13
ABSCISA COTA DESNIVEL 0 0 00+000.00 240 0 8 400 00+400.00 240 0 8 400 00+800.00 280 40 8 400 01+200.00 320 40 8 400 01+600.00 280 -40 4 200 01+800.00 280 0 8 400 02+200.00 320 40 4 200 02+400.00 320 0 8 400 02+800.00 360 40 8 400 03+200.00 400 40 8 400 03+600.00 440 40 4 200 03+800.00 440 0 8 400 04+200.00 480 40 8 400 04+600.00 440 -40 8 400 05+000.00 400 -40 Puente 2 100 05+100.00 400 0 8 400 05+500.00 440 40 8 400 05+900.00 480 40 2 100 06+000.00 480 0 8 400 06+400.00 440 -40 4 200 06+600.00 440 0 8 400 07+000.00 400 -40 8 400 07+400.00 360 -40 3 150 07+550.00 360 0 8 400 07+950.00 400 40 8 400 08+350.00 360 -40 8 400 08+750.00 320 -40 8 400 09+150.00 360 40 8 400 09+550.00 400 40 8 400 09+950.00 440 40 4 200 10+150.00 440 0 8 400 10+550.00 480 40 3 150 10+700.00 480 0 8 400 11+100.00 520 40 8 400 11+500.00 560 40 2 100 11+600.00 560 0 8 400 12+000.00 520 -40 8 400 12+400.00 480 -40 2 100 12+500.00 480 0 8 400 12+900.00 520 40 8 400 13+300.00 560 40 8 400 13+700.00 600 40 8 400 14+100.00 600 0

Metodo de Bruce

Embed Size (px)

DESCRIPTION

Hoja de Calculo del Metodo de Bruce

Citation preview

Hoja1ABSCISACOTADESNIVELGRADIENTE0000000.00+24000840000400.00+2400840000800.00+28040840001200.00+32040840001600.00+280-40420001800.00+2800840002200.00+32040420002400.00+3200840002800.00+36040840003200.00+40040840003600.00+44040420003800.00+4400840004200.00+48040840004600.00+440-40840005000.00+400-40Puente210005100.00+4000840005500.00+44040840005900.00+48040210006000.00+4800840006400.00+440-40420006600.00+4400840007000.00+400-40840007400.00+360-40315007550.00+3600840007950.00+40040840008350.00+360-40840008750.00+320-40840009150.00+36040840009550.00+40040840009950.00+44040420010150.00+4400840010550.00+48040315010700.00+4800840011100.00+52040840011500.00+56040210011600.00+5600840012000.00+520-40840012400.00+480-40210012500.00+4800840012900.00+52040840013300.00+56040840013700.00+60040840014100.00+6000840014500.00+560-40840014900.00+5600840015300.00+60040840015700.00+64040840016100.00+68040840016500.00+72040840016900.00+76040840017300.00+80040840017700.00+84040840018100.00+88040840018500.00+92040840018900.00+96040840019300.00+100040840019700.00+104040840020100.00+108040840020500.00+112040840020900.00+116040210021000.00+11600840021400.00+120040840021800.00+124040840022200.00+128040840022600.00+132040840023000.00+136040840023400.00+140040840023800.00+144040840024200.00+148040840024600.00+152040840025000.00+156040840025400.00+160040210025500.00+16000840025900.00+164040840026300.00+168040840026700.00+172040210026800.00+17200840027200.00+176040840027600.00+180040840028000.00+184040840028400.00+188040840028800.00+192040840029200.00+196040840029600.00+200040840030000.00+204040840030400.00+208040840030800.00+212040840031200.00+216040840031600.00+220040420031800.00+22000840032200.00+224040840032600.00+228040840033000.00+232040840033400.00+236040840033800.00+240040840034200.00+244040840034600.00+248040840035000.00+252040840035400.00+256040840035800.00+260040840036200.00+264040840036600.00+2600-40210036700.00+26000840037100.00+264040840037500.00+268040840037900.00+272040840038300.00+276040840038700.00+280040840039100.00+284040840039500.00+288040840039900.00+292040630040200.00+29200840040600.00+296040840041000.00+300040210041100.00+30000840041500.00+304040210041600.00+30400840042000.00+308040525042250.00+30800840042650.00+312040840043050.00+316040840043450.00+320040840043850.00+324040840044250.00+328040840044650.00+332040

