Calculate Gas Compressibility

This Excel function calculates gas compressibility (Z factor) for natural gases based on equation of state from Dranchuk and Abou-Kassem.

This tool also includes intermediate calculation such as calculating pseudocritical pressure and temperature.

References:

1. Dranchuk, P.M., and Abou-Kassem, J.H.: “Calculation of Z Factors For Natural Gases Using Equations of State,” J. Cdn. Pet. Tech. (July-Sept., 1975) 34-36.


2. “Theory and Practice of Testing Gas Wells”, 3rd. Edition (1975) Energy Resources Conservation Board 603 6th. Ave. S.W. Calgary, Alberta, Canada.

Use VBA macro? Yes

Calculate Gas Compressibility

[File size: 21.3 KiB - Hits: 305 - Type: Excel file in zipped folder]