Excel program to design a wall footing using the code provisions of NSCP 2010Full description
Design of RCC Retaining WallFull description
desin of firewallFull description
Design of shear wall as per ACi method
Full description
Design of shear walls
Excel formula for designing retaining wall. soil engineering.
Retaining Wall Design
Structural Design Calculation of a Dike Wall (Retaining Wall) ACI 318-11
Concrete Slender Wall DesignFull description
Disfor() Example: x= y= z=
0.5 12 23
a= #NAME? = 13.42
Formul in B7 is =disfor(B8)
b = #NAME? = 309.5
Formul in B10 is =disfor(B11)
c = #NAME? = #NAME? = 322.9
Formul in B13 is =disfor(B8)&" + "&disfor(B11) Formul in B14 is =disfor(B15)
Design of Gabion wall Given Data(Refer to cross section) Wall Height Angle of friction for backfill Surcharge Width of the base Backfill slope angle Backface slope angle Soil friction factor Soil density Gabion fill density Soil bearing capacity Angle of wall friction
H φ q B α β µ ws wg pb δ
= = = = = = = = = = =
7 30 15.000 4.5 0 -6 0.7 22 16 407 0
ka=
0.295
m deg KN/m2 m deg deg 3
KN/m 3 KN/m 2 KN/m deg
Determine if Safety factors are within limits: Pressure coefficient, ka
Active earth force, Pa Pa=
189.980 KN/m
Ph=
188.940 KN/m
da=
2.054 m
Horizontal component, Ph
Vertical distance to Ph,da
Overturning Moment check Mo=
388.083 KNm per m
Wg=
384.000 KN/m
dg=
2.667 m
Weight of gabions for a 1-meter unit length,Wg is
Horizontal distance to Wg is dg= ∑Ax/∑A
Resisting Moment,Mr Mr=
1024.128 KNm per m
Saftey Factor against overturning SFo=Mr/Mo
SFo=
2.639
SFo=Mr/Mo > 2
OK
Safety factor against sliding SFs=µWg/Ph
SFs=
1.423 SFs > 1.4 OK
Reaction eccentricity,e e=
0.594 m
For the resultant force to lie in the middle third : -B/6<=e<=B/6
OK
Max. base pressure,P P=(Wg/B)(1+6e/B) Pb=soil Bearing pressure
P=
2 152.876 KN/m
P<=Pb
OK
All saftey factors are within limits.Stability checks at intermediate levels in the walls show similar results.
surcharge
= 15.000 KN/m2
Total area of Gabion wall
=
24.000 m2
Unt Wght of Gabion fill
=
16.000 KN/m3
Total Weight of Gabion wall (Wg)= dg=∑Ax/∑A =
2666.667 mm
384.000 KN/m 2.667 m
2000 1000 500 2000
1000 500
2500
1000
7000
500 3000
1000 500 3500
1000
. 500 4000 2000
4500
Disfor() Example: x= y= z=
0.5 12 23
a= #NAME? = 13.42
Formul in B7 is =disfor(B8)
b = #NAME? = 309.5
Formul in B10 is =disfor(B11)
c = #NAME? = #NAME? = 322.9
Formul in B13 is =disfor(B8)&" + "&disfor(B11) Formul in B14 is =disfor(B15)
