{"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]]}
[{"$nulls":3},"Food budget"]
[null,"Create your food budget. Check tips in cells in table header below.\nYou can create report in the Report worksheet."]
[null,"Date","Category","What","How \nmany","Price \nper item","Price \n(sum)","Where"]
[null,{"$f":"TODAY()","v":"2022-11-10"},"Sweets","Candies",0.25,{"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":"2022-11-10"},"Drinks","Coke",1,{"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":"2022-11-09"},"Ready meals","Meal",1,{"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":"2022-11-09"},"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":"2022-11-09"},"Alcohol","Whisky",1,{"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":"2022-11-08"},"Drinks","Soda",6,{"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":"2022-11-08"},"Ready meals","Meal",1,{"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":"2022-11-08"},"Fruits & vegetables","Apples",2,{"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":"2022-11-08"},"Drinks","Water",1,{"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":"2022-11-07"},"Drinks","Coke",1,{"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":"2022-11-07"},"Sweets","Chocolate",2,{"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":"2022-11-07"},"Sweets","Candies",5,{"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":"2022-11-07"},"Drinks","Water",2,{"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":"2022-11-06"},"Ready meals","Rice",1,{"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":"2022-11-06"},"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":"2022-11-06"},"Alcohol","Beer",1,{"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":"2022-11-06"},"Drinks","Soda",1,{"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":"2022-11-05"},"Ready meals","Meal",1,{"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":"2022-11-05"},"Fruits & vegetables","Bananas",2,{"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":"2022-11-05"},"Drinks","Coke",1,{"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":"2022-11-05"},"Alcohol","Beer",1,{"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":"2022-11-05"},"Bread","Buns",5,{"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 choosen period. "]
[]
[null,"Start Day",{"$f":"TODAY()-1","v":"2022-11-09"},null,"End Day",{"$f":"TODAY()","v":"2022-11-10"}]
[]
[]
[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,"Fruits & 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"}}]