Download User`s Manual

To compute the ratio of specific heats, cell B58 contains the formula
=GAS2CR($B$1, $B$2, $A$4:$A$13, $B$4:$B$13). The GAS2CR
function uses the four arguments described on pages “EREXCEL-8” and
“EREXCEL-9”. The remaining results in cells B59 through B70 are
computed in a similar manner using the same arguments and the function
indicated in column A.
A
B
C
58
Ratio of Specific Heats (Ideal Gas)19
GAS2CR
1.357678
[Cp/Cv]
59
Temperature (Dry Ideal Gas + H2 O ASME)
GAS2TEMP
364.0922
°F
60
Specific Enthalpy (Dry Ideal Gas + H2 O ASME) GAS2ENTH20
135.2667
Btu/Lb
61
Specific Entropy (Dry Ideal Gas + H2 0 ASME)
GAS2ENTR20
.2211987
Btu/Lb °R
62
Compressibility Factor (Reference)21
GAS2Z0
0.9982604
[Z0]
63
Compressibility Factor22
GAS2Z1
0.9997867
[Z1]
64
Super Compressibility
GAS2SZ
1.000107
[Fpv]
65
Density (Reference)23
GAS2DR
7.798304E-2
Lb/Cuft
66
Density24
GAS2D
4.900708E-2
Lb/Cuft
67
Specific Volume (Reference)
GAS2RVOL
12.823300
Cuft/Lb
68
Specific Volume
GAS2VOL
20.405214
Cuft/Lb
69
Viscosity (Dry Ideal Gas)
GAS2U
1.572015E-05
Lb/Sec-ft
70
Viscosity (Dry Ideal Gas)
GAS2UC
2.339416E-02
Centipoise
Entering Gage Pressures
EndResult® functions require that all pressures to be entered as absolute
pressures. If, however, you have a value in gage pressure (e.g. 1500
psig), simply add the atmospheric pressure (e.g. 14.696 psia) to the gage
pressure as shown by the gas density calculation below:
=GAS2D(1500+14.696,300,$A$4:$A$13,$B$4:$B$13)
______________________
19 The specific heat ratio may be unrealistic if it is less than 0.1 or greater than 4.
20 Enthalpy and entropy calculations are based on a change in enthalpy or entropy from the zero enthalpy temperature,
which can be modified as shown on page “EREXCEL-8”.
21 The compressibility factor (reference) may be unrealistic if it is greater than 1.24.
22 The compressibility factor may be unrealistic if it is greater than 1.24.
23 The density (reference) value may be unrealistic if it is greater than 100.
24 The density value may be unrealistic if it is greater than 100.
R
EndResult®
©2003 Sega Inc.
EREXCEL-13
November 1, 2002 - English