PO.SF.Comp.k
Description
Returns the ideal-gas ratio of specific heats, k = Cp/Cv, of a hydrocarbon gas from its specific gravity and temperature, by Moshfeghian's (2013) correlation. Compressor discharge temperature, head and power all need k (`PO.SF.Comp.Tdisch`, `PO.SF.Comp.Power`), and a gas analysis is not always to hand: the gravity is. A sheet that has a k from a composition or a vendor's data sheet uses that cell instead of calling this function.
Formula
=LAMBDA(sg, t, IF(OR(sg<0.55, sg>2, t<-13, t>302), NA(), (1.6-0.44*sg+0.097*sg^2)*(1+0.0385*sg-0.000159*(t+459.67))))Parameters
| Parameter | Unit | Description |
|---|---|---|
sg |
air = 1 | Gas specific gravity (molecular weight / 28.96), 0.55 to 2.0 |
t |
°F | Gas temperature, −13 to 302 °F; for a compression stage the suction or the average of suction and discharge |
Examples
| Invocation | Expected |
|---|---|
=PO.SF.Comp.k(0.553923, 60) |
1.30107 |
=PO.SF.Comp.k(0.65, 100) |
1.268314 |
=PO.SF.Comp.k(1, 200) |
1.173551 |
=PO.SF.Comp.k(0.822, 77) |
1.233865 |
=PO.SF.Comp.k(0.822, 77) |
1.229 |
=PO.SF.Comp.k(0.822, 302) |
1.181 |
=PO.SF.Comp.k(1.754, 77) |
1.112 |
=IF(ISNA(PO.SF.Comp.k(0.5, 60)), 1, 0) |
1 |