Fluid Properties
These Excel spreadsheets will calculate the density of air or other gases of known molecular weight at specifed temperature and pressure. Also the compressibility factor of a gas can be calculated using the Redlich-Kwong equation and the viscosity of a gas can be calculated with the Sutherland formula Calculations may be in U.S. or S.I. units
This fluid properties calculator spreadsheet bundle include all of the spreadsheet workbooks listed and described below.
This Excel spreadsheet calculates the density of air at specified temperature and pressure using the ideal gas law, working in either U.S. units or S.I. units. It will also work for other gases of known molecular weight.
This Excel spreadsheet calculates the average atmospheric pressure at a specified elevation above sea level. The calculations may be in either U.S. units or S.I. units.
This Excel spreadsheet calculates air viscosity at a given temperature and pressure in either U.S. units or S.I. units.
This Excel workbook will calculate the compressibility factor of a gas using the Redlich-Kwong equation of state, based on user input values for temperature and pressure of the gas and critical temperature and pressure of the gas. There is a worksheet for U.S. units and one for S.I. units.
This Excel spreadsheet calculates the density of a gas based on user input values for the gas temperature, gas pressure, molecular weight of the gas, critical temperature of the gas and critical pressure of the gas. The compressibility factor, Z, is calculated using the Redlich-Kwong equation and is used to calculate the gas density. There is a worksheet for U.S. units and one for S.I. units.
This Excel spreadsheet calculates the viscosity of a gas at a specified gas temperture. User inputs required are the gas temperature, Sutherland's constant for the gas, and the viscosity of the gas at some specified reference temperature. A table with values for Sutherland's constant, along with values for gas viscosity at one or more reference temperatures is provided for 25 gases. Calculations may be made in either U.S. or S.I. units.