{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Основные линии","Справочно"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Основные линии","index":0,"n_rows":3,"n_cols":73,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Столбец1","Контур","Приоритет","БЛОК","Номер линии","Врезки","Номер листа","Номер ревизии","Класс трубопровода","материал трубопровода","Категория трубопровода","Код продукта","Рабочее давление, Мпа","Рабочая температура, °С","Элемент №1","Элемент №2","Дюйм диаметр элемента №1","Диаметр элемента №1, мм","Толщина элемента №1","Дюйм диаметр элемента №2","Диаметр элемента №2, мм","Толщина элемента №2, мм","Сварочные электроды","Присадочная проволока","Защитный газ","Дата сварки","Дата сварки факт","Способ сварки","Тип сварного соединения","S/F","Номер сварного шва","Доп стык","Статус (ремонт, вырез)","Клеймо Сварщика 1","Клеймо Сварщика 2","Клеймо Сварщика (Факт)","Дата ТО","ТО № диаграммы","№ заключения проведения замера твердости","% НК","Дата ВИК","№ акта ВИК","Дата проведения МПД","№ заключения МПД","Дата проведения ПВК","№ заключения ПВК","Дата проведения УЗК","№ заключения УЗК","Дата проведения РК","№ заключения РК","Дата проведения стиллоскопирования","№ заключения по стиллоскопированию","Дата проверки содержания феритной фазы","№ заключения по содержанию феритной фазы","Результат","Вид (тип) испытаний","Дата проведения гидроиспытания","№ ЗАЯВКИ","Примечание","Всего замечаний","Описание замечаний","Наличие диаграммы ТО","заявка на НК","повторяющиеся стыки на линии","проблемы РАД 1 кл.","проблемы РД 1 кл.","проблемы РД 2 кл.","наличие одного заключения РК(УЗК)","наличие заключений РК(УЗК)","наличие заключений ПВК 100%","наличие одного заключения ремонт","наличие заключений ВИК","Все змечания"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(RIGHT(E3,LEN(E3)-LEN(LEFT(E3,SEARCH(\"-\",E3,SEARCH(\"-\",E3,1)+1)-1))-1),\"-\")","v":"-"},null,{"$f":"IFERROR(INDEX(#REF!&\" \"&#REF!,MATCH(CONCATENATE(D3,E3),CONCATENATE(#REF!,#REF!),0),1),\"-\")","v":"-"},{"$f":"IFERROR(LEFT(E3,SEARCH(\"-\",E3,1)-1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH(CONCATENATE(D3,E3),CONCATENATE(#REF!,#REF!),0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH(CONCATENATE(D3,E3),CONCATENATE(#REF!,#REF!),0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH(CONCATENATE(D3,E3),CONCATENATE(#REF!,#REF!),0),1),\"-\")","v":"-"},null,{"$f":"IF(AND(D3<>\"\",BF3<>\"\"),CONCATENATE(D3,\".03-\",LEFT(E3,SEARCH(\"-\",E3,SEARCH(\"-\",E3,1)+1)-1),\"-\",BF3,IFERROR(IF(SEARCH(\"/ТС-\",E3,1)>1,CONCATENATE(\"/\",RIGHT(E3,4)),\"\"),\"\")),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(BK3:BS3,TRUE)","v":0},{"$f":"IFERROR(OFFSET(BJ3,(ROW(BJ3)*-1)+1,MATCH(TRUE,$BJ3:$BT3,0)-1,1,1),\"\")","v":""},{"$f":"IFERROR(IF(AND(INDEX(#REF!,MATCH(CONCATENATE(D3,E3),CONCATENATE(#REF!,#REF!),0),1)=\"Треб\",AL3=\"\"),TRUE,FALSE),FALSE)","v":false},{"$f":"IF(AND(AH3<>\"\",BF3=\"\"),TRUE,FALSE)","v":false},{"$f":"IF(E3<>\"\",SUM(($E$3:$E$3=E3)*($AD$3:$AD$3=AD3)*($AE$3:$AE$3=AE3)*($AF$3:$AF$3=AF3)*($BC$3:$BC$3=BC3))>=2,FALSE)","v":false},{"$f":"IF(AND(E3<>\"\",IFERROR(LEFT(AB3,SEARCH(\"/\",AB3,1)-1),AB3)=\"РАД\",AH3<>\"\"),SUM((CONCATENATE(AH3,IFERROR(LEFT(AB3,SEARCH(\"/\",AB3,1)-1),AB3))=(#REF!))*(#REF!<Z3)*(#REF!>Z3))=0,FALSE)","v":false},{"$f":"IF(AND(F3<>\"\",IFERROR(LEFT(AC3,SEARCH(\"/\",AC3,1)-1),AC3)=\"РД\",AI3<>\"\"),SUM((CONCATENATE(AI3,IFERROR(LEFT(AC3,SEARCH(\"/\",AC3,1)-1),AC3))=(#REF!))*(#REF!<AA3)*(#REF!>AA3))=0,FALSE)","v":false},{"$f":"IF(AND(E3<>\"\",IFERROR(LEFT(AB3,SEARCH(\"/\",AB3,1)-1),AB3)=\"РД\",AI3<>\"\"),SUM((CONCATENATE(AI3,IFERROR(LEFT(AB3,SEARCH(\"/\",AB3,1)-1),AB3))=(#REF!))*(#REF!<Z3)*(#REF!>Z3))=0,FALSE)","v":false},{"$f":"IF(AND($AN3>0,COUNTIFS($E$3:$E$3,$E3,$AH$3:$AH$3,$AH3,$BC$3:$BC$3,\"<>\"&\"ремонт\")>=1,$AH3<>\"\"),SUM((IFERROR(SEARCH(E3&AH3&\"Т\",$E$3:$E$3&$AH$3:$AH$3&$AX$3:$AX$3,1),0))+IFERROR(SEARCH(E3&AH3&\"Т\",$E$3:$E$3&$AH$3:$AH$3&$AV$3:$AV$3,1),0))=0,FALSE)","v":false},{"$f":"IF($E3<>\"\",SUM(($E$3:$E$3=$E3)*($AH$3:$AH$3=$AH3)*($BC$3:$BC$3<>\"ремонт\")*IF(IFERROR(SEARCH(\"Т\",$AX$3:$AX$3,1),0)=1,1,IFERROR(SEARCH(\"Т\",$AV$3:$AV$3,1),0)))<IFERROR(ROUNDUP(COUNTIFS($E$3:$E$3,$E3,$AH$3:$AH$3,$AH3,$BC$3:$BC$3,\"<>\"&\"ремонт\")/100*$AN3,0),0))","v":false},{"$f":"IF(K3=\"А(а) I\",IFERROR(SEARCH(\"Т\",AT3,1),0)=0,FALSE)","v":false},{"$f":"IF(SUM(($E$3:$E$3=E3)*($AD$3:$AD$3=AD3)*($AE$3:$AE$3=AE3)*($AF$3:$AF$3=AF3))=2,IFERROR(IF(MATCH(E3&AD3&AE3&AF3&\"ремонт\",$E$3:$E$3&$AD$3:$AD$3&$AE$3:$AE$3&$AF$3:$AF$3&$BC$3:$BC$3,0)>0,MATCH(E3&AD3&AE3&AF3&\"\",$E$3:$E$3&$AD$3:$AD$3&$AE$3:$AE$3&$AF$3:$AF$3&$AX$3:$AX$3,0)>0,),FALSE),IF(BC3=\"ремонт\",TRUE,FALSE))","v":false},{"$f":"IF($AH3<>\"\",$AP3=\"\",FALSE)","v":false},{"$f":"IFERROR(MATCH(TRUE,BJ3:BT3,0)>0,FALSE)","v":false}]

{"sheet":"Справочно","index":1,"n_rows":102,"n_cols":47,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"...","...","...","...","...","..."]