{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Карта КП_год","Мониторинг КП_ежекв","Оценка","Оценка проектов (по году)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,0,8,0],[7,1,8,1],[7,2,7,5],[7,6,7,7],[26,1,26,10],[22,1,22,10],[23,1,23,10],[24,1,24,10],[25,1,25,10],[2,2,2,7],[3,2,3,7],[4,2,4,7],[5,2,5,7],[7,8,7,10]]}
[1,"Индивидуальная карта "]
[]
[null,"ФИО работника:",null,null,null,null,null,null,null,null,null,"Оценка результативности за I квартал 2019 года"," I квартал","Шаблон мониторинга по ключевым проектам I квартал 2019 года"]
[null,"Должность:",null,null,null,null,null,null,null,null,null,"Оценка результативности за I полугодие 2019 года"," I полугодие","Шаблон мониторинга по ключевым проектам I полугодие 2019 года"]
[null,"Подразделение:",null,null,null,null,null,null,null,null,null,"Оценка результативности за 9 месяцев 2019 года"," 9 месяцев","Шаблон мониторинга по ключевым проектам 9 месяцев 2019 года"]
[null,"ФИО и должность непосредственного\nруководителя работника: ",null,null,null,null,null,null,null,null,null,"Оценка результативности за 2019 год"," год","Шаблон мониторинга по ключевым проектам 2019 года"]
[]
["№\nп.п.","КПЭ ","Характеристики КПЭ ",null,null,null,"Целевое значение\n(план)",null,"Плановые уровни эффективности"]
[null,null,"Вид ","Описание","Формула расчёта ","Вес ","Единица измерения","Значение","Нижний ","Целевой ","Верхний "]
[1,"Показатель 1"]
[2,"Показатель 2"]
[3,"Показатель 3"]
[4,"Показатель 4"]
[5,"Показатель 5"]
[6,"Показатель 6"]
["","-","-","-","-","-","-","-","-","-","-"]
["","-","-","-","-","-","-","-","-","-","-"]
["","-","-","-","-","-","-","-","-","-","-"]
["","-","-","-","-","-","-","-","-","-","-"]
[{"$f":"IF($B$23=\"\",\"\",\" \")","v":" "},"Итого:",null,null,null,{"$f":"SUM(IF(ISNUMBER(A10:A19),F10:F19,))","v":0}]
[{"$f":"IF($B$22=\"\",\"\",\" \")","v":" "}," "]
[{"$f":"IF($B$22=\"\",\"\",\" \")","v":" "},"Ключевые проекты:"]
[{"$f":"IF(B23=\"\",\"\",IF(NOT(ISERROR(FIND(\"Профессионализм от первого лица\",B23,1))),\" \",MAX(A$22:A22)+1))","v":1},"Проект 1",null,null,null,null,null,null,null,null,null,{"$f":"B23","v":"Проект 1"}]
[{"$f":"IF(B24=\"\",\"\",IF(NOT(ISERROR(FIND(\"Профессионализм от первого лица\",B24,1))),\" \",MAX(A$22:A23)+1))","v":2},"Проект 2",null,null,null,null,null,null,null,null,null,{"$f":"B24","v":"Проект 2"}]
[{"$f":"IF(B25=\"\",\"\",IF(NOT(ISERROR(FIND(\"Профессионализм от первого лица\",B25,1))),\" \",MAX(A$22:A24)+1))","v":3},"Проект 3",null,null,null,null,null,null,null,null,null,{"$f":"B25","v":"Проект 3"}]
[{"$f":"IF(B26=\"\",\"\",IF(NOT(ISERROR(FIND(\"Профессионализм от первого лица\",B26,1))),\" \",MAX(A$22:A25)+1))","v":""},"",null,null,null,null,null,null,null,null,null,{"$f":"B26","v":""}]
[{"$f":"IF(B27=\"\",\"\",IF(NOT(ISERROR(FIND(\"Профессионализм от первого лица\",B27,1))),\" \",MAX(A$22:A26)+1))","v":""},""]

{"sheet":"Мониторинг КП_ежекв","index":1,"n_rows":28,"n_cols":28,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,3,2,6],[2,7,2,12],[2,14,2,19],[2,21,2,26],[3,3,3,6],[3,7,3,12],[3,14,3,19],[3,21,3,26],[4,3,4,6],[4,7,4,12],[4,14,4,19],[4,21,4,26],[6,0,8,0],[6,1,8,1],[6,2,8,2],[6,3,6,5],[6,6,8,6],[6,7,6,9],[6,21,6,23],[7,17,8,17],[7,18,7,19],[7,21,8,21],[7,22,7,23],[7,24,8,24],[6,24,6,26],[6,27,8,27],[7,3,8,3],[7,4,7,5],[7,7,8,7],[7,8,7,9],[7,10,8,10],[7,11,7,12],[7,14,8,14],[7,15,7,16],[6,10,6,12],[6,13,8,13],[6,14,6,16],[6,17,6,19],[6,20,8,20],[7,25,7,26],[23,0,23,2],[24,0,24,2],[26,0,26,1],[27,0,27,1]]}
[]
[]
[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,null,"2018г.\n(факт)","2019г.",null,null,{"$f":"$D$8","v":"2018г.\n(факт)"},{"$f":"$E$8","v":"2019г."},null,{"$f":"$D$8","v":"2018г.\n(факт)"},{"$f":"$E$8","v":"2019г."},null,null,{"$f":"$D$8","v":"2018г.\n(факт)"},{"$f":"$E$8","v":"2019г."},null,{"$f":"$D$8","v":"2018г.\n(факт)"},{"$f":"$E$8","v":"2019г."},null,null,{"$f":"$D$8","v":"2018г.\n(факт)"},{"$f":"$E$8","v":"2019г."},null,{"$f":"$D$8","v":"2018г.\n(факт)"},{"$f":"$E$8","v":"2019г."}]
[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," год"]
[{"$f":"IFERROR(INDEX('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A1))),\"\")","v":1},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A11,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"Показатель 1"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A11,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":0},null,1,1.0109999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1922]
["1.2.","анрвыораво"]
["1.1.","варываыо","руб./чел.день"]
[{"$f":"IFERROR(INDEX('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A2))),\"\")","v":2},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A14,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"Показатель 2"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A14,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21629]
[{"$f":"IFERROR(INDEX('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A3))),\"\")","v":3},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A15,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"Показатель 3"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A15,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8904]
[{"$f":"IFERROR(INDEX('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A4))),\"\")","v":4},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A16,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"Показатель 4"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A16,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[{"$f":"IFERROR(INDEX('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A5))),\"\")","v":5},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A17,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"Показатель 5"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A17,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[{"$f":"IFERROR(INDEX('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A6))),\"\")","v":6},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A18,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"Показатель 6"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A18,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[{"$f":"IFERROR(INDEX('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A7))),\"\")","v":""},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A19,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A19,'Карта КП_год'!$A$10:$A$19,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('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A8))),\"\")","v":""},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A20,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A20,'Карта КП_год'!$A$10:$A$19,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('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A9))),\"\")","v":""},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A21,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A21,'Карта КП_год'!$A$10:$A$19,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('Карта КП_год'!$A$10:$A$19,SMALL(IF('Карта КП_год'!$A$10:$A$19<>\"\",ROW('Карта КП_год'!$A$10:$A$19)-ROW('Карта КП_год'!$A$9)),ROW(A10))),\"\")","v":""},{"$f":"IFERROR(INDEX('Карта КП_год'!$B$10:$B$19,MATCH($A22,'Карта КП_год'!$A$10:$A$19,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX('Карта КП_год'!$G$10:$G$19,MATCH($A22,'Карта КП_год'!$A$10:$A$19,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,"-"]
["."]
[]
[]
["Легенда:"]
["ячейки для ввода данных в файле"]
["ячейки для ввода данных по наступлению соответствующего периода"]

{"sheet":"Оценка","index":2,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,9,15],[2,1,2,3],[4,3,4,16],[5,3,5,16],[6,3,6,16],[7,3,7,16],[9,16,10,16],[9,17,9,19],[9,20,10,20],[10,6,10,8],[10,9,10,11],[10,12,10,14],[14,16,16,16],[15,3,16,3],[15,4,16,4],[11,1,13,1],[11,2,13,2],[11,6,11,8],[11,9,11,11],[11,12,11,14],[11,16,13,16],[12,3,13,3],[12,4,13,4],[14,1,16,1],[14,2,16,2],[14,6,14,8],[14,9,14,11],[14,12,14,14],[20,16,22,16],[21,3,22,3],[21,4,22,4],[17,1,19,1],[17,2,19,2],[17,6,17,8],[17,9,17,11],[17,12,17,14],[17,16,19,16],[18,3,19,3],[18,4,19,4],[20,1,22,1],[20,2,22,2],[20,6,20,8],[20,9,20,11],[20,12,20,14],[26,16,28,16],[27,3,28,3],[27,4,28,4],[23,1,25,1],[23,2,25,2],[23,6,23,8],[23,9,23,11],[23,12,23,14],[23,16,25,16],[24,3,25,3],[24,4,25,4],[26,1,28,1],[26,2,28,2],[26,6,26,8],[26,9,26,11],[26,12,26,14],[32,16,34,16],[33,3,34,3],[33,4,34,4],[29,1,31,1],[29,2,31,2],[29,6,29,8],[29,9,29,11],[29,12,29,14],[29,16,31,16],[30,3,31,3],[30,4,31,4],[32,1,34,1],[32,2,34,2],[32,6,32,8],[32,9,32,11],[32,12,32,14],[38,16,40,16],[39,3,40,3],[39,4,40,4],[35,1,37,1],[35,2,37,2],[35,6,35,8],[35,9,35,11],[35,12,35,14],[35,16,37,16],[36,3,37,3],[36,4,37,4],[38,1,40,1],[38,2,40,2],[38,6,38,8],[38,9,38,11],[38,12,38,14]]}
[null,"Необходимо выбрать период мониторинга из выпадающего списка (в ячейке D3)"]
[]
[{"$f":"INDEX('Карта КП_год'!$M$3:$M$6,MATCH($B$3,'Карта КП_год'!$L$3:$L$6,0),1)","v":" год"},"Оценка результативности за 2019 год"]
[]
[null,null,"ФИО работника:"]
[null,null,"Должность:"]
[null,null,"Подразделение:"]
[null,null,"ФИО и должность непосредственного\nруководителя работника: "]
[null,null,null,null,null,14000,15262.65058643886,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(B12<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B11,\"<>\"&\"\"))),\"\")","v":1},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C11,\"<>\"&\"\"))),\"\")","v":"Показатель 1"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C11,\"<>\"&\"\"))),\"\")","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C12,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R12","v":0},null,null,{"$f":"S12","v":1922},null,null,{"$f":"T12","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C12,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S12*R13,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C12,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":1922},{"$f":"IFERROR(S12*T13,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B12,'Карта КП_год'!$A$10:$A$21,0),1),U9)","v":0}]
[{"$f":"IF(B12<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E12=\"Да\",100%,IF(E12=\"Нет\",0%,IFERROR(E12/S12,0)))","v":0},{"$f":"IF(OR(AND(G12<=M12,E13<G14),AND(G12>M12,E13>G14)),E13,\"\")","v":""},{"$f":"IF(AND(AND(G14=E13,J12<>G12),AND(G14=E13,G12<>M12)),E13,\"\")","v":""},{"$f":"IF(OR(AND(E13<(G14+(K14-G14)/2),E13>G14,G12<M12),AND(E13>(G14+(K14-G14)/2),E13<G14,G12>M12)),E13,\"\")","v":""},{"$f":"IF(AND((E13=(G14+(K14-G14)/2)),NOT(AND(R13=S13,S13=T13))),E13,\"\")","v":""},{"$f":"IF(OR(AND(E13>(G14+(K14-G14)/2),E13<K14,G12<M12),AND(E13<(G14+(K14-G14)/2),E13>K14,G12>M12)),E13,\"\")","v":""},{"$f":"IF(K14=E13,E13,\"\")","v":0},{"$f":"IF(OR(AND(E13<(O14+(K14-O14)/2),E13>K14,G12<M12),AND(E13>(O14+(K14-O14)/2),E13<K14,G12>M12)),E13,\"\")","v":""},{"$f":"IF(AND(E13=(K14+(O14-K14)/2),NOT(AND(R13=S13,S13=T13))),E13,\"\")","v":""},{"$f":"IF(OR(AND(E13>(O14+(K14-O14)/2),E13<O14,G12<M12),AND(E13<(O14+(K14-O14)/2),E13>O14,G12>M12)),E13,\"\")","v":""},{"$f":"IF(AND(AND(O14=E13,J12<>M12),AND(O14=E13,G12<>M12)),E13,\"\")","v":""},{"$f":"IF(OR(AND(G12<=M12,E13>O14),AND(G12>M12,E13<O14)),E13,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B12,'Карта КП_год'!$A$10:$A$21,0),1),R10)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B12,'Карта КП_год'!$A$10:$A$21,0),1),S10)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B12,'Карта КП_год'!$A$10:$A$21,0),1),T10)","v":0}]
[{"$f":"IF(B12<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R13","v":0},null,null,null,{"$f":"S13","v":0},null,null,null,{"$f":"T13","v":0}]
[{"$f":"IF(B15<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B14,\"<>\"&\"\"))),\"\")","v":"1.2."},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C14,\"<>\"&\"\"))),\"\")","v":"анрвыораво"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C14,\"<>\"&\"\"))),\"\")","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C15,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R15","v":0},null,null,{"$f":"S15","v":0},null,null,{"$f":"T15","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C15,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S15*R16,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C15,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":0},{"$f":"IFERROR(S15*T16,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B15,'Карта КП_год'!$A$10:$A$21,0),1),U12)","v":0}]
[{"$f":"IF(B15<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E15=\"Да\",100%,IF(E15=\"Нет\",0%,IFERROR(E15/S15,0)))","v":0},{"$f":"IF(OR(AND(G15<=M15,E16<G17),AND(G15>M15,E16>G17)),E16,\"\")","v":""},{"$f":"IF(AND(AND(G17=E16,J15<>G15),AND(G17=E16,G15<>M15)),E16,\"\")","v":""},{"$f":"IF(OR(AND(E16<(G17+(K17-G17)/2),E16>G17,G15<M15),AND(E16>(G17+(K17-G17)/2),E16<G17,G15>M15)),E16,\"\")","v":""},{"$f":"IF(AND((E16=(G17+(K17-G17)/2)),NOT(AND(R16=S16,S16=T16))),E16,\"\")","v":""},{"$f":"IF(OR(AND(E16>(G17+(K17-G17)/2),E16<K17,G15<M15),AND(E16<(G17+(K17-G17)/2),E16>K17,G15>M15)),E16,\"\")","v":""},{"$f":"IF(K17=E16,E16,\"\")","v":0},{"$f":"IF(OR(AND(E16<(O17+(K17-O17)/2),E16>K17,G15<M15),AND(E16>(O17+(K17-O17)/2),E16<K17,G15>M15)),E16,\"\")","v":""},{"$f":"IF(AND(E16=(K17+(O17-K17)/2),NOT(AND(R16=S16,S16=T16))),E16,\"\")","v":""},{"$f":"IF(OR(AND(E16>(O17+(K17-O17)/2),E16<O17,G15<M15),AND(E16<(O17+(K17-O17)/2),E16>O17,G15>M15)),E16,\"\")","v":""},{"$f":"IF(AND(AND(O17=E16,J15<>M15),AND(O17=E16,G15<>M15)),E16,\"\")","v":""},{"$f":"IF(OR(AND(G15<=M15,E16>O17),AND(G15>M15,E16<O17)),E16,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B15,'Карта КП_год'!$A$10:$A$21,0),1),R13)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B15,'Карта КП_год'!$A$10:$A$21,0),1),S13)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B15,'Карта КП_год'!$A$10:$A$21,0),1),T13)","v":0}]
[{"$f":"IF(B15<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R16","v":0},null,null,null,{"$f":"S16","v":0},null,null,null,{"$f":"T16","v":0}]
[{"$f":"IF(B18<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B17,\"<>\"&\"\"))),\"\")","v":"1.1."},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C17,\"<>\"&\"\"))),\"\")","v":"варываыо"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C17,\"<>\"&\"\"))),\"\")","v":"руб./чел.день"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C18,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R18","v":0},null,null,{"$f":"S18","v":0},null,null,{"$f":"T18","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C18,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S18*R19,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C18,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":0},{"$f":"IFERROR(S18*T19,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B18,'Карта КП_год'!$A$10:$A$21,0),1),U15)","v":0}]
[{"$f":"IF(B18<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E18=\"Да\",100%,IF(E18=\"Нет\",0%,IFERROR(E18/S18,0)))","v":0},{"$f":"IF(OR(AND(G18<=M18,E19<G20),AND(G18>M18,E19>G20)),E19,\"\")","v":""},{"$f":"IF(AND(AND(G20=E19,J18<>G18),AND(G20=E19,G18<>M18)),E19,\"\")","v":""},{"$f":"IF(OR(AND(E19<(G20+(K20-G20)/2),E19>G20,G18<M18),AND(E19>(G20+(K20-G20)/2),E19<G20,G18>M18)),E19,\"\")","v":""},{"$f":"IF(AND((E19=(G20+(K20-G20)/2)),NOT(AND(R19=S19,S19=T19))),E19,\"\")","v":""},{"$f":"IF(OR(AND(E19>(G20+(K20-G20)/2),E19<K20,G18<M18),AND(E19<(G20+(K20-G20)/2),E19>K20,G18>M18)),E19,\"\")","v":""},{"$f":"IF(K20=E19,E19,\"\")","v":0},{"$f":"IF(OR(AND(E19<(O20+(K20-O20)/2),E19>K20,G18<M18),AND(E19>(O20+(K20-O20)/2),E19<K20,G18>M18)),E19,\"\")","v":""},{"$f":"IF(AND(E19=(K20+(O20-K20)/2),NOT(AND(R19=S19,S19=T19))),E19,\"\")","v":""},{"$f":"IF(OR(AND(E19>(O20+(K20-O20)/2),E19<O20,G18<M18),AND(E19<(O20+(K20-O20)/2),E19>O20,G18>M18)),E19,\"\")","v":""},{"$f":"IF(AND(AND(O20=E19,J18<>M18),AND(O20=E19,G18<>M18)),E19,\"\")","v":""},{"$f":"IF(OR(AND(G18<=M18,E19>O20),AND(G18>M18,E19<O20)),E19,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B18,'Карта КП_год'!$A$10:$A$21,0),1),R16)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B18,'Карта КП_год'!$A$10:$A$21,0),1),S16)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B18,'Карта КП_год'!$A$10:$A$21,0),1),T16)","v":0}]
[{"$f":"IF(B18<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R19","v":0},null,null,null,{"$f":"S19","v":0},null,null,null,{"$f":"T19","v":0}]
[{"$f":"IF(B21<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B20,\"<>\"&\"\"))),\"\")","v":2},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C20,\"<>\"&\"\"))),\"\")","v":"Показатель 2"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C20,\"<>\"&\"\"))),\"\")","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C21,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R21","v":0},null,null,{"$f":"S21","v":21629},null,null,{"$f":"T21","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C21,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S21*R22,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C21,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":21629},{"$f":"IFERROR(S21*T22,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B21,'Карта КП_год'!$A$10:$A$21,0),1),U18)","v":0}]
[{"$f":"IF(B21<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E21=\"Да\",100%,IF(E21=\"Нет\",0%,IFERROR(E21/S21,0)))","v":0},{"$f":"IF(OR(AND(G21<=M21,E22<G23),AND(G21>M21,E22>G23)),E22,\"\")","v":""},{"$f":"IF(AND(AND(G23=E22,J21<>G21),AND(G23=E22,G21<>M21)),E22,\"\")","v":""},{"$f":"IF(OR(AND(E22<(G23+(K23-G23)/2),E22>G23,G21<M21),AND(E22>(G23+(K23-G23)/2),E22<G23,G21>M21)),E22,\"\")","v":""},{"$f":"IF(AND((E22=(G23+(K23-G23)/2)),NOT(AND(R22=S22,S22=T22))),E22,\"\")","v":""},{"$f":"IF(OR(AND(E22>(G23+(K23-G23)/2),E22<K23,G21<M21),AND(E22<(G23+(K23-G23)/2),E22>K23,G21>M21)),E22,\"\")","v":""},{"$f":"IF(K23=E22,E22,\"\")","v":0},{"$f":"IF(OR(AND(E22<(O23+(K23-O23)/2),E22>K23,G21<M21),AND(E22>(O23+(K23-O23)/2),E22<K23,G21>M21)),E22,\"\")","v":""},{"$f":"IF(AND(E22=(K23+(O23-K23)/2),NOT(AND(R22=S22,S22=T22))),E22,\"\")","v":""},{"$f":"IF(OR(AND(E22>(O23+(K23-O23)/2),E22<O23,G21<M21),AND(E22<(O23+(K23-O23)/2),E22>O23,G21>M21)),E22,\"\")","v":""},{"$f":"IF(AND(AND(O23=E22,J21<>M21),AND(O23=E22,G21<>M21)),E22,\"\")","v":""},{"$f":"IF(OR(AND(G21<=M21,E22>O23),AND(G21>M21,E22<O23)),E22,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B21,'Карта КП_год'!$A$10:$A$21,0),1),R19)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B21,'Карта КП_год'!$A$10:$A$21,0),1),S19)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B21,'Карта КП_год'!$A$10:$A$21,0),1),T19)","v":0}]
[{"$f":"IF(B21<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R22","v":0},null,null,null,{"$f":"S22","v":0},null,null,null,{"$f":"T22","v":0}]
[{"$f":"IF(B24<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B23,\"<>\"&\"\"))),\"\")","v":3},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C23,\"<>\"&\"\"))),\"\")","v":"Показатель 3"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C23,\"<>\"&\"\"))),\"\")","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C24,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R24","v":0},null,null,{"$f":"S24","v":8904},null,null,{"$f":"T24","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C24,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S24*R25,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C24,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":8904},{"$f":"IFERROR(S24*T25,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B24,'Карта КП_год'!$A$10:$A$21,0),1),U21)","v":0}]
[{"$f":"IF(B24<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E24=\"Да\",100%,IF(E24=\"Нет\",0%,IFERROR(E24/S24,0)))","v":0},{"$f":"IF(OR(AND(G24<=M24,E25<G26),AND(G24>M24,E25>G26)),E25,\"\")","v":""},{"$f":"IF(AND(AND(G26=E25,J24<>G24),AND(G26=E25,G24<>M24)),E25,\"\")","v":""},{"$f":"IF(OR(AND(E25<(G26+(K26-G26)/2),E25>G26,G24<M24),AND(E25>(G26+(K26-G26)/2),E25<G26,G24>M24)),E25,\"\")","v":""},{"$f":"IF(AND((E25=(G26+(K26-G26)/2)),NOT(AND(R25=S25,S25=T25))),E25,\"\")","v":""},{"$f":"IF(OR(AND(E25>(G26+(K26-G26)/2),E25<K26,G24<M24),AND(E25<(G26+(K26-G26)/2),E25>K26,G24>M24)),E25,\"\")","v":""},{"$f":"IF(K26=E25,E25,\"\")","v":0},{"$f":"IF(OR(AND(E25<(O26+(K26-O26)/2),E25>K26,G24<M24),AND(E25>(O26+(K26-O26)/2),E25<K26,G24>M24)),E25,\"\")","v":""},{"$f":"IF(AND(E25=(K26+(O26-K26)/2),NOT(AND(R25=S25,S25=T25))),E25,\"\")","v":""},{"$f":"IF(OR(AND(E25>(O26+(K26-O26)/2),E25<O26,G24<M24),AND(E25<(O26+(K26-O26)/2),E25>O26,G24>M24)),E25,\"\")","v":""},{"$f":"IF(AND(AND(O26=E25,J24<>M24),AND(O26=E25,G24<>M24)),E25,\"\")","v":""},{"$f":"IF(OR(AND(G24<=M24,E25>O26),AND(G24>M24,E25<O26)),E25,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B24,'Карта КП_год'!$A$10:$A$21,0),1),R22)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B24,'Карта КП_год'!$A$10:$A$21,0),1),S22)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B24,'Карта КП_год'!$A$10:$A$21,0),1),T22)","v":0}]
[{"$f":"IF(B24<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R25","v":0},null,null,null,{"$f":"S25","v":0},null,null,null,{"$f":"T25","v":0}]
[{"$f":"IF(B27<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B26,\"<>\"&\"\"))),\"\")","v":4},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C26,\"<>\"&\"\"))),\"\")","v":"Показатель 4"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C26,\"<>\"&\"\"))),\"\")","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C27,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R27","v":0},null,null,{"$f":"S27","v":17},null,null,{"$f":"T27","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C27,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S27*R28,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C27,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":17},{"$f":"IFERROR(S27*T28,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B27,'Карта КП_год'!$A$10:$A$21,0),1),U24)","v":0}]
[{"$f":"IF(B27<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E27=\"Да\",100%,IF(E27=\"Нет\",0%,IFERROR(E27/S27,0)))","v":0},{"$f":"IF(OR(AND(G27<=M27,E28<G29),AND(G27>M27,E28>G29)),E28,\"\")","v":""},{"$f":"IF(AND(AND(G29=E28,J27<>G27),AND(G29=E28,G27<>M27)),E28,\"\")","v":""},{"$f":"IF(OR(AND(E28<(G29+(K29-G29)/2),E28>G29,G27<M27),AND(E28>(G29+(K29-G29)/2),E28<G29,G27>M27)),E28,\"\")","v":""},{"$f":"IF(AND((E28=(G29+(K29-G29)/2)),NOT(AND(R28=S28,S28=T28))),E28,\"\")","v":""},{"$f":"IF(OR(AND(E28>(G29+(K29-G29)/2),E28<K29,G27<M27),AND(E28<(G29+(K29-G29)/2),E28>K29,G27>M27)),E28,\"\")","v":""},{"$f":"IF(K29=E28,E28,\"\")","v":0},{"$f":"IF(OR(AND(E28<(O29+(K29-O29)/2),E28>K29,G27<M27),AND(E28>(O29+(K29-O29)/2),E28<K29,G27>M27)),E28,\"\")","v":""},{"$f":"IF(AND(E28=(K29+(O29-K29)/2),NOT(AND(R28=S28,S28=T28))),E28,\"\")","v":""},{"$f":"IF(OR(AND(E28>(O29+(K29-O29)/2),E28<O29,G27<M27),AND(E28<(O29+(K29-O29)/2),E28>O29,G27>M27)),E28,\"\")","v":""},{"$f":"IF(AND(AND(O29=E28,J27<>M27),AND(O29=E28,G27<>M27)),E28,\"\")","v":""},{"$f":"IF(OR(AND(G27<=M27,E28>O29),AND(G27>M27,E28<O29)),E28,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B27,'Карта КП_год'!$A$10:$A$21,0),1),R25)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B27,'Карта КП_год'!$A$10:$A$21,0),1),S25)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B27,'Карта КП_год'!$A$10:$A$21,0),1),T25)","v":0}]
[{"$f":"IF(B27<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R28","v":0},null,null,null,{"$f":"S28","v":0},null,null,null,{"$f":"T28","v":0}]
[{"$f":"IF(B30<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B29,\"<>\"&\"\"))),\"\")","v":5},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C29,\"<>\"&\"\"))),\"\")","v":"Показатель 5"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C29,\"<>\"&\"\"))),\"\")","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C30,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R30","v":0},null,null,{"$f":"S30","v":6},null,null,{"$f":"T30","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C30,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S30*R31,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C30,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":6},{"$f":"IFERROR(S30*T31,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B30,'Карта КП_год'!$A$10:$A$21,0),1),U27)","v":0}]
[{"$f":"IF(B30<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E30=\"Да\",100%,IF(E30=\"Нет\",0%,IFERROR(E30/S30,0)))","v":0},{"$f":"IF(OR(AND(G30<=M30,E31<G32),AND(G30>M30,E31>G32)),E31,\"\")","v":""},{"$f":"IF(AND(AND(G32=E31,J30<>G30),AND(G32=E31,G30<>M30)),E31,\"\")","v":""},{"$f":"IF(OR(AND(E31<(G32+(K32-G32)/2),E31>G32,G30<M30),AND(E31>(G32+(K32-G32)/2),E31<G32,G30>M30)),E31,\"\")","v":""},{"$f":"IF(AND((E31=(G32+(K32-G32)/2)),NOT(AND(R31=S31,S31=T31))),E31,\"\")","v":""},{"$f":"IF(OR(AND(E31>(G32+(K32-G32)/2),E31<K32,G30<M30),AND(E31<(G32+(K32-G32)/2),E31>K32,G30>M30)),E31,\"\")","v":""},{"$f":"IF(K32=E31,E31,\"\")","v":0},{"$f":"IF(OR(AND(E31<(O32+(K32-O32)/2),E31>K32,G30<M30),AND(E31>(O32+(K32-O32)/2),E31<K32,G30>M30)),E31,\"\")","v":""},{"$f":"IF(AND(E31=(K32+(O32-K32)/2),NOT(AND(R31=S31,S31=T31))),E31,\"\")","v":""},{"$f":"IF(OR(AND(E31>(O32+(K32-O32)/2),E31<O32,G30<M30),AND(E31<(O32+(K32-O32)/2),E31>O32,G30>M30)),E31,\"\")","v":""},{"$f":"IF(AND(AND(O32=E31,J30<>M30),AND(O32=E31,G30<>M30)),E31,\"\")","v":""},{"$f":"IF(OR(AND(G30<=M30,E31>O32),AND(G30>M30,E31<O32)),E31,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B30,'Карта КП_год'!$A$10:$A$21,0),1),R28)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B30,'Карта КП_год'!$A$10:$A$21,0),1),S28)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B30,'Карта КП_год'!$A$10:$A$21,0),1),T28)","v":0}]
[{"$f":"IF(B30<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R31","v":0},null,null,null,{"$f":"S31","v":0},null,null,null,{"$f":"T31","v":0}]
[{"$f":"IF(B33<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B32,\"<>\"&\"\"))),\"\")","v":6},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C32,\"<>\"&\"\"))),\"\")","v":"Показатель 6"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C32,\"<>\"&\"\"))),\"\")","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C33,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R33","v":0},null,null,{"$f":"S33","v":8},null,null,{"$f":"T33","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C33,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S33*R34,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C33,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":8},{"$f":"IFERROR(S33*T34,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B33,'Карта КП_год'!$A$10:$A$21,0),1),U30)","v":0}]
[{"$f":"IF(B33<>\"\",\"+\",\"\")","v":"+"},null,null,"%",{"$f":"IF(E33=\"Да\",100%,IF(E33=\"Нет\",0%,IFERROR(E33/S33,0)))","v":0},{"$f":"IF(OR(AND(G33<=M33,E34<G35),AND(G33>M33,E34>G35)),E34,\"\")","v":""},{"$f":"IF(AND(AND(G35=E34,J33<>G33),AND(G35=E34,G33<>M33)),E34,\"\")","v":""},{"$f":"IF(OR(AND(E34<(G35+(K35-G35)/2),E34>G35,G33<M33),AND(E34>(G35+(K35-G35)/2),E34<G35,G33>M33)),E34,\"\")","v":""},{"$f":"IF(AND((E34=(G35+(K35-G35)/2)),NOT(AND(R34=S34,S34=T34))),E34,\"\")","v":""},{"$f":"IF(OR(AND(E34>(G35+(K35-G35)/2),E34<K35,G33<M33),AND(E34<(G35+(K35-G35)/2),E34>K35,G33>M33)),E34,\"\")","v":""},{"$f":"IF(K35=E34,E34,\"\")","v":0},{"$f":"IF(OR(AND(E34<(O35+(K35-O35)/2),E34>K35,G33<M33),AND(E34>(O35+(K35-O35)/2),E34<K35,G33>M33)),E34,\"\")","v":""},{"$f":"IF(AND(E34=(K35+(O35-K35)/2),NOT(AND(R34=S34,S34=T34))),E34,\"\")","v":""},{"$f":"IF(OR(AND(E34>(O35+(K35-O35)/2),E34<O35,G33<M33),AND(E34<(O35+(K35-O35)/2),E34>O35,G33>M33)),E34,\"\")","v":""},{"$f":"IF(AND(AND(O35=E34,J33<>M33),AND(O35=E34,G33<>M33)),E34,\"\")","v":""},{"$f":"IF(OR(AND(G33<=M33,E34>O35),AND(G33>M33,E34<O35)),E34,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B33,'Карта КП_год'!$A$10:$A$21,0),1),R31)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B33,'Карта КП_год'!$A$10:$A$21,0),1),S31)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B33,'Карта КП_год'!$A$10:$A$21,0),1),T31)","v":0}]
[{"$f":"IF(B33<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,{"$f":"R34","v":0},null,null,null,{"$f":"S34","v":0},null,null,null,{"$f":"T34","v":0}]
[{"$f":"IF(B36<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B35,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C35,\"<>\"&\"\"))),\"\")","v":"-"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C35,\"<>\"&\"\"))),\"\")","v":"-"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C36,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R36","v":0},null,null,{"$f":"S36","v":"-"},null,null,{"$f":"T36","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C36,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S36*R37,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C36,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":"-"},{"$f":"IFERROR(S36*T37,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B36,'Карта КП_год'!$A$10:$A$21,0),1),U33)","v":"-"}]
[{"$f":"IF(B36<>\"\",\"+\",\"\")","v":""},null,null,"%",{"$f":"IF(E36=\"Да\",100%,IF(E36=\"Нет\",0%,IFERROR(E36/S36,0)))","v":0},{"$f":"IF(OR(AND(G36<=M36,E37<G38),AND(G36>M36,E37>G38)),E37,\"\")","v":0},{"$f":"IF(AND(AND(G38=E37,J36<>G36),AND(G38=E37,G36<>M36)),E37,\"\")","v":""},{"$f":"IF(OR(AND(E37<(G38+(K38-G38)/2),E37>G38,G36<M36),AND(E37>(G38+(K38-G38)/2),E37<G38,G36>M36)),E37,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND((E37=(G38+(K38-G38)/2)),NOT(AND(R37=S37,S37=T37))),E37,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AND(E37>(G38+(K38-G38)/2),E37<K38,G36<M36),AND(E37<(G38+(K38-G38)/2),E37>K38,G36>M36)),E37,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(K38=E37,E37,\"\")","v":""},{"$f":"IF(OR(AND(E37<(O38+(K38-O38)/2),E37>K38,G36<M36),AND(E37>(O38+(K38-O38)/2),E37<K38,G36>M36)),E37,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E37=(K38+(O38-K38)/2),NOT(AND(R37=S37,S37=T37))),E37,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AND(E37>(O38+(K38-O38)/2),E37<O38,G36<M36),AND(E37<(O38+(K38-O38)/2),E37>O38,G36>M36)),E37,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(AND(O38=E37,J36<>M36),AND(O38=E37,G36<>M36)),E37,\"\")","v":""},{"$f":"IF(OR(AND(G36<=M36,E37>O38),AND(G36>M36,E37<O38)),E37,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B36,'Карта КП_год'!$A$10:$A$21,0),1),R34)","v":"-"},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B36,'Карта КП_год'!$A$10:$A$21,0),1),S34)","v":"-"},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B36,'Карта КП_год'!$A$10:$A$21,0),1),T34)","v":"-"}]
[{"$f":"IF(B36<>\"\",\"+\",\"\")","v":""},null,null,null,null,null,{"$f":"R37","v":"-"},null,null,null,{"$f":"S37","v":"-"},null,null,null,{"$f":"T37","v":"-"}]
[{"$f":"IF(B39<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$A$11:$A$22,SMALL(IF('Мониторинг КП_ежекв'!$A$11:$A$22<>\"\",ROW('Мониторинг КП_ежекв'!$A$11:$A$22)-ROW('Мониторинг КП_ежекв'!$A$10)),COUNTIF(B$10:B38,\"<>\"&\"\"))),\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$B$11:$B$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$B$11:$B$22)-ROW('Мониторинг КП_ежекв'!$B$10)),COUNTIF(C$10:C38,\"<>\"&\"\"))),\"\")","v":"-"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$C$11:$C$22,SMALL(IF('Мониторинг КП_ежекв'!$B$11:$B$22<>\"\",ROW('Мониторинг КП_ежекв'!$C$11:$C$22)-ROW('Мониторинг КП_ежекв'!$C$10)),COUNTIF(C$10:C38,\"<>\"&\"\"))),\"\")","v":"-"},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C39,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+1),0)","v":0},null,{"$f":"R39","v":0},null,null,{"$f":"S39","v":"-"},null,null,{"$f":"T39","v":0},null,null,null,{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C39,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH($A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)+2),0)","v":0},{"$f":"IFERROR(S39*R40,0)","v":0},{"$f":"IFERROR(INDEX('Мониторинг КП_ежекв'!$E$11:$AB$22,MATCH($C39,'Мониторинг КП_ежекв'!$B$11:$B$22,0),MATCH(Оценка!$A$3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0)),0)","v":"-"},{"$f":"IFERROR(S39*T40,0)","v":0},{"$f":"IFERROR(INDEX('Карта КП_год'!$F$10:$F$22,MATCH($B39,'Карта КП_год'!$A$10:$A$21,0),1),U36)","v":"-"}]
[{"$f":"IF(B39<>\"\",\"+\",\"\")","v":""},null,null,"%",{"$f":"IF(E39=\"Да\",100%,IF(E39=\"Нет\",0%,IFERROR(E39/S39,0)))","v":0},{"$f":"IF(OR(AND(G39<=M39,E40<G41),AND(G39>M39,E40>G41)),E40,\"\")","v":0},{"$f":"IF(AND(AND(G41=E40,J39<>G39),AND(G41=E40,G39<>M39)),E40,\"\")","v":""},{"$f":"IF(OR(AND(E40<(G41+(K41-G41)/2),E40>G41,G39<M39),AND(E40>(G41+(K41-G41)/2),E40<G41,G39>M39)),E40,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND((E40=(G41+(K41-G41)/2)),NOT(AND(R40=S40,S40=T40))),E40,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AND(E40>(G41+(K41-G41)/2),E40<K41,G39<M39),AND(E40<(G41+(K41-G41)/2),E40>K41,G39>M39)),E40,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(K41=E40,E40,\"\")","v":""},{"$f":"IF(OR(AND(E40<(O41+(K41-O41)/2),E40>K41,G39<M39),AND(E40>(O41+(K41-O41)/2),E40<K41,G39>M39)),E40,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E40=(K41+(O41-K41)/2),NOT(AND(R40=S40,S40=T40))),E40,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(AND(E40>(O41+(K41-O41)/2),E40<O41,G39<M39),AND(E40<(O41+(K41-O41)/2),E40>O41,G39>M39)),E40,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(AND(O41=E40,J39<>M39),AND(O41=E40,G39<>M39)),E40,\"\")","v":""},{"$f":"IF(OR(AND(G39<=M39,E40>O41),AND(G39>M39,E40<O41)),E40,\"\")","v":""},null,{"$f":"IFERROR(INDEX('Карта КП_год'!$I$10:$I$22,MATCH($B39,'Карта КП_год'!$A$10:$A$21,0),1),R37)","v":"-"},{"$f":"IFERROR(INDEX('Карта КП_год'!$J$10:$J$22,MATCH($B39,'Карта КП_год'!$A$10:$A$21,0),1),S37)","v":"-"},{"$f":"IFERROR(INDEX('Карта КП_год'!$K$10:$K$22,MATCH($B39,'Карта КП_год'!$A$10:$A$21,0),1),T37)","v":"-"}]
[{"$f":"IF(B39<>\"\",\"+\",\"\")","v":""},null,null,null,null,null,{"$f":"R40","v":"-"},null,null,null,{"$f":"S40","v":"-"},null,null,null,{"$f":"T40","v":"-"}]
["+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($B$10:$B$41,\"<>\"&\"*.*\",U$10:U$41)","v":0}]
["+"]

