Diagrama de Masa I KM

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

CÁLCULO DE DIAGRAMA DE MASA

COTA ALTURAS AREAS A1 + A2 VOLUMEN VOLUMEN ABUNDADO SUMA ALGEBRAICA


PROGRESIVA d/2 ESP. ORDENADA
Terreno Subrasante Corte Relleno Corte Relleno Corte Relleno Corte Relleno Corte (+) Relleno (-) CORTE - RELLENO
0+000.000 3653.75 3653.75 0.00 0.00 0.070 0.040 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0+010.000 3656.64 3654.85 1.79 -1.79 2.440 0.040 2.51 0.08 5.00 12.55 0.40 1.20 15.06 -0.48 14.58 14.58
0+020.000 3659.48 3655.95 3.53 -3.53 18.830 0.000 21.27 0.04 5.00 106.35 0.20 1.20 127.62 -0.24 127.38 141.96
0+030.000 3663.32 3657.04 6.28 -6.28 19.810 0.000 38.64 0.00 5.00 193.20 0.00 1.20 231.84 0.00 231.84 373.80
0+040.000 3668.73 3658.14 10.59 -10.59 14.290 0.000 34.10 0.00 5.00 170.50 0.00 1.20 204.60 0.00 204.60 578.40
0+060.000 3671.69 3659.23 12.46 -12.46 0.000 7.610 14.29 7.61 10.00 142.90 76.10 1.20 171.48 -91.32 80.16 658.56
0+080.000 3671.44 3660.33 11.11 -11.11 14.680 0.000 14.68 7.61 10.00 146.80 76.10 1.20 176.16 -91.32 84.84 743.40
0+090.000 3671.40 3662.52 8.88 -8.88 24.870 0.000 39.55 0.00 5.00 197.75 0.00 1.20 237.30 0.00 237.30 980.70
0+100.000 3671.91 3664.71 7.20 -7.20 20.440 0.000 45.31 0.00 5.00 226.55 0.00 1.20 271.86 0.00 271.86 1252.56
0+120.000 3672.57 3665.81 6.76 -6.76 7.080 0.000 27.52 0.00 10.00 275.20 0.00 1.20 330.24 0.00 330.24 1582.80
0+140.000 3673.73 3666.90 6.83 -6.83 3.320 1.640 10.40 1.64 10.00 104.00 16.40 1.20 124.80 -19.68 105.12 1687.92
0+160.000 3675.38 3668.00 7.38 -7.38 3.750 1.490 7.07 3.13 10.00 70.70 31.30 1.20 84.84 -37.56 47.28 1735.20
0+180.000 3676.96 3669.10 7.86 -7.86 9.250 0.070 13.00 1.56 10.00 130.00 15.60 1.20 156.00 -18.72 137.28 1872.48
0+200.000 3679.78 3670.19 9.59 -9.59 2.060 2.600 11.31 2.67 10.00 113.10 26.70 1.20 135.72 -32.04 103.68 1976.16
0+220.000 3684.33 3671.29 13.04 -13.04 4.430 0.240 6.49 2.84 10.00 64.90 28.40 1.20 77.88 -34.08 43.80 2019.96
0+240.000 3687.97 3672.38 15.59 -15.59 0.230 6.580 4.66 6.82 10.00 46.60 68.20 1.20 55.92 -81.84 -25.92 1994.04
0+260.000 3690.17 3673.48 16.69 -16.69 3.570 2.660 3.80 9.24 10.00 38.00 92.40 1.20 45.60 -110.88 -65.28 1928.76
0+270.000 3690.59 3675.67 14.92 -14.92 12.440 0.400 16.01 3.06 5.00 80.05 15.30 1.20 96.06 -18.36 77.70 2006.46
0+280.000 3690.79 3677.86 12.93 -12.93 14.500 0.000 26.94 0.40 5.00 134.70 2.00 1.20 161.64 -2.40 159.24 2165.70
0+290.000 3686.62 3680.05 6.57 -6.57 11.970 0.040 26.47 0.04 5.00 132.35 0.20 1.20 158.82 -0.24 158.58 2324.28
0+300.000 3682.11 3681.15 0.96 -0.96 13.510 0.000 25.48 0.04 5.00 127.40 0.20 1.20 152.88 -0.24 152.64 2476.92
0+310.000 3683.83 3683.34 0.49 -0.49 13.760 0.000 27.27 0.00 5.00 136.35 0.00 1.20 163.62 0.00 163.62 2313.30
0+320.000 3683.83 3683.34 0.49 -1.47 17.270 0.170 31.03 0.17 5.00 155.15 0.85 1.20 186.18 -1.02 185.16 2128.14
0+340.000 3685.89 3684.42 1.47 -2.45 4.820 0.950 22.09 1.12 10.00 220.90 11.20 1.20 265.08 -13.44 251.64 1876.50
0+360.000 3687.94 3685.49 2.45 -5.06 1.860 0.740 6.68 1.69 10.00 66.80 16.90 1.20 80.16 -20.28 59.88 1816.62
0+380.000 3691.61 3686.55 5.06 -8.74 1.890 0.000 3.75 0.74 10.00 37.50 7.40 1.20 45.00 -8.88 36.12 1852.74
0+390.000 3696.35 3687.61 8.74 -12.20 1.720 1.050 3.61 1.05 5.00 18.05 5.25 1.20 21.66 -6.30 15.36 1868.10
0+400.000 3700.85 3688.65 12.20 -15.73 10.890 0.000 12.61 1.05 5.00 63.05 5.25 1.20 75.66 -6.30 69.36 1937.46
0+410.000 3706.44 3690.71 15.73 -14.73 10.330 0.000 21.22 0.00 5.00 106.10 0.00 1.20 127.32 0.00 127.32 2064.78
0+420.000 3707.46 3692.73 14.73 -13.35 7.800 0.000 18.13 0.00 5.00 90.65 0.00 1.20 108.78 0.00 108.78 2173.56
0+430.000 3707.07 3693.72 13.35 -12.27 12.880 0.000 20.68 0.00 5.00 103.40 0.00 1.20 124.08 0.00 124.08 2297.64
0+440.000 3706.98 3694.71 12.27 -11.63 11.650 0.000 24.53 0.00 5.00 122.65 0.00 1.20 147.18 0.00 147.18 2444.82
0+460.000 3707.31 3695.68 11.63 -10.96 0.000 3.290 11.65 3.29 10.00 116.50 32.90 1.20 139.80 -39.48 100.32 2545.14
0+480.000 3707.61 3696.65 10.96 -9.09 0.080 0.850 0.08 4.14 10.00 0.80 41.40 1.20 0.96 -49.68 -48.72 2496.42
0+500.000 3707.65 3698.56 9.09 -8.21 8.370 0.000 8.45 0.85 10.00 84.50 8.50 1.20 101.40 -10.20 91.20 2587.62
0+520.000 3708.68 3700.47 8.21 -8.48 9.180 0.000 17.55 0.00 10.00 175.50 0.00 1.20 210.60 0.00 210.60 2798.22
0+530.000 3710.85 3702.37 8.48 -8.28 6.290 0.000 15.47 0.00 5.00 77.35 0.00 1.20 92.82 0.00 92.82 2891.04
0+540.000 3712.55 3704.27 8.28 -9.29 6.470 0.000 12.76 0.00 5.00 63.80 0.00 1.20 76.56 0.00 76.56 2967.60
0+550.000 3715.47 3706.18 9.29 -8.50 6.070 0.000 12.54 0.00 5.00 62.70 0.00 1.20 75.24 0.00 75.24 3042.84
0+560.000 3716.58 3708.08 8.50 -8.26 4.050 0.090 10.12 0.09 5.00 50.60 0.45 1.20 60.72 -0.54 60.18 3103.02
0+570.000 3718.25 3709.99 8.26 -7.76 3.280 0.250 7.33 0.34 5.00 36.65 1.70 1.20 43.98 -2.04 41.94 3144.96
0+580.000 3718.70 3710.94 7.76 -7.24 3.930 0.140 7.21 0.39 5.00 36.05 1.95 1.20 43.26 -2.34 40.92 3185.88
0+600.000 3719.13 3711.89 7.24 -6.88 2.610 0.030 6.54 0.17 10.00 65.40 1.70 1.20 78.48 -2.04 76.44 3262.32
0+620.000 3719.73 3712.85 6.88 -5.69 3.440 0.550 6.05 0.58 10.00 60.50 5.80 1.20 72.60 -6.96 65.64 3327.96
0+630.000 3719.49 3713.80 5.69 -3.42 0.230 1.610 3.67 2.16 5.00 18.35 10.80 1.20 22.02 -12.96 9.06 3337.02
0+640.000 3718.17 3714.75 3.42 -2.58 0.140 0.970 0.37 2.58 5.00 1.85 12.90 1.20 2.22 -15.48 -13.26 3323.76
0+650.000 3718.28 3715.70 2.58 -4.05 3.620 0.310 3.76 1.28 5.00 18.80 6.40 1.20 22.56 -7.68 14.88 3338.64
0+660.000 3720.71 3716.66 4.05 -4.30 6.710 0.030 10.33 0.34 5.00 51.65 1.70 1.20 61.98 -2.04 59.94 3398.58
0+680.000 3721.91 3717.61 4.30 -2.33 3.850 0.520 10.56 0.55 10.00 105.60 5.50 1.20 126.72 -6.60 120.12 3518.70
0+700.000 3721.84 3719.51 2.33 -1.35 9.120 0.000 12.97 0.52 10.00 129.70 5.20 1.20 155.64 -6.24 149.40 3668.10
0+710.000 3722.77 3721.42 1.35 -1.36 8.280 0.000 17.40 0.00 5.00 87.00 0.00 1.20 104.40 0.00 104.40 3772.50
0+720.000 3723.73 3722.37 1.36 -1.51 7.340 0.000 15.62 0.00 5.00 78.10 0.00 1.20 93.72 0.00 93.72 3866.22
0+730.000 3724.83 3723.32 1.51 -2.16 9.800 0.000 17.14 0.00 5.00 85.70 0.00 1.20 102.84 0.00 102.84 3969.06
0+740.000 3726.43 3724.27 2.16 -2.12 4.390 0.210 14.19 0.21 5.00 70.95 1.05 1.20 85.14 -1.26 83.88 4052.94
0+760.000 3727.35 3725.23 2.12 0.30 1.740 0.440 6.13 0.65 10.00 61.30 6.50 1.20 73.56 -7.80 65.76 4118.70
0+780.000 3726.83 3727.13 -0.30 0.83 1.650 0.520 3.39 0.96 10.00 33.90 9.60 1.20 40.68 -11.52 29.16 4147.86
0+800.000 3728.23 3729.06 -0.83 0.49 0.270 1.430 1.92 1.95 10.00 19.20 19.50 1.20 23.04 -23.40 -0.36 4147.50
0+820.000 3729.55 3730.04 -0.49 0.15 18.500 0.000 18.77 1.43 10.00 187.70 14.30 1.20 225.24 -17.16 208.08 4355.58
0+830.000 3730.87 3731.02 -0.15 1.04 27.180 0.000 45.68 0.00 5.00 228.40 0.00 1.20 274.08 0.00 274.08 4629.66
0+840.000 3731.96 3733.00 -1.04 0.99 15.950 0.000 43.13 0.00 5.00 215.65 0.00 1.20 258.78 0.00 258.78 4370.88
0+860.000 3733.01 3734.00 -0.99 0.15 13.040 0.000 28.99 0.00 10.00 289.90 0.00 1.20 347.88 0.00 347.88 4023.00
0+880.000 3734.85 3735.00 -0.15 -0.66 4.660 0.930 17.70 0.93 10.00 177.00 9.30 1.20 212.40 -11.16 201.24 4224.24
0+890.000 3736.68 3736.02 0.66 -1.30 0.000 19.680 4.66 20.61 5.00 23.30 103.05 1.20 27.96 -123.66 -95.70 4128.54
0+900.000 3738.37 3737.07 1.30 -1.03 0.180 5.880 0.18 25.56 5.00 0.90 127.80 1.20 1.08 -153.36 -152.28 3976.26
0+910.000 3739.09 3738.06 1.03 -0.12 9.210 0.040 9.39 5.92 5.00 46.95 29.60 1.20 56.34 -35.52 20.82 3997.08
0+920.000 3739.21 3739.09 0.12 1.51 15.400 0.000 24.61 0.04 5.00 123.05 0.20 1.20 147.66 -0.24 147.42 4144.50
0+940.000 3739.66 3741.17 -1.51 1.45 15.500 0.000 30.90 0.00 10.00 309.00 0.00 1.20 370.80 0.00 370.80 3773.70
0+950.000 3741.81 3743.26 -1.45 1.88 18.220 0.000 33.72 0.00 5.00 168.60 0.00 1.20 202.32 0.00 202.32 3571.38
0+960.000 3743.48 3745.36 -1.88 1.19 19.700 0.000 37.92 0.00 5.00 189.60 0.00 1.20 227.52 0.00 227.52 3343.86
0+970.000 3746.26 3747.45 -1.19 1.08 8.830 0.000 28.53 0.00 5.00 142.65 0.00 1.20 171.18 0.00 171.18 3172.68
0+980.000 3748.46 3749.54 -1.08 1.03 0.000 6.500 8.83 6.50 5.00 44.15 32.50 1.20 52.98 -39.00 13.98 3158.70
0+990.000 3750.60 3751.63 -1.03 0.36 0.000 15.300 0.00 21.80 5.00 0.00 109.00 1.20 0.00 -130.80 -130.80 3289.50
1+000.000 3753.37 3753.73 -0.36 0.00 3.280 0.370 3.28 15.67 5.00 16.40 78.35 1.20 19.68 -94.02 -74.34 3363.84
PERFIL LONGITUDINAL
3780.00 Column C Column D

3760.00

3740.00

3720.00
Altitud (m.sn.m.)

3700.00

3680.00

3660.00

3640.00

3620.00

3600.00
0+000.000 0+100.000 0+200.000 0+300.000 0+400.000 0+500.000 0+600.000 0+700.000 0+800.000 0+900.000 1+000.000
Progresiva (km)

DIAGRAMA DE MASA
5000.00 Column R

4500.00

4000.00

3500.00

3000.00
Ordenada (m3)

2500.00

2000.00

1500.00

1000.00

500.00
3500.00

3000.00

Ordenada (m3)
2500.00

2000.00

1500.00

1000.00

500.00

0.00
0+000.000 0+100.000 0+200.000 0+300.000 0+400.000 0+500.000 0+600.000 0+700.000 0+800.000 0+900.000 1+000.000
Progresiva (km)
CÁLCULO DE DIAGRAMA DE MASA
+ - DEL GRAFICO
Cota Alturas Áreas A1 + A2 Volumen Volumen abundado Suma Volumen
Estaca d/2 Esp. Ordenada
Terreno SubrasantCorte Relleno Corte Relleno Corte Relleno Corte Relleno Corte Relleno Corte Relleno
12380 3564.8 3566.6 18.2 0 0 0 0 0
12400 3566 3566.8 8.9 1.2 0 0 0 0
12420 3567.8 3567 4.5 1.2 0 0 0 0
12434 3568.55 3567.14 7.1 1.2 0 0 0 0
12440 3568.2 3567.2 5.2 1.2 0 0 0 0
12460 3566.6 3567.4 1.4 1.2 0 0 0 0
12480 3565.7 3567.6 22 1.2 0 0 0 0
12500 3566.81 3567.8 6.4 1.2 0 0 0 0
12520 3568.9 3568 5.2 1.2 0 0 0 0
12540 3570.7 3568.2 8.3 1.2 0 0 0 0
12550 3570.92 3568.3 11.8 1.2 0 0 0 0
12560 3570.1 3568.4 8.7 1.2 0 0 0 0
12580 3568.15 3568.6 2.4 1.2 0 0 0 0 26851
12600 3567 3568.8 6.3 1.2 0 0 0 0
12620 3568.4 3569 2.8 1.2 0 0 0 0
12640 3570 3569.2 4.1 1.2 0 0 0 0
12660 3570.59 3569.4 5.7 1.2 0 0 0 0
12680 3570.21 3569.6 3.4 1.2 0 0 0 0
12700 3569.02 3569.8 3.1 1.2 0 0 0 0

CÁLCULO DE DIAGRAMA DE MASA


+ - DEL GRAFICO
Cota Alturas Áreas A1 + A2 Volumen Volumen abundado Suma Volumen
Estaca d/2 Esp. Ordenada
Terreno SubrasanteCorte Relleno Corte Relleno Corte Relleno Corte Relleno Corte Relleno Corte Relleno
12380 3564.8 3566.6 18.2 0 0 0 0 0
12400 3566 3566.8 8.9 1.2 0 0 0 0
12420 3567.8 3567 4.5 1.2 0 0 0 0
12434 3568.55 3567.14 7.1 1.2 0 0 0 0
12440 3568.2 3567.2 5.2 1.2 0 0 0 0
12460 3566.6 3567.4 1.4 1.2 0 0 0 0
12480 3565.7 3567.6 22 1.2 0 0 0 0
12500 3566.81 3567.8 6.4 1.2 0 0 0 0
12520 3568.9 3568 5.2 1.2 0 0 0 0
12540 3570.7 3568.2 8.3 1.2 0 0 0 0
12550 3570.92 3568.3 11.8 1.2 0 0 0 0
12560 3570.1 3568.4 8.7 1.2 0 0 0 0
12580 3568.15 3568.6 2.4 1.2 0 0 0 0 26851
12600 3567 3568.8 6.3 1.2 0 0 0 0
12620 3568.4 3569 2.8 1.2 0 0 0 0
12640 3570 3569.2 4.1 1.2 0 0 0 0
12660 3570.59 3569.4 5.7 1.2 0 0 0 0
12680 3570.21 3569.6 3.4 1.2 0 0 0 0
12700 3569.02 3569.8 3.1 1.2 0 0 0 0
12720 3567.4 3570 11.4 1.2 0 0 0 0
PERFIL LONGITUDINAL
3700.00
3690.00
3680.00

Altitud (m.sn.m.)
3670.00
3660.00
3650.00
Terreno natural
3640.00
Subrasante
3630.00
0+000.000 0+050.000 0+100.000 0+150.000 0+200.000 0+250.000 0+300.000 0+350.000
Progresiva (km)

2500.00 DIAGRAMA DE MASA


Ordenada (m3)

2000.00
1500.00
1000.00
500.00
DIAGRAMA DE MASA
0.00
0+000.000 0+100.000 0+200.000 0+300.000 0+400.000
Progresiva (km)

You might also like