hojas de excel

AREA DE LA CUENCA A= Km2LONGITUD DEL RIO L= 0 Km

PENDIENTE S= 0 mDESNIVEL D= 0 m

KIRPICH

tc= #DIV/0!

SOIL CONSERVATION SERVICE

tc= #DIV/0!

ROWE

tc= #DIV/0!

Tr= 0d= 0 tc= #DIV/0!K= 0

hp= Err:502

MERRIL BERNARD

i= #DIV/0!

E.KUICHLINGe=tc= #DIV/0!C=

Q= #DIV/0!

𝑖=(𝐾 〖𝑇𝑟〗 ^𝑚)/𝑑^𝑛 (260.149 〖𝑇𝑟〗 ^0.355)/𝑑^0.558

𝑡𝑐=(0.000325𝐿^0.77)/𝑆^0.385 𝑡𝑐=𝐿^1.15/ 〖 3085 𝐷 〗 ^0.385

𝑡𝑐=(〖 0.87 𝐿〗 ^3/ )𝐷 ^0.385

𝑖=𝐾/(1−𝑒)𝑡𝑐K=(ℎ𝑝(1−𝑒))/ 〖 24 〗 ^(1−𝑒) hp=(𝐾( 〖𝑡𝑐〗 ^(1−𝑒)))/(1−𝑒)

hp=(𝐾 )/( 60) 〖𝑇𝑟〗 ^𝑚 𝑑^(1−𝑛)

Q=0.278 𝐶 𝑖 𝐴

CURVAS INTENSIDAD - DURACION - PERIODO DE RETORNO

Intensidades máximas registradas en la estación climatológica

5 10 15 20 30 40 60 80 100

m i d Tr= n+1/m log i log Tr Log d

1 0.0 5 24.00 Err:502 1.3802 0.69902 0.0 5 12.00 Err:502 1.0792 0.69903 0.0 5 8.00 Err:502 0.9031 0.69904 0.0 5 6.00 Err:502 0.7782 0.69905 0.0 5 4.80 Err:502 0.6812 0.69906 0.0 5 4.00 Err:502 0.6021 0.69907 0.0 5 3.43 Err:502 0.5351 0.69908 0.0 5 3.00 Err:502 0.4771 0.69909 0.0 5 2.67 Err:502 0.4260 0.699010 0.0 5 2.40 Err:502 0.3802 0.699011 0.0 5 2.18 Err:502 0.3388 0.6990

12 0.0 5 2.00 Err:502 0.3010 0.6990

13 0.0 5 1.85 Err:502 0.2663 0.699014 0.0 5 1.71 Err:502 0.2341 0.699015 0.0 5 1.60 Err:502 0.2041 0.699016 0.0 5 1.50 Err:502 0.1761 0.699017 0.0 5 1.41 Err:502 0.1498 0.699018 0.0 5 1.33 Err:502 0.1249 0.699019 0.0 5 1.26 Err:502 0.1015 0.699020 0.0 5 1.20 Err:502 0.0792 0.699021 0.0 5 1.14 Err:502 0.0580 0.699022 0.0 5 1.09 Err:502 0.0378 0.6990

23 0.0 5 1.04 Err:502 0.0185 0.69901 153.0 10 24.00 2.1847 1.3802 1.00002 150.0 10 12.00 2.1761 1.0792 1.00003 134.4 10 8.00 2.1284 0.9031 1.00004 132.0 10 6.00 2.1206 0.7782 1.00005 123.6 10 4.80 2.0920 0.6812 1.00006 120.0 10 4.00 2.0792 0.6021 1.00007 120.0 10 3.43 2.0792 0.5351 1.00008 120.0 10 3.00 2.0792 0.4771 1.00009 114.6 10 2.67 2.0592 0.4260 1.000010 108.0 10 2.40 2.0334 0.3802 1.000011 104.4 10 2.18 2.0187 0.3388 1.000012 102.6 10 2.00 2.0111 0.3010 1.000013 102.0 10 1.85 2.0086 0.2663 1.0000

