PerfilNivel aguas arriba (msnm)970m.s.n.mNivel aguas abajo (msnm)790m.s.n.mCota fondo inicio tnel (msnm)965m.s.n.mPendiente (%)1.5%Longitud de tnel3120mLongitud pozo86m

Datos y PrdidasQ (m3/s)15L (m)3320D3d2.4Tramo2.4Box1%Tunel concreto lanzado25%Tnel revestido65%Tnel con acero9%Rugosidad nConcreto del box-culvert0.012Roca en tnel0.033Concreto lanzado 5 cm0.028Concreto lanzado 10 cm0.025Acero en tubera0.010Concreto del box-culvertGRP0.009Concreto revestimiento tnel0.012Rugosidad e (mm)Concreto del box-culvert1.0TNEL CONCRETO LANZADORoca en tnel150TNEL REVESTIDOTNEL BLINDADOConcreto lanzado 5 cm100Concreto lanzado 10 cm60Acero en tubera0.100GRP0.029Concreto revestimiento tnel0.012BOXCOULVERTTUNEL CONCRETO LANZADOTNEL REVESTIDOTNEL CON ACEROTOTAL hf (Sistema)TOTAL EXCAVACINTOTAL CONCRETO LANZADOTOTAL CONCRETO HIDRULICOECUACIONESD (m)Espesor (m)d (m)rea hid.(m2)Permetro Hid(m)Rh (m)V (m/s)hfPerdidas localesExcavacinConcreto hidrrea hid.(m2)Permetro Hid(m)Rh (m)V (m/s)hfPerdidas localesExcavacinConcreto lanzrea hid.(m2)Permetro Hid(m)Rh (m)V (m/s)hfPerdidas localesExcavacinConcreto hidrad (m)rea hid.(m2)Permetro Hid(m)Rh (m)V (m/s)hfPerdidas localesExcavacinConcreto hidra20.32.45.769.60.62.60.0480.00951.367.72.896.40.455.1925.3945.07882963.8426.81.544.40.359.7464.84212.96837705.84383.81.72.275.30.4256.612.4790.49581067.0388.7111.311737.8426.84840.262.10.32.45.769.60.62.60.0480.00951.571.73.226.80.4754.6519.6423.92853267.5448.11.774.70.3758.4946.7239.34458495.64682.11.72.275.30.4256.612.4790.49581176.3498.182.712940.9448.15251.932.20.32.45.769.60.62.60.0480.00951.675.73.577.10.54.2015.3953.07903586.2469.42.015.00.47.4634.3876.87749324.04985.11.72.275.30.4256.612.4790.49581291.0612.862.814202.8469.45673.572.30.32.45.769.60.62.60.0480.00951.879.73.947.50.5253.8112.2112.44213919.6490.82.275.30.4256.6125.7835.156610190.95292.71.72.275.30.4256.612.4790.49581411.0732.848.615523.3490.86105.172.40.32.45.769.60.62.60.0480.00951.983.74.327.90.553.479.7901.95794267.8512.12.545.70.455.8919.6523.930511096.35604.91.72.275.30.4256.612.4790.49581536.4858.238.416902.5512.16546.742.50.32.45.769.60.62.60.0480.00952.187.64.728.20.5753.187.9261.58534630.9533.42.846.00.4755.2915.2013.040312040.35921.71.72.275.30.4256.612.4790.49581667.1988.930.818340.3533.46998.282.60.32.45.769.60.62.60.0480.00952.291.65.148.60.62.926.4751.29515008.8554.83.146.30.54.7711.9142.382913022.86243.21.72.275.30.4256.612.4790.49581803.21124.925.119836.9554.87459.782.70.32.45.769.60.62.60.0480.00952.495.65.588.90.6252.695.3341.06685401.5576.13.466.60.5254.339.4501.889914043.86569.31.72.275.30.4256.612.4790.49581944.51266.320.821392.2576.17931.242.80.32.45.769.60.62.60.0480.00952.699.66.039.30.652.494.4270.88555809.0597.53.806.90.553.957.5761.515215103.36900.11.72.275.30.4256.612.4790.49582091.21413.017.423006.1597.58412.682.90.32.45.769.60.62.60.0480.00952.8103.66.519.60.6752.303.7010.74026231.3618.84.157.20.5753.616.1341.226816201.47235.41.72.275.30.4256.612.4790.49582243.31565.114.824678.8618.88904.0730.32.45.769.60.62.60.0480.00953.0107.67.0010.00.72.143.1140.62276668.5640.14.527.50.63.325.0111.002317338.07575.41.72.275.30.4256.612.4790.49582400.61722.412.826410.1640.19405.443.10.32.45.769.60.62.60.0480.00953.2111.67.5110.40.7252.002.6360.52717120.4661.54.917.90.6253.064.1280.825618513.17920.11.72.275.30.4256.612.4790.49582563.41885.111.128200.1661.59916.773.20.32.45.769.60.62.60.0480.00953.4115.58.0310.70.751.872.2440.44877587.2682.85.318.20.652.833.4260.685319726.88269.31.72.275.30.4256.612.4790.49582731.42053.29.830048.8682.810438.063.30.32.45.769.60.62.60.0480.00953.6119.58.5811.10.7751.751.9200.38408068.8704.15.738.50.6752.622.8640.572820979.08623.21.72.275.30.4256.612.4790.49582904.82226.68.831956.2704.110969.333.40.32.45.769.60.62.60.0480.00953.8123.59.1411.40.81.641.6510.33038565.3725.56.168.80.72.442.4100.481922269.78981.81.72.275.30.4256.612.4790.49583083.52405.37.933922.3725.511510.553.50.32.45.769.60.62.60.0480.00954.1127.59.7211.80.8251.541.4270.28539076.5746.86.619.10.7252.272.0400.407923598.99344.91.72.275.30.4256.612.4790.49583267.52589.37.235947.1746.812061.753.60.32.45.769.60.62.60.0480.00954.3131.510.3212.10.851.451.2380.24769602.6768.27.079.40.752.121.7360.347324966.79712.71.72.275.30.4256.612.4790.49583456.92778.76.638030.5768.212622.913.70.32.45.769.60.62.60.0480.00954.5135.510.9412.50.8751.371.0790.215810143.5789.57.559.70.7751.991.4860.297226373.010085.11.72.275.30.4256.612.4790.49583651.62973.46.140172.7789.513194.033.80.32.45.769.60.62.60.0480.00954.8139.411.5712.90.91.300.9440.188710699.2810.88.0410.10.81.871.2780.255627817.910462.21.72.275.30.4256.612.4790.49583851.73173.55.742373.5810.813775.123.90.32.45.769.60.62.60.0480.00955.0143.412.2213.20.9251.230.8290.165711269.7832.28.5510.40.8251.751.1040.220829301.210843.91.72.275.30.4256.612.4790.49584057.13378.95.444633.1832.214366.1840.32.45.769.60.62.60.0480.00955.3147.412.8913.60.951.160.7300.146011855.0853.59.0810.70.851.650.9580.191630823.111230.21.72.275.30.4256.612.4790.49584267.83589.65.146951.3853.514967.204.10.32.45.769.60.62.60.0480.00955.6151.413.5813.90.9751.100.6450.129012455.2874.89.6211.00.8751.560.8350.167032383.511621.11.72.275.30.4256.612.4790.49584483.93805.74.849328.2874.815578.194.20.32.45.769.60.62.60.0480.00955.9155.414.2814.311.050.5720.114413070.2896.210.1811.30.91.470.7300.146133982.512016.71.72.275.30.4256.612.4790.49584705.34027.14.651763.8896.216199.144.30.32.45.769.60.62.60.0480.00956.1159.415.0114.61.0251.000.5090.101813700.0917.510.7511.60.9251.400.6410.128235620.012416.91.72.275.30.4256.612.4790.49584932.04253.84.454258.1917.516830.074.40.32.45.769.60.62.60.0480.00956.4163.315.7515.01.050.950.4540.090814344.6938.911.3411.90.951.320.5650.113037296.012821.81.72.275.30.4256.612.4790.49585164.14485.84.356811.1938.917470.954.50.32.45.769.60.62.60.0480.00956.7167.316.5115.41.0750.910.4060.081215004.0960.211.9512.30.9751.260.4990.099939010.513231.21.72.275.30.4256.612.4790.49585401.54723.24.159422.7960.218121.804.60.32.45.769.60.62.60.0480.00957.0171.317.2815.71.10.870.3640.072815678.3981.512.5712.611.190.4430.088640763.613645.31.72.275.30.4256.612.4790.49585644.24966.04.062093.1981.518782.624.70.32.45.769.60.62.60.0480.00957.3175.318.0816.11.1250.830.3270.065416367.41002.913.2012.91.0251.140.3940.078842555.214064.11.72.275.30.4256.612.4790.49585892.35214.03.964822.11002.919453.414.80.32.45.769.60.62.60.0480.00957.6179.318.8916.41.150.790.2950.058917071.31024.213.8513.21.051.080.3510.070244385.314487.41.72.275.30.4256.612.4790.49586145.75467.43.867609.91024.220134.164.90.32.45.769.60.62.60.0480.00958.0183.319.7216.81.1750.760.2660.053217790.01045.514.5213.51.0751.030.3140.062846253.914915.41.72.275.30.4256.612.4790.49586404.45726.23.770456.31045.520824.8750.32.45.769.60.62.60.0480.00958.3187.220.5717.11.20.730.2410.048118523.51066.915.2113.81.10.990.2820.056348161.115348.11.72.275.30.4256.612.4790.49586668.55990.23.773361.41066.921525.555.10.32.45.769.60.62.60.0480.00958.6191.221.4317.51.2250.700.2180.043619271.91088.215.9014.11.1250.940.2530.050650106.815785.31.72.275.30.4256.612.4790.49586937.96259.73.676325.21088.222236.20

