{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["baza"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":0,"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":"baza","index":0,"n_rows":33,"n_cols":80,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,29,1,32],[6,32,6,60],[25,40,25,42],[26,40,26,42],[6,0,8,0],[6,1,6,31],[1,5,2,26],[3,11,4,14],[3,19,4,26],[3,16,4,18]]}
[]
[null,null,null,null,null,"DNEVNA EVIDENCIJA PRISUSTVA NA RADNOM MJESTU"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ZA",null,null,null,null,2016,null,null,"GODINE"]
[]
[null,{"$f":"WEEKDAY(B8,2)","v":5},6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,{"$f":"WEEKDAY(AF8,2)","v":7},1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1]
["IME","JANUAR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FEBRUAR"]
[null,{"$f":"DATE(god,1,1)","v":"2016-01-01"},{"$f":"B8+1","v":"2016-01-02"},{"$f":"C8+1","v":"2016-01-03"},"2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09","2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","2016-01-16","2016-01-17","2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23","2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28","2016-01-29","2016-01-30","2016-01-31","2016-02-01","2016-02-02","2016-02-03","2016-02-04","2016-02-05","2016-02-06","2016-02-07","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-13","2016-02-14","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-20","2016-02-21","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28","2016-02-29","2016-03-01",{"$f":"BJ8+1","v":"2016-03-02"},{"$f":"BK8+1","v":"2016-03-03"},{"$f":"BL8+1","v":"2016-03-04"},{"$f":"BM8+1","v":"2016-03-05"},{"$f":"BN8+1","v":"2016-03-06"},{"$f":"BO8+1","v":"2016-03-07"},{"$f":"BP8+1","v":"2016-03-08"},{"$f":"BQ8+1","v":"2016-03-09"},{"$f":"BR8+1","v":"2016-03-10"},{"$f":"BS8+1","v":"2016-03-11"},{"$f":"BT8+1","v":"2016-03-12"},{"$f":"BU8+1","v":"2016-03-13"},{"$f":"BV8+1","v":"2016-03-14"},{"$f":"BW8+1","v":"2016-03-15"},{"$f":"BX8+1","v":"2016-03-16"},{"$f":"BY8+1","v":"2016-03-17"},{"$f":"BZ8+1","v":"2016-03-18"},{"$f":"CA8+1","v":"2016-03-19"}]
[null,{"$f":"TEXT(B8,\"ddd\")","v":"Fri"},{"$f":"TEXT(C8,\"ddd\")","v":"Sat"},"Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun",{"$f":"TEXT(BI8,\"ddd\")","v":"Mon"},"Tue",{"$f":"TEXT(BK8,\"ddd\")","v":"Wed"},"Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat"]
["1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
["2","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
["3",null,null,null,null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
["4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
["5","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
["6","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
["7","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B",null,null,null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
["8","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B",null,null,null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B"]
["9","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B",null,null,null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
["10","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B",null,null,null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBRAČUN BOLOVANJA ZA MJESEC FEBRUAR"]
[]
[null,null,"Kako da izračunam bolovanje do 30 dana (plavo) a kako preko 30 dana (žuto)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IME",null,"UKUPNO",null,null,null,"DO 30",null,null,"PREKO 30",null,null,null,null,null,null,"Preko30"]
[null,null,"Bolovanje preko 30 kalendarskih dana (uključujući i vikend) je obojeno žuto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,{"$f":"COUNTIF(AG10:BI10,\"B\")","v":26},null,null,18,null,null,null,null,null,null,null,null,null,{"$f":"BolPreko30(AG10:BI10,$AG$8:$BI$8)","v":0}]
[null,null,"Na primeru sam prikazao više varijanti da bi se moglo videti razlika bolovanja",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,29,null,null,null,null,null,21,null,null,null,null,null,null,{"$f":"BolPreko30(AG11:BI11,$AG$8:$BI$8)","v":21}]
[null,null,"Prazna mjesta se popunjavaju uglavnom sa X ili neko drugo slovo što zanči da je radio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATUM OD ",null,null,null,"2016-02-01",null,null,null,3,null,null,29,null,null,7,null,null,14,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATUM DO ",null,null,null,"2016-02-29",null,null,null,4,null,null,29,null,null,17,null,null,4,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,19,null,null,null,null,null,15,null,null,null,null,null,null,15]
[null,null,"Formula bi trebala biti vezana za datum jer je i red 8 datum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,12,null,null,null,null,null,10,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,29,null,null,21,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,20,null,null,6,null,null,10,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,20,null,null,11,null,null,5,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,29,null,null,17,null,null,4,null,null,null,null,null,null,4]