{"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много","Цена \nза единицу","Цена \n(сумма)","Где"]
[null,{"$f":"TODAY()","v":"2019-03-13"},"Сладости","Свечи",{"v":0.25,"d":"0.3"},{"v":6,"d":"6.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":1.5,"d":"1.50 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()","v":"2019-03-13"},"Напитки","Кола",{"v":1,"d":"1.0"},{"v":1,"d":"1.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":1,"d":"1.00 ₽"}},"Фастфуд"]
[null,{"$f":"TODAY()-1","v":"2019-03-12"},"Готовые продукты","Еда",{"v":1,"d":"1.0"},{"v":28,"d":"28.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":28,"d":"28.00 ₽"}},"Фастфуд"]
[null,{"$f":"TODAY()-1","v":"2019-03-12"},"Мясо","Говядина",1.2,{"v":15,"d":"15.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":18,"d":"18.00 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()-1","v":"2019-03-12"},"Алкоголь","Виски",{"v":1,"d":"1.0"},{"v":25,"d":"25.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":25,"d":"25.00 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()-2","v":"2019-03-11"},"Напитки","Газированная вода",{"v":6,"d":"6.0"},{"v":1,"d":"1.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":6,"d":"6.00 ₽"}},"Доставка на дом"]
[null,{"$f":"TODAY()-2","v":"2019-03-11"},"Готовые продукты","Еда",{"v":1,"d":"1.0"},{"v":10,"d":"10.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":10,"d":"10.00 ₽"}},"Доставка на дом"]
[null,{"$f":"TODAY()-2","v":"2019-03-11"},"Фрукты и овощи","Яблоки",{"v":2,"d":"2.0"},{"v":5,"d":"5.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":10,"d":"10.00 ₽"}},"Доставка на дом"]
[null,{"$f":"TODAY()-2","v":"2019-03-11"},"Напитки","Вода",{"v":1,"d":"1.0"},{"v":1,"d":"1.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":1,"d":"1.00 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()-3","v":"2019-03-10"},"Напитки","Кола",{"v":1,"d":"1.0"},{"v":1,"d":"1.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":1,"d":"1.00 ₽"}},"Фастфуд"]
[null,{"$f":"TODAY()-3","v":"2019-03-10"},"Сладости","Шоколад",{"v":2,"d":"2.0"},{"v":3,"d":"3.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":6,"d":"6.00 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()-3","v":"2019-03-10"},"Сладости","Свечи",{"v":5,"d":"5.0"},{"v":1,"d":"1.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":5,"d":"5.00 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()-3","v":"2019-03-10"},"Напитки","Вода",{"v":2,"d":"2.0"},{"v":0.75,"d":"0.75 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":1.5,"d":"1.50 ₽"}},"Кафе"]
[null,{"$f":"TODAY()-4","v":"2019-03-09"},"Готовые продукты","Рис",{"v":1,"d":"1.0"},{"v":3.25,"d":"3.25 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":3.25,"d":"3.25 ₽"}},"Ресторан"]
[null,{"$f":"TODAY()-4","v":"2019-03-09"},"Мясо","Говядина",0.6,{"v":12,"d":"12.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":7.199999999999999,"d":"7.20 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()-4","v":"2019-03-09"},"Алкоголь","Пиво",{"v":1,"d":"1.0"},{"v":2,"d":"2.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":2,"d":"2.00 ₽"}},"Ресторан"]
[null,{"$f":"TODAY()-4","v":"2019-03-09"},"Напитки","Газированная вода",{"v":1,"d":"1.0"},{"v":1,"d":"1.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":1,"d":"1.00 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()-5","v":"2019-03-08"},"Готовые продукты","Еда",{"v":1,"d":"1.0"},{"v":10,"d":"10.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":10,"d":"10.00 ₽"}},"Фастфуд"]
[null,{"$f":"TODAY()-5","v":"2019-03-08"},"Фрукты и овощи","Бананы",{"v":2,"d":"2.0"},{"v":3,"d":"3.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":6,"d":"6.00 ₽"}},"Доставка на дом"]
[null,{"$f":"TODAY()-5","v":"2019-03-08"},"Напитки","Кола",{"v":1,"d":"1.0"},{"v":0.75,"d":"0.75 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":0.75,"d":"0.75 ₽"}},"Продовольственный магазин"]
[null,{"$f":"TODAY()-5","v":"2019-03-08"},"Алкоголь","Пиво",{"v":1,"d":"1.0"},{"v":1,"d":"1.00 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","v":{"v":1,"d":"1.00 ₽"}},"Кафе"]
[null,{"$f":"TODAY()-5","v":"2019-03-08"},"Хлеб","Булка",{"v":5,"d":"5.0"},{"v":0.2,"d":"0.20 ₽"},{"$f":"Monthly_Expenses[[#This Row],[Цена \nза единицу]]*Monthly_Expenses[[#This Row],[Как \nмного]]","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-12"},null,"День окончания",{"$f":"TODAY()","v":"2019-03-13"}]
[]
[]
[null,"Расходы по категории продуктов"]
[]
[null,"Категория продуктов","Расходы"]
[null,"Алкоголь",{"$f":"SUMIFS(Monthly_Expenses[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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[Цена \n(сумма)],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 ₽"}}]