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: