{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["ダッシュボード","支出および収入","収支レポート","データ リスト","項目ピボットテーブル"],"not_rendered":{"charts":3,"defined_names":18,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"ダッシュボード","index":0,"n_rows":21,"n_cols":16,"rows_kept":21,"merged":[[5,2,5,3]]}
[]
[null,null,"半月ごとの家計簿",{"$nulls":12},"ダッシュボード"]
[]
[]
[]
[null,null,{"$f":"CHOOSE(月番号,\"1 月\",\"2 月\",\".3 月\",\"4 月\",\"5 月\",\"6 月\",\"7 月\",\"8 月\",\"9 月\",\"10 月\",\"11 月\",\"12 月\")","v":"8 月"},null,8,{"$nulls":5},2012]
[]
[]
[null,null,"月間合計","月間合計",{"$nulls":5},"年間合計",null,"年間合計"]
[null,null,"収入","支出",{"$f":"SUMIF(支出[日付],\"<=\"&終了した日月,支出[金額])-SUMIF(支出[日付],\"<\"&開始した日月,支出[金額])","v":{"v":0,"d":"$0"}},{"$nulls":4},"収入",null,"支出",{"$f":"SUM(IF(YEAR(支出[日付])=K6,支出[金額]))","v":{"v":881200,"d":"¥881,200"}}]
[null,null,"支出","収入",{"$f":"SUMIF(収入[日付],\"<=\"&終了した日月,収入[金額])-SUMIF(収入[日付],\"<\"&開始した日月,収入[金額])","v":{"v":0,"d":"$0"}},{"$nulls":4},"支出",null,"収入",{"$f":"SUM(IF(YEAR(収入[日付])=K6,収入[金額]))","v":{"v":1270000,"d":"¥1,270,000"}}]
[]
[]
[]
[]
[]
[{"$nulls":3},"1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月"]
[null,null,"収入 1 ～ 15 日",{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&中間日,収入[説明],\">=\"&開始日)","v":{"v":0,"d":"¥0"}}]
[null,null,"収入 16 日 ～ 月末",{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(収入[金額],収入[説明],\"<=\"&終了日,収入[説明],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}}]
[null,null,"支出 1 ～ 15 日",{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&中間日,支出[日付],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":112500,"d":"¥112,500"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":545000,"d":"¥545,000"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":213700,"d":"¥213,700"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&開始日)","v":{"v":143000,"d":"¥143,000"}}]
[null,null,"支出 16 日 ～ 月末",{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":112500,"d":"¥112,500"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":535000,"d":"¥535,000"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":136200,"d":"¥136,200"}},{"$f":"SUMIFS(支出[金額],支出[日付],\"<=\"&終了日,支出[日付],\">=\"&中間日+1)","v":{"v":0,"d":"¥0"}}]

{"sheet":"支出および収入","index":1,"n_rows":40,"n_cols":10,"rows_kept":40}
[]
[null,null,"半月ごとの家計簿",{"$nulls":6},"収入と支出"]
[]
[]
[]
[null,null,"収入",{"$nulls":3},"支出"]
[]
[null,null,"日付","説明","金額",null,"日付","項目","説明","金額"]
[null,null,{"$f":"NOW()-14","v":"2012-12-25T17:34:14.440"},"義弘の給与",{"v":130000,"d":"¥130,000"},null,{"$f":"NOW()-7","v":"2013-01-01T17:34:14.440"},"家計費","住宅ローン",{"v":100000,"d":"¥100,000"}]
[null,null,{"$f":"NOW()-14","v":"2012-12-25T17:34:14.440"},"久明の給与",{"v":130000,"d":"¥130,000"},null,{"$f":"NOW()-7","v":"2013-01-01T17:34:14.440"},"家計費","電気",{"v":10000,"d":"¥10,000"}]
[null,null,{"$f":"NOW()-28","v":"2012-12-11T17:34:14.440"},"義弘の給与",{"v":150000,"d":"¥150,000"},null,"2013-01-01T17:34:14.440","家計費","水道",{"v":5000,"d":"¥5,000"}]
[null,null,"2012-12-11T17:34:14.440","久明の給与",{"v":160000,"d":"¥160,000"},null,"2013-01-01T17:34:14.440","家計費","ゴミ",{"v":2500,"d":"¥2,500"}]
[null,null,{"$f":"NOW()-42","v":"2012-11-27T17:34:14.440"},"義弘の給与",{"v":130000,"d":"¥130,000"},null,"2013-01-01T17:34:14.440","家計費","携帯電話",{"v":10000,"d":"¥10,000"}]
[null,null,"2012-11-27T17:34:14.440","久明の給与",{"v":130000,"d":"¥130,000"},null,"2013-01-01T17:34:14.440","家計費","自宅電話",{"v":3000,"d":"¥3,000"}]
[null,null,{"$f":"NOW()-56","v":"2012-11-13T17:34:14.440"},"義弘の給与",{"v":150000,"d":"¥150,000"},null,"2013-01-01T17:34:14.440","家計費","インターネット",{"v":5000,"d":"¥5,000"}]
[null,null,"2012-11-13T17:34:14.440","久明の給与",{"v":160000,"d":"¥160,000"},null,"2013-01-01T17:34:14.440","家計費","テレビ",{"v":5000,"d":"¥5,000"}]
[null,null,{"$f":"NOW()-70","v":"2012-10-30T17:34:14.440"},"義弘の給与",{"v":130000,"d":"¥130,000"},null,"2013-01-01T17:34:14.440","家計費","メンテナンス/修理",{"v":2500,"d":"¥2,500"}]
[{"$nulls":6},{"$f":"NOW()-8","v":"2012-12-31T17:34:14.440"},"家計費","クレジット カード 1 ",{"v":10000,"d":"¥10,000"}]
[{"$nulls":6},{"$f":"NOW()-9","v":"2012-12-30T17:34:14.440"},"娯楽費","映画",{"v":3700,"d":"¥3,700"}]
[{"$nulls":6},{"$f":"NOW()-10","v":"2012-12-29T17:34:14.440"},"食費","食料品",{"v":35000,"d":"¥35,000"}]
[{"$nulls":6},{"$f":"NOW()-11","v":"2012-12-28T17:34:14.440"},"食費","外食",{"v":7500,"d":"¥7,500"}]
[{"$nulls":6},{"$f":"NOW()-12","v":"2012-12-27T17:34:14.440"},"養育費","昼食費",{"v":15000,"d":"¥15,000"}]
[{"$nulls":6},{"$f":"NOW()-13","v":"2012-12-26T17:34:14.440"},"投資口座","貯蓄",{"v":25000,"d":"¥25,000"}]
[{"$nulls":6},{"$f":"NOW()-14","v":"2012-12-25T17:34:14.440"},"投資口座","投資口座",{"v":25000,"d":"¥25,000"}]
[{"$nulls":6},{"$f":"NOW()-15","v":"2012-12-24T17:34:14.440"},"個人用","健康/フィットネス クラブ",{"v":10000,"d":"¥10,000"}]
[{"$nulls":6},{"$f":"NOW()-16","v":"2012-12-23T17:34:14.440"},"ペット費用","食費",{"v":5000,"d":"¥5,000"}]
[{"$nulls":6},{"$f":"NOW()-20","v":"2012-12-19T17:34:14.440"},"ペット費用","グルーミング",{"v":5000,"d":"¥5,000"}]
[{"$nulls":6},{"$f":"NOW()-20","v":"2012-12-19T17:34:14.440"},"ペット費用","その他",{"v":5000,"d":"¥5,000"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-12-14T17:34:14.440"},"交通費","車 1 の支払い ",{"v":30000,"d":"¥30,000"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-12-14T17:34:14.440"},"交通費","車 2 の支払い",{"v":35000,"d":"¥35,000"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-12-14T17:34:14.440"},"交通費","自動車保険",{"v":5000,"d":"¥5,000"}]
[{"$nulls":6},{"$f":"NOW()-30","v":"2012-12-09T17:34:14.440"},"交通費","燃料費",{"v":5000,"d":"¥5,000"}]
[{"$nulls":6},{"$f":"NOW()-31","v":"2012-12-08T17:34:14.440"},"交通費","燃料費",{"v":2500,"d":"¥2,500"}]
[{"$nulls":6},{"$f":"NOW()-42","v":"2012-11-27T17:34:14.440"},"交通費","メンテナンス/修理",{"v":15000,"d":"¥15,000"}]
[{"$nulls":6},{"$f":"NOW()-45","v":"2012-11-24T17:34:14.440"},"家計費","住宅ローン",{"v":500000,"d":"¥500,000"}]
[{"$nulls":6},{"$f":"NOW()-50","v":"2012-11-19T17:34:14.440"},"家計費","備品/用品",{"v":20000,"d":"¥20,000"}]
[{"$nulls":6},{"$f":"NOW()-65","v":"2012-11-04T17:34:14.440"},"家計費","自宅電話",{"v":10000,"d":"¥10,000"}]
[{"$nulls":6},{"$f":"NOW()-70","v":"2012-10-30T17:34:14.440"},"家計費","ゴミ",{"v":5000,"d":"¥5,000"}]
[{"$nulls":6},{"$f":"NOW()-75","v":"2012-10-25T17:34:14.440"},"家計費","住宅ローン",{"v":100000,"d":"¥100,000"}]
[{"$nulls":6},{"$f":"NOW()-78","v":"2012-10-22T17:34:14.440"},"娯楽費","映画",{"v":7500,"d":"¥7,500"}]

{"sheet":"収支レポート","index":2,"n_rows":41,"n_cols":8,"rows_kept":41}
[]
[null,null,"半月ごとの家計簿",{"$nulls":4},"収支レポート"]
{"$rows_empty":10}
[null,null,"支出",null,null,"項目の合計"]
[]
[null,null,"説明","合計 / 金額"]
[null,null,"車 1 の支払い ",{"v":30000,"d":"¥30,000"}]
[null,null,"車 2 の支払い",{"v":35000,"d":"¥35,000"}]
[null,null,"自動車保険",{"v":5000,"d":"¥5,000"}]
[null,null,"携帯電話",{"v":10000,"d":"¥10,000"}]
[null,null,"クレジット カード 1 ",{"v":10000,"d":"¥10,000"}]
[null,null,"外食",{"v":7500,"d":"¥7,500"}]
[null,null,"電気",{"v":10000,"d":"¥10,000"}]
[null,null,"燃料費",{"v":7500,"d":"¥7,500"}]
[null,null,"ゴミ",{"v":7500,"d":"¥7,500"}]
[null,null,"食料品",{"v":35000,"d":"¥35,000"}]
[null,null,"グルーミング",{"v":5000,"d":"¥5,000"}]
[null,null,"健康/フィットネス クラブ",{"v":10000,"d":"¥10,000"}]
[null,null,"自宅電話",{"v":13000,"d":"¥13,000"}]
[null,null,"インターネット",{"v":5000,"d":"¥5,000"}]
[null,null,"投資口座",{"v":25000,"d":"¥25,000"}]
[null,null,"昼食費",{"v":15000,"d":"¥15,000"}]
[null,null,"メンテナンス/修理",{"v":17500,"d":"¥17,500"}]
[null,null,"住宅ローン",{"v":700000,"d":"¥700,000"}]
[null,null,"映画",{"v":11200,"d":"¥11,200"}]
[null,null,"その他",{"v":5000,"d":"¥5,000"}]
[null,null,"貯蓄",{"v":25000,"d":"¥25,000"}]
[null,null,"テレビ",{"v":5000,"d":"¥5,000"}]
[null,null,"食費",{"v":5000,"d":"¥5,000"}]
[null,null,"備品/用品",{"v":20000,"d":"¥20,000"}]
[null,null,"水道",{"v":5000,"d":"¥5,000"}]
[null,null,"合計",{"v":1024200,"d":"¥1,024,200"}]

{"sheet":"データ リスト","index":3,"n_rows":20,"n_cols":14,"rows_kept":20}
[]
[null,null,"半月ごとの家計簿",{"$nulls":10},"データ リスト"]
[]
[]
[null,null,"設定         下記の項目データは、支出および収入シートの支出の表のドロップ ダウン リストに表示されます。一覧を更新するには、項目名または各項目の下にある説明を変更してください。"]
[]
[null,null,"家計費","娯楽費","食費","ギフト/寄付","養育費","投資口座","医療","その他","個人用","ペット費用","税金/弁護士費用","交通費"]
[null,null,"住宅ローン","映画","食料品","寄付 1","衣服","個人年金口座","診療費","その他","服飾費","食費","国税","車 1 の支払い "]
[null,null,"電気","ビデオ/映画","外食","寄付 2","玩具/ゲーム","貯蓄","保険料","会費","美容院/ネイル サロン","備品/用品","都道府県税","車 2 の支払い"]
[null,null,"水道","音楽",null,"寄付 3","昼食費","当座",null,null,"ドライ クリーニング","医療","地方税","自動車保険"]
[null,null,"ゴミ","コンサート/観劇",null,"ギフト","会費/手数料","退職金",null,null,"健康/フィットネス クラブ","グルーミング","その他","免許証/登録"]
[null,null,"携帯電話","スポーツ イベント",null,null,"学用品","投資口座",null,null,"ショッピング","その他","弁護士","燃料費"]
[null,null,"自宅電話","その他",null,null,"その他","大学",null,null,"その他",null,"養育費","メンテナンス/修理"]
[null,null,"インターネット",{"$nulls":3},"洗濯","借入金",{"$nulls":4},"慰謝料","公共輸送"]
[null,null,"テレビ",{"$nulls":4},"学生ローン",{"$nulls":4},"その他"]
[null,null,"メンテナンス/修理"]
[null,null,"備品/用品"]
[null,null,"ケーブル/インターネット/電話"]
[null,null,"クレジット カード 1 "]
[null,null,"クレジット カード 2 "]

{"sheet":"項目ピボットテーブル","index":4,"n_rows":16,"n_cols":14,"rows_kept":16,"hidden":true}
[]
[null,null,"半月ごとの家計簿",{"$nulls":10},"項目のピボット"]
[]
[]
[null,"このピボット テーブルは収支レポートの項目の合計ピボット グラフのデータ ソースとなります。 "]
[]
[null,null,"行ラベル","合計 / 金額"]
[null,null,"ペット費用",{"v":15000,"d":"¥15,000"}]
[null,null,"娯楽費",{"v":11200,"d":"¥11,200"}]
[null,null,"食費",{"v":42500,"d":"¥42,500"}]
[null,null,"家計費",{"v":788000,"d":"¥788,000"}]
[null,null,"投資口座",{"v":50000,"d":"¥50,000"}]
[null,null,"個人用",{"v":10000,"d":"¥10,000"}]
[null,null,"養育費",{"v":15000,"d":"¥15,000"}]
[null,null,"交通費",{"v":92500,"d":"¥92,500"}]
[null,null,"総計",{"v":1024200,"d":"¥1,024,200"}]