PO.SF.Comp.Stages


Description

Returns the fewest compression stages that keep each stage's pressure ratio at or below a maximum, with the overall ratio split equally between them, or that equal stage ratio. Equal ratios with intercooling to the same temperature give equal work per stage and close to the least total work, which is why it is the usual first split. The maximum ratio is the caller's: usually set by the discharge temperature limit (`PO.SF.Comp.Tdisch`), the rod load or the machine type.

Formula

=LAMBDA(ps, pd, r_max, output, IF(OR(ps<=0, pd<=ps, r_max<=1), NA(), LET( n, MAX(1, ROUNDUP(LN(pd/ps)/LN(r_max)-0.000000001, 0)), IF(output="Stages", n, IF(output="Ratio", (pd/ps)^(1/n), NA())))))

Parameters

Parameter Unit Description
ps psia Suction pressure of the first stage
pd psia Final discharge pressure; above `ps`
r_max — Largest pressure ratio allowed per stage; above 1
output text "Stages" the number of stages or "Ratio" the pressure ratio of each stage

Examples

Invocation Expected
=PO.SF.Comp.Stages(100, 1000, 4, "Stages") 2
=PO.SF.Comp.Stages(100, 1000, 4, "Ratio") 3.162278
=PO.SF.Comp.Stages(100, 900, 3, "Stages") 2
=PO.SF.Comp.Stages(100, 900, 3, "Ratio") 3
=PO.SF.Comp.Stages(50, 1200, 3.5, "Stages") 3
=PO.SF.Comp.Stages(50, 1200, 3.5, "Ratio") 2.884499
=PO.SF.Comp.Stages(200, 500, 3, "Stages") 1
=IF(ISNA(PO.SF.Comp.Stages(500, 200, 3, "Stages")), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda