Tuesday, March 29, 2011

Petroleum Goodies: Petroleum Engineering Calculations

Petroleum Goodies: Petroleum Engineering Calculations

Petroleum Engineering Calculations

Posted: 29 Mar 2011 02:35 AM PDT

Excel Petroleum Engineering Calculations

This is very useful Excel functions for petroleum engineering calculation that build in Excel add-ins. It consists of formulas and calculations that commonly used in petroleum engineering including PVT correlations, pipe flow, and table lookup/interpolation.

It has a help file that explains formula calculation such as description of the function and syntax how to use it. It doesn’t have the math formula written in its help file. But you still can look for it in the reference from help file.

This Excel petroleum engineering calculation add-ins is written in VBA code. Unfortunately, it’s password protected so we can’t see the macro or calculation to check if the formula is correct. But it’s good to try the tool though.

How to use this tool?

  1. Download zipped file from the following link and extract the file to your local hard drive.
  2. Open Microsoft Excel (minimum version 7.0), click Tool | Add-Ins and then browse the extracted file named Epecvb.mod.xla.

Use VBA macro? Yes

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

Similar Posts:

Posted by R. Pratama at 1:30 PM 0 comments

Friday, March 18, 2011

Petroleum Goodies (in this message: 7 new items)

Petroleum Goodies (in this message: 7 new items)

Single Point Test

Posted: 18 Mar 2011 10:00 AM PDT

Single Point Test: this test consists only of an extended flow period. An estimate of the degree of turbulent flow in the formation is required by this test. This estimate is often based on information provided by other wells in the same formation or calculated from reservoir and fluid properties.

Similar Posts:

Modified Isochronal Test

Posted: 18 Mar 2011 03:53 AM PDT

Modified Isochronal Test: similar to isochronal test which perfoms that each shut-in period between flow periods should be of the same duration as each flow period. It requires an extended flow period as well.Similar Posts:

    None Found

Isochronal Test

Posted: 18 Mar 2011 03:42 AM PDT

Isochronal Test: type of deliverability test which is conducted by producing a well at several flow rates for the same duration periods. The duration of period requires much less than the time required for stabilization.

This test perfoms a long shut-in to allow well reach essentially static conditions between each flow period. Moreover, this test also requires an extended flow rate, long enough to acquire stable pressure.

This isochronal test is not practical in low permeability tight reservoirs since it requres long time to reach pressure stabilization between flow periods.Similar Posts:

    None Found

Back Pressure Test

Posted: 18 Mar 2011 12:03 AM PDT

Back Pressure Test: type of deliverability test which is conducted by flowing a well at different rates. Each production rate is maintained until pressure stabilization has been reached and the radius of investigation has reached the outer edge of the drainage area. This type of test is useful for high permeability reservoirs because the time to reach pressure stabilization for each rate is reasonable.

Similar Posts:

Simplified Analysis

Posted: 17 Mar 2011 08:13 PM PDT

Simplified Analysis: a method to calculate absolute open flow (AOF) or deliverability of well. This method using C & n to estimate the AOF. In most cases the simplified analysis is sufficient to determine the AOF and deliverability. If you have turbulance as dominant flow and the extrapolation to the AOG is large, you can use Laminar Inertial Turbulent (LIT) analysis which is more rigorous than simplified analysis.
Similar Posts:

Laminar Inertial Turbulent

Posted: 17 Mar 2011 07:44 PM PDT

Laminar Inertial Turbulent: a method to analyze absolute open flow (AOF) of well, other method is called simplified analysis using C & n method. LIT method is usually used in well test where the extrapolation to the AOF is large and turbulence is dominant and the well rate is high. This method is more accurate than simplified method.

Similar Posts:

LIT

Posted: 17 Mar 2011 07:44 PM PDT

LIT: Laminar Inertial Turbulent, see AOF calculation using Laminar Inertial Turbulent.

Similar Posts:

Posted by R. Pratama at 1:10 PM 0 comments

Wednesday, March 16, 2011

Petroleum Goodies (in this message: 7 new items)

Petroleum Goodies (in this message: 7 new items)

FDL

Posted: 15 Mar 2011 03:22 PM PDT

FDL: Floating Datum Line, see floating datum line.Similar Posts:

Floating Datum Line

Posted: 15 Mar 2011 03:21 PM PDT

