{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Лист1","index":0,"n_rows":20,"n_cols":26,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,4,10,4],[8,5,10,5],[8,6,10,6],[8,7,10,7],[8,8,10,8],[8,9,8,25],[9,9,10,9],[9,10,9,18],[9,19,9,20],[9,21,10,21],[9,22,10,22],[9,23,10,23],[9,24,10,24],[9,25,10,25],[8,3,9,3]]}
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,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]
[null,null,1,"Канал","тип","fix","доля канала","Affinity","Доля Prime ","Январь"]
[null,null,1,null,null,null,null,null,null,"Дней","Выходы",null,null,null,null,null,null,null,null,"TVR",null,"30\"GRP / мин.","TRP","CPP / CPM","Бюджет\nбез НДС","Бюджет\nс НДС"]
[null,null,1,"Удалить (-)",null,null,null,null,null,null,30,20,15,10,5,"Итого","prime","off","В день","prime","off"]
[null,null,1,"Первый (ВИ)","GRP",0.5,0.3,80,0.6,86,{"$f":"IF(K$7<>0,P12*K$7,0)","v":0},{"$f":"IF(L$7<>0,P12*L$7,0)","v":0},{"$f":"IF(M$7<>0,P12*M$7,0)","v":0},{"$f":"IF(N$7<>0,P12*N$7,0)","v":0},{"$f":"IF(O$7<>0,P12*O$7,0)","v":0},{"$f":"Q12+R12","v":0},{"$f":"IF(Q$7=0,0,IF($E12=\"grp\",V12*$I12*30/Q$7/T12,IF($I12=1,W12/T12,R12*$I12/(1-$I12))))","v":0},{"$f":"IF(Q$7=0,0,IF($E12=\"grp\",V12*(1-$I12)*30/Q$7/U12,IF($I12=1,0,W12*100/$H12/(U12+$I12/(1-$I12)*T12))))","v":0},{"$f":"IF(J12=0,0,P12/J12)","v":0},0.5,0.5,{"$f":"IF(E12=\"grp\",Q$7/30*W12*100/H12,P12*Q$7/60)","v":0},0,0,{"$f":"IF(X12=0,0,V12*X12)","v":0},{"$f":"IF(Y12=0,0,Y12*1.18)","v":0}]
[null,null,2,"Россия 1 (ВИ)","GRP",0.5,0.3,92.857142857142875,1,86,0,0,0,0,0,0,0,0,0,2,1,0,0,0,0,0]
[null,null,3,"РЕН ТВ (ВИ)","GRP",0.5,0.4,94.73684210526315,1,86,0,0,0,0,0,0,0,0,0,2,1,0,0,0,0,0]
[null,null,4,"ТВ3 (ВИ)","GRP",0.5,null,94.73684210526315,0.7,86,0,0,0,0,0,0,0,0,0,2,1,0,0,0,0,0]
[null,null,5,"Россия 2 (ВИ)","GRP",0.5,null,94.736842105263193,0.7,86,0,0,0,0,0,0,0,0,0,2,1,0,0,0,0,0]
[null,null,6,"Ю (ВИ)","GRP",0.5,null,94.73684210526315,1,86,0,0,0,0,0,0,0,0,0,2,1,0,{"$f":"SUM(W12:W16)","v":0},0,0,0]
[null,null,7,"Пятница (ВИ)","GRP",0.6,null,94.73684210526315,0.6,86,{"$f":"IF(K$7<>0,P18*K$7,0)","v":0},{"$f":"IF(L$7<>0,P18*L$7,0)","v":0},{"$f":"IF(M$7<>0,P18*M$7,0)","v":0},{"$f":"IF(N$7<>0,P18*N$7,0)","v":0},{"$f":"IF(O$7<>0,P18*O$7,0)","v":0},{"$f":"Q18+R18","v":0},{"$f":"IF(Q$7=0,0,IF($E18=\"grp\",V18*$I18*30/Q$7/T18,IF($I18=1,W18/T18,R18*$I18/(1-$I18))))","v":0},{"$f":"IF(Q$7=0,0,IF($E18=\"grp\",V18*(1-$I18)*30/Q$7/U18,IF($I18=1,0,W18*100/$H18/(U18+$I18/(1-$I18)*T18))))","v":0},{"$f":"IF(J18=0,0,P18/J18)","v":0},2,1,{"$f":"IF(E18=\"grp\",Q$7/30*W18*100/H18,P18*Q$7/60)","v":0},0,0,{"$f":"IF(X18=0,0,V18*X18)","v":0},{"$f":"IF(Y18=0,0,Y18*1.18)","v":0}]
[null,null,7,"ТНТ (ГПМ)","GRP",0.6,null,94.73684210526315,0.6,86,0,0,0,0,0,0,0,0,0,2,1,0,0,0,0,0]
[null,null,null,"Добавить (+)",null,null,{"$f":"SUM(G12:G19)","v":1},null,null,86,{"$f":"SUM(K12:K19)","v":0},{"$f":"SUM(L12:L19)","v":0},{"$f":"SUM(M12:M19)","v":0},{"$f":"SUM(N12:N19)","v":0},{"$f":"SUM(O12:O19)","v":0},{"$f":"SUM(P12:P19)","v":0},{"$f":"SUM(Q12:Q19)","v":0},{"$f":"SUM(R12:R19)","v":0},{"$f":"SUM(S12:S19)","v":0},null,null,{"$f":"SUM(V12:V19)","v":0},55,null,{"$f":"SUM(Y12:Y19)","v":0},{"$f":"SUM(Z12:Z19)","v":0}]