PERFIL LONGITUDINAL.xlsx

14
Estaca Progresiva ELEVACIONES Cota Terreno Cota Razante 1 0+000 2830 2 0+020 2827.7 3 0+040 2827.7 4 0+060 2829.6 5 0+080 2831.4 6 0+100 2833.8 7 0+120 2836.8 8 0+140 2839.1 9 0+160 2841.4 10 0+180 2843.3 11 0+200 2845.6 12 0+220 2847.2 13 0+240 2847 14 0+260 2846.7 15 0+280 2845.8 16 0+300 2847.5 17 0+320 2847.85 18 0+340 2847.2 19 0+360 2844.5 PC 0+376.944 2845.35 20 0+380 2845.5 21 0+390 2846.9 22 0+400 2847 23 0+410 2846.2 24 0+420 2846.4 25 0+430 2846.95 26 0+440 2847.9 27 0+450 2849.1 28 0+460 2850.1 29 0+470 2850 PT 0+474.333 2851.2 30 0+480 2852.4 31 0+500 2854.9 32 0+520 2852.45 33 0+540 2861 EC 0+548.861 2862.2 34 0+550 2862.3 35 0+560 2863.5 36 0+570 2865 37 0+580 2865.6 38 0+590 2865 39 0+600 2863

Transcript of PERFIL LONGITUDINAL.xlsx

Hoja1EstacaProgresivaELEVACIONESCota Transveral IzquierdaEje del PerfilCota Transversal DerechaCora RojaCota TerrenoCota Razante15105-5-10-1510000+28302825.52826.82828.12830.42831.62832.20,2830020020+2827.72824.82824.82825.82829.852831.12831.8520,2827730040+2827.72829.628292827.82828.82829.72830.840,2827740060+2829.628322821.22829.9528302831.42831.760,2829650080+2831.42832.32831.12830.92832.328332833.780,2831460100+2833.82834.52833.852834.328332833.32833.3100,2833870120+2836.82836.92836.752836.92836.228362835.4120,2836880140+2839.12839.728392838.92839.128382838.3140,2839190160+2841.42841.52841.22841.32841.32840.952840.8160,28414100180+2843.32843.82843.752843.72843.12842.452843180,28433110200+2845.62845.82845.92845.82845.52845.72845.8200,28456120220+2847.22845.12845.92846.32847.32847.12847220,28472130240+28472842.728442845.52847.852848.52848.8240,28470140260+2846.72843.22844.92845.852847.828492849.9260,28467150280+2845.82843.92844.22844.72846.82847.852848.9280,28458160300+2847.52845.32846.52847.22847.82848.252849.1300,28475170320+2847.852850.52851.228522848.52849.12850.2320,28478.5180340+2847.22844.852850.82851.62852.82853.42853.8340,28472190360+2844.52844.22843.828442844.72845.32845.4360,28445PC0376.944+2845.352845.42844.82844.82846.12846.72846.85376.944,28453.5200380+2845.52845.52844.82844.852846.428472847.25380,28455210390+2846.92845.52844.82845.22847.72848.82848.8390,28469220400+28472846.22846.12845.82848.22849.82850.7400,28470230410+2846.22847.42846.852846.12847.52848.92850.4410,28462240420+2846.42848.62847.8528472847.32848.22849.9420,28464250430+2846.952849.42848.128472846.928482849.5430,28469.5260440+2847.92848.82848.52848.22847.92847.92848.45440,28479270450+2849.12851.22850.32849.32848.62847.92848.1450,28491280460+2850.12852.5528522851.22848.92848.52848.7460,28501290470+28502853.12851.52850.32849.728492849.1470,28500PT0474.333+2851.22853.12852.52851.828502849.52850474.333,28512300480+2852.428552854.12853.42850.92849.952850.4480,28524310500+2854.92857.22855.42855.22853.828532853.5500,28549320520+2852.452859.32858.42857.82857,202856.82857.1520,28524.5330540+28612861.72861.22861.22860.828602859.8540,28610EC0548.861+2862.22863.22862.62861.92862.22861.62861.3548.861,28622340550+2862.32863.52862.92862.22862.42861.82861.5550,28623350560+2863.52864.92864.22863.52863.52863.62863560,28635360570+2865286428652865.428652865.42864.9570,28650370580+2865.62860.42862.128642866.82866.92866.7580,28656380590+28652859.42861.52863.32866.32867.22867.9590,28650390600+286328582859.52861286428652866.8600,28630EC0608.861+2862.82856.82857.928602863.528652866.3608.861,28628400610+2862.828572858.1286028642865.52867610,28628410620+2863.4285928612862.52864.12865.42867.9620,28634420630+28652861.8286328642866.72868.12869630,28650430640+28672862.22864.12865.72868.32869.92870.6640,28670440650+2866.82862.128642865.72868.52869.92870.9650,28668450660+28662862.228632864.328672868.22869660,28660460670+2864.92860.828622863.1286628672868670,28649470680+2863.52858.728602861.82865.22866.22867.1680,28635480690+2863.22858.42860.22861.428652866.052866.5690,28632490700+2862.52857.828592861.12864.42865.42865.2700,28625500710+2862.32858.52859.82860.92863.52863.82863.8710,28623510720+2860.72858.82859.42859.92861.42862.52862.9720,28607520730+2859.4285628572858.42860.62861.32861.7730,28594530740+2858.62855.52856.52857.42860.12860.62860.5740,28586540750+2858.72855.82857.052858.12859.12859.12858.8750,28587550760+2857.32856.12856.82857.32858.22857.952857.95760,28573560770+2856.72854.952856.12855.8285728572857.3770,28567570780+2855.92854.22854.328552855.92856.12854.95780,28559EC0788.669+2854.42853.12853.82854.52854.828542854.8788.669,28544580790+2854.228532853.82854.52854.32853.82854.6790,28542590800+2851.82853.12853.6285328512851.12853.4800,28518600810+2849.72851.8285228512849.852851.22851.2810,28497610820+2847.22850.12849.52848.92848.42849.12848.9820,28472620830+28452847.32846.42845.92844.62844.92844.9830,28450630840+2843.52844.92844.92843.82843.952844.92846.6840,28435EC0848.669+2843.92843.82842.9528432845.12846.22847.7848.669,28439640860+2843.528432842.52842.82844.22845.52846.8860,28435650880+28442841.852841.852842.62845.52846.92847.1880,28440660900+28442840.22840.12842.3284528452845.9900,28440670920+28422838.9528402841.12843.12843.92845920,28420680940+2840.128382838.92839.42841.52842.92843.8940,28401690960+2840.22837.52838.22839.12841.92843.22844960,28402700980+2841.42837.62838.72839.92842.32843.12853980,28414711000+2839.82835.92827.22839.62840.82841.42841.91000,28398721020+2839.42837.82838.42838.92839.92839.72840.81020,28394731040+28381040,28380PC1052.338+28381052.338,28380741060+2837.51060,28375751070+28371070,28370761080+28371080,28370PT1084.801+2836.91084.801,28369771100+2836.9ERROR:#REF!781120+2835.91100,28369791140+2836.51120,28359801160+2835.81140,28365811180+2833.41160,28358821200+2831.81180,28334831220+2828.91200,28318841240+2828.51220,28289851260+2831.41240,28285861280+2832.51260,28314871300+2834.21280,28325881320+28371300,2834289

