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

{"sheet":"開始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"このテンプレートについて"]
[null,"この月間個人予算ワークシートを使用すると、見積月収と実月収、および予算と実費を管理できます。"]
[null,"それぞれの表にさまざまなカテゴリで発生した経費を入力します。"]
[null,"見積残高、実残高、差額は自動的に計算されます。"]
[null,"メモ: "]
[null,"月間個人予算ワークシートの列 A に詳細な指示が記載されています。このテキストは意図的に表示されません。テキストを削除するには、列 A を選択し、[削除] を選択します。テキストを再表示するには、列 A を選択し、フォントの色を変更します。"]
[null,"ワークシートの表の詳細については、表内で Shift キーを押し、F10 キーを押して、[テーブル] オプションを選択し、[代替テキスト] を選択します。"]

{"sheet":"月間個人予算","index":1,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[3,1,5,1],[3,2,3,3],[3,6,4,8],[3,9,4,9],[4,2,4,3],[5,2,5,3],[5,6,6,8],[5,9,6,9],[7,1,9,1],[7,2,7,3],[7,6,8,8],[7,9,8,9],[8,2,8,3],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9],[64,1,64,4]]}
["このワークシートでは、月間個人予算を作成します。このワークシートの使用方法に関する役に立つ指示がこの列のセルに表示されます。下向き矢印で開始します。"]
["このワークシートのタイトルは、右のセルに表示されます。次の指示はセル A4 に表示されます。","月間個人予算"]
[]
["見積月収ラベルが、右のセルに表示されます。セル E4 に収入 1 を入力し、E5 に臨時収入を入力し、E6 で月収合計を計算します。次の指示はセル A6 に表示されます。","見積月収","収入 1",null,{"v":4300,"d":"¥4,300.00"},null,"見積残高\n(見積収入から経費を減算)",null,null,{"$f":"E6-J59","v":{"v":3405,"d":"¥3,405.00"}}]
[null,null,"臨時収入",null,{"v":300,"d":"¥300.00"}]
["見積残高はセル J4 で自動的に計算され、実残高はセル J6 に、差額はセル J8 に表示されます。次の指示はセル A8 に表示されます。",null,"月収合計",null,{"$f":"SUM(E4:E5)","v":{"v":4600,"d":"¥4,600.00"}},null,"実残高\n(実収入から経費を減算)",null,null,{"$f":"E10-J61","v":{"v":3064,"d":"¥3,064.00"}}]
[]
["実月収ラベルが、右のセルに表示されます。セル E8 に収入 1 を入力し、E9 に臨時収入を入力し、E10 で月収合計を計算します。次の指示はセル A12 に表示されます。","実月収","収入 1",null,{"v":4000,"d":"¥4,000.00"},null,"差額\n(実績から見積を減算)",null,null,{"$f":"J6-J4","v":{"v":-341,"d":"(¥341.00)"}}]
[null,null,"臨時収入",null,{"v":300,"d":"¥300.00"}]
[null,null,"月収合計",null,{"$f":"SUM(E8:E9)","v":{"v":4300,"d":"¥4,300.00"}}]
[]
["住居費の表の右のセル以降と、娯楽の表のセル G12 以降に詳細を入力します。次の指示はセル A25 に表示されます。","住居費","予算","実費","差額",null,"娯楽","予算","実費","差額"]
[null,"住宅ローン/家賃",{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"ビデオ/DVD",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"電話番号",{"v":54,"d":"¥54.00"},{"v":100,"d":"¥100.00"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":-46,"d":"¥-46.00"}},null,"CD",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"電気",{"v":44,"d":"¥44.00"},{"v":56,"d":"¥56.00"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":-12,"d":"¥-12.00"}},null,"映画",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"ガス",{"v":22,"d":"¥22.00"},{"v":28,"d":"¥28.00"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":-6,"d":"¥-6.00"}},null,"コンサート",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"水道代",{"v":8,"d":"¥8.00"},{"v":8,"d":"¥8.00"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"スポーツ イベント",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"受信料",{"v":34,"d":"¥34.00"},{"v":34,"d":"¥34.00"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"観劇",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"廃棄物除去",{"v":10,"d":"¥10.00"},{"v":10,"d":"¥10.00"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"その他",null,null,{"$f":"娯楽[[#This Row],[予算]]-娯楽[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"保守/修繕費",{"v":23,"d":"¥23.00"},{"v":0,"d":"¥0.00"},{"$f":"住居費[[#This Row],[予算]]-住居費[[#This Row],[実費]]","v":{"v":23,"d":"¥23.00"}},null,"その他",null,null,{"$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,"その他",null,null,{"$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,"小計",null,null,{"$f":"SUBTOTAL(109,娯楽[差額])","v":{"v":0,"d":"¥0.00"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,住居費[差額])","v":{"v":-41,"d":"¥-41.00"}}]
[{"$nulls":6},"ローン","予算","実費","差額"]
["交通費の表の右のセル以降と、ローンの表のセル G24 以降に詳細を入力します。次の指示はセル A35 に表示されます。","交通","予算","実費","差額",null,"私用",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"車両費",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"学生",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"バス/タクシー代",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"クレジット カード",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"保険",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"クレジット カード",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"免許",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"クレジット カード",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"燃料費",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"その他",null,null,{"$f":"ローン[[#This Row],[予算]]-ローン[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"整備代",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"小計",null,null,{"$f":"SUBTOTAL(109,ローン[差額])","v":{"v":0,"d":"¥0.00"}}]
[null,"その他",null,null,{"$f":"交通費[[#This Row],[予算]]-交通費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,交通費[差額])","v":{"v":0,"d":"¥0.00"}},null,"税金","予算","実費","差額"]
[{"$nulls":6},"国",null,null,{"$f":"税金[[#This Row],[予算]]-税金[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
["保険料の表の右のセル以降と、税金の表のセル G33 以降に詳細を入力します。次の指示はセル A42 に表示されます。","保険料","予算","実費","差額",null,"都道府県",null,null,{"$f":"税金[[#This Row],[予算]]-税金[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"自宅",null,null,{"$f":"保険料[[#This Row],[予算]]-保険料[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"市町村",null,null,{"$f":"税金[[#This Row],[予算]]-税金[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"医療保険",null,null,{"$f":"保険料[[#This Row],[予算]]-保険料[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"その他",null,null,{"$f":"税金[[#This Row],[予算]]-税金[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"生命保険",null,null,{"$f":"保険料[[#This Row],[予算]]-保険料[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"小計",null,null,{"$f":"SUBTOTAL(109,税金[差額])","v":{"v":0,"d":"¥0.00"}}]
[null,"その他",null,null,{"$f":"保険料[[#This Row],[予算]]-保険料[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,保険料[差額])","v":{"v":0,"d":"¥0.00"}},null,"貯蓄または投資","予算","実費","差額"]
[{"$nulls":6},"年金口座",null,null,{"$f":"貯蓄[[#This Row],[予算]]-貯蓄[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
["食品の表の右のセル以降と、貯蓄の表のセル G40 以降に詳細を入力します。次の指示はセル A48 に表示されます。","食品","予算","実費","差額",null,"投資口座",null,null,{"$f":"貯蓄[[#This Row],[予算]]-貯蓄[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"食料品",null,null,{"$f":"食品[[#This Row],[予算]]-食品[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"その他",null,null,{"$f":"貯蓄[[#This Row],[予算]]-貯蓄[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"外食",null,null,{"$f":"食品[[#This Row],[予算]]-食品[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"小計",null,null,{"$f":"SUBTOTAL(109,貯蓄[差額])","v":{"v":0,"d":"¥0.00"}}]
[null,"その他",null,null,{"$f":"食品[[#This Row],[予算]]-食品[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,食品[差額])","v":{"v":0,"d":"¥0.00"}},null,"贈答および寄付","予算","実費","差額"]
[{"$nulls":6},"募金/寄付 1",null,null,{"$f":"ギフト[[#This Row],[予算]]-ギフト[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
["ペット費用の表の右のセル以降と、ギフトの表のセル G46 以降に詳細を入力します。次の指示はセル A56 に表示されます。","ペット費用","予算","実費","差額",null,"募金/寄付 2",null,null,{"$f":"ギフト[[#This Row],[予算]]-ギフト[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"食費",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"募金/寄付 3",null,null,{"$f":"ギフト[[#This Row],[予算]]-ギフト[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"医療",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"小計",null,null,{"$f":"SUBTOTAL(109,ギフト[差額])","v":{"v":0,"d":"¥0.00"}}]
[null,"グルーミング代",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"おもちゃ",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"法律","予算","実費","差額"]
[null,"その他",null,null,{"$f":"ペット費用[[#This Row],[予算]]-ペット費用[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"弁護士",null,null,{"$f":"法律[[#This Row],[予算]]-法律[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,ペット費用[差額])","v":{"v":0,"d":"¥0.00"}},null,"養育費",null,null,{"$f":"法律[[#This Row],[予算]]-法律[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":6},"担保権/判決に基づく支払い",null,null,{"$f":"法律[[#This Row],[予算]]-法律[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
["日常生活関連費の表の右のセル以降と、法律の表のセル G52 以降に詳細を入力します。次の指示はセル A59 に表示されます。","日常生活関連費","予算","実費","差額",null,"その他",null,null,{"$f":"法律[[#This Row],[予算]]-法律[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"医療",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"小計",null,null,{"$f":"SUBTOTAL(109,法律[差額])","v":{"v":0,"d":"¥0.00"}}]
[null,"整髪/爪",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
["予算合計はセル J59 で自動的に計算され、実費合計は J61 で、差額合計は J63 で自動的に計算されます。","衣料品",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"予算合計",null,null,{"$f":"SUBTOTAL(109,住居費[予算],交通費[予算],保険料[予算],食品[予算],ペット費用[予算],日常生活関連費[予算],娯楽[予算],ローン[予算],税金[予算],貯蓄[予算],ギフト[予算],法律[予算])","v":{"v":1195,"d":"¥1,195.00"}}]
[null,"ドライ クリーニング",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"スポーツ クラブ",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"実費合計",null,null,{"$f":"SUBTOTAL(109,住居費[実費],交通費[実費],保険料[実費],食品[実費],ペット費用[実費],日常生活関連費[実費],娯楽[実費],ローン[実費],税金[実費],貯蓄[実費],ギフト[実費],法律[実費])","v":{"v":1236,"d":"¥1,236.00"}}]
[null,"会費または手数料",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}}]
[null,"その他",null,null,{"$f":"日常生活関連費[[#This Row],[予算]]-日常生活関連費[[#This Row],[実費]]","v":{"v":0,"d":"¥0.00"}},null,"差額合計",null,null,{"$f":"J59-J61","v":{"v":-41,"d":"(¥41.00)"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,日常生活関連費[差額])","v":{"v":0,"d":"¥0.00"}}]