Scrubber Design Calculation Excel Best

This is crucial for fan and blower sizing. For packed columns, pressure drop per meter of packing multiplied by total packing height gives the total pressure drop.

The by Stephen Hall, based on "Rules of Thumb for Chemical Engineers," calculates the number of transfer units, required packing depth, and height of a transfer unit for packed gas scrubbers.

A=VgUdescap A equals the fraction with numerator cap V sub g and denominator cap U sub d e s end-sub end-fraction scrubber design calculation excel best

The HTU–NTU methodology is particularly well-suited for Excel implementation, as it allows iterative calculations based on input variables such as gas flow rate, liquid properties, packing characteristics, and target removal efficiency.

To build a robust scrubber design spreadsheet, you must include inputs for both gas and liquid phases: Gas Stream Properties This is crucial for fan and blower sizing

Total Packing Height (Z)=NTU×HTUTotal Packing Height open paren cap Z close paren equals NTU cross HTU Finding NTU (Driving Force)

Excel's unit conversion functions or custom formulas can handle this step. The actual gas flow (m³/s) is calculated from normal conditions using the ideal gas law: A=VgUdescap A equals the fraction with numerator cap

where η is efficiency (as a fraction), k is a correlation coefficient (typically 0.1–0.2), R is the liquid-to-gas ratio, and ψ is the inertial impaction parameter.

Design for 70–80% of the flooding limit rather than 100%. This provides a safety buffer for process upsets, fouling, and foaming conditions. The GrowMechanical calculator explicitly checks F-factor utilization and warns when this threshold is exceeded.

This text outlines the essential steps to create a robust, best-practice scrubber design calculator in Excel, focusing on Packed Bed Scrubbers (the most common type for gas absorption).