{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["ヒント","サマリー","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月"],"not_rendered":{"charts":1,"defined_names":27},"read":"whole","date_system":"1900"}

{"sheet":"ヒント","index":0,"n_rows":18,"n_cols":1,"rows_kept":18}
["テンプレートのヒント"]
["[支出の推移] サマリー シートと月々の支出の詳細を簡単に切り替える方法はありますか?"]
["特定の月の支出にすばやく移動するには、B2 の 1 月ナビゲーション リンクなど、グラフ上部にある関連付けられたナビゲーション リンクをクリックします。次に、[支出の推移] ワークシートに戻り、[サマリー] ナビゲーション リンク (D1) をクリックします。 "]
["このヒントのワークシートに戻るには、サマリー ワークシートで N2 を選択します。月々のワークシートから [ヒント] のワークシートに戻るには、E1 を選択します。"]
["新しい品目の [支出] を [支出サマリー] または新しい月々の支出に追加するには、どうすればいいですか?"]
["グラフ下の [支出サマリー] と各月の支出の詳細は、Excel の表で作成されています。新しい行を Excel の表に追加するには、次のいずれかの操作を行います。"]
[{"$f":"ROW(A1)&\". テーブルに集計行がない場合は、テーブルの下に入力を開始して Enter キーまたは Tab キーを押すと、自動的に拡張されます。\"","v":"1. テーブルに集計行がない場合は、テーブルの下に入力を開始して Enter キーまたは Tab キーを押すと、自動的に拡張されます。"}]
[{"$f":"ROW(A2)&\". セルのポインターを集計行の上の最後のセル (最後の支出の合計など) に合わせ、Tab キーを押します。\"","v":"2. セルのポインターを集計行の上の最後のセル (最後の支出の合計など) に合わせ、Tab キーを押します。"}]
[{"$f":"ROW(A3)&\". テーブルを右クリックし、ポップアップ メニューで [挿入] をポイントし、[上に行を挿入] または [下に行を挿入] をクリックします。\"","v":"3. テーブルを右クリックし、ポップアップ メニューで [挿入] をポイントし、[上に行を挿入] または [下に行を挿入] をクリックします。"}]
[{"$f":"ROW(A4)&\". テーブルの右下隅のテーブルのサイズ変更ハンドルにマウスを合わせて下にドラッグし、必要な数だけテーブルの行を増やします。\"","v":"4. テーブルの右下隅のテーブルのサイズ変更ハンドルにマウスを合わせて下にドラッグし、必要な数だけテーブルの行を増やします。"}]
["[サマリー]  ワークシート ([ExpenseSummary] テーブルの [支出] 列) に支出を入力します。"]
["支出が発生する月のワークシートで、支出の種類ごとに支出金額を追加します。"]
["例:\"支出 1\" は、1 月から 6 月までの間と 12 月に発生しました。 "]
[{"$f":"ROW(A1)&\". [支出 1] を [概要] ワークシートの [支出の概要] テーブルの [支出] の下に入力します (支出の種類のタイトルになります)。\"","v":"1. [支出 1] を [概要] ワークシートの [支出の概要] テーブルの [支出] の下に入力します (支出の種類のタイトルになります)。"}]
[{"$f":"ROW(A2)&\". 各月で支出が発生するたびに、該当する月のワークシートに支出の金額を入力します。\"","v":"2. 各月で支出が発生するたびに、該当する月のワークシートに支出の金額を入力します。"}]
[{"$f":"ROW(A3)&\". [支出の概要] ワークシートの支出の種類から、各月のワークシートの [カテゴリ] 列のカテゴリ リストが作成されます。\"","v":"3. [支出の概要] ワークシートの支出の種類から、各月のワークシートの [カテゴリ] 列のカテゴリ リストが作成されます。"}]
[{"$f":"ROW(A4)&\". [カテゴリ] 列のカテゴリ リストを使用して、入力された支出金額に対応する支出の種類を選択します。\"","v":"4. [カテゴリ] 列のカテゴリ リストを使用して、入力された支出金額に対応する支出の種類を選択します。"}]
[{"$f":"ROW(A5)&\". 月に新しい支出を追加するには、新しい行を [概要] ワークシートの [支出の概要] テーブルに追加し、適用する月のワークシートに対応する支出の詳細を入力します。\"","v":"5. 月に新しい支出を追加するには、新しい行を [概要] ワークシートの [支出の概要] テーブルに追加し、適用する月のワークシートに対応する支出の詳細を入力します。"}]

{"sheet":"サマリー","index":1,"n_rows":10,"n_cols":15,"rows_kept":10}
["支出の推移"]
[null,"1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","ヒント"]
[]
["支出","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","合計","推移"]
["支出 1",{"$f":"SUMIFS(ExpJan[金額],ExpJan[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":33,"d":"33.00"}},{"$f":"SUMIFS(ExpFeb[金額],ExpFeb[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":375,"d":"375.00"}},{"$f":"SUMIFS(ExpMar[金額],ExpMar[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":33,"d":"33.00"}},{"$f":"SUMIFS(ExpApr[金額],ExpApr[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":45,"d":"45.00"}},{"$f":"SUMIFS(ExpMay[金額],ExpMay[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":375,"d":"375.00"}},{"$f":"SUMIFS(ExpJun[金額],ExpJun[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":201,"d":"201.00"}},{"$f":"SUMIFS(ExpJul[金額],ExpJul[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpAug[金額],ExpAug[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpSep[金額],ExpSep[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpOct[金額],ExpOct[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpNov[金額],ExpNov[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpDec[金額],ExpDec[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":201,"d":"201.00"}},{"$f":"SUM(ExpenseSummary[[#This Row],[1 月]:[12 月]])","v":{"v":1263,"d":"1,263.00"}}]
["支出 2",{"$f":"SUMIFS(ExpJan[金額],ExpJan[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":238,"d":"238.00"}},{"$f":"SUMIFS(ExpFeb[金額],ExpFeb[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":238,"d":"238.00"}},{"$f":"SUMIFS(ExpMar[金額],ExpMar[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":238,"d":"238.00"}},{"$f":"SUMIFS(ExpApr[金額],ExpApr[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":123,"d":"123.00"}},{"$f":"SUMIFS(ExpMay[金額],ExpMay[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":111,"d":"111.00"}},{"$f":"SUMIFS(ExpJun[金額],ExpJun[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":98,"d":"98.00"}},{"$f":"SUMIFS(ExpJul[金額],ExpJul[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpAug[金額],ExpAug[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpSep[金額],ExpSep[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpOct[金額],ExpOct[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpNov[金額],ExpNov[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpDec[金額],ExpDec[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":440,"d":"440.00"}},{"$f":"SUM(ExpenseSummary[[#This Row],[1 月]:[12 月]])","v":{"v":1486,"d":"1,486.00"}}]
["支出 3",{"$f":"SUMIFS(ExpJan[金額],ExpJan[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":110,"d":"110.00"}},{"$f":"SUMIFS(ExpFeb[金額],ExpFeb[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":110,"d":"110.00"}},{"$f":"SUMIFS(ExpMar[金額],ExpMar[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":110,"d":"110.00"}},{"$f":"SUMIFS(ExpApr[金額],ExpApr[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":125,"d":"125.00"}},{"$f":"SUMIFS(ExpMay[金額],ExpMay[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":333,"d":"333.00"}},{"$f":"SUMIFS(ExpJun[金額],ExpJun[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":122,"d":"122.00"}},{"$f":"SUMIFS(ExpJul[金額],ExpJul[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpAug[金額],ExpAug[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpSep[金額],ExpSep[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpOct[金額],ExpOct[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpNov[金額],ExpNov[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpDec[金額],ExpDec[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":122,"d":"122.00"}},{"$f":"SUM(ExpenseSummary[[#This Row],[1 月]:[12 月]])","v":{"v":1032,"d":"1,032.00"}}]
["支出 4",{"$f":"SUMIFS(ExpJan[金額],ExpJan[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":426,"d":"426.00"}},{"$f":"SUMIFS(ExpFeb[金額],ExpFeb[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":84,"d":"84.00"}},{"$f":"SUMIFS(ExpMar[金額],ExpMar[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":84,"d":"84.00"}},{"$f":"SUMIFS(ExpApr[金額],ExpApr[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":426,"d":"426.00"}},{"$f":"SUMIFS(ExpMay[金額],ExpMay[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":125,"d":"125.00"}},{"$f":"SUMIFS(ExpJun[金額],ExpJun[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":187,"d":"187.00"}},{"$f":"SUMIFS(ExpJul[金額],ExpJul[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpAug[金額],ExpAug[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpSep[金額],ExpSep[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpOct[金額],ExpOct[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpNov[金額],ExpNov[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpDec[金額],ExpDec[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":187,"d":"187.00"}},{"$f":"SUM(ExpenseSummary[[#This Row],[1 月]:[12 月]])","v":{"v":1519,"d":"1,519.00"}}]
["支出 5",{"$f":"SUMIFS(ExpJan[金額],ExpJan[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":54,"d":"54.00"}},{"$f":"SUMIFS(ExpFeb[金額],ExpFeb[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":54,"d":"54.00"}},{"$f":"SUMIFS(ExpMar[金額],ExpMar[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":109,"d":"109.00"}},{"$f":"SUMIFS(ExpApr[金額],ExpApr[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":98,"d":"98.00"}},{"$f":"SUMIFS(ExpMay[金額],ExpMay[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":33,"d":"33.00"}},{"$f":"SUMIFS(ExpJun[金額],ExpJun[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":441,"d":"441.00"}},{"$f":"SUMIFS(ExpJul[金額],ExpJul[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpAug[金額],ExpAug[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpSep[金額],ExpSep[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpOct[金額],ExpOct[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpNov[金額],ExpNov[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(ExpDec[金額],ExpDec[カテゴリ],ExpenseSummary[[#This Row],[支出]])","v":{"v":99,"d":"99.00"}},{"$f":"SUM(ExpenseSummary[[#This Row],[1 月]:[12 月]])","v":{"v":888,"d":"888.00"}}]
["合計",{"$f":"SUBTOTAL(109,ExpenseSummary[1 月])","v":{"v":861,"d":"861.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[2 月])","v":{"v":861,"d":"861.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[3 月])","v":{"v":574,"d":"574.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[4 月])","v":{"v":817,"d":"817.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[5 月])","v":{"v":977,"d":"977.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[6 月])","v":{"v":1049,"d":"1,049.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[7 月])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[8 月])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[9 月])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[10 月])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[11 月])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[12 月])","v":{"v":1049,"d":"1,049.00"}},{"$f":"SUBTOTAL(109,ExpenseSummary[合計])","v":{"v":6188,"d":"6,188.00"}}]

{"sheet":"1 月","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["1 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),1,4)","v":"2016-01-04"},"A-12345",{"v":33,"d":"33.00"},"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),1,5)","v":"2016-01-05"},"A-12346",{"v":238,"d":"238.00"},"支出 2"]
[null,null,{"v":342,"d":"342.00"},"支出 4"]
[null,null,{"v":110,"d":"110.00"},"支出 3"]
[null,null,{"v":84,"d":"84.00"},"支出 4"]
[null,null,{"v":54,"d":"54.00"},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpJan[金額])","v":{"v":861,"d":"861.00"}}]

{"sheet":"2 月","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["2 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),2,3)","v":"2016-02-03"},"A-12345",{"v":33,"d":"33.00"},"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2016-02-04"},"A-12346",{"v":238,"d":"238.00"},"支出 2"]
[null,null,{"v":342,"d":"342.00"},"支出 1"]
[null,null,{"v":110,"d":"110.00"},"支出 3"]
[null,null,{"v":84,"d":"84.00"},"支出 4"]
[null,null,{"v":54,"d":"54.00"},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpFeb[金額])","v":{"v":861,"d":"861.00"}}]

{"sheet":"3 月","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["3 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),3,5)","v":"2016-03-05"},"A-12345",{"v":33,"d":"33.00"},"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2016-03-06"},"A-12346",{"v":238,"d":"238.00"},"支出 2"]
[null,null,{"v":55,"d":"55.00"},"支出 5"]
[null,null,{"v":110,"d":"110.00"},"支出 3"]
[null,null,{"v":84,"d":"84.00"},"支出 4"]
[null,null,{"v":54,"d":"54.00"},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpMar[金額])","v":{"v":574,"d":"574.00"}}]

{"sheet":"4 月","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["4 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2016-04-04"},"A-12345",{"v":45,"d":"45.00"},"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),4,8)","v":"2016-04-08"},"A-12346",{"v":123,"d":"123.00"},"支出 2"]
[null,null,{"v":342,"d":"342.00"},"支出 4"]
[null,null,{"v":125,"d":"125.00"},"支出 3"]
[null,null,{"v":84,"d":"84.00"},"支出 4"]
[null,null,{"v":98,"d":"98.00"},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpApr[金額])","v":{"v":817,"d":"817.00"}}]

{"sheet":"5 月","index":6,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["5 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),5,3)","v":"2016-05-03"},"A-12345",{"v":33,"d":"33.00"},"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),5,8)","v":"2016-05-08"},"A-12346",{"v":111,"d":"111.00"},"支出 2"]
[null,null,{"v":342,"d":"342.00"},"支出 1"]
[null,null,{"v":333,"d":"333.00"},"支出 3"]
[null,null,{"v":125,"d":"125.00"},"支出 4"]
[null,null,{"v":33,"d":"33.00"},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpMay[金額])","v":{"v":977,"d":"977.00"}}]

{"sheet":"6 月","index":7,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["6 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),6,7)","v":"2016-06-07"},"A-12345",{"v":201,"d":"201.00"},"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),6,8)","v":"2016-06-08"},"A-12346",{"v":98,"d":"98.00"},"支出 2"]
[null,null,{"v":342,"d":"342.00"},"支出 5"]
[null,null,{"v":122,"d":"122.00"},"支出 3"]
[null,null,{"v":187,"d":"187.00"},"支出 4"]
[null,null,{"v":99,"d":"99.00"},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpJun[金額])","v":{"v":1049,"d":"1,049.00"}}]

{"sheet":"7 月","index":8,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["7 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),7,9)","v":"2016-07-09"},"A-12345",null,"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),7,14)","v":"2016-07-14"},"A-12346",null,"支出 2"]
[{"$nulls":3},"支出 2"]
[{"$nulls":3},"支出 3"]
[{"$nulls":3},"支出 4"]
[{"$nulls":3},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpJul[金額])","v":{"v":0,"d":"0.00"}}]

{"sheet":"8 月","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["8 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),8,8)","v":"2016-08-08"},"A-12345",null,"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),8,9)","v":"2016-08-09"},"A-12346",null,"支出 2"]
[{"$nulls":3},"支出 2"]
[{"$nulls":3},"支出 3"]
[{"$nulls":3},"支出 4"]
[{"$nulls":3},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpAug[金額])","v":{"v":0,"d":"0.00"}}]

{"sheet":"9 月","index":10,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["9 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),9,9)","v":"2016-09-09"},"A-12345",null,"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),9,15)","v":"2016-09-15"},"A-12346",null,"支出 2"]
[{"$nulls":3},"支出 2"]
[{"$nulls":3},"支出 3"]
[{"$nulls":3},"支出 4"]
[{"$nulls":3},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpSep[金額])","v":{"v":0,"d":"0.00"}}]

{"sheet":"10 月","index":11,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["10 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),10,10)","v":"2016-10-10"},"A-12345",null,"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),10,21)","v":"2016-10-21"},"A-12346",null,"支出 2"]
[{"$nulls":3},"支出 2"]
[{"$nulls":3},"支出 3"]
[{"$nulls":3},"支出 4"]
[{"$nulls":3},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpOct[金額])","v":{"v":0,"d":"0.00"}}]

{"sheet":"11 月","index":12,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["11 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),11,14)","v":"2016-11-14"},"A-12345",null,"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),11,21)","v":"2016-11-21"},"A-12346",null,"支出 2"]
[{"$nulls":3},"支出 2"]
[{"$nulls":3},"支出 3"]
[{"$nulls":3},"支出 4"]
[{"$nulls":3},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpNov[金額])","v":{"v":0,"d":"0.00"}}]

{"sheet":"12 月","index":13,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["12 月の支出",null,null,"サマリー","ヒント"]
["日付","発注書番号","金額","カテゴリ","説明"]
[{"$f":"DATE(YEAR(TODAY()),12,2)","v":"2016-12-02"},"A-12345",{"v":201,"d":"201.00"},"支出 1","備品"]
[{"$f":"DATE(YEAR(TODAY()),12,24)","v":"2016-12-24"},"A-12346",{"v":98,"d":"98.00"},"支出 2"]
[null,null,{"v":342,"d":"342.00"},"支出 2"]
[null,null,{"v":122,"d":"122.00"},"支出 3"]
[null,null,{"v":187,"d":"187.00"},"支出 4"]
[null,null,{"v":99,"d":"99.00"},"支出 5"]
["合計",null,{"$f":"SUBTOTAL(109,ExpDec[金額])","v":{"v":1049,"d":"1,049.00"}}]