{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,6,29,6],[18,7,29,7],[5,9,5,11],[5,12,5,14],[4,4,5,7],[15,9,15,10],[15,12,15,13],[6,4,6,7],[14,9,14,10],[14,12,14,13],[6,9,6,11],[6,12,6,14]]}
[]
[]
[]
[]
[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",null,null,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",null,null,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",null,null,null,"ЛСР 3",93,-1000,"ЛСР 3",10,500,null,"2020-04-25","Срочно"]
[null,4,"2020-07-20",null,"ЛСР 4","2020-05-25",null,null,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,null,"При признаке в колонке 20 \"Планово\" использовать формулу рачета дат из колонки 13, а при признаке в колонке 20 \"Срочно\" использовать формулу из колонки 17","При признаке в колонке 20 \"Планово\" использовать формулу рачета дат из колонки 14, а при признаке в колонке 20 \"Срочно\" использовать формулу из колонки 18"]