Scrubber Design Calculation Excel Best [hot]

The best Excel-based scrubber design calculation tools rely on established chemical engineering principles like the Treybal or Perry’s Chemical Engineers' Handbook methods to accurately size equipment and predict efficiency.

Pro tip: Avoid free sheets that hide their calculations behind passwords. The "best" sheet is one you understand and can modify.

Advantages of Excel-Based Scrubber Design Calculation scrubber design calculation excel best

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

1. Calculate the Equilibrium Line ($y = mx$) based on Henry’s Law constant.
2. Plot the Operating Line based on the L/G ratio.
3. Calculate $N_OG$ (Number of Gas Transfer Units) using numerical integration (Simpson's Rule is easily implemented in Excel columns) or the simplified log-mean driving force method if the system is dilute.
4. Retrieve $H_OG$ data from packing vendor tables (import this as a lookup table in Excel).
5. Multiply to get the Packed Bed Height (Z).

) and the scrubbing medium properties (density and viscosity). Column Diameter Determination The best Excel-based scrubber design calculation tools rely

Next Steps:

6. Quick Verification Test for Any Scrubber Sheet

Run this sanity check before trusting the output: Calculate the Equilibrium Line ($y = mx$) based

Introduction to Scrubber Design