{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Übersicht","Gesamtnote","Notenskala","Semester 1","MA 1","Wdh 1","Heft 1","Test 1.1","Test 1.2","Semester 2","MA 2","Wdh 2","Heft 2","Test 2.1","Test 2.2"],"not_rendered":{"charts":0,"images":1,"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":"Übersicht","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,0,28,7],[29,0,29,7],[30,0,30,7],[31,0,31,7],[32,0,32,7]]}
["Generelles",null,"Semester 1",null,"Semester2"]
[]
["Gesamtnote",null,"Übersicht",null,"Übersicht",null,"andreas.leimer@gmx.at"]
[]
["Notenskala",null,"Mitarbeit",null,"Mitarbeit",null,"CC-Lizenz BY ND"]
[]
[null,null,"Wiederholungen",null,"Wiederholungen"]
[]
[null,null,"Heftführung",null,"Heftführung"]
[]
[null,null,"Test 1",null,"Test 3",null,"!Achtung!"]
[]
[null,null,"Test 2",null,"Test 4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Anleitung"]
[]
[]
[]
[]
["Diese Beurteilungsdatei habe ich für das Unterrichtsfach GW (MS) erstellt. Änderbare Bereiche sind in ORANGE markiert. Wenn du einen Button (links oben) anklickst, kannst du schnell zwischen den Mappen wechseln. Der Löschen-Button setzt alle ausfüllbaren Felder zurück."]
["Unter \"Notenskala\" kannst du die Ziffernnotenskala der ganzen Beurteilungsdatei ändern. Ebenso kannst du die Gewichtung der einzelnen Bereiche anpassen. ACHTUNG: Diese muss immer insgesamt 100% ergeben."]
[" Falls du eine Unterschiedliche Anzahl an Tests machst, gibt es dafür eine eigene Gewichtungsmöglichkeit die anpassbar ist. Diese findest du in den Semesterübersichten. Falls ein Schüler nur den zweiten Test macht, wird dieser Wert automatisch zum Test 1 übertragen. Die Prozentwerte bleiben richtig. Falls du gar keinen Test machst, musst du in den jeweiligen Mappen nichts eintragen. Die Tests sind in verschiedene Teilbereiche (A,B,C,...) gegliedert. "]
["Die Mitarbeitsbenotung kannst du über ein Drop-down Menü auswählen (K=Krank).  Achte darauf, dass du immer ein Datum eingibst, wann die Mitarbeit bewertet wurde. Sonst wird sie nicht gezählt. (überprüfe \"Stunden bis jetzt\")"]
["Zusätzlich zur ausgerechneten Note, gibt es noch die Möglichkeit eine eigene Note zu vermerken (Bei Zwischennoten). Diese zählen nicht zur Berechnung dazu. (Lehrernoten)        "]

{"sheet":"Gesamtnote","index":1,"n_rows":51,"n_cols":32,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,"Nr.","Name","J Lehrer","Note","h","i","Gesamt","S1 Lehrer","S2 Lehrer","S1","S2","h","i",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B4","v":"Nicht Beurteilt"},{"$f":"Notenskala!C4","v":"K/NB"},{"$f":"Notenskala!D4","v":"K/NB"},{"$f":"Notenskala!E4","v":"K/NB"}]
[null,1,"Schüler 1",null,{"$f":"IFERROR(IF(H3=0,\"\",VLOOKUP(H3,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},{"$f":"IF(O3<2%,\"h\",IF(O3<4%,\"k\",\" \"))","v":"h"},{"$f":"IF(P3<2%,\"i\",IF(P3<4%,\"m\",\" \"))","v":"i"},{"$f":"SUMPRODUCT(K3:L3,$K$29:$L$29)/SUM($K$29:$L$29)","v":0.39011341783216785},{"$f":"IF('Semester 1'!D3=0,\"\",'Semester 1'!D3)","v":2},{"$f":"IF('Semester 2'!D3=0,\"\",'Semester 1'!E3)","v":""},{"$f":"'Semester 1'!H3","v":0.86691870629370626},{"$f":"IFERROR('Semester 2'!H3,\"\")","v":0},{"$f":"IFERROR(IF(E3=1,\"\",IF(E3=2,Notenskala!$D$9-H3,IF(E3=3,Notenskala!$D$8-H3,IF(E3=4,Notenskala!$D$7-H3,IF(E3=5,Notenskala!$D$6-H3))))),\"\")","v":0.10988658216783215},{"$f":"IFERROR(IF(E3=1,H3-Notenskala!$C$8,IF(E3=2,H3-Notenskala!$C$7,IF(E3=3,H3-Notenskala!$C$6,IF(E3=4,H3-Notenskala!$C$5,IF(E3=5,\"\"))))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B5","v":"Nicht Genügend"},{"$f":"Notenskala!C5","v":0.49990000000000001},{"$f":"Notenskala!D5","v":0},{"$f":"Notenskala!E5","v":5}]
[null,2,"Schüler 2",null,{"$f":"IFERROR(IF(H4=0,\"\",VLOOKUP(H4,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.44043750000000004,{"$f":"IF('Semester 1'!D4=0,\"\",'Semester 1'!D4)","v":1},{"$f":"IF('Semester 2'!D4=0,\"\",'Semester 1'!E4)","v":""},{"$f":"'Semester 1'!H4","v":0.97875000000000001},{"$f":"IFERROR('Semester 2'!H4,\"\")","v":0},{"$f":"IFERROR(IF(E4=1,\"\",IF(E4=2,Notenskala!$D$9-H4,IF(E4=3,Notenskala!$D$8-H4,IF(E4=4,Notenskala!$D$7-H4,IF(E4=5,Notenskala!$D$6-H4))))),\"\")","v":5.9562499999999963E-2},{"$f":"IFERROR(IF(E4=1,H4-Notenskala!$C$8,IF(E4=2,H4-Notenskala!$C$7,IF(E4=3,H4-Notenskala!$C$6,IF(E4=4,H4-Notenskala!$C$5,IF(E4=5,\"\"))))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B6","v":"Genügend"},{"$f":"Notenskala!C6","v":0.64990000000000003},{"$f":"Notenskala!D6","v":0.5},{"$f":"Notenskala!E6","v":4}]
[null,3,"Schüler 3",null,{"$f":"IFERROR(IF(H5=0,\"\",VLOOKUP(H5,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.35964204545454542,{"$f":"IF('Semester 1'!D5=0,\"\",'Semester 1'!D5)","v":2},{"$f":"IF('Semester 2'!D5=0,\"\",'Semester 1'!E5)","v":""},{"$f":"'Semester 1'!H5","v":0.79920454545454533},{"$f":"IFERROR('Semester 2'!H5,\"\")","v":0},{"$f":"IFERROR(IF(E5=1,\"\",IF(E5=2,Notenskala!$D$9-H5,IF(E5=3,Notenskala!$D$8-H5,IF(E5=4,Notenskala!$D$7-H5,IF(E5=5,Notenskala!$D$6-H5))))),\"\")","v":0.14035795454545458},{"$f":"IFERROR(IF(E5=1,H5-Notenskala!$C$8,IF(E5=2,H5-Notenskala!$C$7,IF(E5=3,H5-Notenskala!$C$6,IF(E5=4,H5-Notenskala!$C$5,IF(E5=5,\"\"))))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B7","v":"Befriedigend"},{"$f":"Notenskala!C7","v":0.80990000000000006},{"$f":"Notenskala!D7","v":0.65},{"$f":"Notenskala!E7","v":3}]
[null,4,"Schüler 4",null,{"$f":"IFERROR(IF(H6=0,\"\",VLOOKUP(H6,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.42862500000000003,{"$f":"IF('Semester 1'!D6=0,\"\",'Semester 1'!D6)","v":1},{"$f":"IF('Semester 2'!D6=0,\"\",'Semester 1'!E6)","v":""},{"$f":"'Semester 1'!H6","v":0.95250000000000001},{"$f":"IFERROR('Semester 2'!H6,\"\")","v":0},{"$f":"IFERROR(IF(E6=1,\"\",IF(E6=2,Notenskala!$D$9-H6,IF(E6=3,Notenskala!$D$8-H6,IF(E6=4,Notenskala!$D$7-H6,IF(E6=5,Notenskala!$D$6-H6))))),\"\")","v":7.1374999999999966E-2},{"$f":"IFERROR(IF(E6=1,H6-Notenskala!$C$8,IF(E6=2,H6-Notenskala!$C$7,IF(E6=3,H6-Notenskala!$C$6,IF(E6=4,H6-Notenskala!$C$5,IF(E6=5,\"\"))))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B8","v":"Gut"},{"$f":"Notenskala!C8","v":0.90990000000000004},{"$f":"Notenskala!D8","v":0.81},{"$f":"Notenskala!E8","v":2}]
[null,5,"Schüler 5",null,{"$f":"IFERROR(IF(H7=0,\"\",VLOOKUP(H7,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.37517668269230769,{"$f":"IF('Semester 1'!D7=0,\"\",'Semester 1'!D7)","v":2},{"$f":"IF('Semester 2'!D7=0,\"\",'Semester 1'!E7)","v":""},{"$f":"'Semester 1'!H7","v":0.83372596153846157},{"$f":"IFERROR('Semester 2'!H7,\"\")","v":0},{"$f":"IFERROR(IF(E7=1,\"\",IF(E7=2,Notenskala!$D$9-H7,IF(E7=3,Notenskala!$D$8-H7,IF(E7=4,Notenskala!$D$7-H7,IF(E7=5,Notenskala!$D$6-H7))))),\"\")","v":0.12482331730769231},{"$f":"IFERROR(IF(E7=1,H7-Notenskala!$C$8,IF(E7=2,H7-Notenskala!$C$7,IF(E7=3,H7-Notenskala!$C$6,IF(E7=4,H7-Notenskala!$C$5,IF(E7=5,\"\"))))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B9","v":"Sehr Gut"},{"$f":"Notenskala!C9","v":1},{"$f":"Notenskala!D9","v":0.91},{"$f":"Notenskala!E9","v":1}]
[null,6,"Schüler 6",null,{"$f":"IFERROR(IF(H8=0,\"\",VLOOKUP(H8,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.43874999999999997,{"$f":"IF('Semester 1'!D8=0,\"\",'Semester 1'!D8)","v":1},{"$f":"IF('Semester 2'!D8=0,\"\",'Semester 1'!E8)","v":""},{"$f":"'Semester 1'!H8","v":0.97499999999999998},{"$f":"IFERROR('Semester 2'!H8,\"\")","v":0},{"$f":"IFERROR(IF(E8=1,\"\",IF(E8=2,Notenskala!$D$9-H8,IF(E8=3,Notenskala!$D$8-H8,IF(E8=4,Notenskala!$D$7-H8,IF(E8=5,Notenskala!$D$6-H8))))),\"\")","v":6.1250000000000027E-2},{"$f":"IFERROR(IF(E8=1,H8-Notenskala!$C$8,IF(E8=2,H8-Notenskala!$C$7,IF(E8=3,H8-Notenskala!$C$6,IF(E8=4,H8-Notenskala!$C$5,IF(E8=5,\"\"))))),\"\")","v":""}]
[null,7,"Schüler 7",null,{"$f":"IFERROR(IF(H9=0,\"\",VLOOKUP(H9,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.37624999999999997,{"$f":"IF('Semester 1'!D9=0,\"\",'Semester 1'!D9)","v":2},{"$f":"IF('Semester 2'!D9=0,\"\",'Semester 1'!E9)","v":""},{"$f":"'Semester 1'!H9","v":0.83611111111111103},{"$f":"IFERROR('Semester 2'!H9,\"\")","v":0},{"$f":"IFERROR(IF(E9=1,\"\",IF(E9=2,Notenskala!$D$9-H9,IF(E9=3,Notenskala!$D$8-H9,IF(E9=4,Notenskala!$D$7-H9,IF(E9=5,Notenskala!$D$6-H9))))),\"\")","v":0.12375000000000003},{"$f":"IFERROR(IF(E9=1,H9-Notenskala!$C$8,IF(E9=2,H9-Notenskala!$C$7,IF(E9=3,H9-Notenskala!$C$6,IF(E9=4,H9-Notenskala!$C$5,IF(E9=5,\"\"))))),\"\")","v":""}]
[null,8,"Schüler 8",null,{"$f":"IFERROR(IF(H10=0,\"\",VLOOKUP(H10,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.30869196428571433,{"$f":"IF('Semester 1'!D10=0,\"\",'Semester 1'!D10)","v":3},{"$f":"IF('Semester 2'!D10=0,\"\",'Semester 1'!E10)","v":""},{"$f":"'Semester 1'!H10","v":0.68598214285714287},{"$f":"IFERROR('Semester 2'!H10,\"\")","v":0},{"$f":"IFERROR(IF(E10=1,\"\",IF(E10=2,Notenskala!$D$9-H10,IF(E10=3,Notenskala!$D$8-H10,IF(E10=4,Notenskala!$D$7-H10,IF(E10=5,Notenskala!$D$6-H10))))),\"\")","v":0.19130803571428567},{"$f":"IFERROR(IF(E10=1,H10-Notenskala!$C$8,IF(E10=2,H10-Notenskala!$C$7,IF(E10=3,H10-Notenskala!$C$6,IF(E10=4,H10-Notenskala!$C$5,IF(E10=5,\"\"))))),\"\")","v":""}]
[null,9,"Schüler 9",null,{"$f":"IFERROR(IF(H11=0,\"\",VLOOKUP(H11,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.36608887987012989,{"$f":"IF('Semester 1'!D11=0,\"\",'Semester 1'!D11)","v":2},{"$f":"IF('Semester 2'!D11=0,\"\",'Semester 1'!E11)","v":""},{"$f":"'Semester 1'!H11","v":0.8135308441558442},{"$f":"IFERROR('Semester 2'!H11,\"\")","v":0},{"$f":"IFERROR(IF(E11=1,\"\",IF(E11=2,Notenskala!$D$9-H11,IF(E11=3,Notenskala!$D$8-H11,IF(E11=4,Notenskala!$D$7-H11,IF(E11=5,Notenskala!$D$6-H11))))),\"\")","v":0.13391112012987011},{"$f":"IFERROR(IF(E11=1,H11-Notenskala!$C$8,IF(E11=2,H11-Notenskala!$C$7,IF(E11=3,H11-Notenskala!$C$6,IF(E11=4,H11-Notenskala!$C$5,IF(E11=5,\"\"))))),\"\")","v":""}]
[null,10,"Schüler 10",null,{"$f":"IFERROR(IF(H12=0,\"\",VLOOKUP(H12,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.34238169642857141,{"$f":"IF('Semester 1'!D12=0,\"\",'Semester 1'!D12)","v":3},{"$f":"IF('Semester 2'!D12=0,\"\",'Semester 1'!E12)","v":""},{"$f":"'Semester 1'!H12","v":0.76084821428571425},{"$f":"IFERROR('Semester 2'!H12,\"\")","v":0},{"$f":"IFERROR(IF(E12=1,\"\",IF(E12=2,Notenskala!$D$9-H12,IF(E12=3,Notenskala!$D$8-H12,IF(E12=4,Notenskala!$D$7-H12,IF(E12=5,Notenskala!$D$6-H12))))),\"\")","v":0.15761830357142859},{"$f":"IFERROR(IF(E12=1,H12-Notenskala!$C$8,IF(E12=2,H12-Notenskala!$C$7,IF(E12=3,H12-Notenskala!$C$6,IF(E12=4,H12-Notenskala!$C$5,IF(E12=5,\"\"))))),\"\")","v":""}]
[null,11,"Schüler 11",null,{"$f":"IFERROR(IF(H13=0,\"\",VLOOKUP(H13,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.39278571428571424,{"$f":"IF('Semester 1'!D13=0,\"\",'Semester 1'!D13)","v":2},{"$f":"IF('Semester 2'!D13=0,\"\",'Semester 1'!E13)","v":""},{"$f":"'Semester 1'!H13","v":0.87285714285714278},{"$f":"IFERROR('Semester 2'!H13,\"\")","v":0},{"$f":"IFERROR(IF(E13=1,\"\",IF(E13=2,Notenskala!$D$9-H13,IF(E13=3,Notenskala!$D$8-H13,IF(E13=4,Notenskala!$D$7-H13,IF(E13=5,Notenskala!$D$6-H13))))),\"\")","v":0.10721428571428576},{"$f":"IFERROR(IF(E13=1,H13-Notenskala!$C$8,IF(E13=2,H13-Notenskala!$C$7,IF(E13=3,H13-Notenskala!$C$6,IF(E13=4,H13-Notenskala!$C$5,IF(E13=5,\"\"))))),\"\")","v":""}]
[null,12,"Schüler 12",null,{"$f":"IFERROR(IF(H14=0,\"\",VLOOKUP(H14,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.40853571428571434,{"$f":"IF('Semester 1'!D14=0,\"\",'Semester 1'!D14)","v":1},{"$f":"IF('Semester 2'!D14=0,\"\",'Semester 1'!E14)","v":""},{"$f":"'Semester 1'!H14","v":0.90785714285714292},{"$f":"IFERROR('Semester 2'!H14,\"\")","v":0},{"$f":"IFERROR(IF(E14=1,\"\",IF(E14=2,Notenskala!$D$9-H14,IF(E14=3,Notenskala!$D$8-H14,IF(E14=4,Notenskala!$D$7-H14,IF(E14=5,Notenskala!$D$6-H14))))),\"\")","v":9.1464285714285665E-2},{"$f":"IFERROR(IF(E14=1,H14-Notenskala!$C$8,IF(E14=2,H14-Notenskala!$C$7,IF(E14=3,H14-Notenskala!$C$6,IF(E14=4,H14-Notenskala!$C$5,IF(E14=5,\"\"))))),\"\")","v":""}]
[null,13,"Schüler 13",null,{"$f":"IFERROR(IF(H15=0,\"\",VLOOKUP(H15,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.34007142857142858,{"$f":"IF('Semester 1'!D15=0,\"\",'Semester 1'!D15)","v":3},{"$f":"IF('Semester 2'!D15=0,\"\",'Semester 1'!E15)","v":""},{"$f":"'Semester 1'!H15","v":0.75571428571428567},{"$f":"IFERROR('Semester 2'!H15,\"\")","v":0},{"$f":"IFERROR(IF(E15=1,\"\",IF(E15=2,Notenskala!$D$9-H15,IF(E15=3,Notenskala!$D$8-H15,IF(E15=4,Notenskala!$D$7-H15,IF(E15=5,Notenskala!$D$6-H15))))),\"\")","v":0.15992857142857142},{"$f":"IFERROR(IF(E15=1,H15-Notenskala!$C$8,IF(E15=2,H15-Notenskala!$C$7,IF(E15=3,H15-Notenskala!$C$6,IF(E15=4,H15-Notenskala!$C$5,IF(E15=5,\"\"))))),\"\")","v":""}]
[null,14,"Schüler 14",null,{"$f":"IFERROR(IF(H16=0,\"\",VLOOKUP(H16,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.39463392857142854,{"$f":"IF('Semester 1'!D16=0,\"\",'Semester 1'!D16)","v":2},{"$f":"IF('Semester 2'!D16=0,\"\",'Semester 1'!E16)","v":""},{"$f":"'Semester 1'!H16","v":0.87696428571428564},{"$f":"IFERROR('Semester 2'!H16,\"\")","v":0},{"$f":"IFERROR(IF(E16=1,\"\",IF(E16=2,Notenskala!$D$9-H16,IF(E16=3,Notenskala!$D$8-H16,IF(E16=4,Notenskala!$D$7-H16,IF(E16=5,Notenskala!$D$6-H16))))),\"\")","v":0.10536607142857146},{"$f":"IFERROR(IF(E16=1,H16-Notenskala!$C$8,IF(E16=2,H16-Notenskala!$C$7,IF(E16=3,H16-Notenskala!$C$6,IF(E16=4,H16-Notenskala!$C$5,IF(E16=5,\"\"))))),\"\")","v":""}]
[null,15,"Schüler 15",null,{"$f":"IFERROR(IF(H17=0,\"\",VLOOKUP(H17,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.42645535714285715,{"$f":"IF('Semester 1'!D17=0,\"\",'Semester 1'!D17)","v":1},{"$f":"IF('Semester 2'!D17=0,\"\",'Semester 1'!E17)","v":""},{"$f":"'Semester 1'!H17","v":0.94767857142857137},{"$f":"IFERROR('Semester 2'!H17,\"\")","v":0},{"$f":"IFERROR(IF(E17=1,\"\",IF(E17=2,Notenskala!$D$9-H17,IF(E17=3,Notenskala!$D$8-H17,IF(E17=4,Notenskala!$D$7-H17,IF(E17=5,Notenskala!$D$6-H17))))),\"\")","v":7.354464285714285E-2},{"$f":"IFERROR(IF(E17=1,H17-Notenskala!$C$8,IF(E17=2,H17-Notenskala!$C$7,IF(E17=3,H17-Notenskala!$C$6,IF(E17=4,H17-Notenskala!$C$5,IF(E17=5,\"\"))))),\"\")","v":""}]
[null,16,"Schüler 16",null,{"$f":"IFERROR(IF(H18=0,\"\",VLOOKUP(H18,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.44614903846153842,{"$f":"IF('Semester 1'!D18=0,\"\",'Semester 1'!D18)","v":1},{"$f":"IF('Semester 2'!D18=0,\"\",'Semester 1'!E18)","v":""},{"$f":"'Semester 1'!H18","v":0.99144230769230757},{"$f":"IFERROR('Semester 2'!H18,\"\")","v":0},{"$f":"IFERROR(IF(E18=1,\"\",IF(E18=2,Notenskala!$D$9-H18,IF(E18=3,Notenskala!$D$8-H18,IF(E18=4,Notenskala!$D$7-H18,IF(E18=5,Notenskala!$D$6-H18))))),\"\")","v":5.3850961538461584E-2},{"$f":"IFERROR(IF(E18=1,H18-Notenskala!$C$8,IF(E18=2,H18-Notenskala!$C$7,IF(E18=3,H18-Notenskala!$C$6,IF(E18=4,H18-Notenskala!$C$5,IF(E18=5,\"\"))))),\"\")","v":""}]
[null,17,"Schüler 17",null,{"$f":"IFERROR(IF(H19=0,\"\",VLOOKUP(H19,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.36962019230769233,{"$f":"IF('Semester 1'!D19=0,\"\",'Semester 1'!D19)","v":2},{"$f":"IF('Semester 2'!D19=0,\"\",'Semester 1'!E19)","v":""},{"$f":"'Semester 1'!H19","v":0.82137820512820514},{"$f":"IFERROR('Semester 2'!H19,\"\")","v":0},{"$f":"IFERROR(IF(E19=1,\"\",IF(E19=2,Notenskala!$D$9-H19,IF(E19=3,Notenskala!$D$8-H19,IF(E19=4,Notenskala!$D$7-H19,IF(E19=5,Notenskala!$D$6-H19))))),\"\")","v":0.13037980769230767},{"$f":"IFERROR(IF(E19=1,H19-Notenskala!$C$8,IF(E19=2,H19-Notenskala!$C$7,IF(E19=3,H19-Notenskala!$C$6,IF(E19=4,H19-Notenskala!$C$5,IF(E19=5,\"\"))))),\"\")","v":""}]
[null,18,"Schüler 18",null,{"$f":"IFERROR(IF(H20=0,\"\",VLOOKUP(H20,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.42629464285714291,{"$f":"IF('Semester 1'!D20=0,\"\",'Semester 1'!D20)","v":1},{"$f":"IF('Semester 2'!D20=0,\"\",'Semester 1'!E20)","v":""},{"$f":"'Semester 1'!H20","v":0.94732142857142865},{"$f":"IFERROR('Semester 2'!H20,\"\")","v":0},{"$f":"IFERROR(IF(E20=1,\"\",IF(E20=2,Notenskala!$D$9-H20,IF(E20=3,Notenskala!$D$8-H20,IF(E20=4,Notenskala!$D$7-H20,IF(E20=5,Notenskala!$D$6-H20))))),\"\")","v":7.3705357142857086E-2},{"$f":"IFERROR(IF(E20=1,H20-Notenskala!$C$8,IF(E20=2,H20-Notenskala!$C$7,IF(E20=3,H20-Notenskala!$C$6,IF(E20=4,H20-Notenskala!$C$5,IF(E20=5,\"\"))))),\"\")","v":""}]
[null,19,"Schüler 19",null,{"$f":"IFERROR(IF(H21=0,\"\",VLOOKUP(H21,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.36522321428571425,{"$f":"IF('Semester 1'!D21=0,\"\",'Semester 1'!D21)","v":2},{"$f":"IF('Semester 2'!D21=0,\"\",'Semester 1'!E21)","v":""},{"$f":"'Semester 1'!H21","v":0.81160714285714275},{"$f":"IFERROR('Semester 2'!H21,\"\")","v":0},{"$f":"IFERROR(IF(E21=1,\"\",IF(E21=2,Notenskala!$D$9-H21,IF(E21=3,Notenskala!$D$8-H21,IF(E21=4,Notenskala!$D$7-H21,IF(E21=5,Notenskala!$D$6-H21))))),\"\")","v":0.13477678571428575},{"$f":"IFERROR(IF(E21=1,H21-Notenskala!$C$8,IF(E21=2,H21-Notenskala!$C$7,IF(E21=3,H21-Notenskala!$C$6,IF(E21=4,H21-Notenskala!$C$5,IF(E21=5,\"\"))))),\"\")","v":""}]
[null,20,"Schüler 20",null,{"$f":"IFERROR(IF(H22=0,\"\",VLOOKUP(H22,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.41484375000000001,{"$f":"IF('Semester 1'!D22=0,\"\",'Semester 1'!D22)","v":1},{"$f":"IF('Semester 2'!D22=0,\"\",'Semester 1'!E22)","v":""},{"$f":"'Semester 1'!H22","v":0.921875},{"$f":"IFERROR('Semester 2'!H22,\"\")","v":0},{"$f":"IFERROR(IF(E22=1,\"\",IF(E22=2,Notenskala!$D$9-H22,IF(E22=3,Notenskala!$D$8-H22,IF(E22=4,Notenskala!$D$7-H22,IF(E22=5,Notenskala!$D$6-H22))))),\"\")","v":8.5156249999999989E-2},{"$f":"IFERROR(IF(E22=1,H22-Notenskala!$C$8,IF(E22=2,H22-Notenskala!$C$7,IF(E22=3,H22-Notenskala!$C$6,IF(E22=4,H22-Notenskala!$C$5,IF(E22=5,\"\"))))),\"\")","v":""}]
[null,21,"Schüler 21",null,{"$f":"IFERROR(IF(H23=0,\"\",VLOOKUP(H23,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.3392276785714286,{"$f":"IF('Semester 1'!D23=0,\"\",'Semester 1'!D23)","v":3},{"$f":"IF('Semester 2'!D23=0,\"\",'Semester 1'!E23)","v":""},{"$f":"'Semester 1'!H23","v":0.75383928571428571},{"$f":"IFERROR('Semester 2'!H23,\"\")","v":0},{"$f":"IFERROR(IF(E23=1,\"\",IF(E23=2,Notenskala!$D$9-H23,IF(E23=3,Notenskala!$D$8-H23,IF(E23=4,Notenskala!$D$7-H23,IF(E23=5,Notenskala!$D$6-H23))))),\"\")","v":0.1607723214285714},{"$f":"IFERROR(IF(E23=1,H23-Notenskala!$C$8,IF(E23=2,H23-Notenskala!$C$7,IF(E23=3,H23-Notenskala!$C$6,IF(E23=4,H23-Notenskala!$C$5,IF(E23=5,\"\"))))),\"\")","v":""}]
[null,22,"Schüler 22",null,{"$f":"IFERROR(IF(H24=0,\"\",VLOOKUP(H24,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":5},"h","i",0.36096428571428574,{"$f":"IF('Semester 1'!D24=0,\"\",'Semester 1'!D24)","v":2},{"$f":"IF('Semester 2'!D24=0,\"\",'Semester 1'!E24)","v":""},{"$f":"'Semester 1'!H24","v":0.80214285714285716},{"$f":"IFERROR('Semester 2'!H24,\"\")","v":0},{"$f":"IFERROR(IF(E24=1,\"\",IF(E24=2,Notenskala!$D$9-H24,IF(E24=3,Notenskala!$D$8-H24,IF(E24=4,Notenskala!$D$7-H24,IF(E24=5,Notenskala!$D$6-H24))))),\"\")","v":0.13903571428571426},{"$f":"IFERROR(IF(E24=1,H24-Notenskala!$C$8,IF(E24=2,H24-Notenskala!$C$7,IF(E24=3,H24-Notenskala!$C$6,IF(E24=4,H24-Notenskala!$C$5,IF(E24=5,\"\"))))),\"\")","v":""}]
[null,23,null,null,{"$f":"IFERROR(IF(H25=0,\"\",VLOOKUP(H25,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""},"h","i",0,{"$f":"IF('Semester 1'!D25=0,\"\",'Semester 1'!D25)","v":""},{"$f":"IF('Semester 2'!D25=0,\"\",'Semester 1'!E25)","v":""},{"$f":"'Semester 1'!H25","v":0},{"$f":"IFERROR('Semester 2'!H25,\"\")","v":0},{"$f":"IFERROR(IF(E25=1,\"\",IF(E25=2,Notenskala!$D$9-H25,IF(E25=3,Notenskala!$D$8-H25,IF(E25=4,Notenskala!$D$7-H25,IF(E25=5,Notenskala!$D$6-H25))))),\"\")","v":false},{"$f":"IFERROR(IF(E25=1,H25-Notenskala!$C$8,IF(E25=2,H25-Notenskala!$C$7,IF(E25=3,H25-Notenskala!$C$6,IF(E25=4,H25-Notenskala!$C$5,IF(E25=5,\"\"))))),\"\")","v":false}]
[null,24,null,null,{"$f":"IFERROR(IF(H26=0,\"\",VLOOKUP(H26,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""},"h","i",0,{"$f":"IF('Semester 1'!D26=0,\"\",'Semester 1'!D26)","v":""},{"$f":"IF('Semester 2'!D26=0,\"\",'Semester 1'!E26)","v":""},{"$f":"'Semester 1'!H26","v":0},{"$f":"IFERROR('Semester 2'!H26,\"\")","v":0},{"$f":"IFERROR(IF(E26=1,\"\",IF(E26=2,Notenskala!$D$9-H26,IF(E26=3,Notenskala!$D$8-H26,IF(E26=4,Notenskala!$D$7-H26,IF(E26=5,Notenskala!$D$6-H26))))),\"\")","v":false},{"$f":"IFERROR(IF(E26=1,H26-Notenskala!$C$8,IF(E26=2,H26-Notenskala!$C$7,IF(E26=3,H26-Notenskala!$C$6,IF(E26=4,H26-Notenskala!$C$5,IF(E26=5,\"\"))))),\"\")","v":false}]
[null,25,null,null,{"$f":"IFERROR(IF(H27=0,\"\",VLOOKUP(H27,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""},"h","i",0,{"$f":"IF('Semester 1'!D27=0,\"\",'Semester 1'!D27)","v":""},{"$f":"IF('Semester 2'!D27=0,\"\",'Semester 1'!E27)","v":""},{"$f":"'Semester 1'!H27","v":0},{"$f":"IFERROR('Semester 2'!H27,\"\")","v":0},{"$f":"IFERROR(IF(E27=1,\"\",IF(E27=2,Notenskala!$D$9-H27,IF(E27=3,Notenskala!$D$8-H27,IF(E27=4,Notenskala!$D$7-H27,IF(E27=5,Notenskala!$D$6-H27))))),\"\")","v":false},{"$f":"IFERROR(IF(E27=1,H27-Notenskala!$C$8,IF(E27=2,H27-Notenskala!$C$7,IF(E27=3,H27-Notenskala!$C$6,IF(E27=4,H27-Notenskala!$C$5,IF(E27=5,\"\"))))),\"\")","v":false}]
[]
[null,null,null,null,null,null,null,null,null,"Gewichtung",0.45,0.55000000000000004,null,null,{"$f":"SUM(K29:L29)","v":1}]
[null,null,null,null,null,null,null,null,null,"MUSS immer 100 ergeben!"]
[null,null,null,null,null,null,null,null,null,"für Ursprungswerte --> runterscrollen!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"#Default"]
[null,null,null,null,null,null,null,null,null,"Gewichtung",0.45,0.55000000000000004]

{"sheet":"Notenskala","index":2,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,"Notenskala"]
[]
[null,"Nicht Beurteilt","K/NB","K/NB","K/NB"]
[null,"Nicht Genügend",{"$f":"D6-0.01%","v":0.49990000000000001},0,5]
[null,"Genügend",{"$f":"D7-0.01%","v":0.64990000000000003},0.5,4]
[null,"Befriedigend",0.80990000000000006,0.65,3]
[null,"Gut",0.90990000000000004,0.81,2]
[null,"Sehr Gut",{"$f":"100%","v":1},0.91,1]
[]
[null,"für ursprüngliche Prozente --> runterscrollen!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"#Default"]
[null,"Nicht Beurteilt",null,"K/NB","K/NB"]
[null,"Nicht Genügend",null,0,5]
[null,"Genügend",null,0.5,4]
[null,"Befriedigend",null,0.65,3]
[null,"Gut",null,0.81,2]
[null,"Sehr Gut",null,0.91,1]

{"sheet":"Semester 1","index":3,"n_rows":53,"n_cols":31,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,"Nr.","Name","S1 Lehrer","Note","h","i","Gesamt","MA","Heft","Wdh","Test 1","Test 2","Test gemacht?","h","i",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B4","v":"Nicht Beurteilt"},{"$f":"Notenskala!C4","v":"K/NB"},{"$f":"Notenskala!D4","v":"K/NB"},{"$f":"Notenskala!E4","v":"K/NB"}]
[null,1,{"$f":"IF(Gesamtnote!C3=0,\"\",Gesamtnote!C3)","v":"Schüler 1"},2,{"$f":"IFERROR(IF(H3=0,\"\",VLOOKUP(H3,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2},{"$f":"IF(O3<2%,\"h\",IF(O3<4%,\"k\",\" \"))","v":" "},{"$f":"IF(P3<2%,\"i\",IF(P3<4%,\"m\",\" \"))","v":" "},{"$f":"IFERROR(_xlfn.IFS(N3=2,SUMPRODUCT(I3:M3,$I$29:$M$29)/SUM($I$29:$M$29),N3=1,SUMPRODUCT(I3:L3,$I$30:$L$30)/SUM($I$30:$L$30),N3=0,SUMPRODUCT(I3:K3,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.86691870629370626},{"$f":"'MA 1'!E3","v":0.88461538461538447},{"$f":"'Heft 1'!E3","v":0.8},{"$f":"'Wdh 1'!E6","v":0.88636363636363635},{"$f":"IF('Test 1.1'!E4=\"K/NB\",'Test 1.2'!E4,'Test 1.1'!E4)","v":0.9375},{"$f":"IF('Test 1.1'!E4=\"K/NB\",\"K/NB\",'Test 1.2'!E4)","v":0.84375},{"$f":"COUNT(L3:M3)","v":2},{"$f":"IFERROR(IF(E3=1,\"\",IF(E3=2,Notenskala!$D$9-H3,IF(E3=3,Notenskala!$D$8-H3,IF(E3=4,Notenskala!$D$7-H3,IF(E3=5,Notenskala!$D$6-H3))))),\"\")","v":4.3081293706293766E-2},{"$f":"IFERROR(IF(E3=1,H3-Notenskala!$C$8,IF(E3=2,H3-Notenskala!$C$7,IF(E3=3,H3-Notenskala!$C$6,IF(E3=4,H3-Notenskala!$C$5,IF(E3=5,\"\"))))),\"\")","v":5.7018706293706201E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B5","v":"Nicht Genügend"},{"$f":"Notenskala!C5","v":0.49990000000000001},{"$f":"Notenskala!D5","v":0},{"$f":"Notenskala!E5","v":5}]
[null,2,{"$f":"IF(Gesamtnote!C4=0,\"\",Gesamtnote!C4)","v":"Schüler 2"},1,{"$f":"IFERROR(IF(H4=0,\"\",VLOOKUP(H4,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":1}," "," ",{"$f":"IFERROR(_xlfn.IFS(N4=2,SUMPRODUCT(I4:M4,$I$29:$M$29)/SUM($I$29:$M$29),N4=1,SUMPRODUCT(I4:L4,$I$30:$L$30)/SUM($I$30:$L$30),N4=0,SUMPRODUCT(I4:K4,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.97875000000000001},{"$f":"'MA 1'!E4","v":1},{"$f":"'Heft 1'!E4","v":0.9},{"$f":"'Wdh 1'!E7","v":1},{"$f":"IF('Test 1.1'!E5=\"K/NB\",'Test 1.2'!E5,'Test 1.1'!E5)","v":1},{"$f":"IF('Test 1.1'!E5=\"K/NB\",\"K/NB\",'Test 1.2'!E5)","v":0.96875},{"$f":"COUNT(L4:M4)","v":2},{"$f":"IFERROR(IF(E4=1,\"\",IF(E4=2,Notenskala!$D$9-H4,IF(E4=3,Notenskala!$D$8-H4,IF(E4=4,Notenskala!$D$7-H4,IF(E4=5,Notenskala!$D$6-H4))))),\"\")","v":""},{"$f":"IFERROR(IF(E4=1,H4-Notenskala!$C$8,IF(E4=2,H4-Notenskala!$C$7,IF(E4=3,H4-Notenskala!$C$6,IF(E4=4,H4-Notenskala!$C$5,IF(E4=5,\"\"))))),\"\")","v":6.8849999999999967E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B6","v":"Genügend"},{"$f":"Notenskala!C6","v":0.64990000000000003},{"$f":"Notenskala!D6","v":0.5},{"$f":"Notenskala!E6","v":4}]
[null,3,{"$f":"IF(Gesamtnote!C5=0,\"\",Gesamtnote!C5)","v":"Schüler 3"},2,{"$f":"IFERROR(IF(H5=0,\"\",VLOOKUP(H5,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":3},"h"," ",{"$f":"IFERROR(_xlfn.IFS(N5=2,SUMPRODUCT(I5:M5,$I$29:$M$29)/SUM($I$29:$M$29),N5=1,SUMPRODUCT(I5:L5,$I$30:$L$30)/SUM($I$30:$L$30),N5=0,SUMPRODUCT(I5:K5,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.79920454545454533},{"$f":"'MA 1'!E5","v":0.84999999999999987},{"$f":"'Heft 1'!E5","v":0.7},{"$f":"'Wdh 1'!E8","v":0.81818181818181823},{"$f":"IF('Test 1.1'!E6=\"K/NB\",'Test 1.2'!E6,'Test 1.1'!E6)","v":0.5},{"$f":"IF('Test 1.1'!E6=\"K/NB\",\"K/NB\",'Test 1.2'!E6)","v":0.84375},2,{"$f":"IFERROR(IF(E5=1,\"\",IF(E5=2,Notenskala!$D$9-H5,IF(E5=3,Notenskala!$D$8-H5,IF(E5=4,Notenskala!$D$7-H5,IF(E5=5,Notenskala!$D$6-H5))))),\"\")","v":1.0795454545454719E-2},{"$f":"IFERROR(IF(E5=1,H5-Notenskala!$C$8,IF(E5=2,H5-Notenskala!$C$7,IF(E5=3,H5-Notenskala!$C$6,IF(E5=4,H5-Notenskala!$C$5,IF(E5=5,\"\"))))),\"\")","v":0.1493045454545453},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B7","v":"Befriedigend"},{"$f":"Notenskala!C7","v":0.80990000000000006},{"$f":"Notenskala!D7","v":0.65},{"$f":"Notenskala!E7","v":3}]
[null,4,{"$f":"IF(Gesamtnote!C6=0,\"\",Gesamtnote!C6)","v":"Schüler 4"},1,{"$f":"IFERROR(IF(H6=0,\"\",VLOOKUP(H6,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":1}," "," ",{"$f":"IFERROR(_xlfn.IFS(N6=2,SUMPRODUCT(I6:M6,$I$29:$M$29)/SUM($I$29:$M$29),N6=1,SUMPRODUCT(I6:L6,$I$30:$L$30)/SUM($I$30:$L$30),N6=0,SUMPRODUCT(I6:K6,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.95250000000000001},{"$f":"'MA 1'!E6","v":1},{"$f":"'Heft 1'!E6","v":0.85},{"$f":"'Wdh 1'!E9","v":0.9375},{"$f":"IF('Test 1.1'!E7=\"K/NB\",'Test 1.2'!E7,'Test 1.1'!E7)","v":1},{"$f":"IF('Test 1.1'!E7=\"K/NB\",\"K/NB\",'Test 1.2'!E7)","v":0.96875},2,{"$f":"IFERROR(IF(E6=1,\"\",IF(E6=2,Notenskala!$D$9-H6,IF(E6=3,Notenskala!$D$8-H6,IF(E6=4,Notenskala!$D$7-H6,IF(E6=5,Notenskala!$D$6-H6))))),\"\")","v":""},{"$f":"IFERROR(IF(E6=1,H6-Notenskala!$C$8,IF(E6=2,H6-Notenskala!$C$7,IF(E6=3,H6-Notenskala!$C$6,IF(E6=4,H6-Notenskala!$C$5,IF(E6=5,\"\"))))),\"\")","v":4.2599999999999971E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B8","v":"Gut"},{"$f":"Notenskala!C8","v":0.90990000000000004},{"$f":"Notenskala!D8","v":0.81},{"$f":"Notenskala!E8","v":2}]
[null,5,{"$f":"IF(Gesamtnote!C7=0,\"\",Gesamtnote!C7)","v":"Schüler 5"},2,{"$f":"IFERROR(IF(H7=0,\"\",VLOOKUP(H7,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2}," ","m",{"$f":"IFERROR(_xlfn.IFS(N7=2,SUMPRODUCT(I7:M7,$I$29:$M$29)/SUM($I$29:$M$29),N7=1,SUMPRODUCT(I7:L7,$I$30:$L$30)/SUM($I$30:$L$30),N7=0,SUMPRODUCT(I7:K7,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.83372596153846157},{"$f":"'MA 1'!E7","v":0.93846153846153846},{"$f":"'Heft 1'!E7","v":0.9},{"$f":"'Wdh 1'!E10","v":0.734375},{"$f":"IF('Test 1.1'!E8=\"K/NB\",'Test 1.2'!E8,'Test 1.1'!E8)","v":0.8125},{"$f":"IF('Test 1.1'!E8=\"K/NB\",\"K/NB\",'Test 1.2'!E8)","v":0.78125},2,{"$f":"IFERROR(IF(E7=1,\"\",IF(E7=2,Notenskala!$D$9-H7,IF(E7=3,Notenskala!$D$8-H7,IF(E7=4,Notenskala!$D$7-H7,IF(E7=5,Notenskala!$D$6-H7))))),\"\")","v":7.6274038461538463E-2},{"$f":"IFERROR(IF(E7=1,H7-Notenskala!$C$8,IF(E7=2,H7-Notenskala!$C$7,IF(E7=3,H7-Notenskala!$C$6,IF(E7=4,H7-Notenskala!$C$5,IF(E7=5,\"\"))))),\"\")","v":2.3825961538461504E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B9","v":"Sehr Gut"},{"$f":"Notenskala!C9","v":1},{"$f":"Notenskala!D9","v":0.91},{"$f":"Notenskala!E9","v":1}]
[null,6,{"$f":"IF(Gesamtnote!C8=0,\"\",Gesamtnote!C8)","v":"Schüler 6"},1,{"$f":"IFERROR(IF(H8=0,\"\",VLOOKUP(H8,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":1}," "," ",{"$f":"IFERROR(_xlfn.IFS(N8=2,SUMPRODUCT(I8:M8,$I$29:$M$29)/SUM($I$29:$M$29),N8=1,SUMPRODUCT(I8:L8,$I$30:$L$30)/SUM($I$30:$L$30),N8=0,SUMPRODUCT(I8:K8,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.97499999999999998},{"$f":"'MA 1'!E8","v":1},{"$f":"'Heft 1'!E8","v":1},{"$f":"'Wdh 1'!E11","v":0.9375},{"$f":"IF('Test 1.1'!E9=\"K/NB\",'Test 1.2'!E9,'Test 1.1'!E9)","v":1},{"$f":"IF('Test 1.1'!E9=\"K/NB\",\"K/NB\",'Test 1.2'!E9)","v":0.96875},2,{"$f":"IFERROR(IF(E8=1,\"\",IF(E8=2,Notenskala!$D$9-H8,IF(E8=3,Notenskala!$D$8-H8,IF(E8=4,Notenskala!$D$7-H8,IF(E8=5,Notenskala!$D$6-H8))))),\"\")","v":""},{"$f":"IFERROR(IF(E8=1,H8-Notenskala!$C$8,IF(E8=2,H8-Notenskala!$C$7,IF(E8=3,H8-Notenskala!$C$6,IF(E8=4,H8-Notenskala!$C$5,IF(E8=5,\"\"))))),\"\")","v":6.5099999999999936E-2}]
[null,7,{"$f":"IF(Gesamtnote!C9=0,\"\",Gesamtnote!C9)","v":"Schüler 7"},2,{"$f":"IFERROR(IF(H9=0,\"\",VLOOKUP(H9,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2}," ","m",{"$f":"IFERROR(_xlfn.IFS(N9=2,SUMPRODUCT(I9:M9,$I$29:$M$29)/SUM($I$29:$M$29),N9=1,SUMPRODUCT(I9:L9,$I$30:$L$30)/SUM($I$30:$L$30),N9=0,SUMPRODUCT(I9:K9,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.83611111111111103},{"$f":"'MA 1'!E9","v":0.82500000000000007},{"$f":"'Heft 1'!E9","v":0.85},{"$f":"'Wdh 1'!E12","v":0.87037037037037035},{"$f":"IF('Test 1.1'!E10=\"K/NB\",'Test 1.2'!E10,'Test 1.1'!E10)","v":0.875},{"$f":"IF('Test 1.1'!E10=\"K/NB\",\"K/NB\",'Test 1.2'!E10)","v":0.78125},2,{"$f":"IFERROR(IF(E9=1,\"\",IF(E9=2,Notenskala!$D$9-H9,IF(E9=3,Notenskala!$D$8-H9,IF(E9=4,Notenskala!$D$7-H9,IF(E9=5,Notenskala!$D$6-H9))))),\"\")","v":7.3888888888889004E-2},{"$f":"IFERROR(IF(E9=1,H9-Notenskala!$C$8,IF(E9=2,H9-Notenskala!$C$7,IF(E9=3,H9-Notenskala!$C$6,IF(E9=4,H9-Notenskala!$C$5,IF(E9=5,\"\"))))),\"\")","v":2.6211111111110963E-2}]
[null,8,{"$f":"IF(Gesamtnote!C10=0,\"\",Gesamtnote!C10)","v":"Schüler 8"},3,{"$f":"IFERROR(IF(H10=0,\"\",VLOOKUP(H10,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":3}," ","m",{"$f":"IFERROR(_xlfn.IFS(N10=2,SUMPRODUCT(I10:M10,$I$29:$M$29)/SUM($I$29:$M$29),N10=1,SUMPRODUCT(I10:L10,$I$30:$L$30)/SUM($I$30:$L$30),N10=0,SUMPRODUCT(I10:K10,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.68598214285714287},{"$f":"'MA 1'!E10","v":0.79285714285714282},{"$f":"'Heft 1'!E10","v":0.8},{"$f":"'Wdh 1'!E13","v":0.625},{"$f":"IF('Test 1.1'!E11=\"K/NB\",'Test 1.2'!E11,'Test 1.1'!E11)","v":0.8125},{"$f":"IF('Test 1.1'!E11=\"K/NB\",\"K/NB\",'Test 1.2'!E11)","v":0.5},2,{"$f":"IFERROR(IF(E10=1,\"\",IF(E10=2,Notenskala!$D$9-H10,IF(E10=3,Notenskala!$D$8-H10,IF(E10=4,Notenskala!$D$7-H10,IF(E10=5,Notenskala!$D$6-H10))))),\"\")","v":0.12401785714285718},{"$f":"IFERROR(IF(E10=1,H10-Notenskala!$C$8,IF(E10=2,H10-Notenskala!$C$7,IF(E10=3,H10-Notenskala!$C$6,IF(E10=4,H10-Notenskala!$C$5,IF(E10=5,\"\"))))),\"\")","v":3.608214285714284E-2}]
[null,9,{"$f":"IF(Gesamtnote!C11=0,\"\",Gesamtnote!C11)","v":"Schüler 9"},2,{"$f":"IFERROR(IF(H11=0,\"\",VLOOKUP(H11,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2}," ","i",{"$f":"IFERROR(_xlfn.IFS(N11=2,SUMPRODUCT(I11:M11,$I$29:$M$29)/SUM($I$29:$M$29),N11=1,SUMPRODUCT(I11:L11,$I$30:$L$30)/SUM($I$30:$L$30),N11=0,SUMPRODUCT(I11:K11,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.8135308441558442},{"$f":"'MA 1'!E11","v":0.82142857142857129},{"$f":"'Heft 1'!E11","v":0.9},{"$f":"'Wdh 1'!E14","v":0.90909090909090906},{"$f":"IF('Test 1.1'!E12=\"K/NB\",'Test 1.2'!E12,'Test 1.1'!E12)","v":0.6875},{"$f":"IF('Test 1.1'!E12=\"K/NB\",\"K/NB\",'Test 1.2'!E12)","v":0.625},2,{"$f":"IFERROR(IF(E11=1,\"\",IF(E11=2,Notenskala!$D$9-H11,IF(E11=3,Notenskala!$D$8-H11,IF(E11=4,Notenskala!$D$7-H11,IF(E11=5,Notenskala!$D$6-H11))))),\"\")","v":9.6469155844155829E-2},{"$f":"IFERROR(IF(E11=1,H11-Notenskala!$C$8,IF(E11=2,H11-Notenskala!$C$7,IF(E11=3,H11-Notenskala!$C$6,IF(E11=4,H11-Notenskala!$C$5,IF(E11=5,\"\"))))),\"\")","v":3.6308441558441373E-3}]
[null,10,{"$f":"IF(Gesamtnote!C12=0,\"\",Gesamtnote!C12)","v":"Schüler 10"},3,{"$f":"IFERROR(IF(H12=0,\"\",VLOOKUP(H12,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":3}," "," ",{"$f":"IFERROR(_xlfn.IFS(N12=2,SUMPRODUCT(I12:M12,$I$29:$M$29)/SUM($I$29:$M$29),N12=1,SUMPRODUCT(I12:L12,$I$30:$L$30)/SUM($I$30:$L$30),N12=0,SUMPRODUCT(I12:K12,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.76084821428571425},{"$f":"'MA 1'!E12","v":0.81428571428571417},{"$f":"'Heft 1'!E12","v":0.85},{"$f":"'Wdh 1'!E15","v":0.640625},{"$f":"IF('Test 1.1'!E13=\"K/NB\",'Test 1.2'!E13,'Test 1.1'!E13)","v":0.8125},{"$f":"IF('Test 1.1'!E13=\"K/NB\",\"K/NB\",'Test 1.2'!E13)","v":0.78125},2,{"$f":"IFERROR(IF(E12=1,\"\",IF(E12=2,Notenskala!$D$9-H12,IF(E12=3,Notenskala!$D$8-H12,IF(E12=4,Notenskala!$D$7-H12,IF(E12=5,Notenskala!$D$6-H12))))),\"\")","v":4.9151785714285801E-2},{"$f":"IFERROR(IF(E12=1,H12-Notenskala!$C$8,IF(E12=2,H12-Notenskala!$C$7,IF(E12=3,H12-Notenskala!$C$6,IF(E12=4,H12-Notenskala!$C$5,IF(E12=5,\"\"))))),\"\")","v":0.11094821428571422}]
[null,11,{"$f":"IF(Gesamtnote!C13=0,\"\",Gesamtnote!C13)","v":"Schüler 11"},2,{"$f":"IFERROR(IF(H13=0,\"\",VLOOKUP(H13,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2},"k"," ",{"$f":"IFERROR(_xlfn.IFS(N13=2,SUMPRODUCT(I13:M13,$I$29:$M$29)/SUM($I$29:$M$29),N13=1,SUMPRODUCT(I13:L13,$I$30:$L$30)/SUM($I$30:$L$30),N13=0,SUMPRODUCT(I13:K13,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.87285714285714278},{"$f":"'MA 1'!E13","v":0.8928571428571429},{"$f":"'Heft 1'!E13","v":0.95},{"$f":"'Wdh 1'!E16","v":0.875},{"$f":"IF('Test 1.1'!E14=\"K/NB\",'Test 1.2'!E14,'Test 1.1'!E14)","v":0.875},{"$f":"IF('Test 1.1'!E14=\"K/NB\",\"K/NB\",'Test 1.2'!E14)","v":0.78125},2,{"$f":"IFERROR(IF(E13=1,\"\",IF(E13=2,Notenskala!$D$9-H13,IF(E13=3,Notenskala!$D$8-H13,IF(E13=4,Notenskala!$D$7-H13,IF(E13=5,Notenskala!$D$6-H13))))),\"\")","v":3.7142857142857255E-2},{"$f":"IFERROR(IF(E13=1,H13-Notenskala!$C$8,IF(E13=2,H13-Notenskala!$C$7,IF(E13=3,H13-Notenskala!$C$6,IF(E13=4,H13-Notenskala!$C$5,IF(E13=5,\"\"))))),\"\")","v":6.2957142857142712E-2}]
[null,12,{"$f":"IF(Gesamtnote!C14=0,\"\",Gesamtnote!C14)","v":"Schüler 12"},1,{"$f":"IFERROR(IF(H14=0,\"\",VLOOKUP(H14,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2},"h"," ",{"$f":"IFERROR(_xlfn.IFS(N14=2,SUMPRODUCT(I14:M14,$I$29:$M$29)/SUM($I$29:$M$29),N14=1,SUMPRODUCT(I14:L14,$I$30:$L$30)/SUM($I$30:$L$30),N14=0,SUMPRODUCT(I14:K14,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.90785714285714292},{"$f":"'MA 1'!E14","v":0.8928571428571429},{"$f":"'Heft 1'!E14","v":0.85},{"$f":"'Wdh 1'!E17","v":0.96875},{"$f":"IF('Test 1.1'!E15=\"K/NB\",'Test 1.2'!E15,'Test 1.1'!E15)","v":0.8125},{"$f":"IF('Test 1.1'!E15=\"K/NB\",\"K/NB\",'Test 1.2'!E15)","v":0.90625},2,{"$f":"IFERROR(IF(E14=1,\"\",IF(E14=2,Notenskala!$D$9-H14,IF(E14=3,Notenskala!$D$8-H14,IF(E14=4,Notenskala!$D$7-H14,IF(E14=5,Notenskala!$D$6-H14))))),\"\")","v":2.142857142857113E-3},{"$f":"IFERROR(IF(E14=1,H14-Notenskala!$C$8,IF(E14=2,H14-Notenskala!$C$7,IF(E14=3,H14-Notenskala!$C$6,IF(E14=4,H14-Notenskala!$C$5,IF(E14=5,\"\"))))),\"\")","v":9.7957142857142854E-2}]
[null,13,{"$f":"IF(Gesamtnote!C15=0,\"\",Gesamtnote!C15)","v":"Schüler 13"},3,{"$f":"IFERROR(IF(H15=0,\"\",VLOOKUP(H15,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":3}," "," ",{"$f":"IFERROR(_xlfn.IFS(N15=2,SUMPRODUCT(I15:M15,$I$29:$M$29)/SUM($I$29:$M$29),N15=1,SUMPRODUCT(I15:L15,$I$30:$L$30)/SUM($I$30:$L$30),N15=0,SUMPRODUCT(I15:K15,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.75571428571428567},{"$f":"'MA 1'!E15","v":0.7857142857142857},{"$f":"'Heft 1'!E15","v":0.8},{"$f":"'Wdh 1'!E18","v":0.65625},{"$f":"IF('Test 1.1'!E16=\"K/NB\",'Test 1.2'!E16,'Test 1.1'!E16)","v":0.8125},{"$f":"IF('Test 1.1'!E16=\"K/NB\",\"K/NB\",'Test 1.2'!E16)","v":0.8125},2,{"$f":"IFERROR(IF(E15=1,\"\",IF(E15=2,Notenskala!$D$9-H15,IF(E15=3,Notenskala!$D$8-H15,IF(E15=4,Notenskala!$D$7-H15,IF(E15=5,Notenskala!$D$6-H15))))),\"\")","v":5.4285714285714382E-2},{"$f":"IFERROR(IF(E15=1,H15-Notenskala!$C$8,IF(E15=2,H15-Notenskala!$C$7,IF(E15=3,H15-Notenskala!$C$6,IF(E15=4,H15-Notenskala!$C$5,IF(E15=5,\"\"))))),\"\")","v":0.10581428571428564}]
[null,14,{"$f":"IF(Gesamtnote!C16=0,\"\",Gesamtnote!C16)","v":"Schüler 14"},2,{"$f":"IFERROR(IF(H16=0,\"\",VLOOKUP(H16,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2},"k"," ",{"$f":"IFERROR(_xlfn.IFS(N16=2,SUMPRODUCT(I16:M16,$I$29:$M$29)/SUM($I$29:$M$29),N16=1,SUMPRODUCT(I16:L16,$I$30:$L$30)/SUM($I$30:$L$30),N16=0,SUMPRODUCT(I16:K16,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.87696428571428564},{"$f":"'MA 1'!E16","v":0.88571428571428579},{"$f":"'Heft 1'!E16","v":0.95},{"$f":"'Wdh 1'!E19","v":0.84375},{"$f":"IF('Test 1.1'!E17=\"K/NB\",'Test 1.2'!E17,'Test 1.1'!E17)","v":0.9375},{"$f":"IF('Test 1.1'!E17=\"K/NB\",\"K/NB\",'Test 1.2'!E17)","v":0.84375},2,{"$f":"IFERROR(IF(E16=1,\"\",IF(E16=2,Notenskala!$D$9-H16,IF(E16=3,Notenskala!$D$8-H16,IF(E16=4,Notenskala!$D$7-H16,IF(E16=5,Notenskala!$D$6-H16))))),\"\")","v":3.303571428571439E-2},{"$f":"IFERROR(IF(E16=1,H16-Notenskala!$C$8,IF(E16=2,H16-Notenskala!$C$7,IF(E16=3,H16-Notenskala!$C$6,IF(E16=4,H16-Notenskala!$C$5,IF(E16=5,\"\"))))),\"\")","v":6.7064285714285576E-2}]
[null,15,{"$f":"IF(Gesamtnote!C17=0,\"\",Gesamtnote!C17)","v":"Schüler 15"},1,{"$f":"IFERROR(IF(H17=0,\"\",VLOOKUP(H17,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":1}," ","m",{"$f":"IFERROR(_xlfn.IFS(N17=2,SUMPRODUCT(I17:M17,$I$29:$M$29)/SUM($I$29:$M$29),N17=1,SUMPRODUCT(I17:L17,$I$30:$L$30)/SUM($I$30:$L$30),N17=0,SUMPRODUCT(I17:K17,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.94767857142857137},{"$f":"'MA 1'!E17","v":0.97142857142857142},{"$f":"'Heft 1'!E17","v":0.95},{"$f":"'Wdh 1'!E20","v":0.9},{"$f":"IF('Test 1.1'!E18=\"K/NB\",'Test 1.2'!E18,'Test 1.1'!E18)","v":0.875},{"$f":"IF('Test 1.1'!E18=\"K/NB\",\"K/NB\",'Test 1.2'!E18)","v":1},2,{"$f":"IFERROR(IF(E17=1,\"\",IF(E17=2,Notenskala!$D$9-H17,IF(E17=3,Notenskala!$D$8-H17,IF(E17=4,Notenskala!$D$7-H17,IF(E17=5,Notenskala!$D$6-H17))))),\"\")","v":""},{"$f":"IFERROR(IF(E17=1,H17-Notenskala!$C$8,IF(E17=2,H17-Notenskala!$C$7,IF(E17=3,H17-Notenskala!$C$6,IF(E17=4,H17-Notenskala!$C$5,IF(E17=5,\"\"))))),\"\")","v":3.7778571428571328E-2}]
[null,16,{"$f":"IF(Gesamtnote!C18=0,\"\",Gesamtnote!C18)","v":"Schüler 16"},1,{"$f":"IFERROR(IF(H18=0,\"\",VLOOKUP(H18,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":1}," "," ",{"$f":"IFERROR(_xlfn.IFS(N18=2,SUMPRODUCT(I18:M18,$I$29:$M$29)/SUM($I$29:$M$29),N18=1,SUMPRODUCT(I18:L18,$I$30:$L$30)/SUM($I$30:$L$30),N18=0,SUMPRODUCT(I18:K18,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.99144230769230757},{"$f":"'MA 1'!E18","v":0.99230769230769234},{"$f":"'Heft 1'!E18","v":1},{"$f":"'Wdh 1'!E21","v":1},{"$f":"IF('Test 1.1'!E19=\"K/NB\",'Test 1.2'!E19,'Test 1.1'!E19)","v":0.875},{"$f":"IF('Test 1.1'!E19=\"K/NB\",\"K/NB\",'Test 1.2'!E19)","v":1},2,{"$f":"IFERROR(IF(E18=1,\"\",IF(E18=2,Notenskala!$D$9-H18,IF(E18=3,Notenskala!$D$8-H18,IF(E18=4,Notenskala!$D$7-H18,IF(E18=5,Notenskala!$D$6-H18))))),\"\")","v":""},{"$f":"IFERROR(IF(E18=1,H18-Notenskala!$C$8,IF(E18=2,H18-Notenskala!$C$7,IF(E18=3,H18-Notenskala!$C$6,IF(E18=4,H18-Notenskala!$C$5,IF(E18=5,\"\"))))),\"\")","v":8.1542307692307525E-2}]
[null,17,{"$f":"IF(Gesamtnote!C19=0,\"\",Gesamtnote!C19)","v":"Schüler 17"},2,{"$f":"IFERROR(IF(H19=0,\"\",VLOOKUP(H19,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2}," ","i",{"$f":"IFERROR(_xlfn.IFS(N19=2,SUMPRODUCT(I19:M19,$I$29:$M$29)/SUM($I$29:$M$29),N19=1,SUMPRODUCT(I19:L19,$I$30:$L$30)/SUM($I$30:$L$30),N19=0,SUMPRODUCT(I19:K19,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.82137820512820514},{"$f":"'MA 1'!E19","v":0.86153846153846148},{"$f":"'Heft 1'!E19","v":0.85},{"$f":"'Wdh 1'!E22","v":0.88888888888888884},{"$f":"IF('Test 1.1'!E20=\"K/NB\",'Test 1.2'!E20,'Test 1.1'!E20)","v":0.5},{"$f":"IF('Test 1.1'!E20=\"K/NB\",\"K/NB\",'Test 1.2'!E20)","v":0.71875},2,{"$f":"IFERROR(IF(E19=1,\"\",IF(E19=2,Notenskala!$D$9-H19,IF(E19=3,Notenskala!$D$8-H19,IF(E19=4,Notenskala!$D$7-H19,IF(E19=5,Notenskala!$D$6-H19))))),\"\")","v":8.862179487179489E-2},{"$f":"IFERROR(IF(E19=1,H19-Notenskala!$C$8,IF(E19=2,H19-Notenskala!$C$7,IF(E19=3,H19-Notenskala!$C$6,IF(E19=4,H19-Notenskala!$C$5,IF(E19=5,\"\"))))),\"\")","v":1.1478205128205077E-2}]
[null,18,{"$f":"IF(Gesamtnote!C20=0,\"\",Gesamtnote!C20)","v":"Schüler 18"},1,{"$f":"IFERROR(IF(H20=0,\"\",VLOOKUP(H20,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":1}," ","m",{"$f":"IFERROR(_xlfn.IFS(N20=2,SUMPRODUCT(I20:M20,$I$29:$M$29)/SUM($I$29:$M$29),N20=1,SUMPRODUCT(I20:L20,$I$30:$L$30)/SUM($I$30:$L$30),N20=0,SUMPRODUCT(I20:K20,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.94732142857142865},{"$f":"'MA 1'!E20","v":0.97857142857142865},{"$f":"'Heft 1'!E20","v":0.9},{"$f":"'Wdh 1'!E23","v":0.90625},{"$f":"IF('Test 1.1'!E21=\"K/NB\",'Test 1.2'!E21,'Test 1.1'!E21)","v":0.9375},{"$f":"IF('Test 1.1'!E21=\"K/NB\",\"K/NB\",'Test 1.2'!E21)","v":1},2,{"$f":"IFERROR(IF(E20=1,\"\",IF(E20=2,Notenskala!$D$9-H20,IF(E20=3,Notenskala!$D$8-H20,IF(E20=4,Notenskala!$D$7-H20,IF(E20=5,Notenskala!$D$6-H20))))),\"\")","v":""},{"$f":"IFERROR(IF(E20=1,H20-Notenskala!$C$8,IF(E20=2,H20-Notenskala!$C$7,IF(E20=3,H20-Notenskala!$C$6,IF(E20=4,H20-Notenskala!$C$5,IF(E20=5,\"\"))))),\"\")","v":3.7421428571428605E-2}]
[null,19,{"$f":"IF(Gesamtnote!C21=0,\"\",Gesamtnote!C21)","v":"Schüler 19"},2,{"$f":"IFERROR(IF(H21=0,\"\",VLOOKUP(H21,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":2}," ","i",{"$f":"IFERROR(_xlfn.IFS(N21=2,SUMPRODUCT(I21:M21,$I$29:$M$29)/SUM($I$29:$M$29),N21=1,SUMPRODUCT(I21:L21,$I$30:$L$30)/SUM($I$30:$L$30),N21=0,SUMPRODUCT(I21:K21,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.81160714285714275},{"$f":"'MA 1'!E21","v":0.84285714285714286},{"$f":"'Heft 1'!E21","v":0.85},{"$f":"'Wdh 1'!E24","v":0.75},{"$f":"IF('Test 1.1'!E22=\"K/NB\",'Test 1.2'!E22,'Test 1.1'!E22)","v":0.75},{"$f":"IF('Test 1.1'!E22=\"K/NB\",\"K/NB\",'Test 1.2'!E22)","v":0.84375},2,{"$f":"IFERROR(IF(E21=1,\"\",IF(E21=2,Notenskala!$D$9-H21,IF(E21=3,Notenskala!$D$8-H21,IF(E21=4,Notenskala!$D$7-H21,IF(E21=5,Notenskala!$D$6-H21))))),\"\")","v":9.8392857142857282E-2},{"$f":"IFERROR(IF(E21=1,H21-Notenskala!$C$8,IF(E21=2,H21-Notenskala!$C$7,IF(E21=3,H21-Notenskala!$C$6,IF(E21=4,H21-Notenskala!$C$5,IF(E21=5,\"\"))))),\"\")","v":1.707142857142685E-3}]
[null,20,{"$f":"IF(Gesamtnote!C22=0,\"\",Gesamtnote!C22)","v":"Schüler 20"},1,{"$f":"IFERROR(IF(H22=0,\"\",VLOOKUP(H22,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":1}," ","i",{"$f":"IFERROR(_xlfn.IFS(N22=2,SUMPRODUCT(I22:M22,$I$29:$M$29)/SUM($I$29:$M$29),N22=1,SUMPRODUCT(I22:L22,$I$30:$L$30)/SUM($I$30:$L$30),N22=0,SUMPRODUCT(I22:K22,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.921875},{"$f":"'MA 1'!E22","v":1},{"$f":"'Heft 1'!E22","v":1},{"$f":"'Wdh 1'!E25","v":0.8125},{"$f":"IF('Test 1.1'!E23=\"K/NB\",'Test 1.2'!E23,'Test 1.1'!E23)","v":0.9375},{"$f":"IF('Test 1.1'!E23=\"K/NB\",\"K/NB\",'Test 1.2'!E23)","v":0.90625},2,{"$f":"IFERROR(IF(E22=1,\"\",IF(E22=2,Notenskala!$D$9-H22,IF(E22=3,Notenskala!$D$8-H22,IF(E22=4,Notenskala!$D$7-H22,IF(E22=5,Notenskala!$D$6-H22))))),\"\")","v":""},{"$f":"IFERROR(IF(E22=1,H22-Notenskala!$C$8,IF(E22=2,H22-Notenskala!$C$7,IF(E22=3,H22-Notenskala!$C$6,IF(E22=4,H22-Notenskala!$C$5,IF(E22=5,\"\"))))),\"\")","v":1.1974999999999958E-2}]
[null,21,{"$f":"IF(Gesamtnote!C23=0,\"\",Gesamtnote!C23)","v":"Schüler 21"},3,{"$f":"IFERROR(IF(H23=0,\"\",VLOOKUP(H23,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":3}," "," ",{"$f":"IFERROR(_xlfn.IFS(N23=2,SUMPRODUCT(I23:M23,$I$29:$M$29)/SUM($I$29:$M$29),N23=1,SUMPRODUCT(I23:L23,$I$30:$L$30)/SUM($I$30:$L$30),N23=0,SUMPRODUCT(I23:K23,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.75383928571428571},{"$f":"'MA 1'!E23","v":0.7857142857142857},{"$f":"'Heft 1'!E23","v":0.85},{"$f":"'Wdh 1'!E26","v":0.75},{"$f":"IF('Test 1.1'!E24=\"K/NB\",'Test 1.2'!E24,'Test 1.1'!E24)","v":0.6875},{"$f":"IF('Test 1.1'!E24=\"K/NB\",\"K/NB\",'Test 1.2'!E24)","v":0.65625},2,{"$f":"IFERROR(IF(E23=1,\"\",IF(E23=2,Notenskala!$D$9-H23,IF(E23=3,Notenskala!$D$8-H23,IF(E23=4,Notenskala!$D$7-H23,IF(E23=5,Notenskala!$D$6-H23))))),\"\")","v":5.6160714285714342E-2},{"$f":"IFERROR(IF(E23=1,H23-Notenskala!$C$8,IF(E23=2,H23-Notenskala!$C$7,IF(E23=3,H23-Notenskala!$C$6,IF(E23=4,H23-Notenskala!$C$5,IF(E23=5,\"\"))))),\"\")","v":0.10393928571428568}]
[null,22,{"$f":"IF(Gesamtnote!C24=0,\"\",Gesamtnote!C24)","v":"Schüler 22"},2,{"$f":"IFERROR(IF(H24=0,\"\",VLOOKUP(H24,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":3},"h"," ",{"$f":"IFERROR(_xlfn.IFS(N24=2,SUMPRODUCT(I24:M24,$I$29:$M$29)/SUM($I$29:$M$29),N24=1,SUMPRODUCT(I24:L24,$I$30:$L$30)/SUM($I$30:$L$30),N24=0,SUMPRODUCT(I24:K24,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0.80214285714285716},{"$f":"'MA 1'!E24","v":0.8571428571428571},{"$f":"'Heft 1'!E24","v":0.8},{"$f":"'Wdh 1'!E27","v":0.78125},{"$f":"IF('Test 1.1'!E25=\"K/NB\",'Test 1.2'!E25,'Test 1.1'!E25)","v":0.6875},{"$f":"IF('Test 1.1'!E25=\"K/NB\",\"K/NB\",'Test 1.2'!E25)","v":0.78125},2,{"$f":"IFERROR(IF(E24=1,\"\",IF(E24=2,Notenskala!$D$9-H24,IF(E24=3,Notenskala!$D$8-H24,IF(E24=4,Notenskala!$D$7-H24,IF(E24=5,Notenskala!$D$6-H24))))),\"\")","v":7.8571428571428958E-3},{"$f":"IFERROR(IF(E24=1,H24-Notenskala!$C$8,IF(E24=2,H24-Notenskala!$C$7,IF(E24=3,H24-Notenskala!$C$6,IF(E24=4,H24-Notenskala!$C$5,IF(E24=5,\"\"))))),\"\")","v":0.15224285714285712}]
[null,23,{"$f":"IF(Gesamtnote!C25=0,\"\",Gesamtnote!C25)","v":""},null,{"$f":"IFERROR(IF(H25=0,\"\",VLOOKUP(H25,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N25=2,SUMPRODUCT(I25:M25,$I$29:$M$29)/SUM($I$29:$M$29),N25=1,SUMPRODUCT(I25:L25,$I$30:$L$30)/SUM($I$30:$L$30),N25=0,SUMPRODUCT(I25:K25,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 1'!E25","v":""},{"$f":"'Heft 1'!E25","v":""},{"$f":"'Wdh 1'!E28","v":""},{"$f":"IF('Test 1.1'!E26=\"K/NB\",'Test 1.2'!E26,'Test 1.1'!E26)","v":"K/NB"},{"$f":"IF('Test 1.1'!E26=\"K/NB\",\"K/NB\",'Test 1.2'!E26)","v":"K/NB"},0,{"$f":"IFERROR(IF(E25=1,\"\",IF(E25=2,Notenskala!$D$9-H25,IF(E25=3,Notenskala!$D$8-H25,IF(E25=4,Notenskala!$D$7-H25,IF(E25=5,Notenskala!$D$6-H25))))),\"\")","v":false},{"$f":"IFERROR(IF(E25=1,H25-Notenskala!$C$8,IF(E25=2,H25-Notenskala!$C$7,IF(E25=3,H25-Notenskala!$C$6,IF(E25=4,H25-Notenskala!$C$5,IF(E25=5,\"\"))))),\"\")","v":false}]
[null,24,{"$f":"IF(Gesamtnote!C26=0,\"\",Gesamtnote!C26)","v":""},null,{"$f":"IFERROR(IF(H26=0,\"\",VLOOKUP(H26,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N26=2,SUMPRODUCT(I26:M26,$I$29:$M$29)/SUM($I$29:$M$29),N26=1,SUMPRODUCT(I26:L26,$I$30:$L$30)/SUM($I$30:$L$30),N26=0,SUMPRODUCT(I26:K26,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 1'!E26","v":""},{"$f":"'Heft 1'!E26","v":""},{"$f":"'Wdh 1'!E29","v":""},{"$f":"IF('Test 1.1'!E27=\"K/NB\",'Test 1.2'!E27,'Test 1.1'!E27)","v":"K/NB"},{"$f":"IF('Test 1.1'!E27=\"K/NB\",\"K/NB\",'Test 1.2'!E27)","v":"K/NB"},0,{"$f":"IFERROR(IF(E26=1,\"\",IF(E26=2,Notenskala!$D$9-H26,IF(E26=3,Notenskala!$D$8-H26,IF(E26=4,Notenskala!$D$7-H26,IF(E26=5,Notenskala!$D$6-H26))))),\"\")","v":false},{"$f":"IFERROR(IF(E26=1,H26-Notenskala!$C$8,IF(E26=2,H26-Notenskala!$C$7,IF(E26=3,H26-Notenskala!$C$6,IF(E26=4,H26-Notenskala!$C$5,IF(E26=5,\"\"))))),\"\")","v":false}]
[null,25,{"$f":"IF(Gesamtnote!C27=0,\"\",Gesamtnote!C27)","v":""},null,{"$f":"IFERROR(IF(H27=0,\"\",VLOOKUP(H27,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N27=2,SUMPRODUCT(I27:M27,$I$29:$M$29)/SUM($I$29:$M$29),N27=1,SUMPRODUCT(I27:L27,$I$30:$L$30)/SUM($I$30:$L$30),N27=0,SUMPRODUCT(I27:K27,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 1'!E27","v":""},{"$f":"'Heft 1'!E27","v":""},{"$f":"'Wdh 1'!E30","v":""},{"$f":"IF('Test 1.1'!E28=\"K/NB\",'Test 1.2'!E28,'Test 1.1'!E28)","v":"K/NB"},{"$f":"IF('Test 1.1'!E28=\"K/NB\",\"K/NB\",'Test 1.2'!E28)","v":"K/NB"},0,{"$f":"IFERROR(IF(E27=1,\"\",IF(E27=2,Notenskala!$D$9-H27,IF(E27=3,Notenskala!$D$8-H27,IF(E27=4,Notenskala!$D$7-H27,IF(E27=5,Notenskala!$D$6-H27))))),\"\")","v":false},{"$f":"IFERROR(IF(E27=1,H27-Notenskala!$C$8,IF(E27=2,H27-Notenskala!$C$7,IF(E27=3,H27-Notenskala!$C$6,IF(E27=4,H27-Notenskala!$C$5,IF(E27=5,\"\"))))),\"\")","v":false}]
[]
[null,null,null,null,null,null,null,"Zwei Tests",0.3,0.15,0.3,0.05,0.2,null,null,null,{"$f":"SUM(I29:M29)","v":1}]
[null,null,null,null,null,null,null,"Ein Test",0.35,0.2,0.35,0.1,null,null,null,null,{"$f":"SUM(I30:M30)","v":1}]
[null,null,null,null,null,null,null,"Kein Test",0.3,0.25,0.45,null,null,null,null,null,1]
[null,null,null,null,null,null,null,"MUSS immer 100 ergeben!"]
[null,null,null,null,null,null,null,"für Ursprungswerte --> runterscrollen!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"#Default"]
[null,null,null,null,null,null,null,"Zwei Tests",0.2,0.1,0.2,0.25,0.25]
[null,null,null,null,null,null,null,"Ein Test",0.2,0.15,0.25,0.4]
[null,null,null,null,null,null,null,"Kein Test",0.35,0.25,0.4]

{"sheet":"MA 1","index":4,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,"Nr.","Name","MA","Prozente","Stunden","Krank","Summe","2025-09-22","2025-10-13","2025-10-15","2025-10-20","2025-10-22","2025-11-03","2025-11-05","2025-11-10","2025-11-12","2025-11-17","2025-11-19","2025-11-24","2025-11-26","2026-02-04"]
[null,1,{"$f":"IF(Gesamtnote!C3=0,\"\",Gesamtnote!C3)","v":"Schüler 1"},{"$f":"IFERROR(VLOOKUP(E3,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},{"$f":"IFERROR(H3/F3,\"\")","v":0.88461538461538447},{"$f":"$D$30-G3","v":13},{"$f":"COUNTIF(I3:BE3,\"K\")","v":1},{"$f":"IF(SUM(I3:BE3)=0,\"\",SUM(I3:BE3))","v":11.499999999999998},1,1,0.9,0.9,0.8,0.8,0.8,0.8,"K",0.9,0.9,1,1,0.7]
[null,2,{"$f":"IF(Gesamtnote!C4=0,\"\",Gesamtnote!C4)","v":"Schüler 2"},{"$f":"IFERROR(VLOOKUP(E4,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},{"$f":"IFERROR(H4/F4,\"\")","v":1},14,{"$f":"COUNTIF(I4:BE4,\"K\")","v":0},{"$f":"IF(SUM(I4:BE4)=0,\"\",SUM(I4:BE4))","v":14},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,3,{"$f":"IF(Gesamtnote!C5=0,\"\",Gesamtnote!C5)","v":"Schüler 3"},{"$f":"IFERROR(VLOOKUP(E5,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.84999999999999987,14,0,11.899999999999999,1,0.9,0.8,0.8,0.9,0.7,0.9,1,1,0.6,1,0.7,1,0.6]
[null,4,{"$f":"IF(Gesamtnote!C6=0,\"\",Gesamtnote!C6)","v":"Schüler 4"},{"$f":"IFERROR(VLOOKUP(E6,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},1,13,1,13,1,1,1,"K",1,1,1,1,1,1,1,1,1,1]
[null,5,{"$f":"IF(Gesamtnote!C7=0,\"\",Gesamtnote!C7)","v":"Schüler 5"},{"$f":"IFERROR(VLOOKUP(E7,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.93846153846153846,13,1,12.2,1,0.8,0.9,0.9,0.8,1,0.8,1,1,1,1,1,1,"K"]
[null,6,{"$f":"IF(Gesamtnote!C8=0,\"\",Gesamtnote!C8)","v":"Schüler 6"},{"$f":"IFERROR(VLOOKUP(E8,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},1,14,0,14,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,7,{"$f":"IF(Gesamtnote!C9=0,\"\",Gesamtnote!C9)","v":"Schüler 7"},{"$f":"IFERROR(VLOOKUP(E9,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.82500000000000007,12,2,9.9,"K",0.8,0.7,0.7,0.8,0.9,0.8,"K",1,0.6,1,1,1,0.6]
[null,8,{"$f":"IF(Gesamtnote!C10=0,\"\",Gesamtnote!C10)","v":"Schüler 8"},{"$f":"IFERROR(VLOOKUP(E10,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.79285714285714282,14,0,11.1,0.8,0.7,0.7,0.9,0.6,0.7,0.8,0.8,1,0.6,1,0.8,1,0.7]
[null,9,{"$f":"IF(Gesamtnote!C11=0,\"\",Gesamtnote!C11)","v":"Schüler 9"},{"$f":"IFERROR(VLOOKUP(E11,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.82142857142857129,14,0,11.499999999999998,0.8,0.8,0.7,0.9,0.9,0.8,0.8,1,1,0.6,1,0.7,1,0.5]
[null,10,{"$f":"IF(Gesamtnote!C12=0,\"\",Gesamtnote!C12)","v":"Schüler 10"},{"$f":"IFERROR(VLOOKUP(E12,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.81428571428571417,14,0,11.399999999999999,0.8,0.7,0.6,0.7,0.7,0.8,0.6,0.8,1,1,1,1,1,0.7]
[null,11,{"$f":"IF(Gesamtnote!C13=0,\"\",Gesamtnote!C13)","v":"Schüler 11"},{"$f":"IFERROR(VLOOKUP(E13,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.8928571428571429,14,0,12.5,1,0.8,0.7,0.8,0.9,0.9,0.8,1,1,0.6,1,1,1,1]
[null,12,{"$f":"IF(Gesamtnote!C14=0,\"\",Gesamtnote!C14)","v":"Schüler 12"},{"$f":"IFERROR(VLOOKUP(E14,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.8928571428571429,14,0,12.5,1,0.9,0.8,0.8,0.9,0.8,0.8,1,1,1,1,1,1,0.5]
[null,13,{"$f":"IF(Gesamtnote!C15=0,\"\",Gesamtnote!C15)","v":"Schüler 13"},{"$f":"IFERROR(VLOOKUP(E15,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.7857142857142857,14,0,11,0.8,0.7,0.7,0.9,0.6,0.7,0.7,0.8,0.6,1,1,1,1,0.5]
[null,14,{"$f":"IF(Gesamtnote!C16=0,\"\",Gesamtnote!C16)","v":"Schüler 14"},{"$f":"IFERROR(VLOOKUP(E16,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.88571428571428579,14,0,12.4,1,0.8,0.7,0.9,0.9,0.9,0.9,1,0.9,0.6,1,0.9,0.9,1]
[null,15,{"$f":"IF(Gesamtnote!C17=0,\"\",Gesamtnote!C17)","v":"Schüler 15"},{"$f":"IFERROR(VLOOKUP(E17,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.97142857142857142,14,0,13.6,1,1,1,1,1,1,1,1,1,0.6,1,1,1,1]
[null,16,{"$f":"IF(Gesamtnote!C18=0,\"\",Gesamtnote!C18)","v":"Schüler 16"},{"$f":"IFERROR(VLOOKUP(E18,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.99230769230769234,13,1,12.9,1,"K",1,1,1,1,1,1,1,1,1,0.9,1,1]
[null,17,{"$f":"IF(Gesamtnote!C19=0,\"\",Gesamtnote!C19)","v":"Schüler 17"},{"$f":"IFERROR(VLOOKUP(E19,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.86153846153846148,13,1,11.2,"K",0.8,0.8,1,0.9,0.7,0.7,1,1,0.8,1,1,1,0.5]
[null,18,{"$f":"IF(Gesamtnote!C20=0,\"\",Gesamtnote!C20)","v":"Schüler 18"},{"$f":"IFERROR(VLOOKUP(E20,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.97857142857142865,14,0,13.700000000000001,1,1,1,1,1,1,1,1,1,1,1,0.8,1,0.9]
[null,19,{"$f":"IF(Gesamtnote!C21=0,\"\",Gesamtnote!C21)","v":"Schüler 19"},{"$f":"IFERROR(VLOOKUP(E21,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.84285714285714286,14,0,11.8,1,0.8,0.9,0.7,0.7,0.9,0.8,1,0.8,0.8,1,0.8,1,0.6]
[null,20,{"$f":"IF(Gesamtnote!C22=0,\"\",Gesamtnote!C22)","v":"Schüler 20"},{"$f":"IFERROR(VLOOKUP(E22,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},1,14,0,14,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,21,{"$f":"IF(Gesamtnote!C23=0,\"\",Gesamtnote!C23)","v":"Schüler 21"},{"$f":"IFERROR(VLOOKUP(E23,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.7857142857142857,14,0,11,0.8,0.7,0.8,0.6,0.8,0.8,0.7,0.8,0.8,0.7,1,1,1,0.5]
[null,22,{"$f":"IF(Gesamtnote!C24=0,\"\",Gesamtnote!C24)","v":"Schüler 22"},{"$f":"IFERROR(VLOOKUP(E24,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.8571428571428571,14,0,12,0.8,0.9,0.7,0.8,0.8,0.8,0.9,0.8,0.9,1,1,1,1,0.6]
[null,23,{"$f":"IF(Gesamtnote!C25=0,\"\",Gesamtnote!C25)","v":""},{"$f":"IFERROR(VLOOKUP(E25,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",14,0,""]
[null,24,{"$f":"IF(Gesamtnote!C26=0,\"\",Gesamtnote!C26)","v":""},{"$f":"IFERROR(VLOOKUP(E26,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",14,0,""]
[null,25,{"$f":"IF(Gesamtnote!C27=0,\"\",Gesamtnote!C27)","v":""},{"$f":"IFERROR(VLOOKUP(E27,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",14,0,""]
[null,null,"Ø",{"$f":"IFERROR(AVERAGE(D3:D27),\"\")","v":1.7727272727272727},{"$f":"IFERROR(AVERAGE(E3:E27),\"\")","v":0.89424325674325678},13.72,0.28000000000000003,12.231818181818182]
[]
[null,null,"Stunden bis jetzt",{"$f":"COUNTA(I2:BE2)","v":14}]
[]
[]
[null,null,"Sehr Gut",{"$f":"COUNTIF($D$3:$D$27,\"1\")","v":8}]
[null,null,"Gut",{"$f":"COUNTIF($D$3:$D$27,\"2\")","v":11}]
[null,null,"Befriedigend",{"$f":"COUNTIF($D$3:$D$27,\"3\")","v":3}]
[null,null,"Genügend",{"$f":"COUNTIF($D$3:$D$27,\"4\")","v":0}]
[null,null,"Nicht Genügend",{"$f":"COUNTIF($D$3:$D$27,\"5\")","v":0}]
[null,null,"K / Nicht Beurteilt",{"$f":"COUNTIF($D$3:$D$27,\"K/NB\")","v":0}]
[]
[null,null,"Positiv",{"$f":"IFERROR(SUM(D33:D36)/SUM(D33:D37),\"\")","v":1}]
[null,null,"Negativ",{"$f":"IFERROR(D37/SUM(D33:D37),\"\")","v":0}]

{"sheet":"Wdh 1","index":5,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,null,null,"Datum",null,null,"2025-09-22","2025-10-15","2025-11-22"]
[null,null,null,"Inhalt",null,null,"Demokratie","Referat Wien","Geschichte der EU","Migrationsströme"]
[null,null,null,"Punkte",null,null,5,5,10,12]
[null,"Nr.","Name","Wdh","Gesamt","Ges. Punkte"]
[null,1,{"$f":"'Semester 1'!C3","v":"Schüler 1"},{"$f":"IFERROR(VLOOKUP(E6,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},{"$f":"IFERROR(SUMIF(G6:R6,\"<>\",G6:R6)/F6,\"\")","v":0.88636363636363635},{"$f":"SUMIF(G6:R6,\"<>\",$G$4:$R$4)","v":22},3.5,4,null,12]
[null,2,{"$f":"'Semester 1'!C4","v":"Schüler 2"},{"$f":"IFERROR(VLOOKUP(E7,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},{"$f":"IFERROR(SUMIF(G7:R7,\"<>\",G7:R7)/F7,\"\")","v":1},{"$f":"SUMIF(G7:R7,\"<>\",$G$4:$R$4)","v":32},5,5,10,12]
[null,3,{"$f":"'Semester 1'!C5","v":"Schüler 3"},{"$f":"IFERROR(VLOOKUP(E8,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.81818181818181823,22,5,4,null,9]
[null,4,{"$f":"'Semester 1'!C6","v":"Schüler 4"},{"$f":"IFERROR(VLOOKUP(E9,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.9375,32,5,5,8,12]
[null,5,{"$f":"'Semester 1'!C7","v":"Schüler 5"},{"$f":"IFERROR(VLOOKUP(E10,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.734375,32,5,4,4,10.5]
[null,6,{"$f":"'Semester 1'!C8","v":"Schüler 6"},{"$f":"IFERROR(VLOOKUP(E11,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.9375,32,5,5,8,12]
[null,7,{"$f":"'Semester 1'!C9","v":"Schüler 7"},{"$f":"IFERROR(VLOOKUP(E12,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.87037037037037035,27,null,5,6.5,12]
[null,8,{"$f":"'Semester 1'!C10","v":"Schüler 8"},{"$f":"IFERROR(VLOOKUP(E13,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":4},0.625,32,2,4,3,11]
[null,9,{"$f":"'Semester 1'!C11","v":"Schüler 9"},{"$f":"IFERROR(VLOOKUP(E14,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.90909090909090906,22,4,4,null,12]
[null,10,{"$f":"'Semester 1'!C12","v":"Schüler 10"},{"$f":"IFERROR(VLOOKUP(E15,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":4},0.640625,32,0.5,2,7,11]
[null,11,{"$f":"'Semester 1'!C13","v":"Schüler 11"},{"$f":"IFERROR(VLOOKUP(E16,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.875,32,3,5,8,12]
[null,12,{"$f":"'Semester 1'!C14","v":"Schüler 12"},{"$f":"IFERROR(VLOOKUP(E17,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.96875,32,5,4,10,12]
[null,13,{"$f":"'Semester 1'!C15","v":"Schüler 13"},{"$f":"IFERROR(VLOOKUP(E18,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.65625,32,2,4,3,12]
[null,14,{"$f":"'Semester 1'!C16","v":"Schüler 14"},{"$f":"IFERROR(VLOOKUP(E19,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.84375,32,5,5,5,12]
[null,15,{"$f":"'Semester 1'!C17","v":"Schüler 15"},{"$f":"IFERROR(VLOOKUP(E20,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.9,20,5,5,8]
[null,16,{"$f":"'Semester 1'!C18","v":"Schüler 16"},{"$f":"IFERROR(VLOOKUP(E21,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},1,32,5,5,10,12]
[null,17,{"$f":"'Semester 1'!C19","v":"Schüler 17"},{"$f":"IFERROR(VLOOKUP(E22,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.88888888888888884,27,null,4,9,11]
[null,18,{"$f":"'Semester 1'!C20","v":"Schüler 18"},{"$f":"IFERROR(VLOOKUP(E23,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.90625,32,3,5,9,12]
[null,19,{"$f":"'Semester 1'!C21","v":"Schüler 19"},{"$f":"IFERROR(VLOOKUP(E24,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.75,32,4,5,4,11]
[null,20,{"$f":"'Semester 1'!C22","v":"Schüler 20"},{"$f":"IFERROR(VLOOKUP(E25,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.8125,32,3,5,8,10]
[null,21,{"$f":"'Semester 1'!C23","v":"Schüler 21"},{"$f":"IFERROR(VLOOKUP(E26,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.75,32,3,3,9,9]
[null,22,{"$f":"'Semester 1'!C24","v":"Schüler 22"},{"$f":"IFERROR(VLOOKUP(E27,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.78125,32,5,2,9,9]
[null,23,{"$f":"'Semester 1'!C25","v":""},{"$f":"IFERROR(VLOOKUP(E28,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,24,{"$f":"'Semester 1'!C26","v":""},{"$f":"IFERROR(VLOOKUP(E29,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,25,{"$f":"'Semester 1'!C27","v":""},{"$f":"IFERROR(VLOOKUP(E30,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,null,"Ø",{"$f":"IFERROR(AVERAGEIF(D6:D30,\">0\"),\"\")","v":2.1818181818181817},{"$f":"IFERROR(AVERAGEIF(E6:E30,\">0\"),\"\")","v":0.84052934649525568},29.636363636363637,3.9,4.2727272727272725,7.2894736842105265,11.214285714285714,"","","","","","","",""]

{"sheet":"Heft 1","index":6,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,"Nr.","Name","Heft","Summe","2025-11-12","Notizen","2025-01-20","Notizen","2025-01-29","Notizen","2025-01-20","Notizen"]
[null,1,{"$f":"'Semester 1'!C3","v":"Schüler 1"},{"$f":"IFERROR(VLOOKUP(E3,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},{"$f":"IFERROR(SUM(F3,H3)/COUNTA(F3,H3),\"\")","v":0.8},0.8,"Unterschrift WDH, Leistung, Gsk EU nicht vollständig"]
[null,2,{"$f":"'Semester 1'!C4","v":"Schüler 2"},{"$f":"IFERROR(VLOOKUP(E4,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},{"$f":"IFERROR(SUM(F4,H4)/COUNTA(F4,H4),\"\")","v":0.9},0.9]
[null,3,{"$f":"'Semester 1'!C5","v":"Schüler 3"},{"$f":"IFERROR(VLOOKUP(E5,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.7,0.7]
[null,4,{"$f":"'Semester 1'!C6","v":"Schüler 4"},{"$f":"IFERROR(VLOOKUP(E6,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.85,0.85,"Zettel einkleben, unterschriften"]
[null,5,{"$f":"'Semester 1'!C7","v":"Schüler 5"},{"$f":"IFERROR(VLOOKUP(E7,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.9,0.9,"EU Gsk nicht vollständig"]
[null,6,{"$f":"'Semester 1'!C8","v":"Schüler 6"},{"$f":"IFERROR(VLOOKUP(E8,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},1,1]
[null,7,{"$f":"'Semester 1'!C9","v":"Schüler 7"},{"$f":"IFERROR(VLOOKUP(E9,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.85,0.85,"zu spät, schriftbild"]
[null,8,{"$f":"'Semester 1'!C10","v":"Schüler 8"},{"$f":"IFERROR(VLOOKUP(E10,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.8,0.8,"Unterschrift WDH, Leistung, Gsk EU nicht vollständig"]
[null,9,{"$f":"'Semester 1'!C11","v":"Schüler 9"},{"$f":"IFERROR(VLOOKUP(E11,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.9,0.9,"EU Gsk nicht vollständig"]
[null,10,{"$f":"'Semester 1'!C12","v":"Schüler 10"},{"$f":"IFERROR(VLOOKUP(E12,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.85,0.85,"U wdh, gsk eu nicht fertig"]
[null,11,{"$f":"'Semester 1'!C13","v":"Schüler 11"},{"$f":"IFERROR(VLOOKUP(E13,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.95,0.95,"U wdh, "]
[null,12,{"$f":"'Semester 1'!C14","v":"Schüler 12"},{"$f":"IFERROR(VLOOKUP(E14,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.85,0.85,"Unterschrift, Geschichte nicht vollständig"]
[null,13,{"$f":"'Semester 1'!C15","v":"Schüler 13"},{"$f":"IFERROR(VLOOKUP(E15,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.8,0.8,"Unterschriften, GSK EU"]
[null,14,{"$f":"'Semester 1'!C16","v":"Schüler 14"},{"$f":"IFERROR(VLOOKUP(E16,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.95,0.95,"EU Gsk nicht vollständig"]
[null,15,{"$f":"'Semester 1'!C17","v":"Schüler 15"},{"$f":"IFERROR(VLOOKUP(E17,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},0.95,0.95,"U wdh, "]
[null,16,{"$f":"'Semester 1'!C18","v":"Schüler 16"},{"$f":"IFERROR(VLOOKUP(E18,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},1,1]
[null,17,{"$f":"'Semester 1'!C19","v":"Schüler 17"},{"$f":"IFERROR(VLOOKUP(E19,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.85,0.85,"Unterschrift, Geschrichte nicht vollständig"]
[null,18,{"$f":"'Semester 1'!C20","v":"Schüler 18"},{"$f":"IFERROR(VLOOKUP(E20,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.9,0.9,"Unterschriften "]
[null,19,{"$f":"'Semester 1'!C21","v":"Schüler 19"},{"$f":"IFERROR(VLOOKUP(E21,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.85,0.85,"Unterschrift, EU Geschichte"]
[null,20,{"$f":"'Semester 1'!C22","v":"Schüler 20"},{"$f":"IFERROR(VLOOKUP(E22,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":1},1,1]
[null,21,{"$f":"'Semester 1'!C23","v":"Schüler 21"},{"$f":"IFERROR(VLOOKUP(E23,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":2},0.85,0.85,"Unterschrift, Geschichte nicht vollständig"]
[null,22,{"$f":"'Semester 1'!C24","v":"Schüler 22"},{"$f":"IFERROR(VLOOKUP(E24,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":3},0.8,0.8]
[null,23,{"$f":"'Semester 1'!C25","v":""},{"$f":"IFERROR(VLOOKUP(E25,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,24,null,{"$f":"IFERROR(VLOOKUP(E26,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,25,null,{"$f":"IFERROR(VLOOKUP(E27,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]

{"sheet":"Test 1.1","index":7,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,null,"2025-11-19","Punkte",null,null,{"$f":"SUM(H2:N2)","v":16},3,5,5,3,null,null,null,null,"Verteilung:"]
["Gruppe","Nr.","Name","Test 1","Prozente","Leer","Summe","A","B","C","D","E","F","G",null,"Sehr Gut",{"$f":"COUNTIF($D$4:$D$28,\"1\")","v":7}]
[3,1,{"$f":"IF(Gesamtnote!C3=0,\"\",Gesamtnote!C3)","v":"Schüler 1"},{"$f":"IF(G4=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G4,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":1},{"$f":"IF(F4=FALSE,G4/$G$2,\"K/NB\")","v":0.9375},{"$f":"SUMPRODUCT(--(H4:L4<>\"\"))=0","v":false},{"$f":"IF(F4=FALSE,SUM(H4:N4),\"K/NB\")","v":15},3,4,5,3,null,null,null,null,"Gut",{"$f":"COUNTIF($D$4:$D$28,\"2\")","v":9}]
[2,2,{"$f":"IF(Gesamtnote!C4=0,\"\",Gesamtnote!C4)","v":"Schüler 2"},{"$f":"IF(G5=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G5,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":1},{"$f":"IF(F5=FALSE,G5/$G$2,\"K/NB\")","v":1},{"$f":"SUMPRODUCT(--(H5:L5<>\"\"))=0","v":false},{"$f":"IF(F5=FALSE,SUM(H5:N5),\"K/NB\")","v":16},3,5,5,3,null,null,null,null,"Befriedigend",{"$f":"COUNTIF($D$4:$D$28,\"3\")","v":4}]
[5,3,{"$f":"IF(Gesamtnote!C5=0,\"\",Gesamtnote!C5)","v":"Schüler 3"},4,0.5,{"$f":"SUMPRODUCT(--(H6:L6<>\"\"))=0","v":false},8,1,2,4,1,null,null,null,null,"Genügend",{"$f":"COUNTIF($D$4:$D$28,\"4\")","v":2}]
[3,4,{"$f":"IF(Gesamtnote!C6=0,\"\",Gesamtnote!C6)","v":"Schüler 4"},1,1,{"$f":"SUMPRODUCT(--(H7:L7<>\"\"))=0","v":false},16,3,5,5,3,null,null,null,null,"Nicht Genügend",{"$f":"COUNTIF($D$4:$D$28,\"5\")","v":0}]
[4,5,{"$f":"IF(Gesamtnote!C7=0,\"\",Gesamtnote!C7)","v":"Schüler 5"},2,0.8125,{"$f":"SUMPRODUCT(--(H8:L8<>\"\"))=0","v":false},13,2,4,5,2,null,null,null,null,"K / Nicht Beurteilt",{"$f":"COUNTIF($D$4:$D$28,\"K/NB\")","v":3}]
[3,6,{"$f":"IF(Gesamtnote!C8=0,\"\",Gesamtnote!C8)","v":"Schüler 6"},1,1,{"$f":"SUMPRODUCT(--(H9:L9<>\"\"))=0","v":false},16,3,5,5,3]
[1,7,{"$f":"IF(Gesamtnote!C9=0,\"\",Gesamtnote!C9)","v":"Schüler 7"},2,0.875,{"$f":"SUMPRODUCT(--(H10:L10<>\"\"))=0","v":false},14,3,4,5,2,null,null,null,null,"Positiv",{"$f":"IFERROR(SUM(Q3:Q6)/SUM(Q3:Q7),\"\")","v":1}]
[2,8,{"$f":"IF(Gesamtnote!C10=0,\"\",Gesamtnote!C10)","v":"Schüler 8"},2,0.8125,{"$f":"SUMPRODUCT(--(H11:L11<>\"\"))=0","v":false},13,2,4,4,3,null,null,null,null,"Negativ",{"$f":"IFERROR(Q7/SUM(Q3:Q7),\"\")","v":0}]
[1,9,{"$f":"IF(Gesamtnote!C11=0,\"\",Gesamtnote!C11)","v":"Schüler 9"},3,0.6875,{"$f":"SUMPRODUCT(--(H12:L12<>\"\"))=0","v":false},11,2,3,5,1]
[5,10,{"$f":"IF(Gesamtnote!C12=0,\"\",Gesamtnote!C12)","v":"Schüler 10"},2,0.8125,{"$f":"SUMPRODUCT(--(H13:L13<>\"\"))=0","v":false},13,2,4,5,2]
[1,11,{"$f":"IF(Gesamtnote!C13=0,\"\",Gesamtnote!C13)","v":"Schüler 11"},2,0.875,{"$f":"SUMPRODUCT(--(H14:L14<>\"\"))=0","v":false},14,2,5,5,2,null,null,null,null,"Notenschlüssel:","Von","Bis"]
[4,12,{"$f":"IF(Gesamtnote!C14=0,\"\",Gesamtnote!C14)","v":"Schüler 12"},2,0.8125,{"$f":"SUMPRODUCT(--(H15:L15<>\"\"))=0","v":false},13,1,5,5,2,null,null,null,null,1,{"$f":"G2","v":16},{"$f":"MROUND($G$2*Notenskala!$D$9,0.5)","v":14.5}]
[4,13,{"$f":"IF(Gesamtnote!C15=0,\"\",Gesamtnote!C15)","v":"Schüler 13"},2,0.8125,{"$f":"SUMPRODUCT(--(H16:L16<>\"\"))=0","v":false},13,3,4,4,2,null,null,null,null,2,{"$f":"R15-0.5","v":14},{"$f":"MROUND($G$2*Notenskala!$D$8,0.5)","v":13}]
[1,14,{"$f":"IF(Gesamtnote!C16=0,\"\",Gesamtnote!C16)","v":"Schüler 14"},1,0.9375,{"$f":"SUMPRODUCT(--(H17:L17<>\"\"))=0","v":false},15,2,5,5,3,null,null,null,null,3,{"$f":"R16-0.5","v":12.5},{"$f":"MROUND($G$2*Notenskala!$D$7,0.5)","v":10.5}]
[1,15,{"$f":"IF(Gesamtnote!C17=0,\"\",Gesamtnote!C17)","v":"Schüler 15"},2,0.875,{"$f":"SUMPRODUCT(--(H18:L18<>\"\"))=0","v":false},14,2,4,5,3,null,null,null,null,4,10,{"$f":"MROUND($G$2*Notenskala!$D$6,0.5)","v":8}]
[4,16,{"$f":"IF(Gesamtnote!C18=0,\"\",Gesamtnote!C18)","v":"Schüler 16"},2,0.875,{"$f":"SUMPRODUCT(--(H19:L19<>\"\"))=0","v":false},14,2,5,5,2,null,null,null,null,5,7.5,{"$f":"MROUND($G$2*Notenskala!$D$5,0.5)","v":0}]
[5,17,{"$f":"IF(Gesamtnote!C19=0,\"\",Gesamtnote!C19)","v":"Schüler 17"},4,0.5,{"$f":"SUMPRODUCT(--(H20:L20<>\"\"))=0","v":false},8,0,3,4,1]
[3,18,{"$f":"IF(Gesamtnote!C20=0,\"\",Gesamtnote!C20)","v":"Schüler 18"},1,0.9375,{"$f":"SUMPRODUCT(--(H21:L21<>\"\"))=0","v":false},15,3,5,4,3,null,null,null,null,"Kurzreferat EU"]
[2,19,{"$f":"IF(Gesamtnote!C21=0,\"\",Gesamtnote!C21)","v":"Schüler 19"},3,0.75,{"$f":"SUMPRODUCT(--(H22:L22<>\"\"))=0","v":false},12,2,3,4,3,null,null,null,null,"A","Foliendesign"]
[2,20,{"$f":"IF(Gesamtnote!C22=0,\"\",Gesamtnote!C22)","v":"Schüler 20"},1,0.9375,{"$f":"SUMPRODUCT(--(H23:L23<>\"\"))=0","v":false},15,3,5,5,2,null,null,null,null,"B","Vortrag"]
[5,21,{"$f":"IF(Gesamtnote!C23=0,\"\",Gesamtnote!C23)","v":"Schüler 21"},3,0.6875,{"$f":"SUMPRODUCT(--(H24:L24<>\"\"))=0","v":false},11,1,4,5,1,null,null,null,null,"C","Inhalt"]
[5,22,{"$f":"IF(Gesamtnote!C24=0,\"\",Gesamtnote!C24)","v":"Schüler 22"},3,0.6875,{"$f":"SUMPRODUCT(--(H25:L25<>\"\"))=0","v":false},11,0,4,5,2,null,null,null,null,"D","Anschaulichkeit / Reaktion auf Rückfragen"]
[null,23,{"$f":"IF(Gesamtnote!C25=0,\"\",Gesamtnote!C25)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H26:L26<>\"\"))=0","v":true},"K/NB"]
[null,24,{"$f":"IF(Gesamtnote!C26=0,\"\",Gesamtnote!C26)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H27:L27<>\"\"))=0","v":true},"K/NB"]
[null,25,{"$f":"IF(Gesamtnote!C27=0,\"\",Gesamtnote!C27)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H28:L28<>\"\"))=0","v":true},"K/NB"]
[null,null,"Ø",{"$f":"IFERROR(AVERAGEIF(D4:D28,\"<>\",D4:D28),\"\")","v":2.0454545454545454},{"$f":"IFERROR(AVERAGEIF(E4:E28,\"<>\",E4:E28),\"\")","v":0.82386363636363635},"",13.181818181818182,2.0454545454545454,4.1818181818181817,4.7272727272727275,2.2272727272727271,"","",""]

{"sheet":"Test 1.2","index":8,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,null,"2025-02-02","Punkte",null,null,{"$f":"SUM(H2:N2)","v":16},3,5,5,3,null,null,null,null,"Verteilung:"]
["Gruppe","Nr.","Name","Test 2","Prozente","Leer","Summe","A","B","C","D","E","F","G",null,"Sehr Gut",{"$f":"COUNTIF($D$4:$D$28,\"1\")","v":8}]
[5,1,{"$f":"IF(Gesamtnote!C3=0,\"\",Gesamtnote!C3)","v":"Schüler 1"},{"$f":"IF(G4=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G4,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":2},{"$f":"IF(F4=FALSE,G4/$G$2,\"K/NB\")","v":0.84375},{"$f":"SUMPRODUCT(--(H4:L4<>\"\"))=0","v":false},{"$f":"IF(F4=FALSE,SUM(H4:N4),\"K/NB\")","v":13.5},2,4.5,4,3,null,null,null,null,"Gut",{"$f":"COUNTIF($D$4:$D$28,\"2\")","v":5}]
[3,2,{"$f":"IF(Gesamtnote!C4=0,\"\",Gesamtnote!C4)","v":"Schüler 2"},{"$f":"IF(G5=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G5,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":1},{"$f":"IF(F5=FALSE,G5/$G$2,\"K/NB\")","v":0.96875},{"$f":"SUMPRODUCT(--(H5:L5<>\"\"))=0","v":false},{"$f":"IF(F5=FALSE,SUM(H5:N5),\"K/NB\")","v":15.5},3,5,4.5,3,null,null,null,null,"Befriedigend",{"$f":"COUNTIF($D$4:$D$28,\"3\")","v":7}]
[5,3,{"$f":"IF(Gesamtnote!C5=0,\"\",Gesamtnote!C5)","v":"Schüler 3"},2,0.84375,{"$f":"SUMPRODUCT(--(H6:L6<>\"\"))=0","v":false},13.5,2.5,4,4,3,null,null,null,null,"Genügend",{"$f":"COUNTIF($D$4:$D$28,\"4\")","v":2}]
[4,4,{"$f":"IF(Gesamtnote!C6=0,\"\",Gesamtnote!C6)","v":"Schüler 4"},1,0.96875,{"$f":"SUMPRODUCT(--(H7:L7<>\"\"))=0","v":false},15.5,2.5,5,5,3,null,null,null,null,"Nicht Genügend",{"$f":"COUNTIF($D$4:$D$28,\"5\")","v":0}]
[6,5,{"$f":"IF(Gesamtnote!C7=0,\"\",Gesamtnote!C7)","v":"Schüler 5"},3,0.78125,{"$f":"SUMPRODUCT(--(H8:L8<>\"\"))=0","v":false},12.5,2.5,4,4,2,null,null,null,null,"K / Nicht Beurteilt",{"$f":"COUNTIF($D$4:$D$28,\"K/NB\")","v":3}]
[4,6,{"$f":"IF(Gesamtnote!C8=0,\"\",Gesamtnote!C8)","v":"Schüler 6"},1,0.96875,{"$f":"SUMPRODUCT(--(H9:L9<>\"\"))=0","v":false},{"$f":"IF(F9=FALSE,SUM(H9:N9),\"K/NB\")","v":15.5},2.5,5,5,3]
[1,7,{"$f":"IF(Gesamtnote!C9=0,\"\",Gesamtnote!C9)","v":"Schüler 7"},3,0.78125,{"$f":"SUMPRODUCT(--(H10:L10<>\"\"))=0","v":false},12.5,2,4.5,4,2,null,null,null,null,"Positiv",{"$f":"IFERROR(SUM(Q3:Q6)/SUM(Q3:Q7),\"\")","v":1}]
[7,8,{"$f":"IF(Gesamtnote!C10=0,\"\",Gesamtnote!C10)","v":"Schüler 8"},4,0.5,{"$f":"SUMPRODUCT(--(H11:L11<>\"\"))=0","v":false},{"$f":"IF(F11=FALSE,SUM(H11:N11),\"K/NB\")","v":8},2,3,2,1,null,null,null,null,"Negativ",{"$f":"IFERROR(Q7/SUM(Q3:Q7),\"\")","v":0}]
[5,9,{"$f":"IF(Gesamtnote!C11=0,\"\",Gesamtnote!C11)","v":"Schüler 9"},4,0.625,{"$f":"SUMPRODUCT(--(H12:L12<>\"\"))=0","v":false},10,2,3,4,1]
[2,10,{"$f":"IF(Gesamtnote!C12=0,\"\",Gesamtnote!C12)","v":"Schüler 10"},3,0.78125,{"$f":"SUMPRODUCT(--(H13:L13<>\"\"))=0","v":false},12.5,3,4,3.5,2]
[1,11,{"$f":"IF(Gesamtnote!C13=0,\"\",Gesamtnote!C13)","v":"Schüler 11"},3,0.78125,{"$f":"SUMPRODUCT(--(H14:L14<>\"\"))=0","v":false},12.5,2.5,4.5,4,1.5,null,null,null,null,"Notenschlüssel:","Von","Bis"]
[6,12,{"$f":"IF(Gesamtnote!C14=0,\"\",Gesamtnote!C14)","v":"Schüler 12"},1,0.90625,{"$f":"SUMPRODUCT(--(H15:L15<>\"\"))=0","v":false},14.5,2.5,5,4,3,null,null,null,null,1,{"$f":"G2","v":16},{"$f":"MROUND($G$2*Notenskala!$D$9,0.5)","v":14.5}]
[6,13,{"$f":"IF(Gesamtnote!C15=0,\"\",Gesamtnote!C15)","v":"Schüler 13"},2,0.8125,{"$f":"SUMPRODUCT(--(H16:L16<>\"\"))=0","v":false},13,2.5,3.5,4,3,null,null,null,null,2,{"$f":"R15-0.5","v":14},{"$f":"MROUND($G$2*Notenskala!$D$8,0.5)","v":13}]
[1,14,{"$f":"IF(Gesamtnote!C16=0,\"\",Gesamtnote!C16)","v":"Schüler 14"},2,0.84375,{"$f":"SUMPRODUCT(--(H17:L17<>\"\"))=0","v":false},13.5,2.5,5,4,2,null,null,null,null,3,{"$f":"R16-0.5","v":12.5},{"$f":"MROUND($G$2*Notenskala!$D$7,0.5)","v":10.5}]
[3,15,{"$f":"IF(Gesamtnote!C17=0,\"\",Gesamtnote!C17)","v":"Schüler 15"},1,1,{"$f":"SUMPRODUCT(--(H18:L18<>\"\"))=0","v":false},16,3,5,5,3,null,null,null,null,4,{"$f":"R17-0.5","v":10},{"$f":"MROUND($G$2*Notenskala!$D$6,0.5)","v":8}]
[3,16,{"$f":"IF(Gesamtnote!C18=0,\"\",Gesamtnote!C18)","v":"Schüler 16"},1,1,{"$f":"SUMPRODUCT(--(H19:L19<>\"\"))=0","v":false},16,3,5,5,3,null,null,null,null,5,{"$f":"R18-0.5","v":7.5},{"$f":"MROUND($G$2*Notenskala!$D$5,0.5)","v":0}]
[2,17,{"$f":"IF(Gesamtnote!C19=0,\"\",Gesamtnote!C19)","v":"Schüler 17"},3,0.71875,{"$f":"SUMPRODUCT(--(H20:L20<>\"\"))=0","v":false},11.5,3,3,4,1.5]
[3,18,{"$f":"IF(Gesamtnote!C20=0,\"\",Gesamtnote!C20)","v":"Schüler 18"},1,1,{"$f":"SUMPRODUCT(--(H21:L21<>\"\"))=0","v":false},16,3,5,5,3,null,null,null,null,"A","Foliendesign"]
[3,19,{"$f":"IF(Gesamtnote!C21=0,\"\",Gesamtnote!C21)","v":"Schüler 19"},2,0.84375,{"$f":"SUMPRODUCT(--(H22:L22<>\"\"))=0","v":false},13.5,3,4.5,4,2,null,null,null,null,"B","Vortrag"]
[4,20,{"$f":"IF(Gesamtnote!C22=0,\"\",Gesamtnote!C22)","v":"Schüler 20"},1,0.90625,{"$f":"SUMPRODUCT(--(H23:L23<>\"\"))=0","v":false},14.5,2.5,4,5,3,null,null,null,null,"C","Inhalt"]
[2,21,{"$f":"IF(Gesamtnote!C23=0,\"\",Gesamtnote!C23)","v":"Schüler 21"},3,0.65625,{"$f":"SUMPRODUCT(--(H24:L24<>\"\"))=0","v":false},10.5,3,2.5,3,2,null,null,null,null,"D","Anschaulichkeit / Reaktion auf Rückfragen"]
[5,22,{"$f":"IF(Gesamtnote!C24=0,\"\",Gesamtnote!C24)","v":"Schüler 22"},{"$f":"IF(G25=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G25,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":3},0.78125,{"$f":"SUMPRODUCT(--(H25:L25<>\"\"))=0","v":false},12.5,2.5,4,4,2]
[null,23,{"$f":"IF(Gesamtnote!C25=0,\"\",Gesamtnote!C25)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H26:L26<>\"\"))=0","v":true},"K/NB"]
[null,24,{"$f":"IF(Gesamtnote!C26=0,\"\",Gesamtnote!C26)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H27:L27<>\"\"))=0","v":true},"K/NB"]
[null,25,{"$f":"IF(Gesamtnote!C27=0,\"\",Gesamtnote!C27)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H28:L28<>\"\"))=0","v":true},"K/NB"]
[null,null,"Ø",{"$f":"IFERROR(AVERAGEIF(D4:D28,\"<>\",D4:D28),\"\")","v":2.1363636363636362},{"$f":"IFERROR(AVERAGEIF(E4:E28,\"<>\",E4:E28),\"\")","v":0.83238636363636365},"",13.318181818181818,2.5909090909090908,4.2272727272727275,4.1363636363636367,2.3636363636363638,"","",""]

{"sheet":"Semester 2","index":9,"n_rows":53,"n_cols":32,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,"Nr.","Name","S2 Lehrer","Note","h","i","Gesamt","MA","Heft","Wdh","Test 1","Test 2","Test gemacht?","h","i",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B4","v":"Nicht Beurteilt"},{"$f":"Notenskala!C4","v":"K/NB"},{"$f":"Notenskala!D4","v":"K/NB"},{"$f":"Notenskala!E4","v":"K/NB"}]
[null,1,{"$f":"IF(Gesamtnote!C3=0,\"\",Gesamtnote!C3)","v":"Schüler 1"},null,{"$f":"IFERROR(IF(H3=0,\"\",VLOOKUP(H3,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""},{"$f":"IF(O3<2%,\"h\",IF(O3<4%,\"k\",\" \"))","v":" "},{"$f":"IF(P3<2%,\"i\",IF(P3<4%,\"m\",\" \"))","v":" "},{"$f":"IFERROR(_xlfn.IFS(N3=2,SUMPRODUCT(I3:M3,$I$29:$M$29)/SUM($I$29:$M$29),N3=1,SUMPRODUCT(I3:L3,$I$30:$L$30)/SUM($I$30:$L$30),N3=0,SUMPRODUCT(I3:K3,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E3","v":""},{"$f":"'Heft 2'!E3","v":""},{"$f":"'Wdh 2'!E6","v":""},{"$f":"'Test 2.1'!E4","v":"K/NB"},{"$f":"'Test 2.2'!E4","v":"K/NB"},{"$f":"COUNT(L3:M3)","v":0},{"$f":"IFERROR(IF(E3=1,\"\",IF(E3=2,Notenskala!$D$9-H3,IF(E3=3,Notenskala!$D$8-H3,IF(E3=4,Notenskala!$D$7-H3,IF(E3=5,Notenskala!$D$6-H3))))),\"\")","v":false},{"$f":"IFERROR(IF(E3=1,H3-Notenskala!$C$8,IF(E3=2,H3-Notenskala!$C$7,IF(E3=3,H3-Notenskala!$C$6,IF(E3=4,H3-Notenskala!$C$5,IF(E3=5,\"\"))))),\"\")","v":false},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B5","v":"Nicht Genügend"},{"$f":"Notenskala!C5","v":0.49990000000000001},{"$f":"Notenskala!D5","v":0},{"$f":"Notenskala!E5","v":5}]
[null,2,{"$f":"IF(Gesamtnote!C4=0,\"\",Gesamtnote!C4)","v":"Schüler 2"},null,{"$f":"IFERROR(IF(H4=0,\"\",VLOOKUP(H4,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N4=2,SUMPRODUCT(I4:M4,$I$29:$M$29)/SUM($I$29:$M$29),N4=1,SUMPRODUCT(I4:L4,$I$30:$L$30)/SUM($I$30:$L$30),N4=0,SUMPRODUCT(I4:K4,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E4","v":""},{"$f":"'Heft 2'!E4","v":""},{"$f":"'Wdh 2'!E7","v":""},{"$f":"'Test 2.1'!E5","v":"K/NB"},{"$f":"'Test 2.2'!E5","v":"K/NB"},{"$f":"COUNT(L4:M4)","v":0},{"$f":"IFERROR(IF(E4=1,\"\",IF(E4=2,Notenskala!$D$9-H4,IF(E4=3,Notenskala!$D$8-H4,IF(E4=4,Notenskala!$D$7-H4,IF(E4=5,Notenskala!$D$6-H4))))),\"\")","v":false},{"$f":"IFERROR(IF(E4=1,H4-Notenskala!$C$8,IF(E4=2,H4-Notenskala!$C$7,IF(E4=3,H4-Notenskala!$C$6,IF(E4=4,H4-Notenskala!$C$5,IF(E4=5,\"\"))))),\"\")","v":false},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B6","v":"Genügend"},{"$f":"Notenskala!C6","v":0.64990000000000003},{"$f":"Notenskala!D6","v":0.5},{"$f":"Notenskala!E6","v":4}]
[null,3,{"$f":"IF(Gesamtnote!C5=0,\"\",Gesamtnote!C5)","v":"Schüler 3"},null,{"$f":"IFERROR(IF(H5=0,\"\",VLOOKUP(H5,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N5=2,SUMPRODUCT(I5:M5,$I$29:$M$29)/SUM($I$29:$M$29),N5=1,SUMPRODUCT(I5:L5,$I$30:$L$30)/SUM($I$30:$L$30),N5=0,SUMPRODUCT(I5:K5,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E5","v":""},{"$f":"'Heft 2'!E5","v":""},{"$f":"'Wdh 2'!E8","v":""},{"$f":"'Test 2.1'!E6","v":"K/NB"},{"$f":"'Test 2.2'!E6","v":"K/NB"},0,{"$f":"IFERROR(IF(E5=1,\"\",IF(E5=2,Notenskala!$D$9-H5,IF(E5=3,Notenskala!$D$8-H5,IF(E5=4,Notenskala!$D$7-H5,IF(E5=5,Notenskala!$D$6-H5))))),\"\")","v":false},{"$f":"IFERROR(IF(E5=1,H5-Notenskala!$C$8,IF(E5=2,H5-Notenskala!$C$7,IF(E5=3,H5-Notenskala!$C$6,IF(E5=4,H5-Notenskala!$C$5,IF(E5=5,\"\"))))),\"\")","v":false},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B7","v":"Befriedigend"},{"$f":"Notenskala!C7","v":0.80990000000000006},{"$f":"Notenskala!D7","v":0.65},{"$f":"Notenskala!E7","v":3}]
[null,4,{"$f":"IF(Gesamtnote!C6=0,\"\",Gesamtnote!C6)","v":"Schüler 4"},null,{"$f":"IFERROR(IF(H6=0,\"\",VLOOKUP(H6,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N6=2,SUMPRODUCT(I6:M6,$I$29:$M$29)/SUM($I$29:$M$29),N6=1,SUMPRODUCT(I6:L6,$I$30:$L$30)/SUM($I$30:$L$30),N6=0,SUMPRODUCT(I6:K6,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E6","v":""},{"$f":"'Heft 2'!E6","v":""},{"$f":"'Wdh 2'!E9","v":""},{"$f":"'Test 2.1'!E7","v":"K/NB"},{"$f":"'Test 2.2'!E7","v":"K/NB"},0,{"$f":"IFERROR(IF(E6=1,\"\",IF(E6=2,Notenskala!$D$9-H6,IF(E6=3,Notenskala!$D$8-H6,IF(E6=4,Notenskala!$D$7-H6,IF(E6=5,Notenskala!$D$6-H6))))),\"\")","v":false},{"$f":"IFERROR(IF(E6=1,H6-Notenskala!$C$8,IF(E6=2,H6-Notenskala!$C$7,IF(E6=3,H6-Notenskala!$C$6,IF(E6=4,H6-Notenskala!$C$5,IF(E6=5,\"\"))))),\"\")","v":false},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B8","v":"Gut"},{"$f":"Notenskala!C8","v":0.90990000000000004},{"$f":"Notenskala!D8","v":0.81},{"$f":"Notenskala!E8","v":2}]
[null,5,{"$f":"IF(Gesamtnote!C7=0,\"\",Gesamtnote!C7)","v":"Schüler 5"},null,{"$f":"IFERROR(IF(H7=0,\"\",VLOOKUP(H7,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N7=2,SUMPRODUCT(I7:M7,$I$29:$M$29)/SUM($I$29:$M$29),N7=1,SUMPRODUCT(I7:L7,$I$30:$L$30)/SUM($I$30:$L$30),N7=0,SUMPRODUCT(I7:K7,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E7","v":""},{"$f":"'Heft 2'!E7","v":""},{"$f":"'Wdh 2'!E10","v":""},{"$f":"'Test 2.1'!E8","v":"K/NB"},{"$f":"'Test 2.2'!E8","v":"K/NB"},0,{"$f":"IFERROR(IF(E7=1,\"\",IF(E7=2,Notenskala!$D$9-H7,IF(E7=3,Notenskala!$D$8-H7,IF(E7=4,Notenskala!$D$7-H7,IF(E7=5,Notenskala!$D$6-H7))))),\"\")","v":false},{"$f":"IFERROR(IF(E7=1,H7-Notenskala!$C$8,IF(E7=2,H7-Notenskala!$C$7,IF(E7=3,H7-Notenskala!$C$6,IF(E7=4,H7-Notenskala!$C$5,IF(E7=5,\"\"))))),\"\")","v":false},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notenskala!B9","v":"Sehr Gut"},{"$f":"Notenskala!C9","v":1},{"$f":"Notenskala!D9","v":0.91},{"$f":"Notenskala!E9","v":1}]
[null,6,{"$f":"IF(Gesamtnote!C8=0,\"\",Gesamtnote!C8)","v":"Schüler 6"},null,{"$f":"IFERROR(IF(H8=0,\"\",VLOOKUP(H8,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N8=2,SUMPRODUCT(I8:M8,$I$29:$M$29)/SUM($I$29:$M$29),N8=1,SUMPRODUCT(I8:L8,$I$30:$L$30)/SUM($I$30:$L$30),N8=0,SUMPRODUCT(I8:K8,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E8","v":""},{"$f":"'Heft 2'!E8","v":""},{"$f":"'Wdh 2'!E11","v":""},{"$f":"'Test 2.1'!E9","v":"K/NB"},{"$f":"'Test 2.2'!E9","v":"K/NB"},0,{"$f":"IFERROR(IF(E8=1,\"\",IF(E8=2,Notenskala!$D$9-H8,IF(E8=3,Notenskala!$D$8-H8,IF(E8=4,Notenskala!$D$7-H8,IF(E8=5,Notenskala!$D$6-H8))))),\"\")","v":false},{"$f":"IFERROR(IF(E8=1,H8-Notenskala!$C$8,IF(E8=2,H8-Notenskala!$C$7,IF(E8=3,H8-Notenskala!$C$6,IF(E8=4,H8-Notenskala!$C$5,IF(E8=5,\"\"))))),\"\")","v":false}]
[null,7,{"$f":"IF(Gesamtnote!C9=0,\"\",Gesamtnote!C9)","v":"Schüler 7"},null,{"$f":"IFERROR(IF(H9=0,\"\",VLOOKUP(H9,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N9=2,SUMPRODUCT(I9:M9,$I$29:$M$29)/SUM($I$29:$M$29),N9=1,SUMPRODUCT(I9:L9,$I$30:$L$30)/SUM($I$30:$L$30),N9=0,SUMPRODUCT(I9:K9,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E9","v":""},{"$f":"'Heft 2'!E9","v":""},{"$f":"'Wdh 2'!E12","v":""},{"$f":"'Test 2.1'!E10","v":"K/NB"},{"$f":"'Test 2.2'!E10","v":"K/NB"},0,{"$f":"IFERROR(IF(E9=1,\"\",IF(E9=2,Notenskala!$D$9-H9,IF(E9=3,Notenskala!$D$8-H9,IF(E9=4,Notenskala!$D$7-H9,IF(E9=5,Notenskala!$D$6-H9))))),\"\")","v":false},{"$f":"IFERROR(IF(E9=1,H9-Notenskala!$C$8,IF(E9=2,H9-Notenskala!$C$7,IF(E9=3,H9-Notenskala!$C$6,IF(E9=4,H9-Notenskala!$C$5,IF(E9=5,\"\"))))),\"\")","v":false}]
[null,8,{"$f":"IF(Gesamtnote!C10=0,\"\",Gesamtnote!C10)","v":"Schüler 8"},null,{"$f":"IFERROR(IF(H10=0,\"\",VLOOKUP(H10,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N10=2,SUMPRODUCT(I10:M10,$I$29:$M$29)/SUM($I$29:$M$29),N10=1,SUMPRODUCT(I10:L10,$I$30:$L$30)/SUM($I$30:$L$30),N10=0,SUMPRODUCT(I10:K10,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E10","v":""},{"$f":"'Heft 2'!E10","v":""},{"$f":"'Wdh 2'!E13","v":""},{"$f":"'Test 2.1'!E11","v":"K/NB"},{"$f":"'Test 2.2'!E11","v":"K/NB"},0,{"$f":"IFERROR(IF(E10=1,\"\",IF(E10=2,Notenskala!$D$9-H10,IF(E10=3,Notenskala!$D$8-H10,IF(E10=4,Notenskala!$D$7-H10,IF(E10=5,Notenskala!$D$6-H10))))),\"\")","v":false},{"$f":"IFERROR(IF(E10=1,H10-Notenskala!$C$8,IF(E10=2,H10-Notenskala!$C$7,IF(E10=3,H10-Notenskala!$C$6,IF(E10=4,H10-Notenskala!$C$5,IF(E10=5,\"\"))))),\"\")","v":false}]
[null,9,{"$f":"IF(Gesamtnote!C11=0,\"\",Gesamtnote!C11)","v":"Schüler 9"},null,{"$f":"IFERROR(IF(H11=0,\"\",VLOOKUP(H11,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N11=2,SUMPRODUCT(I11:M11,$I$29:$M$29)/SUM($I$29:$M$29),N11=1,SUMPRODUCT(I11:L11,$I$30:$L$30)/SUM($I$30:$L$30),N11=0,SUMPRODUCT(I11:K11,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E11","v":""},{"$f":"'Heft 2'!E11","v":""},{"$f":"'Wdh 2'!E14","v":""},{"$f":"'Test 2.1'!E12","v":"K/NB"},{"$f":"'Test 2.2'!E12","v":"K/NB"},0,{"$f":"IFERROR(IF(E11=1,\"\",IF(E11=2,Notenskala!$D$9-H11,IF(E11=3,Notenskala!$D$8-H11,IF(E11=4,Notenskala!$D$7-H11,IF(E11=5,Notenskala!$D$6-H11))))),\"\")","v":false},{"$f":"IFERROR(IF(E11=1,H11-Notenskala!$C$8,IF(E11=2,H11-Notenskala!$C$7,IF(E11=3,H11-Notenskala!$C$6,IF(E11=4,H11-Notenskala!$C$5,IF(E11=5,\"\"))))),\"\")","v":false}]
[null,10,{"$f":"IF(Gesamtnote!C12=0,\"\",Gesamtnote!C12)","v":"Schüler 10"},null,{"$f":"IFERROR(IF(H12=0,\"\",VLOOKUP(H12,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N12=2,SUMPRODUCT(I12:M12,$I$29:$M$29)/SUM($I$29:$M$29),N12=1,SUMPRODUCT(I12:L12,$I$30:$L$30)/SUM($I$30:$L$30),N12=0,SUMPRODUCT(I12:K12,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E12","v":""},{"$f":"'Heft 2'!E12","v":""},{"$f":"'Wdh 2'!E15","v":""},{"$f":"'Test 2.1'!E13","v":"K/NB"},{"$f":"'Test 2.2'!E13","v":"K/NB"},0,{"$f":"IFERROR(IF(E12=1,\"\",IF(E12=2,Notenskala!$D$9-H12,IF(E12=3,Notenskala!$D$8-H12,IF(E12=4,Notenskala!$D$7-H12,IF(E12=5,Notenskala!$D$6-H12))))),\"\")","v":false},{"$f":"IFERROR(IF(E12=1,H12-Notenskala!$C$8,IF(E12=2,H12-Notenskala!$C$7,IF(E12=3,H12-Notenskala!$C$6,IF(E12=4,H12-Notenskala!$C$5,IF(E12=5,\"\"))))),\"\")","v":false}]
[null,11,{"$f":"IF(Gesamtnote!C13=0,\"\",Gesamtnote!C13)","v":"Schüler 11"},null,{"$f":"IFERROR(IF(H13=0,\"\",VLOOKUP(H13,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N13=2,SUMPRODUCT(I13:M13,$I$29:$M$29)/SUM($I$29:$M$29),N13=1,SUMPRODUCT(I13:L13,$I$30:$L$30)/SUM($I$30:$L$30),N13=0,SUMPRODUCT(I13:K13,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E13","v":""},{"$f":"'Heft 2'!E13","v":""},{"$f":"'Wdh 2'!E16","v":""},{"$f":"'Test 2.1'!E14","v":"K/NB"},{"$f":"'Test 2.2'!E14","v":"K/NB"},0,{"$f":"IFERROR(IF(E13=1,\"\",IF(E13=2,Notenskala!$D$9-H13,IF(E13=3,Notenskala!$D$8-H13,IF(E13=4,Notenskala!$D$7-H13,IF(E13=5,Notenskala!$D$6-H13))))),\"\")","v":false},{"$f":"IFERROR(IF(E13=1,H13-Notenskala!$C$8,IF(E13=2,H13-Notenskala!$C$7,IF(E13=3,H13-Notenskala!$C$6,IF(E13=4,H13-Notenskala!$C$5,IF(E13=5,\"\"))))),\"\")","v":false}]
[null,12,{"$f":"IF(Gesamtnote!C14=0,\"\",Gesamtnote!C14)","v":"Schüler 12"},null,{"$f":"IFERROR(IF(H14=0,\"\",VLOOKUP(H14,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N14=2,SUMPRODUCT(I14:M14,$I$29:$M$29)/SUM($I$29:$M$29),N14=1,SUMPRODUCT(I14:L14,$I$30:$L$30)/SUM($I$30:$L$30),N14=0,SUMPRODUCT(I14:K14,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E14","v":""},{"$f":"'Heft 2'!E14","v":""},{"$f":"'Wdh 2'!E17","v":""},{"$f":"'Test 2.1'!E15","v":"K/NB"},{"$f":"'Test 2.2'!E15","v":"K/NB"},0,{"$f":"IFERROR(IF(E14=1,\"\",IF(E14=2,Notenskala!$D$9-H14,IF(E14=3,Notenskala!$D$8-H14,IF(E14=4,Notenskala!$D$7-H14,IF(E14=5,Notenskala!$D$6-H14))))),\"\")","v":false},{"$f":"IFERROR(IF(E14=1,H14-Notenskala!$C$8,IF(E14=2,H14-Notenskala!$C$7,IF(E14=3,H14-Notenskala!$C$6,IF(E14=4,H14-Notenskala!$C$5,IF(E14=5,\"\"))))),\"\")","v":false}]
[null,13,{"$f":"IF(Gesamtnote!C15=0,\"\",Gesamtnote!C15)","v":"Schüler 13"},null,{"$f":"IFERROR(IF(H15=0,\"\",VLOOKUP(H15,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N15=2,SUMPRODUCT(I15:M15,$I$29:$M$29)/SUM($I$29:$M$29),N15=1,SUMPRODUCT(I15:L15,$I$30:$L$30)/SUM($I$30:$L$30),N15=0,SUMPRODUCT(I15:K15,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E15","v":""},{"$f":"'Heft 2'!E15","v":""},{"$f":"'Wdh 2'!E18","v":""},{"$f":"'Test 2.1'!E16","v":"K/NB"},{"$f":"'Test 2.2'!E16","v":"K/NB"},0,{"$f":"IFERROR(IF(E15=1,\"\",IF(E15=2,Notenskala!$D$9-H15,IF(E15=3,Notenskala!$D$8-H15,IF(E15=4,Notenskala!$D$7-H15,IF(E15=5,Notenskala!$D$6-H15))))),\"\")","v":false},{"$f":"IFERROR(IF(E15=1,H15-Notenskala!$C$8,IF(E15=2,H15-Notenskala!$C$7,IF(E15=3,H15-Notenskala!$C$6,IF(E15=4,H15-Notenskala!$C$5,IF(E15=5,\"\"))))),\"\")","v":false}]
[null,14,{"$f":"IF(Gesamtnote!C16=0,\"\",Gesamtnote!C16)","v":"Schüler 14"},null,{"$f":"IFERROR(IF(H16=0,\"\",VLOOKUP(H16,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N16=2,SUMPRODUCT(I16:M16,$I$29:$M$29)/SUM($I$29:$M$29),N16=1,SUMPRODUCT(I16:L16,$I$30:$L$30)/SUM($I$30:$L$30),N16=0,SUMPRODUCT(I16:K16,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E16","v":""},{"$f":"'Heft 2'!E16","v":""},{"$f":"'Wdh 2'!E19","v":""},{"$f":"'Test 2.1'!E17","v":"K/NB"},{"$f":"'Test 2.2'!E17","v":"K/NB"},0,{"$f":"IFERROR(IF(E16=1,\"\",IF(E16=2,Notenskala!$D$9-H16,IF(E16=3,Notenskala!$D$8-H16,IF(E16=4,Notenskala!$D$7-H16,IF(E16=5,Notenskala!$D$6-H16))))),\"\")","v":false},{"$f":"IFERROR(IF(E16=1,H16-Notenskala!$C$8,IF(E16=2,H16-Notenskala!$C$7,IF(E16=3,H16-Notenskala!$C$6,IF(E16=4,H16-Notenskala!$C$5,IF(E16=5,\"\"))))),\"\")","v":false}]
[null,15,{"$f":"IF(Gesamtnote!C17=0,\"\",Gesamtnote!C17)","v":"Schüler 15"},null,{"$f":"IFERROR(IF(H17=0,\"\",VLOOKUP(H17,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N17=2,SUMPRODUCT(I17:M17,$I$29:$M$29)/SUM($I$29:$M$29),N17=1,SUMPRODUCT(I17:L17,$I$30:$L$30)/SUM($I$30:$L$30),N17=0,SUMPRODUCT(I17:K17,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E17","v":""},{"$f":"'Heft 2'!E17","v":""},{"$f":"'Wdh 2'!E20","v":""},{"$f":"'Test 2.1'!E18","v":"K/NB"},{"$f":"'Test 2.2'!E18","v":"K/NB"},0,{"$f":"IFERROR(IF(E17=1,\"\",IF(E17=2,Notenskala!$D$9-H17,IF(E17=3,Notenskala!$D$8-H17,IF(E17=4,Notenskala!$D$7-H17,IF(E17=5,Notenskala!$D$6-H17))))),\"\")","v":false},{"$f":"IFERROR(IF(E17=1,H17-Notenskala!$C$8,IF(E17=2,H17-Notenskala!$C$7,IF(E17=3,H17-Notenskala!$C$6,IF(E17=4,H17-Notenskala!$C$5,IF(E17=5,\"\"))))),\"\")","v":false}]
[null,16,{"$f":"IF(Gesamtnote!C18=0,\"\",Gesamtnote!C18)","v":"Schüler 16"},null,{"$f":"IFERROR(IF(H18=0,\"\",VLOOKUP(H18,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N18=2,SUMPRODUCT(I18:M18,$I$29:$M$29)/SUM($I$29:$M$29),N18=1,SUMPRODUCT(I18:L18,$I$30:$L$30)/SUM($I$30:$L$30),N18=0,SUMPRODUCT(I18:K18,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E18","v":""},{"$f":"'Heft 2'!E18","v":""},{"$f":"'Wdh 2'!E21","v":""},{"$f":"'Test 2.1'!E19","v":"K/NB"},{"$f":"'Test 2.2'!E19","v":"K/NB"},0,{"$f":"IFERROR(IF(E18=1,\"\",IF(E18=2,Notenskala!$D$9-H18,IF(E18=3,Notenskala!$D$8-H18,IF(E18=4,Notenskala!$D$7-H18,IF(E18=5,Notenskala!$D$6-H18))))),\"\")","v":false},{"$f":"IFERROR(IF(E18=1,H18-Notenskala!$C$8,IF(E18=2,H18-Notenskala!$C$7,IF(E18=3,H18-Notenskala!$C$6,IF(E18=4,H18-Notenskala!$C$5,IF(E18=5,\"\"))))),\"\")","v":false}]
[null,17,{"$f":"IF(Gesamtnote!C19=0,\"\",Gesamtnote!C19)","v":"Schüler 17"},null,{"$f":"IFERROR(IF(H19=0,\"\",VLOOKUP(H19,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N19=2,SUMPRODUCT(I19:M19,$I$29:$M$29)/SUM($I$29:$M$29),N19=1,SUMPRODUCT(I19:L19,$I$30:$L$30)/SUM($I$30:$L$30),N19=0,SUMPRODUCT(I19:K19,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E19","v":""},{"$f":"'Heft 2'!E19","v":""},{"$f":"'Wdh 2'!E22","v":""},{"$f":"'Test 2.1'!E20","v":"K/NB"},{"$f":"'Test 2.2'!E20","v":"K/NB"},0,{"$f":"IFERROR(IF(E19=1,\"\",IF(E19=2,Notenskala!$D$9-H19,IF(E19=3,Notenskala!$D$8-H19,IF(E19=4,Notenskala!$D$7-H19,IF(E19=5,Notenskala!$D$6-H19))))),\"\")","v":false},{"$f":"IFERROR(IF(E19=1,H19-Notenskala!$C$8,IF(E19=2,H19-Notenskala!$C$7,IF(E19=3,H19-Notenskala!$C$6,IF(E19=4,H19-Notenskala!$C$5,IF(E19=5,\"\"))))),\"\")","v":false}]
[null,18,{"$f":"IF(Gesamtnote!C20=0,\"\",Gesamtnote!C20)","v":"Schüler 18"},null,{"$f":"IFERROR(IF(H20=0,\"\",VLOOKUP(H20,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N20=2,SUMPRODUCT(I20:M20,$I$29:$M$29)/SUM($I$29:$M$29),N20=1,SUMPRODUCT(I20:L20,$I$30:$L$30)/SUM($I$30:$L$30),N20=0,SUMPRODUCT(I20:K20,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E20","v":""},{"$f":"'Heft 2'!E20","v":""},{"$f":"'Wdh 2'!E23","v":""},{"$f":"'Test 2.1'!E21","v":"K/NB"},{"$f":"'Test 2.2'!E21","v":"K/NB"},0,{"$f":"IFERROR(IF(E20=1,\"\",IF(E20=2,Notenskala!$D$9-H20,IF(E20=3,Notenskala!$D$8-H20,IF(E20=4,Notenskala!$D$7-H20,IF(E20=5,Notenskala!$D$6-H20))))),\"\")","v":false},{"$f":"IFERROR(IF(E20=1,H20-Notenskala!$C$8,IF(E20=2,H20-Notenskala!$C$7,IF(E20=3,H20-Notenskala!$C$6,IF(E20=4,H20-Notenskala!$C$5,IF(E20=5,\"\"))))),\"\")","v":false}]
[null,19,{"$f":"IF(Gesamtnote!C21=0,\"\",Gesamtnote!C21)","v":"Schüler 19"},null,{"$f":"IFERROR(IF(H21=0,\"\",VLOOKUP(H21,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N21=2,SUMPRODUCT(I21:M21,$I$29:$M$29)/SUM($I$29:$M$29),N21=1,SUMPRODUCT(I21:L21,$I$30:$L$30)/SUM($I$30:$L$30),N21=0,SUMPRODUCT(I21:K21,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E21","v":""},{"$f":"'Heft 2'!E21","v":""},{"$f":"'Wdh 2'!E24","v":""},{"$f":"'Test 2.1'!E22","v":"K/NB"},{"$f":"'Test 2.2'!E22","v":"K/NB"},0,{"$f":"IFERROR(IF(E21=1,\"\",IF(E21=2,Notenskala!$D$9-H21,IF(E21=3,Notenskala!$D$8-H21,IF(E21=4,Notenskala!$D$7-H21,IF(E21=5,Notenskala!$D$6-H21))))),\"\")","v":false},{"$f":"IFERROR(IF(E21=1,H21-Notenskala!$C$8,IF(E21=2,H21-Notenskala!$C$7,IF(E21=3,H21-Notenskala!$C$6,IF(E21=4,H21-Notenskala!$C$5,IF(E21=5,\"\"))))),\"\")","v":false}]
[null,20,{"$f":"IF(Gesamtnote!C22=0,\"\",Gesamtnote!C22)","v":"Schüler 20"},null,{"$f":"IFERROR(IF(H22=0,\"\",VLOOKUP(H22,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N22=2,SUMPRODUCT(I22:M22,$I$29:$M$29)/SUM($I$29:$M$29),N22=1,SUMPRODUCT(I22:L22,$I$30:$L$30)/SUM($I$30:$L$30),N22=0,SUMPRODUCT(I22:K22,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E22","v":""},{"$f":"'Heft 2'!E22","v":""},{"$f":"'Wdh 2'!E25","v":""},{"$f":"'Test 2.1'!E23","v":"K/NB"},{"$f":"'Test 2.2'!E23","v":"K/NB"},0,{"$f":"IFERROR(IF(E22=1,\"\",IF(E22=2,Notenskala!$D$9-H22,IF(E22=3,Notenskala!$D$8-H22,IF(E22=4,Notenskala!$D$7-H22,IF(E22=5,Notenskala!$D$6-H22))))),\"\")","v":false},{"$f":"IFERROR(IF(E22=1,H22-Notenskala!$C$8,IF(E22=2,H22-Notenskala!$C$7,IF(E22=3,H22-Notenskala!$C$6,IF(E22=4,H22-Notenskala!$C$5,IF(E22=5,\"\"))))),\"\")","v":false}]
[null,21,{"$f":"IF(Gesamtnote!C23=0,\"\",Gesamtnote!C23)","v":"Schüler 21"},null,{"$f":"IFERROR(IF(H23=0,\"\",VLOOKUP(H23,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N23=2,SUMPRODUCT(I23:M23,$I$29:$M$29)/SUM($I$29:$M$29),N23=1,SUMPRODUCT(I23:L23,$I$30:$L$30)/SUM($I$30:$L$30),N23=0,SUMPRODUCT(I23:K23,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E23","v":""},{"$f":"'Heft 2'!E23","v":""},{"$f":"'Wdh 2'!E26","v":""},{"$f":"'Test 2.1'!E24","v":"K/NB"},{"$f":"'Test 2.2'!E24","v":"K/NB"},0,{"$f":"IFERROR(IF(E23=1,\"\",IF(E23=2,Notenskala!$D$9-H23,IF(E23=3,Notenskala!$D$8-H23,IF(E23=4,Notenskala!$D$7-H23,IF(E23=5,Notenskala!$D$6-H23))))),\"\")","v":false},{"$f":"IFERROR(IF(E23=1,H23-Notenskala!$C$8,IF(E23=2,H23-Notenskala!$C$7,IF(E23=3,H23-Notenskala!$C$6,IF(E23=4,H23-Notenskala!$C$5,IF(E23=5,\"\"))))),\"\")","v":false}]
[null,22,{"$f":"IF(Gesamtnote!C24=0,\"\",Gesamtnote!C24)","v":"Schüler 22"},null,{"$f":"IFERROR(IF(H24=0,\"\",VLOOKUP(H24,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N24=2,SUMPRODUCT(I24:M24,$I$29:$M$29)/SUM($I$29:$M$29),N24=1,SUMPRODUCT(I24:L24,$I$30:$L$30)/SUM($I$30:$L$30),N24=0,SUMPRODUCT(I24:K24,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E24","v":""},{"$f":"'Heft 2'!E24","v":""},{"$f":"'Wdh 2'!E27","v":""},{"$f":"'Test 2.1'!E25","v":"K/NB"},{"$f":"'Test 2.2'!E25","v":"K/NB"},0,{"$f":"IFERROR(IF(E24=1,\"\",IF(E24=2,Notenskala!$D$9-H24,IF(E24=3,Notenskala!$D$8-H24,IF(E24=4,Notenskala!$D$7-H24,IF(E24=5,Notenskala!$D$6-H24))))),\"\")","v":false},{"$f":"IFERROR(IF(E24=1,H24-Notenskala!$C$8,IF(E24=2,H24-Notenskala!$C$7,IF(E24=3,H24-Notenskala!$C$6,IF(E24=4,H24-Notenskala!$C$5,IF(E24=5,\"\"))))),\"\")","v":false}]
[null,23,{"$f":"IF(Gesamtnote!C25=0,\"\",Gesamtnote!C25)","v":""},null,{"$f":"IFERROR(IF(H25=0,\"\",VLOOKUP(H25,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N25=2,SUMPRODUCT(I25:M25,$I$29:$M$29)/SUM($I$29:$M$29),N25=1,SUMPRODUCT(I25:L25,$I$30:$L$30)/SUM($I$30:$L$30),N25=0,SUMPRODUCT(I25:K25,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E25","v":""},{"$f":"'Heft 2'!E25","v":""},{"$f":"'Wdh 2'!E28","v":""},{"$f":"'Test 2.1'!E26","v":"K/NB"},{"$f":"'Test 2.2'!E26","v":"K/NB"},0,{"$f":"IFERROR(IF(E25=1,\"\",IF(E25=2,Notenskala!$D$9-H25,IF(E25=3,Notenskala!$D$8-H25,IF(E25=4,Notenskala!$D$7-H25,IF(E25=5,Notenskala!$D$6-H25))))),\"\")","v":false},{"$f":"IFERROR(IF(E25=1,H25-Notenskala!$C$8,IF(E25=2,H25-Notenskala!$C$7,IF(E25=3,H25-Notenskala!$C$6,IF(E25=4,H25-Notenskala!$C$5,IF(E25=5,\"\"))))),\"\")","v":false}]
[null,24,{"$f":"IF(Gesamtnote!C26=0,\"\",Gesamtnote!C26)","v":""},null,{"$f":"IFERROR(IF(H26=0,\"\",VLOOKUP(H26,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N26=2,SUMPRODUCT(I26:M26,$I$29:$M$29)/SUM($I$29:$M$29),N26=1,SUMPRODUCT(I26:L26,$I$30:$L$30)/SUM($I$30:$L$30),N26=0,SUMPRODUCT(I26:K26,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E26","v":""},{"$f":"'Heft 2'!E26","v":""},{"$f":"'Wdh 2'!E29","v":""},{"$f":"'Test 2.1'!E27","v":"K/NB"},{"$f":"'Test 2.2'!E27","v":"K/NB"},0,{"$f":"IFERROR(IF(E26=1,\"\",IF(E26=2,Notenskala!$D$9-H26,IF(E26=3,Notenskala!$D$8-H26,IF(E26=4,Notenskala!$D$7-H26,IF(E26=5,Notenskala!$D$6-H26))))),\"\")","v":false},{"$f":"IFERROR(IF(E26=1,H26-Notenskala!$C$8,IF(E26=2,H26-Notenskala!$C$7,IF(E26=3,H26-Notenskala!$C$6,IF(E26=4,H26-Notenskala!$C$5,IF(E26=5,\"\"))))),\"\")","v":false}]
[null,25,{"$f":"IF(Gesamtnote!C27=0,\"\",Gesamtnote!C27)","v":""},null,{"$f":"IFERROR(IF(H27=0,\"\",VLOOKUP(H27,Notenskala!$D$4:$E$9,2,TRUE)),\"\")","v":""}," "," ",{"$f":"IFERROR(_xlfn.IFS(N27=2,SUMPRODUCT(I27:M27,$I$29:$M$29)/SUM($I$29:$M$29),N27=1,SUMPRODUCT(I27:L27,$I$30:$L$30)/SUM($I$30:$L$30),N27=0,SUMPRODUCT(I27:K27,$I$31:$K$31)/SUM($I$31:$K$31)),\"\")","v":0},{"$f":"'MA 2'!E27","v":""},{"$f":"'Heft 2'!E27","v":""},{"$f":"'Wdh 2'!E30","v":""},{"$f":"'Test 2.1'!E28","v":"K/NB"},{"$f":"'Test 2.2'!E28","v":"K/NB"},0,{"$f":"IFERROR(IF(E27=1,\"\",IF(E27=2,Notenskala!$D$9-H27,IF(E27=3,Notenskala!$D$8-H27,IF(E27=4,Notenskala!$D$7-H27,IF(E27=5,Notenskala!$D$6-H27))))),\"\")","v":false},{"$f":"IFERROR(IF(E27=1,H27-Notenskala!$C$8,IF(E27=2,H27-Notenskala!$C$7,IF(E27=3,H27-Notenskala!$C$6,IF(E27=4,H27-Notenskala!$C$5,IF(E27=5,\"\"))))),\"\")","v":false}]
[]
[null,null,null,null,null,null,null,"Zwei Tests",0.2,0.1,0.2,0.25,0.25,null,null,null,{"$f":"SUM(I29:M29)","v":1}]
[null,null,null,null,null,null,null,"Ein Test",0.2,0.15,0.25,0.4,null,null,null,null,{"$f":"SUM(I30:M30)","v":1}]
[null,null,null,null,null,null,null,"Kein Test",0.35,0.25,0.4,null,null,null,null,null,1]
[null,null,null,null,null,null,null,"MUSS immer 100 ergeben!"]
[null,null,null,null,null,null,null,"für Ursprungswerte --> runterscrollen!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"#Default"]
[null,null,null,null,null,null,null,"Zwei Tests",0.2,0.1,0.2,0.25,0.25]
[null,null,null,null,null,null,null,"Ein Test",0.2,0.15,0.25,0.4]
[null,null,null,null,null,null,null,"Kein Test",0.35,0.25,0.4]

{"sheet":"MA 2","index":10,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,"Nr.","Name","MA","Prozente","Stunden","Krank","Summe"]
[null,1,{"$f":"IF(Gesamtnote!C3=0,\"\",Gesamtnote!C3)","v":"Schüler 1"},{"$f":"IFERROR(VLOOKUP(E3,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},{"$f":"IFERROR(H3/F3,\"\")","v":""},{"$f":"$D$30-G3","v":0},{"$f":"COUNTIF(I3:BE3,\"K\")","v":0},{"$f":"IF(SUM(I3:BE3)=0,\"\",SUM(I3:BE3))","v":""}]
[null,2,{"$f":"IF(Gesamtnote!C4=0,\"\",Gesamtnote!C4)","v":"Schüler 2"},{"$f":"IFERROR(VLOOKUP(E4,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},{"$f":"IFERROR(H4/F4,\"\")","v":""},0,{"$f":"COUNTIF(I4:BE4,\"K\")","v":0},{"$f":"IF(SUM(I4:BE4)=0,\"\",SUM(I4:BE4))","v":""}]
[null,3,{"$f":"IF(Gesamtnote!C5=0,\"\",Gesamtnote!C5)","v":"Schüler 3"},{"$f":"IFERROR(VLOOKUP(E5,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,4,{"$f":"IF(Gesamtnote!C6=0,\"\",Gesamtnote!C6)","v":"Schüler 4"},{"$f":"IFERROR(VLOOKUP(E6,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,5,{"$f":"IF(Gesamtnote!C7=0,\"\",Gesamtnote!C7)","v":"Schüler 5"},{"$f":"IFERROR(VLOOKUP(E7,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,6,{"$f":"IF(Gesamtnote!C8=0,\"\",Gesamtnote!C8)","v":"Schüler 6"},{"$f":"IFERROR(VLOOKUP(E8,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,7,{"$f":"IF(Gesamtnote!C9=0,\"\",Gesamtnote!C9)","v":"Schüler 7"},{"$f":"IFERROR(VLOOKUP(E9,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,8,{"$f":"IF(Gesamtnote!C10=0,\"\",Gesamtnote!C10)","v":"Schüler 8"},{"$f":"IFERROR(VLOOKUP(E10,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,9,{"$f":"IF(Gesamtnote!C11=0,\"\",Gesamtnote!C11)","v":"Schüler 9"},{"$f":"IFERROR(VLOOKUP(E11,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,10,{"$f":"IF(Gesamtnote!C12=0,\"\",Gesamtnote!C12)","v":"Schüler 10"},{"$f":"IFERROR(VLOOKUP(E12,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,11,{"$f":"IF(Gesamtnote!C13=0,\"\",Gesamtnote!C13)","v":"Schüler 11"},{"$f":"IFERROR(VLOOKUP(E13,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,12,{"$f":"IF(Gesamtnote!C14=0,\"\",Gesamtnote!C14)","v":"Schüler 12"},{"$f":"IFERROR(VLOOKUP(E14,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,13,{"$f":"IF(Gesamtnote!C15=0,\"\",Gesamtnote!C15)","v":"Schüler 13"},{"$f":"IFERROR(VLOOKUP(E15,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,14,{"$f":"IF(Gesamtnote!C16=0,\"\",Gesamtnote!C16)","v":"Schüler 14"},{"$f":"IFERROR(VLOOKUP(E16,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,15,{"$f":"IF(Gesamtnote!C17=0,\"\",Gesamtnote!C17)","v":"Schüler 15"},{"$f":"IFERROR(VLOOKUP(E17,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,16,{"$f":"IF(Gesamtnote!C18=0,\"\",Gesamtnote!C18)","v":"Schüler 16"},{"$f":"IFERROR(VLOOKUP(E18,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,17,{"$f":"IF(Gesamtnote!C19=0,\"\",Gesamtnote!C19)","v":"Schüler 17"},{"$f":"IFERROR(VLOOKUP(E19,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,18,{"$f":"IF(Gesamtnote!C20=0,\"\",Gesamtnote!C20)","v":"Schüler 18"},{"$f":"IFERROR(VLOOKUP(E20,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,19,{"$f":"IF(Gesamtnote!C21=0,\"\",Gesamtnote!C21)","v":"Schüler 19"},{"$f":"IFERROR(VLOOKUP(E21,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,20,{"$f":"IF(Gesamtnote!C22=0,\"\",Gesamtnote!C22)","v":"Schüler 20"},{"$f":"IFERROR(VLOOKUP(E22,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,21,{"$f":"IF(Gesamtnote!C23=0,\"\",Gesamtnote!C23)","v":"Schüler 21"},{"$f":"IFERROR(VLOOKUP(E23,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,22,{"$f":"IF(Gesamtnote!C24=0,\"\",Gesamtnote!C24)","v":"Schüler 22"},{"$f":"IFERROR(VLOOKUP(E24,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,23,{"$f":"IF(Gesamtnote!C25=0,\"\",Gesamtnote!C25)","v":""},{"$f":"IFERROR(VLOOKUP(E25,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,24,{"$f":"IF(Gesamtnote!C26=0,\"\",Gesamtnote!C26)","v":""},{"$f":"IFERROR(VLOOKUP(E26,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,25,{"$f":"IF(Gesamtnote!C27=0,\"\",Gesamtnote!C27)","v":""},{"$f":"IFERROR(VLOOKUP(E27,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0,0,""]
[null,null,"Ø",{"$f":"IFERROR(AVERAGE(D3:D27),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E3:E27),\"\")","v":""},{"$f":"IFERROR(AVERAGE(F3:F27),\"\")","v":0},{"$f":"IFERROR(AVERAGE(G3:G27),\"\")","v":0},{"$f":"IFERROR(AVERAGE(H3:H27),\"\")","v":""}]
[]
[null,null,"Stunden bis jetzt",{"$f":"COUNTA(I2:BE2)","v":0}]
[]
[]
[null,null,"Sehr Gut",{"$f":"COUNTIF($D$3:$D$27,\"1\")","v":0}]
[null,null,"Gut",{"$f":"COUNTIF($D$3:$D$27,\"2\")","v":0}]
[null,null,"Befriedigend",{"$f":"COUNTIF($D$3:$D$27,\"3\")","v":0}]
[null,null,"Genügend",{"$f":"COUNTIF($D$3:$D$27,\"4\")","v":0}]
[null,null,"Nicht Genügend",{"$f":"COUNTIF($D$3:$D$27,\"5\")","v":0}]
[null,null,"K / Nicht Beurteilt",{"$f":"COUNTIF($D$3:$D$27,\"K/NB\")","v":0}]
[]
[null,null,"Positiv",{"$f":"IFERROR(SUM(D33:D36)/SUM(D33:D37),\"\")","v":""}]
[null,null,"Negativ",{"$f":"IFERROR(D37/SUM(D33:D37),\"\")","v":""}]

{"sheet":"Wdh 2","index":11,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,null,null,"Datum"]
[null,null,null,"Inhalt"]
[null,null,null,"Punkte"]
[null,"Nr.","Name","Wdh","Gesamt","Ges. Punkte"]
[null,1,{"$f":"'Semester 1'!C3","v":"Schüler 1"},{"$f":"IFERROR(VLOOKUP(E6,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},{"$f":"IFERROR(SUMIF(G6:R6,\"<>\",G6:R6)/F6,\"\")","v":""},{"$f":"SUMIF(G6:R6,\"<>\",$G$4:$R$4)","v":0}]
[null,2,{"$f":"'Semester 1'!C4","v":"Schüler 2"},{"$f":"IFERROR(VLOOKUP(E7,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},{"$f":"IFERROR(SUMIF(G7:R7,\"<>\",G7:R7)/F7,\"\")","v":""},0]
[null,3,{"$f":"'Semester 1'!C5","v":"Schüler 3"},{"$f":"IFERROR(VLOOKUP(E8,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,4,{"$f":"'Semester 1'!C6","v":"Schüler 4"},{"$f":"IFERROR(VLOOKUP(E9,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,5,{"$f":"'Semester 1'!C7","v":"Schüler 5"},{"$f":"IFERROR(VLOOKUP(E10,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,6,{"$f":"'Semester 1'!C8","v":"Schüler 6"},{"$f":"IFERROR(VLOOKUP(E11,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,7,{"$f":"'Semester 1'!C9","v":"Schüler 7"},{"$f":"IFERROR(VLOOKUP(E12,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,8,{"$f":"'Semester 1'!C10","v":"Schüler 8"},{"$f":"IFERROR(VLOOKUP(E13,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,9,{"$f":"'Semester 1'!C11","v":"Schüler 9"},{"$f":"IFERROR(VLOOKUP(E14,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,10,{"$f":"'Semester 1'!C12","v":"Schüler 10"},{"$f":"IFERROR(VLOOKUP(E15,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,11,{"$f":"'Semester 1'!C13","v":"Schüler 11"},{"$f":"IFERROR(VLOOKUP(E16,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,12,{"$f":"'Semester 1'!C14","v":"Schüler 12"},{"$f":"IFERROR(VLOOKUP(E17,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,13,{"$f":"'Semester 1'!C15","v":"Schüler 13"},{"$f":"IFERROR(VLOOKUP(E18,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,14,{"$f":"'Semester 1'!C16","v":"Schüler 14"},{"$f":"IFERROR(VLOOKUP(E19,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,15,{"$f":"'Semester 1'!C17","v":"Schüler 15"},{"$f":"IFERROR(VLOOKUP(E20,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,16,{"$f":"'Semester 1'!C18","v":"Schüler 16"},{"$f":"IFERROR(VLOOKUP(E21,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,17,{"$f":"'Semester 1'!C19","v":"Schüler 17"},{"$f":"IFERROR(VLOOKUP(E22,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,18,{"$f":"'Semester 1'!C20","v":"Schüler 18"},{"$f":"IFERROR(VLOOKUP(E23,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,19,{"$f":"'Semester 1'!C21","v":"Schüler 19"},{"$f":"IFERROR(VLOOKUP(E24,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,20,{"$f":"'Semester 1'!C22","v":"Schüler 20"},{"$f":"IFERROR(VLOOKUP(E25,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,21,{"$f":"'Semester 1'!C23","v":"Schüler 21"},{"$f":"IFERROR(VLOOKUP(E26,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,22,{"$f":"'Semester 1'!C24","v":"Schüler 22"},{"$f":"IFERROR(VLOOKUP(E27,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,23,{"$f":"'Semester 1'!C25","v":""},{"$f":"IFERROR(VLOOKUP(E28,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,24,{"$f":"'Semester 1'!C26","v":""},{"$f":"IFERROR(VLOOKUP(E29,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,25,{"$f":"'Semester 1'!C27","v":""},{"$f":"IFERROR(VLOOKUP(E30,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},"",0]
[null,null,"Ø",{"$f":"IFERROR(AVERAGEIF(D6:D30,\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(E6:E30,\">0\"),\"\")","v":""},"","","","","","","","","","","","",""]

{"sheet":"Heft 2","index":12,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,"Nr.","Name","Heft","Summe","2025-06-22","Notizen","Datum","Notizen","2025-01-29","Notizen","2025-01-20","Notizen"]
[null,1,{"$f":"'Semester 1'!C3","v":"Schüler 1"},{"$f":"IFERROR(VLOOKUP(E3,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},{"$f":"IFERROR(SUM(F3,H3)/COUNTA(F3,H3),\"\")","v":""}]
[null,2,{"$f":"'Semester 1'!C4","v":"Schüler 2"},{"$f":"IFERROR(VLOOKUP(E4,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},{"$f":"IFERROR(SUM(F4,H4)/COUNTA(F4,H4),\"\")","v":""}]
[null,3,{"$f":"'Semester 1'!C5","v":"Schüler 3"},{"$f":"IFERROR(VLOOKUP(E5,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,4,{"$f":"'Semester 1'!C6","v":"Schüler 4"},{"$f":"IFERROR(VLOOKUP(E6,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,5,{"$f":"'Semester 1'!C7","v":"Schüler 5"},{"$f":"IFERROR(VLOOKUP(E7,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,6,{"$f":"'Semester 1'!C8","v":"Schüler 6"},{"$f":"IFERROR(VLOOKUP(E8,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,7,{"$f":"'Semester 1'!C9","v":"Schüler 7"},{"$f":"IFERROR(VLOOKUP(E9,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,8,{"$f":"'Semester 1'!C10","v":"Schüler 8"},{"$f":"IFERROR(VLOOKUP(E10,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,9,{"$f":"'Semester 1'!C11","v":"Schüler 9"},{"$f":"IFERROR(VLOOKUP(E11,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,10,{"$f":"'Semester 1'!C12","v":"Schüler 10"},{"$f":"IFERROR(VLOOKUP(E12,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,11,{"$f":"'Semester 1'!C13","v":"Schüler 11"},{"$f":"IFERROR(VLOOKUP(E13,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,12,{"$f":"'Semester 1'!C14","v":"Schüler 12"},{"$f":"IFERROR(VLOOKUP(E14,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,13,{"$f":"'Semester 1'!C15","v":"Schüler 13"},{"$f":"IFERROR(VLOOKUP(E15,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,14,{"$f":"'Semester 1'!C16","v":"Schüler 14"},{"$f":"IFERROR(VLOOKUP(E16,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,15,{"$f":"'Semester 1'!C17","v":"Schüler 15"},{"$f":"IFERROR(VLOOKUP(E17,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,16,{"$f":"'Semester 1'!C18","v":"Schüler 16"},{"$f":"IFERROR(VLOOKUP(E18,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,17,{"$f":"'Semester 1'!C19","v":"Schüler 17"},{"$f":"IFERROR(VLOOKUP(E19,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,18,{"$f":"'Semester 1'!C20","v":"Schüler 18"},{"$f":"IFERROR(VLOOKUP(E20,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,19,{"$f":"'Semester 1'!C21","v":"Schüler 19"},{"$f":"IFERROR(VLOOKUP(E21,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,20,{"$f":"'Semester 1'!C22","v":"Schüler 20"},{"$f":"IFERROR(VLOOKUP(E22,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,21,{"$f":"'Semester 1'!C23","v":"Schüler 21"},{"$f":"IFERROR(VLOOKUP(E23,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,22,{"$f":"'Semester 1'!C24","v":"Schüler 22"},{"$f":"IFERROR(VLOOKUP(E24,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,23,{"$f":"'Semester 1'!C25","v":""},{"$f":"IFERROR(VLOOKUP(E25,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,24,null,{"$f":"IFERROR(VLOOKUP(E26,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]
[null,25,null,{"$f":"IFERROR(VLOOKUP(E27,Notenskala!$D$4:$E$9,2,TRUE),\"\")","v":""},""]

{"sheet":"Test 2.1","index":13,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,null,"2025-02-02","Punkte",null,null,{"$f":"SUM(H2:N2)","v":0},null,null,null,null,null,null,null,null,"Verteilung:"]
[null,"Nr.","Name","Test 3","Prozente","Leer","Summe","A","B","C","D","E","F","G",null,"Sehr Gut",{"$f":"COUNTIF($D$4:$D$28,\"1\")","v":0}]
[null,1,{"$f":"IF(Gesamtnote!C3=0,\"\",Gesamtnote!C3)","v":"Schüler 1"},{"$f":"IF(G4=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G4,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":"K/NB"},{"$f":"IF(F4=FALSE,G4/$G$2,\"K/NB\")","v":"K/NB"},{"$f":"SUMPRODUCT(--(H4:L4<>\"\"))=0","v":true},{"$f":"IF(F4=FALSE,SUM(H4:N4),\"K/NB\")","v":"K/NB"},null,null,null,null,null,null,null,null,"Gut",{"$f":"COUNTIF($D$4:$D$28,\"2\")","v":0}]
[null,2,{"$f":"IF(Gesamtnote!C4=0,\"\",Gesamtnote!C4)","v":"Schüler 2"},{"$f":"IF(G5=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G5,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":"K/NB"},{"$f":"IF(F5=FALSE,G5/$G$2,\"K/NB\")","v":"K/NB"},{"$f":"SUMPRODUCT(--(H5:L5<>\"\"))=0","v":true},{"$f":"IF(F5=FALSE,SUM(H5:N5),\"K/NB\")","v":"K/NB"},null,null,null,null,null,null,null,null,"Befriedigend",{"$f":"COUNTIF($D$4:$D$28,\"3\")","v":0}]
[null,3,{"$f":"IF(Gesamtnote!C5=0,\"\",Gesamtnote!C5)","v":"Schüler 3"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H6:L6<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Genügend",{"$f":"COUNTIF($D$4:$D$28,\"4\")","v":0}]
[null,4,{"$f":"IF(Gesamtnote!C6=0,\"\",Gesamtnote!C6)","v":"Schüler 4"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H7:L7<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Nicht Genügend",{"$f":"COUNTIF($D$4:$D$28,\"5\")","v":0}]
[null,5,{"$f":"IF(Gesamtnote!C7=0,\"\",Gesamtnote!C7)","v":"Schüler 5"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H8:L8<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"K / Nicht Beurteilt",{"$f":"COUNTIF($D$4:$D$28,\"K/NB\")","v":25}]
[null,6,{"$f":"IF(Gesamtnote!C8=0,\"\",Gesamtnote!C8)","v":"Schüler 6"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H9:L9<>\"\"))=0","v":true},"K/NB"]
[null,7,{"$f":"IF(Gesamtnote!C9=0,\"\",Gesamtnote!C9)","v":"Schüler 7"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H10:L10<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Positiv",{"$f":"IFERROR(SUM(Q3:Q6)/SUM(Q3:Q7),\"\")","v":""}]
[null,8,{"$f":"IF(Gesamtnote!C10=0,\"\",Gesamtnote!C10)","v":"Schüler 8"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H11:L11<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Negativ",{"$f":"IFERROR(Q7/SUM(Q3:Q7),\"\")","v":""}]
[null,9,{"$f":"IF(Gesamtnote!C11=0,\"\",Gesamtnote!C11)","v":"Schüler 9"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H12:L12<>\"\"))=0","v":true},"K/NB"]
[null,10,{"$f":"IF(Gesamtnote!C12=0,\"\",Gesamtnote!C12)","v":"Schüler 10"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H13:L13<>\"\"))=0","v":true},"K/NB"]
[null,11,{"$f":"IF(Gesamtnote!C13=0,\"\",Gesamtnote!C13)","v":"Schüler 11"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H14:L14<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Notenschlüssel:","Von","Bis"]
[null,12,{"$f":"IF(Gesamtnote!C14=0,\"\",Gesamtnote!C14)","v":"Schüler 12"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H15:L15<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,1,{"$f":"G2","v":0},{"$f":"MROUND($G$2*Notenskala!$D$9,0.5)","v":0}]
[null,13,{"$f":"IF(Gesamtnote!C15=0,\"\",Gesamtnote!C15)","v":"Schüler 13"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H16:L16<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,2,{"$f":"R15-0.5","v":-0.5},{"$f":"MROUND($G$2*Notenskala!$D$8,0.5)","v":0}]
[null,14,{"$f":"IF(Gesamtnote!C16=0,\"\",Gesamtnote!C16)","v":"Schüler 14"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H17:L17<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,3,{"$f":"R16-0.5","v":-0.5},{"$f":"MROUND($G$2*Notenskala!$D$7,0.5)","v":0}]
[null,15,{"$f":"IF(Gesamtnote!C17=0,\"\",Gesamtnote!C17)","v":"Schüler 15"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H18:L18<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,4,-0.5,{"$f":"MROUND($G$2*Notenskala!$D$6,0.5)","v":0}]
[null,16,{"$f":"IF(Gesamtnote!C18=0,\"\",Gesamtnote!C18)","v":"Schüler 16"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H19:L19<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,5,-0.5,{"$f":"MROUND($G$2*Notenskala!$D$5,0.5)","v":0}]
[null,17,{"$f":"IF(Gesamtnote!C19=0,\"\",Gesamtnote!C19)","v":"Schüler 17"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H20:L20<>\"\"))=0","v":true},"K/NB"]
[null,18,{"$f":"IF(Gesamtnote!C20=0,\"\",Gesamtnote!C20)","v":"Schüler 18"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H21:L21<>\"\"))=0","v":true},"K/NB"]
[null,19,{"$f":"IF(Gesamtnote!C21=0,\"\",Gesamtnote!C21)","v":"Schüler 19"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H22:L22<>\"\"))=0","v":true},"K/NB"]
[null,20,{"$f":"IF(Gesamtnote!C22=0,\"\",Gesamtnote!C22)","v":"Schüler 20"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H23:L23<>\"\"))=0","v":true},"K/NB"]
[null,21,{"$f":"IF(Gesamtnote!C23=0,\"\",Gesamtnote!C23)","v":"Schüler 21"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H24:L24<>\"\"))=0","v":true},"K/NB"]
[null,22,{"$f":"IF(Gesamtnote!C24=0,\"\",Gesamtnote!C24)","v":"Schüler 22"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H25:L25<>\"\"))=0","v":true},"K/NB"]
[null,23,{"$f":"IF(Gesamtnote!C25=0,\"\",Gesamtnote!C25)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H26:L26<>\"\"))=0","v":true},"K/NB"]
[null,24,{"$f":"IF(Gesamtnote!C26=0,\"\",Gesamtnote!C26)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H27:L27<>\"\"))=0","v":true},"K/NB"]
[null,25,{"$f":"IF(Gesamtnote!C27=0,\"\",Gesamtnote!C27)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H28:L28<>\"\"))=0","v":true},"K/NB"]
[null,null,"Ø",{"$f":"IFERROR(AVERAGEIF(D4:D28,\"<>\",D4:D28),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(E4:E28,\"<>\",E4:E28),\"\")","v":""},"","","","","","","","",""]

{"sheet":"Test 2.2","index":14,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["zurück"]
[null,null,"2025-02-02","Punkte",null,null,{"$f":"SUM(H2:N2)","v":0},null,null,null,null,null,null,null,null,"Verteilung:"]
[null,"Nr.","Name","Test 4","Prozente","Leer","Summe","A","B","C","D","E","F","G",null,"Sehr Gut",{"$f":"COUNTIF($D$4:$D$28,\"1\")","v":0}]
[null,1,{"$f":"IF(Gesamtnote!C3=0,\"\",Gesamtnote!C3)","v":"Schüler 1"},{"$f":"IF(G4=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G4,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":"K/NB"},{"$f":"IF(F4=FALSE,G4/$G$2,\"K/NB\")","v":"K/NB"},{"$f":"SUMPRODUCT(--(H4:L4<>\"\"))=0","v":true},{"$f":"IF(F4=FALSE,SUM(H4:N4),\"K/NB\")","v":"K/NB"},null,null,null,null,null,null,null,null,"Gut",{"$f":"COUNTIF($D$4:$D$28,\"2\")","v":0}]
[null,2,{"$f":"IF(Gesamtnote!C4=0,\"\",Gesamtnote!C4)","v":"Schüler 2"},{"$f":"IF(G5=\"K/NB\",\"K/NB\",_xlfn.XLOOKUP(G5,$R$15:$R$19,$P$15:$P$19,\"\",-1))","v":"K/NB"},{"$f":"IF(F5=FALSE,G5/$G$2,\"K/NB\")","v":"K/NB"},{"$f":"SUMPRODUCT(--(H5:L5<>\"\"))=0","v":true},{"$f":"IF(F5=FALSE,SUM(H5:N5),\"K/NB\")","v":"K/NB"},null,null,null,null,null,null,null,null,"Befriedigend",{"$f":"COUNTIF($D$4:$D$28,\"3\")","v":0}]
[null,3,{"$f":"IF(Gesamtnote!C5=0,\"\",Gesamtnote!C5)","v":"Schüler 3"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H6:L6<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Genügend",{"$f":"COUNTIF($D$4:$D$28,\"4\")","v":0}]
[null,4,{"$f":"IF(Gesamtnote!C6=0,\"\",Gesamtnote!C6)","v":"Schüler 4"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H7:L7<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Nicht Genügend",{"$f":"COUNTIF($D$4:$D$28,\"5\")","v":0}]
[null,5,{"$f":"IF(Gesamtnote!C7=0,\"\",Gesamtnote!C7)","v":"Schüler 5"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H8:L8<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"K / Nicht Beurteilt",{"$f":"COUNTIF($D$4:$D$28,\"K/NB\")","v":25}]
[null,6,{"$f":"IF(Gesamtnote!C8=0,\"\",Gesamtnote!C8)","v":"Schüler 6"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H9:L9<>\"\"))=0","v":true},"K/NB"]
[null,7,{"$f":"IF(Gesamtnote!C9=0,\"\",Gesamtnote!C9)","v":"Schüler 7"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H10:L10<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Positiv",{"$f":"IFERROR(SUM(Q3:Q6)/SUM(Q3:Q7),\"\")","v":""}]
[null,8,{"$f":"IF(Gesamtnote!C10=0,\"\",Gesamtnote!C10)","v":"Schüler 8"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H11:L11<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Negativ",{"$f":"IFERROR(Q7/SUM(Q3:Q7),\"\")","v":""}]
[null,9,{"$f":"IF(Gesamtnote!C11=0,\"\",Gesamtnote!C11)","v":"Schüler 9"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H12:L12<>\"\"))=0","v":true},"K/NB"]
[null,10,{"$f":"IF(Gesamtnote!C12=0,\"\",Gesamtnote!C12)","v":"Schüler 10"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H13:L13<>\"\"))=0","v":true},"K/NB"]
[null,11,{"$f":"IF(Gesamtnote!C13=0,\"\",Gesamtnote!C13)","v":"Schüler 11"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H14:L14<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,"Notenschlüssel:","Von","Bis"]
[null,12,{"$f":"IF(Gesamtnote!C14=0,\"\",Gesamtnote!C14)","v":"Schüler 12"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H15:L15<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,1,{"$f":"G2","v":0},{"$f":"MROUND($G$2*Notenskala!$D$9,0.5)","v":0}]
[null,13,{"$f":"IF(Gesamtnote!C15=0,\"\",Gesamtnote!C15)","v":"Schüler 13"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H16:L16<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,2,{"$f":"R15-0.5","v":-0.5},{"$f":"MROUND($G$2*Notenskala!$D$8,0.5)","v":0}]
[null,14,{"$f":"IF(Gesamtnote!C16=0,\"\",Gesamtnote!C16)","v":"Schüler 14"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H17:L17<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,3,{"$f":"R16-0.5","v":-0.5},{"$f":"MROUND($G$2*Notenskala!$D$7,0.5)","v":0}]
[null,15,{"$f":"IF(Gesamtnote!C17=0,\"\",Gesamtnote!C17)","v":"Schüler 15"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H18:L18<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,4,-0.5,{"$f":"MROUND($G$2*Notenskala!$D$6,0.5)","v":0}]
[null,16,{"$f":"IF(Gesamtnote!C18=0,\"\",Gesamtnote!C18)","v":"Schüler 16"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H19:L19<>\"\"))=0","v":true},"K/NB",null,null,null,null,null,null,null,null,5,-0.5,{"$f":"MROUND($G$2*Notenskala!$D$5,0.5)","v":0}]
[null,17,{"$f":"IF(Gesamtnote!C19=0,\"\",Gesamtnote!C19)","v":"Schüler 17"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H20:L20<>\"\"))=0","v":true},"K/NB"]
[null,18,{"$f":"IF(Gesamtnote!C20=0,\"\",Gesamtnote!C20)","v":"Schüler 18"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H21:L21<>\"\"))=0","v":true},"K/NB"]
[null,19,{"$f":"IF(Gesamtnote!C21=0,\"\",Gesamtnote!C21)","v":"Schüler 19"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H22:L22<>\"\"))=0","v":true},"K/NB"]
[null,20,{"$f":"IF(Gesamtnote!C22=0,\"\",Gesamtnote!C22)","v":"Schüler 20"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H23:L23<>\"\"))=0","v":true},"K/NB"]
[null,21,{"$f":"IF(Gesamtnote!C23=0,\"\",Gesamtnote!C23)","v":"Schüler 21"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H24:L24<>\"\"))=0","v":true},"K/NB"]
[null,22,{"$f":"IF(Gesamtnote!C24=0,\"\",Gesamtnote!C24)","v":"Schüler 22"},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H25:L25<>\"\"))=0","v":true},"K/NB"]
[null,23,{"$f":"IF(Gesamtnote!C25=0,\"\",Gesamtnote!C25)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H26:L26<>\"\"))=0","v":true},"K/NB"]
[null,24,{"$f":"IF(Gesamtnote!C26=0,\"\",Gesamtnote!C26)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H27:L27<>\"\"))=0","v":true},"K/NB"]
[null,25,{"$f":"IF(Gesamtnote!C27=0,\"\",Gesamtnote!C27)","v":""},"K/NB","K/NB",{"$f":"SUMPRODUCT(--(H28:L28<>\"\"))=0","v":true},"K/NB"]
[null,null,"Ø",{"$f":"IFERROR(AVERAGEIF(D4:D28,\"<>\",D4:D28),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(E4:E28,\"<>\",E4:E28),\"\")","v":""},"","","","","","","","",""]