| SampleIDa |
Water Works/Sample
description/Coagulant dose concentration |
Month |
Calibration method |
M1aPeak Absorbance
@ 690 nm |
M2Peak
Area @ 690 nm |
M3Ratio of peak absorbances
(A690nm/A520nm) |
“M1 and M2”
combined data |
| ObservedConca (µg/L) |
Observed% RSD |
ObservedConc (µg/L) |
Observed% RSD |
ObservedConc (µg/L) |
Observed% RSD |
Calculated MeanConc (µg/L) |
Calculated
SD(µg/L) |
Calculated
%RSD |
| 4R |
Wiggins: raw |
May |
3.16 |
7.09 |
4.21 |
4.83 |
38.2 |
1.03 |
3.69 |
0.74 |
20.15 |
| 5R |
Wiggins: raw |
May |
4.23 |
10.8 |
3.73 |
15.1 |
nda |
0.92 |
3.98 |
0.35 |
8.88 |
| Mean |
|
|
3.70 |
|
3.97 |
|
38.20 |
|
|
|
|
| SD |
|
|
0.76 |
|
0.34 |
|
|
|
|
|
|
| % RSD |
|
|
20.48 |
|
8.55 |
|
|
|
|
|
|
| 6F |
Wiggins: potable |
May |
9.14 |
3.90 |
10.30 |
3.82 |
65.30 |
1.26 |
9.72 |
0.82 |
8.44 |
| 7F |
Wiggins: potable |
May |
1.38 |
2.35 |
1.11 |
26.10 |
64.60 |
1.76 |
1.25 |
0.19 |
15.33 |
| 8F |
Wiggins: potable |
May |
2.38 |
2.03 |
2.58 |
7.37 |
55.60 |
0.40 |
2.48 |
0.14 |
5.70 |
| Mean |
|
|
4.30 |
|
4.66 |
|
61.83 |
|
|
|
|
| SD |
|
|
4.22 |
|
4.94 |
|
5.41 |
|
|
|
|
| % RSD |
|
|
98.17 |
|
105.86 |
|
8.75 |
|
|
|
|
| 9B |
Wiggins: raw: Jar test |
May |
12.70 |
6.62 |
11.00 |
6.46 |
nd |
3.01 |
11.85 |
1.20 |
10.14 |
| 10B |
Wiggins: raw: Jar test |
May |
7.84 |
5.25 |
8.61 |
3.01 |
28.20 |
0.58 |
8.23 |
0.54 |
6.62 |
| Mean |
|
|
10.27 |
|
9.81 |
|
28.20 |
|
|
|
|
| SD |
|
|
3.44 |
|
1.69 |
|
|
|
|
|
|
| % RSD |
|
|
33.46 |
|
17.24 |
|
|
|
|
|
|
| 11O |
Wiggins raw:Jar test: optimal dose |
May |
22.70 |
7.86 |
21.30 |
7.34 |
nd |
3.61 |
22.00 |
0.99 |
4.50 |
| 12O |
Wiggins raw:Jar test: optimal dose |
May |
17.21 |
|
|
|
|
|
17.21 |
|
|
| 13O |
Wiggins/ optimal dose |
May |
14.10 |
3.01 |
19.10 |
1.50 |
nd |
3.01 |
16.60 |
3.54 |
21.30 |
| Mean |
|
|
18.00 |
|
20.20 |
|
|
3.31 |
|
|
|
| SD |
|
|
4.35 |
|
1.56 |
|
|
0.42 |
|
|
|
| % RSD |
|
|
24.19 |
|
7.70 |
|
|
12.82 |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| 14 |
Wiggins raw:Jar test;30% overdose |
May |
1.90 |
|
|
|
|
|
1.90 |
|
|
| 15 |
Wiggins raw:Jar test: 60% overdose |
May |
0.29 |
16.00 |
0.47 |
31.30 |
54.30 |
0.37 |
0.38 |
0.12 |
32.92 |
| 16 |
Wiggins raw:Jar test: 100% overdose |
May |
2.79 |
11.70 |
4.17 |
21.70 |
nd |
2.39 |
3.48 |
0.98 |
28.04 |
| 20R |
Wiggins: raw |
June |
3.60 |
4.34 |
4.11 |
9.75 |
48.20 |
0.98 |
3.86 |
0.36 |
9.35 |
| 20F |
Wiggins: potable |
June |
0.713 |
3.39 |
1.53 |
2.04 |
15.3 |
0.38 |
1.12 |
0.58 |
51.51 |
| 21B |
Wiggins: raw:Jar test |
June |
5.12 |
12.60 |
5.59 |
5.60 |
40.50 |
3.45 |
5.36 |
0.33 |
6.21 |
| 22B |
Wiggins: raw:Jar test |
June |
1.49 |
4.90 |
1.95 |
5.20 |
22.70 |
0.17 |
1.72 |
0.33 |
18.91 |
| Mean |
|
|
3.31 |
|
3.77 |
5.40 |
31.60 |
|
|
|
|
| SD |
|
|
2.57 |
|
2.57 |
0.28 |
12.59 |
|
|
|
|
| % RSD |
|
|
77.66 |
|
68.27 |
5.24 |
39.83 |
|
|
|
|
| 230 |
Wiggins: raw:Jar test: optimal |
June |
0.53 |
8.90 |
0.64 |
15.00 |
13.20 |
0.44 |
0.58 |
0.08 |
14.15 |
| 24 |
Wiggins: raw:Jar test: 30% overdose |
June |
3.64 |
8.10 |
4.41 |
2.72 |
42.80 |
1.01 |
4.03 |
0.54 |
13.53 |
| 25 |
Wiggins: raw:Jar test: 30% overdose |
June |
4.77 |
1.20 |
5.88 |
1.17 |
47.30 |
0.65 |
5.33 |
0.78 |
14.74 |
| 26 |
Wiggins: raw: Jar test: 30% overdose |
June |
1.78 |
5.09 |
2.16 |
8.85 |
30.90 |
5.46 |
1.97 |
0.27 |
13.64 |
| Mean |
|
|
3.40 |
|
4.15 |
4.25 |
40.33 |
|
|
|
|
| SD |
|
|
1.51 |
|
1.87 |
4.06 |
8.47 |
|
|
|
|
| % RSD |
|
|
44.45 |
|
45.15 |
95.63 |
21.01 |
|
|
|
|
| 27 |
Wiggins: raw:Jar test: 60% overdose |
June |
5.65 |
0.48 |
7.35 |
0.07 |
35.60 |
0.50 |
6.50 |
1.20 |
18.49 |
| 28 |
Wiggins: raw:Jar test:100% overdose |
June |
1.61 |
5.82 |
0.72 |
1.70 |
11.90 |
1.03 |
1.17 |
0.63 |
53.77 |
| |
|
|
|
|
|
|
|
|
|
|
|
| 32R |
|
July |
3.93 |
7.19 |
4.00 |
7.57 |
47.20 |
0.97 |
3.97 |
0.05 |
1.25 |
| 32F |
|
July |
1.27 |
4.27 |
1.80 |
0.22 |
9.44 |
0.73 |
1.54 |
0.37 |
24.41 |
| 33B |
Wiggins: raw:Jar test |
July |
5.51 |
0.63 |
7.21 |
1.79 |
54.20 |
0.80 |
6.36 |
1.20 |
18.90 |
| 34B |
Wiggins: raw:Jar test |
July |
12.90 |
4.84 |
12.00 |
7.20 |
44.10 |
2.73 |
12.45 |
0.64 |
5.11 |
| Mean |
|
|
9.21 |
|
9.61 |
|
49.15 |
|
|
|
|
| SD |
|
|
5.23 |
|
3.39 |
|
7.14 |
|
|
|
|
| % RSD |
|
|
56.77 |
|
35.26 |
|
14.53 |
|
|
|
|
| 350 |
Wiggins optimal |
July |
1.08 |
8.09 |
0.41 |
19.50 |
7.85 |
1.12 |
0.75 |
0.47 |
63.32 |
| 36 |
Wiggins 30% overdose |
July |
1.12 |
4.15 |
1.19 |
24.40 |
6.44 |
1.89 |
1.16 |
0.05 |
4.29 |
| 37 |
Wiggins 60% overdose |
July |
2.48 |
2.51 |
3.53 |
1.24 |
9.58 |
0.39 |
3.01 |
0.74 |
24.71 |
| 38 |
Wiggins 60% overdose |
July |
0.19 |
12.00 |
0.74 |
4.01 |
9.71 |
0.17 |
0.46 |
0.39 |
83.45 |
| 39 |
Wiggins 60% overdose |
July |
3.11 |
4.46 |
5.18 |
2.99 |
8.03 |
1.20 |
4.15 |
1.46 |
35.31 |
| Mean |
|
|
1.93 |
|
3.15 |
|
9.11 |
|
|
|
|
| SD |
|
|
1.54 |
|
2.25 |
|
0.93 |
|
|
|
|
| % RSD |
|
|
79.76 |
|
71.32 |
|
10.26 |
|
|
|
|
| 40 |
Wiggins 100% overdose |
July |
2.70 |
2.52 |
2.16 |
6.52 |
10.20 |
1.26 |
2.43 |
0.38 |
15.71 |
| 1R |
DV Harris: raw |
May |
6.79 |
7.15 |
6.61 |
7.72 |
nd |
2.08 |
6.70 |
0.13 |
1.90 |
| 1F |
DV Harris: potable |
May |
1.85 |
8.84 |
2.34 |
12.00 |
17.20 |
0.95 |
2.10 |
0.35 |
16.54 |
| 17R |
DV Harris: raw |
June |
5.48 |
2.93 |
8.14 |
0.79 |
5.32 |
2.39 |
6.81 |
1.88 |
27.62 |
| 17F |
DV Harris: potable |
June |
0.99 |
33.00 |
2.71 |
2.43 |
12.20 |
0.28 |
1.85 |
1.22 |
65.85 |
| 29R |
DV Harris: raw |
July |
18.10 |
9.70 |
18.90 |
8.92 |
62.00 |
6.20 |
18.50 |
0.57 |
3.06 |
| 29F |
DV Harris: potable |
July |
0.82 |
5.52 |
0.40 |
6.57 |
13.40 |
0.40 |
0.61 |
0.30 |
49.07 |
| 2R |
Hazelmere: raw |
May |
1.43 |
2.06 |
2.30 |
0.41 |
23.30 |
0.33 |
1.87 |
0.62 |
32.99 |
| 2F |
Hazelmere: potable |
May |
2.70 |
7.91 |
4.20 |
7.67 |
15.80 |
1.36 |
3.45 |
1.06 |
30.74 |
| 18R |
Hazelmere: raw |
June |
17.25 |
0.95 |
23.80 |
0.69 |
52.20 |
0.83 |
20.53 |
4.63 |
22.57 |
| 18F |
Hazelmere potable |
June |
0.22 |
34.10 |
0.67 |
16.50 |
10.70 |
0.40 |
0.44 |
0.31 |
70.79 |
| 30R |
Hazelmere: raw |
July |
1.78 |
4.33 |
2.31 |
0.65 |
16.80 |
0.69 |
2.05 |
0.37 |
18.33 |
| 30F |
Hazelmere: potable |
July |
0.72 |
5.33 |
1.25 |
4.99 |
8.50 |
0.47 |
0.98 |
0.38 |
38.23 |
| 3R |
Durban Heights: raw |
May |
13.30 |
4.70 |
13.40 |
6.36 |
nd |
0.31 |
13.35 |
0.07 |
0.53 |
| 3F |
Durban Heights:potable |
May |
2.01 |
23.80 |
2.87 |
15.10 |
57.00 |
2.12 |
2.44 |
0.61 |
24.92 |
| 19R |
Durban Heights:potable |
June |
2.36 |
12.70 |
3.50 |
11.70 |
16.50 |
1.65 |
2.93 |
0.81 |
27.51 |
| 19F |
Durban Heights:potable |
June |
0.89 |
8.68 |
0.95 |
9.66 |
13.80 |
0.40 |
0.92 |
0.04 |
4.61 |
| 31R |
Durban Heights:raw |
July |
1.54 |
4.33 |
2.31 |
0.65 |
16.80 |
0.69 |
1.93 |
0.54 |
28.28 |
| 31F |
Durban Heights:potable |
July |
8.02 |
1.54 |
11.20 |
0.99 |
26.00 |
0.29 |
9.61 |
2.25 |
23.40 |
