This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

"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
| Find on | Find on | Find on | Find on | Find on |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
30 Mar 2009
Submitted By:
File Date:
03 Mar 2009
File Author:
Alex Tomanovich
File Version:
File Size:
1,943.50 Kb
File Type:
stars/5.gifTotal Votes:14
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#8 ATomanovich 2016-11-21 18:55
Quoting debest:
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

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.
#7 debest 2016-11-21 15:40
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
#6 hades3 2013-12-02 16:01
#5 JAHAN 2010-08-30 10:39
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.
#4 gregoryz 2008-10-22 08:43
The spreadsheet works well

Please sign in or register to add a comment.

We have 14 guests and 50 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics