{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Рух грошових коштів","Щомісячний дохід","Щомісячні витрати","Дані діаграми"],"not_rendered":{"charts":1,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Рух грошових коштів","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," Прізвище"]
[null,"Сімейний бюджет"]
[null,{"$f":"\" За місяць \" & TEXT(TODAY(),\"mmmm yyyy\")","v":" За місяць September 2021"}]
[]
[]
[null,"Аналіз руху грошових коштів"]
[]
[]
[null," ","Прогнозовано","Фактично","Відхилення"]
[{"$f":"Дохід[[#Totals],[Відхилення]]","v":300},"Сумарний дохід",{"$f":"Дохід[[#Totals],[Прогнозовано]]","v":{"v":5700,"d":"5,700₴"}},{"$f":"Дохід[[#Totals],[Фактично]]","v":{"v":6000,"d":"6,000₴"}},{"$f":"A12","v":{"v":300,"d":"300₴"}}]
[{"$f":"Витрати[[#Totals],[Дисперсія]]","v":{"v":-52,"d":"52.00 ₴"}},"Сумарні витрати",{"$f":"Витрати[[#Totals],[Прогнозовано]]","v":{"v":3603,"d":"3,603₴"}},{"$f":"Витрати[[#Totals],[Фактично]]","v":{"v":3655,"d":"3,655₴"}},{"$f":"A13","v":{"v":-52,"d":"-52₴"}}]
[null,"Усього грошових коштів",{"$f":"C12-C13","v":{"v":2097,"d":"2,097₴"}},{"$f":"D12-D13","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}
[{"$nulls":5}," "]
[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}
[{"$nulls":5}," "]
[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}]