Please reply to this topic to comment on or discuss Repository item:
BEAMANAL.xls

It is a good spreadsheet but like so many not in metric so not useful and efficient for non American Engineers.

Since all the units are consistent I think it would be easy to generate a metric version of this calculation. I you do please upload a copy for everyone to share. If you want a quick work around you might like to use the ChangeUnits add in for Excel. Thanks for your comments DvdHntr.

In the "Single-Span Beam & Code Check" worksheet of the "BEAMANAL.xls"
workbook, it was discovered that if the user selected a channel shape and input a value = 0 for the unbraced length (Lb) for bending, the program would give you a "#DIV/0" error message.

This has now been corrected. What the program does is check if the user input value is <= 1' and if so it uses a value of Lb = 1'. I had already used this same logic for the W and S shapes in the beam size selection pick box, but obviously forgot to use it for channels as well. Of course, there was always the work around of inputting a small value > 0 for the unbraced length.