Hoja de calculo para calculo de: Coordenadas Pc Pt Pe, Curvas de Volteo Simples y Compuestas, a partir de coordenadas de un alineamiento

8/17/2019 Hoja de calculo para calculo de: Coordenadas Pc Pt Pe, Curvas de Volteo Simples y Compuestas, a partir de coord…

1/83

COORDENADAS DE LOS PUNTOS GEOMETRICOS

ESTACION x y Distacia

km5 1365.85 102.31 0 5000

PI-1 1371.54 202.28 5.69 99.97 100.132 5100.132

PI-2 1292.35 263.15 -79.19 60.87 99.881 5200.013

PI-3 1192.91 289.75 -99.44 26.6 102.936 5302.949

PI-4 1094.24 284.8 -98.67 -4.95 98.794 5401.743

PI-5 1005.35 330.6 -88.89 45.8 99.995 5501.738

PI-6 960.88 420.17 -44.47 89.57 100.002 5601.740

PI-7 1046.85 600.63 85.97 180.46 199.892 5801.632

PI-8 1108.09 687.83 61.24 87.2 106.556 5908.188

PI-9 1045.81 717.09 -62.28 29.26 68.811 5976.999

PI-10 984.64 668.79 -61.17 -48.3 77.940 6054.939

Distacia" #

Distacia" $

DistaciaAc%m%&a'a


2/83


3/83

D ( )AD (* I )AD I* ST S

+m 5 , 0

+m 5 , 100.13 176.8382 2.1693 124.29 0.9723 55.7096 15 7.927 14.5847

+m 5 , 200.01 198.8961 2.7476 157.428 0.394 22.5721 15 2.9935 5.90936

+m 5 , 302.95 199.2895 2.8301 162.152 0.3115 17.8478 15 2.3554 4.67255

+m 5 , 401.74 191.957 2.6157 149.869 0.5259 30.1315 15 4.0377 7.8884

+m 5 , 501.74 190.0261 2.5074 143.663 0.6342 36.3369 15 4.9226 9.51297

+m 5 , 601.74 273.2004 2.2362 128.124 0.9054 51.8765 15 7.296 13.5812

+m 5 , 801.63 305.4712 2.9739 170.393 0.1677 9.60729 15 1.2605 2.51518

+m 5 , 908.19 116.4646 1.3977 80.0847 1.7439 99.9153 15 17.85 26.1578

+m 5 , 977 124.9097 2.034 116.54 1.1076 63.4595 15 9.275 16.6137

+m 6 , 54.94

+i&m"ta/" '" &a&ia&

P)O)ESIAS

)ADIODE

I)O


4/83


5/83

C E t PC i PE i PT i P)O)ESIA PC i

5000

14.017 1.9657 92.205 5092.205 5099.4972 5106.7896 +m 5 , 92.205

5.87122 0.2958 88.961 5195.750 5198.7048 5201.6595 +m 5 , 195.75

4.65368 0.1838 97.587 5299.247 5301.5832 5303.9195 +m 5 , 299.247

7.79781 0.5339 92.401 5396.321 5400.2647 5404.2089 +m 5 , 396.321

9.35435 0.7871 91.035 5495.244 5500.0005 5504.757 +m 5 , 495.244

13.1221 1.6803 87.783 5592.540 5599.3308 5606.1214 +m 5 , 592.54

2.51224 0.0529 191.335 5797.457 5798.7141 5799.9717 +m 5 , 797.457

22.9671 8.3153 87.446 5887.418 5900.4965 5913.5754 +m 5 , 887.418

15.7774 2.6359 41.686 5955.262 5963.5687 5971.8755 +m 5 , 955.262

68.665 6040.541 +m 6 , 40.541

P1

P2

P1

P25

15

25

35

45

55

65

75


6/83

-5


7/83

P)O)ESIA PT i AIT *

+m 5 , 0

+m 5 , 99.497 +m 5 , 106.79 0.05685573 0.05685573 3.1984484 183.25759

+m 5 , 198.705 +m 5 , 201.659 0.91546086 -0.9154609 2.2261318 127.54796

+m 5 , 301.583 +m 5 , 303.919 1.30941797 -1.309418 1.8321747 104.97588

