| Criterion | What to Look For | |-----------|------------------| | Transparency | No hidden cells; all constants sourced. | | Flexibility | User selects packing type, gas composition, scrubbing liquid. | | Robustness | Handles #DIV/0! gracefully; shows warnings. | | Validation | Includes example case from Perry’s Handbook or EPA. | | No VBA dependency | Uses only Excel formulas (Solver optional). |
Avoid any spreadsheet that claims to be “one‑click” for all scrubbers – a Venturi, tray tower, and packed bed have fundamentally different hydrodynamics. The best Excel designs are purpose‑built for one scrubber type.
Do you have a specific scrubber type (Venturi, packed, or spray) in mind? Share your gas flow and target pollutant – I can outline the exact Excel row‑by‑row logic.
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
Calculation Steps (recommended Excel workflow)
Excel Best Practices
Example Outputs to Display
Template Structure (recommended workbook tabs)
Closing note Recommend validating Excel results with vendor data or detailed simulation (e.g., Aspen, gPROMs) before final design. scrubber design calculation excel best
Related search suggestions sent.
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
A wet scrubber is an essential environmental control device designed to remove pollutants (gases or particulates) from industrial exhaust streams. For Excel-based design, the "best" calculations typically follow the Generalized Pressure Drop Correlation (GPDC) or Norton’s Correlation for packed towers, and the Calvert or Hesketh equations for Venturi scrubbers. 1. Key Design Parameters for Excel
To build an effective Excel calculator, you must define the following input and output variables: Gas Stream Data: Volumetric flow rate ( Qgcap Q sub g ), temperature, pressure, and pollutant concentration. Scrubbing Liquid Properties: Flow rate ( ), density ( ρlrho sub l ), viscosity ( μlmu sub l ), and surface tension (
Packing Characteristics: Specific to packed towers, you need the Packing Factor ( Fpcap F sub p ) for materials like Intalox saddles or Pall rings. 2. Core Calculation Steps A. Column Diameter Calculation | Criterion | What to Look For |
The diameter is sized to prevent "flooding," where gas flow prevents liquid from descending.
Target Flooding: Most designs aim for 50% to 85% of flooding velocity. Formula Logic: Calculate the gas mass velocity (
) using the Vapor-Liquid Factor and the GPDC chart to find the flooding point. B. Column Height (Mass Transfer) NTU/HTU Method: The total height ( ) is calculated as NOGcap N sub cap O cap G end-sub
(Number of Transfer Units): Determined by the required removal efficiency. HOGcap H sub cap O cap G end-sub
(Height of a Transfer Unit): Determined by the mass transfer coefficient of the packing.
HETP Method: Alternatively, use the Height Equivalent to a Theoretical Plate (HETP) for equilibrium-based calculations. C. Pressure Drop and Power Lec 20: Scrubber - Example problem
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 Do you have a specific scrubber type (Venturi,
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.
Here’s a structured content draft for a webpage, blog post, or product description focused on "Scrubber Design Calculation Excel Best." The tone is professional, technical, and solution-oriented.
A tall column is useless if the packing isn’t wet. Calculate:
Use the Sherwood–Eckert generalized pressure drop correlation.
Your sheet needs a "Fluid Properties" tab. You will need:
Excel tip: Use VLOOKUP tables for water properties vs. temperature.
The client needs to know how powerful their fan must be.
Calculate the molar flow rate of the pollutant.
To elevate your spreadsheet from a simple calculator to a professional engineering tool, integrate these features: