---
cid: po.bp.vfp.liquid.loading
hub: vfp
tags: [VFP, gas-well, liquid-loading, Turner, Coleman, Li, critical-rate, critical-velocity, decline, deliquification]
facets: { discipline: production, phase: gas, property: critical-rate, method-type: empirical }
title: Gas Well Liquid Loading
summary: "Locates where in the tubing a gas well starts to load up by several droplet models and the year its decline gets it there."
slug: po.vfp.liquid.loading
type: worksheet
---

# Gas Well Liquid Loading

## Description

Where in the tubing does a gas well start to load with water, at what rate by each of the common droplet models, and in which year will its decline take it there? You enter the gas, the tubing, the wellhead pressure and temperatures, the liquid it lifts, today's rate and its Arps decline. You read off the Turner, Coleman and Li critical rates at the wellhead and down the tubing, where the well loads first, the years until it falls to each rate, and the gas it makes before it loads.

**Parameters:**
- **Gas and well**: the gas gravity `VLL_SGg` (air = 1), the depth of the perforations `VLL_TVD` (ft), the tubing's inner diameter `VLL_ID` (in) and relative roughness `VLL_Rough`, the flowing wellhead pressure `VLL_Pwh` (psia), and the wellhead and bottomhole temperatures `VLL_Twh` and `VLL_Tbh` (°F)
- **The liquid it lifts**: its density `VLL_RhoL` (lb/ft³) and surface tension against the gas `VLL_IFT` (dyne/cm)
- **Rate today and its decline**: the gas rate `VLL_Qg` (MMscf/d), the nominal decline `VLL_Di` (1/yr) and Arps's exponent `VLL_b`
- **Limits**: Turner's upward adjustment `VLL_TurnerF` (1.2) and the lead time to put a lift on the well `VLL_Lead` (years)

**How to use it:** Take the rate, wellhead pressure and temperatures from a stabilized test, the tubing from the completion, and Di and b from an Arps fit to the well's own rate history (the Arps Decline Forecast sheet). Take condensate's density and surface tension (45 lb/ft³, 20 dyne/cm) only when the well makes no water. The Gas Well Tubing Performance sheet reads Turner's critical rate at the wellhead; this sheet starts from that rate and sets Coleman's beside it, Turner's equation without the 20 % adjustment (the same LAMBDA with its factor set to 1; there is no separate Coleman entry), and Li's flat-droplet rate. It then follows the tubing down from the wellhead to the perforations in ten steps at the wellhead's Turner rate: the temperature, the pressure by the single-phase gas equation in two passes, Z, the three critical rates and Turner's and Li's critical velocities at each depth. The largest critical rate down the tubing decides when the well loads, and the sheet says where it is. A second pass at the bottom, at that larger rate, shows whether the profile at the wellhead's rate was close enough. The well's Arps decline from today's rate gives the years until it falls to each critical rate, and the gas it makes before it loads by Turner. Two charts draw the critical rates against depth and the decline against them. Three checks read the loading today, the time left against the lead time for a lift, and the profile's second pass.

**Method:** Turner's critical rate is qc = 3.06·p·vt·A/(T·Z) MMscf/d with vt = F·1.593·σ^¼·(ρL − ρg)^¼/ρg^½ ft/s, Z by Dranchuk-Abou-Kassem at Sutton's pseudo-criticals; F = 1.2 is Turner's, and F = 1 is Coleman's. Li's is the same with 0.72907 in place of F·1.593. Down the tubing the temperature is linear from the wellhead's to the bottom's. At each depth the pressure is the single-phase gas equation from the wellhead pressure over that length at the mean temperature, first with Z and μg at the wellhead, then at the mean of the wellhead pressure and the first pass (μg by Lee-Gonzalez-Eakin), at the wellhead Turner rate: the rate at which the wellhead would just load. The critical rates are read at each depth's pressure and temperature, and the critical velocity is the gas's in-situ velocity at that rate (Bg from Z). The largest of each column is the rate the well has to keep; at the larger rate the bottom's pressure moves, and the sheet's second pass there shows by how much. The decline is Arps's, q = qi/(1 + b·Di·t)^(1/b); the years to a critical rate qc are ((qi/qc)^b − 1)/(b·Di) (ln(qi/qc)/Di at b = 0), and the gas made to then is Arps's cumulative in MMscf/d·yr, times 365.25 d/yr.

