Scrubber Design Calculation Excel Best [ COMPLETE ]
Use =IF(Flood%>0.85, "WARNING: Close to flooding", "OK")
Use conditional formatting to turn the cell red if pressure drop exceeds 1.5 inH2O/ft.
Excel is not "just a spreadsheet" – it is the most accessible, auditable, and practical tool for scrubber design calculations. When built with best practices (clear inputs, unit consistency, flooding checks, and graphical output), an Excel-based scrubber design tool outperforms many black-box programs for 80% of real-world engineering tasks.
Need a ready-to-use template? Reach out – I can share a structured example or build a custom one for your gas stream.
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 scrubber design calculation excel best
To ensure your Excel guide is robust, it should feature the following sections: Venturi Scrubber Design Calculations | PDF | Gases - Scribd
For a comprehensive review of scrubber design calculation Excel tools, the
spreadsheets are those that balance robust hydraulic modeling (diameter and pressure drop) with verified chemical absorption data. Top Scrubber Design Excel Tools EPA Air Pollution Control Cost Manual Spreadsheets
: These are considered the gold standard for regulatory and preliminary engineering. They provide detailed capital and annualized cost estimates
for wet and dry scrubbers, including specific tabs for packed bed scrubber design parameters and cost estimation. Meloni Marco’s Spray Tower Scrubber Sheet
: Highly rated for its user-friendliness, this tool provides a preliminary calculation of single-stage spray towers
, including removal efficiency and pressure loss estimates. It is uniquely valuable for its bilingual (English/Italian) user guide and documented bibliographical references. Packed Column Scrubber Templates (Scribd/Aimequip) : Popular professional-grade templates that focus on hydraulic checks
, calculating column diameter, % flooding, and fan power requirements based on packing types like Intalox saddles or Pall rings. www.melonimarco.it Key Evaluation Criteria for Scrubber Excel Sheets Use =IF(Flood%>0
When selecting or reviewing a spreadsheet, look for these critical components: Importance Hydraulic Diameter Calculation
Must calculate tower cross-sectional area based on gas/liquid flow rates and gas density. Flooding Analysis
Should include a "percentage of flooding" check (typically targeted between ) to ensure operational stability. Pressure Drop Estimates
Essential for sizing fans/blowers; should account for both irrigated and dry packing, plus internal losses. Packing Databases
Should allow users to select from standard packing types (e.g., Raschig rings, saddles) with pre-loaded packing factors ( cap F sub p Removal Efficiency Modeling
Advanced sheets use mass transfer coefficients or correlations (like Norton's) to estimate the required packing height. Wet & Dry FGD Data Inputs
The Ultimate Guide to Scrubber Design Calculations in Excel Designing an industrial wet scrubber requires precision, as even small errors in column diameter or liquid-to-gas (L/G) ratios can lead to system failure or excessive energy consumption. Using an Excel-based calculation tool is the most efficient way to handle these complex, iterative design processes. Core Components of a Scrubber Design Excel Sheet
A professional-grade scrubber design spreadsheet should be divided into logical sections to ensure accuracy and ease of use: Excel is not "just a spreadsheet" – it
Input Data Streams: Cells for entering gas flow rates (ACFM), inlet temperatures, pressures, and pollutant concentrations.
Physical Properties: Automated lookups for gas density, liquid viscosity, and molecular weights.
Packing Characteristics: A database of common packing materials like Intalox Saddles or Pall Rings, including their specific packing factors ( Fpcap F sub p
Hydraulic Design: Calculations for column diameter based on flooding percentages (typically kept between 50% and 85%). Performance Metrics: Formulas for pressure drop ( ΔPcap delta cap P
), removal efficiency, and Height Equivalent to a Theoretical Plate (HETP). Key Formulas for Your Excel Template
To build the "best" calculation sheet, you must integrate standard engineering correlations:
HCL Packed Column Scrubber Design | PDF | Mole (Unit) - Scribd
“Best $49 I’ve spent. Cut my design time from 2 days to 1 hour.” – James K., Process Engineer
“The packed tower flooding check saved me from a costly mistake.” – Maria L., Environmental Consultant
