hoja de calculo capacidad portante

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 1/9

Df= 1.5m

ϒ(kg/m3)

DONDE:

AAHH B(m)   ϕ(°) C(kg/cm2) Nc Nq Ny

0.5 24 0.3 23.36 11.40 7.08

0.8 24 0.3 23.36 11.40 7.08

1 24 0.3 23.36 11.40 7.08

0.5 25 0.2 25.14 12.72 8.34

0.8 25 0.2 25.14 12.72 8.34

1 25 0.2 25.14 12.72 8.34

0.5 24 0.2 23.36 11.40 7.08

0.8 24 0.2 23.36 11.40 7.081 24 0.2 23.36 11.40 7.08

0.5 28 0.2 31.61 17.81 13.70

0.8 28 0.2 31.61 17.81 13.70

1 28 0.2 31.61 17.81 13.70

0.5 26 0.2 27.09 14.21 9.84

0.8 26 0.2 27.09 14.21 9.84

1 26 0.2 27.09 14.21 9.84

0.5 0 5.53 5.14 1.00 0.00

0.8 0 5.53 5.14 1.00 0.00

1 0 5.53 5.14 1.00 0.00

0.5 0 6.6 5.14 1.00 0.00

0.8 0 6.6 5.14 1.00 0.00

1 0 6.6 5.14 1.00 0.00

0.5 44 151.95 147.74 261.60

0.8 44 151.95 147.74 261.60

1 44 151.95 147.74 261.60

0.5 45 172.29 173.29 325.34

0.8 45 172.29 173.29 325.34

JUAN PABLO II

MERCURIO ALTO

CERRO PACIFICO

12 DE AGOSTO

LOS OLIVOS DE PRO

ENRIQUE MILLA

LAURA CALLER

SAN MARTIN DE

PORRES

EL ALAMO

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 2/9

1 45 172.29 173.29 325.34

0.5 50 347.50 415.14 1072.80

0.8 50 347.50 415.14 1072.80

1 50 347.50 415.14 1072.80

0.5 22 0.05 20.27 9.19 5.09

0.8 22 0.05 20.27 9.19 5.09

1 22 0.05 20.27 9.19 5.090.5 22 0.05 20.27 9.19 5.09

0.8 22 0.05 20.27 9.19 5.09

1 22 0.05 20.27 9.19 5.09

0.5 22 0.05 20.27 9.19 5.09

0.8 22 0.05 20.27 9.19 5.09

1 22 0.05 20.27 9.19 5.09

0.5 22 0.05 20.27 9.19 5.09

0.8 22 0.05 20.27 9.19 5.09

1 22 0.05 20.27 9.19 5.09

CL4-17

CL4-11

CL4-13

CL4-10

19 DE MAYO

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 3/9

1kg/m3= 0.00981KN/m3

1kg/cm2= 98.1kn/m2

FS 3

Df(m)   ϒ(kg/m3) q(kg/m2) qu(kg/m2) qu(kg/cm2) qa(kg/cm2)

1.5 1640 2460.00 101032.26 10.10 3.37

1.5 1640 2460.00 102773.94 10.28 3.43

1.5 1640 2460.00 103935.06 10.39 3.46

1.5 1670 2505.00 85615.55 8.56 2.85

1.5 1670 2505.00 87704.72 8.77 2.92

1.5 1670 2505.00 89097.50 8.91 2.97

1.5 1620 2430.00 77293.83 7.73 2.58

1.5 1620 2430.00 79014.27 7.90 2.631.5 1620 2430.00 80161.23 8.02 2.67

1.5 1740 2610.00 115662.38 11.57 3.86

1.5 1740 2610.00 119238.08 11.92 3.97

1.5 1740 2610.00 121621.88 12.16 4.05

1.5 1640 2460.00 93161.00 9.32 3.11

1.5 1640 2460.00 95581.64 9.56 3.19

1.5 1640 2460.00 97195.40 9.72 3.24

1.5 2920 4380.00 288622.00 28.86 9.62

1.5 2920 4380.00 288622.00 28.86 9.62

1.5 2920 4380.00 288622.00 28.86 9.62

1.5 2920 4380.00 343620.00 34.36 11.45

1.5 2920 4380.00 343620.00 34.36 11.45

1.5 2920 4380.00 343620.00 34.36 11.45

1.5 37.62 12.54

1.5

1.5

1.5 36.81 12.27

1.5

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 4/9

1.5

1.5 47.64 15.88

1.5

1.5

1.5 1840 2760.00 37841.80 3.78 1.26

1.5 1840 2760.00 39246.64 3.92 1.31

1.5 1840 2760.00 40183.20 4.02 1.341.5 1840 2760.00 37841.80 3.78 1.26

1.5 1840 2760.00 39246.64 3.92 1.31

1.5 1840 2760.00 40183.20 4.02 1.34

1.5 1840 2760.00 37841.80 3.78 1.26

1.5 1840 2760.00 39246.64 3.92 1.31

1.5 1840 2760.00 40183.20 4.02 1.34

1.5 1840 2760.00 37841.80 3.78 1.26

1.5 1840 2760.00 39246.64 3.92 1.31

1.5 1840 2760.00 40183.20 4.02 1.34

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 5/9

fi Nc Nq

0   5.14 1.00

1   6.00 1.10

2   6.30 1.22

3   6.62 1.35

4   6.97 1.49

5   7.34 1.646   7.73 1.81

7   8.15 2.00

8   8.60 2.21

9   9.09 2.44

10   9.61 2.69

11   10.16 2.98

12   10.76 3.29

13   11.41 3.63

14   12.11 4.02

15   12.86 4.45

16   13.68 4.92

17   14.56 5.45

18   15.52 6.04

19   16.56 6.70

20   17.69 7.44

21   18.93 8.26

22   20.27 9.19

23   21.75 10.23

24   23.36 11.40

25   25.14 12.72

26   27.09 14.2127   29.24 15.90

28   31.61 17.81

29   34.24 19.98

30   37.16 22.46

31   40.41 25.28

32   44.04 28.52

33   48.09 32.23

34   52.64 36.50

35   57.75 41.44

36   63.53 47.16

37   70.07 53.80

38   77.50 61.55

39   85.97 70.61

40   95.66 81.27

41   106.81 93.85

42   119.67 108.75

43   134.58 126.50

44   151.95 147.74

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 6/9

45   172.29 173.29

46   196.22 204.19

47   224.55 241.80

48   258.28 287.85

49   298.71 344.63

50   347.50 415.14

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 7/9

Ny

0.00

0.01

0.04

0.06

0.10

0.140.20

0.27

0.35

0.44

0.56

0.69

0.85

1.04

1.26

1.52

1.82

2.18

2.59

3.07

3.64

4.31

5.09

6.00

7.08

8.34

9.8411.60

13.70

16.18

19.13

22.65

26.87

31.94

38.04

45.41

54.36

65.27

78.61

95.03

115.31

140.51

171.99

211.56

261.60

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 8/9

325.34

407.11

512.84

650.67

831.99

1072.80

7/23/2019 Hoja de Calculo Capacidad Portante

http://slidepdf.com/reader/full/hoja-de-calculo-capacidad-portante 9/9