ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Each spreadsheet tab should be a different school
4
Sampling locations should be entered in the order they are to be sampled
5
Sample locations should be numbered for each school starting at 001
6
If you want to designate additional bottles, add them to the bottom for each school as needed and label them as "SCHOOL_NAME_EXTRA_BOTTLE_1", etc. with sample type "OT"
7
If you use the extra bottles, make a note to yourself as to the location, and submit a request for sample location description changes using the sample description change form.
8
Link to Sample Description Change Form
9
If you do not use the extra bottles, write on the chain of custody "not sampled" in the Date/Time field and return the empty bottles to the lab.
10
11
12
13
14
15
16
17
18
DWDrinking Water Fountain
19
WBWater bottle filler
20
KFKitchen Faucet
21
KRKitchen Refrigerator
22
IMIce Machine
23
CFClassroom Faucet
24
NSNurse Office Sink
25
BFBathroom Faucet
26
KKCommercial Kitchen Kettle
27
OTOther
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