met. de bruce informe caminos i 2013.xlsx

138
PUNTOS ABSCISA X COTAS A K0+ 000.0 0 2500 1 K0+ 142,9 142.9 2450 2 K0+ 285,8 285.8 2500 3 K0+ 428,7 428.7 2450 4 K0+ 571,6 571.6 2400 5 K0+ 714,5 714.5 2350 6 K0+ 857,4 857.4 2300 7 K1+ 0,3 1000.3 2250 8 K1+ 143,2 1143.2 2300 9 K1+ 286,1 1286.1 2350 10 K1+ 429 1429 2400 11 K1+ 571,9 1571.9 2450 12 K1+ 714,8 1714.8 2500 13 K1+ 857,7 1857.7 2450 14 K2+ 0,6 2000.6 2500 15 K2+ 143,5 2143.5 2450 16 K2+ 286,4 2286.4 2400 17 K2+ 429,3 2429.3 2350 18 K2+ 572,2 2572.2 2300 19 K2+ 715,1 2715.1 2250 20 K2+ 858 2858 2200 21 K3+ 0,9 3000.9 2150 22 K3+ 143,8 3143.8 2100 23 K3+ 286,7 3286.7 2150 24 K3+ 429,6 3429.6 2200 25 K3+ 572,5 3572.5 2250 26 K3+ 715,4 3715.4 2300 27 K3+ 858,3 3858.3 2250 28 K4+ 1,2 4001.2 2300 29 K4+ 144,1 4144.1 2350 30 K4+ 287 4287 2400 31 K4+ 429,9 4429.9 2450 32 K4+ 572,8 4572.8 2500 33 K4+ 715,7 4715.7 2550 34 K4+ 858,6 4858.6 2600 35 K5+ 1,5 5001.5 2650 36 K5+ 144,4 5144.4 2700 37 K5+ 287,3 5287.3 2750 38 K5+ 430,2 5430.2 2800

Upload: keny-sc

Post on 19-Jan-2016

21 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCE

PUNTOS ABSCISA X COTASA K0+ 000.0 0 25001 K0+ 142,9 142.9 24502 K0+ 285,8 285.8 25003 K0+ 428,7 428.7 24504 K0+ 571,6 571.6 24005 K0+ 714,5 714.5 23506 K0+ 857,4 857.4 23007 K1+ 0,3 1000.3 22508 K1+ 143,2 1143.2 23009 K1+ 286,1 1286.1 2350

10 K1+ 429 1429 240011 K1+ 571,9 1571.9 245012 K1+ 714,8 1714.8 250013 K1+ 857,7 1857.7 245014 K2+ 0,6 2000.6 250015 K2+ 143,5 2143.5 245016 K2+ 286,4 2286.4 240017 K2+ 429,3 2429.3 235018 K2+ 572,2 2572.2 230019 K2+ 715,1 2715.1 225020 K2+ 858 2858 220021 K3+ 0,9 3000.9 215022 K3+ 143,8 3143.8 210023 K3+ 286,7 3286.7 215024 K3+ 429,6 3429.6 220025 K3+ 572,5 3572.5 225026 K3+ 715,4 3715.4 230027 K3+ 858,3 3858.3 225028 K4+ 1,2 4001.2 230029 K4+ 144,1 4144.1 235030 K4+ 287 4287 240031 K4+ 429,9 4429.9 245032 K4+ 572,8 4572.8 250033 K4+ 715,7 4715.7 255034 K4+ 858,6 4858.6 260035 K5+ 1,5 5001.5 265036 K5+ 144,4 5144.4 270037 K5+ 287,3 5287.3 275038 K5+ 430,2 5430.2 280039 K5+ 573,1 5573.1 285040 K5+ 716 5716 290041 K5+ 858,9 5858.9 2950

Page 2: MET. DE BRUCE informe caminos I   2013.xlsx

42 K6+ 1,8 6001.8 290043 K6+ 144,7 6144.7 285044 K6+ 287,6 6287.6 290045 K6+ 430,5 6430.5 295046 K6+ 573,4 6573.4 300047 K6+ 716,3 6716.3 305048 K6+ 859,2 6859.2 310049 K7+ 2,1 7002.1 315050 K7+ 145 7145 320051 K7+ 287,9 7287.9 325052 K7+ 430,8 7430.8 330053 K7+ 573,7 7573.7 335054 K7+ 716,6 7716.6 340055 K7+ 859,5 7859.5 345056 K8+ 2,4 8002.4 350057 K8+ 145,3 8145.3 355058 K8+ 288,2 8288.2 360059 K8+ 431,1 8431.1 365060 K8+ 574 8574 370061 K8+ 716,9 8716.9 375062 K8+ 859,8 8859.8 380063 K9+ 2,7 9002.7 385064 K9+ 145,6 9145.6 390065 K9+ 288,5 9288.5 395066 K9+ 431,4 9431.4 400067 K9+ 574,3 9574.3 405068 K9+ 717,2 9717.2 410069 K9+ 860,1 9860.1 415070 K10+ 3 10003 420071 K10+ 145,9 10145.9 425072 K10+ 288,8 10288.8 430073 K10+ 431,7 10431.7 435074 K10+ 574,6 10574.6 430075 K10+ 717,5 10717.5 425076 K10+ 860,4 10860.4 400077 K11+ 3,3 11003.3 405078 K11+ 146,2 11146.2 410079 K11+ 289,1 11289.1 415080 K11+ 432 11432 420081 K11+ 574,9 11574.9 425082 K11+ 717,8 11717.8 430083 K11+ 860,7 11860.7 435084 K12+ 3,6 12003.6 440085 K12+ 146,5 12146.5 445086 K12+ 289,4 12289.4 450087 K12+ 432,3 12432.3 4450

Page 3: MET. DE BRUCE informe caminos I   2013.xlsx

88 K12+ 575,2 12575.2 440089 K12+ 718,1 12718.1 435090 K12+ 861 1286191 K13+ 3,9 13003.992 K13+ 146,8 13146.893 K13+ 289,7 13289.794 K13+ 432,6 13432.695 K13+ 575,5 13575.596 K13+ 718,4 13718.497 K13+ 861,3 13861.398 K14+ 4,2 14004.299 K14+ 147,1 14147.1

100 K14+ 290 14290101 K14+ 432,9 14432.9102 K14+ 575,8 14575.8103 K14+ 718,7 14718.7104 K14+ 861,6 14861.6105 K15+ 4,5 15004.5106 K15+ 147,4 15147.4107 K15+ 290,3 15290.3108 K15+ 433,2 15433.2109 K15+ 576,1 15576.1110 K15+ 719 15719111 K15+ 861,9 15861.9112 K16+ 4,8 16004.8113 K16+ 147,7 16147.7114 K16+ 290,6 16290.6115 K16+ 433,5 16433.5116 K16+ 576,4 16576.4117 K16+ 719,3 16719.3118 K16+ 862,2 16862.2119 K17+ 5,1 17005.1120 K17+ 148 17148121 K17+ 290,9 17290.9122 K17+ 433,8 17433.8123 K17+ 576,7 17576.7124 K17+ 719,6 17719.6125 K17+ 862,5 17862.5126 K18+ 5,4 18005.4127 K18+ 148,3 18148.3128 K18+ 291,2 18291.2129 K18+ 434,1 18434.1130 K18+ 577 18577131 K18+ 719,9 18719.9132 K18+ 862,8 18862.8133 K19+ 5,7 19005.7

Page 4: MET. DE BRUCE informe caminos I   2013.xlsx

134 K19+ 148,6 19148.6135 K19+ 291,5 19291.5136 K19+ 434,4 19434.4137 K19+ 577,3 19577.3138 K19+ 720,2 19720.2139 K19+ 863,1 19863.1140 K20+ 6 20006141 K20+ 148,9 20148.9142 K20+ 291,8 20291.8143 K20+ 434,7 20434.7144 K20+ 577,6 20577.6145 K20+ 720,5 20720.5146 K20+ 863,4 20863.4147 K21+ 6,3 21006.3148 K21+ 149,2 21149.2149 K21+ 292,1 21292.1150 K21+ 435 21435151 K21+ 577,9 21577.9152 K21+ 720,8 21720.8153 K21+ 863,7 21863.7154 K22+ 6,6 22006.6155 K22+ 149,5 22149.5156 K22+ 292,4 22292.4157 K22+ 435,3 22435.3158 K22+ 578,2 22578.2B K22+ 721,1 22721.1

22721.1

EVALUACION DE TRAZADO DE RUTAS

Xo=

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

Page 5: MET. DE BRUCE informe caminos I   2013.xlsx

Xo=

0285.8

571.6857.4

1143.21429

1714.8

2000.6

2286.4

2572.22858

3143.8

3429.6

3715.4

4001.24287

4572.8

4858.6

5144.4

5430.25716

6001.8

6287.6

6573.4

6859.19999999999

7144.99999999999

7430.79999999999

7716.59999999999

8002.39999999999

8288.19999999999

8573.99999999999

8859.79999999999

9145.59999999999

9431.39999999999

9717.1999999999910003

10288.8

10574.6

10860.4

11146.211432

11717.8

12003.6

12289.4

12575.20

500

1000

1500

2000

2500

3000

3500

4000

4500

5000ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 6: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCECONTRAPENDIENTES

Y PENDIENTE Xo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21

-50 -35.00 0 1050 35.00 50 0-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 1050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 0-50 -35.00 0 1050 35.00 50 0-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 10-50 -35.00 0 1050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 0-50 -35.00 0 1050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 0

Page 7: MET. DE BRUCE informe caminos I   2013.xlsx

-50 -35.00 0 10-50 -35.00 0 1050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 0-50 -35.00 0 10-50 -35.00 0 10

-250 -175.00 0 1050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 050 35.00 50 0-50 -35.00 0 10

Page 8: MET. DE BRUCE informe caminos I   2013.xlsx

-50 -35.00 0 10-50 -35.00 0 10

0.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 0

Page 9: MET. DE BRUCE informe caminos I   2013.xlsx

0.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 00.00 0 0

3250 90971.1 240 27761.1

EVALUACION DE TRAZADO DE RUTAS

39311,1+37421,1

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

Page 10: MET. DE BRUCE informe caminos I   2013.xlsx

###

0285.8

571.6857.4

1143.21429

1714.8

2000.6

2286.4

2572.22858

3143.8

3429.6

3715.4

4001.24287

4572.8

4858.6

5144.4

5430.25716

6001.8

6287.6

6573.4

6859.19999999999

7144.99999999999

7430.79999999999

7716.59999999999

8002.39999999999

8288.19999999999

8573.99999999999

8859.79999999999

9145.59999999999

9431.39999999999

9717.1999999999910003

10288.8

10574.6

10860.4

11146.211432

11717.8

12003.6

12289.4

12575.20

500

1000

1500

2000

2500

3000

3500

4000

4500

5000ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 11: MET. DE BRUCE informe caminos I   2013.xlsx

Xo=X+(K*∑Y)

amigo eleazar lo uniko q necesitamos es esos dos datos de amarrillo q x

x= distacia del trazo en metros sacalo con la escalay= es la diferencia de cotas

y la pendiente esta ai ps chekalo todo esta xvr

Page 12: MET. DE BRUCE informe caminos I   2013.xlsx

0285.8

571.6857.4

1143.21429

1714.8

2000.6

2286.4

2572.22858

3143.8

3429.6

3715.4

4001.24287

4572.8

4858.6

5144.4

5430.25716

6001.8

6287.6

6573.4

6859.19999999999

7144.99999999999

7430.79999999999

7716.59999999999

8002.39999999999

8288.19999999999

8573.99999999999

8859.79999999999

9145.59999999999

9431.39999999999

9717.1999999999910003

10288.8

10574.6

10860.4

11146.211432

11717.8

12003.6

12289.4

12575.20

500

1000

1500

2000

2500

3000

3500

4000

4500

5000ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 13: MET. DE BRUCE informe caminos I   2013.xlsx

amigo eleazar lo uniko q necesitamos es esos dos datos de amarrillo q x

Page 14: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCE

PUNTOS ABSCISA X COTAS

A K0+ 000.0 0 45501 K0+ 142,9 142.9 45402 K0+ 285,8 285.8 45303 K0+ 428,7 428.7 45204 K0+ 571,6 571.6 45105 K0+ 714,5 714.5 45006 K0+ 857,4 857.4 44907 K1+ 0,3 1000.3 44808 K1+ 143,2 1143.2 44709 K1+ 286,1 1286.1 4460

10 K1+ 429 1429 445011 K1+ 571,9 1571.9 445012 K1+ 714,8 1714.8 445013 K1+ 857,7 1857.7 446014 K2+ 0,6 2000.6 447015 K2+ 143,5 2143.5 448016 K2+ 286,4 2286.4 449017 K2+ 429,3 2429.3 450018 K2+ 572,2 2572.2 450019 K2+ 715,1 2715.1 451020 K2+ 858 2858 452021 K3+ 0,9 3000.9 453022 K3+ 143,8 3143.8 454023 K3+ 286,7 3286.7 455024 K3+ 429,6 3429.6 456025 K3+ 572,5 3572.5 457026 K3+ 715,4 3715.4 458027 K3+ 858,3 3858.3 459028 K4+ 1,2 4001.2 458029 K4+ 144,1 4144.1 459030 K4+ 287 4287 458031 K4+ 429,9 4429.9 459032 K4+ 572,8 4572.8 458033 K4+ 715,7 4715.7 459034 K4+ 858,6 4858.6 458035 K5+ 1,5 5001.5 459036 K5+ 144,4 5144.4 458037 K5+ 287,3 5287.3 459038 K5+ 430,2 5430.2 460039 K5+ 573,1 5573.1 461040 K5+ 716 5716 462041 K5+ 858,9 5858.9 4630

