Need help building a Gas well Decline Model

**johnsoncj2002** · 11-22-2011, 12:18 PM

I need help building a Gas Well Decline Curve spreadsheet based on the following assumptions:
1.) # of rigs (determines how often a new well flows)
2.) Typcial Gas Well decline curve (I have this already)
3.) First well flow date

I have a spreadsheet I can post to get us started.

Objective: Have an assumption worksheet that defines the Assumptions above with the ability to "toggle" the number of rigs....then this assumption worksheet feeds the decline curve model.

Example. 1 rig drills a new well every 45 days. This 1 well has volume and declines (monthly). Then if I can toggle the number of rigs (2 or 3) then this reflects in the curve model

I hope this makes sense to someone out there.

Thanks.

**royUK** · 11-22-2011, 12:21 PM

One well every 45 days is good going, better rigs than we have here!

Post the example

**johnsoncj2002** · 11-22-2011, 12:35 PM

Can we do this privately?

**johnsoncj2002** · 11-22-2011, 01:16 PM

Okay....I'll post the example on here. Are you still there?

**johnsoncj2002** · 11-22-2011, 03:35 PM

Assumptions:
1.) How many wells (example: 100)
2.) First Flow Date (example: 04-01-11)
3.) Number of Drilling Rigs (example: Table with up to 4 Rigs)
- If 1 Rig - new well every 45 days
- If 2 Rigs - new well every 30 days
- If 3 Rigs - new well every 15 days
- If 4 Rigs - new well every 7 days
- Need the option to change the variables on the intervals (example: every 45 might be 40)
4.) Typical Well Volume (1 well example)

So...in my table (assumptions worksheet). I indicate 100 wells with 1 rig starting 04-11-11 and this is my Gas Volume/Decline rate for 1 well. Then the macro (or forumula) creates the Forecast worksheet. The macro/formula genterats the number of total wells...then inputes the start date..then based on the number of rigs (1) then every 45 days (my example shows 60) a new column is populated.