{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Total","shape","01.03.2013","02.03.2013"],"not_rendered":{"charts":1,"images":0,"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":"Total","index":0,"n_rows":44,"n_cols":25,"rows_kept":44,"cut":false,"hidden":false,"merged":[[32,1,32,3],[4,23,5,23],[4,13,4,22],[4,24,5,24],[4,1,5,1],[4,2,5,2],[4,3,4,12]]}
[null,"Анкета посетителя салона «Инволюкс»:___"]
[null,"Период проведения анкетирования: ",null,"с","2013-03-01","по","2013-03-02"]
[]
[]
[null,"Дата посещения","Кол-во посетителей","Канал коммуникации",null,null,null,null,null,null,null,null,null,"Какая мебель интерессует",null,null,null,null,null,null,null,null,null,"Сумма покупки","Совершили покупку"]
[null,null,null,"ТВ","Радио","Интернет","Наружная реклама (лайтпостеры, билборды, экраны)","Печатные СМИ (газеты, журналы)","Адреская рассылки (директмэйл)","По рекомендации (друзья, соседи, знакомые)","…","…","Другое","Детские","Спальни","Гостиные","Прихожие","Обеденные группы","Комп. столы","Мягкая мебель","Лампы, свет","Постельное бельё","Другое "]
[]
[null,"01.03.2013",{"$f":"'01.03.2013'!B29","v":0},{"$f":"'01.03.2013'!C29","v":0},{"$f":"'01.03.2013'!D29","v":0},{"$f":"'01.03.2013'!E29","v":0},{"$f":"'01.03.2013'!F29","v":0},{"$f":"'01.03.2013'!G29","v":0},{"$f":"'01.03.2013'!H29","v":0},{"$f":"'01.03.2013'!I29","v":0},{"$f":"'01.03.2013'!J29","v":0},{"$f":"'01.03.2013'!K29","v":0},{"$f":"'01.03.2013'!L29","v":0},{"$f":"'01.03.2013'!M29","v":0},{"$f":"'01.03.2013'!N29","v":0},{"$f":"'01.03.2013'!O29","v":0},{"$f":"'01.03.2013'!P29","v":0},{"$f":"'01.03.2013'!Q29","v":0},{"$f":"'01.03.2013'!R29","v":0},{"$f":"'01.03.2013'!S29","v":0},{"$f":"'01.03.2013'!T29","v":0},{"$f":"'01.03.2013'!U29","v":0},{"$f":"'01.03.2013'!V29","v":0},{"$f":"'01.03.2013'!W29","v":0},{"$f":"'01.03.2013'!X29","v":0}]
[null,"02.03.2013",{"$f":"'02.03.2013'!B29","v":0},{"$f":"'02.03.2013'!C29","v":0},{"$f":"'02.03.2013'!D29","v":0},{"$f":"'02.03.2013'!E29","v":0},{"$f":"'02.03.2013'!F29","v":0},{"$f":"'02.03.2013'!G29","v":0},{"$f":"'02.03.2013'!H29","v":0},{"$f":"'02.03.2013'!I29","v":0},{"$f":"'02.03.2013'!J29","v":0},{"$f":"'02.03.2013'!K29","v":0},{"$f":"'02.03.2013'!L29","v":0},{"$f":"'02.03.2013'!M29","v":0},{"$f":"'02.03.2013'!N29","v":0},{"$f":"'02.03.2013'!O29","v":0},{"$f":"'02.03.2013'!P29","v":0},{"$f":"'02.03.2013'!Q29","v":0},{"$f":"'02.03.2013'!R29","v":0},{"$f":"'02.03.2013'!S29","v":0},{"$f":"'02.03.2013'!T29","v":0},{"$f":"'02.03.2013'!U29","v":0},{"$f":"'02.03.2013'!V29","v":0},{"$f":"'02.03.2013'!W29","v":0},{"$f":"'02.03.2013'!X29","v":0}]
[]
[null,null,{"$f":"SUM(C7:C10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"РЕЗУЛЬТАТЫ АНКЕТИРОВАНИЯ"]
[]
[null,"Каналы","Всего посетителей","Совершили покупку","Сумма покупки"]
[null,"В целом",{"$f":"C11","v":0},{"$f":"Y11","v":0},{"$f":"X11","v":0}]
[1,"ТВ",{"$f":"D11","v":0},{"$f":"'01.03.2013'!D38+'02.03.2013'!D38","v":0},{"$f":"'01.03.2013'!E38+'02.03.2013'!E38","v":0}]
[2,"Радио",{"$f":"E11","v":0},{"$f":"'01.03.2013'!D39+'02.03.2013'!D39","v":0},{"$f":"'01.03.2013'!E39+'02.03.2013'!E39","v":0}]
[3,"Интернет",{"$f":"F11","v":0},{"$f":"'01.03.2013'!D40+'02.03.2013'!D40","v":0},{"$f":"'01.03.2013'!E40+'02.03.2013'!E40","v":0}]
[4,"наружная реклама",{"$f":"G11","v":0},{"$f":"'01.03.2013'!D41+'02.03.2013'!D41","v":0},{"$f":"'01.03.2013'!E41+'02.03.2013'!E41","v":0}]
[5,"Печатные СМИ",{"$f":"H11","v":0},{"$f":"'01.03.2013'!D42+'02.03.2013'!D42","v":0},{"$f":"'01.03.2013'!E42+'02.03.2013'!E42","v":0}]
[6,"Адреская рассылка",{"$f":"I11","v":0},{"$f":"'01.03.2013'!D43+'02.03.2013'!D43","v":0},{"$f":"'01.03.2013'!E43+'02.03.2013'!E43","v":0}]
[7,"По рекомендации",{"$f":"J11","v":0},{"$f":"'01.03.2013'!D44+'02.03.2013'!D44","v":0},{"$f":"'01.03.2013'!E44+'02.03.2013'!E44","v":0}]
[8,"…",{"$f":"K11","v":0},{"$f":"'01.03.2013'!D45+'02.03.2013'!D45","v":0},{"$f":"'01.03.2013'!E45+'02.03.2013'!E45","v":0}]
[9,"…",{"$f":"L11","v":0},{"$f":"'01.03.2013'!D46+'02.03.2013'!D46","v":0},{"$f":"'01.03.2013'!E46+'02.03.2013'!E46","v":0}]
[10,"Другое",{"$f":"M11","v":0},{"$f":"'01.03.2013'!D47+'02.03.2013'!D47","v":0},{"$f":"'01.03.2013'!E47+'02.03.2013'!E47","v":0}]
[]
[]
[]
[]
[null,"Какая мебель Вас интерессует?"]
[1,"Детские",{"$f":"N11","v":0},{"$f":"C34/C$44","v":{"$error":"#DIV/0!"}}]
[2,"Спальни",{"$f":"O11","v":0},{"$error":"#DIV/0!"}]
[3,"Гостиные",{"$f":"P11","v":0},{"$error":"#DIV/0!"}]
[4,"Прихожие",{"$f":"Q11","v":0},{"$error":"#DIV/0!"}]
[5,"Обед.группы",{"$f":"R11","v":0},{"$error":"#DIV/0!"}]
[6,"Комп.столы",{"$f":"S11","v":0},{"$error":"#DIV/0!"}]
[7,"Мягкая мебель",{"$f":"T11","v":0},{"$error":"#DIV/0!"}]
[8,"Лампы, свет",{"$f":"U11","v":0},{"$error":"#DIV/0!"}]
[9,"Постельное белье",{"$f":"V11","v":0},{"$error":"#DIV/0!"}]
[10,"Другое",{"$f":"W11","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C34:C43)","v":0}]

{"sheet":"shape","index":1,"n_rows":47,"n_cols":25,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,24,5,24],[4,22,5,22],[4,1,5,1],[4,2,4,11],[4,12,4,21],[4,23,5,23]]}
[null,"Шаблон для заполнения данных из анкет_день 1"]
[]
[null,"Дата 1"]
[]
[null,"№ анкеты","Канал коммуникации",null,null,null,null,null,null,null,null,null,"Какая мебель интерессует",null,null,null,null,null,null,null,null,null,"Сумма покупки","Совершили покупку"," Сумма покупки/Канал"]
[null,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":"IF(W7>0,1,0)","v":0},{"$f":"IF(SUM(C7:L7)>0,W7/SUM(C7:L7),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"COUNTA(B7:B28)","v":0},0,0,0,0,0,{"$f":"COUNTA(H7:H28)","v":0},{"$f":"COUNTA(I7:I28)","v":0},{"$f":"COUNTA(J7:J28)","v":0},{"$f":"COUNTA(K7:K28)","v":0},{"$f":"COUNTA(L7:L28)","v":0},{"$f":"COUNTA(M7:M28)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(W7:W28)","v":0},{"$f":"SUM(X7:X28)","v":0},{"$f":"SUM(Y7:Y28)","v":0}]
[null,"ИТОГО"]
[]
[]
[null,"РЕЗУЛЬТАТЫ АНКЕТИРОВАНИЯ"]
[]
[]
[null,"Каналы","Всего посетителей","Совершили покупку","Сумма покупки"]
[null,"В целом",{"$f":"B29","v":0},{"$f":"COUNTA(W7:W28)","v":0},{"$f":"W29","v":0}]
[null,"ТВ",{"$f":"C29","v":0},{"$f":"SUMPRODUCT($C$7:$C$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($C$7:$C$28,$Y$7:$Y$28)","v":0}]
[null,"Радио",{"$f":"D29","v":0},{"$f":"SUMPRODUCT($D$7:$D$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($D$7:$D$28,$Y$7:$Y$28)","v":0}]
[null,"Интернет",{"$f":"E29","v":0},{"$f":"SUMPRODUCT($E$7:$E$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($E$7:$E$28,$Y$7:$Y$28)","v":0}]
[null,"наружная реклама",{"$f":"F29","v":0},{"$f":"SUMPRODUCT($F$7:$F$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($F$7:$F$28,$Y$7:$Y$28)","v":0}]
[null,"Печатные СМИ",{"$f":"G29","v":0},{"$f":"SUMPRODUCT($G$7:$G$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($G$7:$G$28,$Y$7:$Y$28)","v":0}]
[null,"Адреская рассылка",{"$f":"H29","v":0},{"$f":"SUMPRODUCT($H$7:$H$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($H$7:$H$28,$Y$7:$Y$28)","v":0}]
[null,"По рекомендации",{"$f":"I29","v":0},{"$f":"SUMPRODUCT($I$7:$I$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($I$7:$I$28,$Y$7:$Y$28)","v":0}]
[null,"…",{"$f":"J29","v":0},{"$f":"SUMPRODUCT($J$7:$J$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($J$7:$J$28,$Y$7:$Y$28)","v":0}]
[null,"…",{"$f":"K29","v":0},{"$f":"SUMPRODUCT($K$7:$K$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($K$7:$K$28,$Y$7:$Y$28)","v":0}]
[null,"Другое",{"$f":"L29","v":0},{"$f":"SUMPRODUCT($L$7:$L$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($L$7:$L$28,$Y$7:$Y$28)","v":0}]

{"sheet":"01.03.2013","index":2,"n_rows":47,"n_cols":25,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,1,5,1],[4,2,4,11],[4,12,4,21],[4,22,5,22],[4,23,5,23],[4,24,5,24]]}
[null,"Шаблон для заполнения данных из анкет_день 1"]
[]
[null,"01.03.2013"]
[]
[null,"№ анкеты","Канал коммуникации",null,null,null,null,null,null,null,null,null,"Какая мебель интерессует",null,null,null,null,null,null,null,null,null,"Сумма покупки","Совершили покупку"," Сумма покупки/Канал"]
[null,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":"IF(W7>0,1,0)","v":0},{"$f":"IF(SUM(C7:L7)>0,W7/SUM(C7:L7),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"COUNTA(B7:B28)","v":0},0,0,0,0,0,{"$f":"COUNTA(H7:H28)","v":0},{"$f":"COUNTA(I7:I28)","v":0},{"$f":"COUNTA(J7:J28)","v":0},{"$f":"COUNTA(K7:K28)","v":0},{"$f":"COUNTA(L7:L28)","v":0},{"$f":"COUNTA(M7:M28)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(W7:W28)","v":0},{"$f":"SUM(X7:X28)","v":0},{"$f":"SUM(Y7:Y28)","v":0}]
[null,"ИТОГО"]
[]
[]
[null,"РЕЗУЛЬТАТЫ АНКЕТИРОВАНИЯ"]
[]
[]
[null,"Каналы","Всего посетителей","Совершили покупку","Сумма покупки"]
[null,"В целом",{"$f":"B29","v":0},{"$f":"COUNTA(W7:W28)","v":0},{"$f":"W29","v":0}]
[null,"ТВ",{"$f":"C29","v":0},{"$f":"SUMPRODUCT($C$7:$C$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($C$7:$C$28,$Y$7:$Y$28)","v":0}]
[null,"Радио",{"$f":"D29","v":0},{"$f":"SUMPRODUCT($D$7:$D$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($D$7:$D$28,$Y$7:$Y$28)","v":0}]
[null,"Интернет",{"$f":"E29","v":0},{"$f":"SUMPRODUCT($E$7:$E$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($E$7:$E$28,$Y$7:$Y$28)","v":0}]
[null,"наружная реклама",{"$f":"F29","v":0},{"$f":"SUMPRODUCT($F$7:$F$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($F$7:$F$28,$Y$7:$Y$28)","v":0}]
[null,"Печатные СМИ",{"$f":"G29","v":0},{"$f":"SUMPRODUCT($G$7:$G$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($G$7:$G$28,$Y$7:$Y$28)","v":0}]
[null,"Адреская рассылка",{"$f":"H29","v":0},{"$f":"SUMPRODUCT($H$7:$H$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($H$7:$H$28,$Y$7:$Y$28)","v":0}]
[null,"По рекомендации",{"$f":"I29","v":0},{"$f":"SUMPRODUCT($I$7:$I$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($I$7:$I$28,$Y$7:$Y$28)","v":0}]
[null,"…",{"$f":"J29","v":0},{"$f":"SUMPRODUCT($J$7:$J$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($J$7:$J$28,$Y$7:$Y$28)","v":0}]
[null,"…",{"$f":"K29","v":0},{"$f":"SUMPRODUCT($K$7:$K$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($K$7:$K$28,$Y$7:$Y$28)","v":0}]
[null,"Другое",{"$f":"L29","v":0},{"$f":"SUMPRODUCT($L$7:$L$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($L$7:$L$28,$Y$7:$Y$28)","v":0}]

{"sheet":"02.03.2013","index":3,"n_rows":47,"n_cols":25,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,1,5,1],[4,2,4,11],[4,12,4,21],[4,22,5,22],[4,23,5,23],[4,24,5,24]]}
[null,"Шаблон для заполнения данных из анкет_день 1"]
[]
[null,"02.03.2013"]
[]
[null,"№ анкеты","Канал коммуникации",null,null,null,null,null,null,null,null,null,"Какая мебель интерессует",null,null,null,null,null,null,null,null,null,"Сумма покупки","Совершили покупку"," Сумма покупки/Канал"]
[null,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":"IF(W7>0,1,0)","v":0},{"$f":"IF(SUM(C7:L7)>0,W7/SUM(C7:L7),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"COUNTA(B7:B28)","v":0},0,0,0,0,0,{"$f":"COUNTA(H7:H28)","v":0},{"$f":"COUNTA(I7:I28)","v":0},{"$f":"COUNTA(J7:J28)","v":0},{"$f":"COUNTA(K7:K28)","v":0},{"$f":"COUNTA(L7:L28)","v":0},{"$f":"COUNTA(M7:M28)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(W7:W28)","v":0},{"$f":"SUM(X7:X28)","v":0},{"$f":"SUM(Y7:Y28)","v":0}]
[null,"ИТОГО"]
[]
[]
[null,"РЕЗУЛЬТАТЫ АНКЕТИРОВАНИЯ"]
[]
[]
[null,"Каналы","Всего посетителей","Совершили покупку","Сумма покупки"]
[null,"В целом",{"$f":"B29","v":0},{"$f":"COUNTA(W7:W28)","v":0},{"$f":"W29","v":0}]
[null,"ТВ",{"$f":"C29","v":0},{"$f":"SUMPRODUCT($C$7:$C$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($C$7:$C$28,$Y$7:$Y$28)","v":0}]
[null,"Радио",{"$f":"D29","v":0},{"$f":"SUMPRODUCT($D$7:$D$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($D$7:$D$28,$Y$7:$Y$28)","v":0}]
[null,"Интернет",{"$f":"E29","v":0},{"$f":"SUMPRODUCT($E$7:$E$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($E$7:$E$28,$Y$7:$Y$28)","v":0}]
[null,"наружная реклама",{"$f":"F29","v":0},{"$f":"SUMPRODUCT($F$7:$F$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($F$7:$F$28,$Y$7:$Y$28)","v":0}]
[null,"Печатные СМИ",{"$f":"G29","v":0},{"$f":"SUMPRODUCT($G$7:$G$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($G$7:$G$28,$Y$7:$Y$28)","v":0}]
[null,"Адреская рассылка",{"$f":"H29","v":0},{"$f":"SUMPRODUCT($H$7:$H$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($H$7:$H$28,$Y$7:$Y$28)","v":0}]
[null,"По рекомендации",{"$f":"I29","v":0},{"$f":"SUMPRODUCT($I$7:$I$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($I$7:$I$28,$Y$7:$Y$28)","v":0}]
[null,"…",{"$f":"J29","v":0},{"$f":"SUMPRODUCT($J$7:$J$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($J$7:$J$28,$Y$7:$Y$28)","v":0}]
[null,"…",{"$f":"K29","v":0},{"$f":"SUMPRODUCT($K$7:$K$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($K$7:$K$28,$Y$7:$Y$28)","v":0}]
[null,"Другое",{"$f":"L29","v":0},{"$f":"SUMPRODUCT($L$7:$L$28,$X$7:$X$28)","v":0},{"$f":"SUMPRODUCT($L$7:$L$28,$Y$7:$Y$28)","v":0}]