Steam Tracing Excel 2007
Steam Tracing Excel 2007
Steam Tracing Excel 2007
SI Unit Version
Author: J.A.B. de Lange
In conjunction with www.cheresources.com
Press "Ctrl L" to activate the macro that runs the simulation.
! It is very important to read the messages at the bottom of the screen each time the simulation has been run,
Inputs
Line Number 1
Pipe Length (m) 100
Steam Specification
Steam Pressure (kPa) 800
Insulation Specifications
Insulation Material Fiberglass
Insulation Thickness (mm) 100
Emissivity of insulation lagging 0.4
Ambient Conditions
Ambient Temperature (C) -10
Wind Velocity (km/h) 10.8
Messages
Solution converged to a satisfactory degree
Hottest Surface Temperature Acceptable for Personnel Protection, insulation thickness ok
Insulation thickness acceptable, but refer to the second message for further information
Steam pressure acceptable
Process Fluid Temperature acceptable, and above Minimum Allowable Fluid Temperature
cess Fluid Temperature
Assumptions:
Saturated Steam is used, pressure drop along length of pipe neglegible
Resistance to heat transfer through tracer pipe wall material is neglegible
screen each time the simulation has been run, before evaluating the outputs.
Ouputs
Other Information
Annulus Temperature (C) 81.3
Steam Information
Steam Temperature (C) 170.4
Steam Consumption (kg/h) 9.0
Insulation Information
Thermal Conductivity, k(ins), (W/mK) 0.03226
Temperature Range (C) 10 to 250C
Average Insulation Temperature (C) 26
! It is very important to read the messages at the bottom of the screen each time the simulation has been run,
Inputs
Line Number 2
Pipe Length (ft) 130
Steam Specification
Steam Pressure (psi) 100
Insulation Specifications
Insulation Material Rock Wool 40 kg/m
Insulation Thickness (inches) 3
Emissivity of insulation lagging 0.4
Ambient Conditions
Ambient Temperature (F) 66
Wind Velocity (ft/s) 9
Messages
Solution converged to a satisfactory degree
Hottest Surface Temperature Acceptable for Personnel Protection, insulation thickness ok
Insulation thickness acceptable, but refer to the second message for further information
Steam pressure acceptable
Process Fluid Temperature acceptable, and above Minimum Allowable Fluid Temperature
cess Fluid Temperature
Assumptions:
Saturated Steam is used, pressure drop along length of pipe neglegible
Resistance to heat transfer through tracer pipe wall material is neglegible
screen each time the simulation has been run, before evaluating the outputs.
Ouputs
Other Information
Annulus Temperature (F) 207.1
Steam Information
Steam Temperature (F) 327.8
Steam Consumption (lbm/h) 5.2
Insulation Information
Thermal Conductivity, k(ins), (BTU/fthF) 0.02856
Temperature Range (F) -45 to 390F
Average Insulation Temperature (F) 127
1 Install Solver
2 Make sure the macro function can use Solver
If at any time Solver reports an error message after a macro has been run, simply uninstall the Solver Add-In from the Add
Ins menu (found under Tools), and reinstall Solver as described under "Install Solver".
If the above has no effect on the outcome of the error message, try guessing another value for the insulation thickness. So
sometimes converges to different values depending on the initial starting value.
ll the Solver Add-In from the Add-
Pipes Bare
Reference 1 19 Cemented
Reference 2 8
Reference
1
Ambient Temperature
Wind speed (m/s) (km/h) q -10
0 0 0 18.2733746272 -9
1 3.6 0.05 30.8649554979 -8
2 7.2 0.1 -7
3 10.8 0.15 -6
4 14.4 0.2 -5
5 18 0.25 -4
6 21.6 0.3 -3
7 25.2 0.35 -2
8 28.8 0.4 -1
9 32.4 0.45 0
10 36 0.5 1
11 39.6 0.55 2
12 43.2 0.6 3
13 46.8 0.65 4
14 50.4 0.7 5
15 54 0.75 6
16 57.6 0.8 7
17 61.2 0.85 8
18 64.8 0.9 9
19 68.4 0.95 10
20 72 1 11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Imperial Units
Available steam
Latent Heat (BTU/lbm)
902.7293984442
Pipes Bare
Reference 1 11 Cemented
Reference 2 8
Reference
6
Ambient Temperature
Wind speed (ft/s) q (BTU/hft2) -4
0 0 9.6355334535 -3
3 0.05 16.8984283408 -2
6 0.1 -1
9 0.15 0
12 0.2 1
15 0.25 2
18 0.3 3
21 0.35 4
24 0.4 5
27 0.45 6
30 0.5 7
33 0.55 8
36 0.6 9
39 0.65 10
42 0.7 11
45 0.75 12
48 0.8 13
51 0.85 14
54 0.9 15
57 0.95 16
60 1 17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
Amount of Tracers
1 Tracer OD OD (Inches) OD (mm)
2 " 0.672 17.0688
3 " 0.84 21.336
4 " 1.05 26.67
5 1" 1.315 33.401
Reference 2
Stainless Steel
Carbon Steel
Reference
1
Other Information
Annulus Temperature (C) 81.3
Steam Information
Steam Temperature (C) 170.4148376
Steam Consumption (kg/h) 9.04
Spacers Required
Insulation Information
Thermal Conductivity, k(ins), (W/mK) 0.03226
Temperature Range (C) 10 to 250C
Average Insulation Temperature (C) 25.97
Ouputs: Cemented
Other Information
Annulus Temperature (C) 111.6
Steam Information
Steam Temperature (C) 170.4148376
Steam Consumption (kg/h) 17.66
Spacers Required
Insulation Information
Thermal Conductivity, k(ins), (W/mK) 0.03226
Temperature Range (C) 10 to 250C
Average Insulation Temperature (C) 54.49
Reference
2
Steam Information
Steam Temperature (F) 327.82
Steam Consumption (lbm/h) 5.23
No Spacers Required
Insulation Information
Thermal Conductivity, k(ins), (BTU/fthF) 0.02856
Temperature Range (F) -45 to 390F
Average Insulation Temperature (F) 127.00
Ouputs: Cemented
Other Information
Annulus Temperature (F) 267.5
Steam Information
Steam Temperature (F) 327.82
Steam Consumption (lbm/h) 11.64
No Spacers Required
Insulation Information
Thermal Conductivity, k(ins), (BTU/fthF) 0.02856
Temperature Range (F) -45 to 390F
Average Insulation Temperature (F) 184.40
k1 43.4087852033
k2 0.7534952968
Please refer to Sheet "SI Version" or "Imperial Unit Version" again to continue.
Please refer to Sheet "SI Version" or "Imperial Unit Version" again to continue.
Do not change anything in this sheet, as it will cause the simulation to run incorrectly
c1 46.4841486483
c2 0.7555231307
c3 0.7254155893
NPS qt (W/mK)
" 34.4 60.2879608
" 34.4 60.2879608
1" 34.3 60.1127051
1" 34.3 60.1127051
2" 32.6 57.1333582
2" 31 54.329267
3" 29.1 50.9994087
3" 27.8 48.7210846
4" 26.9 47.1437833
6" 23.8 41.7108566
8" 21.5 37.6799755
10" 18.4 32.2470488
12" 14.6 25.5873322
14" 12.2 21.3811954
16" 9.8 17.1750586
18" 9.8 17.1750586
20" 9.8 17.1750586
24" 9.7 16.9998029
30" 9.7 16.9998029
36" 9.7 16.9998029
42" 9.6 16.8245472
48" 9.6 16.8245472
16.9998029
mm inch
Insthick 100.00 3.937007874
Cement
0.168
0.21
0.168
k1 26.2153837816
k2 0.2611514629
ctrl + r
acos((r1-r2)/(r1+r2)) 0.6049908005 Starting Values Diff
Tsurf pipe bare F 71.4699759029 71.4688436782 1.28193E-006
Tsurf pipe cement F 74.7397061083 74.7386835565 1.04561E-006
Process fluid temp Bare 166.3838289684 0.000000124
Process fluid temp Cement 290.3203644149 6.63474E-008
Solution converged to a satisfactory degree
2.51789E-006
Solution converged to a satisfactory degree
Please refer to Sheet "SI Version" or "Imperial Unit Version" again to continue.
c1 -106.2858584818
c2 0.0293689102
c3 3.01
NPS qt (BTU/fthF)
" 34.4
" 34.4
1" 34.3
1" 34.3
2" 32.6
2" 31
3" 29.1
3" 27.8
4" 26.9
6" 23.8
8" 21.5
10" 18.4
12" 14.6
14" 12.2
16" 9.8
18" 9.8
20" 9.8
24" 9.7
30" 9.7
36" 9.7
42" 9.6
48" 9.6
21.5
mm inch
Insthick 100.00 3.937007874
0.6049908005
1.5084626746
498.15 523.15 573.15 598.15 623.15 648.15 673.15
0.068 0.075
0.103970625 0.1120475
0.071 0.0742363 0.08 0.083 0.086 0.09 0.0928
0.0269025 0.02665 0.02592 0.025443 0.02489 0.024263 0.02356
- - - - - - -
0.097 0.118
0.069 0.072
0.069 0.0738
Bare
Cem
Ref P T H Ref P T H
116 799.82 443.556 2082.4 100 100 327.82 902.729
117 806.715 443.911 2081.4 101 101 328.54 902.245
PIPE INTERNAL DIA
SCH 40S STD SCH 60 SCH 80 SCH 80S XS SCH 100 SCH 120 SCH 140
40S 60 80 80S 100 120 140
15.799 15.799 - 13.868 13.868 13.868 - - -
20.93 20.93 - 18.847 18.847 18.847 - - -
26.645 26.645 - 24.308 24.308 24.308 - - -
40.894 40.894 - 38.1 38.1 38.1 - - -
52.501 52.501 - 49.251 49.251 49.251 - - -
62.713 62.713 - 59.005 59.004 59.005 - - -
77.927 77.927 - 73.66 73.66 73.66 - - -
90.12 90.12 - 85.446 85.446 85.446 - - -
102.26 102.26 - 97.18 97.18 97.18 - 92.05 -
154.056 154.056 - 146.334 146.33 146.334 - 139.73 -
202.722 202.722 198.456 193.68 193.68 193.68 188.904 182.554 177.83
254.508 254.508 247.65 242.874 247.5 247.65 236.524 230.174 222.25
304.8 304.8 295.3 288.9 298.5 298.45 280.974 273.05 266.7
- 336.55 325.424 317.5 - 330.2 307.95 300.024 292.1
- 387.35 373.076 363.524 - 381 354.026 344.474 333.35
- 438.15 419.1 409.55 - 431.8 398.476 387.35 377.85
- 488.95 466.75 455.626 - 482.6 442.926 431.8 419.1
- 590.55 560.374 547.674 - 584.2 531.826 517.55 504.85
- 742.95 - - - 736.6 - - -
- 1047.75 - - - 1041.4 - - -
- 1200.15 - - - 1193.8 - - -
SCH XXS
160
4.775 7.468
5.563 7.823
6.35 9.093
7.137 10.16
8.738 11.074
9.525 14.021
11.125 15.24
- -
13.487 17.12
18.263 21.946
23.012 22.225
28.575 25.4
33.325 25.4
35.712 -
40.488 -
45.237 -
53.975 -
59.538 -
- -
- -
- -
- -
SCH XXS
160
1.3974 1.3974
1.461 1.461
1.5413 1.5413
1.7185 1.7185
1.8625 1.8625
2.014 2.014
2.2034 2.2034
- -
2.5063 2.5063
3.1502 3.1502
3.7562 3.7562
4.4 4.4
5.0054 5.0054
5.3847 -
5.9907 -
6.5967 -
7.207 -
8.4153 -
- -
- -
- -
- -