---
cid: po.bp.well-perf.lift.selection
hub: well-perf
tags: [artificial-lift, lift-selection, screening, ESP, gas-lift, rod-pump, PCP, plunger-lift, jet-pump]
facets: { discipline: production, method-type: empirical }
title: Artificial Lift Method Screening
summary: "Ranks ESP, gas lift, rod pump, PCP, plunger lift and jet pump for a well against published operating ranges."
slug: po.well-perf.lift.selection
type: worksheet
---

# Artificial Lift Method Screening

## Description

Which lift methods suit this well, and in what order? You enter the well's liquid rate, lift depth, temperature, deviation, gas-liquid ratio and sand, and the power at the well. You read off a score for each of six methods, ESP, gas lift, rod pump, progressing cavity pump (PCP), plunger lift and jet pump, against published typical and maximum operating ranges, which methods are ruled out, and a ranked shortlist of three with the reasons; a chart draws the scores.

**Parameters:**
- **Well**:
  - the liquid rate `LS_Q` (STB/d);
  - the lift depth `LS_D` (ft TVD);
  - the temperature `LS_T` (°F) and deviation `LS_Dev` (°) there;
  - the producing GLR `LS_GLR` (scf/bbl);
  - the sand `LS_Sand` (0 none, 1 some, 2 severe).
- **Power**: electricity at the well `LS_Elec` and gas at the well `LS_Gas` (1 yes, 0 no). The gas is for lift gas or for engines.
- **Gas grading**: the GLRs from which free gas troubles a pump (`LS_GlrSome`) and is severe (`LS_GlrSevere`). These are the sheet's own assumption.
- **Ranges**: the table of each method's limits, with its source. Type your vendors' over it.

**How to use it:** take the rate and GLR from a test at the rate you want to lift, and the depth and deviation from the survey. Then type your vendors' ranges over the table, and grade the gas against the separator you would fit. The limits come from a published table of each method's typical and maximum operating ranges: Weatherford's comparison, as reproduced, cross-checked against IPIECA's 2023 table. The sheet names the source of every limit beside it. A criterion scores 2 inside the typical range and 1 past it but inside the maximum, where the vendor must make a special analysis. It scores 0 past the maximum, which rules the method out. Gas and sand are scored from the method's handling grade against how much the well makes. The methods that survive are ranked by total score, the system efficiency breaking a tie. Two checks read the shortlist and the first's lead over the second.

**Method:**

*The four range criteria.*
- **Rate:** 2 inside the typical low-to-high range, 1 outside it but under the maximum, and 0 over the maximum.
- **Depth, temperature and deviation:** 2 at or under the typical limit, 1 at or under the maximum, and 0 over it.

*Gas.* The well's GLR is graded 0 under the GLR from which free gas troubles a pump, 1 from there, and 2 from the GLR at which it is severe. A method then scores MIN(2, MAX(0, its gas grade − the well's grade)), or 2 when the well's grade is 0. The method grades run 1 poor, 2 fair, 3 good and 4 excellent; "poor to fair" is 1.5. Plunger lift also needs 300 scf/bbl per 1,000 ft of depth (Weatherford), and scores 0 without it.

*Sand.* The same rule on the solids grade, against the well's sand grade.

