{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Handout-Income & Education","Demo","User Interface","Class Schedule","Shortcut Keys","Cut & Paste","File Extensions","Exercise-Maine Demographic","Excercise-Expenses","References","Customize Toolbar","Cell Errors","Moon","Functions","That's Special","Wheel","Rows & Columns","Calculator","Sheet1"],"not_rendered":{"charts":2,"images":52,"macros":1,"external_links":1,"defined_names":204,"comments":7,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Handout-Income & Education","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,1,8,2],[8,4,8,5],[31,1,31,5]]}
[]
["Name","Merrymeeting Adult Education",null,null,"Instructor:","Kevin Kilborn"]
["Class","Introduction to Excel",null,null,"Date:","2009-06-15"]
[]
["Exercise","Homework"]
["PURPOSE:","Use link to gather 2000 graduate statistics by county."]
[null,"Provide chart(s) and/or calculations to support the conclusion that income is improved by a degree."]
[]
[null,null,null,null,"Ranking"]
[null,"County","Income","College Graduates","Income","Graduate"]
[null,"Cumberland",47182.952380952382]
[null,"Sagadahoc",44190.777777777781]
[null,"York",44189.2]
[null,"Androscoggin",42466.083333333336]
[null,"Kennebec",39325]
[null,"Lincoln",39184.866666666669]
[null,"Knox",37983.071428571428]
[null,"Hancock",35937.75]
[null,"Oxford",35092.59375]
[null,"Penobscot",34664.461538461539]
[null,"Waldo",33368.434782608696]
[null,"Franklin",31788.285714285714]
[null,"Somerset",30807.695652173912]
[null,"Aroostook",28149.046511627908]
[null,"Piscataquis",27991.625]
[null,"Washington",27590.526315789473]
[]
[null,"Highest:",{"$f":"MAX(C11:C27)","v":47182.952380952382},{"$f":"MAX(D11:D26)","v":0}]
[null,"Lowest:",{"$f":"MIN(C11:C27)","v":27590.526315789473},{"$f":"MIN(D11:D26)","v":0}]
[]
[]
["Link","http://www.ers.usda.gov/Data/Education/EducListpct4.asp?st=ME&view=Percent&longname=Maine"]
[]
[null,"*Optionally rank each category will provide a different perspective when charting."]

{"sheet":"Demo","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,1,6,5],[25,1,25,2],[16,1,19,5]]}
[]
[null,"MS Excel 2007-Introduction"]
[]
[null,"Want to learn spreadsheet magic? Students will learn Excel basics, entering and modifying data, navigating, moving, copying, formatting and printing. Students also learn to use formulas and functions. Come and learn some tricks to make the program easier."]
[]
[]
[]
[]
[null,"Class 1","Class 2","Class 3"]
[null,"Absolute vs. Relative","Charting","Data Integrity"]
[null,"Autofill - Summing","Copy and Paste","Functions & Formulas"]
[null,"Entering Data","Customizing Toolbar","Protecting Workbooks"]
[null,"Navigating","Data Sources","Resolving Errors"]
[null,"Printing","Verifying Data","Sharing Workbooks"]
[null,"User Interface","Vlookup"]
[]
[null,"In the realm of accounting jargon a \"spread sheet\" or spreadsheet was and is a large sheet of paper with columns and rows that organizes data about transactions for a business person to examine. It spreads or shows all of the costs, income, taxes, and other related data on a single sheet of paper for a manager to examine when making a decision."]
[]
[]
[]
[null,"http://dssresources.com/history/sshistory.html"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Sample: =D3-B13+C13"]
[null,null,null,null,"A","B","C","D"]
[null,null,null,1,"PAYEE","CHECKS","DEPOSITS","BALANCE"]
[null,null,null,2]
[null,null,null,3,null,null,null,545.20000000000005]
[null,null,null,4]
[null,null,null,5,"ELECTRIC",14.95]
[null,null,null,6,"OIL",102.15]
[null,null,null,7,"PHONE",36.799999999999997]
[null,null,null,8,"DENTIST",42]
[null,null,null,9,"SALARY",null,395]
[null,null,null,10,"RENT",350]
[null,null,null,11,"GAS CARD",12.93]
[null,null,null,12]
[null,null,null,13,"TOTALS",{"$f":"SUM(F35:F41)","v":558.82999999999993},{"$f":"SUM(G35:G41)","v":395},{"$f":"H33-F43+G43","v":381.37000000000012}]

{"sheet":"User Interface","index":2,"n_rows":57,"n_cols":40,"rows_kept":57,"cut":false,"hidden":false,"merged":[[27,32,27,33],[3,18,3,19],[0,0,1,16]]}
["User Interface"]
[]
[]
[]
[]
[]
[null,null,"Page Break. Page break view, shows where the pages end."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column9","Column1","Column2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quick Access Toolbar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Save"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Undo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customize Toolbar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimize"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximize"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Close"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ribbon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Layout"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Review"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dialog Box Launcher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workspace"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rows"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Columns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formula Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name Box"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert Function"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formula Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Tabs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Navigation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Names"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert Worksheet"]
[null,"The office button contains much of the same functionality previously found under file.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scroll"]
[null,"Customizable tools used frequently.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status"]
[null,"Displays the name of the file, also known as the workbook.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Macro Notification"]
[null,"Minimize, maximize or close the window.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previews"]
[null,"The Ribbon is a new feature with Office 2007 and adds more power and intuitiveness to option selection.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal"]
[null,"Contains the name of the cell or range name.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Layouts"]
[null,"Contains the formula or the constant (text data), being edited.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Break"]
[null,"Is noted by the highligted box.  One or many cells or ranges may be selected at once.  Use the combinations of Shift, Control, and Alt Keys along with mouse dragging.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zoom"]
[null,"Columns refer to the vertical axis of the spreadsheet."]
[null,"Selects all rows and columns."]
[null,"Rows refer to the horizonal axis of the spreadsheet."]
[null,"Shows the current status."]
[null,"Provides navigation among worksheets. Allows you to add, delete, rename and move worksheets."]
[null,"Shows three distinct views, normal, page layout and page preview"]
[null,"Change the magnification of the worksheet"]
[null,"Vertical scroll, click the little arrow, click in the scroll bar, or grab the slider and drag it."]
[null,"Horizontal scroll, click the little arrow, click in the scroll bar, or grab the slider and drag it."]

{"sheet":"Class Schedule","index":3,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[34,9,55,9],[47,2,47,7],[48,2,48,7],[7,9,16,9],[32,2,32,7],[33,2,33,7],[19,2,19,7],[27,2,27,7],[20,2,20,7],[31,2,31,7],[55,2,55,7],[54,2,54,7],[44,2,44,7],[35,2,35,7],[36,2,36,7],[37,2,37,7],[3,1,3,3],[26,2,26,7],[28,2,28,4],[29,2,29,4],[21,2,21,7],[22,2,22,7],[24,2,24,7],[2,1,2,3],[5,2,5,7],[6,2,6,7],[13,2,13,7],[23,2,23,7],[10,2,10,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[11,2,11,7],[12,2,12,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[4,2,4,7],[18,2,18,7],[45,2,45,7],[49,2,49,7],[51,2,51,7],[52,2,52,7],[53,2,53,7],[50,2,50,7],[34,2,34,7],[39,2,39,7],[43,2,43,7],[41,2,41,7],[38,2,38,7],[40,2,40,7],[42,2,42,7]]}
["√",null,null,{"$f":"NOW()","v":40000.691030324073},null,"Class Number:",5]
[null,"Topic:","Review Homework. Information is contained in separate sources."]
[null,"Merrymeeting Adult Education",null,null," ","Instructor: Kevin Kilborn"]
[null,"MS Excel 2007-Introduction",null,null,null,"2009-06-15","→","2009-06-29"]
[null,"Resource","http://home.comcast.net/~kevinkilborn/Great Oaks/MAE/Downloads.aspx"]
[null,"Class 1","2009-06-15"]
[null,"~Time","Plan - Monthly Expenses"]
["√","06:00:00","What is Excel Magic (Introductions)\nExercise Circa 1980",null,null,null,null,null,null,"Short Cut Keys"]
["√","06:45:00","User Interface: Differences 2003-2007; \nShort Cut Keys, F1 Help. "]
["√",null,"New Spreadsheet (Office Button); Templates\nJust a calculator"]
["√","07:00:00","Exercise: Moving/Copying"]
["√",null,"Exercise: Editing:  Rows & Columns: Size, Titles,\n Sum, Navigating "]
["√","07:30:00","Break"]
["√","07:45:00","Customize:  Quick Access Toolbar\n (Spelling & Show Formulas)"]
["√","08:00:00","Exercise:  Monthly Budget, Summing,\nFormatting and Printing"]
["√","07:45:00","Format & Print: Styles, Live Preview, Page Layout\n {Headers, Footers & Page Breaks}"]
[null,"Homework","http://office.microsoft.com/training/training.aspx?AssetID=RP100620721033&CTT=6&Origin=RC100620751033"]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Class 2","2009-06-22"]
[null,"~Time","Plan - Maine Towns & Counties"]
["√","06:00:00","Exercise:  Monthly Expenses\nFormatting and Printing"]
[null,"06:30:00","Relative & Absolute References"]
[null,"07:15:00","Exercise: Use a Table,  enter data,\nproof it, format, sum rows insert graphic."]
[null,null,"Exercise: Configure Voice Proofing {Text to Speech F1},\n Spell Checker, Show Formulas. Proof your data."]
[null,"07:30:00","Break"]
[null,"07:45:00","Data Source Options:   Manually, \nCopying {Paste Special},  Data Sources"]
[null,"08:45:00","Homework: Is there a correlation between, \ncreate a chart(s) to demonstrate your findings.\neducation and salary?"]
[null,"Homework","http://www.ers.usda.gov/Data/Education/EducListpct4.asp?st=ME&view=Percent&longname=Maine"]
[null,"Video","http://office.microsoft.com/training/training.aspx?AssetID=RC101757361033&CTT=6&Origin=RP101757341033"]
[]
[]
[null,"Class 3","2009-06-29"]
[null,"~Time","Plan - Functions, Fun & Protection"]
["√","06:00:00","Review Homework",null,null,null,null,null,null,"Formulas & Functions"]
[null,null,"Exercise: Copy From Maine Towns File"]
[null,null,"1) What is the average income by county?\n2) How many towns in each county?"]
[null,null,"3) What town has the highest income? \n4) Which town has the smallest income?"]
[null,null,"Step: Chart % Average Income by county."]
[null,null,"Exercise: Copy & Paste, vLookup"]
[null,"07:30:00","Break"]
[null,"07:45:00","Exercise:  Open Maine Demographics.xls\n and answer these questions: \nWhat's the smallest town?\nWhat's the average population per municipality"]
[null,null,"1. What is the population of the largest town? \n2. What is the smallest town?"]
[null,null,"3. What is the average population for towns in Maine?"]
[null,null,"Demostrate: Combine Income with Population Data"]
[null,null,"Exercise: Excel as a calculator"]
[null,"Extra"]
[null,null,"Exercise: Arithmetic functions, \noperator precedence ((Use Parenthesis))"]
[null,null,"Exercise: Date functions"]
[null,null,"Exercise: String functions to join (concatenate) \nand separate (parse) data."]
[null,null,"Costly Mistakes"]
[null,null,"Extra"]
[null,null,"Using Macros"]
[null,null,"Exercise: Determine the days with a Full Moon for 2010"]
[null,null,"Exercise: Numerology "]
[null,null,"Exercise: Resolve errors, Tracing"]

{"sheet":"Shortcut Keys","index":4,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"ShortCut and HotKeys"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type","Function","Keys"]
[null,"Data","Text Import","Alt;A+F+T"]
[null,"Data","Web Import","Alt;A+F+W"]
[null,"Edit","Select all","Alt+A"]
[null,"Edit","Inserts a carriage return","Alt+Enter"]
[null,"Edit","Copy selection","Ctrl+C"]
[null,"Edit","Paste buffer","Ctrl+V"]
[null,"Edit","Cut selection","Ctrl+X"]
[null,"Edit","Last character in selection","End"]
[null,"Edit","First character in selection","Home"]
[null,"Error","Trace dependents","ALT;M+D"]
[null,"Error","Trace precedents","Alt;M+P"]
[null,"Format","Bold face","Ctrl+B"]
[null,"Format","Print Preview","Ctrl+F2"]
[null,"Format","Italics","Ctrl+I"]
[null,"Format","Underline","Ctrl+U"]
[null,"Navigate","End of Document","Ctrl+End"]
[null,"Navigate","Top of Document","Ctrl+Home"]
[null,"Navigate","Down","Down Arrow"]
[null,"Navigate","Down","Enter"]
[null,"Navigate","Right","Right Arrow"]
[null,"Navigate","Up","Shift+Enter"]
[null,"Navigate","Left","Shift+Tab"]
[null,"Navigate","Right","Tab"]
[null,"Navigate","UP","Up Arrow"]
[null,"Ribbon","Switch between Tabs Press alt release & press first letter of tab","Alt; H"]
[null,"Ribbon","Autosize Rows","Alt;H+O+A"]
[null,"Ribbon","Autosize Columns","Alt;H+O+I"]
[null,"Ribbon","Show all comments","Alt;R+A"]
[null,"Ribbon","Split window into panes","Alt;W+S"]
[null,"Ribbon","Minimize/Maximize Ribbon","Ctrl+F1"]
[null,"Ribbon","Help","F1"]
[null,"Search","Find Text","Ctrl+F"]
[null,"Search","Goto specific cell or range name","Ctrl+G"]
[null,"Navigate","Left","Left Arrow"]

{"sheet":"Cut & Paste","index":5,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,3,10,4],[2,0,3,4]]}
[]
[]
["Moving & Copying Data, Cells, Formats and Columns\nCopy an answer into the column for each answer"]
[]
["Right-Click"]
[null,null,"Choices"]
[null,null,"A. Messy And Confusing Repeated Operation."]
[null,null,"A. In order to make word processors appear to be bug-free in comparison."]
[null,null,"A. \"Would you like fries with that?\""]
[null,null,"A. To make Excel seem faster."]
[null,null,"A. One - But only if \"light bulbs\" can be found in the Microsoft Knowledge Base.","KeyBoard ShortCuts"]
[null,null,"A. He looks at your shoes when he talks to you.","Ctrl-C","Copy"]
[null,null,"A. Oil of OLE.","Ctrl-X","Cut"]
[null,null,null,"Ctrl-V","Paste"]
[]
["Question","Match","Answer","Result","Comment"]
["Q. Why did Microsoft develop Access?","A. To make Excel seem faster.",null,{"$f":"IF(B17=C17,\"Correct\",\"Incorrect\")","v":"Incorrect"},{"$f":"IF(D17=\"Correct\",\"Techniques that increase Excel performance\",\"\")","v":""}]
["Q. How do you identify an extroverted spreadsheet user?","A. He looks at your shoes when he talks to you.",null,{"$f":"IF(B18=C18,\"Correct\",\"Incorrect\")","v":"Incorrect"},{"$f":"IF(D18=\"Correct\",\"This can get consuming\",\"\")","v":""}]
["Q. What does MACRO stand for?","A. Messy And Confusing Repeated Operation.",null,"Incorrect",{"$f":"IF(D19=\"Correct\",\"Macros are powerful but it's easy to loose track\",\"\")","v":""}]
["Q. What's the name of the new skin care product that Procter & Gamble has developed for MS Office VBA developers?","A. Oil of OLE.","A. Oil of OLE.","Correct",{"$f":"IF(D20=\"Correct\",\"Exchange data between Office Products\",\"\")","v":"Exchange data between Office Products"}]
["Q. How many Excel Tech Support technicians does it take to change a light bulb?","A. One - But only if \"light bulbs\" can be found in the Microsoft Knowledge Base.",null,"Incorrect",{"$f":"IF(D21=\"Correct\",\"F1 (Help) & Google\",\"\")","v":""}]
["Q. Why were spreadsheets invented?","A. In order to make word processors appear to be bug-free in comparison.",null,"Incorrect",{"$f":"IF(D22=\"Correct\",\"A Huge Time Savings\",\"\")","v":""}]
["Q. What is the most frequent question asked by a would-be spreadsheet consultant?","A. \"Would you like fries with that?\"",null,"Incorrect",{"$f":"IF(D23=\"Correct\",\"Doesn't this seem easy?\",\"\")","v":""}]

{"sheet":"File Extensions","index":6,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,1,3]]}
[null,"File Extensions"]
[]
["Occurrence","Format","Extension","Description"]
["High","Excel Workbook",".xlsx","The default Office Excel 2007 XML-based file format. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm)."]
["High","Excel Workbook (code)",".xlsm","The Office Excel 2007 XML-based and macro-enabled file format. Stores VBA macro code or Excel 4.0 macro sheets (.xlm)."]
["Low","Excel Binary Workbook",".xlsb","The Office Excel 2007 Binary file format (BIFF12)."]
["High","Template",".xltx","The default Office Excel 2007 file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm)."]
["Medium","Template (code)",".xltm","The Office Excel 2007 macro-enabled file format for an Excel template. Stores VBA macro code or Excel 4.0 macro sheets (.xlm)."]
["High","Excel 97- Excel 2003 Workbook",".xls","The Excel 97 - Excel 2003 Binary file format (BIFF8)."]
["Medium","Excel 97- Excel 2003 Template",".xlt","The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template."]
["Low","Microsoft Excel 5.0/95 Workbook",".xls","The Excel 5.0/95 Binary file format (BIFF5)."]
["Medium","XML Spreadsheet 2003",".xml","XML Spreadsheet 2003 file format (XMLSS)."]
["Data","XML Data",".xml","XML Data format."]
["Low","Excel Add-In",".xlam","The Office Excel 2007 XML-based and macro-enabled Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm)."]
["Low","Excel 97-2003 Add-In",".xla","The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects."]
["Low","Excel 4.0 Workbook",".xlw","An Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. You can open a workbook in this file format in Office Excel 2007, but you cannot save an Excel file to this file format."]
["Low","Formatted Text (Space-delimited)",".prn","Lotus space-delimited format. Saves only the active sheet."]
["Data","Text (MS-DOS)",".txt","Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet."]
["Low","Unicode Text",".txt","Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium."]
["Data","CSV (comma delimited)",".csv","Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet."]
["Data","DIF",".dif","Data Interchange Format. Saves only the active sheet."]
["Low","SYLK",".slk","Symbolic Link Format. Saves only the active sheet."]
["Database",null,"db","Access, Oracle, SQL/Server, etc."]
["Data","XLSX",".xlsx","Excel file type"]

{"sheet":"Exercise-Maine Demographic","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,2],[0,0,0,4]]}
["Maine Demographics"]
["June 2006"]
["Yes"]
["Town","Type","County","Population","Income"]
["Cambridge","Town"," Somerset",530,28516]
["Eastbrook","Town"," Hancock",364,31667]
["Fryburg","Town"," Oxford",3326,34333]
["Kingfield","Town"," Franklin",1148,29250]
["Minot","Town"," Androscoggin",2866,47557]
["Wilton","City"," Franklin",4200,34562]
[null,null,null,{"$f":"SUBTOTAL(109,[Population])","v":12434},{"$f":"SUBTOTAL(101,[Income])","v":34314.166666666664}]

{"sheet":"Excercise-Expenses","index":8,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[3,2,3,3],[3,8,3,10],[49,1,50,10],[51,2,51,3],[51,8,51,10],[12,8,12,10],[13,8,13,10],[8,8,8,10],[5,8,5,10],[4,8,4,10],[61,8,61,10],[52,8,52,10],[53,8,53,10],[56,8,56,10],[60,8,60,10]]}
[]
[null,"Monthly Household Budget for 2009 "]
[]
[null,null,"Pro-Rata"]
[null,"Category","Self","Spouse","Combined"]
[null,"Insurance (Life & Car)",85,90,{"$f":"SUM(C6:D6)","v":175}]
[null,"Clothing",50,75,125,null,"Exercise 1"]
[null,"CMP",100,0,100]
[null,"Gasoline",55,150,205,null,"Exercise 2"]
[null,"Grocery ",200,400,600]
[null,"Heating Oil",125,null,125]
[null,"Memberships",0,71,71]
[null,"Mortgage/Rent",1000,0,1000]
[null,"Spending Money",100,0,100]
[null,"Verizon Landline",60,0,60]
[null,"Wireless",70,70,140]
[]
[]
[]
[]
[]
[null,"Expenses:",{"$f":"SUM(C6:C21)","v":1845},{"$f":"SUM(D6:D21)","v":856},{"$f":"SUM(C22:D22)","v":2701}]
[]
[null,"Gross Income",45000,20000,{"$f":"SUM(C24:D24)","v":65000}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Move to Cell:","e10"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Monthly Household Budget for 2009 "]
[]
[null,null,"Pro-Rata",null,null,null,"Color",null,"Yearly Outlook"]
[null,"Category","Self","Spouse","Combined",null,"Legend",null,"Combined Salary"]
[null,"Insurance (Life & Car)",85,90,{"$f":"SUM(C54:D54)","v":175},null,null,null,{"$f":"E72","v":65000}]
[null,"Clothing",50,75,125,null,"Exercise 1"]
[null,"CMP",100,0,100]
[null,"Gasoline",55,150,205,null,"Exercise 2",null,"Payroll Deductions"]
[null,"Grocery ",200,400,600,null,null,null,"Health Ins","401K","20% Tax"]
[null,"Heating Oil",125,null,125,null,"AutoSum",null,{"$f":"300*12","v":3600},{"$f":"(C70*0.1)*12","v":2214},{"$f":"I54*0.2","v":13000}]
[null,"Memberships",0,71,71]
[null,"Mortgage/Rent",1000,0,1000,null,"Ref 2 Cell",null,"Take Home"]
[null,"Spending Money",100,0,100,null,null,null,{"$f":"I54-K59","v":52000}]
[null,"Verizon Landline",60,0,60,null,"Formulas"]
[null,"Wireless",70,70,140,null,null,null,null,"Monthly Exp","Yearly Expenses"]
[null,null,null,null,null,null,"Clear",null,null,{"$f":"E70","v":2701},{"$f":"J65*12","v":32412}]
[]
[null,null,null,null,null,null,null,null,null,"Yearly Take Home","Monthly Surplus"]
[null,null,null,null,null,null,null,null,null,{"$f":"I62-K65","v":19588},{"$f":"J68/12","v":1632.3333333333333}]
[]
[null,"Expenses:",{"$f":"SUM(C54:C69)","v":1845},{"$f":"SUM(D54:D69)","v":856},{"$f":"SUM(C70:D70)","v":2701}]
[]
[null,"Gross Income",45000,20000,{"$f":"SUM(C72:D72)","v":65000}]

{"sheet":"References","index":9,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Subject","Link"]
["2003 Commands in 2007","http://images.amazon.com/media/i3d/01/excel2007tipcard.pdf"]
["Chart","http://office.microsoft.com/training/training.aspx?AssetID=RP101757341033&CTT=6&Origin=RC101757361033"]
["CIO Costly Mistakes","http://www.cio.com/article/131500/Eight_of_the_Worst_Spreadsheet_Blunders?page=2"]
["Copy visible cells only:","http://www.mrexcel.com/articles/excel-copy-subtotals.php"]
["Dates","http://support.microsoft.com/kb/214094"]
["Educational Level","http://www.ers.usda.gov/Data/Education/EducListpct4.asp?st=ME&view=Percent&longname=Maine"]
["Household Formulas","http://www.debtsmart.com/cgi-pl/article.cgi?cmd=category&cat=Household%20Math&page=1"]
["MACRO recommendations","http://www.financialmodelingguide.com/analytical-tools/excel-vba-macro/"]
["Maine Population","http://quickfacts.census.gov/qfd/states/23/23001.html"]
["Mouse Pointers","http://tipsfromdoris.net/index.php?option=com_content&task=view&id=36&Itemid=55"]
["Office Product Connectivity","http://download.microsoft.com/download/8/9/5/89585721-4774-4b5e-856b-c9db5d2980b3/Data_Integration_Fact_Sheet.pdf"]
["Operators and Precedence","http://office.microsoft.com/en-us/excel/HP100788861033.aspx"]
["Performance Tuning","http://msdn.microsoft.com/en-us/library/aa730921.aspx"]
["Quick Reference","http://www.customguide.com/pdf/excel-quick-reference-2007.pdf"]
["Recording a Macro","http://www.dummies.com/how-to/content/how-to-record-a-macro-in-excel-2007.html"]
["Shortcut & HotKeys","http://www.lboro.ac.uk/it/access/excel2007-shortcuts.html"]
["Tour of Windows XP","http://www.microsoft.com/windowsxp/pro/evaluation/tours/tour.mspx"]
["Training","http://www.bilkent.edu.tr/~ozgu/CS121WEB/word1.htm"]
["Typing Tutor","http://www.typingweb.com/tutor/"]
["VisiCalc","http://www.bricklin.com/history/intro.htm"]
["Vlookup","http://www.ozgrid.com/Excel/excel-vlookup-formula.htm"]

{"sheet":"Customize Toolbar","index":10,"n_rows":50,"n_cols":40,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,32],[29,32,29,33]]}
["Customizing the Toolbar"]
[]
[null,null,null,null,null,null,null,"Spelling",null,null,null,null,"Formulas",null,null,null,null,"Speech"]
[]
[]
[]
[]
[null,null,"Page Break. Page break view, shows where the pages end."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column9","Column1","Column2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quick Access Toolbar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Save"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Undo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customize Toolbar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimize"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximize"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Close"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ribbon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Layout"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Review"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"View"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dialog Box Launcher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workspace"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rows"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Columns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formula Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name Box"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert Function"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formula Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Tabs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Navigation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Names"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scroll"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Macro Notification"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previews"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Layouts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Break"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zoom"]
[null,null,"Macro Notification. Control macros from here or the developer's tab."]

