Here’s a concise draft you can use for a document, blog post, or email titled “Scrubber Design Calculation — Excel Best Practices”:

Title: Scrubber Design Calculation — Excel Best Practices

Introduction Briefly explain the purpose of scrubber design calculations and why Excel is a useful tool for preliminary sizing, mass/energy balances, and cost estimation.

Key Inputs

Gas flow rate (Nm3/h or actual conditions)
Pollutant concentration (ppm, mg/Nm3)
Target removal efficiency (%)
Gas temperature and pressure
Gas composition (major components, particulates, humidity)
Liquid flow rate and properties (density, viscosity, surface tension)
Absorbent/reactant properties (solubility, reaction kinetics)
Scrubber type (packed bed, tray, venturi, spray tower)
Design constraints (pressure drop, footprint, materials)

Calculation Steps (recommended Excel workflow)

Units & assumptions sheet — define units, constants, and assumptions.
Input sheet — clearly label all user inputs with validation (data ranges, drop-downs).
Conversion functions — centralize unit conversions and standard conditions.
Mass balance — compute pollutant mass load (kg/h) and solvent/absorbent requirements.
Gas–liquid contact model — implement appropriate correlations:
- For packed columns: use HETP or overall mass transfer coefficient (KGa) approach.
- For tray columns: use Murphree or stage efficiency methods.
- For venturi/spray/venturi scrubbers: use droplet collection/impaction correlations.
Mass transfer calculations — calculate required interfacial area, KLa or KGa, and packing height or number of stages.
Pressure drop & hydraulic checks — estimate ΔP across packing/trays and verify liquid distribution.
Materials & corrosion check — select materials compatible with gas/solvent.
Equipment sizing — diameter, packing volume/height, inlet/outlet ducting, pumps.
Performance verification — simulate expected outlet concentration and verify target removal.
Cost estimation — capital and operating cost rough estimates (packing, fans, pump power, reagent).
Sensitivity analysis — include data table or tornado chart to show effect of ±10–20% input variations.

Excel Best Practices

Use named ranges for key inputs and outputs.
Keep calculation cells separate from input cells.
Lock/protect formula cells and provide a clear input cell color scheme.
Add inline comments and a assumptions table.
Use Excel tables for repeatable calculations (e.g., multiple pollutant streams).
Implement error checks and flags (e.g., gas velocity too high, flooding risk).
Use Data Validation and drop-downs for common selections (units, scrubber type).
Include version control and a change log sheet.

Example Outputs to Display

Summary table: inlet/outlet concentrations, removal efficiency, gas flow, liquid flow, packing height, column diameter, pressure drop, power consumption, CAPEX/OPEX.
Charts: concentration vs. time (if dynamic), sensitivity plots, packing height vs. desired efficiency.
Printable design sheet for procurement.

Template Structure (recommended workbook tabs)

00_Instructions
01_Assumptions_and_Units
02_Inputs
03_Conversions
04_MassBalances
05_MassTransfer
06_Hydraulics_and_PressureDrop
07_Sizing_and_Materials
08_Costs
09_Sensitivity
10_Outputs_and_Plots
11_ChangeLog

Closing note Recommend validating Excel results with vendor data or detailed simulation (e.g., Aspen, gPROMs) before final design.

Related search suggestions sent.

Design and Calculation of Scrubbers using Excel: A Comprehensive Approach

Scrubbers are air pollution control devices used to remove pollutants and particulate matter from gas streams. They are widely used in various industries, including power plants, chemical plants, and waste incineration facilities. The design and calculation of scrubbers involve several complex steps, including determination of the scrubber's efficiency, selection of the scrubbing liquid, and sizing of the equipment. In this essay, we will discuss the design and calculation of scrubbers using Excel, a popular spreadsheet software.

Introduction to Scrubber Design

The design of a scrubber involves several key steps:

Determination of the gas flow rate and composition: This includes the flow rate of the gas stream, its temperature, and the concentration of pollutants.
Selection of the scrubbing liquid: The scrubbing liquid is chosen based on its ability to absorb or react with the pollutants.
Determination of the scrubber's efficiency: The scrubber's efficiency is determined by the type of scrubber, the scrubbing liquid, and the operating conditions.
Sizing of the equipment: The scrubber's size is determined by the gas flow rate, the scrubbing liquid flow rate, and the required efficiency.

