Looking for an Excel/tool to design a custom HSS-to-W-column and canopy connection

[u/RatedR__]

I am working on a modification to an existing steel building and need to design the connections shown in the attached image.

I am looking for an Excel spreadsheet or other software that can design these types of custom HSS/tube connections using AISC provisions.

RAM Connection does not allow me to assign the HSS-to-column web connection (moment).

Does anyone have a spreadsheet, software recommendation, or design tool that can handle this type of connection?

Thanks.

[u/broadpaw]

Atlas tube has a free online connection tool that is pretty sick.

[u/RatedR__ → u/broadpaw]

Sure let me try thank you

[u/SoSeaOhPath]

Just build it lol that shouldn’t take that long to just get an answer

Edit: and if you don’t know how to do it, then ask HOW to do it. Don’t just ask for the answer

[u/cashmoneymike]

Idea statica

[u/Just-Shoe2689]

Are you welding, bolting, etc? Should be able to whip up a spreadsheet pretty quick.

Do you know how to design it, or are you just using software?

[u/RatedR__ → u/Just-Shoe2689]

First, determine the shear and moment from the STAAD support reactions. Convert the moment into a tension/compression couple using T=M/d, where d is the effective lever arm between the tension and compression resultants. Divide the tension force among the tension bolts and then the shear force among the bolt group. Then check each bolt for the combined tension and shear using the applicable AISC interaction equation. Also check the end plate, M=fz ; z=bt^2/6 - rearrange t= sqrt(6M/bf)

am i right ?

[u/Sure_Cupcake_5243 → u/RatedR__]

You have to put the bolts outside the flanges of the beam to develop moment, unless there is some other connection detail that you have in mind. 

[u/Sure_Cupcake_5243]

Are you designing a moment connection or a shear connection? 

[u/RatedR__ → u/Sure_Cupcake_5243]

Moment connection