Heat Transfer. Heat Loss From A Pipe in An Indoor Location
Heat Transfer. Heat Loss From A Pipe in An Indoor Location
Heat Transfer. Heat Loss From A Pipe in An Indoor Location
Carlos J. Cruz
cjcruz[at]piping-tools.net
Rev. cjc. 09.06.2016
Source:
Saturated steam or Saturated water
If the fluid is "saturated steam" or "saturated water", there is no need to input any value in the cells of "pUnsatGauge" and "tUnsat"
corresponding to the case of "superheated steam or subcooled water". Any value in those cells will not be considered.
Superheated steam or subcooled water
If the fluid is "superheated steam or subcooled water", there is no need to input any value in the cell of "psatgauge" corresponding to
the case of "saturated steam" or "saturated water". Any value in this cell will not be considered.
To run only the array function:
1. Select the range k18:k27
2. Place the cursor at the end of the function's definition
3. Instead of pressing the Enter-key, press the keys: Ctrl + Shift + Enter
#VALUE! W/(m²*K) (Forced convection inside a pipe with Water/steam, turbulent flow)
#VALUE! W/(m²*K) (Combined natural and forced exterior convection coefficient for a horizontal tube)
#VALUE! W/(m²*K) (Combined radiation convection coefficient )
#VALUE! W/(m*K) (Average pipe temperature)
#VALUE! W/(m*K) (Average insulation temperature)
#VALUE! ºC (Temperature of pipe interior surface )
#VALUE! ºC (Temperature of interface steel pipe - insulation)
#VALUE! ºC (Temperature of insulation exterior surface)
#VALUE! W/(m²*K) (Global heat transfer coefficient refered to the exterior surface)
#VALUE! W (Heat loss for the pipe of length "L")
s_mm, Emiss, Fluid, m_KgMin, pSatGauge_bar, pUnsatGauge_bar, tUnsat, tAmb, fi_%, v_mps, Hasl_m)
Insulation materials
Elastomeric Tube and Sheet. C534, Grade I__-73.33 °C to 23.89 °C
Elastomeric Tube and Sheet-High Temp. C534, Grade II__-73.33 °C to 93.33 °C
Elastomeric Tube and Sheet-Halogen Free. C534, Gr. II=__-73.33 °C to 93.33 °C
Cellular Glass Block. C552, Grade 6, Type I__-73.33 ºC to 204.44 ºC
Cellular Glass Pipe. C552, Grade 6, Type =I__-73.33 ºC to 204.44 ºC
Polystyrene Board. C578, Type I – XII__data available only at at 24 ºC
Polystyrene Pipe. C578, XII__73.9 ªC to 23.89 ºC
Polyisocyanurate. C591, XII__-73.9 ªC to 93.33 ºC
Phenolic Foam Unfaced. C1126, Type III__-73.9 ªC to 93.33 ºC
Melamine Foam. C1410,__23.89 ªC to 93.33 ºC
Polyolefin Sheet and tube. C1427,__-73.33 ªC to 23.89 ºC
Polyimide Foam. C1482, Type I__-73.33 ªC to 204.44 ºC
Polyimide Foam. C1482, Type VI__-73.33 ªC to 204.44 ºC
Polyimide Rigid Cel. C1594, Type II, Gr. III, Cl. 1__-73.33 ªC to 204.44 ºC
Mineral Fiber Pipe, C547, Type I__23.9 ºC to 315.6 ºC
Mineral Fiber Pipe, C547, Type II-III&V__23.9 ºC to 315.6 ºC
Mineral Fiber Pipe, C547, Type IV__23.9 ºC to 315.6 ºC
Mineral Fiber Pipe, C553, Type I & II__23.9 ºC to 93.3 ºC
Mineral Fiber Pipe, C553, Type IV__23.9 ºC to 204.4 ºC
Mineral Fiber Pipe, C553, Type V & VI__23.9 ºC to 315.6 ºC
Mineral Fiber Pipe, C553, Type VII__23.9 ºC to 315.6 ºC
Mineral Fiber Metal Mesh Blanket, C592, Cl.1 & 2__23.9 ºC to 315.6 ºC
Mineral Fiber Board, C612, Type 1A-III__23.9 ºC to 315.6 ºC
Mineral Fiber Board, C612, Type IV A&B__23.9 ºC to 315.6 ºC
Mineral Fiber Board, C612, Type VI__93.3 ºC to 315.6 ºC
Calcium Silicate Pipe and Block. C533, Type I__93.3 ªC to 315.6 ºC
Expanded Perlite Pipe and Block. C610,__93.3 ªC to 315.6 ºC
Micro-porous Thermal Ins.C1676, Type II, Gr.II, Hydro.__93.3 ªC to 315.6 ºC
Flexibel Aerogel Low Temp. C1728, Type I, Grade 1B__-73.3 ªC to 93.3 ºC
Flexibel Aerogel High Temp. C1728, Type III, Grade 1A__23.9 ªC to 315.6 ºC
Flexibel Aerogel Pipe. C1728, Type III, Grade 2__23.9 ªC to 315.6 ºC
Heat transfer. Heat loss from a pipe in an indoor location
www.piping-tools.net
cjcruz[at]piping-tools.net
Heat loss rate of a pipe in an outdoor location
General comment.
This routine is defined to work for carbon steel pipe dimensions and with This routine is not fully automated.
water / steam as interior fluid. The ambient air and surrounding surfaces are macro DQ that iterates the outer s
at the same temperature. The pipe is in a horizontal position. the insulation "t3", which has been
Furthermore, the average tempera
Input data of the pipe must be initially assum
Pipe nominal diameter dn = 8 in This routine is also presented in a fully
Pipe schedule Sch = 80 - written in VBA (see sheet "Indoor pip
Pipe length L= 22 m
Pipe absolute rugosity Rabs = 0.1 mm
Insulation material Ins : Calcium Silicate Pipe and Block. C533, Type I__93.3 ªC to 315.6 ºC
Insulation thickness sins = 50 mm
Emissivity of exerior sheet e= 0.8 Note 1. Average temperature of the
This temperature has to be initially
Interior fluid Fluid : Subcooled water the calculated value.
Interior mass flowrate m= 400 kg/min Note 2. Average temperature of the
For saturat. steam or water psat = 25 bar (g) This temperature has to be initially
For superheated steam or p= 20 bar (g) the calculated value.
subcooled water t= 225 ºC Note 3. Exterior insulation tempera
This temperature has to be initially
Ambient air temperature te = 2 °C temperature "t3" is available, the a
by the new value (when using a m
Ambient air velocity v= 2 m/s This process must be repeated un
Local height H= 0 m.a.s.l. calculated values have a difference
The iteration can be done by activa
Initially assumed temperatures: uses Solver and replaces the assu
Pipe average temperature tave_pipe = 224.66 °C (Note 1) calculated value.
Insulation ave tave_ins = 120.98 °C (Note 2) Due to the way the function Goal s
Exterior insulation temp. t3 = 17.36 °C (Note 3) initial t3-value. (The solution is sen
For example, set t3 = 20 ºC
Thermal conductivities
Interior temperature
ti = IF(F19="Superheated steam",L60,IF(AND(F19="Saturated steam"),L53,IF(AND(F19="Saturated water"),L53,L60)))
ti = 225.00 °C
Note 4 he = Combined_Convection_Coefficient_horizontal_tube_dextmm_Vkmh_tsurf_tamb
(Eq. 1)
U3 = 1 / ( (1/hi)*(r3…
hi = #VALUE! W/(m²*K)
r3 = #VALUE! m
r1 = #VALUE! m
kpipe = 46.5 W/(m*K)
r2 = #VALUE! m
kins = #VALUE! W/(m*K)
he = #VALUE! W/(m²*K)
hrad = 4.11 W/(m²*K)
U3 = #VALUE! W/(m²*K)
ti =
t1 = #VALUE!
t2 =
Local ambient pressure at local height H Combined natural and forced exterior
patm =101,325* (1 -2.25577E-5 * H)^5,25588 convection coefficient for a horizontal tube
H= 0 m.a.s.l. (a VBA function used).
patm = 101,325 Pa
patm = 1.01325 bar de = #VALUE! mm
v= 7.200 km/h
Fluid pressure ts = t3 = 17.363 °C
tamb = 2 °C
Case of saturated fluids he = #VALUE! W/(m²*K)
p= pgauge_sat + patm
pgauge_sat = 25 bar (g)
patm = 1.01 bar
psat = 26.01 bar
tsat = #VALUE! °C
tsat = H2O_SaturationTemp_p VBA function for the combined natural and forced pipe exterior coefficient
tsat = #VALUE! ªC he = Combined_Convection_Coefficient_horizontal_tube_dextmm_Vkmh_tsurf
e= 0.8 - dn = 8 dn
F= 1 - Sch = 80 -
s= 5.67E-08 W/(m²*K4) RabsMM = 0.1 mm
t3K = 290.51 K PbarGauge = 25 bar (g)
teK = 275 K Hasl = 0 m.a.s.l.
hrad = 4.108061198 mKgMin = 400 kg/min
hi = #VALUE! W/(m²*K)
Combined radiation convection coefficient Saturated steam Module: hi_Sat_Unsat_Water_St
hrc = he + hrad Forced_convection_SatSteam_inside_pipe_dn_Sch_RabsMM_pSatBarGauge_Hasl_mKgMin(dn, Sch, RabsMM, PbarGauge, Hasl, mKgMin)
he = #VALUE! W/(m²*K) dn = 8 dn
hrad = 4.11 Sch = 80 -
hrc = #VALUE! W/(m²*K) RabsMM = 0.1 mm
PbarGauge = 25 bar (g)
Hasl = 0 m.a.s.l.
mKgMin = 400 kg/min
hi = #VALUE! W/(m²*K)
Superheated steam or Subcooled water Module: hi_Sat_Unsat_Water_St
Forced_convection_NotSatWaterOrSteam_inside_pipe_dn_Sch_RabsMM_temp_pBarGauge_Hasl_mKgMin
dn = 8 dn
Sch = 80 -
RabsMM = 0.1 mm
PbarGauge = 20 bar (g)
t= 225.0 °C
Hasl = 0 m.a.s.l.
mKgMin = 400 kg/min
hi = #VALUE! W/(m²*K)
Exterior convection heat flow The calculated heat flow acc. (Eq.1) is
Qc = he * A3 * (t3-te) Qext = #VALUE! W
he = #VALUE! W/(m²*K)
A3 = #VALUE! m² The calculated heat flow based on
t3 = #VALUE! ºC the calculated insulation outside
te = 2 °C temperature is
Qc = #VALUE! W Qi-e = #VALUE! W
te= 2 °C
ti = 225 °C
°C
#VALUE! °C t3 = #VALUE! °C
Insulation materials
Elastomeric Tube and Sheet. C534, Grade I__-73.33 °C to 23.89 °C
Elastomeric Tube and Sheet-High Temp. C534, Grade II__-73.33 °C to 93.33 °C
Elastomeric Tube and Sheet-Halogen Free. C534, Gr. II=__-73.33 °C to 93.33 °C
Cellular Glass Block. C552, Grade 6, Type I__-73.33 ºC to 204.44 ºC
Cellular Glass Pipe. C552, Grade 6, Type =I__-73.33 ºC to 204.44 ºC
Polystyrene Board. C578, Type I – XII__data available only at at 24 ºC
Polystyrene Pipe. C578, XII__73.9 ªC to 23.89 ºC
Polyisocyanurate. C591, XII__-73.9 ªC to 93.33 ºC
Phenolic Foam Unfaced. C1126, Type III__-73.9 ªC to 93.33 ºC
Melamine Foam. C1410,__23.89 ªC to 93.33 ºC
Polyolefin Sheet and tube. C1427,__-73.33 ªC to 23.89 ºC
Polyimide Foam. C1482, Type I__-73.33 ªC to 204.44 ºC
Polyimide Foam. C1482, Type VI__-73.33 ªC to 204.44 ºC
Polyimide Rigid Cel. C1594, Type II, Gr. III, Cl. 1__-73.33 ªC to 204.44 ºC
Mineral Fiber Pipe, C547, Type I__23.9 ºC to 315.6 ºC
Mineral Fiber Pipe, C547, Type II-III&V__23.9 ºC to 315.6 ºC
Mineral Fiber Pipe, C547, Type IV__23.9 ºC to 315.6 ºC
Mineral Fiber Pipe, C553, Type I & II__23.9 ºC to 93.3 ºC
Mineral Fiber Pipe, C553, Type IV__23.9 ºC to 204.4 ºC
Mineral Fiber Pipe, C553, Type V & VI__23.9 ºC to 315.6 ºC
Mineral Fiber Pipe, C553, Type VII__23.9 ºC to 315.6 ºC
Mineral Fiber Metal Mesh Blanket, C592, Cl.1 & 2__23.9 ºC to 315.6 ºC
Mineral Fiber Board, C612, Type 1A-III__23.9 ºC to 315.6 ºC
Mineral Fiber Board, C612, Type IV A&B__23.9 ºC to 315.6 ºC
Mineral Fiber Board, C612, Type VI__93.3 ºC to 315.6 ºC
Calcium Silicate Pipe and Block. C533, Type I__93.3 ªC to 315.6 ºC
Expanded Perlite Pipe and Block. C610,__93.3 ªC to 315.6 ºC
Micro-porous Thermal Ins.C1676, Type II, Gr.II, Hydro.__93.3 ªC to 315.6 ºC
Flexibel Aerogel Low Temp. C1728, Type I, Grade 1B__-73.3 ªC to 93.3 ºC
Flexibel Aerogel High Temp. C1728, Type III, Grade 1A__23.9 ªC to 315.6 ºC
Flexibel Aerogel Pipe. C1728, Type III, Grade 2__23.9 ªC to 315.6 ºC
Rev. cjc. 09.06.2016
Page 1 of 7
Result
Q= #VALUE! W
Q= #VALUE! kW
Constants
s= 5.67E-08 W/(m²*K4)
Kelv = 273.15 K
Page 2 of 7
e exterior coefficient
zontal_tube_dextmm_Vkmh_tsurf_tamb
Page 3 of 7
Module: hi_Sat_Unsat_Water_Steam
Module: hi_Sat_Unsat_Water_Steam
MM, PbarGauge, Hasl, mKgMin)
Module: hi_Sat_Unsat_Water_Steam
Page 4 of 7
1
)+
h e+ hrad
Microsoft Editor de
ecuaciones 3.0
Page 5 of 7
Page 6 of 7
Page 7 of 7
References
www.piping-tools.net
Carlos J. Cruz
cjcruz[at]piping-tools.net
[4] http://www.tak2000.com/data/handbookx.pdf
[12] http://wwwme.nchu.edu.tw/Enter/html/lab/lab516/Heat%20Transfer/chapter_8.pdf
[17] Advanced Heat and Mass Transfer by Amir Faghri, Yuwen Zhang, and John R. Howell
5.3 Hydrodynamically and Thermally Fully Developed Laminar Flow
http://www.thermalfluidscentral.org/e-resources/download.php?id=??
5.4 Hydrodynamically fully developed and Thermally Fully Developing Laminar Flow
http://www.thermalfluidscentral.org/e-resources/download.php?id=86
[18] One Stop Shop in Structural Fire Engineering, Professor Colin Bailey, University of Manchester. All rights reserved.
http://www.mace.manchester.ac.uk/project/research/structures/strucfire/materialInFire/Steel/HotRolledCarbonSteel/thermalProperties.htm
[19] Steamdat90
Thermodynamic and transport properties of water
Lennart Delin/Johan Nygaard, ÅF-IPK AB
[20] Insulation Material Specification Chart from NIA Insulation Training Program
http://www.insulation.org/pdf/Insulation_Materials_Spec_Chart_Updated_March_2015.pdf
minar Flow