{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["MK_Abitur"],"read":"whole","date_system":"1900"}

{"sheet":"MK_Abitur","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"merged":[[1,1,2,1],[1,2,2,2],[1,4,1,6],[1,7,1,9],[1,10,1,11],[31,0,31,2]]}
[]
[null,"PH Na2","Abitur 2010",null,"Jahrgang 12",null,null,"Jahrgang 13",null,null,"Qualifikationsphase"]
[{"$nulls":9},"Vorabitur"]
["Nr.","Nachname","Vorname","Schriftliches Abitur","Klausur Nr.1","Klausur Nr.2","Klausur Nr.3","Klausur Nr.4","Klausur Nr.5","Klausur Nr.6","Summe","Durchschnitt"]
[]
[1,{"$nulls":9},{"$f":"IF(COUNT(E6:J6)>0,SUM(E6:J6),\"-\")","v":"-"},{"$f":"IF(COUNT(E6:J6) = 6, ROUND(AVERAGE(E6:J6),1),\"-\")","v":"-"}]
[{"$f":"1+A6","v":2},{"$nulls":9},{"$f":"IF(COUNT(E7:J7)>0,SUM(E7:J7),\"-\")","v":"-"},{"$f":"IF(COUNT(E7:J7) = 6, ROUND(AVERAGE(E7:J7),1),\"-\")","v":"-"}]
[{"$f":"1+A7","v":3},{"$nulls":9},"-","-"]
[4,{"$nulls":9},"-","-"]
[5,{"$nulls":9},"-","-"]
[6,{"$nulls":9},"-","-"]
[7,{"$nulls":9},"-","-"]
[8,{"$nulls":9},"-","-"]
[9,{"$nulls":9},"-","-"]
[10,{"$nulls":9},"-","-"]
[11,{"$nulls":9},"-","-"]
[12,{"$nulls":9},"-","-"]
[13,{"$nulls":9},"-","-"]
[14,{"$nulls":9},"-","-"]
[15,{"$nulls":9},"-","-"]
[16,{"$nulls":9},"-","-"]
[17,{"$nulls":9},"-","-"]
[18,{"$nulls":9},"-","-"]
[19,{"$nulls":9},"-","-"]
[20,{"$nulls":9},"-","-"]
[21,{"$nulls":9},"-","-"]
[22,{"$nulls":9},"-","-"]
[23,{"$nulls":9},"-","-"]
[24,{"$nulls":9},"-","-"]
[25,{"$nulls":9},"-","-"]
[26,{"$nulls":9},"-","-"]
["Durchschnittsnoten:",null,null,{"$f":"IF(COUNT(D6:D31)>0,ROUND(AVERAGE(D6:D31),1),\"-\")","v":"-"},{"$nulls":5},{"$f":"IF(COUNT(J6:J31)>0,ROUND(AVERAGE(J6:J31),1),\"-\")","v":"-"},null,{"$f":"IF(COUNT(L6:L31)>0,ROUND(AVERAGE(L6:L31),1),\"-\")","v":"-"}]