5 Year Report Raw Data File _ReadOnly.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	City	Survey Date	Rainfall last 24 hr in	Site ID	YSI Dupe	Expected Flow Rate	Air Temp °C	Water Temp °C	Temp Difference °C	DO mg/l	pH	Turbidity ntu	SPC uS/cm	E. coli cfu/100ml	Odor	Visual	Color	Observation Notes	Threshold Code	Salinity ppt	Flow Rate	Turbidity ntu Dupe	E. coli cfu/100ml Dupe	E. coli cfu/100ml Rep

2	Anacortes	01/10/2021	0.03	B03-1001	NO		8	8.8	0.8	11.64	7.05	1.6	225.4				3		OT		Moderate
3	Anacortes	02/07/2021	0.2	B03-1001	NO		7	8.1	1.1	11.71	7.3	1.65	228.3				3		OT		Moderate
4	Anacortes	03/05/2021	0.03	B03-1001	NO		10	8.5	-1.5	12.09	7.48	1.82	250.3						OT		Moderate
5	Anacortes	03/05/2021	0.03	B03-1001	NO		10	8.5	-1.5	12.09	7.48	1.82	250.3						OT		Moderate
6	Anacortes	04/03/2021	0	B03-1001	NO		13	11	-2	11.26	6.82	2.33	222.6						OT		Moderate
7	Anacortes	05/02/2021	0	B03-1001	NO		13	13.9	0.9	10.28	6.53	2.5	1093				3		OT	0.55	Moderate
8	Anacortes	05/30/2021	0	B03-1001	NO		16	16	0	9.57	6.89	0.96	2722						OT		Moderate
9	Anacortes	06/28/2021	0	B03-1001	NO		31	18.6	-12.4		7.22	1.49	5493						OT		Moderate
10	Anacortes	01/17/2022	0.28	B03-1001	NO		6	7.2	1.2	12.84	6.522	2.71	134.4						OT		High
11	Anacortes	04/20/2022	0	B03-1001	NO		10	11	1	9.3	7.66	2.53	581						OT		Moderate
12	Anacortes	11/25/2022		B03-1001	NO		5	9.9	4.9	10.42	7.4	3	302				3		OT		Moderate
13	Anacortes	02/18/2023		B03-1001	NO		6	7	1	12.5	6.9	2	151						OT		Moderate
14	Anacortes	03/02/2023		B03-1001	NO		6	7	1	10	4.4	24.3	141						OT		High
15	Anacortes	04/24/2023	0	B03-1001	NO		12	11	-1	12.2	6.74	9.24	391	0					OT	0.19	Moderate
16	Anacortes	05/05/2023		B03-1001	NO		9	13	4	11.45	5.9	42.7	87.6						OT	0.04	High
17	Anacortes	06/10/2023	0.37	B03-1001	NO		12	14.4	2.4	9.35	6.5	28.3	515	9999				no rcard scan, cannot recount	OT	0.25	Moderate
18	Anacortes	06/13/2023		B03-1001	NO									52					OT		Present		0
19	Anacortes	06/19/2023		B03-1001	NO									2					OT		Present
20	Anacortes	06/20/2023		B03-1001	NO		15	16.3	1.3	8.1	7.3	14.6	1203	36					OT	0.6	Trickle
21	Anacortes	08/19/2023	0	B03-1001	NO		17	18.2	1.2	8	7.9	0.82	2223	3					OT	1.14	Trickle
22	Anacortes	08/29/2023		B03-1001	NO		14		-14	13	6.6	21	1127	2					OT	0.56	Trickle
23	Anacortes	09/13/2023		B03-1001	NO		18	17.8	-0.2	9.05	7.4	3.7	2214	0					OT	1.14	Trickle		0
24	Anacortes	09/28/2023		B03-1001	NO		12	16	4	9.5	7.1	8.4	259						OT	0.12	High
25	Anacortes	10/16/2023		B03-1001	NO														OT		None
26	Anacortes	02/29/2024	0.68	B03-1001	NO		5	7.8	2.8	11.25	7.1	3.3	210.2	33	0	0	3		OT	0.1	Moderate
27	Anacortes	04/25/2024	0.28	B03-1001	no	Normal	11.6	13.3	1.7	10.63	6.65	19.5	83.9	2897	0	0	1	light tan	OT	0.04	High
28	Anacortes	04/27/2024		B03-1001	NO									1166					OT		Present
29	Anacortes	07/09/2024	0	B03-1001	NO		28.3	19.1	-9.2	9.5	7.85	0	2176	0	0	0	0		OT	1.12	Moderate
30	Anacortes	08/27/2024	0.78	B03-1001	NO		11	18	7	9.25	7.6	3.12	256	133	0	0	0		OT	0.12	High
31	Anacortes	09/27/2024	0.13	B03-1001	NO	Normal	19.8	17	-2.8	8.96	7.9	1.56	347	166	0	0	0		OT	0.17	Moderate		100
32	Anacortes	11/26/2024	0.03	B03-1001	NO	Higher	4	10	6	10.8	7.6	20.3	245	0	0	0	3	amber	OT	0.12	High
33	Anacortes	12/10/2024	0	B03-1001	NO	Higher	5	9.2	4.2	11.9	7.6		218.5	33	0	0	3	Color intensely amber, No turbidity reading, meter broken	OT	0.1	High
34	Anacortes	01/08/2025	0.07	B03-1001	NO	Higher	8	8.8	0.8	12.17	6.8		217.5	33	0	0	2	buff color	OT	0.1	High		33
35	Anacortes	02/19/2025	0.16	B03-1001	no	Normal	9	8	-1	12.4	7.5	5.1	232	0	0	0	3	dark amber	OT	0.11	High
36	Anacortes	04/12/2025	0	B03-1001	no	Normal	11	11.9	0.9	12.28	7.9	2.2	232.7	0	0	0	3	amber color	OT	0.11	High
37	Anacortes	05/17/2025	0.28	B03-1001	no	Normal	11	15	4	8.2	7.5	5.7	211	67	0	0	1	faint rust color	OT	0.1	Moderate
38	Anacortes	06/01/2025	0.08	B03-1001	no	Normal	14	16	2	9	7.8	0	1135	100	0	0	0		OT	0.6	High
39	Anacortes	07/24/2025	0	B03-1001	no	Lower	21	17.3	-3.7	6.5	7.9	0	8356	167	0	0	0		OT	4.65	Trickle
40	Anacortes	08/17/2025	0	B03-1001	no	Normal	20	18	-2	8.7	7.6	3.6	2820	67	0	0	1	very light beige	OT	1.5	Moderate	4.3	33
41	Anacortes	10/04/2025	0.01	B03-1001	no	Normal	18	16	-2	7.9	7.95	3.06	1833	100	0	0	0		OT	0.94	Moderate
42	Anacortes	10/18/2025	0	B03-1001	no	Normal	11	14.2	3.2	9.96	7.7	2	1460	133	0	0	0		OT	0.74	Moderate	0.9	166
43	Anacortes	03/05/2021	0.03	B03-1001-MH	NO		10	8.5	-1.5	11.83	7.45		222.8								Storm Drain
44	Anacortes	01/10/2021	0.03	B04-1001	NO														OT		None
45	Anacortes	02/07/2021	0.2	B04-1001	NO				-7										OT		None
46	Anacortes	03/05/2021	0.03	B04-1001	NO														OT		None
47	Anacortes	04/03/2021	0	B04-1001	NO														OT		None
48	Anacortes	05/02/2021	0	B04-1001	NO														OT		None
49	Anacortes	06/28/2021	0	B04-1001	NO														OT		None
50	Anacortes	03/16/2023		B04-1001	NO														OT		None
51	Anacortes	03/24/2025	0.55	B04-1001	no							17.55		0	0	0	2	cloudy	OT		High	15.31	33
52	Anacortes	01/10/2021	0.03	B04-1002	NO		8	8.9	0.9	10.74	7.26	3.87	4003				2		OT		Moderate
53	Anacortes	02/07/2021	0.2	B04-1002	NO		7	8.3	1.3	10.9	7.26	4.09	2871						OT		Moderate
54	Anacortes	03/06/2021	0	B04-1002	NO		10	9	-1	11.23	7.37	3.73	5973						OT		Trickle
55	Anacortes	04/16/2025	0	B04-1002	no	Normal	50	11.8	-38.2	10.72	7.52	7.19	88.31	0	0	0	0		OT	4.95	Moderate
56	Anacortes	05/16/2025	0.22	B04-1002	no	Normal	5.5	13	7.5	9.22	7.19	0	13665	133	0	0	0		OT	7.93	Moderate
57	Anacortes	06/23/2025	0	B04-1002	no	Normal	11.67	13.7	2.03	9.08	7.32	1.65	23499	67	0	0	0		OT	14.26	Moderate		67
58	Anacortes	07/26/2025	0	B04-1002	no	Normal	10	14.3	4.3	7.65	7.14	0.68	35602	0	0	0	0		OT	22.48	Moderate
59	Anacortes	08/22/2025	0	B04-1002	no	Normal	22	14.4	-7.6	7.08	7.14	1.44	33101	0	0	0	0	small amount of sediment in bucket	OT	20.8	Moderate	2.96	67
60	Anacortes	03/05/2021	0.03	B04-1002-MH	NO		10	8.7	-1.3	11.69	7.57	4.96	438.6								Storm Drain
61	Anacortes	05/19/2021	0.18	B04-1002-MH	NO		12	14.1	2.1	9.62	6.46	3.1	275								Storm Drain
62	Anacortes	01/10/2021	0.03	B04-1003	NO														OT		None
63	Anacortes	02/07/2021	0.2	B04-1003	NO		7		-7										OT		None
64	Anacortes	03/05/2021	0.03	B04-1003	NO														OT		None
65	Anacortes	04/03/2021	0	B04-1003	NO														OT		None
66	Anacortes	05/02/2021	0	B04-1003	NO														OT		None
67	Anacortes	06/28/2021	0	B04-1003	NO														OT		None
68	Anacortes	10/28/2022		B04-1003	NO														OT		None
69	Anacortes	11/18/2022		B04-1003	NO														OT		None
70	Anacortes	03/16/2023		B04-1003	NO														OT		None
71	Anacortes	02/29/2024	0.68	B04-1003	NO														OT		None
72	Anacortes	05/16/2025	0.22	B04-1003	no	Normal													OT		None
73	Anacortes	06/23/2025	0	B04-1003	no														OT		None
74	Anacortes	07/26/2025	0	B04-1003	no														OT		None
75	Anacortes	08/22/2025	0	B04-1003	no														OT		None
76	Anacortes	03/24/2025	0.55	B04-1003	no										0	0	0	ran out of sample bottles	OT		Moderate
77	Anacortes	02/04/2021	0.28	B04-1004-MH	NO		6	7.8	1.8	11.64	7.25	5.83	200.7								Moderate
78	Anacortes	01/10/2021	0.03	B11-1001	NO		8	9.1	1.1	11.07	7.73	3.61	4135				2		OT		Moderate
79	Anacortes	02/07/2021	0.2	B11-1001	NO		7	8.7	1.7	11.3	7.2	3.96	3982						OT		Moderate
80	Anacortes	03/05/2021	0.03	B11-1001	NO		10	8	-2	11.45	7.6	3.32	15464						OT		Trickle
81	Anacortes	03/05/2021	0.03	B11-1001	NO		10	8	-2	11.45	7.6	3.32	15464						OT		Trickle
82	Anacortes	03/05/2021	0.03	B11-1001-MH	NO		10	8.3	-1.7	11.59	7.59	4.42	3342								Storm Drain
83	Anacortes	05/19/2021	0.18	B11-1001-MH	NO		12	14.3	2.3	9.86	6.26	5.52	186								Storm Drain
84	Anacortes	02/04/2021	0.28	B11-1006-MH	NO		6	7.4	1.4	12.03	7.08	6.4	128.1								Moderate
85	Anacortes	01/11/2021	0.4	F01-1001	NO		8.8	9.2	0.4	10.43	6.81	3.34	756						OT		Moderate
86	Anacortes	01/24/2021	0.15	F01-1001	NO		8	7.1	-0.9	11.33	7.02	8.38	900						OT		Moderate
87	Anacortes	02/08/2021	0	F01-1001	NO														OT		None
88	Anacortes	03/05/2021	0.03	F01-1001	NO		10	9.5	-0.5	9.59	7.13	3.27	2861						OT		Moderate
89	Anacortes	03/07/2021	0.05	F01-1001	NO		8	9.2	1.2	9.23	7.16	2.43	2157						OT		Moderate
90	Anacortes	11/03/2022		F01-1001	NO		3.9	13.6	9.7	8.84	7.49	3.4	1093						OT		Moderate
91	Anacortes	11/04/2022		F01-1001	NO							13.5							OT		Present
92	Anacortes	06/10/2023	0.37	F01-1001	NO		12	15.9	3.9	8.25	7.2	15.9	985	264					OT	0.49	High
93	Anacortes	06/13/2023		F01-1001	NO									202					OT		High
94	Anacortes	06/20/2023		F01-1001	NO		15	16.1	1.1	7.25	7.3	8.4	1704	546					OT	0.87	High
95	Anacortes	08/19/2023	0	F01-1001	NO		17	18.6	1.6	8.11	7.5	7.41	1684	185					OT	0.86	High		74
96	Anacortes	08/29/2023		F01-1001	NO		14		-14	10.5	7.28	6.6	1086	393					OT	0.54	High
97	Anacortes	09/01/2023		F01-1001	NO									4					OT		Present		28
98	Anacortes	09/28/2023		F01-1001	NO		13	16.8	3.8	8.8	7.1	25.3	530						OT	0.26	High
99	Anacortes	10/16/2023		F01-1001	NO														OT		None
100	Anacortes	02/29/2024	0.68	F01-1001	NO		6	8.3	2.3	10.75	7.1	2.9	476	2131	0	0	1		OT	0.23	High