A storage tank design calculation Excel worksheet should separate capacity, liquid pressure, shell-thickness assessment, and weight. For a vertical cylindrical tank, volume is πD²H/4. Hydrostatic pressure follows ρgh. Plate weight follows area × thickness × material density. Final thickness, however, requires the applicable tank design standard and all relevant load cases.
This guide develops a preliminary estimate for a 6 m diameter tank with a 5 m shell height. It has 141.37 m³ gross cylindrical capacity, 127.23 m³ inventory at a 4.5 m liquid level, and 113.10 m³ usable volume between 0.5 m and 4.5 m. Assumed plate thicknesses give an estimated empty mass of 9.64 tonnes including an illustrative accessories allowance.
The example is for an aboveground, vertical, flat-bottom, vented steel tank on continuous support. It is not a pressure-vessel, underground-tank, rectangular-tank, or fabrication-ready design.
Define the tank service before calculating dimensions
Record the stored liquid, density range, temperature, corrosion characteristics, required inventory, filling and withdrawal rates, operating levels, venting conditions, and site loads. A tank that is normally vented can still experience pressure or vacuum during blocked-vent or abnormal operating conditions. Those conditions need explicit review.
API Standard 650, Welded Tanks for Oil Storage, addresses a defined class of welded storage tanks. Confirm its scope, project-adopted edition, material rules, and applicable provisions before using its design methods. A spreadsheet title containing “API 650” does not establish compliance.
Other services or construction types can require different standards. Pressure storage, refrigerated service, water storage, and nonmetallic tanks should not automatically inherit the same design basis. Our pressure-vessel types and selection guide provides related background on equipment classification.
| Input group | Information to collect |
|---|---|
| Process | Required working inventory, liquid density, temperature, filling and emptying rates |
| Geometry | Inside diameter, shell height, bottom shape, roof type, operating levels |
| Mechanical | Design pressure/vacuum, material, corrosion allowance, design loads |
| Site | Wind, seismic conditions, foundation support, settlement, flooding exposure |
| Operation | Venting, overfill protection, access, cleaning, drains, inspection |
Gross, operating, and usable capacity are different
For a straight vertical cylinder with internal diameter D:
Aplan = πD²/4
Vgross,cylinder = AplanH
Vliquid = Aplanh
Vusable = Aplan(hhigh − hlow)
Here H is shell height and h is liquid depth above the flat bottom. Dimensions in metres give volume in cubic metres; multiply by 1,000 for litres. This geometry neglects internal displacement and does not add roof vapor-space volume to liquid capacity.
Low-level inventory may be unavailable because of pump suction requirements, settling, or process constraints. Space above the high operating level provides operating reserve; it is not automatically available for routine storage. Set alarm, shutdown, and overflow levels from the operating and protection philosophy rather than an arbitrary fill percentage.
If the required usable volume is known, a trial diameter follows:
D = √[4Vusable/{π(hhigh − hlow)}]
For example, 110 m³ over a 4 m working level range needs approximately 5.92 m inside diameter before choosing practical dimensions. The 6 m example therefore provides 113.10 m³ over that range.
Worked capacity and hydrostatic-pressure example
| Parameter | Illustrative value |
|---|---|
| Inside diameter | 6.0 m |
| Straight shell height | 5.0 m |
| High operating liquid level | 4.5 m |
| Low operating liquid level | 0.5 m |
| Liquid density | 1,000 kg/m³ |
| Gravity | 9.81 m/s² |
| Vapor-space pressure for this calculation | 0 Pa gauge |
Plan area = π × 6²/4 = 28.274 m²
Gross cylindrical volume = 28.274 × 5 = 141.37 m³
High-level liquid volume = 28.274 × 4.5 = 127.23 m³
Usable volume = 28.274 × (4.5 − 0.5) = 113.10 m³
The bottom liquid pressure relative to the vapor space is:
p = ρgh = 1000 × 9.81 × 4.5 = 44,145 Pa = 44.15 kPa
Pressure increases with depth. At another elevation, use the liquid depth above that point. If the vapor space has nonzero gauge pressure, add it to the hydrostatic pressure for the relevant internal-pressure assessment. A high operating level is not automatically the governing design or hydrotest level.
For a liquid of density 850 kg/m³ at the same level, bottom hydrostatic pressure falls to 37.52 kPa and inventory mass falls to 108.15 tonnes. That does not justify reducing plate thickness without evaluating all design cases, including the test liquid.
Thickness calculation: what a simple equation can establish
For an ideal thin cylindrical membrane under local internal pressure, circumferential stress is approximately:
σhoop = pD/(2t)
Rearranging gives tmembrane = pD/(2S), where S is an assumed stress for this simplified demonstration. With p = 44,145 Pa, D = 6 m, and an illustrative S = 120 MPa:
tmembrane = 44145 × 6/(2 × 120000000) = 0.001104 m = 1.10 mm
This 1.10 mm result is not a permissible tank plate thickness. It illustrates the membrane relationship only. The assumed stress is not a verified code allowable for a selected grade, and the equation is not the API 650 shell-course design method. It excludes course-specific rules, required minimum thickness, corrosion, stability, fabrication, and local loads.
A proper thickness assessment establishes, at minimum:
- The applicable shell-course method and design liquid head for each course.
- Material grade and allowable stresses at design and test conditions.
- Corrosion allowance and applicable nominal-thickness/tolerance requirements.
- Operating and hydrostatic-test load cases.
- Wind and vacuum buckling, seismic effects, and anchorage requirements.
- Nozzles, openings, roof loads, attachments, and other local or combined loads.
Bottom and roof plates require their own design checks. Do not apply a shell hoop-stress equation to a flat bottom or roof and call the result a completed design. For this article’s weight calculation, plate thicknesses are assumed inputs rather than outputs approved by the membrane estimate.
Estimate tank plate weight
Use mass = developed plate area × nominal thickness × material density. The example adopts steel density 7,850 kg/m³, uniform 8 mm shell plate, 6 mm bottom plate, and 5 mm conical roof plate. These are illustrative estimating assumptions, not thickness recommendations.
The roof rise is assumed to be 0.60 m over a 3.0 m radius. The conical slant length is:
s = √(r² + rise²) = √(3² + 0.6²) = 3.0594 m
| Component | Approximate mass formula | Result |
|---|---|---|
| Shell | πDHtsρsteel | 5,918.8 kg |
| Flat bottom | (πD²/4)tbρsteel | 1,331.7 kg |
| Conical roof plate | πrstrρsteel | 1,131.7 kg |
| Plate subtotal | Sum of the above | 8,382.2 kg |
The shell calculation uses inside diameter as a thin-wall area approximation; a detailed takeoff should use developed plate dimensions. The bottom estimate excludes projection beyond the shell, overlaps, and annular details. Roof openings, overlaps, supports, and attachments are not itemized.
For early budgeting only, adding an illustrative 15% accessories allowance gives:
Estimated empty mass = 8382.2 × 1.15 = 9639.6 kg = 9.64 tonnes
Replace the percentage with itemized masses for roof framing, nozzles, manways, platforms, stairs, stiffeners, anchors, insulation, and other installed items as design progresses. Do not add an itemized component and still count it in an unchanged allowance.
Operating, test, and shipping loads
High-level liquid mass = 127.2345 × 1000 = 127,234.5 kg
Estimated operating mass = 9639.6 + 127234.5 = 136,874.1 kg = 136.87 tonnes
Mass in kilograms is not force. Multiply by gravitational acceleration to obtain vertical weight in newtons. The operating gravity load here is approximately 1,342.7 kN before other applicable loads.
Foundation and anchorage calculations also need load combinations, overturning, uplift, shell reactions, settlement, and the actual support conditions. Dividing weight by plan area gives only a gross average pressure, not a complete foundation design.
Hydrotest mass must use the approved test level and test-fluid density. Shipping or lifting mass may differ from installed empty mass because some components are transported separately. Lifting design must also locate the center of gravity and evaluate local attachment loads.
Build the storage-tank worksheet in Excel
Enter SI units and keep geometry, preliminary stress estimates, and weight calculations clearly labeled. The following layout uses English Excel functions.
| Cell | Input | Value |
|---|---|---|
| B2 | Inside diameter, m | 6 |
| B3 | Shell height, m | 5 |
| B4 | High liquid level, m | 4.5 |
| B5 | Low liquid level, m | 0.5 |
| B6 | Liquid density, kg/m³ | 1000 |
| B7 | Steel density, kg/m³ | 7850 |
| B8 | Assumed shell thickness, mm | 8 |
| B9 | Assumed bottom thickness, mm | 6 |
| B10 | Assumed roof thickness, mm | 5 |
| B11 | Roof rise, m | 0.6 |
| B12 | Accessories allowance fraction | 0.15 |
| B13 | Gravity, m/s² | 9.81 |
| B14 | Illustrative membrane stress only, MPa | 120 |
| Cell | Output | Formula |
|---|---|---|
| B17 | Plan area, m² | =PI()*B2^2/4 |
| B18 | Gross cylindrical volume, m³ | =B17*B3 |
| B19 | High-level volume, m³ | =B17*B4 |
| B20 | Usable volume, m³ | =B17*(B4-B5) |
| B21 | Bottom hydrostatic pressure, Pa | =B6*B13*B4 |
| B22 | Membrane estimate ONLY, mm | =B21*B2/(2*B14*1000000)*1000 |
| B23 | Shell mass, kg | =PI()*B2*B3*(B8/1000)*B7 |
| B24 | Bottom mass, kg | =B17*(B9/1000)*B7 |
| B25 | Roof slant length, m | =SQRT((B2/2)^2+B11^2) |
| B26 | Roof plate mass, kg | =PI()*(B2/2)*B25*(B10/1000)*B7 |
| B27 | Plate subtotal, kg | =SUM(B23:B24)+B26 |
| B28 | Estimated empty mass, kg | =B27*(1+B12) |
| B29 | Operating liquid mass, kg | =B19*B6 |
| B30 | Operating total mass, kg | =B28+B29 |
Require positive diameter, height, densities, thicknesses, gravity, and illustrative stress. Enforce 0 ≤ low level < high level ≤ shell height, with nonnegative roof rise and allowance. Do not connect B22 automatically to the assumed thickness inputs: it is explicitly not a code design result.
For multiple shell courses, replace the single shell mass with a sum of πDjHjtjρ for each course using consistent developed dimensions. Keep plate procurement quantities separate from net installed mass when scrap and nesting allowances are involved.
Practical checks before issuing an estimate
Verify that internal rather than external dimensions were used for capacity. Check whether liquid-level datum starts at the bottom plate or another reference. Include displaced volume if large coils, agitators, or internals affect usable inventory.
Review venting and overfill protection alongside tank sizing. Filling rate, thermal breathing, emergency scenarios, and liquid withdrawal can govern vent requirements; a selected nozzle diameter is not evidence of adequate vent capacity.
For solids-containing service, stored volume and drainability may change as solids accumulate. Our tank solids-settling guide discusses related mixing considerations. Those loads and internals should be reflected in the tank specification.
Maintain an assumptions register with material grade, density basis, levels, plate thickness source, corrosion allowance, and excluded components. A reviewer should be able to reproduce each subtotal and see which inputs still require approval.
Frequently asked questions
1. How do I calculate vertical storage-tank capacity?
For a flat-bottom cylinder, V = πD²h/4 using internal diameter and liquid height. Use shell height for gross cylindrical volume and the operating-level difference for usable volume.
2. Is gross capacity the same as working capacity?
No. Working capacity excludes inventory below the low operating level and the reserved space above the high operating level. Internals may also displace liquid.
3. Can pD/(2S) determine my tank plate thickness?
Not by itself. It is a simplified membrane estimate. Final design needs the applicable code method, minimum thicknesses, corrosion, test conditions, stability, and other loads.
4. Why can hydrotest govern the design?
The test-fluid density, fill height, and applicable stress criteria can differ from operating conditions. Check both rather than assuming that normal liquid pressure is the governing case.
5. How is tank empty weight calculated?
Sum developed plate areas multiplied by thickness and material density, then add itemized attachments and structures. A percentage allowance is only an early estimating substitute.
6. Is this worksheet suitable for a horizontal tank?
No. Partial-fill volume in a horizontal cylinder follows circular-segment geometry, and heads require separate treatment. The vertical-cylinder level relationship is not interchangeable.
7. Is a downloadable design-certified Excel file included?
No. This guide supplies formulas for a preliminary worksheet. It does not provide a certified design or a newly created downloadable workbook.
Keep capacity, thickness, and weight traceable
The example provides 113.10 m³ usable inventory and an estimated 9.64-tonne empty mass under the stated assumptions. Complete the code-based thickness and structural assessment before using those assumptions for fabrication or procurement. Explore more calculation guides at GrowMechanical.
