{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Settings","MP","Total table","Info","Price_Gorod","Price_Set"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Settings","index":0,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Агентство:","А"]
[null,null,null,null,"Клиент:","Конфетки",null,null,"Выбор станции"]
[null,null,null,null,"ЦА:",null,null,1,"Станция 1"]
[null,null,null,null,"География:","Сеть",null,2,"Станция 3"]
[null,null,null,null,"Медиа:","радио",null,3,"Станция 4"]
[null,null,null,null,"Формат:","прямая реклама",null,4]
[null,null,null,null,"Хронометраж:",20,null,5]
[null,null,null,null,"Дата начала РК:","2019-05-01",null,6]
[null,null,null,null,"Дата окончания РК:","2019-06-05",null,7]
[null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,10]

{"sheet":"MP","index":1,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[16,1,17,1],[16,8,17,8],[16,7,17,7],[16,4,17,4],[16,3,17,3],[16,2,17,2],[14,10,15,11],[38,0,38,4],[39,0,39,4],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[31,0,31,4],[32,0,32,3],[33,0,33,3],[14,0,15,3],[14,4,15,9],[16,0,17,0],[16,11,17,11],[16,10,17,10],[16,9,17,9]]}
[]
[]
[]
[]
[null,"Агентство:",{"$f":"Settings!F2","v":"А"}]
[null,"Клиент:",{"$f":"Settings!F3","v":"Конфетки"}]
[null,"ЦА:",{"$f":"Settings!F4","v":0}]
[null,"География:",{"$f":"Settings!F5","v":"Сеть"}]
[null,"Медиа:",{"$f":"Settings!F6","v":"радио"}]
[null,"Формат:",{"$f":"Settings!F7","v":"прямая реклама"}]
[null,"Хронометраж:",{"$f":"Settings!F8","v":20}]
[null,"Дата начала РК:",{"$f":"Settings!F9","v":"2019-05-01"}]
[null,"Дата окончания РК:",{"$f":"Settings!F10","v":"2019-06-05"}]
[]
[null,null,null,null,null,null,null,null,null,null,"AQH, %"]
[]
["Время выхода","Хронометраж","Стоимость 30 сек.","Коэфф. хронометража","Стоимость 1 выхода",null,null,"Кол-во выходов","Кол-во секунд","Стоимость, грн","Пн-Пт","Сб-Вс"]
[]
["7:00-8:00",null,null,null,{"$f":"C19*D19","v":0},null,null,{"$f":"SUM(F19:G19)","v":0},{"$f":"SUM(H19*B19)","v":0},{"$f":"H19*E19","v":0}]
["8:00-9:00",null,null,null,0,null,null,0,0,0]
["9:00-10:00",null,null,null,0,null,null,0,0,0]
["10:00-11:00",null,null,null,{"$f":"C22*D22","v":0},null,null,0,0,0]
["11:00-12:00",null,null,null,0,null,null,0,0,0]
["12:00-13:00",null,null,null,0,null,null,0,0,0]
["13:00-14:00",null,null,null,0,null,null,0,0,0]
["14:00-15:00",null,null,null,0,null,null,0,0,0]
["15:00-16:00",null,null,null,0,null,null,0,0,0]
["16:00-17:00",null,null,null,0,null,null,0,0,0]
["17:00-18:00",null,null,null,0,null,null,0,0,0]
["18:00-19:00",null,null,null,0,null,null,0,0,0]
["19:00-20:00",null,null,null,0,null,null,0,0,0]
["Total # of spots",null,null,null,null,{"$f":"COUNTA(F19:F31)","v":0},{"$f":"COUNTA(G19:G31)","v":0},{"$f":"SUM(H19:H31)","v":0},{"$f":"SUM(I19:I31)","v":0},{"$f":"SUM(J19:J31)","v":0}]
["Наценка за позиционирование",null,null,null,0,null,null,null,null,{"$f":"(J32*(1+E33))-J32","v":0}]
["Сезонная наценка",null,null,null,0,null,null,null,null,{"$f":"(SUM(J32:J33)*(1+E34))-SUM(J32:J33)","v":0}]
["Скидка за сплит",null,null,null,0,null,null,null,null,{"$f":"(SUM(J32:J34)*(1-E35))-SUM(J32:J34)","v":0}]
["Скидка за off-прайм",null,null,null,0,null,null,null,null,{"$f":"(J32*(1-E36))-J32","v":0}]
["Скидка за выходные",null,null,null,0,null,null,null,null,{"$f":"(J32*(1-E37))-J32","v":0}]
["Скидка за бюджет",null,null,null,0,null,null,null,null,{"$f":"(SUM(J32:J37)*(1-E38))-SUM(J32:J37)","v":0}]
["Стоимость, грн без НДС",null,null,null,null,null,null,null,null,{"$f":"SUM(J32:J38)","v":0}]
["Стоимость, грн с НДС",null,null,null,null,null,null,null,null,{"$f":"J39*1.2","v":0}]

