{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Widok kalendarza","Ewidencja nieobecności pracowni","Lista pracowników","Typy nieobecności","Dni wolne od pracy"],"not_rendered":{"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Widok kalendarza","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,"REJESTR OBECNOŚCI PRACOWNIKA"]
[null,"Wybierz pracownika:","Pracownik 1"]
[null,"Wprowadź rok:",{"$f":"YEAR(TODAY())","v":2022}]
[]
[null,"Dzień tygodnia/miesiąc","PON","WT","ŚR","CZW","PT","SOB","NIEDZ","PON   ","WT   ","ŚR   ","CZW   ","PT   ","SOB   ","NIEDZ    ","PON    ","WT    ","ŚR    ","CZW    ","PT    ","SOB    ","NIEDZ     ","PON     ","WT     ","ŚR      ","CZW  ","PT     ","SOB     ","NIEDZ            ","PON ","WT ","ŚR ","CZW ","PT ","SOB      ","NIEDZ  ","PON  ","WT  ","ŚR  ","CZW          ","PT  ","SOB  ","NIEDZ       "]
[null,"StyCZWeń",{"$f":"IFERROR(IF(TEXT(DATE(Rok_kalendarzowy,ROW($A1),1),\"ddd\")=LEFT(C$5,5),DATE(Rok_kalendarzowy,ROW($A1),1),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TEXT(DATE(Rok_kalendarzowy,ROW($A1),1),\"ddd\")=LEFT(D$5,5),DATE(Rok_kalendarzowy,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(Rok_kalendarzowy,ROW($A1)+1,0)),AK6+1,\"\"),\"\")","v":""},"","","","","",""]
[null,"Luty","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Marzec","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Kwiecień","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Maj","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"CZWerwiec","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Lipiec","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Sierpień","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Wrzesień","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Październik","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Listopad","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Grudzień","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"NAJWAŻNJSZE STATYSTYKI"]
[null,null,"Dni Nobecności",{"$nulls":4},"Dni roboCZWe",{"$nulls":5},"LiCZWba dni na zwolNniu lekarskim",{"$nulls":4},"Urlop",{"$nulls":4},"Urlop okoliCZWnościowy",{"$nulls":4},"Inne"]
[null,null,{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy+1,1,1))","v":4},{"$nulls":4},{"$f":"NETWORKDAYS(DATE(Rok_kalendarzowy,1,1),EDATE(DATE(Rok_kalendarzowy,1,1),12)-1)","v":260},{"$nulls":5},{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy+1,1,1),Ewidencja_nieobecności[Typ nieobecności],'Typy nieobecności'!B4)","v":1},{"$nulls":4},{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy+1,1,1),Ewidencja_nieobecności[Typ nieobecności],'Typy nieobecności'!B5)","v":0},{"$nulls":4},{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy+1,1,1),Ewidencja_nieobecności[Typ nieobecności],'Typy nieobecności'!B6)","v":3},{"$nulls":4},{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy+1,1,1),Ewidencja_nieobecności[Typ nieobecności],'Typy nieobecności'!B7)","v":0}]
[null,null,{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy-1,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy,1,1))","v":13},{"$nulls":4},{"$f":"NETWORKDAYS(DATE(Rok_kalendarzowy-1,1,1),EDATE(DATE(Rok_kalendarzowy-1,1,1),12)-1)","v":261},{"$nulls":5},{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy-1,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Typ nieobecności],'Typy nieobecności'!B4)","v":4},{"$nulls":4},{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy-1,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Typ nieobecności],'Typy nieobecności'!B5)","v":7},{"$nulls":4},{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy-1,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Typ nieobecności],'Typy nieobecności'!B6)","v":0},{"$nulls":4},{"$f":"SUMIFS(Ewidencja_nieobecności[Dni],Ewidencja_nieobecności[Imię i nazwisko pracownika],wart_Wyb_pracownika,Ewidencja_nieobecności[Data rozpoczęcia],\">=\"&DATE(Rok_kalendarzowy-1,1,1),Ewidencja_nieobecności[Data zakończenia],\"<\"&DATE(Rok_kalendarzowy,1,1),Ewidencja_nieobecności[Typ nieobecności],'Typy nieobecności'!B7)","v":2}]
[null,null,{"$f":"IFERROR(IF(C21<>0,IF(C20>=C21,\"W GÓRĘ \", \"W DÓŁ \")&TEXT(C20/C21-1,\"0%;0%\"),\"W GÓRĘ 100%\"),\"\")","v":"W DÓŁ 69%"},{"$nulls":4},{"$f":"IFERROR(IF(H21<>0,IF(H20>=H21,\"W GÓRĘ \", \"W DÓŁ \")&TEXT(H20/H21-1,\"0%;0%\"),\"W GÓRĘ 100%\"),\"\")","v":"W DÓŁ 0%"},{"$nulls":5},{"$f":"IFERROR(IF(N21<>0,IF(N20>=N21,\"W GÓRĘ \", \"W DÓŁ \")&TEXT(N20/N21-1,\"0%;0%\"),\"W GÓRĘ 100%\"),\"\")","v":"W DÓŁ 75%"},{"$nulls":4},{"$f":"IFERROR(IF(S21<>0,IF(S20>=S21,\"W GÓRĘ \", \"W DÓŁ \")&TEXT(S20/S21-1,\"0%;0%\"),\"W GÓRĘ 100%\"),\"\")","v":"W DÓŁ 100%"},{"$nulls":4},{"$f":"IFERROR(IF(X21<>0,IF(X20>=X21,\"W GÓRĘ \", \"W DÓŁ \")&TEXT(X20/X21-1,\"0%;0%\"),\"W GÓRĘ 100%\"),\"\")","v":"W GÓRĘ 100%"},{"$nulls":4},{"$f":"IFERROR(IF(AC21<>0,IF(AC20>=AC21,\"W GÓRĘ \", \"W DÓŁ \")&TEXT(AC20/AC21-1,\"0%;0%\"),\"W GÓRĘ 100%\"),\"\")","v":"W DÓŁ 100%"}]

