{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Topics","T","T (an)","D","D (an)","Chart1(an)","PP","PP (an)","Combo2ndAxis","Combo2ndAxis (an)","H","H (an)","DP","DP (an)","CF","CF (an)","BE","BE (an)","HW==>>","(1)","(1an)","(2)","(2an)","(3)","(3an)","(4)","(4an)"],"not_rendered":{"charts":18,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart1(an)","index":5,"reason":"not_a_worksheet"}],"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":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Video","Topics:"]
[42,"Save Chart As Template"]
[43,"Set Default Chart"]
[null,"Keyboard for chart on Active Sheet = Alt + F1"]
[null,"Keyboard for chart on New Sheet = F11"]
[44,"Pie within Pie"]
[45,"Combine Chart Types"]
[null,"Plot Secondary Axis"]
[46,"Statistics: Histogram"]
[47,"Statistics: Dot Plot"]
[48,"Conditional Formatting: Bar Chart with Data Labels"]
[49,"Accounting Chart: Break Even Analysis with Sales, Fixed & Variable Costs: Formulas & Chart",null,null,null,null,null,null,null,null,null,null,"http://www.youtube.com/watch?v=7MxlVMzRxa8"]

{"sheet":"T","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Cities","Revenues",null,"Highline Excel 2013 Class Video 42: Save Chart As Template in Excel 2013"]
["Seattle",520698]
["Tacoma",358412]
["Oakland",698544]
["SF",258900]
[]
[]
["Cities","Revenues"]
["Seattle",520698]
["Tacoma",358412]
["Oakland",698544]
["Burien",198200]
["SF",258900]

{"sheet":"T (an)","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Cities","Revenues",null,"Highline Excel 2013 Class Video 42: Save Chart As Template in Excel 2013"]
["Seattle",520698]
["Tacoma",358412]
["Oakland",698544]
["SF",258900]
[]
[]
["Cities","Revenues"]
["Seattle",520698]
["Tacoma",358412]
["Oakland",698544]
["Burien",198200]
["SF",258900]

{"sheet":"D","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Cities","Revenues",null,"Highline Excel 2013 Class Video 43: Set Default Chart in Excel 2013, Keyboard Shortcuts Default Charts"]
["Seattle",520698]
["Tacoma",358412,null,"Keyboard for chart on Active Sheet = Alt + F1"]
["Oakland",698544,null,"Keyboard for chart on New Sheet = F11"]
["SF",258900]
[]
[]
["Cities","Revenues"]
["Seattle",520698]
["Tacoma",358412]
["Oakland",698544]
["Burien",198200]
["SF",258900]

{"sheet":"D (an)","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Cities","Revenues",null,"Highline Excel 2013 Class Video 43: Set Default Chart in Excel 2013, Keyboard Shortcuts Default Charts"]
["Seattle",520698]
["Tacoma",358412,null,"Keyboard for chart on Active Sheet = Alt + F1"]
["Oakland",698544,null,"Keyboard for chart on New Sheet = F11"]
["SF",258900]
[]
[]
["Cities","Revenues"]
["Seattle",520698]
["Tacoma",358412]
["Oakland",698544]
["Burien",198200]
["SF",258900]

{"sheet":"PP","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Cities","Revenues",null,"Highline Excel 2013 Class Video 44: Pie within Pie Chart in Excel 2013"]
["Oakland",698544]
["Seattle",520698]
["Tacoma",358412]
["SF",258900]
["Burien",198200]
["Richland",150900]
["Sumner",39500]
["Tukwila",25489]
["SeaTac",25233]
["Lynwood",22500]

{"sheet":"PP (an)","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Cities","Revenues",null,"Highline Excel 2013 Class Video 44: Pie within Pie Chart in Excel 2013"]
["Oakland",698544]
["Seattle",520698]
["Tacoma",358412]
["SF",258900]
["Burien",198200]
["Richland",150900]
["Sumner",39500]
["Tukwila",25489]
["SeaTac",25233]
["Lynwood",22500]

{"sheet":"Combo2ndAxis","index":8,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 45: Combining Chart Types and Secondary Axis in Excel 2013"]
[]
["Month","Revenue","Expenses",{"$f":"C3&\" as % of Rev\"","v":"Expenses as % of Rev"}]
["Jan",113154,65629,0.57999717199568734]
["Feb",209650,106922,0.51000238492725969]
["Mar",171989,73955,0.4299984301321596]
["Apr",109243,39327,0.35999560612579296]
["May",103826,55028,0.5300021189297478]
["Jun",86504,39792,0.46000184962545082]

{"sheet":"Combo2ndAxis (an)","index":9,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 45: Combining Chart Types and Secondary Axis in Excel 2013"]
[]
["Month","Revenue","Expenses",{"$f":"C3&\" as % of Rev\"","v":"Expenses as % of Rev"}]
["Jan",113154,65629,0.57999717199568734]
["Feb",209650,106922,0.51000238492725969]
["Mar",171989,73955,0.4299984301321596]
["Apr",109243,39327,0.35999560612579296]
["May",103826,55028,0.5300021189297478]
["Jun",86504,39792,0.46000184962545082]

{"sheet":"H","index":10,"n_rows":189,"n_cols":7,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 46: Statistics: Histogram Formulas and Chart in Excel 2013"]
[]
["Student Grades",null,"Min",{"$f":"MIN(A4:A189)","v":0.63},null,"Why Columns touching: Continuous Data: No Gaps."]
[50.59,null,"Max",{"$f":"MAX(A4:A189)","v":106},null,"Title:","Student Grades on Stats Final"]
[79.12,null,"Start",0]
[59.78,null,"Increment",10]
[37.36]
[81.819999999999993,null,"Min","Max","Grade Categories","Frequency"]
[57.11]
[82.82]
[74.92]
[76.45]
[81.8]
[78.27]
[41.98]
[53.44]
[56.7]
[71.31]
[19.43]
[59.55]
[73.83,null,null,null,"Grade\nCategories"]
[80.400000000000006]
[17.68]
[100.59]
[91.79]
[36.46]
[82.9]
[42.27]
[82.67]
[61.07]
[82.97]
[92.41]
[88.47]
[82.86]
[90.01]
[81.44]
[84.25]
[90.56]
[69.28]
[6.08]
[73.83]
[84.2]
[77.61]
[82.82]
[24.42]
[74.260000000000005]
[78.709999999999994]
[71.489999999999995]
[65.849999999999994]
[70.16]
[95.75]
[77.3]
[81.75]
[54.64]
[69.459999999999994]
[50.05]
[62.05]
[64.92]
[73.81]
[16.63]
[6.89]
[77.150000000000006]
[96.85]
[90.08]
[74.930000000000007]
[85.85]
[83.33]
[93.64]
[74.87]
[59.98]
[95.42]
[19.510000000000002]
[58.84]
[52.22]
[62.9]
[81.87]
[67.959999999999994]
[94.78]
[74.760000000000005]
[76.09]
[67.12]
[72.67]
[71.319999999999993]
[70.69]
[39.78]
[50.23]
[62.6]
[46.66]
[52.04]
[105.5]
[47.64]
[91.32]
[80.17]
[24.65]
[86.74]
[45.41]
[48.35]
[100.87]
[15.71]
[40.36]
[68.709999999999994]
[85.88]
[56.39]
[91.77]
[73.930000000000007]
[84.67]
[60.74]
[106]
[14.6]
[20.25]
[46.21]
[81.58]
[61.54]
[90.52]
[11.47]
[79.510000000000005]
[85.26]
[91.58]
[92.33]
[71.02]
[17.149999999999999]
[61.68]
[80.67]
[32.11]
[68.459999999999994]
[16.079999999999998]
[89.13]
[94.31]
[95.44]
[45.88]
[83.85]
[77.989999999999995]
[65.23]
[69.989999999999995]
[74.09]
[83.28]
[86.53]
[89.88]
[71.42]
[79.680000000000007]
[83.29]
[8.3699999999999992]
[61.75]
[59.96]
[77.569999999999993]
[71.5]
[81.319999999999993]
[73.150000000000006]
[49.61]
[90.56]
[72.41]
[72.09]
[53.63]
[9.7899999999999991]
[66.63]
[64.2]
[94.24]
[13.73]
[89.6]
[72.150000000000006]
[75.739999999999995]
[87.54]
[49.11]
[94.78]
[80.89]
[36.450000000000003]
[26.79]
[87.61]
[57.41]
[69.45]
[34.21]
[73.430000000000007]
[87.38]
[56.91]
[72.010000000000005]
[3.01]
[84.48]
[71.11]
[50.16]
[82.13]
[94.55]
[65.959999999999994]
[81.400000000000006]
[5.85]
[27.25]
[83.28]
[68.94]
[0.63]
[19.82]

{"sheet":"H (an)","index":11,"n_rows":189,"n_cols":7,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 46: Statistics: Histogram Formulas and Chart in Excel 2013"]
[]
["Student Grades",null,"Min",{"$f":"MIN(A4:A189)","v":0.63},null,"Why Columns touching: Continuous Data: No Gaps."]
[50.59,null,"Max",{"$f":"MAX(A4:A189)","v":106},null,"Title:","Student Grades on Stats Final"]
[79.12,null,"Start",0]
[59.78,null,"Increment",10]
[37.36]
[81.819999999999993,null,"Min","Max","Grade Categories","Frequency"]
[57.11,null,{"$f":"D5","v":0},{"$f":"C9+$D$6","v":10},{"$f":"\">=\"&C9&CHAR(10)&\"AND\"&CHAR(10)&\"<\"&D9","v":">=0\nAND\n<10"},{"$f":"COUNTIFS($A$4:$A$189,\">=\"&C9,$A$4:$A$189,\"<\"&D9)","v":7}]
[82.82,null,{"$f":"D9","v":10},{"$f":"C10+$D$6","v":20},{"$f":"\">=\"&C10&CHAR(10)&\"AND\"&CHAR(10)&\"<\"&D10","v":">=10\nAND\n<20"},{"$f":"COUNTIFS($A$4:$A$189,\">=\"&C10,$A$4:$A$189,\"<\"&D10)","v":11}]
[74.92,null,{"$f":"D10","v":20},{"$f":"C11+$D$6","v":30},">=20\nAND\n<30",5]
[76.45,null,30,40,">=30\nAND\n<40",6]
[81.8,null,40,50,">=40\nAND\n<50",11]
[78.27,null,50,60,">=50\nAND\n<60",19]
[41.98,null,60,70,">=60\nAND\n<70",23]
[53.44,null,70,80,">=70\nAND\n<80",39]
[56.7,null,80,90,">=80\nAND\n<90",40]
[71.31,null,90,100,">=90\nAND\n<100",21]
[19.43,null,100,110,">=100\nAND\n<110",4]
[59.55]
[73.83,null,null,null,"Grade\nCategories"]
[80.400000000000006]
[17.68]
[100.59]
[91.79]
[36.46]
[82.9]
[42.27]
[82.67]
[61.07]
[82.97]
[92.41]
[88.47]
[82.86]
[90.01]
[81.44]
[84.25]
[90.56]
[69.28]
[6.08]
[73.83]
[84.2]
[77.61]
[82.82]
[24.42]
[74.260000000000005]
[78.709999999999994]
[71.489999999999995]
[65.849999999999994]
[70.16]
[95.75]
[77.3]
[81.75]
[54.64]
[69.459999999999994]
[50.05]
[62.05]
[64.92]
[73.81]
[16.63]
[6.89]
[77.150000000000006]
[96.85]
[90.08]
[74.930000000000007]
[85.85]
[83.33]
[93.64]
[74.87]
[59.98]
[95.42]
[19.510000000000002]
[58.84]
[52.22]
[62.9]
[81.87]
[67.959999999999994]
[94.78]
[74.760000000000005]
[76.09]
[67.12]
[72.67]
[71.319999999999993]
[70.69]
[39.78]
[50.23]
[62.6]
[46.66]
[52.04]
[105.5]
[47.64]
[91.32]
[80.17]
[24.65]
[86.74]
[45.41]
[48.35]
[100.87]
[15.71]
[40.36]
[68.709999999999994]
[85.88]
[56.39]
[91.77]
[73.930000000000007]
[84.67]
[60.74]
[106]
[14.6]
[20.25]
[46.21]
[81.58]
[61.54]
[90.52]
[11.47]
[79.510000000000005]
[85.26]
[91.58]
[92.33]
[71.02]
[17.149999999999999]
[61.68]
[80.67]
[32.11]
[68.459999999999994]
[16.079999999999998]
[89.13]
[94.31]
[95.44]
[45.88]
[83.85]
[77.989999999999995]
[65.23]
[69.989999999999995]
[74.09]
[83.28]
[86.53]
[89.88]
[71.42]
[79.680000000000007]
[83.29]
[8.3699999999999992]
[61.75]
[59.96]
[77.569999999999993]
[71.5]
[81.319999999999993]
[73.150000000000006]
[49.61]
[90.56]
[72.41]
[72.09]
[53.63]
[9.7899999999999991]
[66.63]
[64.2]
[94.24]
[13.73]
[89.6]
[72.150000000000006]
[75.739999999999995]
[87.54]
[49.11]
[94.78]
[80.89]
[36.450000000000003]
[26.79]
[87.61]
[57.41]
[69.45]
[34.21]
[73.430000000000007]
[87.38]
[56.91]
[72.010000000000005]
[3.01]
[84.48]
[71.11]
[50.16]
[82.13]
[94.55]
[65.959999999999994]
[81.400000000000006]
[5.85]
[27.25]
[83.28]
[68.94]
[0.63]
[19.82]

{"sheet":"DP","index":12,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Car Type",{"$f":"TRANSPOSE(C7:C10)","v":"Chevy"},"Ford","Honda","Toyota"]
[]
[]
["Cars Sold",null,"Car Type","Count"]
["Chevy",null,"Chevy",{"$f":"COUNTIF($A$7:$A$34,C7)","v":3}]
["Toyota",null,"Ford",{"$f":"COUNTIF($A$7:$A$34,C8)","v":4}]
["Chevy",null,"Honda",{"$f":"COUNTIF($A$7:$A$34,C9)","v":9}]
["Honda",null,"Toyota",{"$f":"COUNTIF($A$7:$A$34,C10)","v":12}]
["Toyota"]
["Chevy",null,"Highline Excel 2013 Class Video 47: Statistics: Dot Plot (Cell Chart)"]
["Ford"]
["Toyota"]
["Honda"]
["Honda"]
["Honda"]
["Ford"]
["Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Ford"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Honda"]
["Toyota"]
["Honda"]

{"sheet":"DP (an)","index":13,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"REPT(\"*\",COUNTIF($A$7:$A$34,B3))","v":"***"},{"$f":"REPT(\"*\",COUNTIF($A$7:$A$34,C3))","v":"****"},"*********","************"]
["Car Type",{"$f":"TRANSPOSE(C7:C10)","v":"Chevy"},"Ford","Honda","Toyota"]
[]
[]
["Cars Sold",null,"Car Type","Count"]
["Chevy",null,"Chevy",{"$f":"COUNTIF($A$7:$A$34,C7)","v":3}]
["Toyota",null,"Ford",{"$f":"COUNTIF($A$7:$A$34,C8)","v":4}]
["Chevy",null,"Honda",{"$f":"COUNTIF($A$7:$A$34,C9)","v":9}]
["Honda",null,"Toyota",{"$f":"COUNTIF($A$7:$A$34,C10)","v":12}]
["Toyota"]
["Chevy",null,"Highline Excel 2013 Class Video 47: Statistics: Dot Plot (Cell Chart)"]
["Ford"]
["Toyota"]
["Honda"]
["Honda"]
["Honda"]
["Ford"]
["Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Ford"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Honda"]
["Toyota"]
["Honda"]

{"sheet":"CF","index":14,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 48: Conditional Formatting: Bar Chart with Data Labels"]
[]
[]
["Cars Sold",null,"Car Type","Bar"]
["Chevy",null,"Chevy"]
["Toyota",null,"Ford"]
["Chevy",null,"Honda"]
["Honda",null,"Toyota"]
["Toyota"]
["Chevy"]
["Ford"]
["Toyota"]
["Honda"]
["Honda"]
["Honda"]
["Ford"]
["Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Ford"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Honda"]
["Toyota"]
["Honda"]

{"sheet":"CF (an)","index":15,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 48: Conditional Formatting: Bar Chart with Data Labels"]
[]
[]
["Cars Sold",null,"Car Type","Bar"]
["Chevy",null,"Chevy",{"$f":"COUNTIF($A$5:$A$32,C5)","v":3}]
["Toyota",null,"Ford",{"$f":"COUNTIF($A$5:$A$32,C6)","v":4}]
["Chevy",null,"Honda",9]
["Honda",null,"Toyota",12]
["Toyota"]
["Chevy"]
["Ford"]
["Toyota"]
["Honda"]
["Honda"]
["Honda"]
["Ford"]
["Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Ford"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Honda"]
["Toyota"]
["Honda"]

{"sheet":"BE","index":16,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 49: Break Even Analysis Formulas & Chart, Plotting Break Even Point",null,null,null,null,null,null,null,null,null,null,null,"Videos that show how to create table:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Excel Magic Trick # 254: Data Table Creates 100 Formulas"]
["Assumptions"]
["Time","Units Start","Units increment","Unit Price","Unit Variable Cost","Total Fixed Costs"]
["Month",0,100,45,35,4000]
[]
["Units","Sales","Variable Cost","Contribution Margin","Fixed","Total Costs","Net Income"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Break Even x","Break Even y","Label"]
[]
[]
[null,"0 = Units*(S - VC) - FC"]
[null,"FC = Units*(S - VC)"]
[null,"Units = FC/(S - VC)"]

{"sheet":"BE (an)","index":17,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2013 Class Video 49: Break Even Analysis Formulas & Chart, Plotting Break Even Point",null,null,null,null,null,null,null,null,null,null,null,"Videos that show how to create table:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Excel Magic Trick # 254: Data Table Creates 100 Formulas"]
["Assumptions"]
["Time","Units Start","Units increment","Unit Price","Unit Variable Cost","Total Fixed Costs"]
["Month",0,100,45,35,4000]
[]
["Units","Sales","Variable Cost","Contribution Margin","Fixed","Total Costs","Net Income"]
[{"$f":"B5","v":0},{"$f":"$A8*D$5","v":0},0,{"$f":"B8-C8","v":0},{"$f":"$F$5","v":4000},{"$f":"E8+C8","v":4000},{"$f":"B8-F8","v":-4000},{"$f":"D8-E8","v":-4000}]
[{"$f":"A8+$C$5","v":100},4500,3500,{"$f":"B9-C9","v":1000},{"$f":"$F$5","v":4000},{"$f":"E9+C9","v":7500},{"$f":"B9-F9","v":-3000},{"$f":"D9-E9","v":-3000}]
[{"$f":"A9+$C$5","v":200},9000,7000,2000,4000,11000,-2000,-2000]
[300,13500,10500,3000,4000,14500,-1000,-1000]
[400,18000,14000,4000,4000,18000,0,0]
[500,22500,17500,5000,4000,21500,1000,1000]
[600,27000,21000,6000,4000,25000,2000,2000]
[700,31500,24500,7000,4000,28500,3000,3000]
[800,36000,28000,8000,4000,32000,4000,4000]
[900,40500,31500,9000,4000,35500,5000,5000]
[1000,45000,35000,10000,4000,39000,6000,6000]
[]
[null,"Break Even x","Break Even y","Label"]
[null,{"$f":"ROUND(F5/(D5-E5),0)","v":400},{"$f":"B21*D5","v":18000},{"$f":"\"Aprox BEU = \"&B21","v":"Aprox BEU = 400"}]
[]
[null,"0 = Units*(S - VC) - FC"]
[null,"FC = Units*(S - VC)"]
[null,"Units = FC/(S - VC)"]

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

{"sheet":"(1)","index":19,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Create a Combo Chart that shows Rev and Ex as columns and the percentage as a line."]
[]
["Month","Revenue","Expenses",{"$f":"C3&\" as % of Rev\"","v":"Expenses as % of Rev"}]
["Jul",8520,4260,0.5]
["Aug",16181,7929,0.49001915827204745]
["Sep",4558,1732,0.37999122422114961]
["Oct",22421,6726,0.29998661968690066]
["Nov",18557,7794,0.42000323328124156]
["Dec",16557,6292,0.38002053512109679]

{"sheet":"(1an)","index":20,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Create a Combo Chart that shows Rev and Ex as columns and the percentage as a line."]
[]
["Month","Revenue","Expenses",{"$f":"C3&\" as % of Rev\"","v":"Expenses as % of Rev"}]
["Jul",8520,4260,0.5]
["Aug",16181,7929,0.49001915827204745]
["Sep",4558,1732,0.37999122422114961]
["Oct",22421,6726,0.29998661968690066]
["Nov",18557,7794,0.42000323328124156]
["Dec",16557,6292,0.38002053512109679]

{"sheet":"(2)","index":21,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Create a Pie within a Pie chart"]
[]
["Cities","Revenues"]
["Burien",927043]
["Lynwood",111606]
["Oakland",1495786]
["Richland",988880]
["SeaTac",225072]
["Seattle",1323941]
["SF",1339865]
["Sumner",146620]
["Tacoma",857573]
["Tukwila",122041]

{"sheet":"(2an)","index":22,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Create a Pie within a Pie chart"]
[]
["Cities","Revenues"]
["Oakland",1995786]
["SF",1339865]
["Seattle",1323941]
["Richland",988880]
["Burien",927043]
["SeaTac",225072]
["Tacoma",158900]
["Sumner",146620]
["Tukwila",122041]
["Lynwood",69580]

{"sheet":"(3)","index":23,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Create a Dot Plot from the data below"]
[]
[]
[]
["Drinks"]
["Coke"]
["Pepsi"]
["RC Cola"]
["Coke"]
["Coke"]
["Pepsi"]
["Pepsi"]
["Coke"]
["Coke"]
["Pepsi"]
["Pepsi"]
["Coke"]
["RC Cola"]
["RC Cola"]
["Coke"]
["RC Cola"]
["Pepsi"]
["Coke"]
["RC Cola"]
["RC Cola"]
["Coke"]
["Pepsi"]
["RC Cola"]
["RC Cola"]
["Coke"]
["Coke"]

{"sheet":"(3an)","index":24,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Create a Dot Plot from the data below"]
[]
[null,null,null,"Count",{"$f":"COUNTIF($A$6:$A$31,E5)","v":11},7,8]
[null,null,null,null,{"$f":"REPT(\"*\",COUNTIF($A$6:$A$31,E5))","v":"***********"},"*******","********"]
["Drinks",null,null,"Drinks","Coke","Pepsi","RC Cola"]
["Coke"]
["Pepsi"]
["RC Cola"]
["Coke"]
["Coke"]
["Pepsi"]
["Pepsi"]
["Coke"]
["Coke"]
["Pepsi"]
["Pepsi"]
["Coke"]
["RC Cola"]
["RC Cola"]
["Coke"]
["RC Cola"]
["Pepsi"]
["Coke"]
["RC Cola"]
["RC Cola"]
["Coke"]
["Pepsi"]
["RC Cola"]
["RC Cola"]
["Coke"]
["Coke"]

{"sheet":"(4)","index":25,"n_rows":189,"n_cols":1,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
["Create a Histogram Chart for the student Score below. For the upper and Lower limits, use 10 as the increment."]
[]
["Student Grades"]
[29.4]
[37.1]
[26]
[15.6]
[40.9]
[43.1]
[1.7]
[16.5]
[43.2]
[37.200000000000003]
[18.600000000000001]
[3.3]
[37.9]
[37.799999999999997]
[20.7]
[31.9]
[21]
[9.8000000000000007]
[25.9]
[28.3]
[40.1]
[25.4]
[23.7]
[18.899999999999999]
[5.2]
[25.7]
[42.9]
[28.4]
[33.799999999999997]
[25.5]
[44]
[42.1]
[18.100000000000001]
[34.200000000000003]
[45.6]
[39.700000000000003]
[30.7]
[16.7]
[33.19]
[42.8]
[49.6]
[26.2]
[46.5]
[27.1]
[10]
[25.3]
[19]
[28.1]
[15.4]
[23.4]
[44.9]
[8.3000000000000007]
[28.8]
[8.5]
[20.3]
[41]
[22.5]
[43.6]
[4.7]
[33.299999999999997]
[46.7]
[12.9]
[16.8]
[3]
[41.6]
[29.4]
[27]
[34.799999999999997]
[34.119999999999997]
[43.1]
[44.3]
[23.7]
[8.4]
[16.7]
[49.3]
[10.3]
[23.7]
[42.5]
[21.6]
[12.3]
[46]
[48.2]
[30.4]
[18.7]
[12]
[40.25]
[38.42]
[45.2]
[47.6]
[10.1]
[22.9]
[14.1]
[40.700000000000003]
[17.600000000000001]
[13.1]
[34.53]
[35.4]
[22]
[47.3]
[7.4]
[37.6]
[41.4]
[31]
[46.8]
[41.7]
[49.9]
[45.6]
[34.299999999999997]
[35.32]
[38.21]
[13.2]
[46.1]
[21.5]
[18.5]
[21.1]
[19.2]
[49.7]
[14.9]
[39]
[11]
[37.299999999999997]
[25]
[18.399999999999999]
[36.299999999999997]
[43.7]
[32.4]
[45.7]
[41.3]
[11.9]
[43.79]
[26]
[42.71]
[4.5999999999999996]
[32]
[14]
[39.5]
[48]
[13.2]
[30.3]
[34.4]
[33.4]
[27.7]
[38.5]
[39.299999999999997]
[40.200000000000003]
[29.3]
[29]
[23.2]
[29.9]
[34]
[49.2]
[23.6]
[40.4]
[13.8]
[33.200000000000003]
[38.200000000000003]
[31.4]
[21.1]
[44.1]
[31.4]
[39.6]
[12.7]
[22.3]
[15.2]
[48.3]
[44.3]
[47.2]
[36.119999999999997]
[35]
[23.7]
[9.8000000000000007]
[2.8]
[18.399999999999999]
[37.700000000000003]
[46.7]
[13.6]
[31.74]
[48.4]
[7.8]
[25.9]
[33.799999999999997]
[42.6]
[25.7]
[20.9]
[25]
[29.8]

{"sheet":"(4an)","index":26,"n_rows":189,"n_cols":7,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
["Create a Histogram Chart for the student Score below. For the upper and Lower limits, use 10 as the increment."]
[]
["Student Grades"]
[29.4,null,"Max",{"$f":"MAX($A$4:$A$189)","v":47.9},null,"Title:","Histogram for Student Grades"]
[37.1,null,"Min",{"$f":"MIN($A$4:$A$189)","v":1.7}]
[26,null,"Start",0]
[15.6,null,"Increment",10]
[40.9]
[38.1,null,"Min","Max","Grade Increment","Frequency/Count"]
[1.7,null,{"$f":"D6","v":0},{"$f":"C10+D$7","v":10},{"$f":"\">=\"&C10&CHAR(10)&\"AND\"&CHAR(10)&\"<\"&D10","v":">=0\nAND\n<10"},{"$f":"COUNTIFS($A$4:$A$189,\">=\"&C10,$A$4:$A$189,\"<\"&D10)","v":14}]
[16.5,null,{"$f":"D10","v":10},{"$f":"C11+D$7","v":20},{"$f":"\">=\"&C11&CHAR(10)&\"AND\"&CHAR(10)&\"<\"&D11","v":">=10\nAND\n<20"},34]
[33.200000000000003,null,{"$f":"D11","v":20},{"$f":"C12+D$7","v":30},">=20\nAND\n<30",55]
[37.200000000000003,null,30,40,">=30\nAND\n<40",70]
[18.600000000000001,null,40,50,">=40\nAND\n<50",13]
[3.3]
[37.9]
[37.799999999999997]
[20.7]
[31.9]
[21]
[9.8000000000000007]
[25.9]
[28.3]
[36.1]
[25.4]
[23.7]
[18.899999999999999]
[5.2]
[25.7]
[39.9]
[28.4]
[33.799999999999997]
[25.5]
[43]
[28.1]
[18.100000000000001]
[34.200000000000003]
[26.6]
[39.700000000000003]
[30.7]
[16.7]
[33.19]
[28.799999999999997]
[31.6]
[26.2]
[39.5]
[27.1]
[10]
[25.3]
[19]
[28.1]
[15.4]
[23.4]
[37.9]
[8.3000000000000007]
[28.8]
[8.5]
[20.3]
[25]
[22.5]
[34.6]
[4.7]
[33.299999999999997]
[39.700000000000003]
[12.9]
[16.8]
[3]
[23.6]
[29.4]
[27]
[34.799999999999997]
[34.119999999999997]
[40.1]
[38.299999999999997]
[23.7]
[8.4]
[16.7]
[37.299999999999997]
[10.3]
[23.7]
[24.5]
[21.6]
[12.3]
[46]
[40.200000000000003]
[30.4]
[18.7]
[12]
[38.25]
[38.42]
[44.2]
[39.6]
[10.1]
[22.9]
[14.1]
[24.700000000000003]
[17.600000000000001]
[13.1]
[34.53]
[35.4]
[22]
[44.3]
[7.4]
[37.6]
[34.4]
[31]
[31.799999999999997]
[25.700000000000003]
[47.9]
[26.6]
[34.299999999999997]
[35.32]
[38.21]
[13.2]
[35.1]
[21.5]
[18.5]
[21.1]
[19.2]
[34.700000000000003]
[14.9]
[39]
[11]
[37.299999999999997]
[25]
[18.399999999999999]
[36.299999999999997]
[24.700000000000003]
[32.4]
[41.7]
[38.299999999999997]
[11.9]
[30.79]
[26]
[37.71]
[4.5999999999999996]
[32]
[14]
[39.5]
[46]
[13.2]
[30.3]
[34.4]
[33.4]
[27.7]
[38.5]
[39.299999999999997]
[34.200000000000003]
[29.3]
[29]
[23.2]
[29.9]
[34]
[42.2]
[23.6]
[35.4]
[13.8]
[33.200000000000003]
[38.200000000000003]
[31.4]
[21.1]
[29.1]
[31.4]
[39.6]
[12.7]
[22.3]
[15.2]
[37.299999999999997]
[37.299999999999997]
[44.2]
[36.119999999999997]
[35]
[23.7]
[9.8000000000000007]
[2.8]
[18.399999999999999]
[37.700000000000003]
[35.700000000000003]
[13.6]
[31.74]
[45.4]
[7.8]
[25.9]
[33.799999999999997]
[39.6]
[25.7]
[20.9]
[25]
[29.8]