{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Результаты","Анализ","Инструкция"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":178,"n_cols":43,"rows_kept":178,"cut":false,"hidden":false,"merged":[[18,41,22,41],[2,21,2,24],[4,12,6,17],[4,19,6,20],[10,12,12,17],[10,19,12,20],[18,40,19,40],[18,37,19,37],[18,0,19,2],[184,14,184,15],[10,4,10,9],[12,4,12,9],[21,0,21,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],[224,8,224,9],[220,8,220,9],[221,8,221,9],[222,8,222,9],[186,14,186,15],[223,8,223,9],[174,37,176,39],[185,14,185,15],[183,14,183,15],[18,38,18,39],[2,4,2,9],[6,0,6,2],[8,0,8,2],[2,0,2,2],[6,4,6,9],[8,4,8,9],[4,0,4,2],[4,4,4,9]]}
[]
[]
["Образовательная организация",null,null,null,"Ленинская СОШ",null,null,null,null,null,null,null,null,null,{"$f":"A177","v":0},"чел.",null,null,null,null,null,"2018-01-24T22:31:29"]
[]
["Класс",null,null,null,9,null,null,null,null,null,null,null,"Средний балл ГИА-9 2017 года по г.Ростову-на-Дону",null,null,null,null,null,null,4.3099999999999996]
[]
["Предмет",null,null,null,"Иностранный язык"]
[]
["Дата",null,null,null,{"$f":"V3","v":"2018-01-24T22:31:29"}]
[]
["Максимальный балл",null,null,null,{"$f":"AL22","v":55},null,null,null,null,null,null,null,"Средний балл по ОУ",null,null,null,null,null,null,{"$f":"(AP175*5+AP176*4+AP177*3+AP178*2)/A177","v":{"$error":"#DIV/0!"}}]
[]
["Пороговый балл",null,null,null,29]
[]
["Зона риска",null,null,null,29,null,null,30]
[]
["Средний тестовый балл по работе",null,null,null,{"$f":"AL178","v":26}]
[]
["Уровни",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,33,"Тестовый балл","% выплнения по уровням",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,33]
["Максимальный балл",null,null,null,4,5,1,1,1,1,1,1,7,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,10,{"$f":"SUM(E22:AK22)","v":55},{"$f":"SUMIF($E$20:$AK$20,\"Б\",$E$22:$AK$22)*100/$AL22","v":47.272727272727273},{"$f":"SUMIF($E$20:$AK$20,\"П\",$E$22:$AK$22)*100/$AL$22","v":52.727272727272727}]
[null,null,null,"вариант"]
[1,null,null,1,4,2,0,1,1,1,1,0,4,1,1,1,1,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,5,{"$f":"SUM(E24:AK24)","v":26},{"$f":"SUMIF($E$20:$AK$20,\"Б\",$E24:$AK24)/SUMIF($E$20:$AK$20,\"Б\",$E$22:$AK$22)*100","v":53.846153846153847},{"$f":"SUMIF($E$20:$AK$20,\"П\",$E24:$AK24)/SUMIF($E$20:$AK$20,\"П\",$E$22:$AK$22)*100","v":41.379310344827587},{"$f":"IF(AL24>=Анализ!$A$36,\"5\",IF(AND(AL24>=Анализ!$A$37,AL24<Анализ!$A$36),\"4\",IF(AND(AL24>=Анализ!$A$38,AL24<Анализ!$A$37),\"3\",IF(AND(AL24>=1,AL24<Анализ!$A$38),\"2\",\"-\"))))","v":"2"},{"$f":"SUM(COUNTIF($E24,$E$22),COUNTIF($F24,$F$22),COUNTIF($G24,$G$22),COUNTIF($H24,$H$22),COUNTIF($I24,$I$22),COUNTIF($J24,$J$22),COUNTIF($K24,$K$22),COUNTIF($L24,$L$22),COUNTIF($M24,$M$22),COUNTIF($N24,$N$22),COUNTIF($O24,$O$22),COUNTIF($P24,$P$22),COUNTIF($Q24,$Q$22),COUNTIF($R24,$R$22),COUNTIF($S24,$S$22),COUNTIF($T24,$T$22),COUNTIF($U24,$U$22),COUNTIF($V24,$V$22),COUNTIF($W24,$W$22),COUNTIF($X24,$X$22),COUNTIF($Y24,$Y$22),COUNTIF($Z24,$Z$22),COUNTIF($AA24,$AA$22),COUNTIF($AB24,$AB$22),COUNTIF($AC24,$AC$22),COUNTIF($AD$22,$AD24),COUNTIF($AE$22,$AE24),COUNTIF($AF$22,$AF24),COUNTIF($AG$22,$AG24),COUNTIF($AH$22,$AH24),COUNTIF($AI$22,$AI24),COUNTIF($AJ$22,$AJ24),COUNTIF($AK$22,$AK24))*100/33","v":36.363636363636367}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AL25>=Анализ!$A$36,\"5\",IF(AND(AL25>=Анализ!$A$37,AL25<Анализ!$A$36),\"4\",IF(AND(AL25>=Анализ!$A$38,AL25<Анализ!$A$37),\"3\",IF(AND(AL25>=1,AL25<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},{"$f":"SUM(COUNTIF($E25,$E$22),COUNTIF($F25,$F$22),COUNTIF($G25,$G$22),COUNTIF($H25,$H$22),COUNTIF($I25,$I$22),COUNTIF($J25,$J$22),COUNTIF($K25,$K$22),COUNTIF($L25,$L$22),COUNTIF($M25,$M$22),COUNTIF($N25,$N$22),COUNTIF($O25,$O$22),COUNTIF($P25,$P$22),COUNTIF($Q25,$Q$22),COUNTIF($R25,$R$22),COUNTIF($S25,$S$22),COUNTIF($T25,$T$22),COUNTIF($U25,$U$22),COUNTIF($V25,$V$22),COUNTIF($W25,$W$22),COUNTIF($X25,$X$22),COUNTIF($Y25,$Y$22),COUNTIF($Z25,$Z$22),COUNTIF($AA25,$AA$22),COUNTIF($AB25,$AB$22),COUNTIF($AC25,$AC$22),COUNTIF($AD$22,$AD25),COUNTIF($AE$22,$AE25),COUNTIF($AF$22,$AF25),COUNTIF($AG$22,$AG25),COUNTIF($AH$22,$AH25),COUNTIF($AI$22,$AI25),COUNTIF($AJ$22,$AJ25),COUNTIF($AK$22,$AK25))*100/33","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,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AL26>=Анализ!$A$36,\"5\",IF(AND(AL26>=Анализ!$A$37,AL26<Анализ!$A$36),\"4\",IF(AND(AL26>=Анализ!$A$38,AL26<Анализ!$A$37),\"3\",IF(AND(AL26>=1,AL26<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL27>=Анализ!$A$36,\"5\",IF(AND(AL27>=Анализ!$A$37,AL27<Анализ!$A$36),\"4\",IF(AND(AL27>=Анализ!$A$38,AL27<Анализ!$A$37),\"3\",IF(AND(AL27>=1,AL27<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL28>=Анализ!$A$36,\"5\",IF(AND(AL28>=Анализ!$A$37,AL28<Анализ!$A$36),\"4\",IF(AND(AL28>=Анализ!$A$38,AL28<Анализ!$A$37),\"3\",IF(AND(AL28>=1,AL28<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL29>=Анализ!$A$36,\"5\",IF(AND(AL29>=Анализ!$A$37,AL29<Анализ!$A$36),\"4\",IF(AND(AL29>=Анализ!$A$38,AL29<Анализ!$A$37),\"3\",IF(AND(AL29>=1,AL29<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL30>=Анализ!$A$36,\"5\",IF(AND(AL30>=Анализ!$A$37,AL30<Анализ!$A$36),\"4\",IF(AND(AL30>=Анализ!$A$38,AL30<Анализ!$A$37),\"3\",IF(AND(AL30>=1,AL30<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL31>=Анализ!$A$36,\"5\",IF(AND(AL31>=Анализ!$A$37,AL31<Анализ!$A$36),\"4\",IF(AND(AL31>=Анализ!$A$38,AL31<Анализ!$A$37),\"3\",IF(AND(AL31>=1,AL31<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL32>=Анализ!$A$36,\"5\",IF(AND(AL32>=Анализ!$A$37,AL32<Анализ!$A$36),\"4\",IF(AND(AL32>=Анализ!$A$38,AL32<Анализ!$A$37),\"3\",IF(AND(AL32>=1,AL32<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL33>=Анализ!$A$36,\"5\",IF(AND(AL33>=Анализ!$A$37,AL33<Анализ!$A$36),\"4\",IF(AND(AL33>=Анализ!$A$38,AL33<Анализ!$A$37),\"3\",IF(AND(AL33>=1,AL33<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL34>=Анализ!$A$36,\"5\",IF(AND(AL34>=Анализ!$A$37,AL34<Анализ!$A$36),\"4\",IF(AND(AL34>=Анализ!$A$38,AL34<Анализ!$A$37),\"3\",IF(AND(AL34>=1,AL34<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL35>=Анализ!$A$36,\"5\",IF(AND(AL35>=Анализ!$A$37,AL35<Анализ!$A$36),\"4\",IF(AND(AL35>=Анализ!$A$38,AL35<Анализ!$A$37),\"3\",IF(AND(AL35>=1,AL35<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL36>=Анализ!$A$36,\"5\",IF(AND(AL36>=Анализ!$A$37,AL36<Анализ!$A$36),\"4\",IF(AND(AL36>=Анализ!$A$38,AL36<Анализ!$A$37),\"3\",IF(AND(AL36>=1,AL36<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL37>=Анализ!$A$36,\"5\",IF(AND(AL37>=Анализ!$A$37,AL37<Анализ!$A$36),\"4\",IF(AND(AL37>=Анализ!$A$38,AL37<Анализ!$A$37),\"3\",IF(AND(AL37>=1,AL37<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL38>=Анализ!$A$36,\"5\",IF(AND(AL38>=Анализ!$A$37,AL38<Анализ!$A$36),\"4\",IF(AND(AL38>=Анализ!$A$38,AL38<Анализ!$A$37),\"3\",IF(AND(AL38>=1,AL38<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL39>=Анализ!$A$36,\"5\",IF(AND(AL39>=Анализ!$A$37,AL39<Анализ!$A$36),\"4\",IF(AND(AL39>=Анализ!$A$38,AL39<Анализ!$A$37),\"3\",IF(AND(AL39>=1,AL39<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL40>=Анализ!$A$36,\"5\",IF(AND(AL40>=Анализ!$A$37,AL40<Анализ!$A$36),\"4\",IF(AND(AL40>=Анализ!$A$38,AL40<Анализ!$A$37),\"3\",IF(AND(AL40>=1,AL40<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL41>=Анализ!$A$36,\"5\",IF(AND(AL41>=Анализ!$A$37,AL41<Анализ!$A$36),\"4\",IF(AND(AL41>=Анализ!$A$38,AL41<Анализ!$A$37),\"3\",IF(AND(AL41>=1,AL41<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL42>=Анализ!$A$36,\"5\",IF(AND(AL42>=Анализ!$A$37,AL42<Анализ!$A$36),\"4\",IF(AND(AL42>=Анализ!$A$38,AL42<Анализ!$A$37),\"3\",IF(AND(AL42>=1,AL42<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL43>=Анализ!$A$36,\"5\",IF(AND(AL43>=Анализ!$A$37,AL43<Анализ!$A$36),\"4\",IF(AND(AL43>=Анализ!$A$38,AL43<Анализ!$A$37),\"3\",IF(AND(AL43>=1,AL43<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL44>=Анализ!$A$36,\"5\",IF(AND(AL44>=Анализ!$A$37,AL44<Анализ!$A$36),\"4\",IF(AND(AL44>=Анализ!$A$38,AL44<Анализ!$A$37),\"3\",IF(AND(AL44>=1,AL44<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL45>=Анализ!$A$36,\"5\",IF(AND(AL45>=Анализ!$A$37,AL45<Анализ!$A$36),\"4\",IF(AND(AL45>=Анализ!$A$38,AL45<Анализ!$A$37),\"3\",IF(AND(AL45>=1,AL45<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL46>=Анализ!$A$36,\"5\",IF(AND(AL46>=Анализ!$A$37,AL46<Анализ!$A$36),\"4\",IF(AND(AL46>=Анализ!$A$38,AL46<Анализ!$A$37),\"3\",IF(AND(AL46>=1,AL46<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL47>=Анализ!$A$36,\"5\",IF(AND(AL47>=Анализ!$A$37,AL47<Анализ!$A$36),\"4\",IF(AND(AL47>=Анализ!$A$38,AL47<Анализ!$A$37),\"3\",IF(AND(AL47>=1,AL47<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL48>=Анализ!$A$36,\"5\",IF(AND(AL48>=Анализ!$A$37,AL48<Анализ!$A$36),\"4\",IF(AND(AL48>=Анализ!$A$38,AL48<Анализ!$A$37),\"3\",IF(AND(AL48>=1,AL48<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL49>=Анализ!$A$36,\"5\",IF(AND(AL49>=Анализ!$A$37,AL49<Анализ!$A$36),\"4\",IF(AND(AL49>=Анализ!$A$38,AL49<Анализ!$A$37),\"3\",IF(AND(AL49>=1,AL49<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL50>=Анализ!$A$36,\"5\",IF(AND(AL50>=Анализ!$A$37,AL50<Анализ!$A$36),\"4\",IF(AND(AL50>=Анализ!$A$38,AL50<Анализ!$A$37),\"3\",IF(AND(AL50>=1,AL50<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL51>=Анализ!$A$36,\"5\",IF(AND(AL51>=Анализ!$A$37,AL51<Анализ!$A$36),\"4\",IF(AND(AL51>=Анализ!$A$38,AL51<Анализ!$A$37),\"3\",IF(AND(AL51>=1,AL51<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL52>=Анализ!$A$36,\"5\",IF(AND(AL52>=Анализ!$A$37,AL52<Анализ!$A$36),\"4\",IF(AND(AL52>=Анализ!$A$38,AL52<Анализ!$A$37),\"3\",IF(AND(AL52>=1,AL52<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL53>=Анализ!$A$36,\"5\",IF(AND(AL53>=Анализ!$A$37,AL53<Анализ!$A$36),\"4\",IF(AND(AL53>=Анализ!$A$38,AL53<Анализ!$A$37),\"3\",IF(AND(AL53>=1,AL53<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL54>=Анализ!$A$36,\"5\",IF(AND(AL54>=Анализ!$A$37,AL54<Анализ!$A$36),\"4\",IF(AND(AL54>=Анализ!$A$38,AL54<Анализ!$A$37),\"3\",IF(AND(AL54>=1,AL54<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL55>=Анализ!$A$36,\"5\",IF(AND(AL55>=Анализ!$A$37,AL55<Анализ!$A$36),\"4\",IF(AND(AL55>=Анализ!$A$38,AL55<Анализ!$A$37),\"3\",IF(AND(AL55>=1,AL55<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,{"$f":"SUM(E56:AK56)","v":0},{"$f":"SUMIF($E$20:$AK$20,\"Б\",$E56:$AK56)/SUMIF($E$20:$AK$20,\"Б\",$E$22:$AK$22)*100","v":0},{"$f":"SUMIF($E$20:$AK$20,\"П\",$E56:$AK56)/SUMIF($E$20:$AK$20,\"П\",$E$22:$AK$22)*100","v":0},{"$f":"IF(AL56>=Анализ!$A$36,\"5\",IF(AND(AL56>=Анализ!$A$37,AL56<Анализ!$A$36),\"4\",IF(AND(AL56>=Анализ!$A$38,AL56<Анализ!$A$37),\"3\",IF(AND(AL56>=1,AL56<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL57>=Анализ!$A$36,\"5\",IF(AND(AL57>=Анализ!$A$37,AL57<Анализ!$A$36),\"4\",IF(AND(AL57>=Анализ!$A$38,AL57<Анализ!$A$37),\"3\",IF(AND(AL57>=1,AL57<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL58>=Анализ!$A$36,\"5\",IF(AND(AL58>=Анализ!$A$37,AL58<Анализ!$A$36),\"4\",IF(AND(AL58>=Анализ!$A$38,AL58<Анализ!$A$37),\"3\",IF(AND(AL58>=1,AL58<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL59>=Анализ!$A$36,\"5\",IF(AND(AL59>=Анализ!$A$37,AL59<Анализ!$A$36),\"4\",IF(AND(AL59>=Анализ!$A$38,AL59<Анализ!$A$37),\"3\",IF(AND(AL59>=1,AL59<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},0]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AL60>=Анализ!$A$36,\"5\",IF(AND(AL60>=Анализ!$A$37,AL60<Анализ!$A$36),\"4\",IF(AND(AL60>=Анализ!$A$38,AL60<Анализ!$A$37),\"3\",IF(AND(AL60>=1,AL60<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL61>=Анализ!$A$36,\"5\",IF(AND(AL61>=Анализ!$A$37,AL61<Анализ!$A$36),\"4\",IF(AND(AL61>=Анализ!$A$38,AL61<Анализ!$A$37),\"3\",IF(AND(AL61>=1,AL61<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL62>=Анализ!$A$36,\"5\",IF(AND(AL62>=Анализ!$A$37,AL62<Анализ!$A$36),\"4\",IF(AND(AL62>=Анализ!$A$38,AL62<Анализ!$A$37),\"3\",IF(AND(AL62>=1,AL62<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL63>=Анализ!$A$36,\"5\",IF(AND(AL63>=Анализ!$A$37,AL63<Анализ!$A$36),\"4\",IF(AND(AL63>=Анализ!$A$38,AL63<Анализ!$A$37),\"3\",IF(AND(AL63>=1,AL63<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL64>=Анализ!$A$36,\"5\",IF(AND(AL64>=Анализ!$A$37,AL64<Анализ!$A$36),\"4\",IF(AND(AL64>=Анализ!$A$38,AL64<Анализ!$A$37),\"3\",IF(AND(AL64>=1,AL64<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL65>=Анализ!$A$36,\"5\",IF(AND(AL65>=Анализ!$A$37,AL65<Анализ!$A$36),\"4\",IF(AND(AL65>=Анализ!$A$38,AL65<Анализ!$A$37),\"3\",IF(AND(AL65>=1,AL65<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL66>=Анализ!$A$36,\"5\",IF(AND(AL66>=Анализ!$A$37,AL66<Анализ!$A$36),\"4\",IF(AND(AL66>=Анализ!$A$38,AL66<Анализ!$A$37),\"3\",IF(AND(AL66>=1,AL66<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL67>=Анализ!$A$36,\"5\",IF(AND(AL67>=Анализ!$A$37,AL67<Анализ!$A$36),\"4\",IF(AND(AL67>=Анализ!$A$38,AL67<Анализ!$A$37),\"3\",IF(AND(AL67>=1,AL67<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL68>=Анализ!$A$36,\"5\",IF(AND(AL68>=Анализ!$A$37,AL68<Анализ!$A$36),\"4\",IF(AND(AL68>=Анализ!$A$38,AL68<Анализ!$A$37),\"3\",IF(AND(AL68>=1,AL68<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL69>=Анализ!$A$36,\"5\",IF(AND(AL69>=Анализ!$A$37,AL69<Анализ!$A$36),\"4\",IF(AND(AL69>=Анализ!$A$38,AL69<Анализ!$A$37),\"3\",IF(AND(AL69>=1,AL69<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL70>=Анализ!$A$36,\"5\",IF(AND(AL70>=Анализ!$A$37,AL70<Анализ!$A$36),\"4\",IF(AND(AL70>=Анализ!$A$38,AL70<Анализ!$A$37),\"3\",IF(AND(AL70>=1,AL70<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL71>=Анализ!$A$36,\"5\",IF(AND(AL71>=Анализ!$A$37,AL71<Анализ!$A$36),\"4\",IF(AND(AL71>=Анализ!$A$38,AL71<Анализ!$A$37),\"3\",IF(AND(AL71>=1,AL71<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL72>=Анализ!$A$36,\"5\",IF(AND(AL72>=Анализ!$A$37,AL72<Анализ!$A$36),\"4\",IF(AND(AL72>=Анализ!$A$38,AL72<Анализ!$A$37),\"3\",IF(AND(AL72>=1,AL72<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL73>=Анализ!$A$36,\"5\",IF(AND(AL73>=Анализ!$A$37,AL73<Анализ!$A$36),\"4\",IF(AND(AL73>=Анализ!$A$38,AL73<Анализ!$A$37),\"3\",IF(AND(AL73>=1,AL73<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL74>=Анализ!$A$36,\"5\",IF(AND(AL74>=Анализ!$A$37,AL74<Анализ!$A$36),\"4\",IF(AND(AL74>=Анализ!$A$38,AL74<Анализ!$A$37),\"3\",IF(AND(AL74>=1,AL74<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL75>=Анализ!$A$36,\"5\",IF(AND(AL75>=Анализ!$A$37,AL75<Анализ!$A$36),\"4\",IF(AND(AL75>=Анализ!$A$38,AL75<Анализ!$A$37),\"3\",IF(AND(AL75>=1,AL75<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL76>=Анализ!$A$36,\"5\",IF(AND(AL76>=Анализ!$A$37,AL76<Анализ!$A$36),\"4\",IF(AND(AL76>=Анализ!$A$38,AL76<Анализ!$A$37),\"3\",IF(AND(AL76>=1,AL76<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL77>=Анализ!$A$36,\"5\",IF(AND(AL77>=Анализ!$A$37,AL77<Анализ!$A$36),\"4\",IF(AND(AL77>=Анализ!$A$38,AL77<Анализ!$A$37),\"3\",IF(AND(AL77>=1,AL77<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL78>=Анализ!$A$36,\"5\",IF(AND(AL78>=Анализ!$A$37,AL78<Анализ!$A$36),\"4\",IF(AND(AL78>=Анализ!$A$38,AL78<Анализ!$A$37),\"3\",IF(AND(AL78>=1,AL78<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL79>=Анализ!$A$36,\"5\",IF(AND(AL79>=Анализ!$A$37,AL79<Анализ!$A$36),\"4\",IF(AND(AL79>=Анализ!$A$38,AL79<Анализ!$A$37),\"3\",IF(AND(AL79>=1,AL79<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL80>=Анализ!$A$36,\"5\",IF(AND(AL80>=Анализ!$A$37,AL80<Анализ!$A$36),\"4\",IF(AND(AL80>=Анализ!$A$38,AL80<Анализ!$A$37),\"3\",IF(AND(AL80>=1,AL80<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL81>=Анализ!$A$36,\"5\",IF(AND(AL81>=Анализ!$A$37,AL81<Анализ!$A$36),\"4\",IF(AND(AL81>=Анализ!$A$38,AL81<Анализ!$A$37),\"3\",IF(AND(AL81>=1,AL81<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL82>=Анализ!$A$36,\"5\",IF(AND(AL82>=Анализ!$A$37,AL82<Анализ!$A$36),\"4\",IF(AND(AL82>=Анализ!$A$38,AL82<Анализ!$A$37),\"3\",IF(AND(AL82>=1,AL82<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL83>=Анализ!$A$36,\"5\",IF(AND(AL83>=Анализ!$A$37,AL83<Анализ!$A$36),\"4\",IF(AND(AL83>=Анализ!$A$38,AL83<Анализ!$A$37),\"3\",IF(AND(AL83>=1,AL83<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL84>=Анализ!$A$36,\"5\",IF(AND(AL84>=Анализ!$A$37,AL84<Анализ!$A$36),\"4\",IF(AND(AL84>=Анализ!$A$38,AL84<Анализ!$A$37),\"3\",IF(AND(AL84>=1,AL84<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL85>=Анализ!$A$36,\"5\",IF(AND(AL85>=Анализ!$A$37,AL85<Анализ!$A$36),\"4\",IF(AND(AL85>=Анализ!$A$38,AL85<Анализ!$A$37),\"3\",IF(AND(AL85>=1,AL85<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL86>=Анализ!$A$36,\"5\",IF(AND(AL86>=Анализ!$A$37,AL86<Анализ!$A$36),\"4\",IF(AND(AL86>=Анализ!$A$38,AL86<Анализ!$A$37),\"3\",IF(AND(AL86>=1,AL86<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL87>=Анализ!$A$36,\"5\",IF(AND(AL87>=Анализ!$A$37,AL87<Анализ!$A$36),\"4\",IF(AND(AL87>=Анализ!$A$38,AL87<Анализ!$A$37),\"3\",IF(AND(AL87>=1,AL87<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,{"$f":"SUM(E88:AK88)","v":0},{"$f":"SUMIF($E$20:$AK$20,\"Б\",$E88:$AK88)/SUMIF($E$20:$AK$20,\"Б\",$E$22:$AK$22)*100","v":0},{"$f":"SUMIF($E$20:$AK$20,\"П\",$E88:$AK88)/SUMIF($E$20:$AK$20,\"П\",$E$22:$AK$22)*100","v":0},{"$f":"IF(AL88>=Анализ!$A$36,\"5\",IF(AND(AL88>=Анализ!$A$37,AL88<Анализ!$A$36),\"4\",IF(AND(AL88>=Анализ!$A$38,AL88<Анализ!$A$37),\"3\",IF(AND(AL88>=1,AL88<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AL89>=Анализ!$A$36,\"5\",IF(AND(AL89>=Анализ!$A$37,AL89<Анализ!$A$36),\"4\",IF(AND(AL89>=Анализ!$A$38,AL89<Анализ!$A$37),\"3\",IF(AND(AL89>=1,AL89<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},{"$f":"SUM(COUNTIF($E89,$E$22),COUNTIF($F89,$F$22),COUNTIF($G89,$G$22),COUNTIF($H89,$H$22),COUNTIF($I89,$I$22),COUNTIF($J89,$J$22),COUNTIF($K89,$K$22),COUNTIF($L89,$L$22),COUNTIF($M89,$M$22),COUNTIF($N89,$N$22),COUNTIF($O89,$O$22),COUNTIF($P89,$P$22),COUNTIF($Q89,$Q$22),COUNTIF($R89,$R$22),COUNTIF($S89,$S$22),COUNTIF($T89,$T$22),COUNTIF($U89,$U$22),COUNTIF($V89,$V$22),COUNTIF($W89,$W$22),COUNTIF($X89,$X$22),COUNTIF($Y89,$Y$22),COUNTIF($Z89,$Z$22),COUNTIF($AA89,$AA$22),COUNTIF($AB89,$AB$22),COUNTIF($AC89,$AC$22),COUNTIF($AD$22,$AD89),COUNTIF($AE$22,$AE89),COUNTIF($AF$22,$AF89),COUNTIF($AG$22,$AG89),COUNTIF($AH$22,$AH89),COUNTIF($AI$22,$AI89),COUNTIF($AJ$22,$AJ89),COUNTIF($AK$22,$AK89))*100/33","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,null,null,0,0,0,{"$f":"IF(AL90>=Анализ!$A$36,\"5\",IF(AND(AL90>=Анализ!$A$37,AL90<Анализ!$A$36),\"4\",IF(AND(AL90>=Анализ!$A$38,AL90<Анализ!$A$37),\"3\",IF(AND(AL90>=1,AL90<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL91>=Анализ!$A$36,\"5\",IF(AND(AL91>=Анализ!$A$37,AL91<Анализ!$A$36),\"4\",IF(AND(AL91>=Анализ!$A$38,AL91<Анализ!$A$37),\"3\",IF(AND(AL91>=1,AL91<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL92>=Анализ!$A$36,\"5\",IF(AND(AL92>=Анализ!$A$37,AL92<Анализ!$A$36),\"4\",IF(AND(AL92>=Анализ!$A$38,AL92<Анализ!$A$37),\"3\",IF(AND(AL92>=1,AL92<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL93>=Анализ!$A$36,\"5\",IF(AND(AL93>=Анализ!$A$37,AL93<Анализ!$A$36),\"4\",IF(AND(AL93>=Анализ!$A$38,AL93<Анализ!$A$37),\"3\",IF(AND(AL93>=1,AL93<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL94>=Анализ!$A$36,\"5\",IF(AND(AL94>=Анализ!$A$37,AL94<Анализ!$A$36),\"4\",IF(AND(AL94>=Анализ!$A$38,AL94<Анализ!$A$37),\"3\",IF(AND(AL94>=1,AL94<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL95>=Анализ!$A$36,\"5\",IF(AND(AL95>=Анализ!$A$37,AL95<Анализ!$A$36),\"4\",IF(AND(AL95>=Анализ!$A$38,AL95<Анализ!$A$37),\"3\",IF(AND(AL95>=1,AL95<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL96>=Анализ!$A$36,\"5\",IF(AND(AL96>=Анализ!$A$37,AL96<Анализ!$A$36),\"4\",IF(AND(AL96>=Анализ!$A$38,AL96<Анализ!$A$37),\"3\",IF(AND(AL96>=1,AL96<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL97>=Анализ!$A$36,\"5\",IF(AND(AL97>=Анализ!$A$37,AL97<Анализ!$A$36),\"4\",IF(AND(AL97>=Анализ!$A$38,AL97<Анализ!$A$37),\"3\",IF(AND(AL97>=1,AL97<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL98>=Анализ!$A$36,\"5\",IF(AND(AL98>=Анализ!$A$37,AL98<Анализ!$A$36),\"4\",IF(AND(AL98>=Анализ!$A$38,AL98<Анализ!$A$37),\"3\",IF(AND(AL98>=1,AL98<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL99>=Анализ!$A$36,\"5\",IF(AND(AL99>=Анализ!$A$37,AL99<Анализ!$A$36),\"4\",IF(AND(AL99>=Анализ!$A$38,AL99<Анализ!$A$37),\"3\",IF(AND(AL99>=1,AL99<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL100>=Анализ!$A$36,\"5\",IF(AND(AL100>=Анализ!$A$37,AL100<Анализ!$A$36),\"4\",IF(AND(AL100>=Анализ!$A$38,AL100<Анализ!$A$37),\"3\",IF(AND(AL100>=1,AL100<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL101>=Анализ!$A$36,\"5\",IF(AND(AL101>=Анализ!$A$37,AL101<Анализ!$A$36),\"4\",IF(AND(AL101>=Анализ!$A$38,AL101<Анализ!$A$37),\"3\",IF(AND(AL101>=1,AL101<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL102>=Анализ!$A$36,\"5\",IF(AND(AL102>=Анализ!$A$37,AL102<Анализ!$A$36),\"4\",IF(AND(AL102>=Анализ!$A$38,AL102<Анализ!$A$37),\"3\",IF(AND(AL102>=1,AL102<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL103>=Анализ!$A$36,\"5\",IF(AND(AL103>=Анализ!$A$37,AL103<Анализ!$A$36),\"4\",IF(AND(AL103>=Анализ!$A$38,AL103<Анализ!$A$37),\"3\",IF(AND(AL103>=1,AL103<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL104>=Анализ!$A$36,\"5\",IF(AND(AL104>=Анализ!$A$37,AL104<Анализ!$A$36),\"4\",IF(AND(AL104>=Анализ!$A$38,AL104<Анализ!$A$37),\"3\",IF(AND(AL104>=1,AL104<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL105>=Анализ!$A$36,\"5\",IF(AND(AL105>=Анализ!$A$37,AL105<Анализ!$A$36),\"4\",IF(AND(AL105>=Анализ!$A$38,AL105<Анализ!$A$37),\"3\",IF(AND(AL105>=1,AL105<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL106>=Анализ!$A$36,\"5\",IF(AND(AL106>=Анализ!$A$37,AL106<Анализ!$A$36),\"4\",IF(AND(AL106>=Анализ!$A$38,AL106<Анализ!$A$37),\"3\",IF(AND(AL106>=1,AL106<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL107>=Анализ!$A$36,\"5\",IF(AND(AL107>=Анализ!$A$37,AL107<Анализ!$A$36),\"4\",IF(AND(AL107>=Анализ!$A$38,AL107<Анализ!$A$37),\"3\",IF(AND(AL107>=1,AL107<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL108>=Анализ!$A$36,\"5\",IF(AND(AL108>=Анализ!$A$37,AL108<Анализ!$A$36),\"4\",IF(AND(AL108>=Анализ!$A$38,AL108<Анализ!$A$37),\"3\",IF(AND(AL108>=1,AL108<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL109>=Анализ!$A$36,\"5\",IF(AND(AL109>=Анализ!$A$37,AL109<Анализ!$A$36),\"4\",IF(AND(AL109>=Анализ!$A$38,AL109<Анализ!$A$37),\"3\",IF(AND(AL109>=1,AL109<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL110>=Анализ!$A$36,\"5\",IF(AND(AL110>=Анализ!$A$37,AL110<Анализ!$A$36),\"4\",IF(AND(AL110>=Анализ!$A$38,AL110<Анализ!$A$37),\"3\",IF(AND(AL110>=1,AL110<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL111>=Анализ!$A$36,\"5\",IF(AND(AL111>=Анализ!$A$37,AL111<Анализ!$A$36),\"4\",IF(AND(AL111>=Анализ!$A$38,AL111<Анализ!$A$37),\"3\",IF(AND(AL111>=1,AL111<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL112>=Анализ!$A$36,\"5\",IF(AND(AL112>=Анализ!$A$37,AL112<Анализ!$A$36),\"4\",IF(AND(AL112>=Анализ!$A$38,AL112<Анализ!$A$37),\"3\",IF(AND(AL112>=1,AL112<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL113>=Анализ!$A$36,\"5\",IF(AND(AL113>=Анализ!$A$37,AL113<Анализ!$A$36),\"4\",IF(AND(AL113>=Анализ!$A$38,AL113<Анализ!$A$37),\"3\",IF(AND(AL113>=1,AL113<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL114>=Анализ!$A$36,\"5\",IF(AND(AL114>=Анализ!$A$37,AL114<Анализ!$A$36),\"4\",IF(AND(AL114>=Анализ!$A$38,AL114<Анализ!$A$37),\"3\",IF(AND(AL114>=1,AL114<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL115>=Анализ!$A$36,\"5\",IF(AND(AL115>=Анализ!$A$37,AL115<Анализ!$A$36),\"4\",IF(AND(AL115>=Анализ!$A$38,AL115<Анализ!$A$37),\"3\",IF(AND(AL115>=1,AL115<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL116>=Анализ!$A$36,\"5\",IF(AND(AL116>=Анализ!$A$37,AL116<Анализ!$A$36),\"4\",IF(AND(AL116>=Анализ!$A$38,AL116<Анализ!$A$37),\"3\",IF(AND(AL116>=1,AL116<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL117>=Анализ!$A$36,\"5\",IF(AND(AL117>=Анализ!$A$37,AL117<Анализ!$A$36),\"4\",IF(AND(AL117>=Анализ!$A$38,AL117<Анализ!$A$37),\"3\",IF(AND(AL117>=1,AL117<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL118>=Анализ!$A$36,\"5\",IF(AND(AL118>=Анализ!$A$37,AL118<Анализ!$A$36),\"4\",IF(AND(AL118>=Анализ!$A$38,AL118<Анализ!$A$37),\"3\",IF(AND(AL118>=1,AL118<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL119>=Анализ!$A$36,\"5\",IF(AND(AL119>=Анализ!$A$37,AL119<Анализ!$A$36),\"4\",IF(AND(AL119>=Анализ!$A$38,AL119<Анализ!$A$37),\"3\",IF(AND(AL119>=1,AL119<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,{"$f":"SUM(E120:AK120)","v":0},{"$f":"SUMIF($E$20:$AK$20,\"Б\",$E120:$AK120)/SUMIF($E$20:$AK$20,\"Б\",$E$22:$AK$22)*100","v":0},{"$f":"SUMIF($E$20:$AK$20,\"П\",$E120:$AK120)/SUMIF($E$20:$AK$20,\"П\",$E$22:$AK$22)*100","v":0},{"$f":"IF(AL120>=Анализ!$A$36,\"5\",IF(AND(AL120>=Анализ!$A$37,AL120<Анализ!$A$36),\"4\",IF(AND(AL120>=Анализ!$A$38,AL120<Анализ!$A$37),\"3\",IF(AND(AL120>=1,AL120<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL121>=Анализ!$A$36,\"5\",IF(AND(AL121>=Анализ!$A$37,AL121<Анализ!$A$36),\"4\",IF(AND(AL121>=Анализ!$A$38,AL121<Анализ!$A$37),\"3\",IF(AND(AL121>=1,AL121<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL122>=Анализ!$A$36,\"5\",IF(AND(AL122>=Анализ!$A$37,AL122<Анализ!$A$36),\"4\",IF(AND(AL122>=Анализ!$A$38,AL122<Анализ!$A$37),\"3\",IF(AND(AL122>=1,AL122<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL123>=Анализ!$A$36,\"5\",IF(AND(AL123>=Анализ!$A$37,AL123<Анализ!$A$36),\"4\",IF(AND(AL123>=Анализ!$A$38,AL123<Анализ!$A$37),\"3\",IF(AND(AL123>=1,AL123<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL124>=Анализ!$A$36,\"5\",IF(AND(AL124>=Анализ!$A$37,AL124<Анализ!$A$36),\"4\",IF(AND(AL124>=Анализ!$A$38,AL124<Анализ!$A$37),\"3\",IF(AND(AL124>=1,AL124<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL125>=Анализ!$A$36,\"5\",IF(AND(AL125>=Анализ!$A$37,AL125<Анализ!$A$36),\"4\",IF(AND(AL125>=Анализ!$A$38,AL125<Анализ!$A$37),\"3\",IF(AND(AL125>=1,AL125<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL126>=Анализ!$A$36,\"5\",IF(AND(AL126>=Анализ!$A$37,AL126<Анализ!$A$36),\"4\",IF(AND(AL126>=Анализ!$A$38,AL126<Анализ!$A$37),\"3\",IF(AND(AL126>=1,AL126<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL127>=Анализ!$A$36,\"5\",IF(AND(AL127>=Анализ!$A$37,AL127<Анализ!$A$36),\"4\",IF(AND(AL127>=Анализ!$A$38,AL127<Анализ!$A$37),\"3\",IF(AND(AL127>=1,AL127<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL128>=Анализ!$A$36,\"5\",IF(AND(AL128>=Анализ!$A$37,AL128<Анализ!$A$36),\"4\",IF(AND(AL128>=Анализ!$A$38,AL128<Анализ!$A$37),\"3\",IF(AND(AL128>=1,AL128<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL129>=Анализ!$A$36,\"5\",IF(AND(AL129>=Анализ!$A$37,AL129<Анализ!$A$36),\"4\",IF(AND(AL129>=Анализ!$A$38,AL129<Анализ!$A$37),\"3\",IF(AND(AL129>=1,AL129<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL130>=Анализ!$A$36,\"5\",IF(AND(AL130>=Анализ!$A$37,AL130<Анализ!$A$36),\"4\",IF(AND(AL130>=Анализ!$A$38,AL130<Анализ!$A$37),\"3\",IF(AND(AL130>=1,AL130<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL131>=Анализ!$A$36,\"5\",IF(AND(AL131>=Анализ!$A$37,AL131<Анализ!$A$36),\"4\",IF(AND(AL131>=Анализ!$A$38,AL131<Анализ!$A$37),\"3\",IF(AND(AL131>=1,AL131<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL132>=Анализ!$A$36,\"5\",IF(AND(AL132>=Анализ!$A$37,AL132<Анализ!$A$36),\"4\",IF(AND(AL132>=Анализ!$A$38,AL132<Анализ!$A$37),\"3\",IF(AND(AL132>=1,AL132<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL133>=Анализ!$A$36,\"5\",IF(AND(AL133>=Анализ!$A$37,AL133<Анализ!$A$36),\"4\",IF(AND(AL133>=Анализ!$A$38,AL133<Анализ!$A$37),\"3\",IF(AND(AL133>=1,AL133<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL134>=Анализ!$A$36,\"5\",IF(AND(AL134>=Анализ!$A$37,AL134<Анализ!$A$36),\"4\",IF(AND(AL134>=Анализ!$A$38,AL134<Анализ!$A$37),\"3\",IF(AND(AL134>=1,AL134<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL135>=Анализ!$A$36,\"5\",IF(AND(AL135>=Анализ!$A$37,AL135<Анализ!$A$36),\"4\",IF(AND(AL135>=Анализ!$A$38,AL135<Анализ!$A$37),\"3\",IF(AND(AL135>=1,AL135<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL136>=Анализ!$A$36,\"5\",IF(AND(AL136>=Анализ!$A$37,AL136<Анализ!$A$36),\"4\",IF(AND(AL136>=Анализ!$A$38,AL136<Анализ!$A$37),\"3\",IF(AND(AL136>=1,AL136<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL137>=Анализ!$A$36,\"5\",IF(AND(AL137>=Анализ!$A$37,AL137<Анализ!$A$36),\"4\",IF(AND(AL137>=Анализ!$A$38,AL137<Анализ!$A$37),\"3\",IF(AND(AL137>=1,AL137<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL138>=Анализ!$A$36,\"5\",IF(AND(AL138>=Анализ!$A$37,AL138<Анализ!$A$36),\"4\",IF(AND(AL138>=Анализ!$A$38,AL138<Анализ!$A$37),\"3\",IF(AND(AL138>=1,AL138<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL139>=Анализ!$A$36,\"5\",IF(AND(AL139>=Анализ!$A$37,AL139<Анализ!$A$36),\"4\",IF(AND(AL139>=Анализ!$A$38,AL139<Анализ!$A$37),\"3\",IF(AND(AL139>=1,AL139<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL140>=Анализ!$A$36,\"5\",IF(AND(AL140>=Анализ!$A$37,AL140<Анализ!$A$36),\"4\",IF(AND(AL140>=Анализ!$A$38,AL140<Анализ!$A$37),\"3\",IF(AND(AL140>=1,AL140<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL141>=Анализ!$A$36,\"5\",IF(AND(AL141>=Анализ!$A$37,AL141<Анализ!$A$36),\"4\",IF(AND(AL141>=Анализ!$A$38,AL141<Анализ!$A$37),\"3\",IF(AND(AL141>=1,AL141<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL142>=Анализ!$A$36,\"5\",IF(AND(AL142>=Анализ!$A$37,AL142<Анализ!$A$36),\"4\",IF(AND(AL142>=Анализ!$A$38,AL142<Анализ!$A$37),\"3\",IF(AND(AL142>=1,AL142<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL143>=Анализ!$A$36,\"5\",IF(AND(AL143>=Анализ!$A$37,AL143<Анализ!$A$36),\"4\",IF(AND(AL143>=Анализ!$A$38,AL143<Анализ!$A$37),\"3\",IF(AND(AL143>=1,AL143<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL144>=Анализ!$A$36,\"5\",IF(AND(AL144>=Анализ!$A$37,AL144<Анализ!$A$36),\"4\",IF(AND(AL144>=Анализ!$A$38,AL144<Анализ!$A$37),\"3\",IF(AND(AL144>=1,AL144<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL145>=Анализ!$A$36,\"5\",IF(AND(AL145>=Анализ!$A$37,AL145<Анализ!$A$36),\"4\",IF(AND(AL145>=Анализ!$A$38,AL145<Анализ!$A$37),\"3\",IF(AND(AL145>=1,AL145<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL146>=Анализ!$A$36,\"5\",IF(AND(AL146>=Анализ!$A$37,AL146<Анализ!$A$36),\"4\",IF(AND(AL146>=Анализ!$A$38,AL146<Анализ!$A$37),\"3\",IF(AND(AL146>=1,AL146<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL147>=Анализ!$A$36,\"5\",IF(AND(AL147>=Анализ!$A$37,AL147<Анализ!$A$36),\"4\",IF(AND(AL147>=Анализ!$A$38,AL147<Анализ!$A$37),\"3\",IF(AND(AL147>=1,AL147<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL148>=Анализ!$A$36,\"5\",IF(AND(AL148>=Анализ!$A$37,AL148<Анализ!$A$36),\"4\",IF(AND(AL148>=Анализ!$A$38,AL148<Анализ!$A$37),\"3\",IF(AND(AL148>=1,AL148<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL149>=Анализ!$A$36,\"5\",IF(AND(AL149>=Анализ!$A$37,AL149<Анализ!$A$36),\"4\",IF(AND(AL149>=Анализ!$A$38,AL149<Анализ!$A$37),\"3\",IF(AND(AL149>=1,AL149<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL150>=Анализ!$A$36,\"5\",IF(AND(AL150>=Анализ!$A$37,AL150<Анализ!$A$36),\"4\",IF(AND(AL150>=Анализ!$A$38,AL150<Анализ!$A$37),\"3\",IF(AND(AL150>=1,AL150<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL151>=Анализ!$A$36,\"5\",IF(AND(AL151>=Анализ!$A$37,AL151<Анализ!$A$36),\"4\",IF(AND(AL151>=Анализ!$A$38,AL151<Анализ!$A$37),\"3\",IF(AND(AL151>=1,AL151<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,{"$f":"SUM(E152:AK152)","v":0},{"$f":"SUMIF($E$20:$AK$20,\"Б\",$E152:$AK152)/SUMIF($E$20:$AK$20,\"Б\",$E$22:$AK$22)*100","v":0},{"$f":"SUMIF($E$20:$AK$20,\"П\",$E152:$AK152)/SUMIF($E$20:$AK$20,\"П\",$E$22:$AK$22)*100","v":0},{"$f":"IF(AL152>=Анализ!$A$36,\"5\",IF(AND(AL152>=Анализ!$A$37,AL152<Анализ!$A$36),\"4\",IF(AND(AL152>=Анализ!$A$38,AL152<Анализ!$A$37),\"3\",IF(AND(AL152>=1,AL152<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(AL153>=Анализ!$A$36,\"5\",IF(AND(AL153>=Анализ!$A$37,AL153<Анализ!$A$36),\"4\",IF(AND(AL153>=Анализ!$A$38,AL153<Анализ!$A$37),\"3\",IF(AND(AL153>=1,AL153<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},{"$f":"SUM(COUNTIF($E153,$E$22),COUNTIF($F153,$F$22),COUNTIF($G153,$G$22),COUNTIF($H153,$H$22),COUNTIF($I153,$I$22),COUNTIF($J153,$J$22),COUNTIF($K153,$K$22),COUNTIF($L153,$L$22),COUNTIF($M153,$M$22),COUNTIF($N153,$N$22),COUNTIF($O153,$O$22),COUNTIF($P153,$P$22),COUNTIF($Q153,$Q$22),COUNTIF($R153,$R$22),COUNTIF($S153,$S$22),COUNTIF($T153,$T$22),COUNTIF($U153,$U$22),COUNTIF($V153,$V$22),COUNTIF($W153,$W$22),COUNTIF($X153,$X$22),COUNTIF($Y153,$Y$22),COUNTIF($Z153,$Z$22),COUNTIF($AA153,$AA$22),COUNTIF($AB153,$AB$22),COUNTIF($AC153,$AC$22),COUNTIF($AD$22,$AD153),COUNTIF($AE$22,$AE153),COUNTIF($AF$22,$AF153),COUNTIF($AG$22,$AG153),COUNTIF($AH$22,$AH153),COUNTIF($AI$22,$AI153),COUNTIF($AJ$22,$AJ153),COUNTIF($AK$22,$AK153))*100/33","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,null,null,0,0,0,{"$f":"IF(AL154>=Анализ!$A$36,\"5\",IF(AND(AL154>=Анализ!$A$37,AL154<Анализ!$A$36),\"4\",IF(AND(AL154>=Анализ!$A$38,AL154<Анализ!$A$37),\"3\",IF(AND(AL154>=1,AL154<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL155>=Анализ!$A$36,\"5\",IF(AND(AL155>=Анализ!$A$37,AL155<Анализ!$A$36),\"4\",IF(AND(AL155>=Анализ!$A$38,AL155<Анализ!$A$37),\"3\",IF(AND(AL155>=1,AL155<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL156>=Анализ!$A$36,\"5\",IF(AND(AL156>=Анализ!$A$37,AL156<Анализ!$A$36),\"4\",IF(AND(AL156>=Анализ!$A$38,AL156<Анализ!$A$37),\"3\",IF(AND(AL156>=1,AL156<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL157>=Анализ!$A$36,\"5\",IF(AND(AL157>=Анализ!$A$37,AL157<Анализ!$A$36),\"4\",IF(AND(AL157>=Анализ!$A$38,AL157<Анализ!$A$37),\"3\",IF(AND(AL157>=1,AL157<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL158>=Анализ!$A$36,\"5\",IF(AND(AL158>=Анализ!$A$37,AL158<Анализ!$A$36),\"4\",IF(AND(AL158>=Анализ!$A$38,AL158<Анализ!$A$37),\"3\",IF(AND(AL158>=1,AL158<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL159>=Анализ!$A$36,\"5\",IF(AND(AL159>=Анализ!$A$37,AL159<Анализ!$A$36),\"4\",IF(AND(AL159>=Анализ!$A$38,AL159<Анализ!$A$37),\"3\",IF(AND(AL159>=1,AL159<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL160>=Анализ!$A$36,\"5\",IF(AND(AL160>=Анализ!$A$37,AL160<Анализ!$A$36),\"4\",IF(AND(AL160>=Анализ!$A$38,AL160<Анализ!$A$37),\"3\",IF(AND(AL160>=1,AL160<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL161>=Анализ!$A$36,\"5\",IF(AND(AL161>=Анализ!$A$37,AL161<Анализ!$A$36),\"4\",IF(AND(AL161>=Анализ!$A$38,AL161<Анализ!$A$37),\"3\",IF(AND(AL161>=1,AL161<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL162>=Анализ!$A$36,\"5\",IF(AND(AL162>=Анализ!$A$37,AL162<Анализ!$A$36),\"4\",IF(AND(AL162>=Анализ!$A$38,AL162<Анализ!$A$37),\"3\",IF(AND(AL162>=1,AL162<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL163>=Анализ!$A$36,\"5\",IF(AND(AL163>=Анализ!$A$37,AL163<Анализ!$A$36),\"4\",IF(AND(AL163>=Анализ!$A$38,AL163<Анализ!$A$37),\"3\",IF(AND(AL163>=1,AL163<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL164>=Анализ!$A$36,\"5\",IF(AND(AL164>=Анализ!$A$37,AL164<Анализ!$A$36),\"4\",IF(AND(AL164>=Анализ!$A$38,AL164<Анализ!$A$37),\"3\",IF(AND(AL164>=1,AL164<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL165>=Анализ!$A$36,\"5\",IF(AND(AL165>=Анализ!$A$37,AL165<Анализ!$A$36),\"4\",IF(AND(AL165>=Анализ!$A$38,AL165<Анализ!$A$37),\"3\",IF(AND(AL165>=1,AL165<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL166>=Анализ!$A$36,\"5\",IF(AND(AL166>=Анализ!$A$37,AL166<Анализ!$A$36),\"4\",IF(AND(AL166>=Анализ!$A$38,AL166<Анализ!$A$37),\"3\",IF(AND(AL166>=1,AL166<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL167>=Анализ!$A$36,\"5\",IF(AND(AL167>=Анализ!$A$37,AL167<Анализ!$A$36),\"4\",IF(AND(AL167>=Анализ!$A$38,AL167<Анализ!$A$37),\"3\",IF(AND(AL167>=1,AL167<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL168>=Анализ!$A$36,\"5\",IF(AND(AL168>=Анализ!$A$37,AL168<Анализ!$A$36),\"4\",IF(AND(AL168>=Анализ!$A$38,AL168<Анализ!$A$37),\"3\",IF(AND(AL168>=1,AL168<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL169>=Анализ!$A$36,\"5\",IF(AND(AL169>=Анализ!$A$37,AL169<Анализ!$A$36),\"4\",IF(AND(AL169>=Анализ!$A$38,AL169<Анализ!$A$37),\"3\",IF(AND(AL169>=1,AL169<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL170>=Анализ!$A$36,\"5\",IF(AND(AL170>=Анализ!$A$37,AL170<Анализ!$A$36),\"4\",IF(AND(AL170>=Анализ!$A$38,AL170<Анализ!$A$37),\"3\",IF(AND(AL170>=1,AL170<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL171>=Анализ!$A$36,\"5\",IF(AND(AL171>=Анализ!$A$37,AL171<Анализ!$A$36),\"4\",IF(AND(AL171>=Анализ!$A$38,AL171<Анализ!$A$37),\"3\",IF(AND(AL171>=1,AL171<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL172>=Анализ!$A$36,\"5\",IF(AND(AL172>=Анализ!$A$37,AL172<Анализ!$A$36),\"4\",IF(AND(AL172>=Анализ!$A$38,AL172<Анализ!$A$37),\"3\",IF(AND(AL172>=1,AL172<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},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,null,null,0,0,0,{"$f":"IF(AL173>=Анализ!$A$36,\"5\",IF(AND(AL173>=Анализ!$A$37,AL173<Анализ!$A$36),\"4\",IF(AND(AL173>=Анализ!$A$38,AL173<Анализ!$A$37),\"3\",IF(AND(AL173>=1,AL173<Анализ!$A$38),\"2\",\"-\"))))","v":"-"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Оценки","чел.","%"]
[null,null,"Приступили к решению",null,{"$f":"COUNT(E24:E173)","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,{"$f":"COUNT(AK24:AK173)","v":1},"Среднее значение",null,null,"\"5\" -",{"$f":"COUNTIF($AO$24:$AO$173,5)","v":0},{"$f":"AP175/$A$177","v":{"$error":"#DIV/0!"}}]
[null,null,"Не приступили к решению",null,{"$f":"$A$177-E175","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,{"$f":"$A$177-AK175","v":-1},null,null,null,"\"4\" -",{"$f":"COUNTIF($AO$24:$AO$173,4)","v":0},{"$f":"AP176/$A$177","v":{"$error":"#DIV/0!"}}]
[{"$f":"COUNTA(C24:C173)","v":0},null,"Решили верно и полностью",null,{"$f":"COUNTIF(E24:E173,E22)","v":1},0,0,1,1,1,1,0,0,1,1,1,1,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,{"$f":"COUNTIF(AK24:AK173,AK22)","v":0},null,null,null,"\"3\" -",{"$f":"COUNTIF($AO$24:$AO$173,3)","v":0},{"$error":"#DIV/0!"}]
[null,null,"Процент выполнения",null,{"$f":"(SUM(E24:E173)/$A$177)/E22","v":{"$error":"#DIV/0!"}},{"$f":"(SUM(F24:F173)/$A$177)/F22","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!"},{"$error":"#DIV/0!"},{"$f":"SUM(AL24:AL173)/COUNTIF(AL24:AL173,\">0\")","v":26},{"$f":"SUM(AM24:AM173)/COUNTIF(AM24:AM173,\">0\")","v":53.846153846153847},{"$f":"SUM(AN24:AN173)/COUNTIF(AN24:AN173,\">0\")","v":41.379310344827587},"\"2\" -",{"$f":"COUNTIF($AO$24:$AO$173,2)","v":1},{"$error":"#DIV/0!"}]

{"sheet":"Анализ","index":1,"n_rows":91,"n_cols":14,"rows_kept":91,"cut":false,"hidden":false,"merged":[[50,1,57,10],[49,1,49,10],[28,5,28,7],[29,5,29,7],[30,0,32,3],[28,0,29,3],[34,0,34,3],[16,0,16,4],[15,0,15,3],[21,0,21,3],[41,1,42,10],[43,1,48,10],[23,0,23,3],[23,5,23,7],[22,0,22,3],[17,0,18,3],[17,5,17,7],[19,0,20,3],[19,5,19,7],[17,4,18,4],[19,4,20,4],[9,0,9,2],[9,3,9,13],[90,0,90,2],[90,5,90,13],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[77,0,77,13],[79,0,88,13],[24,0,25,3],[26,0,27,3],[40,1,40,10],[11,0,11,13],[12,0,12,13],[15,5,15,7],[8,6,8,13],[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],[8,4,8,5],[73,1,73,10],[74,1,74,10],[75,1,75,10],[58,1,66,10],[67,1,72,10]]}
["Центр независимой оценки качества образования и образовательного аудита \"Легион\""]
["Аналитическая справка по результатам тестирования "]
["Организация",null,null,{"$f":"Результаты!E3","v":"Ленинская СОШ"}]
["Предмет",null,null,{"$f":"Результаты!E7","v":"Иностранный язык"}]
[{"$f":"Результаты!A5","v":"Класс"},null,null,{"$f":"Результаты!E5","v":9}]
["Дата",null,null,{"$f":"Результаты!E9","v":"2018-01-24T22:31:29"}]
["Максимальный балл",null,null,{"$f":"Результаты!E11","v":55}]
["Пороговый балл",null,null,{"$f":"Результаты!E13","v":29}]
["Зона риска",null,null,{"$f":"Результаты!E15","v":29},{"$f":"Результаты!H15","v":30}]
["Средний балл по работе",null,null,{"$f":"Результаты!E17","v":26}]
[]
["     С целью выявления уровня подготовки обучащихся в организации проведено репетиционное тестирование по вариантам, составленным специалистами издательства «Легион». "]
["     Содержание тестов строго соответствовало спецификации контрольных измерительных материалов, разработанной Федеральным институтом педагогических измерений (ФИПИ)."]
[]
[]
["Количество тестируемых",null,null,null,"чел.",{"$f":"Результаты!A177","v":0}]
["Уровни:",null,null,null,null,"Базовый","Повышенный","Высокий"]
["Всего заданий",null,null,null,"шт.",{"$f":"SUM(F19:H19)","v":33}]
[null,null,null,null,null,{"$f":"COUNTIF(Результаты!$E$20:$AK$20,\"Б\")","v":17},{"$f":"COUNTIF(Результаты!$E$20:$AK$20,\"П\")","v":16},{"$f":"COUNTIF(Результаты!$E$20:$AK$20,\"В\")","v":0}]
["Всего баллов",null,null,null,"балл",{"$f":"SUM(F21:H21)","v":55}]
[null,null,null,null,null,{"$f":"SUMIF(Результаты!$E$20:$AK$20,\"Б\",Результаты!$E$22:$AK$22)","v":26},{"$f":"SUMIF(Результаты!$E$20:$AK$20,\"П\",Результаты!$E$22:$AK$22)","v":29},{"$f":"SUMIF(Результаты!$E$20:$AK$20,\"В\",Результаты!$E$22:$AK$22)","v":0}]
["Средний балл по уровням",null,null,null,"балл",{"$f":"SUMIF(Результаты!$E$20:$AK$20,\"Б\",Результаты!$E$24:$AK$173)/Результаты!$A$177","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Результаты!$E$20:$AK$20,\"П\",Результаты!$E$24:$AK$173)/Результаты!$A$177","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Результаты!$E$20:$AK$20,\"В\",Результаты!$E$24:$AK$173)/Результаты!$A$177","v":{"$error":"#DIV/0!"}}]
["% выполнения работы по уровням",null,null,null,null,{"$f":"Результаты!AM178","v":53.846153846153847},{"$f":"Результаты!AN178","v":41.379310344827587},{"$f":"Результаты!#REF!","v":{"$error":"#REF!"}}]
["Средний тестовый балл по работе",null,null,null,"балл",{"$f":"Результаты!AL178","v":26}]
["Преодолели порог",null,null,null,"чел.",{"$f":"SUM(Результаты!AP175:AP177)","v":0}]
[null,null,null,null,"%",{"$f":"SUM(Результаты!AQ175:AQ177)","v":{"$error":"#DIV/0!"}}]
["Не преодолели порог",null,null,null,"чел.",{"$f":"Результаты!AP178","v":1}]
[null,null,null,null,"%",{"$f":"Результаты!AQ178","v":{"$error":"#DIV/0!"}}]
["Попали в группу риска (пороговый балл + 1)",null,null,null,"чел.",{"$f":"COUNTIF(Результаты!AL24:AL173,D9)+COUNTIF(Результаты!AL24:AL173,E9)","v":0}]
[null,null,null,null,"%",{"$f":"F29/F16","v":{"$error":"#DIV/0!"}}]
["Получили оценку",null,null,null,"балл","\"5\"","\"4\"","\"3\"","\"2\""]
[null,null,null,null,"чел.",{"$f":"Результаты!$AP$175","v":0},{"$f":"Результаты!$AP$176","v":0},{"$f":"Результаты!$AP$177","v":0},{"$f":"Результаты!$AP$178","v":1}]
[null,null,null,null,"%",{"$f":"Результаты!$AQ$175","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AQ$176","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AQ$177","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AQ$178","v":{"$error":"#DIV/0!"}}]
[]
["Перевод баллов в оценку"]
[49,"-",55,"5 баллов"]
[40,"-",48,"4 балла"]
[29,"-",39,"3 балла"]
[0,"-",28,"2 балла"]
[]
["номер","тема задания",null,null,null,null,null,null,null,null,null,"приступили","решили верно и полностью","%      верно решенных"]
[1,"Понимание основного содержания прослушанного текста",null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(Результаты!E175:AK175)","v":1},{"$f":"TRANSPOSE(Результаты!E177:AK177)","v":1},{"$f":"TRANSPOSE(Результаты!E178:AK178)","v":{"$error":"#DIV/0!"}}]
[2,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[3,"Понимание в прослушанном тексте запрашиваемой информации. 4 задания 1 уровня (на понимание эксплицитно представленной информации) и 2 задания 2 уровня (на извлечение имплицитно представленной информации). Задания могут быть представлены в произвольном порядке, но первым дается задание 1 уровня",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[4,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[5,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[6,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[7,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[8,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[9,"Понимание основного содержания прочитанного текста",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[10,"Понимание в прочитанном тексте запрашиваемой информации. Одно (первое) задание 1 уровня (на понимание эксплицитно представленной информации), 7 заданий 2 уровня (на извлечение имплицитно представленной информации)",null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[11,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[12,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[13,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[14,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[15,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[16,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[17,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[18,"Грамматические навыки употребления нужной морфологической формы данного слова в коммуникативно-значимом контексте 6 заданий 1 уровня и 3 задания 2 уровня в произвольном порядке (первым дается задание 1 уровня)",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[19,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[20,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[21,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[22,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[23,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[24,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[25,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[26,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[27,"Лексико-грамматические навыки образования и употребления родственного слова нужной части речи с использованием аффиксации в коммуникативно-значимом контексте. Четыре задания 1 уровня и два задания 2 уровня в произвольном порядке (первым дается задание 1 уровня)",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[28,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[29,null,null,null,null,null,null,null,null,null,null,1,1,{"$error":"#DIV/0!"}]
[30,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[31,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[32,null,null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[33,"Письмо личного характера в ответ на письмо-стимул",null,null,null,null,null,null,null,null,null,1,0,{"$error":"#DIV/0!"}]
[34,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[35,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Рекомендации эксперта:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Эксперт"]

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