---
id: po.wb.res.reserves-report
title: Reserves Screening Report
summary: "How much oil three wells have left in 1P, 2P and 3P screening cases, what it is worth and how it reconciles with last year's booking and production."
category: Reservoir
requires:
  - po-addin
  - excel-365
tags:
  - reserves
  - decline-curve-analysis
  - Arps
  - economic-limit
  - EUR
  - type-curve
  - sensitivity
  - forecast
---

## Description

How much oil do wells A-1 to A-3 have left in 1P, 2P and 3P screening cases, what is it worth, and how does this year's number reconcile with last year's? You import the P90, P50 and P10 type curves fitted to a ten-well population, enter each well's 30-month history and lateral, an economics deck and last year's balances. You read off each well's scaled EUR and remaining oil per category, its limit and screening PV, the low and high scenario bounds, and the bridge residual from the prior booking. Oil rates in STB/d, volumes in MSTB, value in $MM.

**How to use it:** Rebuild the ten-well population in the Type Well Builder workbook and copy its reviewed fits and population diagnostics onto the Type curves sheet; a changed fit or diagnostic warns until it is rebuilt and reviewed there. Enter each report well's lateral and monthly history and its prior remaining, additions and revisions per category on the Report sheet (below the results); the 30 months include the final twelve used in the reconciliation. Set the reporting dates and the bridge tolerance at the top of the Report sheet, the sensitivity ranges on the Sensitivity sheet, and the price, cost, tax and discount deck on the Economics sheet. Read each well's numbers on the Report and Valuation sheets and the totals and every check on the Summary. Replace every synthetic default, balance and date before using the numbers.

**Method:** Each type curve's Arps EUR runs to the screening limit. A report well's 1P, 2P and 3P EURs are the P90, P50 and P10 curve EURs scaled by its first-24-month cumulative over the imported normalised median, and its remaining oil is the scaled EUR less its cumulative production, floored at zero. The fit, well-count and cumulative checks read the imported diagnostics, not a recalculated population; the EUR ordering uses the current parameters. The Report compares the proxies with scaled deterministic low and high scenarios and warns on excursions; the scenarios move qi, decline, b and the limit together and are not percentiles, and their independent reference well takes 25 and 10 STB/d as its low and high limits against the type curve's 15 STB/d. The Economics sheet is an independent modified-hyperbolic well with an exponential tail, a limit from the deck and a PV including plugging; its results are not assigned to the report wells. Each report well and category instead gets a scaled Arps limit and a screening PV from the deck's working interest, royalty, tax, fixed and variable costs, escalation, discount and plugging. The valuation inverts the Arps cumulative for a depletion-equivalent age, integrates annual buckets to the limit and discounts partial buckets at their midpoints; it warns at the 40-year cap or where a type limit falls below the deck's break-even. The bridge residual per well and category is current − (prior − production + additions + revisions), with last year's production months 19–30 and a default tolerance of 0.1 MSTB per row. Oil volumes use 30.4375 days a month.

**Example:** The synthetic population at a 10000 ft reference lateral: the imported population and the minimum monthly count are both 10 wells. The P90, P50 and P10 curve EURs are about 441.683, 676.367 and 1069.11 MSTB. The history starts in July 2023, the opening balance is dated 1 January 2025 and the report 1 January 2026; the openings are rounded synthetic assumptions. These are screening curves, not portfolio percentiles.

## Validity

P90, P50 and P10 use exceedance ordering: the 10th, 50th and 90th percentiles of monthly rates across wells. Neither these curves nor the scaled EURs are individual-well probability distributions. The labels are screening conventions, **not SPE-PRMS classification or sign-off**; arithmetic sums are not portfolio percentiles. The low and high scenarios are illustrative bounds, not an uncertainty interval, and not guaranteed physical bounds. The screening values are approximations, not booking valuations. The date check fails on a mismatch between the dates and the history, and changed fits or balances may need revisions in the bridge. Independently review uncapped tails, economic thresholds, history, lateral scaling, sample size, recoverability, commerciality, ownership and classification; replace the synthetic inputs and balances.

## References

