ACI 318-19-Based Excel Calculator for Two-Way Shear Screening, Critical Perimeter Geometry, Drop Panel Sizing & Preliminary Stud-Rail Layouts.

Evaluate reinforced concrete slab-column connections with a professional 24-sheet Excel engineering toolkit. Explore punching shear demand, ACI 318-19-based concrete strength calculations, interior/edge/corner perimeter geometry, 15 drop-panel alternatives, slab thickness comparisons, and preliminary shear stud layouts.

Includes an editable Excel workbook, an engineering reference PDF, and a README guide.

Preliminary engineering screening and study tool only. Not a fully verified structural design system or construction approval.

CONCRETE SLAB PUNCHING SHEAR VERIFICATION & DROP PANEL SIZING SHEET

ACI 318-19-Based Excel Engineering Calculator | 24 Interconnected Worksheets

Analyze Critical Sections. Compare Slab Thicknesses. Explore Drop Panel Alternatives.

Punching shear is a critical consideration in reinforced concrete flat slabs and flat plates. High column reactions, limited slab effective depth, free edges, openings, and unbalanced moments can introduce complex slab-column connection design requirements.

This professional Excel toolkit provides a structured environment for preliminary two-way shear screening, critical-perimeter geometry exploration, concrete strength calculations, and alternative slab configuration comparisons.

Developed for structural engineers, reinforced concrete designers, consultants, and engineering students, the workbook combines interconnected formulas, editable engineering inputs, dynamic geometry, calculation traces, and applicability warnings.

WHAT'S INCLUDED

1. Dynamic Excel Engineering Calculator (.XLSX)

A professionally formatted 24-worksheet workbook featuring:

• ACI 318-19-based concrete punching shear strength expressions.

• Interior, edge, and corner column critical-perimeter geometry.

• Reinforcement-based effective depth calculations.

• Factored column shear and unbalanced moment input fields.

• Direct two-way shear stress calculations.

• Concrete strength and direct-shear utilization screening.

• 15 preliminary drop-panel sizing alternatives.

• 15 slab-thickness comparison scenarios.

• Preliminary headed shear stud-rail coordinate layouts.

• Dynamic slab-column plan visualization.

• Engineering calculation traceability.

• Input validation, QA warnings, and calculation reporting.

2. Engineering Reference Guide (.PDF)

An accompanying technical reference covering the calculation basis, engineering methodology, worked arithmetic example, workbook workflow, and important design limitations.

3. README & User Instructions (.MD)

Installation-free setup guidance, worksheet descriptions, calculation assumptions, supported functions, compatibility requirements, engineering limitations, and license terms.

ENGINEERING WORKFLOW

Step 1 — Define the connection

Enter slab thickness, column dimensions, column location, reinforcement geometry, concrete properties, and project details.

Step 2 — Enter structural actions

Provide factored column shear and transferred moments from an appropriate structural analysis.

Step 3 — Review critical-section geometry

Inspect the calculated interior, edge, or corner perimeter geometry, adopted effective depth, and connection classification.

Step 4 — Evaluate preliminary punching shear

Review the direct shear demand, applicable concrete strength expressions, and direct-shear demand-to-capacity ratio within the supported calculation scope.

Step 5 — Explore alternative configurations

Compare 15 drop-panel configurations and 15 uniform slab-thickness candidates to study how changes in dimensions influence preliminary shear calculations.

Step 6 — Develop preliminary stud layouts

Generate coordinate-based stud-rail arrangements for engineering planning. Final stud strength, spacing, anchorage, and outer-perimeter verification must be performed independently.

Step 7 — Review QA and documentation

Inspect calculation traces, applicability warnings, source references, and the printable engineering calculation report.

KEY PRODUCT FEATURES

24 Interconnected Excel Worksheets

Organized engineering inputs, linked calculations, geometry registers, scenario matrices, dashboards, and documentation.

ACI 318-19-Based Strength Expressions

Concrete-only two-way shear expressions based on ACI 318-19(22), with user-editable material and geometric inputs.

Critical Perimeter Geometry

Formula-driven geometric calculations for rectangular interior, edge, and corner slab-column arrangements.

Drop Panel Comparison Matrix

Study 15 preliminary combinations of local slab thickening and panel dimensions, including inner and outer geometric screening.

Slab Thickness Optimization Support

Compare 15 slab-thickness scenarios to investigate preliminary direct-shear behavior and identify candidates for further structural design.

