Pump Sizing & Selection Calculator
Total Dynamic Head, hydraulic power and estimated shaft power for steady-state pump duty.



About this resource
Pump duty calculations need a clear datum, consistent units and an honest statement of the losses included. This workbook organises the calculation into one editable sheet so every input behind a duty point can be reviewed, checked and reused.
Select the flow units, set the suction and discharge levels against a defined datum, then enter fluid density, pipe geometry and fitting data. The sheet converts the flow, adds static head to the calculated friction and minor losses, and reports Total Dynamic Head with hydraulic and estimated shaft power.
Each result sits next to the equation it comes from, so a duty point can be reproduced by hand. Efficiency assumptions are stated explicitly, and the workbook does not select a pump model or verify a manufacturer curve.
It is intended for preliminary process and mechanical engineering work, not for final equipment selection.
What is included
- Pump Sizing & Selection Calculator workbook — XLSX · Calculator with live formulas, worked example, assumptions and licence sheets. · Editable
- PDF user guide — PDF · Three-page guide: inputs, method and equations, worked example, units and limits. · Not editable
- Flow-rate conversion between supported units
- Static head from defined suction and discharge elevations or liquid levels
- Straight-pipe friction loss using a documented method where pipe data are supplied
- Minor losses from entered fitting and valve loss coefficients where supported
- Total Dynamic Head (TDH)
- Hydraulic power and estimated shaft/input power using a stated efficiency
- Formula, unit and assumption reference
Software compatibility
- Microsoft Excel: Excel 2016 or later, desktop or Microsoft 365 · required · edit · format based expectation — Formulas use standard worksheet functions only. The workbook was recalculated and checked before release; desktop Excel behaviour is a format-based expectation.
- LibreOffice Calc: 7.6 or later · optional · edit · format based expectation — Formulas use standard worksheet functions only. The workbook was recalculated and checked before release; desktop Excel behaviour is a format-based expectation.
Prerequisites and technical context
Intended audience
Working engineer, Early-career engineer, Engineering team, Engineering student
Prerequisites
- A system sketch with suction and discharge levels referenced to one datum
- Pipe lengths, internal diameters and roughness data
- Fluid density or specific gravity at operating conditions
- A pump efficiency assumption for the duty point
Unit systems
- SI: m³/h, m, mm, kg/m³, kPa, kW
- Common field units for flow, head, pressure and power
Assumptions
- Steady-state, single-phase, incompressible liquid flow
- One datum used consistently for static head and elevation
- Darcy–Weisbach friction factor with a documented method
- Minor losses use entered loss coefficients and a stated velocity basis
Technical notes
- Flow is converted to one calculation unit before head and power are evaluated.
- Outputs separate hydraulic power from estimated shaft/input power.
- The workbook does not select a commercial pump model or imply that one has been chosen.
References
- No external standards or references listed.
Scope and limitations
Included
- Flow-rate conversion between supported units
- Static head from defined suction and discharge elevations or liquid levels
- Straight-pipe friction loss using a documented method where pipe data are supplied
- Minor losses from entered fitting and valve loss coefficients where supported
- Total Dynamic Head (TDH)
- Hydraulic power and estimated shaft/input power using a stated efficiency
- Formula, unit and assumption reference
Not included
- Automatic selection of a pump make or model
- Manufacturer performance-curve verification
- NPSH available versus NPSH required, unless a separate validated module is included
- Transient flow, cavitation, slurry, multiphase and complex network behaviour
- Mechanical design, shaft design and motor sizing
Limitations
- Preliminary steady-state, single-phase liquid calculations only.
- Fluid properties and loss coefficients must represent the actual operating conditions and fittings.
- Pump efficiency is an input; the workbook does not predict it.
- Final pump selection must be checked against the actual system requirements and manufacturer performance data.
Author and review information
Author / publisher: Curious Engineering
Review status: Author checked
Equations are implemented as transparent worksheet formulas with the unit handling shown on each sheet. The shipped worked example uses the default inputs and can be reproduced by hand.
Review scope: Before release, every checked result was recalculated from the workbook and compared with an independent implementation of the same equations, including the worked example, unit conversions and boundary checks. No independent third-party review was commissioned.
Licence and permitted use
Single-user commercial licence
One named user may use this workbook on any number of their own devices for commercial and educational engineering work. Resale, redistribution, publication, sublicensing and inclusion in a paid course or product are not permitted. Adapted copies remain subject to the same terms.
- Use on your own projects, including paid client work
- Use for teaching and internal training
- Adapt the formulas and layout for your own internal templates
- Keep a personal or company archive copy for business continuity
Not permitted
- Reselling, sublicensing or distributing the file
- Publishing the file on a website, shared drive or marketplace
- Including the file in a paid course, product or template pack
- Removing the licence, attribution or version notices
Delivery
Orders are confirmed by email before payment. After payment clears, the workbook and PDF guide are sent as a secure download link together with the licence and a short getting-started note. Usually within one business day.
Related resources
- Pipe Flow & Pressure Drop Calculator · $12 — An Excel workbook for steady-state single-phase pipe flow: velocity, Reynolds number, Darcy friction factor, straight-pipe and minor pressure losses.
- Compressor Sizing Calculator · $15 — An Excel workbook for preliminary compressor process calculations: pressure ratio, mass flow, discharge temperature, theoretical and estimated shaft power.