{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Карточка клиента","Аккаунт","ТВ","Радио","ООН","Интернет Медиа","SЕО","Разработка креатива","Разработка сайта","Контекcт","ИТОГОВАЯ СВОДНАЯ","Сотрудники","Технический"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":9,"comments":10,"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":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,2,2,3],[12,3,12,4],[19,3,19,4],[18,3,18,4],[17,3,17,4],[16,3,16,4],[15,3,15,4],[14,3,14,4],[13,3,13,4],[25,3,25,4],[26,3,26,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4]]}
[]
[]
[null,null,"КАРТОЧКА КЛИЕНТА "]
[null,null,"Клиент:","ООО \"ФармПак\""]
[null,null,"Бренд:","Деринат"]
[]
[null,null,"Договор:","№202030"]
[null,null,"Предмет договора: ","SEO, контекст смм "]
[]
[null,null,"Период РК:","Сентябрь, Октябрь"," Тут сделать два ListBox с мультивыбором, позволяющим выбрать несколько месяцев одновременно."]
[null,null,"Бюджет (руб.)",15000000]
[]
[null,null,"Медиа","Дополнительные соглашения"]
[null,null,"ТВ","Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г."]
[null,null,"Радио","Документы в процессе создания"]
[null,null,"ООН","Приложение №3 к дополнительному соглашению № 23 от 19 декабря 2019 г. к договору № VS-081216/FMP от 08 декабря 2016 г."]
[null,null,"SЕО","ПРИЛОЖЕНИЕ № 1 к Дополнительному соглашению  № 28 от 10 августа 2020 г. к Договору № VS-081216/FMP от «08» декабря 2016г.\n"]
[null,null,"Интернет Медиа","ДС №29 к договору № VS-081216/FMP от 08 декабря 2016 г."]
[null,null,"Разработка креатива","Приложение №3 к дополнительному соглашению № 23 от 19 декабря 2019 г. к договору № VS-081216/FMP от 08 декабря 2016 г."]
[null,null,"Разработка сайта","Приложение №44"]
[null,null,"Контекcт","Приложение №45"]

{"sheet":"Аккаунт","index":1,"n_rows":22,"n_cols":82,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,3,8,4],[9,3,9,4],[7,3,7,4],[17,3,17,4],[3,65,3,70],[4,65,4,67],[4,68,4,70],[3,5,3,10],[3,23,3,28],[4,23,4,25],[4,5,4,7],[4,8,4,10],[4,11,4,13],[3,17,3,22],[4,26,4,28],[4,17,4,19],[4,20,4,22],[4,41,4,43],[4,32,4,34],[3,11,3,16],[4,14,4,16],[3,71,3,76],[4,71,4,73],[4,74,4,76],[3,53,3,58],[4,53,4,55],[4,56,4,58],[3,59,3,64],[4,59,4,61],[4,62,4,64],[4,0,4,1],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,2,5,2],[3,78,3,81],[4,79,4,81],[0,3,0,4],[6,3,6,4],[4,3,4,4],[5,3,5,4],[3,29,3,34],[3,35,3,40],[3,41,3,46],[3,47,3,52],[4,50,4,52],[4,44,4,46],[4,47,4,49],[4,35,4,37],[4,38,4,40],[4,29,4,31],[10,3,10,4],[12,3,12,4],[20,3,20,4],[11,3,11,4],[16,3,16,4],[14,3,14,4],[15,3,15,4],[18,3,18,4],[19,3,19,4],[13,3,13,4]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.2,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":8333.3333333333339},"Январь",null,null,null,null,null,"Февраль",null,null,null,null,null,"Март",null,null,null,null,null,"Апрель",null,null,null,null,null,"Май",null,null,null,null,null,"Июнь",null,null,null,null,null,"Июль",null,null,null,null,null,"Август",null,null,null,null,null,"Сентябрь",null,null,null,null,null,"Октябрь",null,null,null,null,null,"Ноябрь",null,null,null,null,null,"Декабрь",null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,"Документы",null,null,"Финансовый блок",null,null,null,"Документы","Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,"Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС","Дата выставления счета Клиенту ","Сумма закрытия","Поступление платежа","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма закрытия","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ",null,0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,null,null,{"$f":"I7*$C7","v":0},{"$f":"SUM(I7:J7)","v":0},null,null,null,null,{"$f":"O7*$C7","v":0},{"$f":"SUM(O7:P7)","v":0},null,null,null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,null,null,null,{"$f":"AA7*$C7","v":0},{"$f":"SUM(AA7:AB7)","v":0},null,null,null,null,{"$f":"AG7*$C7","v":0},{"$f":"SUM(AG7:AH7)","v":0},null,null,null,null,{"$f":"AM7*$C7","v":0},{"$f":"SUM(AM7:AN7)","v":0},null,null,null,null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,null,null,{"$f":"AY7*$C7","v":0},{"$f":"SUM(AY7:AZ7)","v":0},null,null,null,null,{"$f":"BE7*$C7","v":0},{"$f":"SUM(BE7:BF7)","v":0},null,null,null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,null,null,null,{"$f":"BQ7*$C7","v":0},{"$f":"SUM(BQ7:BR7)","v":0},null,null,null,null,{"$f":"BW7*$C7","v":0},{"$f":"SUM(BW7:BX7)","v":0},null,{"$f":"SUMIFS(F7:BY7,$F$6:$BY$6,$CA$6)","v":0},{"$f":"SUMIFS(F7:BY7,$F$6:$BY$6,$CB$6)","v":0},{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0}]
["ТВ",null,0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,{"$f":"SUMIFS(F8:BY8,$F$6:$BY$6,$CA$6)","v":0},{"$f":"SUMIFS(F8:BY8,$F$6:$BY$6,$CB$6)","v":0},{"$f":"CB8*$C8","v":0},{"$f":"SUM(CB8:CC8)","v":0}]
["ТВ",null,0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["ТВ",null,0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["ТВ",null,0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["ТВ",null,0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["ТВ",null,0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["Радио",null,0,"Документы в процессе создания",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["Радио",null,0,"Документы в процессе создания",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["Радио",null,0,"Документы в процессе создания",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["Радио",null,0,"Документы в процессе создания",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,{"$f":"SUMIFS(F19:BY19,$F$6:$BY$6,$CA$6)","v":0},{"$f":"SUMIFS(F19:BY19,$F$6:$BY$6,$CB$6)","v":0},{"$f":"CB19*$C19","v":0},{"$f":"SUM(CB19:CC19)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,{"$f":"SUMIFS(F20:BY20,$F$6:$BY$6,$CA$6)","v":0},{"$f":"SUMIFS(F20:BY20,$F$6:$BY$6,$CB$6)","v":0},{"$f":"CB20*$C20","v":0},{"$f":"SUM(CB20:CC20)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,0,0,0,0]
["ИТОГО:",null,null,null,null,null,null,null,{"$f":"SUM(I7:I21)","v":0},{"$f":"SUM(J7:J21)","v":0},{"$f":"SUM(K7:K21)","v":0},null,null,null,{"$f":"SUM(O7:O21)","v":0},{"$f":"SUM(P7:P21)","v":0},{"$f":"SUM(Q7:Q21)","v":0},null,null,null,{"$f":"SUM(U7:U21)","v":0},{"$f":"SUM(V7:V21)","v":0},{"$f":"SUM(W7:W21)","v":0},null,null,null,{"$f":"SUM(AA7:AA21)","v":0},{"$f":"SUM(AB7:AB21)","v":0},{"$f":"SUM(AC7:AC21)","v":0},null,null,null,{"$f":"SUM(AG7:AG21)","v":0},{"$f":"SUM(AH7:AH21)","v":0},{"$f":"SUM(AI7:AI21)","v":0},null,null,null,{"$f":"SUM(AM7:AM21)","v":0},{"$f":"SUM(AN7:AN21)","v":0},{"$f":"SUM(AO7:AO21)","v":0},null,null,null,{"$f":"SUM(AS7:AS21)","v":0},{"$f":"SUM(AT7:AT21)","v":0},{"$f":"SUM(AU7:AU21)","v":0},null,null,null,{"$f":"SUM(AY7:AY21)","v":0},{"$f":"SUM(AZ7:AZ21)","v":0},{"$f":"SUM(BA7:BA21)","v":0},null,null,null,{"$f":"SUM(BE7:BE21)","v":0},{"$f":"SUM(BF7:BF21)","v":0},{"$f":"SUM(BG7:BG21)","v":0},null,null,null,{"$f":"SUM(BK7:BK21)","v":0},{"$f":"SUM(BL7:BL21)","v":0},{"$f":"SUM(BM7:BM21)","v":0},null,null,null,{"$f":"SUM(BQ7:BQ21)","v":0},{"$f":"SUM(BR7:BR21)","v":0},{"$f":"SUM(BS7:BS21)","v":0},null,null,null,{"$f":"SUM(BW7:BW21)","v":0},{"$f":"SUM(BX7:BX21)","v":0},{"$f":"SUM(BY7:BY21)","v":0},null,{"$f":"SUM(CA7:CA21)","v":0},{"$f":"SUM(CB7:CB21)","v":0},{"$f":"SUM(CC7:CC21)","v":0},{"$f":"SUM(CD7:CD21)","v":0}]

{"sheet":"ТВ","index":2,"n_rows":20,"n_cols":96,"rows_kept":20,"cut":false,"hidden":false,"merged":[[21,3,21,4],[22,3,22,4],[23,3,23,4],[14,3,14,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[20,3,20,4],[19,3,19,4],[15,3,15,4],[13,3,13,4],[10,3,10,4],[9,3,9,4],[11,3,11,4],[12,3,12,4],[8,3,8,4],[3,54,3,60],[4,40,5,40],[3,40,3,46],[4,47,5,47],[3,47,3,53],[4,51,4,53],[4,55,4,57],[4,58,4,60],[3,33,3,39],[3,26,3,32],[4,26,5,26],[7,3,7,4],[3,5,3,11],[4,12,5,12],[4,90,4,92],[4,93,4,95],[3,90,3,95],[0,1,0,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,0,4,1],[4,2,5,2],[4,3,4,4],[4,6,4,8],[4,9,4,11],[4,13,4,15],[4,16,4,18],[3,82,3,88],[3,61,3,67],[3,68,3,74],[4,75,5,75],[3,75,3,81],[4,76,4,78],[4,79,4,81],[4,62,4,64],[4,65,4,67],[4,83,4,85],[4,86,4,88],[4,69,4,71],[4,72,4,74],[4,68,5,68],[4,82,5,82],[3,12,3,18],[4,19,5,19],[3,19,3,25],[4,23,4,25],[6,3,6,4],[4,5,5,5],[5,3,5,4],[4,20,4,22],[4,27,4,29],[4,30,4,32],[4,34,4,36],[4,61,5,61],[4,33,5,33],[4,44,4,46],[4,48,4,50],[4,37,4,39],[4,41,4,43],[4,54,5,54]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":9090.9090909090901},"Январь",null,null,null,null,null,null,"Февраль",null,null,null,null,null,null,"Март",null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,"Май",null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,"Июль",null,null,null,null,null,null,"Август",null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,"Декабрь",null,null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,null,"Плановый бюджет ",null,null,"Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ","Россия 1",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,{"$f":"G7*$C7","v":0},{"$f":"SUM(G7:H7)","v":0},null,{"$f":"J7*$C7","v":0},{"$f":"SUM(J7:K7)","v":0},null,null,{"$f":"N7*$C7","v":0},{"$f":"SUM(N7:O7)","v":0},null,{"$f":"Q7*$C7","v":0},{"$f":"SUM(Q7:R7)","v":0},null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,{"$f":"X7*$C7","v":0},{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"AB7*$C7","v":0},{"$f":"SUM(AB7:AC7)","v":0},null,{"$f":"AE7*$C7","v":0},{"$f":"SUM(AE7:AF7)","v":0},null,null,{"$f":"AI7*$C7","v":0},{"$f":"SUM(AI7:AJ7)","v":0},null,{"$f":"AL7*$C7","v":0},{"$f":"SUM(AL7:AM7)","v":0},null,null,{"$f":"AP7*$C7","v":0},{"$f":"SUM(AP7:AQ7)","v":0},null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,{"$f":"AW7*$C7","v":0},{"$f":"SUM(AW7:AX7)","v":0},null,{"$f":"AZ7*$C7","v":0},{"$f":"SUM(AZ7:BA7)","v":0},null,null,{"$f":"BD7*$C7","v":0},{"$f":"SUM(BD7:BE7)","v":0},null,{"$f":"BG7*$C7","v":0},{"$f":"SUM(BG7:BH7)","v":0},null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,{"$f":"BN7*$C7","v":0},{"$f":"SUM(BN7:BO7)","v":0},null,null,{"$f":"BR7*$C7","v":0},{"$f":"SUM(BR7:BS7)","v":0},null,{"$f":"BU7*$C7","v":0},{"$f":"SUM(BU7:BV7)","v":0},null,null,{"$f":"BY7*$C7","v":0},{"$f":"SUM(BY7:BZ7)","v":0},null,{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0},null,null,{"$f":"CF7*$C7","v":0},{"$f":"SUM(CF7:CG7)","v":0},null,{"$f":"CI7*$C7","v":0},{"$f":"SUM(CI7:CJ7)","v":0},null,{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM7*$C7","v":0},{"$f":"SUM(CM7:CN7)","v":0},{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP7*$C7","v":0},{"$f":"SUM(CP7:CQ7)","v":0}]
["ТВ","СТС",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Россия 24",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,0,0,0]
["ТВ","ТВЦ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM10*$C10","v":0},{"$f":"SUM(CM10:CN10)","v":0},{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP10*$C10","v":0},{"$f":"SUM(CP10:CQ10)","v":0}]
["ТВ","НТВ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP11*$C11","v":0},0]
["ТВ","СТС Love",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Карусель",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Bugi-ретрро",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,{"$f":"CM14*$C14","v":0},0,{"$f":"SUMIFS(G14:CK14,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP14*$C14","v":0},0]
["Радио","Наше Радио",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM15*$C15","v":0},0,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP15*$C15","v":0},0]
["Радио","Радио ХИТ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Ретро Попса-мопса ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Радио России",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Супер Радио",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ИТОГО:",null,null,null,null,null,{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0},0,0,0,0,null,{"$f":"SUM(N7:N19)","v":0},{"$f":"SUM(O7:O19)","v":0},{"$f":"SUM(P7:P19)","v":0},{"$f":"SUM(Q7:Q19)","v":0},{"$f":"SUM(R7:R19)","v":0},{"$f":"SUM(S7:S19)","v":0},null,{"$f":"SUM(U7:U19)","v":0},{"$f":"SUM(V7:V19)","v":0},{"$f":"SUM(W7:W19)","v":0},{"$f":"SUM(X7:X19)","v":0},{"$f":"SUM(Y7:Y19)","v":0},{"$f":"SUM(Z7:Z19)","v":0},null,{"$f":"SUM(AB7:AB19)","v":0},{"$f":"SUM(AC7:AC19)","v":0},{"$f":"SUM(AD7:AD19)","v":0},{"$f":"SUM(AE7:AE19)","v":0},{"$f":"SUM(AF7:AF19)","v":0},{"$f":"SUM(AG7:AG19)","v":0},null,{"$f":"SUM(AI7:AI19)","v":0},{"$f":"SUM(AJ7:AJ19)","v":0},{"$f":"SUM(AK7:AK19)","v":0},{"$f":"SUM(AL7:AL19)","v":0},{"$f":"SUM(AM7:AM19)","v":0},{"$f":"SUM(AN7:AN19)","v":0},null,{"$f":"SUM(AP7:AP19)","v":0},{"$f":"SUM(AQ7:AQ19)","v":0},{"$f":"SUM(AR7:AR19)","v":0},{"$f":"SUM(AS7:AS19)","v":0},{"$f":"SUM(AT7:AT19)","v":0},{"$f":"SUM(AU7:AU19)","v":0},null,{"$f":"SUM(AW7:AW19)","v":0},{"$f":"SUM(AX7:AX19)","v":0},{"$f":"SUM(AY7:AY19)","v":0},{"$f":"SUM(AZ7:AZ19)","v":0},{"$f":"SUM(BA7:BA19)","v":0},{"$f":"SUM(BB7:BB19)","v":0},null,{"$f":"SUM(BD7:BD19)","v":0},{"$f":"SUM(BE7:BE19)","v":0},{"$f":"SUM(BF7:BF19)","v":0},{"$f":"SUM(BG7:BG19)","v":0},{"$f":"SUM(BH7:BH19)","v":0},{"$f":"SUM(BI7:BI19)","v":0},null,{"$f":"SUM(BK7:BK19)","v":0},{"$f":"SUM(BL7:BL19)","v":0},{"$f":"SUM(BM7:BM19)","v":0},{"$f":"SUM(BN7:BN19)","v":0},{"$f":"SUM(BO7:BO19)","v":0},{"$f":"SUM(BP7:BP19)","v":0},null,{"$f":"SUM(BR7:BR19)","v":0},{"$f":"SUM(BS7:BS19)","v":0},{"$f":"SUM(BT7:BT19)","v":0},{"$f":"SUM(BU7:BU19)","v":0},{"$f":"SUM(BV7:BV19)","v":0},{"$f":"SUM(BW7:BW19)","v":0},null,{"$f":"SUM(BY7:BY19)","v":0},{"$f":"SUM(BZ7:BZ19)","v":0},{"$f":"SUM(CA7:CA19)","v":0},{"$f":"SUM(CB7:CB19)","v":0},{"$f":"SUM(CC7:CC19)","v":0},{"$f":"SUM(CD7:CD19)","v":0},null,{"$f":"SUM(CF7:CF19)","v":0},{"$f":"SUM(CG7:CG19)","v":0},{"$f":"SUM(CH7:CH19)","v":0},{"$f":"SUM(CI7:CI19)","v":0},{"$f":"SUM(CJ7:CJ19)","v":0},{"$f":"SUM(CK7:CK19)","v":0},null,0,{"$f":"SUM(CN7:CN19)","v":0},{"$f":"SUM(CO7:CO19)","v":0},{"$f":"SUM(CP7:CP19)","v":0},{"$f":"SUM(CQ7:CQ19)","v":0},{"$f":"SUM(CR7:CR19)","v":0}]

{"sheet":"Радио","index":3,"n_rows":20,"n_cols":96,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,3,23,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[4,82,5,82],[4,83,4,85],[4,86,4,88],[4,90,4,92],[4,44,4,46],[4,47,5,47],[4,48,4,50],[4,51,4,53],[4,26,5,26],[4,27,4,29],[4,30,4,32],[4,33,5,33],[4,34,4,36],[4,37,4,39],[4,12,5,12],[4,93,4,95],[5,3,5,4],[4,68,5,68],[4,69,4,71],[4,72,4,74],[4,75,5,75],[4,76,4,78],[4,79,4,81],[4,54,5,54],[4,55,4,57],[4,58,4,60],[4,61,5,61],[4,62,4,64],[4,65,4,67],[4,40,5,40],[4,41,4,43],[4,0,4,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,4,8],[4,9,4,11],[3,54,3,60],[3,61,3,67],[3,68,3,74],[3,75,3,81],[3,5,3,11],[4,13,4,15],[4,16,4,18],[4,19,5,19],[4,20,4,22],[4,23,4,25],[3,82,3,88],[3,90,3,95],[3,12,3,18],[3,19,3,25],[3,26,3,32],[3,33,3,39],[3,40,3,46],[3,47,3,53],[0,1,0,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":9090.9090909090901},"Январь",null,null,null,null,null,null,"Февраль",null,null,null,null,null,null,"Март",null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,"Май",null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,"Июль",null,null,null,null,null,null,"Август",null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,"Декабрь",null,null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,null,"Плановый бюджет ",null,null,"Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ","Россия 1",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,{"$f":"G7*$C7","v":0},{"$f":"SUM(G7:H7)","v":0},null,{"$f":"J7*$C7","v":0},{"$f":"SUM(J7:K7)","v":0},null,null,{"$f":"N7*$C7","v":0},{"$f":"SUM(N7:O7)","v":0},null,{"$f":"Q7*$C7","v":0},{"$f":"SUM(Q7:R7)","v":0},null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,{"$f":"X7*$C7","v":0},{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"AB7*$C7","v":0},{"$f":"SUM(AB7:AC7)","v":0},null,{"$f":"AE7*$C7","v":0},{"$f":"SUM(AE7:AF7)","v":0},null,null,{"$f":"AI7*$C7","v":0},{"$f":"SUM(AI7:AJ7)","v":0},null,{"$f":"AL7*$C7","v":0},{"$f":"SUM(AL7:AM7)","v":0},null,null,{"$f":"AP7*$C7","v":0},{"$f":"SUM(AP7:AQ7)","v":0},null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,{"$f":"AW7*$C7","v":0},{"$f":"SUM(AW7:AX7)","v":0},null,{"$f":"AZ7*$C7","v":0},{"$f":"SUM(AZ7:BA7)","v":0},null,null,{"$f":"BD7*$C7","v":0},{"$f":"SUM(BD7:BE7)","v":0},null,{"$f":"BG7*$C7","v":0},{"$f":"SUM(BG7:BH7)","v":0},null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,{"$f":"BN7*$C7","v":0},{"$f":"SUM(BN7:BO7)","v":0},null,null,{"$f":"BR7*$C7","v":0},{"$f":"SUM(BR7:BS7)","v":0},null,{"$f":"BU7*$C7","v":0},{"$f":"SUM(BU7:BV7)","v":0},null,null,{"$f":"BY7*$C7","v":0},{"$f":"SUM(BY7:BZ7)","v":0},null,{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0},null,null,{"$f":"CF7*$C7","v":0},{"$f":"SUM(CF7:CG7)","v":0},null,{"$f":"CI7*$C7","v":0},{"$f":"SUM(CI7:CJ7)","v":0},null,{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM7*$C7","v":0},{"$f":"SUM(CM7:CN7)","v":0},{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP7*$C7","v":0},{"$f":"SUM(CP7:CQ7)","v":0}]
["ТВ","СТС",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Россия 24",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,0,0,0]
["ТВ","ТВЦ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP10*$C10","v":0},0]
["ТВ","НТВ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP11*$C11","v":0},0]
["ТВ","СТС Love",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Карусель",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Bugi-ретрро",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,{"$f":"CM14*$C14","v":0},0,{"$f":"SUMIFS(G14:CK14,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP14*$C14","v":0},0]
["Радио","Наше Радио",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM15*$C15","v":0},0,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP15*$C15","v":0},0]
["Радио","Радио ХИТ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Ретро Попса-мопса ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Радио России",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Супер Радио",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ИТОГО:",null,null,null,null,null,{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0},0,0,0,0,null,{"$f":"SUM(N7:N19)","v":0},{"$f":"SUM(O7:O19)","v":0},0,0,0,0,null,{"$f":"SUM(U7:U19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AB7:AB19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AI7:AI19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AP7:AP19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AW7:AW19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BD7:BD19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BK7:BK19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BR7:BR19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BY7:BY19)","v":0},0,0,0,0,0,null,{"$f":"SUM(CF7:CF19)","v":0},0,0,0,0,0,null,0,0,0,0,0,{"$f":"SUM(CR7:CR19)","v":0}]

{"sheet":"ООН","index":4,"n_rows":20,"n_cols":96,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,3,23,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[4,82,5,82],[4,83,4,85],[4,86,4,88],[4,90,4,92],[4,44,4,46],[4,47,5,47],[4,48,4,50],[4,51,4,53],[4,26,5,26],[4,27,4,29],[4,30,4,32],[4,33,5,33],[4,34,4,36],[4,37,4,39],[4,12,5,12],[4,93,4,95],[5,3,5,4],[4,68,5,68],[4,69,4,71],[4,72,4,74],[4,75,5,75],[4,76,4,78],[4,79,4,81],[4,54,5,54],[4,55,4,57],[4,58,4,60],[4,61,5,61],[4,62,4,64],[4,65,4,67],[4,40,5,40],[4,41,4,43],[4,0,4,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,4,8],[4,9,4,11],[3,54,3,60],[3,61,3,67],[3,68,3,74],[3,75,3,81],[3,5,3,11],[4,13,4,15],[4,16,4,18],[4,19,5,19],[4,20,4,22],[4,23,4,25],[3,82,3,88],[3,90,3,95],[3,12,3,18],[3,19,3,25],[3,26,3,32],[3,33,3,39],[3,40,3,46],[3,47,3,53],[0,1,0,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":9090.9090909090901},"Январь",null,null,null,null,null,null,"Февраль",null,null,null,null,null,null,"Март",null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,"Май",null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,"Июль",null,null,null,null,null,null,"Август",null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,"Декабрь",null,null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,null,"Плановый бюджет ",null,null,"Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ","Россия 1",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,{"$f":"G7*$C7","v":0},{"$f":"SUM(G7:H7)","v":0},null,{"$f":"J7*$C7","v":0},{"$f":"SUM(J7:K7)","v":0},null,null,{"$f":"N7*$C7","v":0},{"$f":"SUM(N7:O7)","v":0},null,{"$f":"Q7*$C7","v":0},{"$f":"SUM(Q7:R7)","v":0},null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,{"$f":"X7*$C7","v":0},{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"AB7*$C7","v":0},{"$f":"SUM(AB7:AC7)","v":0},null,{"$f":"AE7*$C7","v":0},{"$f":"SUM(AE7:AF7)","v":0},null,null,{"$f":"AI7*$C7","v":0},{"$f":"SUM(AI7:AJ7)","v":0},null,{"$f":"AL7*$C7","v":0},{"$f":"SUM(AL7:AM7)","v":0},null,null,{"$f":"AP7*$C7","v":0},{"$f":"SUM(AP7:AQ7)","v":0},null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,{"$f":"AW7*$C7","v":0},{"$f":"SUM(AW7:AX7)","v":0},null,{"$f":"AZ7*$C7","v":0},{"$f":"SUM(AZ7:BA7)","v":0},null,null,{"$f":"BD7*$C7","v":0},{"$f":"SUM(BD7:BE7)","v":0},null,{"$f":"BG7*$C7","v":0},{"$f":"SUM(BG7:BH7)","v":0},null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,{"$f":"BN7*$C7","v":0},{"$f":"SUM(BN7:BO7)","v":0},null,null,{"$f":"BR7*$C7","v":0},{"$f":"SUM(BR7:BS7)","v":0},null,{"$f":"BU7*$C7","v":0},{"$f":"SUM(BU7:BV7)","v":0},null,null,{"$f":"BY7*$C7","v":0},{"$f":"SUM(BY7:BZ7)","v":0},null,{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0},null,null,{"$f":"CF7*$C7","v":0},{"$f":"SUM(CF7:CG7)","v":0},null,{"$f":"CI7*$C7","v":0},{"$f":"SUM(CI7:CJ7)","v":0},null,{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM7*$C7","v":0},{"$f":"SUM(CM7:CN7)","v":0},{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP7*$C7","v":0},{"$f":"SUM(CP7:CQ7)","v":0}]
["ТВ","СТС",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Россия 24",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,0,0,0]
["ТВ","ТВЦ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP10*$C10","v":0},0]
["ТВ","НТВ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP11*$C11","v":0},0]
["ТВ","СТС Love",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Карусель",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Bugi-ретрро",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,{"$f":"CM14*$C14","v":0},0,{"$f":"SUMIFS(G14:CK14,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP14*$C14","v":0},0]
["Радио","Наше Радио",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM15*$C15","v":0},0,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP15*$C15","v":0},0]
["Радио","Радио ХИТ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Ретро Попса-мопса ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Радио России",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Супер Радио",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ИТОГО:",null,null,null,null,null,{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0},0,0,0,0,null,{"$f":"SUM(N7:N19)","v":0},{"$f":"SUM(O7:O19)","v":0},0,0,0,0,null,{"$f":"SUM(U7:U19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AB7:AB19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AI7:AI19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AP7:AP19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AW7:AW19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BD7:BD19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BK7:BK19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BR7:BR19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BY7:BY19)","v":0},0,0,0,0,0,null,{"$f":"SUM(CF7:CF19)","v":0},0,0,0,0,0,null,0,0,0,0,0,{"$f":"SUM(CR7:CR19)","v":0}]

{"sheet":"Интернет Медиа","index":5,"n_rows":20,"n_cols":96,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,3,23,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[4,82,5,82],[4,83,4,85],[4,86,4,88],[4,90,4,92],[4,44,4,46],[4,47,5,47],[4,48,4,50],[4,51,4,53],[4,26,5,26],[4,27,4,29],[4,30,4,32],[4,33,5,33],[4,34,4,36],[4,37,4,39],[4,12,5,12],[4,93,4,95],[5,3,5,4],[4,68,5,68],[4,69,4,71],[4,72,4,74],[4,75,5,75],[4,76,4,78],[4,79,4,81],[4,54,5,54],[4,55,4,57],[4,58,4,60],[4,61,5,61],[4,62,4,64],[4,65,4,67],[4,40,5,40],[4,41,4,43],[4,0,4,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,4,8],[4,9,4,11],[3,54,3,60],[3,61,3,67],[3,68,3,74],[3,75,3,81],[3,5,3,11],[4,13,4,15],[4,16,4,18],[4,19,5,19],[4,20,4,22],[4,23,4,25],[3,82,3,88],[3,90,3,95],[3,12,3,18],[3,19,3,25],[3,26,3,32],[3,33,3,39],[3,40,3,46],[3,47,3,53],[0,1,0,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":9090.9090909090901},"Январь",null,null,null,null,null,null,"Февраль",null,null,null,null,null,null,"Март",null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,"Май",null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,"Июль",null,null,null,null,null,null,"Август",null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,"Декабрь",null,null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,null,"Плановый бюджет ",null,null,"Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ","Россия 1",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,{"$f":"G7*$C7","v":0},{"$f":"SUM(G7:H7)","v":0},null,{"$f":"J7*$C7","v":0},{"$f":"SUM(J7:K7)","v":0},null,null,{"$f":"N7*$C7","v":0},{"$f":"SUM(N7:O7)","v":0},null,{"$f":"Q7*$C7","v":0},{"$f":"SUM(Q7:R7)","v":0},null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,{"$f":"X7*$C7","v":0},{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"AB7*$C7","v":0},{"$f":"SUM(AB7:AC7)","v":0},null,{"$f":"AE7*$C7","v":0},{"$f":"SUM(AE7:AF7)","v":0},null,null,{"$f":"AI7*$C7","v":0},{"$f":"SUM(AI7:AJ7)","v":0},null,{"$f":"AL7*$C7","v":0},{"$f":"SUM(AL7:AM7)","v":0},null,null,{"$f":"AP7*$C7","v":0},{"$f":"SUM(AP7:AQ7)","v":0},null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,{"$f":"AW7*$C7","v":0},{"$f":"SUM(AW7:AX7)","v":0},null,{"$f":"AZ7*$C7","v":0},{"$f":"SUM(AZ7:BA7)","v":0},null,null,{"$f":"BD7*$C7","v":0},{"$f":"SUM(BD7:BE7)","v":0},null,{"$f":"BG7*$C7","v":0},{"$f":"SUM(BG7:BH7)","v":0},null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,{"$f":"BN7*$C7","v":0},{"$f":"SUM(BN7:BO7)","v":0},null,null,{"$f":"BR7*$C7","v":0},{"$f":"SUM(BR7:BS7)","v":0},null,{"$f":"BU7*$C7","v":0},{"$f":"SUM(BU7:BV7)","v":0},null,null,{"$f":"BY7*$C7","v":0},{"$f":"SUM(BY7:BZ7)","v":0},null,{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0},null,null,{"$f":"CF7*$C7","v":0},{"$f":"SUM(CF7:CG7)","v":0},null,{"$f":"CI7*$C7","v":0},{"$f":"SUM(CI7:CJ7)","v":0},null,{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM7*$C7","v":0},{"$f":"SUM(CM7:CN7)","v":0},{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP7*$C7","v":0},{"$f":"SUM(CP7:CQ7)","v":0}]
["ТВ","СТС",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Россия 24",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,0,0,0]
["ТВ","ТВЦ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP10*$C10","v":0},0]
["ТВ","НТВ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP11*$C11","v":0},0]
["ТВ","СТС Love",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Карусель",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Bugi-ретрро",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,{"$f":"CM14*$C14","v":0},0,{"$f":"SUMIFS(G14:CK14,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP14*$C14","v":0},0]
["Радио","Наше Радио",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM15*$C15","v":0},0,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP15*$C15","v":0},0]
["Радио","Радио ХИТ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Ретро Попса-мопса ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Радио России",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Супер Радио",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ИТОГО:",null,null,null,null,null,{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0},0,0,0,0,null,{"$f":"SUM(N7:N19)","v":0},{"$f":"SUM(O7:O19)","v":0},0,0,0,0,null,{"$f":"SUM(U7:U19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AB7:AB19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AI7:AI19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AP7:AP19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AW7:AW19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BD7:BD19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BK7:BK19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BR7:BR19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BY7:BY19)","v":0},0,0,0,0,0,null,{"$f":"SUM(CF7:CF19)","v":0},0,0,0,0,0,null,0,0,0,0,0,{"$f":"SUM(CR7:CR19)","v":0}]

{"sheet":"SЕО","index":6,"n_rows":20,"n_cols":96,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,3,23,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[4,82,5,82],[4,83,4,85],[4,86,4,88],[4,90,4,92],[4,44,4,46],[4,47,5,47],[4,48,4,50],[4,51,4,53],[4,26,5,26],[4,27,4,29],[4,30,4,32],[4,33,5,33],[4,34,4,36],[4,37,4,39],[4,12,5,12],[4,93,4,95],[5,3,5,4],[4,68,5,68],[4,69,4,71],[4,72,4,74],[4,75,5,75],[4,76,4,78],[4,79,4,81],[4,54,5,54],[4,55,4,57],[4,58,4,60],[4,61,5,61],[4,62,4,64],[4,65,4,67],[4,40,5,40],[4,41,4,43],[4,0,4,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,4,8],[4,9,4,11],[3,54,3,60],[3,61,3,67],[3,68,3,74],[3,75,3,81],[3,5,3,11],[4,13,4,15],[4,16,4,18],[4,19,5,19],[4,20,4,22],[4,23,4,25],[3,82,3,88],[3,90,3,95],[3,12,3,18],[3,19,3,25],[3,26,3,32],[3,33,3,39],[3,40,3,46],[3,47,3,53],[0,1,0,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":9090.9090909090901},"Январь",null,null,null,null,null,null,"Февраль",null,null,null,null,null,null,"Март",null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,"Май",null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,"Июль",null,null,null,null,null,null,"Август",null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,"Декабрь",null,null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,null,"Плановый бюджет ",null,null,"Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ","Россия 1",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,{"$f":"G7*$C7","v":0},{"$f":"SUM(G7:H7)","v":0},null,{"$f":"J7*$C7","v":0},{"$f":"SUM(J7:K7)","v":0},null,null,{"$f":"N7*$C7","v":0},{"$f":"SUM(N7:O7)","v":0},null,{"$f":"Q7*$C7","v":0},{"$f":"SUM(Q7:R7)","v":0},null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,{"$f":"X7*$C7","v":0},{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"AB7*$C7","v":0},{"$f":"SUM(AB7:AC7)","v":0},null,{"$f":"AE7*$C7","v":0},{"$f":"SUM(AE7:AF7)","v":0},null,null,{"$f":"AI7*$C7","v":0},{"$f":"SUM(AI7:AJ7)","v":0},null,{"$f":"AL7*$C7","v":0},{"$f":"SUM(AL7:AM7)","v":0},null,null,{"$f":"AP7*$C7","v":0},{"$f":"SUM(AP7:AQ7)","v":0},null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,{"$f":"AW7*$C7","v":0},{"$f":"SUM(AW7:AX7)","v":0},null,{"$f":"AZ7*$C7","v":0},{"$f":"SUM(AZ7:BA7)","v":0},null,null,{"$f":"BD7*$C7","v":0},{"$f":"SUM(BD7:BE7)","v":0},null,{"$f":"BG7*$C7","v":0},{"$f":"SUM(BG7:BH7)","v":0},null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,{"$f":"BN7*$C7","v":0},{"$f":"SUM(BN7:BO7)","v":0},null,null,{"$f":"BR7*$C7","v":0},{"$f":"SUM(BR7:BS7)","v":0},null,{"$f":"BU7*$C7","v":0},{"$f":"SUM(BU7:BV7)","v":0},null,null,{"$f":"BY7*$C7","v":0},{"$f":"SUM(BY7:BZ7)","v":0},null,{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0},null,null,{"$f":"CF7*$C7","v":0},{"$f":"SUM(CF7:CG7)","v":0},null,{"$f":"CI7*$C7","v":0},{"$f":"SUM(CI7:CJ7)","v":0},null,{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM7*$C7","v":0},{"$f":"SUM(CM7:CN7)","v":0},{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP7*$C7","v":0},{"$f":"SUM(CP7:CQ7)","v":0}]
["ТВ","СТС",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Россия 24",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,0,0,0]
["ТВ","ТВЦ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP10*$C10","v":0},0]
["ТВ","НТВ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP11*$C11","v":0},0]
["ТВ","СТС Love",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Карусель",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Bugi-ретрро",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,{"$f":"CM14*$C14","v":0},0,{"$f":"SUMIFS(G14:CK14,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP14*$C14","v":0},0]
["Радио","Наше Радио",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM15*$C15","v":0},0,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP15*$C15","v":0},0]
["Радио","Радио ХИТ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Ретро Попса-мопса ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Радио России",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Супер Радио",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ИТОГО:",null,null,null,null,null,{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0},0,0,0,0,null,{"$f":"SUM(N7:N19)","v":0},{"$f":"SUM(O7:O19)","v":0},0,0,0,0,null,{"$f":"SUM(U7:U19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AB7:AB19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AI7:AI19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AP7:AP19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AW7:AW19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BD7:BD19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BK7:BK19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BR7:BR19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BY7:BY19)","v":0},0,0,0,0,0,null,{"$f":"SUM(CF7:CF19)","v":0},0,0,0,0,0,null,0,0,0,0,0,{"$f":"SUM(CR7:CR19)","v":0}]

{"sheet":"Разработка креатива","index":7,"n_rows":20,"n_cols":96,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,3,23,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[4,82,5,82],[4,83,4,85],[4,86,4,88],[4,90,4,92],[4,44,4,46],[4,47,5,47],[4,48,4,50],[4,51,4,53],[4,26,5,26],[4,27,4,29],[4,30,4,32],[4,33,5,33],[4,34,4,36],[4,37,4,39],[4,12,5,12],[4,93,4,95],[5,3,5,4],[4,68,5,68],[4,69,4,71],[4,72,4,74],[4,75,5,75],[4,76,4,78],[4,79,4,81],[4,54,5,54],[4,55,4,57],[4,58,4,60],[4,61,5,61],[4,62,4,64],[4,65,4,67],[4,40,5,40],[4,41,4,43],[4,0,4,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,4,8],[4,9,4,11],[3,54,3,60],[3,61,3,67],[3,68,3,74],[3,75,3,81],[3,5,3,11],[4,13,4,15],[4,16,4,18],[4,19,5,19],[4,20,4,22],[4,23,4,25],[3,82,3,88],[3,90,3,95],[3,12,3,18],[3,19,3,25],[3,26,3,32],[3,33,3,39],[3,40,3,46],[3,47,3,53],[0,1,0,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":9090.9090909090901},"Январь",null,null,null,null,null,null,"Февраль",null,null,null,null,null,null,"Март",null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,"Май",null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,"Июль",null,null,null,null,null,null,"Август",null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,"Декабрь",null,null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,null,"Плановый бюджет ",null,null,"Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ","Россия 1",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,{"$f":"G7*$C7","v":0},{"$f":"SUM(G7:H7)","v":0},null,{"$f":"J7*$C7","v":0},{"$f":"SUM(J7:K7)","v":0},null,null,{"$f":"N7*$C7","v":0},{"$f":"SUM(N7:O7)","v":0},null,{"$f":"Q7*$C7","v":0},{"$f":"SUM(Q7:R7)","v":0},null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,{"$f":"X7*$C7","v":0},{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"AB7*$C7","v":0},{"$f":"SUM(AB7:AC7)","v":0},null,{"$f":"AE7*$C7","v":0},{"$f":"SUM(AE7:AF7)","v":0},null,null,{"$f":"AI7*$C7","v":0},{"$f":"SUM(AI7:AJ7)","v":0},null,{"$f":"AL7*$C7","v":0},{"$f":"SUM(AL7:AM7)","v":0},null,null,{"$f":"AP7*$C7","v":0},{"$f":"SUM(AP7:AQ7)","v":0},null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,{"$f":"AW7*$C7","v":0},{"$f":"SUM(AW7:AX7)","v":0},null,{"$f":"AZ7*$C7","v":0},{"$f":"SUM(AZ7:BA7)","v":0},null,null,{"$f":"BD7*$C7","v":0},{"$f":"SUM(BD7:BE7)","v":0},null,{"$f":"BG7*$C7","v":0},{"$f":"SUM(BG7:BH7)","v":0},null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,{"$f":"BN7*$C7","v":0},{"$f":"SUM(BN7:BO7)","v":0},null,null,{"$f":"BR7*$C7","v":0},{"$f":"SUM(BR7:BS7)","v":0},null,{"$f":"BU7*$C7","v":0},{"$f":"SUM(BU7:BV7)","v":0},null,null,{"$f":"BY7*$C7","v":0},{"$f":"SUM(BY7:BZ7)","v":0},null,{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0},null,null,{"$f":"CF7*$C7","v":0},{"$f":"SUM(CF7:CG7)","v":0},null,{"$f":"CI7*$C7","v":0},{"$f":"SUM(CI7:CJ7)","v":0},null,{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM7*$C7","v":0},{"$f":"SUM(CM7:CN7)","v":0},{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP7*$C7","v":0},{"$f":"SUM(CP7:CQ7)","v":0}]
["ТВ","СТС",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Россия 24",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,0,0,0]
["ТВ","ТВЦ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP10*$C10","v":0},0]
["ТВ","НТВ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP11*$C11","v":0},0]
["ТВ","СТС Love",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Карусель",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Bugi-ретрро",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,{"$f":"CM14*$C14","v":0},0,{"$f":"SUMIFS(G14:CK14,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP14*$C14","v":0},0]
["Радио","Наше Радио",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM15*$C15","v":0},0,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP15*$C15","v":0},0]
["Радио","Радио ХИТ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Ретро Попса-мопса ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Радио России",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Супер Радио",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ИТОГО:",null,null,null,null,null,{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0},0,0,0,0,null,{"$f":"SUM(N7:N19)","v":0},{"$f":"SUM(O7:O19)","v":0},0,0,0,0,null,{"$f":"SUM(U7:U19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AB7:AB19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AI7:AI19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AP7:AP19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AW7:AW19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BD7:BD19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BK7:BK19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BR7:BR19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BY7:BY19)","v":0},0,0,0,0,0,null,{"$f":"SUM(CF7:CF19)","v":0},0,0,0,0,0,null,0,0,0,0,0,{"$f":"SUM(CR7:CR19)","v":0}]

{"sheet":"Разработка сайта","index":8,"n_rows":20,"n_cols":96,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,3,23,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[4,82,5,82],[4,83,4,85],[4,86,4,88],[4,90,4,92],[4,44,4,46],[4,47,5,47],[4,48,4,50],[4,51,4,53],[4,26,5,26],[4,27,4,29],[4,30,4,32],[4,33,5,33],[4,34,4,36],[4,37,4,39],[4,12,5,12],[4,93,4,95],[5,3,5,4],[4,68,5,68],[4,69,4,71],[4,72,4,74],[4,75,5,75],[4,76,4,78],[4,79,4,81],[4,54,5,54],[4,55,4,57],[4,58,4,60],[4,61,5,61],[4,62,4,64],[4,65,4,67],[4,40,5,40],[4,41,4,43],[4,0,4,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,4,8],[4,9,4,11],[3,54,3,60],[3,61,3,67],[3,68,3,74],[3,75,3,81],[3,5,3,11],[4,13,4,15],[4,16,4,18],[4,19,5,19],[4,20,4,22],[4,23,4,25],[3,82,3,88],[3,90,3,95],[3,12,3,18],[3,19,3,25],[3,26,3,32],[3,33,3,39],[3,40,3,46],[3,47,3,53],[0,1,0,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":9090.9090909090901},"Январь",null,null,null,null,null,null,"Февраль",null,null,null,null,null,null,"Март",null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,"Май",null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,"Июль",null,null,null,null,null,null,"Август",null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,"Декабрь",null,null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,null,"Плановый бюджет ",null,null,"Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ","Россия 1",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,{"$f":"G7*$C7","v":0},{"$f":"SUM(G7:H7)","v":0},null,{"$f":"J7*$C7","v":0},{"$f":"SUM(J7:K7)","v":0},null,null,{"$f":"N7*$C7","v":0},{"$f":"SUM(N7:O7)","v":0},null,{"$f":"Q7*$C7","v":0},{"$f":"SUM(Q7:R7)","v":0},null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,{"$f":"X7*$C7","v":0},{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"AB7*$C7","v":0},{"$f":"SUM(AB7:AC7)","v":0},null,{"$f":"AE7*$C7","v":0},{"$f":"SUM(AE7:AF7)","v":0},null,null,{"$f":"AI7*$C7","v":0},{"$f":"SUM(AI7:AJ7)","v":0},null,{"$f":"AL7*$C7","v":0},{"$f":"SUM(AL7:AM7)","v":0},null,null,{"$f":"AP7*$C7","v":0},{"$f":"SUM(AP7:AQ7)","v":0},null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,{"$f":"AW7*$C7","v":0},{"$f":"SUM(AW7:AX7)","v":0},null,{"$f":"AZ7*$C7","v":0},{"$f":"SUM(AZ7:BA7)","v":0},null,null,{"$f":"BD7*$C7","v":0},{"$f":"SUM(BD7:BE7)","v":0},null,{"$f":"BG7*$C7","v":0},{"$f":"SUM(BG7:BH7)","v":0},null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,{"$f":"BN7*$C7","v":0},{"$f":"SUM(BN7:BO7)","v":0},null,null,{"$f":"BR7*$C7","v":0},{"$f":"SUM(BR7:BS7)","v":0},null,{"$f":"BU7*$C7","v":0},{"$f":"SUM(BU7:BV7)","v":0},null,null,{"$f":"BY7*$C7","v":0},{"$f":"SUM(BY7:BZ7)","v":0},null,{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0},null,null,{"$f":"CF7*$C7","v":0},{"$f":"SUM(CF7:CG7)","v":0},null,{"$f":"CI7*$C7","v":0},{"$f":"SUM(CI7:CJ7)","v":0},null,{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM7*$C7","v":0},{"$f":"SUM(CM7:CN7)","v":0},{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP7*$C7","v":0},{"$f":"SUM(CP7:CQ7)","v":0}]
["ТВ","СТС",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Россия 24",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,0,0,0]
["ТВ","ТВЦ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP10*$C10","v":0},0]
["ТВ","НТВ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP11*$C11","v":0},0]
["ТВ","СТС Love",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Карусель",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Bugi-ретрро",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,{"$f":"CM14*$C14","v":0},0,{"$f":"SUMIFS(G14:CK14,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP14*$C14","v":0},0]
["Радио","Наше Радио",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM15*$C15","v":0},0,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP15*$C15","v":0},0]
["Радио","Радио ХИТ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Ретро Попса-мопса ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Радио России",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Супер Радио",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ИТОГО:",null,null,null,null,null,{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0},0,0,0,0,null,{"$f":"SUM(N7:N19)","v":0},{"$f":"SUM(O7:O19)","v":0},0,0,0,0,null,{"$f":"SUM(U7:U19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AB7:AB19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AI7:AI19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AP7:AP19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AW7:AW19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BD7:BD19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BK7:BK19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BR7:BR19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BY7:BY19)","v":0},0,0,0,0,0,null,{"$f":"SUM(CF7:CF19)","v":0},0,0,0,0,0,null,0,0,0,0,0,{"$f":"SUM(CR7:CR19)","v":0}]

{"sheet":"Контекcт","index":9,"n_rows":20,"n_cols":96,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,3,23,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[4,82,5,82],[4,83,4,85],[4,86,4,88],[4,90,4,92],[4,44,4,46],[4,47,5,47],[4,48,4,50],[4,51,4,53],[4,26,5,26],[4,27,4,29],[4,30,4,32],[4,33,5,33],[4,34,4,36],[4,37,4,39],[4,12,5,12],[4,93,4,95],[5,3,5,4],[4,68,5,68],[4,69,4,71],[4,72,4,74],[4,75,5,75],[4,76,4,78],[4,79,4,81],[4,54,5,54],[4,55,4,57],[4,58,4,60],[4,61,5,61],[4,62,4,64],[4,65,4,67],[4,40,5,40],[4,41,4,43],[4,0,4,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,4,8],[4,9,4,11],[3,54,3,60],[3,61,3,67],[3,68,3,74],[3,75,3,81],[3,5,3,11],[4,13,4,15],[4,16,4,18],[4,19,5,19],[4,20,4,22],[4,23,4,25],[3,82,3,88],[3,90,3,95],[3,12,3,18],[3,19,3,25],[3,26,3,32],[3,33,3,39],[3,40,3,46],[3,47,3,53],[0,1,0,2],[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
["Клиент и бренд:",{"$f":"'Карточка клиента'!$D$4 & \" (\" &'Карточка клиента'!$D$5 &\")\"","v":"ООО \"ФармПак\" (Деринат)"},null,"Калькулятор вычитания НДС"]
["Договор:",{"$f":"'Карточка клиента'!$D$7 & \" (\" &'Карточка клиента'!$D$8 &\")\"","v":"№202030 (SEO, контекст смм )"},null,"Сумма с НДС",10000]
["Период РК:",{"$f":"'Карточка клиента'!$D$10","v":"Сентябрь, Октябрь"},null,"НДС (%)",0.1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96]
["Бюджет (руб.)",{"$f":"'Карточка клиента'!$D$11","v":15000000},null,"Сумма без НДС",{"$f":"E2/(E3+1)","v":9090.9090909090901},"Январь",null,null,null,null,null,null,"Февраль",null,null,null,null,null,null,"Март",null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,"Май",null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,"Июль",null,null,null,null,null,null,"Август",null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,"Декабрь",null,null,null,null,null,null,null,"Итого"]
["Медийная информация",null,"Ставка НДС (%)","Основной документ",null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,"Подрядчик","Плановый бюджет ",null,null,"Фактический бюджет",null,null,null,"Плановый бюджет ",null,null,"Фактический бюджет"]
["Медиа","Рекламный канал",null,"Дополнительное соглашение",null,null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС",null,"Сумма без НДС","Сумма НДС","Сумма с НДС","Сумма без НДС","Сумма НДС","Сумма с НДС"]
["ТВ","Россия 1",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,{"$f":"G7*$C7","v":0},{"$f":"SUM(G7:H7)","v":0},null,{"$f":"J7*$C7","v":0},{"$f":"SUM(J7:K7)","v":0},null,null,{"$f":"N7*$C7","v":0},{"$f":"SUM(N7:O7)","v":0},null,{"$f":"Q7*$C7","v":0},{"$f":"SUM(Q7:R7)","v":0},null,null,{"$f":"U7*$C7","v":0},{"$f":"SUM(U7:V7)","v":0},null,{"$f":"X7*$C7","v":0},{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"AB7*$C7","v":0},{"$f":"SUM(AB7:AC7)","v":0},null,{"$f":"AE7*$C7","v":0},{"$f":"SUM(AE7:AF7)","v":0},null,null,{"$f":"AI7*$C7","v":0},{"$f":"SUM(AI7:AJ7)","v":0},null,{"$f":"AL7*$C7","v":0},{"$f":"SUM(AL7:AM7)","v":0},null,null,{"$f":"AP7*$C7","v":0},{"$f":"SUM(AP7:AQ7)","v":0},null,{"$f":"AS7*$C7","v":0},{"$f":"SUM(AS7:AT7)","v":0},null,null,{"$f":"AW7*$C7","v":0},{"$f":"SUM(AW7:AX7)","v":0},null,{"$f":"AZ7*$C7","v":0},{"$f":"SUM(AZ7:BA7)","v":0},null,null,{"$f":"BD7*$C7","v":0},{"$f":"SUM(BD7:BE7)","v":0},null,{"$f":"BG7*$C7","v":0},{"$f":"SUM(BG7:BH7)","v":0},null,null,{"$f":"BK7*$C7","v":0},{"$f":"SUM(BK7:BL7)","v":0},null,{"$f":"BN7*$C7","v":0},{"$f":"SUM(BN7:BO7)","v":0},null,null,{"$f":"BR7*$C7","v":0},{"$f":"SUM(BR7:BS7)","v":0},null,{"$f":"BU7*$C7","v":0},{"$f":"SUM(BU7:BV7)","v":0},null,null,{"$f":"BY7*$C7","v":0},{"$f":"SUM(BY7:BZ7)","v":0},null,{"$f":"CB7*$C7","v":0},{"$f":"SUM(CB7:CC7)","v":0},null,null,{"$f":"CF7*$C7","v":0},{"$f":"SUM(CF7:CG7)","v":0},null,{"$f":"CI7*$C7","v":0},{"$f":"SUM(CI7:CJ7)","v":0},null,{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM7*$C7","v":0},{"$f":"SUM(CM7:CN7)","v":0},{"$f":"SUMIFS(G7:CK7,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP7*$C7","v":0},{"$f":"SUM(CP7:CQ7)","v":0}]
["ТВ","СТС",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G8:CK8,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Россия 24",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,0,0,0]
["ТВ","ТВЦ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,0,0,{"$f":"SUMIFS(G10:CK10,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP10*$C10","v":0},0]
["ТВ","НТВ",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G11:CK11,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP11*$C11","v":0},0]
["ТВ","СТС Love",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G12:CK12,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ТВ","Карусель",0.1,"Приложение № 4 к Дополнительному соглашению  №26 от 23 декабря 2019 г.",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G13:CK13,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Bugi-ретрро",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,0,{"$f":"CM14*$C14","v":0},0,{"$f":"SUMIFS(G14:CK14,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP14*$C14","v":0},0]
["Радио","Наше Радио",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},{"$f":"CM15*$C15","v":0},0,{"$f":"SUMIFS(G15:CK15,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},{"$f":"CP15*$C15","v":0},0]
["Радио","Радио ХИТ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G16:CK16,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Ретро Попса-мопса ",0.1,"Приложение №45",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G17:CK17,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Радио России",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G18:CK18,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["Радио","Супер Радио",0.1,"Документы в процессе создания",null,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,null,0,0,null,0,0,null,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CM$5,$G$6:$CK$6,$CM$6)","v":0},0,0,{"$f":"SUMIFS(G19:CK19,$G$5:$CK$5,$CP$5,$G$6:$CK$6,$CP$6)","v":0},0,0]
["ИТОГО:",null,null,null,null,null,{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0},0,0,0,0,null,{"$f":"SUM(N7:N19)","v":0},{"$f":"SUM(O7:O19)","v":0},0,0,0,0,null,{"$f":"SUM(U7:U19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AB7:AB19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AI7:AI19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AP7:AP19)","v":0},0,0,0,0,0,null,{"$f":"SUM(AW7:AW19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BD7:BD19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BK7:BK19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BR7:BR19)","v":0},0,0,0,0,0,null,{"$f":"SUM(BY7:BY19)","v":0},0,0,0,0,0,null,{"$f":"SUM(CF7:CF19)","v":0},0,0,0,0,0,null,0,0,0,0,0,{"$f":"SUM(CR7:CR19)","v":0}]

{"sheet":"ИТОГОВАЯ СВОДНАЯ","index":10,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,1,1,2],[23,1,23,7],[12,1,12,7]]}
[]
[null,"КАРТОЧКА КЛИЕНТА "]
[null,"Клиент:",{"$f":"'Карточка клиента'!D4","v":"ООО \"ФармПак\""}]
[null,"Бренд:",{"$f":"'Карточка клиента'!D5","v":"Деринат"}]
[]
[null,"Договор:",{"$f":"'Карточка клиента'!D7","v":"№202030"}]
[null,"Предмет договора: ",{"$f":"'Карточка клиента'!D8","v":"SEO, контекст смм "},null,"Сводная по медиа."]
[]
[null,"Период РК:",{"$f":"'Карточка клиента'!D10","v":"Сентябрь, Октябрь"},null,"В сводной добавить за месяц."]
[null,"Бюджет (руб.)",{"$f":"'Карточка клиента'!D11","v":15000000},null,"Сводная по месячная"]
[]
[]
[null,"ИТОГОВАЯ СВОДНАЯ ПО МЕДИА"]
[null,"Медиа","Рекламный канал","Стоимость размещения для Клиента с НДС","Стоимость от подрядчиков ПЛАН","Стоимость от подрядчиков ФАКТ","Планирумая прибыль","Фактическая прибыль"]
[null,"Интернет"]
[null,"SЕО"]
[null,"Контекcт"]
[null,"ТВ"]
[null,"Разработка креатива"]
[null,"Разработка сайта"]
[null,"ООН"]
[]
[]
[null,"ПОДРОБНАЯ ИТОГОВАЯ СВОДНАЯ ПО ВСЕМ МЕДИА"]
[null,"Медиа","Рекламный канал","Стоимость размещения для Клиента с НДС","Стоимость от подрядчиков ПЛАН","Стоимость от подрядчиков ФАКТ","Планирумая прибыль","Фактическая прибыль"]
[null,"Интернет","Youtube (мамы с детьми)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!7:7)","v":0},null,null,{"$f":"D26-E26","v":0},{"$f":"D26-F26","v":0}]
[null,"Интернет","Youtube (Ж 25-55)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"D27-E27","v":{"$error":"#REF!"}},{"$f":"D27-F27","v":{"$error":"#REF!"}}]
[null,"Интернет","Блогеры",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"D28-E28","v":{"$error":"#REF!"}},{"$f":"D28-F28","v":{"$error":"#REF!"}}]
[null,"Интернет","Gismeteo (баннеры)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"D29-E29","v":{"$error":"#REF!"}},{"$f":"D29-F29","v":{"$error":"#REF!"}}]
[null,"Интернет"," MarieClaire.ru (статья)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"D30-E30","v":{"$error":"#REF!"}},{"$f":"D30-F30","v":{"$error":"#REF!"}}]
[null,"Интернет","Вести/Медицина (статья)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"D31-E31","v":{"$error":"#REF!"}},{"$f":"D31-F31","v":{"$error":"#REF!"}}]
[null,"Интернет","Агенты влияния (отзывы)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","Таргетированная реклама OK (видео)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","Таргетированная реклама IN (посты)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","Таргетированная реклама VK (посты)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","посев постов в группах VK (посты)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","Дневник (спецпроект)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","Проверено мамами (спецпроект)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","Programmatic (Аудитории)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","Programmatic (Mama Target)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Интернет","Programmatic (White list)",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Телевидение","Карусель",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Телевидение"," Триколор Наш Кинороман HD+SD",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Телевидение","Триколор Русский Роман",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!#REF!)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Телевидение","Триколор Кинопоказ HD+SD",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!22:22)","v":0},null,null,0,0]
[null,"Телевидение","Триколор Романтичное HD+SD",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!23:23)","v":0},null,null,0,0]
[null,"Телевидение","Триколор Комедийное HD+SD",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!24:24)","v":0},null,null,0,0]
[null,"SЕО","Технические работы по SEO оптимизации",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!25:25)","v":0},null,null,0,0]
[null,"SЕО","Дизайн",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!26:26)","v":0},null,null,0,0]
[null,"SЕО","Копирайтинг",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!27:27)","v":0},null,null,0,0]
[null,"SЕО","Ссылочная масса",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!28:28)","v":0},null,null,0,0]
[null,"SЕО","Программирование",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!29:29)","v":0},null,null,0,0]
[null,"SЕО","Оплата переменной части в SEO",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!30:30)","v":0},null,null,0,0]
[null,"Контекcт","Yandex Direct",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!31:31)","v":0},null,null,0,0]
[null,"Разработка креатива","Разработка реативной конциепции",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!32:32)","v":0},null,null,0,0]
[null,"Разработка креатива","Иллюстрации",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!33:33)","v":0},null,null,0,0]
[null,"Разработка креатива","Копирайтинг",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!34:34)","v":0},null,null,0,0]
[null,"Разработка креатива","Видео ролик",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!35:35)","v":0},null,null,0,0]
[null,"Разработка креатива","Иллюстрации",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!36:36)","v":0},null,null,0,0]
[null,"Разработка креатива","Копирайтинг",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!37:37)","v":0},null,null,0,0]
[null,"Разработка креатива","Видео ролик",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!38:38)","v":0},null,null,0,0]
[null,"Разработка сайта","Разрабока сайта",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!39:39)","v":0},null,null,0,0]
[null,"Разработка сайта","Разработка ТЗ",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!40:40)","v":0},null,null,0,0]
[null,"Разработка сайта","Дизайн",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!41:41)","v":0},null,null,0,0]
[null,"Разработка сайта","Верстка",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!42:42)","v":0},null,null,0,0]
[null,"Разработка сайта","Програмирование",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!43:43)","v":0},null,null,0,0]
[null,"Разработка сайта","Тестирование",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!44:44)","v":0},null,null,0,0]
[null,"Разработка сайта","Перенос на сторону Клиента",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!45:45)","v":0},null,null,0,0]
[null,"Разработка сайта","Техническая поддержка",{"$f":"SUMIF(Аккаунт!$6:$6,\"Сумма с НДС\",Аккаунт!46:46)","v":0},null,null,0,0]

{"sheet":"Сотрудники","index":11,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,2,2,2],[0,1,2,1],[0,0,2,0],[0,3,0,13]]}
["Должность","ФИО","Пароль","Доступ к листам книги"]
[null,null,null,"Account","List_001","List_002","List_003","List_004","List_005","List_006","List_007","List_008","Itog_svod_list","Staff_list"]
[null,null,null,"Аккаунты","ТВ","Радио","ООН","Интернет Медиа","SЕО","Разработка креатива","Разработка сайта","Контекcт","Итоговая сводная","Сотрудники"]
[null,"Севальос-Кальдерон Энрике",101010,"+","+","+","+","+","+","+","+","+","+","+"]
[null,"Волкова Виктория",1111,"+"]
[null,"Дашевская Татьяна",2222,"+"]
[null,"Соколова Ольга",3333,"+"]
[null,"Галкина Александра",4444,"+"]
[null,"Борычев Иван",5555,"+"]
[null,"Мазаева Кристина",2000,null,null,"+","+","+"]
[null,"Арсений Хан",7777,null,null,null,null,"+"]
[null,"Диана Гайфаджян",8888,null,null,null,null,"+"]
[null,"Гаплевский Константин",9999,null,null,null,null,"+"]
[null,"Ярошенко Евгений",4000,null,"+",null,null,"+"]
[null,"Никита Шабалин",5000,null,null,null,null,null,"+"]
[null,"Степанова Екатерина",6000,null,null,null,null,null,null,null,null,"+"]
[null,"Филатов Юрий",7000,null,null,null,null,null,null,null,null,"+"]
[]
[]
[]
[]
[]
[]
[null,"Никита Шабалин",null,null,null,"( здесь, возможно,ещё Галкина Александра,надо уточнить у Энрике. С этим пунктом сложно)"]
[]
[null,"Аккаунты:"]
[null,"Волкова Виктория"]
[null,"Дашевская Татьяна"]
[null,"Соколова Ольга"]
[null,"Галкина Александра"]
[null,"Борычев Иван"]
[]
[null,"Интернет "]
[null,"Кристина Мазаева, Арсений Хан,Диана Гайфаджян,Гаплевский Константин, Ярошенко Евгений"]
[]
[null,"Радио, ООН"]
[null,"Мазаева Кристина"]
[]
[null,"ТВ "]
[null,"Ярошенко Евгений"]
[]
[null,"SEO:"]
[null,"Никита Шабалин ( здесь, возможно,ещё Галкина Александра,надо уточнить у Энрике. С этим пунктом сложно)"]
[]
[null,"Контекст:"]
[null,"Степанова Екатерина, Филатов Юрий"]

{"sheet":"Технический","index":12,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Наименование","программное имя ","Сохраняемое значение",null,null,"Пароли"]
["Галочка в аккаунт форме","Add_media_account",false,null,"На листы",555]
["ФИО кто вошел в книгу","ComboBox_FIO","Ярошенко Евгений",null,"На книгу"]
["Открывшиеся листы:","SaveListLog","List_TV / List_Internet"]