{"sheet":"Ewidencja nieobecności pracowni","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Ewidencja nieobecności pracownika"]
[]
[null,"Imię i nazwisko pracownika","Data rozpoczęcia","Data zakończenia","Typ nieobecności","Dni"]
[null,"Pracownik 1",{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2022-01-03"},{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2022-01-03"},"Zwolnienie lekarskie",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":1}]
[null,"Pracownik 2",{"$f":"DATE(YEAR(TODAY()),1,17)","v":"2022-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2022-01-18"},"Inne",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":2}]
[null,"Pracownik 3",{"$f":"DATE(YEAR(TODAY()),1,18 )","v":"2022-01-18"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2022-01-21"},"Inne",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":4}]
[null,"Pracownik 5",{"$f":"DATE(YEAR(TODAY())-1,12,10 )","v":"2021-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Urlop okolicznościowy",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":5}]
[null,"Pracownik 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2021-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,2)","v":"2021-12-02"},"Zwolnienie lekarskie",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":2}]
[null,"Pracownik 1",{"$f":"DATE(YEAR(TODAY())-1,11,14  )","v":"2021-11-14"},{"$f":"DATE(YEAR(TODAY())-1,11,18)","v":"2021-11-18"},"Urlop",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":4}]
[null,"Pracownik 4",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2022-01-31"},{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2022-02-04"},"Zwolnienie lekarskie",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":5}]
[null,"Pracownik 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2021-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2021-12-06"},"Inne",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":4}]
[null,"Pracownik 4",{"$f":"DATE(YEAR(TODAY())-1,12,10  )","v":"2021-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Inne",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":5}]
[null,"Pracownik 2",{"$f":"DATE(YEAR(TODAY()),1,13 )","v":"2022-01-13"},{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2022-01-15"},"Zwolnienie lekarskie",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":2}]
[null,"Pracownik 5",{"$f":"DATE(YEAR(TODAY()),1,15 )","v":"2022-01-15"},{"$f":"DATE(YEAR(TODAY()),1,20)","v":"2022-01-20"},"Zwolnienie lekarskie",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":4}]
[null,"Pracownik 2",{"$f":"DATE(YEAR(TODAY()),6,13 )","v":"2022-06-13"},{"$f":"DATE(YEAR(TODAY()),6,15)","v":"2022-06-15"},"Urlop okolicznościowy",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":3}]
[null,"Pracownik 5",{"$f":"DATE(YEAR(TODAY()),1,27 )","v":"2022-01-27"},{"$f":"DATE(YEAR(TODAY()),2,3)","v":"2022-02-03"},"Urlop okolicznościowy",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":6}]
[null,"Pracownik 3",{"$f":"DATE(YEAR(TODAY()),1,17 )","v":"2022-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2022-01-18"},"Urlop",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":2}]
[null,"Pracownik 3",{"$f":"DATE(YEAR(TODAY())-1,12,12 )","v":"2021-12-12"},{"$f":"DATE(YEAR(TODAY())-1,12,17)","v":"2021-12-17"},"Urlop okolicznościowy",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":5}]
[null,"Pracownik 1",{"$f":"DATE(YEAR(TODAY())-1,12,21  )","v":"2021-12-21"},{"$f":"DATE(YEAR(TODAY())-1,12,22)","v":"2021-12-22"},"Inne",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":2}]
[null,"Pracownik 1",{"$f":"DATE(YEAR(TODAY())-1,12,14  )","v":"2021-12-14"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Urlop",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":3}]
[null,"Pracownik 2",{"$f":"DATE(YEAR(TODAY())-1,11,29  )","v":"2021-11-29"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2021-12-06"},"Urlop okolicznościowy",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":6}]
[null,"Pracownik 5",{"$f":"DATE(YEAR(TODAY())-1,12,3  )","v":"2021-12-03"},{"$f":"DATE(YEAR(TODAY())-1,12,7)","v":"2021-12-07"},"Urlop",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":3}]
[null,"Pracownik 1",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2022-01-31"},{"$f":"DATE(YEAR(TODAY()),2,2)","v":"2022-02-02"},"Urlop okolicznościowy",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":3}]
[null,"Pracownik 1",{"$f":"DATE(YEAR(TODAY())-1,11,24 )","v":"2021-11-24"},{"$f":"DATE(YEAR(TODAY())-1,11,29)","v":"2021-11-29"},"Zwolnienie lekarskie",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":4}]
[null,"Pracownik 2",{"$f":"DATE(YEAR(TODAY()),12,5 )","v":"2022-12-05"},{"$f":"DATE(YEAR(TODAY()),12,9)","v":"2022-12-09"},"Urlop",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":5}]
[null,"Pracownik 5",{"$f":"DATE(YEAR(TODAY()),4,11 )","v":"2022-04-11"},{"$f":"DATE(YEAR(TODAY()),4,19)","v":"2022-04-19"},"Urlop",{"$f":"NETWORKDAYS(Ewidencja_nieobecności[[#This Row],[Data rozpoczęcia]],Ewidencja_nieobecności[[#This Row],[Data zakończenia]],lst_Dni_wolne)","v":7}]

{"sheet":"Lista pracowników","index":2,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Lista pracowników"]
[]
[null,"Nazwiska pracowników"]
[null,"Pracownik 1"]
[null,"Pracownik 2"]
[null,"Pracownik 3"]
[null,"Pracownik 4"]
[null,"Pracownik 5"]

{"sheet":"Typy nieobecności","index":3,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"Typy nieobecności"]
[]
[null,"Lista typów nieobecności"]
[null,"Zwolnienie lekarskie"]
[null,"Urlop"]
[null,"Urlop okolicznościowy"]
[null,"Inne"]

{"sheet":"Dni wolne od pracy","index":4,"n_rows":9,"n_cols":3,"rows_kept":9}
[null,"Dni wolne od pracy"]
[]
[null,"Dni wolne od pracy","Opis"]
[null,{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2022-01-01"},"Nowy Rok"]
[null,{"$f":"DATE(YEAR(TODAY()),7,4)","v":"2022-07-04"},"Święto Niepodległości"]
[null,{"$f":"DATE(YEAR(TODAY()),11,24)","v":"2022-11-24"},"Wielkanoc"]
[null,{"$f":"DATE(YEAR(TODAY()),11,25)","v":"2022-11-25"},"Wielkanoc"]
[null,{"$f":"DATE(YEAR(TODAY()),12,24)","v":"2022-12-24"},"Boże Narodzenie"]
[null,{"$f":"DATE(YEAR(TODAY()),12,25)","v":"2022-12-25"},"Boże Narodzenie"]