Page 15: MET. DE BRUCE informe caminos I   2013.xlsx

42 K6+ 1,8 6001.8 464043 K6+ 144,7 6144.7 465044 K6+ 287,6 6287.6 466045 K6+ 430,5 6430.5 467046 K6+ 573,4 6573.4 468047 K6+ 716,3 6716.3 469048 K6+ 859,2 6859.2 470049 K7+ 2,1 7002.1 471050 K7+ 145 7145 472051 K7+ 287,9 7287.9 473052 K7+ 430,8 7430.8 474053 K7+ 573,7 7573.7 475054 K7+ 716,6 7716.6 474055 K7+ 859,5 7859.5 473056 K8+ 2,4 8002.4 472057 K8+ 145,3 8145.3 471058 K8+ 288,2 8288.2 470059 K8+ 431,1 8431.1 469060 K8+ 574 8574 468061 K8+ 716,9 8716.9 467062 K8+ 859,8 8859.8 466063 K9+ 2,7 9002.7 465064 K9+ 145,6 9145.6 464065 K9+ 288,5 9288.5 463066 K9+ 431,4 9431.4 464067 K9+ 574,3 9574.3 465068 K9+ 717,2 9717.2 466069 K9+ 860,1 9860.1 467070 K10+ 3 10003 468071 K10+ 145,9 10145.9 469072 K10+ 288,8 10288.8 468073 K10+ 431,7 10431.7 469074 K10+ 574,6 10574.6 468075 K10+ 717,5 10717.5 469076 K10+ 860,4 10860.4 468077 K11+ 3,3 11003.3 467078 K11+ 146,2 11146.2 466079 K11+ 289,1 11289.1 465080 K11+ 432 11432 463081 K11+ 574,9 11574.9 464082 K11+ 717,8 11717.8 463083 K11+ 860,7 11860.7 464084 K12+ 3,6 12003.6 463085 K12+ 146,5 12146.5 464086 K12+ 289,4 12289.4 463087 K12+ 432,3 12432.3 4620

Page 16: MET. DE BRUCE informe caminos I   2013.xlsx

88 K12+ 575,2 12575.2 461089 K12+ 718,1 12718.1 460090 K12+ 861 12861 461091 K13+ 3,9 13003.9 462092 K13+ 146,8 13146.8 461093 K13+ 289,7 13289.7 462094 K13+ 432,6 13432.6 464095 K13+ 575,5 13575.5 463096 K13+ 718,4 13718.4 462097 K13+ 861,3 13861.3 461098 K14+ 4,2 14004.2 460099 K14+ 147,1 14147.1 4620

100 K14+ 290 14290 4630101 K14+ 432,9 14432.9 4610102 K14+ 575,8 14575.8 4600103 K14+ 718,7 14718.7 4590104 K14+ 861,6 14861.6 4580105 K15+ 4,5 15004.5 4570106 K15+ 147,4 15147.4 4580107 K15+ 290,3 15290.3 4570108 K15+ 433,2 15433.2 4560109 K15+ 576,1 15576.1 4570110 K15+ 719 15719 4580111 K15+ 861,9 15861.9 4590112 K16+ 4,8 16004.8 4580113 K16+ 147,7 16147.7 4590114 K16+ 290,6 16290.6 4600115 K16+ 433,5 16433.5 4580116 K16+ 576,4 16576.4 4590117 K16+ 719,3 16719.3 4590118 K16+ 862,2 16862.2 4590119 K17+ 5,1 17005.1 4600120 K17+ 148 17148 4610121 K17+ 290,9 17290.9 4610122 K17+ 433,8 17433.8 4600123 K17+ 576,7 17576.7 4610124 K17+ 719,6 17719.6 4600125 K17+ 862,5 17862.5 4590126 K18+ 5,4 18005.4 4600127 K18+ 148,3 18148.3 4610128 K18+ 291,2 18291.2 4620129 K18+ 434,1 18434.1 4630130 K18+ 577 18577 4620131 K18+ 719,9 18719.9 4610132 K18+ 862,8 18862.8 4620133 K19+ 5,7 19005.7 4610

Page 17: MET. DE BRUCE informe caminos I   2013.xlsx

134 K19+ 148,6 19148.6 4600135 K19+ 291,5 19291.5 4610136 K19+ 434,4 19434.4 4600137 K19+ 577,3 19577.3 4590138 K19+ 720,2 19720.2 4600139 K19+ 863,1 19863.1 4610140 K20+ 6 20006 4600141 K20+ 148,9 20148.9 4590142 K20+ 291,8 20291.8 4600143 K20+ 434,7 20434.7 4590144 K20+ 577,6 20577.6 4600145 K20+ 720,5 20720.5 4610146 K20+ 863,4 20863.4 4600147 K21+ 6,3 21006.3 4610148 K21+ 149,2 21149.2 4600149 K21+ 292,1 21292.1 4590150 K21+ 435 21435 4580151 K21+ 577,9 21577.9 4590152 K21+ 720,8 21720.8 4600153 K21+ 863,7 21863.7 4610154 K22+ 6,6 22006.6 4620155 K22+ 149,5 22149.5 4630156 K22+ 292,4 22292.4 4620157 K22+ 435,3 22435.3 4620158 K22+ 578,2 22578.2 4620159 K22+ 721,1 22721.1 4630160 K22+ 864 22864 4610161 K23+ 6,9 23006.9 4620162 K23+ 149,8 23149.8 4630163 K23+ 292,7 23292.7 4640164 K23+ 435,6 23435.6 4650165 K23+ 578,5 23578.5 4660166 K23+ 721,4 23721.4 4670167 K23+ 864,3 23864.3 4680168 K24+ 7,2 24007.2 4690169 K24+ 150,1 24150.1 4700B K24+ 293 24293 4710

24293

EVALUACION DE TRAZADO DE RUTAS

Page 18: MET. DE BRUCE informe caminos I   2013.xlsx

Xo= 57481,1 + 53521,1

Xo= 111002,2

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0 2000.6 4001.2 6001.8 8002.39999999999 10003 12003.6 14004.2 16004.8 18005.4 20006 22006.6 24007.24300

4350

4400

4450

4500

4550

4600

4650

4700

4750

4800

ESTUDIO DE RUTA

RUTA 2

DISTANCIA

COTA

S

Page 19: MET. DE BRUCE informe caminos I   2013.xlsx

0 2000.6 4001.2 6001.8 8002.39999999999 10003 12003.6 14004.2 16004.8 18005.4 20006 22006.6 24007.24300

4350

4400

4450

4500

4550

4600

4650

4700

4750

4800

ESTUDIO DE RUTA

RUTA 2

DISTANCIA

COTA

S

Page 20: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCECONTRAPENDIENTES

Y PENDIENTE Xo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21

-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 100 0.00 0 00 0.00 0 0

10 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 00 0.00 0 0

10 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 1010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 0

Page 21: MET. DE BRUCE informe caminos I   2013.xlsx

10 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-20 -14.00 0 1010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 10

Page 22: MET. DE BRUCE informe caminos I   2013.xlsx

-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 010 7.00 10 0-10 -7.00 0 1010 7.00 10 020 14.00 20 0-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 1020 14.00 20 010 7.00 10 0-20 -14.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 010 7.00 10 010 7.00 10 0-10 -7.00 0 1010 7.00 10 010 7.00 10 0-20 -14.00 0 1010 7.00 10 00 0.00 0 00 0.00 0 0

10 7.00 10 010 7.00 10 00 0.00 0 0

-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 10

Page 23: MET. DE BRUCE informe caminos I   2013.xlsx

-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 1010 7.00 10 010 7.00 10 0-10 -7.00 0 1010 7.00 10 0-10 -7.00 0 10-10 -7.00 0 10-10 -7.00 0 1010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 0-10 -7.00 0 100 0.00 0 00 0.00 0 0

10 7.00 10 0-20 -14.00 0 1010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 010 7.00 10 0

920 43613 720 39413

EVALUACION DE TRAZADO DE RUTAS

Page 24: MET. DE BRUCE informe caminos I   2013.xlsx

Xo= 57481,1 + 53521,1

Xo= 111002,2

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0 2000.6 4001.2 6001.8 8002.39999999999 10003 12003.6 14004.2 16004.8 18005.4 20006 22006.6 24007.24300

4350

4400

4450

4500

4550

4600

4650

4700

4750

4800

ESTUDIO DE RUTA

RUTA 2

DISTANCIA

COTA

S

Page 25: MET. DE BRUCE informe caminos I   2013.xlsx

0 2000.6 4001.2 6001.8 8002.39999999999 10003 12003.6 14004.2 16004.8 18005.4 20006 22006.6 24007.24300

4350

4400

4450

4500

4550

4600

4650

4700

4750

4800

ESTUDIO DE RUTA

RUTA 2

DISTANCIA

COTA

S

Page 26: MET. DE BRUCE informe caminos I   2013.xlsx

0 2000.6 4001.2 6001.8 8002.39999999999 10003 12003.6 14004.2 16004.8 18005.4 20006 22006.6 24007.24300

4350

4400

4450

4500

4550

4600

4650

4700

4750

4800

ESTUDIO DE RUTA

RUTA 2

DISTANCIA

COTA

S

Page 27: MET. DE BRUCE informe caminos I   2013.xlsx

0 2000.6 4001.2 6001.8 8002.39999999999 10003 12003.6 14004.2 16004.8 18005.4 20006 22006.6 24007.24300

4350

4400

4450

4500

4550

4600

4650

4700

4750

4800

ESTUDIO DE RUTA

RUTA 2

DISTANCIA

COTA

S

Page 28: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCE

PUNTOS ABSCISA X COTAS YA K0+ 000.0 0 2500a1 K0+ 142,9 142.9 2450 -50a2 K0+ 285,8 285.8 2500 50a3 K0+ 428,7 428.7 2450 -50a4 K0+ 571,6 571.6 2400 -50a5 K0+ 714,5 714.5 2350 -50a6 K0+ 857,4 857.4 2300 -50a7 K1+ 0,3 1000.3 2250 -50a8 K1+ 143,2 1143.2 2300 50a9 K1+ 286,1 1286.1 2350 50

a10 K1+ 429 1429 2400 50a11 K1+ 571,9 1571.9 2450 50a12 K1+ 714,8 1714.8 2500 50a13 K1+ 857,7 1857.7 2450 -50a14 K2+ 0,6 2000.6 2500 50a15 K2+ 143,5 2143.5 2450 -50a16 K2+ 286,4 2286.4 2400 -50a17 K2+ 429,3 2429.3 2350 -50a18 K2+ 572,2 2572.2 2300 -50a19 K2+ 715,1 2715.1 2250 -50a20 K2+ 858 2858 2200 -50a21 K3+ 0,9 3000.9 2150 -50A K3+ 143,8 3143.8 2100 -50

a22 K3+ 286,7 3286.7 2150 50a23 K3+ 429,6 3429.6 2200 50a24 K3+ 572,5 3572.5 2250 50a25 K3+ 715,4 3715.4 2300 50a26 K3+ 858,3 3858.3 2250 -50a27 K4+ 1,2 4001.2 2300 50a28 K4+ 144,1 4144.1 2350 50a29 K4+ 287 4287 2400 50a30 K4+ 429,9 4429.9 2450 50a31 K4+ 572,8 4572.8 2500 50a32 K4+ 715,7 4715.7 2550 50a33 K4+ 858,6 4858.6 2600 50a34 K5+ 1,5 5001.5 2650 50a35 K5+ 144,4 5144.4 2700 50a36 K5+ 287,3 5287.3 2750 50a37 K5+ 430,2 5430.2 2800 50a38 K5+ 573,1 5573.1 2850 50

Page 29: MET. DE BRUCE informe caminos I   2013.xlsx

a39 K5+ 716 5716 2900 50a40 K5+ 858,9 5858.9 2950 50a41 K6+ 1,8 6001.8 2900 -50a42 K6+ 144,7 6144.7 2850 -50A K6+ 287,6 6287.6 2900 50

a43 K6+ 430,5 6430.5 2950 50a44 K6+ 573,4 6573.4 3000 50a45 K6+ 716,3 6716.3 3050 50a46 K6+ 859,2 6859.2 3100 50a47 K7+ 2,1 7002.1 3150 50a48 K7+ 145 7145 3200 50a49 K7+ 287,9 7287.9 3250 50a50 K7+ 430,8 7430.8 3300 50a51 K7+ 573,7 7573.7 3350 50a52 K7+ 716,6 7716.6 3400 50a53 K7+ 859,5 7859.5 3450 50a54 K8+ 2,4 8002.4 3500 50a55 K8+ 145,3 8145.3 3550 50a56 K8+ 288,2 8288.2 3600 50a57 K8+ 431,1 8431.1 3650 50a58 K8+ 574 8574 3700 50a59 K8+ 716,9 8716.9 3750 50a60 K8+ 859,8 8859.8 3800 50a61 K9+ 2,7 9002.7 3850 50a62 K9+ 145,6 9145.6 3900 50a63 K9+ 288,5 9288.5 3950 50A K9+ 431,4 9431.4 4000 50

a64 K9+ 574,3 9574.3 4050 50a65 K9+ 717,2 9717.2 4100 50a66 K9+ 860,1 9860.1 4150 50a67 K10+ 3 10003 4200 50a68 K10+ 145,9 10145.9 4250 50a69 K10+ 288,8 10288.8 4300 50a70 K10+ 431,7 10431.7 4350 50a71 K10+ 574,6 10574.6 4300 -50a72 K10+ 717,5 10717.5 4250 -50a73 K10+ 860,4 -4250a74 K11+ 3,3 0a75 K11+ 146,2 0a76 K11+ 289,1 0a77 K11+ 432 0a78 K11+ 574,9 0a79 K11+ 717,8 0a80 K11+ 860,7 0

Page 30: MET. DE BRUCE informe caminos I   2013.xlsx

a81 K12+ 3,6 0a82 K12+ 146,5 0a83 K12+ 289,4 0a84 K12+ 432,3 0A K12+ 575,2 0

a85 K12+ 718,1 0a86 K12+ 861 0a87 K13+ 3,9 0a88 K13+ 146,8 0a89 K13+ 289,7 0a90 K13+ 432,6 0a91 K13+ 575,5 0a92 K13+ 718,4 0a93 K13+ 861,3 0a94 K14+ 4,2 0a95 K14+ 147,1 0a96 K14+ 290 0a97 K14+ 432,9 0a98 K14+ 575,8 0a99 K14+ 718,7 0

a100 K14+ 861,6 0a101 K15+ 4,5 0a102 K15+ 147,4 0a103 K15+ 290,3 0a104 K15+ 433,2 0a105 K15+ 576,1 0

A K15+ 719 0a106 K15+ 861,9 0a107 K16+ 4,8 0a108 K16+ 147,7 0a109 K16+ 290,6 0a110 K16+ 433,5 0a111 K16+ 576,4 0a112 K16+ 719,3 0a113 K16+ 862,2 0a114 K17+ 5,1 0a115 K17+ 148 0a116 K17+ 290,9 0a117 K17+ 433,8 0a118 K17+ 576,7 0a119 K17+ 719,6 0a120 K17+ 862,5 0a121 K18+ 5,4 0a122 K18+ 148,3 0

Page 31: MET. DE BRUCE informe caminos I   2013.xlsx

a123 K18+ 291,2 0a124 K18+ 434,1 0a125 K18+ 577 0a126 K18+ 719,9 0

A K18+ 862,8 0a127 K19+ 5,7 0a128 K19+ 148,6 0a129 K19+ 291,5 0a130 K19+ 434,4 0a131 K19+ 577,3 0a132 K19+ 720,2 0

B K19+ 863,1 0

EVALUACION DE TRAZADO DE RUTAS

Xo= 57481,1 + 53521,1

Xo= 111002,2

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0142.9

285.8428.7

571.6714.5

857.4

1000.3

1143.2

1286.11429

1571.9

1714.8

1857.7

2000.6

2143.5

2286.4

2429.3

2572.2

2715.12858

3000.9

3143.8

3286.7

3429.6

3572.5

3715.4

3858.3

4001.2

4144.14287

4429.9

4572.8

4715.7

4858.6

5001.5

5144.4

5287.3

5430.2

5573.15716

5858.9

6001.8

6144.7

6287.6

6430.5

6573.4

6716.3

6859.19999999999

7002.09999999999

7144.99999999999

7287.89999999999

7430.79999999999

7573.69999999999

7716.59999999999

7859.49999999999

8002.39999999999

8145.29999999999

8288.19999999999

8431.09999999999

8573.99999999999

8716.89999999999

8859.79999999999

9002.69999999999

9145.59999999999

9288.49999999999

9431.39999999999

9574.29999999999

9717.19999999999

9860.0999999999910003

10145.9

10288.8

10431.7

10574.6

10717.50

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 32: MET. DE BRUCE informe caminos I   2013.xlsx

0142.9

285.8428.7

571.6714.5

857.4

1000.3

1143.2

1286.11429

1571.9

1714.8

1857.7

2000.6

2143.5

2286.4

2429.3

2572.2

2715.12858

3000.9

3143.8

3286.7

3429.6

3572.5

3715.4

3858.3

4001.2

4144.14287

4429.9

4572.8

4715.7

4858.6

5001.5

5144.4

5287.3

5430.2

5573.15716

5858.9

6001.8

6144.7

6287.6

6430.5

6573.4

6716.3

6859.19999999999

7002.09999999999

7144.99999999999

7287.89999999999

7430.79999999999

7573.69999999999

7716.59999999999

7859.49999999999

8002.39999999999

8145.29999999999

8288.19999999999

8431.09999999999

8573.99999999999

8716.89999999999

8859.79999999999

9002.69999999999

9145.59999999999

9288.49999999999

9431.39999999999

9574.29999999999

9717.19999999999

9860.0999999999910003

10145.9

10288.8

10431.7

10574.6

10717.50

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 33: MET. DE BRUCE informe caminos I   2013.xlsx

PUNTOSMETODO DE BRUCECONTRAPENDIENTES

PENDIENTE Xo=X+(K*∑Y) Xo=X+(K*∑Y) A

IDA K=21 REGRESO K=21 a1

-35.00 0 10 a2

35.00 50 0 a3

-35.00 0 10 a4

-35.00 0 10 a5

-35.00 0 10 a6

-35.00 0 10 a7

-35.00 0 10 a8

35.00 50 0 a9

35.00 50 0 a10

35.00 50 0 a11

35.00 50 0 a12

35.00 50 0 a13

-35.00 0 10 a14

35.00 50 0 a15

-35.00 0 10 a16

-35.00 0 10 a17

-35.00 0 10 a18

-35.00 0 10 a19

-35.00 0 10 a20

-35.00 0 10 a21

-35.00 0 10 a22

-35.00 0 10 a23

35.00 50 0 a24

35.00 50 0 a25

35.00 50 0 a26

35.00 50 0 a27

-35.00 0 10 a28

35.00 50 0 a29

35.00 50 0 a30

35.00 50 0 a31

35.00 50 0 a32

35.00 50 0 a33

35.00 50 0 a34

35.00 50 0 a35

35.00 50 0 a36

35.00 50 0 a37

35.00 50 0 a38

35.00 50 0 a39

35.00 50 0 a40

Page 34: MET. DE BRUCE informe caminos I   2013.xlsx

35.00 50 0 a41

35.00 50 0 a42

-35.00 0 10 a43

-35.00 0 10 a44

35.00 50 0 a45

35.00 50 0 a46

35.00 50 0 a47

35.00 50 0 a48

35.00 50 0 a49

35.00 50 0 a50

35.00 50 0 a51

35.00 50 0 a52

35.00 50 0 a53

35.00 50 0 a54

35.00 50 0 a55

35.00 50 0 a56

35.00 50 0 a57

35.00 50 0 a58

35.00 50 0 a59

35.00 50 0 a60

35.00 50 0 a61

35.00 50 0 a62

35.00 50 0 a63

35.00 50 0 a64

35.00 50 0 a65

35.00 50 0 a66

35.00 50 0 a67

35.00 50 0 a68

35.00 50 0 a69

35.00 50 0 a70

35.00 50 0 a71

35.00 50 0 a72

35.00 50 0 a73

35.00 50 0 a74

-35.00 0 10 a75

-35.00 0 10 a76

-2975.00 0 10 a77

0.00 0 0 a78

0.00 0 0 a79

0.00 0 0 a80

0.00 0 0 a81

0.00 0 0 a82

0.00 0 0 a83

0.00 0 0 a84

Page 35: MET. DE BRUCE informe caminos I   2013.xlsx

0.00 0 0 a85

0.00 0 0 a86

0.00 0 0 a87

0.00 0 0 a88

0.00 0 0 a89

0.00 0 0 a90

0.00 0 0 a91

0.00 0 0 a92

0.00 0 0 a93

0.00 0 0 a94

0.00 0 0 a95

0.00 0 0 a96

0.00 0 0 a97

0.00 0 0 a98

0.00 0 0 a99

0.00 0 0 a100

0.00 0 0 a101

0.00 0 0 a102

0.00 0 0 a103

0.00 0 0 a104

0.00 0 0 a105

0.00 0 0 a106

0.00 0 0 a107

0.00 0 0 a108

0.00 0 0 a109

0.00 0 0 a110

0.00 0 0 a111

0.00 0 0 a112

0.00 0 0 a113

0.00 0 0 a114

0.00 0 0 a115

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

Page 36: MET. DE BRUCE informe caminos I   2013.xlsx

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

0.00 0 0

2750 57750 210 4410

EVALUACION DE TRAZADO DE RUTAS

Xo= 57481,1 + 53521,1

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0142.9

285.8428.7

571.6714.5

857.4

1000.3

1143.2

1286.11429

1571.9

1714.8

1857.7

2000.6

2143.5

2286.4

2429.3

2572.2

2715.12858

3000.9

3143.8

3286.7

3429.6

3572.5

3715.4

3858.3

4001.2

4144.14287

4429.9

4572.8

4715.7

4858.6

5001.5

5144.4

5287.3

5430.2

5573.15716

5858.9

6001.8

6144.7

6287.6

6430.5

6573.4

6716.3

6859.19999999999

7002.09999999999

7144.99999999999

7287.89999999999

7430.79999999999

7573.69999999999

7716.59999999999

7859.49999999999

8002.39999999999

8145.29999999999

8288.19999999999

8431.09999999999

8573.99999999999

8716.89999999999

8859.79999999999

9002.69999999999

9145.59999999999

9288.49999999999

9431.39999999999

9574.29999999999

9717.19999999999

9860.0999999999910003

10145.9

10288.8

10431.7

10574.6

10717.50

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 37: MET. DE BRUCE informe caminos I   2013.xlsx

0142.9

285.8428.7

571.6714.5

857.4

1000.3

1143.2

1286.11429

1571.9

1714.8

1857.7

2000.6

2143.5

2286.4

2429.3

2572.2

2715.12858

3000.9

3143.8

3286.7

3429.6

3572.5

3715.4

3858.3

4001.2

4144.14287

4429.9

4572.8

4715.7

4858.6

5001.5

5144.4

5287.3

5430.2

5573.15716

5858.9

6001.8

6144.7

6287.6

6430.5

6573.4

6716.3

6859.19999999999

7002.09999999999

7144.99999999999

7287.89999999999

7430.79999999999

7573.69999999999

7716.59999999999

7859.49999999999

8002.39999999999

8145.29999999999

8288.19999999999

8431.09999999999

8573.99999999999

8716.89999999999

8859.79999999999

9002.69999999999

9145.59999999999

9288.49999999999

9431.39999999999

9574.29999999999

9717.19999999999

9860.0999999999910003

10145.9

10288.8

10431.7

10574.6

10717.50

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 38: MET. DE BRUCE informe caminos I   2013.xlsx

ABCISA x COTA Y PENDIENTE

K0+000.0 0

K0+250.0 250.0 250.0 1050 -4 4

K0+500.0 250.0 500.0 1040 -10 -4 4

K0+625.0 125.0 625.0 1030 -10 -8 8

500.0 1125.0 1020 -10 -2 2

142.9 1267.9 1030 10 7 7

142.9 1410.7 1040 10 7 7

333.3 1744.0 1030 -10 -3 3

333.3 2077.4 1020 -10 -3 3

200.0 2277.4 1030 10 5 5

125.0 2402.4 1040 10 8 8

125.0 2527.4 1030 -10 -8 8

125.0 2652.4 1040 10 8 8

125.0 2777.4 1050 10 8 8

125.0 2902.4 1060 10 8 8

125.0 3027.4 1050 -10 -8 8

125.0 3152.4 1040 -10 -8 8

125.0 3277.4 1030 -10 -8 8

333.3 3610.7 1020 -10 -3 3

250.0 3860.7 1010 -10 -4 4

111.1 3971.8 1000 -10 -9 9

111.1 4082.9 990 -10 -9 9

111.1 4194.0 980 -10 -9 9

111.1 4305.2 970 -10 -9 9

250.0 4555.2 960 -10 -4 4

250.0 4805.2 950 -10 -4 4

250.0 5055.2 940 -10 -4 4

666.7 5721.8 930 -10 -1.5 1.5

125.0 5846.8 920 -10 -8 8

125.0 5971.8 910 -10 -8 8

125.0 6096.8 900 -10 -8 8

125.0 6221.8 890 -10 -8 8

125.0 6346.8 880 -10 -8 8

125.0 6471.8 870 -10 -8 8

125.0 6596.8 860 -10 -8 8

250.0 6846.8 850 -10 -4 4

250.0 7096.8 840 -10 -4 4

200.0 7296.8 850 10 5 5

250.0 7546.8 860 10 4 4

166.7 7713.5 870 10 6 6

166.7 7880.2 880 10 6 6

Page 39: MET. DE BRUCE informe caminos I   2013.xlsx

166.7 8046.8 870 -10 -6 6

166.7 8213.5 880 10 6 6

166.7 8380.2 890 10 6 6

166.7 8546.8 900 10 6 6

166.7 8713.5 910 10 6 6

250.0 8963.5 900 -10 -4 4

200.0 9163.5 910 10 5 5

200.0 9363.5 900 -10 -5 5

166.7 9530.2 890 -10 -6 6

250.0 9780.2 900 10 4 4

166.7 9946.8 910 10 6 6

166.7 10113.5 920 10 6 6

111.1 10224.6 930 10 9 9

111.1 10335.7 920 -10 -9 9

111.1 10446.8 910 -10 -9 9

333.3 10780.2 920 10 3 3

200.0 10980.2 910 -10 -5 5

125.0 11105.2 920 10 8 8

125.0 11230.2 930 10 8 8

125.0 11355.2 940 10 8 8

125.0 11480.2 950 10 8 8

125.0 11605.2 940 -10 -8 8

166.7 11771.8 930 -10 -6 6

166.7 11938.5 920 -10 -6 6

166.7 12105.2 930 10 6 6

111.1 12216.3 940 10 9 9

111.1 12327.4 950 10 9 9

111.1 12438.5 940 -10 -9 9

166.7 12605.2 930 -10 -6 6

166.7 12771.8 920 -10 -6 6

500.0 13271.8 910 -10 -2 2

142.9 13414.7 920 10 7 7

142.9 13557.5 930 10 7 7

142.9 13700.4 940 10 7 7

142.9 13843.3 950 10 7 7

142.9 13986.1 960 10 7 7

166.7 14152.8 970 10 6 6

