production profile- reservoir model and well decline profile in excel.

[vinomarky]

Nothing shrink wrapped - I generally make them as needed. Often assume the following;

Rate potential declines exponentially - that is, Rate Potential = Max Potential x (1-(Cum Produced/EUR))
You would cap this rate at maximum of plateau rate

For economic screening this is often a surprisingly good approximation, as any aquifer effects in gas reservoirs are usually late time, and with discounted cash flow are generally second order in terms of their effect on NPV

With gas condensate, you often drop some liquids out in reservoir during depletion, meaning you have leaner gas later in life. In absence of anything else, assume straight line from initial CGR to 0.25 x Initial CGR with similar equation

So, you enter 4 variables;
EUR
Max rate potential
Plateau rate
Initial CGR

Then simply calc 6 columns with each time step;
Rate potential, Truncated Rate, Gas vol produced, Cond Vol Produced, Cum Gas Produced, cum Cond produced
Repeat
Repeat