Area Capacity Curve.xlsx

	B	C	D	E	F	G	H	I	J	K	M
1
2
3	S.No	Elevation (m)	Elevation Difference	Water depth	Area (m2)	Area (Hectare)	Area (Hect-m)	Volume (m3)	Cummulative Volume (m3)	Cummulative Volume (MM3)
4			h					CONE FORMULA
5	1	777.0	0.0	0	95	0.01	0.00	3533.88	3534	0.004
6	3	778.0	1.0	1.0	1239	0.12	0.12	558.82	4093	0.004
7	5	779.0	1.0	2.0	3049	0.30	0.61	2077.20	6170	0.006	A1 & A2 are the areas enclosed by the successive contours at an interval h.
8	7	780.0	1.0	3.0	3822	0.38	1.15	3428.10	9598	0.010
9	9	781.0	1.0	4.0	4787	0.48	1.91	4295.50	13893	0.014
10	11	782.0	1.0	5.0	5895	0.59	2.95	5331.61	19225	0.0192
11	13	783.0	1.0	6.0	8164	0.82	4.90	6999.07	26224	0.0262
12	15	784.0	1.0	7.0	10063	1.01	7.04	9097.24	35321	0.0353
13	17	785.0	1.0	8.0	15266	1.53	12.21	12574.67	47896	0.048
14	19	786.0	1.0	9.0	18238	1.82	16.41	16730.14	64626	0.065
15	21	787.0	1.0	10.0	20734	2.07	20.73	19472.64	84099	0.084
16	23	788.0	1.0	11.0	22439	2.24	24.68	21580.95	105680	0.106
17	24	789.0	1.0	12.0	22626	2.26	27.15	22532.52	128212	0.128
18
19	Note :	A1 & A2 are the areas enclosed by the successive contours at an interval h.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100