+m 5 , 400.265 +m 5 , 404.209 1.52067113 1.52067113 1.5206711 87.128038

+m 5 , 500 +m 5 , 504.757 1.09502837 -1.0950284 2.0465643 117.2595

+m 5 , 599.331 +m 5 , 606.121 0.46083021 -0.4608302 2.6807624 153.59637

+m 5 , 798.714 +m 5 , 799.972 0.44458482 0.44458482 3.5861775 205.47283

+m 5 , 900.497 +m 5 , 913.575 0.61226362 0.61226362 3.7538563 215.08012

+m 5 , 963.569 +m 5 , 971.876 1.13158801 -1.131588 2.0100046 115.16478

0.90242741 0.90242741 0.9024274 51.705282

P)O)ESIAE#TE)NA

Di"cciP2-P1

ASOTO

Di"cciP2-P1

AIT)ADIANES

800 900 1000 1100 1200 1300 1400 1500

0

0

0

0

0

0

0

0

1 102.31

2 202.28

3 263.15

4 289.755 284.8

6 330.6

7 420.17

8 600.63

9 687.83

10 717.09

11 668.79

GRAFICO DE RUTA


8/83

0


9/83

PC COO)DENADAS PT COO)DENA

# $ ONITD ATITD # $ ONITD

0.4504 7.9141 1371.08955 194.365856 0.91546086 6.2848 4.8309 1365.25517

2.3734 1.8243 1294.72337 261.325688 1.30941797 2.8918 0.7736 1289.45818

2.2754 0.6087 1195.18535 289.141348 1.52067113 2.3524 0.118 1190.5576

4.0326 0.2023 1098.27262 285.002305 1.09502837 3.5893 1.8493 1090.65073

4.3759 2.2547 1009.7259 328.345347 0.46083021 2.189 4.4091 1003.16096

3.2445 6.5349 964.124463 413.635109 0.44458482 3.1379 6.5867 964.017878

0.5421 1.138 1046.30786 599.491993 0.61226362 0.7245 1.0316 1047.57446

10.258 14.607 1097.83151 673.222872 1.13158801 16.155 7.59 1091.93462

8.3947 3.9439 1054.20465 713.146077 0.90242741 7.2793 5.7477 1038.53071

Di"cciP3-P2


10/83


11/83

AS P%t "'i '" c%"'a PE

ATITD ONITD ATITD ' : ; E - ' # $

207.110885321 1368.17236 200.738371 3.7037 1.73798 0.4293026 1.5803 0.7234

263.923556116 1292.09078 262.624622 0.5858 0.29006 1.1124394 0.1283 0.2601

289.631986866 1192.87148 289.386667 0.3654 0.18157 1.4651697 0.0191 0.1806

286.649346404 1094.46167 285.825826 1.0495 0.51558 1.3579749 0.1089 0.5039

335.00908759 1006.44343 331.677217 1.5349 0.74784 0.7779293 0.5327 0.5248

426.75673373 964.071171 420.195921 3.1913 1.51101 0.0081227 1.511 0.0123

601.661566631 1046.94116 600.57678 0.1056 0.05269 0.5284242 0.0455 0.0266

695.420021323 1094.88306 684.321447 13.665 5.3497 0.2596622 5.1704 1.3736

711.342250249 1046.36768 712.244163 4.8778 2.24193 1.456216 0.2563 2.2272

Di"cciP1-P


12/83


13/83

OO)DENADAS

ONITD ATITD

1369.75263 201.461784

1292.21912 262.884746

1192.89062 289.567227

1094.35278 285.321882

1005.91069 331.152378

962.560213 420.183648

1046.89566 600.603343

1100.05342 685.695004

1046.11136 714.471391


14/83


15/83



km3 3456 4567 0

PI-1 3403.95 4665.04 -52.05 98.04 111.000

PI-2 3328.78 4726.64 -75.17 61.6 97.186

PI-3 3216.03 4735.31 -112.75 8.67 113.083

PI-4 3185.68 4648.59 -30.35 -86.72 91.878

PI-5 3146.65 4752.65 -39.03 104.06 111.139

PI-6 3044.74 4765.66 -101.91 13.01 102.737

PI-7 3001.38 4848.05 -43.36 82.39 93.103

PI-8 3088.11 4978.13 86.73 130.08 156.342

PI-9 3124.97 5145.08 36.86 166.95 170.971PI-10 3070.76 5164.59 -54.21 19.51 57.614

PI-11 3014.39 5088.71 -56.37 -75.88 94.527

Distacia "#

Distacia " $


16/83


17/83

D ( )AD (* I )AD

3000 +m 3 , 0

3111.000 +m 3 , 111 204.131962 2.74536592 157.297881 0.39622673

3208.186 m 3 , 208.1 200.628511 2.53183326 145.06336 0.6097594

3321.269 m 3 , 321.2 163.001265 1.83070584 104.891718 1.31088682

3413.146 m 3 , 413.1 71.5140546 0.69548813 39.8485346 2.44610452

3524.285 m 3 , 524.2 183.219727 2.05660503 117.834788 1.08498763

3627.022 m 3 , 627.0 173.794513 2.18221908 125.031944 0.95937357

3720.125 m 3 , 720.1 216.851234 2.06908892 118.550062 1.07250374

3876.468 m 3 , 876.4 321.716193 2.77083545 158.757177 0.3707572

4047.438 m 4 , 47.44 187.265464 1.69896183 97.3433425 1.442630824105.052 m 4 , 105.0 124.118948 1.86426317 106.814411 1.27732948

4199.579 m 4 , 199.58

DistaciaAc%m%&a'a

+i&m"ta/"'" &a

&ia&P)O)ESIA

S


18/83


19/83

I* ST S C E

22.7021194 15 3.01119937 5.94340095 5.904598513 0.29925886

34.93664 15 4.72036511 9.14639097 9.005352732 0.72519783

75.1082819 15 11.5324408 19.6633022 18.28532481 3.92081369

140.151465 15 41.382271 36.6915679 28.20431631 29.0169553

62.1652118 15 9.04236877 16.2748144 15.48820067 2.51469192

54.9680565 15 7.80319201 14.3906035 13.84503997 1.90827625

61.4499377 15 8.9151919 16.0875561 15.32752749 2.44937381

21.2428228 15 2.81297592 5.561358 5.529559803 0.26148202

82.6566575 15 13.1909682 21.6394623 19.81119105 4.9750254473.1855885 15 11.1370565 19.1599423 17.88371715 3.68245237

34.1142511

37.1919507

)ADIO DEI)O


20/83


21/83

t PC i PE i PT i P)O)ESIA PC i

3000

107.989 3107.989 3110.9607 3113.9324 +m 3 , 107.989 +m 3 , 110.961

89.454 3203.387 3207.95988 3212.53307 +m 3 , 203.387 +m 3 , 207.96

96.830 3309.363 3319.19477 3329.02642 +m 3 , 309.363 +m 3 , 319.195

38.963 3367.989 3386.33503 3404.68081 +m 3 , 367.989 +m 3 , 386.335

60.714 3465.395 3473.53234 3481.66975 +m 3 , 465.395 +m 3 , 473.532

85.892 3567.561 3574.75657 3581.95187 +m 3 , 567.561 +m 3 , 574.757

76.385 3658.337 3666.38044 3674.42422 +m 3 , 658.337 +m 3 , 666.38

144.614 3819.038 3821.81898 3824.59966 +m 3 , 819.038 +m 3 , 821.819

154.967 3979.566 3990.3861 4001.20583 +m 3 , 979.566 +m 3 , 990.38633.286 4034.492 4044.0717 4053.65167 +m 4 , 34.492 +m 4 , 44.072

83.390 4137.042 +m 4 , 137.042

P1

P2

P1

P2

P)O)ESIAE#TE)NA

150

250

350

450

550

650

750

1 102.31

2 202.28

3 263.15

4 289.755 284.8

6 330.6

7 420.17

8 600.63

9 687.83

10 717.09

11 668.79

GRAFICO DE RUTA


22/83

800 900 1000 1100 1200 1300 1400

-50

50


23/83

P)O)ESIA PT i AIT * #

+m 3 , 0

+m 3 , 113.932 0.48806544 -0.48806544 2.65352722 152.03591 1.41200583

+m 3 , 212.533 0.88429217 -0.88429217 2.25730049 129.333791 3.65104442

