Use the Ideal Gas Law customized for Excel syntax: =(Pressure_atm * MolWeight) / (0.08206 * (Temp_C + 273.15))
Run this sanity check before trusting the output:
Create a table for containing columns for Name, Size, Packing Factor ( Fpcap F sub p ), and Surface Area (
Below is the definitive methodology for building or evaluating a top-tier wet scrubber design spreadsheet (Venturi, Packed Bed, or Spray Tower).
| Feature | Benefit | |---------|---------| | | Venturi, packed tower, and spray tower in one file. | | Built‑in physical properties | Air/water properties at user‑defined temperatures. | | Instant pressure drop calc | Calvert’s & Boll’s methods for venturi scrubbers. | | Collection efficiency curves | Plot efficiency vs. particle diameter (0.1–10 µm). | | Packed bed design | Calculate packing height, diameter, flooding % (Sherwood correlation). | | Automatic unit conversion | SI / US customary units with no manual scaling. | | Graphical outputs | Charts for ΔP, L/G ratio, and efficiency. | | Validation against real data | Sample case included (coal‑fired boiler fly ash). |
You can build custom formulas tailored to specific chemical reactions or waste streams 1.
NTU = LN( (y_in - y_eq_in) / (y_out - y_eq_out) )
Keep all user interactions on a single sheet. Use clear visual coding (e.g., light blue cells for user inputs, grey cells for automated outputs).