Scrubber Design Calculation Excel Best Updated

Depends on packing type and mass transfer coefficient. Total Packing Height (Z): Z = NTU × HTU 1. D. Pressure Drop Calculation

Lock all formula cells and password-protect the worksheet ( Review > Protect Sheet ). Leave only the designated input cells unlocked to prevent users from accidentally deleting complex engineering equations.

ratios) to prevent ugly #DIV/0! or #NUM! errors from breaking your dashboard layout. 5. Limitations of Excel and When to Upgrade

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

To help refine this calculation tool for your specific application, tell me:

to optimize L/G ratios.

The best spreadsheet is a validated spreadsheet. Do this: