Scrubber Design Calculation Excel Hot · Tested & Working

If you don't want to rebuild the wheel from scratch, here are your options:

By: Chemical Engineering Hub

In the world of industrial air pollution control, the wet scrubber remains a non-negotiable workhorse. Whether you are dealing with kiln exhaust, furnace flue gas, or high-temperature reactor off-gases, the challenge is always the same: How do we cool and clean the gas efficiently?

If you have searched for "scrubber design calculation excel hot," you are likely an engineer or plant operator tired of manual spreadsheets that crumble under high thermal loads. You need a robust, dynamic tool.

This article explores the core calculations for designing a venturi or packed bed scrubber for hot gas streams and how to build (or source) an Excel template that won't freeze or fail you. scrubber design calculation excel hot

Automatically populated, ready to print or share:

| Parameter | Value | Unit | |-----------|-------|------| | Gas flow rate (actual @ T,in) | 25,000 | m³/h | | Inlet gas temperature | 850 | °C | | Outlet gas temperature | 72 | °C | | Evaporation rate | 2.8 | L/s | | Scrubber type | Venturi | - | | Pressure drop | 12.4 | kPa | | Overall efficiency (2 µm) | 96.3 | % | | d50 cut diameter | 0.85 | µm | | Vessel diameter | 1.8 | m | | Total installed cost (est.) | $187,000 | USD | | Annual operating cost | $34,200 | USD/year |

Here is a simple row-by-row layout. Paste this into A1:

| | A | B | C | | :--- | :--- | :--- | :--- | | 1 | Parameter | Value | Units | | 2 | Gas flow (actual) | 12500 | m³/h | | 3 | Gas inlet temp | 220 | °C | | 4 | Gas outlet temp | 65 | °C | | 5 | Gas density | =1.293*(273/(B3+273)) | kg/m³ | | 6 | L/G ratio | 2.0 | L/m³ | | 7 | Liquid flow | =B2*B6/1000 | m³/h | | 8 | Flow parameter | =B6*SQRT(B5/1000) | - | | 9 | K4 (flood) | =VLOOKUP("2inPall",PackingTable,2) | - | | 10 | K4 (design @70%) | =B9*0.7 | - | | 11 | Gas velocity | =SQRT(B10*(1000-B5)/(13.1*17*0.001^0.1)) | m/s | | 12 | Column diameter | =SQRT((B2/3600)/(0.785*B11)) | m | If you don't want to rebuild the wheel

(Note: You'll need to create a range named "PackingTable" for the VLOOKUP)

The efficiency is governed by the inertial impaction parameter ($\Psi$). Larger particles and higher relative velocities result in higher efficiency.

For a hot gas stream entering a well-insulated scrubber (adiabatic), the gas will cool to the adiabatic saturation temperature (wet-bulb temperature), assuming sufficient liquid flow and residence time.

The Heat Balance Equation (Imperial Units): Here is a simple row-by-row layout

Q_sensible = Q_latent

M_gas * Cp_gas * (T_in - T_out) = M_evap * h_fg

Where:

Excel Challenge: T_out is not known because the humidity ratio changes. You must use Goal Seek or iterative circular logic.

You can download generic calculators, but here is how to build the professional-grade version that stands out.