{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["儲蓄估算器"],"not_rendered":{"charts":1,"defined_names":24},"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":"NT$6,000"},null,"比較目前儲蓄總計與此儲存格中尚未儲存之金錢的圓形圖。"]
[null,"先前的儲蓄:",{"v":300,"d":"NT$300"}]
[null,"目前的\n儲蓄目標:",{"$f":"IFERROR(EventCost-AmountSaved, \"\")","v":{"v":5700,"d":"NT$5,700"}}]
[null,{"$f":"IFERROR(IF(SavingsPlanInfo>0,\"如果我儲蓄 NT\"&TEXT(SavingsPlanInfo,\"$#,##0 \")&PROPER(SavingFrequency)&\", 截至 \"&TEXT(TODAY(),\"yy/mm/dd\"&\":\"),\"事件日期太接近\"&PROPER(SavingFrequency)&\"儲蓄目標\"), \"\")","v":"如果我儲蓄 NT$1,140 每個月, 截至 22/04/06:"}]
[null,"已儲存:",{"$f":" IFERROR(IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*DailySavings,0)+AmountSaved,AmountSaved), \"\")","v":{"v":4100,"d":"NT$4,100"}}]
[null,"仍需要儲存:",{"$f":"IFERROR(MAX(0,EventCost-SavingsToDate), \"\")","v":{"v":1900,"d":"NT$1,900"}}]
[]
[null,"儲蓄方案詳細資料"]
[null,"儲蓄間隔","每天","每週","每兩週","每個月","每年"]
[null,"儲蓄金額:",{"$f":"IFERROR(MIN(目標,IF(DaysUntilEvent=\"\",0,目標/DaysUntilEvent)), \"\")","v":{"v":31.666666666666668,"d":"NT$32"}},{"$f":"IFERROR(MIN(目標,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,目標/WeeksUntilEvent))), \"\")","v":{"v":221.66666666666666,"d":"NT$222"}},{"$f":"IFERROR(IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(目標,IF(D13=\"\",0,目標/BiWeeksUntilEvent))), \"\")","v":{"v":475,"d":"NT$475"}},{"$f":"IFERROR(MIN(目標,IF(目標=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,目標/MonthsUntilEvent))), \"\")","v":{"v":1140,"d":"NT$1,140"}},{"$f":"IFERROR(IF(OR(目標=\"\",目標=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,目標/YearsUntilEvent)), \"\")","v":{"v":0,"d":"NT$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}]