{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Труба_LC"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Труба_LC","index":0,"n_rows":85,"n_cols":70,"rows_kept":85,"cut":false,"hidden":false,"merged":[[15,2,17,2],[15,1,17,1],[15,8,17,8],[15,5,17,5],[1,1,1,11],[2,1,2,11],[15,9,17,9],[15,10,17,10],[15,11,17,11],[17,3,17,4],[14,3,14,4],[13,3,13,4],[12,3,12,4],[12,2,14,2],[12,1,14,1],[15,7,17,7],[15,6,16,6]]}
[]
[null,"ПРОТОКОЛ"]
[null,"контроля геометрических параметров трубы с резьбой LC"]
[null,null,"Номинальный диаметр трубы",null,null,"Группа прочности",null,"Допуски на натяг по КККР",null,"Контролер",null,"Дата",null,"Смена","А","Б","В","Г"]
[null,null,168.28,null,null,"Q125","ниж. откл.",-1.58,null,null,null,{"$f":"TODAY()","v":"2019-02-02"},null,"Сторона трубы","муфтовая сторона","ниппельная сторона"]
[null,null,"Номинальная толщина стенки трубы",null,null,"Партия ТО","верх. откл.",1.58,null,"подпись",null,null,null,"Диаметр",168.28,168.3,177.8,178,193.68,193.7,194,219.08,219.1,244.48,244.5,245]
[null,null,13.06,null,null,null,null,null,null,null,null,"Смена",null,"Толщина стенки",7.3,7.32,8.0500000000000007,8.1,8.3000000000000007,8.33,8.89,8.9,8.94,9.19,9.1999999999999993,9.5,9.52,9.5299999999999994,9.65,9.6999999999999993,10,10.029999999999999,10.16,10.199999999999999,10.36,10.4,10.59,10.6,10.92,11,11.05,11.1,11.4,11.43,11.5,11.51,11.99,12,12.06,12.1,12.19,12.2,12.4,12.42,12.57,12.6,12.65,12.7,13.06,13.1,13.7,13.72,13.8,13.84,14.15,14.2,14.27,14.3,15.1,15.11]
[null,null,"Номер шаблона для диаметра С10",null,"Резьбовой","номер",null,"Допуски на натяг по НТД",null,"расшифровка",null,"В",null,"Группа прочности","H40","J55","K55","M65","L80","L8013Cr","L809Cr","N80","N80-1","C90","R95","T95","C110","P110","Q125","Q135","TMK140","TMK150","Д","Е","Л","М","Р"]
[null,null,null,null,"калибр",null,"ниж. откл.",{"$f":"-ROUNDDOWN(1/8*25.4,2)","v":-3.17},null,{"$f":"IF(OR(C5=168,C5=168.28,C5=168.3,C5=178,C5=177.8),(3*H6+H6+(I16/(0.0625*2)))+$F$11)","v":7.62},{"$f":"IF(AND(J9=\"ЛОЖЬ\",J10=\"ЛОЖЬ\",J11=\"ЛОЖЬ\"),J12,J9)","v":7.62},null,null,"Признак годности","годн","брак"]
[null,null,"Сторона трубы",null,null,"ниж. знач. \"Натяг LC\"","верх. откл.",{"$f":"ROUNDDOWN(1/8*25.4,2)","v":3.17},null,{"$f":"IF(OR(C5=193.68,C5=193.7,C5=194,C5=219.08,C5=219.1),(3.5*H6+H6+(I16/(0.0625*2)))+$F$11)","v":false}]
[null,null,"ниппельная сторона",null,"по сертиф.",-0.86,null,null,null,{"$f":"IF(OR(C5=244.48,C5=244.5,C5=245)*AND(OR(F5=\"H40\",F5=\"J55\",F5=\"K55\",F5=\"M65\",F5=\"L80\",F5=\"L8013Cr\",F5=\"L809Cr\",F5=\"N80\",F5=\"N80-1\",F5=\"C90\",F5=\"R95\",F5=\"T95\",F5=\"C110\")),(3.5*H6+H6+(I16/(0.0625*2)))+$F$11)","v":false}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C5=244.48,C5=244.5,C5=245)*AND(OR(F5=\"P110\",F5=\"Q125\",F5=\"Q135\")),(4*H6+H6+(I16/(0.0625*2)))+$F$11)","v":false}]
[null,"Номер плавки","Номер трубы","Конусность резьбы на длине 25,4мм (8 ниток), мм на участке с полным профилем",null,"Расст. между делит. линией и верш. проф. рез., мм","Отклонение наружного диаметра резьбы С10 в плоскости измерений L10, мм","Среднеарифметическое отклонение наружного диаметра резьбы С10 в плоскости измерений L10, мм","Разность максимального и минимального отклонений наружного диаметра резьбы С10 (овальность) в плоскости измерений L10, мм, не более","Максимально допустимый натяг, мм с учетом овальности","Фактически измеренный натяг, мм","Заключение о годности"]
[null,null,null,{"$f":"IF(C11=\"муфтовая сторона\",ROUNDUP((0.0625-0.0026)*25.4-0.02,2),ROUNDUP((0.0625-0.0026)*25.4,2))","v":1.53},null,{"$f":"-ROUNDDOWN(0.0015*25.4,2)","v":-0.03},"—",{"$f":"-ROUNDDOWN(0.008*25.4,2)","v":-0.2},"—","—",{"$f":"H5","v":-1.58},"годн"]
[null,null,null,{"$f":"IF(C11=\"муфтовая сторона\",ROUNDDOWN((0.0625+0.0052)*25.4-0.02,2),ROUNDDOWN((0.0625+0.0052)*25.4,2))","v":1.71},null,{"$f":"ROUNDDOWN(0.0015*25.4,2)","v":0.03},"—",{"$f":"ROUNDDOWN(0.008*25.4,2)","v":0.2},{"$f":"ROUNDDOWN(IF(C11=\"муфтовая сторона\",O15,O15*0.6),2)","v":0.3},"—","—","брак",null,null,{"$f":"IF(C5=168,IF(C7>0.331*25.4,C5*0.003,C5*0.004),IF(C5=168.28,IF(C7>0.331*25.4,C5*0.003,C5*0.004),IF(C5=168.3,IF(C7>0.331*25.4,C5*0.003,C5*0.004),IF(C5=177.8,IF(C7>0.35*25.4,C5*0.003,C5*0.004),IF(C5=178,IF(C7>0.35*25.4,C5*0.003,C5*0.004),IF(C5=193.68,IF(C7>0.381*25.4,C5*0.003,C5*0.004),IF(C5=193.7,IF(C7>0.381*25.4,C5*0.003,C5*0.004),IF(C5=194,IF(C7>0.381*25.4,C5*0.003,C5*0.004),IF(C5=219,IF(C7>0.431*25.4,C5*0.003,C5*0.004),IF(C5=219.08,IF(C7>0.431*25.4,C5*0.003,C5*0.004),IF(C5=219.1,IF(C7>0.431*25.4,C5*0.003,C5*0.004),IF(C5=244.48,IF(C7>0.481*25.4,C5*0.003,C5*0.004),IF(C5=244.5,IF(C7>0.481*25.4,C5*0.003,C5*0.004),IF(C5=245,IF(C7>0.481*25.4,C5*0.003,C5*0.004),IF(C5=273,IF(C7>0.538*25.4,C5*0.003,C5*0.004),IF(C5=273.05,IF(C7>0.538*25.4,C5*0.003,C5*0.004),IF(C5=273.1,IF(C7>0.538*25.4,C5*0.003,C5*0.004),IF(C5=298.45,IF(C7>0.588*25.4,C5*0.003,C5*0.004),IF(C5=298.5,IF(C7>0.588*25.4,C5*0.003,C5*0.004),IF(C5=299,IF(C7>0.588*25.4,C5*0.003,C5*0.004),IF(C5=339.72,IF(C7>0.669*25.4,C5*0.003,C5*0.004),IF(C5=339.73,IF(C7>0.669*25.4,C5*0.003,C5*0.004),IF(C5=340,IF(C7>0.669*25.4,C5*0.003,C5*0.004))))))))))))))))))))))))","v":0.50484000000000007}]
[null,null,null,1.57,1.57,null,-0.12,{"$f":"(G16+G18)/2","v":1.4999999999999999E-2},{"$f":"ABS(G16-G18)","v":0.27},{"$f":"2.54+(I16/(0.0625*2))+$F$11","v":3.8400000000000003},4.7]
[null,null,null,1.59,1.6]
[null,null,null,{"$f":"AVERAGE(D16:E17)","v":1.5825},null,null,0.15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Т"]