Design For Roof Purlins Spreadsheet

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

Download Link