{"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":"貯蓄開始日+180","v":"2013-03-16"},null,null,"隔週"]
[]
[]
[]
[null,"旅費:",{"v":600000,"d":"¥600,000"}]
[null,"これまでの貯蓄:",{"v":30000,"d":"¥30,000"}]
[]
[]
[null,"現在の貯蓄目標:",{"$f":"イベントの費用-貯蓄金額","v":{"v":570000,"d":"¥570,000"}}]
[]
[]
[{"$f":"IF(貯蓄プラン情報>0,TEXT(TODAY(),\"yy年mm月dd日\")&\"  から 1 週間おきに \"&TEXT(貯蓄プラン情報,\"¥#,##0 \"))&\"円貯蓄した場合: \"","v":"13年01月15日  から 1 週間おきに ¥47,500 円貯蓄した場合: "}]
[null,"貯蓄済み:",{"$f":" IF(貯蓄プラン情報>0,IF(TODAY()>貯蓄開始日,(TODAY()-貯蓄開始日)*日の貯蓄,0)+貯蓄金額,貯蓄金額)","v":{"v":410000,"d":"¥410,000"}}]
[null,"今後の必要貯蓄額:",{"$f":"MAX(0,イベントの費用-SavingsToDate)","v":{"v":190000,"d":"¥190,000"}}]
[]
[]
[]
["貯蓄プランの詳細"]
[null,"貯蓄間隔","毎日","毎週","隔週","月単位","年単位"]
[null,"貯蓄する金額:",{"$f":"MIN(目標,IF(イベントまでの日数=\"\",0,目標/イベントまでの日数))","v":{"v":3166.6666666666665,"d":"¥3,167"}},{"$f":"MIN(目標,IF(イベントまでの週数=\"\",0,IF(ROUNDUP(イベントまでの週数,0)=0,0,目標/イベントまでの週数)))","v":{"v":22166.666666666664,"d":"¥22,167"}},{"$f":"IF(OR(イベントまでの隔週数=0,イベントまでの隔週数=\"\"),0,MIN(目標,IF(D25=\"\",0,目標/イベントまでの隔週数)))","v":{"v":47500,"d":"¥47,500"}},{"$f":"MIN(目標,IF(目標=\"\",0,IF(OR(イベントまでの月数=0,イベントまでの月数=\"\"),0,目標/イベントまでの月数)))","v":{"v":114000,"d":"¥114,000"}},{"$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}]