Download - Excel Para Caminos

Transcript
Page 1: Excel Para Caminos

CUADRO N°01 - DETERMINACIÓN DE LA OROGRAFÍA

ZONACOTAS

DH αINICIAL FINAL

1 3160 3150 10 20.00 0.500 26.5652 3190 3180 10 18.00 0.556 29.0553 3250 3240 10 23.00 0.435 23.4994 3170 3160 10 27.00 0.370 20.3235 3280 3270 10 24.00 0.417 22.6206 3240 3230 10 30.00 0.333 18.4357 3290 3280 10 22.00 0.455 24.4448 3300 3290 10 30.00 0.333 18.4359 3320 3310 10 38.00 0.263 14.744

10 3340 3330 10 24.00 0.417 22.62011 3270 3260 10 26.00 0.385 21.03712 3220 3210 10 20.00 0.500 26.56513 3310 3300 10 24.00 0.417 22.62014 3150 3140 10 31.00 0.323 17.87915 3200 3190 10 23 0.435 23.49916 3310 3300 10 24 0.417 22.62017 3340 3330 10 17 0.588 30.46518 3300 3290 10 24 0.417 22.62019 3320 3310 10 15 0.667 33.69020 3300 3290 10 14 0.714 35.53821 3270 3260 10 19 0.526 27.75822 3210 3200 10 25 0.400 21.80123 3280 3270 10 21 0.476 25.46324 3260 3250 10 19 0.526 27.75825 3220 3210 10 27 0.370 20.32326 3240 3230 10 28 0.357 19.65427 3200 3190 10 24 0.417 22.62028 3310 3300 10 16 0.625 32.00529 3320 3310 10 21 0.476 25.46330 3330 3320 10 15 0.667 33.690

∆H TAN(α)

Page 2: Excel Para Caminos

CUADRO N°01 - DETERMINACIÓN DE LA OROGRAFÍA

TOPOGRAFIA

Accidentada 0.464 1.9Accidentada 0.507 1.1Accidentada 0.410 1Accidentada 0.355 0.9Accidentada 0.395 1.1

Ondulada 0.322 1Accidentada 0.427 1.4

Ondulada 0.322 1.7Ondulada 0.257 1.1

Accidentada 0.395 1.2Accidentada 0.367 1.2Accidentada 0.464 0.6Accidentada 0.395 1.2

Ondulada 0.312 1Accidentada 0.410 Accidentada 0.395

Muy Accidentada 0.532Accidentada 0.395

Muy Accidentada 0.588 1.4Muy Accidentada 0.620 1.1

Accidentada 0.484 1.4Accidentada 0.381 0.9Accidentada 0.444 1.2Accidentada 0.484 1.1Accidentada 0.355 1

Ondulada 0.343Accidentada 0.395

Muy Accidentada 0.559Accidentada 0.444

Muy Accidentada 0.588

Page 3: Excel Para Caminos

RUTA ROJA

TRAMO COTA DH I% #COMP LONGOBRAS DE ARTE

ALCANTA 3100 8 5 2 4 400 0

RÍO 3092RÍO 3092 66 3 3.33 33 1980 1R-1 3158R-1 3158 52 3 3.33 26 1560 2R-2 3210R-2 3210 86 3 3.33 43 2580 3R-3 3296 26R-3 3296 1560 1

ABRA 3348 52 3 3.33ABRA 3348 12 600 0

B 3324 24 2.5 4

288 8680 7

ABRA DISTANCIA : 21 METROS PMEDIA = (288/8680) * 1003.32%

RUTA MORADA

TRAMO COTA DH I% #COMP LONG OBRAS DE ARTEALCANT

A 3100 8 4.8 2.08 4 384 0RÍO 3092RÍO 3092 48 4 2.5 1840 1= 30 MR-1 3140 23R-1 3140 36 4 2.5 1440 -R-2 3176 18R-2 3176 98 3 2.5 3480 -R-3 3274 58R-3 3274 2160 -

ABRA 3348 74 3 3.33 36ABRA 3348 600 -

B 3324 24 2.5 4 12

288 9904 1

ABRA DISTANCIA : 36 METROS PMEDIA = (288/9904) * 1002.90%

RUTA AZUL

TRAMO COTA DH I% #COMP LONG OBRAS DE ARTE

ABERTURA COMPAS

ABERTURA COMPAS

ABERTURA COMPAS

Page 4: Excel Para Caminos

TRAMO COTA DH I% #COMP LONGALCANT

A 3100 8 4.8 2.08 4 384 0RÍO 3092RÍO 3092 84 2.5 4 2100 2R-1 3176 42R-1 3176 58 3 3.33 1740 2R-2 3234 29R-2 3234 60 2.5 4 1300 3R-3 3294 29R-3 3294 1350 0

ABRA 3348 54 2.5 4 27ABRA 3348 600 1

B 3324 24 2.5 4 127474

288 8

ABRA DISTANCIA : 24 METROS PMEDIA = (288/7474) * 1003.85%

ABERTURA COMPAS

Page 5: Excel Para Caminos

RUTA ROJAOBRAS DE ARTE

PUENTECURV VUEL.0 0

1 1= 28

1 1

1 0

2 0

1 0

6 2

(288/8680) * 100

RUTA MORADAOBRAS DE ARTE

PUENTECURV VUEL.0 0

1 1

2 1

4 2

1 0

1 0

9 5

(288/9904) * 100

RUTA AZULOBRAS DE ARTE

PUENTE

Page 6: Excel Para Caminos

CURV VUEL. PUENTE0 0

1 1= 30M

