Scrubber Design Calculation Excel Best Better [VERIFIED]
: Ensure the calculated pressure drop stays within the standard operating range of ✅ Summary of Core Formulas
An optimized Excel spreadsheet is the industry-standard tool for process engineers to perform these iterative calculations quickly and accurately. This comprehensive guide covers the essential engineering formulas, design parameters, and step-by-step setup required to build the best packed bed scrubber design calculation sheet in Excel. 1. Core Engineering Parameters for Scrubber Design
HTU=GmKGaPcap H cap T cap U equals the fraction with numerator cap G sub m and denominator cap K sub cap G a cap P end-fraction Gmcap G sub m is molar gas flux, KGacap K sub cap G a is mass transfer coefficient, P is pressure. 4. Best Practices for Scrubber Calculation in Excel
): Total square feet of surface area per cubic foot of packing ( 2. Step-by-Step Design Calculations for Excel
[Tab 1: Cover & Instructions] ─── Purpose, Version Control, User Guide [Tab 2: Design Inputs] ───────── Gas/Liquid Specs, Target Efficiency, Packing Constants [Tab 3: Calculations] ────────── Column Diameter, HTU/NTU, Pressure Drop, Fan Power [Tab 4: Outputs & Summary] ───── Spec Sheet, Dimensions, Pump & Fan Requirements [Tab 5: Data References] ─────── Packing Factors, Gas Constants, Antoine Coefficients Use code with caution. Section 1: Input Data (User-Defined) scrubber design calculation excel best
Inputs for inlet gas flow rate, temperature, pressure, and detailed pollutant concentration.
To elevate your spreadsheet from a simple calculator to a professional engineering tool, integrate these features:
To build a professional, error-free utility, organize your workbook into four sequential, color-coded tabs: Tab 1: Dashboard & Inputs
). High pressure drops cause excessive fan power consumption and risk structural damage to column internals. : Ensure the calculated pressure drop stays within
Large callout cells displaying calculated Column Diameter ( ), Total Packed Height ( ), Liquid-to-Gas ( ) Ratio, and Total Pressure Drop. Tab 2: Fluid Properties & Kinetics
Add a 15% to 20% safety margin to the calculated bed height to account for non-ideal gas distribution in real-world operations.
ρg=P⋅MwR⋅Trho sub g equals the fraction with numerator cap P center dot cap M sub w and denominator cap R center dot cap T end-fraction
Step 2: Determine the Generalized Pressure Drop Correlation (GPDC) Y-Value The Generalized Pressure Drop Correlation curve plots against a capacity parameter ( ). At the flooding point, Yfloodcap Y sub f l o o d end-sub can be calculated via the Generalized Leva-Lobo equation: Step-by-Step Design Calculations for Excel [Tab 1: Cover
To prevent column flooding, the tower diameter must be sized based on the gas velocity. Engineers generally design scrubbers to operate at 60% to 80% of the flooding velocity. Calculate using the gas density ( ρgrho sub g ) and cross-sectional area.
These equations are all programmable in Excel, as noted by engineering experts in the field. Several engineers have already created working spreadsheets based on these design equations, which you can adapt for your own use.
Store physical properties in secondary tabs. Use Excel lookup functions to pull data dynamically based on user selections. Tables containing packing factors ( Fpcap F sub p
Designing an efficient wet scrubber requires balancing thermodynamics, fluid mechanics, and mass transfer. While specialized process simulation software exists, a verified, custom-built Excel spreadsheet remains the best tool for daily engineering checks, rapid sizing, and iterative design.
This prevents #NUM! from crashing the sheet.