{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["支出","レポート"],"not_rendered":{"charts":2,"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"支出","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[1,1,1,7]]}
[]
[null,"食費の家計簿を作成しましょう。下の表見出しのセルをクリックすると、ヒントが表示されます。\n[レポート] ワークシートでは、レポートを作成できます。"]
[null,"日付","カテゴリ","摘要","数量","単価","合計金額","購入場所"]
[null,{"$f":"TODAY()","v":"2019-03-12"},"菓子","アメ",{"v":0.25,"d":"0.3"},{"v":6,"d":"¥6.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":1.5,"d":"¥1.50"}},"食料品店"]
[null,{"$f":"TODAY()","v":"2019-03-12"},"飲料","コーラ",{"v":1,"d":"1.0"},{"v":1,"d":"¥1.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":1,"d":"¥1.00"}},"ファースト フード店"]
[null,{"$f":"TODAY()-1","v":"2019-03-11"},"惣菜","外食",{"v":1,"d":"1.0"},{"v":28,"d":"¥28.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":28,"d":"¥28.00"}},"ファースト フード店"]
[null,{"$f":"TODAY()-1","v":"2019-03-11"},"肉類","牛肉",1.2,{"v":15,"d":"¥15.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":18,"d":"¥18.00"}},"食料品店"]
[null,{"$f":"TODAY()-1","v":"2019-03-11"},"酒類","ウイスキー",{"v":1,"d":"1.0"},{"v":25,"d":"¥25.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":25,"d":"¥25.00"}},"食料品店"]
[null,{"$f":"TODAY()-2","v":"2019-03-10"},"飲料","ソーダ",{"v":6,"d":"6.0"},{"v":1,"d":"¥1.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":6,"d":"¥6.00"}},"宅配"]
[null,{"$f":"TODAY()-2","v":"2019-03-10"},"惣菜","外食",{"v":1,"d":"1.0"},{"v":10,"d":"¥10.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":10,"d":"¥10.00"}},"宅配"]
[null,{"$f":"TODAY()-2","v":"2019-03-10"},"果物 & 野菜","リンゴ",{"v":2,"d":"2.0"},{"v":5,"d":"¥5.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":10,"d":"¥10.00"}},"宅配"]
[null,{"$f":"TODAY()-2","v":"2019-03-10"},"飲料","飲料水",{"v":1,"d":"1.0"},{"v":1,"d":"¥1.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":1,"d":"¥1.00"}},"食料品店"]
[null,{"$f":"TODAY()-3","v":"2019-03-09"},"飲料","コーラ",{"v":1,"d":"1.0"},{"v":1,"d":"¥1.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":1,"d":"¥1.00"}},"ファースト フード店"]
[null,{"$f":"TODAY()-3","v":"2019-03-09"},"菓子","チョコレート",{"v":2,"d":"2.0"},{"v":3,"d":"¥3.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":6,"d":"¥6.00"}},"食料品店"]
[null,{"$f":"TODAY()-3","v":"2019-03-09"},"菓子","アメ",{"v":5,"d":"5.0"},{"v":1,"d":"¥1.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":5,"d":"¥5.00"}},"食料品店"]
[null,{"$f":"TODAY()-3","v":"2019-03-09"},"飲料","飲料水",{"v":2,"d":"2.0"},{"v":0.75,"d":"¥0.75"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":1.5,"d":"¥1.50"}},"コーヒー ショップ"]
[null,{"$f":"TODAY()-4","v":"2019-03-08"},"惣菜","米",{"v":1,"d":"1.0"},{"v":3.25,"d":"¥3.25"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":3.25,"d":"¥3.25"}},"レストラン"]
[null,{"$f":"TODAY()-4","v":"2019-03-08"},"肉類","牛肉",0.6,{"v":12,"d":"¥12.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":7.199999999999999,"d":"¥7.20"}},"食料品店"]
[null,{"$f":"TODAY()-4","v":"2019-03-08"},"酒類","ビール",{"v":1,"d":"1.0"},{"v":2,"d":"¥2.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":2,"d":"¥2.00"}},"レストラン"]
[null,{"$f":"TODAY()-4","v":"2019-03-08"},"飲料","ソーダ",{"v":1,"d":"1.0"},{"v":1,"d":"¥1.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":1,"d":"¥1.00"}},"食料品店"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"惣菜","外食",{"v":1,"d":"1.0"},{"v":10,"d":"¥10.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":10,"d":"¥10.00"}},"ファースト フード店"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"果物 & 野菜","バナナ",{"v":2,"d":"2.0"},{"v":3,"d":"¥3.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":6,"d":"¥6.00"}},"宅配"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"飲料","コーラ",{"v":1,"d":"1.0"},{"v":0.75,"d":"¥0.75"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":0.75,"d":"¥0.75"}},"食料品店"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"酒類","ビール",{"v":1,"d":"1.0"},{"v":1,"d":"¥1.00"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":1,"d":"¥1.00"}},"コーヒー ショップ"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"パン","ロールパン",{"v":5,"d":"5.0"},{"v":0.2,"d":"¥0.20"},{"$f":"Monthly_Expenses[[#This Row],[単価]]*Monthly_Expenses[[#This Row],[数量]]","v":{"v":1,"d":"¥1.00"}},"食料品店"]
[null,"集計",{"$nulls":4},{"$f":"SUBTOTAL(109,Monthly_Expenses[合計金額])","v":{"v":146.2,"d":"¥146.20"}}]

{"sheet":"レポート","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"merged":[[0,1,0,7],[5,1,5,2],[18,1,18,2]]}
[null,"選択した期間の支出を確認できます。 "]
[]
[null,"開始日",{"$f":"TODAY()-1","v":"2019-03-11"},null,"終了日",{"$f":"TODAY()","v":"2019-03-12"}]
[]
[]
[null,"食品カテゴリ別の支出"]
[]
[null,"食品カテゴリ","金額"]
[null,"酒類",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[カテゴリ],Expenses_By_Food_Cat[[#This Row],[食品カテゴリ]])","v":{"v":25,"d":"¥25.00"}}]
[null,"パン",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[カテゴリ],Expenses_By_Food_Cat[[#This Row],[食品カテゴリ]])","v":{"v":0,"d":"¥0.00"}}]
[null,"飲料",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[カテゴリ],Expenses_By_Food_Cat[[#This Row],[食品カテゴリ]])","v":{"v":1,"d":"¥1.00"}}]
[null,"果物 & 野菜",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[カテゴリ],Expenses_By_Food_Cat[[#This Row],[食品カテゴリ]])","v":{"v":0,"d":"¥0.00"}}]
[null,"肉類",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[カテゴリ],Expenses_By_Food_Cat[[#This Row],[食品カテゴリ]])","v":{"v":18,"d":"¥18.00"}}]
[null,"惣菜",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[カテゴリ],Expenses_By_Food_Cat[[#This Row],[食品カテゴリ]])","v":{"v":28,"d":"¥28.00"}}]
[null,"菓子",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[カテゴリ],Expenses_By_Food_Cat[[#This Row],[食品カテゴリ]])","v":{"v":1.5,"d":"¥1.50"}}]
[null,"その他",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[カテゴリ],Expenses_By_Food_Cat[[#This Row],[食品カテゴリ]])","v":{"v":0,"d":"¥0.00"}}]
[null,"集計",{"$f":"SUBTOTAL(109,Expenses_By_Food_Cat[金額])","v":{"v":73.5,"d":"¥73.50"}}]
[]
[null,"購入場所別の支出"]
[]
[null,"購入場所リスト","金額"]
[null,"市場",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[購入場所],Expenses_by_Places[[#This Row],[購入場所リスト]])","v":{"v":0,"d":"¥0.00"}}]
[null,"コーヒー ショップ",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[購入場所],Expenses_by_Places[[#This Row],[購入場所リスト]])","v":{"v":0,"d":"¥0.00"}}]
[null,"ファースト フード店",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[購入場所],Expenses_by_Places[[#This Row],[購入場所リスト]])","v":{"v":29,"d":"¥29.00"}}]
[null,"食料品店",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[購入場所],Expenses_by_Places[[#This Row],[購入場所リスト]])","v":{"v":44.5,"d":"¥44.50"}}]
[null,"宅配",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[購入場所],Expenses_by_Places[[#This Row],[購入場所リスト]])","v":{"v":0,"d":"¥0.00"}}]
[null,"レストラン",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[購入場所],Expenses_by_Places[[#This Row],[購入場所リスト]])","v":{"v":0,"d":"¥0.00"}}]
[null,"その他",{"$f":"SUMIFS(Monthly_Expenses[合計金額],Monthly_Expenses[日付],\">=\"&Start_Date,Monthly_Expenses[日付],\"<=\"&End_Date,Monthly_Expenses[購入場所],Expenses_by_Places[[#This Row],[購入場所リスト]])","v":{"v":0,"d":"¥0.00"}}]
[null,"集計",{"$f":"SUBTOTAL(109,Expenses_by_Places[金額])","v":{"v":73.5,"d":"¥73.50"}}]