MIP-Method-for-Hydrology-Calculation.xlsx

	B	C	D	E	F	G	H	I	L
1	Non-Dimensional Regional Hydrograph
2	Month	Region
3	Month	1	2	3	4	5	6	7
4	January	2.40	2.24	2.71	2.59	2.42	2.03	3.30
5	February	1.80	1.70	1.88	1.88	1.82	1.62	2.20
6	March	1.30	1.33	1.38	1.38	1.36	1.27	1.40
7	April	1.00	1.00	1.00	1.00	1.00	1.00	1.00
8	May	2.60	1.21	1.88	2.19	0.91	2.57	3.50
9	June	6.00	7.27	3.13	3.75	2.73	6.08	6.00
10	July	14.50	18.18	13.54	6.89	11.21	24.32	14.00	1
11	August	25.00	27.27	25.00	27.27	13.94	33.78	35.00	2
12	September	16.50	20.91	20.83	20.91	10.00	27.03	24.00	3
13	October	8.00	9.09	10.42	6.89	6.52	6.08	12.00	4
14	November	4.10	3.94	5.00	5.00	4.55	3.38	7.50	5
15	December	3.10	3.03	3.75	3.44	3.33	2.57	5.00	6
16									7
17
18			Given region	3
19
20	Estimating the Hydrograph of Mean Monthly Flows
21
22	Month	Non-dimensional Hydrograph		Measured value (m3/s)	Predicted April Flow (m3/s)		Predicted Hydrograph (m3/s)		Prepared By Er. Krishna Khadka
23
24	January	2.71					1.074
25	February	1.88					0.745
26	March	1.38					0.547
27	April	1.00			0.396		0.396
28	May	1.88					0.745
29	June	3.13		1.24			1.240
30	July	13.54					5.364
31	August	25.00					9.904
32	September	20.83					8.252
33	October	10.42					4.128
34	November	5.00					1.981
35	December	3.75					1.486
36
37
38	Plotting Data
39	Month	Predicted Hydrograph(m3/s)
40	January	1.074
41	February	0.745
42	March	0.547
43	April	0.396
44	May	0.745
45	June	1.240
46	July	5.364
47	August	9.904
48	September	8.252
49	October	4.128
50	November	1.981
51	December	1.486
52
53
54
55
56
57
58
59
60	Flow Duration Curve
61	S.No.	Discharge	Probability of Exceedence (%)	Discharge m3/s
62	1	1.074	8.33	9.904
63	2	0.745	16.67	8.252
64	3	0.547	25.00	5.364
65	4	0.396	33.33	4.128
66	5	0.745	41.67	1.981
67	6	1.240	50.00	1.486
68	7	5.364	58.33	1.240
69	8	9.904	66.67	1.074
70	9	8.252	75.00	0.745
71	10	4.128	83.33	0.745
72	11	1.981	91.67	0.547
73	12	1.486	100.00	0.396
74
75
76		0	4.5
77		5	4.15
78		10	3.72
79		15	2.6
80		20	2.42
81		25	2.236
82		30	1.456
83		35	1.112
84		40	0.975
85		45	0.752
86		50	0.632
87		55	0.542
88		60	0.442
89		65	0.412
90		70	0.392
91		75	0.37
92		80	0.312
93		85	0.254
94		90	0.212
95		95	0.176
96		100	0.154
97
98
99
100