ExcelBanter - Modeling Non Linear Depletion Rates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Modeling Non Linear Depletion Rates (https://www.excelbanter.com/excel-discussion-misc-queries/445442-modeling-non-linear-depletion-rates.html)

Modeling Non Linear Depletion Rates

I am trying to model a non linear depletion rate of a natural gas well. Is
there a function in Excel that would let me model something like a log
normal depeletion of 100% of a resource, starting with say a 60% decline in
year one? What would the Excel formula for this look like? The well will
continue for 10 to 20 years.

--
W

All times are GMT +1. The time now is 07:12 PM.