Clary Lake Gate Flow Calculations

	A	B	C	D	E	F	G	H	I	K	L	M	N	Q	R	V	W	X
1	CFS Outflows for Different Sluice Gate Openings for a Given Water Level													Standard Contracted Rectangular Weir Calculations		Broad Crested Weir Calculations
2	Clary Lake Association														100.00	When the lake level reaches the high water mark, the top of the dam becomes a uncontrolled spillway over it's entire length which is about 100' long, more or less. This calculates flows over the top of the dam in increments of 1/10th of a foot.
3	Prepared by George Fergusson January 6, 2019
4														Length L	5.00
5			Any Opening											b	5.00		Length L:	96
6		Y2	1.71											P	5.00		C:	3.08736973
7		Y1	8.17											H	1.00
8		Cc	0.61											Q	15.98	H	Q (cfs)
9		g	32.17													0.0	0.0
10		Cd	0.5744311343											L:	5.00	0.1	9.4
11		V2	13.17011379		Elevation of bottom of weir: 142' ±									H		0.2	26.5
12		q	62.38287799					NHWM:	151.17					0.1	0.52	0.3	48.7
13		q+2	63.38287799		See this site for more information:			Water Level	0					0.2	1.48	0.4	75.0
14		Gate Leakage:	1		http://ponce.sdsu.edu/onlinechannel13.php			Weir Depth Y1	8.17					0.3	2.70	0.5	104.8
15	Sluice Opening Y2							(water level in ft below hwm)						0.4	4.14	0.6	137.7
16	Inches	Feet	CFS Outflow	with 2 cfs leak	Discharge coefficient Cd		Reference Velocity V2							0.5	5.77	0.7	173.6
17	0	0	0.00	1.0	0.61		13.9856093							0.6	7.55	0.8	212.1
18	1	0.0833	3.22	4.2	0.6081118671		13.94231964							0.7	9.48	0.9	253.1
19	2	0.1666	6.41	7.4	0.6062411593		13.8994295							0.8	11.53	1.0	296.4
20	3	0.2499	9.59	10.6	0.6043876104		13.85693276							0.9	13.70	1.1	341.9
21	4	0.3332	12.75	13.8	0.6025509595		13.81482344							1	15.98	1.2	389.6
22	5	0.4165	15.89	16.9	0.6007309515		13.7730957							1.1	18.36	1.3	439.3
23	6	0.4998	19.01	20.0	0.5989273365		13.73174381							1.2	20.84	1.4	491.0
24	7	0.5831	22.11	23.1	0.5971398698		13.69076216							1.3	23.40	1.5	544.5
25	8	0.6664	25.20	26.2	0.5953683121		13.65014525							1.4	26.04	1.6	599.8
26	9	0.7497	28.26	29.3	0.5936124286		13.6098877							1.5	28.75	1.7	657.0
27	10	0.833	31.31	32.3	0.5918719896	Approximate	13.56998426							1.6	31.54	1.8	715.8
28	11	0.9163	34.34	35.3	0.59014677	error	13.53042976			The Gate in the dam is not circular! The bottom 13.5" is closed!				1.7	34.40	1.9	776.2
29	12	0.9996	36.61	37.6	0.5884365493	0.98	13.49121914		At 12" opening, calculated area = 398 sq in., actual area = 392 sq in. (98%) Very close!					1.8	37.31	2.0	838.3
30	13	1.0829	39.42	40.4	0.5867411113	0.977	13.45234744		CFS results below this line will be increasingly in error because calculations assume a rectangular orifice. They've been adjusted by the amounts in column F					1.9	40.29
31	14	1.1662	42.25	43.2	0.5850602444	0.975	13.41380982							2	43.33	0.82	220.1
32	15	1.2495	45.04	46.0	0.583393741	0.973	13.37560152							2.1	46.41
33	16	1.3328	47.76	48.8	0.5817413977	0.97	13.33771787							2.2	49.55
34	17	1.4161	48.52	49.5	0.5801030152	0.93	13.3001543
35	18	1.4994	49.58	50.6	0.5784783978	0.9	13.26290632							2.2	49.55
36	19	1.5827	49.87	50.9	0.576867354	0.86	13.22596955
37	20	1.666	51.13	52.1	0.5752696957	0.84	13.18933968
38	Max Open: 20.5	1.71	51.15	52.2	0.5744311343	0.82	13.17011379		Fully open, flow is 82% lower than calculated or about 55 cfs when the lake is full.
39
40
41
42
43
44
45										Gate Openings to release Minimum Flows
46										Assumptions: Water Level -2 below HWM
47
48										Date	Minimum Flow	Gate Opening
49										1-1 to 3-15	11.3	0.32	0.28
50										3-16 to 5-15	35.9	1.04
51										5-16 to 6-30	8.3	0.24
52										7-1 to 9-15	1.9	0.06
53										9-16 to 11-15	3.5	0.1
54										11-16 to 12-31	15.5	0.45
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69	This picture shows the obstruction across the bottom of the 34" diameter outlet pipe that represents a reduction in area of about 37%
70
71
72
73	150.89	0.01
74	150.90	0.01
75	150.91	0.01
76	150.92	0.01
77	150.93	0.04
78	150.94	0.08
79	150.95	0.13
80	150.96	0.19
81	150.97	0.28
82	150.98	0.41
83	150.99	0.56
84	151.00	0.74
85	151.01	0.97
86	151.02	1.23
87	151.03	1.53
88	151.04	1.85
89	151.05	2.21
90	151.06	2.60
91	151.07	3.03
92	151.08	3.51
93	151.09	4.03
94	151.10	4.60
95	151.11	5.24
96	151.12	5.93
97	151.13	6.68
98	151.14	7.49
99	151.15	8.37
100	151.16	9.30