14 102.0 10 1.71 2.0086 0.2341 1.000015 94.8 10 1.60 1.9768 0.2041 1.000016 90.0 10 1.50 1.9542 0.1761 1.000017 83.4 10 1.41 1.9212 0.1498 1.000018 81.0 10 1.33 1.9085 0.1249 1.000019 72.0 10 1.26 1.8573 0.1015 1.000020 70.8 10 1.20 1.8500 0.0792 1.000021 70.2 10 1.14 1.8463 0.0580 1.000022 63.0 10 1.09 1.7993 0.0378 1.0000

23 60 10 1.04 1.7782 0.0185 1.00001 141.6 15 24.00 2.1511 1.3802 1.17612 116.0 15 12.00 2.0645 1.0792 1.17613 114.0 15 8.00 2.0569 0.9031 1.17614 108.0 15 6.00 2.0334 0.7782 1.17615 108.0 15 4.80 2.0334 0.6812 1.17616 106.4 15 4.00 2.0269 0.6021 1.17617 96.8 15 3.43 1.9859 0.5351 1.17618 90.0 15 3.00 1.9542 0.4771 1.17619 90.0 15 2.67 1.9542 0.4260 1.176110 88.8 15 2.40 1.9484 0.3802 1.176111 88.4 15 2.18 1.9465 0.3388 1.176112 84.4 15 2.00 1.9263 0.3010 1.176113 82.0 15 1.85 1.9138 0.2663 1.1761

14 80.4 15 1.71 1.9053 0.2341 1.176115 80.0 15 1.60 1.9031 0.2041 1.176116 78.0 15 1.50 1.8921 0.1761 1.176117 72.0 15 1.41 1.8573 0.1498 1.176118 69.6 15 1.33 1.8426 0.1249 1.176119 67.2 15 1.26 1.8274 0.1015 1.176120 65.6 15 1.20 1.8169 0.0792 1.176121 63.2 15 1.14 1.8007 0.0580 1.176122 56.0 15 1.09 1.7482 0.0378 1.1761

23 43.6 15 1.04 1.6395 0.0185 1.17611 132.6 20 24.00 2.1225 1.3802 1.30102 112.0 20 12.00 2.0492 1.0792 1.30103 102.0 20 8.00 2.0086 0.9031 1.30104 99.0 20 6.00 1.9956 0.7782 1.30105 87.0 20 4.80 1.9395 0.6812 1.30106 84.9 20 4.00 1.9289 0.6021 1.30107 83.1 20 3.43 1.9196 0.5351 1.30108 82.5 20 3.00 1.9165 0.4771 1.30109 82.5 20 2.67 1.9165 0.4260 1.301010 79.8 20 2.40 1.9020 0.3802 1.301011 75.0 20 2.18 1.8751 0.3388 1.301012 74.4 20 2.00 1.8716 0.3010 1.301013 72.6 20 1.85 1.8609 0.2663 1.301014 71.7 20 1.71 1.8555 0.2341 1.301015 66.0 20 1.60 1.8195 0.2041 1.301016 64.8 20 1.50 1.8116 0.1761 1.301017 64.5 20 1.41 1.8096 0.1498 1.301018 60.0 20 1.33 1.7782 0.1249 1.301019 58.5 20 1.26 1.7672 0.1015 1.301020 57.0 20 1.20 1.7559 0.0792 1.301021 54.3 20 1.14 1.7348 0.0580 1.301022 49.5 20 1.09 1.6946 0.0378 1.3010

23 32.7 20 1.04 1.5145 0.0185 1.30101 101.0 30 24.00 2.0043 1.3802 1.47712 88.0 30 12.00 1.9445 1.0792 1.47713 85.0 30 8.00 1.9294 0.9031 1.47714 74.0 30 6.00 1.8692 0.7782 1.47715 72.6 30 4.80 1.8609 0.6812 1.47716 72.0 30 4.00 1.8573 0.6021 1.47717 71.0 30 3.43 1.8513 0.5351 1.47718 70.0 30 3.00 1.8451 0.4771 1.47719 66.8 30 2.67 1.8248 0.4260 1.477110 63.0 30 2.40 1.7993 0.3802 1.477111 62.8 30 2.18 1.7980 0.3388 1.477112 62.4 30 2.00 1.7952 0.3010 1.477113 62.0 30 1.85 1.7924 0.2663 1.477114 54.8 30 1.71 1.7388 0.2341 1.4771

15 51.8 30 1.60 1.7143 0.2041 1.477116 50.2 30 1.50 1.7007 0.1761 1.477117 49.0 30 1.41 1.6902 0.1498 1.477118 48.2 30 1.33 1.6830 0.1249 1.477119 48.0 30 1.26 1.6812 0.1015 1.477120 42.0 30 1.20 1.6232 0.0792 1.477121 41.0 30 1.14 1.6128 0.0580 1.477122 39.2 30 1.09 1.5933 0.0378 1.4771

23 34 30 1.04 1.5315 0.0185 1.47711 87.8 40 24.00 1.9435 1.3802 1.60212 73.2 40 12.00 1.8645 1.0792 1.60213 72.4 40 8.00 1.8597 0.9031 1.60214 68.5 40 6.00 1.8357 0.7782 1.60215 67.2 40 4.80 1.8274 0.6812 1.60216 65.3 40 4.00 1.8149 0.6021 1.60217 63.8 40 3.43 1.8048 0.5351 1.60218 62.3 40 3.00 1.7945 0.4771 1.60219 52.4 40 2.67 1.7193 0.4260 1.602110 47.3 40 2.40 1.6749 0.3802 1.602111 47.2 40 2.18 1.6739 0.3388 1.602112 46.7 40 2.00 1.6693 0.3010 1.602113 46.6 40 1.85 1.6684 0.2663 1.602114 44.0 40 1.71 1.6435 0.2341 1.602115 39.0 40 1.60 1.5911 0.2041 1.602116 37.6 40 1.50 1.5752 0.1761 1.602117 37.5 40 1.41 1.5740 0.1498 1.602118 36.7 40 1.33 1.5647 0.1249 1.602119 34.5 40 1.26 1.5378 0.1015 1.602120 34.3 40 1.20 1.5353 0.0792 1.602121 33.8 40 1.14 1.5289 0.0580 1.602122 29.4 40 1.09 1.4683 0.0378 1.6021

23 27.6 40 1.04 1.4409 0.0185 1.60211 71.3 60 24.00 1.8531 1.3802 1.77822 63.0 60 12.00 1.7993 1.0792 1.77823 61.0 60 8.00 1.7853 0.9031 1.77824 50.5 60 6.00 1.7033 0.7782 1.77825 58.4 60 4.80 1.7664 0.6812 1.77826 57.8 60 4.00 1.7619 0.6021 1.77827 53.3 60 3.43 1.7267 0.5351 1.77828 47.3 60 3.00 1.6749 0.4771 1.77829 43.5 60 2.67 1.6385 0.4260 1.778210 41.5 60 2.40 1.6180 0.3802 1.778211 40.9 60 2.18 1.6117 0.3388 1.778212 39.2 60 2.00 1.5933 0.3010 1.778213 39.0 60 1.85 1.5911 0.2663 1.778214 36.5 60 1.71 1.5623 0.2341 1.778215 30.4 60 1.60 1.4829 0.2041 1.7782

16 29.8 60 1.50 1.4742 0.1761 1.778217 28.6 60 1.41 1.4564 0.1498 1.778218 28.6 60 1.33 1.4564 0.1249 1.778219 27.8 60 1.26 1.4440 0.1015 1.778220 26.2 60 1.20 1.4183 0.0792 1.778221 24.3 60 1.14 1.3856 0.0580 1.778222 22.5 60 1.09 1.3522 0.0378 1.7782

