I-Shapes&Channel Flexural/Compression Capacity

Rating:
3

Description


The flexural and compressive strength of a rolled steel I-Shape or Channel member is calculated as per the AISC Manual of Steel Construction, 14th Edition. Both the ASD and LRFD strength is calculated. 
 
AISC 14TH EDITION
FLEXURAL/COMPRESSIVE DESIGN FOR I-SHAPES AND CHANNELS v1.1
(UPDATE: Added a separate cell for input of kx and ky separately) 

GUIDELINES:

1. This spreadsheet is for educational purposes only.
2. The purpose of this spreadsheet is to calculate the flexural and compressive capacity of an I-Shape or Channel member.
3. All member information and calculations are as per AISC 14th Edition Steel Construction Manual.
4. The user inputs required are the member to be checked, the yield strength of the steel, the Lb/Lx/Ly of the member and the Cb/k value.
5. The flexural capacity in both the X-X and Y-Y axis is calculated and the appropriate limit state is also determined for each axis. Both the ASD and LRFD capacity is calculated for flexural and compressive strength.
6. There are tables and graphs within the manual that provide this information also, but not for all members and are limited to Grade 50 steel. Additionally, users may find the spreadsheet useful to check intermediate values if they are manually calculating the flexural/compressive capacity.
7. The same member is not automatically selected for the compressive capacity check. If the user wants to automate this step, simply change the formula in the 'Compression (3)" worksheet, cell C4 to "='Flexure (2)'!C4". 
8. This is not a beam-column check. The spreadsheet does not calculate the combined flexural and compressive capacity. Future updates may include this calculation also as per user suggestions.

Calculation Reference
Beam Analysis
Structural Assessment
AISC

Calculation Preview

Submitted On:
22 Oct 2014
File Size:
788.81 Kb
Downloads:
135
File Version:
1.1
File Author:
Str Eng
Rating:
3

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 1
JohnDoyle[Admin] 8 years ago
Thanks for your submission I have awarded a free 3 month XLC Pro subscription by way of thanks.