- Arps, J.J. (1945). Analysis of Decline Curves. *Trans. AIME* 160, 228-247.
- SPEE (2016). *Monograph 4: Estimating Ultimate Recovery of Developed Wells in Low-Permeability Reservoirs*.
- Society of Petroleum Engineers et al. (2018). *Petroleum Resources Management System*.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| Reference lateral | ft | 10000 | `RPT_RefLat` |
| Late-month weight exponent | — | 1 | `RPT_WPow` |
| Economic-limit rate | STB/d | 15 | `RPT_QEcon` |
| Minimum wells per producing month | wells | 8 | `RPT_MinWells` |
| Maximum relative fit error | fraction | 0.1 | `RPT_FitMax` |
| Maximum median cumulative gap | fraction | 0.15 | `RPT_CumBand` |
| Imported Arps fits: qi, Di, b, cumulative and fit error per curve | STB/d, 1/month, —, MSTB, fraction | imported fits | `RPT_P90Qi`, `RPT_P90DiM`, `RPT_P90B` and the P50 and P10 equivalents, each curve's `Cum` and `Err` |
| Source well count; minimum producing-month count | wells | imported diagnostics | `RPT_NWells`, `RPT_NMin` |
| 24-month cumulative P90, P50, P10 and mean | MSTB | imported diagnostics | `RPT_CumP90`, `RPT_CumP50`, `RPT_CumP10`, `RPT_CumMean` |
| Initial oil rate; initial nominal decline; hyperbolic exponent; base economic limit | STB/d, 1/yr, —, STB/d | 1020, 1.89, 0.93, 15 | `RPE_qi`, `RPE_Di`, `RPE_b`, `RPE_QEcon` |
| Initial rate, low and high | STB/d | 920, 1120 | `RPE_qiLo`, `RPE_qiHi` |
| Decline, low and high | 1/yr | 1.6, 2.2 | `RPE_DiLo`, `RPE_DiHi` |
| Exponent, low and high | — | 0.7, 1 | `RPE_bLo`, `RPE_bHi` |
| Economic limit, low and high | STB/d | 10, 25 | `RPE_QEconLo`, `RPE_QEconHi` |
| Age at forecast start | months | 24 | `RPC_Age` |
| Forecast start date | date | 2026-01-01 | `RPC_Start` |
| Forecast months, at most 1200 | months | 480 | `RPC_Horizon` |
| First calendar production month | date | 2023-07-01 | `RPR_CalendarStart` |
| Opening reserves date | date | 2025-01-01 | `RPR_PriorDate` |
| Current reserves date | date | 2026-01-01 | `RPR_AsOf` |
| Reconciliation tolerance per row | MSTB | 0.1 | `RPR_Tolerance` |
| A-1 1P prior remaining, additions and revisions (every row has its own) | MSTB | synthetic, 0, 0 | `RPR_PriorA1`, `RPR_AdditionA1`, `RPR_RevisionA1` |

The imported fits and diagnostics, the three well histories and laterals, the economics deck, and each bridge row's prior balance, additions and revisions are editable. The histories and bridge inputs sit below the Report results. Two economics inputs and the high sensitivity exponent sit below their main blocks; the sheet labels document the complete deck.

## Sheets

- `Guide` — the workflow, the interpretation and limits, the economic models, and the reconciliation and dates.
- `Type curves` — the imported P90, P50 and P10 Arps fits and population diagnostics, their annual declines and EURs to the limit, and the checks; rebuild them in the Type Well Builder workbook.
- `Sensitivity` — an independent reference well's low, base and high EUR with all inputs moved together, and the one-at-a-time sensitivity.
- `Economics` — an independent modified-hyperbolic reference well: netback, economic limit, cessation date, remaining oil to the limit and PV including plugging.
- `Report` — each well's 1P, 2P and 3P proxy EUR and remaining oil, the scenario bounds, the limit and the prior-year bridge, with the editable balances and histories below.
- `Valuation` — each well and category's discounted annual cash flows over 40 annual buckets and its PV including plugging, with the PV sums by category.
- `Summary` — the arithmetic proxy totals, the independent reference-well economics and every check under one verdict.
- `Test Cases` — the worked example and other cases, with expected and computed results.

## Functions used

`PO.DCA.Arps.EUR`, `PO.DCA.Arps.Time`, `PO.RES.Reserves.EconLimit`, `PO.ECON.COP.Date`, and `PO.ECON.NPV.Monthly`.
