11
1 2 3 4 5 6 7 8 9 10 PI 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 PC -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 PT 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 ST (m) 50.69 35.13 10.55 166.74 20.51 135.01 58.70 47.11 24.41 LC (m) 64.65 45.82 14.04 160.24 27.14 141.38 73.83 60.43 32.20 R (m) 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 e(%) 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 LT (m) 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 x (m) 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 ST= Dist PI = PI2 - PI1 + ST1 PC= PI - ST 1-2 PT= PC + LC x=? LC= π.r.Δ 2% 32 180 N33°14´55"W Δ 41.1575 29.17055556 8.93638889 102.010556 17.2791667 90.0055556 47 38.4725 20.5 Δ/2 0.359166943 0.25456111957897 0.0779847 0.89021003 0.15078918 0.78544664 0.41015237 0.3357359 0.17889625 Dist PI (m) 18.38 98.01 72.96 222.69 110.93 228.67 155.39 92.25 60.62 Interpolacion Radio e Lt 300.00 4.60 33.00 250.00 5.00 33.00 x1= 4.78 33.00 277.44 Radio e Lt 250.00 4.20 28.00 200.00 4.70 28.00 x1= 4.28 28.00 241.9 Radio e Lt 300.00 3.90 28.00 250.00 4.20 28.00 r.Tan (Δ 2)

Alineamiento Carretera

Embed Size (px)

DESCRIPTION

hoja excell de calculo de datos de alineamiento de carretera

Citation preview

Page 1: Alineamiento Carretera

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)

Page 2: Alineamiento Carretera

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

Page 3: Alineamiento Carretera

x1= 4.04 28.00275.96

Page 4: Alineamiento Carretera

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

Page 5: Alineamiento Carretera

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

Page 6: Alineamiento Carretera

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

Page 7: Alineamiento Carretera

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

Page 8: Alineamiento Carretera

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

Page 9: Alineamiento Carretera

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