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.OutlierFlagPO.DCA.Data.CleanPO.DCA.Arps.FitPO.DCA.Arps.WFitPO.DCA.Arps.RatePO.DCA.Arps.EURPO.Stats.RMSEPO.RES.MC.Percentiles
Names (125)
| Name | Refers to | Comment |
|---|---|---|
PO.RES.MC.PercentilesLAMBDA |
=LAMBDA(X, HSTACK(PERCENTILE.INC(X, 0.1), PERCENTILE.INC(X, 0.5), PERCENTILE.INC(X, 0.9), AVERAGE(X))) |
P90, P50, P10 (petroleum convention: P90 the low case, exceeded 90% of the time) and the mean of a column of outcomes; linear interpolation as PERCENTILE.INC. |
TQC_BPos |
Wells!$B$37 |
Position of b in fit |
TQC_Calendar |
Wells!$A$56:$K$85 |
Monthly oil rates by well |
TQC_Clean |
Wells!$D$92:$D$115 |
Selected well Clean |
TQC_CleanB |
Wells!$B$23 |
Clean b |
TQC_CleanDi |
Wells!$B$22 |
Clean Di per month, 1/month |
TQC_CleanEUR |
Wells!$B$25 |
Clean EUR, MSTB |
TQC_CleanFit |
Wells!$F$92:$F$115 |
Selected well CleanFit |
TQC_CleanQi |
Wells!$B$21 |
Clean qi, STB/d |
TQC_CleanRMSE |
Wells!$B$28 |
Clean fit RMSE, STB/d |
TQC_DMo |
Wells!$B$36 |
Days per month, days/month |
TQC_DataCheck |
Wells!$B$31 |
History and screen verdict |
TQC_DataCheckNote |
Wells!$C$31 |
History and screen comment |
TQC_First |
Wells!$C$42:$C$51 |
First producing month |
TQC_FitCheck |
Wells!$B$33 |
Clean fit verdict |
TQC_FitCheckNote |
Wells!$C$33 |
Clean fit comment |
TQC_FitMax |
Wells!$B$10 |
Maximum fit mismatch, % |
TQC_Flag |
Wells!$C$92:$C$115 |
Selected well Flag |
TQC_FlagCheck |
Wells!$B$32 |
Flagged share verdict |
TQC_FlagCheckNote |
Wells!$C$32 |
Flagged share comment |
TQC_FlagMax |
Wells!$B$8 |
Maximum flagged fraction, % |
TQC_FlagShare |
Wells!$B$16 |
Flagged share, % |
TQC_Flagged |
Wells!$B$15 |
Months flagged |
TQC_History |
Wells!$A$92:$F$115 |
Selected rates, flags, cleaned rates and fits |
TQC_Inputs |
Wells!$B$4:$B$11 |
Selected well, cleaning settings and economic limit |
TQC_Lat |
Wells!$B$42:$B$51 |
Lateral lengths |
TQC_M |
Wells!$A$56:$A$85 |
Calendar months |
TQC_MinWindow |
Wells!$B$38 |
Minimum screen window, months |
TQC_Mode |
Wells!$B$5 |
Selected well's rates |
TQC_N |
Wells!$B$14 |
Usable months in selected window |
TQC_NSigma |
Wells!$B$7 |
Outlier threshold (standard deviations) |
TQC_Names |
Wells!$A$42:$A$51 |
Well names |
TQC_Pick |
Wells!$B$12 |
Selected well row |
TQC_Q |
Wells!$B$92:$B$115 |
Selected well Q |
TQC_QEcon |
Wells!$B$11 |
Economic rate limit, STB/d |
TQC_Rates |
Wells!$B$56:$K$85 |
Calendar rates |
TQC_RawB |
Wells!$B$20 |
Raw b |
TQC_RawDi |
Wells!$B$19 |
Raw Di per month, 1/month |
TQC_RawEUR |
Wells!$B$24 |
Raw EUR, MSTB |
TQC_RawFit |
Wells!$E$92:$E$115 |
Selected well RawFit |
TQC_RawQi |
Wells!$B$18 |
Raw qi, STB/d |
TQC_RawRMSE |
Wells!$B$27 |
Raw fit RMSE against cleaned rates, STB/d |
TQC_Ready |
Wells!$B$30 |
Screen ready |
TQC_RefitCheck |
Wells!$B$34 |
EUR change verdict |
TQC_RefitCheckNote |
Wells!$C$34 |
EUR change comment |
TQC_RelErr |
Wells!$B$29 |
Clean fit RMSE over mean, % |
TQC_Results |
Wells!$B$12:$B$30 |
Screen, fits and recovery results |
TQC_Shift |
Wells!$B$26 |
EUR change, % |
TQC_ShiftMax |
Wells!$B$9 |
Maximum EUR shift, % |
TQC_Start |
Wells!$B$13 |
Selected first calendar month, month |
TQC_T |
Wells!$A$92:$A$115 |
Selected well T |
TQC_Well |
Wells!$B$4 |
Well to review |
TQC_Wells |
Wells!$A$42:$D$51 |
Names, editable laterals, first positive month and positive counts |
TQC_Window |
Wells!$B$6 |
Rolling window (months) |
TWA_Checks |
Summary!$B$18:$B$25 |
Every check from the workbook |
TWA_CumP50 |
Summary!$B$10 |
P50 well cumulative, MSTB |
TWA_Flagged |
Summary!$B$12 |
Selected well flagged months |
TWA_Overall |
Summary!$B$4 |
Overall verdict verdict |
TWA_OverallNote |
Summary!$C$4 |
Overall verdict comment |
TWA_P10EUR |
Summary!$B$9 |
P10 EUR (high), MSTB |
TWA_P50Cum |
Summary!$B$11 |
P50 curve cumulative, MSTB |
TWA_P50EUR |
Summary!$B$8 |
P50 EUR, MSTB |
TWA_P90EUR |
Summary!$B$7 |
P90 EUR (low), MSTB |
TWA_Shift |
Summary!$B$13 |
Selected well EUR change, % |
TWC_Aligned |
'Type Curves'!$A$48:$S$71 |
Scaled well rates, coverage, weights, percentiles and fits |
TWC_BPos |
'Type Curves'!$B$11 |
Position of b in fit |
TWC_Count |
'Type Curves'!$L$48:$L$71 |
Well count each month |
TWC_CumBand |
'Type Curves'!$B$8 |
Maximum cumulative gap, % |
TWC_CumCheck |
'Type Curves'!$B$35 |
Cumulative gap verdict |
TWC_CumCheckNote |
'Type Curves'!$C$35 |
Cumulative gap comment |
TWC_CumGap |
'Type Curves'!$B$29 |
P50 curve gap to well median, % |
TWC_CumMean |
'Type Curves'!$B$27 |
Mean well cumulative, MSTB |
TWC_CumP10 |
'Type Curves'!$B$26 |
P10 well cumulative, MSTB |
TWC_CumP50 |
'Type Curves'!$B$25 |
P50 well cumulative, MSTB |
TWC_CumP90 |
'Type Curves'!$B$24 |
P90 well cumulative, MSTB |
TWC_Cums |
'Type Curves'!$V$38:$V$47 |
Individual well cumulatives, MSTB |
TWC_DMo |
'Type Curves'!$B$9 |
Days per month, days/month |
TWC_EurRatio |
'Type Curves'!$B$28 |
P10 over P90 EUR |
TWC_FitCheck |
'Type Curves'!$B$33 |
Fit mismatch verdict |
TWC_FitCheckNote |
'Type Curves'!$C$33 |
Fit mismatch comment |
TWC_FitMax |
'Type Curves'!$B$7 |
Maximum fit mismatch, % |
TWC_FitP10 |
'Type Curves'!$S$48:$S$71 |
P10 Arps fit |
TWC_FitP50 |
'Type Curves'!$R$48:$R$71 |
P50 Arps fit |
TWC_FitP90 |
'Type Curves'!$Q$48:$Q$71 |
P90 Arps fit |
TWC_Fits |
'Type Curves'!$A$17:$H$19 |
Arps parameters, EUR, cumulative and mismatch |
TWC_K |
'Type Curves'!$A$48:$A$71 |
Producing months |
TWC_MeanPos |
'Type Curves'!$B$13 |
Position of mean in percentiles |
TWC_MinWells |
'Type Curves'!$B$6 |
Minimum wells each month, wells |
TWC_MoYr |
'Type Curves'!$B$10 |
Months per year, months/year |
TWC_NMin |
'Type Curves'!$B$23 |
Fewest wells in any month, wells |
TWC_NWells |
'Type Curves'!$B$22 |
Wells in set, wells |
TWC_OrderCheck |
'Type Curves'!$B$34 |
EUR order verdict |
TWC_OrderCheckNote |
'Type Curves'!$C$34 |
EUR order comment |
TWC_P10 |
'Type Curves'!$P$48:$P$71 |
P10 type curve |
TWC_P10B |
'Type Curves'!$E$19 |
P10 B |
TWC_P10Cum |
'Type Curves'!$G$19 |
P10 Cum |
TWC_P10Di |
'Type Curves'!$D$19 |
P10 Di |
TWC_P10DiM |
'Type Curves'!$C$19 |
P10 DiM |
TWC_P10EUR |
'Type Curves'!$F$19 |
P10 EUR |
TWC_P10Err |
'Type Curves'!$H$19 |
P10 Err |
TWC_P10Pos |
'Type Curves'!$B$12 |
Position of P10 in percentiles |
TWC_P10Qi |
'Type Curves'!$B$19 |
P10 Qi |
TWC_P50 |
'Type Curves'!$O$48:$O$71 |
P50 type curve |
TWC_P50B |
'Type Curves'!$E$18 |
P50 B |
TWC_P50Cum |
'Type Curves'!$G$18 |
P50 Cum |
TWC_P50Di |
'Type Curves'!$D$18 |
P50 Di |
TWC_P50DiM |
'Type Curves'!$C$18 |
P50 DiM |
TWC_P50EUR |
'Type Curves'!$F$18 |
P50 EUR |
TWC_P50Err |
'Type Curves'!$H$18 |
P50 Err |
TWC_P50Qi |
'Type Curves'!$B$18 |
P50 Qi |
TWC_P90 |
'Type Curves'!$N$48:$N$71 |
P90 type curve |
TWC_P90B |
'Type Curves'!$E$17 |
P90 B |
TWC_P90Cum |
'Type Curves'!$G$17 |
P90 Cum |
TWC_P90Di |
'Type Curves'!$D$17 |
P90 Di |
TWC_P90DiM |
'Type Curves'!$C$17 |
P90 DiM |
TWC_P90EUR |
'Type Curves'!$F$17 |
P90 EUR |
TWC_P90Err |
'Type Curves'!$H$17 |
P90 Err |
TWC_P90Qi |
'Type Curves'!$B$17 |
P90 Qi |
TWC_Ready |
'Type Curves'!$B$31 |
Curve calculations ready |
TWC_RefLat |
'Type Curves'!$B$4 |
Reference lateral, ft |
TWC_W |
'Type Curves'!$M$48:$M$71 |
Fit weights |
TWC_WPow |
'Type Curves'!$B$5 |
Late-time weight exponent |
TWC_WellsCheck |
'Type Curves'!$B$32 |
Well coverage verdict |
TWC_WellsCheckNote |
'Type Curves'!$C$32 |
Well coverage comment |
TWC_WorstErr |
'Type Curves'!$B$30 |
Worst fit mismatch, % |
Details
| Opens in | Needs the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates. Needs Microsoft 365 or Excel 2024: it uses functions Excel 2016 doesn't have, such as named LAMBDAs, which show #NAME? there. |
| File | TypeWell.xlsx, 51 KB |
| Category | Production |
| For agents and tools | Descriptor (.md) |
More Production Workbooks
Artificial Lift Selection
PO Add-in + Microsoft 365Which artificial-lift method suits a well, from a six-method screen against editable limits to first-pass ESP, gas-lift, rod-pump and plunger sizing.
Continuous Gas-Lift Design
PO Add-inHow much lift gas one well needs, how deep to inject it and where the unloading valves go, checked against port throughput and the nodal rate.
Decline Curve Analysis
PO Add-in + Microsoft 365How much oil one well will recover, from its monthly rate history through four decline fits to an EUR, a booked model and its sensitivity.
ESP System Design
PO Add-in + Microsoft 365How many stages and which motor one well's ESP needs, where it operates, and whether intake gas, cable voltage drop and drive speed are acceptable.
Field Production Profile
PO Add-in + Microsoft 365What a 24-well development will produce year by year, from a P50 type well through a drilling schedule and a buildup, plateau and decline profile.
Flow Assurance Screening
PO Add-in + Microsoft 365Whether a subsea tieback will hydrate, scale, corrode or erode, the methanol that clears its hydrates, and how high each threat rates.
Gas Well Deliverability
PO Add-in + Microsoft 365How much gas one well delivers and when it will load up, from a four-point test fit through the tubing to critical rates along a decline.
Gas-Lift Field Optimisation
PO Add-inHow to split a limited lift-gas supply across four wells for the most oil, and where the first well then injects.
Gathering System Diagram
Excel 2016+How a field's wells, chokes, manifold and separators connect, drawn from a network table and labelled with typed rates and pressures.
Inverted ESP for a Downhole Water Sink
PO Add-in + Microsoft 365Which pump, stages and drive frequency an inverted ESP needs to drain water below the contact and re-inject it, and whether that water is coning.
Nodal Analysis
PO Add-in + Microsoft 365At what rate one oil well flows, from its inflow and best-matching tubing curve, and how tubing size, skin, wellhead pressure and water cut move it.
Pipeline Design and Route Integrity
PO Add-in + Microsoft 365What size one route's gas, liquid and multiphase lines must be, and whether the bore holds against erosion, hydrates and CO2 corrosion.
Production Allocation
Excel 2016+How much of one battery's metered oil, gas and water each of its ten wells made, from each well's test rates and hours on production.
Production Surveillance
PO Add-in + Microsoft 365Whether an oil well's rate, GOR, WOR or productivity index has moved off trend enough to review, beside decline, WOR, inflow and loading references.
Rod Pump System Design
PO Add-in + Microsoft 365Whether a tapered rod string, pump and pumping unit lift one well's target rate within rod stress, unit ratings and counterbalance.
Surface Facility Sizing
PO Add-in + Microsoft 365How big a separator, how much compression and which wellhead choke one well stream needs, from its gas, oil and water rates and pressures.
Unconventional Rate-Transient Analysis
PO Add-in + Microsoft 365Whether a tight-oil well has reached boundary-dominated flow, how much oil it contacts and what it will recover, from its monthly rates and flowing pressures.
VFP Production and Injection Tables
PO Add-in + Microsoft 365What bottomhole pressure one vertical well needs across rate, pressure, water cut and GOR, written as VFPPROD and VFPINJ tables for a simulator.
Well Productivity Review
PO Add-in + Microsoft 365Which wells are worth stimulating, ranked by PI, skin and damage ratio, with each one's IPR uplift valued against a type curve.
Need a workbook we don't have? Suggest a Workbook





