f = 0.25 / [LOG10( ε/(3.7*D) + 5.74/Re^0.9 )]^2
While commercial software like Pipe-Flo, AFT Fathom, or even cloud-based hydraulic solvers exist, the remains indispensable. It is transparent, customizable, and free from recurring licensing costs. By following the principles laid out in this article—correct friction loss method, proper unit handling, system curve development, and NPSH checks—you can build a sheet that rivals many paid tools. pump head calculation excel sheet
A report on pump head calculation for Excel involves structuring a spreadsheet to compute , which is the total pressure a pump must overcome to move fluid at a specific flow rate. 1. Key Components of Pump Head A report on pump head calculation for Excel
Industries that rely heavily on these tools: Re) Dim f
TDH = Hs + Hd + hf + hv
Function Colebrook(eps, D, Re) Dim f, fnew, delta f = 0.02 Do fnew = 1 / (-2 * Log10(eps / (3.7 * D) + 2.51 / (Re * Sqr(f)))) ^ 2 delta = Abs(fnew - f) f = fnew Loop While delta > 0.000001 Colebrook = f End Function