CALCULO DE DIAGRAMA DE MASAS.xls

1.3

CALCULO DEL DIAGRAMA DE MASAS PROGRESIVA

S.D (M)

AREAS (M2) CORTE RELLENO

3.00

0+000

4.00

10.00

4.00

0+020

.00

8.00

6.00

6.00

07.50 0+055 02.50 0+060

7.00

.00

8.00

0.00

10.00 0+080 10.00

7.00

0+100

.00

0+110

4.00 0.00 0.00 0.00

8.00

0.00

6.00

10.00 0+200 10.00 0+220

2.00

3.00

6.00

0.00

10.00 0+240 10.00

8.00

0+260

10.00 .00 1.00 1.00 3.00

7.00

4.67

8.8

10.00 0+360 10.00 0+380

8.00

0.00

12.00

0.3

10.00 0+400 10.00 0+420

10.00

1.32

.00

3.70

10.00 0+440 10.00

3.12

0+460

2.00 9.41 3.0 8.00 10.00

4.79

8.00

2.71

10.00

0.00

6.00

10.00

00.00

00.00

60.00

00.00

00.00

4.00

0.00

06.0

40.00

0.00

6.00

00.00

100.00

130.00

00.00

140.00

182.00

-124.2 2.7 8.7 124.2 99.2 -30.7 -212.7 00.00

140.00

182.00

20.00

90.00

117.00

-394.7 -491.7 80.00

30.00

39.00

140.00

00.00

00.00

90.00

00.00

00.00

7.00

10.00

13.00

60.00

60.00

78.00

20.00

80.00

104.00

40.00

110.00

143.00

-40.7 -310.7 -220.7 -18.7 -176.7 -260.7 -363.7 76.70

1.80

202.4

126.70

8.80

111.4

-489.9 -474.43 200.00

0.30

06.89

220.00

18.0

24.0

-281.32 -8.37 10.00

0.20

6.26

81.20

77.00

100.10

1.20

69.60

90.48

114.10

79.60

103.48

124.60

160.80

209.04

110.0

111.40

144.82

180.00

48.0

63.0

-00.63 -19.3 -8.81 -48.19 -132.63 -166.9 -0.00 180.00

10.00 0+580

-209.2

0.06

10.00 0+560

-206.00

11.08

10.00 0+540

3.7

.00

10.00 0+520

27.0

2.96

10.00 0+500

32.0

4.00

10.00 0+480

136.0

4.00

10.00 0+340

10.00

4.00

10.00 0+320

82.0

2.00

10.00 0+300

-12.00

0.00

05.00 0+280

-60.00

0.00

05.00 0+270

182.00

6.00

10.00 0+180

140.00

4.00

10.00 0+160

90.00

1.00

10.00 0+140

130.00

0.00

05.00 0+120

100.00

0.00

05.00

ORDENADA

00.00 70.00

6.00

10.00 0+040

VOLUMENES (M3) RELLENO R. ABUNDADO

CORTE

7.00 -

97.0 -

32.0

D/2

VOLUMEN Corte 

Coef. Variab. Terraplén !"#

corte

volumétrica terraplén

10

95.7

105

1.35

0.95

10

200.9

215

1.35

0.95

10

214.5

235

1.35

0.95

10

234.3

240

1.35

0.95

10

248

211

1.35

0.95

10

233

185.1

1.35

0.95

10

211

169.7

1.35

0.95

10

200

140.7

1.35

0.95

10

177

131.6

1.35

0.95

10

138

123.7

1.35

0.95

10

245.3

52.2

1.35

0.95

Vol. Increm. corte

$uma al%ebraica o re&uci&o' terraplén

Total corte

Terra plen

()* Corte

129.2

99.75

129.2

99.75

29.45

271.22

204.25

271.22

204.25

66.97

289.58

223.25

289.58

223.25

66.33

316.31

228

316.31

228

88.31

334.8

200.45

334.8

200.45

134.35

314.55

175.85

314.55

175.85

138.7

284.85

161.22

284.85

161.22

123.63

270

133.67

270

133.67

136.33

238.95

125.02

238.95

125.02

113.93

186.3

117.52

186.3

117.52

68.78

331.16

49.59

331.16

49.59

281.57

TOT+L C TOT+L TE

Or&ena&a (4* Terraplén

curva ma'a OCM

0

3029.45

0

3066.97

0

3066.33

0

3088.31

0

3134.35

0

3138.7

0

3123.63

0

3136.33

0

3113.93

0

3068.78

0

3281.57

,TE - 2.01 mt'0 ,,+3LEN - "." mt'0