Sinclair Petroleum Engineering, Inc.

The Excel workbook "Gas Prop" is available for download here.

Two pseudo-critical properties worksheets are included depending upon availability of gas composition or specific gravity.

“Gas Prop” calculates standard gas properties and integrated pseudo-pressures in 25 psi increments.
“BHP” calculates a flowing bottom-hole pressure from surface pressure.
“Onept” estimates permeability from a one-point flow test – useful in tight gas.
“Unload” uses the Li method to calculate the minimum gas rate for continuous liquid removal.

I coded using VBA and the modules are not password protected --modify as you see fit. I have used since 2003 without problems but make no guarantees. Use at your own risk.

Note: All user inputs in blue.