---
cid: po.bp.de.surge.swab
hub: de
tags: [drilling, hydraulics, surge, swab, tripping, trip-speed, Burkhardt, clinging-constant, power-law, ECD, pore-pressure, fracture-gradient]
facets: { discipline: drilling, property: hydraulics, method-type: analytical }
title: Surge and Swab Trip Speed
summary: "Calculates surge and swab pressures section by section and finds the fastest trip speed that neither breaks the shoe nor swabs in a kick."
slug: po.de.surge.swab
type: worksheet
---

# Surge and Swab Trip Speed

## Description

How fast can the string go in and out of the hole without breaking the shoe down or swabbing in a kick? Running pipe in pushes mud up the annulus and raises the bottomhole pressure (surge); pulling it out lowers it (swab). You enter the casing and hole, the string, the mud's power-law rheology, the stand times and the pore and fracture limits at the shoe and the bit. You read off the surge and swab at the shoe and the bit as mud weights, and the fastest safe trip speed in and out with the least time per stand.

**Parameters:**
- **Casing and hole**: the casing ID above and below the crossover `SRG_IdTop`, `SRG_IdBot` and the open hole `SRG_Hole` (in); the crossover `SRG_Xover`, the shoe `SRG_Shoe` and the bit depth `SRG_Bit` (ft)
- **String**: the drill pipe OD and ID `SRG_DpOD`, `SRG_DpID` (in), the bottomhole assembly's length `SRG_BhaL` (ft) and the collars' OD and ID `SRG_BhaOD`, `SRG_BhaID` (in)
- **Mud and pipe movement**: the mud weight `SRG_MW` (ppg), its power-law `SRG_n` and `SRG_K` (eq cp), the clinging constant `SRG_Kc`, the pipe end `SRG_Mode` (0 closed, 1 open), the stand length `SRG_Stand` (ft), the planned times to run a stand in and pull one out `SRG_TimeIn`, `SRG_TimeOut` (s), and the peak-to-average speed `SRG_Peak`
- **Limits and sweep**: the pore pressure and fracture gradient at the shoe and at the bit `SRG_PpShoe`, `SRG_FgShoe`, `SRG_PpBit`, `SRG_FgBit` (ppg), and the sweep's slowest speed `SRG_Start` and step `SRG_StepV` (ft/min)

**How to use it:** The rheology is made up for the example. Take n and K from the hydraulics sheet's Fann fit of the mud in the hole (the annulus fit, at the shear rates the trip makes), the pore pressure and fracture gradient from the pore-pressure sheet or the shoe test, the clinging constant from Burkhardt's chart for the pipe-to-hole ratio, and the peak factor from the driller's stand times or the rig's block-speed log. The sheet works each section in turn, the drill pipe and then the collars against the casing above its crossover, the casing below it and the open hole: the effective annular velocity of the mud the moving pipe displaces and drags along, the equivalent flow rate, and the friction loss over the length of pipe in the section. The losses above the shoe give the surge or swab at the shoe, and all of them the surge or swab at the bit, each as a mud weight. A sweep of average trip speeds repeats the losses at each speed, and a table reads the fastest speed that keeps the surge under the fracture gradient and the swab over the pore pressure at the shoe and at the bit, with the least time per stand that speed means; a chart draws the surge and swab mud weights against trip speed beside the limits. Running in is unsafe when the surge at the planned stand time reaches the fracture gradient at the shoe or at the bit, and pulling out when the swab takes the bottom under the pore pressure at either; a planned average speed over its safe speed is flagged with the seconds a stand should take instead.

**Method:** Burkhardt's effective annular velocity for a pipe moving at vp is v = vp (A/(Dh² − Dp²) + Kc), where A is Dp² for a closed pipe and Dp² − Di² for an open one: the mud the pipe displaces plus the mud that clings to it. The pipe speed is the peak, the stand length × 60 over its time times the peak factor. The equivalent flow rate is Q = v (Dh² − Dp²)/24.5 gpm, and the loss over the length of pipe in the section is the power-law slot loss at that rate, laminar below the API RP 13D Reynolds number 3,470 − 1,370 n and Blasius turbulent above it. The length of pipe in each section is where the pipe (the drill pipe from surface to the top of the collars, the collars from there to the bit) overlaps the hole section. The surge at the shoe is the sum over the four cased sections, and at the bit the sum over all six; as a mud weight it is MW + ΔP/(0.052 × depth), and the swab is the same loss taken off. Burkhardt's velocity is in proportion to the pipe speed, so the sweep scales each section's rate by the speed and takes the loss again. Surge rises and swab falls with speed, so the number of sweep speeds that hold a limit is the row of the last one that does, and the safe speed is read straight between that row and the next.

**Example:** The drilling family's reference well, the one the pore-pressure, casing-design and cement sheets use, vertical: the 9⅝-in. intermediate string, ID 8.681 in. above the crossover at 8,000 ft and 8.535 in. below it, set at 10,000 ft, and the 8½-in. production hole to 13,000 ft, with the bit on bottom. The string is 5-in. drill pipe (ID 4.276 in.) over 600 ft of 6½-in. collars (ID 2-13/16 in.) with a float in it, so the pipe is closed. The mud is the production hole's 13.9 ppg, with a power-law n of 0.70 and K of 280 eq cp and Burkhardt's clinging constant 0.45. The stands are 93 ft, run in at 45 s and pulled at 75 s, and the peak speed is 1.5 times the average. The pore-pressure sheet gives 10.2 ppg of pore pressure and 15.4 ppg of fracture gradient at the shoe, and 13.6 and 16.7 ppg at TD. The sweep runs from 20 to 400 ft/min in steps of 20.

