JOIST.xls

Rating:
25

Description

"JOIST" is a spreadsheet program written in MS-Excel for the purpose of analysis of steel joists considered as
simple-span beams subjected to virtually any type of loading configuration.  Specifically, beam end reactions as well
as the maximum moments and deflections are calculated.  Plots of both the shear and moment diagrams are
produced, as well as a tabulation of the shear, moment, slope, and deflection for the joist span.  There are two
worksheets for selecting K-series and LH-series joists, and 2 worksheets which are the SJI Standard Load Tables.
This program is a workbook consisting of eight (8) worksheets, described as follows:
Worksheet Name
Doc - This documentation sheet
General Joist Analysis - General standard joist analysis for steel joists for non-standard loads
K-Joist Analysis - Analysis for typical, standard loaded, open-web K-series steel joists
K-Joist Table - Standard (SJI) load table for open-web K-series steel joists
KCS-Joist Analysis - Analysis for non-standard loaded, open-web KCS-series steel joists
KCS-Joist Table - Load table for open-web KCS-series steel joists
LH-Joist Analysis - Analysis for typical, standard loaded, longspan LH-series steel joists
LH-Joist Table - Standard (SJI) load table for longspan LH-series steel joists
Program Assumptions and Limitations:
1.   For the "General Joist Analysis" worksheet, the following reference was used in the development of this program: "Modern Formulas for Statics and Dynamics, A Stress-and-Strain Approach" by Walter D. Pilkey and Pin Yu Chang, McGraw-Hill Book Company (1978), pages 11 to 21.
2.   The "General Joist Analysis" worksheet on the joist span will handle a full length uniform load and up to eight (8) partial uniform, triangular, or trapezoidal loads, up to fifteen (15) point loads, and up to four (4) applied moments.
3.   The "General Joist Analysis" worksheet will calculate the joist end vertical reactions, the maximum positive moment and negative moment (if applicable), and the maximum negative deflection and positive deflection (if applicable).  The calculated values for the end reactions and maximum moments and deflections are determined from dividing the joist into fifty (50) equal segments with fifty-one (51) points, and including all of the point load and applied moment locations as well.  (Note: the actual point of maximum moment occurs where the shear = 0, or passes through zero, while the actual point of maximum deflection is where the slope = 0.)  
4.   In the "General Joist Analysis" worksheet the user is given the ability to input two (2) specific locations from the left end of the joist to calculate the shear, moment, slope, deflection, as well as the stress ratios for shear and moment.  This should be utilized when the maximum moment does not occur at the start or end of a segment.
5.   In the "General Joist Analysis" worksheet, the plots of the shear and moment diagrams as well as the displayed tabulation of shear, moment, slope, and deflection are based on the joist span being divided up into fifty (50) equal segments with-one (51) points.
6.   The "General Joist Analysis" worksheet will enable the user to either analyze an existing joist for new loads or determine the required total equivalent uniform load to be used to size a new joist.
7.   The "General Joist Analysis" worksheet only analyzes the joist "as a whole" and does not perform checks on the individual components.
8.   In the "General Joist Analysis" worksheet,  the deflections calculated include a 15% increase above the values calculated using traditional "simple-beam" flexure to more closely match actual test results obtained by SJI.
9.   For the "K-Joist Analysis" and "LH-Joist Analysis" worksheets, the Steel Joist Institute (SJI) Standard Load Table as well the "Recommended Code of Standard Practice for Steel Joists and Joist Girders" are used.  The Standard Load Tables are built into each of these two analysis worksheets.  The two worksheets will evaluate a user selected joist size, as well as display up to a maximum of 15 of the lightest joist sizes that are satisfactory for the loading and deflection criteria specified by the user.  The bridging requirements are also determined.
10.  This program contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc.  (Note:  presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell.  Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box".)

Calculation Reference
AISC

Calculation Preview

Uploaded
03 Mar 2009
Last Modified
30 Mar 2009
File Size:
1,943.50 Kb
Downloads:
1220
File Version:
1.6
File Author:
Alex Tomanovich
Rating:
25

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 18
ATomanovich 7 years ago

Doug,
I took a really quick look (spot check) at the K-series joist tables in the SJI 2005 Catalog and compared it to the 2010 SJI Catalog. I did not see any real changes. Can you advise me on what differences that you are aware of? I wrote the JOIST.xls workbook several years ago, and in the past 10 years, working in heavy industrial projects, I have not had any exposure to nor need for joists.
Alex
debest 7 years ago
Hi Alex - I believe this program is based upon the 2005 SJI tables. Is it possible to have it updated to the 2010 SJI tables? Thx Doug
hades3 10 years ago
Thanks
ATomanovich 13 years ago
Jahan,
While your question is not related to this thread on the JOIST.xls workbook, nevertheless I will answer it here.
Yes, I have a workbook called "FOOTINGS.xls", which is pretty handy for footing analysis and design. The workbook can be found under "Strength", and then "Structural Details" sections of the Calculation Repository. Look on page 3.
The workbook is in "English" units. Sorry, but that's my "cup of tea", as they say. (lol)
Alex
ATomanovich 13 years ago
Thank you.
ATomanovich 13 years ago
Thank you Alex for the information.
Please help me know if we have an ExcelCalc file in order to analyze and design a single footing.
Thank you
JAHAN
ATomanovich 13 years ago
Jahan,
The last mumber in a (Steel Joist Institute) joist is the "section designation", 1 through 12. The higher the number, the heavier the joist (wt./unit length), and the more distributed load it can safely carry. It used to be common place to refer to joists simply as "bar joists", because many times the members of joists were composed of bars/rods. The last number does not refer to a particular angle size, and has nothing to do with the specific member sizes.
I have done some retro-fit work in the past at existing facilities where roof joists were utilized. If you cannot obtain the shop drawings from the original joist vendor, then one has to literally take field measurements of the sections making up the joist. Also, if you do not have the original shop drawings or building project specifications, then you are faced with the question of the yield strength of the materials that were used in fabrication of the joists. Usually if you know approximately when the building was constructed, a call to a local joist vendor can be of some help.
Hope that helps.
Alex
ATomanovich 13 years ago
Alex I have noticed a question for you relating to joist.xls. It was not posted in this thread of the forum.
The original is here.
JAHAN 13 years ago
I have the joist.xls trial version. I am not able to check the formulas included in this file.
Please let me know if it is possible to view the formulas if I pay for the registration fee.
Thank you.
ATomanovich 15 years ago
In the "KCS-Joist Analysis" worksheet of the "JOIST.xls" workbook, the deflection ratios were found to be determined inconsistently with the factored up (by 1.15) deflections that were displayed.
To elaborate, the calculated deflection ratio in cell B74 based on the allowable capacity loads should have used the maximum absolute value of the deflections from cells B72 and B73. The simple-span beam static analysis deflections that were calculated were factored up by 1.15 to better reflect actual test results by the SJI as is noted in the comment box. The original defection ratio in cell B74 does not reflect this 15% increase in deflection.
Likewise, the calculated deflection ratio in cell B91 based on the actual design loads should have used the maximum absolute value of the deflections from cells B89 and B90. Again, the simple-span beam static analysis deflections that were calculated were factored up by 1.15. The original defection ratio in cell B91 does not reflect this 15% increase in deflection.
By the way, these same errors DID NOT occur in the "General Joist Analysis" worksheet. So much for me being consistent! (lol)
I have corrected the logic in cells B74 and B91, and the "JOIST.xls" workbook has now been updated to version 1.6.
ATomanovich 15 years ago
GFT,
I have reviewed your comments pertaining to the KCS-Joist Analysis worksheet, and your are indeed correct!
The calculated deflection ratio in cell B74 based on the allowable capacity loads should have used the maximum absolute value of the deflections displayed in cells B72 and B73. These simple-span beam static analysis deflections that were calculated were factored up by 1.15 to better reflect actual test results by the SJI. The original defection ratio in cell B74 does not reflect this 15% increase in deflection.
Likewise, the calculated deflection ratio in cell B91 based on the actual design loads should have used the maximum absolute value of the deflections displayed in cells B89 and B90. Again, the simple-span beam static analysis deflections that were calculated were factored up by 1.15. The original defection ratio in cell B91 does not reflect this 15% increase in deflection.
I have made the corrections to the logic in cells B74 and B91 and the updated version of this workbook will be posted soon on this website.
By the way, these same errors DID NOT occur in the "General Joist Analysis" worksheet. So much for me being consistent! (lol)
Alex
ATomanovich 15 years ago
I recently download the program. It is very well formated and I expect it will be very helpful. It appears there may be a error on the KCS Analysis page. It seems that the deflection ratio is not being computed properly in cells B74 and B91. Please review this and see if you concur.
ATomanovich 15 years ago
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.
ATomanovich 15 years ago
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? :laugh:
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
ATomanovich 15 years ago
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...
ranmoo 15 years ago
excellant spreadsheet. THANK YOU for sharing your expertise
ATomanovich 15 years ago
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.
ATomanovich 16 years ago
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.