This forum thread will track of the version history of the following download:
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.

In the 'General Joist Analysis' tab... there is an error in the data validation error message in cells D41 through D47. The error message refers to a value in cell B40, but should be referenced to the cell B in the same row. for instance D41 should be checked against B41, D42 to B42 etc...

to see what i am talking about, enter the first load in row 40 that starts at 15 ft. and ends at 30 ft. then add another load in row 41 that starts at 0 ft and ends at 12 ft.... or any number less than 15 ft.

I hope you can find it...

Yep, I know exactly what you're referring to. I had made the same inadvertent mistakes in the input data validation in the "BEAMANAL.xls" workbook which I corrected a few weeks ago, and was re-posted for me by John Doyle on this website. The "General Joist Analysis" worksheet of the "JOIST.xls" workbook was a basic copy of what I had done for general beam analysis. I just forgot that it was a copy.

By the way, let me point out that these mistakes in input data validation also existed in the cells pertaining to the original design loads, not just for the new design loads that you discovered. Nothing like me being consistent, right?

I will make the corrections in the input data validation for cells D21 through D27 as well as D41 through 47, and an updated version (1.5) of the "JOIST.xls" workbook will be posted.

Thanks for bringing this to my attention.

Alex

The same input data validation "glitch" that was found and corrected a few weeks ago in the "BEAMANAL.xls" workbook also existed in the "JOIST.xls" workbook, in the "General Joist Analysis" and "KCS-Joist Analysis" worksheets.

Reiterating from before, in the user input data cells for distributed/partial distributed loads, my original intent was to place input data validation on the user input values of the end distances, "e", for the distributed loads, such that "e" must be >= "b", which would prevent the user from entering bogus values for "e". The input data validation for the "e" values should have each been tied to the appropriate cell for the beginning distance, "b". Problem was, I had all of the "e" distance cells tied to the "b" distance for only the first distributed load. I have made the corrections in both of the worksheets as required.