{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Бюджет","Лист2","Затраты","Данные диаграммы"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":48,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Бюджет","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[10,1,10,13]]}
[null,null,"Янв.","Февр.","Март","Апр.","Май","Июнь","Июль","Авг.","Сент.","Сент.","Нояб.","Дек.","Год","Ср."]
[]
[]
[null,"Доходы"]
[null,"Заработная плата",{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&C$1&\"17\")))","v":26000},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&D$1&\"17\")))","v":65000},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&E$1&\"17\")))","v":43000},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&F$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&G$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&H$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&I$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&J$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&K$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&L$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&M$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B5)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&N$1&\"17\")))","v":0},{"$f":"SUM(Бюджет!$C5:$N5)","v":134000},{"$f":"Бюджет!$O5/12","v":11166.666666666666}]
[null,"Премии и поощрения",{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&C$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&D$1&\"17\")))","v":17000},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&E$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&F$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&G$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&H$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&I$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&J$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&K$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&L$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&M$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B6)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&N$1&\"17\")))","v":0},{"$f":"SUM(Бюджет!$C6:$N6)","v":17000},{"$f":"Бюджет!$O6/12","v":1416.6666666666667}]
[null,"Полученные подарки",{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&C$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&D$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&E$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&F$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&G$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&H$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&I$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&J$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&K$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&L$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&M$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B7)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&N$1&\"17\")))","v":0},{"$f":"SUM(Бюджет!$C7:$N7)","v":0},{"$f":"Бюджет!$O7/12","v":0}]
[null,"Перевод из сбережений",{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&C$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&D$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&E$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&F$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&G$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&H$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&I$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&J$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&K$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&L$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&M$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B8)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&N$1&\"17\")))","v":0},{"$f":"SUM(Бюджет!$C8:$N8)","v":0},{"$f":"Бюджет!$O8/12","v":0}]
[null,"Прочее",{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&C$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&D$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&E$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&F$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&G$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&H$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&I$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&J$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&K$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&L$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&M$1&\"17\")))","v":0},{"$f":"SUMPRODUCT(Затраты!$C$2:$C$99*(Затраты!$B$2:$B$99=$B9)*(MONTH(Затраты!$A$2:$A$99)=MONTH(1&\"\"&N$1&\"17\")))","v":0},{"$f":"SUM(Бюджет!$C9:$N9)","v":0},{"$f":"Бюджет!$O9/12","v":0}]
[null,"ОБЩИЕ ДОХОДЫ",{"$f":"SUM(C5:C9)","v":26000},82000,43000,0,0,0,0,0,0,0,0,0,151000,{"$f":"O10/12","v":12583.333333333334}]

{"sheet":"Лист2","index":1,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Доходы"]
["Заработная плата"]
["Премии и поощрения"]
["Полученные подарки"]
["Перевод из сбережений"]
["Прочее"]
[]
["Жилье"]
["Ипотека или аренда"]
["Коммунальные платежи"]
["Интернет"]
["Мебель и бытовая техника"]
["Сотовая связь"]
["Товары для дома "]
["Ремонт дома"]
["Прочее"]
[]
["Бытовые нужды"]
["Продукты"]
["Средства личной гигиены"]
["Одежда"]
["Хоз. товары"]
["Питание вне дома"]
["Химчистка"]
["Салон красоты или парикмахерская"]
["Прочее"]
[]
["Дети"]
["Медицинские услуги"]
["Одежда"]
["Обучение в кружках"]
["Игрушки и игры"]
["Прочее"]
[]
["Транспорт"]
["Расходы на автомобиль"]
["Топливо"]
["Общественный транспорт"]
["Ремонт"]
["Регистрация и удостоверение"]
["Прочее"]
[]
["Здоровье"]
["Стоматолог и другие врачи"]
["Лекарства"]
["Абонементы в спортзалы"]
["Экстренная медицинская помощь"]
["Прочее"]

{"sheet":"Затраты","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Дата","Категория","Расход","Пометки"]
[]
["2017-01-12","Заработная плата",12000]
["2017-01-18","Заработная плата",14000]
["2017-02-02","Заработная плата",65000]
["2017-02-12","Премии и поощрения",17000]
["2017-03-12","Заработная плата",43000]

{"sheet":"Данные диаграммы","index":3,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[null,"*** Этот лист должен оставаться скрытым ***"]
[]
[]
[null,"Период",3]
[]
[null,null,"Янв.","Февр.","Март","Апр.","Май","Июнь","Июль","Авг.","Сент.","Окт.","Нояб.","Дек.","Год","Ср."]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"LOWER(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,"Общий денежный поток",{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(Бюджет!#REF!)","v":{"$error":"#REF!"}}]
[]
[null,"Годовой приток денежного потока",{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!<0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}}]
[null,"Годовой отток денежного потока",{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(Бюджет!#REF!>=0,NA(),IF(период+2<>COLUMN(Бюджет!#REF!),NA(),Бюджет!#REF!))","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"отображать_длительный_период","v":"Март"}]
[null,{"$f":"отображать_длительный_период & \" Доходы\"","v":"Март Доходы"},{"$f":"INDEX(Бюджет!#REF!,,период)","v":{"$error":"#REF!"}}]
[null,{"$f":"отображать_длительный_период & \" Расходы: \" & TEXT(INDEX(Бюджет!#REF!,,период),\"# ##0р.\")","v":{"$error":"#REF!"}},{"$f":"INDEX(Бюджет!#REF!,,период)","v":{"$error":"#REF!"}}]
[null,{"$f":"отображать_длительный_период & \"Движение средств\"","v":"МартДвижение средств"},{"$f":"ABS(INDEX(Бюджет!#REF!,,период))","v":{"$error":"#REF!"}},{"$f":"REPT(\"-\",INDEX(Бюджет!#REF!,,период)<0)","v":{"$error":"#REF!"}}]