PO.DCA.Arps.SecantEff
Description
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.
Formula
=LAMBDA(Di, b, IF(OR(Di<0, b<0), NA(), IF(b=0, 1-EXP(-Di), 1-(1+b*Di)^(-1/b))))Parameters
| Parameter | Unit | Description |
|---|---|---|
Di |
1/time | Nominal (instantaneous) decline at the start of the period, in the time base the effective decline is wanted over; 0 or more |
b |
— | Arps hyperbolic exponent: 0 exponential, 1 harmonic; 0 or more |
Examples
| Invocation | Expected |
|---|---|
=PO.DCA.Arps.SecantEff(1.89, 0.93) |
0.664035 |
=PO.DCA.Arps.SecantEff(0.5, 0) |
0.393469 |
=PO.DCA.Arps.SecantEff(1, 1) |
0.5 |
=PO.DCA.Arps.SecantEff(1, 0.5) |
0.555556 |
=PO.DCA.Arps.SecantEff(0.3, 2) |
0.209431 |