+m 3 , 329.026 1.49405156 -1.49405156 1.64754109 94.397151 11.4984958

+m 3 , 404.681 0.33665427 0.33665427 0.33665427 19.288869 13.6698483

+m 3 , 481.67 0.35883386 -0.35883386 2.7827588 159.440334 3.17552261

+m 3 , 581.952 1.44382148 -1.44382148 1.69777117 97.2751227 7.74037257

+m 3 , 674.424 0.48444791 -0.48444791 2.65714474 152.243179 4.15198203

+m 3 , 824.6 0.58805582 0.58805582 3.72964848 213.693117 1.56048285

+m 4 , 1.206 0.21729862 0.21729862 3.35889128 192.450294 2.84387464+m 4 , 53.652 1.2253322 -1.2253322 1.91626045 109.793636 10.4790612

0.63893097 0.63893097 0.63893097 36.6080479

Di"cciP2-P1

ASOTO

Di"cciP2-P1

AIT)ADIANES


24/83

1500


25/83

PC COO)DENADAS PT COO)

$ ONITD ATITD # $

2.65961674 3405.36201 4662.38038 0.88429217 2.32906193 1.90861001

2.99194275 3332.43104 4723.64806 1.49405156 4.70647102 0.36190779

0.88418589 3227.5285 4734.42581 0.33665427 3.80952307 10.8850689

39.0592832 3199.34985 4687.64928 0.35883386 14.5327337 38.7465096

8.46643308 3149.82552 4744.18357 1.44382148 8.96957336 1.14507064

0.98814883 3052.48037 4764.67185 0.48444791 3.63410158 6.90529588

7.88934039 3005.53198 4840.16066 0.58805582 4.94565347 7.41762484

2.34045439 3086.54952 4975.78955 0.21729862 0.60645669 2.74682431

12.8807616 3122.12613 5132.19924 1.2253322 12.4116245 4.466902663.77137952 3081.23906 5160.81862 0.63893097 6.64144591 8.94009076

Di"cciP3-P2


26/83


27/83

ENADAS P%t "'i '" c%"'a

ONITD ATITD ONITD ATITD ' : ; E - '

3401.62094 4666.94861 3403.49147 4664.6645 0.59266411 0.29340525

3324.07353 4727.00191 3328.25229 4725.32498 1.41695176 0.69175393

3212.22048 4724.42493 3219.87449 4729.42537 7.02914753 3.10833384

3171.14727 4687.33651 3185.24856 4687.4929 38.9052887 9.88833341

3137.68043 4753.79507 3143.75297 4748.98932 4.66833407 2.15364215

3041.1059 4772.5653 3046.79314 4768.61857 3.60118351 1.69290726

3006.32565 4855.46762 3005.92882 4847.81414 4.5549283 2.10555448

3088.71646 4980.87682 3087.63299 4978.33318 0.51848395 0.25700193

3112.55838 5149.5469 3117.34225 5140.87307 8.71095968 3.735934253064.11855 5155.64991 3072.67881 5158.23426 6.63906559 2.95661321


28/83


29/83


30/83


31/83



km3 159357.974 345211.098 0

PI-1 159328.581 345094.754 -29.393 -116.344 119.999

PI-2 159375.958 345082.118 47.377 -12.636 49.033

PI-3 159486.394 345260.904 110.436 178.786 210.144

PI-4 159540.113 345244.473 53.719 -16.431 56.176

PI-5 159529.149 345128.362 -10.964 -116.111 116.627

st 23.5

1 23.8118798 35.7178198

2 34.3614601 O+


32/83

D ( )AD (* I )AD

3000 +m 3 , 0

3119.999 +m 3 , 120 130.227741 1.58398013 90.7553765 1.55761252

3169.033 m 3 , 169.0 229.152276 1.86348409 106.769773 1.27810857

3379.177 m 3 , 379.1 230.880943 1.82729566 104.696329 1.31429699

3435.352 m 3 , 435.3 139.267267 1.77348146 101.613003 1.3681112

3551.980 m 3 , 551.98

35.3988168

DistaciaAc%m%&a'a

+i&m"ta/"'" &a

&ia&P)O)ESIA

S

159300 159350 159400 159450 159500344950

