{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Noten_1HJ","Noten_2HJ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Noten_1HJ","index":0,"n_rows":53,"n_cols":27,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,23,49,24],[5,11,5,12],[50,21,50,26],[2,19,2,20],[5,15,5,16],[5,17,5,18],[2,13,2,14],[5,25,5,26],[5,21,5,22],[5,23,5,24],[5,19,5,20],[2,15,2,18],[49,13,49,14],[49,15,49,16],[49,17,49,18],[49,19,49,20],[49,21,49,22],[49,25,49,26],[2,3,2,12],[0,0,0,1],[1,0,1,1],[2,0,2,1],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,13,5,14],[3,0,3,1],[5,3,5,4]]}
["Fach",null,"Ph"]
["Klasse",null,"10b"]
["Schriftlich:",null,0.35,"Faktoren mündlich =1!",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D4:O4)=1,\"Ok\",\"Fehler\")","v":"Ok"},null,"Faktoren schriftlich =1!",null,null,null,{"$f":"IF(SUM(P4:U4)=1,\"Ok\",\"Fehler\")","v":"Ok"}]
["Mündlich:",null,{"$f":"1-C3","v":0.65},null,1,null,0,null,0,null,0,null,0,null,0,null,1,null,0,null,0]
[]
[null,null,null,"MN",null,"MN",null,"MN",null,"MN ",null,"MN",null,"MN",null,"Arbeit Nr. 1",null,"Arbeit Nr. 2",null,"Arbeit Nr. 3",null,"Gesamt M",null,"Gesamt S",null,"Note 1HJ"]
["Nr.","Nachname","Vorname","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte"]
[]
[1,null,null,null,{"$f":"IF(ISBLANK(D9),\"\",Zensur_zu_Punkte(D9))","v":""},null,{"$f":"IF(ISBLANK(F9),\"\",Zensur_zu_Punkte(F9))","v":""},null,{"$f":"IF(ISBLANK(H9),\"\",Zensur_zu_Punkte(H9))","v":""},null,{"$f":"IF(ISBLANK(J9),\"\",Zensur_zu_Punkte(J9))","v":""},null,{"$f":"IF(ISBLANK(L9),\"\",Zensur_zu_Punkte(L9))","v":""},null,{"$f":"IF(ISBLANK(N9),\"\",Zensur_zu_Punkte(N9))","v":""},null,{"$f":"IF(ISBLANK(P9),\"\",Zensur_zu_Punkte(P9))","v":""},null,{"$f":"IF(ISBLANK(R9),\"\",Zensur_zu_Punkte(R9))","v":""},null,{"$f":"IF(ISBLANK(T9),\"\",Zensur_zu_Punkte(T9))","v":""},{"$f":"IF(ISNUMBER(W9),Punkte_zu_Zensur(W9),\"\")","v":""},{"$f":"IF(COUNT(E9,G9,I9,K9,M9,O9)>0,ROUND(SUMPRODUCT(D9:O9,$D$4:$O$4),0),\"\")","v":""},{"$f":"IF(ISNUMBER(Y9),Punkte_zu_Zensur(Y9),\"\")","v":""},{"$f":"IF(COUNT(Q9,S9,U9)>0,ROUND(SUMPRODUCT(P9:U9,$P$4:$U$4),0),\"\")","v":""},{"$f":"IF(ISNUMBER(AA9),Punkte_zu_Zensur(AA9),\"\")","v":""},{"$f":"IF(COUNT(W9,Y9)=2,ROUND(W9*$C$4+Y9*$C$3,0),\"\")","v":""}]
[{"$f":"1+A9","v":2},null,null,null,{"$f":"IF(ISBLANK(D10),\"\",Zensur_zu_Punkte(D10))","v":""},null,"",null,"",null,"",null,{"$f":"IF(ISBLANK(L10),\"\",Zensur_zu_Punkte(L10))","v":""},null,"",null,"",null,"",null,{"$f":"IF(ISBLANK(T10),\"\",Zensur_zu_Punkte(T10))","v":""},{"$f":"IF(ISNUMBER(W10),Punkte_zu_Zensur(W10),\"\")","v":""},{"$f":"IF(COUNT(E10,G10,I10,K10,M10,O10)>0,ROUND(SUMPRODUCT(D10:O10,$D$4:$O$4),0),\"\")","v":""},{"$f":"IF(ISNUMBER(Y10),Punkte_zu_Zensur(Y10),\"\")","v":""},{"$f":"IF(COUNT(Q10,S10,U10)>0,ROUND(SUMPRODUCT(P10:U10,$P$4:$U$4),0),\"\")","v":""},{"$f":"IF(ISNUMBER(AA10),Punkte_zu_Zensur(AA10),\"\")","v":""},""]
[{"$f":"1+A10","v":3},null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[4,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[5,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[6,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[7,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[8,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[9,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[10,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[11,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[12,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[13,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[14,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[15,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(ISBLANK(T23),\"\",Zensur_zu_Punkte(T23))","v":""},"","","","","",""]
[16,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[17,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[18,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[19,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[20,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[21,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[22,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[23,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[24,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[25,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[26,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[27,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[28,null,null,null,"",null,"",null,"",null,"",null,{"$f":"IF(ISBLANK(L36),\"\",Zensur_zu_Punkte(L36))","v":""},null,{"$f":"IF(ISBLANK(N36),\"\",Zensur_zu_Punkte(N36))","v":""},null,"",null,"",null,"",{"$f":"IF(ISNUMBER(W36),Punkte_zu_Zensur(W36),\"\")","v":""},"",{"$f":"IF(ISNUMBER(Y36),Punkte_zu_Zensur(Y36),\"\")","v":""},"",{"$f":"IF(ISNUMBER(AA36),Punkte_zu_Zensur(AA36),\"\")","v":""},""]
[29,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[30,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","",""]
[31,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[32,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[33,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[34,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[35,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[36,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[37,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[38,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[39,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[40,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","",""]
[]
[null,null,"Mittelwert:",{"$f":"IF(COUNT(E9:E48)=0,\"-\",AVERAGE(E9:E48))","v":"-"},null,{"$f":"IF(COUNT(G9:G48)=0,\"-\",AVERAGE(G9:G48))","v":"-"},null,{"$f":"IF(COUNT(I9:I48)=0,\"-\",AVERAGE(I9:I48))","v":"-"},null,{"$f":"IF(COUNT(K9:K48)=0,\"-\",AVERAGE(K9:K48))","v":"-"},null,{"$f":"IF(COUNT(M9:M48)=0,\"-\",AVERAGE(M9:M48))","v":"-"},null,{"$f":"IF(COUNT(O9:O48)=0,\"-\",AVERAGE(O9:O48))","v":"-"},null,{"$f":"IF(COUNT(Q9:Q48)=0,\"-\",AVERAGE(Q9:Q48))","v":"-"},null,{"$f":"IF(COUNT(S9:S48)=0,\"-\",AVERAGE(S9:S48))","v":"-"},null,{"$f":"IF(COUNT(U9:U48)=0,\"-\",AVERAGE(U9:U48))","v":"-"},null,{"$f":"IF(COUNT(W9:W48)=0,\"-\",AVERAGE(W9:W48))","v":"-"},null,{"$f":"IF(COUNT(Y9:Y48)=0,\"-\",AVERAGE(Y9:Y48))","v":"-"},null,{"$f":"IF(COUNT(AA9:AA48)=0,\"-\",AVERAGE(AA9:AA48))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notenspiegel Gesamtnoten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(FREQUENCY($AA$9:$AA$48,{0;3;6;9;12;15}),7-V52,1)","v":0},{"$f":"INDEX(FREQUENCY($AA$9:$AA$48,{0;3;6;9;12;15}),7-W52,1)","v":0},{"$f":"INDEX(FREQUENCY($AA$9:$AA$48,{0;3;6;9;12;15}),7-X52,1)","v":0},{"$f":"INDEX(FREQUENCY($AA$9:$AA$48,{0;3;6;9;12;15}),7-Y52,1)","v":0},{"$f":"INDEX(FREQUENCY($AA$9:$AA$48,{0;3;6;9;12;15}),7-Z52,1)","v":0},{"$f":"INDEX(FREQUENCY($AA$9:$AA$48,{0;3;6;9;12;15}),7-AA52,1)","v":0}]

{"sheet":"Noten_2HJ","index":1,"n_rows":53,"n_cols":31,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,25,50,30],[5,27,5,28],[5,29,5,30],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,25,5,26],[49,23,49,24],[49,25,49,26],[49,27,49,28],[49,29,49,30],[5,15,5,16],[5,17,5,18],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[2,19,2,20],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[2,3,2,12],[2,13,2,14],[2,15,2,18],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[49,15,49,16],[49,17,49,18],[49,19,49,20],[49,21,49,22]]}
[{"$f":"Noten_1HJ!A1","v":"Fach"},null,{"$f":"Noten_1HJ!C1","v":"Ph"}]
[{"$f":"Noten_1HJ!A2","v":"Klasse"},null,{"$f":"Noten_1HJ!C2","v":"10b"}]
[{"$f":"Noten_1HJ!A3","v":"Schriftlich:"},null,0.5,"Faktoren mündlich =1!",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D4:O4)=1,\"Ok\",\"Fehler\")","v":"Ok"},null,"Faktoren schriftlich =1!",null,null,null,{"$f":"IF(SUM(P4:U4)=1,\"Ok\",\"Fehler\")","v":"Ok"}]
[{"$f":"Noten_1HJ!A4","v":"Mündlich:"},null,{"$f":"1-C3","v":0.5},null,1,null,0,null,0,null,0,null,0,null,null,null,1,null,null,null,0]
["Anteil 2.HJ",null,0.5]
[null,null,null,"MN",null,"MN",null,"MN",null,"MN ",null,"MN",null,"MN",null,"Arbeit Nr. 1",null,"Arbeit Nr. 2",null,"Arbeit Nr. 3",null,"Gesamt M",null,"Gesamt S",null,"Note 2HJ",null,"Note 1HJ",null,"Gesamtnote"]
["Nr.","Nachname","Vorname","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte","Note","Punkte"]
[]
[1,{"$f":"IF(ISBLANK(Noten_1HJ!B9),\"\",Noten_1HJ!B9)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C9),\"\",Noten_1HJ!C9)","v":""},null,{"$f":"IF(ISBLANK(D9),\"\",Zensur_zu_Punkte(D9))","v":""},null,{"$f":"IF(ISBLANK(F9),\"\",Zensur_zu_Punkte(F9))","v":""},null,{"$f":"IF(ISBLANK(H9),\"\",Zensur_zu_Punkte(H9))","v":""},null,{"$f":"IF(ISBLANK(J9),\"\",Zensur_zu_Punkte(J9))","v":""},null,{"$f":"IF(ISBLANK(L9),\"\",Zensur_zu_Punkte(L9))","v":""},null,{"$f":"IF(ISBLANK(N9),\"\",Zensur_zu_Punkte(N9))","v":""},null,{"$f":"IF(ISBLANK(P9),\"\",Zensur_zu_Punkte(P9))","v":""},null,{"$f":"IF(ISBLANK(R9),\"\",Zensur_zu_Punkte(R9))","v":""},null,{"$f":"IF(ISBLANK(T9),\"\",Zensur_zu_Punkte(T9))","v":""},{"$f":"IF(ISNUMBER(W9),Punkte_zu_Zensur(W9),\"\")","v":""},{"$f":"IF(COUNT(E9,G9,I9,K9,M9,O9)>0,ROUND(SUMPRODUCT(D9:O9,$D$4:$O$4),0),\"\")","v":""},{"$f":"IF(ISNUMBER(Y9),Punkte_zu_Zensur(Y9),\"\")","v":""},{"$f":"IF(COUNT(Q9,S9,U9)>0,ROUND(SUMPRODUCT(P9:U9,$P$4:$U$4),0),\"\")","v":""},{"$f":"IF(ISNUMBER(AA9),Punkte_zu_Zensur(AA9),\"\")","v":""},{"$f":"IF(COUNT(W9,Y9)=2,ROUND(W9*$C$4+Y9*$C$3,0),\"\")","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!Z9),\"\",Noten_1HJ!Z9)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA9),\"\",Noten_1HJ!AA9)","v":""},{"$f":"IF(ISNUMBER(AE9),Punkte_zu_Zensur(AE9),\"\")","v":""},{"$f":"IF(COUNT(AC9,AA9) = 2, ROUND(AA9*$C$5+AC9*(1-$C$5),0),\"\")","v":""}]
[{"$f":"1+A9","v":2},{"$f":"IF(ISBLANK(Noten_1HJ!B10),\"\",Noten_1HJ!B10)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C10),\"\",Noten_1HJ!C10)","v":""},null,{"$f":"IF(ISBLANK(D10),\"\",Zensur_zu_Punkte(D10))","v":""},null,"",null,"",null,"",null,{"$f":"IF(ISBLANK(L10),\"\",Zensur_zu_Punkte(L10))","v":""},null,"",null,"",null,"",null,{"$f":"IF(ISBLANK(T10),\"\",Zensur_zu_Punkte(T10))","v":""},{"$f":"IF(ISNUMBER(W10),Punkte_zu_Zensur(W10),\"\")","v":""},{"$f":"IF(COUNT(E10,G10,I10,K10,M10,O10)>0,ROUND(SUMPRODUCT(D10:O10,$D$4:$O$4),0),\"\")","v":""},{"$f":"IF(ISNUMBER(Y10),Punkte_zu_Zensur(Y10),\"\")","v":""},{"$f":"IF(COUNT(Q10,S10,U10)>0,ROUND(SUMPRODUCT(P10:U10,$P$4:$U$4),0),\"\")","v":""},{"$f":"IF(ISNUMBER(AA10),Punkte_zu_Zensur(AA10),\"\")","v":""},"",{"$f":"IF(ISBLANK(Noten_1HJ!Z10),\"\",Noten_1HJ!Z10)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA10),\"\",Noten_1HJ!AA10)","v":""},{"$f":"IF(ISNUMBER(AE10),Punkte_zu_Zensur(AE10),\"\")","v":""},{"$f":"IF(COUNT(AC10,AA10) = 2, ROUND(AA10*$C$5+AC10*(1-$C$5),0),\"\")","v":""}]
[{"$f":"1+A10","v":3},{"$f":"IF(ISBLANK(Noten_1HJ!B11),\"\",Noten_1HJ!B11)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C11),\"\",Noten_1HJ!C11)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z11),\"\",Noten_1HJ!Z11)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA11),\"\",Noten_1HJ!AA11)","v":""},"",""]
[4,{"$f":"IF(ISBLANK(Noten_1HJ!B12),\"\",Noten_1HJ!B12)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C12),\"\",Noten_1HJ!C12)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z12),\"\",Noten_1HJ!Z12)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA12),\"\",Noten_1HJ!AA12)","v":""},"",""]
[5,{"$f":"IF(ISBLANK(Noten_1HJ!B13),\"\",Noten_1HJ!B13)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C13),\"\",Noten_1HJ!C13)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z13),\"\",Noten_1HJ!Z13)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA13),\"\",Noten_1HJ!AA13)","v":""},"",""]
[6,{"$f":"IF(ISBLANK(Noten_1HJ!B14),\"\",Noten_1HJ!B14)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C14),\"\",Noten_1HJ!C14)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z14),\"\",Noten_1HJ!Z14)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA14),\"\",Noten_1HJ!AA14)","v":""},"",""]
[7,{"$f":"IF(ISBLANK(Noten_1HJ!B15),\"\",Noten_1HJ!B15)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C15),\"\",Noten_1HJ!C15)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z15),\"\",Noten_1HJ!Z15)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA15),\"\",Noten_1HJ!AA15)","v":""},"",""]
[8,{"$f":"IF(ISBLANK(Noten_1HJ!B16),\"\",Noten_1HJ!B16)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C16),\"\",Noten_1HJ!C16)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z16),\"\",Noten_1HJ!Z16)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA16),\"\",Noten_1HJ!AA16)","v":""},"",""]
[9,{"$f":"IF(ISBLANK(Noten_1HJ!B17),\"\",Noten_1HJ!B17)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C17),\"\",Noten_1HJ!C17)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z17),\"\",Noten_1HJ!Z17)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA17),\"\",Noten_1HJ!AA17)","v":""},"",""]
[10,{"$f":"IF(ISBLANK(Noten_1HJ!B18),\"\",Noten_1HJ!B18)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C18),\"\",Noten_1HJ!C18)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z18),\"\",Noten_1HJ!Z18)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA18),\"\",Noten_1HJ!AA18)","v":""},"",""]
[11,{"$f":"IF(ISBLANK(Noten_1HJ!B19),\"\",Noten_1HJ!B19)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C19),\"\",Noten_1HJ!C19)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z19),\"\",Noten_1HJ!Z19)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA19),\"\",Noten_1HJ!AA19)","v":""},"",""]
[12,{"$f":"IF(ISBLANK(Noten_1HJ!B20),\"\",Noten_1HJ!B20)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C20),\"\",Noten_1HJ!C20)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z20),\"\",Noten_1HJ!Z20)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA20),\"\",Noten_1HJ!AA20)","v":""},"",""]
[13,{"$f":"IF(ISBLANK(Noten_1HJ!B21),\"\",Noten_1HJ!B21)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C21),\"\",Noten_1HJ!C21)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z21),\"\",Noten_1HJ!Z21)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA21),\"\",Noten_1HJ!AA21)","v":""},"",""]
[14,{"$f":"IF(ISBLANK(Noten_1HJ!B22),\"\",Noten_1HJ!B22)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C22),\"\",Noten_1HJ!C22)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z22),\"\",Noten_1HJ!Z22)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA22),\"\",Noten_1HJ!AA22)","v":""},"",""]
[15,{"$f":"IF(ISBLANK(Noten_1HJ!B23),\"\",Noten_1HJ!B23)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C23),\"\",Noten_1HJ!C23)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z23),\"\",Noten_1HJ!Z23)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA23),\"\",Noten_1HJ!AA23)","v":""},"",""]
[16,{"$f":"IF(ISBLANK(Noten_1HJ!B24),\"\",Noten_1HJ!B24)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C24),\"\",Noten_1HJ!C24)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z24),\"\",Noten_1HJ!Z24)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA24),\"\",Noten_1HJ!AA24)","v":""},"",""]
[17,{"$f":"IF(ISBLANK(Noten_1HJ!B25),\"\",Noten_1HJ!B25)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C25),\"\",Noten_1HJ!C25)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z25),\"\",Noten_1HJ!Z25)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA25),\"\",Noten_1HJ!AA25)","v":""},"",""]
[18,{"$f":"IF(ISBLANK(Noten_1HJ!B26),\"\",Noten_1HJ!B26)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C26),\"\",Noten_1HJ!C26)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z26),\"\",Noten_1HJ!Z26)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA26),\"\",Noten_1HJ!AA26)","v":""},"",""]
[19,{"$f":"IF(ISBLANK(Noten_1HJ!B27),\"\",Noten_1HJ!B27)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C27),\"\",Noten_1HJ!C27)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z27),\"\",Noten_1HJ!Z27)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA27),\"\",Noten_1HJ!AA27)","v":""},"",""]
[20,{"$f":"IF(ISBLANK(Noten_1HJ!B28),\"\",Noten_1HJ!B28)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C28),\"\",Noten_1HJ!C28)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z28),\"\",Noten_1HJ!Z28)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA28),\"\",Noten_1HJ!AA28)","v":""},"",""]
[21,{"$f":"IF(ISBLANK(Noten_1HJ!B29),\"\",Noten_1HJ!B29)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C29),\"\",Noten_1HJ!C29)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z29),\"\",Noten_1HJ!Z29)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA29),\"\",Noten_1HJ!AA29)","v":""},"",""]
[22,{"$f":"IF(ISBLANK(Noten_1HJ!B30),\"\",Noten_1HJ!B30)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C30),\"\",Noten_1HJ!C30)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z30),\"\",Noten_1HJ!Z30)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA30),\"\",Noten_1HJ!AA30)","v":""},"",""]
[23,{"$f":"IF(ISBLANK(Noten_1HJ!B31),\"\",Noten_1HJ!B31)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C31),\"\",Noten_1HJ!C31)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z31),\"\",Noten_1HJ!Z31)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA31),\"\",Noten_1HJ!AA31)","v":""},"",""]
[24,{"$f":"IF(ISBLANK(Noten_1HJ!B32),\"\",Noten_1HJ!B32)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C32),\"\",Noten_1HJ!C32)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z32),\"\",Noten_1HJ!Z32)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA32),\"\",Noten_1HJ!AA32)","v":""},"",""]
[25,{"$f":"IF(ISBLANK(Noten_1HJ!B33),\"\",Noten_1HJ!B33)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C33),\"\",Noten_1HJ!C33)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z33),\"\",Noten_1HJ!Z33)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA33),\"\",Noten_1HJ!AA33)","v":""},"",""]
[26,{"$f":"IF(ISBLANK(Noten_1HJ!B34),\"\",Noten_1HJ!B34)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C34),\"\",Noten_1HJ!C34)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z34),\"\",Noten_1HJ!Z34)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA34),\"\",Noten_1HJ!AA34)","v":""},"",""]
[27,{"$f":"IF(ISBLANK(Noten_1HJ!B35),\"\",Noten_1HJ!B35)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C35),\"\",Noten_1HJ!C35)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z35),\"\",Noten_1HJ!Z35)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA35),\"\",Noten_1HJ!AA35)","v":""},"",""]
[28,{"$f":"IF(ISBLANK(Noten_1HJ!B36),\"\",Noten_1HJ!B36)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C36),\"\",Noten_1HJ!C36)","v":""},null,"",null,"",null,"",null,"",null,{"$f":"IF(ISBLANK(L36),\"\",Zensur_zu_Punkte(L36))","v":""},null,{"$f":"IF(ISBLANK(N36),\"\",Zensur_zu_Punkte(N36))","v":""},null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z36),\"\",Noten_1HJ!Z36)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA36),\"\",Noten_1HJ!AA36)","v":""},"",""]
[29,{"$f":"IF(ISBLANK(Noten_1HJ!B37),\"\",Noten_1HJ!B37)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C37),\"\",Noten_1HJ!C37)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z37),\"\",Noten_1HJ!Z37)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA37),\"\",Noten_1HJ!AA37)","v":""},"",""]
[30,{"$f":"IF(ISBLANK(Noten_1HJ!B38),\"\",Noten_1HJ!B38)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C38),\"\",Noten_1HJ!C38)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"","","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z38),\"\",Noten_1HJ!Z38)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA38),\"\",Noten_1HJ!AA38)","v":""},"",""]
[31,{"$f":"IF(ISBLANK(Noten_1HJ!B39),\"\",Noten_1HJ!B39)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C39),\"\",Noten_1HJ!C39)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z39),\"\",Noten_1HJ!Z39)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA39),\"\",Noten_1HJ!AA39)","v":""},"",""]
[32,{"$f":"IF(ISBLANK(Noten_1HJ!B40),\"\",Noten_1HJ!B40)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C40),\"\",Noten_1HJ!C40)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z40),\"\",Noten_1HJ!Z40)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA40),\"\",Noten_1HJ!AA40)","v":""},"",""]
[33,{"$f":"IF(ISBLANK(Noten_1HJ!B41),\"\",Noten_1HJ!B41)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C41),\"\",Noten_1HJ!C41)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z41),\"\",Noten_1HJ!Z41)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA41),\"\",Noten_1HJ!AA41)","v":""},"",""]
[34,{"$f":"IF(ISBLANK(Noten_1HJ!B42),\"\",Noten_1HJ!B42)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C42),\"\",Noten_1HJ!C42)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z42),\"\",Noten_1HJ!Z42)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA42),\"\",Noten_1HJ!AA42)","v":""},"",""]
[35,{"$f":"IF(ISBLANK(Noten_1HJ!B43),\"\",Noten_1HJ!B43)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C43),\"\",Noten_1HJ!C43)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z43),\"\",Noten_1HJ!Z43)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA43),\"\",Noten_1HJ!AA43)","v":""},"",""]
[36,{"$f":"IF(ISBLANK(Noten_1HJ!B44),\"\",Noten_1HJ!B44)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C44),\"\",Noten_1HJ!C44)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z44),\"\",Noten_1HJ!Z44)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA44),\"\",Noten_1HJ!AA44)","v":""},"",""]
[37,{"$f":"IF(ISBLANK(Noten_1HJ!B45),\"\",Noten_1HJ!B45)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C45),\"\",Noten_1HJ!C45)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z45),\"\",Noten_1HJ!Z45)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA45),\"\",Noten_1HJ!AA45)","v":""},"",""]
[38,{"$f":"IF(ISBLANK(Noten_1HJ!B46),\"\",Noten_1HJ!B46)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C46),\"\",Noten_1HJ!C46)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z46),\"\",Noten_1HJ!Z46)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA46),\"\",Noten_1HJ!AA46)","v":""},"",""]
[39,{"$f":"IF(ISBLANK(Noten_1HJ!B47),\"\",Noten_1HJ!B47)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C47),\"\",Noten_1HJ!C47)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z47),\"\",Noten_1HJ!Z47)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA47),\"\",Noten_1HJ!AA47)","v":""},"",""]
[40,{"$f":"IF(ISBLANK(Noten_1HJ!B48),\"\",Noten_1HJ!B48)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!C48),\"\",Noten_1HJ!C48)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,"","","","","","",{"$f":"IF(ISBLANK(Noten_1HJ!Z48),\"\",Noten_1HJ!Z48)","v":""},{"$f":"IF(ISBLANK(Noten_1HJ!AA48),\"\",Noten_1HJ!AA48)","v":""},"",""]
[]
[null,null,"Mittelwert:",{"$f":"IF(COUNT(E9:E48)=0,\"-\",AVERAGE(E9:E48))","v":"-"},null,{"$f":"IF(COUNT(G9:G48)=0,\"-\",AVERAGE(G9:G48))","v":"-"},null,{"$f":"IF(COUNT(I9:I48)=0,\"-\",AVERAGE(I9:I48))","v":"-"},null,{"$f":"IF(COUNT(K9:K48)=0,\"-\",AVERAGE(K9:K48))","v":"-"},null,{"$f":"IF(COUNT(M9:M48)=0,\"-\",AVERAGE(M9:M48))","v":"-"},null,{"$f":"IF(COUNT(O9:O48)=0,\"-\",AVERAGE(O9:O48))","v":"-"},null,{"$f":"IF(COUNT(Q9:Q48)=0,\"-\",AVERAGE(Q9:Q48))","v":"-"},null,{"$f":"IF(COUNT(S9:S48)=0,\"-\",AVERAGE(S9:S48))","v":"-"},null,{"$f":"IF(COUNT(U9:U48)=0,\"-\",AVERAGE(U9:U48))","v":"-"},null,{"$f":"IF(COUNT(W9:W48)=0,\"-\",AVERAGE(W9:W48))","v":"-"},null,{"$f":"IF(COUNT(Y9:Y48)=0,\"-\",AVERAGE(Y9:Y48))","v":"-"},null,{"$f":"IF(COUNT(AA9:AA48)=0,\"-\",AVERAGE(AA9:AA48))","v":"-"},null,{"$f":"IF(COUNT(AC9:AC48)=0,\"-\",AVERAGE(AC9:AC48))","v":"-"},null,{"$f":"IF(COUNT(AE9:AE48)=0,\"-\",AVERAGE(AE9:AE48))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notenspiegel Gesamtnoten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(FREQUENCY($AE$9:$AE$48,{0;3;6;9;12;15}),7-Z52,1)","v":0},{"$f":"INDEX(FREQUENCY($AE$9:$AE$48,{0;3;6;9;12;15}),7-AA52,1)","v":0},{"$f":"INDEX(FREQUENCY($AE$9:$AE$48,{0;3;6;9;12;15}),7-AB52,1)","v":0},{"$f":"INDEX(FREQUENCY($AE$9:$AE$48,{0;3;6;9;12;15}),7-AC52,1)","v":0},{"$f":"INDEX(FREQUENCY($AE$9:$AE$48,{0;3;6;9;12;15}),7-AD52,1)","v":0},{"$f":"INDEX(FREQUENCY($AE$9:$AE$48,{0;3;6;9;12;15}),7-AE52,1)","v":0}]