Calculate Gas Formation Volume Factor

Excel Function To Calculate Gas Formation Volume Factor

Petroleum Goodies

Helpful Tools & Tips in Petroleum Engineering

Calculate Gas Formation Volume Factor

Excel Function To Calculate Gas Formation Volume Factor

excel 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

Please sign in to download this tool. If you haven't signed up yet, please register here.

Related Posts:

We advise you to read our Disclaimer before utilizing this tool. If you find our tool useful or easy to use, please consider donating a few bucks through Paypal or please take the time to share this site to your colleagues.

Recommended Petroleum Engineering Books

Comments

What do you think of this tool? Say something here!

You must be logged in to post a comment.