Description
Awwa D103 Design Calculation is an easy-to-use engineering calculation spreadsheet for excel design calculation work, built to save time and ensure accuracy for engineers and designers.
Why Use This Awwa D103 Design Calculation Spreadsheet
This Awwa D103 Design Calculation tool provides a reliable, ready-to-use excel calculation sheet so you can quickly verify results without building formulas from scratch. Engineers rely on this Awwa D103 Design Calculation resource for fast, dependable calculations on real projects.
This Awwa D103 Bolted Steel Tank Design Calculation spreadsheet from 3D-LABS follows AISC standards and gives instant, checkable results for practising engineers — no manual derivation required.
What is the AWWA D103 Bolted Steel Tank Design Calculation?
The AWWA D103 design calculation is a structural-engineering spreadsheet that sizes and verifies factory-coated bolted steel tanks — typically glass-fused-to-steel (GLS) tanks used for municipal water, fire-protection, and industrial process water storage — in accordance with AWWA Standard D103, Factory-Coated Bolted Carbon Steel Tanks for Water Storage. It automates the iterative panel-thickness, bolt-pattern, and seismic-anchor design loop, replacing four to six hours of manual calculation per tank with a single dimensioned design output suitable for internal review, vendor RFQ preparation, or AHJ submittal.
What standard does it follow?
The methodology aligns with AWWA D103 (current edition), with steel design per AISC 360 provisions and seismic design per ASCE 7.
What you input
Tank diameter (m), liquid height (m), specific gravity of the stored liquid, design wind speed (m/s), seismic site class and Ss / S1 spectral accelerations, allowable steel stress (MPa), and bolt size and grade.
What you get
Panel thickness ring-by-ring (mm), required bolt count and pattern per ring, anchor-bolt size and embedment depth, freeboard requirement, overturning-moment check, and a full bill of materials.
Who this is for
Civil and structural engineers designing potable-water, fire-protection, or process-water storage tanks; municipal-utility consultants; tank fabricators verifying designs to AWWA standards; and EPC contractors preparing tank datasheets.
Frequently Asked Questions
Does this calculation cover both new design and retrofit of existing bolted tanks?
Yes — both. For new design, the spreadsheet iterates to required panel thickness from a target tank capacity. For retrofit, panel thicknesses can be locked and the sheet returns the maximum allowable liquid height for the existing configuration.
Which edition of AWWA D103 does the spreadsheet reference?
The current edition. Reference equations and allowable stress factors are labelled on the input sheet for traceability and easy updating to future revisions.
Is seismic design included, or only static loading?
Seismic design is fully included per ASCE 7, with selectable site class (A through F) and user-input Ss / S1 spectral accelerations. The sheet computes base shear, overturning moment, and anchor-bolt design forces.
Does it work for stainless steel tanks, or only carbon steel?
The calculation is set up for factory-coated carbon steel per AWWA D103. Stainless steel tanks fall under AWWA D100 (welded) or alternative bolted-tank standards and require a separate calculation.
What is the output format — is it suitable for AHJ review?
The output is a one-page summary sheet with all design checks, plus a detail tab showing ring-by-ring calculations. Both are formatted for direct inclusion in design submittal packages.
Many engineers and students search for this resource as a Awwa D103 Design Calculation Excel Template, Awwa D103 Design Calculation Calculator, Awwa D103 Design Calculation Design Spreadsheet, or Awwa D103 Design Calculation Engineering Formula, and this download meets all of those needs.
What AWWA D103 Bolted Steel Tank Design Calculation calculates
AWWA D103 Bolted Steel Tank Design Calculation is an Excel-native engineering calculation tool built by 3D-LABS for structural, civil, and construction engineers designing buildings, foundations, pipe racks, silos, and infrastructure. It is used for sizing structural members, checking connections, designing foundations, and verifying seismic and wind load response. Every input is labelled and every output is traceable — the sheet is designed to be checkable, not a black box.
Codes and standards followed
AWWA D103 Bolted Steel Tank Design Calculation follows AWWA D103. Each formula in the spreadsheet is cross-referenced to the specific code clause it implements — you can trace any calculation back to the underlying standard, which is essential for design review and regulatory sign-off.
If your project requires a different code base (e.g. converting an IS-code sheet to an ASME basis), we can produce a code-variant edition on request. Contact info@3d-labs.com for a variant quote.
What is included in your download
- The Excel calculation file (.xlsx) — fully unlocked formulas, cell-level comments, and a clear input/output layout.
- A sample worked example — realistic inputs plus expected outputs so you can validate the spreadsheet against a known case.
- User notes (PDF) — assumptions, code clauses referenced, and edge-case guidance.
- Revision history — every update to the spreadsheet is logged so you know what changed and when.
- Email support — reply within 24 hours (Monday to Saturday, IST) for questions about the spreadsheet or its use.
Software requirements
AWWA D103 Bolted Steel Tank Design Calculation runs in Microsoft Excel 2016 or later on Windows and Mac. It is also compatible with LibreOffice Calc and can be imported into Google Sheets (some formatting may shift). No macros are required and no external add-ins are needed — every calculation runs in cell formulas, which means every step is auditable.
Pricing and delivery
AWWA D103 Bolted Steel Tank Design Calculation is priced at ₹26,000 (approximate USD equivalent shown in the cart). Delivery is instant — after payment you get a download link immediately and a receipt by email. One-time purchase, lifetime access, no subscriptions or hidden fees.
Payment methods: Cashfree (Indian customers) or PayPal International (customers outside India). Volume discounts are available on bundles of 5 or more spreadsheets from the same discipline — contact sales@3d-labs.com for a bundle quote.
Related tools and services
Engineers who work with AWWA D103 Bolted Steel Tank Design Calculation often also need:
- Other Structural & Civil Engineering spreadsheets from our catalogue of 117 tools in this discipline.
- Our Structural Design Services — for projects where the calculation is only part of a larger scope and you want the full engineering deliverable produced by 3D-LABS.
- Our online training courses — instructor-led programmes on Structural & Civil Engineering topics, including software mastery and code walkthroughs.
- Our engineering e-book library — 115+ technical PDF references covering theory, practice, and code interpretation.
Frequently asked questions
What software do I need to run AWWA D103 Bolted Steel Tank Design Calculation?
The spreadsheet is delivered as a native Excel (.xlsx) file. It runs in Microsoft Excel 2016 or later on Windows and Mac. It also runs in LibreOffice Calc and Google Sheets (with import), though some formatting may shift. No macros are required — all logic runs in cell formulas so you can audit every step.
Which codes and standards does this spreadsheet follow?
AWWA D103 Bolted Steel Tank Design Calculation follows AWWA D103. Every formula is cross-referenced to the code clause it implements, so your reviewer can trace the calculation back to the standard. If your project needs a different code, contact us — many spreadsheets are available in code-variant editions.
Are the formulas locked or editable?
All formulas are unlocked and editable. You can adapt inputs, add your own load combinations, integrate the sheet into your own workflow, and audit the logic. We do not password-protect our worksheets — an engineer should always be able to verify what the tool is doing.
What is included in the download?
The download includes: (1) the Excel calculation file with all formulas, (2) a sample worked example showing typical inputs and expected outputs, (3) a short user notes PDF explaining assumptions and code clauses used, and (4) a revision history so you can see how the sheet has been updated over time.
Do you offer support if I have questions?
Yes. Email support with any 3D-LABS spreadsheet purchase — reply within 24 hours (Mon-Sat, IST). We also offer paid tuning if you need the spreadsheet adapted to a specific project (typically USD 50-200 depending on scope). Contact info@3d-labs.com for details.
About 3D-LABS engineering spreadsheets
AWWA D103 Bolted Steel Tank Design Calculation is one of 621 engineering calculation spreadsheets in the 3D-LABS catalogue — the largest curated collection of code-compliant Excel calculators for practising engineers anywhere. Each sheet is built and reviewed by 3D-LABS engineers who use them daily on real client projects across pressure vessel design, storage tank design, piping stress analysis, structural engineering, heat exchanger design, and FEA services since 2003.
Browse the full SpreadSheet Calculations catalogue or the Structural & Civil Engineering calculations sub-category. Volume discounts apply on 5+ spreadsheets from the same discipline.
