Petroleum Goodies

Saturday, December 17, 2011

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

Tuesday, November 22, 2011

Petroleum Goodies: Excel Production Plot Template

Excel Production Plot Template

Posted: 21 Nov 2011 09:25 PM PST

Excel Production Plot Template To Visualize Your Data Quickly

This Excel production template version 2 is very useful to visualize your production data from different wells. This version 2 is different way to lookup your data compare to version 1 that uses array formula. This method uses INDIRECT Excel function that allows you to create Excel formula based on input string. Please note that you have to name your well list (see tab “List”) exactly the same with sheet name. This method allows you to put well data by sheet.

This chart is set up to 3 series but you can add more. Just add your production data in new sheet from different wells as long as you want. Then, add/update formula in sheet Plot Data and Plot. Please note that red cell is calculated data, yellow is input.

Hint: This version 2 template is running faster than previous version because version 2 is not using 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: