2023-24 MI [Data]

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	2023-2024 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)	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	9/8/2023	1:50:00 PM	20.0	248	10.5	0.62	0.10	187.0	0.0	496.50	7.0	14.30	Rainy yesterday	Clean	0.07	0.1	0.007
9	401	Allendale Public Schools, MI	10/27/2023	7:43:00 AM	16.0	216	8.5	0.54	0.06	119.0	5.0	430.00	7.0	15.35	Heavy rain at times	Clear but moving quickly	0.11	0.3003	0.033	relative depth = 0.11
10	401	Allendale Public Schools, MI	11/17/2023	8:45:00 AM	12.0	290	9.0	0.70	0	170.0	0.0	576.00	7.8	12.70	Spotty Rain	Clear	0.098	0.234	0.0229	relative depth = 0.098 m
11	401	Allendale Public Schools, MI	12/8/2023	1:30:00 PM	10.9	270	10.2	0.75	0.02	136.0	5.0	549.50	7.7	13.26	Cloudy, a little bit of percipation on Wednesday	Clear, faster moving	0.11	0.16	0.0176	relative depth = 0.11
12	401	Allendale Public Schools, MI	2/15/2024	8:45:00 AM	8.0	595	10.5	0.05	0.17	144.5	5.0	798.50	6.75	12.65	Warm, but a cold front moved in and a mix of precipitation has begun with lake effect snow	Fast moving but clear.	0.097	0.2577	0.025	relative depth = 0.097
13	402	Allendale Public Schools, MI	9/8/2023	1:50:00 PM	20.0	576	11.0	0.65	0.09	229.5	0.0	287.50	7.3	12.15	Rain	Clean	0.07	0.1	0.07	relative depth = 0.07
14	402	Allendale Public Schools, MI	10/27/2023	1:30:00 PM	18.0	218	8.0	0.55	0.05	102.0	5.0	430.50	7.5	11.70	Spotty down pours	Clear water	0.08	0.339	0.0271	relative depth = 0.08
15	402	Allendale Public Schools, MI	11/17/2023	9:00:00 AM	12.0	270	9.0	0.72	0.00	136.0	0.0	540.50	7.0	14.90	Spotty Rain	Clear	0.11	0.253	0.0278	relative depth = 0.11
16	402	Allendale Public Schools, MI	12/8/2023	12:30:00 PM	13.6	277	11.0	0.81	0.00	110.5	0.0	565.33	8.0	14.40	Cool, overcast, with a little precip on Wednesday morning.	Clear and faster moving	0.175	0.2	0.035	relative depth = 0.175
17	402	Allendale Public Schools, MI	2/15/2024	9:50:00 AM	8.0	274	11.0	0.95	0.04	119.0	10.0	559.00	7.5	14.40	Warm, but then a cold front moved in. Mixed precipitation was falling while pulling the samples.	Water was clear and running nice.	0.11	0.279	0.03	relative depth = 0.11
18	403	Allendale Public Schools, MI	9/8/2023	12:30:00 AM	21.0	340	10.0	0.30	0.21	163.0	22.5	647.00	7.3	15.65	Rained yesterday	slow and muddy	0.12	0.1	0.012	relative depth = 0.012
19	403	Allendale Public Schools, MI	10/27/2023	12:30:00 PM	19.0	201	9.5	0.72	0.11	136.0	0.0	402.00	7.5	12.25	Spotty down pours	Still slow moving but clearer than usual.	0.1	0.0414	0.0041	relative depth = 0.1
20	403	Allendale Public Schools, MI	11/17/2023	9:50:00 AM	13.0	268	8.0	0.96	0.07	119.0	5.0	536.00	7.5	16.10	Spotty rain	Slow and cloudier than upstream of diversion	0.124	0.179	0.0222	relative depth = 0.124
21	403	Allendale Public Schools, MI	12/8/2023	11:30:00 AM	10.5	253	8.5	0.99	0.00	170.0	7.5	542.50	7.8	17.45	cloudy, little precipitation	cloudy, little movement	0.12	0	0	relative depth = 0.12
22	403	Allendale Public Schools, MI	2/15/2024	11:15:00 AM	8.0	288	10.5	0.59	0.21	68.0	0.0	576.00	7.0		Warm, but then a cold front moved in. Mixed precipitation was falling while pulling the samples.	Water was moving faster than what this study site usually is.	0.09	0.1	0.009	relative depth = 0.09
23	404	Allendale Public Schools, MI	9/8/2023	11:30:00 AM	21.0	254	8.0	0.50	0.23	221.0	0.0	509.00	7.5	12.80	Rain yesterday	Slow with clear water	0.12	0.2	0.024	relative depth = 0.406
24	404	Allendale Public Schools, MI	10/27/2023	11:25:00 AM	18.0	405	8.0	0.66	0.33	136.0	5.0	632.50	7.5	16.91	Times of heavy down pours	Fast moving water upstream, but then gets slow and cloudy	0.105	0.241	0.0253	relative depth = 0.105
25	404	Allendale Public Schoold, MI	11/17/2023	1:30:00 AM	12.0	268	8.0	0.00	0.00	119.0	5.0	543.00	8.3	11.40	Spotty rain	Water was running fast but was clear	0.084	0.19	0.016	relative depth = 0.084
26	404	Allendale Public Schoold, MI	12/8/2023	9:50:00 AM	6.9	283	10.3	0.12	0.02	153.0	5.0	581.30	8.0	9.30	light rain Wednesday	deeper mid channel- and cloudy	0.105	0.4	0.042	relative depth = 0.105
27	404	Allendale Public Schools, MI	2/15/2024	12:15:00 PM	8.0	615	11.5	0.97	0.02	102.0	0.0	878.50	7.3	13.94	Warm, but then a cold front moved in. Mixed precipitation was falling while pulling the samples.	Water was clear and running fast.	0.13	0.1968	0.025584	relative depth = 0.13
28	405	Allendale Public Schools, MI	9/8/2023	9:50:00 AM	20.0	550	9.0	0.72	0.07	187.0	5.0	789.00	7.0	17.00	rain yesterday	Slow moving but clear	0.176	0.1	0.0176	relative depth = 0.176
29	405	Allendale Public Schools, MI	10/27/2023	9:45:00 AM	18.0	216	10.0	0.98	0.03	153.0	10.0	421.50	8.0	19.30	Spotty down pours of rain.	Clear"ish", but slightly more turbid water.	0.22	0.0879	0.0193	relative depth = 0.22
30	405	Allendale Public Schools, MI	11/19/2023	12:30:00 PM	16.0	288	8.0	0.28	0.03	119.0	5.0	576.00	8.0	12.70	Cool and a little rain	Clear	0.145	0.187	0.0271	relative depth = 0.145
31	405	Allendale Public Schools, MI	12/8/2023	8:50:00 AM	9.0	283	11.0	0.42	0.03	127.5	2.5	570.00	7.8	9.50	mild	Flowing muddy banks.	0.13	0.1	0.013	relative depth = 0.13
32	405	Allendale Public Schools, MI	2/15/2024	1:45:00 PM	8.0	605	9.0	0.60	0.05	102.0	0.0	859.50	7.5	10.45	Warm, but then a cold front moved in. Mixed precipitation was falling while pulling the samples.	Clear	0.147	0.2058	0.0303	relative depth = 0.147
33	406	Allendale Public Schools, MI	9/8/2023	8:50:00 AM		242	9.5	0.32	0.03	187.0	10.0	470.00	7.8	10.95	rain yesterday	low flowing	0.13	0.2	0.026	relative depth = 0.24
34	406	Allendale Public Schools, MI	10/27/2023	8:45:00 AM	18.5	206	9.0	0.15	0.12	170.0	20.0	406.00	8.3	16.95	Off and on periods of heavy rain	Fast and a little cloudy	0.165	0.3115	0.0514	relative depth = 0.165
35	406	Allendale Public Schools, MI	11/17/2023	1:40:00 PM	13.0	289	10.0	1.00	0.04	170.0	0.0	585.00	8.0	17.60	A little bit of rain the night before	clear	0.1	0.347	0.0347	relative depth = 0.1
36	406	Allendale Public Schools, MI	2/15/2024	7:45:00 AM	8.0	289	10.0	0.92	0.16	187.0	0.0	576.00	7.0	18.60	Warm, but a cold front moved in and a mix of precipitation has begun with lake effect snow	Clear water	0.12	0.25	0.03	relative depth = 0.12
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