hoja de calculo

39
INGENIERIA HIDRAULICA UNIVERSIDAD NACIONAL DE CAJAMARCA Diseño de Sistemas de Riego I PARAMETROS GEOMORFOLOGICOS DE LA SUB CUENCA ALTA DEL metros Km Area 1657!"16#16 165#7$ Perimetro 56755#$ 56#76 1 COEFICIENTE DE GRAVELLIUS 1#%$6!675 2 LONGITUD DEL MAXIMO RECORRIDO L&m' 7!!#66 L&(m' #7!!66 FACTOR DE FORMA )* "#"51%%+!55 ! RECTANGULO E"UIVALENTE a* !(m ,* "(m - . * *&/ _ _ '0/ _ *&/ _ _ '0/ _ *&&/ / ' _ _ _ ) 0&/ / ' _ _ 8 km 2# $m

Upload: ronald

Post on 04-Nov-2015

7 views

Category:

Documents


1 download

DESCRIPTION

hoja de calculos

TRANSCRIPT

PARAMETROS PARAMETROS GEOMORFOLOGICOS DE LA SUB CUENCA ALTA DEL RIO NAMORA7 PENDIENTE DEL CAUCE PRINCIPALCOTASPi -(Pi-1)Li Li AC.Si(Li2/Si)(Li2/Si)1/2metrosKm290000Area165728016.16165.732950502769.2052769.2050.02424712767.70250620608.5605441648Perimetro56755.2356.763000502153.0174922.2220.02199605439.69451314128.1789235033050501542.0086464.230.0373331383.09264138563.37451549571 COEFICIENTE DE GRAVELLIUS310050828.1497292.3790.0611359401.26397183370.3710869831315050861.4678153.8460.0612786330.70293473575.7979113667Kc=1.2436867524320050865.4679019.3130.0612965269.08535613600.7317430428325050548.29567.5130.093294936.803361815.1960784885330050313.0099880.5220.16613338.844781195783.1595270321335050451.83410332.3560.111844874.039387231358.2614031869340050241.21410573.570.21280696.842446167529.808307264234505042.18910615.7591.191501.853911945438.7537599717350050364.09310979.8520.14965310.396590247982.50211022183550501669.33812649.190.0393038528.79824659645.6481792696360050590.66813239.8580.084121547.650291152030.1595135092 LONGITUD DEL MAXIMO RECORRIDO3650502466.79915706.6570.02300214239.00665417326.69151934823700501132.25216838.9090.0429030818.80439175388.0255014608L(m)22788.663750502013.3418852.2490.02163223002.15055412775.8757880058L(km)22.78866380050562.78419415.0330.093564964.597598131888.1113837902385050426.76719841.80.121554542.091211191246.81277311843 FACTOR DE FORMA390050457.06620298.8660.111909707.021487271381.92149613763950502476.69522775.5610.02303841840.30410817431.059643754F=0.051449855122775.561128469.001709115

4 RECTANGULO EQUIVALENTESc3.14%

a=8kmb=20km5 PENDIENTE DE LA CUENCA8 TIEMPO DE CONCENTRACIONCRITERIO SEGN HORTONlineas de reticuladonumero de intersecciones y tangenciaslongitud de lineas del reticulado (m)

