{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Údaje","DochList","DataRoku","InfoProg"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":41,"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":"Údaje","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,7,32,9]]}
["Údaje pracovníka:"]
[]
["Měsíc docházky (číslo):",1,null,null,null,null,null,"\nNávod na použití:\n\n1. Na listu ÚDAJE upravte modře podbarvená data ve sloupci B podle vašich podmínek; většinou jen jednou upravujete jméno, příjmení, zařazení a pracoviště.\n\n2. Máte-li v daném měsíci pravidelnou výuku a chcete-li této možnosti využít, zaškrtněte pole AKCEPTUJ PRAVIDELNÝ TÝDEN a upravte modře podbarvená data v tabulce PRAVIDELNÝ TÝDEN.\n\n3. Každý měsíc na listu ÚDAJE upravte požadovaný měsíc a stiskněte tlačítko PŘIPRAV. Tím se předepíše list docházky podle právě nastavených údajů.\n\n4. Přepněte se na docházkový list a v orámované žlutě podbarvené oblasti jednotlivých dnů (!) provádějte libovolné změny. Součty v dalších buňkách se přepočítávají samy.\n\n5. Činnosti 3. a 4. můžete libovolněkrát opakovat. Po dosažení požadovaného stavu docházku vytiskněte a podepište, sešit jako XLS(M) soubor zašlete paní sekretářce."]
["Rok docházky:",2021]
[]
["Fond prac. doby při 100% úvazku",{"$f":"homFPP(rgPozadMesic)","v":168}]
["Fond prac. doby při daném úvazku",{"$f":"B6/100*rgUvazek","v":168}]
[]
["Jméno:","Jan"]
["Příjmení:","Novák"]
[]
["Zařazení (THP, AP, D):","AP"]
["Úvazek %:",100]
["Stálé pracoviště:","A-999"]
[]
["Základní prac. doba OD (čas):","08:00:00"]
["Základní prac. doba DO (čas):","13:30:00"]
[]
["Volitelný začátek (čas):","07:00:00"]
["Začátek přestávky (čas):","11:30:00"]
["Konec přestávky (čas):",{"$f":"rgPrestZac+rgDelkaPrestavky/60/24","v":"12:00:00"}]
["Volitelný konec (čas):",{"$f":"rgStdZac+(rgStdDoba+rgDelkaPrestavky/60)/24","v":"15:30:00"},"Diference:"]
["Standardní doba (číslo):",{"$f":"rgUvazek*rgStdPracDoba/100","v":8},{"$f":"24*(rgStdKon-rgPrestKon+rgPrestZac-rgStdZac)-rgStdDoba","v":0}]
[]
["Pravidelný týden:","Příchod (čas)","Přest.od (čas)","Přest.do (čas)","Odchod (čas)","Odprac. (číslo)"]
["Po","06:30:00","12:30:00","13:00:00","17:00:00",{"$f":"24*(E26-D26+C26-B26)","v":10.000000000000004}]
["Út","07:30:00","14:00:00","14:30:00","17:00:00",{"$f":"24*(E27-D27+C27-B27)","v":9.0000000000000036}]
["St","08:00:00","12:00:00","12:30:00","13:30:00",5]
["Čt","08:00:00","12:00:00","12:30:00","13:30:00",5]
["Pá","06:30:00","12:00:00","12:30:00","18:00:00",11]
["Celkem týdně:",null,null,null,null,{"$f":"SUM(F26:F30)","v":40.000000000000007}]

{"sheet":"DochList","index":1,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[52,8,52,11],[51,8,51,11],[2,0,2,13],[53,4,53,7],[17,5,17,6],[50,4,50,7],[51,4,51,7],[17,0,18,0],[17,1,18,1],[17,7,18,7],[50,0,53,3],[17,8,18,8],[17,9,18,9],[17,10,18,10],[11,9,11,13],[17,11,18,11],[17,13,18,13],[14,1,14,5],[17,2,17,4],[14,9,14,13],[14,6,14,8],[17,12,18,12],[13,6,13,8],[53,8,53,13],[52,4,52,7],[4,1,4,5],[7,1,7,5],[5,1,5,5],[5,9,5,13],[13,1,13,5],[4,9,4,13],[8,1,8,5],[10,1,10,5],[11,1,11,5],[7,9,7,13],[10,9,10,13],[13,9,13,13],[8,9,8,13]]}
[]
[]
["Podklad pro evidenci odpracované doby v režimu pružné pracovní doby"]
[]
[null,{"$f":"UPPER(rgPrijmeniZam)&\" \"&rgJmenoZam","v":"NOVÁK Jan"},null,null,null,null,null,null,null,{"$f":"rgZarazZam","v":"AP"}]
[null,"příjmení a jméno",null,null,null,null,null,null,null,"pracovní zařazení (THP, AP, D)"]
[]
[null,"Institut geologického inženýrství",null,null,null,null,null,null,null,541]
[null,"útvar",null,null,null,null,null,null,null,"číslo"]
[]
[null,{"$f":"DATE(rgPozadRok,rgPozadMesic,1)","v":"2021-01-01"},{"$f":"DATE(rgPozadRok,rgPozadMesic,1)","v":"2021-01-01"},{"$f":"DATE(rgPozadRok,rgPozadMesic,1)","v":"2021-01-01"},{"$f":"DATE(rgPozadRok,rgPozadMesic,1)","v":"2021-01-01"},{"$f":"DATE(rgPozadRok,rgPozadMesic,1)","v":"2021-01-01"},null,null,null,{"$f":"rgPozadRok","v":2021}]
[null,"měsíc",null,null,null,null,null,null,null,"rok"]
[]
[null,{"$f":"TEXT(rgPPDod,\"hh:mm\")&\" - \"&TEXT(rgPPDdo,\"hh:mm\")","v":"08:00 - 13:30"},{"$f":"TEXT(rgPPDod,\"hh:mm\")","v":"08:00"},{"$f":"TEXT(rgPPDod,\"hh:mm\")","v":"08:00"},{"$f":"TEXT(rgPPDod,\"hh:mm\")","v":"08:00"},{"$f":"TEXT(rgPPDod,\"hh:mm\")","v":"08:00"},{"$f":"TEXT(rgPrestZac,\"hh:mm\")&\" - \"&TEXT(rgPrestKon,\"hh:mm\")","v":"11:30 - 12:00"},null,null,{"$f":"rgPracZam","v":"A-999"}]
[null,"základní pracovní doba",null,null,null,null,"Přestávka na jídlo",null,null,"stálé pracoviště"]
[]
[]
["dat.","Příchod","NEPŘÍTOMNOST",null,null,"Přestávka",null,"Odchod","Odprac. doba","Omluv. nepřít.","Nahraz. doba","Práce přesčas","Týdně","Poznámky"]
[null,null,"odch.","přích.","důvod","od","do"]
[1,"Svátek",null,null,null,null,null,null,8,null,null,null,null,"Nový Rok"]
[2,"Sobota"]
[3,"Neděle",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I20:L22)","v":8}]
[4,"06:10:00",null,null,null,"12:20:00","12:50:00","17:20:00",10.000000000000004]
[5,"07:10:00",null,null,null,"13:55:00","14:25:00","17:15:00",9.0000000000000036]
[6,"07:55:00",null,null,null,"11:40:00","12:10:00","13:40:00",5]
[7,"07:50:00",null,null,null,"11:45:00","12:15:00","13:50:00",5]
[8,"06:10:00",null,null,null,"11:45:00","12:15:00","18:05:00",11]
[9,"Sobota"]
[10,"Neděle",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I23:L29)","v":40.000000000000007}]
[11,"06:20:00",null,null,null,"12:10:00","12:40:00","17:05:00",10.000000000000004]
[12,"07:25:00",null,null,null,"13:45:00","14:15:00","17:10:00",9.0000000000000036]
[13,"07:55:00",null,null,null,"11:55:00","12:25:00","13:50:00",5]
[14,"07:55:00",null,null,null,"11:40:00","12:10:00","13:50:00",5]
[15,"06:10:00",null,null,null,"11:55:00","12:25:00","18:05:00",11]
[16,"Sobota"]
[17,"Neděle",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I30:L36)","v":40.000000000000007}]
[18,"06:20:00",null,null,null,"12:10:00","12:40:00","17:15:00",10.000000000000004]
[19,"07:15:00",null,null,null,"13:55:00","14:25:00","17:15:00",9.0000000000000036]
[20,"07:40:00",null,null,null,"11:40:00","12:10:00","13:45:00",5]
[21,"07:50:00",null,null,null,"11:45:00","12:15:00","13:45:00",5]
[22,"06:20:00",null,null,null,"11:50:00","12:20:00","18:15:00",11]
[23,"Sobota"]
[24,"Neděle",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I37:L43)","v":40.000000000000007}]
[25,"06:10:00",null,null,null,"12:20:00","12:50:00","17:15:00",10.000000000000004]
[26,"07:15:00",null,null,null,"13:55:00","14:25:00","17:10:00",9.0000000000000036]
[27,"07:55:00",null,null,null,"11:45:00","12:15:00","13:45:00",5]
[28,"07:45:00",null,null,null,"11:50:00","12:20:00","13:45:00",5]
[29,"06:25:00",null,null,null,"11:50:00","12:20:00","18:15:00",11]
[30,"Sobota"]
[31,"Neděle",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I44:L50)","v":40.000000000000007}]
["Podpis zaměstnance:",null,null,null,"Celkem:",null,null,null,{"$f":"SUM(I20:I50)","v":168},{"$f":"SUM(J20:J50)","v":0},{"$f":"SUM(K20:K50)","v":0},{"$f":"SUM(L20:L50)","v":0},{"$f":"SUM(M20:M50)","v":168.00000000000003}]
[null,null,null,null,"Celkem:",null,null,null,{"$f":"rgCelkOdprac+rgCelkOmluv+rgCelkNahraz+rgCelkPres","v":168}]
[null,null,null,null,"Plán.počet hodin.",null,null,null,168,null,null,null,"Dif.",{"$f":"rgPlanHodin-rgCelkHodin","v":0}]
[null,null,null,null,"Podpis pověřeného zaměstnance:",null,null,null,"Podpis vedoucího"]

