One possibility for a gas compressibility factor calculator Excel spreadsheet is through the use of the Redlich-Kwong equation of state, which is shown below:Ī, B, and h are constants calculated as shown. For gases that don’t exhibit ideal gas behavior, the compressibility factor, Z can be introduced to give: ρ = Z*MW*P/R*T. The Ideal Gas Law, PV = nRT, can be used to calculate the density of a gas that exhibits ideal gas behavior by introducing the molecular weight of the gas and solving for gas density to give: ρ = MW*P/R*T.įor information on the use of the ideal gas to calculate gas density, see the article, “ Air Density Calculator Excel Spreadsheet.”Ĭonditions required for ideal gas behavior are pressure > critical temperature. The compressibility factor of a gas is used in several types of calculations including calculation of real gas density. Background for Gas Compressibility Factor Calculator Excel Spreadsheet Read on for information about using a gas compressibility factor calculator Excel spreadsheet. This spreadsheet calculates the compressibility factor of a gas from the gas temperature, gas pressure, and the critical pressure and critical temperature of the gas. You can buy a convenient gas compressibility factor calculator Excel spreadsheet for a very reasonable price. This Excel spreadsheet is intended for calculation of the compressibility factor of a gas using the Redlich-Kwong equation of state. Look in the Fluid Properties category on the Download page. To obtain a gas compressibility factor calculator Excel spreadsheet, click here to visit our spreadsheet store. Where to Find a Gas Compressibility Factor Calculator Excel Spreadsheet

Download solver table for excel