TDH = 36.9 (static + required pressure) + 4.0 (friction) – 1.5 (suction help) ≈
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.
Here is what that spreadsheet is actually calculating—and why it matters: booster pump head calculation xls
#MechanicalEngineering #PumpSizing #HVAC #Hydraulics #EngineeringTips
This is where the Excel grid truly earns its keep. Every elbow, every valve, and every meter of pipe steals energy. TDH = 36
Do not mix metric and imperial units. If flow is in L/s, your head must be calculated in meters. If flow is in GPM, use feet.
You can write a macro to iterate through pipe diameters and pump curves simultaneously, allowing Excel to select the most efficient pump model for your specific TDH automatically. Do not mix metric and imperial units
The heart of the engineering design process is finding the intersection of accurate data and efficient tools. For booster pump sizing, the is the ideal blend of both.
For large projects (hotels, hospitals, industrial plants), your spreadsheet should include:
The booster pump head calculation determines the total pressure (expressed in feet or meters of head) the pump must generate to overcome system resistance and lift water, while maintaining the desired flow rate.
Using an automates complex hydraulic formulas, reduces manual errors, and provides a reusable template for future projects. This guide will walk you through the engineering principles behind Total Dynamic Head (TDH) calculations and show you exactly how to build and implement these functions in Microsoft Excel.