PO.DE.Casing.LoadCase


Description

Net pressure load on a casing string at one depth for the standard burst and collapse load cases, with the external backup. Evaluated down a depth column, it gives the load line that the burst or collapse rating is compared against. Cases 1 and 2 (burst) return internal minus external pressure in psi, cases 3 and 4 (collapse) external minus internal.

Formula

=LAMBDA(Case, D_ft, Pref_psi, Dref_ft, Gin_psift, Gout_psift, Level_ft, LET( pout, Gout_psift*D_ft, pburst, Pref_psi-Gin_psift*(Dref_ft-D_ft), pevac, IF(Case=3, 0, IF(D_ft>Level_ft, Gin_psift*(D_ft-Level_ft), 0)), IF(OR(Case<1, Case>4), NA(), IF(Case<=2, pburst-pout, pout-pevac))))

Parameters

Parameter Unit Description
Case dimensionless 1 burst gas to surface; 2 burst lost returns with water; 3 collapse full evacuation; 4 collapse partial evacuation
D_ft ft True vertical depth of the point
Pref_psi psi Burst: pressure at the reference depth (pore pressure for case 1, fracture pressure for case 2)
Dref_ft ft Burst: true vertical depth of the reference pressure
Gin_psift psi/ft Internal fluid gradient: gas (case 1), water (case 2) or the fluid below the level (case 4)
Gout_psift psi/ft External gradient: the backup for burst, the mud outside for collapse
Level_ft ft Case 4: depth of the fluid level inside the casing

Examples

Invocation Expected
=PO.DE.Casing.LoadCase(1, 0, 5000, 10000, 0.1, 0.465, 0) 4000
=PO.DE.Casing.LoadCase(1, 10000, 5000, 10000, 0.1, 0.465, 0) 350
=PO.DE.Casing.LoadCase(2, 0, 6400, 8000, 0.465, 0, 0) 2680
=PO.DE.Casing.LoadCase(2, 8000, 6400, 8000, 0.465, 0.465, 0) 2680
=PO.DE.Casing.LoadCase(3, 10000, 0, 0, 0, 0.52, 0) 5200
=PO.DE.Casing.LoadCase(4, 10000, 0, 0, 0.52, 0.52, 4000) 2080
=PO.DE.Casing.LoadCase(4, 3000, 0, 0, 0.52, 0.52, 4000) 1560

Need a custom LAMBDA? Suggest a New Lambda