2016 Water Quality Data

	A	B	C	D	E
1		5/17/2016	5/18/2016	5/19/2016	2015-16 Averages

2	Per1G3DO	8.9	8.9	9.6
3	Per1G4DO	9.2	5.9	6.7
4	Averages!	9.05	7.4	8.15	8.2
5
6	Per1G3pH	6.6	6.6	7.33
7	Per1G11-12	6.13	6.22	6.27
8	Averages!	6.365	6.41	6.8	6.525
9
10	Per1G1-2TempAir	56.6	54.1	52.7
11	Per1G4TempAir	56.6	55.4	52.2
12	Per1G7-8TempAir	56.6	54.1	52.7
13	Per1G9TempAir	54.7	54.1	52.3
14	Average in F	56.125	54.425	52.475	54.34166667
15	Average in C	13.40277778	12.45833333	11.375	12.41203704
16
17	Per1G1-2TempH2O	51.4	55.1
18	Per1G4TempH2O	51.4	55.1	52.3
19	Per1G7-8TempH2O	51.4	55.1	52.2
20	Per1G9TempH2O	51.3	55.1	52.3
21	Average in F	51.375	55.1	52.26666667	52.91388889
22	Average in C	10.76388889	12.83333333	11.25925926	11.61882716
23
24	Per1G11-12Turb (Clear)	15.4	12.8	12.5	12.5
25	Per1G11-12Turb (Cloudy)	275.8	135.9	108.4
26
27
28	Per1G10FlowRateSlow	0.272		0.259
29	Convert m/s to m3/s	0.27608		0.262885
30	Convert m3/s to gallons/s	72.93262012		69.44686989	71.189745
31
32	Per1G10FlowRateFast			0.266
33	Convert m/s to m3/s			0.26999
34	Convert m3/s to gallons/s			71.32381232	71.32381232
35
36
37
38	Per2G61-2DO
39	Per2G7-8DO	9.8	9.8	10.8
40	Per2G12DO
41	Averages!	9.8	9.8	10.8	10.13333333
42
43	Per2G6pH
44	Averages!	#DIV/0!	#DIV/0!	#DIV/0!
45
46	Per2G4TempAir	62.9	60.3	58.5
47	Per2G5TempAir
48	Per2G11TempAir
49	Average in F	62.9	60.3	58.5	60.56666667
50	Average in C	17.16666667	15.72222222	14.72222222	15.87037037
51
52	Per2G4TempH2O	53.4	56	53.7
53	Per2G5TempH2O	52.88	53.78	52.88
54	Per2G11TempH2O
55	Average in F	53.14	54.89	53.29	53.77333333
56	Average in C	11.74444444	12.71666667	11.82777778	12.0962963
57
58	Per2G3Turb (Clear)	0		27.2	13.6
59	Per2G3Turb (Cloudy)
60
61	Per2G9-10FlowRateSlow	0.312	0.318	0.319
62	Convert m/s to m3/s	0.31668	0.32277	0.323785
63	Convert m3/s to gallons/s	83.65800543	85.26681322	85.53494786	84.81992217
64
65	Per2G9-10FlowRateFast	0.343	0.342	0.352
66	Convert m/s to m3/s	0.348145	0.34713	0.35728
67	Convert m3/s to gallons/s	91.97017904	91.70204441	94.38339074	92.68520473
68
69
70
71	Per3G3DO
72	Per3G4DO
73	Per3G9DO	9.5	9.4	9.3
74	Averages!	9.5	9.4	9.3	9.4
75
76	Per3G1pH	6.5	6.58	6.28
77	Per3G2pH
78	Per3G7pH	6.25	6.11	6.24
79	Per3G11pH	5.94	6.74
80	Averages!	6.095	6.425	6.24	6.253333333
81
82	Per3G5TempAir		65.1	59.9
83	Per3G6TempAir		65.1	59.9
84	Per3G10TempAir
85	Average in F		65.1	59.9	62.5
86	Average in C		18.38888889	15.5	16.94444444
87
88	Per3G5TempH2O		57	56.3
89	Per3G6TempH2O		57	56.3
90	Per3G10TempH2O
91	Average in F		57	56.3	56.65
92	Average in C		13.88888889	13.5	13.69444444
93
94	Per3G12Turb (Clear)	-14.5	-14	1.2	-9.1
95	Per3G12Turb (Cloudy)	39	36	51.2
96
97	Per3G8FlowRateSlow	0.569	0.319	0.347
98	Convert m/s to m3/s	0.577535	0.323785	0.352205
99	Convert m3/s to gallons/s	152.5686061	85.53494786	93.04271757	110.3820905
100