---
cid: po.bp.de.casing.design
hub: de
tags: [drilling, casing, casing-design, burst, collapse, tension, triaxial, von-Mises, design-factor, load-case, buoyancy, API-5C3]
facets: { discipline: drilling, property: casing, method-type: analytical }
title: Casing Design
summary: "Whether a two-section casing string holds its burst, collapse, tension and triaxial loads by API TR 5C3, with the design factors down the string."
slug: po.de.casing.design
type: worksheet
---

# Casing Design

## Description

Will a two-section casing string hold the loads it is designed for? You enter the string's diameter, grade, shoe and crossover, each section's weight and wall, the mud, pore and fracture pressures, and the minimum design factors. You read off each section's API TR 5C3 burst, collapse and pipe-body yield ratings, the lowest burst, collapse and tension design factors along each section, and the top joint's overpull and triaxial design factor.

**Parameters:**
- **String**: outside diameter `CSG_OD` (in), the grade's minimum yield strength `CSG_Yp` (psi), the shoe `CSG_Shoe` and the crossover `CSG_Xover` (ft TVD), and each section's nominal weight and wall, `CSG_W1`/`CSG_T1` above and `CSG_W2`/`CSG_T2` below (lb/ft, in)
- **Loads**: the mud the string is run in `CSG_MW` (ppg), the pore pressure at the next section's TD `CSG_PpTD` (ppg) and that TD `CSG_TD` (ft), the fracture gradient at the shoe `CSG_FgShoe` (ppg), the gas gradient `CSG_Ggas` and the water gradient `CSG_Gw` (psi/ft), and the overpull `CSG_Overpull` (lbf)
- **Minimum design factors**: burst `CSG_DFb`, collapse `CSG_DFc`, tension `CSG_DFt` and triaxial `CSG_DFvm`

**How to use it:** The default well is made up. Take the pore and fracture pressures from the pore-pressure sheet or the well plan, the mud from the mud program, the sections from the casing tally, and the minimum design factors from the company's casing policy. Rate the connections separately: the sheet rates the pipe body only. Down the string the sheet draws the standard load lines. Burst is taken two ways: gas to surface from a kick at the next section's TD, and lost returns with water from the fracture pressure at the shoe, both against a water backup. Collapse is full evacuation against the mud the string was run in. The axial load at each depth is the buoyed weight of the string below it, and it lowers the collapse rating. Compare the design factor of each load at each depth, and the lowest along each section, with the minimums for burst, collapse, tension with the overpull, and triaxial; each section passes only when it meets every one. One chart draws the burst and collapse loads against the ratings down the string, and another the axial load against the tension limit.

**Method:** Burst is 0.875 × 2 Yp t/D, Barlow's equation at the API minimum wall. Collapse is API's yield, plastic, transition or elastic equation, picked by D/t and the grade, with the yield strength replaced by the axial-stress equivalent grade Ypa = [√(1 − 0.75 (σa/Yp)²) − 0.5 σa/Yp] Yp. Pipe-body yield is (π/4)(D² − d²) Yp. Gas to surface puts Pp,TD − Ggas (TD − z) inside, lost returns Pfrac,shoe − Gw (shoe − z), each less Gw z outside. Full evacuation puts the mud's 0.052 MW z outside and nothing in. The buoyancy factor is 1 − MW/65.5 with the mud inside and out. The axial load at a depth is the buoyed weight per foot of each section times its length below that depth, and its stress is that load over the section's steel area, Fy/Yp. A design factor is the rating over the load at the same depth. Burst takes the larger of the two burst loads, and collapse and tension are skipped where their load is zero. The tension limit is the yield over the tension design factor, and the overpull the top joint allows is that limit less the hanging weight. The top joint's triaxial stress is von Mises over Lamé's radial and hoop stresses at the inner wall, with the gas-to-surface pressure inside, nothing outside and the hanging weight's axial stress. Its design factor is Yp over that stress.

**Example:** The default case is the drilling family's reference well, the one the pore-pressure and cement-volume sheets use: a vertical onshore well with 13⅜-in. surface casing at 4,000 ft, a 12¼-in. intermediate hole to 10,000 ft cased with 9⅝-in. P-110, 47 lb/ft above 53.5 lb/ft from 8,000 ft, and an 8½-in. production hole to 13,000 ft. The walls are 0.472 and 0.545 in.; the plain-end weight 10.68 (D − t) t lb/ft checks them at 46.1 and 52.9 lb/ft. The string is run in the 10.5 ppg intermediate mud. The pore-pressure sheet gives 13.6 ppg at the 13,000 ft TD and a 15.4 ppg fracture gradient at the shoe. The gas is 0.1 psi/ft, the water 0.465 psi/ft, and the overpull 100,000 lbf. The minimum design factors are 1.1 for burst, 1.125 for collapse, 1.6 for tension and 1.25 for triaxial.

The upper section rates 9,440 psi in burst and 5,296 psi in collapse, with a pipe-body yield of 1,493,000 lbf. The lower section rates 10,900 psi in burst and 7,950 psi in collapse. A 13.6 ppg kick at 13,000 ft is 9,194 psi, so gas to surface leaves 7,894 psi at the wellhead: a burst design factor of 9,440/7,894 = 1.196, the string's lowest. Lost returns from the 8,008 psi fracture pressure at the shoe give 3,358 psi of net burst all the way down. Full evacuation loads the 47 lb/ft pipe with 4,368 psi at the 8,000 ft crossover, where the 89,847 lbf of lower section hanging below lowers its rating to 5,261 psi: a collapse design factor of 1.20. The 53.5 lb/ft pipe's lowest is 1.46, at the shoe. The buoyancy factor in 10.5 ppg mud is 0.8397, so the 483,000 lbf string hangs 405,573 lbf at the top, a tension design factor of 3.68, with 527,527 lbf of overpull to spare at 1.6. The top joint's von Mises stress under gas to surface is 73,435 psi, a triaxial design factor of 1.50. The string meets every minimum. Run the 47 lb/ft to 9,500 ft and its collapse design factor at the crossover falls to 1.02, under the 1.125 minimum. Run N-80 in place of P-110 and the top joint fails in burst (0.87), collapse (1.07) and triaxial (1.09); a 15 ppg kick at TD puts 8,840 psi at the wellhead, a burst design factor of 1.07.

## Validity

Working-stress design with uniaxial load lines, constant gradients (a linear gas column, not the exponential one), true vertical depths and nominal dimensions. The gas-to-surface line is not capped at the shoe's fracture pressure: here the gas would break down the shoe first, so the burst load is an upper bound. The axial load is the buoyancy-factor (effective) tension of a string hanging free in one mud. It leaves out the cement's support, the change of mud after cementing, temperature and ballooning, bending in a deviated hole, and the shock and drag of running. The collapse rating's axial-stress reduction ignores internal pressure, as API's biaxial treatment does. The triaxial check is for the top joint under gas to surface only. The ratings are the pipe body's: connection leak and joint strength are separate and often lower. Minimum design factors are company policy, not part of API TR 5C3. Named alternatives: the von Mises stress at any depth for a full triaxial envelope, and the partial-evacuation load case (case 4) for evacuation to a fluid level. Field units.

## References

- American Petroleum Institute (2008). *API TR 5C3 / ISO/TR 10400:2007, Equations and Calculations for Casing, Tubing, and Line Pipe Used as Casing or Tubing* (burst, collapse, pipe-body yield, triaxial yield).
- Bourgoyne, A.T., Millheim, K.K., Chenevert, M.E. and Young, F.S. (1986). *Applied Drilling Engineering*. SPE Textbook Series Vol. 2, ch. 7 (casing design: load lines, buoyancy and design factors).
- Mitchell, R.F. and Miska, S.Z. (eds.) (2011). *Fundamentals of Drilling Engineering*. SPE Textbook Series Vol. 12 (casing design).

## Functions used

`PO.DE.Casing.Burst.API5C3`, `PO.DE.Casing.Collapse.API5C3`, `PO.DE.Casing.Axial.Yield`, `PO.DE.Casing.LoadCase`, `PO.DE.TD.Buoyancy`, `PO.DE.Casing.DesignFactor`, `PO.DE.Casing.VonMises`

## Spreadsheet: CasingDesign

