{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Attendance Sheet","Attendance","Lab 332A","Tests 332A","Assessment","Overall Grade","Homework 332A","Lesson Quizzes","Distributions","A-database","A-Map","EET-1 Details","EET-2 Details","EET-3 Details","EET-4 Details","EET-5 Details","EET-9 Details","Summary","ICE Part II","ICE Part III"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Attendance Sheet","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"ET 332A",null,null,null,"  "]
[null,"Electromagnetic Principles and Devices","ET 332A"]
[null,{"$f":"'Overall Grade'!A30","v":"Fall 2015"},"Electromagnetic Principles and Devices",null,null,"   "]
[null,null,"Fall Attendance"]
[]
[null,null,null,"Date  _______ / _______ / __________"]
[]
[null,"Last Name",null,"Signature"]
[1,{"$f":"IF(ISBLANK('Overall Grade'!A5),+$F$1,'Overall Grade'!A5)","v":"Test student"}]
[2,{"$f":"IF(ISBLANK('Overall Grade'!A6),+$F$1,'Overall Grade'!A6)","v":"  "}]
[3,{"$f":"IF(ISBLANK('Overall Grade'!A7),+$F$1,'Overall Grade'!A7)","v":"  "}]
[4,{"$f":"IF(ISBLANK('Overall Grade'!A8),+$F$1,'Overall Grade'!A8)","v":"  "}]
[5,{"$f":"IF(ISBLANK('Overall Grade'!A9),+$F$1,'Overall Grade'!A9)","v":"  "}]
[6,{"$f":"IF(ISBLANK('Overall Grade'!A10),+$F$1,'Overall Grade'!A10)","v":"  "}]
[7,{"$f":"IF(ISBLANK('Overall Grade'!A11),+$F$1,'Overall Grade'!A11)","v":"  "}]
[8,{"$f":"IF(ISBLANK('Overall Grade'!A12),+$F$1,'Overall Grade'!A12)","v":"  "}]
[9,{"$f":"IF(ISBLANK('Overall Grade'!A13),+$F$1,'Overall Grade'!A13)","v":"  "}]
[10,{"$f":"IF(ISBLANK('Overall Grade'!A14),+$F$1,'Overall Grade'!A14)","v":"  "}]
[11,{"$f":"IF(ISBLANK('Overall Grade'!A15),+$F$1,'Overall Grade'!A15)","v":"  "}]
[12,{"$f":"IF(ISBLANK('Overall Grade'!A16),+$F$1,'Overall Grade'!A16)","v":"  "}]
[13,{"$f":"IF(ISBLANK('Overall Grade'!A17),+$F$1,'Overall Grade'!A17)","v":"  "}]
[14,{"$f":"IF(ISBLANK('Overall Grade'!A18),+$F$1,'Overall Grade'!A18)","v":"  "}]
[15,{"$f":"IF(ISBLANK('Overall Grade'!A19),+$F$1,'Overall Grade'!A19)","v":"  "}]
[16,{"$f":"IF(ISBLANK('Overall Grade'!A20),+$F$1,'Overall Grade'!A20)","v":"  "}]
[17,{"$f":"IF(ISBLANK('Overall Grade'!A21),+$F$1,'Overall Grade'!A21)","v":"  "}]
[18,{"$f":"IF(ISBLANK('Overall Grade'!A22),+$F$1,'Overall Grade'!A22)","v":"  "}]
[19,{"$f":"IF(ISBLANK('Overall Grade'!A23),+$F$1,'Overall Grade'!A23)","v":"  "}]
[20,{"$f":"IF(ISBLANK('Overall Grade'!A24),+$F$1,'Overall Grade'!A24)","v":"  "}]
[21,{"$f":"IF(ISBLANK('Overall Grade'!A25),+$F$1,'Overall Grade'!A25)","v":"  "}]

{"sheet":"Attendance","index":1,"n_rows":109,"n_cols":15,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["     ",{"$f":"'Overall Grade'!B31","v":"2015-08-24"},{"$f":"B1+2","v":"2015-08-26"},"2014-08-22","2014-08-25",{"$f":"E1+2","v":"2014-08-27"},{"$f":"F1+2","v":"2014-08-29"},"2014-09-01",{"$f":"H1+2","v":"2014-09-03"},{"$f":"I1+2","v":"2014-09-05"},"2014-09-08",{"$f":"K1+2","v":"2014-09-10"},{"$f":"L1+2","v":"2014-09-12"},"2014-09-15",{"$f":"N1+2","v":"2014-09-17"}]
["Name","M","W","F","M","W","F","M","W","F","M","W","F","M","W"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A5),+$A$1,+'Overall Grade'!A5)","v":"Test student"}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A6),+$A$1,+'Overall Grade'!A6)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A7),+$A$1,+'Overall Grade'!A7)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A8),+$A$1,+'Overall Grade'!A8)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A9),+$A$1,+'Overall Grade'!A9)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A10),+$A$1,+'Overall Grade'!A10)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A11),+$A$1,+'Overall Grade'!A11)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A12),+$A$1,+'Overall Grade'!A12)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A13),+$A$1,+'Overall Grade'!A13)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A14),+$A$1,+'Overall Grade'!A14)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A15),+$A$1,+'Overall Grade'!A15)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A16),+$A$1,+'Overall Grade'!A16)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A17),+$A$1,+'Overall Grade'!A17)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A18),+$A$1,+'Overall Grade'!A18)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A19),+$A$1,+'Overall Grade'!A19)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A20),+$A$1,+'Overall Grade'!A20)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A21),+$A$1,+'Overall Grade'!A21)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A22),+$A$1,+'Overall Grade'!A22)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A23),+$A$1,+'Overall Grade'!A23)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A24),+$A$1,+'Overall Grade'!A24)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A25),+$A$1,+'Overall Grade'!A25)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A26),+$A$1,+'Overall Grade'!A26)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A27),+$A$1,+'Overall Grade'!A27)","v":"     "}]
[]
[]
[]
[null,{"$f":"O1+2","v":"2014-09-19"},{"$f":"B29+3","v":"2014-09-22"},{"$f":"C29+2","v":"2014-09-24"},{"$f":"D29+2","v":"2014-09-26"},{"$f":"E29+3","v":"2014-09-29"},{"$f":"F29+2","v":"2014-10-01"},{"$f":"G29+2","v":"2014-10-03"},{"$f":"H29+3","v":"2014-10-06"},{"$f":"I29+2","v":"2014-10-08"},{"$f":"J29+2","v":"2014-10-10"},{"$f":"K29+3","v":"2014-10-13"},{"$f":"L29+2","v":"2014-10-15"},{"$f":"M29+2","v":"2014-10-17"},{"$f":"N29+3","v":"2014-10-20"}]
["Name","F","M","W","F","M","W","F","M","W","F","M","W","F","M"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A5),+$A$1,+'Overall Grade'!A5)","v":"Test student"}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A6),+$A$1,+'Overall Grade'!A6)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A7),+$A$1,+'Overall Grade'!A7)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A8),+$A$1,+'Overall Grade'!A8)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A9),+$A$1,+'Overall Grade'!A9)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A10),+$A$1,+'Overall Grade'!A10)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A11),+$A$1,+'Overall Grade'!A11)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A12),+$A$1,+'Overall Grade'!A12)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A13),+$A$1,+'Overall Grade'!A13)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A14),+$A$1,+'Overall Grade'!A14)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A15),+$A$1,+'Overall Grade'!A15)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A16),+$A$1,+'Overall Grade'!A16)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A17),+$A$1,+'Overall Grade'!A17)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A18),+$A$1,+'Overall Grade'!A18)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A19),+$A$1,+'Overall Grade'!A19)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A20),+$A$1,+'Overall Grade'!A20)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A21),+$A$1,+'Overall Grade'!A21)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A22),+$A$1,+'Overall Grade'!A22)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A23),+$A$1,+'Overall Grade'!A23)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A24),+$A$1,+'Overall Grade'!A24)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A25),+$A$1,+'Overall Grade'!A25)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A26),+$A$1,+'Overall Grade'!A26)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A27),+$A$1,+'Overall Grade'!A27)","v":"     "}]
[]
[]
[]
[null,{"$f":"O29+2","v":"2014-10-22"},{"$f":"B57+2","v":"2014-10-24"},{"$f":"C57+3","v":"2014-10-27"},{"$f":"D57+2","v":"2014-10-29"},{"$f":"E57+2","v":"2014-10-31"},{"$f":"F57+3","v":"2014-11-03"},{"$f":"G57+2","v":"2014-11-05"},{"$f":"H57+2","v":"2014-11-07"},{"$f":"I57+3","v":"2014-11-10"},{"$f":"J57+2","v":"2014-11-12"},{"$f":"K57+2","v":"2014-11-14"},{"$f":"L57+3","v":"2014-11-17"},{"$f":"M57+2","v":"2014-11-19"},{"$f":"N57+2","v":"2014-11-21"}]
["Name","W","F","M","W","F","M","W","F","M","W","F","M","W","F"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A5),+$A$1,+'Overall Grade'!A5)","v":"Test student"}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A6),+$A$1,+'Overall Grade'!A6)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A7),+$A$1,+'Overall Grade'!A7)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A8),+$A$1,+'Overall Grade'!A8)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A9),+$A$1,+'Overall Grade'!A9)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A10),+$A$1,+'Overall Grade'!A10)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A11),+$A$1,+'Overall Grade'!A11)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A12),+$A$1,+'Overall Grade'!A12)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A13),+$A$1,+'Overall Grade'!A13)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A14),+$A$1,+'Overall Grade'!A14)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A15),+$A$1,+'Overall Grade'!A15)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A16),+$A$1,+'Overall Grade'!A16)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A17),+$A$1,+'Overall Grade'!A17)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A18),+$A$1,+'Overall Grade'!A18)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A19),+$A$1,+'Overall Grade'!A19)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A20),+$A$1,+'Overall Grade'!A20)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A21),+$A$1,+'Overall Grade'!A21)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A22),+$A$1,+'Overall Grade'!A22)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A23),+$A$1,+'Overall Grade'!A23)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A24),+$A$1,+'Overall Grade'!A24)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A25),+$A$1,+'Overall Grade'!A25)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A26),+$A$1,+'Overall Grade'!A26)","v":"     "}]
[]
[]
[]
[]
[]
[null,{"$f":"O57+3","v":"2014-11-24"},{"$f":"B86+2","v":"2014-11-26"},{"$f":"C86+2","v":"2014-11-28"}]
["Name","M","W","F","Absences","Attendance average"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A5),+$A$1,+'Overall Grade'!A5)","v":"Test student"},null,null,null,null,{"$f":"(45-SUM(B3:O3,B31:O31,B59:O59,B88:D88))/45","v":1}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A6),+$A$1,+'Overall Grade'!A6)","v":"     "},null,null,null,null,{"$f":"(45-SUM(B4:O4,B32:O32,B60:O60,B89:D89))/45","v":1}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A7),+$A$1,+'Overall Grade'!A7)","v":"     "},null,null,null,null,1]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A8),+$A$1,+'Overall Grade'!A8)","v":"     "},null,null,null,null,1]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A9),+$A$1,+'Overall Grade'!A9)","v":"     "},null,null,null,null,1]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A10),+$A$1,+'Overall Grade'!A10)","v":"     "},null,null,null,null,1]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A11),+$A$1,+'Overall Grade'!A11)","v":"     "},null,null,null,null,1,null,"class Average"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A12),+$A$1,+'Overall Grade'!A12)","v":"     "},null,null,null,null,1,null,{"$f":"SUM(F88:F111)/COUNT(F88:F111)","v":1}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A13),+$A$1,+'Overall Grade'!A13)","v":"     "},null,null,null,null,1]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A14),+$A$1,+'Overall Grade'!A14)","v":"     "},null,null,null,null,1]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A15),+$A$1,+'Overall Grade'!A15)","v":"     "},null,null,null,null,1]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A16),+$A$1,+'Overall Grade'!A16)","v":"     "},null,null,null,null,1]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A17),+$A$1,+'Overall Grade'!A17)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A18),+$A$1,+'Overall Grade'!A18)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A19),+$A$1,+'Overall Grade'!A19)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A20),+$A$1,+'Overall Grade'!A20)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A21),+$A$1,+'Overall Grade'!A21)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A22),+$A$1,+'Overall Grade'!A22)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A23),+$A$1,+'Overall Grade'!A23)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A24),+$A$1,+'Overall Grade'!A24)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A25),+$A$1,+'Overall Grade'!A25)","v":"     "}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A26),+$A$1,+'Overall Grade'!A26)","v":"     "}]

{"sheet":"Lab 332A","index":2,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["       "]
["Name","ID","Lab 1","Lab 2","Lab 3","Lab 4","Lab 5","Lab 6"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A5),+$A$1,+'Overall Grade'!A5)","v":"Test student"},{"$f":"RIGHT('Overall Grade'!B5,5)","v":"54505"}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A6),+$A$1,+'Overall Grade'!A6)","v":"       "},{"$f":"RIGHT('Overall Grade'!B6,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A7),+$A$1,+'Overall Grade'!A7)","v":"       "},{"$f":"RIGHT('Overall Grade'!B7,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A8),+$A$1,+'Overall Grade'!A8)","v":"       "},{"$f":"RIGHT('Overall Grade'!B8,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A9),+$A$1,+'Overall Grade'!A9)","v":"       "},{"$f":"RIGHT('Overall Grade'!B9,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A10),+$A$1,+'Overall Grade'!A10)","v":"       "},{"$f":"RIGHT('Overall Grade'!B10,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A11),+$A$1,+'Overall Grade'!A11)","v":"       "},{"$f":"RIGHT('Overall Grade'!B11,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A12),+$A$1,+'Overall Grade'!A12)","v":"       "},{"$f":"RIGHT('Overall Grade'!B12,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A13),+$A$1,+'Overall Grade'!A13)","v":"       "},{"$f":"RIGHT('Overall Grade'!B13,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A14),+$A$1,+'Overall Grade'!A14)","v":"       "},{"$f":"RIGHT('Overall Grade'!B14,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A15),+$A$1,+'Overall Grade'!A15)","v":"       "},{"$f":"RIGHT('Overall Grade'!B15,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A16),+$A$1,+'Overall Grade'!A16)","v":"       "},{"$f":"RIGHT('Overall Grade'!B16,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A17),+$A$1,+'Overall Grade'!A17)","v":"       "},{"$f":"RIGHT('Overall Grade'!B17,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A18),+$A$1,+'Overall Grade'!A18)","v":"       "},{"$f":"RIGHT('Overall Grade'!B18,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A19),+$A$1,+'Overall Grade'!A19)","v":"       "},{"$f":"RIGHT('Overall Grade'!B19,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A20),+$A$1,+'Overall Grade'!A20)","v":"       "},{"$f":"RIGHT('Overall Grade'!B20,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A21),+$A$1,+'Overall Grade'!A21)","v":"       "},{"$f":"RIGHT('Overall Grade'!B21,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A22),+$A$1,+'Overall Grade'!A22)","v":"       "},{"$f":"RIGHT('Overall Grade'!B22,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A23),+$A$1,+'Overall Grade'!A23)","v":"       "},{"$f":"RIGHT('Overall Grade'!B23,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A24),+$A$1,+'Overall Grade'!A24)","v":"       "},{"$f":"RIGHT('Overall Grade'!B24,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A25),+$A$1,+'Overall Grade'!A25)","v":"       "},{"$f":"RIGHT('Overall Grade'!B25,5)","v":""}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A26),+$A$1,+'Overall Grade'!A26)","v":"       "},{"$f":"RIGHT('Overall Grade'!B26,5)","v":""}]
[null,"Average",{"$f":"AVERAGE(C3:C17)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"AVERAGE(E3:E18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F3:F18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G3:G18)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"High",{"$f":"MAX(C3:C17)","v":0},0,{"$f":"MAX(E3:E18)","v":0},{"$f":"MAX(F3:F18)","v":0},{"$f":"MAX(G3:G18)","v":0},0]
[null,"Low",{"$f":"MIN(C3:C18)","v":0},0,0,0,0,0]
[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,{"$f":"100*COUNT(C35:H35,C3:H3)","v":0}]
["Name","ID","Lab 7","Lab 8","Lab 9","Lab 10","Lab 11","Lab 12","Total"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A5),+$A$1,+'Overall Grade'!A5)","v":"Test student"},{"$f":"RIGHT('Overall Grade'!B5,5)","v":"54505"},null,null,null,null,null,null,{"$f":"SUM(C3:H3,C35:H35)","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A6),+$A$1,+'Overall Grade'!A6)","v":"       "},{"$f":"RIGHT('Overall Grade'!B6,5)","v":""},null,null,null,null,null,null,{"$f":"SUM(C4:H4,C36:H36)","v":0},null,null,"Lab Test"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A7),+$A$1,+'Overall Grade'!A7)","v":"       "},{"$f":"RIGHT('Overall Grade'!B7,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A5)))","v":1}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A8),+$A$1,+'Overall Grade'!A8)","v":"       "},{"$f":"RIGHT('Overall Grade'!B8,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A6)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A9),+$A$1,+'Overall Grade'!A9)","v":"       "},{"$f":"RIGHT('Overall Grade'!B9,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A7)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A10),+$A$1,+'Overall Grade'!A10)","v":"       "},{"$f":"RIGHT('Overall Grade'!B10,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A8)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A11),+$A$1,+'Overall Grade'!A11)","v":"       "},{"$f":"RIGHT('Overall Grade'!B11,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A10)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A12),+$A$1,+'Overall Grade'!A12)","v":"       "},{"$f":"RIGHT('Overall Grade'!B12,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A11)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A13),+$A$1,+'Overall Grade'!A13)","v":"       "},{"$f":"RIGHT('Overall Grade'!B13,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A12)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A14),+$A$1,+'Overall Grade'!A14)","v":"       "},{"$f":"RIGHT('Overall Grade'!B14,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!#REF!)))","v":1}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A15),+$A$1,+'Overall Grade'!A15)","v":"       "},{"$f":"RIGHT('Overall Grade'!B15,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A13)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A16),+$A$1,+'Overall Grade'!A16)","v":"       "},{"$f":"RIGHT('Overall Grade'!B16,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!#REF!)))","v":1}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A17),+$A$1,+'Overall Grade'!A17)","v":"       "},{"$f":"RIGHT('Overall Grade'!B17,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A14)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A18),+$A$1,+'Overall Grade'!A18)","v":"       "},{"$f":"RIGHT('Overall Grade'!B18,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A15)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A19),+$A$1,+'Overall Grade'!A19)","v":"       "},{"$f":"RIGHT('Overall Grade'!B19,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A16)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A20),+$A$1,+'Overall Grade'!A20)","v":"       "},{"$f":"RIGHT('Overall Grade'!B20,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!#REF!)))","v":1}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A21),+$A$1,+'Overall Grade'!A21)","v":"       "},{"$f":"RIGHT('Overall Grade'!B21,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A17)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A22),+$A$1,+'Overall Grade'!A22)","v":"       "},{"$f":"RIGHT('Overall Grade'!B22,5)","v":""},null,null,null,null,null,null,0,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A18)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A23),+$A$1,+'Overall Grade'!A23)","v":"       "},{"$f":"RIGHT('Overall Grade'!B23,5)","v":""},null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A24),+$A$1,+'Overall Grade'!A24)","v":"       "},{"$f":"RIGHT('Overall Grade'!B24,5)","v":""},null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A25),+$A$1,+'Overall Grade'!A25)","v":"       "},{"$f":"RIGHT('Overall Grade'!B25,5)","v":""},null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A26),+$A$1,+'Overall Grade'!A26)","v":"       "},{"$f":"RIGHT('Overall Grade'!B26,5)","v":""},null,null,null,null,null,null,{"$f":"SUM(C21:H21,C56:H56)","v":0},null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A19)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A24),+$A$1,+'Overall Grade'!A24)","v":"       "},{"$f":"RIGHT('Overall Grade'!B24,5)","v":""},{"$f":"AVERAGE(C35:C48)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D35:D48)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E35:E48)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F35:F48)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G35:G48)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H35:H52)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C24:H24,C56:H56)","v":0},null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A20)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A25),+$A$1,+'Overall Grade'!A25)","v":"       "},{"$f":"RIGHT('Overall Grade'!B25,5)","v":""},{"$f":"MAX(C35:C48)","v":0},{"$f":"MAX(D35:D48)","v":0},{"$f":"MAX(E35:E48)","v":0},{"$f":"MAX(F35:F48)","v":0},{"$f":"MAX(G35:G48)","v":0},{"$f":"MAX(H35:H52)","v":0},null,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A21)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A26),+$A$1,+'Overall Grade'!A26)","v":"       "},{"$f":"RIGHT('Overall Grade'!B26,5)","v":""},{"$f":"MIN(C35:C48)","v":0},{"$f":"MIN(D35:D48)","v":0},{"$f":"MIN(E35:E48)","v":0},{"$f":"MIN(F35:F48)","v":0},{"$f":"MAX(G35:G47)","v":0},{"$f":"MIN(H35:H52)","v":0},null,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A22)))","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A27),+$A$1,+'Overall Grade'!A27)","v":"       "},{"$f":"RIGHT('Overall Grade'!B27,5)","v":""},null,null,null,null,{"$f":"MIN(G35:G47)","v":0},null,null,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A23)))","v":0}]
[null,"Average",null,null,null,null,null,null,null,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A24)))","v":0}]
[null,"High",null,null,null,null,"Lab Average",null,null,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A25)))","v":0}]
[null,"Low",null,null,null,null,{"$f":"SUM(I35:I46)/(SUM(L37:L56)*+$I$33)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A26)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"N(NOT(ISBLANK('Overall Grade'!A27)))","v":0}]

{"sheet":"Tests 332A","index":3,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Test scores",null,100,100,100,{"$f":"COUNT(C3:E3)","v":0},200,{"$f":"100*COUNT(C3:E3)","v":0},null,null,"    "]
["Name","ID Number","Exam1","Exam2","Exam3","Total Pts","Final","Total %","Drop",null,null,"Zero Test"]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A5),+$K$1,'Overall Grade'!A5)","v":"Test student"},{"$f":"RIGHT('Overall Grade'!B5,5)","v":"54505"},null,null,null,{"$f":"SUM(C3:E3)","v":0},null,{"$f":"G3/$G$1","v":0},null,null,null,{"$f":"N(F3>0)","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A6),+$K$1,'Overall Grade'!A6)","v":"    "},{"$f":"RIGHT('Overall Grade'!B6,5)","v":""},null,null,null,{"$f":"SUM(C4:E4)","v":0},null,{"$f":"G4/$G$1","v":0},null,null,null,{"$f":"N(F4>0)","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A7),+$K$1,'Overall Grade'!A7)","v":"    "},{"$f":"RIGHT('Overall Grade'!B7,5)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A8),+$K$1,'Overall Grade'!A8)","v":"    "},{"$f":"RIGHT('Overall Grade'!B8,5)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A9),+$K$1,'Overall Grade'!A9)","v":"    "},{"$f":"RIGHT('Overall Grade'!B9,5)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A10),+$K$1,'Overall Grade'!A10)","v":"    "},{"$f":"RIGHT('Overall Grade'!B10,5)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A11),+$K$1,'Overall Grade'!A11)","v":"    "},{"$f":"RIGHT('Overall Grade'!B11,5)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A12),+$K$1,'Overall Grade'!A12)","v":"    "},{"$f":"RIGHT('Overall Grade'!B12,5)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A13),+$K$1,'Overall Grade'!A13)","v":"    "},{"$f":"RIGHT('Overall Grade'!B13,5)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A14),+$K$1,'Overall Grade'!A14)","v":"    "},{"$f":"RIGHT('Overall Grade'!B14,5)","v":""},null,null,null,0,null,0,null,null,null,{"$f":"N(F11>0)","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A15),+$K$1,'Overall Grade'!A15)","v":"    "},{"$f":"RIGHT('Overall Grade'!B15,5)","v":""},null,null,null,0,null,0,null,null,null,{"$f":"N(F12>0)","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A16),+$K$1,'Overall Grade'!A16)","v":"    "},{"$f":"RIGHT('Overall Grade'!B16,5)","v":""},null,null,null,0,null,0,null,null,null,{"$f":"N(F12>0)","v":0}]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A17),+$K$1,'Overall Grade'!A17)","v":"    "},{"$f":"RIGHT('Overall Grade'!B17,4)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A18),+$K$1,'Overall Grade'!A18)","v":"    "},{"$f":"RIGHT('Overall Grade'!B18,4)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A19),+$K$1,'Overall Grade'!A19)","v":"    "},{"$f":"RIGHT('Overall Grade'!B19,4)","v":""},null,null,null,{"$f":"SUM(C17:E17)","v":0},null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A20),+$K$1,'Overall Grade'!A20)","v":"    "},{"$f":"RIGHT('Overall Grade'!B20,4)","v":""},null,null,null,0,null,0,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A21),+$K$1,'Overall Grade'!A21)","v":"    "},{"$f":"RIGHT('Overall Grade'!B21,4)","v":""},null,null,null,0,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A22),+$K$1,'Overall Grade'!A22)","v":"    "},{"$f":"RIGHT('Overall Grade'!B22,4)","v":""},null,null,null,0,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A23),+$K$1,'Overall Grade'!A23)","v":"    "},{"$f":"RIGHT('Overall Grade'!B23,4)","v":""},null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A24),+$K$1,'Overall Grade'!A24)","v":"    "},{"$f":"RIGHT('Overall Grade'!B24,4)","v":""},null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A25),+$K$1,'Overall Grade'!A25)","v":"    "},{"$f":"RIGHT('Overall Grade'!B25,4)","v":""},null,null,null,0]
[{"$f":"IF(ISBLANK(+'Overall Grade'!A26),+$K$1,'Overall Grade'!A26)","v":"    "},{"$f":"RIGHT('Overall Grade'!B26,4)","v":""},null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,"Test Class Ave"]
[null,null,null,null,null,null,null,{"$f":"(SUM(F3:F18)/SUM(L3:L20))/+$G$1","v":{"$error":"#DIV/0!"}}]
[null,"Class Ave","Exam1","Exam2","Exam3",null,"Final"]
[null,"Average",{"$f":"AVERAGE(C3:C18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D3:D18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E3:E18)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G3:G18)/+$G$1","v":{"$error":"#DIV/0!"}}]
[null,"High",{"$f":"MAX(C3:C18)","v":0},{"$f":"MAX(D3:D18)","v":0},{"$f":"MAX(E3:E18)","v":0},null,{"$f":"MAX(G3:G18)","v":0}]
[null,"Low",{"$f":"MIN(C3:C18)","v":0},{"$f":"MIN(D3:D18)","v":0},{"$f":"MIN(E3:E18)","v":0},null,{"$f":"MIN(G3:G18)","v":0}]

