{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Deckblatt","Kurswahl1","Kurswahl2","Persönliche Angaben","Abschluss"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Deckblatt","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[6,0,8,3],[4,0,4,3],[10,0,12,3],[5,0,5,3],[14,0,15,3],[17,0,21,3],[13,0,13,3],[9,0,9,3],[16,0,16,3]]}
[null,"Max -Delbrück-Gymnasium"]
[null,"Wahlen zum Kurssystem"]
[]
[]
["Zum Arbeiten mit der Kurswahltabelle:"]
[]
["1. Stellen Sie sicher, dass Sie die richtige Datei gewählt haben. Für MS Excel nehmen Sie die .xlsm und für OpenOffice die .ods Datei."]
[]
[]
[]
["2. Speichern Sie die Datei in ihren eigenen Dateien bzw. aktivieren Sie das Bearbeiten. Nur dann können Sie diese ausfüllen."]
[]
[]
[]
["3. Zum Verwenden der Buttons müssen Makros aktiviert sein. Bestätigen Sie deren Verwendung."]
[]
[]
["Hinweis: Wollen oder können Sie ihren Makros nicht aktivieren, nutzen Sie zur Navigation die Tabellenblattreiter am unteren Fensterrand. Gehen Sie zunächst auf \"Kurswahl 1\", dann auf \"Kurswahl 2\" und \"Persönliche Angaben\"."]

{"sheet":"Kurswahl1","index":1,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,0,5,1],[21,0,21,4],[21,5,21,8],[14,0,14,1],[15,0,15,1],[11,0,11,1],[16,0,16,1],[17,0,18,1]]}
[]
[]
[]
[null,null,{"$f":"IF(COUNTIF(C7:C21,\"nicht erfüllt\")>0,\"Nicht alle Bedingungen erfüllt\",\"\")","v":"Nicht alle Bedingungen erfüllt"}]
[null,null,null,null,null,null,null,null,null,"Informatik",null,null,"Darstellendes Spiel"]
["Prüfungsfächer",null,{"$f":"IF(COUNTIF(C7:C11,\" \")=5,\"\",\"Fehlermeldungen\")","v":"Fehlermeldungen"},null,"Aufgabenfeld","Fachbereich","Nur eins","Zwei aus","doppelte Fächer","Info WPU","Fehlermeldung doppeltes Prüfungsfach","Fehlermeldung kein Prüfungsfach gewählt","DS WPU"]
["1. Leistungskursfach",null,{"$f":"\" \"&L7","v":" kein Prüfungsfach gewählt"},"1. Pr.F.",{"$f":"IF($B7=\"\",\"\",VLOOKUP($B7,$F$24:$J$41,2,FALSE))","v":""},{"$f":"IF($B7=\"\",\"\",VLOOKUP($B7,$F$24:$J$41,3,FALSE))","v":""},{"$f":"IF($B7=\"\",\"\",VLOOKUP($B7,$F$24:$J$41,4,FALSE))","v":""},{"$f":"IF($B7=\"\",\"\",VLOOKUP($B7,$F$24:$J$41,5,FALSE))","v":""},{"$f":"COUNTIF($B$7:$B$11,B7)","v":0},null,{"$f":"IF(I7>1,\"Doppeltes Prüfungsfach! Bitte wähle ein anderes!\",\"\")","v":""},{"$f":"IF(B7=\"\",\"kein Prüfungsfach gewählt\",\"\")","v":"kein Prüfungsfach gewählt"}]
["2. Leistungskursfach",null,{"$f":"K8&\" \"&L8","v":" kein Prüfungsfach gewählt"},"2. Pr.F.",{"$f":"IF($B8=\"\",\"\",VLOOKUP($B8,$F$24:$J$41,2,FALSE))","v":""},{"$f":"IF($B8=\"\",\"\",VLOOKUP($B8,$F$24:$J$41,3,FALSE))","v":""},{"$f":"IF($B8=\"\",\"\",VLOOKUP($B8,$F$24:$J$41,4,FALSE))","v":""},{"$f":"IF($B8=\"\",\"\",VLOOKUP($B8,$F$24:$J$41,5,FALSE))","v":""},{"$f":"COUNTIF($B$7:$B$11,B8)","v":0},null,{"$f":"IF(I8>1,\"Doppeltes Prüfungsfach! Bitte wähle ein anderes!\",\"\")","v":""},{"$f":"IF(B8=\"\",\"kein Prüfungsfach gewählt\",\"\")","v":"kein Prüfungsfach gewählt"}]
["3. Prüfungsfach (schriftl.)",null,{"$f":"K9&\" \"&L9","v":" kein Prüfungsfach gewählt"},"3. Pr.F.",{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,$F$24:$J$41,2,FALSE))","v":""},{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,$F$24:$J$41,3,FALSE))","v":""},{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,$F$24:$J$41,4,FALSE))","v":""},{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,$F$24:$J$41,5,FALSE))","v":""},{"$f":"COUNTIF($B$7:$B$11,B9)","v":0},{"$f":"IF(B9=$J$5,1,0)","v":0},"","kein Prüfungsfach gewählt",{"$f":"IF(B9=$M$5,1,0)","v":0}]
["4. Prüfungsfach (mdl.)",null," kein Prüfungsfach gewählt","4. Pr.F.",{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,$F$24:$J$41,2,FALSE))","v":""},{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,$F$24:$J$41,3,FALSE))","v":""},{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,$F$24:$J$41,4,FALSE))","v":""},{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,$F$24:$J$41,5,FALSE))","v":""},{"$f":"COUNTIF($B$7:$B$11,B10)","v":0},{"$f":"IF(B10=$J$5,1,0)","v":0},"","kein Prüfungsfach gewählt",{"$f":"IF(B10=$M$5,1,0)","v":0}]
["5. Prüfungskomponente",null," kein Prüfungsfach gewählt","5. Pk.",{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,$F$24:$J$41,2,FALSE))","v":""},{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,$F$24:$J$41,3,FALSE))","v":""},{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,$F$24:$J$41,4,FALSE))","v":""},{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,$F$24:$J$41,5,FALSE))","v":""},{"$f":"COUNTIF($B$7:$B$11,B11)","v":0},null,"","kein Prüfungsfach gewählt"]
["Verpflichtungen:",null,null,null,{"$f":"IF(COUNTIF(E7:E10,G24)>0,1)+IF(COUNTIF(E7:E10,G36)>0,1)+IF(COUNTIF(E7:E10,G27)>0,1)","v":0},{"$f":"COUNTIF($F$7:$F$11,\"1. Aufgabenfeld\")","v":0},{"$f":"COUNTIF(G9:G10,\"MKDS\")","v":0},{"$f":"COUNTIF(H7:H11,\"ZA\")","v":0},{"$f":"COUNTIF(I7:I11,1)","v":0},{"$f":"SUM(J7:J11)","v":0},null,null,{"$f":"SUM(M7:M11)","v":0}]
["alle Prüfungsfächer ausgewählt",null,{"$f":"IF(COUNTIF(L7:L11,\"\")=5,\"erfüllt\",\"nicht erfüllt\")","v":"nicht erfüllt"},null,null,{"$f":"COUNTIF($F$7:$F$11,\"2. Aufgabenfeld\")","v":0}]
["zwei Prüfungsfächer aus dem Bereich DE, einer FS und MA im 1. - 4. PF",null,{"$f":"IF(E12>1,\"erfüllt\",\"nicht erfüllt\")","v":"nicht erfüllt"},null,null,{"$f":"COUNTIF($F$7:$F$11,\"3. Aufgabenfeld\")","v":0}]
["mindestens ein Prüfungsfach oder 5. PK pro Aufgabenfeld",null,{"$f":"IF(COUNTIF($F$12:$F$14,0)<1,\"erfüllt\",\"nicht erfüllt\")","v":"nicht erfüllt"}]
["3. + 4. Prüfungsfach: Nur ein Fach aus MU, KU, DS, SP",null,{"$f":"IF(G12<2,\"erfüllt\",\"nicht erfüllt\")","v":"erfüllt"}]
["spezielle Verpflichtungen:"]
[{"$f":"IF(J12+M12=2,\"Du hast DS und Informatik als Prüfungsfach gewählt. Das geht nur, wenn du in der 10. Klasse beides als WPU belegt hast.\",IF(M12>0,\"Du hast DS als Prüfungsfach gewählt. Das geht nur, wenn du in der 10. Klasse DS als WPU belegt hast.\",IF(J12>0,\"Du hast Informatik als Prüfungsfach gewählt. Das geht nur, wenn du in der 10. Klasse Informatik als WPU belegt hast.\",\"\")))","v":""}]
[]
[{"$f":"IF(A18=\"\",\"\",\"Bitte bestätige dies kurz:\")","v":""},null,{"$f":"IF(A18=\"\",\"\",IF(B20=K23,\"erfüllt\",\"nicht erfüllt\"))","v":""}]
[]
["Auswahltabellen",null,null,null,null,"Prüftabelle",null,null,null,null,"Bestätigung Info"]
["1. Leistungskursfach","2. Leistungskursfach","3. Prüfungsfach (schriftl.)","4. Prüfungsfach (mündl.)","5. Prüfungskomponente","Fach","Aufgabenfeld","Fachbereich","Nur eins","Zwei aus","Ja, wurde in der 10. belegt."]
["Biologie","Biologie","Biologie","Biologie","Biologie","Deutsch","Deutsch","1. Aufgabenfeld",null,"ZA","Nein, habe ich nicht belegt."]
["Chemie","Chemie","Chemie","Chemie","Chemie","Musik",null,"1. Aufgabenfeld","MKDS"]
["Deutsch","Deutsch","Deutsch","Darstellendes Spiel","Darstellendes Spiel","Kunst",null,"1. Aufgabenfeld","MKDS"]
["Englisch","Englisch","Englisch","Deutsch","Deutsch","Englisch","Fremdsprache","1. Aufgabenfeld",null,"ZA"]
["Mathematik","Geografie","Französisch","Englisch","Englisch","Französisch","Fremdsprache","1. Aufgabenfeld",null,"ZA"]
["Physik","Geschichte","Geografie","Französisch","Französisch","Latein","Fremdsprache","1. Aufgabenfeld",null,"ZA"]
["Spanisch","Kunst","Geschichte","Geografie","Geografie","Spanisch","Fremdsprache","1. Aufgabenfeld",null,"ZA"]
[null,"Mathematik","Informatik","Geschichte","Geschichte","Darstellendes Spiel",null,"1. Aufgabenfeld","MKDS"]
[null,"Musik","Kunst","Informatik","Informatik","Politikwissenschaft",null,"2. Aufgabenfeld"]
[null,"Philosophie","Latein","Kunst","Kunst","Geschichte",null,"2. Aufgabenfeld"]
[null,"Physik","Mathematik","Latein","Latein","Geografie",null,"2. Aufgabenfeld"]
[null,"Politikwissenschaft","Musik","Mathematik","Mathematik","Philosophie",null,"2. Aufgabenfeld"]
[null,"Spanisch","Philosophie","Musik","Musik","Mathematik","Mathematik","3. Aufgabenfeld",null,"ZA"]
[null,null,"Physik","Philosophie","Philosophie","Physik",null,"3. Aufgabenfeld"]
[null,null,"Politikwissenschaft","Physik","Physik","Chemie",null,"3. Aufgabenfeld"]
[null,null,"Spanisch","Politikwissenschaft","Politikwissenschaft","Biologie",null,"3. Aufgabenfeld"]
[null,null,null,"Spanisch","Spanisch","Informatik",null,"3. Aufgabenfeld"]
[null,null,null,"Sport","Sport","Sport",null,"4. Aufgabenfeld","MKDS"]

{"sheet":"Kurswahl2","index":2,"n_rows":61,"n_cols":37,"rows_kept":61,"cut":false,"hidden":false,"merged":[[6,24,6,27],[8,15,8,19],[18,15,18,19],[22,15,22,19],[49,14,49,15],[25,14,28,19],[46,18,47,18],[46,14,46,15],[47,14,47,15],[48,14,48,15],[21,15,21,19],[39,14,39,19],[37,0,48,0],[23,3,23,6],[30,3,30,6],[35,3,35,6],[7,9,7,12],[9,0,16,0],[19,0,22,0],[25,0,29,0],[32,0,33,0],[9,9,9,12],[7,3,7,6],[18,9,18,12],[25,9,25,12],[38,7,45,7],[4,24,4,27],[2,24,2,27],[17,3,17,6],[6,0,6,7],[16,15,16,19],[17,15,17,19],[6,9,6,12],[6,14,6,19],[10,15,10,19],[9,15,9,19],[7,15,7,19],[11,15,11,19],[15,15,15,19],[14,15,14,19],[13,15,13,19],[12,15,12,19]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warnmeldung: 1 = zuviele Kurse",null,null,null,"Zsfsg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(Kurswahl2!$O$8:$O$22,\"nicht erfüllt\")<1,\"\",\"formale Bedingungen nicht vollständig erfüllt\")","v":"formale Bedingungen nicht vollständig erfüllt"},null,null,null,null,{"$f":"IF(Y6>10,1,0)","v":0},{"$f":"IF(Z6>10,1,0)","v":0},0,0,{"$f":"SUM(Y4:AB4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#Kurse/Semester"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Y18:Y36,\"WAHR\")+COUNTIF(Y11:Y16,\"WAHR\")","v":0},{"$f":"COUNTIF(Z18:Z36,\"WAHR\")+COUNTIF(Z11:Z16,\"WAHR\")","v":0},{"$f":"COUNTIF(AA18:AA36,\"WAHR\")+COUNTIF(AA11:AA16,\"WAHR\")","v":0},{"$f":"COUNTIF(AB18:AB36,\"WAHR\")+COUNTIF(AB11:AB16,\"WAHR\")","v":0}]
["Übersicht",null,null,null,null,null,null,null,null,"Wahlboxen",null,null,null,null,"Verpflichtungen",null,null,null,null,null,null,"Verpflichtungen erfüllt?",null,null,"Wahlboxverknüpfungen",null,null,null,null,"LK Kurse","GK Kurse",null," Prüfung 2 Semester hintereinander?","Prüfung das Fächer blockweise belegt werden","Kurse nicht einzeln in Q2 oder 4 gewählt"]
[null,null,null,"Semester",null,null,null,null,null,"Semester",null,null,null,null,{"$f":"IF(V8=1,\"erfüllt\",\"nicht erfüllt\")","v":"nicht erfüllt"},"Prüfungsfächerwahl möglich",null,null,null,null,null,{"$f":"IF(COUNTIF(Kurswahl1!C13:C16,\"erfüllt\")=4,1,0)","v":0},null,null,"hier wird nur ausgegeben, was der Schüler vorne"]
[null,"Fach","Pr.fach","1.","2.","3.","4.","einbringbar",null,"1.","2.","3.","4.",null,"erfüllt","Deutsch vier Semester",null,null,null,null,null,{"$f":"IF(H10=4,1,0)","v":1},null,null,"angekreuzt hat, um damit weiterzuarbeiten"]
["1. AF","Deutsch",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B10)>0,VLOOKUP(B10,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"x","x","x","x",4,null,null,null,null,null,null,"nicht erfüllt","eine Fremdsprache vier Semester",null,null,null,null,null,{"$f":"IF(H13=4,1,IF(H14=4,1,IF(H15=4,1,IF(H16=4,1,0))))","v":0},null,null,null,null,null,null,null,{"$f":"IF(C10=\"1. Pr.F.\",H10,IF(C10=\"2. Pr.F.\",H10,0))","v":0},{"$f":"IF(C10=\"1. Pr.F.\",0,IF(C10=\"2. Pr.F.\",0,H10))","v":4},null,null,null,"Kurse im Semester","zulässig??","zulässige Kurskombinationen"]
[null,"Musik",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B11)>0,VLOOKUP(B11,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},{"$f":"IF($C11<>\"\",\"x\",IF(Y11=TRUE,\"x\",\"\"))","v":""},"","","",{"$f":"COUNTIF(D11:G11,\"x\")","v":0},null,null,null,null,null,null,"erfüllt","Mathematik vier Semester",null,null,null,null,null,{"$f":"IF(H26=4,1,0)","v":1},null,null,false,false,false,false,null,0,0,null,{"$f":"IF(COUNTIF(D11:E11,\"x\")=2,1,IF(COUNTIF(F11:G11,\"x\")=2,1,0))","v":0},{"$f":"IF(AND(Y11=Z11,AA11=AB11),1,0)","v":1},{"$f":"IF(Y11=TRUE,1,\"\")&IF(Z11=TRUE,2,\"\")&IF(AA11=TRUE,3,\"\")&IF(AB11=TRUE,4,\"\")","v":""},{"$f":"IF(AI11=\"\",1,COUNTIF($AK$11:$AK$16,AI11))","v":1},1234]
[null,"Kunst",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B12)>0,VLOOKUP(B12,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","","","",{"$f":"COUNTIF(D12:G12,\"x\")","v":0},null,null,null,null,null,null,"nicht erfüllt","eine NaWi (Ph, Ch, Bio) vier Semester",null,null,null,null,null,{"$f":"IF(H27=4,1,IF(H28=4,1,IF(H29=4,1,0)))","v":0},null,null,false,false,false,false,null,0,0,null,{"$f":"IF(COUNTIF(D12:E12,\"x\")=2,1,IF(COUNTIF(F12:G12,\"x\")=2,1,0))","v":0},{"$f":"IF(AND(Y12=Z12,AA12=AB12),1,0)","v":1},{"$f":"IF(Y12=TRUE,1,\"\")&IF(Z12=TRUE,2,\"\")&IF(AA12=TRUE,3,\"\")&IF(AB12=TRUE,4,\"\")","v":""},{"$f":"IF(AI12=\"\",1,COUNTIF($AK$11:$AK$16,AI12))","v":1},123]
[null,"Englisch",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B13)>0,VLOOKUP(B13,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","","","",0,null,null,null,null,null,null,"nicht erfüllt","Ph o. Ch zwei Semester hintereinander (blockweise)",null,null,null,null,null,{"$f":"IF(SUM(AG27:AG28)>0,1,0)","v":0},null,null,false,false,false,false,null,0,0,null,null,1,"",1,234]
[null,"Französisch",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B14)>0,VLOOKUP(B14,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","","","",0,null,null,null,null,null,null,"nicht erfüllt","GeWi-Regelung",null,null,null,null,null,{"$f":"IF(W54+W55=2,1,0)","v":0},null,null,false,false,false,false,null,0,0,null,null,1,"",1,12]
[null,"Latein",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B15)>0,VLOOKUP(B15,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","","","",0,null,null,null,null,null,null,"nicht erfüllt","Mu, Ku oder DS mindestens zwei Semester hintereinander (blockweise)",null,null,null,null,null,{"$f":"IF(AG11+AG12+AG17>0,1,0)","v":0},null,null,false,false,false,false,null,0,0,null,null,1,"",1,34]
[null,"Spanisch",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B16)>0,VLOOKUP(B16,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","","","",0,null,null,null,null,null,null,"erfüllt","Sport",null,null,null,null,null,{"$f":"IF(COUNTIF(D34:G34,\"x\")=4,1,0)","v":1},null,null,false,false,false,false,null,0,0,null,null,1,"",1,1]
[null,"Darstellendes Spiel",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B17)>0,VLOOKUP(B17,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","","","",0,null,null,null,null,null,null,{"$error":"#VALUE!"},"mindestens 40 Kurse",null,null,null,null,null,{"$f":"IF(Q49>=40,1,0)","v":{"$error":"#VALUE!"}},null,null,false,false,false,false,null,0,0,null,{"$f":"IF(COUNTIF(D17:E17,\"x\")=2,1,IF(COUNTIF(F17:G17,\"x\")=2,1,0))","v":0},1,"",1]
[null,null,null,"Semester",null,null,null,null,null,null,null,null,null,null,"nicht erfüllt","mindestens 32 einbringbare Kurse",null,null,null,null,null,{"$f":"IF(SUM(H10:H49)>=32,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",1]
[null,"Fach","Pr.fach","1.","2.","3.","4.","einbringbar",null,null,null,null,null,null,{"$error":"#VALUE!"},"mindestens 132 Gesamtstunden über vier Semester",null,null,null,null,null,{"$f":"IF(R47+R48>=132,1,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"",1]
["2. AF","Politikwissenschaft",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B20)>0,VLOOKUP(B20,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},{"$f":"IF($C20<>\"\",\"x\",IF(Y20=TRUE,\"x\",\"\"))","v":""},{"$f":"IF($C20<>\"\",\"x\",IF(Z20=TRUE,\"x\",\"\"))","v":""},{"$f":"IF($C20<>\"\",\"x\",IF(AA20=TRUE,\"x\",\"\"))","v":""},{"$f":"IF($C20<>\"\",\"x\",IF(AB20=TRUE,\"x\",\"\"))","v":""},{"$f":"COUNTIF(D20:G20,\"x\")","v":0},null,null,null,null,null,null,"erfüllt","Informatik/DS-Abitur (3./4. PF) nur mit WPU Informatik/DS",null,null,null,null,null,{"$f":"IF(Kurswahl1!C20=\"nicht erfüllt\",0,1)","v":1},null,null,false,false,false,false,null,{"$f":"IF(C20=\"1. Pr.F.\",H20,IF(C20=\"2. Pr.F.\",H20,0))","v":0},{"$f":"IF(C20=\"1. Pr.F.\",0,IF(C20=\"2. Pr.F.\",0,H20))","v":0},null,null,{"$f":"IF(AND(Y20=Z20,AA20=AB20),1,0)","v":1},"",1]
[null,"Geschichte",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B21)>0,VLOOKUP(B21,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},{"$f":"IF($C21<>\"\",\"x\",IF(Y21=TRUE,\"x\",\"\"))","v":""},"","x","x",{"$f":"COUNTIF(D21:G21,\"x\")","v":2},null,null,null,null,null,null,{"$f":"IF(V21=0,\"erfüllt\",\"nicht erfüllt\")","v":"erfüllt"},{"$f":"IF(V21=0,\"Wähle im Pflichtbereich (1. bis 3.AF inkl. Sport = hellblau) maximal 11 Kurse (Ausnahme: DS wird dabei nicht angerechnet)\",\"Du hast in mindestens einem Semester zu viele (>11) Kurse im Pflichtbereich (=hellblau) gewählt!\")","v":"Wähle im Pflichtbereich (1. bis 3.AF inkl. Sport = hellblau) maximal 11 Kurse (Ausnahme: DS wird dabei nicht angerechnet)"},null,null,null,null,null,{"$f":"AC4","v":0},null,null,false,false,false,false,null,{"$f":"IF(C21=\"1. Pr.F.\",H21,IF(C21=\"2. Pr.F.\",H21,0))","v":0},{"$f":"IF(C21=\"1. Pr.F.\",0,IF(C21=\"2. Pr.F.\",0,H21))","v":2},null,null,1,"",1]
[null,"Geografie",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B22)>0,VLOOKUP(B22,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","",{"$f":"IF($C22<>\"\",\"x\",IF(AA22=TRUE,\"x\",\"\"))","v":""},{"$f":"IF($C22<>\"\",\"x\",IF(AB22=TRUE,\"x\",\"\"))","v":""},0,null,null,null,null,null,null,{"$f":"IF(V22=1,\"erfüllt\",\"nicht erfüllt\")","v":"erfüllt"},"Kurse können nur zusammenhängend im Block belegt werden (z.B. 1,2,3,4 o. 1,2,3 o. 2,3,4. o. 1,2 o. 3,4 o. 1)",null,null,null,null,null,{"$f":"IF(OR(COUNTIF(AJ11:AJ51,0)>0,AI48=1),0,1)","v":1},null,null,false,false,false,false,null,{"$f":"IF(C22=\"1. Pr.F.\",H22,IF(C22=\"2. Pr.F.\",H22,0))","v":0},{"$f":"IF(C22=\"1. Pr.F.\",0,IF(C22=\"2. Pr.F.\",0,H22))","v":0},null,null,1,"",1]
[null,"Philosophie",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B23)>0,VLOOKUP(B23,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","",{"$f":"IF($C23<>\"\",\"x\",IF(AA23=TRUE,\"x\",\"\"))","v":""},{"$f":"IF($C23<>\"\",\"x\",IF(AB23=TRUE,\"x\",\"\"))","v":""},0,null,null,null,null,null,null,"wird nicht geprüft","maximal 32 einzubringende Pflichtkurse",null,null,null,null,null,null,null,null,false,false,false,false,null,{"$f":"IF(C23=\"1. Pr.F.\",H23,IF(C23=\"2. Pr.F.\",H23,0))","v":0},{"$f":"IF(C23=\"1. Pr.F.\",0,IF(C23=\"2. Pr.F.\",0,H23))","v":0},null,null,1,"",1]
[null,null,null,"Semester"]
[null,"Fach","Pr.fach","1.","2.","3.","4.","einbringbar",null,null,null,null,null,null,"Hinweise:"]
["3. AF","Mathematik",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B26)>0,VLOOKUP(B26,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"x","x","x","x",4,null,null,null,null,null,null,"Für das Abitur müssen Sie 32 Kurse einbringen - jedoch nicht beliebig. Es gibt feste Regeln für das Einbringen von Kursen. Wenn Sie alle obigen Ver- pflichtungen erfüllt haben, können Sie ein Abitur erhalten - zumindest erfüllen Sie alle Grundvoraussetzungen Ihnen aus den von Ihnen gewählten Kursen ein Abitur zusammenzustellen. Ob Sie jedoch auch alle Kurse einbringen können, die Sie WOLLEN, wird hier NICHT geprüft. Bitte lassen Sie sich individuell beraten, was Sie belegen müssen, um den einen Kurs notenrelevant und den anderen Kurs im Abitur nicht zu berücksichtigen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26=\"1. Pr.F.\",H26,IF(C26=\"2. Pr.F.\",H26,0))","v":0},{"$f":"IF(C26=\"1. Pr.F.\",0,IF(C26=\"2. Pr.F.\",0,H26))","v":4},null,null,null,"",1]
[null,"Physik",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B27)>0,VLOOKUP(B27,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},{"$f":"IF($C27<>\"\",\"x\",IF(Y27=TRUE,\"x\",\"\"))","v":""},"","","",{"$f":"COUNTIF(D27:G27,\"x\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,null,{"$f":"IF(C27=\"1. Pr.F.\",H27,IF(C27=\"2. Pr.F.\",H27,0))","v":0},{"$f":"IF(C27=\"1. Pr.F.\",0,IF(C27=\"2. Pr.F.\",0,H27))","v":0},null,{"$f":"IF(COUNTIF(D27:E27,\"x\")=2,1,IF(COUNTIF(F27:G27,\"x\")=2,1,0))","v":0},{"$f":"IF(AND(Y27=Z27,AA27=AB27),1,0)","v":1},"",1]
[null,"Chemie",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B28)>0,VLOOKUP(B28,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","","","",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,null,{"$f":"IF(C28=\"1. Pr.F.\",H28,IF(C28=\"2. Pr.F.\",H28,0))","v":0},{"$f":"IF(C28=\"1. Pr.F.\",0,IF(C28=\"2. Pr.F.\",0,H28))","v":0},null,{"$f":"IF(COUNTIF(D28:E28,\"x\")=2,1,IF(COUNTIF(F28:G28,\"x\")=2,1,0))","v":0},1,"",1]
[null,"Biologie",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B29)>0,VLOOKUP(B29,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},{"$f":"IF($C29<>\"\",\"x\",IF(Y29=TRUE,\"x\",\"\"))","v":""},"","","",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,null,{"$f":"IF(C29=\"1. Pr.F.\",H29,IF(C29=\"2. Pr.F.\",H29,0))","v":0},{"$f":"IF(C29=\"1. Pr.F.\",0,IF(C29=\"2. Pr.F.\",0,H29))","v":0},null,null,1,"",1]
[null,"Informatik",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B30)>0,VLOOKUP(B30,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"","","","",0,null,null,null,null,null,null,"Hier ein paar Hinweise, was Sie einbringen müssen (die Liste ist nicht vollständig):",null,null,null,null,null,null,null,null,null,false,false,false,false,null,{"$f":"IF(C30=\"1. Pr.F.\",H30,IF(C30=\"2. Pr.F.\",H30,0))","v":0},{"$f":"IF(C30=\"1. Pr.F.\",0,IF(C30=\"2. Pr.F.\",0,H30))","v":0},null,null,1,"",1]
[null,null,null,"Semester",null,null,null,null,null,null,null,null,null,null,"Einbringen müssen Sie jeweils 4 Kurse aus Deutsch, Mathematik und einer Fremdsprache.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AI31=\"\",\"\",COUNTIF($AK$11:$AK$16,AI31))","v":""}]
[null,"Fach","Pr.fach","1.","2.","3.","4.","einbringbar",null,null,null,null,null,null,"Einbringen müssen Sie jeweils 4 Kurse aller Prüfungsfächer.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["Sport","Sport Theorie",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B33)>0,VLOOKUP(B33,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},null,{"$f":"IF($C$34<>\"\",\"x\",IF($C$33<>\"\",\"x\",IF(Z33=TRUE,\"x\",\"\")))","v":""},{"$f":"IF($C$34<>\"\",\"x\",IF($C$33<>\"\",\"x\",IF(AA33=TRUE,\"x\",\"\")))","v":""},null,{"$f":"COUNTIF(D33:G33,\"x\")","v":0},null,null,null,null,null,null,"Einbringen müssen Sie mindestens den letzten Kurs des Faches, in dem Sie die 5. PK haben.",null,null,null,null,null,null,null,null,null,null,false,{"$f":"Z33","v":false},null,null,0,{"$f":"IF(C33=\"1. Pr.F.\",0,IF(C33=\"2. Pr.F.\",0,H33))","v":0},null,null,null,"",""]
[null,"Sport",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B34)>0,VLOOKUP(B34,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},"x","x","x","x",4,null,null,null,null,null,null,"Einbringen müssen Sie mindestens 2 Kurse aus den Fächern Kunst, Musik, Darstellendes Spiel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4,null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(H35=\"\",\"\",\"Sport Sonderregelungen*\")","v":""},{"$f":"IF(C34=\"\",IF(H33+H48+H49=0,\"\",H33*(-1)+H48*(-1)+H49*(-1)),IF(H33+H48+H49=0,\"\",H33*(-1)+H48*(-1)+H49*(-1)+1))","v":""},null,null,null,null,null,null,"Einbringen müssen Sie 4 Kurse eines Faches aus den Gesellschaftswissenschaften.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,"Semester",null,null,null,null,null,null,null,null,null,null,"Einbringen müssen Sie 4 Kurse eines Faches aus den Naturwissenschaften…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuletzt-gewählt-Prüfung",null,"",""]
[null,"Fach","Pr.fach","1.","2.","3.","4.","einbringbar",null,null,null,null,null,null,"Aus allen Zusatzkursen können Sie maximal 8 einbringen (davon max. 2x ZK Ensemblemusik, 2x ZK S. u. B. und max. 4 andere ZK).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["Zusatzkurse (ZK) und weitere Kurse","ZK: Ensemblemusik",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B38)>0,VLOOKUP(B38,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},{"$f":"IF($C38<>\"\",\"x\",IF(Y38=TRUE,\"x\",\"\"))","v":""},"","","",{"$f":"IF(COUNTIF(D38:G38,\"x\")>2,2,COUNTIF(D38:G38,\"x\"))","v":0},null,null,null,null,null,null,"Wurde Sport in einer Prüfung gewählt, belegen Sie automatisch auch Sport Theorie.",null,null,null,null,null,null,null,null,null,false,{"$f":"Y38","v":false},false,{"$f":"AA38","v":false},null,{"$f":"IF(C38=\"1. Pr.F.\",H38,IF(C38=\"2. Pr.F.\",H38,0))","v":0},{"$f":"IF(C38=\"1. Pr.F.\",0,IF(C38=\"2. Pr.F.\",0,COUNTIF(D38:G38,\"x\")))","v":0}]
[null,"Latein",null,"","","","",{"$f":"IF(COUNTIF(D39:G46,\"x\")>4,4,COUNTIF(D39:G46,\"x\"))","v":0},null,null,null,null,null,null,"Eine GeWi durchgehend (wenn Ge durchgehend, dann PW mind. im 3./4. Semester oder Geo oder Philo durchgehend.)",null,null,null,null,null,null,null,null,null,false,false,false,false,null,{"$f":"IF(C39=\"1. Pr.F.\",#REF!,IF(C39=\"2. Pr.F.\",#REF!,0))","v":0},0,null,"Q12 erlaubt","Q34 erlaubt","Kommentarhinweise"]
[null,"ZK: Rhetorik",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B40)>0,VLOOKUP(B40,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},{"$f":"IF($C40<>\"\",\"x\",IF(AND(Y40=TRUE,AG40=1),\"x\",\"\"))","v":""},{"$f":"IF($C40<>\"\",\"x\",IF(AND(Z40=TRUE,AG40=1),\"x\",\"\"))","v":""},{"$f":"IF($C40<>\"\",\"x\",IF(AND(AA40=TRUE,AH40=1),\"x\",\"\"))","v":""},{"$f":"IF($C40<>\"\",\"x\",IF(AND(AB40=TRUE,AH40=1),\"x\",\"\"))","v":""},null,null,null,null,null,null,null,"Kursiv gedruckte Zusatzkurse können nur in Q1/2 oder Q3/4 gewählt werden.",null,null,null,null,null,null,null,null,null,false,false,false,false,null,{"$f":"IF(C40=\"1. Pr.F.\",H39,IF(C40=\"2. Pr.F.\",H39,0))","v":0},{"$f":"IF(C40=\"1. Pr.F.\",0,IF(C40=\"2. Pr.F.\",0,COUNTIF(D40:G40,\"x\")))","v":0},null,{"$f":"IF(Y40=FALSE,0,IF(AA40=TRUE,0,1))","v":0},{"$f":"IF(AA40=FALSE,0,IF(Y40=TRUE,0,1))","v":0},{"$f":"IF(COUNTIF(Y40:AB40,TRUE)=4,1,0)","v":0}]
[null,"ZK: Robotik",null,{"$f":"IF($C41<>\"\",\"x\",IF(AND(Y41=TRUE,AG41=1),\"x\",\"\"))","v":""},{"$f":"IF($C41<>\"\",\"x\",IF(AND(Z41=TRUE,AG41=1),\"x\",\"\"))","v":""},{"$f":"IF($C41<>\"\",\"x\",IF(AND(AA41=TRUE,AH41=1),\"x\",\"\"))","v":""},{"$f":"IF($C41<>\"\",\"x\",IF(AND(AB41=TRUE,AH41=1),\"x\",\"\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H35=\"\",\"\",\"*Sport Sonderregelung: max. 4 Sportkurse (inkl. Theorie) wenn kein PF, max. 5 Sportkurse (inkl. Theorie) wenn PF\")","v":""},null,null,null,null,null,null,null,null,null,false,false,false,false,null,0,{"$f":"IF(C41=\"1. Pr.F.\",0,IF(C41=\"2. Pr.F.\",0,COUNTIF(D41:G41,\"x\")))","v":0},null,{"$f":"IF(Y41=FALSE,0,IF(AA41=TRUE,0,1))","v":0},{"$f":"IF(AA41=FALSE,0,IF(Y41=TRUE,0,1))","v":0},{"$f":"IF(COUNTIF(Y41:AB41,TRUE)=4,1,0)","v":0}]
[null,"ZK: Natur - Raum - Kunst",null,"","","","",null,null,null,null,null,null,null,{"$f":"IF(AND(E48=\"\",F49=\"\"),\"\",\"Ski und Surfen erhöhen die Zahl der einbringbaren Kurse nicht.\")","v":""},null,null,null,null,null,null,null,null,null,false,false,false,false,null,0,{"$f":"IF(C42=\"1. Pr.F.\",0,IF(C42=\"2. Pr.F.\",0,COUNTIF(D42:G42,\"x\")))","v":0},null,0,0,0]
[null,"ZK: EDEN ",null,"","","","",null,null,null,null,null,null,null,{"$f":"IF(H13<4,\"Sind Sie sicher, dass Sie Englisch abwählen können? PäKo fragen!\",\"\")","v":"Sind Sie sicher, dass Sie Englisch abwählen können? PäKo fragen!"},null,null,null,null,null,null,null,null,null,false,{"$f":"Y43","v":false},false,{"$f":"AA43","v":false},null,0,{"$f":"IF(C43=\"1. Pr.F.\",0,IF(C43=\"2. Pr.F.\",0,COUNTIF(D43:G43,\"x\")))","v":0},null,0,0,0]
[null,"ZK: Wittenberggalaxis",null,"","","","",null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(D39:G39,\"x\")>0,COUNTIF(D39:E39,\"x\")<>2),\"Wenn Sie das Latinuum anstreben, müssen Sie mindestens die ersten beiden Semester Latein belegen.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,false,false,false,{"$f":"AA44","v":false},null,0,{"$f":"IF(C44=\"1. Pr.F.\",0,IF(C44=\"2. Pr.F.\",0,COUNTIF(D44:G44,\"x\")))","v":0},null,0,0,0]
[null,"ZK: Digitale Welten",null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,{"$f":"AA45","v":false},null,0,{"$f":"IF(C45=\"1. Pr.F.\",0,IF(C45=\"2. Pr.F.\",0,COUNTIF(D45:G45,\"x\")))","v":0},null,0,0,0]
[null,"ZK: Welttanzprogramm",null,"","","","",null,null,null,null,null,null,null,null,null,"Kurse","Stunden","Stunden insg.",null,null,null,null,null,false,false,false,false,null,0,0,null,0,0,0]
[null,"ZK: Studium und Beruf",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B47)>0,VLOOKUP(B47,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},{"$f":"IF($C47<>\"\",\"x\",IF(Y47=TRUE,\"x\",\"\"))","v":""},{"$f":"IF($C47<>\"\",\"x\",IF(Z47=TRUE,\"x\",\"\"))","v":""},"",null,{"$f":"IF(COUNTIF(D47:G47,\"x\")>2,2,COUNTIF(D47:G47,\"x\"))","v":0},null,null,null,null,null,null,"Leistungskursfächer (5h)",null,{"$f":"IF(COUNTIF(C10:C49,\"1. Pr.F.\")=1,IF(COUNTIF(C10:C49,\"2. Pr.F.\")=1,8,\"Error\"),\"Error\")","v":"Error"},{"$f":"Q47*5","v":{"$error":"#VALUE!"}},{"$f":"R47+R48","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,false,false,null,null,0,{"$f":"IF(C47=\"1. Pr.F.\",0,IF(C47=\"2. Pr.F.\",0,H47))","v":0}]
[null,"Ski und Snowboard",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B48)>0,VLOOKUP(B48,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},null,{"$f":"IF($C48<>\"\",\"x\",IF(Y48=TRUE,\"x\",\"\"))","v":""},null,null,{"$f":"IF(COUNTIF(D48:G48,\"x\")>2,2,COUNTIF(D48:G48,\"x\"))","v":0},null,null,null,null,null,null,"Grundkurse (3h) + Sportpraxis(2h)",null,{"$f":"SUM(AE10:AE49)","v":14},{"$f":"SUM(AE10:AE33)*3+SUM(AE38:AE47)*3+2*(AE34+AE48+AE49)","v":38},null,null,null,null,null,null,false,null,null,null,null,0,{"$f":"IF(C48=\"1. Pr.F.\",0,IF(C48=\"2. Pr.F.\",0,COUNTIF(D48:G48,\"x\")))","v":0},null,null,null,{"$f":"SUM(AI40:AI47)","v":0}]
[null,"Surfen",{"$f":"IF(COUNTIF(Kurswahl1!$B$7:$B$11,Kurswahl2!B49)>0,VLOOKUP(B49,Kurswahl1!$B$7:$D$11,3,FALSE),\"\")","v":""},null,null,{"$f":"IF($C49<>\"\",\"x\",IF(AA49=TRUE,\"x\",\"\"))","v":""},null,0,null,null,null,null,null,null,"Kurse insgesamt",null,{"$f":"Q47+Q48","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,false,null,null,0,{"$f":"IF(C49=\"1. Pr.F.\",0,IF(C49=\"2. Pr.F.\",0,COUNTIF(D49:G49,\"x\")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"davon einbringbare Kurse",null,{"$f":"SUM(H10:H49)","v":14}]
[]
[]
["Im Folgenden sind die eingebauten Regelungen aufgelistet, die die Einbringbarkeit eines Kurses beschränken",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GeWi Sonderregelungen aufgeschlüsselt"]
["Der Kurs Ensemblemusik ist auf maximal 2 einbringbare Kurse limitiert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(COUNTIF(D20:G20,\"x\")=4,COUNTIF(D21:G21,\"x\")=4,COUNTIF(D22:G22,\"x\")=4,COUNTIF(D23:G23,\"x\")=4),1,0)","v":0},"eine GeWi muss durchgehend belegt werden"]
["Zusatzkurse sind auf maximal 8 einbringbare Kurse limitiert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D21:G21,\"x\")=4,IF(AND(OR(COUNTIF(D22:G22,\"x\")=4,COUNTIF(D23:G23,\"x\")=4,COUNTIF(F20:G20,\"x\")=2))=TRUE,1,0),1)","v":1},"Wenn Sie Geschichte durchgehend belegen, müssen Sie entweder PW im 3. & 4. Semester oder Geografie oder Philosophie durchgehend belegen."]
["Der Kurs Latein ist auf maximal 2 einbringbare Kurse limitiert"]
["Der Kurs Studium und Beruf ist auf maximal 2 einbringbare Kurse limitiert"]
["Ski und Surfen können nicht eingebracht werden"]
["Wird Sport als Prüfungsfach gewählt, so wird automatisch Sport Theorie belegt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"alte Sonderregelung"]
["Max 10 bzw. 11 Kurse im blauen (Pflicht-)Bereich",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D20:G20,\"x\")=4,IF(AND(OR(COUNTIF(D22:G22,\"x\")=4,COUNTIF(D23:G23,\"x\")=4,COUNTIF(F21:G21,\"x\")=2))=TRUE,1,0),1)","v":1},"Wenn Sie PW durchgehend belegen, müssen Sie entweder Geschichte im 3. & 4. Semester oder Geografie oder Philosophie durchgehend belegen."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(COUNTIF(F21:G21,\"x\")=2,COUNTIF(D20:G20,\"x\")=4),1,0)","v":1},"Sie müssen in jedem Fall Geschichte im 3. & 4. Semester oder PW durchgehend belegen."]

{"sheet":"Persönliche Angaben","index":3,"n_rows":111,"n_cols":19,"rows_kept":111,"cut":false,"hidden":false,"merged":[[10,1,10,3],[14,1,14,3],[5,1,5,3],[17,1,17,3],[0,7,0,13]]}
[null,null,null,null,null,null,null,"Dropdown-Profilierungskurse (roter Bereich aus Kursübersicht der Profilierungskurse -> Mittelstufenkoordinator oder Qualitätsbeauftragten fragen)"]
[null,null,null,null,null,null,null,"funktioniert ergänzbar im blauen Bereich",null,null,"P8","P9","P10","Titel","P8lfdNr.","P9lfdNr.","P10lfdNr.",{"$f":"M2","v":"P10"},{"$f":"N2","v":"Titel"}]
[null,null,null,null,null,null,null,null,null,null,"P8TH1","P9TH1","-","Pantomime/ Masken ",{"$f":"IF(OR(K3=\"-\",K3=\"\"),\"\",MAX(O$1:O2)+1)","v":1},{"$f":"IF(OR(L3=\"-\",L3=\"\"),\"\",MAX(P$1:P2)+1)","v":1},{"$f":"IF(OR(M3=\"-\",M3=\"\"),\"\",MAX(Q$1:Q2)+1)","v":""},{"$f":"M3","v":"-"},{"$f":"N3","v":"Pantomime/ Masken "}]
[null,null,null,null,null,null,null,"Liste bis Zeile 100 funktionsfähig",null,null,"-","P9TH2","P10TH2","Improvisationstheater",{"$f":"IF(OR(K4=\"-\",K4=\"\"),\"\",MAX(O$1:O3)+1)","v":""},{"$f":"IF(OR(L4=\"-\",L4=\"\"),\"\",MAX(P$1:P3)+1)","v":2},{"$f":"IF(OR(M4=\"-\",M4=\"\"),\"\",MAX(Q$1:Q3)+1)","v":1},"P10TH2","Improvisationstheater"]
[null,null,null,null,null,null,1,{"$f":"IF(G5=\"\",\"\",VLOOKUP(G5,$Q$3:$S$102,2,FALSE)&\" - \"&VLOOKUP(G5,$Q$3:$S$102,3,FALSE))","v":"P10TH2 - Improvisationstheater"},null,null,"P8DE1","P9DE1","P10DE1","Die innere Bühne - Aktivwerkstatt Hörspiel/-feature",{"$f":"IF(OR(K5=\"-\",K5=\"\"),\"\",MAX(O$1:O4)+1)","v":2},{"$f":"IF(OR(L5=\"-\",L5=\"\"),\"\",MAX(P$1:P4)+1)","v":3},{"$f":"IF(OR(M5=\"-\",M5=\"\"),\"\",MAX(Q$1:Q4)+1)","v":2},"P10DE1","Die innere Bühne - Aktivwerkstatt Hörspiel/-feature"]
[null,"Persönliche Angaben",null,null,null,null,{"$f":"IF(OR(G5=MAX(Q3:Q102),G5=\"\"),\"\",MAX($G$4:G5)+1)","v":2},{"$f":"IF(G6=\"\",\"\",VLOOKUP(G6,$Q$3:$S$102,2,FALSE)&\" - \"&VLOOKUP(G6,$Q$3:$S$102,3,FALSE))","v":"P10DE1 - Die innere Bühne - Aktivwerkstatt Hörspiel/-feature"},null,null,"P8DE2","P9DE2","P10DE2","Maximal Report (Jugendpresse des MDGs)",{"$f":"IF(OR(K6=\"-\",K6=\"\"),\"\",MAX(O$1:O5)+1)","v":3},{"$f":"IF(OR(L6=\"-\",L6=\"\"),\"\",MAX(P$1:P5)+1)","v":4},{"$f":"IF(OR(M6=\"-\",M6=\"\"),\"\",MAX(Q$1:Q5)+1)","v":3},"P10DE2","Maximal Report (Jugendpresse des MDGs)"]
[null,null,"Name",null,null,null,{"$f":"IF(OR(G6=MAX(Q4:Q103),G6=\"\"),\"\",MAX($G$4:G6)+1)","v":3},"P10DE2 - Maximal Report (Jugendpresse des MDGs)",null,null,"P8DE3","P9DE3","-","Bücherbörse",{"$f":"IF(OR(K7=\"-\",K7=\"\"),\"\",MAX(O$1:O6)+1)","v":4},{"$f":"IF(OR(L7=\"-\",L7=\"\"),\"\",MAX(P$1:P6)+1)","v":5},{"$f":"IF(OR(M7=\"-\",M7=\"\"),\"\",MAX(Q$1:Q6)+1)","v":""},"-","Bücherbörse"]
[null,null,"Vorname(n!)",null,null,null,{"$f":"IF(OR(G7=MAX(Q5:Q104),G7=\"\"),\"\",MAX($G$4:G7)+1)","v":4},"P10DE4 - Buchstabenbaustelle, Textwerkstatt, Literaturschmiede",null,null,"P8DE4","P9DE4","P10DE4","Buchstabenbaustelle, Textwerkstatt, Literaturschmiede",{"$f":"IF(OR(K8=\"-\",K8=\"\"),\"\",MAX(O$1:O7)+1)","v":5},{"$f":"IF(OR(L8=\"-\",L8=\"\"),\"\",MAX(P$1:P7)+1)","v":6},{"$f":"IF(OR(M8=\"-\",M8=\"\"),\"\",MAX(Q$1:Q7)+1)","v":4},"P10DE4","Buchstabenbaustelle, Textwerkstatt, Literaturschmiede"]
[null,null,"Geburtstag",null,null,null,{"$f":"IF(OR(G8=MAX(Q6:Q105),G8=\"\"),\"\",MAX($G$4:G8)+1)","v":5},"P10DE5 - MDG Satiregipfel",null,null,"P8DE5","P9DE5","P10DE5","MDG Satiregipfel",{"$f":"IF(OR(K9=\"-\",K9=\"\"),\"\",MAX(O$1:O8)+1)","v":6},{"$f":"IF(OR(L9=\"-\",L9=\"\"),\"\",MAX(P$1:P8)+1)","v":7},{"$f":"IF(OR(M9=\"-\",M9=\"\"),\"\",MAX(Q$1:Q8)+1)","v":5},"P10DE5","MDG Satiregipfel"]
[null,null,"Geburtsort",null,null,null,{"$f":"IF(OR(G9=MAX(Q7:Q106),G9=\"\"),\"\",MAX($G$4:G9)+1)","v":6},"P10EN1 - Of detectives, wizards and robots - come and join the fantastic world of reading",null,null,"P8EN1","-","P10EN1","Of detectives, wizards and robots - come and join the fantastic world of reading",{"$f":"IF(OR(K10=\"-\",K10=\"\"),\"\",MAX(O$1:O9)+1)","v":7},{"$f":"IF(OR(L10=\"-\",L10=\"\"),\"\",MAX(P$1:P9)+1)","v":""},{"$f":"IF(OR(M10=\"-\",M10=\"\"),\"\",MAX(Q$1:Q9)+1)","v":6},"P10EN1","Of detectives, wizards and robots - come and join the fantastic world of reading"]
[null,"Angaben zu Fremdsprachen",null,null,null,null,{"$f":"IF(OR(G10=MAX(Q8:Q107),G10=\"\"),\"\",MAX($G$4:G10)+1)","v":7},"P10EN3 - Speaking English! Making friends! Discussing our digital life!",null,null,"P8EN2","-","-","come and join the fantastic world of writing",{"$f":"IF(OR(K11=\"-\",K11=\"\"),\"\",MAX(O$1:O10)+1)","v":8},{"$f":"IF(OR(L11=\"-\",L11=\"\"),\"\",MAX(P$1:P10)+1)","v":""},{"$f":"IF(OR(M11=\"-\",M11=\"\"),\"\",MAX(Q$1:Q10)+1)","v":""},"-","come and join the fantastic world of writing"]
[null,null,"1. FS","Englisch",null,null,{"$f":"IF(OR(G11=MAX(Q9:Q108),G11=\"\"),\"\",MAX($G$4:G11)+1)","v":8},"P10EN4 - What's fair in fairtrade?",null,null,"-","P9EN3","P10EN3","Speaking English! Making friends! Discussing our digital life!",{"$f":"IF(OR(K12=\"-\",K12=\"\"),\"\",MAX(O$1:O11)+1)","v":""},{"$f":"IF(OR(L12=\"-\",L12=\"\"),\"\",MAX(P$1:P11)+1)","v":8},{"$f":"IF(OR(M12=\"-\",M12=\"\"),\"\",MAX(Q$1:Q11)+1)","v":7},"P10EN3","Speaking English! Making friends! Discussing our digital life!"]
[null,null,"2. FS (ab 7. Klasse)",null,null,null,{"$f":"IF(OR(G12=MAX(Q10:Q109),G12=\"\"),\"\",MAX($G$4:G12)+1)","v":9},"P10EN5 - How the world was discovered",null,null,"P8EN4","P9EN4","P10EN4","What's fair in fairtrade?",{"$f":"IF(OR(K13=\"-\",K13=\"\"),\"\",MAX(O$1:O12)+1)","v":9},{"$f":"IF(OR(L13=\"-\",L13=\"\"),\"\",MAX(P$1:P12)+1)","v":9},{"$f":"IF(OR(M13=\"-\",M13=\"\"),\"\",MAX(Q$1:Q12)+1)","v":8},"P10EN4","What's fair in fairtrade?"]
[null,null,"3. FS (ab 9. Klasse)",null,null,null,{"$f":"IF(OR(G13=MAX(Q11:Q110),G13=\"\"),\"\",MAX($G$4:G13)+1)","v":10},"P10EK3 - Wir verbessern die Welt (OSM)",null,null,"P8EN5","P9EN5","P10EN5","How the world was discovered",{"$f":"IF(OR(K14=\"-\",K14=\"\"),\"\",MAX(O$1:O13)+1)","v":10},{"$f":"IF(OR(L14=\"-\",L14=\"\"),\"\",MAX(P$1:P13)+1)","v":10},{"$f":"IF(OR(M14=\"-\",M14=\"\"),\"\",MAX(Q$1:Q13)+1)","v":9},"P10EN5","How the world was discovered"]
[null,"Angaben zu Wahlpflicht",null,null,null,null,{"$f":"IF(OR(G14=MAX(Q12:Q111),G14=\"\"),\"\",MAX($G$4:G14)+1)","v":11},"P10FS1 - Bundeswettbewerb für Fremdsprachen (Französisch, Spanisch)",null,null,"P8EK1","-","-","Auf Entdeckungsreise zu den weitgehend unerforschten Gebieten",{"$f":"IF(OR(K15=\"-\",K15=\"\"),\"\",MAX(O$1:O14)+1)","v":11},{"$f":"IF(OR(L15=\"-\",L15=\"\"),\"\",MAX(P$1:P14)+1)","v":""},{"$f":"IF(OR(M15=\"-\",M15=\"\"),\"\",MAX(Q$1:Q14)+1)","v":""},"-","Auf Entdeckungsreise zu den weitgehend unerforschten Gebieten"]
[null,null,"WP10 Fach 1",null,null,null,{"$f":"IF(OR(G15=MAX(Q13:Q112),G15=\"\"),\"\",MAX($G$4:G15)+1)","v":12},"P10FS2 - TED Talks (Science Slam)",null,null,"-","P9EK3","-","Save the planet",{"$f":"IF(OR(K16=\"-\",K16=\"\"),\"\",MAX(O$1:O15)+1)","v":""},{"$f":"IF(OR(L16=\"-\",L16=\"\"),\"\",MAX(P$1:P15)+1)","v":11},{"$f":"IF(OR(M16=\"-\",M16=\"\"),\"\",MAX(Q$1:Q15)+1)","v":""},"-","Save the planet"]
[null,null,"WP10 Fach 2",null,null,null,{"$f":"IF(OR(G16=MAX(Q14:Q113),G16=\"\"),\"\",MAX($G$4:G16)+1)","v":13},"P10FS3 - Textwerkstatt (Literarisches Lesen fremdsprachlicher Texte als kreativer Prozess)",null,null,"P8EK3","P9EK3","P10EK3","Wir verbessern die Welt (OSM)",{"$f":"IF(OR(K17=\"-\",K17=\"\"),\"\",MAX(O$1:O16)+1)","v":12},{"$f":"IF(OR(L17=\"-\",L17=\"\"),\"\",MAX(P$1:P16)+1)","v":12},{"$f":"IF(OR(M17=\"-\",M17=\"\"),\"\",MAX(Q$1:Q16)+1)","v":10},"P10EK3","Wir verbessern die Welt (OSM)"]
[null,"Angaben zu Profilierungskursen P10",null,null,null,null,{"$f":"IF(OR(G17=MAX(Q15:Q114),G17=\"\"),\"\",MAX($G$4:G17)+1)","v":14},"P10FS4 - debating - let's talk about it!",null,null,"P8FS1","P9FS1","P10FS1","Bundeswettbewerb für Fremdsprachen (Französisch, Spanisch)",{"$f":"IF(OR(K18=\"-\",K18=\"\"),\"\",MAX(O$1:O17)+1)","v":13},{"$f":"IF(OR(L18=\"-\",L18=\"\"),\"\",MAX(P$1:P17)+1)","v":13},{"$f":"IF(OR(M18=\"-\",M18=\"\"),\"\",MAX(Q$1:Q17)+1)","v":11},"P10FS1","Bundeswettbewerb für Fremdsprachen (Französisch, Spanisch)"]
[null,null,"Kurs im 1. Halbjahr Kl. 10","ab 2021",null,null,{"$f":"IF(OR(G18=MAX(Q16:Q115),G18=\"\"),\"\",MAX($G$4:G18)+1)","v":15},"P10GE2 - Meisterwerke der Filmgeschichte",null,null,"-","P9FS2","P10FS2","TED Talks (Science Slam)",{"$f":"IF(OR(K19=\"-\",K19=\"\"),\"\",MAX(O$1:O18)+1)","v":""},{"$f":"IF(OR(L19=\"-\",L19=\"\"),\"\",MAX(P$1:P18)+1)","v":14},{"$f":"IF(OR(M19=\"-\",M19=\"\"),\"\",MAX(Q$1:Q18)+1)","v":12},"P10FS2","TED Talks (Science Slam)"]
[null,null,"Kurs im 2. Halbjahr Kl. 10",null,null,null,{"$f":"IF(OR(G19=MAX(Q17:Q116),G19=\"\"),\"\",MAX($G$4:G19)+1)","v":16},"P10GE3 - Regionalgeschichte Berlins",null,null,"-","P9FS3","P10FS3","Textwerkstatt (Literarisches Lesen fremdsprachlicher Texte als kreativer Prozess)",{"$f":"IF(OR(K20=\"-\",K20=\"\"),\"\",MAX(O$1:O19)+1)","v":""},{"$f":"IF(OR(L20=\"-\",L20=\"\"),\"\",MAX(P$1:P19)+1)","v":15},{"$f":"IF(OR(M20=\"-\",M20=\"\"),\"\",MAX(Q$1:Q19)+1)","v":13},"P10FS3","Textwerkstatt (Literarisches Lesen fremdsprachlicher Texte als kreativer Prozess)"]
[null,null,null,null,null,null,{"$f":"IF(OR(G20=MAX(Q18:Q117),G20=\"\"),\"\",MAX($G$4:G20)+1)","v":17},"P10GE4 - Jüdisches Leben in Berlin im Spannungsfeld d. Antisemitismus",null,null,"P8FS4","P9FS4","P10FS4","debating - let's talk about it!",{"$f":"IF(OR(K21=\"-\",K21=\"\"),\"\",MAX(O$1:O20)+1)","v":14},{"$f":"IF(OR(L21=\"-\",L21=\"\"),\"\",MAX(P$1:P20)+1)","v":16},{"$f":"IF(OR(M21=\"-\",M21=\"\"),\"\",MAX(Q$1:Q20)+1)","v":14},"P10FS4","debating - let's talk about it!"]
[null,null,null,null,null,null,{"$f":"IF(OR(G21=MAX(Q19:Q118),G21=\"\"),\"\",MAX($G$4:G21)+1)","v":18},"P10GE5 - Vielfalt leben…",null,null,"P8GE1","-","-","Kennst du deinen Bezirk? Wir erforschen Pankow",{"$f":"IF(OR(K22=\"-\",K22=\"\"),\"\",MAX(O$1:O21)+1)","v":15},{"$f":"IF(OR(L22=\"-\",L22=\"\"),\"\",MAX(P$1:P21)+1)","v":""},{"$f":"IF(OR(M22=\"-\",M22=\"\"),\"\",MAX(Q$1:Q21)+1)","v":""},"-","Kennst du deinen Bezirk? Wir erforschen Pankow"]
[null,null,null,null,null,null,{"$f":"IF(OR(G22=MAX(Q20:Q119),G22=\"\"),\"\",MAX($G$4:G22)+1)","v":19},"P10GE6 - Weltanschauung und Propagande der NSDAP",null,null,"-","-","P10GE2","Meisterwerke der Filmgeschichte",{"$f":"IF(OR(K23=\"-\",K23=\"\"),\"\",MAX(O$1:O22)+1)","v":""},{"$f":"IF(OR(L23=\"-\",L23=\"\"),\"\",MAX(P$1:P22)+1)","v":""},{"$f":"IF(OR(M23=\"-\",M23=\"\"),\"\",MAX(Q$1:Q22)+1)","v":15},"P10GE2","Meisterwerke der Filmgeschichte"]
[null,null,null,null,null,null,{"$f":"IF(OR(G23=MAX(Q21:Q120),G23=\"\"),\"\",MAX($G$4:G23)+1)","v":20},"P10GE7 - Jüdisches Leben in Berlin & Brandenburg",null,null,"-","P9GE3","P10GE3","Regionalgeschichte Berlins",{"$f":"IF(OR(K24=\"-\",K24=\"\"),\"\",MAX(O$1:O23)+1)","v":""},{"$f":"IF(OR(L24=\"-\",L24=\"\"),\"\",MAX(P$1:P23)+1)","v":17},{"$f":"IF(OR(M24=\"-\",M24=\"\"),\"\",MAX(Q$1:Q23)+1)","v":16},"P10GE3","Regionalgeschichte Berlins"]
[null,null,null,null,null,null,{"$f":"IF(OR(G24=MAX(Q22:Q121),G24=\"\"),\"\",MAX($G$4:G24)+1)","v":21},"P10PW1 - Politik - Alle wollen mitreden",null,null,"-","-","P10GE4","Jüdisches Leben in Berlin im Spannungsfeld d. Antisemitismus",{"$f":"IF(OR(K25=\"-\",K25=\"\"),\"\",MAX(O$1:O24)+1)","v":""},{"$f":"IF(OR(L25=\"-\",L25=\"\"),\"\",MAX(P$1:P24)+1)","v":""},{"$f":"IF(OR(M25=\"-\",M25=\"\"),\"\",MAX(Q$1:Q24)+1)","v":17},"P10GE4","Jüdisches Leben in Berlin im Spannungsfeld d. Antisemitismus"]
[null,null,null,null,null,null,{"$f":"IF(OR(G25=MAX(Q23:Q122),G25=\"\"),\"\",MAX($G$4:G25)+1)","v":22},"P10PW2 - Start Up - Wie gründe ich ein Unternehmen",null,null,"-","P9GE5","P10GE5","Vielfalt leben…",{"$f":"IF(OR(K26=\"-\",K26=\"\"),\"\",MAX(O$1:O25)+1)","v":""},{"$f":"IF(OR(L26=\"-\",L26=\"\"),\"\",MAX(P$1:P25)+1)","v":18},{"$f":"IF(OR(M26=\"-\",M26=\"\"),\"\",MAX(Q$1:Q25)+1)","v":18},"P10GE5","Vielfalt leben…"]
[null,null,null,null,null,null,{"$f":"IF(OR(G26=MAX(Q24:Q123),G26=\"\"),\"\",MAX($G$4:G26)+1)","v":23},"P10PW3 - Soziales Wirtschaften: Ist das überhaupt möglich?",null,null,"-","P9GE6","P10GE6","Weltanschauung und Propagande der NSDAP",{"$f":"IF(OR(K27=\"-\",K27=\"\"),\"\",MAX(O$1:O26)+1)","v":""},{"$f":"IF(OR(L27=\"-\",L27=\"\"),\"\",MAX(P$1:P26)+1)","v":19},{"$f":"IF(OR(M27=\"-\",M27=\"\"),\"\",MAX(Q$1:Q26)+1)","v":19},"P10GE6","Weltanschauung und Propagande der NSDAP"]
[null,null,null,null,null,null,{"$f":"IF(OR(G27=MAX(Q25:Q124),G27=\"\"),\"\",MAX($G$4:G27)+1)","v":24},"P10PW4 - Wie bewerten Unternehmer den Standort Pankow? ",null,null,"-","-","P10GE7","Jüdisches Leben in Berlin & Brandenburg",{"$f":"IF(OR(K28=\"-\",K28=\"\"),\"\",MAX(O$1:O27)+1)","v":""},{"$f":"IF(OR(L28=\"-\",L28=\"\"),\"\",MAX(P$1:P27)+1)","v":""},{"$f":"IF(OR(M28=\"-\",M28=\"\"),\"\",MAX(Q$1:Q27)+1)","v":20},"P10GE7","Jüdisches Leben in Berlin & Brandenburg"]
[null,null,null,null,null,null,{"$f":"IF(OR(G28=MAX(Q26:Q125),G28=\"\"),\"\",MAX($G$4:G28)+1)","v":25},"P10IN1 - Programmieren lernen mit Minecraft",null,null,"P8PW1","P9PW1","P10PW1","Politik - Alle wollen mitreden",{"$f":"IF(OR(K29=\"-\",K29=\"\"),\"\",MAX(O$1:O28)+1)","v":16},{"$f":"IF(OR(L29=\"-\",L29=\"\"),\"\",MAX(P$1:P28)+1)","v":20},{"$f":"IF(OR(M29=\"-\",M29=\"\"),\"\",MAX(Q$1:Q28)+1)","v":21},"P10PW1","Politik - Alle wollen mitreden"]
[null,null,null,null,null,null,{"$f":"IF(OR(G29=MAX(Q27:Q126),G29=\"\"),\"\",MAX($G$4:G29)+1)","v":26},"P10IN2 - 3D Druck - von der Idee zum Prototyp",null,null,"-","P9PW2","P10PW2","Start Up - Wie gründe ich ein Unternehmen",{"$f":"IF(OR(K30=\"-\",K30=\"\"),\"\",MAX(O$1:O29)+1)","v":""},{"$f":"IF(OR(L30=\"-\",L30=\"\"),\"\",MAX(P$1:P29)+1)","v":21},{"$f":"IF(OR(M30=\"-\",M30=\"\"),\"\",MAX(Q$1:Q29)+1)","v":22},"P10PW2","Start Up - Wie gründe ich ein Unternehmen"]
[null,null,null,null,null,null,{"$f":"IF(OR(G30=MAX(Q28:Q127),G30=\"\"),\"\",MAX($G$4:G30)+1)","v":27},"P10IN3 - Von NIMROD bis Call of Duty: Die Geschichte der Videospiele",null,null,"-","P9PW3","P10PW3","Soziales Wirtschaften: Ist das überhaupt möglich?",{"$f":"IF(OR(K31=\"-\",K31=\"\"),\"\",MAX(O$1:O30)+1)","v":""},{"$f":"IF(OR(L31=\"-\",L31=\"\"),\"\",MAX(P$1:P30)+1)","v":22},{"$f":"IF(OR(M31=\"-\",M31=\"\"),\"\",MAX(Q$1:Q30)+1)","v":23},"P10PW3","Soziales Wirtschaften: Ist das überhaupt möglich?"]
[null,null,null,null,null,null,{"$f":"IF(OR(G31=MAX(Q29:Q128),G31=\"\"),\"\",MAX($G$4:G31)+1)","v":28},"P10IN4 - Smart Home",null,null,"-","P9PW4","P10PW4","Wie bewerten Unternehmer den Standort Pankow? ",{"$f":"IF(OR(K32=\"-\",K32=\"\"),\"\",MAX(O$1:O31)+1)","v":""},{"$f":"IF(OR(L32=\"-\",L32=\"\"),\"\",MAX(P$1:P31)+1)","v":23},{"$f":"IF(OR(M32=\"-\",M32=\"\"),\"\",MAX(Q$1:Q31)+1)","v":24},"P10PW4","Wie bewerten Unternehmer den Standort Pankow? "]
[null,null,null,null,null,null,{"$f":"IF(OR(G32=MAX(Q30:Q129),G32=\"\"),\"\",MAX($G$4:G32)+1)","v":29},"P10KU1 - Typographie/ Schriftgestaltung",null,null,"P8IN1","P9IN1","P10IN1","Programmieren lernen mit Minecraft",{"$f":"IF(OR(K33=\"-\",K33=\"\"),\"\",MAX(O$1:O32)+1)","v":17},{"$f":"IF(OR(L33=\"-\",L33=\"\"),\"\",MAX(P$1:P32)+1)","v":24},{"$f":"IF(OR(M33=\"-\",M33=\"\"),\"\",MAX(Q$1:Q32)+1)","v":25},"P10IN1","Programmieren lernen mit Minecraft"]
[null,null,null,null,null,null,{"$f":"IF(OR(G33=MAX(Q31:Q130),G33=\"\"),\"\",MAX($G$4:G33)+1)","v":30},"P10KU3 - \"TAPE THAT\" - Delbrücks KlebeBande ",null,null,"-","P9IN2","P10IN2","3D Druck - von der Idee zum Prototyp",{"$f":"IF(OR(K34=\"-\",K34=\"\"),\"\",MAX(O$1:O33)+1)","v":""},{"$f":"IF(OR(L34=\"-\",L34=\"\"),\"\",MAX(P$1:P33)+1)","v":25},{"$f":"IF(OR(M34=\"-\",M34=\"\"),\"\",MAX(Q$1:Q33)+1)","v":26},"P10IN2","3D Druck - von der Idee zum Prototyp"]
[null,null,null,null,null,null,{"$f":"IF(OR(G34=MAX(Q32:Q131),G34=\"\"),\"\",MAX($G$4:G34)+1)","v":31},"P10KU4 - KSK&B",null,null,"P8IN3","P9IN3","P10IN3","Von NIMROD bis Call of Duty: Die Geschichte der Videospiele",{"$f":"IF(OR(K35=\"-\",K35=\"\"),\"\",MAX(O$1:O34)+1)","v":18},{"$f":"IF(OR(L35=\"-\",L35=\"\"),\"\",MAX(P$1:P34)+1)","v":26},{"$f":"IF(OR(M35=\"-\",M35=\"\"),\"\",MAX(Q$1:Q34)+1)","v":27},"P10IN3","Von NIMROD bis Call of Duty: Die Geschichte der Videospiele"]
[null,null,null,null,null,null,{"$f":"IF(OR(G35=MAX(Q33:Q132),G35=\"\"),\"\",MAX($G$4:G35)+1)","v":32},"P10KU6 - Präsentieren",null,null,"P8IN4","P9IN4","P10IN4","Smart Home",{"$f":"IF(OR(K36=\"-\",K36=\"\"),\"\",MAX(O$1:O35)+1)","v":19},{"$f":"IF(OR(L36=\"-\",L36=\"\"),\"\",MAX(P$1:P35)+1)","v":27},{"$f":"IF(OR(M36=\"-\",M36=\"\"),\"\",MAX(Q$1:Q35)+1)","v":28},"P10IN4","Smart Home"]
[null,null,null,null,null,null,{"$f":"IF(OR(G36=MAX(Q34:Q133),G36=\"\"),\"\",MAX($G$4:G36)+1)","v":33},"P10KU7 - Museumsprofile",null,null,"P8IN5","P9IN5","-","AppCamps - AndroidApps programmieren",{"$f":"IF(OR(K37=\"-\",K37=\"\"),\"\",MAX(O$1:O36)+1)","v":20},{"$f":"IF(OR(L37=\"-\",L37=\"\"),\"\",MAX(P$1:P36)+1)","v":28},{"$f":"IF(OR(M37=\"-\",M37=\"\"),\"\",MAX(Q$1:Q36)+1)","v":""},"-","AppCamps - AndroidApps programmieren"]
[null,null,null,null,null,null,{"$f":"IF(OR(G37=MAX(Q35:Q134),G37=\"\"),\"\",MAX($G$4:G37)+1)","v":34},"P10LA1-4 - Kurs aufs Latinum",null,null,"-","P9IN6","-","Digitale Welten - Von Arduino bis Raspberry Pi",{"$f":"IF(OR(K38=\"-\",K38=\"\"),\"\",MAX(O$1:O37)+1)","v":""},{"$f":"IF(OR(L38=\"-\",L38=\"\"),\"\",MAX(P$1:P37)+1)","v":29},{"$f":"IF(OR(M38=\"-\",M38=\"\"),\"\",MAX(Q$1:Q37)+1)","v":""},"-","Digitale Welten - Von Arduino bis Raspberry Pi"]
[null,null,null,null,null,null,{"$f":"IF(OR(G38=MAX(Q36:Q135),G38=\"\"),\"\",MAX($G$4:G38)+1)","v":35},"P10LA5 - Leben in Rom - ohne Smartphone und Strom",null,null,"P8IN7","-","-","VEX Robotic – Roboterwettbewerb",{"$f":"IF(OR(K39=\"-\",K39=\"\"),\"\",MAX(O$1:O38)+1)","v":21},{"$f":"IF(OR(L39=\"-\",L39=\"\"),\"\",MAX(P$1:P38)+1)","v":""},{"$f":"IF(OR(M39=\"-\",M39=\"\"),\"\",MAX(Q$1:Q38)+1)","v":""},"-","VEX Robotic – Roboterwettbewerb"]
[null,null,null,null,null,null,{"$f":"IF(OR(G39=MAX(Q37:Q136),G39=\"\"),\"\",MAX($G$4:G39)+1)","v":36},"P10LA7 - Rhetorik im alten Rom",null,null,"P8KU1","P9KU1","P10KU1","Typographie/ Schriftgestaltung",{"$f":"IF(OR(K40=\"-\",K40=\"\"),\"\",MAX(O$1:O39)+1)","v":22},{"$f":"IF(OR(L40=\"-\",L40=\"\"),\"\",MAX(P$1:P39)+1)","v":30},{"$f":"IF(OR(M40=\"-\",M40=\"\"),\"\",MAX(Q$1:Q39)+1)","v":29},"P10KU1","Typographie/ Schriftgestaltung"]
[null,null,null,null,null,null,{"$f":"IF(OR(G40=MAX(Q38:Q137),G40=\"\"),\"\",MAX($G$4:G40)+1)","v":37},"P10MA2 - Kryptologie - Verschlüsselte Botschaften",null,null,"P8KU2","-","-","All you can eat? - Essen in der Kunst",{"$f":"IF(OR(K41=\"-\",K41=\"\"),\"\",MAX(O$1:O40)+1)","v":23},{"$f":"IF(OR(L41=\"-\",L41=\"\"),\"\",MAX(P$1:P40)+1)","v":""},{"$f":"IF(OR(M41=\"-\",M41=\"\"),\"\",MAX(Q$1:Q40)+1)","v":""},"-","All you can eat? - Essen in der Kunst"]
[null,null,null,null,null,null,{"$f":"IF(OR(G41=MAX(Q39:Q138),G41=\"\"),\"\",MAX($G$4:G41)+1)","v":38},"P10MA3 - Tabellenkalkulation im Berufsalltag",null,null,"-","P9KU3","P10KU3","\"TAPE THAT\" - Delbrücks KlebeBande ",{"$f":"IF(OR(K42=\"-\",K42=\"\"),\"\",MAX(O$1:O41)+1)","v":""},{"$f":"IF(OR(L42=\"-\",L42=\"\"),\"\",MAX(P$1:P41)+1)","v":31},{"$f":"IF(OR(M42=\"-\",M42=\"\"),\"\",MAX(Q$1:Q41)+1)","v":30},"P10KU3","\"TAPE THAT\" - Delbrücks KlebeBande "]
[null,null,null,null,null,null,{"$f":"IF(OR(G42=MAX(Q40:Q139),G42=\"\"),\"\",MAX($G$4:G42)+1)","v":39},"P10MA4 - Mathematik im Alltag",null,null,"-","-","P10KU4","KSK&B",{"$f":"IF(OR(K43=\"-\",K43=\"\"),\"\",MAX(O$1:O42)+1)","v":""},{"$f":"IF(OR(L43=\"-\",L43=\"\"),\"\",MAX(P$1:P42)+1)","v":""},{"$f":"IF(OR(M43=\"-\",M43=\"\"),\"\",MAX(Q$1:Q42)+1)","v":31},"P10KU4","KSK&B"]
[null,null,null,null,null,null,{"$f":"IF(OR(G43=MAX(Q41:Q140),G43=\"\"),\"\",MAX($G$4:G43)+1)","v":40},"P10MU1 - Songwriting",null,null,"P8KU5","P9KU5","-","Illustration - Worte werden Bilder",{"$f":"IF(OR(K44=\"-\",K44=\"\"),\"\",MAX(O$1:O43)+1)","v":24},{"$f":"IF(OR(L44=\"-\",L44=\"\"),\"\",MAX(P$1:P43)+1)","v":32},{"$f":"IF(OR(M44=\"-\",M44=\"\"),\"\",MAX(Q$1:Q43)+1)","v":""},"-","Illustration - Worte werden Bilder"]
[null,null,null,null,null,null,{"$f":"IF(OR(G44=MAX(Q42:Q141),G44=\"\"),\"\",MAX($G$4:G44)+1)","v":41},"P10MU2 - Musiktheater",null,null,"-","P9KU6","P10KU6","Präsentieren",{"$f":"IF(OR(K45=\"-\",K45=\"\"),\"\",MAX(O$1:O44)+1)","v":""},{"$f":"IF(OR(L45=\"-\",L45=\"\"),\"\",MAX(P$1:P44)+1)","v":33},{"$f":"IF(OR(M45=\"-\",M45=\"\"),\"\",MAX(Q$1:Q44)+1)","v":32},"P10KU6","Präsentieren"]
[null,null,null,null,null,null,{"$f":"IF(OR(G45=MAX(Q43:Q142),G45=\"\"),\"\",MAX($G$4:G45)+1)","v":42},"P10MU4 - Von der elektronischen Klangerzeugung zur elektronischen Tanzmusik",null,null,"-","-","P10KU7","Museumsprofile",{"$f":"IF(OR(K46=\"-\",K46=\"\"),\"\",MAX(O$1:O45)+1)","v":""},{"$f":"IF(OR(L46=\"-\",L46=\"\"),\"\",MAX(P$1:P45)+1)","v":""},{"$f":"IF(OR(M46=\"-\",M46=\"\"),\"\",MAX(Q$1:Q45)+1)","v":33},"P10KU7","Museumsprofile"]
[null,null,null,null,null,null,{"$f":"IF(OR(G46=MAX(Q44:Q143),G46=\"\"),\"\",MAX($G$4:G46)+1)","v":43},"P10MU5 - Ensemblemusik",null,null,"P8LA1-4","P9LA1-4","P10LA1-4","Kurs aufs Latinum",{"$f":"IF(OR(K47=\"-\",K47=\"\"),\"\",MAX(O$1:O46)+1)","v":25},{"$f":"IF(OR(L47=\"-\",L47=\"\"),\"\",MAX(P$1:P46)+1)","v":34},{"$f":"IF(OR(M47=\"-\",M47=\"\"),\"\",MAX(Q$1:Q46)+1)","v":34},"P10LA1-4","Kurs aufs Latinum"]
[null,null,null,null,null,null,{"$f":"IF(OR(G47=MAX(Q45:Q144),G47=\"\"),\"\",MAX($G$4:G47)+1)","v":44},"P10MU6 - Singen macht Spaß",null,null,"P8LA5","P9LA5","P10LA5","Leben in Rom - ohne Smartphone und Strom",{"$f":"IF(OR(K48=\"-\",K48=\"\"),\"\",MAX(O$1:O47)+1)","v":26},{"$f":"IF(OR(L48=\"-\",L48=\"\"),\"\",MAX(P$1:P47)+1)","v":35},{"$f":"IF(OR(M48=\"-\",M48=\"\"),\"\",MAX(Q$1:Q47)+1)","v":35},"P10LA5","Leben in Rom - ohne Smartphone und Strom"]
[null,null,null,null,null,null,{"$f":"IF(OR(G48=MAX(Q46:Q145),G48=\"\"),\"\",MAX($G$4:G48)+1)","v":45},"P10MU8 - Musikhören, Lesen & Verstehen",null,null,"P8LA6","P9LA6","-","Rezeption mythologischer Stoffe",{"$f":"IF(OR(K49=\"-\",K49=\"\"),\"\",MAX(O$1:O48)+1)","v":27},{"$f":"IF(OR(L49=\"-\",L49=\"\"),\"\",MAX(P$1:P48)+1)","v":36},{"$f":"IF(OR(M49=\"-\",M49=\"\"),\"\",MAX(Q$1:Q48)+1)","v":""},"-","Rezeption mythologischer Stoffe"]
[null,null,null,null,null,null,{"$f":"IF(OR(G49=MAX(Q47:Q146),G49=\"\"),\"\",MAX($G$4:G49)+1)","v":46},"P10PH1 - Der Traum vom Fliegen",null,null,"-","-","P10LA7","Rhetorik im alten Rom",{"$f":"IF(OR(K50=\"-\",K50=\"\"),\"\",MAX(O$1:O49)+1)","v":""},{"$f":"IF(OR(L50=\"-\",L50=\"\"),\"\",MAX(P$1:P49)+1)","v":""},{"$f":"IF(OR(M50=\"-\",M50=\"\"),\"\",MAX(Q$1:Q49)+1)","v":36},"P10LA7","Rhetorik im alten Rom"]
[null,null,null,null,null,null,{"$f":"IF(OR(G50=MAX(Q48:Q147),G50=\"\"),\"\",MAX($G$4:G50)+1)","v":47},"P10PH2 - Astronomie",null,null,"P8MA1","-","-","Schach - mehr als ein Spiel",{"$f":"IF(OR(K51=\"-\",K51=\"\"),\"\",MAX(O$1:O50)+1)","v":28},{"$f":"IF(OR(L51=\"-\",L51=\"\"),\"\",MAX(P$1:P50)+1)","v":""},{"$f":"IF(OR(M51=\"-\",M51=\"\"),\"\",MAX(Q$1:Q50)+1)","v":""},"-","Schach - mehr als ein Spiel"]
[null,null,null,null,null,null,{"$f":"IF(OR(G51=MAX(Q49:Q148),G51=\"\"),\"\",MAX($G$4:G51)+1)","v":48},"P10PH4 - Physik in Film und Serie",null,null,"P8MA2","P9MA2","P10MA2","Kryptologie - Verschlüsselte Botschaften",{"$f":"IF(OR(K52=\"-\",K52=\"\"),\"\",MAX(O$1:O51)+1)","v":29},{"$f":"IF(OR(L52=\"-\",L52=\"\"),\"\",MAX(P$1:P51)+1)","v":37},{"$f":"IF(OR(M52=\"-\",M52=\"\"),\"\",MAX(Q$1:Q51)+1)","v":37},"P10MA2","Kryptologie - Verschlüsselte Botschaften"]
[null,null,null,null,null,null,{"$f":"IF(OR(G52=MAX(Q50:Q149),G52=\"\"),\"\",MAX($G$4:G52)+1)","v":49},"P10SP2 - Sportliche Bewegungen entwickeln und selbst umsetzen",null,null,"P8MA3","P9MA3","P10MA3","Tabellenkalkulation im Berufsalltag",{"$f":"IF(OR(K53=\"-\",K53=\"\"),\"\",MAX(O$1:O52)+1)","v":30},{"$f":"IF(OR(L53=\"-\",L53=\"\"),\"\",MAX(P$1:P52)+1)","v":38},{"$f":"IF(OR(M53=\"-\",M53=\"\"),\"\",MAX(Q$1:Q52)+1)","v":38},"P10MA3","Tabellenkalkulation im Berufsalltag"]
[null,null,null,null,null,null,{"$f":"IF(OR(G53=MAX(Q51:Q150),G53=\"\"),\"\",MAX($G$4:G53)+1)","v":50},"P10SP3 - Organisation von sportlichen Veranstaltungen/ Turnieren",null,null,"-","-","P10MA4","Mathematik im Alltag",{"$f":"IF(OR(K54=\"-\",K54=\"\"),\"\",MAX(O$1:O53)+1)","v":""},{"$f":"IF(OR(L54=\"-\",L54=\"\"),\"\",MAX(P$1:P53)+1)","v":""},{"$f":"IF(OR(M54=\"-\",M54=\"\"),\"\",MAX(Q$1:Q53)+1)","v":39},"P10MA4","Mathematik im Alltag"]
[null,null,null,null,null,null,{"$f":"IF(OR(G54=MAX(Q52:Q151),G54=\"\"),\"\",MAX($G$4:G54)+1)","v":51},"P10SP4 - Planung und Durchführung einer sportlich-entspannten Pausengestaltung",null,null,"P8MU1","P9MU1","P10MU1","Songwriting",{"$f":"IF(OR(K55=\"-\",K55=\"\"),\"\",MAX(O$1:O54)+1)","v":31},{"$f":"IF(OR(L55=\"-\",L55=\"\"),\"\",MAX(P$1:P54)+1)","v":39},{"$f":"IF(OR(M55=\"-\",M55=\"\"),\"\",MAX(Q$1:Q54)+1)","v":40},"P10MU1","Songwriting"]
[null,null,null,null,null,null,{"$f":"IF(OR(G55=MAX(Q53:Q152),G55=\"\"),\"\",MAX($G$4:G55)+1)","v":""},"",null,null,"P8MU2","P9MU2","P10MU2","Musiktheater",{"$f":"IF(OR(K56=\"-\",K56=\"\"),\"\",MAX(O$1:O55)+1)","v":32},{"$f":"IF(OR(L56=\"-\",L56=\"\"),\"\",MAX(P$1:P55)+1)","v":40},{"$f":"IF(OR(M56=\"-\",M56=\"\"),\"\",MAX(Q$1:Q55)+1)","v":41},"P10MU2","Musiktheater"]
[null,null,null,null,null,null,{"$f":"IF(OR(G56=MAX(Q54:Q153),G56=\"\"),\"\",MAX($G$4:G56)+1)","v":""},"",null,null,"P8MU3","-","-","Instrumente spielen lernen",{"$f":"IF(OR(K57=\"-\",K57=\"\"),\"\",MAX(O$1:O56)+1)","v":33},{"$f":"IF(OR(L57=\"-\",L57=\"\"),\"\",MAX(P$1:P56)+1)","v":""},{"$f":"IF(OR(M57=\"-\",M57=\"\"),\"\",MAX(Q$1:Q56)+1)","v":""},"-","Instrumente spielen lernen"]
[null,null,null,null,null,null,{"$f":"IF(OR(G57=MAX(Q55:Q154),G57=\"\"),\"\",MAX($G$4:G57)+1)","v":""},"",null,null,"-","P9MU4","P10MU4","Von der elektronischen Klangerzeugung zur elektronischen Tanzmusik",{"$f":"IF(OR(K58=\"-\",K58=\"\"),\"\",MAX(O$1:O57)+1)","v":""},{"$f":"IF(OR(L58=\"-\",L58=\"\"),\"\",MAX(P$1:P57)+1)","v":41},{"$f":"IF(OR(M58=\"-\",M58=\"\"),\"\",MAX(Q$1:Q57)+1)","v":42},"P10MU4","Von der elektronischen Klangerzeugung zur elektronischen Tanzmusik"]
[null,null,null,null,null,null,{"$f":"IF(OR(G58=MAX(Q56:Q155),G58=\"\"),\"\",MAX($G$4:G58)+1)","v":""},"",null,null,"P8MU5","P9MU5","P10MU5","Ensemblemusik",{"$f":"IF(OR(K59=\"-\",K59=\"\"),\"\",MAX(O$1:O58)+1)","v":34},{"$f":"IF(OR(L59=\"-\",L59=\"\"),\"\",MAX(P$1:P58)+1)","v":42},{"$f":"IF(OR(M59=\"-\",M59=\"\"),\"\",MAX(Q$1:Q58)+1)","v":43},"P10MU5","Ensemblemusik"]
[null,null,null,null,null,null,{"$f":"IF(OR(G59=MAX(Q57:Q156),G59=\"\"),\"\",MAX($G$4:G59)+1)","v":""},"",null,null,"P8MU6","P9MU6","P10MU6","Singen macht Spaß",{"$f":"IF(OR(K60=\"-\",K60=\"\"),\"\",MAX(O$1:O59)+1)","v":35},{"$f":"IF(OR(L60=\"-\",L60=\"\"),\"\",MAX(P$1:P59)+1)","v":43},{"$f":"IF(OR(M60=\"-\",M60=\"\"),\"\",MAX(Q$1:Q59)+1)","v":44},"P10MU6","Singen macht Spaß"]
[null,null,null,null,null,null,{"$f":"IF(OR(G60=MAX(Q58:Q157),G60=\"\"),\"\",MAX($G$4:G60)+1)","v":""},"",null,null,"P8MU7","P9MU7","-","Instrumentenbau",{"$f":"IF(OR(K61=\"-\",K61=\"\"),\"\",MAX(O$1:O60)+1)","v":36},{"$f":"IF(OR(L61=\"-\",L61=\"\"),\"\",MAX(P$1:P60)+1)","v":44},{"$f":"IF(OR(M61=\"-\",M61=\"\"),\"\",MAX(Q$1:Q60)+1)","v":""},"-","Instrumentenbau"]
[null,null,null,null,null,null,{"$f":"IF(OR(G61=MAX(Q59:Q158),G61=\"\"),\"\",MAX($G$4:G61)+1)","v":""},"",null,null,"P8MU8","P9MU8","P10MU8","Musikhören, Lesen & Verstehen",{"$f":"IF(OR(K62=\"-\",K62=\"\"),\"\",MAX(O$1:O61)+1)","v":37},{"$f":"IF(OR(L62=\"-\",L62=\"\"),\"\",MAX(P$1:P61)+1)","v":45},{"$f":"IF(OR(M62=\"-\",M62=\"\"),\"\",MAX(Q$1:Q61)+1)","v":45},"P10MU8","Musikhören, Lesen & Verstehen"]
[null,null,null,null,null,null,{"$f":"IF(OR(G62=MAX(Q60:Q159),G62=\"\"),\"\",MAX($G$4:G62)+1)","v":""},"",null,null,"P8PH1","P9PH1","P10PH1","Der Traum vom Fliegen",{"$f":"IF(OR(K63=\"-\",K63=\"\"),\"\",MAX(O$1:O62)+1)","v":38},{"$f":"IF(OR(L63=\"-\",L63=\"\"),\"\",MAX(P$1:P62)+1)","v":46},{"$f":"IF(OR(M63=\"-\",M63=\"\"),\"\",MAX(Q$1:Q62)+1)","v":46},"P10PH1","Der Traum vom Fliegen"]
[null,null,null,null,null,null,{"$f":"IF(OR(G63=MAX(Q61:Q160),G63=\"\"),\"\",MAX($G$4:G63)+1)","v":""},"",null,null,"P8PH2","P9PH2","P10PH2","Astronomie",{"$f":"IF(OR(K64=\"-\",K64=\"\"),\"\",MAX(O$1:O63)+1)","v":39},{"$f":"IF(OR(L64=\"-\",L64=\"\"),\"\",MAX(P$1:P63)+1)","v":47},{"$f":"IF(OR(M64=\"-\",M64=\"\"),\"\",MAX(Q$1:Q63)+1)","v":47},"P10PH2","Astronomie"]
[null,null,null,null,null,null,{"$f":"IF(OR(G64=MAX(Q62:Q161),G64=\"\"),\"\",MAX($G$4:G64)+1)","v":""},"",null,null,"P8PH3","-","-","Hat Wasser ein Gedächtnis?",{"$f":"IF(OR(K65=\"-\",K65=\"\"),\"\",MAX(O$1:O64)+1)","v":40},{"$f":"IF(OR(L65=\"-\",L65=\"\"),\"\",MAX(P$1:P64)+1)","v":""},{"$f":"IF(OR(M65=\"-\",M65=\"\"),\"\",MAX(Q$1:Q64)+1)","v":""},"-","Hat Wasser ein Gedächtnis?"]
[null,null,null,null,null,null,{"$f":"IF(OR(G65=MAX(Q63:Q162),G65=\"\"),\"\",MAX($G$4:G65)+1)","v":""},"",null,null,"-","-","P10PH4","Physik in Film und Serie",{"$f":"IF(OR(K66=\"-\",K66=\"\"),\"\",MAX(O$1:O65)+1)","v":""},{"$f":"IF(OR(L66=\"-\",L66=\"\"),\"\",MAX(P$1:P65)+1)","v":""},{"$f":"IF(OR(M66=\"-\",M66=\"\"),\"\",MAX(Q$1:Q65)+1)","v":48},"P10PH4","Physik in Film und Serie"]
[null,null,null,null,null,null,{"$f":"IF(OR(G66=MAX(Q64:Q163),G66=\"\"),\"\",MAX($G$4:G66)+1)","v":""},"",null,null,"P8SP1","P9SP1","-","Was passiert mit meinem Körper beim Sport und wie halte ich ihn gesund?",{"$f":"IF(OR(K67=\"-\",K67=\"\"),\"\",MAX(O$1:O66)+1)","v":41},{"$f":"IF(OR(L67=\"-\",L67=\"\"),\"\",MAX(P$1:P66)+1)","v":48},{"$f":"IF(OR(M67=\"-\",M67=\"\"),\"\",MAX(Q$1:Q66)+1)","v":""},{"$f":"M67","v":"-"},{"$f":"N67","v":"Was passiert mit meinem Körper beim Sport und wie halte ich ihn gesund?"}]
[null,null,null,null,null,null,{"$f":"IF(OR(G67=MAX(Q65:Q164),G67=\"\"),\"\",MAX($G$4:G67)+1)","v":""},"",null,null,"P8SP2","P9SP2","P10SP2","Sportliche Bewegungen entwickeln und selbst umsetzen",{"$f":"IF(OR(K68=\"-\",K68=\"\"),\"\",MAX(O$1:O67)+1)","v":42},{"$f":"IF(OR(L68=\"-\",L68=\"\"),\"\",MAX(P$1:P67)+1)","v":49},{"$f":"IF(OR(M68=\"-\",M68=\"\"),\"\",MAX(Q$1:Q67)+1)","v":49},"P10SP2","Sportliche Bewegungen entwickeln und selbst umsetzen"]
[null,null,null,null,null,null,{"$f":"IF(OR(G68=MAX(Q66:Q165),G68=\"\"),\"\",MAX($G$4:G68)+1)","v":""},"",null,null,"-","P9SP3","P10SP3","Organisation von sportlichen Veranstaltungen/ Turnieren",{"$f":"IF(OR(K69=\"-\",K69=\"\"),\"\",MAX(O$1:O68)+1)","v":""},{"$f":"IF(OR(L69=\"-\",L69=\"\"),\"\",MAX(P$1:P68)+1)","v":50},{"$f":"IF(OR(M69=\"-\",M69=\"\"),\"\",MAX(Q$1:Q68)+1)","v":50},"P10SP3","Organisation von sportlichen Veranstaltungen/ Turnieren"]
[null,null,null,null,null,null,{"$f":"IF(OR(G69=MAX(Q67:Q166),G69=\"\"),\"\",MAX($G$4:G69)+1)","v":""},{"$f":"IF(G70=\"\",\"\",VLOOKUP(G70,$Q$3:$S$102,2,FALSE)&\" - \"&VLOOKUP(G70,$Q$3:$S$102,3,FALSE))","v":""},null,null,"-","P9SP4","P10SP4","Planung und Durchführung einer sportlich-entspannten Pausengestaltung",{"$f":"IF(OR(K70=\"-\",K70=\"\"),\"\",MAX(O$1:O69)+1)","v":""},{"$f":"IF(OR(L70=\"-\",L70=\"\"),\"\",MAX(P$1:P69)+1)","v":51},{"$f":"IF(OR(M70=\"-\",M70=\"\"),\"\",MAX(Q$1:Q69)+1)","v":51},"P10SP4","Planung und Durchführung einer sportlich-entspannten Pausengestaltung"]
[null,null,null,null,null,null,{"$f":"IF(OR(G70=MAX(Q68:Q167),G70=\"\"),\"\",MAX($G$4:G70)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K71=\"-\",K71=\"\"),\"\",MAX(O$1:O70)+1)","v":""},{"$f":"IF(OR(L71=\"-\",L71=\"\"),\"\",MAX(P$1:P70)+1)","v":""},{"$f":"IF(OR(M71=\"-\",M71=\"\"),\"\",MAX(Q$1:Q70)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G71=MAX(Q69:Q168),G71=\"\"),\"\",MAX($G$4:G71)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K72=\"-\",K72=\"\"),\"\",MAX(O$1:O71)+1)","v":""},{"$f":"IF(OR(L72=\"-\",L72=\"\"),\"\",MAX(P$1:P71)+1)","v":""},{"$f":"IF(OR(M72=\"-\",M72=\"\"),\"\",MAX(Q$1:Q71)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G72=MAX(Q70:Q169),G72=\"\"),\"\",MAX($G$4:G72)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K73=\"-\",K73=\"\"),\"\",MAX(O$1:O72)+1)","v":""},{"$f":"IF(OR(L73=\"-\",L73=\"\"),\"\",MAX(P$1:P72)+1)","v":""},{"$f":"IF(OR(M73=\"-\",M73=\"\"),\"\",MAX(Q$1:Q72)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G73=MAX(Q71:Q170),G73=\"\"),\"\",MAX($G$4:G73)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K74=\"-\",K74=\"\"),\"\",MAX(O$1:O73)+1)","v":""},{"$f":"IF(OR(L74=\"-\",L74=\"\"),\"\",MAX(P$1:P73)+1)","v":""},{"$f":"IF(OR(M74=\"-\",M74=\"\"),\"\",MAX(Q$1:Q73)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G74=MAX(Q72:Q171),G74=\"\"),\"\",MAX($G$4:G74)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K75=\"-\",K75=\"\"),\"\",MAX(O$1:O74)+1)","v":""},{"$f":"IF(OR(L75=\"-\",L75=\"\"),\"\",MAX(P$1:P74)+1)","v":""},{"$f":"IF(OR(M75=\"-\",M75=\"\"),\"\",MAX(Q$1:Q74)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G75=MAX(Q73:Q172),G75=\"\"),\"\",MAX($G$4:G75)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K76=\"-\",K76=\"\"),\"\",MAX(O$1:O75)+1)","v":""},{"$f":"IF(OR(L76=\"-\",L76=\"\"),\"\",MAX(P$1:P75)+1)","v":""},{"$f":"IF(OR(M76=\"-\",M76=\"\"),\"\",MAX(Q$1:Q75)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G76=MAX(Q74:Q173),G76=\"\"),\"\",MAX($G$4:G76)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K77=\"-\",K77=\"\"),\"\",MAX(O$1:O76)+1)","v":""},{"$f":"IF(OR(L77=\"-\",L77=\"\"),\"\",MAX(P$1:P76)+1)","v":""},{"$f":"IF(OR(M77=\"-\",M77=\"\"),\"\",MAX(Q$1:Q76)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G77=MAX(Q75:Q174),G77=\"\"),\"\",MAX($G$4:G77)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K78=\"-\",K78=\"\"),\"\",MAX(O$1:O77)+1)","v":""},{"$f":"IF(OR(L78=\"-\",L78=\"\"),\"\",MAX(P$1:P77)+1)","v":""},{"$f":"IF(OR(M78=\"-\",M78=\"\"),\"\",MAX(Q$1:Q77)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G78=MAX(Q76:Q175),G78=\"\"),\"\",MAX($G$4:G78)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K79=\"-\",K79=\"\"),\"\",MAX(O$1:O78)+1)","v":""},{"$f":"IF(OR(L79=\"-\",L79=\"\"),\"\",MAX(P$1:P78)+1)","v":""},{"$f":"IF(OR(M79=\"-\",M79=\"\"),\"\",MAX(Q$1:Q78)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G79=MAX(Q77:Q176),G79=\"\"),\"\",MAX($G$4:G79)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K80=\"-\",K80=\"\"),\"\",MAX(O$1:O79)+1)","v":""},{"$f":"IF(OR(L80=\"-\",L80=\"\"),\"\",MAX(P$1:P79)+1)","v":""},{"$f":"IF(OR(M80=\"-\",M80=\"\"),\"\",MAX(Q$1:Q79)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G80=MAX(Q78:Q177),G80=\"\"),\"\",MAX($G$4:G80)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K81=\"-\",K81=\"\"),\"\",MAX(O$1:O80)+1)","v":""},{"$f":"IF(OR(L81=\"-\",L81=\"\"),\"\",MAX(P$1:P80)+1)","v":""},{"$f":"IF(OR(M81=\"-\",M81=\"\"),\"\",MAX(Q$1:Q80)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G81=MAX(Q79:Q178),G81=\"\"),\"\",MAX($G$4:G81)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K82=\"-\",K82=\"\"),\"\",MAX(O$1:O81)+1)","v":""},{"$f":"IF(OR(L82=\"-\",L82=\"\"),\"\",MAX(P$1:P81)+1)","v":""},{"$f":"IF(OR(M82=\"-\",M82=\"\"),\"\",MAX(Q$1:Q81)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G82=MAX(Q80:Q179),G82=\"\"),\"\",MAX($G$4:G82)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K83=\"-\",K83=\"\"),\"\",MAX(O$1:O82)+1)","v":""},{"$f":"IF(OR(L83=\"-\",L83=\"\"),\"\",MAX(P$1:P82)+1)","v":""},{"$f":"IF(OR(M83=\"-\",M83=\"\"),\"\",MAX(Q$1:Q82)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G83=MAX(Q81:Q180),G83=\"\"),\"\",MAX($G$4:G83)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K84=\"-\",K84=\"\"),\"\",MAX(O$1:O83)+1)","v":""},{"$f":"IF(OR(L84=\"-\",L84=\"\"),\"\",MAX(P$1:P83)+1)","v":""},{"$f":"IF(OR(M84=\"-\",M84=\"\"),\"\",MAX(Q$1:Q83)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G84=MAX(Q82:Q181),G84=\"\"),\"\",MAX($G$4:G84)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K85=\"-\",K85=\"\"),\"\",MAX(O$1:O84)+1)","v":""},{"$f":"IF(OR(L85=\"-\",L85=\"\"),\"\",MAX(P$1:P84)+1)","v":""},{"$f":"IF(OR(M85=\"-\",M85=\"\"),\"\",MAX(Q$1:Q84)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G85=MAX(Q83:Q182),G85=\"\"),\"\",MAX($G$4:G85)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K86=\"-\",K86=\"\"),\"\",MAX(O$1:O85)+1)","v":""},{"$f":"IF(OR(L86=\"-\",L86=\"\"),\"\",MAX(P$1:P85)+1)","v":""},{"$f":"IF(OR(M86=\"-\",M86=\"\"),\"\",MAX(Q$1:Q85)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G86=MAX(Q84:Q183),G86=\"\"),\"\",MAX($G$4:G86)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K87=\"-\",K87=\"\"),\"\",MAX(O$1:O86)+1)","v":""},{"$f":"IF(OR(L87=\"-\",L87=\"\"),\"\",MAX(P$1:P86)+1)","v":""},{"$f":"IF(OR(M87=\"-\",M87=\"\"),\"\",MAX(Q$1:Q86)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G87=MAX(Q85:Q184),G87=\"\"),\"\",MAX($G$4:G87)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K88=\"-\",K88=\"\"),\"\",MAX(O$1:O87)+1)","v":""},{"$f":"IF(OR(L88=\"-\",L88=\"\"),\"\",MAX(P$1:P87)+1)","v":""},{"$f":"IF(OR(M88=\"-\",M88=\"\"),\"\",MAX(Q$1:Q87)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G88=MAX(Q86:Q185),G88=\"\"),\"\",MAX($G$4:G88)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K89=\"-\",K89=\"\"),\"\",MAX(O$1:O88)+1)","v":""},{"$f":"IF(OR(L89=\"-\",L89=\"\"),\"\",MAX(P$1:P88)+1)","v":""},{"$f":"IF(OR(M89=\"-\",M89=\"\"),\"\",MAX(Q$1:Q88)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G89=MAX(Q87:Q186),G89=\"\"),\"\",MAX($G$4:G89)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K90=\"-\",K90=\"\"),\"\",MAX(O$1:O89)+1)","v":""},{"$f":"IF(OR(L90=\"-\",L90=\"\"),\"\",MAX(P$1:P89)+1)","v":""},{"$f":"IF(OR(M90=\"-\",M90=\"\"),\"\",MAX(Q$1:Q89)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G90=MAX(Q88:Q187),G90=\"\"),\"\",MAX($G$4:G90)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K91=\"-\",K91=\"\"),\"\",MAX(O$1:O90)+1)","v":""},{"$f":"IF(OR(L91=\"-\",L91=\"\"),\"\",MAX(P$1:P90)+1)","v":""},{"$f":"IF(OR(M91=\"-\",M91=\"\"),\"\",MAX(Q$1:Q90)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G91=MAX(Q89:Q188),G91=\"\"),\"\",MAX($G$4:G91)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K92=\"-\",K92=\"\"),\"\",MAX(O$1:O91)+1)","v":""},{"$f":"IF(OR(L92=\"-\",L92=\"\"),\"\",MAX(P$1:P91)+1)","v":""},{"$f":"IF(OR(M92=\"-\",M92=\"\"),\"\",MAX(Q$1:Q91)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G92=MAX(Q90:Q189),G92=\"\"),\"\",MAX($G$4:G92)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K93=\"-\",K93=\"\"),\"\",MAX(O$1:O92)+1)","v":""},{"$f":"IF(OR(L93=\"-\",L93=\"\"),\"\",MAX(P$1:P92)+1)","v":""},{"$f":"IF(OR(M93=\"-\",M93=\"\"),\"\",MAX(Q$1:Q92)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G93=MAX(Q91:Q190),G93=\"\"),\"\",MAX($G$4:G93)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K94=\"-\",K94=\"\"),\"\",MAX(O$1:O93)+1)","v":""},{"$f":"IF(OR(L94=\"-\",L94=\"\"),\"\",MAX(P$1:P93)+1)","v":""},{"$f":"IF(OR(M94=\"-\",M94=\"\"),\"\",MAX(Q$1:Q93)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G94=MAX(Q92:Q191),G94=\"\"),\"\",MAX($G$4:G94)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K95=\"-\",K95=\"\"),\"\",MAX(O$1:O94)+1)","v":""},{"$f":"IF(OR(L95=\"-\",L95=\"\"),\"\",MAX(P$1:P94)+1)","v":""},{"$f":"IF(OR(M95=\"-\",M95=\"\"),\"\",MAX(Q$1:Q94)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G95=MAX(Q93:Q192),G95=\"\"),\"\",MAX($G$4:G95)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K96=\"-\",K96=\"\"),\"\",MAX(O$1:O95)+1)","v":""},{"$f":"IF(OR(L96=\"-\",L96=\"\"),\"\",MAX(P$1:P95)+1)","v":""},{"$f":"IF(OR(M96=\"-\",M96=\"\"),\"\",MAX(Q$1:Q95)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G96=MAX(Q94:Q193),G96=\"\"),\"\",MAX($G$4:G96)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K97=\"-\",K97=\"\"),\"\",MAX(O$1:O96)+1)","v":""},{"$f":"IF(OR(L97=\"-\",L97=\"\"),\"\",MAX(P$1:P96)+1)","v":""},{"$f":"IF(OR(M97=\"-\",M97=\"\"),\"\",MAX(Q$1:Q96)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G97=MAX(Q95:Q194),G97=\"\"),\"\",MAX($G$4:G97)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K98=\"-\",K98=\"\"),\"\",MAX(O$1:O97)+1)","v":""},{"$f":"IF(OR(L98=\"-\",L98=\"\"),\"\",MAX(P$1:P97)+1)","v":""},{"$f":"IF(OR(M98=\"-\",M98=\"\"),\"\",MAX(Q$1:Q97)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G98=MAX(Q96:Q195),G98=\"\"),\"\",MAX($G$4:G98)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K99=\"-\",K99=\"\"),\"\",MAX(O$1:O98)+1)","v":""},{"$f":"IF(OR(L99=\"-\",L99=\"\"),\"\",MAX(P$1:P98)+1)","v":""},{"$f":"IF(OR(M99=\"-\",M99=\"\"),\"\",MAX(Q$1:Q98)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G99=MAX(Q97:Q196),G99=\"\"),\"\",MAX($G$4:G99)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K100=\"-\",K100=\"\"),\"\",MAX(O$1:O99)+1)","v":""},{"$f":"IF(OR(L100=\"-\",L100=\"\"),\"\",MAX(P$1:P99)+1)","v":""},{"$f":"IF(OR(M100=\"-\",M100=\"\"),\"\",MAX(Q$1:Q99)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G100=MAX(Q98:Q197),G100=\"\"),\"\",MAX($G$4:G100)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K101=\"-\",K101=\"\"),\"\",MAX(O$1:O100)+1)","v":""},{"$f":"IF(OR(L101=\"-\",L101=\"\"),\"\",MAX(P$1:P100)+1)","v":""},{"$f":"IF(OR(M101=\"-\",M101=\"\"),\"\",MAX(Q$1:Q100)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G101=MAX(Q99:Q198),G101=\"\"),\"\",MAX($G$4:G101)+1)","v":""},"",null,null,null,null,null,null,{"$f":"IF(OR(K102=\"-\",K102=\"\"),\"\",MAX(O$1:O101)+1)","v":""},{"$f":"IF(OR(L102=\"-\",L102=\"\"),\"\",MAX(P$1:P101)+1)","v":""},{"$f":"IF(OR(M102=\"-\",M102=\"\"),\"\",MAX(Q$1:Q101)+1)","v":""},0,0]
[null,null,null,null,null,null,{"$f":"IF(OR(G102=MAX(Q100:Q199),G102=\"\"),\"\",MAX($G$4:G102)+1)","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(OR(G103=MAX(Q101:Q200),G103=\"\"),\"\",MAX($G$4:G103)+1)","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(OR(G104=MAX(Q102:Q201),G104=\"\"),\"\",MAX($G$4:G104)+1)","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(OR(G105=MAX(Q103:Q202),G105=\"\"),\"\",MAX($G$4:G105)+1)","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(OR(G106=MAX(Q104:Q203),G106=\"\"),\"\",MAX($G$4:G106)+1)","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(OR(G107=MAX(Q105:Q204),G107=\"\"),\"\",MAX($G$4:G107)+1)","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(OR(G108=MAX(Q106:Q205),G108=\"\"),\"\",MAX($G$4:G108)+1)","v":""},""]
[null,null,null,null,null,null,{"$f":"IF(OR(G109=MAX(Q107:Q206),G109=\"\"),\"\",MAX($G$4:G109)+1)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(G110=MAX(Q108:Q207),G110=\"\"),\"\",MAX($G$4:G110)+1)","v":""}]

{"sheet":"Abschluss","index":4,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[44,7,50,7],[35,7,36,7],[1,1,1,7],[40,2,40,5],[41,2,41,5],[7,2,7,5]]}
[null,"Kurswahl / MDG / Vers. 2.1 (Jan 2021)"]
[null,{"$f":"IF(COUNTIF(Kurswahl2!$O$8:$O$21,\"nicht erfüllt\")<1,\"\",\"formale Bedingungen nicht vollständig erfüllt\")","v":"formale Bedingungen nicht vollständig erfüllt"}]
[null,"Name:",{"$f":"'Persönliche Angaben'!D8&\" \"&'Persönliche Angaben'!D7","v":" "},null,null,null,{"$f":"'Persönliche Angaben'!D9","v":"00:00:00"},{"$f":"'Persönliche Angaben'!D10","v":0}]
[]
["1. Fremdspr:",{"$f":"IF('Persönliche Angaben'!D12=\"\",\"-\",'Persönliche Angaben'!D12)","v":"Englisch"},"2. Fremdspr.",{"$f":"IF('Persönliche Angaben'!D13=\"\",\"-\",'Persönliche Angaben'!D13)","v":"-"},"3. Fremdspr.",{"$f":"IF('Persönliche Angaben'!D14=\"\",\"-\",'Persönliche Angaben'!D14)","v":"-"}]
["WP10 Fach 1:",{"$f":"IF('Persönliche Angaben'!D16=\"\",\"-\",'Persönliche Angaben'!D16)","v":"-"},"WP10 Fach 2:",{"$f":"IF('Persönliche Angaben'!D17=\"\",\"-\",'Persönliche Angaben'!D17)","v":"-"},"P10 Kurs 1:",{"$f":"IF('Persönliche Angaben'!D19=\"\",\"-\",'Persönliche Angaben'!D19)","v":"ab 2021"},"P10 Kurs 2:",{"$f":"IF('Persönliche Angaben'!D20=\"\",\"-\",'Persönliche Angaben'!D20)","v":"-"}]
[]
["1. Aufgabenfeld",null,"Semester"]
["Fach","Pr.fach","1.","2.","3.","4.","belegt","einbringbar"]
["Deutsch",{"$f":"IF(Kurswahl2!C10=\"\",\"\",Kurswahl2!C10)","v":""},{"$f":"IF(Kurswahl2!D10=\"\",\"\",Kurswahl2!D10)","v":"x"},{"$f":"IF(Kurswahl2!E10=\"\",\"\",Kurswahl2!E10)","v":"x"},{"$f":"IF(Kurswahl2!F10=\"\",\"\",Kurswahl2!F10)","v":"x"},{"$f":"IF(Kurswahl2!G10=\"\",\"\",Kurswahl2!G10)","v":"x"},{"$f":"IF(Kurswahl2!H10=\"\",\"\",Kurswahl2!H10)","v":4},{"$f":"G10","v":4}]
["Musik",{"$f":"IF(Kurswahl2!C11=\"\",\"\",Kurswahl2!C11)","v":""},{"$f":"IF(Kurswahl2!D11=\"\",\"\",Kurswahl2!D11)","v":""},{"$f":"IF(Kurswahl2!E11=\"\",\"\",Kurswahl2!E11)","v":""},{"$f":"IF(Kurswahl2!F11=\"\",\"\",Kurswahl2!F11)","v":""},{"$f":"IF(Kurswahl2!G11=\"\",\"\",Kurswahl2!G11)","v":""},{"$f":"IF(Kurswahl2!H11=\"\",\"\",Kurswahl2!H11)","v":0},{"$f":"G11","v":0}]
["Kunst",{"$f":"IF(Kurswahl2!C12=\"\",\"\",Kurswahl2!C12)","v":""},{"$f":"IF(Kurswahl2!D12=\"\",\"\",Kurswahl2!D12)","v":""},{"$f":"IF(Kurswahl2!E12=\"\",\"\",Kurswahl2!E12)","v":""},{"$f":"IF(Kurswahl2!F12=\"\",\"\",Kurswahl2!F12)","v":""},{"$f":"IF(Kurswahl2!G12=\"\",\"\",Kurswahl2!G12)","v":""},{"$f":"IF(Kurswahl2!H12=\"\",\"\",Kurswahl2!H12)","v":0},0]
["Englisch",{"$f":"IF(Kurswahl2!C13=\"\",\"\",Kurswahl2!C13)","v":""},{"$f":"IF(Kurswahl2!D13=\"\",\"\",Kurswahl2!D13)","v":""},{"$f":"IF(Kurswahl2!E13=\"\",\"\",Kurswahl2!E13)","v":""},{"$f":"IF(Kurswahl2!F13=\"\",\"\",Kurswahl2!F13)","v":""},{"$f":"IF(Kurswahl2!G13=\"\",\"\",Kurswahl2!G13)","v":""},{"$f":"IF(Kurswahl2!H13=\"\",\"\",Kurswahl2!H13)","v":0},0]
["Französisch",{"$f":"IF(Kurswahl2!C14=\"\",\"\",Kurswahl2!C14)","v":""},{"$f":"IF(Kurswahl2!D14=\"\",\"\",Kurswahl2!D14)","v":""},{"$f":"IF(Kurswahl2!E14=\"\",\"\",Kurswahl2!E14)","v":""},{"$f":"IF(Kurswahl2!F14=\"\",\"\",Kurswahl2!F14)","v":""},{"$f":"IF(Kurswahl2!G14=\"\",\"\",Kurswahl2!G14)","v":""},{"$f":"IF(Kurswahl2!H14=\"\",\"\",Kurswahl2!H14)","v":0},0]
["Latein",{"$f":"IF(Kurswahl2!C15=\"\",\"\",Kurswahl2!C15)","v":""},{"$f":"IF(Kurswahl2!D15=\"\",\"\",Kurswahl2!D15)","v":""},{"$f":"IF(Kurswahl2!E15=\"\",\"\",Kurswahl2!E15)","v":""},{"$f":"IF(Kurswahl2!F15=\"\",\"\",Kurswahl2!F15)","v":""},{"$f":"IF(Kurswahl2!G15=\"\",\"\",Kurswahl2!G15)","v":""},{"$f":"IF(Kurswahl2!H15=\"\",\"\",Kurswahl2!H15)","v":0},0]
["Spanisch",{"$f":"IF(Kurswahl2!C16=\"\",\"\",Kurswahl2!C16)","v":""},{"$f":"IF(Kurswahl2!D16=\"\",\"\",Kurswahl2!D16)","v":""},{"$f":"IF(Kurswahl2!E16=\"\",\"\",Kurswahl2!E16)","v":""},{"$f":"IF(Kurswahl2!F16=\"\",\"\",Kurswahl2!F16)","v":""},{"$f":"IF(Kurswahl2!G16=\"\",\"\",Kurswahl2!G16)","v":""},{"$f":"IF(Kurswahl2!H16=\"\",\"\",Kurswahl2!H16)","v":0},0]
["Darst. Spiel",{"$f":"IF(Kurswahl2!C17=\"\",\"\",Kurswahl2!C17)","v":""},{"$f":"IF(Kurswahl2!D17=\"\",\"\",Kurswahl2!D17)","v":""},{"$f":"IF(Kurswahl2!E17=\"\",\"\",Kurswahl2!E17)","v":""},{"$f":"IF(Kurswahl2!F17=\"\",\"\",Kurswahl2!F17)","v":""},{"$f":"IF(Kurswahl2!G17=\"\",\"\",Kurswahl2!G17)","v":""},{"$f":"IF(Kurswahl2!H17=\"\",\"\",Kurswahl2!H17)","v":0},0]
[]
["2. Aufgabenfeld"]
["Fach","Pr.fach","1.","2.","3.","4.","belegt","einbringbar"]
["Politikwiss.",{"$f":"IF(Kurswahl2!C20=\"\",\"\",Kurswahl2!C20)","v":""},{"$f":"IF(Kurswahl2!D20=\"\",\"\",Kurswahl2!D20)","v":""},{"$f":"IF(Kurswahl2!E20=\"\",\"\",Kurswahl2!E20)","v":""},{"$f":"IF(Kurswahl2!F20=\"\",\"\",Kurswahl2!F20)","v":""},{"$f":"IF(Kurswahl2!G20=\"\",\"\",Kurswahl2!G20)","v":""},{"$f":"IF(Kurswahl2!H20=\"\",\"\",Kurswahl2!H20)","v":0},{"$f":"G21","v":0}]
["Geschichte",{"$f":"IF(Kurswahl2!C21=\"\",\"\",Kurswahl2!C21)","v":""},{"$f":"IF(Kurswahl2!D21=\"\",\"\",Kurswahl2!D21)","v":""},{"$f":"IF(Kurswahl2!E21=\"\",\"\",Kurswahl2!E21)","v":""},{"$f":"IF(Kurswahl2!F21=\"\",\"\",Kurswahl2!F21)","v":"x"},{"$f":"IF(Kurswahl2!G21=\"\",\"\",Kurswahl2!G21)","v":"x"},{"$f":"IF(Kurswahl2!H21=\"\",\"\",Kurswahl2!H21)","v":2},{"$f":"G22","v":2}]
["Geografie",{"$f":"IF(Kurswahl2!C22=\"\",\"\",Kurswahl2!C22)","v":""},{"$f":"IF(Kurswahl2!D22=\"\",\"\",Kurswahl2!D22)","v":""},{"$f":"IF(Kurswahl2!E22=\"\",\"\",Kurswahl2!E22)","v":""},{"$f":"IF(Kurswahl2!F22=\"\",\"\",Kurswahl2!F22)","v":""},{"$f":"IF(Kurswahl2!G22=\"\",\"\",Kurswahl2!G22)","v":""},{"$f":"IF(Kurswahl2!H22=\"\",\"\",Kurswahl2!H22)","v":0},0]
["Philosophie",{"$f":"IF(Kurswahl2!C23=\"\",\"\",Kurswahl2!C23)","v":""},{"$f":"IF(Kurswahl2!D23=\"\",\"\",Kurswahl2!D23)","v":""},{"$f":"IF(Kurswahl2!E23=\"\",\"\",Kurswahl2!E23)","v":""},{"$f":"IF(Kurswahl2!F23=\"\",\"\",Kurswahl2!F23)","v":""},{"$f":"IF(Kurswahl2!G23=\"\",\"\",Kurswahl2!G23)","v":""},{"$f":"IF(Kurswahl2!H23=\"\",\"\",Kurswahl2!H23)","v":0},0]
[]
["3. Aufgabenfeld"]
["Fach","Pr.fach","1.","2.","3.","4.","belegt","einbringbar"]
["Mathematik",{"$f":"IF(Kurswahl2!C26=\"\",\"\",Kurswahl2!C26)","v":""},{"$f":"IF(Kurswahl2!D26=\"\",\"\",Kurswahl2!D26)","v":"x"},{"$f":"IF(Kurswahl2!E26=\"\",\"\",Kurswahl2!E26)","v":"x"},{"$f":"IF(Kurswahl2!F26=\"\",\"\",Kurswahl2!F26)","v":"x"},{"$f":"IF(Kurswahl2!G26=\"\",\"\",Kurswahl2!G26)","v":"x"},{"$f":"IF(Kurswahl2!H26=\"\",\"\",Kurswahl2!H26)","v":4},{"$f":"G28","v":4}]
["Physik",{"$f":"IF(Kurswahl2!C27=\"\",\"\",Kurswahl2!C27)","v":""},{"$f":"IF(Kurswahl2!D27=\"\",\"\",Kurswahl2!D27)","v":""},{"$f":"IF(Kurswahl2!E27=\"\",\"\",Kurswahl2!E27)","v":""},{"$f":"IF(Kurswahl2!F27=\"\",\"\",Kurswahl2!F27)","v":""},{"$f":"IF(Kurswahl2!G27=\"\",\"\",Kurswahl2!G27)","v":""},{"$f":"IF(Kurswahl2!H27=\"\",\"\",Kurswahl2!H27)","v":0},{"$f":"G29","v":0}]
["Chemie",{"$f":"IF(Kurswahl2!C28=\"\",\"\",Kurswahl2!C28)","v":""},{"$f":"IF(Kurswahl2!D28=\"\",\"\",Kurswahl2!D28)","v":""},{"$f":"IF(Kurswahl2!E28=\"\",\"\",Kurswahl2!E28)","v":""},{"$f":"IF(Kurswahl2!F28=\"\",\"\",Kurswahl2!F28)","v":""},{"$f":"IF(Kurswahl2!G28=\"\",\"\",Kurswahl2!G28)","v":""},{"$f":"IF(Kurswahl2!H28=\"\",\"\",Kurswahl2!H28)","v":0},0]
["Biologie",{"$f":"IF(Kurswahl2!C29=\"\",\"\",Kurswahl2!C29)","v":""},{"$f":"IF(Kurswahl2!D29=\"\",\"\",Kurswahl2!D29)","v":""},{"$f":"IF(Kurswahl2!E29=\"\",\"\",Kurswahl2!E29)","v":""},{"$f":"IF(Kurswahl2!F29=\"\",\"\",Kurswahl2!F29)","v":""},{"$f":"IF(Kurswahl2!G29=\"\",\"\",Kurswahl2!G29)","v":""},{"$f":"IF(Kurswahl2!H29=\"\",\"\",Kurswahl2!H29)","v":0},0]
["Informatik",{"$f":"IF(Kurswahl2!C30=\"\",\"\",Kurswahl2!C30)","v":""},{"$f":"IF(Kurswahl2!D30=\"\",\"\",Kurswahl2!D30)","v":""},{"$f":"IF(Kurswahl2!E30=\"\",\"\",Kurswahl2!E30)","v":""},{"$f":"IF(Kurswahl2!F30=\"\",\"\",Kurswahl2!F30)","v":""},{"$f":"IF(Kurswahl2!G30=\"\",\"\",Kurswahl2!G30)","v":""},{"$f":"IF(Kurswahl2!H30=\"\",\"\",Kurswahl2!H30)","v":0},0]
[]
["Sport"]
["Fach","Pr.fach","1.","2.","3.","4.","belegt","einbringbar"]
["Sport Theorie",{"$f":"IF(Kurswahl2!C33=\"\",\"\",Kurswahl2!C33)","v":""},{"$f":"IF(Kurswahl2!D33=\"\",\"\",Kurswahl2!D33)","v":""},{"$f":"IF(Kurswahl2!E33=\"\",\"\",Kurswahl2!E33)","v":""},{"$f":"IF(Kurswahl2!F33=\"\",\"\",Kurswahl2!F33)","v":""},{"$f":"IF(Kurswahl2!G35=\"\",\"\",Kurswahl2!G35)","v":""},{"$f":"IF(Kurswahl2!H35=\"\",\"\",Kurswahl2!H33)","v":""},{"$f":"SUM(Kurswahl2!H33:H35,Kurswahl2!H48:H49)","v":4}]
["Sport ",{"$f":"IF(Kurswahl2!C34=\"\",\"\",Kurswahl2!C34)","v":""},{"$f":"IF(Kurswahl2!D34=\"\",\"\",Kurswahl2!D34)","v":"x"},{"$f":"IF(Kurswahl2!E34=\"\",\"\",Kurswahl2!E34)","v":"x"},{"$f":"IF(Kurswahl2!F34=\"\",\"\",Kurswahl2!F34)","v":"x"},{"$f":"IF(Kurswahl2!G34=\"\",\"\",Kurswahl2!G34)","v":"x"},{"$f":"IF(Kurswahl2!H34=\"\",\"\",Kurswahl2!H34)","v":4}]
[]
["Sonstige Kurse"]
["Fach","Pr.fach","1.","2.","3.","4.","belegt","einbringbar"]
[{"$f":"Kurswahl2!B48","v":"Ski und Snowboard"},{"$f":"IF(Kurswahl2!C48=\"\",\"\",Kurswahl2!C48)","v":""},{"$f":"IF(Kurswahl2!E48=\"\",\"\",Kurswahl2!E48)","v":""},null,null,null,{"$f":"IF(Kurswahl2!E48=\"x\",1,0)","v":0},{"$f":"Kurswahl2!H48","v":0}]
[{"$f":"Kurswahl2!B49","v":"Surfen"},{"$f":"IF(Kurswahl2!C49=\"\",\"\",Kurswahl2!C49)","v":""},{"$f":"IF(Kurswahl2!F49=\"\",\"\",Kurswahl2!F49)","v":""},null,null,null,{"$f":"IF(Kurswahl2!F49=\"x\",1,0)","v":0},{"$f":"Kurswahl2!H49","v":0}]
[{"$f":"Kurswahl2!B38","v":"ZK: Ensemblemusik"},{"$f":"IF(Kurswahl2!C38=\"\",\"\",Kurswahl2!C38)","v":""},{"$f":"IF(Kurswahl2!D38=\"\",\"\",Kurswahl2!D38)","v":""},{"$f":"IF(Kurswahl2!E38=\"\",\"\",Kurswahl2!E38)","v":""},{"$f":"IF(Kurswahl2!F38=\"\",\"\",Kurswahl2!F38)","v":""},{"$f":"IF(Kurswahl2!G38=\"\",\"\",Kurswahl2!G38)","v":""},{"$f":"IF(Kurswahl2!H38=\"\",\"\",Kurswahl2!H38)","v":0},{"$f":"G43","v":0}]
[{"$f":"Kurswahl2!B39","v":"Latein"},{"$f":"IF(Kurswahl2!C39=\"\",\"\",Kurswahl2!C39)","v":""},{"$f":"IF(Kurswahl2!D39=\"\",\"\",Kurswahl2!D39)","v":""},{"$f":"IF(Kurswahl2!E39=\"\",\"\",Kurswahl2!E39)","v":""},{"$f":"IF(Kurswahl2!F39=\"\",\"\",Kurswahl2!F39)","v":""},{"$f":"IF(Kurswahl2!G39=\"\",\"\",Kurswahl2!G39)","v":""},{"$f":"IF(Kurswahl2!#REF!=\"\",\"\",Kurswahl2!#REF!)","v":{"$error":"#REF!"}},{"$f":"G44","v":{"$error":"#REF!"}}]
[{"$f":"Kurswahl2!B40","v":"ZK: Rhetorik"},{"$f":"IF(Kurswahl2!C40=\"\",\"\",Kurswahl2!C40)","v":""},{"$f":"IF(Kurswahl2!D40=\"\",\"\",Kurswahl2!D40)","v":""},{"$f":"IF(Kurswahl2!E40=\"\",\"\",Kurswahl2!E40)","v":""},{"$f":"IF(Kurswahl2!F40=\"\",\"\",Kurswahl2!F40)","v":""},{"$f":"IF(Kurswahl2!G40=\"\",\"\",Kurswahl2!G40)","v":""},{"$f":"COUNTIF(Kurswahl2!D40:G40,\"x\")","v":0},{"$f":"IF(Kurswahl2!H39=\"\",\"\",Kurswahl2!H39)","v":0}]
[{"$f":"Kurswahl2!B41","v":"ZK: Robotik"},{"$f":"IF(Kurswahl2!C41=\"\",\"\",Kurswahl2!C41)","v":""},{"$f":"IF(Kurswahl2!D41=\"\",\"\",Kurswahl2!D41)","v":""},{"$f":"IF(Kurswahl2!E41=\"\",\"\",Kurswahl2!E41)","v":""},{"$f":"IF(Kurswahl2!F41=\"\",\"\",Kurswahl2!F41)","v":""},{"$f":"IF(Kurswahl2!G41=\"\",\"\",Kurswahl2!G41)","v":""},{"$f":"COUNTIF(Kurswahl2!D41:G41,\"x\")","v":0}]
[{"$f":"Kurswahl2!B42","v":"ZK: Natur - Raum - Kunst"},{"$f":"IF(Kurswahl2!C42=\"\",\"\",Kurswahl2!C42)","v":""},{"$f":"IF(Kurswahl2!D42=\"\",\"\",Kurswahl2!D42)","v":""},{"$f":"IF(Kurswahl2!E42=\"\",\"\",Kurswahl2!E42)","v":""},{"$f":"IF(Kurswahl2!F42=\"\",\"\",Kurswahl2!F42)","v":""},{"$f":"IF(Kurswahl2!G42=\"\",\"\",Kurswahl2!G42)","v":""},{"$f":"COUNTIF(Kurswahl2!D42:G42,\"x\")","v":0}]
[{"$f":"Kurswahl2!B43","v":"ZK: EDEN "},{"$f":"IF(Kurswahl2!C43=\"\",\"\",Kurswahl2!C43)","v":""},{"$f":"IF(Kurswahl2!D43=\"\",\"\",Kurswahl2!D43)","v":""},{"$f":"IF(Kurswahl2!E43=\"\",\"\",Kurswahl2!E43)","v":""},{"$f":"IF(Kurswahl2!F43=\"\",\"\",Kurswahl2!F43)","v":""},{"$f":"IF(Kurswahl2!G43=\"\",\"\",Kurswahl2!G43)","v":""},{"$f":"COUNTIF(Kurswahl2!D43:G43,\"x\")","v":0}]
[{"$f":"Kurswahl2!B44","v":"ZK: Wittenberggalaxis"},{"$f":"IF(Kurswahl2!C44=\"\",\"\",Kurswahl2!C44)","v":""},{"$f":"IF(Kurswahl2!D44=\"\",\"\",Kurswahl2!D44)","v":""},{"$f":"IF(Kurswahl2!E44=\"\",\"\",Kurswahl2!E44)","v":""},{"$f":"IF(Kurswahl2!F44=\"\",\"\",Kurswahl2!F44)","v":""},{"$f":"IF(Kurswahl2!G44=\"\",\"\",Kurswahl2!G44)","v":""},{"$f":"COUNTIF(Kurswahl2!D44:G44,\"x\")","v":0}]
[{"$f":"Kurswahl2!B45","v":"ZK: Digitale Welten"},{"$f":"IF(Kurswahl2!C45=\"\",\"\",Kurswahl2!C45)","v":""},{"$f":"IF(Kurswahl2!D45=\"\",\"\",Kurswahl2!D45)","v":""},{"$f":"IF(Kurswahl2!E45=\"\",\"\",Kurswahl2!E45)","v":""},{"$f":"IF(Kurswahl2!F45=\"\",\"\",Kurswahl2!F45)","v":""},{"$f":"IF(Kurswahl2!G45=\"\",\"\",Kurswahl2!G45)","v":""},{"$f":"COUNTIF(Kurswahl2!D45:G45,\"x\")","v":0}]
[{"$f":"Kurswahl2!B46","v":"ZK: Welttanzprogramm"},{"$f":"IF(Kurswahl2!C46=\"\",\"\",Kurswahl2!C46)","v":""},{"$f":"IF(Kurswahl2!D46=\"\",\"\",Kurswahl2!D46)","v":""},{"$f":"IF(Kurswahl2!E46=\"\",\"\",Kurswahl2!E46)","v":""},{"$f":"IF(Kurswahl2!F46=\"\",\"\",Kurswahl2!F46)","v":""},{"$f":"IF(Kurswahl2!G46=\"\",\"\",Kurswahl2!G46)","v":""},{"$f":"COUNTIF(Kurswahl2!D46:G46,\"x\")","v":0}]
[{"$f":"Kurswahl2!B47","v":"ZK: Studium und Beruf"},{"$f":"IF(Kurswahl2!C47=\"\",\"\",Kurswahl2!C47)","v":""},{"$f":"IF(Kurswahl2!D47=\"\",\"\",Kurswahl2!D47)","v":""},{"$f":"IF(Kurswahl2!E47=\"\",\"\",Kurswahl2!E47)","v":""},{"$f":"IF(Kurswahl2!F47=\"\",\"\",Kurswahl2!F47)","v":""},{"$f":"IF(Kurswahl2!G47=\"\",\"\",Kurswahl2!G47)","v":""},{"$f":"IF(Kurswahl2!H47=\"\",\"\",Kurswahl2!H47)","v":0},{"$f":"G52","v":0}]
[]
["Stunden insg.:",{"$f":"Kurswahl2!R47+Kurswahl2!R48","v":{"$error":"#VALUE!"}},"Kurse:",{"$f":"Kurswahl2!Q49","v":{"$error":"#VALUE!"}},"einbringbar:",{"$f":"Kurswahl2!Q50","v":14}]
[]
["Datum, Unterschrift:"]