Scrubber Design Calculation Excel Best May 2026

Function ConvertUnits(Value, FromUnit, ToUnit) ' Case logic for "m3/hr to CFM", etc. End Function Instead of manual trial for diameter, use VBA to call Solver:

SolverOk SetCell:="$M$10", MaxMinVal:=2, ValueOf:=0, ByChange:="$B$5" SolverSolve UserFinish:=True Goal: Minimize diameter while keeping pressure drop < 40 mmH2O/m. If absorption is concentrated (CO₂ in MEA, SO₂ in caustic), the NTU equation becomes implicit. Use circular references with Enable Iterative Calculation (max iterations 1000, max change 0.0001). 4. Error Trapping In every formula, add IFERROR . For example: scrubber design calculation excel best

For decades, engineers have relied on rigorous software like Aspen Plus or ChemCAD. However, for quick iterations, feasibility studies, and site-based troubleshooting, SO₂ in caustic)