23 19.6 60 1.04 1.2923 0.0185 1.77821 54.8 80 24.00 1.7388 1.3802 1.90312 54.4 80 12.00 1.7356 1.0792 1.90313 50.6 80 8.00 1.7042 0.9031 1.90314 48.8 80 6.00 1.6884 0.7782 1.90315 47.6 80 4.80 1.6776 0.6812 1.90316 43.7 80 4.00 1.6405 0.6021 1.90317 40.7 80 3.43 1.6096 0.5351 1.90318 38.3 80 3.00 1.5832 0.4771 1.90319 35.5 80 2.67 1.5502 0.4260 1.903110 35.2 80 2.40 1.5465 0.3802 1.903111 32.5 80 2.18 1.5119 0.3388 1.903112 31.2 80 2.00 1.4942 0.3010 1.903113 30.9 80 1.85 1.4900 0.2663 1.903114 30.7 80 1.71 1.4871 0.2341 1.903115 25.5 80 1.60 1.4065 0.2041 1.903116 24.2 80 1.50 1.3838 0.1761 1.903117 22.8 80 1.41 1.3579 0.1498 1.903118 22.7 80 1.33 1.3560 0.1249 1.903119 22.4 80 1.26 1.3502 0.1015 1.903120 21.6 80 1.20 1.3345 0.0792 1.903121 21.4 80 1.14 1.3304 0.0580 1.903122 16.9 80 1.09 1.2279 0.0378 1.9031

23 14.7 80 1.04 1.1673 0.0185 1.90311 51.2 100 24.00 1.7093 1.3802 2.00002 49.7 100 12.00 1.6964 1.0792 2.00003 42.4 100 8.00 1.6274 0.9031 2.00004 40.6 100 6.00 1.6085 0.7782 2.00005 38.6 100 4.80 1.5866 0.6812 2.00006 36.3 100 4.00 1.5599 0.6021 2.00007 32.8 100 3.43 1.5159 0.5351 2.00008 32.6 100 3.00 1.5132 0.4771 2.00009 28.8 100 2.67 1.4594 0.4260 2.000010 28.4 100 2.40 1.4533 0.3802 2.000011 28.1 100 2.18 1.4487 0.3388 2.000012 27.0 100 2.00 1.4314 0.3010 2.000013 25.4 100 1.85 1.4048 0.2663 2.000014 24.2 100 1.71 1.3838 0.2341 2.000015 22.7 100 1.60 1.3560 0.2041 2.000016 22.7 100 1.50 1.3560 0.1761 2.0000

17 20.2 100 1.41 1.3054 0.1498 2.000018 20.0 100 1.33 1.3010 0.1249 2.000019 18.5 100 1.26 1.2672 0.1015 2.000020 18.3 100 1.20 1.2625 0.0792 2.000021 17.6 100 1.14 1.2455 0.0580 2.000022 13.5 100 1.09 1.1303 0.0378 2.0000

23 11.8 100 1.04 1.0719 0.0185 2.00001 50.0 120 24.00 1.6990 1.3802 2.07922 41.5 120 12.00 1.6180 1.0792 2.07923 35.7 120 8.00 1.5527 0.9031 2.07924 34.5 120 6.00 1.5378 0.7782 2.07925 33.8 120 4.80 1.5289 0.6812 2.07926 30.3 120 4.00 1.4814 0.6021 2.07927 28.2 120 3.43 1.4502 0.5351 2.07928 27.2 120 3.00 1.4346 0.4771 2.07929 27.0 120 2.67 1.4314 0.4260 2.079210 25.5 120 2.40 1.4065 0.3802 2.079211 25.0 120 2.18 1.3979 0.3388 2.079212 23.7 120 2.00 1.3747 0.3010 2.079213 21.3 120 1.85 1.3284 0.2663 2.079214 20.5 120 1.71 1.3118 0.2341 2.079215 19.8 120 1.60 1.2967 0.2041 2.079216 18.9 120 1.50 1.2765 0.1761 2.079217 18.0 120 1.41 1.2553 0.1498 2.079218 17.3 120 1.33 1.2380 0.1249 2.079219 15.9 120 1.26 1.2014 0.1015 2.079220 15.6 120 1.20 1.1931 0.0792 2.079221 15.2 120 1.14 1.1818 0.0580 2.079222 11.3 120 1.09 1.0531 0.0378 2.0792

23 9.8 120 1.04 0.9912 0.0185 2.0792

