Newest Articles
ChExpress-August 19, 2010
ChExpress-August 5, 2010
ChExpress-July 22, 2010
ChExpress-July 12, 2010
ChExpress-June 24, 2010
ChExpress-June 10, 2010
ChExpress-May 27, 2010
Energy Efficient Hot and Cold Water
Electrical Process Tomography
Biodiesel: The Road Ahead
Methanol Plant Capacity Enhancement
Plate and Frame Heat Exchangers: Preliminary Design
Compressor Surging Under Control
Plant and Equipment Wellness, Part 1: Observing Variability


| More



cheplusbannerbig.gif (7470 bytes)

Steam Tracing with MS Excel

excel_icon.gif (986 bytes)Steam Tracing with MS Excel is presented as a guide to understanding how the spreadsheet "steam_tracing.xls" works to perform various calculations associated with steam tracing.  This spreadsheet by Andre de Lange from South Africa was the winner of our 2005 Spreadsheet Competition.  The spreadsheet, available in both Imperial and SI units, is available for download here.

If you're using Excel 2007, use this version of the spreadsheet.

Introduction
Heat tracing is used to prevent heat loss from process fluids being transported in process fluid pipes, when there is risk of damage to piping, or interference with operation such
as fouling or blockage, caused by the congealing, increase in viscosity, or separation of components, in the fluid below certain temperatures, or when there is risk of formation of corrosive substances or water due to condensation in corrosive services.  This prevention of heat loss is accomplished by employing electrical tracing, or steam tracing, and insulating both the process fluid pipe and the tracer together, using appropriate insulation lagging, in an attempt to minimise heat loss from the pipe and tracer to their surroundings.


The existing software that was used to design steam tracing had to be evaluated in terms of its accuracy and reliability, as problems associated with steam tracing designed with the existing software have occurred in the past.

A software simulation had to be designed that could compare theoretical inputs and outputs with that of an existing simulation used to design steam tracing, as well as compare it to existing installed steam tracing, in order to determine where improvements in the software could be made.

The new software had to use the outputs from the existing software as inputs and its outputs had to correspond to the inputs of the existing software. Other important evaluations were also included in the new software.

Theory
The term “Heat Tracing” is inclusive for two methods used in the conservation of temperature. The first method is known as electrical heat tracing, and the second is known as steam tracing.

Electrical heat tracing may be described as an insulated electrical heating cable, which is spiralled around the process fluid pipe, after which the pipe and tracing is insulated with the appropriate type and thickness of insulation lagging material.  While this method of heat tracing may be installed with

In order follow the theory of the spreadsheet, download the nomenclature sheet in Adobe Acrobat reader format.

relative ease compared to steam tracing, it is more expensive, and poses several risks.  The most important of these, being the risk of electric spark, which may cause electric shock or ignite flammable substances resulting in explosions or fire.   If electrical heat tracing is not carefully controlled, there is also the possibility that the cable could overheat and damage the pipe or insulation.  This also renders the tracing cable unusable and the cable needs to be replaced.

Steam tracing is described by attaching a smaller pipe containing saturated steam, also known as the “tracer”, parallel to the process fluid pipe. The two pipes are then also insulated together with the specified insulation and jacketed if necessary.  Steam tracing is more labor intensive to install than electrical heat tracing, but there are very few risks associated with it.  The temperature of the tracer also cannot exceed the maximum saturation temperature of the steam, as it operates at specific steam pressures.

Steam tracing may be done in one of two ways.  Bare steam tracing is the most popular choice as it is fairly easily installed and maintained and it is ideally suited to lower temperature requirements.  It is simply composed of a half inch or three quarters of an inch pipe attached to the process fluid pipe by straps and both pipes are then insulated together.   The other available option is to make use of cemented steam tracing, during which heat conductive cement is placed around the steam tracer running parallel to the process fluid pipe, (shown in figure 1b), in an attempt to increase the contact area available for heat transfer, between the tracer and the process fluid pipe.