Preliminary Stud-Rail Layout Builder

Generate formula-linked stud coordinates and inspect preliminary reinforcement arrangements. This is a geometric planning feature, not a completed shear reinforcement strength design.

Dynamic Slab Plan Visualization

Review an automatically updated schematic reflecting relevant slab and column geometry.

Engineering Transparency

Review individual inputs, formulas, intermediate calculations, assumptions, source references, and calculation limitations.

WHO IS THIS FOR?

• Structural engineers and reinforced concrete designers.

• Civil and structural engineering consultants.

• Flat slab and flat plate designers.

• Engineering students and graduate engineers.

• Structural design offices and engineering checking teams.

• Engineering educators studying slab-column punching shear behavior.

TECHNICAL SPECIFICATIONS

Primary Format: Microsoft Excel (.XLSX)

Worksheets: 24

Design Basis: ACI 318-19, reapproved 2022

Unit System: SI — mm, MPa, kN, kN·m

Column Geometry: Rectangular and square columns

Drop Panel Alternatives: 15

Slab Thickness Alternatives: 15

Stud-Rail Builder: Preliminary coordinate layout only

Additional Files: PDF Engineering Guide + Markdown README

Delivery: Instant digital download

Edition: First Edition, 2026

IMPORTANT ENGINEERING LIMITATIONS

This workbook is a restricted preliminary calculation and educational tool.

Its most developed strength calculation is concrete-only concentric punching shear screening for interior rectangular columns without openings or stud reinforcement.

Although edge/corner perimeter geometry, transferred moment inputs, drop-panel alternatives, and stud coordinates are included, complete engineering verification of eccentric moment transfer, edge/corner connection strength, openings, drop-panel code qualification, headed stud strength, anchorage, and outer stud critical sections is not implemented or independently established.

ACI 318-25 design calculations and US customary units are not implemented.

A displayed direct-shear ratio must never be interpreted as final code compliance, proof of structural adequacy, or permission to construct. An appropriately qualified structural engineer must independently verify all applicable design requirements and governing code provisions.

DIGITAL DELIVERY

Your purchase includes one downloadable ZIP archive containing the editable Excel workbook, PDF reference guide, and README instructions.

No physical item will be shipped.

LICENSE

Licensed for individual and internal professional preliminary engineering use. Resale, redistribution, or repackaging of the original files as a competing digital product is prohibited.

Publisher: Sarchawa — sarchawa.com

Owner & Writer: Mohammed A. Omer

Copyright © 2026 Mohammed A. Omer. Published by Sarchawa (sarchawa.com). All rights reserved.

Customer FAQ

Q: Is this an editable Excel calculator?

Yes. The package includes a 24-worksheet Microsoft Excel (.XLSX) file with interconnected formulas and editable engineering inputs.

Q: Which ACI edition does the calculator reference?

The workbook uses ACI 318-19, reapproved in 2022, as its primary design basis. ACI 318-25 calculations are not implemented.

Q: Does the calculator support interior, edge, and corner columns?

The workbook provides preliminary critical-perimeter geometry for rectangular interior, edge, and corner configurations. Complete design verification of edge/corner connections with eccentric shear is not included.

Q: Can I compare different slab thicknesses and drop panels?

Yes. The workbook provides 15 slab-thickness scenarios and 15 preliminary drop-panel alternatives for geometric and direct-shear screening.

Q: Does it design headed shear stud reinforcement?

It generates preliminary stud-rail coordinates and schematic layouts. Stud strength, anchorage, spacing compliance, and outer-perimeter design must be independently verified.

Q: Can I use the results for construction?

No. The workbook is for preliminary screening and engineering study. It is not a validated final structural design system. All project calculations require independent review by an appropriately qualified structural engineer.

Q: What files will I receive?

An Excel calculator, a PDF engineering reference guide, and a Markdown README, packaged in a downloadable ZIP file.

Q: Do I need specialized software?

Microsoft Excel Desktop is recommended, with automatic calculation enabled. No macros are required.

Q: Does the workbook support imperial units?

No. The current edition uses SI units only.

Keywords: concrete punching shear calculator, slab punching shear Excel, ACI 318 punching shear calculation, drop panel sizing spreadsheet, reinforced concrete slab design Excel, two way shear calculator, slab column connection calculator, ACI 318-19 Excel calculator, structural engineering spreadsheet, flat slab punching shear, punching shear critical perimeter, concrete slab thickness calculator