4
RUTA 01 -Color verde TRAMO L compasadas # compasadas L tramo i cm unid. m % PI-A1 1.7 8 272 5.88 AI-B1 1.7 83 2822 5.88 B1-C1 2 6 240 5.00 C1-PF 7.1 2 284 1.41 PI-PF 99 3618 18.17 4.54 RUTA 02 -Color azul TRAMO L compasadas # compasadas L tramo i cm unid. m % PI.A2 1.7 12 408 5.88 A2-B2 1.7 85 2890 5.88 B2-C2 2.5 7 350 4.00 C2-PF 7.4 2 296 1.35 PI-PF 106 3944 17.12 4.28 RUTA 03 Color negro TRAMO L compasadas # compasadas L tramo i cm unid. m % PI-A3 1.7 8 272 5.88 A3.B3 1,7 89 2890 5.88 B3-C3 2 7 280 5.00 C3-PI 2.3 3 138 4.35 PI-PF 107 3580 21.11 5.28 CUADRO RESUMEN Descripcion Ruta Verde Ruta Azul Ruta Negra

Hoja de calculo

Embed Size (px)

DESCRIPTION

Hoja de calculo para carreteras

Citation preview

rutas

RUTA 01 -Color verde

TRAMOL compasadas# compasadasL tramoi # alcatarillasL puente # de curvascmunid.m%unid.mde volteoPI-A11.782725.881241AI-B11.78328225.88702B1-C1262405.00101C1-PF7.122841.41000PI-PF99361818.1792444.54

RUTA 02 -Color azul

TRAMOL compasadas# compasadasL tramoi# alcantarillasL puente# de curvascmunid.m%unid.mde volteoPI.A21.7124085.882400A2-B21.78528905.881003B2-C22.573504.00101C2-PF7.422961.35000PI-PF106394417.12134044.28

RUTA 03 Color negro

TRAMOL compasadas# compasadasL tramoi# alcantarillasL puente# de curvas cmunid.m%unid.mde volteoPI-A31.782725.881241A3.B31,78928905.88903B3-C3272805.00101C3-PI2.331384.35000PI-PF107358021.11112455.28

CUADRO RESUMENDescripcionRuta VerdeRuta AzulRuta NegraLong. (m)361839443580i (%)media5.544.285.28# alcant.91311L punt. (m)244024123

ELECCION DE LA MEJOR RUTADescripcionRuta VerdeRuta AzulRuta NegraLong. (m)312i (%)media231# alcant.132L punt. (m)132TOTAL7107

* Ruta mas adecuada: RUTA 01 -COLOR VERDE

coordenadas de los PI COORDANAS DE LOS PI

PUNTOESTE NORTEPP701281466570128,14665Pi1 701521469270152,14692Pi2702951466670295,14666Pi3703351475870335,14758Pi4703481476070348,14760Pi5703621465670362,14656Pi6702541457270254,14572Pi7703771432870377,14328Pi8705441439270544,14392Pi9706321431770632,14317Pi10706521435470652,14354Pi11705581441470558,14414Pi12704381441570438,14415Pi13703741452370374,14523Pi14706901460970690,14609Pi15706101478870610,14788Pi16706581494670658,14946Pi17706961494270696,14942Pi18706651483870665,14838Pi19706741473670674,14736Pi20708821478670882,14786Pi21708061462670806,14626Pi22709841458170984,14581Pi23710381468571038,14685Pi24712521475171252,14751Pi25713181450171318,14501Pi26713531449871353,14498Pi27713801463771380,14637PF714421476571442,14765

Hoja3