{"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-08"},{"$f":"_xlfn.SINGLE(存款开始日期)+180","v":"2022-06-06"},null,"每月"]
[null,"出行费用：",{"v":6000,"d":"¥6,000"},null,"比较当前存款总金额和未存款金额的饼图位于此单元格中。"]
[null,"之前存款：",{"v":300,"d":"¥300"}]
[null,"当前\n存款目标：",{"$f":"IFERROR(_xlfn.SINGLE(活动成本)-已存款金额, \"\")","v":{"v":5700,"d":"¥5,700"}}]
[null,{"$f":"IFERROR(IF(_xlfn.SINGLE(存款计划信息)>0,\"如果我存款 \"&TEXT(_xlfn.SINGLE(存款计划信息),\"¥#,##0 \")&PROPER(_xlfn.SINGLE(存款频次))&\", 截至 \"&TEXT(TODAY(),\"yy/mm/dd\"&\":\"),\"活动日期过于接近\"&PROPER(_xlfn.SINGLE(存款频次))&\"存款计划\"), \"\")","v":"如果我存款 ¥1,140 每月, 截至 22/04/07:"}]
[null,"我已存款：",{"$f":" IFERROR(_xlfn.SINGLE(IF(_xlfn.SINGLE(存款计划信息)>0,IF(TODAY()>_xlfn.SINGLE(存款开始日期),(TODAY()-_xlfn.SINGLE(存款开始日期))*_xlfn.SINGLE(每日存款),0)+_xlfn.SINGLE(已存款金额),已存款金额)), \"\")","v":{"v":4100,"d":"¥4,100"}}]
[null,"我仍需存款：",{"$f":"IFERROR(MAX(0,_xlfn.SINGLE(活动成本)-_xlfn.SINGLE(存款到期日)), \"\")","v":{"v":1900,"d":"¥1,900"}}]
[]
[null,"存款计划详细信息"]
[null,"存款时间间隔","每天","每周","每两周一次","每月","每年"]
[null,"要存款的金额：",{"$f":"IFERROR(MIN(目标,IF(_xlfn.SINGLE(几天前活动)=\"\",0,_xlfn.SINGLE(目标)/_xlfn.SINGLE(几天前活动))), \"\")","v":{"v":31.666666666666668,"d":"¥32"}},{"$f":"IFERROR(MIN(目标,IF(_xlfn.SINGLE(几周前活动)=\"\",0,IF(ROUNDUP(_xlfn.SINGLE(几周前活动),0)=0,0,_xlfn.SINGLE(目标)/_xlfn.SINGLE(几周前活动)))), \"\")","v":{"v":221.66666666666666,"d":"¥222"}},{"$f":"IFERROR(IF(OR(_xlfn.SINGLE(两周前活动)=0,_xlfn.SINGLE(两周前活动)=\"\"),0,MIN(目标,IF(D13=\"\",0,_xlfn.SINGLE(目标)/_xlfn.SINGLE(两周前活动)))), \"\")","v":{"v":475,"d":"¥475"}},{"$f":"IFERROR(MIN(目标,IF(_xlfn.SINGLE(目标)=\"\",0,IF(OR(_xlfn.SINGLE(几个月前活动)=0,_xlfn.SINGLE(几个月前活动)=\"\"),0,_xlfn.SINGLE(目标)/_xlfn.SINGLE(几个月前活动)))), \"\")","v":{"v":1140,"d":"¥1,140"}},{"$f":"IFERROR(IF(OR(_xlfn.SINGLE(目标)=\"\",_xlfn.SINGLE(目标)=0),0,IF(OR(_xlfn.SINGLE(几年前活动)=0,_xlfn.SINGLE(几年前活动)=\"\"),0,_xlfn.SINGLE(目标)/_xlfn.SINGLE(几年前活动))), \"\")","v":{"v":0,"d":"¥0"}}]
[null,"时间间隔","天数","周数","两周","月","工作"]
[null,"达到目标之前的时间：",{"$f":"IFERROR(IF(_xlfn.SINGLE(存款开始日期)<>\"\",DATEDIF(_xlfn.SINGLE(存款开始日期),_xlfn.SINGLE(活动日期),\"D\"),\"\"), \"\")","v":180},{"$f":"IFERROR(IF(_xlfn.SINGLE(几天前活动)<>\"\",_xlfn.SINGLE(几天前活动)/7,\"\"), \"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IFERROR(IF(OR(_xlfn.SINGLE(几周前活动)=0,_xlfn.SINGLE(几周前活动)=\"\"),0,ROUNDDOWN(_xlfn.SINGLE(几周前活动)/2,0)), \"\")","v":12},{"$f":"IFERROR(IF(_xlfn.SINGLE(存款开始日期)<>\"\",DATEDIF(_xlfn.SINGLE(存款开始日期),_xlfn.SINGLE(活动日期),\"M\"),\"\"), \"\")","v":5},{"$f":"IFERROR(IF(_xlfn.SINGLE(存款开始日期)<>\"\",DATEDIF(_xlfn.SINGLE(存款开始日期),_xlfn.SINGLE(活动日期),\"Y\"),\"\"), \"\")","v":0}]