{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["開始","月間予算レポート","月間支出レポート","追加データ"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"このテンプレートについて"]
[null,"このブックを使用し、支出を記録して家計簿を作成します。"]
[null,"それぞれの収入源からの収入見積と収入実績は [月間予算レポート] ワークシートに入力し、様々なカテゴリでの支出の見積額と実績額は [月間支出レポート] ワークシートに入力します。"]
[null,"収支と差額のそれぞれの見積額と実績額は自動計算され、[家計サマリ] と [家計のあらまし] グラフは [月間予算レポート] ワークシートで更新されます。"]
[null,"表のカテゴリの編集と新しいカテゴリの追加は [追加データ] ワークシートで行えます。"]
[null,"注:  "]
[null,"[月間予算レポート] ワークシートの列 A と、 [月間支出レポート] ワークシートと [追加データ] ワークシートのセル A1 に追加の説明があります。このテキストは意図的に表示されません。テキストを削除するには、列 A またはセル A1 を選択し、[削除] を選択します。テキストを再表示するには、列 A またはセル A1 を選択し、フォントの色を変更します。"]
[null,"テーブルの詳細については、テーブル内で Shift キーを押しながら F10 キーを押して、[テーブル] オプション、[代替テキスト] の順に選択します。ピボットテーブルの場合は、テーブル内で Shift キーを押しながら F10 キーを押して、[ピボットテーブル オプション]、[代替テキスト] タブの順に選択します。"]

{"sheet":"月間予算レポート","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,13],[1,9,5,13],[2,2,2,5],[3,2,3,5],[4,2,4,5],[7,1,10,1],[7,5,10,5],[7,6,10,6],[8,9,31,9],[12,1,16,1],[12,5,16,5],[12,6,16,6],[19,1,34,6]]}
["このワークシートでは、[月間予算レポート] を作成します。このワークシートのタイトルは右のセルに表示され、サブタイトルはセル J1 に表示されます。セル F1 を選択すると [月間支出レポート] ワークシートに移動します。このワークシートの使用方法に関するその他の役立つ説明がこの列にある各セルに表示されます。","家計のあらまし",{"$nulls":3},"月間支出",{"$nulls":3},"家計サマリ",null,null,"一本の緑色の麦の穂がこのセルに表示されます。"]
["収支ラベルは右のセルに表示されます。テーブル データをフィルター処理するピボットテーブル スライサーは、セル J2 から N6 にあります。複数のカテゴリを選択するには、Control キーを押したまま選択します。","収支",{"$nulls":7},"このセルには、選択したカテゴリを使って下のピボットテーブルをフィルター処理するカテゴリ スライサーが表示されます。"]
["収支見積ラベルは右のセルに表示されます。収支見積はセル G3 で自動的に計算されます。","収支見積","(見積から支出を差し引いたもの)",{"$nulls":3},{"$f":"D17-SUM(予算詳細[予算])","v":{"v":1585,"d":"¥1,585"}}]
["収支実績ラベルは右のセルに表示されます。収支実績はセル G4 で自動的に計算されます。","収支実績 ","(実績から支出を差し引いたもの)",{"$nulls":3},{"$f":"D11-SUM(予算詳細[実費])","v":{"v":1740,"d":"¥1,740"}}]
["差額ラベルは右のセルに表示されます。差額はセル G5 で自動的に計算されます。次の指示はセル A7 に表示されます。","差額","(実績から見積を差し引いたもの)",{"$nulls":3},{"$f":"G4-G3","v":{"v":155,"d":"¥155"}}]
[]
["収入ラベルは右のセルに、支出ラベルはセル F7 に、家計サマリーのヒントはセル J7 に表示されます。","収入",{"$nulls":3},"支出",{"$nulls":3},"下のピボットテーブルを選択し、[分析] タブで [更新] を選択して更新します。"]
["収入実績ラベルは右のセルに、支出実績ラベルはセル F8 に表示されます。収入 1 をセル D8 に入力します。支出実績はセル G8 で自動計算されます。","実績","収入 1",{"v":5800,"d":"¥5,800"},null,"実績",{"$f":"SUM(予算詳細[実費])","v":{"v":7860,"d":"¥7,860"}}]
["収入 2 をセル D9 に入力します。画像はセル J9 に表示されます。ピボットテーブルは、セル K9 から始まります。ピボットテーブルを更新するには、[分析] タブで [更新] を選択します。",null,"収入 2",{"v":2300,"d":"¥2,300"},{"$nulls":5},"このセルには画像が表示されます。","カテゴリ","予算 ","実費 ","差額 "]
["臨時収入をセル D10 に入力します。",null,"臨時収入",{"v":1500,"d":"¥1,500"},{"$nulls":6},"ギフトまたは寄付",{"v":100,"d":"¥100"},{"v":125,"d":"¥125"},{"v":-25,"d":"(¥25)"}]
["収入合計ラベルはセル C11 に表示され、収入合計はセル D11 で自動計算されます。次の指示はセル A13 に表示されます。",null,"収入合計",{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"¥9,600"}}]
[{"$nulls":10},"ペット費用",{"v":170,"d":"¥170"},{"v":100,"d":"¥100"},{"v":70,"d":"¥70"}]
["収入見積ラベルは右のセルに、支出見積ラベルはセル F13 に表示されます。支出見積はセル G13 で自動計算されます。","見積",{"$nulls":3},"見積",{"$f":"SUM(予算詳細[予算])","v":{"v":7915,"d":"¥7,915"}}]
["収入見積 1 をセル D14 に入力します。",null,"収入 1",{"v":6000,"d":"¥6,000"},{"$nulls":6},"ローン",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
["収入見積 2 をセル D15 に入力します。",null,"収入 2",{"v":1000,"d":"¥1,000"}]
["臨時収入をセル D16 に入力します。",null,"臨時収入",{"v":2500,"d":"¥2,500"},{"$nulls":6},"娯楽",{"v":400,"d":"¥400"},{"v":358,"d":"¥358"},{"v":42,"d":"¥42"}]
["収入合計ラベルはセル C17 に表示され、収入合計はセル D17 で自動計算されます。次の指示はセル A20 に表示されます。",null,"収入合計",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"¥9,500"}}]
[{"$nulls":10},"交通費",{"v":1425,"d":"¥1,425"},{"v":1375,"d":"¥1,375"},{"v":50,"d":"¥50"}]
[]
["カテゴリ別の支出の割合を示す円グラフは、右のセルに表示されます。","カテゴリ別の支出の割合を示す円グラフはこのセルに表示されます。",{"$nulls":8},"子供",{"v":140,"d":"¥140"},{"v":140,"d":"¥140"},{"v":0,"d":"¥0"}]
[]
[{"$nulls":10},"住居費",{"v":2830,"d":"¥2,830"},{"v":2702,"d":"¥2,702"},{"v":128,"d":"¥128"}]
[]
[{"$nulls":10},"食費",{"v":1100,"d":"¥1,100"},{"v":1320,"d":"¥1,320"},{"v":-220,"d":"(¥220)"}]
[]
[{"$nulls":10},"税金",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"v":0,"d":"¥0"}]
[]
[{"$nulls":10},"貯蓄または投資",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[]
[{"$nulls":10},"日常生活関連費",{"v":150,"d":"¥150"},{"v":140,"d":"¥140"},{"v":10,"d":"¥10"}]
[]
[{"$nulls":10},"保険",{"v":900,"d":"¥900"},{"v":900,"d":"¥900"},{"v":0,"d":"¥0"}]
[]
[{"$nulls":10},"総計",{"v":7915,"d":"¥7,915"},{"v":7860,"d":"¥7,860"},{"v":55,"d":"¥55"}]

{"sheet":"月間支出レポート","index":2,"n_rows":62,"n_cols":7,"rows_kept":62,"merged":[[0,1,0,4],[0,5,0,6]]}
["このワークシートでは、月間支出レポートを計算します。このワークシートのタイトルは右のセルに表示されます。F1 を選択すると、[月間予算レポート] ワークシートに移動できます。","月間支出レポート",{"$nulls":3},"月間予算レポート"]
[" 右側のセルから始めて、[予算詳細] テーブルに情報を入力します。","内容","カテゴリ","予算","実費","差額","実費のあらまし"]
[null,"課外活動","子供",{"v":40,"d":"¥40"},{"v":40,"d":"¥40"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":40,"d":"¥40"}}]
[null,"医療","子供",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"学校用品","子供",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"授業料","子供",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":100,"d":"¥100"}}]
[null,"コンサート","娯楽",{"v":50,"d":"¥50"},{"v":40,"d":"¥40"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":10,"d":"¥10"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":40,"d":"¥40"}}]
[null,"観劇","娯楽",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":50,"d":"¥50"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":150,"d":"¥150"}}]
[null,"映画","娯楽",{"v":50,"d":"¥50"},{"v":28,"d":"¥28"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":22,"d":"¥22"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":28,"d":"¥28"}}]
[null,"音楽 (CD、ダウンロードなど)","娯楽",{"v":50,"d":"¥50"},{"v":30,"d":"¥30"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":20,"d":"¥20"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":30,"d":"¥30"}}]
[null,"スポーツ イベント","娯楽",{"v":0,"d":"¥0"},{"v":40,"d":"¥40"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-40,"d":"(¥40)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":40,"d":"¥40"}}]
[null,"ビデオ/DVD (購入)","娯楽",{"v":20,"d":"¥20"},{"v":50,"d":"¥50"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-30,"d":"(¥30)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":50,"d":"¥50"}}]
[null,"ビデオ/DVD (レンタル)","娯楽",{"v":30,"d":"¥30"},{"v":20,"d":"¥20"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":10,"d":"¥10"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":20,"d":"¥20"}}]
[null,"外食","食費",{"v":1000,"d":"¥1,000"},{"v":1200,"d":"¥1,200"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-200,"d":"(¥200)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":1200,"d":"¥1,200"}}]
[null,"食料品","食費",{"v":100,"d":"¥100"},{"v":120,"d":"¥120"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-20,"d":"(¥20)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":120,"d":"¥120"}}]
[null,"募金/寄付 1","ギフトまたは寄付",{"v":75,"d":"¥75"},{"v":100,"d":"¥100"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-25,"d":"(¥25)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":100,"d":"¥100"}}]
[null,"募金/寄付 2","ギフトまたは寄付",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":25,"d":"¥25"}}]
[null,"ギフト 1","ギフトまたは寄付",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"ギフト 2","ギフトまたは寄付",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"ケーブル/BS/CS テレビ","住居費",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":100,"d":"¥100"}}]
[null,"電気","住居費",{"v":45,"d":"¥45"},{"v":50,"d":"¥50"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-5,"d":"(¥5)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":50,"d":"¥50"}}]
[null,"ガス","住居費",{"v":300,"d":"¥300"},{"v":400,"d":"¥400"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-100,"d":"(¥100)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":400,"d":"¥400"}}]
[null,"ハウス クリーニング サービス","住居費",{"v":200,"d":"¥200"},null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":200,"d":"¥200"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"修繕費","住居費",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":50,"d":"¥50"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":150,"d":"¥150"}}]
[null,"住宅ローン/家賃","住居費",{"v":1700,"d":"¥1,700"},{"v":1700,"d":"¥1,700"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":1700,"d":"¥1,700"}}]
[null,"ガス/燃料","住居費",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"オンライン/インターネット サービス","住居費",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":100,"d":"¥100"}}]
[null,"電話 (携帯)","住居費",{"v":60,"d":"¥60"},{"v":60,"d":"¥60"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":60,"d":"¥60"}}]
[null,"電話 (自宅)","住居費",{"v":35,"d":"¥35"},{"v":39,"d":"¥39"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-4,"d":"(¥4)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":39,"d":"¥39"}}]
[null,"消耗品","住居費",{"v":40,"d":"¥40"},{"v":55,"d":"¥55"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-15,"d":"(¥15)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":55,"d":"¥55"}}]
[null,"ゴミ回収とリサイクル","住居費",{"v":25,"d":"¥25"},{"v":22,"d":"¥22"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":3,"d":"¥3"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":22,"d":"¥22"}}]
[null,"水道代","住居費",{"v":25,"d":"¥25"},{"v":26,"d":"¥26"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-1,"d":"(¥1)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":26,"d":"¥26"}}]
[null,"医療保険","保険",{"v":400,"d":"¥400"},{"v":400,"d":"¥400"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":400,"d":"¥400"}}]
[null,"住宅保険","保険",{"v":400,"d":"¥400"},{"v":400,"d":"¥400"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":400,"d":"¥400"}}]
[null,"生命保険","保険",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":100,"d":"¥100"}}]
[null,"クレジット カード 1","ローン",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":200,"d":"¥200"}}]
[null,"クレジット カード 2","ローン",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"クレジット カード 3","ローン",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"個人ローン","ローン",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"教育ローン","ローン",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"衣料品","日常生活関連費",{"v":150,"d":"¥150"},{"v":140,"d":"¥140"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":10,"d":"¥10"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":140,"d":"¥140"}}]
[null,"ドライ クリーニング","日常生活関連費",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"整髪/爪","日常生活関連費",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"スポーツ クラブ","日常生活関連費",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"医療","日常生活関連費",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"食費","ペット費用",{"v":150,"d":"¥150"},{"v":75,"d":"¥75"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":75,"d":"¥75"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":75,"d":"¥75"}}]
[null,"グルーミング代","ペット費用",{"v":20,"d":"¥20"},{"v":25,"d":"¥25"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-5,"d":"(¥5)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":25,"d":"¥25"}}]
[null,"獣医","ペット費用",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"おもちゃ","ペット費用",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"投資口座","貯蓄または投資",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":200,"d":"¥200"}}]
[null,"年金口座","貯蓄または投資",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"国税","税金",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":300,"d":"¥300"}}]
[null,"地方税","税金",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"都道府県税","税金",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"バス/タクシー代","交通費",{"v":100,"d":"¥100"},{"v":150,"d":"¥150"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":-50,"d":"(¥50)"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":150,"d":"¥150"}}]
[null,"ガソリン代","交通費",{"v":450,"d":"¥450"},{"v":400,"d":"¥400"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":50,"d":"¥50"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":400,"d":"¥400"}}]
[null,"保険","交通費",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":300,"d":"¥300"}}]
[null,"自動車税 ","交通費",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":25,"d":"¥25"}}]
[null,"整備代","交通費",{"v":100,"d":"¥100"},{"v":50,"d":"¥50"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":50,"d":"¥50"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":50,"d":"¥50"}}]
[null,"駐車場代","交通費",null,null,{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}}]
[null,"車のローン","交通費",{"v":450,"d":"¥450"},{"v":450,"d":"¥450"},{"$f":"予算詳細[[#This Row],[予算]]-予算詳細[[#This Row],[実費]]","v":{"v":0,"d":"¥0"}},{"$f":"予算詳細[[#This Row],[実費]]","v":{"v":450,"d":"¥450"}}]
[null,"集計",null,{"$f":"SUBTOTAL(109,予算詳細[予算])","v":{"v":7915,"d":"¥7,915"}},{"$f":"SUBTOTAL(109,予算詳細[実費])","v":{"v":7860,"d":"¥7,860"}},{"$f":"SUBTOTAL(109,予算詳細[差額])","v":{"v":55,"d":"¥55"}}]

{"sheet":"追加データ","index":3,"n_rows":15,"n_cols":5,"rows_kept":15}
["このワークシートを使用して、[月間支出レポート] ワークシート内の [予算詳細] テーブルにある [カテゴリ] 列のドロップダウン リストを更新します。これを行うには、セル E2 から始まる [予算カテゴリ参照] テーブルで、カテゴリを変更したり新しいカテゴリを入力します。[月間予算レポート] ワークシートの [家計のあらまし] グラフにリンクされたピボットテーブルはセル B2 から始まります。","[家計のあらまし] グラフ用のピボットテーブル",null,null,"予算詳細カテゴリの参照リスト"]
[null,"カテゴリ","費用",null,"予算カテゴリ参照"]
[null,"子供",{"v":140,"d":"¥140"},null,"子供"]
[null,"娯楽",{"v":358,"d":"¥358"},null,"娯楽"]
[null,"食費",{"v":1320,"d":"¥1,320"},null,"食費"]
[null,"ギフトまたは寄付",{"v":125,"d":"¥125"},null,"ギフトまたは寄付"]
[null,"住居費",{"v":2702,"d":"¥2,702"},null,"住居費"]
[null,"保険",{"v":900,"d":"¥900"},null,"保険"]
[null,"ローン",{"v":200,"d":"¥200"},null,"ローン"]
[null,"日常生活関連費",{"v":140,"d":"¥140"},null,"日常生活関連費"]
[null,"ペット費用",{"v":100,"d":"¥100"},null,"ペット費用"]
[null,"貯蓄または投資",{"v":200,"d":"¥200"},null,"貯蓄または投資"]
[null,"税金",{"v":300,"d":"¥300"},null,"税金"]
[null,"交通費",{"v":1375,"d":"¥1,375"},null,"交通費"]
[null,"総計",{"v":7860,"d":"¥7,860"}]