{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Инструкция","1-2 вопрос","3-4 вопрос","Итог"],"not_rendered":{"charts":0,"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":"Инструкция","index":0,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["ИНСТРУКЦИЯ К\"СОЦИОМЕТРИЧЕСКОЙ МЕТОДИКЕ\""]
["Файл «Социометрические матрицы» состоит из 4 листов: инструкция; 1-2 вопрос; 3-4 вопрос; итог. "]
["Начинать работу надо с первого листа: внимательно прочитать инструкцию к «Социометрической методике»."]
["Алгоритм действий при работе с социометрической матрицей:"]
["1.      Открыть файл «Социометрическая методика» doc, распечатать бланки вопросов по количеству респондентов."]
["2.      Провести исследование:"," "]
["Школьник  отвечает на вопросы, записывает на бланке ниже предлагаемого вопроса фамилии трех человек, которым он отдает свои выборы."]
[" При этом первым указывается тот, кому школьник отдает свои наибольшие: "]
["симпатии (1, 4 вопрос),"]
["антипатии (2, 3 вопрос). "]
["Затем записывает фамилии тех, кому отдается предпочтение во вторую и третью очередь."]
["ВАЖНО!!! При ответе на разные вопросы фамилии выбранных одноклассников могут повторяться (об этом следует сказать школьникам). "]
["Классный руководитель и школьники  проверяют, названы ли после каждого вопроса фамилии трех человек. "]
["3.      Открыть файл  Excel «Социометрические матрицы» "]
["4.      Заполнить лист «1-2 вопрос»"]
["В столбце «Шифр» вносятся шифры из личных дел детей в том же порядке, в каком они внесены в остальных таблицах. "]
["ВАЖНО!!! эти шифры автоматически заполняются и на остальных листах (Лист «3-4 вопрос», лист «Итог»)."]
["В соответствии с шифрами и номерами детей в строке респондента вносятся:"]
[" «1» в колонки с номерами, соответствующими ответам на вопрос 1 (из бланка);"]
["«-1» вносится в колонки с номерами, соответствующими ответам на вопрос 2. "]
["Соответствующие цифры проставляются в клетках пересечения его строки со столбцом, где указан номер выбираемого человека."]
["ВАЖНО!!! колонки с жёлтыми полями заполняются автоматически!"]
["5.      Заполнение листа «3-4 вопрос»: в соответствии с шифрами и номерами детей в строке респондента вносятся"]
[" «-1» в колонки с номерами, соответствующими ответам на вопрос 3 (из бланка);"]
["«1» вносится в колонки с номерами, соответствующими ответам на вопрос 4. "]
["6.      Перейдите на лист «Итог»"]
["На листе «Итог» нажать на смайлик, и сводные данные появятся автоматически. Скопировать ВСЕ данные."]
["Открыть \"Таблицу для ИШ - итоговые результаты\" и вставить во вкладку \"Социометрия\" все скопированные данные."]

{"sheet":"1-2 вопрос","index":1,"n_rows":35,"n_cols":39,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,36,0,37]]}
[null,null,null,null,null,null,null,null,null,null,null,null,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,"S","\"Да\"","\"Нет\"",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,{"$f":"SUM(C3:AF3)","v":0},{"$f":"COUNTIF(C3:AF3,1)","v":0},{"$f":"COUNTIF(C3:AF3,-1)","v":0},null,{"$f":"TRANSPOSE(C34:AF34)","v":0},{"$f":"TRANSPOSE(C35:AF35)","v":0},{"$f":"C5+C6+C7","v":0}]
[2,null,null,null,null,null,null,null,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,0,0,null,0,0]
[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,0,0,0,null,0,0]
[4,null,null,null,null,null,null,null,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,0,0,null,0,0]
[5,null,null,null,null,null,null,null,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,0,0,null,0,0]
[6,null,null,null,null,null,null,null,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,0,0,null,0,0]
[7,null,null,null,null,null,null,null,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,0,0,null,0,0]
[8,null,null,null,null,null,null,null,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,0,0,null,0,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,0,0]
[10,null,null,null,null,null,null,null,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,0,0,null,0,0]
[11,null,null,null,null,null,null,null,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,0,0,null,0,0," "]
[12,null,null,null,null,null,null,null,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,0,0,null,0,0]
[13,null,null,null,null,null,null,null,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,0,0,null,0,0]
[14,null,null,null,null,null,null,null,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,0,0,null,0,0]
[15,null,null,null,null,null,null,null,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,0,0,null,0,0]
[16,null,null,null,null,null,null,null,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,0,0,null,0,0]
[17,null,null,null,null,null,null,null,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,0,0,null,0,0]
[18,null,null,null,null,null,null,null,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,0,0,null,0,0]
[19,null,null,null,null,null,null,null,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,0,0,null,0,0]
[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,0,0,0,null,0,0]
[21,null,null,null,null,null,null,null,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,0,0,null,0,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,0,0]
[23,null,null,null,null,null,null,null,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,0,0,null,0,0]
[24,null,null,null,null,null,null,null,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,0,0,null,0,0]
[25,null,null,null,null,null,null,null,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,0,0,null,0,0]
[26,null,null,null,null,null,null,null,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,0,0,null,0,0]
[27,null,null,null,null,null,null,null,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,0,0,null,0,0]
[28,null,null,null,null,null,null,null,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,0,0,null,0,0]
[29,null,null,null,null,null,null,null,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,0,0,null,0,0]
[30,null,null,null,null,null,null,null,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,0,0,null,0,0]
[null,{"$f":"COUNTA(B3:B32)","v":0},{"$f":"SUM(C3:C32)","v":0},{"$f":"SUM(D3:D32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AVERAGE(C33:AF33)","v":0}]
[null,"Выбор \"да\"",{"$f":"COUNTIF(C3:C32,1)","v":0},{"$f":"COUNTIF(D3:D32,1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AVERAGE(C34:AF34)","v":0}]
[null,"Выбор \"нет\"",{"$f":"COUNTIF(C3:C32,-1)","v":0},{"$f":"COUNTIF(D3:D32,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AVERAGE(C35:AF35)","v":0}]

