To automate pressure drop and flooding calculations, build a lookup table on a separate tab containing constants for common packing materials (e.g., Pall Rings, Raschig Rings, or structured packing). Use XLOOKUP or VLOOKUP to automatically pull the correct packing factor ( Fpcap F sub p
where:
To build a reliable calculation tool, structure your Excel workbook into four dedicated tabs. This separation keeps inputs, physical properties, calculations, and outputs cleanly organized. scrubber design calculation excel hot
To prevent the liquid from being blown out of the top of the scrubber, you must calculate the tower's cross-sectional area based on the gas velocity. Calculate the Flooding Gas Velocity ( Ufcap U sub f ) using the Sherwood-Lobo Correlation . Excel Formula: Set your operating velocity ( Uopcap U sub o p end-sub ) at 60% to 70% of the flooding velocity. To automate pressure drop and flooding calculations, build
For effective particulate and acid gas removal, typical L/G ratios range from . To prevent the liquid from being blown out
) are commonly used to find the required packing depth for your target removal efficiency. Standard Target: removal efficiency. Hydraulic Performance (Pressure Drop)
Q_actual = Q_inlet * (T_out + 460) / (T_in + 460) * (P_in / P_out)