Fluid also loses energy every time it encounters a bend, tee, valve, or change in pipe diameter. These are called minor losses, calculated using the K-factor method:
Manually building this spreadsheet from scratch is rewarding, but verified tools are available for free download that include safety factors and built-in industry standards.
In your Excel worksheet, dedicate a specific column for user inputs, similar to a standard engineering workbook: booster pump head calculation xls
Knowing this will let me provide the exact formula strings for your template. Share public link
Quantities of elbows, tees, and check valves, which contribute to "minor losses". Residual/Required Pressure: Fluid also loses energy every time it encounters
To build an XLS calculator, you must program the core mathematical formula for Total Dynamic Head:
Assuming you need to calculate the head for a booster pump in a water supply system: Share public link Quantities of elbows, tees, and
Using the standard Hazen-Williams formula, the friction loss (meter head per 100 meters of pipe) can be computed via an Excel Add-In or with user-defined functions (VBA) that allow selective options for either Hazen-Williams or Darcy-Weisbach formulations.