1 0

2 0

2 0

0 0

6 1

(288/7474) * 100

Page 7: Excel Para Caminos

PESOS ABSOLUTOS

CARACTERISTICASRUTA ROJA RUTA AZUL

VALOR PESO VALOR PESOLongitud Total (m) 8680 2 7474 1Pendiente media % 3.32 2 3.85 1Pendiente maxima % 4 1 4 1Alcantarillas 7 1 8 2Puentes 28 1 30 2Numero de curvas de vuelta 6 2 6 2

9 9

Como podemos apreciar en nuestra evaluación por pesos absolutos elegiremos la ruta AZUL por ser la más adecuada.

PESOS RELATIVOS

CARACTERISTICASRUTA ROJA RUTA AZUL

VALOR PESO VALOR PESOLongitud Total (m) 8680 1.16 7474 1Pendiente media % 3.32 1.16 3.85 1Pendiente maxima % 4 1 4 1.14Alcantarillas 7 0.88 8 1.07Puentes 28 1 30 1.2Numero de curvas de vuelta 6 1.2 6 1

6.52 6.41

En la evaluación por pesos relativos también resulta ganadora la ruta AZUL, por lo tanto es la que elegimos para nuestra carretera

Page 8: Excel Para Caminos

PESOS ABSOLUTOS

RUTA MORADAVALOR PESO

9904 32.9 34 19 3

30 25 1

13

Como podemos apreciar en nuestra evaluación por pesos absolutos elegiremos la ruta AZUL por ser la más adecuada.

PESOS RELATIVOS

RUTA MORADAVALOR PESO

9904 1.332.9 1.334 19 1.29

30 1.075 1

7.02

En la evaluación por pesos relativos también resulta ganadora la ruta AZUL, por lo tanto es la que elegimos para nuestra carretera

Page 9: Excel Para Caminos

CUADRO DE COORDENADAS

PUNTO LADO LONG.ÁNGULO

GRA. MIN. SEG. SENKM 00

KM00 - Pi1 242.00P1 99.000º 48.000º 50.340º D

Pi1 - Pi2 180.00P2 116.000º 25.000º 24.020º I

Pi2 - Pi3 178.00P3 78.000º 06.000º 00.880º D

Pi3 - Pi4 148.00P4 46.000º 31.000º 55.010º I

Pi4 - Pi5 276.00P5 104.000º 22.000º 15.680º I

Pi5 -Pi 6 160.00P6 98.000º 55.000º 42.220º D

Pi6 - Pi7 200.00P7 00.000º 00.000º 00.000º

Pi7 - Pi8 0.00P8

1384.000

Page 10: Excel Para Caminos

COORDENADAS MEDIDAS COORDENADAS MEDIDAS

PUNTO A PUNTO B

ESTE 626458.000 627348.000NORTE 9245446.000 9245758.000

CUADRO DE COORDENADAS

AZIMUTGRA. RADI.

PROYECCIONESGRA. MIN. SEG. ESTE NORTE

56.00º 43.00º 7.32º 56.719 0.990 202.309 132.798

156.00º 31.00º 57.66º 156.533 2.732 71.681 -165.112

40.00º 6.00º 33.64º 40.109 0.700 114.676 136.137

118.00º 12.00º 34.52º 118.210 2.063 130.421 -69.959

71.00º 40.00º 39.51º 71.678 1.251 262.008 86.764

327.00º 18.00º 23.83º 327.307 5.713 -86.423 134.652

66.00º 14.00º 6.05º 66.235 1.156 183.041 80.597

0.00º 0.00º 0.00º 0.000 0.000 0.000 0.000

COORDENADAS CALCULADAS

PUNTO A' ESTE

627335.713

ERROR -12.287

CORRECCION 12.287

Page 11: Excel Para Caminos

CUADRO DE COORDENADAS

COORDENADAS CORRECCIÓN PROY. CORREGIDAESTE NORTE ESTE NORTE ESTE NORTE

626458.000 9245446.002.148 -4.175 204.457 128.623

626660.309 9245578.7981.598 -3.105 73.279 -168.217

626731.989 9245413.6861.580 -3.071 116.257 133.066

626846.666 9245549.8231.314 -4.762 131.735 -74.721

626977.087 9245479.8642.450 -4.762 264.458 82.003

627239.094 9245566.6281.420 -2.760 -85.002 131.891

627152.672 9245701.2801.776 -3.450 184.817 77.147

627335.713 9245781.8770.000 0.000 0.000 0.000

627335.713 9245781.87712.287 -26.085

COORDENADAS CALCULADAS COORDENADAS MEDIDASESTE NORTE ESTE NORTE

627335.713 9245781.877 627348.00 9245758.00

-12.287 23.877

12.287 -23.877

Page 12: Excel Para Caminos

CUADRO DE COORDENADAS

COOR. CORREGIDASESTE NORTE

626458.000 9245446.00

626662.457 9245574.623

626735.736 9245406.405

626851.992 9245539.472

626983.728 9245464.751

627248.186 9245546.754

627163.183 9245678.645

627348.000 9245755.792

627348.000 9245755.792

COORDENADAS MEDIDASNORTE

9245758.00

Page 13: Excel Para Caminos

Punto Segmento h Cota D d e Menor

0 - - - - -20 0.25 0.2 2 1.60 317840 0.3 0.12 2 0.80 317860 - - - - -80 0.25 0.15 2 1.20 3180

100 0.3 0.15 2 1.00 3182120 0.2 0.1 2 1.00 3184130 - - - - -150 0.25 0.2 2 1.60 3182170 0.25 0.15 2 1.20 3180190 - - - - -210 - - - - -230 0.5 0.3 2 1.20 3194250 0.15 0.05 2 0.67 3194270 - - - - -280 - - - - -300 0.2 0.05 2 0.50 3192320 - - - - -340 0.25 0.1 2 0.80 3192350 0.25 0.15 2 1.20 3192360 0.25 0.2 2 1.60 3192370 - - - - -390 - - - - -410 0.25 0.05 2 0.40 3192430 - - - - -450 0.35 0.05 2 0.29 3192470 0.4 0.15 2 0.75 3192490 0.2 0.15 2 1.50 3194510 0.25 0.05 2 0.40 3198520 - - - - -530 0.25 0.15 2 1.20 3200540 0.25 0.15 2 1.20 3200550 - - - - -560 0.25 0.15 2 1.20 3196570 0.25 0.05 2 0.40 3194580 0.45 0.15 2 0.67 3194590 0.3 0.25 2 1.67 3194600 0.3 0.15 2 1.00 3198610 0.35 0.05 2 0.29 3202620 - - - - -630 0.5 0.25 2 1.00 3204650 0.7 0.2 2 0.57 3204670 0.45 0.35 2 1.56 3202

Page 14: Excel Para Caminos

690 0.25 0.15 2 1.20 3200710 0.35 0.15 2 0.86 3200720 0.45 0.3 2 1.33 3200730 - - - - -750 0.4 0.2 2 1.00 3204770 - - - - -790 0.2 0.05 2 0.50 3206800 - - - - -810 0.25 0.1 2 0.80 3204820 - - - - -830 - - - - -840 0.25 0.1 2 0.80 3202850 0.45 0.1 2 0.44 3208860 0.3 0.2 2 1.33 3212870 - - - - -880 - - - - -890 0.15 0.05 2 0.67 3220910 0.2 0.05 2 0.50 3220920 0.2 0.1 2 1.00 3220930 - - - - -940 - - - - -950 0.3 0.05 2 0.33 3230960 0.5 0.45 2 1.80 3228970 0.35 0.05 2 0.29 3224980 0.25 0.2 2 1.60 3218990 0.25 0.1 2 0.80 3218

1000 - - - - -

Page 15: Excel Para Caminos

Cota Terreno3180.003179.603178.803180.003181.203183.003185.003184.003183.603180.003180.003186.003195.203192.003188.003190.003194.003194.003192.803194.003193.603194.003192.003192.403192.003192.293200.003204.003198.403200.003201.203201.203200.003197.203194.403194.673195.673199.003202.003204.003206.003204.573203.56

Page 16: Excel Para Caminos

3201.203200.863201.333202.003214.003206.003206.503206.003204.803202.003198.003202.803208.443213.333216.003220.003220.673220.503221.003224.003218.003230.333229.803224.293219.603218.803218.00

Page 17: Excel Para Caminos

LONGITUD DE TRAMO 1 = 400 PENDIENTE = 3.075ESTACA COTA FINAL COTA INICIAL DIFER COTAS COTA SUBRA DISTANCIA

0 3192.3 3180 12.3 3180.00 020 3192.3 3180 12.3 3180.62 2040 3192.3 3180 12.3 3181.23 4060 3192.3 3180 12.3 3181.85 6080 3192.3 3180 12.3 3182.46 80

100 3192.3 3180 12.3 3183.08 100120 3192.3 3180 12.3 3183.69 120130 3192.3 3180 12.3 3184.00 130150 3192.3 3180 12.3 3184.61 150170 3192.3 3180 12.3 3185.23 170190 3192.3 3180 12.3 3185.84 190210 3192.3 3180 12.3 3186.46 210230 3192.3 3180 12.3 3187.07 230250 3192.3 3180 12.3 3187.69 250270 3192.3 3180 12.3 3188.30 270280 3192.3 3180 12.3 3188.61 280300 3192.3 3180 12.3 3189.23 300320 3192.3 3180 12.3 3189.84 320340 3192.3 3180 12.3 3190.46 340350 3192.3 3180 12.3 3190.76 350360 3192.3 3180 12.3 3191.07 360370 3192.3 3180 12.3 3191.38 370390 3192.3 3180 12.3 3191.99 390400 3192.3 3180 12.3 3192.30 400

I%= ((CFL - CI)/DT)*100

LONGITUD DE TRAMO 2 = 300 PENDIENTE = 3.90ESTACA COTA FINAL COTA INICIAL DIFER COTAS COTA SUBRA DISTANCIA

400 3204 3192.3 11.7 3192.3 0410 3204 3192.3 11.7 3192.69 10430 3204 3192.3 11.7 3193.47 30

Page 18: Excel Para Caminos

450 3204 3192.3 11.7 3194.25 50470 3204 3192.3 11.7 3195.03 70490 3204 3192.3 11.7 3195.81 90510 3204 3192.3 11.7 3196.59 110520 3204 3192.3 11.7 3196.98 120530 3204 3192.3 11.7 3197.37 130540 3204 3192.3 11.7 3197.76 140550 3204 3192.3 11.7 3198.15 150560 3204 3192.3 11.7 3198.54 160570 3204 3192.3 11.7 8623.93 170580 3204 3192.3 11.7 3199.32 180590 3204 3192.3 11.7 3199.71 190600 3204 3192.3 11.7 3200.10 200610 3204 3192.3 11.7 3200.49 210620 3204 3192.3 11.7 3200.88 220630 3204 3192.3 11.7 3201.27 230650 3204 3192.3 11.7 3202.05 250670 3204 3192.3 11.7 3202.83 270690 3204 3192.3 11.7 3203.61 290700 3204 3192.3 11.7 3204.00 300

I%= ((CFL - CI)/DT)*100

LONGITUD DE TRAMO 3 = 300 PENDIENTE = 4.667ESTACA COTA FINAL COTA INICIAL DIFER COTAS COTA SUBRA DISTANCIA

700 3218.00 3204 14 3204 0710 3218.00 3206 12 3204.467 10720 3218.00 3206 12 3204.933 20730 3218.00 3206 12 3205.400 30750 3218.00 3206 12 3206.333 50770 3218.00 3206 12 3207.267 70790 3218.00 3206 12 3209.133 90800 3218.00 3206 12 3208.667 100810 3218.00 3206 12 3209.133 110820 3218.00 3206 12 3209.600 120830 3218.00 3206 12 3210.067 130840 3218.00 3206 12 3210.533 140850 3218.00 3206 12 3211.000 150860 3218.00 3206 12 3211.467 160870 3218.00 3206 12 3211.933 170880 3218.00 3206 12 3212.400 180890 3218.00 3206 12 3212.867 190910 3218.00 3206 12 3213.800 210920 3218.00 3206 12 3214.267 220

Page 19: Excel Para Caminos

930 3218.00 3206 12 3214.733 230940 3218.00 3206 12 3215.200 240950 3218.00 3206 12 3215.667 250960 3218.00 3206 12 3216.133 260970 3218.00 3206 12 3216.600 270980 3218.00 3206 12 3217.067 280990 3218.00 3206 12 3217.533 290

1000 3218.00 3206 12 3218.000 300

I%= ((CFL - CI)/DT)*100

Page 20: Excel Para Caminos

IZQUIERDA

Cota Cota Cota Cota Cota

Dist. (m) Dist. (m)

3188 318617 12

0.85 0.603186 3184

17 110.85 0.553186 3184

20 141.00 0.703188 3186

22 151.10 0.753188 3186

16 120.80 0.603190 318814.00 11.000.70 0.553192 3190

14 100.70 0.503190 3188

16 110.80 0.553188 3186

14 110.70 0.553188 3186

13 100.65 0.50

319213

0.653200

IZQUIERDA

IZQUIERDA

Dist. (m)

Dist. (m)

Dist. (m)

Page 21: Excel Para Caminos

160.80

3200 31989 6

0.45 0.303206 3204 3202 3196 3194

14 14 11 10 80.70 0.70 0.55 0.50 0.40

3200 3198 3198 319614 12 9 7

0.70 0.60 0.45 0.353202 3200 3202 3200

13 10 10 80.65 0.50 0.50 0.40

3204 3202 320013 13 10

0.65 0.65 0.503200 3198

15 120.75 0.603202 3200

14 120.7 0.6

3200 319814 12

0.70 0.603202 3200

16 120.80 0.603200 3198

14 110.70 0.553200 3198

15 120.75 0.60

319815

0.753198

150.75

3208 320615 12

0.75 0.603212 3210

Page 22: Excel Para Caminos

13 90.65 0.45

320414

0.70

320614

0.703206

130.653206

120.60

3204 320215 10

0.75 0.503202 3200

16 100.80 0.50

320815

0.75

320420

1.00

321214

0.70

Page 23: Excel Para Caminos

320614

0.703206

170.853206

160.80

322012

0.603212

140.703212

130.653212

140.703208

140.70

320416

0.803208

221.103214

160.803218

120.60

3224 3222

Page 24: Excel Para Caminos

14 100.70 0.503228 3226

14 110.70 0.553228 3226

14 100.70 0.503228 3226

12 100.60 0.503228 3226

12 100.60 0.503232 3230

15 80.75 0.40

322416

0.80

Page 25: Excel Para Caminos

IZQUIERDA ESTACA DERECHA

Cota Cota Cota Cota Cota Cota Cota Cota

Dist. (m) Cota Dist. (m)

3184 3182 km 00 3178 3176 3174 31728 4 3182.00 4.0 7.0 10.4 15.0

0.4 0.2 3182.00 0.20 0.35 0.52 0.753182 3180 km 00+20 3178 3176 3174 3172

6 2 3182.00 4.0 8.0 12.0 16.00.3 0.1 3182.00 0.20 0.40 0.60 0.80 46

3182 3180 km 00+40 3176 3174 3172 31708 3 3182.67 3.0 8.0 12.4 17.0

0.40 0.15 3182.67 0.15 0.40 0.62 0.853184 3182 km 00+60 3178 3176 3174 3172

10 5 3184.00 4 9 16 220.50 0.25 3184.00 0.20 0.45 0.80 1.103184 3182 km 00+80 3180 3178 3176 3174

6 1 3184.00 3 6 12 200.30 0.05 3184.00 0.15 0.30 0.60 1.003186 3184 km 00+100 3182 3180 3178 31766.00 2.00 3186.00 3 8 12 180.30 0.10 3186.00 0.15 0.40 0.60 0.903188 3186 km 00+120 3184 3182 3180 3178

6 1 3185.00 1 6 10 140.30 0.05 3185.00 0.05 0.30 0.50 0.703186 3184 km 00+140 3182 3180 3178 3176

6 1 3187.00 4 8 12 160.30 0.05 3187.00 0.20 0.40 0.60 0.803184 3182 km 00+160 3178 3176 3174 3172

7 3 3188.00 3.0 8.0 12.0 16.00.35 0.15 3188.00 0.15 0.40 0.60 0.803184 3182 km 00+180 3178 3176 3174 3172

