The basic gas control valve sizing equation can be found in ISA-75.01.01-2012, "Industrial-Process Control Valves, Part 2-1: Flow Capacity", and in "IEC 60534-2-1 (Second Edition)." These standards show the valve sizing equation to take this form when arranged to be solved for "C":

**valve sizing equation **

C is defined as being either C_{v} or K_{v} (calculated required valve capacity) depending on the value of N_{6}. This equation requires a value for the upstream gas density where the symbol for density is p (rho). The equation assumes that the user knows an accurate density value. There are accurate tables for a few gases, the best example being steam, but such accurate information is not readily available for most industrial gases. The standards (the ISA and IEC standards are, for all practical purposes, identical) make allowance for this by including two additional equations.

These equations, one based on mass flow units (symbol W) and one on volumetric flow units at standard conditions (symbol Q_{s}) substitute for the upstream density a calculation of density based on the ideal gas equation using the molecular weight of the gas, its upstream pressure, and upstream temperature. To correct for the fact that a gas density calculation using the ideal gas equation does not always duplicate actual behavior, the standards include the compressibility factor (symbol Z) to include the degree to which a particular gas does not follow ideal gas behavior.

The equation for mass flow is:

**equation for mass flow **

A method for determining the value to use for the compressibility factor is outside the scope of the standards.

Experience has shown that for most gases used in industrial processes, and at the pressures and temperatures that they are normally used, for valve sizing purposes, assuming a compressibility factor of 1.0 is usually (but not always) sufficient. There are equations of state that predict the real density of gases, with varying degrees of accuracy. Some of these are included with piping system analysis applications. These applications can be expensive, at least from my point of view.

### Spreadsheet Development Background

In 1987, when I was developing Hammel-Dahl's first control valve sizing application, I chose to use Van der Waals equation of state, though not as accurate as more complex equations, to account for the non-ideal behavior of gases. Advantages of using Van der Waals equation is that it is fairly simple and can be written in terms of the compressibility factor, and the reduced pressure and reduced temperature of the gas^{1}:

**Van der Waals equation **

It is significant to note that this is of the same form as the generalized compressibility chart, namely, Z = ƒ(P_{r}, T_{r}). An iterative solution is required.

In later years, whenever I needed to size a valve for gas service when I suspected that the compressibility might become a factor, I would look up the compressibility factor using the Nelson-Obert Generalized Compressibility Charts.

Some time ago, I got tired of reading the charts, which requires some visual interpolation (and eye strain) and made a Microsoft Excel sheet where I tabulated many reduced pressure and reduced temperature points from the Nelson-Obert charts and included a two-dimensional interpolation scheme that yields a compressibility factor for most gases for which I can find the critical pressure and temperature. The use of this spreadsheet is the topic of this article.

Figure 1 is a screenshot of the sheet showing a calculation for carbon dioxide. The calculation in figure 1 shows a compressibility factor of 0.7. In this case, assuming a compressibility factor of 1.0 when it is really 0.7 would result in a C_{v} calculation that would be about 20 percent high. When the compressibility factor decreases, so does the calculated required valve capacity (C_{v} or K_{v}).

*Figure 1. Calculation for carbon dioxideprocess data for this application yields a compressibility factor of 0.70.*

The worksheet can be downloaded at no charge here.

### Spreadsheet Construction Procedure

The Gas Compressibility Factor for Control valve Sizing worksheet can also be constructed using the following instructions:

*Screen 1. User interface.*

**Screen 2. Unit conversion inputs **

*Screen 2. Unit conversion inputs.*

**Screen 3. Calculations. **

*Screen 3. Calculations.*

**Screen 4. Worksheet Table 1. **

*Screen 4. Worksheet Table 1.*

**Screen 5. Worksheet Table 2. **

*Screen 5. Worksheet Table 2.*

### Creating the worksheet.

Create an Excel worksheet based on Screen 1 through Screen 5. In these images, color coding of worksheet entries is as follows:

- Black cell entries are text typed into the cell.
- Red cell entries are formulas that are listed in Table A and must be typed into that cell.
- Green cell entries are copies of each red cell entry, but instead of typing in the formula, copy the formula in the red cell and paste it into the three cells to the right of the red cell.

**Table A. Formulas to be entered into the Excel sheet. **

*Table A. Formulas to be entered into the Excel sheet.*

There are two tables in the worksheet: Table 1 in Screen 4. and Table 2 in Screen 5. Type in the numerical values as shown. Then name the tables by highlighting the data shown inside the red box, and from the Excel Formulas tab, select "Define name" and type in the name of the table (TABEL1 or TABLE2) and click OK.

The Nelson-Obert charts are said to have an accuracy within 1 to 2 percent for Z values greater than 0.6 and within 4 to 6 percent for Z values of 0.3 to 0.6. The generalized compressibility factor graphs may be considerably in error for strongly polar gases, with errors as great as 15 to 20 percent.