|    | A                                                                                                                                                                                                 | B                                                                                                 | C                                                                                                                                                                                                                                                                                           | D                                                                | E                  | F                                                    | G                               | H                                                                        | I                                                               | J                                                                   | K                                                                       | L                   |
|----|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------|--------------------|------------------------------------------------------|---------------------------------|--------------------------------------------------------------------------|-----------------------------------------------------------------|---------------------------------------------------------------------|-------------------------------------------------------------------------|---------------------|
| 1  | Casing Design                                                                                                                                                                                     |                                                                                                   | Petroleum Office                                                                                                                                                                                                                                                                            |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 2  | Blue cells on yellow are inputs. Enter the string's two sections, the mud it is run in, and the pore and fracture pressures from the pore-pressure sheet.                                         |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 3  | String                                                                                                                                                                                            |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 4  | Casing outside diameter                                                                                                                                                                           | 9.625                                                                                             | in                                                                                                                                                                                                                                                                                          |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 5  | Minimum yield strength of the grade (P-110)                                                                                                                                                       | 110000                                                                                            | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 6  | Setting depth of the shoe (TVD)                                                                                                                                                                   | 10000                                                                                             | ft                                                                                                                                                                                                                                                                                          |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 7  | Crossover from the upper to the lower section (TVD)                                                                                                                                               | 8000                                                                                              | ft                                                                                                                                                                                                                                                                                          |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 8  | Upper section's nominal weight                                                                                                                                                                    | 47                                                                                                | lb/ft                                                                                                                                                                                                                                                                                       |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 9  | Upper section's wall thickness                                                                                                                                                                    | 0.472                                                                                             | in                                                                                                                                                                                                                                                                                          |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 10 | Lower section's nominal weight                                                                                                                                                                    | 53.5                                                                                              | lb/ft                                                                                                                                                                                                                                                                                       |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 11 | Lower section's wall thickness                                                                                                                                                                    | 0.545                                                                                             | in                                                                                                                                                                                                                                                                                          |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 12 | Loads                                                                                                                                                                                             |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 13 | Mud the string is run in, outside it for collapse                                                                                                                                                 | 10.5                                                                                              | ppg                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 14 | Pore pressure at the next TD (pore-pressure sheet)                                                                                                                                                | 13.6                                                                                              | ppg                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 15 | Next section's TD (TVD)                                                                                                                                                                           | 13000                                                                                             | ft                                                                                                                                                                                                                                                                                          |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 16 | Fracture gradient at the shoe (pore-pressure sheet)                                                                                                                                               | 15.4                                                                                              | ppg                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 17 | Gas gradient for the gas-to-surface kick                                                                                                                                                          | 0.1                                                                                               | psi/ft                                                                                                                                                                                                                                                                                      |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 18 | Water gradient: inside for lost returns, the backup outside                                                                                                                                       | 0.465                                                                                             | psi/ft                                                                                                                                                                                                                                                                                      |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 19 | Overpull the top joint must allow over the hanging weight                                                                                                                                         | 100000                                                                                            | lbf                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 20 | Minimum Design Factors                                                                                                                                                                            |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 21 | Burst                                                                                                                                                                                             | 1.1                                                                                               | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 22 | Collapse                                                                                                                                                                                          | 1.125                                                                                             | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 23 | Tension (pipe-body yield)                                                                                                                                                                         | 1.6                                                                                               | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 24 | Triaxial (von Mises)                                                                                                                                                                              | 1.25                                                                                              | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 26 | Ratings (API TR 5C3)                                                                                                                                                                              |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 27 | Burst rating, upper section                                                                                                                                                                       | =PO.DE.Casing.Burst.API5C3(CSG_OD,CSG_T1,CSG_Yp)                                                  | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 28 | Burst rating, lower section                                                                                                                                                                       | =PO.DE.Casing.Burst.API5C3(CSG_OD,CSG_T2,CSG_Yp)                                                  | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 29 | Collapse rating with no axial load, upper section                                                                                                                                                 | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,0,0)                                           | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 30 | Collapse rating with no axial load, lower section                                                                                                                                                 | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T2,CSG_Yp,0,0)                                           | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 31 | Pipe-body yield, upper section                                                                                                                                                                    | =PO.DE.Casing.Axial.Yield(CSG_OD,CSG_T1,CSG_Yp)                                                   | lbf                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 32 | Pipe-body yield, lower section                                                                                                                                                                    | =PO.DE.Casing.Axial.Yield(CSG_OD,CSG_T2,CSG_Yp)                                                   | lbf                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 33 | Loads                                                                                                                                                                                             |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 34 | Gas-kick pressure at the next section's TD                                                                                                                                                        | =CSG_PpTD*CSG_Psi*CSG_TD                                                                          | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 35 | Surface pressure with gas to surface                                                                                                                                                              | =CSG_Pref-CSG_Ggas*CSG_TD                                                                         | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 36 | Fracture pressure at the shoe                                                                                                                                                                     | =CSG_FgShoe*CSG_Psi*CSG_Shoe                                                                      | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 37 | Buoyancy factor in the mud                                                                                                                                                                        | =INDEX(PO.DE.TD.Buoyancy(CSG_W1,CSG_OD,CSG_OD-2*CSG_T1,CSG_MW,CSG_MW,CSG_Steel),1,1)              | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 38 | Buoyed weight, upper section                                                                                                                                                                      | =INDEX(PO.DE.TD.Buoyancy(CSG_W1,CSG_OD,CSG_OD-2*CSG_T1,CSG_MW,CSG_MW,CSG_Steel),1,2)              | lb/ft                                                                                                                                                                                                                                                                                       |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 39 | Buoyed weight, lower section                                                                                                                                                                      | =INDEX(PO.DE.TD.Buoyancy(CSG_W2,CSG_OD,CSG_OD-2*CSG_T2,CSG_MW,CSG_MW,CSG_Steel),1,2)              | lb/ft                                                                                                                                                                                                                                                                                       |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 40 | Hanging weight in air                                                                                                                                                                             | =CSG_W1*CSG_Xover+CSG_W2*(CSG_Shoe-CSG_Xover)                                                     | lbf                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 41 | Buoyed hanging weight at the top                                                                                                                                                                  | =CSG_Wb1*CSG_Xover+CSG_Wb2*(CSG_Shoe-CSG_Xover)                                                   | lbf                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 42 | Buoyed hanging weight at the crossover                                                                                                                                                            | =CSG_Wb2*(CSG_Shoe-CSG_Xover)                                                                     | lbf                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 43 | Design Factors (the lowest along each section)                                                                                                                                                    |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 44 | Burst, upper section                                                                                                                                                                              | =MIN(I65:I75)                                                                                     | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 45 | Burst, lower section                                                                                                                                                                              | =MIN(I76:I81)                                                                                     | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 46 | Collapse, upper section                                                                                                                                                                           | =MIN(J65:J75)                                                                                     | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 47 | Collapse, lower section                                                                                                                                                                           | =MIN(J76:J81)                                                                                     | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 48 | Tension, the top joint                                                                                                                                                                            | =INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,CSG_Htop,CSG_DFt),1,1)                                   | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 49 | Tension, the lower section's top joint                                                                                                                                                            | =INDEX(PO.DE.Casing.DesignFactor(CSG_Fy2,CSG_Hx,CSG_DFt),1,1)                                     | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 50 | Overpull the top joint allows at its design factor                                                                                                                                                | =CSG_Fy1/CSG_DFt-CSG_Htop                                                                         | lbf                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 51 | Von Mises stress, top joint's inner wall, gas to surface                                                                                                                                          | =PO.DE.Casing.VonMises(CSG_OD,CSG_T1,CSG_Psurf,0,CSG_Htop*CSG_Yp/CSG_Fy1,CSG_OD/2-CSG_T1)         | psi                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 52 | Triaxial, the top joint                                                                                                                                                                           | =CSG_Yp/CSG_VM                                                                                    | —                                                                                                                                                                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 53 | Burst check                                                                                                                                                                                       | =IF(MIN(CSG_DFb1,CSG_DFb2)>=CSG_DFb,"PASS","FAIL")                                                | =IF(MIN(CSG_DFb1,CSG_DFb2)>=CSG_DFb,"the lowest burst design factor, "&TEXT(MIN(CSG_DFb1,CSG_DFb2),"0.00")&", meets the minimum","the lowest burst design factor, "&TEXT(MIN(CSG_DFb1,CSG_DFb2),"0.00")&", is under the minimum: a heavier or stronger top section")                        |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 54 | Collapse check                                                                                                                                                                                    | =IF(MIN(CSG_DFc1,CSG_DFc2)>=CSG_DFc,"PASS","FAIL")                                                | =IF(MIN(CSG_DFc1,CSG_DFc2)>=CSG_DFc,"the lowest collapse design factor, "&TEXT(MIN(CSG_DFc1,CSG_DFc2),"0.00")&", meets the minimum","the lowest collapse design factor, "&TEXT(MIN(CSG_DFc1,CSG_DFc2),"0.00")&", is under the minimum: raise the crossover or run a heavier lower section") |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 55 | Tension check                                                                                                                                                                                     | =IF(AND(MIN(CSG_DFt1,CSG_DFt2)>=CSG_DFt,CSG_Pull>=CSG_Overpull),"PASS","FAIL")                    | =IF(AND(MIN(CSG_DFt1,CSG_DFt2)>=CSG_DFt,CSG_Pull>=CSG_Overpull),"both top joints meet the tension design factor with the overpull to spare","a top joint is under the tension design factor or can't take the overpull")                                                                    |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 56 | Triaxial check                                                                                                                                                                                    | =IF(CSG_DFvm1>=CSG_DFvm,"PASS","FAIL")                                                            | =IF(CSG_DFvm1>=CSG_DFvm,"the top joint's triaxial design factor meets the minimum","the top joint's triaxial design factor is under the minimum")                                                                                                                                           |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 57 | Upper section check                                                                                                                                                                               | =IF(AND(CSG_DFb1>=CSG_DFb,CSG_DFc1>=CSG_DFc,CSG_DFt1>=CSG_DFt,CSG_DFvm1>=CSG_DFvm),"PASS","FAIL") | =IF(AND(CSG_DFb1>=CSG_DFb,CSG_DFc1>=CSG_DFc,CSG_DFt1>=CSG_DFt,CSG_DFvm1>=CSG_DFvm),"the upper section meets every design factor","the upper section misses a design factor")                                                                                                                |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 58 | Lower section check                                                                                                                                                                               | =IF(AND(CSG_DFb2>=CSG_DFb,CSG_DFc2>=CSG_DFc,CSG_DFt2>=CSG_DFt),"PASS","FAIL")                     | =IF(AND(CSG_DFb2>=CSG_DFb,CSG_DFc2>=CSG_DFc,CSG_DFt2>=CSG_DFt),"the lower section meets every design factor","the lower section misses a design factor")                                                                                                                                    |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 60 | How to use it: take the pore and fracture pressures from the pore-pressure sheet or the well plan, the mud from the mud program, and the minimum design factors from the company's casing policy. |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 61 | The load lines are the uniaxial working-stress cases; the triaxial check is for the top joint under the gas-to-surface case.                                                                      |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 63 | Load Lines Down the String                                                                                                                                                                        |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 64 | Depth TVD (ft)                                                                                                                                                                                    | Section                                                                                           | Burst, gas (psi)                                                                                                                                                                                                                                                                            | Burst, losses (psi)                                              | Burst rating (psi) | Collapse load (psi)                                  | Axial load (lbf)                | Collapse rating (psi)                                                    | DF burst (—)                                                    | DF collapse (—)                                                     | DF tension (—)                                                          | Tension limit (lbf) |
| 65 | =CSG_Xover*0/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A65,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A65,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A65,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A65)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G65*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E65,MAX(C65,D65),CSG_DFb),1,1) | =IF(F65>0,INDEX(PO.DE.Casing.DesignFactor(H65,F65,CSG_DFc),1,1),"") | =IF(G65>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G65,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 66 | =CSG_Xover*1/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A66,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A66,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A66,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A66)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G66*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E66,MAX(C66,D66),CSG_DFb),1,1) | =IF(F66>0,INDEX(PO.DE.Casing.DesignFactor(H66,F66,CSG_DFc),1,1),"") | =IF(G66>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G66,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 67 | =CSG_Xover*2/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A67,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A67,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A67,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A67)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G67*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E67,MAX(C67,D67),CSG_DFb),1,1) | =IF(F67>0,INDEX(PO.DE.Casing.DesignFactor(H67,F67,CSG_DFc),1,1),"") | =IF(G67>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G67,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 68 | =CSG_Xover*3/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A68,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A68,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A68,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A68)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G68*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E68,MAX(C68,D68),CSG_DFb),1,1) | =IF(F68>0,INDEX(PO.DE.Casing.DesignFactor(H68,F68,CSG_DFc),1,1),"") | =IF(G68>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G68,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 69 | =CSG_Xover*4/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A69,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A69,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A69,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A69)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G69*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E69,MAX(C69,D69),CSG_DFb),1,1) | =IF(F69>0,INDEX(PO.DE.Casing.DesignFactor(H69,F69,CSG_DFc),1,1),"") | =IF(G69>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G69,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 70 | =CSG_Xover*5/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A70,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A70,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A70,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A70)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G70*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E70,MAX(C70,D70),CSG_DFb),1,1) | =IF(F70>0,INDEX(PO.DE.Casing.DesignFactor(H70,F70,CSG_DFc),1,1),"") | =IF(G70>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G70,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 71 | =CSG_Xover*6/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A71,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A71,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A71,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A71)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G71*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E71,MAX(C71,D71),CSG_DFb),1,1) | =IF(F71>0,INDEX(PO.DE.Casing.DesignFactor(H71,F71,CSG_DFc),1,1),"") | =IF(G71>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G71,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 72 | =CSG_Xover*7/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A72,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A72,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A72,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A72)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G72*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E72,MAX(C72,D72),CSG_DFb),1,1) | =IF(F72>0,INDEX(PO.DE.Casing.DesignFactor(H72,F72,CSG_DFc),1,1),"") | =IF(G72>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G72,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 73 | =CSG_Xover*8/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A73,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A73,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A73,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A73)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G73*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E73,MAX(C73,D73),CSG_DFb),1,1) | =IF(F73>0,INDEX(PO.DE.Casing.DesignFactor(H73,F73,CSG_DFc),1,1),"") | =IF(G73>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G73,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 74 | =CSG_Xover*9/10                                                                                                                                                                                   | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A74,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A74,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A74,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A74)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G74*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E74,MAX(C74,D74),CSG_DFb),1,1) | =IF(F74>0,INDEX(PO.DE.Casing.DesignFactor(H74,F74,CSG_DFc),1,1),"") | =IF(G74>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G74,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 75 | =CSG_Xover*10/10                                                                                                                                                                                  | Upper                                                                                             | =PO.DE.Casing.LoadCase(1,A75,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A75,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb1           | =PO.DE.Casing.LoadCase(3,A75,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb1*(CSG_Xover-A75)+CSG_Hx | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T1,CSG_Yp,G75*CSG_Yp/CSG_Fy1,0) | =INDEX(PO.DE.Casing.DesignFactor(E75,MAX(C75,D75),CSG_DFb),1,1) | =IF(F75>0,INDEX(PO.DE.Casing.DesignFactor(H75,F75,CSG_DFc),1,1),"") | =IF(G75>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy1,G75,CSG_DFt),1,1),"") | =CSG_Fy1/CSG_DFt    |
| 76 | =CSG_Xover+(CSG_Shoe-CSG_Xover)*0/5                                                                                                                                                               | Lower                                                                                             | =PO.DE.Casing.LoadCase(1,A76,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A76,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb2           | =PO.DE.Casing.LoadCase(3,A76,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb2*(CSG_Shoe-A76)         | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T2,CSG_Yp,G76*CSG_Yp/CSG_Fy2,0) | =INDEX(PO.DE.Casing.DesignFactor(E76,MAX(C76,D76),CSG_DFb),1,1) | =IF(F76>0,INDEX(PO.DE.Casing.DesignFactor(H76,F76,CSG_DFc),1,1),"") | =IF(G76>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy2,G76,CSG_DFt),1,1),"") | =CSG_Fy2/CSG_DFt    |
| 77 | =CSG_Xover+(CSG_Shoe-CSG_Xover)*1/5                                                                                                                                                               | Lower                                                                                             | =PO.DE.Casing.LoadCase(1,A77,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A77,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb2           | =PO.DE.Casing.LoadCase(3,A77,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb2*(CSG_Shoe-A77)         | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T2,CSG_Yp,G77*CSG_Yp/CSG_Fy2,0) | =INDEX(PO.DE.Casing.DesignFactor(E77,MAX(C77,D77),CSG_DFb),1,1) | =IF(F77>0,INDEX(PO.DE.Casing.DesignFactor(H77,F77,CSG_DFc),1,1),"") | =IF(G77>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy2,G77,CSG_DFt),1,1),"") | =CSG_Fy2/CSG_DFt    |
| 78 | =CSG_Xover+(CSG_Shoe-CSG_Xover)*2/5                                                                                                                                                               | Lower                                                                                             | =PO.DE.Casing.LoadCase(1,A78,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A78,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb2           | =PO.DE.Casing.LoadCase(3,A78,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb2*(CSG_Shoe-A78)         | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T2,CSG_Yp,G78*CSG_Yp/CSG_Fy2,0) | =INDEX(PO.DE.Casing.DesignFactor(E78,MAX(C78,D78),CSG_DFb),1,1) | =IF(F78>0,INDEX(PO.DE.Casing.DesignFactor(H78,F78,CSG_DFc),1,1),"") | =IF(G78>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy2,G78,CSG_DFt),1,1),"") | =CSG_Fy2/CSG_DFt    |
| 79 | =CSG_Xover+(CSG_Shoe-CSG_Xover)*3/5                                                                                                                                                               | Lower                                                                                             | =PO.DE.Casing.LoadCase(1,A79,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A79,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb2           | =PO.DE.Casing.LoadCase(3,A79,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb2*(CSG_Shoe-A79)         | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T2,CSG_Yp,G79*CSG_Yp/CSG_Fy2,0) | =INDEX(PO.DE.Casing.DesignFactor(E79,MAX(C79,D79),CSG_DFb),1,1) | =IF(F79>0,INDEX(PO.DE.Casing.DesignFactor(H79,F79,CSG_DFc),1,1),"") | =IF(G79>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy2,G79,CSG_DFt),1,1),"") | =CSG_Fy2/CSG_DFt    |
| 80 | =CSG_Xover+(CSG_Shoe-CSG_Xover)*4/5                                                                                                                                                               | Lower                                                                                             | =PO.DE.Casing.LoadCase(1,A80,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A80,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb2           | =PO.DE.Casing.LoadCase(3,A80,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb2*(CSG_Shoe-A80)         | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T2,CSG_Yp,G80*CSG_Yp/CSG_Fy2,0) | =INDEX(PO.DE.Casing.DesignFactor(E80,MAX(C80,D80),CSG_DFb),1,1) | =IF(F80>0,INDEX(PO.DE.Casing.DesignFactor(H80,F80,CSG_DFc),1,1),"") | =IF(G80>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy2,G80,CSG_DFt),1,1),"") | =CSG_Fy2/CSG_DFt    |
| 81 | =CSG_Xover+(CSG_Shoe-CSG_Xover)*5/5                                                                                                                                                               | Lower                                                                                             | =PO.DE.Casing.LoadCase(1,A81,CSG_Pref,CSG_TD,CSG_Ggas,CSG_Gw,0)                                                                                                                                                                                                                             | =PO.DE.Casing.LoadCase(2,A81,CSG_Pfrac,CSG_Shoe,CSG_Gw,CSG_Gw,0) | =CSG_Pb2           | =PO.DE.Casing.LoadCase(3,A81,0,0,0,CSG_MW*CSG_Psi,0) | =CSG_Wb2*(CSG_Shoe-A81)         | =PO.DE.Casing.Collapse.API5C3(CSG_OD,CSG_T2,CSG_Yp,G81*CSG_Yp/CSG_Fy2,0) | =INDEX(PO.DE.Casing.DesignFactor(E81,MAX(C81,D81),CSG_DFb),1,1) | =IF(F81>0,INDEX(PO.DE.Casing.DesignFactor(H81,F81,CSG_DFc),1,1),"") | =IF(G81>0,INDEX(PO.DE.Casing.DesignFactor(CSG_Fy2,G81,CSG_DFt),1,1),"") | =CSG_Fy2/CSG_DFt    |
| 83 | Constants                                                                                                                                                                                         |                                                                                                   |                                                                                                                                                                                                                                                                                             |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 84 | Pressure gradient of 1 ppg of mud                                                                                                                                                                 | 0.052                                                                                             | psi/ft/ppg                                                                                                                                                                                                                                                                                  |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |
| 85 | Density of steel                                                                                                                                                                                  | 65.5                                                                                              | ppg                                                                                                                                                                                                                                                                                         |                                                                  |                    |                                                      |                                 |                                                                          |                                                                 |                                                                     |                                                                         |                     |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.DE.Casing.Burst.API5C3 | =LAMBDA(OD_in, t_in, Yp_psi, 0.875*2*Yp_psi*t_in/OD_in) | API TR 5C3 pipe-body internal yield (burst) pressure, Barlow with the 0.875 wall tolerance, [psi]. |
| PO.DE.Casing.Collapse.API5C3 | =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)))) | API TR 5C3 collapse pressure in the yield, plastic, transition or elastic regime chosen from D/t, with the axial-stress equivalent grade; Output 1 adds the regime, 2 returns the regime D/t limits, [psi]. |
| PO.DE.Casing.Axial.Yield | =LAMBDA(BodyOD_in, BodyWall_in, BodyYp_psi, PI()/4*(BodyOD_in^2-(BodyOD_in-2*BodyWall_in)^2)*BodyYp_psi) | API TR 5C3 pipe-body yield strength, Fy = (pi/4)(D^2 - d^2) Yp, [lbf]. |
| PO.DE.Casing.LoadCase | =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)))) | Casing load line at a depth: net burst (1 gas to surface, 2 lost returns with water) or net collapse (3 full evacuation, 4 partial evacuation) pressure with the external backup, [psi]. |
| PO.DE.Casing.DesignFactor | =LAMBDA(Rating, Load, DF_min, LET(df, Rating/Load, HSTACK(df, IF(df>=DF_min, 1, 0)))) | Casing design factor, rating / load, and whether it meets the named minimum design factor (1 pass, 0 fail). |
| PO.DE.Casing.VonMises | =LAMBDA(WallOD_in, t_in, Pi_psi, Po_psi, Sa_psi, r_in, LET(ro, WallOD_in/2, ri, ro-t_in, k, ro^2-ri^2, mean, (Pi_psi*ri^2-Po_psi*ro^2)/k, dev, (Pi_psi-Po_psi)*ri^2*ro^2/(k*r_in^2), sr, mean-dev, sh, mean+dev, SQRT(((Sa_psi-sr)^2+(sr-sh)^2+(sh-Sa_psi)^2)/2))) | Triaxial (von Mises) equivalent stress at radius r of a casing wall: Lame radial and hoop stress from internal and external pressure plus the axial stress, [psi]. |
| PO.DE.TD.Buoyancy | =LAMBDA(PipeW_lbft, PipeOD_in, PipeID_in, MWi_ppg, MWo_ppg, RhoSteel_ppg, LET(bf, 1 - (MWo_ppg*PipeOD_in^2 - MWi_ppg*PipeID_in^2) / (RhoSteel_ppg*(PipeOD_in^2 - PipeID_in^2)), HSTACK(bf, PipeW_lbft*bf))) | Buoyancy factor of a pipe with different fluids inside and outside, and its buoyed weight per foot: {BF, lb/ft}. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| CSG_OD | $B$4 | Casing outside diameter, in |
| CSG_Yp | $B$5 | Minimum yield strength of the grade (P-110), psi |
| CSG_Shoe | $B$6 | Setting depth of the shoe (TVD), ft |
| CSG_Xover | $B$7 | Crossover from the upper to the lower section (TVD), ft |
| CSG_W1 | $B$8 | Upper section's nominal weight, lb/ft |
| CSG_T1 | $B$9 | Upper section's wall thickness, in |
| CSG_W2 | $B$10 | Lower section's nominal weight, lb/ft |
| CSG_T2 | $B$11 | Lower section's wall thickness, in |
| CSG_MW | $B$13 | Mud the string is run in, outside it for collapse, ppg |
| CSG_PpTD | $B$14 | Pore pressure at the next TD (pore-pressure sheet), ppg |
| CSG_TD | $B$15 | Next section's TD (TVD), ft |
| CSG_FgShoe | $B$16 | Fracture gradient at the shoe (pore-pressure sheet), ppg |
| CSG_Ggas | $B$17 | Gas gradient for the gas-to-surface kick, psi/ft |
| CSG_Gw | $B$18 | Water gradient: inside for lost returns, the backup outside, psi/ft |
| CSG_Overpull | $B$19 | Overpull the top joint must allow over the hanging weight, lbf |
| CSG_DFb | $B$21 | Burst |
| CSG_DFc | $B$22 | Collapse |
| CSG_DFt | $B$23 | Tension (pipe-body yield) |
| CSG_DFvm | $B$24 | Triaxial (von Mises) |
| CSG_Inputs | $B$4:$B$24 | The string's diameter, grade, shoe, crossover and two sections, the mud, the pore and fracture pressures, the gas and water gradients, the overpull and the four minimum design factors |
| CSG_Pb1 | $B$27 | Burst rating, upper section, psi |
| CSG_Pb2 | $B$28 | Burst rating, lower section, psi |
| CSG_Pc1 | $B$29 | Collapse rating with no axial load, upper section, psi |
| CSG_Pc2 | $B$30 | Collapse rating with no axial load, lower section, psi |
| CSG_Fy1 | $B$31 | Pipe-body yield, upper section, lbf |
| CSG_Fy2 | $B$32 | Pipe-body yield, lower section, lbf |
| CSG_Pref | $B$34 | Gas-kick pressure at the next section's TD, psi |
| CSG_Psurf | $B$35 | Surface pressure with gas to surface, psi |
| CSG_Pfrac | $B$36 | Fracture pressure at the shoe, psi |
| CSG_BF | $B$37 | Buoyancy factor in the mud |
| CSG_Wb1 | $B$38 | Buoyed weight, upper section, lb/ft |
| CSG_Wb2 | $B$39 | Buoyed weight, lower section, lb/ft |
| CSG_Hair | $B$40 | Hanging weight in air, lbf |
| CSG_Htop | $B$41 | Buoyed hanging weight at the top, lbf |
| CSG_Hx | $B$42 | Buoyed hanging weight at the crossover, lbf |
| CSG_DFb1 | $B$44 | Burst, upper section |
| CSG_DFb2 | $B$45 | Burst, lower section |
| CSG_DFc1 | $B$46 | Collapse, upper section |
| CSG_DFc2 | $B$47 | Collapse, lower section |
| CSG_DFt1 | $B$48 | Tension, the top joint |
| CSG_DFt2 | $B$49 | Tension, the lower section's top joint |
| CSG_Pull | $B$50 | Overpull the top joint allows at its design factor, lbf |
| CSG_VM | $B$51 | Von Mises stress, top joint's inner wall, gas to surface, psi |
| CSG_DFvm1 | $B$52 | Triaxial, the top joint |
| CSG_BurstCheck | $B$53 | Burst check verdict |
| CSG_BurstCheckNote | $C$53 | Burst check comment |
| CSG_CollapseCheck | $B$54 | Collapse check verdict |
| CSG_CollapseCheckNote | $C$54 | Collapse check comment |
| CSG_TensionCheck | $B$55 | Tension check verdict |
| CSG_TensionCheckNote | $C$55 | Tension check comment |
| CSG_TriaxialCheck | $B$56 | Triaxial check verdict |
| CSG_TriaxialCheckNote | $C$56 | Triaxial check comment |
| CSG_UpperCheck | $B$57 | Upper section check verdict |
| CSG_UpperCheckNote | $C$57 | Upper section check comment |
| CSG_LowerCheck | $B$58 | Lower section check verdict |
| CSG_LowerCheckNote | $C$58 | Lower section check comment |
| CSG_Results | $B$27:$B$58 | Each section's ratings, the kick, surface and fracture pressures, the buoyed weights and hanging weights, the lowest design factors, the overpull, the top joint's von Mises stress, and the six checks |
| CSG_Curve | $A$65:$L$81 | Depth, section, the burst loads for gas to surface and lost returns, the burst rating, the collapse load for full evacuation, the axial load, the collapse rating under it, the three design factors and the tension limit |
| CSG_Psi | $B$84 | Pressure gradient of 1 ppg of mud, psi/ft/ppg |
| CSG_Steel | $B$85 | Density of steel, ppg |

---

## Related Blueprints
- [Plug and Abandonment Design](/blueprint/po.de.pa.design.md)
- [Soft-String Torque and Drag](/blueprint/po.de.torque.drag.md)
- [Tubing Stress and Movement](/blueprint/po.de.tubing.stress.md)
- [BOP Accumulator Sizing](/blueprint/po.de.wellcontrol.accumulator.md)
- [Surge and Swab Trip Speed](/blueprint/po.de.surge.swab.md)
- [Hole Cleaning and Solids Control](/blueprint/po.de.holecleaning.solids.md)

