Water Test Results Summary Diamond 2020.xlsx

	A	B	C	D	E	F	G	H
1	Lead in Water Test Results Summary:		Diamond Elementary School
2	Notes:
3	• The lead in water Action Level is 15 parts per billion (ppb).
4	Any fixture testing at or above the action level of 15 ppb is immediately removed from service and cannot be returned to service until it has been remediated and passed follow-up testing.
5	• A "ND" or "non-detect" test result indicates the sample measured below the minimum detection limit of 2 ppb.
6	Legend:
7	• Test results greater than or equal to the Action Level of 15 ppb are highlighted in red and precede an "Action Req." (Action Required) value in the "Initial Level" or "Final Level" column.
8	• Test results from 12 ppb to 14.99 ppb (near the Action Level) are highlighted in orange and precede a "High" value in the "Initial Level" or "Final Level" column.
9	• Test results from 5 ppb to 11.99 ppb are highlighted in yellow and precede a "Moderate" value in the "Initial Level" or "Final Level" column.
10	• Test results less than 5 ppb are not highlighted and precede a "Low" value in the "Initial Level" or "Final Level" column.
11	Fixture Location Description	Fixture ID #	Initial Test Date	Initial Test Result (ppb)	Initial Level	Final Retest Date	Final Test Result (ppb)	Final Level
12	Main Bulding	[enter ID #]	[enter date]	[enter result]	[autofill]	[enter date]	[enter result]	[autofill]
13	School Building Classroom sink	20170100-001CF	9/27/2019	ND	Non-Detect
14	School Building Water Fountain	20170100-002DW	9/27/2019	ND	Non-Detect
15	School Building Girls Bathroom	20170100-003BF	9/27/2019	ND	Non-Detect
16	School Building Boys Bathroom	20170100-004BF	9/27/2019	ND	Non-Detect
17	School Building Kitchen	20170100-005KF	9/27/2019	ND	Non-Detect
18
19	Gymnasium
20	Gymnasium Kitchen Sink	20170101-001KF	9/27/2019	4	Low
21	Gymnasium Girls Bathroom	20170101-002BF	9/27/2019	ND	Non-Detect
22	Gymnasium Boys Bathroom	20170101-003BF	9/27/2019	13	High
23
24	Teacherage
25	Teacherage Kitchen Sink	20170102-001KF	9/27/2019	ND	Non-Detect
26	Teacherage East Bathroom Sink	20170102-002BF	9/27/2019	3	Low
27	Teacherage West Bathroom Sink	20170102-003BF	9/27/2019	ND	Non-Detect
28
29
30
31
32
33
34
35
36
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