Spreadsheets

AISC 360-22 Steel Section Properties & Capacity Calculator (European Profiles: IPE, HEA, HEB, UPN, IPN)

29 $

What's Included

Macro-enabled structural steel calculation workbook implementing AISC 360-22 (LRFD Specification for Structural Steel Buildings) and TYCTE 2016. Features complete section property databases for European hot-rolled profiles (IPE, HEA, HEB, UPN, IPN), width-to-thickness ratio classification (Table B4.1), Chapter E axial compression with Section E7 slender element reductions, Chapter F flexure and Lateral-Torsional Buckling (LTB), Chapter G shear, Appendix 8 second-order P-delta effects (B1 multiplier), and Chapter H combined biaxial bending interaction.

  • Standard Compliance: AISC 360-22, ASCE/SEI 7-22, AISC 16th Edition, TYCTE 2016
  • Profile Library: IPE 100–600, HEA/HEB 100–1000, UPN 50–400, IPN 80–600
  • Steel Grades: S235, S275, S355, S450, ASTM A36, A572 Gr. 50, A992
  • Format: Macro-Enabled Excel Workbook (.XLSM) with dynamic multilingual UI (English, Turkish, Arabic)
⚡

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 structural steel calculation workbook provides an automated strength and capacity evaluation engine for hot-rolled structural steel members according to the AISC 360-22 Specification for Structural Steel Buildings (LRFD method) and TYCTE 2016 (Turkish Steel Code). Built specifically for structural engineers designing steel structures with European profiles, the workbook cross-references geometric dimensions from EN 10365 / DIN standards with American Institute of Steel Construction limit state formulations.

Building Standards: AISC 360-22 • ASCE 7-22 • TYCTE 2016
Cross-Sections: IPE • HEA • HEB • UPN • IPN
Units: SI Metric (mm, cm², cm&sup4;, kN, kN·m, MPa)
Delivery: Excel .XLSM + Open Formulas + VBA Core

Calculation Capabilities & Technical Scope

The workbook executes step-by-step structural capacity verifications conforming to the latest AISC 360-22 and ASCE 7-22 provisions:

ModuleAISC 360-22 ClauseEngineering Scope & FormulationGoverning Limit States
Section Database & PropertiesAISC Part 1 / EN 10365Dynamic header lookup for area A, depth d, width b, web thickness tw, flange thickness tf, root radius r, moments of inertia (Ix, Iy), elastic moduli (Wex, Wey), plastic moduli (Wpx, Wpy), radii of gyration (ix, iy), torsion constant J, and warping constant Cw.Geometric Properties
Width-to-Thickness Ratio LimitsTable B4.1a & Table B4.1bClassification of unstiffened elements (flanges b/tf) and stiffened elements (webs h/tw) under pure axial compression and flexure into Compact, Noncompact, or Slender sections against λp and λr limits.Local Buckling Classification
Compression CapacityChapter E (E1, E3, E4)Evaluation of flexural buckling stress Fe (Eq. E3-4) for major and minor axes, torsional / flexural-torsional buckling stress Fe (Eq. E4-2), critical stress Fcr (Eq. E3-2 & E3-3) with boundary 4.71√(E/Fy), and design compressive strength φcPn (φc = 0.90).Flexural & Torsional Buckling
Slender Element ReductionSection E7 & Table E7.1Effective width method for slender compression elements: elastic local buckling stress Fel = (c2λr/λ)²·Fy, effective width be, net effective area Ae = ∑bet, and reduced compressive capacity Pn = FcrAe.Effective Width Ae
Major & Minor Axis FlexureChapter F (F1, F2, F3, F6)Moment gradient modifier Cb (Eq. F1-1), limiting unbraced lengths Lp and Lr, Lateral-Torsional Buckling (LTB) across yielding (Mp = FyZx), inelastic LTB (Eq. F2-2), and elastic LTB (Eq. F2-3). Flange Local Buckling (FLB) and Web Local Buckling (WLB) checks. Minor axis bending strength φbMny.Yielding • LTB • FLB • WLB
Shear DesignChapter G (G1, G2.1, G6)Major axis web shear capacity φvVnx with web shear strength coefficient Cv1 (Section G2.1(b)) and resistance factor φv = 1.0 or 0.90 based on web slenderness. Weak-axis flange shear capacity φvVny per Section G6 (φv = 0.90).Web & Flange Shear Limit States
Second-Order EffectsAppendix 8 (Section 8.2)Approximate second-order analysis using multiplier B1 to account for P-δ effects: B1 = Cm / (1 – αPr/Pe1) ≥ 1.0, where Pe1 is the Euler buckling strength determined with effective length Lc. Amplified required flexural strength Mr = B1Mnt + B2Mlt.P-δ Moment Amplification
Combined Axial & FlexureChapter H (Section H1.1)Interaction equations for doubly symmetric members subject to axial force and biaxial flexure: Eq. H1-1a for Pr/Pc ≥ 0.2, and Eq. H1-1b for Pr/Pc < 0.2. Reports unity check ratio and governing failure mode.Interaction Equations H1-1a/b
Serviceability DeflectionChapter L / ASCE 7-22 App. CElastic midspan deflection δ = 5qL4/(384EI) evaluated under service load combinations (G + Q and G + 0.5S) against specified deflection thresholds (L/300 and L/360).Deflection Limits L/300, L/360

Supported Profile Series & Steel Materials

European I-Sections (HEA, HEB, IPE, IPN)

Broad flange HEA (HE 100 A to HE 1000 A), HEB (HE 100 B to HE 1000 B), standard parallel flange IPE (IPE 100 to IPE 600), and tapered flange IPN (IPN 80 to IPN 600) per EN 10365 / DIN 1025.

