Spreadsheets
Special Structural Shear Wall Design Excel Workbook – ACI 318-25
19 $
What's Included
Special reinforced concrete structural shear wall Excel workbook prepared to ACI 318-25 Section 18.10 in US customary or SI metric units. Plots a multi-layer strain-compatibility P-M interaction curve, checks in-plane wall shear strength, evaluates boundary element triggers, and sizes Ash confinement hoops.
⚡
Instant Digital Access
Direct file download immediately after checkout. Access anytime under My Account.
🛡️
Verified & Standard Compliant
Spreadsheets, tools, and code templates are fully tested for technical accuracy.
💬
Dedicated Support
Direct technical assistance via Telegram @hungthinhvn or Email hangchat.xyz@gmail.com
Product Description
Product Overview
This Excel workbook performs flexural-axial, in-plane shear, and seismic boundary element design for rectangular, barbell, or flanged special structural walls to ACI 318-25 Section 18.10. It computes multi-point strain-compatibility axial-moment interaction curves alongside displacement-based and stress-based boundary zone confinement requirements.
Standard: ACI 318-25 Sec. 18.10
Units: US & SI Units
File: 07-Concrete Shear Wall Design Based on ACI 318-25.xlsx
Units: US & SI Units
File: 07-Concrete Shear Wall Design Based on ACI 318-25.xlsx
Design Checks & Calculation Scope
Strain-Compatibility φPn–φMn Diagram
Integrates concrete compression block and multi-layer vertical reinforcement strains from pure compression (0.80 φPo) to pure tension, applying ACI 318-25 Table 21.2.1 strength reduction factors (φ = 0.65 compression-controlled to 0.90 tension-controlled).
In-Plane Wall Shear (Sec. 18.10.4)
Computes nominal wall shear strength from wall aspect ratio factor αc and horizontal web steel ρt · fy, checking maximum wall shear stress (8 √(f’c) Acv / 10 √(f’c) Acv piers), two-curtain triggers, and φshear = 0.75 / 0.60.
Boundary Element Trigger (Sec. 18.10.6.2 & .3)
Evaluates both the displacement-based neutral-axis check c ≥ lw / (600 · (1.5 δu / hw)) and the compressive-stress trigger (≥ 0.20 f’c / < 0.15 f’c) to establish special vs ordinary boundary detailing.
Boundary Confinement Hoops Ash (Table 18.10.6.4(g))
Determines special boundary zone length (max(c − 0.1 lw, c/2)), transverse hoop spacing limits, and required rectilinear confinement steel Ash = max(0.09 s bc f’c / fyh, 0.30 s bc (Ag/Ach − 1) f’c / fyh) in both directions.
Technical Summary
| Governing Standard | ACI 318-25 Sec. 18.10, Ch. 11, Table 21.2.1, Ch. 22 |
| Unit System | Switchable: US Customary (kips, ft, in, ksi) or SI Metric (kN, m, mm, MPa) |
| Worksheet Tabs | SHEARWALL (Input, Interaction Plot & Summary), Sheet1 & Sheet2 (Fiber Calcs), Design Basis |
| Key Inputs | Wall length lw, thickness hw/tw, flange/boundary dimensions, f’c, fy, Pu, Mu, Vu, roof displacement δu, curtain bar sizes & boundary cage layout |
| Key Outputs | Interactive φPn–φMn curve vs (Pu, Mu), φVn vs Vu, neutral axis c, special boundary zone extent, Ash hoop area & spacing |
Worksheet Screenshots
Sample calculation output captured directly from the Excel printable sheets:
Building Code Standards & Regional Applicability
Strength reduction factors (φ), capacity equations, and reinforcement detailing limits follow ACI 318-25 / ACI 318M-25 and ASCE/SEI 7-22. Engineers working under national codes derived directly from ACI 318 can adjust concrete strength, steel yield grade, load factors, and bar sizes directly in the input cells:
| Region / Country | Applicable National Standard | Engineering Application |
|---|---|---|
| United States & Territories | IBC 2024 / ACI 318-25 / ASCE 7-22 | Matches current IBC / ACI 318-25 building code provisions in US customary units (kips, in, ksi). |
| Saudi Arabia & GCC | SBC 304 (Saudi Building Code) | SBC 304 adopts ACI 318 strength reduction factors (φ) and detailing provisions directly for EPC and commercial submittals. |
| Philippines | NSCP 2015 (ACI 318 based) | Uses equivalent strength design, shear-friction, and seismic detailing provisions; metric or customary bar inputs supported. |
| Indonesia | SNI 2847:2019 / SNI 1726:2019 | SNI 2847 adopts ACI 318 provisions with compatible flexural, shear, deep-beam, and special wall checks. |
| Colombia & Latin America | NSR-10 / NEC-15 / NTC-C | Follows the ACI 318 framework for seismic confinement, coupling beams, shear walls, and spread foundations. |
| Canada & International | CSA A23.3 / International Projects | Useful as an ACI 318-25 design check on international industrial, oil & gas, and plant foundations. |
Spreadsheet Notes & Engineer Responsibility
- Editable Open Formulas: All worksheets use native Excel formulas without VBA macros or password-locked sheets.
- Worked Example Included: Pre-populated sample inputs and pass/fail checks allow you to review the calculation flow immediately before entering project loads.
- Professional Responsibility: This spreadsheet is an engineering design aid. Input loads, geotechnical parameters, site seismic criteria, reinforcement detailing, and final code compliance remain the responsibility of the Engineer of Record.
Included File
- Workbook:
07-Concrete Shear Wall Design Based on ACI 318-25.xlsx(calculation sheet(s) + Design Basis reference tab). - Delivery: Instant download link (Google Drive) provided after checkout.
Related Products
Spreadsheets
-66% OFF
VERIFIED DIGITAL FILE
Instant access
Steel Design Collection – AISC Excel Sheets
A comprehensive pack of Excel templates for structural steel design to AISC standards, automating code checks…
Spreadsheets
-20% OFF
VERIFIED DIGITAL FILE
Instant access
M&E Engineering Spreadsheets – 53 Excel Files
53 Excel calculation tools for electrical and mechanical engineers, covering the routine M&E calculations that slow…
Spreadsheets
-70% OFF
VERIFIED DIGITAL FILE
Instant access
Excel File Sheet Solar Power System Design Calculator
Excel sheet to size solar panels, battery banks and inverters for off-grid systems from system voltage,…
Spreadsheets
-31% OFF
VERIFIED DIGITAL FILE
Instant access
Smart Google Sheet Tracking Crypto Money Flow Hourly
Google Sheet that tracks crypto money flow with hourly Bitcoin on-chain data, automated netflow calculations (inflow…