PO.DE.Casing.Collapse.API5C3


Description

Minimum collapse resistance of casing or tubing under external pressure, by the four API collapse equations. The regime is chosen from the D/t ratio and the grade, and axial tension can reduce the rating through the API axial-stress equivalent grade. Output 0 returns the collapse pressure in psi, 1 adds the regime (1 yield, 2 plastic, 3 transition, 4 elastic) as a second cell, and 2 returns the grade's three regime D/t limits.

Formula

=LAMBDA(OD_in, t_in, Yp_psi, Sa_psi, Output, LET( s, Sa_psi/Yp_psi, Ya, (SQRT(1-0.75*s^2)-0.5*s)*Yp_psi, kA, 2.8762+0.10679E-5*Ya+0.21301E-10*Ya^2-0.53132E-16*Ya^3, kB, 0.026233+0.50609E-6*Ya, kC, -465.93+0.030867*Ya-0.10483E-7*Ya^2+0.36989E-13*Ya^3, ba, kB/kA, xa, 3*ba/(2+ba), kF, 46950000*xa^3/(Ya*(xa-ba)*(1-xa)^2), kG, kF*ba, dtYP, (SQRT((kA-2)^2+8*(kB+kC/Ya))+(kA-2))/(2*(kB+kC/Ya)), dtPT, Ya*(kA-kF)/(kC+Ya*(kB-kG)), dtTE, (2+ba)/(3*ba), dt, OD_in/t_in, reg, IF(dt<=dtYP, 1, IF(dt<=dtPT, 2, IF(dt<=dtTE, 3, 4))), pc, IF(reg=1, 2*Ya*(dt-1)/dt^2, IF(reg=2, Ya*(kA/dt-kB)-kC, IF(reg=3, Ya*(kF/dt-kG), 46950000/(dt*(dt-1)^2)))), IF(Output=2, HSTACK(dtYP, dtPT, dtTE), IF(Output=1, HSTACK(pc, reg), pc))))

Parameters

Parameter Unit Description
OD_in in Specified outside diameter
t_in in Specified (nominal) wall thickness
Yp_psi psi Minimum yield strength of the grade
Sa_psi psi Axial stress, tension positive; 0 for the uniaxial rating
Output dimensionless 0 collapse pressure; 1 pressure and regime; 2 the regime D/t limits

Examples

Invocation Expected
=PO.DE.Casing.Collapse.API5C3(5.5, 0.415, 80000, 0, 0) 11160
=PO.DE.Casing.Collapse.API5C3(9.625, 0.472, 110000, 0, 0) 5300
=PO.DE.Casing.Collapse.API5C3(5.5, 0.415, 110000, 0, 0) 14540
=PO.DE.Casing.Collapse.API5C3(13.375, 0.48, 80000, 0, 0) 2260
=PO.DE.Casing.Collapse.API5C3(13.375, 0.38, 55000, 0, 0) 1130
=PO.DE.Casing.Collapse.API5C3(16, 0.495, 80000, 0, 0) 1480
=PO.DE.Casing.Collapse.API5C3(16, 0.495, 125000, 0, 0) 1480
=PO.DE.Casing.Collapse.API5C3(16, 0.375, 40000, 0, 0) 630
=PO.DE.Casing.Collapse.API5C3(7, 0.362, 110000, 0, 0) 6230
=PO.DE.Casing.Collapse.API5C3(7, 0.362, 110000, 10000, 0) 6120
=PO.DE.Casing.Collapse.API5C3(5.5, 0.415, 80000, 0, 1) [11161.7851, 1]
=PO.DE.Casing.Collapse.API5C3(9.625, 0.472, 110000, 0, 1) [5296.4166, 2]
=PO.DE.Casing.Collapse.API5C3(13.375, 0.48, 80000, 0, 1) [2262.8442, 3]
=PO.DE.Casing.Collapse.API5C3(16, 0.495, 80000, 0, 1) [1480.4293, 4]
=PO.DE.Casing.Collapse.API5C3(9.625, 0.472, 80000, 0, 2) [13.38, 22.47, 31.02]
=PO.DE.Casing.Collapse.API5C3(9.625, 0.472, 40000, 0, 2) [16.4, 27.01, 42.64]
=PO.DE.Casing.Collapse.API5C3(9.625, 0.472, 110000, 0, 2) [12.44, 20.41, 26.22]

Need a custom LAMBDA? Suggest a New Lambda