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

{"sheet":"Tabelle1","index":0,"n_rows":62,"n_cols":11,"rows_kept":62,"merged":[[11,5,11,8],[18,1,18,3],[18,6,18,8],[35,1,35,2],[35,5,35,6],[35,7,35,8],[36,7,36,8]]}
["Berechnung der Endnote gemäß Anlage 4 der Abiturverfügung "]
[]
[]
[]
[null,"Maximale Rohpunktzahl",120,null,null,"Prüfung, ob eine Drittkorrektur erforderlich ist"]
[{"$nulls":5},"Abweichung zwischen EK und ZK größer als 3 Notenpunkte?"]
[null,null,"EK","ZK",{"$nulls":3},"EK","ZK"]
["I","Erreichte Rohpunktsummen",108,112,null,"aus I resultierende Notenpunktzahl",null,{"$f":"IF(AND(F38<=C8, C8 <=G38),D38,IF(AND(F39<=C8, C8 <=G39),D39,IF(AND(F40<=C8, C8 <=G40),D40,IF(AND(F41<=C8, C8 <=G41),D41,IF(AND(F42<=C8, C8 <=G42),D42,IF(AND(F43<=C8, C8 <=G43),D43,IF(AND(F44<=C8, C8 <=G44),D44,IF(AND(F45<=C8, C8 <=G45),D45,IF(AND(F46<=C8, C8 <=G46),D46,IF(AND(F47<=C8, C8 <=G47),D47,IF(AND(F48<=C8, C8 <=G48),D48,IF(AND(F49<=C8, C8 <=G49),D49,IF(AND(F50<=C8, C8 <=G50),D50,IF(AND(F51<=C8, C8 <=G51),D51,IF(AND(F52<=C8, C8 <=G52),D52,D53)))))))))))))))","v":14},{"$f":"IF(AND(F38<=D8, D8 <=G38),D38,IF(AND(F39<=D8, D8 <=G39),D39,IF(AND(F40<=D8, D8 <=G40),D40,IF(AND(F41<=D8, D8 <=G41),D41,IF(AND(F42<=D8, D8 <=G42),D42,IF(AND(F43<=D8, D8 <=G43),D43,IF(AND(F44<=D8, D8 <=G44),D44,IF(AND(F45<=D8, D8 <=G45),D45,IF(AND(F46<=D8, D8 <=G46),D46,IF(AND(F47<=D8, D8 <=G47),D47,IF(AND(F48<=D8, D8 <=G48),D48,IF(AND(F49<=D8, D8 <=G49),D49,IF(AND(F50<=D8, D8 <=G50),D50,IF(AND(F51<=D8, D8 <=G51),D51,IF(AND(F52<=D8, D8 <=G52),D52,D53)))))))))))))))","v":14}]
[null,null,{"$f":"IF(OR(C8<0,C8>C5),\"Falsche Eingabe\",\"\")","v":""},{"$f":"IF(OR(D8<0,D8>C5),\"Falsche Eingabe\",\"\")","v":""}]
[null,null,"EK","ZK",{"$nulls":3},"EK","ZK"]
["II ","ggf. Absenkung (\"Gehäufte Verstöße …\") lt. §13 (2) APO-GOSt  bzw. § 17 (5) APO-WbK in Notenpunkten (-1 oder -2) ",-1,0,null,"Notenpunktzahl nach evtl. Absenkung lt. II",null,{"$f":"IF(H8+C11<0,0,H8+C11)","v":13},{"$f":"IF(I8+D11<0,0,I8+D11)","v":14}]
[null,null,{"$f":"IF(OR(C11<-2,C11>0),\"Falsche Eingabe\",\"\")","v":""},{"$f":"IF(OR(D11<-2,D11>0),\"Falsche Eingabe\",\"\")","v":""},null,{"$f":"IF(ABS(H11-I11)>3,\"Eine Drittkorrektur ist erforderlich!\",\"Eine Drittkorrektur ist nicht erforderlich.\")","v":"Eine Drittkorrektur ist nicht erforderlich."}]
[]
[]
[{"$nulls":6},"Absenkung vorgesehen (EK oder ZK)?",{"$f":"OR(C11<0,D11<0)","v":true}]
[{"$nulls":6},"Drittkorrektur nicht erforderlich?",{"$f":"ABS(H11-I11)<4","v":true}]
[]
[]
[{"$f":"IF(AND(NOT($H$15),$H$16),1,0)","v":0},{"$f":"IF(OR($C$11<0,$D$11<0),\"\",\"Keine Absenkung nach §13(2) APO-GOSt vorgesehen\")","v":""},{"$nulls":3},{"$f":"IF(AND($H$15,$H$16),1,0)","v":1},{"$f":"IF(OR($C$11<0,$D$11<0),\"Absenkung nach §13(2) APO-GOSt vorgesehen  (EK oder ZK)\",\"\")","v":"Absenkung nach §13(2) APO-GOSt vorgesehen  (EK oder ZK)"}]
[]
["III","Arithmetisches Mittel der beiden Rohpunktsummen aus I (ggf. gerundet)",{"$f":"IF(AND(NOT($H$15),$H$16),ROUND((C8+D8)/2,0),\"\")","v":""},null,null,"V","Arithmetisches Mittel der Rohpunktsummen aus I (ggf. gerundet)",{"$f":"IF(AND($H$15,$H$16),ROUND((C8+D8)/2,0),\"\")","v":110}]
[]
[{"$nulls":5},"VI","aus V resultierende Notenpunktzahl",{"$f":"IF(AND($H$15,$H$16),IF(AND(F38<=H21, H21 <=G38),D38,IF(AND(F39<=H21, H21 <=G39),D39,IF(AND(F40<=H21, H21 <=G40),D40,IF(AND(F41<=H21, H21 <=G41),D41,IF(AND(F42<=H21, H21 <=G42),D42,IF(AND(F43<=H21, H21 <=G43),D43,IF(AND(F44<=H21, H21 <=G44),D44,IF(AND(F45<=H21, H21 <=G45),D45,IF(AND(F46<=H21, H21 <=G46),D46,IF(AND(F47<=H21, H21 <=G47),D47,IF(AND(F48<=H21, H21 <=G48),D48,IF(AND(F49<=H21, H21 <=G49),D49,IF(AND(F50<=H21, H21 <=G50),D50,IF(AND(F51<=H21, H21 <=G51),D51,IF(AND(F52<=H21, H21 <=G52),D52,D53))))))))))))))),\"\" )","v":14}]
[]
[{"$nulls":7},"EK","ZK"]
[{"$nulls":5},"VII","Notenpunktzahl nach Abzug lt. II",{"$f":"IF(AND($H$15,$H$16),IF((H23+C11)<0,0,H23+C11),\"\")","v":13},{"$f":"IF(AND($H$15,$H$16),IF(H23+D11<0,0,H23+D11),\"\")","v":14}]
[]
["IV","Endnote (Notenpunktzahl)\naus III resultierende Notenpunktzahl",{"$f":"IF(AND(NOT($H$15),$H$16),IF(AND(F38<=C21, C21 <=G38),D38,IF(AND(F39<=C21, C21 <=G39),D39,IF(AND(F40<=C21, C21 <=G40),D40,IF(AND(F41<=C21, C21 <=G41),D41,IF(AND(F42<=C21, C21 <=G42),D42,IF(AND(F43<=C21, C21 <=G43),D43,IF(AND(F44<=C21, C21 <=G44),D44,IF(AND(F45<=C21, C21 <=G45),D45,IF(AND(F46<=C21, C21 <=G46),D46,IF(AND(F47<=C21, C21 <=G47),D47,IF(AND(F48<=C21, C21 <=G48),D48,IF(AND(F49<=C21, C21 <=G49),D49,IF(AND(F50<=C21, C21 <=G50),D50,IF(AND(F51<=C21, C21 <=G51),D51,IF(AND(F52<=C21, C21 <=G52),D52,D53))))))))))))))),\"\")","v":""},null,null,"VIII","Endnote (Notenpunktzahl)\narithmetisches Mittel der beiden Notenpunktzahlen lt. VII (ggf. gerundet)",{"$f":"IF(AND($H$15,$H$16),ROUND((H26+I26)/2,0),\"\")","v":14}]
[]
[]
[]
[]
[]
["Zur Information: Zuordnung der Rohpunkte zu Notenstufen"]
[]
[null,"Prozentuale Anteile erbrachter Leistung",null,"Punkte GOSt","Notenstufen","Rohpunkte",{"$nulls":4},"Anzahl der Rohpunkte je Ziffernnote (1-6)"]
[null,"von","bis unter",null,null,"von","bis"]
[null,{"v":0.95,"d":"95%"},{"v":1,"d":"100%"},15,"1+",{"$f":"IF(INT(B38*$C$5)=B38*$C$5, B38*$C$5, INT(B38*$C$5)+1)","v":114},{"$f":"$C$5","v":120}]
[null,{"v":0.9,"d":"90%"},{"$f":"B38","v":{"v":0.95,"d":"95%"}},14,1,{"$f":"IF(INT(B39*$C$5)=B39*$C$5, B39*$C$5, INT(B39*$C$5)+1)","v":108},{"$f":"F38-1","v":113},{"$nulls":3},{"$f":"G38-G41","v":19}]
[null,{"v":0.85,"d":"85%"},{"v":0.9,"d":"90%"},13,"1-",102,107]
[null,{"v":0.8,"d":"80%"},{"v":0.85,"d":"85%"},12,"2+",96,101]
[null,{"v":0.75,"d":"75%"},{"v":0.8,"d":"80%"},11,2,90,95,{"$nulls":3},{"$f":"G41-G44","v":18}]
[null,{"v":0.7,"d":"70%"},{"v":0.75,"d":"75%"},10,"2-",84,89]
[null,{"v":0.65,"d":"65%"},{"v":0.7,"d":"70%"},9,"3+",78,83]
[null,{"v":0.6,"d":"60%"},{"v":0.65,"d":"65%"},8,3,72,77,{"$nulls":3},{"$f":"G44-G47","v":18}]
[null,{"v":0.55,"d":"55%"},{"v":0.6,"d":"60%"},7,"3-",66,71]
[null,{"v":0.5,"d":"50%"},{"v":0.55,"d":"55%"},6,"4+",60,65]
[null,{"v":0.45,"d":"45%"},{"v":0.5,"d":"50%"},5,4,54,59,{"$nulls":3},{"$f":"G47-G50","v":18}]
[null,{"v":0.4,"d":"40%"},{"v":0.45,"d":"45%"},4,"4-",48,53]
[null,{"v":0.33,"d":"33%"},{"v":0.4,"d":"40%"},3,"5+",40,47]
[null,{"v":0.27,"d":"27%"},{"v":0.33,"d":"33%"},2,5,33,39,{"$nulls":3},{"$f":"G50-G53","v":24}]
[null,{"v":0.2,"d":"20%"},{"v":0.27,"d":"27%"},1,"5-",24,32]
[null,{"v":0,"d":"0%"},{"$f":"B52","v":{"v":0.2,"d":"20%"}},0,6,0,{"$f":"F52-1","v":23},{"$nulls":3},{"$f":"G53-F53+1","v":24}]
["Notentabelle nach Vorgabe KMK (Dezember 2016)"]
[{"$nulls":5},"Punkte:",{"$f":"C5","v":120}]
["QUA-LiS NRW 2017-01-26",{"$nulls":4},"Rundung:",1]
[]
[]
[null,"Kennwerte der Tabelle (Erbrachte Leistung): "]
[null,"Distanz im oberen Teil (75% bis 100%):",null,null,{"v":0.05,"d":"5.0%"}]
[null,"Distanz im mittleren Teil (50% bis 75%):",null,null,{"v":0.05,"d":"5.0%"}]
[null,"Distanz im unteren Teil (0% bis 50%):",null,null,{"v":0.0667,"d":"6.7%"}]