{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["P(1)","P(1an)","P(1an) (2)","P(2) 82-83","P82-83an","P(3) P84-85","84-85an"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"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":"P(1)","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
["Can you find at least 12 problems with this spreadsheet?"]
[]
["Assumptions"]
["Days","2010-04-23",{"$f":"B4+1","v":"2010-04-24"},"2010-04-25","2010-04-26","2010-04-27"]
[]
[null,"Names",{"$f":"\"Day 1: \"&TEXT(B4,\"m/d/y\")","v":"Day 1: 4/23/10"},{"$f":"\"Day 1: \"&TEXT(C4,\"m/d/y\")","v":"Day 1: 4/24/10"},{"$f":"\"Day 1: \"&TEXT(D4,\"m/d/y\")","v":"Day 1: 4/25/10"},"Day 1: 4/26/10","Day 1: 4/27/10"]
[null,"Jo",2679.05,1564.17,2476.8200000000002,1190.18,1038.05]
[null,"Joe",1533.63,2800.32,2246.5100000000002,2399.52,1387.32]
[null,"Sean",1013.55,1170.0999999999999,2874.04,1757.26,2437.7800000000002]
[null,"Chin",1899.4,1721.91,2606.9699999999998,2160.33,1331.4]
[null,"Mike ",2835.53,2414.63,2465.2600000000002,2097.39,1110.8]
[null,"Sioux",2101.25,1565.38,2618.64,1104.04,2429.58]
[null,"Totals",{"$f":"C12+C11+C10+C9+C8+C7","v":12062.41},{"$f":"SUM(D8:D13)","v":0},"=SUM(E5:E10)",{"$f":"SUM(F8:F12)","v":9518.5400000000009},{"$f":"SUM(G7:G11)","v":7305.3499999999995}]
[]
[null,"Select Name To Sum"]
[null,"Jo"]
[null,{"$f":"SUMPRODUCT(INDEX(C7:G12,MATCH(B16,B7:B12,0),0))","v":8948.27}]

{"sheet":"P(1an)","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":true,"merged":[[2,0,2,5]]}
["Can you find at least 11 problems with this spreadsheet?"]
[]
["Assumptions"]
["Days","2010-04-23",{"$f":"B4+1","v":"2010-04-24"},"2010-04-25","2010-04-26","2010-04-27"]
[]
[null,"Names",{"$f":"\"Day 1: \"&TEXT(B4,\"m/d/y\")","v":"Day 1: 4/23/10"},{"$f":"\"Day 1: \"&TEXT(C4,\"m/d/y\")","v":"Day 1: 4/24/10"},{"$f":"\"Day 1: \"&TEXT(D4,\"m/d/y\")","v":"Day 1: 4/25/10"},"Day 1: 4/26/10","Day 1: 4/27/10"]
[null,"Jo",2679.05,1564.17,2476.8200000000002,1190.18,1038.05]
[null,"Joe",1533.63,2800.32,2246.5100000000002,2399.52,1387.32]
[null,"Sean",1013.55,1170.0999999999999,2874.04,1757.26,2437.7800000000002]
[null,"Chin",1899.4,1721.91,2606.9699999999998,2160.33,1331.4]
[null,"Mike ",2835.53,2414.63,2465.2600000000002,2097.39,1110.8]
[null,"Sioux",2101.25,1565.38,2618.64,1104.04,2429.58]
[null,"Totals",{"$f":"C12+C11+C10+C9+C8+C7","v":12062.41},{"$f":"SUM(D8:D13)","v":0},"=SUM(E5:E10)",{"$f":"SUM(F8:F12)","v":9518.5400000000009},{"$f":"SUM(G7:G11)","v":7305.3499999999995}]
[]
[null,"Select Name To Sum"]
[null,"Jo"]
[null,{"$f":"SUMPRODUCT(INDEX(C7:G12,MATCH(B16,B7:B12,0),0))","v":8948.27}]
[]
[]
[null,"Problems"]
[null,1,{"$f":"\"The word 'Days' in cell \"&ADDRESS(ROW(A4),COLUMN(A4),4)&\" usually should not be aligned right. This is because the default alignment for text  and numbers is helpful in seeing what type of data is in cell.\"","v":"The word 'Days' in cell A4 usually should not be aligned right. This is because the default alignment for text  and numbers is helpful in seeing what type of data is in cell."}]
[null,2,"Merge and Center should be Center Across Selection"]
[null,3,{"$f":"\"Cells \"&ADDRESS(ROW(F6),COLUMN(F6),4)&\":\"&ADDRESS(ROW(G6),COLUMN(G6),4)&\" must be formulas so that if you change assumptions the labels will change.\"","v":"Cells F6:G6 must be formulas so that if you change assumptions the labels will change."}]
[null,4,{"$f":"\"Formula in cell \"&ADDRESS(ROW(C13),COLUMN(C13),4)&\" must use SUM not + + + + + . This is because SUM is faster to create and if rows are inserted SUM will update, but + + + will not update.\"","v":"Formula in cell C13 must use SUM not + + + + + . This is because SUM is faster to create and if rows are inserted SUM will update, but + + + will not update."}]
[null,5,{"$f":"\"Cells \"&ADDRESS(ROW(C7),COLUMN(C7),4)&\":\"&ADDRESS(ROW(C12),COLUMN(C12),4)&\" must not be formatted with TEXT Number format\"","v":"Cells C7:C12 must not be formatted with TEXT Number format"}]
[null,6,{"$f":"\"Cells \"&ADDRESS(ROW(B4),COLUMN(B4),4)&\":\"&ADDRESS(ROW(F4),COLUMN(F4),4)&\" must be formatted to show year so that template can be used for other years besides the current one.\"","v":"Cells B4:F4 must be formatted to show year so that template can be used for other years besides the current one."}]
[null,7,{"$f":"\"Cell \"&ADDRESS(ROW(E13),COLUMN(E13),4)&\" must not be formatted with TEXT Number format. Once it is formatted with a Number format that can see numbers, you must put the formula into edit mode and hit Enter to get the formula to show the formula result.\"","v":"Cell E13 must not be formatted with TEXT Number format. Once it is formatted with a Number format that can see numbers, you must put the formula into edit mode and hit Enter to get the formula to show the formula result."}]
[null,8,{"$f":"\"The formulas in the cells \"&ADDRESS(ROW(F13),COLUMN(F13),4)&\":\"&ADDRESS(ROW(G13),COLUMN(G13),4)&\" must add all the numbers in the column.\"","v":"The formulas in the cells F13:G13 must add all the numbers in the column."}]
[null,9,{"$f":"\"Data Validation List in cell \"&ADDRESS(ROW(B16),COLUMN(B16),4)&\" should be linked to cells with names.\"","v":"Data Validation List in cell B16 should be linked to cells with names."}]
[null,10,{"$f":"\"Name in cell \"&ADDRESS(ROW(B11),COLUMN(B11),4)&\" must not have a space at the end.\"","v":"Name in cell B11 must not have a space at the end."}]
[null,11,{"$f":"\"Something is wrong with cell \"&ADDRESS(ROW(D13),COLUMN(D13),4)&\" but I do not know what it is, can you figure it out?\"","v":"Something is wrong with cell D13 but I do not know what it is, can you figure it out?"}]
[null,12,"Formatting Numbers might be nice also."]

{"sheet":"P(1an) (2)","index":2,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Can you find at least 11 problems with this spreadsheet?"]
[]
["Assumptions"]
["Days","2010-04-23",{"$f":"B4+1","v":"2010-04-24"},"2010-04-25","2010-04-26","2010-04-27"]
[]
[null,"Names",{"$f":"\"Day 1: \"&TEXT(B4,\"m/d/y\")","v":"Day 1: 4/23/10"},{"$f":"\"Day 1: \"&TEXT(C4,\"m/d/y\")","v":"Day 1: 4/24/10"},{"$f":"\"Day 1: \"&TEXT(D4,\"m/d/y\")","v":"Day 1: 4/25/10"},{"$f":"\"Day 1: \"&TEXT(E4,\"m/d/y\")","v":"Day 1: 4/26/10"},"Day 1: 4/27/10"]
[null,"Jo",2679.05,1564.17,2476.8200000000002,1190.18,1038.05]
[null,"Joe",1533.63,2800.32,2246.5100000000002,2399.52,1387.32]
[null,"Sean",1013.55,1170.0999999999999,2874.04,1757.26,2437.7800000000002]
[null,"Chin",1899.4,1721.91,2606.9699999999998,2160.33,1331.4]
[null,"Mike",2835.53,2414.63,2465.2600000000002,2097.39,1110.8]
[null,"Sioux",2101.25,1565.38,2618.64,1104.04,2429.58]
[null,"Totals",{"$f":"SUM(C7:C12)","v":12062.410000000002},{"$f":"SUM(D7:D12)","v":11236.510000000002},15288.24,10708.720000000001,9734.93]
[]
[null,"Select Name To Sum"]
[null,"Mike"]
[null,{"$f":"SUMPRODUCT(INDEX(C7:G12,MATCH(B16,B7:B12,0),0))","v":10923.609999999999}]
[]
[]
[null,"Problems"]
[null,1,{"$f":"\"The word 'Days' in cell \"&ADDRESS(ROW(A4),COLUMN(A4),4)&\" usually should not be aligned right. This is because the default alignment for text  and numbers is helpful in seeing what type of data is in cell.\"","v":"The word 'Days' in cell A4 usually should not be aligned right. This is because the default alignment for text  and numbers is helpful in seeing what type of data is in cell."}]
[null,2,"Merge and Center should be Center Across Selection"]
[null,3,{"$f":"\"Cells \"&ADDRESS(ROW(F6),COLUMN(F6),4)&\":\"&ADDRESS(ROW(G6),COLUMN(G6),4)&\" must be formulas so that if you change assumptions the labels will change.\"","v":"Cells F6:G6 must be formulas so that if you change assumptions the labels will change."}]
[null,4,{"$f":"\"Formula in cell \"&ADDRESS(ROW(C13),COLUMN(C13),4)&\" must use SUM not + + + + + . This is because SUM is faster to create and if rows are inserted SUM will update, but + + + will not update.\"","v":"Formula in cell C13 must use SUM not + + + + + . This is because SUM is faster to create and if rows are inserted SUM will update, but + + + will not update."}]
[null,5,{"$f":"\"Cells \"&ADDRESS(ROW(C7),COLUMN(C7),4)&\":\"&ADDRESS(ROW(C12),COLUMN(C12),4)&\" must not be formatted with TEXT Number format\"","v":"Cells C7:C12 must not be formatted with TEXT Number format"}]
[null,6,{"$f":"\"Cells \"&ADDRESS(ROW(B4),COLUMN(B4),4)&\":\"&ADDRESS(ROW(F4),COLUMN(F4),4)&\" must be formatted to show year so that template can be used for other years besides the current one.\"","v":"Cells B4:F4 must be formatted to show year so that template can be used for other years besides the current one."}]
[null,7,{"$f":"\"Cell \"&ADDRESS(ROW(E13),COLUMN(E13),4)&\" must not be formatted with TEXT Number format. Once it is formatted with a Number format that can see numbers, you must put the formula into edit mode and hit Enter to get the formula to show the formula result.\"","v":"Cell E13 must not be formatted with TEXT Number format. Once it is formatted with a Number format that can see numbers, you must put the formula into edit mode and hit Enter to get the formula to show the formula result."}]
[null,8,{"$f":"\"The formulas in the cells \"&ADDRESS(ROW(F13),COLUMN(F13),4)&\":\"&ADDRESS(ROW(G13),COLUMN(G13),4)&\" must add all the numbers in the column.\"","v":"The formulas in the cells F13:G13 must add all the numbers in the column."}]
[null,9,{"$f":"\"Data Validation List in cell \"&ADDRESS(ROW(B16),COLUMN(B16),4)&\" should be linked to cells with names.\"","v":"Data Validation List in cell B16 should be linked to cells with names."}]
[null,10,{"$f":"\"Name in cell \"&ADDRESS(ROW(B11),COLUMN(B11),4)&\" must not have a space at the end.\"","v":"Name in cell B11 must not have a space at the end."}]
[null,11,{"$f":"\"Something is wrong with cell \"&ADDRESS(ROW(D13),COLUMN(D13),4)&\" but I do not know what it is, can you figure it out?\"","v":"Something is wrong with cell D13 but I do not know what it is, can you figure it out?"}]
[null,12,"Formatting Numbers might be nice also."]

{"sheet":"P(2) 82-83","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"P82-83an","index":4,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Computer Purchase Analysis"]
[null,"Dell","HP","Lenovo"]
["GHz",2.13,2.4,2.13]
["RAM",1,1,2.5]
["Hard drive",250,200,250]
["Keyboard","Included","Included","Included"]
["Computer:",1067,949,1724]
["RAM upgrade",130,120,"Included"]
["Hard drive upgrade",220,90,"Included"]
["Optical Mouse",10,40,"Included"]
["Video Card",100,100,"Included"]
["Wireless Router or LAN",82,30,"Included"]
["CD-RW",40,"Included","Included"]
["Upgrade to Windows Vista",99,60,"Included"]
["Flat Panel Monitor",190,130,329]
["Shipping & Handling",75,25,"Included"]
["Warranty",95,127.95]
["  Total cost of 1 system",{"$f":"SUM(B7:B17)","v":2108},{"$f":"SUM(C7:C17)","v":1671.95},{"$f":"SUM(D7:D17)","v":2053}]
[]
["Totals After Discounts"]
["Cost per Machine",{"$f":"(1-B25)*(B18-B16)+B16","v":1904.7},{"$f":"C18-C26","v":1656.95},{"$f":"D18*(1-D27)","v":1642.4}]
["Cost of 30 Machines",{"$f":"B21*$B28","v":57141},{"$f":"C21*$B28","v":49708.5},{"$f":"D21*$B28","v":49272}]
[]
["Assumptions"]
["Dell Discount on all but shipping",0.1]
["HP discount per machine",null,15]
["Gateway price reduction and Free warrenty (1year)",null,null,0.2]
["Number of Machines Purchased",30]

{"sheet":"P(3) P84-85","index":5,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Position","Location","Annual Salary","Cost of Living Multiplier","Monthly Car Payment","Adjusted Salary","Bonus","Total 2yr. Financial Package"]
[null,"Product Manager","New York",39750,1.35,0,null,2500]
[null,"Networking Specialist","Chicago",42300,1.2,275]
[null,"Systems Analyst","Indianapolis",49900,0.85,275,null,5000]
[]
[null,null,null,null,null,"Average:"]
[null,null,null,null,null,"Low Offer"]
[null,null,null,null,null,"High Offer"]
[null,null,null,null,null,"# positions w/bonus"]

{"sheet":"84-85an","index":6,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Goal of homework: Help employee to select the most appropriate position based on a number of criteria"]
["Criteria 1","Amount of disposable income"]
["Criteria 2"]
["Criteria 3"]
[]
["Assumptions"]
["NY apartment cost",2500]
["NY job won't require car",0]
["Increase for adjusted Salary after first Year",0.1]
[]
[]
[]
[]
[]
[null,"Position","Location","Annual Salary","Cost of Living Multiplier","Monthly Car Payment","Adjusted Salary","Bonus","Total 2yr. Financial Package"]
[null,"Product Manager","New York",39750,1.35,0,{"$f":"IF(E16=0,0,D16/E16-F16*12)","v":29444.444444444442},2500,{"$f":"G16+G16*(1+B$9)+H16","v":64333.333333333328}]
[null,"Networking Specialist","Chicago",42300,1.2,275,{"$f":"IF(E17=0,0,D17/E17-F17*12)","v":31950},null,{"$f":"G17+G17*(1+B$9)+H17","v":67095}]
[null,"Senior Consultant","New York",64000,1.35,0,{"$f":"IF(E18=0,0,D18/E18-F18*12)","v":47407.407407407401},5000,{"$f":"G18+G18*(1+B$9)+H18","v":104555.55555555555}]
[null,"Systems Analyst","Indianapolis",49900,0.85,275,{"$f":"IF(E19=0,0,D19/E19-F19*12)","v":55405.882352941175},5000,{"$f":"G19+G19*(1+B$9)+H19","v":121352.35294117648}]
[]
[null,null,null,null,null,"Average:",{"$f":"AVERAGE(salaries)","v":41051.93355119825}]
[null,null,null,null,null,"Low Offer",{"$f":"MIN(salaries)","v":29444.444444444442}]
[null,null,null,null,null,"High Offer",{"$f":"MAX(salaries)","v":55405.882352941175}]
[null,null,null,null,null,"# positions w/bonus",null,{"$f":"COUNT(H16:H19)","v":3}]