Gas Compressibility Factor Spreadsheet Calculator

Engineering Excel Spreadsheet Downloads
Fluid Flow Design and Engineering
Hydraulic and Pneumatic Design and Engineering

Gas Compressibility Factor Spreadsheet Calculator

Equation 9 of the IEC and ISA control valve sizing equation standards, rearranged to solve for Cv, is:

Gas Compressibility Factor Spreadsheet Calculator

were N9 is a constant that depends on the engineering units that will be used in the calculation.

This equation uses upstream pressure, upstream temperature, the molecular mass of the gas and the compressibility factor (Z) of the gas to include the upstream density of the gas in the Cv calculation. (I have highlighted "Z" in red, because that is the subject of this Excel worksheet.) The IEC/ISA standards include Z in their equation, but they do not make any suggestion as to how to determine its value. The compressibility factor is included to correct what would otherwise be the density based on the "Ideal gas equation" for the behavior of a real gas. The Ideal gas equation assumes that there is no interaction between gas molecules which in many cases there may be. It turns out that many of the gasses used in industrial processes, at the temperatures they are often used , have minimal interaction between molecules, so assuming that the Ideal gas equation is sufficient can be satisfactory for control valve sizing purposes. Entering a value of 1.0 for Z causes Equation 9 to use a density based on the Ideal gas equation. In cases where Z turns out to be significantly different than 1.0 the result can be mis-sizing of a control valve. For example, if the actual compressibility factor is 0.7, but a value of 1.0 is used in the calculation, the calculated Cv will be about 20% high.

Note: Accessing this resource requires an active Premium Membership with Engineers Edge

Download:

Gas Compressibility Factor Spreadsheet Calculator

Preview

Gas Compressibility Factor Spreadsheet Calculator

Contribute Article
Spider Optimizer

© Copyright 2000 - 2017, by Engineers Edge, LLC www.engineersedge.com
All rights reserved
Disclaimer | Feedback | Advertising | Contact


User Reviews/Comments:

There are currently no comments available.


Add a Comment (you must be logged in to post comment Register):
Name:
Email: (Optional)
Comment: