{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["!","@","Options"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":14,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"@","index":1,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Показатели","Квадрат","Круг","Треугольник","Прямоугольник","Зигзаг"]
[null,null,null,"Индекс присутствия психотипа в рабочей группе",{"$f":"IF(VIEW_REZULTS,Options!M3,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!N3,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!O3,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!P3,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!Q3,\"\")","v":""}]
[null,null,null,"Индекс отрицания психотипа",{"$f":"IF(VIEW_REZULTS,Options!M4,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!N4,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!O4,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!P4,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!Q4,\"\")","v":""}]
[null,null,null,"Индекс значимости психотипа в рабочей группе",{"$f":"IF(VIEW_REZULTS,Options!M5,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!N5,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!O5,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!P5,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!Q5,\"\")","v":""}]
[null,null,null,"Индекс сложности коммуникаций психотипа",{"$f":"IF(VIEW_REZULTS,Options!M6,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!N6,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!O6,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!P6,\"\")","v":""},{"$f":"IF(VIEW_REZULTS,Options!Q6,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"№ п/п","                                 Место\nРаботник",1,2,3,4,5]
[null,null,1,null,{"$f":"IF(Options!$E3>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F3:$J3,0),1),\"\")","v":""},{"$f":"IF(Options!$E3>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F3:$J3,0),1),\"\")","v":""},{"$f":"IF(Options!$E3>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F3:$J3,0),1),\"\")","v":""},{"$f":"IF(Options!$E3>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F3:$J3,0),1),\"\")","v":""},{"$f":"IF(Options!$E3>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F3:$J3,0),1),\"\")","v":""}]
[null,null,2,null,{"$f":"IF(Options!$E4>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F4:$J4,0),1),\"\")","v":""},{"$f":"IF(Options!$E4>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F4:$J4,0),1),\"\")","v":""},{"$f":"IF(Options!$E4>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F4:$J4,0),1),\"\")","v":""},{"$f":"IF(Options!$E4>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F4:$J4,0),1),\"\")","v":""},{"$f":"IF(Options!$E4>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F4:$J4,0),1),\"\")","v":""}]
[null,null,3,null,{"$f":"IF(Options!$E5>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F5:$J5,0),1),\"\")","v":""},{"$f":"IF(Options!$E5>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F5:$J5,0),1),\"\")","v":""},{"$f":"IF(Options!$E5>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F5:$J5,0),1),\"\")","v":""},{"$f":"IF(Options!$E5>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F5:$J5,0),1),\"\")","v":""},{"$f":"IF(Options!$E5>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F5:$J5,0),1),\"\")","v":""}]
[null,null,4,null,{"$f":"IF(Options!$E6>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F6:$J6,0),1),\"\")","v":""},{"$f":"IF(Options!$E6>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F6:$J6,0),1),\"\")","v":""},{"$f":"IF(Options!$E6>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F6:$J6,0),1),\"\")","v":""},{"$f":"IF(Options!$E6>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F6:$J6,0),1),\"\")","v":""},{"$f":"IF(Options!$E6>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F6:$J6,0),1),\"\")","v":""}]
[null,null,5,null,{"$f":"IF(Options!$E7>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F7:$J7,0),1),\"\")","v":""},{"$f":"IF(Options!$E7>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F7:$J7,0),1),\"\")","v":""},{"$f":"IF(Options!$E7>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F7:$J7,0),1),\"\")","v":""},{"$f":"IF(Options!$E7>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F7:$J7,0),1),\"\")","v":""},{"$f":"IF(Options!$E7>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F7:$J7,0),1),\"\")","v":""}]
[null,null,6,null,{"$f":"IF(Options!$E8>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F8:$J8,0),1),\"\")","v":""},{"$f":"IF(Options!$E8>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F8:$J8,0),1),\"\")","v":""},{"$f":"IF(Options!$E8>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F8:$J8,0),1),\"\")","v":""},{"$f":"IF(Options!$E8>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F8:$J8,0),1),\"\")","v":""},{"$f":"IF(Options!$E8>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F8:$J8,0),1),\"\")","v":""}]
[null,null,7,null,{"$f":"IF(Options!$E9>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F9:$J9,0),1),\"\")","v":""},{"$f":"IF(Options!$E9>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F9:$J9,0),1),\"\")","v":""},{"$f":"IF(Options!$E9>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F9:$J9,0),1),\"\")","v":""},{"$f":"IF(Options!$E9>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F9:$J9,0),1),\"\")","v":""},{"$f":"IF(Options!$E9>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F9:$J9,0),1),\"\")","v":""}]
[null,null,8,null,{"$f":"IF(Options!$E10>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F10:$J10,0),1),\"\")","v":""},{"$f":"IF(Options!$E10>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F10:$J10,0),1),\"\")","v":""},{"$f":"IF(Options!$E10>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F10:$J10,0),1),\"\")","v":""},{"$f":"IF(Options!$E10>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F10:$J10,0),1),\"\")","v":""},{"$f":"IF(Options!$E10>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F10:$J10,0),1),\"\")","v":""}]
[null,null,9,null,{"$f":"IF(Options!$E11>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F11:$J11,0),1),\"\")","v":""},{"$f":"IF(Options!$E11>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F11:$J11,0),1),\"\")","v":""},{"$f":"IF(Options!$E11>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F11:$J11,0),1),\"\")","v":""},{"$f":"IF(Options!$E11>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F11:$J11,0),1),\"\")","v":""},{"$f":"IF(Options!$E11>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F11:$J11,0),1),\"\")","v":""}]
[null,null,10,null,{"$f":"IF(Options!$E12>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F12:$J12,0),1),\"\")","v":""},{"$f":"IF(Options!$E12>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F12:$J12,0),1),\"\")","v":""},{"$f":"IF(Options!$E12>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F12:$J12,0),1),\"\")","v":""},{"$f":"IF(Options!$E12>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F12:$J12,0),1),\"\")","v":""},{"$f":"IF(Options!$E12>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F12:$J12,0),1),\"\")","v":""}]
[null,null,11,null,{"$f":"IF(Options!$E13>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F13:$J13,0),1),\"\")","v":""},{"$f":"IF(Options!$E13>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F13:$J13,0),1),\"\")","v":""},{"$f":"IF(Options!$E13>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F13:$J13,0),1),\"\")","v":""},{"$f":"IF(Options!$E13>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F13:$J13,0),1),\"\")","v":""},{"$f":"IF(Options!$E13>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F13:$J13,0),1),\"\")","v":""}]
[null,null,12,null,{"$f":"IF(Options!$E14>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F14:$J14,0),1),\"\")","v":""},{"$f":"IF(Options!$E14>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F14:$J14,0),1),\"\")","v":""},{"$f":"IF(Options!$E14>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F14:$J14,0),1),\"\")","v":""},{"$f":"IF(Options!$E14>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F14:$J14,0),1),\"\")","v":""},{"$f":"IF(Options!$E14>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F14:$J14,0),1),\"\")","v":""}]
[null,null,13,null,{"$f":"IF(Options!$E15>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F15:$J15,0),1),\"\")","v":""},{"$f":"IF(Options!$E15>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F15:$J15,0),1),\"\")","v":""},{"$f":"IF(Options!$E15>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F15:$J15,0),1),\"\")","v":""},{"$f":"IF(Options!$E15>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F15:$J15,0),1),\"\")","v":""},{"$f":"IF(Options!$E15>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F15:$J15,0),1),\"\")","v":""}]
[null,null,14,null,{"$f":"IF(Options!$E16>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F16:$J16,0),1),\"\")","v":""},{"$f":"IF(Options!$E16>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F16:$J16,0),1),\"\")","v":""},{"$f":"IF(Options!$E16>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F16:$J16,0),1),\"\")","v":""},{"$f":"IF(Options!$E16>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F16:$J16,0),1),\"\")","v":""},{"$f":"IF(Options!$E16>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F16:$J16,0),1),\"\")","v":""}]
[null,null,15,null,{"$f":"IF(Options!$E17>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F17:$J17,0),1),\"\")","v":""},{"$f":"IF(Options!$E17>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F17:$J17,0),1),\"\")","v":""},{"$f":"IF(Options!$E17>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F17:$J17,0),1),\"\")","v":""},{"$f":"IF(Options!$E17>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F17:$J17,0),1),\"\")","v":""},{"$f":"IF(Options!$E17>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F17:$J17,0),1),\"\")","v":""}]
[null,null,16,null,{"$f":"IF(Options!$E18>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F18:$J18,0),1),\"\")","v":""},{"$f":"IF(Options!$E18>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F18:$J18,0),1),\"\")","v":""},{"$f":"IF(Options!$E18>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F18:$J18,0),1),\"\")","v":""},{"$f":"IF(Options!$E18>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F18:$J18,0),1),\"\")","v":""},{"$f":"IF(Options!$E18>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F18:$J18,0),1),\"\")","v":""}]
[null,null,17,null,{"$f":"IF(Options!$E19>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F19:$J19,0),1),\"\")","v":""},{"$f":"IF(Options!$E19>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F19:$J19,0),1),\"\")","v":""},{"$f":"IF(Options!$E19>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F19:$J19,0),1),\"\")","v":""},{"$f":"IF(Options!$E19>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F19:$J19,0),1),\"\")","v":""},{"$f":"IF(Options!$E19>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F19:$J19,0),1),\"\")","v":""}]
[null,null,18,null,{"$f":"IF(Options!$E20>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F20:$J20,0),1),\"\")","v":""},{"$f":"IF(Options!$E20>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F20:$J20,0),1),\"\")","v":""},{"$f":"IF(Options!$E20>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F20:$J20,0),1),\"\")","v":""},{"$f":"IF(Options!$E20>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F20:$J20,0),1),\"\")","v":""},{"$f":"IF(Options!$E20>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F20:$J20,0),1),\"\")","v":""}]
[null,null,19,null,{"$f":"IF(Options!$E21>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F21:$J21,0),1),\"\")","v":""},{"$f":"IF(Options!$E21>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F21:$J21,0),1),\"\")","v":""},{"$f":"IF(Options!$E21>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F21:$J21,0),1),\"\")","v":""},{"$f":"IF(Options!$E21>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F21:$J21,0),1),\"\")","v":""},{"$f":"IF(Options!$E21>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F21:$J21,0),1),\"\")","v":""}]
[null,null,20,null,{"$f":"IF(Options!$E22>0,INDEX(SHAPES,MATCH('@'!E$61,Options!$F22:$J22,0),1),\"\")","v":""},{"$f":"IF(Options!$E22>0,INDEX(SHAPES,MATCH('@'!F$61,Options!$F22:$J22,0),1),\"\")","v":""},{"$f":"IF(Options!$E22>0,INDEX(SHAPES,MATCH('@'!G$61,Options!$F22:$J22,0),1),\"\")","v":""},{"$f":"IF(Options!$E22>0,INDEX(SHAPES,MATCH('@'!H$61,Options!$F22:$J22,0),1),\"\")","v":""},{"$f":"IF(Options!$E22>0,INDEX(SHAPES,MATCH('@'!I$61,Options!$F22:$J22,0),1),\"\")","v":""}]

{"sheet":"Options","index":2,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,1,1,2],[5,1,6,1]]}
[]
[null,"Параметры",null,null,"№","Квадрат","Круг","Треугольник","Прямоугольник","Зигзаг",null,"Показатели",1,2,3,4,5]
[null,"Макс. количество тестирований",{"$f":"COUNT(dbTest[№])","v":20},null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,"Индекс присутствия психотипа в рабочей группе",{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Квадрат],1)/TESTED_COUNT*100,\"\")","v":""},{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Круг],1)/TESTED_COUNT*100,\"\")","v":""},{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Треугольник],1)/TESTED_COUNT*100,\"\")","v":""},{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Прямоугольник],1)/TESTED_COUNT*100,\"\")","v":""},{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Зигзаг],1)/TESTED_COUNT*100,\"\")","v":""}]
[null,"Количество протестированных",{"$f":"SUM(dbTest[№])","v":0},null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,"Индекс отрицания психотипа",{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Квадрат],5)/TESTED_COUNT*100,\"\")","v":""},{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Круг],5)/TESTED_COUNT*100,\"\")","v":""},{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Треугольник],5)/TESTED_COUNT*100,\"\")","v":""},{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Прямоугольник],5)/TESTED_COUNT*100,\"\")","v":""},{"$f":"IF(TESTED_COUNT>0,COUNTIF(dbTest[Зигзаг],5)/TESTED_COUNT*100,\"\")","v":""}]
[null,"Тестируемый №",0,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,"Индекс значимости психотипа в рабочей группе",{"$f":"IFERROR(SUM(IF(dbTest[Квадрат]>0,5-dbTest[Квадрат],0))/TESTED_COUNT*25,\"\")","v":""},{"$f":"IFERROR(SUM(IF(dbTest[Круг]>0,5-dbTest[Круг],0))/TESTED_COUNT*25,\"\")","v":""},{"$f":"IFERROR(SUM(IF(dbTest[Треугольник]>0,5-dbTest[Треугольник],0))/TESTED_COUNT*25,\"\")","v":""},{"$f":"IFERROR(SUM(IF(dbTest[Прямоугольник]>0,5-dbTest[Прямоугольник],0))/TESTED_COUNT*25,\"\")","v":""},{"$f":"IFERROR(SUM(IF(dbTest[Зигзаг]>0,5-dbTest[Зигзаг],0))/TESTED_COUNT*25,\"\")","v":""}]
[null,"Удаление теста",0,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,"Индекс сложности коммуникаций психотипа",{"$f":"IFERROR(IF(M$12>0,SUMPRODUCT(M$7:M$11,TRANSPOSE($M$5:$Q$5))/M$12,0),\"\")","v":0},{"$f":"IFERROR(IF(N$12>0,SUMPRODUCT(N$7:N$11,TRANSPOSE($M$5:$Q$5))/N$12,0),\"\")","v":0},{"$f":"IFERROR(IF(O$12>0,SUMPRODUCT(O$7:O$11,TRANSPOSE($M$5:$Q$5))/O$12,0),\"\")","v":0},{"$f":"IFERROR(IF(P$12>0,SUMPRODUCT(P$7:P$11,TRANSPOSE($M$5:$Q$5))/P$12,0),\"\")","v":0},{"$f":"IFERROR(IF(Q$12>0,SUMPRODUCT(Q$7:Q$11,TRANSPOSE($M$5:$Q$5))/Q$12,0),\"\")","v":0}]
[null,null,{"$f":"IF(DELETE_NUM>0,IF(DELETE_NUM=21,\"Все\",DELETE_NUM),\"-\")","v":"-"},null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,1,{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,M$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L7))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,N$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L7))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,O$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L7))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,P$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L7))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,Q$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L7))=4,1,0))","v":0}]
[null,"Просмотр групповых показателей",{"$f":"TESTED_COUNT>1","v":false},null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,2,{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,M$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L8))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,N$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L8))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,O$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L8))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,P$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L8))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,Q$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L8))=4,1,0))","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,3,{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,M$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L9))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,N$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L9))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,O$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L9))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,P$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L9))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,Q$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L9))=4,1,0))","v":0}]
[null,"Квадрат",null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,4,{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,M$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L10))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,N$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L10))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,O$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L10))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,P$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L10))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,Q$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L10))=4,1,0))","v":0}]
[null,"Круг",null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,5,{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,M$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L11))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,N$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L11))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,O$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L11))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,P$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L11))=4,1,0))","v":0},{"$f":"SUM(IF(ABS(INDEX(dbTest[[Квадрат]:[Зигзаг]],,Q$2)-INDEX(dbTest[[Квадрат]:[Зигзаг]],,$L11))=4,1,0))","v":0}]
[null,"Треугольник",null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0},null,null,null,null,null,null,"Итого",{"$f":"SUM(M7:M11)","v":0},{"$f":"SUM(N7:N11)","v":0},0,0,0]
[null,"Прямоугольник",null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,"Зигзаг",null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]
[null,null,null,null,{"$f":"IF(SUM(dbTest[[#This Row],[Квадрат]:[Зигзаг]])=15,1,0)","v":0}]