ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Hoja_HS01FechaQd_m3/smQd_m3/s ordenado% PersistenciaIndices hidrológicos*
2
Curva de Duracion de caudales diarios
(método simplificado*)
1/1/20170.41150.3Ingresar persistencia (%) =99
3
2/1/20170.5213.30.5Q (m3/s) =0.2
4
3/1/20170.5312.20.8
5
4/1/20170.4411.41.1
*Ver Gráfico en la hoja Figura_CDuracion (ajustar ejes)
6
Nro de datos (n):5/1/20170.5511.41.4
7
3656/1/20170.3610.11.6
8
1. Copiar la columna C en E (Editar - Pegado especial - solo los valores)
2. Ordenar de mayor a menor con la opcion Datos-Ordenar Intervalo (Z-A)
7/1/20170.379.11.9
9
8/1/20170.388.92.2
10
9/1/20170.398.72.5
11
10/1/20170.3108.62.7
12
11/1/20170.3118.43.0
13
Leyenda12/1/20170.4128.23.3
14
Celda para el ingreso de datos13/01/20170.7138.23.6
15
Celda automática14/01/20171.41483.8
16
Celda a verificar15/01/20171.4157.84.1
17
Celda resultado16/01/20171.4167.84.4
18
17/01/20171.5177.64.6
19
Nota: Los resultados obtenidos son de responsabilidad del usuario
+info: http://pedrorau.blogspot.com/
18/01/20171.3187.64.9
20
19/01/20171.1197.55.2
21
20/01/20171.1207.35.5
22
*Ver: Vogel R. 1994. Flow Duration Curves I: New interpretation and confidence intervals, Journal of Water Resources Planning and Management,
120, 485–504
21/01/20171.12175.7
23
22/01/20171.5226.76.0
24
23/01/20172.7236.66.3
25
24/01/20171.5246.66.6
26
25/01/20171.2256.56.8
27
26/01/20171.1266.47.1
28
27/01/20171276.37.4
29
28/01/20171286.37.7
30
29/01/20171296.27.9
31
30/01/20171306.18.2
32
31/01/20170.93168.5
33
1/2/20170.93268.7
34
2/2/20171335.89.0
35
3/2/20171.4345.79.3
36
4/2/20172355.59.6
37
5/2/20172365.59.8
38
6/2/20171.9375.410.1
39
7/2/20171.6385.410.4
40
8/2/20171.6395.310.7
41
9/2/20171.8405.310.9
42
10/2/20171.7415.111.2
43
11/2/20171.742511.5
44
12/2/20171.543511.7
45
13/02/20171.444512.0
46
14/02/20171.345512.3
47
15/02/20171.246512.6
48
16/02/20171.3474.912.8
49
17/02/20171.5484.813.1
50
18/02/20171.8494.713.4
51
19/02/20172.7504.713.7
52
20/02/20172.8514.613.9
53
21/02/20173.1524.614.2
54
22/02/20178534.614.5
55
23/02/20177.8544.514.8
56
24/02/20174.7554.515.0
57
25/02/20174.2564.415.3
58
26/02/20175.5574.315.6
59
27/02/20176.6584.315.8
60
28/02/201712.2594.216.1
61
1/3/20178.2604.216.4
62
2/3/20178.661416.7
63
3/3/20178.4623.916.9
64
4/3/20178.9633.817.2
65
5/3/201713.3643.817.5
66
6/3/20178.2653.717.8
67
7/3/20176.7663.618.0
68
8/3/201710.1673.618.3
69
9/3/20177.6683.518.6
70
10/3/20176.3693.518.9
71
11/3/20176.2703.519.1
72
12/3/20176.6713.419.4
73
13/03/20177.3723.419.7
74
14/03/20177.8733.419.9
75
15/03/201711.4743.220.2
76
16/03/20175.7753.220.5
77
17/03/20175.1763.120.8
78
18/03/20175.3773.121.0
79
19/03/20171578321.3
80
20/03/20179.179321.6
81
21/03/20175.4802.921.9
82
22/03/20175812.922.1
83
23/03/20178.7822.822.4
84
24/03/20176.4832.822.7
85
25/03/20177.5842.823.0
86
26/03/20176.1852.823.2
87
27/03/20175862.823.5
88
28/03/20174.6872.723.8
89
29/03/20174.3882.724.0
90
30/03/20174.5892.724.3
91
31/03/20174.6902.624.6
92
1/4/20175.5912.624.9
93
2/4/20177.6922.625.1
94
3/4/20176.5932.625.4
95
4/4/20175.3942.425.7
96
5/4/20175952.426.0
97
6/4/20177962.426.2
98
7/4/20175.8972.426.5
99
8/4/20175982.426.8
100
9/4/20174.9992.427.0