Click highlights to download macro-enabled Excel workbooks Gasprops or BHFP-Unload.
Two pseudo-critical properties worksheets are included depending upon availability of gas composition or
specific gravity.
"Gasprop" calculates standard gas properties, pseudo-pressure, and pseudo-pressure with k(p)
"BHP" calculates a flowing bottom-hole pressure from surface pressure using Cullender and Smith or Hagedorn
and Brown.
"Unload" uses the well known Turner 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.