The Allowable Stress Design (AISC-ASD) 9th Edition provides detailed provisions for designing steel stair systems that are safe and long-lasting while complying with code requirements. This Excel sheet automates the design of steel stair components including stringers, treads, risers, and landings under typical occupancy live loads and self-weight.
Steel Stair Design Components
The sheet breaks the stair system down into its primary components — stringers (the inclined structural members supporting the treads), treads, risers, and landing platforms — and checks each against AISC-ASD 9th Edition allowable stress limits for bending, shear, and deflection under the governing live and dead load combination.
What This Excel Sheet Calculates
- Stringer bending and shear stress under stair live load and self-weight
- Tread and riser plate stress and deflection
- Landing beam sizing and support reactions
- Stringer-to-support and stringer-to-landing connection capacity
- Handrail post loading, where included in the layout
- Overall stair deflection against serviceability limits
Design Inputs Required
- Stringer section size and steel grade (Fy)
- Stair span, total rise, and tread going
- Live load per the governing occupancy category
- Number of stringers and tread spacing
- Support and connection type at the top and bottom of each stringer
- Handrail load, if the stair includes a guardrail system
Applicable Design Codes
This sheet follows the Allowable Stress Design (ASD) method set out in the AISC 9th Edition Manual of Steel Construction. Member and connection checks are based on comparing calculated stresses against the allowable stresses defined for the applicable steel grade and section type.
Who Should Use This Tool
This tool is intended for structural engineers and designers responsible for steel stair systems in industrial, commercial, and access-way applications, as well as engineering students studying allowable stress design methods for secondary steel members.
Download the Free Steel Stair Design Sheet
This free Excel sheet gives engineers a quick, reliable way to check steel stair stringers, treads, risers, and landings against AISC-ASD 9th Edition allowable stress limits. Instead of working through the stringer bending, shear, and deflection checks by hand for every stair configuration, the sheet automates the calculation so results can be reviewed and adjusted quickly during design iterations. It is set up for typical industrial and commercial stair layouts and can be adapted to project-specific spans, loads, and section sizes.



Be the first to comment.