{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Schularbeitsplaner","Beurteilungsblatt","Einzel"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"Schularbeitsplaner","index":0,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,11],[2,3,2,4],[3,3,3,4],[32,5,32,11],[36,2,39,11],[35,2,35,4],[35,5,35,6],[34,5,34,11],[34,1,34,4],[7,1,8,1],[4,5,4,6],[5,5,5,6],[12,13,12,15],[23,13,23,15],[3,14,3,15],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,6,8,6],[7,11,8,11],[6,7,6,9],[7,5,8,5],[2,1,5,2],[4,3,4,4],[2,11,4,11],[5,3,5,4],[2,5,2,6],[3,5,3,6]]}
[]
[]
[null,"Schularbeitsplanung",null,"Fach",null,"Französisch",null,null,null,null,null,"Dauer \nin \nMinuten"]
[null,null,null,"Klasse",null,"7AB",null,null,null,null,null,null,null,"Note","Häufigkeit"]
[null,null,null,"Schularbeit",null,2,null,null,null,null,null,null,null,null,null,"in %"]
[null,null,null,"Datum",null,"2014-05-06",null,null,null,null,null,100,null,"Sehr gut",{"$f":"COUNTIF(Beurteilungsblatt!$Y$23:$Y$50,1)","v":0},{"$f":"ROUND(O6/O$11*100,1)","v":0}]
[null,null,null,null,null,null,null,"Schwierigkeit",null,null,null,null,null,"Gut",{"$f":"COUNTIF(Beurteilungsblatt!$Y$23:$Y$50,2)","v":0},{"$f":"ROUND(O7/O$11*100,1)","v":0}]
[null,null,"Struktur","Items","Punkte","Gewichtung\nder Items","%",null,null,null,null,"Min",null,"Befriedigend",{"$f":"COUNTIF(Beurteilungsblatt!$Y$23:$Y$50,3)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"Genügend",{"$f":"COUNTIF(Beurteilungsblatt!$Y$23:$Y$50,4)","v":2},100]
[null,"LESEN",1,{"$f":"SUM(D11:D14)","v":15},{"$f":"IF(C10>0,E33/C33,0)","v":50},{"$f":"IF(AND(C10=1,E10>0),E10/D10,0)","v":3.3333333333333335},{"$f":"IF(E33>0,E10/E$33*100,0)","v":25},null,"mittel","schwierig",0.6,{"$f":"IF(C10=1,ROUND(COUNTA(D11:D14)*45/4,0),0)","v":23},1,"Nicht genügend",{"$f":"COUNTIF(Beurteilungsblatt!$Y$23:$Y$50,5)","v":0},0]
[null,"Lesetext 1",7,9,{"$f":"D11*F$10","v":30},null,{"$f":"IF(E$33>0,E11/E$33*100,0)","v":15},null,1,null,{"$f":"IF(D11>0,0.6,0)","v":0.6},null,null,"Schülerzahl",{"$f":"SUM(O6:O10)","v":2},{"$f":"ROUND(SUM(P6:P10),0)","v":100}]
[null,"Lesetext 2",1,6,{"$f":"D12*F$10","v":20},null,{"$f":"IF(E$33>0,E12/E$33*100,0)","v":10},null,1,null,{"$f":"IF(D12>0,0.6,0)","v":0.6}]
[null,"Lesetext 3",null,null,{"$f":"D13*F$10","v":0},null,{"$f":"IF(E$33>0,E13/E$33*100,0)","v":0},null,null,null,{"$f":"IF(D13>0,0.6,0)","v":0},null,null,"Notenverteilung"]
[null,"Lesetext 4",null,null,{"$f":"D14*F$10","v":0},null,{"$f":"IF(E$33>0,E14/E$33*100,0)","v":0},null,null,null,{"$f":"IF(D14>0,0.6,0)","v":0}]
[]
[null,"HÖREN",1,{"$f":"SUM(D17:D20)","v":13},{"$f":"IF(C16>0,E33/C33,0)","v":50},{"$f":"IF(AND(C16=1,E16>0),E16/D16,0)","v":3.8461538461538463},{"$f":"IF(E33>0,E16/E$33*100,0)","v":25},null,null,null,null,{"$f":"SUM(N17:N20)","v":11},2]
[null,"Hörtext 1",null,6,{"$f":"D17*F$16","v":23.076923076923077},null,{"$f":"IF(E$33>0,E17/E$33*100,0)","v":11.538461538461538},"%",1,null,{"$f":"IF(D17>0,0.6,0)","v":0.6},2,3,{"$f":"IF($C$16=1,ROUNDUP(SUM(L17*2*60+D17*5+30)*COUNT(D17)*COUNT(L17)/60,0),0)","v":5}]
[null,"Hörtext 2",null,7,{"$f":"D18*F$16","v":26.923076923076923},null,{"$f":"IF(E$33>0,E18/E$33*100,0)","v":13.461538461538462},"%",1,null,{"$f":"IF(D18>0,0.6,0)","v":0.6},2,4,{"$f":"IF($C$16=1,ROUNDUP(SUM(L18*2*60+D18*5+30)*COUNT(D18)*COUNT(L18)/60,0),0)","v":6}]
[null,"Hörtext 3",null,null,{"$f":"D19*F$16","v":0},null,{"$f":"IF(E$33>0,E19/E$33*100,0)","v":0},"%",null,null,{"$f":"IF(D19>0,0.6,0)","v":0},null,5,{"$f":"IF($C$16=1,ROUNDUP(SUM(L19*2*60+D19*5+30)*COUNT(D19)*COUNT(L19)/60,0),0)","v":0}]
[null,"Hörtext 4",null,null,{"$f":"D20*F$16","v":0},null,{"$f":"IF(E$33>0,E20/E$33*100,0)","v":0},"%",null,null,{"$f":"IF(D20>0,0.6,0)","v":0},null,null,{"$f":"IF($C$16=1,ROUNDUP(SUM(L20*2*60+D20*5+30)*COUNT(D20)*COUNT(L20)/60,0),0)","v":0}]
[]
[]
[null,"SPRACHE IM KONTEXT",1,{"$f":"SUM(D24:D27)","v":25},{"$f":"IF(C23>0,E33/C33,0)","v":50},{"$f":"IF(AND(C23=1,E23>0),E23/D23,0)","v":2},{"$f":"IF(E33>0,E23/E$33*100,0)","v":25},null,"mittel","schwierig",{"$f":"IFERROR(SUM(K24:K27)/COUNT(I24:J27),0)","v":0},{"$f":"IF(C23=1,ROUND(COUNTA(D24:D27)*40/4,0),0)","v":20}]
[null,"SiK 1",null,14,{"$f":"D24*F$23","v":28},null,{"$f":"IF(E$33>0,E24/E$33*100,0)","v":14.000000000000002},"%",1,null,{"$f":"IF(D24>0,IF(#REF!*0.7+I24*0.6+J24*0.5<1,#REF!*0.7+I24*0.6+J24*0.5,\"FEHLER\"))","v":{"$error":"#REF!"}},null,null,"Lösungsquote nach Kompetenzbereichen  in %"]
[null,"SiK 2",null,11,{"$f":"D25*F$23","v":22},null,{"$f":"IF(E$33>0,E25/E$33*100,0)","v":11},"%",1,null,{"$f":"IF(D25>0,IF(#REF!*0.7+I25*0.6+J25*0.5<1,#REF!*0.7+I25*0.6+J25*0.5,\"FEHLER\"))","v":{"$error":"#REF!"}}]
[null,"SiK 3",null,null,{"$f":"D26*F$23","v":0},null,{"$f":"IF(E$33>0,E26/E$33*100,0)","v":0},"%",null,null,{"$f":"IF(D26>0,IF(#REF!*0.7+I26*0.6+J26*0.5<1,#REF!*0.7+I26*0.6+J26*0.5,\"FEHLER\"))","v":false},null,null,"Lesen"]
[null,"SiK 4",null,null,{"$f":"D27*F$23","v":0},null,{"$f":"IF(E$33>0,E27/E$33*100,0)","v":0},"%",null,null,{"$f":"IF(D27>0,IF(#REF!*0.7+I27*0.6+J27*0.5<1,#REF!*0.7+I27*0.6+J27*0.5,\"FEHLER\"))","v":false},null,null,"Hören"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SIK"]
[null,"SCHREIBEN",null,{"$f":"D30+D31","v":40},{"$f":"IF(C30+C31>0,E33/C33,0)","v":50},{"$f":"IF(E29>0,E29/D29,0)","v":1.25},{"$f":"IF(E33>0,E29/E$33*100,0)","v":25},null,null,null,null,{"$f":"L6-L16-L23-L10","v":46},null,"Schreiben 1"]
[null,"Schreibauftrag 1",1,{"$f":"IF(C30=1,40,0)","v":40},{"$f":"IF(C30=1,40,0)","v":40},null,{"$f":"IF(E$33>0,E30/E$33*100,0)","v":20},"%",null,null,null,null,null,"Schreiben 2"]
[null,"Schreibauftrag 2",0,{"$f":"IF(C31=1,40,0)","v":0},{"$f":"IF(C31=1,40,0)","v":0},null,{"$f":"IF(E$33>0,E31/E$33*100,0)","v":0},"%"]
[]
[null,"Anzahl der Teilbereiche",{"$f":"C10+C16+C23+(C30+C31)-C30*C31","v":4},null,200]
[null,null,null,null,null,"RP-Modell","Gesamtverrechnung"]
[null,"Beurteilungsmodell",null,null,null,"RP-Modell"]
[]
[null,null,{"$f":"IF(AND(C10*C16*C23*(C30+C31)=0,F35=\"RP-Modell\"),\"Eine Schularbeit nach RP-Modell muss alle vier Bereiche Lesen, Hören, SiK und Schreiben enthalten\",\"\")","v":""}]

{"sheet":"Beurteilungsblatt","index":1,"n_rows":53,"n_cols":25,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,15,1,24],[7,1,7,2],[13,1,13,3],[14,1,14,3],[15,1,15,3],[9,1,9,3],[9,6,9,7],[11,6,12,7],[15,8,15,18],[9,9,9,13],[11,9,11,13],[12,9,12,13],[13,9,13,13],[9,14,9,18],[11,14,11,18],[12,14,12,18],[3,15,3,18],[4,15,4,18],[5,15,5,18],[6,15,6,18],[2,15,2,18],[6,2,6,3],[2,21,2,23],[17,19,17,20],[20,2,20,3],[17,9,17,13],[17,14,17,18],[17,6,17,7],[3,21,3,23],[4,21,4,23],[5,21,5,23],[11,1,11,3],[12,1,12,3],[9,19,9,20],[1,1,5,5],[9,23,9,24],[6,21,6,23],[51,2,51,3],[52,2,52,3],[7,9,7,13],[10,9,10,12],[10,14,10,17],[10,2,10,3],[14,4,14,5],[7,3,7,5],[13,14,13,18],[14,8,14,18]]}
[]
[null,"Klassenergebnis",null,null,null,null,null,null,null,null,null,null,null,null,null,"Notenschlüssel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sehr gut",null,null,null,null,{"$f":"U6+(X14-X16)*0.75","v":180},"≤",null,null,{"$f":"X14","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gut",null,null,null,null,{"$f":"U6+(X14-X16)*0.5","v":160},"<",null,null,{"$f":"U3","v":180}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Befriedigend",null,null,null,null,{"$f":"U6+(X14-X16)*0.25","v":140},"<",null,null,{"$f":"U4","v":160}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genügend",null,null,null,null,{"$f":"Y7","v":120},"<",null,null,{"$f":"U5","v":140}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nicht genügend",null,null,null,null,0,"<",null,null,{"$f":"X16","v":120}]
[null,"Beurteilung",null,{"$f":"Schularbeitsplaner!F35","v":"RP-Modell"},null,null,null,"Klasse",{"$f":"Schularbeitsplaner!F4","v":"7AB"},"Schularbeit",null,null,null,null,{"$f":"Schularbeitsplaner!F5","v":2}]
[]
[null,null,null,null,"Lesen","Hören","rezeptiv",null,"SiK","Schreiben 1",null,null,null,null,"Schreiben 2",null,null,null,null,"produktiv"]
[]
[null,"Items",null,null,{"$f":"IF(Schularbeitsplaner!C10=1,Schularbeitsplaner!D10,0)","v":15},{"$f":"IF(Schularbeitsplaner!C16=1,Schularbeitsplaner!D16,0)","v":13},null,null,{"$f":"IF(Schularbeitsplaner!C23=1,Schularbeitsplaner!D23,0)","v":25},{"$f":"IF(Schularbeitsplaner!C30=1,Schularbeitsplaner!D30,0)","v":40},null,null,null,null,{"$f":"IF(Schularbeitsplaner!C31>0,Schularbeitsplaner!D31,0)","v":0}]
[null,"Wertigkeit",null,null,{"$f":"Schularbeitsplaner!F10","v":3.3333333333333335},{"$f":"Schularbeitsplaner!F16","v":3.8461538461538463},null,null,{"$f":"Schularbeitsplaner!F23","v":2},{"$f":"Schularbeitsplaner!F29","v":1.25},null,null,null,null,{"$f":"Schularbeitsplaner!F29","v":1.25}]
[null,"maximale Punkte",null,null,{"$f":"E13*E12","v":50},{"$f":"F13*F12","v":50},{"$f":"E14+F14","v":100},{"$f":"E14+F14","v":100},{"$f":"I13*I12","v":50},{"$f":"J12*J13","v":50},null,null,null,null,{"$f":"O12*O13","v":0},null,null,null,null,{"$f":"I14+J14+O14","v":100},{"$f":"I14+J14+O14","v":100},null,null,{"$f":"H14+U14","v":200}]
[null,"cut score",null,null,0.5,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[null,"minimale Punkte",null,null,null,null,{"$f":"$H$16","v":50},{"$f":"H14*E15","v":50},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$U$16","v":50},{"$f":"U14*I15","v":50},null,null,{"$f":"X14*X15","v":120}]
[]
[null,null,null,null,"Lesen","Hören","rezeptiv",null,"SiK","Schreiben 1",null,null,null,null,"Schreiben 2",null,null,null,null,"produktiv",null,null,null,"Gesamt ","Note"]
[null,"Nr. ","Name","Vorname","Lesen","Hören",null,"Rezeptiv gewichtet","SiK","EA","A&L","SSM","SR",1,"EA","A&L","SSM","SR",2,"Produktiv","Produktiv gewichtet",null,null,"Gesamt gewichtet","Note"]
[null,null,null,null,null,null,"Summe",{"$f":"IF(Schularbeitsplaner!$F$35=\"Gesamtverrechnung\",\"GV\",\"RP-Modell\")","v":"RP-Modell"},"SiK","EA","A&L","SSM","SR","Σ","EA","A&L","SSM","SR","Σ","Summe",{"$f":"IF(Schularbeitsplaner!$F$35=\"Gesamtverrechnung\",\"GV\",\"RP-Modell\")","v":"RP-Modell"},null,"Summe",{"$f":"IF(Schularbeitsplaner!$F$35=\"Gesamtverrechnung\",\"GV\",\"RP-Modell\")","v":"RP-Modell"},{"$f":"IF(Schularbeitsplaner!$F$35=\"Gesamtverrechnung\",\"GV\",\"RP-Modell\")","v":"RP-Modell"}]
[null,null,"Anzahl der Items",null,{"$f":"E12","v":15},{"$f":"F12","v":13},{"$f":"G6","v":0},{"$f":"H14","v":100},{"$f":"I12","v":25},10,10,10,10,40,10,10,10,10,40,{"$f":"I12+J12+O12","v":65},{"$f":"U14","v":100},null,{"$f":"X14","v":200},{"$f":"X14","v":200}]
[null,null,"Name","Vorname"]
[null,1,"Hafner","Christin",10,11,{"$f":"IF(COUNT($E23:$F23)>0,$E23*$E$13*Schularbeitsplaner!C$10+$F23*$F$13*Schularbeitsplaner!C$16,\"\")","v":75.641025641025635},{"$f":"IF(COUNT(E23:F23)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G23,IF(G23>G$16,G23,0)),\"\")","v":75.641025641025635},12,9,8,6,7,{"$f":"IF(COUNT(J23:M23)>0,IF(J23>0,SUM(J23:M23)*Schularbeitsplaner!C$30,0),\"\")","v":30},null,null,null,null,{"$f":"IF(COUNT(O23:R23)>0,IF(O23>0,(O23+P23+Q23+R23)*Schularbeitsplaner!C$31,0),\"\")","v":""},{"$f":"IF(COUNT(I23,N23,S23)>0,I23*$I$13+SUM(J23:M23)*$J$13+SUM(O23:R23)*$O$13,\"\")","v":61.5},{"$f":"IF(COUNT(I23:M23,O23:R23)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T23,IF(T23>=T$16,T23,0)),\"\")","v":61.5},null,{"$f":"SUM(G23,T23)","v":137.14102564102564},{"$f":"IF(COUNT(H23,U23)>0,SUM(H23,U23),\"\")","v":137.14102564102564},{"$f":"IF(COUNT(X23)=0,\"\",IF(X23<$Y$7,\"5\",IF(X23<$Y$6,\"4\",IF(X23<$Y$5,\"3\",IF(X23<$Y$4,\"2\",IF(X23<=$Y$3,\"1\",\"\"))))))","v":"4"}]
[null,{"$f":"B23+1","v":2},"Hafner","Karl",12,11,{"$f":"IF(COUNT($E24:$F24)>0,$E24*$E$13*Schularbeitsplaner!C$10+$F24*$F$13*Schularbeitsplaner!C$16,\"\")","v":82.307692307692307},{"$f":"IF(COUNT(E24:F24)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G24,IF(G24>G$16,G24,0)),\"\")","v":82.307692307692307},12,6,6,6,6,{"$f":"IF(COUNT(J24:M24)>0,IF(J24>0,SUM(J24:M24)*Schularbeitsplaner!C$30,0),\"\")","v":24},null,null,null,null,{"$f":"IF(COUNT(O24:R24)>0,IF(O24>0,(O24+P24+Q24+R24)*Schularbeitsplaner!C$31,0),\"\")","v":""},{"$f":"IF(COUNT(I24,N24,S24)>0,I24*$I$13+SUM(J24:M24)*$J$13+SUM(O24:R24)*$O$13,\"\")","v":54},{"$f":"IF(COUNT(I24:M24,O24:R24)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T24,IF(T24>=T$16,T24,0)),\"\")","v":54},null,{"$f":"SUM(G24,T24)","v":136.30769230769232},{"$f":"IF(COUNT(H24,U24)>0,SUM(H24,U24),\"\")","v":136.30769230769232},"4"]
[null,{"$f":"B24+1","v":3},null,null,null,null,{"$f":"IF(COUNT($E25:$F25)>0,$E25*$E$13*Schularbeitsplaner!C$10+$F25*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E25:F25)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G25,IF(G25>G$16,G25,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J25:M25)>0,IF(J25>0,SUM(J25:M25)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O25:R25)>0,IF(O25>0,(O25+P25+Q25+R25)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I25:M25,O25:R25)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T25,IF(T25>=T$16,T25,0)),\"\")","v":""},null,0,"",""]
[null,4,null,null,null,null,{"$f":"IF(COUNT($E26:$F26)>0,$E26*$E$13*Schularbeitsplaner!C$10+$F26*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E26:F26)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G26,IF(G26>G$16,G26,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J26:M26)>0,IF(J26>0,SUM(J26:M26)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O26:R26)>0,IF(O26>0,(O26+P26+Q26+R26)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I26:M26,O26:R26)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T26,IF(T26>=T$16,T26,0)),\"\")","v":""},null,0,"",""]
[null,5,null,null,null,null,{"$f":"IF(COUNT($E27:$F27)>0,$E27*$E$13*Schularbeitsplaner!C$10+$F27*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E27:F27)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G27,IF(G27>G$16,G27,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J27:M27)>0,IF(J27>0,SUM(J27:M27)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O27:R27)>0,IF(O27>0,(O27+P27+Q27+R27)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I27:M27,O27:R27)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T27,IF(T27>=T$16,T27,0)),\"\")","v":""},null,0,"",""]
[null,6,null,null,null,null,{"$f":"IF(COUNT($E28:$F28)>0,$E28*$E$13*Schularbeitsplaner!C$10+$F28*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E28:F28)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G28,IF(G28>G$16,G28,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J28:M28)>0,IF(J28>0,SUM(J28:M28)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O28:R28)>0,IF(O28>0,(O28+P28+Q28+R28)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I28:M28,O28:R28)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T28,IF(T28>=T$16,T28,0)),\"\")","v":""},null,0,"",""]
[null,7,null,null,null,null,{"$f":"IF(COUNT($E29:$F29)>0,$E29*$E$13*Schularbeitsplaner!C$10+$F29*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E29:F29)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G29,IF(G29>G$16,G29,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J29:M29)>0,IF(J29>0,SUM(J29:M29)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O29:R29)>0,IF(O29>0,(O29+P29+Q29+R29)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I29:M29,O29:R29)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T29,IF(T29>=T$16,T29,0)),\"\")","v":""},null,0,"",""]
[null,8,null,null,null,null,{"$f":"IF(COUNT($E30:$F30)>0,$E30*$E$13*Schularbeitsplaner!C$10+$F30*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E30:F30)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G30,IF(G30>G$16,G30,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J30:M30)>0,IF(J30>0,SUM(J30:M30)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O30:R30)>0,IF(O30>0,(O30+P30+Q30+R30)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I30:M30,O30:R30)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T30,IF(T30>=T$16,T30,0)),\"\")","v":""},null,0,"",""]
[null,9,null,null,null,null,{"$f":"IF(COUNT($E31:$F31)>0,$E31*$E$13*Schularbeitsplaner!C$10+$F31*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E31:F31)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G31,IF(G31>G$16,G31,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J31:M31)>0,IF(J31>0,SUM(J31:M31)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O31:R31)>0,IF(O31>0,(O31+P31+Q31+R31)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I31:M31,O31:R31)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T31,IF(T31>=T$16,T31,0)),\"\")","v":""},null,0,"",""]
[null,10,null,null,null,null,{"$f":"IF(COUNT($E32:$F32)>0,$E32*$E$13*Schularbeitsplaner!C$10+$F32*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E32:F32)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G32,IF(G32>G$16,G32,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J32:M32)>0,IF(J32>0,SUM(J32:M32)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O32:R32)>0,IF(O32>0,(O32+P32+Q32+R32)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I32:M32,O32:R32)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T32,IF(T32>=T$16,T32,0)),\"\")","v":""},null,0,"",""]
[null,11,null,null,null,null,{"$f":"IF(COUNT($E33:$F33)>0,$E33*$E$13*Schularbeitsplaner!C$10+$F33*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E33:F33)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G33,IF(G33>G$16,G33,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J33:M33)>0,IF(J33>0,SUM(J33:M33)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O33:R33)>0,IF(O33>0,(O33+P33+Q33+R33)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I33:M33,O33:R33)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T33,IF(T33>=T$16,T33,0)),\"\")","v":""},null,0,"",""]
[null,12,null,null,null,null,{"$f":"IF(COUNT($E34:$F34)>0,$E34*$E$13*Schularbeitsplaner!C$10+$F34*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E34:F34)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G34,IF(G34>G$16,G34,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J34:M34)>0,IF(J34>0,SUM(J34:M34)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O34:R34)>0,IF(O34>0,(O34+P34+Q34+R34)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I34:M34,O34:R34)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T34,IF(T34>=T$16,T34,0)),\"\")","v":""},null,0,"",""]
[null,13,null,null,null,null,{"$f":"IF(COUNT($E35:$F35)>0,$E35*$E$13*Schularbeitsplaner!C$10+$F35*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E35:F35)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G35,IF(G35>G$16,G35,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J35:M35)>0,IF(J35>0,SUM(J35:M35)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O35:R35)>0,IF(O35>0,(O35+P35+Q35+R35)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I35:M35,O35:R35)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T35,IF(T35>=T$16,T35,0)),\"\")","v":""},null,0,"",""]
[null,14,null,null,null,null,{"$f":"IF(COUNT($E36:$F36)>0,$E36*$E$13*Schularbeitsplaner!C$10+$F36*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E36:F36)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G36,IF(G36>G$16,G36,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J36:M36)>0,IF(J36>0,SUM(J36:M36)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O36:R36)>0,IF(O36>0,(O36+P36+Q36+R36)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I36:M36,O36:R36)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T36,IF(T36>=T$16,T36,0)),\"\")","v":""},null,0,"",""]
[null,15,null,null,null,null,{"$f":"IF(COUNT($E37:$F37)>0,$E37*$E$13*Schularbeitsplaner!C$10+$F37*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E37:F37)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G37,IF(G37>G$16,G37,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J37:M37)>0,IF(J37>0,SUM(J37:M37)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O37:R37)>0,IF(O37>0,(O37+P37+Q37+R37)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I37:M37,O37:R37)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T37,IF(T37>=T$16,T37,0)),\"\")","v":""},null,0,"",""]
[null,16,null,null,null,null,{"$f":"IF(COUNT($E38:$F38)>0,$E38*$E$13*Schularbeitsplaner!C$10+$F38*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E38:F38)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G38,IF(G38>G$16,G38,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J38:M38)>0,IF(J38>0,SUM(J38:M38)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O38:R38)>0,IF(O38>0,(O38+P38+Q38+R38)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I38:M38,O38:R38)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T38,IF(T38>=T$16,T38,0)),\"\")","v":""},null,0,"",""]
[null,17,null,null,null,null,{"$f":"IF(COUNT($E39:$F39)>0,$E39*$E$13*Schularbeitsplaner!C$10+$F39*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E39:F39)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G39,IF(G39>G$16,G39,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J39:M39)>0,IF(J39>0,SUM(J39:M39)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O39:R39)>0,IF(O39>0,(O39+P39+Q39+R39)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I39:M39,O39:R39)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T39,IF(T39>=T$16,T39,0)),\"\")","v":""},null,0,"",""]
[null,18,null,null,null,null,{"$f":"IF(COUNT($E40:$F40)>0,$E40*$E$13*Schularbeitsplaner!C$10+$F40*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E40:F40)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G40,IF(G40>G$16,G40,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J40:M40)>0,IF(J40>0,SUM(J40:M40)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O40:R40)>0,IF(O40>0,(O40+P40+Q40+R40)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I40:M40,O40:R40)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T40,IF(T40>=T$16,T40,0)),\"\")","v":""},null,0,"",""]
[null,19,null,null,null,null,{"$f":"IF(COUNT($E41:$F41)>0,$E41*$E$13*Schularbeitsplaner!C$10+$F41*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E41:F41)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G41,IF(G41>G$16,G41,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J41:M41)>0,IF(J41>0,SUM(J41:M41)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O41:R41)>0,IF(O41>0,(O41+P41+Q41+R41)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I41:M41,O41:R41)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T41,IF(T41>=T$16,T41,0)),\"\")","v":""},null,0,"",""]
[null,20,null,null,null,null,{"$f":"IF(COUNT($E42:$F42)>0,$E42*$E$13*Schularbeitsplaner!C$10+$F42*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E42:F42)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G42,IF(G42>G$16,G42,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J42:M42)>0,IF(J42>0,SUM(J42:M42)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O42:R42)>0,IF(O42>0,(O42+P42+Q42+R42)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I42:M42,O42:R42)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T42,IF(T42>=T$16,T42,0)),\"\")","v":""},null,0,"",""]
[null,21,null,null,null,null,{"$f":"IF(COUNT($E43:$F43)>0,$E43*$E$13*Schularbeitsplaner!C$10+$F43*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E43:F43)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G43,IF(G43>G$16,G43,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J43:M43)>0,IF(J43>0,SUM(J43:M43)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O43:R43)>0,IF(O43>0,(O43+P43+Q43+R43)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I43:M43,O43:R43)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T43,IF(T43>=T$16,T43,0)),\"\")","v":""},null,0,"",""]
[null,22,null,null,null,null,{"$f":"IF(COUNT($E44:$F44)>0,$E44*$E$13*Schularbeitsplaner!C$10+$F44*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E44:F44)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G44,IF(G44>G$16,G44,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J44:M44)>0,IF(J44>0,SUM(J44:M44)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O44:R44)>0,IF(O44>0,(O44+P44+Q44+R44)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I44:M44,O44:R44)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T44,IF(T44>=T$16,T44,0)),\"\")","v":""},null,0,"",""]
[null,23,null,null,null,null,{"$f":"IF(COUNT($E45:$F45)>0,$E45*$E$13*Schularbeitsplaner!C$10+$F45*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E45:F45)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G45,IF(G45>G$16,G45,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J45:M45)>0,IF(J45>0,SUM(J45:M45)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O45:R45)>0,IF(O45>0,(O45+P45+Q45+R45)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I45:M45,O45:R45)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T45,IF(T45>=T$16,T45,0)),\"\")","v":""},null,0,"",""]
[null,24,null,null,null,null,{"$f":"IF(COUNT($E46:$F46)>0,$E46*$E$13*Schularbeitsplaner!C$10+$F46*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E46:F46)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G46,IF(G46>G$16,G46,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J46:M46)>0,IF(J46>0,SUM(J46:M46)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O46:R46)>0,IF(O46>0,(O46+P46+Q46+R46)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I46:M46,O46:R46)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T46,IF(T46>=T$16,T46,0)),\"\")","v":""},null,0,"",""]
[null,25,null,null,null,null,{"$f":"IF(COUNT($E47:$F47)>0,$E47*$E$13*Schularbeitsplaner!C$10+$F47*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E47:F47)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G47,IF(G47>G$16,G47,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J47:M47)>0,IF(J47>0,SUM(J47:M47)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O47:R47)>0,IF(O47>0,(O47+P47+Q47+R47)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I47:M47,O47:R47)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T47,IF(T47>=T$16,T47,0)),\"\")","v":""},null,0,"",""]
[null,26,null,null,null,null,{"$f":"IF(COUNT($E48:$F48)>0,$E48*$E$13*Schularbeitsplaner!C$10+$F48*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E48:F48)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G48,IF(G48>G$16,G48,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J48:M48)>0,IF(J48>0,SUM(J48:M48)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O48:R48)>0,IF(O48>0,(O48+P48+Q48+R48)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I48:M48,O48:R48)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T48,IF(T48>=T$16,T48,0)),\"\")","v":""},null,0,"",""]
[null,27,null,null,null,null,{"$f":"IF(COUNT($E49:$F49)>0,$E49*$E$13*Schularbeitsplaner!C$10+$F49*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E49:F49)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G49,IF(G49>G$16,G49,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J49:M49)>0,IF(J49>0,SUM(J49:M49)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O49:R49)>0,IF(O49>0,(O49+P49+Q49+R49)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I49:M49,O49:R49)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T49,IF(T49>=T$16,T49,0)),\"\")","v":""},null,0,"",""]
[null,28,null,null,null,null,{"$f":"IF(COUNT($E50:$F50)>0,$E50*$E$13*Schularbeitsplaner!C$10+$F50*$F$13*Schularbeitsplaner!C$16,\"\")","v":""},{"$f":"IF(COUNT(E50:F50)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",G50,IF(G50>G$16,G50,0)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNT(J50:M50)>0,IF(J50>0,SUM(J50:M50)*Schularbeitsplaner!C$30,0),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNT(O50:R50)>0,IF(O50>0,(O50+P50+Q50+R50)*Schularbeitsplaner!C$31,0),\"\")","v":""},"",{"$f":"IF(COUNT(I50:M50,O50:R50)>0,IF(Schularbeitsplaner!F$35=\"Gesamtverrechnung\",T50,IF(T50>=T$16,T50,0)),\"\")","v":""},null,0,"",""]
[null,null,null,null,{"$f":"E53","v":73.333333333333329},{"$f":"F53","v":84.615384615384613},{"$f":"I53","v":48},{"$f":"N53","v":67.5},{"$f":"S53","v":0}]
[null,null,"Mittelwerte ",null,{"$f":"IF(COUNT(E23:E50)>0,AVERAGE(E23:E50),0)","v":11},{"$f":"IF(COUNT(F23:F50)>0,AVERAGE(F23:F50),0)","v":11},78.974358974358978,78.974358974358978,12,7.5,7,6,6.5,27,0,0,0,0,0,57.75,57.75,null,{"$f":"AVERAGE(W23:W50)","v":9.7660256410256405},{"$f":"IF(COUNT(X23:X50)>0,AVERAGE(X23:X50),0)","v":136.72435897435898}]
[null,null,"in %",null,{"$f":"IF(E$21>0,E52/E$21*100,0)","v":73.333333333333329},{"$f":"IF(F$21>0,F52/F$21*100,0)","v":84.615384615384613},0,78.974358974358978,48,75,70,60,65,67.5,0,0,0,0,0,88.84615384615384,57.75,null,4.8830128205128203,68.362179487179489]

{"sheet":"Einzel","index":2,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,20,2,21],[15,11,15,21],[2,13,2,15],[2,17,2,18],[14,11,14,21],[13,17,13,19],[13,20,13,21],[3,13,3,14],[4,13,4,14],[5,13,5,14],[6,13,6,14],[7,13,7,14],[8,13,8,14],[9,13,9,14],[11,13,11,14],[13,13,13,14],[13,11,13,12],[15,2,29,4],[1,11,1,12],[10,13,10,14],[5,2,6,4],[7,2,7,4],[2,2,4,4],[8,2,8,3],[9,2,10,4]]}
[]
[]
[null,null,"Einzelauswertungen",null,null,null,null,null,null,null,null,"Schularbeit",{"$f":"Beurteilungsblatt!O8","v":2},"Hafner  Karl",null,null,null,"Klassenmittel",null,{"$f":"Beurteilungsblatt!I8","v":"7AB"},"Maximum"]
[null,null,null,null,null,null,null,null,null,null,null,"Bereich","Items","gewichtete \nPunkte",null,"LqK\n in %",null,"Items","gew.\nPunkte","LqK \nin %","Items","gew.\nPunkte"]
[null,null,null,null,null,null,null,null,null,null,null,"Lesen",12,{"$f":"ROUND(M5*Q5,1)","v":40},null,{"$f":"IF(V5>0,ROUND(N5/V5*100,3),0)","v":80},{"$f":"Beurteilungsblatt!E13","v":3.3333333333333335},{"$f":"Beurteilungsblatt!E52","v":11},{"$f":"ROUND(R5*Q5,1)","v":36.700000000000003},{"$f":"IF(V5>0,ROUND(S5/V5,3),0)","v":0.73399999999999999},{"$f":"Beurteilungsblatt!E12","v":15},{"$f":"U5*Q5","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,"Hören",11,{"$f":"ROUND(M6*Q6,1)","v":42.3},null,{"$f":"IF(V6>0,ROUND(N6/V6*100,3),0)","v":84.6},{"$f":"Beurteilungsblatt!F13","v":3.8461538461538463},{"$f":"Beurteilungsblatt!F52","v":11},{"$f":"ROUND(R6*Q6,1)","v":42.3},{"$f":"IF(V6>0,ROUND(S6/V6,3),0)","v":0.84599999999999997},{"$f":"Beurteilungsblatt!F12","v":13},{"$f":"U6*Q6","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,"rezeptiv",null,{"$f":"M5*Q5+M6*Q6","v":82.307692307692307},null,null,null,null,{"$f":"SUM(S5:S6)","v":79},null,null,{"$f":"SUM(V5:V6)","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,"SIK",12,{"$f":"M8*Q8","v":24},null,{"$f":"IF(V8>0,ROUND(N8/V8*100,3),0)","v":48},{"$f":"Beurteilungsblatt!I13","v":2},{"$f":"Beurteilungsblatt!I52","v":12},{"$f":"ROUND(R8*Q8,1)","v":24},0.48,{"$f":"Beurteilungsblatt!I12","v":25},{"$f":"U8*Q8","v":50}]
[null,null,"Schüler/in",null,null,null,null,null,null,null,null,"Schreiben 1",24,{"$f":"M9*Q9","v":30},null,{"$f":"IF(V9>0,ROUND(N9/V9*100,3),0)","v":60},{"$f":"Beurteilungsblatt!J13","v":1.25},{"$f":"Beurteilungsblatt!N52","v":27},{"$f":"ROUND(R9*Q9,1)","v":33.799999999999997},0.67600000000000005,{"$f":"Beurteilungsblatt!J12","v":40},{"$f":"U9*Q9","v":50}]
[null,null,{"$f":"N3","v":"Hafner  Karl"},null,null,null,null,null,null,null,null,"Schreiben 2",null,{"$f":"M10*Q10","v":0},null,{"$f":"IF(V10>0,ROUND(N10/V10*100,3),0)","v":0},{"$f":"Beurteilungsblatt!O13","v":1.25},{"$f":"Beurteilungsblatt!S52","v":0},{"$f":"ROUND(R10*Q10,1)","v":0},0,{"$f":"Beurteilungsblatt!O14","v":0},{"$f":"U10*Q10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"produktiv",null,{"$f":"M8*Q8+M9*Q9+M10*Q10","v":54},null,null,null,null,{"$f":"SUM(S8:S10)","v":57.8},null,null,{"$f":"SUM(V8:V10)","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,"gesamt",null,{"$f":"N7+N11","v":136.30769230769232},null,null,null,null,{"$f":"S7+S11","v":136.80000000000001},null,null,{"$f":"V7+V11","v":200}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Note",null,4,null,null,null,"Beurteilungsmodell",null,null,{"$f":"Beurteilungsblatt!$D$8","v":"RP-Modell"}]
[]
[null,null,"\nHinweis:\n\nSchritt 1\nAnklicken des Feldes \"Daten übertragen\"\n\nSchritt 2\nAuswahl einzelner Schüler/innen über die Katalognummer im Auswahlfeld",null,null,null,null,null,null,null,null,"Lösungsquote nach Kompetenzbereichen in % (LqK in %)"]
[null,null,null,null,null,null,null,null,null,null,null,"Lesen",{"$f":"$N$5","v":40},{"$f":"$P$5","v":80},{"$f":"$S$5","v":36.700000000000003},{"$f":"$T$5*100","v":73.400000000000006},{"$f":"$V$5","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,"Hören",{"$f":"$N$6","v":42.3},{"$f":"$P$6","v":84.6},{"$f":"$S$6","v":42.3},{"$f":"$T$6*100","v":84.6},{"$f":"$V$6","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,"SIK",{"$f":"$N$8","v":24},{"$f":"$P$8","v":48},{"$f":"$S$8","v":24},{"$f":"$T$8*100","v":48},{"$f":"$V$8","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,"Schreiben 1",{"$f":"$N$9","v":30},{"$f":"$P$9","v":60},{"$f":"$S$9","v":33.799999999999997},{"$f":"$T$9*100","v":67.600000000000009},{"$f":"$V$9","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,"Schreiben 2",{"$f":"$N$10","v":0},{"$f":"$P$10","v":0},{"$f":"$S$10","v":0},{"$f":"$T$10*100","v":0},{"$f":"$V$10","v":0}]