Petroleum Goodies

Helpful Tools & Tips in Petroleum Engineering

Excel List Navigator

Free Excel List Navigator: Navigate Your List

List Navigator 2007

This tool simply helps you to filter your data from list and show the selected data. It takes the data from sheet All List and dump the selected data to sheet Selected List. You can do operation from the selected data or simply show them on chart.

This tool can be used for general purpose. In this spreadsheet we use an example to select individual well and show its production and calculate peak rates (oil and gas).

How To Use This Tool?

  1. Put your multiple item list by column (all the way down). Item name could not be in order as long as you have the same item list name.
  2. Click reload button to update item list to drop down menu
  3. To select your item, select item list from drop down toolbar or click the forward or backward buttons.

Rate-Time Spreadsheet

Rate-Time Spreadsheet (RTS) To Estimate Range of Your Reserves

rate-time-spreadsheetThis Excel spreadsheet helps you to calculate range of  production forecast using seven different methods by analyzing gas or oil production (i.e. rate-time) data.

This tool is available for Excel 2003 and 2007 versions. For those who use newer versions of Excel (2010 and later versions) can use the 2007 version. The authors of this tool provide user guide on how use this tool (see download links at the bottom of this page). They also provide examples using tight gas well. For more details, please read SPE papers 116731, 119897, 132352 from OnePetro website.

Calculate Gas Properties

Web-based & Excel Tools To Calculate Dry Gas Properties

It is essential for Petroleum Engineers to make various calculations in order to arrive at certain important figures on dry gas properties when they are engaged in working on their projects. Since these are quite time consuming calculations the presence of a web-based tool that does the calculations when their input figures are entered is of immense benefit for them. What you get in Excel format in this webpage is exactly that. It is a tool that could help them calculate various figures they need. When it comes to dry gas properties you may need inputs such as gas gravity, mole percent of CO2 and H2S, bottom hole pressure and temperature.

Gas Compressibility Factor

Web-based Tool To Calculate Gas Compressibility Factor

The purpose of writing the VBA excel function is to calculate the gas compressibility factor (Z) through JavaScript. This Excel function also aims to be a useful online website tool that can be used by anybody to calculate gas compressibility factor through our website.

About Gas Compressibility Factor

This is a helpful thermodynamic property in modifying the ideal gas law, taking to account the real gas behavior. The gas compressibility factor is a measure of the amount of thermodynamic properties in real gases that deviate from the amount that is expected from ideal gases. The compressibility factor can be considered as the ratio of the volume of real gas to the volume predicted from ideal gas given that the pressure and temperature are similar to that of the volume.

Cumulative Probability Chart

Cumulative Probability Plot (up to 5 series)

This online tool helps you to create cumulative probability chart from your data. To do this, sort your data in ascending order. Next,  calculate percentile rank from your data. The smallest number in your data has the smallest percentile. Then  plot your sorted data versus percentile rank.

Calculate Daily Step Rate from Production Volume

Imagine you have producing gas wells with small amount of liquid production oil or water. Your liquid productions are not producing continuously (intermittent). Your liquid productions are not tied in directly to sales line. Or your wells are located far away from central facilities. Consequently, liquid productions need to be hauled by truck every certain day or every week. As a result, your production data is not in daily rate but in volume collected from certain day.

Modified Hyperbolic Decline Curve (Updated)

Modified Hyperbolic Decline Curve Formula

Hyperbolic Decline Curve with terminal decline

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.(1)

Horizontal Well Landing Position

Visualize Horizontal Well Landing Position Easily

visualize 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:

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