{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Ocenjevanje prihrankov"],"not_rendered":{"charts":1,"defined_names":23},"read":"whole","date_system":"1900"}

{"sheet":"Ocenjevanje prihrankov","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[0,1,0,6],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[4,2,4,3],[5,2,5,3],[7,2,7,3],[8,2,8,3]]}
[null,"ZIMSKE POČITNICE\nPOTOVANJE V MEHIKO"]
[null," Začetek varčevanja za:"," Končni datum prihrankov:",null," Prihranite denar:"]
[null,{"$f":"TODAY()-120","v":"2021-12-02"},{"$f":"DateSavingsBegin+180","v":"2022-05-31"},null,"MESEČNO"]
[null,"STROŠKI POTOVANJA:",{"v":6000,"d":"6,000 €"},null,"Tortni grafikon, ki primerja skupne trenutne prihranke z denarjem, ki ga je treba še prihraniti."]
[null,"PREDHODNI PRIHRANKI:",{"v":300,"d":"300 €"}]
[null,"TRENUTNO \nCILJ VARČEVANJA:",{"$f":"IFERROR(EventCost-AmountSaved, \"\")","v":{"v":5700,"d":"5,700 €"}}]
[null,{"$f":"IFERROR(IF(SavingsPlanInfo>0,\"Če prihranim \"&TEXT(SavingsPlanInfo,\"#.##0 € \")&PROPER(SavingFrequency)&\", od \"&TEXT(TODAY(),\"mm.dd.yy\"&\":\"),\"Datum dogodka je preblizu za \"&PROPER(SavingFrequency)&\" Načrt varčevanja\"), \"\")","v":"Če prihranim 1.140 € Mesečno, od 04.01.22:"}]
[null,"Prihranil/-a sem:",{"$f":" IFERROR(IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*DailySavings,0)+AmountSaved,AmountSaved), \"\")","v":{"v":4100,"d":"4,100 €"}}]
[null,"Moram prihraniti še:",{"$f":"IFERROR(MAX(0,EventCost-SavingsToDate), \"\")","v":{"v":1900,"d":"1,900 €"}}]
[]
[null,"PODROBNOSTI VARČEVALNEGA NAČRTA"]
[null,"Interval varčevanja","Dnevno","Tedensko","Dvakrat tedensko","Mesečno","Letno"]
[null,"Znesek za prihranek:",{"$f":"IFERROR(MIN(Cilj,IF(DaysUntilEvent=\"\",0,Cilj/DaysUntilEvent)), \"\")","v":{"v":31.666666666666668,"d":"32 €"}},{"$f":"IFERROR(MIN(Cilj,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,Cilj/WeeksUntilEvent))), \"\")","v":{"v":221.66666666666666,"d":"222 €"}},{"$f":"IFERROR(IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(Cilj,IF(D13=\"\",0,Cilj/BiWeeksUntilEvent))), \"\")","v":{"v":475,"d":"475 €"}},{"$f":"IFERROR(MIN(Cilj,IF(Cilj=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,Cilj/MonthsUntilEvent))), \"\")","v":{"v":1140,"d":"1,140 €"}},{"$f":"IFERROR(IF(OR(Cilj=\"\",Cilj=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,Cilj/YearsUntilEvent)), \"\")","v":{"v":0,"d":"0 €"}}]
[null,"Časovni interval","Dnevi","Tedni","Dva tedna","Meseci","Leta"]
[null,"Čas do dosege cilja:",{"$f":"IFERROR(IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"D\"),\"\"), \"\")","v":180},{"$f":"IFERROR(IF(DaysUntilEvent<>\"\",DaysUntilEvent/7,\"\"), \"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IFERROR(IF(OR(WeeksUntilEvent=0,WeeksUntilEvent=\"\"),0,ROUNDDOWN(WeeksUntilEvent/2,0)), \"\")","v":12},{"$f":"IFERROR(IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"M\"),\"\"), \"\")","v":5},{"$f":"IFERROR(IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"Y\"),\"\"), \"\")","v":0}]