---
id: po.wb.ipr.well-productivity-review
title: Well Productivity Review
summary: "Which wells are worth stimulating, ranked by PI, skin and damage ratio, with each one's IPR uplift valued against a type curve."
category: Production
requires:
  - po-addin
  - excel-365
tags:
  - IPR
  - productivity-index
  - skin
  - stimulation
  - multilayer
  - workover
  - economics
---

## Description

Which candidate wells are damaged enough to stimulate, how much oil would removing the damage add, and is the workover worth its cost? You enter the shared rock, fluid and pressures, the completion and each candidate's skin, cost and chance of success. You read off each candidate's pseudosteady-state PI, flow efficiency, damage ratio and ranks, the unscaled composite IPR uplift at a common flowing pressure, and its risked NPV, payout and break-even against a separately modelled type curve. Field units; the candidates are synthetic.

**How to use it:** Replace the synthetic wells and reservoir on the Candidates sheet with measured well data: the shared rock, fluid and pressures, the completion (open interval, its top, kv/kh and perforation skin) and one row per candidate with its skin, cost and chance. Ties in the ranks keep the input order. Check that the uplift does not exceed the candidate's own IPR base. Enter the type curve, prices and fiscal terms on the Economics Inputs sheet, then read each job's value and GO or NO-GO decision on the Value sheet; check that the rate after workover stays within the type curve's initial rate. The Summary collects the results and checks. Use measured well data before making decisions.

**Method:** For each candidate, radial pseudosteady-state PI is k h / [141.2 Bo μo (ln(re/rw) − 0.75 + s)]. Flow efficiency is the ratio of damaged to ideal PI, and damage ratio its reciprocal. The completion skin is split into its damage, partial-penetration and perforation parts; a matrix-treatment PI removes the damage part only, not all completion skin. At the common pressure, the composite IPR uses a straight line above the bubble point and Vogel below; the target-skin rate less the current-skin rate is the **unscaled** uplift. The independent single-phase test pressure is above the bubble point and uses the straight-line IPR. For economics, the uplift declines exponentially over the remaining base life of the type-curve well. Incremental oil earns the shared net margin, with the workover cost, scaled by working interest, in month one. Workover cash is incremental, before income tax, and ends at the base well's economic life; no life extension is assumed. Risked NPV weights the successful cash flow by the chance of success and the cost-only failure by its complement; payout is measured from the workover.

**Example:** The three synthetic candidates are illustrative modifications of the IPR reference well, not field measurements: 0.5 mD, current skins 1, 2 and 3, target skin −2 and 2,000 psi flowing pressure. Their IPR base rates are approximately 90.0, 80.6 and 73.0 STB/d, and unscaled uplifts approximately 48.2, 57.6 and 65.2 STB/d. The separate type-curve well's base is approximately 120.3 STB/d in the first month. These are different hypothetical wells, not a single calibrated production forecast: their coupling is illustrative. Separately labelled references reproduce the IPR reference well's stimulation, horizontal and multilayer examples, keeping its independent 20 mD and skin 5, and the independent workover example that starts with a 60 STB/d uplift.

## Validity

Vertical PI is pseudosteady state; horizontal methods are steady state. The composite IPR assumes Darcy flow above the bubble point and Vogel below. Multilayer shut-in pressure is PI-weighted and may not balance the nonlinear composite rates. The horizontal and layered reference sheets keep their inputs, headline and checks; the detailed method comparisons, per-layer results and curves are in the single-sheet horizontal and multilayer blueprints they come from. The economics assume constant GOR, oil and gas prices and the shared fiscal terms, exponential decline of the incremental rate, end-of-month cash flow, no fixed-LOE change and no income tax. Alternatives: steady-state or transient vertical PI; the Klins or Fetkovich rate for a depleted well instead of the composite model; the single-sheet blueprints for PI, skin sensitivity, horizontal comparison, multilayer and the workover decision.

## References

- Hawkins, M.F. Jr. (1956). “A Note on the Skin Effect.” *Trans. AIME* 207, 356–357.
- Saidikowski, R.M. (1979). “Numerical Simulations of the Combined Effects of Wellbore Damage and Partial Penetration.” SPE-8204.
- Papatzacos, P. (1987). “Approximate Partial-Penetration Pseudoskin for Infinite-Conductivity Wells.” *SPE Reservoir Engineering* 2(2), 227–234.
- Vogel, J.V. (1968). “Inflow Performance Relationships for Solution-Gas Drive Wells.” *JPT* 20(1), 83–92.
- Standing, M.B. (1970). “Inflow Performance Relationships for Damaged Wells Producing by Solution-Gas Drive.” *JPT* 22(11), 1399–1400.

## Inputs

The IPR, Horizontal and Layered Reference sheets carry their own inputs from the IPR reference well.

| Input | Unit | Default | Name |
|---|---|---|---|
| Candidate permeability | mD | 0.5 | `PRA_k` |
| Net pay | ft | 50 | `PRA_h` |
| Oil formation volume factor | bbl/STB | 1.467 | `PRA_Bo` |
| Oil viscosity | cp | 0.302 | `PRA_Uo` |
| Drainage radius | ft | 1490 | `PRA_re` |
| Wellbore radius | ft | 0.354 | `PRA_rw` |
| Reservoir pressure | psi | 4000 | `PRA_Pr` |
| Bubble point pressure | psi | 2620 | `PRA_Pb` |
| Common flowing pressure | psi | 2000 | `PRA_Pwf` |
| Synthetic target skin | — | −2 | `PRA_Target` |
| Single-phase test pressure above Pb | psi | 3000 | `PRA_PwfTest` |
| Open interval | ft | 40 | `PRA_hp` |
| Open interval top below pay top | ft | 0 | `PRA_htop` |
| Vertical over horizontal permeability | — | 0.1 | `PRA_kvkh` |
| Perforation skin | — | 0.5 | `PRA_sp` |
| Candidate skin, A, B, C | — | 1, 2, 3 | `PRA_SkinA`, `PRA_SkinB`, `PRA_SkinC` |
| Candidate cost, A, B, C | $ | 350000, 500000, 1500000 | `PRA_CostA`, `PRA_CostB`, `PRA_CostC` |
| Candidate chance of success, A, B, C | % | 80 | `PRA_PcA`, `PRA_PcB`, `PRA_PcC` |
| Type curve, prices, interests, taxes, operating costs and discount rate | — | see the Economics Inputs sheet | `PRE_LifeCap`, `PRE_IP`, `PRE_b`, `PRE_Dei`, `PRE_Dterm`, `PRE_GOR`, `PRE_TC`, `PRE_Oil`, `PRE_OilDiff`, `PRE_Gas`, `PRE_GasDiff`, `PRE_Esc`, `PRE_WI`, `PRE_NRI`, `PRE_SevOil`, `PRE_SevGas`, `PRE_AdVal`, `PRE_LOE`, `PRE_LOEVar`, `PRE_Gath`, `PRE_Disc` |
| Months the well has produced before the workover | months | 36 | `PRE_Age` |
| Reference workover: incremental oil rate at the start, its effective decline, cost, chance of success | STB/d, 1/yr, $, % | 60, 0.5, 350000, 80 | `PRE_UpliftRef`, `PRE_UpDecl`, `PRE_CostRef`, `PRE_PcRef` |
| Longest acceptable payout, from the workover | months | 12 | `PRE_PayoutMax` |

## Sheets

- `Guide` — what the workbook answers, the order to work through its sheets and the model boundaries.
- `Candidates` — the shared rock, fluid and pressures, the completion inputs, and per candidate the PI, flow efficiency, damage ratio and their ranks, the composite rate and unscaled uplift, the damage skin, treated PI and matrix gain, and the single-phase test rate, with an uplift chart and the checks.
- `IPR Reference` — the independent 20 mD reference well with its skins and five composite IPRs; not a synthetic candidate or a type-curve forecast.
- `Horizontal Reference` — the reference well drilled horizontally, with steady-state PI by several methods and their mean.
- `Layered Reference` — three sands with shared fluid and geometry, the PI-weighted shut-in pressure and the crossflow check at the operating flowing pressure.
- `Economics Inputs` — the separate type-curve well, prices, fiscal terms and the workover inputs, with its decline, life and first-month base rate.
- `Cash Flow` — the monthly oil and net revenue per STB/d of uplift that every job shares.
- `Value` — the 60 STB/d reference and each candidate's uplift, rate after workover, success, failure and risked NPV, payout, PV/I, break-even chance and uplift, and the GO or NO-GO decision.
- `Summary` — the references, the candidate results and every check under one verdict.
- `Test Cases` — the worked example and other cases, with expected and computed results.

## Functions used

`PO.IPR.VW.PSS.PI`, `PO.IPR.VW.PSS.Rate`, `PO.IPR.VW.PSS.Rate.ByVogel`, `PO.IPR.HW.SS.PI.ByBorisov`, `PO.IPR.HW.SS.PI.ByEconomides.Centered`, `PO.IPR.HW.SS.PI.ByGRJ`, `PO.IPR.HW.SS.PI.ByJoshi`, `PO.IPR.HW.SS.PI.ByRenardDupuy`, and the catalog LAMBDAs `PO.CO.Damage.Decomposition`, `PO.CO.Damage.Hawkins`, `PO.ECON.NPV.Monthly` and `PO.ECON.Payout`. The alternatives under Validity: `PO.IPR.VW.SS.PI`, `PO.IPR.VW.TF.PI`, `PO.IPR.VW.PSS.Rate.ByKlins` and `PO.IPR.VW.PSS.Rate.ByFetkovich`.
