An Excel-based ejector design spreadsheet has been developed based on constant-pressure mixing theory. The tool:

The XLS file accompanying this paper includes full formulas, validation cases, and charting macros.

The humble Excel spreadsheet is an extraordinarily capable platform for ejector design calculation. By combining thermodynamic property tables, empirical area-ratio correlations, momentum balances, and iterative solvers, you can create a .xls file that rivals dedicated software – with the added advantages of transparency, customizability, and zero licensing cost.

Whether you are designing a steam ejector for a vacuum distillation column, a liquid jet pump for a sump, or an eductor for a chemical reactor, the systematic approach outlined here will serve as your comprehensive blueprint.

Next steps for the reader:

With your own ejector design calculation .xls, you will transform a complex thermodynamics problem into a simple, robust engineering tool.

Need help with specific VBA macros or formula debugging? Join the r/Excel or r/ChemicalEngineering subreddits – many engineers share their ejector spreadsheet snippets.

Based on constant gas/vapor flow theory (or incompressible liquid jet theory):

Using momentum balance (implemented in Solver), find that predicted ṁ_s = 195 kg/h → close to 200. Slightly adjust ARM to 12.8.

The spreadsheet iteration takes less than 1 second.

Use either:

Example formula for water vapor pressure (Antoine equation):

=10^(A - B/(C+T))  ' Where A,B,C are constants for the fluid