{"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,"日期","类别","内容","多少数量","价格每件","价格\n（总和）","地点"]
[null,{"$f":"TODAY()","v":"2019-03-14"},"甜品","糖果",{"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-14"},"饮料","可乐",{"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-13"},"预制餐","餐食",{"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-13"},"肉类","牛肉",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-13"},"酒类","威士忌",{"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-12"},"饮料","苏打饮料",{"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-12"},"预制餐","餐食",{"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-12"},"水果和蔬菜","苹果",{"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-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()-3","v":"2019-03-11"},"饮料","可乐",{"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-11"},"甜品","巧克力",{"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-11"},"甜品","糖果",{"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-11"},"饮料","水",{"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-10"},"预制餐","饭",{"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-10"},"肉类","牛肉",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-10"},"酒类","啤酒",{"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-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()-5","v":"2019-03-09"},"预制餐","餐食",{"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-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()-5","v":"2019-03-09"},"饮料","可乐",{"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-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()-5","v":"2019-03-09"},"面包","圆面包",{"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[价格\n（总和）])","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-13"},null,"结束日期",{"$f":"TODAY()","v":"2019-03-14"}]
[]
[]
[null,"按食品类别列出的支出"]
[]
[null,"食品类别","支出"]
[null,"酒类",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[类别],按食品类别列出的支出[[#This Row],[食品类别]])","v":{"v":25,"d":"¥25.00"}}]
[null,"面包",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[类别],按食品类别列出的支出[[#This Row],[食品类别]])","v":{"v":0,"d":"¥0.00"}}]
[null,"饮料",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[类别],按食品类别列出的支出[[#This Row],[食品类别]])","v":{"v":1,"d":"¥1.00"}}]
[null,"水果和蔬菜",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[类别],按食品类别列出的支出[[#This Row],[食品类别]])","v":{"v":0,"d":"¥0.00"}}]
[null,"肉类",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[类别],按食品类别列出的支出[[#This Row],[食品类别]])","v":{"v":18,"d":"¥18.00"}}]
[null,"预制餐",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[类别],按食品类别列出的支出[[#This Row],[食品类别]])","v":{"v":28,"d":"¥28.00"}}]
[null,"甜品",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[类别],按食品类别列出的支出[[#This Row],[食品类别]])","v":{"v":1.5,"d":"¥1.50"}}]
[null,"其他",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[类别],按食品类别列出的支出[[#This Row],[食品类别]])","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,按食品类别列出的支出[支出])","v":{"v":73.5,"d":"¥73.50"}}]
[]
[null,"按地点列出的支出"]
[]
[null,"地点列表","支出"]
[null,"市场",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[地点],按地点列出的支出[[#This Row],[地点列表]])","v":{"v":0,"d":"¥0.00"}}]
[null,"咖啡店",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[地点],按地点列出的支出[[#This Row],[地点列表]])","v":{"v":0,"d":"¥0.00"}}]
[null,"快餐",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[地点],按地点列出的支出[[#This Row],[地点列表]])","v":{"v":29,"d":"¥29.00"}}]
[null,"杂货铺",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[地点],按地点列出的支出[[#This Row],[地点列表]])","v":{"v":44.5,"d":"¥44.50"}}]
[null,"送货上门",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[地点],按地点列出的支出[[#This Row],[地点列表]])","v":{"v":0,"d":"¥0.00"}}]
[null,"餐厅",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[地点],按地点列出的支出[[#This Row],[地点列表]])","v":{"v":0,"d":"¥0.00"}}]
[null,"其他",{"$f":"SUMIFS(Monthly_Expenses[价格\n（总和）],Monthly_Expenses[日期],\">=\"&开始日期,Monthly_Expenses[日期],\"<=\"&结束日期,Monthly_Expenses[地点],按地点列出的支出[[#This Row],[地点列表]])","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,按地点列出的支出[支出])","v":{"v":73.5,"d":"¥73.50"}}]