Hydraulic rating of sieve and valve trays for up to three column sections: enter the internal vapour and liquid loads and properties of each section and the tray layout, and see the percent of jet flood, the tray pressure drop, the downcomer backup, the weeping and entrainment checks and the turndown, section by section. In sizing mode the tool finds the column diameter for your design percent of flood.
USD 49 one-time purchase

What it does
New sizing (largest section
New sizing (largest section diameter, rounded up to your step) or rating of an existing column; 1 or 2 liquid passes; segmental downcomer area from the weir length by default, or your own.
Dry tray pressure drop (sieve
published discharge coefficient; valve: the maker's K1 and K2), Francis weir crest, aeration factor, total tray drop in mm of liquid and per tray, section and column pressure drop.
Downcomer
apron loss, clear and aerated backup as a percent of the tray spacing, downcomer velocity against a published rule, residence time and liquid seal.
Sieve tray weeping check
Sieve tray weeping check against a digitised weep chart, with the minimum vapour rate and the turndown ratio; minimum hole F-factor rule for valve trays.
Fractional entrainment from a
Fractional entrainment from a digitised entrainment chart, entrained liquid and the efficiency loss (Colburn equation).
Operating window of the
Operating window of the controlling section: jet flood, downcomer backup, weeping and downcomer velocity limits around the design point.
Built for engineers
- Visible formulas — nothing hidden, so you can check every step.
- Fully referenced — methods from the standard references, with the book, edition and page named in the Guide tab.
- 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 | Checked against an independent Python model in 119 recalculated runs (default case, all 24 selector combinations with default and manual settings, SI/US/British unit variants, result-unit switching, 54 edge cases), about 16,900 values, 0 mismatches and 0 formula errors in LibreOffice, plus 97 invalid-input cases that all stop with a clear message. |
| Free version | Browse the free calculators |
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. |