{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Your Expenses","Report"],"not_rendered":{"charts":2,"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Your Expenses","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[1,1,1,7]]}
[]
[null,"Create your Food Budget. Check tips in cells in table header below.\nYou can create report in Report worksheet."]
[null,"Date","Category","What","How \nmany","Price \nper item","Price \n(sum)","Where"]
[null,{"$f":"TODAY()","v":"2019-03-12"},"Sweets","Sweets",{"v":0.25,"d":"0.3"},{"v":6,"d":"£6.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":1.5,"d":"£1.50"}},"Grocery"]
[null,{"$f":"TODAY()","v":"2019-03-12"},"Drinks","Coke",{"v":1,"d":"1.0"},{"v":1,"d":"£1.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":1,"d":"£1.00"}},"Fast Food"]
[null,{"$f":"TODAY()-1","v":"2019-03-11"},"Ready Meals","Meal",{"v":1,"d":"1.0"},{"v":28,"d":"£28.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":28,"d":"£28.00"}},"Fast Food"]
[null,{"$f":"TODAY()-1","v":"2019-03-11"},"Meat","Beef",1.2,{"v":15,"d":"£15.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":18,"d":"£18.00"}},"Grocery"]
[null,{"$f":"TODAY()-1","v":"2019-03-11"},"Alcohol","Whisky",{"v":1,"d":"1.0"},{"v":25,"d":"£25.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":25,"d":"£25.00"}},"Grocery"]
[null,{"$f":"TODAY()-2","v":"2019-03-10"},"Drinks","Fizzy drinks",{"v":6,"d":"6.0"},{"v":1,"d":"£1.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":6,"d":"£6.00"}},"Home Delivery"]
[null,{"$f":"TODAY()-2","v":"2019-03-10"},"Ready Meals","Meal",{"v":1,"d":"1.0"},{"v":10,"d":"£10.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":10,"d":"£10.00"}},"Home Delivery"]
[null,{"$f":"TODAY()-2","v":"2019-03-10"},"Fruit & Vegetables","Apples",{"v":2,"d":"2.0"},{"v":5,"d":"£5.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":10,"d":"£10.00"}},"Home Delivery"]
[null,{"$f":"TODAY()-2","v":"2019-03-10"},"Drinks","Water",{"v":1,"d":"1.0"},{"v":1,"d":"£1.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":1,"d":"£1.00"}},"Grocery"]
[null,{"$f":"TODAY()-3","v":"2019-03-09"},"Drinks","Coke",{"v":1,"d":"1.0"},{"v":1,"d":"£1.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":1,"d":"£1.00"}},"Fast Food"]
[null,{"$f":"TODAY()-3","v":"2019-03-09"},"Sweets","Chocolate",{"v":2,"d":"2.0"},{"v":3,"d":"£3.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":6,"d":"£6.00"}},"Grocery"]
[null,{"$f":"TODAY()-3","v":"2019-03-09"},"Sweets","Sweets",{"v":5,"d":"5.0"},{"v":1,"d":"£1.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":5,"d":"£5.00"}},"Grocery"]
[null,{"$f":"TODAY()-3","v":"2019-03-09"},"Drinks","Water",{"v":2,"d":"2.0"},{"v":0.75,"d":"£0.75"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":1.5,"d":"£1.50"}},"Coffee shops"]
[null,{"$f":"TODAY()-4","v":"2019-03-08"},"Ready Meals","Rice",{"v":1,"d":"1.0"},{"v":3.25,"d":"£3.25"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":3.25,"d":"£3.25"}},"Restaurant"]
[null,{"$f":"TODAY()-4","v":"2019-03-08"},"Meat","Beef",0.6,{"v":12,"d":"£12.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":7.199999999999999,"d":"£7.20"}},"Grocery"]
[null,{"$f":"TODAY()-4","v":"2019-03-08"},"Alcohol","Beer",{"v":1,"d":"1.0"},{"v":2,"d":"£2.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":2,"d":"£2.00"}},"Restaurant"]
[null,{"$f":"TODAY()-4","v":"2019-03-08"},"Drinks","Fizzy drinks",{"v":1,"d":"1.0"},{"v":1,"d":"£1.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":1,"d":"£1.00"}},"Grocery"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"Ready Meals","Meal",{"v":1,"d":"1.0"},{"v":10,"d":"£10.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":10,"d":"£10.00"}},"Fast Food"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"Fruit & Vegetables","Bananas",{"v":2,"d":"2.0"},{"v":3,"d":"£3.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":6,"d":"£6.00"}},"Home Delivery"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"Drinks","Coke",{"v":1,"d":"1.0"},{"v":0.75,"d":"£0.75"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":0.75,"d":"£0.75"}},"Grocery"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"Alcohol","Beer",{"v":1,"d":"1.0"},{"v":1,"d":"£1.00"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":1,"d":"£1.00"}},"Coffee shops"]
[null,{"$f":"TODAY()-5","v":"2019-03-07"},"Bread","Buns",{"v":5,"d":"5.0"},{"v":0.2,"d":"£0.20"},{"$f":"Monthly_Expenses[[#This Row],[Price \nper item]]*Monthly_Expenses[[#This Row],[How \nmany]]","v":{"v":1,"d":"£1.00"}},"Grocery"]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,Monthly_Expenses[Price \n(sum)])","v":{"v":146.2,"d":"£146.20"}}]

{"sheet":"Report","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,"Check your expenses in chosen period. "]
[]
[null,"Start day",{"$f":"TODAY()-1","v":"2019-03-11"},null,"End Day",{"$f":"TODAY()","v":"2019-03-12"}]
[]
[]
[null,"Expenses by Food Category"]
[]
[null,"Food Category","Expenses"]
[null,"Alcohol",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Category],Expenses_By_Food_Cat[[#This Row],[Food Category]])","v":{"v":25,"d":"£25.00"}}]
[null,"Bread",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Category],Expenses_By_Food_Cat[[#This Row],[Food Category]])","v":{"v":0,"d":"£0.00"}}]
[null,"Drinks",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Category],Expenses_By_Food_Cat[[#This Row],[Food Category]])","v":{"v":1,"d":"£1.00"}}]
[null,"Fruit & Vegetables",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Category],Expenses_By_Food_Cat[[#This Row],[Food Category]])","v":{"v":0,"d":"£0.00"}}]
[null,"Meat",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Category],Expenses_By_Food_Cat[[#This Row],[Food Category]])","v":{"v":18,"d":"£18.00"}}]
[null,"Ready Meals",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Category],Expenses_By_Food_Cat[[#This Row],[Food Category]])","v":{"v":28,"d":"£28.00"}}]
[null,"Sweets",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Category],Expenses_By_Food_Cat[[#This Row],[Food Category]])","v":{"v":1.5,"d":"£1.50"}}]
[null,"Other",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Category],Expenses_By_Food_Cat[[#This Row],[Food Category]])","v":{"v":0,"d":"£0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Expenses_By_Food_Cat[Expenses])","v":{"v":73.5,"d":"£73.50"}}]
[]
[null,"Expenses by Places"]
[]
[null,"Places List","Expenses"]
[null,"Market",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Where],Expenses_by_Places[[#This Row],[Places List]])","v":{"v":0,"d":"£0.00"}}]
[null,"Coffee shops",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Where],Expenses_by_Places[[#This Row],[Places List]])","v":{"v":0,"d":"£0.00"}}]
[null,"Fast Food",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Where],Expenses_by_Places[[#This Row],[Places List]])","v":{"v":29,"d":"£29.00"}}]
[null,"Grocery",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Where],Expenses_by_Places[[#This Row],[Places List]])","v":{"v":44.5,"d":"£44.50"}}]
[null,"Home Delivery",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Where],Expenses_by_Places[[#This Row],[Places List]])","v":{"v":0,"d":"£0.00"}}]
[null,"Restaurant",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Where],Expenses_by_Places[[#This Row],[Places List]])","v":{"v":0,"d":"£0.00"}}]
[null,"Other",{"$f":"SUMIFS(Monthly_Expenses[Price \n(sum)],Monthly_Expenses[Date],\">=\"&Start_Date,Monthly_Expenses[Date],\"<=\"&End_Date,Monthly_Expenses[Where],Expenses_by_Places[[#This Row],[Places List]])","v":{"v":0,"d":"£0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Expenses_by_Places[Expenses])","v":{"v":73.5,"d":"£73.50"}}]