Alineamiento Carretera

Preview:

DESCRIPTION

hoja excell de calculo de datos de alineamiento de carretera

Citation preview

1 2 3 4 5 6 7 8 9 10 11 12 13PI 0+ 0+18.38 0+130.6 0+204.18 0+270.08 0+319.52 0+416.57 0+516.59 0+628.41 0+686.88 0+730.88 0+817.57 0+817.57PC -0+32.31 0+95.47 0+193.63 0+103.34 0+299.01 0+281.56 0+457.89 0+581.3 0+662.47 0+718.48 0+655.94 0+801.33PT 0+32.34 0+141.29 0+207.67 0+263.58 0+326.15 0+422.94 0+531.72 0+641.73 0+694.67 0+734.97 0+813.43 0+822.88ST (m) 50.69 35.13 10.55 166.74 20.51 135.01 58.70 47.11 24.41 12.40 161.63 16.24LC (m) 64.65 45.82 14.04 160.24 27.14 141.38 73.83 60.43 32.20 16.49 157.49 21.55R (m) 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00Δ 41°09´27" I 29°10´14" D 8°56´11" I 102°00´38" D 17°16´45" I 90°00´20" I 47°00´00" D 38°28´21" I 20°30´00" D 10°30´00" I 100°15´30" D 13°43´00" De(%) 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00LT (m) 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00x (m) 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67

si si no si no si si si si no no siST= Dist PI = PI2 - PI1 + ST1PC= PI - ST 1-2 6%PT= PC + LC x=?LC= π.r.Δ 2% 32 m

180N33°14´55"W

Δ 41.1575 29.17055556 8.93638889 102.010556 17.2791667 90.0055556 47 38.4725 20.5 10.5 100.258333 13.7166667Δ/2 0.359166943 0.25456111957897 0.0779847 0.89021003 0.15078918 0.78544664 0.41015237 0.3357359 0.17889625 0.09162979 0.87491901 0.1197005

Dist PI (m) 18.38 98.01 72.96 222.69 110.93 228.67 155.39 92.25 60.62 95.01 165.77 92.64

InterpolacionRadio e Lt

300.00 4.60 33.00250.00 5.00 33.00

x1= 4.78 33.00277.44

Radio e Lt250.00 4.20 28.00200.00 4.70 28.00

x1= 4.28 28.00241.9

Radio e Lt300.00 3.90 28.00250.00 4.20 28.00

r.Tan (Δ∕2)

x1= 3.98 28.00286.06

Radio e Lt110.00 5.80 32.00100.00 5.90 31.00

x1= 5.83 31.65106.53

Radio e Lt400.00 3.30 28.00300.00 3.90 28.00

x1= 3.60 28.00349.36

Radio e Lt400.00 3.30 28.00300.00 3.90 28.00

x1= 3.69 28.00334.66

Radio e Lt600.00 2.40 28.00500.00 2.80 28.00

x1= 2.58 28.00554.48

Radio e Lt175.00 5.00 28.00150.00 5.30 29.00

x1= 5.18 28.60160.03

Radio e Lt300.00 3.90 28.00250.00 4.20 28.00

x1= 4.04 28.00275.96

14 15 16 17 18 19 20 21 22 23 24 25 26 27 280+899.28 0+941.98 01+139.24 01+255.56 01+331.72 01+389.72 01+470.18 01+544.26 01+673.64 01+759.57 01+841.27 01+898.25 01+960 02+047.87 02+102.350+884.49 0+900.62 01+103.01 01+069.74 01+236.54 01+303.92 01+355.55 01+513.49 01+644.21 01+741.2 01+822.53 01+891.75 01+956.12 01+960.02 02+068.820+904.13 0+954.13 01+150.2 01+239.39 01+347.08 01+405.83 01+482.26 01+553.83 01+682.85 01+765.54 01+847.36 01+900.41 01+961.29 02+063.86 02+112.64

14.79 41.36 36.23 185.82 95.18 85.80 114.63 30.77 29.43 18.37 18.74 6.50 3.88 87.85 33.5319.64 53.52 47.19 169.65 110.54 101.91 126.72 40.34 38.64 24.35 24.83 8.66 5.17 103.84 43.8390.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00

12°30´16" I 34°04´12" I 30°02´38" I 108°00´10" I 70°22´13" I 64°52´33" I 80°40´20" I 25°40´52" D 24°36´00" I 15°30´00" I 15°48´26" D 05°30´40" I 03°17´39" D 66°06´19" D 27°54´00" I6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00

32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.0010.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67

no si no no no no si si si si si si no si no

12.5044444 34.07 30.0438889 108.002778 70.3702778 64.8758333 80.6722222 25.6811111 24.6 15.5 15.8072222 5.51111111 3.29416667 66.1052778 27.90.10912186 0.29731684 0.26218239 0.94250204 0.61409652 0.56614845 0.70399795 0.22410997 0.2146755 0.13526302 0.13794404 0.04809352 0.02874703 0.57687738 0.24347343

52.64 226.47 141.58 278.15 137.82 150.15 176.63 150.58 106.16 94.10 69.63 66.09 90.46 126.34 90.43

