Plate heat exchangers pack a lot of surface area into a compact frame, but sizing one correctly still comes down to standard thermal-hydraulic fundamentals: heat duty, LMTD, overall U-value, and the resulting plate count. The Plate Heat Exchanger Design Excel Sheet from GrowMechanical walks through this calculation so you can arrive at a preliminary plate exchanger size before requesting a vendor’s detailed selection.
It is built for engineers, technicians, and plant professionals sizing plate-type heat exchangers for industrial process and HVAC applications.
What This Sheet Calculates
- Heat duty from hot and cold side flow rates and temperatures
- LMTD for the plate exchanger flow arrangement
- Required heat transfer area from your target overall U-value
- Estimated number of plates based on per-plate effective area
- Preliminary pressure drop estimate
Key Features
- Easy-to-use, guided input fields for flow rate, temperatures, and fluid properties
- Calculates required heat transfer area and estimated plate count
- Supports hot and cold side flow rates and temperatures independently
- Useful for water, glycol, oil, and other common process fluids
- Suitable for single-pass or multi-pass configurations
- Helps with preliminary sizing before vendor consultation
- Fully editable formulas — no hidden cells
Why Use This Sizing Sheet
- Save Engineering Time: Get a preliminary plate exchanger size without waiting on vendor selection software for early-stage estimates.
- Reduce Errors: A structured LMTD and area calculation reduces the risk of significantly under- or over-specifying the exchanger before vendor engagement.
- Standardized Methodology: Consistent sizing basis makes it easier to compare multiple vendor proposals against your own estimate.
Technical Specifications
| Parameter |
Details |
| File Format |
Microsoft Excel (.xlsx) |
| Exchanger Type |
Gasketed plate heat exchanger, single-pass or multi-pass |
| Key Outputs |
Heat duty, LMTD, required area, estimated plate count, pressure drop |
| Compatible Fluids |
Water, glycol, oil, and other common process fluids |
| Editable |
Yes — all formulas open for review |
| Internet Required |
No — works fully offline |
Typical Applications
- Industrial process heat recovery and cooling duties
- HVAC chilled water and condenser water applications
- Oil cooling and glycol heat transfer systems
- Preliminary sizing before requesting vendor quotations
Who Should Use This Sheet
- Process and mechanical engineers evaluating plate exchanger options
- Plant technicians and maintenance engineers
- EPC engineers preparing preliminary equipment data sheets
- Engineering students learning plate exchanger sizing fundamentals
What You’ll Receive
- Editable Excel sheet with plate heat exchanger sizing calculations
- Heat duty, LMTD, area, plate count, and pressure drop outputs
- 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 hot side and cold side flow rates and inlet/outlet temperatures.
- Enter fluid properties for both sides (water, glycol, oil, or other).
- Review the calculated heat duty and LMTD.
- Enter or select a target overall U-value to calculate required area and plate count.
- Use the pressure drop estimate to sanity-check your configuration before vendor consultation.
For waterside economizer-specific sizing, see our Plate & Frame Heat Exchanger Excel Sheet. See also our Shell and Tube Heat Exchanger Excel Sheet and Design of Heat Exchanger Excel Sheet. Explore the Engineering Design & Calculation Master Excel Bundle, or browse the complete product catalog.
Frequently Asked Questions
How is this different from the Plate & Frame Heat Exchanger Excel Sheet?
Our Plate & Frame Heat Exchanger Excel Sheet is built specifically for waterside economizer (free-cooling) sizing in HVAC systems. This sheet covers general plate heat exchanger sizing across broader industrial and HVAC services.
What fluids can I use this sheet for?
The sheet supports water, glycol, oil, and other common process fluids — enter the appropriate fluid properties (density, specific heat, viscosity) for accurate results.
Does this sheet replace vendor plate exchanger selection software?
No. This sheet provides a preliminary sizing estimate for early-stage design and vendor comparison. Final plate count, gasket material, and pressure rating should be confirmed with the exchanger manufacturer’s detailed selection software.
Can this be used for multi-pass plate exchanger configurations?
Yes, the sheet is structured to support both single-pass and multi-pass configurations.
What overall U-value should I use?
U-values for plate exchangers are typically higher than shell-and-tube designs for similar services due to enhanced turbulence; use vendor-published ranges or your own project data where available, and treat sheet defaults as a starting point.
Ready to size your plate heat exchanger? Get the Plate Heat Exchanger Design Excel Sheet today and generate a reliable preliminary size before you contact a vendor.
