{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["GRADE BOOK"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"GRADE BOOK","index":0,"n_rows":58,"n_cols":23,"rows_kept":58,"merged":[[53,1,53,5]]}
[]
[null,"[YOUR SCHOOL NAME]"]
[]
[]
[{"$nulls":6},"Score",{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.73,"d":"73%"},{"v":0.77,"d":"77%"},{"v":0.8,"d":"80%"},{"v":0.83,"d":"83%"},{"v":0.87,"d":"87%"},{"v":0.9,"d":"90%"},{"v":0.93,"d":"93%"},{"v":0.97,"d":"97%"}]
[{"$nulls":6},"Ltr Grade","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":6},"GPA",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"[Teacher Name]"]
[null,"[Class/Project]",{"$nulls":3},"Assignment or Test Name"]
[null,"[Year/Semester/Quarter]",{"$nulls":3},"Percentage (should total 100%)"]
[{"$nulls":5},{"$f":"\"Total percentage: \"&SUM(G10:BZ10)*100&\"%\"","v":"Total percentage: 0%"}]
[]
[null,"Student Name","Student ID","Score","Ltr Grade","GPA",{"$f":"IF(OR(G9,G9>\"\"),G9,\"\")","v":""},{"$f":"IF(OR(H9,H9>\"\"),H9,\"\")","v":""},"","","","","","","","","","","","","","",""]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(tblGrades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$10:$W$10,tblGrades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(tblGrades[[#This Row],[Score]]<>\"\",HLOOKUP(tblGrades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[]
[null,"Class Summary",null,"Score","Ltr Grade","GPA","","","","","","","","","","",""]
[null," Average",null,{"$f":"IFERROR(AVERAGE(tblGrades[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D56,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(AVERAGE(tblGrades[[#All],[GPA]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Highest Score",null,{"$f":"IFERROR(MAX(tblGrades[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D57,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(MAX(tblGrades[[#All],[GPA]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Lowest Score",null,{"$f":"IFERROR(MIN(tblGrades[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D58,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(MIN(tblGrades[[#All],[GPA]]),0)","v":0},"","","","","","","","","","","","","","","","",""]