{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Мониторинг КПЭ_ежекв","Мониторинг КПЭ_по итогам года","Визуализация"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":19,"n_cols":35,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,31,1,33],[1,34,3,34],[2,33,3,33],[2,32,3,32],[2,31,3,31],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,1,8],[1,10,1,12],[1,9,3,9],[1,24,1,26],[2,7,2,8],[2,6,3,6],[1,13,1,15],[1,17,1,19],[2,18,2,19],[2,10,3,10],[1,30,3,30],[1,27,1,29],[2,28,2,29],[2,20,3,20],[2,21,2,22],[2,24,3,24],[1,23,3,23],[2,25,2,26],[2,27,3,27],[1,20,1,22],[2,11,2,12],[2,13,3,13],[2,14,2,15],[2,17,3,17],[1,16,3,16]]}
[]
[null,null,null,"№\nп.п.","КПЭ ","Единица измерения","I квартал",null,null,"Примечание\n(причины отклонения от плана)","II квартал",null,null,"1 полугодие",null,null,"Примечание\n(причины отклонения от плана)","III квартал",null,null,"9 месяцев",null,null,"Примечание\n(причины отклонения от плана)","IV квартал",null,null,"ГОД",null,null,"Примечание\n(причины отклонения от плана)","Уровни эффективности",null,null,"Вес,\n%"]
[null,null,null,null,null,null,"2017г.\n(факт)","2018г.",null,null,"2017г.\n(факт)","2018г.",null,"2017г.\n(факт)","2018г.",null,null,"2017г.\n(факт)","2018г.",null,"2017г.\n(факт)","2018г.",null,null,"2017г.\n(факт)","2018г.",null,"2017г.\n(факт)","2018г.",null,null,"нижний","целевой/ план","верхний"]
[null,null,null,null,null,null,null,"план","факт",null,null,"план","факт",null,"план","факт",null,null,"план","факт",null,"план","факт",null,null,"план","факт",null,"план","факт"]
[null,null,null,null,null,null,null," I квартал",null,null,null,null,null,null," I полугодие",null,null,null,null,null,null," 9 месяцев",null,null,null,null,null,null," год"]
["ФИО 1","Должность 1","Подразделение 1",1,"Показатель 1",{"$f":"IFERROR(INDEX(#REF!,MATCH($D6,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 1","Должность 1","Подразделение 1",2,"Показатель 2",{"$f":"IFERROR(INDEX(#REF!,MATCH($D7,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 1","Должность 1","Подразделение 1","2.1.","Показатель 2 (нормализованный)",{"$f":"IFERROR(INDEX(#REF!,MATCH($D8,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 1","Должность 1","Подразделение 1",3,"Показатель 3",{"$f":"IFERROR(INDEX(#REF!,MATCH($D9,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 1","Должность 1","Подразделение 1",4,"Показатель 4",{"$f":"IFERROR(INDEX(#REF!,MATCH($D10,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 1","Должность 1","Подразделение 1","4.1.","Показатель 4 (нормализованный)",{"$f":"IFERROR(INDEX(#REF!,MATCH($D11,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(E1))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 1","Должность 1","Подразделение 1",5,"Показатель 5",{"$f":"IFERROR(INDEX(#REF!,MATCH($D12,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(E2))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 1","Должность 1","Подразделение 1",6,"Показатель 6",{"$f":"IFERROR(INDEX(#REF!,MATCH($D13,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(E4))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 2","Должность 2","Подразделение 2",1,"Показатель 1",{"$f":"IFERROR(INDEX(#REF!,MATCH($D14,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 2","Должность 2","Подразделение 2",2,"Показатель 2",{"$f":"IFERROR(INDEX(#REF!,MATCH($D15,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 2","Должность 2","Подразделение 2",3,"Показатель 3",{"$f":"IFERROR(INDEX(#REF!,MATCH($D16,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 2","Должность 2","Подразделение 2",4,"Показатель 4",{"$f":"IFERROR(INDEX(#REF!,MATCH($D17,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(#REF!))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["ФИО 2","Должность 2","Подразделение 2",5,"Показатель 5",{"$f":"IFERROR(INDEX(#REF!,MATCH($D18,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!=#REF!,ROW(#REF!)-ROW(#REF!)),ROW(E10))),\"-\")","v":"-"},null,null,"Необходимо подтянуть из листа \"Визуализация\" (можно по номеру п.п.)"]
["и т.д."]

{"sheet":"Мониторинг КПЭ_по итогам года","index":1,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,18,2,18],[1,19,2,19],[1,20,2,20],[1,16,2,16],[1,17,2,17],[7,4,7,5],[1,11,1,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,4,2,4],[11,4,11,5],[1,5,2,5],[1,6,2,6],[1,7,1,8],[1,9,1,10],[1,21,2,21]]}
[]
[null,null,null,null,"№ п.п.","Наименование проекта","Вес проекта,\n% ","Качество / Результат проекта \n(балл)",null,"График\n(балл)",null,"Бюджет\n(балл)",null,"Уд.вес по\nкритерию\nкачество,\n%*","Уд.вес по\nкритерию\nграфик,\n%*","Уд.вес по\nкритерию\nбюджет,\n%","Целевое значение (8=100%)","РПк\n(факт)","РПг\n(факт)","РПб\n(факт)","Общая\nоценка по\nкритериям\nКГ\n(балл)","Уровень исполнения проекта от цели (8 баллов)"]
[null,null,null,null,null,null,null,"План","Факт","План","Факт","План","Факт"]
[null,null,null,null,1,2,3,4,5,6,7,9,10,8,9,13,10,11,12,17,13,14]
[{"$f":"IF(F5<>\"-\",\"+\",\"\")","v":"+"},"ФИО 1","Должность 1","Подразделение 1",1,"Проект 1",null,8,null,8,null,8,null,null,null,null,8,{"$f":"I5*N5","v":0},{"$f":"K5*O5","v":0},{"$f":"M5*P5","v":0},{"$f":"R5+S5+T5","v":0},{"$f":"IF(G5=\"-\",\"-\",(U5/8)*G5)","v":0}]
[{"$f":"IF(F6<>\"-\",\"+\",\"\")","v":"+"},"ФИО 1","Должность 1","Подразделение 1",2,"Проект 2",null,8,null,8,null,8,null,null,null,null,8,{"$f":"I6*N6","v":0},{"$f":"K6*O6","v":0},{"$f":"M6*P6","v":0},{"$f":"R6+S6+T6","v":0},{"$f":"IF(G6=\"-\",\"-\",(U6/8)*G6)","v":0}]
["+","ФИО 1","Должность 1","Подразделение 1",3,"Проект 3",null,8,null,8,null,8,null,null,null,null,8,{"$f":"I7*N7","v":0},{"$f":"K7*O7","v":0},{"$f":"M7*P7","v":0},{"$f":"R7+S7+T7","v":0},{"$f":"IF(G7=\"-\",\"-\",(U7/8)*G7)","v":0}]
["+","ФИО 1","Должность 1","Подразделение 1","Итоговое значение Проектов **",null,{"$f":"SUM(G5:G7)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$7,Q5:Q7)","v":0},null,null,null,{"$f":"SUMPRODUCT($G$5:$G$7,U5:U7)","v":0},{"$f":"SUM(V5:V7)","v":0}]
[{"$f":"IF(F9<>\"-\",\"+\",\"\")","v":"+"},"ФИО 2","Должность 2","Подразделение 2",1,"Проект 1",null,8,null,8,null,8,null,null,null,null,8,{"$f":"I9*N9","v":0},{"$f":"K9*O9","v":0},{"$f":"M9*P9","v":0},{"$f":"R9+S9+T9","v":0},{"$f":"IF(G9=\"-\",\"-\",(U9/8)*G9)","v":0}]
[{"$f":"IF(F10<>\"-\",\"+\",\"\")","v":"+"},"ФИО 1","Должность 1","Подразделение 1",2,"Проект 2",null,8,null,8,null,8,null,null,null,null,8,{"$f":"I10*N10","v":0},{"$f":"K10*O10","v":0},{"$f":"M10*P10","v":0},{"$f":"R10+S10+T10","v":0},{"$f":"IF(G10=\"-\",\"-\",(U10/8)*G10)","v":0}]
["+","ФИО 1","Должность 1","Подразделение 1",3,"Проект 3",null,8,null,8,null,8,null,null,null,null,8,{"$f":"I11*N11","v":0},{"$f":"K11*O11","v":0},{"$f":"M11*P11","v":0},{"$f":"R11+S11+T11","v":0},{"$f":"IF(G11=\"-\",\"-\",(U11/8)*G11)","v":0}]
["+","ФИО 1","Должность 1","Подразделение 1","Итоговое значение Проектов **",null,{"$f":"SUM(G9:G11)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$5:$G$7,Q9:Q11)","v":0},null,null,null,{"$f":"SUMPRODUCT($G$5:$G$7,U9:U11)","v":0},{"$f":"SUM(V9:V11)","v":0}]
[null,"и т.д."]
[null,null,null,null,null,"Не по всем работникам (у 5-10%) могут быть проекты, но лист есть во всех файлах (как правило у кого нет они скрывают листы)"]

{"sheet":"Визуализация","index":2,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":true,"merged":[[7,20,8,20],[8,9,8,11],[9,1,11,1],[9,2,11,2],[9,9,9,11],[9,16,11,16],[10,3,11,3],[7,3,8,3],[7,4,8,4],[7,5,7,15],[7,16,8,16],[7,17,7,19],[10,4,11,4],[9,6,9,8],[7,1,8,1],[9,12,9,14],[8,6,8,8],[8,12,8,14],[18,1,20,1],[18,2,20,2],[12,1,14,1],[12,2,14,2],[25,3,26,3],[25,4,26,4],[15,1,17,1],[15,2,17,2],[15,9,15,11],[12,6,12,8],[12,16,14,16],[13,3,14,3],[13,4,14,4],[15,16,17,16],[15,12,15,14],[16,3,17,3],[16,4,17,4],[18,9,18,11],[18,16,20,16],[19,3,20,3],[19,4,20,4],[18,6,18,8],[18,12,18,14],[12,9,12,11],[15,6,15,8],[12,12,12,14],[27,16,29,16],[28,3,29,3],[28,4,29,4],[21,16,23,16],[22,3,23,3],[22,4,23,4],[46,3,46,5],[46,6,46,10],[46,11,46,15],[44,3,44,5],[44,6,44,10],[44,11,44,15],[45,3,45,5],[45,6,45,10],[45,11,45,15],[42,3,42,5],[42,6,42,10],[42,11,42,15],[43,3,43,5],[43,6,43,10],[43,11,43,15],[41,3,41,5],[41,6,41,10],[36,6,36,8],[40,1,40,2],[40,3,40,5],[40,6,40,10],[40,11,40,15],[21,6,21,8],[21,12,21,14],[24,6,24,8],[24,12,24,14],[27,6,27,8],[27,12,27,14],[27,1,29,1],[27,2,29,2],[36,9,36,11],[36,12,36,14],[27,9,27,11],[24,1,26,1],[24,2,26,2],[24,9,24,11],[21,1,23,1],[21,2,23,2],[21,9,21,11],[24,16,26,16],[41,11,41,15],[30,1,32,1],[30,2,32,2],[7,2,8,2],[36,16,38,16],[37,3,38,3],[37,4,38,4],[30,16,32,16],[31,3,32,3],[31,4,32,4],[33,1,35,1],[33,2,35,2],[33,6,33,8],[33,9,33,11],[33,12,33,14],[33,16,35,16],[34,3,35,3],[34,4,35,4],[30,6,30,8],[30,9,30,11],[30,12,30,14],[36,1,38,1],[36,2,38,2]]}
[{"$f":"INDEX(#REF!,MATCH(#REF!,#REF!,0),1)","v":{"$error":"#REF!"}},"Оценка результативности за _____________ 2018 года"]
[]
[null,null,"ФИО работника:"]
[null,null,"Должность:"]
[null,null,"Подразделение:"]
[null,null,"ФИО непосредственного\nруководителя работника: "]
[null,null,null,null,null,14000,15262.6505864389,16000,16110.575619018797,16500,16958.500651598733,17100,18654.350716758607,19000,20350.20078191848,21000]
[null,"№\nп.\nп.","Наименование показателя","Ед.\nизм.","  Факт  \n% от\nцели","Исполнение, %",null,null,null,null,null,null,null,null,null,null,"Примечание ","Уровни эффективности",null,null,"Вес,\n%"]
[null,null,null,null,null,null,"нижний",null,null,"целевой/ план",null,null,"верхний",null,null,null,null,"нижний","целевой/ план","верхний"]
[{"$f":"IF(B10<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B9,\"<>\"&\"\"))),\"\")","v":1},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C9,\"<>\"&\"\"))),\"\")","v":"Показатель 1"},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B9,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C10,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R10","v":0},null,null,{"$f":"S10","v":0},null,null,{"$f":"T10","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C10,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S10*R11,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C10,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S10*T11,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B9,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B10<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E10=\"Да\",100%,IF(E10=\"Нет\",0%,IFERROR(E10/S10,0)))","v":0},{"$f":"IF(OR(AND(G10<=M10,E11<G12),AND(G10>M10,E11>G12)),E11,\"\")","v":""},{"$f":"IF(AND(AND(G12=E11,J10<>G10),AND(G12=E11,G10<>M10)),E11,\"\")","v":""},{"$f":"IF(OR(AND(E11<(G12+(K12-G12)/2),E11>G12,G10<M10),AND(E11>(G12+(K12-G12)/2),E11<G12,G10>M10)),E11,\"\")","v":""},{"$f":"IF(AND((E11=(G12+(K12-G12)/2)),NOT(AND(R11=S11,S11=T11))),E11,\"\")","v":""},{"$f":"IF(OR(AND(E11>(G12+(K12-G12)/2),E11<K12,G10<M10),AND(E11<(G12+(K12-G12)/2),E11>K12,G10>M10)),E11,\"\")","v":""},{"$f":"IF(K12=E11,E11,\"\")","v":0},{"$f":"IF(OR(AND(E11<(O12+(K12-O12)/2),E11>K12,G10<M10),AND(E11>(O12+(K12-O12)/2),E11<K12,G10>M10)),E11,\"\")","v":""},{"$f":"IF(AND(E11=(K12+(O12-K12)/2),NOT(AND(R11=S11,S11=T11))),E11,\"\")","v":""},{"$f":"IF(OR(AND(E11>(O12+(K12-O12)/2),E11<O12,G10<M10),AND(E11<(O12+(K12-O12)/2),E11>O12,G10>M10)),E11,\"\")","v":""},{"$f":"IF(AND(AND(O12=E11,J10<>M10),AND(O12=E11,G10<>M10)),E11,\"\")","v":""},{"$f":"IF(OR(AND(G10<=M10,E11>O12),AND(G10>M10,E11<O12)),E11,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B9,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B9,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B9,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B10<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R11","v":0},null,null,null,{"$f":"S11","v":0},null,null,null,{"$f":"T11","v":0}]
[{"$f":"IF(B13<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B12,\"<>\"&\"\"))),\"\")","v":2},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C12,\"<>\"&\"\"))),\"\")","v":"Показатель 2"},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B12,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C13,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R13","v":0},null,null,{"$f":"S13","v":0},null,null,{"$f":"T13","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C13,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S13*R14,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C13,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S13*T14,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B12,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B13<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E13=\"Да\",100%,IF(E13=\"Нет\",0%,IFERROR(E13/S13,0)))","v":0},{"$f":"IF(OR(AND(G13<=M13,E14<G15),AND(G13>M13,E14>G15)),E14,\"\")","v":""},{"$f":"IF(AND(AND(G15=E14,J13<>G13),AND(G15=E14,G13<>M13)),E14,\"\")","v":""},{"$f":"IF(OR(AND(E14<(G15+(K15-G15)/2),E14>G15,G13<M13),AND(E14>(G15+(K15-G15)/2),E14<G15,G13>M13)),E14,\"\")","v":""},{"$f":"IF(AND((E14=(G15+(K15-G15)/2)),NOT(AND(R14=S14,S14=T14))),E14,\"\")","v":""},{"$f":"IF(OR(AND(E14>(G15+(K15-G15)/2),E14<K15,G13<M13),AND(E14<(G15+(K15-G15)/2),E14>K15,G13>M13)),E14,\"\")","v":""},{"$f":"IF(K15=E14,E14,\"\")","v":0},{"$f":"IF(OR(AND(E14<(O15+(K15-O15)/2),E14>K15,G13<M13),AND(E14>(O15+(K15-O15)/2),E14<K15,G13>M13)),E14,\"\")","v":""},{"$f":"IF(AND(E14=(K15+(O15-K15)/2),NOT(AND(R14=S14,S14=T14))),E14,\"\")","v":""},{"$f":"IF(OR(AND(E14>(O15+(K15-O15)/2),E14<O15,G13<M13),AND(E14<(O15+(K15-O15)/2),E14>O15,G13>M13)),E14,\"\")","v":""},{"$f":"IF(AND(AND(O15=E14,J13<>M13),AND(O15=E14,G13<>M13)),E14,\"\")","v":""},{"$f":"IF(OR(AND(G13<=M13,E14>O15),AND(G13>M13,E14<O15)),E14,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B12,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B12,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B12,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B13<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R14","v":0},null,null,null,{"$f":"S14","v":0},null,null,null,{"$f":"T14","v":0}]
[{"$f":"IF(B16<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B15,\"<>\"&\"\"))),\"\")","v":"2.1."},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C15,\"<>\"&\"\"))),\"\")","v":"Показатель 2 (нормализованный)"},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B15,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C16,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R16","v":0},null,null,{"$f":"S16","v":0},null,null,{"$f":"T16","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C16,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S16*R17,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C16,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S16*T17,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B15,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B16<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E16=\"Да\",100%,IF(E16=\"Нет\",0%,IFERROR(E16/S16,0)))","v":0},{"$f":"IF(OR(AND(G16<=M16,E17<G18),AND(G16>M16,E17>G18)),E17,\"\")","v":""},{"$f":"IF(AND(AND(G18=E17,J16<>G16),AND(G18=E17,G16<>M16)),E17,\"\")","v":""},{"$f":"IF(OR(AND(E17<(G18+(K18-G18)/2),E17>G18,G16<M16),AND(E17>(G18+(K18-G18)/2),E17<G18,G16>M16)),E17,\"\")","v":""},{"$f":"IF(AND((E17=(G18+(K18-G18)/2)),NOT(AND(R17=S17,S17=T17))),E17,\"\")","v":""},{"$f":"IF(OR(AND(E17>(G18+(K18-G18)/2),E17<K18,G16<M16),AND(E17<(G18+(K18-G18)/2),E17>K18,G16>M16)),E17,\"\")","v":""},{"$f":"IF(K18=E17,E17,\"\")","v":0},{"$f":"IF(OR(AND(E17<(O18+(K18-O18)/2),E17>K18,G16<M16),AND(E17>(O18+(K18-O18)/2),E17<K18,G16>M16)),E17,\"\")","v":""},{"$f":"IF(AND(E17=(K18+(O18-K18)/2),NOT(AND(R17=S17,S17=T17))),E17,\"\")","v":""},{"$f":"IF(OR(AND(E17>(O18+(K18-O18)/2),E17<O18,G16<M16),AND(E17<(O18+(K18-O18)/2),E17>O18,G16>M16)),E17,\"\")","v":""},{"$f":"IF(AND(AND(O18=E17,J16<>M16),AND(O18=E17,G16<>M16)),E17,\"\")","v":""},{"$f":"IF(OR(AND(G16<=M16,E17>O18),AND(G16>M16,E17<O18)),E17,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B15,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B15,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B15,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B16<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R17","v":0},null,null,null,{"$f":"S17","v":0},null,null,null,{"$f":"T17","v":0}]
[{"$f":"IF(B19<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B18,\"<>\"&\"\"))),\"\")","v":3},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C18,\"<>\"&\"\"))),\"\")","v":"Показатель 3"},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B18,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C19,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R19","v":0},null,null,{"$f":"S19","v":0},null,null,{"$f":"T19","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C19,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S19*R20,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C19,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S19*T20,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B18,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B19<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E19=\"Да\",100%,IF(E19=\"Нет\",0%,IFERROR(E19/S19,0)))","v":0},{"$f":"IF(OR(AND(G19<=M19,E20<G21),AND(G19>M19,E20>G21)),E20,\"\")","v":""},{"$f":"IF(AND(AND(G21=E20,J19<>G19),AND(G21=E20,G19<>M19)),E20,\"\")","v":""},{"$f":"IF(OR(AND(E20<(G21+(K21-G21)/2),E20>G21,G19<M19),AND(E20>(G21+(K21-G21)/2),E20<G21,G19>M19)),E20,\"\")","v":""},{"$f":"IF(AND((E20=(G21+(K21-G21)/2)),NOT(AND(R20=S20,S20=T20))),E20,\"\")","v":""},{"$f":"IF(OR(AND(E20>(G21+(K21-G21)/2),E20<K21,G19<M19),AND(E20<(G21+(K21-G21)/2),E20>K21,G19>M19)),E20,\"\")","v":""},{"$f":"IF(K21=E20,E20,\"\")","v":0},{"$f":"IF(OR(AND(E20<(O21+(K21-O21)/2),E20>K21,G19<M19),AND(E20>(O21+(K21-O21)/2),E20<K21,G19>M19)),E20,\"\")","v":""},{"$f":"IF(AND(E20=(K21+(O21-K21)/2),NOT(AND(R20=S20,S20=T20))),E20,\"\")","v":""},{"$f":"IF(OR(AND(E20>(O21+(K21-O21)/2),E20<O21,G19<M19),AND(E20<(O21+(K21-O21)/2),E20>O21,G19>M19)),E20,\"\")","v":""},{"$f":"IF(AND(AND(O21=E20,J19<>M19),AND(O21=E20,G19<>M19)),E20,\"\")","v":""},{"$f":"IF(OR(AND(G19<=M19,E20>O21),AND(G19>M19,E20<O21)),E20,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B18,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B18,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B18,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B19<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R20","v":0},null,null,null,{"$f":"S20","v":0},null,null,null,{"$f":"T20","v":0}]
[{"$f":"IF(B22<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B21,\"<>\"&\"\"))),\"\")","v":4},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C21,\"<>\"&\"\"))),\"\")","v":"Показатель 4"},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B21,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C22,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R22","v":0},null,null,{"$f":"S22","v":0},null,null,{"$f":"T22","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C22,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S22*R23,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C22,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S22*T23,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B21,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B22<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E22=\"Да\",100%,IF(E22=\"Нет\",0%,IFERROR(E22/S22,0)))","v":0},{"$f":"IF(OR(AND(G22<=M22,E23<G24),AND(G22>M22,E23>G24)),E23,\"\")","v":""},{"$f":"IF(AND(AND(G24=E23,J22<>G22),AND(G24=E23,G22<>M22)),E23,\"\")","v":""},{"$f":"IF(OR(AND(E23<(G24+(K24-G24)/2),E23>G24,G22<M22),AND(E23>(G24+(K24-G24)/2),E23<G24,G22>M22)),E23,\"\")","v":""},{"$f":"IF(AND((E23=(G24+(K24-G24)/2)),NOT(AND(R23=S23,S23=T23))),E23,\"\")","v":""},{"$f":"IF(OR(AND(E23>(G24+(K24-G24)/2),E23<K24,G22<M22),AND(E23<(G24+(K24-G24)/2),E23>K24,G22>M22)),E23,\"\")","v":""},{"$f":"IF(K24=E23,E23,\"\")","v":0},{"$f":"IF(OR(AND(E23<(O24+(K24-O24)/2),E23>K24,G22<M22),AND(E23>(O24+(K24-O24)/2),E23<K24,G22>M22)),E23,\"\")","v":""},{"$f":"IF(AND(E23=(K24+(O24-K24)/2),NOT(AND(R23=S23,S23=T23))),E23,\"\")","v":""},{"$f":"IF(OR(AND(E23>(O24+(K24-O24)/2),E23<O24,G22<M22),AND(E23<(O24+(K24-O24)/2),E23>O24,G22>M22)),E23,\"\")","v":""},{"$f":"IF(AND(AND(O24=E23,J22<>M22),AND(O24=E23,G22<>M22)),E23,\"\")","v":""},{"$f":"IF(OR(AND(G22<=M22,E23>O24),AND(G22>M22,E23<O24)),E23,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B21,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B21,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B21,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B22<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R23","v":0},null,null,null,{"$f":"S23","v":0},null,null,null,{"$f":"T23","v":0}]
[{"$f":"IF(B25<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B24,\"<>\"&\"\"))),\"\")","v":"4.1."},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C24,\"<>\"&\"\"))),\"\")","v":"Показатель 4 (нормализованный)"},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B24,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C25,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R25","v":0},null,null,{"$f":"S25","v":0},null,null,{"$f":"T25","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C25,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S25*R26,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C25,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S25*T26,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B24,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B25<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E25=\"Да\",100%,IF(E25=\"Нет\",0%,IFERROR(E25/S25,0)))","v":0},{"$f":"IF(OR(AND(G25<=M25,E26<G27),AND(G25>M25,E26>G27)),E26,\"\")","v":""},{"$f":"IF(AND(AND(G27=E26,J25<>G25),AND(G27=E26,G25<>M25)),E26,\"\")","v":""},{"$f":"IF(OR(AND(E26<(G27+(K27-G27)/2),E26>G27,G25<M25),AND(E26>(G27+(K27-G27)/2),E26<G27,G25>M25)),E26,\"\")","v":""},{"$f":"IF(AND((E26=(G27+(K27-G27)/2)),NOT(AND(R26=S26,S26=T26))),E26,\"\")","v":""},{"$f":"IF(OR(AND(E26>(G27+(K27-G27)/2),E26<K27,G25<M25),AND(E26<(G27+(K27-G27)/2),E26>K27,G25>M25)),E26,\"\")","v":""},{"$f":"IF(K27=E26,E26,\"\")","v":0},{"$f":"IF(OR(AND(E26<(O27+(K27-O27)/2),E26>K27,G25<M25),AND(E26>(O27+(K27-O27)/2),E26<K27,G25>M25)),E26,\"\")","v":""},{"$f":"IF(AND(E26=(K27+(O27-K27)/2),NOT(AND(R26=S26,S26=T26))),E26,\"\")","v":""},{"$f":"IF(OR(AND(E26>(O27+(K27-O27)/2),E26<O27,G25<M25),AND(E26<(O27+(K27-O27)/2),E26>O27,G25>M25)),E26,\"\")","v":""},{"$f":"IF(AND(AND(O27=E26,J25<>M25),AND(O27=E26,G25<>M25)),E26,\"\")","v":""},{"$f":"IF(OR(AND(G25<=M25,E26>O27),AND(G25>M25,E26<O27)),E26,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B24,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B24,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B24,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B25<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R26","v":0},null,null,null,{"$f":"S26","v":0},null,null,null,{"$f":"T26","v":0}]
[{"$f":"IF(B28<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B27,\"<>\"&\"\"))),\"\")","v":5},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C27,\"<>\"&\"\"))),\"\")","v":"Показатель 5"},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B27,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C28,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R28","v":0},null,null,{"$f":"S28","v":0},null,null,{"$f":"T28","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C28,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S28*R29,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C28,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S28*T29,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B27,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B28<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E28=\"Да\",100%,IF(E28=\"Нет\",0%,IFERROR(E28/S28,0)))","v":0},{"$f":"IF(OR(AND(G28<=M28,E29<G30),AND(G28>M28,E29>G30)),E29,\"\")","v":""},{"$f":"IF(AND(AND(G30=E29,J28<>G28),AND(G30=E29,G28<>M28)),E29,\"\")","v":""},{"$f":"IF(OR(AND(E29<(G30+(K30-G30)/2),E29>G30,G28<M28),AND(E29>(G30+(K30-G30)/2),E29<G30,G28>M28)),E29,\"\")","v":""},{"$f":"IF(AND((E29=(G30+(K30-G30)/2)),NOT(AND(R29=S29,S29=T29))),E29,\"\")","v":""},{"$f":"IF(OR(AND(E29>(G30+(K30-G30)/2),E29<K30,G28<M28),AND(E29<(G30+(K30-G30)/2),E29>K30,G28>M28)),E29,\"\")","v":""},{"$f":"IF(K30=E29,E29,\"\")","v":0},{"$f":"IF(OR(AND(E29<(O30+(K30-O30)/2),E29>K30,G28<M28),AND(E29>(O30+(K30-O30)/2),E29<K30,G28>M28)),E29,\"\")","v":""},{"$f":"IF(AND(E29=(K30+(O30-K30)/2),NOT(AND(R29=S29,S29=T29))),E29,\"\")","v":""},{"$f":"IF(OR(AND(E29>(O30+(K30-O30)/2),E29<O30,G28<M28),AND(E29<(O30+(K30-O30)/2),E29>O30,G28>M28)),E29,\"\")","v":""},{"$f":"IF(AND(AND(O30=E29,J28<>M28),AND(O30=E29,G28<>M28)),E29,\"\")","v":""},{"$f":"IF(OR(AND(G28<=M28,E29>O30),AND(G28>M28,E29<O30)),E29,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B27,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B27,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B27,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B28<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R29","v":0},null,null,null,{"$f":"S29","v":0},null,null,null,{"$f":"T29","v":0}]
[{"$f":"IF(B31<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B30,\"<>\"&\"\"))),\"\")","v":6},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C30,\"<>\"&\"\"))),\"\")","v":"Показатель 6"},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B30,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C31,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R31","v":0},null,null,{"$f":"S31","v":0},null,null,{"$f":"T31","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C31,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S31*R32,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C31,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S31*T32,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B30,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B31<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E31=\"Да\",100%,IF(E31=\"Нет\",0%,IFERROR(E31/S31,0)))","v":0},{"$f":"IF(OR(AND(G31<=M31,E32<G33),AND(G31>M31,E32>G33)),E32,\"\")","v":""},{"$f":"IF(AND(AND(G33=E32,J31<>G31),AND(G33=E32,G31<>M31)),E32,\"\")","v":""},{"$f":"IF(OR(AND(E32<(G33+(K33-G33)/2),E32>G33,G31<M31),AND(E32>(G33+(K33-G33)/2),E32<G33,G31>M31)),E32,\"\")","v":""},{"$f":"IF(AND((E32=(G33+(K33-G33)/2)),NOT(AND(R32=S32,S32=T32))),E32,\"\")","v":""},{"$f":"IF(OR(AND(E32>(G33+(K33-G33)/2),E32<K33,G31<M31),AND(E32<(G33+(K33-G33)/2),E32>K33,G31>M31)),E32,\"\")","v":""},{"$f":"IF(K33=E32,E32,\"\")","v":0},{"$f":"IF(OR(AND(E32<(O33+(K33-O33)/2),E32>K33,G31<M31),AND(E32>(O33+(K33-O33)/2),E32<K33,G31>M31)),E32,\"\")","v":""},{"$f":"IF(AND(E32=(K33+(O33-K33)/2),NOT(AND(R32=S32,S32=T32))),E32,\"\")","v":""},{"$f":"IF(OR(AND(E32>(O33+(K33-O33)/2),E32<O33,G31<M31),AND(E32<(O33+(K33-O33)/2),E32>O33,G31>M31)),E32,\"\")","v":""},{"$f":"IF(AND(AND(O33=E32,J31<>M31),AND(O33=E32,G31<>M31)),E32,\"\")","v":""},{"$f":"IF(OR(AND(G31<=M31,E32>O33),AND(G31>M31,E32<O33)),E32,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B30,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B30,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B30,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B31<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R32","v":0},null,null,null,{"$f":"S32","v":0},null,null,null,{"$f":"T32","v":0}]
[{"$f":"IF(B34<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B33,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C33,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B33,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C34,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R34","v":0},null,null,{"$f":"S34","v":0},null,null,{"$f":"T34","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C34,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S34*R35,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C34,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S34*T35,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B33,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B34<>\"\",\"+\",\"\")","v":""},null,null,"%",{"$f":"IF(E34=\"Да\",100%,IF(E34=\"Нет\",0%,IFERROR(E34/S34,0)))","v":0},{"$f":"IF(OR(AND(G34<=M34,E35<G36),AND(G34>M34,E35>G36)),E35,\"\")","v":""},{"$f":"IF(AND(AND(G36=E35,J34<>G34),AND(G36=E35,G34<>M34)),E35,\"\")","v":""},{"$f":"IF(OR(AND(E35<(G36+(K36-G36)/2),E35>G36,G34<M34),AND(E35>(G36+(K36-G36)/2),E35<G36,G34>M34)),E35,\"\")","v":""},{"$f":"IF(AND((E35=(G36+(K36-G36)/2)),NOT(AND(R35=S35,S35=T35))),E35,\"\")","v":""},{"$f":"IF(OR(AND(E35>(G36+(K36-G36)/2),E35<K36,G34<M34),AND(E35<(G36+(K36-G36)/2),E35>K36,G34>M34)),E35,\"\")","v":""},{"$f":"IF(K36=E35,E35,\"\")","v":0},{"$f":"IF(OR(AND(E35<(O36+(K36-O36)/2),E35>K36,G34<M34),AND(E35>(O36+(K36-O36)/2),E35<K36,G34>M34)),E35,\"\")","v":""},{"$f":"IF(AND(E35=(K36+(O36-K36)/2),NOT(AND(R35=S35,S35=T35))),E35,\"\")","v":""},{"$f":"IF(OR(AND(E35>(O36+(K36-O36)/2),E35<O36,G34<M34),AND(E35<(O36+(K36-O36)/2),E35>O36,G34>M34)),E35,\"\")","v":""},{"$f":"IF(AND(AND(O36=E35,J34<>M34),AND(O36=E35,G34<>M34)),E35,\"\")","v":""},{"$f":"IF(OR(AND(G34<=M34,E35>O36),AND(G34>M34,E35<O36)),E35,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B33,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B33,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B33,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B34<>\"\",\"+\",\"\")","v":""},null,null,null,null,null,{"$f":"R35","v":0},null,null,null,{"$f":"S35","v":0},null,null,null,{"$f":"T35","v":0}]
[{"$f":"IF(B37<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$D$6:$D$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$D$6:$D$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$D$6:$D$13)-ROW('Мониторинг КПЭ_ежекв'!$D$5)),COUNTIF(B$8:B36,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$E$6:$E$13,SMALL(IF('Мониторинг КПЭ_ежекв'!$E$6:$E$13<>\"\",ROW('Мониторинг КПЭ_ежекв'!$E$6:$E$13)-ROW('Мониторинг КПЭ_ежекв'!$E$5)),COUNTIF(C$8:C36,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B36,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C37,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+1),0)","v":0},null,{"$f":"R37","v":0},null,null,{"$f":"S37","v":0},null,null,{"$f":"T37","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C37,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH($A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)+2),0)","v":0},{"$f":"IFERROR(S37*R38,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$H$6:$AE$13,MATCH($C37,'Мониторинг КПЭ_ежекв'!$E$6:$E$13,0),MATCH(Визуализация!$A$1,'Мониторинг КПЭ_ежекв'!$H$5:$AE$5,0)),0)","v":0},{"$f":"IFERROR(S37*T38,0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B36,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B37<>\"\",\"+\",\"\")","v":""},null,null,"%",{"$f":"IF(E37=\"Да\",100%,IF(E37=\"Нет\",0%,IFERROR(E37/S37,0)))","v":0},{"$f":"IF(OR(AND(G37<=M37,E38<G39),AND(G37>M37,E38>G39)),E38,\"\")","v":""},{"$f":"IF(AND(AND(G39=E38,J37<>G37),AND(G39=E38,G37<>M37)),E38,\"\")","v":""},{"$f":"IF(OR(AND(E38<(G39+(K39-G39)/2),E38>G39,G37<M37),AND(E38>(G39+(K39-G39)/2),E38<G39,G37>M37)),E38,\"\")","v":""},{"$f":"IF(AND((E38=(G39+(K39-G39)/2)),NOT(AND(R38=S38,S38=T38))),E38,\"\")","v":""},{"$f":"IF(OR(AND(E38>(G39+(K39-G39)/2),E38<K39,G37<M37),AND(E38<(G39+(K39-G39)/2),E38>K39,G37>M37)),E38,\"\")","v":""},{"$f":"IF(K39=E38,E38,\"\")","v":0},{"$f":"IF(OR(AND(E38<(O39+(K39-O39)/2),E38>K39,G37<M37),AND(E38>(O39+(K39-O39)/2),E38<K39,G37>M37)),E38,\"\")","v":""},{"$f":"IF(AND(E38=(K39+(O39-K39)/2),NOT(AND(R38=S38,S38=T38))),E38,\"\")","v":""},{"$f":"IF(OR(AND(E38>(O39+(K39-O39)/2),E38<O39,G37<M37),AND(E38<(O39+(K39-O39)/2),E38>O39,G37>M37)),E38,\"\")","v":""},{"$f":"IF(AND(AND(O39=E38,J37<>M37),AND(O39=E38,G37<>M37)),E38,\"\")","v":""},{"$f":"IF(OR(AND(G37<=M37,E38>O39),AND(G37>M37,E38<O39)),E38,\"\")","v":""},null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B36,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B36,\"<>\"&\"\"))),0)","v":0},{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),COUNTIF(B$8:B36,\"<>\"&\"\"))),0)","v":0}]
[{"$f":"IF(B37<>\"\",\"+\",\"\")","v":""},null,null,null,null,null,{"$f":"R38","v":0},null,null,null,{"$f":"S38","v":0},null,null,null,{"$f":"T38","v":0}]
["+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($B$8:$B$39,\"<>\"&\"*.*\",U$8:U$39)","v":0}]
["+","Информация по результативности процессов (в части КПЭ и СоЦ) руководителя:",null,"Представлено",null,null,"Представлено не в полной мере",null,null,null,null,"Не представлено"]
["+",1,"Подписанная карта"]
["+",2,"Утвержденные паспорта"]
["+",3,"Мониторинг исполнения по ключевым проектам"]
["+",4,"Уставы/ др.документы по  ключевым проектам"]
["+",5,"Подписанный актуальный СоЦ"]
["+",6,"Информация по курируемым ДЗО"]
["+"]
["+","Примечание: файл заполнять не нужно. Данный файл представлен как визуализация мониторинга исполнения."]