Tablas de Hidrologia
sharo96Trabajo7 de Enero de 2016
1.125 Palabras (5 Páginas)354 Visitas
Duraciones | |||||
Año | 5 | 10 | 20 | 60 | 120 |
1970 | 5 | 25 | 35 | 40 | 45 |
1971 | 10 | 12 | 20 | 25 | 27 |
1972 | 8 | 17 | 24 | 32 | 39 |
1973 | 3 | 9 | 15 | 24 | 35 |
1974 | 11 | 21 | 34 | 47 | 59 |
1975 | 10 | 13 | 19 | 25 | 28 |
1976 | 15 | 17 | 29 | 35 | 37 |
1977 | 6 | 9 | 19 | 23 | 26 |
1978 | 7 | 11 | 13 | 19 | 22 |
1979 | 13 | 16 | 21 | 25 | 27 |
1980 | 17 | 20 | 23 | 28 | 32 |
1981 | 15 | 19 | 21 | 35 | 38 |
Intensidades | |||||
Año | 5 | 10 | 20 | 60 | 120 |
1970 | = 5*60/5 \# "0" \* MERGEFORMAT60 | 150 | = 60*35/20 \# "0" \* MERGEFORMAT105 | 40 | = 45*60/120 \# "0" \* MERGEFORMAT22.5 |
1971 | = 600/5 \# "0" \* MERGEFORMAT120 | 72 | = 60*20/20 \# "0" \* MERGEFORMAT60 | 25 | = 27*60/120 \# "0" \* MERGEFORMAT13.5 |
1972 | = 60*8/5 \# "0" \* MERGEFORMAT96 | 102 | = 24*60/20 \# "0" \* MERGEFORMAT72 | 32 | = 39*60/120 \# "0" \* MERGEFORMAT19.5 |
1973 | = 60*3/5 \# "0" \* MERGEFORMAT36 | 54 | 45 | 24 | 17.5 |
1974 | = 60*11/5 \# "0" \* MERGEFORMAT132 | 126 | 102 | 47 | = 59*60/120 \# "0" \* MERGEFORMAT29.5 |
1975 | 120 | 78 | 57 | 25 | = 28*60/120 \# "0" \* MERGEFORMAT14 |
1976 | 180 | 102 | 87 | 35 | = 37*60/120 \# "0" \* MERGEFORMAT18.5 |
1977 | 72 | 54 | 57 | 23 | = 26*60/120 \# "0" \* MERGEFORMAT13 |
1978 | 84 | 66 | 39 | 19 | 11 |
1979 | 156 | 96 | 63 | 25 | 13.5 |
1980 | 204 | 120 | 69 | 28 | 16 |
1981 | 180 | 114 | 63 | 35 | 19 |
Intensidades mm/hr | ||||||
Orden | T | 5 | 10 | 20 | 60 | 120 |
1.00 | 13.00 | 204 | 150 | = 60*35/20 \# "0" \* MERGEFORMAT105 | 47 | = 59*60/120 \# "0" \* MERGEFORMAT29.5 |
2.00 | 6.50 | 180 | 126 | 102 | 40 | = 45*60/120 \# "0" \* MERGEFORMAT22.5 |
3.00 | 4.33 | 180 | 120 | 87 | 35 | = 39*60/120 \# "0" \* MERGEFORMAT19.5 |
4.00 | 3.25 | 156 | 114 | = 24*60/20 \# "0" \* MERGEFORMAT72 | 35 | 19 |
5.00 | 2.60 | = 60*11/5 \# "0" \* MERGEFORMAT132 | 102 | 69 | 32 | = 37*60/120 \# "0" \* MERGEFORMAT18.5 |
6.00 | 2.17 | = 600/5 \# "0" \* MERGEFORMAT120 | 102 | 63 | 28 | 17.5 |
7.00 | 1.86 | 120 | 96 | 63 | 25 | 16 |
8.00 | 1.63 | = 60*8/5 \# "0" \* MERGEFORMAT96 | 78 | = 60*20/20 \# "0" \* MERGEFORMAT60 | 25 | = 28*60/120 \# "0" \* MERGEFORMAT14 |
9.00 | 1.44 | 84 | 72 | 57 | 25 | 13.5 |
10.00 | 1.30 | 72 | 66 | 57 | 24 | = 27*60/120 \# "0" \* MERGEFORMAT13.5 |
11.00 | 1.18 | = 5*60/5 \# "0" \* MERGEFORMAT60 | 54 | 45 | 23 | = 26*60/120 \# "0" \* MERGEFORMAT13 |
12.00 | 1.08 | = 60*3/5 \# "0" \* MERGEFORMAT36 | 54 | 39 | 19 | 11 |
RESULTADOS:
Sumatorias
Y= 103.0287
X1= 23.4299
X2= 82.2880
X1^2= 14.0
Ecuaciones | ||||||||
Y | X1 | X2 | X1^2 | X2^2 | X1X2 | X1y | X2y | |
2.3096 | 1.1139 | 0.6990 | 1.2409 | 0.4886 | 0.7786 | = B2*A2 \# "0.0000" \* MERGEFORMAT2.5728 | = A2*C2 \# "0.0000" \* MERGEFORMAT1.6144 | |
2.2553 | 0.8129 | 0.6990 | 0.6608 | 0.4886 | 0.5682 | = A3*B3 \# "0.0000" \* MERGEFORMAT1.8333 | = A3*C3 \# "0.0000" \* MERGEFORMAT1.5764 | 2 |
2.2553 | 0.6365 | 0.6990 | 0.4051 | 0.4886 | 0.4449 | = A4*B4 \# "0.0000" \* MERGEFORMAT1.4355 | = A4*C4 \# "0.0000" \* MERGEFORMAT1.5764 | |
2.1931 | 0.5119 | 0.6990 | 0.2620 | 0.4886 | 0.3578 | = A5*B5 \# "0.0000" \* MERGEFORMAT1.1226 | = A5*C5 \# "0.0000" \* MERGEFORMAT1.5329 | |
2.1206 | 0.4150 | 0.6990 | 0.1722 | 0.4886 | 0.2901 | = A6*B6 \# "0.0000" \* MERGEFORMAT0.8800 | = A6*C6 \# "0.0000" \* MERGEFORMAT1.4822 | |
2.0792 | 0.3365 | 0.6990 | 0.1132 | 0.4886 | 0.2352 | = A7*B7 \# "0.0000" \* MERGEFORMAT0.6996 | = A7*C7 \# "0.0000" \* MERGEFORMAT1.4533 | |
2.0792 | 0.2695 | 0.6990 | 0.0726 | 0.4886 | 0.1884 | = A8*B8 \# "0.0000" \* MERGEFORMAT0.5604 | = A8*C8 \# "0.0000" \* MERGEFORMAT1.4533 | |
1.9823 | 0.2122 | 0.6990 | 0.0450 | 0.4886 | 0.1483 | = A9*B9 \# "0.0000" \* MERGEFORMAT0.4206 | = A9*C9 \# "0.0000" \* MERGEFORMAT1.3855 | |
1.9243 | 0.1584 | 0.6990 | 0.0251 | 0.4886 | 0.1107 | = A10*B10 \# "0.0000" \* MERGEFORMAT0.3047 | = A10*C10 \# "0.0000" \* MERGEFORMAT1.3450 | |
1.8573 | 0.1139 | 0.6990 | 0.0130 | 0.4886 | 0.0796 | = A11*B11 \# "0.0000" \* MERGEFORMAT0.2116 | = A11*C11 \# "0.0000" \* MERGEFORMAT1.2982 | |
1.7782 | 0.0719 | 0.6990 | 0.0052 | 0.4886 | 0.0502 | = A12*B12 \# "0.0000" \* MERGEFORMAT0.1278 | = A12*C12 \# "0.0000" \* MERGEFORMAT1.2429 | |
1.5563 | 0.0334 | 0.6990 | 0.0011 | 0.4886 | 0.0234 | = A13*B13 \# "0.0000" \* MERGEFORMAT0.0520 | = A13*C13 \# "0.0000" \* MERGEFORMAT1.0878 |
...