{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["כלי להערכת חיסכון"],"not_rendered":{"charts":1,"defined_names":23},"read":"whole","date_system":"1900"}

{"sheet":"כלי להערכת חיסכון","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,"חופשת חורף\nטיול למקסיקו"]
[null," תחילת חיסכון:"," סיום חיסכון:",null," חסוך כסף:"]
[null,{"$f":"TODAY()-120","v":"2021-12-09"},{"$f":"DateSavingsBegin+180","v":"2022-06-07"},null,"חודשי"]
[null,"עלות הנסיעה:",{"v":6000,"d":"₪ 6,000"},null,"תרשים עוגה המשווה את סך החיסכון הנוכחי לכסף שעדיין לא נחסך בתא זה."]
[null,"חסכונות קודמים:",{"v":300,"d":"₪ 300"}]
[null,"נוכחי \nמטרת החיסכון:",{"$f":"IFERROR(EventCost-AmountSaved, \"\")","v":{"v":5700,"d":"₪ 5,700"}}]
[null,{"$f":"IFERROR(IF(SavingsPlanInfo>0,\"אם אני חוסך \"&TEXT(SavingsPlanInfo,\"#,##0 ₪ \")&PROPER(SavingFrequency)&\", נכון ל- \"&TEXT(TODAY(),\"dd.mm.yy\"&\":\"),\"תאריך האירוע קרוב מדי עבור \"&PROPER(SavingFrequency)&\" תוכנית חיסכון\"), \"\")","v":"אם אני חוסך 1,140 ₪ חודשי, נכון ל- 08.04.22:"}]
[null,"חסכתי:",{"$f":" IFERROR(IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*DailySavings,0)+AmountSaved,AmountSaved), \"\")","v":{"v":4100,"d":"₪ 4,100"}}]
[null,"אני עדיין צריך לחסוך:",{"$f":"IFERROR(MAX(0,EventCost-SavingsToDate), \"\")","v":{"v":1900,"d":"₪ 1,900"}}]
[]
[null,"פרטי תוכנית החיסכון"]
[null,"מרווח זמן לחיסכון","מדי יום","שבועי","דו-שבועי","חודשי","שנתי"]
[null,"סכום לחיסכון:",{"$f":"IFERROR(MIN(מטרה,IF(DaysUntilEvent=\"\",0,מטרה/DaysUntilEvent)), \"\")","v":{"v":31.666666666666668,"d":"₪ 32"}},{"$f":"IFERROR(MIN(מטרה,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,מטרה/WeeksUntilEvent))), \"\")","v":{"v":221.66666666666666,"d":"₪ 222"}},{"$f":"IFERROR(IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(מטרה,IF(D13=\"\",0,מטרה/BiWeeksUntilEvent))), \"\")","v":{"v":475,"d":"₪ 475"}},{"$f":"IFERROR(MIN(מטרה,IF(מטרה=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,מטרה/MonthsUntilEvent))), \"\")","v":{"v":1140,"d":"₪ 1,140"}},{"$f":"IFERROR(IF(OR(מטרה=\"\",מטרה=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,מטרה/YearsUntilEvent)), \"\")","v":{"v":0,"d":"₪ 0"}}]
[null,"מרווח זמן","ימים","שבועות","דו-שבועיים","חודשים","שנים"]
[null,"זמן עד להשגת המטרה:",{"$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}]