Calculating Depletion for Oil & Gas Wells

[Jlafber]

I'm new to access and figured it would be a good time to learn this program. I'm curious if there would be an easy way to perform the following

1) I need to run queries to find totals for each oil & gas well within a spacing unit
2) A spacing unit is based on township-range-section grid numbers
3) A spacing unit includes two section and so 150-90-1 and 150-90-12 would be a spacing unit
4) Within this section there might be 6 wells with unique Well #s

Currently I have the detail on a well-by-well basis. I'm just not sure how to get access to auto-recognize a spacing unit. The spacing units always follow the same logic. So for example Section 1/12 2/11 3/10 etc are all one spacing unit. There are thousands of wells and so the task needs to be automated.



Any tips or ideas would be appreciated. It would be great if Access could take the well data and then auto sort the wells into spacing units and provide subtotals.

[rpeare]

let's focus on one block of 36 wells so 150-90-1 through 150-90-36
each block is represented by 3 different spacing units
150-90-1 - 150-90-12
150-90-13 - 150-90-24
150-90-25 - 150-90-36
Within the spacing unit 150-90-1 - 150-90-12 there may be 6 wells
I am assuming that there can only be 1 well per block within the spacing unit, in other words unit 150-90-1 could not have 2 wells in it, or could it?

I think regardless of this if you are recording the well number and the grid from which it came it should be fairly easy to choose a township and range then select a spacing unit and show the data relevant to that spacing unit.

For instance you could have a table

tblSpacingUnitGroups
SUG_ID  SUG_Seq  SUG_Lower  SUG_Upper
1       1        1          12
2       2        13         24
3       3        25         36

Then when you run your query against a group of wells after having chosen township and range you would select a spacing unit group from a list which would translate the last digit(s) of the 'code' to determine which wells belong in your query.

You could also go more brute force like this

 tblSpacingUnitGroups
SUG_ID  SUG_Group  SUG_Number
1       1          1
2       1          7
3       1          12
...
10      2          13
11      2          16
15      2          24
...
20      3          25
21      3          36

then you could just strip off the last character and make sure it matched the group you were looking for.

[Jlafber]

Here is another map that shows the well locations within a spacing unit. The dark lines are horizontal drilling. There is usually multiple wells within a spacing unit. The purple shading is indicating that Section 17/20 is one spacing unit and there might be 7 wells in this unit. You can see the other spacing unit pairs (30/31, 29/32, 21/28, 24/25 etc). All of North Dakota follows this same logic for the most part.

Ideally the querry would be able to provide a summary for all pairs for all township/ranges by spacing unit. I would be looking to sum total revenue, barrels extracted, ending reserves, etc. Currently all this information is tracked only at the well.

[rpeare]

If the logic in my first post correctly defines the block/spacing group then the method should be sound for anything you're doing. All you'd have to do then is record the in/out volumes and figure out a method to figure the cost (i.e out units * barrel cost on that day). This doesn't outwardly appear to be a very difficult database to build. Is there something in particular that is causing you an issue?

[Jlafber]

Thanks rpeare. I'm going to play with it and appreciate your help!

[Jlafber]

That works perfectly!