Scrubber Design Calculation Excel Best Jun 2026

NTU = −ln(1 − η). In Excel: = -LN(1 - Efficiency)

The packing material maximizes the contact surface area between the gas and liquid phases. This maximizes the absorption of the gaseous contaminant into the liquid phase.

Use conditional formatting to highlight cells in red if calculated values exceed safe engineering limits (such as a flooding approach velocity exceeding 80%). scrubber design calculation excel best

Add a simple tab:

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 NTU = −ln(1 − η)

Packed bed scrubbers are among the most common types you will encounter, so let us look at how to build a spreadsheet for this application.

Determination of the Height of a Transfer Unit (HTU) and Number of Transfer Units (NTU) to calculate the total packed bed height. Use conditional formatting to highlight cells in red

Efficiency % equals the fraction with numerator Inlet Concentration minus Outlet Concentration and denominator Inlet Concentration end-fraction cross 100 Step 5: Estimate Pressure Drop:

Produce a clean output worksheet with key results: vessel diameter, height, liquid flow rate, pressure drop, and expected efficiency.

Usually water or a chemical reagent solution (e.g., NaOHcap N a cap O cap H for acid gases). Liquid Density ( ρlrho sub l ) and Viscosity ( μlmu sub l ): Needed for hydraulics and pressure drop equations. Performance Target Removal Efficiency (