{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Pracovní doba"],"not_rendered":{"charts":0,"images":2,"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":"Pracovní doba","index":0,"n_rows":55,"n_cols":37,"rows_kept":55,"cut":false,"hidden":false,"merged":[[34,4,34,5],[35,4,35,5],[36,4,36,5],[29,4,29,5],[30,4,30,5],[44,4,44,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[13,9,13,11],[41,4,41,5],[42,4,42,5],[43,4,43,5],[33,4,33,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[31,4,31,5],[32,4,32,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[9,8,9,13],[11,4,11,8],[11,9,11,10],[11,11,11,12],[13,4,13,5],[14,4,14,5]]}
[]
[]
[null,null,null,"Měsíc:",1]
[null,null,null,"Rok:",2010,null,null,"S","státní svátek"]
[null,null,null,"Příchod:","07:30:00",null,null,"D","Dovolená"]
[null,null,null,"Přestávka:","11:30:00","-","12:00:00","N","Nemoc"]
[null,null,null,"Odchod:","16:00:00",null,null,"C","Služební cesta"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(E8=\"\",G8=\"So\",G8=\"Ne\",H8=\"S\",N8<>\"\"),\"\",$E$5)","v":""},{"$f":"IF(OR(E8=\"\",G8=\"So\",G8=\"Ne\",H8=\"S\",N8<>\"\"),\"\",$E$6)","v":""},"-",{"$f":"IF(OR(E8=\"\",G8=\"So\",G8=\"Ne\",H8=\"S\",N8<>\"\"),\"\",$G$6)","v":""},{"$f":"IF(OR(E8=\"\",G8=\"So\",G8=\"Ne\",H8=\"S\",N8<>\"\"),\"\",$E$7)","v":""},{"$f":"IF(H8=\"C\",\"Služební cesta\",IF(H8=\"D\",\"Dovolená\",IF(H8=\"N\",\"Nemoc\",\"\")))","v":""}]
[]
[null,null,null,null,null,null,null,null,"Evidence pracovní doby"]
[]
[null,null,null,"Jméno:",null,null,null,null,null,"Útvar:",null,null,null,"Období:",{"$f":"DATE(E4,E3,1)","v":"2010-01-01"}]
[]
[null,null,null,null,"Den",null,null,"S","Příchod","Pracovní přestávka",null,null,"Odchod","Dovolená\nNemoc\nSlužební cesta","Jiné \n(nařízená práce \npřesčas,...)",null,"Týdenní součty hodin"]
[null,null,null,null,1,null,{"$f":"IF(E15=\"\",E15,HLOOKUP(WEEKDAY(CONCATENATE(E15,\".\",$E$3,\".\",$E$4),2),$T$51:$Z$52,2))","v":"Pá"},null,{"$f":"IF(OR(E15=\"\",G15=\"So\",G15=\"Ne\",H15=\"S\",N15<>\"\"),\"\",$E$5)","v":"07:30:00"},{"$f":"IF(OR(E15=\"\",G15=\"So\",G15=\"Ne\",H15=\"S\",N15<>\"\"),\"\",$E$6)","v":"11:30:00"},"-",{"$f":"IF(OR(E15=\"\",G15=\"So\",G15=\"Ne\",H15=\"S\",N15<>\"\"),\"\",$G$6)","v":"12:00:00"},{"$f":"IF(OR(E15=\"\",G15=\"So\",G15=\"Ne\",H15=\"S\",N15<>\"\"),\"\",$E$7)","v":"16:00:00"},{"$f":"IF(H15=\"C\",\"Služební cesta\",IF(H15=\"D\",\"Dovolená\",IF(H15=\"N\",\"Nemoc\",\"\")))","v":""},null,null,{"$f":"IF(G15=\"Ne\",CONCATENATE(TEXT(INT(S15/60),\"0\"),\":\",TEXT(MOD(S15,60),\"00\")),\"\")","v":""},{"$f":"(IF(OR(I15=\"\",J15=\"\",L15=\"\",M15=\"\"),0,M15-I15 - (L15-J15)))","v":"08:00:00"},{"$f":"HOUR(R15)*60+MINUTE(R15)+IF(G15=\"Po\",0,S14)","v":480}]
[null,null,null,null,{"$f":"IF(E15<$AK$51,E15+1,\"\")","v":2},null,{"$f":"IF(E16=\"\",E16,HLOOKUP(WEEKDAY(CONCATENATE(E16,\".\",$E$3,\".\",$E$4),2),$T$51:$Z$52,2))","v":"So"},null,"","","-","","","",null,null,{"$f":"IF(G16=\"Ne\",CONCATENATE(TEXT(INT(S16/60),\"0\"),\":\",TEXT(MOD(S16,60),\"00\")),\"\")","v":""},"00:00:00",480]
[null,null,null,null,{"$f":"IF(E16<$AK$51,E16+1,\"\")","v":3},null,"Ne",null,"","","-","","","",null,null,"8:00","00:00:00",480]
[null,null,null,null,4,null,"Po",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",480]
[null,null,null,null,5,null,"Út",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",960]
[null,null,null,null,6,null,"St",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",1440]
[null,null,null,null,7,null,"Čt",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",1920]
[null,null,null,null,8,null,"Pá",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",2400]
[null,null,null,null,9,null,"So",null,"","","-","","","",null,null,"","00:00:00",2400]
[null,null,null,null,10,null,"Ne",null,"","","-","","","",null,null,"40:00","00:00:00",2400]
[null,null,null,null,11,null,"Po",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",480]
[null,null,null,null,12,null,"Út",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",960]
[null,null,null,null,13,null,"St",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",1440]
[null,null,null,null,14,null,"Čt",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",1920]
[null,null,null,null,15,null,"Pá",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",2400]
[null,null,null,null,16,null,"So",null,"","","-","","","",null,null,"","00:00:00",2400]
[null,null,null,null,17,null,"Ne",null,"","","-","","","",null,null,"40:00","00:00:00",2400]
[null,null,null,null,18,null,"Po",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",480]
[null,null,null,null,19,null,"Út",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",960]
[null,null,null,null,20,null,"St",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",1440]
[null,null,null,null,21,null,"Čt",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",1920]
[null,null,null,null,22,null,"Pá",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",2400]
[null,null,null,null,23,null,"So",null,"","","-","","","",null,null,"","00:00:00",2400]
[null,null,null,null,24,null,"Ne",null,"","","-","","","",null,null,"40:00","00:00:00",2400]
[null,null,null,null,25,null,"Po",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",480]
[null,null,null,null,26,null,"Út",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",960]
[null,null,null,null,27,null,"St",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",1440]
[null,null,null,null,28,null,"Čt",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",1920]
[null,null,null,null,29,null,"Pá",null,"07:30:00","11:30:00","-","12:00:00","16:00:00","",null,null,"","08:00:00",2400]
[null,null,null,null,30,null,"So",null,"","","-","","","",null,null,"","00:00:00",2400]
[null,null,null,null,{"$f":"IF(E44<$AK$51,E44+1,\"\")","v":31},null,"Ne",null,"","","-","","","",null,null,"40:00","00:00:00",2400]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Podpis zaměstnance:",".............................................",null,null,null,null,"Podpis nadřízeného:","............................................."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,null,null,null,null,null,null,null,null,null,"Dnů v měsíci:",{"$f":"VALUE(DAY(DATE($E$4,$E$3+1,1)-DATE($E$4,$E$3,1)))","v":31}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Po","Út","St","Čt","Pá","So","Ne"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Po","Út","St","Čt","Pá","So","Ne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7]