The quantum gases hydrogen, helium, and neon do not conform to the corresponding states behavior and the reduced pressure and temperature for those three gases should be redefined in the following manner to improve the accuracy of predicting their compressibility factors when using the generalized graphs:

**where temperatures are in Kelvin and pressures are in atmospheres. **

*Where temperatures are in Kelvin and pressures are in atmospheres.*

The worksheet is valid for reduced pressures between 0.0 and 20 and for reduced temperatures between 1.0 and 15. The Nelson-Obert low pressure chart gives some data for reduced temperatures less than 1.0, but there is not enough data to lend it to the present method of tabulating data and interpolating between given data points. I think the reason for this scarcity of data is that the authors of the chart were not able to find much good agreement between various gases and their compressibility factors in the area between the reduced temperature (Tr) = 1.0 isotherm and the saturated vapor line.

Although the worksheet is configured for conventional U.S. units (degrees F and pounds per square inch absolute), there is a space to the right of the user interface where the user can easily change the conversion factors for other temperature and pressure units. If you change the conversion factors, you also can edit the unit designations in column B of the user interface to agree with your revised conversion factors. Keep in mind that all the calculations are carried out in absolute pressure and temperature units.

### How it all works

A brief explanation of how the worksheet works follows:

- The worksheet calculates the compressibility factor (Z) based on a table (TABLE1) of tabulated values of compressibility factors taken from the Nelson-Obert Generalized Compressibility Charts for a range of reduced pressures and reduced temperatures. To account for pressures and temperatures between the tabulated reduced pressures and temperatures, the worksheet does three sets of linear interpolations.
- At the tabulated value of T
_{r}below, the user's given value of T_{r}, the worksheet finds Z at the user's given value of P_{r}by interpolating between the tabulated value of P_{r}above the user's given value of P_{r}and the tabulated value of Pr below the user's given value of Pr. - The worksheet then repeats the above process at the tabulated value of T
_{r}above the user's given value of T_{r}. - The worksheet then has values of Z at the user's input value of P
_{r}, at the tabulated values of T_{r}below, and above the user's input value of T_{r}. - The final step is to interpolate between these two values of Z to find the value of Z at the user's input values of P
_{r}and T_{r}. You can follow the above process in columns S, T, U, and V, rows 6 through 21, where each step is briefly described in column W. - The worksheet determines the correct column to use in Table 1 by using a VLOOKUP function in Table 2.
- It then determines the correct row to use in Table 1 by using a VLOOKUP function in Column 1 of Table 1.

Using the worksheet

The worksheet has room for up to four sets of process conditions, making it compatible with many of the valve manufacturer's control valve sizing programs, which typically are configured to perform simultaneous calculations for up to four sets of process data.

The user interface is in the upper left corner of the worksheet. You can optionally enter the name of the gas and the tag number of the valve for which you are doing calculations, for your reference, if you are going to either save or print out the worksheet.

Enter the critical temperature and critical pressure of the gas, and up to four upstream temperatures and pressures. The fields where the calculated compressibility factor(s) appear will remain blank until all required data has been entered. It is possible to use other units than PSIA and degrees F for either and/or both upstream and critical pressure and temperature. See the area just to the right of the user interface.

For your reference, below the data and results area, the reduced temperature (T_{r}) and reduced pressure (P_{r}) being used in the calculation are displayed along with a note stating whether T_{r} and P_{r} are within or outside the limits of the worksheet.

If you have entered temperatures or pressures that result in T_{r} or P_{r} that are outside the stated limits, the COMPRESS. FACTOR (Z) field will read #NA and the notes below that will state which parameter is out of limits.

When the process approaches the critical point (T_{r} and P_{r} both equal 1.0) the compressibility factor changes very rapidly making it difficult to read the charts accurately or interpolate between points accurately. This is especially notable at the critical temperature (T_{r} = 1.0) and reduced pressures (P_{r}) between about 1.0 and 2.0. Also, if you look at the medium pressure Nelson-Obert chart, the T_{r} isotherm of 1.0 is almost vertical as it approaches the critical pressure (P_{r} = 1.00). This is because in this area, the compressibility factors of various gases do not all appear at the same point on the T_{r} = 1.0 isotherm. When the worksheet returns a compressibility factor (Z) of less than 0.35, the compressibility factor will be shown in red to remind users that their process conditions are close to the critical point.

Link to ISA-75.01.01-2012, Industrial-Process Control Valves, Part 2-1: Flow Capacity.https://www.isa.org/products/ansi-isa-75-01-01-2012-60534-2-1-mod-industrial-pr

**Download Compressibility Factor Excel Sheet **

**Read Article in InTech Focus Magazine **