Tank and Dike Work Book Instructions and Notes 1
Purpose: This Excel Work Book was created to assist the Plant Layout Designer with a task that can be complicated, complic ated, filled with potential error and take a lot of time. The goal is to reduce costs by reducing time and improving quality.
2
Application: This Work Book can be used for single tank within a single containment area or can be used for multiple tanks within a single containment area.
Contents: There are five (5) sheets included. Sheet "1 (this sheet) is the instructions and Notes. Sheet #2 is a
3 list of some of the most c ommon API Storage Tank sizes. Space is included so the user can record other other sizes consistent with project specific requirements . Sheet #3 is the work work sheet for the Single Tank application. Sheet #4 is the work Sheet for the multiple tank application. Sheet #5 is a two page work sheet: Page 1 is for the Dike Detail and page 2 is for the Tank Pad Detail.
Tank Data: A) Collect a list of Tanks for the Project. This list must include the sizes (in Barrels), the Tank Types
4 and the Commodities. B) Determine if there is a Local or Client imposed Code that defines Grouping or
separation of Tank types or Commodities. If there are Tanks on the project lis t that are not included on Sheet #2 then add them in the "Yellow" spaces provided and in this case only hit "Save".
Civil/Structural Data: Meet with the appropriate Civil/Structural Group and have them define preliminary
5 guidelines for A) the Angle of Repose of the material to be used for the Dikes (Berms, Bungs, etc.), the
recommended maximum height of the Dikes and for B) The proposed approach to Tank Pad profiles (Height and configuration).
6
The Task: Add the Dike Height and Angle of Repose data into Page 1 of Sheet #5. Add the Tank Pad height Data to Page 2 of Sheet #5
User add data as required in yellow boxes (#1, #2 & #3) if provided data is not applicable y l n o m m o c s k n a T e g a r o t . S s n d r i o a t d l a n l a a t t S s n I i P m A r n a o F d k e n s a a T b n s i i d e r e e s h u n w o h s n o i t a m r o f n i e h T
Capacity Barrels
Gallons (US)
2,500 5,000 7,500 10,000 12,000 15,000 20,000 25,000 30,000 35,000 40,000 50,000 55,000 60,000 60,000 65,000 70,000 70,000 80,000 80,000 90,000 95,000
y t i c a p a d c e r k i n u a q t e r d s d a a r e s U
105,000 210,000 315,000 420,000 504,000 630,000 840,000 1,050,000 1,260,000 1,470,000 1,680,000 2,100,000 2,310,000 2,520,000 2,520,000 2,730,000 2,940,000 2,940,000 3,360,000 3,360,000 3,780,000 3,990,000 0 0 0 0 0 0 0
Gallons (UK)
87,431 174,861 262,292 349,723 419,668 524,584 699,446 874,307 1,049,169 1,224,030 1,398,892 1,748,615 1,923,476 2,098,338 2,098,338 2,273,199 2,448,061 2,448,061 2,797,784 2,797,784 3,147,507 3,322,368 0 0 0 0 0 0 0
Diameter Cubic Feet
Cubic Yards
14,036 28,073 42,109 56,146 67,375 84,219 112,292 140,365 168,438 196,510 224,583 280,729 308,802 336,875 336,875 364,948 393,021 393,021 449,167 449,167 505,313 533,386 0 0 0 0 0 0 0
#1
520 1,040 1,560 2,079 2,495 3,119 4,159 5,199 6,238 7,278 8,318 10,397 11,437 12,477 12,477 13,517 14,556 14,556 16,636 16,636 18,715 19,755 0 0 0 0 0 0 0
Cubic Meters
398 795 1,193 1,590 1,908 2,385 3,180 3,975 4,770 5,565 6,360 7,950 8,745 9,540 9,540 10,336 11,131 11,131 12,721 12,721 14,311 15,106 0 0 0 0 0 0 0
Feet
21.25 30.00 37.00 42.50 46.50 52.00 60.00 67.00 73.50 79.50 85.00 86.00 100.00 105.00 95.00 108.50 113.00 103.00 121.00 110.00 116.50 120.00
#2
Page 2
Height
Meters
Feet
6.477 9.144 11.278 12.954 14.173 15.850 18.288 20.422 22.403 24.232 25.908 26.213 30.480 32.004 28.956 33.071 34.442 31.394 36.881 33.528 35.509 36.576 0.000 0.000 0.000 0.000 0.000 0.000 0.000
40 40 40 40 40 40 40 40 40 40 40 40 40 40 48 40 40 48 40 48 48 48
#3
Meters
12.192 12.192 12.192 12.192 12.192 12.192 12.192 12.192 12.192 12.192 12.192 12.192 12.192 12.192 14.630 12.192 12.192 14.630 12.192 14.630 14.630 14.630 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Tank & Dike Calculation Sheet #1 The user only fills in data in the approprate "Yellow" boxes. No. 1, 2, 3, 4, 5 are optional, 6, 7, 8, 9 are required. The Answer is at #10
Single Tank in Single Dike Area
#2 Tank Number
#3 By
#4 Date
#1 Project -
A
Capacity Barrels
B
Gallons (US)
Gallons (UK) 0
#6 See Note @ #10
#7 Diameter
Cubic Feet 0
Cubic Yards 0
Volume (110%)
Cubic Meters 0
Feet
Meters
#5 Height (Information only) Feet
Meters
0
0
0
Minimum Toe of Dike to Crown of Dike if Dike area is square (North/South direction)
#DIV/0!
Feet
#DIV/0!
Meters
See Note @ #10
(Same in East/West direction)
Tank Diameter -
0
Tank Diameter -
0.0
Feet ` Meters
15 ft or 5m Min.
Go to Sheet #5 for Dike Details
#8
15 ft or 5m Min.
Effective Tank Pad Diameter 6 Feet 2.0 Meters
#9
Pad Height
Feet Meters
Dike Height 0
Feet
0
Meters
Go to Sheet #5 for Pad Details
Dike Containment Area
Tank Pad Pad Volume 0.00
Cubic Feet
0.00
Cubic Meters
Total Volume Required (*)
Minimum Dike surface area
Min. Req'd Length/Width
#10
0
#DIV/0!
#DIV/0!
Feet
0
#DIV/0!
(*) Total Volume required includes Tank contents plus Pad displacement volume.
#DIV/0! Meters Note: For Total Outside Toe to Outside Toe Dimension add dim "Y" & "Z" from Sheet #5
Tank & Dike Calculation Sheet The user only fills in data in the approprate "Yellow" boxes. No. 1, 2, 3, 4, 5 are optional, 6, 7, 8 are required. The Answer is at #9 & 10
Page 1
Multiple Tanks in Single Dike Area #2 Tank Numbers
. k T t s e g r a L
. s k T r e l l a m S
#3 By
#4 Date
#7 Diameter
#5 Height(Optional)
#1 Project -
A
Capacity
#6 Barrels B1
Gallons (US)
Gallons (UK)
0
Cubic Feet 0
0
Volume (110%)
C1 C2 C3 C4 C5
Cubic Yards
Cubic Meters 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0
Displacement Volume of Pads = Total Volume of Containment area =
0 0 0 0 #9
Cu. Ft Minimum Width must include Largest Tank Pad Dia + Maintence between the Dike & Pad
Feet
Meters
0
0
Volume Largest Tank =
Meters
0
0
Displacement Volume of Smaller Tanks =
Feet
#10
Cu. Meters
Minimum Length
Selected Width
Tank Diameter -
0
Tank Diameter -
0.0
Note: For Total Outside Toe to Outside Toe Dimension add dim "Y" & "Z" from Sheet #5
Feet
#DIV/0!
Feet
Meters
#DIV/0!
Meters
Feet Meters
` See Sht. #5 for Dike Height
Maint. Clearance
Dike Height 15 Feet
Largest Tank
0
Smaller Tank (s)
5 Meters
Pad Height Effective Tank Pad Diameter See Sheet #5
See Sheet #5
0
#8 Feet Meters
Page 1 Dike Width Calculation Detail
#1
Crown Walkway decimal of feet
Actual =
"X"
Recommended =
3 Feet Min. Recommended = 1 Meter Min. decimal of meter
Actual =
The user must fill in appropriate data on both sheets in the "Yellow" boxes at No. 1, 2 and 3
#2
This dimension "X" is determined by the "Angle of Repose" for the material used for the Dike. Concrete wall would be 1:0 ratio but desert sand might be 1:3 ratio. You must talk to Civil to get guidance.
Required Angle Ratio
1 To
"Freeboard" This is the safety space for Rain or Fire Water volume
#3 Max. Recommended Dike Height
6'-0" 2 Dike Profile
Selected
Feet
Feet
Meters
Meters
This is the minimum height required for the spilled volume of the tank.
`
Angle of Repose Ratio Example- 1:1, 1:1.5, 1:2 Dim "Y"
Minimum Toe to Toe Dike width Item
Imperial
Metric
"X" #1
0
0
"X" #2
0
0
Walkway Dim. "Z"
Total =
0
0
0
0
0
0
0
0
0
0
Dimension "X"
Dimension "Y"
Page 2 Tank Diameter
Pad Volume Calculation Detail Tank Wall
Pad Slope
Pad Apron Tank Bottom Tank Pad
Effective Pad Volume equals the Tank Diameter + the Pad Apron for both sides & one Pad Slope
Tank Diameter If Single Tank Largest If Multiple Tank
Smaller multiple Tks.
Pad
#4 Apron
#5 Slope
Diameter
Radius
Radius Sq.
Area
#6 Height
Volume (Single Tank)
B (Ft)
0.0
0.0
0.0
0.0
0.0
0.0
Cubic Feet
B (m)
0.0
0.0
0.0
0.0
0.0
0.0
Cu. Meters
B1 (Ft)
0.0
0.0
0.0
0.0
0.0
0.0
B1 (m)
0.0
0.0
0.0
0.0
0.0
0.0
C1 (Ft)
0.0
0.0
0.0
0.0
0.0
0.0
C1 (m)
0.0
0.0
0.0
0.0
0.0
0.0
C2 (Ft)
0.0
0.0
0.0
0.0
0.0
0.0
C2 (m)
0.0
0.0
0.0
0.0
0.0
0.0
C3 (Ft)
0.0
0.0
0.0
0.0
0.0
0.0
C3(m)
0.0
0.0
0.0
0.0
0.0
0.0
C4 (ft)
0.0
0.0
0.0
0.0
0.0
0.0
C4 (m)
0.0
0.0
0.0
0.0
0.0
0.0
C5 (Ft)
0.0
0.0
0.0
0.0
0.0
0.0
C5 (m)
0.0
0.0
0.0
0.0
0.0
0.0
Pad Volume for multiple Tanks
0.0 Cubic Feet 0.0 Cu. Meters
