Description
AWWA Tank Shell and Loads Calculation
Engineering Spreadsheet — Instant Download
What This Spreadsheet Does
Calculates shell course thicknesses and the full load envelope for AWWA-compliant water storage tanks — bolted (D-103) and welded (D-100) configurations. Built for water-sector design engineers, municipal infrastructure consultants, and EPC teams on potable and raw water projects.
What’s Inside the Excel File
- Inputs — tank diameter, height, liquid level, specific gravity, wind speed, seismic site class, allowable stress, joint efficiency
- Shell thickness per course for hydrostatic + design loads
- Load combinations — dead, hydrostatic, wind, seismic per AWWA
- Bolted vs welded toggle for joint efficiency selection
- Utilization ratios per course
- Drop-in summary table for design report
Who This Is For
- Water-sector design engineers
- Municipal infrastructure consultants
- EPC teams on potable and raw water projects
- Bolted tank manufacturers and detailers
Codes & Standards Referenced
- AWWA D-100 — Welded Carbon Steel Tanks for Water Storage
- AWWA D-103 — Factory-Coated Bolted Carbon Steel Tanks for Water Storage
How It Works
| 1 | Purchase — secure one-time payment |
| 2 | Download — instant Excel access |
| 3 | Enter Values — tank geometry, materials, site loads |
| 4 | Get Results — shell thicknesses + load envelope |
File Format & Compatibility
Microsoft Excel (.xlsx). Opens in Excel 2016+, Excel 365, Google Sheets. No macros, no locked cells.
What You Get After Payment
- ✅ Instant download (also emailed)
- ✅ Lifetime access
- ✅ Engineer email support
- ✅ 7-day refund if file fails to open
🌍 Trusted by engineers across 50+ countries · 📚 Part of 160+ engineering spreadsheets · 🛠 Support from qualified engineers
Frequently Asked Questions
Welded or bolted tanks?
Both — toggle between D-100 (welded) and D-103 (bolted) joint efficiencies.
Does it cover net section tension at bolted joints?
That check is in our dedicated AWWA D-103 net section tension sheet.
Custom version needed?
Request a custom quote.
Reviews
There are no reviews yet.