Roof Purlin Design

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

Calculation Preview

This spreadsheet is to be used to check the adequacy of roof purlins for a specified combination of loads. The designis based on the maximum yeild strength (Mn = FySx) as stated in the AISC Manual 13th Ed. This spread sheet can only be used for load combinations with two variables. In most cases the worst case scenario is 0.6DL+W, so this should be adequate. Only the values in the highlighted cells need to be changed.

Calculation Reference
Roof Design
| Find on | Find on | Find on | Find on | Find on |
Structural Steel
| Find on | Find on | Find on | Find on | Find on |
Cold Form Sections
| 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:
10 May 2012
Submitted By:
File Date:
09 May 2012
File Author:
File Version:
File Size:
1,225.16 Kb
File Type:
stars/4.gifTotal Votes:5
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.


#4 duke666 2016-07-12 22:53
It looks like the Dead Load and Wind Load values are reversed in the formula in E32. Or another way of looking at it is that the labels in H21 & K21 are reversed.

Also, since wind uplift is the usual condition, the bottom flange is the compression flange, and cannot be assumed to be braced, so the lateral-torsional buckling statement is incorrect.
#3 Valermos 2012-05-10 15:32
Yes it is. I'm starting off simple. By the way, in structural reports, is it more desirable to have all working shown or will results in tabulated format with code cited in the reference column be adequate.

My aim is to develop spreadsheets that only need to have the input changed and then printed out.
#2 ryandarwin 2012-05-10 15:22
So simple. Nothing is new.
#1 JohnDoyle 2012-05-10 08:10
Thanks for your second contribution. Its always good to welcome another author helping to build our repository. I have extended your XLC Pro subscription by way of thanks. [Admin]

Please sign in or register to add a comment.

We have 8 guests and 37 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