{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["月間個人予算"],"read":"whole","date_system":"1900"}

{"sheet":"月間個人予算","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"merged":[[0,1,0,9],[2,1,4,1],[2,2,2,3],[2,7,2,8],[3,2,3,3],[3,7,3,8],[4,2,4,3],[4,6,4,8],[5,1,7,1],[5,2,5,3],[5,7,5,8],[6,2,6,3],[6,7,6,8],[7,2,7,3],[7,6,7,8],[20,6,20,9],[21,1,21,4],[29,6,29,9],[31,1,31,4],[36,6,36,9],[38,1,38,4],[42,6,42,9],[44,1,44,4],[48,6,48,9],[52,1,52,4],[55,6,55,9]]}
[null,"月間個人予算"]
[]
[null,"見積月収","収入 1",null,{"v":2500,"d":"¥2,500"},null,"予算合計 ","(見積収入から経費を減算)",null,{"$f":"SUM(C21,C31,C38,C44,C52,C62,H20,H29,H36,H42,H48,H55)","v":{"v":2060,"d":"¥2,060"}}]
[null,null,"臨時収入",null,{"v":500,"d":"¥500"},null,"実費合計 ","(実収入から経費を減算)",null,{"$f":"SUM(D21,D31,D38,D44,D52,D62,I20,I29,I36,I42,I48,I55)","v":{"v":2040,"d":"¥2,040"}}]
[null,null,"月収合計",null,{"$f":"SUM(E3:E4)","v":{"v":3000,"d":"¥3,000"}},null,"支出差の合計",null,null,{"$f":"SUM(E21,E31,E38,E44,E52,E62,J20,J29,J36,J42,J48,J55)","v":{"v":20,"d":"¥20"}}]
[null,"実月収","収入 1",null,{"v":2500,"d":"¥2,500"},null,"見積残高","(見積収入から経費を減算)",null,{"$f":"E5-J3","v":{"v":940,"d":"¥940"}}]
[null,null,"臨時収入",null,{"v":500,"d":"¥500"},null,"実残高","(実収入から経費を減算)",null,{"$f":"E8-J4","v":{"v":960,"d":"¥960"}}]
[null,null,"月収合計",null,{"$f":"SUM(E6:E7)","v":{"v":3000,"d":"¥3,000"}},null,"残高差額 (実費から予算を減算)",null,null,{"$f":"J7-J6","v":{"v":20,"d":"¥20"}}]
[]
[null,"住居費","予算","実費","差額",null,"娯楽","予算","実費","差額"]
[null,"住宅ローン/家賃",{"v":1500,"d":"¥1,500"},{"v":1400,"d":"¥1,400"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":100,"d":"¥100"}},null,"ビデオ/DVD",{"v":0,"d":"¥0"},{"v":50,"d":"¥50"},{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":-50,"d":"¥-50"}}]
[null,"電話番号",{"v":60,"d":"¥60"},{"v":100,"d":"¥100"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":-40,"d":"¥-40"}},null,"CD",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"電気",{"v":50,"d":"¥50"},{"v":60,"d":"¥60"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":-10,"d":"¥-10"}},null,"映画",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"ガス",{"v":200,"d":"¥200"},{"v":180,"d":"¥180"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":20,"d":"¥20"}},null,"コンサート",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"水道代",null,null,{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"スポーツ イベント",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"受信料",null,null,{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"観劇",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"廃棄物除去",null,null,{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"その他",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"保守/修繕費",null,null,{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"その他",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"備品",null,null,{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"その他",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"その他",null,null,{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"集計",{"$f":"SUBTOTAL(109,娯楽[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,娯楽[実費])","v":{"v":50,"d":"¥50"}},{"$f":"SUBTOTAL(109,娯楽[差額])","v":{"v":-50,"d":"¥-50"}}]
[null,"集計",{"$f":"SUBTOTAL(109,住居費[予算])","v":{"v":1810,"d":"¥1,810"}},{"$f":"SUBTOTAL(109,住居費[実費])","v":{"v":1740,"d":"¥1,740"}},{"$f":"SUBTOTAL(109,住居費[差額])","v":{"v":70,"d":"¥70"}}]
[{"$nulls":6},"ローン","予算","実費","差額"]
[null,"交通費","予算","実費","差額",null,"私用",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"車両費",{"v":250,"d":"¥250"},{"v":250,"d":"¥250"},{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"学生",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"バス/タクシー代",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"クレジット カード",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"保険",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"クレジット カード",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"免許",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"クレジット カード",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"燃料費",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"その他",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"整備代",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"集計",{"$f":"SUBTOTAL(109,ローン[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,ローン[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,ローン[差額])","v":{"v":0,"d":"¥0"}}]
[null,"その他",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"集計",{"$f":"SUBTOTAL(109,交通費[予算])","v":{"v":250,"d":"¥250"}},{"$f":"SUBTOTAL(109,交通費[実費])","v":{"v":250,"d":"¥250"}},{"$f":"SUBTOTAL(109,交通費[差額])","v":{"v":0,"d":"¥0"}},null,"税金","予算","実費","差額"]
[{"$nulls":6},"国",null,null,{"$f":"税金[[#This Row],[予算]]-税金[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"保険料","予算","実費","差額",null,"都道府県",null,null,{"$f":"税金[[#This Row],[予算]]-税金[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"自宅",null,null,{"$f":"保険料[[#This Row],[予算]]-保険料[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"市町村",null,null,{"$f":"税金[[#This Row],[予算]]-税金[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"医療保険",null,null,{"$f":"保険料[[#This Row],[予算]]-保険料[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"その他",null,null,{"$f":"税金[[#This Row],[予算]]-税金[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"生命保険",null,null,{"$f":"保険料[[#This Row],[予算]]-保険料[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"集計",{"$f":"SUBTOTAL(109,税金[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,税金[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,税金[差額])","v":{"v":0,"d":"¥0"}}]
[null,"その他",null,null,{"$f":"保険料[[#This Row],[予算]]-保険料[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"集計",{"$f":"SUBTOTAL(109,保険料[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,保険料[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,保険料[差額])","v":{"v":0,"d":"¥0"}},null,"貯蓄または投資","予算","実費","差額"]
[{"$nulls":6},"年金口座",null,null,{"$f":"貯蓄または投資[[#This Row],[予算]]-貯蓄または投資[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"食費","予算","実費","差額",null,"投資口座",null,null,{"$f":"貯蓄または投資[[#This Row],[予算]]-貯蓄または投資[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"食料品",null,null,{"$f":"食費[[#This Row],[予算]]-食費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"その他",null,null,{"$f":"貯蓄または投資[[#This Row],[予算]]-貯蓄または投資[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"外食",null,null,{"$f":"食費[[#This Row],[予算]]-食費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"集計",{"$f":"SUBTOTAL(109,貯蓄または投資[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,貯蓄または投資[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,貯蓄または投資[差額])","v":{"v":0,"d":"¥0"}}]
[null,"その他",null,null,{"$f":"食費[[#This Row],[予算]]-食費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"集計",{"$f":"SUBTOTAL(109,食費[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,食費[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,食費[差額])","v":{"v":0,"d":"¥0"}},null,"贈答および寄付","予算","実費","差額"]
[{"$nulls":6},"募金/寄付 1",null,null,{"$f":"贈答および寄付[[#This Row],[予算]]-贈答および寄付[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"ペット費用","予算","実費","差額",null,"募金/寄付 2",null,null,{"$f":"贈答および寄付[[#This Row],[予算]]-贈答および寄付[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"食費",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"募金/寄付 3",null,null,{"$f":"贈答および寄付[[#This Row],[予算]]-贈答および寄付[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"医療",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"集計",{"$f":"SUBTOTAL(109,贈答および寄付[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,贈答および寄付[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,贈答および寄付[差額])","v":{"v":0,"d":"¥0"}}]
[null,"グルーミング代",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"おもちゃ",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"法律","予算","実費","差額"]
[null,"その他",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"弁護士",null,null,{"$f":"法律[[#This Row],[予算]]-法律[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"集計",{"$f":"SUBTOTAL(109,ペット費用[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,ペット費用[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,ペット費用[差額])","v":{"v":0,"d":"¥0"}},null,"養育費",null,null,{"$f":"法律[[#This Row],[予算]]-法律[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[{"$nulls":6},"担保権/判決に基づく支払い",null,null,{"$f":"法律[[#This Row],[予算]]-法律[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"日常生活関連費","予算","実費","差額",null,"その他",null,null,{"$f":"法律[[#This Row],[予算]]-法律[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"医療",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},null,"集計",{"$f":"SUBTOTAL(109,法律[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,法律[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,法律[差額])","v":{"v":0,"d":"¥0"}}]
[null,"整髪/爪",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"衣料品",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"ドライ クリーニング",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"スポーツ クラブ",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"会費または手数料",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"その他",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"集計",{"$f":"SUBTOTAL(109,日常生活関連費[予算])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,日常生活関連費[実費])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,日常生活関連費[差額])","v":{"v":0,"d":"¥0"}}]