CURVAS INTENSIDAD - DURACION - PERIODO DE RETORNO

Intensidades máximas registradas en la estación climatológica

120

BETA 2 BETA 1 ALFA

Err:502 Err:502 Err:502

k Err:502 Err:502

m 0.355

n 0.558 0.442

𝑖=(260.149〖〗𝑇𝑟 ^0.355)/𝑑^0.558

Tr d10 5 Err:502 Err:502 Err:502 Err:502 Err:50250 10 Err:502 Err:502 Err:502 Err:502 Err:50275 15 Err:502 Err:502 Err:502 Err:502 Err:502100 20 Err:502 Err:502 Err:502 Err:502 Err:502

25 Err:502 Err:502 Err:502 Err:502 Err:502




















i10 i50 i75 i100 hp10

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

Err:502 Err:502 Err:502

hp75 hp51 hp100

0 20 40 60 80 100 120 1400

100

200

300

400

500

600

Curvas intensidad - duracion - periodo de retornoTr = 10 años Tr = 50 años Tr = 75 años Tr = 100 años

0 20 40 60 80 100 120 1400

20

40

60

80

100

120

140

160

180

200

Curvas precipitacion - duracion - periodo de retorno

0Ix+(1-x)O

FECHA I(m3/s) O(m3/s) V(m3/s*dia0 x=0.01 0 02 0 03 0 04 0 05 0 06 0 07 0 08 0 09 0 0

10 0 011 0 012 0 013 0 014 0 015 0 016 0 017 0 018 0 019 0 020 0 021 0 022 0 0

0

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

0

i

t (dias) I (m3/s) C1Ii C2Ii+1 C3Oi Oi+10 - - - 01 0.00 0.00 0.00 0.002 0.00 0.00 0.00 0.003 0.00 0.00 0.00 0.004 0.00 0.00 0.00 0.005 0.00 0.00 0.00 0.006 0.00 0.00 0.00 0.007 0.00 0.00 0.00 0.008 0.00 0.00 0.00 0.009 0.00 0.00 0.00 0.00

10 0.00 0.00 0.00 0.0011 0.00 0.00 0.00 0.0012 0.00 0.00 0.00 0.0013 0.00 0.00 0.00 0.0014 0.00 0.00 0.00 0.0015 0.00 0.00 0.00 0.0016 0.00 0.00 0.00 0.0017 0.00 0.00 0.00 0.0018 0.00 0.00 0.00 0.0019 0.00 0.00 0.00 0.0020 0.00 0.00 0.00 0.0021 0.00 0.00 0.00 0.0022 0.00 0.00 0.00 0.0023 0.00 0.00 0.00 0.0024 0.00 0.00 0.00 0.00

C1 0.7702C2 -0.1491C3 0.6211 0.37888199

0.1 0.2 0.3 0.4 0.5Ix+(1-x)O

x=0.1 x=0.2 x=0.3 x=0.4 x=0.50 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 0 30-Dec-99 1-Jan-00 3-Jan-00 5-Jan-00 7-Jan-00 9-Jan-00 11-Jan-00

0

2

4

6

8

10

12

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

0.1

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

0.2

0 5 10 15 20 25 300

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

HIDROGRAMA

HIDROGRAMA DE ENTRADAHIDROGRAMA DE SALIDA

DIAS

I (m

3/s)

- O

(m3/

s)

30-Dec-99 1-Jan-00 3-Jan-00 5-Jan-00 7-Jan-00 9-Jan-00 11-Jan-000

2

4

6

8

10

12

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

0.2

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

0.3

0 5 10 15 20 25 300

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

HIDROGRAMA


DIAS

I (m

3/s)

- O

(m3/

s)

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

0.3

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

f(x) = NaN x + NaN

0.4

K 1.85

X 0.4

0 5 10 15 20 25 300

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

HIDROGRAMA


DIAS

I (m

3/s)

- O

(m3/

s)

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

f(x) = NaN x + NaN

0.4

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

f(x) = NaN x + NaN0.5

dias K 1.83

X 0.5

0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 10

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

f(x) = NaN x + NaN0.5

hojas de excel

Documents