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

Calculate Gas Compressibility Factor
Calculate Pseudocritical Pressure and Temperature
Calculate Gas Viscosity
Gas Properties Calculator
Calculate Friction Factor

Petroleum Goodies

Sunday, December 11, 2011