Petroleum Goodies: January 2012

Sunday, January 29, 2012

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

Friday, January 27, 2012

Petroleum Goodies: Calculate Best Initial Production

Calculate Best Initial Production

Posted: 26 Jan 2012 07:43 PM PST

Calculate Best Initial Production Automatically

calculate best inital production

It’s not hard to calculate best 30, 60, 0r 90-day average of initial production manually. What if you have many wells, let say more than 100 wells? This Excel tool is useful to determine initial production based on certain number of days. In addition to that, this tool has capability to exclude downtime, for example you don’t want to include production rates that are less than a specified cut off rate. For quality control purposes, this tool provides chart showing original production before and after applying cut off rates.

How to run this tool:

Select well by clicking scroll button, or alternatively you can type well number in yellow cell.
Update your well list by clicking “Update Well List” button if you have production data from new well that is not on the list. Please note that this button will erase the previous outputs that have been generated before. If you want to keep the previous results, do not use this update button, just add your well name manually into Main sheet after adding new well production data into Prod Data sheet.

How to update production data:

Put your production data with the same format with this template into sheet “Prod Data”. You do not need to worry about the order of the well or production data. This tool will sort them for you.
Run this tool using above procedure.

Using VBA macro? Yes

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

Similar Posts:

Monday, January 16, 2012

Petroleum Goodies: Post Audit Production Template

Post Audit Production Template

Posted: 15 Jan 2012 08:36 PM PST

Production Template for Post Audit Review

post audit production template

This is Excel production template for post audit review. To use this tool you must have the following:

Target production rate before you drill wells.
Actual production from your wells after drilling wells.

Put your actual and target production rate in column mode starts with well name actual date and production rate in monthly basis. Your target production rate must be in month 1, 2, 3, etc. Add your new well name into Well list sheet. Extend existing formula if needed.

Use drop down cell to select different wells and to compare target versus actual production. This excel production template will look up the data based on well name you select using an array Excel function. therefore, well name must be exactly the same between actual and target production data.

Notes:

Some calculation uses EOMONTH excel function to determine number of maximum days in a month. This requires add-ons Analysis ToolPak and Analysis ToolPak – VBA to be turn on. To do this go to Tools, Add-ons and then select add-ons Analysis ToolPak and Analysis ToolPak – VBA .
This template using array formula that covers row up to 20000 for your production data (Actual and Target). You can extend this range if needed.
When adding new wells or new production data for existing wells, just add the data at the end row of Actual or Target sheets.
You must extract file to run array formula.

Use VBA macro? No

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

Similar Posts: