This is the engine of the spreadsheet.

1. Enthalpy Calculation (using Steam Table logic or add-in):

2. Isentropic Expansion (Nozzle): The steam expands isentropically from Motive Pressure to Suction Pressure.

3. Mixing Calculations (The Iterative Part): We need to find the Mass Flow Ratio ($\mu = M_s / M_m$).

4. Compression in Diffuser: The fluid mixture is compressed from Suction Pressure to Discharge Pressure.

5. The Goal Seek / Solver Setup: Instead of manual iterations, set up a check cell:


A well-structured spreadsheet contains the following 10 tabs:

ARM = 12.5 (from interpolation)

Best for liquid-liquid ejectors (e.g., pumping seawater with a pressurized water jet). Assumes mixing occurs in a constant cross-section throat.

Key equation:

This Excel sheet is built upon the One-Dimensional Flow Theory and the Conservation of Energy and Mass.

Use either:

Example formula for water vapor pressure (Antoine equation):

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

Spreadsheet calculations are approximate. Always: