please solve this question in 60 minutes i will give you upvote

Problem 2 [25%] Considering the flow rate of the hydrologic year 2012/13 observed in a gauge station and presented in the table in next page (flow rate in m/s), determine the duration curve of that year (the curve should be presented as a table with six points). Note that for simplification, the flow rate is constant along each month, except for February 2013 where the maximum of 100 m/s occurs in 1-Feb-2013. Flow Flow rate Date Date rate (m/s) 10 (m/s) 10 10 10 0 0 0 11 10 10 0 10 0 0 10 10 10 0 0 SER==== 10 0 10 0 0 0 10 10 10 10 0 0 0 10 10 0 0 0 10 10 10 10 0 0 10 0 10 10 0 0 10 0 0 0 10 10 10 10 0 0 Flow rate Date (m/s) 5 1-Dec-2012 5 2-Dec-2012 5 3-Dec-2012 5 4-Dec-2012 5 5-Dec-2012 5 6-Dec-2012 5 7-Dec-2012 5 8-Dec-2012 5 9-Dec-2012 5 10-Dec-2012 5 11-Dec-2012 5 12-Dec-2012 5 13-Dec-2012 5 14-Dec-2012 5 15-Dec-2012 5 16-Dec-2012 5 17-Dec-2012 5 18-Dec-2012 5 19-Dec-2012 5 20-Dec-2012 5 21-Dec-2012 5 22-Dec-2012 5 23-Dec-2012 5 24-Dec-2012 5 25-Dec-2012 5 26-Dec-2012 5 27-Dec-2012 5 28-Dec-2012 5 29-Dec-2012 5 30-Dec-2012 5 31-Dec-2012 2 1-Jan-2013 2 2-Jan-2013 2 3-Jan-2013 2 4-Jan-2013 2 5-Jan-2013 2 6-Jan-2013 2 7-Jan-2013 2 8-Jan-2013 2 9-Jan-2013 2 10-Jan-2013 2 11-Jan-2013 2 12-Jan-2013 2 13-Jan-2013 2 14-Jan-2013 2 15-Jan-2013 2 16-Jan-2013 2 17-Jan-2013 2 18-Jan-2013 2 19-Jan-2013 2 20-Jan-2013 2 21-Jan-2013 2 22-Jan-2013 2 23-Jan-2013 2 24-Jan-2013 2 25-Jan-2013 2 26-Jan-2013 2 27-Jan-2013 2 28-Jan-2013 2 29-Jan-2013 2 30-Jan-2013 31-Jan-2013 Flow Date rate (m/s) 1-Feb-2013 100 2-Feb-2013 20 3-Feb-2013 20 4-Feb-2013 20 5-Feb-2013 20 6-Feb-2013 20 7-Feb-2013 20 8-Feb-2013 20 9-Feb-2013 20 10-Feb-2013 20 11-Feb-2013 20 12-Feb-2013 20 13-Feb-2013 20 14-Feb-2013 20 15-Feb-2013 20 16-Feb-2013 20 17-Feb-2013 20 18-Feb-2013 20 19-Feb-2013 20 20-Feb-2013 20 21-Feb-2013 20 22-Feb-2013 20 23-Feb-2013 20 24-Feb-2013 20 25-Feb-2013 20 26-Feb-2013 20 27-Feb-2013 20 28-Feb-2013 20 1-Mar-2013 2 2-Mar-2013 2 3-Mar-2013 2 4-Mar-2013 2 5-Mar-2013 2 6-Mar-2013 2 7-Mar-2013 2 8-Mar-2013 2 9-Mar-2013 2 10-Mar-2013 2 11-Mar-2013 2 12-Mar-2013 2 13-Mar-2013 2 14-Mar-2013 2 15-Mar-2013 2 16-Mar-2013 2 17-Mar-2013 2 18-Mar-2013 2 19-Mar-2013 2 20-Mar-2013 2 21-Mar-2013 2 22-Mar-2013 2 23-Mar-2013 2 24-Mar-2013 2 25-Mar-2013 2 26-Mar-2013 2 27-Mar-2013 2 28-Mar-2013 2 29-Mar-2013 2 30-Mar-2013 2 31-Mar-2013 2 1-Oct-2012 2-Oct-2012 3-Oct-2012 4-Oct-2012 5-Oct-2012 6-Oct-2012 7-Oct-2012 8-Oct-2012 9-Oct-2012 10-Oct-2012 11-Oct-2012 12-Oct-2012 13-Oct-2012 14-Oct-2012 15-Oct-2012 16-Oct-2012 17-Oct-2012 18-Oct-2012 19-Oct-2012 20-Oct-2012 21-Oct-2012 22-Oct-2012 23-Oct-2012 24-Oct-2012 25-Oct-2012 26-Oct-2012 27-Oct-2012 28-Oct-2012 29-Oct-2012 30-Oct-2012 31-Oct-2012 1-Nov-2012 2-Nov-2012 3-Nov-2012 4-Nov-2012 5-Nov-2012 6-Nov-2012 7-Nov-2012 8-Nov-2012 9-Nov-2012 10-Nov-2012 11-Nov-2012 12-Nov-2012 13-Nov-2012 14-Nov-2012 15-Nov-2012 16-Nov-2012 17-Nov-2012 18-Nov-2012 19-Nov-2012 20-Nov-2012 21-Nov-2012 22-Nov-2012 23-Nov-2012 24-Nov-2012 25-Nov-2012 26-Nov-2012 27-Nov-2012 28-Nov-2012 29-Nov-2012 30-Nov-2012 0 Flow Flow Date rate Date rate (m/s) 1-Jun-2013 0 1-Aug-2013 0 2-Jun-2013 0 2-Aug-2013 0 3-Jun-2013 0 3-Aug-2013 0 4-Jun-2013 0 4-Aug-2013 0 5-Jun-2013 0 5-Aug-2013 0 6-Jun-2013 0 6-Aug-2013 0 7-Jun-2013 0 7-Aug-2013 0 8-Jun-2013 0 8-Aug-2013 0 9-Jun-2013 0 9-Aug-2013 0 10-Jun-2013 0 10-Aug-2013 0 11-Jun-2013 0 11-Aug-2013 0 12-Jun-2013 0 12-Aug-2013 0 13-Jun-2013 0 13-Aug-2013 0 14-Jun-2013 0 14-Aug-2013 0 15-Jun-2013 0 15-Aug-2013 0 16-Jun-2013 0 16-Aug-2013 0 17-Jun-2013 0 17-Aug-2013 0 18-Jun-2013 0 18-Aug-2013 0 19-Jun-2013 0 19-Aug-2013 0 20-Jun-2013 0 20-Aug-2013 0 21-Jun-2013 0 21-Aug-2013 0 22-Jun-2013 0 22-Aug-2013 0 23-Jun-2013 0 23-Aug-2013 0 24-Jun-2013 0 24-Aug-2013 0 25-Jun-2013 0 25-Aug-2013 0 26-Jun-2013 0 26-Aug-2013 0 27-Jun-2013 0 27-Aug-2013 0 28-Jun-2013 0 28-Aug-2013 0 29-Jun-2013 0 29-Aug-2013 0 30-Jun-2013 0 30-Aug-2013 0 1-Jul-2013 0 31-Aug-2013 0 2-Jul-2013 0 1-Sep-2013 0 3-Jul-2013 0 2-Sep-2013 0 4-Jul-2013 0 3-Sep-2013 0 5-Jul-2013 0 4-Sep-2013 0 6-Jul-2013 0 5-Sep-2013 0 7-Jul-2013 0 6-Sep-2013 0 8-Jul-2013 0 7-Sep-2013 0 9-Jul-2013 0 8-Sep-2013 0 10-Jul-2013 0 9-Sep-2013 0 11-Jul-2013 0 10-Sep-2013 0 12-Jul-2013 0 11-Sep-2013 0 13-Jul-2013 0 12-Sep-2013 0 14-Jul-2013 0 13-Sep-2013 0 15-Jul-2013 0 14-Sep-2013 0 16-Jul-2013 0 15-Sep-2013 0 17-Jul-2013 0 16-Sep-2013 0 18-Jul-2013 0 17-Sep-2013 0 19-Jul-2013 0 18-Sep-2013 0 20-Jul-2013 0 19-Sep-2013 0 21-Jul-2013 0 20-Sep-2013 0 22-Jul-2013 0 21-Sep-2013 0 23-Jul-2013 0 22-Sep-2013 0 24-Jul-2013 0 23-Sep-2013 0 25-Jul-2013 0 24-Sep-2013 0 26-Jul-2013 0 25-Sep-2013 0 27-Jul-2013 0 26-Sep-2013 0 28-Jul-2013 0 27-Sep-2013 0 29-Jul-2013 0 28-Sep-2013 0 30-Jul-2013 0 29-Sep-2013 0 31-Jul-2013 0 30-Sep-2013 0 1-Apr-2013 2-Apr-2013 3-Apr-2013 4-Apr-2013 5-Apr-2013 6-Apr-2013 7-Apr-2013 8-Apr-2013 9-Apr-2013 10-Apr-2013 11-Apr-2013 12-Apr-2013 13-Apr-2013 14-Apr-2013 15-Apr-2013 16-Apr-2013 17-Apr-2013 18-Apr-2013 19-Apr-2013 20-Apr-2013 21-Apr-2013 22-Apr-2013 23-Apr-2013 24-Apr-2013 25-Apr-2013 26-Apr-2013 27-Apr-2013 28-Apr-2013 29-Apr-2013 30-Apr-2013 1-May-2013 2-May-2013 3-May-2013 4-May-2013 5-May-2013 6-May-2013 7-May-2013 8-May-2013 9-May-2013 10-May-2013 11-May-2013 12-May-2013 13-May-2013 14-May-2013 15-May-2013 16-May-2013 17-May-2013 18-May-2013 19-May-2013 20-May-2013 21-May-2013 22-May-2013 23-May-2013 24-May-2013 25-May-2013 26-May-2013 27-May-2013 28-May-2013 29-May-2013 30-May-2013 31-May-2013 10 10 0 0 2 2 0 0 0 0 2 2 2 2 2 2 0 0 0 0 0 0 2 2 2 2 2 2 2 0 0 0 0 0 0 2 2 2 2 0 0 0 0 0 0 1 0 0 TTTTTTT 2 2 2 2 2 2 2 2 2 2 2 2 0 0 0 0 0 Formulae T = : yAho absolute Patm = 1.01325 x 10% Pa Min - Mou + 7 +G+1 = 0) + H P +z+U 2 a LUP hg = f 1 = S,L E 2.51 y = D2g 2g = :-2 log10 + F 3.70 Ref H2 = H, -h, -hm UD Re = V M = a'pUS = A'PQU = a'p.? - S U? V water(T=20 C) = 10-6 m/s m hm = K 2g P P turbine = nP row = n/QH met A U2 E = h+a 2g R, = Q=-sr 13 sy? 2/3 s(h) Q. = Vgs(hc), b(h.) P n Q? m= ha h2 h. = 3 hve = Chopening &B2 x; Eyi y = a2 = [(x-7)(y;-))) (, -x)] P= at" y=a2x+a n n P flow YOH total U a = 7-a27 1 ft 0.3048 m pump Fr = n n Ngh E production 'annual ny net turbine CU. 2LU 0 1 J = 1/3600 Wh = 19 P 7 7 8 gT max max TURBINE Q1 = Qmin/QN az = Qmax/ON Pelton single spear jet 0.15 1.25 Francis (low ns) 0.3 1.25 Francis (high ns) 0.5 1.25 Cross flow 0.1 1.25 Kaplan with double adjustment 0.2 1.25 Kaplan with just blades adjustment 0.5 1.0 Archimedean screw 0.3 1.15 Problem 2 [25%] Considering the flow rate of the hydrologic year 2012/13 observed in a gauge station and presented in the table in next page (flow rate in m/s), determine the duration curve of that year (the curve should be presented as a table with six points). Note that for simplification, the flow rate is constant along each month, except for February 2013 where the maximum of 100 m/s occurs in 1-Feb-2013. Flow Flow rate Date Date rate (m/s) 10 (m/s) 10 10 10 0 0 0 11 10 10 0 10 0 0 10 10 10 0 0 SER==== 10 0 10 0 0 0 10 10 10 10 0 0 0 10 10 0 0 0 10 10 10 10 0 0 10 0 10 10 0 0 10 0 0 0 10 10 10 10 0 0 Flow rate Date (m/s) 5 1-Dec-2012 5 2-Dec-2012 5 3-Dec-2012 5 4-Dec-2012 5 5-Dec-2012 5 6-Dec-2012 5 7-Dec-2012 5 8-Dec-2012 5 9-Dec-2012 5 10-Dec-2012 5 11-Dec-2012 5 12-Dec-2012 5 13-Dec-2012 5 14-Dec-2012 5 15-Dec-2012 5 16-Dec-2012 5 17-Dec-2012 5 18-Dec-2012 5 19-Dec-2012 5 20-Dec-2012 5 21-Dec-2012 5 22-Dec-2012 5 23-Dec-2012 5 24-Dec-2012 5 25-Dec-2012 5 26-Dec-2012 5 27-Dec-2012 5 28-Dec-2012 5 29-Dec-2012 5 30-Dec-2012 5 31-Dec-2012 2 1-Jan-2013 2 2-Jan-2013 2 3-Jan-2013 2 4-Jan-2013 2 5-Jan-2013 2 6-Jan-2013 2 7-Jan-2013 2 8-Jan-2013 2 9-Jan-2013 2 10-Jan-2013 2 11-Jan-2013 2 12-Jan-2013 2 13-Jan-2013 2 14-Jan-2013 2 15-Jan-2013 2 16-Jan-2013 2 17-Jan-2013 2 18-Jan-2013 2 19-Jan-2013 2 20-Jan-2013 2 21-Jan-2013 2 22-Jan-2013 2 23-Jan-2013 2 24-Jan-2013 2 25-Jan-2013 2 26-Jan-2013 2 27-Jan-2013 2 28-Jan-2013 2 29-Jan-2013 2 30-Jan-2013 31-Jan-2013 Flow Date rate (m/s) 1-Feb-2013 100 2-Feb-2013 20 3-Feb-2013 20 4-Feb-2013 20 5-Feb-2013 20 6-Feb-2013 20 7-Feb-2013 20 8-Feb-2013 20 9-Feb-2013 20 10-Feb-2013 20 11-Feb-2013 20 12-Feb-2013 20 13-Feb-2013 20 14-Feb-2013 20 15-Feb-2013 20 16-Feb-2013 20 17-Feb-2013 20 18-Feb-2013 20 19-Feb-2013 20 20-Feb-2013 20 21-Feb-2013 20 22-Feb-2013 20 23-Feb-2013 20 24-Feb-2013 20 25-Feb-2013 20 26-Feb-2013 20 27-Feb-2013 20 28-Feb-2013 20 1-Mar-2013 2 2-Mar-2013 2 3-Mar-2013 2 4-Mar-2013 2 5-Mar-2013 2 6-Mar-2013 2 7-Mar-2013 2 8-Mar-2013 2 9-Mar-2013 2 10-Mar-2013 2 11-Mar-2013 2 12-Mar-2013 2 13-Mar-2013 2 14-Mar-2013 2 15-Mar-2013 2 16-Mar-2013 2 17-Mar-2013 2 18-Mar-2013 2 19-Mar-2013 2 20-Mar-2013 2 21-Mar-2013 2 22-Mar-2013 2 23-Mar-2013 2 24-Mar-2013 2 25-Mar-2013 2 26-Mar-2013 2 27-Mar-2013 2 28-Mar-2013 2 29-Mar-2013 2 30-Mar-2013 2 31-Mar-2013 2 1-Oct-2012 2-Oct-2012 3-Oct-2012 4-Oct-2012 5-Oct-2012 6-Oct-2012 7-Oct-2012 8-Oct-2012 9-Oct-2012 10-Oct-2012 11-Oct-2012 12-Oct-2012 13-Oct-2012 14-Oct-2012 15-Oct-2012 16-Oct-2012 17-Oct-2012 18-Oct-2012 19-Oct-2012 20-Oct-2012 21-Oct-2012 22-Oct-2012 23-Oct-2012 24-Oct-2012 25-Oct-2012 26-Oct-2012 27-Oct-2012 28-Oct-2012 29-Oct-2012 30-Oct-2012 31-Oct-2012 1-Nov-2012 2-Nov-2012 3-Nov-2012 4-Nov-2012 5-Nov-2012 6-Nov-2012 7-Nov-2012 8-Nov-2012 9-Nov-2012 10-Nov-2012 11-Nov-2012 12-Nov-2012 13-Nov-2012 14-Nov-2012 15-Nov-2012 16-Nov-2012 17-Nov-2012 18-Nov-2012 19-Nov-2012 20-Nov-2012 21-Nov-2012 22-Nov-2012 23-Nov-2012 24-Nov-2012 25-Nov-2012 26-Nov-2012 27-Nov-2012 28-Nov-2012 29-Nov-2012 30-Nov-2012 0 Flow Flow Date rate Date rate (m/s) 1-Jun-2013 0 1-Aug-2013 0 2-Jun-2013 0 2-Aug-2013 0 3-Jun-2013 0 3-Aug-2013 0 4-Jun-2013 0 4-Aug-2013 0 5-Jun-2013 0 5-Aug-2013 0 6-Jun-2013 0 6-Aug-2013 0 7-Jun-2013 0 7-Aug-2013 0 8-Jun-2013 0 8-Aug-2013 0 9-Jun-2013 0 9-Aug-2013 0 10-Jun-2013 0 10-Aug-2013 0 11-Jun-2013 0 11-Aug-2013 0 12-Jun-2013 0 12-Aug-2013 0 13-Jun-2013 0 13-Aug-2013 0 14-Jun-2013 0 14-Aug-2013 0 15-Jun-2013 0 15-Aug-2013 0 16-Jun-2013 0 16-Aug-2013 0 17-Jun-2013 0 17-Aug-2013 0 18-Jun-2013 0 18-Aug-2013 0 19-Jun-2013 0 19-Aug-2013 0 20-Jun-2013 0 20-Aug-2013 0 21-Jun-2013 0 21-Aug-2013 0 22-Jun-2013 0 22-Aug-2013 0 23-Jun-2013 0 23-Aug-2013 0 24-Jun-2013 0 24-Aug-2013 0 25-Jun-2013 0 25-Aug-2013 0 26-Jun-2013 0 26-Aug-2013 0 27-Jun-2013 0 27-Aug-2013 0 28-Jun-2013 0 28-Aug-2013 0 29-Jun-2013 0 29-Aug-2013 0 30-Jun-2013 0 30-Aug-2013 0 1-Jul-2013 0 31-Aug-2013 0 2-Jul-2013 0 1-Sep-2013 0 3-Jul-2013 0 2-Sep-2013 0 4-Jul-2013 0 3-Sep-2013 0 5-Jul-2013 0 4-Sep-2013 0 6-Jul-2013 0 5-Sep-2013 0 7-Jul-2013 0 6-Sep-2013 0 8-Jul-2013 0 7-Sep-2013 0 9-Jul-2013 0 8-Sep-2013 0 10-Jul-2013 0 9-Sep-2013 0 11-Jul-2013 0 10-Sep-2013 0 12-Jul-2013 0 11-Sep-2013 0 13-Jul-2013 0 12-Sep-2013 0 14-Jul-2013 0 13-Sep-2013 0 15-Jul-2013 0 14-Sep-2013 0 16-Jul-2013 0 15-Sep-2013 0 17-Jul-2013 0 16-Sep-2013 0 18-Jul-2013 0 17-Sep-2013 0 19-Jul-2013 0 18-Sep-2013 0 20-Jul-2013 0 19-Sep-2013 0 21-Jul-2013 0 20-Sep-2013 0 22-Jul-2013 0 21-Sep-2013 0 23-Jul-2013 0 22-Sep-2013 0 24-Jul-2013 0 23-Sep-2013 0 25-Jul-2013 0 24-Sep-2013 0 26-Jul-2013 0 25-Sep-2013 0 27-Jul-2013 0 26-Sep-2013 0 28-Jul-2013 0 27-Sep-2013 0 29-Jul-2013 0 28-Sep-2013 0 30-Jul-2013 0 29-Sep-2013 0 31-Jul-2013 0 30-Sep-2013 0 1-Apr-2013 2-Apr-2013 3-Apr-2013 4-Apr-2013 5-Apr-2013 6-Apr-2013 7-Apr-2013 8-Apr-2013 9-Apr-2013 10-Apr-2013 11-Apr-2013 12-Apr-2013 13-Apr-2013 14-Apr-2013 15-Apr-2013 16-Apr-2013 17-Apr-2013 18-Apr-2013 19-Apr-2013 20-Apr-2013 21-Apr-2013 22-Apr-2013 23-Apr-2013 24-Apr-2013 25-Apr-2013 26-Apr-2013 27-Apr-2013 28-Apr-2013 29-Apr-2013 30-Apr-2013 1-May-2013 2-May-2013 3-May-2013 4-May-2013 5-May-2013 6-May-2013 7-May-2013 8-May-2013 9-May-2013 10-May-2013 11-May-2013 12-May-2013 13-May-2013 14-May-2013 15-May-2013 16-May-2013 17-May-2013 18-May-2013 19-May-2013 20-May-2013 21-May-2013 22-May-2013 23-May-2013 24-May-2013 25-May-2013 26-May-2013 27-May-2013 28-May-2013 29-May-2013 30-May-2013 31-May-2013 10 10 0 0 2 2 0 0 0 0 2 2 2 2 2 2 0 0 0 0 0 0 2 2 2 2 2 2 2 0 0 0 0 0 0 2 2 2 2 0 0 0 0 0 0 1 0 0 TTTTTTT 2 2 2 2 2 2 2 2 2 2 2 2 0 0 0 0 0 Formulae T = : yAho absolute Patm = 1.01325 x 10% Pa Min - Mou + 7 +G+1 = 0) + H P +z+U 2 a LUP hg = f 1 = S,L E 2.51 y = D2g 2g = :-2 log10 + F 3.70 Ref H2 = H, -h, -hm UD Re = V M = a'pUS = A'PQU = a'p.? - S U? V water(T=20 C) = 10-6 m/s m hm = K 2g P P turbine = nP row = n/QH met A U2 E = h+a 2g R, = Q=-sr 13 sy? 2/3 s(h) Q. = Vgs(hc), b(h.) P n Q? m= ha h2 h. = 3 hve = Chopening &B2 x; Eyi y = a2 = [(x-7)(y;-))) (, -x)] P= at" y=a2x+a n n P flow YOH total U a = 7-a27 1 ft 0.3048 m pump Fr = n n Ngh E production 'annual ny net turbine CU. 2LU 0 1 J = 1/3600 Wh = 19 P 7 7 8 gT max max TURBINE Q1 = Qmin/QN az = Qmax/ON Pelton single spear jet 0.15 1.25 Francis (low ns) 0.3 1.25 Francis (high ns) 0.5 1.25 Cross flow 0.1 1.25 Kaplan with double adjustment 0.2 1.25 Kaplan with just blades adjustment 0.5 1.0 Archimedean screw 0.3 1.15