{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Месячный бюджет на питание","Фактические расходы"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Месячный бюджет на питание","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"merged":[[3,4,3,6],[5,1,5,3],[5,4,5,6],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[{"$nulls":7}," "]
[]
[null,"Бюджет для месяца",null,null,{"$f":"\"Процент потраченного бюджета:  \"&TEXT(E4,\"0%\")","v":"Процент потраченного бюджета:  35%"}]
[null,{"$f":"TEXT(NOW(),\"ММММ\")","v":"Май"},null,null,{"$f":"E6/B6","v":0.3508695652173913}]
[null,"Общий бюджет питания за месяц",null,null,"Уже потраченная сумма"]
[null,{"$f":"SUM(D9:G9)","v":{"v":575,"d":"575 ₽"}},null,null,{"$f":"SUM(D10:G10)","v":{"v":201.75,"d":"202 ₽"}}]
[]
[{"$nulls":3},"Продовольственные товары","Питание вне дома","Закуски","Прочее"]
[null,"Месячный бюджет",null,{"v":325,"d":"325 ₽"},{"v":100,"d":"100 ₽"},{"v":100,"d":"100 ₽"},{"v":50,"d":"50 ₽"}]
[null,"Фактические расходы",null,{"$f":"SUMIF(Table_ActualFoodExpenses[Категория],'Месячный бюджет на питание'!D8,Table_ActualFoodExpenses[Стоимость])","v":{"v":175,"d":"175 ₽"}},{"$f":"SUMIF(Table_ActualFoodExpenses[Категория],'Месячный бюджет на питание'!E8,Table_ActualFoodExpenses[Стоимость])","v":{"v":0,"d":"0 ₽"}},{"$f":"SUMIF(Table_ActualFoodExpenses[Категория],'Месячный бюджет на питание'!F8,Table_ActualFoodExpenses[Стоимость])","v":{"v":16.75,"d":"17 ₽"}},{"$f":"SUMIF(Table_ActualFoodExpenses[Категория],'Месячный бюджет на питание'!G8,Table_ActualFoodExpenses[Стоимость])","v":{"v":10,"d":"10 ₽"}}]

{"sheet":"Фактические расходы","index":1,"n_rows":6,"n_cols":6,"rows_kept":6}
[null,"Фактические расходы на питание",{"$nulls":3}," "]
[null,"Дата","Стоимость","Категория","Комментарии"]
[null,{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),F3)","v":"2022-05-01"},{"v":175,"d":"175.00 ₽"},"Продовольственные товары",null,1]
[null,"2022-05-05",{"v":4.75,"d":"4.75 ₽"},"Закуски",null,5]
[null,"2022-05-07",{"v":12,"d":"12.00 ₽"},"Закуски",null,7]
[null,"2022-05-08",{"v":10,"d":"10.00 ₽"},"Прочее",null,8]