{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["C01 2016"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"C01 2016","index":0,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[[45,0,45,1],[47,0,47,1],[9,4,9,5],[25,4,25,5],[9,2,9,3],[25,2,25,3],[43,0,43,1]]}
["C01"]
[]
["Název ústavu:",null,{"$f":"[1]EAVVYP72!$T$2","v":0}]
[]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Období od:",{"$f":"[1]EAVVYP72!$U$2","v":0}]
[{"$f":"CONCATENATE(\"A. Přehled čerpání mzdových prostředků v Kč a počtu zaměstnanců na pracovišti za období \",Q5,\" - \",Q6,\" podle zdroje financování\")","v":"A. Přehled čerpání mzdových prostředků v Kč a počtu zaměstnanců na pracovišti za období 0 - 0 podle zdroje financování"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Období do:",{"$f":"[1]EAVVYP72!$V$2","v":0}]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null," ","                 Počet zaměstnanců",null,null,null,null,null,null,null,null,null,null,null,null,"Mzdové","Prům."]
[null,null,"celkem",null,"VŠ vzděl.prac.výzk.útv.",null,"Tarifní ","Příplatek","Příplatek","Příplatky","Příplatek","Odměny","Náhrady","Mzdy","OON","prostředky ","měsíční"]
["řádek","Zdroje","prům.přep.","fyz.p.d.","prům.přep.","fyz.p.d.","mzda","za vedení","zvláštní","ostatní","osobní"," ","mzdy","celkem",null,"celkem","výdělek"]
[1,"celkové mzd.prostředky",{"$f":"[1]EAVVYP72!$B$2","v":0},{"$f":"[1]EAVVYP72!$C$2","v":0},{"$f":"[1]EAVVYP72!$D$2","v":0},{"$f":"[1]EAVVYP72!$E$2","v":0},{"$f":"[1]EAVVYP72!$F$2","v":0},{"$f":"[1]EAVVYP72!$H$2","v":0},{"$f":"[1]EAVVYP72!$I$2","v":0},{"$f":"[1]EAVVYP72!$J$2+[1]EAVVYP72!$K$2+[1]EAVVYP72!$R$2","v":0},{"$f":"[1]EAVVYP72!$G$2","v":0},{"$f":"[1]EAVVYP72!$L$2","v":0},{"$f":"[1]EAVVYP72!$M$2","v":0},{"$f":"[1]EAVVYP72!$O$2","v":0},{"$f":"[1]EAVVYP72!$N$2","v":0},{"$f":"N12+O12","v":0},{"$f":"[1]EAVVYP72!$S$2","v":0}]
[2,"zdroje - institucionální",{"$f":"[1]EAVVYP72!$B$3","v":0},{"$f":"[1]EAVVYP72!$C$3","v":0},{"$f":"[1]EAVVYP72!$D$3","v":0},{"$f":"[1]EAVVYP72!$E$3","v":0},{"$f":"[1]EAVVYP72!$F$3","v":0},{"$f":"[1]EAVVYP72!$H$3","v":0},{"$f":"[1]EAVVYP72!$I$3","v":0},{"$f":"[1]EAVVYP72!$J$3+[1]EAVVYP72!$K$3+[1]EAVVYP72!$R$3","v":0},{"$f":"[1]EAVVYP72!$G$3","v":0},{"$f":"[1]EAVVYP72!$L$3","v":0},{"$f":"[1]EAVVYP72!$M$3","v":0},{"$f":"[1]EAVVYP72!$O$3","v":0},{"$f":"[1]EAVVYP72!$N$3","v":0},{"$f":"N13+O13","v":0},{"$f":"[1]EAVVYP72!$S$3","v":0}]
[3,"zdroje - mimorozpočtové",{"$f":"[1]EAVVYP72!$B$4","v":0},{"$f":"[1]EAVVYP72!$C$4","v":0},{"$f":"[1]EAVVYP72!$D$4","v":0},{"$f":"[1]EAVVYP72!$E$4","v":0},{"$f":"[1]EAVVYP72!$F$4","v":0},{"$f":"[1]EAVVYP72!$H$4","v":0},{"$f":"[1]EAVVYP72!$I$4","v":0},{"$f":"[1]EAVVYP72!$J$4+[1]EAVVYP72!$K$4+[1]EAVVYP72!$R$4","v":0},{"$f":"[1]EAVVYP72!$G$4","v":0},{"$f":"[1]EAVVYP72!$L$4","v":0},{"$f":"[1]EAVVYP72!$M$4","v":0},{"$f":"[1]EAVVYP72!$O$4","v":0},{"$f":"[1]EAVVYP72!$N$4","v":0},0,{"$f":"[1]EAVVYP72!$S$4","v":0}]
[4,"kontrolní součet *",{"$f":"SUM(C13:C14)","v":0},{"$f":"SUM(D13:D14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["* řádek 4 se musí rovnat řádku 1"]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"B. Přehled čerpání mzdových prostředků v Kč a počtu zaměstnanců na pracovišti za období \",Q5,\" - \",Q6,\" podle kategorií\")","v":"B. Přehled čerpání mzdových prostředků v Kč a počtu zaměstnanců na pracovišti za období 0 - 0 podle kategorií"}]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null," ","                 Počet zaměstnanců",null,null,null,null,null,null,null,null,null,null,null,null,"Mzdové","Prům."]
[null,null,"celkem",null,"VŠ vzděl.prac.výzk.útv.",null,"Tarifní","Příplatek","Příplatek","Příplatky","Příplatek","Odměny","Náhrady","Mzdy","OON","prostředky ","měsíční"]
["řádek","Kategorie","prům.přep.","fyz.p.d.","prům.přep.","fyz.p.d.","mzda","za vedení","zvláštní","ostatní","osobní"," ","mzdy","celkem",null,"celkem","výdělek"]
[1,"celkem",{"$f":"[1]EAVVYP72!B5","v":0},{"$f":"[1]EAVVYP72!C5","v":0},{"$f":"[1]EAVVYP72!D5","v":0},{"$f":"[1]EAVVYP72!E5","v":0},{"$f":"[1]EAVVYP72!$F5","v":0},{"$f":"[1]EAVVYP72!$H5","v":0},{"$f":"[1]EAVVYP72!$I5","v":0},{"$f":"[1]EAVVYP72!$J5+[1]EAVVYP72!$K5+[1]EAVVYP72!$R5","v":0},{"$f":"[1]EAVVYP72!$G5","v":0},{"$f":"[1]EAVVYP72!$L5","v":0},{"$f":"[1]EAVVYP72!$M5","v":0},{"$f":"[1]EAVVYP72!$O5","v":0},{"$f":"[1]EAVVYP72!$N5","v":0},{"$f":"N28+O28","v":0},{"$f":"[1]EAVVYP72!$S5","v":0}]
[2,"0 - OON",{"$f":"IF([1]EAVVYP72!$B6=0,\"\",[1]EAVVYP72!$B6)","v":""},{"$f":"IF([1]EAVVYP72!$C6=0,\"\",[1]EAVVYP72!$C6)","v":""},{"$f":"IF([1]EAVVYP72!$D6=0,\"\",[1]EAVVYP72!$D6)","v":""},{"$f":"IF([1]EAVVYP72!$E6=0,\"\",[1]EAVVYP72!$E6)","v":""},{"$f":"IF([1]EAVVYP72!$F6=0,\"\",[1]EAVVYP72!$F6)","v":""},{"$f":"IF([1]EAVVYP72!$H6=0,\"\",[1]EAVVYP72!$H6)","v":""},{"$f":"IF([1]EAVVYP72!$I6=0,\"\",[1]EAVVYP72!$I6)","v":""},{"$f":"IF(([1]EAVVYP72!$J6+[1]EAVVYP72!$K6+[1]EAVVYP72!$R6)=0,\"\",[1]EAVVYP72!$J6+[1]EAVVYP72!$K6+[1]EAVVYP72!$R6)","v":""},{"$f":"IF([1]EAVVYP72!$G6=0,\"\",[1]EAVVYP72!$G6)","v":""},{"$f":"IF([1]EAVVYP72!$L6=0,\"\",[1]EAVVYP72!$L6)","v":""},{"$f":"IF([1]EAVVYP72!$M6=0,\"\",[1]EAVVYP72!$M6)","v":""},{"$f":"IF([1]EAVVYP72!$O6=0,\"\",[1]EAVVYP72!$O6)","v":""},{"$f":"[1]EAVVYP72!$N6","v":0},{"$f":"IF(N29=\"\",O29,N29+O29)","v":0},{"$f":"IF([1]EAVVYP72!$S6=0,\"\",[1]EAVVYP72!$S6)","v":""}]
[3,"1 - výzkumní pracovníci",{"$f":"[1]EAVVYP72!$B7","v":0},{"$f":"[1]EAVVYP72!C7","v":0},{"$f":"[1]EAVVYP72!D7","v":0},{"$f":"[1]EAVVYP72!E7","v":0},{"$f":"[1]EAVVYP72!$F7","v":0},{"$f":"[1]EAVVYP72!$H7","v":0},{"$f":"[1]EAVVYP72!$I7","v":0},{"$f":"[1]EAVVYP72!$J7+[1]EAVVYP72!$K7+[1]EAVVYP72!$R7","v":0},{"$f":"[1]EAVVYP72!$G7","v":0},{"$f":"[1]EAVVYP72!$L7","v":0},{"$f":"[1]EAVVYP72!$M7","v":0},{"$f":"[1]EAVVYP72!$O7","v":0},{"$f":"[1]EAVVYP72!$N7","v":0},{"$f":"N30+O30","v":0},{"$f":"[1]EAVVYP72!$S7","v":0}]
[4,"2 - ost.VŠ prac. výzkum. Útvarů",{"$f":"[1]EAVVYP72!$B8","v":0},{"$f":"[1]EAVVYP72!C8","v":0},{"$f":"[1]EAVVYP72!D8","v":0},{"$f":"[1]EAVVYP72!E8","v":0},{"$f":"[1]EAVVYP72!$F8","v":0},{"$f":"[1]EAVVYP72!$H8","v":0},{"$f":"[1]EAVVYP72!$I8","v":0},{"$f":"[1]EAVVYP72!$J8+[1]EAVVYP72!$K8+[1]EAVVYP72!$R8","v":0},{"$f":"[1]EAVVYP72!$G8","v":0},{"$f":"[1]EAVVYP72!$L8","v":0},{"$f":"[1]EAVVYP72!$M8","v":0},{"$f":"[1]EAVVYP72!$O8","v":0},{"$f":"[1]EAVVYP72!$N8","v":0},0,{"$f":"[1]EAVVYP72!$S8","v":0}]
[5,"3 - odborní pracovníci s VŠ",{"$f":"[1]EAVVYP72!$B9","v":0},{"$f":"[1]EAVVYP72!C9","v":0},null,null,{"$f":"[1]EAVVYP72!$F9","v":0},{"$f":"[1]EAVVYP72!$H9","v":0},{"$f":"[1]EAVVYP72!$I9","v":0},{"$f":"[1]EAVVYP72!$J9+[1]EAVVYP72!$K9+[1]EAVVYP72!$R9","v":0},{"$f":"[1]EAVVYP72!$G9","v":0},{"$f":"[1]EAVVYP72!$L9","v":0},{"$f":"[1]EAVVYP72!$M9","v":0},{"$f":"[1]EAVVYP72!$O9","v":0},{"$f":"[1]EAVVYP72!$N9","v":0},0,{"$f":"[1]EAVVYP72!$S9","v":0}]
[6,"4 - odborní prac. se SŠ a VOŠ",{"$f":"[1]EAVVYP72!$B10","v":0},{"$f":"[1]EAVVYP72!C10","v":0},null,null,{"$f":"[1]EAVVYP72!$F10","v":0},{"$f":"[1]EAVVYP72!$H10","v":0},{"$f":"[1]EAVVYP72!$I10","v":0},{"$f":"[1]EAVVYP72!$J10+[1]EAVVYP72!$K10+[1]EAVVYP72!$R10","v":0},{"$f":"[1]EAVVYP72!$G10","v":0},{"$f":"[1]EAVVYP72!$L10","v":0},{"$f":"[1]EAVVYP72!$M10","v":0},{"$f":"[1]EAVVYP72!$O10","v":0},{"$f":"[1]EAVVYP72!$N10","v":0},0,{"$f":"[1]EAVVYP72!$S10","v":0}]
[7,"5 - odb.prac. VaV se SŠ a VOŠ",{"$f":"[1]EAVVYP72!$B11","v":0},{"$f":"[1]EAVVYP72!C11","v":0},null,null,{"$f":"[1]EAVVYP72!$F11","v":0},{"$f":"[1]EAVVYP72!$H11","v":0},{"$f":"[1]EAVVYP72!$I11","v":0},{"$f":"[1]EAVVYP72!$J11+[1]EAVVYP72!$K11+[1]EAVVYP72!$R11","v":0},{"$f":"[1]EAVVYP72!$G11","v":0},{"$f":"[1]EAVVYP72!$L11","v":0},{"$f":"[1]EAVVYP72!$M11","v":0},{"$f":"[1]EAVVYP72!$O11","v":0},{"$f":"[1]EAVVYP72!$N11","v":0},0,{"$f":"[1]EAVVYP72!$S11","v":0}]
[8,"7 - technicko-hospodářští prac.",{"$f":"[1]EAVVYP72!$B12","v":0},{"$f":"[1]EAVVYP72!C12","v":0},null,null,{"$f":"[1]EAVVYP72!$F12","v":0},{"$f":"[1]EAVVYP72!$H12","v":0},{"$f":"[1]EAVVYP72!$I12","v":0},{"$f":"[1]EAVVYP72!$J12+[1]EAVVYP72!$K12+[1]EAVVYP72!$R12","v":0},{"$f":"[1]EAVVYP72!$G12","v":0},{"$f":"[1]EAVVYP72!$L12","v":0},{"$f":"[1]EAVVYP72!$M12","v":0},{"$f":"[1]EAVVYP72!$O12","v":0},{"$f":"[1]EAVVYP72!$N12","v":0},0,{"$f":"[1]EAVVYP72!$S12","v":0}]
[9,"8 - dělníci",{"$f":"[1]EAVVYP72!$B13","v":0},{"$f":"[1]EAVVYP72!C13","v":0},null,null,{"$f":"[1]EAVVYP72!$F13","v":0},{"$f":"[1]EAVVYP72!$H13","v":0},{"$f":"[1]EAVVYP72!$I13","v":0},{"$f":"[1]EAVVYP72!$J13+[1]EAVVYP72!$K13+[1]EAVVYP72!$R13","v":0},{"$f":"[1]EAVVYP72!$G13","v":0},{"$f":"[1]EAVVYP72!$L13","v":0},{"$f":"[1]EAVVYP72!$M13","v":0},{"$f":"[1]EAVVYP72!$O13","v":0},{"$f":"[1]EAVVYP72!$N13","v":0},0,{"$f":"[1]EAVVYP72!$S13","v":0}]
[10,"9 - provozní pracovníci",{"$f":"[1]EAVVYP72!$B14","v":0},{"$f":"[1]EAVVYP72!C14","v":0},null,null,{"$f":"[1]EAVVYP72!$F14","v":0},{"$f":"[1]EAVVYP72!$H14","v":0},{"$f":"[1]EAVVYP72!$I14","v":0},{"$f":"[1]EAVVYP72!$J14+[1]EAVVYP72!$K14+[1]EAVVYP72!$R14","v":0},{"$f":"[1]EAVVYP72!$G14","v":0},{"$f":"[1]EAVVYP72!$L14","v":0},{"$f":"[1]EAVVYP72!$M14","v":0},{"$f":"[1]EAVVYP72!$O14","v":0},{"$f":"[1]EAVVYP72!$N14","v":0},0,{"$f":"[1]EAVVYP72!$S14","v":0}]
[11,"kontrolní součet *",{"$f":"SUM(C29:C37)","v":0},{"$f":"SUM(D29:D37)","v":0},{"$f":"SUM(E29:E37)","v":0},{"$f":"SUM(F29:F37)","v":0},{"$f":"SUM(G29:G37)","v":0},{"$f":"SUM(H29:H37)","v":0},0,0,0,0,0,0,0,0]
[]
["* řádek 11 se musí rovnat řádku 1"]
[]
[null,null,null,null,null,null,null,null,null,null,"Legenda:"]
[null,null,null,null,null,null,null,null,null,null,"vyplnit žlutě vyznačené buňky a podpisové pole"]
["Vyhotovil:",null,{"$f":"[1]EAVVYP72!$X$2","v":0},null,null,null,null,null,null,null,"tabulka A. řádek 2 zdroje institucionální = mzdové prostředky  od zřizovatele"]
[null,null,null,null,null,null,null,null,null,null,"tabulka A. řádek 3 zdroje mimorozpočtové = veškeré ostatní mzdové prostředky"]
["Datum:",null,{"$f":"[1]EAVVYP72!$W$2","v":0},null,null,null,null,null,null,null,"tabulka A. zdroje - institucionální: článek 5, 6, 8, 9"]
[null,null,null,null,null,null,null,null,null,null,"tabulka A. zdroje - mimorozpočtové: článek 0, 3, 4, 7, 10"]
["Podpis a razítko:",null,null,null,null,null,null,null,null,null,"tabulka B. řádek 2 pouze sloupec 13 a 14,  řádek OON nesmí obsahovat jiné údaje.  "]
[null,null,null,null,null,null,null,null,null,null,"tabulka B. řádek 3 musí být shodný s VaV tabulka Celkem kategorie 1"]
[null,"Kontaktní údaje:",null,null,null,null,null,null,null,null,"tabulka B. řádek 4 musí být shodný s VaV tabulka Celkem kategorie 2"]
[null,null,null,null,null,null,null,null,null,null,"tabulka A. řádek 1 se musí rovnat tabulce B. řádek 1"]