Evaluating Heat Exchanger Performance by Excel
Evaluating Heat Exchanger Performance by Excel
Evaluating Heat Exchanger Performance by Excel
Inputs
Cold Stream Data
Description Symbols Value Unit
Fluid Name N !!!
Shell or Tube T/S !!!
Mass Flow Rate ṁ Kg/s
Inlet Temperature 𝑇𝑖 ℃
Outlet Temperature To ℃
Equivilant Inside Diameter dt m
Outside Diameter do m
Tube length L m
Cross Sectional Area At m^2
Heat Transfer Area A m^2
Fluid Density ρ Kg/m^3
Specific Heat Cp J/Kg.℃
Dynamic Viscosity 𝜇 Kg/m.s
Thermal Conductivity k W/m.℃
Deliverables
Cold Stream Data (Tube)
Description Symbols Value Unit
Mass Velocity Gt Kg/s.m^2
Reynold Number Re !!!
Results
Cold Stream Data
Description Symbols Value Unit
Mass Velocity Gt Kg/s.m^2
Reynold Number Re !!!
Design Effectiviness 𝜀 %
Operation Effectiviness 𝜀 %
ing Shell and Tube Heat Exchanger Performance
Inputs
Hot Stream Data
Description Symbols Value Unit
Fluid Name N !!!
Shell or Tube T/S !!!
Mass Flow Rate ṁ Kg/s
𝑇𝑖 𝑇𝑖 ℃
𝑇o To ℃
Equivilant Inside Diameter De m
Outside Diameter !!! m
Shell Length !!! m
Cross Sectional Area As m^2
Heat Transfer Area !!! m^2
Fluid Density ρ Kg/m^3
Specific Heat Cp J/Kg.℃
Dynamic Viscosity 𝜇 Kg/m.s
Thermal Conductivity k W/m.℃
Deliverables
Hot Stream Data (Shell)
Description Symbols Value Unit
Mass Velocity Gs Kg/s.m^2
Reynold Number Re !!!
JH Jh ℉
Heat Transfer Cofficient ho W/℃.m^2
Heat Duty Q W
∆𝑇2 ∆𝑇2 ℃
LMTD LMTD ℃
Correction Factor F !!!
Clean Overall Heat Transfer Cofficient 𝑈c
Results
Hot Stream Data
Description Symbols Value Unit
Mass Velocity Gs Kg/s.m^2
Reynold Number Re !!!
Design Effectiviness 𝜀 %
Operation Effectiviness 𝜀 %
Evaluating and Optimizing Shell and Tube Heat Exchanger Performance
Inputs
Cold Stream Data
Description Symbols Value Unit
Fluid Name N Water !!!
Shell or Tube T/S T !!!
Number of Passes n 4 !!!
Mass Flow Rate ṁ 8 Kg/s
Inlet Temperature 𝑇𝑖 15 ℃
Outlet Temperature To 32.85714 ℃
Equivilant Inside Diameter dt m
Outside Diameter do m
Tube length L m
Cross Sectional Area At m^2
Heat Transfer Area A m^2
Fluid Density ρ Kg/m^3
Specific Heat Cp 4200 J/Kg.℃
Dynamic Viscosity 𝜇 Kg/m.s
Thermal Conductivity k W/m.℃
Overall Heat Transfer Cofficient 𝑈 250 W/℃.m^2
Deliverables
Cold Stream Data (Tube)
Description Symbols Value Unit
Mass Velocity Gt Kg/s.m^2
Reynold Number Re !!!
JH Jh !!!
Heat Transfer Cofficient hi W/℃.m^2
Heat Duty Q W
∆𝑇1 ∆𝑇1 ℃
LMTD LMTD ℃
Correction Factor F !!!
Dirt Overall Heat Transfer Cofficient 𝑈𝑓 W/℃.m^2
Rf
The Surface Area of The Heat Exchanger A
Results
Cold Stream Data
Description Symbols Value Unit
Mass Velocity Gt Kg/s.m^2
Reynold Number Re !!!
Design Effectiviness 𝜀 %
Operation Effectiviness 𝜀 %
g Shell and Tube Heat Exchanger Performance
Inputs
Hot Stream Data
Description Symbols Value Unit
Fluid Name N Oil !!! For get one of temperature use this formula
Results
Hot Stream Data
Description Symbols Value Unit
Mass Velocity Gs Kg/s.m^2
Reynold Number Re !!!
Design Effectiviness 𝜀 %
Operation Effectiviness 𝜀 %
temperature use this formula
Group 3
No Student Name
1 Mohamed Ragab Ahmed Ahmed
2 Mohamed Mohamed Abdelhafiz
3 Mohamed Ragab Gamal
4 Adel Ezz El-Deen Gaber
5 Osama Ahmed Ateya
6 Abdelraham Mohamed El-Sayed