Excel Para Caminos

download Excel Para Caminos

of 53

  • date post

    21-Dec-2015
  • Category

    Documents

  • view

    9
  • download

    3

Embed Size (px)

description

aca

Transcript of Excel Para Caminos

OrografaCUADRO N01 - DETERMINACIN DE LA OROGRAFA

ZONACOTASHDHTAN()TOPOGRAFIAINICIALFINAL1316031501020.000.50026.565Accidentada0.4641.92319031801018.000.55629.055Accidentada0.5071.13325032401023.000.43523.499Accidentada0.41014317031601027.000.37020.323Accidentada0.3550.95328032701024.000.41722.620Accidentada0.3951.16324032301030.000.33318.435Ondulada0.32217329032801022.000.45524.444Accidentada0.4271.48330032901030.000.33318.435Ondulada0.3221.79332033101038.000.26314.744Ondulada0.2571.110334033301024.000.41722.620Accidentada0.3951.211327032601026.000.38521.037Accidentada0.3671.212322032101020.000.50026.565Accidentada0.4640.613331033001024.000.41722.620Accidentada0.3951.214315031401031.000.32317.879Ondulada0.3121153200319010230.43523.499Accidentada0.410163310330010240.41722.620 Accidentada0.395173340333010170.58830.465Muy Accidentada0.532183300329010240.41722.620Accidentada0.395193320331010150.66733.690Muy Accidentada0.5881.4203300329010140.71435.538Muy Accidentada0.6201.1213270326010190.52627.758Accidentada0.4841.4223210320010250.40021.801Accidentada0.3810.9233280327010210.47625.463Accidentada0.4441.2243260325010190.52627.758Accidentada0.4841.1253220321010270.37020.323Accidentada0.3551263240323010280.35719.654Ondulada0.343273200319010240.41722.620Accidentada0.395283310330010160.62532.005Muy Accidentada0.559293320331010210.47625.463Accidentada0.444303330332010150.66733.690Muy Accidentada0.588

rutas

RUTA ROJATRAMOCOTADHABERTURA COMPASI%#COMPLONGOBRAS DE ARTEPUENTEALCANTCURV VUEL.A31008524400000RO3092RO30926633.33331980111= 28R-13158R-131585233.33261560211R-23210R-232108633.33432580310R-3329626R-332961560120ABRA33485233.33ABRA334812600010B3324242.54

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

RUTA MORADATRAMOCOTADHABERTURA COMPASI%#COMPLONGOBRAS DE ARTEPUENTEALCANTCURV VUEL.A310084.82.084384000RO3092RO30924842.518401= 30 M11R-1314023R-131403642.51440-21R-2317618R-231769832.53480-42R-3327458R-332742160-10ABRA33487433.3336ABRA3348600-10B3324242.5412

2889904195

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

RUTA AZULTRAMOCOTADHABERTURA COMPASI%#COMPLONGOBRAS DE ARTEPUENTEALCANTCURV VUEL.A310084.82.084384000RO3092RO3092842.542100211= 30MR-13176 42R-131765833.331740210R-23234 29R-23234602.541300320R-33294 29R-33294 1350020ABRA3348542.5427ABRA3348 600100B3324242.54127474288 861ABRA DISTANCIA : 24 METROS PMEDIA =(288/7474) * 1003.85%

Pesos absolutos y relativos

PESOS ABSOLUTOS

CARACTERISTICASRUTA ROJARUTA AZULRUTA MORADAVALOR PESOVALOR PESOVALOR PESOLongitud Total (m)868027474199043Pendiente media %3.3223.8512.93Pendiente maxima %414141Alcantarillas718293Puentes281302302Numero de curvas de vuelta6262519913Como podemos apreciar en nuestra evaluacin por pesos absolutos elegiremos la ruta AZUL por ser la ms adecuada.

PESOS RELATIVOS

CARACTERISTICASRUTA ROJARUTA AZULRUTA MORADAVALOR PESOVALOR PESOVALOR PESOLongitud Total (m)86801.167474199041.33Pendiente media %3.321.163.8512.91.33Pendiente maxima %4141.1441Alcantarillas70.8881.0791.29Puentes281301.2301.07Numero de curvas de vuelta61.261516.526.417.02En la evaluacin por pesos relativos tambin resulta ganadora la ruta AZUL, por lo tanto es la que elegimos para nuestra carretera

POLIGONAL

COORDENADAS MEDIDASCOORDENADAS MEDIDASPUNTO APUNTO BESTE626458.000627348.000NORTE9245446.0009245758.000CUADRO DE COORDENADASPUNTOLADOLONG.NGULOAZIMUTGRA.RADI.PROYECCIONESCOORDENADASCORRECCINPROY. CORREGIDACOOR. CORREGIDASGRA.MIN.SEG.SENGRA.MIN.SEG.ESTENORTEESTENORTEESTENORTEESTENORTEESTENORTEKM 00626458.0009245446.00626458.0009245446.00KM00 - Pi1242.0056.0043.007.3256.7190.990202.309132.7982.148-4.175204.457128.623P199.00048.00050.340D626660.3099245578.798626662.4579245574.623Pi1 - Pi2180.00156.0031.0057.66156.5332.73271.681-165.1121.598-3.10573.279-168.217P2116.00025.00024.020I626731.9899245413.686626735.7369245406.405Pi2 - Pi3178.0040.006.0033.6440.1090.700114.676136.1371.580-3.071116.257133.066P378.00006.00000.880D626846.6669245549.823626851.9929245539.472Pi3 - Pi4148.00118.0012.0034.52118.2102.063130.421-69.9591.314-4.762131.735-74.721P446.00031.00055.010I626977.0879245479.864626983.7289245464.751Pi4 - Pi5276.0071.0040.0039.5171.6781.251262.00886.7642.450-4.762264.45882.003P5104.00022.00015.680I627239.0949245566.628627248.1869245546.754Pi5 -Pi 6160.00327.0018.0023.83327.3075.713-86.423134.6521.420-2.760-85.002131.891P698.00055.00042.220D627152.6729245701.280627163.1839245678.645Pi6 - Pi7200.0066.0014.006.0566.2351.156183.04180.5971.776-3.450184.81777.147P700.00000.00000.000627335.7139245781.877627348.0009245755.792Pi7 - Pi80.000.000.000.000.0000.0000.0000.0000.0000.0000.0000.000P8627335.7139245781.877627348.0009245755.7921384.00012.287-26.085

COORDENADAS CALCULADASCOORDENADAS MEDIDASPUNTO A'ESTENORTEESTENORTE627335.7139245781.877627348.009245758.00

ERROR-12.28723.877CORRECCION12.287-23.877

estacado cada 20 m

PuntoSegmentohCota DdeMenor Terreno0-----3180.00200.250.221.6031783179.60400.30.1220.8031783178.8060-----3180.00800.250.1521.2031803181.201000.30.1521.0031823183.001200.20.121.0031843185.00130-----3184.001500.250.221.6031823183.601700.250.1521.2031803180.00190-----3180.00210-----3186.002300.50.321.2031943195.202500.150.0520.6731943192.00270-----3188.00280-----3190.003000.20.0520.5031923194.00320-----3194.003400.250.120.8031923192.803500.250.1521.2031923194.003600.250.221.6031923193.60370-----3194.00390-----3192.004100.250.0520.4031923192.40430-----3192.004500.350.0520.2931923192.294700.40.1520.7531923200.004900.20.1521.5031943204.005100.250.0520.4031983198.40520-----3200.005300.250.1521.2032003201.205400.250.1521.2032003201.20550-----3200.005600.250.1521.2031963197.205700.250.0520.4031943194.405800.450.1520.6731943194.675900.30.2521.6731943195.676000.30.1521.0031983199.006100.350.0520.2932023202.00620-----3204.006300.50.2521.0032043206.006500.70.220.5732043204.576700.450.3521.5632023203.566900.250.1521.2032003201.207100.350.1520.8632003200.867200.450.321.3332003201.33730-----3202.007500.40.221.0032043214.00770-----3206.007900.20.0520.5032063206.50800-----3206.008100.250.120.8032043204.80820-----3202.00830-----3198.008400.250.120.8032023202.808500.450.120.4432083208.448600.30.221.3332123213.33870-----3216.00880-----3220.008900.150.0520.6732203220.679100.20.0520.5032203220.509200.20.121.0032203221.00930-----3224.00940-----3218.009500.30.0520.3332303230.339600.50.4521.8032283229.809700.350.0520.2932243224.299800.250.221.6032183219.609900.250.120.8032183218.801000-----3218.00

Cota subrasanteLONGITUD DE TRAMO 1 = 400PENDIENTE =3.075ESTACACOTA FINALCOTA INICIALDIFER COTASCOTA SUBRADISTANCIA03192.3318012.33180.000203192.3318012.33180.6220403192.3318012.33181.2340603192.3318012.33181.8560803192.3318012.33182.46801003192.3318012.33183.081001203192.3318012.33183.691201303192.3318012.33184.001301503192.3318012.33184.611501703192.3318012.33185.231701903192.3318012.33185.841902103192.3318012.33186.462102303192.3318012.33187.072302503192.3318012.33187.692502703192.3318012.33188.302702803192.3318012.33188.612803003192.3318012.33189.233003203192.3318012.33189.843203403192.3318012.33190.463403503192.3318012.33190.763503603192.3318012.33191.073603703192.3318012.33191.383703903192.3318012.33191.993904003192.3318012.33192.30400

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

LONGITUD DE TRAMO 2 = 300PENDIENTE =3.90ESTACACOTA FINALCOTA INICIALDIFER COTASCOTA SUBRADISTANCIA40032043192.311.73192.3041032043192.311.73192.691043032043192.311.73193.473045032043192.311.73194.255047032043192.311.73195.037049032043192.311.73195.819051032043192.311.73196.5911052032043192.311.73196.9812053032043192.311.73197.3713054032043192.311.73197.7614055032043192.311.73198.1515056032043192.311.73198.5416057032043192.311.78623.9317058032043192.311.73199.3218059032043192.311.73199.7119060032043192.311.73200.1020061032043192.311.73200.4921062032043192.311.73200.8822063032043192.311.73201.2723065032043192.311.73202.0525067032043192.311.73202.8327069032043192.311.73203.6129070032043192.311.73204.00300

I%=((CFL - CI)/DT)*100LONGITUD DE TRAMO 3 = 300PENDIENTE =4.667ESTACACOTA FINALCOTA INICIALDIFER COTASCOTA SUBRADISTANCIA7003218.00320414320407103218.003206123204.467107203218.003206123204.933207303218.003206123205.400307503218.003206123206.333507703218.003206123207.267707903218.003206123209.133908003218.003206123208.6671008103218.003206123209.1331108203218.003206123209.6001208303218.003206123210.0671308403218.003206123210.5331408503218.003206123211.0001508603218.003206123211.4671608703218.003206123211.9331708803218.003206123212.4001808903218.003206123212.8671909103218.003206123213.8002109203218.003206123214.2672209303218.003206123214.7332309403218.003206123215.2002409503218.003206123215.6672509603218.003206123216.1332609703218.003206123216.6002709803218.003206123217.0672809903218.003206123217.53329010003218.003206123218.000300

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

secciones transversales

IZQUIERDAIZQUIERDAIZQUIERDAESTACADERECHACotaCotaCotaCotaCotaCotaCotaCotaCotaCotaCotaCotaCotaDist. (m)Dist. (m)Dist. (m)Dist. (m)Dist. (m)Dist. (m)Dist. (m)CotaDist. (m)Dist. (m)Dist. (m)Dist. (m)Dist. (m)Dist. (m)3188318631843182km 0031783176317431721712843182.004.07.010.415.00.850.600.40.23182.000.200.350.520.753186318431823180km 00+2031783176317431721711623182.004.08.012.016.00.850.550.30.13182.000.200.400.600.80463186318431823180km 00+4031763174317231702014833182.673.08.012.417.01.000.700.400.153182.670.150.400.620.853188318631843182km 00+60317831763174317222151053184.004916221.100.750.500.253184.000.200.450.801.103188318631843182km 00+8031803178317631741612613184.003612200.800.600.300.053184.000.150.300.601.003190318831863184km 00+100318231803178317614.0011.006.002.003186.003812180.700.550.300.103186.000.150.400.600.903192319031883186km 00+12031843182318031781410613185.001610140.700.500.300.053185.000.050.300.500.703190318831863184km 00+140