Home › Shop › Packed Column Sizing and Pressure Drop
Excel tool

Packed Column Sizing and Pressure Drop

What diameter does the packed column need, how close to flooding will it run, what pressure drop will the blower see, and does the packing still wet at turndown?

Packed column sizing: flooding velocity, diameter at your percent of flood with rounding, pressure drop per metre, wetting rate, packed height from HETP or HTU, and turndown load cases.

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
Packed Column Sizing and Pressure Drop — sample pages

What it does

Flooding

Flooding gas velocity and pressure drop at flooding from the flow parameter and your packing factor, with a calibration factor for maker's data.

Three design bases

Percent of calculated flood, a pressure drop limit per metre, or a percent of the maker's flooding velocity.

Diameter

Rounded up to the next 50 mm, 100 mm or a generic size series, with the increase from rounding shown.

Hydraulics at that diameter

Percent of flood, pressure drop per metre, F-factor, liquid loading and wetting rate against the minimum.

Packed height

From stages times HETP or transfer units times HTU, with beds for a maximum bed height and the total pressure drop.

Turndown

Four editable load cases with percent of flood, pressure drop and wetting rate for each.

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

Packed Column Sizing and Pressure Drop 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 againstAn independent Python model in 229 recalculated runs: all selector combinations (84), SI, US, British and industry units on three setups, result-unit switching and 128 edge and invalid-input cases; about 13,750 values compared, 0 mismatches and 0 formula errors in LibreOffice.
Free toolsBrowse 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.