{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Gradebook View","Graph of Results","Grade in Progress"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Gradebook View","index":0,"n_rows":77,"n_cols":37,"rows_kept":77,"cut":false,"hidden":false,"merged":[[12,1,12,2],[35,1,35,2],[58,1,58,2],[1,28,1,30],[2,3,2,23],[4,28,4,30],[4,3,4,14],[4,15,4,20],[4,21,4,23]]}
["x",null,null,null,4,8,7,0,6,4,10,null,9,3,5,15,12,20,24,37,28,50,70,880]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Category Weighting"]
[null,null,null,"Typical Gradebook ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.35,{"$f":"1-SUM(AC3:AD3)","v":0.44999999999999996}]
[null,null,1]
[null,null,null,"Homework",null,null,null,null,null,null,null,null,null,null,null,"Quiz",null,null,null,null,null,"Test",null,null,"Total Points",null,null,null,"Category Averages"]
[null,null,"Assignment",10,10,10,10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D6:X6)","v":620},null,"Total Pts Earned",null,"HW","Q","T",null,"HW","Q","T",null,"Weighted Ave"]
[null,null,"Student A",10,10,10,10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D7:X7)","v":620},null,{"$f":"$Y$7/$Y$6","v":1},null,{"$f":"SUM(D7:O7)/SUM($D$6:$O$6)","v":1},{"$f":"SUM(P7:U7)/SUM($P$6:$U$6)","v":1},{"$f":"SUM(V7:X7)/SUM($V$6:$X$6)","v":1},null,{"$f":"$AC$3*AC7","v":0.2},{"$f":"$AD$3*AD7","v":0.35},{"$f":"$AE$3*AE7","v":0.44999999999999996},null,{"$f":"SUM(AG7:AI7)","v":1}]
[null,null,"Late?"]
[]
[null,null,"Student B",10,10,10,10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D10:X10)","v":620},null,{"$f":"$Y$10/$Y$6","v":1},null,{"$f":"SUM(D10:O10)/SUM($D$6:$O$6)","v":1},{"$f":"SUM(P10:U10)/SUM($P$6:$U$6)","v":1},{"$f":"SUM(V10:X10)/SUM($V$6:$X$6)","v":1},null,{"$f":"$AC$3*AC10","v":0.2},{"$f":"$AD$3*AD10","v":0.35},{"$f":"$AE$3*AE10","v":0.44999999999999996},null,{"$f":"SUM(AG10:AI10)","v":1}]
[null,null,"Late?"]
[]
[null,"Points Based"]
[null,null,null,"Late Policy Impact Calculations"]
[]
[null,"Late work","Student A",{"$f":"IF(D8=\"x\",0,D7)","v":10},{"$f":"IF(E8=\"x\",0,E7)","v":10},10,10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D16:X16)","v":620},null,{"$f":"Y16/$Y$6","v":1},null,{"$f":"SUM(D16:O16)/SUM($D$6:$O$6)","v":1},{"$f":"SUM(P16:U16)/SUM($P$6:$U$6)","v":1},{"$f":"SUM(V16:X16)/SUM($V$6:$X$6)","v":1},null,{"$f":"$AC$3*AC16","v":0.2},{"$f":"$AD$3*AD16","v":0.35},{"$f":"$AE$3*AE16","v":0.44999999999999996},null,{"$f":"SUM(AG16:AI16)","v":1}]
[null,"recorded as"]
[null,"a zero (0).","Student B",{"$f":"IF(D11=\"x\",0,D10)","v":10},{"$f":"IF(E11=\"x\",0,E10)","v":10},{"$f":"IF(F11=\"x\",0,F10)","v":10},10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D18:X18)","v":620},null,{"$f":"Y18/$Y$6","v":1},null,{"$f":"SUM(D18:O18)/SUM($D$6:$O$6)","v":1},{"$f":"SUM(P18:U18)/SUM($P$6:$U$6)","v":1},{"$f":"SUM(V18:X18)/SUM($V$6:$X$6)","v":1},null,{"$f":"$AC$3*AC18","v":0.2},{"$f":"$AD$3*AD18","v":0.35},{"$f":"$AE$3*AE18","v":0.44999999999999996},null,{"$f":"SUM(AG18:AI18)","v":1}]
[]
[]
[null,"Late penalty","Student A",{"$f":"IF(D$8=\"x\",(D$7-($B$23*D$6)),D$7)","v":10},{"$f":"IF(E$8=\"x\",(E$7-($B$23*E$6)),E$7)","v":10},10,10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D21:X21)","v":620},null,{"$f":"Y21/Y6","v":1},null,{"$f":"SUM(D21:O21)/SUM($D$6:$O$6)","v":1},{"$f":"SUM(P21:U21)/SUM($P$6:$U$6)","v":1},{"$f":"SUM(V21:X21)/SUM($V$6:$X$6)","v":1},null,{"$f":"$AC$3*AC21","v":0.2},{"$f":"$AD$3*AD21","v":0.35},{"$f":"$AE$3*AE21","v":0.44999999999999996},null,{"$f":"SUM(AG21:AI21)","v":1}]
[null,"deduction"]
[null,0.2,"Student B",{"$f":"IF(D$11=\"x\",(D$10-($B$23*D$6)),D$10)","v":10},{"$f":"IF(E$11=\"x\",(E$10-($B$23*E$6)),E$10)","v":10},10,10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D23:X23)","v":620},null,{"$f":"Y23/Y6","v":1},null,{"$f":"SUM(D23:O23)/SUM($D$6:$O$6)","v":1},{"$f":"SUM(P23:U23)/SUM($P$6:$U$6)","v":1},{"$f":"SUM(V23:X23)/SUM($V$6:$X$6)","v":1},null,{"$f":"$AC$3*AC23","v":0.2},{"$f":"$AD$3*AD23","v":0.35},{"$f":"$AE$3*AE23","v":0.44999999999999996},null,{"$f":"SUM(AG23:AI23)","v":1}]
[]
[]
[null,"Late penalty","Student A",{"$f":"IF(D8=\"x\",IF(D21/D$6<0.5,0.5*D$6,D21),IF(D7/D$6<0.5,0.5*D$6,D7))","v":10},{"$f":"IF(E8=\"x\",IF(E21/E$6<0.5,0.5*E$6,E21),IF(E7/E$6<0.5,0.5*E$6,E7))","v":10},{"$f":"IF(F8=\"x\",IF(F21/F$6<0.5,0.5*F$6,F21),IF(F7/F$6<0.5,0.5*F$6,F7))","v":10},10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D26:X26)","v":620},null,{"$f":"Y26/$Y$6","v":1},null,{"$f":"SUM(D26:O26)/SUM($D$6:$O$6)","v":1},{"$f":"SUM(P26:U26)/SUM($P$6:$U$6)","v":1},{"$f":"SUM(V26:X26)/SUM($V$6:$X$6)","v":1},null,{"$f":"$AC$3*AC26","v":0.2},{"$f":"$AD$3*AD26","v":0.35},{"$f":"$AE$3*AE26","v":0.44999999999999996},null,{"$f":"SUM(AG26:AI26)","v":1}]
[null,"and floor of"]
[null,0.5,"Student B",{"$f":"IF(D11=\"x\",IF(D23/D$6<0.5,0.5*D$6,D23),IF(D10/D$6<0.5,0.5*D$6,D10))","v":10},{"$f":"IF(E11=\"x\",IF(E23/E$6<0.5,0.5*E$6,E23),IF(E10/E$6<0.5,0.5*E$6,E10))","v":10},{"$f":"IF(F11=\"x\",IF(F23/F$6<0.5,0.5*F$6,F23),IF(F10/F$6<0.5,0.5*F$6,F10))","v":10},10,10,10,10,10,10,10,10,10,20,25,30,35,40,45,80,100,125,{"$f":"SUM(D28:X28)","v":620},null,{"$f":"Y28/$Y$6","v":1},null,{"$f":"SUM(D28:O28)/SUM($D$6:$O$6)","v":1},{"$f":"SUM(P28:U28)/SUM($P$6:$U$6)","v":1},{"$f":"SUM(V28:X28)/SUM($V$6:$X$6)","v":1},null,{"$f":"$AC$3*AC28","v":0.2},{"$f":"$AD$3*AD28","v":0.35},{"$f":"$AE$3*AE28","v":0.44999999999999996},null,{"$f":"SUM(AG28:AI28)","v":1}]
[]
[]
[]
[null,null,"Student A",{"$f":"D7/D$6","v":1},{"$f":"E7/E$6","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,{"$f":"AVERAGE(D32:O32)","v":1},{"$f":"AVERAGE(P32:U32)","v":1},{"$f":"AVERAGE(V32:X32)","v":1},null,{"$f":"$AC$3*AC32","v":0.2},{"$f":"$AD$3*AD32","v":0.35},{"$f":"$AE$3*AE32","v":0.44999999999999996},null,{"$f":"SUM(AG32:AI32)","v":1}]
[]
[null,null,"Student B",{"$f":"D10/D$6","v":1},{"$f":"E10/E$6","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,{"$f":"AVERAGE(D34:O34)","v":1},{"$f":"AVERAGE(P34:U34)","v":1},{"$f":"AVERAGE(V34:X34)","v":1},null,{"$f":"$AC$3*AC34","v":0.2},{"$f":"$AD$3*AD34","v":0.35},{"$f":"$AE$3*AE34","v":0.44999999999999996},null,{"$f":"SUM(AG34:AI34)","v":1}]
[]
[null,"Percent Based"]
[null,null,null,"Late Policy Impact Calculations"]
[]
[null,"Late work","Student A",{"$f":"IF(D$8=\"x\",0,D32)","v":1},{"$f":"IF(E$8=\"x\",0,E32)","v":1},{"$f":"IF(F$8=\"x\",0,F32)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,{"$f":"AVERAGE(D39:O39)","v":1},{"$f":"AVERAGE(P39:U39)","v":1},{"$f":"AVERAGE(V39:X39)","v":1},null,{"$f":"$AC$3*AC39","v":0.2},{"$f":"$AD$3*AD39","v":0.35},{"$f":"$AE$3*AE39","v":0.44999999999999996},null,{"$f":"SUM(AG39:AI39)","v":1}]
[null,"recorded as"]
[null,"a zero (0).","Student B",{"$f":"IF(D$11=\"x\",0,D34)","v":1},{"$f":"IF(E$11=\"x\",0,E34)","v":1},{"$f":"IF(F$11=\"x\",0,F34)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,{"$f":"AVERAGE(D41:O41)","v":1},{"$f":"AVERAGE(P41:U41)","v":1},{"$f":"AVERAGE(V41:X41)","v":1},null,{"$f":"$AC$3*AC41","v":0.2},{"$f":"$AD$3*AD41","v":0.35},{"$f":"$AE$3*AE41","v":0.44999999999999996},null,{"$f":"SUM(AG41:AI41)","v":1}]
[]
[]
[null,"Late penalty","Student A",{"$f":"IF(D$8=\"x\",D32-$B$46,D32)","v":1},{"$f":"IF(E$8=\"x\",E32-$B$46,E32)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,{"$f":"AVERAGE(D44:O44)","v":1},{"$f":"AVERAGE(P44:U44)","v":1},{"$f":"AVERAGE(V44:X44)","v":1},null,{"$f":"$AC$3*AC44","v":0.2},{"$f":"$AD$3*AD44","v":0.35},{"$f":"$AE$3*AE44","v":0.44999999999999996},null,{"$f":"SUM(AG44:AI44)","v":1}]
[null,"deduction"]
[null,{"$f":"B23","v":0.2},"Student B",{"$f":"IF(D$11=\"x\",D34-$B$46,D34)","v":1},{"$f":"IF(E$11=\"x\",E34-$B$46,E34)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,{"$f":"AVERAGE(D46:O46)","v":1},{"$f":"AVERAGE(P46:U46)","v":1},{"$f":"AVERAGE(V46:X46)","v":1},null,{"$f":"$AC$3*AC46","v":0.2},{"$f":"$AD$3*AD46","v":0.35},{"$f":"$AE$3*AE46","v":0.44999999999999996},null,{"$f":"SUM(AG46:AI46)","v":1}]
[]
[]
[null,"Late penalty","Student A",{"$f":"IF(D8=\"x\",IF(D44<0.5,0.5,D44),IF(D7/D$6<0.5,0.5,D7/D6))","v":1},{"$f":"IF(E8=\"x\",IF(E44<0.5,0.5,E44),IF(E7/E$6<0.5,0.5,E7/E6))","v":1},{"$f":"IF(F8=\"x\",IF(F44<0.5,0.5,F44),IF(F7/F$6<0.5,0.5,F7/F6))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,{"$f":"AVERAGE(D49:O49)","v":1},{"$f":"AVERAGE(P49:U49)","v":1},{"$f":"AVERAGE(V49:X49)","v":1},null,{"$f":"$AC$3*AC49","v":0.2},{"$f":"$AD$3*AD49","v":0.35},{"$f":"$AE$3*AE49","v":0.44999999999999996},null,{"$f":"SUM(AG49:AI49)","v":1}]
[null,"and floor of"]
[null,0.5,"Student B",{"$f":"IF(D11=\"x\",IF(D46<0.5,0.5,D46),IF(D10/D$6<0.5,0.5,D10/D6))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,{"$f":"AVERAGE(D51:O51)","v":1},{"$f":"AVERAGE(P51:U51)","v":1},{"$f":"AVERAGE(V51:X51)","v":1},null,{"$f":"$AC$3*AC51","v":0.2},{"$f":"$AD$3*AD51","v":0.35},{"$f":"$AE$3*AE51","v":0.44999999999999996},null,{"$f":"SUM(AG51:AI51)","v":1}]
[]
[]
[]
[null,null,"Student A",{"$f":"IF(D32=$D$76,$D$77,IF(D32>=$E$76,$E$77,IF(D32>=$F$76,$F$77,IF(D32>=$G$76,$G$77,IF(D32>=$H$76,$H$77,$I$77)))))","v":5},{"$f":"IF(E32=$D$76,$D$77,IF(E32>=$E$76,$E$77,IF(E32>=$F$76,$F$77,IF(E32>=$G$76,$G$77,IF(E32>=$H$76,$H$77,$I$77)))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,null,null,null,{"$f":"AVERAGE(D55:O55)","v":5},{"$f":"AVERAGE(P55:U55)","v":5},{"$f":"AVERAGE(V55:X55)","v":5},null,{"$f":"$AC$3*AC55","v":1},{"$f":"$AD$3*AD55","v":1.75},{"$f":"$AE$3*AE55","v":2.25},null,{"$f":"SUM(AG55:AI55)","v":5}]
[]
[null,null,"Student B",{"$f":"IF(D34=$D$76,$D$77,IF(D34>=$E$76,$E$77,IF(D34>=$F$76,$F$77,IF(D34>=$G$76,$G$77,IF(D34>=$H$76,$H$77,$I$77)))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,null,null,null,{"$f":"AVERAGE(D57:O57)","v":5},{"$f":"AVERAGE(P57:U57)","v":5},{"$f":"AVERAGE(V57:X57)","v":5},null,{"$f":"$AC$3*AC57","v":1},{"$f":"$AD$3*AD57","v":1.75},{"$f":"$AE$3*AE57","v":2.25},null,{"$f":"SUM(AG57:AI57)","v":5}]
[]
[null,"Scale Score"]
[null,null,null,"Late Policy Impact Calculations"]
[]
[null,"Late work","Student A",{"$f":"IF(D39=$D$76,$D$77,IF(D39>=$E$76,$E$77,IF(D39>=$F$76,$F$77,IF(D39>=$G$76,$G$77,IF(D39>=$H$76,$H$77,$I$77)))))","v":5},{"$f":"IF(E39=$D$76,$D$77,IF(E39>=$E$76,$E$77,IF(E39>=$F$76,$F$77,IF(E39>=$G$76,$G$77,IF(E39>=$H$76,$H$77,$I$77)))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,null,null,null,{"$f":"AVERAGE(D62:O62)","v":5},{"$f":"AVERAGE(P62:U62)","v":5},{"$f":"AVERAGE(V62:X62)","v":5},null,{"$f":"$AC$3*AC62","v":1},{"$f":"$AD$3*AD62","v":1.75},{"$f":"$AE$3*AE62","v":2.25},null,{"$f":"SUM(AG62:AI62)","v":5}]
[null,"recorded as"]
[null,"a zero (0).","Student B",{"$f":"IF(D41=$D$76,$D$77,IF(D41>=$E$76,$E$77,IF(D41>=$F$76,$F$77,IF(D41>=$G$76,$G$77,IF(D41>=$H$76,$H$77,$I$77)))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,null,null,null,{"$f":"AVERAGE(D64:O64)","v":5},{"$f":"AVERAGE(P64:U64)","v":5},{"$f":"AVERAGE(V64:X64)","v":5},null,{"$f":"$AC$3*AC64","v":1},{"$f":"$AD$3*AD64","v":1.75},{"$f":"$AE$3*AE64","v":2.25},null,{"$f":"SUM(AG64:AI64)","v":5}]
[]
[]
[null,"Late penalty","Student A",{"$f":"IF(D44=$D$76,$D$77,IF(D44>=$E$76,$E$77,IF(D44>=$F$76,$F$77,IF(D44>=$G$76,$G$77,IF(D44>=$H$76,$H$77,$I$77)))))","v":5},{"$f":"IF(E44=$D$76,$D$77,IF(E44>=$E$76,$E$77,IF(E44>=$F$76,$F$77,IF(E44>=$G$76,$G$77,IF(E44>=$H$76,$H$77,$I$77)))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,null,null,null,{"$f":"AVERAGE(D67:O67)","v":5},{"$f":"AVERAGE(P67:U67)","v":5},{"$f":"AVERAGE(V67:X67)","v":5},null,{"$f":"$AC$3*AC67","v":1},{"$f":"$AD$3*AD67","v":1.75},{"$f":"$AE$3*AE67","v":2.25},null,{"$f":"SUM(AG67:AI67)","v":5}]
[null,"of"]
[null,{"$f":"B46","v":0.2},"Student B",{"$f":"IF(D46=$D$76,$D$77,IF(D46>=$E$76,$E$77,IF(D46>=$F$76,$F$77,IF(D46>=$G$76,$G$77,IF(D46>=$H$76,$H$77,$I$77)))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,null,null,null,{"$f":"AVERAGE(D69:O69)","v":5},{"$f":"AVERAGE(P69:U69)","v":5},{"$f":"AVERAGE(V69:X69)","v":5},null,{"$f":"$AC$3*AC69","v":1},{"$f":"$AD$3*AD69","v":1.75},{"$f":"$AE$3*AE69","v":2.25},null,{"$f":"SUM(AG69:AI69)","v":5}]
[]
[]
[null,"Late penalty","Student A",{"$f":"IF(D49=$D$76,$D$77,IF(D49>=$E$76,$E$77,IF(D49>=$F$76,$F$77,IF(D49>=$G$76,$G$77,IF(D49>=$H$76,$H$77,$I$77)))))","v":5},{"$f":"IF(E49=$D$76,$D$77,IF(E49>=$E$76,$E$77,IF(E49>=$F$76,$F$77,IF(E49>=$G$76,$G$77,IF(E49>=$H$76,$H$77,$I$77)))))","v":5},{"$f":"IF(F49=$D$76,$D$77,IF(F49>=$E$76,$E$77,IF(F49>=$F$76,$F$77,IF(F49>=$G$76,$G$77,IF(F49>=$H$76,$H$77,$I$77)))))","v":5},{"$f":"IF(G49=$D$76,$D$77,IF(G49>=$E$76,$E$77,IF(G49>=$F$76,$F$77,IF(G49>=$G$76,$G$77,IF(G49>=$H$76,$H$77,$I$77)))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,null,null,null,{"$f":"AVERAGE(D72:O72)","v":5},{"$f":"AVERAGE(P72:U72)","v":5},{"$f":"AVERAGE(V72:X72)","v":5},null,{"$f":"$AC$3*AC72","v":1},{"$f":"$AD$3*AD72","v":1.75},{"$f":"$AE$3*AE72","v":2.25},null,{"$f":"SUM(AG72:AI72)","v":5}]
[null,"and floor of"]
[null,0.5,"Student B",{"$f":"IF(D51=$D$76,$D$77,IF(D51>=$E$76,$E$77,IF(D51>=$F$76,$F$77,IF(D51>=$G$76,$G$77,IF(D51>=$H$76,$H$77,$I$77)))))","v":5},{"$f":"IF(E51=$D$76,$D$77,IF(E51>=$E$76,$E$77,IF(E51>=$F$76,$F$77,IF(E51>=$G$76,$G$77,IF(E51>=$H$76,$H$77,$I$77)))))","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,null,null,null,null,{"$f":"AVERAGE(D74:O74)","v":5},{"$f":"AVERAGE(P74:U74)","v":5},{"$f":"AVERAGE(V74:X74)","v":5},null,{"$f":"$AC$3*AC74","v":1},{"$f":"$AD$3*AD74","v":1.75},{"$f":"$AE$3*AE74","v":2.25},null,{"$f":"SUM(AG74:AI74)","v":5}]
[]
[null,null,null,1,0.9,0.8,0.7,0.6,0.5]
[null,null,null,5,4,3,2,1,0]

{"sheet":"Graph of Results","index":1,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,0,5,0],[11,0,13,0],[7,0,9,0]]}
[]
[null,null,"Student A","Student A","Student B","Student B"]
[null,"Straight Points",{"$f":"'Gradebook View'!AK7","v":1},{"$f":"IF(C3>=$N$3,$O$3,IF(C3>=$N$4,$O$4,IF(C3>=$N$5,$O$5,IF(C3>=$N$6,$O$6,$O$7))))","v":"A"},{"$f":"'Gradebook View'!AK10","v":1},{"$f":"IF(E3>=$N$3,$O$3,IF(E3>=$N$4,$O$4,IF(E3>=$N$5,$O$5,IF(E3>=$N$6,$O$6,$O$7))))","v":"A"},null,null,null,null,null,null,null,0.9,"A"]
["Straight Points","Pts: Late = 0",{"$f":"'Gradebook View'!AK16","v":1},"A",{"$f":"'Gradebook View'!AK18","v":1},"A",null,null,null,null,null,null,null,0.8,"B"]
[null,"Pts: Late = % penalty",{"$f":"'Gradebook View'!AK21","v":1},"A",{"$f":"'Gradebook View'!AK23","v":1},"A",null,null,null,null,null,null,null,0.7,"C"]
[null,"Pts: Late = % penalty w/ floor",{"$f":"'Gradebook View'!AK26","v":1},"A",{"$f":"'Gradebook View'!AK28","v":1},"A",null,null,null,null,null,null,null,0.6,"D"]
[null,"Percent Based",{"$f":"'Gradebook View'!AK32","v":1},"A",{"$f":"'Gradebook View'!AK34","v":1},"A",null,null,null,null,null,null,null,0.5,"E"]
["Straight Percentage","%: Late = 0",{"$f":"'Gradebook View'!AK39","v":1},"A",{"$f":"'Gradebook View'!AK41","v":1},"A"]
[null,"%: Late = % penalty",{"$f":"'Gradebook View'!AK44","v":1},"A",{"$f":"'Gradebook View'!AK46","v":1},"A"]
[null,"%: Late = % penalty w/ floor",{"$f":"'Gradebook View'!AK49","v":1},"A",{"$f":"'Gradebook View'!AK51","v":1},"A"]
[null,"Scale Score",{"$f":"'Gradebook View'!AK55","v":5},null,{"$f":"'Gradebook View'!AK57","v":5}]
["Scale Score","Scale: Late = 0",{"$f":"'Gradebook View'!AK62","v":5},null,{"$f":"'Gradebook View'!AK64","v":5}]
[null,"Scale: Late = % penalty",{"$f":"'Gradebook View'!AK67","v":5},null,{"$f":"'Gradebook View'!AK69","v":5}]
[null,"Scale: Late = % penalty w/ floor",{"$f":"'Gradebook View'!AK72","v":5},null,{"$f":"'Gradebook View'!AK74","v":5}]

{"sheet":"Grade in Progress","index":2,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,13,5,15],[5,9,5,10],[3,1,3,6],[3,9,3,15]]}
["Homework","Yes"]
["Quiz","No"]
["Test",null,"X"]
[null,"Enter your own information in this region.",null,null,null,null,null,null,null,"Grades are calculated in this region and graphed to the right."]
[]
[null,null,null,null,null,null,null,null,null,"Grading Rule",null,null,null,"Grade In-Progress"]
[null,"Include In Grade","Assignment Number","Assignment","Points Available","Student Earned","Late?",null,null,"If Late, then Zero","50% Floor",null,"Total Points Available","Earned","Late = 0","50% Floor"]
[null,"Yes",1,"Homework",10,8,null,null,null,{"$f":"IF(B8=\"yes\",IF(G8=\"X\",0,F8),\"\")","v":8},{"$f":"IF(B8=\"Yes\",IF(F8/E8<0.5,0.5*E8,F8),\"\")","v":8},null,{"$f":"SUM($E$8:E8)","v":10},{"$f":"SUM($F$8:F8)/$M8","v":0.8},{"$f":"SUM($J$8:J8)/$M8","v":0.8},{"$f":"SUM($K$8:K8)/$M8","v":0.8}]
[null,"Yes",2,"Homework",15,12,"x",null,null,{"$f":"IF(B9=\"yes\",IF(G9=\"X\",0,F9),\"\")","v":0},{"$f":"IF(B9=\"Yes\",IF(F9/E9<0.5,0.5*E9,F9),\"\")","v":12},null,{"$f":"SUM($E$8:E9)","v":25},{"$f":"SUM($F$8:F9)/$M9","v":0.8},{"$f":"SUM($J$8:J9)/$M9","v":0.32},{"$f":"SUM($K$8:K9)/$M9","v":0.8}]
[null,"Yes",3,"Homework",8,6,"x",null,null,0,6,null,{"$f":"SUM($E$8:E10)","v":33},{"$f":"SUM($F$8:F10)/$M10","v":0.78787878787878785},{"$f":"SUM($J$8:J10)/$M10","v":0.24242424242424243},{"$f":"SUM($K$8:K10)/$M10","v":0.78787878787878785}]
[null,"Yes",4,"Quiz",35,28,null,null,null,28,28,null,{"$f":"SUM($E$8:E11)","v":68},{"$f":"SUM($F$8:F11)/$M11","v":0.79411764705882348},{"$f":"SUM($J$8:J11)/$M11","v":0.52941176470588236},{"$f":"SUM($K$8:K11)/$M11","v":0.79411764705882348}]
[null,"Yes",5,"Homework",12,4,null,null,null,4,6,null,{"$f":"SUM($E$8:E12)","v":80},{"$f":"SUM($F$8:F12)/$M12","v":0.72499999999999998},{"$f":"SUM($J$8:J12)/$M12","v":0.5},{"$f":"SUM($K$8:K12)/$M12","v":0.75}]
[null,"Yes",6,"Homework",12,4,null,null,null,4,6,null,{"$f":"SUM($E$8:E13)","v":92},{"$f":"SUM($F$8:F13)/$M13","v":0.67391304347826086},{"$f":"SUM($J$8:J13)/$M13","v":0.47826086956521741},{"$f":"SUM($K$8:K13)/$M13","v":0.71739130434782605}]
[null,"Yes",7,"Homework",12,8,null,null,null,8,8,null,{"$f":"SUM($E$8:E14)","v":104},{"$f":"SUM($F$8:F14)/$M14","v":0.67307692307692313},{"$f":"SUM($J$8:J14)/$M14","v":0.5},{"$f":"SUM($K$8:K14)/$M14","v":0.71153846153846156}]
[null,"Yes",8,"Test",50,47,null,null,null,47,47,null,{"$f":"SUM($E$8:E15)","v":154},{"$f":"SUM($F$8:F15)/$M15","v":0.75974025974025972},{"$f":"SUM($J$8:J15)/$M15","v":0.6428571428571429},{"$f":"SUM($K$8:K15)/$M15","v":0.7857142857142857}]
[null,"Yes",9,"Homework",10,5,null,null,null,5,5,null,{"$f":"SUM($E$8:E16)","v":164},{"$f":"SUM($F$8:F16)/$M16","v":0.74390243902439024},{"$f":"SUM($J$8:J16)/$M16","v":0.63414634146341464},{"$f":"SUM($K$8:K16)/$M16","v":0.76829268292682928}]
[null,"Yes",10,"Homework",12,10,null,null,null,10,10,null,{"$f":"SUM($E$8:E17)","v":176},{"$f":"SUM($F$8:F17)/$M17","v":0.75},{"$f":"SUM($J$8:J17)/$M17","v":0.64772727272727271},{"$f":"SUM($K$8:K17)/$M17","v":0.77272727272727271}]
[null,"Yes",11,"Quiz",25,23,null,null,null,23,23,null,{"$f":"SUM($E$8:E18)","v":201},{"$f":"SUM($F$8:F18)/$M18","v":0.77114427860696522},{"$f":"SUM($J$8:J18)/$M18","v":0.68159203980099503},{"$f":"SUM($K$8:K18)/$M18","v":0.79104477611940294}]
[null,"Yes",12,"Homework",10,8,null,null,null,8,8,null,{"$f":"SUM($E$8:E19)","v":211},{"$f":"SUM($F$8:F19)/$M19","v":0.77251184834123221},{"$f":"SUM($J$8:J19)/$M19","v":0.6872037914691943},{"$f":"SUM($K$8:K19)/$M19","v":0.79146919431279616}]
[]
[null,null,null,"Total Points",{"$f":"SUM(E8:E19)","v":211},{"$f":"SUM(F8:F19)","v":163},null,null,null,{"$f":"SUM(J8:J19)","v":145},{"$f":"SUM(K8:K19)","v":167}]
[null,null,null,null,null,{"$f":"F21/$E$21","v":0.77251184834123221},null,null,null,{"$f":"J21/$E$21","v":0.6872037914691943},{"$f":"K21/$E$21","v":0.79146919431279616}]