Petroleum Goodies

Horizontal Well Landing Position

Visualize Horizontal Well Landing Position Easily

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:

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

How to update/change database:

1. 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.
2. 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.
3. 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

Download Horizontal Well Landing Position
[File size: 1.8 MiB - Hits: 116 - Type: File in zipped folder]

Horizontal Well Toe Direction

Visualize Horizontal Well Toe Direction Quickly

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:

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

How to update/change database:

1. 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.
2. 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.
• Stay tune on this website to get next tool on how to visualize horizontal well landing position easily.

Using VBA macro? Yes

Download Horizontal Well Toe Direction
[File size: 234.4 KiB - Hits: 93 - Type: File in zipped folder]

Calculate Best Initial Production

Calculate Best Initial Production Automatically

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:

1. 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.
2. Run this tool using above procedure.

Using VBA macro? Yes

Download Calculate Best Inital Production
[File size: 158.9 KiB - Hits: 153 - Type: File in zipped folder]

Petroleum Glossary

Term and Glossary in Oil & Gas Industry

Here are some terms and glossaries in oil & gas industry. To find your glossary please use Ctrl-F and type the word. Not found your glossary? Or want to send your own glossary? Please contact us.

abandonment costs, abnormal pressure, absolute open flow potential, absolute permeability, air gun, anticlinal trap, anticline, api, api gravity, apparent velocity, back pressure test, back-pressure, barrel, barrel of oil equivalent, basin, bcf, bhp, bopd, cbm, cdp, closure, coal seam gas, common depth points, compressor, condensate, csg, damaged zone, dcq, drill stem test, dry hole, dst, exploration well, fault, fault trap, fbhp, fdl, field, floating datum line, formation, fthp, ftp, fwhp, gas in place, geology, geophysics, giip, gip, gsa, horizon, hydrocarbon pay, hydrocarbons, influx, isochronal test, joint, laminar inertial turbulent, lcm, lead, licence, lit, lithology, log interpretation, mdq, mfc, migration, mmbbl, mmcfd, modified isochronal test, mpd, mwd, neutron porosity, normal fault, ogip, oil, oil-base mud, p-wave, permeability, permian, petroleum, pigging, pmcd, possible, potential, probable, prospect, q, quartz, recoverable gas, recoverable oil, reserves, reservoir, reverse fault, rot, s-wave, sandstone, seal, sediment, seismic survey, show, sidetrack, sidewall core, simplified analysis, single point test, tail pipe, tally, thp, top, topographic elevation, trap, trend, two way time, twt, underbalance, unitization, velocity survey, water-base drilling mud, wireline log, x axis, x-ray diffraction, x-ray fluorescence, xrd, xylene, y axis, yield, young’s modulus, zone

Please read our Disclaimer before using this tool.

If you like this website and find it useful, please share this with your colleagues.