It is necessary to foster a better understanding of the heat loss distribution through an insulated pipe containing steam tracing, before continuing the discussion. For this purpose, detailed diagrams depicting the cross-sections of the two types of tracing methods are given below, in figures 1a and b:

steam_tracer1.gif (32608 bytes)

Because the area around the process fluid pipe and tracer cannot be accurately described simply by assuming perfect cylindrical geometry, provision had to be made for a realistic impression of the true geometry. Detailed derivations of formulas are included in Appendix 1.

Heat transfer across a surface occurs according to the following equation: (Coulson & Richardson, 1999:634-688)

steam_tracing2.gif (1241 bytes) (2.1)

The following equations were derived in determining the different areas across which heat transfer occurs:

steam_tracing3.gif (1723 bytes) (2.2)

For bare tracing, the following formulas were derived:

steam_tracing4.gif (1536 bytes) (2.3)
steam_tracing5.gif (1393 bytes) (2.4)
steam_tracing6.gif (2347 bytes) (2.5)
steam_tracing7.gif (2876 bytes) (2.6)
steam_tracing8.gif (4606 bytes) (2.7)
steam_tracing9.gif (1637 bytes) (2.8)
steam_tracing10.gif (1808 bytes) (2.9)
steam_tracing11.gif (1306 bytes) (2.10)
steam_tracing12.gif (4095 bytes) (2.11)
steam_tracing13.gif (1407 bytes) (2.12)

The following equation was used to determine the hottest surface temperature for bare tracing: (Le Roux, D.F. (1997) “Thermal Insulation and Heat Tracing”, Guideline presented by D.F. le Roux, Secunda)

steam_tracing14.gif (5053 bytes) (2.13)
steam_tracing15.gif (3019 bytes) (2.14)
steam_tracing16.gif (1586 bytes) (2.15)
For cemented tracing, the following formulas were derived:
steam_tracing17.gif (2941 bytes) (2.16)
steam_tracing18.gif (1555 bytes) (2.17)
steam_tracing19.gif (3556 bytes) (2.18)
steam_tracing20.gif (1664 bytes) (2.19)
steam_tracing22.gif (2472 bytes) (2.20)
steam_tracing23.gif (4465 bytes) (2.21)
steam_tracing24.gif (1289 bytes) (2.22)
steam_tracing25.gif (3959 bytes) (2.23)
steam_tracing26.gif (1229 bytes) (2.24)
steam_tracing27.gif (1989 bytes) (2.25)
The following equation was used to determine the hottest surface temperature for cemented tracing:
steam_tracing28.gif (3462 bytes) (2.26)
where
steam_tracing29.gif (5008 bytes) (2.27)
Refer to Appendix 2 for a table of qt vs. NPS. (Table 3)

 

Experimental
The cross sections of the bare traced and cemented traced pipes are given in figures 3a and 3b, respectively.  These figures illustrate how the geometric approach was used in describing the heat loss through the system, taking into account that spherical geometry was not assumed.

steam_tracing30.gif (37522 bytes)

 

steam_tracing31.gif (37137 bytes)

The independent variables for the design were as follows, and were all specified variables in the software simulation:

  • Time, s
  • Pipe Length,                                         (0 to maximum length for steam trap), m
  • Steam Pressure,                                   (240 to 1700kPa)
  • Nominal process fluid pipe size,             (0.5 to 48 inches)
  • Amount of available tracers                    (0 to 5)
  • Nominal pipe size of tracer pipe,           (0.5 or 0.75 inches)
  • Insulation thickness,                              (0 to process fluid pipe diameter), m
  • Emissivity of insulation lagging               (0 to 1)
  • Ambient Temperature,                           (-10 to 50 șC)
  • Wind velocity,                                        (0 to 72km/h)

The dependent variables for the simulation were as follows:

  • Annulus Temperature,                           (Process fluid temperature to Steam Temperature)
  • Saturated Steam Temperature,              (126.1 to 204.3șC)
  • Steam Consumption,                             (0 to 50kg/h)
  • Process Fluid Temperature,                   (0 to 600șC)
  • Pipe Outer Radius,                                (10.668 to 609.62mm)
  • Pipe Wall Thickness,                             (1.3974 to 15.6869mm)
  • Pipe Inner Radius,                                 (6.401 to 1219.2mm)
  • Pipe Wall Thermal Conductivity,             (16 to 401W/mK)
  • Steam Tracer Outside Radius,               (6.35 to 9.53mm)
  • Maximum Tracer Length,                       (30 to 60m)
  • Thermal Conductivity of insulation          (0.01241 to 0.1120 W/mK)
  • Average Insulation Temperature,      (Ambient temp. to Steam temp.)
  • Surface Temperature,                           (N/A), K
  • Surface Film Coefficient,                        (N/A), W/m2K

The main deliverable was to obtain the minimum temperature at which the process fluid had to enter the pipeline, but other information such as the wall temperature and steam consumption were also important.

The interface designed for the simulation is shown in Fig. 3c and was written in Microsoft Excel:

steam_tracing33.gif (104045 bytes)

Fig. 3c, Interface

The detailed design and calculations can be found in Appendix 1. The design was done following an unconventional approach, in an attempt to make as few assumptions as possible.

Most of the equations were fundamentally derived, but some equations were employed from other sources. (See References)

All the necessary equations were developed and simplified to eliminate ambiguity. The equations were then solved simultaneously and by making use of iterations.

The inputs to the simulation were highlighted in yellow, on the left side of the page, and the outputs were highlighted blue, on the right hand side, to eliminate ambiguity in deciding which were inputs and which were outputs.

The inputs section mostly made use of drop-down menus to facilitate data input, and mostly made use of referencing techniques to look up the necessary values used in the calculations. For example, the user was only required to choose the NPS of the process fluid pipe, and the schedule number, and the program automatically looked up the outer diameter, inside diameter and wall thicknesses from a table containing accurate standard values for pipe sizes.

Also, the user was only required to specify the insulation material type, steam pressure, and ambient temperature, which the program used to calculate an average insulation temperature, and interpolate between different k-values, to obtain the specific thermal conductivity at that specific temperature, since thermal conductivity is temperature dependent. The program also used the lagging emissivity, together with the ambient temperature, surface temperature and wind velocity, to calculate an exact value for the surface film coefficient on the outside, which needed to be very accurate.

The program was also able to calculate a maximum surface temperature, to ensure safety protection for personnel, as the surface temperature, by standard, is not allowed to exceed 60 șC. Temperatures higher than this would result in injury caused by touching the outside surface.

The steam consumption was also calculated by determining the heat loss from the system for a certain length of pipe. The steam is invariably subject to heat loss, and thus condensation, when sufficient heat has been lost. This corresponds to the maximum length of a tracer. Fresh, saturated steam then needs to be re-introduced into the system, to ensure efficient operation, and a steam trap needs to be installed at the end of the maximum length, to collect all the condensate which has formed. The condensate may be recycled to create new steam.

The simulation made use of macros, in the sense that the program automatically performs the calculations necessary to converge the answers to a final answer, by simply requiring the user to press a shortcut key.

Results and Discussion

Due to the nature of the project, definite answers are not possible to obtain, but rather different simulations could be run and each time the answers could be evaluated. As an example, one specific run could be described in terms of its equations as follows:

Consider the Bare Tracer.

Firstly, the inputs field has to be completed (see Table 1):

Table 1: Input Fields

steam_tracing34.gif (41993 bytes)

After this has been done, the outputs section may be calculated:

Some of the outputs are values found in making use of references from other tables. These are shown first in Table 2.

Table 2: Output Fields

steam_tracing35.gif (29154 bytes)

This information can now be used together with the inputs section to calculate the remaining outputs.

Firstly, the Average Insulation Temperature is calculated from equation (2.9):

steam_tracing36.gif (1819 bytes)

it is found that   Tins=36.67 șC

It should be noted that the Process fluid Temperature is not known yet, so this is not a final answer.

