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

{"sheet":"Cijferlijst","index":0,"n_rows":57,"n_cols":33,"rows_kept":57,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,1,6,2],[8,3,8,6],[9,3,9,6],[54,1,54,2],[55,1,55,2],[56,1,56,2]]}
[]
[null,null,"Gemiddelde",null,{"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%"}]
[null,null,"Beoordeling op basis van letters",null,"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[null,null,"GPA (Grade Point Average)",null,{"v":0,"d":"0.00"},0.67,{"v":1,"d":"1.00"},1.33,1.67,{"v":2,"d":"2.00"},2.33,2.67,{"v":3,"d":"3.00"},3.33,3.67,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"}]
[null,"Naam van uw school"]
[{"$nulls":3},"Naam van taak of toets"]
[{"$nulls":3},"Mogelijke cijfers"]
[null,"Naam van docent"]
[null,"Les/project",null,"Totaal aantal taken en toetsen:",{"$nulls":3},{"$f":"COUNTA(G6:AG6)","v":0}]
[null,"Jaar/semester/kwartaal",null,"Totale aantal mogelijke punten:",{"$nulls":3},{"$f":"SUM(G7:AG7)","v":0}]
[]
[null,"Naam van leerling","Studentnummer","Gemiddelde","Beoordeling op basis van letters","GPA (Grade Point Average)",{"$f":"IF(OR(G6,G6>\"\"),G6,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$nulls":3},{"$f":"(IF(SUM(G13:AG13),ROUND(SUM(G13:AG13)/$H$10,2),\"\"))","v":""},{"$f":"IF(D13<>\"\",HLOOKUP(D13,GradeTable,2),\"\")","v":""},{"$f":"IF(D13<>\"\",HLOOKUP(D13,GradeTable,3),\"\")","v":""}]
[{"$nulls":3},"",{"$f":"IF(D14<>\"\",HLOOKUP(D14,GradeTable,2),\"\")","v":""},{"$f":"IF(D14<>\"\",HLOOKUP(D14,GradeTable,3),\"\")","v":""}]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[]
[null,"Overzicht klas",null,{"$f":"IF(OR(D12,D12>\"\"),D12,\"\")","v":"Gemiddelde"},"Beoordeling op basis van letters","GPA (Grade Point Average)","","","","","","","","","","","",{"$nulls":8},"","","","","","","",""]
[null," Gemiddelde",null,{"$f":"IF(SUM(D13:D52),AVERAGE(D13:D52),\"\")","v":""},{"$f":"IF(D55<>\"\",HLOOKUP(D55,GradeTable,2),\"\")","v":""},{"$f":"IF(SUM(F13:F52),AVERAGE(F13:F52),\"\")","v":""},{"$f":"IF(SUM(G13:G52),AVERAGE(G13:G52),\"\")","v":""},{"$f":"IF(SUM(H13:H52),AVERAGE(H13:H52),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[null," Hoogste score",null,{"$f":"IF(SUM(D13:D52),MAX(D13:D52),\"\")","v":""},{"$f":"IF(D56<>\"\",HLOOKUP(D56,GradeTable,2),\"\")","v":""},{"$f":"IF(SUM(F13:F52),MAX(F13:F52),\"\")","v":""},{"$f":"IF(SUM(G13:G52),MAX(G13:G52),\"\")","v":""},{"$f":"IF(SUM(H13:H52),MAX(H13:H52),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[null," Laagste score",null,{"$f":"IF(SUM(D13:D52),MIN(D13:D52),\"\")","v":""},{"$f":"IF(D57<>\"\",HLOOKUP(D57,GradeTable,2),\"\")","v":""},{"$f":"IF(SUM(F13:F52),MIN(F13:F52),\"\")","v":""},{"$f":"IF(SUM(G13:G52),MIN(G13:G52),\"\")","v":""},{"$f":"IF(SUM(H13:H52),MIN(H13:H52),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]