{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["úroveň B1","úroveň B2","úroveň C1"],"not_rendered":{"charts":0,"images":213,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"úroveň B1","index":0,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,27],[11,8,11,12],[8,15,8,19],[15,8,15,13],[17,9,18,10],[15,15,15,20],[17,16,18,18],[1,0,1,6],[1,7,1,13],[1,21,1,27],[11,1,11,5],[11,22,11,26],[1,14,1,20],[20,11,20,13],[20,8,20,9],[20,15,20,16],[20,18,20,20]]}
["Tabulka hodnocení psaní úrovně B1 dle komponent"]
["Splnění úkolu",null,null,null,null,null,null,"Organizace textu",null,null,null,null,null,null,"Lexikální prostředky",null,null,null,null,null,null,"Gramatické prostředky"]
[null,"dodržení tématu",null,null,null,null,null,null,"struktura",null,null,null,null,null,null,"rozsah",null,null,null,null,null,null,"rozsah"]
[]
[]
[null,"splnění kom. jaz. funkcí",null,null,null,null,null,null,"linearita",null,null,null,null,null,null,"správnost",null,null,null,null,null,null,"správnost"]
[]
[]
[null,"rozsah",null,null,null,null,null,null,"zákl. spojovací prostř.",null,null,null,null,null,null,"Průměr za kritérium:",null,null,null,null,null,null,"pravopis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(T3=\"\",T6=\"\"),\"#N/A\",AVERAGE(T3,T6))","v":"#N/A"}]
[]
[null,"Průměr za kritérium:",null,null,null,null,null,null,"Průměr za kritérium:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Průměr za kritérium:"]
[null,null,{"$f":"IF(AND(F3=\"\",F6=\"\",F9=\"\"),\"#N/A\",AVERAGE(F3,F6,F9))","v":"#N/A"},null,null,null,null,null,null,{"$f":"IF(AND(M3=\"\",M6=\"\",M9=\"\"),\"#N/A\",AVERAGE(M3,M6,M9))","v":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AA3=\"\",AA6=\"\",AA9=\"\"),\"#N/A\",AVERAGE(AA3,AA6,AA9))","v":"#N/A"}]
[]
[]
[null,null,{"$f":"R21/K21","v":1.25},null,null,null,null,null,"SOUČET CELKEM",null,null,null,null,null,null,"KONVERZE"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C13=\"#N/A\",J13=\"#N/A\",Q10=\"#N/A\",X13=\"#N/A\"),\"#N/A\",SUM(C13,J13,Q10,X13))","v":"#N/A"},null,null,null,null,null,null,{"$f":"IF(J18=\"#N/A\",\"#N/A\",ROUNDUP(J18*C16,0))","v":"#N/A"}]
[]
[]
[null,null,null,null,null,null,null,null,"maximum =",null,12,"bodů",null,null,null,"maximum =",null,15,"bodů"]

{"sheet":"úroveň B2","index":1,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,8,20,9],[20,11,20,13],[20,15,20,16],[20,18,20,20],[14,1,14,5],[11,8,11,12],[11,22,11,26],[15,8,15,13],[15,15,15,20],[17,9,18,10],[17,16,18,18],[8,15,8,19],[0,0,0,27],[1,0,1,6],[1,7,1,13],[1,14,1,20],[1,21,1,27]]}
["Tabulka hodnocení psaní úrovně B2 dle komponent"]
["Splnění úkolu",null,null,null,null,null,null,"Organizace textu",null,null,null,null,null,null,"Lexikální prostředky",null,null,null,null,null,null,"Gramatické prostředky"]
[null,"dodržení tématu",null,null,null,null,null,null,"struktura",null,null,null,null,null,null,"rozsah",null,null,null,null,null,null,"rozsah"]
[]
[]
[null,"splnění kom. jaz. funkcí",null,null,null,null,null,null,"koherence",null,null,null,null,null,null,"správnost",null,null,null,null,null,null,"správnost"]
[]
[]
[null,"registr",null,null,null,null,null,null,"koheze",null,null,null,null,null,null,"Průměr za kritérium:",null,null,null,null,null,null,"pravopis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(T3=\"\",T6=\"\"),\"#N/A\",AVERAGE(T3,T6))","v":"#N/A"}]
[]
[null,"rozsah",null,null,null,null,null,null,"Průměr za kritérium:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Průměr za kritérium:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M3=\"\",M6=\"\",M9=\"\"),\"#N/A\",AVERAGE(M3,M6,M9))","v":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AA3=\"\",AA6=\"\",AA9=\"\"),\"#N/A\",AVERAGE(AA3,AA6,AA9))","v":"#N/A"}]
[]
[null,"Průměr za kritérium:"]
[null,null,{"$f":"IF(AND(F3=\"\",F6=\"\",F9=\"\",F12=\"\"),\"#N/A\",AVERAGE(F3,F6,F9,F12))","v":"#N/A"},null,null,null,null,null,"SOUČET CELKEM",null,null,null,null,null,null,"KONVERZE"]
[]
[null,null,{"$f":"R21/K21","v":1.25},null,null,null,null,null,null,{"$f":"IF(OR(C16=\"#N/A\",J13=\"#N/A\",Q10=\"#N/A\",X13=\"#N/A\"),\"#N/A\",SUM(C16,J13,Q10,X13))","v":"#N/A"},null,null,null,null,null,null,{"$f":"IF(J18=\"#N/A\",\"#N/A\",ROUNDUP(J18*C18,0))","v":"#N/A"}]
[]
[]
[null,null,null,null,null,null,null,null,"maximum =",null,12,"bodů",null,null,null,"maximum =",null,15,"bodů"]

{"sheet":"úroveň C1","index":2,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":false,"merged":[[8,15,8,19],[0,0,0,27],[1,0,1,6],[1,7,1,13],[1,14,1,20],[1,21,1,27],[11,22,11,26],[14,1,14,5],[15,8,15,13],[15,15,15,20],[17,9,18,10],[17,16,18,18],[20,8,20,9],[20,11,20,13],[20,15,20,16],[20,18,20,20],[11,8,11,12]]}
["Tabulka hodnocení psaní úrovně C1 dle komponent"]
["Splnění úkolu",null,null,null,null,null,null,"Organizace textu",null,null,null,null,null,null,"Lexikální prostředky",null,null,null,null,null,null,"Gramatické prostředky"]
[null,"dodržení tématu",null,null,null,null,null,null,"struktura (obsahová)",null,null,null,null,null,null,"rozsah",null,null,null,null,null,null,"rozsah"]
[]
[]
[null,"splnění kom. jaz. funkcí",null,null,null,null,null,null,"koherence",null,null,null,null,null,null,"správnost",null,null,null,null,null,null,"správnost"]
[]
[]
[null,"registr",null,null,null,null,null,null,"koheze",null,null,null,null,null,null,"Průměr za kritérium:",null,null,null,null,null,null,"pravopis a interpunkce"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(T3=\"\",T6=\"\"),\"#N/A\",AVERAGE(T3,T6))","v":"#N/A"}]
[]
[null,"rozsah",null,null,null,null,null,null,"Průměr za kritérium:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Průměr za kritérium:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M3=\"\",M6=\"\",M9=\"\"),\"#N/A\",AVERAGE(M3,M6,M9))","v":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AA3=\"\",AA6=\"\",AA9=\"\"),\"#N/A\",AVERAGE(AA3,AA6,AA9))","v":"#N/A"}]
[]
[null,"Průměr za kritérium:"]
[null,null,{"$f":"IF(AND(F3=\"\",F6=\"\",F9=\"\",F12=\"\"),\"#N/A\",AVERAGE(F3,F6,F9,F12))","v":"#N/A"},null,null,null,null,null,"SOUČET CELKEM",null,null,null,null,null,null,"KONVERZE"]
[]
[null,null,{"$f":"R21/K21","v":1.6666666666666667},null,null,null,null,null,null,{"$f":"IF(OR(C16=\"#N/A\",J13=\"#N/A\",Q10=\"#N/A\",X13=\"#N/A\"),\"#N/A\",SUM(C16,J13,Q10,X13))","v":"#N/A"},null,null,null,null,null,null,{"$f":"IF(J18=\"#N/A\",\"#N/A\",ROUNDUP(J18*C18,0))","v":"#N/A"}]
[]
[]
[null,null,null,null,null,null,null,null,"maximum =",null,12,"bodů",null,null,null,"maximum =",null,20,"bodů"]