{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Domov","Šablóna","LoV"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Domov","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Parameter",null,null,"Hodnota"]
[]
[]
[null,"Čas príchodu do práce",null,null,"08:00:00"]
[null,"Čas odchodu z práce",null,null,"16:30:00"]
[null,"Minimálny rozsah pracovnej doby v hod.",null,null,7.7]
[null,"Obedná pauza v min.",null,null,30]
[null,"Nárok na dovolenku v dňoch",null,null,20]
[null,"Práca cez sviatky",null,null,"Nie"]
[null,"Práca cez víkendy",null,null,"Nie"]

{"sheet":"Šablóna","index":1,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":true,"merged":[[3,1,3,8],[47,1,47,4],[5,2,5,3],[5,4,5,5],[5,6,5,7],[13,1,13,8]]}
[]
[null,"Mesiac",null,null,null,null,"Rok",{"$f":"YEAR($C$2)","v":1900}]
[]
[]
[]
[null,null,"Kalendárne dni",null,"Pracovné dni",null,"Dovolenka"]
[]
[null,"Počet dní",{"$f":"IF(MOD(YEAR($C$2),4)=0,VLOOKUP(MONTH($C$2),LoV!$D$2:$G$14,4,FALSE),VLOOKUP(MONTH($C$2),LoV!$D$2:$F$14,3,FALSE))","v":31},null,{"$f":"COUNT(B17:B47)","v":0},null,"Nárok"]
[]
[null,"Prvý deň",{"$f":"$C$2","v":"00:00:00"},{"$f":"VLOOKUP(WEEKDAY($C$10,2),LoV!$A$3:$B$9,2,FALSE)","v":"Sobota"},{"$f":"WORKDAY($C$10-1,1,LoV!$K$3:$K$17)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(WEEKDAY($E$10,2),LoV!$A$3:$B$9,2,FALSE)","v":{"$error":"#NUM!"}},"Využitá"]
[]
[null,"Posledný deň",{"$f":"DATE(YEAR($C$10),MONTH($C$10),$C$8)","v":"1900-01-31"},{"$f":"VLOOKUP(WEEKDAY(C12,2),LoV!$A$3:$B$9,2,FALSE)","v":"Utorok"},{"$f":"WORKDAY($C$12+1,-1,LoV!$K$3:$K$17)","v":"1900-01-31"},{"$f":"VLOOKUP(WEEKDAY($E$12,2),LoV!$A$3:$B$9,2,FALSE)","v":"Utorok"},"Zostatok",{"$f":"$H$8-$H$10","v":0}]
[]
[]
[]
[null,"Dátum","Príchod","Odchod","Obed","Spolu","Nadčas","Dovolenka","Poznámka"]
[null,{"$f":"IF(AND(MONTH($E$10)=MONTH($C$2),MONTH($E$12)=MONTH($C$2)),E10,\"\")","v":{"$error":"#NUM!"}},null,null,null,{"$f":"IF(AND(C17<>\"\",D17<>\"\"),(N((HOUR(D17) * 60+MINUTE(D17))-(HOUR(C17) * 60 + MINUTE(C17))) - E17) / 60,\"\")","v":""}]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B17,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B17,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,{"$f":"IF(AND(C18<>\"\",D18<>\"\"),(N((HOUR(D18) * 60+MINUTE(D18))-(HOUR(C18) * 60 + MINUTE(C18))) - E18) / 60,\"\")","v":""}]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B18,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B18,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B19,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B19,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B20,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B20,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B21,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B21,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B22,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B22,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B23,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B23,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B24,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B24,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B25,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B25,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B26,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B26,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B27,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B27,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B28,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B28,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B29,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B29,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B30,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B30,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B31,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B31,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B32,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B32,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B33,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B33,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B34,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B34,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B35,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B35,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B36,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B36,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B37,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B37,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B38,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B38,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B39,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B39,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B40,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B40,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B41,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B41,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B42,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B42,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B43,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B43,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B44,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B44,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B45,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B45,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(MONTH(WORKDAY(B46,1,LoV!$K$3:$K$17)) = MONTH($C$2),WORKDAY(B46,1,LoV!$K$3:$K$17),\"\"),\"\")","v":""},null,null,null,""]
[null,"Spolu odpracovaných hodín",null,null,null,{"$f":"SUM(F17:F47)","v":0},{"$f":"SUM(G17:G47)","v":0},{"$f":"COUNTIF(H17:H47,\"A\")","v":0}]

