{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Zobrazení kalendáře","Sledování nepřítomnosti zaměstn","Seznam zaměstnanců","Typy nepřítomnosti","Celofiremní svátky"],"not_rendered":{"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Zobrazení kalendáře","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,"ZÁZNAM O DOCHÁZCE ZAMĚSTNANCŮ"]
[null,"Vyberte zaměstnance:","Zaměstnanec 1"]
[null,"Zadejte rok:",{"$f":"YEAR(TODAY())","v":2022}]
[]
[null,"Den/měsíc","PO","ÚT","ST","ČT","PÁ","SO","NE   ","PO   ","ÚT   ","ST   ","ČT   ","PÁ   ","SO   ","NE    ","PO    ","ÚT    ","ST    ","ČT    ","PÁ    ","SO    ","NE     ","PO     ","ÚT     ","ST     ","ČT  ","PÁ     ","SO     ","NE ","PO ","ÚT ","ST ","ČT ","PÁ ","SO ","NE  ","PO  ","ÚT  ","ST  ","ČT 2","PÁ  ","SO  ","NE"]
[null,"Leden",{"$f":"IFERROR(IF(TEXT(DATE(Kalendářní_rok,ROW($A1),1),\"ddd\")=LEFT(C$5,2),DATE(Kalendářní_rok,ROW($A1),1),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TEXT(DATE(Kalendářní_rok,ROW($A1),1),\"ddd\")=LEFT(D$5,2),DATE(Kalendářní_rok,ROW($A1),1),IF(C6>=1,C6+1,\"\")),\"\")","v":""},"","","","","",{"$f":"IFERROR(IF(I6>=1,I6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J6>=1,J6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K6>=1,K6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L6>=1,L6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M6>=1,M6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N6>=1,N6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O6>=1,O6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P6>=1,P6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Q6>=1,Q6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(R6>=1,R6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(S6>=1,S6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(T6>=1,T6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(U6>=1,U6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(V6>=1,V6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(W6>=1,W6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X6>=1,X6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Y6>=1,Y6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Z6>=1,Z6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AA6>=1,AA6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AB6>=1,AB6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AC6>=1,AC6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AD6>=1,AD6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AE6>=1,AE6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AF6>=1,AF6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AG6>=1,AG6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AH6>=1,AH6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AI6>=1,AI6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AJ6>=1,AJ6+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(AK6>=1,AK6+1<=DATE(Kalendářní_rok,ROW($A1)+1,0)),AK6+1,\"\"),\"\")","v":""},"","","","","",""]
[null,"Únor","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Březen","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Duben","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Květen","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Červen","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Červenec","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Srpen","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Září","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Říjen","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Listopad","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Prosinec","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"KLÍČOVÉ STATISTIKY"]
[null,null,"Dny nepřítomnosti",{"$nulls":4},"Odpracované dny",{"$nulls":5},"Počet dnů nemoci",{"$nulls":4},"Dovolená",{"$nulls":4},"Úmrtí v rodině",{"$nulls":4},"Ostatní"]
[null,null,{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok+1,1,1))","v":4},{"$nulls":4},{"$f":"NETWORKDAYS(DATE(Kalendářní_rok,1,1),EDATE(DATE(Kalendářní_rok,1,1),12)-1)","v":260},{"$nulls":5},{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok+1,1,1),Sledování_nepřítomnosti[Typ nepřítomnosti],'Typy nepřítomnosti'!B4)","v":1},{"$nulls":4},{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok+1,1,1),Sledování_nepřítomnosti[Typ nepřítomnosti],'Typy nepřítomnosti'!B5)","v":0},{"$nulls":4},{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok+1,1,1),Sledování_nepřítomnosti[Typ nepřítomnosti],'Typy nepřítomnosti'!B6)","v":3},{"$nulls":4},{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok+1,1,1),Sledování_nepřítomnosti[Typ nepřítomnosti],'Typy nepřítomnosti'!B7)","v":0}]
[null,null,{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok-1,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok,1,1))","v":13},{"$nulls":4},{"$f":"NETWORKDAYS(DATE(Kalendářní_rok-1,1,1),EDATE(DATE(Kalendářní_rok-1,1,1),12)-1)","v":261},{"$nulls":5},{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok-1,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Typ nepřítomnosti],'Typy nepřítomnosti'!B4)","v":4},{"$nulls":4},{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok-1,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Typ nepřítomnosti],'Typy nepřítomnosti'!B5)","v":7},{"$nulls":4},{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok-1,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Typ nepřítomnosti],'Typy nepřítomnosti'!B6)","v":0},{"$nulls":4},{"$f":"SUMIFS(Sledování_nepřítomnosti[Dny],Sledování_nepřítomnosti[Jméno zaměstnance],valSelEmployee,Sledování_nepřítomnosti[Počáteční datum],\">=\"&DATE(Kalendářní_rok-1,1,1),Sledování_nepřítomnosti[Koncové datum],\"<\"&DATE(Kalendářní_rok,1,1),Sledování_nepřítomnosti[Typ nepřítomnosti],'Typy nepřítomnosti'!B7)","v":2}]
[null,null,{"$f":"IFERROR(IF(C21<>0,IF(C20>=C21,\"NÁRŮST \", \"POKLES \")&TEXT(C20/C21-1,\"0%;0%\"),\"POKLES 100%\"),\"\")","v":"POKLES 69%"},{"$nulls":4},{"$f":"IFERROR(IF(H21<>0,IF(H20>=H21,\"NÁRŮST \", \"POKLES \")&TEXT(H20/H21-1,\"0%;0%\"),\"NÁRŮST 100%\"),\"\")","v":"POKLES 0%"},{"$nulls":5},{"$f":"IFERROR(IF(N21<>0,IF(N20>=N21,\"NÁRŮST \", \"POKLES \")&TEXT(N20/N21-1,\"0%;0%\"),\"NÁRŮST 100%\"),\"\")","v":"POKLES 75%"},{"$nulls":4},{"$f":"IFERROR(IF(S21<>0,IF(S20>=S21,\"NÁRŮST \", \"POKLES \")&TEXT(S20/S21-1,\"0%;0%\"),\"NÁRŮST 100%\"),\"\")","v":"POKLES 100%"},{"$nulls":4},{"$f":"IFERROR(IF(X21<>0,IF(X20>=X21,\"NÁRŮST \", \"POKLES \")&TEXT(X20/X21-1,\"0%;0%\"),\"NÁRŮST O 100 %\"),\"\")","v":"NÁRŮST O 100 %"},{"$nulls":4},{"$f":"IFERROR(IF(AC21<>0,IF(AC20>=AC21,\"NÁRŮST \", \"POKLES \")&TEXT(AC20/AC21-1,\"0%;0%\"),\"NÁRŮST 100%\"),\"\")","v":"POKLES 100%"}]

{"sheet":"Sledování nepřítomnosti zaměstn","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Sledování nepřítomnosti zaměstnanců"]
[]
[null,"Jméno zaměstnance","Počáteční datum","Koncové datum","Typ nepřítomnosti","Dny"]
[null,"Zaměstnanec 1",{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2022-01-03"},{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2022-01-03"},"Nemoc",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":1}]
[null,"Zaměstnanec 2",{"$f":"DATE(YEAR(TODAY()),1,17)","v":"2022-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2022-01-18"},"Ostatní",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":2}]
[null,"Zaměstnanec 3",{"$f":"DATE(YEAR(TODAY()),1,18 )","v":"2022-01-18"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2022-01-21"},"Ostatní",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":4}]
[null,"Zaměstnanec 5",{"$f":"DATE(YEAR(TODAY())-1,12,10 )","v":"2021-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Úmrtí v rodině",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":5}]
[null,"Zaměstnanec 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2021-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,2)","v":"2021-12-02"},"Nemoc",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":2}]
[null,"Zaměstnanec 1",{"$f":"DATE(YEAR(TODAY())-1,11,14  )","v":"2021-11-14"},{"$f":"DATE(YEAR(TODAY())-1,11,18)","v":"2021-11-18"},"Dovolená",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":4}]
[null,"Zaměstnanec 4",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2022-01-31"},{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2022-02-04"},"Nemoc",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":5}]
[null,"Zaměstnanec 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2021-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2021-12-06"},"Ostatní",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":4}]
[null,"Zaměstnanec 4",{"$f":"DATE(YEAR(TODAY())-1,12,10  )","v":"2021-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Ostatní",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":5}]
[null,"Zaměstnanec 2",{"$f":"DATE(YEAR(TODAY()),1,13 )","v":"2022-01-13"},{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2022-01-15"},"Nemoc",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":2}]
[null,"Zaměstnanec 5",{"$f":"DATE(YEAR(TODAY()),1,15 )","v":"2022-01-15"},{"$f":"DATE(YEAR(TODAY()),1,20)","v":"2022-01-20"},"Nemoc",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":4}]
[null,"Zaměstnanec 2",{"$f":"DATE(YEAR(TODAY()),6,13 )","v":"2022-06-13"},{"$f":"DATE(YEAR(TODAY()),6,15)","v":"2022-06-15"},"Úmrtí v rodině",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":3}]
[null,"Zaměstnanec 5",{"$f":"DATE(YEAR(TODAY()),1,27 )","v":"2022-01-27"},{"$f":"DATE(YEAR(TODAY()),2,3)","v":"2022-02-03"},"Úmrtí v rodině",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":6}]
[null,"Zaměstnanec 3",{"$f":"DATE(YEAR(TODAY()),1,17 )","v":"2022-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2022-01-18"},"Dovolená",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":2}]
[null,"Zaměstnanec 3",{"$f":"DATE(YEAR(TODAY())-1,12,12 )","v":"2021-12-12"},{"$f":"DATE(YEAR(TODAY())-1,12,17)","v":"2021-12-17"},"Úmrtí v rodině",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":5}]
[null,"Zaměstnanec 1",{"$f":"DATE(YEAR(TODAY())-1,12,21  )","v":"2021-12-21"},{"$f":"DATE(YEAR(TODAY())-1,12,22)","v":"2021-12-22"},"Ostatní",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":2}]
[null,"Zaměstnanec 1",{"$f":"DATE(YEAR(TODAY())-1,12,14  )","v":"2021-12-14"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Dovolená",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":3}]
[null,"Zaměstnanec 2",{"$f":"DATE(YEAR(TODAY())-1,11,29  )","v":"2021-11-29"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2021-12-06"},"Úmrtí v rodině",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":6}]
[null,"Zaměstnanec 5",{"$f":"DATE(YEAR(TODAY())-1,12,3  )","v":"2021-12-03"},{"$f":"DATE(YEAR(TODAY())-1,12,7)","v":"2021-12-07"},"Dovolená",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":3}]
[null,"Zaměstnanec 1",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2022-01-31"},{"$f":"DATE(YEAR(TODAY()),2,2)","v":"2022-02-02"},"Úmrtí v rodině",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":3}]
[null,"Zaměstnanec 1",{"$f":"DATE(YEAR(TODAY())-1,11,24 )","v":"2021-11-24"},{"$f":"DATE(YEAR(TODAY())-1,11,29)","v":"2021-11-29"},"Nemoc",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":4}]
[null,"Zaměstnanec 2",{"$f":"DATE(YEAR(TODAY()),12,5 )","v":"2022-12-05"},{"$f":"DATE(YEAR(TODAY()),12,9)","v":"2022-12-09"},"Dovolená",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":5}]
[null,"Zaměstnanec 5",{"$f":"DATE(YEAR(TODAY()),4,11 )","v":"2022-04-11"},{"$f":"DATE(YEAR(TODAY()),4,19)","v":"2022-04-19"},"Dovolená",{"$f":"NETWORKDAYS(Sledování_nepřítomnosti[[#This Row],[Počáteční datum]],Sledování_nepřítomnosti[[#This Row],[Koncové datum]],lstHolidays)","v":7}]

{"sheet":"Seznam zaměstnanců","index":2,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Seznam zaměstnanců"]
[]
[null,"Jména zaměstnanců"]
[null,"Zaměstnanec 1"]
[null,"Zaměstnanec 2"]
[null,"Zaměstnanec 3"]
[null,"Zaměstnanec 4"]
[null,"Zaměstnanec 5"]

{"sheet":"Typy nepřítomnosti","index":3,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"Typy nepřítomnosti"]
[]
[null,"Seznam typů nepřítomnosti"]
[null,"Nemoc"]
[null,"Dovolená"]
[null,"Úmrtí v rodině"]
[null,"Ostatní"]

{"sheet":"Celofiremní svátky","index":4,"n_rows":9,"n_cols":3,"rows_kept":9}
[null,"Celofiremní svátky"]
[]
[null,"Celofiremní volno","Popis"]
[null,{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2022-01-01"},"Nový rok"]
[null,{"$f":"DATE(YEAR(TODAY()),7,4)","v":"2022-07-04"},"Den nezávislosti"]
[null,{"$f":"DATE(YEAR(TODAY()),11,24)","v":"2022-11-24"},"Den díkůvzdání"]
[null,{"$f":"DATE(YEAR(TODAY()),11,25)","v":"2022-11-25"},"Den díkůvzdání"]
[null,{"$f":"DATE(YEAR(TODAY()),12,24)","v":"2022-12-24"},"Vánoce"]
[null,{"$f":"DATE(YEAR(TODAY()),12,25)","v":"2022-12-25"},"Vánoce"]