{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Prikaz kalendara","Praćenje odsustava zaposlenih","Lista zaposlenih","Tipovi odsustva","Praznici preduzeća"],"not_rendered":{"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Prikaz kalendara","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,"ZAPIS O PRISUTNOSTI ZAPOSLENOG"]
[null,"Izaberite zaposlenog:","Zaposleni 1"]
[null,"Unesite godinu:",{"$f":"YEAR(TODAY())","v":2022}]
[]
[null,"Radni dan/mesec","PON","UTO","SRE","ČET","PET","SUB","NED","PON   ","UTO  ","SRE   ","ČET   ","PЕT   ","SUB   ","NED    ","PON    ","UTO    ","SRE    ","ČET    ","PЕT    ","SUB    ","NED     ","PON     ","UTO     ","SRE     ","ČET  ","PЕT     ","SUB     ","NED ","PON ","UTO ","SRE ","ČET ","PЕT ","SUB ","NED  ","PON  ","UTO        ","SRE  ","ČET     ","PET  ","SUB  ","NED      "]
[null,"Januar",{"$f":"IFERROR(IF(TEXT(DATE(Kalendarska_godina,ROW($A1),1),\"ddd\")=LEFT(C$5,3),DATE(Kalendarska_godina,ROW($A1),1),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TEXT(DATE(Kalendarska_godina,ROW($A1),1),\"ddd\")=LEFT(D$5,3),DATE(Kalendarska_godina,ROW($A1),1),IF(C6>=1,C6+1,\"\")),\"\")","v":""},"","",{"$f":"IFERROR(IF(TEXT(DATE(Kalendarska_godina,ROW($A1),1),\"ddd\")=LEFT(G$5,3),DATE(Kalendarska_godina,ROW($A1),1),IF(F6>=1,F6+1,\"\")),\"\")","v":""},"2022-01-01","2022-01-02",{"$f":"IFERROR(IF(I6>=1,I6+1,\"\"),\"\")","v":"2022-01-03"},{"$f":"IFERROR(IF(J6>=1,J6+1,\"\"),\"\")","v":"2022-01-04"},{"$f":"IFERROR(IF(K6>=1,K6+1,\"\"),\"\")","v":"2022-01-05"},{"$f":"IFERROR(IF(L6>=1,L6+1,\"\"),\"\")","v":"2022-01-06"},{"$f":"IFERROR(IF(M6>=1,M6+1,\"\"),\"\")","v":"2022-01-07"},{"$f":"IFERROR(IF(N6>=1,N6+1,\"\"),\"\")","v":"2022-01-08"},{"$f":"IFERROR(IF(O6>=1,O6+1,\"\"),\"\")","v":"2022-01-09"},{"$f":"IFERROR(IF(P6>=1,P6+1,\"\"),\"\")","v":"2022-01-10"},{"$f":"IFERROR(IF(Q6>=1,Q6+1,\"\"),\"\")","v":"2022-01-11"},{"$f":"IFERROR(IF(R6>=1,R6+1,\"\"),\"\")","v":"2022-01-12"},{"$f":"IFERROR(IF(S6>=1,S6+1,\"\"),\"\")","v":"2022-01-13"},{"$f":"IFERROR(IF(T6>=1,T6+1,\"\"),\"\")","v":"2022-01-14"},{"$f":"IFERROR(IF(U6>=1,U6+1,\"\"),\"\")","v":"2022-01-15"},{"$f":"IFERROR(IF(V6>=1,V6+1,\"\"),\"\")","v":"2022-01-16"},{"$f":"IFERROR(IF(W6>=1,W6+1,\"\"),\"\")","v":"2022-01-17"},{"$f":"IFERROR(IF(X6>=1,X6+1,\"\"),\"\")","v":"2022-01-18"},{"$f":"IFERROR(IF(Y6>=1,Y6+1,\"\"),\"\")","v":"2022-01-19"},{"$f":"IFERROR(IF(Z6>=1,Z6+1,\"\"),\"\")","v":"2022-01-20"},{"$f":"IFERROR(IF(AA6>=1,AA6+1,\"\"),\"\")","v":"2022-01-21"},{"$f":"IFERROR(IF(AB6>=1,AB6+1,\"\"),\"\")","v":"2022-01-22"},{"$f":"IFERROR(IF(AC6>=1,AC6+1,\"\"),\"\")","v":"2022-01-23"},{"$f":"IFERROR(IF(AD6>=1,AD6+1,\"\"),\"\")","v":"2022-01-24"},{"$f":"IFERROR(IF(AE6>=1,AE6+1,\"\"),\"\")","v":"2022-01-25"},{"$f":"IFERROR(IF(AF6>=1,AF6+1,\"\"),\"\")","v":"2022-01-26"},{"$f":"IFERROR(IF(AG6>=1,AG6+1,\"\"),\"\")","v":"2022-01-27"},{"$f":"IFERROR(IF(AH6>=1,AH6+1,\"\"),\"\")","v":"2022-01-28"},{"$f":"IFERROR(IF(AI6>=1,AI6+1,\"\"),\"\")","v":"2022-01-29"},{"$f":"IFERROR(IF(AJ6>=1,AJ6+1,\"\"),\"\")","v":"2022-01-30"},{"$f":"IFERROR(IF(AND(AK6>=1,AK6+1<=DATE(Kalendarska_godina,ROW($A1)+1,0)),AK6+1,\"\"),\"\")","v":"2022-01-31"},"","","","","",""]
[null,"Februar","","2022-02-01","2022-02-02","2022-02-03","2022-02-04","2022-02-05","2022-02-06","2022-02-07","2022-02-08","2022-02-09","2022-02-10","2022-02-11","2022-02-12","2022-02-13","2022-02-14","2022-02-15","2022-02-16","2022-02-17","2022-02-18","2022-02-19","2022-02-20","2022-02-21","2022-02-22","2022-02-23","2022-02-24","2022-02-25","2022-02-26","2022-02-27","2022-02-28","2022-03-01","2022-03-02","2022-03-03","2022-03-04","2022-03-05","2022-03-06","","","","","","",""]
[null,"Mart","","2022-03-01","2022-03-02","2022-03-03","2022-03-04","2022-03-05","2022-03-06","2022-03-07","2022-03-08","2022-03-09","2022-03-10","2022-03-11","2022-03-12","2022-03-13","2022-03-14","2022-03-15","2022-03-16","2022-03-17","2022-03-18","2022-03-19","2022-03-20","2022-03-21","2022-03-22","2022-03-23","2022-03-24","2022-03-25","2022-03-26","2022-03-27","2022-03-28","2022-03-29","2022-03-30","2022-03-31","2022-04-01","2022-04-02","2022-04-03","","","","","","",""]
[null,"April","","","","","2022-04-01","2022-04-02","2022-04-03","2022-04-04","2022-04-05","2022-04-06","2022-04-07","2022-04-08","2022-04-09","2022-04-10","2022-04-11","2022-04-12","2022-04-13","2022-04-14","2022-04-15","2022-04-16","2022-04-17","2022-04-18","2022-04-19","2022-04-20","2022-04-21","2022-04-22","2022-04-23","2022-04-24","2022-04-25","2022-04-26","2022-04-27","2022-04-28","2022-04-29","2022-04-30","2022-05-01","","","","","","",""]
[null,"Maj","","","","","","","2022-05-01","2022-05-02","2022-05-03","2022-05-04","2022-05-05","2022-05-06","2022-05-07","2022-05-08","2022-05-09","2022-05-10","2022-05-11","2022-05-12","2022-05-13","2022-05-14","2022-05-15","2022-05-16","2022-05-17","2022-05-18","2022-05-19","2022-05-20","2022-05-21","2022-05-22","2022-05-23","2022-05-24","2022-05-25","2022-05-26","2022-05-27","2022-05-28","2022-05-29","2022-05-30","2022-05-31","","","","",""]
[null,"Jun","","","2022-06-01","2022-06-02","2022-06-03","2022-06-04","2022-06-05","2022-06-06","2022-06-07","2022-06-08","2022-06-09","2022-06-10","2022-06-11","2022-06-12","2022-06-13","2022-06-14","2022-06-15","2022-06-16","2022-06-17","2022-06-18","2022-06-19","2022-06-20","2022-06-21","2022-06-22","2022-06-23","2022-06-24","2022-06-25","2022-06-26","2022-06-27","2022-06-28","2022-06-29","2022-06-30","2022-07-01","2022-07-02","2022-07-03","","","","","","",""]
[null,"Jul","","","","","2022-07-01","2022-07-02","2022-07-03","2022-07-04","2022-07-05","2022-07-06","2022-07-07","2022-07-08","2022-07-09","2022-07-10","2022-07-11","2022-07-12","2022-07-13","2022-07-14","2022-07-15","2022-07-16","2022-07-17","2022-07-18","2022-07-19","2022-07-20","2022-07-21","2022-07-22","2022-07-23","2022-07-24","2022-07-25","2022-07-26","2022-07-27","2022-07-28","2022-07-29","2022-07-30","2022-07-31","","","","","","",""]
[null,"Avgust","2022-08-01","2022-08-02","2022-08-03","2022-08-04","2022-08-05","2022-08-06","2022-08-07","2022-08-08","2022-08-09","2022-08-10","2022-08-11","2022-08-12","2022-08-13","2022-08-14","2022-08-15","2022-08-16","2022-08-17","2022-08-18","2022-08-19","2022-08-20","2022-08-21","2022-08-22","2022-08-23","2022-08-24","2022-08-25","2022-08-26","2022-08-27","2022-08-28","2022-08-29","2022-08-30","2022-08-31","2022-09-01","2022-09-02","2022-09-03","2022-09-04","","","","","","",""]
[null,"Septembar","","","","2022-09-01","2022-09-02","2022-09-03","2022-09-04","2022-09-05","2022-09-06","2022-09-07","2022-09-08","2022-09-09","2022-09-10","2022-09-11","2022-09-12","2022-09-13","2022-09-14","2022-09-15","2022-09-16","2022-09-17","2022-09-18","2022-09-19","2022-09-20","2022-09-21","2022-09-22","2022-09-23","2022-09-24","2022-09-25","2022-09-26","2022-09-27","2022-09-28","2022-09-29","2022-09-30","2022-10-01","2022-10-02","","","","","","",""]
[null,"Oktobar","","","","","","2022-10-01","2022-10-02","2022-10-03","2022-10-04","2022-10-05","2022-10-06","2022-10-07","2022-10-08","2022-10-09","2022-10-10","2022-10-11","2022-10-12","2022-10-13","2022-10-14","2022-10-15","2022-10-16","2022-10-17","2022-10-18","2022-10-19","2022-10-20","2022-10-21","2022-10-22","2022-10-23","2022-10-24","2022-10-25","2022-10-26","2022-10-27","2022-10-28","2022-10-29","2022-10-30","2022-10-31","","","","","",""]
[null,"Novembar","","2022-11-01","2022-11-02","2022-11-03","2022-11-04","2022-11-05","2022-11-06","2022-11-07","2022-11-08","2022-11-09","2022-11-10","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","2022-11-16","2022-11-17","2022-11-18","2022-11-19","2022-11-20","2022-11-21","2022-11-22","2022-11-23","2022-11-24","2022-11-25","2022-11-26","2022-11-27","2022-11-28","2022-11-29","2022-11-30","2022-12-01","2022-12-02","2022-12-03","2022-12-04","","","","","","",""]
[null,"Decembar","","","","2022-12-01","2022-12-02","2022-12-03","2022-12-04","2022-12-05","2022-12-06","2022-12-07","2022-12-08","2022-12-09","2022-12-10","2022-12-11","2022-12-12","2022-12-13","2022-12-14","2022-12-15","2022-12-16","2022-12-17","2022-12-18","2022-12-19","2022-12-20","2022-12-21","2022-12-22","2022-12-23","2022-12-24","2022-12-25","2022-12-26","2022-12-27","2022-12-28","2022-12-29","2022-12-30","2022-12-31","2023-01-01","","","","","","",""]
[null,"KLJUČNI STATISTIČKI PODACI"]
[null,null,"Dani odsustva",{"$nulls":4},"Radni dani",{"$nulls":5},"Broj dana bolovanja",{"$nulls":4},"Odmor",{"$nulls":4},"Smrtni slučaj",{"$nulls":4},"Drugo"]
[null,null,{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina+1,1,1))","v":4},{"$nulls":4},{"$f":"NETWORKDAYS(DATE(Kalendarska_godina,1,1),EDATE(DATE(Kalendarska_godina,1,1),12)-1)","v":260},{"$nulls":5},{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina+1,1,1),Praćenje_odsustava[Tip odsustva],'Tipovi odsustva'!B4)","v":1},{"$nulls":4},{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina+1,1,1),Praćenje_odsustava[Tip odsustva],'Tipovi odsustva'!B5)","v":0},{"$nulls":4},{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina+1,1,1),Praćenje_odsustava[Tip odsustva],'Tipovi odsustva'!B6)","v":3},{"$nulls":4},{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina+1,1,1),Praćenje_odsustava[Tip odsustva],'Tipovi odsustva'!B7)","v":0}]
[null,null,{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina-1,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina,1,1))","v":13},{"$nulls":4},{"$f":"NETWORKDAYS(DATE(Kalendarska_godina-1,1,1),EDATE(DATE(Kalendarska_godina-1,1,1),12)-1)","v":261},{"$nulls":5},{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina-1,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Tip odsustva],'Tipovi odsustva'!B4)","v":4},{"$nulls":4},{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina-1,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Tip odsustva],'Tipovi odsustva'!B5)","v":7},{"$nulls":4},{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina-1,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Tip odsustva],'Tipovi odsustva'!B6)","v":0},{"$nulls":4},{"$f":"SUMIFS(Praćenje_odsustava[Dani],Praćenje_odsustava[Ime zaposlenog],valSelEmployee,Praćenje_odsustava[Datum početka],\">=\"&DATE(Kalendarska_godina-1,1,1),Praćenje_odsustava[Datum završetka],\"<\"&DATE(Kalendarska_godina,1,1),Praćenje_odsustava[Tip odsustva],'Tipovi odsustva'!B7)","v":2}]
[null,null,{"$f":"IFERROR(IF(C21<>0,IF(C20>=C21,\"GORE \", \"DOLE \")&TEXT(C20/C21-1,\"0%;0%\"),\"GORE 100%\"),\"\")","v":"DOLE 69%"},{"$nulls":4},{"$f":"IFERROR(IF(H21<>0,IF(H20>=H21,\"GORE \", \"DOLE \")&TEXT(H20/H21-1,\"0%;0%\"),\"GORE 100%\"),\"\")","v":"DOLE 0%"},{"$nulls":5},{"$f":"IFERROR(IF(N21<>0,IF(N20>=N21,\"GORE \", \"DOLE \")&TEXT(N20/N21-1,\"0%;0%\"),\"GORE 100%\"),\"\")","v":"DOLE 75%"},{"$nulls":4},{"$f":"IFERROR(IF(S21<>0,IF(S20>=S21,\"GORE \", \"DOLE \")&TEXT(S20/S21-1,\"0%;0%\"),\"GORE 100%\"),\"\")","v":"DOLE 100%"},{"$nulls":4},{"$f":"IFERROR(IF(X21<>0,IF(X20>=X21,\"GORE \", \"DOLE \")&TEXT(X20/X21-1,\"0%;0%\"),\"GORE 100%\"),\"\")","v":"GORE 100%"},{"$nulls":4},{"$f":"IFERROR(IF(AC21<>0,IF(AC20>=AC21,\"GORE \", \"DOLE \")&TEXT(AC20/AC21-1,\"0%;0%\"),\"GORE 100%\"),\"\")","v":"DOLE 100%"}]

{"sheet":"Praćenje odsustava zaposlenih","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Praćenje odsustava zaposlenih"]
[]
[null,"Ime zaposlenog","Datum početka","Datum završetka","Tip odsustva","Dani"]
[null,"Zaposleni 1",{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2022-01-03"},{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2022-01-03"},"Bolovanje",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":1}]
[null,"Zaposleni 2",{"$f":"DATE(YEAR(TODAY()),1,17)","v":"2022-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2022-01-18"},"Drugo",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":2}]
[null,"Zaposleni 3",{"$f":"DATE(YEAR(TODAY()),1,18 )","v":"2022-01-18"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2022-01-21"},"Drugo",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":4}]
[null,"Zaposleni 5",{"$f":"DATE(YEAR(TODAY())-1,12,10 )","v":"2021-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Smrtni slučaj",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":5}]
[null,"Zaposleni 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2021-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,2)","v":"2021-12-02"},"Bolovanje",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":2}]
[null,"Zaposleni 1",{"$f":"DATE(YEAR(TODAY())-1,11,14  )","v":"2021-11-14"},{"$f":"DATE(YEAR(TODAY())-1,11,18)","v":"2021-11-18"},"Odmor",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":4}]
[null,"Zaposleni 4",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2022-01-31"},{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2022-02-04"},"Bolovanje",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":5}]
[null,"Zaposleni 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2021-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2021-12-06"},"Drugo",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":4}]
[null,"Zaposleni 4",{"$f":"DATE(YEAR(TODAY())-1,12,10  )","v":"2021-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Drugo",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":5}]
[null,"Zaposleni 2",{"$f":"DATE(YEAR(TODAY()),1,13 )","v":"2022-01-13"},{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2022-01-15"},"Bolovanje",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":2}]
[null,"Zaposleni 5",{"$f":"DATE(YEAR(TODAY()),1,15 )","v":"2022-01-15"},{"$f":"DATE(YEAR(TODAY()),1,20)","v":"2022-01-20"},"Bolovanje",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":4}]
[null,"Zaposleni 2",{"$f":"DATE(YEAR(TODAY()),6,13 )","v":"2022-06-13"},{"$f":"DATE(YEAR(TODAY()),6,15)","v":"2022-06-15"},"Smrtni slučaj",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":3}]
[null,"Zaposleni 5",{"$f":"DATE(YEAR(TODAY()),1,27 )","v":"2022-01-27"},{"$f":"DATE(YEAR(TODAY()),2,3)","v":"2022-02-03"},"Smrtni slučaj",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":6}]
[null,"Zaposleni 3",{"$f":"DATE(YEAR(TODAY()),1,17 )","v":"2022-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2022-01-18"},"Odmor",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":2}]
[null,"Zaposleni 3",{"$f":"DATE(YEAR(TODAY())-1,12,12 )","v":"2021-12-12"},{"$f":"DATE(YEAR(TODAY())-1,12,17)","v":"2021-12-17"},"Smrtni slučaj",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":5}]
[null,"Zaposleni 1",{"$f":"DATE(YEAR(TODAY())-1,12,21  )","v":"2021-12-21"},{"$f":"DATE(YEAR(TODAY())-1,12,22)","v":"2021-12-22"},"Drugo",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":2}]
[null,"Zaposleni 1",{"$f":"DATE(YEAR(TODAY())-1,12,14  )","v":"2021-12-14"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2021-12-16"},"Odmor",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":3}]
[null,"Zaposleni 2",{"$f":"DATE(YEAR(TODAY())-1,11,29  )","v":"2021-11-29"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2021-12-06"},"Smrtni slučaj",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":6}]
[null,"Zaposleni 5",{"$f":"DATE(YEAR(TODAY())-1,12,3  )","v":"2021-12-03"},{"$f":"DATE(YEAR(TODAY())-1,12,7)","v":"2021-12-07"},"Odmor",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":3}]
[null,"Zaposleni 1",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2022-01-31"},{"$f":"DATE(YEAR(TODAY()),2,2)","v":"2022-02-02"},"Smrtni slučaj",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":3}]
[null,"Zaposleni 1",{"$f":"DATE(YEAR(TODAY())-1,11,24 )","v":"2021-11-24"},{"$f":"DATE(YEAR(TODAY())-1,11,29)","v":"2021-11-29"},"Bolovanje",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":4}]
[null,"Zaposleni 2",{"$f":"DATE(YEAR(TODAY()),12,5 )","v":"2022-12-05"},{"$f":"DATE(YEAR(TODAY()),12,9)","v":"2022-12-09"},"Odmor",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":5}]
[null,"Zaposleni 5",{"$f":"DATE(YEAR(TODAY()),4,11 )","v":"2022-04-11"},{"$f":"DATE(YEAR(TODAY()),4,19)","v":"2022-04-19"},"Odmor",{"$f":"NETWORKDAYS(Praćenje_odsustava[[#This Row],[Datum početka]],Praćenje_odsustava[[#This Row],[Datum završetka]],lstHolidays)","v":7}]

{"sheet":"Lista zaposlenih","index":2,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Lista zaposlenih"]
[]
[null,"Imena zaposlenih"]
[null,"Zaposleni 1"]
[null,"Zaposleni 2"]
[null,"Zaposleni 3"]
[null,"Zaposleni 4"]
[null,"Zaposleni 5"]

{"sheet":"Tipovi odsustva","index":3,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"Tipovi odsustva"]
[]
[null,"Lista tipova odsustva"]
[null,"Bolovanje"]
[null,"Odmor"]
[null,"Smrtni slučaj"]
[null,"Drugo"]

{"sheet":"Praznici preduzeća","index":4,"n_rows":9,"n_cols":3,"rows_kept":9}
[null,"Praznici preduzeća"]
[]
[null,"Praznici preduzeća","Opis"]
[null,{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2022-01-01"},"Nova godina"]
[null,{"$f":"DATE(YEAR(TODAY()),7,4)","v":"2022-07-04"},"Dan nezavisnosti"]
[null,{"$f":"DATE(YEAR(TODAY()),11,24)","v":"2022-11-24"},"Dan zahvalnosti"]
[null,{"$f":"DATE(YEAR(TODAY()),11,25)","v":"2022-11-25"},"Dan zahvalnosti"]
[null,{"$f":"DATE(YEAR(TODAY()),12,24)","v":"2022-12-24"},"Božić"]
[null,{"$f":"DATE(YEAR(TODAY()),12,25)","v":"2022-12-25"},"Božić"]