PO.SF.PL.Liq.Size(ql, rho, mu, length, eps, dh, p_in, p_min, v_max, ids)

Returns the smallest pipe internal diameter, from a list of candidate sizes, that carries a liquid rate from an inlet pressure to a minimum delivery pressure, the elevation change included, without exceeding a velocity limit. It sweeps the list smallest first with the shipped Darcy-Weisbach functions and stops at the first size that passes both tests. The roughness is the wall's absolute roughness, so each size takes its own relative roughness ε/D. A sheet reads the nominal size with `INDEX(nps, MATCH(size, ids, 0))`.

PO.SF.Pump.NPSHa(ps, pv, sg, hs, hf)

Returns the net positive suction head available at a pump's suction, in feet of the liquid pumped: how far the suction pressure stands above the liquid's vapour pressure. A pump needs at least the NPSH its curve requires at the duty, or the liquid flashes in the impeller eye and the pump cavitates. NPSHa = (ps − pv)·2.31/sg + hs − hf, where 2.31 ft of water is one psi.

Need a custom LAMBDA? Request a Lambda