{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["!","@","Options"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":63,"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":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[36,3,36,5],[36,7,36,9],[36,11,36,13],[31,2,34,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"QUESTION","v":""}]

{"sheet":"@","index":1,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[16,1,16,3],[17,1,18,3],[15,14,15,17],[15,9,15,12],[19,1,20,3],[15,1,15,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"EmBI-показатели рабочей группы",null,null,null,null,null,null,null,"Индекс «Никто»",null,null,null,null,"Индекс «Я»"]
[null,null,null,null,"Em","B","I","EmBI",null,"Em","B","I","EmBI",null,"Em","B","I","EmBI"]
[null,"Индекс и оценка уровня EmBI-лидерства в рабочей группе",null,null,{"$f":"IF(VIEW_REZULTS,Em_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,B_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,I_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,EmBI_Idx,\"\")","v":""},null,{"$f":"IF(VIEW_REZULTS,Em0_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,B0_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,I0_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,EmBI0_Idx,\"\")","v":""},null,{"$f":"IF(VIEW_REZULTS,EmL_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,BL_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IL_Idx,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,EmBIL_Idx,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(VIEW_REZULTS,IF(E18<=20,\"низкий уровень\",IF(E18<=40,\"уровень ниже среднего\",IF(E18<=60,\"средний уровень\",IF(E18<=80,\"уровень выше среднего\",\"высокий уровень\")))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(F18<=20,\"низкий уровень\",IF(F18<=40,\"уровень ниже среднего\",IF(F18<=60,\"средний уровень\",IF(F18<=80,\"уровень выше среднего\",\"высокий уровень\")))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(G18<=20,\"низкий уровень\",IF(G18<=40,\"уровень ниже среднего\",IF(G18<=60,\"средний уровень\",IF(G18<=80,\"уровень выше среднего\",\"высокий уровень\")))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(H18<=20,\"низкий уровень\",IF(H18<=40,\"уровень ниже среднего\",IF(H18<=60,\"средний уровень\",IF(H18<=80,\"уровень выше среднего\",\"высокий уровень\")))),\"\")","v":""},null,{"$f":"IF(VIEW_REZULTS,IF(J18<=20,\"норма\",IF(J18<=30,\"отклонение от нормы\",IF(J18<=40,\"заметное отклонение от нормы\",\"сильное отклонение от нормы\"))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(K18<=20,\"норма\",IF(K18<=30,\"отклонение от нормы\",IF(K18<=40,\"заметное отклонение от нормы\",\"сильное отклонение от нормы\"))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(L18<=20,\"норма\",IF(L18<=30,\"отклонение от нормы\",IF(L18<=40,\"заметное отклонение от нормы\",\"сильное отклонение от нормы\"))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(M18<=20,\"норма\",IF(M18<=30,\"отклонение от нормы\",IF(M18<=40,\"заметное отклонение от нормы\",\"сильное отклонение от нормы\"))),\"\")","v":""},null,{"$f":"IF(VIEW_REZULTS,IF(O18=0,\"норма\",IF(O18<=10,\"отклонение от нормы\",IF(O18<=20,\"заметное отклонение от нормы\",\"сильное отклонение от нормы\"))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(P18=0,\"норма\",IF(P18<=10,\"отклонение от нормы\",IF(P18<=20,\"заметное отклонение от нормы\",\"сильное отклонение от нормы\"))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(Q18=0,\"норма\",IF(Q18<=10,\"отклонение от нормы\",IF(Q18<=20,\"заметное отклонение от нормы\",\"сильное отклонение от нормы\"))),\"\")","v":""},{"$f":"IF(VIEW_REZULTS,IF(R18=0,\"норма\",IF(R18<=10,\"отклонение от нормы\",IF(R18<=20,\"заметное отклонение от нормы\",\"сильное отклонение от нормы\"))),\"\")","v":""}]
[null,"Коэффициент и оценка соответствия формального и неформального (EmBI) статусов работников:",null,null,{"$f":"IF(VIEW_REZULTS,Options!H11,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!I11,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!J11,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!K11,\"\")","v":""}]
[null,null,null,null,{"$f":"Options!H12","v":""},{"$f":"Options!I12","v":""},{"$f":"Options!J12","v":""},{"$f":"Options!K12","v":""}]
[]
[]
[null,"№\n п/п","Работник","Формальный статус работника в рабочей группе\n[1-5]","Индекс эмоционального лидера Em","Индекс делового лидера B","Индекс информационного лидера I","EmBI-статус работника",null,"Em","B","I","EmBI",null,"Em","B","I","EmBI"]
[null,{"$f":"IF(OR(ISBLANK('@'!$C25),ISBLANK('@'!$D25)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!O3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!P3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!Q3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!R3,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!S3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!T3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!U3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!V3,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!W3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!X3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!Y3,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B25),Options!Z3,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C26),ISBLANK('@'!$D26)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!O4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!P4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!Q4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!R4,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!S4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!T4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!U4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!V4,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!W4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!X4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!Y4,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B26),Options!Z4,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C27),ISBLANK('@'!$D27)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!O5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!P5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!Q5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!R5,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!S5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!T5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!U5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!V5,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!W5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!X5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!Y5,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B27),Options!Z5,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C28),ISBLANK('@'!$D28)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!O6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!P6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!Q6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!R6,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!S6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!T6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!U6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!V6,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!W6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!X6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!Y6,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B28),Options!Z6,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C29),ISBLANK('@'!$D29)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!O7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!P7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!Q7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!R7,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!S7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!T7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!U7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!V7,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!W7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!X7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!Y7,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B29),Options!Z7,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C30),ISBLANK('@'!$D30)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!O8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!P8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!Q8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!R8,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!S8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!T8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!U8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!V8,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!W8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!X8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!Y8,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B30),Options!Z8,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C31),ISBLANK('@'!$D31)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!O9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!P9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!Q9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!R9,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!S9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!T9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!U9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!V9,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!W9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!X9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!Y9,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B31),Options!Z9,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C32),ISBLANK('@'!$D32)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!O10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!P10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!Q10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!R10,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!S10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!T10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!U10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!V10,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!W10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!X10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!Y10,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B32),Options!Z10,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C33),ISBLANK('@'!$D33)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!O11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!P11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!Q11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!R11,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!S11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!T11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!U11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!V11,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!W11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!X11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!Y11,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B33),Options!Z11,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C34),ISBLANK('@'!$D34)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!O12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!P12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!Q12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!R12,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!S12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!T12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!U12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!V12,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!W12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!X12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!Y12,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B34),Options!Z12,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C35),ISBLANK('@'!$D35)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!O13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!P13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!Q13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!R13,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!S13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!T13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!U13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!V13,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!W13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!X13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!Y13,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B35),Options!Z13,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C36),ISBLANK('@'!$D36)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!O14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!P14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!Q14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!R14,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!S14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!T14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!U14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!V14,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!W14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!X14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!Y14,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B36),Options!Z14,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C37),ISBLANK('@'!$D37)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!O15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!P15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!Q15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!R15,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!S15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!T15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!U15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!V15,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!W15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!X15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!Y15,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B37),Options!Z15,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C38),ISBLANK('@'!$D38)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!O16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!P16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!Q16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!R16,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!S16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!T16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!U16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!V16,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!W16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!X16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!Y16,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B38),Options!Z16,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C39),ISBLANK('@'!$D39)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!O17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!P17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!Q17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!R17,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!S17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!T17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!U17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!V17,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!W17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!X17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!Y17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B39),Options!Z17,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C40),ISBLANK('@'!$D40)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!O18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!P18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!Q18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!R18,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!S18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!T18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!U18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!V18,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!W18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!X18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!Y18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B40),Options!Z18,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C41),ISBLANK('@'!$D41)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!O19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!P19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!Q19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!R19,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!S19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!T19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!U19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!V19,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!W19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!X19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!Y19,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B41),Options!Z19,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C42),ISBLANK('@'!$D42)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!O20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!P20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!Q20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!R20,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!S20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!T20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!U20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!V20,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!W20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!X20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!Y20,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B42),Options!Z20,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C43),ISBLANK('@'!$D43)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!O21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!P21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!Q21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!R21,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!S21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!T21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!U21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!V21,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!W21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!X21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!Y21,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B43),Options!Z21,\"\"),\"\")","v":""}]
[null,{"$f":"IF(OR(ISBLANK('@'!$C44),ISBLANK('@'!$D44)),\"\",ROW()-ROW('@'!$B$24))","v":""},null,null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!O22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!P22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!Q22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!R22,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!S22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!T22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!U22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!V22,\"\"),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!W22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!X22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!Y22,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(REZULTS,1,$B44),Options!Z22,\"\"),\"\")","v":""}]

{"sheet":"Options","index":2,"n_rows":48,"n_cols":65,"rows_kept":48,"cut":false,"hidden":true,"merged":[[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[1,1,1,3],[1,5,1,10],[2,5,2,6],[3,5,3,6],[4,5,4,6]]}
[]
[null,"Параметры",null,null,null,"Показатели рабочей группы",null,null,null,null,null,null,"№","Status","Em","B","I","EmBI","Em0","B0","I0","EmBI0","Em-","B-","I-","EmBI-"]
[null,"Кол.вопросов",{"$f":"COUNT(dbTest[№])","v":21},null,null,"EmBI-показатели",null,"Em","B","I","EmBI",null,{"$f":"IF(ISNUMBER('@'!B25),IF(INDEX(TESTED,1,'@'!B25)=QUESTIONS_COUNT,'@'!B25,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D25,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"№ вопроса",null,{"$f":"IFERROR(INDEX(dbTest[Вопросы],ROW_NUM,1),\"\")","v":""},null,"Кол. вопросов",null,{"$f":"COUNTIF(dbTest[EmBI],1)","v":6},{"$f":"COUNTIF(dbTest[EmBI],2)","v":7},{"$f":"COUNTIF(dbTest[EmBI],3)","v":7},null,null,{"$f":"IF(ISNUMBER('@'!B26),IF(INDEX(TESTED,1,'@'!B26)=QUESTIONS_COUNT,'@'!B26,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D26,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"№ строки",{"$f":"IFERROR(MATCH(QUESTION_NUM,dbTest[№ вопроса],0),0)","v":0},{"$f":"IFERROR(MATCH(ANSWER_NAME1,STAFF_LIST,0),0)","v":0},null,"Макс. кол. ответов",null,{"$f":"H4*3","v":18},{"$f":"I4*3","v":21},21,{"$f":"SUM(H5:J5)","v":60},null,{"$f":"IF(ISNUMBER('@'!B27),IF(INDEX(TESTED,1,'@'!B27)=QUESTIONS_COUNT,'@'!B27,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D27,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"Кол.работников",{"$f":"COUNTA('@'!$C$25:$C$44)","v":0},{"$f":"IFERROR(MATCH(ANSWER_NAME2,STAFF_LIST,0),0)","v":0},null,"Веса 1 и 2 п/п ответов",null,1.5,1.25,null,null,null,{"$f":"IF(ISNUMBER('@'!B28),IF(INDEX(TESTED,1,'@'!B28)=QUESTIONS_COUNT,'@'!B28,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D28,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"Кол.тестирований",{"$f":"COUNTIF(TESTED,QUESTIONS_COUNT)","v":0},{"$f":"IFERROR(MATCH(ANSWER_NAME3,STAFF_LIST,0),0)","v":0},null,"Макс оценка",null,{"$f":"H4*TESTED_COUNT*W_1","v":0},{"$f":"I4*TESTED_COUNT*W_1","v":0},{"$f":"J4*TESTED_COUNT*W_1","v":0},{"$f":"SUM(H7:J7)","v":0},null,{"$f":"IF(ISNUMBER('@'!B29),IF(INDEX(TESTED,1,'@'!B29)=QUESTIONS_COUNT,'@'!B29,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D29,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"Макс.кол.тестирований",{"$f":"COUNT(TESTED)","v":20},null,null,"Индексы EmBI",null,{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[Em])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[B])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[I])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[EmBI])+0.5),\"\")","v":""},null,{"$f":"IF(ISNUMBER('@'!B30),IF(INDEX(TESTED,1,'@'!B30)=QUESTIONS_COUNT,'@'!B30,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D30,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"№ поиск",{"$f":"IFERROR(MATCH(0,TESTED,0),0)","v":1},null,null,"Индекс \"Никто\"",null,{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[Em0])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[B0])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[I0])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[EmBI0])+0.5),\"\")","v":""},null,{"$f":"IF(ISNUMBER('@'!B31),IF(INDEX(TESTED,1,'@'!B31)=QUESTIONS_COUNT,'@'!B31,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D31,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"№ тестируемого",null,null,null,"Индекс \"Я\"",null,{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[Em-])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[B-])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[I-])+0.5),\"\")","v":""},{"$f":"IFERROR(INT(AVERAGE(EmBI_Indexes[EmBI-])+0.5),\"\")","v":""},null,{"$f":"IF(ISNUMBER('@'!B32),IF(INDEX(TESTED,1,'@'!B32)=QUESTIONS_COUNT,'@'!B32,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D32,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"Удаление результата №",0,{"$f":"IF(DELETE_NUM=0,\"-\",IF(DELETE_NUM=TESTED_MAX+1,\"Все\",\"№ \" &DELETE_NUM))","v":"-"},null,"Соответствие статусов",null,{"$f":"IFERROR(SIGN(CORREL(EmBI_Indexes[Status],EmBI_Indexes[Em]))*RSQ(EmBI_Indexes[Status],EmBI_Indexes[Em]),\"\")","v":""},{"$f":"IFERROR(SIGN(CORREL(EmBI_Indexes[Status],EmBI_Indexes[B]))*RSQ(EmBI_Indexes[Status],EmBI_Indexes[B]),\"\")","v":""},{"$f":"IFERROR(SIGN(CORREL(EmBI_Indexes[Status],EmBI_Indexes[I]))*RSQ(EmBI_Indexes[Status],EmBI_Indexes[I]),\"\")","v":""},{"$f":"IFERROR(SIGN(CORREL(EmBI_Indexes[Status],EmBI_Indexes[EmBI]))*RSQ(EmBI_Indexes[Status],EmBI_Indexes[EmBI]),\"\")","v":""},null,{"$f":"IF(ISNUMBER('@'!B33),IF(INDEX(TESTED,1,'@'!B33)=QUESTIONS_COUNT,'@'!B33,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D33,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Correl_table[Соответствие],MATCH(ABS(H11),Correl_table[r2],1),1) & IF(ABS(H11)<0.2^2,\"\",IF(H11<0,\" обратное\",\" прямое\")),\"\")","v":""},{"$f":"IFERROR(INDEX(Correl_table[Соответствие],MATCH(ABS(I11),Correl_table[r2],1),1) & IF(ABS(I11)<0.2^2,\"\",IF(I11<0,\" обратное\",\" прямое\")),\"\")","v":""},{"$f":"IFERROR(INDEX(Correl_table[Соответствие],MATCH(ABS(J11),Correl_table[r2],1),1) & IF(ABS(J11)<0.2^2,\"\",IF(J11<0,\" обратное\",\" прямое\")),\"\")","v":""},{"$f":"IFERROR(INDEX(Correl_table[Соответствие],MATCH(ABS(K11),Correl_table[r2],1),1) & IF(ABS(K11)<0.2^2,\"\",IF(K11<0,\" обратное\",\" прямое\")),\"\")","v":""},null,{"$f":"IF(ISNUMBER('@'!B34),IF(INDEX(TESTED,1,'@'!B34)=QUESTIONS_COUNT,'@'!B34,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D34,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,null,null,null,null,"Показывать результаты",null,{"$f":"AND(TESTED_COUNT>0,TESTED_COUNT=COUNTIF(TESTED,\">0\"))","v":false},null,null,null,null,{"$f":"IF(ISNUMBER('@'!B35),IF(INDEX(TESTED,1,'@'!B35)=QUESTIONS_COUNT,'@'!B35,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D35,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,"r2","Соответствие",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B36),IF(INDEX(TESTED,1,'@'!B36)=QUESTIONS_COUNT,'@'!B36,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D36,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,0,"практически отсутствует",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B37),IF(INDEX(TESTED,1,'@'!B37)=QUESTIONS_COUNT,'@'!B37,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D37,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,{"$f":"0.2^2","v":4.0000000000000008E-2},"незначительное",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B38),IF(INDEX(TESTED,1,'@'!B38)=QUESTIONS_COUNT,'@'!B38,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D38,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,{"$f":"0.3^2","v":0.09},"слабое",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B39),IF(INDEX(TESTED,1,'@'!B39)=QUESTIONS_COUNT,'@'!B39,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D39,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,{"$f":"0.5^2","v":0.25},"заметное",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B40),IF(INDEX(TESTED,1,'@'!B40)=QUESTIONS_COUNT,'@'!B40,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D40,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,{"$f":"0.7^2","v":0.48999999999999994},"существенное",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B41),IF(INDEX(TESTED,1,'@'!B41)=QUESTIONS_COUNT,'@'!B41,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D41,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,{"$f":"0.9^2","v":0.81},"высокое",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B42),IF(INDEX(TESTED,1,'@'!B42)=QUESTIONS_COUNT,'@'!B42,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D42,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,{"$f":"0.95^2","v":0.90249999999999997},"очень высокое",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B43),IF(INDEX(TESTED,1,'@'!B43)=QUESTIONS_COUNT,'@'!B43,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D43,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[null,1,"функциональное",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('@'!B44),IF(INDEX(TESTED,1,'@'!B44)=QUESTIONS_COUNT,'@'!B44,\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),'@'!D44,\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(Em_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(Em_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(Em_3,EmBI_Indexes[[#This Row],[№]]))/Em_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(B_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(B_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(B_3,EmBI_Indexes[[#This Row],[№]]))/B_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(I_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(I_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(I_3,EmBI_Indexes[[#This Row],[№]]))/I_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(EmBI_1,EmBI_Indexes[[#This Row],[№]])*W_1+COUNTIF(EmBI_2,EmBI_Indexes[[#This Row],[№]])*W_2+COUNTIF(EmBI_3,EmBI_Indexes[[#This Row],[№]]))/EmBI_Wmax*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),0))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),0))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),0))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),0)+COUNTIF(INDEX(EmBI_3,,EmBI_Indexes[[#This Row],[№]]),0))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(Em_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/Em_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(B_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(B_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/B_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(I_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(I_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/I_Anwers*100+0.5),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ISNUMBER(EmBI_Indexes[[#This Row],[№]]),INT((COUNTIF(INDEX(EmBI_1,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(EmBI_2,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]])+COUNTIF(INDEX(Em_3,,EmBI_Indexes[[#This Row],[№]]),-EmBI_Indexes[[#This Row],[№]]))/EmBI_Answers*100+0.5),\"\"),\"\")","v":""}]
[]
[]
[null,null,null,null,null,{"$f":"QUESTIONS_COUNT=COUNT(dbTest[1])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[2])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[3])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[4])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[5])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[6])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[7])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[8])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[9])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[10])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[11])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[12])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[13])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[14])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[15])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[16])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[17])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[18])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[19])","v":false},{"$f":"QUESTIONS_COUNT=COUNT(dbTest[20])","v":false}]
[null,null,null,null,null,{"$f":"COUNT(dbTest[1])","v":0},{"$f":"COUNT(dbTest[2])","v":0},{"$f":"COUNT(dbTest[3])","v":0},{"$f":"COUNT(dbTest[4])","v":0},{"$f":"COUNT(dbTest[5])","v":0},{"$f":"COUNT(dbTest[6])","v":0},{"$f":"COUNT(dbTest[7])","v":0},{"$f":"COUNT(dbTest[8])","v":0},{"$f":"COUNT(dbTest[9])","v":0},{"$f":"COUNT(dbTest[10])","v":0},{"$f":"COUNT(dbTest[11])","v":0},{"$f":"COUNT(dbTest[12])","v":0},{"$f":"COUNT(dbTest[13])","v":0},{"$f":"COUNT(dbTest[14])","v":0},{"$f":"COUNT(dbTest[15])","v":0},{"$f":"COUNT(dbTest[16])","v":0},{"$f":"COUNT(dbTest[17])","v":0},{"$f":"COUNT(dbTest[18])","v":0},{"$f":"COUNT(dbTest[19])","v":0},{"$f":"COUNT(dbTest[20])","v":0}]
[null,"№","№ вопроса","Вопросы","EmBI","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"]
[null,1,21,"Есть ли в Вашей рабочей группе человек, к которому Вы можете обратиться за советом, касающимся той или иной жизненной ситуации?",9]
[null,2,20,"Если в Вашей рабочей группе возникнет конфликтная ситуация, кто из коллег, по Вашему мнению, будет стараться разрешить её вне зависимости от личных привязанностей? ",1]
[null,3,3,"С кем из коллег Вашей рабочей группы Вам было бы интересно провести вечер: сходить в кафе, в клуб, в кино, на вечер, и т. д.?",1]
[null,4,15,"Кого из коллег Вы предпочли бы увидеть в группе, отправляющейся вместе с Вами за город на пикник, в туристическую поездку и т. д.?",1]
[null,5,9,"Кто из коллег, на Ваш взгляд, по-настоящему пользуется уважением и доверием окружающих?",1]
[null,6,5,"С кем из коллег Вы могли бы поделиться самым сокровенным?",1]
[null,7,17,"Рабочее место кого из коллег Вы хотели бы, чтобы находилось рядом с Вашим рабочим местом?",1]
[null,8,4,"Есть ли в Вашей рабочей группе человек, которому обычно приходят в голову хорошие идеи, когда нужно разрешить какую-либо проблему?",2]
[null,9,16,"Кто из Ваших коллег чаще всего является организатором мероприятий делового характера: занимается организацией совещаний и обсуждения проблем, уточнением у руководства поставленных группе задач, участвует в распределении порученных задач между коллегами и т. д.?",2]
[null,10,19,"Кто из Ваших коллег чаще всего является организатором корпоративных мероприятий досугового характера: организацией вечеров, отдыха на природе, поездок, прочих культурных и спортивных мероприятий?",2]
[null,11,11,"Кто из Ваших коллег по-настоящему способен отстоять интересы Вашей рабочей группы?",2]
[null,12,14,"Кто из коллег, по Вашему мнению, является деятельным, активным человеком?",2]
[null,13,10,"Кто из коллег, по Вашему мнению, является целеустремленным человеком?",2]
[null,14,18,"Если перед Вашей рабочей группой поставлена важная задача, кто в первую очередь возьмётся за организацию ее выполнения?",2]
[null,15,7,"Кого из коллег Вашей рабочей группы Вы могли бы назвать для себя примером (образцом) в плане уровня профессиональных качеств работника?",3]
[null,16,6,"Кого из коллег Вашей рабочей группы Вы могли бы назвать для себя примером (образцом) в плане дисциплины труда и отвественного отношения к работе?",3]
[null,17,2,"К кому из коллег Вы можете обратиться за помощью по текущим рабочим вопросам?   ",3]
[null,18,8,"От кого из Ваших коллег Вы можете получить своевременную информацию, касающуюся как деловой, так и внерабочей жизни Вашей организации? ",3]
[null,19,12,"Кто из Ваших коллег при принятии решений руководствуется здравым смыслом, а не эмоциями?",3]
[null,20,1,"Кто из коллег, по Вашему мнению, является всесторонне развитым, эрудированным человеком?",3]
[null,21,13,"Кого из коллег, по Вашему мнению, можно назвать квалифицированным пользователем компьютера?",3]