NC0003425_Worksheets_20160101

1/18/2017 10:24:48
12
393

393

0
12

2.2999999999999998
47

8/23/2014
1000
500

8/24/2014
1000
500

8/25/2014
1000
500
12

8/26/2014
1000
500
6

5/14/2015
13.8
13.8
25

11/17/2015
6.15
6.15
12.5

5/14/2015
0.5
0.5
5.2

11/16/2015
0.63200000000000001
0.63200000000000001

252.63525000000001

2014
2015

8
0

252.63525000000001
5.2

500
13.8

47

12

12

Date
Total Mercury 1631E PQL = 0.5 ng/L
Modifier
Value
Data Entry
Permitted Flow =
7Q10s =
cfs
MGD
WQBEL =
ng/L
Facility Name
MERCURY WQBEL/TBEL EVALUATION
WQS =
You can only enter data in the light blue cells
2) all the same year date/values must be group together with no gaps or other year dates separating the dates , but not necessarily in date order
4) once date/data entries are complete click on
WQS =
n/gL
WATER QUALITY STANDARD
Follow directions in message box
REQUIRED DATA FOR WQBEL
Entry must be a number = or greater than 0
Entry must be a number greater than 0
CALCULATE ANNUAL AVERAGE
Enter facility name, NPDES #, etc
3) if you copy/paste data from another spreadsheet be sure to use the special paste and check the value box
6) you may add addition/correct data at anytime and/or re-calculate the annual calendar average by repeating steps
AUTO MESSAGES/COMPARISONS TO "WQBEL" AND "TBEL"
MISSING DATE
"INCORRECT ENTRY" ALERT BOX
Alert box appears for entries that do match required entry format, follow directions in box
NO Permitted Flow and/or 7Q10s DATA
No Limit Required
Alert message displays as long as no entries for "7Q10S" and "Permitted Flow" have been accepted to calculate the "WQBEL"
Annual Limit 47 ng/L with Quartertly Monitoing
Annual Limit
(WQBEL
) ng/L with Quartertly Monitoing
Alert message displays when entries have been accepted to calculate the "WQBEL" and the calculated annual calendar average completed , and "WQBEL" is required by guidance
Alert message displays when entries have been accepted to calculate the "WQBEL" and the calculated annual calendar average completed , and 47 ng/L ("TBEL") is required by guidance
Alert message displays when entries have been accepted to calculate the "WQBEL" and the calculated annual calendar average completed , and no "WQBEL" or "TBEL" is required by guidance
> TBEL
WQBEL <
Alert message display adjacet (left) to the calculated annual calendar average when all entries have been accepted, annual calendar averages completed, and that annual average exceeds
"WQBEL"
MISCELLANEOUS FEATURES
The "PQL" , 0.5 ng/L, and the "TBEL", 14 ng/L, are set as defined, you cannot change these values.
When you desire to print out a copy of the "Evaluation" you can click on this button. The print area is determined based on the amount of data that has been accepted and is displayed
accordingly. Any additional change can be made or the "Evaluation" printed as supported by the review page.
YOU SHOULD NOT REMOVE THE "PROTECT" FROM THE SPREADSHEET AS THE FEATURES CAN BE COMPROMISED AND THE EVALUATION RESULTS INVALID.
INFORMATION
The calculated "WQBEL" value appears in its designated cell once all the required entries have been accepted.
Alert message displays as long as no entries made for "Data Entry" but entries have been accepted for "7Q10S and "Permitted Flow"
Alert message display adjacet (right) to the "Value" when entry for a "Data Entry" and "Date" have been accepted and that "Value" exceeds "TBEL"
You may be prompt to follow a certain format or limited to certain values
5) the annual calendar average is calculated based on all that years "Value" and displayed with a label defining the appliacble calendar year adjacent to last date enterted for that
year
<
1) each "Date"
(mm/dd/yy)
must be entered with the corresponding "Modifier"
(<blank> or <
) and "Data Entry"
(number greater than 0)
, see "
MISCELLANEOUS FEATURES
" for more details
When a value accepted into a "Data Entry" cell, its is checked against the "PQL" and the "Modifier" (<blank>, < ) and adjusted as follows:
Any value accepted = or less than 1.0 ng/L or greater than 0.5 ng/L with a "Modifier" of <, or any value accepted less than 0.5 ng/L will be adjusted to a"Value" = 0.5 ng/L. Any value
accepted greater than 1.0 ng/L with a "Modifier" of < will be adjusted to a "Value" = 1/2 of the "Data Entry" value. Any value accepted greater than 0.5 ng/L with a "Modifier" of
"<blank>" will be assigned the "Data Entry" value.
???
Facility Name:
Alert appears in "Value" cell when the adjacent "Data Entry" entry accepted but "Modifier" is not <blank> or <

Alert appears adjacent to the "Value" cell when "Data Entry" entry accepted but has no corresponding "Date"
Fresh water HQW/ORW = 6 ng/L
Fresh water = 12 ng/L
Salt water = 25 ng/L
Salt water HQW/ORW = 12.5 ng/L
V:2013-5
# of Samples
Annual Average, ng/L
Maximum Value, ng/L
WQBEL, ng/L
TBEL, ng/L
Mercury Data Statistics (Method 1631E)
ng/L - Annual Average for 2012
ng/L - Annual Average for 2013
ng/L - Annual Average for 2014
ng/L - Annual Average for 2015
Roxboro Outfall 001
2015 Average

EVALUATE
PRINT DATA REVIEW
PRINT TABLE REVIEW

EVALUATE
PRINT REVIEW