**Example:** The default case is the Gas Well Tubing Performance sheet's: the gas-inflow family's reference well, a vertical gas well on 640 acres (re = 2,980 ft, rw = 0.354 ft) in 40 ft of 8 mD sand, perforated over its top 20 ft, producing a 0.7 gravity sweet gas from a 3,000 psia reservoir at 160 °F, with a skin of 2 from a buildup. It has 2-7/8-in tubing (2.441 in ID) completed to its perforations at 7,500 ft TVD (relative roughness 0.0006) and flows to 1,200 psia and 100 °F at the wellhead against the gathering line, making water (Turner's water: 67 lb/ft³, 60 dyne/cm). Today it makes the four-point test's third rate, 8,210 Mscf/d. Its decline is an assumption, stated, not fitted: Arps hyperbolic with b = 0.5, the exponent Fetkovich et al. (1996) give for a gas well in boundary-dominated flow against a low backpressure, and a nominal 0.35 a year. A lift takes two years to put on the well. At the wellhead's 1,200 psia and 100 °F, Z = 0.8271 and Turner's rate is 1.739 MMscf/d, the gas-well sheet's; Coleman's is 1.739/1.2 = 1.449 and Li's 1.449 × 0.72907/1.593 = 0.663. At 1.739 MMscf/d the gas column is nearly static: the pressure rises to 1,479.0 psia at 7,500 ft, where the gas at 160 °F is denser (Z = 0.8653), and Turner's rate there is 1.792 MMscf/d, 3.0 % above the wellhead's. So the well loads first at the bottom. Coleman's largest is 1.493 and Li's 0.683, also at the bottom. Turner's critical velocity falls from 6.76 ft/s at the wellhead to 6.54 at the bottom. At 1.792 MMscf/d the bottom's pressure is 1,480.1 psia and its Turner rate moves 0.04 %, so the profile holds. Today's 8.21 MMscf/d is 4.58 times that rate. On the decline it falls to 1.792 MMscf/d in ((8.21/1.792)^0.5 − 1)/(0.5 × 0.35) = 6.52 years, to Coleman's in 7.69 and to Li's in 14.09, after 9.13 Bscf: the well has six and a half years before it needs a lift, more than the two-year lead time.

## Validity

Turner's droplet model was fitted to gas wells mostly above 1,000 psia at the wellhead, in the mist regime; Coleman et al. found wells under about 1,000 psia loaded at Turner's velocity without the 20 % adjustment, and Li et al.'s flat drop gives the lowest rate of the three. The three bracket the loading: a well under Turner's rate but over Li's is the one to watch with a flowing gradient survey. The profile is single-phase gas with one Z and μg per depth, the gas equation's average-temperature, average-Z method; the water's head is left out, as it is from the critical rate. The wellhead pressure is held by the gathering line for the life of the well, so the critical rates are fixed and only the decline moves; a falling line pressure (compression) lowers them, and the year moves out. The decline is a stated Arps curve: with a rate history, fit Di and b to it; a well whose decline steepens as it loads, or a terminal decline, moves the year. Read the largest rate down a uniform string: a tapered string or a liner's larger bore below the tubing loads at the larger diameter first.

Named alternatives: the Gas Well Tubing Performance sheet for the tubing performance and Turner's rate by size, the Gas Well Tubing Sizing sheet for a velocity string against the IPR, Nosseir's flow-regime model, and a nodal analysis of the loaded tubing curve for how the rate falls once the well loads.

## References

- Turner, R.G., Hubbard, M.G. and Dukler, A.E. (1969). "Analysis and Prediction of Minimum Flow Rate for the Continuous Removal of Liquids from Gas Wells." *JPT* 21(11), 1475–1482.
- Coleman, S.B., Clay, H.B., McCurdy, D.G. and Norris, H.L. III (1991). "A New Look at Predicting Gas-Well Load-Up." *JPT* 43(3), 329–333.
- Li, M., Li, S.L. and Sun, L.T. (2001). "New View on Continuous-Removal Liquids from Gas Wells." SPE Permian Basin Oil and Gas Recovery Conference, Midland.
- Fetkovich, M.J., Fetkovich, E.J. and Fetkovich, M.D. (1996). "Useful Concepts for Decline-Curve Forecasting, Reserve Estimation, and Analysis." *SPE Reservoir Engineering* 11(1), 13–22.
- Arps, J.J. (1945). "Analysis of Decline Curves." *Trans. AIME* 160, 228–247.
- Lea, J.F., Nickens, H.V. and Wells, M.R. (2008). *Gas Well Deliquification*, 2nd ed. Gulf Professional Publishing, ch. 3.

## Functions used

`PO.PE.Loading.TurnerRate`, `PO.PE.Loading.LiRate`, `PO.VFP.Gas.Pin`, `PO.DCA.Arps.Time`, `PO.DCA.Arps.Prod`, `PO.DCA.Arps.Rate`, `PO.FA.Erosion.Vmix`, `PO.PVT.Ppc.BySutton`, `PO.PVT.Tpc.BySutton`, `PO.PVT.Z.ByDAK`, `PO.PVT.Ug.ByLGE`, `PO.PVT.Bg.ByDefinition`

## Spreadsheet: VfpLiquidLoading

|     | A                                                                                                                                                                                                    | B                                                                                                                                                                                                                                                                                                                                                              | C                                                                                                                                                                                                                                                                                                                                                                                                                                                 | D                                                 | E                                                                                                         | F                                                                                                         | G                                                              | H                                                                                            | I            |
|-----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------|-----------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------|----------------------------------------------------------------|----------------------------------------------------------------------------------------------|--------------|
| 1   | Gas Well Liquid Loading                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 2   | Blue cells on yellow are inputs. Type the gas, the tubing, the water and the well's decline; the critical rates by Turner, Coleman and Li down the tubing and the year the well reaches each follow. |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 3   | Gas and Well (the Gas-Well Sheet's)                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 4   | Gas specific gravity (air = 1), sweet gas                                                                                                                                                            | 0.7                                                                                                                                                                                                                                                                                                                                                            | air = 1                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 5   | Depth of the perforations, tubing to them (TVD)                                                                                                                                                      | 7500                                                                                                                                                                                                                                                                                                                                                           | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 6   | Tubing inner diameter                                                                                                                                                                                | 2.441                                                                                                                                                                                                                                                                                                                                                          | in                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 7   | Tubing relative roughness, ε/D                                                                                                                                                                       | 0.0006                                                                                                                                                                                                                                                                                                                                                         | —                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 8   | Flowing wellhead pressure, held by the gathering line                                                                                                                                                | 1200                                                                                                                                                                                                                                                                                                                                                           | psia                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 9   | Flowing wellhead temperature                                                                                                                                                                         | 100                                                                                                                                                                                                                                                                                                                                                            | °F                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 10  | Temperature at the perforations, the reservoir's                                                                                                                                                     | 160                                                                                                                                                                                                                                                                                                                                                            | °F                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 11  | The Liquid It Lifts                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 12  | Liquid density (water)                                                                                                                                                                               | 67                                                                                                                                                                                                                                                                                                                                                             | lb/ft³                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 13  | Liquid-gas surface tension (water)                                                                                                                                                                   | 60                                                                                                                                                                                                                                                                                                                                                             | dyne/cm                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 14  | Rate Today and Its Decline (Arps)                                                                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 15  | Gas rate today, the start of the decline                                                                                                                                                             | 8.21                                                                                                                                                                                                                                                                                                                                                           | MMscf/d                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 16  | Nominal decline rate today, Di                                                                                                                                                                       | 0.35                                                                                                                                                                                                                                                                                                                                                           | 1/yr                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 17  | Arps hyperbolic exponent, b                                                                                                                                                                          | 0.5                                                                                                                                                                                                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 18  | Turner's Adjustment and the Lead Time                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 19  | Turner's upward adjustment on the critical velocity                                                                                                                                                  | 1.2                                                                                                                                                                                                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 20  | Lead time to put a lift on the well                                                                                                                                                                  | 2                                                                                                                                                                                                                                                                                                                                                              | years                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 22  | Gas at the Wellhead                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 23  | Gas pseudo-critical pressure (Sutton)                                                                                                                                                                | =PO.PVT.Ppc.BySutton(VLL_SGg)                                                                                                                                                                                                                                                                                                                                  | psia                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 24  | Gas pseudo-critical temperature (Sutton)                                                                                                                                                             | =PO.PVT.Tpc.BySutton(VLL_SGg)                                                                                                                                                                                                                                                                                                                                  | °R                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 25  | Z-factor at the wellhead (Dranchuk-Abou-Kassem)                                                                                                                                                      | =PO.PVT.Z.ByDAK(VLL_Pwh/VLL_Ppc,(VLL_Twh+VLL_R0)/VLL_Tpc)                                                                                                                                                                                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 26  | Gas viscosity at the wellhead (Lee-Gonzalez-Eakin)                                                                                                                                                   | =PO.PVT.Ug.ByLGE(VLL_Zwh,VLL_SGg,VLL_Pwh,VLL_Twh+VLL_R0)                                                                                                                                                                                                                                                                                                       | cp                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 27  | Critical Rates at the Wellhead                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 28  | Turner, the gas-well sheet's                                                                                                                                                                         | =PO.PE.Loading.TurnerRate(VLL_Pwh,VLL_Twh,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)                                                                                                                                                                                                                                                                         | MMscf/d                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 29  | Coleman (Turner with factor 1)                                                                                                                                                                       | =PO.PE.Loading.TurnerRate(VLL_Pwh,VLL_Twh,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)                                                                                                                                                                                                                                                                         | MMscf/d                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 30  | Li, flat droplets                                                                                                                                                                                    | =PO.PE.Loading.LiRate(VLL_Pwh,VLL_Twh,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL)                                                                                                                                                                                                                                                                                         | MMscf/d                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 31  | Down the Tubing, at the Wellhead Turner Rate                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 32  | Bottomhole pressure at that rate                                                                                                                                                                     | =C67                                                                                                                                                                                                                                                                                                                                                           | psia                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 33  | Turner rate, the largest down the tubing                                                                                                                                                             | =MAX($E$57:$E$67)                                                                                                                                                                                                                                                                                                                                              | MMscf/d                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 34  | Depth where it is largest                                                                                                                                                                            | =INDEX($A$57:$A$67,MATCH(VLL_QcT,$E$57:$E$67,0))                                                                                                                                                                                                                                                                                                               | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 35  | Where the well loads first                                                                                                                                                                           | =""&IF(VLL_ZGov=0,"At the wellhead",IF(VLL_ZGov=VLL_TVD,"At the bottom","Part way down"))                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 36  | Coleman rate, the largest down the tubing                                                                                                                                                            | =MAX($F$57:$F$67)                                                                                                                                                                                                                                                                                                                                              | MMscf/d                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 37  | Li rate, the largest down the tubing                                                                                                                                                                 | =MAX($G$57:$G$67)                                                                                                                                                                                                                                                                                                                                              | MMscf/d                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 38  | Bottomhole pressure at that Turner rate                                                                                                                                                              | =LET(tmean,(VLL_Twh+VLL_Tbh)/2,first,PO.VFP.Gas.Pin(VLL_QcT,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,VLL_TVD,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcT,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,VLL_TVD,VLL_Rough,VLL_Vert)) | psia                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 39  | Turner rate at the bottom at that pressure                                                                                                                                                           | =LET(pbhGov_psia,VLL_PbhGov,PO.PE.Loading.TurnerRate(pbhGov_psia,VLL_Tbh,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF))                                                                                                                                                                                                                                         | MMscf/d                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 40  | Second pass at the bottom against the profile's                                                                                                                                                      | =VLL_QcBh2/E67-1                                                                                                                                                                                                                                                                                                                                               | %                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 41  | When the Well Loads Up on Its Decline                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 42  | Rate today over the largest Turner rate                                                                                                                                                              | =VLL_Qg/VLL_QcT                                                                                                                                                                                                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 43  | Years until it loads by Turner                                                                                                                                                                       | =PO.DCA.Arps.Time(MAX(VLL_Qg,VLL_QcT),VLL_Di,VLL_b,VLL_QcT)                                                                                                                                                                                                                                                                                                    | years                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 44  | Years until it loads by Coleman                                                                                                                                                                      | =PO.DCA.Arps.Time(MAX(VLL_Qg,VLL_QcC),VLL_Di,VLL_b,VLL_QcC)                                                                                                                                                                                                                                                                                                    | years                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 45  | Years until it loads by Li                                                                                                                                                                           | =PO.DCA.Arps.Time(MAX(VLL_Qg,VLL_QcLi),VLL_Di,VLL_b,VLL_QcLi)                                                                                                                                                                                                                                                                                                  | years                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 46  | Gas made before it loads by Turner                                                                                                                                                                   | =PO.DCA.Arps.Prod(VLL_Qg,VLL_Di,VLL_b,VLL_tT)*VLL_DaysYr/VLL_MMB                                                                                                                                                                                                                                                                                               | Bscf                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 47  | Loading check                                                                                                                                                                                        | =IF(VLL_Qg>=VLL_QcT,"PASS",IF(VLL_Qg>=VLL_QcLi,"WARN","FAIL"))                                                                                                                                                                                                                                                                                                 | =IF(VLL_Qg>=VLL_QcT,""&FIXED(VLL_Qg,2)&" MMscf/d is over Turner's "&FIXED(VLL_QcT,2)&" MMscf/d, the largest down the tubing: the gas carries its water out",IF(VLL_Qg>=VLL_QcLi,""&FIXED(VLL_Qg,2)&" MMscf/d is under Turner's "&FIXED(VLL_QcT,2)&" but over Li's "&FIXED(VLL_QcLi,2)&" MMscf/d: run a flowing gradient survey",""&FIXED(VLL_Qg,2)&" MMscf/d is under Li's "&FIXED(VLL_QcLi,2)&" MMscf/d too: the well is loading now; lift it")) |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 48  | Lead time check                                                                                                                                                                                      | =IF(VLL_tT>VLL_Lead,"PASS","WARN")                                                                                                                                                                                                                                                                                                                             | =IF(VLL_tT>VLL_Lead,"it loads by Turner in "&FIXED(VLL_tT,2)&" years (Coleman "&FIXED(VLL_tC,2)&", Li "&FIXED(VLL_tLi,2)&"), past the "&FIXED(VLL_Lead,2)&"-year lead time","it loads by Turner in "&FIXED(VLL_tT,2)&" years, within the "&FIXED(VLL_Lead,2)&"-year lead time: order the velocity string or plunger now")                                                                                                                         |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 49  | Profile check                                                                                                                                                                                        | =IF(ABS(VLL_PassErr)<=VLL_PassTol,"PASS","WARN")                                                                                                                                                                                                                                                                                                               | =IF(ABS(VLL_PassErr)<=VLL_PassTol,"at the largest Turner rate the bottom's moves "&FIXED(VLL_PassErr*100,2)&"%, so the profile at the wellhead's rate holds","at the largest Turner rate the bottom's moves "&FIXED(VLL_PassErr*100,2)&"%: friction matters here; read the bottom's second pass")                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 51  | How to use it: the rate, wellhead pressure and temperatures from a stabilized test, the tubing from the completion, and Di and b fitted to the well's own history on the Arps sheet.                 |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 52  | Coleman is Turner's critical rate with the factor set to 1; there is no separate Coleman entry. Li is the optimistic end of the bracket, Turner the conservative.                                    |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 53  | The wellhead pressure stays at the gathering line's as the rate falls, so the critical rates are fixed and only the decline moves.                                                                   |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 55  | Down the Tubing at the Wellhead Turner Rate                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 56  | Depth TVD (ft)                                                                                                                                                                                       | Temperature (°F)                                                                                                                                                                                                                                                                                                                                               | Pressure (psia)                                                                                                                                                                                                                                                                                                                                                                                                                                   | Z                                                 | Turner (MMscf/d)                                                                                          | Coleman (MMscf/d)                                                                                         | Li (MMscf/d)                                                   | Turner vc (ft/s)                                                                             | Li vc (ft/s) |
| 57  | =VLL_TVD*0/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A57/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =VLL_Pwh                                                                                                                                                                                                                                                                                                                                                                                                                                          | =PO.PVT.Z.ByDAK(C57/VLL_Ppc,(B57+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C57,PO.PE.Loading.TurnerRate(pFlow_psia,B57,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C57,PO.PE.Loading.TurnerRate(pFlow_psia,B57,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C57,B57,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E57*VLL_Scf*PO.PVT.Bg.ByDefinition(C57,B57+VLL_R0,D57)/VLL_Sec,0,VLL_ID) | =H57*G57/E57 |
| 58  | =VLL_TVD*1/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A58/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B58)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A58,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A58,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C58/VLL_Ppc,(B58+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C58,PO.PE.Loading.TurnerRate(pFlow_psia,B58,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C58,PO.PE.Loading.TurnerRate(pFlow_psia,B58,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C58,B58,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E58*VLL_Scf*PO.PVT.Bg.ByDefinition(C58,B58+VLL_R0,D58)/VLL_Sec,0,VLL_ID) | =H58*G58/E58 |
| 59  | =VLL_TVD*2/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A59/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B59)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A59,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A59,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C59/VLL_Ppc,(B59+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C59,PO.PE.Loading.TurnerRate(pFlow_psia,B59,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C59,PO.PE.Loading.TurnerRate(pFlow_psia,B59,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C59,B59,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E59*VLL_Scf*PO.PVT.Bg.ByDefinition(C59,B59+VLL_R0,D59)/VLL_Sec,0,VLL_ID) | =H59*G59/E59 |
| 60  | =VLL_TVD*3/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A60/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B60)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A60,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A60,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C60/VLL_Ppc,(B60+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C60,PO.PE.Loading.TurnerRate(pFlow_psia,B60,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C60,PO.PE.Loading.TurnerRate(pFlow_psia,B60,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C60,B60,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E60*VLL_Scf*PO.PVT.Bg.ByDefinition(C60,B60+VLL_R0,D60)/VLL_Sec,0,VLL_ID) | =H60*G60/E60 |
| 61  | =VLL_TVD*4/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A61/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B61)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A61,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A61,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C61/VLL_Ppc,(B61+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C61,PO.PE.Loading.TurnerRate(pFlow_psia,B61,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C61,PO.PE.Loading.TurnerRate(pFlow_psia,B61,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C61,B61,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E61*VLL_Scf*PO.PVT.Bg.ByDefinition(C61,B61+VLL_R0,D61)/VLL_Sec,0,VLL_ID) | =H61*G61/E61 |
| 62  | =VLL_TVD*5/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A62/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B62)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A62,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A62,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C62/VLL_Ppc,(B62+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C62,PO.PE.Loading.TurnerRate(pFlow_psia,B62,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C62,PO.PE.Loading.TurnerRate(pFlow_psia,B62,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C62,B62,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E62*VLL_Scf*PO.PVT.Bg.ByDefinition(C62,B62+VLL_R0,D62)/VLL_Sec,0,VLL_ID) | =H62*G62/E62 |
| 63  | =VLL_TVD*6/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A63/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B63)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A63,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A63,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C63/VLL_Ppc,(B63+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C63,PO.PE.Loading.TurnerRate(pFlow_psia,B63,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C63,PO.PE.Loading.TurnerRate(pFlow_psia,B63,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C63,B63,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E63*VLL_Scf*PO.PVT.Bg.ByDefinition(C63,B63+VLL_R0,D63)/VLL_Sec,0,VLL_ID) | =H63*G63/E63 |
| 64  | =VLL_TVD*7/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A64/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B64)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A64,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A64,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C64/VLL_Ppc,(B64+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C64,PO.PE.Loading.TurnerRate(pFlow_psia,B64,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C64,PO.PE.Loading.TurnerRate(pFlow_psia,B64,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C64,B64,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E64*VLL_Scf*PO.PVT.Bg.ByDefinition(C64,B64+VLL_R0,D64)/VLL_Sec,0,VLL_ID) | =H64*G64/E64 |
| 65  | =VLL_TVD*8/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A65/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B65)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A65,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A65,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C65/VLL_Ppc,(B65+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C65,PO.PE.Loading.TurnerRate(pFlow_psia,B65,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C65,PO.PE.Loading.TurnerRate(pFlow_psia,B65,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C65,B65,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E65*VLL_Scf*PO.PVT.Bg.ByDefinition(C65,B65+VLL_R0,D65)/VLL_Sec,0,VLL_ID) | =H65*G65/E65 |
| 66  | =VLL_TVD*9/10                                                                                                                                                                                        | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A66/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B66)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A66,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A66,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C66/VLL_Ppc,(B66+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C66,PO.PE.Loading.TurnerRate(pFlow_psia,B66,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C66,PO.PE.Loading.TurnerRate(pFlow_psia,B66,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C66,B66,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E66*VLL_Scf*PO.PVT.Bg.ByDefinition(C66,B66+VLL_R0,D66)/VLL_Sec,0,VLL_ID) | =H66*G66/E66 |
| 67  | =VLL_TVD*10/10                                                                                                                                                                                       | =VLL_Twh+(VLL_Tbh-VLL_Twh)*A67/VLL_TVD                                                                                                                                                                                                                                                                                                                         | =LET(tmean,(VLL_Twh+B67)/2,first,PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,VLL_Ugwh,VLL_Zwh,VLL_ID,A67,VLL_Rough,VLL_Vert),mean,(VLL_Pwh+first)/2,zmean,PO.PVT.Z.ByDAK(mean/VLL_Ppc,(tmean+VLL_R0)/VLL_Tpc),PO.VFP.Gas.Pin(VLL_QcWh,VLL_Pwh,tmean,VLL_SGg,PO.PVT.Ug.ByLGE(zmean,VLL_SGg,mean,tmean+VLL_R0),zmean,VLL_ID,A67,VLL_Rough,VLL_Vert))                                                                                              | =PO.PVT.Z.ByDAK(C67/VLL_Ppc,(B67+VLL_R0)/VLL_Tpc) | =LET(pFlow_psia,C67,PO.PE.Loading.TurnerRate(pFlow_psia,B67,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_TurnerF)) | =LET(pFlow_psia,C67,PO.PE.Loading.TurnerRate(pFlow_psia,B67,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL,VLL_Coleman)) | =PO.PE.Loading.LiRate(C67,B67,VLL_SGg,VLL_ID,VLL_IFT,VLL_RhoL) | =PO.FA.Erosion.Vmix(E67*VLL_Scf*PO.PVT.Bg.ByDefinition(C67,B67+VLL_R0,D67)/VLL_Sec,0,VLL_ID) | =H67*G67/E67 |
| 69  | The Decline Against the Critical Rates                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 70  | Year (years)                                                                                                                                                                                         | Gas rate (MMscf/d)                                                                                                                                                                                                                                                                                                                                             | Turner (MMscf/d)                                                                                                                                                                                                                                                                                                                                                                                                                                  | Coleman (MMscf/d)                                 | Li (MMscf/d)                                                                                              | State                                                                                                     |                                                                |                                                                                              |              |
| 71  | =0                                                                                                                                                                                                   | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A71)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B71>=C71,"Unloads",IF(B71>=E71,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 72  | =A71+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A72)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B72>=C72,"Unloads",IF(B72>=E72,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 73  | =A72+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A73)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B73>=C73,"Unloads",IF(B73>=E73,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 74  | =A73+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A74)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B74>=C74,"Unloads",IF(B74>=E74,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 75  | =A74+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A75)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B75>=C75,"Unloads",IF(B75>=E75,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 76  | =A75+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A76)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B76>=C76,"Unloads",IF(B76>=E76,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 77  | =A76+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A77)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B77>=C77,"Unloads",IF(B77>=E77,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 78  | =A77+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A78)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B78>=C78,"Unloads",IF(B78>=E78,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 79  | =A78+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A79)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B79>=C79,"Unloads",IF(B79>=E79,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 80  | =A79+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A80)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B80>=C80,"Unloads",IF(B80>=E80,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 81  | =A80+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A81)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B81>=C81,"Unloads",IF(B81>=E81,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 82  | =A81+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A82)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B82>=C82,"Unloads",IF(B82>=E82,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 83  | =A82+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A83)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B83>=C83,"Unloads",IF(B83>=E83,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 84  | =A83+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A84)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B84>=C84,"Unloads",IF(B84>=E84,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 85  | =A84+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A85)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B85>=C85,"Unloads",IF(B85>=E85,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 86  | =A85+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A86)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B86>=C86,"Unloads",IF(B86>=E86,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 87  | =A86+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A87)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B87>=C87,"Unloads",IF(B87>=E87,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 88  | =A87+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A88)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B88>=C88,"Unloads",IF(B88>=E88,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 89  | =A88+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A89)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B89>=C89,"Unloads",IF(B89>=E89,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 90  | =A89+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A90)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B90>=C90,"Unloads",IF(B90>=E90,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 91  | =A90+VLL_Step                                                                                                                                                                                        | =PO.DCA.Arps.Rate(VLL_Qg,VLL_Di,VLL_b,A91)                                                                                                                                                                                                                                                                                                                     | =VLL_QcT                                                                                                                                                                                                                                                                                                                                                                                                                                          | =VLL_QcC                                          | =VLL_QcLi                                                                                                 | =IF(B91>=C91,"Unloads",IF(B91>=E91,"Loads by Turner","Loads by Li too"))                                  |                                                                |                                                                                              |              |
| 93  | Constants                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 94  | Coleman's adjustment: none                                                                                                                                                                           | 1                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 95  | A vertical pipe's angle from horizontal                                                                                                                                                              | 90                                                                                                                                                                                                                                                                                                                                                             | °                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 96  | Rankine at 0 °F                                                                                                                                                                                      | 459.67                                                                                                                                                                                                                                                                                                                                                         | °R                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 97  | scf in an MMscf                                                                                                                                                                                      | 1000000                                                                                                                                                                                                                                                                                                                                                        | scf/MMscf                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 98  | Seconds in a day                                                                                                                                                                                     | 86400                                                                                                                                                                                                                                                                                                                                                          | s/d                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 99  | Days in a year                                                                                                                                                                                       | 365.25                                                                                                                                                                                                                                                                                                                                                         | d/yr                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 100 | MMscf in a Bscf                                                                                                                                                                                      | 1000                                                                                                                                                                                                                                                                                                                                                           | MMscf/Bscf                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 101 | Step of the decline table                                                                                                                                                                            | 1                                                                                                                                                                                                                                                                                                                                                              | years                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |
| 102 | Bottom's second pass accepted                                                                                                                                                                        | 0.01                                                                                                                                                                                                                                                                                                                                                           | %                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                   |                                                                                                           |                                                                                                           |                                                                |                                                                                              |              |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.PE.Loading.TurnerRate | =LAMBDA(p, t, sg_g, tubing_id, sigma, rho_l, factor, IF(OR(p<=0, t<=-459.67, sg_g<=0, tubing_id<=0, sigma<=0, rho_l<=0, factor<=0), NA(), LET(tr, t+459.67, z, PO.PVT.Z.ByDAK(p/PO.PVT.Ppc.BySutton(sg_g), tr/PO.PVT.Tpc.BySutton(sg_g)), rho_g, PO.PVT.Rho.Gas.ByDefinition(p, tr, sg_g, z)*62.428, IF(rho_l<=rho_g, NA(), 3.06*p*factor*1.593*sigma^0.25*(rho_l-rho_g)^0.25/rho_g^0.5*PI()*tubing_id^2/576/(tr*z))))) | Turner critical gas rate to unload liquid, MMscf/d: p (psia) and t (°F) where it is read, usually the wellhead, gas gravity sg_g, tubing_id (in), the liquid's sigma (dyne/cm) and rho_l (lb/ft³), and factor (1.2 Turner, 1 Coleman). |
| PO.PE.Loading.LiRate | =LAMBDA(p_psia, t_degF, sg_gas, tubingID_in, sigma_dyncm, rhoL_lbft3, IF(OR(p_psia<=0, t_degF<=-459.67, sg_gas<=0, tubingID_in<=0, sigma_dyncm<=0, rhoL_lbft3<=0), NA(), LET(tr, t_degF+459.67, z, PO.PVT.Z.ByDAK(p_psia/PO.PVT.Ppc.BySutton(sg_gas), tr/PO.PVT.Tpc.BySutton(sg_gas)), rho_g, PO.PVT.Rho.Gas.ByDefinition(p_psia, tr, sg_gas, z)*62.428, IF(rhoL_lbft3<=rho_g, NA(), 3.06*p_psia*0.72907*sigma_dyncm^0.25*(rhoL_lbft3-rho_g)^0.25/rho_g^0.5*PI()*tubingID_in^2/576/(tr*z))))) | Li critical gas rate to unload liquid (flat-droplet model), MMscf/d: p_psia and t_degF where it is read, gas gravity sg_gas, tubingID_in, the liquid's sigma_dyncm and rhoL_lbft3. Same order as PO.PE.Loading.TurnerRate. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| VLL_SGg | $B$4 | Gas specific gravity (air = 1), sweet gas, air = 1 |
| VLL_TVD | $B$5 | Depth of the perforations, tubing to them (TVD), ft |
| VLL_ID | $B$6 | Tubing inner diameter, in |
| VLL_Rough | $B$7 | Tubing relative roughness, ε/D |
| VLL_Pwh | $B$8 | Flowing wellhead pressure, held by the gathering line, psia |
| VLL_Twh | $B$9 | Flowing wellhead temperature, °F |
| VLL_Tbh | $B$10 | Temperature at the perforations, the reservoir's, °F |
| VLL_RhoL | $B$12 | Liquid density (water), lb/ft³ |
| VLL_IFT | $B$13 | Liquid-gas surface tension (water), dyne/cm |
| VLL_Qg | $B$15 | Gas rate today, the start of the decline, MMscf/d |
| VLL_Di | $B$16 | Nominal decline rate today, Di, 1/yr |
| VLL_b | $B$17 | Arps hyperbolic exponent, b |
| VLL_TurnerF | $B$19 | Turner's upward adjustment on the critical velocity |
| VLL_Lead | $B$20 | Lead time to put a lift on the well, years |
| VLL_Inputs | $B$4:$B$20 | The gas gravity, the tubing, the wellhead pressure and temperatures, the liquid's density and surface tension, the rate today, its Arps decline, Turner's adjustment and the lead time for a lift |
| VLL_Ppc | $B$23 | Gas pseudo-critical pressure (Sutton), psia |
| VLL_Tpc | $B$24 | Gas pseudo-critical temperature (Sutton), °R |
| VLL_Zwh | $B$25 | Z-factor at the wellhead (Dranchuk-Abou-Kassem) |
| VLL_Ugwh | $B$26 | Gas viscosity at the wellhead (Lee-Gonzalez-Eakin), cp |
| VLL_QcWh | $B$28 | Turner, the gas-well sheet's, MMscf/d |
| VLL_QcWhC | $B$29 | Coleman (Turner with factor 1), MMscf/d |
| VLL_QcWhLi | $B$30 | Li, flat droplets, MMscf/d |
| VLL_Pbh | $B$32 | Bottomhole pressure at that rate, psia |
| VLL_QcT | $B$33 | Turner rate, the largest down the tubing, MMscf/d |
| VLL_ZGov | $B$34 | Depth where it is largest, ft |
| VLL_Where | $B$35 | Where the well loads first |
| VLL_QcC | $B$36 | Coleman rate, the largest down the tubing, MMscf/d |
| VLL_QcLi | $B$37 | Li rate, the largest down the tubing, MMscf/d |
| VLL_PbhGov | $B$38 | Bottomhole pressure at that Turner rate, psia |
| VLL_QcBh2 | $B$39 | Turner rate at the bottom at that pressure, MMscf/d |
| VLL_PassErr | $B$40 | Second pass at the bottom against the profile's, % |
| VLL_QRatio | $B$42 | Rate today over the largest Turner rate |
| VLL_tT | $B$43 | Years until it loads by Turner, years |
| VLL_tC | $B$44 | Years until it loads by Coleman, years |
| VLL_tLi | $B$45 | Years until it loads by Li, years |
| VLL_GpT | $B$46 | Gas made before it loads by Turner, Bscf |
| VLL_LoadCheck | $B$47 | Loading check verdict |
| VLL_LoadCheckNote | $C$47 | Loading check comment |
| VLL_LeadCheck | $B$48 | Lead time check verdict |
| VLL_LeadCheckNote | $C$48 | Lead time check comment |
| VLL_PassCheck | $B$49 | Profile check verdict |
| VLL_PassCheckNote | $C$49 | Profile check comment |
| VLL_Results | $B$23:$B$49 | The gas at the wellhead, Turner's, Coleman's and Li's critical rates there and the largest of each down the tubing, the bottom's second pass, the years until the decline reaches each, the gas made before it loads, and the three checks |
| VLL_Profile | $A$57:$I$67 | Ten steps from the wellhead to the perforations at the wellhead Turner rate: the temperature, the pressure in two passes, Z, Turner's, Coleman's and Li's critical rates, and Turner's and Li's critical velocities |
| VLL_Decline | $A$71:$F$91 | Twenty years of the Arps decline from today's rate against the largest Turner, Coleman and Li rates down the tubing, and whether the well unloads |
| VLL_Coleman | $B$94 | Coleman's adjustment: none |
| VLL_Vert | $B$95 | A vertical pipe's angle from horizontal, ° |
| VLL_R0 | $B$96 | Rankine at 0 °F, °R |
| VLL_Scf | $B$97 | scf in an MMscf, scf/MMscf |
| VLL_Sec | $B$98 | Seconds in a day, s/d |
| VLL_DaysYr | $B$99 | Days in a year, d/yr |
| VLL_MMB | $B$100 | MMscf in a Bscf, MMscf/Bscf |
| VLL_Step | $B$101 | Step of the decline table, years |
| VLL_PassTol | $B$102 | Bottom's second pass accepted, % |

---

## Related Blueprints
- [Gas Well Tubing Performance](/blueprint/po.vfp.gas.well.md)
- [Plunger Lift for a Loading Gas Well](/blueprint/po.vfp.plunger.lift.md)
- [Gas Well Tubing Sizing](/blueprint/po.vfp.tubing.sizing.md)
- [Vertical Lift by Beggs and Brill](/blueprint/po.vfp.beggsbrill.verticallift.md)
- [Single-Phase Liquid Injection and the Fracture Limit](/blueprint/po.vfp.liquid.singlephase.md)
- [Multiphase Correlations Compared Against a Gauge](/blueprint/po.vfp.correlations.compare.md)

