Store physical properties in secondary tabs. Use Excel lookup functions to pull data dynamically based on user selections. Tables containing packing factors ( Fpcap F sub p
The use of Excel for scrubber design calculation has several advantages:
Understanding the underlying mathematics is essential before building your Excel spreadsheet. The core calculations can be categorized by scrubber type, but many principles overlap. scrubber design calculation excel best
Determine the power needed to overcome the scrubber pressure drop.
The design sheet calculates the structural dimensions required to ensure efficient mass transfer while preventing column flooding. Store physical properties in secondary tabs
The choice of packing directly affects the pressure drop, efficiency, and overall height of your system. Packing Type Packing Factor ( Fpcap F sub p Mass Transfer Efficiency Relative Pressure Drop Low to Medium Pall Rings Medium to High Saddles (IMTP/Intalox) Structured Packing Exceptionally Low 5. Build the Excel Sheet Architecture
Cells executing the explicit algebraic steps for flooding velocity, diameter calculation, and Onda’s correlations. The core calculations can be categorized by scrubber
=LN((Y_in - Y_star_in) / (Y_out - Y_star_out))