166.7 14319.4 980 10 6 6

166.7 14486.1 970 -10 -6 6

166.7 14652.8 980 10 6 6

200.0 14852.8 970 -10 -5 5

250.0 15102.8 980 10 4 4

142.9 15245.6 990 10 7 7

500.0 15745.6 980 -10 -2 2

Page 40: MET. DE BRUCE informe caminos I   2013.xlsx

166.7 15912.3 990 10 6 6

166.7 16079.0 1000 10 6 6

166.7 16245.6 1010 10 6 6

166.7 16412.3 1020 10 6 6

166.7 16579.0 1030 10 6 6

166.7 16745.6 1040 10 6 6

166.7 16912.3 1050 10 6 6

111.1 17023.4 1060 10 9 9

111.1 17134.5 1070 10 9 9

111.1 17245.6 1080 10 9 9

111.1 17356.7 1090 10 9 9

111.1 17467.9 1100 10 9 9

250.0 17717.9 1090 -10 -4 4

333.3 18051.2 1080 -10 -3 3

200.0 18251.2 1090 10 5 5

200.0 18451.2 1100 10 5 5

200.0 18651.2 1110 10 5 5

200.0 18851.2 1120 10 5 5

166.7 19017.9 1130 10 6 6

166.7 19184.5 1140 10 6 6

166.7 19351.2 1150 10 6 6

166.7 19517.9 1160 10 6 6

166.7 19684.5 1170 10 6 6

166.7 19851.2 1180 10 6 6

166.7 20017.9 1190 10 6 6

166.7 20184.5 1200 10 6 6

166.7 20351.2 1210 10 6 6

166.7 20517.9 1220 10 6 6

166.7 20684.5 1230 10 6 6

166.7 20851.2 1240 10 6 6

166.7 21017.9 1250 10 6 6

21017.9

Page 41: MET. DE BRUCE informe caminos I   2013.xlsx

0142.9

285.8428.7

571.6714.5

857.4

1000.3

1143.2

1286.11429

1571.9

1714.8

1857.7

2000.6

2143.5

2286.4

2429.3

2572.2

2715.12858

3000.9

3143.8

3286.7

3429.6

3572.5

3715.4

3858.3

4001.2

4144.14287

4429.9

4572.8

4715.7

4858.6

5001.5

5144.4

5287.3

5430.2

5573.15716

5858.9

6001.8

6144.7

6287.6

6430.5

6573.4

6716.3

6859.19999999999

7002.09999999999

7144.99999999999

7287.89999999999

7430.79999999999

7573.69999999999

7716.59999999999

7859.49999999999

8002.39999999999

8145.29999999999

8288.19999999999

8431.09999999999

8573.99999999999

8716.89999999999

8859.79999999999

9002.69999999999

9145.59999999999

9288.49999999999

9431.39999999999

9574.29999999999

9717.19999999999

9860.0999999999910003

10145.9

10288.8

10431.7

10574.6

10717.50

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 42: MET. DE BRUCE informe caminos I   2013.xlsx

0142.9

285.8428.7

571.6714.5

857.4

1000.3

1143.2

1286.11429

1571.9

1714.8

1857.7

2000.6

2143.5

2286.4

2429.3

2572.2

2715.12858

3000.9

3143.8

3286.7

3429.6

3572.5

3715.4

3858.3

4001.2

4144.14287

4429.9

4572.8

4715.7

4858.6

5001.5

5144.4

5287.3

5430.2

5573.15716

5858.9

6001.8

6144.7

6287.6

6430.5

6573.4

6716.3

6859.19999999999

7002.09999999999

7144.99999999999

7287.89999999999

7430.79999999999

7573.69999999999

7716.59999999999

7859.49999999999

8002.39999999999

8145.29999999999

8288.19999999999

8431.09999999999

8573.99999999999

8716.89999999999

8859.79999999999

9002.69999999999

9145.59999999999

9288.49999999999

9431.39999999999

9574.29999999999

9717.19999999999

9860.0999999999910003

10145.9

10288.8

10431.7

10574.6

10717.50

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 43: MET. DE BRUCE informe caminos I   2013.xlsx

CONTRAPENDIENTESXo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21

cota x

1050 250 250

0 10 1040 250 500

0 10 1030 125 625

0 10 1020 500 1125

10 0 1030 142.9 1267.9

10 0 1040 142.9 1410.7

0 10 1030 333.3 1744.0

0 10 1020 333.3 2077.4

10 0 1030 200 2277.4

10 0 1040 125 2402.4

0 10 1030 125 2527.4

10 0 1040 125 2652.4

10 0 1050 125 2777.4

10 0 1060 125 2902.4

0 10 1050 125 3027.4

0 10 1040 125 3152.4

0 10 1030 125 3277.4

0 10 1020 333.3 3610.7

0 10 1010 250 3860.7

0 10 1000 111.1 3971.8

0 10 990 111.1 4082.9

0 10 980 111.1 4194.0

0 10 970 111.1 4305.2

0 10 960 250 4555.2

0 10 950 250 4805.2

0 10 940 250 5055.2

0 10 930 666.7 5721.8

0 10 920 125 5846.8

0 10 910 125 5971.8

0 10 900 125 6096.8

0 10 890 125 6221.8

0 10 880 125 6346.8

0 10 870 125 6471.8

0 10 860 125 6596.8

0 10 850 250 6846.8

0 10 840 250 7096.8

10 0 850 200 7296.8

10 0 860 250 7546.8

10 0 870 166.7 7713.5

10 0 880 166.7 7880.2

Page 44: MET. DE BRUCE informe caminos I   2013.xlsx

0 10 870 166.7 8046.8

10 0 880 166.7 8213.5

10 0 890 166.7 8380.2

10 0 900 166.7 8546.8

10 0 910 166.7 8713.5

0 10 900 250 8963.5

10 0 910 200 9163.5

0 10 900 200 9363.5

0 10 890 166.7 9530.2

10 0 900 250 9780.2

10 0 910 166.7 9946.8

10 0 920 166.7 10113.5

10 0 930 111.1 10224.6

0 10 920 111.1 10335.7

0 10 910 111.1 10446.8

10 0 920 333.3 10780.2

0 10 910 200 10980.2

10 0 920 125 11105.2

10 0 930 125 11230.2

10 0 940 125 11355.2

10 0 950 125 11480.2

0 10 940 125 11605.2

0 10 930 166.7 11771.8

0 10 920 166.7 11938.5

10 0 930 166.7 12105.2

10 0 940 111.1 12216.3

10 0 950 111.1 12327.4

0 10 940 111.1 12438.5

0 10 930 166.7 12605.2

0 10 920 166.7 12771.8

0 10 910 500 13271.8

10 0 920 142.9 13414.7

10 0 930 142.9 13557.5

10 0 940 142.9 13700.4

10 0 950 142.9 13843.3

10 0 960 142.9 13986.1

10 0 970 166.7 14152.8

10 0 980 166.7 14319.4

0 10 970 166.7 14486.1

10 0 980 166.7 14652.8

0 10 970 200 14852.8

10 0 980 250 15102.8

10 0 990 142.9 15245.6

0 10 980 500 15745.6

Page 45: MET. DE BRUCE informe caminos I   2013.xlsx

10 0 990 166.7 15912.3

10 0 1000 166.7 16079.0

10 0 1010 166.7 16245.6

10 0 1020 166.7 16412.3

10 0 1030 166.7 16579.0

10 0 1040 166.7 16745.6

10 0 1050 166.7 16912.3

10 0 1060 111.1 17023.4

10 0 1070 111.1 17134.5

10 0 1080 111.1 17245.6

10 0 1090 111.1 17356.7

10 0 1100 111.1 17467.9

0 10 1090 250 17717.9

0 10 1080 333.3 18051.2

10 0 1090 200 18251.2

10 0 1100 200 18451.2

10 0 1110 200 18651.2

10 0 1120 200 18851.2

10 0 1130 166.7 19017.9

10 0 1140 166.7 19184.5

10 0 1150 166.7 19351.2

10 0 1160 166.7 19517.9

10 0 1170 166.7 19684.5

10 0 1180 166.7 19851.2

10 0 1190 166.7 20017.9

10 0 1200 166.7 20184.5

10 0 1210 166.7 20351.2

10 0 1220 166.7 20517.9

10 0 1230 166.7 20684.5

10 0 1240 166.7 20851.2

10 0 1250 166.7 21017.9

670 35087.8571 470 30887.8571

Page 46: MET. DE BRUCE informe caminos I   2013.xlsx

0142.9

285.8428.7

571.6714.5

857.4

1000.3

1143.2

1286.11429

1571.9

1714.8

1857.7

2000.6

2143.5

2286.4

2429.3

2572.2

2715.12858

3000.9

3143.8

3286.7

3429.6

3572.5

3715.4

3858.3

4001.2

4144.14287

4429.9

4572.8

4715.7

4858.6

5001.5

5144.4

5287.3

5430.2

5573.15716

5858.9

6001.8

6144.7

6287.6

6430.5

6573.4

6716.3

6859.19999999999

7002.09999999999

7144.99999999999

7287.89999999999

7430.79999999999

7573.69999999999

7716.59999999999

7859.49999999999

8002.39999999999

8145.29999999999

8288.19999999999

8431.09999999999

8573.99999999999

8716.89999999999

8859.79999999999

9002.69999999999

9145.59999999999

9288.49999999999

9431.39999999999

9574.29999999999

9717.19999999999

9860.0999999999910003

10145.9

10288.8

10431.7

10574.6

10717.50

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 47: MET. DE BRUCE informe caminos I   2013.xlsx

0142.9

285.8428.7

571.6714.5

857.4

1000.3

1143.2

1286.11429

1571.9

1714.8

1857.7

2000.6

2143.5

2286.4

2429.3

2572.2

2715.12858

3000.9

3143.8

3286.7

3429.6

3572.5

3715.4

3858.3

4001.2

4144.14287

4429.9

4572.8

4715.7

4858.6

5001.5

5144.4

5287.3

5430.2

5573.15716

5858.9

6001.8

6144.7

6287.6

6430.5

6573.4

6716.3

6859.19999999999

7002.09999999999

7144.99999999999

7287.89999999999

7430.79999999999

7573.69999999999

7716.59999999999

7859.49999999999

8002.39999999999

8145.29999999999

8288.19999999999

8431.09999999999

8573.99999999999

8716.89999999999

8859.79999999999

9002.69999999999

9145.59999999999

9288.49999999999

9431.39999999999

9574.29999999999

9717.19999999999

9860.0999999999910003

10145.9

10288.8

10431.7

10574.6

10717.50

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

Column F

LONGITUD

COTA

S

Page 48: MET. DE BRUCE informe caminos I   2013.xlsx

CONTRAPENDIENTESXo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21

-10 0 10

-10 0 10

-10 0 10

10 10 0

10 10 0

-10 0 10

-10 0 10

10 10 0

10 10 0

-10 0 10

10 10 0

10 10 0

10 10 0

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

-10 0 10

10 10 0

10 10 0

10 10 0

10 10 0

Page 49: MET. DE BRUCE informe caminos I   2013.xlsx

-10 0 10

10 10 0

10 10 0

10 10 0

10 10 0

-10 0 10

10 10 0

-10 0 10

-10 0 10

10 10 0

10 10 0

10 10 0

10 10 0

-10 0 10

-10 0 10

10 10 0

-10 0 10

10 10 0

10 10 0

10 10 0

10 10 0

-10 0 10

-10 0 10

-10 0 10

10 10 0

10 10 0

10 10 0

-10 0 10

-10 0 10

-10 0 10

-10 0 10

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

-10 0 10

10 10 0

-10 0 10

10 10 0

10 10 0

-10 0 10

Page 50: MET. DE BRUCE informe caminos I   2013.xlsx

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

-10 0 10

-10 0 10

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

10 10 0

Page 51: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCE

PUNTOS ABSCISA X COTAS YA K0+ 000.0 0 1050a1 K0+ 142,9 142.9 1050 0a2 K0+ 285,8 285.8 1060 10a3 K0+ 428,7 428.7 1070 10a4 K0+ 571,6 571.6 1080 10a5 K0+ 714,5 714.5 1090 10a6 K0+ 857,4 857.4 1100 10a7 K1+ 0,3 1000.3 1090 -10a8 K1+ 143,2 1143.2 1100 10a9 K1+ 286,1 1286.1 1110 10

a10 K1+ 429 1429 1120 10a11 K1+ 571,9 1571.9 1130 10a12 K1+ 714,8 1714.8 1140 10a13 K1+ 857,7 1857.7 1150 10a14 K2+ 0,6 2000.6 1160 10a15 K2+ 143,5 2143.5 1170 10a16 K2+ 286,4 2286.4 1180 10a17 K2+ 429,3 2429.3 1190 10a18 K2+ 572,2 2572.2 1200 10a19 K2+ 715,1 2715.1 1210 10a20 K2+ 858 2858 1220 10a21 K3+ 0,9 3000.9 1230 10a22 K3+ 143,8 3143.8 1240 10a23 K3+ 286,7 3286.7 1250 10a24 K3+ 429,6 3429.6 1240 -10a25 K3+ 572,5 3572.5 1250 10a26 K3+ 715,4 3715.4 1240 -10a27 K3+ 858,3 3858.3 1250 10a28 K4+ 1,2 4001.2 1240 -10a29 K4+ 144,1 4144.1 1230 -10a30 K4+ 287 4287 1240 10a31 K4+ 429,9 4429.9 1250 10a32 K4+ 572,8 4572.8 1260 10a33 K4+ 715,7 4715.7 1270 10a34 K4+ 858,6 4858.6 1280 10a35 K5+ 1,5 5001.5 1290 10a36 K5+ 144,4 5144.4 1300 10a37 K5+ 287,3 5287.3 1310 10a38 K5+ 430,2 5430.2 1320 10a39 K5+ 573,1 5573.1 1330 10

Page 52: MET. DE BRUCE informe caminos I   2013.xlsx

a40 K5+ 716 5716 1340 10a41 K5+ 858,9 5858.9 1350 10a42 K6+ 1,8 6001.8 1340 -10a43 K6+ 144,7 6144.7 1350 10a44 K6+ 287,6 6287.6 1360 10a45 K6+ 430,5 6430.5 1350 -10a46 K6+ 573,4 6573.4 1340 -10a47 K6+ 716,3 6716.3 1330 -10a48 K6+ 859,2 6859.2 1320 -10a49 K7+ 2,1 7002.1 1310 -10a50 K7+ 145 7145 1300 -10a51 K7+ 287,9 7287.9 1290 -10a52 K7+ 430,8 7430.8 1300 10a53 K7+ 573,7 7573.7 1310 10a54 K7+ 716,6 7716.6 1300 -10a55 K7+ 859,5 7859.5 1310 10a56 K8+ 2,4 8002.4 1320 10a57 K8+ 145,3 8145.3 1330 10a58 K8+ 288,2 8288.2 1340 10a59 K8+ 431,1 8431.1 1350 10a60 K8+ 574 8574 1360 10a61 K8+ 716,9 8716.9 1350 -10a62 K8+ 859,8 8859.8 1360 10a63 K9+ 2,7 9002.7 1350 -10a64 K9+ 145,6 9145.6 1340 -10a65 K9+ 288,5 9288.5 1350 10a66 K9+ 431,4 9431.4 1340 -10a67 K9+ 574,3 9574.3 1350 10a68 K9+ 717,2 9717.2 1360 10a69 K9+ 860,1 9860.1 1350 -10a70 K10+ 3 10003 1340 -10a71 K10+ 145,9 10145.9 1330 -10a72 K10+ 288,8 10288.8 1340 10a73 K10+ 431,7 10431.7 1330 -10a74 K10+ 574,6 10574.6 1320 -10a75 K10+ 717,5 10717.5 1310 -10a76 K10+ 860,4 10860.4 1300 -10a77 K11+ 3,3 11003.3 1290 -10a78 K11+ 146,2 11146.2 1280 -10a79 K11+ 289,1 11289.1 1270 -10a80 K11+ 432 11432 1260 -10a81 K11+ 574,9 11574.9 1250 -10a82 K11+ 717,8 11717.8 1240 -10a83 K11+ 860,7 11860.7 1230 -10

Page 53: MET. DE BRUCE informe caminos I   2013.xlsx

a84 K12+ 3,6 12003.6 1240 10a85 K12+ 146,5 12146.5 1250 10a86 K12+ 289,4 12289.4 1240 -10a87 K12+ 432,3 12432.3 1250 10a88 K12+ 575,2 12575.2 1260 10a89 K12+ 718,1 12718.1 1270 10a90 K12+ 861 12861 1260 -10a91 K13+ 3,9 13003.9 1270 10a92 K13+ 146,8 13146.8 1260 -10a93 K13+ 289,7 13289.7 1250 -10a94 K13+ 432,6 13432.6 1240 -10a95 K13+ 575,5 13575.5 1230 -10a96 K13+ 718,4 13718.4 1240 10a97 K13+ 861,3 13861.3 1250 10a98 K14+ 4,2 14004.2 1260 10a99 K14+ 147,1 14147.1 1270 10

a100 K14+ 290 14290 1260 -10a101 K14+ 432,9 14432.9 1270 10a102 K14+ 575,8 14575.8 1280 10a103 K14+ 718,7 14718.7 1290 10a104 K14+ 861,6 14861.6 1300 10a105 K15+ 4,5 15004.5 1310 10a106 K15+ 147,4 15147.4 1320 10a107 K15+ 290,3 15290.3 1330 10a108 K15+ 433,2 15433.2 1340 10a109 K15+ 576,1 15576.1 1350 10a110 K15+ 719 15719 1360 10a111 K15+ 861,9 15861.9 1370 10a112 K16+ 4,8 16004.8 1380 10a113 K16+ 147,7 16147.7 1390 10a114 K16+ 290,6 16290.6 1400 10a115 K16+ 433,5 16433.5 1410 10a116 K16+ 576,4 16576.4 1420 10a117 K16+ 719,3 16719.3 1430 10a118 K16+ 862,2 16862.2 1440 10a119 K17+ 5,1 17005.1 1450 10a120 K17+ 148 17148 1460 10a121 K17+ 290,9 17290.9 1470 10a122 K17+ 433,8 17433.8 1480 10a123 K17+ 576,7 17576.7 1490 10a124 K17+ 719,6 17719.6 1500 10a125 K17+ 862,5 17862.5 1510 10a126 K18+ 5,4 18005.4 1520 10a127 K18+ 148,3 18148.3 1530 10

Page 54: MET. DE BRUCE informe caminos I   2013.xlsx

a128 K18+ 291,2 18291.2 1540 10a129 K18+ 434,1 18434.1 1550 10a130 K18+ 577 18577 1540 -10a131 K18+ 719,9 18719.9 1550 10a132 K18+ 862,8 18862.8 1540 -10a133 K19+ 5,7 19005.7 1530 -10a134 K19+ 148,6 19148.6 1540 10a135 K19+ 291,5 19291.5 1530 -10a136 K19+ 434,4 19434.4 1520 -10a137 K19+ 577,3 19577.3 1510 -10a138 K19+ 577,4 19720.2 1500 -10a139 19863.1 1490 -10a140 20006 1480 -10a141 20148.9 1470 -10a142 20291.8 1480 10a143 20434.7 1490 10a144 20577.6 1480 -10a145 20720.5 1470 -10a146 20863.4 1460 -10a147 21006.3 1450 -10a148 21149.2 1440 -10a149 21292.1 1430 -10a150 21435 1420 -10a151 21577.9 1410 -10a152 21720.8 1400 -10a153 21863.7 1390 -10a154 22006.6 1380 -10a155 22149.5 1370 -10a156 22292.4 1360 -10a157 22435.3 1370 10a158 22578.2 1380 10a159 22721.1 1370 -10a160 22864 1360 -10a161 23006.9 1350 -10a162 23149.8 1340 -10a163 23292.7 1330 -10a164 23435.6 1320 -10a165 23578.5 1310 -10a166 23721.4 1300 -10a167 23864.3 1290 -10a168 24007.2 1280 -10a169 24150.1 1270 -10a170 24293 1260 -10a171 24435.9 1250 -10

Page 55: MET. DE BRUCE informe caminos I   2013.xlsx

a172 24578.8 1260 10a173 24721.7 1250 -10a174 K19+ 720,2 24864.6 1260 10

B K19+ 863,1 25007.5 1250 -10

25007.5

EVALUACION DE TRAZADO DE RUTAS

Xo= 57481,1 + 53521,1

Xo= 111002,2

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0 1286.1 2572.2 3858.3 5144.4 6430.5 7716.59999999999 9002.69999999999 10288.80

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

RUTA 3

LONGITUD

COTA

S

000.0 666.7 1333.3 2000.0 2666.7 3333.3 4000.0 4666.7 5333.3 6000.0 6666.7 7333.3 7944.4 8444.4 9254.0 9865.1 10531.7 11198.4 11865.1 12476.2 12920.6 13504.0 13948.4 14392.9 15039.7 15654.8 16194.4 16765.9 17242.1 17686.5 18269.8 19186.5 19979.4 20677.8 21350.0 21808.3 22633.3 23300.0 23966.7 24555.6 25088.9 25533.3 25977.8 26422.2700

900

1100

1300

1500

1700

1900

2100

2300

2500

2700

2900

3100

3300

3500

3700

3900

4100

4300

4500

4700

Chart Title

KEBINRUBENCHRISTIANLUCIA

Axis Title

C O

TAS

Page 56: MET. DE BRUCE informe caminos I   2013.xlsx

0 1286.1 2572.2 3858.3 5144.4 6430.5 7716.59999999999 9002.69999999999 10288.80

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

RUTA 3

LONGITUD

COTA

S

Page 57: MET. DE BRUCE informe caminos I   2013.xlsx

PUNTOSMETODO DE BRUCECONTRAPENDIENTES

PENDIENTE Xo=X+(K*∑Y) Xo=X+(K*∑Y) A

IDA K=21 REGRESO K=21 a1

0.00 0 0 a2

7.00 10 0 a3

7.00 10 0 a4

7.00 10 0 a5

7.00 10 0 a6

7.00 10 0 a7

-7.00 0 10 a8

7.00 10 0 a9

7.00 10 0 a10

7.00 10 0 a11

7.00 10 0 a12

7.00 10 0 a13

7.00 10 0 a14

7.00 10 0 a15

7.00 10 0 a16

7.00 10 0 a17

7.00 10 0 a18

7.00 10 0 a19

7.00 10 0 a20

7.00 10 0 a21

7.00 10 0 a22

7.00 10 0 a23

7.00 10 0 a24

-7.00 0 10 a25

7.00 10 0 a26

-7.00 0 10 a27

7.00 10 0 a28

-7.00 0 10 a29

-7.00 0 10 a30

7.00 10 0 a31

7.00 10 0 a32

7.00 10 0 a33

7.00 10 0 a34

7.00 10 0 a35

7.00 10 0 a36

7.00 10 0 a37

7.00 10 0 a38

7.00 10 0 a39

7.00 10 0 a40

Page 58: MET. DE BRUCE informe caminos I   2013.xlsx

7.00 10 0 a41

7.00 10 0 a42

-7.00 0 10 a43

7.00 10 0 a44

7.00 10 0 a45

-7.00 0 10 a46

-7.00 0 10 a47

-7.00 0 10 a48

-7.00 0 10 a49

-7.00 0 10 a50

-7.00 0 10 a51

-7.00 0 10 a52

7.00 10 0 a53

7.00 10 0 a54

-7.00 0 10 a55

7.00 10 0 a56

7.00 10 0 a57

7.00 10 0 a58

7.00 10 0 a59

7.00 10 0 a60

7.00 10 0 a61

-7.00 0 10 a62

7.00 10 0 a63

-7.00 0 10 a64

-7.00 0 10 a65

7.00 10 0 a66

-7.00 0 10 a67

7.00 10 0 a68

7.00 10 0 a69

-7.00 0 10 a70

-7.00 0 10 a71

-7.00 0 10 a72

7.00 10 0 a73

-7.00 0 10 a74

-7.00 0 10 a75

-7.00 0 10 a76

-7.00 0 10 a77

-7.00 0 10 a78

-7.00 0 10 a79

-7.00 0 10 a80

-7.00 0 10 a81

-7.00 0 10 a82

-7.00 0 10 a83

-7.00 0 10 a84

Page 59: MET. DE BRUCE informe caminos I   2013.xlsx

7.00 10 0 a85

7.00 10 0 a86

-7.00 0 10 a87

7.00 10 0 a88

7.00 10 0 a89

7.00 10 0 a90

-7.00 0 10 a91

7.00 10 0 a92

-7.00 0 10 a93

-7.00 0 10 a94

-7.00 0 10 a95

-7.00 0 10 a96

7.00 10 0 a97

7.00 10 0 a98

7.00 10 0 a99

7.00 10 0 a100

-7.00 0 10 a101

7.00 10 0 a102

7.00 10 0 a103

7.00 10 0 a104

7.00 10 0 a105

7.00 10 0 a106

7.00 10 0 a107

7.00 10 0 a108

7.00 10 0 a109

7.00 10 0 a110

7.00 10 0 a111

7.00 10 0 a112

7.00 10 0 a113

7.00 10 0 a114

7.00 10 0 a115

7.00 10 0 a116

7.00 10 0 a117

7.00 10 0 a118

7.00 10 0 a119

7.00 10 0 a120

7.00 10 0 a121

7.00 10 0 a122

7.00 10 0 a123

7.00 10 0 a124

7.00 10 0 a125

7.00 10 0 a126

7.00 10 0 a127

7.00 10 0 a128

Page 60: MET. DE BRUCE informe caminos I   2013.xlsx

7.00 10 0 a129

7.00 10 0 a130

-7.00 0 10 a131

7.00 10 0 a132

-7.00 0 10 a133

-7.00 0 10 a134

7.00 10 0 a135

-7.00 0 10 a136

-7.00 0 10 a137

-7.00 0 10 a138

-7.00 0 10 a139

-7.00 0 10 a140

-7.00 0 10 a141

-7.00 0 10 a142

7.00 10 0 a143

7.00 10 0 a144

-7.00 0 10 a145

-7.00 0 10 a146

-7.00 0 10 a147

-7.00 0 10 a148

-7.00 0 10 a149

-7.00 0 10 a150

-7.00 0 10 a151

-7.00 0 10 a152

-7.00 0 10 a153

-7.00 0 10 a154

-7.00 0 10 a155

-7.00 0 10 a156

-7.00 0 10 a157

7.00 10 0 a158

7.00 10 0 a159

-7.00 0 10 a160

-7.00 0 10 a161

-7.00 0 10 a162

-7.00 0 10 a163

-7.00 0 10 a164

-7.00 0 10 a165

-7.00 0 10 a166

-7.00 0 10 a167

-7.00 0 10 a168

-7.00 0 10 a169

-7.00 0 10 a170

-7.00 0 10 a171

-7.00 0 10 a172

Page 61: MET. DE BRUCE informe caminos I   2013.xlsx

7.00 10 0 a173

-7.00 0 10 a174

7.00 10 0 B

-7.00 0 10

970 45377.5 770 41177.5

EVALUACION DE TRAZADO DE RUTAS

Xo= 57481,1 + 53521,1

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0 1286.1 2572.2 3858.3 5144.4 6430.5 7716.59999999999 9002.69999999999 10288.80

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

RUTA 3

LONGITUD

COTA

S

000.0 666.7 1333.3 2000.0 2666.7 3333.3 4000.0 4666.7 5333.3 6000.0 6666.7 7333.3 7944.4 8444.4 9254.0 9865.1 10531.7 11198.4 11865.1 12476.2 12920.6 13504.0 13948.4 14392.9 15039.7 15654.8 16194.4 16765.9 17242.1 17686.5 18269.8 19186.5 19979.4 20677.8 21350.0 21808.3 22633.3 23300.0 23966.7 24555.6 25088.9 25533.3 25977.8 26422.2700

900

1100

1300

1500

1700

1900

2100

2300

2500

2700

2900

3100

3300

3500

3700

3900

4100

4300

4500

4700

Chart Title

KEBINRUBENCHRISTIANLUCIA

Axis Title

C O

TAS

Page 62: MET. DE BRUCE informe caminos I   2013.xlsx

0 1286.1 2572.2 3858.3 5144.4 6430.5 7716.59999999999 9002.69999999999 10288.80

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

RUTA 3

LONGITUD

COTA

S

Page 63: MET. DE BRUCE informe caminos I   2013.xlsx

ABCISA X COTA Y PENDIENTE

CONTRAPENDIENTES

Xo=X+(K*∑Y)

IDA

K0+000.0 000.0

K0+166,67 166.7 166.7 1050 6 6

K0+333,33 166.7 333.3 1060 10 6 6 10

K0+500,00 166.7 500.0 1070 10 6 6 10

K0+666,67 166.7 666.7 1080 10 6 6 10

K0+833,33 166.7 833.3 1090 10 6 6 10

K1+000,00 166.7 1000.0 1100 10 6 6 10

K1+166,67 166.7 1166.7 1090 -10 -6 6 0

K1+333,33 166.7 1333.3 1100 10 6 6 10

K1+500,00 166.7 1500.0 1110 10 6 6 10

K1+666,67 166.7 1666.7 1120 10 6 6 10

K1+833,33 166.7 1833.3 1130 10 6 6 10

K2+000,00 166.7 2000.0 1140 10 6 6 10

K2+166,67 166.7 2166.7 1150 10 6 6 10

K2+333,33 166.7 2333.3 1160 10 6 6 10

K2+500,00 166.7 2500.0 1170 10 6 6 10

K2+666,67 166.7 2666.7 1180 10 6 6 10

K2+833,33 166.7 2833.3 1190 10 6 6 10

K3+000,00 166.7 3000.0 1200 10 6 6 10

K3+166,67 166.7 3166.7 1210 10 6 6 10

K3+333,33 166.7 3333.3 1220 10 6 6 10

K3+500,00 166.7 3500.0 1230 10 6 6 10

K3+666,67 166.7 3666.7 1240 10 6 6 10

K3+833,33 166.7 3833.3 1250 10 6 6 10

K4+000,00 166.7 4000.0 1240 -10 -6 6 0

K4+166,67 166.7 4166.7 1250 10 6 6 10

K4+333,33 166.7 4333.3 1240 -10 -6 6 0

K4+500,00 166.7 4500.0 1250 10 6 6 10

K4+666,67 166.7 4666.7 1240 -10 -6 6 0

K4+833,33 166.7 4833.3 1230 -10 -6 6 0

K5+000,00 166.7 5000.0 1240 10 6 6 10

K5+166,67 166.7 5166.7 1250 10 6 6 10

K5+333,33 166.7 5333.3 1260 10 6 6 10

K5+500,00 166.7 5500.0 1270 10 6 6 10

K5+666,67 166.7 5666.7 1280 10 6 6 10

K5+833,33 166.7 5833.3 1290 10 6 6 10

K6+000,00 166.7 6000.0 1300 10 6 6 10

K6+166,67 166.7 6166.7 1310 10 6 6 10

K6+333,33 166.7 6333.3 1320 10 6 6 10

K6+500,00 166.7 6500.0 1330 10 6 6 10

K6+666,67 166.7 6666.7 1340 10 6 6 10

Page 64: MET. DE BRUCE informe caminos I   2013.xlsx

K6+833,33 166.7 6833.3 1350 10 6 6 10

K7+000,00 166.7 7000.0 1340 -10 -6 6 0

K7+166,67 166.7 7166.7 1350 10 6 6 10

K7+333,33 166.7 7333.3 1360 10 6 6 10

K7+500,00 166.7 7500.0 1350 -10 -6 6 0

K7+666,67 166.7 7666.7 1340 -10 -6 6 0

K7+833,33 166.7 7833.3 1330 -10 -6 6 0

K7+944,44 111.1 7944.4 1320 -10 -9 9 0

K8+055,56 111.1 8055.6 1310 -10 -9 9 0

K8+166,67 111.1 8166.7 1300 -10 -9 9 0

K8+277,78 111.1 8277.8 1290 -10 -9 9 0

K8+444,44 166.7 8444.4 1300 10 6 6 10

K8+587,30 142.9 8587.3 1310 10 7 7 10

K8+753,97 166.7 8754.0 1300 -10 -6 6 0

K8+920,63 166.7 8920.6 1310 10 6 6 10

K9+253,97 333.3 9254.0 1320 10 3 3 10

K9+420,63 166.7 9420.6 1330 10 6 6 10

K9+587,30 166.7 9587.3 1340 10 6 6 10

K9+698,41 111.1 9698.4 1350 10 9 9 10

K9+865,08 166.7 9865.1 1360 10 6 6 10

K10+031,75 166.7 10031.7 1350 -10 -6 6 0

K10+198,41 166.7 10198.4 1360 10 6 6 10

K10+365,08 166.7 10365.1 1350 -10 -6 6 0

K10+531,75 166.7 10531.7 1340 -10 -6 6 0

K10+698,41 166.7 10698.4 1350 10 6 6 10

K10+865,08 166.7 10865.1 1340 -10 -6 6 0

K11+031,75 166.7 11031.7 1350 10 6 6 10

K11+198,41 166.7 11198.4 1360 10 6 6 10

K11+365,08 166.7 11365.1 1350 -10 -6 6 0

K11+531,75 166.7 11531.7 1340 -10 -6 6 0

K11+698,41 166.7 11698.4 1330 -10 -6 6 0

K11+865,08 166.7 11865.1 1340 10 6 6 10

K12+031,75 166.7 12031.7 1330 -10 -6 6 0

K12+198,41 166.7 12198.4 1320 -10 -6 6 0

K12+309,52 111.1 12309.5 1310 -10 -9 9 0

K12+476,19 166.7 12476.2 1300 -10 -6 6 0

K12+587,30 111.1 12587.3 1290 -10 -9 9 0

K12+698,41 111.1 12698.4 1280 -10 -9 9 0

K12+809,52 111.1 12809.5 1270 -10 -9 9 0

K12+920,63 111.1 12920.6 1260 -10 -9 9 0

K13+031,75 111.1 13031.7 1250 -10 -9 9 0

K13+142,86 111.1 13142.9 1240 -10 -9 9 0

K13+392,86 250.0 13392.9 1230 -10 -4 4 0

K13+503,97 111.1 13504.0 1240 10 9 9 10

Page 65: MET. DE BRUCE informe caminos I   2013.xlsx

K13+615,08 111.1 13615.1 1250 10 9 9 10

K13+726,19 111.1 13726.2 1240 -10 -9 9 0

K13+837,30 111.1 13837.3 1250 10 9 9 10

K13+948,41 111.1 13948.4 1260 10 9 9 10

K14+059,52 111.1 14059.5 1270 10 9 9 10

K14+170,63 111.1 14170.6 1260 -10 -9 9 0

K14+281,75 111.1 14281.7 1270 10 9 9 10

K14+392,86 111.1 14392.9 1260 -10 -9 9 0

K14+503,97 111.1 14504.0 1250 -10 -9 9 0

K14+753,97 250.0 14754.0 1240 -10 -4 4 0

K14+896,83 142.9 14896.8 1230 -10 -7 7 0

K15+039,68 142.9 15039.7 1240 10 7 7 10

K15+182,54 142.9 15182.5 1250 10 7 7 10

K15+432,54 250.0 15432.5 1260 10 4 4 10

K15+543,65 111.1 15543.7 1270 10 9 9 10

K15+654,76 111.1 15654.8 1260 -10 -9 9 0

K15+765,87 111.1 15765.9 1270 10 9 9 10

K15+908,73 142.9 15908.7 1280 10 7 7 10

K16+051,59 142.9 16051.6 1290 10 7 7 10

K16+194,44 142.9 16194.4 1300 10 7 7 10

K16+337,30 142.9 16337.3 1310 10 7 7 10

K16+480,16 142.9 16480.2 1320 10 7 7 10

K16+623,02 142.9 16623.0 1330 10 7 7 10

K16+765,87 142.9 16765.9 1340 10 7 7 10

K16+908,73 142.9 16908.7 1350 10 7 7 10

K17+019,84 111.1 17019.8 1360 10 9 9 10

K17+130,95 111.1 17131.0 1370 10 9 9 10

K17+242,06 111.1 17242.1 1380 10 9 9 10

K17+353,17 111.1 17353.2 1390 10 9 9 10

K17+464,29 111.1 17464.3 1400 10 9 9 10

K17+575,40 111.1 17575.4 1410 10 9 9 10

K17+686,51 111.1 17686.5 1420 10 9 9 10

K17+797,62 111.1 17797.6 1430 10 9 9 10

K17+908,73 111.1 17908.7 1440 10 9 9 10

K18+019,84 111.1 18019.8 1450 10 9 9 10

K18+269,84 250.0 18269.8 1460 10 4 4 10

K18+519,84 250.0 18519.8 1470 10 4 4 10

K18+686,51 166.7 18686.5 1480 10 6 6 10

K18+936,51 250.0 18936.5 1490 10 4 4 10

K19+186,51 250.0 19186.5 1500 10 4 4 10

K19+436,51 250.0 19436.5 1510 10 4 4 10

K19+636,51 200.0 19636.5 1520 10 5 5 10

K19+836,51 200.0 19836.5 1530 10 5 5 10

K19+979,37 142.9 19979.4 1540 10 7 7 10

Page 66: MET. DE BRUCE informe caminos I   2013.xlsx

K20+122,22 142.9 20122.2 1550 10 7 7 10

K20+233,33 111.1 20233.3 1540 -10 -9 9 0

K20+566,67 333.3 20566.7 1550 10 3 3 10

K20+677,78 111.1 20677.8 1540 -10 -9 9 0

K20+788,89 111.1 20788.9 1530 -10 -9 9 0

K21+038,89 250.0 21038.9 1540 10 4 4 10

K21+150,00 111.1 21150.0 1530 -10 -9 9 0

K21+350,00 200.0 21350.0 1520 -10 -5 5 0

K21+475,00 125.0 21475.0 1510 -10 -8 8 0

K21+586,11 111.1 21586.1 1500 -10 -9 9 0

K21+697,22 111.1 21697.2 1490 -10 -9 9 0

K21+808,33 111.1 21808.3 1480 -10 -9 9 0

K22+008,33 200.0 22008.3 1470 -10 -5 5 0

K22+133,33 125.0 22133.3 1480 10 8 8 10

K22+383,33 250.0 22383.3 1490 10 4 4 10

K22+633,33 250.0 22633.3 1480 -10 -4 4 0

K22+744,44 111.1 22744.4 1470 -10 -9 9 0

K22+855,56 111.1 22855.6 1460 -10 -9 9 0

K23+188,89 333.3 23188.9 1450 -10 -3 3 0

K23+300,00 111.1 23300.0 1440 -10 -9 9 0

K23+411,11 111.1 23411.1 1430 -10 -9 9 0

K23+744,44 333.3 23744.4 1420 -10 -3 3 0

K23+855,56 111.1 23855.6 1410 -10 -9 9 0

K23+966,67 111.1 23966.7 1400 -10 -9 9 0

K24+077,78 111.1 24077.8 1390 -10 -9 9 0

K24+277,78 200.0 24277.8 1380 -10 -5 5 0

K24+388,89 111.1 24388.9 1370 -10 -9 9 0

K24+555,56 166.7 24555.6 1360 -10 -6 6 0

K24+755,56 200.0 24755.6 1370 10 5 5 10

K24+866,67 111.1 24866.7 1380 10 9 9 10

K24+977,78 111.1 24977.8 1370 -10 -9 9 0

K25+088,89 111.1 25088.9 1360 -10 -9 9 0

K25+200,00 111.1 25200.0 1350 -10 -9 9 0

K25+311,11 111.1 25311.1 1340 -10 -9 9 0

K25+422,22 111.1 25422.2 1330 -10 -9 9 0

K25+533,33 111.1 25533.3 1320 -10 -9 9 0

K25+644,44 111.1 25644.4 1310 -10 -9 9 0

K25+755,56 111.1 25755.6 1300 -10 -9 9 0

K25+866,67 111.1 25866.7 1290 -10 -9 9 0

K25+977,78 111.1 25977.8 1280 -10 -9 9 0

K26+088,89 111.1 26088.9 1270 -10 -9 9 0

K26+200,00 111.1 26200.0 1260 -10 -9 9 0

K26+311,11 111.1 26311.1 1250 -10 -9 9 0

K26+422,22 111.1 26422.2 1260 10 9 9 10

Page 67: MET. DE BRUCE informe caminos I   2013.xlsx

K26+533,33 111.1 26533.3 1250 -10 -9 9 0

K26+644,44 111.1 26644.4 1260 10 9 9 10

K26+755,56 111.1 26755.6 1250 -10 -9 9 0

26755.6 970

0 1286.1 2572.2 3858.3 5144.4 6430.5 7716.59999999999 9002.69999999999 10288.80

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

RUTA 3

