Decline Curve Analysis: DCA, EUR, Excel, Software, and Production Data (2026)

Decline curve analysis, usually shortened to DCA, is the practical method oil and gas teams use to turn historical production into a forecast.

The basic idea is simple: a producing well usually starts high, falls quickly, and then settles into a slower tail. A decline curve fits that observed production history and estimates what the well may produce next.

That matters because a forecast drives real decisions:

• whether a well or lease is worth buying
• whether a group of wells supports a reserve case
• whether a package is strong enough for lending or internal capital review
• whether an operator's public production story matches source-level production behavior
• whether a data/API workflow has enough monthly history to support a useful type curve

EnergyNetWatch treats DCA as a source-aware workflow, not a magic number. A curve is only as useful as the production history, date basis, well identity, normalization rules, and quality gates behind it.

Decline Curve Analysis In Oil And Gas

In oil and gas, decline curve analysis usually means fitting an Arps-style curve to monthly or daily production.

The three classic Arps decline types are:

The model is useful because it compresses a messy production history into a small set of parameters:

The hard part is not writing the formula. The hard part is deciding whether the input history is good enough to forecast.

The Arps Formulas

The most common formulas are:

Exponential:
q(t) = qi * e^(-Di * t)

Hyperbolic:
q(t) = qi / (1 + b * Di * t)^(1 / b)

Harmonic:
q(t) = qi / (1 + Di * t)

Where q(t) is production rate at time t, qi is the starting production rate, Di is the initial decline rate, and b controls the decline shape.

For modern shale wells, hyperbolic decline is often the starting point, but an unconstrained hyperbolic fit can produce an unrealistic long tail. That is why a serious workflow should show the assumptions: fitting window, minimum history, zero-month handling, terminal decline, economic limit, and whether the result passed a quality gate.

A Simple EUR Example

Assume a well has:

A simplified hyperbolic EUR calculation can be written as:

EUR = [qi / ((1 - b) * Di)] * [1 - (q_limit / qi)^(1 - b)] * 30.44

Using those assumptions:

EUR = [500 / ((1 - 0.8) * 0.08)] * [1 - (10 / 500)^(1 - 0.8)] * 30.44
EUR = [500 / 0.016] * [1 - 0.457] * 30.44
EUR ~= 516,000 barrels

That number is not a valuation by itself. It is a forecast volume before price, operating cost, working interest, royalty burden, taxes, downtime, abandonment cost, and risk adjustments.

DCA In Excel

Many analysts still build decline curve analysis in Excel because it is transparent and easy to audit.

A practical Excel workflow usually looks like this:

Excel can work for a small set of wells. The problem appears when a team needs to repeat the process across thousands or millions of wells, keep source dates visible, preserve well identity, and explain which curves are fit for decision support.

That is where a software or API workflow becomes more useful.

DCA Software Should Preserve Source Context

Decline curve software should do more than draw a smooth line.

Before trusting a forecast, a user should be able to answer:

EnergyNetWatch uses this framing in the app: production data first, source context second, forecast only when the record quality supports it.

Monthly Production Data Is The Foundation

Most public DCA workflows start with state-reported monthly production.

That creates several practical issues:

This is why DCA should sit next to the source-production workflow. A forecast is not separate from data quality. It depends on it.

For Texas context, see the Texas oil and gas production reporting guide. For broader source context, see why oil and gas data is hard to normalize.

EnergyNetWatch DCA Workflow

A useful DCA workflow should be repeatable:

state production -> well identity -> monthly history -> quality gate -> curve fit -> forecast/export

EnergyNetWatch keeps the record basis visible before presenting forecast outputs. That means the app can support several different user jobs:

The practical rule is simple: do not treat every curve as equally trustworthy. A well with clean monthly history and a stable fit is different from a short-history, gassy, shut-in, or noisy well.

When DCA Should Be Discounted

DCA is useful, but it should be discounted when the input history is weak.

Watch for:

• fewer than 12 meaningful production months
• major shut-ins or workovers in the fit window
• allocated volumes where well-level behavior is uncertain
• gas/oil stream changes that shift the BOE read
• unusually high b factors without a terminal decline constraint
• wells still in early transient behavior
• stale source data or partial latest-month loads
• missing operator or API identity

Those cases do not make the data useless. They mean the result should be labeled as lower-confidence or excluded from valuation-grade workflows.

What To Request From EnergyNetWatch

If your team is evaluating DCA or production forecasting, the best request is not a generic demo.

Ask for a current workflow tied to your basin, operator, county, or well list:

Request EnergyNetWatch access for current production histories, DCA quality flags, maps, exports, alerts, and API workflows.

Frequently Asked Questions

What is decline curve analysis?

Decline curve analysis is a method for fitting historical oil and gas production to a mathematical curve so a team can estimate future production and remaining recoverable volume.

What is EUR in oil and gas?

EUR means estimated ultimate recovery. It is the estimated total volume a well or group of wells may produce over its life under a defined forecast and economic-limit assumption.

Can DCA be done in Excel?

Yes. Excel is common for single-well or small-package analysis. The challenge is scaling the workflow while preserving source data, well identity, zero-month handling, quality gates, and exportable assumptions.

What production data is needed for DCA?

At minimum, a useful DCA workflow needs monthly production history, well identity, production phase, source dates, and enough nonzero months to fit a curve. Better workflows also preserve operator labels, county context, and data caveats.

Is hyperbolic decline always better than exponential decline?

No. Hyperbolic decline often fits unconventional wells better, but it can overstate tail production if the b factor and terminal decline are not constrained. Exponential decline may be more conservative for later-life behavior.

Does EnergyNetWatch provide DCA through the app or API?

EnergyNetWatch supports production-history workflows and quality-gated DCA workflows where the source data supports them. API access is scoped by account, dataset, entitlement, and approved use case.

Sources

• J.J. Arps, "Analysis of Decline Curves," Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers, 1945.
• EnergyNetWatch Texas oil and gas production reporting guide
• EnergyNetWatch oil and gas data API guide
• EnergyNetWatch source-aware methodology