{"sheet":"DataRoku","index":2,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,0,2,2],[24,0,24,2],[0,0,0,1]]}
["Data roku",null,{"$f":"rgPozadRok","v":2021}]
[]
["A. Fond pracovní doby"]
[]
["Std. pracovní doba 100% úvazku [hod]:",null,null,8]
["Délka povinné přestávky [min]:",null,null,30]
[]
[]
["Měsíc","Dnů","Svátků","Hodin"]
[1,20,1,{"$f":"rgStdPracDoba*(B10+C10)","v":168},null,{"$f":"rgStdPracDoba*B10","v":160},{"$f":"rgStdPracDoba*C10","v":8}]
[2,20,0,160,null,160,0]
[3,23,0,184,null,184,0,null,{"$f":"SUM(F10:F12)","v":504},{"$f":"SUM(G10:G12)","v":8}]
[4,20,2,176,null,160,16]
[5,21,0,168,null,168,0]
[6,22,0,176,null,176,0,null,{"$f":"SUM(F13:F15)","v":504},{"$f":"SUM(G13:G15)","v":16}]
[7,20,2,176,null,160,16]
[8,22,0,176,null,176,0]
[9,21,1,176,null,168,8,null,{"$f":"SUM(F16:F18)","v":504},{"$f":"SUM(G16:G18)","v":24}]
[10,20,1,168,null,160,8]
[11,21,1,176,null,168,8]
[12,22,1,184,null,176,8,null,{"$f":"SUM(F19:F21)","v":504},{"$f":"SUM(G19:G21)","v":24}]
["Celkem",{"$f":"SUM(B10:B21)","v":252},{"$f":"SUM(C10:C21)","v":9},{"$f":"SUM(D10:D21)","v":2088},null,{"$f":"SUM(F10:F21)","v":2016}]
[]
[]
["B. Placené svátky"]
[]
["Datum","Svátek","Sloupec1"]
["2021-01-01","Nový Rok",{"$f":"A28","v":"2021-01-01"}]
["2021-04-02","Velký Pátek","2021-04-02"]
["2021-04-05","Pondělí Velikonoční","2021-04-05"]
["2021-05-01","Svátek Práce","2021-05-01"]
["2021-05-08","Den vítězství","2021-05-08"]
["2021-07-05","Věrozvěstové","2021-07-05"]
["2021-07-06","Jan Hus","2021-07-06"]
["2021-09-28","Česká státnost","2021-09-28"]
["2021-10-28","Vznik ČSR","2021-10-28"]
["2021-11-17","Den studentů","2021-11-17"]
["2021-12-24","Štědrý den","2021-12-24"]
["2021-12-25","1. Svátek Vánoční","2021-12-25"]
["2021-12-26","2. Svátek Vánoční","2021-12-26"]

