Shear Connection Design Excel Sheet

Shear Connection - A beam bolted to a column. It is a shear only connection because the beam flanges are not rigidly connected to the column. 
Note the gap shown between the bottom flange of the beam and the column.

download