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

Need a custom LAMBDA? Suggest a New Lambda