NC0004987_Worksheets - Outfall 005_20220514 (2)

Dissolved Metals & Hardness Determination
v. 5/27/2010
I. How to Determine Hardness for use with Dissolved Freshwater Standards for Permitting Purposes
HARDNESS - Use 25 mg/L, expressed as CaCO3 or Ca+Mg, as the default Hardness
OR
To determine a Hardness value for permit
limit development, use the following equation:
Hardness (Hardness instream(a), mg/L * 7Q10, MGD)+(Hardness effluent(b), mg/L* Plant flow, MGD)
(mass balance)
(7Q10, MGD + Plant flow, MGD)
(a) Use the median instream Hardness value of the ambient 8-digit HUC data collected by the Division of Water Quality. To find the 8-digit HUC hardness value for your facility Click Here.
(b) For the purpose of this estimation, use the facility's median effluent Hardness value, if available. The Division will request the permittee to sample effluent hardness once/month and submit one to two years of data with the permit renewal application. If no effluent hardness data is submitted, a default of 25 mg/L will be applied.
II. To Develop Dissolved Metal concentrations for permitting purposes use the Freshwater Standards for Hardness Dependent Metals listed in Table A below.
Table A: Dissolved Freshwater Standards for Hardness Dependent Metals
Metal
pg/L
Cadmium, Acute
{1.136672-[In hardness](0.041838)} • e^{0.9151 [In hardness]-3.1485}
Cadmium, Acute (Trout Waters)
{1.136672-[In hardness](0.041838)} • e^{0.9151[In hardness]-3.6236}
Cadmium, Chronic
{1.101672-[In hardness](0.041838)} • e^{0.7998[In hardness]-4.4451}
Chromium III, Acute
0.316 • e^{0.8190[In hardness]+3.7256}
Chromium III, Chronic
0.860 • e^{0.8190[In hardness]+0.6848}
Copper, Acute
0.960 • e^{0.9422[In hardness]-1.700}
Copper, Chronic
0.960 • e^{0.8545[In hardness]-1.702}
Lead, Acute
{1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-1.460}
Lead, Chronic
{1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-4.705}
Nickel, Acute
0.998 • e^{0.8460[In hardness]+2.255}
Nickel, Chronic
0.997 • e^{0.8460[In hardness]+0.0584}
Silver, Acute
0.85 • e^{1.72[In hardness]-6.59}
Silver, Chronic
Not applicable
Zinc, Acute
0.978 • e^{0.8473[In hardness]+0.884}
Zinc, Chronic
0.986 • e^{0.8473[In hardness]+0.884}
Complete information on all the proposed Surface Water Quality Standards can be viewed at: http://h2o.enr.state.nc.us/csu/trirev SW.html.

US EPA Translators
using Default Partition Coefficients (DPC)
Translator equation using Default Partition Coefficients =
1
v. 6/2/2010
[1 + (Kpo * TSS (l+a) * 10-6)1
Kpo and a are constants that express the equilibrium relationship between dissolved and adsorbed forms of metals.
A default value of 10 mg/L Total Suspended Solids (TSS) will be used.
Table A contains the Default Partition Coefficients for the equation.
Table B contains the calculated translators using the default partition coefficients for streams.
TABLE A. Default Partition Coefficients
STREAMS
Metal (1)
Kpo
a
Cu
1.04E+06
-0.7436
Zn
1.25E+06
-0.7038
Pb
2.80E+06
-0.8
Cr (III) (2)
3.36E+06
-0.09304
Cd
4.00E+06
-1.1307
Ni
4.90E+05
-0.5719
(1) Delos, C.G., et al. Technical Guidance for Performing Waste Load Allocations. Book II: Streams and Rivers. Chapter 3: Toxic Substances, For the U.S. EPA. (EPA-440/4-84-022)
(2) Linear partition coefficients shall not apply to the Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefore,
TABLE B. US EPA Translators
PARAMETER
US EPA Translators
Using stream Default Partition Coefficients
TSS = 10 mg/L
Cadmium
0.252
Chromium III
0.202
Chromium VI
1
Chromium, Total
N/A
Copper
0.348
Lead
0.184
Nickel
0.432
Silver
1
Zinc
0.288
Example for Cadmium (streams)
Given:
TSS = 10 mg/L
Kpo = 4.00E + 06
a =-1.1307
Translator = 1
[1 + (Kpo * TSS (1-')* 10 6)]
[1 + (4.00x106 * 101-1.1307) * 10-6)]
[1+2.960465]
= 0.252

Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
MAXIMUM DATA POINTS = 58
REQUIRED DATA ENTRY
Table 1. Project Information
❑ CHECK IF HQW OR ORW WQS
Facility Name
WWTP/WTP Class
NPDES Permit
Outfall
Flow, Qw (MGD)
Receiving Stream
Marshall Steam Station
C
I
NC0004987
Outfall 005
5.100
Lake Norman
8 Digit HUC Number
03010103
Stream Class
WS-IV
0 Apply WS Hardness WQC
7Q10s (cfs)
7Q1Ow (cfs)
30Q2 (cfs)
QA (cfs)
1 Q10s (cfs)
60.00
60.00
60.00
C
60.00
I
I
49.15
Effluent Hardness (Median)
HUC Hardness (Median)
Combined Hardness Chronic
Combined Hardness Acute
25 mg/L
default 25 mg/L (HUC Hard Med = 21.5 mg/L)
25 mg/L
25 mg/L
Data Source(s)
Renewal Application and DMRs
CHECK TO APPLY MODEL
CHECK WQS
Table 2. Parameters of Concern
Par01
Par02
Par03
Par04
Par05
Par06
Par07
Par08
Par09
Par10
Par11
Par12
Par13
Par14
Par15
Par16
Par17
Par18
Par19
Par20
Par21
Par22
Par23
Par24
Name
WQS
Type
Chronic Modifier
Acute
PQL Units
Arsenic
Aquactic Life
C
150
FW
340
ug/L
Arsenic
Human Health
Water Supply
C
10
HH/WS
N/A
ug/L
Beryllium
Aquatic Life
NC
6.5
FW
65
ug/L
Cadmium
Aquatic Life
NC
0.5899
FW
3.2396
ug/L
Chlorides (AL)
Aquatic Life
NC
230
FW
Chlorinated Phenolic Compounds
Water Supply
NC
1
A
ug/L
yTotal Phenolic Compounds
Aquatic Life
NC
300
A
ug/L
Chromium III
Aquatic Life
NC
117.7325
FW
905.0818
ug/L
Chromium VI
Aquatic Life
NC
11
FW
16
pg/L
Chromium, Total
Aquatic Life
NC
N/A
FW
N/A
pg/L
Copper (AL)
Aquatic Life
NC
7.8806
FW
10.4720
ug/L
Cyanide
Aquatic Life
NC
5
FW
22
10
ug/L
Fluoride
Aquatic Life
NC
1,800
FW
ug/L
Lead
Aquatic Life
NC
2.9416
FW
75.4871
ug/L
Mercury
Aquatic Life
NC
12
FW
0.5
ng/L
Molybdenum
Human Health
NC
2000
HH
ug/L
Nickel
Aquatic Life
NC
37.2313
FW
335.2087
pg/L
Nickel
Water Supply
NC
25.0000
WS
N/A
pg/L
Selenium
Aquatic Life
NC
5
FW
56
ug/L
Silver (AL)
Aquatic Life
NC
0.06
FW
0.2964
ug/L
Zinc (AL)
Aquatic Life
NC
126.7335
FW
125.7052
ug/L
Aluminum
Water Supply
NC
6500
WS
pg/L
Boron
Water Supply
NC
7
WS
mg/L
Sulfate
Water Supply
NC
250
WS
mg/L
NC0004987_Worksheets_20220414 (3).xlsm, input
4/18/2022

REASONABLE POTENTIAL ANALYSIS
H
Effluent Hardness (monthly average)
Date Data BDL=1/2DL Results
1 25 25 Std Dev.
2 Mean
3 C.V.
4 n
5 10% value
6 Median Value
7 Max. Value
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par01 & Par02
Arsenic
N/A
25.0000
0.0000
1
25.00 mg/L
25.00 mg/L
25.00 mg/L
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev.
2 < 1 0.5 Mean
3 < 1 0.5 C.V.
4 < 1 0.5 n
5 < 1 0.5
6 < 1 0.5
7 < 1 0.5
8 < 1 0.5
9 < 1 0.5
10 < 1 0.5
11 < 1 0.5
12 < 1 0.5
13 < 1 0.5
14 < 1 0.5
15 < 1 0.5
16 < 1 0.5
17 < 1 0.5
18 < 1 0.5
19 < 1 0.5
20 < 1 0.5
21 < 1 0.5
22 < 1 0.5
23 < 1 0.5
24 < 1 0.5
25 < 1 0.5
26 < 1 0.5
27 < 1 0.5
28 < 1 0.5
29 < 1 0.5
30 < 1 0.5
31 < 1 0.5
32 < 1 0.5
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
0.0000
0.5000
0.0000
32
Mult Factor = 1.00
Max. Value 0.5 ug/L
Max. Pred Cw 0 DETECTS ug/L
NC0004987_Worksheets_20220414 (3).xlsm, data
- 3 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
Par03
Beryllium
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev.
2 Mean
3 C.V.
4 n
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par04
Cadmium
N/A
0.5000
0.0000
1
Mult Factor = 1.00
Max. Value 0.50 ug/L
Max. Pred Cw 0 DETECTS ug/L
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev.
2 < 1 0.5 Mean
3 < 1 0.5 C.V.
4 < 1 0.5 n
5 < 1 0.5
6 < 1 0.5
7 < 1 0.5
8 < 1 0.5
9 < 1 0.5
10 < 1 0.5
11 < 1 0.5
12 < 1 0.5
13 < 1 0.5
14 < 1 0.5
15 < 1 0.5
16 < 1 0.5
17 < 1 0.5
18 < 1 0.5
19 < 1 0.5
20 < 1 0.5
21 < 1 0.5
22 < 1 0.5
23 < 1 0.5
24 < 1 0.5
25 < 1 0.5
26 < 1 0.5
27 < 1 0.5
28 < 1 0.5
29 < 1 0.5
30 < 1 0.5
31 < 1 0.5
32 < 1 0.5
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
0.0000
0.5000
0.0000
32
Mult Factor = 1.00
Max. Value 0.500 ug/L
Max. Pred Cw 0 DETECTS ug/L
NC0004987_Worksheets_20220414 (3).xlsm, data
- 4 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
Par05
Chlorides (AL)
Date Data
5.9
7.3
7.9
150
600
510
850
510
470
500
510
560
550
150
480
53
140
230
320
300
280
120
140
630
490
770
110
71
370
430
180
310
BDL=1/2DL Results
5.9 Std Dev.
7.3 Mean
7.9 C.V.
150 n
600
510 Mult Factor =
850 Max. Value
510 Max. Pred Cw
470
500
510
560
550
150
480
53
140
230
320
300
280
120
140
630
490
770
110
71
370
430
180
310
Use "PASTE SPECIAL -
Values" then "COPY" .
Maximum data points =
58
Par06
Chlorinated Phenolic Compounds
231.0116
337.7
0.6842
32
1.2
850.0 mg/L
1,020.0 mg/L
Date Data BDL=1/2DL Results
1 Std Dev.
2 Mean
3 C.V.
4 n
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
NO DATA
NO DATA
NO DATA
0
Mult Factor = N/A
Max. Value N/A
Max. Pred Cw N/A
NC0004987_Worksheets_20220414 (3).xlsm, data
- 5 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par07
Total Phenolic Compounds
Date Data BDL=1/2DL Results
1 < 1.6 0.8 Std Dev.
2 Mean
3 C.V.
4 n
5
6
ug/L 7
ug/L 8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
N/A
0.8000
0.0000
1
Mult Factor = 1.00
Max. Value 0.8 ug/L
Max. Pred Cw 0 DETECTS ug/L
Par08
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Date Data BDL=1/2DL Results
1 Std Dev. NO DATA
2 Mean NO DATA
3 C.V. NO DATA
4 n 0
5
6 Mult Factor = N/A
7 Max. Value N/A
8 Max. Pred Cw N/A
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Chromium III
NC0004987_Worksheets_20220414 (3).xlsm, data
- 6 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par09
Chromium VI
Date Data BDL=1/2DL Results
1 Std Dev.
2 Mean
3 C.V.
4 n
5
6 Mult Factor =
fag/L 7 Max. Value
fag/L 8 Max. Pred Cw
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par10
Chromium, Total
NO DATA
NO DATA
NO DATA
0
N/A
N/A fag/L
N/A fag/L
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev.
2 < 1 0.5 Mean
3 < 1 0.5 C.V.
4 < 1 0.5 n
5 < 1 0.5
6 < 1 0.5 Mult Factor =
7 < 1 0.5 Max. Value
8 < 1 0.5 Max. Pred Cw
9 < 1 0.5
10 1.28 1.28
11 < 1 0.5
12 < 1 0.5
13 < 1 0.5
14 < 1 0.5
15 < 1 0.5
16 < 1 0.5
17 < 1 0.5
18 < 1 0.5
19 < 1 0.5
20 < 1 0.5
21 < 1 0.5
22 < 1 0.5
23 < 1 0.5
24 < 1 0.5
25 < 1 0.5
26 < 1 0.5
27 < 1 0.5
28 < 1 0.5
29 < 1 0.5
30 < 1 0.5
31 < 1 0.5
32 < 1 0.5
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
Use "PASTE SF
Values" then "
. Maximum c
points = 5
0.1379
0.5244
0.2630
32
1.08
1.3
1.4
NC0004987_Worksheets_20220414 (3).xlsm, data
- 7 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Pal 1
Copper (AL)
Date Data BDL=1/2DL Results
1 2.74 2.74 Std Dev.
2 2.18 2.18 Mean
3 1.32 1.32 C.V.
4 1.67 1.67 n
5 3.8 3.8
6 1.56 1.56 Mult Factor =
fag/L 7 3.2 3.2 Max. Value
fag/L 8 3.46 3.46 Max. Pred Cw
9 2.28 2.28
10 2.95 2.95
11 2.24 2.24
12 1.24 1.24
13 2.37 2.37
14 1.8 1.8
15 1.69 1.69
16 1.8 1.8
17 3.38 3.38
18 2.45 2.45
19 2.41 2.41
20 1.91 1.91
21 4.44 4.44
22 1.89 1.89
23 2.39 2.39
24 2.52 2.52
25 3.18 3.18
26 2 2
27 2.39 2.39
28 2.88 2.88
29 2.4 2.4
30 2.94 2.94
31 4.02 4.02
32 2.6 2.6
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
0.7717
2.5031
0.3083
32
1.09
4.44 ug/L
4.84 ug/L
Par12
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Date Data BDL=1/2DL Results
1 19 19 Std Dev. N/A
2 Mean 19.00
3 C.V. 0.0000
4 n 1
5
6 Mult Factor = 1.00
7 Max. Value 19.0
8 Max. Pred Cw 19.0
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Cyanide
NC0004987_Worksheets_20220414 (3).xlsm, data
- 8 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par13
Fluoride
1
2
3
4
5
6
ug/L 7
ug/L 8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Date Data BDL=1/2DL
200
200
210
480
1300
1100
500
1100
500
1000
1300
1200
1600
1100
1200
180
480
640
1100
800
700
250
250
1100
1100
1200
500
250
500
1200
500
900
200
200
210
480
1300
1100
< 1000
1100
< 1000
1000
1300
1200
1600
1100
1200
180
480
640
1100
800
700
< 500
< 500
1100
1100
1200
< 1000
< 500
< 1000
1200
500
900
Results
Std Dev.
Mean
C.V.
n
Mult Factor =
Max. Value
Max. Pred Cw
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par14
Lead
417.0403
770.0000
0.5416
32
1.16
1600.0 ug/L
1856.0 ug/L
Date Data BDL=1/2DL
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
0.5
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Results
Std Dev. 0.0000
Mean 0.5000
C.V. 0.0000
n 32
Mult Factor = 1.00
Max. Value 0.500
Max. Pred Cw 0 DETECTS
NC0004987_Worksheets_20220414 (3).xlsm, data
- 9 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par15
Mercury
Date Data BDL=1/2DL Results
1 1.28 1.28 Std Dev.
2 2.14 2.14 Mean
3 2.19 2.19 C.V.
4 1.18 1.18 n
5 1.59 1.59
6 < 0.5 0.25 Mult Factor =
ug/L 7 < 0.5 0.25 Max. Value
ug/L 8 0.667 0.667 Max. Pred Cw
9 1 1
10 1.72 1.72
11 < 2 1
12 2.14 2.14
13 1.89 1.89
14 2 2
15 1.14 1.14
16 0.759 0.759
17 1.23 1.23
18 0.717 0.717
19 0.67 0.67
20 2.33 2.33
21 < 0.5 0.25
22 < 0.5 0.25
23 0.888 0.888
24 0.98 0.98
25 0.536 0.536
26 < 2 1
27 0.764 0.764
28 0.765 0.765
29 0.84 0.84
30 1.03 1.03
31 1.31 1.31
32 < 0.5 0.25
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par16
Molybdenum
0.6215
1.0939
0.5682
32
1.17
2.3 ng/L
2.7 ng/L
Date Data BDL=1/2DL Results
1 8840 8840 Std Dev.
2 Mean
3 C.V.
4 n
5
6 Mult Factor =
7 Max. Value
8 Max. Pred Cw
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Use "PASTE SF
Values" then "
. Maximum c
points = 5
N/A
8840.0000
0.0000
1
1.00
8840.0
8840.0
NC0004987_Worksheets_20220414 (3).xlsm, data
- 10 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
iata
;8
Par17 & Par18
Nickel
Date Data BDL=1/2DL Results
1 21.0 21 Std Dev.
2 8.3 8.3 Mean
3 11.0 11 C.V.
4 5.7 5.67 n
5 23.4 23.4
6 24.9 24.9 Mult Factor =
ug/L 7 9.9 9.93 Max. Value
ug/L 8 13.5 13.5 Max. Pred Cw
9 7.1 7.13
10 4.0 3.98
11 11.2 11.2
12 3.7 3.67
13 6.7 6.68
14 14.1 14.1
15 11.3 11.3
16 5.0 5.02
17 6.5 6.53
18 5.9 5.85
19 4.7 4.73
20 3.0 2.95
21 16.0 16
22 19.4 19.4
23 5.4 5.35
24 4.98 4.98
25 33.5 33.5
26 8.87 8.87
27 10.7 10.7
28 10.1 10.1
29 5.6 5.6
30 4.67 4.67
31 2.69 2.69
32 2.71 2.71
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
Use "PASTE SPECIAL• Par19
Values" then "COPY"
. Maximum data
points = 58
Selenium
7.3685
10.1691
0.7246
32
1.22
33.5 fag/L
40.9 fag/L
Date Data BDL=1/2DL Results
1 1.38 1.38 Std Dev.
2 4.05 4.05 Mean
3 1.72 1.72 C.V.
4 2.99 2.99 n
5 5.32 5.32
6 3.95 3.95 Mult Factor =
7 3.43 3.43 Max. Value
8 2.7 2.7 Max. Pred Cw
9 2.62 2.62
10 2.58 2.58
11 4.48 4.48
12 3.24 3.24
13 2.86 2.86
14 2.6 2.6
15 2.9 2.9
16 1.6 1.6
17 2.71 2.71
18 1.92 1.92
19 1.67 1.67
20 1.38 1.38
21 1.4 1.4
22 1.04 1.04
23 1.5 1.5
24 1.93 1.93
25 7.74 7.74
26 2.2 2.2
27 1.84 1.84
28 2.46 2.46
29 1.76 1.76
30 < 1 0.5
31 1 1
32 1.12 1.12
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
NC0004987_Worksheets_20220414 (3).xlsm, data
- 11 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par20
Silver (AL)
1.4450
2.5184
0.5738
32
1.17
7.7 ug/L
9.1 ug/L
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev.
2 < 1 0.5 Mean
3 < 1 0.5 C.V.
4 < 1 0.5 n
5 < 1 0.5
6 < 1 0.5
7 < 1 0.5
8 < 1 0.5
9 < 1 0.5
10 < 1 0.5
11 < 1 0.5
12 < 1 0.5
13 < 1 0.5
14 < 1 0.5
15 < 1 0.5
16 < 1 0.5
17 < 1 0.5
18 < 1 0.5
19 < 1 0.5
20 < 1 0.5
21 < 1 0.5
22 < 1 0.5
23 < 1 0.5
24 < 1 0.5
25 < 1 0.5
26 < 1 0.5
27 < 1 0.5
28 < 1 0.5
29 < 1 0.5
30 < 1 0.5
31 < 1 0.5
32 < 1 0.5
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par21
Zinc (AL)
0.0000
0.5000
0.0000
32
Mult Factor = 1.00
Max. Value 0.500 ug/L
Max. Pred Cw 0 DETECTS ug/L
Date Data BDL=1/2DL Results
1 81.7 81.7 Std Dev.
2 52.7 52.7 Mean
3 19.7 19.7 C.V.
4 53.8 53.8 n
5 122 122
6 27.9 27.9 Mult Factor =
7 17.8 17.8 Max. Value
8 15.5 15.5 Max. Pred Cw
9 20.2 20.2
10 16 16
11 37.5 37.5
12 24.9 24.9
13 27.8 27.8
14 49.8 49.8
15 19.6 19.6
16 19.4 19.4
17 27.8 27.8
18 21.6 21.6
19 17.1 17.1
20 23.6 23.6
21 35 35
22 49.7 49.7
23 26.3 26.3
24 28 28
25 98.1 98.1
26 49.3 49.3
27 49.7 49.7
28 44.7 44.7
29 38.7 38.7
30 28 28
31 14.5 14.5
32 13 13
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
NC0004987_Worksheets_20220414 (3).xlsm, data
- 12 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par22
Aluminum
24.8999
36.6063
0.6802
32
1.20
122.0 ug/L
146.4 ug/L
Date Data BDL=1/2DL Results
1 127 127 Std Dev.
2 Mean
3 C.V.
4 n
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par23
Boron
N/A
127.0000
0.0000
1
Mult Factor = 1.00
Max. Value 127.000000 fag/L
Max. Pred Cw 127.000000 fag/L
Date Data BDL=1/2DL
1 7.92 7.92
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
NC0004987_Worksheets_20220414 (3).xlsm, data
- 13 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
Results
Std Dev.
Mean
C.V.
n
Mult Factor =
Max. Value
Max. Pred Cw
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par24
Sulfate
N/A
7.9200
0.0000
1
1.00
7.920000 mg/L
7.920000 mg/L
Date Data BDL=1/2DL Results
1 140 140 Std Dev.
2 100 100 Mean
3 150 150 C.V.
4 99 99 n
5 310 310
6 280 280
7 330 330
8 160 160
9 150 150
10 150 150
11 210 210
12 210 210
13 230 230
14 160 160
15 240 240
16 65 65
17 140 140
18 130 130
19 130 130
20 130 130
21 140 140
22 130 130
23 88 88
24 200 200
25 260 260
26 280 280
27 94 94
28 110 110
29 140 140
30 160 160
31 79 79
32 120 120
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
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par25
Barium
69.3190
166.0938
0.4173
32
Mult Factor = 1.13
Max. Value 330.000000 mg/L
Max. Pred Cw 372.900000 mg/L
Date Data BDL=1/2DL
1 0.049 0.049
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
NC0004987_Worksheets_20220414 (3).xlsm, data
- 14 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
Results
Std Dev.
Mean
C.V.
n
Mult Factor =
Max. Value
Max. Pred Cw
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
N/A
0.0490
0.0000
1
1.00
0.049000 mg/L
0.049000 mg/L
NC0004987_Worksheets_20220414 (3).xlsm, data
- 15 - 4/18/2022

Marshall Steam Station
NC0004987
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
MAXIMUM DATA POINTS = 58
Qw (MGD) = 5.10
1 Q 10S (cfs) = 49.15
7Q 1 OS (cfs) = 60.00
7Q 1 OW (cfs) = 60.00
30Q2 (cfs) = 60.00
Avg. Stream Flow, QA (cfs) = 60.00
Receiving Stream: Lake Norman HUC 03010103
WWTP/WTP Class:
IWC% @ 1 Q 10S = 13.85505214
IWC% @ 7Q 10S = 11.64126353
IWC% @ 7Q 1 OW = 11.64126353
IWC% @ 30Q2 = 11.64126353
IW%C @ QA = 11.64126353
Stream Class: WS-IV
Outfall Outfall 005
Qw = 5.1 MGD
COMBINED HARDNESS (mg/L)
Acute = 25 mg/L
Chromic = 25 mg/L
YOU HAVE DESIGNATED THIS RECEIVING
STREAM AS WATER SUPPLY
Effluent Hard:0 val > 100 mg/L 0 val < 25 mg/L
Effluent Hard Med = 25 mg/L
PARAMETER
TYPE
(1)
STANDARDS & CRITERIA (2)
_1
a
N
H
Z
m
REASONABLE POTENTIAL RESULTS
RECOMMENDED ACTION
NC WQS / Applied 1/2 FAV /
Chronic Standard Acute
n # Det. Max Pred Cw Allowable Cw
Arsenic
Arsenic
C
C
150 FW(7Q10s) 340
10 FIH/WS(Qavg)
ug/L
ug/L
32 0
NO DETECTS
Acute (FW): 2,454.0
_ _ __ ___
Chronic (FW)_1,288.5
Max MDL= 1_________
Chronic (HH): 85.9
Max MDL = 1
no limit
____________________________
____________________________
Beryllium
NC
6.5 FW(7Q10s) 65
ug/L
1 0
Note: n < 9
Limited data set
NO DETECTS
Acute: 469.14
_ _ _ _ _ _ _ _ _ _ _ _
Chronic: 55.84
Max MDL = 1
no limit
____________________________
Cadmium
NC
0.5899 FW(7Q10s) 3.2396
ug/L
32 0
NO DETECTS
Acute: 23.382
-- _ _ _ _
Chronic: ---- 5.067 --
Max MDL = 1
no limit
---—-—-—-—-—-—-—-—-—-— - — - — -—
Chlorides (AL)
NC
230 FW(7Q10s)
mg/L
32 32
1,020.0
Acute: NO WQS
Chronic:----1,975.7--
No value > Allowable Cw
no limit
----------------------------
Chlorinated Phenolic Compounds
NC
1 A(30Q2)
ug/L
0 0
N/A
Acute: NO WQS
-- Ch_ _
ronic: - — - —- 8.6---
n/a
-- - — - — - — - — - — - — - — - — - — - — - — - — - —
Total Phenolic Compounds
NC
300 A(30Q2)
ug/L
1 0
Note: n < 9
Limited data set
NO DETECTS
Acute: NO WQS
Chronic:----2,577.0--
Max MDL = 1.6
no limit
----------------------------
Chromium III
NC
117.7325 FW(7Q10s) 905.0818
fig/
0 0
N/A
Acute: 6,532.5
Chronic:----1,011.3--
no limit
----------------------------
Chromium VI
NC
11 FW(7Q10s) 16
µg/L
0 0
N/A
Acute: 115.5
Chronic:-----945 --
no limit
----------------------------
Chromium, Total
NC
µg/L
32 1
1.4
no limit
Page 16 of 28
NC0004987_Worksheets_20220414 (3).xlsm, rpa
4/18/2022

Marshall Steam Station
NC0004987
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall Outfall 005
Qw = 5.1 MGD
Copper (AL)
NC
7.8806 FW(7Q10s) 10.4720
ug/L
32 32
4.84
Acute: 75.58
_ _ _ _
-- Chronic: - - -- 67.70 --
No value > Allowable Cw
no limit
---------------------------
Cyanide
NC
5 FW(7Q10s) 22
10
ug/L
1 1
Note: n < 9
Limited data set
19.0
Default C.V.
Acute: 158.8
___ _ __________
Chronic: 43 0
No value > Allowable Cw
no limit
___________________________
Fluoride
NC
1800 FW(7Q10s)
ug/L
32 25
1,856.0
Acute: NO WQS
_ _ _ _ _
-- Chronic: - -- 15,462.2 -
No value > Allowable Cw
n/a
---------------------------
Lead
NC
2.9416 FW(7Q10s) 75.4871
ug/L
32 0
NO DETECTS
Acute: 544.834
-_ _ ---_ _
-Chronic:-25.269 --
Max MDL = 1
no limit
---------------------------
Mercury
NC
12 FW(7Q10s)
0.5
ng/L
32 25
2.7
Acute: NO WQS
_ _ _ _
--Chronic: - - - - --- --
103
No value > Allowable Cw
no limit
---------------------------
Molybdenum
NC
2000 HH(7Q10s)
ug/L
1 1
Note: n < 9
Limited data set
8,840.0
Default C.V.
Acute: NO WQS
___ _ ____ _
Chronic: 17,180.3
No value > Allowable Cw
n/a
___________________________
Nickel
Nickel
NC
NC
37.2313 FW(7Q10s) 335.2087
25.0000 WS(7Q10s)
µg/L
µg/L
32 32
40.9
Acute (FW): 2,419.4
_ _ _ __ _ __
Chronic (FW)_319.8
No value >_ Allowable Cw__
Chronic (WS) 214.8
No value > Allowable Cw
no limit
___________________________
___________________________
Selenium
NC
5 FW(7Q10s) 56
ug/L
32 31
9.1
Acute: 404.2
_ _
--Chronic:-----43-0 --
No value > Allowable Cw
no limit
---------------------------
Silver (AL)
NC
0.06 FW(7Q10s) 0.2964
ug/L
32 0
NO DETECTS
Acute: 2.139
--Ch_ _ ronic: - - -- 0.515__ --
Max MDL = 1
no limit
---------------------------
Zinc (AL)
NC
126.7335 FW(7Q10s) 125.7052
ug/L
32 32
146.4
Acute: 907.3
_ _ _ _
--Chronic:----1,08 --
No value > Allowable Cw
no limit
---------------------------
Aluminum
NC
6500 WS(7Q10s)
µg/L
1 1
Note: n < 9
Limited data set
127.00000
Default C.V.
Acute: NO WQS
___ _ __ _ _
Chronic: 55835.86338
No value > Allowable Cw
no limit
____________________________
Boron
NC
7 WS(7Q10s)
mg/L
1 1
Note: n < 9
Limited data set
7.92000
Default C.V.
Acute: NO WQS
__Ch_ _ ____ _
ronic: 60.13093
No value > Allowable Cw
no limit
___________________________
IAcute:
NO WQS
r,,, ';m;+
Page 17 of 28
NC0004987_Worksheets_20220414 (3).xlsm, rpa
4/18/2022

Marshall Steam Station
NC0004987
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall Outfall 005
Qw = 5.1 MGD
Sulfate
NC
250 WS(7Q10s)
mg/L
32 32
372.90000
—
Chronic: --- 515.40797
No value > Allowable Cw
---------------------------
Barium
NC
1 WS(7Q10s)
mg/L
1 1
Note: n < 9
Limited data set
0.04900
Default C.V.
Acute: NO WQS
_ _ _ _ ___ ___
Chronic: 8.59013
No value > Allowable Cw
no limit
___________________________
Page 18 of 28
NC0004987_Worksheets_20220414 (3).xlsm, rpa
4/18/2022

Monitoring Frequencies
2B .0500 Effluent Limited
pH
Temp, C
BOD5
TSS
NH3-N
Fecal Col.
TN
TP
E
E
I, E
I, E
E
E
E
E
2/Month
1/Week
2/Month
2/Month
1/Month
2/Month
Water Quality Limited
Parameter Location Class I
D.O.
D.O.
pH
Temp, C
Temp, C
BOD5
TSS
NH3-N
TRC
Fecal Col.
Fecal Col.
Conductivi
Conductivi
TN
TP
U.
E
E
U, D
I, E
I, E
E
E
E
U, D
E
U, D
E
E
1/Week
1/Week
1/Week
1/Week
3/Week
3/Week
3/Week
3/Week
2/Month 1/Week
1/Week 3/Week
See notes below.
See notes below.
Frequency
Daily
Daily
Daily
Daily
3/Week
Daily
1/Week
1/Week
2/Month
Daily
1/Week
2/Month
2/Month
1/Month
2/Week
2/Month
2/Month
1/Week
1/Week
Class II Class III
1/Week 3/Week
1/Week 3/Week'
1/Week 3/Week
Daily Daily
1/Week 3/Week`
1/Week 3/Week
1/Week 3/Week
2/Month 1/Week
2/Week 3/Week
1/Week 3/Week
1/Week 3/Week'
1/Week 3/Week
1/Week 3/Week'
See notes below.
See notes below.
Class IV
Daily
3/Week'
Daily
Daily
3/Week'
Daily
Daily
3/Week
Daily
Daily
3/Week'
Daily
3/Week'
Notes:
Upstream and downstream monitoring in WQ-limited waters is to be conducted
3/Week during Jun, Jul, Aug, and Sep; and 1/Week during the rest of the year.
TN, TP Monitoring
All facilities >= 0.05 MGD will monitor TN and TP
Those < 0.05 MGD will monitor if discharging to NSW
For the Neuse, Tar -Pamlico, and any other river basins classifed as NSW, use limits
and monitoring requirements according to the basin's permitting strategy.
For French Broad, Broad, Savannah, New Watauga, Little Tennessee, and Hiwassee:
- >= 0.05 M: - monitor semiannually
- >= 1.0 MG - monitor quarterly
For all other river basins:
- >= 0.05 M: - monitor quarterly
- >= 1.0 MG - monitor monthly
Per Memo Dated 7-15-2010
RPA Condition
Permit Monitoring Frequency
LRPA Exists
Monitor Monthly and add Permit Limit
2.RPA Exists but Action Levels (Cu, Zn, Ag ,Fe. CI)
Monitor Quarterly in conjunction with Tox Test
3aRPA Exists but Damsel Limited (o<g samples)
3b. RPA exists, dataset limited, but 2 values >
allowable Cw
Monitor Quarterly
Monitor Monthly and add Pewit Limit
1.No RYA (Predicted Max > 5014 of Allowable)
Monitor Quarterly (or defer to Pretreat LTMP)
5.No RPA (Predicted Max < MM% Allowable)
No Monitoring
6a.Na Data (New Permit, New Waste Stream)
6b. New Greensand or Conventional WTP
Monitor Monthly for Toxic Pollutants of Concern
Monitor Quarterly for Toxic Pollutants of Concern
password all sheets = rpa2016
Msg00
Msg01
Msg02
Msg03
Msg04
Msg05
Msg06
Msg07
Msg08
Msg09
Msg10
< No Data Entered >
MaxPredCw < Acute
MaxPredCw < Chronic
MaxPredCw « Acute
MaxPredCw « Chronic
MaxPredCw > Acute
MaxPredCw > Chronic
MaxPredCw » Acute
MaxPredCw» Chronic
No acute standard or 1/2 FAV
No chronic standard or criterion
NO DATA
MONITOR?
MONITOR?
REMOVE?
REMOVE?
DAILY MAX LIMIT?
MO AVG LIMIT?
DAILY MAX LIMIT?
MO AVG LIMIT?
N/A
N/A
Sample recommendations:
Daily max limit
Monitor 1/month
Monitor 1/week
Monitor2/month
Monitoring not necessary in permit
No limit
No limit - assuming no tox (Action Level parameter)
No limit (Action Level parameter)
Continue to monitor at 2/month
Mo. avg. limit (keep wk. avg. if existing)
Revise daily max. limit

River Basin
HUC
Hardness
Total Suspended Solids (TSS)
Stations
Samples
10th Percentile
Median
Mean
Stations
Samples
10th Percentile
Median
Mean
03010102
4
188
28
90.5
83.4
1
8
6.2
6.2
8.8
Roanoke
03010103
12
720
14
21.5
24.3
5
40
6.2
6.9
45.6
03010104
18
851
24
35
36.6
4
32
6.2
6.2
18.0
River
03010106
5
118
18
29
32.3
1
8
6.2
6.2
7.9
03010107
11
856
24
30
33.6
6
47
6.2
6.2
11.5
03010201
0
0
NA
NA
NA
0
0
NA
NA
NA
03010202
1
73
28
38
42.6
1
8
6.2
6.2
6.6
:howan Rive
03010203
12
633
18
28
36.2
5
40
6.2
6.2
6.4
03010204
3
146
20
30
31.6
2
16
6.2
6.2
8.9
03010205
21
252
40
96
203.2
2
15
6.2
6.2
7.2
03020101
17
1021
19
28
31.8
9
72
6.2
6.2
9.3
Tar-
03020102
3
172
20
26.5
29.5
1
8
6.2
6.2
6.2
Pamlico
03020103
12
818
23
35
60.2
6
47
6.2
6.2
9.8
03020104
1
88
10
16
20.9
7
293
6.2
6.2
15.9
River
03020105
0
0
NA
NA
NA
0
0
NA
NA
NA
03020106
1
120
30
60
153.1
1
9
6.2
6.2
7.5
03020201
48
2361
20
34
43.8
17
136
6.2
6.2
9.7
Neuse
03020202
9
643
20
30
35.7
6
41
6.2
7.2
13.2
River
03020203
14
573
16
26
31.3
4
32
6.2
6.2
6.2
03020204
6
147
32
60
68.9
1
8
6.2
6.2
6.2
White Oak
03020301
0
0
NA
NA
NA
0
0
NA
NA
NA
River
03020302
3
221
45.2
93
357.0
2
18
6.2
6.2
6.2
03030002
56
2695
26
44
48.8
17
315
6.2
7.8
14.8
03030003
33
1637
24
43
53.4
9
65
6.2
6.2
38.8
Cape Fear
03030004
22
1240
6
19
21.4
7
55
6.2
6.2
10.0
River
03030005
16
1054
18
26
83.6
6
49
6.2
7.2
12.3
03030006
17
760
12
23
33.1
7
57
6.2
6.2
6.5
03030007
17
657
24
40
56.0
8
63
6.2
6.2
6.6
03040101
22
1380
10
20
25.8
12
187
6.2
8.8
25.6
03040102
7
473
16
34
33.9
5
68
6.2
13
29.1
Yadkin -Pee
03040103
42
1527
22
42
78.4
9
84
6.2
11
19.3
Dee River
03040104
14
563
11.4
22
26.5
4
31
6.2
6.2
10.2
03040105
24
875
31
46
51.3
9
97
6.2
6.2
26.6
03040201
10
329
11.64
22
23.6
4
31
6.2
6.2
10.5
03040202
0
0
NA
NA
NA
0
0
NA
NA
NA
Lumber
03040203
58
1346
5
12
15.2
8
61
6.2
6.2
7.5
03040204
23
362
5
7
15.0
2
16
6.2
6.2
6.7
River
03040206
25
503
7
20
31.1
3
27
6.2
6.2
7.1
03040208
0
0
NA
NA
NA
1
8
8.8
16
15.9
Catawba
03050101
63
2861
7
14
26.2
15
91
6.2
6.2
19.6
03050102
18
1230
8
22
27.4
9
72
6.2
6.35
21.1
River
03050103
14
966
38
67
67.2
5
40
6.2
6.2
9.6
Broad River
03050105
24
1011
9
17
21.2
8
63
6.2
6.2
13.0
Savannah
03060101
1
116
3
5
5.7
1
10
6.2
6.2
6.3
River
03060102
0
0
NA
NA
NA
0
0
NA
NA
NA
New River
05050001
9
707
12
20
22.1
8
46
6.2
6.2
33.8
✓atauga RivE
06010103
6
322
12
20
21.8
2
15
6.2
6.2
6.5
French
06010105
30
1854
4
10
11.3
14
91
6.2
6.2
18.6
Broad
06010106
13
982
3
9
23.0
6
49
6.2
6.2
8.1
River
06010108
12
744
3
12
12.3
5
34
6.2
6.2
16.2
Little
06010202
12
567
4
8
8.2
3
24
6.2
6.2
11.5
Tennessee
06010203
7
310
4
7
8.9
1
8
6.2
6.2
8.2
River
06010204
7
152
5
9
10.0
1
8
6.2
6.2
9.0
Hiwassee
06020002
13
272
5
10
12.5
3
17
6.2
6.2
8.5
River
06020003
0
0
NA
NA
NA
0
0
NA
NA
NA
notes:
816 37,496 273 2,660
1. The Practical Quanitation Limit (PQL) for TSS is 6.2 mg/L. The PQL for Hardness is 1 mg/L.
2. Some questionable data (recorded as zero but with no PQL given) was removed from the database.
3. This table was constructed using all available data in STORET for the State of North Carolina, 12/20/10.

Date: 4/18/2022
Dissolved to Total Metal Calculator
Do NOT enter any data directly into this spreadsheet.
Enter data onto "Table 1" under the Input Sheet and enter
"Effluent Hardness" under the Data Sheet.
In accordance with 40 CFR 122.45 (c ), permits are, have and
must be written as total metals.
This calculator has been inserted into the RPA to calculate Total
Metal allowable allocations once Table 1 has been completed
(Input Sheet) and Effluent hardness has been entered (Data
Sheet).
1) Following the spreadsheet from left to right. First
the allowable allocations for the dissolved metals will
appear for all the metals listed once Table 1 is complete and
effluent hardness entered. Use a default value of 25 mg/L if
no hardness data is available. Second, the
Dissolved Metal allocations are divided by the Translators to
determine the Total Metals that can be allocated to the
Permittee. These Total Metals values are automatically
inserted into Table 2 and are the allowable Total Metal
allocations determined for the Permittee prior to allowing
for dilution. See Input sheet Table 2. The final acute and
chronic values shown under the RPA sheet are the Total
Metal values listed in Table 2 divided by the acute and
chronic IWC, respectively.
2) The Translators used in the freshwater RPA are the Partition
Coefficients published by US EPA in 1984. They are TSS
dependent equations and can be found listed with the WQS
hardness dependent equations under the sheet labeled
Equations. A fixed TSS value of 10 mg/L is used to calculate
the Translator values.
3) Pretreatment Facilities - PERCS will need a copy of the
Dissolved to Total Metal Calculator spreadsheet and the
RPA sheet along with the Final Permit. Pretreatment
Facilities are required to renew their Headwords Analysis
after renewal of their permits. Since all their metal
allocations are likely to change PERCS needs to see any new
metal permit limits and the allowable allocations for the
dissolved metals to assess Maximum Allowable Headworks
Loading (MAHL) numbers for each metal based on the
Combined Hardness values used in the permit writers RPA
calculations.
4) For Cadmium, Lead, Nickel, Chromium and Beryllium, if all
the effluent sampling data for the last three to five years
shows the pollutant at concentrations less than the Practical
Quantitative Level (PQL), it is not likely a limit or monitoring
will be put in the permit. However, if the estimated NPDES
permit limit is less than the Practical Quantitative Limit
(particularly, Cadmium and Lead) and the pollutant is
believed to be present, to assess compliance with the new
standards and for future permit limit development,
monitoring for the pollutant will be required. If the facility is
monitoring for the pollutant in its Pretreatment LTMP, no
monitoring is needed in the permit.
5) For monitoring and compliance purposes if Total Chromium
FACILITY: Marshall Steam Station
NPDES PERMIT: NC0004987
Dissolved to Total Metal Calculator
In accordance with Federal Regulations, permit limitations must be written as Total Metals per 40 CFR 122.45(c)
HUC = 03010103
Receiving
Stream
summer
7Q10 (CFS)
Receiving
Stream
summer 7Q10
(MGD)
Rec. Stream
1Q10
[MGD]
NPDES
Flow Limit
[MGD]
Total Suspended
Solids
-Fixed Value-
(mg/L)
Combined
Hardness
chronic
(mg/L)
Combined
Hardness
Acute
(mg/L)
Instream
Wastewater
Concentration
(Chronic)
Instream
Wastewater
Concentration
(Acute)
8-digit H U C
Hardness
Median (mg/L)
Effluent
Hardness
Median
(mg/L)
60.0000
38.7097 31.7097
5.1000
10 25.000 25.000 11.6413 13.8551
25 25
PARAMETER
Dissolved Metals
Chronic
Acute
[ug/I]
[ug/I]
US EPA
Translators- using
Default Partition
Coefficients
(streams)
Maximum Allowable Effluent Concentration
(MAEC) as a Total Metal
=Dissolved Metal Translator
Chronic
Acute
HUC Hard Med (mg/L) =
21.5
EFF Hard Med (mg/L) = 25
[ug/I]
[ug/I]
Cadmium (d)
Cd -Trout streams
Chromium III (d)(h)
Chromium VI (d)
Chromium, Total (t)
Copper (d)(h)
Lead (d)(h)
Nickel (d)(h)
Ni - WS streams (t)
Silver (d)(h,acute)
Zinc (d)(h)
0.15
0.15
24
11
2.7
0.54
16
0.06
36
0.82
0.51
183
16
3.6
14
145
0.30
36
0.252
0.252
0.202
1.000
0.348
0.184
0.432
1.000
0.288
0.59
0.59
117.73
11.00
N/A
7.88
2.94
37.23
3.24
2.01
905.08
16.00
N/A
10.47
75.49
335.21
25 N/A
0.06
0.30
126.73 125.71
Beryllium
Arsenic (d)
6.5
150
65
340
1.000
1.000
6.5
150
65
340
COMMENTS (identify parameters to PERCS Branch to maintain in facility's LTMP/STMP):
(d) = dissolved metal standard. See 15A NCAC 02B .0211 for more information.
(h) = hardness -dependent dissolved metal standard. See 15A NCAC 02B .0211 for more information.
(t) = based upon measurement of total recoveable metal. See 15A NCAC 02B .0211 for more information.
The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard.
The Human Health standard for Arsenic is 10 µg/L which is Total Recoverable metal standard.

Reasonable Potential Multiplying Factors -Calculator
95.0%
95.0%
Confidence Level
Upper Boundary of the Effluent Distribution (Percentile Value Not To Exceed)
Coefficient of Variation
Coefficient of Variation
n
0.0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1.0
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2.0
2.1
2.2
2.3
2.4
2.5 2.6
2.7
2.8
2.9
3.0 3.1
3.2
3.3
3.4
3.5 3.6
3.7
3.8
3.9
4.0 4.1
4.2
1
1.00
1.39
1.92
2.63
3.55
4.73
6.20
7.98
iu.11 1L.b0
15.47
18.72
22.35
26.38
30.78
35.57
40.73
46.26
52.14
58.37
64.94
71.84
79.06
86.58
94.41
102.53
110.94
119.62
128.56
137.76
147.21
15b.i
166.84
177.00
187.38
197.98
208.78
219.79
231.00
242.40
253.99
265.76
277.71
2
1.00
1.27
1.61
2.03
2.53
3.11
3.79
4.57
5.43
6.38
7.41
8.51
9.69
10.94
12.25
13.61
15.03
16.49
18.00
19.55
21.14
22.75
24.40
26.08
27.79
29.51
31.26
33.03
34.82
36.63
38.45
40.28
42.13
43.99
45.86
47.74
49.64
51.54
53.44
55.36
57.28
59.21
61.15
3
1.00
1.22
1.48
1.79
2.15
2.55
3.00
3.49
4.03
4.60
5.20
5.84
6.49
7.17
7.87
8.59
9.32
10.06
10.81
11.58
12.34
13.12
13.90
14.68
15.46
16.25
17.04
17.83
18.62
19.41
20.21
21.00
21.79
22.58
23.36
24.15
24.94
25.72
26.50
27.28
28.06
28.84
29.61
4
1.00
1.19
1.40
1.65
1.93
2.25
2.59
2.95
3.34
3.74
4.16
4.60
5.04
5.50
5.96
6.42
6.89
7.36
7.84
8.31
8.79
9.26
9.73
10.20
10.68
11.14
11.61
12.07
12.54
13.00
13.45
13.91
14.36
14.81
15.25
15.70
16.14
16.58
17.01
17.44
17.87
18.30
18.72
5
1.00
1.16
1.35
1.56
1.80
2.0c
2.32
2.61
2.91
3.23
3.55
3.87
4.21
4.54
4.88
5.21
5.55
5.89
6.22
6.56
6.89
7.22
7.54
7.87
8.19
8.51
8.82
9.13
9.44
9.75
10.05
10.36
10.65
10.95
11.24
11.53
11.82
12.10
12.38
12.66
12.94
13.21
13.48
6
1.00
1.15
1.31
1.50
1.70
1.9.
2.14
?.38
2.63
2.88
3.14
3.40
3.66
3.92
4.18
4.44
4.70
4.96
5.21
5.46
5.71
5.96
6.20
6.44
6.68
6.91
7.14
7.37
7.60
7.82
8.04
8.25
8.47
8.68
8.89
9.10
9.30
9.50
9.70
9.90
10.09
10.29
10.48
7
1.00
1.13
1.28
1.45
1.62
1.81
2.01
2.21
2.42
2.63
2.84
3.06
3.27
3.48
3.69
3.90
4.11
4.32
4.52
4.72
4.91
5.10
5.29
5.48
5.67
5.85
6.02
6.20
6.37
6.54
6.71
6.88
7.04
7.20
7.36
7.51
7.67
7.82
7.97
8.12
8.26
8.41
8.55
8
1.00
1.12
1.26
1.40
1.56
1.73
1.90
2.07
2.25
2.44
2.62
2.80
2.98
3.16
3.33
3.51
3.68
3.85
4.01
4.17
4.33
4.49
4.64
4.79
4.94
5.09
5.23
5.37
5.51
5.64
5.78
5.91
6.03
6.16
6.29
6.41
6.53
6.65
6.77
6.88
6.99
7.11
7.22
9
1.00
1.11
1.24
1.37
1.51
1.66
1.81
1.97
2.17
2.28
2.44
2.60
2.7F
2.90
3.05
3.20
3.34
3.49
3.62
3.7F
3.89
4.02
4.15
4.27
4.40
1.52
4.63
4.75
1-.86
4.97
5.08
5.19
5.29
5.40
5.50
5.60
5.69
5.79
5.88
5.98
6.07
6.16
6.25
10
1.00
1.10
1.22
1.34
1.47
1.60
1.74
1.88
2.02
2.16
2.30
2.43
2.57
2.70
2.83
2.95
3.08
3.20
3.32
3.43
3.55
3.66
3.77
3.87
3.97
4.07
4.17
4.27
4.36
4.46
4.55
4.64
4.72
4.81
4.89
4.97
5.06
5.13
5.21
5.29
5.36
5.44
5.51
11
1.00
1.10
1.20
1.32
1.43
1.55
1.68
1.80
1.93
2.05
2.18
2.30
2.41
2.53
2.64
2.75
2.86
2.97
3.07
3.17
3.27
3.36
3.46
3.55
3.63
3.72
3.80
3.89
3.97
4.05
4.12
4.20
4.27
4.34
4.41
4.48
4.55
4.62
4.68
4.75
4.81
4.87
4.94
12
1.00
1.09
1.19
1.29
1.40
1.51
1.63
1.74
1.85
1.96
2.07
2.18
2.29
2.39
2.49
2.59
2.68
2.78
2.87
2.95
3.04
3.12
3.20
3.28
3.36
3.43
3.50
3.57
3.64
3.71
3.78
3.84
3.90
3.97
4.03
4.09
4.15
4.20
4.26
4.31
4.37
4.42
4.47
13
1.00
1.09
1.18
1.27
1.37
1.48
1.58
1.68
1.79
1.89
1.99
2.08
2.18
2.27
2.36
2.45
2.53
2.61
2.69
2.77
2.84
2.92
2.99
3.06
3.12
3.19
3.25
3.31
3.37
3.43
3.49
3.55
3.60
3.66
3.71
3.76
3.81
3.86
3.91
3.96
4.00
4.05
4.09
14
1.00
1.08
1.17
1.26
1.35
1.44
1.54
1.63
1.73
1.82
1.91
2.00
2.08
2.17
2.25
2.32
2.40
2.47
2.54
2.61
2.68
2.74
2.81
2.87
2.93
2.98
3.04
3.09
3.15
3.20
3.25
3.30
3.35
3.39
3.44
3.48
3.53
3.57
3.61
3.66
3.70
3.74
3.77
15
1.00
1.08
1.16
1.24
1.33
1.41
1.50
1.59
1.68
1.76
1.84
1.92
2.00
2.07
2.15
2.22
2.29
2.35
2.41
2.48
2.54
2.59
2.65
2.70
2.76
2.81
2.86
2.91
2.95
3.00
3.04
3.09
3.13
3.17
3.21
3.25
3.29
3.33
3.36
3.40
3.44
3.47
3.51
16
1.00
1.07
1.15
1.23
1.31
1.39
1.47
1.55
1.63
1.71
1.78
1.85
1.93
1.99
2.06
2.12
2.19
2.24
2.30
2.36
2.41
2.46
2.51
2.56
2.61
2.65
2.70
2.74
2.78
2.83
2.86
2.90
2.94
2.98
3.01
3.05
3.08
3.12
3.15
3.18
3.21
3.24
3.28
17
1.00
1.07
1.14
1.21
1.29
1.36
1.44
1.51
1.59
1.66
1.73
1.79
1.86
1.92
1.98
2.04
2.10
2.15
2.20
2.25
2.30
2.35
2.39
2.44
2.48
2.52
2.56
2.60
2.64
2.67
2.71
2.74
2.78
2.81
2.84
2.87
2.90
2.93
2.96
2.99
3.02
3.05
3.08
18
1.00
1.06
1.13
1.20
1.27
1.34
1.41
1.48
1.55
1.62
1.68
1.74
1.80
1.86
1.91
1.97
2.02
2.07
2.11
2.16
2.20
2.25
2.29
2.33
2.36
2.40
2.44
2.47
2.51
2.54
2.57
2.60
2.63
2.66
2.69
2.72
2.75
2.77
2.80
2.83
2.85
2.88
2.90
19
1.00
1.06
1.12
1.19
1.26
1.32
1.39
1.45
1.51
1.58
1.64
1.69
1.75
1.80
1.85
1.90
1.95
1.99
2.03
2.08
2.12
2.15
2.19
2.23
2.26
2.30
2.33
2.36
2.39
2.42
2.45
2.48
2.51
2.53
2.56
2.58
2.61
2.63
2.66
2.68
2.70
2.72
2.75
20
1.00
1.06
1.12
1.18
1.24
1.30
1.36
1.42
1.48
1.54
1.59
1.65
1.70
1.75
1.79
1.84
1.88
1.92
1.96
2.00
2.04
2.07
2.11
2.14
2.17
2.20
2.23
2.26
2.29
2.31
2.34
2.37
2.39
2.42
2.44
2.46
2.48
2.51
2.53
2.55
2.57
2.59
2.61
21
1.00
1.05
1.11
1.17
1.23
1.29
1.34
1.40
1.45
1.51
1.56
1.61
1.65
1.70
1.74
1.78
1.82
1.86
1.90
1.93
1.96
2.00
2.03
2.06
2.09
2.12
2.14
2.17
2.19
2.22
2.24
2.27
2.29
2.31
2.33
2.35
2.37
2.39
2.41
2.43
2.45
2.47
2.49
22
1.00
1.05
1.11
1.16
1.22
1.27
1.32
1.38
1.43
1.48
1.52
1.57
1.61
1.65
1.69
1.73
1.77
1.80
1.84
1.87
1.90
1.93
1.96
1.99
2.01
2.04
2.06
2.09
2.11
2.13
2.15
2.18
2.20
2.22
2.24
2.25
2.27
2.29
2.31
2.33
2.34
2.36
2.37
23
1.00
1.05
1.10
1.15
1.20
1.25
1.31
1.35
1.40
1.45
1.49
1.53
1.57
1.61
1.65
1.68
1.72
1.75
1.78
1.81
1.84
1.87
1.89
1.92
1.94
1.97
1.99
2.01
2.03
2.05
2.07
2.09
2.11
2.13
2.15
2.16
2.18
2.20
2.21
2.23
2.24
2.26
2.27
24
1.00
1.05
1.09
1.14
1.19
1.24
1.29
1.33
1.38
1.42
1.46
1.50
1.54
1.57
1.61
1.64
1.67
1.70
1.73
1.76
1.78
1.81
1.83
1.86
1.88
1.90
1.92
1.94
1.96
1.98
2.00
2.02
2.03
2.05
2.07
2.08
2.10
2.11
2.13
2.14
2.16
2.17
2.18
25
1.00
1.04
1.09
1.14
1.18
1.23
1.27
1.32
1.36
1.40
1.43
1.47
1.51
1.54
1.57
1.60
1.63
1.66
1.68
1.71
1.73
1.76
1.78
1.80
1.82
1.84
1.86
1.88
1.90
1.91
1.93
1.95
1.96
1.98
1.99
2.01
2.02
2.04
2.05
2.06
2.08
2.09
2.10
26
1.00
1.04
1.09
1.13
1.17
1.21
1.26
1.30
1.34
1.37
1.41
1.44
1.48
1.51
1.54
1.56
1.59
1.62
1.64
1.66
1.69
1.71
1.73
1.75
1.77
1.79
1.80
1.82
1.84
1.85
1.87
1.88
1.90
1.91
1.93
1.94
1.95
1.97
1.98
1.99
2.00
2.01
2.02
27
1.00
1.04
1.08
1.12
1.16
1.20
1.24
1.28
1.32
1.35
1.39
1.42
1.45
1.48
1.50
1.53
1.55
1.58
1.60
1.62
1.64
1.66
1.68
1.70
1.72
1.73
1.75
1.77
1.78
1.80
1.81
1.82
1.84
1.85
1.86
1.88
1.89
1.90
1.91
1.92
1.93
1.94
1.95
28
1.00
1.04
1.08
1.12
1.15
1.19
1.23
1.26
1.30
1.33
1.36
1.39
1.42
1.45
1.47
1.50
1.52
1.54
1.56
1.58
1.60
1.62
1.64
1.66
1.67
1.69
1.70
1.72
1.73
1.74
1.76
1.77
1.78
1.79
1.81
1.82
1.83
1.84
1.85
1.86
1.87
1.88
1.89
29
1.00
1.04
1.07
1.11
1.15
1.18
1.22
1.25
1.28
1.31
1.34
1.37
1.40
1.42
1.44
1.47
1.49
1.51
1.53
1.55
1.56
1.58
1.60
1.61
1.63
1.64
1.66
1.67
1.68
1.70
1.71
1.72
1.73
1.74
1.75
1.76
1.77
1.78
1.79
1.80
1.81
1.82
1.83
30
1.00
1.03
1.07
1.10
1.14
1.17
1.20
1.24
1.27
1.29
1.32
1.35
1.37
1.39
1.42
1.44
1.46
1.48
1.49
1.51
1.53
1.54
1.56
1.57
1.59
1.60
1.61
1.63
1.64
1.65
1.66
1.67
1.68
1.69
1.70
1.71
1.72
1.73
1.74
1.75
1.76
1.76
1.77
31
1.00
1.03
1.06
1.10
1.13
1.16
1.19
1.22
1.25
1.28
1.30
1.33
1.35
1.37
1.39
1.41
1.43
1.45
1.46
1.48
1.50
1.51
1.52
1.54
1.55
1.56
1.57
1.59
1.60
1.61
1.62
1.63
1.64
1.65
1.66
1.66
1.67
1.68
1.69
1.70
1.71
1.71
1.72
32
1.00
1.03
1.06
1.09
1.12
1.15
1.18
1.21
1.24
1.26
1.28
1.31
1.33
1.35
1.37
1.39
1.40
1.42
1.43
1.45
1.46
1.48
1.49
1.50
1.51
1.53
1.54
1.55
1.56
1.57
1.58
1.59
1.60
1.60
1.61
1.62
1.63
1.64
1.64
1.65
1.66
1.66
1.67
33
1.00
1.03
1.06
1.09
1.12
1.14
1.17
1.20
1.22
1.24
1.27
1.29
1.31
1.33
1.34
1.36
1.38
1.39
1.41
1.42
1.43
1.45
1.46
1.47
1.48
1.49
1.50
1.51
1.52
1.53
1.54
1.55
1.56
1.56
1.57
1.58
1.59
1.59
1.60
1.61
1.61
1.62
1.63
34
1.00
1.03
1.05
1.08
1.11
1.14
1.16
1.18
1.21
1.23
1.25
1.27
1.29
1.31
1.32
1.34
1.35
1.37
1.38
1.39
1.41
1.42
1.43
1.44
1.45
1.46
1.47
1.48
1.49
1.49
1.50
1.51
1.52
1.53
1.53
1.54
1.55
1.55
1.56
1.57
1.57
1.58
1.58
35
1.00
1.03
1.05
1.08
1.10
1.13
1.15
1.17
1.20
1.22
1.23
1.25
1.27
1.29
1.30
1.32
1.33
1.34
1.36
1.37
1.38
1.39
1.40
1.41
1.42
1.43
1.44
1.45
1.45
1.46
1.47
1.48
1.48
1.49
1.50
1.50
1.51
1.51
1.52
1.53
1.53
1.54
1.54
36
1.00
1.02
1.05
1.07
1.10
1.12
1.14
1.16
1.18
1.20
1.22
1.24
1.25
1.27
1.28
1.30
1.31
1.32
1.33
1.34
1.35
1.36
1.37
1.38
1.39
1.40
1.41
1.42
1.42
1.43
1.44
1.44
1.45
1.46
1.46
1.47
1.47
1.48
1.48
1.49
1.49
1.50
1.50
37
1.00
1.02
1.05
1.07
1.09
1.11
1.13
1.15
1.17
1.19
1.21
1.22
1.24
1.25
1.26
1.28
1.29
1.30
1.31
1.32
1.33
1.34
1.35
1.36
1.36
1.37
1.38
1.39
1.39
1.40
1.41
1.41
1.42
1.42
1.43
1.43
1.44
1.45
1.45
1.45
1.46
1.46
1.47
38
1.00
1.02
1.04
1.06
1.08
1.10
1.12
1.14
1.16
1.18
1.19
1.21
1.22
1.23
1.25
1.26
1.27
1.28
1.29
1.30
1.31
1.32
1.32
1.33
1.34
1.35
1.35
1.36
1.37
1.37
1.38
1.38
1.39
1.39
1.40
1.40
1.41
1.41
1.42
1.42
1.43
1.43
1.43
39
1.00
1.02
1.04
1.06
1.08
1.10
1.12
1.13
1.15
1.16
1.18
1.19
1.21
1.22
1.23
1.24
1.25
1.26
1.27
1.28
1.29
1.29
1.30
1.31
1.31
1.32
1.33
1.33
1.34
1.34
1.35
1.36
1.36
1.37
1.37
1.37
1.38
1.38
1.39
1.39
1.40
1.40
1.40
40
1.00
1.02
1.04
1.06
1.07
1.09
1.11
1.12
1.14
1.15
1.17
1.18
1.19
1.20
1.21
1.22
1.23
1.24
1.25
1.26
1.26
1.27
1.28
1.29
1.29
1.30
1.30
1.31
1.31
1.32
1.32
1.33
1.33
1.34
1.34
1.35
1.35
1.35
1.36
1.36
1.37
1.37
1.37
41
1.00
1.02
1.03
1.05
1.07
1.08
1.10
1.12
1.13
1.14
1.15
1.17
1.18
1.19
1.20
1.21
1.21
1.22
1.23
1.24
1.24
1.25
1.26
1.26
1.27
1.27
1.28
1.29
1.29
1.29
1.30
1.30
1.31
1.31
1.32
1.32
1.32
1.33
1.33
1.33
1.34
1.34
1.34
42
1.00
1.02
1.03
1.05
1.06
1.08
1.09
1.11
1.12
1.13
1.14
1.15
1.16
1.17
1.18
1.19
1.20
1.21
1.21
1.22
1.23
1.23
1.24
1.24
1.25
1.25
1.26
1.26
1.27
1.27
1.28
1.28
1.28
1.29
1.29
1.29
1.30
1.30
1.30
1.31
1.31
1.31
1.32
43
1.00
1.01
1.03
1.04
1.06
1.07
1.09
1.10
1.11
1.12
1.13
1.14
1.15
1.16
1.17
1.18
1.18
1.19
1.20
1.20
1.21
1.21
1.22
1.22
1.23
1.23
1.24
1.24
1.25
1.25
1.25
1.26
1.26
1.26
1.27
1.27
1.27
1.28
1.28
1.28
1.28
1.29
1.29
44
1.00
1.01
1.03
1.04
1.05
1.07
1.08
1.09
1.10
1.11
1.12
1.13
1.14
1.15
1.15
1.16
1.17
1.17
1.18
1.18
1.19
1.20
1.20
1.20
1.21
1.21
1.22
1.22
1.22
1.23
1.23
1.23
1.24
1.24
1.24
1.25
1.25
1.25
1.25
1.26
1.26
1.26
1.26
45
1.00
1.01
1.03
1.04
1.05
1.06
1.07
1.08
1.09
1.10
1.11
1.12
1.13
1.13
1.14
1.15
1.15
1.16
1.16
1.17
1.17
1.18
1.18
1.19
1.19
1.19
1.20
1.20
1.20
1.21
1.21
1.21
1.22
1.22
1.22
1.22
1.23
1.23
1.23
1.23
1.24
1.24
1.24
46
1.00
1.01
1.02
1.03
1.05
1.06
1.07
1.08
1.08
1.09
1.10
1.11
1.11
1.12
1.13
1.13
1.14
1.14
1.15
1.15
1.16
1.16
1.17
1.17
1.17
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.20
1.20
1.20
1.20
1.21
1.21
1.21
1.21
1.21
1.22
1.22
47
1.00
1.01
1.02
1.03
1.04
1.05
1.06
1.07
1.08
1.08
1.09
1.10
1.10
1.11
1.12
1.12
1.13
1.13
1.13
1.14
1.14
1.15
1.15
1.15
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.18
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.19
1.19
1.20
48
1.00
1.01
1.02
1.03
1.04
1.05
1.05
1.06
1.07
1.08
1.08
1.09
1.09
1.10
1.10
1.11
1.11
1.12
1.12
1.12
1.13
1.13
1.13
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.16
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.17
1.17
1.18
49
1.00
1.01
1.02
1.03
1.03
1.04
1.05
1.05
1.06
1.07
1.07
1.08
1.08
1.09
1.09
1.10
1.10
1.10
1.11
1.11
1.11
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.14
1.14
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.15
1.15
1.15
50
1.00
1.01
1.01
1.02
1.03
1.04
1.04
1.05
1.05
1.06
1.06
1.07
1.07
1.08
1.08
1.08
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.12
1.12
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.14
51
1.00
1.01
1.01
1.02
1.03
1.03
1.04
1.04
1.05
1.05
1.06
1.06
1.06
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.12
1.12
1.12
52
1.00
1.01
1.01
1.02
1.02
1.03
1.03
1.04
1.04
1.04
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.07
1.07
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.10
1.10
53
1.00
1.00
1.01
1.01
1.02
1.02
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
54
1.00
1.00
1.01
1.01
1.01
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.07
1.07
55
1.00
1.00
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
56
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
57
1.00
1.00
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
58
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
0.0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1.0
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2.0
2.1
2.2
2.3
2.4
2.5 2.6
2.7
2.8
2.9
3.0 3.1
3.2
3.3
3.4
3.5 3.6
3.7
3.8
3.9
4.0 4.1
4.2

RPM Fs as
f(n,CV,Confidence,UpperBound)
400.00
350.00
300.00
0
mu 250.00
u_
c
0
1 200.00
V
Z.
5 150.00
100.00
n
350.00-400.00
L 300.00-350.00
❑ 250.00-300.00
❑ 200.00-250.00
150.00-200.00
100.00-150.00
❑ 50.00-100.00
❑ 0.00-50.00

Coefficient of Variation
4.3
4.4
4.5 4.6
4.7
4.8
4.9
5.0 5.1
5.2
5.3
5.4
5.5 5.6
5.7
5.8
5.9
6.0 6.1
n
289.83
302.12
314.57
327.19
339.96
352.88
365.95
37,.1,
39z.53
406.03
41,o6
433.43
447.33
461.35
475.50
489.76
DU,-LD
518.65
533.27
1
63.09
65.03
66.98
68.93
70.89
72.85
74.81
76.78
78.75
80.72
82.69
84.67
86.64
88.62
90.60
92.58
94.56
96.54
98.52
2
30.38
31.15
31.92
32.68
33.44
34.20
34.96
35.72
36.47
37.22
37.97
38.71
39.46
40.20
40.93
41.67
42.40
43.13
43.86
3
19.14
19.56
19.98
20.39
20.80
21.21
21.61
22.02
22.42
22.82
23.21
23.61
24.00
24.39
24.77
25.16
25.54
25.92
26.30
4
13.75
14.02
14.28
14.55
14.81
15.06
15.32
15.57
15.82
16.07
16.32
16.56
16.81
17.05
17.29
17.53
17.76
18.00
18.23
5
10.66
10.85
11.04
11.22
11.40
11.58
11.76
11.93
12.10
12.28
12.45
12.62
12.78
12.95
13.11
13.28
13.44
13.60
13.76
6
8.69
8.83
8.96
9.10
9.23
9.37
9.50
9.63
9.75
9.88
10.01
10.13
10.25
10.37
10.49
10.61
10.73
10.85
10.96
7
7.33
7.43
7.54
7.65
7.75
7.85
7.95
8.05
8.15
8.25
8.34
8.44
8.53
8.63
8.72
8.81
8.90
8.99
9.08
8
6.34
6.42
6.51
6.59
6.67
6.76
6.84
6.9`
6.99
7.07
7.15
7.22
7.30
-7.37
7.44
7.52
7.59
7.66
7.73
9
5.58
5.65
5.72
5.79
5.86
5.93
5.99
6.06
6.12
6.19
6.25
6.31
6.37
6.43
6.49
6.55
6.61
6.66
6.72
10
5.00
5.05
5.11
5.17
5.23
5.28
5.34
5.39
5.44
5.50
5.55
5.60
5.65
5.70
5.75
5.80
5.85
5.89
5.94
11
4.52
4.57
4.62
4.67
4.72
4.77
4.81
4.86
4.90
4.95
4.99
5.03
5.08
5.12
5.16
5.20
5.24
5.28
5.32
12
4.14
4.18
4.22
4.26
4.30
4.35
4.38
4.42
4.46
4.50
4.54
4.57
4.61
4.65
4.68
4.72
4.75
4.78
4.82
13
3.81
3.85
3.89
3.92
3.96
3.99
4.03
4.06
4.10
4.13
4.16
4.19
4.22
4.26
4.29
4.32
4.35
4.37
4.40
14
3.54
3.57
3.60
3.64
3.67
3.70
3.73
3.76
3.79
3.82
3.84
3.87
3.90
3.93
3.95
3.98
4.00
4.03
4.05
15
3.30
3.33
3.36
3.39
3.42
3.44
3.47
3.50
3.52
3.55
3.57
3.60
3.62
3.65
3.67
3.69
3.71
3.74
3.76
16
3.10
3.13
3.15
3.18
3.20
3.23
3.25
3.27
3.30
3.32
3.34
3.36
3.38
3.40
3.42
3.44
3.46
3.48
3.50
17
2.92
2.95
2.97
2.99
3.01
3.03
3.06
3.08
3.10
3.12
3.14
3.16
3.17
3.19
3.21
3.23
3.25
3.26
3.28
18
2.77
2.79
2.81
2.83
2.85
2.87
2.89
2.90
2.92
2.94
2.96
2.97
2.99
3.01
3.02
3.04
3.06
3.07
3.09
19
2.63
2.65
2.66
2.68
2.70
2.72
2.73
2.75
2.77
2.78
2.80
2.81
2.83
2.84
2.86
2.87
2.89
2.90
2.91
20
2.50
2.52
2.54
2.55
2.57
2.58
2.60
2.61
2.63
2.64
2.66
2.67
2.68
2.70
2.71
2.72
2.74
2.75
2.76
21
2.39
2.41
2.42
2.44
2.45
2.46
2.48
2.49
2.50
2.52
2.53
2.54
2.56
2.57
2.58
2.59
2.60
2.61
2.63
22
2.29
2.30
2.32
2.33
2.34
2.36
2.37
2.38
2.39
2.40
2.42
2.43
2.44
2.45
2.46
2.47
2.48
2.49
2.50
23
2.20
2.21
2.22
2.23
2.25
2.26
2.27
2.28
2.29
2.30
2.31
2.32
2.33
2.34
2.35
2.36
2.37
2.38
2.39
24
2.11
2.12
2.13
2.15
2.16
2.17
2.18
2.19
2.20
2.21
2.22
2.23
2.24
2.25
2.25
2.26
2.27
2.28
2.29
25
2.03
2.04
2.06
2.07
2.08
2.09
2.09
2.10
2.11
2.12
2.13
2.14
2.15
2.16
2.16
2.17
2.18
2.19
2.20
26
1.96
1.97
1.98
1.99
2.00
2.01
2.02
2.03
2.04
2.04
2.05
2.06
2.07
2.07
2.08
2.09
2.10
2.10
2.11
27
1.90
1.91
1.91
1.92
1.93
1.94
1.95
1.96
1.96
1.97
1.98
1.99
1.99
2.00
2.01
2.01
2.02
2.03
2.03
28
1.84
1.84
1.85
1.86
1.87
1.88
1.88
1.89
1.90
1.90
1.91
1.92
1.92
1.93
1.94
1.94
1.95
1.95
1.96
29
1.78
1.79
1.79
1.80
1.81
1.82
1.82
1.83
1.84
1.84
1.85
1.85
1.86
1.87
1.87
1.88
1.88
1.89
1.89
30
1.73
1.73
1.74
1.75
1.75
1.76
1.77
1.77
1.78
1.78
1.79
1.80
1.80
1.81
1.81
1.82
1.82
1.83
1.83
31
1.68
1.68
1.69
1.70
1.70
1.71
1.71
1.72
1.72
1.73
1.74
1.74
1.75
1.75
1.76
1.76
1.76
1.77
1.77
32
1.63
1.64
1.64
1.65
1.65
1.66
1.66
1.67
1.67
1.68
1.68
1.69
1.69
1.70
1.70
1.71
1.71
1.72
1.72
33
1.59
1.59
1.60
1.60
1.61
1.61
1.62
1.62
1.63
1.63
1.64
1.64
1.65
1.65
1.65
1.66
1.66
1.67
1.67
34
1.55
1.55
1.56
1.56
1.57
1.57
1.58
1.58
1.58
1.59
1.59
1.60
1.60
1.60
1.61
1.61
1.61
1.62
1.62
35
1.51
1.51
1.52
1.52
1.53
1.53
1.53
1.54
1.54
1.55
1.55
1.55
1.56
1.56
1.56
1.57
1.57
1.57
1.58
36
1.47
1.48
1.48
1.49
1.49
1.49
1.50
1.50
1.50
1.51
1.51
1.51
1.52
1.52
1.52
1.53
1.53
1.53
1.54
37
1.44
1.44
1.45
1.45
1.45
1.46
1.46
1.46
1.47
1.47
1.47
1.48
1.48
1.48
1.48
1.49
1.49
1.49
1.50
38
1.41
1.41
1.41
1.42
1.42
1.42
1.43
1.43
1.43
1.43
1.44
1.44
1.44
1.45
1.45
1.45
1.45
1.46
1.46
39
1.38
1.38
1.38
1.38
1.39
1.39
1.39
1.40
1.40
1.40
1.40
1.41
1.41
1.41
1.41
1.42
1.42
1.42
1.42
40
1.35
1.35
1.35
1.35
1.36
1.36
1.36
1.37
1.37
1.37
1.37
1.37
1.38
1.38
1.38
1.38
1.39
1.39
1.39
41
1.32
1.32
1.32
1.33
1.33
1.33
1.33
1.34
1.34
1.34
1.34
1.34
1.35
1.35
1.35
1.35
1.35
1.36
1.36
42
1.29
1.29
1.30
1.30
1.30
1.30
1.31
1.31
1.31
1.31
1.31
1.32
1.32
1.32
1.32
1.32
1.32
1.33
1.33
43
1.27
1.27
1.27
1.27
1.28
1.28
1.28
1.28
1.28
1.28
1.29
1.29
1.29
1.29
1.29
1.29
1.30
1.30
1.30
44
1.24
1.24
1.25
1.25
1.25
1.25
1.25
1.26
1.26
1.26
1.26
1.26
1.26
1.26
1.27
1.27
1.27
1.27
1.27
45
1.22
1.22
1.22
1.22
1.23
1.23
1.23
1.23
1.23
1.23
1.24
1.24
1.24
1.24
1.24
1.24
1.24
1.24
1.25
46
1.20
1.20
1.20
1.20
1.20
1.21
1.21
1.21
1.21
1.21
1.21
1.21
1.21
1.22
1.22
1.22
1.22
1.22
1.22
47
1.18
1.18
1.18
1.18
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.20
1.20
1.20
48
1.16
1.16
1.16
1.16
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
49
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
50
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
51
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
52
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
53
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
54
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
55
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
56
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
57
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
58
4.3
4.4
4.5
4.6
4.7
4.8
4.9
5.0
5.1
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
6.0
6.1

9/11/2013 rdb
New freshwater RPA based on 95% probability/95% confidence
Statistically 58 points are the maximum number of points allowed under this RPA program. Data fields were estbalished to allow only 58 data point entries.
Additional messages will appear to alert user if more than 58 data points were enter and no predicted values will be calculated
All worksheets are "Protected"
The "mf calculator" is password "Protected"
OTHER CHANGES FROM PREVIOUS RPA PROGRAM:
A. When Model is applied (Check box activated):
1) assumes only chroinc dilution known
2) assumes user will insert appropriate flow values for "7Q10s (cfs)", "7Q10w (cfs)", "30Q2 (cfs)", "QA (cfs)" to define chronic dilution in terms of "IWC %", "IWC %" is the same for all stream flows
3) automatically assigns the entered chronic IWC % to the "IWC @ 7Q10s", "IWC @ 7Q10w", "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page)
3) "1 Q10s (cfs)" automatically defaults to no acute dilution, acute IWC = 100% ,"IWC @ 1 Q10s" = 100% which is used in acute WQS calculatons (See "RPA" page)
B. When Model is not applied (Check box NOT activated):
1) assumes user will insert appropriate flow values for "7Q10s (cfs)", "7Q10w (cfs)", "30Q2 (cfs)", "QA (cfs)" , "Flow Qw (MGD)" for chronic IWC % calculations, IWC % will vary according to flows
3) automatically calculates chronic -based IWC % for the "IWC @ 7Q10s", "IWC @ 7Q10w", "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page)
3) "1 Q10s (cfs)" is automatically calculated bases on entered "7Q10s (cfs)" flow
4) automatically calculates acute -based IWC% for the "IWC @ 1 Q10s" value used in acute WQS calculations (See "RPA" page)
C. When paremeter's "Impaired?" check box is activated:
1) automtically activtes the "IMPAIRED" message alert on the "RPA" page for that parameter
2) does NOT make any automatic adjustements to WQS calculations
NOTE: If new or expanding discharge and receiving stream impaired, will need to evaluate if additional waste load is allowed
10/30/2013 rdb
1) Amended cRR" alert on data sets entreies to activate if "<" entered but no value entered, does not effect RPA calculation, ERR message only
2) Added new calculation feature to count nondetects when both "<" and a value are entered for each data set, used to calculate detected entries
3) Amended "Comments" drop down menu - per Juile
4) Turned the Chronic toxicity concentration message off on the RPA page - per Julie
2/10/14:
ON "data" page changed highlighted area from blue shades to gray
5/2/14 rdb
1) Increased rounding factor on all calculated IWC% to 7 decimals
2) Increased display for all calkculated to 6 decimals places.
5/5/14 rdb
Increased rounding factor on all calculated IWC% to 9 decimals
5/21 / 14 rdb
Removed ROUND function from all IWC% calculations
7/31/14 rdb
Moved RPA page tile blocks down one row so header text was separated
9/9/15: COMPLETED REVISIONS FOR METAL TRANSLATOR FEATURE
1) Added tabs for "HUC Hardness" (lookup table for HUC hardness values), "Hardness Equations" (summary of translator formulas, metals impacted, general info), "Dss to Total Hardness Calculator"
(calcution sheet for metal translator, impacted chronic and acute wqs)
2) Revised "Input" page Table 1:
- New user input for "8 Digit HUC Number" uisng drop down menu for lookup HUC Hardness, required entry, brown highlight
- New display only for calculated "Effluent Hardness (Median)" including conditional method for info display, brown highlight
- New display only for designed "HUC Hardness (Median)" incuding conditionla method for info display, brown highlight
- New display only for calculated "Combined Hardness Chronic" for metal translator application, brown highlight
- New display only for calculated "Combined Hardness Acute" for metal translator application, brown highlight
- Assigned name for "HUC Number"
3) Revised "Input" pade Table 2:
- Removed "Impaired ?" column, conditional display, references
- Added new column for "WQS" designation incuding assigning applicable WQS where fixed
- Added new error message "CHECK WQS", conditonal control based on "WQS" entry for Cadmium, Chlorides, Molybdeum, Nickel
- Revised text in error message
- Added new brown highlight "Metal Translator Data Entry" label box
- Removed Par01 "Arsenic" line
- Revised Par02 " Arsenic" line to reflect Human Health and Water Supply criterion, Chronic = 10 mg/L, Acute = "N/A"
- Revised Par04 "Cadmium" line:
a) "WQS" input with drop down menu to select applicable criterion
b) "Chronic" and "Acute" inputs to display calculated metal translator values including conditional method for info display based on "WQS" selection, no rounding
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
d) Conditonal controls to activate error nessages, brown highlight
- Revised Par05 "Chloride (AL)" line:
a) "WQS" input with drop down menu to select applicable criterion
b) "Chronic" display only for applicable value including conditional method for info display based on "WQS" selection
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
d) "Name" display only based on "WQS" selection including conditional metdod fro info display
e) Conditonal controls to activate error nessages
- Revised "Chromium, Total" line:
a) Removed Par08 label
b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
c) brown highlight
- Added new "Chromium III" line:
a) Assigned applicable text in "WQS", "Type", Modifier", Units"
b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
c) brown highlight
- Added new Par08 "Chromium VI" line:
a) Assigned Par08 label, applicable text in "WQS", "Type", Modifier", Units"
b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
c) brown highlight
- Revised Par09 "Copper (AL)" line:
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
b) brown highlight
- Revisd Par12 "Lead" line:
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
b) brown highlight
- Revised Par14 "Molybdenum" lime:
a) "WQS" input with drop down menu to select applicable criterion
b) "Chronic" display only for applicable value including conditional method for info display based on "WQS" selection
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
d) Conditonal controls to activate error nessages
- Revised Par15 "Nickel" line:
a) "WQS" input with drop down menu to select applicable criterion
b) "Chronic" and "Acute" inputs to display calculated metal translator values including conditional method for info display based on "WQS" selection, no rounding
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
d) Conditonal controls to activate error nessages, brown highlight
- Revised Par17 "Silver (AL)" line:
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
b) brown highlight
- Revised Par18 "Zinc (AL)" line:
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
b) brown highlight
3) Revised "Data" page:
- Revised Par01 "Arsenic" entry, text, and calculations ("1") - all effluent hardness data to be entered in this section for used to calculate eflluent hardness factors
a) Reference to Par01 "Arsenic" removed
b) New label "Effluent Hardness (monthly average)" added
c) "Mult Factor =" and "Max. Pred Cw" removed, text and calcuation
d) "10% value" and "Median value" added, text and calculation including conditional method for info display
e) Assigned name "Effluent_Median" and "effluent_10" to calculated values
f) PQL condition removed from calculation method for data displayed
4) Revised "RPA" page:
- Removed all features assocaited with "Impairment"
- Added new display only for calculated "COMBINED HARDNESS (mg/L)", Chonic and Acute, conditional method for info display
- Revised "Receiving Stream" display to include selected HUC Number in text
- Removed unused display features for WET % (previouly hidden)
- Revised "Arsenic" lines:
a) Par01 "Arsenic" line removed
b) Par02 "Arsenic" references used for display to calculate "Acute" and Chronic" allowable Cw
- Revised "Cadmium", "Chromium VI", "Copper (AL)", "Lead", "Nickel", "Silver (AL)", "Zinc (AL)" (lines:
a) "NC WQS/Chronic" and 1/2 FAV/Acute" conditional method revised for info display, no rounding
b) "Allowable Cw" Acute" and "Chronic" conditional metfhod revised fro info display inculding rounding value

