PO.ECON.COP.Date


Description

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.

Formula

=LAMBDA(Dates, Rate, Limit, LET( i, SEQUENCE(ROWS(Rate)), hit, IFERROR(MATCH(1, (Rate<=Limit)*1, 0), 0), qb, SUM((i=hit)*Rate), qa, SUM((i=hit-1)*Rate), tb, SUM((i=hit)*Dates), ta, SUM((i=hit-1)*Dates), IF(hit=0, "none", IF(hit=1, tb, IF(qb>0, ta+(tb-ta)*LN(qa/Limit)/LN(qa/qb), ta+(tb-ta)*(qa-Limit)/(qa-qb))))))

Parameters

Parameter Unit Description
Dates date Forecast dates, one column, in order (Excel date serials)
Rate unit/time Forecast rate on each date, same rows
Limit unit/time Economic-limit rate, in the units of Rate (for example from `PO.RES.Reserves.EconLimit`)

Examples

Invocation Expected
=PO.ECON.COP.Date(45658+SEQUENCE(48,1,0,30), 1000*EXP(-0.002*SEQUENCE(48,1,0,30)), 100) 46809.29255
=PO.ECON.COP.Date({45658;45689;45717}, {150;120;90}, 100) 45706.7453
=PO.ECON.COP.Date({45658;45689;45717}, {90;80;70}, 100) 45658
=PO.ECON.COP.Date({45658;45689;45717}, {150;120;90}, 90) 45717
=IF(ISTEXT(PO.ECON.COP.Date({45658;45689;45717}, {150;120;110}, 100)), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda