Slope Stability Excel Spread Sheet Example

Example 11.
3
Bishop's simplified method
Homogenous soil
su
30
kPa
'
w
33
9.8
deg.
kN/m3
sat
18
kN/m3
zcr
3.33
m
zs
4 m
FS
1.06 assumed
No tension crack
Slice
1
2
3
4
5
6
7
8
9
b
m
4.9
2.5
2
2
2
2
2
2.5
1.6
z
m
1
3.6
4.6
5.6
6.5
6.9
6.8
5.3
1.6
Tension crack
FS
1 assumed
Slice
b
z
m
m
1
4.9
1
2
2.5
3.6
3
2
4.6
4
2
5.6
5
2
6.5
6
2
6.9
7
2
6.8
8
2.5
5.3
9
1.6
1.6
zw
W=bz
kN
88.2
162.0
165.6
201.6
234.0
248.4
244.8
238.5
46.1
W=bz
kN
88.2
162.0
165.6
201.6
234.0
248.4
244.8
238.5
46.1
Tension crack filled with water

R
14.3 m
TCM/R
23.7 kN
FS
0.95 assumed
Slice
b
z
W=bz
m
m
kN
1
4.9
1
88.2
2
2.5
3.6
162.0
zw
ru
m
1
3.6
4.6
5
5.5
5.3
4.5
2.9
0.1
0.54
0.54
0.54
0.49
0.46
0.42
0.36
0.30
0.03
zw
ru
m
1
3.6
4.6
5
5.5
5.3
4.5
2.9
0.1
0.54
0.54
0.54
0.49
0.46
0.42
0.36
0.30
0.03
zw
ru
m
1
3.6
0.54
0.54
deg
-23
-10
0
9
17
29
39.5
49.5
65
deg
-23
-10
0
9
17
29
39.5
49.5
65
deg
-23
-10
mj
Wsin
ESA
W (1 - ru)tan' mj
1.47
1.14
1.00
0.92
0.88
0.85
0.86
0.90
1.02
Sum
-34.5
-28.1
0.0
31.5
68.4
120.4
155.7
181.4
41.8
536.6
FS
38.3
54.6
49.0
62.1
72.2
80.1
87.6
97.5
29.6
570.9
1.06
mj
Wsin
ESA
W (1 - ru)tan' mj
1.50
1.15
1.00
0.92
0.87
0.84
0.84
0.87
0.99
Sum
-34.5
-28.1
0.0
31.5
68.4
120.4
155.7
181.4
41.8
536.6
FS
39.1
55.0
49.0
61.8
71.5
78.9
85.8
95.1
0.0
536.2
1.00
mj
Wsin
ESA
W (1 - ru)tan' mj
1.53
1.15
-34.5
-28.1
39.9
55.3
TSA
su b/cos
159.7
76.2
60.0
60.7
62.7
68.6
77.8
115.5
113.6
794.8
1.48
TSA
su b/cos
159.7
76.2
60.0
60.7
62.7
68.6
77.8
115.5
0.0
681.2
1.27
TSA
su b/cos
159.7
76.2
3
4
5
6
7
8
9
2
2
2
2
2
2.5
1.6
4.6
5.6
6.5
6.9
6.8
5.3
1.6
165.6
201.6
234.0
248.4
244.8
238.5
46.1
4.6
5
5.5
5.3
4.5
2.9
0.1
0.54
0.49
0.46
0.42
0.36
0.30
0.03
0
9
17
29
39.5
49.5
65
1.00
0.91
0.86
0.83
0.83
0.86
0.96
Sum
0.0
31.5
68.4
120.4
155.7
181.4
41.8
536.6
FS
49.0
61.5
70.9
77.8
84.3
93.0
0.0
531.7
0.95
60.0
60.7
62.7
68.6
77.8
115.5
0.0
681.2
1.22
Example 13.4
Three soil layers
Soil 1 Soil 2 Soil 3
su
30
58
42
29
33
25
'
w
9.8
kPa
deg.
kN/m3
sat
FS
18 17.5 17
1.01assumed
kN/m3
Slice
z1
z2
z3
m
1
2.3
2.4
2
0.9
0.8
0
0
0
m
0
1.3
2.2
3.6
4.1
4.1
3.7
1.5
0
m
0
0
0
0
1.5
2
3.1
3.8
1.6
1
2
3
4
5
6
7
8
9
b
m
4.9
2.5
2
2
2
2
2
2.5
1.6
HELP
R
b
z
zw
W=bz
kN
88.2
160.4
163.4
198.0
226.9
240.3
234.9
227.1
43.5
zw
ru
m
1
3.6
4.6
5
5.5
5.3
4.5
2.9
0.1
0.54
0.55
0.55
0.49
0.48
0.43
0.38
0.31
0.04
deg
-23
-10
0
9
17
29
39.5
49.5
65
mj
Wsin
1.49
1.15
1.00
0.92
0.87
0.84
0.89
0.94
1.19
Sum
-34.5
-27.8
0.0
31.0
66.3
116.5
149.4
172.7
39.4
513.1
FS
TSA
ESA
W(1 - ru)tan' mj su b/cos
39.0
53.7
47.6
59.7
67.6
74.7
72.6
81.1
23.3
519.1
1.01
159.7
76.2
60.0
60.7
62.7
68.6
108.9
161.7
219.6
978.1
1.91
Example 13.5
Janbu's method
HELP
Soil 1 Soil 2
29 33.5 deg.
'
w
9.8
kN/m3
sat
18
17 kN/m3
d
4.5
m
l
11.5
fo
d/l
0.39
1.06
FS
1.04assumed
z1
z2
Slice
b
m
m
m
1
2
1
0.7
2
3.5
2
2.5
3
2
1
4.3
4
2.9
0
2.5
W=bz
kN
59.8
274.8
182.2
123.3
zw
deg
-45
0
45
59.9
mj
Wtan
Wtan' cos mj
3.03
1.00
0.92
0.95
Sum
-59.8
0.0
182.2
212.6
335.0
FS
71.0
152.3
65.9
38.9
328.0
1.04
Example 11.3
Bishop's simplified method
Homogenous soil
su
30
kPa
'
w
33
9.8
deg.
kN/m3
sat
18
kN/m3
zcr
3.33
m
zs
4 m
FS
1.06 assumed
No tension crack
Slice
1
2
3
4
5
6
7
8
9
b
m
4.9
2.5
2
2
2
2
2
2.5
1.6
z
m
1
3.6
4.6
5.6
6.5
6.9
6.8
5.3
1.6
Tension crack
FS
1 assumed
Slice
b
z
m
m
1
4.9
1
2
2.5
3.6
3
2
4.6
4
2
5.6
5
2
6.5
6
2
6.9
7
2
6.8
8
2.5
5.3
9
1.6
1.6
zw
W=bz
kN
88.2
162.0
165.6
201.6
234.0
248.4
244.8
238.5
46.1
W=bz
kN
88.2
162.0
165.6
201.6
234.0
248.4
244.8
238.5
46.1
Tension crack filled with water

R
14.3 m
TCM/R
23.7 kN
FS
0.95 assumed
Slice
b
z
W=bz
m
m
kN
1
4.9
1
88.2
2
2.5
3.6
162.0
zw
ru
m
1
3.6
4.6
5
5.5
5.3
4.5
2.9
0.1
0.54
0.54
0.54
0.49
0.46
0.42
0.36
0.30
0.03
zw
ru
m
1
3.6
4.6
5
5.5
5.3
4.5
2.9
0.1
0.54
0.54
0.54
0.49
0.46
0.42
0.36
0.30
0.03
zw
ru
m
1
3.6
0.54
0.54
deg
-23
-10
0
9
17
29
39.5
49.5
65
deg
-23
-10
0
9
17
29
39.5
49.5
65
deg
-23
-10
mj
Wsin
ESA
W (1 - ru)tan' mj
1.47
1.14
1.00
0.92
0.88
0.85
0.86
0.90
1.02
Sum
-34.5
-28.1
0.0
31.5
68.4
120.4
155.7
181.4
41.8
536.6
FS
38.3
54.6
49.0
62.1
72.2
80.1
87.6
97.5
29.6
570.9
1.06
mj
Wsin
ESA
W (1 - ru)tan' mj
1.50
1.15
1.00
0.92
0.87
0.84
0.84
0.87
0.99
Sum
-34.5
-28.1
0.0
31.5
68.4
120.4
155.7
181.4
41.8
536.6
FS
39.1
55.0
49.0
61.8
71.5
78.9
85.8
95.1
0.0
536.2
1.00
mj
Wsin
ESA
W (1 - ru)tan' mj
1.53
1.15
-34.5
-28.1
39.9
55.3
TSA
su b/cos
159.7
76.2
60.0
60.7
62.7
68.6
77.8
115.5
113.6
794.8
1.48
TSA
su b/cos
159.7
76.2
60.0
60.7
62.7
68.6
77.8
115.5
0.0
681.2
1.27
TSA
su b/cos
159.7
76.2
3
4
5
6
7
8
9
2
2
2
2
2
2.5
1.6
4.6
5.6
6.5
6.9
6.8
5.3
1.6
165.6
201.6
234.0
248.4
244.8
238.5
46.1
4.6
5
5.5
5.3
4.5
2.9
0.1
0.54
0.49
0.46
0.42
0.36
0.30
0.03
0
9
17
29
39.5
49.5
65
1.00
0.91
0.86
0.83
0.83
0.86
0.96
Sum
0.0
31.5
68.4
120.4
155.7
181.4
41.8
536.6
FS
49.0
61.5
70.9
77.8
84.3
93.0
0.0
531.7
0.95
60.0
60.7
62.7
68.6
77.8
115.5
0.0
681.2
1.22
Example 13.4
Three soil layers
Soil 1 Soil 2 Soil 3
su
30
58
42
29
33
25
'
w
9.8
kPa
deg.
kN/m3
sat
FS
18 17.5 17
1.01assumed
kN/m3
Slice
z1
z2
z3
m
1
2.3
2.4
2
0.9
0.8
0
0
0
m
0
1.3
2.2
3.6
4.1
4.1
3.7
1.5
0
m
0
0
0
0
1.5
2
3.1
3.8
1.6
1
2
3
4
5
6
7
8
9
b
m
4.9
2.5
2
2
2
2
2
2.5
1.6
HELP
R
b
z
zw
W=bz
kN
88.2
160.4
163.4
198.0
226.9
240.3
234.9
227.1
43.5
zw
ru
m
1
3.6
4.6
5
5.5
5.3
4.5
2.9
0.1
0.54
0.55
0.55
0.49
0.48
0.43
0.38
0.31
0.04
deg
-23
-10
0
9
17
29
39.5
49.5
65
mj
Wsin
1.49
1.15
1.00
0.92
0.87
0.84
0.89
0.94
1.19
Sum
-34.5
-27.8
0.0
31.0
66.3
116.5
149.4
172.7
39.4
513.1
FS
TSA
ESA
W(1 - ru)tan' mj su b/cos
39.0
53.7
47.6
59.7
67.6
74.7
72.6
81.1
23.3
519.1
1.01
159.7
76.2
60.0
60.7
62.7
68.6
108.9
161.7
219.6
978.1
1.91
Example 13.5
Janbu's method
HELP
Soil 1 Soil 2
29 33.5 deg.
'
w
9.8
kN/m3
sat
18
17 kN/m3
d
4.5
m
l
11.5
fo
d/l
0.39
1.06
FS
1.04assumed
z1
z2
Slice
b
m
m
m
1
2
1
0.7
2
3.5
2
2.5
3
2
1
4.3
4
2.9
0
2.5
W=bz
kN
59.8
274.8
182.2
123.3
zw
deg
-45
0
45
59.9
mj
Wtan
Wtan' cos mj
3.03
1.00
0.92
0.95
Sum
-59.8
0.0
182.2
212.6
335.0
FS
71.0
152.3
65.9
38.9
328.0
1.04

Slope Stability Excel Spread Sheet Example

Uploaded by

Copyright:

Available Formats

Slope Stability Excel Spread Sheet Example

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Slope Stability Excel Spread Sheet Example

Uploaded by

Copyright:

Available Formats

Example 11.

Tension crack filled with water

Tension crack filled with water

You might also like