{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Hinweise","FOBOSO §35","FOBOSO Anlagen","FOS 12","BOS 12","FOSBOS 13-1","FOSBOS 13-2","FOSBOS 13-3"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":5,"comments":5,"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":"Hinweise","index":0,"n_rows":37,"n_cols":33,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Wahlpflichtfächer",null,null,null,null,null,"(3) 1","(3) 2","(2h) 3","(2v) 4","(3) 5","(3) 6","(2h) 7","(2h) 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 22.02.22"]
[null,"WPF 1","Wahlpflichtfach 1",1,null,null,null,null,"Profilfach 1","Profilfach 2","Profilfach 3","Profilfach 3","Profilfach 3","Profilfach 4","Profilfach 5","Profilfach 6"]
[null,"WPF 2","Wahlpflichtfach 2",1,null,"T","Technik","T","Physik","Technologie",{"$f":"\"-\"","v":"-"},{"$f":"\"-\"","v":"-"},"Chemie",{"$f":"\"-\"","v":"-"},"Mathe Additum",{"$f":"\"-\"","v":"-"}]
[null,"WPF 3","Wahlpflichtfach 3",1,null,"ABU","Agrar","ABU","Biologie","Chemie",{"$f":"\"-\"","v":"-"},{"$f":"\"-\"","v":"-"},"Physik",{"$f":"\"-\"","v":"-"},"Technologie","-"]
[null,"Eingabe","Wahlpflichtfach auswählen",0,null,"W","Wirtschaft","W","BWR","VWL",{"$f":"\"-\"","v":"-"},"Rechtslehre",{"$f":"\"-\"","v":"-"},"-","Naturwissenschaften","Informatik"]
[null,"kein","-",0,null,"IW","Int. Wirtschaft","IW","IBV","Franz./Span.","-","Rechtslehre",{"$f":"\"-\"","v":"-"},"-","Naturwissenschaften","IBS"]
[null,"B-A ","Aspekte der Biologie",1,null,"S","Sozialwesen","S","Päd./Psy.","Sozialwirtschaft und Recht","-","Chemie",{"$f":"\"-\"","v":"-"},"-","Biologie","Soziologie"]
[null,"C-A ","Aspekte der Chemie",1,null,"Gdh","Gesundheit","Gdh","Gesundheitswissenschaften","-","Biologie",{"$f":"\"-\"","v":"-"},"Kom./Int.","Chemie",{"$f":"\"-\"","v":"-"},{"$f":"\"-\"","v":"-"}]
[null,"PhA ","Aspekte der Physik",1,null,"Gst","Gestaltung","Gst","Gestaltung Praxis","Gestaltung Theorie","Naturwissenschaften",{"$f":"\"-\"","v":"-"},"Medien","-","-","-"]
[null,"PsA ","Aspekte der Psychologie",1]
[null,"Bte ","Biotechnologie",1]
[null,"EBC ","English Book Club",1,null,null,null,null,"Profilfach 1","Profilfach 2",null,null,"Profilfach 3","Profilfach 3"]
[null,"GEx ","Experimentelles Gestalten",1,null,"T","Technik","T","Physik","Technologie",null,null,"Chemie","Mathe Additum"]
[null,"F ","Französisch",1,null,"ABU","Agrar","ABU","Biologie","Chemie",null,null,"Physik","Technologie"]
[null,"F-f ","Französisch (fortgeführt)",1,null,"W","Wirtschaft","W","BWR","VWL",null,null,"Naturwissenschaften","Informatik"]
[null,"RGw ","Gesundheitswirtschaft und Recht",1,null,"IW","Int. Wirtschaft","IW","IBV","Franz./Span.",null,null,"Naturwissenschaften","IBS"]
[null,"Inf ","Informatik",1,null,"S","Sozialwesen","S","Päd./Psy.","Sozialwirtschaft und Recht",null,null,"Biologie","Soziologie"]
[null,"IBS ","International Business Studies",1,null,"Gdh","Gesundheit","Gdh","Gesundheitswissenschaften","Biologie","x",null,"Kom./Int.","Chemie"]
[null,"IPo ","Internationale Politik",1,null,"Gst","Gestaltung","Gst","Gestaltung Praxis","Gestaltung Theorie",null,null,"Naturwissenschaften","Medien"]
[null,"It ","Italienisch",1]
[null,"Ku ","Kunst*",0,null,null,null,null,"Profilfach 1","Profilfach 2","Profilfach 3"]
[null,"L ","Latein",1,null,"T","Technik","T","Physik","Technologie","Chemie"]
[null,"M+ ","Mathematik Additum",1,null,"ABU","Agrar","ABU","Biologie","Chemie","Technologie"]
[null,"Mu ","Musik*",0,null,"W","Wirtschaft","W","BWR","VWL","Naturwissenschaften"]
[null,"Ph+ ","Physik (Additum)",1,null,"IW","Int. Wirtschaft","IW","IBV","Franz./Span.","Naturwissenschaften"]
[null,"Ru ","Russisch",1,null,"S","Sozialwesen","S","Päd./Psy.","Sozialwirtschaft und Recht","Biologie"]
[null,"SoP ","Sozialpsychologie",1,null,"Gdh","Gesundheit","Gdh","Gesundheitswissenschaften","Biologie","Kommunik./Interakt."]
[null,"Soz ","Soziologie",1,null,"Gst","Gestaltung","Gst","Gestaltung","Medien","Naturwissenschaften"]
[null,"Sp ","Spanisch",1]
[null,"Spf ","Spanisch (fortgeführt)",1]
[null,"SGe ","Spektrum der Gesundheit",1]
[null,"S ","Sport*",0]
[null,"S+A ","Studier- und Arbeitstechniken*",0]
[null,"GSz ","Szenisches Gestalten*",0]
[null,"WAk ","Wirtschaft Aktuell",1]
[null,"WR ","Wirtschaft und Recht",1]

{"sheet":"FOBOSO §35","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FOBOSO Anlagen","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FOS 12","index":3,"n_rows":46,"n_cols":38,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,35,8,37],[12,34,12,37],[37,3,37,5],[38,3,38,5],[39,3,39,5],[30,3,30,4],[41,2,41,14],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,5],[35,9,35,10],[36,3,36,5],[1,2,1,3],[1,8,1,14],[2,9,2,13],[3,3,3,5],[3,7,3,14],[4,3,4,10],[24,7,24,10],[26,3,26,10],[28,3,28,4],[29,3,29,4],[29,5,29,6],[28,5,28,6],[27,3,27,10]]}
[]
[null,null,"Abschlussprüfung FOS 12",null,null,null,null,"Name: _____________________________","Erika Musterfrau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C29","v":"Punktezahl Prüfungen (dreifach)"},{"$f":"D29","v":51},{"$f":"F29","v":"Anzahl:"},{"$f":"H29","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2022-12-22T12:27:08.450"},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":"C30","v":"Punktezahl weiterer 25 HJE"},{"$f":"D30","v":179},{"$f":"F30","v":" Anzahl:"},{"$f":"H30","v":25}]
[null,null,"Ausbildungsrichtung:  ","Wirtschaft",null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punktezahl Fachreferat",4]
[null,null,null,"Zu streichende HJE mit x markieren!",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(R7:R24)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE7:AE26)","v":0},{"$f":"COUNT(AF8:AF14)","v":2},null,null,"Punktezahl FPA",12]
["EB",null,null,"11/1","x","11/2","x","12/1","x","12/2","x","sP","mP","PE","GE",null,"GE(eingebracht)","Str.","GE",null,null,"11/1","11/1 einbr","11/2","11/2 einbr","12/1","12/1 einbr","12/2","12/2 einbr","Anzahl","Anzahl GE(nichtprüfung)<4","Anz. mdl. Prfg",null,null,{"$f":"C33","v":"Gesamt:"},246]
[1,null,"Religionslehre/Ethik",null,null,null,null,15,null,9,null,null,null,null,{"$f":"IF(AND(ISERROR(S7),ISERROR(T7)),\"\",IF(ISNUMBER(S7),ROUND(S7,0),ROUND(T7,0)))","v":12},null,{"$f":"IF(A7=1,O7,\"\")","v":12},{"$f":"COUNTIF(D7:K7,\"x\")","v":0},{"$f":"IF(AVERAGE(V7:AB7)<1,0,AVERAGE(V7:AB7))","v":12},{"$f":"IF(AVERAGE(D7:J7)<1,0,AVERAGE(D7:J7))","v":12},null,{"$f":"IF(AND(ISNUMBER(D7),E7=\"\",$A7=1),D7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(F7),G7=\"\",$A7=1),F7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(H7),I7=\"\",$A7=1),H7,\"\")","v":15},null,{"$f":"IF(AND(ISNUMBER(J7),K7=\"\",$A7=1),J7,\"\")","v":9},null,{"$f":"COUNT(V7:AB7)","v":2},{"$f":"IF(Q7<4,IF(Q7=0,2,1),\"\")","v":""},null,null,null,{"$f":"C34","v":"Durchschnittsnote:"},3.6,{"$f":"F34","v":3.6166666666666671}]
[1,null,"Deutsch",null,null,8,null,5,null,10,null,2,4,{"$f":"IF(ISBLANK(L8),\"\",IF(ISBLANK(M8),L8,IF((L8*2+M8)/3<1,0,ROUND((L8*2+M8)/3,0))))","v":3},{"$f":"IF(ISBLANK(L8),\"\",IF(AND(ISERROR(S8),ISERROR(T8)),\"\",IF(ISNUMBER(S8),ROUND(S8,0),ROUND(T8,0))))","v":5},null,5,{"$f":"COUNTIF(D8:K8,\"x\")","v":0},{"$f":"IF((3*N8+SUM(V8:AB8))/(AD8+3)<1,0,(3*N8+SUM(V8:AB8))/(AD8+3))","v":5.333333333333333},{"$f":"AVERAGE(D8:J8)","v":7.666666666666667},null,"",null,8,null,5,null,10,null,{"$f":"COUNT(V8:AB8)","v":3},null,{"$f":"IF(M8=\"\",\"\",M8)","v":4},null,null,"Fachabitur:","bestanden"]
[1,null,"Englisch",null,null,9,null,2,"x",4,null,6,9,{"$f":"IF(ISBLANK(L9),\"\",IF(ISBLANK(M9),L9,IF((L9*2+M9)/3<1,0,ROUND((L9*2+M9)/3,0))))","v":7},{"$f":"IF(ISBLANK(L9),\"\",IF(AND(ISERROR(S9),ISERROR(T9)),\"\",IF(ISNUMBER(S9),ROUND(S9,0),ROUND(T9,0))))","v":7},null,7,1,{"$f":"IF((3*N9+SUM(V9:AB9))/(AD9+3)<1,0,(3*N9+SUM(V9:AB9))/(AD9+3))","v":6.8},5,null,"",null,9,null,"",null,4,null,2,null,{"$f":"IF(M9=\"\",\"\",M9)","v":9},null,null,"Überprüfung nach § 35 (9):"]
[1,null,"Mathematik",null,null,5,null,7,null,3,null,3,null,{"$f":"IF(ISBLANK(L10),\"\",IF(ISBLANK(M10),L10,IF((L10*2+M10)/3<1,0,ROUND((L10*2+M10)/3,0))))","v":3},{"$f":"IF(ISBLANK(L10),\"\",IF(AND(ISERROR(S10),ISERROR(T10)),\"\",IF(ISNUMBER(S10),ROUND(S10,0),ROUND(T10,0))))","v":4},null,4,0,4,5,null,"",null,5,null,7,null,3,null,3,null,"",null,null,{"$f":"C38","v":"Prüfungsergebnisse"},{"$f":"D38","v":"erfüllt"},"<4",{"$f":"N37","v":2}]
[1,null,"Geschichte",10,null,7,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISERROR(S11),ISERROR(T11)),\"\",IF(ISNUMBER(S11),ROUND(S11,0),ROUND(T11,0)))","v":9},null,9,0,{"$f":"IF(AVERAGE(V11:AB11)<1,0,AVERAGE(V11:AB11))","v":8.5},{"$f":"IF(AVERAGE(D11:J11)<1,0,AVERAGE(D11:J11))","v":8.5},null,10,null,7,null,"",null,"",null,2,{"$f":"IF(Q11<4,IF(Q11=0,2,1),\"\")","v":""},null,null,null,{"$f":"C39","v":"Gesamtergebnisse"},{"$f":"D39","v":"erfüllt"},"<4",{"$f":"M37","v":0}]
[1,null,"Politik und Gesellschaft",null,null,null,null,4,null,3,"x",null,null,null,4,null,4,1,{"$f":"IF(AVERAGE(V12:AB12)<1,0,AVERAGE(V12:AB12))","v":4},{"$f":"IF(AVERAGE(D12:J12)<1,0,AVERAGE(D12:J12))","v":3.5},null,"",null,"",null,4,null,"",null,1,""]
[0,null,"Sport*",null,null,null,null,1,null,1,null,null,null,null,1,null,"",0,{"$f":"IF(AVERAGE(V13:AB13)<1,0,AVERAGE(V13:AB13))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AVERAGE(D13:J13)<1,0,AVERAGE(D13:J13))","v":1},null,"",null,"",null,"",null,"",null,0,"",null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!"]
[{"$f":"IF(C14=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$4:$N$10,3,FALSE)","v":"BWR"},null,null,3,null,3,"x",8,null,4,null,{"$f":"IF(ISBLANK(L14),\"\",IF(ISBLANK(M14),L14,IF((L14*2+M14)/3<1,0,ROUND((L14*2+M14)/3,0))))","v":4},{"$f":"IF(ISBLANK(L14),\"\",IF(AND(ISERROR(S14),ISERROR(T14)),\"\",IF(ISNUMBER(S14),ROUND(S14,0),ROUND(T14,0))))","v":5},null,5,1,{"$f":"IF((3*N14+SUM(V14:AB14))/(AD14+3)<1,0,(3*N14+SUM(V14:AB14))/(AD14+3))","v":4.5999999999999996},4.666666666666667,null,"",null,3,null,"",null,8,null,2,null,""]
[{"$f":"IF(C15=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$4:$N$10,4,FALSE)","v":"VWL"},null,null,3,"x",8,null,7,null,null,null,null,8,null,8,1,{"$f":"IF(AVERAGE(V15:AB15)<1,0,AVERAGE(V15:AB15))","v":7.5},{"$f":"IF(AVERAGE(D15:J15)<1,0,AVERAGE(D15:J15))","v":6},null,"",null,"",null,8,null,7,null,2,""]
[0,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$4:$N$10,5,FALSE)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"",null,"",0,{"$f":"IF(AVERAGE(V16:AB16)<1,0,AVERAGE(V16:AB16))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AVERAGE(D16:J16)<1,0,AVERAGE(D16:J16))","v":{"$error":"#DIV/0!"}},null,"",null,"",null,"",null,"",null,0,""]
[1,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$4:$N$10,6,FALSE)","v":"Rechtslehre"},7,null,4,null,null,null,null,null,null,null,null,6,null,6,0,5.5,5.5,null,7,null,4,null,"",null,"",null,2,""]
[0,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$4:$N$10,7,FALSE)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"",null,"",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",null,"",null,"",null,"",null,0,""]
[0,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$4:$P$10,8,FALSE)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,"",null,"",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",null,"",null,"",null,"",null,0,""]
[1,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$4:$P$10,9,FALSE)","v":"Naturwissenschaften"},null,null,null,null,15,null,15,null,null,null,null,15,null,15,0,15,15,null,"",null,"",null,15,null,15,null,2,""]
[1,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$4:$P$10,10,FALSE)","v":"Informatik"},null,null,null,null,4,null,4,null,null,null,null,4,null,4,0,4,4,null,"",null,"",null,4,null,4,null,2,""]
[{"$f":"IF(OR(C22=\"-\",VLOOKUP(C22,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":1},null,"Aspekte der Biologie",null,null,null,null,3,null,5,null,null,null,null,4,null,4,0,4,4,null,"",null,"",null,3,null,5,null,2,""]
[{"$f":"IF(OR(C23=\"-\",VLOOKUP(C23,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":0},null,"Musik*",null,null,null,null,1,null,6,null,null,null,null,4,null,"",0,{"$error":"#DIV/0!"},3.5,null,"",null,"",null,"",null,"",null,0,""]
[{"$f":"IF(OR(C24=\"-\",VLOOKUP(C24,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":0},null,"-",null,null,null,null,null,null,null,null,null,null,null,"",null,"",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",null,"",null,"",null,"",null,0,""]
[1,null,"Fachreferat",null,null,null,null,4,null,null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",H25)","v":4},null,4,null,null,{"$f":"IF(A25=0,AVERAGE(D25:J25),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD24)","v":25},""]
[1,null,"Fachpraktische Ausbildung",5,null,7,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(S26),\"\",IF(S26<1,0,ROUND(S26,0)))","v":6},null,6,null,{"$f":"AVERAGE(D26:F26)","v":6},"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"* nicht einbringungsfähig","Streichungen überprüfen",null,null,null,null,null,null,null,null,{"$f":"AF5","v":2}]
[null,null,null,{"$f":"IF(AE5>=3,\"Zur Prüfung nicht zugelassen\",\"\")","v":""}]
[null,null,"Punktezahl Prüfungen (dreifach)",{"$f":"3*SUM(N8:N14)","v":51},null,"Anzahl:",null,{"$f":"U46","v":4},null,null,null,"HJE","GE","PE",null,null,null,"Punkte","Anzahl HJE","Anzahl GE","Anzahl PE"]
[null,null,"Punktezahl weiterer 25 HJE",{"$f":"SUM(V7:AC24)","v":179},null," Anzahl:",null,{"$f":"S46","v":25},null,"Anzahl 0:",null,{"$f":"S30","v":0},{"$f":"T30","v":0},{"$f":"U30","v":0},null,null,null,0,{"$f":"COUNTIF($V$7:$AC$24,R30)","v":0},{"$f":"COUNTIF($Q$7:$Q$26,R30)","v":0},{"$f":"COUNTIF($N$8:$N$14,R30)","v":0}]
[null,null,"Punktezahl Fachreferat",{"$f":"H25","v":4},null,null,null,null,null,"Anzahl 1:",null,{"$f":"S31","v":0},0,0,null,null,null,1,0,{"$f":"COUNTIF($Q$7:$Q$26,R31)","v":0},0]
[null,null,"Punktezahl FPA",{"$f":"D26+F26","v":12},null,null,null,null,null,"Anzahl 2:",null,0,0,0,null,null,null,2,0,0,0]
[null,null,"Gesamt:",{"$f":"SUM(D29:D32)","v":246},null,null,null,null,null,"Anzahl 3:",null,3,0,2,null,null,null,3,3,0,2]
[null,null,"Durchschnittsnote:",{"$f":"IF(D35=\"bestanden\",INT(F34*10)/10,\"\")","v":3.6},null,{"$f":"17/3-5*D33/600","v":3.6166666666666671},null,null,null,"Anzahl 4:",null,5,5,1,null,null,null,4,5,5,1]
[null,null,"Fachabitur:",{"$f":"IF(AND(G38+G39=2,M27<4),\"bestanden\",\"nicht bestanden\")","v":"bestanden"},null,null,null,null,null,"Anzahl 5:",null,3,2,0,null,null,null,5,3,2,0]
[null,null,null,null,null,null,null,null,null,"< 4",null,{"$f":"SUM(L30:L33)","v":3},{"$f":"SUM(M30:M33)","v":0},{"$f":"SUM(N30:N33)","v":2},null,null,null,6,0,2,0]
[null,null,"Überprüfung nach § 35 (9):",null,null,null,null,null,null,"< 4 (gew.):",null,{"$f":"2*L30+L31+L32+L33","v":3},{"$f":"2*M30+M31+M32+M33","v":0},{"$f":"2*N30+N31+N32+N33","v":2},null,null,null,7,4,1,1]
[null,null,"Prüfungsergebnisse",{"$f":"IF(AND(N37<3,U46=4),\"erfüllt\",\"nicht erfüllt\")","v":"erfüllt"},null,null,{"$f":"IF(D38=\"erfüllt\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,8,3,1,0]
[null,null,"Gesamtergebnisse",{"$f":"IF(H30=25,IF(OR((M37=0),AND(M37=1,D33>=200),AND(M37=2,D33>=240)),\"erfüllt\",\"nicht erfüllt\"))","v":"erfüllt"},null,null,{"$f":"IF(D39=\"erfüllt\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,9,2,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2,0,0]
[null,null,null,null,{"$f":"COUNTIF(D38:F40,\"nicht erfüllt\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,11,0,0,0]
[null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0]
[null,null,{"$f":"Hinweise!AG2","v":"Version 22.02.22"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0]
[null,null,"© H. Müller | T. Pickel (VBA) | M. Thoma (Gestaltung)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,3,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S30:S45)","v":25},{"$f":"SUM(T30:T45)","v":14},{"$f":"SUM(U30:U45)","v":4}]

{"sheet":"BOS 12","index":4,"n_rows":46,"n_cols":39,"rows_kept":46,"cut":false,"hidden":false,"merged":[[9,35,9,36],[11,34,11,38],[1,35,1,36],[2,35,2,36],[3,35,3,36],[4,35,4,36],[5,35,5,36],[6,35,6,37],[7,35,7,38],[8,35,8,36],[4,3,4,10],[1,2,1,3],[1,8,1,14],[2,9,2,13],[3,3,3,5],[3,7,3,14],[35,9,35,10],[24,7,24,10],[26,3,26,10],[27,3,27,10],[28,3,28,4],[28,5,28,6],[29,3,29,4],[29,5,29,6],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,5],[36,3,36,5],[37,3,37,5],[38,3,38,5],[39,3,39,5],[41,2,41,14]]}
[]
[null,null,"Abschlussprüfung BOS 12",null,null,null,null,"Name: _____________________________","Hans Streichinger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punktezahl Prüfungen (zweifach)",{"$f":"D29","v":46},null,"Anzahl:",{"$f":"H29","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2022-12-22T12:27:08.450"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punktezahl weiterer 17 HJE",{"$f":"D30","v":102},null," Anzahl:",{"$f":"H30","v":17}]
[null,null,"Ausbildungsrichtung:  ","Technik",null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punktezahl Fachreferat",4]
[null,null,null,"Zu streichende HJE mit x markieren!",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(R7:R24)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE7:AE25)","v":0},{"$f":"COUNT(AF8:AF14)","v":3},null,null,"Gesamt:",{"$f":"SUM(AJ1:AJ4)","v":152}]
["EB",null,null,null,null,null,null,"12/1","x","12/2","x","sP","mP","PE","GE",null,"GE(eingebracht)","Str.","GE",null,null,"11/1","11/1 einbr","11/2","11/2 einbr","12/1","12/1 einbr","12/2","12/2 einbr","Anzahl","Anzahl<4 Nichtprüfung","Anz. mdl. Prfg",null,null,"Durchschnittsnote:",{"$f":"D34","v":""},null,{"$f":"17/3-5*AJ5/390","v":3.7179487179487181}]
[1,null,"Religionslehre/Ethik",null,null,null,null,5,null,5,null,null,null,null,{"$f":"IF(AND(ISERROR(S7),ISERROR(T7)),\"\",IF(ISNUMBER(S7),ROUND(S7,0),ROUND(T7,0)))","v":5},null,{"$f":"IF(A7=1,O7,\"\")","v":5},{"$f":"COUNTIF(D7:K7,\"x\")","v":0},{"$f":"IF(AVERAGE(V7:AB7)<1,0,AVERAGE(V7:AB7))","v":5},{"$f":"IF(AVERAGE(D7:J7)<1,0,AVERAGE(D7:J7))","v":5},null,{"$f":"IF(AND(ISNUMBER(D7),E7=\"\",$A7=1),D7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(F7),G7=\"\",$A7=1),F7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(H7),I7=\"\",$A7=1),H7,\"\")","v":5},null,{"$f":"IF(AND(ISNUMBER(J7),K7=\"\",$A7=1),J7,\"\")","v":5},null,{"$f":"COUNT(V7:AB7)","v":2},{"$f":"IF(Q7=\"\",\"\",IF(Q7<4,IF(Q7=0,2,1),\"\"))","v":""},null,null,null,"Fachabitur:",{"$f":"D35","v":"nicht bestanden"}]
[1,null,"Deutsch",null,null,null,null,4,"x",4,null,3,null,{"$f":"IF(ISBLANK(L8),\"\",IF(ISBLANK(M8),L8,IF((L8*2+M8)/3<1,0,ROUND((L8*2+M8)/3,0))))","v":3},{"$f":"IF(ISBLANK(L8),\"\",IF(AND(ISERROR(S8),ISERROR(T8)),\"\",IF(ISNUMBER(S8),ROUND(S8,0),ROUND(T8,0))))","v":3},null,3,{"$f":"COUNTIF(D8:K8,\"x\")","v":1},{"$f":"IF((2*N8+SUM(V8:AB8))/(AD8+2)<1,0,(2*N8+SUM(V8:AB8))/(AD8+2))","v":3.3333333333333335},{"$f":"AVERAGE(D8:J8)","v":4},null,"",null,"",null,"",null,4,null,{"$f":"COUNT(V8:AB8)","v":1},null,{"$f":"IF(M8=\"\",\"\",M8)","v":""},null,null,"Überprüfung nach § 35 (9):"]
[1,null,"Englisch",null,null,null,null,4,"x",4,null,3,3,{"$f":"IF(ISBLANK(L9),\"\",IF(ISBLANK(M9),L9,IF((L9*2+M9)/3<1,0,ROUND((L9*2+M9)/3,0))))","v":3},{"$f":"IF(ISBLANK(L9),\"\",IF(AND(ISERROR(S9),ISERROR(T9)),\"\",IF(ISNUMBER(S9),ROUND(S9,0),ROUND(T9,0))))","v":3},null,3,1,{"$f":"IF((2*N9+SUM(V9:AB9))/(AD9+2)<1,0,(2*N9+SUM(V9:AB9))/(AD9+2))","v":3.3333333333333335},4,null,"",null,"",null,"",null,4,null,1,null,{"$f":"IF(M9=\"\",\"\",M9)","v":3},null,null,{"$f":"C38","v":"Prüfungsergebnisse"},{"$f":"D38","v":"erfüllt"},null,"<4",{"$f":"N37","v":2}]
[1,null,"Mathematik",null,null,null,null,4,null,4,null,10,8,{"$f":"IF(ISBLANK(L10),\"\",IF(ISBLANK(M10),L10,IF((L10*2+M10)/3<1,0,ROUND((L10*2+M10)/3,0))))","v":9},7,null,7,0,6.5,4,null,"",null,"",null,4,null,4,null,2,null,8,null,null,{"$f":"C39","v":"Gesamtergebnisse"},{"$f":"D39","v":"nicht erfüllt"},null,"<4",{"$f":"M37","v":2}]
[]
[1,null,"Geschichte, Politik u. Gesellsch.",null,null,null,null,4,"x",4,null,null,null,null,{"$f":"IF(AND(ISERROR(S12),ISERROR(T12)),\"\",IF(ISNUMBER(S12),ROUND(S12,0),ROUND(T12,0)))","v":4},null,4,1,{"$f":"IF(AVERAGE(V12:AB12)<1,0,AVERAGE(V12:AB12))","v":4},{"$f":"IF(AVERAGE(D12:J12)<1,0,AVERAGE(D12:J12))","v":4},null,"",null,"",null,"",null,4,null,1,{"$f":"IF(Q12=\"\",\"\",IF(Q12<4,IF(Q12=0,2,1),\"\"))","v":""},null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!"]
[]
[{"$f":"IF(C14=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$14:$N$20,3,FALSE)","v":"Physik"},null,null,null,null,4,null,4,null,10,4,{"$f":"IF(ISBLANK(L14),\"\",IF(ISBLANK(M14),L14,IF((L14*2+M14)/3<1,0,ROUND((L14*2+M14)/3,0))))","v":8},{"$f":"IF(ISBLANK(L14),\"\",IF(AND(ISERROR(S14),ISERROR(T14)),\"\",IF(ISNUMBER(S14),ROUND(S14,0),ROUND(T14,0))))","v":6},null,6,0,{"$f":"IF((2*N14+SUM(V14:AB14))/(AD14+2)<1,0,(2*N14+SUM(V14:AB14))/(AD14+2))","v":6},4,null,"",null,"",null,4,null,4,null,2,null,4]
[{"$f":"IF(C15=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$14:$N$20,4,FALSE)","v":"Technologie"},null,null,null,null,5,null,13,null,null,null,null,9,null,9,0,{"$f":"IF(AVERAGE(V15:AB15)<1,0,AVERAGE(V15:AB15))","v":9},{"$f":"IF(AVERAGE(D15:J15)<1,0,AVERAGE(D15:J15))","v":9},null,"",null,"",null,5,null,13,null,2,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$14:$N$20,7,FALSE)","v":"Chemie"},null,null,null,null,8,null,12,null,null,null,null,10,null,10,0,{"$f":"IF(AVERAGE(V20:AB20)<1,0,AVERAGE(V20:AB20))","v":10},{"$f":"IF(AVERAGE(D20:J20)<1,0,AVERAGE(D20:J20))","v":10},null,"",null,"",null,8,null,12,null,2,""]
[1,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$14:$N$20,8,FALSE)","v":"Mathe Additum"},null,null,null,null,5,null,11,null,null,null,null,8,null,8,0,{"$f":"IF(AVERAGE(V21:AB21)<1,0,AVERAGE(V21:AB21))","v":8},{"$f":"IF(AVERAGE(D21:J21)<1,0,AVERAGE(D21:J21))","v":8},null,"",null,"",null,5,null,11,null,2,""]
[{"$f":"IF(OR(C22=\"-\",VLOOKUP(C22,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":1},null,"Aspekte der Biologie",null,null,null,null,5,null,5,null,null,null,null,5,null,5,0,5,5,null,"",null,"",null,5,null,5,null,2,""]
[{"$f":"IF(OR(C23=\"-\",VLOOKUP(C23,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":0},null,"-",null,null,null,null,null,null,null,null,null,null,null,"",null,"",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",null,"",null,"",null,"",null,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,null,null,null,null,null,null,""]
[1,null,"Fachreferat",null,null,null,null,4,null,null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",H25)","v":4},null,4,null,null,{"$f":"IF(A25=0,AVERAGE(D25:J25),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD24)","v":17},""]
[]
[null,null,"* nicht einbringungsfähig","Streichungen überprüfen",null,null,null,null,null,null,null,null,{"$f":"AF5","v":3}]
[null,null,null,{"$f":"IF(AE5>2,\"Zur Prüfung nicht zugelassen\",\"\")","v":""}]
[null,null,"Punktezahl Prüfungen (zweifach)",{"$f":"2*SUM(N8:N14)","v":46},null,"Anzahl:",null,{"$f":"U46","v":4},null,null,null,"HJE","GE","PE",null,null,null,"Punkte","Anzahl HJE","Anzahl GE","Anzahl PE"]
[null,null,"Punktezahl weiterer 17 HJE",{"$f":"SUM(V7:AC24)","v":102},null," Anzahl:",null,{"$f":"S46","v":17},null,"Anzahl 0:",null,{"$f":"S30","v":0},{"$f":"T30","v":0},{"$f":"U30","v":0},null,null,null,0,{"$f":"COUNTIF($V$7:$AC$24,R30)","v":0},{"$f":"COUNTIF($Q$7:$Q$26,R30)","v":0},{"$f":"COUNTIF($N$8:$N$14,R30)","v":0}]
[null,null,"Punktezahl Fachreferat",{"$f":"H25","v":4},null,null,null,null,null,"Anzahl 1:",null,{"$f":"S31","v":0},0,0,null,null,null,1,0,{"$f":"COUNTIF($Q$7:$Q$26,R31)","v":0},0]
[null,null,null,null,null,null,null,null,null,"Anzahl 2:",null,0,0,0,null,null,null,2,0,0,0]
[null,null,"Gesamt:",{"$f":"SUM(D29:D32)","v":152},null,null,null,null,null,"Anzahl 3:",null,0,2,2,null,null,null,3,0,2,2]
[null,null,"Durchschnittsnote:",{"$f":"IF(D35=\"bestanden\",INT(F34*10)/10,\"\")","v":""},null,{"$f":"17/3-5*D33/390","v":3.7179487179487181},null,null,null,"Anzahl 4:",null,7,2,0,null,null,null,4,7,2,0]
[null,null,"Fachabitur:",{"$f":"IF(AND(E41=0,H30=17,U46=4,M27<4),\"bestanden\",\"nicht bestanden\")","v":"nicht bestanden"},null,null,null,null,null,"Anzahl 5:",null,6,2,0,null,null,null,5,6,2,0]
[null,null,null,null,null,null,null,null,null,"< 4",null,{"$f":"SUM(L30:L33)","v":0},{"$f":"SUM(M30:M33)","v":2},{"$f":"SUM(N30:N33)","v":2},null,null,null,6,0,1,0]
[null,null,"Überprüfung nach § 35 (9)",null,null,null,null,null,null,"< 4 (gew.):",null,{"$f":"2*L30+L31+L32+L33","v":0},{"$f":"2*M30+M31+M32+M33","v":2},{"$f":"2*N30+N31+N32+N33","v":2},null,null,null,7,0,1,0]
[null,null,"Prüfungsergebnisse",{"$f":"IF(AND(N37<3,U46=4),\"erfüllt\",\"nicht erfüllt\")","v":"erfüllt"},null,null,null,null,null,null,null,null,null,null,null,null,null,8,1,1,1]
[null,null,"Gesamtergebnisse",{"$f":"IF(H30=17,IF(OR((M37=0),AND(M37=1,D33>=130),AND(M37=2,D33>=156)),\"erfüllt\",\"nicht erfüllt\"))","v":"nicht erfüllt"},null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,1,0]
[null,null,null,null,{"$f":"COUNTIF(D38:F40,\"nicht erfüllt\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,11,1,0,0]
[null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,1,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,1,0,0]
[null,null,{"$f":"'FOS 12'!C44","v":"Version 22.02.22"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0]
[null,null,"© H. Müller | T. Pickel (VBA) | M. Thoma (Gestaltung)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S30:S45)","v":17},{"$f":"SUM(T30:T45)","v":11},{"$f":"SUM(U30:U45)","v":4}]

{"sheet":"FOSBOS 13-1","index":5,"n_rows":46,"n_cols":39,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,3,3,5],[3,7,3,14],[3,35,3,36],[8,35,8,36],[1,8,1,14],[1,35,1,36],[2,9,2,13],[2,35,2,36],[4,3,4,10],[4,35,4,36],[5,35,5,36],[6,35,6,37],[7,35,7,38],[33,3,33,4],[9,35,9,36],[11,34,11,38],[24,7,24,10],[26,3,26,10],[27,3,27,10],[28,3,28,4],[28,5,28,6],[29,3,29,4],[29,5,29,6],[30,3,30,4],[31,3,31,4],[32,3,32,4],[41,2,41,14],[34,3,34,5],[35,9,35,10],[36,3,36,5],[37,3,37,5],[38,3,38,5],[39,3,39,5]]}
[]
[null,null,"Abschlussprüfung ABITUR",null,null,null,null,"Name: _____________________________","Hans Streichinger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C29","v":"Punktezahl Prüfungen (2-fach)"},{"$f":"D29","v":78},null,"Anzahl:",{"$f":"H29","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2022-12-22T12:27:08.450"},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":"C30","v":"Punktezahl weiterer 16 HJE"},{"$f":"D30","v":80},null," Anzahl:",{"$f":"H30","v":16}]
[null,null,"Ausbildungsrichtung:  ","Sozialwesen",null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punktezahl Seminararbeit (2-fach)",2]
[null,null,null,"Zu streichende HJE mit x markieren!",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(R7:R24)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE7:AE25)","v":2},{"$f":"COUNT(AF8:AF14)","v":3},null,null,"Gesamt:",{"$f":"SUM(AJ1:AJ4)","v":160}]
["EB",null,null,"12/1",null,"12/2",null,"13/1","x","13/2","x","sP","mP","PE","GE",null,"GE(eingebracht)","Str.","GE",null,"Sprache",{"$f":"D6","v":"12/1"},null,{"$f":"F6","v":"12/2"},null,{"$f":"H6","v":"13/1"},null,{"$f":"J6","v":"13/2"},null,"Anzahl","Anzahl<4 Nichtprüfung","Anz. mdl. Prfg",null,null,"Durchschnittsnote:",{"$f":"D34","v":3.6},null,{"$f":"17/3-5*AJ5/390","v":3.6153846153846159}]
[1,null,"Religionslehre/Ethik",null,null,null,null,4,null,3,"x",null,null,null,{"$f":"IF(AND(ISERROR(S7),ISERROR(T7)),\"\",IF(ISNUMBER(S7),ROUND(S7,0),ROUND(T7,0)))","v":4},null,{"$f":"IF(A7=1,O7,\"\")","v":4},{"$f":"COUNTIF(D7:K7,\"x\")","v":1},{"$f":"IF(AVERAGE(V7:AB7)<1,0,AVERAGE(V7:AB7))","v":4},{"$f":"IF(AVERAGE(D7:J7)<1,0,AVERAGE(D7:J7))","v":3.5},null,{"$f":"IF(AND(ISNUMBER(D7),E7=\"\",$A7=1),D7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(F7),G7=\"\",$A7=1),F7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(H7),I7=\"\",$A7=1),H7,\"\")","v":4},null,{"$f":"IF(AND(ISNUMBER(J7),K7=\"\",$A7=1),J7,\"\")","v":""},null,{"$f":"COUNT(V7:AB7)","v":1},{"$f":"IF(Q7=\"\",\"\",IF(Q7<4,IF(Q7=0,2,1),\"\"))","v":""},null,null,null,{"$f":"C35","v":"Abitur (allgemein)"},{"$f":"D35","v":"bestanden"}]
[1,null,"Deutsch",null,null,null,null,4,null,5,null,10,null,{"$f":"IF(ISBLANK(L8),\"\",IF(ISBLANK(M8),L8,IF((L8*2+M8)/3<1,0,ROUND((L8*2+M8)/3,0))))","v":10},{"$f":"IF(ISBLANK(L8),\"\",IF(AND(ISERROR(S8),ISERROR(T8)),\"\",IF(ISNUMBER(S8),ROUND(S8,0),ROUND(T8,0))))","v":7},null,7,{"$f":"COUNTIF(D8:K8,\"x\")","v":0},{"$f":"IF((2*N8+SUM(V8:AB8))/(AD8+2)<1,0,(2*N8+SUM(V8:AB8))/(AD8+2))","v":7.25},{"$f":"AVERAGE(D8:J8)","v":4.5},null,"",null,"",null,4,null,5,null,{"$f":"COUNT(V8:AB8)","v":2},null,{"$f":"IF(M8=\"\",\"\",M8)","v":""},null,null,"Überprüfung nach § 35 (9):"]
[1,null,"Englisch",null,null,null,null,4,null,4,null,12,9,{"$f":"IF(ISBLANK(L9),\"\",IF(ISBLANK(M9),L9,IF((L9*2+M9)/3<1,0,ROUND((L9*2+M9)/3,0))))","v":11},{"$f":"IF(ISBLANK(L9),\"\",IF(AND(ISERROR(S9),ISERROR(T9)),\"\",IF(ISNUMBER(S9),ROUND(S9,0),ROUND(T9,0))))","v":8},null,8,0,{"$f":"IF((2*N9+SUM(V9:AB9))/(AD9+2)<1,0,(2*N9+SUM(V9:AB9))/(AD9+2))","v":7.5},4,null,"",null,"",null,4,null,4,null,2,null,{"$f":"IF(M9=\"\",\"\",M9)","v":9},null,null,{"$f":"C38","v":"Prüfungsergebnisse"},{"$f":"D38","v":"erfüllt"},null,"<4",{"$f":"N37","v":0}]
[1,null,"Mathematik",null,null,null,null,4,null,4,null,10,10,{"$f":"IF(ISBLANK(L10),\"\",IF(ISBLANK(M10),L10,IF((L10*2+M10)/3<1,0,ROUND((L10*2+M10)/3,0))))","v":10},7,null,7,0,7,4,null,"",null,"",null,4,null,4,null,2,null,10,null,null,{"$f":"C39","v":"Gesamtergebnisse"},{"$f":"D39","v":"erfüllt"},null,"<4",{"$f":"M37","v":2}]
[]
[1,null,"Geschichte, Politik und Gesellschaft",null,null,null,null,4,null,5,null,null,null,null,{"$f":"IF(AND(ISERROR(S12),ISERROR(T12)),\"\",IF(ISNUMBER(S12),ROUND(S12,0),ROUND(T12,0)))","v":5},null,5,0,{"$f":"IF(AVERAGE(V12:AB12)<1,0,AVERAGE(V12:AB12))","v":4.5},{"$f":"IF(AVERAGE(D12:J12)<1,0,AVERAGE(D12:J12))","v":4.5},null,"",null,"",null,4,null,5,null,2,{"$f":"IF(Q12=\"\",\"\",IF(Q12<4,IF(Q12=0,2,1),\"\"))","v":""},null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!"]
[]
[{"$f":"IF(C14=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,3,FALSE)","v":"Päd./Psy."},null,null,null,null,4,null,4,null,10,3,{"$f":"IF(ISBLANK(L14),\"\",IF(ISBLANK(M14),L14,IF((L14*2+M14)/3<1,0,ROUND((L14*2+M14)/3,0))))","v":8},{"$f":"IF(ISBLANK(L14),\"\",IF(AND(ISERROR(S14),ISERROR(T14)),\"\",IF(ISNUMBER(S14),ROUND(S14,0),ROUND(T14,0))))","v":6},null,6,0,{"$f":"IF((2*N14+SUM(V14:AB14))/(AD14+2)<1,0,(2*N14+SUM(V14:AB14))/(AD14+2))","v":6},4,null,"",null,"",null,4,null,4,null,2,null,3]
[{"$f":"IF(C15=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,4,FALSE)","v":"Sozialwirtschaft und Recht"},null,null,null,null,3,null,3,null,null,null,null,3,null,3,0,{"$f":"IF(AVERAGE(V15:AB15)<1,0,AVERAGE(V15:AB15))","v":3},{"$f":"IF(AVERAGE(D15:J15)<1,0,AVERAGE(D15:J15))","v":3},{"$f":"IF(AND((_xlfn.NUMBERVALUE(AB15)>=4),(O15>=4),(AD15=2),(C15=\"Franz./Span.\")),1,0)","v":0},"",null,"",null,3,null,3,null,2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,5,FALSE)","v":"Biologie"},null,null,null,null,1,"x",8,null,null,null,null,8,null,8,1,{"$f":"IF(AVERAGE(V20:AB20)<1,0,AVERAGE(V20:AB20))","v":8},{"$f":"IF(AVERAGE(D20:J20)<1,0,AVERAGE(D20:J20))","v":4.5},null,"",null,"",null,"",null,8,null,1,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR(C22=\"-\",VLOOKUP(C22,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":1},null,"Spanisch",null,null,null,null,10,null,10,null,null,null,null,10,null,10,0,{"$f":"IF(AVERAGE(V22:AB22)<1,0,AVERAGE(V22:AB22))","v":10},{"$f":"IF(AVERAGE(D22:J22)<1,0,AVERAGE(D22:J22))","v":10},{"$f":"IF(AND((_xlfn.NUMBERVALUE(AB22)>=4),(O22>=4),(AD22=2),(OR(C22=\"Spanisch (fortgeführt)\",C22=\"Spanisch\",C22=\"Französisch\",C22=\"Französisch (fortgeführt)\"))),1,0)","v":1},"",null,"",null,10,null,10,null,2,""]
[{"$f":"IF(OR(C23=\"-\",VLOOKUP(C23,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":0},null,"-",null,null,null,null,null,null,null,null,null,null,null,"",null,"",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",null,"",null,"",null,"",null,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,null,null,null,null,null,null,""]
[1,null,"Seminararbeit",null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",H25)","v":1},null,1,null,null,{"$f":"IF(A25=0,AVERAGE(D25:J25),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD24)","v":16},1]
[]
[null,null,"* nicht einbringungsfähig","Streichungen überprüfen",null,null,null,null,null,null,null,null,{"$f":"AF5","v":3}]
[null,null,null,{"$f":"IF(OR(H25=0,AE5>2),\"Zur Prüfung nicht zugelassen\",\"\")","v":""}]
[null,null,"Punktezahl Prüfungen (2-fach)",{"$f":"2*SUM(N8:N14)","v":78},null,"Anzahl:",null,{"$f":"U46","v":4},null,null,null,"HJE","GE","PE",null,null,null,"Punkte","Anzahl HJE","Anzahl GE","Anzahl PE"]
[null,null,"Punktezahl weiterer 16 HJE",{"$f":"SUM(V7:AC24)","v":80},null," Anzahl:",null,{"$f":"S46","v":16},null,"Anzahl 0:",null,{"$f":"S30","v":0},{"$f":"T30","v":0},{"$f":"U30","v":0},null,null,null,0,{"$f":"COUNTIF($V$7:$AC$24,R30)","v":0},{"$f":"COUNTIF($Q$7:$Q$26,R30)","v":0},{"$f":"COUNTIF($N$8:$N$14,R30)","v":0}]
[null,null,"Punktezahl Seminararbeit (2-fach)",{"$f":"H25*2","v":2},null,null,null,null,null,"Anzahl 1:",null,{"$f":"S31","v":0},1,0,null,null,null,1,0,{"$f":"COUNTIF($Q$7:$Q$26,R31)","v":1},0]
[null,null,null,null,null,null,null,null,null,"Anzahl 2:",null,0,0,0,null,null,null,2,0,0,0]
[null,null,"Gesamt:",{"$f":"SUM(D29:D32)","v":160},null,"von 390",null,null,null,"Anzahl 3:",null,2,1,0,null,null,null,3,2,1,0]
[null,null,"Durchschnittsnote:",{"$f":"IF(D35=\"bestanden\",INT(F34*10)/10,\"\")","v":3.6},null,{"$f":"17/3-5*D33/390","v":3.6153846153846159},null,null,null,"Anzahl 4:",null,9,1,0,null,null,null,4,9,1,0]
[null,null,{"$f":"IF(SUM(U15+U22)>0,\"Abitur (allgemein)\",\"Abitur (fachgebunden)\")","v":"Abitur (allgemein)"},{"$f":"IF(AND(E41=0,H30=16,U46=4,H25>0,M27<4),\"bestanden\",\"nicht bestanden\")","v":"bestanden"},null,null,null,null,null,"Anzahl 5:",null,2,1,0,null,null,null,5,2,1,0]
[null,null,null,null,null,null,null,null,null,"< 4",null,{"$f":"SUM(L30:L33)","v":2},{"$f":"SUM(M30:M33)","v":2},{"$f":"SUM(N30:N33)","v":0},null,null,null,6,0,1,0]
[null,null,"Überprüfung nach § 35 (9)",null,null,null,null,null,null,"< 4 (gew.):",null,{"$f":"2*L30+L31+L32+L33","v":2},{"$f":"2*M30+M31+M32+M33","v":2},{"$f":"2*N30+N31+N32+N33","v":0},null,null,null,7,0,2,0]
[null,null,"Prüfungsergebnisse",{"$f":"IF(AND(N30=0,N37<3,U46=4),\"erfüllt\",\"nicht erfüllt\")","v":"erfüllt"},null,null,null,null,null,null,null,null,null,null,null,null,null,8,1,2,1]
[null,null,"Gesamtergebnisse",{"$f":"IF(H30=16,IF(OR((M37=0),AND(M37=1,D33>=130),AND(M37=2,D33>=156)),\"erfüllt\",\"nicht erfüllt\"))","v":"erfüllt"},null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2,1,2]
[null,null,null,null,{"$f":"COUNTIF(D38:F40,\"nicht erfüllt\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,11,0,0,1]
[null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0]
[null,null,{"$f":"'FOS 12'!C44","v":"Version 22.02.22"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0]
[null,null,"© H. Müller | T. Pickel (VBA) | M. Thoma (Gestaltung)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S30:S45)","v":16},{"$f":"SUM(T30:T45)","v":10},{"$f":"SUM(U30:U45)","v":4}]

{"sheet":"FOSBOS 13-2","index":6,"n_rows":48,"n_cols":39,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,35,0,36],[3,35,3,36],[2,37,2,38],[3,37,3,38],[3,3,3,5],[3,7,3,14],[2,35,2,36],[8,35,8,36],[1,8,1,14],[1,35,1,36],[2,9,2,13],[4,3,4,10],[4,35,4,36],[5,35,5,36],[6,35,6,37],[7,35,7,38],[35,3,35,4],[9,35,9,36],[11,34,11,38],[24,7,24,10],[26,3,26,10],[27,3,27,10],[30,3,30,4],[30,5,30,6],[31,3,31,4],[31,5,31,6],[32,3,32,4],[33,3,33,4],[34,3,34,4],[43,2,43,14],[36,3,36,5],[37,9,37,10],[38,3,38,5],[39,3,39,5],[40,3,40,5],[41,3,41,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C31","v":"Punktezahl Prüfungen (2-fach)"},{"$f":"D31","v":52},null,"Anzahl:",{"$f":"H31","v":4}]
[null,null,"Abschlussprüfung ABITUR",null,null,null,null,"Name: _____________________________","Hans Streichinger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C32","v":"Punktezahl weiterer 16 HJE"},{"$f":"D32+D34","v":64},null," Anzahl:",{"$f":"H32","v":18}]
[null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2022-12-22T12:27:08.450"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punktezahl Seminararbeit (2-fach)",{"$f":"D33","v":8}]
[null,null,"Ausbildungsrichtung:  ","Technik",null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zweite Fremdsprache:",{"$f":"D34","v":2}]
[null,null,null,"Zu streichende HJE mit x markieren!",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(R7:R24)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE7:AE25)","v":0},{"$f":"COUNT(AF8:AF14)","v":2},null,null,"Gesamt:",{"$f":"D35","v":124},null,"von 420"]
["EB",null,null,"12/1",null,"12/2",null,"13/1","x","13/2","x","sP","mP","PE","GE",null,"GE(eingebracht)","Str.","GE",null,"Sprache","12/1",null,"12/2",null,"13/1",null,"13/2",null,"Anzahl","Anzahl<4 Nichtprüfung","Anz. mdl. Prfg",null,null,"Durchschnittsnote:",{"$f":"D36","v":4.0999999999999996},null,{"$f":"17/3-5*AJ5/390","v":4.0769230769230775}]
[1,null,"Religionslehre/Ethik",null,null,null,null,4,null,3,null,null,null,null,{"$f":"IF(AND(ISERROR(S7),ISERROR(T7)),\"\",IF(ISNUMBER(S7),ROUND(S7,0),ROUND(T7,0)))","v":4},null,{"$f":"IF(A7=1,O7,\"\")","v":4},{"$f":"COUNTIF(D7:K7,\"x\")","v":0},{"$f":"IF(AVERAGE(V7:AB7)<1,0,AVERAGE(V7:AB7))","v":3.5},{"$f":"IF(AVERAGE(D7:J7)<1,0,AVERAGE(D7:J7))","v":3.5},null,{"$f":"IF(AND(ISNUMBER(D7),E7=\"\",$A7=1),D7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(F7),G7=\"\",$A7=1),F7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(H7),I7=\"\",$A7=1),H7,\"\")","v":4},null,{"$f":"IF(AND(ISNUMBER(J7),K7=\"\",$A7=1),J7,\"\")","v":3},null,{"$f":"COUNT(V7:AB7)","v":2},{"$f":"IF(Q7=\"\",\"\",IF(Q7<4,IF(Q7=0,2,1),\"\"))","v":""},null,null,null,{"$f":"C37","v":"Abitur (fachgebunden)"},{"$f":"D37","v":"bestanden"}]
[1,null,"Deutsch",null,null,null,null,4,"x",5,null,6,null,{"$f":"IF(ISBLANK(L8),\"\",IF(ISBLANK(M8),L8,IF((L8*2+M8)/3<1,0,ROUND((L8*2+M8)/3,0))))","v":6},{"$f":"IF(ISBLANK(L8),\"\",IF(AND(ISERROR(S8),ISERROR(T8)),\"\",IF(ISNUMBER(S8),ROUND(S8,0),ROUND(T8,0))))","v":6},null,6,{"$f":"COUNTIF(D8:K8,\"x\")","v":1},{"$f":"IF((2*N8+SUM(V8:AB8))/(AD8+2)<1,0,(2*N8+SUM(V8:AB8))/(AD8+2))","v":5.666666666666667},{"$f":"AVERAGE(D8:J8)","v":4.5},null,"",null,"",null,"",null,5,null,{"$f":"COUNT(V8:AB8)","v":1},null,{"$f":"IF(M8=\"\",\"\",M8)","v":""},null,null,"Überprüfung nach § 35 (9):"]
[1,null,"Englisch",null,null,null,null,4,null,4,null,5,4,{"$f":"IF(ISBLANK(L9),\"\",IF(ISBLANK(M9),L9,IF((L9*2+M9)/3<1,0,ROUND((L9*2+M9)/3,0))))","v":5},{"$f":"IF(ISBLANK(L9),\"\",IF(AND(ISERROR(S9),ISERROR(T9)),\"\",IF(ISNUMBER(S9),ROUND(S9,0),ROUND(T9,0))))","v":5},null,5,0,{"$f":"IF((2*N9+SUM(V9:AB9))/(AD9+2)<1,0,(2*N9+SUM(V9:AB9))/(AD9+2))","v":4.5},4,null,"",null,"",null,4,null,4,null,2,null,{"$f":"IF(M9=\"\",\"\",M9)","v":4},null,null,{"$f":"C40","v":"Prüfungsergebnisse"},{"$f":"D40","v":"erfüllt"},null,"<4",{"$f":"N39","v":0}]
[1,null,"Mathematik",null,null,null,null,4,null,4,null,9,null,{"$f":"IF(ISBLANK(L10),\"\",IF(ISBLANK(M10),L10,IF((L10*2+M10)/3<1,0,ROUND((L10*2+M10)/3,0))))","v":9},7,null,7,0,6.5,4,null,"",null,"",null,4,null,4,null,2,null,"",null,null,{"$f":"C41","v":"Gesamtergebnisse"},{"$f":"D41","v":"erfüllt"},null,"<4",{"$f":"M39","v":0}]
[]
[1,null,"Geschichte, Politik und Gesellschaft",null,null,null,null,4,null,3,null,null,null,null,{"$f":"IF(AND(ISERROR(S12),ISERROR(T12)),\"\",IF(ISNUMBER(S12),ROUND(S12,0),ROUND(T12,0)))","v":4},null,4,0,{"$f":"IF(AVERAGE(V12:AB12)<1,0,AVERAGE(V12:AB12))","v":3.5},{"$f":"IF(AVERAGE(D12:J12)<1,0,AVERAGE(D12:J12))","v":3.5},null,"",null,"",null,4,null,3,null,2,{"$f":"IF(Q12=\"\",\"\",IF(Q12<4,IF(Q12=0,2,1),\"\"))","v":""},null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!"]
[]
[{"$f":"IF(C14=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,3,FALSE)","v":"Physik"},null,null,null,null,4,null,4,null,8,3,{"$f":"IF(ISBLANK(L14),\"\",IF(ISBLANK(M14),L14,IF((L14*2+M14)/3<1,0,ROUND((L14*2+M14)/3,0))))","v":6},{"$f":"IF(ISBLANK(L14),\"\",IF(AND(ISERROR(S14),ISERROR(T14)),\"\",IF(ISNUMBER(S14),ROUND(S14,0),ROUND(T14,0))))","v":5},null,5,0,{"$f":"IF((2*N14+SUM(V14:AB14))/(AD14+2)<1,0,(2*N14+SUM(V14:AB14))/(AD14+2))","v":5},4,null,"",null,"",null,4,null,4,null,2,null,3]
[{"$f":"IF(C15=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,4,FALSE)","v":"Technologie"},null,null,null,null,3,null,4,null,null,null,null,4,null,4,0,{"$f":"IF(AVERAGE(V15:AB15)<1,0,AVERAGE(V15:AB15))","v":3.5},{"$f":"IF(AVERAGE(D15:J15)<1,0,AVERAGE(D15:J15))","v":3.5},{"$f":"IF(AND((_xlfn.NUMBERVALUE(AB15)>=4),(O15>=4),(AD15=2),(C15=\"Franz./Span.\")),1,0)","v":0},"",null,"",null,3,null,4,null,2,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,5,FALSE)","v":"Chemie"},null,null,null,null,1,"x",4,null,null,null,null,4,null,4,1,{"$f":"IF(AVERAGE(V20:AB20)<1,0,AVERAGE(V20:AB20))","v":4},{"$f":"IF(AVERAGE(D20:J20)<1,0,AVERAGE(D20:J20))","v":2.5},null,"",null,"",null,"",null,4,null,1,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR(C22=\"-\",VLOOKUP(C22,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":1},null,"Informatik",null,null,null,null,4,null,4,null,null,null,null,4,null,4,0,{"$f":"IF(AVERAGE(V22:AB22)<1,0,AVERAGE(V22:AB22))","v":4},{"$f":"IF(AVERAGE(D22:J22)<1,0,AVERAGE(D22:J22))","v":4},{"$f":"IF(AND((_xlfn.NUMBERVALUE(AB22)>=4),(O22>=4),(AD22=2),(OR(C22=\"Spanisch (fortgeführt)\",C22=\"Französisch (fortgeführt)\"))),1,0)","v":0},"",null,"",null,4,null,4,null,2,""]
[{"$f":"IF(OR(C23=\"-\",VLOOKUP(C23,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":0},null,"-",null,null,null,null,null,null,null,null,null,null,null,"",null,"",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",null,"",null,"",null,"",null,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,null,null,null,null,null,null,""]
[1,null,"Seminararbeit",null,null,null,null,4,null,null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",H25)","v":4},null,4,null,null,{"$f":"IF(A25=0,AVERAGE(D25:J25),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD24)","v":16},""]
[]
[null,null,"* nicht einbringungsfähig","Streichungen überprüfen",null,null,null,null,null,null,null,null,{"$f":"AF5","v":2}]
[null,null,null,{"$f":"IF(OR(AE5>2,H25=0),\"Zur Prüfung nicht zugelassen\",\"\")","v":""}]
[1,null,"Franz./Span. (fortgeführt)",1,null,1,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISERROR(S29),ISERROR(T29)),\"\",IF(ISNUMBER(S29),ROUND(S29,0),ROUND(T29,0)))","v":1},null,{"$f":"IF(A29=1,O29,\"\")","v":1},{"$f":"COUNTIF(D29:K29,\"x\")","v":0},{"$f":"IF(AVERAGE(V29:AB29)<1,0,AVERAGE(V29:AB29))","v":1},{"$f":"IF(AVERAGE(D29:J29)<1,0,AVERAGE(D29:J29))","v":1},{"$f":"IF(AND((_xlfn.NUMBERVALUE(X29)>=4),(AD29=2),(O29>=4)),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(D29),E29=\"\",$A29=1),D29,\"\")","v":1},null,{"$f":"IF(AND(ISNUMBER(F29),G29=\"\",$A29=1),F29,\"\")","v":1},null,null,null,null,null,{"$f":"COUNT(V29:AB29)","v":2}]
[]
[null,null,"Punktezahl Prüfungen (2-fach)",{"$f":"2*SUM(N8:N14)","v":52},null,"Anzahl:",null,{"$f":"U48","v":4},null,null,null,"HJE","GE","PE",null,null,null,"Punkte","Anzahl HJE","Anzahl GE","Anzahl PE"]
[null,null,"Punktezahl weiterer 16 HJE",{"$f":"SUM(V7:AC24)","v":62},null," Anzahl:",null,{"$f":"S48","v":18},null,"Anzahl 0:",null,{"$f":"S32","v":0},{"$f":"T32","v":0},{"$f":"U32","v":0},null,null,null,0,{"$f":"COUNTIF($V$7:$AC$29,R32)","v":0},{"$f":"COUNTIF($Q$7:$Q$26,R32)","v":0},{"$f":"COUNTIF($N$8:$N$14,R32)","v":0}]
[null,null,"Punktezahl Seminararbeit (2-fach)",{"$f":"H25*2","v":8},null,null,null,null,null,"Anzahl 1:",null,{"$f":"S33","v":2},0,0,null,null,null,1,{"$f":"COUNTIF($V$7:$AC$29,R33)","v":2},{"$f":"COUNTIF($Q$7:$Q$26,R33)","v":0},0]
[null,null,"Zweite Fremdsprache:",{"$f":"D29+F29","v":2},null,null,null,null,null,"Anzahl 2:",null,0,0,0,null,null,null,2,0,0,0]
[null,null,"Gesamt:",{"$f":"SUM(D31:D34)","v":124},null,"von 420",null,null,null,"Anzahl 3:",null,3,0,0,null,null,null,3,3,0,0]
[null,null,"Durchschnittsnote:",{"$f":"IF(D37=\"bestanden\",INT(F36*10)/10,\"\")","v":4.0999999999999996},null,{"$f":"17/3-5*D35/420","v":4.1904761904761907},null,null,null,"Anzahl 4:",null,12,6,0,null,null,null,4,12,6,0]
[null,null,{"$f":"IF(SUM(U15+U22+U29)>0,\"Abitur (allgemein)\",\"Abitur (fachgebunden)\")","v":"Abitur (fachgebunden)"},{"$f":"IF(AND(E43=0,H32=18,U48=4,H25>0,M27<4),\"bestanden\",\"nicht bestanden\")","v":"bestanden"},null,null,null,null,null,"Anzahl 5:",null,1,2,1,null,null,null,5,1,2,1]
[null,null,null,null,null,null,null,null,null,"< 4",null,{"$f":"SUM(L32:L35)","v":5},{"$f":"SUM(M32:M35)","v":0},{"$f":"SUM(N32:N35)","v":0},null,null,null,6,0,1,2]
[null,null,"Überprüfung nach § 35 (9)",null,null,null,null,null,null,"< 4 (gew.):",null,{"$f":"2*L32+L33+L34+L35","v":5},{"$f":"2*M32+M33+M34+M35","v":0},{"$f":"2*N32+N33+N34+N35","v":0},null,null,null,7,0,1,0]
[null,null,"Prüfungsergebnisse",{"$f":"IF(AND(N32=0,N39<3,U48=4),\"erfüllt\",\"nicht erfüllt\")","v":"erfüllt"},null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,0]
[null,null,"Gesamtergebnisse",{"$f":"IF(H32=18,IF(OR((M39=0),AND(M39=1,D35>=140),AND(M39=2,D35>=168)),\"erfüllt\",\"nicht erfüllt\"))","v":"erfüllt"},null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,0,0]
[null,null,null,null,{"$f":"COUNTIF(D40:F42,\"nicht erfüllt\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,11,0,0,0]
[null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0]
[null,null,{"$f":"'FOS 12'!C44","v":"Version 22.02.22"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0]
[null,null,"© H. Müller | T. Pickel (VBA) | M. Thoma (Gestaltung)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S32:S47)","v":18},{"$f":"SUM(T32:T47)","v":10},{"$f":"SUM(U32:U47)","v":4}]

{"sheet":"FOSBOS 13-3","index":7,"n_rows":48,"n_cols":39,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,35,0,36],[3,35,3,36],[4,37,4,38],[5,37,5,38],[43,2,43,14],[36,3,36,5],[37,9,37,10],[38,3,38,5],[39,3,39,5],[40,3,40,5],[41,3,41,5],[35,3,35,4],[9,35,9,36],[11,34,11,38],[24,7,24,10],[26,3,26,10],[32,3,32,4],[33,3,33,4],[34,3,34,4],[3,3,3,5],[3,7,3,14],[27,3,27,10],[30,3,30,4],[30,5,30,6],[31,3,31,4],[31,5,31,6],[28,3,28,5],[28,6,28,7],[2,35,2,36],[8,35,8,36],[1,8,1,14],[1,35,1,36],[2,9,2,13],[4,3,4,10],[4,35,4,36],[5,35,5,36],[6,35,6,37],[7,35,7,38]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C31","v":"Punktezahl Prüfungen (2-fach)"},64,null,"Anzahl:",{"$f":"H31","v":4}]
[null,null,"Abschlussprüfung ABITUR",null,null,null,null,"Name: _____________________________","Hans Streichinger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punktezahl weiterer 16 HJE",91,null," Anzahl:",{"$f":"H32","v":16}]
[null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2022-12-22T12:27:08.450"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punktezahl Seminararbeit (2-fach)",10]
[null,null,"Ausbildungsrichtung:  ","Technik",null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ergänzngsprüfung 2. Fremdsprache",""]
[null,null,null,"Zu streichende HJE mit x markieren!",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(R7:R24)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE7:AE25)","v":0},{"$f":"COUNT(AF8:AF14)","v":3},null,null,"Gesamt:",{"$f":"D35","v":165},null,{"$f":"F35","v":"von 420"}]
["EB",null,null,"12/1",null,"12/2",null,"13/1","x","13/2","x","sP","mP","PE","GE",null,"GE(eingebracht)","Str.","GE",null,"Sprache","12/1",null,"12/2",null,"13/1",null,"13/2",null,"Anzahl","Anzahl<4 Nichtprüfung","Anz. mdl. Prfg",null,null,"Durchschnittsnote:",{"$f":"D36","v":""},null,{"$f":"F36","v":3.7023809523809526}]
[1,null,"Religionslehre/Ethik",null,null,null,null,12,null,10,null,null,null,null,{"$f":"IF(AND(ISERROR(S7),ISERROR(T7)),\"\",IF(ISNUMBER(S7),ROUND(S7,0),ROUND(T7,0)))","v":11},null,{"$f":"IF(A7=1,O7,\"\")","v":11},{"$f":"COUNTIF(D7:K7,\"x\")","v":0},{"$f":"IF(AVERAGE(V7:AB7)<1,0,AVERAGE(V7:AB7))","v":11},{"$f":"IF(AVERAGE(D7:J7)<1,0,AVERAGE(D7:J7))","v":11},null,{"$f":"IF(AND(ISNUMBER(D7),E7=\"\",$A7=1),D7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(F7),G7=\"\",$A7=1),F7,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(H7),I7=\"\",$A7=1),H7,\"\")","v":12},null,{"$f":"IF(AND(ISNUMBER(J7),K7=\"\",$A7=1),J7,\"\")","v":10},null,{"$f":"COUNT(V7:AB7)","v":2},{"$f":"IF(Q7=\"\",\"\",IF(Q7<4,IF(Q7=0,2,1),\"\"))","v":""},null,null,null,{"$f":"C37","v":"Abitur (allgemein)"},{"$f":"D37","v":"nicht bestanden"}]
[1,null,"Deutsch",null,null,null,null,4,"x",4,null,8,8,{"$f":"IF(ISBLANK(L8),\"\",IF(ISBLANK(M8),L8,IF((L8*2+M8)/3<1,0,ROUND((L8*2+M8)/3,0))))","v":8},{"$f":"IF(ISBLANK(L8),\"\",IF(AND(ISERROR(S8),ISERROR(T8)),\"\",IF(ISNUMBER(S8),ROUND(S8,0),ROUND(T8,0))))","v":7},null,7,{"$f":"COUNTIF(D8:K8,\"x\")","v":1},{"$f":"IF((2*N8+SUM(V8:AB8))/(AD8+2)<1,0,(2*N8+SUM(V8:AB8))/(AD8+2))","v":6.666666666666667},{"$f":"AVERAGE(D8:J8)","v":4},null,"",null,"",null,"",null,4,null,{"$f":"COUNT(V8:AB8)","v":1},null,{"$f":"IF(M8=\"\",\"\",M8)","v":8},null,null,"Überprüfung nach § 35 (9):"]
[1,null,"Englisch",null,null,null,null,4,null,4,null,12,4,{"$f":"IF(ISBLANK(L9),\"\",IF(ISBLANK(M9),L9,IF((L9*2+M9)/3<1,0,ROUND((L9*2+M9)/3,0))))","v":9},{"$f":"IF(ISBLANK(L9),\"\",IF(AND(ISERROR(S9),ISERROR(T9)),\"\",IF(ISNUMBER(S9),ROUND(S9,0),ROUND(T9,0))))","v":7},null,7,0,{"$f":"IF((2*N9+SUM(V9:AB9))/(AD9+2)<1,0,(2*N9+SUM(V9:AB9))/(AD9+2))","v":6.5},4,null,"",null,"",null,4,null,4,null,2,null,{"$f":"IF(M9=\"\",\"\",M9)","v":4},null,null,{"$f":"C40","v":"Prüfungsergebnisse"},{"$f":"D40","v":"erfüllt"},null,"<4",{"$f":"N39","v":0}]
[1,null,"Mathematik",null,null,null,null,4,null,4,null,10,null,{"$f":"IF(ISBLANK(L10),\"\",IF(ISBLANK(M10),L10,IF((L10*2+M10)/3<1,0,ROUND((L10*2+M10)/3,0))))","v":10},7,null,7,0,7,4,null,"",null,"",null,4,null,4,null,2,null,"",null,null,{"$f":"C41","v":"Gesamtergebnisse"},{"$f":"D41","v":"erfüllt"},null,"<4",{"$f":"M39","v":0}]
[]
[1,null,"Geschichte, Politik und Gesellschaft",null,null,null,null,12,null,10,null,null,null,null,{"$f":"IF(AND(ISERROR(S12),ISERROR(T12)),\"\",IF(ISNUMBER(S12),ROUND(S12,0),ROUND(T12,0)))","v":11},null,11,0,{"$f":"IF(AVERAGE(V12:AB12)<1,0,AVERAGE(V12:AB12))","v":11},{"$f":"IF(AVERAGE(D12:J12)<1,0,AVERAGE(D12:J12))","v":11},null,"",null,"",null,12,null,10,null,2,{"$f":"IF(Q12=\"\",\"\",IF(Q12<4,IF(Q12=0,2,1),\"\"))","v":""},null,null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!"]
[]
[{"$f":"IF(C14=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,3,FALSE)","v":"Physik"},null,null,null,null,4,null,4,null,5,5,{"$f":"IF(ISBLANK(L14),\"\",IF(ISBLANK(M14),L14,IF((L14*2+M14)/3<1,0,ROUND((L14*2+M14)/3,0))))","v":5},{"$f":"IF(ISBLANK(L14),\"\",IF(AND(ISERROR(S14),ISERROR(T14)),\"\",IF(ISNUMBER(S14),ROUND(S14,0),ROUND(T14,0))))","v":5},null,5,0,{"$f":"IF((2*N14+SUM(V14:AB14))/(AD14+2)<1,0,(2*N14+SUM(V14:AB14))/(AD14+2))","v":4.5},4,null,"",null,"",null,4,null,4,null,2,null,5]
[{"$f":"IF(C15=\"-\",0,1)","v":1},null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,4,FALSE)","v":"Technologie"},null,null,null,null,3,null,4,null,null,null,null,4,null,4,0,{"$f":"IF(AVERAGE(V15:AB15)<1,0,AVERAGE(V15:AB15))","v":3.5},{"$f":"IF(AVERAGE(D15:J15)<1,0,AVERAGE(D15:J15))","v":3.5},{"$f":"IF(AND((_xlfn.NUMBERVALUE(AB15)>=4),(O15>=4),(AD15=2),(C15=\"Franz./Span.\")),1,0)","v":0},"",null,"",null,3,null,4,null,2,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,{"$f":"VLOOKUP($D$4,Hinweise!$G$23:$N$29,5,FALSE)","v":"Chemie"},null,null,null,null,1,"x",4,null,null,null,null,4,null,4,1,{"$f":"IF(AVERAGE(V20:AB20)<1,0,AVERAGE(V20:AB20))","v":4},{"$f":"IF(AVERAGE(D20:J20)<1,0,AVERAGE(D20:J20))","v":2.5},null,"",null,"",null,"",null,4,null,1,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR(C22=\"-\",VLOOKUP(C22,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":1},null,"Informatik",null,null,null,null,4,null,4,null,null,null,null,4,null,4,0,{"$f":"IF(AVERAGE(V22:AB22)<1,0,AVERAGE(V22:AB22))","v":4},{"$f":"IF(AVERAGE(D22:J22)<1,0,AVERAGE(D22:J22))","v":4},{"$f":"IF(AND((_xlfn.NUMBERVALUE(AB22)>=4),(O22>=4),(AD22=2),(OR(C22=\"Spanisch (fortgeführt)\",C22=\"Französisch (fortgeführt)\"))),1,0)","v":0},"",null,"",null,4,null,4,null,2,""]
[{"$f":"IF(OR(C23=\"-\",VLOOKUP(C23,Hinweise!$C$6:$D$37,2,FALSE)=0),0,1)","v":0},null,"-",null,null,null,null,null,null,null,null,null,null,null,"",null,"",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",null,"",null,"",null,"",null,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,null,null,null,null,null,null,""]
[1,null,"Seminararbeit",null,null,null,null,5,null,null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",H25)","v":5},null,5,null,null,{"$f":"IF(A25=0,AVERAGE(D25:J25),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD24)","v":16},""]
[]
[null,null,"* nicht einbringungsfähig","Streichungen überprüfen",null,null,null,null,null,null,null,null,{"$f":"AF5","v":3}]
[null,null,null,{"$f":"IF(OR(H25=0,AE5>2),\"Zur Prüfung nicht zugelassen\",\"\")","v":""}]
[1,null,"Ergänzungsprüfung 2. Fremdsprache",{"$f":"IF(N29=\"\",\"unvollständig\",IF(O29<4,\"nicht bestanden\",\"bestanden\"))","v":"unvollständig"},null,null,null,null,null,null,null,4,null,{"$f":"IF(OR(ISBLANK(L29),ISBLANK(M29)),\"\",IF(ISBLANK(M29),L29,IF((L29*2+M29)/3<1,0,ROUND((L29*2+M29)/3,0))))","v":""},{"$f":"N29","v":""},null,{"$f":"IF(A29=1,O29,\"\")","v":""},{"$f":"COUNTIF(D29:K29,\"x\")","v":0},{"$f":"IF(AVERAGE(V29:AB29)<1,0,AVERAGE(V29:AB29))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AVERAGE(D29:J29)<1,0,AVERAGE(D29:J29))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(ISNUMBER(O29),O29>=4),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(D29),E29=\"\",$A29=1),D29,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(F29),G29=\"\",$A29=1),F29,\"\")","v":""},null,null,null,null,null,{"$f":"COUNT(V29:AB29)","v":0}]
[]
[null,null,"Punktezahl Prüfungen (2-fach)",{"$f":"2*SUM(N8:N14)","v":64},null,"Anzahl:",null,{"$f":"U48","v":4},null,null,null,"HJE","GE","PE",null,null,null,"Punkte","Anzahl HJE","Anzahl GE","Anzahl PE"]
[null,null,"Punktezahl weiterer 16 HJE",{"$f":"SUM(V7:AC24)","v":91},null," Anzahl:",null,{"$f":"S48","v":16},null,"Anzahl 0:",null,{"$f":"S32","v":0},{"$f":"T32","v":0},{"$f":"U32","v":0},null,null,null,0,{"$f":"COUNTIF($V$7:$AC$24,R32)","v":0},{"$f":"COUNTIF($Q$7:$Q$26,R32)","v":0},{"$f":"COUNTIF($N$8:$N$25,R32)","v":0}]
[null,null,"Punktezahl Seminararbeit (2-fach)",{"$f":"H25*2","v":10},null,null,null,null,null,"Anzahl 1:",null,{"$f":"S33","v":0},0,0,null,null,null,1,0,{"$f":"COUNTIF($Q$7:$Q$26,R33)","v":0},{"$f":"COUNTIF($N$8:$N$25,R33)","v":0}]
[null,null,"Ergänzngsprüfung 2. Fremdsprache",{"$f":"IF(U29=1,N29*2,\"\")","v":""},null,null,null,null,null,"Anzahl 2:",null,0,0,0,null,null,null,2,0,0,0]
[null,null,"Gesamt:",{"$f":"SUM(D31:D34)","v":165},null,"von 420",null,null,null,"Anzahl 3:",null,1,0,0,null,null,null,3,1,0,0]
[null,null,"Durchschnittsnote:",{"$f":"IF(D37=\"bestanden\",INT(F36*10)/10,\"\")","v":""},null,{"$f":"17/3-5*D35/420","v":3.7023809523809526},null,null,null,"Anzahl 4:",null,11,3,0,null,null,null,4,11,3,0]
[null,null,{"$f":"IF(SUM(U15+U22+1)>0,\"Abitur (allgemein)\",\"Abitur (fachgebunden)\")","v":"Abitur (allgemein)"},{"$f":"IF(AND(U29=1,E43=0,H32=16,U48=4,H25>0,M27<4),\"bestanden\",\"nicht bestanden\")","v":"nicht bestanden"},null,null,null,null,null,"Anzahl 5:",null,0,2,1,null,null,null,5,0,2,1]
[null,null,null,null,null,null,null,null,null,"< 4",null,{"$f":"SUM(L32:L35)","v":1},{"$f":"SUM(M32:M35)","v":0},{"$f":"SUM(N32:N35)","v":0},null,null,null,6,0,0,0]
[null,null,"Überprüfung nach § 35 (9)",null,null,null,null,null,null,"< 4 (gew.):",null,{"$f":"2*L32+L33+L34+L35","v":1},{"$f":"2*M32+M33+M34+M35","v":0},{"$f":"2*N32+N33+N34+N35","v":0},null,null,null,7,0,3,0]
[null,null,"Prüfungsergebnisse",{"$f":"IF(AND(N32=0,N39<3,U48=4),\"erfüllt\",\"nicht erfüllt\")","v":"erfüllt"},null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,1]
[null,null,"Gesamtergebnisse",{"$f":"IF(H32=16,IF(OR((M39=0),AND(M39=1,D35>=140),AND(M39=2,D35>=168)),\"erfüllt\",\"nicht erfüllt\"))","v":"erfüllt"},null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2,0,1]
[null,null,null,null,{"$f":"COUNTIF(D40:F42,\"nicht erfüllt\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,11,0,2,0]
[null,null,"Alle Berechnungen sind rechtlich nicht verbindlich!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,2,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0]
[null,null,{"$f":"'FOS 12'!C44","v":"Version 22.02.22"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0]
[null,null,"© H. Müller | T. Pickel (VBA) | M. Thoma (Gestaltung)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S32:S47)","v":16},{"$f":"SUM(T32:T47)","v":10},{"$f":"SUM(U32:U47)","v":4}]