PresupuestoPRESUPUESTODESCRIPCIN UNIDADESCANTIDADESCOSTO UNITARIO (US)TOTAL (US)D = 2.0EXCAVACIN SUBTERRANEA EN ROCAm311737.82$200$2,347,564CONCRETO HIDRULICOm34840.26$450$2,178,117CONCRETO LANZADOm3426.75$550$234,714VARIOS%20$952,079COSTO TOTAL$5,712,475D = 2.1EXCAVACIN SUBTERRANEA EN ROCAm312940.95$200$2,588,190CONCRETO HIDRULICOm35251.93$450$2,363,370CONCRETO LANZADOm3448.09$550$246,449VARIOS%20$1,039,602COSTO TOTAL$6,237,610D = 2.2EXCAVACIN SUBTERRANEA EN ROCAm314202.76$200$2,840,553CONCRETO HIDRULICOm35673.57$450$2,553,106CONCRETO LANZADOm3469.43$550$258,185VARIOS%20$1,130,369COSTO TOTAL$6,782,213D = 2.3EXCAVACIN SUBTERRANEA EN ROCAm315523.27$200$3,104,654CONCRETO HIDRULICOm36105.17$450$2,747,328CONCRETO LANZADOm3490.77$550$269,921VARIOS%20$1,224,380COSTO TOTAL$7,346,282D = 2.4EXCAVACIN SUBTERRANEA EN ROCAm315523.27$200$3,104,654CONCRETO HIDRULICOm36105.17$450$2,747,328CONCRETO LANZADOm3490.77$550$269,921VARIOS%20$1,224,380COSTO TOTAL$7,346,282D = 2.5EXCAVACIN SUBTERRANEA EN ROCAm316902.46$200$3,380,493CONCRETO HIDRULICOm36546.74$450$2,946,033CONCRETO LANZADOm3512.10$550$281,656VARIOS%20$1,321,636COSTO TOTAL$7,929,819D = 2.6EXCAVACIN SUBTERRANEA EN ROCAm318340.35$200$3,668,069CONCRETO HIDRULICOm36998.28$450$3,149,224CONCRETO LANZADOm3533.44$550$293,392VARIOS%20$1,422,137COSTO TOTAL$8,532,823D = 2.7EXCAVACIN SUBTERRANEA EN ROCAm319836.92$200$3,967,384CONCRETO HIDRULICOm37459.78$450$3,356,899CONCRETO LANZADOm3554.78$550$305,128VARIOS%20$1,525,882COSTO TOTAL$9,155,293D = 2.8EXCAVACIN SUBTERRANEA EN ROCAm321392.18$200$4,278,436CONCRETO HIDRULICOm37931.24$450$3,569,059CONCRETO LANZADOm3576.12$550$316,864VARIOS%20$1,632,872COSTO TOTAL$9,797,230D = 2.9EXCAVACIN SUBTERRANEA EN ROCAm323006.13$200$4,601,226CONCRETO HIDRULICOm38412.68$450$3,785,704CONCRETO LANZADOm3597.45$550$328,599VARIOS%20$1,743,106COSTO TOTAL$10,458,635D = 3.0EXCAVACIN SUBTERRANEA EN ROCAm3ERROR:#N/A$200ERROR:#N/ACONCRETO HIDRULICOm3ERROR:#N/A$450ERROR:#N/ACONCRETO LANZADOm3ERROR:#N/A$550ERROR:#N/AVARIOS%20ERROR:#N/ACOSTO TOTALERROR:#N/AD = 3.1EXCAVACIN SUBTERRANEA EN ROCAm3ERROR:#N/A$140ERROR:#N/ACONCRETO HIDRULICOm3ERROR:#N/A$400ERROR:#N/ACONCRETO LANZADOm3ERROR:#N/A$500ERROR:#N/AVARIOS%20ERROR:#N/ACOSTO TOTALERROR:#N/AD = 3.2EXCAVACIN SUBTERRANEA EN ROCAm328200.12$140$3,948,016CONCRETO HIDRULICOm39916.77$400$3,966,707CONCRETO LANZADOm3661.47$500$330,733VARIOS%20$1,649,091COSTO TOTAL$9,894,547D = 3.3EXCAVACIN SUBTERRANEA EN ROCAm330048.82$140$4,206,835CONCRETO HIDRULICOm310438.06$400$4,175,225CONCRETO LANZADOm3682.80$500$341,402VARIOS%20$1,744,692COSTO TOTAL$10,468,155D = 3.4EXCAVACIN SUBTERRANEA EN ROCAm331956.22$140$4,473,871CONCRETO HIDRULICOm310969.33$400$4,387,730CONCRETO LANZADOm3704.14$500$352,071VARIOS%20$1,842,734COSTO TOTAL$11,056,405D = 3.5EXCAVACIN SUBTERRANEA EN ROCAm333922.30$140$4,749,123CONCRETO HIDRULICOm311510.55$400$4,604,221CONCRETO LANZADOm3725.48$500$362,739VARIOS%20$1,943,217COSTO TOTAL$11,659,300D = 3.6EXCAVACIN SUBTERRANEA EN ROCAm335947.08$140$5,032,591CONCRETO HIDRULICOm312061.75$400$4,824,698CONCRETO LANZADOm3746.82$500$373,408VARIOS%20$2,046,140COSTO TOTAL$12,276,837D = 3.7EXCAVACIN SUBTERRANEA EN ROCAm338030.54$140$5,324,276CONCRETO HIDRULICOm312622.91$400$5,049,162CONCRETO LANZADOm3768.15$500$384,077VARIOS%20$2,151,503COSTO TOTAL$12,909,018D = 3.8EXCAVACIN SUBTERRANEA EN ROCAm340172.69$140$5,624,177CONCRETO HIDRULICOm313194.03$400$5,277,612CONCRETO LANZADOm3789.49$500$394,746VARIOS%20$2,259,307COSTO TOTAL$13,555,842D = 3.9EXCAVACIN SUBTERRANEA EN ROCAm342373.54$140$5,932,295CONCRETO HIDRULICOm313775.12$400$5,510,049CONCRETO LANZADOm3810.83$500$405,415VARIOS%20$2,369,552COSTO TOTAL$14,217,310D = 4.0EXCAVACIN SUBTERRANEA EN ROCAm344633.07$140$6,248,629CONCRETO HIDRULICOm314366.18$400$5,746,472CONCRETO LANZADOm3832.17$500$416,083VARIOS%20$2,482,237COSTO TOTAL$14,893,421D = 4.1EXCAVACIN SUBTERRANEA EN ROCAm346951.29$140$6,573,180CONCRETO HIDRULICOm314967.20$400$5,986,881CONCRETO LANZADOm3853.50$500$426,752VARIOS%20$2,597,363COSTO TOTAL$15,584,175D = 4.2EXCAVACIN SUBTERRANEA EN ROCAm349328.19$140$6,905,947CONCRETO HIDRULICOm315578.19$400$6,231,276CONCRETO LANZADOm3874.84$500$437,421VARIOS%20$2,714,929COSTO TOTAL$16,289,573D = 4.3EXCAVACIN SUBTERRANEA EN ROCAm351763.79$140$7,246,931CONCRETO HIDRULICOm316199.14$400$6,479,658CONCRETO LANZADOm3896.18$500$448,090VARIOS%20$2,834,936COSTO TOTAL$17,009,614D = 4.4EXCAVACIN SUBTERRANEA EN ROCAm356811.06$140$7,953,548CONCRETO HIDRULICOm317470.95$400$6,988,381CONCRETO LANZADOm3938.85$500$469,427VARIOS%20$3,082,271COSTO TOTAL$18,493,627D = 4.5EXCAVACIN SUBTERRANEA EN ROCAm359422.72$140$8,319,181CONCRETO HIDRULICOm318121.80$400$7,248,722CONCRETO LANZADOm3960.19$500$480,096VARIOS%20$3,209,600COSTO TOTAL$19,257,599D = 4.6EXCAVACIN SUBTERRANEA EN ROCAm362093.08$140$8,693,031CONCRETO HIDRULICOm318782.62$400$7,513,049CONCRETO LANZADOm3981.53$500$490,765VARIOS%20$3,339,369COSTO TOTAL$20,036,213D = 4.7EXCAVACIN SUBTERRANEA EN ROCAm364822.12$140$9,075,097CONCRETO HIDRULICOm319453.41$400$7,781,363CONCRETO LANZADOm31002.87$500$501,434VARIOS%20$3,471,579COSTO TOTAL$20,829,471D = 4.8EXCAVACIN SUBTERRANEA EN ROCAm367609.85$140$9,465,379CONCRETO HIDRULICOm320134.16$400$8,053,662CONCRETO LANZADOm31024.21$500$512,103VARIOS%20$3,606,229COSTO TOTAL$21,637,373D = 4.9EXCAVACIN SUBTERRANEA EN ROCAm370456.27$140$9,863,878CONCRETO HIDRULICOm320824.87$400$8,329,949CONCRETO LANZADOm31045.54$500$522,771VARIOS%20$3,743,320COSTO TOTAL$22,459,918D = 5.0EXCAVACIN SUBTERRANEA EN ROCAm373361.38$140$10,270,594CONCRETO HIDRULICOm321525.55$400$8,610,221CONCRETO LANZADOm31066.88$500$533,440VARIOS%20$3,882,851COSTO TOTAL$23,297,106

Grafico Optimizacin DimetroOPTIMIZACIN DEL DIMETRO EFECTIVO DEL TNEL DE CONDUCCINTOTAL GENERADOENERGIA NO GENERADATIEMPO (1 AO)TOTAL GENERADOENERGIA NO GENERADACOSTO PROYECTO + ENERGIA NO GENERADADIMETRO (m)COSTO (US)SALTO BRUTOhfSALTO NETOEFICIENCIA EQUIPOSPOTENCIA (kW)COSTO UNITARIO kW (US)COSTO kW -hora(US)COSTO kW -hora(US)COSTO kW hora(US)COSTO kW -hora(US)1.9ERROR:#REF!180111.3168.690.9292980.100$930$1,5071$8,033,887.77$13,020,098.79ERROR:#REF!2.0$5,712,47518082.6797.330.92131760.100$1,318$1,1191$11,384,331.77$9,669,654.79$15,382,129.342.1$6,237,61018062.77117.230.92158700.100$1,587$8501$13,711,958.23$7,342,028.33$13,579,638.552.2$6,782,21318048.62131.380.92177850.100$1,779$6581$15,366,612.42$5,687,374.14$12,469,587.002.3$7,346,28218038.36141.640.92191750.100$1,917$5191$16,566,847.57$4,487,138.99$11,833,421.432.4$7,346,28218030.79149.210.92202000.100$2,020$4171$17,453,154.88$3,600,831.68$10,947,114.132.5$7,929,81918025.10154.900.92209700.100$2,097$3401$18,118,152.89$2,935,833.67$10,865,652.672.6$8,532,82318020.77159.230.92215560.100$2,156$2811$18,624,285.82$2,429,700.74$10,962,523.242.7$9,155,29318017.44162.560.92220080.100$2,201$2361$19,014,508.44$2,039,478.12$11,194,771.102.8$9,797,23018014.83165.170.92223600.100$2,236$2011$19,318,908.34$1,735,078.22$11,532,308.622.9$10,458,63518012.78167.220.92226380.100$2,264$1731$19,558,908.46$1,495,078.10$11,953,712.893.0ERROR:#N/A18011.15168.850.92228590.100$2,286$1511$19,749,991.30$1,303,995.26ERROR:#N/A3.1ERROR:#N/A1809.84170.160.92230360.100$2,304$1331$19,903,499.64$1,150,486.92ERROR:#N/A3.2$9,894,5471808.77171.230.92231800.100$2,318$1191$20,027,847.89$1,026,138.67$10,920,686.053.3$10,468,1551807.91172.090.92232980.100$2,330$1071$20,129,350.33$924,636.23$11,392,790.923.4$11,056,4051807.19172.810.92233940.100$2,339$971$20,212,795.97$841,190.59$11,897,596.003.5$11,659,3001806.60173.400.92234740.100$2,347$891$20,281,852.90$772,133.66$12,431,433.183.6$12,276,8371806.11173.890.92235410.100$2,354$831$20,339,356.57$714,629.99$12,991,467.013.7$12,909,0181805.70174.300.92235970.100$2,360$771$20,387,517.53$666,469.03$13,575,486.933.8$13,555,8421805.35174.650.92236440.100$2,364$721$20,428,073.02$625,913.54$14,181,755.723.9$14,217,3101805.06174.940.92236830.100$2,368$681$20,462,398.50$591,588.06$14,808,897.924.0$14,893,4211804.81175.190.92237170.100$2,372$651$20,491,590.68$562,395.88$15,455,816.804.1$15,584,1751804.59175.410.92237460.100$2,375$621$20,516,529.79$537,456.77$16,121,632.144.2$16,289,5731804.41175.590.92237710.100$2,377$601$20,537,926.72$516,059.84$16,805,633.064.3$17,009,6141804.25175.750.92237920.100$2,379$581$20,556,358.98$497,627.58$17,507,242.034.4$18,493,6271804.12175.880.92238110.100$2,381$561$20,572,298.33$481,688.23$18,975,315.334.5$19,257,5991804.00176.000.92238270.100$2,383$541$20,586,132.16$467,854.40$19,725,452.914.6$20,036,2131803.90176.100.92238400.100$2,384$531$20,598,180.20$455,806.36$20,492,019.674.7$20,829,4711803.81176.190.92238530.100$2,385$521$20,608,707.57$445,278.99$21,274,750.494.8$21,637,3731803.73176.270.92238630.100$2,386$501$20,617,935.10$436,051.46$22,073,424.544.9$22,459,9181803.66176.340.92238730.100$2,387$501$20,626,047.52$427,939.04$22,887,857.095.0$23,297,1061803.60176.400.92238810.100$2,388$491$20,633,199.99$420,786.57$23,717,892.98DE ACUERDO A LA GRAFICA - EL DIMETRO OPTIMO CORRESPONDE A 2.7 m