Not every heat exchanger problem starts with a target outlet temperature. Often you already have an exchanger (existing or vendor-proposed) and need to know how it will actually perform — what heat duty and outlet temperatures it will deliver for a given flow and inlet condition. This is a “rating” problem, and it’s solved with the effectiveness-NTU method rather than a straight LMTD sizing calculation. This Heat Exchanger Effectiveness-NTU Excel Sheet from GrowMechanical automates that rating calculation.
It is built for process and mechanical engineers rating existing exchangers, evaluating vendor proposals, or checking off-design performance where outlet temperatures are unknown.
What This Sheet Calculates
- Heat capacity rates (C = ṁ × Cp) for both fluid streams
- Capacity ratio: Cr = Cmin / Cmax
- Number of Transfer Units: NTU = UA / Cmin
- Effectiveness (ε) using correlations for counter-flow, parallel-flow, and shell-and-tube arrangements
- Actual heat duty: Q = ε × Cmin × (Th,in − Tc,in)
- Resulting outlet temperatures for both streams
Why Use the Effectiveness-NTU Method
- Save Engineering Time: Rate an exchanger’s actual performance without iterating on an LMTD sizing calculation.
- Reduce Errors: Standard effectiveness correlations reduce the risk of manual mistakes in rating problems where outlet temperatures are unknown.
- Standardized Methodology: A consistent rating approach makes it easier to compare vendor proposals or check off-design operating points.
When to Use Effectiveness-NTU vs. LMTD Sizing
| Situation |
Recommended Method |
| You know all four temperatures and need required area |
LMTD sizing method (see our Design of Heat Exchanger Excel Sheet) |
| You know the exchanger (UA) and flow rates but not outlet temperatures |
Effectiveness-NTU rating method (this sheet) |
| You need to check an existing exchanger at a new/off-design flow rate |
Effectiveness-NTU rating method (this sheet) |
| You’re comparing a vendor-proposed exchanger’s actual predicted performance |
Effectiveness-NTU rating method (this sheet) |
Key Features
- Effectiveness correlations for counter-flow, parallel-flow, and shell-and-tube (1 shell pass) arrangements
- Automatic capacity ratio and NTU calculation
- Outlet temperature and heat duty results without iteration
- Fully editable formulas — no hidden cells
- Works offline in Microsoft Excel
Technical Specifications
| Parameter |
Details |
| File Format |
Microsoft Excel (.xlsx) |
| Method |
Effectiveness-NTU (ε-NTU) heat exchanger rating method |
| Flow Arrangements Covered |
Counter-flow, parallel-flow, shell-and-tube (1 shell pass) |
| Key Outputs |
Effectiveness, NTU, capacity ratio, heat duty, outlet temperatures |
| Editable |
Yes — all formulas open for review |
| Internet Required |
No — works fully offline |
Typical Applications
- Rating existing heat exchangers at new operating conditions
- Checking vendor-proposed exchanger performance predictions
- Off-design and part-load performance evaluation
- Troubleshooting underperforming heat exchangers in service
Who Should Use This Sheet
- Process engineers rating existing or proposed heat exchangers
- Plant engineers troubleshooting exchanger performance
- EPC engineers evaluating vendor thermal design submittals
- Engineering students learning effectiveness-NTU methodology
What You’ll Receive
- Editable Excel sheet with effectiveness-NTU rating calculations
- Correlations for multiple common flow arrangements
- Lifetime access with a single, one-time purchase
Compatibility
- Microsoft Excel 2010 or later (Windows or Mac)
- No macros or add-ins required
- Works fully offline once downloaded
How to Use This Sheet
- Enter mass flow rates and specific heats for both fluid streams.
- Enter the exchanger’s UA value (or estimate area × U from known data).
- Select the flow arrangement (counter-flow, parallel-flow, or shell-and-tube).
- Review the calculated capacity ratio, NTU, and effectiveness.
- Read off the predicted heat duty and outlet temperatures.
For sizing an exchanger from known temperatures, see our Design of Heat Exchanger Excel Sheet and Heat Exchanger Sizing Excel Sheet (LMTD Correction & U-Value). For type-specific design, see our Shell and Tube Heat Exchanger Excel Sheet. Explore the Engineering Design & Calculation Master Excel Bundle, or browse the complete product catalog.
Frequently Asked Questions
What’s the difference between this sheet and a standard LMTD sizing sheet?
LMTD sizing calculates required area when all four temperatures are known. This sheet solves the opposite (rating) problem: given a known or assumed UA, it predicts outlet temperatures and heat duty using the effectiveness-NTU method.
What is NTU?
NTU (Number of Transfer Units) is a dimensionless measure of an exchanger’s heat transfer capability relative to the minimum fluid heat capacity rate: NTU = UA / Cmin. Higher NTU generally means better performance for a given capacity ratio.
Can I use this to check a vendor’s proposed exchanger performance?
Yes. Many engineers use the effectiveness-NTU method to independently verify a vendor’s predicted outlet temperatures and duty for a proposed exchanger design.
Does this cover shell-and-tube arrangements specifically?
Yes, the sheet includes the effectiveness correlation for a standard 1-shell-pass, 2-tube-pass shell-and-tube arrangement, in addition to counter-flow and parallel-flow.
Do I need to know the exchanger’s UA value to use this sheet?
Yes, you need UA (overall heat transfer coefficient × area) either from exchanger specification data or a preliminary estimate to run the rating calculation.
Need to know how your heat exchanger will actually perform? Get the Heat Exchanger Effectiveness-NTU Excel Sheet today and rate outlet temperatures and duty without trial-and-error iteration.
