---
cid: po.bp.de.tubing.stress
hub: de
tags: [completion, tubing, tubing-movement, tubing-stress, packer, packer-force, seal-assembly, Lubinski, Hammerlindl, piston, ballooning, thermal, helical-buckling, von-Mises, triaxial, design-factor]
facets: { discipline: completions, property: tubing-movement, method-type: analytical }
title: Tubing Stress and Movement
summary: "Works the length changes and packer force from Lubinski's four effects for production, injection and shut-in, with a triaxial check of the tubing."
slug: po.de.tubing.stress
type: worksheet
---

# Tubing Stress and Movement

## Description

Will the tubing stay in its packer, and hold, when the well goes from the conditions the packer was set in to production, injection or a shut-in? You enter the tubing, the packer and its seal bore, the fluids and temperatures when the packer was set, and each load case's pressures, densities and temperatures. You read off how far free tubing moves against its seal travel, or the load a latched packer takes, whether the tubing buckles, and the top joint's triaxial and tension design factors.

**Parameters:**
- **Tubing and packer**: the tubing OD `TS_OD` and ID `TS_ID` (in), its weight `TS_W` (lb/ft), the grade's yield `TS_Yp`, Young's modulus `TS_E` (psi), Poisson's ratio `TS_Nu`, the thermal expansion coefficient `TS_Beta` (1/°F), the packer depth `TS_Packer` (ft MD), its seal bore `TS_Bore` and the casing ID at the packer `TS_CsgID` (in), the mode `TS_Mode` (0 free in the seal bore, 1 latched), the seal travel up `TS_SealUp` and down `TS_SealDown` (in), and the packer's rating `TS_PkRating` (lbf)
- **When the packer was set**: the packer fluid `TS_Rho0` (ppg) in the tubing and annulus, the surface temperature `TS_Ts0` and the static temperature at the packer `TS_Tp0` (°F)
- **Load cases**: for production (`Prod`), injection (`Inj`) and shut-in (`Shut`), the tubing fluid's average density `TS_Rho…` (ppg), the surface tubing and annulus pressures `TS_Pt…`, `TS_Pa…` (psi), and the tubing temperature at the surface and at the packer `TS_Ts…`, `TS_Tp…` (°F)
- **Design factors and the sweep**: the minimum triaxial `TS_DFvm` and tension `TS_DFt` design factors, the helical critical-load mode `TS_HelMode` (0 at the packer's inclination, 1 vertical), and the sweep's lowest injection pressure `TS_StartP` and its step `TS_StepP` (psi)

**How to use it:** The load cases are made up. Take the tubing's pressures and densities from the well's flowing and shut-in gradient surveys or the injection plan, the temperatures from a flowing-temperature model or a temperature log, the seal travel, bore and rating from the packer's data sheet, and the survey from the well's directional survey. The packer's depth comes from the wellbore-schematic workbook's survey, which puts the packer's 9,300 ft MD at its TVD on the minimum-curvature survey, so this sheet and the schematic state the same depth; pressures use the TVD and the tubing's length the MD. The sheet works each of Lubinski's effects in its own cells for each case: the piston force on the tubing's end in the seal bore, ballooning from the average pressure changes, the temperature change, and helical buckling above the packer, from the buoyed weight with the case's fluids and the critical helical load at the packer's inclination. A sweep of the injection pressure charts the free tubing's movement, effect by effect, against the seal travel. Check that free tubing moves less than its seal travel, or that a latched packer's load is under its rating; whether a case buckles the tubing, and whether the helix reaches the surface; and that the top joint's lowest triaxial and tension design factors are over their minimums.

**Method:** Each load case changes the pressure inside the tubing, the pressure in the annulus and the tubing's temperature, and Lubinski's four effects turn those changes into forces and length changes at the packer. The pressure change inside the tubing at the packer is the surface pressure plus the change of the fluid column, Pt + 0.052 (ρ − ρ0) TVD, and in the annulus the surface pressure. The average changes are the means of the surface and packer values, and the temperature change is the change of the mean of the surface and packer temperatures. The piston force is F1 = (Ap − Ai) ΔPi − (Ap − Ao) ΔPo. Ballooning is F2 = 2ν (ΔPia Ai − ΔPoa Ao). The temperature force is F3 = −E β As ΔT. Each length change is −12 L F / (E As), or 12 L β ΔT for temperature, with L the packer's MD. A positive force shortens free tubing and a positive length change lengthens it, so the effects add. The fictitious force is Ff = Ap (ΔPi − ΔPo), less the packer's load when the tubing is latched. It buckles the tubing above the critical helical load, 2√2 √(E I w sin θ / r) at the packer's inclination θ, with r the radial clearance. Lubinski's buckling then shortens it by r² (Ff² − Fcr²) / (8 E I w), with w the buoyed weight per inch, over a length (Ff − Fcr) / W. The tubing either floats in the seal bore, where it moves by the sum of the four, or is latched, where it puts F1 + F2 + F3 on the packer (Hammerlindl). The top joint carries the landing tension, the buoyed weight times the packer's TVD. Free tubing loses the piston force from it. Latched tubing adds the ballooning and temperature forces the packer holds. The von Mises stress at the inner wall takes Lamé's radial and hoop stresses from the surface pressures. The triaxial design factor is Yp over that stress, and the tension design factor is the pipe-body yield over the axial force. The sweep repeats the injection case at each surface pressure, and the highest pressure the seal travel takes is read straight between the two sweep rows on either side of it.

**Example:** The wellbore-schematic workbook's well, example well A-12: vertical to a kick-off at 2,500 ft, built at 1.5°/100 ft to 30° at 4,500 ft MD and held to TD at 10,000 ft MD (9,173 ft TVD). The completion is 3½-in. 9.3 lb/ft L-80 tubing (ID 2.992 in.) on a production packer at 9,300 ft MD in the 7-in. 29 lb/ft liner (ID 6.184 in.). The tubing seals in a 4.00-in. bore, free to move, with 96 in. of seal travel up and 48 in. down. The packer was set in the workbook's 9.0 ppg packer fluid, at 70 °F at the surface and 207 °F at the packer. Production flows 6.5 ppg of oil and gas at 500 psi, at 160 °F at the surface and 205 °F at the packer. Injection is 8.6 ppg water at 3,000 psi, at 60 °F and 120 °F. Shut-in leaves 1,800 psi on the 6.5 ppg column, at 120 °F and 205 °F. The annulus stays at 0 psi. The design factors are 1.25 triaxial and 1.6 in tension. The schematic gives the strings' ODs only; the tubing grade, the liner weight, the seal bore and the load cases are this sheet's choices.

The packer sits at 8,567 ft TVD, on the 30° hold. The tubing's steel area is 2.590 in², and the bore's 12.566 in². In the packer fluid it weighs 8.02 lb/ft buoyed, so it hangs 68,724 lbf at the top. Injection puts 2,822 psi more in the tubing at the packer, 2,911 psi more on average, and cools it 48.5 °F. Piston, ballooning and temperature forces of 15,620, 12,280 and 26,004 lbf shorten the free tubing 22.4, 17.6 and 37.3 in. The 35,460 lbf fictitious force is over the 14,186 lbf critical helical load, so the bottom 2,704 ft buckles and shortens it 3.5 in. more, 80.9 in. in all, inside the 96 in. of seal travel. Production heats the tubing 44 °F and lengthens it 39.1 in., inside the 48 in. of space-out. Shut-in moves it 5.5 in. The seal travel holds the injection up to 3,863 psi at the surface. Latched, the same tubing would pull 53,904 lbf on the packer while injecting and push 27,228 lbf while producing. The top joint's lowest triaxial design factor is 3.00, in production, and its lowest tension design factor 2.87. Every design factor holds; the buckled injection case is the one to watch. Latched, the producing tubing buckles over 861 ft instead, and the injection raises the top joint's axial force to 107,008 lbf, a tension design factor of 1.94. J-55 tubing latched and injecting at 5,000 psi fails both: 1.23 triaxial and 1.23 in tension.

## Validity

Lubinski's analysis is elastic, for one tubing size from the surface to the packer, with average pressures and an average temperature change along the string. A tapered string, or a string whose fluid density changes along it, needs the effects worked by section. The buckling length change ignores friction against the casing and uses the full buoyed weight per foot, as in a vertical well; in the deviated well the inclination enters only through the critical helical load (setting the helical critical-load mode to 1 takes the vertical form). With latched tubing the packer load is F1 + F2 + F3; the small relief the helix gives back is left out, which is conservative. The fictitious force carries no slack-off: tubing landed with set-down weight adds it to Ff. The annulus keeps the packer fluid in every case, and the top-joint check uses the surface pressures. The bending stress of the helix at the packer, the collapse of the tubing under annulus pressure and the connections' ratings are not checked. A full tubing-movement program (WellCat, or a stiff-string tubing model) handles friction, tapered strings, temperature profiles and the iteration of a latched, buckled string. Field units.

## References

- Lubinski, A., Althouse, W.S. and Logan, J.L. (1962). Helical Buckling of Tubing Sealed in Packers. *Journal of Petroleum Technology* 14(6), 655–670. SPE-178-PA.
- Hammerlindl, D.J. (1977). Movement, Forces and Stresses Associated With Combination Tubing Strings Sealed in Packers. *Journal of Petroleum Technology* 29(2) (February 1977).
- Mitchell, R.F. and Miska, S.Z. (eds.) (2011). *Fundamentals of Drilling Engineering*. SPE Textbook Series Vol. 12 (tubing and casing buckling, the critical helical load).
- 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* (pipe-body yield, triaxial yield).

## Functions used

`PO.CO.Tubing.Piston`, `PO.CO.Tubing.Ballooning`, `PO.CO.Tubing.Thermal`, `PO.CO.Tubing.Buckling`, `PO.DE.TD.Buoyancy`, `PO.DE.TD.Buckling.Helical`, `PO.DE.Casing.VonMises`, `PO.DE.Casing.Axial.Yield`, `PO.CO.Schematic.Depths`, `PO.DE.Dir.DoglegSeverity`, `PO.DE.Dir.RatioFactor`, `PO.DE.Dir.MinCurv.dTVD`

## Spreadsheet: TubingStress

|     | A                                                                                                                                                                                                      | B                                                                                                                                                                                                                   | C                                                                                                                                                                                                                                                                                                                                                                                                                                      | D                                                                               | E                                                                                | F                                                                         | G                                                                                                       | H                            | I                      | J                                                                             | K                               | L                                                                                     | M                                                                                     | N                                    |
|-----|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------|----------------------------------------------------------------------------------|---------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------|------------------------------|------------------------|-------------------------------------------------------------------------------|---------------------------------|---------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------|--------------------------------------|
| 1   | Tubing Stress and Movement                                                                                                                                                                             |                                                                                                                                                                                                                     | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 2   | Blue cells on yellow are inputs. Enter the tubing and packer, the conditions the packer was set in, the three load cases and the design factors; overwrite the survey with yours.                      |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 3   | Tubing and Packer                                                                                                                                                                                      |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 4   | Tubing outside diameter                                                                                                                                                                                | 3.5                                                                                                                                                                                                                 | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 5   | Tubing inside diameter (3½-in. 9.3 lb/ft)                                                                                                                                                              | 2.992                                                                                                                                                                                                               | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 6   | Tubing weight                                                                                                                                                                                          | 9.3                                                                                                                                                                                                                 | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 7   | Tubing grade's minimum yield strength (L-80)                                                                                                                                                           | 80000                                                                                                                                                                                                               | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 8   | Young's modulus of steel                                                                                                                                                                               | 30000000                                                                                                                                                                                                            | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 9   | Poisson's ratio of steel                                                                                                                                                                               | 0.3                                                                                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 10  | Thermal expansion coefficient of steel                                                                                                                                                                 | 0.0000069                                                                                                                                                                                                           | 1/°F                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 11  | Packer depth (MD)                                                                                                                                                                                      | 9300                                                                                                                                                                                                                | ft                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 12  | Packer seal-bore diameter                                                                                                                                                                              | 4                                                                                                                                                                                                                   | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 13  | Casing inside diameter at the packer (7-in. 29 lb/ft liner)                                                                                                                                            | 6.184                                                                                                                                                                                                               | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 14  | Tubing at the packer: 0 free in the seal bore, 1 latched                                                                                                                                               | 0                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 15  | Seal travel the tubing can shorten by                                                                                                                                                                  | 96                                                                                                                                                                                                                  | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 16  | Seal travel the tubing can lengthen by (space-out)                                                                                                                                                     | 48                                                                                                                                                                                                                  | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 17  | Packer's rated tubing load, either way                                                                                                                                                                 | 80000                                                                                                                                                                                                               | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 18  | When the Packer Was Set                                                                                                                                                                                |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 19  | Packer fluid in the tubing and annulus                                                                                                                                                                 | 9                                                                                                                                                                                                                   | ppg                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 20  | Temperature at the surface                                                                                                                                                                             | 70                                                                                                                                                                                                                  | °F                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 21  | Static temperature at the packer                                                                                                                                                                       | 207                                                                                                                                                                                                                 | °F                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 22  | Load Case: Production                                                                                                                                                                                  |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 23  | Average density of the fluid in the tubing                                                                                                                                                             | 6.5                                                                                                                                                                                                                 | ppg                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 24  | Surface tubing pressure                                                                                                                                                                                | 500                                                                                                                                                                                                                 | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 25  | Surface annulus pressure                                                                                                                                                                               | 0                                                                                                                                                                                                                   | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 26  | Tubing temperature at the surface                                                                                                                                                                      | 160                                                                                                                                                                                                                 | °F                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 27  | Tubing temperature at the packer                                                                                                                                                                       | 205                                                                                                                                                                                                                 | °F                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 28  | Load Case: Injection                                                                                                                                                                                   |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 29  | Average density of the fluid in the tubing                                                                                                                                                             | 8.6                                                                                                                                                                                                                 | ppg                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 30  | Surface tubing pressure                                                                                                                                                                                | 3000                                                                                                                                                                                                                | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 31  | Surface annulus pressure                                                                                                                                                                               | 0                                                                                                                                                                                                                   | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 32  | Tubing temperature at the surface                                                                                                                                                                      | 60                                                                                                                                                                                                                  | °F                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 33  | Tubing temperature at the packer                                                                                                                                                                       | 120                                                                                                                                                                                                                 | °F                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 34  | Load Case: Shut-in                                                                                                                                                                                     |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 35  | Average density of the fluid in the tubing                                                                                                                                                             | 6.5                                                                                                                                                                                                                 | ppg                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 36  | Surface tubing pressure                                                                                                                                                                                | 1800                                                                                                                                                                                                                | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 37  | Surface annulus pressure                                                                                                                                                                               | 0                                                                                                                                                                                                                   | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 38  | Tubing temperature at the surface                                                                                                                                                                      | 120                                                                                                                                                                                                                 | °F                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 39  | Tubing temperature at the packer                                                                                                                                                                       | 205                                                                                                                                                                                                                 | °F                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 40  | Design Factors and the Injection Sweep                                                                                                                                                                 |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 41  | Minimum triaxial design factor                                                                                                                                                                         | 1.25                                                                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 42  | Minimum tension design factor                                                                                                                                                                          | 1.6                                                                                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 43  | Helical load: 0 at the packer's inclination, 1 vertical                                                                                                                                                | 0                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 44  | Lowest surface injection pressure in the sweep                                                                                                                                                         | 0                                                                                                                                                                                                                   | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 45  | Step between the sweep's pressures                                                                                                                                                                     | 250                                                                                                                                                                                                                 | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 48  | Packer Depth, the Tubing, and the Worst Case of Each Effect                                                                                                                                            |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 49  | Packer TVD                                                                                                                                                                                             | =PO.CO.Schematic.Depths(TS_Packer,TS_SvMD,TS_SvInc,TS_SvAzi,TS_SvTVD)                                                                                                                                               | ft                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 50  | Hole inclination at the packer                                                                                                                                                                         | =INDEX(TS_SvInc,MATCH(TS_Packer,TS_SvMD,1))                                                                                                                                                                         | °                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 51  | Tubing wall thickness                                                                                                                                                                                  | =(TS_OD-TS_ID)/2                                                                                                                                                                                                    | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 52  | Steel area                                                                                                                                                                                             | =PI()*((TS_OD/2)^2-(TS_ID/2)^2)                                                                                                                                                                                     | in²                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 53  | Packer seal-bore area                                                                                                                                                                                  | =PI()*(TS_Bore/2)^2                                                                                                                                                                                                 | in²                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 54  | Buoyed weight in the packer fluid                                                                                                                                                                      | =INDEX(PO.DE.TD.Buoyancy(TS_W,TS_OD,TS_ID,TS_Rho0,TS_Rho0,TS_Steel),1,2)                                                                                                                                            | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 55  | Buoyed weight, production                                                                                                                                                                              | =INDEX(PO.DE.TD.Buoyancy(TS_W,TS_OD,TS_ID,TS_RhoProd,TS_Rho0,TS_Steel),1,2)                                                                                                                                         | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 56  | Buoyed weight, injection                                                                                                                                                                               | =INDEX(PO.DE.TD.Buoyancy(TS_W,TS_OD,TS_ID,TS_RhoInj,TS_Rho0,TS_Steel),1,2)                                                                                                                                          | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 57  | Buoyed weight, shut-in                                                                                                                                                                                 | =INDEX(PO.DE.TD.Buoyancy(TS_W,TS_OD,TS_ID,TS_RhoShut,TS_Rho0,TS_Steel),1,2)                                                                                                                                         | lb/ft                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 58  | Tension at the top when the packer was set                                                                                                                                                             | =TS_Wb0*TS_TVDp                                                                                                                                                                                                     | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 59  | Pipe-body yield                                                                                                                                                                                        | =PO.DE.Casing.Axial.Yield(TS_OD,TS_t,TS_Yp)                                                                                                                                                                         | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 60  | Most the free tubing shortens                                                                                                                                                                          | =MAX(0,-MIN(N104:N106))                                                                                                                                                                                             | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 61  | Most the free tubing lengthens                                                                                                                                                                         | =MAX(0,MAX(N104:N106))                                                                                                                                                                                              | in                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 62  | Largest packer pull if latched (tension)                                                                                                                                                               | =MAX(0,MAX(H104:H106))                                                                                                                                                                                              | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 63  | Largest packer push if latched (compression)                                                                                                                                                           | =MAX(0,-MIN(H104:H106))                                                                                                                                                                                             | lbf                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 64  | Longest helically buckled length above the packer                                                                                                                                                      | =MAX(M104:M106)                                                                                                                                                                                                     | ft                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 65  | Lowest triaxial design factor at the top                                                                                                                                                               | =MIN(E110:E112)                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 66  | Lowest tension design factor at the top                                                                                                                                                                | =MIN(F110:F112)                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 67  | Highest injection pressure inside the seal travel (free)                                                                                                                                               | =LET(cnt,COUNTIF(H116:H136,">="&-TS_SealUp),IF(cnt=0,0,IF(cnt=ROWS(A116:A136),INDEX(A116:A136,cnt),INDEX(A116:A136,cnt)+(-TS_SealUp-INDEX(H116:H136,cnt))/(INDEX(H116:H136,cnt+1)-INDEX(H116:H136,cnt))*TS_StepP))) | psi                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 68  | Seal and packer check                                                                                                                                                                                  | =IF(TS_Mode=0,IF(AND(TS_Short<=TS_SealUp,TS_Long<=TS_SealDown),"PASS","FAIL"),IF(MAX(TS_PkTen,TS_PkComp)<=TS_PkRating,"PASS","FAIL"))                                                                               | =IF(TS_Mode=0,IF(AND(TS_Short<=TS_SealUp,TS_Long<=TS_SealDown),"the free tubing's movement stays inside the seal travel in every case","the tubing moves past its seal travel: longer seals, more space-out or a latched packer"),IF(MAX(TS_PkTen,TS_PkComp)<=TS_PkRating,"the latched packer's load stays under its rating in every case","the latched packer's load exceeds its rating: a free seal assembly or a stronger packer")) |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 69  | Buckling check                                                                                                                                                                                         | =IF(TS_Buckled=0,"PASS",IF(TS_Buckled<TS_Packer,"WARN","FAIL"))                                                                                                                                                     | =IF(TS_Buckled=0,"no load case buckles the tubing",IF(TS_Buckled<TS_Packer,"the tubing buckles helically over "&TEXT(TS_Buckled,"0")&" ft above the packer","the helix reaches the surface: set down less, latch the tubing or add tension"))                                                                                                                                                                                          |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 70  | Triaxial check                                                                                                                                                                                         | =IF(TS_DFvmMin>=TS_DFvm,"PASS","FAIL")                                                                                                                                                                              | =IF(TS_DFvmMin>=TS_DFvm,"the top joint's lowest triaxial design factor, "&TEXT(TS_DFvmMin,"0.00")&", meets the minimum","the top joint's lowest triaxial design factor, "&TEXT(TS_DFvmMin,"0.00")&", is under the minimum")                                                                                                                                                                                                            |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 71  | Tension check                                                                                                                                                                                          | =IF(TS_DFtMin>=TS_DFt,"PASS","FAIL")                                                                                                                                                                                | =IF(TS_DFtMin>=TS_DFt,"the top joint's lowest tension design factor, "&TEXT(TS_DFtMin,"0.00")&", meets the minimum","the top joint's lowest tension design factor, "&TEXT(TS_DFtMin,"0.00")&", is under the minimum")                                                                                                                                                                                                                  |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 72  | Design verdict                                                                                                                                                                                         | =IF(OR(TS_PackerCheck="FAIL",TS_BucklingCheck="FAIL",TS_TriaxialCheck="FAIL",TS_TensionCheck="FAIL"),"FAIL",IF(TS_BucklingCheck="WARN","WARN","PASS"))                                                              | =IF(OR(TS_PackerCheck="FAIL",TS_BucklingCheck="FAIL",TS_TriaxialCheck="FAIL",TS_TensionCheck="FAIL"),"a load case breaks a design limit",IF(TS_BucklingCheck="WARN","every design factor holds, with the tubing buckled in a load case","every load case holds every design limit"))                                                                                                                                                   |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 74  | How to use it: take the load cases' pressures and temperatures from the well's flowing and shut-in surveys or a temperature model, and the seal travel and packer rating from the packer's data sheet. |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 75  | Lubinski's effects are for one tubing size, elastic and without friction; a tapered string or a deviated well's drag needs a full tubing-movement program.                                             |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 77  | Constants                                                                                                                                                                                              |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 78  | Pressure gradient of 1 ppg of fluid                                                                                                                                                                    | 0.052                                                                                                                                                                                                               | psi/ft/ppg                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 79  | Density of steel                                                                                                                                                                                       | 65.5                                                                                                                                                                                                                | ppg                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 83  | Survey (the wellbore-schematic workbook's well A-12), TVD by Minimum Curvature                                                                                                                         |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 84  | MD (ft)                                                                                                                                                                                                | Inclination (°)                                                                                                                                                                                                     | Azimuth (°)                                                                                                                                                                                                                                                                                                                                                                                                                            | Dogleg severity (°/100 ft)                                                      | Ratio factor (—)                                                                 | TVD (ft)                                                                  |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 85  | 0                                                                                                                                                                                                      | 0                                                                                                                                                                                                                   | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =0                                                                              | =1                                                                               | =A85                                                                      |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 86  | 1000                                                                                                                                                                                                   | 0                                                                                                                                                                                                                   | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B85,C85,B86,C86,A86-A85)                              | =PO.DE.Dir.RatioFactor(D86*(A86-A85)/100)                                        | =F85+PO.DE.Dir.MinCurv.dTVD(B85,B86,A86-A85,E86)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 87  | 2500                                                                                                                                                                                                   | 0                                                                                                                                                                                                                   | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B86,C86,B87,C87,A87-A86)                              | =PO.DE.Dir.RatioFactor(D87*(A87-A86)/100)                                        | =F86+PO.DE.Dir.MinCurv.dTVD(B86,B87,A87-A86,E87)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 88  | 3000                                                                                                                                                                                                   | 7.5                                                                                                                                                                                                                 | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B87,C87,B88,C88,A88-A87)                              | =PO.DE.Dir.RatioFactor(D88*(A88-A87)/100)                                        | =F87+PO.DE.Dir.MinCurv.dTVD(B87,B88,A88-A87,E88)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 89  | 3500                                                                                                                                                                                                   | 15                                                                                                                                                                                                                  | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B88,C88,B89,C89,A89-A88)                              | =PO.DE.Dir.RatioFactor(D89*(A89-A88)/100)                                        | =F88+PO.DE.Dir.MinCurv.dTVD(B88,B89,A89-A88,E89)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 90  | 4000                                                                                                                                                                                                   | 22.5                                                                                                                                                                                                                | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B89,C89,B90,C90,A90-A89)                              | =PO.DE.Dir.RatioFactor(D90*(A90-A89)/100)                                        | =F89+PO.DE.Dir.MinCurv.dTVD(B89,B90,A90-A89,E90)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 91  | 4500                                                                                                                                                                                                   | 30                                                                                                                                                                                                                  | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B90,C90,B91,C91,A91-A90)                              | =PO.DE.Dir.RatioFactor(D91*(A91-A90)/100)                                        | =F90+PO.DE.Dir.MinCurv.dTVD(B90,B91,A91-A90,E91)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 92  | 6000                                                                                                                                                                                                   | 30                                                                                                                                                                                                                  | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B91,C91,B92,C92,A92-A91)                              | =PO.DE.Dir.RatioFactor(D92*(A92-A91)/100)                                        | =F91+PO.DE.Dir.MinCurv.dTVD(B91,B92,A92-A91,E92)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 93  | 8000                                                                                                                                                                                                   | 30                                                                                                                                                                                                                  | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B92,C92,B93,C93,A93-A92)                              | =PO.DE.Dir.RatioFactor(D93*(A93-A92)/100)                                        | =F92+PO.DE.Dir.MinCurv.dTVD(B92,B93,A93-A92,E93)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 94  | 10000                                                                                                                                                                                                  | 30                                                                                                                                                                                                                  | 135                                                                                                                                                                                                                                                                                                                                                                                                                                    | =PO.DE.Dir.DoglegSeverity(B93,C93,B94,C94,A94-A93)                              | =PO.DE.Dir.RatioFactor(D94*(A94-A93)/100)                                        | =F93+PO.DE.Dir.MinCurv.dTVD(B93,B94,A94-A93,E94)                          |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 96  | Pressure and Temperature Changes from When the Packer Was Set                                                                                                                                          |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 97  | Load case                                                                                                                                                                                              | Tubing, at the packer (psi)                                                                                                                                                                                         | Annulus, at the packer (psi)                                                                                                                                                                                                                                                                                                                                                                                                           | Tubing, average (psi)                                                           | Annulus, average (psi)                                                           | Temperature, average (°F)                                                 |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 98  | Production                                                                                                                                                                                             | =TS_PtProd+TS_Psi*(TS_RhoProd-TS_Rho0)*TS_TVDp                                                                                                                                                                      | =TS_PaProd                                                                                                                                                                                                                                                                                                                                                                                                                             | =(TS_PtProd+B98)/2                                                              | =TS_PaProd                                                                       | =(TS_TsProd+TS_TpProd)/2-(TS_Ts0+TS_Tp0)/2                                |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 99  | Injection                                                                                                                                                                                              | =TS_PtInj+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                        | =TS_PaInj                                                                                                                                                                                                                                                                                                                                                                                                                              | =(TS_PtInj+B99)/2                                                               | =TS_PaInj                                                                        | =(TS_TsInj+TS_TpInj)/2-(TS_Ts0+TS_Tp0)/2                                  |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 100 | Shut-in                                                                                                                                                                                                | =TS_PtShut+TS_Psi*(TS_RhoShut-TS_Rho0)*TS_TVDp                                                                                                                                                                      | =TS_PaShut                                                                                                                                                                                                                                                                                                                                                                                                                             | =(TS_PtShut+B100)/2                                                             | =TS_PaShut                                                                       | =(TS_TsShut+TS_TpShut)/2-(TS_Ts0+TS_Tp0)/2                                |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 102 | Lubinski's Four Effects (a positive force shortens free tubing; a positive length change lengthens it)                                                                                                 |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 103 | Load case                                                                                                                                                                                              | Piston force (lbf)                                                                                                                                                                                                  | Piston (in)                                                                                                                                                                                                                                                                                                                                                                                                                            | Ballooning force (lbf)                                                          | Ballooning (in)                                                                  | Temperature force (lbf)                                                   | Temperature (in)                                                                                        | Packer load if latched (lbf) | Buoyed weight (lb/ft)  | Critical helical load (lbf)                                                   | Fictitious force (lbf)          | Buckling (in)                                                                         | Buckled length (ft)                                                                   | Movement if free (in)                |
| 104 | Production                                                                                                                                                                                             | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B98,C98,TS_E),1,1)                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B98,C98,TS_E),1,2)                                                                                                                                                                                                                                                                                                                                                            | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,D98,E98,TS_E,TS_Nu),1,1)   | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,D98,E98,TS_E,TS_Nu),1,2)    | =INDEX(PO.CO.Tubing.Thermal(TS_Packer,TS_OD,TS_ID,F98,TS_E,TS_Beta),1,1)  | =INDEX(PO.CO.Tubing.Thermal(TS_Packer,TS_OD,TS_ID,F98,TS_E,TS_Beta),1,2)                                | =B104+D104+F104              | =TS_WbProd             | =PO.DE.TD.Buckling.Helical(TS_OD,TS_ID,TS_CsgID,I104,TS_IncP,TS_E,TS_HelMode) | =TS_Ap*(B98-C98)-TS_Mode*H104   | =INDEX(PO.CO.Tubing.Buckling(K104,J104,TS_Packer,TS_OD,TS_ID,TS_CsgID,I104,TS_E),1,1) | =INDEX(PO.CO.Tubing.Buckling(K104,J104,TS_Packer,TS_OD,TS_ID,TS_CsgID,I104,TS_E),1,2) | =IF(TS_Mode=0,C104+E104+G104+L104,0) |
| 105 | Injection                                                                                                                                                                                              | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B99,C99,TS_E),1,1)                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B99,C99,TS_E),1,2)                                                                                                                                                                                                                                                                                                                                                            | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,D99,E99,TS_E,TS_Nu),1,1)   | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,D99,E99,TS_E,TS_Nu),1,2)    | =INDEX(PO.CO.Tubing.Thermal(TS_Packer,TS_OD,TS_ID,F99,TS_E,TS_Beta),1,1)  | =INDEX(PO.CO.Tubing.Thermal(TS_Packer,TS_OD,TS_ID,F99,TS_E,TS_Beta),1,2)                                | =B105+D105+F105              | =TS_WbInj              | =PO.DE.TD.Buckling.Helical(TS_OD,TS_ID,TS_CsgID,I105,TS_IncP,TS_E,TS_HelMode) | =TS_Ap*(B99-C99)-TS_Mode*H105   | =INDEX(PO.CO.Tubing.Buckling(K105,J105,TS_Packer,TS_OD,TS_ID,TS_CsgID,I105,TS_E),1,1) | =INDEX(PO.CO.Tubing.Buckling(K105,J105,TS_Packer,TS_OD,TS_ID,TS_CsgID,I105,TS_E),1,2) | =IF(TS_Mode=0,C105+E105+G105+L105,0) |
| 106 | Shut-in                                                                                                                                                                                                | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B100,C100,TS_E),1,1)                                                                                                                                       | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B100,C100,TS_E),1,2)                                                                                                                                                                                                                                                                                                                                                          | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,D100,E100,TS_E,TS_Nu),1,1) | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,D100,E100,TS_E,TS_Nu),1,2)  | =INDEX(PO.CO.Tubing.Thermal(TS_Packer,TS_OD,TS_ID,F100,TS_E,TS_Beta),1,1) | =INDEX(PO.CO.Tubing.Thermal(TS_Packer,TS_OD,TS_ID,F100,TS_E,TS_Beta),1,2)                               | =B106+D106+F106              | =TS_WbShut             | =PO.DE.TD.Buckling.Helical(TS_OD,TS_ID,TS_CsgID,I106,TS_IncP,TS_E,TS_HelMode) | =TS_Ap*(B100-C100)-TS_Mode*H106 | =INDEX(PO.CO.Tubing.Buckling(K106,J106,TS_Packer,TS_OD,TS_ID,TS_CsgID,I106,TS_E),1,1) | =INDEX(PO.CO.Tubing.Buckling(K106,J106,TS_Packer,TS_OD,TS_ID,TS_CsgID,I106,TS_E),1,2) | =IF(TS_Mode=0,C106+E106+G106+L106,0) |
| 108 | The Top Joint in Each Load Case (triaxial at the inner wall, PO.DE.Casing.VonMises)                                                                                                                    |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 109 | Load case                                                                                                                                                                                              | Axial force (lbf)                                                                                                                                                                                                   | Axial stress (psi)                                                                                                                                                                                                                                                                                                                                                                                                                     | Von Mises stress (psi)                                                          | Triaxial design factor (—)                                                       | Axial design factor (—)                                                   |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 110 | Production                                                                                                                                                                                             | =TS_F0-B104+TS_Mode*H104                                                                                                                                                                                            | =B110/TS_As                                                                                                                                                                                                                                                                                                                                                                                                                            | =PO.DE.Casing.VonMises(TS_OD,TS_t,TS_PtProd,TS_PaProd,C110,TS_ID/2)             | =TS_Yp/D110                                                                      | =IF(B110>0,TS_Fy/B110,TS_Fy/ABS(B110))                                    |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 111 | Injection                                                                                                                                                                                              | =TS_F0-B105+TS_Mode*H105                                                                                                                                                                                            | =B111/TS_As                                                                                                                                                                                                                                                                                                                                                                                                                            | =PO.DE.Casing.VonMises(TS_OD,TS_t,TS_PtInj,TS_PaInj,C111,TS_ID/2)               | =TS_Yp/D111                                                                      | =IF(B111>0,TS_Fy/B111,TS_Fy/ABS(B111))                                    |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 112 | Shut-in                                                                                                                                                                                                | =TS_F0-B106+TS_Mode*H106                                                                                                                                                                                            | =B112/TS_As                                                                                                                                                                                                                                                                                                                                                                                                                            | =PO.DE.Casing.VonMises(TS_OD,TS_t,TS_PtShut,TS_PaShut,C112,TS_ID/2)             | =TS_Yp/D112                                                                      | =IF(B112>0,TS_Fy/B112,TS_Fy/ABS(B112))                                    |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 114 | Injection Pressure Sweep (free tubing)                                                                                                                                                                 |                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                 |                                                                                  |                                                                           |                                                                                                         |                              |                        |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 115 | Surface injection pressure (psi)                                                                                                                                                                       | Tubing Δp at the packer (psi)                                                                                                                                                                                       | Tubing Δp, average (psi)                                                                                                                                                                                                                                                                                                                                                                                                               | Piston (in)                                                                     | Ballooning (in)                                                                  | Temperature (in)                                                          | Buckling (in)                                                                                           | Total (in)                   | Seal travel limit (in) |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 116 | =TS_StartP+0*TS_StepP                                                                                                                                                                                  | =A116+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A116+B116)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B116,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C116,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B116-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D116+E116+F116+G116         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 117 | =TS_StartP+1*TS_StepP                                                                                                                                                                                  | =A117+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A117+B117)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B117,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C117,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B117-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D117+E117+F117+G117         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 118 | =TS_StartP+2*TS_StepP                                                                                                                                                                                  | =A118+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A118+B118)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B118,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C118,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B118-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D118+E118+F118+G118         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 119 | =TS_StartP+3*TS_StepP                                                                                                                                                                                  | =A119+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A119+B119)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B119,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C119,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B119-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D119+E119+F119+G119         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 120 | =TS_StartP+4*TS_StepP                                                                                                                                                                                  | =A120+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A120+B120)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B120,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C120,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B120-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D120+E120+F120+G120         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 121 | =TS_StartP+5*TS_StepP                                                                                                                                                                                  | =A121+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A121+B121)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B121,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C121,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B121-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D121+E121+F121+G121         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 122 | =TS_StartP+6*TS_StepP                                                                                                                                                                                  | =A122+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A122+B122)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B122,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C122,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B122-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D122+E122+F122+G122         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 123 | =TS_StartP+7*TS_StepP                                                                                                                                                                                  | =A123+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A123+B123)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B123,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C123,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B123-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D123+E123+F123+G123         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 124 | =TS_StartP+8*TS_StepP                                                                                                                                                                                  | =A124+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A124+B124)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B124,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C124,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B124-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D124+E124+F124+G124         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 125 | =TS_StartP+9*TS_StepP                                                                                                                                                                                  | =A125+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A125+B125)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B125,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C125,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B125-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D125+E125+F125+G125         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 126 | =TS_StartP+10*TS_StepP                                                                                                                                                                                 | =A126+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A126+B126)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B126,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C126,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B126-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D126+E126+F126+G126         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 127 | =TS_StartP+11*TS_StepP                                                                                                                                                                                 | =A127+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A127+B127)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B127,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C127,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B127-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D127+E127+F127+G127         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 128 | =TS_StartP+12*TS_StepP                                                                                                                                                                                 | =A128+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A128+B128)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B128,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C128,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B128-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D128+E128+F128+G128         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 129 | =TS_StartP+13*TS_StepP                                                                                                                                                                                 | =A129+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A129+B129)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B129,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C129,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B129-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D129+E129+F129+G129         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 130 | =TS_StartP+14*TS_StepP                                                                                                                                                                                 | =A130+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A130+B130)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B130,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C130,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B130-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D130+E130+F130+G130         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 131 | =TS_StartP+15*TS_StepP                                                                                                                                                                                 | =A131+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A131+B131)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B131,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C131,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B131-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D131+E131+F131+G131         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 132 | =TS_StartP+16*TS_StepP                                                                                                                                                                                 | =A132+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A132+B132)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B132,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C132,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B132-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D132+E132+F132+G132         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 133 | =TS_StartP+17*TS_StepP                                                                                                                                                                                 | =A133+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A133+B133)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B133,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C133,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B133-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D133+E133+F133+G133         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 134 | =TS_StartP+18*TS_StepP                                                                                                                                                                                 | =A134+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A134+B134)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B134,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C134,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B134-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D134+E134+F134+G134         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 135 | =TS_StartP+19*TS_StepP                                                                                                                                                                                 | =A135+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A135+B135)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B135,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C135,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B135-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D135+E135+F135+G135         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |
| 136 | =TS_StartP+20*TS_StepP                                                                                                                                                                                 | =A136+TS_Psi*(TS_RhoInj-TS_Rho0)*TS_TVDp                                                                                                                                                                            | =(A136+B136)/2                                                                                                                                                                                                                                                                                                                                                                                                                         | =INDEX(PO.CO.Tubing.Piston(TS_Packer,TS_OD,TS_ID,TS_Bore,B136,$C$99,TS_E),1,2)  | =INDEX(PO.CO.Tubing.Ballooning(TS_Packer,TS_OD,TS_ID,C136,$E$99,TS_E,TS_Nu),1,2) | =$G$105                                                                   | =INDEX(PO.CO.Tubing.Buckling(TS_Ap*(B136-$C$99),$J$105,TS_Packer,TS_OD,TS_ID,TS_CsgID,$I$105,TS_E),1,1) | =D136+E136+F136+G136         | =-TS_SealUp            |                                                                               |                                 |                                                                                       |                                                                                       |                                      |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.DE.Dir.DoglegSeverity | =LAMBDA(Inc1_deg, Azi1_deg, Inc2_deg, Azi2_deg, dMD_ft, DEGREES(2 * ASIN(SQRT(MIN(1, SIN(RADIANS(Inc2_deg - Inc1_deg) / 2)^2 + SIN(RADIANS(Inc1_deg)) * SIN(RADIANS(Inc2_deg)) * SIN(RADIANS(Azi2_deg - Azi1_deg) / 2)^2)))) * 100 / dMD_ft) | Dogleg severity in degrees per 100 ft between two directional surveys, from the inclinations, azimuths and course length. |
| PO.DE.Dir.RatioFactor | =LAMBDA(Dogleg_deg, IF(Dogleg_deg < 0.000001, 1, 2 / RADIANS(Dogleg_deg) * TAN(RADIANS(Dogleg_deg) / 2))) | Minimum curvature ratio factor from the dogleg angle over a course, degrees (1 for a straight course). |
| PO.DE.Dir.MinCurv.dTVD | =LAMBDA(Inc1_deg, Inc2_deg, dMD_ft, RF, dMD_ft / 2 * (COS(RADIANS(Inc1_deg)) + COS(RADIANS(Inc2_deg))) * RF) | Minimum curvature TVD increment, ft, over a course. |
| PO.CO.Schematic.Depths | =LAMBDA(MD_ft, Survey_MD, Survey_Inc, Survey_Azi, Survey_TVD, LET(n, COUNT(Survey_MD), k, IF(MD_ft < INDEX(Survey_MD, 1), 0, MATCH(MD_ft, Survey_MD, 1)), lo, MAX(1, MIN(k, n - 1)), hi, lo + 1, md_lo, INDEX(Survey_MD, lo), md_hi, INDEX(Survey_MD, hi), inc_lo, RADIANS(INDEX(Survey_Inc, lo)), inc_hi, RADIANS(INDEX(Survey_Inc, hi)), azi_lo, RADIANS(INDEX(Survey_Azi, lo)), azi_hi, RADIANS(INDEX(Survey_Azi, hi)), tvd_lo, INDEX(Survey_TVD, lo), dogleg, 2 * ASIN(SQRT(MIN(1, SIN((inc_hi - inc_lo) / 2)^2 + SIN(inc_lo) * SIN(inc_hi) * SIN((azi_hi - azi_lo) / 2)^2))), frac, (MD_ft - md_lo) / (md_hi - md_lo), cos_at, IF(dogleg < 0.000000001, COS(inc_lo), (SIN((1 - frac) * dogleg) * COS(inc_lo) + SIN(frac * dogleg) * COS(inc_hi)) / SIN(dogleg)), part, frac * dogleg, ratio, IF(part < 0.000000001, 1, 2 / part * TAN(part / 2)), IF(k = 0, tvd_lo - (md_lo - MD_ft), IF(k >= n, INDEX(Survey_TVD, hi) + (MD_ft - md_hi) * COS(inc_hi), tvd_lo + (MD_ft - md_lo) / 2 * (COS(inc_lo) + cos_at) * ratio)))) | TVD, ft, of a measured depth on a survey: minimum-curvature interpolation between the two stations around it, vertical above the first and straight on below the last. |
| 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}. |
| PO.DE.TD.Buckling.Helical | =LAMBDA(OD_in, ID_in, Dh_in, Wb_lbft, Inc_deg, E_psi, Mode, LET(mi, PI()/64*(OD_in^4 - ID_in^4), wpi, Wb_lbft/12, IF(Mode=1, 5.55*(E_psi*mi*wpi^2)^(1/3), 2*SQRT(2)*SQRT(E_psi*mi*wpi*SIN(RADIANS(Inc_deg))/((Dh_in - OD_in)/2))))) | Helical buckling load, lbf: the square root of 2 times Dawson-Paslay in an inclined hole (Mode 0) or 5.55 (EI w^2)^(1/3) in a vertical one (Mode 1). |
| 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.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.CO.Tubing.Piston | =LAMBDA(L_ft, OD_in, ID_in, Bore_in, dPi_psi, dPo_psi, E_psi, LET(areaI, PI()/4*ID_in^2, areaO, PI()/4*OD_in^2, areaP, PI()/4*Bore_in^2, frc, (areaP - areaI)*dPi_psi - (areaP - areaO)*dPo_psi, HSTACK(frc, -12*L_ft*frc/(E_psi*(areaO - areaI))))) | Lubinski piston effect at a packer: the force on the tubing, lbf, and the free-tubing length change, in. (negative shortens): {lbf, in}. |
| PO.CO.Tubing.Ballooning | =LAMBDA(L_ft, OD_in, ID_in, dPia_psi, dPoa_psi, E_psi, Nu, LET(areaI, PI()/4*ID_in^2, areaO, PI()/4*OD_in^2, frc, 2*Nu*(dPia_psi*areaI - dPoa_psi*areaO), HSTACK(frc, -12*L_ft*frc/(E_psi*(areaO - areaI))))) | Lubinski ballooning and reverse ballooning from the average pressure changes inside and outside the tubing: {force lbf, length change in.}. |
| PO.CO.Tubing.Thermal | =LAMBDA(L_ft, OD_in, ID_in, dT_F, E_psi, Beta_perF, LET(steel, PI()/4*(OD_in^2 - ID_in^2), HSTACK(0 - E_psi*Beta_perF*steel*dT_F, 12*L_ft*Beta_perF*dT_F))) | Lubinski temperature effect from the average tubing temperature change: {force lbf, length change in.}; cooling gives a positive force and a shortening. |
| PO.CO.Tubing.Buckling | =LAMBDA(Ff_lbf, Fcr_lbf, TbgL_ft, TbgOD_in, TbgID_in, CsgID_in, W_lbft, TbgE_psi, LET(mi, PI()/64*(TbgOD_in^4 - TbgID_in^4), clr, (CsgID_in - TbgOD_in)/2, fLow, MAX(Fcr_lbf, Ff_lbf - W_lbft*TbgL_ft), bkl, Ff_lbf > Fcr_lbf, HSTACK(IF(bkl, (fLow^2 - Ff_lbf^2)*clr^2/(8*TbgE_psi*mi*W_lbft/12), 0), IF(bkl, (Ff_lbf - fLow)/W_lbft, 0)))) | Lubinski helical-buckling length change of tubing, in., above the packer, with the buckled length, ft, from the fictitious force and a critical load. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| TS_OD | $B$4 | Tubing outside diameter, in |
| TS_ID | $B$5 | Tubing inside diameter (3½-in. 9.3 lb/ft), in |
| TS_W | $B$6 | Tubing weight, lb/ft |
| TS_Yp | $B$7 | Tubing grade's minimum yield strength (L-80), psi |
| TS_E | $B$8 | Young's modulus of steel, psi |
| TS_Nu | $B$9 | Poisson's ratio of steel |
| TS_Beta | $B$10 | Thermal expansion coefficient of steel, 1/°F |
| TS_Packer | $B$11 | Packer depth (MD), ft |
| TS_Bore | $B$12 | Packer seal-bore diameter, in |
| TS_CsgID | $B$13 | Casing inside diameter at the packer (7-in. 29 lb/ft liner), in |
| TS_Mode | $B$14 | Tubing at the packer: 0 free in the seal bore, 1 latched |
| TS_SealUp | $B$15 | Seal travel the tubing can shorten by, in |
| TS_SealDown | $B$16 | Seal travel the tubing can lengthen by (space-out), in |
| TS_PkRating | $B$17 | Packer's rated tubing load, either way, lbf |
| TS_Rho0 | $B$19 | Packer fluid in the tubing and annulus, ppg |
| TS_Ts0 | $B$20 | Temperature at the surface, °F |
| TS_Tp0 | $B$21 | Static temperature at the packer, °F |
| TS_RhoProd | $B$23 | Average density of the fluid in the tubing, ppg |
| TS_PtProd | $B$24 | Surface tubing pressure, psi |
| TS_PaProd | $B$25 | Surface annulus pressure, psi |
| TS_TsProd | $B$26 | Tubing temperature at the surface, °F |
| TS_TpProd | $B$27 | Tubing temperature at the packer, °F |
| TS_RhoInj | $B$29 | Average density of the fluid in the tubing, ppg |
| TS_PtInj | $B$30 | Surface tubing pressure, psi |
| TS_PaInj | $B$31 | Surface annulus pressure, psi |
| TS_TsInj | $B$32 | Tubing temperature at the surface, °F |
| TS_TpInj | $B$33 | Tubing temperature at the packer, °F |
| TS_RhoShut | $B$35 | Average density of the fluid in the tubing, ppg |
| TS_PtShut | $B$36 | Surface tubing pressure, psi |
| TS_PaShut | $B$37 | Surface annulus pressure, psi |
| TS_TsShut | $B$38 | Tubing temperature at the surface, °F |
| TS_TpShut | $B$39 | Tubing temperature at the packer, °F |
| TS_DFvm | $B$41 | Minimum triaxial design factor |
| TS_DFt | $B$42 | Minimum tension design factor |
| TS_HelMode | $B$43 | Helical load: 0 at the packer's inclination, 1 vertical |
| TS_StartP | $B$44 | Lowest surface injection pressure in the sweep, psi |
| TS_StepP | $B$45 | Step between the sweep's pressures, psi |
| TS_Inputs | $B$4:$B$45 | The tubing and its steel, the packer, its seal bore and travel and its rating, the conditions it was set in, the three load cases' fluids, pressures and temperatures, the design factors and the sweep |
| TS_TVDp | $B$49 | Packer TVD, ft |
| TS_IncP | $B$50 | Hole inclination at the packer, ° |
| TS_t | $B$51 | Tubing wall thickness, in |
| TS_As | $B$52 | Steel area, in² |
| TS_Ap | $B$53 | Packer seal-bore area, in² |
| TS_Wb0 | $B$54 | Buoyed weight in the packer fluid, lb/ft |
| TS_WbProd | $B$55 | Buoyed weight, production, lb/ft |
| TS_WbInj | $B$56 | Buoyed weight, injection, lb/ft |
| TS_WbShut | $B$57 | Buoyed weight, shut-in, lb/ft |
| TS_F0 | $B$58 | Tension at the top when the packer was set, lbf |
| TS_Fy | $B$59 | Pipe-body yield, lbf |
| TS_Short | $B$60 | Most the free tubing shortens, in |
| TS_Long | $B$61 | Most the free tubing lengthens, in |
| TS_PkTen | $B$62 | Largest packer pull if latched (tension), lbf |
| TS_PkComp | $B$63 | Largest packer push if latched (compression), lbf |
| TS_Buckled | $B$64 | Longest helically buckled length above the packer, ft |
| TS_DFvmMin | $B$65 | Lowest triaxial design factor at the top |
| TS_DFtMin | $B$66 | Lowest tension design factor at the top |
| TS_MaxInj | $B$67 | Highest injection pressure inside the seal travel (free), psi |
| TS_PackerCheck | $B$68 | Seal and packer check verdict |
| TS_PackerCheckNote | $C$68 | Seal and packer check comment |
| TS_BucklingCheck | $B$69 | Buckling check verdict |
| TS_BucklingCheckNote | $C$69 | Buckling check comment |
| TS_TriaxialCheck | $B$70 | Triaxial check verdict |
| TS_TriaxialCheckNote | $C$70 | Triaxial check comment |
| TS_TensionCheck | $B$71 | Tension check verdict |
| TS_TensionCheckNote | $C$71 | Tension check comment |
| TS_DesignCheck | $B$72 | Design verdict verdict |
| TS_DesignCheckNote | $C$72 | Design verdict comment |
| TS_Results | $B$49:$B$72 | The packer's TVD and inclination, the tubing's wall, areas, buoyed weight, landing tension and yield, the worst movement, packer load, buckled length and design factors, the highest injection pressure, and the checks |
| TS_Psi | $B$78 | Pressure gradient of 1 ppg of fluid, psi/ft/ppg |
| TS_Steel | $B$79 | Density of steel, ppg |
| TS_Survey | $A$85:$C$94 | Survey stations: measured depth, inclination, azimuth |
| TS_SurveyTvd | $D$85:$F$94 | Each station's dogleg severity over the course above it, its ratio factor and its TVD by minimum curvature |
| TS_SvMD | $A$85:$A$94 | Survey station measured depths, ft |
| TS_SvInc | $B$85:$B$94 | Survey station inclinations, deg |
| TS_SvAzi | $C$85:$C$94 | Survey station azimuths, deg |
| TS_SvTVD | $F$85:$F$94 | Survey station TVDs by minimum curvature, ft |
| TS_Changes | $A$98:$F$100 | Each load case's pressure changes at the packer and on average in the tubing and the annulus, and its average temperature change |
| TS_Effects | $A$104:$N$106 | Each load case's piston, ballooning and temperature forces and length changes, the latched packer load, the buoyed weight, the critical helical and fictitious forces, the buckling and the free tubing's movement |
| TS_TopJoint | $A$110:$F$112 | Each load case's axial force and stress in the top joint, its von Mises stress at the inner wall and its triaxial and axial design factors |
| TS_Curve | $A$116:$I$136 | Each surface injection pressure: the tubing pressure changes, the free tubing's four length changes, their total and the seal travel limit |

---

## Related Blueprints
- [Plug and Abandonment Design](/blueprint/po.de.pa.design.md)
- [Casing Design](/blueprint/po.de.casing.design.md)
- [Soft-String Torque and Drag](/blueprint/po.de.torque.drag.md)
- [Directional Survey Calculator](/blueprint/po.de.directional.survey.md)
- [Primary Cement Job Design](/blueprint/po.de.cement.volumes.md)
- [Hole Cleaning and Solids Control](/blueprint/po.de.holecleaning.solids.md)

