Petroleum Goodies: 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:

Petroleum Goodies

Thursday, February 2, 2012