---
id: po.wb.dca.production-surveillance
title: Production Surveillance
summary: "Whether an oil well's rate, GOR, WOR or productivity index has moved off trend enough to review, beside decline, WOR, inflow and loading references."
category: Production
requires:
  - po-addin
  - excel-365
tags:
  - production
  - surveillance
  - decline-curve-analysis
  - productivity-index
  - wor
  - liquid-loading
---

## Description

Has this oil well's rate fallen below its decline, or its gas-oil ratio (GOR), water-oil ratio (WOR) or observed productivity index (PI) moved enough to look into? You enter monthly oil rates, four well tests and your screening limits. You read off an exponential decline fit, each trend against its limit and the candidate reason, beside four independent references: an Arps forecast, a waterflood producer's WOR, vertical oil inflow and gas-well loading. **These synthetic examples are not a matched field.**

**How to use it:** Replace the yellow inputs and synthetic observations with consistent measurements. On the Well trends sheet, calculate oil rate from produced volume and producing days, checking allocation and downtime; enter the true first producing month (1–7 in this layout), all required rates, and the four tests' GOR, water cut and reservoir and flowing pressures. Invalid tests or first months fail the data check; calculation-safe substitute rates are not results. For PI, use representative reservoir and stabilized flowing pressures above the bubble point with positive drawdown. Each reference sheet has its own inputs; changing one does not change the others. Gas loading is not inferred from the oil well's GOR. The Summary combines the candidate reasons and every check for review, not automatic intervention.

**Method:** Well trends uses A-3's 30 synthetic type-well oil rates and month-30 GOR and water cut. The tests at the selected first month and months 12, 21 and 30, the fluid trajectories, the pressures and the imposed month-30 rate loss are invented; yellow rate and test formulas are editable, and pressures depend on rates. A log-rate fit to the first 24 producing months gives an exponential Arps baseline (b = 0) with nonnegative decline. The latest rate is compared with the fit, and GOR, WOR and observed PI with the first test. WOR = water cut / (1 - water cut); PI = oil rate / pressure drawdown. Thresholds are screening choices, not diagnostic limits.

The Arps reference is an independent decline example. The DWS waterflood reference uses Chan's derivative and extrapolates log WOR to an economic limit at constant liquid rate and costs. The separate single-phase inflow model computes PI, the skin split and the potential gain on damage removal, not A-3's observed PI. The independent gas example compares Turner, Coleman and Li critical rates along the tubing and against gas decline.

**Example:** With the independent reference defaults (the WOR trend from month 12 and the Arps reference's nominal decline of 1.89 per year), the 24-month WOR history gives an economic cumulative oil of approximately 3,287,690.6 STB, while the separate Arps reference gives an EUR of approximately 720.162 MSTB. These are synthetic reference results, not a forecast for A-3.

## Validity

Illustrative pressures exceed the 2620 psi bubble point; test conditions and pressure uncertainty can mimic a PI trend. The exponential fit screens, it does not forecast reserves; fit representative production and investigate outliers. A rate, GOR, WOR or PI flag does not prove a cause. Chan signatures are empirical and WOR extrapolation may not persist. Inflow assumes single-phase pseudosteady radial flow; skin decomposition does not prove treatment response. Loading assumes the entered water properties, fixed wellhead pressure and Arps decline; confirm with a stabilized gas test and flowing gradient. Review uncertainty and economics before action.

## References

- Arps, J.J. (1945). Analysis of Decline Curves. *Transactions of the AIME*, 160, 228-247.
- Chan, K.S. (1995). Water Control Diagnostic Plots. SPE 30775.
- Turner, R.G., Hubbard, M.G. and Dukler, A.E. (1969). Analysis and Prediction of Minimum Flow Rate for the Continuous Removal of Liquids from Gas Wells. SPE 2198.

## Inputs

| Input | Unit | Default | Name |
|---|---|---:|---|
| First month (Well trends fit table) | month | 2 | `PSH_Start1` |
| Rate below fitted decline, GOR rise over first test, WOR rise over first test, observed PI fall from first test | fraction | 0.20, 0.25, 0.50, 0.20 | `PSH_RateDrop`, `PSH_GorRise`, `PSH_WorRise`, `PSH_PiDrop` |
| Bubble point for test validity | psi | 2620 | `PSH_Pb` |
| Initial oil rate, nominal decline per year, hyperbolic exponent, economic-limit oil rate (Arps reference) | STB/d, 1/year, fraction, STB/d | 1020, 1.89, 0.93, 15 | `PSA_qi`, `PSA_Di`, `PSA_b`, `PSA_QEcon` |
| Grid step unit, grid step, largest history mismatch | text, months or days, fraction | Monthly, 7, 0.1 | `PSA_Basis`, `PSA_Step`, `PSA_FitMax` |
| Oil at breakthrough, first month of trend, Chan slope threshold | STB, month, fraction | 400000, 12, 0 | `PSW_Np0`, `PSW_FitFrom`, `PSW_SlopeConing` |
| Oil price, royalty, production tax, variable oil cost, fixed monthly cost, liquid handling cost | $/STB, fraction, fraction, $/STB, $/month, $/STB | 70, 0.125, 0.05, 6, 25000, 3 | `PSW_Price`, `PSW_Royalty`, `PSW_Tax`, `PSW_Opex`, `PSW_Fixed`, `PSW_Lift` |
| Oil initially in place, minimum trend R squared | STB, fraction | 8000000, 0.95 | `PSW_N`, `PSW_R2Min` |
| Permeability, net pay, oil formation volume factor, oil viscosity, drainage radius, wellbore radius, total skin | mD, ft, rb/STB, cP, ft, ft, fraction | 20, 50, 1.467, 0.302, 1490, 0.354, 5 | `PSI_k`, `PSI_h`, `PSI_Bo`, `PSI_Uo`, `PSI_re`, `PSI_rw`, `PSI_s` |
| Average reservoir pressure, flowing pressure above bubble point, stabilized test PI | psi, psi, STB/d/psi | 4000, 3000, 1.27 | `PSI_Pr`, `PSI_Pwf`, `PSI_JTest` |
| Open interval, top of pay to top of open interval, vertical to horizontal permeability, perforation skin | ft, ft, fraction, skin | 40, 0, 0.1, 0.5 | `PSI_hp`, `PSI_htop`, `PSI_kvkh`, `PSI_sp` |
| Altered-zone permeability and radius | mD, ft | 8, 2 | `PSI_ks`, `PSI_rs` |
| PI mismatch tolerance, Hawkins versus split tolerance, damage skin screening threshold | fraction, skin, skin | 0.1, 0.5, 1 | `PSI_JTol`, `PSI_sTol`, `PSI_sdMax` |
| Gas specific gravity, depth of perforations, tubing inner diameter, tubing relative roughness | fraction, ft, in, fraction | 0.7, 7500, 2.441, 0.0006 | `PSL_SGg`, `PSL_TVD`, `PSL_ID`, `PSL_Rough` |
| Flowing wellhead pressure, flowing wellhead temperature, temperature at perforations | psia, F, F | 1200, 100, 160 | `PSL_Pwh`, `PSL_Twh`, `PSL_Tbh` |
| Liquid density, liquid-gas surface tension | lb/ft3, dyne/cm | 67, 60 | `PSL_RhoL`, `PSL_IFT` |
| Gas rate today, nominal decline rate, Arps exponent | MMscf/d, 1/year, fraction | 8.21, 0.35, 0.5 | `PSL_Qg`, `PSL_Di`, `PSL_b` |
| Turner velocity adjustment, lead time for lift | fraction, years | 1.2, 2 | `PSL_TurnerF`, `PSL_Lead` |

Editable tables: Well trends `B25:B54` contains 30 monthly oil rates, and `C59:F62` contains four GOR, water-cut, reservoir-pressure and flowing-pressure tests. The Arps reference `A36:A59` and `C36:C59` contain 24 history times and oil rates. WOR diagnostics `A51:C74` contains 24 independent time, oil and water observations. Inflow reference `A61:A73` contains the skin sweep. Each reference has its own inputs; changing one does not change the others.

## Sheets

- `Guide` — synthetic scope, workflow and interpretation.
- `Well trends` — one oil well's rate, GOR, WOR and observed-PI histories, the exponential decline fit and the candidate reason.
- `Arps reference` — an independent calibrated Arps decline history and forecast to the economic limit.
- `WOR diagnostics` — an independent DWS waterflood producer's Chan derivative and its WOR extrapolated to an economic limit.
- `Inflow reference` — an independent vertical oil well's PI, skin split and skin sensitivity.
- `Gas loading` — an independent gas well's tubing profile, Turner, Coleman and Li critical rates, and decline.
- `Summary` — candidate reasons, reference highlights and every named check; a fail overrides a warning.
- `Test Cases` — the worked example and other cases, with expected and computed results.

## Functions used

The workbook uses Petroleum Office DCA, statistics, inflow, PVT and gas VFP functions and installs catalog LAMBDAs for Arps secant decline, Chan derivative, economic limit, damage and gas liquid loading: `PO.DCA.Arps.Rate`, `.Prod`, `.EUR`, `.Time`, `PO.DCA.Convert.NominalToEffective`, `PO.Stats.RMSE`, `PO.IPR.VW.PSS.PI`, `PO.IPR.VW.PSS.Rate`, `PO.IPR.Rwa`, `PO.PVT.Z.ByDAK`, `PO.PVT.Ppc.BySutton`, `PO.PVT.Tpc.BySutton`, `PO.PVT.Bg.ByDefinition`, `PO.PVT.Ug.ByLGE`, `PO.VFP.Gas.Pin`, `PO.FA.Erosion.Vmix`, and the LAMBDAs `PO.DCA.Arps.SecantEff`, `PO.PE.Chan.WORDerivative`, `PO.RES.Reserves.EconLimit`, `PO.CO.Damage.Hawkins`, `PO.CO.Damage.Decomposition`, `PO.CO.Damage.Flow`, `PO.PE.Loading.TurnerRate` and `PO.PE.Loading.LiRate`. Microsoft 365 or Excel 2024 and the Petroleum Office add-in are required.
