Two-phase gas-liquid pipe pressure drop: homogeneous or Lockhart-Martinelli, friction, static and acceleration parts, hold-up, flow regime map, slugging flag, erosional velocity check and a multi-segment line.
USD 49 one-time purchase

What it does
Pressure drop parts
Friction, static and acceleration pressure drop for every segment and the whole line, with gas density following the falling pressure.
Two methods
Homogeneous or Lockhart-Martinelli, with the two-phase multiplier, liquid hold-up and line liquid inventory.
Flow regime
Stratified, intermittent, annular and dispersed bubble for horizontal lines; bubble, slug and annular for upward lines, with map coordinates.
Slugging and erosion
A slugging flag for the line and an erosional velocity check with your own C factor, per segment and worst case.
Multi-segment line
Horizontal runs, risers and downhill sections, each segment defaulting to the diameter of the one before.
What-if tables
Pressure drop at other gas and liquid rates, with ranked findings, three 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 (separate friction factor code, root finding for the stratified liquid level, iterated acceleration term): the default case, every combination of method, orientation and gas density basis, SI, US and British unit variants with every input and result unit switched, edge cases that reach every flow regime, and blocked inputs (blank, zero, negative, text, exhausted pressure) which give a clear message and blank results, never an error value. |
| 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