{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["1.Semester","2.Semester","Matura","Tabelle5","Tabelle6","Tabelle7","Tabelle8","Tabelle9","Tabelle10","Tabelle11","Tabelle12","Tabelle13","Tabelle14","Tabelle15","Tabelle16"],"not_rendered":{"charts":1,"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"1.Semester","index":0,"n_rows":59,"n_cols":27,"rows_kept":59}
["Schuljahr : 201x / 201y","1.Semester",null,"Thema 1",null,"Thema 2",null,"Thema 3",null,"Thema 4"]
[{"$f":"\"Anzahl = \" & COUNTA(A5:A29)","v":"Anzahl = 2"},null,null,"Datum",null,"Datum",null,"Datum",null,"Datum",{"$nulls":7},"Nebenrechnung Gewichte",{"$nulls":5},"Nebenrechnung gewichtete Noten"]
[{"$nulls":3},"Gewicht",1,"Gewicht",1,"Gewicht",1,"Gewicht",1]
["Name","Zeugnis\ngerundet","Zeugnis","Punkte1","N1","Punkte2","N2","Punkte3","N3","Punkte4","N4","Gewicht-summe","Nach-Name",null,"Bemerkungen",null,null,"Gewicht-summe","G1","G2","G3","G4",null,"N1","N2","N3","N4"]
["Beispiel Hans",{"$f":"IF(C5=\"\",\"\",ROUND((C5*2),0)/2)","v":3},{"$f":"IF(L5=0,\"\", ROUND( (X5+Y5+Z5+AA5)/L5,2))","v":3.08},2,{"$f":"IF(D5=\"\",\"\",IF(D5<=$D$34,ROUND((3/$D$34*D5)+1,1), ROUND(2/($D$33-$D$34)*(D5-$D$34) + 4,1)))","v":1.4},12,{"$f":"IF(F5=\"\",\"\",IF(F5<=$F$34,ROUND((3/$F$34*F5)+1,1), ROUND(2/($F$33-$F$34)*(F5-$F$34) + 4,2)))","v":4.25},12,{"$f":"IF(H5=\"\",\"\",IF(H5<=$H$34,ROUND((3/$H$34*H5)+1,1), ROUND(2/($H$33-$H$34)*(H5-$H$34) + 4,2)))","v":3.6},null,{"$f":"IF(J5=\"\",\"\",IF(J5<=$J$34,ROUND((3/$J$34*J5)+1,1), ROUND(2/($J$33-$J$34)*(J5-$J$34) + 4,2)))","v":""},{"$f":"R5","v":3},{"$f":"IF(A5<>\"\",A5,\"\")","v":"Beispiel Hans"},{"$nulls":4},{"$f":"SUM(S5:V5)","v":3},{"$f":"IF(D5=\"\", 0, $E$3)","v":1},{"$f":"IF(F5=\"\", 0, $G$3)","v":1},{"$f":"IF(H5=\"\", 0, $I$3)","v":1},{"$f":"IF(J5=\"\", 0, $K$3)","v":0},null,{"$f":"IF(S5=0,0,S5*E5)","v":1.4},{"$f":"IF(T5=0,0,T5*G5)","v":4.25},{"$f":"IF(U5=0,0,U5*I5)","v":3.6},{"$f":"IF(V5=0,0,V5*K5)","v":0}]
["Unsinn Xaver",{"$f":"IF(C6=\"\",\"\",ROUND((C6*2),0)/2)","v":4.5},{"$f":"IF(L6=0,\"\", ROUND( (X6+Y6+Z6+AA6)/L6,2))","v":4.5},14,{"$f":"IF(D6=\"\",\"\",IF(D6<=$D$34,ROUND((3/$D$34*D6)+1,1), ROUND(2/($D$33-$D$34)*(D6-$D$34) + 4,1)))","v":4},15,{"$f":"IF(F6=\"\",\"\",IF(F6<=$F$34,ROUND((3/$F$34*F6)+1,1), ROUND(2/($F$33-$F$34)*(F6-$F$34) + 4,2)))","v":5},null,{"$f":"IF(H6=\"\",\"\",IF(H6<=$H$34,ROUND((3/$H$34*H6)+1,1), ROUND(2/($H$33-$H$34)*(H6-$H$34) + 4,2)))","v":""},null,{"$f":"IF(J6=\"\",\"\",IF(J6<=$J$34,ROUND((3/$J$34*J6)+1,1), ROUND(2/($J$33-$J$34)*(J6-$J$34) + 4,2)))","v":""},{"$f":"R6","v":2},{"$f":"IF(A6<>\"\",A6,\"\")","v":"Unsinn Xaver"},{"$nulls":4},2,{"$f":"IF(D6=\"\", 0, $E$3)","v":1},{"$f":"IF(F6=\"\", 0, $G$3)","v":1},{"$f":"IF(H6=\"\", 0, $I$3)","v":0},{"$f":"IF(J6=\"\", 0, $K$3)","v":0},null,{"$f":"IF(S6=0,0,S6*E6)","v":4},{"$f":"IF(T6=0,0,T6*G6)","v":5},{"$f":"IF(U6=0,0,U6*I6)","v":0},{"$f":"IF(V6=0,0,V6*K6)","v":0}]
[null,3.5,3.6,12,3.6,null,"",null,"",null,"",1,"",{"$nulls":4},1,1,0,0,0,null,3.6,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",{"$f":"R15","v":0},"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},{"$f":"SUM(S25:V25)","v":0},0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
[null,"","",null,"",null,"",null,"",null,"",0,"",{"$nulls":4},{"$f":"SUM(S29:V29)","v":0},0,0,0,0,null,0,0,0,0]
["Durchschnitt",{"$f":"IF(ISERROR(ROUND(AVERAGE(B5:B29),2)),\"\",ROUND(AVERAGE(B5:B29),2))","v":3.67},{"$f":"IF(ISERROR(ROUND(AVERAGE(C5:C29),2)),\"\",ROUND(AVERAGE(C5:C29),2))","v":3.73},{"$f":"IF(ISERROR(ROUND(AVERAGE(D5:D29),2)),\"\",ROUND(AVERAGE(D5:D29),2))","v":9.33},{"v":3,"d":"3.00"},13.5,4.63,12,3.6,"","",null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(N5:N29),2)),\"\",ROUND(AVERAGE(N5:N29),2))","v":""},{"$f":"IF(ISERROR(ROUND(AVERAGE(O5:O29),2)),\"\",ROUND(AVERAGE(O5:O29),2))","v":""},{"$f":"IF(ISERROR(ROUND(AVERAGE(P5:P29),2)),\"\",ROUND(AVERAGE(P5:P29),2))","v":""}]
["Stabwn",{"$f":"IF(ISERROR(ROUND(STDEVP(B5:B29),2)),\"\",ROUND(STDEVP(B5:B29),2))","v":0.62},{"$f":"IF(ISERROR(ROUND(STDEVP(C5:C29),2)),\"\",ROUND(STDEVP(C5:C29),2))","v":0.59},{"$f":"IF(ISERROR(ROUND(STDEVP(D5:D29),2)),\"\",ROUND(STDEVP(D5:D29),2))","v":5.25},1.14,1.5,0.38,0,0,"",""]
["Pmax",null,null,27,null,20,null,25]
["P Note 6",null,null,24,null,19,null,24]
["P Note 4",null,null,14,null,11,null,14]
[]
[]
[]
[]
[]
[]
[null,"Nicht gewertete Prüfungen (z. B. gefehlt) nicht eintragen, d.h. leer lassen "]
[null,"Ausdruck: Tabelle markieren und drucken."]
[null,"2 tes Semester ist in Tabelle 2 oder dieses Formular neu benutzen"]
[null,"Viel Spass ! Verbesserungswünsche mir sagen "]
[null,"Gruesse Peter"]
{"$rows_empty":13}
["ihgdef","k","m",null,"p"]

{"sheet":"2.Semester","index":1,"n_rows":34,"n_cols":29,"rows_kept":34,"merged":[[0,0,0,1],[1,0,1,1]]}
["Schuljahr : 201x / 201y",null,"2.Semester",null,null,"Thema 1",null,"Thema 2",null,"Thema 3",null,"Thema 4"]
[{"$f":"\"Anzahl = \" & COUNTA(B5:B24)","v":"Anzahl = 2"},{"$nulls":4},"Datum",null,"Datum",null,"Datum",null,"Datum",{"$nulls":7},"Nebenrechnung Gewichte",{"$nulls":5},"Nebenrechnung gewichtete Noten"]
[{"$nulls":5},"Gewicht",1,"Gewicht",1,"Gewicht",1,"Gewicht",1]
["h","Name","2.Sem\nZeugnis\ngerundet","2.Sem\nZeugnis","1.Sem\n Zeugnis","Punkte1","N1","Punkte2","N2","Punkte3","N3","Punkte4","N4","Gewicht-summe","Nach-Name",null,"Bemerkungen",null,null,"Gewicht-summe","G1","G2","G3","G4",null,"N1","N2","N3","N4"]
[{"$f":"IF(OR(C5=\"\",E5=\"\"),\"\",IF(C5>E5,\"k\",IF(C5=E5,\"g\",IF(C5<E5,\"m\"))))","v":"k"},"Beispiel Hans",{"$f":"IF(D5=\"\",\"\",ROUND((D5*2),0)/2)","v":5},{"$f":"IF(N5=0,\"\", ROUND( (Z5+AA5+AB5+AC5)/N5,2))","v":5.22},{"$f":"'1.Semester'!B5","v":3},15,{"$f":"IF(F5=\"\",\"\",IF(F5<=$F$34,ROUND((3/$F$34*F5)+1,1), ROUND(2/($F$33-$F$34)*(F5-$F$34) + 4,1)))","v":4.2},20,{"$f":"IF(H5=\"\",\"\",IF(H5<=$H$34,ROUND((3/$H$34*H5)+1,1), ROUND(2/($H$33-$H$34)*(H5-$H$34) + 4,2)))","v":6.25},20,{"$f":"IF(J5=\"\",\"\",IF(J5<=$J$34,ROUND((3/$J$34*J5)+1,1), ROUND(2/($J$33-$J$34)*(J5-$J$34) + 4,2)))","v":5.2},null,{"$f":"IF(L5=\"\",\"\",IF(L5<=$L$34,ROUND((3/$L$34*L5)+1,1), ROUND(2/($L$33-$L$34)*(L5-$L$34) + 4,2)))","v":""},{"$f":"T5","v":3},{"$f":"IF(B5<>\"\",B5,\"\")","v":"Beispiel Hans"},{"$nulls":4},{"$f":"SUM(U5:X5)","v":3},{"$f":"IF(F5=\"\", 0, $G$3)","v":1},{"$f":"IF(H5=\"\", 0, $I$3)","v":1},{"$f":"IF(J5=\"\", 0, $K$3)","v":1},{"$f":"IF(L5=\"\", 0, $M$3)","v":0},null,{"$f":"IF(U5=0,0,U5*G5)","v":4.2},{"$f":"IF(V5=0,0,V5*I5)","v":6.25},{"$f":"IF(W5=0,0,W5*K5)","v":5.2},{"$f":"IF(X5=0,0,X5*M5)","v":0}]
[{"$f":"IF(OR(C6=\"\",E6=\"\"),\"\",IF(C6>E6,\"k\",IF(C6=E6,\"g\",IF(C6<E6,\"m\"))))","v":"m"},"Unsinn Xaver",{"$f":"IF(D6=\"\",\"\",ROUND((D6*2),0)/2)","v":2},{"$f":"IF(N6=0,\"\", ROUND( (Z6+AA6+AB6+AC6)/N6,2))","v":2.17},{"$f":"'1.Semester'!B6","v":4.5},14,{"$f":"IF(F6=\"\",\"\",IF(F6<=$F$34,ROUND((3/$F$34*F6)+1,1), ROUND(2/($F$33-$F$34)*(F6-$F$34) + 4,1)))","v":4},1,{"$f":"IF(H6=\"\",\"\",IF(H6<=$H$34,ROUND((3/$H$34*H6)+1,1), ROUND(2/($H$33-$H$34)*(H6-$H$34) + 4,2)))","v":1.3},1,{"$f":"IF(J6=\"\",\"\",IF(J6<=$J$34,ROUND((3/$J$34*J6)+1,1), ROUND(2/($J$33-$J$34)*(J6-$J$34) + 4,2)))","v":1.2},null,{"$f":"IF(L6=\"\",\"\",IF(L6<=$L$34,ROUND((3/$L$34*L6)+1,1), ROUND(2/($L$33-$L$34)*(L6-$L$34) + 4,2)))","v":""},{"$f":"T6","v":3},{"$f":"IF(B6<>\"\",B6,\"\")","v":"Unsinn Xaver"},{"$nulls":4},3,{"$f":"IF(F6=\"\", 0, $G$3)","v":1},{"$f":"IF(H6=\"\", 0, $I$3)","v":1},{"$f":"IF(J6=\"\", 0, $K$3)","v":1},{"$f":"IF(L6=\"\", 0, $M$3)","v":0},null,{"$f":"IF(U6=0,0,U6*G6)","v":4},{"$f":"IF(V6=0,0,V6*I6)","v":1.3},{"$f":"IF(W6=0,0,W6*K6)","v":1.2},{"$f":"IF(X6=0,0,X6*M6)","v":0}]
["g",null,3.5,3.6,{"$f":"'1.Semester'!B7","v":3.5},12,3.6,null,"",null,"",null,"",1,"",{"$nulls":4},1,1,0,0,0,null,3.6,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B8","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B9","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B10","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B11","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B12","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B13","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B14","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B15","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B16","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B17","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B18","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B19","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B20","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B21","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B22","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B23","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B24","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B25","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},{"$f":"SUM(U25:X25)","v":0},0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B26","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B27","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B28","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},0,0,0,0,0,null,0,0,0,0]
["",null,"","",{"$f":"'1.Semester'!B29","v":""},null,"",null,"",null,"",null,"",0,"",{"$nulls":4},{"$f":"SUM(U29:X29)","v":0},0,0,0,0,null,0,0,0,0]
[null,"Durchschnitt",{"$f":"IF(ISERROR(ROUND(AVERAGE(C5:C29),2)),\"\",ROUND(AVERAGE(C5:C29),2))","v":3.5},{"$f":"IF(ISERROR(ROUND(AVERAGE(D5:D29),2)),\"\",ROUND(AVERAGE(D5:D29),2))","v":3.66},null,{"$f":"IF(ISERROR(ROUND(AVERAGE(F5:F29),2)),\"\",ROUND(AVERAGE(F5:F29),2))","v":13.67},3.93,10.5,3.78,10.5,3.2,"","",null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(P5:P29),2)),\"\",ROUND(AVERAGE(P5:P29),2))","v":""},{"$f":"IF(ISERROR(ROUND(AVERAGE(Q5:Q29),2)),\"\",ROUND(AVERAGE(Q5:Q29),2))","v":""},{"$f":"IF(ISERROR(ROUND(AVERAGE(R5:R29),2)),\"\",ROUND(AVERAGE(R5:R29),2))","v":""}]
[null,"Stabwn",{"$f":"IF(ISERROR(ROUND(STDEVP(C5:C29),2)),\"\",ROUND(STDEVP(C5:C29),2))","v":1.22},{"$f":"IF(ISERROR(ROUND(STDEVP(D5:D29),2)),\"\",ROUND(STDEVP(D5:D29),2))","v":1.25},null,{"$f":"IF(ISERROR(ROUND(STDEVP(F5:F29),2)),\"\",ROUND(STDEVP(F5:F29),2))","v":1.25},0.25,9.5,2.48,9.5,2,"",""]
[null,"Pmax",{"$nulls":3},27,null,20,null,25]
[null,"P Note 6",{"$nulls":3},24,null,19,null,24]
[null,"P Note 4",{"$nulls":3},14,null,11,null,14]

