Decline Curve Analysis LAMBDAs
Classic and unconventional decline models, decline diagnostics, rate conversions, field production profiles and the cash-flow economics a forecast feeds.
13 lambdas
PO.DCA.ModHyp.Tswitch
Returns the time at which a modified hyperbolic decline switches from its Arps hyperbolic to the terminal exponential: the time when the hyperbolic's nominal decline, Di/(1 + b·Di·t), has fallen to the terminal decline Dlim. t = (Di/Dlim − 1)/(b·Di), in the time base of the declines. It is the switch `PO.DCA.ModHyp.Rate` and `PO.DCA.ModHyp.Prod` make, so the rate at the switch is `PO.DCA.ModHyp.Rate` at this time, qi·(Dlim/Di)^(1/b).
PO.PE.Chan.WORDerivative
The time derivative of the water-oil ratio, WOR′ = dWOR/dt, at one point of a well's production history: the second curve of Chan's water-control diagnostic. Plotted with WOR against time on log-log axes, its trend tells the excess water's source. A WOR′ that keeps rising with a positive slope is near-wellbore channelling or a high-permeability layer watering out; a WOR′ whose slope turns negative after breakthrough, while WOR still climbs slowly, is bottom-water coning, the case a downhole water sink treats.
PO.RTA.NormalizedRate
Returns the pressure-normalized oil rate of rate-transient analysis, q/(pi − pwf): the oil rate over the drawdown from the initial reservoir pressure to the flowing bottomhole pressure. It is the y axis of the Blasingame and Agarwal-Gardner plots, and it puts a well whose flowing pressure changes (a choke change, a pump speed-up) back on one decline, which a rate alone can't. Its reciprocal, (pi − pwf)/q, is the inverse normalized pressure a flowing material balance fits against material-balance time (`PO.RTA.FlowingMB`). It works on one value or on whole columns of rates and flowing pressures.
PO.RTA.FlowingMB
Returns the oil in place a producing well has contacted, in STB, by the flowing material balance of Agarwal-Gardner and Mattar-Anderson. From each point's cumulative oil Np and rate q it forms the material-balance time tc = Np/q, fits the inverse normalized pressure (pi − pwf)/q against it with a straight line, and returns 1/(slope·ct). It needs no shut-in: the flowing pressures the well already records stand in for the average reservoir pressures a tank material balance asks for. Pass only the points in boundary-dominated flow; transient points sit off the line.
PO.DCA.Arps.SecantEff
Returns the secant effective decline of an Arps hyperbolic over one period of its time base: the fraction of the rate lost in that period, from the nominal decline Di the Arps functions take. De = 1 − (1 + b·Di)^(−1/b), and 1 − exp(−Di) for exponential decline (b = 0). With Di in 1/yr it is the effective annual decline that reserves reports and economics programs quote a hyperbolic in. The shipped `PO.DCA.Convert.NominalToEffective` is the tangent (exponential) conversion, 1 − exp(−Di), which equals the secant only when b = 0.
PO.Stats.AARE
How far a correlation's values fall from measured ones, as one number: the average absolute relative error, in percent. It is the score PVT and flow-correlation studies rank correlations by, because a relative error lets a 50 scf/STB miss at 100 scf/STB count for more than the same miss at 800, and the absolute value stops misses on either side from cancelling. Give it the observed values and the computed ones, of the same shape: a column of lab points and the column a correlation gives at them, or two single values. A pair is scored only when both are numbers and the observed value is not zero, so a lab table can carry blank rows and a correlation can leave a point out. With no pair to score it returns #N/A.
PO.ECON.NPV.Monthly
Net present value of a column of monthly cash flows at an annual discount rate. Each flow is taken at the end of its month, so the k-th flow is divided by (1 + i)^(k/12), where i is the annual rate. The monthly rate (1 + i)^(1/12) − 1 is the one that compounds to i over twelve months, so a flow twelve months out is discounted by exactly one year. Any currency works; the result is in the same currency.
PO.ECON.IRR.Monthly
Annualised internal rate of return of a column of monthly cash flows, robust to the second root that end-of-life costs create. Excel's IRR searches locally from one guess. A well program's cash flow often has two roots, because plugging costs at the end of life turn the flow negative again, and from its default guess IRR can land on the spurious one at a negative rate. This LAMBDA first evaluates NPV on a grid of monthly rates from −5 % to +45 % in steps of 0.25 %. The first grid point after NPV turns positive where NPV is no longer positive brackets the economic root. IRR, seeded at the bottom of that bracket, refines it, and linear interpolation across the step stands in if IRR strays outside it. The monthly root r is returned as the annual rate (1 + r)^12 − 1. It returns the text "n/a" when NPV never falls through zero on the grid: a program that never pays back its capital has no IRR, and neither does one whose IRR is above 45 % a month.
PO.ECON.Payout
The month in which cumulative cash flow climbs back to zero after its low point: the undiscounted payout. The cumulative cash flow is found with SCAN. Its low point is the trough, where the capital outlay is deepest; payout is the first month after the trough in which the cumulative is zero or more. Counting from the trough, not from the start, means early revenue before a later capital phase does not count as payout. The LAMBDA returns the month's position in the column (the first month is 1), and the text "none" when the cumulative never climbs back to zero.
PO.ECON.Capex.Phasing
Spreads a capital total over periods in proportion to a phasing profile. Each period gets total × weight / sum of weights, so the profile can be written as percentages, fractions or any relative weights, and the spread always adds back to the total. The result has the shape of the profile: a column profile gives a column of spend by period, ready to subtract from a monthly cash flow. A zero weight leaves that period without spend.
PO.RES.Reserves.EconLimit
The production rate at which a well or field stops paying for itself: the rate at which the net revenue from each barrel (or Mscf), after royalty, production tax and variable operating cost, just covers the fixed operating cost. A decline forecast ends where it falls to this rate, which fixes the reserves and the cessation date (`PO.ECON.COP.Date`).
PO.ECON.COP.Date
The date on which a production forecast first falls to the economic limit: the cessation-of-production (COP) date that ends the reserves and the cash flow. The forecast can come from any decline model or simulation, as a column of dates and a column of rates. Between the last date above the limit and the first date at or below it, the date is interpolated on the logarithm of the rate, which is exact for an exponential decline.
PO.ECON.PSC.Split
The period-by-period split of a production sharing contract (PSC). From the gross revenue the government first takes its royalty. The contractor then recovers its costs as cost oil, up to a cost-recovery cap; costs above the cap carry forward to later periods. What remains is profit oil, shared between the government and the contractor on a sliding scale set either by the contractor's R-factor or by production tranches. The contractor pays income tax on its share of the profit oil. The function returns one of these quantities as a column, one row per period: cost oil, profit oil, either party's profit oil, the contractor's tax, the government take, the contractor's net cash flow, or the government's cumulative share of the profit.