Scrubber Design Calculation Excel Best Online

This report provides a basic example of scrubber design calculations. You may need to modify the calculations and assumptions based on your specific requirements and the type of scrubber you are designing.

If you need help building a specific section of this Excel model, I can help you with: lists.

Using XLOOKUP or INDEX/MATCH against structured tables of packing factors (for different types and sizes of random or structured packing) prevents manual data entry errors. Data validation drop-down menus ensure users only select valid packing materials or chemical systems. 🎯 Goal Seek and Solver

Cells executing the explicit algebraic steps for flooding velocity, diameter calculation, and Onda’s correlations. scrubber design calculation excel best

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.

To create the scrubber design calculator, you need a structured approach. Break your Excel workbook into the following, clearly labeled sheets: A. Input Data Sheet

: Establish the gas inlet flow rate, temperature, and pressure. Identify the pollutant concentration (e.g., HCl, cap H sub 2 cap S cap S cap O sub 2 This report provides a basic example of scrubber

Δylm=(yin−yin*)−(yout−yout*)ln(yin−yin*yout−yout*)delta y sub l m end-sub equals the fraction with numerator open paren y sub i n end-sub minus y sub i n end-sub raised to the * power close paren minus open paren y sub o u t end-sub minus y sub o u t end-sub raised to the * power close paren and denominator l n open paren the fraction with numerator y sub i n end-sub minus y sub i n end-sub raised to the * power and denominator y sub o u t end-sub minus y sub o u t end-sub raised to the * power end-fraction close paren end-fraction y*y raised to the * power

You can use the following formulas in your Excel template:

| Feature | Why It Matters | |--------|----------------| | for packing types | Prevents manual entry errors | | Unit converters (e.g., scfm to acfm) | Saves time, avoids unit mismatch | | Flooding check with color coding (green = safe, red = flooded) | Instant visual feedback | | Sensitivity analysis with data tables | See how diameter changes with gas flow ±20% | | Graphical output (pressure drop vs. gas rate) | Validates design against classic curves | | Protection for formula cells | Users can’t break core logic | Using XLOOKUP or INDEX/MATCH against structured tables of

Here's an example of a report based on the scrubber design calculations:

= (Pressure_atm * Mol_Weight) / (0.08206 * (Temp_C + 273.15)) Step 2: Determine Column Diameter (Flooding Approach)

Ensure that your design meets all requirements: efficiency targets, pressure drop limits, flooding margins, and liquid distribution constraints.

are generated via Onda's remaining dimensionless groups (Schmidt and Reynolds numbers), Excel can compute the overall height of a transfer unit:

You do not have to start from scratch. Several excellent resources are available: