{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["キャッシュ フロー","月間収入","月間支出","グラフ データ"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"キャッシュ フロー","index":0,"n_rows":11,"n_cols":5,"rows_kept":11}
[]
[null,"Torres 家 | 2023 年 2 月"]
[null,"家計予算"]
[]
[null,"キャッシュ フロー分析​​"]
[]
[]
[null,"家計予算","予測","実際","差異"]
[null,"収入合計",{"$f":"収入[[#Totals],[予測]]","v":{"v":5700,"d":"¥5,700.00"}},{"$f":"収入[[#Totals],[実際]]","v":{"v":6000,"d":"¥6,000.00"}},{"$f":"キャッシュフロー[[#This Row],[実際]]-キャッシュフロー[[#This Row],[予測]]","v":{"v":300,"d":"¥300"}}]
[null,"支出合計",{"$f":"支出[[#Totals],[予測]]","v":{"v":3603,"d":"¥3,603.00"}},{"$f":"支出[[#Totals],[実際]]","v":{"v":3655,"d":"¥3,655.00"}},{"$f":"キャッシュフロー[[#This Row],[予測]]-キャッシュフロー[[#This Row],[実際]]","v":{"v":-52,"d":"(¥52)"}}]
[null,"現金合計",{"$f":"C9-C10","v":{"v":2097,"d":"¥2,097.00"}},{"$f":"D9-D10","v":{"v":2345,"d":"¥2,345.00"}},{"$f":"SUBTOTAL(109,キャッシュフロー[差異])","v":{"v":248,"d":"¥248"}}]

{"sheet":"月間収入","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[2,1,2,3]]}
[{"$nulls":5}," "]
[null,"Torres 家 | 2023 年 2 月"]
[null,"月間収入"]
[]
[null,"月間収入","予測","実際","差異"]
[null,"収入 1",{"v":4000,"d":"¥4,000.00"},{"v":4000,"d":"¥4,000.00"},{"$f":"収入[[#This Row],[実際]]-収入[[#This Row],[予測]]","v":{"v":0,"d":"¥0.00"}}]
[null,"収入 2",{"v":1400,"d":"¥1,400.00"},{"v":1500,"d":"¥1,500.00"},{"$f":"収入[[#This Row],[実際]]-収入[[#This Row],[予測]]","v":{"v":100,"d":"¥100.00"}}]
[null,"その他の収入",{"v":300,"d":"¥300.00"},{"v":500,"d":"¥500.00"},{"$f":"収入[[#This Row],[実際]]-収入[[#This Row],[予測]]","v":{"v":200,"d":"¥200.00"}}]
[null,"収入合計",{"$f":"SUBTOTAL(109,収入[予測])","v":{"v":5700,"d":"¥5,700.00"}},{"$f":"SUBTOTAL(109,収入[実際])","v":{"v":6000,"d":"¥6,000.00"}},{"$f":"SUBTOTAL(109,収入[差異])","v":{"v":300,"d":"¥300.00"}}]

{"sheet":"月間支出","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[1,1,1,3],[2,1,2,3]]}
[{"$nulls":5}," "]
[null,"Torres 家 | 2023 年 2 月"]
[null,"月間支出"]
[]
[null,"月間支出","予測","実際","差異"]
[null,"住居費",{"v":1500,"d":"¥1,500.00"},{"v":1500,"d":"¥1,500.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"食料品",{"v":250,"d":"¥250.00"},{"v":280,"d":"¥280.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":-30,"d":"(¥30.00)"}}]
[null,"電話料金",{"v":38,"d":"¥38.00"},{"v":38,"d":"¥38.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"電気/ガス",{"v":65,"d":"¥65.00"},{"v":78,"d":"¥78.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":-13,"d":"(¥13.00)"}}]
[null,"上下水道/ごみ",{"v":25,"d":"¥25.00"},{"v":21,"d":"¥21.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":4,"d":"¥4.00"}}]
[null,"ケーブル TV",{"v":75,"d":"¥75.00"},{"v":83,"d":"¥83.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":-8,"d":"(¥8.00)"}}]
[null,"インターネット",{"v":60,"d":"¥60.00"},{"v":60,"d":"¥60.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"保守/修理",{"v":0,"d":"¥0.00"},{"v":60,"d":"¥60.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":-60,"d":"(¥60.00)"}}]
[null,"保育",{"v":180,"d":"¥180.00"},{"v":150,"d":"¥150.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":30,"d":"¥30.00"}}]
[null,"授業料",{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"ペット費用",{"v":75,"d":"¥75.00"},{"v":80,"d":"¥80.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":-5,"d":"(¥5.00)"}}]
[null,"交通費",{"v":280,"d":"¥280.00"},{"v":260,"d":"¥260.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":20,"d":"¥20.00"}}]
[null,"日常生活関連費",{"v":75,"d":"¥75.00"},{"v":65,"d":"¥65.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":10,"d":"¥10.00"}}]
[null,"保険",{"v":255,"d":"¥255.00"},{"v":255,"d":"¥255.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"クレジット カード",{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"ローン",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"税金",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"贈答/寄付",{"v":150,"d":"¥150.00"},{"v":150,"d":"¥150.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"貯蓄",{"v":225,"d":"¥225.00"},{"v":225,"d":"¥225.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"その他",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"支出[[#This Row],[予測]]-支出[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,"集計",{"$f":"SUBTOTAL(109,支出[予測])","v":{"v":3603,"d":"¥3,603.00"}},{"$f":"SUBTOTAL(109,支出[実際])","v":{"v":3655,"d":"¥3,655.00"}},{"$f":"SUBTOTAL(109,支出[差異])","v":{"v":-52,"d":"(52.00)"}}]

{"sheet":"グラフ データ","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"グラフ データ"]
[]
[null,null,"予測","実際"]
[null,"月間収入",{"$f":"収入[[#Totals],[予測]]","v":5700},{"$f":"収入[[#Totals],[実際]]","v":6000}]
[null,"月間支出",{"$f":"支出[[#Totals],[予測]]","v":3603},{"$f":"支出[[#Totals],[実際]]","v":3655}]
[null,"キャッシュ フロー",{"$f":"キャッシュフロー[[#Totals],[予測]]","v":2097},{"$f":"キャッシュフロー[[#Totals],[実際]]","v":2345}]