For steam ejector design calculations, several specialized Excel spreadsheets and research papers provide the necessary thermodynamic correlations for entrainment ratios and nozzle sizing. Notable Ejector Design Resources
Steam Ejector Calculation Notes: This is a widely used free spreadsheet on Cheresources based on semi-empirical equations for entrainment ratio. It uses curve-fitting constants for both choked and non-choked flow conditions.
Lempor Ejector Calculator: A specialized calculator for steam locomotive exhaust systems that simplifies complex fluid dynamics into a multi-sheet Excel workbook.
Scribd - Steam Ejector Calculations XLS: This document outlines the specific constants (
) used to calculate mass flow rates of motive steam versus entrained vapor, along with area ratios for the nozzle throat and outlet. Key Design Parameters
Ejector performance is typically calculated using the following variables: Entrainment Ratio ( ejector design calculation xls
): The mass flow rate of entrained vapor divided by the mass flow rate of motive steam. Compression Ratio ( ): The ratio of discharge pressure ( Pccap P sub c ) to entrained vapor pressure ( Pecap P sub e ). Choked flow is generally defined as Expansion Ratio ( ): The ratio of motive steam pressure ( Ppcap P sub p ) to entrained vapor pressure ( Pecap P sub e Geometry Sizing: Determining the nozzle throat area ( A1cap A sub 1 ), nozzle outlet area ( A2cap A sub 2 ), and diffuser cross-sections. Foundational Research Papers
If you are looking for the underlying theory to build your own model, the following papers are the industry standard:
"Evaluation of Steam Ejectors" by Hisham Al Dessouky et al. (Chemical Engineering & Processing, 2002): Provides the empirical constants used in most modern spreadsheets.
"Estimation of ejector's main cross sections..." (Applied Thermal Engineering, 2004): Offers a step-by-step procedure for steam-ejector refrigeration systems.
Lempor Ejector Calculator Beta 1.1 | PDF | Steam Locomotive - Scribd For steam ejector design calculations , several specialized
Ejectors (also known as jet pumps or eductors) are simple yet highly effective devices that use a high-pressure fluid (motive fluid) to entrain and compress a lower-pressure fluid (suction fluid). They are widely used in chemical plants, HVAC systems, vacuum distillation, and wastewater treatment.
Unlike centrifugal pumps, ejectors have no moving parts – but their design is notoriously calculation-intensive. This is where an Ejector Design Calculation Excel Sheet becomes an engineer’s best friend.
In this post, we’ll cover:
CR = 0.4/0.1 = 4Before diving into spreadsheet formulas, we must establish the core physics.
An ejector consists of four main parts:
Abstract
Ejectors (or jet pumps) are passive fluid handling devices that use a high-pressure motive fluid to entrain and compress a secondary fluid. Their design involves iterative thermodynamic and fluid dynamic calculations. This paper presents a systematic methodology for ejector design calculation implemented in Microsoft Excel (XLS). The spreadsheet tool integrates key design parameters: entrainment ratio, area ratios, Mach number constraints, and pressure recovery. Validation against literature data shows agreement within ±5% for critical operating points. The tool enables rapid parametric studies without specialized software.
Keywords: Ejector design, jet pump, Excel calculation, entrainment ratio, area ratio, gas ejector, steam ejector.
If you do not have access to Steam Table functions in Excel, you can use the HEI (Heat Exchange Institute) empirical curves converted into formulas.
You can program a "Lookup Table" into a separate sheet:
Sheet 3: "HEI Curve Data" Create a table of Expansion Ratio vs. Compression Ratio for various flow ratios ($R = M_s / M_m$). Mastering Ejector Design Calculation Using Excel (XLS) –
| Exp. Ratio | Compr. Ratio (R=0.5) | Compr. Ratio (R=1.0) | | :--- | :--- | :--- | | 10 | 1.8 | 1.2 | | 20 | 2.5 | 1.6 | | ... | ... | ... |
Calculation Logic:
VLOOKUP or INDEX/MATCH to interpolate the table.