Note: In order to use the spreadsheet examples, you need to download Business Functions
|ProdProf (Time, Base, ResvsOrDcRate, FromDates, AnnualRates, DeclinePoint, AbandonRate, [DeclineParam], [DayCount], [Periods], [ProjMode], [PPSwitch])|
|Generate an oil production profile based on pre-determined production rates and a decline curve|
|The function generates a complete production profile for an oilfield from the first production, through the plateau period, into the decline and to abandonment. It works by first of all doing a stepped constant rate as production builds up. Production s|
|Auto Array Function|
Whats good or unique about it
ProdProf is a very quick way of getting a sensible production profile for an oil or gas field. Just set one or more AnnualRates, decide the DeclinePoint and AbandonRate, use the defaults for most of the others and you have a production profile, that you can run on any timebase (quarterly, annually etc).
This decline function calculates the decline factor internally based on the plateau rate, the abandonment rate, and the reserves. To see what decline factor it calculated, use the Trace facility.
TemplatesThis function features in the following downloadable spreadsheet template(s):