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

Need a custom LAMBDA? Suggest a New Lambda