{"sheet":"Matura","index":2,"n_rows":22,"n_cols":9,"rows_kept":22}
["Notenzusammenfassung"]
["Name","1.Sem","2.Sem","ErfNote","MP","Fachnote"]
[null,{"$f":"'1.Semester'!B5","v":3},{"$f":"'2.Semester'!C5","v":5},{"$f":"ROUND( (B3+C3)/2,2)","v":4},null,{"$f":"ROUND((D3+E3)/2,1)","v":2},null,"Graphik:"]
[null,{"$f":"'1.Semester'!B6","v":4.5},{"$f":"'2.Semester'!C6","v":2},{"$f":"ROUND( (B4+C4)/2,2)","v":3.25},null,{"$f":"ROUND((D4+E4)/2,1)","v":1.6},null,"Note","Anzahl"]
[null,{"$f":"'1.Semester'!B7","v":3.5},{"$f":"'2.Semester'!C7","v":3.5},3.5,null,1.8,null,1,{"$f":"COUNTIF($E$3:$E$19,H5)","v":0}]
[null,{"$f":"'1.Semester'!B8","v":""},{"$f":"'2.Semester'!C8","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,1.5,{"$f":"COUNTIF($E$3:$E$19,H6)","v":0}]
[null,{"$f":"'1.Semester'!B9","v":""},{"$f":"'2.Semester'!C9","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,2,0]
[null,{"$f":"'1.Semester'!B10","v":""},{"$f":"'2.Semester'!C10","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,2.5,0]
[null,{"$f":"'1.Semester'!B11","v":""},{"$f":"'2.Semester'!C11","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,3,0]
[null,{"$f":"'1.Semester'!B12","v":""},{"$f":"'2.Semester'!C12","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,3.5,0]
[null,{"$f":"'1.Semester'!B13","v":""},{"$f":"'2.Semester'!C13","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,4,0]
[null,{"$f":"'1.Semester'!B14","v":""},{"$f":"'2.Semester'!C14","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,4.5,0]
[null,{"$f":"'1.Semester'!B15","v":""},{"$f":"'2.Semester'!C15","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,5,0]
[null,{"$f":"'1.Semester'!B16","v":""},{"$f":"'2.Semester'!C16","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,5.5,0]
[null,{"$f":"'1.Semester'!B17","v":""},{"$f":"'2.Semester'!C17","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,6,0]
[null,{"$f":"'1.Semester'!B18","v":""},{"$f":"'2.Semester'!C18","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[null,{"$f":"'1.Semester'!B19","v":""},{"$f":"'2.Semester'!C19","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[null,{"$f":"'1.Semester'!B20","v":""},{"$f":"'2.Semester'!C20","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[null,{"$f":"'[1]2.Semester'!G20","v":""},{"$f":"'[1]2.Semester'!C20","v":""},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[]
["Durchschnitt",{"$f":"ROUND(AVERAGE(B3:B19),2)","v":3.67},{"$f":"ROUND(AVERAGE(C3:C19),2)","v":3.5},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
["Stabwn",{"$f":"ROUND(STDEVP(B3:B19),2)","v":0.62},{"$f":"ROUND(STDEVP(C3:C19),2)","v":1.22},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]

{"sheet":"Tabelle5","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle6","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle7","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle8","index":6,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle9","index":7,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle10","index":8,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle11","index":9,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle12","index":10,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle13","index":11,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle14","index":12,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle15","index":13,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle16","index":14,"n_rows":0,"n_cols":0,"rows_kept":0}