Download - Hoja de Cálculo en Libro1 Ucs
-
7/25/2019 Hoja de Clculo en Libro1 Ucs
1/6
GSI 62
sigci 100 Mpa
mi 24
mb 6.18
mb/mi 0.257395142
s 0.014666017a 0.5
E 19953
n sig3 sig1 ds1/ds3 sign tau signtau
10 0.1 14 22.5 0.7 2.9 2.1
9 0.20 17 19.9 1.0 3.5 3.4
8 0.39 20 20.9 1.3 4.1 5.3
7 0.78 26 15.1 2.3 6.1 14.2
6 1.56 35 10.9 4.4 9.2 40.2
5 3.13 49 8.0 8.2 14.3 116.9
4 6.25 70 6.0 15.3 22.2 340.2
3 12.50 101 4.5 28.6 34.2 976.9
c 3.362
tanfi 1.1267 0.84 48
UCS maci!"# 17.71 Mpa
0.0 5.0 10.0 15.0 20.0 25.0 30.0
0.0
5.0
10.0
15.0
20.0
25.0
30.0
35.0
40.0
f$# % 1.1265606407$ & 3.3618708409
'( % 0.9868580804
esfuerzo normal
esfuerzo
de
corte
-
7/25/2019 Hoja de Clculo en Libro1 Ucs
2/6
signsq
0.5
1.0
1.7
5.5
19.0
66.8
235.1
817.1
35.0
C")*mn +,in-aC")*mn +#
-
7/25/2019 Hoja de Clculo en Libro1 Ucs
3/6
-
7/25/2019 Hoja de Clculo en Libro1 Ucs
4/6
GSI 30
mi 24
sig Ci 100
a 0.5
mb 1.97
s 0.000418942
GSI 25 a %
GSI 25 s %
sig 3 sig 1 sig 1/ sig 3 sig n sig n sig
0.1 5 21.2 0.2 0.4 0.1
0.2 7 15.9 0.4 0.8 0.3
0.39 9 11.9 0.7 1.2 0.9
0.78 13 8.8 1.5 2.1 3.0
1.56 19 6.6 2.9 3.4 9.8
3.13 28 5.0 5.6 5.6 31.4
6.25 41 3.8 10.9 9.0 97.6
12.5 62 3.0 20.8 14.4 298.9
sig
0.0 5.0 10.0 15.0 20.0 25.0
0.0
2.0
4.0
6.0
8.0
10.0
12.0
14.0
16.0
f(x) = 0.6726135219x + 0.9868744494
R = 0.9849750107
Column F
esfuerzo normal
e
sfu
erzo
d
e
co
rte
1
3=1+
mbc
2(1
3)
1
3
=1+amb
a (3c)a1
-
7/25/2019 Hoja de Clculo en Libro1 Ucs
5/6
ES+UE' 'M,
.5
GSI%25 GSI25 ES+UE' E C'E
sig n s:
0.04
0.15
0.56
2.17
8.33
31.71
117.95
433.25
c 0.986 Mpa
tanfi 37;
UCS ( macizo)
1
'=
3
'+
ci(mb 3'
ci
+s)a
mb=m
iexp(GSI10028 )
s=exp(GSI1009 )a=0 .5
s=0
a=0.65GSI
200
n=3+
1
3
1 3
+1
3( )n =
-
7/25/2019 Hoja de Clculo en Libro1 Ucs
6/6
3
1
3
+1
1
3