2018-19 MI [Data]

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	2018-2019 Creek Connections Water Quality Data
2	Michigan Schools (Site Numbers 400-499)
3	Data in squares that are shaded BLUE represent an unrealistic data number that needs to be confirmed or checked,
4	YELLOW if only one trial was done or if Sample A and B yielded very different results and a third trial was not completed for more accuracy,
5	or ORANGE if we spot an error for any other reason.
6	Please let us know the correction and we will remove the shading.
7	Site #	School	Date	Time	Temp. (deg C)	pH Meter	TDS (mg/L)	DO (mg/L)	NO3-N (mg/L)	P (mg/L)	Alk (mg/L)	Turb (JTU)	Conductivity (uS/cm)	pH Test Kit	WQI value	Weather (past 48 hr)	Creek Appearance	Stage (m)	Flow (m/s)	Discharge (m3/s)	Other tests

8	401	Allendale Public Schools, MI	4/19/2019	12:45 PM	9.0	N/A	220.0	10.0	0.94	0.04	119.0	0.0	242.50	6.5	21.00	Overcast, cool, with intermittent light rain over the night and throughout the day.	Clear water, deeper. Shaded upstream from wooded area.	0.3467	0.403	0.1397	Relative Depth- 0.3467 m
9	401	Allendale Public Schools, MI	3/15/2019	7:15 AM	10.0	N/A	178.5	11.0	0.85	0.08	127.5	90.0	350.00	7.8	32.05	Wednesday: cloudy, 45 F, 11 mph wind, 69% humanity, 20% precipitation, Thursday: sunny, 50 F, 9 MPH winds, 63% humidity, 10% precipitation.	Water was moving quickly and murky because of the heavy rains that we had received.	N/A	N/A	N/A	N/A
10	402	Allendale Public Schools, MI	4/19/2019	11:50 AM	8.5	N/A	220.0	10.5	0.80	0.06	110.5	0.0	445.50	7.5	11.60	Overcast, cool, with intermittent light rain over the night and throughout the day.	Water was clear, but deeper than previous times out in the field.	0.275	0.4286	0.117865	Relative Depth- 0.275 m
11	402	Allendale Public Schools, MI	3/15/2019	7:15 AM	11.0	N/A	169.0	9.5	0.75	0.21	119.0	80.0	350.50	6.8	36.05	Partly cloudy, rainy, stormy, mildly warm/humid	Water was cloudy and fast flowing	N/A	N/A	N/A	N/A
12	403	Allendale Public Schools, MI	4/19/2019	9:30 AM	8.0	NA	471.0	10.5	0.00	0.02	170.0	0.0	223.00	8.0	6.95	Overcast, cool, with intermittent light rain over the night and throughout the day.	Water was wider and deeper than it typically is; this is downstream from the diversion.	0.39	0.427	0.17	Relative Depth- 0.39 m
13	403	Allendale Public Schools, MI	3/15/2019	7:15 AM	11.0	N/A	177.0	9.5	1.00	0.06	170.0	40.0	344.50	7.5	22.20	Humid, windy, and rainy. Temp 37 degrees F	The stream had a high flow with very cloudy water due tothe heavy rains we've been getting	N/A	N/A	N/A	Relative Depth- 0.55 m
14	404	Allendale Public Schools, MI	4/19/2019	9:30 AM	7.0	NA	224.0	11.0	0.40	0.04	119.0	0.0	424.00	7.5	6.90	Overcast, cool, with intermittent light rain over the night and throughout the day.	Not as shallow as what is typically is due to rain and snow melt earlier this week.	0.346	0.478	0.1655	Relative Depth- 0.346 m
15	404	Allendale Public Schools, MI	3/15/2019	7:00 AM	12.0	N/A	183.0	9.5	0.98	0.07	76.5	70.0	340.50	7.5	28.20	Thundering, raining, sunny	Cloudy	N/A	N/A	N/A	Relative Depth- 0.76 m
16	405	Allendale Public Schools, MI	4/19/2019	8:30 AM	9.0	N/A	226.5	10.0	0.80	0.01	127.5	0.0	457.50	7.3	13.10	Overcast, cool, with intermittent light rain over the night and throughout the day.	Wide and deep from rain and snow melt earlier this week.	0.343	0.25	0.343	Relative Depth- 0.343 m
17	405	Allendale Public Schools, MI	3/15/2019	7:00 AM	11.5	N/A	182.0	10.5	1.00	0.08	85.0	45.0	344.00	7.5	22.85	Thunder Storm light rain	very cloudy	N/A	N/A	N/A	Relative depth- 0.58 m
18	406	Allendale Public Schools, MI	4/19/2019	7:45 AM	11.0	N/A	222.5	7.0	0.68	0.27	119.0	2.5	442.50	7.8	18.41	Overcast, cool, with intermittent light rain over the night and throughout the day.	Clear water, but the water levels were much higher from snow melt and rain a few days ago	0.3475	0.1795	0.062387	Relative Depth- 0.3475 m
19	406	Allendale Public Schools, MI	3/15/2019	6:45 AM	11.5	N/A	170.5	14.0	1.00	0.01	132.0	42.5	335.00	7.8	20.81	heavy rain for 2 days	muddy banks, tall brown grass	N/A	N/A	N/A	Relative Depth-0.6 m
20															70.00
21															70.00
22															70.00
23															70.00
24															70.00
25															70.00
26															70.00
27															70.00
28															70.00
29															70.00
30															70.00
31															70.00
32															70.00
33															70.00
34															70.00
35															70.00
36															70.00
37															70.00
38															70.00
39															70.00
40															70.00
41															70.00
42															70.00
43															70.00
44															70.00
45															70.00
46															70.00
47															70.00
48															70.00
49															70.00
50															70.00
51															70.00
52															70.00
53															70.00
54															70.00
55															70.00
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