{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["储蓄估算器"],"not_rendered":{"charts":1,"defined_names":18},"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]]}
["寒假去墨西哥旅游"]
[]
[]
[]
[null," 开始储蓄日期:"," 结束储蓄日期:",{"$nulls":3}," 储蓄方式:"]
[null,{"$f":"TODAY()-120","v":"2012-08-16"},{"$f":"储蓄开始日期+180","v":"2013-02-12"},null,null,"两周一次"]
[]
[]
[]
[null,"旅行费用:",{"v":60000,"d":"¥60,000"}]
[null,"前期存款:",{"v":3000,"d":"¥3,000"}]
[]
[]
[null,"当前存款目标:",{"$f":"活动成本-已存金额","v":{"v":57000,"d":"¥57,000"}}]
[]
[]
[{"$f":"IF(储蓄计划信息>0,\"  如果我每两周存储 \"&TEXT(储蓄计划信息,\"¥#,### \")&\", 则截止到 \"&TEXT(TODAY(),\"yyyy 年 mm 月 dd 日\"&\":\"),\"  活动日期太接近 \"&PROPER(存储频率)&\" 储蓄计划\")","v":"  如果我每两周存储 ¥4,750 , 则截止到 2012 年 12 月 14 日:"}]
[null,"已储蓄:",{"$f":" IF(储蓄计划信息>0,IF(TODAY()>储蓄开始日期,(TODAY()-储蓄开始日期)*按日储蓄,0)+已存金额,已存金额)","v":{"v":41000,"d":"¥41,000"}}]
[null,"还需储蓄:",{"$f":"MAX(0,活动成本-SavingsToDate)","v":{"v":19000,"d":"¥19,000"}}]
[]
[]
[]
["储蓄计划明细"]
[null,"储蓄区间","每天一次","每周一次","两周一次","每月一次","每年"]
[null,"待存金额:",{"$f":"MIN(目标,IF(活动前天数=\"\",0,目标/活动前天数))","v":{"v":316.6666666666667,"d":"¥317"}},{"$f":"MIN(目标,IF(活动前周数=\"\",0,IF(ROUNDUP(活动前周数,0)=0,0,目标/活动前周数)))","v":{"v":2216.6666666666665,"d":"¥2,217"}},{"$f":"IF(OR(活动前双周数=0,活动前双周数=\"\"),0,MIN(目标,IF(D25=\"\",0,目标/活动前双周数)))","v":{"v":4750,"d":"¥4,750"}},{"$f":"MIN(目标,IF(目标=\"\",0,IF(OR(活动前月数=0,活动前月数=\"\"),0,目标/活动前月数)))","v":{"v":11400,"d":"¥11,400"}},{"$f":"IF(OR(目标=\"\",目标=0),0,IF(OR(活动前年数=0,活动前年数=\"\"),0,目标/活动前年数))","v":{"v":0,"d":"¥0"}}]
[]
[null,"时间区间","天","周","双周","月","年"]
[null,"距离目标完成的时间:",{"$f":"IF(储蓄开始日期<>\"\",DATEDIF(储蓄开始日期,活动日期,\"D\"),\"\")","v":180},{"$f":"IF(活动前天数<>\"\",活动前天数/7,\"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IF(OR(活动前周数=0,活动前周数=\"\"),0,ROUNDDOWN(活动前周数/2,0))","v":12},{"$f":"IF(储蓄开始日期<>\"\",DATEDIF(储蓄开始日期,活动日期,\"M\"),\"\")","v":5},{"$f":"IF(储蓄开始日期<>\"\",DATEDIF(储蓄开始日期,活动日期,\"Y\"),\"\")","v":0}]