EXCEL BEST PRACTICES Participate in an Interactive Evolving Survey using xml/web services Email Name (optional) Years of experience using Excel
4
thomas@evolvingtech.com
Rate your spreadsheet skill level Intermediate Frequency of usage
1-2 hrs per week
No information or request can be pressing 'Connect'. Data supplied verified for accuracy or correctn
Frequency of usage
5% 29% 8% 37%
Your email is used for unique IDs Would you like to receive only and NOT distributed to 3rd update notices for Excel parties. Best Practices?
No Yes
ABSOLUTELY NO NOTICES!
Experience (Yrs)
20.00% 15.00% 10.00% 5.00% 0.00% 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20+
Skill Level
29% 13%
mation or request can be sent without 'Connect'. Data supplied is not for accuracy or correctness.
l hour or less per month 2-3 hrs per month 21% 1-2 hrs per week 3-5 hrs per week More than 5 hrs per week
requency of usage
8% 37%
Skill Level
5% 34% Intermediate 18% Newbie Beginner
EXCEL BEST PRACTICES Response Data from xml data retrieved and used for the charts in the survey
Table 1 Experience (Yrs) 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20+
10.53% 7.89% 2.63% 7.89% 18.42% 2.63% 2.63% 2.63% 2.63% 5.26% 2.63% 2.63% 2.63% 5.26% 2.63% 2.63% 2.63% 2.63% 2.63% 5.26% 5.26%
Table 2 Skill Level Newbie Beginner Intermediate Advanced Super Advanced
5.3% 18.4% 34.2% 13.2% 28.9%
Table 4 Messages Your email is used for unique IDs only and NOT distributed to 3rd parties. Would you like to receive update notices for Excel Best Practices?
Disclaimer
Notices1 Notices2 Notices3 URLName URLAddress Question1 Question2 Question3
EXCEL BEST PRACTICES http://www.evolvingtech.c om/excel Years of experience using Excel Rate your spreadsheet skill level Frequency of usage
Table 3 Frequency of usage l hour or less per month 2-3 hrs per month 1-2 hrs per week 3-5 hrs per week More than 5 hrs per week
7.9% 21.1% 36.8% 28.9% 5.3%
EXCEL BEST PRACTICES Internal Computations used to commonicate with servlet using xml Version Full URL URL base Parameters
1 http://www.evolvingtech.com:8080/ExcelDB/EvolvingSurveyServlet?q1=5&q2=3&q3=3&q http://www.evolvingtech.com:8080/ExcelDB/EvolvingSurveyServlet q1=5&q2=3&q3=3&q4=39619.4476157407&q5=thomas@evolvingtech.com&q6=NONE&q7=1&q8=1 39619.4476157407 thomas@evolvingtech.com 0.18421052 5 1 45 table1 21 Experience (Yrs) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20+ table1 21 Experience (Yrs) 0.10526316 0.078947365 0.02631579 0.078947365 0.18421052 0.02631579 0.02631579 0.02631579 0.02631579 0.05263158 0.02631579 0.02631579 0.02631579 0.05263158 0.02631579 0.02631579 0.02631579 0.02631579 0.02631579 0.05263158 0.05263158 5 2 45
descr 4 value column offset row start
tab0 table1 table1 table1 table1 table1 table1 table1 table1 table1 table1
name Experience (Yrs) 0 1 2 3 4 5 6 7 8
value decimal value 0.10526316 0.078947365 0.02631579 0.078947365 0.18421052 0.02631579 0.02631579 0.02631579 0.02631579
table1 table1 table1 table1 table1 table1 table1 table1 table1 table1 table1 table1 table2 table2 table2 table2 table2 table2 table3 table3 table3 table3 table3 table3 table4
9 10 11 12 13 14 15 16 17 18 19 20+ Skill Level Newbie Beginner Intermediate Advanced Super Advanced Frequency of usage l hour or less per month 2-3 hrs per month 1-2 hrs per week 3-5 hrs per week More than 5 hrs per week Messages
table4
Disclaimer
table4 table4 table4 table4 table4 table4 table4 table4 table5 table5 table5
Notices1 Notices2 Notices3 URLName URLAddress Question1 Question2 Question3 Privacy 1 2
0.05263158 0.02631579 0.02631579 0.02631579 0.05263158 0.02631579 0.02631579 0.02631579 0.02631579 0.02631579 0.05263158 0.05263158 decimal value 0.05263158 0.18421052 0.34210527 0.13157895 0.28947368 decimal value 0.078947365 0.21052632 0.36842105 0.28947368 0.05263158 Text labels Your email is used for unique IDs only and NOT distributed to 3rd parties. Would you like to receive update notices for Excel Best Practices?
EXCEL BEST PRACTICES http://www.evolvingtech.com/e xcel Years of experience using Excel Rate your spreadsheet skill level Frequency of usage Text labels ABSOLUTELY NO NOTICES! Inform Me of Book Updates
ingSurveyServlet?q1=5&q2=3&q3=3&q4=39619.4476157407&q5=thomas@evolvingtech.com&q6=NONE&q7=1&q8=1 ingSurveyServlet volvingtech.com&q6=NONE&q7=1&q8=1 NONE Intermediate 3 1 67 table2 5 Skill Level Newbie Beginner Intermediate Advanced Super Advanced 0.34210527 3 2 67 table2 5 Skill Level 0.05263158 0.18421052 0.34210527 0.13157895 0.28947368 1-2 hrs per week 3 1 73 table3 5 Frequency of usage l hour or less per month 2-3 hrs per month 1-2 hrs per week 3-5 hrs per week More than 5 hrs per week 0.36842105 3 2 73 1 1 1 89
table3 table5 5 2 Frequency of usage Privacy 0.078947365 1 0.21052632 2 0.36842105 0.28947368 0.05263158
relative position row Column1 offset 0 45 1 46 2 47 3 48 4 49 5 50 6 51 7 52 8 53 9 54
col offset 0 0 0 0 0 0 0 0 0 0
10 11 12 13 14 15 16 17 18 19 20 21 0 1 2 3 4 5 0 1 2 3 4 5 0
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1
80
0
2 3 4 5 6 7 8 9 0 1 2
81 82 83 84 85 86 87 88 89 90 91
0 0 0 0 0 0 0 0 0 0 0
6=NONE&q7=1&q8=1
ABSOLUTELY NO NOTICES!
Disclaimer Your email is used for unique IDs only and NOT distribut 1 1 1 2 1 2 89 79 79
table5 table4 table4 2 9 9 Privacy Messages Messages ABSOLUTELY NO NOTICES! Disclaimer Your email is used for unique IDs only and NOT distribut Inform Me of Book Updates Notices1 Would you like to receive update notices for Excel Best Notices2 0 Notices3 0 URLName EXCEL BEST PRACTICES URLAddress http://www.evolvingtech.com/excel Question1 Years of experience using Excel Question2 Rate your spreadsheet skill level Question3 Frequency of usage
nly and NOT distributed to 3rd parties.
nly and NOT distributed to 3rd parties. tices for Excel Best Practices?
Legal Matter Copyright 2003, Evolving Technologies Corporation. All rights reserved. Disclaimer Wiley Publications, Inc., Evolving Technologies Corporation and the author are supplying these spreadsheets "as-is" without any warranty of any kind. Wiley Publications, Inc., Evolving Technologies Corporation and the author make no assertions about the correctness, efficacy, or safety in your use of these spreadsheets and files supplied with this book and disclaim any direct, consequential or incidental responsibility, liability or obligation in connection with the use of such materials. Evolving Technologies Corporation Software User Agreement 30th June, 2003 EVOLVING TECHNOLOGIES CORPORATION (hereinafter "ETC") MAKES AVAILABLE SOFTWARE, DOCUMENTATION, INFORMATION AND/OR OTHER MATERIALS FOR OPEN SOURCE PROJECTS (COLLECTIVELY "CONTENT"). USE OF THE CONTENT IS GOVERNED BY THE TERMS AND CONDITIONS OF THIS AGREEMENT AND/OR THE TERMS AND CONDITIONS OF LICENSE AGREEMENTS OR NOTICES INDICATED OR REFERENCED BELOW. BY USING THE CONTENT, YOU AGREE THAT YOUR USE OF THE CONTENT IS GOVERNED BY THIS AGREEMENT AND/OR THE TERMS AND CONDITIONS OF ANY APPLICABLE LICENSE AGREEMENTS OR NOTICES INDICATED OR REFERENCED BELOW. IF YOU DO NOT AGREE TO THE TERMS AND CONDITIONS OF THIS AGREEMENT AND THE TERMS AND CONDITIONS OF ANY APPLICABLE LICENSE AGREEMENTS OR NOTICES INDICATED OR REFERENCED BELOW, THEN YOU MAY NOT USE THE CONTENT. Unless otherwise indicated, all Content made available by ETC is provided to you under the terms and conditions of the Common Public License Version 1.0 ("CPL"). A copy of the CPL is provided with this Content and is also available at http://www.eclipse.org/legal/cpl-v10.html. For purposes of the CPL, "Program" will mean the Content. Content includes, but is not limited to, source code, object code, documentation and other files maintained by ETC. Content containing Copyright Notices are not to be altered or removed. Content may contain encryption software. The country in which you are currently may have restrictions on the import, possession, and use, and/or re-export to another country, of encryption software. BEFORE using any encryption software, please check the country's laws, regulations and policies concerning the import, possession, or use, and re-export of encryption software, to see if this is permitted.