Lake D Water Testing

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Date	Phosphorus Activity	test taken by	Conditions	Clarity Ft	Locations	GPS North	GPS West	Phosphorous mg/L	Result	times over normal at .03 mg/L	Chlorophyll ug/L	TSI(TP)	Nitrogen	% Solids	% Water	% Inorganic	% Organic

2	6/24/2008	watch spot	cr			east pipe			0.13	over	4.3
3	7/23/2008	watch spot	cr			east Keating			0.11	over	3.67
4	7/23/2008	watch spot	cr			north Evans			0.11	over	3.67
5	7/23/2008	watch spot	cr			Middle south inlet pipe #6			0.68	over	22.67
6	7/23/2008	watch spot	cr			waterfall			0.11	over	3.67
7	6/6/2009	watch spot	cr			south east channel			0.11	over	3.67
8	6/6/2009	watch spot	cr			Middle south inlet pipe #6			0.2	over	6.67
9	6/6/2009	watch spot	cr			south west boyke farm			1.4	over	46.68
10	9/23/2009	watch spot	cr			south east channel			0.1	over	3.33
11	9/23/2009	watch spot	cr			Middle south inlet pipe #6			0.11	over	3.67
12	9/23/2009	watch spot	cr			south west boyke farm			1.04	over	34.67
13	6/24/2010	watch spot	cr			Middle south inlet pipe #6			0.1	over	3.33
14	6/24/2010	watch spot	cr			waterfall			0.07	over	2.33
15	6/24/2010	watch spot	cr			south west boyke farm			0.61	over	20.34
16	4/11/2011	Citizen lake monitoring	cr	normal	8	deep hole
17	4/29/2011	Citizen lake monitoring	cr	normal	14	deep hole
18	4/29/2011	watch spot	cr			east pipe			0.02	under
19	4/29/2011	watch spot	cr			Middle south inlet pipe #6			0.29	over	9.67
20	4/29/2011	watch spot	cr			waterfall			0.036	over	1.2
21	5/10/2011	Citizen lake monitoring	cr	normal	16	deep hole
22	5/29/2011	Citizen lake monitoring	cr	normal	26	deep hole
23	6/6/2011	Citizen lake monitoring	cr + je	normal	20	deep hole
24	6/14/2011	DNR monthly test: June	cr + je	normal		deep hole			0.015	under		0.79	49
25	6/15/2011	Citizen lake monitoring	cr + je	normal	19	deep hole
26	6/19/2011	watch spot	cr	heavy rain		Middle south inlet pipe #6			0.23	over	7.67
27	6/19/2011	watch spot	cr	heavy rain		south west boyke farm			0.85	over	28.34
28	6/25/2011	Citizen lake monitoring	je	normal	22	deep hole
29	7/12/2011	Citizen lake monitoring	je	normal	13	deep hole
30	7/18/2011	Citizen lake monitoring	je	normal	16	deep hole
31	7/18/2011	DNR monthly test: July	je	normal		deep hole			0.013	under		3.19	48
32	7/27/2011	watch spot		heavy rain		culvert			0.3	over	10
33	7/30/2011	Citizen lake monitoring	je	normal	12	deep hole
34	7/30/2011	Zebra Mussel cleanup			GPS	N 43 73.1305' W 88 39.6318'
35	8/12/2011	Citizen lake monitoring	je	normal	10	deep hole
36	8/12/2011	watch spot	je + fc	normal		east Keating			0.016	under
37	8/12/2011	watch spot	je + fc	normal		east pipe			0.016	under
38	8/12/2011	watch spot	je + fc	normal		north Evans			0.016	under
39	8/12/2011	watch spot	je + fc	normal		Middle south inlet pipe #6			0.083	over	2.8
40	8/12/2011	watch spot	je + fc	normal		waterfall			0.016	under
41	8/22/2011	Citizen lake monitoring	je + fc	normal	12	deep hole
42	8/22/2011	DNR monthly test: Aug.	je + fc	normal		deep hole			0.016	under		4.4	50
43	9/6/2011	Citizen lake monitoring	je	normal	10	deep hole
44	4/12/2012	Citizen lake monitoring	je	dry	27	deep hole
45	5/4/2012	Citizen lake monitoring	je	heavy rain	25	deep hole
46	5/23/2012	Citizen lake monitoring	je	normal	18	deep hole
47	5/28/2012	watch spot	je	dry		east pipe			0.012	under
48	5/28/2012	watch spot	je	dry		Middle south inlet pipe #6			0.028	under	0.93
49	5/28/2012	watch spot	je	dry		waterfall			0.018	under
50	5/28/2012	watch spot	bm	dry		HY 45 bridge			0.49	over	16.3
51	6/4/2012	Citizen lake monitoring	je	dry	27	deep hole
52	6/4/2012	DNR monthly test: June	je	dry		deep hole			0.019	under		0.69	51
53	6/24/2012	watch spot	cr			east pipe			0.13	over	4.33
54	7/4/2012	Citizen lake monitoring	je	very dry	25	deep hole
55	7/17/2012	Citizen lake monitoring	je	extra dry	18	deep hole
56	7/17/2012	DNR monthly test July	je		18	deep hole			0.015	under		2.16	49
57	8/10/2012	watch spot	je	heavy rain		south pond powerline			0.12	over	4
58	8/10/2012	watch spot	je	heavy rain		south woods powerline			0.17	over	5.66
59	8/11/2012	watch spot	je	heavy rain		waterfall			0.04	over	1.33
60	8/11/2012	watch spot	bm	heavy rain		Middle south inlet pipe #6			0.44	over	14.6
61	8/15/2012	Citizen lake monitoring	je	normal	17	deep hole
62	8/15/2012	DNR monthly test Aug	je		17	deep hole			0.012	under		2.07	47
63	4/16/2013	watch spot	je	heavy rain		HY 45 bridge			0.48	over	16
64	4/16/2013	watch spot	je	heavy rain		middle east ditch			0.31	over	10.3
65	4/16/2013	watch spot	je	heavy rain		south merged powerline			0.61	over	20.3
66	4/19/2013	watch spot	je	rain		south woods powerline			0.18	over	6
67	4/19/2013	watch spot	je	rain		south pond powerline			0.12	over	4
68	4/19/2013	watch spot	je	rain		south merged powerline			0.12	over	4
69	4/19/2013	watch spot	je	rain		Middle south inlet pipe #6			0.14	over	4.6
70	4/19/2013	watch spot	je	rain		south west boyke farm			4.6	over	153
71	5/4/2013	watch spot	je	med rain		south west boyke farm			4.5	over	150
72	5/4/2013	watch spot	je	med rain		Middle south inlet pipe #6			0.7	over	23.3
73	5/4/2013	watch spot	je	med rain		south woods east channel			0.7	over	23.3
74	5/4/2013	watch spot	je	med rain		Middle south inlet pipe #6			0.48	over	16
75	5/24/2013	DNR monthly test May	je		21	deep hole			0.026			not tested	53
76	6/17/2013	DNR monthly test june	je	normal	21	deep hole			0.016			1.3	50
77	6/22/2013	watch spot	je	med rain		south middle abel farm			0.14	over	4.6
78	6/22/2013	watch spot	je	med rain		south east ledge			0.08	over	2.6
79	6/22/2013	watch spot	je	med rain		south west boyke farm			3.2	over	106.6
80	6/22/2013	watch spot	je	med rain		enter lake south			0.95	over	31.6
81	7/23/2013	DNR monthly test july	je	normal	19	deep hole			0.0113	normal		2.2	47
82	8/16/2013	DNR monthly test August	je	normal	22	deep hole			0.0127	normal		2.02	48
83	4/16/2014	watch spot	je	heavy rain		Southeast source (ledge) pipe#4			0.035	normal	1.16
84	4/16/2014	watch spot	je	heavy rain		Southcenter channel pipe#2			0.21	over	7
85	4/16/2014	watch spot	je	heavy rain		Southwest channel (Boyke) pipe#1			0.37	over	12.3
86	4/16/2014	watch spot	je	heavy rain		HY 45 bridge			0.38	over	12.6
87	4/16/2014	watch spot	je	heavy rain		Southeast channel (ledge) pipe#3			0.26	over	8.66
88	5/13/2014	watch spot	je	med rain		Southwest channel (Boyke) pipe#1	43.726187 ' N	88.395203 ' W	1.4	over	46.7
89	5/13/2014	watch spot	je	med rain		Southcenter channel pipe#2	43.726472 ' N	88.395187 ' W	0.035	normal	1.16
90	5/13/2014	watch spot	je	med rain		Southeast channel (ledge) pipe#3	43.726533 ' N	88.394928 ' W	0.04	over	1.33
91	5/13/2014	watch spot	je	med rain		Southeast source (ledge) pipe#4	43.725543 ' N	88.394195 ' W	0.06	over	2
92	5/13/2014	watch spot	je	med rain		Tursky valley pipe #5	43.725197 ' N	88.394020 ' W	0.04	over	1.33
93	5/13/2014	watch spot	je	med rain		Middle south inlet pipe #6	43.727213 ' N	88.395378 ' W	0.25	over	8.3
94	5/19/2014	watch spot	je	med rain		deep hole			0.035	normal	1.16
95	5/28/2014	DNR monthly test May	je	normal	22	deep hole			0.033	normal	1.1
96	6/2/2014	watch spot	je	heavy rain 3 in		Southwest channel (Boyke) pipe#1			1.9	over	63.3
97	6/2/2014	watch spot	je	heavy rain 3 in		Southcenter channel pipe#2			0.35	over	11.6
98	6/2/2014	watch spot	je	heavy rain 3 in		Southeast channel (ledge) pipe#3			0.07	over	2.3
99	6/2/2014	watch spot	je	heavy rain 3 in		Southeast source (ledge) pipe#4			0.18	over	6
100	6/2/2014	watch spot	je	heavy rain 3 in		Tursky valley pipe #5			0.38	over	12.6