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


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 +#


3/6


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


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 =


6/6

3

1

3

+1

1

3

hoja de cálculo en libro1 ucs

Documents