Floating datum line: represents travel time between the recording surface and the zero line (generally sea level). This travel time depends on rock type, how weathered the rock is, and other factors. Similar Posts:

Topographic Elevation

Posted: 15 Mar 2011 03:20 PM PDT

Topographic elevation: is the height above sea level of the surface along which the seismic data were acquired. Similar Posts:

CDP

Posted: 15 Mar 2011 03:19 PM PDT

CDP: Common Depth Points, common reflecting point at depth on a reflector or the halfway point when a wave travels from a source to a reflector to a receiver.Similar Posts:

Common Depth Points

Posted: 15 Mar 2011 03:18 PM PDT

Common Depth Points: common reflecting point at depth on a reflector or the halfway point when a wave travels from a source to a reflector to a receiver.Similar Posts:

Two Way Time

Posted: 15 Mar 2011 03:17 PM PDT

Two Way Time (TWT): indicates the time required for the seismic wave to travel from a source to some point below the surface and back up to a receiver

Similar Posts:

TWT

Posted: 15 Mar 2011 03:15 PM PDT

TWT: Two Way Time, indicates the time required for the seismic wave to travel from a source to some point below the surface and back up to a receiver

Similar Posts:

Posted by R. Pratama at 1:08 PM 0 comments

Saturday, March 12, 2011

Petroleum Goodies (in this message: 4 new items)

Petroleum Goodies (in this message: 4 new items)

MFC

Posted: 11 Mar 2011 02:47 PM PST

MFC: Micro-Flux Control

Similar Posts:

    None Found

MPD

Posted: 11 Mar 2011 02:43 PM PST

MPD: Managed Pressure Drilling, See alo PMCD.

Similar Posts:

LCM

Posted: 11 Mar 2011 02:42 PM PST

LCM: Lost of Circulation Material

Similar Posts:

    None Found

PMCD

Posted: 11 Mar 2011 02:40 PM PST

PMCD: Pressurized Mud Cap Drilling, a drilling technique where the pore and fluid loss gradient are virtually the same, resulting in total mud losses and kicks in the same hole section.
Similar Posts:

Posted by R. Pratama at 1:22 PM 0 comments

Friday, March 11, 2011

Petroleum Goodies (in this message: 2 new items)

Petroleum Goodies (in this message: 2 new items)

FTP

Posted: 11 Mar 2011 02:58 AM PST

FTP: Flowing Tubing Pressure, see also FTHP.Similar Posts:

MWD

Posted: 11 Mar 2011 02:56 AM PST

MWD: 1) Measurement While Drilling. 2) Maximum Well Deliverability, maximum gas or oil that can be produced through pipeline.Similar Posts:

Posted by R. Pratama at 1:21 PM 0 comments

Thursday, March 10, 2011

Petroleum Goodies (in this message: 10 new items)

Petroleum Goodies (in this message: 10 new items)

Joint

Posted: 09 Mar 2011 05:34 PM PST

Joint: A single length (30 feet or 9.1 meters) of drill pipe, drill collar, casing, or tubing that has threaded connections at both ends. Several joints screwed together constitute a stand of pipe.

Similar Posts:

    None Found

Influx

Posted: 09 Mar 2011 05:31 PM PST

Influx: An intrusion of formation fluids into the borehole, i.e. water influx.Similar Posts:

    None Found

FBHP

Posted: 09 Mar 2011 05:28 PM PST

FBHP: Flowing Bottom Hole Pressure, pressure at bottom hole of reservoir when flowing. See also BHP.Similar Posts:

BHP

Posted: 09 Mar 2011 05:27 PM PST

BHP: Bottom Hole Pressure, pressure at bottom hole of reservoir. Also called sandface pressure.Similar Posts:

    None Found

FWHP

Posted: 09 Mar 2011 05:26 PM PST

FWHP: Flowing Well Head Pressure, pressure of wellhead during flow. See also FTHP.Similar Posts:

FTHP

Posted: 09 Mar 2011 05:25 PM PST

FTHP: Flowing Tubing Head Pressure, pressure of wellhead during flow.Similar Posts:

THP

Posted: 09 Mar 2011 05:24 PM PST

THP: Tubing Head Pressure, pressure at wellhead.Similar Posts:

    None Found

Y Axis

Posted: 09 Mar 2011 05:18 PM PST

Y axis: The vertical axis of a two-dimensional cartesian coordinate system.
Similar Posts:

    None Found

