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

It was recently brought to my attention in the "LH-Joist Analysis" worksheet of the "JOIST.xls" workbook that if one tried to select LH joists deeper and/or heavier than a 44LH12, the worksheet would basically bomb. What apparently happened was when I used the "K-Joist Analysis" worksheet as a template to create the "LH-Joist Analysis" worksheet, the lookup range used in several of the cells was not properly adjusted to include the entire table of data for LH joists.

This has now been corrected.

In the "JOIST.xls" workbook in the "K-Joist Analysis" worksheet it was discovered that in a few cells I had an inadvertent and undesirable extra space at the end of the 2 numbers in the table representing the allowable total and live loads for the joist sizes and spans. What the extra space did was prevent the program from correctly extracting the second number (live load) from the table. These few occurrences were very obvious to the user due to the erroneous single digit value which was displayed for the distributed live load (WLL) in the calculation page. By the way, the load table in the "LH-Joist Analysis" worksheet was also checked for the presence of any of the extra spaces and none were found.

The current version of this workbook is now 1.4.