Here is the exact layout of a "best" scrubber calculator workbook:
Sheet 1: Control Panel (Inputs)
Sheet 2: Fluid Properties
Sheet 3: Column Sizing (Core Engine)
Sheet 4: Mechanical Summary
Sheet 5: Cost Estimate (Rough Order of Magnitude)
No one remembers that 1 ft³ = 28.3168 liters. Write a simple VBA function: scrubber design calculation excel best
Function ConvertUnits(Value, FromUnit, ToUnit)
' Case logic for "m3/hr to CFM", etc.
End Function
In the field of chemical and environmental engineering, the design of wet scrubbers is a critical task. While specialized simulation software exists, Microsoft Excel remains the industry standard for preliminary sizing, vendor verification, and detailed process calculations. Its transparency and flexibility make it the "best" platform for understanding the underlying physics of scrubber operation.
This text outlines the essential steps to create a robust, best-practice scrubber design calculator in Excel, focusing on Packed Bed Scrubbers (the most common type for gas absorption).
Create a dynamic chart showing:
Use the Sherwood–Eckert generalized pressure drop correlation.
This is mass transfer. The best Excel methods use HTU-NTU (Height of a Transfer Unit).
Sad but true: Rigorous HTU requires iteration. In your best Excel sheet, create a small lookup table of packing factors (KGa values) and use:
Z (packing height, ft) = NTU * HTU
Add 20% safety factor: = Z_calc * 1.2 Here is the exact layout of a "best"
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