=B9_Static + B15_SuctionFric + B16_DischargeFric + B17_EquipDrop
Start by creating a dedicated "Input" section with distinct cell formatting (e.g., Blue fonts for inputs) so users know where to type.
| Feature | Benefit | |---------|---------| | | Every formula is visible, unlike black-box software. | | Iteration | Change pipe diameter or flow rate; results update instantly. | | Cost | Free (if you already have Office). No annual license fees. | | Library | Build a lookup table for pipe friction (e.g., Hazen-Williams, Darcy-Weisbach). | | Reporting | One-click printing and PDF export for client submissions. | pump head calculation excel
[ f = \frac0.25\left[ \log_10\left( \frac\varepsilon/D3.7 + \frac5.74Re^0.9 \right) \right]^2 ]
To calculate in Excel, you must sum three primary components: Static Head , Friction Head Loss , and Pressure Head . This value determines the energy a pump must impart to a fluid to reach its destination. 1. Core Pump Head Formula | | Cost | Free (if you already have Office)
At the heart of pump selection lies the calculation. While specialized software exists to model complex fluid networks, Microsoft Excel remains the industry standard for quick, accurate, and transparent calculations.
Formulas:
Htotal=Hstatic+Hfriction+Hpressure+Hvelocitycap H sub t o t a l end-sub equals cap H sub s t a t i c end-sub plus cap H sub f r i c t i o n end-sub plus cap H sub p r e s s u r e end-sub plus cap H sub v e l o c i t y end-sub The vertical distance the fluid must be lifted. Friction Head ( Hfrictioncap H sub f r i c t i o n end-sub
This is the core of your tool. We will use the Darcy-Weisbach equation , which is the most accurate method for liquids across all flow regimes. | | Reporting | One-click printing and PDF
Before we input a single formula, we must define what we are calculating. "Pump Head" is a measure of the energy the pump must impart to the fluid to overcome resistance. It is measured in units of length (meters or feet), which often confuses beginners. Why feet? Because it represents the height a column of fluid can be lifted by the pump's pressure.