Evaluating Heat Exchanger Performance by Excel

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

Evaluating and Optimizing Shell and Tube Heat Exchanger Performance

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 !!!

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

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

Shell or Tube T/S S !!!


Number of Passes n 1 !!!
Mass Flow Rate ṁ 4 Kg/s
𝑇𝑖 𝑇𝑖 90 ℃
𝑇o To 30 ℃
Equivilant Hydraulic Diameter Dh 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 2500 J/Kg.℃
Dynamic Viscosity 𝜇 Kg/m.s
Thermal Conductivity k W/m.℃
Overall Heat Transfer Cofficient 𝑈 250 W/℃.m^2
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 𝜀 %
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

Introduced to: Dr. Ahmed Safwat & Eng. Mostafa Abdelftah

Evaluating and Optimizing Shell and Tube Heat Exchanger Performance


Inputs
Cold Stream Data Hot Stream Data
Description Symbols Value Unit Description Symbols Value Unit
Fluid Name N Water !!! Fluid Name N Oil !!!
Shell or Tube T T !!! Shell or Tube S S !!!
Mass Flow Rate ṁ 37.7993642 Kg/s Mass Flow Rate ṁ 8.8198516 Kg/s
Inlet Temperature 𝑇𝑖 32 ℃ Inlet Temperature 𝑇𝑖 150.81111 ℃
Outlet Temperature To 39.73142764 ℃ Outlet Temperature To 76.66667 ℃
Equivilant Inside Diameter (Hydraulic) dt 0.01484376 m Equivilant Inside Diameter (Hydraulic) De 0.009144 m
Outside Diameter do 0.01905 m Inside Shell Diameter Ds 0.3088778 m
Tube length L 12.393168 m Shell Length !!! !!! !!!
Cross Sectional Area At 0.023504469 m^2 Cross Sectional Area As 0.0154219 m^2
Heat Transfer Area A 78.59864189 m^2 Heat Transfer Area A 100.87096 m^2
Fluid Density ρ 994.10584 Kg/m^3 Fluid Density ρ 956.14208 Kg/m^3
Specific Heat Cp 4178.424592 J/Kg.℃ Specific Heat Cp 1867.312 J/Kg.℃
Dynamic Viscosity 𝜇 0.000708945 Kg/m.s Dynamic Viscosity 𝜇 0.011 Kg/m.s
Number of Buffels NB 35 Buffel Buffle Space B 0.3556 m
Thermal Conductivity k 0.627 W/m.℃ Thermal Conductivity k 0.108 W/m.℃
Number of Tube Passes n 1 Pass Thermal Conductivity of Tube Material K 389 W/m.℃
Deliverables
Cold Stream Data (Tube) Hot Stream Data (Shell)
Description Symbols Value Unit Description Symbols Value Unit
Mass Velocity Gt 1608.177755 Kg/s.m^2 Mass Velocity Gs 571.90416 Kg/s.m^2
Reynold Number Re 33671.74132 !!! Reynold Number Re 475.40782 !!!
Flow Type (Laminar or Turblent) L/T T !!! Flow Type (Laminar or Turblent) L/T L !!!
Bulk Temperature TB 36.1406 ℃ Bulk Temperature TB 117 ℃
Wall Temperature Tw 38.414 ℃ Wall Temperature Tw 131.715 ℃
Dynamic Viscosity of Fluid Base on The Wall Temperature
𝜇w 0.000676049 Kg/m.sDynamic Viscosity of Fluid Base on The Wall Temperature
𝜇w 0.0080423 Kg/m.s
Prandtl Number Pr 4.72451711 !!! JH Jh 11.593883 !!!
Heat Transfer Cofficient hi 6834.246172 W/℃.m^2 Heat Transfer Cofficient ho 822.78646 W/℃.m^2
Heat Duty Q 1221115.544 W Heat Duty Q 1221115.5 W
Tube Pitch (Tringular) Pt 0.022161657 m Inside Shell Diameter (Traingular) Ds 0.3088778 m
Heat Capacity Rate Cc 157941.7929 W/℃ Heat Capacity Rate Ch 16469.415 W/℃
Pressure Loss r) ∆Pr 0 Pa Friction factor 𝑓 0.5514562 !!!
Pressure Loss (t) ∆Pt 25237.00987 Pa
Fricition Factor 𝑓 0.005848207 !!!
Results
Description Symbols Value Unit Description Symbols Value Unit
∆𝑇1 ∆𝑇1 44.66667 ℃ ∆𝑇2 ∆𝑇2 111.07968 ℃
Outlet Temperature To 39.73142764 ℃ LMTD LMTD 72.898907 ℃
Correction Factor F 0.99 !!! The Smallest of Heat Capacity Rate Cmin 16469.415 W/℃
Clean Overall Heat Transfer Cofficient 𝑈c 709.584266 W/℃.m^2 Dirt Overall Heat Transfer Cofficient 𝑈𝑓 167.73913 W/℃.m^2
The Maximum Possible Heat Transfer Rate Qmax 1956749.453 W Efficivness 𝜀 62.405309 %
Pressure Drop on The Tube Side ∆P 25237.00987 Pa Pressure Drop on The Tube Side ∆P 3.66 Psi
Pressure Drop on The Shell Side ∆Ps 109778.2324 Pa Pressure Drop on The Shell Side ∆Ps 16 Psi
Operation Fouling Resistant Rf 0.004552362 ℃.m^2/W Operation Fouling Resistant Rf 0.026 h.℉.ft^2/Btu
Reference Values
Description Symbols Value Unit Description Symbols Value Unit
Operation fouling resistant Rf 0.028 h.℉.ft^2/Btu Effectiveness 𝜀 57.47 %
Pressure Drop on The Tube Side ∆P 3.65 Psi Pressure Drop on The Shell Side ∆Ps 21.384 Psi
sdf
fsd ds ds ds sd ds
d s sd f sd sd
d d sd df d ds
d ds ds dsf d sd
d dd ds s d sd

You might also like