Run in at 45 s a stand, the string averages 124 ft/min with a 186 ft/min peak. Past the drill pipe in the upper casing the mud moves at 176.0 ft/min, 361.8 gpm, and loses 128.5 psi over 8,000 ft; in the lower casing 35.1 psi and in the open hole 43.0 psi; past the collars in the open hole it moves at 345.7 ft/min, turbulent, and loses 43.6 psi. That is a surge of 163.6 psi at the shoe and 250.2 psi at the bit, 14.21 and 14.27 ppg, well under the 15.4 and 16.7 ppg fracture gradients. Pulled at 75 s a stand, 74.4 ft/min, the swab is 114.4 psi at the shoe and 175.0 psi at the bit, which leaves 13.68 and 13.64 ppg, over the 10.2 and 13.6 ppg pore pressures. The sweep holds the shoe's fracture gradient up to 280.5 ft/min and the bit's to 354.7 ft/min, so the string can run in as fast as 19.9 s a stand. Swabbing at the bit governs pulling out: the bottom stays over 13.6 ppg up to 92.0 ft/min, 60.7 s a stand. Both planned speeds are inside. The 0.3 ppg trip margin is what sets the pulling speed: a 60 s stand would swab the bottom to 13.60 ppg. Run open-ended, the pipe sends only its steel up the annulus and the surge at the bit falls to 185.8 psi. Set to one 10,000 ft section of 8.5-in. hole with 4½-in. pipe (ID 3.826 in.) at 270 ft/min in a 10 ppg mud of n 0.6 and K 400 eq cp, the sheet gives 149.5 psi (149.47), the value the Burkhardt surge function documents for its first case, composed with the power-law annulus loss.

## Validity

Steady state: Burkhardt's model leaves out the pipe's acceleration and deceleration between slips, the mud's gel strength breaking at the start of each stand, and the compressibility of the mud and the hole, which together make the pressure peak of a real stand; the peak factor stands in for them. A dynamic surge model is not covered. The clinging constant is one number for every section, though Burkhardt's chart has it fall from about 0.45 toward 0.35 as the pipe fills less of the hole. A closed pipe sends all its displacement up the annulus; an open one sends only the steel's, and the true split between the bore and the annulus, which needs both friction losses, lies between the two modes, so the open mode is the lower bound. The annulus loss jumps at the laminar-turbulent limit, where the two friction factors don't meet, so the sweep's curves step there and the safe speed read across a step is less sure. The mud is a power-law fluid at the bit's temperature; for a yield-stress mud use the Herschel-Bulkley model or the drilling hydraulics sheet. The hole is vertical and gauge, the casing and hole sections are concentric, and field units hold throughout.

## References

- Burkhardt, J.A. (1961). Wellbore Pressure Surges Produced by Pipe Movement. *Journal of Petroleum Technology* 13(6), 595–605. SPE-1546-G.
- Bourgoyne, A.T., Millheim, K.K., Chenevert, M.E. and Young, F.S. (1986). *Applied Drilling Engineering*. SPE Textbook Series Vol. 2, ch. 4 (surge pressure due to pipe movement, the clinging constant).
- API RP 13D (2017). *Rheology and Hydraulics of Oil-Well Drilling Fluids*, 7th ed. American Petroleum Institute (the power-law annulus loss and its flow-regime limit).
- Mitchell, R.F. and Miska, S.Z. (eds.) (2011). *Fundamentals of Drilling Engineering*. SPE Textbook Series Vol. 12 (surge and swab, trip-speed limits).

## Functions used

`PO.DE.Surge.Burkhardt`, `PO.DE.Hyd.AnnulusLoss`

## Spreadsheet: SurgeSwab

