{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Zobrazenie kalendára","Evidencia dochádzky zamestna...","Zoznam zamestnancov","Typy voľna","Celofiremné voľno"],"not_rendered":{"external_links":1,"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Zobrazenie kalendára","index":0,"n_rows":22,"n_cols":44,"rows_kept":22,"merged":[[1,2,1,8],[2,2,2,8],[18,2,18,4],[18,7,18,10],[18,13,18,15],[18,18,18,20],[18,23,18,25],[18,28,18,30],[19,2,19,4],[19,7,19,10],[19,13,19,15],[19,18,19,20],[19,23,19,25],[19,28,19,30],[20,2,20,4],[20,7,20,10],[20,13,20,15],[20,18,20,20],[20,23,20,25],[20,28,20,30],[21,2,21,4],[21,7,21,10],[21,13,21,15],[21,18,21,20],[21,23,21,25],[21,28,21,30]]}
[null,"EVIDENCIA DOCHÁDZKY ZAMESTNANCOV"]
[null,"Vyberte zamestnanca:","Zamestnanec 1"]
[null,"Zadajte rok:",{"$f":"YEAR(TODAY())","v":2017}]
[]
[null,"Deň v týždni/mesiac","NE","PO","UT","ST","ŠT","PI","SO","NE   ","PO   ","UT   ","ST   ","ŠT   ","PI   ","SO   ","NE    ","PO    ","UT    ","ST    ","ŠT    ","PI    ","SO    ","NE     ","PO     ","UT     ","ST     ","ŠT  ","PI     ","SO     ","NE ","PO ","UT ","ST ","ŠT ","PI ","SO ","NE  ","PO  ","UT  ","ST  ","ŠT          ","PI  ","SO  "]
[null,"Január",{"$f":"IFERROR(IF(TEXT(DATE(Kalendárny_rok,ROW($A1),1),\"ddd\")=LEFT(C$5,2),DATE(Kalendárny_rok,ROW($A1),1),\"\"),\"\")","v":"2017-01-01"},{"$f":"IFERROR(IF(TEXT(DATE(Kalendárny_rok,ROW($A1),1),\"ddd\")=LEFT(D$5,2),DATE(Kalendárny_rok,ROW($A1),1),IF(C6>=1,C6+1,\"\")),\"\")","v":"2017-01-02"},"2017-01-03","2017-01-04","2017-01-05","2017-01-06","2017-01-07",{"$f":"IFERROR(IF(I6>=1,I6+1,\"\"),\"\")","v":"2017-01-08"},{"$f":"IFERROR(IF(J6>=1,J6+1,\"\"),\"\")","v":"2017-01-09"},{"$f":"IFERROR(IF(K6>=1,K6+1,\"\"),\"\")","v":"2017-01-10"},{"$f":"IFERROR(IF(L6>=1,L6+1,\"\"),\"\")","v":"2017-01-11"},{"$f":"IFERROR(IF(M6>=1,M6+1,\"\"),\"\")","v":"2017-01-12"},{"$f":"IFERROR(IF(N6>=1,N6+1,\"\"),\"\")","v":"2017-01-13"},{"$f":"IFERROR(IF(O6>=1,O6+1,\"\"),\"\")","v":"2017-01-14"},{"$f":"IFERROR(IF(P6>=1,P6+1,\"\"),\"\")","v":"2017-01-15"},{"$f":"IFERROR(IF(Q6>=1,Q6+1,\"\"),\"\")","v":"2017-01-16"},{"$f":"IFERROR(IF(R6>=1,R6+1,\"\"),\"\")","v":"2017-01-17"},{"$f":"IFERROR(IF(S6>=1,S6+1,\"\"),\"\")","v":"2017-01-18"},{"$f":"IFERROR(IF(T6>=1,T6+1,\"\"),\"\")","v":"2017-01-19"},{"$f":"IFERROR(IF(U6>=1,U6+1,\"\"),\"\")","v":"2017-01-20"},{"$f":"IFERROR(IF(V6>=1,V6+1,\"\"),\"\")","v":"2017-01-21"},{"$f":"IFERROR(IF(W6>=1,W6+1,\"\"),\"\")","v":"2017-01-22"},{"$f":"IFERROR(IF(X6>=1,X6+1,\"\"),\"\")","v":"2017-01-23"},{"$f":"IFERROR(IF(Y6>=1,Y6+1,\"\"),\"\")","v":"2017-01-24"},{"$f":"IFERROR(IF(Z6>=1,Z6+1,\"\"),\"\")","v":"2017-01-25"},{"$f":"IFERROR(IF(AA6>=1,AA6+1,\"\"),\"\")","v":"2017-01-26"},{"$f":"IFERROR(IF(AB6>=1,AB6+1,\"\"),\"\")","v":"2017-01-27"},{"$f":"IFERROR(IF(AC6>=1,AC6+1,\"\"),\"\")","v":"2017-01-28"},{"$f":"IFERROR(IF(AD6>=1,AD6+1,\"\"),\"\")","v":"2017-01-29"},{"$f":"IFERROR(IF(AE6>=1,AE6+1,\"\"),\"\")","v":"2017-01-30"},{"$f":"IFERROR(IF(AF6>=1,AF6+1,\"\"),\"\")","v":"2017-01-31"},{"$f":"IFERROR(IF(AG6>=1,AG6+1,\"\"),\"\")","v":"2017-02-01"},{"$f":"IFERROR(IF(AH6>=1,AH6+1,\"\"),\"\")","v":"2017-02-02"},{"$f":"IFERROR(IF(AI6>=1,AI6+1,\"\"),\"\")","v":"2017-02-03"},{"$f":"IFERROR(IF(AJ6>=1,AJ6+1,\"\"),\"\")","v":"2017-02-04"},{"$f":"IFERROR(IF(AND(AK6>=1,AK6+1<=DATE(Kalendárny_rok,ROW($A1)+1,0)),AK6+1,\"\"),\"\")","v":""},"","","","","",""]
[null,"Február","","","","2017-02-01","2017-02-02","2017-02-03","2017-02-04",{"$f":"IFERROR(IF(I7>=1,I7+1,\"\"),\"\")","v":"2017-02-05"},{"$f":"IFERROR(IF(J7>=1,J7+1,\"\"),\"\")","v":"2017-02-06"},{"$f":"IFERROR(IF(K7>=1,K7+1,\"\"),\"\")","v":"2017-02-07"},{"$f":"IFERROR(IF(L7>=1,L7+1,\"\"),\"\")","v":"2017-02-08"},{"$f":"IFERROR(IF(M7>=1,M7+1,\"\"),\"\")","v":"2017-02-09"},{"$f":"IFERROR(IF(N7>=1,N7+1,\"\"),\"\")","v":"2017-02-10"},{"$f":"IFERROR(IF(O7>=1,O7+1,\"\"),\"\")","v":"2017-02-11"},{"$f":"IFERROR(IF(P7>=1,P7+1,\"\"),\"\")","v":"2017-02-12"},{"$f":"IFERROR(IF(Q7>=1,Q7+1,\"\"),\"\")","v":"2017-02-13"},{"$f":"IFERROR(IF(R7>=1,R7+1,\"\"),\"\")","v":"2017-02-14"},{"$f":"IFERROR(IF(S7>=1,S7+1,\"\"),\"\")","v":"2017-02-15"},{"$f":"IFERROR(IF(T7>=1,T7+1,\"\"),\"\")","v":"2017-02-16"},{"$f":"IFERROR(IF(U7>=1,U7+1,\"\"),\"\")","v":"2017-02-17"},{"$f":"IFERROR(IF(V7>=1,V7+1,\"\"),\"\")","v":"2017-02-18"},{"$f":"IFERROR(IF(W7>=1,W7+1,\"\"),\"\")","v":"2017-02-19"},{"$f":"IFERROR(IF(X7>=1,X7+1,\"\"),\"\")","v":"2017-02-20"},{"$f":"IFERROR(IF(Y7>=1,Y7+1,\"\"),\"\")","v":"2017-02-21"},{"$f":"IFERROR(IF(Z7>=1,Z7+1,\"\"),\"\")","v":"2017-02-22"},{"$f":"IFERROR(IF(AA7>=1,AA7+1,\"\"),\"\")","v":"2017-02-23"},{"$f":"IFERROR(IF(AB7>=1,AB7+1,\"\"),\"\")","v":"2017-02-24"},{"$f":"IFERROR(IF(AC7>=1,AC7+1,\"\"),\"\")","v":"2017-02-25"},{"$f":"IFERROR(IF(AD7>=1,AD7+1,\"\"),\"\")","v":"2017-02-26"},{"$f":"IFERROR(IF(AE7>=1,AE7+1,\"\"),\"\")","v":"2017-02-27"},{"$f":"IFERROR(IF(AF7>=1,AF7+1,\"\"),\"\")","v":"2017-02-28"},{"$f":"IFERROR(IF(AG7>=1,AG7+1,\"\"),\"\")","v":"2017-03-01"},{"$f":"IFERROR(IF(AH7>=1,AH7+1,\"\"),\"\")","v":"2017-03-02"},{"$f":"IFERROR(IF(AI7>=1,AI7+1,\"\"),\"\")","v":"2017-03-03"},{"$f":"IFERROR(IF(AJ7>=1,AJ7+1,\"\"),\"\")","v":"2017-03-04"},{"$f":"IFERROR(IF(AND(AK7>=1,AK7+1<=DATE(Kalendárny_rok,ROW($A2)+1,0)),AK7+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(AL7>=1,AL7+1<=DATE(Kalendárny_rok,ROW($A2)+1,0)),AL7+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(AM7>=1,AM7+1<=DATE(Kalendárny_rok,ROW($A2)+1,0)),AM7+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(AN7>=1,AN7+1<=DATE(Kalendárny_rok,ROW($A2)+1,0)),AN7+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(AO7>=1,AO7+1<=DATE(Kalendárny_rok,ROW($A2)+1,0)),AO7+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(AP7>=1,AP7+1<=DATE(Kalendárny_rok,ROW($A2)+1,0)),AP7+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(AQ7>=1,AQ7+1<=DATE(Kalendárny_rok,ROW($A2)+1,0)),AQ7+1,\"\"),\"\")","v":""}]
[null,"Marec","","","","2017-03-01","2017-03-02","2017-03-03","2017-03-04","2017-03-05","2017-03-06","2017-03-07","2017-03-08","2017-03-09","2017-03-10","2017-03-11","2017-03-12","2017-03-13","2017-03-14","2017-03-15","2017-03-16","2017-03-17","2017-03-18","2017-03-19","2017-03-20","2017-03-21","2017-03-22","2017-03-23","2017-03-24","2017-03-25","2017-03-26","2017-03-27","2017-03-28","2017-03-29","2017-03-30","2017-03-31","2017-04-01","","","","","","",""]
[null,"Apríl","","","","","","","2017-04-01","2017-04-02","2017-04-03","2017-04-04","2017-04-05","2017-04-06","2017-04-07","2017-04-08","2017-04-09","2017-04-10","2017-04-11","2017-04-12","2017-04-13","2017-04-14","2017-04-15","2017-04-16","2017-04-17","2017-04-18","2017-04-19","2017-04-20","2017-04-21","2017-04-22","2017-04-23","2017-04-24","2017-04-25","2017-04-26","2017-04-27","2017-04-28","2017-04-29","2017-04-30","","","","","",""]
[null,"Máj","","2017-05-01","2017-05-02","2017-05-03","2017-05-04","2017-05-05","2017-05-06","2017-05-07","2017-05-08","2017-05-09","2017-05-10","2017-05-11","2017-05-12","2017-05-13","2017-05-14","2017-05-15","2017-05-16","2017-05-17","2017-05-18","2017-05-19","2017-05-20","2017-05-21","2017-05-22","2017-05-23","2017-05-24","2017-05-25","2017-05-26","2017-05-27","2017-05-28","2017-05-29","2017-05-30","2017-05-31","2017-06-01","2017-06-02","2017-06-03","","","","","","",""]
[null,"Jún","","","","","2017-06-01","2017-06-02","2017-06-03","2017-06-04","2017-06-05","2017-06-06","2017-06-07","2017-06-08","2017-06-09","2017-06-10","2017-06-11","2017-06-12","2017-06-13","2017-06-14","2017-06-15","2017-06-16","2017-06-17","2017-06-18","2017-06-19","2017-06-20","2017-06-21","2017-06-22","2017-06-23","2017-06-24","2017-06-25","2017-06-26","2017-06-27","2017-06-28","2017-06-29","2017-06-30","2017-07-01","","","","","","",""]
[null,"Júl","","","","","","","2017-07-01","2017-07-02","2017-07-03","2017-07-04","2017-07-05","2017-07-06","2017-07-07","2017-07-08","2017-07-09","2017-07-10","2017-07-11","2017-07-12","2017-07-13","2017-07-14","2017-07-15","2017-07-16","2017-07-17","2017-07-18","2017-07-19","2017-07-20","2017-07-21","2017-07-22","2017-07-23","2017-07-24","2017-07-25","2017-07-26","2017-07-27","2017-07-28","2017-07-29","2017-07-30","2017-07-31","","","","",""]
[null,"August","","","2017-08-01","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2017-08-08","2017-08-09","2017-08-10","2017-08-11","2017-08-12","2017-08-13","2017-08-14","2017-08-15","2017-08-16","2017-08-17","2017-08-18","2017-08-19","2017-08-20","2017-08-21","2017-08-22","2017-08-23","2017-08-24","2017-08-25","2017-08-26","2017-08-27","2017-08-28","2017-08-29","2017-08-30","2017-08-31","2017-09-01","2017-09-02","","","","","","",""]
[null,"September","","","","","","2017-09-01","2017-09-02","2017-09-03","2017-09-04","2017-09-05","2017-09-06","2017-09-07","2017-09-08","2017-09-09","2017-09-10","2017-09-11","2017-09-12","2017-09-13","2017-09-14","2017-09-15","2017-09-16","2017-09-17","2017-09-18","2017-09-19","2017-09-20","2017-09-21","2017-09-22","2017-09-23","2017-09-24","2017-09-25","2017-09-26","2017-09-27","2017-09-28","2017-09-29","2017-09-30","","","","","","",""]
[null,"Október","2017-10-01","2017-10-02","2017-10-03","2017-10-04","2017-10-05","2017-10-06","2017-10-07","2017-10-08","2017-10-09","2017-10-10","2017-10-11","2017-10-12","2017-10-13","2017-10-14","2017-10-15","2017-10-16","2017-10-17","2017-10-18","2017-10-19","2017-10-20","2017-10-21","2017-10-22","2017-10-23","2017-10-24","2017-10-25","2017-10-26","2017-10-27","2017-10-28","2017-10-29","2017-10-30","2017-10-31","2017-11-01","2017-11-02","2017-11-03","2017-11-04","","","","","","",""]
[null,"November","","","","2017-11-01","2017-11-02","2017-11-03","2017-11-04","2017-11-05","2017-11-06","2017-11-07","2017-11-08","2017-11-09","2017-11-10","2017-11-11","2017-11-12","2017-11-13","2017-11-14","2017-11-15","2017-11-16","2017-11-17","2017-11-18","2017-11-19","2017-11-20","2017-11-21","2017-11-22","2017-11-23","2017-11-24","2017-11-25","2017-11-26","2017-11-27","2017-11-28","2017-11-29","2017-11-30","2017-12-01","2017-12-02","","","","","","",""]
[null,"December","","","","","","2017-12-01","2017-12-02","2017-12-03","2017-12-04","2017-12-05","2017-12-06","2017-12-07","2017-12-08","2017-12-09","2017-12-10","2017-12-11","2017-12-12","2017-12-13","2017-12-14","2017-12-15","2017-12-16","2017-12-17","2017-12-18","2017-12-19","2017-12-20","2017-12-21","2017-12-22","2017-12-23","2017-12-24","2017-12-25","2017-12-26","2017-12-27","2017-12-28","2017-12-29","2017-12-30","2017-12-31","","","","","",""]
[null,"KĽÚČOVÁ ŠTATISTIKA"]
[null,null,"Počet dní voľna",{"$nulls":4},"Počet pracovných dní",{"$nulls":5},"Počet dní prácene-\nschopnosti",{"$nulls":4},"Dovolenka",{"$nulls":4},"Účasť na pohrebe",{"$nulls":4},"Iné"]
[null,null,{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok+1,1,1))","v":4},{"$nulls":4},{"$f":"NETWORKDAYS(DATE(Kalendárny_rok,1,1),EDATE(DATE(Kalendárny_rok,1,1),12)-1)","v":260},{"$nulls":5},{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok+1,1,1),EvidenciaDochádzky[Typ voľna],'Typy voľna'!B4)","v":1},{"$nulls":4},{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok+1,1,1),EvidenciaDochádzky[Typ voľna],'Typy voľna'!B5)","v":0},{"$nulls":4},{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok+1,1,1),EvidenciaDochádzky[Typ voľna],'Typy voľna'!B6)","v":3},{"$nulls":4},{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok+1,1,1),EvidenciaDochádzky[Typ voľna],'Typy voľna'!B7)","v":0}]
[null,null,{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok-1,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok,1,1))","v":14},{"$nulls":4},{"$f":"NETWORKDAYS(DATE(Kalendárny_rok-1,1,1),EDATE(DATE(Kalendárny_rok-1,1,1),12)-1)","v":261},{"$nulls":5},{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok-1,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Typ voľna],'Typy voľna'!B4)","v":4},{"$nulls":4},{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok-1,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Typ voľna],'Typy voľna'!B5)","v":8},{"$nulls":4},{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok-1,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Typ voľna],'Typy voľna'!B6)","v":0},{"$nulls":4},{"$f":"SUMIFS(EvidenciaDochádzky[Dni],EvidenciaDochádzky[Meno zamestnanca],valVybZamestnanec,EvidenciaDochádzky[Počiatočný dátum],\">=\"&DATE(Kalendárny_rok-1,1,1),EvidenciaDochádzky[Koncový dátum],\"<\"&DATE(Kalendárny_rok,1,1),EvidenciaDochádzky[Typ voľna],'Typy voľna'!B7)","v":2}]
[null,null,{"$f":"IFERROR(IF(C21<>0,IF(C20>=C21,\"NÁRAST \", \"POKLES \")&TEXT(C20/C21-1,\"0%;0%\"),\"NÁRAST 100%\"),\"\")","v":"POKLES 71%"},{"$nulls":4},{"$f":"IFERROR(IF(H21<>0,IF(H20>=H21,\"NÁRAST \", \"POKLES \")&TEXT(H20/H21-1,\"0%;0%\"),\"NÁRAST 100%\"),\"\")","v":"POKLES 0%"},{"$nulls":5},{"$f":"IFERROR(IF(N21<>0,IF(N20>=N21,\"NÁRAST \", \"POKLES \")&TEXT(N20/N21-1,\"0%;0%\"),\"NÁRAST 100%\"),\"\")","v":"POKLES 75%"},{"$nulls":4},{"$f":"IFERROR(IF(S21<>0,IF(S20>=S21,\"NÁRAST \", \"POKLES \")&TEXT(S20/S21-1,\"0%;0%\"),\"NÁRAST 100%\"),\"\")","v":"POKLES 100%"},{"$nulls":4},{"$f":"IFERROR(IF(X21<>0,IF(X20>=X21,\"NÁRAST \", \"POKLES \")&TEXT(X20/X21-1,\"0%;0%\"),\"NÁRAST 100%\"),\"\")","v":"NÁRAST 100%"},{"$nulls":4},{"$f":"IFERROR(IF(AC21<>0,IF(AC20>=AC21,\"NÁRAST \", \"POKLES \")&TEXT(AC20/AC21-1,\"0%;0%\"),\"NÁRAST 100%\"),\"\")","v":"POKLES 100%"}]

{"sheet":"Evidencia dochádzky zamestna...","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Evidencia dochádzky zamestnancov"]
[]
[null,"Meno zamestnanca","Počiatočný dátum","Koncový dátum","Typ voľna","Dni"]
[null,"Zamestnanec 1",{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2017-01-03"},{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2017-01-03"},"Práceneschopnosť",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":1}]
[null,"Zamestnanec 2",{"$f":"DATE(YEAR(TODAY()),1,17)","v":"2017-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2017-01-18"},"Iné",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":2}]
[null,"Zamestnanec 3",{"$f":"DATE(YEAR(TODAY()),1,18 )","v":"2017-01-18"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2017-01-21"},"Iné",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":3}]
[null,"Zamestnanec 5",{"$f":"DATE(YEAR(TODAY())-1,12,10 )","v":"2016-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2016-12-16"},"Účasť na pohrebe",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":5}]
[null,"Zamestnanec 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2016-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,2)","v":"2016-12-02"},"Práceneschopnosť",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":2}]
[null,"Zamestnanec 1",{"$f":"DATE(YEAR(TODAY())-1,11,14  )","v":"2016-11-14"},{"$f":"DATE(YEAR(TODAY())-1,11,18)","v":"2016-11-18"},"Dovolenka",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":5}]
[null,"Zamestnanec 4",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2017-01-31"},{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2017-02-04"},"Práceneschopnosť",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":4}]
[null,"Zamestnanec 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2016-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2016-12-06"},"Iné",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":4}]
[null,"Zamestnanec 4",{"$f":"DATE(YEAR(TODAY())-1,12,10  )","v":"2016-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2016-12-16"},"Iné",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":5}]
[null,"Zamestnanec 2",{"$f":"DATE(YEAR(TODAY()),1,13 )","v":"2017-01-13"},{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2017-01-15"},"Práceneschopnosť",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":1}]
[null,"Zamestnanec 5",{"$f":"DATE(YEAR(TODAY()),1,15 )","v":"2017-01-15"},{"$f":"DATE(YEAR(TODAY()),1,20)","v":"2017-01-20"},"Práceneschopnosť",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":5}]
[null,"Zamestnanec 2",{"$f":"DATE(YEAR(TODAY()),6,13 )","v":"2017-06-13"},{"$f":"DATE(YEAR(TODAY()),6,15)","v":"2017-06-15"},"Účasť na pohrebe",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":3}]
[null,"Zamestnanec 5",{"$f":"DATE(YEAR(TODAY()),1,27 )","v":"2017-01-27"},{"$f":"DATE(YEAR(TODAY()),2,3)","v":"2017-02-03"},"Účasť na pohrebe",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":6}]
[null,"Zamestnanec 3",{"$f":"DATE(YEAR(TODAY()),1,17 )","v":"2017-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2017-01-18"},"Dovolenka",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":2}]
[null,"Zamestnanec 3",{"$f":"DATE(YEAR(TODAY())-1,12,12 )","v":"2016-12-12"},{"$f":"DATE(YEAR(TODAY())-1,12,17)","v":"2016-12-17"},"Účasť na pohrebe",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":5}]
[null,"Zamestnanec 1",{"$f":"DATE(YEAR(TODAY())-1,12,21  )","v":"2016-12-21"},{"$f":"DATE(YEAR(TODAY())-1,12,22)","v":"2016-12-22"},"Iné",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":2}]
[null,"Zamestnanec 1",{"$f":"DATE(YEAR(TODAY())-1,12,14  )","v":"2016-12-14"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2016-12-16"},"Dovolenka",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":3}]
[null,"Zamestnanec 2",{"$f":"DATE(YEAR(TODAY())-1,11,29  )","v":"2016-11-29"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2016-12-06"},"Účasť na pohrebe",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":6}]
[null,"Zamestnanec 5",{"$f":"DATE(YEAR(TODAY())-1,12,3  )","v":"2016-12-03"},{"$f":"DATE(YEAR(TODAY())-1,12,7)","v":"2016-12-07"},"Dovolenka",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":3}]
[null,"Zamestnanec 1",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2017-01-31"},{"$f":"DATE(YEAR(TODAY()),2,2)","v":"2017-02-02"},"Účasť na pohrebe",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":3}]
[null,"Zamestnanec 1",{"$f":"DATE(YEAR(TODAY())-1,11,24 )","v":"2016-11-24"},{"$f":"DATE(YEAR(TODAY())-1,11,29)","v":"2016-11-29"},"Práceneschopnosť",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":4}]
[null,"Zamestnanec 2",{"$f":"DATE(YEAR(TODAY()),12,5 )","v":"2017-12-05"},{"$f":"DATE(YEAR(TODAY()),12,9)","v":"2017-12-09"},"Dovolenka",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":4}]
[null,"Zamestnanec 5",{"$f":"DATE(YEAR(TODAY()),4,11 )","v":"2017-04-11"},{"$f":"DATE(YEAR(TODAY()),4,19)","v":"2017-04-19"},"Dovolenka",{"$f":"NETWORKDAYS(EvidenciaDochádzky[[#This Row],[Počiatočný dátum]],EvidenciaDochádzky[[#This Row],[Koncový dátum]],lstVoľno)","v":7}]

{"sheet":"Zoznam zamestnancov","index":2,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Zoznam zamestnancov"]
[]
[null,"Mená zamestnancov"]
[null,"Zamestnanec 1"]
[null,"Zamestnanec 2"]
[null,"Zamestnanec 3"]
[null,"Zamestnanec 4"]
[null,"Zamestnanec 5"]

{"sheet":"Typy voľna","index":3,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"Typy voľna"]
[]
[null,"Zoznam typov voľna"]
[null,"Práceneschopnosť"]
[null,"Dovolenka"]
[null,"Účasť na pohrebe"]
[null,"Iné"]

{"sheet":"Celofiremné voľno","index":4,"n_rows":9,"n_cols":3,"rows_kept":9}
[null,"Celofiremné voľno"]
[]
[null,"Celofiremné voľno","Popis"]
[null,{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2017-01-01"},"Nový rok"]
[null,{"$f":"DATE(YEAR(TODAY()),7,4)","v":"2017-07-04"},"Deň nezávislosti"]
[null,{"$f":"DATE(YEAR(TODAY()),11,24)","v":"2017-11-24"},"Deň vďakyvzdania"]
[null,{"$f":"DATE(YEAR(TODAY()),11,25)","v":"2017-11-25"},"Deň vďakyvzdania"]
[null,{"$f":"DATE(YEAR(TODAY()),12,24)","v":"2017-12-24"},"Vianoce"]
[null,{"$f":"DATE(YEAR(TODAY()),12,25)","v":"2017-12-25"},"Vianoce"]