Methodology for calculating heat losses in steam transmission networks using Microsoft Excel

Authors

DOI:

https://doi.org/10.61117/ipsumtec.v8i3.391

Keywords:

Thermal insulation, Energy losses, steam transportation network, Heat transfer

Abstract

Steam transportation systems typically include large steam lines with a large variety and number of transition elements such as valves, flanges, orifice plates, etc., installed along with them. When evaluating the efficiency of the transportation process through a steam pipeline and determining the main causes that impact energy loss, it has been found that the procedure for quantifying energy losses in steam pipeline networks relies on simplifications that arise from the complexity of the conditions under which they operate. This paper presents a calculation procedure to determine heat losses in the pipes of a steam transportation network, which is based on geometric information of the line and the state of its thermal insulation, as well as the conditions under which the network operates. The results obtained were compared to calculations of surface temperature and heat loss in a steam pipeline with different insulation conditions. The proposed methodology has the advantage of being simple and easy to implement on a personal computer with Microsoft Excel without requiring a high investment, unlike commercial software that has a high cost and requires computer equipment with more specific features.

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

Author Biographies

Rosember Ovando Castelar , National Technological Institute of Mexico

Rosember Ovando Castelar. Electromechanical Engineer from TecNM/Zacatepec Institute of Technology (1990) and Master of Science in Mechanical Engineering from TecNM/CENIDET (1996). In 1993, he joined the Nuclear Energy Management Department of the National Institute of Electricity and Clean Energy (INEEL) as a researcher, where he worked for 24 years. His research focuses on modelling heat transfer and fluid transport processes in pipe networks, as well as modelling severe and operational accidents in nuclear power plants. He is currently a full-time professor in the Metal-Mechanics Department at TecNM/Sede Instituto Tecnológico de Zacatepec.

Jazmin Jiménez Manzanares, National Technological Institute of Mexico

Jazmín Jiménez Manzanares. Electromechanical Engineer from TecNM/Zacatepec Institute of Technology (2022). Her line of work is the study of heat transfer, as well as the optimisation of electromechanical and automotive systems. She has applied her technical knowledge to innovate industrial solutions and currently shares her passion for engineering at multiple educational levels, where she imparts in-depth and comprehensive knowledge that fosters growth for social well-being with empathy and warmth.

Minerva Guadalupe Vargas Vega , National Technological Institute of Mexico

Minerva Guadalupe Vargas Vega. Graduate of TecNM/Tijuana Institute of Technology in Electromechanical Engineering with doctoral studies in Engineering at DEPFI-UNAM. She has worked on applied engineering projects in rainwater harvesting systems and research in fluid dynamics using modified gravity conditions.

Omar Christian Benitez Centeno , National Technological Institute of Mexico

Omar Christian Benítez Centeno. Doctor of Science specialising in Thermal Systems from TecNM/CENIDET, specialist at the Mexican Petroleum Institute and the Electrical Research Institute (now INEEL), professor since 2009 in the Department of Metalworking at TecNM/Zacatepec Institute of Technology and occasional professor at the Monterrey Institute of Technology and Higher Education (Cuernavaca campus). His line of research is multiphase flow modelling, solar energy, heat transfer and fluid mechanics.

Roberto Martin Urzúa Rangel , National Technological Institute of Mexico

Roberto Martín Urzua Rangel. Industrial Mechanical Engineer specialising in Thermal Engineering from TecNM/Aguascalientes Institute of Technology and Master's Degree in Mechanical Engineering with a specialisation in design from TecNM/CENIDET. His area of professional development is the automotive industry, where he worked at the Volkswagen plant in Puebla, DINA buses in Hidalgo, and the Ford plant in Cuautitlán Izcalli.

References

Schroeder, F.S. Calculating heat loss or gain by an insulated pipe. Chemical Engineering, January 25, 1982, pp. 111- 114.

Marconcini, R. y Neri, G., Numerical simulation of a steam pipeline network, Geothermics, Vol. 7, 1979, pp. 17-27. DOI: https://doi.org/10.1016/0375-6505(78)90023-8

Peña, J. M., Energy losses in horizontal steam lines. GRC Transactions, Vol. 10, 1986, pp. 347-252.

Peña, J M. y Campbell H., Evaluación de las pérdidas de calor en líneas de vapor geotérmico, Memorias, 3er Congreso latinoamericano de Transferencia de Calor y Materia, Guanajuato, Gto., 4-7 Julio, 1988, pp. 53-64.

Rohsenow, W. M. H.Y. Choi., Heat, Mass and Momentum Transfer,1961, 391.

Gnielinsky, New equations for heat and mass transfer in turbulent pipe and channel flow, Int. Chem. Eng., Vol. 16, No. 2, 1976, pp. 359-368.

Chen N. H., An explicit equation for friction factor in pipes. Industrial and Engineering Chemistry Fundamentals 18, 1979, 296–297. DOI: https://doi.org/10.1021/i160071a019

P. Abraham, E. M. Sparrow, W. J. Minkowycz, Internal-flow Nusselt numbers for the low-Reynolds number end of the laminar-to-turbulent transition regime, Int. J. Heat Mass Tran., 54, 2011, 584–588. DOI: https://doi.org/10.1016/j.ijheatmasstransfer.2010.09.012

Churchill, S. W. y Bernstein, M. A., Correlating Equation for Forced Convection from Gases and Liquids to a Circular Cylinder in Cross Flow. J. Heat Transfer, 99, 1977, pp. 300-306. DOI: https://doi.org/10.1115/1.3450685

Churchill, S. W., & Chu, H. H., Correlating equations for laminar and turbulent free convection from a horizontal cylinder. International journal of heat and mass transfer, 18(9), 1975,1049-1053. DOI: https://doi.org/10.1016/0017-9310(75)90222-7

Incropera, F. P., Dewitt, D. P., Bergman, T. L., & Lavine, A. S., Fundamentals of heat and mass transfer. 2007. Hoboken, NJ: John Wiley; 1985.

Ozisik, M. N., Heat transfer: a basic approach. McGraw-Hill; 1985

Holman, J. P., Heat Transfer, 10th edition. Mc-Graw Hill Higher education;2010.

Chapra, S. C., Canale, R. P., Ruiz, R. S. G., Mercado, V. H. I., Díaz, E. M., & Benites, G. E., Métodos numéricos para ingenieros (Vol. 5, pp. 154-196). New York, NY, USA: McGraw-Hill; 2010.

Kreith, F., & Bohn, M. S., Principles of heat transfer, St. Paul: West Publishing Company;1993.

Wagner, W., & Kretzschmar, H. J., IAPWS industrial formulation 1997 for the thermodynamic properties of water and steam. International steam tables: properties of water and steam based on the industrial formulation IAPWS-IF97, 2008,7-15. DOI: https://doi.org/10.1007/978-3-540-74234-0_3

C. Cruickshank, E. Ordoñez y G. Castillo (1990), Modelo matemático de la red de vaporductos de la planta geotermoeléctrica de Cerro Prieto, UNAM, Informe del proyecto 9361.

Published

2025-10-10

Crossmark

Crossmark Policy Page

How to Cite

Ovando Castelar , R., Jiménez Manzanares, J., Vargas Vega , M. G., Benitez Centeno , O. C., & Urzúa Rangel , R. M. (2025). Methodology for calculating heat losses in steam transmission networks using Microsoft Excel. REVISTA IPSUMTEC, 8(3), 123–130. https://doi.org/10.61117/ipsumtec.v8i3.391

Issue

Section

Artículos