corte y relleno-programa.xlsx

Upload: sandro-venero-soncco

Post on 07-Jul-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/18/2019 corte y relleno-programa.xlsx

    1/3

    AREA VOLU

    PROG. DISTANCIA CORTE RELLENO CORTE

    0+00 0.00 5.4 2

    0+020 20.00 1.03 3.16 64.3

    0+040 20.00 0.48 3.37 15.1

    0+060 20.00 15 0 154.8

    0+080 20.00 1.11 2.69 161.1

    0+100 20.00 2.78 1.89 38.9

    0+120 20.00 0 6.02 27.8

    0+140 20.00 0 10.56 0

    0+160 20.00 2.16 4.36 21.6

    0+180 20.00 7.02 1.88 91.8

    0+200 20.00 5.07 4.3 120.9

    0+220 20.00 3.16 2.54 82.3

    0+240 20.00 4.5 0.93 76.6

    0+248 8.00 4.14 1.03 34.56

    0+260 12.00 5 0 54.84

    0+280 20.00 4.87 0 98.7

    GRAFICA

    PROG.

    0+00

    0+020 12.7

    0+040 -37.5

    0+060 83.6

    0+080 217.8

    0+100 210.9

    0+120 159.6

    0+140 -6.2

    0+160 -133.8

    0+180 -104.4

    0+200 -45.3

    0+220 -31.4

    0+240 10.5

    0+248 37.22

    0+260 85.88

    0+280 184.58

    ORDENADA

    DE MASA

    -200

    -150

    -100

    -50

    0

    50

    100

    150

    200

    250

  • 8/18/2019 corte y relleno-programa.xlsx

    2/3

    MEN VOLUMEN NETO M3   INCIDEN

    RELLENO CORTE O RELLENO SACAR CORTE +! SACAR CORTE -! MS

    51.6 12.7 12.7 0 0.1

    65.3 -50.2 0 -50.2 0.1

    33.7 121.1 121.1 0 0.1

    26.9 134.2 134.2 0 0.1

    45.8 -6.9 0 -6.9 0.1

    79.1 -51.3 0 -51.3 0.1

    165.8 -165.8 0 -165.8 0.1

    149.2 -127.6 0 -127.6 0.1

    62.4 29.4 29.4 0 0.1

    61.8 59.1 59.1 0 0.1

    68.4 13.9 13.9 0 0.1

    34.7 41.9 41.9 0 0.1

    7.84 26.72 26.72 0 0.1

    6.18 48.66 48.66 0 0.1

    0 98.7 98.7 0 0.1

    ORDENADA DE MASA

    ORDENADA DE MASA

  • 8/18/2019 corte y relleno-programa.xlsx

    3/3

    IA DEL MATERIAL EN CORTE CLASIFICACION DE MATERIAL EN CORTE   VOLUMEN NETO

    RF RS MS RF RS   CORTE O RELLENO

    0.2 0.6 1.27 2.54 7.62 12.7 12.7

    0.2 0.6 -5.02 0 -30.12 -50.2 -37.5

    0.2 0.6 12.11 24.22 72.66 121.1 83.6

    0.2 0.6 13.42 26.84 80.52 134.2 217.8

    0.2 0.6 -0.69 0 -4.14 -6.9 210.9

    0.2 0.6 -5.13 0 -30.78 -51.3 159.6

    0.2 0.6 -16.58 0 -99.48 -165.8 -6.2

    0.2 0.6 -12.76 0 -76.56 -127.6 -133.8

    0.2 0.6 2.94 5.88 17.64 29.4 -104.4

    0.2 0.6 5.91 11.82 35.46 59.1 -45.3

    0.2 0.6 1.39 2.78 8.34 13.9 -31.4

    0.2 0.6 4.19 8.38 25.14 41.9 10.5

    0.2 0.6 2.672 5.344 16.032 26.72 37.22

    0.2 0.6 4.866 9.732 29.196 48.66 85.88

    0.2 0.6 9.87 19.74 59.22 98.7 184.58

    ORDENADA

    DE MASA