{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["シート1","予算の概要","予算概要","月間支出","追加データ"],"not_rendered":{"charts":1,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"シート1","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"hidden":true}
["計算フィールド"]
["解決順序","フィールド","数式"]
[]
["集計項目"]
["解決順序","項目","数式"]
[]
[]
["メモ​​:","複数の数式でセルが更新されると、"]
[null,"値は最後の解決順序による数式で設定されます。"]
[]
[null,"複数の集計項目または集計フィールドの解決順序を変更するには、"]
[null,"[オプション] タブの [計算] グループでフィールド、項目、セットを選択してから、[計算順序] を選択します。"]

{"sheet":"予算の概要","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
[null,"予算の概要",{"$nulls":5}," "]
[null,"残高"]
[]
[null,"見積残高",null,{"$f":"Projected_Income-Projected_Expenses","v":{"v":1585,"d":"¥1,585"}},null,"見積から支出を差し引いたもの"]
[null,"実残高 ",null,{"$f":"Actual_Income-Actual_Expenses","v":{"v":1740,"d":"¥1,740"}},null,"実績から支出を差し引いたもの"]
[null,"差額",null,{"$f":"D5-D4","v":{"v":155,"d":"¥155"}},null,"実績から見積を差し引いたもの"]
[]
[null,"収入",{"$nulls":3},"支出"]
[]
[null,null,"予測","実績",null,"予測","実績"]
[null,"収入 1",{"v":6000,"d":"¥6,000"},{"v":5800,"d":"¥5,800"},null,{"$f":"SUM(Monthly_Expenses_Table[予算])","v":{"v":7915,"d":"¥7,915"}},{"$f":"SUM(Monthly_Expenses_Table[実費])","v":{"v":7860,"d":"¥7,860"}}]
[null,"収入 2",{"v":1000,"d":"¥1,000"},{"v":2300,"d":"¥2,300"}]
[null,"臨時収入",{"v":2500,"d":"¥2,500"},{"v":1500,"d":"¥1,500"}]
[null,"収入合計",{"$f":"SUM(C11:C13)","v":{"v":9500,"d":"¥9,500"}},{"$f":"SUM(D11:D13)","v":{"v":9600,"d":"¥9,600"}}]
[]
[null,"実際の支出の内訳"]

{"sheet":"予算概要","index":2,"n_rows":45,"n_cols":7,"rows_kept":45,"merged":[[0,1,0,4]]}
[null,"予算概要",{"$nulls":4}," "]
[]
[null,"カテゴリ","予算 ","実費 ","差額  "]
[null,"子供",{"v":140,"d":"¥140"},{"v":140,"d":"¥140"},{"v":0,"d":"¥0"}]
[null,"医療",null,null,{"v":0,"d":"¥0"}]
[null,"課外活動",{"v":40,"d":"¥40"},{"v":40,"d":"¥40"},{"v":0,"d":"¥0"}]
[null,"学校用品",null,null,{"v":0,"d":"¥0"}]
[null,"授業料",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"v":0,"d":"¥0"}]
[]
[null,"娯楽",{"v":400,"d":"¥400"},{"v":358,"d":"¥358"},{"v":42,"d":"¥42"}]
[null,"コンサート",{"v":50,"d":"¥50"},{"v":40,"d":"¥40"},{"v":10,"d":"¥10"}]
[null,"スポーツ イベント",{"v":0,"d":"¥0"},{"v":40,"d":"¥40"},{"v":-40,"d":"(¥40)"}]
[null,"ビデオ/DVD (レンタル)",{"v":30,"d":"¥30"},{"v":20,"d":"¥20"},{"v":10,"d":"¥10"}]
[null,"ビデオ/DVD (購入)",{"v":20,"d":"¥20"},{"v":50,"d":"¥50"},{"v":-30,"d":"(¥30)"}]
[null,"映画",{"v":50,"d":"¥50"},{"v":28,"d":"¥28"},{"v":22,"d":"¥22"}]
[null,"音楽 (CD、ダウンロードなど)",{"v":50,"d":"¥50"},{"v":30,"d":"¥30"},{"v":20,"d":"¥20"}]
[null,"観劇",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"v":50,"d":"¥50"}]
[]
[null,"食べ物",{"v":1100,"d":"¥1,100"},{"v":1320,"d":"¥1,320"},{"v":-220,"d":"(¥220)"}]
[]
[null,"ギフトと寄付",{"v":100,"d":"¥100"},{"v":125,"d":"¥125"},{"v":-25,"d":"(¥25)"}]
[null,"ギフト 1",null,null,{"v":0,"d":"¥0"}]
[null,"ギフト 2",null,null,{"v":0,"d":"¥0"}]
[null,"募金/寄付 1",{"v":75,"d":"¥75"},{"v":100,"d":"¥100"},{"v":-25,"d":"(¥25)"}]
[null,"募金/寄付 2",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"v":0,"d":"¥0"}]
[]
[null,"住居費",{"v":2830,"d":"¥2,830"},{"v":2702,"d":"¥2,702"},{"v":-72,"d":"(¥72)"}]
[]
[null,"保険",{"v":900,"d":"¥900"},{"v":900,"d":"¥900"},{"v":0,"d":"¥0"}]
[]
[null,"ローン",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[]
[null,"日常生活関連費",{"v":150,"d":"¥150"},{"v":140,"d":"¥140"},{"v":10,"d":"¥10"}]
[]
[null,"ペット費用",{"v":170,"d":"¥170"},{"v":100,"d":"¥100"},{"v":70,"d":"¥70"}]
[]
[null,"税金",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"v":0,"d":"¥0"}]
[]
[null,"交通費",{"v":1425,"d":"¥1,425"},{"v":1375,"d":"¥1,375"},{"v":50,"d":"¥50"}]
[]
[null,"貯蓄",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[null,"投資口座",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[null,"年金口座",null,null,{"v":0,"d":"¥0"}]
[]
[null,"Grand Total",{"v":7915,"d":"¥7,915"},{"v":7860,"d":"¥7,860"},{"v":-145,"d":"(¥145)"}]

{"sheet":"月間支出","index":3,"n_rows":61,"n_cols":8,"rows_kept":61}
[null,"月間支出",{"$nulls":5}," "]
[null,"説明","カテゴリ","予算","実費","差額","実費の概要"]
[null,"課外活動","子供",{"v":40,"d":"¥40"},{"v":40,"d":"¥40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":40}]
[null,"医療","子供",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"学校用品","子供",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"授業料","子供",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":100}]
[null,"コンサート","娯楽",{"v":50,"d":"¥50"},{"v":40,"d":"¥40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":10,"d":"¥10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":40}]
[null,"観劇","娯楽",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":50,"d":"¥50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":150}]
[null,"映画","娯楽",{"v":50,"d":"¥50"},{"v":28,"d":"¥28"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":22,"d":"¥22"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":28}]
[null,"音楽 (CD、ダウンロードなど)","娯楽",{"v":50,"d":"¥50"},{"v":30,"d":"¥30"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":20,"d":"¥20"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":30}]
[null,"スポーツ イベント","娯楽",{"v":0,"d":"¥0"},{"v":40,"d":"¥40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-40,"d":"(¥40)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":40}]
[null,"ビデオ/DVD (購入)","娯楽",{"v":20,"d":"¥20"},{"v":50,"d":"¥50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-30,"d":"(¥30)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":50}]
[null,"ビデオ/DVD (レンタル)","娯楽",{"v":30,"d":"¥30"},{"v":20,"d":"¥20"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":10,"d":"¥10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":20}]
[null,"外食","食べ物",{"v":1000,"d":"¥1,000"},{"v":1200,"d":"¥1,200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-200,"d":"(¥200)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":1200}]
[null,"食料品","食べ物",{"v":100,"d":"¥100"},{"v":120,"d":"¥120"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-20,"d":"(¥20)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":120}]
[null,"募金/寄付 1","ギフトと寄付",{"v":75,"d":"¥75"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-25,"d":"(¥25)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":100}]
[null,"募金/寄付 2","ギフトと寄付",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":25}]
[null,"ギフト 1","ギフトと寄付",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"ギフト 2","ギフトと寄付",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"ケーブル/BS/CS テレビ","住居費",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":100}]
[null,"電気","住居費",{"v":45,"d":"¥45"},{"v":50,"d":"¥50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-5,"d":"(¥5)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":50}]
[null,"ガス","住居費",{"v":300,"d":"¥300"},{"v":400,"d":"¥400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-100,"d":"(¥100)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":400}]
[null,"ハウス クリーニング サービス","住居費",{"v":200,"d":"¥200"},null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"修繕費","住居費",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":50,"d":"¥50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":150}]
[null,"住宅ローン/家賃","住居費",{"v":1700,"d":"¥1,700"},{"v":1700,"d":"¥1,700"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":1700}]
[null,"ガス/燃料","住居費",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"インターネット サービス","住居費",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":100}]
[null,"携帯電話","住居費",{"v":60,"d":"¥60"},{"v":60,"d":"¥60"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":60}]
[null,"自宅電話","住居費",{"v":35,"d":"¥35"},{"v":39,"d":"¥39"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-4,"d":"(¥4)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":39}]
[null,"消耗品","住居費",{"v":40,"d":"¥40"},{"v":55,"d":"¥55"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-15,"d":"(¥15)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":55}]
[null,"ゴミ回収とリサイクル","住居費",{"v":25,"d":"¥25"},{"v":22,"d":"¥22"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":3,"d":"¥3"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":22}]
[null,"水道代","住居費",{"v":25,"d":"¥25"},{"v":26,"d":"¥26"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-1,"d":"(¥1)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":26}]
[null,"健康","保険",{"v":400,"d":"¥400"},{"v":400,"d":"¥400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":400}]
[null,"住宅保険","保険",{"v":400,"d":"¥400"},{"v":400,"d":"¥400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":400}]
[null,"生命保険","保険",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":100}]
[null,"クレジット カード 1","ローン",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":200}]
[null,"クレジット カード 2","ローン",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"クレジット カード 3","ローン",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"個人","ローン",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"教育ローン","ローン",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"衣料品","日常生活関連費",{"v":150,"d":"¥150"},{"v":140,"d":"¥140"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":10,"d":"¥10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":140}]
[null,"ドライ クリーニング","日常生活関連費",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"整髪/爪","日常生活関連費",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"スポーツ クラブ","日常生活関連費",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"医療","日常生活関連費",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"食費","ペット費用",{"v":150,"d":"¥150"},{"v":75,"d":"¥75"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":75,"d":"¥75"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":75}]
[null,"グルーミング代","ペット費用",{"v":20,"d":"¥20"},{"v":25,"d":"¥25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-5,"d":"(¥5)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":25}]
[null,"獣医","ペット費用",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"おもちゃ","ペット費用",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"投資口座","貯蓄",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":200}]
[null,"年金口座","貯蓄",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"国税","税金",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":300}]
[null,"地方税","税金",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"都道府県","税金",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"バスまたはライドシェア","交通費",{"v":100,"d":"¥100"},{"v":150,"d":"¥150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":-50,"d":"(¥50)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":150}]
[null,"ガソリン代","交通費",{"v":450,"d":"¥450"},{"v":400,"d":"¥400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":50,"d":"¥50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":400}]
[null,"保険","交通費",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":300}]
[null,"自動車税 ","交通費",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":25}]
[null,"修繕費","交通費",{"v":100,"d":"¥100"},{"v":50,"d":"¥50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":50,"d":"¥50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":50}]
[null,"駐車場代","交通費",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":0}]
[null,"車両費","交通費",{"v":450,"d":"¥450"},{"v":450,"d":"¥450"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[予算]]=\"\",Monthly_Expenses_Table[[#This Row],[実費]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[予算]]-Monthly_Expenses_Table[[#This Row],[実費]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[実費]]","v":450}]

{"sheet":"追加データ","index":4,"n_rows":17,"n_cols":9,"rows_kept":17}
[null,"追加データ",{"$nulls":3}," "]
[null,"家計グラフ用のピボットテーブル",null,null,"カテゴリ リスト"]
[]
[null,"カテゴリ","実費 ",null,"カテゴリを追加するには、下に入力してください",{"$nulls":3},"`"]
[null,"ペット費用",{"v":100,"d":"¥100"},null,"子供"]
[null,"ギフトと寄付",{"v":125,"d":"¥125"},null,"娯楽"]
[null,"子供",{"v":140,"d":"¥140"},null,"食べ物"]
[null,"日常生活関連費",{"v":140,"d":"¥140"},null,"ギフトと寄付"]
[null,"ローン",{"v":200,"d":"¥200"},null,"住居費"]
[null,"貯蓄",{"v":200,"d":"¥200"},null,"保険"]
[null,"税金",{"v":300,"d":"¥300"},null,"ローン"]
[null,"娯楽",{"v":358,"d":"¥358"},null,"日常生活関連費"]
[null,"保険",{"v":900,"d":"¥900"},null,"ペット費用"]
[null,"食べ物",{"v":1320,"d":"¥1,320"},null,"貯蓄"]
[null,"交通費",{"v":1375,"d":"¥1,375"},null,"税金"]
[null,"住居費",{"v":2702,"d":"¥2,702"},null,"交通費"]
[null,"Grand Total",{"v":7860,"d":"¥7,860"}]