{"sheet":"Total table","index":2,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,1,6],[1,7,1,8],[1,1,3,1]]}
[]
[null,"Станция","Май",null,null,null,null,"Июнь"]
[null,null,"01.05.2019-\n05.05.2019","06.05.2019-\n12.05.2019","13.05.2019-\n19.05.2019","20.05.2019-\n26.05.2019","27.05.2019-\n31.05.2019","01.06.2019-\n02.06.2019","03.06.2019-\n05.06.2019"]
[null,null,"Ср-Вс","Пн-Вс","Пн-Вс","Пн-Вс","Пн-Пт","Сб-Вс","Пн-Ср"]
[null,"Станция 1",26,33,0,0,25,12,0]
[null,"Станция 3",0,0,36,36,24,10,22]
[null,"Станция 4",20,36,36,36,0,0,24]
[null,"Всего",{"$f":"SUM(C5:C7)","v":46},{"$f":"SUM(D5:D7)","v":69},{"$f":"SUM(E5:E7)","v":72},{"$f":"SUM(F5:F7)","v":72},{"$f":"SUM(G5:G7)","v":49},{"$f":"SUM(H5:H7)","v":22},{"$f":"SUM(I5:I7)","v":46}]

{"sheet":"Info","index":3,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Коэфф. хронометража",null,null,null,null,null,"Агентство","География:","Формат:","Станции"]
[null,null,null,null,null,null,null,"А","Город","прямая реклама","Станция 1"]
[null,"10\"","15\"","20\"","25\"","30\"",null,"Б","Сеть","спонсорство","Станция 2"]
[null,0.4,0.6,0.8,0.95,1,null,"В",null,null,"Станция 3"]
[null,null,null,null,null,null,null,null,null,null,"Станция 4"]
[null,null,null,null,null,null,null,null,null,null,"Станция 5"]
[null,null,null,null,null,null,null,null,null,null,"Станция 6"]
[null,null,null,null,null,null,null,null,null,null,"Станция 7"]
[null,null,null,null,null,null,null,null,null,null,"Станция 8"]
[null,null,null,null,null,null,null,null,null,null,"Станция 9"]
[null,null,null,null,null,null,null,null,null,null,"Станция 10"]

{"sheet":"Price_Gorod","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Станция 1","Станция 2","Станция 3","Станция 4","Станция 5","Станция 6","Станция 7","Станция 8","Станция 9","Станция 10"]
["7:00-8:00",100,200,300,400,500,600,700,800,900,1000]
["8:00-9:00",100,200,300,400,500,600,700,800,900,1000]
["9:00-10:00",100,200,300,400,500,600,700,800,900,1000]
["10:00-11:00",100,200,300,400,500,600,700,800,900,1000]
["11:00-12:00",100,200,300,400,500,600,700,800,900,1000]
["12:00-13:00",100,200,300,400,500,600,700,800,900,1000]
["13:00-14:00",100,200,300,400,500,600,700,800,900,1000]
["14:00-15:00",100,200,300,400,500,600,700,800,900,1000]
["15:00-16:00",100,200,300,400,500,600,700,800,900,1000]
["16:00-17:00",100,200,300,400,500,600,700,800,900,1000]
["17:00-18:00",100,200,300,400,500,600,700,800,900,1000]
["18:00-19:00",100,200,300,400,500,600,700,800,900,1000]
["19:00-20:00",100,200,300,400,500,600,700,800,900,1000]

{"sheet":"Price_Set","index":5,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Станция 1","Станция 2","Станция 3","Станция 4","Станция 5","Станция 6","Станция 7","Станция 8","Станция 9","Станция 10"]
["7:00-8:00",100,200,300,400,500,600,700,800,900,1000]
["8:00-9:00",100,200,300,400,500,600,700,800,900,1000]
["9:00-10:00",100,200,300,400,500,600,700,800,900,1000]
["10:00-11:00",100,200,300,400,500,600,700,800,900,1000]
["11:00-12:00",100,200,300,400,500,600,700,800,900,1000]
["12:00-13:00",100,200,300,400,500,600,700,800,900,1000]
["13:00-14:00",100,200,300,400,500,600,700,800,900,1000]
["14:00-15:00",100,200,300,400,500,600,700,800,900,1000]
["15:00-16:00",100,200,300,400,500,600,700,800,900,1000]
["16:00-17:00",100,200,300,400,500,600,700,800,900,1000]
["17:00-18:00",100,200,300,400,500,600,700,800,900,1000]
["18:00-19:00",100,200,300,400,500,600,700,800,900,1000]
["19:00-20:00",100,200,300,400,500,600,700,800,900,1000]