Moment connection of Wide Flange Beam to HSS Column EXCEL calculator - CivilEngineeringBible.com (Download FREE!)

Files > Download Moment connection of Wide Flange Beam to HSS Column EXCEL calculator - CivilEngineeringBible.com (FREE!)

Disclaimer:

Spreadsheet is not compatible with Excel versions prior to 2010

Codes Used:

ASCE 7-10

AISC 360-10

AISC Design Guide 24 (modified for AISC 360-10 equations)

Information:

Cells requiring input are shaded yellow

Weld strength is 70 ksi

For through-plate connection, spreadsheet assumes 2 rows of bolts

2" from end of beam to centerline of first bolt holes

Bolt spacing s = 3" for db ≤ 1 1/8"; s = 2.67*db for db > 1 1/8"

When HSS column is rectangular, enter "wide" or "narrow" for controlling column face failure to enter "wide" or "narrow" will result in an error "wide" or "narrow" not required with square or round columns

**Spreadsheet checks moment connection only--engineer is responsible for checking structural adequacy of column and beam

**shear resistance of connection is checked by a different spreadsheet