5) Revised "Dss to Total Metal Hardness Calculator" page
- Assigned names for:
a) "CdMAE_AC' - Cadmium calculated metal translator Acute value
b) "CdMAE_CH' - Cadmium calculated metal translator Chronic value
c) "CuMAE_AC" - Copper calculatd metal translator Acute value
d) "CuMAE_CH" - Copper calculated metal translator Chronic value
e) "Cr_Total_AC' - Total Chromium calculated meat) translator Acute value
f) "Cr_Total_CH' - Total Chromium calculated metal translator Chronic value
g) "CrIIIMAE_AC" - Chromium III calculated metal translator Acute value.
h) "CrIIIMAE_CH' - Chromium III calculated metal tramslator Chronic value
i) "CrVIMAE_AC' - Chromium VI calculated metal translator Acute value
j) "CrVINAE_CH' - Chromium VI calculatd metal translator Chronic value
k) "PbMAE_AC' - Lead calculated metal translator Acute value
m) "PbMAE_CH' - Lead calculated metal translator Chronic value
n) "NiMAE_AC' - Nickel calculated metal translator Acute value
o) "NiMAE_CH' - Nickel calculated metal translator Chroniv value
p) "AuMAE_AC' - Silver calculated metal translator Acute value
q) "AuMAE_CH" - Silver calculated metal translator Chronic value
r) "ZnMAE-AC" - Zinc calculated metal translator Acute value
s) "ZnMAE_CH' - Zinc calculated metal translator Chronic value
t) "tss" - assigned TSS harness factor
u) "CHA" - calculated combined acute hardness value
v) "CHC" - calculated combined chronic hardness value
- Added conditional methods to formulas for info display and to incorporate names, no rounding
6) Set up passwortd to protect all pages 'rpa2015'
1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION
1) Inserted "Aresenic, Aquatic Life, C, 50, FW, N/A, pg/L" in first row "INPUT" Table 2, Par01
2) Updated program names to reflect addition of new Arsenic Aquatic Life parameter
3) Inserted "Arsenic" Aquatic Life parameter and cell programming in Arsenic section "RPA" as Chronic and added drop down menu feature
4) Amended labels on "Data" to show H for hardnes and Par01-Par22 for paremeters
1/12/16 REVISED IWC CALCULATIONS TO SHOW FULL DISPLAY on "RPA"
1) Reformatted IWC calculation cells to show caculated value as general (number value will always be displayed)
2) Revised IWC calculation formula to x by 100 to mimic %
3) Revised IWC calculation labels to include "%"
4) Revised all calculations using IWC values "Acute", "Chronic" to divide by 100 to correct for IWC % value
1/12/16 REVISED SPREADSHEET TO INDICATE NO DETECT AND MDL
1) Revised "Data" Par01-Par22 Max Value cell conditional statement to display "NO DETECTS" when data set has all no detects
2) Revised "RPA" all parameters Max Pred CW cell formatting to display "NO DETECTS" when required to display no detects
3) Revised "RPA" alert message (under Chronic labels) conditional statement to display "Max MDL = <2 x max adjusted data set value>" when data set has all no detects
4) Revised "RPA" drop menu to add "No detects" to list and display
1/12/16:
Corrected formula error in mf formula Par01 to use corrected data set ("Data")
Revised "RPA" Cadmium, Copper, Lead, Nickel, Silver, Zinc Acute and Chronic cell conditional statements to have cell display blank if WQS is blank or WQS displays "NO DATA"
1/21-29/16:
1) Expanded parameter list and program features to add two additional parameters, (Par08) "Chromium III" & (Par09) "Chromium VI". This included adding two new data input sections on "Data" tab with
new corresponding RPA evalutaion, non -detect evaluation, formulas for each new data input section; adding two new parameter summary sections to "RPA" tab; revising exsiting parameter designation
to new assigned name (Par10 - Par24), data set (_Data08 - _Data24), non -detects (_ND08 - _ND24).
2) For consistency rearranged display, "Input" & "RPA" tabs, to be "Chromium III", "Chromium VI", "Chromium, Total". All features and programing unique to each display was revised accordingly.
3) Corrected Arsenic - Aquatic Life, Berylium Chronic and Acute values on "Input" tab to be exported from metal translator table.
4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (HUC Hard Med = NA mg/I)" when HUC hardness is NA.
5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formulas to assign 25 as hardness value when HUC hardness is NA.
6) Revised "RPA" tab Chromium, Total Reasonable Potential Results section to remove Acute and Chronic labels and allowable Cw calulation/display, area now blank except for MDL feature display.
7) Revised "RPA" tab Chromium III and Chromium VI Reasonable Potential Results sectons to remove display of values for n, #Det, Max Pred Cw, area blank except for display features from added condtional
formulas that reference Chromium, Total display and data.
NOTE: All RPA evaluation data is generated on each parameter "Data" section and imported to that parameter's "RPA" section, thus, RPA evaluation data can be displayed/used when programmed to do so.
8) Revised "RPA" tab Acute and Chronic conditional formulas for active parameters to display either "IWC?" or "IWC/DATA?" as default until appropraite data is provided.
9) Removed label from "Input" tab.
10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Method 625.
See task notes
2/3/16:
Revised "input"page model feature to
a- Add new model 1 Q10S input cell that is visible on;y when model feature is activated
b- Revise cell formula 1 Q10s (cfs) to display 1 Q10s flow when model feature activated or calculate from 7Q10s flow when model feature NOT activated and 7Q10s flow displayed
c- Revised instructions narrartive that is visible only when model feature is activated
2/9/16:
Revised "input" page Effluent Hardness (Median) cell formula to display "default 99 mg/L (Efflunet Hard Med = <actual value> mg/L)" when stream class is WS and Effluent Hard Med is greater than 99.999 mg/L
Revised "data" page Effluent Hardness (Median) cell formula to display 99 whenstream class is WS and Effluent Hard Med is greater than 99.999 mg/L
Added new display messages to "rpa" page that are visible only when the steam class is water supply
2/16/16:
1) Revised "Diss to Total Metal Calculator" page:
added new cells to display actual calculated Effluent & HUC Median values and to display "Apply Water Supply Criterion" when applicable (stream class is Water Supply based and Efflunet Hard Med
exceeds 99.999 mg/L)
revised the existing calculation input/display cells for Effluent & HUC Hardness Median to show the applied hardness value based on new conditional formula as follows
a- If HUC Hard Med = NA or less than 25 mg/L then default HUC Hard Med to 25 mg/L
b- If Effluent Hard Med less than 25 then default Effluent Hard Med to 25 mg/L
c- If stream class is WS and Effluent Hard Med is greater than 99.9999 mg/L then default Effluent Hard Med to 99 mg/L
2) Revised "input" page dipplay HUC Hardness (Median) to show NA when HUC table value is NA.
2/19/16
Added new WS WQC button to "input" page, activates effluent hardness to apply WS WQC standards, does NOT set parameter modifiers, still must do modifers individually
Added Nickel WS parameter to "input" page
Added Nichel WS to "rpa" page, revised both Nickel parametesr to share commom data, Nickel WS has no Acute standard so only list acute for FW
Set up both Nickel Par17 & Par18 to use same data entries
Changed Par22-25 modifier cells to be set automtically based on WQS entry.
Changed display font color phenols, chlorinared phenols menus
2/22/16:
Make text changes per Julie direction.
2/24/16:
Added to " Diss to Total Metal Calculator" page:
1) Comment section for PERCS info or other to allow user to add commentary
2) Added Facility name to display based on input page
3) Added NPDES permit# to display based on input page
4) Set up new Name "PERCS_page" as print area for table and other PERCS info for GOTO use.
NOTE: User can either highlight desire print area or use GOTO feature to set up desired print arae. When in print mode set up, will need to designate "Print Selection".