|     | A                                                                                                                                                                                   | B                                                                                                                         | C                                                                                                                                                                                                                                                         | D                                                                                                                         | E                                                                                                                                 | F                                                                                                                         | G                                                                                                                         | H                                                                  | I                                                                  | J                                                                                           | K                                                             | L                          | M                                                                                         | N               |
|-----|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------|--------------------------------------------------------------------|---------------------------------------------------------------------------------------------|---------------------------------------------------------------|----------------------------|-------------------------------------------------------------------------------------------|-----------------|
| 1   | Surge and Swab Trip Speed                                                                                                                                                           |                                                                                                                           | Petroleum Office                                                                                                                                                                                                                                          |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 2   | Blue cells on yellow are inputs. Enter the casing and hole, the string, the mud and its power-law fit, the stand times, and the pore and fracture pressures.                        |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 3   | Casing and Hole                                                                                                                                                                     |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 4   | Casing inside diameter above the crossover                                                                                                                                          | 8.681                                                                                                                     | in                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 5   | Casing inside diameter below it, to the shoe                                                                                                                                        | 8.535                                                                                                                     | in                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 6   | Casing crossover depth                                                                                                                                                              | 8000                                                                                                                      | ft                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 7   | Casing shoe depth                                                                                                                                                                   | 10000                                                                                                                     | ft                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 8   | Open-hole diameter (bit size)                                                                                                                                                       | 8.5                                                                                                                       | in                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 9   | Bit depth                                                                                                                                                                           | 13000                                                                                                                     | ft                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 10  | String                                                                                                                                                                              |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 11  | Drill pipe outside diameter                                                                                                                                                         | 5                                                                                                                         | in                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 12  | Drill pipe inside diameter                                                                                                                                                          | 4.276                                                                                                                     | in                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 13  | Bottomhole assembly length                                                                                                                                                          | 600                                                                                                                       | ft                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 14  | Drill collar outside diameter                                                                                                                                                       | 6.5                                                                                                                       | in                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 15  | Drill collar inside diameter                                                                                                                                                        | 2.8125                                                                                                                    | in                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 16  | Mud and Pipe Movement                                                                                                                                                               |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 17  | Mud weight                                                                                                                                                                          | 13.9                                                                                                                      | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 18  | Power-law flow behavior index n (hydraulics sheet)                                                                                                                                  | 0.7                                                                                                                       | —                                                                                                                                                                                                                                                         |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 19  | Power-law consistency index K (hydraulics sheet)                                                                                                                                    | 280                                                                                                                       | eq cp                                                                                                                                                                                                                                                     |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 20  | Burkhardt clinging constant                                                                                                                                                         | 0.45                                                                                                                      | —                                                                                                                                                                                                                                                         |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 21  | Pipe end: 0 closed (float in the string), 1 open                                                                                                                                    | 0                                                                                                                         | —                                                                                                                                                                                                                                                         |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 22  | Stand length                                                                                                                                                                        | 93                                                                                                                        | ft                                                                                                                                                                                                                                                        |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 23  | Planned time to run a stand in                                                                                                                                                      | 45                                                                                                                        | s                                                                                                                                                                                                                                                         |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 24  | Planned time to pull a stand out                                                                                                                                                    | 75                                                                                                                        | s                                                                                                                                                                                                                                                         |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 25  | Peak pipe speed over the average                                                                                                                                                    | 1.5                                                                                                                       | —                                                                                                                                                                                                                                                         |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 26  | Limits and Sweep                                                                                                                                                                    |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 27  | Pore pressure at the shoe (pore-pressure sheet)                                                                                                                                     | 10.2                                                                                                                      | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 28  | Fracture gradient at the shoe (pore-pressure sheet)                                                                                                                                 | 15.4                                                                                                                      | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 29  | Pore pressure at the bit (pore-pressure sheet)                                                                                                                                      | 13.6                                                                                                                      | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 30  | Fracture gradient at the bit (pore-pressure sheet)                                                                                                                                  | 16.7                                                                                                                      | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 31  | Slowest average speed in the sweep                                                                                                                                                  | 20                                                                                                                        | ft/min                                                                                                                                                                                                                                                    |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 32  | Step between the sweep's speeds                                                                                                                                                     | 20                                                                                                                        | ft/min                                                                                                                                                                                                                                                    |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 35  | Annulus Sections at the Planned Speeds (Burkhardt, then the power-law loss)                                                                                                         |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 36  | Section                                                                                                                                                                             | Hole from (ft)                                                                                                            | Hole to (ft)                                                                                                                                                                                                                                              | Pipe in it (ft)                                                                                                           | Hole or casing ID (in)                                                                                                            | Pipe OD (in)                                                                                                              | Pipe ID (in)                                                                                                              | Velocity in (ft/min)                                               | Rate in (gpm)                                                      | Surge (psi)                                                                                 | Velocity out (ft/min)                                         | Rate out (gpm)             | Swab (psi)                                                                                |                 |
| 37  | Drill pipe, casing above the crossover                                                                                                                                              | =0                                                                                                                        | =MIN(SRG_Xover,SRG_Shoe)                                                                                                                                                                                                                                  | =_PO.DE.IntervalOverlap(0,SRG_Bit-SRG_BhaL,B37,C37)                                                                       | =SRG_IdTop                                                                                                                        | =SRG_DpOD                                                                                                                 | =SRG_DpID                                                                                                                 | =PO.DE.Surge.Burkhardt(SRG_VpIn,E37,F37,G37,SRG_Kc,SRG_Mode)       | =H37*(E37^2-F37^2)/SRG_AvQ                                         | =LET(SurgeRate_gpm,I37,PO.DE.Hyd.AnnulusLoss(SurgeRate_gpm,E37,F37,D37,SRG_MW,SRG_n,SRG_K)) | =PO.DE.Surge.Burkhardt(SRG_VpOut,E37,F37,G37,SRG_Kc,SRG_Mode) | =K37*(E37^2-F37^2)/SRG_AvQ | =LET(SwabRate_gpm,L37,PO.DE.Hyd.AnnulusLoss(SwabRate_gpm,E37,F37,D37,SRG_MW,SRG_n,SRG_K)) |                 |
| 38  | Drill pipe, casing below the crossover                                                                                                                                              | =MIN(SRG_Xover,SRG_Shoe)                                                                                                  | =SRG_Shoe                                                                                                                                                                                                                                                 | =_PO.DE.IntervalOverlap(0,SRG_Bit-SRG_BhaL,B38,C38)                                                                       | =SRG_IdBot                                                                                                                        | =SRG_DpOD                                                                                                                 | =SRG_DpID                                                                                                                 | =PO.DE.Surge.Burkhardt(SRG_VpIn,E38,F38,G38,SRG_Kc,SRG_Mode)       | =H38*(E38^2-F38^2)/SRG_AvQ                                         | =LET(SurgeRate_gpm,I38,PO.DE.Hyd.AnnulusLoss(SurgeRate_gpm,E38,F38,D38,SRG_MW,SRG_n,SRG_K)) | =PO.DE.Surge.Burkhardt(SRG_VpOut,E38,F38,G38,SRG_Kc,SRG_Mode) | =K38*(E38^2-F38^2)/SRG_AvQ | =LET(SwabRate_gpm,L38,PO.DE.Hyd.AnnulusLoss(SwabRate_gpm,E38,F38,D38,SRG_MW,SRG_n,SRG_K)) |                 |
| 39  | Drill pipe, open hole                                                                                                                                                               | =SRG_Shoe                                                                                                                 | =MAX(SRG_Shoe,SRG_Bit)                                                                                                                                                                                                                                    | =_PO.DE.IntervalOverlap(0,SRG_Bit-SRG_BhaL,B39,C39)                                                                       | =SRG_Hole                                                                                                                         | =SRG_DpOD                                                                                                                 | =SRG_DpID                                                                                                                 | =PO.DE.Surge.Burkhardt(SRG_VpIn,E39,F39,G39,SRG_Kc,SRG_Mode)       | =H39*(E39^2-F39^2)/SRG_AvQ                                         | =LET(SurgeRate_gpm,I39,PO.DE.Hyd.AnnulusLoss(SurgeRate_gpm,E39,F39,D39,SRG_MW,SRG_n,SRG_K)) | =PO.DE.Surge.Burkhardt(SRG_VpOut,E39,F39,G39,SRG_Kc,SRG_Mode) | =K39*(E39^2-F39^2)/SRG_AvQ | =LET(SwabRate_gpm,L39,PO.DE.Hyd.AnnulusLoss(SwabRate_gpm,E39,F39,D39,SRG_MW,SRG_n,SRG_K)) |                 |
| 40  | Collars, casing above the crossover                                                                                                                                                 | =0                                                                                                                        | =MIN(SRG_Xover,SRG_Shoe)                                                                                                                                                                                                                                  | =_PO.DE.IntervalOverlap(SRG_Bit-SRG_BhaL,SRG_Bit,B40,C40)                                                                 | =SRG_IdTop                                                                                                                        | =SRG_BhaOD                                                                                                                | =SRG_BhaID                                                                                                                | =PO.DE.Surge.Burkhardt(SRG_VpIn,E40,F40,G40,SRG_Kc,SRG_Mode)       | =H40*(E40^2-F40^2)/SRG_AvQ                                         | =LET(SurgeRate_gpm,I40,PO.DE.Hyd.AnnulusLoss(SurgeRate_gpm,E40,F40,D40,SRG_MW,SRG_n,SRG_K)) | =PO.DE.Surge.Burkhardt(SRG_VpOut,E40,F40,G40,SRG_Kc,SRG_Mode) | =K40*(E40^2-F40^2)/SRG_AvQ | =LET(SwabRate_gpm,L40,PO.DE.Hyd.AnnulusLoss(SwabRate_gpm,E40,F40,D40,SRG_MW,SRG_n,SRG_K)) |                 |
| 41  | Collars, casing below the crossover                                                                                                                                                 | =MIN(SRG_Xover,SRG_Shoe)                                                                                                  | =SRG_Shoe                                                                                                                                                                                                                                                 | =_PO.DE.IntervalOverlap(SRG_Bit-SRG_BhaL,SRG_Bit,B41,C41)                                                                 | =SRG_IdBot                                                                                                                        | =SRG_BhaOD                                                                                                                | =SRG_BhaID                                                                                                                | =PO.DE.Surge.Burkhardt(SRG_VpIn,E41,F41,G41,SRG_Kc,SRG_Mode)       | =H41*(E41^2-F41^2)/SRG_AvQ                                         | =LET(SurgeRate_gpm,I41,PO.DE.Hyd.AnnulusLoss(SurgeRate_gpm,E41,F41,D41,SRG_MW,SRG_n,SRG_K)) | =PO.DE.Surge.Burkhardt(SRG_VpOut,E41,F41,G41,SRG_Kc,SRG_Mode) | =K41*(E41^2-F41^2)/SRG_AvQ | =LET(SwabRate_gpm,L41,PO.DE.Hyd.AnnulusLoss(SwabRate_gpm,E41,F41,D41,SRG_MW,SRG_n,SRG_K)) |                 |
| 42  | Collars, open hole                                                                                                                                                                  | =SRG_Shoe                                                                                                                 | =MAX(SRG_Shoe,SRG_Bit)                                                                                                                                                                                                                                    | =_PO.DE.IntervalOverlap(SRG_Bit-SRG_BhaL,SRG_Bit,B42,C42)                                                                 | =SRG_Hole                                                                                                                         | =SRG_BhaOD                                                                                                                | =SRG_BhaID                                                                                                                | =PO.DE.Surge.Burkhardt(SRG_VpIn,E42,F42,G42,SRG_Kc,SRG_Mode)       | =H42*(E42^2-F42^2)/SRG_AvQ                                         | =LET(SurgeRate_gpm,I42,PO.DE.Hyd.AnnulusLoss(SurgeRate_gpm,E42,F42,D42,SRG_MW,SRG_n,SRG_K)) | =PO.DE.Surge.Burkhardt(SRG_VpOut,E42,F42,G42,SRG_Kc,SRG_Mode) | =K42*(E42^2-F42^2)/SRG_AvQ | =LET(SwabRate_gpm,L42,PO.DE.Hyd.AnnulusLoss(SwabRate_gpm,E42,F42,D42,SRG_MW,SRG_n,SRG_K)) |                 |
| 44  | Trip-Speed Sweep (the same loss pulls the column down swabbing)                                                                                                                     |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 45  | Average speed (ft/min)                                                                                                                                                              | DP, upper casing (psi)                                                                                                    | DP, lower casing (psi)                                                                                                                                                                                                                                    | DP, open hole (psi)                                                                                                       | BHA, upper casing (psi)                                                                                                           | BHA, lower casing (psi)                                                                                                   | BHA, open hole (psi)                                                                                                      | Surge at shoe (ppg)                                                | Swab at shoe (ppg)                                                 | Surge at bit (ppg)                                                                          | Swab at bit (ppg)                                             | Fracture, shoe (ppg)       | Fracture, bit (ppg)                                                                       | Pore, bit (ppg) |
| 46  | =SRG_Start+0*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A46*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A46*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A46*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A46*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A46*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A46*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B46+C46+E46+F46)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B46+C46+E46+F46)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B46:G46)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B46:G46)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 47  | =SRG_Start+1*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A47*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A47*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A47*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A47*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A47*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A47*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B47+C47+E47+F47)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B47+C47+E47+F47)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B47:G47)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B47:G47)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 48  | =SRG_Start+2*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A48*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A48*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A48*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A48*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A48*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A48*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B48+C48+E48+F48)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B48+C48+E48+F48)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B48:G48)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B48:G48)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 49  | =SRG_Start+3*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A49*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A49*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A49*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A49*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A49*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A49*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B49+C49+E49+F49)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B49+C49+E49+F49)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B49:G49)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B49:G49)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 50  | =SRG_Start+4*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A50*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A50*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A50*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A50*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A50*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A50*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B50+C50+E50+F50)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B50+C50+E50+F50)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B50:G50)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B50:G50)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 51  | =SRG_Start+5*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A51*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A51*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A51*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A51*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A51*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A51*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B51+C51+E51+F51)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B51+C51+E51+F51)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B51:G51)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B51:G51)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 52  | =SRG_Start+6*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A52*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A52*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A52*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A52*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A52*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A52*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B52+C52+E52+F52)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B52+C52+E52+F52)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B52:G52)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B52:G52)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 53  | =SRG_Start+7*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A53*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A53*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A53*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A53*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A53*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A53*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B53+C53+E53+F53)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B53+C53+E53+F53)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B53:G53)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B53:G53)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 54  | =SRG_Start+8*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A54*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A54*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A54*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A54*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A54*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A54*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B54+C54+E54+F54)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B54+C54+E54+F54)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B54:G54)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B54:G54)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 55  | =SRG_Start+9*SRG_StepV                                                                                                                                                              | =LET(SweepRate_gpm,$I$37*A55*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A55*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A55*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A55*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A55*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A55*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B55+C55+E55+F55)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B55+C55+E55+F55)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B55:G55)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B55:G55)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 56  | =SRG_Start+10*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A56*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A56*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A56*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A56*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A56*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A56*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B56+C56+E56+F56)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B56+C56+E56+F56)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B56:G56)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B56:G56)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 57  | =SRG_Start+11*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A57*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A57*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A57*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A57*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A57*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A57*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B57+C57+E57+F57)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B57+C57+E57+F57)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B57:G57)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B57:G57)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 58  | =SRG_Start+12*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A58*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A58*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A58*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A58*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A58*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A58*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B58+C58+E58+F58)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B58+C58+E58+F58)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B58:G58)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B58:G58)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 59  | =SRG_Start+13*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A59*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A59*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A59*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A59*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A59*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A59*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B59+C59+E59+F59)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B59+C59+E59+F59)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B59:G59)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B59:G59)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 60  | =SRG_Start+14*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A60*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A60*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A60*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A60*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A60*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A60*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B60+C60+E60+F60)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B60+C60+E60+F60)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B60:G60)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B60:G60)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 61  | =SRG_Start+15*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A61*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A61*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A61*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A61*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A61*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A61*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B61+C61+E61+F61)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B61+C61+E61+F61)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B61:G61)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B61:G61)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 62  | =SRG_Start+16*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A62*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A62*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A62*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A62*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A62*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A62*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B62+C62+E62+F62)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B62+C62+E62+F62)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B62:G62)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B62:G62)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 63  | =SRG_Start+17*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A63*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A63*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A63*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A63*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A63*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A63*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B63+C63+E63+F63)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B63+C63+E63+F63)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B63:G63)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B63:G63)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 64  | =SRG_Start+18*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A64*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A64*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A64*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A64*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A64*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A64*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B64+C64+E64+F64)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B64+C64+E64+F64)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B64:G64)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B64:G64)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 65  | =SRG_Start+19*SRG_StepV                                                                                                                                                             | =LET(SweepRate_gpm,$I$37*A65*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$37,$F$37,$D$37,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$38*A65*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$38,$F$38,$D$38,SRG_MW,SRG_n,SRG_K))                                                                                                                                 | =LET(SweepRate_gpm,$I$39*A65*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$39,$F$39,$D$39,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$40*A65*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$40,$F$40,$D$40,SRG_MW,SRG_n,SRG_K))         | =LET(SweepRate_gpm,$I$41*A65*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$41,$F$41,$D$41,SRG_MW,SRG_n,SRG_K)) | =LET(SweepRate_gpm,$I$42*A65*SRG_Peak/SRG_VpIn,PO.DE.Hyd.AnnulusLoss(SweepRate_gpm,$E$42,$F$42,$D$42,SRG_MW,SRG_n,SRG_K)) | =IF(SRG_Shoe>0,SRG_MW+(B65+C65+E65+F65)/(SRG_Psi*SRG_Shoe),SRG_MW) | =IF(SRG_Shoe>0,SRG_MW-(B65+C65+E65+F65)/(SRG_Psi*SRG_Shoe),SRG_MW) | =SRG_MW+SUM(B65:G65)/(SRG_Psi*SRG_Bit)                                                      | =SRG_MW-SUM(B65:G65)/(SRG_Psi*SRG_Bit)                        | =SRG_FgShoe                | =SRG_FgBit                                                                                | =SRG_PpBit      |
| 67  | Safe Trip Speeds (read between the sweep's rows)                                                                                                                                    |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 68  | Limit                                                                                                                                                                               | Limit (ppg)                                                                                                               | Safe speed (ft/min)                                                                                                                                                                                                                                       | Least time a stand (s)                                                                                                    | Limit reached                                                                                                                     |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 69  | Running in: fracture at the shoe                                                                                                                                                    | =SRG_FgShoe                                                                                                               | =LET(cnt,COUNTIF(H46:H65,"<"&B69),IF(cnt=0,0,IF(cnt=20,INDEX(A46:A65,cnt),INDEX(A46:A65,cnt)+(B69-INDEX(H46:H65,cnt))/(INDEX(H46:H65,cnt+1)-INDEX(H46:H65,cnt))*SRG_StepV)))                                                                              | =IF(C69>0,SRG_Stand*SRG_SecMin/C69,0)                                                                                     | =IF(C69>=MAX(A46:A65),"not reached: ≥ "&FIXED(C69,0)&", the sweep's top",IF(C69=0,"no sweep speed holds it","read between rows")) |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 70  | Running in: fracture at the bit                                                                                                                                                     | =SRG_FgBit                                                                                                                | =LET(cnt,COUNTIF(J46:J65,"<"&B70),IF(cnt=0,0,IF(cnt=20,INDEX(A46:A65,cnt),INDEX(A46:A65,cnt)+(B70-INDEX(J46:J65,cnt))/(INDEX(J46:J65,cnt+1)-INDEX(J46:J65,cnt))*SRG_StepV)))                                                                              | =IF(C70>0,SRG_Stand*SRG_SecMin/C70,0)                                                                                     | =IF(C70>=MAX(A46:A65),"not reached: ≥ "&FIXED(C70,0)&", the sweep's top",IF(C70=0,"no sweep speed holds it","read between rows")) |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 71  | Pulling out: pore pressure at the shoe                                                                                                                                              | =SRG_PpShoe                                                                                                               | =LET(cnt,COUNTIF(I46:I65,">"&B71),IF(cnt=0,0,IF(cnt=20,INDEX(A46:A65,cnt),INDEX(A46:A65,cnt)+(B71-INDEX(I46:I65,cnt))/(INDEX(I46:I65,cnt+1)-INDEX(I46:I65,cnt))*SRG_StepV)))                                                                              | =IF(C71>0,SRG_Stand*SRG_SecMin/C71,0)                                                                                     | =IF(C71>=MAX(A46:A65),"not reached: ≥ "&FIXED(C71,0)&", the sweep's top",IF(C71=0,"no sweep speed holds it","read between rows")) |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 72  | Pulling out: pore pressure at the bit                                                                                                                                               | =SRG_PpBit                                                                                                                | =LET(cnt,COUNTIF(K46:K65,">"&B72),IF(cnt=0,0,IF(cnt=20,INDEX(A46:A65,cnt),INDEX(A46:A65,cnt)+(B72-INDEX(K46:K65,cnt))/(INDEX(K46:K65,cnt+1)-INDEX(K46:K65,cnt))*SRG_StepV)))                                                                              | =IF(C72>0,SRG_Stand*SRG_SecMin/C72,0)                                                                                     | =IF(C72>=MAX(A46:A65),"not reached: ≥ "&FIXED(C72,0)&", the sweep's top",IF(C72=0,"no sweep speed holds it","read between rows")) |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 74  | Surge and Swab at the Planned Speeds, and the Safe Speeds                                                                                                                           |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 75  | Average speed running in                                                                                                                                                            | =SRG_Stand*SRG_SecMin/SRG_TimeIn                                                                                          | ft/min                                                                                                                                                                                                                                                    |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 76  | Peak speed running in                                                                                                                                                               | =SRG_Peak*SRG_VavgIn                                                                                                      | ft/min                                                                                                                                                                                                                                                    |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 77  | Average speed pulling out                                                                                                                                                           | =SRG_Stand*SRG_SecMin/SRG_TimeOut                                                                                         | ft/min                                                                                                                                                                                                                                                    |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 78  | Peak speed pulling out                                                                                                                                                              | =SRG_Peak*SRG_VavgOut                                                                                                     | ft/min                                                                                                                                                                                                                                                    |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 79  | Surge pressure at the shoe                                                                                                                                                          | =J37+J38+J40+J41                                                                                                          | psi                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 80  | Surge pressure at the bit                                                                                                                                                           | =SUM(J37:J42)                                                                                                             | psi                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 81  | Swab pressure at the shoe                                                                                                                                                           | =M37+M38+M40+M41                                                                                                          | psi                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 82  | Swab pressure at the bit                                                                                                                                                            | =SUM(M37:M42)                                                                                                             | psi                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 83  | Surge mud weight at the shoe                                                                                                                                                        | =IF(SRG_Shoe>0,SRG_MW+SRG_SurgeShoe/(SRG_Psi*SRG_Shoe),SRG_MW)                                                            | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 84  | Surge mud weight at the bit                                                                                                                                                         | =SRG_MW+SRG_SurgeBit/(SRG_Psi*SRG_Bit)                                                                                    | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 85  | Swab mud weight at the shoe                                                                                                                                                         | =IF(SRG_Shoe>0,SRG_MW-SRG_SwabShoe/(SRG_Psi*SRG_Shoe),SRG_MW)                                                             | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 86  | Swab mud weight at the bit                                                                                                                                                          | =SRG_MW-SRG_SwabBit/(SRG_Psi*SRG_Bit)                                                                                     | ppg                                                                                                                                                                                                                                                       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 87  | Safe average speed running in                                                                                                                                                       | =MIN(C69,C70)                                                                                                             | ft/min                                                                                                                                                                                                                                                    |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 88  | Safe average speed pulling out                                                                                                                                                      | =MIN(C71,C72)                                                                                                             | ft/min                                                                                                                                                                                                                                                    |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 89  | Least time to run a stand in                                                                                                                                                        | =IF(SRG_SafeIn>0,SRG_Stand*SRG_SecMin/SRG_SafeIn,0)                                                                       | s                                                                                                                                                                                                                                                         |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 90  | Least time to pull a stand out                                                                                                                                                      | =IF(SRG_SafeOut>0,SRG_Stand*SRG_SecMin/SRG_SafeOut,0)                                                                     | s                                                                                                                                                                                                                                                         |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 91  | Surge check                                                                                                                                                                         | =IF(AND(SRG_EmwSurgeShoe<SRG_FgShoe,SRG_EmwSurgeBit<SRG_FgBit),"PASS","FAIL")                                             | =IF(AND(SRG_EmwSurgeShoe<SRG_FgShoe,SRG_EmwSurgeBit<SRG_FgBit),"running in at the planned speed stays under the fracture gradient at the shoe and the bit","running in at the planned speed reaches the fracture gradient: run the stands in slower")     |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 92  | Swab check                                                                                                                                                                          | =IF(AND(SRG_EmwSwabShoe>SRG_PpShoe,SRG_EmwSwabBit>SRG_PpBit),"PASS","FAIL")                                               | =IF(AND(SRG_EmwSwabShoe>SRG_PpShoe,SRG_EmwSwabBit>SRG_PpBit),"pulling out at the planned speed stays over the pore pressure at the shoe and the bit","pulling out at the planned speed swabs the bottom under the pore pressure: pull the stands slower") |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 93  | Trip speed check                                                                                                                                                                    | =IF(AND(SRG_VavgIn<=SRG_SafeIn,SRG_VavgOut<=SRG_SafeOut),"PASS","FAIL")                                                   | =IF(AND(SRG_VavgIn<=SRG_SafeIn,SRG_VavgOut<=SRG_SafeOut),"both planned speeds are at or under the safe speeds","a planned speed is over its safe speed: take at least "&TEXT(SRG_LeastIn,"0")&" s a stand in and "&TEXT(SRG_LeastOut,"0")&" s out")       |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 95  | How to use it: take n and K from the hydraulics sheet's Fann fit of the mud in the hole, and the pore pressure and fracture gradient from the pore-pressure sheet or the shoe test. |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 96  | Steady state: the pipe's acceleration, the mud's gels and its compressibility add a transient the model leaves out.                                                                 |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 98  | Constants                                                                                                                                                                           |                                                                                                                           |                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 99  | Pressure gradient of 1 ppg of mud                                                                                                                                                   | 0.052                                                                                                                     | psi/ft/ppg                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 100 | Annular velocity to rate: v (D² − d²) / 24.5 gpm                                                                                                                                    | 24.5                                                                                                                      | ft/min·in²/gpm                                                                                                                                                                                                                                            |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |
| 101 | Seconds in a minute                                                                                                                                                                 | 60                                                                                                                        | s/min                                                                                                                                                                                                                                                     |                                                                                                                           |                                                                                                                                   |                                                                                                                           |                                                                                                                           |                                                                    |                                                                    |                                                                                             |                                                               |                            |                                                                                           |                 |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.DE.Surge.Burkhardt | =LAMBDA(Vp_ftmin, Dh_in, Dp_in, Di_in, Kc, Mode, Vp_ftmin*(IF(Mode=1, Dp_in^2 - Di_in^2, Dp_in^2)/(Dh_in^2 - Dp_in^2) + Kc)) | Burkhardt effective annular velocity, ft/min, of the mud a moving pipe displaces, with the clinging constant; closed-end (Mode 0) or open-end (Mode 1) pipe. |
| PO.DE.Hyd.AnnulusLoss | =LAMBDA(Q_gpm, Dh_in, Dp_in, L_ft, MW_ppg, n, K_cp, LET(v, Q_gpm / (2.448 * (Dh_in^2 - Dp_in^2)), gap, Dh_in - Dp_in, re, 109000 * MW_ppg * v^(2 - n) / K_cp * (0.0208 * (Dh_in - Dp_in) / (2 + 1 / n))^n, L_ft * IF(re < 3470 - 1370 * n, K_cp * v^n * ((2 + 1 / n) / 0.0208)^n / (144000 * gap^(1 + n)), 0.0791 / re^0.25 * MW_ppg * v^2 / (21.1 * gap)))) | Frictional pressure loss, psi, in an annulus for a power-law mud: laminar below the API RP 13D limit 3470 - 1370n, Blasius turbulent above (Bourgoyne et al.). |
| _PO.DE.IntervalOverlap | =LAMBDA(top_ft, bottom_ft, from_ft, to_ft, MAX(0, MIN(bottom_ft, to_ft) - MAX(top_ft, from_ft))) | Length, ft, of the interval top..bottom that lies inside from..to (0 when they do not overlap). |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| SRG_IdTop | $B$4 | Casing inside diameter above the crossover, in |
| SRG_IdBot | $B$5 | Casing inside diameter below it, to the shoe, in |
| SRG_Xover | $B$6 | Casing crossover depth, ft |
| SRG_Shoe | $B$7 | Casing shoe depth, ft |
| SRG_Hole | $B$8 | Open-hole diameter (bit size), in |
| SRG_Bit | $B$9 | Bit depth, ft |
| SRG_DpOD | $B$11 | Drill pipe outside diameter, in |
| SRG_DpID | $B$12 | Drill pipe inside diameter, in |
| SRG_BhaL | $B$13 | Bottomhole assembly length, ft |
| SRG_BhaOD | $B$14 | Drill collar outside diameter, in |
| SRG_BhaID | $B$15 | Drill collar inside diameter, in |
| SRG_MW | $B$17 | Mud weight, ppg |
| SRG_n | $B$18 | Power-law flow behavior index n (hydraulics sheet) |
| SRG_K | $B$19 | Power-law consistency index K (hydraulics sheet), eq cp |
| SRG_Kc | $B$20 | Burkhardt clinging constant |
| SRG_Mode | $B$21 | Pipe end: 0 closed (float in the string), 1 open |
| SRG_Stand | $B$22 | Stand length, ft |
| SRG_TimeIn | $B$23 | Planned time to run a stand in, s |
| SRG_TimeOut | $B$24 | Planned time to pull a stand out, s |
| SRG_Peak | $B$25 | Peak pipe speed over the average |
| SRG_PpShoe | $B$27 | Pore pressure at the shoe (pore-pressure sheet), ppg |
| SRG_FgShoe | $B$28 | Fracture gradient at the shoe (pore-pressure sheet), ppg |
| SRG_PpBit | $B$29 | Pore pressure at the bit (pore-pressure sheet), ppg |
| SRG_FgBit | $B$30 | Fracture gradient at the bit (pore-pressure sheet), ppg |
| SRG_Start | $B$31 | Slowest average speed in the sweep, ft/min |
| SRG_StepV | $B$32 | Step between the sweep's speeds, ft/min |
| SRG_Inputs | $B$4:$B$32 | The casing, its crossover and shoe, the hole and bit depth, the drill pipe and collars, the mud and its power-law n and K, the clinging constant, the pipe end, the stands and their times, the peak factor, the pore and fracture pressures, and the sweep |
| SRG_Sections | $A$37:$M$42 | Each annulus section: the hole section's depths, the pipe in it, the diameters, and running in and pulling out, Burkhardt's velocity, the equivalent rate and the loss |
| SRG_Curve | $A$46:$N$65 | Each average trip speed: the six sections' losses at its peak, the surge and swab mud weights at the shoe and the bit, and the limits |
| SRG_SafeSpeeds | $A$69:$E$72 | Each limit, its mud weight, the fastest average speed that holds it, read between the sweep rows (0 when none does), the least time per stand at that speed, and whether the sweep reached the limit |
| SRG_VavgIn | $B$75 | Average speed running in, ft/min |
| SRG_VpIn | $B$76 | Peak speed running in, ft/min |
| SRG_VavgOut | $B$77 | Average speed pulling out, ft/min |
| SRG_VpOut | $B$78 | Peak speed pulling out, ft/min |
| SRG_SurgeShoe | $B$79 | Surge pressure at the shoe, psi |
| SRG_SurgeBit | $B$80 | Surge pressure at the bit, psi |
| SRG_SwabShoe | $B$81 | Swab pressure at the shoe, psi |
| SRG_SwabBit | $B$82 | Swab pressure at the bit, psi |
| SRG_EmwSurgeShoe | $B$83 | Surge mud weight at the shoe, ppg |
| SRG_EmwSurgeBit | $B$84 | Surge mud weight at the bit, ppg |
| SRG_EmwSwabShoe | $B$85 | Swab mud weight at the shoe, ppg |
| SRG_EmwSwabBit | $B$86 | Swab mud weight at the bit, ppg |
| SRG_SafeIn | $B$87 | Safe average speed running in, ft/min |
| SRG_SafeOut | $B$88 | Safe average speed pulling out, ft/min |
| SRG_LeastIn | $B$89 | Least time to run a stand in, s |
| SRG_LeastOut | $B$90 | Least time to pull a stand out, s |
| SRG_SurgeCheck | $B$91 | Surge check verdict |
| SRG_SurgeCheckNote | $C$91 | Surge check comment |
| SRG_SwabCheck | $B$92 | Swab check verdict |
| SRG_SwabCheckNote | $C$92 | Swab check comment |
| SRG_SpeedCheck | $B$93 | Trip speed check verdict |
| SRG_SpeedCheckNote | $C$93 | Trip speed check comment |
| SRG_Results | $B$75:$B$93 | The planned average and peak speeds, the surge and swab pressures and mud weights at the shoe and the bit, the safe speeds and least stand times, and the three checks |
| SRG_Psi | $B$99 | Pressure gradient of 1 ppg of mud, psi/ft/ppg |
| SRG_AvQ | $B$100 | Annular velocity to rate: v (D² − d²) / 24.5 gpm, ft/min·in²/gpm |
| SRG_SecMin | $B$101 | Seconds in a minute, s/min |

---

## Related Blueprints
- [Pore Pressure and Mud-Weight Window](/blueprint/po.de.pore.pressure.eaton.md)
- [Drilling Hydraulics and ECD](/blueprint/po.de.hydraulics.program.md)
- [Primary Cement Job Design](/blueprint/po.de.cement.volumes.md)
- [BOP Accumulator Sizing](/blueprint/po.de.wellcontrol.accumulator.md)
- [Casing Design](/blueprint/po.de.casing.design.md)
- [Hole Cleaning and Solids Control](/blueprint/po.de.holecleaning.solids.md)

