WIND LOAD CALCULATION EXEL SHEET AS PER IS 875 PART 3

Design Wind Speed= Vz = Vb X K1 X K2 X K3 X K4 -0.70 -0.70 0.70 0.70

VZ = Vb K1 K2 K3 K4 o Degree o Degree 9oDegree 9oDegree
VZ = 44.00 1.00 1.00 1.00 1 (+CPI) C (-CPI) C (+CPI) C (-CPI) C
VZ = 44.00 M\S
0.70 -0.30 0.70 -0.30 -0.50 -0.50 -0.50
-0.5 -0.5
Design Wind Pressure= Pz=0.6 X Vz^2 A 0.5 B A B A 0.5 B A
Pz= 0.60 Vz^2
Pz= 1161.60 N/m^2 D D D D
Pz= 1.16 kn/m^2
Note: The Value of pd, However shell not be taken as less then 0.70 pz -0.70 -0.70 -0.10 -0.10
0.70Pz= 0.81 kn/m^2 13.94 2.32 2.32 13.94
1.2 0.2 0.2 1.2
design wind pressure = Kd X Ka X Kc X Pz
Pd = Kd Ka Kc Pz Left To Left To Top To Top To
Pd = 0.90 0.90 0.90 1.16 Right Right Bottom Bottom
Pd = 0.85 Kn/m^2 0.2 0.8 1.2 -0.2 1.0 0.5 0.0
W1 W3 W5 W7
0.83 3.31 4.96 -0.83 4.13 2.07 0.00
Wind Load on Individual Members= F=(Cpe - Cpi) X A X Pd
pp 90 Degree (A) 0 Degree (A) Pd
13.72 4.88 0.85
1.2 0.2 0.6 0.4
IS -875 Part-3 13.94 2.32 6.97 4.65
Cpe (External pressure coefficient)
A B C D 13.94 2.32 6.97 4.65
Cpe (0) Degree 0.70 -0.30 -0.70 -0.70 1.20 0.20 0.6 0.4
Cpe (90) Degree -0.50 -0.50 0.70 -0.10
Right To ) Right To Bottom Bottom
Cpi (internal pressure coefficient) Left Left To Top To Top
Plus Cpi 0.5 Cpi for 5 TO 20% Opening 0.8 0.20 -0.2 1.2 1.0 0.5 0.0
W2 W4 W6 W8
Minus Cpi -0.5 IS:875 PART-3 (2015) CL-7.3.2 3.31 0.83 -0.83 4.96 4.13 2.07 0.00

Input Cell
Output Cell
1.2 0.2 0.20 1.20
13.94 2.32 2.32 13.94
)
)7

1142

1124::1
-0.50
B

0.0
0.00

0.0
0.00
 WIND LOAD CALCULATION EXEL SHEET AS PER IS 875 PART 3
Design Wind Speed= Vz = Vb X K1 X K2 X K3 X K4 -0.80
VZ = Vb K1 K2 K3 K4 o Degree o Degree (- 9oDegree(+ 9oDegree (-
VZ = 44.00 1.00 1.00 1.00 1 (+CPI) CPI) CPI) EG CPI)
VZ = 44.00 M\S
-0.90 -0.40 -0.90 -0.40
-0.5
Design Wind Pressure= Pz=0.6 X Vz^2 EF 0.5 GH EF GH 0.5
Pz= 0.60 Vz^2
Pz= 1161.60 N/m^2 FH
Pz= 1.16 kn/m^2
Note: The Value of pd, However shell not be taken as less then 0.70 pz -0.40
0.70Pz= 0.81 kn/m^2 7.80
1.3
design wind pressure = Kd X Ka X Kc X Pz
Pd = Kd Ka Kc Pz Left To Left To Top To Top To
Pd = 0.90 0.90 0.90 1.16 Right Right Bottom Bottom
Pd = 0.85 Kn/m^2 1.4 0.9 0.4 -0.1 W5
W1 W3
8.40 5.40 2.40 -0.60
Wind Load on Individual Members= F=(Cpe - Cpi) X A X Pd
COLUMN TO COLUMN SPAN Pd
5.00 1.20
0.9
IS -875 Part-3 5.40
Cpe (External pressure coefficient)
EF GH EG FH 5.40
Cpe (0) Degree -0.90 -0.40 0.9
Cpe (90) Degree -0.80 -0.40
Right To Right To Bottom To Bottom To
Cpi (internal pressure coefficient) Left Left Top Top
Plus Cpi 0.5 Cpi for 5 TO 20% Opening 0.9 1.40 -0.1 0.4 W6
W2 W4
Minus Cpi -0.5 IS:875 PART-3 (2015) CL-7.3.2 5.40 8.40 -0.60 2.40

Input Cell
Output Cell
1.30
7.80
 -0.80

EG

-0.5

FH

-0.40
1.80
0.3

W7

-0.1
-0.60

-0.60
-0.1

W8

0.30
1.80