Spreadsheets
Two-Way Slab Punching Shear Design Excel Workbook – ACI 318M-25 Metric
19 $
What's Included
SI metric (mm, kN, MPa) two-way flat slab punching shear Excel workbook prepared to ACI 318M-25. Checks interior, edge, and corner columns, slab opening deductions on critical perimeter bo, biaxial unbalanced moment transfer (gamma_v), size-effect factor lambda_s, and closed shear stirrup spacing and extension.
⚡
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 SI Metric Excel workbook verifies two-way reinforced concrete flat slabs and mat foundations against punching shear under concentric axial shear and biaxial unbalanced moments in accordance with ACI 318M-25. It covers interior, edge, and corner column locations, perimeter reductions for adjacent slab openings, size-effect modification (λs), and closed stirrup shear reinforcement detailing.
Standard: ACI 318M-25 (SI Metric)
Units: SI Metric (mm, kN, MPa)
File: 19-Slab Punching Shear Design Based on ACI 318M-25.xlsx
Units: SI Metric (mm, kN, MPa)
File: 19-Slab Punching Shear Design Based on ACI 318M-25.xlsx
Design Checks & Calculation Scope
Critical Perimeter bo & Openings
Calculates effective critical shear perimeter bo at d/2 from interior (4-sided), edge (3-sided), and corner (2-sided) columns, deducting ineffective segments projected by slab openings (Sec. 22.6.4).
Biaxial Unbalanced Moment Transfer
Determines eccentric shear transfer fractions γv1, γv2 and polar section moduli Jc/c around both principal slab axes to evaluate peak factored shear stress vu (Sec. 8.4.4.2.3).
Size-Effect Factor λs (Table 22.6.5.2)
Applies ACI 318M-25 size-effect factor λs = min(1.0, √(2 / (1 + 0.004 d))) directly to concrete punching capacity φvc (φ = 0.75) as well as to stirrup shear calculations and outer perimeter extension distance.
Closed Stirrups & Extension Distance (Sec. 22.6.6)
Checks maximum stirrup stress limit vs,max = 0.50 √(f’c) − vc, required stirrup leg spacing (s ≤ d/2), and distance from the column face where concrete alone resists punching stress.
Technical Summary
| Governing Standard | ACI 318M-25 (Metric Ch. 8, Table 21.2.1(b), Sec. 22.6) |
| Unit System | SI Metric (mm, kN, kN-m, N/mm2 / MPa) |
| Worksheet Tabs | Punching in Slab (Calcs & Diagrams), Rebar Data, Revision, Design Basis |
| Key Inputs | Column dimensions C1/C2, slab effective depth d, location (Interior/Edge/Corner), opening dimensions, Vu, Mux, Muy, f’c, fyv, stirrup bar size & leg count |
| Key Outputs | bo, Jc/c, γv1/γv2, peak shear stress vu, φvc with λs, required stirrup spacing s & zone extension |
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:
19-Slab Punching Shear Design Based on ACI 318M-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
VERIFIED DIGITAL FILE
Instant access
Pile Capacity Analysis Excel Spreadsheet
Complete pile foundation design workbook: vertical end bearing and skin friction, lateral capacity, settlement and group…
Spreadsheets
VERIFIED DIGITAL FILE
Instant access
Bitcoin On-Chain Data Google Sheet with Telegram Alerts
Google Sheet that pulls hourly Bitcoin on-chain data with automatic updates and Telegram alerts, so you…
Spreadsheets
-20% OFF
VERIFIED DIGITAL FILE
Instant access
19 ACI 318 Structural Design Excel Templates
19 ready-to-use structural design templates covering foundations, concrete, steel and wood per ACI 318, AISC, IBC,…