---
id: po.wb.dca.type-well
title: Type Well Builder
summary: "What a new well in a play will produce, as P90, P50 and P10 type curves and EURs from ten offset wells normalised by lateral length and screened for outliers."
category: Production
requires:
  - po-addin
  - excel-365
tags:
  - decline-curve-analysis
  - type-well
  - type-curve
  - data-cleaning
  - Arps
  - weighted-fit
  - EUR
---

## Description

What should a new well in this play produce, low, middle and high? You enter ten offset wells' completed laterals and 30 calendar months of oil rates; the workbook aligns them at first production, scales each to a reference lateral, takes the monthly P90, P50 and P10 and fits each with Arps. You read off the three type curves and their EURs, the P50's 24-month cumulative against the wells' median, and an outlier screen of any one well before it joins the set.

**How to use it:** On the Wells sheet, enter monthly volume divided by producing days, zeros before first production, and the completed length for each well. Use a consistent landing zone, completion and vintage, and at least eight to ten comparable wells with 24 consecutive producing months. Pick a well to review and check allocation, downtime, tests, frac hits and recompletions before changing it to Clean; review each flagged month against field records, as an outlier is not necessarily an error. On the Type Curves sheet, set the reference lateral, the late-time weight exponent and the coverage and fit limits, and read the percentile curves and EURs. Linear lateral scaling is an assumption, not a physical law. The Summary gathers the results and checks.

**Method:** A rate is monthly oil volume divided by producing days. Each well is aligned to its first positive calendar month and multiplied by reference lateral / well lateral. Each producing month's P90, P50 and P10 are `PERCENTILE.INC` at 0.1, 0.5 and 0.9. The Arps fits minimise weighted log error, using (month/24)^p as weight, with p the late-time weight exponent. EUR is calculated to the economic rate limit, with 30.4375 days per month. The selected well's rolling Z-score flags are reviewed and the flagged rates interpolated; an Arps fit compares the raw and clean histories. The raw set remains in use unless Clean is explicitly selected; Clean substitutes only the selected well's first 24 producing months.

**Example:** Ten synthetic tight-oil laterals, 6,500 to 12,500 ft, start over seven calendar months. With raw rates, a 10,000 ft reference, late-time weight exponent 1 and a 15 STB/d limit, the independent type-well blueprint gives P90, P50 and P10 EURs of about 442, 676 and 1,069 MSTB. The P50 curve's 24-month cumulative is about 279.0 MSTB versus the wells' median of 278.9 MSTB. These are synthetic results, not reserves.

## Validity

A curve of monthly percentiles is not a single well. P90 is the low 10th percentile, P10 the high 90th percentile, not probabilistic reserves for one well. The fitted Arps tail may be highly uncertain; compare with a terminal-decline forecast and older analogues. The outlier screen cannot distinguish a genuine operating event from an error and can miss runs of bad months. If a selected history is too short or the screen invalid, the screen reports FAIL and Clean does not substitute it. Missing months reduce the curve coverage; if any month has no contributing wells the fit is disabled. Review any FAIL or WARN before use.

## References

- Arps, J.J. (1945), Analysis of Decline Curves, Transactions of the AIME 160, 228-247.
- Society of Petroleum Evaluation Engineers (2016), Monograph 4, Estimating Ultimate Recovery of Developed Wells in Low-Permeability Reservoirs.
- Society of Petroleum Engineers (2018), Petroleum Resources Management System, section 2.2.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| Well to review; selected well's rates (Raw or Clean) | — | A-1, Raw | `TQC_Well`, `TQC_Mode` |
| Lateral lengths and 30 months of oil rates | ft, STB/d | synthetic ten-well set | `TQC_Lat`, `TQC_Rates` |
| Rolling window; outlier threshold | months, standard deviations | 7, 3 | `TQC_Window`, `TQC_NSigma` |
| Maximum flagged fraction, maximum EUR shift, maximum fit mismatch | fraction | 0.15, 0.05, 0.1 | `TQC_FlagMax`, `TQC_ShiftMax`, `TQC_FitMax` |
| Economic rate limit (shared) | STB/d | 15 | `TQC_QEcon` |
| Reference lateral; late-time weight exponent | ft, dimensionless | 10000, 1 | `TWC_RefLat`, `TWC_WPow` |
| Minimum wells each month, maximum fit mismatch, maximum cumulative gap | wells, fraction, fraction | 8, 0.1, 0.15 | `TWC_MinWells`, `TWC_FitMax`, `TWC_CumBand` |

## Sheets

- `Guide` — the workflow and how to read the curves.
- `Wells` — the editable laterals and 30-month calendar of rates for the ten wells, the selected well's rolling Z-score screen, and its raw and clean Arps fits.
- `Type Curves` — the rates aligned at first production and scaled by lateral, the P90, P50 and P10 curves with their Arps fits and EURs, and the chart.
- `Summary` — the principal results and every check.
- `Test Cases` — the worked example and other cases, with expected and computed results.

## Functions used

`PO.DCA.Data.OutlierFlag`, `PO.DCA.Data.Clean`, `PO.DCA.Arps.Fit`, `PO.DCA.Arps.WFit`, `PO.DCA.Arps.Rate`, `PO.DCA.Arps.EUR`, `PO.Stats.RMSE`, `PO.RES.MC.Percentiles`.
