{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Popis obveza projekta 1","Postavke i izračuni"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Popis obveza projekta 1","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Popis obveza projekta"]
[]
[null,"Potrebno završiti do:",null,null,"Rok",null,"Aktivnosti isticanja"]
[null,"Marija Poljak",null,null,{"$f":"TODAY()+95","v":"2019-08-18"},null,"     Ovaj tjedan [18 srp do 24srp.]"]
[]
[null,"Projekt 1"]
[null,"Aktivnost","Krajnji rok","Proračun","% dovršenosti","Napredak","Napomene"," "]
[null,"Planiranje",{"$f":"TODAY()-90","v":"2019-02-14"},{"v":476,"d":"476.00 kn"},{"v":0.25,"d":"25%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":0.25,"d":"25%"}}]
[null,"Priprema",{"$f":"TODAY()-2","v":"2019-05-13"},{"v":301,"d":"301.00 kn"},{"v":0.1,"d":"10%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":0.1,"d":"10%"}}]
[null,"Zadatak A",{"$f":"TODAY()-7","v":"2019-05-08"},{"v":429,"d":"429.00 kn"},{"v":0,"d":"0%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":0,"d":"0%"}}]
[null,"Zadatak B",{"$f":"TODAY()+20","v":"2019-06-04"},{"v":332,"d":"332.00 kn"},{"v":0.7,"d":"70%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":0.7,"d":"70%"}}]
[null,"Zadatak C",{"$f":"TODAY()+40","v":"2019-06-24"},{"v":471,"d":"471.00 kn"},{"v":0.1,"d":"10%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":0.1,"d":"10%"}}]
[null,"Zadatak D",{"$f":"TODAY()+45","v":"2019-06-29"},{"v":418,"d":"418.00 kn"},{"v":1,"d":"100%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":1,"d":"100%"}}]
[null,"Administracija",{"$f":"TODAY()+55","v":"2019-07-09"},{"v":150,"d":"150.00 kn"},{"v":0,"d":"0%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":0,"d":"0%"}},"Započnite nakon dovršetka zadatka B"]
[null,"Uručeno",{"$f":"TODAY()+70","v":"2019-07-24"},{"v":330,"d":"330.00 kn"},{"v":0.25,"d":"25%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":0.25,"d":"25%"}}]
[null,"Daljnji rad",{"$f":"TODAY()+90","v":"2019-08-13"},{"v":353,"d":"353.00 kn"},{"v":0.5,"d":"50%"},{"$f":"tblPopisObveza[[#This Row],[% dovršenosti]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Postavke i izračuni","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Postavke isticanja"]
[null,"U tablice u nastavku spremaju se postavke i izračuni za padajući popis Aktivnosti isticanja. Bilo kakve promjene mogu za posljedicu imati pogreške ili gubitak funkcije."]
[null,"Bez isticanja",null,null,{"$f":"B5","v":"Bez isticanja"}]
[null,"Interval:","Početak:","Završetak:","Rok:"]
[null,"Ovaj tjedan",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2019-05-13"},{"$f":"C7+6","v":"2019-05-19"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":"Ovaj tjedan [13 May - 19 May]"}]
[null,"Ovaj mjesec",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2019-05-01"},{"$f":"EDATE(C8,1)-1","v":"2019-05-31"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d, mmm\")&\"]\"","v":"Ovaj mjesec [1 - 31, May]"}]
[null,"Prvo tromjesečje",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2019-02-01"},{"$f":"EDATE(C9,4)-1","v":"2019-05-31"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"Prvo tromjesečje [1 Feb - 31 May]"}]
[null,"Ova godina",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2019-01-01"},{"$f":"EDATE(C10,12)-1","v":"2019-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"yyyy\")&\"]\"","v":"Ova godina [2019]"}]
[null,"Interval:",null,null,{"$f":"B11","v":"Interval:"}]
[null,"Prošli tjedan",{"$f":"C7-7","v":"2019-05-06"},{"$f":"C12+6","v":"2019-05-12"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":"Prošli tjedan [6 May - 12 May]"}]
[null,"Prošli mjesec",{"$f":"EDATE(C8,-1)","v":"2019-04-01"},{"$f":"EDATE(C13,1)-1","v":"2019-04-30"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d, mmm\")&\"]\"","v":"Prošli mjesec [1 - 30, Apr]"}]
[null,"Prošle tromjesečje",{"$f":"EDATE(C9,-3)","v":"2018-11-01"},{"$f":"EDATE(C14,3)-1","v":"2019-01-31"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":"Prošle tromjesečje [1 Nov - 31 Jan]"}]
[null,"Prošla godina",{"$f":"EDATE(C10,-12)","v":"2018-01-01"},{"$f":"EDATE(C15,12)-1","v":"2018-12-31"},{"$f":"B15","v":"Prošla godina"}]
[]
[null,"Odabrano isticanje",{"$f":"IFERROR(MATCH(IstakniAktivnosti,PrveIstaknuteObveze,0),\"\")","v":""},{"$f":"IstakniAktivnosti","v":"     Ovaj tjedan [18 srp do 24srp.]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Početak isticanja",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Završetak isticanja",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]