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

{"sheet":"Betygsbok","index":0,"n_rows":57,"n_cols":33,"rows_kept":57,"merged":[[4,1,6,2],[8,3,8,6],[9,3,9,6],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2]]}
[]
[{"$nulls":3},"Genomsnitt",{"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":3},"Betyg","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":3},"Medelbetyg",{"v":1,"d":"1.00"},{"v":67,"d":"67.00"},{"v":100,"d":"100.00"},{"v":133,"d":"133.00"},{"v":167,"d":"167.00"},{"v":200,"d":"200.00"},{"v":233,"d":"233.00"},{"v":267,"d":"267.00"},{"v":300,"d":"300.00"},{"v":333,"d":"333.00"},{"v":367,"d":"367.00"},{"v":400,"d":"400.00"},{"v":400,"d":"400.00"}]
[null,"Skolans namn"]
[{"$nulls":3},"Namn på uppgift eller prov"]
[{"$nulls":3},"Möjliga poäng"]
[null,"Lärarens namn"]
[null,"Klass/projekt",null,"Totalt antal uppgifter och prov:",{"$nulls":3},{"$f":"COUNTA(G6:AG6)","v":0}]
[null,"Läsår/termin/kvartal",null,"Totalt antal möjliga poäng:",{"$nulls":3},{"$f":"SUM(G7:AG7)","v":0}]
[]
[null,"Elevens namn","Elev-ID","Genomsnitt","Betyg","Medelbetyg",{"$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},"","",""]
[{"$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,"Sammanfattning för klassen",null,{"$f":"IF(OR(D12,D12>\"\"),D12,\"\")","v":"Genomsnitt"},"Betyg","Medelbetyg","","","","","","","","","","","",{"$nulls":8},{"$f":"IF(OR(Z12,Z12>\"\"),Z12,\"\")","v":""},"","","","","","",""]
[null,"Genomsnitt",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":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null," Högsta poäng",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":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null," Lägsta poäng",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":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]