{"sheet":"InfoProg","index":3,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Název","List","Adresa"]
["DataRoku!_FilterDatabase","DataRoku","$A$27:$B$39"]
["rgDelkaPrestavky","DataRoku","$D$6"]
["rgFondPracDoby","DataRoku","$A$10:$D$21"]
["rgPlacSvatky","DataRoku","$A$28:$B$39"]
["rgStdPracDoba","DataRoku","$D$5"]
["DochList!Print_Area","DochList","$A$1:$N$55"]
["rgCelkHodin","DochList","$I$52"]
["rgCelkNahraz","DochList","$K$51"]
["rgCelkOdprac","DochList","$I$51"]
["rgCelkOmluv","DochList","$J$51"]
["rgCelkPres","DochList","$L$51"]
["rgCisloUtvaru","DochList","$J$8"]
["rgDochazka","DochList","$A$20:$N$50"]
["rgJmeno","DochList","$B$5"]
["rgMesic","DochList","$B$11"]
["rgNazevUtvaru","DochList","$B$8"]
["rgPlanHodin","DochList","$I$53"]
["rgPracoviste","DochList","$J$14"]
["rgPracZar","DochList","$J$5"]
["rgRok","DochList","$J$11"]
["rgRozdíl","DochList","$M$53"]
["rgCelkTydne","Údaje","$F$31"]
["rgDataVyuky","Údaje","$B$26:$F$30"]
["rgFondPracDoby100","Údaje","$B$6"]
["rgFondPracDocyUU","Údaje","$B$7"]
["rgJmenoZam","Údaje","$B$9"]
["rgPozadMesic","Údaje","$B$3"]
["rgPozadRok","Údaje","$B$4"]
["rgPPDdo","Údaje","$B$17"]
["rgPPDod","Údaje","$B$16"]
["rgPracZam","Údaje","$B$14"]
["rgPrestKon","Údaje","$B$21"]
["rgPrestZac","Údaje","$B$20"]
["rgPrijmeniZam","Údaje","$B$10"]
["rgStdDoba","Údaje","$B$23"]
["rgStdKon","Údaje","$B$22"]
["rgStdZac","Údaje","$B$19"]
["rgUvazek","Údaje","$B$13"]
["rgVyuka","Údaje","$A$25:$F$30"]
["rgZarazZam","Údaje","$B$12"]
["Údaje!Print_Area","Údaje","$A$1:$F$31"]