{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["(1)","(1an)","(2)","(2an)","(3)","(3an)","(4)","(4an)","(5)","(5an)","(6)","(6an)","(7)","(7an)","(8)","(8an)","(9)","(9an)","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":3},"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":"(1)","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["In the green cells add formulas to complete the payroll calculations"]
[]
[null,null,null,null,null,null,"Tax Rate"]
[null,null,null,null,null,null,0.14199999999999999]
[]
["Name","In","Out","Total Time","Wage","Total Pay Before Tax (Time*Wage)","Tax (Total Pay*Tax Rate)","Pay After Tax (Total Pay - Tax)"]
["Name1","09:26:24","21:26:24",null,19]
["Name2","09:40:48","14:28:48",null,15]
["Name3","09:12:00","16:24:00",null,18]
["Name4","10:09:36","14:57:36",null,16]
["Name5","09:12:00","18:48:00",null,11]
["Name6","09:26:24","14:14:24",null,14]
["Name7","08:57:36","18:33:36",null,17]
["Name8","08:43:12","15:55:12",null,17]
["Name9","10:24:00","17:36:00",null,16]
["Name10","09:55:12","19:31:12",null,15]
["Name11","09:12:00","21:12:00",null,15]
["Name12","09:26:24","14:14:24",null,19]
["Name13","09:55:12","14:43:12",null,21]
["Name14","10:24:00","20:00:00",null,15]
["Name15","10:24:00","20:00:00",null,13]
["Name16","08:57:36","13:45:36",null,19]

{"sheet":"(1an)","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["In the green cells add formulas to complete the payroll calculations"]
[]
[null,null,null,null,null,null,"Tax Rate"]
[null,null,null,null,null,null,0.14199999999999999]
[]
["Name","In","Out","Total Time","Wage","Total Pay Before Tax (Time*Wage)","Tax (Total Pay*Tax Rate)","Pay After Tax (Total Pay - Tax)"]
["Name1","09:26:24","21:26:24",{"$f":"(C7-B7)*24","v":12},19,{"$f":"E7*D7","v":228},{"$f":"ROUND(F7*G$4,2)","v":32.380000000000003},{"$f":"F7-G7","v":195.62}]
["Name2","09:40:48","14:28:48",4.7999999999999989,15,71.999999999999986,10.220000000000001,61.779999999999987]
["Name3","09:12:00","16:24:00",7.2000000000000011,18,129.60000000000002,18.399999999999999,111.20000000000002]
["Name4","10:09:36","14:57:36",4.7999999999999989,16,76.799999999999983,10.91,65.889999999999986]
["Name5","09:12:00","18:48:00",9.6000000000000014,11,105.60000000000002,15,90.600000000000023]
["Name6","09:26:24","14:14:24",4.7999999999999989,14,67.199999999999989,9.5399999999999991,57.659999999999989]
["Name7","08:57:36","18:33:36",9.6000000000000014,17,163.20000000000002,23.17,140.03000000000003]
["Name8","08:43:12","15:55:12",7.2000000000000011,17,122.40000000000002,17.38,105.02000000000002]
["Name9","10:24:00","17:36:00",7.2000000000000011,16,115.20000000000002,16.36,98.840000000000018]
["Name10","09:55:12","19:31:12",9.6000000000000014,15,144.00000000000003,20.45,123.55000000000003]
["Name11","09:12:00","21:12:00",12,15,180,25.56,154.44]
["Name12","09:26:24","14:14:24",4.7999999999999989,19,91.199999999999974,12.95,78.249999999999972]
["Name13","09:55:12","14:43:12",4.7999999999999989,21,100.79999999999998,14.31,86.489999999999981]
["Name14","10:24:00","20:00:00",9.6000000000000014,15,144.00000000000003,20.45,123.55000000000003]
["Name15","10:24:00","20:00:00",9.6000000000000014,13,124.80000000000001,17.72,107.08000000000001]
["Name16","08:57:36","13:45:36",4.7999999999999989,19,91.199999999999974,12.95,78.249999999999972]

{"sheet":"(2)","index":2,"n_rows":208,"n_cols":8,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
["In the green cells add formulas to sum that sales for each sales rep"]
[]
["Date","SalesRep","Sales",null,null,null,"Names","Total Sales"]
["2010-03-18","Fred",73,null,null,null,"Sioux"]
["2010-03-19","Jo",121,null,null,null,"Sue"]
["2010-03-20","Fred",167,null,null,null,"Jo"]
["2010-03-21","Joe",167,null,null,null,"Joe"]
["2010-03-22","Sue",75,null,null,null,"Fred"]
["2010-03-23","Fred",157,null,null,null,"Chin"]
["2010-03-24","Sue",61]
["2010-03-25","Fred",108]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(2an)","index":3,"n_rows":208,"n_cols":10,"rows_kept":208,"cut":false,"hidden":true,"merged":[]}
["In the green cells add formulas to sum that sales for each sales rep"]
[]
["Date","SalesRep","Sales",null,null,null,"Names","Total Sales"]
["2010-03-18","Fred",73,null,null,null,"Chin",{"$f":"SUMIF(B$4:B$208,G4,$C$4:$C$208)","v":2718},null,{"$f":"H4='(5an)'!F7","v":true}]
["2010-03-19","Jo",121,null,null,null,"Fred",3601,null,{"$f":"H5='(5an)'!F8","v":true}]
["2010-03-20","Fred",167,null,null,null,"Jo",4087,null,{"$f":"H6='(5an)'!F9","v":true}]
["2010-03-21","Joe",167,null,null,null,"Joe",4659,null,{"$f":"H7='(5an)'!F10","v":true}]
["2010-03-22","Sue",75,null,null,null,"Sioux",2571,null,{"$f":"H8='(5an)'!F11","v":true}]
["2010-03-23","Fred",157,null,null,null,"Sue",5109,null,{"$f":"H9='(5an)'!F12","v":true}]
["2010-03-24","Sue",61]
["2010-03-25","Fred",108]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(3)","index":4,"n_rows":208,"n_cols":3,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
["Sort the Sales Column to show the largest values at the top of the column."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73]
["2010-03-19","Jo",121]
["2010-03-20","Fred",167]
["2010-03-21","Joe",167]
["2010-03-22","Sue",75]
["2010-03-23","Fred",157]
["2010-03-24","Sue",61]
["2010-03-25","Fred",108]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(3an)","index":5,"n_rows":208,"n_cols":3,"rows_kept":208,"cut":false,"hidden":true,"merged":[]}
["Sort the Sales Column to show the largest values at the top of the column."]
[]
["Date","SalesRep","Sales"]
["2010-07-09","Sue",170]
["2010-08-23","Joe",170]
["2010-04-07","Sioux",168]
["2010-07-21","Sue",168]
["2010-03-20","Fred",167]
["2010-03-21","Joe",167]
["2010-06-05","Sue",167]
["2010-06-08","Sioux",167]
["2010-08-03","Sue",167]
["2010-05-07","Sioux",166]
["2010-08-09","Joe",166]
["2010-06-29","Chin",165]
["2010-05-18","Fred",163]
["2010-07-29","Sue",160]
["2010-09-09","Jo",160]
["2010-07-22","Joe",159]
["2010-10-01","Sioux",159]
["2010-03-23","Fred",157]
["2010-07-07","Jo",157]
["2010-07-02","Sue",156]
["2010-09-18","Sioux",155]
["2010-06-30","Joe",153]
["2010-07-13","Chin",153]
["2010-05-08","Sioux",152]
["2010-06-06","Joe",152]
["2010-06-19","Fred",152]
["2010-04-21","Chin",151]
["2010-08-13","Joe",151]
["2010-09-05","Jo",151]
["2010-05-05","Fred",150]
["2010-09-03","Jo",150]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-08-05","Sue",148]
["2010-09-12","Chin",148]
["2010-08-29","Jo",147]
["2010-08-31","Sue",147]
["2010-05-01","Chin",146]
["2010-06-23","Sue",146]
["2010-09-19","Jo",146]
["2010-09-30","Fred",146]
["2010-10-08","Sue",146]
["2010-08-18","Joe",145]
["2010-05-09","Joe",143]
["2010-08-15","Sue",143]
["2010-10-07","Fred",143]
["2010-04-27","Jo",142]
["2010-06-25","Jo",141]
["2010-07-03","Jo",141]
["2010-07-12","Jo",141]
["2010-08-24","Fred",141]
["2010-09-24","Sue",141]
["2010-04-02","Fred",140]
["2010-03-26","Jo",139]
["2010-05-10","Joe",139]
["2010-09-21","Sue",139]
["2010-04-16","Sue",138]
["2010-06-16","Sioux",138]
["2010-06-18","Sue",137]
["2010-07-25","Chin",136]
["2010-04-22","Joe",135]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-04-20","Sue",134]
["2010-05-29","Fred",134]
["2010-09-16","Sue",134]
["2010-05-25","Joe",133]
["2010-08-28","Sue",133]
["2010-04-10","Chin",132]
["2010-10-03","Sue",132]
["2010-10-06","Joe",132]
["2010-09-23","Jo",131]
["2010-03-27","Sioux",130]
["2010-05-04","Sue",130]
["2010-05-24","Joe",130]
["2010-06-17","Fred",130]
["2010-07-24","Jo",130]
["2010-07-27","Joe",130]
["2010-06-07","Sue",129]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-09-27","Joe",126]
["2010-05-23","Fred",125]
["2010-09-07","Jo",125]
["2010-06-21","Jo",123]
["2010-06-28","Joe",123]
["2010-07-31","Sioux",123]
["2010-08-19","Joe",123]
["2010-03-30","Joe",122]
["2010-08-16","Jo",122]
["2010-03-19","Jo",121]
["2010-04-05","Joe",121]
["2010-04-30","Fred",120]
["2010-07-06","Sue",120]
["2010-06-12","Joe",119]
["2010-07-18","Joe",117]
["2010-08-14","Fred",117]
["2010-08-22","Sue",117]
["2010-09-28","Joe",117]
["2010-08-20","Jo",116]
["2010-10-05","Sue",116]
["2010-05-22","Jo",115]
["2010-04-29","Chin",114]
["2010-08-04","Sioux",114]
["2010-07-17","Jo",113]
["2010-07-30","Chin",113]
["2010-05-11","Chin",111]
["2010-04-09","Chin",110]
["2010-06-22","Sue",110]
["2010-09-20","Sue",110]
["2010-04-04","Sioux",109]
["2010-04-15","Fred",109]
["2010-06-11","Chin",109]
["2010-06-15","Sue",109]
["2010-03-25","Fred",108]
["2010-05-19","Joe",108]
["2010-06-14","Sue",108]
["2010-04-03","Sue",107]
["2010-09-11","Chin",107]
["2010-08-10","Jo",106]
["2010-05-13","Fred",104]
["2010-07-11","Jo",104]
["2010-04-19","Chin",103]
["2010-07-01","Sue",103]
["2010-06-20","Jo",100]
["2010-07-14","Fred",100]
["2010-05-21","Fred",99]
["2010-06-01","Jo",99]
["2010-07-23","Chin",98]
["2010-09-15","Joe",98]
["2010-09-04","Chin",97]
["2010-05-02","Sioux",96]
["2010-05-17","Joe",96]
["2010-08-12","Sioux",95]
["2010-08-26","Jo",95]
["2010-04-26","Chin",94]
["2010-07-10","Fred",92]
["2010-08-21","Sue",91]
["2010-04-08","Jo",88]
["2010-07-20","Sue",88]
["2010-09-10","Joe",88]
["2010-09-02","Fred",87]
["2010-03-29","Sioux",86]
["2010-09-01","Fred",86]
["2010-08-30","Chin",84]
["2010-09-17","Chin",84]
["2010-04-25","Sioux",81]
["2010-08-06","Jo",81]
["2010-10-02","Sue",80]
["2010-07-04","Fred",79]
["2010-08-07","Jo",79]
["2010-04-06","Fred",78]
["2010-07-05","Chin",78]
["2010-07-19","Chin",78]
["2010-04-01","Sue",77]
["2010-05-16","Joe",76]
["2010-06-13","Jo",76]
["2010-07-16","Sioux",76]
["2010-08-08","Jo",76]
["2010-08-17","Fred",76]
["2010-03-22","Sue",75]
["2010-04-28","Fred",75]
["2010-06-04","Joe",75]
["2010-09-13","Fred",75]
["2010-04-17","Jo",74]
["2010-06-09","Joe",74]
["2010-08-11","Sue",74]
["2010-03-18","Fred",73]
["2010-08-02","Sioux",73]
["2010-04-13","Sue",71]
["2010-06-24","Joe",71]
["2010-05-12","Joe",70]
["2010-05-03","Sioux",69]
["2010-06-10","Chin",69]
["2010-09-08","Fred",69]
["2010-09-14","Fred",68]
["2010-09-22","Sioux",68]
["2010-07-08","Joe",67]
["2010-03-28","Sue",66]
["2010-04-24","Sue",66]
["2010-09-26","Sioux",65]
["2010-05-14","Sioux",64]
["2010-05-20","Joe",63]
["2010-05-06","Chin",62]
["2010-09-06","Chin",62]
["2010-03-24","Sue",61]
["2010-08-01","Chin",60]
["2010-10-04","Sioux",60]
["2010-05-31","Jo",59]
["2010-04-12","Fred",58]
["2010-08-27","Sioux",57]
["2010-09-29","Joe",57]
["2010-05-15","Jo",56]
["2010-05-28","Joe",56]
["2010-07-15","Sue",56]
["2010-07-26","Joe",56]
["2010-04-11","Jo",54]
["2010-04-23","Chin",54]
["2010-05-30","Fred",54]
["2010-08-25","Sue",54]
["2010-07-28","Jo",53]
["2010-03-31","Sioux",50]
["2010-04-14","Jo",50]
["2010-04-18","Sioux",50]
["2010-09-25","Sue",50]

{"sheet":"(4)","index":6,"n_rows":208,"n_cols":3,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
["Filter the data set to show only the sales for Jo."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73]
["2010-03-19","Jo",121]
["2010-03-20","Fred",167]
["2010-03-21","Joe",167]
["2010-03-22","Sue",75]
["2010-03-23","Fred",157]
["2010-03-24","Sue",61]
["2010-03-25","Fred",108]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(4an)","index":7,"n_rows":208,"n_cols":3,"rows_kept":208,"cut":false,"hidden":true,"merged":[]}
["Filter the data set to show only the sales for Jo."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73]
["2010-03-19","Jo",121]
["2010-03-20","Fred",167]
["2010-03-21","Joe",167]
["2010-03-22","Sue",75]
["2010-03-23","Fred",157]
["2010-03-24","Sue",61]
["2010-03-25","Fred",108]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(5)","index":8,"n_rows":208,"n_cols":3,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
["Create A PivotTable that sums sales for each Sales Rep."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73]
["2010-03-19","Jo",121]
["2010-03-20","Fred",167]
["2010-03-21","Joe",167]
["2010-03-22","Sue",75]
["2010-03-23","Fred",157]
["2010-03-24","Sue",61]
["2010-03-25","Fred",108]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(5an)","index":9,"n_rows":208,"n_cols":8,"rows_kept":208,"cut":false,"hidden":true,"merged":[]}
["Create A PivotTable that sums sales for each Sales Rep."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73]
["2010-03-19","Jo",121]
["2010-03-20","Fred",167,null,"Row Labels","Sum of Sales"]
["2010-03-21","Joe",167,null,"Chin",2718,null,{"$f":"F7='(2an)'!H4","v":true}]
["2010-03-22","Sue",75,null,"Fred",3601,null,{"$f":"F8='(2an)'!H5","v":true}]
["2010-03-23","Fred",157,null,"Jo",4087,null,{"$f":"F9='(2an)'!H6","v":true}]
["2010-03-24","Sue",61,null,"Joe",4659,null,{"$f":"F10='(2an)'!H7","v":true}]
["2010-03-25","Fred",108,null,"Sioux",2571,null,{"$f":"F11='(2an)'!H8","v":true}]
["2010-03-26","Jo",139,null,"Sue",5109,null,{"$f":"F12='(2an)'!H9","v":true}]
["2010-03-27","Sioux",130,null,"Grand Total",22745]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(6)","index":10,"n_rows":208,"n_cols":3,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
["Create A PivotTable that sums sales for each Month."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73]
["2010-03-19","Jo",121]
["2010-03-20","Fred",167]
["2010-03-21","Joe",167]
["2010-03-22","Sue",75]
["2010-03-23","Fred",157]
["2010-03-24","Sue",61]
["2010-03-25","Fred",108]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(6an)","index":11,"n_rows":208,"n_cols":7,"rows_kept":208,"cut":false,"hidden":true,"merged":[]}
["Create A PivotTable that sums sales for each Month."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73,null,null,"Row Labels","Sum of Sales"]
["2010-03-19","Jo",121,null,null,"2010"]
["2010-03-20","Fred",167,null,null,"Mar",1522]
["2010-03-21","Joe",167,null,null,"Apr",3003]
["2010-03-22","Sue",75,null,null,"May",3365]
["2010-03-23","Fred",157,null,null,"Jun",3664]
["2010-03-24","Sue",61,null,null,"Jul",3515]
["2010-03-25","Fred",108,null,null,"Aug",3468]
["2010-03-26","Jo",139,null,null,"Sep",3240]
["2010-03-27","Sioux",130,null,null,"Oct",968]
["2010-03-28","Sue",66,null,null,"Grand Total",22745]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(7)","index":12,"n_rows":208,"n_cols":3,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
["Create A PivotTable that sums sales for each Sales Rep and then make a chart that shows how each amount compares to the whole."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73]
["2010-03-19","Jo",121]
["2010-03-20","Fred",167]
["2010-03-21","Joe",167]
["2010-03-22","Sue",75]
["2010-03-23","Fred",157]
["2010-03-24","Sue",61]
["2010-03-25","Fred",108]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(7an)","index":13,"n_rows":208,"n_cols":7,"rows_kept":208,"cut":false,"hidden":true,"merged":[]}
["Create A PivotTable that sums sales for each Sales Rep and then make a chart that shows how each amount compares to the whole."]
[]
["Date","SalesRep","Sales"]
["2010-03-18","Fred",73,null,null,"Row Labels","Sum of Sales"]
["2010-03-19","Jo",121,null,null,"Chin",2718]
["2010-03-20","Fred",167,null,null,"Fred",3601]
["2010-03-21","Joe",167,null,null,"Jo",4087]
["2010-03-22","Sue",75,null,null,"Joe",4659]
["2010-03-23","Fred",157,null,null,"Sioux",2571]
["2010-03-24","Sue",61,null,null,"Sue",5109]
["2010-03-25","Fred",108,null,null,"Grand Total",22745]
["2010-03-26","Jo",139]
["2010-03-27","Sioux",130]
["2010-03-28","Sue",66]
["2010-03-29","Sioux",86]
["2010-03-30","Joe",122]
["2010-03-31","Sioux",50]
["2010-04-01","Sue",77]
["2010-04-02","Fred",140]
["2010-04-03","Sue",107]
["2010-04-04","Sioux",109]
["2010-04-05","Joe",121]
["2010-04-06","Fred",78]
["2010-04-07","Sioux",168]
["2010-04-08","Jo",88]
["2010-04-09","Chin",110]
["2010-04-10","Chin",132]
["2010-04-11","Jo",54]
["2010-04-12","Fred",58]
["2010-04-13","Sue",71]
["2010-04-14","Jo",50]
["2010-04-15","Fred",109]
["2010-04-16","Sue",138]
["2010-04-17","Jo",74]
["2010-04-18","Sioux",50]
["2010-04-19","Chin",103]
["2010-04-20","Sue",134]
["2010-04-21","Chin",151]
["2010-04-22","Joe",135]
["2010-04-23","Chin",54]
["2010-04-24","Sue",66]
["2010-04-25","Sioux",81]
["2010-04-26","Chin",94]
["2010-04-27","Jo",142]
["2010-04-28","Fred",75]
["2010-04-29","Chin",114]
["2010-04-30","Fred",120]
["2010-05-01","Chin",146]
["2010-05-02","Sioux",96]
["2010-05-03","Sioux",69]
["2010-05-04","Sue",130]
["2010-05-05","Fred",150]
["2010-05-06","Chin",62]
["2010-05-07","Sioux",166]
["2010-05-08","Sioux",152]
["2010-05-09","Joe",143]
["2010-05-10","Joe",139]
["2010-05-11","Chin",111]
["2010-05-12","Joe",70]
["2010-05-13","Fred",104]
["2010-05-14","Sioux",64]
["2010-05-15","Jo",56]
["2010-05-16","Joe",76]
["2010-05-17","Joe",96]
["2010-05-18","Fred",163]
["2010-05-19","Joe",108]
["2010-05-20","Joe",63]
["2010-05-21","Fred",99]
["2010-05-22","Jo",115]
["2010-05-23","Fred",125]
["2010-05-24","Joe",130]
["2010-05-25","Joe",133]
["2010-05-26","Joe",148]
["2010-05-27","Joe",148]
["2010-05-28","Joe",56]
["2010-05-29","Fred",134]
["2010-05-30","Fred",54]
["2010-05-31","Jo",59]
["2010-06-01","Jo",99]
["2010-06-02","Sue",135]
["2010-06-03","Joe",135]
["2010-06-04","Joe",75]
["2010-06-05","Sue",167]
["2010-06-06","Joe",152]
["2010-06-07","Sue",129]
["2010-06-08","Sioux",167]
["2010-06-09","Joe",74]
["2010-06-10","Chin",69]
["2010-06-11","Chin",109]
["2010-06-12","Joe",119]
["2010-06-13","Jo",76]
["2010-06-14","Sue",108]
["2010-06-15","Sue",109]
["2010-06-16","Sioux",138]
["2010-06-17","Fred",130]
["2010-06-18","Sue",137]
["2010-06-19","Fred",152]
["2010-06-20","Jo",100]
["2010-06-21","Jo",123]
["2010-06-22","Sue",110]
["2010-06-23","Sue",146]
["2010-06-24","Joe",71]
["2010-06-25","Jo",141]
["2010-06-26","Fred",126]
["2010-06-27","Jo",126]
["2010-06-28","Joe",123]
["2010-06-29","Chin",165]
["2010-06-30","Joe",153]
["2010-07-01","Sue",103]
["2010-07-02","Sue",156]
["2010-07-03","Jo",141]
["2010-07-04","Fred",79]
["2010-07-05","Chin",78]
["2010-07-06","Sue",120]
["2010-07-07","Jo",157]
["2010-07-08","Joe",67]
["2010-07-09","Sue",170]
["2010-07-10","Fred",92]
["2010-07-11","Jo",104]
["2010-07-12","Jo",141]
["2010-07-13","Chin",153]
["2010-07-14","Fred",100]
["2010-07-15","Sue",56]
["2010-07-16","Sioux",76]
["2010-07-17","Jo",113]
["2010-07-18","Joe",117]
["2010-07-19","Chin",78]
["2010-07-20","Sue",88]
["2010-07-21","Sue",168]
["2010-07-22","Joe",159]
["2010-07-23","Chin",98]
["2010-07-24","Jo",130]
["2010-07-25","Chin",136]
["2010-07-26","Joe",56]
["2010-07-27","Joe",130]
["2010-07-28","Jo",53]
["2010-07-29","Sue",160]
["2010-07-30","Chin",113]
["2010-07-31","Sioux",123]
["2010-08-01","Chin",60]
["2010-08-02","Sioux",73]
["2010-08-03","Sue",167]
["2010-08-04","Sioux",114]
["2010-08-05","Sue",148]
["2010-08-06","Jo",81]
["2010-08-07","Jo",79]
["2010-08-08","Jo",76]
["2010-08-09","Joe",166]
["2010-08-10","Jo",106]
["2010-08-11","Sue",74]
["2010-08-12","Sioux",95]
["2010-08-13","Joe",151]
["2010-08-14","Fred",117]
["2010-08-15","Sue",143]
["2010-08-16","Jo",122]
["2010-08-17","Fred",76]
["2010-08-18","Joe",145]
["2010-08-19","Joe",123]
["2010-08-20","Jo",116]
["2010-08-21","Sue",91]
["2010-08-22","Sue",117]
["2010-08-23","Joe",170]
["2010-08-24","Fred",141]
["2010-08-25","Sue",54]
["2010-08-26","Jo",95]
["2010-08-27","Sioux",57]
["2010-08-28","Sue",133]
["2010-08-29","Jo",147]
["2010-08-30","Chin",84]
["2010-08-31","Sue",147]
["2010-09-01","Fred",86]
["2010-09-02","Fred",87]
["2010-09-03","Jo",150]
["2010-09-04","Chin",97]
["2010-09-05","Jo",151]
["2010-09-06","Chin",62]
["2010-09-07","Jo",125]
["2010-09-08","Fred",69]
["2010-09-09","Jo",160]
["2010-09-10","Joe",88]
["2010-09-11","Chin",107]
["2010-09-12","Chin",148]
["2010-09-13","Fred",75]
["2010-09-14","Fred",68]
["2010-09-15","Joe",98]
["2010-09-16","Sue",134]
["2010-09-17","Chin",84]
["2010-09-18","Sioux",155]
["2010-09-19","Jo",146]
["2010-09-20","Sue",110]
["2010-09-21","Sue",139]
["2010-09-22","Sioux",68]
["2010-09-23","Jo",131]
["2010-09-24","Sue",141]
["2010-09-25","Sue",50]
["2010-09-26","Sioux",65]
["2010-09-27","Joe",126]
["2010-09-28","Joe",117]
["2010-09-29","Joe",57]
["2010-09-30","Fred",146]
["2010-10-01","Sioux",159]
["2010-10-02","Sue",80]
["2010-10-03","Sue",132]
["2010-10-04","Sioux",60]
["2010-10-05","Sue",116]
["2010-10-06","Joe",132]
["2010-10-07","Fred",143]
["2010-10-08","Sue",146]

{"sheet":"(8)","index":14,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["In the two green cells calculate the Loan due date."]
[]
["Loan Amount",10500]
["Loan Issue Date","2010-03-18"]
["Months until loan due",5]
["Date Loan is due"]
[]
["Loan Amount",10500]
["Loan Issue Date","2010-03-18"]
["Days until loan due",75]
["Date Loan is due"]

{"sheet":"(8an)","index":15,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["In the two green cells calculate the Loan due date."]
[]
["Loan Amount",10500]
["Loan Issue Date","2010-03-18"]
["Months until loan due",5]
["Date Loan is due",{"$f":"EDATE(B4,B5)","v":"2010-08-18"}]
[]
["Loan Amount",10500]
["Loan Issue Date","2010-03-18"]
["Days until loan due",75]
["Date Loan is due",{"$f":"B9+B10","v":"2010-06-01"}]

{"sheet":"(9)","index":16,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["In the green cells create a formula that calculates the expenses as a percent of Income."]
[]
[null,"Month","Income",{"$f":"D16","v":"Expense 1"},{"$f":"E16","v":"Expense 2"},{"$f":"F16","v":"Expense 3"},{"$f":"G16","v":"Expense 4"},{"$f":"H16","v":"Expense 5"},{"$f":"I16","v":"Expense 6"},{"$f":"J16","v":"Expense 7"}]
[null,"Jan",5000]
[null,"Feb",6000]
[null,"Mar",7500]
[null,"Apr",8000]
[null,"May",8000]
[null,"Jun",8000]
[null,"Jul",10000]
[null,"Aug",11000]
[null,"Sep",15000]
[]
[]
["Assumptions (Formula Inputs)",null,null,"Assumptions (Formula Inputs)"]
["Expense 1",0.1,null,"Expense 1","Expense 2","Expense 3","Expense 4","Expense 5","Expense 6","Expense 7"]
["Expense 2",0.05,null,0.1,0.05,0.12,4.4999999999999998E-2,0.21,0.04,0.03]
["Expense 3",0.12]
["Expense 4",4.4999999999999998E-2]
["Expense 5",0.21]
["Expense 6",0.04]
["Expense 7",0.03]

{"sheet":"(9an)","index":17,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["In the green cells create a formula that calculates the expenses as a percent of Income."]
[]
[null,"Month","Income",{"$f":"D16","v":"Expense 1"},{"$f":"E16","v":"Expense 2"},{"$f":"F16","v":"Expense 3"},{"$f":"G16","v":"Expense 4"},{"$f":"H16","v":"Expense 5"},{"$f":"I16","v":"Expense 6"},{"$f":"J16","v":"Expense 7"}]
[null,"Jan",5000,{"$f":"$C4*D$17","v":500},250,600,225,1050,200,150]
[null,"Feb",6000,600,300,720,270,1260,240,180]
[null,"Mar",7500,750,375,900,337.5,1575,300,225]
[null,"Apr",8000,800,400,960,360,1680,320,240]
[null,"May",8000,800,400,960,360,1680,320,240]
[null,"Jun",8000,800,400,960,360,1680,320,240]
[null,"Jul",10000,1000,500,1200,450,2100,400,300]
[null,"Aug",11000,1100,550,1320,495,2310,440,330]
[null,"Sep",15000,1500,750,1800,675,3150,600,450]
[]
[]
["Assumptions (Formula Inputs)",null,null,"Assumptions (Formula Inputs)"]
["Expense 1",0.1,null,"Expense 1","Expense 2","Expense 3","Expense 4","Expense 5","Expense 6","Expense 7"]
["Expense 2",0.05,null,0.1,0.05,0.12,4.4999999999999998E-2,0.21,0.04,0.03]
["Expense 3",0.12]
["Expense 4",4.4999999999999998E-2]
["Expense 5",0.21]
["Expense 6",0.04]
["Expense 7",0.03]

{"sheet":"Sheet3","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}