{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["マクロ代替手順","入力","予算","月次サマリ","年間サマリ","使い方"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"マクロ代替手順","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["マクロ版 = 関数フル装備版"]
["本ファイルは VBA を含まない安全版です。マクロ機能はすべて Excel 関数で代替しています。"]
[]
["代替済マクロ一覧:"]
["1. 「実績自動集計」 → 入力シートに記入するだけで予算シートに SUMIFS で自動反映"]
["2. 「予算超過警告」 → 条件付き書式で実績>予算の行を赤く表示"]
["3. 「カテゴリプルダウン」→ データの入力規則（リスト）で実装"]
["4. 「グラフ自動更新」→ 月次サマリのデータ範囲がテーブル参照で動的更新"]
["5. 「年間繰越」 → 翌月は実績列をコピー → 前月実績列に値貼り付け（5秒）"]
[]
["セキュリティ警告が出ない安全な家計簿です。"]

{"sheet":"入力","index":1,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Excel家計簿 マクロ版（高機能・関数代替）　- 日次入力"]
[]
["対象月","2026/05",null,"予算合計",{"$f":"SUM(予算!D:D)","v":null}]
[]
["No.","日付","カテゴリ","内容","金額","メモ"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[null,null,null,"当月支出合計",{"$f":"SUM(E6:E35)","v":null}]

{"sheet":"予算","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["予算 / 実績 / 差異 / 前月比較"]
[]
["No.","カテゴリ","区分","予算","実績","差異","前月実績"]
[1,"住居費","固定",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B4),0)","v":null},{"$f":"IFERROR(D4-E4,\"\")","v":null}]
[2,"水道光熱費","固定",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B5),0)","v":null},{"$f":"IFERROR(D5-E5,\"\")","v":null}]
[3,"通信費","固定",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B6),0)","v":null},{"$f":"IFERROR(D6-E6,\"\")","v":null}]
[4,"保険料","固定",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B7),0)","v":null},{"$f":"IFERROR(D7-E7,\"\")","v":null}]
[5,"サブスク","固定",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B8),0)","v":null},{"$f":"IFERROR(D8-E8,\"\")","v":null}]
[6,"食費（食料品）","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B9),0)","v":null},{"$f":"IFERROR(D9-E9,\"\")","v":null}]
[7,"食費（外食）","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B10),0)","v":null},{"$f":"IFERROR(D10-E10,\"\")","v":null}]
[8,"日用品","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B11),0)","v":null},{"$f":"IFERROR(D11-E11,\"\")","v":null}]
[9,"衣服・美容","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B12),0)","v":null},{"$f":"IFERROR(D12-E12,\"\")","v":null}]
[10,"交通費","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B13),0)","v":null},{"$f":"IFERROR(D13-E13,\"\")","v":null}]
[11,"交際費","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B14),0)","v":null},{"$f":"IFERROR(D14-E14,\"\")","v":null}]
[12,"医療費","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B15),0)","v":null},{"$f":"IFERROR(D15-E15,\"\")","v":null}]
[13,"教育費","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B16),0)","v":null},{"$f":"IFERROR(D16-E16,\"\")","v":null}]
[14,"娯楽・趣味","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B17),0)","v":null},{"$f":"IFERROR(D17-E17,\"\")","v":null}]
[15,"車両関連","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B18),0)","v":null},{"$f":"IFERROR(D18-E18,\"\")","v":null}]
[16,"家具・家電","臨時",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B19),0)","v":null},{"$f":"IFERROR(D19-E19,\"\")","v":null}]
[17,"旅行","臨時",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B20),0)","v":null},{"$f":"IFERROR(D20-E20,\"\")","v":null}]
[18,"冠婚葬祭","臨時",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B21),0)","v":null},{"$f":"IFERROR(D21-E21,\"\")","v":null}]
[19,"ペット関連","変動",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B22),0)","v":null},{"$f":"IFERROR(D22-E22,\"\")","v":null}]
[20,"その他","その他",null,{"$f":"IFERROR(SUMIFS(入力!E:E,入力!C:C,B23),0)","v":null},{"$f":"IFERROR(D23-E23,\"\")","v":null}]
[null,"合計",null,{"$f":"SUM(D4:D23)","v":null},{"$f":"SUM(E4:E23)","v":null},{"$f":"SUM(F4:F23)","v":null},{"$f":"SUM(G4:G23)","v":null}]

{"sheet":"月次サマリ","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["支出カテゴリ別 構成比"]
[]
["カテゴリ","実績","構成比"]
["住居費",{"$f":"予算!E4","v":null},{"$f":"IFERROR(B4/SUM($B$4:$B$23),0)","v":null}]
["水道光熱費",{"$f":"予算!E5","v":null},{"$f":"IFERROR(B5/SUM($B$4:$B$23),0)","v":null}]
["通信費",{"$f":"予算!E6","v":null},{"$f":"IFERROR(B6/SUM($B$4:$B$23),0)","v":null}]
["保険料",{"$f":"予算!E7","v":null},{"$f":"IFERROR(B7/SUM($B$4:$B$23),0)","v":null}]
["サブスク",{"$f":"予算!E8","v":null},{"$f":"IFERROR(B8/SUM($B$4:$B$23),0)","v":null}]
["食費（食料品）",{"$f":"予算!E9","v":null},{"$f":"IFERROR(B9/SUM($B$4:$B$23),0)","v":null}]
["食費（外食）",{"$f":"予算!E10","v":null},{"$f":"IFERROR(B10/SUM($B$4:$B$23),0)","v":null}]
["日用品",{"$f":"予算!E11","v":null},{"$f":"IFERROR(B11/SUM($B$4:$B$23),0)","v":null}]
["衣服・美容",{"$f":"予算!E12","v":null},{"$f":"IFERROR(B12/SUM($B$4:$B$23),0)","v":null}]
["交通費",{"$f":"予算!E13","v":null},{"$f":"IFERROR(B13/SUM($B$4:$B$23),0)","v":null}]
["交際費",{"$f":"予算!E14","v":null},{"$f":"IFERROR(B14/SUM($B$4:$B$23),0)","v":null}]
["医療費",{"$f":"予算!E15","v":null},{"$f":"IFERROR(B15/SUM($B$4:$B$23),0)","v":null}]
["教育費",{"$f":"予算!E16","v":null},{"$f":"IFERROR(B16/SUM($B$4:$B$23),0)","v":null}]
["娯楽・趣味",{"$f":"予算!E17","v":null},{"$f":"IFERROR(B17/SUM($B$4:$B$23),0)","v":null}]
["車両関連",{"$f":"予算!E18","v":null},{"$f":"IFERROR(B18/SUM($B$4:$B$23),0)","v":null}]
["家具・家電",{"$f":"予算!E19","v":null},{"$f":"IFERROR(B19/SUM($B$4:$B$23),0)","v":null}]
["旅行",{"$f":"予算!E20","v":null},{"$f":"IFERROR(B20/SUM($B$4:$B$23),0)","v":null}]
["冠婚葬祭",{"$f":"予算!E21","v":null},{"$f":"IFERROR(B21/SUM($B$4:$B$23),0)","v":null}]
["ペット関連",{"$f":"予算!E22","v":null},{"$f":"IFERROR(B22/SUM($B$4:$B$23),0)","v":null}]
["その他",{"$f":"予算!E23","v":null},{"$f":"IFERROR(B23/SUM($B$4:$B$23),0)","v":null}]

{"sheet":"年間サマリ","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["年間サマリ（12ヶ月）"]
[]
["項目","4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月","年間合計"]
["収入合計",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:M4)","v":null}]
["固定費",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B5:M5)","v":null}]
["変動費",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B6:M6)","v":null}]
["臨時支出",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B7:M7)","v":null}]
["支出合計",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B8:M8)","v":null}]
["収支差額",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B9:M9)","v":null}]

{"sheet":"使い方","index":5,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Excel家計簿 マクロ版（高機能・関数代替）　使い方"]
[]
["1. 入力シート: 日付・カテゴリ・金額をその場で入力。No.は連番です。"]
["2. 予算シート: 各カテゴリの予算を入力。実績はSUMIFSで自動集計されます。"]
["3. 月次サマリ: 円グラフで支出構成が一目で確認できます。"]
["4. 年間サマリ: 12ヶ月分の収支推移を折れ線グラフで把握できます。"]
[]
["【予算超過のサイン】"]
["予算より実績が大きいカテゴリは行全体が赤くハイライトされます。"]
["「条件付き書式」で自動判定しているため、手動操作は不要です。"]
[]
["【前月比較の使い方】"]
["予算シートG列に前月実績を手入力すれば、差異が見えます。"]
["翌月へ進めるときは「実績→前月実績」へコピー&ペーストして使ってください。"]
[]
["【ピボット連動】"]
["入力シートのデータ範囲を選択 → 「挿入 → ピボットテーブル」で"]
["カテゴリ別/日付別の好きな切り口で集計できます。"]