{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["СВОДКА МЕРОПРИЯТИЯ","Имена","ДОХОД","СТАТЬИ ДОХОДОВ","СТАТЬИ РАСХОДОВ","ИМЯ"],"not_rendered":{"charts":1,"defined_names":19,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"СВОДКА МЕРОПРИЯТИЯ","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"merged":[[0,1,1,5],[0,6,1,6],[0,7,1,7],[2,3,9,6],[3,1,3,2],[8,1,9,1],[8,2,9,2],[10,1,12,3],[10,4,12,6],[13,2,13,3],[13,4,13,5],[13,7,13,8]]}
[null,"НАЗВАНИЕ МЕРОПРИЯТИЯ ПО СБОРУ СРЕДСТВ",{"$nulls":4},"ИМЯ","РАСХОДЫ"]
[]
[null,"ЦЕЛЬ МЕРОПРИЯТИЯ",null,"Круговая диаграмма, показывающая фактический доход и сумму до цели, находится в данной ячейке."]
[null,{"v":5000,"d":"5,000.00 ₽"}]
[]
[null,"ОБЩИЙ ДОХОД",{"$f":"SUM(ДОХОД!$C$8:$C$19)","v":{"v":3400,"d":"3,400.00 ₽"}}]
[null,"ОБЩИT РАСХОДЫ",{"$f":"SUM(Имена!$C$8:$C$11)","v":{"v":230,"d":"230.00 ₽"}}]
[null,"ФАКТИЧЕСКИЙ ДОХОД",{"$f":"ОБЩИЙ_ДОХОД-ОБЩИЕ_РАСХОДЫ","v":{"v":3170,"d":"3,170.00 ₽"}}]
[null,"ЦЕЛЕВОЕ ЗНАЧЕНИЕ",{"$f":"Целевая_Сумма-ФАКТИЧЕСКИЙ_ДОХОД","v":{"v":1830,"d":"1,830.00 ₽"}}]
[]
[null,"СОБРАННАЯ СУММА ПО ИМЕНИ",null,null,"ПОТРАЧЕННАЯ СУММА ПО ИМЕНИ"]
[]
[]
[null,"Срез для фильтрации по собравшему средства находится в этой ячейке.","Срез для фильтрации по источнику средств находится в этой ячейке.",null,"Срез для фильтрации по источнику расходов находится в этой ячейке.",null," Срез для фильтрации расходов по потратившему средства находится в этой ячейке.","СРЕЗЫ\n\nВыберите элемент для фильтрации списков по данным значениям. Для нескольких значений удерживайте нажатой клавишу CTRL."]
[]
[null,"ДАТА","(All)",null,null,"ДАТА","(All)"]
[]
[null,"КЕМ СОБРАНО","Сумма дохода",null,null,"КЕМ ПОТРАЧЕНО ","Статьи расходов"]
[null,"Имя 1",{"v":450,"d":"450.00 ₽"},null,null,"Имя 6",{"v":115,"d":"115.00 ₽"}]
[null,"Имя 2",{"v":50,"d":"50.00 ₽"},null,null,"Имя 7",{"v":45.5,"d":"45.50 ₽"}]
[null,"Имя 3",{"v":150,"d":"150.00 ₽"},null,null,"Имя 2",{"v":50,"d":"50.00 ₽"}]
[null,"Имя 8",{"v":550,"d":"550.00 ₽"},null,null,"Имя 5",{"v":19.5,"d":"19.50 ₽"}]
[null,"Имя 5",{"v":75,"d":"75.00 ₽"},null,null,"Grand Total",{"v":230,"d":"230.00 ₽"}]
[null,"Имя 4",{"v":725,"d":"725.00 ₽"}]
[null,"Имя 7",{"v":775,"d":"775.00 ₽"}]
[null,"Имя 6",{"v":350,"d":"350.00 ₽"}]
[null,"Имя 9",{"v":150,"d":"150.00 ₽"}]
[null,"Имя 10",{"v":125,"d":"125.00 ₽"}]
[null,"Grand Total",{"v":3400,"d":"3,400.00 ₽"}]

{"sheet":"Имена","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"merged":[[0,1,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,9],[3,1,5,4]]}
[null,"ДОХОД И РАСХОДЫ",{"$nulls":4},"СВОДКА МЕРОПРИЯТИЯ","ДОХОД"]
[]
[]
[null,"РАСХОДЫ"]
[]
[]
[null,"ИСТОЧНИК","СУММА","ДАТА","КЕМ ПОТРАЧЕНО "]
[null,"Аренда автомобиля",{"v":115,"d":"115.00 ₽"},"2025-06-01","Имя 6"]
[null,"Материалы",{"v":45.5,"d":"45.50 ₽"},"2025-06-02","Имя 7"]
[null,"Материалы",{"v":50,"d":"50.00 ₽"},"2025-06-01","Имя 2"]
[null,"Реклама",{"v":19.5,"d":"19.50 ₽"},"2025-06-01","Имя 5"]

{"sheet":"ДОХОД","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,1,1,5],[0,6,1,6],[0,7,1,7],[1,8,2,8],[3,1,5,4]]}
[null,"ДОХОД И РАСХОДЫ",{"$nulls":4},"Имена","СТАТЬИ ДОХОДОВ"]
[]
[]
[null,"ВЫРУЧКА"]
[]
[]
[null,"ИСТОЧНИК","СУММА","ДАТА","КЕМ СОБРАНО"]
[null,"Лотерейные билеты",{"v":250,"d":"250.00 ₽"},"2025-06-01","Имя 1"]
[null,"Пожертвования наличных",{"v":50,"d":"50.00 ₽"},"2025-06-01","Имя 2"]
[null,"Анонимное пожертвование",{"v":150,"d":"150.00 ₽"},"2025-06-02","Имя 3"]
[null,"Негласный аукцион",{"v":550,"d":"550.00 ₽"},"2025-06-03","Имя 8"]
[null,"Продано продуктов и услуг",{"v":75,"d":"75.00 ₽"},"2025-06-03","Имя 5"]
[null,"Пожертвования наличных",{"v":200,"d":"200.00 ₽"},"2025-06-04","Имя 1"]
[null,"Анонимное пожертвование",{"v":500,"d":"500.00 ₽"},"2025-06-05","Имя 4"]
[null,"Негласный аукцион",{"v":775,"d":"775.00 ₽"},"2025-06-06","Имя 7"]
[null,"Продано продуктов и услуг",{"v":350,"d":"350.00 ₽"},"2025-06-08","Имя 6"]
[null,"Лотерейные билеты",{"v":225,"d":"225.00 ₽"},"2025-06-09","Имя 4"]
[null,"Лотерейные билеты",{"v":150,"d":"150.00 ₽"},"2025-06-11","Имя 9"]
[null,"Лотерейные билеты",{"v":125,"d":"125.00 ₽"},"2025-06-11","Имя 10"]

{"sheet":"СТАТЬИ ДОХОДОВ","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[0,1,1,1],[0,2,1,2],[0,3,1,3]]}
[null,"СПИСКИ","ДОХОД","СТАТЬИ РАСХОДОВ"]
[{"$nulls":4}," "]
[{"$nulls":4}," "]
[null,"СТАТЬИ ДОХОДОВ"]
[null,"Лотерейные билеты"]
[null,"Плата за вход"]
[null,"Пожертвования наличных"]
[null,"Пожертвовано статей негласного аукциона"]
[null,"Продано продуктов и услуг"]
[null,"Анонимное пожертвование"]
[null,"Негласный аукцион"]

{"sheet":"СТАТЬИ РАСХОДОВ","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[0,1,1,1],[0,2,1,2],[0,3,1,3]]}
[null,"СПИСКИ","СТАТЬИ ДОХОДОВ","ИМЯ"]
[]
[]
[null,"СТАТЬИ РАСХОДОВ"]
[null,"Управление волонтерами"]
[null,"Питание волонтеров"]
[null,"Аренда помещений"]
[null,"Материалы"]
[null,"Налог с продаж"]
[null,"Страхование"]
[null,"Лицензия на ведение бизнеса"]
[null,"Себестоимость проданных товаров"]
[null,"Аренда автомобиля"]
[null,"Почтовые расходы"]
[null,"Печатные материалы"]
[null,"Реклама"]
[null,"Продукты или услуги"]

{"sheet":"ИМЯ","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"merged":[[0,1,1,1],[0,2,1,2],[0,3,1,3]]}
[null,"СПИСКИ","СТАТЬИ РАСХОДОВ","СВОДКА МЕРОПРИЯТИЯ"]
[]
[]
[null,"ИМЕНА"]
[null,"Имя 1"]
[null,"Имя 2"]
[null,"Имя 3"]
[null,"Имя 4"]
[null,"Имя 5"]
[null,"Имя 6"]
[null,"Имя 7"]
[null,"Имя 8"]
[null,"Имя 9"]
[null,"Имя 10"]