Hoja2ABSCISACOTADESNIVELGRADIENTEABSCISACOTADESNIVELk3540000000.00+24000%00000.00+2400040000400.00+2804010%00800.00+3208010%10%48.00Lv ida44250.00+Lv regreso44250.00+40000800.00+3204010%01400.00+280-407%7%16.00356048040001200.00+280-40-10%03800.00+4802008%8%104.001246001680020001400.00+28000%04700.00+400-809%9%44.00177530.00+130140.00+40001800.00+3204010%05600.00+480809%9%44.0020002000.00+32000%07000.00+360-1209%9%64.0040002400.00+3604010%07550.00+400407%7%18.00340002800.00+4004010%08350.00+320-8010%10%48.0040003200.00+4404010%11200.00+5602408%8%126.0020003400.00+44000%12100.00+480-809%9%44.00240040003800.00+4804010%13700.00+6001208%8%56.0040004200.00+440-40-10%14500.00+560-405%5%8.0040004600.00+400-40-10%21000.00+120064010%10%380.0010004700.00+40000%28000.00+188068010%10%400.0040005100.00+4404010%32200.00+228040010%10%232.0040005500.00+4804010%35800.00+264036010%10%216.0010005600.00+48000%36200.00+2600-4010%10%24.0040006000.00+440-40-10%44250.00+33207209%9%398.0020006200.00+44000%40006600.00+400-40-0.14%40007000.00+360-40-0.115007150.00+3600040007550.00+400400.140007950.00+360-40-0.140008350.00+320-40-0.140008750.00+360400.140009150.00+400400.140009550.00+440400.120009750.00+4400040010150.00+480400.115010300.00+4800040010700.00+520400.140011100.00+560400.110011200.00+5600040011600.00+520-40-0.140012000.00+480-40-0.110012100.00+4800040012500.00+520400.140012900.00+560400.140013300.00+600400.140013700.00+6000040014100.00+560-40-0.140014500.00+5600040014900.00+600400.140015300.00+640400.140015700.00+680400.140016100.00+720400.140016500.00+760400.140016900.00+800400.140017300.00+840400.140017700.00+880400.140018100.00+920400.140018500.00+960400.140018900.00+1000400.140019300.00+1040400.140019700.00+1080400.140020100.00+1120400.140020500.00+1160400.110020600.00+11600040021000.00+1200400.140021400.00+1240400.140021800.00+1280400.140022200.00+1320400.140022600.00+1360400.140023000.00+1400400.140023400.00+1440400.140023800.00+1480400.140024200.00+1520400.140024600.00+1560400.140025000.00+1600400.110025100.00+16000040025500.00+1640400.140025900.00+1680400.140026300.00+1720400.110026400.00+17200040026800.00+1760400.140027200.00+1800400.140027600.00+1840400.140028000.00+1880400.140028400.00+1920400.140028800.00+1960400.140029200.00+2000400.140029600.00+2040400.140030000.00+2080400.140030400.00+2120400.140030800.00+2160400.140031200.00+2200400.120031400.00+22000040031800.00+2240400.140032200.00+2280400.140032600.00+2320400.140033000.00+2360400.140033400.00+2400400.140033800.00+2440400.140034200.00+2480400.140034600.00+2520400.140035000.00+2560400.140035400.00+2600400.140035800.00+2640400.140036200.00+2600-40-0.110036300.00+26000040036700.00+2640400.140037100.00+2680400.140037500.00+2720400.140037900.00+2760400.140038300.00+2800400.140038700.00+2840400.140039100.00+2880400.140039500.00+2920400.130039800.00+29200040040200.00+2960400.140040600.00+3000400.110040700.00+30000040041100.00+3040400.110041200.00+30400040041600.00+3080400.125041850.00+30800040042250.00+3120400.140042650.00+3160400.140043050.00+3200400.140043450.00+3240400.140043850.00+3280400.140044250.00+3320400.1

Hoja3RUTA 1RUTA 2PUNTOS OBLIGADOSABSCISACOTAPUNTOS OBLIGADOSABSCISACOTAAH. LOS GUERREROSaEL PROGRESO bMORAScCARCHIdTENGUELILLOB