This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.


"UGTANK.xls" workbook is for the analysis and design of anchorage for underground storage tanks, obviously addressing the concerns of buoyancy. I've had this workbook in a partially finished state for quite a while, and I just recently decided to complete it. This is not a subject that we encounter on a regular basis, but if and when you need it, hopefully it will prove to be helpful.

Program Assumptions and Limitations:
1. This program is in part based on the following two (2) dated, but still useful references:
a. Lockwood Greene Engineering Special Design Instruction No. 38, "An Approach to the Design of Anchorages for Underground Storage Tanks", dated December 6, 1972.
b. Lockwood Greene Engineering Special Design Instruction No. 31, "Design of Anchorage for Underground Storage Tanks", dated January 14, 1972.
2. This program utilizes the procedures and guidelines per the ACI 318-99 Building Code in the design of the reinforcing for the concrete spread foundation.
3. This program refers to the AISC 9th Edition (ASD) Manual, 1989. The values for safe working loads for turnbuckles are taken from the table on page 4-149 of the Manual.
4. The soil is assumed to have no voids and is assumed saturated with water (water level to top of grade), while the tank is assumed to be empty. These conservative assumptions result in largest possible buoyant force.
5. This program permits the user to utilize either steel tension straps or threaded rods with turnbuckles to secure the tank to the foundation. Note: if turnbuckles are used, then they will control the required threaded rod size.
6. This program assumes that the empty tank weight is subtracted from the buoyant force in determining the tension force in either the straps or anchor rods.
7. The program assumes that the distance between the ends of a strap or rod is equal to OD + 6".
8. The program assumes that the tank is centered on the spread foundation.
9. For the design of the foundation reinforcing in the short direction, this program assumes a uniformly loaded simple span beam strip with cantilevers (overhangs) at each end. The ends of the anchor serve as the supports. The assumed uniform loading on this "beam strip" is determined as 2 times the anchor tension divided by the foundation width.
10. This program does not address the anchorage of the straps or rods to the concrete foundation. That must be separately by the user.
11. Underground tank should be bedded on 12" of compacted sand rather than bearing directly on the concrete spread foundation. This will protect the integrity of the tank and minimize possible failure of the tank joints.
12. Provide turnbuckles in the tank anchor straps. This allows for final adjustment. Where flat straps are used, this will necessitate welding a round bar extension to accommodate the turnbuckle.
13. This program contains “comment boxes” which contain information including explanations of input items, etc. (Note: presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell.

Calculation Reference
Tank Design
| Find on | Find on | Find on | Find on | Find on |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
11 Mar 2008
Submitted By:
File Date:
11 Mar 2008
File Version:
File Size:
109.00 Kb
File Type:
stars/5.gifTotal Votes:6
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#4 Heinzig 2019-02-25 18:02
Alex; thanks! Nice analysis! Nice presentation!
#3 Mnidrbird 2014-05-19 05:33
What is the typical value used with the input parameter Soil Dry Unit Weight (Cell D20)in the UGTank program for an application where typical soil material is sand (e.g. Florida, U.S.)?

Can you provide an example of the formula you provide in the drop down explanation for Cell D20?
#2 hades3 2013-12-01 12:19
#1 monk.dong 2008-08-06 15:43

Please sign in or register to add a comment.

We have 2 guests and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics