purlin design.xlsx

	A	B	C	D	E	F	G	H
1
2	PURLIN DESIGN
3
4	Wind Load
5	Basic Wind Speed	50	m/s
6	Design Wind Press	165	Kg/m2
7
8	Maximum -ve Thrust	-1.3
9
10	Purlin Design
11	Purlin Spacing	0.3	m		spacing			purlin wt
12	Dead Load of Roofing	65	Kg/m2		0.45	29.25	kg/m	0.9
13	Live Load on Roofing (75-(17x2))	50	Kg/m2		0.45	22.5	kg/m
14	Max wind Press (upward)	-215	Kg/m2		0.45	-96.525	kg/m
15
16	Span of Purlin	0.45	m
17
18	Adopt section	ISA 25 X 25 X5
19	Wt	1.8	Kg/m
20	Ixx	1.2	cm4
21	Zxx	0.7	cm3
22
23
24	Load/m on Purlin
25	Case	1	DL + WL (up)
26		Roof DL + Purlin Wt - WL(up)
27		19.5	1.8	-64.35
28		-43.05	Kg/m
29
30	Case	2	DL + LL
31		Roof DL + Purlin Wt + LL
32		19.5	1.8	15
33		36.3	Kg/m
34
35
36	Maximum Load /m	43.05	Kg/m
37
38
39	Bending Moment	WL^2/10
40		0.8717625	Kg/m
41	Zxx required	0.06	Cm3	<	0.7	Cm3
42		Safe
43
44	Check for deflection for DL & LL
45
46	Allowable Deflection	L/325
47		2	mm
48
49	Actual Deflection	5/384 * wl^4/EI
50		1	mm
51		Safe
52
53	Load on Truss from Purlin			KG/M
54	Live Load	6.75	KG	22.5
55	Dead Load	9.585	KG	31.95
56	Wind Load - Uplift	-28.9575	KG	-96.525
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100