$$h_f = 10.67 \cdot \fracQ^1.852C^1.852 \cdot d^4.87$$
For power users, a adds game-changing features: booster pump head calculation xls
For water transmission specifically, many engineers prefer the Hazen-Williams formula because it avoids calculating the Reynolds number and friction factor. It is less precise than Darcy-Weisbach but widely accepted for civil engineering projects. $$h_f = 10
, your spreadsheet should include the following columns and variables: Input Parameters: Flow Rate ( Measured in GPM or Pipe Diameter ( Internal diameter of the piping. Pipe Length ( Total length of the straight pipe. Friction Loss Calculations: Hazen-Williams formula for water: booster pump head calculation xls