AISC 13th Ed. Equation H1-1b

[AELLC]

In the otherwise excellent BeamCol13 Excel spreadsheet by Joel Berg PE, cell N48 on the Beam Col (Round HSS & Pipe) worksheet calculates AISC Eqn H1-1b, however one precedent cell N53 is blank.

I don't have the AISC Manual Edition 13, so does anyone know the referenced formula, or the fix to this particular Excel?

The attached file below is BeamCol13 in .xlsx file format, compatible with Excel 2007 or 2010.

 

[jberg]

AELLC,

I created that spreadsheet and you are correct that precedent N53 is blank, but it shouldn't be. Where the equation points to N53, it should be N44. It should be the weak axis bending stress ratio. I don't think I have the spreadsheet here at home, but first thing Monday morning, I will fix this issue and repost the spreadsheet to the steelTools.org website. Any other questions, please email me (I think my email address is in the Excel file properties).

Thanks!

JWB