20-Sheet Excel Engineering Toolkit for Preliminary AISC 360-22 Shear Checks, Steel Connection Geometry, Bolt Groups, Weld Groups & Calculation Traceability.

A structured 20-sheet Excel engineering workbook for preliminary structural steel shear connection analysis. Explore single-plate shear tabs, single-angle and double-angle connections, review AISC 360-22 shear-strength equations, examine bolt and weld group mechanics, and organize calculation results with transparent formulas, QA checks, and a 15-page technical guide.

Designed for engineering study and preliminary analysis—not final connection design or construction approval.

Structural Steel Shear Connection Sizing & Check Sheet

A Preliminary Steel Connection Calculation & Engineering Review Toolkit

Structural steel shear connection analysis involves more than selecting a plate, angle, bolt arrangement, or weld size. Understanding connection geometry, load paths, material properties, applicable limit states, and the assumptions behind engineering calculations is essential.

The Structural Steel Shear Connection Sizing & Check Sheet provides a structured Excel environment for exploring common shear connection configurations, performing selected preliminary strength calculations, and documenting engineering assumptions.

Developed around selected ANSI/AISC 360-22 provisions, this toolkit combines a 20-sheet calculation workbook with a technical user guide and documented calculation limitations.

Explore Three Common Connection Families

• Single-Plate Shear Connections: Organize shear-tab geometry, plate properties, bolt layouts, weld information, and preliminary connected-element shear checks.

• Single-Angle Connections: Enter clip-angle dimensions and inspect preliminary component shear calculations and associated engineering considerations.

• Double-Angle Connections: Explore double-angle geometry and selected strength-screening calculations while identifying connection-specific checks requiring further verification.

These modules support preliminary analysis and engineering education. They do not constitute complete connection-design procedures.

Practical Engineering Calculation Features

LRFD & ASD Screening

Select Load and Resistance Factor Design or Allowable Strength Design and review selected shear-strength calculations using the corresponding design-strength factors.

Transparent Shear-Strength Equations

Examine gross-section shear yielding and net-section shear rupture calculations associated with ANSI/AISC 360-22 Equations J4-3 and J4-4.

Bolt-Group Mechanics

Explore bolt coordinates, group eccentricity, direct shear distribution, and elastic bolt-force calculations for supported rectangular layouts of up to eight bolts.

Weld-Group Mechanics

Examine illustrative fillet-weld throat calculations and elastic force distribution for a defined two-line weld-group arrangement.

Connection Geometry & Detailing

Organize plate dimensions, angle geometry, bolt spacing, member clearances, weld dimensions, and preliminary geometric-fit comparisons.

Engineering Calculation Dashboard

View active connection inputs, selected calculated strength ratios, warnings, and calculation-readiness information in a centralized dashboard.

Calculation Traceability

Follow calculation inputs, formulas, referenced equations, assumptions, and linked workbook results.

Quality Assurance & Applicability

Review 30 QA and applicability checks covering inputs, numerical screening conditions, engineering limitations, and unsupported applications.

Preliminary Candidate Comparison

Compare selected plate-thickness alternatives using the implemented connected-element shear equations. This feature is not a comprehensive connection-sizing optimizer.

What's Included

• 20-sheet Excel engineering calculation workbook (.XLSX)

• 15-page structural steel shear connection calculation and user guide (.PDF)

• README with operating instructions, implemented-feature details, verification status, and limitations (.MD)

• Complete downloadable ZIP package

Who Is This Toolkit For?

• Civil and structural engineers

• Junior structural engineers and engineering trainees

• Structural steel connection design professionals

• Steel detailers and fabrication technical staff

• Engineering consultants

• Structural engineering educators and students

• Professionals studying preliminary steel connection calculations

Engineering Scope & Limitations

The workbook uses US Customary units (inches, kips, and ksi) and evaluates one active connection at a time.

It is a preliminary, partially verified engineering calculation resource. Complete connection-specific strength, bolt, weld, member, and detailing checks have not been independently validated. The workbook therefore does not issue an overall engineering design approval.

It does not replace ANSI/AISC 360, the AISC Steel Construction Manual, project-specific engineering calculations, applicable construction standards, or review by a qualified structural engineer.

PRELIMINARY ENGINEERING CALCULATION TOOL — NOT FOR DIRECT FABRICATION OR CONSTRUCTION APPROVAL.

Product Information

