{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Radek N.","Martin D.","pracovní výkaz","pokyny k vyplnění"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Radek N.","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Radek Novák"]
[]
[null,null,null,null,null,null,null,null,"Počet hodin"]
[null,null,"2016-04-01",null,null,null,null,null,"00:00:00"]
[null,null,{"$f":"C5+1","v":"2016-04-02"},null,null,null,null,null,"08:30:00"]
[null,null,{"$f":"C6+1","v":"2016-04-03"},null,null,null,null,null,"07:15:00"]
[null,null,"2016-04-04",null,null,null,null,null,"02:45:00"]
[null,null,"2016-04-05",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-06",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-07",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-08",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-09",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-10",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-11",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-12",null,null,null,null,null,"05:30:00"]
[null,null,"2016-04-13",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-14",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-15",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-16",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-17",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-18",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-19",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-20",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-21",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-22",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-23",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-24",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-25",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-26",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-27",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-28",null,null,null,null,null,"00:00:00"]
[null,null,{"$f":"IF(DAY(DATE(YEAR($C$5),MONTH($C$5)+1,0))=28,\"\",C32+1)","v":"2016-04-29"},null,null,null,null,null,"00:00:00"]
[null,null,{"$f":"IF(DAY(DATE(YEAR($C$5),MONTH($C$5)+1,0))<30,\"\",C33+1)","v":"2016-04-30"},null,null,null,null,null,"00:00:00"]
[null,null,{"$f":"IF(DAY(DATE(YEAR($C$5),MONTH($C$5)+1,0))<31,\"\",C34+1)","v":""},null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I5:I35)","v":4.979166666666667}]

{"sheet":"Martin D.","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Martin Dvořák"]
[]
[null,null,null,null,null,null,null,null,"Počet hodin"]
[null,null,"2016-04-01",null,null,null,null,null,"00:00:00"]
[null,null,{"$f":"C5+1","v":"2016-04-02"},null,null,null,null,null,"07:15:00"]
[null,null,{"$f":"C6+1","v":"2016-04-03"},null,null,null,null,null,"05:45:00"]
[null,null,"2016-04-04",null,null,null,null,null,"07:15:00"]
[null,null,"2016-04-05",null,null,null,null,null,"05:45:00"]
[null,null,"2016-04-06",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-07",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-08",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-09",null,null,null,null,null,"08:45:00"]
[null,null,"2016-04-10",null,null,null,null,null,"07:15:00"]
[null,null,"2016-04-11",null,null,null,null,null,"08:45:00"]
[null,null,"2016-04-12",null,null,null,null,null,"03:00:00"]
[null,null,"2016-04-13",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-14",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-15",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-16",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-17",null,null,null,null,null,"07:15:00"]
[null,null,"2016-04-18",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-19",null,null,null,null,null,"05:45:00"]
[null,null,"2016-04-20",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-21",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-22",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-23",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-24",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-25",null,null,null,null,null,"08:30:00"]
[null,null,"2016-04-26",null,null,null,null,null,"00:00:00"]
[null,null,"2016-04-27",null,null,null,null,null,"04:00:00"]
[null,null,"2016-04-28",null,null,null,null,null,"04:00:00"]
[null,null,{"$f":"IF(DAY(DATE(YEAR($C$5),MONTH($C$5)+1,0))=28,\"\",C32+1)","v":"2016-04-29"},null,null,null,null,null,"08:30:00"]
[null,null,{"$f":"IF(DAY(DATE(YEAR($C$5),MONTH($C$5)+1,0))<30,\"\",C33+1)","v":"2016-04-30"},null,null,null,null,null,"05:30:00"]
[null,null,{"$f":"IF(DAY(DATE(YEAR($C$5),MONTH($C$5)+1,0))<31,\"\",C34+1)","v":""},null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I5:I35)","v":5.9687500000000018}]

{"sheet":"pracovní výkaz","index":2,"n_rows":31,"n_cols":35,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,1,24,2],[26,29,26,33],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[17,1,17,2],[4,2,4,6],[14,1,15,2],[14,3,14,33],[14,34,15,34],[16,1,16,2]]}
[]
[null,"Pracovní výkaz"]
[]
[]
[null,"Jméno:"]
[]
[null,"Stát","ČR"]
[]
[null,"Měsíc:",{"$f":"D16","v":"2016-04-01"}]
[]
[null,"Rok:",{"$f":"D16","v":"2016-04-01"}]
[]
[null,"Přehled odpracovaných hodin a nepřítomnosti"]
[]
[null,"Položka",null,"Počet hodin v kalendářním dni měsíce",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,"Celkem hodin za měsíc"]
[null,null,null,"2016-04-01",{"$f":"D16+1","v":"2016-04-02"},{"$f":"E16+1","v":"2016-04-03"},{"$f":"F16+1","v":"2016-04-04"},{"$f":"G16+1","v":"2016-04-05"},{"$f":"H16+1","v":"2016-04-06"},{"$f":"I16+1","v":"2016-04-07"},{"$f":"J16+1","v":"2016-04-08"},{"$f":"K16+1","v":"2016-04-09"},{"$f":"L16+1","v":"2016-04-10"},{"$f":"M16+1","v":"2016-04-11"},{"$f":"N16+1","v":"2016-04-12"},{"$f":"O16+1","v":"2016-04-13"},{"$f":"P16+1","v":"2016-04-14"},{"$f":"Q16+1","v":"2016-04-15"},{"$f":"R16+1","v":"2016-04-16"},{"$f":"S16+1","v":"2016-04-17"},{"$f":"T16+1","v":"2016-04-18"},{"$f":"U16+1","v":"2016-04-19"},{"$f":"V16+1","v":"2016-04-20"},{"$f":"W16+1","v":"2016-04-21"},{"$f":"X16+1","v":"2016-04-22"},{"$f":"Y16+1","v":"2016-04-23"},{"$f":"Z16+1","v":"2016-04-24"},{"$f":"AA16+1","v":"2016-04-25"},{"$f":"AB16+1","v":"2016-04-26"},{"$f":"AC16+1","v":"2016-04-27"},{"$f":"AD16+1","v":"2016-04-28"},{"$f":"IF(DAY(DATE(YEAR($D$16),MONTH($D$16)+1,0))=28,\"\",AE16+1)","v":"2016-04-29"},{"$f":"IF(DAY(DATE(YEAR($D$16),MONTH($D$16)+1,0))<30,\"\",AF16+1)","v":"2016-04-30"},{"$f":"IF(DAY(DATE(YEAR($D$16),MONTH($D$16)+1,0))<31,\"\",AG16+1)","v":""}]
[null,"Odpracované hodiny",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,{"$f":"SUM(D17:AH17)","v":0}]
[null,"Placený svátek",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,{"$f":"SUM(D18:AH18)","v":0}]
[null,"Dovolená",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,0]
[null,"Lékař",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,0]
[null,"Pracovní cesta",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,0]
[null,"Placené volno",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,0]
[null,"Neplacené volno",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,0]
[null,"Ošetřování člena rodiny",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,0]
[null,"Nemoc",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,0]
[]
[null,"Datum:",{"$f":"TODAY()","v":"2016-05-05"},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,"Fond pracovní doby",null,null,null,null,{"$f":"SUM(AI17:AI25)","v":0}]
[]
[null,"Podpis zaměstnance:",null," .........................................."]
[]
[null,"Podpis nadřízeného:",null," .........................................."]

{"sheet":"pokyny k vyplnění","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]
["nějaký text","nějaký text","nějaký text","nějaký text","nějaký text"]