Scrubber Design Calculations

The design calculations for a scrubber typically involve the following steps:

Gas flow rate calculation: The gas flow rate is calculated using the formula:

Q = (A x V) / (ρ x T)

where Q is the gas flow rate (m³/s), A is the cross-sectional area of the duct (m²), V is the gas velocity (m/s), ρ is the gas density (kg/m³), and T is the temperature (K).

Scrubbing liquid flow rate calculation: The scrubbing liquid flow rate is calculated using the formula:

L = (Q x C) / (η x ρ)

where L is the scrubbing liquid flow rate (m³/s), C is the concentration of pollutants (kg/m³), η is the scrubber's efficiency, and ρ is the density of the scrubbing liquid (kg/m³).

Scrubber efficiency calculation: The scrubber's efficiency is calculated using the formula:

η = (C_in - C_out) / C_in

where η is the scrubber's efficiency, C_in is the inlet concentration of pollutants (kg/m³), and C_out is the outlet concentration of pollutants (kg/m³).

Excel-Based Scrubber Design Calculation

Excel is a powerful tool for designing and calculating scrubbers. It allows users to create spreadsheets that can perform complex calculations and data analysis. Here is an example of how to create an Excel-based scrubber design calculation:

Step 1: Create a new spreadsheet

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

Step 2: Input data

Input the following data into the spreadsheet:

Gas flow rate (m³/s)
Gas temperature (K)
Concentration of pollutants (kg/m³)
Scrubbing liquid flow rate (m³/s)
Scrubber efficiency (%)

Step 3: Calculate gas flow rate

Use the formula = (A x V) / (ρ x T) to calculate the gas flow rate.

| | A (m²) | V (m/s) | ρ (kg/m³) | T (K) | Q (m³/s) | | --- | --- | --- | --- | --- | --- | | | | | | | =(A2B2)/(C2D2) |

Step 4: Calculate scrubbing liquid flow rate

Use the formula = (Q x C) / (η x ρ) to calculate the scrubbing liquid flow rate.

| | Q (m³/s) | C (kg/m³) | η (%) | ρ (kg/m³) | L (m³/s) | | --- | --- | --- | --- | --- | =(A2B2)/(C2D2) |

Step 5: Calculate scrubber efficiency

Use the formula = (C_in - C_out) / C_in to calculate the scrubber's efficiency.

| | C_in (kg/m³) | C_out (kg/m³) | η (%) | | --- | --- | --- | =(A2-B2)/A2 |

Step 6: Perform sensitivity analysis

Perform a sensitivity analysis to determine the effect of changing operating conditions on the scrubber's performance.

Advantages of Excel-Based Scrubber Design Calculation

The use of Excel for scrubber design calculation has several advantages:

Easy to use: Excel is a user-friendly software that is widely available.
Flexible: Excel allows users to create custom spreadsheets that can be tailored to specific design requirements.
Fast: Excel can perform complex calculations quickly and accurately.
Low cost: Excel is a low-cost software compared to other design software.

Conclusion

The design and calculation of scrubbers is a complex process that involves several steps, including determination of the gas flow rate and composition, selection of the scrubbing liquid, and sizing of the equipment. Excel is a powerful tool that can be used to perform these calculations quickly and accurately. By creating a custom spreadsheet, users can perform sensitivity analysis and determine the effect of changing operating conditions on the scrubber's performance. The use of Excel for scrubber design calculation is a cost-effective and efficient approach that can be widely used in various industries.

For designing a scrubber in Excel, the "best" solid guides generally focus on two primary types: Packed Bed Scrubbers (for gas absorption) and Venturi Scrubbers (for particulate/dust removal)

. Effective spreadsheets typically integrate hydraulic calculations (diameter, flooding) with mass transfer modeling (HETP, efficiency). Recommended Excel Scrubber Design Guides Packed Bed Scrubber Design Excel (HCL/Acid Gas)

: This widely used template is ideal for chemical absorption. It includes input fields for gas/liquid properties, packing types (like Intalox Saddles), and calculates column diameter, pressure drop, and motor power requirements. Available on platforms like Course Hero EPA Wet and Dry Scrubbers Cost Calculation Spreadsheet : Provided by the

, this tool is the gold standard for estimating capital and annual operating costs based on waste gas composition and pollutant properties. Spray Tower Rating Spreadsheet : Developed by experts like Meloni Marco

, this bilingual (Italian/English) guide allows for preliminary calculations of single-stage spray towers, focusing on removal efficiency and pressure losses. Venturi Scrubber Design Calculation XLS

: This specialized sheet focuses on particulate removal using the Calvert calculation method. It handles humidification of inlet gas, saturated gas flow rates, and throat velocity to determine geometry. Key Calculation Components to Include

To ensure your Excel guide is robust, it should feature the following sections: Venturi Scrubber Design Calculations | PDF | Gases - Scribd

The most effective scrubber design calculation tool in Excel should balance detailed mass transfer equations with hydraulic limits, such as flooding and pressure drop. A "best-in-class" spreadsheet typically organizes data into clear modules for input, iterative calculation, and results. Core Modules for a Design Spreadsheet

Input Data: Define gas flow rates (ACFM), temperatures, pollutant concentrations ( Cincap C sub i n end-sub Coutcap C sub o u t end-sub

), and chemical properties of both the gas and scrubbing liquid.

Column Sizing: Calculate the required tower diameter based on gas velocity and saturation temperature.

Packing & Internals: Input data for specific packing types (e.g., Intalox saddles or Pall rings) and packing factors ( Fpcap F sub p

Efficiency & Mass Transfer: Use the Height of a Transfer Unit (HETP) or HTU/NTU methods to determine the total height of the packing bed required to meet target removal rates.

Hydraulics & Pressure Drop: Estimate the total pressure drop across the packing and internals using correlations like Norton’s or Hesketh (for Venturi scrubbers) to size the fan or blower. Essential Formulas for Excel Automation Calculation Formula / Method Key Parameters Efficiency (%) Inlet and outlet concentrations L/G Ratio Liters of liquid per Target range: 0.5–3 L/ Diameter Calculated from gas mass flow rate and velocity Pressure Drop Generalized Pressure Drop Correlation Packing factor, liquid/gas densities, and viscosity HETP Norton's Correlation: Surface tension, viscosity, and gas velocity Top Resources for Templates

High-quality, pre-built Excel templates can be found through professional engineering communities and regulatory agencies: Wet Scrubber Application Guide - Sly Inc.

Step A: Gas Properties & Molar Flow

Calculate the molar flow rate of the pollutant.

Excel Formula Logic: Molar_Flow = (Gas_Flow_Rate * Inlet_Concentration) / Molar_Volume
Tip: Use named ranges in Excel (e.g., name cell B2 "Q_Gas") to make formulas readable like = Q_Gas * Dens_Gas.

3. The "Best" Features Your Spreadsheet Must Have

| Feature | How to Implement in Excel | |---------|---------------------------| | Unit conversion | Use CONVERT function or a hidden unit table with VLOOKUP. | | Solver/Goal Seek for ΔP | Automate L/G adjustment to meet efficiency at min pressure drop. | | Error trapping | =IF(Flood% > 0.8, "WARNING: Near flooding", "OK") | | Graphical output | Dynamic charts: Efficiency vs. d_p, ΔP vs. gas flow. | | Lookup physical properties | Hidden sheet with water/air properties (density, viscosity, diffusivity) from 0–100°C. |

4. Example Calculation Logic (Excel Cell Layout)

Tab 5: `Results_Summary`

One page for the report:

Column height (packing + disengagement + sump)
Pump head (ΔP + static head)
Estimated cost (optional: based on diameter and material)

A. Unit Converter Toolbar

Embed a hidden sheet with all conversions (scfm to acfm, °F to °R, psi to psf). Use =CONVERT(value, "from_unit", "to_unit") if you have Excel’s Analysis ToolPak.

Scrubber Design Calculation Excel Best [best] May 2026