29 30 31 32 33 34 35 36 37 38 39 40 41 42 4302+169.54 02+232.02 02+333.65 02+379.05 02+450.54 02+515.29 02+554.4 02+615.68 02+673.92 02+787.52 02+859.76 02+912.92 02+980.8 03+083.51 03+148.1602+103.88 02+191.45 02+269.98 02+361.87 02+331.51 02+482.87 02+509 02+563.38 02+638.15 02+752.14 02+789.11 02+896.33 02+970.75 03+037.68 03+106.8202+185.36 02+244 02+349.31 02+384.66 02+461.58 02+525.29 02+567.39 02+629.91 02+684.77 02+798.28 02+875.89 02+918.34 02+984.12 03+096.59 03+160.31

65.66 40.57 63.67 17.18 119.03 32.42 45.40 52.30 35.77 35.38 70.65 16.59 10.05 45.83 41.3481.49 52.55 79.33 22.79 130.07 42.42 58.40 66.52 46.62 46.14 86.78 22.01 13.37 58.91 53.4990.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00 90.00

51°52´32" I 33°27´19" I 50°30´00" D 14°30´31" D 82°48´12" I 27°00´13" D 37°10´33" D 42°21´00" I 29°40´39" D 29°22´20" D 55°14´47" I 14°00´52" D 08°30´50" D 37°30´21" I 34°03´11" D6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00

32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.0010.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67 10.67

si si si no si no no si si no si si si si si

51.8755556 33.4552778 50.5 14.5086111 82.8033333 27.0036111 37.1758333 42.35 29.6775 29.3722222 55.2463889 14.0144444 8.51388889 37.5058333 34.05305560.45269962 0.29195237 0.44069564 0.12661152 0.7225954 0.23565096 0.32442035 0.36957347 0.25898504 0.25632099 0.48211569 0.1222991 0.0742977 0.32730014 0.29716897

112.32 130.22 93.42 83.07 172.73 61.52 93.69 96.31 138.52 96.87 107.67 79.05 109.43 97.40 81.76

44 45 46 47 4803+200.73 03+279.22 03+386.01 03+442.69 03+493.603+182.35 03+254.8 03+344.37 03+400.56 03+444.5703+206.71 03+287.01 03+398.22 03+455.01 03+507.28

18.38 24.42 41.64 42.13 49.0324.36 32.21 53.85 54.45 62.7190.00 90.00 90.00 90.00 90.00

15°30´31" I 20°30´12" D 34°16´55" I 34°40´ 00" D 39°55´26" I6.00 6.00 6.00 6.00 6.00

32.00 32.00 32.00 32.00 32.0010.67 10.67 10.67 10.67 10.67

si si si no no

15.5086111 20.5033333 34.2819444 34.6666667 39.92388890.13533816 0.17892534 0.2991664 0.30252374 0.34840166

90.90 123.42 86.10 80.72 -3458.24

No. PI ∆1 0+000 N33°14´55"W Trabajar con Rmin e=6% Vd=70 km/h2 0+018.38 41°09´27" I Calcular:3 0+130.60 29°10´14" D Curvas compuestas4 0+204.18 8°56´11" I Curvas en reversa5 0+270.08 102°00´38" D Diagramas de peralte6 0+319.52 17°16´45" I Diagramas de corte transversal7 0+416.57 90°00´20" I Sobre ancho8 0+516.59 47°00´00" D Cambios de alineamiento9 0+628.41 38°28´21" I

10 0+686.88 20°30´00" D11 0+730.88 10°30´00" I12 0+817.57 100°15´30" D13 0+899.28 13°43´00" D14 0+941.98 12°30´16" I15 1+034.93 34°04´12" I16 1+139.24 30°02´38" I17 1+255.56 108°00´10" I18 1+331.72 70°22´13" I19 1+389.72 64°52´33" I20 1+470.18 80°40´20" I21 1+544.26 25°40´52" D22 1+673.64 24°36´00" I23 1+759.57 15°30´00" I24 1+841.27 15°48´26" D25 1+898.25 05°30´40" I26 1+960.00 03°17´39" D27 2+047.87 66°06´19" D28 2+102.35 27°54´00" I29 2+169.54 51°52´32" I30 2+232.02 33°27´19" I31 2+333.65 50°30´00" D32 2+379.05 14°30´31" D33 2+450.54 82°48´12" I34 2+515.29 27°00´13" D35 2+554.40 37°10´33" D36 2+615.68 42°21´00" I37 2+673.92 29°40´39" D38 2+787.52 29°22´20" D39 2+859.76 55°14´47" I40 2+912.92 14°00´52" D

41 2+980.80 08°30´50" D42 3+083.51 37°30´21" I43 3+148.16 34°03´11" D44 3+200.73 15°30´31" I45 3+279.22 20°30´12" D46 3+386.01 34°16´55" I47 3+442.69 34°40´ 00" D48 3+493.60 39°55´26" I

N° Integrantes Grupo

11 Enma González2 José Manuel Cwu3 Rodrigo Zelaya

21 Juan Cesar Aguirre2 Martha Sánchez3 Marco Vinicio Arévalo

31 Javier Asahel Barahona2 Enrique Gómez3 Itzel Lara

41 Clara Ramos2 Erick Obando3 Oscar Maldonado

5

1 Jose Ottoniel Ordoñez2 Chisthian Simón3 Jenifer Moncada4 Aurora Patricia