{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["WT Calc ASME B31.8"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"WT Calc ASME B31.8","index":0,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[[147,0,147,1],[148,0,148,1],[148,2,148,3],[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,1,3,11],[71,9,71,10],[91,1,91,11],[128,2,128,4]]}
["ATTACHMENT - X"]
["Document No. X"]
[{"$f":"CONCATENATE(\"Wall Thickness Calculation of \",E7,\"in Gas Pipeline (Location Class-\",E9,\", D.F.=\",E10,\", Corr. Allow.=\",E8,\"mm)\")","v":"Wall Thickness Calculation of 36in Gas Pipeline (Location Class-3, D.F.=0.5, Corr. Allow.=1.5mm)"}]
[1.0]
[2.0,null,"DESIGN INPUT"]
[3.0,null,"Design Code",null,"ASME B31.8"]
[4.0,null,"Pipeline Size / Nominal O.D","D",36.0,"in",{"$f":"E7*25.4","v":914.4},"mm"]
[5.0,null,"Corrosion Allowance","A",1.5,"mm"]
[6.0,null,"Location Class",null,3.0]
[7.0,null,"Design Factor","F",0.5]
[8.0]
[9.0,null,"Steel Coefficient of Expansion,  ","α",1.17E-5,"per deg C",6.5E-6,"in/in/ oC"]
[10.0,null,"Modulus of Elasticity  ","E",207000.0,"Mpa",3.05E7,"Psi"]
[11.0]
[12.0,null,"Pressure and Temperature Data"]
[13.0,null,"Design Pressure ","P",63.5,"bar g",{"$f":"E16*14.50377","v":920.989395},"psi g"]
[14.0,null,"Design Temperature (Underground)","Td",65.0,"oC",{"$f":"E17*9/5+32","v":149},"oF"]
[15.0,null,"Installation (backfill) Temp","Ti",13.0,"oC",55.4,"oF"]
[16.0,null,"Weld joint factor","E",1.0]
[17.0,null,"Temperature Derating Factor","T",1.0]
[18.0]
[19.0,null,"A.  WALL THICKNESS "]
[20.0,null,"Grade",null,null,null,null,"X60"]
[21.0,null,"SMYS of Line Pipe",null,null,"S",null,60200.0,"psi",{"$f":"H24*0.006894757","v":415.0643714},"MPa"]
[22.0,null,"Wall Thickness Calculated",null,null,"tmin",null,{"$f":"(($G$16*$G7)/(2*H24*($E$10)*($E$19)))+$E$8","v":15.48924755},"mm",{"$f":"H25/25.4","v":0.6098128959},"inch"]
[23.0,null,"tmin = P x D / (2x Sx Fx E x T) + A"]
[24.0,null,"Next higher API wall thickness",null,null,"t",null,15.9,"mm",{"$f":"H27/25.4","v":0.625984252},"inch"]
[25.0,null,"D/t Check ( Should be  < 96)",null,null,null,null,{"$f":"$G7/H27","v":57.50943396}]
[26.0]
[27.0,null,"B.  EQUIVALENT STRESS CHECK FOR CORRODED PIPE CONDITION"]
[28.0,null,"Wall thickness (t)",null,null,null,null,{"$f":"H27-E8","v":14.4},"mm"]
[29.0,null,"Hoop Stress = Sh = PD/2t",null,null,null,null,{"$f":"E16*G7/(20*(H31))","v":201.6125},"MPa"]
[30.0]
[31.0,null,"B.1  Restrained Pipe (Underground)"]
[32.0,null,"Thermal Stress = ST = a (Ti - Td) E",null,null,null,null,{"$f":"$E$13*$E$12*($E18-E17)","v":-125.9388},"MPa"]
[33.0,null,"Longitudinal Stress due to pressure = SP = 0.3 Sh",null,null,null,null,{"$f":"0.3*H32","v":60.48375},"MPa"]
[34.0]
[35.0,null,"Longitudinal Stress, SL"]
[36.0,null,"SL = SP + ST + SB + SX  ",{"$f":"CONCATENATE(\"  ≤    0.9 x SMYS = \",ROUNDUP(0.9*J24,0),\" MPa\")","v":"  ≤    0.9 x SMYS = 374 MPa"}]
[37.0]
[38.0,null,"Without considering SB (Bending stress) and SX (Axial stress due to external loading): "]
[39.0,null,"SL = SP + ST ",null,null,null,null,{"$f":"H36+H35","v":-65.45505},"MPa"]
[40.0,null,"Longitudinal Stress check :","SL  ",{"$f":"IF(ABS(H42)<=0.9*J24,\"≤ 0.9 x SMYS\",\"> 0.9 x SMYS\")","v":"≤ 0.9 x SMYS"},null,"hence ",{"$f":"IF(E43=\"≤ 0.9 x SMYS\",\"OK\",\"NOT OK\")","v":"OK"}]
[41.0]
[42.0,null,"Equivalent Stress, SE "]
[43.0,null,"SE1 = | Sh - SL |",null,null,null,"SE1",{"$f":"ABS(H32-H42)","v":267.06755},"MPa"]
[44.0,null,"SE2 = [ Sh2 + SL2 - Sh SL ]1/2",null,null,null,"SE2",{"$f":"(H32^2+H42^2-H32*H42)^0.5","v":241.098569},"MPa"]
[45.0,null,"SE = Max (SE1, SE2)",{"$f":"CONCATENATE(\"  ≤    0.9 x SMYS = \",ROUNDUP(0.9*J24,0),\" MPa\")","v":"  ≤    0.9 x SMYS = 374 MPa"},null,null,"SE",{"$f":"MAX(H46,H47)","v":267.06755},"MPa"]
[46.0,null,"Equivalent Stress check :","SE",{"$f":"IF(H48<=0.9*J24,\"≤ 0.9 x SMYS\",\"> 0.9 x SMYS\")","v":"≤ 0.9 x SMYS"},null,"hence ",{"$f":"IF(E49=\"≤ 0.9 x SMYS\",\"OK\",\"NOT OK\")","v":"OK"}]
[47.0]
[48.0,null,"B.2  Unrestrained Pipe (Aboveground)"]
[49.0,null,"Longitudinal Stress due to pressure = SP = 0.5 Sh",null,null,null,null,{"$f":"0.5*H32","v":100.80625},"MPa"]
[50.0]
[51.0,null,"Longitudinal Stress, SL",null,null,null,null,null,null,null,null,null,null,null,"Iteration Control",null,{"$f":"P56-P59","v":-0.00003372097927}]
[52.0,null,"SL = SP +SB + SX  ",{"$f":"CONCATENATE(\"  ≤    0.75 x SMYS = \",ROUNDUP(0.75*J24,0),\" MPa\")","v":"  ≤    0.75 x SMYS = 312 MPa"}]
[53.0,null,"Without considering SB (Bending stress) and SX (Axial stress due to external loading): ",null,null,null,null,null,null,null,null,null,null,null,"0.9SMYS",{"$f":"0.9*J24","v":373.5579343}]
[54.0,null,"SL = SP ",null,null,null,null,{"$f":"H52","v":100.80625},"MPa",null,null,null,null,null,"SB",-163.98081621913218]
[55.0,null,"Longitudinal Stress check :","SL  ",{"$f":"IF(H57<=0.75*J24,\"≤ 0.75 x SMYS\",\"> 0.75 x SMYS\")","v":"≤ 0.75 x SMYS"},null,"hence ",{"$f":"IF(E58=\"≤ 0.75 x SMYS\",\"OK\",\"NOT OK\")","v":"OK"},null,null,null,null,null,null,"SL",{"$f":"H36+H35+P57","v":-229.4358662}]
[56.0,null,null,null,null,null,null,null,null,null,null,null,null,null,"SE2",{"$f":"(H32^2+P58^2-H32*P58)^0.5","v":373.557968}]
[57.0,null,"C.  MINIMUM BENDING RADIUS"]
[58.0,null,"Minimum bending radius for underground section is calculated from maximum margin of bending stress, "]
[59.0,null,"based on Max (SE1, SE2) = 0.9 x SMYS. Hence, bending stress SB = ",null,null,null,null,{"$f":"IF(H46>=H47,0.7*H32-0.9*J24-H35,P57)","v":-106.4903843},"MPa"]
[60.0,null,"R (Minimum Bend Radius) = E D / (2 |Sb|)",null,null,null,null,{"$f":"E13*G7/(2*ABS(H62))/1000","v":888.7224951},"m"]
[61.0]
[62.0,null,"D. CHECK ON THINNING DUE TO COLD BENDS:   BEND RADIUS = 40 D"]
[63.0,null,"Inner bend radius divided by diameter, (n)",null,null,null,null,39.5]
[64.0,null,"As per PD 8010-1:2004, % of Wall thinning  = 50 / (n+1)  ",null,null,null,null,{"$f":"50/(H66+1)","v":1.234567901},"%"]
[65.0,null,"Pipe thk. before bending = cal thk/(1-thinning %)",null,null,null,null,{"$f":"H25/(1-$H$67/100)","v":15.68286315},"mm"]
[66.0,null,"Available thickness for bending (= Selected thk)",null,null,null,null,{"$f":"H27","v":15.9},"mm"]
[67.0,null,"Adequacy Check (Pipe thk before bending < Available thk)",null,null,null,null,{"$f":"IF(H68<H69,\"OK\",\"Fail\")","v":"OK"}]
[68.0]