{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Расходы","Доходы","Сводка"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Расходы","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[0,6,0,8],[1,6,1,7],[2,1,2,8],[3,7,3,8]]}
[]
[]
[null,"Бюджет мероприятия \n[Название мероприятия]"]
[{"$nulls":7}," Расходы"]
[]
[{"$nulls":7},"Предполагаемые","Фактические"]
[null,null,"Общие расходы",{"$nulls":4},{"$f":"SUM(D14,D22,D28,D35,H14,H22,H27)","v":{"v":1145,"d":"1,145.00 ₽"}},{"$f":"SUM(E14,E22,E28,E35,I14,I22,I27)","v":{"v":395,"d":"395.00 ₽"}}]
[]
[null,null,"Место проведения","Предполагаемые","Фактические",null,"Угощения","Предполагаемые","Фактические"]
[null,null,"Арендная плата",{"v":500,"d":"500.00 ₽"},{"v":250,"d":"250.00 ₽"},null,"Еда"]
[null,null,"Обслуживающий персонал",{"v":400,"d":"400.00 ₽"},{"v":50,"d":"50.00 ₽"},null,"Напитки"]
[null,null,"Оборудование",{"$nulls":3},"Скатерти"]
[null,null,"Столы и стулья",{"$nulls":3},"Обслуживающий персонал и чаевые"]
[null,null,"Итог",{"$f":"SUBTOTAL(109,Таблица1[Предполагаемые])","v":{"v":900,"d":"900.00 ₽"}},{"$f":"SUBTOTAL(109,Таблица1[Фактические])","v":{"v":300,"d":"300.00 ₽"}},null,"Итог",{"$f":"SUBTOTAL(109,Table5[Предполагаемые])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,Table5[Фактические])","v":{"v":0,"d":"0.00 ₽"}}]
[]
[null,null,"Украшения","Предполагаемые","Фактические",null,"Программа","Предполагаемые","Фактические"]
[null,null,"Цветы",{"v":200,"d":"200.00 ₽"},{"v":50,"d":"50.00 ₽"},null,"Исполнители"]
[null,null,"Свечи",{"$nulls":3},"Докладчики"]
[null,null,"Освещение",{"$nulls":3},"Транспорт"]
[null,null,"Воздушные шары",{"$nulls":3},"Гостиница"]
[null,null,"Запасы бумаги",{"$nulls":3},"Другое"]
[null,null,"Итог",{"$f":"SUBTOTAL(109,Таблица2[Предполагаемые])","v":{"v":200,"d":"200.00 ₽"}},{"$f":"SUBTOTAL(109,Таблица2[Фактические])","v":{"v":50,"d":"50.00 ₽"}},null,"Итог",{"$f":"SUBTOTAL(109,Таблица6[Предполагаемые])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,Таблица6[Фактические])","v":{"v":0,"d":"0.00 ₽"}}]
[]
[null,null,"Реклама","Предполагаемые","Фактические",null,"Призы","Предполагаемые","Фактические"]
[null,null,"Графический дизайн",{"v":45,"d":"45.00 ₽"},{"v":45,"d":"45.00 ₽"},null,"Ленты, таблички, награды"]
[null,null,"Фотокопирование и печать",{"$nulls":3},"Подарки"]
[null,null,"Почтовые расходы",{"$nulls":3},"Итог",{"$f":"SUBTOTAL(109,Таблица7[Предполагаемые])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,Таблица7[Фактические])","v":{"v":0,"d":"0.00 ₽"}}]
[null,null,"Итог",{"$f":"SUBTOTAL(109,Таблица3[Предполагаемые])","v":{"v":45,"d":"45.00 ₽"}},{"$f":"SUBTOTAL(109,Таблица3[Фактические])","v":{"v":45,"d":"45.00 ₽"}}]
[]
[null,null,"Прочее","Предполагаемые","Фактические"]
[null,null,"Телефон"]
[null,null,"Транспорт"]
[null,null,"Канцтовары"]
[null,null,"Службы факсов"]
[null,null,"Итог",{"$f":"SUBTOTAL(109,Таблица4[Предполагаемые])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,Таблица4[Фактические])","v":{"v":0,"d":"0.00 ₽"}}]

{"sheet":"Доходы","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"merged":[[2,1,2,6],[3,5,3,6],[14,1,14,6],[21,1,21,6],[28,1,28,6]]}
[]
[]
[null,"Бюджет мероприятия \n[Название мероприятия]"]
[{"$nulls":5}," Доходы"]
[]
[{"$nulls":5},"Предполагаемые","Фактические"]
[null,"Общие доходы",{"$nulls":3},{"$f":"SUM(F14,F21,F28,F36)","v":{"v":1936,"d":"1,936.00 ₽"}},{"$f":"SUM(G14,G21,G28,G36)","v":{"v":1831,"d":"1,831.00 ₽"}}]
[]
[null,"Билеты"]
[null,"Предполагаемые","Фактические",null,null,"Предполагаемые","Фактические"]
[null,300,278,"Взрослые @",{"v":5,"d":"5.00 ₽"},{"$f":"B11*E11","v":{"v":1500,"d":"1,500.00 ₽"}},{"$f":"C11*E11","v":{"v":1390,"d":"1,390.00 ₽"}}]
[null,197,195,"Дети @",{"v":2,"d":"2.00 ₽"},{"$f":"B12*E12","v":{"v":394,"d":"394.00 ₽"}},{"$f":"C12*E12","v":{"v":390,"d":"390.00 ₽"}}]
[null,42,51,"Другие @",{"v":1,"d":"1.00 ₽"},{"$f":"B13*E13","v":{"v":42,"d":"42.00 ₽"}},{"$f":"C13*E13","v":{"v":51,"d":"51.00 ₽"}}]
[{"$nulls":5},{"$f":"SUM(F11:F13)","v":{"v":1936,"d":"1,936.00 ₽"}},{"$f":"SUM(G11:G13)","v":{"v":1831,"d":"1,831.00 ₽"}}]
[]
[null,"Реклама в программе"]
[null,"Предполагаемые","Фактические",null,null,"Предполагаемые","Фактические"]
[{"$nulls":3},"Обложка @",null,{"$f":"B18*E18","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C18*E18","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":3},"Половина страницы @",null,{"$f":"B19*E19","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C19*E19","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":3},"Четверть страницы @",null,{"$f":"B20*E20","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C20*E20","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":5},{"$f":"SUM(F18:F20)","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUM(G18:G20)","v":{"v":0,"d":"0.00 ₽"}}]
[]
[null,"Экспоненты и продавцы"]
[null,"Предполагаемые","Фактические",null,null,"Предполагаемые","Фактические"]
[{"$nulls":3},"Большие стенды @",null,{"$f":"B25*E25","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C25*E25","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":3},"Средние стенды @",null,{"$f":"B26*E26","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C26*E26","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":3},"Маленькие стенды @",null,{"$f":"B27*E27","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C27*E27","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":5},{"$f":"SUM(F25:F27)","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUM(G25:G27)","v":{"v":0,"d":"0.00 ₽"}}]
[]
[null,"Продажа товаров"]
[null,"Предполагаемые","Фактические",null,null,"Предполагаемые","Фактические"]
[{"$nulls":3},"Товары @",null,{"$f":"B32*E32","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C32*E32","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":3},"Товары @",null,{"$f":"B33*E33","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C33*E33","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":3},"Товары @",null,{"$f":"B34*E34","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C34*E34","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":3},"Товары @",null,{"$f":"B35*E35","v":{"v":0,"d":"0.00 ₽"}},{"$f":"C35*E35","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":5},{"$f":"SUM(F32:F35)","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUM(G32:G35)","v":{"v":0,"d":"0.00 ₽"}}]

{"sheet":"Сводка","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[2,1,2,6],[3,5,3,6]]}
[]
[]
[null,"Бюджет мероприятия \n[Название мероприятия]"]
[{"$nulls":5},"Сводка по прибыли и убыткам"]
[]
[{"$nulls":5},"Предполагаемые","Фактические"]
[null,"Общий доход",{"$nulls":3},{"$f":"Доходы!F7","v":{"v":1936,"d":"1,936.00 ₽"}},{"$f":"Доходы!G7","v":{"v":1831,"d":"1,831.00 ₽"}}]
[null,"Общие расходы",{"$nulls":3},{"$f":"Расходы!H7","v":{"v":1145,"d":"1,145.00 ₽"}},{"$f":"Расходы!I7","v":{"v":395,"d":"395.00 ₽"}}]
[null,"Общая прибыль (или убытки)",{"$nulls":3},{"$f":"F7-F8","v":{"v":791,"d":"791.00 ₽"}},{"$f":"G7-G8","v":{"v":1436,"d":"1,436.00 ₽"}}]