{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Даты","Карта КПЭ_год","Мониторинг КПЭ_ежекв","Оценка","Мониторинг КП_ежекв","Оценка проектов (по году)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Карта КПЭ_год","index":1,"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]]}
[null,"Индивидуальная карта"]
[]
[null,"ФИО работника:","Фамилия Имя Отчество",null,null,null,null,null,null,null,null,"Оценка результативности за I квартал 2019 года"," I квартал","Мониторинг по ключевым проектам за I квартал 2019 года"]
[null,"Должность:","Должность 1",null,null,null,null,null,null,null,null,"Оценка результативности за I полугодие 2019 года"," I полугодие","Мониторинг по ключевым проектам за I полугодие 2019 года"]
[null,"Подразделение:","Цех",null,null,null,null,null,null,null,null,"Оценка результативности за 9 месяцев 2019 года"," 9 месяцев","Мониторинг по ключевым проектам за 9 месяцев 2019 года"]
[null,"ФИО и должность непосредственного\nруководителя работника: ","Фамилия Имя Отчество-2",null,null,null,null,null,null,null,null,"Оценка результативности за 2019 год"," год","Мониторинг по ключевым проектам за 2019 год"]
[]
["№\nп.п.","КПЭ ","Характеристики КПЭ ",null,null,null,"Целевое значение\n(план)",null,"Плановые уровни эффективности"]
[null,null,"Вид ","Описание","Формула расчёта ","Вес ","Единица измерения","Значение","Нижний ","Целевой ","Верхний "]
[1,"Показатель 1","Количественный","Описание 1","Формула расчёта 1",0.3,"%",100,0.9,1,1.1000000000000001]
[2,"Показатель 2","Количественный","Описание 2","Формула расчёта 2",0.25,"%",100,0.9,1,1.1000000000000001]
[3,"Показатель 3","Качественный","Описание 3","Формула расчёта 3",0.3,"балл",8,0.75,1,1.25]
[4,"Показатель 4","Качественный","Описание 4","Формула расчёта 4",0.15,"балл",8,0.75,1,1.25]
["","-","-","-","-","-","-","-","-","-","-"]
["","-","-","-","-","-","-","-","-","-","-"]
["","-","-","-","-","-","-","-","-","-","-"]
["","-","-","-","-","-","-","-","-","-","-"]
["","-","-","-","-","-","-","-","-","-","-"]
["","-","-","-","-","-","-","-","-","-","-"]
[{"$f":"IF($B$23=\"\",\"\",\" \")","v":" "},"Итого:",null,null,null,{"$f":"SUM(IF(ISNUMBER(A10:A19),F10:F19,))","v":1}]
[{"$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":""},"",null,null,null,null,null,null,null,null,null,{"$f":"B25","v":""}]
[{"$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":2,"n_rows":21,"n_cols":28,"rows_kept":21,"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,21,4,26],[4,28,8,28],[6,0,8,0],[6,1,8,1],[6,2,8,2],[6,3,6,5],[6,6,8,6],[6,20,8,20],[7,18,7,19],[4,3,4,6],[4,7,4,12],[4,14,4,19],[6,7,6,9],[6,10,6,12],[6,13,8,13],[6,14,6,16],[6,17,6,19],[6,33,6,35],[7,21,8,21],[7,22,7,23],[7,24,8,24],[7,25,7,26],[7,30,8,30],[7,31,7,32],[7,33,8,33],[7,34,7,35],[7,37,7,38],[6,36,6,38],[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],[7,17,8,17],[6,21,6,23],[6,24,6,26],[6,27,8,27],[6,29,8,29],[6,30,6,32],[7,36,8,36]]}
[null,null,null,{"$f":"\"Мониторинг карты КПЭ за \"&D7&\" \"&LEFT(E8,4)&\" года\"","v":"Мониторинг карты КПЭ за I квартал 2019 года"},null,null,null,{"$f":"\"Мониторинг карты КПЭ за \"&K7&\" \"&LEFT(L8,4)&\" года\"","v":"Мониторинг карты КПЭ за 1 полугодие 2019 года"},null,null,null,null,null,null,{"$f":"\"Мониторинг карты КПЭ за \"&R7&\" \"&LEFT(S8,4)&\" года\"","v":"Мониторинг карты КПЭ за 9 месяцев 2019 года"},null,null,null,null,null,null,{"$f":"\"Мониторинг карты КПЭ за \"&LEFT(Z8,4)&\" год\"","v":"Мониторинг карты КПЭ за 2019 год"},null,null,null,null,null," I квартал"]
[null,null,null,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,{"$f":"'Карта КПЭ_год'!C3","v":"Фамилия Имя Отчество"},null,null,null,{"$f":"$D3","v":"Фамилия Имя Отчество"},null,null,null,null,null,null,{"$f":"$D3","v":"Фамилия Имя Отчество"},null,null,null,null,null,null,{"$f":"$D3","v":"Фамилия Имя Отчество"},null,null,null,null,null," 9 месяцев"]
[null,"Должность:",null,{"$f":"'Карта КПЭ_год'!C4","v":"Должность 1"},null,null,null,{"$f":"$D4","v":"Должность 1"},null,null,null,null,null,null,{"$f":"$D4","v":"Должность 1"},null,null,null,null,null,null,{"$f":"$D4","v":"Должность 1"}]
[null,"Подразделение:",null,{"$f":"'Карта КПЭ_год'!C5","v":"Цех"},null,null,null,{"$f":"$D5","v":"Цех"},null,null,null,null,null,null,{"$f":"$D5","v":"Цех"},null,null,null,null,null,null,{"$f":"$D5","v":"Цех"}]
[]
["№\nп.п.","КПЭ ","Единица измерения","I квартал",null,null,{"$f":"IF(SUMPRODUCT(--(IF(F11:F21<>\"-\",IF(E11:E21<>\"Да\",F11:F21,0),0)>(IF(E11:E21<>\"-\",IF(E11:E21<>\"Да\",E11:E21,0),0))*1.01),--(G11:G21=\"\"))+SUMPRODUCT(--(IF(F11:F21<>\"-\",IF(E11:E21<>\"Да\",F11:F21,0),0)<(IF(E11:E21<>\"-\",IF(E11:E21<>\"Да\",E11:E21,0),0))*0.99),--(G11:G21=\"\"))=0,\"Примечание\n(причины отклонения от плана)\",\"Не все примечания заполнены. МОНИТОРИНГ НЕ ПРИНИМАЕТСЯ!!!\")","v":"Примечание\n(причины отклонения от плана)"},"II квартал",null,null,"1 полугодие",null,null,{"$f":"IF(IF(TODAY()>=DATE(LEFT(L8,4),7,1),SUMPRODUCT(--(IF(M11:M21<>\"-\",IF(L11:L21<>\"Да\",M11:M21,0),0)>(IF(L11:L21<>\"-\",IF(L11:L21<>\"Да\",L11:L21,0),0))*1.01),--(N11:N21=\"\"))+SUMPRODUCT(--(IF(M11:M21<>\"-\",IF(L11:L21<>\"Да\",M11:M21,0),0)<(IF(L11:L21<>\"-\",IF(L11:L21<>\"Да\",L11:L21,0),0))*0.99),--(N11:N21=\"\"))=0,\"ИСТИНА\"),\"Примечание\n(причины отклонения от плана)\",\"Не все примечания заполнены. МОНИТОРИНГ НЕ ПРИНИМАЕТСЯ!!!\")","v":"Примечание\n(причины отклонения от плана)"},"III квартал",null,null,"9 месяцев",null,null,{"$f":"IF(IF(TODAY()>=DATE(LEFT(S8,4),10,1),SUMPRODUCT(--(IF(T11:T21<>\"-\",IF(S11:S21<>\"Да\",T11:T21,0),0)>(IF(S11:S21<>\"-\",IF(S11:S21<>\"Да\",S11:S21,0),0))*1.01),--(U11:U21=\"\"))+SUMPRODUCT(--(IF(T11:T21<>\"-\",IF(S11:S21<>\"Да\",T11:T21,0),0)<(IF(S11:S21<>\"-\",IF(S11:S21<>\"Да\",S11:S21,0),0))*0.99),--(U11:U21=\"\"))=0,\"ИСТИНА\"),\"Примечание\n(причины отклонения от плана)\",\"Не все примечания заполнены. МОНИТОРИНГ НЕ ПРИНИМАЕТСЯ!!!\")","v":"Примечание\n(причины отклонения от плана)"},"IV квартал",null,null,"ГОД",null,null,{"$f":"IF(IF(TODAY()>=DATE(LEFT(Z8,4)+1,1,1),SUMPRODUCT(--(IF(AA11:AA21<>\"-\",IF(Z11:Z21<>\"Да\",AA11:AA21,0),0)>(IF(Z11:Z21<>\"-\",IF(Z11:Z21<>\"Да\",Z11:Z21,0),0))*1.01),--(AB11:AB21=\"\"))+SUMPRODUCT(--(IF(AA11:AA21<>\"-\",IF(Z11:Z21<>\"Да\",AA11:AA21,0),0)<(IF(Z11:Z21<>\"-\",IF(Z11:Z21<>\"Да\",Z11:Z21,0),0))*0.99),--(AB11:AB21=\"\"))=0,\"ИСТИНА\"),\"Примечание\n(причины отклонения от плана)\",\"Не все примечания заполнены. МОНИТОРИНГ НЕ ПРИНИМАЕТСЯ!!!\")","v":"Примечание\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," год"]
[1,"Показатель 1","%"]
[2,"Показатель 2","%"]
[3,"Показатель 3","балл"]
[4,"Показатель 4","балл"]
["","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["."]

{"sheet":"Оценка","index":3,"n_rows":47,"n_cols":23,"rows_kept":47,"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,20,10,20],[9,21,9,22],[10,6,10,8],[10,9,10,11],[10,12,10,14],[11,16,13,16],[12,3,13,3],[12,4,13,4],[9,16,10,16],[9,17,9,19],[11,1,13,1],[11,2,13,2],[11,6,11,8],[11,9,11,11],[11,12,11,14],[17,16,19,16],[18,3,19,3],[18,4,19,4],[14,1,16,1],[14,2,16,2],[14,6,14,8],[14,9,14,11],[14,12,14,14],[14,16,16,16],[15,3,16,3],[15,4,16,4],[17,1,19,1],[17,2,19,2],[17,6,17,8],[17,9,17,11],[17,12,17,14],[23,16,25,16],[24,3,25,3],[24,4,25,4],[20,1,22,1],[20,2,22,2],[20,6,20,8],[20,9,20,11],[20,12,20,14],[20,16,22,16],[21,3,22,3],[21,4,22,4],[23,1,25,1],[23,2,25,2],[23,6,23,8],[23,9,23,11],[23,12,23,14],[29,16,31,16],[30,3,31,3],[30,4,31,4],[26,1,28,1],[26,2,28,2],[26,6,26,8],[26,9,26,11],[26,12,26,14],[26,16,28,16],[27,3,28,3],[27,4,28,4],[29,1,31,1],[29,2,31,2],[29,6,29,8],[29,9,29,11],[29,12,29,14],[35,16,37,16],[36,3,37,3],[36,4,37,4],[32,1,34,1],[32,2,34,2],[32,6,32,8],[32,9,32,11],[32,12,32,14],[32,16,34,16],[33,3,34,3],[33,4,34,4],[35,1,37,1],[35,2,37,2],[35,6,35,8],[35,9,35,11],[35,12,35,14],[43,1,43,21],[44,1,44,21],[38,1,40,1],[38,2,40,2],[38,6,38,8],[38,9,38,11],[38,12,38,14],[38,16,40,16],[39,3,40,3],[39,4,40,4]]}
[null,null,"В ячейке D3 необходимо выбрать период мониторинга из выпадающего списка"]
[]
[{"$f":"INDEX('Карта КПЭ_год'!$M$3:$M$6,MATCH($B$3,'Карта КПЭ_год'!$L$3:$L$6,0),1)","v":" I полугодие"},"Оценка результативности за I полугодие 2019 года"]
[]
[null,null,"ФИО работника:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$3:$AB$3,,IF(A3=\" I квартал\",-1,-4),,),1,MATCH(A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Фамилия Имя Отчество"}]
[null,null,"Должность:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$4:$AB$4,,IF(A3=\" I квартал\",-1,-4),,),1,MATCH(A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Должность 1"}]
[null,null,"Подразделение:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$5:$AB$5,,IF(A3=\" I квартал\",-1,-4),,),1,MATCH(A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Цех"}]
[null,null,"ФИО и должность непосредственного\nруководителя работника: ",{"$f":"'Карта КПЭ_год'!C6","v":"Фамилия Имя Отчество-2"}]
[]
[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,"нижний","целевой/ план","верхний",null,"Факт.ур-нь выполнения","Квзв."]
[{"$f":"IF(B12<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B11,\"<>\"&\"\"))),\"\")","v":1},"Показатель 1","%",0,null,0,null,null,0,null,null,0,null,null,null,0,{"$f":"IFERROR(IF(S12<=0,(1-R13+1)*S12,S12*R13),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B12,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S12<=0,(1-T13+1)*S12,S12*T13),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B12,'Карта КПЭ_год'!$A$10:$A$21,0),1),U9)","v":0.3},{"$f":"IF(OR(E12=\"\",AND(R13=\"-\",T13=\"-\",E12<S12),AND(R13=\"-\",E12<S12)),0,IF(OR(AND(T13=\"-\",E13>=S13),AND(R13=\"-\",T13=\"-\",E13=S13),E12=S12),1,IF(AND(T13=\"-\",E12>=R12,E12<S12),1-((E12-S12)/(S12*R13-S12))*ABS(1-0.8),IF(OR(AND(S12<0,E13>S13,E13<=T13),AND(T13>S13,R13=\"-\",E13>S13,E13<=T13)),(1+ABS(1.2-1))-(((T13-E13)/(T13-S13))*ABS(1.2-1)),IF(AND(T13>S13,R13=\"-\",E13>=T13),1.2,IF(AND(S12<0,E13>=R13,E13<S13),1-((E13-S13)/(R13-S13))*ABS(1-0.8),IF(AND(R13=T13,E13/100=R13,E13/100=S13,E13/100=T13),1,IF(AND(R13=T13,E13/100<>R13,E13/100<>S13,E13/100<>T13),0,IF(OR(AND(T13>R13,E12<S12*R13),AND(T13<R13,E12>S12*R13)),0,IF(OR(AND(T13>R13,E12>=S12*T13),AND(T13<R13,E12<=S12*T13)),1.2,IF(T13>R13,IF(AND(E12>=S12*R13,E12<=S12*S13),1-((ABS(S12-E12)/(S12-S12*R13))*(1-0.8)),(1+ABS(1.2-1))-(((S12*T13-E12)/(S12*T13-S12))*ABS(1.2-1))),IF(AND(E12<S12*R13,E12>=S12*S13),1-((E12-S12)/(S12*R13-S12))*ABS(1-0.8),(1+ABS(1.2-1))-(((S12*T13-E12)/(S12*T13-S12))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U12=\"-\",0,V12*U12)","v":0.3}]
[{"$f":"IF(B12<>\"\",\"+\",\"\")","v":"+"},null,null,"%",1,"","","","","",1,"","","","","",null,{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$I$10:$I$22,MATCH($B12,'Карта КПЭ_год'!$A$10:$A$21,0),1),R10)","v":0.9},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$J$10:$J$22,MATCH($B12,'Карта КПЭ_год'!$A$10:$A$21,0),1),S10)","v":1},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$K$10:$K$22,MATCH($B12,'Карта КПЭ_год'!$A$10:$A$21,0),1),T10)","v":1.1000000000000001}]
[{"$f":"IF(B12<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,0.9,null,null,null,1,null,null,null,1.1000000000000001]
[{"$f":"IF(B15<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B14,\"<>\"&\"\"))),\"\")","v":2},"Показатель 2","%",0,null,0,null,null,0,null,null,0,null,null,null,0,{"$f":"IFERROR(IF(S15<=0,(1-R16+1)*S15,S15*R16),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B15,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S15<=0,(1-T16+1)*S15,S15*T16),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B15,'Карта КПЭ_год'!$A$10:$A$21,0),1),U12)","v":0.25},{"$f":"IF(OR(E15=\"\",AND(R16=\"-\",T16=\"-\",E15<S15),AND(R16=\"-\",E15<S15)),0,IF(OR(AND(T16=\"-\",E16>=S16),AND(R16=\"-\",T16=\"-\",E16=S16),E15=S15),1,IF(AND(T16=\"-\",E15>=R15,E15<S15),1-((E15-S15)/(S15*R16-S15))*ABS(1-0.8),IF(OR(AND(S15<0,E16>S16,E16<=T16),AND(T16>S16,R16=\"-\",E16>S16,E16<=T16)),(1+ABS(1.2-1))-(((T16-E16)/(T16-S16))*ABS(1.2-1)),IF(AND(T16>S16,R16=\"-\",E16>=T16),1.2,IF(AND(S15<0,E16>=R16,E16<S16),1-((E16-S16)/(R16-S16))*ABS(1-0.8),IF(AND(R16=T16,E16/100=R16,E16/100=S16,E16/100=T16),1,IF(AND(R16=T16,E16/100<>R16,E16/100<>S16,E16/100<>T16),0,IF(OR(AND(T16>R16,E15<S15*R16),AND(T16<R16,E15>S15*R16)),0,IF(OR(AND(T16>R16,E15>=S15*T16),AND(T16<R16,E15<=S15*T16)),1.2,IF(T16>R16,IF(AND(E15>=S15*R16,E15<=S15*S16),1-((ABS(S15-E15)/(S15-S15*R16))*(1-0.8)),(1+ABS(1.2-1))-(((S15*T16-E15)/(S15*T16-S15))*ABS(1.2-1))),IF(AND(E15<S15*R16,E15>=S15*S16),1-((E15-S15)/(S15*R16-S15))*ABS(1-0.8),(1+ABS(1.2-1))-(((S15*T16-E15)/(S15*T16-S15))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U15=\"-\",0,V15*U15)","v":0.25}]
[{"$f":"IF(B15<>\"\",\"+\",\"\")","v":"+"},null,null,"%",1,"","","","","",1,"","","","","",null,{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$I$10:$I$22,MATCH($B15,'Карта КПЭ_год'!$A$10:$A$21,0),1),R13)","v":0.9},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$J$10:$J$22,MATCH($B15,'Карта КПЭ_год'!$A$10:$A$21,0),1),S13)","v":1},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$K$10:$K$22,MATCH($B15,'Карта КПЭ_год'!$A$10:$A$21,0),1),T13)","v":1.1000000000000001}]
[{"$f":"IF(B15<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,0.9,null,null,null,1,null,null,null,1.1000000000000001]
[{"$f":"IF(B18<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B17,\"<>\"&\"\"))),\"\")","v":3},"Показатель 3","балл",0,null,0,null,null,0,null,null,0,null,null,null,0,{"$f":"IFERROR(IF(S18<=0,(1-R19+1)*S18,S18*R19),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B18,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S18<=0,(1-T19+1)*S18,S18*T19),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B18,'Карта КПЭ_год'!$A$10:$A$21,0),1),U15)","v":0.3},{"$f":"IF(OR(E18=\"\",AND(R19=\"-\",T19=\"-\",E18<S18),AND(R19=\"-\",E18<S18)),0,IF(OR(AND(T19=\"-\",E19>=S19),AND(R19=\"-\",T19=\"-\",E19=S19),E18=S18),1,IF(AND(T19=\"-\",E18>=R18,E18<S18),1-((E18-S18)/(S18*R19-S18))*ABS(1-0.8),IF(OR(AND(S18<0,E19>S19,E19<=T19),AND(T19>S19,R19=\"-\",E19>S19,E19<=T19)),(1+ABS(1.2-1))-(((T19-E19)/(T19-S19))*ABS(1.2-1)),IF(AND(T19>S19,R19=\"-\",E19>=T19),1.2,IF(AND(S18<0,E19>=R19,E19<S19),1-((E19-S19)/(R19-S19))*ABS(1-0.8),IF(AND(R19=T19,E19/100=R19,E19/100=S19,E19/100=T19),1,IF(AND(R19=T19,E19/100<>R19,E19/100<>S19,E19/100<>T19),0,IF(OR(AND(T19>R19,E18<S18*R19),AND(T19<R19,E18>S18*R19)),0,IF(OR(AND(T19>R19,E18>=S18*T19),AND(T19<R19,E18<=S18*T19)),1.2,IF(T19>R19,IF(AND(E18>=S18*R19,E18<=S18*S19),1-((ABS(S18-E18)/(S18-S18*R19))*(1-0.8)),(1+ABS(1.2-1))-(((S18*T19-E18)/(S18*T19-S18))*ABS(1.2-1))),IF(AND(E18<S18*R19,E18>=S18*S19),1-((E18-S18)/(S18*R19-S18))*ABS(1-0.8),(1+ABS(1.2-1))-(((S18*T19-E18)/(S18*T19-S18))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U18=\"-\",0,V18*U18)","v":0.3}]
[{"$f":"IF(B18<>\"\",\"+\",\"\")","v":"+"},null,null,"%",1,"","","","","",1,"","","","","",null,{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$I$10:$I$22,MATCH($B18,'Карта КПЭ_год'!$A$10:$A$21,0),1),R16)","v":0.75},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$J$10:$J$22,MATCH($B18,'Карта КПЭ_год'!$A$10:$A$21,0),1),S16)","v":1},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$K$10:$K$22,MATCH($B18,'Карта КПЭ_год'!$A$10:$A$21,0),1),T16)","v":1.25}]
[{"$f":"IF(B18<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,0.75,null,null,null,1,null,null,null,1.25]
[{"$f":"IF(B21<>\"\",\"+\",\"\")","v":"+"},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B20,\"<>\"&\"\"))),\"\")","v":4},"Показатель 4","балл",0,null,0,null,null,0,null,null,0,null,null,null,0,{"$f":"IFERROR(IF(S21<=0,(1-R22+1)*S21,S21*R22),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B21,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S21<=0,(1-T22+1)*S21,S21*T22),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B21,'Карта КПЭ_год'!$A$10:$A$21,0),1),U18)","v":0.15},{"$f":"IF(OR(E21=\"\",AND(R22=\"-\",T22=\"-\",E21<S21),AND(R22=\"-\",E21<S21)),0,IF(OR(AND(T22=\"-\",E22>=S22),AND(R22=\"-\",T22=\"-\",E22=S22),E21=S21),1,IF(AND(T22=\"-\",E21>=R21,E21<S21),1-((E21-S21)/(S21*R22-S21))*ABS(1-0.8),IF(OR(AND(S21<0,E22>S22,E22<=T22),AND(T22>S22,R22=\"-\",E22>S22,E22<=T22)),(1+ABS(1.2-1))-(((T22-E22)/(T22-S22))*ABS(1.2-1)),IF(AND(T22>S22,R22=\"-\",E22>=T22),1.2,IF(AND(S21<0,E22>=R22,E22<S22),1-((E22-S22)/(R22-S22))*ABS(1-0.8),IF(AND(R22=T22,E22/100=R22,E22/100=S22,E22/100=T22),1,IF(AND(R22=T22,E22/100<>R22,E22/100<>S22,E22/100<>T22),0,IF(OR(AND(T22>R22,E21<S21*R22),AND(T22<R22,E21>S21*R22)),0,IF(OR(AND(T22>R22,E21>=S21*T22),AND(T22<R22,E21<=S21*T22)),1.2,IF(T22>R22,IF(AND(E21>=S21*R22,E21<=S21*S22),1-((ABS(S21-E21)/(S21-S21*R22))*(1-0.8)),(1+ABS(1.2-1))-(((S21*T22-E21)/(S21*T22-S21))*ABS(1.2-1))),IF(AND(E21<S21*R22,E21>=S21*S22),1-((E21-S21)/(S21*R22-S21))*ABS(1-0.8),(1+ABS(1.2-1))-(((S21*T22-E21)/(S21*T22-S21))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U21=\"-\",0,V21*U21)","v":0.15}]
[{"$f":"IF(B21<>\"\",\"+\",\"\")","v":"+"},null,null,"%",1,"","","","","",1,"","","","","",null,{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$I$10:$I$22,MATCH($B21,'Карта КПЭ_год'!$A$10:$A$21,0),1),R19)","v":0.75},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$J$10:$J$22,MATCH($B21,'Карта КПЭ_год'!$A$10:$A$21,0),1),S19)","v":1},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$K$10:$K$22,MATCH($B21,'Карта КПЭ_год'!$A$10:$A$21,0),1),T19)","v":1.25}]
[{"$f":"IF(B21<>\"\",\"+\",\"\")","v":"+"},null,null,null,null,null,0.75,null,null,null,1,null,null,null,1.25]
[{"$f":"IF(B24<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B23,\"<>\"&\"\"))),\"\")","v":""},"-","-",0,null,"-",null,null,0,null,null,"-",null,null,null,0,{"$f":"IFERROR(IF(S24<=0,(1-R25+1)*S24,S24*R25),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B24,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S24<=0,(1-T25+1)*S24,S24*T25),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B24,'Карта КПЭ_год'!$A$10:$A$21,0),1),U21)","v":"-"},{"$f":"IF(OR(E24=\"\",AND(R25=\"-\",T25=\"-\",E24<S24),AND(R25=\"-\",E24<S24)),0,IF(OR(AND(T25=\"-\",E25>=S25),AND(R25=\"-\",T25=\"-\",E25=S25),E24=S24),1,IF(AND(T25=\"-\",E24>=R24,E24<S24),1-((E24-S24)/(S24*R25-S24))*ABS(1-0.8),IF(OR(AND(S24<0,E25>S25,E25<=T25),AND(T25>S25,R25=\"-\",E25>S25,E25<=T25)),(1+ABS(1.2-1))-(((T25-E25)/(T25-S25))*ABS(1.2-1)),IF(AND(T25>S25,R25=\"-\",E25>=T25),1.2,IF(AND(S24<0,E25>=R25,E25<S25),1-((E25-S25)/(R25-S25))*ABS(1-0.8),IF(AND(R25=T25,E25/100=R25,E25/100=S25,E25/100=T25),1,IF(AND(R25=T25,E25/100<>R25,E25/100<>S25,E25/100<>T25),0,IF(OR(AND(T25>R25,E24<S24*R25),AND(T25<R25,E24>S24*R25)),0,IF(OR(AND(T25>R25,E24>=S24*T25),AND(T25<R25,E24<=S24*T25)),1.2,IF(T25>R25,IF(AND(E24>=S24*R25,E24<=S24*S25),1-((ABS(S24-E24)/(S24-S24*R25))*(1-0.8)),(1+ABS(1.2-1))-(((S24*T25-E24)/(S24*T25-S24))*ABS(1.2-1))),IF(AND(E24<S24*R25,E24>=S24*S25),1-((E24-S24)/(S24*R25-S24))*ABS(1-0.8),(1+ABS(1.2-1))-(((S24*T25-E24)/(S24*T25-S24))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U24=\"-\",0,V24*U24)","v":0}]
[{"$f":"IF(B24<>\"\",\"+\",\"\")","v":""},null,null,"%",1,"","","","","","","","","","","",null,{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$I$10:$I$22,MATCH($B24,'Карта КПЭ_год'!$A$10:$A$21,0),1),R22)","v":"-"},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$J$10:$J$22,MATCH($B24,'Карта КПЭ_год'!$A$10:$A$21,0),1),S22)","v":"-"},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$K$10:$K$22,MATCH($B24,'Карта КПЭ_год'!$A$10:$A$21,0),1),T22)","v":"-"}]
[{"$f":"IF(B24<>\"\",\"+\",\"\")","v":""},null,null,null,null,null,"-",null,null,null,"-",null,null,null,"-"]
[{"$f":"IF(B27<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B26,\"<>\"&\"\"))),\"\")","v":""},"-","-",0,null,"-",null,null,0,null,null,"-",null,null,null,0,{"$f":"IFERROR(IF(S27<=0,(1-R28+1)*S27,S27*R28),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B27,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S27<=0,(1-T28+1)*S27,S27*T28),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B27,'Карта КПЭ_год'!$A$10:$A$21,0),1),U24)","v":"-"},{"$f":"IF(OR(E27=\"\",AND(R28=\"-\",T28=\"-\",E27<S27),AND(R28=\"-\",E27<S27)),0,IF(OR(AND(T28=\"-\",E28>=S28),AND(R28=\"-\",T28=\"-\",E28=S28),E27=S27),1,IF(AND(T28=\"-\",E27>=R27,E27<S27),1-((E27-S27)/(S27*R28-S27))*ABS(1-0.8),IF(OR(AND(S27<0,E28>S28,E28<=T28),AND(T28>S28,R28=\"-\",E28>S28,E28<=T28)),(1+ABS(1.2-1))-(((T28-E28)/(T28-S28))*ABS(1.2-1)),IF(AND(T28>S28,R28=\"-\",E28>=T28),1.2,IF(AND(S27<0,E28>=R28,E28<S28),1-((E28-S28)/(R28-S28))*ABS(1-0.8),IF(AND(R28=T28,E28/100=R28,E28/100=S28,E28/100=T28),1,IF(AND(R28=T28,E28/100<>R28,E28/100<>S28,E28/100<>T28),0,IF(OR(AND(T28>R28,E27<S27*R28),AND(T28<R28,E27>S27*R28)),0,IF(OR(AND(T28>R28,E27>=S27*T28),AND(T28<R28,E27<=S27*T28)),1.2,IF(T28>R28,IF(AND(E27>=S27*R28,E27<=S27*S28),1-((ABS(S27-E27)/(S27-S27*R28))*(1-0.8)),(1+ABS(1.2-1))-(((S27*T28-E27)/(S27*T28-S27))*ABS(1.2-1))),IF(AND(E27<S27*R28,E27>=S27*S28),1-((E27-S27)/(S27*R28-S27))*ABS(1-0.8),(1+ABS(1.2-1))-(((S27*T28-E27)/(S27*T28-S27))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U27=\"-\",0,V27*U27)","v":0}]
[{"$f":"IF(B27<>\"\",\"+\",\"\")","v":""},null,null,"%",1,"","","","","","","","","","","",null,{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$I$10:$I$22,MATCH($B27,'Карта КПЭ_год'!$A$10:$A$21,0),1),R25)","v":"-"},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$J$10:$J$22,MATCH($B27,'Карта КПЭ_год'!$A$10:$A$21,0),1),S25)","v":"-"},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$K$10:$K$22,MATCH($B27,'Карта КПЭ_год'!$A$10:$A$21,0),1),T25)","v":"-"}]
[{"$f":"IF(B27<>\"\",\"+\",\"\")","v":""},null,null,null,null,null,"-",null,null,null,"-",null,null,null,"-"]
[{"$f":"IF(B30<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B29,\"<>\"&\"\"))),\"\")","v":""},"-","-",0,null,"-",null,null,0,null,null,"-",null,null,null,0,{"$f":"IFERROR(IF(S30<=0,(1-R31+1)*S30,S30*R31),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B30,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S30<=0,(1-T31+1)*S30,S30*T31),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B30,'Карта КПЭ_год'!$A$10:$A$21,0),1),U27)","v":"-"},{"$f":"IF(OR(E30=\"\",AND(R31=\"-\",T31=\"-\",E30<S30),AND(R31=\"-\",E30<S30)),0,IF(OR(AND(T31=\"-\",E31>=S31),AND(R31=\"-\",T31=\"-\",E31=S31),E30=S30),1,IF(AND(T31=\"-\",E30>=R30,E30<S30),1-((E30-S30)/(S30*R31-S30))*ABS(1-0.8),IF(OR(AND(S30<0,E31>S31,E31<=T31),AND(T31>S31,R31=\"-\",E31>S31,E31<=T31)),(1+ABS(1.2-1))-(((T31-E31)/(T31-S31))*ABS(1.2-1)),IF(AND(T31>S31,R31=\"-\",E31>=T31),1.2,IF(AND(S30<0,E31>=R31,E31<S31),1-((E31-S31)/(R31-S31))*ABS(1-0.8),IF(AND(R31=T31,E31/100=R31,E31/100=S31,E31/100=T31),1,IF(AND(R31=T31,E31/100<>R31,E31/100<>S31,E31/100<>T31),0,IF(OR(AND(T31>R31,E30<S30*R31),AND(T31<R31,E30>S30*R31)),0,IF(OR(AND(T31>R31,E30>=S30*T31),AND(T31<R31,E30<=S30*T31)),1.2,IF(T31>R31,IF(AND(E30>=S30*R31,E30<=S30*S31),1-((ABS(S30-E30)/(S30-S30*R31))*(1-0.8)),(1+ABS(1.2-1))-(((S30*T31-E30)/(S30*T31-S30))*ABS(1.2-1))),IF(AND(E30<S30*R31,E30>=S30*S31),1-((E30-S30)/(S30*R31-S30))*ABS(1-0.8),(1+ABS(1.2-1))-(((S30*T31-E30)/(S30*T31-S30))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U30=\"-\",0,V30*U30)","v":0}]
[{"$f":"IF(B30<>\"\",\"+\",\"\")","v":""},null,null,"%",1,"","","","","","","","","","","",null,{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$I$10:$I$22,MATCH($B30,'Карта КПЭ_год'!$A$10:$A$21,0),1),R28)","v":"-"},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$J$10:$J$22,MATCH($B30,'Карта КПЭ_год'!$A$10:$A$21,0),1),S28)","v":"-"},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$K$10:$K$22,MATCH($B30,'Карта КПЭ_год'!$A$10:$A$21,0),1),T28)","v":"-"}]
[{"$f":"IF(B30<>\"\",\"+\",\"\")","v":""},null,null,null,null,null,"-",null,null,null,"-",null,null,null,"-"]
[{"$f":"IF(B33<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B32,\"<>\"&\"\"))),\"\")","v":""},"-","-",0,null,"-",null,null,0,null,null,"-",null,null,null,0,{"$f":"IFERROR(IF(S33<=0,(1-R34+1)*S33,S33*R34),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B33,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S33<=0,(1-T34+1)*S33,S33*T34),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B33,'Карта КПЭ_год'!$A$10:$A$21,0),1),U30)","v":"-"},{"$f":"IF(OR(E33=\"\",AND(R34=\"-\",T34=\"-\",E33<S33),AND(R34=\"-\",E33<S33)),0,IF(OR(AND(T34=\"-\",E34>=S34),AND(R34=\"-\",T34=\"-\",E34=S34),E33=S33),1,IF(AND(T34=\"-\",E33>=R33,E33<S33),1-((E33-S33)/(S33*R34-S33))*ABS(1-0.8),IF(OR(AND(S33<0,E34>S34,E34<=T34),AND(T34>S34,R34=\"-\",E34>S34,E34<=T34)),(1+ABS(1.2-1))-(((T34-E34)/(T34-S34))*ABS(1.2-1)),IF(AND(T34>S34,R34=\"-\",E34>=T34),1.2,IF(AND(S33<0,E34>=R34,E34<S34),1-((E34-S34)/(R34-S34))*ABS(1-0.8),IF(AND(R34=T34,E34/100=R34,E34/100=S34,E34/100=T34),1,IF(AND(R34=T34,E34/100<>R34,E34/100<>S34,E34/100<>T34),0,IF(OR(AND(T34>R34,E33<S33*R34),AND(T34<R34,E33>S33*R34)),0,IF(OR(AND(T34>R34,E33>=S33*T34),AND(T34<R34,E33<=S33*T34)),1.2,IF(T34>R34,IF(AND(E33>=S33*R34,E33<=S33*S34),1-((ABS(S33-E33)/(S33-S33*R34))*(1-0.8)),(1+ABS(1.2-1))-(((S33*T34-E33)/(S33*T34-S33))*ABS(1.2-1))),IF(AND(E33<S33*R34,E33>=S33*S34),1-((E33-S33)/(S33*R34-S33))*ABS(1-0.8),(1+ABS(1.2-1))-(((S33*T34-E33)/(S33*T34-S33))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U33=\"-\",0,V33*U33)","v":0}]
[{"$f":"IF(B33<>\"\",\"+\",\"\")","v":""},null,null,"%",1,"","","","","","","","","","","",null,{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$I$10:$I$22,MATCH($B33,'Карта КПЭ_год'!$A$10:$A$21,0),1),R31)","v":"-"},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$J$10:$J$22,MATCH($B33,'Карта КПЭ_год'!$A$10:$A$21,0),1),S31)","v":"-"},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$K$10:$K$22,MATCH($B33,'Карта КПЭ_год'!$A$10:$A$21,0),1),T31)","v":"-"}]
[{"$f":"IF(B33<>\"\",\"+\",\"\")","v":""},null,null,null,null,null,"-",null,null,null,"-",null,null,null,"-"]
[{"$f":"IF(B36<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B35,\"<>\"&\"\"))),\"\")","v":""},"-","-",0,null,"-",null,null,0,null,null,"-",null,null,null,0,{"$f":"IFERROR(IF(S36<=0,(1-R37+1)*S36,S36*R37),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B36,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S36<=0,(1-T37+1)*S36,S36*T37),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B36,'Карта КПЭ_год'!$A$10:$A$21,0),1),U33)","v":"-"},{"$f":"IF(OR(E36=\"\",AND(R37=\"-\",T37=\"-\",E36<S36),AND(R37=\"-\",E36<S36)),0,IF(OR(AND(T37=\"-\",E37>=S37),AND(R37=\"-\",T37=\"-\",E37=S37),E36=S36),1,IF(AND(T37=\"-\",E36>=R36,E36<S36),1-((E36-S36)/(S36*R37-S36))*ABS(1-0.8),IF(OR(AND(S36<0,E37>S37,E37<=T37),AND(T37>S37,R37=\"-\",E37>S37,E37<=T37)),(1+ABS(1.2-1))-(((T37-E37)/(T37-S37))*ABS(1.2-1)),IF(AND(T37>S37,R37=\"-\",E37>=T37),1.2,IF(AND(S36<0,E37>=R37,E37<S37),1-((E37-S37)/(R37-S37))*ABS(1-0.8),IF(AND(R37=T37,E37/100=R37,E37/100=S37,E37/100=T37),1,IF(AND(R37=T37,E37/100<>R37,E37/100<>S37,E37/100<>T37),0,IF(OR(AND(T37>R37,E36<S36*R37),AND(T37<R37,E36>S36*R37)),0,IF(OR(AND(T37>R37,E36>=S36*T37),AND(T37<R37,E36<=S36*T37)),1.2,IF(T37>R37,IF(AND(E36>=S36*R37,E36<=S36*S37),1-((ABS(S36-E36)/(S36-S36*R37))*(1-0.8)),(1+ABS(1.2-1))-(((S36*T37-E36)/(S36*T37-S36))*ABS(1.2-1))),IF(AND(E36<S36*R37,E36>=S36*S37),1-((E36-S36)/(S36*R37-S36))*ABS(1-0.8),(1+ABS(1.2-1))-(((S36*T37-E36)/(S36*T37-S36))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U36=\"-\",0,V36*U36)","v":0}]
[{"$f":"IF(B36<>\"\",\"+\",\"\")","v":""},null,null,"%",1,"","","","","","","","","","","",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,"-",null,null,null,"-",null,null,null,"-"]
[{"$f":"IF(B39<>\"\",\"+\",\"\")","v":""},{"$f":"IFERROR(INDEX('Мониторинг КПЭ_ежекв'!$A$11:$A$20,SMALL(IF('Мониторинг КПЭ_ежекв'!$A$11:$A$20<>\"\",ROW('Мониторинг КПЭ_ежекв'!$A$11:$A$20)-ROW('Мониторинг КПЭ_ежекв'!$A$10)),COUNTIF(B$10:B38,\"<>\"&\"\"))),\"\")","v":""},"-","-",0,null,"-",null,null,0,null,null,"-",null,null,null,0,{"$f":"IFERROR(IF(S39<=0,(1-R40+1)*S39,S39*R40),0)","v":0},{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$11:$E$21,,MATCH($A$3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0)-1,,),MATCH($B39,'Мониторинг КПЭ_ежекв'!$A$11:$A$21,0))","v":0},{"$f":"IFERROR(IF(S39<=0,(1-T40+1)*S39,S39*T40),0)","v":0},{"$f":"IFERROR(INDEX('Карта КПЭ_год'!$F$10:$F$22,MATCH($B39,'Карта КПЭ_год'!$A$10:$A$21,0),1),U36)","v":"-"},{"$f":"IF(OR(E39=\"\",AND(R40=\"-\",T40=\"-\",E39<S39),AND(R40=\"-\",E39<S39)),0,IF(OR(AND(T40=\"-\",E40>=S40),AND(R40=\"-\",T40=\"-\",E40=S40),E39=S39),1,IF(AND(T40=\"-\",E39>=R39,E39<S39),1-((E39-S39)/(S39*R40-S39))*ABS(1-0.8),IF(OR(AND(S39<0,E40>S40,E40<=T40),AND(T40>S40,R40=\"-\",E40>S40,E40<=T40)),(1+ABS(1.2-1))-(((T40-E40)/(T40-S40))*ABS(1.2-1)),IF(AND(T40>S40,R40=\"-\",E40>=T40),1.2,IF(AND(S39<0,E40>=R40,E40<S40),1-((E40-S40)/(R40-S40))*ABS(1-0.8),IF(AND(R40=T40,E40/100=R40,E40/100=S40,E40/100=T40),1,IF(AND(R40=T40,E40/100<>R40,E40/100<>S40,E40/100<>T40),0,IF(OR(AND(T40>R40,E39<S39*R40),AND(T40<R40,E39>S39*R40)),0,IF(OR(AND(T40>R40,E39>=S39*T40),AND(T40<R40,E39<=S39*T40)),1.2,IF(T40>R40,IF(AND(E39>=S39*R40,E39<=S39*S40),1-((ABS(S39-E39)/(S39-S39*R40))*(1-0.8)),(1+ABS(1.2-1))-(((S39*T40-E39)/(S39*T40-S39))*ABS(1.2-1))),IF(AND(E39<S39*R40,E39>=S39*S40),1-((E39-S39)/(S39*R40-S39))*ABS(1-0.8),(1+ABS(1.2-1))-(((S39*T40-E39)/(S39*T40-S39))*ABS(1.2-1))))))))))))))","v":1},{"$f":"IF(U39=\"-\",0,V39*U39)","v":0}]
[{"$f":"IF(B39<>\"\",\"+\",\"\")","v":""},null,null,"%",1,"","","","","","","","","","","",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,"-",null,null,null,"-",null,null,null,"-"]
["+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($B$10:$B$41,\"<>\"&\"*.*\",U$10:U$41)","v":1}]
[{"$f":"IF(B41<>\"\",\"+\",\"\")","v":""}]
[{"$f":"IF(B42<>\"\",\"+\",\"\")","v":""},"Итоговый коэффициент исполнения по карте КПЭ (без нормализации)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($B$12:$B$41,\"<>\"&\"*.*\",$W$12:$W$41)","v":1}]
[{"$f":"IF(B43<>\"\",\"+\",\"\")","v":""},"Итоговый коэффициент исполнения по карте КПЭ для премирования (с нормализацией)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($B$15:$B$47,\"<>\"&\"*.*\",$W$12:$W$41)","v":1}]
[{"$f":"IF(B46<>\"\",\"+\",\"\")","v":""}]
[" ","Примечание: Данный файл представлен как визуализация мониторинга исполнения."]

