Petroleum Goodies

Sunday, September 2, 2012

Petroleum Goodies: Modified Hyperbolic Decline Curve

Posted: 02 Sep 2012 04:10 AM PDT

Modified Hyperbolic Decline Curve Formula

Extrapolation of hyperbolic declines over long periods of time frequently results in unrealistically high reserves. To avoid this problem, it has been suggested (Robertson) that at some point in time, the hyperbolic decline be converted into an exponential decline.⁽¹⁾

This Excel tool is useful to forecast a gas well from historical production. Historical productions are used to history match to get decline parameters such as initial rate (qi), decline rate (D) and b value. A value of b = 0 corresponds to exponential decline. A value of b = 1 is called harmonic decline. Sometimes, values of b > 1 are observed. This forecasting tool is built using two decline schedules, the first schedule used hyperbolic decline (b > 1) and the second part utilized exponential decline (b = 0). The change in decline type is indicated by switch rate. Decline conversion from effective to nominal (vice versa) has been calculated in this tool.⁽²⁾

Feel free to use this tool and don’t forget to Like it and share it with your friends.

Using VBA macro? No

References:

Fekete Decline Curve Analysis
Schlumberger Oil Field Manager (OFM)

Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts:

Thursday, February 2, 2012

Petroleum Goodies: Horizontal Well Landing Position

Horizontal Well Landing Position

Posted: 02 Feb 2012 05:08 AM PST

Visualize Horizontal Well Landing Position Easily

horizontal well landing position

This is an extended work from the previous tool called Horizontal Toe Direction posted in this website earlier. The objective of this tool is to visualize horizontal well landing position within target zone using horizontal well deviation survey and top and bottom formation data points. Once we plot these survey and tops formation data, we can determine the following information:

Horizontal length
Toe direction
Formation thickness along wellbore
Landing position within target zone
Average depth of horizontal section

How to use:

Select well you want to analyze using scroll button or alternatively, type Well Number (not Well Code) in yellow cell.
Use “Run Batch” button to run multiple well selections.
Update your well list if you have new survey data added from new well.

How to update/change database:

Put your survey data into sheet “Survey”. Required colums: Well Code, Well Name, MD, TVD, DIP, TVDSS, X COORD, Y COORD. Please put them to the same column like in this tool.
Put your top formation into sheet “Top Fromation” and your bottom formation into “Btm Fromation”. These are X-Y-Z data points, Z in TVD subsea.
Enjoy the tool!

Assumptions:

Assumptions may vary depending your needs. The following assumptions apply to the tool.

Horizontal length – calculated from heel to toe. heel defines where dip start >88 deg. This also applies to define category for well landing position and toe direction.
Formation thickness – the distance between top and bottom formations.
Landing position – calculated from average depth of horizontal section related to top and bottom formation. Available for 3 positions (i.e., top, middle, bottom), also for 5 positions.
Toe direction – calculated from average dip of horizontal section from heel to toe. Dip ranges between 90 +/-0.5 deg is called flat.

Version Updates:

Version 1:

First release Feb 2012
Works well with Excel 2003, need some modification in macro to work with Excel 2007.
You need to use Excel 2007 if your data exceed 65000 rows.

Note:

All data provided in this tool are not real data and not related to any company.
To enable copy from Excel range to Powerpoint, you have to add Ms. PowerPoint object library from VBA editor. Click Tools – References and select Microsoft PowerPoint Object Library as shown below, then hit OK. See previous Excel tool that shows you how to add this object library.

Using VBA macro? Yes

Note: There is a file embedded within this post, please visit this post to download the file.

Similar Posts:

Sunday, January 29, 2012

Petroleum Goodies: Horizontal Well Toe Direction

Horizontal Well Toe Direction

Posted: 28 Jan 2012 05:49 PM PST

Visualize Horizontal Well Toe Direction Quickly

horizontal well toe direction

The objective of this tool is to visualize horizontal well toe direction using horizontal well deviation survey. Yes you can do easily if you have less well. What if you have more than 1000 wells? This tool can save your time! Once we plot directional survey data, we can determine the following information:

Horizontal length
Toe direction
Average depth of horizontal section

How to use:

Select well you want to analyze using scroll button or alternatively, type Well Number (not Well Code) in yellow cell.
Use “Run Batch” button to run multiple well selections.
Update your well list if you have new survey data added from new well.

How to update/change database:

Put your survey data into sheet “Survey”. Required colums: Well Code, Well Name, MD, TVD, DIP, TVDSS, X COORD, Y COORD. Please put them to the same column like in this tool.
Enjoy the tool!

Assumptions:

Assumptions may vary depending your needs. The following assumptions apply to the tool.

Horizontal length – calculated from heel to toe. heel defines where dip start >88 deg. This also applies to define category for well landing position and toe direction.
Toe direction – calculated from average dip of horizontal section from heel to toe. Dip ranges between 90 +/-0.5 deg is called flat.

Version Updates:

Version 1: first release Feb 2012

Note:

All data provided in this tool are not real and not related to any company.
To enable copy from Excel range to Powerpoint, you have to add Ms. PowerPoint object library from VBA editor. Click Tools – References and select Microsoft PowerPoint Object Library as shown below, then hit OK. See previous Excel tool that shows you how to add this object library.

Using VBA macro? Yes

Note: There is a file embedded within this post, please visit this post to download the file.

Similar Posts: