
AISC 360-22 Steel Section Properties & Capacity Calculator (European Profiles: IPE, HEA, HEB, UPN, IPN)
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.
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:
| Module | AISC 360-22 Clause | Engineering Scope & Formulation | Governing Limit States |
|---|---|---|---|
| Section Database & Properties | AISC Part 1 / EN 10365 | Dynamic 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 Limits | Table B4.1a & Table B4.1b | Classification 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 Capacity | Chapter 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 Reduction | Section E7 & Table E7.1 | Effective 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 Flexure | Chapter 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 Design | Chapter 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 Effects | Appendix 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 & Flexure | Chapter 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 Deflection | Chapter L / ASCE 7-22 App. C | Elastic 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
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.
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.
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).
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:
Building Code Standards & Regional Applicability
Resistance factors (φ), design strengths, and code equations correspond to international standards:
| Region / Country | Adopted Design Standard | Engineering Application & Compatibility |
|---|---|---|
| United States & International Projects | AISC 360-22 / ASCE/SEI 7-22 / IBC 2024 | Standard LRFD member design for hot-rolled shapes; direct evaluation of European sections imported into US structural models. |
| Türkiye & Middle East Region | TYCTE 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 Kingdom | EN 10365 / EN 10025 / Eurocode 3 Cross-Check | Enables structural verification of standard European sections against AISC limit states for multinational industrial EPC projects. |
| Gulf States & Saudi Arabia | SBC 306 (Saudi Building Code – Steel) | Fully compatible with SBC 306 steel design provisions, which adopt AISC 360 specifications as primary reference. |
| Southeast Asia & Latin America | AISC-Aligned National Building Codes | Provides 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
Excel checks for a pinned steel base plate to AISC 360-10: plate capacity under axial, tensile…
Automated Gantt Chart Template in Google Sheets
Turn Google Sheets into a fully automated project planner: dynamic Gantt chart, task tracking and progress…
Premium HSE Dashboard Excel Templates
A collection of ready-made HSE dashboard templates in Excel with clean layouts, charts and KPIs for…
Excel Steel Connection Design Calculation Sheet - Per AISC
Excel calculation sheet for an apex haunch steel connection to AISC: weld strength, bolt group and…




