You can use this sheet to Check of Shear Plate bolted connection according AISC360‐05 (LRFD), Rev0
#AISC_Spreadsheet
for any comments in this sheet post your comment below.
"Great engineering starts with the KISS principle—keep it simple, every day."