{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["2","Музеи","интерактивы","Объекты","РАСЧЕТ","Обеды","Транспорт","Справочник"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":3,"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":"2","index":0,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Общее количество человек","платники"]
[null,null,null,null,null,42,24]
[]
[]
[]
[]
[null,null,null,"Стоимость билета","Факт оплата"]
[true,null,"Музей 1",50,{"$f":"IF(A8,D8*F$2/G$2,0)","v":87.5}]
[true,null,"Музей 2",100,{"$f":"IF(A9,D9*F$2/G$2,0)","v":175}]
[false,null,"Музей 3",150,0]
[true,null,"Музей 4",80,140]
[]
[true,null,"Музей 5",90,157.5]
[true,null,"Интерактив 1",130,227.5]
[true,null,"Интерактив 2",120,210]
[true,null,"Интерактив 3",130,227.5]
[true,null,"Интерактив 4",100,175]
[null,null,null,null,"Итого на чел"]
[]
[]
[]
[]
[]
[]
[]
[false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Блок музеев и интерактивов"]

{"sheet":"Музеи","index":1,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Общее","Платник"]
[null,3,null,null,null,null,null,null,36,17]
[]
[]
[null,null,null,null,null,"Блок музеев ",null,null,null,null,null,null,null,null,{"$f":"O3","v":0}]
[null,null,null,null,null,"Музей Тысячелетия"]
[null,null,null,null,null,"Музей Естественной истор"]
[null,null,null,null,null,"Музей ИЗО "]
[null,null,null,null,null,"Музей истории КФУ"]
[null,null,null,null,null,"Музей Ушковой"]
[null,null,null,null,null,"Музей Тукая (в городе)"]
[null,null,null,null,null,"Музей Мусы Джалиля"]
[null,null,null,null,null,"Музей Баратынского"]
[null,null,null,null,null,"Музей Салиха Сайдашева"]
[null,null,null,null,null,"Музей Национальный РТ"]
[null,null,null,null,null,"Музей Соц Быта"]
[null,null,null,null,null,"Музей Исламской Культуры"]
[null,null,null,null,null,"Музей Советских автоматов"]
[null,null,null,null,null,"Музей ВОВ "]
[null,null,null,null,null,"Музей Самовара"]
[null,null,null,null,null,"Музей Сказок и легенд"]
[null,null,null,null,null,"Музей Чак Чака"]

{"sheet":"интерактивы","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"Интерактивы "]
[null,null,null,null,null,"Искусство завязывания Платка"]
[null,null,null,null,null,"Искусство в капле воды",null," "]
[null,null,null,null,null,"Искусство Арабской Калиграфии"]
[null,null,null,null,null,"Роспись по стеклу"]
[null,null,null,null,null,"Встреча (якын дуслар)"]
[null,null,null,null,null,"Тайны бабушкиного сундука"]
[null,null,null,null,null,"В поисках клада"]
[null,null,null,null,null,"Забавы по-татарски (туган авылым)"]
[null,null,null,null,null,"Аулак Ой (Музей Тукая)"]
[null,null,null,null,null,"Татарский страус (д. Ямашурма)"]
[null,null,null,null,null,"Казанский зоопарк"]
[null,null,null,null,null,"Дом занимательной науки и техники"]
[null,null,null,null,null,"Океанариум"]
[null,null,null,null,null,"Трогательный зоопарк (Петерб, 9)"]
[null,null,null,null,null,"Контактный зоопарк (Ривьера)"]
[null,null,null,null,null,"С высоты птичьего полета"]
[null,null,null,null,null,"Ипподром"]
[null,null,null,null,null,"Парк тропических бабочек"]
[null,null,null,null,null,"Стрелецкие забавы"]
[null,null,null,null,null,"Хаски парк"]
[null,null,null,null,null,"Планета развлечений (Парк Хаус)"]

{"sheet":"Объекты","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,"Интерактивы "]
[null,null,null,null,null,"Белокаменная крепость (Кремль)"]
[null,null,null,null,null,"Легенды и тайны (Марджани)",null," "]
[null,null,null,null,null,"Раифа "]
[null,null,null,null,null,"Цитадель завоевателя (Свияжск)"]
[null,null,null,null,null,"ВКМЗ"]
[null,null,null,null,null,"Чистопольские страницы"]
[null,null,null,null,null,"Иске Казань"]
[null,null,null,null,null,"Ночная экскурсия "]

{"sheet":"РАСЧЕТ","index":4,"n_rows":111,"n_cols":11,"rows_kept":111,"cut":false,"hidden":false,"merged":[[111,5,111,6],[103,5,103,6],[104,5,104,6],[105,5,105,6],[106,5,106,6],[107,5,107,6],[102,5,102,6],[86,5,86,8],[87,5,87,8],[88,5,88,8],[89,5,89,8],[90,5,90,8],[91,5,91,8],[92,5,92,8],[93,5,93,8],[94,5,94,8],[95,5,95,8],[96,5,96,8],[100,5,100,6],[101,5,101,6],[79,5,79,8],[56,5,56,8],[57,5,57,8],[65,5,65,8],[66,5,66,8],[67,5,67,8],[68,5,68,8],[70,5,70,8],[71,5,71,8],[72,5,72,8],[73,5,73,8],[74,5,74,8],[75,5,75,8],[76,5,76,8],[77,5,77,8],[78,5,78,8],[37,5,37,8],[38,5,38,8],[39,5,39,8],[44,5,44,8],[45,5,45,8],[32,5,32,8],[33,5,33,8],[34,5,34,8],[35,5,35,8],[36,5,36,8],[82,5,82,8],[83,5,83,8],[84,5,84,8],[85,5,85,8],[80,5,80,8],[81,5,81,8],[57,15,57,17],[69,5,69,8],[52,5,52,8],[53,5,53,8],[54,5,54,8],[55,5,55,8],[50,5,50,8],[51,5,51,8],[40,5,40,8],[41,5,41,8],[42,5,42,8],[43,5,43,8],[49,5,49,8],[46,5,46,8],[47,5,47,8],[48,5,48,8],[26,5,26,8],[27,5,27,8],[28,5,28,8],[17,5,17,8],[20,5,20,8],[21,5,21,8],[23,5,23,8],[24,5,24,8],[25,5,25,8],[15,5,15,8],[16,5,16,8],[22,5,22,8],[18,5,18,8],[19,5,19,8],[10,5,10,8],[11,5,11,8],[12,5,12,8],[13,5,13,8],[14,5,14,8]]}
[]
[]
[null,null,null,null,null,null,"Таблица расчета экскурсионного тура "]
[]
[null,null,null,null,null,"Кол-во",null,"Платник"]
[null,null,null,null,null,15,null,{"$f":"SUMIF(E11:E29,TRUE,K11:K29)","v":3000}]
[]
[]
[]
[null,null,null,null,null,"Интерактивы "]
[null,null,null,null,true,"Белокаменная крепость (Кремль)",null,null,null,2,1000]
[null,null,null,null,false,"Легенды и тайны (Марджани)",null,null,null,1,1000]
[null,null,null,null,false,"Раифа ",null,null,null,1,1000]
[null,null,null,null,true,"Цитадель завоевателя (Свияжск)",null,null,null,null,1000]
[null,null,null,null,true,"ВКМЗ",null,null,null,"Музей Природы",1000]
[null,null,null,null,false,"Чистопольские страницы",null,null,null,null,1000]
[null,null,null,null,null,"Иске Казань"]
[null,null,null,null,null,"Елабуга"]
[null,null,null,null,null,"Болгары"]
[null,null,null,null,null,"Чебоксары"]
[null,null,null,null,null,"Йошкар ола"]
[]
[null,null,null,null,null,"Ночная экскурсия "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Блок музеев "]
[null,null,null,null,null,"Музей Тысячелетия"]
[null,null,null,null,null,"Музей Естественной истор"]
[null,null,null,null,null,"Музей ИЗО "]
[null,null,null,null,null,"Музей истории КФУ"]
[null,null,null,null,null,"Музей Ушковой"]
[null,null,null,null,null,"Музей Тукая (в городе)"]
[null,null,null,null,null,"Музей Мусы Джалиля"]
[null,null,null,null,null,"Музей Баратынского"]
[null,null,null,null,null,"Музей Салиха Сайдашева"]
[null,null,null,null,null,"Музей Национальный РТ"]
[null,null,null,null,null,"Музей Соц Быта"]
[null,null,null,null,null,"Музей Исламской Культуры"]
[null,null,null,null,null,"Музей Советских автоматов"]
[null,null,null,null,null,"Музей ВОВ "]
[null,null,null,null,null,"Музей Самовара"]
[null,null,null,null,null,"Музей Сказок и легенд"]
[null,null,null,null,null,"Музей Чак Чака"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Интерактивы "]
[null,null,null,null,null,"Искусство завязывания Платка"]
[null,null,null,null,null,"Искусство в капле воды"]
[null,null,null,null,null,"Искусство Арабской Калиграфии"]
[null,null,null,null,null,"Роспись по стеклу"]
[null,null,null,null,null,"Встреча (якын дуслар)"]
[null,null,null,null,null,"Тайны бабушкиного сундука"]
[null,null,null,null,null,"В поисках клада"]
[null,null,null,null,null,"Забавы по-татарски (туган авылым)"]
[null,null,null,null,null,"Аулак Ой (Музей Тукая)"]
[null,null,null,null,null,"Татарский страус (д. Ямашурма)"]
[null,null,null,null,null,"Казанский зоопарк"]
[null,null,null,null,null,"Дом занимательной науки и техники"]
[null,null,null,null,null,"Океанариум"]
[null,null,null,null,null,"Трогательный зоопарк (Петерб, 9)"]
[null,null,null,null,null,"Контактный зоопарк (Ривьера)"]
[null,null,null,null,null,"С высоты птичьего полета"]
[null,null,null,null,null,"Ипподром"]
[null,null,null,null,null,"Парк тропических бабочек"]
[null,null,null,null,null,"Стрелецкие забавы"]
[null,null,null,null,null,"Хаски парк"]
[null,null,null,null,null,"Планета развлечений (Парк Хаус)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Обеды ",null,"Кол-во"]
[null,null,null,null,null,"Обед в городе 220"]
[null,null,null,null,null,"Обед в городе 250"]
[null,null,null,null,null,"Обед в городе 285"]
[null,null,null,null,null,"Мастер-класс "]
[null,null,null,null,null,"Обед Свияжск 350"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Транспорт",null,"Кол-во ч"]

{"sheet":"Обеды","index":5,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[21,5,21,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Обеды ",null,"Кол-во"]
[null,null,null,null,null,"Обед в городе 220"]
[null,null,null,null,null,"Обед в городе 250"]
[null,null,null,null,null,"Обед в городе 285"]
[null,null,null,null,null,"Мастер-класс "]
[null,null,null,null,null,"Обед Свияжск 350"]

{"sheet":"Транспорт","index":6,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[14,5,14,6],[15,5,15,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Транспорт",null,"Кол-во ч"]

{"sheet":"Справочник","index":7,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Белокаменная крепость (Кремль)","Легенды и тайны (Марджани)","Раифа ","Цитадель завоевателя (Свияжск)","ВКМЗ","Чистопольские страницы","Иске Казань","Ночная экскурсия "]
[1,1,1,1,"Музей Природы",1,1,1]
[2,null,null,null,"Дендрарий",2,null,2]
[3,null,null,null,null,3]