Secondly, the Annulus Temperature may be calculated from eq. (2.8):

steam_tracing37.gif (1611 bytes)
Tann=76.4 șC

Since Tp is not known yet, and Tins has not yet been assigned a definite value, this value is also not fixed yet.

Now, the Average Surface Temperature needs to be calculated.  This value may be approximated by assuming that about 80% of the average surface temperature is due to the process fluid temperature and the remaining 20% is made up of the surface temperature on the tracer side.  The Average Surface Temperature may then be calculated as follows.

From Eq.(2.13) and (2.14):

steam_tracing38.gif (5068 bytes)

steam_tracing39.gif (3002 bytes) for the tracer side
and steam_tracing40.gif (2831 bytes) for the process fluid pipe side.
Therefore, steam_tracing41.gif (2033 bytes)

The surface temperature is now calculated by making use of iterations to obtain the final value of
         
         
Tsurf)Avg = 14.991 șC 

This causes the value of q to change until it stabilizes to its final answer

Technically speaking, one has to calculate the area ratios that the process fluid pipe, annulus length and tracer each contribute, calculate each area’s surface temperature, and obtain the average value for the surface temperature accordingly, but due to the limited capacity of Microsoft Excel, this method was tried and it failed, because Excel could not perform all the iterations necessary to do the calculations.  The above calculation has shown to give satisfactory results for most situations.

As a next step, the surface coefficient needs to be calculated using Eq.(2.15):

steam_tracing42.gif (1463 bytes)

The value for the surface coefficient then becomes:
h0=10.1
k1 is calculated using Eq.(2.10):

steam_tracing43.gif (1290 bytes)
but according to Eq.(2.5),
steam_tracing44.gif (2331 bytes)
and
steam_tracing45.gif (2880 bytes)

therefore, k1=18.21340591
k2 may then be calculated using Eq.(2.11):
steam_tracing46.gif (4065 bytes)

and therefore amounts to     k2= 0.489641399

Finally the Process Fluid Temperature can be calculated using Eq.(2.12):
steam_tracing47.gif (1393 bytes)

Excel is then programmed to perform iterations automatically, since a circular reference is created, but it causes all of the values to converge consequently, and the final answers are obtained, and with the final values of Tins known, the correct thermal conductivity values can be obtained and used in the equations:

kins=0.02712 W/mK
kw=53.3 W/mK

References

Le Roux, D.F. (1997) “Thermal Insulation and Heat Tracing”, Guideline presented by line manager D.F. le Roux, Secunda.

Foo, K.W. (1994) “Sizing tracers quickly (Part 1)”. Hydrocarbon Processing, p93-97. January. “Sizing tracers quickly (Part 2)”. Hydrocarbon Processing, p93-97. February.

Fisch, E. (1984) “Winterising process plants”. Chemical Engineering, p128-143, 20 August.

Kenny, T.M. (1992) ”Steam tracing: do it right”. Chemical Engineering Progress, p40-44, August.

Coulson, J.M and Richardson, J.F. (1999) Chemical Engineering, R.K. Sinnot, London.

Le Roux, D.F. (2005) Theoretical discussion and problem description, Sasol Limited, Secunda.

Van der Spuy, E. (2005) Theoretical advice, and steam traps, Spirax Sarco, Secunda.

Smit, J. (2005) Practical information, Sasol Limited, Secunda.

Technical committee of specification SP 50-4, (2004) Specification SP 50-4 Revision 2 for Steam and Hot Water Tracing, Sasol Limited, Secunda.

Other Information
Appendix 1 and Appendix 2 as referred to in the article are available in Acrobat Reader format here.

 

By: Andre de Lange, Winner of the 2005 spreadsheet competition
delange.a@gmail.com

 


ChE Plus Subscriber - Click Here for a Printable Version

Fill out your email address to
receive notification of site updates
and instantly receive five technical
questions and answers
!
Email Address:
First Name:
Last Name:

State:

Country:

Industry:

Position:

Signup Remove