{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["план","база","календарь","Лист1 (2)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":4,"defined_names":13,"comments":0,"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":"план","index":0,"n_rows":52,"n_cols":23,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,7,2,9],[3,7,3,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,{"$f":"B7","v":"00:00:00"},"2015-04-22",null,null,null,null,null,null,null,null,null,null,"Б/НАЛ"]
["Исполнитель:","ООО \"Стильное Радио\"",null,null,null,null,null,"Название ролика:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"БАРТЕР"]
["Заказчик:",null,null,null,null,null,null,"Хронометраж:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"БЕСПЛАТНО"]
["Торговая марка (Бренд):",null,null,null,null,null,null,"Сумма заявки:",null,{"$f":"SUMIF(A10:A52,1,N10:N52)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Н-БАРТЕР"]
["Клиент-менеджер:",null,null,null,null,null,null,"Скидка:",null,{"$f":"SUMIF(O10:O52,\"<>0\",P10:P52)","v":0}]
["Дата начала проката:",null,null,{"$f":"B8-B7+1","v":1},null,null,null,"ИТОГО:",null,{"$f":"J5-J6","v":0}]
["Дата оконч. проката:"]
["выбор                         (для выбора центра поставить \"1\" )",null,"Коэффициент","Количесто часов трансляции в день","Количество дней","Коэф время","Часы Коэф","Количество выходов в час","Выход Коэф","Количество трансляций роликов в день","Всего выходов","Стоимость за 1 выход","Стоимость за 1 день","Итого стоимость","скидка (%)","скидка (руб.)","ИТОГО","ФОРМА РАСЧЕТА","примечание"]
[null,"г. Владивосток, ТК \"Дальприбор\" (ул. Бородинская, 46/50; вещание на УЛИЦЕ)",{"$f":"IF(ISNA(VLOOKUP(B10,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B10,база!$A$4:$B$53,2,FALSE))","v":12},10,30,{"$f":"IF(ISNA(VLOOKUP(E10,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E18,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D10,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D10,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H10,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H10,база!$E$4:$F$6,2,FALSE))","v":"0"},{"$f":"D10*H10","v":30},{"$f":"E10*J10","v":900},12,{"$f":"J10*L10","v":360},{"$f":"K10*L10","v":10800},null,{"$f":"N10*O10/100","v":0},{"$f":"N10-P10","v":10800}]
[null,"г. Владивосток, ТЦ \"Виктория\" (ул. Бородинская, 46/50; внутр.)",{"$f":"IF(ISNA(VLOOKUP(B11,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B11,база!$A$4:$B$53,2,FALSE))","v":10},8,30,{"$f":"IF(ISNA(VLOOKUP(E11,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D11,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D11,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H11,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H11,база!$E$4:$F$6,2,FALSE))","v":"0"},24,720,10,240,7200,null,0,7200]
[null,"г. Владивосток, ТЦ \"Альянс\" (ул. Бородинская 46/50; внутр.)",{"$f":"IF(ISNA(VLOOKUP(B12,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B12,база!$A$4:$B$53,2,FALSE))","v":5},8,30,{"$f":"IF(ISNA(VLOOKUP(E12,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D12,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D12,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H12,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H12,база!$E$4:$F$6,2,FALSE))","v":"0"},24,720,6,144,4320,null,0,4320]
[null,"г. Владивосток, ТЦ \"Универсам\" (ул. Русская, 44; внутр. и внеш.)",{"$f":"IF(ISNA(VLOOKUP(B13,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B13,база!$A$4:$B$53,2,FALSE))","v":7.1},9,30,{"$f":"IF(ISNA(VLOOKUP(E13,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D13,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D13,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H13,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H13,база!$E$4:$F$6,2,FALSE))","v":"0"},27,810,8,216,6480,null,0,6480]
[null,"г. Владивосток, ПТК Луговая (ул. Луговая, 18)",null,9,30,{"$f":"IF(ISNA(VLOOKUP(E14,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D14,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D14,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H14,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H14,база!$E$4:$F$6,2,FALSE))","v":"0"},{"$f":"D14*H14","v":27},{"$f":"E14*J14","v":810},10,{"$f":"J14*L14","v":270},{"$f":"K14*L14","v":8100},null,{"$f":"N14*O14/100","v":0},{"$f":"N14-P14","v":8100}]
[null,"г. Владивосток, ТЦ \"Первореченский\"- (Острякова,13)",{"$f":"IF(ISNA(VLOOKUP(B15,[2]база!$A$4:$B$71,2,FALSE)),\"0\",VLOOKUP(B15,[2]база!$A$4:$B$71,2,FALSE))","v":"0"},9,30,{"$f":"IF(ISNA(VLOOKUP(E15,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D15,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D15,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H15,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H15,база!$E$4:$F$6,2,FALSE))","v":"0"},27,810,10,270,8100,null,0,8100]
[null,"г. Владивосток, Дизайн студия \"Заря\"(пр-т 100 лет Вл-ку 155/2; внутр и внешн)",{"$f":"IF(ISNA(VLOOKUP(B16,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B16,база!$A$4:$B$53,2,FALSE))","v":3.3},10,30,{"$f":"IF(ISNA(VLOOKUP(E16,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D16,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D16,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H16,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H16,база!$E$4:$F$6,2,FALSE))","v":"0"},30,900,6,180,5400,null,0,5400]
[null,"г. Владивосток ТЦ \"Гранд\" (ул. Русская,46 внутр.)",null,9,30,null,null,3,null,27,810,8,216,6480,null,0,6480]
[null,"г. Владивосток, ТЦ \"Искра\"- переход (п-т 100 Владивостоку, внутр)",{"$f":"IF(ISNA(VLOOKUP(B18,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B18,база!$A$4:$B$53,2,FALSE))","v":3.3},10,30,{"$f":"IF(ISNA(VLOOKUP(E18,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E18,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D18,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D18,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H18,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H18,база!$E$4:$F$6,2,FALSE))","v":"0"},30,{"$f":"E18*J18","v":900},6,180,5400,null,0,5400]
[null,"г. Владивосток , ул Светланская(район музей Арсеньева)",null,10,30,null,null,3,null,30,{"$f":"E19*J19","v":900},15,450,{"$f":"K19*L19","v":13500},null,{"$f":"N19*O19/100","v":0},{"$f":"N19-P19","v":13500}]
[null,"г. Владивосток , ул Семеновская площадь(на ТЦ \"Клевер Хаус\")",null,10,30,null,null,3,null,30,900,25,750,22500,null,0,22500]
[null,"г. Владивосток, Набережная спортивной гавани, тер. от аллеи до СК \"Олимпиец\"",null,10,30,null,null,3,null,30,900,15,450,13500,null,0,13500]
[null,"г. Владивосток, ТЦ \"Первомай\"(р-н Чуркин, перед  Зеленым островом)",null,10,30,null,null,3,null,30,900,15,450,13500,null,0,13500]
[null,"г. Владивосток, ТЦ \"Снеговая падь\"(ул. Анны Щетининой,21)",null,10,30,null,null,3,null,30,900,6,180,5400,null,0,5400]
[null,"г. Вадивосток, ТК \"Спортивная\" (ул. Фадеева, 1а)",null,9,30,null,null,3,null,{"$f":"D24*H24","v":27},{"$f":"E24*J24","v":810},10,{"$f":"J24*L24","v":270},{"$f":"K24*L24","v":8100},null,{"$f":"N24*O24/100","v":0},{"$f":"N24-P24","v":8100}]
[null,"г. Владивосток, ТЦ \"Ярмарка на Крыгина\" (ул. Крыгина, 23)",null,9,30,null,null,3,null,27,810,6,162,4860,null,0,4860]
[null,"г. Владивосток, Авторынок \"Зеленый Угол\" (ул. Нейбута)",null,6,30,null,null,3,null,{"$f":"H26*D26","v":18},{"$f":"J26*E26","v":540},22,{"$f":"L26*J26","v":396},{"$f":"L26*K26","v":11880},null,{"$f":"N26*O26/100","v":0},{"$f":"N26-P26","v":11880}]
[null,"г. Владивосток, ТЦ «КИТАЙ ГОРОД» (Выселковая)",null,10,30,null,null,3,null,30,900,15,450,13500,null,{"$f":"N27*O27/100","v":0},{"$f":"N27-P27","v":13500}]
[null,"г. Артем. ТЦ \"Авиатор\" (ул. Фрунзе, 32а. Внутр. Внеш.)",{"$f":"IF(ISNA(VLOOKUP(B28,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B28,база!$A$4:$B$53,2,FALSE))","v":"0"},10,30,{"$f":"IF(ISNA(VLOOKUP(E28,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D28,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D28,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H28,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H28,база!$E$4:$F$6,2,FALSE))","v":"0"},{"$f":"D28*H28","v":30},900,8,240,{"$f":"K28*L28","v":7200},null,{"$f":"N28*O28/100","v":0},{"$f":"N28-P28","v":7200}]
[null,"г. Артем.ТЦ \"Городской\" (ул. Кирова 9/1. внутр., внеш.)",{"$f":"IF(ISNA(VLOOKUP(B29,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B29,база!$A$4:$B$53,2,FALSE))","v":"0"},8,30,{"$f":"IF(ISNA(VLOOKUP(E29,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D29,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D29,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H29,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H29,база!$E$4:$F$6,2,FALSE))","v":"0"},24,720,10,240,7200,null,0,7200]
[null,"г. Артем. Муницмпальный РЫНОК (ул. Пионерская,1. внеш.)",null,7,30,null,null,3,null,21,630,4.76,{"$f":"J30*L30","v":99.96},2998.7999999999997,null,{"$f":"N30*O30/100","v":0},{"$f":"N30-P30","v":2998.7999999999997}]
[null,"г. Артем.п. Угловое ТЦ \"Регион\" (ул. 1-я Рабочая, 16. внутр., внеш.)",{"$f":"IF(ISNA(VLOOKUP(B31,[3]база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B31,[3]база!$A$4:$B$53,2,FALSE))","v":"0"},8,30,{"$f":"IF(ISNA(VLOOKUP(E31,[3]база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP([3]план!#REF!,[3]база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D31,[3]база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D31,[3]база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H31,[3]база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H31,[3]база!$E$4:$F$6,2,FALSE))","v":"0"},{"$f":"D31*H31","v":24},{"$f":"E31*J31","v":720},10,{"$f":"J31*L31","v":240},{"$f":"K31*L31","v":7200},null,{"$f":"N31*O31/100","v":0},{"$f":"N31-P31","v":7200}]
[null,"г. Артем.Супермаркет \"№ 90\" (ул. Фрунзе, 48)",{"$f":"IF(ISNA(VLOOKUP(B32,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B32,база!$A$4:$B$53,2,FALSE))","v":"0"},10,30,{"$f":"IF(ISNA(VLOOKUP(E32,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E12,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D32,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D32,база!$C$4:$D$25,2,FALSE))","v":0},6,{"$f":"IF(ISNA(VLOOKUP(H32,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H32,база!$E$4:$F$6,2,FALSE))","v":"0"},60,1800,1.34,80.400000000000006,2412,null,0,2412]
[null,"г. Артем.Супермаркет \"Парус\" (ул. Кирова, 19)",{"$f":"IF(ISNA(VLOOKUP(B33,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B33,база!$A$4:$B$53,2,FALSE))","v":"0"},10,30,{"$f":"IF(ISNA(VLOOKUP(E33,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E13,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D33,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D33,база!$C$4:$D$25,2,FALSE))","v":0},6,{"$f":"IF(ISNA(VLOOKUP(H33,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H33,база!$E$4:$F$6,2,FALSE))","v":"0"},60,1800,1.34,80.400000000000006,2412,null,0,2412]
[null,"г. Артем.Супермаркет \"Юлия\" (ул. Кирова, 1/1)",{"$f":"IF(ISNA(VLOOKUP(B34,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B34,база!$A$4:$B$53,2,FALSE))","v":"0"},10,30,{"$f":"IF(ISNA(VLOOKUP(E34,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D34,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D34,база!$C$4:$D$25,2,FALSE))","v":0},6,{"$f":"IF(ISNA(VLOOKUP(H34,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H34,база!$E$4:$F$6,2,FALSE))","v":"0"},60,1800,1.34,80.400000000000006,2412,null,0,2412]
[null,"г. Артем.Супрмаркет \"Алмаз\" (ул. Кирова, 72)",{"$f":"IF(ISNA(VLOOKUP(B35,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B35,база!$A$4:$B$53,2,FALSE))","v":"0"},10,30,{"$f":"IF(ISNA(VLOOKUP(E35,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E10,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D35,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D35,база!$C$4:$D$25,2,FALSE))","v":0},6,{"$f":"IF(ISNA(VLOOKUP(H35,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H35,база!$E$4:$F$6,2,FALSE))","v":"0"},60,1800,1.34,80.400000000000006,2412,null,0,2412]
[null,"г. Находка, ТЦ \"Купеческий\" (г. Находка ул. Сидоренко, 1. внутр., внеш.)",{"$f":"IF(ISNA(VLOOKUP(B36,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B36,база!$A$4:$B$53,2,FALSE))","v":"0"},10,30,{"$f":"IF(ISNA(VLOOKUP(E36,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D36,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D36,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H36,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H36,база!$E$4:$F$6,2,FALSE))","v":"0"},30,900,10,300,9000,null,0,9000]
[null,"г. Находка \"КАНТ и Ко\" (ул. Находкинский проспект, 5)",null,10,30,null,null,3,null,30,900,7,210,6300,null,0,6300]
[null,"г. Находка ТЦ \"Апельсин\" (ул. Школьная, 1б)",null,10,30,null,null,3,null,30,900,8,240,7200,null,0,7200]
[null,"г. Большой Камень.ТЦ \"Айсберг\" (ул. Аллея труда, 35 а)",null,10,30,{"$f":"IF(ISNA(VLOOKUP(E39,[4]база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP([4]план!#REF!,[4]база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D39,[4]база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D39,[4]база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H39,[4]база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H39,[4]база!$E$4:$F$6,2,FALSE))","v":"0"},{"$f":"D39*H39","v":30},{"$f":"E39*J39","v":900},6,{"$f":"J39*L39","v":180},{"$f":"K39*L39","v":5400},null,0,{"$f":"N39-P39","v":5400}]
[null,"г. Уссурийск. ТЦ Новый ГУМ (ул. Чичерина, 105)",null,10,30,null,null,3,null,30,900,8,240,7200,null,0,7200]
[null,"г. Уссурийск, ТЦ Богатырь (ул. Чичерина,91-а)",{"$f":"IF(ISNA(VLOOKUP(B41,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B41,база!$A$4:$B$53,2,FALSE))","v":3},10,30,{"$f":"IF(ISNA(VLOOKUP(E41,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!#REF!,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D41,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D41,база!$C$4:$D$25,2,FALSE))","v":0},5,{"$f":"IF(ISNA(VLOOKUP(H41,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H41,база!$E$4:$F$6,2,FALSE))","v":"0"},50,1500,6.5,325,9750,null,0,9750]
[null,"г. Уссурийск, Центральный рынок (ул. Чичерина)",{"$f":"IF(ISNA(VLOOKUP(B42,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B42,база!$A$4:$B$53,2,FALSE))","v":3},10,30,{"$f":"IF(ISNA(VLOOKUP(E42,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E19,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D42,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D42,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H42,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H42,база!$E$4:$F$6,2,FALSE))","v":"0"},30,900,6.5,195,5850,null,0,5850]
[null,"г. Уссурийск. ТЦ \"Антарес\" (ул. Некрасова, 86)",null,10,30,null,null,3,null,{"$f":"H43*D43","v":30},{"$f":"J43*E43","v":900},8,{"$f":"L43*J43","v":240},{"$f":"L43*K43","v":7200},null,{"$f":"N43*O43/100","v":0},{"$f":"N43-P43","v":7200}]
[null,"г. Уссурийск. ТЦ Москва (ул. Суханова, 52)",null,10,30,null,null,2,null,{"$f":"H44*D44","v":20},{"$f":"J44*E44","v":600},13,{"$f":"L44*J44","v":260},{"$f":"L44*K44","v":7800},null,{"$f":"N44*O44/100","v":0},{"$f":"N44-P44","v":7800}]
[null,"г. Хабаровск. ТЦ \"Али Восток\" (пр.60 лет Октября, 156. внутр.)",{"$f":"IF(ISNA(VLOOKUP(B45,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B45,база!$A$4:$B$53,2,FALSE))","v":"0"},8,30,{"$f":"IF(ISNA(VLOOKUP(E45,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E18,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D45,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D45,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H45,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H45,база!$E$4:$F$6,2,FALSE))","v":"0"},24,720,5,120,3600,null,0,3600]
[null,"г. Хабаровск. ТЦ \"Смайл-Март\" (ул. П. Морозова, 118. внутр)",{"$f":"IF(ISNA(VLOOKUP(B46,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B46,база!$A$4:$B$53,2,FALSE))","v":"0"},10,30,{"$f":"IF(ISNA(VLOOKUP(E46,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E27,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D46,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D46,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H46,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H46,база!$E$4:$F$6,2,FALSE))","v":"0"},30,900,8,240,7200,null,0,7200]
[null,"г. Хабаровск. ТЦ \"ЭВР\" (ул.Суворова,51.внутр.)",{"$f":"IF(ISNA(VLOOKUP(B47,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B47,база!$A$4:$B$53,2,FALSE))","v":"0"},10,30,{"$f":"IF(ISNA(VLOOKUP(E47,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E29,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D47,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D47,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H47,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H47,база!$E$4:$F$6,2,FALSE))","v":"0"},30,900,7,210,6300,null,0,6300]
[null,"г. Хабаровск. ТЦ \"Южный парк\" (ул. Суворова,25, внутр.,внеш.)",{"$f":"IF(ISNA(VLOOKUP(B48,база!$A$4:$B$53,2,FALSE)),\"0\",VLOOKUP(B48,база!$A$4:$B$53,2,FALSE))","v":"0"},11,30,{"$f":"IF(ISNA(VLOOKUP(E48,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E28,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D48,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D48,база!$C$4:$D$25,2,FALSE))","v":"0"},3,{"$f":"IF(ISNA(VLOOKUP(H48,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H48,база!$E$4:$F$6,2,FALSE))","v":"0"},33,990,10,330,9900,null,0,9900]
[null,"г.Хабаровск. ТЦ \"Универсам\" (ул.Краснореченская, 44. внутр.)",null,10,30,{"$f":"IF(ISNA(VLOOKUP(E49,база!$G$4:$G$58,2,FALSE)),\"0\",VLOOKUP(план!E29,база!$G$4:$G$58,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(D49,база!$C$4:$D$25,2,FALSE)),\"0\",VLOOKUP(D49,база!$C$4:$D$25,2,FALSE))","v":0},3,{"$f":"IF(ISNA(VLOOKUP(H49,база!$E$4:$F$6,2,FALSE)),\"0\",VLOOKUP(H49,база!$E$4:$F$6,2,FALSE))","v":"0"},{"$f":"D49*H49","v":30},{"$f":"E49*J49","v":900},6,{"$f":"J49*L49","v":180},{"$f":"K49*L49","v":5400},null,{"$f":"N49*O49/100","v":0},{"$f":"N49-P49","v":5400}]
[null,"г. Хабаровск. ТД \"Домострой\" (ул. Пр-т 60 лет Октября, 158/1. внеш.)",null,10,30,null,null,3,null,{"$f":"D50*H50","v":30},900,5,150,4500,null,0,4500]
[null,"ИЗГОТОВЛЕНИЕ РОЛИКА",null,null,null,null,null,null,null,null,null,null,null,1500,null,0,1500]
[null,"КРЕАТИВ",null,null,null,null,null,null,null,null,null,null,null,500,null,0,500]

{"sheet":"база","index":1,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["наименование","тариф","Кол-во часов","Часы коэф","Сколько выходов","Выход Коэф","Количество дней"]
[{"$f":"план!B10","v":"г. Владивосток, ТК \"Дальприбор\" (ул. Бородинская, 46/50; вещание на УЛИЦЕ)"}]
["наименование","тариф","Кол-во часов","Часы коэф","Сколько выходов","Выход Коэф","Количество дней"]
["г. Владивосток, Дизайн студия \"Заря\"(пр-т 100 лет Вл-ку 155/2; внутр и внешн)",3.3,10,null,null,null,30]
["г. Находка, ТЦ \"Купеческий\" (г. Находка ул. Сидоренко, 1)",10,8,null,null,null,30]
["г. Находка Ц ГУМ (Находкинский проспект, 60)",8,10,null,null,null,30]
["г. Находка \"КАНТ и Ко\" (ул. Находкинский проспект, 5)",2.8,10,null,null,null,30]
["ТЦ \"Европейский\" (ул. Русская 19 В; внутр. и внеш.)",9,10,null,null,null,30]
["г. Владивосток ТЦ \"Максим\" (Пр-т 100 лет Владивостоку, 57; внутр. и внеш.)",6.5,10,null,null,null,30]
["г. Владивосток, ТЦ \"Универсам\" (ул. Русская, 44; внутр. и внеш.)",7.1,9,null,null,null,30]
["г. Владивосток, ТЦ \"Виктория\" (ул. Бородинская, 46/50; внутр.)",10,8,null,null,null,30]
["г. Владивосток, ТК \"Дальприбор\" (ул. Бородинская, 46/50; вещание на УЛИЦЕ)",12,8,null,null,null,30]
["г. Владивосток, ТЦ  \"Россиянка\"( ул. Русская, 87  А; внутр.)",8,10,null,null,null,30]
["г. Владивосток, ТД ГУМ (ул.Светланская,  35; внешн.)",3.5,10,null,null,null,30]
["г. Владивосток, ТЦ \"Пасифик\" (ул. Бородинская 46/50; внутр.)",null,8,null,null,null,30]
["г. Владивосток, ТЦ \"Альянс\" (ул. Бородинская 46/50; внутр.)",5,8,null,null,null,30]
["г. Владивосток, ТЦ \"Искра\"- переход (п-т 100 Владивостоку, внутр)",3.3,10,null,null,null,30]
["г. Владивосток, ТЦ Черемушки (ул. Запорожская; внутр. и внеш)",8,10,null,null,null,30]
["г. Владивосток ТЦ \"Надежда\" (ул. Фадеева, 1а)",6,10,null,null,null,30]
["г. Владивосток Супермаркет \"Маркет +\" (ул. Верхнепортовая, 2г; внутр. и внеш.)",6,10,null,null,null,30]
["Супермаркет  \" Fresh 25\" (Пр-т Красного Знамени, 86; внутр.)",3,10,null,null,null,30]
["г. Уссурийск, Центральный рынок (ул. Чичерина)",3,10,null,null,null,30]
["г. Уссурийск, ТЦ Богатырь (ул. Чичерина,91-а)",3,10,null,null,null,30]
["г. Находка ТЦ \"Апельсин\" (ул. Школьная, 1б)",7,10,null,null,null,30]
["г. Находка ТЦ Тихоокеанский ( Находкинский проспект, 36)",7,10,null,null,null,30]
["Супермаркет  \" Fresh 25\" (ул. Карбышева, 32; внутр. и внеш.)",3,10,null,null,null,30]
["ИЗГОТОВЛЕНИЕ РОЛИКА",3,10,null,null,null,30]
["КРЕАТИВ",3.3,10,null,null,null,30]
["г. Хабаровск. ТЦ \"ЭВР\"",null,10,null,null,null,30]
["Артем. ТЦ \"Авиатор\" (ул. Фрунзе, 32а)",10,6,null,null,null,30]
["г. Владивосток, Рынок \"Первая Речка\" (ул. Острякова, 13)",5.6,10,null,null,null,30]
["г. Хабаровск. ТЦ \"Смайл-Март\" (ул. П. Морозова, 118)",null,10,null,null,null,30]
["г. Находка. Супермаркет \"ВЛ-МАРТ\" (Бульвар Энтузиастов, 2)",null,10,null,null,null,30]
["г. Уссурийск. ТЦ Белая гора (ул. Плеханова, 61,внутр. и внеш.)",null,10,null,null,null,30]
["г. Хабаровск. ТЦ \"Али Восток\" (пр.60 лет Октября, 156)",null,10,null,null,null,30]
["г. Хабаровс.Супермаркет \"ВЛ-МАРТ\" (ул. Ворошилова, 35б)",null,10,null,null,null,30]
["Артем.Супермаркет \"Гурман\" (пл. Ленина, 7/2)",null,10,null,null,null,30]
["Артем.Супермаркет \"№ 90\" (ул. Фрунзе, 48)",null,10,null,null,null,30]
["Артем.Супрмаркет \"Алмаз\" (ул. Кирова, 72)",null,10,null,null,null,30]
["Артем.Супермаркет \"Парус\" (ул. Кирова, 19)",null,10,null,null,null,30]
["Уссурийск. ТЦ Новый ГУМ (ул. Чичерина, 105)",8,10,null,null,null,30]
["Артем.ТЦ \"Городской\" (ул. Кирова 9/1)",null,10,null,null,null,30]
["г. Хабаровск. ТД \"Домострой\" (ул. Пр-т 60 лет Октября, 158/1)",null,10,null,null,null,30]
["Дискаунтер \"Унимарт\" (Снеговая, 4; внутр. и внеш.)",null,10,null,null,null,30]
["г. Хабаровск. ТЦ \"Южный парк\"",null,10,null,null,null,30]
["г. Владивосток, Сеть Гипермаркетов АПТЕК \"Монастырев и Ко\" (ул Русская 94-а, внутр)",0,10,null,null,null,30]
["г. Владивосток, Сеть Гипермаркетов АПТЕК \"Монастырев и Ко\" (пр 100 лет Вл-ку 20, внутр)",null,10,null,null,null,30]
["Гипермаркет \"Влазер\" (Океанский проспект, 52 а; внутр. и внешн.)",null,10,null,null,null,30]
["г. Владивосток, Сеть Гипермаркетов АПТЕК \"Монастырев и Ко\" (ул.Вязова 1-в, внутр)",null,10,null,null,null,30]
["г. Владивосток, Сеть Гипермаркетов АПТЕК \"Монастырев и Ко\" (ул.Шилкинская 10-а, внутр)",1,10,null,null,null,30]
["г. Владивосток ТЦ \"Sweet Home\" (Бородинская 46/50) ВИДЕОМОНИТОР",null,18,null,null,null,30]
["Артем.Супермаркет \"Юлия\" (ул. Кирова, 1/1)",null,10,null,null,null,30]
["г. Владивосток, ТЦ Центральный (ул. Светланская, 29; внутр и внеш)",0,10,null,null,null,30]
["Артем.Супермаркет \"Юлия\" (ул. Кирова, 1/1)",null,10,null,null,null,30]

{"sheet":"календарь","index":2,"n_rows":39,"n_cols":30,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,25],[2,2,2,24],[3,2,3,24],[4,2,4,8],[4,9,11,9],[4,10,4,16],[4,17,11,17],[4,18,4,24],[12,2,12,24],[13,2,13,8],[13,9,20,9],[13,10,13,16],[13,17,20,17],[13,18,13,24],[21,2,21,24],[22,2,22,8],[22,9,29,9],[22,10,22,16],[22,17,29,17],[22,18,22,24],[39,2,39,24],[30,2,30,24],[31,2,31,8],[31,9,38,9],[31,10,31,16],[31,17,38,17],[31,18,31,24]]}
[8]
[2]
[null,null,2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()-1","v":"2015-12-06T16:06:19.270"},{"$f":"ROUND(AB3,0)","v":42345},41967]
[]
[null,null,{"$f":"DATE(theyear,1,1)","v":"2016-01-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,2,1)","v":"2016-02-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,3,1)","v":"2016-03-01"}]
[null,null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","","2016-01-01","2016-01-02",null,{"$f":"IF(MONTH(DATE(YEAR(K5),MONTH(K5),1))<>MONTH(DATE(YEAR(K5),MONTH(K5),1)-(WEEKDAY(DATE(YEAR(K5),MONTH(K5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(K5),MONTH(K5),1)-(WEEKDAY(DATE(YEAR(K5),MONTH(K5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"2016-02-01","2016-02-02","2016-02-03","2016-02-04","2016-02-05","2016-02-06",null,{"$f":"IF(MONTH(DATE(YEAR(S5),MONTH(S5),1))<>MONTH(DATE(YEAR(S5),MONTH(S5),1)-(WEEKDAY(DATE(YEAR(S5),MONTH(S5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(S5),MONTH(S5),1)-(WEEKDAY(DATE(YEAR(S5),MONTH(S5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","2016-03-01","2016-03-02","2016-03-03","2016-03-04","2016-03-05"]
[null,null,"2016-01-03","2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09",null,"2016-02-07","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-13",null,"2016-03-06","2016-03-07","2016-03-08","2016-03-09","2016-03-10","2016-03-11","2016-03-12"]
[null,null,"2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","2016-01-16",null,"2016-02-14","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-20",null,"2016-03-13","2016-03-14","2016-03-15","2016-03-16","2016-03-17","2016-03-18","2016-03-19"]
[null,null,"2016-01-17","2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23",null,"2016-02-21","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27",null,"2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26"]
[null,null,"2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28","2016-01-29","2016-01-30",null,"2016-02-28","2016-02-29","","","","","",null,"2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","",""]
[null,null,"2016-01-31","","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
[null,null,{"$f":"DATE(theyear,4,1)","v":"2016-04-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,5,1)","v":"2016-05-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,6,1)","v":"2016-06-01"}]
[null,null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"IF(MONTH(DATE(YEAR(C14),MONTH(C14),1))<>MONTH(DATE(YEAR(C14),MONTH(C14),1)-(WEEKDAY(DATE(YEAR(C14),MONTH(C14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(C14),MONTH(C14),1)-(WEEKDAY(DATE(YEAR(C14),MONTH(C14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","","2016-04-01","2016-04-02",null,{"$f":"IF(MONTH(DATE(YEAR(K14),MONTH(K14),1))<>MONTH(DATE(YEAR(K14),MONTH(K14),1)-(WEEKDAY(DATE(YEAR(K14),MONTH(K14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(K14),MONTH(K14),1)-(WEEKDAY(DATE(YEAR(K14),MONTH(K14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":"2016-05-01"},"2016-05-02","2016-05-03","2016-05-04","2016-05-05","2016-05-06","2016-05-07",null,{"$f":"IF(MONTH(DATE(YEAR(S14),MONTH(S14),1))<>MONTH(DATE(YEAR(S14),MONTH(S14),1)-(WEEKDAY(DATE(YEAR(S14),MONTH(S14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(S14),MONTH(S14),1)-(WEEKDAY(DATE(YEAR(S14),MONTH(S14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","2016-06-01","2016-06-02","2016-06-03","2016-06-04"]
[null,null,"2016-04-03","2016-04-04","2016-04-05","2016-04-06","2016-04-07","2016-04-08","2016-04-09",null,"2016-05-08","2016-05-09","2016-05-10","2016-05-11","2016-05-12","2016-05-13","2016-05-14",null,"2016-06-05","2016-06-06","2016-06-07","2016-06-08","2016-06-09","2016-06-10","2016-06-11"]
[null,null,"2016-04-10","2016-04-11","2016-04-12","2016-04-13","2016-04-14","2016-04-15","2016-04-16",null,"2016-05-15","2016-05-16","2016-05-17","2016-05-18","2016-05-19","2016-05-20","2016-05-21",null,"2016-06-12","2016-06-13","2016-06-14","2016-06-15","2016-06-16","2016-06-17","2016-06-18"]
[null,null,"2016-04-17","2016-04-18","2016-04-19","2016-04-20","2016-04-21","2016-04-22","2016-04-23",null,"2016-05-22","2016-05-23","2016-05-24","2016-05-25","2016-05-26","2016-05-27","2016-05-28",null,"2016-06-19","2016-06-20","2016-06-21","2016-06-22","2016-06-23","2016-06-24","2016-06-25"]
[null,null,"2016-04-24","2016-04-25","2016-04-26","2016-04-27","2016-04-28","2016-04-29","2016-04-30",null,"2016-05-29","2016-05-30","2016-05-31","","","","",null,"2016-06-26","2016-06-27","2016-06-28","2016-06-29","2016-06-30","",""]
[null,null,"","","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
[null,null,{"$f":"DATE(theyear,7,1)","v":"2016-07-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,8,1)","v":"2016-08-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,9,1)","v":"2016-09-01"}]
[null,null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"IF(MONTH(DATE(YEAR(C23),MONTH(C23),1))<>MONTH(DATE(YEAR(C23),MONTH(C23),1)-(WEEKDAY(DATE(YEAR(C23),MONTH(C23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(C23),MONTH(C23),1)-(WEEKDAY(DATE(YEAR(C23),MONTH(C23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","","2016-07-01","2016-07-02",null,{"$f":"IF(MONTH(DATE(YEAR(K23),MONTH(K23),1))<>MONTH(DATE(YEAR(K23),MONTH(K23),1)-(WEEKDAY(DATE(YEAR(K23),MONTH(K23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(K23),MONTH(K23),1)-(WEEKDAY(DATE(YEAR(K23),MONTH(K23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"2016-08-01","2016-08-02","2016-08-03","2016-08-04","2016-08-05","2016-08-06",null,{"$f":"IF(MONTH(DATE(YEAR(S23),MONTH(S23),1))<>MONTH(DATE(YEAR(S23),MONTH(S23),1)-(WEEKDAY(DATE(YEAR(S23),MONTH(S23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(S23),MONTH(S23),1)-(WEEKDAY(DATE(YEAR(S23),MONTH(S23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","2016-09-01","2016-09-02","2016-09-03"]
[null,null,"2016-07-03","2016-07-04","2016-07-05","2016-07-06","2016-07-07","2016-07-08","2016-07-09",null,"2016-08-07","2016-08-08","2016-08-09","2016-08-10","2016-08-11","2016-08-12","2016-08-13",null,"2016-09-04","2016-09-05","2016-09-06","2016-09-07","2016-09-08","2016-09-09","2016-09-10"]
[null,null,"2016-07-10","2016-07-11","2016-07-12","2016-07-13","2016-07-14","2016-07-15","2016-07-16",null,"2016-08-14","2016-08-15","2016-08-16","2016-08-17","2016-08-18","2016-08-19","2016-08-20",null,"2016-09-11","2016-09-12","2016-09-13","2016-09-14","2016-09-15","2016-09-16","2016-09-17"]
[null,null,"2016-07-17","2016-07-18","2016-07-19","2016-07-20","2016-07-21","2016-07-22","2016-07-23",null,"2016-08-21","2016-08-22","2016-08-23","2016-08-24","2016-08-25","2016-08-26","2016-08-27",null,"2016-09-18","2016-09-19","2016-09-20","2016-09-21","2016-09-22","2016-09-23","2016-09-24"]
[null,null,"2016-07-24","2016-07-25","2016-07-26","2016-07-27","2016-07-28","2016-07-29","2016-07-30",null,"2016-08-28","2016-08-29","2016-08-30","2016-08-31","","","",null,"2016-09-25","2016-09-26","2016-09-27","2016-09-28","2016-09-29","2016-09-30",""]
[null,null,"2016-07-31","","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
[null,null,{"$f":"DATE(theyear,10,1)","v":"2016-10-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,11,1)","v":"2016-11-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,12,1)","v":"2016-12-01"}]
[null,null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"IF(MONTH(DATE(YEAR(C32),MONTH(C32),1))<>MONTH(DATE(YEAR(C32),MONTH(C32),1)-(WEEKDAY(DATE(YEAR(C32),MONTH(C32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(C32),MONTH(C32),1)-(WEEKDAY(DATE(YEAR(C32),MONTH(C32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","","","2016-10-01",null,{"$f":"IF(MONTH(DATE(YEAR(K32),MONTH(K32),1))<>MONTH(DATE(YEAR(K32),MONTH(K32),1)-(WEEKDAY(DATE(YEAR(K32),MONTH(K32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(K32),MONTH(K32),1)-(WEEKDAY(DATE(YEAR(K32),MONTH(K32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","2016-11-01","2016-11-02","2016-11-03","2016-11-04","2016-11-05",null,{"$f":"IF(MONTH(DATE(YEAR(S32),MONTH(S32),1))<>MONTH(DATE(YEAR(S32),MONTH(S32),1)-(WEEKDAY(DATE(YEAR(S32),MONTH(S32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(S32),MONTH(S32),1)-(WEEKDAY(DATE(YEAR(S32),MONTH(S32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","2016-12-01","2016-12-02","2016-12-03"]
[null,null,"2016-10-02","2016-10-03","2016-10-04","2016-10-05","2016-10-06","2016-10-07","2016-10-08",null,"2016-11-06","2016-11-07","2016-11-08","2016-11-09","2016-11-10","2016-11-11","2016-11-12",null,"2016-12-04","2016-12-05","2016-12-06","2016-12-07","2016-12-08","2016-12-09","2016-12-10"]
[null,null,"2016-10-09","2016-10-10","2016-10-11","2016-10-12","2016-10-13","2016-10-14","2016-10-15",null,"2016-11-13","2016-11-14","2016-11-15","2016-11-16","2016-11-17","2016-11-18","2016-11-19",null,"2016-12-11","2016-12-12","2016-12-13","2016-12-14","2016-12-15","2016-12-16","2016-12-17"]
[null,null,"2016-10-16","2016-10-17","2016-10-18","2016-10-19","2016-10-20","2016-10-21","2016-10-22",null,"2016-11-20","2016-11-21","2016-11-22","2016-11-23","2016-11-24","2016-11-25","2016-11-26",null,"2016-12-18","2016-12-19","2016-12-20","2016-12-21","2016-12-22","2016-12-23","2016-12-24"]
[null,null,"2016-10-23","2016-10-24","2016-10-25","2016-10-26","2016-10-27","2016-10-28","2016-10-29",null,"2016-11-27","2016-11-28","2016-11-29","2016-11-30","","","",null,"2016-12-25","2016-12-26","2016-12-27","2016-12-28","2016-12-29","2016-12-30","2016-12-31"]
[null,null,"2016-10-30","2016-10-31","","","","","",null,"","","","","","","",null,"","","","","","",""]

{"sheet":"Лист1 (2)","index":3,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Эта рабочая книга содержит ряд полезных функций рабочего листа:"]
["IsBold",{"$f":"isbold(A2)","v":true}]
["IsItalic",{"$f":"isitalic(A3)","v":true}]
["AllBold",{"$f":"Allbold(A4)","v":false}]
["FillColor",{"$f":"fillcolor(A5)","v":20}]
["SayIt",{"$f":"IF(C6=700,sayit(\"не давай большую скидку\"))","v":false},{"$f":"RANDBETWEEN(10,100)","v":89}]
["LastSaved",{"$f":"lastsaved()","v":{"$error":"#VALUE!"}}]
["LastPrinted",{"$f":"lastprinted()","v":{"$error":"#VALUE!"}}]
["SheetName",{"$f":"sheetname(A1)","v":"Лист1 (2)"}]
["WorkbookName",{"$f":"workbookname(A1)","v":"МП-арпропр_апаро_16.06.2015.xlsm"}]
["AppName",{"$f":"appname(A1)","v":"Microsoft Excel"}]
["CountBetween",{"$f":"countbetween(A16:A26,2,5)","v":5},{"$f":"countbetween(A16:A26,5,2)","v":5}]
["LastInColumn",{"$f":"lastincolumn(E1)","v":999}]
["LastInRow",{"$f":"lastinrow(A16)","v":999}]
[]
[0,null,null,null,999]
[1]
[2]
[4]
[3]
[2]
[6]
[8]
[9]
[10]
[3]
["IsLike",{"$f":"ISLIKE(A1,\"*workbook*\")","v":false}]
["ExtractElement",{"$f":"extractelement(\"123-456-789\",2,\"-\")","v":"456"}]
["ExtractElement2",{"$f":"extractelement2(\"123-456-789\",2,\"-\")","v":"456"}]
["SpellDollars",{"$f":"spelldollars(B32)","v":"Пять и 20/100 долларов"}]
["StatFunction",{"$f":"statfunction($A$32:$A$36,\"sum\")","v":26}]
[5,{"$f":"statfunction($A$32:$A$36,\"average\")","v":5.2}]
[4,{"$f":"statfunction($A$32:$A$36,\"median\")","v":4}]
[11,{"$f":"statfunction($A$32:$A$36,\"max\")","v":11}]
[3,{"$f":"statfunction($A$32:$A$36,\"min\")","v":3}]
[3,{"$f":"statfunction($A$32:$A$36,\"stdev\")","v":3.3466401061363027}]
["SheetOffset",{"$f":"SHEETOFFSET(2,A1)","v":{"$error":"#VALUE!"}}]
["MaxAllSheets",{"$f":"MAXALLSHEETS((A1))","v":8}]
["RandomIntegers",{"$f":"randomintegers()","v":2}]
[null,3]
[null,1]
[null,4]
["RangeRandomize",{"$f":"rangerandomize(A32:A36)","v":3}]
[null,3]
[null,4]
[null,11]
[null,5]