Purlin Design
Purlin Design
Number of Spans                                       =                                   4
(for 1 or 2 spans, Bending Moment Coefficient is 8, for 3 or more spans, it is 10)
(in case of Bending about minor axis, (No of spans)x(No of sagrods+1) is used.
Dead Loads
Weight of Sheeting                                     =                                 5 kg/sqm
Self Weight of Purlin                                  =             Automatically Calculated from Section properties
Extra for cleats, as % of Purlin weight                =                                10 %
Additional Dead Loads to Consider                      =                                 0 kg/sqm
Live Loads
Live load on Roof                                    =             Automatically Calculated from Slope
                                                     =                                  75 kg/sqm
Additional Live Loads to be considered               =                                   0 kg/sqm
(For Design of Wall Girt (Cladding Runner), additional Live loads to be considered can be entered as -ve of LL on roof)
                                                                                           (Live load will be 0 effectively)
Wind Loads
Basic Wind Speed                                  39 m/s           Terrain Category                  1
k1                         1                Maximum Horizontal Dimension of Building              176 m
k3                         1                                       Hence, Bldg Class       C
                                                                   Height of Top                  12.3 m
Based on the data on right, k2 is obtained from the tables
k2                       0.85
Based on the h/w and l/w, the values of Cpe is obtained from tables as noted below:
Maximum Downward Cpe (include sign)                               0
Maximum Upward Cpe (include sign)                            -0.943
Output Summary
Stresses Ok?                            OK
Critical Stress Factor                  0.95
Hence, Overall: OK
Notes:
1. Section Properties Check based on Section 9 of B:5950 Part 5 is a guideline and not mandatory
               Hence, Design is considered Safe even if above check only is not okay but all other checks are okay
2. Currently, this design only works if full width is effective. If full width is not effective,
               this spreadsheet will report Failure in Stress Check
3. Not suitable currently for curved roofs.
4. Design is not suitable for varying spans of purlins (varying truss spacing)
                                                                          Z Purlin Design Report                Created by Madurai ES Consultancy Services Pvt Ltd
Revision History                                        R0: Basic Design with checks for Stresses and Deflection based on IS 800 only
                                                        R1: Added Section property checks and Allowable Stress Calculations based on IS 801
Number of Spans = 3
Bending Moment Coefficients: Use 8 for Single/Two spans, 10 for 3 or more spans
Bending Moment Coefficient for Mxx(BMCX)                                                                                      10
For Bending About Minor Axis, Number of spans= number of spans x (number of sagrods+1)
Number of Spans about Minor Axis                                        =                                                     15
Bending Moment Coefficient for Myy(BMCY)                                                                                      10
DEAD LOAD
LIVE LOAD
Live Load on Roof = 75 kg/sqm if slope is less than 10 degrees. If Slope is more than 10 degrees, LL = 75 – 2x(slope-10), subject to minimum of 40 kg/sqm
Live load on Roof                                                              =                                              75 KG/M2
Additional Live Loads to be considered                                        =                                                0 KG/M2
(For Design of Wall Girt (Cladding Runner), additional Live loads to be considered can be entered as -ve of LL on roof)
Terrain Category                                                                                      1
Maximum Horizontal Dimension of Building                                                            176 m
Hence, Building Class is                                                       C
Height of Top                                                                                       12.3 m
Page 3
                                                                        Z Purlin Design Report         Created by Madurai ES Consultancy Services Pvt Ltd
Based on the h/w and l/w, the values of Cpe is obtained from tables as noted below:
Maximum Downward Cpe (including sign)                                                          0
Maximum Upward Cpe (including sign)                                                       -0.943
Design Calculations: Primary Load Cases – Conversion of forces to Normal And Tangential Components
WL is normal to roof
Hence, WL1 normal component = WL1 x Spacing =                                            -1.332 kN/m
And, WL1 Tangential component =                                                               0 kN/m
WL is normal to roof
Hence, WL2 normal component = WL2 x Spacing =                                             0.462 kN/m
And, WL2 Tangential component =                                                               0 kN/m
Page 4
                                                               Z Purlin Design Report         Created by Madurai ES Consultancy Services Pvt Ltd
For Strength Design, 0.75 factor is applicable for combinations with Wind Load since 33.33% extra stress is allowed
Hence, the components of load in the various load combinations for Strength design are
                       DL+LL                 0.75(DL+WL1)        0.75(DL+LL+WL2)
Normal Load                            1.195              -0.888             1.242 kN/m
Tangential Load                        0.105               0.010             0.078 kN/m
Design Calculations: Checking Basic Section Properties based on Section 9 of BS:5950 Part 5 – 1998
Hence NOT OK
Hence OK
Hence OK
Hence NOT OK
Check No. 5 – Zxx of Purlin >= WL/1400 for Simply Supported Purlin and >=WL/1800 for Continuous Purlin
Zxx                     =                                  75.40 cm3
Page 5
                                                               Z Purlin Design Report             Created by Madurai ES Consultancy Services Pvt Ltd
WL/denominator 63.735
Hence OK
Result 1: Check for Section Properties Based on BS 5950 Part 5 Sec.9: NOT OK
Design Calculations: Checking Basic Section Properties based on IS 801 for Lip of Purlin
Minimum Depth of Lip shall be 2.8 x t x ((w/t)^2-281200/Fy)^(1/6) and not less than 4.8t
t=                                                               2 mm
w=                                                            55.4 mm
Fy=                                                          3450 kg/sqcm
w/t=                                                          27.7
2.8 x t x ((w/t)^2-281200/Fy)^(1/6)                         16.630 mm
4.8t=                                                          9.6 mm
Lip l= 20 mm
Hence OK
Hence OK
Compression stress based on full width = Max (Mxx/Zxx+Myy/Zyy) for all three unfactored combinations
f                          =                               215.082 N/sqmm
                           =                              2150.821 kg/sqcm
1435/sqrt(f) =                                              30.942
w/t =                                                         27.7
Maximum Compressive Stress based on Lateral Buckling of Flange, as per Clause 6.3 of IS 801
Calculate X=L2Sxc/(dIyc)
Page 6
                                                                Z Purlin Design Report              Created by Madurai ES Consultancy Services Pvt Ltd
and Y = Pi2ECb/Fy
Fb, the Allowable Compressive Stress based on Lateral Buckling of Flange is calculated as
X<0.18Y implies, Fb = 0.6 Fy        - CASE (i)
X>0.18Y but X<0.9Y implies, Fb= 0.667 Fy – Fy . X / (2.7 Y)       - CASE (ii)
X>0.9Y implies Fb = 0.3 Fy . Y / X      - CASE (iii)
Pi =                                                                                           3.1415926535898
E = Modulus of Elasticity, as per IS 801 is taken as                                                   2074000 kgf/sqcm
Cb as per IS 801 can be taken conservatively assuming M1=0 (end span)                                     1.75
Fy =                                                                                                      3450 kg/sqcm
Hence, Fb =                                                                                    0.667Fy-Fy.X/(2.7Y)
                                                                        =                      1910.6654163439 kg/sqcm
                                                                        =                                 191.067 N/sqmm
As per clause 6.4.1 of IS 801,allowed maximum average shear stress Fv in kgf/sqcm is calculated as
Case 1: If h/t is less than 4590/sqrt(Fy), Fv=1275 x sqrt(Fy) / (h/t)                         1275 x sqrt(Fy)/(h/t) =     506.009
Case 2: If h/t is more than 4590/sqrt(Fy), Fv=5850000 / (h/t)^2                                  5850000/(h/t)^2 =        267.075
Both are subject to maximum 0.4Fy                                                                           0.4Fy =         1380
4590/sqrt(Fy) = 78.145
Hence, Case is : 2
Hence, Fv =                         5850000/(h/t)^2
                       =                  267.075 kgf/sqcm
Page 7
                                                              Z Purlin Design Report       Created by Madurai ES Consultancy Services Pvt Ltd
Hence OK
As per clause 6.4.2of IS 801 for the design check of allowable stress in combined shear and bending
Fbw = 36560000/(h/t)^2
Here, h/t already calculated above as                    148.000
Already calculated fbw = Mxx/Zxx since Zyy at web is very high (x=t/2, Z=I/x)
                       DL+LL               DL+WL1             DL+LL+WL2
Mxx/Zxx                            152.150            150.744            210.938 N/sqmm
Fbw                      166.91015339664 221.99050401753 221.99050401753
As per clause 6.4.3 of IS 801 for the design check of allowable stress in combined shear and bending
SQRT((fbw/Fbw)^2+(fv/Fv)^2) must be less than 1
In this clause, Fbw is not restricted by 0.6Fy and Fv is not restricted by 0.4Fy
Theoretical Deflection is calculated as (5/384) (wl^4/EI) for Simply Supported beam and (3/384) (wl^4/EI) for multiple spans
w is normal component of unfactored distributed load in kN/m, max. of all load combinations
                     =                                   1.656 kN/m
Page 8
                                                               Z Purlin Design Report       Created by Madurai ES Consultancy Services Pvt Ltd
Hence OK
As per MBMA, allowed deflection from Live load component must be within Span/240
Span                                       9.800 m
                         or                9800 mm
Span/240 = 40.83 mm
Hence OK
Results Summary
Stresses Ok?                                           OK
Critical Stress Factor                                 0.95
Hence, Overall: OK
Notes:
1. Section Properties Check based on Section 9 of B:5950 Part 5 is a guideline and not mandatory
2. Currently, this design only works if full width is effective. If full width is not effective,
                                               this spreadsheet will report Failure in Stress Check
3. Not suitable currently for curved roofs.
4. Design is not suitable for varying spans of purlins (varying truss spacing)
Page 9