Petroleum Goodies

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:

Saturday, December 17, 2011

Petroleum Goodies: Calculate Gas Compressibility

Calculate Gas Compressibility

Posted: 17 Dec 2011 05:00 AM PST

Excel Function To Calculate Gas Compressibility

calculate gas compressibility

This Excel tool is very helpful to calculate gas compressibility (Cg). This gas properties is estimated from gas formation volume factor that has been calculated from the previous post. On input, you have to provide gas specific gravity (air=1), gas composition (CO2 and H2S), and temperature. Gas formation volume factor calculation is provided in this tool. Gas compressibility is asymptotically approached as the pressure decrease.

Use VBA macro? Yes

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

Similar Posts:

Sunday, December 11, 2011

Petroleum Goodies: Calculate Gas Formation Volume Factor

Calculate Gas Formation Volume Factor

Posted: 10 Dec 2011 09:11 AM PST

Excel Function To Calculate Gas Formation Volume Factor

calculate gas formation volume factor

This Excel tool is very helpful to calculate gas formation volume factor (Bg). This gas properties is estimated from gas viscosity and compressibility factor that have been calculated from the previous posts. On input, you have to provide gas specific gravity (air=1), gas composition (CO2 and H2S), and temperature. Gas compressibility factor and viscosity calculations are provided in this tool. Gas formation volume factor is asymptotically approached as the pressure decrease.

Note: Gas compressibility factor is calculated using Dranchuk and Abou-Kassem equation. Gas viscosity is estimated from Lee, Gonzales and Eakin equations.

Use VBA macro? Yes

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