345000

345050

345100

345150

345200

345250

345300

C=a.t Tit&"


33/83

I* ST S C E

89.2446235 23.8118798 23.5 37.0896822 33.4523705 9.64339809

73.2302266 34.3614601 25.533138 43.9176765 40.9888662 8.44801405

75.3036707 35.3988168 27.3118125 46.5245584 43.2475625 9.31148773

78.3869974 35.3988168 28.8638827 48.4295175 44.7399533 10.2761211

52.8449505

49.033138

)ADIO DEI)O

159550 159600


34/83

t PC i PE i PT i O)ESIA P

3000

96.499 3096.499 3115.04432 3133.58916 m 3 , 96.49m 3 , 115.0

0.000 3133.589 3155.548 3177.50684 m 3 , 133.58m 3 , 155.5

157.299 3334.806 3358.06827 3381.33055 m 3 , 334.80m 3 , 358.06

0.000 3381.331 3405.54531 3429.76007 m 3 , 381.33m 3 , 405.5

87.764 3517.524 +m 3 , 517.524

P)O)ESIAE#TE)NA


35/83

O)ESIA P AIT * #

+m 3 , 0

3 , 133.58 0.24746062 0.24746062 0.24746062 14.1784494 5.75615419

3 , 177.50 1.3101519 -1.3101519 4.97303341 284.933826 24.6707335

3 , 381.33 0.55333219 0.55333219 3.69492485 211.703599 14.3530429

m 3 , 429.7 1.27396347 -1.27396347 5.00922184 287.00727 27.6015973

0.09414773 0.09414773 0.09414773 5.39426736

Di"cciP2-P1

ASOTO

Di"cciP2-P1

AIT)ADIANES


36/83

PC COO)DENADAS PT COO)

$ ONITD ATITD # $

22.7841324 159334.337 345117.538 1.3101519 22.7062665 6.05602684

6.57997316 159351.287 345088.698 0.55333219 13.4183048 21.7230346

23.2362919 159472.041 345237.668 1.27396347 26.1174027 7.98851513

8.44248487 159512.511 345252.915 0.09414773 2.71345618 28.7360554

Di"cciP3-P2


37/83

ENADAS P%t "'i '" c%"'a

ONITD ATITD ONITD ATITD ' : ; E - '

159351.287 345088.698 159342.812 345103.118 16.5071114 6.86371332

159389.376 345103.841 159370.332 345096.27 15.2288985 6.78088446

159512.511 345252.915 159492.276 345245.292 16.6837401 7.37225236

159537.4 345215.737 159524.955 345234.326 18.2402814 7.96416033


38/83

PE COO)DENADAS

# $ ONITD ATITD

0.53134564 5.91738588 3.47780172 159336.895 345099.64

1.19238647 2.50515224 6.30115912 159372.837 345089.968

1.21048069 2.59923222 6.8988475 159489.677 345252.19

0.58990787 6.61815298 4.43033869 159531.574 345238.757

Di"cciP1-P


39/83



km5 1365.85 102.31 0

PI-1 1371.54 202.28 5.69 99.97 100.132

PI-2 1292.35 263.15 -79.19 60.87 99.881

PI-3 1192.91 289.75 -99.44 26.6 102.936

PI-4 1094.24 284.8 -98.67 -4.95 98.794

PI-5 1005.35 330.6 -88.89 45.8 99.995

PI-6 960.88 420.17 -44.47 89.57 100.002

PI-7 1046.85 600.63 85.97 180.46 199.892

PI-8 1108.09 687.83 61.24 87.2 106.556

PI-9 1045.81 717.09 -62.28 29.26 68.811

PI-10 984.64 668.79 -61.17 -48.3 77.940

Distacia "#

Distacia " $


40/83


41/83

D ( )AD (* I )AD

5000 +m 5 , 0

5100.132 +m 5 , 100.13 176.838219 2.16927606 124.290363 0.97231659

5200.013 +m 5 , 200.01 198.896148 2.74763555 157.42792 0.39395711

5302.949 +m 5 , 302.95 199.289474 2.83008909 162.152161 0.31150356

5401.743 +m 5 , 401.74 191.956964 2.6156995 149.868542 0.52589316