8 4 3190.00 4 8 12 170.40 0.20 3190.00 0.20 0.40 0.60 0.85 3190 3188 km 00+200 3184 3182 3180 3178

9 3 3197.00 4 8 12 180.45 0.15 3197.00 0.20 0.40 0.60 0.903198 3196 km 00+220 3194 3192 3190

Dist. (m)

Dist. (m)

Dist. (m)

Dist. (m)

Dist. (m)

Dist. (m)

Page 26: Excel Para Caminos

10 2 3195.20 6 12 160.50 0.10 3195.20 0.30 0.60 0.803196 3194 km 00+230 3190 3188 3186 3184

4 2 3193.00 2.0 5.0 7.0 10.00.20 0.10 3193.00 0.10 0.25 0.35 0.503192 3190 km 00+240 3186 3184 3182 3180 3182

6 3 3192.00 2 4 7 9 13.00.30 0.15 3192.00 0.10 0.20 0.35 0.45 0.653194 3192 km 00+250 3188 3186 3184 3182 3178 3176

5 2 3194.67 1 4 6 8 12 150.25 0.10 3194.67 0.05 0.20 0.30 0.40 0.60 0.753198 3196 km 00+260 3192 3190 3188 3186 3180 3178

5 3 3196.67 1 4 6 9 10 140.25 0.15 3196.67 0.05 0.20 0.30 0.45 0.50 0.703198 3196 km 00+270 3192 3190 3188 3186 3184 3182

9 4 3200.00 4.0 8.0 10.0 14.0 11 130.45 0.20 3200.00 0.20 0.40 0.50 0.70 0.55 0.653196 3194 km 00+280 3190 3188 3186 3184

6 1 31203.00 4 7 10 130.30 0.05 31203.00 0.20 0.35 0.50 0.653198 3196 km 00+300 3192 3190 3188 3186

7 2 3204.00 5.0 7.0 10.0 12.00.35 0.1 3204.00 0.25 0.35 0.50 0.603196 3194 km 00+320 3192 3190 3188 3186 3184

8 1 3204.60 4.0 7.0 11.0 13.0 14.00.40 0.05 3204.60 0.20 0.35 0.55 0.65 0.703198 3196 km 00+340 3192 3190 3188

10 6 3202.00 6.0 10.0 13.00.50 0.30 3202.00 0.30 0.50 0.653196 3194 km 00+360 3190 3188 3186

9 5 3200.00 6.0 10.0 14.00.45 0.25 3200.00 0.30 0.50 0.703196 3194 km 00+380 3190 3188 3186 3184

8 4 3200.00 1.0 6.0 11.0 16.00.40 0.20 3200.00 0.05 0.30 0.55 0.803196 3194 km 00+400 3190 3188 3186

11 6 3200.00 6.0 11.0 16.00.55 0.30 3200.00 0.30 0.55 0.803196 3194 km 00+420 3190 3188 3186 3184

11 6 3202.00 1.0 6.0 11.0 16.00.55 0.30 3202.00 0.05 0.30 0.55 0.803204 3202 km 00+440 3198 3196 3194

9 4 3206.00 4.0 9.0 14.00.45 0.20 3206.00 0.20 0.45 0.703208 3206 km 00+460 3202 3200 3198

Page 27: Excel Para Caminos

6 1 3204.00 2.0 9.0 14.00.30 0.05 3204.00 0.10 0.45 0.703202 3200 km 00+480 3196 3194 3192 3190

8 4 3206.00 1.0 6.0 10.0 16.00.40 0.20 3206.00 0.05 0.30 0.50 0.803204 3202 km 00+500 3198 3196 3194

12 5 3206.50 4.0 8.0 12.00.60 0.25 3206.50 0.20 0.40 0.603204 3202 km 00+520 3200 3198 3196

8 5 3210.50 4.0 10.0 14.00.40 0.25 3210.50 0.20 0.50 0.703204 3202 km 00+530 3200 3198 3196 3194

6 2 3214.00 4.0 6.0 10.0 16.00.30 0.10 3214.00 0.20 0.30 0.50 0.803204 3202 km 00+540 3198 3196 3194 3192

7 2 3212.67 3.0 6.0 10.0 15.00.35 0.10 3212.67 0.15 0.30 0.50 0.753200 3198 km 00+550 3196 3194 3192

5 1 3210.00 3.0 7.0 12.00.25 0.05 3210.00 0.15 0.35 0.603198 3196 km 00+560 3192 3190 3188

6 3 3208.00 3.0 7.0 13.00.30 0.15 3208.00 0.15 0.35 0.653206 3204 km 00+570 3202 3200 3198

9 4 3212.56 2.0 7.0 12.00.45 0.20 3212.56 0.10 0.35 0.603198 3196 km 00+580 3194 3192 3190

15 5 3216.00 2.0 10.0 18.00.75 0.25 3216.00 0.10 0.50 0.903202 3200 km 00+600 3198 3196 3194

10 2 3215.33 4.0 10.0 16.00.50 0.10 3215.33 0.20 0.50 0.803206 3204 km 00+620 3200 3198 3196

14 6 3214.00 2.0 9.0 15.00.70 0.30 3214.00 0.10 0.45 0.753208 3206 km 00+620 3202 3200

13 7 3204.00 8.0 14.00.65 0.35 3204.00 0.40 0.703210 3208 km 00+640 3204 3202

14 6 3214.00 4.0 12.00.70 0.30 3214.00 0.20 0.603208 3206 km 00+660 3202 3200

20 9 3212.00 5.0 12.01.00 0.45 3212.00 0.25 0.603206 3204 km 00+680 3202 3200

Page 28: Excel Para Caminos

12 2 3214.00 6.0 13.00.60 0.10 3214.00 0.30 0.653204 3202 km 00+700 3200 3198

8 2 3212.00 6.0 12.00.40 0.10 3212.00 0.30 0.603204 3202 km 00+710 3198 3196 3194 3192

10 4 32016.00 2.0 7.0 10.0 16.00.50 0.20 32016.00 0.10 0.35 0.50 0.803204 3202 km 00+720 3200 3198 3196

10 3 3216.00 6.0 10.0 14.00.50 0.15 3216.00 0.30 0.50 0.703206 3204 km 00+730 3200 3198

13 6 3216.00 12.0 14.00.65 0.30 3216.00 0.60 0.703218 3216 km 00+740 3212 3210 3208

8 1 3218.00 4.0 10.0 16.00.40 0.05 3218.00 0.20 0.50 0.803210 3208 km 00+760 3204 3202 3200

10 4 3221.00 4.0 8.0 12.00.50 0.20 3221.00 0.20 0.40 0.603210 3208 km 00+780 3204 3202 3200

8 4 3222.00 5.0 10.0 14.00.40 0.20 3222.00 0.25 0.50 0.703210 3208 km 00+800 3204 3202 3200

10 5 3223.00 5.0 10.0 14.00.50 0.25 3223.00 0.25 0.50 0.703206 3204 km 00+820 3202 3200 3198

9 4 3226.00 2.0 7.0 12.00.45 0.20 3226.00 0.10 0.35 0.603206 3204 km 00+830 3200 3198 3196

12 6 3224.00 5.0 10.0 16.00.60 0.30 3224.00 0.25 0.50 0.803202 3200 km 00+840 3196 3194

10 6 3225.00 6.0 14.00.50 0.30 3225.00 0.30 0.703206 3204 km 00+860 3200 3198 3196

10 6 3224.80 2.0 6.0 20.00.50 0.30 3224.80 0.10 0.30 1.003212 3210 km 00+870 3206 3204 3202 3200

10 4 3226.00 4.0 10.0 14.0 12.00.50 0.20 3226.00 0.20 0.50 0.70 0.603216 3214 km 00+880 3212 3210 3208

6 1 3228.00 3.0 7.0 12.00.30 0.05 3228.00 0.15 0.35 0.603220 3218 km 00+900 3214 3212 3210

Page 29: Excel Para Caminos

7 4 3231.00 6.0 10.0 12.00.35 0.20 3231.00 0.30 0.50 0.603224 3222 km 00+910 3218 3216 3214 3212

8 4 3230.00 2.0 6.0 10.0 13.00.40 0.20 3230.00 0.10 0.30 0.50 0.653224 3222 km 00+920 3218 3216 3214 3212

6 2 3224.00 1.0 4.0 8.0 11.00.30 0.10 3224.00 0.05 0.20 0.40 0.553224 3222 km 00+940 3218 3216 3214 3212 3210

6 2 3236.00 2.0 5.0 9.0 12.0 14.00.30 0.10 3236.00 0.10 0.25 0.45 0.60 0.703224 3222 km 00+960 3220 3218 3216

5 2 3237.00 3.0 7.0 12.00.25 0.10 3237.00 0.15 0.35 0.603228 3226 km 00+980 3222 3220 3218

4 1 3236.00 4.0 7.0 12.00.20 0.05 3236.00 0.20 0.35 0.603222 3220 km 00+1 3214 3212 3210

10 5 3235.00 5.0 13.0 15.00.50 0.25 3235.00 0.25 0.65 0.75

Page 30: Excel Para Caminos

ELEMENTOS DE CURVA

CURVAANGULOS

ÁNGULOVALOR S

1 13° 12' 26.10'' I 13.212 28° 21' 49.20'' D 28.363 42° 48' 54.60'' D 42.824 82° 35' 59.08'' I 82.605 27° 46' 23.09'' D 27.776 118° 04' 26.63'' I 118.077 120° 55' 02.20'' I 120.92

Numero de Ca 2,00

Peralte Máxi 12,00 %

Long. Entre 7,00 m

Bombeo 0,02

Velocidad de 40,00 km/h.

Page 31: Excel Para Caminos

ELEMENTOS DE CURVA

RADIANES RADIO (m) T angente(m) Long. Curva (m) Cuerda (m) Externa(m) Flecha (m)

0.23 30.00 3.473 6.92 6.90 0.20 0.200.50 30.00 7.581 14.85 14.70 0.94 0.910.75 48.00 18.818 35.87 35.04 3.56 3.311.44 80.00 70.281 115.33 105.60 26.49 19.900.48 44.00 10.878 21.33 21.12 1.32 1.292.06 52.00 86.669 107.16 89.18 49.07 25.252.11 40.00 70.581 84.42 69.60 41.13 20.28

Reducción 30,00 km/h.

VD ALT. POR BOMBEO ALT. POR PERALTE40.00 0.020 0.234

0.020 0.2340.020 0.1460.020 0.0880.020 0.1590.020 0.1350.020 0.175 0.175

Page 32: Excel Para Caminos

ELEMENTOS DE CURVA

Peralte (%) LRP (m) SA (m)

23.39 36.27 2.3023.39 36.27 2.3014.62 23.74 1.528.77 15.39 0.98

15.95 25.64 1.6413.50 22.14 1.4217.54 27.92 1.78

ALT. POR PERALTE P < 6 = 0.005P > 6 = 0.007

0.175

Page 33: Excel Para Caminos

CURVA Nº TANGENTE AZIMUT

GRAD MIN SEG RAD

1 3.743 230° 37' 05'' 4.025

63° 49' 31'' 1.1142 7.581 243° 49' 31'' 4.256

35° 27' 42'' 0.6193 18.818 215° 27' 42'' 3.761

352° 38' 47'' 6.1554 70.281 532° 38' 47'' 9.296

75° 14' 46'' 1.3135 10.878 255° 14' 46'' 4.455

47° 28' 23'' 0.8296 86.669 227° 28' 23'' 3.970

165° 32' 50'' 2.8897 70.581 345° 32' 50'' 6.031

44° 37' 49'' 0.779

Page 34: Excel Para Caminos

PROYECCIONES PUNTO COORDENADAS

ESTE NORTE ESTE NORTE

-2.893 -2.375 PC1 626,265.785 9,245,144.500 -2.8930903PI1 626,262.892 9,245,142.125

3.359 1.651 PT1 626,266.251 9,245,143.776

-6.804 -3.344 PC2 626,403.589 9,245,204.490PI2 626,396.785 9,245,207.834

4.398 6.175 PT2 626,401.183 9,245,201.659

-10.917 -15.327 PC3 626,430.629 9,245,285.870PI3 626,441.547 9,245,270.542 3.35916651

-2.409 18.663 PT3 626,443.955 9,245,289.206

8.995 -69.703 PC4 626,402.873 9,245,432.896PI4 626,411.869 9,245,502.599

67.964 17.898 PT4 626,343.905 9,245,519.599

-10.519 -2.770 PC5 626,584.076 9,245,527.110PI5 626,573.557 9,245,545.110

8.017 7.353 PT5 9,245,553.127 9,245,552.463

-63.872 -58.583 PC6 626,748.147 9,245,587.901PI6 626,684.275 9,245,646.484

21.631 -83.926 PT6 626,705.906 9,245,562.558

-17.616 68.347 PC7 626,747.025 9,245,540.508PI7 626,729.410 9,245,472.160

49.585 50.229 PT7 626,778.995 9,245,522.390

Page 35: Excel Para Caminos

PUNTO ELEMENTO DISTANCIA PROGRESIVA

A 0.00 Km + 00 + 00.00

A-PI1 120.00

PI1 120.00 Km 00 + 12 + 00.00

T1 3.47PC1 116.53 Km 00 + 10 + 16.53

LC1 6.90PT1 123.43 Km 00 + 12 + 3.43

PI1-PI2 149.00

T1 3.47145.53

PI2 268.95 Km 00 + 26 + 8.95

T2 7.58PC2 261.37 Km 00 + 26 + 1.37

LC2 14.70PT2 276.07 Km 00 + 26 + 16.07

PI2-PI3 77.00

T2 7.5869.42

PI3 345.49 Km 00 + 34 + 5.49

T3 18.82PC3 326.67 Km 00 + 32 + 6.67

LC3 35.04PT3 361.71 Km 00 + 36 + 1.71

PI3-PI4 234.00

T3 18.82215.18

PI4 576.90 Km 00 + 56 + 16.90

T4 70.28PC4 506.61 Km 00 + 50 + 6.61

LC4 105.60PT4

612.21Km 00 + 60 + 12.21

PI4-PI5 167.00

Page 36: Excel Para Caminos

T4 70.2896.72

PI5 708.93 Km 00 + 70 + 8.93

T5 10.88PC5

698.05Km 00 + 68 + 18.05

LC5 21.12PT5

719.17Km 00 + 70 + 19.17

PI5-PI6 150.00

T5 10.88139.12

PI6858.30

Km 00 + 84 + 18.30

T6 86.67PC6

771.63Km 00 + 76 + 11.63

LC6 89.18PT6 860.81 Km 00 + 86 + 0.81

PI6-PI7 180.00

T6 86.67

93.33

PI7954.14

Km 00 + 94 + 14.14

T7 70.58PC7 883.56 Km 00 + 88 + 3.56

LC7 69.60PT7

953.16Km 00 + 94 + 13.16

PI7-B 160.00

T7 70.58

89.42

B954.14

Km 00 + 94 + 14.14

Page 37: Excel Para Caminos

PROGRESIVA DISTANCIA ÁREAS M2 VOLUMEN M3 VOLUMEN CORREGIDOCORTE RELLENO CORTE RELLENO CORTE

0.00 36.52 28 43.82420.00 24.44 20.36 369.2 403.6 29.32820.00 12.48 20 124.8 845.2 14.97622.89 0 64.52 141.0024 1389.423 010.00 12.32 56.88 123.8 566.4 14.78410.00 12.44 56.4 184 442 14.92810.00 24.36 32 603 160.6 29.23220.00 96.24 0.12 4410 1.2 115.48820.00 344.76 0 8176.4 0 413.71210.62 472.88 0 4890.0852 0 567.45610.00 448.04 0 3362.1 0 537.64810.00 224.38 0 1262.6 60.4 269.25610.00 28.14 12.08 525.7 60.4 33.76810.00 77 0 981.8 0 92.410.00 119.36 0 978 0.2 143.23210.00 76.24 0.04 442.6 180.2 91.48810.00 12.28 36 163.2 192.4 14.73610.00 20.36 2.48 1506.2 12.4 24.43220.00 280.88 0 10174.8 0 337.05625.77 736.6 0 22178.6928 0 883.9210.00 984.68 0 10145.8 0 1181.61610.00 1044.48 0 10196.3 0 1253.37610.00 994.78 0 8921.3 0 1193.73610.00 789.48 0 7326.5 0 947.37610.00 675.82 0 5781.5 0 810.98410.00 480.48 0 3964.6 0 576.57610.00 312.44 0 1684.8 0 374.92810.00 24.52 0 185 0.6 29.42410.00 12.48 0.12 264.8 42 14.97620.00 40.48 8.28 927.6 86 48.57620.00 52.28 0.32 1047.6 5.6 62.73620.00 52.48 0.24 608 325.6 62.97620.00 8.32 32.3220.00

21.12

10.00

10.00

10.00

10.00

10.00

10.00

20.00

20.00

Page 38: Excel Para Caminos

20.00

20.00

20.00

20.00

12.98

10.00

10.00

10.00

10.00

10.00

20.00

20.00

20.00

15.05

10.00

10.00

10.00

20.00

20.00

10.00

10.00

10.00

10.00

10.00

10.00

20.00

Page 39: Excel Para Caminos

VOLUMEN CORREGIDORELLENO

36.426.468

2683.87673.94473.3241.6

0.1560000

15.70400

0.05246.8

3.2240000000000

0.15610.7640.4160.312

Page 40: Excel Para Caminos
Page 41: Excel Para Caminos

METRADO DE MOVIMIENTO DE TIERRAESTACA AREA CORTE AREA RELLENO VOL. CORTE

km. 00 + 000,00 5.00 4.00 58.00km. 00 + 020,00 0.80 10.00 11.36km. 00 + 040,00 28.00 430.00km. 00 + 060,00 15.00 0.77km. 00 + 080,00 1.00 12.00 60.00km. 00 + 100,00 5.00 3.00 120.00km. 00 + 120,00 7.00 3.00 65.00km. 00 + 130,00 6.00 8.00 70.00km. 00 + 150,00 1.00 13.00 407.56km. 00 + 170,00 48.00 0.00km. 00 + 190,00 55.00 14.54km. 00 + 210,00 4.00 7.00 713.24km. 00 + 230,00 67.00 1090.00km. 00 + 250,00 42.00 382.40km. 00 + 270,00 4.00 16.00 100.00km. 00 + 280,00 16.00 7.00 455.00km. 00 + 300,00 40.00 604.80km. 00 + 320,00 41.00 810.00km. 00 + 340,00 21.00 620.00km. 00 + 350,00 35.00 280.00km. 00 + 360,00 22.00 285.00km. 00 + 370,00 23.00 450.00km. 00 + 390,00 4.00 3.00 50.00km. 00 + 410,00 2.00 11.00 3.64km. 00 + 430,00 14.00 410.00km. 00 + 450,00 27.00 214.41km. 00 + 470,00 44.00 1680.00km. 00 + 490,00 80.00 1064.71km. 00 + 510,00 12.00 4.00 223.00km. 00 + 520,00 26.00 420.00km. 00 + 530,00 32.00 560.00km. 00 + 540,00 40.00 248.60km. 00 + 550,00 17.00 0.60 95.00km. 00 + 560,00 2.00 10.00 0.00km. 00 + 570,00 40.00 345.00km. 00 + 580,00 29.00 14.29km. 00 + 590,00 38.00 0.04km. 00 + 600,00 0.40 8.00 67.00km. 00 + 610,00 13.00 1.50 193.40km. 00 + 620,00 28.00 740.00km. 00 + 630,00 46.00 1300.00km. 00 + 650,00 19.00 388.06km. 00 + 670,00 6.00 0.20 16.36km. 00 + 690,00 21.00 0.00

Page 42: Excel Para Caminos

km. 00 + 710,00 35.00 0.00km. 00 + 720,00 31.00 0.00km. 00 + 730,00 26.00 260.00km. 00 + 750,00 78.00 58.00km. 00 + 770,00 1.00 12.00 685.12km. 00 + 790,00 17.00 0.71km. 00 + 800,00 17.00 0.00km. 00 + 810,00 48.00 0.00km. 00 + 820,00 72.00 0.00km. 00 + 830,00 54.00 0.00km. 00 + 840,00 74.00 0.00km. 00 + 850,00 0.00 23.00 0.00km. 00 + 860,00 16.00 280.00km. 00 + 870,00 40.00 515.00km. 00 + 880,00 65.00 630.00km. 00 + 890,00 63.00 605.00km. 00 + 910,00 58.00 600.00km. 00 + 920,00 62.00 785.00km. 00 + 930,00 95.00 590.00km. 00 + 940,00 23.00 590.00km. 00 + 950,00 138.00 805.00km. 00 + 960,00 126.00 1320.00km. 00 + 970,00 63.00 945.00km. 00 + 980,00 16.00 395.00km. 00 + 990,00 9.00 125.41km. 01 + 000,00 4.00 4.00 65.00

VOLUMEN 24315.42

Page 43: Excel Para Caminos

METRADO DE MOVIMIENTO DE TIERRAVOL. RELLENO

140.00211.36

0.00342.31150.0070.0060.00

210.0037.56

1030.00284.5413.240.00

102.40115.0015.3151.200.000.000.000.000.00

140.00223.63

0.0014.410.004.710.000.000.003.11

53.00330.00475.86114.29228.0446.500.900.000.000.06

188.36560.00

Page 44: Excel Para Caminos

330.00285.00346.67140.0035.12

340.71170.00310.00600.00630.00640.00485.00

0.000.000.000.000.000.000.000.000.000.000.000.00

10.4245.00

9583.72