{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["開始","個人予算"],"not_rendered":{"defined_names":2},"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":107,"n_cols":17,"rows_kept":107,"merged":[[1,1,1,3],[1,4,1,15],[27,2,27,16],[36,2,36,16],[43,2,43,16],[53,2,53,16],[62,2,62,16],[69,2,69,16],[79,2,79,16],[87,2,87,16],[95,2,95,16],[103,2,103,16]]}
["このワークシートでは、単純な個人予算を作成します。このワークシートの使用方法に関する役立つ説明がこの列にある各セルに表示されます。下向き矢印で開始します。"]
["このワークシートのタイトルが右のセルに表示されます。セル Q2 に年を入力します。次の指示はセル A4 に表示されます。","個人予算",{"$nulls":14},{"$f":"YEAR(TODAY())","v":2019}]
[]
["ラベルはセル C4 から P4 に表示されます。",null,"収益","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
["セル C5 から順に、詳細を収入のテーブルに入力します。次の指示はセル A11 に表示されます。",null,"収入","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年","スパークライン"]
[null,null,"給料",{"v":2600,"d":"¥2,600.00"},{"v":2600,"d":"¥2,600.00"},{"v":2600,"d":"¥2,600.00"},{"$nulls":9},{"$f":"SUM(収入[[#This Row],[1 月]:[12 月]])","v":{"v":7800,"d":"¥7,800.00"}}]
[null,null,"利息/配当金",{"v":649,"d":"¥649.00"},{"v":313,"d":"¥313.00"},{"v":664,"d":"¥664.00"},{"$nulls":9},{"$f":"SUM(収入[[#This Row],[1 月]:[12 月]])","v":{"v":1626,"d":"¥1,626.00"}}]
[null,null,"その他",{"v":474,"d":"¥474.00"},{"v":643,"d":"¥643.00"},{"v":380,"d":"¥380.00"},{"$nulls":9},{"$f":"SUM(収入[[#This Row],[1 月]:[12 月]])","v":{"v":1497,"d":"¥1,497.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,収入[1 月])","v":{"v":3723,"d":"¥3,723.00"}},{"$f":"SUBTOTAL(109,収入[2 月])","v":{"v":3556,"d":"¥3,556.00"}},{"$f":"SUBTOTAL(109,収入[3 月])","v":{"v":3644,"d":"¥3,644.00"}},{"$f":"SUBTOTAL(109,収入[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,収入[年])","v":{"v":10923,"d":"¥10,923.00"}}]
[]
["ラベルはセル C11 から P11 までに表示されます。",null,"支出","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
["セル C12 から順に、自宅の経費をテーブルに入力します。次の指示はセル A20 に表示されます。",null,"自宅","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年","スパークライン"]
[null,null,"住宅ローン",{"v":750,"d":"¥750.00"},{"v":750,"d":"¥750.00"},{"v":750,"d":"¥750.00"},{"$nulls":9},{"$f":"SUM(自宅[[#This Row],[1 月]:[12 月]])","v":{"v":2250,"d":"¥2,250.00"}}]
[null,null,"保険",{"$nulls":12},{"$f":"SUM(自宅[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"修理費",null,null,{"v":75,"d":"¥75.00"},{"$nulls":9},{"$f":"SUM(自宅[[#This Row],[1 月]:[12 月]])","v":{"v":75,"d":"¥75.00"}}]
[null,null,"点検費",{"v":35,"d":"¥35.00"},{"v":35,"d":"¥35.00"},{"v":35,"d":"¥35.00"},{"$nulls":9},{"$f":"SUM(自宅[[#This Row],[1 月]:[12 月]])","v":{"v":105,"d":"¥105.00"}}]
[null,null,"水道光熱費",{"v":165,"d":"¥165.00"},{"v":165,"d":"¥165.00"},{"v":165,"d":"¥165.00"},{"$nulls":9},{"$f":"SUM(自宅[[#This Row],[1 月]:[12 月]])","v":{"v":495,"d":"¥495.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,自宅[1 月])","v":{"v":950,"d":"¥950.00"}},{"$f":"SUBTOTAL(109,自宅[2 月])","v":{"v":950,"d":"¥950.00"}},{"$f":"SUBTOTAL(109,自宅[3 月])","v":{"v":1025,"d":"¥1,025.00"}},{"$f":"SUBTOTAL(109,自宅[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,自宅[年])","v":{"v":2925,"d":"¥2,925.00"}}]
[]
["セル C20 から順に、毎日の支出をテーブルに入力します。次の指示はセル A29 に表示されます。",null,"生活費","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"食料品 ",{"v":191,"d":"¥191.00"},{"v":152,"d":"¥152.00"},{"v":145,"d":"¥145.00"},{"$nulls":9},{"$f":"SUM(毎日[[#This Row],[1 月]:[12 月]])","v":{"v":488,"d":"¥488.00"}}]
[null,null,"保育",{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"$nulls":9},{"$f":"SUM(毎日[[#This Row],[1 月]:[12 月]])","v":{"v":600,"d":"¥600.00"}}]
[null,null,"ドライ クリーニング",{"v":20,"d":"¥20.00"},null,{"v":20,"d":"¥20.00"},{"$nulls":9},{"$f":"SUM(毎日[[#This Row],[1 月]:[12 月]])","v":{"v":40,"d":"¥40.00"}}]
[null,null,"外食",{"v":55,"d":"¥55.00"},null,{"v":56,"d":"¥56.00"},{"$nulls":9},{"$f":"SUM(毎日[[#This Row],[1 月]:[12 月]])","v":{"v":111,"d":"¥111.00"}}]
[null,null,"ハウスクリーニング サービス",{"v":25,"d":"¥25.00"},{"v":17,"d":"¥17.00"},{"v":7,"d":"¥7.00"},{"$nulls":9},{"$f":"SUM(毎日[[#This Row],[1 月]:[12 月]])","v":{"v":49,"d":"¥49.00"}}]
[null,null,"犬の散歩代行",{"v":10,"d":"¥10.00"},{"v":5,"d":"¥5.00"},{"v":7,"d":"¥7.00"},{"$nulls":9},{"$f":"SUM(毎日[[#This Row],[1 月]:[12 月]])","v":{"v":22,"d":"¥22.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,毎日[1 月])","v":{"v":501,"d":"¥501.00"}},{"$f":"SUBTOTAL(109,毎日[2 月])","v":{"v":374,"d":"¥374.00"}},{"$f":"SUBTOTAL(109,毎日[3 月])","v":{"v":435,"d":"¥435.00"}},{"$f":"SUBTOTAL(109,毎日[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,毎日[年度])","v":{"v":1310,"d":"¥1,310.00"}}]
[]
["セル C29 から順に、交通費をテーブルに入力します。次の指示はセル A38 に表示されます。",null,"交通費","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"光熱費",{"v":195,"d":"¥195.00"},{"v":125,"d":"¥125.00"},{"v":171,"d":"¥171.00"},{"$nulls":9},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":491,"d":"¥491.00"}}]
[null,null,"保険料",{"v":165,"d":"¥165.00"},{"v":165,"d":"¥165.00"},{"v":165,"d":"¥165.00"},{"$nulls":9},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":495,"d":"¥495.00"}}]
[null,null,"修繕費",{"$nulls":12},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"洗車/整備サービス",{"v":10,"d":"¥10.00"},{"$nulls":11},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":10,"d":"¥10.00"}}]
[null,null,"駐車場",{"v":10,"d":"¥10.00"},{"v":40,"d":"¥40.00"},{"v":20,"d":"¥20.00"},{"$nulls":9},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":70,"d":"¥70.00"}}]
[null,null,"公共交通費",{"v":20,"d":"¥20.00"},{"v":40,"d":"¥40.00"},{"v":30,"d":"¥30.00"},{"$nulls":9},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":90,"d":"¥90.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,交通[1 月])","v":{"v":400,"d":"¥400.00"}},{"$f":"SUBTOTAL(109,交通[2 月])","v":{"v":370,"d":"¥370.00"}},{"$f":"SUBTOTAL(109,交通[3 月])","v":{"v":386,"d":"¥386.00"}},{"$f":"SUBTOTAL(109,交通[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[年度])","v":{"v":1156,"d":"¥1,156.00"}}]
[]
["セル C38 から順に、娯楽費をテーブルに入力します。次の指示がセル A45 に表示されます。",null,"娯楽","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"ケーブル TV",{"v":85,"d":"¥85.00"},{"v":85,"d":"¥85.00"},{"v":85,"d":"¥85.00"},{"$nulls":9},{"$f":"SUM(娯楽[[#This Row],[1 月]:[12 月]])","v":{"v":255,"d":"¥255.00"}}]
[null,null,"ビデオ/DVD レンタル",{"v":7,"d":"¥7.00"},{"v":8,"d":"¥8.00"},{"v":9,"d":"¥9.00"},{"$nulls":9},{"$f":"SUM(娯楽[[#This Row],[1 月]:[12 月]])","v":{"v":24,"d":"¥24.00"}}]
[null,null,"映画/演劇",{"v":9,"d":"¥9.00"},{"v":5,"d":"¥5.00"},{"v":9,"d":"¥9.00"},{"$nulls":9},{"$f":"SUM(娯楽[[#This Row],[1 月]:[12 月]])","v":{"v":23,"d":"¥23.00"}}]
[null,null,"コンサート/クラブ",{"v":5,"d":"¥5.00"},{"v":5,"d":"¥5.00"},{"v":7,"d":"¥7.00"},{"$nulls":9},{"$f":"SUM(娯楽[[#This Row],[1 月]:[12 月]])","v":{"v":17,"d":"¥17.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,娯楽[1 月])","v":{"v":106,"d":"¥106.00"}},{"$f":"SUBTOTAL(109,娯楽[2 月])","v":{"v":103,"d":"¥103.00"}},{"$f":"SUBTOTAL(109,娯楽[3 月])","v":{"v":110,"d":"¥110.00"}},{"$f":"SUBTOTAL(109,娯楽[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娯楽[年度])","v":{"v":319,"d":"¥319.00"}}]
[]
["セル C12 から順に、医療費をテーブルに入力します。次の指示はセル A55 に表示されます。",null,"医療保険","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"スポーツ クラブ会費",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"$nulls":9},{"$f":"SUM(医療保険[[#This Row],[1 月]:[12 月]])","v":{"v":150,"d":"¥150.00"}}]
[null,null,"保険料",{"v":225,"d":"¥225.00"},{"v":225,"d":"¥225.00"},{"v":225,"d":"¥225.00"},{"$nulls":9},{"$f":"SUM(医療保険[[#This Row],[1 月]:[12 月]])","v":{"v":675,"d":"¥675.00"}}]
[null,null,"処方薬",{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"$nulls":9},{"$f":"SUM(医療保険[[#This Row],[1 月]:[12 月]])","v":{"v":300,"d":"¥300.00"}}]
[null,null,"市販薬",{"v":6,"d":"¥6.00"},{"v":2,"d":"¥2.00"},{"v":9,"d":"¥9.00"},{"$nulls":9},{"$f":"SUM(医療保険[[#This Row],[1 月]:[12 月]])","v":{"v":17,"d":"¥17.00"}}]
[null,null,"患者負担金/自己負担費",{"v":20,"d":"¥20.00"},null,{"v":41,"d":"¥41.00"},{"$nulls":9},{"$f":"SUM(医療保険[[#This Row],[1 月]:[12 月]])","v":{"v":61,"d":"¥61.00"}}]
[null,null,"獣医/ペット医薬品",{"v":4,"d":"¥4.00"},null,{"v":25,"d":"¥25.00"},{"$nulls":9},{"$f":"SUM(医療保険[[#This Row],[1 月]:[12 月]])","v":{"v":29,"d":"¥29.00"}}]
[null,null,"生命保険",{"v":55,"d":"¥55.00"},{"v":55,"d":"¥55.00"},{"v":55,"d":"¥55.00"},{"$nulls":9},{"$f":"SUM(医療保険[[#This Row],[1 月]:[12 月]])","v":{"v":165,"d":"¥165.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,医療保険[1 月])","v":{"v":460,"d":"¥460.00"}},{"$f":"SUBTOTAL(109,医療保険[2 月])","v":{"v":432,"d":"¥432.00"}},{"$f":"SUBTOTAL(109,医療保険[3 月])","v":{"v":505,"d":"¥505.00"}},{"$f":"SUBTOTAL(109,医療保険[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,医療保険[年度])","v":{"v":1397,"d":"¥1,397.00"}}]
[]
["セル C55 から順に、休暇の支出をテーブルに入力します。次の指示はセル A64 に表示されます。",null,"休暇","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"航空運賃",null,{"v":485,"d":"¥485.00"},{"$nulls":10},{"$f":"SUM(休暇[[#This Row],[1 月]:[12 月]])","v":{"v":485,"d":"¥485.00"}}]
[null,null,"宿泊費",null,{"v":245,"d":"¥245.00"},{"$nulls":10},{"$f":"SUM(休暇[[#This Row],[1 月]:[12 月]])","v":{"v":245,"d":"¥245.00"}}]
[null,null,"食費",null,{"v":95,"d":"¥95.00"},{"$nulls":10},{"$f":"SUM(休暇[[#This Row],[1 月]:[12 月]])","v":{"v":95,"d":"¥95.00"}}]
[null,null,"お土産",{"$nulls":12},{"$f":"SUM(休暇[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"ペット ホテル",{"$nulls":12},{"$f":"SUM(休暇[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"レンタカー",null,{"v":85,"d":"¥85.00"},{"$nulls":10},{"$f":"SUM(休暇[[#This Row],[1 月]:[12 月]])","v":{"v":85,"d":"¥85.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,休暇[1 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[2 月])","v":{"v":910,"d":"¥910.00"}},{"$f":"SUBTOTAL(109,休暇[3 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休暇[年度])","v":{"v":910,"d":"¥910.00"}}]
[]
["セル C64 から順に、レクリエーションの支出をテーブルに入力します。次の指示はセル A71 に表示されます。",null,"レクリエーション","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"ジム費",{"$nulls":12},{"$f":"SUM(レクリエーション[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"スポーツ用品",{"$nulls":12},{"$f":"SUM(レクリエーション[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"チーム会費",{"$nulls":12},{"$f":"SUM(レクリエーション[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"玩具/子供用品",{"v":39,"d":"¥39.00"},{"v":33,"d":"¥33.00"},{"v":40,"d":"¥40.00"},{"$nulls":9},{"$f":"SUM(レクリエーション[[#This Row],[1 月]:[12 月]])","v":{"v":112,"d":"¥112.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,レクリエーション[1 月])","v":{"v":39,"d":"¥39.00"}},{"$f":"SUBTOTAL(109,レクリエーション[2 月])","v":{"v":33,"d":"¥33.00"}},{"$f":"SUBTOTAL(109,レクリエーション[3 月])","v":{"v":40,"d":"¥40.00"}},{"$f":"SUBTOTAL(109,レクリエーション[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,レクリエーション[年度])","v":{"v":112,"d":"¥112.00"}}]
[]
["セル C71 から順に、会費と購読料のテーブルに経費を入力します。次の指示はセル A81 に表示されます。",null,"会費/購読料","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"雑誌",{"$nulls":12},{"$f":"SUM(会費と購読料[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"新聞",{"$nulls":12},{"$f":"SUM(会費と購読料[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"インターネット接続",{"$nulls":12},{"$f":"SUM(会費と購読料[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"公共ラジオ",{"$nulls":12},{"$f":"SUM(会費と購読料[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"公共テレビ",{"$nulls":12},{"$f":"SUM(会費と購読料[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"宗教団体",{"v":29,"d":"¥29.00"},{"v":18,"d":"¥18.00"},{"v":17,"d":"¥17.00"},{"$nulls":9},{"$f":"SUM(会費と購読料[[#This Row],[1 月]:[12 月]])","v":{"v":64,"d":"¥64.00"}}]
[null,null,"募金/寄付",{"$nulls":12},{"$f":"SUM(会費と購読料[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,会費と購読料[1 月])","v":{"v":29,"d":"¥29.00"}},{"$f":"SUBTOTAL(109,会費と購読料[2 月])","v":{"v":18,"d":"¥18.00"}},{"$f":"SUBTOTAL(109,会費と購読料[3 月])","v":{"v":17,"d":"¥17.00"}},{"$f":"SUBTOTAL(109,会費と購読料[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会費と購読料[年度])","v":{"v":64,"d":"¥64.00"}}]
[]
["セル C81 から順に、個人経費をテーブルに入力します。次の指示はセル A89 に表示されます。",null,"私用","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"衣料品",null,null,{"v":29,"d":"¥29.00"},{"$nulls":9},{"$f":"SUM(個人[[#This Row],[1 月]:[12 月]])","v":{"v":29,"d":"¥29.00"}}]
[null,null,"贈答品",null,{"v":35,"d":"¥35.00"},{"$nulls":10},{"$f":"SUM(個人[[#This Row],[1 月]:[12 月]])","v":{"v":35,"d":"¥35.00"}}]
[null,null,"美容/理容費",{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"$nulls":9},{"$f":"SUM(個人[[#This Row],[1 月]:[12 月]])","v":{"v":75,"d":"¥75.00"}}]
[null,null,"書籍",{"$nulls":12},{"$f":"SUM(個人[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"音楽 (CD など)",{"$nulls":12},{"$f":"SUM(個人[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,個人[1 月])","v":{"v":25,"d":"¥25.00"}},{"$f":"SUBTOTAL(109,個人[2 月])","v":{"v":60,"d":"¥60.00"}},{"$f":"SUBTOTAL(109,個人[3 月])","v":{"v":54,"d":"¥54.00"}},{"$f":"SUBTOTAL(109,個人[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,個人[年度])","v":{"v":139,"d":"¥139.00"}}]
[]
["セル C89 から順に、金融債務をテーブルに入力します。次の指示はセル A97 に表示されます。",null,"金融債務","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年度","スパークライン"]
[null,null,"定期預金",{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"$nulls":9},{"$f":"SUM(金融​​[[#This Row],[1 月]:[12 月]])","v":{"v":75,"d":"¥75.00"}}]
[null,null,"年金 (401k、ロスIRA)",{"v":45,"d":"¥45.00"},{"v":45,"d":"¥45.00"},{"v":45,"d":"¥45.00"},{"$nulls":9},{"$f":"SUM(金融​​[[#This Row],[1 月]:[12 月]])","v":{"v":135,"d":"¥135.00"}}]
[null,null,"クレジット カード支払",{"v":75,"d":"¥75.00"},{"v":75,"d":"¥75.00"},{"v":75,"d":"¥75.00"},{"$nulls":9},{"$f":"SUM(金融​​[[#This Row],[1 月]:[12 月]])","v":{"v":225,"d":"¥225.00"}}]
[null,null,"所得税 (追加)",{"$nulls":12},{"$f":"SUM(金融​​[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"その他の債務",{"v":32,"d":"¥32.00"},{"v":34,"d":"¥34.00"},{"v":1,"d":"¥1.00"},{"$nulls":9},{"$f":"SUM(金融​​[[#This Row],[1 月]:[12 月]])","v":{"v":67,"d":"¥67.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,金融​​[1 月])","v":{"v":177,"d":"¥177.00"}},{"$f":"SUBTOTAL(109,金融​​[2 月])","v":{"v":179,"d":"¥179.00"}},{"$f":"SUBTOTAL(109,金融​​[3 月])","v":{"v":146,"d":"¥146.00"}},{"$f":"SUBTOTAL(109,金融​​[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,金融​​[年度])","v":{"v":502,"d":"¥502.00"}}]
[]
["セル C97 から順に、雑費を入力します。次の指示はセル A105 に表示されます。",null,"雑支払","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年","スパークライン"]
[null,null,"その他",{"$nulls":12},{"$f":"SUM(雑費[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"その他",{"$nulls":12},{"$f":"SUM(雑費[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"その他",{"$nulls":12},{"$f":"SUM(雑費[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"その他",{"$nulls":12},{"$f":"SUM(雑費[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"その他",{"$nulls":12},{"$f":"SUM(雑費[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,雑費[1 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[2 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[3 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[年])","v":{"v":0,"d":"¥0.00"}}]
[]
["セル C105 から始まるテーブルで合計が自動計算されます。毎月と年間に対して、支出合計と現金の不足または余剰が計算され、スパークラインが更新されます。",null,"合計","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年","スパークライン"]
[null,null,"支出合計",{"$f":"SUM(雑費[[#Totals],[1 月]],金融​​[[#Totals],[1 月]],個人[[#Totals],[1 月]],会費と購読料[[#Totals],[1 月]],レクリエーション[[#Totals],[1 月]],休暇[[#Totals],[1 月]],医療保険[[#Totals],[1 月]],娯楽[[#Totals],[1 月]],交通[[#Totals],[1 月]],毎日[[#Totals],[1 月]],自宅[[#Totals],[1 月]])","v":{"v":2687,"d":"¥2,687.00"}},{"$f":"SUM(雑費[[#Totals],[2 月]],金融​​[[#Totals],[2 月]],個人[[#Totals],[2 月]],会費と購読料[[#Totals],[2 月]],レクリエーション[[#Totals],[2 月]],休暇[[#Totals],[2 月]],医療保険[[#Totals],[2 月]],娯楽[[#Totals],[2 月]],交通[[#Totals],[2 月]],毎日[[#Totals],[2 月]],自宅[[#Totals],[2 月]])","v":{"v":3429,"d":"¥3,429.00"}},{"$f":"SUM(雑費[[#Totals],[3 月]],金融​​[[#Totals],[3 月]],個人[[#Totals],[3 月]],会費と購読料[[#Totals],[3 月]],レクリエーション[[#Totals],[3 月]],休暇[[#Totals],[3 月]],医療保険[[#Totals],[3 月]],娯楽[[#Totals],[3 月]],交通[[#Totals],[3 月]],毎日[[#Totals],[3 月]],自宅[[#Totals],[3 月]])","v":{"v":2718,"d":"¥2,718.00"}},{"$f":"SUM(雑費[[#Totals],[4 月]],金融​​[[#Totals],[4 月]],個人[[#Totals],[4 月]],会費と購読料[[#Totals],[4 月]],レクリエーション[[#Totals],[4 月]],休暇[[#Totals],[4 月]],医療保険[[#Totals],[4 月]],娯楽[[#Totals],[4 月]],交通[[#Totals],[4 月]],毎日[[#Totals],[4 月]],自宅[[#Totals],[4 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[5 月]],金融​​[[#Totals],[5 月]],個人[[#Totals],[5 月]],会費と購読料[[#Totals],[5 月]],レクリエーション[[#Totals],[5 月]],休暇[[#Totals],[5 月]],医療保険[[#Totals],[5 月]],娯楽[[#Totals],[5 月]],交通[[#Totals],[5 月]],毎日[[#Totals],[5 月]],自宅[[#Totals],[5 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[6 月]],金融​​[[#Totals],[6 月]],個人[[#Totals],[6 月]],会費と購読料[[#Totals],[6 月]],レクリエーション[[#Totals],[6 月]],休暇[[#Totals],[6 月]],医療保険[[#Totals],[6 月]],娯楽[[#Totals],[6 月]],交通[[#Totals],[6 月]],毎日[[#Totals],[6 月]],自宅[[#Totals],[6 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[7 月]],金融​​[[#Totals],[7 月]],個人[[#Totals],[7 月]],会費と購読料[[#Totals],[7 月]],レクリエーション[[#Totals],[7 月]],休暇[[#Totals],[7 月]],医療保険[[#Totals],[7 月]],娯楽[[#Totals],[7 月]],交通[[#Totals],[7 月]],毎日[[#Totals],[7 月]],自宅[[#Totals],[7 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[8 月]],金融​​[[#Totals],[8 月]],個人[[#Totals],[8 月]],会費と購読料[[#Totals],[8 月]],レクリエーション[[#Totals],[8 月]],休暇[[#Totals],[8 月]],医療保険[[#Totals],[8 月]],娯楽[[#Totals],[8 月]],交通[[#Totals],[8 月]],毎日[[#Totals],[8 月]],自宅[[#Totals],[8 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[9 月]],金融​​[[#Totals],[9 月]],個人[[#Totals],[9 月]],会費と購読料[[#Totals],[9 月]],レクリエーション[[#Totals],[9 月]],休暇[[#Totals],[9 月]],医療保険[[#Totals],[9 月]],娯楽[[#Totals],[9 月]],交通[[#Totals],[9 月]],毎日[[#Totals],[9 月]],自宅[[#Totals],[9 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[10 月]],金融​​[[#Totals],[10 月]],個人[[#Totals],[10 月]],会費と購読料[[#Totals],[10 月]],レクリエーション[[#Totals],[10 月]],休暇[[#Totals],[10 月]],医療保険[[#Totals],[10 月]],娯楽[[#Totals],[10 月]],交通[[#Totals],[10 月]],毎日[[#Totals],[10 月]],自宅[[#Totals],[10 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[11 月]],金融​​[[#Totals],[11 月]],個人[[#Totals],[11 月]],会費と購読料[[#Totals],[11 月]],レクリエーション[[#Totals],[11 月]],休暇[[#Totals],[11 月]],医療保険[[#Totals],[11 月]],娯楽[[#Totals],[11 月]],交通[[#Totals],[11 月]],毎日[[#Totals],[11 月]],自宅[[#Totals],[11 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[12 月]],金融​​[[#Totals],[12 月]],個人[[#Totals],[12 月]],会費と購読料[[#Totals],[12 月]],レクリエーション[[#Totals],[12 月]],休暇[[#Totals],[12 月]],医療保険[[#Totals],[12 月]],娯楽[[#Totals],[12 月]],交通[[#Totals],[12 月]],毎日[[#Totals],[12 月]],自宅[[#Totals],[12 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(雑費[[#Totals],[年]],金融​​[[#Totals],[年度]],個人[[#Totals],[年度]],会費と購読料[[#Totals],[年度]],レクリエーション[[#Totals],[年度]],休暇[[#Totals],[年度]],医療保険[[#Totals],[年度]],娯楽[[#Totals],[年度]],交通[[#Totals],[年度]],毎日[[#Totals],[年度]],自宅[[#Totals],[年]])","v":{"v":8834,"d":"¥8,834.00"}}]
[null,null,"現金の不足/余剰",{"$f":"収入[[#Totals],[1 月]]-D106","v":{"v":1036,"d":"¥1,036.00"}},{"$f":"収入[[#Totals],[2 月]]-E106","v":{"v":127,"d":"¥127.00"}},{"$f":"収入[[#Totals],[3 月]]-F106","v":{"v":926,"d":"¥926.00"}},{"$f":"収入[[#Totals],[4 月]]-G106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[5 月]]-H106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[6 月]]-I106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[7 月]]-J106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[8 月]]-K106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[9 月]]-L106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[10 月]]-M106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[11 月]]-N106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[12 月]]-O106","v":{"v":0,"d":"¥0.00"}},{"$f":"収入[[#Totals],[年]]-P106","v":{"v":2089,"d":"¥2,089.00"}}]