{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Движение денежных средств","Доходы за месяц","Расходы за месяц","Данные диаграммы"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Движение денежных средств","index":0,"n_rows":11,"n_cols":5,"rows_kept":11}
[]
[null,"Семья Ивановых | февраль 2023 г."]
[null,"СЕМЕЙНЫЙ БЮДЖЕТ"]
[]
[null,"Анализ движения денежных средств"]
[]
[]
[null,"Семейный бюджет","Плановые","Фактические","Отклонение"]
[null,"Итого доходов",{"$f":"Доходы[[#Totals],[Плановые]]","v":{"v":5700,"d":"5,700 ₽"}},{"$f":"Доходы[[#Totals],[Фактические]]","v":{"v":6000,"d":"6,000 ₽"}},{"$f":"ДвижениеДенежныхСредств[[#This Row],[Фактические]]-ДвижениеДенежныхСредств[[#This Row],[Плановые]]","v":{"v":300,"d":"300 ₽"}}]
[null,"Итого расходов",{"$f":"Расходы[[#Totals],[Плановые]]","v":{"v":3603,"d":"3,603 ₽"}},{"$f":"Расходы[[#Totals],[Фактические]]","v":{"v":3655,"d":"3,655 ₽"}},{"$f":"ДвижениеДенежныхСредств[[#This Row],[Плановые]]-ДвижениеДенежныхСредств[[#This Row],[Фактические]]","v":{"v":-52,"d":"-52 ₽"}}]
[null,"Итого денежных средств",{"$f":"C9-C10","v":{"v":2097,"d":"2,097 ₽"}},{"$f":"D9-D10","v":{"v":2345,"d":"2,345 ₽"}},{"$f":"SUBTOTAL(109,ДвижениеДенежныхСредств[Отклонение])","v":{"v":248,"d":"248 ₽"}}]

{"sheet":"Доходы за месяц","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[1,1,1,3],[2,1,2,3]]}
[{"$nulls":5}," "]
[null,"Семья Ивановых | февраль 2023 г."]
[null,"ДОХОДЫ ЗА МЕСЯЦ"]
[]
[null," Доход за месяц","Плановые","Фактические","Отклонение"]
[null,"Доход 1",{"v":4000,"d":"4,000.00 ₽"},{"v":4000,"d":"4,000.00 ₽"},{"$f":"Доходы[[#This Row],[Фактические]]-Доходы[[#This Row],[Плановые]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Доход 2",{"v":1400,"d":"1,400.00 ₽"},{"v":1500,"d":"1,500.00 ₽"},{"$f":"Доходы[[#This Row],[Фактические]]-Доходы[[#This Row],[Плановые]]","v":{"v":100,"d":"100.00 ₽"}}]
[null,"Прочие доходы",{"v":300,"d":"300.00 ₽"},{"v":500,"d":"500.00 ₽"},{"$f":"Доходы[[#This Row],[Фактические]]-Доходы[[#This Row],[Плановые]]","v":{"v":200,"d":"200.00 ₽"}}]
[null,"Итого доходов",{"$f":"SUBTOTAL(109,Доходы[Плановые])","v":{"v":5700,"d":"5,700.00 ₽"}},{"$f":"SUBTOTAL(109,Доходы[Фактические])","v":{"v":6000,"d":"6,000.00 ₽"}},{"$f":"SUBTOTAL(109,Доходы[Отклонение])","v":{"v":300,"d":"300.00 ₽"}}]

{"sheet":"Расходы за месяц","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[1,1,1,3],[2,1,2,3]]}
[{"$nulls":5}," "]
[null,"Семья Ивановых | февраль 2023 г."]
[null,"РАСХОДЫ ЗА МЕСЯЦ"]
[]
[null," Расходы за месяц","Плановые","Фактические","Отклонение"]
[null,"Жилье",{"v":1500,"d":"1,500.00 ₽"},{"v":1500,"d":"1,500.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Продукты",{"v":250,"d":"250.00 ₽"},{"v":280,"d":"280.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":-30,"d":"-30.00 ₽"}}]
[null,"Телефон",{"v":38,"d":"38.00 ₽"},{"v":38,"d":"38.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Электричество и газ",{"v":65,"d":"65.00 ₽"},{"v":78,"d":"78.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":-13,"d":"-13.00 ₽"}}]
[null,"Водоснабжение, водоотведение, вывоз мусора",{"v":25,"d":"25.00 ₽"},{"v":21,"d":"21.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":4,"d":"4.00 ₽"}}]
[null,"Кабельное ТВ",{"v":75,"d":"75.00 ₽"},{"v":83,"d":"83.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":-8,"d":"-8.00 ₽"}}]
[null,"Интернет",{"v":60,"d":"60.00 ₽"},{"v":60,"d":"60.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Обслуживание и ремонт",{"v":0,"d":"0.00 ₽"},{"v":60,"d":"60.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":-60,"d":"-60.00 ₽"}}]
[null,"Уход за ребенком",{"v":180,"d":"180.00 ₽"},{"v":150,"d":"150.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":30,"d":"30.00 ₽"}}]
[null,"Обучение",{"v":250,"d":"250.00 ₽"},{"v":250,"d":"250.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Домашние животные",{"v":75,"d":"75.00 ₽"},{"v":80,"d":"80.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":-5,"d":"-5.00 ₽"}}]
[null,"Транспорт",{"v":280,"d":"280.00 ₽"},{"v":260,"d":"260.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":20,"d":"20.00 ₽"}}]
[null,"Предметы личной гигиены",{"v":75,"d":"75.00 ₽"},{"v":65,"d":"65.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":10,"d":"10.00 ₽"}}]
[null,"Страхование",{"v":255,"d":"255.00 ₽"},{"v":255,"d":"255.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Кредитные карты",{"v":100,"d":"100.00 ₽"},{"v":100,"d":"100.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Кредиты",{"v":0,"d":"0.00 ₽"},{"v":0,"d":"0.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Налоги",{"v":0,"d":"0.00 ₽"},{"v":0,"d":"0.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Подарки, благотворительность",{"v":150,"d":"150.00 ₽"},{"v":150,"d":"150.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Сбережения",{"v":225,"d":"225.00 ₽"},{"v":225,"d":"225.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Другое",{"v":0,"d":"0.00 ₽"},{"v":0,"d":"0.00 ₽"},{"$f":"Расходы[[#This Row],[Плановые]]-Расходы[[#This Row],[Фактические]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Итог",{"$f":"SUBTOTAL(109,Расходы[Плановые])","v":{"v":3603,"d":"3,603.00 ₽"}},{"$f":"SUBTOTAL(109,Расходы[Фактические])","v":{"v":3655,"d":"3,655.00 ₽"}},{"$f":"SUBTOTAL(109,Расходы[Отклонение])","v":{"v":-52,"d":"-52.00 ₽"}}]

{"sheet":"Данные диаграммы","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Данные диаграммы"]
[]
[null,null,"Плановые","Фактические"]
[null,"Доходы за месяц",{"$f":"Доходы[[#Totals],[Плановые]]","v":5700},{"$f":"Доходы[[#Totals],[Фактические]]","v":6000}]
[null,"Расходы за месяц",{"$f":"Расходы[[#Totals],[Плановые]]","v":3603},{"$f":"Расходы[[#Totals],[Фактические]]","v":3655}]
[null,"Движение денежных средств",{"$f":"ДвижениеДенежныхСредств[[#Totals],[Плановые]]","v":2097},{"$f":"ДвижениеДенежныхСредств[[#Totals],[Фактические]]","v":2345}]