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

{"sheet":"月間収入","index":0,"n_rows":16,"n_cols":3,"rows_kept":16}
[null,"予算"]
[null,"収入に占める支出の割合","概要"]
[null,"収入に占める支出の割合の円グラフ。割合のパーセンテージは下のセルに表示されます","月収合計"]
[null,null,{"$f":"SUM(収入[金額])","v":{"v":3750,"d":"¥3,750"}}]
[null,null,"1 か月の支出合計"]
[null,null,{"$f":"SUM(支出[[#All],[金額]])","v":{"v":2058,"d":"¥2,058"}}]
[null,null,"1 か月の貯蓄合計"]
[null,null,{"$f":"SUM(貯蓄[[#All],[金額]])","v":{"v":550,"d":"¥550"}}]
[null,null,"現金残高"]
[null,null,{"$f":"月収合計-か月の支出合計-か月の貯蓄合計","v":{"v":1142,"d":"¥1,142"}}]
[null,{"$f":"MIN(か月の支出合計/月収合計,1)","v":{"v":0.5488,"d":"55%"}}]
[null,"月間収入"]
[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":1,"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":2,"n_rows":12,"n_cols":3,"rows_kept":12}
[null,{"$f":"BudgetTitle","v":"予算"}]
[null,"月間支出"]
[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"}]

{"sheet":"グラフ データ","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[null,"グラフ データ"]
[null,{"$f":"MIN(1-B3,1)","v":{"v":0.45120000000000005,"d":"45%"}}]
[null,{"$f":"MIN(か月の支出合計/月収合計,1)","v":{"v":0.5488,"d":"55%"}}]
[null,{"$f":"(か月の支出合計/月収合計)>1","v":false}]