LONGITUD

COTA

S

000.0 666.7 1333.3 2000.0 2666.7 3333.3 4000.0 4666.7 5333.3 6000.0 6666.7 7333.3 7944.4 8444.4 9254.0 9865.1 10531.7 11198.4 11865.1 12476.2 12920.6 13504.0 13948.4 14392.9 15039.7 15654.8 16194.4 16765.9 17242.1 17686.5 18269.8 19186.5 19979.4 20677.8 21350.0 21808.3 22633.3 23300.0 23966.7 24555.6 25088.9 25533.3 25977.8 26422.2700

900

1100

1300

1500

1700

1900

2100

2300

2500

2700

2900

3100

3300

3500

3700

3900

4100

4300

4500

4700

Chart Title

KEBINRUBENCHRISTIANLUCIA

Axis Title

C O

TAS

Page 68: MET. DE BRUCE informe caminos I   2013.xlsx

0 1286.1 2572.2 3858.3 5144.4 6430.5 7716.59999999999 9002.69999999999 10288.80

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

RUTA 3

LONGITUD

COTA

S

Page 69: MET. DE BRUCE informe caminos I   2013.xlsx

CONTRAPENDIENTES

Xo=X+(K*∑Y) Xo=X+(K*∑Y)

K=21 REGRESO K=21

cota x

1050 166.666667 166.666667

0 1040 166.666667 333.333333 -10

0 1030 166.666667 500 -10

0 1020 166.666667 666.666667 -10

0 1030 166.7 833.3 10

0 1040 166.7 1000.0 10

10 1030 166.7 1166.7 -10

0 1040 166.7 1333.3 10

0 1050 166.666667 1500.0 10

0 1060 166.666667 1666.7 10

0 1070 166.666667 1833.3 10

0 1080 166.666667 2000.0 10

0 1090 166.666667 2166.7 10

0 1100 166.666667 2333.3 10

0 1110 166.666667 2500.0 10

0 1120 166.666667 2666.7 10

0 1130 166.666667 2833.3 10

0 1140 166.7 3000.0 10

0 1150 166.666667 3166.7 10

0 1160 166.7 3333.3 10

0 1170 166.7 3500.0 10

0 1180 166.7 3666.7 10

0 1190 166.7 3833.3 10

10 1180 166.666667 4000.0 -10

0 1190 166.666667 4166.7 10

10 1180 166.666667 4333.3 -10

0 1190 166.7 4500.0 10

10 1180 166.666667 4666.7 -10

10 1170 166.666667 4833.3 -10

0 1180 166.666667 5000.0 10

0 1190 166.666667 5166.7 10

0 1200 166.666667 5333.3 10

0 1210 166.666667 5500.0 10

0 1220 166.666667 5666.7 10

0 1230 166.666667 5833.3 10

0 1240 166.666667 6000.0 10

0 1250 166.666667 6166.7 10

0 1260 166.666667 6333.3 10

0 1270 166.7 6500.0 10

0 1280 166.7 6666.7 10

Page 70: MET. DE BRUCE informe caminos I   2013.xlsx

0 1290 166.7 6833.3 10

10 1280 166.7 7000.0 -10

0 1290 166.7 7166.7 10

0 1300 166.7 7333.3 10

10 1290 166.7 7500.0 -10

10 1280 166.666667 7666.7 -10

10 1270 166.666667 7833.3 -10

10 1260 111.111111 7944.4 -10

10 1250 111.1 8055.6 -10

10 1240 111.111111 8166.7 -10

10 1230 111.1 8277.8 -10

0 1240 166.7 8444.4 10

0 1250 142.9 8587.3 10

10 1240 166.7 8754.0 -10

0 1250 166.7 8920.6 10

0 1260 333.3 9254.0 10

0 1270 166.666667 9420.6 10

0 1280 166.666667 9587.3 10

0 1290 111.111111 9698.4 10

0 1300 166.666667 9865.1 10

10 1290 166.666667 10031.7 -10

0 1300 166.666667 10198.4 10

10 1290 166.7 10365.1 -10

10 1280 166.7 10531.7 -10

0 1290 166.7 10698.4 10

10 1280 166.7 10865.1 -10

0 1290 166.7 11031.7 10

0 1300 166.7 11198.4 10

10 1290 166.7 11365.1 -10

10 1280 166.7 11531.7 -10

10 1270 166.666667 11698.4 -10

0 1280 166.7 11865.1 10

10 1270 166.7 12031.7 -10

10 1260 166.7 12198.4 -10

10 1250 111.1 12309.5 -10

10 1240 166.7 12476.2 -10

10 1230 111.1 12587.3 -10

10 1220 111.1 12698.4 -10

10 1210 111.1 12809.5 -10

10 1200 111.1 12920.6 -10

10 1190 111.111111 13031.7 -10

10 1180 111.111111 13142.9 -10

10 1170 250.0 13392.9 -10

0 1180 111.111111 13504.0 10

Page 71: MET. DE BRUCE informe caminos I   2013.xlsx

0 1190 111.1 13615.1 10

10 1180 111.1 13726.2 -10

0 1190 111.1 13837.3 10

0 1200 111.1 13948.4 10

0 1210 111.1 14059.5 10

10 1200 111.1 14170.6 -10

0 1210 111.1 14281.7 10

10 1200 111.1 14392.9 -10

10 1190 111.1 14504.0 -10

10 1180 250.0 14754.0 -10

10 1170 142.9 14896.8 -10

0 1180 142.9 15039.7 10

0 1190 142.857143 15182.5 10

0 1200 250.0 15432.5 10

0 1210 111.111111 15543.7 10

10 1200 111.111111 15654.8 -10

0 1210 111.111111 15765.9 10

0 1220 142.857143 15908.7 10

0 1230 142.9 16051.6 10

0 1240 142.9 16194.4 10

0 1250 142.9 16337.3 10

0 1260 142.9 16480.2 10

0 1270 142.9 16623.0 10

0 1280 142.9 16765.9 10

0 1290 142.9 16908.7 10

0 1300 111.1 17019.8 10

0 1310 111.1 17131.0 10

0 1320 111.1 17242.1 10

0 1330 111.1 17353.2 10

0 1340 111.1 17464.3 10

0 1350 111.1 17575.4 10

0

0

0

0

0

0

0

0

0

0

0

0

0

Page 72: MET. DE BRUCE informe caminos I   2013.xlsx

0

10

0

10

10

0

10

10

10

10

10

10

10

0

0

10

10

10

10

10

10

10

10

10

10

10

10

10

0

0

10

10

10

10

10

10

10

10

10

10

10

10

10

0

Page 73: MET. DE BRUCE informe caminos I   2013.xlsx

10

0

10

47125.5556 770 42925.5556

0 1286.1 2572.2 3858.3 5144.4 6430.5 7716.59999999999 9002.69999999999 10288.80

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

RUTA 3

LONGITUD

COTA

S

000.0 666.7 1333.3 2000.0 2666.7 3333.3 4000.0 4666.7 5333.3 6000.0 6666.7 7333.3 7944.4 8444.4 9254.0 9865.1 10531.7 11198.4 11865.1 12476.2 12920.6 13504.0 13948.4 14392.9 15039.7 15654.8 16194.4 16765.9 17242.1 17686.5 18269.8 19186.5 19979.4 20677.8 21350.0 21808.3 22633.3 23300.0 23966.7 24555.6 25088.9 25533.3 25977.8 26422.2700

900

1100

1300

1500

1700

1900

2100

2300

2500

2700

2900

3100

3300

3500

3700

3900

4100

4300

4500

4700

Chart Title

KEBINRUBENCHRISTIANLUCIA

Axis Title

C O

TAS

Page 74: MET. DE BRUCE informe caminos I   2013.xlsx

0 1286.1 2572.2 3858.3 5144.4 6430.5 7716.59999999999 9002.69999999999 10288.80

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

ESTUDIO DE RUTA

RUTA 3

LONGITUD

COTA

S

Page 75: MET. DE BRUCE informe caminos I   2013.xlsx

CONTRAPENDIENTESXo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21 6

-4

0 10 -9

0 10 -3

0 10 -2

10 0 -6

10 0 -9

0 10 -9

10 0 -9

10 0 -4

10 0 2

10 0 -6

10 0 -6

10 0 -9

10 0 -5

10 0 -6

10 0 -6

10 0 -1

10 0 -4

10 0 -5

10 0 -4

10 0 -4

10 0 3

10 0 9

0 10 9

10 0 9

0 10 9

10 0 9

0 10 -3

0 10 -3

10 0 9

10 0 3

10 0 8

10 0 6

10 0 8

10 0 8

10 0 8

10 0 8

10 0 5

10 0 6

10 0 5

Page 76: MET. DE BRUCE informe caminos I   2013.xlsx

10 0 6

0 10 1.43

10 0 -5

10 0 5

0 10 -3

0 10 6

0 10 -2

0 10 6

0 10 6

0 10 6

0 10 -6

10 0 6

10 0 6

0 10 6

10 0 8

10 0 8

10 0 8

10 0 8

10 0 9

10 0 6

0 10 5

10 0 8

0 10 9

0 10 8

10 0 5

0 10 8

10 0 8

10 0 6

0 10 9

0 10 9

0 10 8

10 0 5

0 10 5

0 10 9

0 10 6

0 10 4

0 10 -5

0 10 3

0 10 -2

0 10

0 10

0 10

0 10

10 0

Page 77: MET. DE BRUCE informe caminos I   2013.xlsx

10 0

0 10

10 0

10 0

10 0

0 10

10 0

0 10

0 10

0 10

0 10

10 0

10 0

10 0

10 0

0 10

10 0

10 0

10 0

10 0

10 0

10 0

10 0

10 0

10 0

10 0

10 0

10 0

10 0

10 0

10 0

Page 78: MET. DE BRUCE informe caminos I   2013.xlsx

000.0 666.7 1333.3 2000.0 2666.7 3333.3 4000.0 4666.7 5333.3 6000.0 6666.7 7333.3 7944.4 8444.4 9254.0 9865.1 10531.7 11198.4 11865.1 12476.2 12920.6 13504.0 13948.4 14392.9 15039.7 15654.8 16194.4 16765.9 17242.1 17686.5 18269.8 19186.5 19979.4 20677.8 21350.0 21808.3 22633.3 23300.0 23966.7 24555.6 25088.9 25533.3 25977.8 26422.2700

900

1100

1300

1500

1700

1900

2100

2300

2500

2700

2900

3100

3300

3500

3700

3900

4100

4300

4500

4700

Chart Title

KEBINRUBENCHRISTIANLUCIA

Axis Title

C O

TAS

Page 79: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCE

PUNTOS ABSCISA X COTAS

A K0+ 000.0 0 43501 K0+ 210 1050 43002 K0+ 420 2100 43503 K0+ 630 3150 43004 K0+ 420 4200 43505 K0+ 210 5250 44006 K0+ 420 6300 44507 K1+ 210 7350 44008 K1+ 420 8400 43509 K1+ 210 9450 4300

10 K1+ 420 10500 425011 K1+ 210 11550 420012 K1+ 0 12600 415013 K1+ 210 13650 410014 K2+ 420 14700 405015 K2+ 630 15750 400016 K2+ 420 16800 395017 K2+ 210 17850 400018 K2+ 0 18900 405019 K3+ 210 19950 410020 K3+ 420 21000 415021 K3+ 630 22050 420022 K3+ 840 23100 425023 K3+ 1050 24150 430024 K3+ 840 25200 425025 K3+ 1050 26250 420026 K3+ 1260 27300 415027 K3+ 1050 28350 410028 K4+ 1260 29400 405029 K4+ 1050 30450 400030 K4+ 1260 31500 395031 K4+ 1470 32550 390032 K4+ 1680 33600 385033 K4+ 1890 34650 380034 K4+ 2100 35700 375035 K5+ 1890 36750 370036 K5+ 1680 37800 365037 K5+ 1890 38850 360038 K5+ 2100 39900 355039 K5+ 2310 40950 360040 K5+ 2100 42000 365041 K5+ 1890 43050 3700

Page 80: MET. DE BRUCE informe caminos I   2013.xlsx

42 K6+ 1860 44100 375043 K6+ 1890 45150 380044 K6+ 2100 46200 3850

46200

EVALUACION DE TRAZADO DE RUTAS

Xo= 264600 + 260400

Xo= 525000

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0 5000 10000 15000 20000 25000 30000 35000 40000 45000 500000

500100015002000250030003500400045005000

ROLANDO

COTAS

Page 81: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCECONTRAPENDIENTES

Y PENDIENTE Xo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21

-50 -5 0 5050 3 50 0-50 -4 0 5050 4 50 050 2 50 050 4 50 0-50 -5 0 50-50 -4 0 50-50 -6 0 50-50 -8 0 50-50 -3 0 50-50 -3 0 50-50 -4 0 50-50 -4 0 50-50 -8 0 50-50 -7 0 5050 6 50 050 8 50 050 5 50 050 7 50 050 8 50 050 7 50 050 5 50 0-50 -7 0 50-50 -6 0 50-50 -7 0 50-50 -6 0 50-50 -7 0 50-50 -4 0 50-50 -5 0 50-50 -7 0 50-50 -7 0 50-50 -8 0 50-50 -6 0 50-50 -7 0 50-50 -6 0 50-50 -6 0 50-50 -7 0 5050 8 50 050 8 50 050 5 50 0

Page 82: MET. DE BRUCE informe caminos I   2013.xlsx

50 7 50 050 9 50 050 9 50 0

850 64050 1350 74550

EVALUACION DE TRAZADO DE RUTAS

Xo= 264600 + 260400

Xo= 525000

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0 5000 10000 15000 20000 25000 30000 35000 40000 45000 500000

500100015002000250030003500400045005000

ROLANDO

COTAS

Page 83: MET. DE BRUCE informe caminos I   2013.xlsx

>

Page 84: MET. DE BRUCE informe caminos I   2013.xlsx

0 5000 10000 15000 20000 25000 30000 35000 40000 45000 500000

500100015002000250030003500400045005000

ROLANDO

COTAS

Page 85: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCE

PUNTOS ABSCISA X COTAS

A K0+ 000.0 0 43501 K0+ 210 1050 44002 K0+ 420 2100 43503 K0+ 630 3150 44004 K0+ 420 4200 43505 K0+ 210 5250 44006 K0+ 420 6300 43507 K1+ 210 7350 44008 K1+ 420 8400 44509 K1+ 210 9450 4500

10 K1+ 420 10500 455011 K1+ 210 11550 450012 K1+ 0 12600 445013 K1+ 210 13650 440014 K2+ 420 14700 435015 K2+ 630 15750 430016 K2+ 420 16800 425017 K2+ 210 17850 420018 K2+ 0 18900 425019 K3+ 210 19950 430020 K3+ 420 21000 425021 K3+ 630 22050 430022 K3+ 840 23100 435023 K3+ 1050 24150 440024 K3+ 840 25200 445025 K3+ 1050 26250 440026 K3+ 1260 27300 435027 K3+ 1050 28350 430028 K4+ 1260 29400 425029 K4+ 1050 30450 420030 K4+ 1260 31500 415031 K4+ 1470 32550 410032 K4+ 1680 33600 405033 K4+ 1890 34650 400034 K4+ 2100 35700 395035 K5+ 1890 36750 390036 K5+ 1680 37800 385037 K5+ 1890 38850 380038 K5+ 2100 39900 375039 K5+ 2310 40950 370040 K5+ 2100 42000 365041 K5+ 1890 43050 3600

Page 86: MET. DE BRUCE informe caminos I   2013.xlsx

42 K6+ 1860 44100 365043 K6+ 1890 45150 370044 K6+ 2100 46200 375045 K6+ 2101 47250 380046 K6+ 2102 48300 385048 48300

EVALUACION DE TRAZADO DE RUTAS

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0 10000 20000 30000 40000 50000 600000

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

COTAS

JORDY

Page 87: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCECONTRAPENDIENTES

Y PENDIENTE Xo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21

50 6 50 0-50 -7 0 5050 4 50 0-50 -4 0 5050 3 50 0-50 -3 0 5050 3 50 050 3 50 050 3 50 050 7 50 0-50 -8 0 50-50 -8 0 50-50 -5 0 50-50 -8 0 50-50 -7 0 50-50 -7 0 50-50 -5 0 5050 6 50 050 6 50 0-50 -5 0 5050 4 50 050 8 50 050 7 50 050 6 50 0-50 -5 0 50-50 -3 0 50-50 -6 0 50-50 -7 0 50-50 -8 0 50-50 -8 0 50 *-50 -8 0 50-50 -8 0 50-50 -9 0 50-50 -6 0 50-50 -6 0 50-50 -7 0 50-50 -5 0 50-50 -8 0 50-50 -7 0 50-50 -8 0 50-50 -8 0 50

Page 88: MET. DE BRUCE informe caminos I   2013.xlsx

50 7 50 050 6 50 050 9 50 050 8 50 050 6 50 0

900 67200 1400 77700

EVALUACION DE TRAZADO DE RUTAS

X0 0

Xo=X+(K*∑Y)

Xo=Xo(Ida) + Xo(Regreso)

0 10000 20000 30000 40000 50000 600000

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

COTAS

JORDY

Page 89: MET. DE BRUCE informe caminos I   2013.xlsx

>

Page 90: MET. DE BRUCE informe caminos I   2013.xlsx

TIPO DE SUPERFICIE KAfirmado 21Tratamiento superficial 32Carpeta asfaltica 35Pavimento en concreto 44

Page 91: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCECONTRAPENDIENTES

PUNTOS ABSCISA X COTAS Y PENDIENTE Xo=X+(K*∑Y)

A K0+ 000.0 0 4350 IDA 1 K0+ 210 1050 4300 -50 -5 02 K0+ 420 2100 4350 50 3 503 K0+ 630 3150 4400 50 4 504 K0+ 420 4200 4450 50 9 505 K0+ 210 5250 4400 -50 -5 06 K0+ 420 6300 4450 50 5 507 K1+ 210 7350 4400 -50 -8 08 K1+ 420 8400 4350 -50 -5 09 K1+ 210 9450 4400 50 7 50

10 K1+ 420 10500 4350 -50 -5 011 K1+ 421 11550 4400 50 4 5012 K1+ 210 11550 4300 -50 -6 013 K1+ 0 12600 4350 50 3 5014 K1+ 210 13650 4400 50 2 5015 K2+ 420 14700 4450 50 3 5016 K2+ 630 15750 4400 -50 -9 017 K2+ 420 16800 4350 -50 -5 018 K2+ 210 17850 4300 -50 -4 019 K2+ 0 18900 4350 50 6 5020 K3+ 210 19950 4400 50 6 5021 K3+ 420 21000 4350 -50 -6 0

K3+ 421 22050 4300 -50 -6 022 K3+ 630 22050 4300 -50 -6 023 K3+ 840 23100 4350 50 6 5024 K3+ 1050 24150 4300 -50 -3 025 K3+ 840 25200 4350 50 5 5026 K3+ 1050 26250 4400 50 4 5027 K3+ 1260 27300 4350 -50 -9 028 K3+ 1050 28350 4400 50 3 5029 K4+ 1260 29400 4350 -50 -9 030 K4+ 1050 30450 4300 -50 -9 031 K4+ 1260 31500 4350 50 3 5032 K4+ 1470 32550 4300 -50 -6 033 K4+ 1680 33600 4250 -50 -6 034 K4+ 1890 34650 4200 -50 -6 035 K4+ 2100 35700 4150 -50 -3 036 K5+ 1890 36750 4200 50 3 5037 K5+ 1680 37800 4150 -50 -2 038 K5+ 1890 38850 4200 50 8 5039 K5+ 2100 39900 4150 -50 -8 040 K5+ 2310 40950 4100 -50 -8 0

Page 92: MET. DE BRUCE informe caminos I   2013.xlsx

41 K5+ 2100 42000 4050 -50 -8 042 K5+ 1890 43050 4100 50 3 5043 K6+ 1860 44100 4050 -50 -3 044 K6+ 1890 45150 4000 -50 -8 045 K6+ 2100 46200 3950 -50 -7 0

46 K6+ 2101 47250 3900 -50 -8 0

47 K6+ 2102 48300 3850 -50 -8 048300 950

0 10000 20000 30000 40000 50000 600003500

3600

3700

3800

3900

4000

4100

4200

4300

4400

4500

COTAS

CHRISTIAN

Axis Title

Page 93: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCECONTRAPENDIENTESXo=X+(K*∑Y) Xo=X+(K*∑Y)

K=21 REGRESO K=21

50000

500

50500

500

50000

50505000

5050500

5000

500

50500

505050500

500

5050

Page 94: MET. DE BRUCE informe caminos I   2013.xlsx

500

505050

50

5068250 1450 78750

0 10000 20000 30000 40000 50000 600003500

3600

3700

3800

3900

4000

4100

4200

4300

4400

4500

COTAS

CHRISTIAN

Axis Title

Page 95: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCE

PUNTOS ABSCISA X COTAS YA K0+ 000.0 0 43501 K0+ 210 1050 4400 502 K0+ 420 2100 4450 503 K0+ 630 3150 4400 -504 K0+ 420 4200 4350 -505 K0+ 210 5250 4400 506 K0+ 420 6300 4350 -507 K1+ 210 7350 4400 508 K1+ 420 8400 4350 -509 K1+ 210 9450 4300 -50

10 K1+ 420 10500 4350 5011 K1+ 210 11550 4300 -5012 K1+ 0 12600 4250 -5013 K1+ 210 13650 4300 5014 K2+ 420 14700 4250 -5015 K2+ 630 15750 4200 -5016 K2+ 420 16800 4250 5017 K2+ 210 17850 4200 -5018 K2+ 0 18900 4150 -5019 K3+ 210 19950 4200 5020 K3+ 420 21000 4150 -5021 K3+ 630 22050 4100 -5022 K3+ 840 23100 4050 -5023 K3+ 1050 24150 4100 5024 K3+ 840 25200 4050 -5025 K3+ 1050 26250 4100 5026 K3+ 1260 27300 4050 -5027 K3+ 1050 28350 4000 -5028 K4+ 1260 29400 4050 5029 K4+ 1050 30450 4000 -5030 K4+ 1260 31500 4050 5031 K4+ 1470 32550 4000 -5032 K4+ 1680 33600 3950 -5033 K4+ 1890 34650 3900 -5034 K4+ 2100 35700 3850 -5035 K5+ 1890 36750 3800 -5036 K5+ 1680 37800 3850 5037 K5+ 1890 38850 3800 -5038 K5+ 2100 39900 3850 5039 K5+ 2310 40950 3900 5040 K5+ 2100 42000 3850 -5041 K5+ 1890 43050 3900 50

Page 96: MET. DE BRUCE informe caminos I   2013.xlsx

42 K5+ 1680 44100 3850 -50

43 K5+ 1470 45150 3900 50

44 K5+ 1260 46200 3950 50

45 K5+ 1050 47250 3900 -50

46 K5+ 840 48300 3850 -5049350

0 10000 20000 30000 40000 50000 600003400

3600

3800

4000

4200

4400

4600

COTAS

RUTA YACKY

Axis Title

Page 97: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCECONTRAPENDIENTES

PENDIENTE Xo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21

2 50 02 50 0-2 0 50-2 0 508 50 0-8 0 508 50 0-8 0 50-8 0 502 50 0-2 0 50-8 0 509 50 0-8 0 50-2 0 508 50 0-8 0 50-5 0 508 50 0-8 0 50-2 0 50-8 0 508 50 0-8 0 508 50 0-2 0 50-8 0 508 50 0-8 0 508 50 0-8 0 50-2 0 50-8 0 50-8 0 50-8 0 508 50 0-8 0 502 50 08 50 0-8 0 508 50 0

Page 98: MET. DE BRUCE informe caminos I   2013.xlsx

-4 0 50

2 50 0

8 50 0

-8 0 50

-8 0 50900 68250 1400 78750

0 10000 20000 30000 40000 50000 600003400

3600

3800

4000

4200

4400

4600

COTAS

RUTA YACKY

Axis Title

Page 99: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCE

PUNTOS ABSCISA X COTAS Y PENDIENTEA K0+ 000.0 0 43501 K0+ 210 210 4300 -50 -82 K0+ 420 420 4250 -50 -33 K0+ 630 630 4300 50 44 K0+ 420 840 4250 -50 -85 K0+ 210 1050 4300 50 76 K0+ 420 1260 4350 50 27 K1+ 210 1470 4400 50 78 K1+ 420 1680 4450 50 69 K1+ 210 1890 4400 -50 -7

10 K1+ 420 2100 4450 50 511 K1+ 210 2310 4500 50 812 K1+ 0 2520 4550 50 713 K1+ 210 2730 4600 50 614 K2+ 420 2940 4550 -50 -415 K2+ 630 3150 4500 -50 -816 K2+ 420 3360 4450 -50 -817 K2+ 210 3570 4400 -50 -818 K2+ 0 3780 4350 -50 -719 K3+ 210 3990 4300 -50 -720 K3+ 420 4200 4350 50 621 K3+ 630 4410 4300 -50 -522 K3+ 840 4620 4350 50 723 K3+ 1050 4830 4300 -50 -624 K3+ 840 5040 4350 50 725 K3+ 1050 5250 4300 -50 -926 K3+ 1260 5460 4350 50 927 K3+ 1050 5670 4400 50 428 K4+ 1260 5880 4450 50 329 K4+ 1050 6090 4400 -50 -630 K4+ 1260 6300 4350 -50 -931 K4+ 1470 6510 4300 -50 -832 K4+ 1680 6720 4250 -50 -833 K4+ 1890 6930 4200 -50 -734 K4+ 2100 7140 4150 -50 -835 K5+ 1890 7350 4100 -50 -836 K5+ 1680 7560 4050 -50 -937 K5+ 1890 7770 4000 -50 -938 K5+ 2100 7980 3950 -50 -539 K5+ 2310 8190 3900 -50 -640 K5+ 2100 8400 3850 -50 -341 K5+ 1890 8610 3800 -50 -8

Page 100: MET. DE BRUCE informe caminos I   2013.xlsx

42 K6+ 1860 8820 3750 -50 -743 K6+ 1890 9030 3700 -50 -844 K6+ 2100 9240 3650 -50 -845 K6+ 1890 9450 3700 50 746 K6+ 2100 9660 3750 50 647 K6+ 2310 9870 3800 50 948 K6+ 2520 10080 3850 50 848 K6+ 2521 10290 3800 -50 -648 K7+ 2310 10290 3850 0 6

10290

0 2000 4000 6000 8000 10000 120000

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

COTAS

RICARDO

Page 101: MET. DE BRUCE informe caminos I   2013.xlsx

METODO DE BRUCECONTRAPENDIENTES

PENDIENTE Xo=X+(K*∑Y) Xo=X+(K*∑Y)

IDA K=21 REGRESO K=21

0 500 50

50 00 50

50 050 050 050 00 50

50 050 050 050 00 500 500 500 500 500 50

50 00 50

50 00 50

50 00 50

50 050 050 00 500 500 500 500 500 500 500 500 500 500 500 500 50

Page 102: MET. DE BRUCE informe caminos I   2013.xlsx

0 500 500 50

50 050 050 050 00 50

50 501000 31290 1550 42840

0 2000 4000 6000 8000 10000 120000

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

COTAS

RICARDO