Create a new spreadsheet in Excel and give it a title, such as "Scrubber Design Calculation".

Include a packing factor table indexed by packing type and size.

A logical sequence is: input worksheet, calculation worksheet, and presentation/output worksheet. This makes it easier for others to understand and audit your work.

Before diving into the math, let’s validate the claim.

): Dictated by the gas velocity and the flooding characteristics of the chosen packing. Packed Height (

This is where Excel shines. For gas absorption (e.g., HCl in water), the method is standard.

This prevents #NUM! from crashing the sheet.

For venturi scrubbers, collection efficiency can be expressed as:

Avoid using circular references or enabling iterative calculation settings. Break complex formulas down into sequential, named cell steps instead. Tab 4: Summary Report & Verification

These equations are all programmable in Excel, as noted by engineering experts in the field. Several engineers have already created working spreadsheets based on these design equations, which you can adapt for your own use.