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

{"sheet":"Registro voti","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},"Media",{"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},"Voto (lettera)","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":3},"GPA",{"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,"Nome scuola"]
[{"$nulls":3},"Nome interrogazione o compito"]
[{"$nulls":3},"Punti possibili"]
[null,"Nome insegnante"]
[null,"Classe/progetto",null,"Numero totale di interrogazioni e compiti:",{"$nulls":3},{"$f":"COUNTA(G6:AG6)","v":0}]
[null,"Anno/semestre/trimestre",null,"Totale punti possibili:",{"$nulls":3},{"$f":"SUM(G7:AG7)","v":0}]
[]
[null,"Nome studente","ID studente","Media","Voto (lettera)","GPA",{"$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,"Riepilogo classe",null,{"$f":"IF(OR(D12,D12>\"\"),D12,\"\")","v":"Media"},"Voto (lettera)","GPA","","","","","","","","","","","",{"$nulls":8},"","","","","","","",""]
[null,"Media",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,"Punteggio più alto",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,"Punteggio più basso",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":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]