6
LADO IZQUIERDO Progresiva Coordenadas Borde Plataforma Parámetros COORDENADAS Este Norte Cota Ancho Peralte Este WGS-84 WGS-84 msnm m % WGS-84 -53.809 208036.485 7832483.16 3732.606 -5.7 -2.51 208043.004 -50 208035.214 7832486.75 3732.772 -5.76 -2.5 208041.871 -40 208031.825 7832496.17 3733.369 -5.92 -2.5 208038.895 -30 208028.71 7832505.67 3733.107 -6.08 -2.5 208035.92 -20 208025.601 7832514.15 3732.65 -6.1 -2.49 208032.407 16000 370083.769 7497138.82 417.596 -5.052 -2 370088.087 16010 370078.578 7497147.37 417.942 -5.052 -2 370082.896 16020 370073.387 7497155.91 418.289 -5.052 -2 370077.705 16030 370068.196 7497164.46 418.635 -5.052 -2 370072.514 16040 370063.004 7497173.01 419.008 -5.052 -1.47 370067.322 16050 370057.813 7497181.56 419.407 -5.052 -0.41 370062.131 16053.813 370055.834 7497184.82 419.56 -5.052 0 370060.152 16060 370052.583 7497190.09 419.809 -5.096 0.66 370056.943 16070 370047.356 7497198.69 420.21 -5.17 1.73 370051.81 16080 370042.246 7497207.41 420.613 -5.243 2.79 370046.82 16090 370037.345 7497216.32 421.019 -5.315 3.86 370042.062 16100 370032.749 7497225.45 421.426 -5.389 4.93 370037.631 16110 370028.565 7497234.84 421.833 -5.461 5.99 370033.626 16120 370024.907 7497244.52 422.242 -5.531 7.06 370030.152 16128.813 370022.192 7497253.27 422.607 -5.612 8 370027.617 16130 370021.88 7497254.47 422.648 -5.612 8 370027.317 16140 370019.683 7497264.66 422.994 -5.612 8 370025.21 16150 370018.27 7497274.99 423.34 -5.612 8 370023.855 16160 370017.648 7497285.4 423.686 -5.612 8 370023.259 16170 370017.822 7497295.82 424.033 -5.612 8 370023.425 16180 370018.79 7497306.2 424.379 -5.612 8 370024.354 16190 370020.547 7497316.48 424.725 -5.612 8 370026.039 16200 370023.083 7497326.59 425.068 -5.612 8 370028.471 16210 370026.383 7497336.48 425.387 -5.612 8 370031.635 16220 370030.427 7497346.09 425.679 -5.612 8 370035.513 16230 370035.192 7497355.36 425.944 -5.612 8 370040.082 16240 370040.651 7497364.25 426.181 -5.612 8 370045.316 16250 370046.771 7497372.69 426.391 -5.612 8 370051.185 16260 370053.517 7497380.64 426.574 -5.612 8 370057.654 16270 370060.849 7497388.05 426.729 -5.612 8 370064.685 16280 370068.726 7497394.88 426.857 -5.612 8 370072.238 16288.629 370075.924 7497400.28 426.946 -5.612 8 370079.141 16290 370077.11 7497401.07 426.948 -5.593 7.85 370080.269 16300 370085.928 7497406.56 426.957 -5.514 6.79 370088.717

Planilla subbase para carreteras

Embed Size (px)

DESCRIPTION

Planilla de subbase para replantear en formato excel

Citation preview

Page 1: Planilla subbase para carreteras

LADO IZQUIERDOProgresiva Coordenadas Borde Plataforma Parámetros COORDENADAS DEL EJE

Este Norte Cota Ancho Peralte Este Norte WGS-84 WGS-84 msnm m % WGS-84 WGS-84

-53.809 208036.485 7832483.16 3732.606 -5.7 -2.51 208043.004 7832485.19-50 208035.214 7832486.75 3732.772 -5.76 -2.5 208041.871 7832488.83-40 208031.825 7832496.17 3733.369 -5.92 -2.5 208038.895 7832498.37-30 208028.71 7832505.67 3733.107 -6.08 -2.5 208035.92 7832507.92-20 208025.601 7832514.15 3732.65 -6.1 -2.49 208032.407 7832517.27

16000 370083.769 7497138.82 417.596 -5.052 -2 370088.087 7497141.4416010 370078.578 7497147.37 417.942 -5.052 -2 370082.896 7497149.9916020 370073.387 7497155.91 418.289 -5.052 -2 370077.705 7497158.5416030 370068.196 7497164.46 418.635 -5.052 -2 370072.514 7497167.0816040 370063.004 7497173.01 419.008 -5.052 -1.47 370067.322 7497175.6316050 370057.813 7497181.56 419.407 -5.052 -0.41 370062.131 7497184.18

16053.813 370055.834 7497184.82 419.56 -5.052 0 370060.152 7497187.4416060 370052.583 7497190.09 419.809 -5.096 0.66 370056.943 7497192.7316070 370047.356 7497198.69 420.21 -5.17 1.73 370051.81 7497201.3116080 370042.246 7497207.41 420.613 -5.243 2.79 370046.82 7497209.9716090 370037.345 7497216.32 421.019 -5.315 3.86 370042.062 7497218.7716100 370032.749 7497225.45 421.426 -5.389 4.93 370037.631 7497227.7316110 370028.565 7497234.84 421.833 -5.461 5.99 370033.626 7497236.916120 370024.907 7497244.52 422.242 -5.531 7.06 370030.152 7497246.27

16128.813 370022.192 7497253.27 422.607 -5.612 8 370027.617 7497254.7116130 370021.88 7497254.47 422.648 -5.612 8 370027.317 7497255.8616140 370019.683 7497264.66 422.994 -5.612 8 370025.21 7497265.6316150 370018.27 7497274.99 423.34 -5.612 8 370023.855 7497275.5416160 370017.648 7497285.4 423.686 -5.612 8 370023.259 7497285.5216170 370017.822 7497295.82 424.033 -5.612 8 370023.425 7497295.5116180 370018.79 7497306.2 424.379 -5.612 8 370024.354 7497305.4716190 370020.547 7497316.48 424.725 -5.612 8 370026.039 7497315.3216200 370023.083 7497326.59 425.068 -5.612 8 370028.471 7497325.0216210 370026.383 7497336.48 425.387 -5.612 8 370031.635 7497334.516220 370030.427 7497346.09 425.679 -5.612 8 370035.513 7497343.7216230 370035.192 7497355.36 425.944 -5.612 8 370040.082 7497352.6116240 370040.651 7497364.25 426.181 -5.612 8 370045.316 7497361.1316250 370046.771 7497372.69 426.391 -5.612 8 370051.185 7497369.2216260 370053.517 7497380.64 426.574 -5.612 8 370057.654 7497376.8416270 370060.849 7497388.05 426.729 -5.612 8 370064.685 7497383.9516280 370068.726 7497394.88 426.857 -5.612 8 370072.238 7497390.5

16288.629 370075.924 7497400.28 426.946 -5.612 8 370079.141 7497395.6816290 370077.11 7497401.07 426.948 -5.593 7.85 370080.269 7497396.4616300 370085.928 7497406.56 426.957 -5.514 6.79 370088.717 7497401.816310 370095.026 7497411.44 426.94 -5.443 5.72 370097.494 7497406.5916320 370104.325 7497415.8 426.898 -5.37 4.65 370106.519 7497410.916330 370113.754 7497419.71 426.83 -5.297 3.59 370115.728 7497414.79

Page 2: Planilla subbase para carreteras

16340 370123.26 7497423.28 426.736 -5.224 2.52 370125.064 7497418.3816350 370132.797 7497426.6 426.616 -5.151 1.45 370134.484 7497421.7316360 370142.329 7497429.77 426.471 -5.077 0.39 370143.95 7497424.96

16363.629 370145.78 7497430.9 426.411 -5.052 0 370147.389 7497426.1116370 370151.82 7497432.93 426.295 -5.052 -0.76 370153.429 7497428.14

Page 3: Planilla subbase para carreteras

LADO DERECHOParámetros Coordenadas Borde Plataforma AZIMUT

Cota Ancho Peralte Este Norte Cota SECCION msnm m % WGS-84 WGS-84 msnm g.m.s

5.7 -2.51 208049.218 7832487.13 3730.42 #REF!5.76 -2.5 208048.105 7832490.77 3730.365 #REF!5.92 -2.5 208045.072 7832500.3 3730.299 #REF!6.08 -2.5 208041.949 7832509.8 3730.296 #REF!

6.1 -2.49 208038.262 7832519.96 3730.232 #REF!417.697 5.052 -2 370092.405 7497144.07 417.596 58 º43 '37'' 418.043 5.052 -2 370087.214 7497152.61 417.942 58 º43 '37''

418.39 5.052 -2 370082.023 7497161.16 418.289 58 º43 '37'' 418.736 5.052 -2 370076.831 7497169.71 418.635 58 º43 '37'' 419.082 5.052 -2 370071.64 7497178.25 418.981 58 º43 '37'' 419.428 5.052 -2 370066.449 7497186.8 419.327 58 º43 '37''

419.56 5.052 -2 370064.469 7497190.06 419.459 58 º43 '37'' 419.775 5.161 -2 370061.36 7497195.4 419.672 58 º50 '18'' 420.121 5.334 -2 370056.406 7497204.02 420.014 59 º29 '26'' 420.467 5.508 -2.79 370051.624 7497212.67 420.313 60 º43 '36'' 420.814 5.681 -3.86 370047.103 7497221.39 420.595 62 º32 '44''

421.16 5.85 -4.93 370042.93 7497230.21 420.872 64 º56 '49'' 421.506 6.018 -5.99 370039.203 7497239.16 421.146 67 º55 '54'' 421.852 6.181 -7.06 370036.014 7497248.23 421.416 71 º30 '1'' 422.158 6.362 -8 370033.765 7497256.34 421.649 75 º7 '43'' 422.199 6.362 -8 370033.481 7497257.44 421.69 75 º38 '49'' 422.545 6.362 -8 370031.476 7497266.73 422.036 80 º1 '16'' 422.891 6.362 -8 370030.186 7497276.16 422.382 84 º23 '41'' 423.237 6.362 -8 370029.619 7497285.65 422.728 88 º46 '7'' 423.584 6.362 -8 370029.778 7497295.16 423.075 93 º8 '33''

423.93 6.362 -8 370030.661 7497304.64 423.421 97 º30 '57'' 424.276 6.362 -8 370032.264 7497314.01 423.767 101 º53 '23'' 424.619 6.362 -8 370034.578 7497323.24 424.11 106 º15 '48'' 424.938 6.362 -8 370037.588 7497332.26 424.429 110 º38 '14''

425.23 6.362 -8 370041.278 7497341.03 424.721 115 º0 '39'' 425.495 6.362 -8 370045.626 7497349.49 424.986 119 º23 '4'' 425.732 6.362 -8 370050.606 7497357.59 425.223 123 º45 '29'' 425.942 6.362 -8 370056.189 7497365.29 425.433 128 º7 '57'' 426.125 6.362 -8 370062.344 7497372.55 425.616 132 º30 '21''

426.28 6.362 -8 370069.034 7497379.31 425.771 136 º52 '46'' 426.408 6.362 -8 370076.22 7497385.54 425.899 141 º15 '12'' 426.497 6.362 -8 370082.787 7497390.46 425.988 145 º1 '38'' 426.509 6.318 -7.85 370083.836 7497391.24 426.013 145 º37 '17'' 426.583 6.139 -6.79 370091.821 7497396.51 426.166 149 º37 '26'' 426.629 5.975 -5.72 370100.202 7497401.27 426.287 153 º2 '34'' 426.648 5.808 -4.65 370108.893 7497405.6 426.378 155 º52 '42''

426.64 5.636 -3.59 370117.827 7497409.56 426.438 158 º7 '53''

Page 4: Planilla subbase para carreteras

426.604 5.463 -2.52 370126.95 7497413.25 426.466 159 º48 '3'' 426.541 5.29 -1.46 370136.216 7497416.73 426.464 160 º53 '13'' 426.451 5.116 -0.39 370145.582 7497420.11 426.431 161 º23 '24'' 426.411 5.052 0 370148.998 7497421.32 426.411 161 º25 '44'' 426.333 5.052 0.76 370155.038 7497423.35 426.371 161 º25 '42''