X Axis

Posted: 09 Mar 2011 05:17 PM PST

X axis: The horizontal axis of a two-dimensional cartesian coordinate system.
Similar Posts:

    None Found

Q

Posted: 09 Mar 2011 05:14 PM PST

Q (or q in lower case): Nomenclature for gas rate.Similar Posts:

    None Found

Posted by R. Pratama at 1:44 PM 0 comments

Wednesday, March 9, 2011

Petroleum Goodies (in this message: 10 new items)

Petroleum Goodies (in this message: 10 new items)

Conversion Factors

Posted: 09 Mar 2011 09:00 AM PST

Oil & Gas Volume Conversion Factors

Another handy note for commonly used unit conversion in oil and gas industry related to volume.

1 bbl (Barrel) = 158.987 liters
CF = cubic feet
MCF (thousand cubic feet) = 10^3 cubic feet
MMCF (million cubic feet) = 10^6 cubic feet
BCF (billion cubic feet) = 10^6 cubic feet
TCF (trillion cubic feet) = 10^12 cubic feet
5487 CF gas equivalent with 1 boe (barrel oil equivalent)
6 BCF gas equivalent with 1 mmboe (million barrel oil equivalent)

Metric Conversions
1 meter = 3.281 feet
1 foot =  0.3048 meters
1 CF = 0.0283 cubic meters
1 cubic meter = 35.315 CFSimilar Posts:

CBM

Posted: 09 Mar 2011 03:48 AM PST

CBM: Coal Bed Methane, a form of natural gas extracted from coal bedSimilar Posts:

Possible

Posted: 09 Mar 2011 03:44 AM PST

Possible: An estimate of the volume of hydrocarbons in the trap area that possibly exist. 3P is then proved plus probable plus possible volumes.
Similar Posts:

Probable

Posted: 09 Mar 2011 03:44 AM PST

Probable: Hydrocarbon volume considered likely (probable) to have been found by the drilling of the well, given the mapping that has taken place. 2P is then proved plus probable volumes.
Similar Posts:

Proved

Posted: 09 Mar 2011 03:44 AM PST

Proved: Hydrocarbon volume considered to be proven by the drilling of the well. There is a very high chance that this volume exists in the ground around the well bore.
Similar Posts:

GSA

Posted: 09 Mar 2011 03:41 AM PST

GSA: Gas Sales Agreement. Commonly used in gas sales contract.Similar Posts:

    None Found

MDQ

Posted: 09 Mar 2011 03:40 AM PST

MDQ: Maximum Daily Quantity, maximum amount of gas that can be delivered to buyer as per gas contract agreement.Similar Posts:

    None Found

TOP

Posted: 09 Mar 2011 03:39 AM PST

TOP: Take or Pay, minimum gas demand that required by buyer to pay.Similar Posts:

    None Found

DCQ

Posted: 09 Mar 2011 03:37 AM PST

DCQ: Daily Contract Quantity, amount of daily demand from gas sales contract.Similar Posts:

    None Found

ROT

Posted: 09 Mar 2011 03:36 AM PST

ROT: Rate of Take, predicted gas demand of gas sales agreement.RSimilar Posts:

    None Found

Posted by R. Pratama at 1:23 PM 0 comments

Tuesday, March 8, 2011

Petroleum Goodies: Standard Pressure

Petroleum Goodies: Standard Pressure

Standard Pressure

Posted: 07 Mar 2011 06:46 PM PST

Standard Pressure in North America

Standard pressure in enginerring calculation may vary by location and country. It might not contribute huge error in your calculation but good to get the right number. Below just an example of standard pressure in North America.

Location Standard Pressure (psia)
Alaska State Lands 14.65
Arkansas 14.65
California 14.73
Colorado 15.025
Illinois 14.65
Kansas 14.65
Louisiana 15.025
Michigan 14.73
Mississippi 15.025
New Mexico 15.025
Oklahoma 14.65
Texas 14.65
Utah 15.025
West Virginia 14.85
Wyoming 15.025
US Federal Leases 14.73
Canada 14.696

Reference: Hewlett-Packard HP-41C Petroleum Fluids Pac handbook except for the Alaska State Lands value.

Similar Posts:

Posted by R. Pratama at 1:13 PM 0 comments
Subscribe to: Posts (Atom)