Gantry Girder Excel
Gantry Girder Excel
Gantry Girder Excel
1) This spreadsheet is developed using Steel Designer's Manual & IS 800.It contains three
sheets namely Instructions,Section Properties & Girder Design.
2) To commence with design of gantry girder, user is required to input details of gantry like
Capacity, c/c span of crane, Span of gantry girder,Maximum Wheel load, Wheel base
Self wt. of crane, wt. of crab and self wt. of rail.
3) After basic calculations of loads and moments based on above values user has to select
size of gantry girder.User can choose Beam+Channel or Beam+Channel+Plate.If bottom
plate is not provided same can be deleted from sketch.
Legend :
Indicates Input required from user.
DATE :
DATE :
5.000
Lifting Capacity of Crane : T
11.100
c/c Span of crane : m
Span of Gantry Girder :6.700 m
Wheel base :1.900 m
Maximum wheel load : 3.120 T (without impact)
35
Impact Factor (Vertical load) : %
Maximum wheel load : 4.212 T (with 35% Impact for vertical load)
4.212 4.212
2.875 1.900
6.700
= =
My = 0.53 T-m
Properties of section
ISMB 400 Bottom Plate
Properties ISMB 400 ISMC 200
Details
Wt per m 61.5 Kg 22.3 Kg 0.00 Kg
Area 78.4 cm2 28.5 cm2 0 cm2
Depth 40 cm 20 cm 0 cm
Width of flange 14 cm 7.5 cm 0 cm
Thk of flange 1.6 cm 1.14 cm
Thk of web 0.89 cm 0.62 cm
Cyy - 2.12 cm
Ixx 20500 cm4 1830 cm4
Iyy 5231 cm4 141 cm4
15.69 = yt ( in cm)
24.93 = yb ( in cm )
y= 24.93 cm
To calculate K 1
To calculaate K 2
Iy of compressor flange
w=
Iy of whole flange
= 0.63
K2= 0.35 ---------From IS 800 Table 6.4
ryy = 81.27 mm
fcb = 1235.01
X = Y x [ 1 + 1/20 x (l x T / ry D) ]
2 1/2
= 640.62 Mpa
26.5 x 105
Y=
(l / ryy )2
Y = 389.92 Mpa
sbc = 153.46 Mpa --------- As per clause no. 6.2.3 of IS 800 (Ref. Table 6.2)
DATE :
DATE :
= 12.00 Mpa
Only top flange is effective in resisting lateral loads. The top flange is assumed
to consists of channel of upper half section of I section.
When lateral longitudinal loads are combined allowable stresses can be
increased by 10%
dmax = P x L3 3xa a 3
dmax = 6.27 mm
= 8.93 mm
Sectional Overall Flange Web Flange
Sr. No. NAME Mass 'M' Area 'a' Depth 'D' Width 'B' Thickness Thickness Ixx
Kg/m cm2 cm cm 't' cm 'T' cm cm4
ISMB
1 ISMB 100 8.9 11.4 10 5 0.47 0.7 183
2 ISMB 125 13.3 17 12.5 7 0.5 0.8 445
3 ISMB 150 15 19.1 15 7.5 0.5 0.8 718
4 ISMB 175 19.6 25 17.5 8.5 0.58 0.9 1260
5 ISMB 200 24.2 30.8 20 10 0.57 1 2120
6 ISMB 225 31.1 39.7 22.5 11 0.65 1.18 3440
6 ISMB 250 37.3 47.5 25 12.5 0.69 1.25 5130
7 ISMB 300 46 58.6 30 14 0.77 1.31 8990
8 ISMB 350 52.4 66.7 35 14 0.81 1.42 13600
9 ISMB 400 61.5 78.4 40 14 0.89 1.6 20500
10 ISMB 450 72.4 92.2 45 15 0.94 1.74 30400
11 ISMB 500 86.9 111 50 18 1.02 1.72 45200
12 ISMB 550 104 132 55 19 1.12 1.93 64900
13 ISMB 600 123 156 60 21 1.2 2.03 91800
1 PG 700x250 161.4 205.6 70.0 25.0 1.6 2.0 153966
2 PG 750x300 205.7 262.0 75.0 30.0 1.6 2.5 242921
3 PG 800x300 212.0 270.0 80.0 30.0 1.6 2.5 281563
4 PG 850x300 188.4 240.0 95.0 30.0 1.0 2.5 381688
5 PG 900x300 224.5 286.0 90.0 30.0 1.6 2.5 369071
6 PG 1000x300 237.1 302.0 100.0 30.0 1.6 2.5 470879
7 PG 1050x300 243.4 310.0 105.0 30.0 1.6 2.5 527396
8 PG 1100x300 249.6 318.0 110.0 30.0 1.6 2.5 587788
9 PG 1150x300 255.9 326.0 115.0 30.0 1.6 2.5 652154
10 PG 1200 262.2 334.0 120.0 30.0 1.6 2.5 720596
ISMC
1 ISMC 100 9.56 12.2 10 5 0.5 0.77 192
2 ISMC 125 13.1 16.7 12.5 6.5 0.53 0.82 425
3 ISMC 150 16.8 21.3 15 7.5 0.57 0.9 788
4 ISMC 200 22.3 28.5 20 7.5 0.62 1.14 1830
5 ISMC 225 26.1 33.3 22.5 8 0.65 1.24 2710
6 ISMC 250 30.6 39 25 8 0.72 1.41 3880
7 ISMC 300 36.3 46.3 30 9 0.78 1.36 6420
8 ISMC 350 42.7 54.4 35 10 0.83 1.35 10000
9 ISMC 400 50.1 63.8 40 10 0.88 1.53 15200
Iyy rxx ryy Zxx Zyy Cyy
cm4 cm cm cm3 cm3 cm
LD t4
Yt
t1
D
Yb
t3
A A
B1
1 PG 700x250 25 66 25 1.6 2 2 0
2 PG 750x300 30 70 30 1.6 2.5 2.5 0
3 PG 800x300 30 75 30 1.6 2.5 2.5 0
4 PG 850x300 30 90 30 1.0 2.5 2.5 0
5 PG 900x300 30 85 30 1.6 2.5 2.5 0
6 PG 1000x300 30 95 30 1.6 2.5 2.5 0
7 PG 1050x300 30 100 30 1.6 2.5 2.5 0
8 PG 1100x300 30 105 30 1.6 2.5 2.5 0
9 PG 1150x300 30 110 30 1.6 2.5 2.5 0
10 PG 1200 30 115 30 1.6 2.5 2.5 0
LD (mm) Ax (cm2) Yb (cm) Yt (cm) Ixx (cm4) Iyy (cm4) rxx (cm) ryy (cm) Zxx Zyy
161.40 70
205.67 75
211.95 80
188.40 95
224.51 90
237.07 100
243.35 105
249.63 110
255.91 115
262.19 120