NxNyLx (m)Ly(m)L = Longitud de mximo recorrido, m22788.660S = Pendiente del mximo recorrido (adim.)3.14%111155717.545834.94Tc = Tiempo de concentracin, en minutos167.2372255185226127512.617498.14Tc = Tiempo de concentracin, en horas2.787287092328339158.3910037.274303713133.512126.215265513842.7115439.226256213079.9316749.979 CURVA HIPSOMETRICA7314012836.2216605.18372012037.0915805.42TRAMOSELEVACIONArea (m)Area (km^2)%A parcial%A acumulada93089133.9410577.40290000.000010278960.263454.43T1290029501677140.881.681.011.0111165454.4T2295030006095940.626.103.684.6912T3300030506683712.816.684.038.72SUMA287282110866.59114128.1T4305031006082231.346.083.6712.39SUMA569224994.69T5310031506636489.636.644.0016.40T6315032006194000.456.193.7420.14T7320032506899547.956.904.1624.30T8325033006937620.786.944.1928.48EQUIDISTANCIA (m)50T9330033507922852.627.924.7833.27T10335034007616988.697.624.6037.86Sx0.129434846T11340034502977865.72.981.8039.66T12345035002834364.462.831.7141.37T133500355016140658.8516.149.7451.11Sy0.1235453845T143550360011280739.0711.286.8157.91T153600365011542409.3411.546.9664.88T16365037008129928.318.134.9169.78Sc 0.1985224629T173700375010112929.2510.116.1075.89T183750380013995953.2814.008.4584.33aritmeticoSc0.1264901152T193800385013780216.1613.788.3192.65T20385039007616393.27.624.6097.24geometricoSc0.1264558335T21390039503677511.113.682.2299.46T2239504000892521.660.890.54100.006 LONGITUD DEL CENTROIDEarea total165728016.16165.73

L (m)3.22

ALTURA MEDIA3550msnm10 COEFICIENTE DE MASIVIDAD (Cm)H (Altitud media, msnm)3550A (Area proyectada de la cuenca)km2165.73COEFICIENTE DE MASIVIDAD (Cm)km-10.02142063911 COEFICIENTE OROGRAFICOH = Altitud media, s.n.m m3550A = rea proyectada de la cuencam2165.73C0 = Coeficiente orogrfico76043.2683139891

CUADRO DE RESUMEN DE LOS PARAMETROSDESCRIPCINSMBOLOUNIDADVALOR1 COEFICIENTE DE GRAVELLIUSKc1.242 LONGITUD DEL MAXIMO RECORRIDOLKm22.793 FACTOR DE FORMAF0.054 RECTANGULO EQUIVALENTERemxm8 X 205 PENDIENTE DE LA CUENCASc%19.856 LONGITUD DEL CENTROIDELcm3.227 PENDIENTE DEL CAUCE PRINCIPALS%0.0318 TIEMPO DE CONCENTRACIONtcHoras2.799 ALTURA MEDIAHm.s.n.m.355010 COEFICIENTE DE MASIVIDAD (Cm)CmKm-10.02142111 COEFICIENTE OROGRAFICOCo76043.2712 ORDEN DEL CAUCEN4

&"Freestyle Script,Normal"INGENIERIA HIDRAULICA&14UNIVERSIDAD NACIONAL DE CAJAMARCA

&"Freestyle Script,Negrita"&12Diseo de Sistemas de Riego I

8 km20 kmCALCULOS

precipitaciones (2)CALCULO DE LA INTENSIDAD MAXIMA DE DISEOLLUVIAS MAXIMAS (mm)/ FUENTE: ESTACION WEBERBAUERAOP.Mx.24h.DURACION EN MINUTOS51030601201502002201440197537.99.20
COMPAQ: COMPAQ:de la formula el dato 1440=24*6010.9414.4017.1220.3621.5323.1423.69197672.917.7021.0427.7032.9439.1741.4244.5045.58197740.59.8311.6915.3918.3021.7623.0124.7225.32197814.83.594.275.626.697.958.419.049.251979286.808.0810.6412.6515.0415.9117.0917.51198028.86.998.3110.9413.0115.4716.3617.5818.01198139.39.5411.3414.9317.7621.1222.3323.9924.57198230.57.408.8011.5913.7816.3917.3318.6219.07198329.87.238.6011.3213.4616.0116.9318.1918.63198427.66.707.9710.4912.4714.8315.6816.8517.26198519.84.815.727.528.9510.6411.2512.0912.38198627.46.657.9110.4112.3814.7215.5716.7317.13198724.35.907.019.2310.9813.0613.8114.8315.19198818.24.425.256.918.229.7810.3411.1111.381989307.288.6611.4013.5516.1217.0418.3118.76199024.76.007.139.3811.1613.2714.0315.0815.44199129.77.218.5711.2813.4215.9616.8718.1318.57199217.74.305.116.728.009.5110.0610.8111.07199322.55.466.508.5510.1712.0912.7813.7414.07199428.56.928.2310.8312.8815.3116.1917.4017.82199520.65.005.957.839.3111.0711.7012.5812.88199635.18.5210.1313.3415.8618.8619.9421.4321.94199727.66.707.9710.4912.4714.8315.6816.8517.26199831.77.709.1512.0414.3217.0318.0119.3519.82199938.89.4211.2014.7417.5320.8522.0423.6924.26200036.18.7610.4213.7216.3119.4020.5122.0422.57200128.26.858.1410.7112.7415.1516.0217.2217.63200222.35.416.448.4710.0811.9812.6713.6113.94200320.85.056.007.909.4011.1811.8212.7013.00200428.16.828.1110.6812.7015.1015.9617.1517.57200520.24.905.837.679.1310.8511.4812.3312.63200620.65.005.957.839.3111.0711.7012.5812.88200725.46.177.339.6511.4813.6514.4315.5115.882008276.557.7910.2612.2014.5115.3416.4816.88200922.25.396.418.4310.0311.9312.6113.5513.88

INTENSIDADES MAXIMAS (mm/h) - ESTACION WEBERBAHUAER

Latitud:0710' ( S )Departamento : Cajamarca Longitud:7830' ( W )Provincia : Cajamarca Altitud2536Distrito : CajamarcaAo5 min10 min30 min60 min120 min150 min200 min220 min1975110.4065.6428.8017.1210.188.616.946.46110.40082888621976212.35126.2755.3932.9419.5816.5713.3512.43212.35410094481977117.9770.1530.7718.3010.889.207.426.91197843.1125.6311.256.693.983.362.712.5210.2197981.5648.5021.2812.657.526.365.134.77198083.8949.8821.8813.017.746.545.274.911981114.4868.0729.8617.7610.568.937.206.70198288.8452.8323.1713.788.196.935.595.20198386.8151.6222.6413.468.016.775.465.08198480.4047.8020.9712.477.416.275.054.71198557.6834.2915.048.955.324.503.633.38198679.8147.4620.8212.387.366.235.024.67198770.7842.0918.4610.986.535.524.454.14198853.0231.5213.838.224.894.143.333.10198987.3951.9622.8013.558.066.825.495.12199071.9542.7818.7711.166.645.614.524.21199186.5151.4422.5713.427.986.755.445.06199251.5630.6613.458.004.754.023.243.02199365.5438.9717.1010.176.045.114.123.84199483.0249.3621.6612.887.666.485.224.86199560.0135.6815.659.315.534.683.773.511996102.2460.7926.6715.869.437.986.435.98199780.4047.8020.9712.477.416.275.054.71199892.3454.9124.0914.328.527.205.815.411999113.0267.2029.4817.5310.428.827.116.622000105.1662.5327.4316.319.708.206.616.16200182.1548.8421.4312.747.586.415.164.81200264.9638.6216.9410.085.995.074.083.80200360.5936.0315.809.405.594.733.813.55200481.8548.6721.3512.707.556.395.154.79200558.8434.9915.359.135.434.593.703.44200660.0135.6815.659.315.534.683.773.51200773.9943.9919.3011.486.825.774.654.33200878.6546.7720.5212.207.256.144.944.60200964.6738.4516.8710.035.965.044.073.79

Fuente: ESTACION METEOROLOGICA AUGUSTO WEBERBAUER

TRANSFERENCIA DE INTENSIDADES A LA SUBCUENCA

Altitud3550(Altitud media de la Sub cuenca) Factor de transferencia =1.40

mAo5 min10 min30 min60 min120 min150 min200 min220 min11975154.591.940.324.014.312.19.79.060.349537110835.884049459615.74202165789.360262085.56564513194.707962583.79427627153.532518427121976297.3176.877.546.127.423.218.717.472.174784247442.915383475418.826606982611.19436748756.65621073215.63046876124.53774932464.224701091831977165.198.243.125.615.212.910.49.774.213619960644.127682443619.358432038611.51059255786.84423928385.78952155114.66593433384.34404293064197860.335.915.79.45.64.73.83.580.737894242848.00703914221.060272217812.52251278277.44593064946.29849047865.07612636324.725936814651979114.267.929.817.710.58.97.26.782.368962813448.976878316521.485732262612.77549283897.59635349086.42573271055.17867437054.821410285661980117.469.830.618.210.89.27.46.984.00003138449.946717491121.911192307513.02847289517.74677633226.55297494245.28122237784.916883756671981160.395.341.824.914.812.510.19.484.00003138449.946717491121.911192307513.02847289517.74677633226.55297494245.28122237784.916883756681982124.474.032.419.311.59.77.87.384.815565669250.431637078422.123922329913.15496292327.82198775296.61659605845.33249638154.964620492191983121.572.331.718.811.29.57.67.190.524305666253.826074189523.613032486714.040393128.34846769797.061943875.69141440725.2987776406101984112.566.929.417.510.48.87.16.690.932072808954.068533983123.719397497914.1036381348.38607340827.09375442795.7170514095.322646008311198580.748.021.112.57.46.35.14.791.747607094154.553453570423.932127520314.23012816218.46128482897.15737554395.76832541275.3703827438121986111.766.429.117.310.38.77.06.599.087415661758.91772985625.846697721915.36853841519.13818761527.72996558746.22979144575.800013363313198799.158.925.815.49.17.76.25.8100.718484232259.887569030626.272157766715.62151847139.28861045667.85720781936.3323394535.895486834314198874.244.119.411.56.85.84.74.3103.572854230761.584787586227.016712845116.06423356979.55185042918.07988172516.51179846596.0625654086151989122.372.731.919.011.39.57.77.2110.09712851365.464144284528.718553024317.076153794610.15354179478.58885065276.92199049526.4444592926161990100.759.926.315.69.37.96.35.9111.728197083566.433983459129.144013069117.329133850810.30396463618.71609288467.02453850266.5399327636171991121.172.031.618.811.29.47.67.1112.543731368866.918903046429.356743091517.455623878910.37917605688.77971400057.07581250626.587669499118199272.242.918.811.26.75.64.54.2112.543731368866.918903046429.356743091517.455623878910.37917605688.77971400057.07581250626.587669499119199391.754.623.914.28.57.25.85.4114.174799939467.88874222129.782203136317.708603935110.52959889828.90695623247.17836051366.6831429701201994116.269.130.318.010.79.17.36.8114.58256708268.131202014629.888568147517.771848949210.56720460858.93876679047.20399751546.707011337921199584.049.921.913.07.76.65.34.9114.990334224768.373661808229.994933158717.835093963210.60481031898.97057734837.22963451726.7308797056221996143.185.137.322.213.211.29.08.4116.213635652669.101041189230.314028192418.024829005410.71762744999.06600902237.30654552276.8024848089231997112.566.929.417.510.48.87.16.6117.436937080569.828420570130.63312322618.214564047510.8304445819.16144069627.38345652826.8740899121241998129.376.933.720.011.910.18.17.6121.106841364372.010558712931.590408326818.78376917411.16889597429.44773571797.61418954477.0889052219251999158.294.141.324.514.612.39.99.3121.514608506972.253018506631.69677333818.847014188111.20650168459.47954627597.63982654667.1127735896262000147.287.538.422.813.611.59.38.6122.330142792272.737938093931.909503360418.973504216211.28171310529.54316739197.69110055027.1605103251272001115.068.430.017.810.69.07.26.7124.368978505473.950237062132.441328416419.289729286411.4697416579.70222018177.81928555947.279852163928200290.954.123.714.18.47.15.75.3129.262184217176.859754585933.717708550820.048669455111.921010181210.08394687748.12692958147.566272576929200384.850.422.113.27.86.65.35.0143.126267066985.103387569837.334118931622.198999932913.199604333111.16550584858.99858764388.3777970804302004114.668.129.917.810.68.97.26.7147.203938493387.527985506338.397769043622.831450073513.575661436611.48361142829.25495766218.616480757931200582.449.021.512.87.66.45.24.8154.543747060891.892261791940.312339245323.969860326414.252564222912.05620147179.71642369519.046111377432200684.049.921.913.07.76.65.34.9158.213651344694.074399934841.269624346124.539065452914.591015616112.34249649359.94715671169.2609266871332007103.661.627.016.19.68.16.56.1160.252487057895.28669890341.801449402124.855290523214.779044167812.501549283310.07534172089.3802685259342008110.165.528.717.110.28.66.96.4165.145692769498.196216426743.077829536525.614230691815.23031269212.88327597910.38298574289.666688938935200990.553.823.614.08.37.15.75.3297.262246985176.753189568177.540093165746.105615245327.414562845623.189896762218.689374337117.40004009Promedio116.269.130.318.010.79.17.36.8Desv. Est.41.124.410.76.43.83.22.62.4

VERIFICACION PARA VER EL AJUSTE DEL MODELO PROBABILISTICO CON INTENSIDADES. A DIFERENTES PERIODOS DE DURACION USANDO PROGRAMA RELAN

PARA 5 MINUTOS

PARA 10 MINUTOS

PARA 30 MINUTOS

PARA 60 MINUTOS

PARA 120 MINUTOS

PARA 150 MINUTOS

PARA 200 MINUTOS

PARA 220 MINUTOS

APLICANDO EL MODELO DE GUMBELTr 5051030601201502002200.040.060.140.240.400.480.590.6499.4559.1425.9415.439.181.766.255.82204121533219101312

x40y35.5608461081

9261019.9732992.119259393.78733600.92

83.78

I= 13.31mm/hDel cuadro y la grafica, para el tiempo de concentracin167.2Minutos :

Q = CIA / 360

C =0.41pendiente superior al 7%I =13.31TR 10 aos y Vida til 30 aosA =16572.80Ha

Q =251.15m3/seg

CUENCA

PUNTO MINPUNTO MINPUNTO MINPUNTO MINPUNTO MINPUNTO MINPUNTO MINPUNTO MIN

BALANCE HIDRICOPARAMETROS GEOMORFOLOGICOS DE LA SUB CUENCA ALTA DEL RIO NAMORAmetrosKmParmetroEnePARA ENCONTRAR RAcuencaarea166290502.21166.29n (horas)888a=0.31perimetro56755.2356.76Tmed (C)253035b=0.42embalsearea5000.5Tmed (K)298303308diferencia de areas165.79es (mb)31.6842.4356.23HR (%)707580e (mb)22.1731.8244.981COEFICIENTE DE GRAVELLIUSVz=1m (m/s)455Vz=3m (m/s)688Kc=1.2415815539Vz=2m (km/d)432.0561.6561.6P (kPa)100.1100.1100.1PARA ENCONTRAR N2.262.262.260.070.070.070.190.240.31W0.720.770.81Ra (mm)16.3616.2715.51N (horas)12.6012.4012.102Longitud de Mximo Recorridoa0.310.310.31b0.420.420.42L16163.15Rg (mm)9.439.459.12albedo0.200.200.20Rns (mm)7.557.567.293Factor de Forma.Rnl (mm)1.391.040.56Rn (mm)6.156.526.74F=0.0000181908ETo(mm/dia)8.239.369.25Kc0.700.800.80ETP(mm/dia)5.767.497.404Rectngulo Equivalentedas/mes312831ETP(mm/mes)178.6209.7229.4ETP(MMC)29.634.838.013E (mm/mes)389.21553.38586.652E (MMC)0.1950.2770.293

