{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Procena ušteđevine"],"not_rendered":{"charts":1,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"Procena ušteđevine","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[0,0,0,6],[4,2,4,4],[5,2,5,4],[5,5,5,6],[9,2,9,3],[10,2,10,3],[13,2,13,3],[17,2,17,3],[18,2,18,3]]}
["PUTOVANJE U MEKSIKO ZA ZIMSKI RASPUST"]
[]
[]
[]
[null," Započni štednju datuma:"," Završi štednju do datuma:",{"$nulls":3}," Uštedite novac:"]
[null,{"$f":"TODAY()-120","v":"2012-09-18"},{"$f":"DateSavingsBegin+180","v":"2013-03-17"},null,null,"DVOSEDMIČNO"]
[]
[]
[]
[null,"TROŠKOVI PUTOVANJA:",{"v":6000,"d":"6,000 Din."}]
[null,"PRETHODNA ŠTEDNJA:",{"v":300,"d":"300 Din."}]
[]
[]
[null,"TRENUTAN CILJ ŠTEDNJE:",{"$f":"EventCost-Sačuvaniznos","v":{"v":5700,"d":"5,700 Din."}}]
[]
[]
[{"$f":"IF(SavingsPlanInfo>0,\"  Ako sačuvam \"&TEXT(SavingsPlanInfo,\"#.##0 Din. \")&LOWER(SavingFrequency)&\", od \"&TEXT(TODAY(),\"d.m.yyyy\"&\":\"),\"  Datum događaja je preblizu \"&Declinations&\" planu uštede.\")","v":"  Ako sačuvam 475 Din. dvosedmično, od 16.1.2013:"}]
[null,"Uštedeo sam:",{"$f":" IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*DailySavings,0)+Sačuvaniznos,Sačuvaniznos)","v":{"v":4100,"d":"4,100 Din."}}]
[null,"Treba da uštedim još:",{"$f":"MAX(0,EventCost-SavingsToDate)","v":{"v":1900,"d":"1,900 Din."}}]
[]
[]
[]
["DETALJI O PLANU ŠTEDNJE"]
[null,"Trajanje štednje","Dnevno","Sedmično","Dvosedmično","Mesečno","Godišnje"]
[null,"Količina za uštedu:",{"$f":"MIN(Cilj,IF(DaysUntilEvent=\"\",0,Cilj/DaysUntilEvent))","v":{"v":31.666666666666668,"d":"32 Din."}},{"$f":"MIN(Cilj,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,Cilj/WeeksUntilEvent)))","v":{"v":221.66666666666666,"d":"222 Din."}},{"$f":"IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(Cilj,IF(D25=\"\",0,Cilj/BiWeeksUntilEvent)))","v":{"v":475,"d":"475 Din."}},{"$f":"MIN(Cilj,IF(Cilj=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,Cilj/MonthsUntilEvent)))","v":{"v":1140,"d":"1,140 Din."}},{"$f":"IF(OR(Cilj=\"\",Cilj=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,Cilj/YearsUntilEvent))","v":{"v":0,"d":"0 Din."}}]
[]
[null,"Vremenski interval","Dana","Sedmice","Dvosedmično","Meseci","Godine"]
[null,"Vreme do postizanja cilja:",{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"D\"),\"\")","v":180},{"$f":"IF(DaysUntilEvent<>\"\",DaysUntilEvent/7,\"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IF(OR(WeeksUntilEvent=0,WeeksUntilEvent=\"\"),0,ROUNDDOWN(WeeksUntilEvent/2,0))","v":12},{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"M\"),\"\")","v":5},{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"Y\"),\"\")","v":0}]