{"sheet":"Cell Errors","index":11,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,4,1,5],[1,7,1,8]]}
[null,null,null,"Split"]
["Error Value","Meaning","Causes"]
["#DIV/0","Division by Zero","Division is occuring on 0 or blank.",null,"County","Income","College Graduates","Delta","County Rank","Std. Deviation",null,"Rank"]
[{"$error":"#N/A"},"No value available","Don't yet have the necessary information.",null,"Cumberland",37746.361904761907,45295.634285714288,{"$f":"G4-F4","v":7549.2723809523814},{"$f":"VLOOKUP(E4,$L$4:$M$17,2,FALSE)","v":5},{"$f":"STDEV(G4,NationalAverage)","v":{"$error":"#REF!"}},null,"Androscoggin",3]
[{"$error":"#NAME?"},"Excel doesn't recognize a name","Incorrect range name",null,"Sagadahoc",35352.622222222228,42423.146666666675,{"$f":"G5-F5","v":7070.524444444447},{"$f":"VLOOKUP(E5,$L$4:$M$17,2,FALSE)","v":15},{"$error":"#REF!"},null,"Aroostook",2]
[{"$error":"#NULL!"},"You specified an intersection of two cells ranges whose cells don't actually intersect","A space was placed in a functions arguments.",null,"York",35351.360000000001,42421.631999999998,7070.2719999999972,{"$error":"#N/A"},{"$error":"#REF!"},null,"Cumberland",5]
[{"$error":"#NUM!"},"Problems with a number in the formula","Number is too large or an invalid argument in a function.",null,"Androscoggin",33972.866666666669,40767.440000000002,{"$f":"AH7-F7","v":-33972.866666666669},3,{"$error":"#REF!"},null,"Franklin",4]
[{"$error":"#REF!"},"Invalid cell reference","Occurs when a cell is deleted after it was referenced.",null,"Kennebec",31460,37752,6292,1,{"$error":"#REF!"},null,"Kennebec",1]
[{"$error":"#VALUE!"},"Wrong type of arguments in a function or wrong type of operator","Trying to do a math function on text values.",null,"Lincoln",31347.893333333337,37617.472000000002,6269.5786666666645,7,{"$error":"#REF!"},null,"Knox",6]
[null,null,null,null,"Knox",30386.457142857143,36463.748571428572,{"$f":"E10-F10","v":{"$error":"#VALUE!"}},6,{"$error":"#REF!"},null,"Lincoln",7]
[null,null,null,null,"Hancock",28750.2,34500.239999999998,{"$f":"G11-F11","v":5750.0399999999972},{"$error":"#N/A"},{"$error":"#REF!"},null,"Oxford",9]
[null,"Masking Errors",null,null,"Oxford",28074.075000000001,33688.89,5614.8149999999987,9,{"$error":"#REF!"},null,"Penobscot",10]
[null,"ISBLANK",null,null,"Penobscot",27731.569230769233,33277.883076923077,5546.3138461538438,10,{"$error":"#REF!"},null,"Piscataquis",12]
[null,"ISERR",null,null,"Waldo",26694.747826086958,32033.697391304348,5338.94956521739,13,{"$error":"#REF!"},null,"Sagadahoc",15]
[null,"ISERROR",null,null,"Franklin",25430.628571428573,30516.754285714287,5086.1257142857139,4,{"$error":"#REF!"},null,"Somerset",8]
[null,"ISLOGICAL",null,null,"Somerset",24646.156521739133,"29575.387826087",4929.231304347868,8,{"$error":"#REF!"},null,"Waldo",13]
[null,"ISNA",null,null,"Aroostook",22519.23720930233,27023.084651162793,{"$f":"G17 F17","v":{"$error":"#NULL!"}},2,{"$error":"#REF!"},null,"Washington",11]
[null,"ISNONTEXT",null,null,"Piscataquis",22393.300000000003,26871.960000000003,4478.66,12,{"$error":"#REF!"},null,"York",14]
[null,"ISNUMBER",null,null,"Washington",22072.42105263158,26486.905263157896,4414.484210526316,11,{"$error":"#REF!"}]
[null,"ISREF"]
[null,"ISTEXT",null,null,"Highest:",{"$f":"MAX(RangeIncome)","v":{"$error":"#NAME?"}},{"$f":"MAX(G4:G19)","v":45295.634285714288},{"$f":"MEDIAN(G21)","v":45295.634285714288},{"$f":"SUM(I4:I19)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Lowest:",{"$f":"MIN(F4:F20)","v":22072.42105263158},{"$f":"MIN(G4:G19)","v":26486.905263157896},{"$f":"MIN(H4:H19)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Average:",{"$f":"SUM(F4:F19)/0","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G4:G19)","v":35142.6992128048},{"$f":"SUM(H4:H20)/COUNT(H4:H19)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"National Average:"]

{"sheet":"Moon","index":12,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"http://aa.usno.navy.mil/cgi-bin/aa_moonphases.pl?year=2009&ZZZ=END"]
[null,"Select Range, Convert Text to Columns"]
[null,"Delete all data not pertaining to Full Moon, Delete  Hours and Minutes of Full Moon"]
[null,"Concatenate Month and Day"]
[null,"Select all Dates and copy values only"]
[null,"Format to Date Column (Month, Day and add 2009)"]
[null,"Determine the days nn.nn of the moon's cycle."]
[null,"Average"]
[]
[]
[null,"Day","Hour","Minutes"]
["Jan",11,3,27,null,{"$f":"A15 & \" \" &B15& \", 2009 \" & C15 & \":\" &D15","v":"Jan 11, 2009 3:27"},{"$f":"ROUND(F16-F15,2)","v":29.47}]
["Feb",9,14,49,null,{"$f":"A16 & \" \" &B16& \", 2009 \" & C16 & \":\" &D16","v":"Feb 9, 2009 14:49"},{"$f":"ROUND(F17-F16,2)","v":29.49}]
["Mar",11,2,38,null,"Mar 11, 2009 2:38",29.51]
["Apr",9,14,56,null,"Apr 9, 2009 14:56",29.55]
["May",9,4,1,null,"May 9, 2009 4:1",29.59]
["Jun",7,18,12,null,"Jun 7, 2009 18:12",29.63]
["Jul",7,9,21,null,"Jul 7, 2009 9:21",29.65]
["Aug",6,0,55,null,"Aug 6, 2009 0:55",29.63]
["Sep",4,16,3,null,"Sep 4, 2009 16:3",29.59]
["Oct",4,6,10,null,"Oct 4, 2009 6:10",29.54]
["Nov",2,19,14,null,"Nov 2, 2009 19:14",29.51]
["Dec",2,7,30,null,"Dec 2, 2009 7:30",29.49]
["Dec",31,19,13,null,"Dec 31, 2009 19:13",-40178.800000000003]
[]
[null,null,null,null,null,null,{"$f":"ROUND(AVERAGE(G15:G26),2)","v":29.55}]

{"sheet":"Functions","index":13,"n_rows":139,"n_cols":101,"rows_kept":139,"cut":false,"hidden":false,"merged":[[88,0,88,4],[0,1,1,4],[3,0,3,4],[34,0,34,4],[56,0,56,4],[73,0,73,4],[7,0,10,1]]}
[null,"Formulas and Functions"]
[]
[]
["Arithmetic"]
["Prime Numbers","Seed",10]
[{"$f":"COLUMN()","v":1},{"$f":"IF(COLUMN() <= PrimeSeed,COLUMN(),\"\")","v":2},3,4,5,6,7,8,9,10,"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COLUMN() <= PrimeSeed,COLUMN(),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COLUMN() <= PrimeSeed,COLUMN(),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IFERROR(IF(IsPrime(B6),\"prime\",\"\"),\"\")","v":"prime"},{"$f":"IFERROR(IF(IsPrime(C6),\"prime\",\"\"),\"\")","v":"prime"},"","prime","","prime","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(IF(IsPrime(BO6),\"prime\",\"\"),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"ListPrimes(PrimeSeed)","v":"2, 3, 5, 7, "},null,null,{"$f":"IF(D$6=2,\"Prime\",IF(AND((MOD(D$6,ROW(INDIRECT(\"2:\"&ROUNDUP(SQRT(D$6),0))))<>0))=TRUE,\"Prime\",\"\"))","v":""},null,"",null,"","Prime"]
[null,null,null,null,null,null,null,null,{"$f":"IF(MIN(MOD($I$6,ROW(INDIRECT(\"2:\"&INT(SQRT($I$6))))))=0,\"not prime\",\"prime\")","v":"prime"}]
[]
[]
[]
[]
["Fibonacci Sequence",5,"Seed",1,"Seed 2",2]
["Result",{"$f":"Seed","v":1},{"$f":"Seed2","v":2},{"$f":"IF(COLUMN()-3<Fibonacci,B15+C15,0)","v":3},5,8,13,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Doubling a Penny",28]
["Result",0.01,{"$f":"B18* 2","v":0.02},{"$f":"IF(COLUMN()-2 < Days,C18* 2,0)","v":0.04},0.08,0.16,0.32,0.64,1.28,2.56,5.12,10.24,20.48,40.96,81.92,163.84,327.68,655.36,1310.72,2621.44,5242.88,10485.76,20971.52,41943.040000000001,83886.080000000002,167772.16,335544.32000000001,671088.64000000001,1342177.28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Circles"]
["Pi",3.1415926000000001]
["Radius",5]
["Area of a Circle",{"$f":"Pi*Radius^2","v":78.539815000000004}]
["Circumference",{"$f":"Pi*Radius*2","v":31.415925999999999}]
[]
[]
["Conversions"]
["1 kilometer",0.62,"miles"]
["1 mile = ",5280,"feet"]
["1 Acre =",43560,"feet"]
[]
["Feet in a 10K Race?",{"$f":"(10*MilesInKilometer)*FeetInMile","v":32736},"feet"]
["How many feet in 4 acres",{"$f":"4*FeetInAcre","v":174240},"feet"]
[]
["Monthly Loan Payments"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"http://www.1728.com/loanform.htm"]
[]
[]
["Loan (L)",15000]
["Months (N)",48]
["Rate (p)",0.05]
["p/1200 (Factor)",{"$f":"(p/1200)*100","v":4.1666666666666675E-3}]
["Monthly Payment",{"$f":"(Factor+Factor/(((1+Factor)^N)-1)) * L","v":345.43940355969659}," - OR -","PMT Function",{"$f":"PMT(Factor,N,L)","v":-345.43940355969659}]
[]
[]
[]
[]
[]
["Mass is Significant but Speed Kills"]
[]
[]
[]
[null,null,null,null,null,"Constants"]
[null,null,null,null,null,0.73756214927700003]
[null,null,null,null,null,0.30480000000000002]
[]
[]
[null,null,"http://www.ajdesigner.com/phpenergykenetic/kenetic_energy_equation.php"]
[null,null,null,null,"Kilograms"]
["Mass (pounds)",2700,"Velocity",20,{"$f":"B68*0.45359237","v":1224.6993990000001}]
["Miles/Hour",20,{"$f":"Velocity+(10*(COLUMN()-2))","v":30},40,50,60,70,80,90,100,110,120,130,140]
["Meters/Second",{"$f":"((B69*5280)/3600) * MeterInAFoot","v":8.9407999999999994},13.411200000000001,17.881599999999999,22.352,26.822400000000002,31.292800000000003,35.763199999999998,40.233600000000003,44.704000000000001,49.174400000000006,53.644800000000004,58.115200000000002,62.585600000000007]
["Pounds of Force ",{"$f":"(0.5*Kilograms * B70^2) * JouleToPounds","v":36103.631719279532},81233.171368378957,144414.52687711813,225647.6982454971,324932.68547351583,442269.48856117442,577658.10750847252,731098.54231541068,902590.7929819884,1092134.8595082064,1299730.7418940633,1525378.4401395605,1769077.9542446977]
[]
[]
["Completion Date of Project"]
["Today:",{"$f":"MONTH(NOW())&\"/\"&DAY(NOW())&\"/\"&YEAR(NOW())","v":"7/6/2009"},null,null,"Holidays"]
["Start:","2009-05-20",null,"Memorial Day","2009-05-20"]
["Day Length",6,null,"July 4th.","2009-07-04"]
["Employees Utilized:",3,null,"Company Picnic","2009-08-10"]
["Estimated Work",400,null,"Labor Day","2009-09-07"]
["Combined Employee Days ",{"$f":"ROUNDUP(B79/(B77*B78),0)","v":23}]
["Actual Date Value:",{"$f":"DATE(YEAR(StartDate),MONTH(StartDate),DAY(StartDate)+Employee_Days)","v":"2009-06-12"}]
["Actual Days",{"$f":"Actual_Date-StartDate","v":23}]
["Work Days:",{"$f":"NETWORKDAYS(StartDate,Actual_Date,Holidays)","v":17}]
["Work Day Value:",{"$f":"Actual_Date + (Actual_Days-Work_Days)","v":39982}]
["Delivery Date",{"$f":"MONTH(B84) & \"/\" & DAY(B84) & \"/\" & YEAR(B84)","v":"6/18/2009"}]
[]
["http://support.microsoft.com/kb/214094"]
[]
["Strings and Things"]
["FirstName","Middle Initial","Last Name","Address1","Address2","City","State","Zip","Prefix"]
["John","S","Smith","15 Maple St.",null,"Brunswick","ME",4011,"MR"]
["Sally","J","Pearson","22 Hope Avenue","Box 302","Portland","ME",4101,"DR"]
["Mark",null,"Sullivan","232 Oak Stret",null,"Freeport","ME",4532,"MR"]
["Bill","P","Silver","17 Pleasant Street","Box 1515","Westbrook","ME",4521,"SIR"]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"TRIM(PROPER($I91) & \" \" & $A91 & \" \" & IF(ISBLANK($B91),$C91, $B91 &\". \" & $C91))","v":"Mr John S. Smith"},{"$f":"TRIM(PROPER(OFFSET($I91,COLUMN()-1,0)) & \" \" & OFFSET($A91,COLUMN()-1,0) & \" \" & IF(ISBLANK(OFFSET($B91,COLUMN()-1,0)),OFFSET($C91,COLUMN()-1,0), OFFSET($B91,COLUMN()-1,0) &\". \" & OFFSET($C91,COLUMN()-1,0)))","v":"Dr Sally J. Pearson"},{"$f":"TRIM(PROPER(OFFSET($I91,COLUMN()-1,0)) & \" \" & OFFSET($A91,COLUMN()-1,0) & \" \" & IF(ISBLANK(OFFSET($B91,COLUMN()-1,0)),OFFSET($C91,COLUMN()-1,0), OFFSET($B91,COLUMN()-1,0) &\". \" & OFFSET($C91,COLUMN()-1,0)))","v":"Mr Mark Sullivan"},"Sir Bill P. Silver","","","","",""]
[{"$f":"$D91","v":"15 Maple St."},{"$f":"OFFSET($D91,COLUMN()-1,0)","v":"22 Hope Avenue"},{"$f":"OFFSET($D91,COLUMN()-1,0)","v":"232 Oak Stret"},{"$f":"OFFSET($D91,COLUMN()-1,0)","v":"17 Pleasant Street"},{"$f":"OFFSET($D91,COLUMN()-1,0)","v":0},0,0,0,0]
[{"$f":"IF(ISBLANK($E91),$F91 & \", \" &  $G91 & \"  \" &  TEXT($H91,\"00000\"),$E91 & CHAR(10) & $F91 & \", \" &  $G91 & \"  \" &  TEXT($H91,\"00000\"))","v":"Brunswick, ME  04011"},{"$f":"IF(ISBLANK(OFFSET($E91,COLUMN()-1,0)),OFFSET($F91,COLUMN()-1,0) & \", \" &  OFFSET($G91,COLUMN()-1,0) & \"  \" &  TEXT(OFFSET($H91,COLUMN()-1,0),\"00000\"),OFFSET($E91,COLUMN()-1,0) )","v":"Box 302"},{"$f":"IF(ISBLANK(OFFSET($E91,COLUMN()-1,0)),OFFSET($F91,COLUMN()-1,0) & \", \" &  OFFSET($G91,COLUMN()-1,0) & \"  \" &  TEXT(OFFSET($H91,COLUMN()-1,0),\"00000\"),OFFSET($E91,COLUMN()-1,0) )","v":"Freeport, ME  04532"},{"$f":"IF(ISBLANK(OFFSET($E91,COLUMN()-1,0)),OFFSET($F91,COLUMN()-1,0) & \", \" &  OFFSET($G91,COLUMN()-1,0) & \"  \" &  TEXT(OFFSET($H91,COLUMN()-1,0),\"00000\"),OFFSET($E91,COLUMN()-1,0) )","v":"Box 1515"},{"$f":"IF(ISBLANK(OFFSET($E91,COLUMN()-1,0)),OFFSET($F91,COLUMN()-1,0) & \", \" &  OFFSET($G91,COLUMN()-1,0) & \"  \" &  TEXT(OFFSET($H91,COLUMN()-1,0),\"00000\"),OFFSET($E91,COLUMN()-1,0) )","v":",   00000"},",   00000",",   00000",",   00000",",   00000"]
[{"$f":"IF(ISBLANK($E91),\"\",$F91&\", \"&$G91&\"  \"&TEXT($H91,\"00000\"))","v":""},{"$f":"IF(ISBLANK(OFFSET($E91,COLUMN()-1,0)),\"\",OFFSET($F91,COLUMN()-1,0) &\", \"&OFFSET($G91,COLUMN()-1,0) &\"  \"&TEXT(OFFSET($H91,COLUMN()-1,0),\"00000\"))","v":"Portland, ME  04101"},{"$f":"IF(ISBLANK(OFFSET($E91,COLUMN()-1,0)),\"\",OFFSET($F91,COLUMN()-1,0) &\", \"&OFFSET($G91,COLUMN()-1,0) &\"  \"&TEXT(OFFSET($H91,COLUMN()-1,0),\"00000\"))","v":""},{"$f":"IF(ISBLANK(OFFSET($E91,COLUMN()-1,0)),\"\",OFFSET($F91,COLUMN()-1,0) &\", \"&OFFSET($G91,COLUMN()-1,0) &\"  \"&TEXT(OFFSET($H91,COLUMN()-1,0),\"00000\"))","v":"Westbrook, ME  04521"},{"$f":"IF(ISBLANK(OFFSET($E91,COLUMN()-1,0)),\"\",OFFSET($F91,COLUMN()-1,0) &\", \"&OFFSET($G91,COLUMN()-1,0) &\"  \"&TEXT(OFFSET($H91,COLUMN()-1,0),\"00000\"))","v":""},"","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["http://spreadsheetpage.com/index.php/site/joke/the_best_spreadsheets/"]

{"sheet":"That's Special","index":14,"n_rows":155,"n_cols":18,"rows_kept":155,"cut":false,"hidden":false,"merged":[[84,1,84,4],[138,0,138,1],[63,13,63,14],[1,1,1,9],[3,0,3,1],[13,0,13,1],[63,3,63,4]]}
[]
[null,"Special Features"]
[]
["Hide Rows (7-8)"]
["We hold these truths to be self-evident, "," "]
["that all men are created equal"," "]
["Hide"]
["These"]
["Rows"]
["that they are endowed by their Creator with certain unalienable Rights, "," "]
["that among these are Life"," "]
["Liberty and the pursuit of Happiness."," "]
[]
["Copy Rows (5-12) below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy Range (N28-O54) to Starting Point (N65).  Copy only the visible cells:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Speech","Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lyceum Address",1838]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1838 Count",{"$f":"SUBTOTAL(3,O27:O27)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperance Address",1842]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1842 Count",{"$f":"SUBTOTAL(3,O29:O29)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Eulogy on Henry Clay",1852]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1852 Count",{"$f":"SUBTOTAL(3,O31:O31)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"House Divided Speech",1858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lincoln-Douglas Debates",1858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1858 Count",{"$f":"SUBTOTAL(3,O33:O34)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Second Lecture on Discoveries and Inventions",1859]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Address before the Wisconsin State Agricultural Society",1859]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1859 Count",{"$f":"SUBTOTAL(3,O36:O37)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooper Union Address",1860]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1860 Count",{"$f":"SUBTOTAL(3,O39:O39)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Farewell Address",1861]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Addresses to the New Jersey Senate/General Assembly",1861]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Address in Independence Hall",1861]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"First Inaugural Address",1861]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1861 Count",{"$f":"SUBTOTAL(3,O41:O44)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Response to a Serenade",1863]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The Gettysburg Address",1863]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1863 Count",{"$f":"SUBTOTAL(3,O46:O47)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Speeches to Ohio Regiments",1864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1864 Count",{"$f":"SUBTOTAL(3,O49:O49)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Second Inaugural Address",1865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Public Address",1865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1865 Count",{"$f":"SUBTOTAL(3,O51:O52)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Count",{"$f":"SUBTOTAL(3,O27:O52)","v":17}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"http://www.mrexcel.com/articles/excel-copy-subtotals.php"]
[]
[null,null,null,"Copy Range (A62-B155) Paste Values Below:",null,null,null,null,null,null,null,null,null,"Paste Speech & Year from Above"]
["Cumberland",{"$f":"VLOOKUP(A65,$A$140:$B$156,2,FALSE)","v":47182.952380952382}]
["Sagadahoc",{"$f":"VLOOKUP(A66,$A$140:$B$156,2,FALSE)","v":44190.777777777781}]
["York",44189.2]
["Androscoggin",42466.083333333336]
["Kennebec",39325]
["Lincoln",39184.866666666669]
["Knox",37983.071428571428]
["Hancock",35937.75]
["Oxford",35092.59375]
["Penobscot",34664.461538461539]
["Waldo",33368.434782608696]
["Franklin",31788.285714285714]
["Somerset",30807.695652173912]
["Aroostook",28149.046511627908]
["Piscataquis",27991.625]
["Washington",27590.526315789473]
[]
[]
[]
[]
[null,"Transpose (A86-A94) TO B86"]
["T"]
["R"]
["A"]
["N"]
["S",null,{"$f":"IF(CONCATENATE(B86,C86,D86,E86,F86,G86,H86,I86,J86) = \"TRANSPOSE\",\"Well Done\",\"\")","v":""}]
["P"]
["O"]
["S"]
["E"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["How are these values hidden?\nHow are they used?"]
["Cumberland",47182.952380952382]
["Sagadahoc",44190.777777777781]
["York",44189.2]
["Androscoggin",42466.083333333336]
["Kennebec",39325]
["Lincoln",39184.866666666669]
["Knox",37983.071428571428]
["Hancock",35937.75]
["Oxford",35092.59375]
["Penobscot",34664.461538461539]
["Waldo",33368.434782608696]
["Franklin",31788.285714285714]
["Somerset",30807.695652173912]
["Aroostook",28149.046511627908]
["Piscataquis",27991.625]
["Washington",27590.526315789473]

{"sheet":"Wheel","index":15,"n_rows":57,"n_cols":56,"rows_kept":57,"cut":false,"hidden":false,"merged":[[54,0,54,45],[4,0,6,41],[19,4,28,14],[31,0,31,28],[0,0,1,42],[53,0,53,45],[50,0,50,45],[51,0,51,46],[52,0,52,45],[2,0,2,37]]}
["Costly Spreadsheet Mistakes"]
[]
["Press a Letter from the Alphabet Below to Find Costly Spreadsheet Mistakes"]
[null,null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
["Westpac Jumps the Gun on Profit"]
[]
[]
[]
["Reason",null,null,null,null,null,null,null,null,null,null,null,null,"Guesses Remaining",null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"D+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"C-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"C+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"B-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"B+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"A-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"A"]
[null,null,null,null,{"$f":"VLOOKUP(Guesses,BC10:BD20,2)","v":"A+"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"A+"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["http://www.cio.com/article/131500/Eight_of_the_Worst_Spreadsheet_Blunders?page=2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Westpac Jumps the Gun on Profit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inappropriate data in spreadsheet"]
["Fidelity's - Spreadsheet off by $2.6 billion.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Needed a minus sign"]
["The $24 Million \"Clerical Error\" at TransAlta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cut and paste error"]
["Fannie Mae Discovers $1.3 Billion in shareholder equity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Honest mistake"]
["University of Toledo Loses $2.4 Million in Projected Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typo in a formula"]
["RedEnvelope Skids on Loss Forecast and Budgeting Error. Loosing one quarter of its value.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Error in one cell"]
["\"Think-and-Do Tank\" Flubs the Math, Think Tank reports 11% with bachelor's degree, it was actually 20%.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cut and paste error"]
["Kodak Restates, Adds $9 million to Loss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Too many zeros"]

{"sheet":"Rows & Columns","index":16,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[[14,2,14,3],[15,2,15,3],[16,2,16,3],[0,0,1,3]]}
["Manipulating Rows & Columns"]
[]
[null," "]
[null,null,null,null,"Order the Months by Moving Columns"]
[]
[null,null,null,null,"January","February ","May","June","July","March","September","April","October","August","December","November"]
[]
["Arrange the Declaration of Independence by adding, cutting & pasting rows. Begin by wrapping text."]
["that among these are Life",4]
["that all men are created equal",2]
["that they are endowed by their Creator with certain unalienable Rights, ",3]
["Liberty and the pursuit of Happiness.",5]
["We hold these truths to be self-evident, ",1]
[]
[null,null,"Format for Dollars & Cents,"]
[null," ","Spell Check Counties,"]
[null,null,"Sort Alphabetically"]
[null,null,"County","Income"]
[null,null,"Cumberland",47182.952380952382]
[null,null,"Sagadahoc",44190.777777777781]
[null,null,"York",44189.2]
[null,null,"Androscoggin",42466.083333333336]
[null,null,"Kennelbec",39325]
[null,null,"Lincoln",39184.866666666669]
[null,null,"Knox",37983.071428571428]
[null,null,"Hancock",35937.75]
[null,null,"Oxford",35092.59375]
[null,null,"Penobscot",34664.461538461539]
[null,null,"Waldo",33368.434782608696]
[null,null,"Franklin",31788.285714285714]
[null,null,"Somerset",30807.695652173912]
[null,null,"Aroostock",28149.046511627908]
[null,null,"Piscataquis",27991.625]
[null,null,"Washington",27590.526315789473]
[]
[null,"T"]
[null,"R"]
[null,"A"]
[null,"N"]
[null,"S"]
[null,"P"]
[null,"O"]
[null,"S"]
[null,"E"]

{"sheet":"Calculator","index":17,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,9,1,11],[26,1,26,5]]}
[]
[null,null,null,null,null,null,null,null,null,"Calculator Memory"]
[null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Exercise 1:  Monthly Take Home"]
[null,"Yearly Take Home:",null,70000]
[null,"Yearly Payroll Deductions:",null,16000]
[null,"Yearly Expenses:",null,45000]
[null,"Monthly Net:",null,{"$f":"(D21-D22-D23)/12","v":750}]
[]
["Exercise 2:  Check Register"]
[null,"Check Register"]
[null,"Balance Forward",null,null,null,300]
[null,"Running Balance",null,null,null,{"$f":"SUM($F$31:$F$50)+$F$28 - SUM($E$31:$E$50)","v":1544.8}]
[null,"Date","Type","Check No","Debit","Credit"]
[null,"2009-07-01","Salary",null,null,1500]
[null,"2009-07-01","Check",101,300]
[null,"2009-07-02","Check",102,55.2]
[null,"2009-07-05","ATM",null,200]
[null,"2009-07-06","Consulting",null,null,300]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Counts",{"$f":"SUBTOTAL(103,[Debit])","v":3},{"$f":"SUBTOTAL(103,[Credit])","v":2}]
[null,null,null,null,null,{"$f":"SUM($F$31:$F$50)+$F$28 - SUM($E$31:$E$50)","v":1544.8}]
[]
["Exercise 3:  Format and Print Check Register"]

{"sheet":"Sheet1","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[27,0,28,0],[27,1,28,1],[29,0,30,0],[29,1,30,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[25,0,26,0],[25,1,26,1],[16,0,19,0],[6,1,9,1],[6,2,9,2],[11,0,12,0],[11,1,12,1],[11,2,12,2]]}