{"sheet":"LoV","index":2,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,3,0,6],[0,8,0,12]]}
["Dni v týždni",null,null,"Počet dní v mesiaci",null,null,null,null,"Sviatky / Dni pracovného pokoja"]
["ID dňa","Názov dňa",null,"ID mesiaca","Názov mesiaca","Počet dní 1","Počet dní 2",null,"ID mesiaca","ID dňa","Dátum","Názov sviatku","Kategória"]
[1,"Pondelok",null,1,"januar",31,31,null,1,1,{"$f":"DATE(YEAR(NOW()),1,1)","v":"2016-01-01"},"Deň vzniku Slovenskej republiky","štátny sviatok"]
[2,"Utorok",null,2,"februar",28,29,null,1,6,{"$f":"DATE(YEAR(NOW()),1,6)","v":"2016-01-06"},"Zjavenie Pána (Traja králi)","deň pracovného pokoja"]
[3,"Streda",null,3,"marec",31,31,null,{"$f":"IF(OR(22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7) > 31,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)<0),4,3)","v":3},{"$f":"IF(OR(22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7) > 31,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)<0),MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)-9,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7))-2","v":25},{"$f":"DATE(YEAR(NOW()),IF(OR(22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7) > 31,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)<0),4,3),IF(OR(22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7) > 31,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)<0),MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)-9,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7))-2)","v":"2016-03-25"},"Veľký piatok","deň pracovného pokoja"]
[4,"Štvrtok",null,4,"april",30,30,null,{"$f":"IF(OR(22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7) > 31,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)<0),4,3)","v":3},{"$f":"IF(OR(22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7) > 31,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)<0),MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)-9,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7))+1","v":28},{"$f":"DATE(YEAR(NOW()),IF(OR(22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7) > 31,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)<0),4,3),IF(OR(22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7) > 31,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)<0),MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7)-9,22+MOD(19*MOD(YEAR(NOW()),19)+24,30)+MOD(5+2*MOD(YEAR(NOW()),4)+4*MOD(YEAR(NOW()),7)+6*MOD(19*MOD(YEAR(NOW()),19)+24,30),7))+1)","v":"2016-03-28"},"Veľkonočný pondelok","deň pracovného pokoja"]
[5,"Piatok",null,5,"maj",31,31,null,5,1,{"$f":"DATE(YEAR(NOW()),5,1)","v":"2016-05-01"},"Sviatok práce","deň pracovného pokoja"]
[6,"Sobota",null,6,"jun",30,30,null,5,8,{"$f":"DATE(YEAR(NOW()),5,8)","v":"2016-05-08"},"Deň víťazstva nad fašizmom","deň pracovného pokoja"]
[7,"Nedeľa",null,7,"jul",31,31,null,7,5,{"$f":"DATE(YEAR(NOW()),7,5)","v":"2016-07-05"},"Sviatok svätého Cyrila a Metoda","štátny sviatok"]
[null,null,null,8,"august",31,31,null,8,29,{"$f":"DATE(YEAR(NOW()),8,29)","v":"2016-08-29"},"Výročie SNP","štátny sviatok"]
[null,null,null,9,"september",30,30,null,9,1,{"$f":"DATE(YEAR(NOW()),9,1)","v":"2016-09-01"},"Deň ústavy Slovenskej republiky","štátny sviatok"]
[null,null,null,10,"oktober",31,31,null,9,15,{"$f":"DATE(YEAR(NOW()),9,15)","v":"2016-09-15"},"Sedembolestná Panna Mária","deň pracovného pokoja"]
[null,null,null,11,"november",30,30,null,11,1,{"$f":"DATE(YEAR(NOW()),11,1)","v":"2016-11-01"},"Sviatok všetkých svätých","deň pracovného pokoja"]
[null,null,null,12,"december",31,31,null,11,17,{"$f":"DATE(YEAR(NOW()),11,17)","v":"2016-11-17"},"Deň boja za slobodu a demokraciu","štátny sviatok"]
[null,null,null,null,null,null,null,null,12,24,{"$f":"DATE(YEAR(NOW()),12,24)","v":"2016-12-24"},"Štedrý deň","deň pracovného pokoja"]
[null,null,null,null,null,null,null,null,12,25,{"$f":"DATE(YEAR(NOW()),12,25)","v":"2016-12-25"},"Prvý sviatok vianočný","deň pracovného pokoja"]
[null,null,null,null,null,null,null,null,12,26,{"$f":"DATE(YEAR(NOW()),12,26)","v":"2016-12-26"},"Druhý sviatok vianočný","deň pracovného pokoja"]