{"sheet":"Оценка проектов (по году)","index":3,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,8,6,9],[6,16,7,16],[6,17,7,17],[6,18,7,18],[14,1,14,2],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[6,14,7,14],[6,15,7,15],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,6,5],[6,6,6,7]]}
[null,"Итоговый балл по показателю \"Реализация ключевых проектов\" за 2018 год",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIFS($C$10:$C$14,\"<>\"&\"-\",$D$10:$D$14,\"\")+COUNTIFS($C$10:$C$14,\"<>\"&\"-\",$K$10:$K$14,\"\")+COUNTIFS($C$10:$C$14,\"<>\"&\"-\",$L$10:$L$14,\"\")>0,\"КРАСНЫЕ ПОЛЯ НЕ ЗАПОЛНЕНЫ\",\"\")","v":"КРАСНЫЕ ПОЛЯ НЕ ЗАПОЛНЕНЫ"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF($D$10:$D$14,\"<\"&0.2)<>0,\"ОДИН или НЕСКОЛЬКО ПРОЕКТОВ имеют ВЕС МЕНЕЕ 20% (ИСПРАВИТЬ!!!)\",\"\")","v":"ОДИН или НЕСКОЛЬКО ПРОЕКТОВ имеют ВЕС МЕНЕЕ 20% (ИСПРАВИТЬ!!!)"}]
[null,null,"ФИО работника:",{"$f":"INDEX(OFFSET('Мониторинг КП_ежекв'!$E$3:$AB$3,,-4,,),1,MATCH(Оценка!A3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15<>100%,\"СУММА ВЕСОВ проектов НЕ РАВНО 100% (ИСПРАВИТЬ!!!)\",\"\")","v":"СУММА ВЕСОВ проектов НЕ РАВНО 100% (ИСПРАВИТЬ!!!)"}]
[null,null,"Должность:",{"$f":"INDEX(OFFSET('Мониторинг КП_ежекв'!$E$4:$AB$4,,-4,,),1,MATCH(Оценка!A3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0))","v":0}]
[null,null,"Подразделение:",{"$f":"INDEX(OFFSET('Мониторинг КП_ежекв'!$E$5:$AB$5,,-4,,),1,MATCH(Оценка!A3,'Мониторинг КП_ежекв'!$E$10:$AB$10,0))","v":0}]
[]
[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,1,2,3,4,5,6,7,9,10,8,9,13,10,11,12,17,13,14]
[{"$f":"IF(C10<>\"-\",\"+\",\"\")","v":"+"},1,{"$f":"IFERROR(INDEX('Карта КП_год'!$B$23:$B$28,MATCH(B10,'Карта КП_год'!$A$23:$A$28,0),1),\"-\")","v":"Проект 1"},0.25,8,null,8,null,8,null,0.5,0.45,null,8,{"$f":"F10*K10/100","v":0},{"$f":"H10*L10/100","v":0},{"$f":"J10*M10","v":0},{"$f":"O10+P10+Q10","v":0},{"$f":"IF(D10=\"-\",\"-\",(R10/8)*D10)","v":0}]
[{"$f":"IF(C11<>\"-\",\"+\",\"\")","v":"+"},2,{"$f":"IFERROR(INDEX('Карта КП_год'!$B$23:$B$28,MATCH(B11,'Карта КП_год'!$A$23:$A$28,0),1),\"-\")","v":"Проект 2"},0.15,8,null,8,null,8,null,0.5,null,null,8,{"$f":"F11*K11/100","v":0},{"$f":"H11*L11/100","v":0},{"$f":"J11*M11","v":0},{"$f":"O11+P11+Q11","v":0},{"$f":"IF(D11=\"-\",\"-\",(R11/8)*D11)","v":0}]
[{"$f":"IF(C12<>\"-\",\"+\",\"\")","v":"+"},3,{"$f":"IFERROR(INDEX('Карта КП_год'!$B$23:$B$28,MATCH(B12,'Карта КП_год'!$A$23:$A$28,0),1),\"-\")","v":"Проект 3"},0.25,8,null,8,null,8,null,0.5,0.5,null,8,{"$f":"F12*K12/100","v":0},{"$f":"H12*L12/100","v":0},{"$f":"J12*M12","v":0},{"$f":"O12+P12+Q12","v":0},{"$f":"IF(D12=\"-\",\"-\",(R12/8)*D12)","v":0}]
[{"$f":"IF(C13<>\"-\",\"+\",\"\")","v":""},4,{"$f":"IFERROR(INDEX('Карта КП_год'!$B$23:$B$28,MATCH(B13,'Карта КП_год'!$A$23:$A$28,0),1),\"-\")","v":"-"},null,8,null,8,null,8,null,null,null,null,8,{"$f":"F13*K13/100","v":0},{"$f":"H13*L13/100","v":0},{"$f":"J13*M13","v":0},{"$f":"O13+P13+Q13","v":0},{"$f":"IF(D13=\"-\",\"-\",(R13/8)*D13)","v":0}]
[{"$f":"IF(C14<>\"-\",\"+\",\"\")","v":""},5,{"$f":"IFERROR(INDEX('Карта КП_год'!$B$23:$B$28,MATCH(B14,'Карта КП_год'!$A$23:$A$28,0),1),\"-\")","v":"-"},null,8,null,8,null,8,null,null,null,null,8,{"$f":"F14*K14/100","v":0},{"$f":"H14*L14/100","v":0},{"$f":"J14*M14","v":0},{"$f":"O14+P14+Q14","v":0},{"$f":"IF(D14=\"-\",\"-\",(R14/8)*D14)","v":0}]
["+","Итоговое значение Проектов **",null,{"$f":"SUM(D10:D14)","v":0.65},null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$10:$D$14,N10:N14)","v":5.2},null,null,null,{"$f":"SUMPRODUCT($D$10:$D$14,R10:R14)","v":0},{"$f":"SUM(S10:S14)","v":0}]
[null,"."," "]