Home › Shop › Distillation Tray Hydraulics and Flooding
Excel tool

Distillation Tray Hydraulics and Flooding

Jet flood, column diameter, tray pressure drop, downcomer backup, weeping, entrainment and turndown for sieve and valve trays, section by section.

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

  • Excel workbook (.xlsx), no macros, version v1.0
  • Excel 2010 or later, Windows and Mac
  • Instant download after payment; updates to this major version included
  • Single-user licence; team and site options
  • Refund if it does not work as described or has an error we cannot fix: contact support within 14 days of purchase — full refund policy
Distillation Tray Hydraulics and Flooding — sample pages

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].

Distillation Tray Hydraulics and Flooding Excel workbook sample pages
Layout illustration (not a results screenshot).

Specification and checks

FormatExcel workbook (.xlsx), no macros
Versionv1.0
Works inExcel 2010 or later, Windows and Mac
UnitsSI, US and British, mixed freely
IncludesGuide tab with method and references, calculator, print-ready report
Checked againstChecked 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 versionBrowse the free calculators

Compatibility, licence and support

FileExcel 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.
LicenceSingle user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms.
UpdatesUpdates to this major version are included; download them again from the link in your receipt.
SupportEmail [email protected] with your order number — questions on the method, your inputs or your results are welcome.
RefundsIf 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.