{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Результат"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Результат","index":0,"n_rows":33,"n_cols":99,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,59,0,61],[0,62,0,64],[0,66,0,76],[0,77,0,87],[0,88,0,98],[0,25,0,34],[0,35,0,46],[0,48,0,49],[0,50,0,52],[0,53,0,55],[0,56,0,58],[0,7,1,7],[0,11,1,11],[0,12,1,12],[0,13,1,13],[0,14,1,14],[0,15,0,24],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5]]}
["Город","Канал","БА","Тип продажи","Точка продажи","TVR БА","TVR ЦА","Affinity","Share","Cum.Reach %","wTotal","Prime","CPP ","CPP TRP ","CPT ","Reached CPT",null,null,null,null,null,null,null,null,null,"Frequency Distribution",null,null,null,null,null,null,null,null,null,"CPP/CPM (без НДС)",null,null,null,null,null,null,null,null,null,null,null,null,"Коэффициенты",null,"CPP c каналами",null,null,"Варианты сплитов",null,null,"Оценочный коэффициент",null,null,"TRP",null,null,"GRP'30",null,null,null,"натуральный",null,null,null,null,null,null,null,null,null,null,"натуральный с aff",null,null,null,null,null,null,null,null,null,null,"мин СРР "]
[null,null,null,null,null,null,"W 25+",null,"W 25+","W 25+","W 25+",null,null,null,null,"1+","2+","3+","4+","5+","6+","7+","8+","9+","10+","1+","2+","3+","4+","5+","6+","7+","8+","9+","10+","Январь","Февраль","Март","Апрель","Май","Июнь","Июль","Август","Сентябрь","Октябрь","Ноябрь","Декабрь",null,"Каналов","коэфф","Натуральный","Нат. с aff","мин. СРР ","Натуральный","Нат. с aff","мин. СРР ","Натуральный","Нат. с aff","мин. СРР ","Натуральный","Нат. с aff","мин. СРР ","Натуральный","Нат. с aff","мин. СРР ",null,"Кол-во каналов","CPP на ЦА","Affinity сплита","Хр-ж","GRP'30","TRP\"30","Оценка бюджета","Охват 5+","OTS","CPP per Reach","CPP per OTS","Кол-во каналов","CPP на ЦА","Affinity сплита","Хр-ж","GRP'30","TRP\"30","Оценка бюджета","Охват 5+","OTS","CPP per Reach","CPP per OTS","Кол-во каналов","CPP на ЦА","Affinity сплита","Хр-ж","GRP'30","TRP\"30","Оценка бюджета","Охват 5+","OTS","CPP per Reach","CPP per OTS"]
["Москва","Первый","All 14-59","GRP","ВИ",1.46,3.03,{"$f":"G3/F3*100","v":207.53424657534248},14.319999694824219,86.680000305175781,6215.68017578125,0.6,{"$f":"AVERAGE(AJ3:AU3)","v":{"$error":"#DIV/0!"}},{"$f":"M3/H3*100","v":{"$error":"#DIV/0!"}},{"$f":"M3*F3/(K3/100*G3)","v":{"$error":"#DIV/0!"}},{"$f":"$O3/Z3*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},86.68,83.76,81.95,80.81,79.53,78.849999999999994,77.239999999999995,75.64,74.56,73.84,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,{"$f":"$N3-(INDEX($AW3:$AX6,BO3,2)*$N3)","v":{"$error":"#DIV/0!"}},{"$f":"$N3-(INDEX($AW3:$AX6,BO3,2)*$N3)","v":{"$error":"#DIV/0!"}},{"$f":"$N3-(INDEX($AW3:$AX6,BO3,2)*$N3)","v":{"$error":"#DIV/0!"}},{"$f":"$G3/SUM($G3:$G6)","v":0.42200557103064068},{"$f":"$BF3/SUM($BF3:$BF6)","v":0.41673074326753273},{"$f":"IF(BG3<>\"\",$BG3/SUM($BG3:$BG6),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H3*$H7+$I3*$I7","v":110.92712313508335},{"$f":"$H3*$H7+$I3*$I7","v":110.92712313508335},{"$f":"IF($P3<$P7,$BF3,\"\")","v":{"$error":"#DIV/0!"}}]
["Москва","Россия 1","All 25+","GRP","ВИ",2.1,2.82,{"$f":"G4/F4*100","v":134.28571428571428},13.930000305175781,82.480003356933594,6215.68017578125,0.6,{"$f":"AVERAGE(AJ4:AU4)","v":{"$error":"#DIV/0!"}},{"$f":"M4/H4*100","v":{"$error":"#DIV/0!"}},{"$f":"M4*F4/(K4/100*G4)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},82.48,80.010000000000005,77.91,76.55,74.44,73.709999999999994,72.290000000000006,71.47,70.819999999999993,69.650000000000006,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.01,{"$f":"$N4-(INDEX($AW3:$AX6,BO3,2)*$N4)","v":{"$error":"#DIV/0!"}},{"$f":"$N4-(INDEX($AW3:$AX6,BO3,2)*$N4)","v":{"$error":"#DIV/0!"}},{"$f":"$N4-(INDEX($AW3:$AX6,BO3,2)*$N4)","v":{"$error":"#DIV/0!"}},{"$f":"$G4/SUM($G3:$G6)","v":0.39275766016713093},{"$f":"$BF4/SUM($BF3:$BF6)","v":0.27840821595171761},{"$f":"IF(BG4<>\"\",$BG4/SUM($BG3:$BG6),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H4*$H7+$I4*$I7","v":74.107857295445029},{"$f":"$H4*$H7+$I4*$I7","v":74.107857295445029},{"$f":"IF($P4<$P7,$BF4,\"\")","v":{"$error":"#DIV/0!"}}]
["Москва","НТВ","All 18+","GRP","Алькасар",0.28000000000000003,0.23,{"$f":"G5/F5*100","v":82.142857142857139},1.0800000429153442,45.869998931884766,6215.68017578125,0.6,{"$f":"AVERAGE(AJ5:AU5)","v":{"$error":"#DIV/0!"}},{"$f":"M5/H5*100","v":{"$error":"#DIV/0!"}},{"$f":"M5*F5/(K5/100*G5)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},45.87,39.17,32.03,28.08,24.59,22.1,20.79,19.3,17.77,16.399999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.4999999999999999E-2,{"$f":"$N5-(INDEX($AW3:$AX6,BO3,2)*$N5)","v":{"$error":"#DIV/0!"}},{"$f":"$N5-(INDEX($AW3:$AX6,BO3,2)*$N5)","v":{"$error":"#DIV/0!"}},{"$f":"$N5-(INDEX($AW3:$AX6,BO3,2)*$N5)","v":{"$error":"#DIV/0!"}},{"$f":"$G5/SUM($G3:$G6)","v":3.2033426183844013E-2},{"$f":"$BF5/SUM($BF3:$BF6)","v":0.1563257125565255},{"$f":"IF(BG5<>\"\",$BG5/SUM($BG3:$BG6),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H5*$H7+$I5*$I7","v":41.611428592886242},{"$f":"$H5*$H7+$I5*$I7","v":41.611428592886242},{"$f":"IF($P5<$P7,$BF5,\"\")","v":{"$error":"#DIV/0!"}}]
["Москва","ТНТ","All 14-44","GRP","Алькасар",1.49,1.1000000000000001,{"$f":"G6/F6*100","v":73.825503355704697},5.25,59.709999084472656,6215.68017578125,0.6,{"$f":"AVERAGE(AJ6:AU6)","v":{"$error":"#DIV/0!"}},{"$f":"M6/H6*100","v":{"$error":"#DIV/0!"}},{"$f":"M6*F6/(K6/100*G6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},59.71,56.51,54.23,52.01,50.77,49.35,48.64,47.24,45.91,44.56,null,null,null,null,null,null,null,null,null,null,null,null,null,4,1.95E-2,{"$f":"$N6-(INDEX($AW3:$AX6,BO3,2)*$N6)","v":{"$error":"#DIV/0!"}},{"$f":"$N6-(INDEX($AW3:$AX6,BO3,2)*$N6)","v":{"$error":"#DIV/0!"}},{"$f":"$N6-(INDEX($AW3:$AX6,BO3,2)*$N6)","v":{"$error":"#DIV/0!"}},{"$f":"$G6/SUM($G3:$G6)","v":0.15320334261838442},{"$f":"$BF6/SUM($BF3:$BF6)","v":0.1485353282242243},{"$f":"IF(BG6<>\"\",$BG6/SUM($BG3:$BG6),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H6*$H7+$I6*$I7","v":39.537751677852349},{"$f":"$H6*$H7+$I6*$I7","v":39.537751677852349},{"$f":"IF($P6<$P7,$BF6,\"\")","v":{"$error":"#DIV/0!"}}]
["МОСКВА","TOTAL",null,null,null,null,null,0.5,0.5,null,null,null,{"$f":"AVERAGE(M3:M6)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N3:N6)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O3:O6)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P3:P6)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AY3:AY6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,1,{"$error":"#DIV/0!"},266.18416070126693,266.18416070126693,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,3,153636.751367841,86.714514545909438,20,450.364694815885,390.53155879576161,60000000,50.41,89983.93,1190240.0317397343,666.78572496222387,19,132793.87564717079,88.606775095115012,20,509.92496390640355,451.82806592239342,60000,52.51,104335.89,1142639.4972386213,575.06578033694825,10,136745.67664293863,98.992867478322538,20,443.23468802147903,438.77072733105905,60000000,50.38,101064.3,1190948.7892020643,593.6814483452614]
["Самара","Первый","All 18+","GRP","ВИ",2.06,3.03,{"$f":"G8/F8*100","v":147.08737864077668},14.319999694824219,86.680000305175781,6215.68017578125,0.6,{"$f":"AVERAGE(AJ8:AU8)","v":{"$error":"#DIV/0!"}},{"$f":"M8/H8*100","v":{"$error":"#DIV/0!"}},{"$f":"M8*F8/(K8/100*G8)","v":{"$error":"#DIV/0!"}},{"$f":"$O8/Z8*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},86.68,83.76,81.95,80.81,79.53,78.849999999999994,77.239999999999995,75.64,74.56,73.84,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,{"$f":"$N8-(INDEX($AW8:$AX10,BO8,2)*$N8)","v":{"$error":"#DIV/0!"}},{"$f":"$N8-(INDEX($AW8:$AX10,BO8,2)*$N8)","v":{"$error":"#DIV/0!"}},{"$f":"$N8-(INDEX($AW8:$AX10,BO8,2)*$N8)","v":{"$error":"#DIV/0!"}},{"$f":"$G8/SUM($G8:$G10)","v":0.40185676392572944},{"$f":"$BF8/SUM($BF8:$BF10)","v":0.36253403865005379},{"$f":"IF(BG8<>\"\",$BG8/SUM($BG8:$BG10),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H8*$H11+$I8*$I11","v":80.703689167800448},{"$f":"$H8*$H11+$I8*$I11","v":80.703689167800448},{"$f":"IF($P8<$P11,$BF8,\"\")","v":{"$error":"#DIV/0!"}}]
["Самара","Россия 1","All 18+","GRP","ВИ",1.94,2.82,{"$f":"G9/F9*100","v":145.36082474226802},13.930000305175781,82.480003356933594,6215.68017578125,0.6,{"$f":"AVERAGE(AJ9:AU9)","v":{"$error":"#DIV/0!"}},{"$f":"M9/H9*100","v":{"$error":"#DIV/0!"}},{"$f":"M9*F9/(K9/100*G9)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},82.48,80.010000000000005,77.91,76.55,74.44,73.709999999999994,72.290000000000006,71.47,70.819999999999993,69.650000000000006,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.01,{"$f":"$N9-(INDEX($AW8:$AX10,BO8,2)*$N9)","v":{"$error":"#DIV/0!"}},{"$f":"$N9-(INDEX($AW8:$AX10,BO8,2)*$N9)","v":{"$error":"#DIV/0!"}},{"$f":"$N9-(INDEX($AW8:$AX10,BO8,2)*$N9)","v":{"$error":"#DIV/0!"}},{"$f":"$G9/SUM($G8:$G10)","v":0.37400530503978779},{"$f":"$BF9/SUM($BF8:$BF10)","v":0.35778008861700006},{"$f":"IF(BG9<>\"\",$BG9/SUM($BG8:$BG10),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H9*$H11+$I9*$I11","v":79.645412523721902},{"$f":"$H9*$H11+$I9*$I11","v":79.645412523721902},{"$f":"IF($P9<$P11,$BF9,\"\")","v":{"$error":"#DIV/0!"}}]
["Самара","НТВ","All 18+","GRP","Алькасар",1.45,1.69,{"$f":"G10/F10*100","v":116.55172413793105},7.9699997901916504,77.970001220703125,6215.68017578125,0.6,{"$f":"AVERAGE(AJ10:AU10)","v":{"$error":"#DIV/0!"}},{"$f":"M10/H10*100","v":{"$error":"#DIV/0!"}},{"$f":"M10*F10/(K10/100*G10)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},77.97,74.16,72.33,70.510000000000005,69.27,68.44,67.25,65.55,64.760000000000005,63.33,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.4999999999999999E-2,{"$f":"$N10-(INDEX($AW8:$AX10,BO8,2)*$N10)","v":{"$error":"#DIV/0!"}},{"$f":"$N10-(INDEX($AW8:$AX10,BO8,2)*$N10)","v":{"$error":"#DIV/0!"}},{"$f":"$N10-(INDEX($AW8:$AX10,BO8,2)*$N10)","v":{"$error":"#DIV/0!"}},{"$f":"$G10/SUM($G8:$G10)","v":0.22413793103448279},{"$f":"$BF10/SUM($BF8:$BF10)","v":0.27968587273294615},{"$f":"IF(BG10<>\"\",$BG10/SUM($BG8:$BG10),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H10*$H11+$I10*$I11","v":62.260861964061348},{"$f":"$H10*$H11+$I10*$I11","v":62.260861964061348},{"$f":"IF($P10<$P11,$BF10,\"\")","v":{"$error":"#DIV/0!"}}]
["САМАРА","TOTAL",null,null,null,null,null,0.5,0.5,null,null,null,{"$f":"AVERAGE(M8:M10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N8:N10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O8:O10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P8:P10)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AY8:AY10)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,1,{"$error":"#DIV/0!"},222.6099636555837,222.6099636555837,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,19,153636.7513678415,86.714514545909438,20,450.364694815885,390.53155879576161,60000000,50.41,89983.93,1190240.0317397343,666.78572496222387,19,132793.87564717079,88.606775095115012,20,509.92496390640355,451.82806592239342,60000000,52.51,104335.89,1142639.4972386213,575.06578033694825,10,136745.67664293863,98.992867478322538,20,443.23468802147903,438.77072733105905,60000000,50.38,101064.3,1190948.7892020643,593.6814483452614]
["Екатеринбург","Первый","All 18+","GRP","ВИ",2.06,3.03,{"$f":"G12/F12*100","v":147.08737864077668},14.319999694824219,86.680000305175781,6215.68017578125,0.6,{"$f":"AVERAGE(AJ12:AU12)","v":{"$error":"#DIV/0!"}},{"$f":"M12/H12*100","v":{"$error":"#DIV/0!"}},{"$f":"M12*F12/(K12/100*G12)","v":{"$error":"#DIV/0!"}},{"$f":"$O12/Z12*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},86.68,83.76,81.95,80.81,79.53,78.849999999999994,77.239999999999995,75.64,74.56,73.84,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,{"$f":"$N12-(INDEX($AW12:$AX14,BO12,2)*$N12)","v":{"$error":"#DIV/0!"}},{"$f":"$N12-(INDEX($AW12:$AX14,BO12,2)*$N12)","v":{"$error":"#DIV/0!"}},{"$f":"$N12-(INDEX($AW12:$AX14,BO12,2)*$N12)","v":{"$error":"#DIV/0!"}},{"$f":"$G12/SUM($G12:$G14)","v":0.40185676392572944},{"$f":"$BF12/SUM($BF12:$BF14)","v":0.3243272873501537},{"$f":"IF(BG12<>\"\",$BG12/SUM($BG12:$BG14),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H12*$H15+$I12*$I15","v":80.703689167800448},{"$f":"$H12*$H15+$I12*$I15","v":80.703689167800448},{"$f":"IF($P12<$P15,$BF12,\"\")","v":{"$error":"#DIV/0!"}}]
["Екатеринбург","Россия 1","All 18+","GRP","ВИ",1.94,2.82,{"$f":"G13/F13*100","v":145.36082474226802},13.930000305175781,82.480003356933594,6215.68017578125,0.6,{"$f":"AVERAGE(AJ13:AU13)","v":{"$error":"#DIV/0!"}},{"$f":"M13/H13*100","v":{"$error":"#DIV/0!"}},{"$f":"M13*F13/(K13/100*G13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},82.48,80.010000000000005,77.91,76.55,74.44,73.709999999999994,72.290000000000006,71.47,70.819999999999993,69.650000000000006,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.01,{"$f":"$N13-(INDEX($AW12:$AX14,BO12,2)*$N13)","v":{"$error":"#DIV/0!"}},{"$f":"$N13-(INDEX($AW12:$AX14,BO12,2)*$N13)","v":{"$error":"#DIV/0!"}},{"$f":"$N13-(INDEX($AW12:$AX14,BO12,2)*$N13)","v":{"$error":"#DIV/0!"}},{"$f":"$G13/SUM($G12:$G14)","v":0.37400530503978779},{"$f":"$BF13/SUM($BF12:$BF14)","v":0.32007434678722141},{"$f":"IF(BG13<>\"\",$BG13/SUM($BG12:$BG14),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H13*$H15+$I13*$I15","v":79.645412523721902},{"$f":"$H13*$H15+$I13*$I15","v":79.645412523721902},{"$f":"IF($P13<$P15,$BF13,\"\")","v":{"$error":"#DIV/0!"}}]
["Екатеринбург","НТВ","All 25-59","GRP","Алькасар",1,1.69,{"$f":"G14/F14*100","v":169},7.9699997901916504,77.970001220703125,6215.68017578125,0.6,{"$f":"AVERAGE(AJ14:AU14)","v":{"$error":"#DIV/0!"}},{"$f":"M14/H14*100","v":{"$error":"#DIV/0!"}},{"$f":"M14*F14/(K14/100*G14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},77.97,74.16,72.33,70.510000000000005,69.27,68.44,67.25,65.55,64.760000000000005,63.33,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.4999999999999999E-2,{"$f":"$N14-(INDEX($AW12:$AX14,BO12,2)*$N14)","v":{"$error":"#DIV/0!"}},{"$f":"$N14-(INDEX($AW12:$AX14,BO12,2)*$N14)","v":{"$error":"#DIV/0!"}},{"$f":"$N14-(INDEX($AW12:$AX14,BO12,2)*$N14)","v":{"$error":"#DIV/0!"}},{"$f":"$G14/SUM($G12:$G14)","v":0.22413793103448279},{"$f":"$BF14/SUM($BF12:$BF14)","v":0.35559836586262494},{"$f":"IF(BG14<>\"\",$BG14/SUM($BG12:$BG14),0)","v":{"$error":"#DIV/0!"}},{"$f":"$H14*$H15+$I14*$I15","v":88.484999895095825},{"$f":"$H14*$H15+$I14*$I15","v":88.484999895095825},{"$f":"IF($P14<$P15,$BF14,\"\")","v":{"$error":"#DIV/0!"}}]
["ЕКАТЕРИНБУРГ","TOTAL",null,null,null,null,null,0.5,0.5,null,null,null,{"$f":"AVERAGE(M12:M14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N12:N14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O12:O14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P12:P14)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AY12:AY14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,1,{"$error":"#DIV/0!"},248.83410158661817,248.83410158661817,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,19,153636.7513678415,86.714514545909438,20,450.364694815885,390.53155879576161,60000000,50.41,89983.93,1190240.0317397343,666.78572496222387,19,132793.87564717079,88.606775095115012,20,509.92496390640355,451.82806592239342,60000000,52.51,104335.89,1142639.4972386213,575.06578033694825,10,136745.67664293863,98.992867478322538,20,443.23468802147903,438.77072733105905,60000000,50.38,101064.3,1190948.7892020643,593.6814483452614]
[1,2,3,4,5,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,97,98,99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,2,3,4,5,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]
["Пример данных",null,null,null,null,"Пример данных",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Итоговые данные","натуральный","нат с aff","мин СРР ",null,"Итоговые данные","натуральный","нат с aff","мин СРР "]
["Кол-во каналов",3,19,10,null,"Кол-во каналов",19,19,10]
["CPP на ЦА","15 3636,75","13 2793,88","13 6745,68",null,"CPP на ЦА",153636.7513678415,132793.87564717079,136745.67664293863]
["Affinity сплита",87,89,99,null,"Affinity сплита",86.714514545909438,88.606775095115012,98.992867478322538,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Итоговые данные","натуральный","нат с aff","мин СРР "]
["Хронометраж",20,20,20,null,"Хронометраж",20,20,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Кол-во каналов",19,19,10]
["GRP '30'"," 450,36"," 509,92"," 443,23",null,"GRP'30",450.36469481588546,509.92496390640355,443.23468802147903,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPP на ЦА",153636.7513678415,132793.87564717079,136745.67664293863]
["TRP '30'"," 390,53"," 451,83"," 438,77",null,"TRP\"30",390.53155879576161,451.82806592239342,438.77072733105905,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affinity сплита",86.714514545909438,88.606775095115012,98.992867478322538]
["Оценка бюджета","60 000 000"," 60 000","60 000 000",null,"Оценка бюджета",60000000,60000000,60000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Хронометраж",20,20,20]
["Охват 5+"," 50,41"," 52,51"," 50,38",null,"Охват 5+",50.41,52.51,50.38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRP'30",450.36469481588546,509.92496390640355,443.23468802147903]
["OTS"," 89 984"," 104 336"," 101 064",null,"OTS",89983.93,104335.89,101064.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRP\"30",390.53155879576161,451.82806592239342,438.77072733105905]
["CPP per Reach","1 190 240","1 142 639","1 190 949",null,"CPP per Reach",1190240.0317397299,1142639.4972386213,1190948.7892020643,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Оценка бюджета",60000000,60000000,60000000]
["CPP per OTS"," 666,79"," 575,07"," 593,68",null,"CPP per OTS",666.78572496222387,575.06578033694825,593.6814483452614,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Охват 5+",50.41,52.51,50.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTS",89983.93,104335.89,101064.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPP per Reach",1190240.0317397299,1142639.4972386213,1190948.7892020643]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPP per OTS",666.78572496222387,575.06578033694825,593.6814483452614]