AISC 360-22 Beam-Column Design Aid (Live for download!) 2

[RattlinBog]

https://sites.google.com/view/steel-design-aid

Above is the link to a Google Site I put together for the AISC 360-22 steel design aid I developed for my civil engineering M.S. grad project over the last couple years. You are welcome to download, use, and share freely! The download links simply pull from google drive. I also uploaded the design aid to steeltools.org, but it is still under review. I can post an update when it gets published.

There is an Excel file, which is the most comprehensive and full version; and there is a Mathcad Prime file, which is similar to the Excel file but with less features. For some reason, the Mathcad file takes a while to download, so just wait a couple minutes. I also provided a link to my project report for those interested in some background.

Reference this thread: https://www.eng-tips.com/threads/steel-design-aid-aisc-360-22-sharing-the-tool.523980/

I'm happy to answer questions on this thread or in the email I provided on the google site. I hope this is helpful to some folks!

 

[bones206]

This is really excellent work. I do a lot of renovation work and will be making great use of this tool. Thank you for sharing!

 

[RattlinBog]

Thank you--I'm happy to hear it! What started as a personal frustration with lacking resources for corroded and reinforced member design, turned into a bigger project that I wanted to share with others.

If you (or others) find errors or have suggestions for improvement/new features, feel free to send an email to the email address listed on the "User Guide" of the Excel file and at the bottom of the google site. I probably won't be messing with the design aid for a while as I just need a break from staring at it for 2 years, but I could start a backburner to do list if issues are found.

 

[EngDM]

I am excited to dig into this and adapt it to CSA requirements and Canadian load cases. If/when I get around to that, I will surely email you a copy. Scope is basically to address several of the design aid limitations. And adding HSS of course, although since they aren't LTB sensitive the equations are a little different, so hopefully thats easy to integrate.

Would be interesting to set up something that deals with the loade cases so you don't need to check each case manually.

 

[RattlinBog]

EngDM, sounds great!

Would be interesting to set up something that deals with the load cases so you don't need to check each case manually.

You may be thinking of the Analysis tab, which is only good for one simple-span beam, and yes, all loads are manually-entered.

However, Part 2 "Loads & Deflection Criteria" of the Design tab goes through the ASCE 7 load combinations based on user input for dead, live, roof live, snow, rain, and wind, but only for the following types of loads: full-length uniformly distributed load (entered as psf load, which is multiplied by tributary width in the background); concentrated load at midspan; and 2 equal, symmetrically-placed concentrated loads.

That's not going to cover every type and position of load, but it should cover many common scenarios.

 

[EngDM]

EngDM, sounds great!


You may be thinking of the Analysis tab, which is only good for one simple-span beam, and yes, all loads are manually-entered.

However, Part 2 "Loads & Deflection Criteria" of the Design tab goes through the ASCE 7 load combinations based on user input for dead, live, roof live, snow, rain, and wind, but only for the following types of loads: full-length uniformly distributed load (entered as psf load, which is multiplied by tributary width in the background); concentrated load at midspan; and 2 equal, symmetrically-placed concentrated loads.

That's not going to cover every type and position of load, but it should cover many common scenarios.

View attachment 1824

Correct me if I am wrong, but does the spreadsheet currently take the maximum of all load cases for shear/moment and run the combination equations with the maximums? If this is indeed how the spreadsheet is doing it, this may be overly conservative; you should be comparing the shear from the same combination with each moment. For instance, your max shear comes from wind, but max vertical comes from snow. The spreadsheet as it stands would use the highest wind factored, and the highest snow factored.

 

[RattlinBog]

You're probably right, but I might not be following what you're saying correctly. Are you talking about wind and snow on a column? The spreadsheet is definitely more "beam friendly." If you're designing a column, all the axial loads and weak axis bending would have to be done by hand and entered manually.

The spreadsheet just takes the shear and moment values for each type of load (dead, live, snow, etc.) and runs them through the ASCE 7 load combinations (both LRFD and ASD). It only does this for strong axis bending/shear and only for the three types of loading scenarios I listed in my last post.