Embed Size (px)
DESCRIPTION
EXCEL_TP4
Citation preview
Muestra Concent, tiempo[Nº] [g/l]
1 0 152 0 303 0.003 454 0.011 605 0.019 756 0.032 907 0.043 1058 0.05 1209 0.054 135
10 0.056 15011 0.058 16512 0.059 18013 0.06 19514 0.061 21015 0.06 22516 0.061 24017 0.06 25518 0.06 27019 0.06 28520 0.06 300
0 50 100 150 200 250 300 3500
0.01
0.02
0.03
0.04
0.05
0.06
0.07
Concentracion - Tiempo
Tiempo en seg
0 50 100 150 200 250 300 3500
0.01
0.02
0.03
0.04
0.05
0.06
0.07
Concentracion - Tiempo
Tiempo en seg
Muestra Concent, masa (mg)= 420000[Nº] [mg/l] tiempo (s)= 101.00 3.00
2.00 3.00 Caudal aforado (l/s)= 38.46153846153853.00 4.00
4.00 4.00 Concentración global(mg/l)= 1092.005.00 4.00
6.00 5.00
7.00 8.00 Tiempo (s) Concentracion (mg/l)8.00 32.00 10 3.00
9.00 95.00 20 3.00
10.00 194.00 30 4.00
11.00 347.00 40 4.00
12.00 196.00 50 4.00
13.00 87.00 60 5.00
14.00 51.00 70 8.00
15.00 32.00 80 32.00
16.00 11.00 90 95.00
17.00 5.00 100 194.00
18.00 4.00 110 347.00
19.00 4.00 120 196.00
20.00 3.00 130 87.00
Total 1092.00 140 51.00
150 32.00
160 11.00
170 5.00
180 4.00
190 4.00
200 3.00
10 20 30 40 50 60 70 80 90 1001101201301401501601701801902000.00
50.00
100.00
150.00
200.00
250.00
300.00
350.00
400.00
Concentración - Tiempo
Tiempo
Conc
entr
ació
n
Año Eb Ec A acumulado Prom A,B y C correccion
Hidrológico
1 133 146.3 166.25 133 148.5166667 148.5166667 133
2 34 37.4 42.5 167 37.96666667 186.4833333 34
3 56 61.6 70 223 62.53333333 249.0166667 56
4 95 104.5 118.75 318 106.0833333 355.1 95
5 114 125.4 142.5 432 127.3 482.4 114
6 107 117.7 133.75 539 119.4833333 601.8833333 107
7 40 44 50 579 44.66666667 646.55 40
8 25 27.5 31.25 604 27.91666667 674.4666667 25
9 74 81.4 92.5 678 82.63333333 757.1 74
10 90 101.2 115 768 102.0666667 859.1666667 90
11 96 102.3 116.25 864 104.85 964.0166667 96
12 55 46.2 52.5 919 51.23333333 1015.25 47.01153659
13 80 75.9 86.25 999 80.71666667 1095.966667 68.38041685
14 40 31.9 36.25 1039 36.05 1132.016667 34.19020843
15 60 55 62.5 1099 59.16666667 1191.183333 51.28531264
16 35 31.9 36.25 1134 34.38333333 1225.566667 29.91643237
17 25 19.8 22.5 1159 22.43333333 1248 21.36888027
18 12 7.7 8.75 1171 9.483333333 1257.483333 10.25706253
19 28 23.1 26.25 1199 25.78333333 1283.266667 23.9331459
20 30.8 25.4 28.85 1229.8 28.35 1311.616667 26.32646049
m1 m2pendientes 0.89638259 1.04870093
Ea Promedio acumulado
A acumolado C(Prom A,B y C) corregido Promedio acumulado corregido
133 148.516667 148.516667167 37.9666667 186.483333223 62.5333333 249.016667318 106.083333 355.1432 127.3 482.4539 119.483333 601.883333579 44.6666667 646.55604 27.9166667 674.466667678 82.6333333 757.1768 102.066667 859.166667864 104.85 964.016667
911.01153659 48.5705122 1012.58718979.39195344 76.8434723 1089.430651013.5821619 34.1134028 1123.544051064.8674745 56.2617709 1179.805821094.7839069 32.6888108 1212.494641116.1527871 21.2229601 1233.71761126.4098497 8.90235418 1242.619951150.3429956 24.4277153 1267.047671176.6694561 26.8588202 1293.90649
0 200 400 600 800 1000 1200 14000
200
400
600
800
1000
1200
1400
error A correccion
Q Promedio acumulado corregido
Q A
acu
mul
ado
0 200 400 600 800 1000 1200 14000
200
400
600
800
1000
1200
1400
error A correccion
Q Promedio acumulado corregido
Q A
acu
mul
ado
Suncho Corral AÑO/MES septiembre octubre noviembre diciembre enero febrero marzo29-30 1.6 0.5 0.4 1 0.6 16.8 41.630-31 0.9 0.4 0.6 0.9 1.4 35.6 77.231-32 0.5 0.4 0.4 0.3 16.7 74.6 95.132-33 0.6 0.5 0.5 0.4 2.3 12.8 91.3933-34 1.3 0.5 0.4 0.3 0.2 0.8 7.234-35 0.4 0.3 0.25 0.4 0.8 4 14.335-36 0.5 0.4 0.3 0.2 0.1 4 20.436-37 0.4 0.35 0.3 0.25 0.2 19.2 25.837-38 0.7 0.6 0.5 0.7 0.9 2.4 22.638-39 0.6 0.5 0.5 0.8 1.2 1.6 50.239-40 0.6 0.7 0.8 1 1.2 1.4 2.140-41 0.8 0.9 1 1.2 1.3 3.6 12.2Promedios 0.742 0.504 0.496 0.621 2.242 14.733 38.341
Colonia Dora septiembre octubre noviembre diciembre enero febrero marzo
29-30 1.4 0.35 0.25 0.6 1.15 13.5 3530-31 0.6 0.2 0.3 0.55 1 28 6331-32 0.33 0.25 0.23 0.15 12 60 117.3932-33 0.93 0.80 0.80 0.68 3.02 15.96 112.8233-34 1.79 0.80 0.68 0.56 0.43 1.17 9.0634-35 0.3 0.2 0.15 0.2 0.6 3 1135-36 0.3 0.2 0.15 0.1 0.05 2 1436-37 0.25 0.2 0.15 0.12 0.1 15 2137-38 0.35 0.3 0.22 0.4 0.5 1.8 1838-39 0.3 0.26 0.25 0.42 0.7 0.9 4039-40 0.3 0.4 0.5 0.7 0.9 1.1 1.640-41 0.4 0.5 0.6 0.8 0.9 2.8 10promedios 0.604 0.372 0.357 0.440 1.780 12.103 37.739
CD SC1.6 1.40.9 0.60.5 0.330.4 0.30.5 0.30.4 0.250.7 0.350.6 0.30.6 0.30.8 0.40.5 0.350.4 0.20.4 0.250.3 0.20.4 0.2
0 10 20 30 40 50 60 700
10
20
30
40
50
60
70
80
90
f(x) = 1.23236821561342 x + 0.186863130942847
Comparacion
Q Suncho Corral
Q C
olon
ia D
ora
0.35 0.20.6 0.30.5 0.260.7 0.40.9 0.50.4 0.250.6 0.3 ecuacion0.4 0.23
0.25 0.150.3 0.150.3 0.150.5 0.220.5 0.250.8 0.5
1 0.61 0.6
0.9 0.550.3 0.150.4 0.20.2 0.1
0.25 0.120.7 0.40.8 0.42
1 0.71.2 0.80.6 1.151.4 1
16.7 120.8 0.60.1 0.050.2 0.10.9 0.51.2 0.71.2 0.91.3 0.9
16.8 13.535.6 2874.6 60
4 34 2
19.2 152.4 1.81.6 0.91.4 1.13.6 2.8
41.6 3577.2 6314.3 11
0 10 20 30 40 50 60 700
10
20
30
40
50
60
70
80
90
f(x) = 1.23236821561342 x + 0.186863130942847
Comparacion
Q Suncho Corral
Q C
olon
ia D
ora
20.4 1425.8 2122.6 1850.2 40
2.1 1.612.2 1033.8 3040.3 33.416.6 14
6.6 57.2 5.5
14.2 1146.9 35
7.2 611.1 1026.6 22
13 117.5 61.5 1.24.8 3.53.8 2.8
11.2 95.2 4.54.7 4
11.5 9.38.8 78.8 70.9 0.81.7 1.20.5 0.34.2 3.20.3 0.20.4 0.35.9 4.25.1 44.2 30.4 0.3
0.61 0.40.8 0.450.5 0.30.4 0.20.6 0.44.9 3.52.2 1.51.7 1.20.4 0.250.8 0.450.7 0.35
0.5 0.250.6 0.30.5 0.25
Suncho Corral abril mayo junio julio agosto SUMAS
33.8 26.6 11.5 5.9 4.9 145.240.3 13 8.8 5.1 2.2 186.4
83 30.4 15.5 8.3 3.4 328.687.4 48.4 18.6 10.2 4.4 277.49
8.5 7.3 7.6 3.8 2.4 40.316.6 7.5 8.8 4.2 1.7 59.25
6.6 1.5 0.9 0.4 0.4 35.77.2 4.8 1.7 0.61 0.8 61.61
14.2 3.8 0.5 0.8 0.7 48.446.9 11.2 4.2 0.5 0.5 118.7
7.2 5.2 0.3 0.4 0.6 21.5 AÑO MAS SECO11.1 4.7 0.4 0.6 0.5 38.3
30.233 13.700 6.567 3.401 1.875 CAUDAL MODULO
Colonia Dora abril mayo junio julio agosto SUMAS
30 22 9.3 4.2 3.5 121.2533.4 11 7 4 1.5 150.55
102.48 37.65 19.29 10.42 4.38 364.55808107.90 59.84 23.11 12.76 5.61 344.221476
10.66 9.18 9.55 4.87 3.14 51.9085214 6 7 3 1.2 46.65
5 1.2 0.8 0.3 0.25 24.355.5 3.5 1.2 0.4 0.45 47.8711 2.8 0.3 0.45 0.35 36.4735 9 3.2 0.3 0.25 90.58
6 4.5 0.2 0.2 0.3 16.7 AÑO MAS SECO10 4 0.3 0.4 0.25 30.95
30.911 14.223 6.771 3.441 1.765 CAUDAL MODULO
0 10 20 30 40 50 60 700
10
20
30
40
50
60
70
80
90
f(x) = 1.23236821561342 x + 0.186863130942847
Comparacion
Q Suncho Corral
Q C
olon
ia D
ora
0 2 4 6 8 10 12 140.000
5.000
10.000
15.000
20.000
25.000
30.000
35.000
40.000
Hidrograma Colonia Dora
meses
caud
ales
med
ios
0 10 20 30 40 50 60 700
10
20
30
40
50
60
70
80
90
f(x) = 1.23236821561342 x + 0.186863130942847
Comparacion
Q Suncho Corral
Q C
olon
ia D
ora
0 2 4 6 8 10 12 140.000
5.000
10.000
15.000
20.000
25.000
30.000
35.000
40.000
45.000
Hidrograma Suncho Corral
meses
caud
ales
med
ios
0 2 4 6 8 10 12 140.000
5.000
10.000
15.000
20.000
25.000
30.000
35.000
40.000
Hidrograma Colonia Dora
meses
caud
ales
med
ios
19.523.25
2734.1
3950.75
144.15186
85.2510.515.521.7
1.79917808219178
10.513.95
1824.8
3039.15117.8157.572.85
67.75
10.851.39493150684932
[(Qi+Qi+1)/2]Δti
[(Qi+Qi+1)/2]Δti
0 2 4 6 8 10 12 140.000
5.000
10.000
15.000
20.000
25.000
30.000
35.000
40.000
Hidrograma Colonia Dora
meses
caud
ales
med
ios
0 2 4 6 8 10 12 140.000
5.000
10.000
15.000
20.000
25.000
30.000
35.000
40.000
45.000
Hidrograma Suncho Corral
meses
caud
ales
med
ios
0 2 4 6 8 10 12 140.000
5.000
10.000
15.000
20.000
25.000
30.000
35.000
40.000
Hidrograma Colonia Dora
meses
caud
ales
med
ios
mes /año caudales
m3/s m/n+1
1 F 578.34 0.027027032 E 394.74 0.054054053 M 327.726 0.081081084 M 307.53 0.108108115 A 275.4 0.135135146 A 261.63 0.162162167 F 215.73 0.189189198 F 182.682 0.216216229 M 175.338 0.24324324
10 M 160.65 0.2702702711 E 153.306 0.297297312 D 128.52 0.3243243213 M 111.996 0.3513513514 D 100.98 0.3783783815 J 98.226 0.4054054116 E 93.636 0.4324324317 D 72.706 0.4594594618 A 67.748 0.4864864919 N 65.545 0.5135135120 N 52.24 0.5405405421 J 47.736 0.5675675722 J 46.181 0.5945945923 O 44.615 0.6216216224 N 42.876 0.6486486525 O 38.189 0.67567568 Qaguapotable (m3/s)=26 S.89 32.594 0.7027027 Qenergiaelectrica (m3/s)=27 O 31.126 0.72972973 Qagricola (m3/s)=28 A 30.942 0.7567567629 S.88 30.758 0.7837837830 M 27.724 0.8108108131 J 24.786 0.8378378432 A 21.395 0.8648648633 A 20.563 0.8918918934 S.87 18.727 0.9189189235 J 14.602 0.9459459536 J 14.321 0.97297297
0.027027027027027
0.0810810810810811
0.135135135135135
0.189189189189189
0.243243243243243
0.297297297297297
0.351351351351351
0.405405405405405
0.45945945945946
0.513513513513514
0.567567567567568
0.621621621621622
0.675675675675676
0.72972972972973
0.783783783783784
0.837837837837838
0.891891891891892
0.9459459459459460
100
200
300
400
500
600
700
Curva de caudales clasificados
Probabilidad
Caud
al
14.64532.59468.85
0.027027027027027
0.0810810810810811
0.135135135135135
0.189189189189189
0.243243243243243
0.297297297297297
0.351351351351351
0.405405405405405
0.45945945945946
0.513513513513514
0.567567567567568
0.621621621621622
0.675675675675676
0.72972972972973
0.783783783783784
0.837837837837838
0.891891891891892
0.9459459459459460
100
200
300
400
500
600
700
Curva de caudales clasificados
Probabilidad
Caud
al
0.027027027027027
0.0810810810810811
0.135135135135135
0.189189189189189
0.243243243243243
0.297297297297297
0.351351351351351
0.405405405405405
0.45945945945946
0.513513513513514
0.567567567567568
0.621621621621622
0.675675675675676
0.72972972972973
0.783783783783784
0.837837837837838
0.891891891891892
0.9459459459459460
100
200
300
400
500
600
700
Curva de caudales clasificados
Probabilidad
Caud
al
altura area A perimetro mojado radio hidraulico Rh pendiente S0.5 0 0 0 0.003
1 0.9528 3.6876 0.258379433778067 0.0031.5 2.1928 1.9316 1.13522468419963 0.003
2 2.8301 1.5678 1.80514096185738 0.0032.5 3.882 2.8897 1.3433920476174 0.003
3 4.4325 1.0839 4.08939939108774 0.0033.5 4.6777 1.2259 3.81572722081736 0.003
4 5.5168 3.6799 1.4991711731297 0.003
maning n caudal Q0.024 00.024 0.285586750.024 6.053006590.024 15.66454730.024 13.79459890.024 83.65413670.024 79.5697020.024 23.1107191
0 0.5 1 1.5 2 2.5 3 3.5 4 4.50
102030405060708090
Curva de Gastos
Tirante
Caud
al
0 0.5 1 1.5 2 2.5 3 3.5 4 4.50
102030405060708090
Curva de Gastos
Tirante
Caud
al
