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] |