{"sheet":"Мониторинг КП_ежекв","index":4,"n_rows":74,"n_cols":15,"rows_kept":74,"cut":false,"hidden":false,"merged":[[9,3,37,3],[9,4,37,5],[0,1,0,4],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,6,7],[6,8,7,8],[6,9,6,10],[6,11,7,11],[6,12,6,14],[39,3,49,3],[39,4,49,5],[51,3,57,3],[51,4,57,5],[59,3,65,3],[59,4,65,5],[67,3,73,3],[67,4,73,5]]}
[null,{"$f":"INDEX('Карта КПЭ_год'!$N$3:$N$6,MATCH(Оценка!$B$3,'Карта КПЭ_год'!$L$3:$L$6,0),1)","v":"Мониторинг по ключевым проектам за I полугодие 2019 года"}]
[]
[{"$f":"LEFT(SUBSTITUTE(RIGHT(MID(\" \"&SUBSTITUTE(D3,\" \",REPT(\" \",999)),1,999*2),999),\" \",\"\"),1)&\".\"&LEFT(SUBSTITUTE(RIGHT(MID(\" \"&SUBSTITUTE(D3,\" \",REPT(\" \",999)),1,999*3),999),\" \",\"\"),1)&\". \"&MID(D3,1,FIND(\" \",D3,1)-1)","v":"И.О. Фамилия"},null,"ФИО работника:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$3:$AB$3,,IF(Оценка!$A$3=\" I квартал\",-1,-4),,),1,MATCH(Оценка!A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Фамилия Имя Отчество"}]
[null,null,"Должность:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$4:$AB$4,,IF(Оценка!$A$3=\" I квартал\",-1,-4),,),1,MATCH(Оценка!A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Должность 1"}]
[null,null,"Подразделение:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$5:$AB$5,,IF(Оценка!$A$3=\" I квартал\",-1,-4),,),1,MATCH(Оценка!A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Цех"}]
[]
[null,"№\nп.п.","Наименование проекта","Заказчик / Инициатор\nпроекта\n(И.О. Фамилия)","Куратор\nпроекта\n(И.О. Фамилия)","Руководитель\nпроекта\n(И.О. Фамилия)","Качество / Результат этапа\n(показатели эффективности)",null,"Текущий статус по проекту (причины отклонений по критерию Качество)","График\n(срок реализации этапа, проекта), дата",null,"Текущий статус по проекту (причины отклонений по критерию График)","Бюджет\n(затраты/инвестиции на реализацию этапа проекта, проекта)"]
[null,null,null,null,null,null,"План","Факт",null,"План","Факт",null,"План","Факт","Ед.изм."]
["+",1,"Проект 1","И.О. Фамилия 1","И.О. Фамилия 2","И.О. Фамилия 3"]
["+"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+"]
["+"]
["+"]
[]
[]
[]
["+"]
[]
["+"]
["+"]
["+",2,"Проект 2","И.О. Фамилия 1","И.О. Фамилия 2","И.О. Фамилия 3"]
["+"]
["+"]
["+"]
["+"]
[]
[]
["+"]
[]
[]
["+"]
["+"]
["",3,"-","И.О. Фамилия 1","И.О. Фамилия 2","И.О. Фамилия 3"]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
[""]
["",4,"-","И.О. Фамилия 1","И.О. Фамилия 2","И.О. Фамилия 3"]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
[""]
["",5,"-","И.О. Фамилия 1","И.О. Фамилия 2","И.О. Фамилия 3"]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
[""]

{"sheet":"Оценка проектов (по году)","index":5,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[[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],[6,8,6,9]]}
[null,"Итоговый балл по показателю ''Реализация ключевых проектов'' за 2019 год"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(SUM(D10:D14)<>100%,SUM(K10:M14)/COUNTIF(C10:C14,\"<>\"&\"-\")<>100%,COUNTIFS($K$10:$M$14,\"<>\"&\"\",$K$10:$M$14,\"<\"&20%)),\"СУММА по КРИТЕРИЯМ ''Качество'' и ''График'' НЕ РАВНА 100%, либо ВЕС КРИТЕРИЯ менее 20% (ИСПРАВИТЬ!!!)\",\"\")","v":""}]
[null,null,"ФИО работника:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$3:$AB$3,,IF(Оценка!$A$3=\" I квартал\",-1,-4),,),1,MATCH(Оценка!A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Фамилия Имя Отчество"}]
[null,null,"Должность:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$4:$AB$4,,IF(Оценка!$A$3=\" I квартал\",-1,-4),,),1,MATCH(Оценка!A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Должность 1"}]
[null,null,"Подразделение:",{"$f":"INDEX(OFFSET('Мониторинг КПЭ_ежекв'!$E$5:$AB$5,,IF(Оценка!$A$3=\" I квартал\",-1,-4),,),1,MATCH(Оценка!A3,'Мониторинг КПЭ_ежекв'!$E$10:$AB$10,0))","v":"Цех"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(COUNTIF($D$10:$D$14,\"<\"&20%)<>0,D15<>100%),\"СУММА ВЕСОВ проектов НЕ РАВНА 100%, либо ВЕС ПРОЕКТА МЕНЕЕ 20% (ИСПРАВИТЬ!!!)\",\"\")","v":""}]
[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]
["+",1,"Проект 1",0.5,8,null,8,null,8,null,0.6,0.4,null,8,0,0,0,0,0]
["+",2,"Проект 2",0.5,8,null,8,null,8,null,0.6,0.4,null,8,0,0,0,0,0]
["",3,"-",null,8,null,8,null,8,null,null,null,null,8,0,0,0,0,0]
["",4,"-",null,8,null,8,null,8,null,null,null,null,8,0,0,0,0,0]
["",5,"-",null,8,null,8,null,8,null,null,null,null,8,0,0,0,0,0]
["+","Итоговое значение Проектов **",null,1,null,null,null,null,null,null,null,null,null,8,null,null,null,0,0]
["+","."," "]