{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["貯蓄見積もりツール"],"not_rendered":{"charts":1,"external_links":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-07"},{"$f":"DateSavingsBegin+180","v":"2022-06-05"},null,"毎月"]
[null,"旅費:",{"v":6000,"d":"¥6,000"},null,"このセルには、現在の貯蓄総額とまだ貯蓄していない金額を比較した円グラフが示されます。"]
[null,"事前貯蓄:",{"v":300,"d":"¥300"}]
[null,"現在貯蓄目標:",{"$f":"IFERROR(EventCost-AmountSaved, \"\")","v":{"v":5700,"d":"¥5,700"}}]
[null,{"$f":"IFERROR(IF(SavingsPlanInfo>0,\"保存した場合\"&TEXT(SavingsPlanInfo,\"¥#,##0;¥-#,##0 \")&PROPER(SavingFrequency)&\",日付\"&TEXT(TODAY(),\"mm.dd.yy\"&\":\"),\"イベントの日付が次の日付と近すぎます\"&PROPER(SavingFrequency)&\"貯蓄計画\"), \"\")","v":"保存した場合¥1,140毎月,日付04.06.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,_xlfn.SINGLE(目標)/DaysUntilEvent)), \"\")","v":{"v":31.666666666666668,"d":"¥32"}},{"$f":"IFERROR(MIN(目標,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,_xlfn.SINGLE(目標)/WeeksUntilEvent))), \"\")","v":{"v":221.66666666666666,"d":"¥222"}},{"$f":"IFERROR(IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(目標,IF(D13=\"\",0,_xlfn.SINGLE(目標)/BiWeeksUntilEvent))), \"\")","v":{"v":475,"d":"¥475"}},{"$f":"IFERROR(MIN(目標,IF(_xlfn.SINGLE(目標)=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,_xlfn.SINGLE(目標)/MonthsUntilEvent))), \"\")","v":{"v":1140,"d":"¥1,140"}},{"$f":"IFERROR(IF(OR(_xlfn.SINGLE(目標)=\"\",_xlfn.SINGLE(目標)=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,_xlfn.SINGLE(目標)/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}]