ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
"WEIGHTS" --- PIPE AND TANK WEIGHT CALCULATION PROGRAM
2
3
Program Description:
4
5
"WEIGHTS" is a spreadsheet program written in MS-Excel for the purpose of calculating the weights of pipes and tanks
6
or vessels. Specifically, the weight of pipes either empty or full of contents, with/without insulation, and with/without ice
7
buildup is determined. The volume and weight of tanks or vessels of various top/bottom or end configuations is
8
determined.
9
10
This program is a workbook consisting of five (5) worksheets, described as follows:
11
12
Worksheet NameDescription
13
DocThis documentation sheet
14
Pipe WeightsCalculate weights of standard weight steel pipes
15
Pipe Rack WeightCalculate weight of rack of standard weight steel pipes
16
Vert. Tank Volume & WeightCalculate volume and weight of a vertical cylindrical tank
17
Horiz. Tank Volume & WeightCalculate volume and weight of a horizontal cylindrical tank
18
19
Program Assumptions and Limitations:
20
21
1. Worksheets for Pipe Weights and Pipe Rack Weight assume use of standard weight (STD) steel pipe for
22
diameters from 1/2" up through 36".
23
2. Worksheet for Vert. Tank Volume & Weight assumes vertical cylindrical tank, and permits use of various top and
24
bottom configuations. Tops may be either flat, spherical, or elliptical. Bottoms may be either flat, elliptical,
25
spherical, or conical.
26
3. Worksheet for Horiz. Tank Volume & Weight assumes vertical horizontal tank, and permits use of various end
27
configuations. Left and right ends may be either flat, elliptical, or spherical.
28
4. Worksheet for Vert. Tank Volume & Weight assumes wall thickness of center, cylindrical section is same as for top
29
and bottom. Where top and/or bottom thickness are not the same as center, cylindrical section, the user may
30
account for the difference by including an estimated correction weight (+/-) in the Misc. Weight input.
31
5. Worksheet for Horiz. Tank Volume & Weight assumes wall thickness of center, cylindrical section is same as for both
32
ends. Where end thicknesses are not the same as center, cylindrical section, the user may account for the
33
difference by including an estimated correction weight (+/-) in the Misc. Weight input.
34
6. This program contains several “comment boxes” which contain a wide variety of information including
35
explanations of input or output items, equations used, data tables, etc. (Note: presence of a “comment box”
36
is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the
37
desired cell to view the contents of that particular "comment box".)
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