plantilla de estacado

Upload: jenchluis-ricardo-verde-carbajal

Post on 09-Mar-2016

232 views

Category:

Documents


0 download

DESCRIPTION

hoja simple de estacado en excel

TRANSCRIPT

  • ELEMENTOS DEL PERFIL LONGITUDINALESTACADO 0 2 4 6PENDIENTELONGITUD DE TRAMO 0 20 40 60distancia parcial 0 20 20 20COTA TERRENO 1064 1063.8 1063.6 1063COTA SUBRASANTE 1064 1062.898 1061.796 1060.694ALTURA CORTE 0 0.902 1.804 2.306ALTURA RELLENO 0 0 0 0ALINEAMIENTO

    0 0.902 1.804 2.306

    3.144

    3.81

    91011121314151617181920212223242526272829

    altura maxima de

    rellenoaltura

    maxima de corte

  • 303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677

  • 78798081828384858687888990919293949596979899

    100101102103104105106107108109110111112113114115116117118119120121122123124125

  • 126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173

  • 174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212

  • ELEMENTOS DEL PERFIL LONGITUDINAL8 10 12 14 16 18

    80 100 120 140 160 18020 20 20 20 20 20

    1062.8 1062.3 1060 1055 1052.2 10511059.592 1058.49 1057.388 1056.286 1055.184 1054.082

    3.208 3.81 2.612 0 0 00 0 0 1.286 2.984 3.082

    3.208 3.81 2.612 -1.286 -2.984 -3.082

  • ELEMENTOS DEL PERFIL LONGITUDINAL20 22 24 26 28 30

    200 220 240 260 280 30020 20 20 20 20 20

    1050 1049.2 1049.2 1049 1050 1049.81052.98 1051.878 1050.776 1049.674 1048.572 1047.47

    0 0 0 0 1.428 2.332.98 2.678 1.576 0.674 0 0

    -2.98 -2.678 -1.576 -0.674 1.428 2.33

  • 31 32 33 34 35 36

    310 320 330 340 350 36010 10 10 10 10 10

    1050 1050 1048 1046.6 1045.2 1044.81046.919 1046.368 1045.817 1045.266 1044.715 1044.164

    3.081 3.632 2.183 1.334 0.485 0.6360 0 0 0 0 0

    3.081 3.632 2.183 1.334 0.485 0.636

  • 37 38 39 40 41 42

    370 380 390 400 410 42010 10 10 10 10 10

    1043.8 1042.4 1042 1041.8 1041.6 10421043.613 1043.062 1042.511 1041.96 1041.409 1040.858

    0.187 0 0 0 0.191 1.1420 0.662 0.511 0.16 0 0

    0.187 -0.662 -0.511 -0.16 0.191 1.142

  • 43 44 45 46 47 48

    430 440 450 460 470 48010 10 10 10 10 10

    1042 1041.4 1041.2 1041 1040 1039.81040.307 1039.756 1039.205 1038.654 1038.103 1037.552

    1.693 1.644 1.995 2.346 1.897 2.2480 0 0 0 0 0

    1.693 1.644 1.995 2.346 1.897 2.248

  • 49 50 51 52 54 56

    490 500 510 520 540 56010 10 10 10 20 20

    1039 1037.8 1035.8 1034 1032 10301037.001 1036.45 1035.899 1035.348 1034.246 1033.144

    1.999 1.35 0 0 0 00 0 0.099 1.348 2.246 3.144

    1.999 1.35

  • 58 60 62 64 65 66

    580 600 620 640 650 66020 20 20 20 10 10

    1030.2 1030.6 1033.8 1031.8 1031.6 10301032.042 1030.94 1029.838 1028.736 1028.185 1027.634

    0 0 3.962 3.064 3.415 2.3661.842 0.34 0 0 0 0

  • 67 68 69 70 71 72

    670 680 690 700 710 72010 10 10 10 10 10

    1029.6 1028.8 1028.6 1028 1026.8 10241027.083 1026.532 1025.981 1025.43 1024.879 1024.328

    2.517 2.268 2.619 2.57 1.921 00 0 0 0 0 0.328

  • 73 74 76 78 80 82

    730 740 760 780 800 82010 10 20 20 20 20

    1022.4 1020.8 1020.8 1020.2 1018 1019.81023.777 1023.226 1022.124 1021.022 1019.92 1018.818

    0 0 0 0 0.9822.426 1.324 0.822 1.92 0

  • 84 85 86 87 88 89

    840 850 860 870 880 89020 10 10 10 10 10

    1020.4 1022.8 1024.6 1024.2 1024 1022.41017.716 1017.165 1016.614 1016.063 1015.512 1014.961

    2.684 5.635 7.986 8.137 8.488 7.4390 0 0 0 0 0

  • 90 91 92 93 94 95

    900 910 920 930 940 95010 10 10 10 10 10

    1020.8 1019.8 1018.6 1017.8 1016 1014.61014.41 1013.859 1013.308 1012.757 1012.206 1011.655

    6.39 5.941 5.292 5.043 3.794 2.9450 0 0 0 0 0

  • 96 98 100 102 104 106

    960 980 980.8 1020 1040 106010 20 0.8 39.2 20 20

    1014 1012.2 1012 1009.9 1005.6 1004.41011.104 1010.002 1010 1010 1010 1010

    2.896 2.198 PUENTE0 0 PUENTE

    PUENTE

  • 108 109 110 111 112 114

    1080 1090 1100 1110 1120 114020 10 10 10 10 20

    1010 1014.2 1016.2 1015.8 1015.4 1015.81010 1010 1010 1010 1010 1011.2048

    PUENTE 5.4 4.5952PUENTE 0 0PUENTE

    20

  • 116 118 120 122 124 126

    1160 1180 1200 1220 1240 126020 20 20 20 20 20

    1017.8 1017.8 1018.2 1016.4 1016.6 1016.21012.4096 1013.6144 1014.8192 1016.024 1017.2288 1018.4336

    5.3904 4.1856 3.3808 0.376 0 00 0 0 0 0.6288 2.2336

    40 60 80 100 120 140

  • 127 128 129 130 131 132

    1270 1280 1290 1300 1310 132010 10 10 10 10 10

    1017.8 1018.8 1020.2 1021.8 1024.2 1027.81019.036 1019.6384 1020.2408 1020.8432 1021.4456 1022.048

    0 0 0 0.9568 2.7544 5.7521.236 0.8384 0.0408 0 0 0

    150 160 170 180 190 200

  • 133 134 136 138 140 142

    1330 1340 1360 1380 1400 142010 10 20 20 20 20

    1029.8 1029.8 1028.4 1029.8 1031.6 10311022.6504 1023.2528 1024.4576 1025.6624 1026.8672 1028.072

    7.1496 6.5472 3.9424 4.1376 4.7328 2.9280 0 0 0 0 0

    210 220 240 260 280 300

  • 144 146 148 150 152 154

    1440 1460 1480 1500 1520 154020 20 20 20 20 20

    1030.2 101031.6 1031.8 1032 1032.4 1032.61029.2768 1030.4816 1031.6864 1032.8912 1034.096 1035.3008

    0.9232 100001.118 0.1136 0 0 00 0 0 0.8912 1.696 2.7008

    320 340 360 380 400 420

  • 156 158 160 final

    1560 1580 1600 161820 20 20 18

    1034.6 1036.4 1038.2 10401036.5056 1037.7104 1038.9152 1039.99952

    0 0 0 0.000481.9056 1.3104 0.7152 0

    440 460 480 498

  • Hoja1