{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,12,5,14],[5,9,5,11],[15,12,15,13],[15,9,15,10],[14,12,14,13],[14,9,14,10],[6,12,6,14],[6,9,6,11],[4,4,5,7],[6,4,6,7]]}
[]
[]
[]
[]
[null,null,null,null,"Прошу помощи в слиянии формул (для использования одной таблицы вместо двух)"]
[null,null,null,null,null,null,null,null,null,"Вариант рачета № 1",null,null,"Вариант Расчета № 2"]
[null,"Получение ПСД",null,null,"Наличие ЛСР (Планово и срочно по признаку)",null,null,null,null,"Наличие ЛСР (Планово)",null,null,"Наличие ЛСР (Срочно)",null,null,null,null,"ПРИЗНАК"]
[null,"№ п/п","Директивный срок начала работ",null,"№ ЛСР","ДАТА ПОСТУПЛЕНИЯ ЛСР в ЦО","КОЛИЧЕСТВО ДНЕЙ РЕШЕНИЯ ВОПРОСА","БАЛЛЫ",null,"№ ЛСР","КОЛИЧЕСТВО ДНЕЙ РЕШЕНИЯ ВОПРОСА","БАЛЛЫ","Отметка о согласовании ЛСР с заказчиком","КОЛИЧЕСТВО ДНЕЙ РЕШЕНИЯ ВОПРОСА","БАЛЛЫ",null,"Дата поступления проекта","Срочность"]
[null,"1","5",null,7,8,9,10,null,"11",13,14,15,17,18,null,19,20]
[null,1,"2020-04-20",null,"ЛСР 1","2020-04-15",{"$f":"IF(R10=\"Планово\",DATEDIF((C10-98),F10,\"D\"),IF(R10=\"Срочно\",DATEDIF(Q10,F10,\"D\"),\"\"))","v":5},{"$f":"IF(R10=\"Планово\",IF(ПЛ<=7,600,IF(ПЛ<=14,500,IF(ПЛ<=21,400,IF(ПЛ<=28,300,IF(ПЛ<=35,200,IF(ПЛ<=42,0,IF(ПЛ<=49,-200,IF(ПЛ<=56,-400,IF(ПЛ<=63,-600,-1000))))))))),IF(R10=\"Срочно\",IF(СР<=7,1000,IF(СР<=14,500,IF(СР<=21,0,-500))),\"\"))","v":1000},null,"ЛСР 1",{"$f":"DATEDIF((C10-98),F10,\"d\")","v":93},{"$f":"IF(K10<=7,600,IF(K10<=14,500,IF(K10<=21,400,IF(K10<=28,300,IF(K10<=35,200,IF(K10<=42,0,IF(K10<=49,-200,IF(K10<=56,-400,IF(K10<=63,-600,-1000)))))))))","v":-1000},"ЛСР 1",{"$f":"DATEDIF(Q10,F10,\"d\")","v":5},{"$f":"IF(N10<=7,1000,IF(N10<=14,500,IF(N10<=21,0,-500)))","v":1000},null,"2020-04-10","Срочно"]
[null,2,"2020-04-30",null,"ЛСР 2","2020-02-02",{"$f":"IF(R11=\"Планово\",DATEDIF((C11-98),F11,\"D\"),IF(R11=\"Срочно\",DATEDIF(Q11,F11,\"D\"),\"\"))","v":10},{"$f":"IF(R11=\"Планово\",IF(ПЛ<=7,600,IF(ПЛ<=14,500,IF(ПЛ<=21,400,IF(ПЛ<=28,300,IF(ПЛ<=35,200,IF(ПЛ<=42,0,IF(ПЛ<=49,-200,IF(ПЛ<=56,-400,IF(ПЛ<=63,-600,-1000))))))))),IF(R11=\"Срочно\",IF(СР<=7,1000,IF(СР<=14,500,IF(СР<=21,0,-500))),\"\"))","v":500},null,"ЛСР 2",{"$f":"DATEDIF((C11-98),F11,\"d\")","v":10},{"$f":"IF(K11<=7,600,IF(K11<=14,500,IF(K11<=21,400,IF(K11<=28,300,IF(K11<=35,200,IF(K11<=42,0,IF(K11<=49,-200,IF(K11<=56,-400,IF(K11<=63,-600,-1000)))))))))","v":500},"ЛСР 2",{"$f":"DATEDIF(Q11,F11,\"d\")","v":23},{"$f":"IF(N11<=7,1000,IF(N11<=14,500,IF(N11<=21,0,-500)))","v":-500},null,"2020-01-10","Планово"]
[null,3,"2020-05-10",null,"ЛСР 3","2020-05-05",10,{"$f":"IF(R12=\"Планово\",IF(ПЛ<=7,600,IF(ПЛ<=14,500,IF(ПЛ<=21,400,IF(ПЛ<=28,300,IF(ПЛ<=35,200,IF(ПЛ<=42,0,IF(ПЛ<=49,-200,IF(ПЛ<=56,-400,IF(ПЛ<=63,-600,-1000))))))))),IF(R12=\"Срочно\",IF(СР<=7,1000,IF(СР<=14,500,IF(СР<=21,0,-500))),\"\"))","v":500},null,"ЛСР 3",{"$f":"DATEDIF((C12-98),F12,\"d\")","v":93},-1000,"ЛСР 3",10,500,null,"2020-04-25","Срочно"]
[null,4,"2020-07-20",null,"ЛСР 4","2020-05-25",42,{"$f":"IF(R13=\"Планово\",IF(ПЛ<=7,600,IF(ПЛ<=14,500,IF(ПЛ<=21,400,IF(ПЛ<=28,300,IF(ПЛ<=35,200,IF(ПЛ<=42,0,IF(ПЛ<=49,-200,IF(ПЛ<=56,-400,IF(ПЛ<=63,-600,-1000))))))))),IF(R13=\"Срочно\",IF(СР<=7,1000,IF(СР<=14,500,IF(СР<=21,0,-500))),\"\"))","v":0},null,"ЛСР 4",42,0,"ЛСР 4",5,1000,null,"2020-05-20","Планово"]
[]
[null,null,null,null,null,null,null,null,null,"KPI Зам начальника УС по ПСР",null,{"$f":"_xlfn.AGGREGATE(9,7,L10:L13)","v":-1500},"KPI Зам начальника УС по ПСР",null,{"$f":"_xlfn.AGGREGATE(9,7,O10:O13)","v":2000}]
[null,null,null,null,null,null,null,null,null,"KPI инженера УС по ПСР",null,{"$f":"L15/2","v":-750},"KPI инженера УС по ПСР",null,{"$f":"O15/2","v":1000}]
[]
[null,"№ п/п","Директивный срок начала работ",null,"№ ЛСР","ДАТА ПОСТУПЛЕНИЯ ЛСР в ЦО","КОЛИЧЕСТВО ДНЕЙ РЕШЕНИЯ ВОПРОСА","БАЛЛЫ",null,"№ ЛСР","КОЛИЧЕСТВО ДНЕЙ РЕШЕНИЯ ВОПРОСА","БАЛЛЫ","Отметка о согласовании ЛСР с заказчиком","КОЛИЧЕСТВО ДНЕЙ РЕШЕНИЯ ВОПРОСА","БАЛЛЫ",null,"Дата поступления проекта","Срочность"]
[null,"1","5",null,7,8,9,10,null,"11",13,14,15,17,18,null,19,20]
[null,1,"2020-04-20",null,"ЛСР 1","2020-04-15",{"$f":"IF(R20=\"Планово\",DATEDIF((C20-98),F20,\"d\"),IF(R20=\"Срочно\",DATEDIF(Q20,F20,\"d\"),\"\"))","v":5},{"$f":"IF(R20=\"Планово\",IF(DATEDIF((C20-98),F20,\"d\")<=7,600,IF(DATEDIF((C20-98),F20,\"d\")<=14,500,IF(DATEDIF((C20-98),F20,\"d\")<=21,400,IF(DATEDIF((C20-98),F20,\"d\")<=28,300,IF(DATEDIF((C20-98),F20,\"d\")<=35,200,IF(DATEDIF((C20-98),F20,\"d\")<=42,0,IF(DATEDIF((C20-98),F20,\"d\")<=49,-200,IF(DATEDIF((C20-98),F20,\"d\")<=56,-400,IF(DATEDIF((C20-98),F20,\"d\")<=63,-600,-1000))))))))),IF(R20=\"Срочно\",IF(DATEDIF(Q20,F20,\"d\")<=7,1000,IF(DATEDIF(Q20,F20,\"d\")<=14,500,IF(DATEDIF(Q20,F20,\"d\")<=21,0,-500))),\"\"))","v":1000},null,"ЛСР 1",{"$f":"DATEDIF((C20-98),F20,\"d\")","v":93},{"$f":"IF(K20<=7,600,IF(K20<=14,500,IF(K20<=21,400,IF(K20<=28,300,IF(K20<=35,200,IF(K20<=42,0,IF(K20<=49,-200,IF(K20<=56,-400,IF(K20<=63,-600,-1000)))))))))","v":-1000},"ЛСР 1",{"$f":"DATEDIF(Q20,F20,\"d\")","v":5},{"$f":"IF(N20<=7,1000,IF(N20<=14,500,IF(N20<=21,0,-500)))","v":1000},null,"2020-04-10","Срочно"]
[null,2,"2020-04-30",null,"ЛСР 2","2020-02-02",{"$f":"IF(R21=\"Планово\",DATEDIF((C21-98),F21,\"d\"),IF(R21=\"Срочно\",DATEDIF(Q21,F21,\"d\"),\"\"))","v":10},{"$f":"IF(R21=\"Планово\",IF(DATEDIF((C21-98),F21,\"d\")<=7,600,IF(DATEDIF((C21-98),F21,\"d\")<=14,500,IF(DATEDIF((C21-98),F21,\"d\")<=21,400,IF(DATEDIF((C21-98),F21,\"d\")<=28,300,IF(DATEDIF((C21-98),F21,\"d\")<=35,200,IF(DATEDIF((C21-98),F21,\"d\")<=42,0,IF(DATEDIF((C21-98),F21,\"d\")<=49,-200,IF(DATEDIF((C21-98),F21,\"d\")<=56,-400,IF(DATEDIF((C21-98),F21,\"d\")<=63,-600,-1000))))))))),IF(R21=\"Срочно\",IF(DATEDIF(Q21,F21,\"d\")<=7,1000,IF(DATEDIF(Q21,F21,\"d\")<=14,500,IF(DATEDIF(Q21,F21,\"d\")<=21,0,-500))),\"\"))","v":500},null,"ЛСР 2",{"$f":"DATEDIF((C21-98),F21,\"d\")","v":10},{"$f":"IF(K21<=7,600,IF(K21<=14,500,IF(K21<=21,400,IF(K21<=28,300,IF(K21<=35,200,IF(K21<=42,0,IF(K21<=49,-200,IF(K21<=56,-400,IF(K21<=63,-600,-1000)))))))))","v":500},"ЛСР 2",{"$f":"DATEDIF(Q21,F21,\"d\")","v":23},{"$f":"IF(N21<=7,1000,IF(N21<=14,500,IF(N21<=21,0,-500)))","v":-500},null,"2020-01-10","Планово"]
[null,3,"2020-05-10",null,"ЛСР 3","2020-05-05",10,500,null,"ЛСР 3",{"$f":"DATEDIF((C22-98),F22,\"d\")","v":93},-1000,"ЛСР 3",10,500,null,"2020-04-25","Срочно"]
[null,4,"2020-07-20",null,"ЛСР 4","2020-05-25",42,0,null,"ЛСР 4",{"$f":"DATEDIF((C23-98),F23,\"d\")","v":42},0,"ЛСР 4",5,1000,null,"2020-05-20","Планово"]