Curva Asimetricag1 =0.07g2 =-0.07m =5.8676L1 =150A =0.000167A =-0.000188A =0.000250L2 = 190B =-0.07B =0.07B =0.01COTA PIV =2863.90356C =2843.9C =2839.707C =2846.207COTAPCV =2853.404COTA PTV =2850.604Curva Simetrica 3Curva Simetrica 1Curva Simetrica 2ESTACAPROGRESIVAXCota Sobre laCurvaCota Sobre la RazanteESTACAPROGRESIVAXCota Sobre laCurvaCota Sobre la RazanteESTACAPROGRESIVAXCota Sobre laCurvaCota Sobre la RazanteESTACAPROGRESIVAXCota Sobre laCurvaCota Sobre la RazantePCV0484.235+02853.4042853.404PCV0920+02843.900PCV0160+02839.707PCV0330+02846.2070500+15.7652854.4422854.5070930+102843.2170170+102840.3880340+102846.332100510+25.7652855.0342855.2070940+202842.5670180+202841.0320350+202846.507100520+35.7652855.5742855.9070950+302841.9500190+302841.6380360+302846.732100530+45.7652856.0612856.6070960+402841.3670200+402842.2070370+402847.007100540+55.7652856.4962857.3070970+502840.8170210+502842.7380380+502847.332100550+65.7652856.8792858.0070980+602840.3000220+602843.2320390+602847.707100560+75.7652857.2102858.7070990+702839.8170230+702843.6880400+702848.132100570+85.7652857.4892859.4071000+802839.3670240+802844.1070410+802848.607100580+95.7652857.7152860.1071010+902838.9500250+902844.4880420+902849.132100590+105.7652857.8902860.8071020+1002838.5670260+1002844.8320430+1002849.707100600+115.7652858.0122861.5071030+1102838.2170270+1102845.1380440+1102850.332100610+125.7652858.0822862.207PTV1040+1202837.9000280+1202845.407PTV0450+1202851.007100620+135.7652858.1002862.9070290+1302845.638100630+145.7652858.0662863.6070300+1402845.832100634.235+1502858.0362863.9040310+1502845.988100640+155.7652857.983PTV0320+1602846.107100650+165.7652857.866100660+175.7652857.716100670+185.7652857.533100680+195.7652857.319100690+205.7652857.071100700+215.7652856.791100710+225.7652856.479100720+235.7652856.134100730+245.7652855.757100740+255.7652855.347100750+265.7652854.904100760+275.7652854.429100770+285.7652853.922100780+295.7652853.382100790+305.7652852.810100800+315.7652852.205100810+325.7652851.567100820+335.7652850.89710PTV0824.235+3402850.604