Q (m3/s) 0.50.50.5a=8km Q (MMC) 1.341.211.34b=20km P (MMC) 50.750865729355.509256777962.0968433508 ETP (MMC) 29.634.838.0 ETR (MMC) 29.634.838.0 E (MMC) 0.20.30.3Q (MMC)1.341.211.34A1=A2=2515% DS (MMC) 19.6219.2622.43A3=116.2905022170% Sinicial (MMC) 121212 Sfinal (MMC) 31.6231.2634.43

PRECIPITACIONest.areaEnFebMarNO15%220275330NE15%275308363Sur70%330352385ETP(mm/dia)=EtoxkcP (mm)305.1940132168333.8089430256373.4238728345P(MMC)50.750865729355.509256777962.0968433508

EVAPOTRANSPIRACIONParametroEnfebmarn(horas)888Tmed(C)253035HR(%)707580Vz=1m(m/s)455Vz=3m(m/s)688Kc0.70.80.8Z(altitud pm km)100100100albedo0.20.20.2n/N0.60.60.6

PRECIPITACIONNOSx=ERROR:#REF!ERROR:#REF!0.1997630253Sy=ERROR:#DIV/0!ERROR:#DIV/0!

S=ERROR:#REF!ERROR:#REF!S=ERROR:#REF!ERROR:#REF!

Tc=

LONG en metrosN DE CURVAS QUE CRUZANLONG en metros0Y0000Y11954.250Y292612.822997.04Y3122575.346793.4Y4123382.638287.21Y5153912.3510776.2Y6244935.649895.24Y7196302.794301.92Y8336673.170Y9345499.750Y10284788.0143051.01Y1192737.3TOTAL Y19644374.0587425.06

8 km20 kmTK = Temperatura del aire (K)s = Constante de Stefan Woltzman: 1.9804x10-9La cuenca posee un embalse de 0.5 km2 en su punto ms bajo, de modo que el rea es de 100-0.5 = 99.5 km2

Hoja41010Area cuenca100permetro40Kc1.1283791671Area embalse0.5Precipitacinalfa26.5650511771EstacinPolgonosEneFebMar90-alfa63.4349488229NO25%220275330seno (90-alfa)0.894427191NE25%2753083631.1180339887Sur50%330352385hipP (mm)1.25P (MMC)0.00.06.253.75ParmetroEneFebMar25n (horas)888Tmed (C)253035Tmed (K)298303308es31.6842.4356.23HR (%)707580e22.1731.8244.98Vz=1m (m/s)455Vz=3m (m/s)688Vz=2m (km/d)432.0561.6561.6P (kPa)100.1100.1100.12.262.262.260.070.070.070.190.240.31W0.720.770.81Ra (mm)16.3616.2715.51N (horas)12.6012.4012.10a0.310.310.31b0.420.420.42Rg (mm)9.439.459.12albedo0.200.200.20Rns (mm)7.557.567.29Rnl (mm)1.391.040.56Rn (mm)6.156.526.74ETo(mm/dia)8.239.369.25Kc0.700.800.80ETP(mm/dia)5.767.497.40das/mes312831ETP(mm/mes)178.6209.7229.4ETP(MMC)17.820.922.8

E (mm/mes)389.2553.4586.6E (MMC)0.20.30.3

Q (m3/s) 0.50.50.5 Q (MMC) 1.31.21.3

Enero Febrero Marzo P (MMC) 0.00.00.0 ETP (MMC) 17.820.922.8 ETR (MMC) 17.820.922.8 E (MMC) 0.20.30.3Q (MMC)1.31.21.3 DS (MMC) -19.3-22.4-24.5 Sinicial (MMC) 12-7.3-29.7 Sfinal (MMC) -7.3-29.7-54.1

Hoja3PARAMETROS GEOMORFOLOGICOS DE LA SUB CUENCA ALTA DEL RIO NAMORA

metrosKmcuencaarea166290502.21166.29perimetro56755.2356.761COEFICIENTE DE GRAVELLIUS

Kc=ERROR:#VALUE!2Longitud de Mximo Recorrido

L16163.15

3Factor de Forma.

F=0.05162447754Rectngulo Equivalente

a=ERROR:#VALUE!b=ERROR:#VALUE!