{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["サマリー","1 か月の収入","1 か月の支出","1 か月の貯蓄","グラフ データ"],"not_rendered":{"charts":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"サマリー","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[2,1,9,1],[2,3,10,7]]}
[null,"個人予算表"]
[null,"収入に占める支出の割合","サマリー"]
[null,{"$f":"収入に占める支出の割合","v":{"v":0.6229333333333333,"d":"62%"}},"1 か月の収入合計","このセルの縦棒グラフは、1 か月の合計収入と 1 か月の合計支出を示しています。"]
[null,null,{"$f":"SUM(か月の収入[[#All],[金額]])","v":{"v":3750,"d":"¥3,750"}}]
[null,null,"1 か月の支出合計"]
[null,null,{"$f":"SUM(か月の支出[[#All],[金額]])","v":{"v":2336,"d":"¥2,336"}}]
[null,null,"1 か月の貯蓄合計"]
[null,null,{"$f":"SUM(貯蓄[[#All],[金額]])","v":{"v":550,"d":"¥550"}}]
[null,null,"現金残高"]
[null,null,{"$f":"か月の収入合計-か月の支出合計-か月の貯蓄合計","v":{"v":864,"d":"¥864"}}]

{"sheet":"1 か月の収入","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"BudgetTitle","v":"個人予算表"}]
[null,"1 か月の収入"]
[null,"項目","金額"]
[null,"収入源 1",{"v":2500,"d":"¥2,500.00"}]
[null,"収入源 2",{"v":1000,"d":"¥1,000.00"}]
[null,"その他",{"v":250,"d":"¥250.00"}]

{"sheet":"1 か月の支出","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,{"$f":"BudgetTitle","v":"個人予算表"}]
[null,"1 か月の支出"]
[null,"項目","支払い期日","金額"]
[null,"家賃/住宅ローン","日付",{"v":800,"d":"¥800.00"}]
[null,"電気","日付",{"v":120,"d":"¥120.00"}]
[null,"ガス","日付",{"v":50,"d":"¥50.00"}]
[null,"携帯電話","日付",{"v":45,"d":"¥45.00"}]
[null,"食料品","日付",{"v":500,"d":"¥500.00"}]
[null,"自動車ローン","日付",{"v":273,"d":"¥273.00"}]
[null,"自動車関連費用","日付",{"v":120,"d":"¥120.00"}]
[null,"学生ローン","日付",{"v":50,"d":"¥50.00"}]
[null,"クレジット カード支払い","日付",{"v":100,"d":"¥100.00"}]
[null,"自動車保険","日付",{"v":78,"d":"¥78.00"}]
[null,"日常生活関連費","日付",{"v":50,"d":"¥50.00"}]
[null,"娯楽","日付",{"v":100,"d":"¥100.00"}]
[null,"雑費","日付",{"v":50,"d":"¥50.00"}]

{"sheet":"1 か月の貯蓄","index":3,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"BudgetTitle","v":"個人予算表"}]
[null,"1 か月の貯蓄"]
[null,"日付","金額"]
[null,"日付",{"v":200,"d":"¥200.00"}]
[null,"日付",{"v":250,"d":"¥250.00"}]
[null,"日付",{"v":100,"d":"¥100.00"}]

{"sheet":"グラフ データ","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[]
[null,"グラフ データ"]
[]
[null,{"$f":"MIN(1,1-B5)","v":{"v":0.37706666666666666,"d":"38%"}}]
[null,{"$f":"MIN(か月の支出合計/か月の収入合計,1)","v":{"v":0.6229333333333333,"d":"62%"}}]
[null,{"$f":"(か月の支出合計/か月の収入合計)>1","v":false}]