5501.738 +m 5 , 501.74 190.026121 2.50739449 143.663122 0.63419816

5601.740 +m 5 , 601.74 273.200386 2.23617762 128.12354 0.90541504

5801.632 +m 5 , 801.63 305.471209 2.97391386 170.392713 0.1676788

5908.188 +m 5 , 908.19 116.464644 1.39774103 80.0846617 1.74385163

5976.999 +m 5 , 977 124.909664 2.03401541 116.540499 1.10757724

6054.939 +m 6 , 54.94

DistaciaAc%m%&a'a

+i&m"ta/" '" &a&ia&

P)O)ESIAS


42/83


43/83

I* ST S C E

55.709637 24 12.6831248 23.3355982 22.4271725 3.14519579

22.5720795 24 4.78959239 9.45497056 9.39394606 0.47325469

17.8478395 24 3.76856555 7.47608551 7.44589557 0.29407513

30.1314584 24 6.46029904 12.6214358 12.4764949 0.85428462

36.3368779 24 7.8761518 15.2207558 14.9669561 1.2593303

51.8764602 24 11.6735698 21.7299608 20.9952918 2.68842881

9.60728734 24 2.01687334 4.02429111 4.01957828 0.08459628

99.9153383 38.052896 45.2816918 66.3586045 58.2642605 21.0948386

63.4595014 38.052896 23.5292521 42.1465216 40.0250529 6.68689167

)ADIO DEI)O


44/83


45/83

t PC i PE i PT i P)O)ESIA PC i

5000

87.449 5087.449 5099.11647 5110.78427 +m 5 , 87.449

82.408 5193.193 5197.92003 5202.64752 +m 5 , 193.193

94.378 5297.026 5300.76366 5304.50171 +m 5 , 297.026

88.565 5393.067 5399.37765 5405.68836 +m 5 , 393.067

85.659 5491.347 5498.95765 5506.56803 +m 5 , 491.347

80.452 5587.020 5597.88512 5608.7501 +m 5 , 587.02

186.201 5794.951 5796.9634 5798.97555 +m 5 , 794.951

59.257 5858.233 5891.41227 5924.59157 +m 5 , 858.233

0.000 5924.592 5945.66483 5966.73809 +m 5 , 924.592

54.411 6021.149 +m 6 , 21.149

P1

P2

P1

P2


46/83


47/83

P)O)ESIA PT i

+m 5 , 0

+m 5 , 99.116 +m 5 , 110.784 0.05685573 0.05685573 3.19844839

+m 5 , 197.92 +m 5 , 202.648 0.91546086 -0.91546086 2.2261318

+m 5 , 300.764 +m 5 , 304.502 1.30941797 -1.30941797 1.83217469

+m 5 , 399.378 +m 5 , 405.688 1.52067113 1.52067113 1.52067113

+m 5 , 498.958 +m 5 , 506.568 1.09502837 -1.09502837 2.04656428

+m 5 , 597.885 +m 5 , 608.75 0.46083021 -0.46083021 2.68076244

+m 5 , 796.963 +m 5 , 798.976 0.44458482 0.44458482 3.58617748

+m 5 , 891.412 +m 5 , 924.592 0.61226362 0.61226362 3.75385627

+m 5 , 945.665 +m 5 , 966.738 1.13158801 -1.13158801 2.01000465

0.90242741 0.90242741 0.90242741

P)O)ESIAE#TE)NA

Di"cciP2-P1

ASOTO

Di"cciP2-P1

AIT)ADIANES


48/83


49/83

PC COO)DENADAS

AIT * # $ ONITD ATITD

183.257594 0.7207199 12.6626307 1370.81928 189.617369 0.91546086

127.547956 3.79739733 2.91889854 1296.1474 260.231101 1.30941797

104.975877 3.64056513 0.97384385 1196.55057 288.776156 1.52067113

87.1280375 6.45218488 0.3236882 1100.69218 285.123688 1.09502837

117.259496 7.00143618 3.6074449 1012.35144 326.992555 0.46083021

153.596374 5.19114156 10.4558253 966.071142 409.714175 0.44458482

205.472834 0.86742314 1.82081167 1045.98258 598.809188 0.61226362

215.080121 26.0243556 37.0562346 1082.06564 650.773765 1.13158801

115.164783 21.2960576 10.0051805 1067.10606 707.084819 0.90242741

51.7052816

Di"cciP3-P2


50/83


51/83

PT COO)DENADAS P%t "'i '" c%"'a

# $ ONITD ATITD ONITD ATITD

10.0557334 7.72941651 1361.48427 210.009417 1366.15177 199.813393

4.62691249 1.23768979 1287.72309 264.38769 1291.93524 262.309396

3.76383221 0.18882101 1189.14617 289.561179 1192.84837 289.168668

5.74282626 2.95895425 1088.49717 287.758954 1094.59468 286.441321

3.50246065 7.05454014 1001.84754 337.65454 1007.09949 332.323548

5.02060511 10.538774 965.900605 430.708774 965.985873 420.211474

1.15914019 1.65050661 1048.00914 602.280507 1046.99586 600.544847

40.9839424 19.2548195 1067.10606 707.084819 1074.58585 678.929292

18.4665453 14.5812349 1027.34345 702.508765 1047.22476 704.796792


52/83


53/83

PE COO)DENADAS

' : ; E - ' # $ ONITD

5.92597142 2.78077563 0.42930256 2.52843768 1.15746102 1368.68021

0.93735776 0.46410307 1.11243941 0.20535411 0.41619869 1292.1406

0.58459053 0.2905154 1.46516975 0.03062912 0.28889627 1192.879

1.679206 0.82492138 1.35797495 0.17423862 0.80631023 1094.42044

2.45587537 1.19654507 0.77792929 0.85238078 0.83974229 1006.24711

5.10604178 2.41761296 0.00812269 2.41753321 0.01963731 963.56834

0.16889542 0.08429914 0.52842422 0.07280096 0.04250136 1046.92306

34.6662746 13.5714361 0.25966219 13.1164776 3.48452163 1087.70233

12.3743481 5.68745643 1.45621603 0.65024548 5.65016296 1046.57451

Di"cciP1-P


54/83


55/83

ATITD

200.97085391

262.72559431

289.45756384

285.635011

331.48380533

420.19183704

600.58734883

682.41381405

710.44695524


56/83


57/83



PI 1 1874.18300 1682.72400 0

PI 2 1929.96800 1740.95900 55.785 58.235 80.643

PI 3 1979.62600 1494.46400 49.658 -246.495 251.447

PI 4 2139.74200 1617.73100 160.116 123.267 202.069

Distacia "#

Distacia " $

1350.00000

1400.00000

1450.00000

1500.00000

1550.00000

1600.00000

1650.00000

1700.00000

1750.00000

1800.00000

C=at Tit&"


58/83

1850.00000 1900.00000 1950.00000 2000.00000 2050.0


59/83

D ( )AD (* I a'

5000 +m 5 , 0

5080.643 +m 5 , 80.64 215.777788 0.96270958 55.1591959 2.17888307

5332.090 +m 5 , 332.09 243.290508 1.1135007 63.7988904 2.02809196

5534.159 +m 5 , 534.16

DistaciaAc%m%&a'a

+i&m"ta/" '" &a&ia&

P)O)ESIAS


60/83

0000 2100.00000 2150.00000 2200.00000


61/83

I* )ADIO ST S C

124.840804 71.4118455 71.4118455 136.716811 155.598061 126.59442

116.20111 71.4118455 114.730404 144.829789 121.254001

)ADIO DEI)O


62/83


63/83

E t PC i PE i PT i P)O)ESIA PC i

0

82.8319168 -56.074 -56.074 21.7251449 99.5241755 +m -1 , 943.926

63.7277757 0.000 99.524 171.93907 244.353965 +m 0 , 99.524

87.339 331.693 +m 0 , 331.693


64/83


65/83

P)O)ESIA PT i

+m 0 , 0

+m 0 , 21.725 +m 0 , 99.524 0.76391401 0.76391401 3.90550666

+m 0 , 171.939 +m 0 , 244.354 0.19879557 -0.19879557 6.08438974

0.91470513 0.91470513 4.05629778

P)O)ESIAE#TE)NA

Di"cciP2-P1

ASOTO

Di"cciP2-P1

AIT)ADIANES


66/83


67/83

