GasCalc - gas column calculation

This program calculates the Shut In Wellhead Pressure (when it is given the reservoir pressure) for a well full with gas, and the Reservoir pressure in static and flowing conditions (steady flow) when the wellhead pressure is known.

The calculation is done by the Cullender-Smith method. The gas viscosity is based on the Carr, Kobayashi and Burrows for gas mixtures corrected for mixtures with N2, CO2 and H2S. The compressibility factor is calculated with Peng - Robinson equation of state:

The program should be used for vertical or near vertical wells.
The spreadsheet was tested on Windows XP with Office XP installed - English version.