{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Diktat 1"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Diktat 1","index":0,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[[22,3,22,4],[4,3,4,4],[0,0,1,1],[2,0,3,1],[2,2,3,2],[2,3,3,4],[1,3,1,4],[0,3,0,4]]}
["Diktat Bewertung",null,"Anzahl Worte","Bewertung",null,null,"sehr hart",null,1,3,0,1]
[null,null,40,5,null,null,"hart",null,2,8,1.4,"1-"]
["Überschrift und Datum eingeben",null,null,{"$f":"VLOOKUP(D2,I1:J5,2,0)/100","v":0.16},null,null,"normal",null,3,10,1.5,"2+"]
[null,null,null,null,null,{"$f":"A3","v":"Überschrift und Datum eingeben"},"milde",null,4,13,1.6,2]
["Name","Fehler","Schulnote","Notenspiegel",null,"Note","sehr milde",null,5,16,2.4,"2-"]
[null,null,{"$f":"IF(F9<>\"\",VLOOKUP(F9,$K$1:$L$16,2,1),\"\")","v":""},"Noten","Anzahl",null,null,null,null,null,2.5,"3+"]
[null,null,{"$f":"IF(F10<>\"\",VLOOKUP(F10,$K$1:$L$16,2,1),\"\")","v":""},1,{"$f":"COUNTIF(G9:G48,1)","v":0},null,null,null,null,null,2.6,3]
[null,null,"",2,{"$f":"COUNTIF(G9:G48,2)","v":0},null,null,null,null,null,3.4,"3-"]
[null,null,"",3,{"$f":"COUNTIF(G9:G48,3)","v":0},{"$f":"IF(B6<>\"\",IF(ROUND(1+(5*B6/($C$2*$D$3)),1)<=6.4,ROUND(1+(5*B6/($C$2*$D$3)),1),6.4),\"\")","v":""},{"$f":"IF(F9<>\"\",ROUND(F9,0),\"\")","v":""},null,null,null,3.5,"4+"]
[null,null,"",4,{"$f":"COUNTIF(G9:G48,4)","v":0},"","",null,null,null,3.6,4]
[null,null,"",5,{"$f":"COUNTIF(G9:G48,5)","v":0},"","",null,null,null,4.4000000000000004,"4-"]
[null,null,"",6,{"$f":"COUNTIF(G9:G48,6)","v":0},"","",null,null,null,4.5,"5+"]
[null,null,"","ø",{"$f":"IFERROR(ROUND(SUMPRODUCT(D7:D12,E7:E12)/COUNT(G9:G48),2),\"\")","v":""},"","",null,null,null,4.5999999999999996,5]
[null,null,"",null,null,"","",null,null,null,5.4,"5-"]
[null,null,"",null,null,"","",null,null,null,5.5,"6+"]
[null,null,"",null,null,"","",null,null,null,5.6,6]
[null,null,"",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":"A3","v":"Überschrift und Datum eingeben"},null,"",""]
[null,null,"",{"$f":"C1","v":"Anzahl Worte"},{"$f":"C2","v":40},"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,"",null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]