{"sheet":"3-4 вопрос","index":2,"n_rows":35,"n_cols":38,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,36,0,37]]}
[null,null,null,null,null,null,null,null,null,null,null,null,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,"S","\"Да\"","\"Нет\"",null,"да","нет"]
[1,{"$f":"'1-2 вопрос'!B3","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,null,null,null,null,null,null,null,{"$f":"SUM(C3:AF3)","v":0},{"$f":"COUNTIF(C3:AF3,1)","v":0},{"$f":"COUNTIF(C3:AF3,-1)","v":0},null,{"$f":"TRANSPOSE(C34:AF34)","v":0},{"$f":"TRANSPOSE(C35:AF35)","v":0}]
[2,{"$f":"'1-2 вопрос'!B4","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,null,null,null,null,null,null,null,{"$f":"SUM(C4:AF4)","v":0},{"$f":"COUNTIF(C4:AF4,1)","v":0},{"$f":"COUNTIF(C4:AF4,-1)","v":0},null,0,0]
[3,{"$f":"'1-2 вопрос'!B5","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[4,{"$f":"'1-2 вопрос'!B6","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[5,{"$f":"'1-2 вопрос'!B7","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[6,{"$f":"'1-2 вопрос'!B8","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[7,{"$f":"'1-2 вопрос'!B9","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[8,{"$f":"'1-2 вопрос'!B10","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[9,{"$f":"'1-2 вопрос'!B11","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[10,{"$f":"'1-2 вопрос'!B12","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[11,{"$f":"'1-2 вопрос'!B13","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[12,{"$f":"'1-2 вопрос'!B14","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[13,{"$f":"'1-2 вопрос'!B15","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[14,{"$f":"'1-2 вопрос'!B16","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[15,{"$f":"'1-2 вопрос'!B17","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[16,{"$f":"'1-2 вопрос'!B18","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[17,{"$f":"'1-2 вопрос'!B19","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[18,{"$f":"'1-2 вопрос'!B20","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[19,{"$f":"'1-2 вопрос'!B21","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[20,{"$f":"'1-2 вопрос'!B22","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[21,{"$f":"'1-2 вопрос'!B23","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[22,{"$f":"'1-2 вопрос'!B24","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[23,{"$f":"'1-2 вопрос'!B25","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[24,{"$f":"'1-2 вопрос'!B26","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[25,{"$f":"'1-2 вопрос'!B27","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[26,{"$f":"'1-2 вопрос'!B28","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[27,{"$f":"'1-2 вопрос'!B29","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[28,{"$f":"'1-2 вопрос'!B30","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[29,{"$f":"'1-2 вопрос'!B31","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[30,{"$f":"'1-2 вопрос'!B32","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,null,null,null,null,null,null,null,0,0,0,null,0,0]
[null,"Сумма выборов",{"$f":"SUM(C3:C32)","v":0},{"$f":"SUM(D3:D32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Выбор \"да\"",{"$f":"COUNTIF(C3:C32,1)","v":0},{"$f":"COUNTIF(D3:D32,1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Выбор \"нет\"",{"$f":"COUNTIF(C3:C32,-1)","v":0},{"$f":"COUNTIF(D3:D32,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Итог","index":3,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,17,0,18]]}
["Всего",{"$f":"'1-2 вопрос'!B33","v":0},"Индивид",null,null,null,"Взаимно",null,null,null,"Итог",null,null,null,null,null,null,"Свод"]
["№               п/п","Шифр ","Его берут","Не берут","Он возьмёт","Не возьмёт","берут","не берут","Возьмёт","не возьмёт","Индекс 1 (соцстатус)","Индекс 2 (вз позит)","Индекс 3 (вз негат)","Индекс удовлетв","Изол",null,null,"Индексы","Знач",null,"низкий","средний","высокий"]
[1,{"$f":"'1-2 вопрос'!B3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A3>$B$1,\"\",IF(AND(C3=0,D3=0),1,IF(AND(C3=0,D3>0),2,\"\")))","v":""},null,1,"Групповой сплоченности",{"$f":"G33/(3*(B1-1))","v":0},null,"степень взаимосвязанности индивидов, теснота их эмоциональных связей"]
[2,{"$f":"'1-2 вопрос'!B4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A4>$B$1,\"\",IF(AND(C4=0,D4=0),1,IF(AND(C4=0,D4>0),2,\"\")))","v":""},null,2,"Дисперсия позит выбора",{"$f":"C34","v":""},null,"дифференциация, наличие лидеров"]
[3,{"$f":"'1-2 вопрос'!B5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,3,"Дисперсия негат выбора",{"$f":"D34","v":""},null,"дифференциация, наличие \"отвергаемых\""]
[4,{"$f":"'1-2 вопрос'!B6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,4,"Индекс групповой устойчивости",{"$f":"IFERROR(1/H33,\"\")","v":""},null,"стабильность, прочность эмоциональных связей, способность сохранять связи на длительное время"]
[5,{"$f":"'1-2 вопрос'!B7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,5,"Индекс взаим позитива",{"$f":"G33/(3*(B1-1))","v":0},null,"уровень взаимоотношений"]
[6,{"$f":"'1-2 вопрос'!B8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,6,"Индекс взаим негатива",{"$f":"H33/(3*(B1-1))","v":0}]
[7,{"$f":"'1-2 вопрос'!B9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,7,"Уровень благополучия",{"$f":"S13+S14-S15-S16-S17","v":0},null,"Благополучие взаимоотношений в коллективе"]
[8,{"$f":"'1-2 вопрос'!B10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,4,"Групповой интеграции",{"$f":"IFERROR(1/(S16 + S17),\"\")","v":""},null,"Способность группы интегрировать членов в единое целое"]
[9,{"$f":"'1-2 вопрос'!B11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[10,{"$f":"'1-2 вопрос'!B12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Статусные категории","кол-во"]
[11,{"$f":"'1-2 вопрос'!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,1,"\"Звёзды\"",{"$f":"COUNTIF(C3:C32,\">5\")","v":0}]
[12,{"$f":"'1-2 вопрос'!B14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,2,"\"Предпочитаемые\"",{"$f":"COUNTIF(C3:C32,\">2\") - COUNTIF(C3:C32,\">5\")","v":0}]
[13,{"$f":"'1-2 вопрос'!B15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,3,"\"Пренебрегаемые\"",{"$f":"COUNTIF(C3:C32,\">0\") - COUNTIF(C3:C32,\">2\")","v":0}]
[14,{"$f":"'1-2 вопрос'!B16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,4,"\"Изолированные\"",{"$f":"COUNTIF(O3:O32,1)","v":0}]
[15,{"$f":"'1-2 вопрос'!B17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"",null,5,"\"Отвергаемые\"",{"$f":"COUNTIF(O3:O32,2)","v":0}]
[16,{"$f":"'1-2 вопрос'!B18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[17,{"$f":"'1-2 вопрос'!B19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[18,{"$f":"'1-2 вопрос'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[19,{"$f":"'1-2 вопрос'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[20,{"$f":"'1-2 вопрос'!B22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[21,{"$f":"'1-2 вопрос'!B23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[22,{"$f":"'1-2 вопрос'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[23,{"$f":"'1-2 вопрос'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[24,{"$f":"'1-2 вопрос'!B26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[25,{"$f":"'1-2 вопрос'!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[26,{"$f":"'1-2 вопрос'!B28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[27,{"$f":"'1-2 вопрос'!B29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[28,{"$f":"'1-2 вопрос'!B30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[29,{"$f":"'1-2 вопрос'!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[30,{"$f":"'1-2 вопрос'!B32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Сумма выборов",{"$f":"SUM(C3:C32)","v":0},{"$f":"SUM(D3:D32)","v":0},0,0,{"$f":"SUM(G3:G32)","v":0},{"$f":"SUM(H3:H32)","v":0},0,0,{"$f":"IFERROR(AVERAGE(K3:K32),\"\")","v":""},{"$f":"IFERROR(AVERAGE(L3:L32),\"\")","v":""},"","",{"$f":"COUNTIF(O3:O32,\">=1\")","v":0}]
[null,"дисперсия ",{"$f":"IFERROR(VAR(C3:C32),\"\")","v":""},{"$f":"IFERROR(VAR(D3:D32),\"\")","v":""},"","","","","","","","","",""]