Accessing backend system…
While I cannot provide a direct file, the best public domain Excel scrubber calculator is the EPA’s Air Pollution Control Cost Estimation Spreadsheet (updated 2021). Search for:
"EPA OAQPS Control Cost Manual" + Excel scrubber
It includes:
Pro tip: Copy only the calculation logic into your own workbook, then strip out VBA (if any) and replace with dynamic arrays (FILTER, SORT) for Excel 365.
The most common source of scrubber design errors is unit mismatch (e.g., mixing Standard Cubic Feet per Minute (SCFM) with Actual Cubic Feet per Minute (ACFM)).
Start with what you need to remove. In Excel, set up:
Excel Formula Example:
Outlet Mass = Inlet Mass * (1 - Efficiency/100)
Liquid Flow (GPM) = (L/G Ratio) * Gas Flow (ACFM) / 1000
Add a simple tab:
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
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
Designing a wet scrubber requires balancing hydraulic constraints with mass transfer requirements to achieve a specific removal efficiency. Utilizing Excel for these calculations allows for iterative design, especially when determining the optimal tower diameter and packing height based on flooding percentages and pressure drop limits. Core Calculation Methodology
The design of a packed column scrubber typically follows a sequence from initial gas properties to final vessel dimensions: Gas and Liquid Characterization
: 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
) and the scrubbing medium properties (density and viscosity). Column Diameter Determination
: Use the Generalized Pressure Drop Correlation (GPDC) to find the flooding gas velocity. Designers usually target 50% to 85% of the flooding velocity to ensure stable operation. Formula for Area Formula for Diameter Mass Transfer & Packing Height : The total height ( ) is the product of the Number of Transfer Units ( cap N sub cap O cap G end-sub ) and the Height of a Transfer Unit ( cap H sub cap O cap G end-sub HETP (Height Equivalent to a Theoretical Plate) : Often calculated using correlations like Norton’s Billet & Schultes A typical design factor of 20% safety
is applied for columns with fewer than 15 theoretical stages. Pressure Drop Analysis
: Total pressure drop includes losses from dry packing, liquid spraying, and internal supports. A common design target is an initial drop of cap H sub 2 cap O of packing. Best Practices for Excel Design Sheets
To build the "best" Excel tool, integrate the following features found in professional-grade templates: Individual Design of 2 Scrubbers - UKDiss.com
You can find pre-built Excel templates for scrubber design on engineering forums (Cheresources, Eng-Tips) for free. But the best solution is building your own because:
If you must download, look for sheets that include:
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.
The keyword "scrubber design calculation excel best" is searched by thousands of engineers each month. Why? Because they know that a well-structured Excel workbook is the fastest path from gas conditions to a purchase-ready column specification. scrubber design calculation excel best
To summarize the "Best" approach:
Excel doesn't have CFD or AI—yet. But for robust, transparent, and immediate scrubber design calculations, it remains the undisputed best tool for the working chemical engineer.
Next Steps:
About the Author: [Your Name] is a process engineer with 12 years of experience in air pollution control and Excel-based process design. He has sized over 50 scrubbers using spreadsheets – and only 2 of them reworked.
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
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 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.
To create or select the ultimate spreadsheet for wet scrubber design, engineers must integrate hydraulic capacity, mass transfer efficiency, and structural constraints into a unified, automated workbook. Core Design Modules for Excel
An effective scrubber design spreadsheet must be broken down into distinct, sequential calculation modules.
Gas Characterization: Inputs for inlet gas flow rate, temperature, pressure, and detailed pollutant concentration.
Physical Properties: Automated lookup tables or formulas for gas density, viscosity, and pollutant solubility (Henry's law constants).
Packing/Tray Hydraulics: Calculations for column diameter based on flooding velocity limits (typically 60-80% of flood).
Mass Transfer: Determination of the Height of a Transfer Unit (HTU) and Number of Transfer Units (NTU) to calculate the total packed bed height.
Pressure Drop: Empirical correlations (like the Leva or Billet and Schultes models) to predict gas-side pressure drop per foot of packing. Essential Excel Features for Engineering Accuracy
To elevate a basic spreadsheet into a professional-grade engineering tool, specific Excel functionalities must be utilized. ⚡ Visual Basic for Applications (VBA)
Many mass transfer calculations, particularly those involving multi-component absorption or non-isothermal conditions, require iterative solutions. VBA macros can handle these loops seamlessly without causing circular reference errors in the grid. 📊 Data Validation and Lookups
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
The native Goal Seek tool is invaluable for finding the exact column diameter required to achieve a specific target pressure drop or to lock in a precise removal efficiency percentage. Critical Design Parameters to Calculate
Your spreadsheet must compute and display these key metrics clearly to validate the equipment design:
Liquid-to-Gas (L/G) Ratio: The fundamental operating parameter that dictates removal efficiency and operational cost.
Scrubber Diameter: Calculated to ensure gas velocities do not cause liquid entrainment or flooding.
Packed Height: The actual contact length required to achieve the target emission reduction.
Droplet Elimination: Sizing calculations for the mist eliminator at the top of the tower to prevent liquid carryover. Best Practices for Spreadsheet Integrity
Building a robust calculation tool requires strict adherence to spreadsheet engineering standards.
Color Coding: Use strict conventions (e.g., yellow fill for user inputs, gray for reference data, and no fill for calculated formulas). While I cannot provide a direct file, the
Unit Consistency: Clearly label every single cell with its unit (e.g., acfm, gpm, lb/ft³) and include automated conversion toggles between SI and English units.
Limit Checks: Use conditional formatting to highlight cells in red if calculated values exceed safe engineering limits (such as a flooding approach velocity exceeding 80%).
Designing a scrubber—whether it's a wet scrubber for industrial gas cleaning or a simpler air scrubber
for a room—requires balancing air chemistry and fluid dynamics.
To build the "best" Excel tool, you shouldn't just plug in numbers; you need a structured workflow that handles everything from removal efficiency 1. The Core Calculation Workflow
A professional-grade scrubber design tool should follow these sequential steps: Step 1: Input Gas Characteristics:
Define the inlet gas flow rate (ACFM), temperature, pressure, and the concentration of the contaminant (e.g., cap S cap O sub 2 cap H cap C l , or dust). Step 2: Determine Liquid-to-Gas (L/G) Ratio:
This is the "magic number" for efficiency. For soluble gases or dust, typical ratios range from 0.5 to 3 liters per (4–20 gallons per 1000 Step 3: Size the Tower (Diameter):
Calculate the cross-sectional area by dividing the gas flow rate by the allowable "gas velocity" (typically ~500 feet per minute for many industrial designs). Step 4: Calculate Efficiency: Use the formula: Efficiency % Inlet Concentration Outlet Concentration Inlet Concentration
Efficiency % equals the fraction with numerator Inlet Concentration minus Outlet Concentration and denominator Inlet Concentration end-fraction cross 100 Step 5: Estimate Pressure Drop:
This determines your blower size and operational cost. High pressure drops generally mean better cleaning but higher electricity bills. Sly Air Pollution Control 2. Best Practices for Your Excel Layout
To make your Excel sheet functional and "bulletproof," organize it into these four distinct tabs: Key Features User data entry only. Data Validation (dropdowns) for units (e.g., cap C cap F cap M II. Constants Reference data.
Tables for gas constants, water density, and packing material factors. III. Calculations The "Engine Room."
Intermediate steps like saturation calculations and heat balances. IV. Results Final output.
Use a summary table with "Pass/Fail" flags for design limits (e.g., velocity limits). 3. Pro-Tips for Accuracy Heat Balance is Key:
Don't forget that as water evaporates to cool the hot inlet gas, the volume of gas changes. Your Excel formulas must account for the saturated outlet volume Packing Factors:
If designing a packed bed scrubber, include a lookup table for different packing types (e.g., Raschig rings, Pall rings) as these significantly affect the pressure drop. Automate Unit Conversion: Use Excel's
function to allow users to toggle between Metric and Imperial units without breaking the math. Sly Air Pollution Control 4. Technical Resources for Templates
If you are looking for specific design equations or existing templates to study: EPA Wet Scrubber Guide
The industry standard for acid gas scrubber design procedures. Sly Inc. Application Guide Excellent for understanding sizing based on shell velocity. Torch-Air Technical Blog Provides detailed breakdowns of the heat balance and ratio formulas. Sly Air Pollution Control Are you designing this for a specific contaminant cap N cap H sub 3 or dust) or a general-purpose ventilation system? Wet Scrubber Application Guide - Sly Inc.
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
Wet scrubbers are essential industrial systems used to remove pollutants from furnace flue gas or other gas streams. Using an Excel-based approach for scrubber design calculations allows engineers to iterate quickly through different gas flow rates, pollutant concentrations, and liquid-to-gas ratios.
The primary goal of a scrubber is to maximize the contact time and surface area between the dirty gas and the scrubbing liquid. Whether you are designing a venturi scrubber for particulate matter or a packed tower for acid gas removal, the fundamental calculations remain the same.
A robust Excel tool for scrubber design should include the following sections: 1. Input Parameters and Gas Properties
Start by defining the characteristics of the inlet gas stream. This data acts as the foundation for every subsequent calculation.
Gas Flow Rate: Define this in both Actual Cubic Feet per Minute (ACFM) and Standard Cubic Feet per Minute (SCFM). Gas Temperature: Inlet and target outlet temperatures. Pro tip: Copy only the calculation logic into
Gas Composition: Molecular weight of the gas stream (usually close to air, 29 lb/lb-mol).
Pollutant Concentration: Parts per million (ppm) or grains per cubic foot (gr/acf). 2. Sizing the Scrubber Diameter
The diameter of the tower is determined by the gas velocity. If the velocity is too high, the gas will carry the liquid out of the top (entrainment). If it is too low, the scrubber becomes unnecessarily large and expensive.
Flooding Velocity: Use the Sherwood-Shipley-Holloway correlation to determine the point where liquid can no longer flow down against the rising gas.
Operating Velocity: Typically set at 60% to 80% of the flooding velocity.
Cross-Sectional Area: Calculated by dividing the flow rate by the operating velocity. 3. Calculating the Packing Height (Mass Transfer)
The height of the packing material determines the efficiency of the pollutant removal. This is often calculated using the Number of Transfer Units (NTU) and the Height of a Transfer Unit (HTU).
NTU: This represents how difficult the separation is. It is calculated based on the log-mean concentration difference between the inlet and outlet.
HTU: This represents the efficiency of the specific packing material used.
Total Height: The formula is simply Total Height = NTU x HTU. 4. Pressure Drop Calculations
The pressure drop is a critical value because it determines the size and power consumption of the fan or blower required to move the gas through the system. Dry Pressure Drop: Resistance of the packing itself.
Wet Pressure Drop: Resistance caused by the liquid flowing over the packing.
Eckert’s Generalized Pressure Drop Correlation: This is the industry standard formula to implement in Excel to predict pressure drop based on gas/liquid loading. 5. Liquid-to-Gas (L/G) Ratio
The L/G ratio is the amount of liquid used per volume of gas. Increasing the liquid flow generally improves removal efficiency but increases the pressure drop and operating costs. Most scrubbers operate in the range of 5 to 50 gallons per 1,000 cubic feet of gas. Why Excel is the Best Tool for Scrubber Design
While specialized simulation software exists, Excel remains the preferred choice for many engineers for several reasons:
Transparency: You can see every formula and understand the physics behind the calculation.
Customization: You can easily add "What-If" scenarios to see how the design reacts to a 20% increase in gas flow.
Portability: Excel files are easy to share with clients and stakeholders without requiring expensive software licenses.
By building a structured spreadsheet with these five sections, you can create a high-performance scrubber design tool that ensures environmental compliance and operational efficiency. To help you get the most accurate results, tell me:
Are you designing for particulate removal or gas absorption (like SO2 or HCl)? What is your target removal efficiency (e.g., 99%)?
Do you have a specific packing material in mind (e.g., Raschig rings, Pall rings)?
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.
Related search suggestions sent.
Want to check out an issue? Sign up to receive a special offer.
While I cannot provide a direct file, the best public domain Excel scrubber calculator is the EPA’s Air Pollution Control Cost Estimation Spreadsheet (updated 2021). Search for:
"EPA OAQPS Control Cost Manual" + Excel scrubber
It includes:
Pro tip: Copy only the calculation logic into your own workbook, then strip out VBA (if any) and replace with dynamic arrays (FILTER, SORT) for Excel 365.
The most common source of scrubber design errors is unit mismatch (e.g., mixing Standard Cubic Feet per Minute (SCFM) with Actual Cubic Feet per Minute (ACFM)).
Start with what you need to remove. In Excel, set up:
Excel Formula Example:
Outlet Mass = Inlet Mass * (1 - Efficiency/100)
Liquid Flow (GPM) = (L/G Ratio) * Gas Flow (ACFM) / 1000
Add a simple tab:
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
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
Designing a wet scrubber requires balancing hydraulic constraints with mass transfer requirements to achieve a specific removal efficiency. Utilizing Excel for these calculations allows for iterative design, especially when determining the optimal tower diameter and packing height based on flooding percentages and pressure drop limits. Core Calculation Methodology
The design of a packed column scrubber typically follows a sequence from initial gas properties to final vessel dimensions: Gas and Liquid Characterization
: 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
) and the scrubbing medium properties (density and viscosity). Column Diameter Determination
: Use the Generalized Pressure Drop Correlation (GPDC) to find the flooding gas velocity. Designers usually target 50% to 85% of the flooding velocity to ensure stable operation. Formula for Area Formula for Diameter Mass Transfer & Packing Height : The total height ( ) is the product of the Number of Transfer Units ( cap N sub cap O cap G end-sub ) and the Height of a Transfer Unit ( cap H sub cap O cap G end-sub HETP (Height Equivalent to a Theoretical Plate) : Often calculated using correlations like Norton’s Billet & Schultes A typical design factor of 20% safety
is applied for columns with fewer than 15 theoretical stages. Pressure Drop Analysis
: Total pressure drop includes losses from dry packing, liquid spraying, and internal supports. A common design target is an initial drop of cap H sub 2 cap O of packing. Best Practices for Excel Design Sheets
To build the "best" Excel tool, integrate the following features found in professional-grade templates: Individual Design of 2 Scrubbers - UKDiss.com
You can find pre-built Excel templates for scrubber design on engineering forums (Cheresources, Eng-Tips) for free. But the best solution is building your own because:
If you must download, look for sheets that include:
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.
The keyword "scrubber design calculation excel best" is searched by thousands of engineers each month. Why? Because they know that a well-structured Excel workbook is the fastest path from gas conditions to a purchase-ready column specification.
To summarize the "Best" approach:
Excel doesn't have CFD or AI—yet. But for robust, transparent, and immediate scrubber design calculations, it remains the undisputed best tool for the working chemical engineer.
Next Steps:
About the Author: [Your Name] is a process engineer with 12 years of experience in air pollution control and Excel-based process design. He has sized over 50 scrubbers using spreadsheets – and only 2 of them reworked.
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
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 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.
To create or select the ultimate spreadsheet for wet scrubber design, engineers must integrate hydraulic capacity, mass transfer efficiency, and structural constraints into a unified, automated workbook. Core Design Modules for Excel
An effective scrubber design spreadsheet must be broken down into distinct, sequential calculation modules.
Gas Characterization: Inputs for inlet gas flow rate, temperature, pressure, and detailed pollutant concentration.
Physical Properties: Automated lookup tables or formulas for gas density, viscosity, and pollutant solubility (Henry's law constants).
Packing/Tray Hydraulics: Calculations for column diameter based on flooding velocity limits (typically 60-80% of flood).
Mass Transfer: Determination of the Height of a Transfer Unit (HTU) and Number of Transfer Units (NTU) to calculate the total packed bed height.
Pressure Drop: Empirical correlations (like the Leva or Billet and Schultes models) to predict gas-side pressure drop per foot of packing. Essential Excel Features for Engineering Accuracy
To elevate a basic spreadsheet into a professional-grade engineering tool, specific Excel functionalities must be utilized. ⚡ Visual Basic for Applications (VBA)
Many mass transfer calculations, particularly those involving multi-component absorption or non-isothermal conditions, require iterative solutions. VBA macros can handle these loops seamlessly without causing circular reference errors in the grid. 📊 Data Validation and Lookups
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
The native Goal Seek tool is invaluable for finding the exact column diameter required to achieve a specific target pressure drop or to lock in a precise removal efficiency percentage. Critical Design Parameters to Calculate
Your spreadsheet must compute and display these key metrics clearly to validate the equipment design:
Liquid-to-Gas (L/G) Ratio: The fundamental operating parameter that dictates removal efficiency and operational cost.
Scrubber Diameter: Calculated to ensure gas velocities do not cause liquid entrainment or flooding.
Packed Height: The actual contact length required to achieve the target emission reduction.
Droplet Elimination: Sizing calculations for the mist eliminator at the top of the tower to prevent liquid carryover. Best Practices for Spreadsheet Integrity
Building a robust calculation tool requires strict adherence to spreadsheet engineering standards.
Color Coding: Use strict conventions (e.g., yellow fill for user inputs, gray for reference data, and no fill for calculated formulas).
Unit Consistency: Clearly label every single cell with its unit (e.g., acfm, gpm, lb/ft³) and include automated conversion toggles between SI and English units.
Limit Checks: Use conditional formatting to highlight cells in red if calculated values exceed safe engineering limits (such as a flooding approach velocity exceeding 80%).
Designing a scrubber—whether it's a wet scrubber for industrial gas cleaning or a simpler air scrubber
for a room—requires balancing air chemistry and fluid dynamics.
To build the "best" Excel tool, you shouldn't just plug in numbers; you need a structured workflow that handles everything from removal efficiency 1. The Core Calculation Workflow
A professional-grade scrubber design tool should follow these sequential steps: Step 1: Input Gas Characteristics:
Define the inlet gas flow rate (ACFM), temperature, pressure, and the concentration of the contaminant (e.g., cap S cap O sub 2 cap H cap C l , or dust). Step 2: Determine Liquid-to-Gas (L/G) Ratio:
This is the "magic number" for efficiency. For soluble gases or dust, typical ratios range from 0.5 to 3 liters per (4–20 gallons per 1000 Step 3: Size the Tower (Diameter):
Calculate the cross-sectional area by dividing the gas flow rate by the allowable "gas velocity" (typically ~500 feet per minute for many industrial designs). Step 4: Calculate Efficiency: Use the formula: Efficiency % Inlet Concentration Outlet Concentration Inlet Concentration
Efficiency % equals the fraction with numerator Inlet Concentration minus Outlet Concentration and denominator Inlet Concentration end-fraction cross 100 Step 5: Estimate Pressure Drop:
This determines your blower size and operational cost. High pressure drops generally mean better cleaning but higher electricity bills. Sly Air Pollution Control 2. Best Practices for Your Excel Layout
To make your Excel sheet functional and "bulletproof," organize it into these four distinct tabs: Key Features User data entry only. Data Validation (dropdowns) for units (e.g., cap C cap F cap M II. Constants Reference data.
Tables for gas constants, water density, and packing material factors. III. Calculations The "Engine Room."
Intermediate steps like saturation calculations and heat balances. IV. Results Final output.
Use a summary table with "Pass/Fail" flags for design limits (e.g., velocity limits). 3. Pro-Tips for Accuracy Heat Balance is Key:
Don't forget that as water evaporates to cool the hot inlet gas, the volume of gas changes. Your Excel formulas must account for the saturated outlet volume Packing Factors:
If designing a packed bed scrubber, include a lookup table for different packing types (e.g., Raschig rings, Pall rings) as these significantly affect the pressure drop. Automate Unit Conversion: Use Excel's
function to allow users to toggle between Metric and Imperial units without breaking the math. Sly Air Pollution Control 4. Technical Resources for Templates
If you are looking for specific design equations or existing templates to study: EPA Wet Scrubber Guide
The industry standard for acid gas scrubber design procedures. Sly Inc. Application Guide Excellent for understanding sizing based on shell velocity. Torch-Air Technical Blog Provides detailed breakdowns of the heat balance and ratio formulas. Sly Air Pollution Control Are you designing this for a specific contaminant cap N cap H sub 3 or dust) or a general-purpose ventilation system? Wet Scrubber Application Guide - Sly Inc.
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
Wet scrubbers are essential industrial systems used to remove pollutants from furnace flue gas or other gas streams. Using an Excel-based approach for scrubber design calculations allows engineers to iterate quickly through different gas flow rates, pollutant concentrations, and liquid-to-gas ratios.
The primary goal of a scrubber is to maximize the contact time and surface area between the dirty gas and the scrubbing liquid. Whether you are designing a venturi scrubber for particulate matter or a packed tower for acid gas removal, the fundamental calculations remain the same.
A robust Excel tool for scrubber design should include the following sections: 1. Input Parameters and Gas Properties
Start by defining the characteristics of the inlet gas stream. This data acts as the foundation for every subsequent calculation.
Gas Flow Rate: Define this in both Actual Cubic Feet per Minute (ACFM) and Standard Cubic Feet per Minute (SCFM). Gas Temperature: Inlet and target outlet temperatures.
Gas Composition: Molecular weight of the gas stream (usually close to air, 29 lb/lb-mol).
Pollutant Concentration: Parts per million (ppm) or grains per cubic foot (gr/acf). 2. Sizing the Scrubber Diameter
The diameter of the tower is determined by the gas velocity. If the velocity is too high, the gas will carry the liquid out of the top (entrainment). If it is too low, the scrubber becomes unnecessarily large and expensive.
Flooding Velocity: Use the Sherwood-Shipley-Holloway correlation to determine the point where liquid can no longer flow down against the rising gas.
Operating Velocity: Typically set at 60% to 80% of the flooding velocity.
Cross-Sectional Area: Calculated by dividing the flow rate by the operating velocity. 3. Calculating the Packing Height (Mass Transfer)
The height of the packing material determines the efficiency of the pollutant removal. This is often calculated using the Number of Transfer Units (NTU) and the Height of a Transfer Unit (HTU).
NTU: This represents how difficult the separation is. It is calculated based on the log-mean concentration difference between the inlet and outlet.
HTU: This represents the efficiency of the specific packing material used.
Total Height: The formula is simply Total Height = NTU x HTU. 4. Pressure Drop Calculations
The pressure drop is a critical value because it determines the size and power consumption of the fan or blower required to move the gas through the system. Dry Pressure Drop: Resistance of the packing itself.
Wet Pressure Drop: Resistance caused by the liquid flowing over the packing.
Eckert’s Generalized Pressure Drop Correlation: This is the industry standard formula to implement in Excel to predict pressure drop based on gas/liquid loading. 5. Liquid-to-Gas (L/G) Ratio
The L/G ratio is the amount of liquid used per volume of gas. Increasing the liquid flow generally improves removal efficiency but increases the pressure drop and operating costs. Most scrubbers operate in the range of 5 to 50 gallons per 1,000 cubic feet of gas. Why Excel is the Best Tool for Scrubber Design
While specialized simulation software exists, Excel remains the preferred choice for many engineers for several reasons:
Transparency: You can see every formula and understand the physics behind the calculation.
Customization: You can easily add "What-If" scenarios to see how the design reacts to a 20% increase in gas flow.
Portability: Excel files are easy to share with clients and stakeholders without requiring expensive software licenses.
By building a structured spreadsheet with these five sections, you can create a high-performance scrubber design tool that ensures environmental compliance and operational efficiency. To help you get the most accurate results, tell me:
Are you designing for particulate removal or gas absorption (like SO2 or HCl)? What is your target removal efficiency (e.g., 99%)?
Do you have a specific packing material in mind (e.g., Raschig rings, Pall rings)?
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.
Related search suggestions sent.
Accessing backend system…
We're sorry, but your session has expired due to inactivity. Please use your browser to refresh this page and log in to our system again.
Message goes here.
Message goes here.
Message goes here.
Message goes here.
Collaborating with industry leaders to bring you the best PHP resources and expertise
Copyright Bright New Library © 2026. — All amounts in USD