{"sheet":"Assessment","index":4,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["ET 332A Assessment Report",null,null,null,{"$f":"'Overall Grade'!A30","v":"Fall 2015"}]
[]
["Class Averages"]
[]
[null,"Homework","Test/Quiz","Lab Reports","Final (Optional)"]
[null,{"$f":"'Homework 332A'!T47","v":0.11111111111111112},{"$f":"'Tests 332A'!H29","v":{"$error":"#DIV/0!"}},{"$f":"'Lab 332A'!G63","v":{"$error":"#DIV/0!"}},{"$f":"'Tests 332A'!G29","v":0}]
[]
[]
[]
[]
[]
[null,"Attendance"]
[null,{"$f":"Attendance!H95","v":1}]
[]
["Report as of","2002-06-11"]

{"sheet":"Overall Grade","index":5,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[null,null,"Exams","Labs","HW","Final","Total Grade",null,"Final Grade"]
["Weights",null,0.5,0.2,0.15,0.15,0.8,"      ",1]
[null,null,null,null,null,null,null,"Count"]
["Name","ID Number","Tests","Labs","HW","Final"," w.o final","Final","Final Grade","Attendance"]
["Test student","850054505",{"$f":"IF(ISBLANK(A5),+$H$2,('Tests 332A'!F3)/'Tests 332A'!$H$1*$C$2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISBLANK(A5),+$H$2,'Lab 332A'!I35/'Lab 332A'!$I$33*$D$2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISBLANK(A5),+$H$2,(+'Homework 332A'!R29+'Lesson Quizzes'!R30)/('Homework 332A'!$R$27+'Lesson Quizzes'!R28)*$E$2)","v":0.15},{"$f":"IF(ISBLANK(A5),+$H$2,'Tests 332A'!G3/'Tests 332A'!$G$1*$F$2)","v":0},{"$f":"IF(ISBLANK(A5),+$H$2,SUM(C5:E5)/+$G$2)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(ISBLANK(A5),+$H$2,+IF(COUNT(H5)<>0,SUM(C5:F5), SUM(C5:E5)/$G$2))","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(ISBLANK(A6),+$H$2,('Tests 332A'!F4)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A6),+$H$2,'Lab 332A'!I36/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A6),+$H$2,(+'Homework 332A'!R30)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A6),+$H$2,'Tests 332A'!G4/'Tests 332A'!$G$1*$F$2)","v":"      "},{"$f":"IF(ISBLANK(A6),+$H$2,SUM(C6:E6)/+$G$2)","v":"      "},null,{"$f":"IF(ISBLANK(A6),+$H$2,+IF(COUNT(H6)<>0,SUM(C6:F6), SUM(C6:E6)/$G$2))","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A7),+$H$2,('Tests 332A'!F5)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A7),+$H$2,'Lab 332A'!I37/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A7),+$H$2,(+'Homework 332A'!R31)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A7),+$H$2,'Tests 332A'!G5/'Tests 332A'!$G$1*$F$2)","v":"      "},{"$f":"IF(ISBLANK(A7),+$H$2,SUM(C7:E7)/+$G$2)","v":"      "},null,{"$f":"IF(ISBLANK(A7),+$H$2,+IF(COUNT(H7)<>0,SUM(C7:F7), SUM(C7:E7)/$G$2))","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A8),+$H$2,('Tests 332A'!F6)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A8),+$H$2,'Lab 332A'!I38/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A8),+$H$2,(+'Homework 332A'!R32)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A8),+$H$2,'Tests 332A'!G6/'Tests 332A'!$G$1*$F$2)","v":"      "},{"$f":"IF(ISBLANK(A8),+$H$2,SUM(C8:E8)/+$G$2)","v":"      "},null,{"$f":"IF(ISBLANK(A8),+$H$2,+IF(COUNT(H8)<>0,SUM(C8:F8), SUM(C8:E8)/$G$2))","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A9),+$H$2,('Tests 332A'!F7)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A9),+$H$2,'Lab 332A'!I39/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A9),+$H$2,(+'Homework 332A'!R33)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A9),+$H$2,'Tests 332A'!G7/'Tests 332A'!$G$1*$F$2)","v":"      "},{"$f":"IF(ISBLANK(A9),+$H$2,SUM(C9:E9)/+$G$2)","v":"      "},null,{"$f":"IF(ISBLANK(A9),+$H$2,+IF(COUNT(H9)<>0,SUM(C9:F9), SUM(C9:E9)/$G$2))","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A10),+$H$2,('Tests 332A'!F8)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A10),+$H$2,'Lab 332A'!I40/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A10),+$H$2,(+'Homework 332A'!R34)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A10),+$H$2,'Tests 332A'!G8/'Tests 332A'!$G$1*$F$2)","v":"      "},{"$f":"IF(ISBLANK(A10),+$H$2,SUM(C10:E10)/+$G$2)","v":"      "},null,{"$f":"IF(ISBLANK(A10),+$H$2,+IF(COUNT(H10)<>0,SUM(C10:F10), SUM(C10:E10)/$G$2))","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A11),+$H$2,('Tests 332A'!F9)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A11),+$H$2,'Lab 332A'!I41/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A11),+$H$2,(+'Homework 332A'!R35)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A11),+$H$2,'Tests 332A'!G9/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      "]
[null,null,{"$f":"IF(ISBLANK(A12),+$H$2,('Tests 332A'!F10)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A12),+$H$2,'Lab 332A'!I42/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A12),+$H$2,(+'Homework 332A'!R36)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A12),+$H$2,'Tests 332A'!G10/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      "]
[null,null,{"$f":"IF(ISBLANK(A13),+$H$2,('Tests 332A'!F11)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A13),+$H$2,'Lab 332A'!I43/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A13),+$H$2,(+'Homework 332A'!R37)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A13),+$H$2,'Tests 332A'!G11/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      "]
[null,null,{"$f":"IF(ISBLANK(A14),+$H$2,('Tests 332A'!F12)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A14),+$H$2,'Lab 332A'!I44/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A14),+$H$2,(+'Homework 332A'!R38)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A14),+$H$2,'Tests 332A'!G12/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      "]
[null,null,{"$f":"IF(ISBLANK(A15),+$H$2,('Tests 332A'!F13)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A15),+$H$2,'Lab 332A'!I45/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A15),+$H$2,(+'Homework 332A'!R39)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A15),+$H$2,'Tests 332A'!G13/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      "]
[null,null,{"$f":"IF(ISBLANK(A16),+$H$2,('Tests 332A'!F14)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A16),+$H$2,'Lab 332A'!I46/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A16),+$H$2,(+'Homework 332A'!R40)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A16),+$H$2,'Tests 332A'!G14/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      "]
[null,null,{"$f":"IF(ISBLANK(A17),+$H$2,('Tests 332A'!F15)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A17),+$H$2,'Lab 332A'!I47/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A17),+$H$2,(+'Homework 332A'!R41)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A17),+$H$2,'Tests 332A'!G15/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A17),+$H$2,Attendance!D100)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A18),+$H$2,('Tests 332A'!F16)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A18),+$H$2,'Lab 332A'!I48/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A18),+$H$2,(+'Homework 332A'!R42)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A18),+$H$2,'Tests 332A'!G16/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A18),+$H$2,Attendance!D101)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A19),+$H$2,('Tests 332A'!F17)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A19),+$H$2,'Lab 332A'!I49/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A19),+$H$2,(+'Homework 332A'!R43)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A19),+$H$2,'Tests 332A'!G17/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A19),+$H$2,Attendance!D102)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A20),+$H$2,('Tests 332A'!F18)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A20),+$H$2,'Lab 332A'!I50/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A20),+$H$2,(+'Homework 332A'!R44)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A20),+$H$2,'Tests 332A'!G18/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A20),+$H$2,Attendance!D103)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A21),+$H$2,('Tests 332A'!F19)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A21),+$H$2,'Lab 332A'!#REF!/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A21),+$H$2,(+'Homework 332A'!R45)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A21),+$H$2,'Tests 332A'!G19/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A21),+$H$2,Attendance!D104)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A22),+$H$2,('Tests 332A'!F20)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A22),+$H$2,'Lab 332A'!I48/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A22),+$H$2,(+'Homework 332A'!R46)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A22),+$H$2,'Tests 332A'!G20/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A22),+$H$2,Attendance!D105)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A23),+$H$2,('Tests 332A'!F21)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A23),+$H$2,'Lab 332A'!#REF!/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A23),+$H$2,(+'Homework 332A'!R47)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A23),+$H$2,'Tests 332A'!G21/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A23),+$H$2,Attendance!D106)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A24),+$H$2,('Tests 332A'!F28)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A24),+$H$2,'Lab 332A'!I51/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A24),+$H$2,(+'Homework 332A'!R48)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A24),+$H$2,'Tests 332A'!G22/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A24),+$H$2,Attendance!D107)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A25),+$H$2,('Tests 332A'!F29)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A25),+$H$2,'Lab 332A'!I52/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A25),+$H$2,(+'Homework 332A'!R49)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A25),+$H$2,'Tests 332A'!G23/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A25),+$H$2,Attendance!D108)","v":"      "}]
[null,null,{"$f":"IF(ISBLANK(A26),+$H$2,('Tests 332A'!F30)/'Tests 332A'!$H$1*$C$2)","v":"      "},{"$f":"IF(ISBLANK(A26),+$H$2,'Lab 332A'!#REF!/'Lab 332A'!$I$33*$D$2)","v":"      "},{"$f":"IF(ISBLANK(A26),+$H$2,(+'Homework 332A'!R50)/'Homework 332A'!$R$27*$E$2)","v":"      "},{"$f":"IF(ISBLANK(A26),+$H$2,'Tests 332A'!G24/'Tests 332A'!$G$1*$F$2)","v":"      "},"      ",null,"      ",{"$f":"IF(ISBLANK(A26),+$H$2,Attendance!D109)","v":"      "}]
[]
[]
[]
["Fall 2015","Semester start"]
[null,"2015-08-24"]
[]
[]
[null,"Exams","Labs","HW","Final",null,"Total Grade",null,"Final %"]
["Weights",0.5,0.2,0.1,0.2,null,0.8,null,1]
[]
[null,null,null,null,null,null,null,"Final",null,"Current"]
["ID Code","Tests","Labs","HW","Final","Final "," w.o final","Count ","Final %","Grade","Exam 3 Score"]
[{"$f":"RIGHT(B5,5)","v":"54505"},{"$f":"C5","v":{"$error":"#DIV/0!"}},{"$f":"D5","v":{"$error":"#DIV/0!"}},{"$f":"E5","v":0.15},{"$f":"F5","v":0},{"$f":"IF(ISBLANK(A5),$H$2,'Tests 332A'!H3)","v":0},{"$f":"G5","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISBLANK(H5),+$H$2,H5)","v":"      "},{"$f":"I5","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISBLANK(A5),$H$2,IF(+I5>=$A$68,$B$68,IF(AND(I5<$A$68,I5>=$A$69),$B$69,IF(AND(I5<$A$69,I5>=$A$70),$B$70,IF(AND(I5<$A$70,I5>=$A$71),$B$71,IF(I5<$A$71,$B$72,$H$2))))))","v":{"$error":"#DIV/0!"}},{"$f":"'Tests 332A'!E3","v":0}]
[{"$f":"RIGHT(B6,5)","v":""},{"$f":"C6","v":"      "},"      ","      ","      ",{"$f":"IF(ISBLANK(A6),$H$2,'Tests 332A'!H4)","v":"      "},{"$f":"G6","v":"      "},{"$f":"IF(ISBLANK(H6),+$H$2,H6)","v":"      "},{"$f":"I6","v":"      "},{"$f":"IF(ISBLANK(A6),$H$2,IF(+I6>=$A$68,$B$68,IF(AND(I6<$A$68,I6>=$A$69),$B$69,IF(AND(I6<$A$69,I6>=$A$70),$B$70,IF(AND(I6<$A$70,I6>=$A$71),$B$71,IF(I6<$A$71,$B$72,$H$2))))))","v":"      "},{"$f":"'Tests 332A'!E4","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A7),$H$2,'Tests 332A'!H5)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E5","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A8),$H$2,'Tests 332A'!H6)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E6","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A9),$H$2,'Tests 332A'!H7)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E7","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A10),$H$2,'Tests 332A'!H8)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E8","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A11),$H$2,'Tests 332A'!H9)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E9","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A12),$H$2,'Tests 332A'!H10)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E10","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A13),$H$2,'Tests 332A'!H11)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E11","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A14),$H$2,'Tests 332A'!H12)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E12","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A15),$H$2,'Tests 332A'!H13)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E13","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A16),$H$2,'Tests 332A'!H14)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E14","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A17),$H$2,'Tests 332A'!H15)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E15","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A18),$H$2,'Tests 332A'!H16)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E16","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A19),$H$2,'Tests 332A'!H17)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E17","v":0}]
["","      ","      ","      ","      ",{"$f":"IF(ISBLANK(A20),$H$2,'Tests 332A'!H18)","v":"      "},"      ","      ","      ","      ",{"$f":"'Tests 332A'!E18","v":0}]
[{"$f":"RIGHT(B21,4)","v":""},"      ","      ",null,{"$f":"F21","v":"      "},{"$f":"IF(ISBLANK(A21),$H$2,'Tests 332A'!H19)","v":"      "},"      ","      ",null,"      "]
["","      ","      ",null,{"$f":"F22","v":"      "},{"$f":"IF(ISBLANK(A22),$H$2,'Tests 332A'!H20)","v":"      "},"      ","      ",null,"      "]
["","      ","      ",null,{"$f":"F23","v":"      "},{"$f":"IF(ISBLANK(A23),$H$2,'Tests 332A'!H21)","v":"      "},"      ","      ",null,"      "]
["","      ","      ",null,{"$f":"F24","v":"      "},{"$f":"IF(ISBLANK(A24),$H$2,'Tests 332A'!H22)","v":"      "},"      ","      ",null,"      "]
["","      ","      ",null,{"$f":"F25","v":"      "},{"$f":"IF(ISBLANK(A25),$H$2,'Tests 332A'!H23)","v":"      "},"      ","      ",null,"      "]
[null,{"$f":"C26","v":"      "},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,null,null,null,null,null,null,"      "]
[]
[]
[]
["Grade Range"]
[0.9,"A"]
[0.8,"B"]
[0.7,"C"]
[0.6,"D"]
["below 60.0%","F"]

{"sheet":"Homework 332A","index":6,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Homework","    "]
["Name","ID","hw1","hw2","hw3","hw4","hw5","hw6","hw7","hw8","hw9","hw10","hw11","hw12","hw13","hw14","hw15","hw16"]
[{"$f":"IF(ISBLANK('Overall Grade'!A5),+$B$1,+'Overall Grade'!A5)","v":"Test student"},{"$f":"IF(ISBLANK('Overall Grade'!B5),+$B$1,RIGHT('Overall Grade'!B5,5))","v":"54505"},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[{"$f":"IF(ISBLANK('Overall Grade'!A6),+$B$1,+'Overall Grade'!A6)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B6),+$B$1,RIGHT('Overall Grade'!B6,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A7),+$B$1,+'Overall Grade'!A7)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B7),+$B$1,RIGHT('Overall Grade'!B7,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A8),+$B$1,+'Overall Grade'!A8)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B8),+$B$1,RIGHT('Overall Grade'!B8,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A9),+$B$1,+'Overall Grade'!A9)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B9),+$B$1,RIGHT('Overall Grade'!B9,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A10),+$B$1,+'Overall Grade'!A10)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B10),+$B$1,RIGHT('Overall Grade'!B10,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A11),+$B$1,+'Overall Grade'!A11)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B11),+$B$1,RIGHT('Overall Grade'!B11,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A12),+$B$1,+'Overall Grade'!A12)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B12),+$B$1,RIGHT('Overall Grade'!B12,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A13),+$B$1,+'Overall Grade'!A13)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B13),+$B$1,RIGHT('Overall Grade'!B13,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A14),+$B$1,+'Overall Grade'!A14)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B14),+$B$1,RIGHT('Overall Grade'!B14,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A15),+$B$1,+'Overall Grade'!A15)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B15),+$B$1,RIGHT('Overall Grade'!B15,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A16),+$B$1,+'Overall Grade'!A16)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B16),+$B$1,RIGHT('Overall Grade'!B16,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A17),+$B$1,+'Overall Grade'!A17)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B17),+$B$1,RIGHT('Overall Grade'!B17,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A18),+$B$1,+'Overall Grade'!A18)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B18),+$B$1,RIGHT('Overall Grade'!B18,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A19),+$B$1,+'Overall Grade'!A19)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B19),+$B$1,RIGHT('Overall Grade'!B19,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A20),+$B$1,+'Overall Grade'!A20)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B20),+$B$1,RIGHT('Overall Grade'!B20,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A21),+$B$1,+'Overall Grade'!A21)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B21),+$B$1,RIGHT('Overall Grade'!B21,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A22),+$B$1,+'Overall Grade'!A22)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B22),+$B$1,RIGHT('Overall Grade'!B22,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A23),+$B$1,+'Overall Grade'!A23)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B23),+$B$1,RIGHT('Overall Grade'!B23,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A24),+$B$1,+'Overall Grade'!A24)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B24),+$B$1,RIGHT('Overall Grade'!B24,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A25),+$B$1,+'Overall Grade'!A25)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B25),+$B$1,RIGHT('Overall Grade'!B25,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A26),+$B$1,+'Overall Grade'!A26)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B26),+$B$1,RIGHT('Overall Grade'!B26,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A27),+$B$1,+'Overall Grade'!A27)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B27),+$B$1,RIGHT('Overall Grade'!B27,5))","v":"    "}]
[]
["Homework",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*COUNT(C29:Q29,C3:R3)","v":3100}]
["Name","ID","hw17","hw18","hw19","hw20","hw21","hw22","hw23","hw24","hw25","hw26","hw27","hw28","hw29","hw30","hw31","Total"]
[{"$f":"IF(ISBLANK('Overall Grade'!A5),+$B$1,+'Overall Grade'!A5)","v":"Test student"},{"$f":"IF(ISBLANK('Overall Grade'!B5),+$B$1,RIGHT('Overall Grade'!B5,5))","v":"54505"},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,{"$f":"SUM(C3:R3,C29:Q29)","v":3100}]
[{"$f":"IF(ISBLANK('Overall Grade'!A6),+$B$1,+'Overall Grade'!A6)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B6),+$B$1,RIGHT('Overall Grade'!B6,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A7),+$B$1,+'Overall Grade'!A7)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B7),+$B$1,RIGHT('Overall Grade'!B7,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A8),+$B$1,+'Overall Grade'!A8)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B8),+$B$1,RIGHT('Overall Grade'!B8,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A9),+$B$1,+'Overall Grade'!A9)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B9),+$B$1,RIGHT('Overall Grade'!B9,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A10),+$B$1,+'Overall Grade'!A10)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B10),+$B$1,RIGHT('Overall Grade'!B10,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A11),+$B$1,+'Overall Grade'!A11)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B11),+$B$1,RIGHT('Overall Grade'!B11,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A12),+$B$1,+'Overall Grade'!A12)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B12),+$B$1,RIGHT('Overall Grade'!B12,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A13),+$B$1,+'Overall Grade'!A13)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B13),+$B$1,RIGHT('Overall Grade'!B13,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A14),+$B$1,+'Overall Grade'!A14)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B14),+$B$1,RIGHT('Overall Grade'!B14,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A15),+$B$1,+'Overall Grade'!A15)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B15),+$B$1,RIGHT('Overall Grade'!B15,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A16),+$B$1,+'Overall Grade'!A16)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B16),+$B$1,RIGHT('Overall Grade'!B16,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A17),+$B$1,+'Overall Grade'!A17)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B17),+$B$1,RIGHT('Overall Grade'!B17,4))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A18),+$B$1,+'Overall Grade'!A18)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B18),+$B$1,RIGHT('Overall Grade'!B18,4))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A19),+$B$1,+'Overall Grade'!A19)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B19),+$B$1,RIGHT('Overall Grade'!B19,4))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A20),+$B$1,+'Overall Grade'!A20)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B20),+$B$1,RIGHT('Overall Grade'!B20,4))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A21),+$B$1,+'Overall Grade'!A21)","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A22),+$B$1,+'Overall Grade'!A22)","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Class Ave"]
[{"$f":"IF(ISBLANK('Overall Grade'!A23),+$B$1,+'Overall Grade'!A23)","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AVERAGE(R29:R37)/$R$27","v":0.11111111111111112}]
[{"$f":"IF(ISBLANK('Overall Grade'!A24),+$B$1,+'Overall Grade'!A24)","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A25),+$B$1,+'Overall Grade'!A25)","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A26),+$B$1,+'Overall Grade'!A26)","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Lesson Quizzes","index":7,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Lesson Quizzes","    "]
["Name","ID","Lesson \nQuiz 1","Lesson \nQuiz 2","Lesson \nQuiz 3","Lesson \nQuiz 4","Lesson \nQuiz 5","Lesson \nQuiz 6","Lesson \nQuiz 7","Lesson \nQuiz 8","Lesson \nQuiz 9","Lesson \nQuiz 10","Lesson \nQuiz 11","Lesson \nQuiz 12","Lesson \nQuiz 13"]
[{"$f":"IF(ISBLANK('Overall Grade'!A5),+$B$1,+'Overall Grade'!A5)","v":"Test student"},{"$f":"IF(ISBLANK('Overall Grade'!B5),+$B$1,RIGHT('Overall Grade'!B5,5))","v":"54505"},10,20,20,20,20,20,20,20,20,20,20,20,20]
[{"$f":"IF(ISBLANK('Overall Grade'!A6),+$B$1,+'Overall Grade'!A6)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B6),+$B$1,RIGHT('Overall Grade'!B6,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A7),+$B$1,+'Overall Grade'!A7)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B7),+$B$1,RIGHT('Overall Grade'!B7,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A8),+$B$1,+'Overall Grade'!A8)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B8),+$B$1,RIGHT('Overall Grade'!B8,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A9),+$B$1,+'Overall Grade'!A9)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B9),+$B$1,RIGHT('Overall Grade'!B9,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A10),+$B$1,+'Overall Grade'!A10)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B10),+$B$1,RIGHT('Overall Grade'!B10,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A11),+$B$1,+'Overall Grade'!A11)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B11),+$B$1,RIGHT('Overall Grade'!B11,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A12),+$B$1,+'Overall Grade'!A12)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B12),+$B$1,RIGHT('Overall Grade'!B12,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A13),+$B$1,+'Overall Grade'!A13)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B13),+$B$1,RIGHT('Overall Grade'!B13,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A14),+$B$1,+'Overall Grade'!A14)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B14),+$B$1,RIGHT('Overall Grade'!B14,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A15),+$B$1,+'Overall Grade'!A15)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B15),+$B$1,RIGHT('Overall Grade'!B15,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A16),+$B$1,+'Overall Grade'!A16)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B16),+$B$1,RIGHT('Overall Grade'!B16,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A17),+$B$1,+'Overall Grade'!A17)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B17),+$B$1,RIGHT('Overall Grade'!B17,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A18),+$B$1,+'Overall Grade'!A18)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B18),+$B$1,RIGHT('Overall Grade'!B18,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A19),+$B$1,+'Overall Grade'!A19)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B19),+$B$1,RIGHT('Overall Grade'!B19,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A20),+$B$1,+'Overall Grade'!A20)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B20),+$B$1,RIGHT('Overall Grade'!B20,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A21),+$B$1,+'Overall Grade'!A21)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B21),+$B$1,RIGHT('Overall Grade'!B21,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A22),+$B$1,+'Overall Grade'!A22)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B22),+$B$1,RIGHT('Overall Grade'!B22,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A23),+$B$1,+'Overall Grade'!A23)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B23),+$B$1,RIGHT('Overall Grade'!B23,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A24),+$B$1,+'Overall Grade'!A24)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B24),+$B$1,RIGHT('Overall Grade'!B24,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A25),+$B$1,+'Overall Grade'!A25)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B25),+$B$1,RIGHT('Overall Grade'!B25,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A26),+$B$1,+'Overall Grade'!A26)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B26),+$B$1,RIGHT('Overall Grade'!B26,5))","v":"    "}]
[{"$f":"IF(ISBLANK('Overall Grade'!A27),+$B$1,+'Overall Grade'!A27)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B27),+$B$1,RIGHT('Overall Grade'!B27,5))","v":"    "}]
[]
[]
["Lesson Quizzes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"20*COUNT(C30:I30,K30:N30,D3:O3)+10*COUNT(C3)+10*COUNT(J30)","v":480}]
["Name","ID","Lesson \nQuiz 14","Lesson \nQuiz 15","Lesson \nQuiz 16","Lesson \nQuiz 17","Lesson \nQuiz 18","Lesson \nQuiz 19","Lesson \nQuiz 20","Lesson \nQuiz 21","Lesson \nQuiz 22","Lesson \nQuiz 23","Lesson \nQuiz 24","Lesson \nQuiz 25",null,null,null,"Total"]
[{"$f":"IF(ISBLANK('Overall Grade'!A5),+$B$1,+'Overall Grade'!A5)","v":"Test student"},{"$f":"IF(ISBLANK('Overall Grade'!B5),+$B$1,RIGHT('Overall Grade'!B5,5))","v":"54505"},20,20,20,20,20,20,20,10,20,20,20,20,null,null,null,{"$f":"SUM(C3:O3,C30:Q30)","v":480}]
[{"$f":"IF(ISBLANK('Overall Grade'!A6),+$B$1,+'Overall Grade'!A6)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B6),+$B$1,RIGHT('Overall Grade'!B6,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C4:O4,C31:Q31)","v":0}]
[{"$f":"IF(ISBLANK('Overall Grade'!A7),+$B$1,+'Overall Grade'!A7)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B7),+$B$1,RIGHT('Overall Grade'!B7,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A8),+$B$1,+'Overall Grade'!A8)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B8),+$B$1,RIGHT('Overall Grade'!B8,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A9),+$B$1,+'Overall Grade'!A9)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B9),+$B$1,RIGHT('Overall Grade'!B9,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A10),+$B$1,+'Overall Grade'!A10)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B10),+$B$1,RIGHT('Overall Grade'!B10,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A11),+$B$1,+'Overall Grade'!A11)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B11),+$B$1,RIGHT('Overall Grade'!B11,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A12),+$B$1,+'Overall Grade'!A12)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B12),+$B$1,RIGHT('Overall Grade'!B12,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A13),+$B$1,+'Overall Grade'!A13)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B13),+$B$1,RIGHT('Overall Grade'!B13,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A14),+$B$1,+'Overall Grade'!A14)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B14),+$B$1,RIGHT('Overall Grade'!B14,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A15),+$B$1,+'Overall Grade'!A15)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B15),+$B$1,RIGHT('Overall Grade'!B15,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A16),+$B$1,+'Overall Grade'!A16)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B16),+$B$1,RIGHT('Overall Grade'!B16,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A17),+$B$1,+'Overall Grade'!A17)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B17),+$B$1,RIGHT('Overall Grade'!B17,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A18),+$B$1,+'Overall Grade'!A18)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B18),+$B$1,RIGHT('Overall Grade'!B18,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A19),+$B$1,+'Overall Grade'!A19)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B19),+$B$1,RIGHT('Overall Grade'!B19,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A20),+$B$1,+'Overall Grade'!A20)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B20),+$B$1,RIGHT('Overall Grade'!B20,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A21),+$B$1,+'Overall Grade'!A21)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B21),+$B$1,RIGHT('Overall Grade'!B21,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A22),+$B$1,+'Overall Grade'!A22)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B22),+$B$1,RIGHT('Overall Grade'!B22,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A23),+$B$1,+'Overall Grade'!A23)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B23),+$B$1,RIGHT('Overall Grade'!B23,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A24),+$B$1,+'Overall Grade'!A24)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B24),+$B$1,RIGHT('Overall Grade'!B24,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A25),+$B$1,+'Overall Grade'!A25)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B25),+$B$1,RIGHT('Overall Grade'!B25,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(ISBLANK('Overall Grade'!A26),+$B$1,+'Overall Grade'!A26)","v":"    "},{"$f":"IF(ISBLANK('Overall Grade'!B26),+$B$1,RIGHT('Overall Grade'!B26,5))","v":"    "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Distributions","index":8,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Assessment",null,"Needs \nImprovement (<70)","Meets \n (70-89)","Exceeds \n(>90)"]
["Bins",0,69,89,100]
["Exam Distributions"]
["Bin Values","Exam 1","Exam 2","Exam 3"]
[{"$f":"B2","v":0}]
[{"$f":"C2","v":69}]
[{"$f":"D2","v":89}]
[{"$f":"E2","v":100}]
["more"]
["Lab Distributions",{"$f":"SUM(B5:B9)","v":0},{"$f":"SUM(C5:C9)","v":0},0]
["Bin Values","Lab 1","Lab 2","Lab 3","Lab 4","Lab 5","Lab 6"]
[{"$f":"B2","v":0}]
[{"$f":"C2","v":69}]
[{"$f":"D2","v":89}]
[{"$f":"E2","v":100}]
["more"]
["Total",{"$f":"SUM(B12:B16)","v":0},{"$f":"SUM(C12:C16)","v":0},0,0,0,0]
["Bin Values","Lab 7","Lab 8","Lab 9","Lab 10","Lab 11","Lab 12"]
[{"$f":"B2","v":0}]
[{"$f":"C2","v":69}]
[{"$f":"D2","v":89}]
[{"$f":"E2","v":100}]
["more"]
["Total",{"$f":"SUM(B19:B23)","v":0},{"$f":"SUM(C19:C23)","v":0},0,0,0,0]
[]
["Homework \nDistributions"]
["Bin Values","HW1","HW2","HW3","HW4","HW5","HW6","HW7","HW8","HW9","HW10","HW11","HW12","HW13","HW14","HW15","HW16"]
[{"$f":"B2","v":0}]
[{"$f":"C2","v":69}]
[{"$f":"D2","v":89}]
[{"$f":"E2","v":100}]
["more"]
["Total",{"$f":"SUM(B28:B32)","v":0},{"$f":"SUM(C28:C32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bin Values","HW17","HW18","HW19","HW20","HW21","HW22","HW23","HW24","HW25","HW26","HW27","HW28","HW29","HW30","HW31","HW32"]
[{"$f":"B2","v":0}]
[{"$f":"C2","v":69}]
[{"$f":"D2","v":89}]
[{"$f":"E2","v":100}]
["more"]
["Total",{"$f":"SUM(B35:B39)","v":0},{"$f":"SUM(C35:C39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"A-database","index":9,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Item","Needs Improvement (<70)","Meets  (70-89)","Exceeds (>90)","Assessment ID"]
[null,null,null,null,"E01"]
[null,null,null,null,"E02"]
[null,null,null,null,"E03"]
[null,null,null,null,"L01"]
[null,null,null,null,"L02"]
[null,null,null,null,"L03"]
[null,null,null,null,"L04"]
[null,null,null,null,"L05"]
[null,null,null,null,"L06"]
[null,null,null,null,"L07"]
[null,null,null,null,"L08"]
[null,null,null,null,"L09"]
[null,null,null,null,"L10"]
[null,null,null,null,"L11"]
[null,null,null,null,"L12"]
[null,null,null,null,"H01"]
[null,null,null,null,"H02"]
[null,null,null,null,"H03"]
[null,null,null,null,"H04"]
[null,null,null,null,"H05"]
[null,null,null,null,"H06"]
[null,null,null,null,"H07"]
[null,null,null,null,"H08"]
[null,null,null,null,"H09"]
[null,null,null,null,"H10"]
[null,null,null,null,"H11"]
[null,null,null,null,"H12"]
[null,null,null,null,"H13"]
[null,null,null,null,"H14"]
[null,null,null,null,"H15"]
[null,null,null,null,"H16"]
[null,null,null,null,"H17"]
[null,null,null,null,"H18"]
[null,null,null,null,"H19"]
[null,null,null,null,"H20"]
[null,null,null,null,"H21"]
[null,null,null,null,"H22"]
[null,null,null,null,"H23"]
[null,null,null,null,"H24"]
[null,null,null,null,"H25"]
[null,null,null,null,"H26"]
[null,null,null,null,"H27"]
[null,null,null,null,"H28"]
[null,null,null,null,"H29"]
[null,null,null,null,"H30"]
[null,null,null,null,"H31"]
[null,null,null,null,"H32"]

{"sheet":"A-Map","index":10,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Assessment Map"]
[null,"EET Code"]
["CPC Code","EET-1","EET-2","EET-3","EET-4","EET-6","EET-9"]
[1,"E01L03"]
[2,"E01H08"]
[3,null,null,null,"E01"]
[4,"E01H01H02H03H04H05H06L01"]
[5,"E01H07"]
[6,"E01H09L04"]
[7,null,null,null,"E01L04L05L10L11"]
[8,null,null,null,"E02L05"]
[9,"E02"]
[10,"E02L03"]
[11,null,null,"E02H10"]
[12,null,null,"E02H12L05"]
[13,"E02H12H13H14"]
[14,null,null,"E02H15H16L06"]
[15,null,null,"E02H12H13H14"]
[16,null,null,null,"E02H17H18L07"]
[17,null,"E03H20"]
[18,null,"E03H19H25"]
[19,"E03L02"]
[20,"E02E03"]
[21,null,null,"E02E03L06L08L09"]
[22,null,null,"E02"]
[23,null,null,null,null,"E03H21H22H23H24"]
[24,null,null,"E03H26H27H28"]
[25,null,null,null,null,"E03H26H27H28"]
[26,null,null,"E03H26H27H28"]
[27,null,null,null,null,"E03H26H27H28"]
[28,null,null,null,null,null,"E03H26H27H28L12"]

{"sheet":"EET-1 Details","index":11,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Needs Improvement","Meets","Exceeds"]
["EET-1 Fundmentals\n\nET332a\nCourse Performance\nCriteria","Fraction of students that attain a grade level below 70% on all assessments pertaining to the listed Course Performance Criteria. ","Fraction of students that attain a grade level between 70% and 89% on all assessments pertaining to the listed Course Performance Criteria","Fraction of students that attain a grade level of 90% or above on all assessments pertaining to the listed Course Performance Criteria."]
["Explain how\nelectromagnetism can transfer electric energy to mechanical energy."]
["Use the basic principles of physics to describe simple linear and rotational motion."]
["Explain the key parts of\n magnetic circuits and perform basic magnetic circuit calculations."]
["List the sources of power\n loss in magnetic circuits."]
["Explain how \nelectromagnetic forces produce motor action."]
["Define commutation in dc\n machines and list factors that affect it."]
["List the parts of a practical\n dc machine."]
["Explain how torque is \ndeveloped in a separately excited dc motor."]
["Interpret standard \nmotor/generator terminal markings."]
["List dc motor starting\n methods."]

{"sheet":"EET-2 Details","index":12,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Needs Improvement","Meets","Exceeds"]
["EET-2\nInterperting Data\n\nET332a\nCourse Performance\nCriteria","Fraction of students that attain a grade level below 70% on all assessments pertaining to the listed Course Performance Criteria. ","Fraction of students that attain a grade level between 70% and 89% on all assessments pertaining to the listed Course Performance Criteria","Fraction of students that attain a grade level of 90% or above on all assessments pertaining to the listed Course Performance Criteria."]
["Interpret NEMA ratings\n"]
["Read basic motor control ladder diagrams\n"]

{"sheet":"EET-3 Details","index":13,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Needs Improvement","Meets","Exceeds"]
["EET-3 Modeling\n\nET332a\nCourse Performance\nCriteria","Fraction of students that attain a grade level below 70% on all assessments pertaining to the listed Course Performance Criteria. ","Fraction of students that attain a grade level between 70% and 89% on all assessments pertaining to the listed Course Performance Criteria","Fraction of students that attain a grade level of 90% or above on all assessments pertaining to the listed Course Performance Criteria."]
["Use the model of \nseparately excited dc generator to perform electrical calculations"]
["Determine the voltage \nregulation of a dc generator."]
["Use the equivalent circuit \nmodel of the separately excited dc motor to perform calculations."]
["Explain the operation of \na shunt connected dc motor and use an equivalent circuit model to perform calculations."]
["Compare and contrast \nthe torque speed characteristics of separately excited, shunt, series, and compound connected dc motors."]
["Calculate speed \nregulation of a dc motor."]
["Explain how photocells \nconvert light into electric current."]
["Explain how photocells \nconvert light into electric current."]

{"sheet":"EET-4 Details","index":14,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Needs Improvement","Meets","Exceeds"]
["EET-4 Experimentation\n\nET332a\nCourse Performance\nCriteria","Fraction of students that attain a grade level below 70% on all assessments pertaining to the listed Course Performance Criteria. ","Fraction of students that attain a grade level between 70% and 89% on all assessments pertaining to the listed Course Performance Criteria","Fraction of students that attain a grade level of 90% or above on all assessments pertaining to the listed Course Performance Criteria."]
["Determine the \ntorque-speed relationships for typical mechanical loads."]
["Explain how \nelectromagnetic induction produces generator voltage."]
["Explain how voltage \nis generated in elementary dc machines."]
["Determine the losses \nand efficiency of a dc motor."]

{"sheet":"EET-5 Details","index":15,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Needs Improvement","Meets","Exceeds"]
["EET-5 Problem Solving\n\nET332a\nCourse Performance\nCriteria","Fraction of students that attain a grade level below 70% on all assessments pertaining to the listed Course Performance Criteria. ","Fraction of students that attain a grade level between 70% and 89% on all assessments pertaining to the listed Course Performance Criteria","Fraction of students that attain a grade level of 90% or above on all assessments pertaining to the listed Course Performance Criteria."]
["Calculate motor \nperformance when magnetic circuits saturate."]
["Compute photocell \nvoltage, current, and efficiency."]
["Find the maximum \npower transfer of a solar cell."]

{"sheet":"EET-9 Details","index":16,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Needs Improvement","Meets","Exceeds"]
["EET-9 Contemporary Issues\n\nET332a\nCourse Performance\nCriteria","Fraction of students that attain a grade level below 70% on all assessments pertaining to the listed Course Performance Criteria. ","Fraction of students that attain a grade level between 70% and 89% on all assessments pertaining to the listed Course Performance Criteria","Fraction of students that attain a grade level of 90% or above on all assessments pertaining to the listed Course Performance Criteria."]
["Analyze the economics \nof owning a solar panel"]

{"sheet":"Summary","index":17,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Needs Improvement","Meets","Exceeds"]
["Course Performance Rubric\n\nCourse Student Outcomes ET332a","Fraction of students that \nattain a grade level below 70% on all assessments pertaining to the listed Course Performance Criteria. ","Fraction of students that attain a grade level between 70% and 89% on all assessments pertaining to the listed Course Performance Criteria","Fraction of students that attain a grade level of 90% or above on all assessments pertaining to the listed Course Performance Criteria."]
["EET-1 Fundamentals\n",{"$f":"AVERAGE('EET-1 Details'!B7:B16)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-1 Details'!C7:C16)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-1 Details'!D7:D16)","v":{"$error":"#DIV/0!"}}]
["EET 2 Interpreting Data\n",{"$f":"AVERAGE('EET-2 Details'!B7:B8)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-2 Details'!C7:C8)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-2 Details'!D7:D8)","v":{"$error":"#DIV/0!"}}]
["EET-3 Modeling\n",{"$f":"AVERAGE('EET-3 Details'!B7:B14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-3 Details'!C7:C14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-3 Details'!D7:D14)","v":{"$error":"#DIV/0!"}}]
["EET-4 Experimentation\n",{"$f":"AVERAGE('EET-4 Details'!B7:B10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-4 Details'!C7:C10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-4 Details'!D7:D10)","v":{"$error":"#DIV/0!"}}]
["EET-5 Problem Solving\n",{"$f":"AVERAGE('EET-5 Details'!B7:B9)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-5 Details'!C7:C9)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-5 Details'!D7:D9)","v":{"$error":"#DIV/0!"}}]
["EET-9 Contemporary \nIssues",{"$f":"AVERAGE('EET-9 Details'!B7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-9 Details'!C7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('EET-9 Details'!D7)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Student Course Evaluation ICE Part II","Course Mean Value \nof all evaluation items"]
["Course Average",{"$f":"'ICE Part II'!C26","v":{"$error":"#DIV/0!"}}]
[]
[]
["Student Course Evaluation ICE Part III\n\nStudent Course Outcomes","Course mean values for all items pertaining to student course outcomes"]
["EET-1 Fundamentals",{"$f":"('ICE Part III'!C6+'ICE Part III'!C7)/2","v":0}]
["EET-6 Design",{"$f":"'ICE Part III'!C11","v":0}]
["EET-7 Communication",{"$f":"'ICE Part III'!C14","v":0}]
["EET-9 Contemporary \nIssues",{"$f":"('ICE Part III'!C8+'ICE Part III'!C9+'ICE Part III'!C10+'ICE Part III'!C13+'ICE Part III'!C15)/5","v":0}]
["EET-10 Ethics",{"$f":"'ICE Part III'!C12","v":0}]

{"sheet":"ICE Part II","index":18,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"ICE Part II Results","Note: Items marked * are reversed in scoring. "]
["Course","ET 332a","Disagreement leads to a high mean. Response percentages have not been changed"]
["Semester",{"$f":"'Overall Grade'!A30","v":"Fall 2015"},"Enter values in colored area"]
["Item Number","Item","Mean","Standard\nDeviation","% Strongly \nAgree","%  \nAgree","%  \nNeither Agree or disagree","%  \nDisagree","%  Strongly Disagree","% No Response"]
[21,"Course was a good Learning Experience"]
[22,"Course Content was Good"]
[23,"The Course was Well Organized"]
[24,"Trouble Paying Attention In Class*"]
[25,"Additional Prerequisites*"]
[26,"Fewer Prerequisites*"]
[27,"Course was Very Interesting"]
[28,"Required Work was Appropriate"]
[29,"Course was One of the Best"]
[30,"The Tests Covered the Course"]
[31,"Course was a Waste of Time*"]
[32,"Textbook was Good"]
[33,"AV Could be Used More Effectively"]
[34,"Should be Taught in Some Other Way*"]
[35,"Covered Material in Other Courses*"]
[36,"Material Was Too Difficult*"]
[37,"Course Should be Continued to be Offered"]
[38,"Reading Assignments Hard to Understand*"]
[39,"I was often Confused*"]
[40,"Generally, the Course was Good"]
[]
[null,"Course Average",{"$f":"AVERAGE(C5:C24)","v":{"$error":"#DIV/0!"}}]

{"sheet":"ICE Part III","index":19,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"ICE Part III Results"]
["Course","ET 332a"]
["Semester",{"$f":"'Overall Grade'!A30","v":"Fall 2015"},"Enter values in colored area"]
[]
["Item Number","Item","Mean","Standard\nDeviation","% Strongly \nAgree","%  \nAgree","%  \nNeither Agree or disagree","%  \nDisagree","%  Strongly Disagree","% No Response","EET Program Outcome"]
[41,"Gaining factual knowledge (terminology, methods, trends)",null,null,null,null,null,null,null,null,"EET-1"]
[42,"Learning fundamental principles, generalizations, \nor theories",null,null,null,null,null,null,null,null,"EET-1"]
[43,"Learning to apply course material to improve \nrational thinking",null,null,null,null,null,null,null,null,"EET-9"]
[44,"Developing specific competencies needed by \nprofessionals in this field",null,null,null,null,null,null,null,null,"EET-9"]
[45,"Learning how professionals in this field \ngain new knowledge",null,null,null,null,null,null,null,null,"EET-9"]
[46,"Creative capacities",null,null,null,null,null,null,null,null,"EET-6"]
[47,"Developingt a sense of personal responsibility \n(self-reliance, self-discipline)",null,null,null,null,null,null,null,null,"EET-10"]
[48,"Gaining a broader appreciation of \nintellectual-cultural activity ",null,null,null,null,null,null,null,null,"EET-9"]
[49,"Developing skill in expressing myself orally or in writing",null,null,null,null,null,null,null,null,"EET-7"]
[50,"Discovering the implications of course material for \nunderstanding myself ",null,null,null,null,null,null,null,null,"EET-9"]
[]
[null,"Course Average",{"$f":"AVERAGE(C6:C15)","v":{"$error":"#DIV/0!"}}]