Lake James Watershed VWIN Data to share

	A	B	C	D	E	F	G	H	I
1	This spreadsheet is subject to updates. Please download to explore the data on your own.
2	Data can be filtered by site number or site name. The most recent data are at the bottom of the spreadsheet.
3
4	Orange or yellow highlighted cells indicate high results.
5	*Results marked with strikethroughs are less than the lab reporting limit (see below). Any results less than the reporting limit are considered estimated.
6
7	Column Heading	Description	Units	*Reporting Limit	2018-20 Regional VWIN Average	2018-20 Pristine VWIN Average	NC Regulatory Limits	Analysis Method	Notes
8	site #	VWIN site number
9	site name	VWIN site name
10	month	month of sample collection
11	day	day of sample collection
12	year	year of sample collection
13	NH3-N	ammonia-nitrogen	mg/L	0.02	0.08	0.04	n/a	SM 4500 NH3 C-2011
14	NO3-N	nitrate/nitrite-nitrogen	mg/L	0.1	0.5	0.2	10.0 mg/L nitrate only	Cadmium reduction
15	Total P	total phosphorus (as PO4)	mg/L	0.02	n/a	n/a	n/a	SM 4500 P E-2011	to calculate total phosphorus as P, divide by results by 3.07
16	PO4	orthophosphate (as PO4)	mg/L	0.02	0.08	0.04	n/a	SM 4500 P E-2011
17	Turb	turbidity	NTU	1.0	6.0	2.1	50 NTU for aquatic life, 10 NTU for Trout Waters	SM 2130 B-2011
18	TSS	total suspended solids	mg/L	10.0	7.9	2.8	n/a	SM 2540 D-2011
19	Cond	conductivity	umhos/cm	10.0	77.7	19.7	n/a	SM 2510 B-2011
20	Alk	alkalinity	mg/L	1.0	22.2	9.5	n/a	Methyl orange titration
21	pH	pH	s.u.	n/a	7.2	7.0	allowable limit 6.0-9.0	SM 4500 H+B-2011
22	volunteer comments	observations provided by volunteers
23	present weather conditions	subjective categories for volunteer observations
24	amt rain last 3 days	subjective categories for volunteer observations
25	flow/water level	subjective categories for volunteer observations
26	water clarity	subjective categories for volunteer observations
27	water color	subjective categories for volunteer observations
28	water surface	subjective categories for volunteer observations
29	water odor	subjective categories for volunteer observations
30	trash	subjective categories for volunteer observations
31	Cu	copper	ug/L	2.0	n/a	n/a			discontinued metals analysis in 2010
32	Zn	zinc	ug/L	20.0	n/a	n/a			discontinued metals analysis in 2010
33	Pb	lead	ug/L	2.0	n/a	n/a			discontinued metals analysis in 2010
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