{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["使い方","表","項目別","人別","リスト"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":11,"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":77,"n_cols":1,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["慶弔金管理表の使い方"]
[]
["① 「リスト」シートによく使用する項目を入力する"]
["画面左下、シート見出しの「リスト」をクリックし、「リスト」シートを開いてください。\n●「項目リスト」…慶弔金の種類を入力してください。\n●「あげた（もらった）人リスト」…家族（もしくは同世帯の人）の名前を入力してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["② 「表」シートに入力する"]
["慶弔金が発生したら、日付・項目・家族の誰があげた（もらった）か・金額 等を入力してください。\n※「項目」「あげた（もらった）人」「お返し」欄は、セル右側の▼マークをクリックし、リストから選んでください。\n※「収入」「支出」は半角数字で入力してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["③ 見たい部分だけを検索・抽出しましょう。"]
["「項目別」「人別」シートではそれぞれ、②で入力した表の中から見たい部分だけを検索することができます。（使い方はどちらも同じです。）\n●表上のプルダウンリストから、見たい項目（人名）を選んでください。\n※「項目別」「人別」シートの表を変更しても、「表」シートには反映されません。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["★ 表の行数を増やしたいときは・・・"]
["（１）表の一番下の行を選択します。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["（２）右下に表示される■を、必要な行数分ドラッグしてください。"]

{"sheet":"表","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,4],[0,5,0,6],[1,5,1,6]]}
["慶弔金管理表",null,null,null,null,"★収入合計：",null,{"$f":"SUM(入力テーブル[収入])","v":75000}]
[null,null,null,null,null,"★支出合計：",null,{"$f":"SUM(入力テーブル[支出])","v":10000}]
[]
[]
[]
["日付","項目","あげた（もらった）人","相手","収入","支出","お返し","備考"]
["2012-01-01","お年玉","山田花子","玉津のおばあちゃん",10000,null,"不要"]
[null,"お年玉","山田一郎","玉津のおばあちゃん",10000,null,"不要"]
[null,"お年玉","山田次郎","玉津のおばあちゃん",5000,null,"不要"]
["2012-02-20","進学祝い","山田次郎","小山の叔父さん",50000,null,"済"]
["2012-03-01","出産祝い","お母さん","ともみちゃん",null,10000,null,"お祝い金＋ベビーグッズ3,000円"]

{"sheet":"項目別","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,1,4],[0,5,0,6],[1,5,1,6],[3,0,3,1]]}
["項目別 集計表",null,null,null,null,"★収入合計：",null,{"$f":"SUM(項目別集計テーブル[収入])","v":50000}]
[null,null,null,null,null,"★支出合計：",null,{"$f":"SUM(項目別集計テーブル[支出])","v":0}]
[]
["見たい項目を選びましょう→",null,"進学祝い"]
[]
["日付","項目","あげた（もらった）人","相手","収入","支出","お返し","備考"]
["2012-02-20","進学祝い","山田次郎","小山の叔父さん",50000,null,"済"]

{"sheet":"人別","index":3,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,1,4],[0,5,0,6],[1,5,1,6],[3,0,3,1]]}
["人別 集計表",null,null,null,null,"★収入合計：",null,{"$f":"SUM(人別集計テーブル[収入])","v":0}]
[null,null,null,null,null,"★支出合計：",null,{"$f":"SUM(人別集計テーブル[支出])","v":10000}]
[]
["あげた（もらった）人の名前を選びましょう→",null,"お母さん"]
[]
["日付","項目","あげた（もらった）人","相手","収入","支出","お返し","備考"]
["2012-03-01","出産祝い","お母さん","ともみちゃん",null,10000,null,"お祝い金＋ベビーグッズ3,000円"]

{"sheet":"リスト","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["リスト"]
["★よく使用する「項目」名と「あげた（もらった）人」名を入力してください。"]
["項目",null,"あげた（もらった）人"]
["お年玉",null,"お母さん"]
["入学祝い",null,"お父さん"]
["結婚祝い",null,"山田花子"]
["出産祝い",null,"山田一郎"]
["進学祝い",null,"山田次郎"]
["お見舞金"]
["お香典"]