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

{"sheet":"GRADEBOOK","index":0,"n_rows":10,"n_cols":21,"rows_kept":10,"merged":[[1,1,2,3],[1,4,1,6],[2,4,2,6],[3,4,3,6]]}
[]
[null,"[School Name]",null,null,"[Year/Semester/Quarter]",null,null,"Average",0,0.6,0.63,0.67,0.7,0.73,0.77,0.8,0.83,0.87,0.9,0.93,0.97]
[{"$nulls":4},"[Class/Project]",null,null,"Ltr Grade","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":4},"[Teacher Name]",null,null,"GPA",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[]
[null,"Student Name","Student ID","Average","Grade","GPA","Missing","Assignment 1","Assignment 2","Quiz 1","Quiz 2","Test 1","Assignment 3","Assignment 4","Quiz 3","Test 2","Column10","Column11","Column12","Column13","Column1"]
[null,"Ken Mallit",1234,{"$f":"IFERROR(AVERAGE(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers]))),\"\")","v":{"v":0.9166666666666666,"d":"0.92"}},{"$f":"LOOKUP(tblData[[#This Row],[Average]],GradeAvg,GradeLetter)","v":"A-"},{"$f":"LOOKUP(tblData[[#This Row],[Average]],GradeAvg,GradeGPA)","v":3.67},{"$f":"IF(COUNTA(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers])))=0,\"\",COUNTA(tblData[[#Headers],[Assignment 1]]:INDEX(tblData[#Headers],1,COUNTA(tblData[#Headers])))-COUNTA(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers]))))","v":11},0.88,0.95,0.92]
[null,"Robin Wakefield",5678,{"$f":"IFERROR(AVERAGE(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers]))),\"\")","v":{"v":0.7133333333333334,"d":"0.71"}},{"$f":"LOOKUP(tblData[[#This Row],[Average]],GradeAvg,GradeLetter)","v":"C-"},{"$f":"LOOKUP(tblData[[#This Row],[Average]],GradeAvg,GradeGPA)","v":1.67},{"$f":"IF(COUNTA(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers])))=0,\"\",COUNTA(tblData[[#Headers],[Assignment 1]]:INDEX(tblData[#Headers],1,COUNTA(tblData[#Headers])))-COUNTA(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers]))))","v":11},0.75,0.71,0.68]
[null,"Niraj Shah",9876,{"$f":"IFERROR(AVERAGE(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers]))),\"\")","v":{"v":0.7933333333333333,"d":"0.79"}},{"$f":"LOOKUP(tblData[[#This Row],[Average]],GradeAvg,GradeLetter)","v":"C+"},{"$f":"LOOKUP(tblData[[#This Row],[Average]],GradeAvg,GradeGPA)","v":2.33},{"$f":"IF(COUNTA(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers])))=0,\"\",COUNTA(tblData[[#Headers],[Assignment 1]]:INDEX(tblData[#Headers],1,COUNTA(tblData[#Headers])))-COUNTA(tblData[[#This Row],[Assignment 1]]:INDEX(tblData[],ROW(tblData[[#This Row],[Assignment 1]])-ROW(tblData[[#Headers],[Average]]),COUNTA(tblData[#Headers]))))","v":11},0.72,0.81,0.85]