{"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":183,"n_cols":42,"rows_kept":183,"cut":false,"hidden":false,"merged":[[180,40,181,42],[182,40,182,42],[18,40,22,40],[2,21,2,24],[4,12,6,17],[4,19,6,20],[10,12,12,17],[10,19,12,20],[2,11,2,13],[2,14,2,16],[18,39,19,39],[18,35,19,35],[174,35,176,38],[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],[185,14,185,15],[183,14,183,15],[18,36,18,38],[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],[18,0,19,2],[184,14,184,15],[10,4,10,9],[12,4,12,9],[21,0,21,3]]}
[]
[]
["Образовательная организация",null,null,null,"Ленинская ",null,null,null,null,null,null,"кол-во уч-ся",null,null,{"$f":"A177","v":0},null,null,"чел.",null,null,null,{"$f":"TODAY()","v":"2018-04-06"}]
[]
["Класс",null,null,null,9,null,null,null,null,null,null,null,"Средний балл ГИА-9 2017 года по г.Ростову-на-Дону",null,null,null,null,null,null,3.89]
[]
["Предмет",null,null,null,"Обществознание"]
[]
["Дата",null,null,null,"2018-01-12"]
[]
["Максимальный балл",null,null,null,{"$f":"AJ22","v":39},null,null,null,null,null,null,null,"Средний балл по ОУ",null,null,null,null,null,null,{"$f":"(AO175*5+AO176*4+AO177*3+AO178*2)/A177","v":{"$error":"#DIV/0!"}}]
[]
["Пороговый балл",null,null,null,15]
[]
["Зона риска",null,null,null,15,null,null,16]
[]
["Средний тестовый балл по выборке",null,null,null,{"$f":"AJ178","v":19.214285714285715}]
[]
["Уровни",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,"Тестовый балл","% выплнения заданий по уровням",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]
["Максимальный балл",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,1,1,1,2,2,2,3,2,2,{"$f":"SUM(E22:AI22)","v":39},{"$f":"SUMIF($E$20:$AI$20,\"Б\",$E$22:$AI$22)*100/$AJ22","v":46.153846153846153},{"$f":"SUMIF($E$20:$AI$20,\"П\",$E$22:$AI$22)*100/$AJ$22","v":41.025641025641029},{"$f":"SUMIF($E$20:$AI$20,\"В\",$E$22:$AI$22)*100/$AJ$22","v":12.820512820512821}]
[null,null,null,"вариант"]
[1,9,null,1,1,1,0,1,1,0,1,0,1,1,1,1,0,0,0,1,1,0,1,1,0,2,1,1,1,2,1,1,3,0,0,{"$f":"SUM(E24:AI24)","v":25},{"$f":"SUMIF($E$20:$AI$20,\"Б\",$E24:$AI24)/SUMIF($E$20:$AI$20,\"Б\",$E$22:$AI$22)*100","v":66.666666666666657},{"$f":"SUMIF($E$20:$AI$20,\"П\",$E24:$AI24)/SUMIF($E$20:$AI$20,\"П\",$E$22:$AI$22)*100","v":62.5},{"$f":"SUMIF($E$20:$AI$20,\"В\",$E24:$AI24)/SUMIF($E$20:$AI$20,\"В\",$E$22:$AI$22)*100","v":60},{"$f":"IF(AJ24>=Анализ!$A$36,\"5\",IF(AND(AJ24>=Анализ!$A$37,AJ24<Анализ!$A$36),\"4\",IF(AND(AJ24>=Анализ!$A$38,AJ24<Анализ!$A$37),\"3\",IF(AND(AJ24>=1,AJ24<Анализ!$A$38),\"2\",\"-\"))))","v":"4"},{"$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($Z24,$Z$22),COUNTIF($AA24,$AA$22),COUNTIF($AB24,$AB$22),COUNTIF($AC24,$AC$22),COUNTIF($AD24,$AD$22),COUNTIF($AE24,$AE$22),COUNTIF($AF24,$AF$22),COUNTIF($AG24,$AG$22),COUNTIF($AH24,$AH$22),COUNTIF($AI24,$AI$22))*100/31","v":74.193548387096769}]
[2,9,null,2,1,1,0,0,1,0,0,1,1,1,1,1,0,1,1,1,1,1,0,0,0,0,1,0,1,1,2,0,0,0,0,18,72.222222222222214,31.25,0,{"$f":"IF(AJ25>=Анализ!$A$36,\"5\",IF(AND(AJ25>=Анализ!$A$37,AJ25<Анализ!$A$36),\"4\",IF(AND(AJ25>=Анализ!$A$38,AJ25<Анализ!$A$37),\"3\",IF(AND(AJ25>=1,AJ25<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},{"$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($Z25,$Z$22),COUNTIF($AA25,$AA$22),COUNTIF($AB25,$AB$22),COUNTIF($AC25,$AC$22),COUNTIF($AD25,$AD$22),COUNTIF($AE25,$AE$22),COUNTIF($AF25,$AF$22),COUNTIF($AG25,$AG$22),COUNTIF($AH25,$AH$22),COUNTIF($AI25,$AI$22))*100/31","v":58.064516129032256}]
[3,9,null,2,1,1,0,0,1,0,0,0,1,1,1,1,0,0,0,1,1,1,1,1,0,0,1,0,1,0,1,0,0,0,0,15,55.555555555555557,31.25,0,{"$f":"IF(AJ26>=Анализ!$A$36,\"5\",IF(AND(AJ26>=Анализ!$A$37,AJ26<Анализ!$A$36),\"4\",IF(AND(AJ26>=Анализ!$A$38,AJ26<Анализ!$A$37),\"3\",IF(AND(AJ26>=1,AJ26<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},51.612903225806448]
[4,9,null,2,1,1,0,0,1,0,0,1,1,0,1,0,1,1,0,0,0,0,1,0,0,0,1,1,1,0,0,1,3,0,0,16,44.444444444444443,31.25,60,{"$f":"IF(AJ27>=Анализ!$A$36,\"5\",IF(AND(AJ27>=Анализ!$A$37,AJ27<Анализ!$A$36),\"4\",IF(AND(AJ27>=Анализ!$A$38,AJ27<Анализ!$A$37),\"3\",IF(AND(AJ27>=1,AJ27<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},51.612903225806448]
[5,9,null,2,1,1,0,0,1,0,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,0,1,0,1,0,1,0,2,0,0,11,38.888888888888893,12.5,40,{"$f":"IF(AJ28>=Анализ!$A$36,\"5\",IF(AND(AJ28>=Анализ!$A$37,AJ28<Анализ!$A$36),\"4\",IF(AND(AJ28>=Анализ!$A$38,AJ28<Анализ!$A$37),\"3\",IF(AND(AJ28>=1,AJ28<Анализ!$A$38),\"2\",\"-\"))))","v":"2"},32.258064516129032]
[6,9,null,1,1,1,1,0,1,0,0,0,1,1,1,0,0,1,1,1,0,0,1,1,1,1,0,0,1,2,1,2,2,0,0,22,61.111111111111114,56.25,40,{"$f":"IF(AJ29>=Анализ!$A$36,\"5\",IF(AND(AJ29>=Анализ!$A$37,AJ29<Анализ!$A$36),\"4\",IF(AND(AJ29>=Анализ!$A$38,AJ29<Анализ!$A$37),\"3\",IF(AND(AJ29>=1,AJ29<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},54.838709677419352]
[7,9,null,2,1,1,1,0,1,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,1,0,1,0,1,1,0,1,0,21,77.777777777777786,43.75,0,{"$f":"IF(AJ30>=Анализ!$A$36,\"5\",IF(AND(AJ30>=Анализ!$A$37,AJ30<Анализ!$A$36),\"4\",IF(AND(AJ30>=Анализ!$A$38,AJ30<Анализ!$A$37),\"3\",IF(AND(AJ30>=1,AJ30<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},64.516129032258064]
[8,9,null,1,1,1,1,1,1,0,1,0,1,0,1,1,1,1,1,0,1,0,1,0,0,2,0,0,1,2,2,0,3,0,0,24,88.888888888888886,31.25,60,{"$f":"IF(AJ31>=Анализ!$A$36,\"5\",IF(AND(AJ31>=Анализ!$A$37,AJ31<Анализ!$A$36),\"4\",IF(AND(AJ31>=Анализ!$A$38,AJ31<Анализ!$A$37),\"3\",IF(AND(AJ31>=1,AJ31<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},67.741935483870961]
[9,9,null,2,1,1,0,0,1,0,0,0,1,0,1,1,0,1,1,1,1,1,1,0,0,0,1,0,1,1,1,1,3,0,0,20,66.666666666666657,31.25,60,{"$f":"IF(AJ32>=Анализ!$A$36,\"5\",IF(AND(AJ32>=Анализ!$A$37,AJ32<Анализ!$A$36),\"4\",IF(AND(AJ32>=Анализ!$A$38,AJ32<Анализ!$A$37),\"3\",IF(AND(AJ32>=1,AJ32<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},54.838709677419352]
[10,9,null,1,1,1,1,0,0,1,1,1,1,0,1,1,1,1,1,1,1,0,1,1,0,2,0,1,1,2,1,0,0,0,0,23,83.333333333333343,50,0,{"$f":"IF(AJ33>=Анализ!$A$36,\"5\",IF(AND(AJ33>=Анализ!$A$37,AJ33<Анализ!$A$36),\"4\",IF(AND(AJ33>=Анализ!$A$38,AJ33<Анализ!$A$37),\"3\",IF(AND(AJ33>=1,AJ33<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},74.193548387096769]
[11,9,null,1,1,1,1,0,1,1,1,0,1,0,1,0,0,1,1,0,1,0,1,1,1,2,0,1,0,2,1,0,2,0,0,22,77.777777777777786,37.5,40,{"$f":"IF(AJ34>=Анализ!$A$36,\"5\",IF(AND(AJ34>=Анализ!$A$37,AJ34<Анализ!$A$36),\"4\",IF(AND(AJ34>=Анализ!$A$38,AJ34<Анализ!$A$37),\"3\",IF(AND(AJ34>=1,AJ34<Анализ!$A$38),\"2\",\"-\"))))","v":"3"},61.29032258064516]
[12,9,null,1,1,1,0,1,1,0,1,0,1,1,1,1,0,1,1,1,1,0,1,1,1,1,1,1,1,2,2,2,3,1,0,30,77.777777777777786,81.25,60,{"$f":"IF(AJ35>=Анализ!$A$36,\"5\",IF(AND(AJ35>=Анализ!$A$37,AJ35<Анализ!$A$36),\"4\",IF(AND(AJ35>=Анализ!$A$38,AJ35<Анализ!$A$37),\"3\",IF(AND(AJ35>=1,AJ35<Анализ!$A$38),\"2\",\"-\"))))","v":"4"},83.870967741935488]
[13,9,null,1,1,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,1,1,0,0,0,0,0,1,2,1,0,0,0,0,10,33.333333333333329,25,0,{"$f":"IF(AJ36>=Анализ!$A$36,\"5\",IF(AND(AJ36>=Анализ!$A$37,AJ36<Анализ!$A$36),\"4\",IF(AND(AJ36>=Анализ!$A$38,AJ36<Анализ!$A$37),\"3\",IF(AND(AJ36>=1,AJ36<Анализ!$A$38),\"2\",\"-\"))))","v":"2"},29.032258064516128]
[14,9,null,2,1,1,1,0,1,0,0,0,1,0,1,1,0,1,0,0,1,0,0,0,0,0,1,0,1,0,1,0,0,0,0,12,55.555555555555557,12.5,0,{"$f":"IF(AJ37>=Анализ!$A$36,\"5\",IF(AND(AJ37>=Анализ!$A$37,AJ37<Анализ!$A$36),\"4\",IF(AND(AJ37>=Анализ!$A$38,AJ37<Анализ!$A$37),\"3\",IF(AND(AJ37>=1,AJ37<Анализ!$A$38),\"2\",\"-\"))))","v":"2"},41.935483870967744]
[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":"IF(AJ38>=Анализ!$A$36,\"5\",IF(AND(AJ38>=Анализ!$A$37,AJ38<Анализ!$A$36),\"4\",IF(AND(AJ38>=Анализ!$A$38,AJ38<Анализ!$A$37),\"3\",IF(AND(AJ38>=1,AJ38<Анализ!$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,0,0,0,0,{"$f":"IF(AJ39>=Анализ!$A$36,\"5\",IF(AND(AJ39>=Анализ!$A$37,AJ39<Анализ!$A$36),\"4\",IF(AND(AJ39>=Анализ!$A$38,AJ39<Анализ!$A$37),\"3\",IF(AND(AJ39>=1,AJ39<Анализ!$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,0,0,0,0,{"$f":"IF(AJ40>=Анализ!$A$36,\"5\",IF(AND(AJ40>=Анализ!$A$37,AJ40<Анализ!$A$36),\"4\",IF(AND(AJ40>=Анализ!$A$38,AJ40<Анализ!$A$37),\"3\",IF(AND(AJ40>=1,AJ40<Анализ!$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,0,0,0,0,{"$f":"IF(AJ41>=Анализ!$A$36,\"5\",IF(AND(AJ41>=Анализ!$A$37,AJ41<Анализ!$A$36),\"4\",IF(AND(AJ41>=Анализ!$A$38,AJ41<Анализ!$A$37),\"3\",IF(AND(AJ41>=1,AJ41<Анализ!$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,0,0,0,0,{"$f":"IF(AJ42>=Анализ!$A$36,\"5\",IF(AND(AJ42>=Анализ!$A$37,AJ42<Анализ!$A$36),\"4\",IF(AND(AJ42>=Анализ!$A$38,AJ42<Анализ!$A$37),\"3\",IF(AND(AJ42>=1,AJ42<Анализ!$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,0,0,0,0,{"$f":"IF(AJ43>=Анализ!$A$36,\"5\",IF(AND(AJ43>=Анализ!$A$37,AJ43<Анализ!$A$36),\"4\",IF(AND(AJ43>=Анализ!$A$38,AJ43<Анализ!$A$37),\"3\",IF(AND(AJ43>=1,AJ43<Анализ!$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,0,0,0,0,{"$f":"IF(AJ44>=Анализ!$A$36,\"5\",IF(AND(AJ44>=Анализ!$A$37,AJ44<Анализ!$A$36),\"4\",IF(AND(AJ44>=Анализ!$A$38,AJ44<Анализ!$A$37),\"3\",IF(AND(AJ44>=1,AJ44<Анализ!$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,0,0,0,0,{"$f":"IF(AJ45>=Анализ!$A$36,\"5\",IF(AND(AJ45>=Анализ!$A$37,AJ45<Анализ!$A$36),\"4\",IF(AND(AJ45>=Анализ!$A$38,AJ45<Анализ!$A$37),\"3\",IF(AND(AJ45>=1,AJ45<Анализ!$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,0,0,0,0,{"$f":"IF(AJ46>=Анализ!$A$36,\"5\",IF(AND(AJ46>=Анализ!$A$37,AJ46<Анализ!$A$36),\"4\",IF(AND(AJ46>=Анализ!$A$38,AJ46<Анализ!$A$37),\"3\",IF(AND(AJ46>=1,AJ46<Анализ!$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,0,0,0,0,{"$f":"IF(AJ47>=Анализ!$A$36,\"5\",IF(AND(AJ47>=Анализ!$A$37,AJ47<Анализ!$A$36),\"4\",IF(AND(AJ47>=Анализ!$A$38,AJ47<Анализ!$A$37),\"3\",IF(AND(AJ47>=1,AJ47<Анализ!$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,0,0,0,0,{"$f":"IF(AJ48>=Анализ!$A$36,\"5\",IF(AND(AJ48>=Анализ!$A$37,AJ48<Анализ!$A$36),\"4\",IF(AND(AJ48>=Анализ!$A$38,AJ48<Анализ!$A$37),\"3\",IF(AND(AJ48>=1,AJ48<Анализ!$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,0,0,0,0,{"$f":"IF(AJ49>=Анализ!$A$36,\"5\",IF(AND(AJ49>=Анализ!$A$37,AJ49<Анализ!$A$36),\"4\",IF(AND(AJ49>=Анализ!$A$38,AJ49<Анализ!$A$37),\"3\",IF(AND(AJ49>=1,AJ49<Анализ!$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,0,0,0,0,{"$f":"IF(AJ50>=Анализ!$A$36,\"5\",IF(AND(AJ50>=Анализ!$A$37,AJ50<Анализ!$A$36),\"4\",IF(AND(AJ50>=Анализ!$A$38,AJ50<Анализ!$A$37),\"3\",IF(AND(AJ50>=1,AJ50<Анализ!$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,0,0,0,0,{"$f":"IF(AJ51>=Анализ!$A$36,\"5\",IF(AND(AJ51>=Анализ!$A$37,AJ51<Анализ!$A$36),\"4\",IF(AND(AJ51>=Анализ!$A$38,AJ51<Анализ!$A$37),\"3\",IF(AND(AJ51>=1,AJ51<Анализ!$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,0,0,0,0,{"$f":"IF(AJ52>=Анализ!$A$36,\"5\",IF(AND(AJ52>=Анализ!$A$37,AJ52<Анализ!$A$36),\"4\",IF(AND(AJ52>=Анализ!$A$38,AJ52<Анализ!$A$37),\"3\",IF(AND(AJ52>=1,AJ52<Анализ!$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,0,0,0,0,{"$f":"IF(AJ53>=Анализ!$A$36,\"5\",IF(AND(AJ53>=Анализ!$A$37,AJ53<Анализ!$A$36),\"4\",IF(AND(AJ53>=Анализ!$A$38,AJ53<Анализ!$A$37),\"3\",IF(AND(AJ53>=1,AJ53<Анализ!$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,0,0,0,0,{"$f":"IF(AJ54>=Анализ!$A$36,\"5\",IF(AND(AJ54>=Анализ!$A$37,AJ54<Анализ!$A$36),\"4\",IF(AND(AJ54>=Анализ!$A$38,AJ54<Анализ!$A$37),\"3\",IF(AND(AJ54>=1,AJ54<Анализ!$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,0,0,0,0,{"$f":"IF(AJ55>=Анализ!$A$36,\"5\",IF(AND(AJ55>=Анализ!$A$37,AJ55<Анализ!$A$36),\"4\",IF(AND(AJ55>=Анализ!$A$38,AJ55<Анализ!$A$37),\"3\",IF(AND(AJ55>=1,AJ55<Анализ!$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,{"$f":"SUM(E56:AI56)","v":0},{"$f":"SUMIF($E$20:$AI$20,\"Б\",$E56:$AI56)/SUMIF($E$20:$AI$20,\"Б\",$E$22:$AI$22)*100","v":0},{"$f":"SUMIF($E$20:$AI$20,\"П\",$E56:$AI56)/SUMIF($E$20:$AI$20,\"П\",$E$22:$AI$22)*100","v":0},{"$f":"SUMIF($E$20:$AI$20,\"В\",$E56:$AI56)/SUMIF($E$20:$AI$20,\"В\",$E$22:$AI$22)*100","v":0},{"$f":"IF(AJ56>=Анализ!$A$36,\"5\",IF(AND(AJ56>=Анализ!$A$37,AJ56<Анализ!$A$36),\"4\",IF(AND(AJ56>=Анализ!$A$38,AJ56<Анализ!$A$37),\"3\",IF(AND(AJ56>=1,AJ56<Анализ!$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,0,0,0,0,{"$f":"IF(AJ57>=Анализ!$A$36,\"5\",IF(AND(AJ57>=Анализ!$A$37,AJ57<Анализ!$A$36),\"4\",IF(AND(AJ57>=Анализ!$A$38,AJ57<Анализ!$A$37),\"3\",IF(AND(AJ57>=1,AJ57<Анализ!$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,0,0,0,0,{"$f":"IF(AJ58>=Анализ!$A$36,\"5\",IF(AND(AJ58>=Анализ!$A$37,AJ58<Анализ!$A$36),\"4\",IF(AND(AJ58>=Анализ!$A$38,AJ58<Анализ!$A$37),\"3\",IF(AND(AJ58>=1,AJ58<Анализ!$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,0,0,0,0,{"$f":"IF(AJ59>=Анализ!$A$36,\"5\",IF(AND(AJ59>=Анализ!$A$37,AJ59<Анализ!$A$36),\"4\",IF(AND(AJ59>=Анализ!$A$38,AJ59<Анализ!$A$37),\"3\",IF(AND(AJ59>=1,AJ59<Анализ!$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,0,0,0,0,{"$f":"IF(AJ60>=Анализ!$A$36,\"5\",IF(AND(AJ60>=Анализ!$A$37,AJ60<Анализ!$A$36),\"4\",IF(AND(AJ60>=Анализ!$A$38,AJ60<Анализ!$A$37),\"3\",IF(AND(AJ60>=1,AJ60<Анализ!$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,0,0,0,0,{"$f":"IF(AJ61>=Анализ!$A$36,\"5\",IF(AND(AJ61>=Анализ!$A$37,AJ61<Анализ!$A$36),\"4\",IF(AND(AJ61>=Анализ!$A$38,AJ61<Анализ!$A$37),\"3\",IF(AND(AJ61>=1,AJ61<Анализ!$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,0,0,0,0,{"$f":"IF(AJ62>=Анализ!$A$36,\"5\",IF(AND(AJ62>=Анализ!$A$37,AJ62<Анализ!$A$36),\"4\",IF(AND(AJ62>=Анализ!$A$38,AJ62<Анализ!$A$37),\"3\",IF(AND(AJ62>=1,AJ62<Анализ!$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,0,0,0,0,{"$f":"IF(AJ63>=Анализ!$A$36,\"5\",IF(AND(AJ63>=Анализ!$A$37,AJ63<Анализ!$A$36),\"4\",IF(AND(AJ63>=Анализ!$A$38,AJ63<Анализ!$A$37),\"3\",IF(AND(AJ63>=1,AJ63<Анализ!$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,0,0,0,0,{"$f":"IF(AJ64>=Анализ!$A$36,\"5\",IF(AND(AJ64>=Анализ!$A$37,AJ64<Анализ!$A$36),\"4\",IF(AND(AJ64>=Анализ!$A$38,AJ64<Анализ!$A$37),\"3\",IF(AND(AJ64>=1,AJ64<Анализ!$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,0,0,0,0,{"$f":"IF(AJ65>=Анализ!$A$36,\"5\",IF(AND(AJ65>=Анализ!$A$37,AJ65<Анализ!$A$36),\"4\",IF(AND(AJ65>=Анализ!$A$38,AJ65<Анализ!$A$37),\"3\",IF(AND(AJ65>=1,AJ65<Анализ!$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,0,0,0,0,{"$f":"IF(AJ66>=Анализ!$A$36,\"5\",IF(AND(AJ66>=Анализ!$A$37,AJ66<Анализ!$A$36),\"4\",IF(AND(AJ66>=Анализ!$A$38,AJ66<Анализ!$A$37),\"3\",IF(AND(AJ66>=1,AJ66<Анализ!$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,0,0,0,0,{"$f":"IF(AJ67>=Анализ!$A$36,\"5\",IF(AND(AJ67>=Анализ!$A$37,AJ67<Анализ!$A$36),\"4\",IF(AND(AJ67>=Анализ!$A$38,AJ67<Анализ!$A$37),\"3\",IF(AND(AJ67>=1,AJ67<Анализ!$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,0,0,0,0,{"$f":"IF(AJ68>=Анализ!$A$36,\"5\",IF(AND(AJ68>=Анализ!$A$37,AJ68<Анализ!$A$36),\"4\",IF(AND(AJ68>=Анализ!$A$38,AJ68<Анализ!$A$37),\"3\",IF(AND(AJ68>=1,AJ68<Анализ!$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,0,0,0,0,{"$f":"IF(AJ69>=Анализ!$A$36,\"5\",IF(AND(AJ69>=Анализ!$A$37,AJ69<Анализ!$A$36),\"4\",IF(AND(AJ69>=Анализ!$A$38,AJ69<Анализ!$A$37),\"3\",IF(AND(AJ69>=1,AJ69<Анализ!$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,0,0,0,0,{"$f":"IF(AJ70>=Анализ!$A$36,\"5\",IF(AND(AJ70>=Анализ!$A$37,AJ70<Анализ!$A$36),\"4\",IF(AND(AJ70>=Анализ!$A$38,AJ70<Анализ!$A$37),\"3\",IF(AND(AJ70>=1,AJ70<Анализ!$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,0,0,0,0,{"$f":"IF(AJ71>=Анализ!$A$36,\"5\",IF(AND(AJ71>=Анализ!$A$37,AJ71<Анализ!$A$36),\"4\",IF(AND(AJ71>=Анализ!$A$38,AJ71<Анализ!$A$37),\"3\",IF(AND(AJ71>=1,AJ71<Анализ!$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,0,0,0,0,{"$f":"IF(AJ72>=Анализ!$A$36,\"5\",IF(AND(AJ72>=Анализ!$A$37,AJ72<Анализ!$A$36),\"4\",IF(AND(AJ72>=Анализ!$A$38,AJ72<Анализ!$A$37),\"3\",IF(AND(AJ72>=1,AJ72<Анализ!$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,0,0,0,0,{"$f":"IF(AJ73>=Анализ!$A$36,\"5\",IF(AND(AJ73>=Анализ!$A$37,AJ73<Анализ!$A$36),\"4\",IF(AND(AJ73>=Анализ!$A$38,AJ73<Анализ!$A$37),\"3\",IF(AND(AJ73>=1,AJ73<Анализ!$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,0,0,0,0,{"$f":"IF(AJ74>=Анализ!$A$36,\"5\",IF(AND(AJ74>=Анализ!$A$37,AJ74<Анализ!$A$36),\"4\",IF(AND(AJ74>=Анализ!$A$38,AJ74<Анализ!$A$37),\"3\",IF(AND(AJ74>=1,AJ74<Анализ!$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,0,0,0,0,{"$f":"IF(AJ75>=Анализ!$A$36,\"5\",IF(AND(AJ75>=Анализ!$A$37,AJ75<Анализ!$A$36),\"4\",IF(AND(AJ75>=Анализ!$A$38,AJ75<Анализ!$A$37),\"3\",IF(AND(AJ75>=1,AJ75<Анализ!$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,0,0,0,0,{"$f":"IF(AJ76>=Анализ!$A$36,\"5\",IF(AND(AJ76>=Анализ!$A$37,AJ76<Анализ!$A$36),\"4\",IF(AND(AJ76>=Анализ!$A$38,AJ76<Анализ!$A$37),\"3\",IF(AND(AJ76>=1,AJ76<Анализ!$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,0,0,0,0,{"$f":"IF(AJ77>=Анализ!$A$36,\"5\",IF(AND(AJ77>=Анализ!$A$37,AJ77<Анализ!$A$36),\"4\",IF(AND(AJ77>=Анализ!$A$38,AJ77<Анализ!$A$37),\"3\",IF(AND(AJ77>=1,AJ77<Анализ!$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,0,0,0,0,{"$f":"IF(AJ78>=Анализ!$A$36,\"5\",IF(AND(AJ78>=Анализ!$A$37,AJ78<Анализ!$A$36),\"4\",IF(AND(AJ78>=Анализ!$A$38,AJ78<Анализ!$A$37),\"3\",IF(AND(AJ78>=1,AJ78<Анализ!$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,0,0,0,0,{"$f":"IF(AJ79>=Анализ!$A$36,\"5\",IF(AND(AJ79>=Анализ!$A$37,AJ79<Анализ!$A$36),\"4\",IF(AND(AJ79>=Анализ!$A$38,AJ79<Анализ!$A$37),\"3\",IF(AND(AJ79>=1,AJ79<Анализ!$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,0,0,0,0,{"$f":"IF(AJ80>=Анализ!$A$36,\"5\",IF(AND(AJ80>=Анализ!$A$37,AJ80<Анализ!$A$36),\"4\",IF(AND(AJ80>=Анализ!$A$38,AJ80<Анализ!$A$37),\"3\",IF(AND(AJ80>=1,AJ80<Анализ!$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,0,0,0,0,{"$f":"IF(AJ81>=Анализ!$A$36,\"5\",IF(AND(AJ81>=Анализ!$A$37,AJ81<Анализ!$A$36),\"4\",IF(AND(AJ81>=Анализ!$A$38,AJ81<Анализ!$A$37),\"3\",IF(AND(AJ81>=1,AJ81<Анализ!$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,0,0,0,0,{"$f":"IF(AJ82>=Анализ!$A$36,\"5\",IF(AND(AJ82>=Анализ!$A$37,AJ82<Анализ!$A$36),\"4\",IF(AND(AJ82>=Анализ!$A$38,AJ82<Анализ!$A$37),\"3\",IF(AND(AJ82>=1,AJ82<Анализ!$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,0,0,0,0,{"$f":"IF(AJ83>=Анализ!$A$36,\"5\",IF(AND(AJ83>=Анализ!$A$37,AJ83<Анализ!$A$36),\"4\",IF(AND(AJ83>=Анализ!$A$38,AJ83<Анализ!$A$37),\"3\",IF(AND(AJ83>=1,AJ83<Анализ!$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,0,0,0,0,{"$f":"IF(AJ84>=Анализ!$A$36,\"5\",IF(AND(AJ84>=Анализ!$A$37,AJ84<Анализ!$A$36),\"4\",IF(AND(AJ84>=Анализ!$A$38,AJ84<Анализ!$A$37),\"3\",IF(AND(AJ84>=1,AJ84<Анализ!$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,0,0,0,0,{"$f":"IF(AJ85>=Анализ!$A$36,\"5\",IF(AND(AJ85>=Анализ!$A$37,AJ85<Анализ!$A$36),\"4\",IF(AND(AJ85>=Анализ!$A$38,AJ85<Анализ!$A$37),\"3\",IF(AND(AJ85>=1,AJ85<Анализ!$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,0,0,0,0,{"$f":"IF(AJ86>=Анализ!$A$36,\"5\",IF(AND(AJ86>=Анализ!$A$37,AJ86<Анализ!$A$36),\"4\",IF(AND(AJ86>=Анализ!$A$38,AJ86<Анализ!$A$37),\"3\",IF(AND(AJ86>=1,AJ86<Анализ!$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,0,0,0,0,{"$f":"IF(AJ87>=Анализ!$A$36,\"5\",IF(AND(AJ87>=Анализ!$A$37,AJ87<Анализ!$A$36),\"4\",IF(AND(AJ87>=Анализ!$A$38,AJ87<Анализ!$A$37),\"3\",IF(AND(AJ87>=1,AJ87<Анализ!$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,{"$f":"SUM(E88:AI88)","v":0},{"$f":"SUMIF($E$20:$AI$20,\"Б\",$E88:$AI88)/SUMIF($E$20:$AI$20,\"Б\",$E$22:$AI$22)*100","v":0},{"$f":"SUMIF($E$20:$AI$20,\"П\",$E88:$AI88)/SUMIF($E$20:$AI$20,\"П\",$E$22:$AI$22)*100","v":0},{"$f":"SUMIF($E$20:$AI$20,\"В\",$E88:$AI88)/SUMIF($E$20:$AI$20,\"В\",$E$22:$AI$22)*100","v":0},{"$f":"IF(AJ88>=Анализ!$A$36,\"5\",IF(AND(AJ88>=Анализ!$A$37,AJ88<Анализ!$A$36),\"4\",IF(AND(AJ88>=Анализ!$A$38,AJ88<Анализ!$A$37),\"3\",IF(AND(AJ88>=1,AJ88<Анализ!$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,0,0,0,0,{"$f":"IF(AJ89>=Анализ!$A$36,\"5\",IF(AND(AJ89>=Анализ!$A$37,AJ89<Анализ!$A$36),\"4\",IF(AND(AJ89>=Анализ!$A$38,AJ89<Анализ!$A$37),\"3\",IF(AND(AJ89>=1,AJ89<Анализ!$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($Z89,$Z$22),COUNTIF($AA89,$AA$22),COUNTIF($AB89,$AB$22),COUNTIF($AC89,$AC$22),COUNTIF($AD89,$AD$22),COUNTIF($AE89,$AE$22),COUNTIF($AF89,$AF$22),COUNTIF($AG89,$AG$22),COUNTIF($AH89,$AH$22),COUNTIF($AI89,$AI$22))*100/31","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":"IF(AJ90>=Анализ!$A$36,\"5\",IF(AND(AJ90>=Анализ!$A$37,AJ90<Анализ!$A$36),\"4\",IF(AND(AJ90>=Анализ!$A$38,AJ90<Анализ!$A$37),\"3\",IF(AND(AJ90>=1,AJ90<Анализ!$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,0,0,0,0,{"$f":"IF(AJ91>=Анализ!$A$36,\"5\",IF(AND(AJ91>=Анализ!$A$37,AJ91<Анализ!$A$36),\"4\",IF(AND(AJ91>=Анализ!$A$38,AJ91<Анализ!$A$37),\"3\",IF(AND(AJ91>=1,AJ91<Анализ!$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,0,0,0,0,{"$f":"IF(AJ92>=Анализ!$A$36,\"5\",IF(AND(AJ92>=Анализ!$A$37,AJ92<Анализ!$A$36),\"4\",IF(AND(AJ92>=Анализ!$A$38,AJ92<Анализ!$A$37),\"3\",IF(AND(AJ92>=1,AJ92<Анализ!$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,0,0,0,0,{"$f":"IF(AJ93>=Анализ!$A$36,\"5\",IF(AND(AJ93>=Анализ!$A$37,AJ93<Анализ!$A$36),\"4\",IF(AND(AJ93>=Анализ!$A$38,AJ93<Анализ!$A$37),\"3\",IF(AND(AJ93>=1,AJ93<Анализ!$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,0,0,0,0,{"$f":"IF(AJ94>=Анализ!$A$36,\"5\",IF(AND(AJ94>=Анализ!$A$37,AJ94<Анализ!$A$36),\"4\",IF(AND(AJ94>=Анализ!$A$38,AJ94<Анализ!$A$37),\"3\",IF(AND(AJ94>=1,AJ94<Анализ!$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,0,0,0,0,{"$f":"IF(AJ95>=Анализ!$A$36,\"5\",IF(AND(AJ95>=Анализ!$A$37,AJ95<Анализ!$A$36),\"4\",IF(AND(AJ95>=Анализ!$A$38,AJ95<Анализ!$A$37),\"3\",IF(AND(AJ95>=1,AJ95<Анализ!$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,0,0,0,0,{"$f":"IF(AJ96>=Анализ!$A$36,\"5\",IF(AND(AJ96>=Анализ!$A$37,AJ96<Анализ!$A$36),\"4\",IF(AND(AJ96>=Анализ!$A$38,AJ96<Анализ!$A$37),\"3\",IF(AND(AJ96>=1,AJ96<Анализ!$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,0,0,0,0,{"$f":"IF(AJ97>=Анализ!$A$36,\"5\",IF(AND(AJ97>=Анализ!$A$37,AJ97<Анализ!$A$36),\"4\",IF(AND(AJ97>=Анализ!$A$38,AJ97<Анализ!$A$37),\"3\",IF(AND(AJ97>=1,AJ97<Анализ!$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,0,0,0,0,{"$f":"IF(AJ98>=Анализ!$A$36,\"5\",IF(AND(AJ98>=Анализ!$A$37,AJ98<Анализ!$A$36),\"4\",IF(AND(AJ98>=Анализ!$A$38,AJ98<Анализ!$A$37),\"3\",IF(AND(AJ98>=1,AJ98<Анализ!$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,0,0,0,0,{"$f":"IF(AJ99>=Анализ!$A$36,\"5\",IF(AND(AJ99>=Анализ!$A$37,AJ99<Анализ!$A$36),\"4\",IF(AND(AJ99>=Анализ!$A$38,AJ99<Анализ!$A$37),\"3\",IF(AND(AJ99>=1,AJ99<Анализ!$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,0,0,0,0,{"$f":"IF(AJ100>=Анализ!$A$36,\"5\",IF(AND(AJ100>=Анализ!$A$37,AJ100<Анализ!$A$36),\"4\",IF(AND(AJ100>=Анализ!$A$38,AJ100<Анализ!$A$37),\"3\",IF(AND(AJ100>=1,AJ100<Анализ!$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,0,0,0,0,{"$f":"IF(AJ101>=Анализ!$A$36,\"5\",IF(AND(AJ101>=Анализ!$A$37,AJ101<Анализ!$A$36),\"4\",IF(AND(AJ101>=Анализ!$A$38,AJ101<Анализ!$A$37),\"3\",IF(AND(AJ101>=1,AJ101<Анализ!$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,0,0,0,0,{"$f":"IF(AJ102>=Анализ!$A$36,\"5\",IF(AND(AJ102>=Анализ!$A$37,AJ102<Анализ!$A$36),\"4\",IF(AND(AJ102>=Анализ!$A$38,AJ102<Анализ!$A$37),\"3\",IF(AND(AJ102>=1,AJ102<Анализ!$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,0,0,0,0,{"$f":"IF(AJ103>=Анализ!$A$36,\"5\",IF(AND(AJ103>=Анализ!$A$37,AJ103<Анализ!$A$36),\"4\",IF(AND(AJ103>=Анализ!$A$38,AJ103<Анализ!$A$37),\"3\",IF(AND(AJ103>=1,AJ103<Анализ!$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,0,0,0,0,{"$f":"IF(AJ104>=Анализ!$A$36,\"5\",IF(AND(AJ104>=Анализ!$A$37,AJ104<Анализ!$A$36),\"4\",IF(AND(AJ104>=Анализ!$A$38,AJ104<Анализ!$A$37),\"3\",IF(AND(AJ104>=1,AJ104<Анализ!$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,0,0,0,0,{"$f":"IF(AJ105>=Анализ!$A$36,\"5\",IF(AND(AJ105>=Анализ!$A$37,AJ105<Анализ!$A$36),\"4\",IF(AND(AJ105>=Анализ!$A$38,AJ105<Анализ!$A$37),\"3\",IF(AND(AJ105>=1,AJ105<Анализ!$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,0,0,0,0,{"$f":"IF(AJ106>=Анализ!$A$36,\"5\",IF(AND(AJ106>=Анализ!$A$37,AJ106<Анализ!$A$36),\"4\",IF(AND(AJ106>=Анализ!$A$38,AJ106<Анализ!$A$37),\"3\",IF(AND(AJ106>=1,AJ106<Анализ!$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,0,0,0,0,{"$f":"IF(AJ107>=Анализ!$A$36,\"5\",IF(AND(AJ107>=Анализ!$A$37,AJ107<Анализ!$A$36),\"4\",IF(AND(AJ107>=Анализ!$A$38,AJ107<Анализ!$A$37),\"3\",IF(AND(AJ107>=1,AJ107<Анализ!$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,0,0,0,0,{"$f":"IF(AJ108>=Анализ!$A$36,\"5\",IF(AND(AJ108>=Анализ!$A$37,AJ108<Анализ!$A$36),\"4\",IF(AND(AJ108>=Анализ!$A$38,AJ108<Анализ!$A$37),\"3\",IF(AND(AJ108>=1,AJ108<Анализ!$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,0,0,0,0,{"$f":"IF(AJ109>=Анализ!$A$36,\"5\",IF(AND(AJ109>=Анализ!$A$37,AJ109<Анализ!$A$36),\"4\",IF(AND(AJ109>=Анализ!$A$38,AJ109<Анализ!$A$37),\"3\",IF(AND(AJ109>=1,AJ109<Анализ!$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,0,0,0,0,{"$f":"IF(AJ110>=Анализ!$A$36,\"5\",IF(AND(AJ110>=Анализ!$A$37,AJ110<Анализ!$A$36),\"4\",IF(AND(AJ110>=Анализ!$A$38,AJ110<Анализ!$A$37),\"3\",IF(AND(AJ110>=1,AJ110<Анализ!$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,0,0,0,0,{"$f":"IF(AJ111>=Анализ!$A$36,\"5\",IF(AND(AJ111>=Анализ!$A$37,AJ111<Анализ!$A$36),\"4\",IF(AND(AJ111>=Анализ!$A$38,AJ111<Анализ!$A$37),\"3\",IF(AND(AJ111>=1,AJ111<Анализ!$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,0,0,0,0,{"$f":"IF(AJ112>=Анализ!$A$36,\"5\",IF(AND(AJ112>=Анализ!$A$37,AJ112<Анализ!$A$36),\"4\",IF(AND(AJ112>=Анализ!$A$38,AJ112<Анализ!$A$37),\"3\",IF(AND(AJ112>=1,AJ112<Анализ!$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,0,0,0,0,{"$f":"IF(AJ113>=Анализ!$A$36,\"5\",IF(AND(AJ113>=Анализ!$A$37,AJ113<Анализ!$A$36),\"4\",IF(AND(AJ113>=Анализ!$A$38,AJ113<Анализ!$A$37),\"3\",IF(AND(AJ113>=1,AJ113<Анализ!$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,0,0,0,0,{"$f":"IF(AJ114>=Анализ!$A$36,\"5\",IF(AND(AJ114>=Анализ!$A$37,AJ114<Анализ!$A$36),\"4\",IF(AND(AJ114>=Анализ!$A$38,AJ114<Анализ!$A$37),\"3\",IF(AND(AJ114>=1,AJ114<Анализ!$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,0,0,0,0,{"$f":"IF(AJ115>=Анализ!$A$36,\"5\",IF(AND(AJ115>=Анализ!$A$37,AJ115<Анализ!$A$36),\"4\",IF(AND(AJ115>=Анализ!$A$38,AJ115<Анализ!$A$37),\"3\",IF(AND(AJ115>=1,AJ115<Анализ!$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,0,0,0,0,{"$f":"IF(AJ116>=Анализ!$A$36,\"5\",IF(AND(AJ116>=Анализ!$A$37,AJ116<Анализ!$A$36),\"4\",IF(AND(AJ116>=Анализ!$A$38,AJ116<Анализ!$A$37),\"3\",IF(AND(AJ116>=1,AJ116<Анализ!$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,0,0,0,0,{"$f":"IF(AJ117>=Анализ!$A$36,\"5\",IF(AND(AJ117>=Анализ!$A$37,AJ117<Анализ!$A$36),\"4\",IF(AND(AJ117>=Анализ!$A$38,AJ117<Анализ!$A$37),\"3\",IF(AND(AJ117>=1,AJ117<Анализ!$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,0,0,0,0,{"$f":"IF(AJ118>=Анализ!$A$36,\"5\",IF(AND(AJ118>=Анализ!$A$37,AJ118<Анализ!$A$36),\"4\",IF(AND(AJ118>=Анализ!$A$38,AJ118<Анализ!$A$37),\"3\",IF(AND(AJ118>=1,AJ118<Анализ!$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,0,0,0,0,{"$f":"IF(AJ119>=Анализ!$A$36,\"5\",IF(AND(AJ119>=Анализ!$A$37,AJ119<Анализ!$A$36),\"4\",IF(AND(AJ119>=Анализ!$A$38,AJ119<Анализ!$A$37),\"3\",IF(AND(AJ119>=1,AJ119<Анализ!$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,{"$f":"SUM(E120:AI120)","v":0},{"$f":"SUMIF($E$20:$AI$20,\"Б\",$E120:$AI120)/SUMIF($E$20:$AI$20,\"Б\",$E$22:$AI$22)*100","v":0},{"$f":"SUMIF($E$20:$AI$20,\"П\",$E120:$AI120)/SUMIF($E$20:$AI$20,\"П\",$E$22:$AI$22)*100","v":0},{"$f":"SUMIF($E$20:$AI$20,\"В\",$E120:$AI120)/SUMIF($E$20:$AI$20,\"В\",$E$22:$AI$22)*100","v":0},{"$f":"IF(AJ120>=Анализ!$A$36,\"5\",IF(AND(AJ120>=Анализ!$A$37,AJ120<Анализ!$A$36),\"4\",IF(AND(AJ120>=Анализ!$A$38,AJ120<Анализ!$A$37),\"3\",IF(AND(AJ120>=1,AJ120<Анализ!$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,0,0,0,0,{"$f":"IF(AJ121>=Анализ!$A$36,\"5\",IF(AND(AJ121>=Анализ!$A$37,AJ121<Анализ!$A$36),\"4\",IF(AND(AJ121>=Анализ!$A$38,AJ121<Анализ!$A$37),\"3\",IF(AND(AJ121>=1,AJ121<Анализ!$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,0,0,0,0,{"$f":"IF(AJ122>=Анализ!$A$36,\"5\",IF(AND(AJ122>=Анализ!$A$37,AJ122<Анализ!$A$36),\"4\",IF(AND(AJ122>=Анализ!$A$38,AJ122<Анализ!$A$37),\"3\",IF(AND(AJ122>=1,AJ122<Анализ!$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,0,0,0,0,{"$f":"IF(AJ123>=Анализ!$A$36,\"5\",IF(AND(AJ123>=Анализ!$A$37,AJ123<Анализ!$A$36),\"4\",IF(AND(AJ123>=Анализ!$A$38,AJ123<Анализ!$A$37),\"3\",IF(AND(AJ123>=1,AJ123<Анализ!$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,0,0,0,0,{"$f":"IF(AJ124>=Анализ!$A$36,\"5\",IF(AND(AJ124>=Анализ!$A$37,AJ124<Анализ!$A$36),\"4\",IF(AND(AJ124>=Анализ!$A$38,AJ124<Анализ!$A$37),\"3\",IF(AND(AJ124>=1,AJ124<Анализ!$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,0,0,0,0,{"$f":"IF(AJ125>=Анализ!$A$36,\"5\",IF(AND(AJ125>=Анализ!$A$37,AJ125<Анализ!$A$36),\"4\",IF(AND(AJ125>=Анализ!$A$38,AJ125<Анализ!$A$37),\"3\",IF(AND(AJ125>=1,AJ125<Анализ!$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,0,0,0,0,{"$f":"IF(AJ126>=Анализ!$A$36,\"5\",IF(AND(AJ126>=Анализ!$A$37,AJ126<Анализ!$A$36),\"4\",IF(AND(AJ126>=Анализ!$A$38,AJ126<Анализ!$A$37),\"3\",IF(AND(AJ126>=1,AJ126<Анализ!$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,0,0,0,0,{"$f":"IF(AJ127>=Анализ!$A$36,\"5\",IF(AND(AJ127>=Анализ!$A$37,AJ127<Анализ!$A$36),\"4\",IF(AND(AJ127>=Анализ!$A$38,AJ127<Анализ!$A$37),\"3\",IF(AND(AJ127>=1,AJ127<Анализ!$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,0,0,0,0,{"$f":"IF(AJ128>=Анализ!$A$36,\"5\",IF(AND(AJ128>=Анализ!$A$37,AJ128<Анализ!$A$36),\"4\",IF(AND(AJ128>=Анализ!$A$38,AJ128<Анализ!$A$37),\"3\",IF(AND(AJ128>=1,AJ128<Анализ!$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,0,0,0,0,{"$f":"IF(AJ129>=Анализ!$A$36,\"5\",IF(AND(AJ129>=Анализ!$A$37,AJ129<Анализ!$A$36),\"4\",IF(AND(AJ129>=Анализ!$A$38,AJ129<Анализ!$A$37),\"3\",IF(AND(AJ129>=1,AJ129<Анализ!$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,0,0,0,0,{"$f":"IF(AJ130>=Анализ!$A$36,\"5\",IF(AND(AJ130>=Анализ!$A$37,AJ130<Анализ!$A$36),\"4\",IF(AND(AJ130>=Анализ!$A$38,AJ130<Анализ!$A$37),\"3\",IF(AND(AJ130>=1,AJ130<Анализ!$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,0,0,0,0,{"$f":"IF(AJ131>=Анализ!$A$36,\"5\",IF(AND(AJ131>=Анализ!$A$37,AJ131<Анализ!$A$36),\"4\",IF(AND(AJ131>=Анализ!$A$38,AJ131<Анализ!$A$37),\"3\",IF(AND(AJ131>=1,AJ131<Анализ!$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,0,0,0,0,{"$f":"IF(AJ132>=Анализ!$A$36,\"5\",IF(AND(AJ132>=Анализ!$A$37,AJ132<Анализ!$A$36),\"4\",IF(AND(AJ132>=Анализ!$A$38,AJ132<Анализ!$A$37),\"3\",IF(AND(AJ132>=1,AJ132<Анализ!$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,0,0,0,0,{"$f":"IF(AJ133>=Анализ!$A$36,\"5\",IF(AND(AJ133>=Анализ!$A$37,AJ133<Анализ!$A$36),\"4\",IF(AND(AJ133>=Анализ!$A$38,AJ133<Анализ!$A$37),\"3\",IF(AND(AJ133>=1,AJ133<Анализ!$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,0,0,0,0,{"$f":"IF(AJ134>=Анализ!$A$36,\"5\",IF(AND(AJ134>=Анализ!$A$37,AJ134<Анализ!$A$36),\"4\",IF(AND(AJ134>=Анализ!$A$38,AJ134<Анализ!$A$37),\"3\",IF(AND(AJ134>=1,AJ134<Анализ!$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,0,0,0,0,{"$f":"IF(AJ135>=Анализ!$A$36,\"5\",IF(AND(AJ135>=Анализ!$A$37,AJ135<Анализ!$A$36),\"4\",IF(AND(AJ135>=Анализ!$A$38,AJ135<Анализ!$A$37),\"3\",IF(AND(AJ135>=1,AJ135<Анализ!$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,0,0,0,0,{"$f":"IF(AJ136>=Анализ!$A$36,\"5\",IF(AND(AJ136>=Анализ!$A$37,AJ136<Анализ!$A$36),\"4\",IF(AND(AJ136>=Анализ!$A$38,AJ136<Анализ!$A$37),\"3\",IF(AND(AJ136>=1,AJ136<Анализ!$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,0,0,0,0,{"$f":"IF(AJ137>=Анализ!$A$36,\"5\",IF(AND(AJ137>=Анализ!$A$37,AJ137<Анализ!$A$36),\"4\",IF(AND(AJ137>=Анализ!$A$38,AJ137<Анализ!$A$37),\"3\",IF(AND(AJ137>=1,AJ137<Анализ!$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,0,0,0,0,{"$f":"IF(AJ138>=Анализ!$A$36,\"5\",IF(AND(AJ138>=Анализ!$A$37,AJ138<Анализ!$A$36),\"4\",IF(AND(AJ138>=Анализ!$A$38,AJ138<Анализ!$A$37),\"3\",IF(AND(AJ138>=1,AJ138<Анализ!$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,0,0,0,0,{"$f":"IF(AJ139>=Анализ!$A$36,\"5\",IF(AND(AJ139>=Анализ!$A$37,AJ139<Анализ!$A$36),\"4\",IF(AND(AJ139>=Анализ!$A$38,AJ139<Анализ!$A$37),\"3\",IF(AND(AJ139>=1,AJ139<Анализ!$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,0,0,0,0,{"$f":"IF(AJ140>=Анализ!$A$36,\"5\",IF(AND(AJ140>=Анализ!$A$37,AJ140<Анализ!$A$36),\"4\",IF(AND(AJ140>=Анализ!$A$38,AJ140<Анализ!$A$37),\"3\",IF(AND(AJ140>=1,AJ140<Анализ!$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,0,0,0,0,{"$f":"IF(AJ141>=Анализ!$A$36,\"5\",IF(AND(AJ141>=Анализ!$A$37,AJ141<Анализ!$A$36),\"4\",IF(AND(AJ141>=Анализ!$A$38,AJ141<Анализ!$A$37),\"3\",IF(AND(AJ141>=1,AJ141<Анализ!$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,0,0,0,0,{"$f":"IF(AJ142>=Анализ!$A$36,\"5\",IF(AND(AJ142>=Анализ!$A$37,AJ142<Анализ!$A$36),\"4\",IF(AND(AJ142>=Анализ!$A$38,AJ142<Анализ!$A$37),\"3\",IF(AND(AJ142>=1,AJ142<Анализ!$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,0,0,0,0,{"$f":"IF(AJ143>=Анализ!$A$36,\"5\",IF(AND(AJ143>=Анализ!$A$37,AJ143<Анализ!$A$36),\"4\",IF(AND(AJ143>=Анализ!$A$38,AJ143<Анализ!$A$37),\"3\",IF(AND(AJ143>=1,AJ143<Анализ!$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,0,0,0,0,{"$f":"IF(AJ144>=Анализ!$A$36,\"5\",IF(AND(AJ144>=Анализ!$A$37,AJ144<Анализ!$A$36),\"4\",IF(AND(AJ144>=Анализ!$A$38,AJ144<Анализ!$A$37),\"3\",IF(AND(AJ144>=1,AJ144<Анализ!$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,0,0,0,0,{"$f":"IF(AJ145>=Анализ!$A$36,\"5\",IF(AND(AJ145>=Анализ!$A$37,AJ145<Анализ!$A$36),\"4\",IF(AND(AJ145>=Анализ!$A$38,AJ145<Анализ!$A$37),\"3\",IF(AND(AJ145>=1,AJ145<Анализ!$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,0,0,0,0,{"$f":"IF(AJ146>=Анализ!$A$36,\"5\",IF(AND(AJ146>=Анализ!$A$37,AJ146<Анализ!$A$36),\"4\",IF(AND(AJ146>=Анализ!$A$38,AJ146<Анализ!$A$37),\"3\",IF(AND(AJ146>=1,AJ146<Анализ!$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,0,0,0,0,{"$f":"IF(AJ147>=Анализ!$A$36,\"5\",IF(AND(AJ147>=Анализ!$A$37,AJ147<Анализ!$A$36),\"4\",IF(AND(AJ147>=Анализ!$A$38,AJ147<Анализ!$A$37),\"3\",IF(AND(AJ147>=1,AJ147<Анализ!$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,0,0,0,0,{"$f":"IF(AJ148>=Анализ!$A$36,\"5\",IF(AND(AJ148>=Анализ!$A$37,AJ148<Анализ!$A$36),\"4\",IF(AND(AJ148>=Анализ!$A$38,AJ148<Анализ!$A$37),\"3\",IF(AND(AJ148>=1,AJ148<Анализ!$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,0,0,0,0,{"$f":"IF(AJ149>=Анализ!$A$36,\"5\",IF(AND(AJ149>=Анализ!$A$37,AJ149<Анализ!$A$36),\"4\",IF(AND(AJ149>=Анализ!$A$38,AJ149<Анализ!$A$37),\"3\",IF(AND(AJ149>=1,AJ149<Анализ!$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,0,0,0,0,{"$f":"IF(AJ150>=Анализ!$A$36,\"5\",IF(AND(AJ150>=Анализ!$A$37,AJ150<Анализ!$A$36),\"4\",IF(AND(AJ150>=Анализ!$A$38,AJ150<Анализ!$A$37),\"3\",IF(AND(AJ150>=1,AJ150<Анализ!$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,0,0,0,0,{"$f":"IF(AJ151>=Анализ!$A$36,\"5\",IF(AND(AJ151>=Анализ!$A$37,AJ151<Анализ!$A$36),\"4\",IF(AND(AJ151>=Анализ!$A$38,AJ151<Анализ!$A$37),\"3\",IF(AND(AJ151>=1,AJ151<Анализ!$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,{"$f":"SUM(E152:AI152)","v":0},{"$f":"SUMIF($E$20:$AI$20,\"Б\",$E152:$AI152)/SUMIF($E$20:$AI$20,\"Б\",$E$22:$AI$22)*100","v":0},{"$f":"SUMIF($E$20:$AI$20,\"П\",$E152:$AI152)/SUMIF($E$20:$AI$20,\"П\",$E$22:$AI$22)*100","v":0},{"$f":"SUMIF($E$20:$AI$20,\"В\",$E152:$AI152)/SUMIF($E$20:$AI$20,\"В\",$E$22:$AI$22)*100","v":0},{"$f":"IF(AJ152>=Анализ!$A$36,\"5\",IF(AND(AJ152>=Анализ!$A$37,AJ152<Анализ!$A$36),\"4\",IF(AND(AJ152>=Анализ!$A$38,AJ152<Анализ!$A$37),\"3\",IF(AND(AJ152>=1,AJ152<Анализ!$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,0,0,0,0,{"$f":"IF(AJ153>=Анализ!$A$36,\"5\",IF(AND(AJ153>=Анализ!$A$37,AJ153<Анализ!$A$36),\"4\",IF(AND(AJ153>=Анализ!$A$38,AJ153<Анализ!$A$37),\"3\",IF(AND(AJ153>=1,AJ153<Анализ!$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($Z153,$Z$22),COUNTIF($AA153,$AA$22),COUNTIF($AB153,$AB$22),COUNTIF($AC153,$AC$22),COUNTIF($AD153,$AD$22),COUNTIF($AE153,$AE$22),COUNTIF($AF153,$AF$22),COUNTIF($AG153,$AG$22),COUNTIF($AH153,$AH$22),COUNTIF($AI153,$AI$22))*100/31","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":"IF(AJ154>=Анализ!$A$36,\"5\",IF(AND(AJ154>=Анализ!$A$37,AJ154<Анализ!$A$36),\"4\",IF(AND(AJ154>=Анализ!$A$38,AJ154<Анализ!$A$37),\"3\",IF(AND(AJ154>=1,AJ154<Анализ!$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,0,0,0,0,{"$f":"IF(AJ155>=Анализ!$A$36,\"5\",IF(AND(AJ155>=Анализ!$A$37,AJ155<Анализ!$A$36),\"4\",IF(AND(AJ155>=Анализ!$A$38,AJ155<Анализ!$A$37),\"3\",IF(AND(AJ155>=1,AJ155<Анализ!$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,0,0,0,0,{"$f":"IF(AJ156>=Анализ!$A$36,\"5\",IF(AND(AJ156>=Анализ!$A$37,AJ156<Анализ!$A$36),\"4\",IF(AND(AJ156>=Анализ!$A$38,AJ156<Анализ!$A$37),\"3\",IF(AND(AJ156>=1,AJ156<Анализ!$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,0,0,0,0,{"$f":"IF(AJ157>=Анализ!$A$36,\"5\",IF(AND(AJ157>=Анализ!$A$37,AJ157<Анализ!$A$36),\"4\",IF(AND(AJ157>=Анализ!$A$38,AJ157<Анализ!$A$37),\"3\",IF(AND(AJ157>=1,AJ157<Анализ!$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,0,0,0,0,{"$f":"IF(AJ158>=Анализ!$A$36,\"5\",IF(AND(AJ158>=Анализ!$A$37,AJ158<Анализ!$A$36),\"4\",IF(AND(AJ158>=Анализ!$A$38,AJ158<Анализ!$A$37),\"3\",IF(AND(AJ158>=1,AJ158<Анализ!$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,0,0,0,0,{"$f":"IF(AJ159>=Анализ!$A$36,\"5\",IF(AND(AJ159>=Анализ!$A$37,AJ159<Анализ!$A$36),\"4\",IF(AND(AJ159>=Анализ!$A$38,AJ159<Анализ!$A$37),\"3\",IF(AND(AJ159>=1,AJ159<Анализ!$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,0,0,0,0,{"$f":"IF(AJ160>=Анализ!$A$36,\"5\",IF(AND(AJ160>=Анализ!$A$37,AJ160<Анализ!$A$36),\"4\",IF(AND(AJ160>=Анализ!$A$38,AJ160<Анализ!$A$37),\"3\",IF(AND(AJ160>=1,AJ160<Анализ!$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,0,0,0,0,{"$f":"IF(AJ161>=Анализ!$A$36,\"5\",IF(AND(AJ161>=Анализ!$A$37,AJ161<Анализ!$A$36),\"4\",IF(AND(AJ161>=Анализ!$A$38,AJ161<Анализ!$A$37),\"3\",IF(AND(AJ161>=1,AJ161<Анализ!$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,0,0,0,0,{"$f":"IF(AJ162>=Анализ!$A$36,\"5\",IF(AND(AJ162>=Анализ!$A$37,AJ162<Анализ!$A$36),\"4\",IF(AND(AJ162>=Анализ!$A$38,AJ162<Анализ!$A$37),\"3\",IF(AND(AJ162>=1,AJ162<Анализ!$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,0,0,0,0,{"$f":"IF(AJ163>=Анализ!$A$36,\"5\",IF(AND(AJ163>=Анализ!$A$37,AJ163<Анализ!$A$36),\"4\",IF(AND(AJ163>=Анализ!$A$38,AJ163<Анализ!$A$37),\"3\",IF(AND(AJ163>=1,AJ163<Анализ!$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,0,0,0,0,{"$f":"IF(AJ164>=Анализ!$A$36,\"5\",IF(AND(AJ164>=Анализ!$A$37,AJ164<Анализ!$A$36),\"4\",IF(AND(AJ164>=Анализ!$A$38,AJ164<Анализ!$A$37),\"3\",IF(AND(AJ164>=1,AJ164<Анализ!$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,0,0,0,0,{"$f":"IF(AJ165>=Анализ!$A$36,\"5\",IF(AND(AJ165>=Анализ!$A$37,AJ165<Анализ!$A$36),\"4\",IF(AND(AJ165>=Анализ!$A$38,AJ165<Анализ!$A$37),\"3\",IF(AND(AJ165>=1,AJ165<Анализ!$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,0,0,0,0,{"$f":"IF(AJ166>=Анализ!$A$36,\"5\",IF(AND(AJ166>=Анализ!$A$37,AJ166<Анализ!$A$36),\"4\",IF(AND(AJ166>=Анализ!$A$38,AJ166<Анализ!$A$37),\"3\",IF(AND(AJ166>=1,AJ166<Анализ!$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,0,0,0,0,{"$f":"IF(AJ167>=Анализ!$A$36,\"5\",IF(AND(AJ167>=Анализ!$A$37,AJ167<Анализ!$A$36),\"4\",IF(AND(AJ167>=Анализ!$A$38,AJ167<Анализ!$A$37),\"3\",IF(AND(AJ167>=1,AJ167<Анализ!$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,0,0,0,0,{"$f":"IF(AJ168>=Анализ!$A$36,\"5\",IF(AND(AJ168>=Анализ!$A$37,AJ168<Анализ!$A$36),\"4\",IF(AND(AJ168>=Анализ!$A$38,AJ168<Анализ!$A$37),\"3\",IF(AND(AJ168>=1,AJ168<Анализ!$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,0,0,0,0,{"$f":"IF(AJ169>=Анализ!$A$36,\"5\",IF(AND(AJ169>=Анализ!$A$37,AJ169<Анализ!$A$36),\"4\",IF(AND(AJ169>=Анализ!$A$38,AJ169<Анализ!$A$37),\"3\",IF(AND(AJ169>=1,AJ169<Анализ!$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,0,0,0,0,{"$f":"IF(AJ170>=Анализ!$A$36,\"5\",IF(AND(AJ170>=Анализ!$A$37,AJ170<Анализ!$A$36),\"4\",IF(AND(AJ170>=Анализ!$A$38,AJ170<Анализ!$A$37),\"3\",IF(AND(AJ170>=1,AJ170<Анализ!$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,0,0,0,0,{"$f":"IF(AJ171>=Анализ!$A$36,\"5\",IF(AND(AJ171>=Анализ!$A$37,AJ171<Анализ!$A$36),\"4\",IF(AND(AJ171>=Анализ!$A$38,AJ171<Анализ!$A$37),\"3\",IF(AND(AJ171>=1,AJ171<Анализ!$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,0,0,0,0,{"$f":"IF(AJ172>=Анализ!$A$36,\"5\",IF(AND(AJ172>=Анализ!$A$37,AJ172<Анализ!$A$36),\"4\",IF(AND(AJ172>=Анализ!$A$38,AJ172<Анализ!$A$37),\"3\",IF(AND(AJ172>=1,AJ172<Анализ!$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,0,0,0,0,{"$f":"IF(AJ173>=Анализ!$A$36,\"5\",IF(AND(AJ173>=Анализ!$A$37,AJ173<Анализ!$A$36),\"4\",IF(AND(AJ173>=Анализ!$A$38,AJ173<Анализ!$A$37),\"3\",IF(AND(AJ173>=1,AJ173<Анализ!$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,{"$f":"COUNT(E24:E173)","v":14},14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,"Среднее значение",null,null,null,"\"5\" -",{"$f":"COUNTIF($AN$24:$AN$173,5)","v":0},{"$f":"AO175/$A$177","v":{"$error":"#DIV/0!"}}]
[null,null,"Не приступили к решению",null,{"$f":"$A$177-E175","v":-14},-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,-14,null,null,null,null,"\"4\" -",{"$f":"COUNTIF($AN$24:$AN$173,4)","v":2},{"$f":"AO176/$A$177","v":{"$error":"#DIV/0!"}}]
[{"$f":"COUNTA(C24:C173)","v":0},null,"Решили верно и полностью",null,{"$f":"COUNTIF(E24:E173,E22)","v":14},13,6,3,13,2,6,4,13,7,13,9,4,11,9,8,10,5,10,6,3,4,9,5,13,7,3,2,5,0,0,null,null,null,null,"\"3\" -",{"$f":"COUNTIF($AN$24:$AN$173,3)","v":9},{"$error":"#DIV/0!"}]
[null,null,"Процент выполнения",null,{"$f":"E177/$A$177","v":{"$error":"#DIV/0!"}},{"$f":"F177/$A$177","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!"},{"$f":"SUM(AJ24:AJ173)/COUNTIF(AJ24:AJ173,\">0\")","v":19.214285714285715},{"$f":"SUM(AK24:AK173)/COUNTIF(AK24:AK173,\">0\")","v":64.285714285714292},{"$f":"SUM(AL24:AL173)/COUNTIF(AL24:AL173,\">0\")","v":38.392857142857146},{"$f":"SUM(AM24:AM173)/COUNTIF(AM24:AM173,\">0\")","v":52.5},"\"2\" -",{"$f":"COUNTIF($AN$24:$AN$173,2)","v":3},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Средний балл по ОУ"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"(AO175*5+AO176*4+AO177*3+AO178*2)/A177","v":{"$error":"#DIV/0!"}}]

{"sheet":"Анализ","index":1,"n_rows":91,"n_cols":14,"rows_kept":91,"cut":false,"hidden":false,"merged":[[63,1,63,10],[64,1,64,10],[65,1,65,10],[58,1,58,10],[59,1,59,10],[60,1,60,10],[61,1,61,10],[62,1,62,10],[53,1,53,10],[54,1,54,10],[55,1,55,10],[56,1,56,10],[57,1,57,10],[30,0,32,3],[28,0,29,3],[34,0,34,3],[66,1,71,10],[41,1,41,10],[42,1,42,10],[43,1,43,10],[44,1,44,10],[45,1,45,10],[46,1,46,10],[47,1,47,10],[48,1,48,10],[49,1,49,10],[50,1,50,10],[51,1,51,10],[52,1,52,10],[16,0,16,4],[15,0,15,3],[21,0,21,3],[28,5,28,7],[29,5,29,7],[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]]}
["Центр независимой оценки качества образования и образовательного аудита \"Легион\""]
["Аналитическая справка по результатам тестирования "]
["Организация",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-12"}]
["Максимальный балл",null,null,{"$f":"Результаты!E11","v":39}]
["Пороговый балл",null,null,{"$f":"Результаты!E13","v":15}]
["Зона риска",null,null,{"$f":"Результаты!E15","v":15},{"$f":"Результаты!H15","v":16}]
["Средний балл по работе",null,null,{"$f":"Результаты!E17","v":19.214285714285715}]
[]
["     С целью выявления уровня подготовки обучащихся в организации проведено репетиционное тестирование по вариантам, составленным специалистами издательства «Легион». "]
["     Содержание тестов строго соответствовало спецификации контрольных измерительных материалов, разработанной Федеральным институтом педагогических измерений (ФИПИ)."]
[]
[]
["Количество тестируемых",null,null,null,"чел.",{"$f":"Результаты!A177","v":0}]
["Уровни:",null,null,null,null,"Базовый","Повышенный","Высокий"]
["Всего заданий",null,null,null,"шт.",{"$f":"SUM(F19:H19)","v":31}]
[null,null,null,null,null,{"$f":"COUNTIF(Результаты!$E$20:$AI$20,\"Б\")","v":16},{"$f":"COUNTIF(Результаты!$E$20:$AI$20,\"П\")","v":13},{"$f":"COUNTIF(Результаты!$E$20:$AI$20,\"В\")","v":2}]
["Всего баллов",null,null,null,"балл",{"$f":"SUM(F21:H21)","v":39}]
[null,null,null,null,null,{"$f":"SUMIF(Результаты!$E$20:$AI$20,\"Б\",Результаты!$E$22:$AI$22)","v":18},{"$f":"SUMIF(Результаты!$E$20:$AI$20,\"П\",Результаты!$E$22:$AI$22)","v":16},{"$f":"SUMIF(Результаты!$E$20:$AI$20,\"В\",Результаты!$E$22:$AI$22)","v":5}]
["Средний балл по уровням",null,null,null,"балл",{"$f":"SUMIF(Результаты!$E$20:$AI$20,\"Б\",Результаты!$E$24:$AI$173)/Результаты!$A$177","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Результаты!$E$20:$AI$20,\"П\",Результаты!$E$24:$AI$173)/Результаты!$A$177","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Результаты!$E$20:$AI$20,\"В\",Результаты!$E$24:$AI$173)/Результаты!$A$177","v":{"$error":"#DIV/0!"}}]
["% выполнения работы по уровням",null,null,null,null,{"$f":"Результаты!AK178","v":64.285714285714292},{"$f":"Результаты!AL178","v":38.392857142857146},{"$f":"Результаты!AM178","v":52.5}]
["Средний балл по работе",null,null,null,"балл",{"$f":"Результаты!AJ178","v":19.214285714285715}]
["Преодолели порог",null,null,null,"чел.",{"$f":"SUM(Результаты!AO175:AO177)","v":11}]
[null,null,null,null,"%",{"$f":"SUM(Результаты!AP175:AP177)","v":{"$error":"#DIV/0!"}}]
["Не преодолели порог",null,null,null,"чел.",{"$f":"Результаты!AO178","v":3}]
[null,null,null,null,"%",{"$f":"Результаты!AP178","v":{"$error":"#DIV/0!"}}]
["Попали в группу риска (пороговый балл + 1)",null,null,null,"чел.",{"$f":"COUNTIF(Результаты!AJ24:AJ173,D9)+COUNTIF(Результаты!AJ24:AJ173,E9)","v":2}]
[null,null,null,null,"%",{"$f":"F29/F16","v":{"$error":"#DIV/0!"}}]
["Получили оценку",null,null,null,"балл","\"5\"","\"4\"","\"3\"","\"2\""]
[null,null,null,null,"чел.",{"$f":"Результаты!$AO$175","v":0},{"$f":"Результаты!$AO$176","v":2},{"$f":"Результаты!$AO$177","v":9},{"$f":"Результаты!$AO$178","v":3}]
[null,null,null,null,"%",{"$f":"Результаты!$AP$175","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AP$176","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AP$177","v":{"$error":"#DIV/0!"}},{"$f":"Результаты!$AP$178","v":{"$error":"#DIV/0!"}}]
[]
["Перевод баллов в оценку"]
[34,"-",39,"5 баллов"]
[25,"-",33,"4 балла"]
[15,"-",24,"3 балла"]
[0,"-",14,"2 балла"]
[]
["номер","тема задания",null,null,null,null,null,null,null,null,null,"приступили","решили верно и полностью","%      верно решенных"]
[1,"Общество как форма жизнедеятельности людей; взаимодействие общества и природы; основные сферы общественной жизни, их взаимосвязь",null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(Результаты!E175:AI175)","v":14},{"$f":"TRANSPOSE(Результаты!E177:AI177)","v":14},{"$f":"TRANSPOSE(Результаты!E178:AI178)","v":{"$error":"#DIV/0!"}}]
[2,"Биологическое и социальное в человеке; личность; деятельность человека и ее основные формы (труд, игра, учение); человек и его ближайшее окружение; межличностные отношения; общение, межличностные конфликты, их конструктивное разрешение",null,null,null,null,null,null,null,null,null,14,13,{"$error":"#DIV/0!"}]
[3,"Общество и человек(задание на обращение к социальным реалиям)",null,null,null,null,null,null,null,null,null,14,6,{"$error":"#DIV/0!"}]
[4,"Общество и человек(задание на анализ двух суждений)",null,null,null,null,null,null,null,null,null,14,3,{"$error":"#DIV/0!"}]
[5,"Сфера духовной культуры и ее особенности; наука в жизни современного общества; образование и его значимость в условиях информационного общества; возможности получения общего и профессионального образования в Российской Федерации; религия, религиозные организации и объединения, их роль в жизни современного общества; свобода совести; мораль; гуманизм; патриотизм; гражданственность",null,null,null,null,null,null,null,null,null,14,13,{"$error":"#DIV/0!"}]
[6,"Сфера духовной культуры (задание на анализ двух суждений)",null,null,null,null,null,null,null,null,null,14,2,{"$error":"#DIV/0!"}]
[7,"Экономика, ее роль в жизни общества; товары и услуги, ресурсы и потребности, ограниченность ресурсов; экономические системы и собственность; производство, производительность труда; разделение труда и специализация; обмен, торговля; рынок и рыночный механизм",null,null,null,null,null,null,null,null,null,14,6,{"$error":"#DIV/0!"}]
[8,"Предпринимательство; малое предпринимательство и индивидуальная трудовая деятельность; деньги; заработная плата и стимулирование труда; неравенство доходов и экономические меры социальной поддержки; налоги, уплачиваемые гражданами; экономические цели и функции государства",null,null,null,null,null,null,null,null,null,14,4,{"$error":"#DIV/0!"}]
[9,"Экономическая сфера жизни общества (задание на обращение к социальным реалиям)",null,null,null,null,null,null,null,null,null,14,13,{"$error":"#DIV/0!"}]
[10,"Экономическая сфера жизни общества (задание на анализ двух суждений)",null,null,null,null,null,null,null,null,null,14,7,{"$error":"#DIV/0!"}]
[11,"Социальная структура общества, семья как малая группа, многообразие социальных ролей в подростковом возрасте, социальные ценности и нормы, отклоняющееся поведение, социальный конфликт и пути его решения, межнациональные отношения",null,null,null,null,null,null,null,null,null,14,13,{"$error":"#DIV/0!"}]
[12,"Социальная сфера (задание на обращение к социальным реалиям)",null,null,null,null,null,null,null,null,null,14,9,{"$error":"#DIV/0!"}]
[13,"Социальная сфера(задание на анализ двух суждений)",null,null,null,null,null,null,null,null,null,14,4,{"$error":"#DIV/0!"}]
[14,"Власть; роль политики в жизни общества; понятие и признаки государства; разделение властей; формы государства; политический режим; демократия; местное самоуправление; участие граждан в политической жизни; выборы, референдум; политические партии и движения, их роль в общественной жизни; гражданское общество и правовое государство",null,null,null,null,null,null,null,null,null,14,11,{"$error":"#DIV/0!"}]
[15,"Сфера политики и социального управления (задание на обращение к социальным реалиям)",null,null,null,null,null,null,null,null,null,14,9,{"$error":"#DIV/0!"}]
[16,"Сфера политики и социального управления (задание на анализ двух суждений)",null,null,null,null,null,null,null,null,null,14,8,{"$error":"#DIV/0!"}]
[17,"Право, его роль в жизни общества и государства; норма права; нормативный правовой акт; признаки и виды правонарушений; понятие и виды юридической ответственности; административные правоотношения, правонарушения и наказания; основные понятия и институты уголовного права; уголовная ответственность несовершеннолетних",null,null,null,null,null,null,null,null,null,14,10,{"$error":"#DIV/0!"}]
[18,"Конституция Российской Федерации; основы конституционного строя Российской Федерации; федеративное устройство Российской Федерации; органы государственной власти Российской Федерации; правоохранительные органы; судебная система; взаимоотношения органов государственной власти и граждан; права и свободы человека и гражданина в Российской Федерации, их гарантии; конституционные обязанности гражданина; права ребенка и их защита; особенности правового статуса несовершеннолетних; механизмы реализации и защиты прав и свобод человека и гражданина; международно-правовая защита жертв вооруженных конфликтов",null,null,null,null,null,null,null,null,null,14,5,{"$error":"#DIV/0!"}]
[19,"Понятие правоотношений, право на труд и трудовые правоотношения, трудоустройство несовершеннолетних, семейные правоотношения, права и обязанности родителей и детей, гражданские правоотношения, права собственности, права потребителей (задание на обращение к социальным реалиям)",null,null,null,null,null,null,null,null,null,14,10,{"$error":"#DIV/0!"}]
[20,"Право (задание на анализ двух суждений)",null,null,null,null,null,null,null,null,null,14,6,{"$error":"#DIV/0!"}]
[21,"Различное содержание в разных вариантах: задание ориентировано на проверяемое умение (задание на сравнение)",null,null,null,null,null,null,null,null,null,14,3,{"$error":"#DIV/0!"}]
[22,"Различное содержание в разных вариантах: задание ориентировано на проверяемое умение (задание на установление соответствия)",null,null,null,null,null,null,null,null,null,14,4,{"$error":"#DIV/0!"}]
[23,"Различное содержание в разных вариантах: задание ориентировано на проверяемое умение (задание на выбор верных позиций из списка)",null,null,null,null,null,null,null,null,null,14,9,{"$error":"#DIV/0!"}]
[24,"Различное содержание в разных вариантах: задание ориентировано на проверяемое умение (задание на выбор верных позиций из списка)",null,null,null,null,null,null,null,null,null,14,5,{"$error":"#DIV/0!"}]
[25,"Различное содержание в разных вариантах: задание ориентировано на проверяемое умение (задание на установление фактов и мнений)",null,null,null,null,null,null,null,null,null,14,13,{"$error":"#DIV/0!"}]
[26,"Задания на анализ источников",null,null,null,null,null,null,null,null,null,14,7,{"$error":"#DIV/0!"}]
[27,null,null,null,null,null,null,null,null,null,null,14,3,{"$error":"#DIV/0!"}]
[28,null,null,null,null,null,null,null,null,null,null,14,2,{"$error":"#DIV/0!"}]
[29,null,null,null,null,null,null,null,null,null,null,14,5,{"$error":"#DIV/0!"}]
[30,null,null,null,null,null,null,null,null,null,null,14,0,{"$error":"#DIV/0!"}]
[31,null,null,null,null,null,null,null,null,null,null,14,0,{"$error":"#DIV/0!"}]
[32,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[33,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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. Шаблон хранить без заполнения данными. При создании нового файла результатов открыть шаблон и сохранить под другим именем (именем проверяемого учреждения)"]