Booster Pump Head Calculation Xls [TRUSTED]

=IF(B4>0, ( ( (B12*B6)/(2*9.81) ) * ( ( (4*B4/3600)/(PI()*(B6/1000)^2) )^2 ) ) , 0 )

(Where B12 is friction factor λ from Colebrook equation – use iterative or Moody chart approximation)

Better to use:

Include conditional formatting to flag Re < 2300 (laminar) and negative results.

Calculate total dynamic head (TDH) for a booster pump and provide a reproducible Excel file for design and pump selection. booster pump head calculation xls

For large projects (hotels, hospitals, industrial plants), your spreadsheet should include: =IF(B4>0, ( ( (B12*B6)/(2*9