{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["儲蓄估算表"],"not_rendered":{"charts":1,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"儲蓄估算表","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]]}
["寒假\n墨西哥之旅"]
[]
[]
[]
[null," 開始儲蓄日期："," 完成儲蓄日期：",{"$nulls":3}," 存錢時間間隔："]
[null,{"$f":"TODAY()-120","v":"2012-09-17"},{"$f":"DateSavingsBegin+180","v":"2013-03-16"},null,null,"每兩週"]
[]
[]
[]
[null,"旅遊費用：",{"v":180000,"d":"NT$180,000"}]
[null,"先前儲蓄：",{"v":9000,"d":"NT$9,000"}]
[]
[]
[null,"目前\n儲蓄目標：",{"$f":"EventCost-AmountSaved","v":{"v":171000,"d":"NT$171,000"}}]
[]
[]
[{"$f":"IF(SavingsPlanInfo>0,\"  如果儲蓄計劃為\"&PROPER(SavingFrequency)&\" NT\"&TEXT(SavingsPlanInfo,\"$#,##0 \")&\", 截至 \"&TEXT(TODAY(),\"yy.mm.dd\"&\":\"),\"  事件日期對於 \"&PROPER(SavingFrequency)&\" 儲蓄計劃而言太近\")","v":"  如果儲蓄計劃為每兩週 NT$14,250 , 截至 13.01.15:"}]
[null,"已存金額：",{"$f":" IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*DailySavings,0)+AmountSaved,AmountSaved)","v":{"v":123000,"d":"NT$123,000"}}]
[null,"待存金額：",{"$f":"MAX(0,EventCost-SavingsToDate)","v":{"v":57000,"d":"NT$57,000"}}]
[]
[]
[]
["儲蓄計劃詳細資料"]
[null,"儲蓄時間間隔","每日","每週","每兩週","每月","每年"]
[null,"需存金額：",{"$f":"MIN(Goal,IF(DaysUntilEvent=\"\",0,Goal/DaysUntilEvent))","v":{"v":950,"d":"NT$950"}},{"$f":"MIN(Goal,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,Goal/WeeksUntilEvent)))","v":{"v":6650,"d":"NT$6,650"}},{"$f":"IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(Goal,IF(D25=\"\",0,Goal/BiWeeksUntilEvent)))","v":{"v":14250,"d":"NT$14,250"}},{"$f":"MIN(Goal,IF(Goal=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,Goal/MonthsUntilEvent)))","v":{"v":34200,"d":"NT$34,200"}},{"$f":"IF(OR(Goal=\"\",Goal=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,Goal/YearsUntilEvent))","v":{"v":0,"d":"NT$0"}}]
[]
[null,"時間間隔","天","週","兩週","月","年"]
[null,"距離達成目標的時間：",{"$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}]