*Power.* A method that needs nothing (plunger lift, on the well's own gas) scores 2. Otherwise it scores 2 when what it needs is at the well and 0 when not:
- electricity for the ESP;
- lift gas for gas lift;
- either for the rod pump, PCP and jet pump, whose prime movers are gas engines or electric motors.

*Ranking.* A method with any 0 is out. The rest rank by their total plus a tenth of the middle of their system-efficiency range, so a tie goes to the more efficient method, then to the method listed first. The reasons list the criteria that rule a method out, or those past their typical range.

**Example:** The default well is the ESP sizing sheet's: 1,600 STB/d of liquid from mid-perforations at 7,500 ft, 180 °F, vertical, no sand, with electricity and gas at the well. The sizing sheet carries no gas, so a GLR of 300 scf/bbl is assumed here; that is 40 % water cut with a 500 scf/STB GOR. At 1,600 STB/d, 7,500 ft and 180 °F:

- **ESP** sits inside every typical range: 200–20,000 BPD, 10,000 ft, 275 °F. It scores 14 of 14.
- **Gas lift** does too, with 14.
- **Rod pump** scores 13: 1,600 STB/d is past its typical 1,500 but under its 5,000 maximum.
- **Jet pump** scores 13 too: 1,600 STB/d is past its typical 300–1,000.
- **PCP** is out on depth: 7,500 ft is past its 6,000 ft maximum.
- **Plunger lift** is out on rate (over 200 BPD) and on GLR (300 against the 2,250 scf/bbl it needs at 7,500 ft).

The ESP and gas lift tie on 14. The ESP's middle efficiency of 47.5 % against gas lift's 20 % puts it first, then gas lift, then the rod pump: 13 plus 52.5 % beats the jet pump's 13 plus 20 %. With the first two tied, size both.

## Validity

A screen, not a design. It rules methods out and orders the rest, but it doesn't size them, price them or weigh how the well changes over its life. Size the shortlist on the ESP, gas-lift and rod-pump sheets, then compare power and cost.

**The ranges** are typical industry figures, and every vendor's differ:
- The table is Weatherford Artificial Lift Systems' comparison chart, as reproduced in a public slide deck; PetroWiki says its depth-rate charts derive from that presentation. It was cross-checked against IPIECA (2023), whose own table cites Clegg (2007), Brown (1980–84) and Guo et al. (2007).
- **Where the two disagree, the sheet takes Weatherford's and names IPIECA's beside it.** On plunger lift, IPIECA gives a depth under 5,000 ft and a maximum deviation of 30–50°, against Weatherford's 19,000 ft and 80°. IPIECA's ESP rate reaches 150,000 BPD.
- **No typical deviation.** Weatherford gives none for the PCP or plunger lift, so their maximum is used for both.

**The sheet's own assumptions**, not published values: the gas and sand grades and how they are scored, the GLR grade thresholds, the power rules and the efficiency tie-break. Clegg, Bucaram and Hein (1993) and Brown (1982) are the classic qualitative comparisons behind such tables; neither paper was to hand, and no value here is taken from them.

Hydraulic piston pumps, capillary strings, foam and velocity strings are not screened.

Named alternatives: Clegg et al.'s design-and-operating-feature comparison, for the qualitative factors this sheet leaves out (workover, automation, offshore); a decision tree on expert rules (Heinze, Winkler and Lea); life-cycle economics on the shortlist; and the Plunger Lift for a Loading Gas Well sheet for a gas well's plunger.

## References

- Weatherford Artificial Lift Systems. *Artificial Lift Systems Comparison* (typical and maximum operating ranges by method), as reproduced in "Artificial Lift Technology", slideshare.net/josepazv/artificial-lift-technology.
- IPIECA (2023). "Artificial lift." *Compendium of energy and GHG efficient technologies and practices*, Upstream, last reviewed June 2023.
- Clegg, J.D., Bucaram, S.M. and Hein, N.W. Jr. (1993). "Recommendations and Comparisons for Selecting Artificial-Lift Methods." *JPT* 45(12), 1128–1167. SPE-24834-PA.
- Brown, K.E. (1982). "Overview of Artificial Lift Systems." *JPT* 34(10). SPE-9979-PA.
- Lea, J.F. and Nickens, H.V. (1999). "Selection of Artificial Lift." SPE 52157, SPE Mid-Continent Operations Symposium.

## Functions used

None: the sheet uses only Excel's built-in functions.

## Spreadsheet: LiftSelection

|    | A                                                                                                                                                               | B                                                                       | C                                                                                                                                                                                                                                                                                                                                 | D                                 | E                                     | F                                                                             | G                                          | H                                                                         | I               | J             | K                        | L                                                            | M                | N                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | O              | P                                                                                |
|----|-----------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------|---------------------------------------|-------------------------------------------------------------------------------|--------------------------------------------|---------------------------------------------------------------------------|-----------------|---------------|--------------------------|--------------------------------------------------------------|------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------|----------------------------------------------------------------------------------|
| 1  | Artificial Lift Method Screening                                                                                                                                |                                                                         | Petroleum Office                                                                                                                                                                                                                                                                                                                  |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 2  | Blue cells on yellow are inputs. Type the well; six lift methods are scored against published operating ranges, and the best three are ranked with the reasons. |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 3  | The Well (the ESP Sizing Sheet's)                                                                                                                               |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 4  | Liquid rate to lift                                                                                                                                             | 1600                                                                    | STB/d                                                                                                                                                                                                                                                                                                                             |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 5  | Lift depth, the mid-perforations (TVD)                                                                                                                          | 7500                                                                    | ft                                                                                                                                                                                                                                                                                                                                |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 6  | Temperature at the lift depth                                                                                                                                   | 180                                                                     | °F                                                                                                                                                                                                                                                                                                                                |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 7  | Deviation at the lift depth                                                                                                                                     | 0                                                                       | °                                                                                                                                                                                                                                                                                                                                 |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 8  | Producing gas-liquid ratio                                                                                                                                      | 300                                                                     | scf/bbl                                                                                                                                                                                                                                                                                                                           |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 9  | Sand produced: 0 none, 1 some, 2 severe                                                                                                                         | 0                                                                       | —                                                                                                                                                                                                                                                                                                                                 |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 10 | Power at the Well                                                                                                                                               |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 11 | Electricity at the well: 1 yes, 0 no                                                                                                                            | 1                                                                       | —                                                                                                                                                                                                                                                                                                                                 |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 12 | Gas at the well, for lift gas or engines: 1 yes, 0 no                                                                                                           | 1                                                                       | —                                                                                                                                                                                                                                                                                                                                 |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 13 | How the Gas-Liquid Ratio Is Graded (the Sheet's Own Assumption)                                                                                                 |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 14 | GLR from which free gas troubles a pump                                                                                                                         | 500                                                                     | scf/bbl                                                                                                                                                                                                                                                                                                                           |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 15 | GLR from which it is severe                                                                                                                                     | 2000                                                                    | scf/bbl                                                                                                                                                                                                                                                                                                                           |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 18 | Operating Ranges by Method (Weatherford's Comparison as Reproduced)                                                                                             |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 19 | Typical and maximum ranges; past a typical range needs special analysis, past a maximum rules the method out. Grades run 1 poor to 4 excellent.                 |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 20 | Power: 0 none (the well's own gas), 1 electricity, 2 lift gas, 3 either. Plunger lift needs 300 scf/bbl per 1,000 ft. Type your vendor's limits over these.     |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 21 | Method                                                                                                                                                          | Rate low (STB/d)                                                        | Rate high (STB/d)                                                                                                                                                                                                                                                                                                                 | Rate max (STB/d)                  | Depth typical (ft)                    | Depth max (ft)                                                                | Temp typical (°F)                          | Temp max (°F)                                                             | Dev typical (°) | Dev max (°)   | GLR per kft (scf/bbl)    | Gas grade                                                    | Solids grade     | Power                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Efficiency (%) | Source                                                                           |
| 22 | ESP                                                                                                                                                             | 200                                                                     | 20000                                                                                                                                                                                                                                                                                                                             | 30000                             | 10000                                 | 15000                                                                         | 275                                        | 400                                                                       | 10              | 90            | 0                        | 1.5                                                          | 1.5              | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0.475          | Weatherford; IPIECA gives 50-150,000 BPD, 15,000 ft, 550 °F                      |
| 23 | Gas lift                                                                                                                                                        | 100                                                                     | 10000                                                                                                                                                                                                                                                                                                                             | 30000                             | 10000                                 | 15000                                                                         | 250                                        | 400                                                                       | 50              | 70            | 0                        | 4                                                            | 3                | 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0.2            | Weatherford; IPIECA gives up to 80,000 BPD, 350 °F                               |
| 24 | Rod pump                                                                                                                                                        | 5                                                                       | 1500                                                                                                                                                                                                                                                                                                                              | 5000                              | 11000                                 | 16000                                                                         | 350                                        | 550                                                                       | 20              | 90            | 0                        | 2.5                                                          | 2.5              | 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0.525          | Weatherford; IPIECA gives 10,000 ft, 70-85° max                                  |
| 25 | PCP                                                                                                                                                             | 5                                                                       | 2200                                                                                                                                                                                                                                                                                                                              | 4500                              | 4500                                  | 6000                                                                          | 150                                        | 250                                                                       | 90              | 90            | 0                        | 3                                                            | 4                | 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0.55           | Weatherford, no typical deviation given; IPIECA gives 9,000 ft, 185 °F           |
| 26 | Plunger lift                                                                                                                                                    | 1                                                                       | 5                                                                                                                                                                                                                                                                                                                                 | 200                               | 8000                                  | 19000                                                                         | 120                                        | 500                                                                       | 80              | 80            | 300                      | 4                                                            | 1.5              | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0              | Weatherford, no typical deviation given; IPIECA gives under 5,000 ft, 30-50° max |
| 27 | Jet pump                                                                                                                                                        | 300                                                                     | 1000                                                                                                                                                                                                                                                                                                                              | 15000                             | 10000                                 | 15000                                                                         | 250                                        | 500                                                                       | 20              | 90            | 0                        | 3                                                            | 3                | 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0.2            | Weatherford; IPIECA gives 25-4,000 BPD, 250 °F, 40-70° max                       |
| 30 | The Well's Gas, Graded                                                                                                                                          |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 31 | Gas grade: 0 low, 1 some, 2 severe                                                                                                                              | =IF(LS_GLR>=LS_GlrSevere,2,IF(LS_GLR>=LS_GlrSome,1,0))                  | —                                                                                                                                                                                                                                                                                                                                 |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 32 | GLR plunger lift needs at this depth (300 per 1,000 ft)                                                                                                         | =MAX(K22:K27)*LS_D/1000                                                 | scf/bbl                                                                                                                                                                                                                                                                                                                           |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 33 | Shortlist                                                                                                                                                       |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 34 | Methods inside every maximum range                                                                                                                              | =COUNT(LS_Ranks)                                                        | —                                                                                                                                                                                                                                                                                                                                 |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 35 | First                                                                                                                                                           | =""&IFERROR(INDEX(LS_Methods,MATCH(1,LS_Ranks,0)),"none")               |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 36 | Its score                                                                                                                                                       | =IFERROR(INDEX(LS_Totals,MATCH(1,LS_Ranks,0)),0)                        | points                                                                                                                                                                                                                                                                                                                            |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 37 | Its lowest criterion score                                                                                                                                      | =IFERROR(INDEX(LS_Lowest,MATCH(1,LS_Ranks,0)),0)                        | points                                                                                                                                                                                                                                                                                                                            |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 38 | Why                                                                                                                                                             | =""&IFERROR(INDEX(LS_Reasons,MATCH(1,LS_Ranks,0)),"")                   |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 39 | Second                                                                                                                                                          | =""&IFERROR(INDEX(LS_Methods,MATCH(2,LS_Ranks,0)),"none")               |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 40 | Its score                                                                                                                                                       | =IFERROR(INDEX(LS_Totals,MATCH(2,LS_Ranks,0)),0)                        | points                                                                                                                                                                                                                                                                                                                            |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 41 | Why                                                                                                                                                             | =""&IFERROR(INDEX(LS_Reasons,MATCH(2,LS_Ranks,0)),"")                   |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 42 | Third                                                                                                                                                           | =""&IFERROR(INDEX(LS_Methods,MATCH(LS_Rank3,LS_Ranks,0)),"none")        |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 43 | Its score                                                                                                                                                       | =IFERROR(INDEX(LS_Totals,MATCH(LS_Rank3,LS_Ranks,0)),0)                 | points                                                                                                                                                                                                                                                                                                                            |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 44 | Why                                                                                                                                                             | =""&IFERROR(INDEX(LS_Reasons,MATCH(LS_Rank3,LS_Ranks,0)),"")            |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 45 | First's lead over the second                                                                                                                                    | =LS_FirstScore-LS_SecondScore                                           | points                                                                                                                                                                                                                                                                                                                            |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 46 | Shortlist check                                                                                                                                                 | =IF(LS_Count=0,"FAIL",IF(LS_FirstLowest<2,"WARN","PASS"))               | =IF(LS_Count=0,"no method fits this well inside its maximum ranges; check the depth and the rate",IF(LS_FirstLowest<2,""&LS_First&" leads but is past its typical range on some criteria; ask the vendor for a special analysis",""&LS_First&" fits every criterion inside its typical range; then "&LS_Second&" and "&LS_Third)) |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 47 | Lead check                                                                                                                                                      | =IF(LS_Count<2,"WARN",IF(LS_Lead=0,"WARN",IF(LS_Lead<1,"WARN","PASS"))) | =IF(LS_Count<2,"one method or none fits; nothing to compare",IF(LS_Lead=0,""&LS_First&" and "&LS_Second&" tie on score; efficiency breaks it: size both",IF(LS_Lead<1,""&LS_First&" leads "&LS_Second&" by half a point: size both",""&LS_First&" leads "&LS_Second&" by a point or more")))                                      |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 49 | How to use it: the rate and GLR from a test at the rate you want, the depth and deviation from the survey, and your vendors' ranges over the table.             |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 50 | A screen, not a design: size the shortlist on the ESP, gas-lift and rod-pump sheets, then compare power and cost.                                               |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 52 | Scores: 2 Typical, 1 Past Typical, 0 Past the Maximum (Ruled Out)                                                                                               |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 53 | The rank key is the total plus a tenth of the efficiency, so a tie goes to the more efficient method; then to the upper row.                                    |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 54 | Method                                                                                                                                                          | Rate                                                                    | Depth                                                                                                                                                                                                                                                                                                                             | Temperature                       | Deviation                             | GLR                                                                           | Sand                                       | Power                                                                     | Total           | Lowest        | Rank key                 | Rank                                                         | Chart score      | Reasons                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                |                                                                                  |
| 55 | =A22                                                                                                                                                            | =IF(LS_Q>D22,0,IF(AND(LS_Q>=B22,LS_Q<=C22),2,1))                        | =IF(LS_D>F22,0,IF(LS_D<=E22,2,1))                                                                                                                                                                                                                                                                                                 | =IF(LS_T>H22,0,IF(LS_T<=G22,2,1)) | =IF(LS_Dev>J22,0,IF(LS_Dev<=I22,2,1)) | =IF(LS_GLR<K22*LS_D/1000,0,IF(LS_GasGrade=0,2,MIN(2,MAX(0,L22-LS_GasGrade)))) | =IF(LS_Sand=0,2,MIN(2,MAX(0,M22-LS_Sand))) | =IF(N22=0,2,IF(N22=1,2*LS_Elec,IF(N22=2,2*LS_Gas,2*MAX(LS_Elec,LS_Gas)))) | =SUM(B55:H55)   | =MIN(B55:H55) | =IF(J55=0,-1,I55+O22/10) | =IF(K55<0,"",COUNTIF(K55:K60,">"&K55)+COUNTIF(K$55:K55,K55)) | =IF(K55<0,0,I55) | =IF(J55=0,"Out on "&SUBSTITUTE(TRIM(IF(B55=0,"rate ","")&IF(C55=0,"depth ","")&IF(D55=0,"temperature ","")&IF(E55=0,"deviation ","")&IF(F55=0,"GLR ","")&IF(G55=0,"sand ","")&IF(H55=0,"power ",""))," ",", "),IF(J55=2,"Inside every typical range","Past typical on "&SUBSTITUTE(TRIM(IF(B55<2,"rate ","")&IF(C55<2,"depth ","")&IF(D55<2,"temperature ","")&IF(E55<2,"deviation ","")&IF(F55<2,"GLR ","")&IF(G55<2,"sand ","")&IF(H55<2,"power ",""))," ",", "))) |                |                                                                                  |
| 56 | =A23                                                                                                                                                            | =IF(LS_Q>D23,0,IF(AND(LS_Q>=B23,LS_Q<=C23),2,1))                        | =IF(LS_D>F23,0,IF(LS_D<=E23,2,1))                                                                                                                                                                                                                                                                                                 | =IF(LS_T>H23,0,IF(LS_T<=G23,2,1)) | =IF(LS_Dev>J23,0,IF(LS_Dev<=I23,2,1)) | =IF(LS_GLR<K23*LS_D/1000,0,IF(LS_GasGrade=0,2,MIN(2,MAX(0,L23-LS_GasGrade)))) | =IF(LS_Sand=0,2,MIN(2,MAX(0,M23-LS_Sand))) | =IF(N23=0,2,IF(N23=1,2*LS_Elec,IF(N23=2,2*LS_Gas,2*MAX(LS_Elec,LS_Gas)))) | =SUM(B56:H56)   | =MIN(B56:H56) | =IF(J56=0,-1,I56+O23/10) | =IF(K56<0,"",COUNTIF(K55:K60,">"&K56)+COUNTIF(K$55:K56,K56)) | =IF(K56<0,0,I56) | =IF(J56=0,"Out on "&SUBSTITUTE(TRIM(IF(B56=0,"rate ","")&IF(C56=0,"depth ","")&IF(D56=0,"temperature ","")&IF(E56=0,"deviation ","")&IF(F56=0,"GLR ","")&IF(G56=0,"sand ","")&IF(H56=0,"power ",""))," ",", "),IF(J56=2,"Inside every typical range","Past typical on "&SUBSTITUTE(TRIM(IF(B56<2,"rate ","")&IF(C56<2,"depth ","")&IF(D56<2,"temperature ","")&IF(E56<2,"deviation ","")&IF(F56<2,"GLR ","")&IF(G56<2,"sand ","")&IF(H56<2,"power ",""))," ",", "))) |                |                                                                                  |
| 57 | =A24                                                                                                                                                            | =IF(LS_Q>D24,0,IF(AND(LS_Q>=B24,LS_Q<=C24),2,1))                        | =IF(LS_D>F24,0,IF(LS_D<=E24,2,1))                                                                                                                                                                                                                                                                                                 | =IF(LS_T>H24,0,IF(LS_T<=G24,2,1)) | =IF(LS_Dev>J24,0,IF(LS_Dev<=I24,2,1)) | =IF(LS_GLR<K24*LS_D/1000,0,IF(LS_GasGrade=0,2,MIN(2,MAX(0,L24-LS_GasGrade)))) | =IF(LS_Sand=0,2,MIN(2,MAX(0,M24-LS_Sand))) | =IF(N24=0,2,IF(N24=1,2*LS_Elec,IF(N24=2,2*LS_Gas,2*MAX(LS_Elec,LS_Gas)))) | =SUM(B57:H57)   | =MIN(B57:H57) | =IF(J57=0,-1,I57+O24/10) | =IF(K57<0,"",COUNTIF(K55:K60,">"&K57)+COUNTIF(K$55:K57,K57)) | =IF(K57<0,0,I57) | =IF(J57=0,"Out on "&SUBSTITUTE(TRIM(IF(B57=0,"rate ","")&IF(C57=0,"depth ","")&IF(D57=0,"temperature ","")&IF(E57=0,"deviation ","")&IF(F57=0,"GLR ","")&IF(G57=0,"sand ","")&IF(H57=0,"power ",""))," ",", "),IF(J57=2,"Inside every typical range","Past typical on "&SUBSTITUTE(TRIM(IF(B57<2,"rate ","")&IF(C57<2,"depth ","")&IF(D57<2,"temperature ","")&IF(E57<2,"deviation ","")&IF(F57<2,"GLR ","")&IF(G57<2,"sand ","")&IF(H57<2,"power ",""))," ",", "))) |                |                                                                                  |
| 58 | =A25                                                                                                                                                            | =IF(LS_Q>D25,0,IF(AND(LS_Q>=B25,LS_Q<=C25),2,1))                        | =IF(LS_D>F25,0,IF(LS_D<=E25,2,1))                                                                                                                                                                                                                                                                                                 | =IF(LS_T>H25,0,IF(LS_T<=G25,2,1)) | =IF(LS_Dev>J25,0,IF(LS_Dev<=I25,2,1)) | =IF(LS_GLR<K25*LS_D/1000,0,IF(LS_GasGrade=0,2,MIN(2,MAX(0,L25-LS_GasGrade)))) | =IF(LS_Sand=0,2,MIN(2,MAX(0,M25-LS_Sand))) | =IF(N25=0,2,IF(N25=1,2*LS_Elec,IF(N25=2,2*LS_Gas,2*MAX(LS_Elec,LS_Gas)))) | =SUM(B58:H58)   | =MIN(B58:H58) | =IF(J58=0,-1,I58+O25/10) | =IF(K58<0,"",COUNTIF(K55:K60,">"&K58)+COUNTIF(K$55:K58,K58)) | =IF(K58<0,0,I58) | =IF(J58=0,"Out on "&SUBSTITUTE(TRIM(IF(B58=0,"rate ","")&IF(C58=0,"depth ","")&IF(D58=0,"temperature ","")&IF(E58=0,"deviation ","")&IF(F58=0,"GLR ","")&IF(G58=0,"sand ","")&IF(H58=0,"power ",""))," ",", "),IF(J58=2,"Inside every typical range","Past typical on "&SUBSTITUTE(TRIM(IF(B58<2,"rate ","")&IF(C58<2,"depth ","")&IF(D58<2,"temperature ","")&IF(E58<2,"deviation ","")&IF(F58<2,"GLR ","")&IF(G58<2,"sand ","")&IF(H58<2,"power ",""))," ",", "))) |                |                                                                                  |
| 59 | =A26                                                                                                                                                            | =IF(LS_Q>D26,0,IF(AND(LS_Q>=B26,LS_Q<=C26),2,1))                        | =IF(LS_D>F26,0,IF(LS_D<=E26,2,1))                                                                                                                                                                                                                                                                                                 | =IF(LS_T>H26,0,IF(LS_T<=G26,2,1)) | =IF(LS_Dev>J26,0,IF(LS_Dev<=I26,2,1)) | =IF(LS_GLR<K26*LS_D/1000,0,IF(LS_GasGrade=0,2,MIN(2,MAX(0,L26-LS_GasGrade)))) | =IF(LS_Sand=0,2,MIN(2,MAX(0,M26-LS_Sand))) | =IF(N26=0,2,IF(N26=1,2*LS_Elec,IF(N26=2,2*LS_Gas,2*MAX(LS_Elec,LS_Gas)))) | =SUM(B59:H59)   | =MIN(B59:H59) | =IF(J59=0,-1,I59+O26/10) | =IF(K59<0,"",COUNTIF(K55:K60,">"&K59)+COUNTIF(K$55:K59,K59)) | =IF(K59<0,0,I59) | =IF(J59=0,"Out on "&SUBSTITUTE(TRIM(IF(B59=0,"rate ","")&IF(C59=0,"depth ","")&IF(D59=0,"temperature ","")&IF(E59=0,"deviation ","")&IF(F59=0,"GLR ","")&IF(G59=0,"sand ","")&IF(H59=0,"power ",""))," ",", "),IF(J59=2,"Inside every typical range","Past typical on "&SUBSTITUTE(TRIM(IF(B59<2,"rate ","")&IF(C59<2,"depth ","")&IF(D59<2,"temperature ","")&IF(E59<2,"deviation ","")&IF(F59<2,"GLR ","")&IF(G59<2,"sand ","")&IF(H59<2,"power ",""))," ",", "))) |                |                                                                                  |
| 60 | =A27                                                                                                                                                            | =IF(LS_Q>D27,0,IF(AND(LS_Q>=B27,LS_Q<=C27),2,1))                        | =IF(LS_D>F27,0,IF(LS_D<=E27,2,1))                                                                                                                                                                                                                                                                                                 | =IF(LS_T>H27,0,IF(LS_T<=G27,2,1)) | =IF(LS_Dev>J27,0,IF(LS_Dev<=I27,2,1)) | =IF(LS_GLR<K27*LS_D/1000,0,IF(LS_GasGrade=0,2,MIN(2,MAX(0,L27-LS_GasGrade)))) | =IF(LS_Sand=0,2,MIN(2,MAX(0,M27-LS_Sand))) | =IF(N27=0,2,IF(N27=1,2*LS_Elec,IF(N27=2,2*LS_Gas,2*MAX(LS_Elec,LS_Gas)))) | =SUM(B60:H60)   | =MIN(B60:H60) | =IF(J60=0,-1,I60+O27/10) | =IF(K60<0,"",COUNTIF(K55:K60,">"&K60)+COUNTIF(K$55:K60,K60)) | =IF(K60<0,0,I60) | =IF(J60=0,"Out on "&SUBSTITUTE(TRIM(IF(B60=0,"rate ","")&IF(C60=0,"depth ","")&IF(D60=0,"temperature ","")&IF(E60=0,"deviation ","")&IF(F60=0,"GLR ","")&IF(G60=0,"sand ","")&IF(H60=0,"power ",""))," ",", "),IF(J60=2,"Inside every typical range","Past typical on "&SUBSTITUTE(TRIM(IF(B60<2,"rate ","")&IF(C60<2,"depth ","")&IF(D60<2,"temperature ","")&IF(E60<2,"deviation ","")&IF(F60<2,"GLR ","")&IF(G60<2,"sand ","")&IF(H60<2,"power ",""))," ",", "))) |                |                                                                                  |
| 62 | Constants                                                                                                                                                       |                                                                         |                                                                                                                                                                                                                                                                                                                                   |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |
| 63 | Third place on the shortlist                                                                                                                                    | 3                                                                       | —                                                                                                                                                                                                                                                                                                                                 |                                   |                                       |                                                                               |                                            |                                                                           |                 |               |                          |                                                              |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                |                                                                                  |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| LS_Q | $B$4 | Liquid rate to lift, STB/d |
| LS_D | $B$5 | Lift depth, the mid-perforations (TVD), ft |
| LS_T | $B$6 | Temperature at the lift depth, °F |
| LS_Dev | $B$7 | Deviation at the lift depth, ° |
| LS_GLR | $B$8 | Producing gas-liquid ratio, scf/bbl |
| LS_Sand | $B$9 | Sand produced: 0 none, 1 some, 2 severe |
| LS_Elec | $B$11 | Electricity at the well: 1 yes, 0 no |
| LS_Gas | $B$12 | Gas at the well, for lift gas or engines: 1 yes, 0 no |
| LS_GlrSome | $B$14 | GLR from which free gas troubles a pump, scf/bbl |
| LS_GlrSevere | $B$15 | GLR from which it is severe, scf/bbl |
| LS_Inputs | $B$4:$B$15 | The well's rate, lift depth, temperature, deviation, gas-liquid ratio and sand, the power at the well, and the GLR grades |
| LS_Limits | $A$22:$P$27 | Each method's typical and maximum rate, depth, temperature and deviation, the GLR it needs, its gas and solids grades, the power it needs, its efficiency and the source |
| LS_Methods | $A$22:$A$27 | The lift methods screened |
| LS_Scores | $A$55:$N$60 | Each method's score on the seven criteria, its total and lowest score, the rank key with the efficiency tie-break, its rank, and the reasons |
| LS_Ranks | $L$55:$L$60 | Each method's rank, blank when ruled out |
| LS_Totals | $I$55:$I$60 | Each method's total score |
| LS_Lowest | $J$55:$J$60 | Each method's lowest criterion score |
| LS_Reasons | $N$55:$N$60 | Each method's reasons |
| LS_GasGrade | $B$31 | Gas grade: 0 low, 1 some, 2 severe |
| LS_GlrPlunger | $B$32 | GLR plunger lift needs at this depth (300 per 1,000 ft), scf/bbl |
| LS_Count | $B$34 | Methods inside every maximum range |
| LS_First | $B$35 | First |
| LS_FirstScore | $B$36 | Its score, points |
| LS_FirstLowest | $B$37 | Its lowest criterion score, points |
| LS_FirstWhy | $B$38 | Why |
| LS_Second | $B$39 | Second |
| LS_SecondScore | $B$40 | Its score, points |
| LS_SecondWhy | $B$41 | Why |
| LS_Third | $B$42 | Third |
| LS_ThirdScore | $B$43 | Its score, points |
| LS_ThirdWhy | $B$44 | Why |
| LS_Lead | $B$45 | First's lead over the second, points |
| LS_ShortlistCheck | $B$46 | Shortlist check verdict |
| LS_ShortlistCheckNote | $C$46 | Shortlist check comment |
| LS_LeadCheck | $B$47 | Lead check verdict |
| LS_LeadCheckNote | $C$47 | Lead check comment |
| LS_Results | $B$31:$B$47 | The gas grade, the GLR plunger lift needs, the number of methods that fit, the first three with their scores and reasons, the first's lead, and the checks |
| LS_Rank3 | $B$63 | Third place on the shortlist |

---

## Related Blueprints
- [Water-Oil Ratio Diagnostics](/blueprint/po.dca.wor.diagnostics.md)
- [Decline Model Comparison](/blueprint/po.dca.models.compare.md)
- [Plunger Lift for a Loading Gas Well](/blueprint/po.vfp.plunger.lift.md)
- [Rod Pump System Design](/blueprint/po.rp.system.design.md)
- [Integrated Flow Assurance Screen](/blueprint/po.fa.integrated.assessment.md)
- [Arps Decline Forecast](/blueprint/po.dca.arps.forecast.md)