European Channels (UPN Series)

Standard U-channels from UPN 50 to UPN 400 per DIN 1026-1 / NF A 45-255. Geometric properties include shear center offset xo and minor axis section modulus for channel orientations.

Structural Steel Grades & Thickness Reductions

Pre-configured steel grades: EN 10025 structural grades (S235, S275, S355, S450) with automated yield strength Fy step reductions for flange thickness t > 40 mm, plus ASTM equivalents (A36, A572 Gr. 50, A992).

ASCE 7-22 LRFD Load Combinations

Strength design combinations: 1.4G; 1.2G + 1.6Q + 0.5S; 1.2G + 1.6S + 1.0Q; 1.2G + 1.6S + 0.5W; 1.2G + 1.0W + 1.0Q + 0.5S; and 0.9G + 1.0W (using strength-level wind).

Worksheet Screenshots

Printable calculation views exported directly from the calculation sheets:

AISC 360-22 Section Properties and Loading Input
Figure 1: Profile selection, cross-section dimension verification, major/minor axis geometric properties, and ASCE 7-22 LRFD load combinations.
AISC 360-22 Compression and Flexural Capacity Checks
Figure 2: AISC Table B4.1 width-to-thickness ratio limits, Chapter E flexural/torsional compression capacity, and Chapter F Lateral-Torsional Buckling evaluation.
AISC 360-22 Shear Second-Order B1 Interaction H1 Deflection
Figure 3: Chapter G web and flange shear checks, Appendix 8 second-order B1 multiplier, Chapter H interaction equation H1-1a/b, and span deflection limits.
AISC 360-22 Section E7 Slender Section Effective Width
Figure 4: AISC Section E7 and Table E7.1 effective width formulation for slender compression elements and reduced effective area Ae determination.
AISC 360-22 Technical Compliance Verification Log
Figure 5: Technical verification sheet documenting mapping of all spreadsheet equations and tables directly to AISC 360-22 specifications.

Building Code Standards & Regional Applicability

Resistance factors (φ), design strengths, and code equations correspond to international standards:

Region / CountryAdopted Design StandardEngineering Application & Compatibility
United States & International ProjectsAISC 360-22 / ASCE/SEI 7-22 / IBC 2024Standard LRFD member design for hot-rolled shapes; direct evaluation of European sections imported into US structural models.
Türkiye & Middle East RegionTYCTE 2016 / YÇTE 2018 (Turkish Steel Code)Direct clause alignment with YÇTE chapters 5, 8, 9, 10, and 11; toggle UI to Turkish for official municipal submittals.
Europe & United KingdomEN 10365 / EN 10025 / Eurocode 3 Cross-CheckEnables structural verification of standard European sections against AISC limit states for multinational industrial EPC projects.
Gulf States & Saudi ArabiaSBC 306 (Saudi Building Code – Steel)Fully compatible with SBC 306 steel design provisions, which adopt AISC 360 specifications as primary reference.
Southeast Asia & Latin AmericaAISC-Aligned National Building CodesProvides independent engineering verification for steel structures designed under AISC-derived national codes.

Spreadsheet Notes & Engineer Responsibility

  • Transparent Open Formulas: Cell calculations are fully visible and editable with standard Excel formulas and documented VBA routines for table lookups.
  • Dynamic Multilingual Engine: Toggle between English, Turkish (YÇTE), and Arabic by changing cell AI1 (1 = English, 2 = Türkçe, 3 = ΧΩΑ).
  • Professional Engineering Review: Boundary conditions, unbraced lengths (Lx, Ly, Lt), effective length factors (Kx, Ky), and applied load combinations remain the responsibility of the engineer of record.

Package Contents

  • Archive File: AISC-360-22-Steel-Section-Database-and-Capacity-Calculator.zip (1.63 MB)
  • Included Workbook: Steel Section AISC 360-22 TYCTE 2016.xlsm (Macro-enabled workbook)
  • Delivery: Instant Google Drive direct download link provided upon checkout.

Related Products

  • Steel Pinned Base Plate Design – AISC 360-10
    Spreadsheets
    VERIFIED DIGITAL FILE Instant access

    Steel Pinned Base Plate Design – AISC 360-10

    Excel checks for a pinned steel base plate to AISC 360-10: plate capacity under axial, tensile…

    ★★★★★
    (2) Digital
  • The Ultimate Automated Gantt Chart Template in Google Sheet. Boost Your Project Management!
    Spreadsheets
    -48% OFF
    VERIFIED DIGITAL FILE Instant access

    Automated Gantt Chart Template in Google Sheets

    Turn Google Sheets into a fully automated project planner: dynamic Gantt chart, task tracking and progress…

    Quality checked Digital
  • Premium HSE Dashboard Excel Templates – Professional Reporting Collection
    Spreadsheets
    VERIFIED DIGITAL FILE Instant access

    Premium HSE Dashboard Excel Templates

    A collection of ready-made HSE dashboard templates in Excel with clean layouts, charts and KPIs for…

    ★★★★★
    (5) Digital
  • Excel Steel Connection Design Calculation Sheet - Per AISC
    Spreadsheets
    VERIFIED DIGITAL FILE Instant access

    Excel Steel Connection Design Calculation Sheet - Per AISC

    Excel calculation sheet for an apex haunch steel connection to AISC: weld strength, bolt group and…

    ★★★★★
    (2) Digital
  • S

    Sale Assistant

    ● Online • 24/7 Support

    Please introduce yourself to start chat

    Sale Assistant
    Hello! 👋 How can I help you today?