PC COO)DENADAS

AIT * # $ ONITD ATITD

223.769049 94.5742886 98.7278605 1835.39371 1642.23114 0.19879557

348.609853 22.6579658 112.470806 1956.96803 1606.93481 0.91470513

232.408743

Di"cciP3-P2

1820 1840 1860 1880 1900 19201580

1590

1600

1610

1620

1630

1640

1650

C=a.t Tit&"


68/83


69/83

PT COO)DENADAS P%t "'i '" c%"'a

# $ ONITD ATITD ONITD ATITD

27.0000342 134.024194 1956.96803 1606.93481 1896.18087 1624.58297

90.9103919 69.9883289 2070.53639 1564.45233 2013.75221 1585.69357

1940 1960 1980 2000 20201540

1550

1560

1570

1580

1590

1600

1610

1620

C=a.t Tit&"

1940 1960 1980


70/83


71/83

PE COO)DENADAS

' : ; E - ' # $ ONITD

121.181474 38.3495576 1.28823711 10.6924048 116.376027 1906.87328

97.4034515 33.6756758 1.21284155 11.798589 91.2295673 2001.95362

Di"cciP1-P

1900 1920 1940 19601300

1400

1500

1600

1700

1800

C=a.t Tit&"

2040 2060 2080


72/83


73/83

ATITD

1740.959

1494.464

1980 2000 2020


74/83


75/83



PI 1 1874.18300 1682.72400 0

PI 2 1929.96800 1740.95900 55.785 58.235 80.643

PI 3 1979.62600 1494.46400 49.658 -246.495 251.447

PI 4 2139.74200 1617.73100 160.116 123.267 202.069

Distacia "#

Distacia " $

920 940

100

200

300

400

500

600

700

800


76/83

D ( )AD (* I a'

5000 +m 5 , 0

5080.643 m 5 , 80.64 215.777788 0.96270958 55.1591959 2.17888307

5332.090 m 5 , 332.0 243.290508 1.1135007 63.7988904 2.02809196

5534.159 m 5 , 534.16

DistaciaAc%m%&a'a

+i&m"ta/"'" &a

&ia&P)O)ESIA

S

0 960 980 1000 1020 1040 1060 1080 1100 1120

C=a.t Tit&"


77/83

I* )ADIO ST S C

124.840804 71.4118455 19.8486938 38 43.247983 35.1865137

116.20111 132.856323 213.447 269.444839 225.583873

)ADIO DEI)O


78/83

E t PC i PE i PT i O)ESIA P

0

23.0228661 42.643 42.643 64.2669171 85.8909086 0

118.560694 0.000 85.891 220.613328 355.335748 m 0 , 85.89

-11.378 343.958 +m 0 , 343.95


79/83

O)ESIA P AIT *

+m 0 , 0

m 0 , 64.26 m 0 , 85.89 0.76391401 0.76391401 3.90550666 223.769049

0 , 220.61m 0 , 355.33 0.19879557 -0.19879557 6.08438974 348.609853

8 0.91470513 0.91470513 4.05629778 232.408743

29.7730407

P)O)ESIAE#TE)NA

Di"cciP2-P1

ASOTO

Di"cciP2-P1

AIT)ADIANES


80/83

PC COO)DENADAS

# $ ONITD ATITD #

26.2866207 27.4410927 1903.68138 1713.51791 0.19879557 7.50457307

42.1534269 209.243404 1937.47257 1703.7074 0.91470513 169.13189

Di"cciP3-P2

1072 1074 1076 1078 1080 1082 1084 1086 1088 10

620

630

640

650

660

670

680

690

700

710

C=a.t Tit&"


81/83


82/83

PE COO)DENADAS

: ; E - ' # $ ONITD ATITD

10.6591367 1.28823711 2.97191968 32.3463442 1923.5489 1740.959

62.6510409 1.21284155 21.95038 169.725691 2021.16485 1494.464

Di"cciP1-P

1040 1050 1060 1070 1080670

680

690

700

710

720

C=a.t Tit&"

70 1080


83/83

1090 1100

Documents

Hoja de calculo para calculo de: Coordenadas Pc Pt Pe, Curvas de Volteo Simples y Compuestas, a partir de coordenadas de un alineamiento