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!)
Spreadsheet is not compatible with Excel versions prior to 2010
AISC Design Guide 24 (modified for AISC 360-10 equations)
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
Follow our official Facebook page (@civilengineeringbible) and Twitter page (@CivilEngBible) and do not miss the best civil engineering tools and articles!