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

{"sheet":"Abi-Bogen_WiWi","index":0,"n_rows":63,"n_cols":15,"rows_kept":63,"cut":false,"hidden":false,"merged":[[8,0,8,3],[13,0,13,3],[19,0,19,4],[6,0,6,3],[41,0,41,3],[10,3,10,4],[11,0,11,3],[16,5,16,8],[35,8,35,10],[32,7,32,9],[34,6,34,9],[47,0,47,4],[42,0,42,3],[43,0,43,3],[41,10,41,12],[36,0,36,4],[37,0,37,3],[39,0,39,3],[40,0,40,3],[38,6,38,7],[8,10,8,11],[6,11,6,13],[6,6,6,8],[49,5,49,8],[12,11,12,12],[20,11,20,12],[48,5,48,8],[40,8,40,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[41,13,42,14],[19,5,19,7],[40,10,40,12],[49,13,49,14],[45,9,45,11],[0,8,0,14],[2,4,2,6],[4,4,4,6],[2,13,2,14],[2,9,2,11],[4,9,4,10],[4,12,4,14],[2,7,2,8],[4,7,4,8]]}
[null,null,null,"Lippe Berufskolleg Lünen",null,null,null,null," Ermittlung der Gesamtqualifikation  § 25 APO-BK"]
[]
[null,null,null,"Name:",null,null,null,"     Vorname:",null,null,null,null,"Geb.datum:"]
[]
[null,null,null,"Geburtsort:",null,null,null,"     Bek.nis:",null,null,null,"Wohnort:"]
[null,null,null,null,null,null,null,null,null,"(ja - welches? / nein)"]
["Spanisch",null,null,null,"Pflicht (ja/nein)","Nein","freiwillig (ja/nein)",null,null,null,"Ja","Feststellungsprüfung (ja/nein)"]
[]
["1. Fremdsprache:",null,null,null,"Englisch","von:",{"$f":"IF(O7 = \"ja\",\"---\",\"5\")","v":"5"},"bis:",{"$f":"IF(O7 = \"ja\",\"---\",\"13\")","v":"13"},null,"2. Fremdsprache:",null,null,{"$f":"IF(M9=\"\",\"---\",\"von:  7\")","v":"---"},{"$f":"IF(M9=\"\",\"---\",\"bis:  10\")","v":"---"}]
[]
[null,null,null,"Block I"]
["1. Abiturfächer: "]
[null,null,null,null,null,"12 / I","12 / II","13 / I","13 / II",null,null,null,null,"Punkte LK:"]
["Leistungskurse:",null,null,null,"BWL - REWE",null,null,null,null,null,"Kurse LK"]
[null,null,null," ","Deutsch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurse unter 5 P.:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(max. 3 Kurse)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Deutsch"]
[]
["2. weitere Grundkursfächer:",null,null,null,null,"Pflichtkurse:",null,null,null,null,null,null,null,"max. Anzahl v."]
[null,null,null,null,null,"12 / I","12 / II","13 / I","13 / II",null,null,null,null,"Defizitkursen"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(A22=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(B22=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(C22=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(D22=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,"Englisch",null,null,null,null,{"$f":"IF(AND(A23=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(B23=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(C23=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(D23=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,"Mathematik",null,null,null,null,{"$f":"IF(AND(A24=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(B24=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(C24=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(D24=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)","v":{"$error":"#REF!"}},null,null,null,"Kurse unter 5 P.:"]
[null,null,null,null,"Bio/Phy/Che"]
[null,null,null,null,"VWL",null,null,null,null,{"$f":"IF(AND(A26=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(B26=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(C26=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(D26=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,"Spanisch",null,null,null,null,{"$f":"IF(AND(A27=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(B27=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(C27=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)+IF(AND(D27=TRUE,#REF!=0,ISNUMBER(#REF!)),1,0)","v":{"$error":"#REF!"}},null,null,null,"Punkte GK-anteilig"]
[null,null,null,null,"WI"]
[null,null,null,null,"Gesellschaftsl.",null,null,null,null,null,null,null,null,"Punkte GK: "]
[null,null,null,null,"Religion"]
[null,null,null,null,"Sport"]
[null,null,null,null,"Differenzierung",null,null,null,null,null,null,null,null,"Punkte Gesamt"]
[null,null,null,null,{"$f":"IF(E41<>\"Mathematik\",\"Mathematik\",\"\")","v":"Mathematik"},null,null,"Summe:"]
[null,null,null,null,{"$f":"IF(E41<>\"Englisch\",\"Englisch\",\"\")","v":"Englisch"},null,null,null,"(mind. 24)"]
[null,null,null,null,{"$f":"IF(E41<>\"Deutsch\",\"Deutsch\",\"\")","v":"Deutsch"},null,"Pflichtkurse:",null,null,null,{"$f":"K15+K33","v":0}]
[null,null,null,null,null,null,null,null,"(mind. 32)"]
["Block II"]
["3. Abiturbereich:"]
[null,null,null,null,null,null,"    Abitur"]
["Durchschn.note",null,null,null,null,null,"schr.","mdl.","Punkte"]
[15,null,null,null,{"$f":"E14","v":"BWL - REWE"},"(1. LK)",null,null,null,null,"2 Fächer je 25 Pkt. (bzw. 20 Pkt. bei"]
[{"$f":"AVERAGE(F15:I15)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"E15","v":"Deutsch"},"(2. LK)",null,null,null,null,"bes. Lernleistung), darunter 1 LK",null,null,"Gesamtpunkte\nBlock II"]
[{"$f":"(VLOOKUP(E43,$E$22:$I$31,5,0)+VLOOKUP(E43,$E$22:$I$31,2,0)+VLOOKUP(E43,$E$22:$I$31,3,0)+VLOOKUP(E43,$E$22:$I$31,4,0))/4","v":0},null,null,null,"Englisch","(3. AF)"]
[{"$f":"(VLOOKUP(E44,$E$22:$I$31,5,0)+VLOOKUP(E44,$E$22:$I$31,2,0)+VLOOKUP(E44,$E$22:$I$31,3,0)+VLOOKUP(E44,$E$22:$I$31,4,0))/4","v":0},null,null,null,"WI","(4. AF)",null,null,null,null,null,null,"  Summe:"]
[null,null,null,null,null,null,null,null," ",null,null,null," ",{"$f":"IF(M50>767,1,IF(M50>750,1.1,IF(M50>733,1.2,IF(M50>716,1.3,IF(M50>700,1.4,IF(M50>683,1.5,IF(M50>666,1.6,IF(M50>649,1.7,\"*\"))))))))","v":"*"}]
[null,null,null,"Besondere Lernleistung:",null,"nein",null,{"$f":"IF(F46=\"nein\",\"--\",\" \")","v":"--"}," Pkt.","(einfache Wertung)",null,null,null,{"$f":"IF(N45=\"*\",IF(M50>632,1.8,IF(M50>616,1.9,IF(M50>599,2,IF(M50>582,2.1,IF(M50>565,2.2,IF(M50>548,2.3,IF(M50>532,2.4,\"*\"))))))))","v":"*"}]
[null,null,null,null,null,{"$f":"IF(OR(F46=\"ja\",F46=\"nein\"),\" \",\" (ja/nein)\")","v":" "},null,null,null,null,null,null,null,{"$f":"IF(N46=\"*\",IF(M50>515,2.5,IF(M50>498,2.6,IF(M50>481,2.7,IF(M50>464,2.8,IF(M50>448,2.9,IF(M50>431,3,IF(M50>414,3.1,\"*\"))))))))","v":"*"}]
["4. Gesamtqualifikation:",null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"IF(N47=\"*\",IF(M50>397,3.2,IF(M50>380,3.3,IF(M50>364,3.4,IF(M50>347,3.5,IF(M50>330,3.6,IF(M50>313,3.7,IF(M50>296,3.8,\"*\"))))))))","v":"*"}]
[null,null,null,null,null,"Block 1\n(mind. 200 PKT.)",null,null,null,null,null,null," ","           Note:"]
[null,null,null,null,null,"Block 2\n(mind. 100 PKT.)",null,null,null,null,null,"  Summe:"]
[]
[]
[null,null,null,null,"Biologie"]
[null,null,null,null,"Physik"]
[null,null,null,null,"Chemie"]
[null,null,null,null,"WI"]
[null,null,null,null,{"$f":"IF(AND($E$41<>\"Englisch\",$E$43<>\"Englisch\"),\"Englisch\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(OR($E$41=\"Englisch\",$E$41=\"Deutsch\"),OR($E$43=\"Englisch\",$E$43=\"Deutsch\")),\"\",\"Spanisch\")","v":"Spanisch"}]
[null,null,null,null,{"$f":"IF(AND(OR($E$41=\"Englisch\",$E$41=\"Deutsch\"),OR($E$43=\"Englisch\",$E$43=\"Deutsch\")),\"\",\"Gesellschaftslehre\")","v":"Gesellschaftslehre"}]
[null,null,null,null,{"$f":"IF(AND(OR($E$41=\"Englisch\",$E$41=\"Deutsch\"),OR($E$43=\"Englisch\",$E$43=\"Deutsch\")),\"\",\"Religion\")","v":"Religion"}]
[null,null,null,null,{"$f":"IF(AND(OR($E$41=\"Englisch\",$E$41=\"Deutsch\"),OR($E$43=\"Englisch\",$E$43=\"Deutsch\")),\"\",\"VWL\")","v":"VWL"}]
[null,null,null,null,{"$f":"IF(OR($E$41=\"Mathematik\",$E$43=\"Mathematik\"),\"\",\"Mathematik\")","v":"Mathematik"}]
[null,null,null,null,{"$f":"IF(OR($E$41=\"Deutsch\",$E$43=\"Deutsch\"),\"\",\"Deutsch\")","v":"Deutsch"}]

{"sheet":"Durschnittsnoten","index":1,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[0,"nicht bestanden"]
[300,4]
[301,3.9]
[{"$f":"A3+18","v":319},3.8]
[{"$f":"A4+18","v":337},3.7]
[355,3.6]
[373,3.5]
[391,3.4]
[409,3.3]
[427,3.2]
[445,3.1]
[463,3]
[481,2.9]
[499,2.8]
[517,2.7]
[535,2.6]
[553,2.5]
[571,2.4]
[589,2.2999999999999998]
[607,2.2000000000000002]
[625,2.1]
[643,2]
[661,1.9]
[679,1.8]
[697,1.7]
[715,1.6]
[733,1.5]
[751,1.4]
[769,1.3]
[787,1.2]
[805,1.1000000000000001]
[823,1]

{"sheet":"Tabelle1","index":2,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5]