Format: Excel Workbook + PDF Guide + README
Excel Worksheets: 20
Technical Guide: 15 Pages
Design Reference: ANSI/AISC 360-22 (selected provisions)
Units: US Customary
Edition: First Edition, 2026
Publisher: Sarchawa
Website: sarchawa.com

Developed for transparent engineering calculation study, preliminary strength screening, and structured technical review.

Product Highlights

20 INTERCONNECTED EXCEL WORKSHEETS

AISC 360-22 J4-3 & J4-4 SHEAR EQUATION SCREENS

LRFD & ASD CALCULATION MODES

SINGLE-PLATE & CLIP-ANGLE MODULES

ELASTIC BOLT-GROUP & WELD-GROUP ANALYSIS

GEOMETRY & DETAILING REVIEW

30 QA & APPLICABILITY CHECKS

CALCULATION TRACE & SOURCE REGISTER

PRELIMINARY CANDIDATE COMPARISON

15-PAGE TECHNICAL USER GUIDE

US CUSTOMARY UNITS

PRELIMINARY ENGINEERING TOOL — VERIFICATION REQUIRED

What's Included — Downloadable Files

1. Structural-Steel-Shear-Connection-Sizing-and-Check-Sheet.xlsx

2. Structural-Steel-Shear-Connection-Calculation-and-User-Guide.pdf

3. Structural-Steel-Shear-Connection-README.md

All three files are provided in:

Structural-Steel-Shear-Connection-Complete.zip

Frequently Asked Questions

Q: What software do I need?

A: A recent desktop version of Microsoft Excel is recommended. Automatic formula recalculation should be enabled.

Q: Does this workbook support LRFD and ASD?

A: Yes. The workbook supports LRFD and ASD modes for its implemented preliminary shear-strength screening calculations.

Q: Which connection types are included?

A: The workbook provides input and preliminary analysis modules for single-plate shear tabs, single-angle connections, and double-angle clip connections. Complete design verification of these connection types is not included.

Q: Which AISC specification is referenced?

A: ANSI/AISC 360-22. Selected connected-element shear calculations reference Equations J4-3 and J4-4. The workbook does not implement the entire specification.

Q: Does the workbook calculate bolt and weld group forces?

A: It includes simplified elastic bolt-group mechanics and illustrative two-line weld-group analysis. These are not independently verified, complete AISC bolt or weld design procedures.

Q: Can it generate construction-ready connection designs?

A: No. It is a preliminary engineering study and calculation resource. Final connection design, engineering approval, fabrication, and construction require complete project-specific verification by a qualified structural engineer.

Q: Does it support SI units?

A: No. The current release uses US Customary units: inches, kips, and ksi.

Q: Can I analyze multiple connections?

A: The workbook calculates one active connection at a time. The Connection Schedule can record additional entries, but it does not independently calculate every scheduled connection.

Q: Can I edit the calculations?

A: Users may enter and modify designated engineering inputs and adapt the workbook for authorized internal use. Any modification affecting the engineering methods requires independent checking.

Q: Is this an official AISC product?

A: No. It is an independently published educational and preliminary calculation toolkit, not an AISC-certified or AISC-endorsed design application.

Important Engineering Disclaimer

IMPORTANT ENGINEERING DISCLAIMER

This product is intended for engineering education, preliminary calculation study, and structured technical review.

The workbook contains selected calculation methods referenced to ANSI/AISC 360-22 and other illustrative engineering mechanics procedures. Not all required connection limit states, code provisions, geometry rules, bolt and weld requirements, member checks, or project-specific design conditions are implemented or independently verified.

Results must not be interpreted as certification of structural adequacy, final engineering approval, or authorization for fabrication or construction.

Users are responsible for confirming input accuracy, applicable specifications, load combinations, engineering assumptions, connection load paths, material properties, and all required limit states.

A qualified structural engineer must independently review and approve any calculations used in professional engineering work.

Sarchawa is not affiliated with or endorsed by the American Institute of Steel Construction (AISC).

Digital Product License

PERSONAL & INTERNAL PROFESSIONAL USE LICENSE

Purchase grants the buyer permission to use this digital product for personal engineering education, professional study, and internal engineering analysis.

The buyer may edit designated workbook inputs, adapt the files for internal workflows, and print calculation records for internal documentation, subject to appropriate engineering verification.

Redistribution, resale, public sharing of the complete files, rebranding of the original product, and selling substantially unchanged copies are not permitted without authorization.

This license does not transfer ownership of the original workbook design, documentation, or publishing materials.

Third-party specifications, standards, trademarks, and underlying engineering principles remain the property of their respective rights holders where applicable.

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