{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Topics","RibbonQAT","Keyboards","Keyboards (an)","Calcs and Data Analysis","Calcs and Data Analysis (an)","Default Alignment","Default Alignment (an)","ExcelTables","ExcelTables (an)","PT 1 (an)","HW ==>>","HW(1)","HW(1an)","HW(2)","PT-HW-2-Answer","HW(3)","HW(3an)","HW(4)","HW(4an)","HW(5)","HW(5an)"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":4},"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":"Topics","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Topics","Video #"]
["Ribbons and QAT",5]
["Keyboard Shortcuts",6]
["What does excel do: 1) Calculations and 2) Data Analysis",7]
["Data In Excel and Default Alignment",8]
["Keeping Data in Excel: Proper Data Set or Excel Table",9]

{"sheet":"RibbonQAT","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Video #23: Excel 2013 Basics 05"]
["Ribbon and QAT"]
[]
["Name","Quiz 01","Quiz 02","Quiz 03","Test 1","Test 2","Test 3","Total","% Grade"]
["Max",20,20,20,100,100,100,{"$f":"SUM(B5:G5)","v":360},{"$f":"H5/H5","v":1}]
["Sioux",15,9,15,87,59,98,{"$f":"SUM(B6:G6)","v":283},{"$f":"H6/$H$5","v":0.78611111111111109}]
["Phil",16,8,14,92,68,92,{"$f":"SUM(B7:G7)","v":290},0.80555555555555558]
["Tom",12,15,18,78,67,97,287,0.79722222222222228]
["Chin",16,16,19,65,72,88,276,0.76666666666666672]
["Shelia",11,13,18,74,81,87,284,0.78888888888888886]
["Mo",18,19,19,89,79,75,299,0.8305555555555556]
["Gigi",20,8,15,92,75,92,{"$f":"SUM(B12:G12)","v":302},{"$f":"H12/$H$5","v":0.83888888888888891}]
["Average",{"$f":"AVERAGE(B6:B12)","v":15.428571428571429},{"$f":"AVERAGE(C6:C12)","v":12.571428571428571},{"$f":"AVERAGE(D6:D12)","v":16.857142857142858},82.428571428571431,71.571428571428569,{"$f":"AVERAGE(G6:G12)","v":89.857142857142861},{"$f":"AVERAGE(H6:H12)","v":288.71428571428572},0.80198412698412702]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"GEOMEAN(1+I6:I12)-1","v":0.80183047248323636},"Geometric Mean"]

{"sheet":"Keyboards","index":2,"n_rows":602,"n_cols":7,"rows_kept":602,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Video #24: Excel 2013 Basics 06:"]
["Keyboard Shortcuts Are Fast! My Favorite 10 Excel Keyboards"]
[]
["Reminder:"]
["Ctrl Selection trick",null,"Ctrl + C    means you hold keys simultaneously"]
["Shift Selection trick",null,"Alt, P, S, P     means you hit keys in succession"]
[]
["10 Favorites:"]
["Ctrl + Arrow Key   ==>> Jump to end. If all empty, jump to last empty"]
["Ctrl + Home   ==>> Go To A1"]
["Ctrl + Shift + Arrow Key   ==>> Select column or row (go until it sees an empty cell). Works in cells, formulas, dialog boxes."]
["Alt, 1    ==>> get first command in QAT"]
["Ctrl + *   ==>> Select Current Region (go in all directions until it sees an empty cells)"]
["Alt + =      ==>> SUM function"]
["Shift + Enter     ==>> Puts \"Thing\" in cell and moves selected cell up (above cell with formula).."]
["F4 = puts dollar signs in cell references. And it jumps screen back in view."]
["Alt, N, V   ==>>  PivotTable dialog box  "]
["Alt, P, S, P    ==>> Page Setup"]
[]
["Date","Region","SalesRep","Sales",null,"Total"]
["2013-10-21","West","Tyrone",519]
["2013-10-25","West","Tyrone",651]
["2013-10-26","West","Tyrone",618,null,"Date","Total"]
["2013-10-23","Northwest","Chin",335,null,"2013-10-20"]
["2013-10-20","Northwest","Tyrone",640,null,"2013-10-21"]
["2013-10-23","Southwest","Tyrone",586,null,"2013-10-22"]
["2013-10-21","West","Gigi",301,null,"2013-10-23"]
["2013-10-25","Southwest","Chin",359,null,"2013-10-24"]
["2013-10-20","West","Chin",658,null,"2013-10-25"]
["2013-10-21","Southwest","Tyrone",213]
["2013-10-25","Southwest","Chin",500]
["2013-10-22","Northwest","Tyrone",604]
["2013-10-23","West","Tyrone",340]
["2013-10-21","Northwest","Chin",117]
["2013-10-25","Southwest","Gigi",234]
["2013-10-20","West","Gigi",225]
["2013-10-25","Southwest","Tyrone",302]
["2013-10-24","Northwest","Tyrone",223]
["2013-10-22","West","Chin",401]
["2013-10-24","West","Chin",405]
["2013-10-21","Northwest","Tyrone",493]
["2013-10-21","Southwest","Tyrone",214]
["2013-10-22","Southwest","Tyrone",366]
["2013-10-22","Northwest","Tyrone",191]
["2013-10-25","West","Tyrone",628]
["2013-10-26","West","Gigi",144]
["2013-10-26","Southwest","Tyrone",335]
["2013-10-22","Southwest","Chin",571]
["2013-10-25","Southwest","Chin",136]
["2013-10-25","Northwest","Gigi",201]
["2013-10-23","Northwest","Chin",339]
["2013-10-25","Northwest","Tyrone",203]
["2013-10-21","West","Gigi",526]
["2013-10-25","West","Chin",86]
["2013-10-24","Southwest","Tyrone",388]
["2013-10-25","Northwest","Chin",119]
["2013-10-21","West","Gigi",296]
["2013-10-21","Northwest","Chin",295]
["2013-10-21","Northwest","Gigi",120]
["2013-10-21","West","Gigi",647]
["2013-10-22","Northwest","Tyrone",159]
["2013-10-23","Northwest","Chin",217]
["2013-10-24","Southwest","Tyrone",362]
["2013-10-26","Southwest","Gigi",599]
["2013-10-25","West","Tyrone",546]
["2013-10-25","Northwest","Gigi",254]
["2013-10-20","West","Tyrone",101]
["2013-10-26","Southwest","Chin",150]
["2013-10-25","Southwest","Gigi",204]
["2013-10-24","Southwest","Tyrone",106]
["2013-10-21","West","Tyrone",333]
["2013-10-24","Northwest","Gigi",67]
["2013-10-20","Northwest","Gigi",51]
["2013-10-21","Southwest","Gigi",279]
["2013-10-24","Southwest","Tyrone",123]
["2013-10-21","West","Chin",519]
["2013-10-22","Northwest","Chin",501]
["2013-10-26","West","Gigi",235]
["2013-10-23","Southwest","Tyrone",35]
["2013-10-23","West","Gigi",319]
["2013-10-24","Northwest","Chin",551]
["2013-10-26","Southwest","Chin",188]
["2013-10-25","West","Tyrone",129]
["2013-10-20","West","Gigi",339]
["2013-10-21","Southwest","Chin",485]
["2013-10-20","West","Tyrone",29]
["2013-10-20","Southwest","Tyrone",135]
["2013-10-26","Southwest","Tyrone",584]
["2013-10-23","Northwest","Tyrone",684]
["2013-10-23","West","Gigi",528]
["2013-10-26","Southwest","Tyrone",675]
["2013-10-23","West","Gigi",119]
["2013-10-22","West","Gigi",368]
["2013-10-24","Southwest","Gigi",524]
["2013-10-24","Southwest","Gigi",329]
["2013-10-26","West","Gigi",146]
["2013-10-26","Northwest","Tyrone",350]
["2013-10-23","Southwest","Chin",387]
["2013-10-20","Southwest","Gigi",244]
["2013-10-23","Southwest","Gigi",388]
["2013-10-20","Southwest","Tyrone",449]
["2013-10-22","West","Tyrone",477]
["2013-10-23","Southwest","Chin",457]
["2013-10-26","Southwest","Tyrone",105]
["2013-10-22","West","Tyrone",458]
["2013-10-26","Northwest","Chin",110]
["2013-10-21","West","Tyrone",32]
["2013-10-24","West","Chin",681]
["2013-10-23","Northwest","Gigi",320]
["2013-10-25","Northwest","Chin",601]
["2013-10-25","Southwest","Gigi",101]
["2013-10-23","Northwest","Gigi",172]
["2013-10-20","West","Chin",197]
["2013-10-22","West","Chin",346]
["2013-10-26","West","Chin",318]
["2013-10-21","West","Gigi",245]
["2013-10-25","Southwest","Chin",498]
["2013-10-26","Southwest","Tyrone",272]
["2013-10-21","Southwest","Chin",424]
["2013-10-26","Northwest","Chin",122]
["2013-10-23","Southwest","Tyrone",39]
["2013-10-21","Southwest","Gigi",400]
["2013-10-26","West","Chin",416]
["2013-10-20","Southwest","Tyrone",397]
["2013-10-25","Northwest","Gigi",671]
["2013-10-25","Southwest","Gigi",148]
["2013-10-21","Northwest","Tyrone",115]
["2013-10-25","Northwest","Tyrone",639]
["2013-10-24","Southwest","Tyrone",659]
["2013-10-22","West","Tyrone",36]
["2013-10-21","Northwest","Tyrone",102]
["2013-10-22","West","Chin",413]
["2013-10-25","West","Chin",166]
["2013-10-22","West","Chin",97]
["2013-10-26","West","Tyrone",127]
["2013-10-20","Northwest","Gigi",60]
["2013-10-22","Southwest","Gigi",496]
["2013-10-23","Northwest","Gigi",204]
["2013-10-26","Northwest","Gigi",489]
["2013-10-20","West","Tyrone",266]
["2013-10-20","Northwest","Chin",364]
["2013-10-20","Northwest","Chin",579]
["2013-10-21","West","Gigi",587]
["2013-10-26","West","Gigi",543]
["2013-10-22","Northwest","Chin",644]
["2013-10-20","West","Gigi",564]
["2013-10-22","Southwest","Gigi",149]
["2013-10-23","Southwest","Chin",201]
["2013-10-25","West","Chin",51]
["2013-10-23","West","Tyrone",195]
["2013-10-26","Northwest","Chin",660]
["2013-10-21","Northwest","Gigi",523]
["2013-10-23","West","Tyrone",649]
["2013-10-25","Southwest","Tyrone",409]
["2013-10-20","Northwest","Tyrone",556]
["2013-10-22","Northwest","Chin",565]
["2013-10-20","Southwest","Tyrone",357]
["2013-10-25","West","Gigi",219]
["2013-10-25","Northwest","Gigi",327]
["2013-10-20","Southwest","Chin",666]
["2013-10-20","Northwest","Tyrone",290]
["2013-10-24","Northwest","Tyrone",64]
["2013-10-24","West","Chin",373]
["2013-10-26","Northwest","Gigi",249]
["2013-10-20","Northwest","Tyrone",237]
["2013-10-22","West","Chin",138]
["2013-10-26","West","Chin",324]
["2013-10-22","Southwest","Gigi",633]
["2013-10-26","Southwest","Gigi",240]
["2013-10-20","Southwest","Tyrone",615]
["2013-10-22","Southwest","Tyrone",180]
["2013-10-25","West","Chin",415]
["2013-10-22","West","Tyrone",305]
["2013-10-25","Northwest","Chin",657]
["2013-10-23","West","Gigi",474]
["2013-10-22","West","Gigi",611]
["2013-10-21","West","Chin",682]
["2013-10-24","Northwest","Chin",398]
["2013-10-23","Northwest","Tyrone",74]
["2013-10-24","West","Gigi",243]
["2013-10-25","West","Chin",151]
["2013-10-25","Northwest","Chin",174]
["2013-10-24","Northwest","Chin",304]
["2013-10-20","West","Tyrone",457]
["2013-10-20","Southwest","Chin",315]
["2013-10-23","Northwest","Tyrone",295]
["2013-10-22","Northwest","Tyrone",534]
["2013-10-23","West","Chin",598]
["2013-10-24","Southwest","Gigi",14]
["2013-10-22","Southwest","Chin",26]
["2013-10-23","West","Gigi",108]
["2013-10-22","West","Tyrone",114]
["2013-10-26","Northwest","Chin",684]
["2013-10-25","West","Gigi",258]
["2013-10-21","Northwest","Tyrone",439]
["2013-10-26","Northwest","Tyrone",583]
["2013-10-25","West","Tyrone",664]
["2013-10-24","West","Tyrone",339]
["2013-10-24","Northwest","Chin",164]
["2013-10-22","Southwest","Tyrone",671]
["2013-10-23","Southwest","Gigi",241]
["2013-10-24","West","Chin",257]
["2013-10-23","Northwest","Chin",264]
["2013-10-26","West","Tyrone",471]
["2013-10-21","Northwest","Tyrone",40]
["2013-10-22","West","Tyrone",594]
["2013-10-21","West","Chin",605]
["2013-10-24","West","Gigi",409]
["2013-10-21","Northwest","Tyrone",250]
["2013-10-22","Southwest","Chin",481]
["2013-10-25","West","Chin",529]
["2013-10-24","Southwest","Gigi",56]
["2013-10-23","West","Tyrone",82]
["2013-10-26","West","Tyrone",575]
["2013-10-22","West","Chin",665]
["2013-10-25","West","Gigi",490]
["2013-10-23","Southwest","Tyrone",630]
["2013-10-25","Southwest","Gigi",352]
["2013-10-23","Southwest","Gigi",269]
["2013-10-22","Southwest","Chin",200]
["2013-10-23","West","Chin",329]
["2013-10-24","West","Gigi",605]
["2013-10-22","West","Gigi",340]
["2013-10-22","West","Tyrone",456]
["2013-10-22","West","Tyrone",368]
["2013-10-22","Northwest","Tyrone",510]
["2013-10-21","Northwest","Chin",63]
["2013-10-23","Northwest","Tyrone",359]
["2013-10-20","West","Tyrone",138]
["2013-10-26","Northwest","Gigi",35]
["2013-10-26","Southwest","Tyrone",386]
["2013-10-26","Southwest","Gigi",73]
["2013-10-25","Northwest","Tyrone",389]
["2013-10-26","West","Gigi",321]
["2013-10-24","Northwest","Tyrone",175]
["2013-10-25","Southwest","Gigi",438]
["2013-10-20","Southwest","Gigi",622]
["2013-10-21","Southwest","Tyrone",612]
["2013-10-24","Southwest","Tyrone",404]
["2013-10-26","Southwest","Tyrone",632]
["2013-10-22","Northwest","Tyrone",20]
["2013-10-20","West","Tyrone",264]
["2013-10-20","Northwest","Gigi",656]
["2013-10-21","Northwest","Tyrone",391]
["2013-10-20","Southwest","Gigi",686]
["2013-10-26","Northwest","Chin",466]
["2013-10-22","West","Chin",661]
["2013-10-21","Southwest","Tyrone",654]
["2013-10-22","West","Chin",661]
["2013-10-25","West","Gigi",202]
["2013-10-23","West","Tyrone",335]
["2013-10-24","Southwest","Gigi",181]
["2013-10-23","West","Chin",370]
["2013-10-23","West","Gigi",608]
["2013-10-26","West","Tyrone",74]
["2013-10-21","Southwest","Chin",349]
["2013-10-23","Northwest","Tyrone",77]
["2013-10-20","Southwest","Chin",77]
["2013-10-26","Southwest","Gigi",639]
["2013-10-26","Southwest","Chin",97]
["2013-10-24","Northwest","Gigi",56]
["2013-10-22","Southwest","Tyrone",22]
["2013-10-22","West","Chin",306]
["2013-10-25","Northwest","Gigi",329]
["2013-10-20","West","Chin",95]
["2013-10-25","Southwest","Gigi",270]
["2013-10-26","Southwest","Tyrone",648]
["2013-10-24","Northwest","Tyrone",169]
["2013-10-21","West","Chin",488]
["2013-10-22","Northwest","Gigi",353]
["2013-10-22","West","Chin",613]
["2013-10-23","West","Tyrone",664]
["2013-10-23","West","Gigi",343]
["2013-10-24","Southwest","Tyrone",318]
["2013-10-26","Northwest","Gigi",294]
["2013-10-23","Northwest","Chin",295]
["2013-10-26","Northwest","Gigi",197]
["2013-10-21","Northwest","Gigi",682]
["2013-10-23","West","Chin",147]
["2013-10-24","West","Tyrone",662]
["2013-10-25","Northwest","Tyrone",482]
["2013-10-24","Southwest","Gigi",503]
["2013-10-24","West","Gigi",190]
["2013-10-25","Southwest","Chin",477]
["2013-10-21","Southwest","Tyrone",630]
["2013-10-21","West","Tyrone",576]
["2013-10-25","West","Gigi",43]
["2013-10-22","Southwest","Tyrone",460]
["2013-10-20","West","Gigi",347]
["2013-10-23","Northwest","Chin",245]
["2013-10-26","West","Gigi",303]
["2013-10-22","Southwest","Chin",60]
["2013-10-23","Northwest","Gigi",191]
["2013-10-24","Southwest","Chin",550]
["2013-10-20","Northwest","Chin",222]
["2013-10-24","Southwest","Gigi",213]
["2013-10-26","Southwest","Tyrone",28]
["2013-10-22","West","Tyrone",552]
["2013-10-23","West","Tyrone",608]
["2013-10-25","West","Gigi",308]
["2013-10-22","Southwest","Chin",56]
["2013-10-26","Southwest","Tyrone",303]
["2013-10-22","West","Tyrone",561]
["2013-10-20","Southwest","Gigi",264]
["2013-10-20","Southwest","Tyrone",249]
["2013-10-25","Northwest","Tyrone",259]
["2013-10-26","Northwest","Chin",609]
["2013-10-21","Northwest","Gigi",213]
["2013-10-21","West","Chin",301]
["2013-10-26","Southwest","Gigi",359]
["2013-10-26","West","Tyrone",18]
["2013-10-20","Southwest","Tyrone",98]
["2013-10-22","Northwest","Chin",274]
["2013-10-24","Southwest","Gigi",466]
["2013-10-20","Northwest","Gigi",65]
["2013-10-21","Northwest","Chin",638]
["2013-10-23","West","Gigi",73]
["2013-10-20","West","Tyrone",89]
["2013-10-22","West","Gigi",154]
["2013-10-20","West","Chin",209]
["2013-10-23","West","Chin",296]
["2013-10-25","Northwest","Chin",564]
["2013-10-25","Southwest","Tyrone",338]
["2013-10-25","Northwest","Tyrone",428]
["2013-10-26","Northwest","Gigi",24]
["2013-10-22","Southwest","Chin",353]
["2013-10-26","West","Gigi",645]
["2013-10-26","Southwest","Gigi",466]
["2013-10-22","West","Chin",37]
["2013-10-25","Northwest","Gigi",367]
["2013-10-22","Southwest","Chin",295]
["2013-10-23","Southwest","Chin",178]
["2013-10-21","West","Chin",56]
["2013-10-26","West","Gigi",227]
["2013-10-24","Southwest","Tyrone",215]
["2013-10-24","West","Tyrone",506]
["2013-10-26","Northwest","Gigi",215]
["2013-10-20","Southwest","Chin",237]
["2013-10-22","West","Gigi",296]
["2013-10-25","West","Gigi",302]
["2013-10-23","Southwest","Gigi",622]
["2013-10-21","West","Chin",312]
["2013-10-24","West","Tyrone",304]
["2013-10-23","Southwest","Tyrone",158]
["2013-10-25","West","Chin",569]
["2013-10-23","Northwest","Chin",545]
["2013-10-26","Southwest","Chin",111]
["2013-10-22","West","Gigi",227]
["2013-10-21","Northwest","Tyrone",340]
["2013-10-25","West","Chin",123]
["2013-10-20","West","Chin",229]
["2013-10-24","Northwest","Gigi",618]
["2013-10-24","Southwest","Gigi",65]
["2013-10-21","West","Chin",19]
["2013-10-26","Southwest","Gigi",72]
["2013-10-26","West","Chin",103]
["2013-10-25","West","Chin",658]
["2013-10-22","Southwest","Gigi",523]
["2013-10-21","Northwest","Tyrone",338]
["2013-10-25","Northwest","Gigi",33]
["2013-10-26","West","Tyrone",553]
["2013-10-25","Northwest","Gigi",346]
["2013-10-22","Northwest","Chin",125]
["2013-10-21","West","Tyrone",241]
["2013-10-22","West","Chin",316]
["2013-10-20","Northwest","Gigi",392]
["2013-10-26","West","Tyrone",644]
["2013-10-24","Northwest","Chin",259]
["2013-10-21","West","Chin",488]
["2013-10-22","Northwest","Chin",299]
["2013-10-21","Northwest","Tyrone",36]
["2013-10-22","Southwest","Chin",83]
["2013-10-25","Southwest","Chin",80]
["2013-10-22","Southwest","Tyrone",349]
["2013-10-22","West","Gigi",342]
["2013-10-24","West","Tyrone",540]
["2013-10-22","Southwest","Tyrone",411]
["2013-10-21","West","Tyrone",632]
["2013-10-25","West","Chin",175]
["2013-10-21","Southwest","Chin",606]
["2013-10-21","Northwest","Chin",658]
["2013-10-25","Southwest","Chin",268]
["2013-10-20","Northwest","Chin",556]
["2013-10-22","Northwest","Tyrone",208]
["2013-10-25","Southwest","Tyrone",559]
["2013-10-26","Southwest","Chin",530]
["2013-10-25","Southwest","Chin",663]
["2013-10-21","Northwest","Chin",31]
["2013-10-20","West","Chin",587]
["2013-10-23","Southwest","Tyrone",280]
["2013-10-20","Northwest","Tyrone",488]
["2013-10-25","Southwest","Tyrone",609]
["2013-10-26","Northwest","Tyrone",375]
["2013-10-25","Northwest","Chin",474]
["2013-10-23","Southwest","Tyrone",323]
["2013-10-26","Southwest","Gigi",650]
["2013-10-21","Northwest","Tyrone",505]
["2013-10-20","Southwest","Gigi",114]
["2013-10-20","Southwest","Chin",483]
["2013-10-22","West","Gigi",444]
["2013-10-26","Southwest","Chin",642]
["2013-10-22","Southwest","Chin",241]
["2013-10-24","Southwest","Gigi",444]
["2013-10-23","Northwest","Chin",270]
["2013-10-23","Northwest","Gigi",608]
["2013-10-26","West","Chin",498]
["2013-10-21","Northwest","Gigi",100]
["2013-10-22","Northwest","Gigi",379]
["2013-10-22","Southwest","Gigi",332]
["2013-10-26","Northwest","Gigi",13]
["2013-10-26","Southwest","Tyrone",456]
["2013-10-21","Southwest","Gigi",249]
["2013-10-26","West","Chin",324]
["2013-10-22","West","Gigi",423]
["2013-10-20","West","Tyrone",220]
["2013-10-20","Southwest","Chin",47]
["2013-10-20","West","Tyrone",651]
["2013-10-21","West","Tyrone",89]
["2013-10-23","Southwest","Gigi",590]
["2013-10-24","Northwest","Tyrone",681]
["2013-10-20","Northwest","Chin",538]
["2013-10-20","West","Gigi",562]
["2013-10-24","Northwest","Gigi",97]
["2013-10-22","Southwest","Gigi",583]
["2013-10-25","Northwest","Tyrone",268]
["2013-10-26","Northwest","Chin",443]
["2013-10-26","West","Chin",455]
["2013-10-23","Southwest","Chin",663]
["2013-10-22","West","Gigi",518]
["2013-10-25","West","Gigi",621]
["2013-10-21","Northwest","Chin",645]
["2013-10-21","Southwest","Tyrone",131]
["2013-10-24","Southwest","Gigi",130]
["2013-10-26","West","Chin",415]
["2013-10-23","Southwest","Tyrone",119]
["2013-10-22","Southwest","Chin",307]
["2013-10-21","Southwest","Chin",472]
["2013-10-24","Southwest","Tyrone",136]
["2013-10-21","Northwest","Gigi",586]
["2013-10-22","West","Gigi",215]
["2013-10-22","Northwest","Tyrone",562]
["2013-10-21","Southwest","Gigi",662]
["2013-10-23","Southwest","Gigi",419]
["2013-10-24","West","Chin",508]
["2013-10-23","Southwest","Tyrone",170]
["2013-10-20","Southwest","Tyrone",586]
["2013-10-24","Southwest","Gigi",219]
["2013-10-24","Southwest","Chin",339]
["2013-10-24","Southwest","Chin",198]
["2013-10-23","Northwest","Chin",674]
["2013-10-21","Northwest","Gigi",399]
["2013-10-22","Northwest","Tyrone",615]
["2013-10-21","Northwest","Tyrone",107]
["2013-10-24","Northwest","Tyrone",199]
["2013-10-25","West","Chin",23]
["2013-10-20","Southwest","Tyrone",297]
["2013-10-20","Northwest","Tyrone",273]
["2013-10-26","West","Tyrone",281]
["2013-10-22","Southwest","Gigi",227]
["2013-10-26","Northwest","Chin",156]
["2013-10-25","Southwest","Chin",534]
["2013-10-22","Southwest","Gigi",459]
["2013-10-21","Southwest","Chin",131]
["2013-10-20","West","Chin",339]
["2013-10-21","Northwest","Gigi",634]
["2013-10-21","Northwest","Chin",450]
["2013-10-25","West","Chin",65]
["2013-10-26","Southwest","Chin",530]
["2013-10-22","Southwest","Gigi",74]
["2013-10-26","Southwest","Tyrone",93]
["2013-10-21","Northwest","Gigi",337]
["2013-10-20","Northwest","Gigi",583]
["2013-10-23","West","Tyrone",374]
["2013-10-22","Northwest","Chin",243]
["2013-10-21","West","Chin",225]
["2013-10-26","Southwest","Chin",160]
["2013-10-21","West","Tyrone",502]
["2013-10-25","Northwest","Tyrone",221]
["2013-10-21","Southwest","Gigi",516]
["2013-10-26","West","Chin",678]
["2013-10-22","Northwest","Tyrone",637]
["2013-10-21","Northwest","Tyrone",525]
["2013-10-25","Southwest","Chin",540]
["2013-10-23","West","Gigi",245]
["2013-10-20","Northwest","Chin",290]
["2013-10-21","Southwest","Tyrone",376]
["2013-10-22","Southwest","Chin",226]
["2013-10-26","Northwest","Tyrone",38]
["2013-10-23","Northwest","Gigi",283]
["2013-10-21","West","Tyrone",480]
["2013-10-21","West","Chin",482]
["2013-10-26","Southwest","Tyrone",37]
["2013-10-23","Southwest","Tyrone",279]
["2013-10-23","West","Tyrone",152]
["2013-10-20","Northwest","Gigi",419]
["2013-10-23","West","Tyrone",652]
["2013-10-21","Southwest","Chin",151]
["2013-10-20","Northwest","Chin",99]
["2013-10-25","Northwest","Tyrone",432]
["2013-10-21","Northwest","Tyrone",174]
["2013-10-23","Northwest","Chin",209]
["2013-10-23","Northwest","Gigi",261]
["2013-10-26","Southwest","Gigi",633]
["2013-10-26","West","Gigi",308]
["2013-10-26","West","Tyrone",319]
["2013-10-20","West","Tyrone",400]
["2013-10-24","West","Gigi",20]
["2013-10-26","Northwest","Chin",151]
["2013-10-21","Southwest","Tyrone",345]
["2013-10-24","Southwest","Tyrone",78]
["2013-10-23","West","Tyrone",81]
["2013-10-23","West","Chin",563]
["2013-10-20","Southwest","Tyrone",344]
["2013-10-23","West","Tyrone",103]
["2013-10-20","Southwest","Chin",378]
["2013-10-26","West","Gigi",546]
["2013-10-23","West","Gigi",649]
["2013-10-21","Northwest","Chin",387]
["2013-10-20","West","Chin",468]
["2013-10-22","Southwest","Tyrone",36]
["2013-10-23","Southwest","Tyrone",576]
["2013-10-24","Northwest","Gigi",304]
["2013-10-23","Northwest","Chin",648]
["2013-10-21","Southwest","Gigi",624]
["2013-10-23","Southwest","Gigi",199]
["2013-10-22","West","Tyrone",21]
["2013-10-23","Northwest","Tyrone",173]
["2013-10-23","Northwest","Chin",149]
["2013-10-24","West","Tyrone",294]
["2013-10-20","Southwest","Gigi",225]
["2013-10-22","Southwest","Chin",276]
["2013-10-22","Northwest","Chin",666]
["2013-10-23","West","Chin",616]
["2013-10-21","Northwest","Tyrone",307]
["2013-10-23","Southwest","Chin",140]
["2013-10-24","West","Gigi",632]
["2013-10-25","West","Chin",461]
["2013-10-21","West","Chin",656]
["2013-10-22","West","Gigi",158]
["2013-10-23","Northwest","Tyrone",663]
["2013-10-24","Southwest","Gigi",555]
["2013-10-23","West","Gigi",489]
["2013-10-22","West","Chin",212]
["2013-10-20","Southwest","Gigi",411]
["2013-10-23","Northwest","Chin",343]
["2013-10-22","West","Gigi",629]
["2013-10-21","Northwest","Gigi",247]
["2013-10-25","Southwest","Gigi",180]
["2013-10-25","Southwest","Chin",374]
["2013-10-22","West","Gigi",672]
["2013-10-25","Southwest","Chin",484]
["2013-10-26","Southwest","Chin",77]
["2013-10-26","West","Chin",315]
["2013-10-23","Southwest","Gigi",462]
["2013-10-22","Southwest","Tyrone",470]
["2013-10-20","West","Tyrone",102]
["2013-10-20","West","Tyrone",161]
["2013-10-21","Northwest","Gigi",651]
["2013-10-21","Northwest","Tyrone",28]
["2013-10-26","Northwest","Tyrone",222]
["2013-10-25","West","Tyrone",399]
["2013-10-22","Northwest","Gigi",570]
["2013-10-25","West","Chin",119]
["2013-10-24","Northwest","Gigi",219]
["2013-10-24","West","Gigi",466]
["2013-10-22","Southwest","Tyrone",225]
["2013-10-21","West","Chin",293]
["2013-10-23","Southwest","Chin",217]
["2013-10-25","Northwest","Gigi",547]
["2013-10-25","Northwest","Chin",449]
["2013-10-26","West","Chin",185]
["2013-10-26","Northwest","Gigi",579]
["2013-10-21","Northwest","Chin",675]
["2013-10-23","Southwest","Tyrone",239]
["2013-10-22","Northwest","Chin",152]
["2013-10-24","Northwest","Tyrone",210]
["2013-10-25","Southwest","Gigi",573]
["2013-10-26","West","Chin",19]
["2013-10-21","Southwest","Chin",478]
["2013-10-21","Northwest","Tyrone",565]
["2013-10-24","Southwest","Gigi",169]
["2013-10-24","Northwest","Tyrone",329]
["2013-10-24","Southwest","Tyrone",115]
["2013-10-20","Northwest","Gigi",524]
["2013-10-26","Southwest","Tyrone",550]
["2013-10-22","Southwest","Tyrone",514]
["2013-10-20","Southwest","Chin",223]
["2013-10-25","Southwest","Chin",667]
["2013-10-20","Southwest","Chin",314]
["2013-10-26","Northwest","Gigi",228]
["2013-10-22","Northwest","Chin",193]
["2013-10-26","West","Tyrone",509]
["2013-10-21","Northwest","Tyrone",529]
["2013-10-26","Northwest","Chin",416]
["2013-10-22","West","Gigi",532]
["2013-10-22","West","Chin",639]
["2013-10-22","Southwest","Chin",115]
["2013-10-20","West","Tyrone",145]
["2013-10-26","Northwest","Gigi",349]
["2013-10-24","Northwest","Chin",98]
["2013-10-24","Southwest","Tyrone",342]
["2013-10-20","Southwest","Chin",234]

{"sheet":"Keyboards (an)","index":3,"n_rows":602,"n_cols":7,"rows_kept":602,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Video #24: Excel 2013 Basics 06:"]
["Keyboard Shortcuts Are Fast! My Favorite 10 Excel Keyboards"]
[]
["Reminder:"]
["Ctrl Selection trick",null,"Ctrl + C    means you hold keys simultaneously"]
["Shift Selection trick",null,"Alt, P, S, P     means you hit keys in succession"]
[]
["10 Favorites:"]
["Ctrl + Arrow Key   ==>> Jump to end. If all empty, jump to last empty"]
["Ctrl + Home   ==>> Go To A1"]
["Ctrl + Shift + Arrow Key   ==>> Select column or row (go until it sees an empty cell). Works in cells, formulas, dialog boxes."]
["Alt, 1    ==>> get first command in QAT"]
["Ctrl + *   ==>> Select Current Region (go in all directions until it sees an empty cells)"]
["Alt + =      ==>> SUM function"]
["Shift + Enter     ==>> Puts \"Thing\" in cell and moves selected cell up (above cell with formula).."]
["F4 = puts dollar signs in cell references. And it jumps screen back in view."]
["Alt, N, V   ==>>  PivotTable dialog box  "]
["Alt, P, S, P    ==>> Page Setup"]
[]
["Date","Region","SalesRep","Sales",null,"Total"]
["2013-10-21","West","Tyrone",519,null,{"$f":"SUM(D21:D602)","v":203018}]
["2013-10-25","West","Tyrone",651]
["2013-10-26","West","Tyrone",618,null,"Date","Total"]
["2013-10-23","Northwest","Chin",335,null,"2013-10-20",{"$f":"SUMIFS($D$21:$D$602,$A$21:$A$602,F24)","v":24791}]
["2013-10-20","Northwest","Tyrone",640,null,"2013-10-21",{"$f":"SUMIFS($D$21:$D$602,$A$21:$A$602,F25)","v":33868}]
["2013-10-23","Southwest","Tyrone",586,null,"2013-10-22",34850]
["2013-10-21","West","Gigi",301,null,"2013-10-23",28873]
["2013-10-25","Southwest","Chin",359,null,"2013-10-24",20820]
["2013-10-20","West","Chin",658,null,"2013-10-25",28782]
["2013-10-21","Southwest","Tyrone",213]
["2013-10-25","Southwest","Chin",500]
["2013-10-22","Northwest","Tyrone",604,null,"Row Labels","Sum of Sales"]
["2013-10-23","West","Tyrone",340,null,"2013-10-20",24791]
["2013-10-21","Northwest","Chin",117,null,"2013-10-21",33868]
["2013-10-25","Southwest","Gigi",234,null,"2013-10-22",34850]
["2013-10-20","West","Gigi",225,null,"2013-10-23",28873]
["2013-10-25","Southwest","Tyrone",302,null,"2013-10-24",20820]
["2013-10-24","Northwest","Tyrone",223,null,"2013-10-25",28782]
["2013-10-22","West","Chin",401,null,"2013-10-26",31034]
["2013-10-24","West","Chin",405,null,"Grand Total",203018]
["2013-10-21","Northwest","Tyrone",493]
["2013-10-21","Southwest","Tyrone",214]
["2013-10-22","Southwest","Tyrone",366]
["2013-10-22","Northwest","Tyrone",191]
["2013-10-25","West","Tyrone",628]
["2013-10-26","West","Gigi",144]
["2013-10-26","Southwest","Tyrone",335]
["2013-10-22","Southwest","Chin",571]
["2013-10-25","Southwest","Chin",136]
["2013-10-25","Northwest","Gigi",201]
["2013-10-23","Northwest","Chin",339]
["2013-10-25","Northwest","Tyrone",203]
["2013-10-21","West","Gigi",526]
["2013-10-25","West","Chin",86]
["2013-10-24","Southwest","Tyrone",388]
["2013-10-25","Northwest","Chin",119]
["2013-10-21","West","Gigi",296]
["2013-10-21","Northwest","Chin",295]
["2013-10-21","Northwest","Gigi",120]
["2013-10-21","West","Gigi",647]
["2013-10-22","Northwest","Tyrone",159]
["2013-10-23","Northwest","Chin",217]
["2013-10-24","Southwest","Tyrone",362]
["2013-10-26","Southwest","Gigi",599]
["2013-10-25","West","Tyrone",546]
["2013-10-25","Northwest","Gigi",254]
["2013-10-20","West","Tyrone",101]
["2013-10-26","Southwest","Chin",150]
["2013-10-25","Southwest","Gigi",204]
["2013-10-24","Southwest","Tyrone",106]
["2013-10-21","West","Tyrone",333]
["2013-10-24","Northwest","Gigi",67]
["2013-10-20","Northwest","Gigi",51]
["2013-10-21","Southwest","Gigi",279]
["2013-10-24","Southwest","Tyrone",123]
["2013-10-21","West","Chin",519]
["2013-10-22","Northwest","Chin",501]
["2013-10-26","West","Gigi",235]
["2013-10-23","Southwest","Tyrone",35]
["2013-10-23","West","Gigi",319]
["2013-10-24","Northwest","Chin",551]
["2013-10-26","Southwest","Chin",188]
["2013-10-25","West","Tyrone",129]
["2013-10-20","West","Gigi",339]
["2013-10-21","Southwest","Chin",485]
["2013-10-20","West","Tyrone",29]
["2013-10-20","Southwest","Tyrone",135]
["2013-10-26","Southwest","Tyrone",584]
["2013-10-23","Northwest","Tyrone",684]
["2013-10-23","West","Gigi",528]
["2013-10-26","Southwest","Tyrone",675]
["2013-10-23","West","Gigi",119]
["2013-10-22","West","Gigi",368]
["2013-10-24","Southwest","Gigi",524]
["2013-10-24","Southwest","Gigi",329]
["2013-10-26","West","Gigi",146]
["2013-10-26","Northwest","Tyrone",350]
["2013-10-23","Southwest","Chin",387]
["2013-10-20","Southwest","Gigi",244]
["2013-10-23","Southwest","Gigi",388]
["2013-10-20","Southwest","Tyrone",449]
["2013-10-22","West","Tyrone",477]
["2013-10-23","Southwest","Chin",457]
["2013-10-26","Southwest","Tyrone",105]
["2013-10-22","West","Tyrone",458]
["2013-10-26","Northwest","Chin",110]
["2013-10-21","West","Tyrone",32]
["2013-10-24","West","Chin",681]
["2013-10-23","Northwest","Gigi",320]
["2013-10-25","Northwest","Chin",601]
["2013-10-25","Southwest","Gigi",101]
["2013-10-23","Northwest","Gigi",172]
["2013-10-20","West","Chin",197]
["2013-10-22","West","Chin",346]
["2013-10-26","West","Chin",318]
["2013-10-21","West","Gigi",245]
["2013-10-25","Southwest","Chin",498]
["2013-10-26","Southwest","Tyrone",272]
["2013-10-21","Southwest","Chin",424]
["2013-10-26","Northwest","Chin",122]
["2013-10-23","Southwest","Tyrone",39]
["2013-10-21","Southwest","Gigi",400]
["2013-10-26","West","Chin",416]
["2013-10-20","Southwest","Tyrone",397]
["2013-10-25","Northwest","Gigi",671]
["2013-10-25","Southwest","Gigi",148]
["2013-10-21","Northwest","Tyrone",115]
["2013-10-25","Northwest","Tyrone",639]
["2013-10-24","Southwest","Tyrone",659]
["2013-10-22","West","Tyrone",36]
["2013-10-21","Northwest","Tyrone",102]
["2013-10-22","West","Chin",413]
["2013-10-25","West","Chin",166]
["2013-10-22","West","Chin",97]
["2013-10-26","West","Tyrone",127]
["2013-10-20","Northwest","Gigi",60]
["2013-10-22","Southwest","Gigi",496]
["2013-10-23","Northwest","Gigi",204]
["2013-10-26","Northwest","Gigi",489]
["2013-10-20","West","Tyrone",266]
["2013-10-20","Northwest","Chin",364]
["2013-10-20","Northwest","Chin",579]
["2013-10-21","West","Gigi",587]
["2013-10-26","West","Gigi",543]
["2013-10-22","Northwest","Chin",644]
["2013-10-20","West","Gigi",564]
["2013-10-22","Southwest","Gigi",149]
["2013-10-23","Southwest","Chin",201]
["2013-10-25","West","Chin",51]
["2013-10-23","West","Tyrone",195]
["2013-10-26","Northwest","Chin",660]
["2013-10-21","Northwest","Gigi",523]
["2013-10-23","West","Tyrone",649]
["2013-10-25","Southwest","Tyrone",409]
["2013-10-20","Northwest","Tyrone",556]
["2013-10-22","Northwest","Chin",565]
["2013-10-20","Southwest","Tyrone",357]
["2013-10-25","West","Gigi",219]
["2013-10-25","Northwest","Gigi",327]
["2013-10-20","Southwest","Chin",666]
["2013-10-20","Northwest","Tyrone",290]
["2013-10-24","Northwest","Tyrone",64]
["2013-10-24","West","Chin",373]
["2013-10-26","Northwest","Gigi",249]
["2013-10-20","Northwest","Tyrone",237]
["2013-10-22","West","Chin",138]
["2013-10-26","West","Chin",324]
["2013-10-22","Southwest","Gigi",633]
["2013-10-26","Southwest","Gigi",240]
["2013-10-20","Southwest","Tyrone",615]
["2013-10-22","Southwest","Tyrone",180]
["2013-10-25","West","Chin",415]
["2013-10-22","West","Tyrone",305]
["2013-10-25","Northwest","Chin",657]
["2013-10-23","West","Gigi",474]
["2013-10-22","West","Gigi",611]
["2013-10-21","West","Chin",682]
["2013-10-24","Northwest","Chin",398]
["2013-10-23","Northwest","Tyrone",74]
["2013-10-24","West","Gigi",243]
["2013-10-25","West","Chin",151]
["2013-10-25","Northwest","Chin",174]
["2013-10-24","Northwest","Chin",304]
["2013-10-20","West","Tyrone",457]
["2013-10-20","Southwest","Chin",315]
["2013-10-23","Northwest","Tyrone",295]
["2013-10-22","Northwest","Tyrone",534]
["2013-10-23","West","Chin",598]
["2013-10-24","Southwest","Gigi",14]
["2013-10-22","Southwest","Chin",26]
["2013-10-23","West","Gigi",108]
["2013-10-22","West","Tyrone",114]
["2013-10-26","Northwest","Chin",684]
["2013-10-25","West","Gigi",258]
["2013-10-21","Northwest","Tyrone",439]
["2013-10-26","Northwest","Tyrone",583]
["2013-10-25","West","Tyrone",664]
["2013-10-24","West","Tyrone",339]
["2013-10-24","Northwest","Chin",164]
["2013-10-22","Southwest","Tyrone",671]
["2013-10-23","Southwest","Gigi",241]
["2013-10-24","West","Chin",257]
["2013-10-23","Northwest","Chin",264]
["2013-10-26","West","Tyrone",471]
["2013-10-21","Northwest","Tyrone",40]
["2013-10-22","West","Tyrone",594]
["2013-10-21","West","Chin",605]
["2013-10-24","West","Gigi",409]
["2013-10-21","Northwest","Tyrone",250]
["2013-10-22","Southwest","Chin",481]
["2013-10-25","West","Chin",529]
["2013-10-24","Southwest","Gigi",56]
["2013-10-23","West","Tyrone",82]
["2013-10-26","West","Tyrone",575]
["2013-10-22","West","Chin",665]
["2013-10-25","West","Gigi",490]
["2013-10-23","Southwest","Tyrone",630]
["2013-10-25","Southwest","Gigi",352]
["2013-10-23","Southwest","Gigi",269]
["2013-10-22","Southwest","Chin",200]
["2013-10-23","West","Chin",329]
["2013-10-24","West","Gigi",605]
["2013-10-22","West","Gigi",340]
["2013-10-22","West","Tyrone",456]
["2013-10-22","West","Tyrone",368]
["2013-10-22","Northwest","Tyrone",510]
["2013-10-21","Northwest","Chin",63]
["2013-10-23","Northwest","Tyrone",359]
["2013-10-20","West","Tyrone",138]
["2013-10-26","Northwest","Gigi",35]
["2013-10-26","Southwest","Tyrone",386]
["2013-10-26","Southwest","Gigi",73]
["2013-10-25","Northwest","Tyrone",389]
["2013-10-26","West","Gigi",321]
["2013-10-24","Northwest","Tyrone",175]
["2013-10-25","Southwest","Gigi",438]
["2013-10-20","Southwest","Gigi",622]
["2013-10-21","Southwest","Tyrone",612]
["2013-10-24","Southwest","Tyrone",404]
["2013-10-26","Southwest","Tyrone",632]
["2013-10-22","Northwest","Tyrone",20]
["2013-10-20","West","Tyrone",264]
["2013-10-20","Northwest","Gigi",656]
["2013-10-21","Northwest","Tyrone",391]
["2013-10-20","Southwest","Gigi",686]
["2013-10-26","Northwest","Chin",466]
["2013-10-22","West","Chin",661]
["2013-10-21","Southwest","Tyrone",654]
["2013-10-22","West","Chin",661]
["2013-10-25","West","Gigi",202]
["2013-10-23","West","Tyrone",335]
["2013-10-24","Southwest","Gigi",181]
["2013-10-23","West","Chin",370]
["2013-10-23","West","Gigi",608]
["2013-10-26","West","Tyrone",74]
["2013-10-21","Southwest","Chin",349]
["2013-10-23","Northwest","Tyrone",77]
["2013-10-20","Southwest","Chin",77]
["2013-10-26","Southwest","Gigi",639]
["2013-10-26","Southwest","Chin",97]
["2013-10-24","Northwest","Gigi",56]
["2013-10-22","Southwest","Tyrone",22]
["2013-10-22","West","Chin",306]
["2013-10-25","Northwest","Gigi",329]
["2013-10-20","West","Chin",95]
["2013-10-25","Southwest","Gigi",270]
["2013-10-26","Southwest","Tyrone",648]
["2013-10-24","Northwest","Tyrone",169]
["2013-10-21","West","Chin",488]
["2013-10-22","Northwest","Gigi",353]
["2013-10-22","West","Chin",613]
["2013-10-23","West","Tyrone",664]
["2013-10-23","West","Gigi",343]
["2013-10-24","Southwest","Tyrone",318]
["2013-10-26","Northwest","Gigi",294]
["2013-10-23","Northwest","Chin",295]
["2013-10-26","Northwest","Gigi",197]
["2013-10-21","Northwest","Gigi",682]
["2013-10-23","West","Chin",147]
["2013-10-24","West","Tyrone",662]
["2013-10-25","Northwest","Tyrone",482]
["2013-10-24","Southwest","Gigi",503]
["2013-10-24","West","Gigi",190]
["2013-10-25","Southwest","Chin",477]
["2013-10-21","Southwest","Tyrone",630]
["2013-10-21","West","Tyrone",576]
["2013-10-25","West","Gigi",43]
["2013-10-22","Southwest","Tyrone",460]
["2013-10-20","West","Gigi",347]
["2013-10-23","Northwest","Chin",245]
["2013-10-26","West","Gigi",303]
["2013-10-22","Southwest","Chin",60]
["2013-10-23","Northwest","Gigi",191]
["2013-10-24","Southwest","Chin",550]
["2013-10-20","Northwest","Chin",222]
["2013-10-24","Southwest","Gigi",213]
["2013-10-26","Southwest","Tyrone",28]
["2013-10-22","West","Tyrone",552]
["2013-10-23","West","Tyrone",608]
["2013-10-25","West","Gigi",308]
["2013-10-22","Southwest","Chin",56]
["2013-10-26","Southwest","Tyrone",303]
["2013-10-22","West","Tyrone",561]
["2013-10-20","Southwest","Gigi",264]
["2013-10-20","Southwest","Tyrone",249]
["2013-10-25","Northwest","Tyrone",259]
["2013-10-26","Northwest","Chin",609]
["2013-10-21","Northwest","Gigi",213]
["2013-10-21","West","Chin",301]
["2013-10-26","Southwest","Gigi",359]
["2013-10-26","West","Tyrone",18]
["2013-10-20","Southwest","Tyrone",98]
["2013-10-22","Northwest","Chin",274]
["2013-10-24","Southwest","Gigi",466]
["2013-10-20","Northwest","Gigi",65]
["2013-10-21","Northwest","Chin",638]
["2013-10-23","West","Gigi",73]
["2013-10-20","West","Tyrone",89]
["2013-10-22","West","Gigi",154]
["2013-10-20","West","Chin",209]
["2013-10-23","West","Chin",296]
["2013-10-25","Northwest","Chin",564]
["2013-10-25","Southwest","Tyrone",338]
["2013-10-25","Northwest","Tyrone",428]
["2013-10-26","Northwest","Gigi",24]
["2013-10-22","Southwest","Chin",353]
["2013-10-26","West","Gigi",645]
["2013-10-26","Southwest","Gigi",466]
["2013-10-22","West","Chin",37]
["2013-10-25","Northwest","Gigi",367]
["2013-10-22","Southwest","Chin",295]
["2013-10-23","Southwest","Chin",178]
["2013-10-21","West","Chin",56]
["2013-10-26","West","Gigi",227]
["2013-10-24","Southwest","Tyrone",215]
["2013-10-24","West","Tyrone",506]
["2013-10-26","Northwest","Gigi",215]
["2013-10-20","Southwest","Chin",237]
["2013-10-22","West","Gigi",296]
["2013-10-25","West","Gigi",302]
["2013-10-23","Southwest","Gigi",622]
["2013-10-21","West","Chin",312]
["2013-10-24","West","Tyrone",304]
["2013-10-23","Southwest","Tyrone",158]
["2013-10-25","West","Chin",569]
["2013-10-23","Northwest","Chin",545]
["2013-10-26","Southwest","Chin",111]
["2013-10-22","West","Gigi",227]
["2013-10-21","Northwest","Tyrone",340]
["2013-10-25","West","Chin",123]
["2013-10-20","West","Chin",229]
["2013-10-24","Northwest","Gigi",618]
["2013-10-24","Southwest","Gigi",65]
["2013-10-21","West","Chin",19]
["2013-10-26","Southwest","Gigi",72]
["2013-10-26","West","Chin",103]
["2013-10-25","West","Chin",658]
["2013-10-22","Southwest","Gigi",523]
["2013-10-21","Northwest","Tyrone",338]
["2013-10-25","Northwest","Gigi",33]
["2013-10-26","West","Tyrone",553]
["2013-10-25","Northwest","Gigi",346]
["2013-10-22","Northwest","Chin",125]
["2013-10-21","West","Tyrone",241]
["2013-10-22","West","Chin",316]
["2013-10-20","Northwest","Gigi",392]
["2013-10-26","West","Tyrone",644]
["2013-10-24","Northwest","Chin",259]
["2013-10-21","West","Chin",488]
["2013-10-22","Northwest","Chin",299]
["2013-10-21","Northwest","Tyrone",36]
["2013-10-22","Southwest","Chin",83]
["2013-10-25","Southwest","Chin",80]
["2013-10-22","Southwest","Tyrone",349]
["2013-10-22","West","Gigi",342]
["2013-10-24","West","Tyrone",540]
["2013-10-22","Southwest","Tyrone",411]
["2013-10-21","West","Tyrone",632]
["2013-10-25","West","Chin",175]
["2013-10-21","Southwest","Chin",606]
["2013-10-21","Northwest","Chin",658]
["2013-10-25","Southwest","Chin",268]
["2013-10-20","Northwest","Chin",556]
["2013-10-22","Northwest","Tyrone",208]
["2013-10-25","Southwest","Tyrone",559]
["2013-10-26","Southwest","Chin",530]
["2013-10-25","Southwest","Chin",663]
["2013-10-21","Northwest","Chin",31]
["2013-10-20","West","Chin",587]
["2013-10-23","Southwest","Tyrone",280]
["2013-10-20","Northwest","Tyrone",488]
["2013-10-25","Southwest","Tyrone",609]
["2013-10-26","Northwest","Tyrone",375]
["2013-10-25","Northwest","Chin",474]
["2013-10-23","Southwest","Tyrone",323]
["2013-10-26","Southwest","Gigi",650]
["2013-10-21","Northwest","Tyrone",505]
["2013-10-20","Southwest","Gigi",114]
["2013-10-20","Southwest","Chin",483]
["2013-10-22","West","Gigi",444]
["2013-10-26","Southwest","Chin",642]
["2013-10-22","Southwest","Chin",241]
["2013-10-24","Southwest","Gigi",444]
["2013-10-23","Northwest","Chin",270]
["2013-10-23","Northwest","Gigi",608]
["2013-10-26","West","Chin",498]
["2013-10-21","Northwest","Gigi",100]
["2013-10-22","Northwest","Gigi",379]
["2013-10-22","Southwest","Gigi",332]
["2013-10-26","Northwest","Gigi",13]
["2013-10-26","Southwest","Tyrone",456]
["2013-10-21","Southwest","Gigi",249]
["2013-10-26","West","Chin",324]
["2013-10-22","West","Gigi",423]
["2013-10-20","West","Tyrone",220]
["2013-10-20","Southwest","Chin",47]
["2013-10-20","West","Tyrone",651]
["2013-10-21","West","Tyrone",89]
["2013-10-23","Southwest","Gigi",590]
["2013-10-24","Northwest","Tyrone",681]
["2013-10-20","Northwest","Chin",538]
["2013-10-20","West","Gigi",562]
["2013-10-24","Northwest","Gigi",97]
["2013-10-22","Southwest","Gigi",583]
["2013-10-25","Northwest","Tyrone",268]
["2013-10-26","Northwest","Chin",443]
["2013-10-26","West","Chin",455]
["2013-10-23","Southwest","Chin",663]
["2013-10-22","West","Gigi",518]
["2013-10-25","West","Gigi",621]
["2013-10-21","Northwest","Chin",645]
["2013-10-21","Southwest","Tyrone",131]
["2013-10-24","Southwest","Gigi",130]
["2013-10-26","West","Chin",415]
["2013-10-23","Southwest","Tyrone",119]
["2013-10-22","Southwest","Chin",307]
["2013-10-21","Southwest","Chin",472]
["2013-10-24","Southwest","Tyrone",136]
["2013-10-21","Northwest","Gigi",586]
["2013-10-22","West","Gigi",215]
["2013-10-22","Northwest","Tyrone",562]
["2013-10-21","Southwest","Gigi",662]
["2013-10-23","Southwest","Gigi",419]
["2013-10-24","West","Chin",508]
["2013-10-23","Southwest","Tyrone",170]
["2013-10-20","Southwest","Tyrone",586]
["2013-10-24","Southwest","Gigi",219]
["2013-10-24","Southwest","Chin",339]
["2013-10-24","Southwest","Chin",198]
["2013-10-23","Northwest","Chin",674]
["2013-10-21","Northwest","Gigi",399]
["2013-10-22","Northwest","Tyrone",615]
["2013-10-21","Northwest","Tyrone",107]
["2013-10-24","Northwest","Tyrone",199]
["2013-10-25","West","Chin",23]
["2013-10-20","Southwest","Tyrone",297]
["2013-10-20","Northwest","Tyrone",273]
["2013-10-26","West","Tyrone",281]
["2013-10-22","Southwest","Gigi",227]
["2013-10-26","Northwest","Chin",156]
["2013-10-25","Southwest","Chin",534]
["2013-10-22","Southwest","Gigi",459]
["2013-10-21","Southwest","Chin",131]
["2013-10-20","West","Chin",339]
["2013-10-21","Northwest","Gigi",634]
["2013-10-21","Northwest","Chin",450]
["2013-10-25","West","Chin",65]
["2013-10-26","Southwest","Chin",530]
["2013-10-22","Southwest","Gigi",74]
["2013-10-26","Southwest","Tyrone",93]
["2013-10-21","Northwest","Gigi",337]
["2013-10-20","Northwest","Gigi",583]
["2013-10-23","West","Tyrone",374]
["2013-10-22","Northwest","Chin",243]
["2013-10-21","West","Chin",225]
["2013-10-26","Southwest","Chin",160]
["2013-10-21","West","Tyrone",502]
["2013-10-25","Northwest","Tyrone",221]
["2013-10-21","Southwest","Gigi",516]
["2013-10-26","West","Chin",678]
["2013-10-22","Northwest","Tyrone",637]
["2013-10-21","Northwest","Tyrone",525]
["2013-10-25","Southwest","Chin",540]
["2013-10-23","West","Gigi",245]
["2013-10-20","Northwest","Chin",290]
["2013-10-21","Southwest","Tyrone",376]
["2013-10-22","Southwest","Chin",226]
["2013-10-26","Northwest","Tyrone",38]
["2013-10-23","Northwest","Gigi",283]
["2013-10-21","West","Tyrone",480]
["2013-10-21","West","Chin",482]
["2013-10-26","Southwest","Tyrone",37]
["2013-10-23","Southwest","Tyrone",279]
["2013-10-23","West","Tyrone",152]
["2013-10-20","Northwest","Gigi",419]
["2013-10-23","West","Tyrone",652]
["2013-10-21","Southwest","Chin",151]
["2013-10-20","Northwest","Chin",99]
["2013-10-25","Northwest","Tyrone",432]
["2013-10-21","Northwest","Tyrone",174]
["2013-10-23","Northwest","Chin",209]
["2013-10-23","Northwest","Gigi",261]
["2013-10-26","Southwest","Gigi",633]
["2013-10-26","West","Gigi",308]
["2013-10-26","West","Tyrone",319]
["2013-10-20","West","Tyrone",400]
["2013-10-24","West","Gigi",20]
["2013-10-26","Northwest","Chin",151]
["2013-10-21","Southwest","Tyrone",345]
["2013-10-24","Southwest","Tyrone",78]
["2013-10-23","West","Tyrone",81]
["2013-10-23","West","Chin",563]
["2013-10-20","Southwest","Tyrone",344]
["2013-10-23","West","Tyrone",103]
["2013-10-20","Southwest","Chin",378]
["2013-10-26","West","Gigi",546]
["2013-10-23","West","Gigi",649]
["2013-10-21","Northwest","Chin",387]
["2013-10-20","West","Chin",468]
["2013-10-22","Southwest","Tyrone",36]
["2013-10-23","Southwest","Tyrone",576]
["2013-10-24","Northwest","Gigi",304]
["2013-10-23","Northwest","Chin",648]
["2013-10-21","Southwest","Gigi",624]
["2013-10-23","Southwest","Gigi",199]
["2013-10-22","West","Tyrone",21]
["2013-10-23","Northwest","Tyrone",173]
["2013-10-23","Northwest","Chin",149]
["2013-10-24","West","Tyrone",294]
["2013-10-20","Southwest","Gigi",225]
["2013-10-22","Southwest","Chin",276]
["2013-10-22","Northwest","Chin",666]
["2013-10-23","West","Chin",616]
["2013-10-21","Northwest","Tyrone",307]
["2013-10-23","Southwest","Chin",140]
["2013-10-24","West","Gigi",632]
["2013-10-25","West","Chin",461]
["2013-10-21","West","Chin",656]
["2013-10-22","West","Gigi",158]
["2013-10-23","Northwest","Tyrone",663]
["2013-10-24","Southwest","Gigi",555]
["2013-10-23","West","Gigi",489]
["2013-10-22","West","Chin",212]
["2013-10-20","Southwest","Gigi",411]
["2013-10-23","Northwest","Chin",343]
["2013-10-22","West","Gigi",629]
["2013-10-21","Northwest","Gigi",247]
["2013-10-25","Southwest","Gigi",180]
["2013-10-25","Southwest","Chin",374]
["2013-10-22","West","Gigi",672]
["2013-10-25","Southwest","Chin",484]
["2013-10-26","Southwest","Chin",77]
["2013-10-26","West","Chin",315]
["2013-10-23","Southwest","Gigi",462]
["2013-10-22","Southwest","Tyrone",470]
["2013-10-20","West","Tyrone",102]
["2013-10-20","West","Tyrone",161]
["2013-10-21","Northwest","Gigi",651]
["2013-10-21","Northwest","Tyrone",28]
["2013-10-26","Northwest","Tyrone",222]
["2013-10-25","West","Tyrone",399]
["2013-10-22","Northwest","Gigi",570]
["2013-10-25","West","Chin",119]
["2013-10-24","Northwest","Gigi",219]
["2013-10-24","West","Gigi",466]
["2013-10-22","Southwest","Tyrone",225]
["2013-10-21","West","Chin",293]
["2013-10-23","Southwest","Chin",217]
["2013-10-25","Northwest","Gigi",547]
["2013-10-25","Northwest","Chin",449]
["2013-10-26","West","Chin",185]
["2013-10-26","Northwest","Gigi",579]
["2013-10-21","Northwest","Chin",675]
["2013-10-23","Southwest","Tyrone",239]
["2013-10-22","Northwest","Chin",152]
["2013-10-24","Northwest","Tyrone",210]
["2013-10-25","Southwest","Gigi",573]
["2013-10-26","West","Chin",19]
["2013-10-21","Southwest","Chin",478]
["2013-10-21","Northwest","Tyrone",565]
["2013-10-24","Southwest","Gigi",169]
["2013-10-24","Northwest","Tyrone",329]
["2013-10-24","Southwest","Tyrone",115]
["2013-10-20","Northwest","Gigi",524]
["2013-10-26","Southwest","Tyrone",550]
["2013-10-22","Southwest","Tyrone",514]
["2013-10-20","Southwest","Chin",223]
["2013-10-25","Southwest","Chin",667]
["2013-10-20","Southwest","Chin",314]
["2013-10-26","Northwest","Gigi",228]
["2013-10-22","Northwest","Chin",193]
["2013-10-26","West","Tyrone",509]
["2013-10-21","Northwest","Tyrone",529]
["2013-10-26","Northwest","Chin",416]
["2013-10-22","West","Gigi",532]
["2013-10-22","West","Chin",639]
["2013-10-22","Southwest","Chin",115]
["2013-10-20","West","Tyrone",145]
["2013-10-26","Northwest","Gigi",349]
["2013-10-24","Northwest","Chin",98]
["2013-10-24","Southwest","Tyrone",342]
["2013-10-20","Southwest","Chin",234]

{"sheet":"Calcs and Data Analysis","index":4,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Video Project 25: Excel 2013 Basics 07"]
["What Excel Does: Calculations and Data Analysis"]
[]
["Calculation = a single answer in a cell",null,null,null,null,null,null,null,null,null,"Data Analysis = converting raw data into useful information"]
["Examples:",null,null,null,null,null,null,null,null,null,"Examples:"]
["Percentage grade",null,null,null,null,null,null,null,null,null,"Creating a Regional Sales Report with the SUMIFS function"]
["Net Income",null,null,null,null,null,null,null,null,null,"Creating a Regional Sales Report with a PivotTable"]
["Payroll deduction",null,null,null,null,null,null,null,null,null,"Sorting a column of assembly times to show the fastest times at the top of the column"]
[]
[]
["Name","Quiz 01","Quiz 02","Quiz 03","Test 1","Test 2","Test 3","Total","% Grade",null,"Date","Region","SalesRep","Sales",null,"Date","Total"]
["Max",20,20,20,100,100,100,{"$f":"SUM(B12:G12)","v":360},{"$f":"H12/H12","v":1},null,"2013-10-21","Northwest","Chin",154,null,"2013-10-20",{"$f":"SUMIFS($N$12:$N$33,$K$12:$K$33,P12)","v":4606}]
["Sioux",15,9,15,87,59,98,{"$f":"SUM(B13:G13)","v":283},null,null,"2013-10-21","Northwest","Gigi",205,null,"2013-10-21",{"$f":"SUMIFS($N$12:$N$33,$K$12:$K$33,P13)","v":2508}]
["Phil",16,8,14,92,68,92,{"$f":"SUM(B14:G14)","v":290},null,null,"2013-10-21","Southwest","Gigi",895,null,"2013-10-22",596]
["Tom",12,15,18,78,67,97,287,null,null,"2013-10-20","West","Gigi",620,null,"2013-10-23",0]
["Chin",16,16,19,65,72,88,276,null,null,"2013-10-20","Northwest","Gigi",484,null,"2013-10-24",3765]
["Shelia",11,13,18,74,81,87,284,null,null,"2013-10-21","West","Chin",1254,null,"2013-10-25",2648]
["Mo",18,19,19,89,79,75,299,null,null,"2013-10-20","West","Freddy",376]
["Gigi",20,8,15,92,75,92,302,null,null,"2013-10-25","Southwest","Chin",739]
["Average",{"$f":"AVERAGE(B13:B19)","v":15.428571428571429},{"$f":"AVERAGE(C13:C19)","v":12.571428571428571},{"$f":"AVERAGE(D13:D19)","v":16.857142857142858},82.428571428571431,71.571428571428569,{"$f":"AVERAGE(G13:G19)","v":89.857142857142861},{"$f":"AVERAGE(H13:H19)","v":288.71428571428572},null,null,"2013-10-25","West","Gigi",1201]
[null,null,null,null,null,null,null,null,null,null,"2013-10-25","Northwest","June",546]
["Net Income Projections","Jan","Feb","Mar","Apr","May","Total",null,null,null,"2013-10-20","Northwest","Freddy",1141]
["Revenue",{"$f":"B28","v":5000},{"$f":"B23*$B$29","v":5250},{"$f":"C23*$B$29","v":5512.5},5788.125,6077.53125,{"$f":"SUM(B23:F23)","v":27628.15625},null,null,null,"2013-10-24","Southwest","Gigi",799]
["Expenses",null,null,null,null,null,{"$f":"SUM(B24:F24)","v":0},null,null,null,"2013-10-20","Northwest","Chin",725]
["Net Income",{"$f":"B23-B24","v":5000},{"$f":"C23-C24","v":5250},5512.5,5788.125,{"$f":"F23-F24","v":6077.53125},27628.15625,null,null,null,"2013-10-24","Northwest","Gigi",651]
[null,null,null,null,null,null,null,null,null,null,"2013-10-24","West","June",1235]
["Assumptions (Formula Inputs)",null,null,null,null,null,null,null,null,null,"2013-10-25","Northwest","Chin",162]
["Start Jan Rev",5000,null,null,null,null,null,null,null,null,"2013-10-24","Southwest","Chin",684]
["Rev Increase",1.05,null,null,null,null,null,null,null,null,"2013-10-20","West","Chin",222]
["Exp as a % of Rev",0.65,null,null,null,null,null,null,null,null,"2013-10-22","Northwest","June",596]
[null,null,null,null,null,null,null,null,null,null,"2013-10-20","West","June",1038]
["Name","Gross","Deduction",null,"Tax Rate",null,null,null,null,null,"2013-10-24","Northwest","June",127]
["Jo",987,null,null,1.4500000000000001E-2,null,null,null,null,null,"2013-10-24","West","June",269]
["Mo",653.25]
["Sioux",855.25]
["Tyrone",1022.3,null,null,null,null,null,null,null,null,"Name","Assemby Time (mins)","Shift"]
["Gigi",796,null,null,null,null,null,null,null,null,"Jesse  Barton",8.43,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Robin  Ruiz",7.06,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Dean  King",10.8,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Douglas  Stevens",7.03,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Jean  French",11.64,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Sherri  Daniels",8.2899999999999991,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Ernestine  Watkins",11.92,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Clark  Waters",5.57,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Otis  Weaver",7.92,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Stanley  Steele",11.4,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Evelyn  Morgan",8.83,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Ernest  Guerrero",11.94,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Geraldine  Ramirez",9.6,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Joey  Lyons",6.67,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Ivan  Hamilton",11.76,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Jenny  Dean",8.43,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Eloise  Barber",5.82,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Bernard  Ryan",7.38,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Hector  Martinez",6.24,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Josh  Lindsey",5.29,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Rita  Fuller",10.33,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Lena  Hubbard",5.99,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Cody  Carlson",5.9,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Kent  West",8.8699999999999992,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Sadie  Richardson",6.46,"Shift 1"]

{"sheet":"Calcs and Data Analysis (an)","index":5,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Video Project 25: Excel 2013 Basics 07"]
["What Excel Does: Calculations and Data Analysis"]
[]
["Calculation = a single answer in a cell",null,null,null,"Data Analysis = converting raw data into useful information"]
["Examples:",null,null,null,"Examples:"]
["Percentage Grade",null,null,null,"Creating a Regional Sales Report with the SUMIFS function"]
["Net Income",null,null,null,"Creating a Regional Sales Report with a PivotTable"]
["Payroll Deduction",null,null,null,"Sorting a column of assembly times to show the fastest times at the top of the column"]
[]
[]
["Name","Quiz 01","Quiz 02","Quiz 03","Test 1","Test 2","Test 3","Total","% Grade",null,"Date","Region","SalesRep","Sales",null,"Date","Total"]
["Max",20,20,20,100,100,100,{"$f":"SUM(B12:G12)","v":360},{"$f":"H12/H12","v":1},null,"2013-10-21","Northwest","Chin",154,null,"2013-10-20",{"$f":"SUMIFS($N$12:$N$33,$K$12:$K$33,P12)","v":4606}]
["Sioux",15,9,15,87,59,98,{"$f":"SUM(B13:G13)","v":283},{"$f":"H13/$H$12","v":0.78611111111111109},null,"2013-10-21","Northwest","Gigi",205,null,"2013-10-21",{"$f":"SUMIFS($N$12:$N$33,$K$12:$K$33,P13)","v":2508}]
["Phil",16,8,14,92,68,92,{"$f":"SUM(B14:G14)","v":290},{"$f":"H14/$H$12","v":0.80555555555555558},null,"2013-10-21","Southwest","Gigi",895,null,"2013-10-22",596]
["Tom",12,15,18,78,67,97,287,0.79722222222222228,null,"2013-10-20","West","Gigi",620,null,"2013-10-23",0]
["Chin",16,16,19,65,72,88,276,0.76666666666666672,null,"2013-10-20","Northwest","Gigi",484,null,"2013-10-24",3765]
["Shelia",11,13,18,74,81,87,284,0.78888888888888886,null,"2013-10-21","West","Chin",1254,null,"2013-10-25",2648]
["Mo",18,19,19,89,79,75,299,0.8305555555555556,null,"2013-10-20","West","Freddy",376]
["Gigi",20,8,15,92,75,92,302,0.83888888888888891,null,"2013-10-25","Southwest","Chin",739]
["Average",{"$f":"AVERAGE(B13:B19)","v":15.428571428571429},{"$f":"AVERAGE(C13:C19)","v":12.571428571428571},{"$f":"AVERAGE(D13:D19)","v":16.857142857142858},82.428571428571431,71.571428571428569,{"$f":"AVERAGE(G13:G19)","v":89.857142857142861},{"$f":"AVERAGE(H13:H19)","v":288.71428571428572},null,null,"2013-10-25","West","Gigi",1201,null,"Row Labels","Sum of Sales"]
[null,null,null,null,null,null,null,null,null,null,"2013-10-25","Northwest","June",546,null,"2013-10-20",4606]
["Net Income Projections","Jan","Feb","Mar","Apr","May","Total",null,null,null,"2013-10-20","Northwest","Freddy",1141,null,"2013-10-21",2508]
["Revenue",{"$f":"B28","v":5000},{"$f":"B23*$B$29","v":5250},{"$f":"C23*$B$29","v":5512.5},5788.125,6077.53125,{"$f":"SUM(B23:F23)","v":27628.15625},null,null,null,"2013-10-24","Southwest","Gigi",799,null,"2013-10-22",596]
["Expenses",{"$f":"B23*$B$30","v":3250},{"$f":"C23*$B$30","v":3412.5},3583.125,3762.28125,3950.3953125000003,{"$f":"SUM(B24:F24)","v":17958.301562500001},null,null,null,"2013-10-20","Northwest","Chin",725,null,"2013-10-24",3765]
["Net Income",{"$f":"B23-B24","v":1750},{"$f":"C23-C24","v":1837.5},1929.375,2025.84375,{"$f":"F23-F24","v":2127.1359374999997},9669.8546874999993,null,null,null,"2013-10-24","Northwest","Gigi",651,null,"2013-10-25",2648]
[null,null,null,null,null,null,null,null,null,null,"2013-10-24","West","June",1235,null,"Grand Total",14123]
["Assumptions (Formula Inputs)",null,null,null,null,null,null,null,null,null,"2013-10-25","Northwest","Chin",162]
["Start Jan Rev",5000,null,null,null,null,null,null,null,null,"2013-10-24","Southwest","Chin",684]
["Rev Increase",1.05,null,null,null,null,null,null,null,null,"2013-10-20","West","Chin",222]
["Exp as a % of Rev",0.65,null,null,null,null,null,null,null,null,"2013-10-22","Northwest","June",596]
[null,null,null,null,null,null,null,null,null,null,"2013-10-20","West","June",1038]
["Name","Gross","Deduction",null,"Tax Rate",null,null,null,null,null,"2013-10-24","Northwest","June",127]
["Jo",987,{"$f":"B33*$E$33","v":14.311500000000001},null,1.4500000000000001E-2,null,null,null,null,null,"2013-10-24","West","June",269]
["Mo",653.25,{"$f":"B34*$E$33","v":9.4721250000000001}]
["Sioux",855.25,12.401125]
["Tyrone",1022.3,14.82335,null,null,null,null,null,null,null,"Name","Assembly Time (mins)","Shift"]
["Gigi",796,11.542,null,null,null,null,null,null,null,"Josh  Lindsey",5.29,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Clark  Waters",5.57,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Eloise  Barber",5.82,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Cody  Carlson",5.9,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Lena  Hubbard",5.99,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Hector  Martinez",6.24,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Sadie  Richardson",6.46,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Joey  Lyons",6.67,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Douglas  Stevens",7.03,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Robin  Ruiz",7.06,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Bernard  Ryan",7.38,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Otis  Weaver",7.92,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Sherri  Daniels",8.2899999999999991,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Jesse  Barton",8.43,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Jenny  Dean",8.43,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Evelyn  Morgan",8.83,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Kent  West",8.8699999999999992,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Geraldine  Ramirez",9.6,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Rita  Fuller",10.33,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Dean  King",10.8,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Stanley  Steele",11.4,"Shift 3"]
[null,null,null,null,null,null,null,null,null,null,"Jean  French",11.64,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Ivan  Hamilton",11.76,"Shift 2"]
[null,null,null,null,null,null,null,null,null,null,"Ernestine  Watkins",11.92,"Shift 1"]
[null,null,null,null,null,null,null,null,null,null,"Ernest  Guerrero",11.94,"Shift 1"]

{"sheet":"Default Alignment","index":6,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Video Project 26: Excel 2013 Basics 08"]
["Default Data Alignment In Excel"]
[null,null,null,null,"Calls",null,"Dates"]
[null,"By default, words are aligned left",null,null,"12",null,"2013-11-02"]
[null,null,null,null,"35",null,"11.2.2013"]
[null,"By default, numbers are aligned right",null,null,"16"]
[null,null,null,"Total"]
[null,"By default, TRUE/FALSEs are aligned center"]
[null,null,null,null,"Fix For Numbers Stored as text:"]
[null,"By default, errors are aligned center",null,null,"1) Highlight Numbers"]
[null,null,null,null,"2) Data Ribbon Tab"]
[null,null,null,null,"3) Text To Columns"]
[null,null,null,null,"4) Finish"]
[]
["Error Message","Description of Error"]
[null,"Formula errors:"]
[{"$error":"#DIV/0!"},"Divide by zero"]
[{"$error":"#REF!"},"Formula is using cell reference that has been deleted, or other invalid cell reference"]
[{"$error":"#NAME?"},"Excel built-in function misspelled, Defined Name misspelled, or \"text\" (word data) in formula is not in double quotes."]
[{"$error":"#N/A"},"Not Available/ No Answer"]
[{"$error":"#VALUE!"},"Invalid operand or argument type (argument in a function), or Array Formula was entered without Ctrl + Shift + Enter"]
[{"$error":"#NULL!"},"No Intersection"]
[{"$error":"#NUM!"},"Invalid numeric values in a formula or function, or an iterative function like IRR cannot find an answer, or the number is too big or small (number must be between -1*10^307 and 1*10^307)"]
[null,"Other errors"]
["#######","Column width not wide enough to display data (values), or negative date or time"]
["Circular Cell Reference","Cell reference in formula refers to the formulas result (itself). You see a dialog message about this error"]

{"sheet":"Default Alignment (an)","index":7,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Video Project 26: Excel 2013 Basics 08"]
["Default Data Alignment In Excel"]
[null,null,null,null,"Calls",null,"Dates"]
[null,"By default, words are aligned left",null,null,12,null,"2013-11-02"]
["Excel","Excel",null,null,35,null,"11.2.2013"]
[43,"By default, numbers are aligned right",null,null,16]
[null,43,null,"Total",{"$f":"SUM(E4:E6)","v":63}]
[null,"By default, TRUE/FALSEs are aligned center"]
[null,false,null,null,"Fix For Numbers Stored as text:"]
[null,"By default, errors are aligned center",null,null,"1) Highlight Numbers"]
[null,{"$f":"1/0","v":{"$error":"#DIV/0!"}},null,null,"2) Data Ribbon Tab"]
[null,null,null,null,"3) Text To Columns"]
[null,null,null,null,"4) Finish"]
[]
["Error Message","Description of Error"]
[null,"Formula errors:"]
[{"$error":"#DIV/0!"},"Divide by zero"]
[{"$error":"#REF!"},"Formula is using cell reference that has been deleted, or other invalid cell reference"]
[{"$error":"#NAME?"},"Excel built-in function misspelled, Defined Name misspelled, or \"text\" (word data) in formula is not in double quotes."]
[{"$error":"#N/A"},"Not Available/ No Answer"]
[{"$error":"#VALUE!"},"Invalid operand or argument type (argument in a function), or Array Formula was entered without Ctrl + Shift + Enter"]
[{"$error":"#NULL!"},"No Intersection"]
[{"$error":"#NUM!"},"Invalid numeric values in a formula or function, or an iterative function like IRR cannot find an answer, or the number is too big or small (number must be between -1*10^307 and 1*10^307)"]
[null,"Other errors"]
["#######","Column width not wide enough to display data (values), or negative date or time"]
["Circular Cell Reference","Cell reference in formula refers to the formulas result (itself). You see a dialog message about this error"]

{"sheet":"ExcelTables","index":8,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Video Project 27: Excel 2013 Basics 09"]
["Keeping Data in Excel: Proper Data Set and Excel Table"]
[]
["Proper Data Set:",null,null,null,null,null,null,"Stock Table: Proper Data Set  Example:"]
[1,"Field names in first row"]
[null,"Field names say what sort of data can go in the column",null,null,null,null,null,"Ticker","Name","Beta","P/E","EPS","Price"]
[2,"No empty field names",null,null,null,null,null,"MSFT","Microsoft",0.8,13.32,2.67,35.729999999999997]
[null,"It would be impossible to make a PivotTable without field names",null,null,null,null,null,"GE","General Electric",1.22,19.62,1.33,26.09]
[3,"Records in subsequent rows",null,null,null,null,null,"GOOG","Google",0.97,27.61,36.76,1015]
[null,"Record = row = collection of bits of raw data = set of related data",null,null,null,null,null,"KO","Coca Cola",0.26,20.53,1.93,39.61]
[4,"Try not to have empty cells in the records"]
[null,"Empty cells sometimes cause trouble, but usually there is a fix"]
[5,"Must have empty cells all around your data set (or have Excel row headers (numbers) or column headers (letters) at the left or above the data set)"]
[]
["In order to create PivotTables, Sort, Filter, we need a proper data set."]
["and later when we study Access (database)"]
[]
["Proper Data Set Example:"]
["Sales table"]
[]
[null,null,null,null,null,null,null,"Excel Table Feature:"]
["Date","Region","SalesRep","Sales",null,null,null,"What is does:"]
["2013-10-21","Northwest","Chin",154,null,null,null,"1) Dynamic Ranges"]
["2013-10-21","Northwest","Gigi",205,null,null,null,"Allows you to add new records to data set and all formulas and charts and PivotTables will automatically update (you have to refresh a PivotTable)."]
["2013-10-21","Southwest","Gigi",895,null,null,null,"2) Adds formatting"]
["2013-10-20","West","Gigi",620,null,null,null,"3) Adds Sorting and Filter buttons to each field (at the top of each column)"]
["2013-10-20","Northwest","Gigi",484]
["2013-10-21","West","Chin",1254,null,null,null,"Convert Proper Data Set to Excel Table ==>> Ctrl + T"]
["2013-10-20","West","Freddy",376,null,null,null,"Name Table in Table Tools Ribbon Design Tab, Properties group, Table Name Textbox"]
["2013-10-25","Southwest","Chin",739]
["2013-10-25","West","Gigi",1201,null,null,null,"Medical table"]
["2013-10-25","Northwest","June",546]
["2013-10-20","Northwest","Freddy",1141]
["2013-10-24","Southwest","Gigi",799,null,null,null,"Date","Systolic","Diastolic"]
["2013-10-20","Northwest","Chin",725,null,null,null,"2013-10-24",122,78]
["2013-10-24","Northwest","Gigi",651,null,null,null,"2013-10-25",132,80]
["2013-10-24","West","June",1235,null,null,null,"2013-10-26",119,77]
["2013-10-25","Northwest","Chin",162,null,null,null,"2013-10-27",145,91]
["2013-10-24","Southwest","Chin",684]
["2013-10-20","West","Chin",222]
["2013-10-22","Northwest","June",596,null,null,null,null,null,null,null,"Max","Min"]
["2013-10-20","West","June",1038]
["2013-10-24","Northwest","June",127]
["2013-10-24","West","June",269,null,null,null,null,null,null,null,"MAX function finds biggest number."]
[null,null,null,null,null,null,null,null,null,null,null,"MIN function finds smallest number."]

{"sheet":"ExcelTables (an)","index":9,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Video Project 27: Excel 2013 Basics 09"]
["Keeping Data in Excel: Proper Data Set and Excel Table"]
[]
["Proper Data Set:",null,null,null,null,null,null,"Stock Table: Proper Data Set  Example:"]
[1,"Field names in first row"]
[null,"Field names say what sort of data can go in the column",null,null,null,null,null,"Ticker","Name","Beta","P/E","EPS","Price"]
[2,"No empty field names",null,null,null,null,null,"MSFT","Microsoft",0.8,13.32,2.67,35.729999999999997]
[null,"It would be impossible to make a PivotTable without field names",null,null,null,null,null,"GE","General Electric",1.22,19.62,1.33,26.09]
[3,"Records in subsequent rows",null,null,null,null,null,"GOOG","Google",0.97,27.61,36.76,1015]
[null,"Record = row = collection of bits of raw data = set of related data",null,null,null,null,null,"KO","Coca Cola",0.26,20.53,1.93,39.61]
[4,"Try not to have empty cells in the records"]
[null,"Empty cells sometimes cause trouble, but usually there is a fix"]
[5,"Must have empty cells all around your data set (or have Excel row headers (numbers) or column headers (letters) at the left or above the data set)"]
[]
["In order to create PivotTables, Sort, Filter, we need a proper data set."]
["and later when we study Access (database)"]
[]
["Proper Data Set Example:"]
["Sales table"]
[]
[null,null,null,null,null,null,null,"Excel Table Feature:"]
["Date","Region","SalesRep","Sales",null,null,null,"What is does:"]
["2013-10-21","West","Chin",1254,null,null,null,"1) Dynamic Ranges"]
["2013-10-24","West","June",1235,null,null,null,"Allows you to add new records to data set and all formulas and charts and PivotTables will automatically update (you have to refresh a PivotTable)."]
["2013-10-25","West","Gigi",1201,null,null,null,"2) Adds formatting"]
["2013-10-20","Northwest","Freddy",1141,null,null,null,"3) Adds Sorting and Filter buttons to each field (at the top of each column)"]
["2013-10-20","West","June",1038]
["2013-10-21","Southwest","Gigi",895,null,null,null,"Convert Proper Data Set to Excel Table ==>> Ctrl + T"]
["2013-10-24","Southwest","Gigi",799,null,null,null,"Name Table in Table Tools Ribbon Design Tab, Properties group, Table Name Textbox"]
["2013-10-25","Southwest","Chin",739]
["2013-10-20","Northwest","Chin",725,null,null,null,"Medical table"]
["2013-10-24","Southwest","Chin",684]
["2013-10-24","Northwest","Gigi",651]
["2013-10-20","West","Gigi",620,null,null,null,"Date","Systolic","Diastolic"]
["2013-10-22","Northwest","June",596,null,null,null,"2013-10-24",122,78]
["2013-10-25","Northwest","June",546,null,null,null,"2013-10-25",132,80]
["2013-10-20","Northwest","Gigi",484,null,null,null,"2013-10-26",119,77]
["2013-10-20","West","Freddy",376,null,null,null,"2013-10-27",145,91]
["2013-10-24","West","June",269,null,null,null,"2013-10-28",149,93]
["2013-10-20","West","Chin",222,null,null,null,"2013-10-29",131,87]
["2013-10-21","Northwest","Gigi",205,null,null,null,"2013-10-30",125,84,null,"Max","Min"]
["2013-10-25","Northwest","Chin",162,null,null,null,null,null,null,null,{"$f":"MAX(AnswerBloodPressureT[Systolic])","v":149},{"$f":"MIN(J35:J41)","v":77}]
["2013-10-21","Northwest","Chin",154]
["2013-10-24","Northwest","June",127]

{"sheet":"PT 1 (an)","index":10,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Sales"]
["June",3811]
["Chin",3940]
["Freddy",1517]
["Gigi",4855]
["Grand Total",14123]

{"sheet":"HW ==>>","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"HW(1)","index":12,"n_rows":585,"n_cols":5,"rows_kept":585,"cut":false,"hidden":false,"merged":[]}
["In cell F4 create a formula that adds the total calls. In cell G8:G32 create a formula that adds the total calls for each Sales Rep."]
[]
["SalesRep","Calls",null,"Total"]
["Alexis  Gill",31]
["Elias  Ramsey",42]
["Myron  Daniel",37]
["Kathleen  Marshall",18,null,"SalesRep","Total"]
["Jermaine  Sherman",43,null,"Fred  Mullins"]
["Freda  Gregory",104,null,"Janet  Murphy"]
["Aaron  Adkins",25,null,"Faith  Malone"]
["Faith  Malone",54,null,"Aaron  Adkins"]
["Kim  Wolfe",38,null,"Natasha  Schneider"]
["Freda  Gregory",43,null,"Kathleen  Marshall"]
["Tony  Pierce",26,null,"Lynn  Osborne"]
["Barry  Scott",46,null,"Kim  Wolfe"]
["Freda  Gregory",40,null,"Barry  Scott"]
["Freda  Gregory",65,null,"Myron  Daniel"]
["Sheila  Smith",36,null,"Alfred  Fuller"]
["Fred  Mullins",16,null,"Mildred  Leonard"]
["Kurt  Hill",21,null,"Elias  Ramsey"]
["Brad  Dawson",31,null,"Jermaine  Sherman"]
["Fred  Mullins",51,null,"Sean  Hunter"]
["Jermaine  Sherman",40,null,"Brad  Dawson"]
["Lynn  Osborne",65,null,"Cecil  Austin"]
["Janet  Murphy",95,null,"Tony  Pierce"]
["Cecil  Austin",51,null,"Freda  Gregory"]
["Myron  Daniel",41,null,"Alexis  Gill"]
["Natasha  Schneider",57,null,"Wilbert  Moreno"]
["Elias  Ramsey",55,null,"Kurt  Hill"]
["Janet  Murphy",31,null,"John  Lucas"]
["Lynn  Osborne",67,null,"Velma  Bennett"]
["Alfred  Fuller",47,null,"Sheila  Smith"]
["Brad  Dawson",27]
["Alexis  Gill",45]
["Faith  Malone",26]
["Cecil  Austin",14]
["Janet  Murphy",33]
["John  Lucas",57]
["Kim  Wolfe",104]
["Kim  Wolfe",29]
["Freda  Gregory",49]
["Alexis  Gill",43]
["Kim  Wolfe",44]
["John  Lucas",22]
["Alfred  Fuller",11]
["Aaron  Adkins",32]
["Wilbert  Moreno",40]
["Alexis  Gill",60]
["Wilbert  Moreno",47]
["Myron  Daniel",58]
["Sean  Hunter",30]
["Lynn  Osborne",81]
["Sean  Hunter",49]
["Alexis  Gill",58]
["Kurt  Hill",111]
["Barry  Scott",43]
["Sheila  Smith",28]
["Brad  Dawson",40]
["Kim  Wolfe",98]
["Lynn  Osborne",58]
["Wilbert  Moreno",39]
["Alfred  Fuller",45]
["Aaron  Adkins",31]
["Brad  Dawson",24]
["Fred  Mullins",56]
["Alexis  Gill",64]
["Tony  Pierce",46]
["Natasha  Schneider",50]
["Myron  Daniel",12]
["Lynn  Osborne",25]
["Aaron  Adkins",96]
["Velma  Bennett",36]
["Mildred  Leonard",23]
["Wilbert  Moreno",26]
["Tony  Pierce",14]
["Freda  Gregory",51]
["Sean  Hunter",54]
["Freda  Gregory",97]
["Barry  Scott",59]
["Kathleen  Marshall",95]
["Freda  Gregory",94]
["Lynn  Osborne",35]
["Alfred  Fuller",27]
["Elias  Ramsey",37]
["Sheila  Smith",57]
["Sean  Hunter",59]
["Elias  Ramsey",60]
["Janet  Murphy",70]
["Jermaine  Sherman",39]
["Kim  Wolfe",23]
["Wilbert  Moreno",42]
["Natasha  Schneider",35]
["Mildred  Leonard",56]
["Natasha  Schneider",81]
["Lynn  Osborne",50]
["Faith  Malone",40]
["Velma  Bennett",37]
["Janet  Murphy",65]
["Alfred  Fuller",57]
["Fred  Mullins",120]
["Faith  Malone",50]
["Alfred  Fuller",32]
["Sean  Hunter",115]
["Lynn  Osborne",17]
["Lynn  Osborne",20]
["Faith  Malone",33]
["Janet  Murphy",35]
["Brad  Dawson",58]
["John  Lucas",46]
["Mildred  Leonard",77]
["Mildred  Leonard",45]
["Natasha  Schneider",45]
["Janet  Murphy",26]
["Freda  Gregory",42]
["Mildred  Leonard",40]
["Aaron  Adkins",22]
["Freda  Gregory",21]
["Barry  Scott",37]
["Velma  Bennett",103]
["Fred  Mullins",53]
["Faith  Malone",29]
["Alexis  Gill",84]
["Myron  Daniel",100]
["Sean  Hunter",38]
["Barry  Scott",43]
["Barry  Scott",49]
["Fred  Mullins",35]
["Natasha  Schneider",13]
["Janet  Murphy",86]
["Jermaine  Sherman",23]
["Alexis  Gill",39]
["Fred  Mullins",58]
["Kathleen  Marshall",76]
["Myron  Daniel",54]
["Natasha  Schneider",42]
["Natasha  Schneider",24]
["Sean  Hunter",31]
["Lynn  Osborne",58]
["John  Lucas",93]
["Jermaine  Sherman",43]
["Mildred  Leonard",38]
["Mildred  Leonard",83]
["Myron  Daniel",20]
["Wilbert  Moreno",74]
["Mildred  Leonard",28]
["Natasha  Schneider",60]
["Lynn  Osborne",39]
["Tony  Pierce",37]
["Janet  Murphy",104]
["Myron  Daniel",86]
["Jermaine  Sherman",53]
["Fred  Mullins",17]
["Kathleen  Marshall",57]
["Aaron  Adkins",52]
["Faith  Malone",40]
["Kim  Wolfe",56]
["Janet  Murphy",49]
["Aaron  Adkins",62]
["Myron  Daniel",29]
["Elias  Ramsey",114]
["Velma  Bennett",45]
["Tony  Pierce",101]
["Wilbert  Moreno",23]
["Jermaine  Sherman",86]
["Myron  Daniel",102]
["Freda  Gregory",24]
["Natasha  Schneider",22]
["Alfred  Fuller",24]
["Natasha  Schneider",43]
["Elias  Ramsey",28]
["Wilbert  Moreno",49]
["Kim  Wolfe",34]
["Janet  Murphy",22]
["Janet  Murphy",38]
["Lynn  Osborne",57]
["Barry  Scott",73]
["Kim  Wolfe",30]
["Sean  Hunter",26]
["Natasha  Schneider",50]
["Cecil  Austin",49]
["Lynn  Osborne",71]
["Freda  Gregory",50]
["Freda  Gregory",41]
["Myron  Daniel",44]
["Aaron  Adkins",88]
["Faith  Malone",37]
["Kathleen  Marshall",30]
["Janet  Murphy",49]
["Alexis  Gill",52]
["Kathleen  Marshall",47]
["Cecil  Austin",33]
["Barry  Scott",48]
["Cecil  Austin",89]
["Alfred  Fuller",36]
["Jermaine  Sherman",29]
["Brad  Dawson",35]
["Aaron  Adkins",39]
["Tony  Pierce",41]
["Kim  Wolfe",42]
["Lynn  Osborne",60]
["John  Lucas",92]
["Alexis  Gill",34]
["Elias  Ramsey",33]
["Freda  Gregory",31]
["Faith  Malone",48]
["Kurt  Hill",42]
["Kathleen  Marshall",49]
["Myron  Daniel",43]
["Alfred  Fuller",78]
["Kim  Wolfe",100]
["Sheila  Smith",54]
["Faith  Malone",36]
["Wilbert  Moreno",39]
["Fred  Mullins",52]
["Jermaine  Sherman",43]
["Myron  Daniel",112]
["Jermaine  Sherman",108]
["Natasha  Schneider",45]
["Faith  Malone",49]
["Sean  Hunter",101]
["Velma  Bennett",51]
["Aaron  Adkins",23]
["Natasha  Schneider",90]
["Myron  Daniel",23]
["Myron  Daniel",42]
["Lynn  Osborne",16]
["Fred  Mullins",37]
["Velma  Bennett",111]
["Aaron  Adkins",34]
["Faith  Malone",60]
["Velma  Bennett",99]
["Janet  Murphy",49]
["Sean  Hunter",21]
["Natasha  Schneider",33]
["Sean  Hunter",26]
["John  Lucas",46]
["Tony  Pierce",49]
["Kim  Wolfe",60]
["Sean  Hunter",38]
["Kurt  Hill",119]
["Lynn  Osborne",71]
["Janet  Murphy",30]
["Janet  Murphy",93]
["Sean  Hunter",49]
["Wilbert  Moreno",59]
["Fred  Mullins",45]
["Aaron  Adkins",33]
["Kim  Wolfe",38]
["Mildred  Leonard",86]
["Jermaine  Sherman",24]
["Elias  Ramsey",49]
["Jermaine  Sherman",62]
["Mildred  Leonard",69]
["Mildred  Leonard",86]
["Velma  Bennett",47]
["Janet  Murphy",32]
["Mildred  Leonard",25]
["Fred  Mullins",109]
["Alexis  Gill",59]
["Brad  Dawson",115]
["Alexis  Gill",57]
["Alfred  Fuller",15]
["Sean  Hunter",37]
["Brad  Dawson",60]
["Lynn  Osborne",51]
["Sean  Hunter",52]
["Sean  Hunter",47]
["Wilbert  Moreno",28]
["Sean  Hunter",12]
["Kim  Wolfe",41]
["Jermaine  Sherman",120]
["Tony  Pierce",10]
["Barry  Scott",28]
["John  Lucas",58]
["Elias  Ramsey",67]
["Jermaine  Sherman",70]
["Freda  Gregory",35]
["Natasha  Schneider",38]
["Elias  Ramsey",94]
["Lynn  Osborne",64]
["Elias  Ramsey",33]
["Myron  Daniel",34]
["Natasha  Schneider",41]
["Sheila  Smith",22]
["Fred  Mullins",28]
["Mildred  Leonard",57]
["Aaron  Adkins",93]
["Cecil  Austin",59]
["Alfred  Fuller",59]
["Sheila  Smith",59]
["Aaron  Adkins",44]
["Jermaine  Sherman",65]
["Faith  Malone",21]
["Velma  Bennett",34]
["Elias  Ramsey",27]
["Alfred  Fuller",27]
["Cecil  Austin",100]
["Lynn  Osborne",51]
["Kim  Wolfe",39]
["Myron  Daniel",111]
["Barry  Scott",68]
["Sheila  Smith",39]
["Kurt  Hill",32]
["Brad  Dawson",25]
["Wilbert  Moreno",60]
["Mildred  Leonard",38]
["Barry  Scott",57]
["Janet  Murphy",22]
["Kathleen  Marshall",32]
["Kathleen  Marshall",57]
["Fred  Mullins",13]
["Faith  Malone",57]
["Elias  Ramsey",58]
["Faith  Malone",41]
["Freda  Gregory",57]
["Brad  Dawson",35]
["Elias  Ramsey",98]
["Faith  Malone",50]
["Wilbert  Moreno",102]
["Alfred  Fuller",33]
["Natasha  Schneider",47]
["Cecil  Austin",47]
["Mildred  Leonard",26]
["Cecil  Austin",110]
["Kathleen  Marshall",46]
["Wilbert  Moreno",34]
["Lynn  Osborne",28]
["Cecil  Austin",47]
["Alexis  Gill",57]
["Kathleen  Marshall",53]
["Janet  Murphy",55]
["Freda  Gregory",47]
["Jermaine  Sherman",48]
["Alfred  Fuller",57]
["Mildred  Leonard",55]
["Fred  Mullins",46]
["Natasha  Schneider",26]
["Brad  Dawson",21]
["Faith  Malone",34]
["Elias  Ramsey",34]
["Natasha  Schneider",100]
["Jermaine  Sherman",35]
["Myron  Daniel",52]
["Alfred  Fuller",54]
["Kathleen  Marshall",36]
["Alexis  Gill",10]
["Lynn  Osborne",35]
["Wilbert  Moreno",116]
["Brad  Dawson",48]
["Brad  Dawson",99]
["Cecil  Austin",22]
["Velma  Bennett",51]
["Mildred  Leonard",28]
["Natasha  Schneider",57]
["Freda  Gregory",35]
["Kim  Wolfe",58]
["Freda  Gregory",33]
["Janet  Murphy",29]
["Barry  Scott",37]
["Myron  Daniel",29]
["Kurt  Hill",94]
["Natasha  Schneider",42]
["Kathleen  Marshall",28]
["Sean  Hunter",22]
["Alexis  Gill",21]
["Tony  Pierce",79]
["Wilbert  Moreno",21]
["Lynn  Osborne",24]
["Cecil  Austin",45]
["Kurt  Hill",39]
["Kim  Wolfe",80]
["Tony  Pierce",49]
["Kathleen  Marshall",105]
["Alfred  Fuller",34]
["Alfred  Fuller",63]
["Tony  Pierce",37]
["Freda  Gregory",10]
["Lynn  Osborne",24]
["Sheila  Smith",91]
["Tony  Pierce",57]
["Myron  Daniel",82]
["Alfred  Fuller",55]
["Alfred  Fuller",77]
["Freda  Gregory",100]
["Kim  Wolfe",30]
["Elias  Ramsey",56]
["Kurt  Hill",37]
["Natasha  Schneider",39]
["Tony  Pierce",37]
["Aaron  Adkins",22]
["Brad  Dawson",35]
["Kathleen  Marshall",110]
["Freda  Gregory",64]
["Sheila  Smith",39]
["Aaron  Adkins",24]
["John  Lucas",88]
["Natasha  Schneider",41]
["Elias  Ramsey",74]
["Myron  Daniel",52]
["Aaron  Adkins",49]
["Wilbert  Moreno",38]
["Alexis  Gill",44]
["Mildred  Leonard",53]
["John  Lucas",69]
["Sheila  Smith",84]
["Natasha  Schneider",26]
["Myron  Daniel",31]
["Natasha  Schneider",70]
["Brad  Dawson",75]
["Kurt  Hill",56]
["Jermaine  Sherman",39]
["Alexis  Gill",46]
["Sean  Hunter",44]
["Freda  Gregory",43]
["Faith  Malone",35]
["Faith  Malone",33]
["Lynn  Osborne",108]
["Natasha  Schneider",47]
["Brad  Dawson",93]
["Freda  Gregory",13]
["Mildred  Leonard",44]
["Kathleen  Marshall",28]
["Kim  Wolfe",42]
["Aaron  Adkins",65]
["Janet  Murphy",41]
["Natasha  Schneider",32]
["Freda  Gregory",35]
["Aaron  Adkins",36]
["Kathleen  Marshall",20]
["Wilbert  Moreno",66]
["Jermaine  Sherman",53]
["Myron  Daniel",61]
["Sheila  Smith",35]
["Faith  Malone",27]
["Faith  Malone",53]
["Natasha  Schneider",30]
["Sheila  Smith",56]
["Barry  Scott",120]
["Barry  Scott",39]
["Tony  Pierce",35]
["Elias  Ramsey",13]
["Kim  Wolfe",46]
["Fred  Mullins",32]
["Cecil  Austin",20]
["Wilbert  Moreno",100]
["Faith  Malone",113]
["Aaron  Adkins",55]
["Lynn  Osborne",46]
["John  Lucas",94]
["Elias  Ramsey",78]
["Barry  Scott",26]
["Kathleen  Marshall",76]
["Aaron  Adkins",57]
["Lynn  Osborne",53]
["Natasha  Schneider",53]
["Faith  Malone",44]
["Fred  Mullins",35]
["Lynn  Osborne",59]
["Jermaine  Sherman",55]
["Lynn  Osborne",118]
["Aaron  Adkins",78]
["Fred  Mullins",53]
["Mildred  Leonard",38]
["Sean  Hunter",36]
["Freda  Gregory",11]
["Kim  Wolfe",72]
["Aaron  Adkins",65]
["Wilbert  Moreno",91]
["Janet  Murphy",24]
["Alfred  Fuller",57]
["Alfred  Fuller",30]
["Kim  Wolfe",67]
["Myron  Daniel",54]
["Velma  Bennett",110]
["Kim  Wolfe",38]
["Sheila  Smith",32]
["Myron  Daniel",29]
["Kathleen  Marshall",31]
["Freda  Gregory",43]
["Lynn  Osborne",22]
["Kathleen  Marshall",91]
["Janet  Murphy",54]
["Myron  Daniel",27]
["Mildred  Leonard",43]
["Tony  Pierce",60]
["Alfred  Fuller",21]
["Brad  Dawson",24]
["John  Lucas",97]
["Cecil  Austin",94]
["Alexis  Gill",22]
["Lynn  Osborne",53]
["Jermaine  Sherman",22]
["Tony  Pierce",27]
["Janet  Murphy",26]
["Fred  Mullins",51]
["Cecil  Austin",33]
["Sheila  Smith",30]
["Alexis  Gill",38]
["Natasha  Schneider",94]
["Kim  Wolfe",52]
["Alexis  Gill",91]
["Aaron  Adkins",89]
["Velma  Bennett",32]
["Tony  Pierce",54]
["Lynn  Osborne",42]
["Kathleen  Marshall",78]
["Alexis  Gill",57]
["Mildred  Leonard",44]
["Janet  Murphy",51]
["Janet  Murphy",11]
["Alexis  Gill",85]
["Kim  Wolfe",26]
["Elias  Ramsey",41]
["Faith  Malone",112]
["Tony  Pierce",35]
["Mildred  Leonard",30]
["Janet  Murphy",22]
["Freda  Gregory",12]
["Faith  Malone",23]
["Tony  Pierce",89]
["Janet  Murphy",69]
["Kathleen  Marshall",31]
["Aaron  Adkins",16]
["Aaron  Adkins",33]
["Kim  Wolfe",60]
["Fred  Mullins",22]
["Lynn  Osborne",24]
["Tony  Pierce",50]
["Kim  Wolfe",36]
["Lynn  Osborne",116]
["Natasha  Schneider",51]
["Fred  Mullins",54]
["Freda  Gregory",56]
["Barry  Scott",108]
["Elias  Ramsey",20]
["John  Lucas",47]
["Fred  Mullins",73]
["Lynn  Osborne",31]
["Tony  Pierce",41]
["Janet  Murphy",59]
["Alfred  Fuller",43]
["Myron  Daniel",44]
["Sheila  Smith",110]
["Barry  Scott",56]
["Sheila  Smith",103]
["Cecil  Austin",37]
["Janet  Murphy",52]
["Barry  Scott",112]
["Sean  Hunter",24]
["Tony  Pierce",20]
["Faith  Malone",76]
["Kathleen  Marshall",28]
["Sean  Hunter",23]
["Kim  Wolfe",59]
["Fred  Mullins",56]
["Alexis  Gill",44]
["Fred  Mullins",36]
["Lynn  Osborne",108]
["Alexis  Gill",72]
["Jermaine  Sherman",35]
["Faith  Malone",55]
["Kim  Wolfe",89]
["Sean  Hunter",35]
["Freda  Gregory",47]
["Alfred  Fuller",50]
["Jermaine  Sherman",61]
["Freda  Gregory",117]
["Alexis  Gill",42]
["Fred  Mullins",24]
["Faith  Malone",39]
["Sheila  Smith",46]
["Janet  Murphy",58]
["Mildred  Leonard",116]
["Alexis  Gill",53]
["Janet  Murphy",29]
["Barry  Scott",18]
["Elias  Ramsey",59]
["Barry  Scott",101]
["Cecil  Austin",119]
["Wilbert  Moreno",58]
["Elias  Ramsey",23]
["Jermaine  Sherman",100]
["Natasha  Schneider",45]
["Aaron  Adkins",98]
["Sean  Hunter",115]

{"sheet":"HW(1an)","index":13,"n_rows":585,"n_cols":5,"rows_kept":585,"cut":false,"hidden":false,"merged":[]}
["In cell F4 create a formula that adds the total calls. In cell G8:G32 create a formula that adds the total calls for each Sales Rep."]
[]
["SalesRep","Calls",null,"Total"]
["Alexis  Gill",31,null,{"$f":"SUM(B4:B585)","v":29751}]
["Elias  Ramsey",42]
["Myron  Daniel",37]
["Kathleen  Marshall",18,null,"SalesRep","Total"]
["Jermaine  Sherman",43,null,"Fred  Mullins",{"$f":"SUMIFS($B$4:$B$585,$A$4:$A$585,D8)","v":1172}]
["Freda  Gregory",104,null,"Janet  Murphy",{"$f":"SUMIFS($B$4:$B$585,$A$4:$A$585,D9)","v":1509}]
["Aaron  Adkins",25,null,"Faith  Malone",1315]
["Faith  Malone",54,null,"Aaron  Adkins",1361]
["Kim  Wolfe",38,null,"Natasha  Schneider",1569]
["Freda  Gregory",43,null,"Kathleen  Marshall",1222]
["Tony  Pierce",26,null,"Lynn  Osborne",1847]
["Barry  Scott",46,null,"Kim  Wolfe",1531]
["Freda  Gregory",40,null,"Barry  Scott",1168]
["Freda  Gregory",65,null,"Myron  Daniel",1409]
["Sheila  Smith",36,null,"Alfred  Fuller",1032]
["Fred  Mullins",16,null,"Mildred  Leonard",1228]
["Kurt  Hill",21,null,"Elias  Ramsey",1193]
["Brad  Dawson",31,null,"Jermaine  Sherman",1296]
["Fred  Mullins",51,null,"Sean  Hunter",1084]
["Jermaine  Sherman",40,null,"Brad  Dawson",845]
["Lynn  Osborne",65,null,"Cecil  Austin",969]
["Janet  Murphy",95,null,"Tony  Pierce",994]
["Cecil  Austin",51,null,"Freda  Gregory",1510]
["Myron  Daniel",41,null,"Alexis  Gill",1308]
["Natasha  Schneider",57,null,"Wilbert  Moreno",1152]
["Elias  Ramsey",55,null,"Kurt  Hill",551]
["Janet  Murphy",31,null,"John  Lucas",809]
["Lynn  Osborne",67,null,"Velma  Bennett",756]
["Alfred  Fuller",47,null,"Sheila  Smith",921]
["Brad  Dawson",27]
["Alexis  Gill",45]
["Faith  Malone",26]
["Cecil  Austin",14]
["Janet  Murphy",33]
["John  Lucas",57]
["Kim  Wolfe",104]
["Kim  Wolfe",29]
["Freda  Gregory",49]
["Alexis  Gill",43]
["Kim  Wolfe",44]
["John  Lucas",22]
["Alfred  Fuller",11]
["Aaron  Adkins",32]
["Wilbert  Moreno",40]
["Alexis  Gill",60]
["Wilbert  Moreno",47]
["Myron  Daniel",58]
["Sean  Hunter",30]
["Lynn  Osborne",81]
["Sean  Hunter",49]
["Alexis  Gill",58]
["Kurt  Hill",111]
["Barry  Scott",43]
["Sheila  Smith",28]
["Brad  Dawson",40]
["Kim  Wolfe",98]
["Lynn  Osborne",58]
["Wilbert  Moreno",39]
["Alfred  Fuller",45]
["Aaron  Adkins",31]
["Brad  Dawson",24]
["Fred  Mullins",56]
["Alexis  Gill",64]
["Tony  Pierce",46]
["Natasha  Schneider",50]
["Myron  Daniel",12]
["Lynn  Osborne",25]
["Aaron  Adkins",96]
["Velma  Bennett",36]
["Mildred  Leonard",23]
["Wilbert  Moreno",26]
["Tony  Pierce",14]
["Freda  Gregory",51]
["Sean  Hunter",54]
["Freda  Gregory",97]
["Barry  Scott",59]
["Kathleen  Marshall",95]
["Freda  Gregory",94]
["Lynn  Osborne",35]
["Alfred  Fuller",27]
["Elias  Ramsey",37]
["Sheila  Smith",57]
["Sean  Hunter",59]
["Elias  Ramsey",60]
["Janet  Murphy",70]
["Jermaine  Sherman",39]
["Kim  Wolfe",23]
["Wilbert  Moreno",42]
["Natasha  Schneider",35]
["Mildred  Leonard",56]
["Natasha  Schneider",81]
["Lynn  Osborne",50]
["Faith  Malone",40]
["Velma  Bennett",37]
["Janet  Murphy",65]
["Alfred  Fuller",57]
["Fred  Mullins",120]
["Faith  Malone",50]
["Alfred  Fuller",32]
["Sean  Hunter",115]
["Lynn  Osborne",17]
["Lynn  Osborne",20]
["Faith  Malone",33]
["Janet  Murphy",35]
["Brad  Dawson",58]
["John  Lucas",46]
["Mildred  Leonard",77]
["Mildred  Leonard",45]
["Natasha  Schneider",45]
["Janet  Murphy",26]
["Freda  Gregory",42]
["Mildred  Leonard",40]
["Aaron  Adkins",22]
["Freda  Gregory",21]
["Barry  Scott",37]
["Velma  Bennett",103]
["Fred  Mullins",53]
["Faith  Malone",29]
["Alexis  Gill",84]
["Myron  Daniel",100]
["Sean  Hunter",38]
["Barry  Scott",43]
["Barry  Scott",49]
["Fred  Mullins",35]
["Natasha  Schneider",13]
["Janet  Murphy",86]
["Jermaine  Sherman",23]
["Alexis  Gill",39]
["Fred  Mullins",58]
["Kathleen  Marshall",76]
["Myron  Daniel",54]
["Natasha  Schneider",42]
["Natasha  Schneider",24]
["Sean  Hunter",31]
["Lynn  Osborne",58]
["John  Lucas",93]
["Jermaine  Sherman",43]
["Mildred  Leonard",38]
["Mildred  Leonard",83]
["Myron  Daniel",20]
["Wilbert  Moreno",74]
["Mildred  Leonard",28]
["Natasha  Schneider",60]
["Lynn  Osborne",39]
["Tony  Pierce",37]
["Janet  Murphy",104]
["Myron  Daniel",86]
["Jermaine  Sherman",53]
["Fred  Mullins",17]
["Kathleen  Marshall",57]
["Aaron  Adkins",52]
["Faith  Malone",40]
["Kim  Wolfe",56]
["Janet  Murphy",49]
["Aaron  Adkins",62]
["Myron  Daniel",29]
["Elias  Ramsey",114]
["Velma  Bennett",45]
["Tony  Pierce",101]
["Wilbert  Moreno",23]
["Jermaine  Sherman",86]
["Myron  Daniel",102]
["Freda  Gregory",24]
["Natasha  Schneider",22]
["Alfred  Fuller",24]
["Natasha  Schneider",43]
["Elias  Ramsey",28]
["Wilbert  Moreno",49]
["Kim  Wolfe",34]
["Janet  Murphy",22]
["Janet  Murphy",38]
["Lynn  Osborne",57]
["Barry  Scott",73]
["Kim  Wolfe",30]
["Sean  Hunter",26]
["Natasha  Schneider",50]
["Cecil  Austin",49]
["Lynn  Osborne",71]
["Freda  Gregory",50]
["Freda  Gregory",41]
["Myron  Daniel",44]
["Aaron  Adkins",88]
["Faith  Malone",37]
["Kathleen  Marshall",30]
["Janet  Murphy",49]
["Alexis  Gill",52]
["Kathleen  Marshall",47]
["Cecil  Austin",33]
["Barry  Scott",48]
["Cecil  Austin",89]
["Alfred  Fuller",36]
["Jermaine  Sherman",29]
["Brad  Dawson",35]
["Aaron  Adkins",39]
["Tony  Pierce",41]
["Kim  Wolfe",42]
["Lynn  Osborne",60]
["John  Lucas",92]
["Alexis  Gill",34]
["Elias  Ramsey",33]
["Freda  Gregory",31]
["Faith  Malone",48]
["Kurt  Hill",42]
["Kathleen  Marshall",49]
["Myron  Daniel",43]
["Alfred  Fuller",78]
["Kim  Wolfe",100]
["Sheila  Smith",54]
["Faith  Malone",36]
["Wilbert  Moreno",39]
["Fred  Mullins",52]
["Jermaine  Sherman",43]
["Myron  Daniel",112]
["Jermaine  Sherman",108]
["Natasha  Schneider",45]
["Faith  Malone",49]
["Sean  Hunter",101]
["Velma  Bennett",51]
["Aaron  Adkins",23]
["Natasha  Schneider",90]
["Myron  Daniel",23]
["Myron  Daniel",42]
["Lynn  Osborne",16]
["Fred  Mullins",37]
["Velma  Bennett",111]
["Aaron  Adkins",34]
["Faith  Malone",60]
["Velma  Bennett",99]
["Janet  Murphy",49]
["Sean  Hunter",21]
["Natasha  Schneider",33]
["Sean  Hunter",26]
["John  Lucas",46]
["Tony  Pierce",49]
["Kim  Wolfe",60]
["Sean  Hunter",38]
["Kurt  Hill",119]
["Lynn  Osborne",71]
["Janet  Murphy",30]
["Janet  Murphy",93]
["Sean  Hunter",49]
["Wilbert  Moreno",59]
["Fred  Mullins",45]
["Aaron  Adkins",33]
["Kim  Wolfe",38]
["Mildred  Leonard",86]
["Jermaine  Sherman",24]
["Elias  Ramsey",49]
["Jermaine  Sherman",62]
["Mildred  Leonard",69]
["Mildred  Leonard",86]
["Velma  Bennett",47]
["Janet  Murphy",32]
["Mildred  Leonard",25]
["Fred  Mullins",109]
["Alexis  Gill",59]
["Brad  Dawson",115]
["Alexis  Gill",57]
["Alfred  Fuller",15]
["Sean  Hunter",37]
["Brad  Dawson",60]
["Lynn  Osborne",51]
["Sean  Hunter",52]
["Sean  Hunter",47]
["Wilbert  Moreno",28]
["Sean  Hunter",12]
["Kim  Wolfe",41]
["Jermaine  Sherman",120]
["Tony  Pierce",10]
["Barry  Scott",28]
["John  Lucas",58]
["Elias  Ramsey",67]
["Jermaine  Sherman",70]
["Freda  Gregory",35]
["Natasha  Schneider",38]
["Elias  Ramsey",94]
["Lynn  Osborne",64]
["Elias  Ramsey",33]
["Myron  Daniel",34]
["Natasha  Schneider",41]
["Sheila  Smith",22]
["Fred  Mullins",28]
["Mildred  Leonard",57]
["Aaron  Adkins",93]
["Cecil  Austin",59]
["Alfred  Fuller",59]
["Sheila  Smith",59]
["Aaron  Adkins",44]
["Jermaine  Sherman",65]
["Faith  Malone",21]
["Velma  Bennett",34]
["Elias  Ramsey",27]
["Alfred  Fuller",27]
["Cecil  Austin",100]
["Lynn  Osborne",51]
["Kim  Wolfe",39]
["Myron  Daniel",111]
["Barry  Scott",68]
["Sheila  Smith",39]
["Kurt  Hill",32]
["Brad  Dawson",25]
["Wilbert  Moreno",60]
["Mildred  Leonard",38]
["Barry  Scott",57]
["Janet  Murphy",22]
["Kathleen  Marshall",32]
["Kathleen  Marshall",57]
["Fred  Mullins",13]
["Faith  Malone",57]
["Elias  Ramsey",58]
["Faith  Malone",41]
["Freda  Gregory",57]
["Brad  Dawson",35]
["Elias  Ramsey",98]
["Faith  Malone",50]
["Wilbert  Moreno",102]
["Alfred  Fuller",33]
["Natasha  Schneider",47]
["Cecil  Austin",47]
["Mildred  Leonard",26]
["Cecil  Austin",110]
["Kathleen  Marshall",46]
["Wilbert  Moreno",34]
["Lynn  Osborne",28]
["Cecil  Austin",47]
["Alexis  Gill",57]
["Kathleen  Marshall",53]
["Janet  Murphy",55]
["Freda  Gregory",47]
["Jermaine  Sherman",48]
["Alfred  Fuller",57]
["Mildred  Leonard",55]
["Fred  Mullins",46]
["Natasha  Schneider",26]
["Brad  Dawson",21]
["Faith  Malone",34]
["Elias  Ramsey",34]
["Natasha  Schneider",100]
["Jermaine  Sherman",35]
["Myron  Daniel",52]
["Alfred  Fuller",54]
["Kathleen  Marshall",36]
["Alexis  Gill",10]
["Lynn  Osborne",35]
["Wilbert  Moreno",116]
["Brad  Dawson",48]
["Brad  Dawson",99]
["Cecil  Austin",22]
["Velma  Bennett",51]
["Mildred  Leonard",28]
["Natasha  Schneider",57]
["Freda  Gregory",35]
["Kim  Wolfe",58]
["Freda  Gregory",33]
["Janet  Murphy",29]
["Barry  Scott",37]
["Myron  Daniel",29]
["Kurt  Hill",94]
["Natasha  Schneider",42]
["Kathleen  Marshall",28]
["Sean  Hunter",22]
["Alexis  Gill",21]
["Tony  Pierce",79]
["Wilbert  Moreno",21]
["Lynn  Osborne",24]
["Cecil  Austin",45]
["Kurt  Hill",39]
["Kim  Wolfe",80]
["Tony  Pierce",49]
["Kathleen  Marshall",105]
["Alfred  Fuller",34]
["Alfred  Fuller",63]
["Tony  Pierce",37]
["Freda  Gregory",10]
["Lynn  Osborne",24]
["Sheila  Smith",91]
["Tony  Pierce",57]
["Myron  Daniel",82]
["Alfred  Fuller",55]
["Alfred  Fuller",77]
["Freda  Gregory",100]
["Kim  Wolfe",30]
["Elias  Ramsey",56]
["Kurt  Hill",37]
["Natasha  Schneider",39]
["Tony  Pierce",37]
["Aaron  Adkins",22]
["Brad  Dawson",35]
["Kathleen  Marshall",110]
["Freda  Gregory",64]
["Sheila  Smith",39]
["Aaron  Adkins",24]
["John  Lucas",88]
["Natasha  Schneider",41]
["Elias  Ramsey",74]
["Myron  Daniel",52]
["Aaron  Adkins",49]
["Wilbert  Moreno",38]
["Alexis  Gill",44]
["Mildred  Leonard",53]
["John  Lucas",69]
["Sheila  Smith",84]
["Natasha  Schneider",26]
["Myron  Daniel",31]
["Natasha  Schneider",70]
["Brad  Dawson",75]
["Kurt  Hill",56]
["Jermaine  Sherman",39]
["Alexis  Gill",46]
["Sean  Hunter",44]
["Freda  Gregory",43]
["Faith  Malone",35]
["Faith  Malone",33]
["Lynn  Osborne",108]
["Natasha  Schneider",47]
["Brad  Dawson",93]
["Freda  Gregory",13]
["Mildred  Leonard",44]
["Kathleen  Marshall",28]
["Kim  Wolfe",42]
["Aaron  Adkins",65]
["Janet  Murphy",41]
["Natasha  Schneider",32]
["Freda  Gregory",35]
["Aaron  Adkins",36]
["Kathleen  Marshall",20]
["Wilbert  Moreno",66]
["Jermaine  Sherman",53]
["Myron  Daniel",61]
["Sheila  Smith",35]
["Faith  Malone",27]
["Faith  Malone",53]
["Natasha  Schneider",30]
["Sheila  Smith",56]
["Barry  Scott",120]
["Barry  Scott",39]
["Tony  Pierce",35]
["Elias  Ramsey",13]
["Kim  Wolfe",46]
["Fred  Mullins",32]
["Cecil  Austin",20]
["Wilbert  Moreno",100]
["Faith  Malone",113]
["Aaron  Adkins",55]
["Lynn  Osborne",46]
["John  Lucas",94]
["Elias  Ramsey",78]
["Barry  Scott",26]
["Kathleen  Marshall",76]
["Aaron  Adkins",57]
["Lynn  Osborne",53]
["Natasha  Schneider",53]
["Faith  Malone",44]
["Fred  Mullins",35]
["Lynn  Osborne",59]
["Jermaine  Sherman",55]
["Lynn  Osborne",118]
["Aaron  Adkins",78]
["Fred  Mullins",53]
["Mildred  Leonard",38]
["Sean  Hunter",36]
["Freda  Gregory",11]
["Kim  Wolfe",72]
["Aaron  Adkins",65]
["Wilbert  Moreno",91]
["Janet  Murphy",24]
["Alfred  Fuller",57]
["Alfred  Fuller",30]
["Kim  Wolfe",67]
["Myron  Daniel",54]
["Velma  Bennett",110]
["Kim  Wolfe",38]
["Sheila  Smith",32]
["Myron  Daniel",29]
["Kathleen  Marshall",31]
["Freda  Gregory",43]
["Lynn  Osborne",22]
["Kathleen  Marshall",91]
["Janet  Murphy",54]
["Myron  Daniel",27]
["Mildred  Leonard",43]
["Tony  Pierce",60]
["Alfred  Fuller",21]
["Brad  Dawson",24]
["John  Lucas",97]
["Cecil  Austin",94]
["Alexis  Gill",22]
["Lynn  Osborne",53]
["Jermaine  Sherman",22]
["Tony  Pierce",27]
["Janet  Murphy",26]
["Fred  Mullins",51]
["Cecil  Austin",33]
["Sheila  Smith",30]
["Alexis  Gill",38]
["Natasha  Schneider",94]
["Kim  Wolfe",52]
["Alexis  Gill",91]
["Aaron  Adkins",89]
["Velma  Bennett",32]
["Tony  Pierce",54]
["Lynn  Osborne",42]
["Kathleen  Marshall",78]
["Alexis  Gill",57]
["Mildred  Leonard",44]
["Janet  Murphy",51]
["Janet  Murphy",11]
["Alexis  Gill",85]
["Kim  Wolfe",26]
["Elias  Ramsey",41]
["Faith  Malone",112]
["Tony  Pierce",35]
["Mildred  Leonard",30]
["Janet  Murphy",22]
["Freda  Gregory",12]
["Faith  Malone",23]
["Tony  Pierce",89]
["Janet  Murphy",69]
["Kathleen  Marshall",31]
["Aaron  Adkins",16]
["Aaron  Adkins",33]
["Kim  Wolfe",60]
["Fred  Mullins",22]
["Lynn  Osborne",24]
["Tony  Pierce",50]
["Kim  Wolfe",36]
["Lynn  Osborne",116]
["Natasha  Schneider",51]
["Fred  Mullins",54]
["Freda  Gregory",56]
["Barry  Scott",108]
["Elias  Ramsey",20]
["John  Lucas",47]
["Fred  Mullins",73]
["Lynn  Osborne",31]
["Tony  Pierce",41]
["Janet  Murphy",59]
["Alfred  Fuller",43]
["Myron  Daniel",44]
["Sheila  Smith",110]
["Barry  Scott",56]
["Sheila  Smith",103]
["Cecil  Austin",37]
["Janet  Murphy",52]
["Barry  Scott",112]
["Sean  Hunter",24]
["Tony  Pierce",20]
["Faith  Malone",76]
["Kathleen  Marshall",28]
["Sean  Hunter",23]
["Kim  Wolfe",59]
["Fred  Mullins",56]
["Alexis  Gill",44]
["Fred  Mullins",36]
["Lynn  Osborne",108]
["Alexis  Gill",72]
["Jermaine  Sherman",35]
["Faith  Malone",55]
["Kim  Wolfe",89]
["Sean  Hunter",35]
["Freda  Gregory",47]
["Alfred  Fuller",50]
["Jermaine  Sherman",61]
["Freda  Gregory",117]
["Alexis  Gill",42]
["Fred  Mullins",24]
["Faith  Malone",39]
["Sheila  Smith",46]
["Janet  Murphy",58]
["Mildred  Leonard",116]
["Alexis  Gill",53]
["Janet  Murphy",29]
["Barry  Scott",18]
["Elias  Ramsey",59]
["Barry  Scott",101]
["Cecil  Austin",119]
["Wilbert  Moreno",58]
["Elias  Ramsey",23]
["Jermaine  Sherman",100]
["Natasha  Schneider",45]
["Aaron  Adkins",98]
["Sean  Hunter",115]

{"sheet":"HW(2)","index":14,"n_rows":585,"n_cols":4,"rows_kept":585,"cut":false,"hidden":false,"merged":[]}
["Create a PivotTable as a new sheet that adds the sales for each Sales Rep."]
[]
["Date","Region","SalesRep","Sales"]
["2013-10-21","West","Jermaine  Sherman",519]
["2013-10-25","West","Elias  Ramsey",651]
["2013-10-26","West","Barry  Scott",618]
["2013-10-23","Northwest","Alfred  Fuller",335]
["2013-10-20","Northwest","Alfred  Fuller",640]
["2013-10-23","Southwest","Kim  Wolfe",586]
["2013-10-21","West","Myron  Daniel",301]
["2013-10-25","Southwest","Elias  Ramsey",359]
["2013-10-20","West","Kim  Wolfe",658]
["2013-10-21","Southwest","Elias  Ramsey",213]
["2013-10-25","Southwest","Lynn  Osborne",500]
["2013-10-22","Northwest","Kim  Wolfe",604]
["2013-10-23","West","Alexis  Gill",340]
["2013-10-21","Northwest","Lynn  Osborne",117]
["2013-10-25","Southwest","Mildred  Leonard",234]
["2013-10-20","West","Mildred  Leonard",225]
["2013-10-25","Southwest","Velma  Bennett",302]
["2013-10-24","Northwest","Fred  Mullins",223]
["2013-10-22","West","Kim  Wolfe",401]
["2013-10-24","West","Barry  Scott",405]
["2013-10-21","Northwest","Myron  Daniel",493]
["2013-10-21","Southwest","Lynn  Osborne",214]
["2013-10-22","Southwest","Alfred  Fuller",366]
["2013-10-22","Northwest","Elias  Ramsey",191]
["2013-10-25","West","Mildred  Leonard",628]
["2013-10-26","West","Alfred  Fuller",144]
["2013-10-26","Southwest","Mildred  Leonard",335]
["2013-10-22","Southwest","Myron  Daniel",571]
["2013-10-25","Southwest","Alfred  Fuller",136]
["2013-10-25","Northwest","Lynn  Osborne",201]
["2013-10-23","Northwest","Brad  Dawson",339]
["2013-10-25","Northwest","Kim  Wolfe",203]
["2013-10-21","West","Alexis  Gill",526]
["2013-10-25","West","Myron  Daniel",86]
["2013-10-24","Southwest","Natasha  Schneider",388]
["2013-10-25","Northwest","Kathleen  Marshall",119]
["2013-10-21","West","Kathleen  Marshall",296]
["2013-10-21","Northwest","Barry  Scott",295]
["2013-10-21","Northwest","Brad  Dawson",120]
["2013-10-21","West","Elias  Ramsey",647]
["2013-10-22","Northwest","Wilbert  Moreno",159]
["2013-10-23","Northwest","Alexis  Gill",217]
["2013-10-24","Southwest","Kim  Wolfe",362]
["2013-10-26","Southwest","Velma  Bennett",599]
["2013-10-25","West","Jermaine  Sherman",546]
["2013-10-25","Northwest","Lynn  Osborne",254]
["2013-10-20","West","Elias  Ramsey",101]
["2013-10-26","Southwest","Lynn  Osborne",150]
["2013-10-25","Southwest","Myron  Daniel",204]
["2013-10-24","Southwest","Brad  Dawson",106]
["2013-10-21","West","Myron  Daniel",333]
["2013-10-24","Northwest","Myron  Daniel",67]
["2013-10-20","Northwest","Velma  Bennett",51]
["2013-10-21","Southwest","Lynn  Osborne",279]
["2013-10-24","Southwest","Tony  Pierce",123]
["2013-10-21","West","Alfred  Fuller",519]
["2013-10-22","Northwest","Mildred  Leonard",501]
["2013-10-26","West","Kathleen  Marshall",235]
["2013-10-23","Southwest","Barry  Scott",35]
["2013-10-23","West","Alfred  Fuller",319]
["2013-10-24","Northwest","Barry  Scott",551]
["2013-10-26","Southwest","Natasha  Schneider",188]
["2013-10-25","West","Kathleen  Marshall",129]
["2013-10-20","West","Brad  Dawson",339]
["2013-10-21","Southwest","Kathleen  Marshall",485]
["2013-10-20","West","Mildred  Leonard",29]
["2013-10-20","Southwest","Kim  Wolfe",135]
["2013-10-26","Southwest","Jermaine  Sherman",584]
["2013-10-23","Northwest","Lynn  Osborne",684]
["2013-10-23","West","Alfred  Fuller",528]
["2013-10-26","Southwest","Lynn  Osborne",675]
["2013-10-23","West","Brad  Dawson",119]
["2013-10-22","West","Kim  Wolfe",368]
["2013-10-24","Southwest","Freda  Gregory",524]
["2013-10-24","Southwest","Lynn  Osborne",329]
["2013-10-26","West","Sean  Hunter",146]
["2013-10-26","Northwest","Alfred  Fuller",350]
["2013-10-23","Southwest","Natasha  Schneider",387]
["2013-10-20","Southwest","Faith  Malone",244]
["2013-10-23","Southwest","Kathleen  Marshall",388]
["2013-10-20","Southwest","Natasha  Schneider",449]
["2013-10-22","West","Natasha  Schneider",477]
["2013-10-23","Southwest","Sheila  Smith",457]
["2013-10-26","Southwest","Barry  Scott",105]
["2013-10-22","West","Sean  Hunter",458]
["2013-10-26","Northwest","Elias  Ramsey",110]
["2013-10-21","West","Natasha  Schneider",32]
["2013-10-24","West","Cecil  Austin",681]
["2013-10-23","Northwest","Barry  Scott",320]
["2013-10-25","Northwest","Freda  Gregory",601]
["2013-10-25","Southwest","Mildred  Leonard",101]
["2013-10-23","Northwest","Sheila  Smith",172]
["2013-10-20","West","Brad  Dawson",197]
["2013-10-22","West","Alfred  Fuller",346]
["2013-10-26","West","John  Lucas",318]
["2013-10-21","West","John  Lucas",245]
["2013-10-25","Southwest","Kathleen  Marshall",498]
["2013-10-26","Southwest","Lynn  Osborne",272]
["2013-10-21","Southwest","Kathleen  Marshall",424]
["2013-10-26","Northwest","Lynn  Osborne",122]
["2013-10-23","Southwest","Lynn  Osborne",39]
["2013-10-21","Southwest","Jermaine  Sherman",400]
["2013-10-26","West","Alfred  Fuller",416]
["2013-10-20","Southwest","Velma  Bennett",397]
["2013-10-25","Northwest","Myron  Daniel",671]
["2013-10-25","Southwest","Alfred  Fuller",148]
["2013-10-21","Northwest","Fred  Mullins",115]
["2013-10-25","Northwest","Aaron  Adkins",639]
["2013-10-24","Southwest","Kathleen  Marshall",659]
["2013-10-22","West","Barry  Scott",36]
["2013-10-21","Northwest","Fred  Mullins",102]
["2013-10-22","West","Mildred  Leonard",413]
["2013-10-25","West","Natasha  Schneider",166]
["2013-10-22","West","Kim  Wolfe",97]
["2013-10-26","West","Sean  Hunter",127]
["2013-10-20","Northwest","Janet  Murphy",60]
["2013-10-22","Southwest","Mildred  Leonard",496]
["2013-10-23","Northwest","Sean  Hunter",204]
["2013-10-26","Northwest","Alfred  Fuller",489]
["2013-10-20","West","Faith  Malone",266]
["2013-10-20","Northwest","Kathleen  Marshall",364]
["2013-10-20","Northwest","Barry  Scott",579]
["2013-10-21","West","Faith  Malone",587]
["2013-10-26","West","Janet  Murphy",543]
["2013-10-22","Northwest","Mildred  Leonard",644]
["2013-10-20","West","Alfred  Fuller",564]
["2013-10-22","Southwest","Faith  Malone",149]
["2013-10-23","Southwest","Barry  Scott",201]
["2013-10-25","West","Janet  Murphy",51]
["2013-10-23","West","Myron  Daniel",195]
["2013-10-26","Northwest","Kim  Wolfe",660]
["2013-10-21","Northwest","Myron  Daniel",523]
["2013-10-23","West","Kathleen  Marshall",649]
["2013-10-25","Southwest","Elias  Ramsey",409]
["2013-10-20","Northwest","Velma  Bennett",556]
["2013-10-22","Northwest","Kim  Wolfe",565]
["2013-10-20","Southwest","Elias  Ramsey",357]
["2013-10-25","West","Alexis  Gill",219]
["2013-10-25","Northwest","Freda  Gregory",327]
["2013-10-20","Southwest","Velma  Bennett",666]
["2013-10-20","Northwest","Freda  Gregory",290]
["2013-10-24","Northwest","Elias  Ramsey",64]
["2013-10-24","West","Natasha  Schneider",373]
["2013-10-26","Northwest","Brad  Dawson",249]
["2013-10-20","Northwest","Kurt  Hill",237]
["2013-10-22","West","Natasha  Schneider",138]
["2013-10-26","West","Faith  Malone",324]
["2013-10-22","Southwest","Kathleen  Marshall",633]
["2013-10-26","Southwest","Lynn  Osborne",240]
["2013-10-20","Southwest","Brad  Dawson",615]
["2013-10-22","Southwest","Myron  Daniel",180]
["2013-10-25","West","Tony  Pierce",415]
["2013-10-22","West","Fred  Mullins",305]
["2013-10-25","Northwest","Kathleen  Marshall",657]
["2013-10-23","West","Kathleen  Marshall",474]
["2013-10-22","West","Natasha  Schneider",611]
["2013-10-21","West","Kurt  Hill",682]
["2013-10-24","Northwest","Fred  Mullins",398]
["2013-10-23","Northwest","Natasha  Schneider",74]
["2013-10-24","West","Lynn  Osborne",243]
["2013-10-25","West","Barry  Scott",151]
["2013-10-25","Northwest","Kathleen  Marshall",174]
["2013-10-24","Northwest","Freda  Gregory",304]
["2013-10-20","West","Wilbert  Moreno",457]
["2013-10-20","Southwest","Alfred  Fuller",315]
["2013-10-23","Northwest","Kim  Wolfe",295]
["2013-10-22","Northwest","Mildred  Leonard",534]
["2013-10-23","West","Jermaine  Sherman",598]
["2013-10-24","Southwest","Lynn  Osborne",14]
["2013-10-22","Southwest","Kathleen  Marshall",26]
["2013-10-23","West","Aaron  Adkins",108]
["2013-10-22","West","Janet  Murphy",114]
["2013-10-26","Northwest","Sheila  Smith",684]
["2013-10-25","West","Kurt  Hill",258]
["2013-10-21","Northwest","John  Lucas",439]
["2013-10-26","Northwest","Alfred  Fuller",583]
["2013-10-25","West","Lynn  Osborne",664]
["2013-10-24","West","Elias  Ramsey",339]
["2013-10-24","Northwest","Freda  Gregory",164]
["2013-10-22","Southwest","Elias  Ramsey",671]
["2013-10-23","Southwest","Mildred  Leonard",241]
["2013-10-24","West","Mildred  Leonard",257]
["2013-10-23","Northwest","Kurt  Hill",264]
["2013-10-26","West","Mildred  Leonard",471]
["2013-10-21","Northwest","Tony  Pierce",40]
["2013-10-22","West","Faith  Malone",594]
["2013-10-21","West","Kim  Wolfe",605]
["2013-10-24","West","Fred  Mullins",409]
["2013-10-21","Northwest","Tony  Pierce",250]
["2013-10-22","Southwest","Tony  Pierce",481]
["2013-10-25","West","Sean  Hunter",529]
["2013-10-24","Southwest","Wilbert  Moreno",56]
["2013-10-23","West","Alfred  Fuller",82]
["2013-10-26","West","Lynn  Osborne",575]
["2013-10-22","West","Kathleen  Marshall",665]
["2013-10-25","West","Kathleen  Marshall",490]
["2013-10-23","Southwest","Mildred  Leonard",630]
["2013-10-25","Southwest","Elias  Ramsey",352]
["2013-10-23","Southwest","Cecil  Austin",269]
["2013-10-22","Southwest","Jermaine  Sherman",200]
["2013-10-23","West","Natasha  Schneider",329]
["2013-10-24","West","Kim  Wolfe",605]
["2013-10-22","West","Faith  Malone",340]
["2013-10-22","West","Natasha  Schneider",456]
["2013-10-22","West","Sean  Hunter",368]
["2013-10-22","Northwest","Lynn  Osborne",510]
["2013-10-21","Northwest","Barry  Scott",63]
["2013-10-23","Northwest","Elias  Ramsey",359]
["2013-10-20","West","Barry  Scott",138]
["2013-10-26","Northwest","Janet  Murphy",35]
["2013-10-26","Southwest","Myron  Daniel",386]
["2013-10-26","Southwest","Mildred  Leonard",73]
["2013-10-25","Northwest","Mildred  Leonard",389]
["2013-10-26","West","Kathleen  Marshall",321]
["2013-10-24","Northwest","Kathleen  Marshall",175]
["2013-10-25","Southwest","Elias  Ramsey",438]
["2013-10-20","Southwest","Alfred  Fuller",622]
["2013-10-21","Southwest","Alfred  Fuller",612]
["2013-10-24","Southwest","Barry  Scott",404]
["2013-10-26","Southwest","Elias  Ramsey",632]
["2013-10-22","Northwest","Elias  Ramsey",20]
["2013-10-20","West","Cecil  Austin",264]
["2013-10-20","Northwest","Elias  Ramsey",656]
["2013-10-21","Northwest","Jermaine  Sherman",391]
["2013-10-20","Southwest","Barry  Scott",686]
["2013-10-26","Northwest","Aaron  Adkins",466]
["2013-10-22","West","Kathleen  Marshall",661]
["2013-10-21","Southwest","Lynn  Osborne",654]
["2013-10-22","West","Natasha  Schneider",661]
["2013-10-25","West","Wilbert  Moreno",202]
["2013-10-23","West","Lynn  Osborne",335]
["2013-10-24","Southwest","Natasha  Schneider",181]
["2013-10-23","West","Alfred  Fuller",370]
["2013-10-23","West","Kim  Wolfe",608]
["2013-10-26","West","Lynn  Osborne",74]
["2013-10-21","Southwest","Alexis  Gill",349]
["2013-10-23","Northwest","Barry  Scott",77]
["2013-10-20","Southwest","Myron  Daniel",77]
["2013-10-26","Southwest","Kim  Wolfe",639]
["2013-10-26","Southwest","Natasha  Schneider",97]
["2013-10-24","Northwest","Natasha  Schneider",56]
["2013-10-22","Southwest","Mildred  Leonard",22]
["2013-10-22","West","Janet  Murphy",306]
["2013-10-25","Northwest","Elias  Ramsey",329]
["2013-10-20","West","Elias  Ramsey",95]
["2013-10-25","Southwest","Kathleen  Marshall",270]
["2013-10-26","Southwest","Brad  Dawson",648]
["2013-10-24","Northwest","Lynn  Osborne",169]
["2013-10-21","West","Kim  Wolfe",488]
["2013-10-22","Northwest","Barry  Scott",353]
["2013-10-22","West","Elias  Ramsey",613]
["2013-10-23","West","Myron  Daniel",664]
["2013-10-23","West","Kurt  Hill",343]
["2013-10-24","Southwest","Janet  Murphy",318]
["2013-10-26","Northwest","Tony  Pierce",294]
["2013-10-23","Northwest","Mildred  Leonard",295]
["2013-10-26","Northwest","Kathleen  Marshall",197]
["2013-10-21","Northwest","Myron  Daniel",682]
["2013-10-23","West","Faith  Malone",147]
["2013-10-24","West","Tony  Pierce",662]
["2013-10-25","Northwest","Kathleen  Marshall",482]
["2013-10-24","Southwest","Kim  Wolfe",503]
["2013-10-24","West","Elias  Ramsey",190]
["2013-10-25","Southwest","Cecil  Austin",477]
["2013-10-21","Southwest","Elias  Ramsey",630]
["2013-10-21","West","Lynn  Osborne",576]
["2013-10-25","West","Natasha  Schneider",43]
["2013-10-22","Southwest","Kim  Wolfe",460]
["2013-10-20","West","Faith  Malone",347]
["2013-10-23","Northwest","Kathleen  Marshall",245]
["2013-10-26","West","Natasha  Schneider",303]
["2013-10-22","Southwest","Lynn  Osborne",60]
["2013-10-23","Northwest","Mildred  Leonard",191]
["2013-10-24","Southwest","Barry  Scott",550]
["2013-10-20","Northwest","Brad  Dawson",222]
["2013-10-24","Southwest","Kim  Wolfe",213]
["2013-10-26","Southwest","Cecil  Austin",28]
["2013-10-22","West","Myron  Daniel",552]
["2013-10-23","West","Kim  Wolfe",608]
["2013-10-25","West","Myron  Daniel",308]
["2013-10-22","Southwest","Kurt  Hill",56]
["2013-10-26","Southwest","Kurt  Hill",303]
["2013-10-22","West","Faith  Malone",561]
["2013-10-20","Southwest","Brad  Dawson",264]
["2013-10-20","Southwest","Natasha  Schneider",249]
["2013-10-25","Northwest","Barry  Scott",259]
["2013-10-26","Northwest","Kathleen  Marshall",609]
["2013-10-21","Northwest","Natasha  Schneider",213]
["2013-10-21","West","Natasha  Schneider",301]
["2013-10-26","Southwest","Cecil  Austin",359]
["2013-10-26","West","Mildred  Leonard",18]
["2013-10-20","Southwest","Barry  Scott",98]
["2013-10-22","Northwest","Natasha  Schneider",274]
["2013-10-24","Southwest","Velma  Bennett",466]
["2013-10-20","Northwest","Lynn  Osborne",65]
["2013-10-21","Northwest","Kathleen  Marshall",638]
["2013-10-23","West","Lynn  Osborne",73]
["2013-10-20","West","Kim  Wolfe",89]
["2013-10-22","West","Lynn  Osborne",154]
["2013-10-20","West","Cecil  Austin",209]
["2013-10-23","West","Lynn  Osborne",296]
["2013-10-25","Northwest","Jermaine  Sherman",564]
["2013-10-25","Southwest","Barry  Scott",338]
["2013-10-25","Northwest","Alfred  Fuller",428]
["2013-10-26","Northwest","Myron  Daniel",24]
["2013-10-22","Southwest","Elias  Ramsey",353]
["2013-10-26","West","Natasha  Schneider",645]
["2013-10-26","Southwest","Alfred  Fuller",466]
["2013-10-22","West","Elias  Ramsey",37]
["2013-10-25","Northwest","Lynn  Osborne",367]
["2013-10-22","Southwest","Myron  Daniel",295]
["2013-10-23","Southwest","Natasha  Schneider",178]
["2013-10-21","West","Kim  Wolfe",56]
["2013-10-26","West","Myron  Daniel",227]
["2013-10-24","Southwest","Natasha  Schneider",215]
["2013-10-24","West","Myron  Daniel",506]
["2013-10-26","Northwest","Mildred  Leonard",215]
["2013-10-20","Southwest","Mildred  Leonard",237]
["2013-10-22","West","Mildred  Leonard",296]
["2013-10-25","West","Mildred  Leonard",302]
["2013-10-23","Southwest","Kurt  Hill",622]
["2013-10-21","West","Mildred  Leonard",312]
["2013-10-24","West","Alfred  Fuller",304]
["2013-10-23","Southwest","Faith  Malone",158]
["2013-10-25","West","Janet  Murphy",569]
["2013-10-23","Northwest","Kim  Wolfe",545]
["2013-10-26","Southwest","Alfred  Fuller",111]
["2013-10-22","West","Tony  Pierce",227]
["2013-10-21","Northwest","Alfred  Fuller",340]
["2013-10-25","West","Kim  Wolfe",123]
["2013-10-20","West","Alfred  Fuller",229]
["2013-10-24","Northwest","Freda  Gregory",618]
["2013-10-24","Southwest","Natasha  Schneider",65]
["2013-10-21","West","Lynn  Osborne",19]
["2013-10-26","Southwest","Freda  Gregory",72]
["2013-10-26","West","Kim  Wolfe",103]
["2013-10-25","West","Lynn  Osborne",658]
["2013-10-22","Southwest","Tony  Pierce",523]
["2013-10-21","Northwest","Mildred  Leonard",338]
["2013-10-25","Northwest","Alfred  Fuller",33]
["2013-10-26","West","Elias  Ramsey",553]
["2013-10-25","Northwest","Mildred  Leonard",346]
["2013-10-22","Northwest","Lynn  Osborne",125]
["2013-10-21","West","Lynn  Osborne",241]
["2013-10-22","West","Myron  Daniel",316]
["2013-10-20","Northwest","Alexis  Gill",392]
["2013-10-26","West","Alexis  Gill",644]
["2013-10-24","Northwest","Tony  Pierce",259]
["2013-10-21","West","Tony  Pierce",488]
["2013-10-22","Northwest","Alfred  Fuller",299]
["2013-10-21","Northwest","Natasha  Schneider",36]
["2013-10-22","Southwest","Kathleen  Marshall",83]
["2013-10-25","Southwest","Aaron  Adkins",80]
["2013-10-22","Southwest","Barry  Scott",349]
["2013-10-22","West","Lynn  Osborne",342]
["2013-10-24","West","Myron  Daniel",540]
["2013-10-22","Southwest","Kurt  Hill",411]
["2013-10-21","West","Sean  Hunter",632]
["2013-10-25","West","Aaron  Adkins",175]
["2013-10-21","Southwest","Alexis  Gill",606]
["2013-10-21","Northwest","Kathleen  Marshall",658]
["2013-10-25","Southwest","Elias  Ramsey",268]
["2013-10-20","Northwest","Elias  Ramsey",556]
["2013-10-22","Northwest","Natasha  Schneider",208]
["2013-10-25","Southwest","Cecil  Austin",559]
["2013-10-26","Southwest","Natasha  Schneider",530]
["2013-10-25","Southwest","Freda  Gregory",663]
["2013-10-21","Northwest","Natasha  Schneider",31]
["2013-10-20","West","Kim  Wolfe",587]
["2013-10-23","Southwest","Mildred  Leonard",280]
["2013-10-20","Northwest","Kim  Wolfe",488]
["2013-10-25","Southwest","Barry  Scott",609]
["2013-10-26","Northwest","Myron  Daniel",375]
["2013-10-25","Northwest","Mildred  Leonard",474]
["2013-10-23","Southwest","Sean  Hunter",323]
["2013-10-26","Southwest","Faith  Malone",650]
["2013-10-21","Northwest","Myron  Daniel",505]
["2013-10-20","Southwest","Alfred  Fuller",114]
["2013-10-20","Southwest","Freda  Gregory",483]
["2013-10-22","West","Lynn  Osborne",444]
["2013-10-26","Southwest","Lynn  Osborne",642]
["2013-10-22","Southwest","Freda  Gregory",241]
["2013-10-24","Southwest","Fred  Mullins",444]
["2013-10-23","Northwest","Lynn  Osborne",270]
["2013-10-23","Northwest","Elias  Ramsey",608]
["2013-10-26","West","Mildred  Leonard",498]
["2013-10-21","Northwest","Myron  Daniel",100]
["2013-10-22","Northwest","Mildred  Leonard",379]
["2013-10-22","Southwest","Elias  Ramsey",332]
["2013-10-26","Northwest","Kathleen  Marshall",13]
["2013-10-26","Southwest","Sean  Hunter",456]
["2013-10-21","Southwest","Natasha  Schneider",249]
["2013-10-26","West","Kathleen  Marshall",324]
["2013-10-22","West","John  Lucas",423]
["2013-10-20","West","Alexis  Gill",220]
["2013-10-20","Southwest","Elias  Ramsey",47]
["2013-10-20","West","Mildred  Leonard",651]
["2013-10-21","West","Elias  Ramsey",89]
["2013-10-23","Southwest","Myron  Daniel",590]
["2013-10-24","Northwest","Mildred  Leonard",681]
["2013-10-20","Northwest","Kim  Wolfe",538]
["2013-10-20","West","Kurt  Hill",562]
["2013-10-24","Northwest","Faith  Malone",97]
["2013-10-22","Southwest","Tony  Pierce",583]
["2013-10-25","Northwest","Myron  Daniel",268]
["2013-10-26","Northwest","Sean  Hunter",443]
["2013-10-26","West","Sheila  Smith",455]
["2013-10-23","Southwest","Jermaine  Sherman",663]
["2013-10-22","West","Kathleen  Marshall",518]
["2013-10-25","West","Brad  Dawson",621]
["2013-10-21","Northwest","Kathleen  Marshall",645]
["2013-10-21","Southwest","Kathleen  Marshall",131]
["2013-10-24","Southwest","Elias  Ramsey",130]
["2013-10-26","West","Wilbert  Moreno",415]
["2013-10-23","Southwest","Mildred  Leonard",119]
["2013-10-22","Southwest","Elias  Ramsey",307]
["2013-10-21","Southwest","Freda  Gregory",472]
["2013-10-24","Southwest","Kim  Wolfe",136]
["2013-10-21","Northwest","Kathleen  Marshall",586]
["2013-10-22","West","Kathleen  Marshall",215]
["2013-10-22","Northwest","Myron  Daniel",562]
["2013-10-21","Southwest","Aaron  Adkins",662]
["2013-10-23","Southwest","Mildred  Leonard",419]
["2013-10-24","West","Tony  Pierce",508]
["2013-10-23","Southwest","Kathleen  Marshall",170]
["2013-10-20","Southwest","John  Lucas",586]
["2013-10-24","Southwest","Barry  Scott",219]
["2013-10-24","Southwest","Alfred  Fuller",339]
["2013-10-24","Southwest","Faith  Malone",198]
["2013-10-23","Northwest","Kim  Wolfe",674]
["2013-10-21","Northwest","Elias  Ramsey",399]
["2013-10-22","Northwest","Kim  Wolfe",615]
["2013-10-21","Northwest","Mildred  Leonard",107]
["2013-10-24","Northwest","Sean  Hunter",199]
["2013-10-25","West","Alfred  Fuller",23]
["2013-10-20","Southwest","Myron  Daniel",297]
["2013-10-20","Northwest","Alfred  Fuller",273]
["2013-10-26","West","Sean  Hunter",281]
["2013-10-22","Southwest","Alfred  Fuller",227]
["2013-10-26","Northwest","Barry  Scott",156]
["2013-10-25","Southwest","Alfred  Fuller",534]
["2013-10-22","Southwest","Elias  Ramsey",459]
["2013-10-21","Southwest","Barry  Scott",131]
["2013-10-20","West","Barry  Scott",339]
["2013-10-21","Northwest","Aaron  Adkins",634]
["2013-10-21","Northwest","Kim  Wolfe",450]
["2013-10-25","West","Janet  Murphy",65]
["2013-10-26","Southwest","Natasha  Schneider",530]
["2013-10-22","Southwest","Kim  Wolfe",74]
["2013-10-26","Southwest","Cecil  Austin",93]
["2013-10-21","Northwest","Kurt  Hill",337]
["2013-10-20","Northwest","Kathleen  Marshall",583]
["2013-10-23","West","Barry  Scott",374]
["2013-10-22","Northwest","Elias  Ramsey",243]
["2013-10-21","West","Alexis  Gill",225]
["2013-10-26","Southwest","Mildred  Leonard",160]
["2013-10-21","West","Natasha  Schneider",502]
["2013-10-25","Northwest","Alfred  Fuller",221]
["2013-10-21","Southwest","Wilbert  Moreno",516]
["2013-10-26","West","Mildred  Leonard",678]
["2013-10-22","Northwest","Lynn  Osborne",637]
["2013-10-21","Northwest","Mildred  Leonard",525]
["2013-10-25","Southwest","Lynn  Osborne",540]
["2013-10-23","West","Elias  Ramsey",245]
["2013-10-20","Northwest","Lynn  Osborne",290]
["2013-10-21","Southwest","Alfred  Fuller",376]
["2013-10-22","Southwest","Elias  Ramsey",226]
["2013-10-26","Northwest","Barry  Scott",38]
["2013-10-23","Northwest","Myron  Daniel",283]
["2013-10-21","West","Kim  Wolfe",480]
["2013-10-21","West","Velma  Bennett",482]
["2013-10-26","Southwest","Elias  Ramsey",37]
["2013-10-23","Southwest","Natasha  Schneider",279]
["2013-10-23","West","Kathleen  Marshall",152]
["2013-10-20","Northwest","Aaron  Adkins",419]
["2013-10-23","West","Freda  Gregory",652]
["2013-10-21","Southwest","Alfred  Fuller",151]
["2013-10-20","Northwest","Kim  Wolfe",99]
["2013-10-25","Northwest","Lynn  Osborne",432]
["2013-10-21","Northwest","Kim  Wolfe",174]
["2013-10-23","Northwest","Kurt  Hill",209]
["2013-10-23","Northwest","Lynn  Osborne",261]
["2013-10-26","Southwest","Lynn  Osborne",633]
["2013-10-26","West","Natasha  Schneider",308]
["2013-10-26","West","Lynn  Osborne",319]
["2013-10-20","West","Aaron  Adkins",400]
["2013-10-24","West","Tony  Pierce",20]
["2013-10-26","Northwest","Barry  Scott",151]
["2013-10-21","Southwest","Tony  Pierce",345]
["2013-10-24","Southwest","Natasha  Schneider",78]
["2013-10-23","West","Kim  Wolfe",81]
["2013-10-23","West","Myron  Daniel",563]
["2013-10-20","Southwest","Myron  Daniel",344]
["2013-10-23","West","Lynn  Osborne",103]
["2013-10-20","Southwest","Natasha  Schneider",378]
["2013-10-26","West","Lynn  Osborne",546]
["2013-10-23","West","Barry  Scott",649]
["2013-10-21","Northwest","Myron  Daniel",387]
["2013-10-20","West","Elias  Ramsey",468]
["2013-10-22","Southwest","Natasha  Schneider",36]
["2013-10-23","Southwest","Sean  Hunter",576]
["2013-10-24","Northwest","Barry  Scott",304]
["2013-10-23","Northwest","Tony  Pierce",648]
["2013-10-21","Southwest","Sean  Hunter",624]
["2013-10-23","Southwest","Myron  Daniel",199]
["2013-10-22","West","Kathleen  Marshall",21]
["2013-10-23","Northwest","Sheila  Smith",173]
["2013-10-23","Northwest","Kim  Wolfe",149]
["2013-10-24","West","Barry  Scott",294]
["2013-10-20","Southwest","Alfred  Fuller",225]
["2013-10-22","Southwest","John  Lucas",276]
["2013-10-22","Northwest","Mildred  Leonard",666]
["2013-10-23","West","Jermaine  Sherman",616]
["2013-10-21","Northwest","Barry  Scott",307]
["2013-10-23","Southwest","Kim  Wolfe",140]
["2013-10-24","West","Barry  Scott",632]
["2013-10-25","West","Lynn  Osborne",461]
["2013-10-21","West","Natasha  Schneider",656]
["2013-10-22","West","Tony  Pierce",158]
["2013-10-23","Northwest","Kathleen  Marshall",663]
["2013-10-24","Southwest","Elias  Ramsey",555]
["2013-10-23","West","Fred  Mullins",489]
["2013-10-22","West","Elias  Ramsey",212]
["2013-10-20","Southwest","Jermaine  Sherman",411]
["2013-10-23","Northwest","Barry  Scott",343]
["2013-10-22","West","Kathleen  Marshall",629]
["2013-10-21","Northwest","Wilbert  Moreno",247]
["2013-10-25","Southwest","Mildred  Leonard",180]
["2013-10-25","Southwest","Freda  Gregory",374]
["2013-10-22","West","Wilbert  Moreno",672]
["2013-10-25","Southwest","Myron  Daniel",484]
["2013-10-26","Southwest","Elias  Ramsey",77]
["2013-10-26","West","Velma  Bennett",315]
["2013-10-23","Southwest","Alfred  Fuller",462]
["2013-10-22","Southwest","Mildred  Leonard",470]
["2013-10-20","West","Myron  Daniel",102]
["2013-10-20","West","Sean  Hunter",161]
["2013-10-21","Northwest","Freda  Gregory",651]
["2013-10-21","Northwest","Natasha  Schneider",28]
["2013-10-26","Northwest","Alfred  Fuller",222]
["2013-10-25","West","Mildred  Leonard",399]
["2013-10-22","Northwest","Janet  Murphy",570]
["2013-10-25","West","Velma  Bennett",119]
["2013-10-24","Northwest","Natasha  Schneider",219]
["2013-10-24","West","Barry  Scott",466]
["2013-10-22","Southwest","Elias  Ramsey",225]
["2013-10-21","West","Wilbert  Moreno",293]
["2013-10-23","Southwest","Kathleen  Marshall",217]
["2013-10-25","Northwest","Barry  Scott",547]
["2013-10-25","Northwest","Lynn  Osborne",449]
["2013-10-26","West","Kim  Wolfe",185]
["2013-10-26","Northwest","Lynn  Osborne",579]
["2013-10-21","Northwest","Barry  Scott",675]
["2013-10-23","Southwest","Barry  Scott",239]
["2013-10-22","Northwest","Myron  Daniel",152]
["2013-10-24","Northwest","Barry  Scott",210]
["2013-10-25","Southwest","Janet  Murphy",573]
["2013-10-26","West","Barry  Scott",19]
["2013-10-21","Southwest","Alexis  Gill",478]
["2013-10-21","Northwest","Alfred  Fuller",565]
["2013-10-24","Southwest","Kathleen  Marshall",169]
["2013-10-24","Northwest","Elias  Ramsey",329]
["2013-10-24","Southwest","Lynn  Osborne",115]
["2013-10-20","Northwest","Natasha  Schneider",524]
["2013-10-26","Southwest","Natasha  Schneider",550]
["2013-10-22","Southwest","Mildred  Leonard",514]
["2013-10-20","Southwest","Barry  Scott",223]
["2013-10-25","Southwest","Myron  Daniel",667]
["2013-10-20","Southwest","Alfred  Fuller",314]
["2013-10-26","Northwest","Alexis  Gill",228]
["2013-10-22","Northwest","Jermaine  Sherman",193]
["2013-10-26","West","Lynn  Osborne",509]
["2013-10-21","Northwest","Brad  Dawson",529]
["2013-10-26","Northwest","Alexis  Gill",416]
["2013-10-22","West","Velma  Bennett",532]
["2013-10-22","West","Alfred  Fuller",639]
["2013-10-22","Southwest","Aaron  Adkins",115]
["2013-10-20","West","Barry  Scott",145]
["2013-10-26","Northwest","Aaron  Adkins",349]
["2013-10-24","Northwest","Kathleen  Marshall",98]
["2013-10-24","Southwest","Jermaine  Sherman",342]
["2013-10-20","Southwest","Barry  Scott",234]

{"sheet":"PT-HW-2-Answer","index":15,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Sales"]
["Jermaine  Sherman",6027]
["Elias  Ramsey",15181]
["Barry  Scott",13915]
["Alfred  Fuller",14779]
["Kim  Wolfe",15449]
["Myron  Daniel",14079]
["Lynn  Osborne",17520]
["Alexis  Gill",4860]
["Mildred  Leonard",15973]
["Velma  Bennett",4485]
["Fred  Mullins",2485]
["Brad  Dawson",4368]
["Natasha  Schneider",12691]
["Kathleen  Marshall",16838]
["Wilbert  Moreno",3017]
["Tony  Pierce",6024]
["Freda  Gregory",6436]
["Sean  Hunter",5527]
["Faith  Malone",4662]
["Sheila  Smith",1941]
["Cecil  Austin",2939]
["John  Lucas",2287]
["Aaron  Adkins",4047]
["Janet  Murphy",3204]
["Kurt  Hill",4284]
["Grand Total",203018]

{"sheet":"HW(3)","index":16,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["In the range C5:C29 calculate the deduction for each person (deduction = Gross * Tax Rate)."]
[]
[]
["Name","Gross","Deduction",null,"Tax Rate"]
["Fred  Mullins",1490,null,null,1.4500000000000001E-2]
["Janet  Murphy",1196]
["Faith  Malone",796]
["Aaron  Adkins",1473]
["Natasha  Schneider",1162]
["Kathleen  Marshall",1179]
["Lynn  Osborne",706]
["Kim  Wolfe",1024]
["Barry  Scott",1026]
["Myron  Daniel",731]
["Alfred  Fuller",1356]
["Mildred  Leonard",1202]
["Elias  Ramsey",1227]
["Jermaine  Sherman",1106]
["Sean  Hunter",1258]
["Brad  Dawson",732]
["Cecil  Austin",1379]
["Tony  Pierce",1245]
["Freda  Gregory",1347]
["Alexis  Gill",1096]
["Wilbert  Moreno",792]
["Kurt  Hill",924]
["John  Lucas",923]
["Velma  Bennett",1489]
["Sheila  Smith",1253]

{"sheet":"HW(3an)","index":17,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["In the range C5:C29 calculate the deduction for each person (deduction = Gross * Tax Rate)."]
[]
[]
["Name","Gross","Deduction",null,"Tax Rate"]
["Fred  Mullins",1490,{"$f":"B5*$E$5","v":233.93},null,0.157]
["Janet  Murphy",1196,{"$f":"B6*$E$5","v":187.77199999999999}]
["Faith  Malone",796,124.97199999999999]
["Aaron  Adkins",1473,231.261]
["Natasha  Schneider",1162,182.434]
["Kathleen  Marshall",1179,185.10300000000001]
["Lynn  Osborne",706,110.842]
["Kim  Wolfe",1024,160.768]
["Barry  Scott",1026,161.08199999999999]
["Myron  Daniel",731,114.767]
["Alfred  Fuller",1356,212.892]
["Mildred  Leonard",1202,188.714]
["Elias  Ramsey",1227,192.63900000000001]
["Jermaine  Sherman",1106,173.642]
["Sean  Hunter",1258,197.506]
["Brad  Dawson",732,114.92400000000001]
["Cecil  Austin",1379,216.50300000000001]
["Tony  Pierce",1245,195.465]
["Freda  Gregory",1347,211.47900000000001]
["Alexis  Gill",1096,172.072]
["Wilbert  Moreno",792,124.34399999999999]
["Kurt  Hill",924,145.06800000000001]
["John  Lucas",923,144.911]
["Velma  Bennett",1489,233.773]
["Sheila  Smith",1253,196.721]

{"sheet":"HW(4)","index":18,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["In Table 1, sort the Assembly Time (mins) field so that the smallest numbers appear at the top of the column. Then, in Table 2,  sort the Number Of Practice Laps field so that the biggest numbers appear on top."]
[]
["Table 1:",null,null,null,null,null,"Table 2:"]
[]
["Name","Assemby Time (mins)","Shift",null,null,null,"Racer","Number Of Practice Laps"]
["Jesse  Barton",8.43,"Shift 3",null,null,null,"Isaac",9]
["Robin  Ruiz",7.06,"Shift 1",null,null,null,"Caden",25]
["Dean  King",10.8,"Shift 1",null,null,null,"Ella",32]
["Douglas  Stevens",7.03,"Shift 3",null,null,null,"Halle",21]
["Jean  French",11.64,"Shift 2",null,null,null,"Logan",18]
["Sherri  Daniels",8.2899999999999991,"Shift 3",null,null,null,"Zaine",29]
["Ernestine  Watkins",11.92,"Shift 1",null,null,null,"Magic",5]
["Clark  Waters",5.57,"Shift 3",null,null,null,"Rob",15]
["Otis  Weaver",7.92,"Shift 2",null,null,null,"Walt",9]
["Stanley  Steele",11.4,"Shift 3"]
["Evelyn  Morgan",8.83,"Shift 2"]
["Ernest  Guerrero",11.94,"Shift 1"]
["Geraldine  Ramirez",9.6,"Shift 3"]
["Joey  Lyons",6.67,"Shift 1"]
["Ivan  Hamilton",11.76,"Shift 2"]
["Jenny  Dean",8.43,"Shift 2"]
["Eloise  Barber",5.82,"Shift 3"]
["Bernard  Ryan",7.38,"Shift 3"]
["Hector  Martinez",6.24,"Shift 2"]
["Josh  Lindsey",5.29,"Shift 2"]
["Rita  Fuller",10.33,"Shift 1"]
["Lena  Hubbard",5.99,"Shift 1"]
["Cody  Carlson",5.9,"Shift 2"]
["Kent  West",8.8699999999999992,"Shift 1"]
["Sadie  Richardson",6.46,"Shift 1"]

{"sheet":"HW(4an)","index":19,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["In Table 1, sort the Assembly Time (mins) field so that the smallest numbers appear at the top of the column. Then, in Table 2,  sort the Number Of Practice Laps field so that the biggest numbers appear on top."]
[]
["Table 1:",null,null,null,null,null,"Table 2:"]
[]
["Name","Assemby Time (mins)","Shift",null,null,null,"Racer","Number Of Practice Laps"]
["Josh  Lindsey",5.29,"Shift 2",null,null,null,"Ella",32]
["Clark  Waters",5.57,"Shift 3",null,null,null,"Zaine",29]
["Eloise  Barber",5.82,"Shift 3",null,null,null,"Caden",25]
["Cody  Carlson",5.9,"Shift 2",null,null,null,"Halle",21]
["Lena  Hubbard",5.99,"Shift 1",null,null,null,"Logan",18]
["Hector  Martinez",6.24,"Shift 2",null,null,null,"Rob",15]
["Sadie  Richardson",6.46,"Shift 1",null,null,null,"Isaac",9]
["Joey  Lyons",6.67,"Shift 1",null,null,null,"Walt",9]
["Douglas  Stevens",7.03,"Shift 3",null,null,null,"Magic",5]
["Robin  Ruiz",7.06,"Shift 1"]
["Bernard  Ryan",7.38,"Shift 3"]
["Otis  Weaver",7.92,"Shift 2"]
["Sherri  Daniels",8.2899999999999991,"Shift 3"]
["Jesse  Barton",8.43,"Shift 3"]
["Jenny  Dean",8.43,"Shift 2"]
["Evelyn  Morgan",8.83,"Shift 2"]
["Kent  West",8.8699999999999992,"Shift 1"]
["Geraldine  Ramirez",9.6,"Shift 3"]
["Rita  Fuller",10.33,"Shift 1"]
["Dean  King",10.8,"Shift 1"]
["Stanley  Steele",11.4,"Shift 3"]
["Jean  French",11.64,"Shift 2"]
["Ivan  Hamilton",11.76,"Shift 2"]
["Ernestine  Watkins",11.92,"Shift 1"]
["Ernest  Guerrero",11.94,"Shift 1"]

{"sheet":"HW(5)","index":20,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Convert the Proper Data Set for classes and grades below to an Excel Table."]
["Give the Excel Table a smart name."]
["In cell D9, use the built-in AVERAGE function to calculate the GPA."]
["Then make a column chart that shows the class name on the horizontal axis and column heights as grades."]
["Finally, add a few records to see if the dynamic range aspect of the Excel Table feature is working."]
[]
[]
["Class","Grade",null,"GPA (Average)"]
["Busn 101",2.8,null,null,"<<== use AVERAGE function here."]
["Busn 135",2.7]
["Busn 125",3.7]
["Busn 125",4]
["ENGL 101",3.1]

{"sheet":"HW(5an)","index":21,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Convert the Proper Data Set for classes and grades below to an Excel Table."]
["Give the Excel Table a smart name."]
["In cell D9, use the built-in AVERAGE function to calculate the GPA."]
["Then make a column chart that shows the class name on the horizontal axis and column heights as grades."]
["Then, add a few records to see if the dynamic range aspect of the Excel Table feature is working."]
["What happens to the chart if you sort the Grade field?"]
[]
["Class","Grade",null,"GPA (Average)"]
["Busn 135",2.7,null,{"$f":"AVERAGE(AnswerGradeTable[Grade])","v":3.3142857142857141},"<<== use AVERAGE function here."]
["Busn 101",2.8]
["Busn 216",2.9]
["ENGL 101",3.1]
["Busn 125",3.7]
["Busn 125",4]
["Busn 214",4]