{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["PHYS 260"],"read":"whole","date_system":"1900"}

{"sheet":"PHYS 260","index":0,"n_rows":19,"n_cols":15,"rows_kept":19}
["Category","Percentage",null,"Assignment","Score","Possible",null,"Assignment","Score","Possible",null,"Item","Score","Possible","Weighted"]
["HW",7,null,"Homework 1",null,100,null,"Quiz 1",null,1,null,"Office Hours",null,3,{"$f":"(M2/N2)*B6","v":0}]
["Quizzes",25,null,"Homework 2",null,100,null,"Quiz 2",{"$nulls":3},"Participation",null,1,{"$f":"(M3/N3)*B5","v":0}]
["Midterm",25,null,"Homework 3",null,100,null,"Quiz 3",{"$nulls":3},"Midterm Exam",null,100,{"$f":"(M4/N4)*B4","v":0}]
["Participation",5,null,"Homework 4",null,100,null,"Quiz 4",{"$nulls":3},"Final Exam",null,100,{"$f":"(M5/N5)*B7","v":0}]
["Office Hours",3,null,"Homework 5",null,100,null,"Quiz 5"]
["Final",35,null,"Homework 6",{"$nulls":3},"Quiz 6"]
[{"$nulls":3},"Homework 7",{"$nulls":3},"Quiz 7"]
[{"$nulls":3},"Homework 8",{"$nulls":3},"Quiz 8"]
[{"$nulls":3},"Homework 9",{"$nulls":3},"Quiz 9"]
[{"$nulls":3},"Homework 10",{"$nulls":3},"Quiz 10"]
[{"$nulls":3},"Homework 11",{"$nulls":3},"Quiz 11"]
[{"$nulls":3},"Homework 12",{"$nulls":3},"Quiz 12"]
[{"$nulls":3},"Homework 13"]
[{"$nulls":3},"Homework 14"]
[{"$nulls":3},"HOMEWORK TOTAL",{"$f":"SUM(E2:E15)","v":0},{"$f":"SUM(F2:F15)","v":500},null,"QUIZ TOTAL",{"$f":"SUM(I2:I13)","v":0},{"$f":"SUM(J2:J13)","v":1}]
[{"$nulls":3},"Percentage",null,{"$f":"E16/F16","v":{"v":0,"d":"0.0%"}},null,"Percentage",null,{"$f":"I16/J16","v":0}]
["Total Score:",{"$f":"F18+J18+O18","v":0},null,"Points",null,{"$f":"F17*B2","v":0},null,"Points",null,{"$f":"J17*B3","v":0},null,"Points",null,null,{"$f":"SUM(O2:O5)","v":0}]
["Letter Grade:",{"$f":"IF(B18>=94,\"A\",IF(B18>=88,\"A-\",IF(B18>=84,\"B+\",IF(B18>=81,\"B\",IF(B18>=77,\"B-\",IF(B18>=74,\"C+\",IF(B18>=70,\"C\",IF(B18>=66,\"C-\",IF(B18>=55,\"D\",\"F\")))))))))","v":"F"}]