{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Результаты","Анализ","Инструкция"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":180,"n_cols":44,"rows_kept":180,"cut":false,"hidden":false,"merged":[[4,0,4,2],[4,4,4,9],[2,4,2,9],[6,0,6,2],[8,0,8,2],[2,0,2,2],[6,4,6,9],[8,4,8,9],[176,36,178,39],[187,14,187,15],[185,14,185,15],[20,37,20,39],[20,40,21,40],[226,8,226,9],[222,8,222,9],[223,8,223,9],[224,8,224,9],[188,14,188,15],[225,8,225,9],[20,0,21,2],[186,14,186,15],[10,4,10,9],[12,4,12,9],[23,0,23,3],[16,0,16,2],[10,0,10,2],[12,0,12,2],[14,0,14,2],[16,4,16,9],[14,4,14,6],[14,7,14,9],[18,0,18,2],[18,4,18,9],[4,11,4,15],[4,17,4,19],[8,11,10,16],[8,18,10,19],[2,21,2,31],[20,42,23,42],[6,21,7,23],[8,21,8,23],[19,29,19,35],[20,41,21,41],[20,36,21,36],[12,22,14,35]]}
[]
[]
["Образовательная организация",null,null,null,"Ленинская",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-04-06"}]
[]
["Класс",null,null,null,11,null,null,null,null,null,null,"Кол-во учащихся ",null,null,null,null,null,{"$f":"A179","v":0}]
[]
["Предмет",null,null,null,"История",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Средний балл по ОУ"]
[]
["Дата",null,null,null,"2018-01-13",null,null,null,null,null,null,"Тестовый средний балл ЕГЭ 2017 года                                 по г.Ростову-на-Дону",null,null,null,null,null,null,53.11,null,null,{"$f":"(AQ177*5+AQ178*4+AQ179*3+AQ180*2)/A179","v":{"$error":"#DIV/0!"}}]
[]
["Максимальный балл",null,null,null,{"$f":"AK24","v":55}]
[]
["Пороговый балл",null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 - заполняется автоматически автосуммой критериев К1-К7"]
[]
["Зона риска",null,null,null,9,null,null,10]
[]
["Первичный средний балл по выборке",null,null,null,{"$f":"AK180","v":22}]
[]
["Тестовый средний балл по выборке",null,null,null,{"$f":"AO180","v":48}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"КРИТЕРИИ К1-К7"]
["Уровни",null,null,"А,В,С",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,"К1","К2","К3","К4","К5","К6","К7","Первичный балл","% выплнения заданий по уровням",null,null,"Тестовый балл","Оценка","% правильных ответов"]
[null,null,null,"Б,П,В","П","Б","Б","Б","Б","Б","П","Б","Б","Б","П","П","Б","Б","Б","П","Б","П","Б","П","Б","В","В","В","В","Б","П","В","В","Б","В","В",null,"Базовый","Повышенный","Высокий"]
["№","Класс","Ф.И.О.","№ задания",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
["Максимальный балл",null,null,null,1,2,2,1,2,2,2,2,2,1,3,2,1,1,1,2,2,1,1,2,2,2,3,4,{"$f":"SUM(AD24:AJ24)","v":11},2,2,2,1,1,2,1,{"$f":"SUM(E24:AB24,AD24:AJ24)","v":55},{"$f":"SUMIF($E$22:$AJ$22,\"Б\",$E24:$AJ24)/SUMIF($E$22:$AJ$22,\"Б\",$E$24:$AJ$24)*100","v":100},{"$f":"SUMIF($E$22:$AJ$22,\"П\",$E24:$AJ24)/SUMIF($E$22:$AJ$22,\"П\",$E$24:$AJ$24)*100","v":100},{"$f":"SUMIF($E$22:$AJ$22,\"В\",$E24:$AJ24)/SUMIF($E$22:$AJ$22,\"В\",$E$24:$AJ$24)*100","v":100},{"$f":"LOOKUP(AK24,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":100},{"$f":"LOOKUP(AO24,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":5}]
[null,null,null,"вариант"]
[1,11,null,1,1,1,2,1,1,0,1,0,0,1,0,1,1,0,0,2,0,1,1,0,1,0,2,0,{"$f":"IF(AD26+AE26+AF26+AG26+AH26+AI26+AJ26=0,\"\",SUM(AD26:AJ26))","v":5},2,1,1,0,0,1,0,{"$f":"SUM(E26:AB26,AD26:AJ26)","v":22},{"$f":"SUMIF($E$22:$AJ$22,\"Б\",$E26:$AJ26)/SUMIF($E$22:$AJ$22,\"Б\",$E$24:$AJ$24)*100","v":44},{"$f":"SUMIF($E$22:$AJ$22,\"П\",$E26:$AJ26)/SUMIF($E$22:$AJ$22,\"П\",$E$24:$AJ$24)*100","v":46.666666666666664},{"$f":"SUMIF($E$22:$AJ$22,\"В\",$E26:$AJ26)/SUMIF($E$22:$AJ$22,\"В\",$E$24:$AJ$24)*100","v":34.615384615384613},{"$f":"LOOKUP(AK26,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":48},{"$f":"LOOKUP(AO26,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":3},{"$f":"SUM(COUNTIF($E26,$E$24),COUNTIF($F26,$F$24),COUNTIF($G26,$G$24),COUNTIF($H26,$H$24),COUNTIF($I26,$I$24),COUNTIF($J26,$J$24),COUNTIF($K26,$K$24),COUNTIF($L26,$L$24),COUNTIF($M26,$M$24),COUNTIF($N26,$N$24),COUNTIF($O26,$O$24),COUNTIF($P26,$P$24),COUNTIF($Q26,$Q$24),COUNTIF($R26,$R$24),COUNTIF($S26,$S$24),COUNTIF($T26,$T$24),COUNTIF($U26,$U$24),COUNTIF($V26,$V$24),COUNTIF($W26,$W$24),COUNTIF($X26,$X$24),COUNTIF($Y26,$Y$24),COUNTIF($Z26,$Z$24),COUNTIF($AA26,$AA$24),COUNTIF($AB26,$AB$24),COUNTIF($AH26,$AH$24),COUNTIF($AD26,$AD$24),COUNTIF($AE26,$AE$24),COUNTIF($AF26,$AF$24),COUNTIF($AG26,$AG$24),COUNTIF($AJ26,$AJ$24),COUNTIF($AI26,$AI$24),COUNTIF($AC26,$AC$24))*100/32","v":28.125}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD27+AE27+AF27+AG27+AH27+AI27+AJ27=0,\"\",SUM(AD27:AJ27))","v":""},null,null,null,null,null,null,null,{"$f":"SUM(E27:AB27,AD27:AJ27)","v":0},0,0,0,{"$f":"LOOKUP(AK27,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO27,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},{"$f":"SUM(COUNTIF($E27,$E$24),COUNTIF($F27,$F$24),COUNTIF($G27,$G$24),COUNTIF($H27,$H$24),COUNTIF($I27,$I$24),COUNTIF($J27,$J$24),COUNTIF($K27,$K$24),COUNTIF($L27,$L$24),COUNTIF($M27,$M$24),COUNTIF($N27,$N$24),COUNTIF($O27,$O$24),COUNTIF($P27,$P$24),COUNTIF($Q27,$Q$24),COUNTIF($R27,$R$24),COUNTIF($S27,$S$24),COUNTIF($T27,$T$24),COUNTIF($U27,$U$24),COUNTIF($V27,$V$24),COUNTIF($W27,$W$24),COUNTIF($X27,$X$24),COUNTIF($Y27,$Y$24),COUNTIF($Z27,$Z$24),COUNTIF($AA27,$AA$24),COUNTIF($AB27,$AB$24),COUNTIF($AH27,$AH$24),COUNTIF($AD27,$AD$24),COUNTIF($AE27,$AE$24),COUNTIF($AF27,$AF$24),COUNTIF($AG27,$AG$24),COUNTIF($AJ27,$AJ$24),COUNTIF($AI27,$AI$24),COUNTIF($AC27,$AC$24))*100/32","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD28+AE28+AF28+AG28+AH28+AI28+AJ28=0,\"\",SUM(AD28:AJ28))","v":""},null,null,null,null,null,null,null,{"$f":"SUM(E28:AB28,AD28:AJ28)","v":0},0,0,0,{"$f":"LOOKUP(AK28,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO28,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK29,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO29,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK30,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO30,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK31,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO31,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK32,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO32,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK33,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO33,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK34,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO34,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK35,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO35,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK36,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO36,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK37,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO37,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK38,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO38,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK39,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO39,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK40,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO40,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK41,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO41,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK42,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO42,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK43,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO43,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK44,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO44,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK45,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO45,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK46,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO46,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK47,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO47,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK48,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO48,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK49,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO49,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK50,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO50,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK51,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO51,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK52,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO52,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK53,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO53,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK54,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO54,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK55,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO55,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK56,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO56,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK57,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO57,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK58,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO58,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK59,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO59,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK60,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO60,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK61,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO61,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK62,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO62,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK63,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO63,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK64,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO64,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK65,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO65,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK66,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO66,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK67,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO67,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK68,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO68,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK69,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO69,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK70,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO70,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK71,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO71,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK72,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO72,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK73,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO73,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK74,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO74,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK75,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO75,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK76,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO76,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK77,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO77,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK78,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO78,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK79,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO79,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK80,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO80,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK81,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO81,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK82,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO82,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK83,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO83,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK84,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO84,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK85,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO85,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK86,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO86,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK87,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO87,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK88,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO88,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"SUM(E89:AB89,AD89:AJ89)","v":0},{"$f":"SUMIF($E$22:$AJ$22,\"Б\",$E89:$AJ89)/SUMIF($E$22:$AJ$22,\"Б\",$E$24:$AJ$24)*100","v":0},{"$f":"SUMIF($E$22:$AJ$22,\"П\",$E89:$AJ89)/SUMIF($E$22:$AJ$22,\"П\",$E$24:$AJ$24)*100","v":0},{"$f":"SUMIF($E$22:$AJ$22,\"В\",$E89:$AJ89)/SUMIF($E$22:$AJ$22,\"В\",$E$24:$AJ$24)*100","v":0},{"$f":"LOOKUP(AK89,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO89,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK90,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO90,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD91+AE91+AF91+AG91+AH91+AI91+AJ91=0,\"\",SUM(AD91:AJ91))","v":""},null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK91,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO91,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},{"$f":"SUM(COUNTIF($E91,$E$24),COUNTIF($F91,$F$24),COUNTIF($G91,$G$24),COUNTIF($H91,$H$24),COUNTIF($I91,$I$24),COUNTIF($J91,$J$24),COUNTIF($K91,$K$24),COUNTIF($L91,$L$24),COUNTIF($M91,$M$24),COUNTIF($N91,$N$24),COUNTIF($O91,$O$24),COUNTIF($P91,$P$24),COUNTIF($Q91,$Q$24),COUNTIF($R91,$R$24),COUNTIF($S91,$S$24),COUNTIF($T91,$T$24),COUNTIF($U91,$U$24),COUNTIF($V91,$V$24),COUNTIF($W91,$W$24),COUNTIF($X91,$X$24),COUNTIF($Y91,$Y$24),COUNTIF($Z91,$Z$24),COUNTIF($AA91,$AA$24),COUNTIF($AB91,$AB$24),COUNTIF($AH91,$AH$24),COUNTIF($AD91,$AD$24),COUNTIF($AE91,$AE$24),COUNTIF($AF91,$AF$24),COUNTIF($AG91,$AG$24),COUNTIF($AJ91,$AJ$24),COUNTIF($AI91,$AI$24),COUNTIF($AC91,$AC$24))*100/32","v":0}]
[67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK92,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO92,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK93,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO93,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK94,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO94,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK95,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO95,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK96,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO96,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK97,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO97,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK98,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO98,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK99,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO99,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK100,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO100,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK101,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO101,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK102,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO102,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK103,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO103,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK104,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO104,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK105,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO105,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK106,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO106,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK107,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO107,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK108,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO108,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK109,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO109,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK110,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO110,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK111,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO111,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK112,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO112,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK113,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO113,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK114,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO114,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK115,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO115,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK116,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO116,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK117,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO117,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK118,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO118,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK119,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO119,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK120,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO120,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK121,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO121,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK122,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO122,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK123,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO123,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK124,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO124,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK125,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO125,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[101,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK126,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO126,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[102,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK127,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO127,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[103,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK128,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO128,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[104,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK129,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO129,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[105,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK130,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO130,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[106,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK131,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO131,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[107,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK132,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO132,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[108,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK133,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO133,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[109,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK134,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO134,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[110,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK135,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO135,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[111,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK136,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO136,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[112,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK137,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO137,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[113,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK138,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO138,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[114,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK139,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO139,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[115,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK140,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO140,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[116,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK141,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO141,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[117,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK142,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO142,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[118,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK143,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO143,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[119,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK144,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO144,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK145,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO145,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[121,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK146,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO146,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[122,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK147,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO147,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[123,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK148,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO148,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[124,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK149,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO149,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK150,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO150,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[126,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK151,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO151,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[127,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK152,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO152,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[128,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"SUM(E153:AB153,AD153:AJ153)","v":0},{"$f":"SUMIF($E$22:$AJ$22,\"Б\",$E153:$AJ153)/SUMIF($E$22:$AJ$22,\"Б\",$E$24:$AJ$24)*100","v":0},{"$f":"SUMIF($E$22:$AJ$22,\"П\",$E153:$AJ153)/SUMIF($E$22:$AJ$22,\"П\",$E$24:$AJ$24)*100","v":0},{"$f":"SUMIF($E$22:$AJ$22,\"В\",$E153:$AJ153)/SUMIF($E$22:$AJ$22,\"В\",$E$24:$AJ$24)*100","v":0},{"$f":"LOOKUP(AK153,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO153,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[129,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK154,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO154,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[130,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD155+AE155+AF155+AG155+AH155+AI155+AJ155=0,\"\",SUM(AD155:AJ155))","v":""},null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK155,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO155,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},{"$f":"SUM(COUNTIF($E155,$E$24),COUNTIF($F155,$F$24),COUNTIF($G155,$G$24),COUNTIF($H155,$H$24),COUNTIF($I155,$I$24),COUNTIF($J155,$J$24),COUNTIF($K155,$K$24),COUNTIF($L155,$L$24),COUNTIF($M155,$M$24),COUNTIF($N155,$N$24),COUNTIF($O155,$O$24),COUNTIF($P155,$P$24),COUNTIF($Q155,$Q$24),COUNTIF($R155,$R$24),COUNTIF($S155,$S$24),COUNTIF($T155,$T$24),COUNTIF($U155,$U$24),COUNTIF($V155,$V$24),COUNTIF($W155,$W$24),COUNTIF($X155,$X$24),COUNTIF($Y155,$Y$24),COUNTIF($Z155,$Z$24),COUNTIF($AA155,$AA$24),COUNTIF($AB155,$AB$24),COUNTIF($AH155,$AH$24),COUNTIF($AD155,$AD$24),COUNTIF($AE155,$AE$24),COUNTIF($AF155,$AF$24),COUNTIF($AG155,$AG$24),COUNTIF($AJ155,$AJ$24),COUNTIF($AI155,$AI$24),COUNTIF($AC155,$AC$24))*100/32","v":0}]
[131,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK156,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO156,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK157,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO157,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[133,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK158,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO158,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[134,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK159,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO159,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[135,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK160,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO160,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[136,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK161,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO161,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[137,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK162,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO162,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[138,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK163,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO163,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[139,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK164,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO164,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK165,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO165,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[141,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK166,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO166,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[142,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK167,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO167,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[143,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK168,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO168,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[144,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK169,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO169,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK170,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO170,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[146,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK171,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO171,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[147,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK172,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO172,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[148,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK173,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO173,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[149,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK174,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO174,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,0,0,0,0,{"$f":"LOOKUP(AK175,Анализ!$P$39:$P$118,Анализ!$Q$39:$Q$118)","v":0},{"$f":"LOOKUP(AO175,Анализ!$Q$39:$Q$118,Анализ!$R$39:$R$118)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Оценки","чел.","%"]
[null,null,"Приступили к решению",null,{"$f":"COUNT(E26:E175)","v":1},{"$f":"COUNT(F26:F175)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"Среднее значение",null,null,null,null,"\"5\" -",{"$f":"COUNTIF($AP$26:$AP$175,5)","v":0},{"$f":"AQ177/$A$179","v":{"$error":"#DIV/0!"}}]
[null,null,"Не приступили к решению",null,{"$f":"$A$179-E177","v":-1},-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,null,null,null,null,null,"\"4\" -",{"$f":"COUNTIF($AP$26:$AP$175,4)","v":0},{"$f":"AQ178/$A$179","v":{"$error":"#DIV/0!"}}]
[{"$f":"COUNTA(C26:C175)","v":0},null,"Решили верно и полностью",null,{"$f":"COUNTIF(E26:E175,E24)","v":1},0,1,1,0,0,0,0,0,1,0,0,1,0,0,1,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,null,null,null,null,null,"\"3\" -",{"$f":"COUNTIF($AP$26:$AP$175,3)","v":1},{"$f":"AQ179/$A$179","v":{"$error":"#DIV/0!"}}]
[null,null,"Процент выполнения",null,{"$f":"(SUM(E26:E175))/$A$179/E24","v":{"$error":"#DIV/0!"}},{"$f":"(SUM(F26:F175))/$A$179/F24","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(AK26:AK175)/COUNTIF(AK26:AK175,\">0\")","v":22},{"$f":"SUM(AL26:AL175)/COUNTIF(AL26:AL175,\">0\")","v":44},{"$f":"SUM(AM26:AM175)/COUNTIF(AM26:AM175,\">0\")","v":46.666666666666664},{"$f":"SUM(AN26:AN175)/COUNTIF(AN26:AN175,\">0\")","v":34.615384615384613},{"$f":"SUM(AO26:AO175)/COUNTIF(AO26:AO175,\">0\")","v":48},"\"2\" -",{"$f":"COUNTIF($AP$26:$AP$175,2)","v":0},{"$f":"AQ180/$A$179","v":{"$error":"#DIV/0!"}}]

{"sheet":"Анализ","index":1,"n_rows":94,"n_cols":18,"rows_kept":94,"cut":false,"hidden":false,"merged":[[0,0,0,13],[7,0,7,2],[7,3,7,13],[8,0,8,2],[2,3,2,13],[3,3,3,13],[5,3,5,13],[6,0,6,2],[6,3,6,13],[2,0,2,2],[3,0,3,2],[5,0,5,2],[4,0,4,2],[4,3,4,13],[70,0,71,10],[8,4,8,5],[12,0,12,13],[13,0,13,13],[16,5,16,7],[24,0,24,3],[24,5,24,7],[23,0,23,3],[18,0,19,3],[65,1,65,10],[9,0,9,2],[9,3,9,13],[62,1,62,10],[63,1,63,10],[64,1,64,10],[66,1,66,10],[67,1,67,10],[68,1,68,10],[52,1,52,5],[50,1,50,5],[51,1,51,5],[29,0,30,3],[25,5,25,7],[26,5,26,7],[35,15,36,17],[8,6,8,13],[20,4,21,4],[22,0,22,3],[45,1,45,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[43,1,43,5],[44,1,44,5],[10,0,10,2],[10,3,10,13],[29,5,29,7],[30,5,30,7],[18,5,18,7],[18,4,19,4],[17,0,17,4],[16,0,16,3],[37,1,37,5],[38,1,38,5],[39,1,39,5],[31,0,33,3],[20,0,21,3],[27,5,27,7],[28,5,28,7],[25,0,26,3],[27,0,28,3],[36,1,36,10],[20,5,20,7],[58,1,58,5],[59,1,59,5],[60,1,60,5],[37,6,37,10],[56,6,56,10],[57,6,57,10],[58,6,58,10],[59,6,59,10],[50,6,50,10],[51,6,51,10],[52,6,52,10],[53,6,53,10],[54,6,54,10],[61,1,61,5],[38,6,38,10],[39,6,39,10],[40,6,40,10],[41,6,41,10],[42,6,42,10],[43,6,43,10],[44,6,44,10],[45,6,45,10],[46,6,46,10],[47,6,47,10],[48,6,48,10],[49,6,49,10],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[60,6,60,10],[61,6,61,10],[55,6,55,10]]}
["Центр независимой оценки качества образования и образовательного аудита \"Легион\""]
["Аналитическая справка по результатам тестирования "]
["Организация",null,null,{"$f":"Результаты!E3","v":"Ленинская"}]
["Предмет",null,null,{"$f":"Результаты!E7","v":"История"}]
[{"$f":"Результаты!A5","v":"Класс"},null,null,{"$f":"Результаты!E5","v":11}]
["Дата",null,null,{"$f":"Результаты!E9","v":"2018-01-13"}]
["Максимальный балл",null,null,{"$f":"Результаты!E11","v":55}]
["Пороговый балл",null,null,{"$f":"Результаты!E13","v":9}]
["Зона риска",null,null,{"$f":"Результаты!E15","v":9},{"$f":"Результаты!H15","v":10}]
["Первичный средний балл",null,null,{"$f":"Результаты!E17","v":22}]
["Тестовый средний балл",null,null,{"$f":"Результаты!E19","v":48}]
[]
["     С целью выявления уровня подготовки обучащихся в организации проведено репетиционное тестирование по вариантам, составленным специалистами издательства «Легион». "]
["     Содержание тестов строго соответствовало спецификации контрольных измерительных материалов, разработанной Федеральным институтом педагогических измерений (ФИПИ)."]
[]
[]
["Количество тестируемых",null,null,null,"чел.",{"$f":"Результаты!A179","v":0}]
["Уровни:",null,null,null,null,"Базовый","Повышенный","Высокий"]
["Всего заданий",null,null,null,"шт.",{"$f":"SUM(F20:H20)","v":32}]
[null,null,null,null,null,{"$f":"COUNTIF(Результаты!$E$22:$AJ$22,\"Б\")","v":16},{"$f":"COUNTIF(Результаты!$E$22:$AJ$22,\"П\")","v":8},{"$f":"COUNTIF(Результаты!$E$22:$AJ$22,\"В\")","v":8}]
["Всего баллов",null,null,null,"балл",{"$f":"SUM(F22:H22)","v":66}]
[null,null,null,null,null,{"$f":"SUMIF(Результаты!$E$22:$AJ$22,\"Б\",Результаты!$E$24:$AJ$24)","v":25},{"$f":"SUMIF(Результаты!$E$22:$AJ$22,\"П\",Результаты!$E$24:$AJ$24)","v":15},{"$f":"SUMIF(Результаты!$E$22:$AJ$22,\"В\",Результаты!$E$24:$AJ$24)","v":26}]
["Средний балл по уровням",null,null,null,"балл",{"$f":"SUMIF(Результаты!$E$22:$AJ$22,\"Б\",Результаты!$E$26:$AJ$175)/Результаты!$A$179","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Результаты!$E$22:$AJ$22,\"П\",Результаты!$E$26:$AJ$175)/Результаты!$A$179","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Результаты!$E$22:$AJ$22,\"В\",Результаты!$E$26:$AJ$175)/Результаты!$A$179","v":{"$error":"#DIV/0!"}}]
["% выполнения работы по уровням",null,null,null,null,{"$f":"Результаты!AL180","v":44},{"$f":"Результаты!AM180","v":46.666666666666664},{"$f":"Результаты!AN180","v":34.615384615384613}]
["Средний балл по работе",null,null,null,"балл",{"$f":"Результаты!AK180","v":22}]
["Преодолели порог",null,null,null,"чел.",{"$f":"SUM(Результаты!AQ177:AQ179)","v":1}]
[null,null,null,null,"%",{"$f":"SUM(Результаты!AR177:AR179)","v":{"$error":"#DIV/0!"}}]
["Не преодолели порог",null,null,null,"чел.",{"$f":"Результаты!A179-Анализ!F26","v":-1}]
[null,null,null,null,"%",{"$f":"Результаты!AR180","v":{"$error":"#DIV/0!"}}]
["Попали в группу риска (пороговый балл + 1)",null,null,null,"чел.",{"$f":"COUNTIF(Результаты!AK26:AK175,D9)+COUNTIF(Результаты!AK26:AK175,E9)","v":0}]
[null,null,null,null,"%",{"$f":"F30/F17","v":{"$error":"#DIV/0!"}}]
["Получили оценку",null,null,null,"балл","\"5\"","\"4\"","\"3\"","\"2\""]
[null,null,null,null,"чел.",{"$f":"Результаты!$AQ$177","v":0},{"$f":"Результаты!$AQ$178","v":0},{"$f":"Результаты!$AQ$179","v":1},{"$f":"Результаты!$AQ$180","v":0}]
[null,null,null,null,"%",{"$f":"Результаты!$AR$177","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AR$178","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AR$179","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AR$180","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Таблица перевода баллов"]
["номер","тема задания",null,null,null,null,null,null,null,null,null,"приступили","решили верно и полностью","%      верно решенных"]
[1,"Систематизация исторической информации (умение определять последовательность событий)",null,null,null,null,"С древнейших времён до начала XXI в. (история России, история зарубежных стран)",null,null,null,null,{"$f":"TRANSPOSE(Результаты!E177:AJ177)","v":1},{"$f":"TRANSPOSE(Результаты!E179:AJ179)","v":1},{"$f":"TRANSPOSE(Результаты!E180:AJ180)","v":{"$error":"#DIV/0!"}},null,"Первичный балл","Тестовый балл","Оценка"]
[2,"Знание дат (задание на установление соответствия)",null,null,null,null,"VIII-начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,0,0,0]
[3,"Определение терминов (множественный выбор)",null,null,null,null,"Один из периодов, изучаемых в курсе истории России (VIII - начало XXI в.)",null,null,null,null,1,1,{"$error":"#DIV/0!"},null,1,4,2]
[4,"Определение термина по нескольким признакам",null,null,null,null,"Один из периодов, изучаемых в курсе истории России (VIII - начало XXI в.)",null,null,null,null,1,1,{"$error":"#DIV/0!"},null,2,8,2]
[5,"Знание основных фактов, процессов, явлений (задание на установление соответствия)",null,null,null,null,"VIII-начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,3,11,2]
[6,"Работа с текстовым историческим источником (задание на установление соответствия)",null,null,null,null,"VIII- 1914 г.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,4,15,2]
[7,"Систематизация исторической информации (множественный выбор)",null,null,null,null,"Один из периодов, изучаемых в курсе истории России (VIII - начало XXI в.)",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,5,18,2]
[8,"Знание основных фактов, процессов, явлений (задание на заполнение пропусков в предложениях)",null,null,null,null,"1941-1945 гг.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,6,22,2]
[9,"Знание исторических деятелей (задание на установление соответствия)",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,7,25,2]
[10,"Работа с текстовым историческим источником (краткий ответ в виде слова, словосочетания)",null,null,null,null,"1914-2012 гг.",null,null,null,null,1,1,{"$error":"#DIV/0!"},null,8,29,2]
[11,"Систематизация исторической информации, представленной в различных знаковых системах (таблица)",null,null,null,null,"С древнейших времён до начала XXI в. (история России, история зарубежных стран)",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,9,32,3]
[12,"Работа с текстовым историческим источником",null,null,null,null,"Один из периодов, изучаемых в курсе истории России (VIII - начало XXI в.)",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,10,34,3]
[13,"Работа с исторической картой (схемой)",null,null,null,null,"Один из периодов, изучаемых в курсе истории России (VIII - начало XXI в.)",null,null,null,null,1,1,{"$error":"#DIV/0!"},null,11,35,3]
[14,"Работа с исторической картой (схемой)",null,null,null,null,"Один из периодов, изучаемых в курсе истории России (VIII - начало XXI в.)",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,12,36,3]
[15,"Работа с исторической картой (схемой)",null,null,null,null,"Один из периодов, изучаемых в курсе истории России (VIII - начало XXI в.)",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,13,37,3]
[16,"Работа с исторической картой (схемой)",null,null,null,null,"Один из периодов, изучаемых в курсе истории России (VIII - начало XXI в.)",null,null,null,null,1,1,{"$error":"#DIV/0!"},null,14,38,3]
[17,"Знание основных фактов, процессов, явлений истории культуры России (задание на установление соответствия)",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,15,40,3]
[18,"Анализ иллюстративного материала",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,1,{"$error":"#DIV/0!"},null,16,41,3]
[19,"Анализ иллюстративного материала",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,1,{"$error":"#DIV/0!"},null,17,42,3]
[20,"Характеристика авторства, времени, обстоятельств и целей создания источника",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,18,43,3]
[21,"Умение проводить поиск исторической информации в источниках разного типа",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,19,44,3]
[22,"Умение использовать принципы структурно-функционального, временного и пространственного анализа при работе с источником",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,20,45,3]
[23,"Умение использовать принципы структурно-функционального, временного и пространственного анализа при рассмотрении фактов, явлений, процессов (задание-задача)",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,21,47,3]
[24,"Умение использовать исторические сведения для аргументации в ходе дискуссии",null,null,null,null,"VIII - начало XXI в.",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,22,48,3]
[25,"Историческое сочинение",null,null,null,null,"VIII - начало XXI в. (три периода на выбор экзаменуемого)",null,null,null,null,1,0,{"$error":"#DIV/0!"},null,23,49,3]
["К1","Указание событий (явлений, процессов)",null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"},null,24,50,3]
["К2","Исторические личности и их роль в указанных событиях (явлениях, процессах) данного периода истории",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"},null,25,51,3]
["К3","Причинно-следственные связи",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"},null,26,52,4]
["К4","Оценка влияния данного периода на дальнейшую историю России",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"},null,27,54,4]
["К5","Использование исторической терминологии",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"},null,28,55,4]
["К6","Наличие / отсутствие фактических ошибок",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"},null,29,56,4]
["К7","Форма изложения",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"},null,30,57,4]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,31,58,4]
["Рекомендации эксперта",null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,32,60,4]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,33,61,4]
[36,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,34,62,4]
[37,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,35,63,4]
[38,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,36,64,4]
[39,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,37,65,4]
[40,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,38,67,4]
[41,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,39,68,5]
[42,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,40,69,5]
[43,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,41,70,5]
[44,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,42,71,5]
[45,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,43,72,5]
[46,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,44,75,5]
[47,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45,77,5]
[48,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,46,79,5]
[49,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,47,82,5]
[50,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,48,84,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,86,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,89,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,91,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,93,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,96,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,98,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,100,5]

{"sheet":"Инструкция","index":2,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["При подготовке анализа заполнить следующие данные:"]
[]
["При открытии файла разрешить работу макросов!"]
[]
["1. Лист \"Результаты\" - поля, помеченные голубой заливкой"]
[null,"Класс"]
[null,"Предмет"]
[null,"Дата"]
[null,"Пороговый балл"]
[null,"Зона риска (пороговый балл + 1) -внести данные в отдельные клеточки"]
[null,"Уровни заданий (А1…..Аn, В1…Вn, С1…Сn или 1…n)"]
[null,"Уровни заданий (Базовый - Б, Повышенный - П, Высокий - В)",null,null,null,null,null,"необходимо отмечать заглавными буквами"]
[null,"Максимальные баллы за выполнения заданий"]
[null,"Буква класса"]
[null,"ФИО учащегося"]
[null,"Вариант"]
[null,"Выполнение заданий по каждому учащемуся"]
["2. Лист \"Анализ\" - поля, помеченные голубой заливкой"]
[null,"Темы заданий"]
[null,"Рекомендации эксперта"]
[null,"ФИО эксперта"]
[null,"Таблица перевода баллов (Количество первичных баллов, Соответствующие им тестовые баллы и Соответсвующие им оценки по 5-балльной шкале)"]
[]
["3. При результате тестирования \"0\" баллов - самостоятельно в столбце с оценкой поставить \"2\""]
[]
["4. Шаблон хранить без заполнения данными. При создании нового файла результатов открыть шаблон и сохранить под другим именем (именем проверяемого учреждения)"]