Cooling-water and steam networks screened for the limiting element: header velocity and pressure drop, pressure available against required at every user, pumps, tower, boiler and letdown, ranked by utilisation, with headroom for added load.
USD 49 one-time purchase

What it does
Header hydraulics
Velocity and pressure drop per segment by Darcy-Weisbach with Colebrook-White friction; isothermal compressible flow for steam.
Pressure at every user
Available against required differential pressure for every user, with margin and utilisation.
Pumps, tower and boiler
Pumps on a quadratic curve, tower heat, flow, range and approach against design, and boiler and letdown capacity.
Limiting element ranking
Every element of both networks ranked by utilisation, with and without your added load.
Headroom for added load
How much heat duty or steam flow a chosen node can take, with its effect on flow and header drop.
Report
Ranked findings, utilisation, header pressure profile and headroom charts, and a print-ready report.
Built for engineers
- Visible formulas — nothing hidden, so you can check every step.
- Fully referenced — methods from the standard references, checked against their published worked examples.
- Safe to share — sheets are protected against accidental edits, with an open password so you can still customise.
- Built-in input checks — clear warnings for impossible inputs and values outside typical ranges.
For engineering estimates; verify against site data. Code-based methods are aligned with the publicly documented procedure; they are not a licensed reproduction or a certification.
Preview the workbook
An illustration of the sheet layout of this workbook, not a screenshot of calculated results. Select the image to enlarge it. For questions before you buy, email [email protected].
Specification and checks
| Format | Excel workbook (.xlsx), no macros |
| Version | v1.0 |
| Works in | Excel 2010 or later, Windows and Mac |
| Units | SI, US and British, mixed freely |
| Includes | Guide tab with method and references, calculator, print-ready report |
| Checked against | An independent Python model in 170+ recalculated runs: 40 selector combinations, SI, US and British units, 36 edge cases and 97 invalid-input cases; 0 formula errors in LibreOffice. |
| Free version | Try the free pipe pressure drop calculator |
Compatibility, licence and support
| File | Excel workbook (.xlsx), no macros, version v1.0; works in Excel 2010 or later on Windows and Mac. Sheets are protected against accidental edits, with an open password so you can customise. |
| Licence | Single user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms. |
| Updates | Updates to this major version are included; download them again from the link in your receipt. |
| Support | Email [email protected] with your order number — questions on the method, your inputs or your results are welcome. |
| Refunds | If the tool does not work as described, or has an error we cannot fix, email [email protected] with your order number within 14 days of purchase and we will refund you in full. Refunds are not offered for a change of mind once a file has been downloaded. Read the full refund policy. |
Field guide: Water Treatment, Utilities and Energy Made Simple