NC0004987_Worksheets - Outfall 002_20220514

Dissolved Metals & H
I. How to Determine Hardness for use
HARDNESS - Use 25 mg/L, expressed as C
OR
To determine a Hardness value for permit
Hardness = (Hardness instream(a) n
(mass balance)
(a) Use the median instream Hardness vn
(b) For the purpose of this estimation, use th
II. To Develoa Dissolved Metal con
Table A: Dissolved Freshwater Standards for H,
Metal
Cadmium, Acute
Cadmium, Acute (Trout Waters)
Cadmium, Chronic
Chromium III, Acute
Chromium III, Chronic
Copper, Acute
Copper, Chronic
Lead, Acute
Lead, Chronic
Nickel, Acute
Nickel, Chronic
Silver, Acute
Silver, Chronic
Zinc, Acute
Zinc, Chronic
Complete information on all the proposed
US EPA Translators
using Default Partition 1
Translator equation using Default Partition Coel
Kpo and a are constants that express the equ
i
A default value of 10 mg/L Total Suspended
Table A contains the Default Partition Coel
Table B contains the calculated translators
TABLE A. Default Partition Coefficients
Metal (1)
Cu
Zn
Pb

Cr (III) (2)
Cd
Ni
(1) Delos, C.G., et al. Technical Guidance for Perforr
(2) Linear partition coefficients shall not apply to the
TABLE B. US EPA Translators
PARAMETER
Cadmium
Chromium III
Chromium VI
Chromium, Total
Copper
Lead
Nickel
Silver
Zinc

ardness Determination
v. 5/27/2010
with Dissolved Freshwater Standards for Permitting Purposes
:aCo/ or Ca+Mg, as the default Hardness
limit development, use the following equation:
iq/L * 7Q10, MGD)+(Hardness effluent(b), and/L* Plant flow, MGD)
(7Q10, MGD + Plant flow, MGD)
clue of the ambient 8-digit HUC data collected by the Division of Water Quality. To find the 8-digit HUC
le facility's median effluent Hardness value, if available. The Division will request the permittee to sample effluent
Icentrations for permitting purposes use the Freshwater Standards for Hardness De
irdness Dependent Metals
pg/L
{1.136672-[In hardness](0.041838)} • e^{0.9151 [In hardness]-3.1485}
{1.136672-[In hardness](0.041838)} • e^{0.9151[In hardness]-3.6236}
{1.101672-[In hardness](0.041838)} • e^{0.7998[In hardness]-4.4451}
0.316 • e^{0.8190[In hardness]+3.7256}
0.860 • e^{0.8190[In hardness]+0.6848}
0.960 • e^{0.9422[In hardness]-1.700}
0.960 • e^{0.8545[In hardness]-1.702}
{1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-1.460}
{1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-4.705}
0.998 • e^{0.8460[In hardness]+2.255}
0.997 • e^{0.8460[In hardness]+0.0584}
0.85 • e^{1.72[In hardness]-6.59}
Not applicable
0.978 • e^{0.8473[In hardness]+0.884}
0.986 • e^{0.8473[In hardness]+0.884}
Surface Water Quality Standards can be viewed at: http://h2o.enr.state.nc.us/csu/trirev SW.html.
Coefficients (DPC)
Fficients =
1
v. 6/2/2010
[1 + (Kpo * TSS (1+a) * 10-6)]
librium relationship between dissolved and adsorbed forms of metals.
Solids (TSS) will be used.
Fficients for the equation.
using the default partition coefficients for streams.
STREAMS
Kpo
a
1.04E+06
-0.7436
1.25E+06
-0.7038
2.80E+06
-0.8

3.36E+06
-0.09304
4.00E+06
-1.1307
4.90E+05
-0.5719
ning Waste Load Allocations. Book II: Streams and Rivers. Chapter 3: Toxic Substances, For the U.S. EPA. (EPA-440/4-84-022)
Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefore, p
US EPA Translators
Using stream Default Partition Coefficients
TSS = 10 mg/L
0.252
0.202
1
N/A
0.348
0.184
0.432
1
0.288

hardness value for your facility, Click Here.
hardness once/month and submit one to two years of data with the permit renewal application. If no effluent hardness datz
pendent Metals listed in Table A below.

Example for Cadmium (streams)
Given:
TSS = 10 mg/L
Kpo = 4.00E + 06
a =-1.1307
Translator = 1
[1 + (Kpo * TSS (1+0 * 10-6)]
= 1
[1 + (4.00x106 * 101-1.13°7) * 10-6)]
= 1
[1+2.960465]
= 0.252

1 is submitted, a default of 25 mg/L will be applied.

Monitoring Frequencies
2B .0500 Effluent Limited
pH E 2/Month 1/Week 3/Week Daily
Temp, C E 1/Week 1/Week 3/Week Daily
BODS I, E 2/Month 1/Week 3/Week Daily
TSS I, E 2/Month 1/Week 3/Week Daily
NH3-N E 1/Month 2/Month 1/Week 3/Week
Fecal Col. E 2/Month 1/Week 3/Week Daily
TN E See notes below.
TP E See notes below.
Water Quality Limited
Frequency
Parameter Location Class I Class II Class III Class IV
D.O. E 1/Week 1/Week 3/Week Daily
D.O. U, D 1 /Week 1 /Week 3/Week* 3/Week*
pH E 2/Month 1/Week 3/Week Daily
Temp, C E Daily Daily Daily Daily
Temp, C U, D 1/Week 1/Week 3/Week* 3/Week*
BODS I, E 2/Month 1/Week 3/Week Daily
TSS I, E 2/Month 1/Week 3/Week Daily
NH3-N E 1/Month 2/Month 1/Week 3/Week
TRC E 2/Week 2/Week 3/Week Daily
Fecal Col. E 2/Month 1/Week 3/Week Daily
Fecal Col. U, D 2/Month 1/Week 3/Week* 3/Week*
Conductivi E 1/Week 1/Week 3/Week Daily
Conductivi U, D 1/Week 1/Week 3/Week* 3/Week*
TN E See notes below.
TP E See notes below.
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 classified 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 MC- monitor semi-annually
- >= 1.0 MG - monitor quarterly
For all other river basins:
- >= 0.05 MC- monitor quarterly
- >= 1.0 MG - monitor monthly
Sample recommendat

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
Daily max limit
Monitor 1/month
Monitor 1/week
Monitor 2/month
Monitoring not necess,
No limit
No limit - assuming nc
No limit (Action Level
Continue to monitor at
Mo. avg. limit (keep w
Revise daily max. limi

Per Memo Dated 7-15-2010
RPA Condition
Permit Monitoring Frequency
Exists
Monitor Monthly and add Permit Limit
_1_RPA
2.RPA Exists but Action Levels (Cu, Zn, Ag ,Fe, CO
Monitor Quarterly in conjunction with 1
3a.RPA Exists but Dataset Limited (n< 8 samples)
3b. RPA exists, dataset limited, but 2 values >
allowable Cw
Monitor Quarterly
Monitor Monthly and add Permit Limit
4.No RPA (Predicted Max > 50% of Allowable)
Monitor Quarterly (or defer to Pretreat I
5.No RPA (Predicted Max < 50% Allowable)
No Monitoring
6a.No Data (New Permit, New Waste Stream)
6b. New Greensand or Conventional WTP
Monitor Monthly for Toxic Pollutants a
Monitor Quarterly for Toxic Pollutants
password all sheets = rpa2016
ions:

ary in permit
tox (Action Level parameter)
parameter)
2/month
k. avg. if existing)
t

"ox Test
'..TMP)
f Concern
of Concern

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 002
3.000
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.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 17.5 17.5 Std Dev.
2 16.7 16.7 Mean
3 21.1 21.1 C.V.
4 31.9 31.9 n
5 39.2 39.2
6 31.4 31.4 Mult Factor =
7 31.5 31.5 Max. Value
8 38 38 Max. Pred Cw
9 43.9 43.9
10 46.2 46.2
11 60 60
12 62.4 62.4
13 46.6 46.6
14 44.1 44.1
15 20.8 20.8
16 26.1 26.1
17 27.8 27.8
18 23.2 23.2
19 25.5 25.5
20 28.5 28.5
21 29.8 29.8
22 10.5 10.5
23 10.5 10.5
24 15.1 15.1
25 20.5 20.5
26 20 20
27 17.6 17.6
28 18.2 18.2
29 20.5 20.5
30 1.39 1.39
31 1.03 1.03
32 14.5 14.5
33 1 1
34 9.19 9.19
35 1.26 1.26
36 1.04 1.04
37 3.42 3.42
38 1 1
39 2.33 2.33
40 2.06 2.06
41 2.23 2.23
42 7.41 7.41
43 1.52 1.52
44 2.46 2.46
45 2.95 2.95
46 2.06 2.06
47 2 2
48 2.9 2.9
49 2.89 2.89
50 3.91 3.91
51 4.96 4.96
52 7.87 7.87
53 7.35 7.35
54 7.32 7.32
55 12.6 12.6
56 6.94 6.94
57 6.17 6.17
58 7.69 7.69
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
15.8659
16.8026
0.9443
58
1.00
62.4 ug/L
62.4 ug/L
NC0004987_Worksheets_20220414.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 < 0.1 0.05 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
N/A
0.0500
0.0000
1
Mult Factor = 1.00
Max. Value 0.050 ug/L
Max. Pred Cw 0 DETECTS ug/L
NC0004987_Worksheets_20220414.xlsm, data
- 4 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
Par05
Chlorides (AL)
Date Data
BDL=1/2DL Results
Std Dev.
Mean
C.V.
n
Use "PASTE SPECIAL -
Values" then "COPY" .
Maximum data points =
58
Par06
Chlorinated Phenolic Compounds
NO DATA 1
NO DATA 2
NO DATA 3
0 4
5
Mult Factor = N/A 6
Max. Value N/A mg/L 7
Max. Pred Cw N/A mg/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 Results
Std Dev.
Mean
C.V.
n
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.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.xlsm, data
- 6 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par09
Chromium VI
Date Data BDL=1/2DL Results
1 1.2 1.2 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
N/A
1.2000
0.0000
1
1.00
1.2 fag/L
1.2 fag/L
Par10
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev. 2.9698
2 4.7 4.7 Mean 2.6000
3 C.V. (default) 0.6000
4 n 2
5
6 Mult Factor = 3.79
7 Max. Value 4.7
8 Max. Pred Cw 17.8
Chromium, Total
- 7 -
NC0004987_Worksheets_20220414.xlsm, data
4/18/2022

REASONABLE POTENTIAL ANALYSIS
,ECIAL•
:OPY"
lata
Pal 1
Copper (AL)
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.26 1.26
6 < 1 0.5 Mult Factor =
fag/L 7 < 1 0.5 Max. Value
fag/L 8 1.01 1.01 Max. Pred Cw
9 < 1 0.5
10 < 1 0.5
11 1.06 1.06
12 < 1 0.5
13 < 1 0.5
14 < 1 0.5
15 < 1 0.5
16 < 1 0.5
17 1.1 1.1
18 < 1 0.5
19 < 1 0.5
20 < 1 0.5
21 < 1 0.5
22 1.52 1.52
23 < 1 0.5
24 < 1 0.5
25 1.02 1.02
26 < 1 0.5
27 < 1 0.5
28 < 1 0.5
29 < 1 0.5
30 1.54 1.54
31 1.34 1.34
32 < 1 0.5
33 < 1 0.5
34 < 1 0.5
35 1.18 1.18
36 1.24 1.24
37 < 1 0.5
38 1.42 1.42
39 1.13 1.13
40 1.36 1.36
41 < 2 1
42 < 2 1
43 < 2 1
44 < 2 1
45 < 2 1
46 < 2 1
47 < 2 1
48 < 2 1
49 2.41 2.41
50 3.13 3.13
51 3.06 3.06
52 3.3 3.3
53 3.62 3.62
54 2.83 2.83
55 2.32 2.32
56 < 2 1
57 < 2 1
58 < 2 1
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par12
Cyanide
0.7919
1.0578
0.7486
58
1.00
3.62 ug/L
3.62 ug/L
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Date Data BDL=1/2DL Results
1 < 10 5 Std Dev. N/A
2 Mean 5.00
3 C.V. 0.0000
4 n 1
5
6 Mult Factor = 1.00
7 Max. Value 5.0
8 Max. Pred Cw 0 DETECTS
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
- 8 -
NC0004987_Worksheets_20220414.xlsm, data
4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par13
Fluoride
Date Data BDL=1/2DL Results
1 Std Dev.
2 Mean
3 C.V.
4 n
5
6 Mult Factor =
ug/L 7 Max. Value
ug/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
Par14
Lead
NO DATA
NO DATA
NO DATA
0
N/A
N/A ug/L
N/A ug/L
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev. N/A
2 Mean 0.5000
3 C.V. 0.0000
4 n 1
5
6 Mult Factor = 1.00
7 Max. Value 0.500
8 Max. Pred Cw 0 DETECTS
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
- 9 -
NC0004987_Worksheets_20220414.xlsm, data
4/18/2022

REASONABLE POTENTIAL ANALYSIS
,ECIAL•
:OPY"
lata
Par15
Mercury
Date Data BDL=1/2DL Results
1 < 0.5 0.25 Std Dev.
2 < 0.5 0.25 Mean
3 0.796 0.796 C.V.
4 0.5 0.5 n
5 0.882 0.882
6 1.56 1.56 Mult Factor =
ug/L 7 < 0.5 0.25 Max. Value
ug/L 8 0.96 0.96 Max. Pred Cw
9 0.747 0.747
10 0.91 0.91
11 1.14 1.14
12 0.99 0.99
13 1.46 1.46
14 0.601 0.601
15 < 0.5 0.25
16 < 0.5 0.25
17 1.75 1.75
18 1.04 1.04
19 1.69 1.69
20 1 1
21 0.623 0.623
22 2.51 2.51
23 0.838 0.838
24 0.814 0.814
25 1.13 1.13
26 1.18 1.18
27 1.43 1.43
28 1.11 1.11
29 1.07 1.07
30 < 0.5 0.25
31 < 0.5 0.25
32 1.06 1.06
33 < 0.5 0.25
34 0.927 0.927
35 0.579 0.579
36 < 0.5 0.25
37 0.608 0.608
38 < 0.5 0.25
39 < 0.5 0.25
40 < 0.5 0.25
41 1.45 1.45
42 0.649 0.649
43 < 0.5 0.25
44 < 0.5 0.25
45 0.269 0.25
46 0.28 0.25
47 < 0.5 0.25
48 < 0.5 0.25
49 < 0.5 0.25
50 < 0.5 0.25
51 < 2 1
52 < 0.5 0.25
53 < 0.5 0.25
54 0.294 0.25
55 0.98 0.98
56 0.756 0.756
57 0.636 0.636
58 0.263 0.25
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
0.5035
0.7134
0.7058
58
1.00
2.5 ng/L
2.5 ng/L
Par16
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
Molybdenum
NC0004987_Worksheets_20220414.xlsm, data
- 10 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
iata
;8
Par17 & Par18
Nickel
Date Data BDL=1/2DL Results
1 6.2 6.18 Std Dev.
2 Mean
3 C.V.
4 n
5
6 Mult Factor =
ug/L 7 Max. Value
ug/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• Par19
Values" then "COPY"
. Maximum data
points = 58
Selenium
N/A
6.1800
0.0000
1
1.00
6.2 fag/L
6.2 fag/L
Date Data BDL=1/2DL Results
1 8.83 8.83 Std Dev.
2 7.37 7.37 Mean
3 8.4 8.4 C.V.
4 8.81 8.81 n
5 9.53 9.53
6 11.8 11.8 Mult Factor =
7 12.4 12.4 Max. Value
8 12.5 12.5 Max. Pred Cw
9 10 10
10 7.62 7.62
11 8.78 8.78
12 7.31 7.31
13 6.18 6.18
14 6.4 6.4
15 6.44 6.44
16 7.48 7.48
17 6.97 6.97
18 8.03 8.03
19 6.86 6.86
20 8.19 8.19
21 7.04 7.04
22 8.37 8.37
23 8.52 8.52
24 8.03 8.03
25 8.74 8.74
26 7.85 7.85
27 8.69 8.69
28 8.61 8.61
29 8.34 8.34
30 4.36 4.36
31 3.85 3.85
32 4.83 4.83
33 3.64 3.64
34 4.27 4.27
35 3.28 3.28
36 3.8 3.8
37 4.61 4.61
38 3.29 3.29
39 3.43 3.43
40 3.02 3.02
41 4.32 4.32
42 6.37 6.37
43 3.6 3.6
44 2.86 2.86
45 3.17 3.17
46 3.38 3.38
47 3.38 3.38
48 3.46 3.46
49 3.12 3.12
50 2.7 2.7
51 3.36 3.36
52 3.77 3.77
53 3.82 3.82
54 4.2 4.2
55 5.75 5.75
56 4.15 4.15
57 3.86 3.86
58 5.23 5.23
NC0004987_Worksheets_20220414.xlsm, data
4/18/2022

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par20
Silver (AL)
2.6128
6.1547
0.4245
58
1.00
12.5 ug/L
12.5 ug/L
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
Par21
Zinc (AL)
N/A
0.5000
0.0000
1
Mult Factor = 1.00
Max. Value 0.500 ug/L
Max. Pred Cw 0 DETECTS ug/L
Date Data BDL=1/2DL Results
1 < 5 2.5 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
NC0004987_Worksheets_20220414.xlsm, data
- 12 - 4/18/2022

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par22
Aluminum
N/A
2.5000
0.0000
1
1.00
2.5 ug/L
0 DETECTS ug/L
Date Data BDL=1/2DL Results
1 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 SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par23
Boron
NO DATA
NO DATA
NO DATA
0
N/A
N/A fag/L
N/A fag/L
Date Data BDL=1/2DL
1 3.96 3.96
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.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
3.9600
0.0000
1
1.00
3.960000 mg/L
3.960000 mg/L
Date Data BDL=1/2DL Results
1 200 200 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
Par25
Barium
N/A
200.0000
0.0000
1
Mult Factor = 1.00
Max. Value 200.000000 mg/L
Max. Pred Cw 200.000000 mg/L
Date Data BDL=1/2DL
1 0.088 0.088
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.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.0880
0.0000
1
1.00
0.088000 mg/L
0.088000 mg/L
NC0004987_Worksheets_20220414.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) = 3.00
1 Q 10S (cfs) = 49.15
7Q 1 OS (cfs) = 60.00
7Q1OW (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 = 8.643122677
IWC% @ 7Q 10S = 7.192575406
IWC% @ 7Q1OW = 7.192575406
IWC% @ 30Q2 = 7.192575406
IW%C @ QA = 7.192575406
Stream Class: WS-IV
Outfall Outfall 002
Qw = 3 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
REASONABLE POTENTIAL RESULTS
RECOMMENDED ACTION
NC WQS / Applied 1/2 FAV /
Chronic Standard Acute
11 # Det. Max Pred Cw Allowable Cw
Arsenic
Arsenic
C
C
150 FW(7Q10s) 340
10 FIH/WS(Qavg)
ug/L
ug/L
58 58
62.4
Acute (FW): 3,933.8
_ _ _ __ _ ___
Chronic (FW)_2,085.5
No value >_ Allowable Cw___
Chronic (HH) 10 39.
No value > Allowable Cw
no limit
____________________________
____________________________
Beryllium
NC
6.5 FW(7Q10s) 65
ug/L
1 0
Note: n < 9
Limited data set
NO DETECTS
Acute: 752.04
___ _ ____ _ ___
Chronic: 90.37
Max MDL = 1
no limit
____________________________
Cadmium
NC
0.5899 FW(7Q10s) 3.2396
ug/L
1 0
Note: n < 9
Limited data set
NO DETECTS
Acute: 37.482
_ _ _ _
Chronic: - — -— 8.201_ --
Max MDL = 0.1
no limit
----------------------------
Chlorides (AL)
NC
230 FW(7Q10s)
mg/L
0 0
N/A
Acute: NO WQS
—_ _ ---_ _
-Chronic: —--
3,197.7
n/a
----------------------------
Chlorinated Phenolic Compounds
NC
1 A(30Q2)
ug/L
0 0
N/A
Acute: NO WQS
-- Ch_ _
ronic:-----13-9 ------------------------------
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: 4,171.0
Max MDL = 1.6
no limit
____________________________
Chromium III
NC
117.7325 FW(7Q10s) 905.0818
µg/L
0 0
N/A
Acute: 10,471.7
—_ _ ---_ _
-Chronic: —--
1,636.9
no limit
----------------------------
Chromium VI
NC
11 FW(7Q10s) 16
µg/L
1 1
Note: n < 9
Limited data set
1.2
Default C.V.
Acute: 185.1
___ _ ______ _______________________________
Chronic: 152.9
No value > Allowable Cw
no limit
Chromium, Total
NC
µg/L
2 1
Note: n < 9
Limited data set
17.8
Default C.V.
no limit
Page 16 of 59
NC0004987_Worksheets_20220414.xlsm, rpa
4/18/2022

Marshall Steam Station
NC0004987
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall Outfall 002
Qw = 3 MGD
Copper (AL)
NC
7.8806 FW(7Q10s) 10.4720
ug/L
58 20
3.62
Acute: 121.16
—_ _ - — -_ _ _ --
-Chronic:—109 57
No value > Allowable Cw
no limit
---—-—-—-—-—-—-—-—-—-—-—-—-
Cyanide
NC
5 FW(7Q10s) 22
10
ug/L
1 0
Note: n < 9
Limited data set
NO DETECTS
Acute: 254.5
___ _ _ _________
Chronic: 69.5
Max MDL = 10
no limit
___________________________
Fluoride
NC
1800 FW(7Q10s)
ug/L
0 0
N/A
Acute: NO WQS
—_ _ --- _ _ _
-Chronic: —
25,025.8
n/a
---------------------------
Lead
NC
2.9416 FW(7Q10s) 75.4871
ug/L
1 0
Note: n < 9
Limited data set
NO DETECTS
Acute: 873.378
___ _ ____ _ ___
Chronic: 40.898
Max MDL = 1
no limit
___________________________
Mercury
NC
12 FW(7Q10s)
0.5
ng/L
58 37
2.5
Acute: NO WQS
—_ _ ---- _ _
-Chronic:-166.8 --
No value > Allowable Cw
no limit
---------------------------
Molybdenum
NC
2000 HH(7Q10s)
ug/L
0 0
N/A
Acute: NO WQS
_ _ _ _
--Chronic: --- 27,806.5 —
n/a
---—-—-—-—-—-—-—-—-—-—-—-—-
Nickel
Nickel
NC
NC
37.2313 FW(7Q10s) 335.2087
25.0000 WS(7Q10s)
jig/
µg/L
1 1
Note: n < 9
Limited data set
6.2
Default C.V.
Acute (FW): 3'878.3
_ _ __ _ __
Chronic (FW)_517.6
N_ov_alue>_Allow_able_Cw
_______________________________________
Chronic (WS): 347.6
No value > Allowable Cw
no limit
___________________________
Selenium
NC
5 FW(7Q10s) 56
ug/L
58 58
12.5
Acute: 647.9
_
--Chronic:_ -----69-5 --
No value > Allowable Cw
no limit
---------------------------
Silver(AL)
NC
0.06 FW(7Q10s) 0.2964
ug/L
1 0
Note: n < 9
Limited data set
NO DETECTS
Acute: 3.429
___ _ ____ _ ______________________________
Chronic: 0.834
Max MDL = 1
no limit
Zinc (AL)
NC
126.7335 FW(7Q10s) 125.7052
ug/L
1 0
Note: n <9
Limited data set
NO DETECTS
Acute: 1,454.4
_ _ _ _
Chronic: ---- _ _--
1,762.0
Max MDL = 5
no limit
---------------------------
Aluminum
NC
6500 WS(7Q10s)
µg/L
0 0
N/A
Acute: NO WQS
___ _ __ _ _ _ _
Chronic: 90370.96774
n/a
____________________________
Boron
NC
7 WS(7Q10s)
mg/L
1 1
Note: n < 9
Limited data set
3.96000
Default C.V.
Acute: NO WQS
___ _ ____ _ _
Chronic: 97.32258
No value > Allowable Cw
no limit
___________________________
IAcute:
NO WQS
r,,, ';m;+
Page 17 of 59
NC0004987_Worksheets_20220414.xlsm, rpa
4/18/2022

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

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
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
1.00
..59
1.92
2.63
3.55
../3
6.20
7.98
10.11
12.60
1S.47
18.72
22.35
26.38
30.78
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
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
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
5
1.00
1.16
1.35
1.56
1.80
2.05
2.32
2.61
2.91
3.23
3.55
3.87
4.21
4.54
4.88
6
1.00
1.15
1.31
1.50
1.70
1.91
2.14
2.38
2.63
2.88
3.14
3.40
3.66
3.92
4.18
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
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
9
1.00
1.11
1.24
1.37
1.51
1.6E
1.81
1.97
2.12
2.28
2.44
2.60
2.75
2.90
3.05
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
RPMFs as
f(n,CV,Confidence,U pperBound)
400.00
350.00
300.00 ---''''''
0
250.00
u_
c
0
fa 200.00
u
t.
150.00 -//
100.00 /'
50.00
0.00
1 4 7 10 13 16 19 22 25
0.1
350.00-400.00
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

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
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
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
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
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
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
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
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
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
3.20
3.34
3.49
3.62
3.76
3.89
4.02
4.15
4.27
4.40
1-.52
4.63
4.75
4.86
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
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
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
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
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
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
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.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
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
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
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
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
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
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
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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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

Coefficient of Variation
2.9
3.0
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4.0
137.76
147.21
156.91
166.84
177.00
187.38
197.98
208.78
219.79
231.00
242.40
253.99
36.63
38.45
40.28
42.13
43.99
45.86
47.74
49.64
51.54
53.44
55.36
57.28
19.41
20.21
21.00
21.79
22.58
23.36
24.15
24.94
25.72
26.50
27.28
28.06
13.00
13.45
13.91
14.36
14.81
15.25
15.70
16.14
16.58
17.01
17.44
17.87
9.75
10.05
10.36
10.65
10.95
11.24
11.53
11.82
12.10
12.38
12.66
12.94
7.82
8.04
8.25
8.47
8.68
8.89
9.10
9.30
9.50
9.70
9.90
10.09
6.54
6.71
6.88
7.04
7.20
7.36
7.51
7.67
7.82
7.97
8.12
8.26
5.64
5.78
5.91
6.03
6.16
6.29
6.41
6.53
6.65
6.77
6.88
6.99
4.97
5.08
5.19
5.29
5.40
5.50
5.60
5.69
5.79
5.88
5.98
6.07
4.46
4.55
4.64
4.72
4.81
4.89
4.97
5.06
5.13
5.21
5.29
5.36
4.05
4.12
4.20
4.27
4.34
4.41
4.48
4.55
4.62
4.68
4.75
4.81
3.71
3.78
3.84
3.90
3.97
4.03
4.09
4.15
4.20
4.26
4.31
4.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
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.00
3.04
3.09
3.13
3.17
3.21
3.25
3.29
3.33
3.36
3.40
3.44
2.83
2.86
2.90
2.94
2.98
3.01
3.05
3.08
3.12
3.15
3.18
3.21
2.67
2.71
2.74
2.78
2.81
2.84
2.87
2.90
2.93
2.96
2.99
3.02
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.42
2.45
2.48
2.51
2.53
2.56
2.58
2.61
2.63
2.66
2.68
2.70
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.22
2.24
2.27
2.29
2.31
2.33
2.35
2.37
2.39
2.41
2.43
2.45
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.05
2.07
2.09
2.11
2.13
2.15
2.16
2.18
2.20
2.21
2.23
2.24
1.98
2.00
2.02
2.03
2.05
2.07
2.08
2.10
2.11
2.13
2.14
2.16
1.91
1.93
1.95
1.96
1.98
1.99
2.01
2.02
2.04
2.05
2.06
2.08
1.85
1.87
1.88
1.90
1.91
1.93
1.94
1.95
1.97
1.98
1.99
2.00
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.74
1.76
1.77
1.78
1.79
1.81
1.82
1.83
1.84
1.85
1.86
1.87
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.65
1.66
1.67
1.68
1.69
1.70
1.71
1.72
1.73
1.74
1.75
1.76
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.57
1.58
1.59
1.60
1.60
1.61
1.62
1.63
1.64
1.64
1.65
1.66
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.49
1.50
1.51
1.52
1.53
1.53
1.54
1.55
1.55
1.56
1.57
1.57
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.43
1.44
1.44
1.45
1.46
1.46
1.47
1.47
1.48
1.48
1.49
1.49
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.37
1.38
1.38
1.39
1.39
1.40
1.40
1.41
1.41
1.42
1.42
1.43
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.32
1.32
1.33
1.33
1.34
1.34
1.35
1.35
1.35
1.36
1.36
1.37

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.27
1.28
1.28
1.28
1.29
1.29
1.29
1.30
1.30
1.30
1.31
1.31
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.23
1.23
1.23
1.24
1.24
1.24
1.25
1.25
1.25
1.25
1.26
1.26
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.19
1.19
1.19
1.20
1.20
1.20
1.20
1.21
1.21
1.21
1.21
1.21
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.15
1.15
1.16
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.17
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.12
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.13
1.13
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.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.10
1.10
1.10
1.10
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.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
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.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
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.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
2.9
3.0
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4.0

Coefficient of Variation
4.1
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.9
5.0
5.1
5.2
265.76
277.71
289.83
302.12
314.57
327.19
339.96
352.88
365.95
379.17
392.53
406.03
59.21
61.15
63.09
65.03
66.98
68.93
70.89
72.85
74.81
76.78
78.75
80.72
28.84
29.61
30.38
31.15
31.92
32.68
33.44
34.20
34.96
35.72
36.47
37.22
18.30
18.72
19.14
19.56
19.98
20.39
20.80
21.21
21.61
22.02
22.42
22.82
13.21
13.48
13.75
14.02
14.28
14.55
14.81
15.06
15.32
15.57
15.82
16.07
10.29
10.48
10.66
10.85
11.04
11.22
11.40
11.58
11.76
11.93
12.10
12.28
8.41
8.55
8.69
8.83
8.96
9.10
9.23
9.37
9.50
9.63
9.75
9.88
7.11
7.22
7.33
7.43
7.54
7.65
7.75
7.85
7.95
8.05
8.15
8.25
6.16
6.25
6.34
6.42
6.51
6.59
6.67
6.76
6.84
6.91
6.99
7.07
5.44
5.51
5.58
5.65
5.72
5.79
5.86
5.93
5.99
6.06
6.12
6.19
4.87
4.94
5.00
5.05
5.11
5.17
5.23
5.28
5.34
5.39
5.44
5.50
4.42
4.47
4.52
4.57
4.62
4.67
4.72
4.77
4.81
4.86
4.90
4.95
4.05
4.09
4.14
4.18
4.22
4.26
4.30
4.35
4.38
4.42
4.46
4.50
3.74
3.77
3.81
3.85
3.89
3.92
3.96
3.99
4.03
4.06
4.10
4.13
3.47
3.51
3.54
3.57
3.60
3.64
3.67
3.70
3.73
3.76
3.79
3.82
3.24
3.28
3.30
3.33
3.36
3.39
3.42
3.44
3.47
3.50
3.52
3.55
3.05
3.08
3.10
3.13
3.15
3.18
3.20
3.23
3.25
3.27
3.30
3.32
2.88
2.90
2.92
2.95
2.97
2.99
3.01
3.03
3.06
3.08
3.10
3.12
2.72
2.75
2.77
2.79
2.81
2.83
2.85
2.87
2.89
2.90
2.92
2.94
2.59
2.61
2.63
2.65
2.66
2.68
2.70
2.72
2.73
2.75
2.77
2.78
2.47
2.49
2.50
2.52
2.54
2.55
2.57
2.58
2.60
2.61
2.63
2.64
2.36
2.37
2.39
2.41
2.42
2.44
2.45
2.46
2.48
2.49
2.50
2.52
2.26
2.27
2.29
2.30
2.32
2.33
2.34
2.36
2.37
2.38
2.39
2.40
2.17
2.18
2.20
2.21
2.22
2.23
2.25
2.26
2.27
2.28
2.29
2.30
2.09
2.10
2.11
2.12
2.13
2.15
2.16
2.17
2.18
2.19
2.20
2.21
2.01
2.02
2.03
2.04
2.06
2.07
2.08
2.09
2.09
2.10
2.11
2.12
1.94
1.95
1.96
1.97
1.98
1.99
2.00
2.01
2.02
2.03
2.04
2.04
1.88
1.89
1.90
1.91
1.91
1.92
1.93
1.94
1.95
1.96
1.96
1.97
1.82
1.83
1.84
1.84
1.85
1.86
1.87
1.88
1.88
1.89
1.90
1.90
1.76
1.77
1.78
1.79
1.79
1.80
1.81
1.82
1.82
1.83
1.84
1.84
1.71
1.72
1.73
1.73
1.74
1.75
1.75
1.76
1.77
1.77
1.78
1.78
1.66
1.67
1.68
1.68
1.69
1.70
1.70
1.71
1.71
1.72
1.72
1.73
1.62
1.63
1.63
1.64
1.64
1.65
1.65
1.66
1.66
1.67
1.67
1.68
1.58
1.58
1.59
1.59
1.60
1.60
1.61
1.61
1.62
1.62
1.63
1.63
1.54
1.54
1.55
1.55
1.56
1.56
1.57
1.57
1.58
1.58
1.58
1.59
1.50
1.50
1.51
1.51
1.52
1.52
1.53
1.53
1.53
1.54
1.54
1.55
1.46
1.47
1.47
1.48
1.48
1.49
1.49
1.49
1.50
1.50
1.50
1.51
1.43
1.43
1.44
1.44
1.45
1.45
1.45
1.46
1.46
1.46
1.47
1.47
1.40
1.40
1.41
1.41
1.41
1.42
1.42
1.42
1.43
1.43
1.43
1.43
1.37
1.37
1.38
1.38
1.38
1.38
1.39
1.39
1.39
1.40
1.40
1.40

1.34
1.34
1.35
1.35
1.35
1.35
1.36
1.36
1.36
1.37
1.37
1.37
1.31
1.32
1.32
1.32
1.32
1.33
1.33
1.33
1.33
1.34
1.34
1.34
1.29
1.29
1.29
1.29
1.30
1.30
1.30
1.30
1.31
1.31
1.31
1.31
1.26
1.26
1.27
1.27
1.27
1.27
1.28
1.28
1.28
1.28
1.28
1.28
1.24
1.24
1.24
1.24
1.25
1.25
1.25
1.25
1.25
1.26
1.26
1.26
1.22
1.22
1.22
1.22
1.22
1.22
1.23
1.23
1.23
1.23
1.23
1.23
1.19
1.20
1.20
1.20
1.20
1.20
1.20
1.21
1.21
1.21
1.21
1.21
1.17
1.18
1.18
1.18
1.18
1.18
1.18
1.18
1.18
1.19
1.19
1.19
1.15
1.15
1.16
1.16
1.16
1.16
1.16
1.16
1.16
1.16
1.17
1.17
1.13
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.15
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.13
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.11
1.11
1.11
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.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
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.03
1.03
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
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.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
4.1
4.2
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
419.66
433.43
447.33
461.35
475.50
489.76
504.15
518.65
533.27
1
82.69
84.67
86.64
88.62
90.60
92.58
94.56
96.54
98.52
2
37.97
38.71
39.46
40.20
40.93
41.67
42.40
43.13
43.86
3
23.21
23.61
24.00
24.39
24.77
25.16
25.54
25.92
26.30
4
16.32
16.56
16.81
17.05
17.29
17.53
17.76
18.00
18.23
5
12.45
12.62
12.78
12.95
13.11
13.28
13.44
13.60
13.76
6
10.01
10.13
10.25
10.37
10.49
10.61
10.73
10.85
10.96
7
8.34
8.44
8.53
8.63
8.72
8.81
8.90
8.99
9.08
8
7.15
7.22
7.30
7.37
7.44
7.52
7.59
7.66
7.73
9
6.25
6.31
6.37
6.43
6.49
6.55
6.61
6.66
6.72
10
5.55
5.60
5.65
5.70
5.75
5.80
5.85
5.89
5.94
11
4.99
5.03
5.08
5.12
5.16
5.20
5.24
5.28
5.32
12
4.54
4.57
4.61
4.65
4.68
4.72
4.75
4.78
4.82
13
4.16
4.19
4.22
4.26
4.29
4.32
4.35
4.37
4.40
14
3.84
3.87
3.90
3.93
3.95
3.98
4.00
4.03
4.05
15
3.57
3.60
3.62
3.65
3.67
3.69
3.71
3.74
3.76
16
3.34
3.36
3.38
3.40
3.42
3.44
3.46
3.48
3.50
17
3.14
3.16
3.17
3.19
3.21
3.23
3.25
3.26
3.28
18
2.96
2.97
2.99
3.01
3.02
3.04
3.06
3.07
3.09
19
2.80
2.81
2.83
2.84
2.86
2.87
2.89
2.90
2.91
20
2.66
2.67
2.68
2.70
2.71
2.72
2.74
2.75
2.76
21
2.53
2.54
2.56
2.57
2.58
2.59
2.60
2.61
2.63
22
2.42
2.43
2.44
2.45
2.46
2.47
2.48
2.49
2.50
23
2.31
2.32
2.33
2.34
2.35
2.36
2.37
2.38
2.39
24
2.22
2.23
2.24
2.25
2.25
2.26
2.27
2.28
2.29
25
2.13
2.14
2.15
2.16
2.16
2.17
2.18
2.19
2.20
26
2.05
2.06
2.07
2.07
2.08
2.09
2.10
2.10
2.11
27
1.98
1.99
1.99
2.00
2.01
2.01
2.02
2.03
2.03
28
1.91
1.92
1.92
1.93
1.94
1.94
1.95
1.95
1.96
29
1.85
1.85
1.86
1.87
1.87
1.88
1.88
1.89
1.89
30
1.79
1.80
1.80
1.81
1.81
1.82
1.82
1.83
1.83
31
1.74
1.74
1.75
1.75
1.76
1.76
1.76
1.77
1.77
32
1.68
1.69
1.69
1.70
1.70
1.71
1.71
1.72
1.72
33
1.64
1.64
1.65
1.65
1.65
1.66
1.66
1.67
1.67
34
1.59
1.60
1.60
1.60
1.61
1.61
1.61
1.62
1.62
35
1.55
1.55
1.56
1.56
1.56
1.57
1.57
1.57
1.58
36
1.51
1.51
1.52
1.52
1.52
1.53
1.53
1.53
1.54
37
1.47
1.48
1.48
1.48
1.48
1.49
1.49
1.49
1.50
38
1.44
1.44
1.44
1.45
1.45
1.45
1.45
1.46
1.46
39
1.40
1.41
1.41
1.41
1.41
1.42
1.42
1.42
1.42
40

1.37
1.37
1.38
1.38
1.38
1.38
1.39
1.39
1.39
41
1.34
1.34
1.35
1.35
1.35
1.35
1.35
1.36
1.36
42
1.31
1.32
1.32
1.32
1.32
1.32
1.32
1.33
1.33
43
1.29
1.29
1.29
1.29
1.29
1.29
1.30
1.30
1.30
44
1.26
1.26
1.26
1.26
1.27
1.27
1.27
1.27
1.27
45
1.24
1.24
1.24
1.24
1.24
1.24
1.24
1.24
1.25
46
1.21
1.21
1.21
1.22
1.22
1.22
1.22
1.22
1.22
47
1.19
1.19
1.19
1.19
1.19
1.19
1.20
1.20
1.20
48
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
49
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
50
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
51
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
52
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
54
1.05
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
55
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
57
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
58
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 w
Additional messages will appear to alert user if more than 58 data points were enter and no predicted va
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)", "30Q
3) automatically assigns the entered chronic IWC % to the "IWC @ 7Q10s", "IWC @ 7Q10'
3) "1 Q10s (cfs)" automatically defaults to no acute dilution, acute IWC = 100% ,"IWC @ 1(
B. When Model is not applied (Check box NOT activated):
1) assumes user will insert appropriate flow values for "7Q1 Os (cfs)", "7Q1 Ow (cfs)", "30Q
3) automatically calculates chronic -based IWC % for the "IWC @ 7Q10s", "IWC @ 7Q10w
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
C. When paremeter's "Impaired?" check box is activated:
1) automtically activtes the "IMPAIRED" message alert on the "RPA" page for that paramet(
2) does NOT make any automatic adjustements to WQS calculations
NOTE: If new or expanding discharge and receiving stream impaired, will need to evaluate i
10/30/2013 rdb
1) Amended "ERR' alert on data sets entreies to activate if "<" entered but no value entered, does not (
2) Added new calculation feature to count nondetects when both "<" and a value are entered for each da
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" (sums
(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 ei
- New display only for calculated "Effluent Hardness (Median)" including conditional method for info displ
- New display only for designed "HUC Hardness (Median)" incuding conditionla method for info display, I
- New display only for calculated "Combined Hardness Chronic" for metal translator application, brown h
- New display only for calculated "Combined Hardness Acute" for metal translator application, brown high
- 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, Ch
- 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, J
- 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 condit
c) "Modifier" input display only based on "WQS" selection including conditional method for ir
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 ba
c) "Modifier" input display only based on "WQS" selection including conditional method for ir
d) "Name" display only based on "WQS" selection including conditional metdod fro info disp
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 ba
c) "Modifier" input display only based on "WQS" selection including conditional method for ir
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 condit
c) "Modifier" input display only based on "WQS" selection including conditional method for ir
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 t
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
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, conditions
- 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
- 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 ro
b) "Allowable Cw" Acute" and "Chronic" conditional metfhod revised fro info display inculdinc
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
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 di
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 % vale
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 de
2) Revised "RPA" all parameters Max Pred CW cell formatting to display "NO DETECTS" when require
3) Revised "RPA" alert message (under Chronic labels) conditional statement to display "Max MDL = <2
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 statemer
1/21-29/16:
1) Expanded parameter list and program features to add two additional parameters, (Par08) "Chromium
new corresponding RPA evalutaion, non -detect evaluation, formulas for each new data input section; a
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", "Chroi
3) Corrected Arsenic - Aquatic Life, Berylium Chronic and Acute values on "Input" tab to be exported fror
4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (I-
5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formula;
6) Revised "RPA" tab Chromium, Total Reasonable Potential Results section to remove Acute and Chroi
7) Revised "RPA" tab Chromium III and Chromium VI Reasonable Potential Results sectons to remove c
formulas that reference Chromium, Total display and data.
NOTE: All RPA evaluation data is generated on each parameter "Data" section and imported to that pare
8) Revised "RPA" tab Acute and Chronic conditional formulas for active parameters to display either "/W
9) Removed label from "Input" tab.
10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Me
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
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 r
Revised "data" page Effluent Hardness (Median) cell formula to display 99 whenstream class is WS and
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
exceeds 99.999 mg/L)
revised the existing calculation input/display cells for Effluent & HUC Hardness Median to show the applil
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 El
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, d
Added Nickel WS parameter to "input" page
Added Nichel WS to "rpa" page, revised both Nickel parametesr to share commom data, Nickel WS has
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. Whe

ere estbalished to allow only 58 data point entries.
ues will be calculated
2 (cfs)", "QA (cfs)" to define chronic dilution in terms of "IWC %", "IWC %" is the same for all stream flows
w", "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page)
)10s" = 100% which is used in acute WQS calculatons (See "RPA" page)
2 (cfs)", "QA (cfs)" , "Flow Qw (MGD)" for chronic IWC % calculations, IWC % will vary according to flows
"IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page)
WQS calculations (See "RPA" page)
r? J
f additional waste load is allowed
?ffect RPA calculation, ERR message only
to set, used to calculate detected entries
mary of translator formulas, metals impacted, general info), "Dss to Total Hardness Calculator"
ntry, brown highlight
ay, brown highlight
Irown highlight
ighlight
flight
lorides, Molybdeum, Nickel

kcute = "N/A"
Tonal method for info display based on "WQS" selection, no rounding
go dispaly
ised on "WQS" selection
go dispaly
ay
ised on "WQS" selection
go dispaly
ional method for info display based on "WQS" selection, no rounding
go dispaly
:his section for used to calculate eflluent hardness factors
for info display

[I method for info display
�w
unding
rounding value
and added drop down menu feature
splayed)
ue
Ita set has all no detects
d to display no detects
x max adjusted data set value>" when data set has all no detects

its to have cell display blank if WQS is blank or WQS displays "NO DATA"
III" & (Par09) "Chromium VI". This included adding two new data input sections on "Data" tab with
dding two new parameter summary sections to "RPA" tab; revising exsiting parameter designation
mium, Total". All features and programing unique to each display was revised accordingly.
n metal translator table.
IUC Hard Med = NA mg/I)" when HUC hardness is NA.
to assign 25 as hardness value when HUC hardness is NA.
nic labels and allowable Cw calulation/display, area now blank except for MDL feature display.
lisplay of values for n, #Det, Max Pred Cw, area blank except for display features from added condtional
Lmeter's "RPA" section, thus, RPA evaluation data can be displayed/used when programmed to do so.
C?" or "IWC/DATA?" as default until appropraite data is provided.
lhod 625.
7Q10s flow when model feature NOT activated and 7Q10s flow displayed
Vied = <actual value> mg/L)" when stream class is WS and Effluent Hard Med is greater than 99.999 mg/L
Effluent Hard Med is greater than 99.999 mg/L
Supply Criterion" when applicable (stream class is Water Supply based and Efflunet Hard Med
ed hardness value based on new conditional formula as follows
(fluent Hard Med to 99 mg/L
foes NOT set parameter modifiers, still must do modifers individually
no Acute standard so only list acute for FW

in in print mode set up, will need to designate "Print Selection".

River Basin
HUC
Hardness
Total Su
Stations
Samples
10th Percentile
Median
Mean
Stations
Samples
03010102
4
188
28
90.5
83.4
1
8
Roanoke
03010103
12
720
14
21.5
24.3
5
40
03010104
18
851
24
35
36.6
4
32
River
03010106
5
118
18
29
32.3
1
8
03010107
11
856
24
30
33.6
6
47
03010201
0
0
NA
NA
NA
0
0
03010202
1
73
28
38
42.6
1
8
:howan Rive
03010203
12
633
18
28
36.2
5
40
03010204
3
146
20
30
31.6
2
16
03010205
21
252
40
96
203.2
2
15
03020101
17
1021
19
28
31.8
9
72
Tar-03020102
3
172
20
26.5
29.5
1
8
Pamlico
03020103
12
818
23
35
60.2
6
47
03020104
1
88
10
16
20.9
7
293
River
03020105
0
0
NA
NA
NA
0
0
03020106
1
120
30
60
153.1
1
9
03020201
48
2361
20
34
43.8
17
136
Neuse
03020202
9
643
20
30
35.7
6
41
River
03020203
14
573
16
26
31.3
4
32
03020204
6
147
32
60
68.9
1
8
White Oak
03020301
0
0
NA
NA
NA
0
0
River
03020302
3
221
45.2
93
357.0
2
18
03030002
56
2695
26
44
48.8
17
315
03030003
33
1637
24
43
53.4
9
65
Cape Fear
03030004
22
1240
6
19
21.4
7
55
River
03030005
16
1054
18
26
83.6
6
49
03030006
17
760
12
23
33.1
7
57
03030007
17
657
24
40
56.0
8
63
03040101
22
1380
10
20
25.8
12
187
03040102
7
473
16
34
33.9
5
68
Yadkin -Pee
03040103
42
1527
22
42
78.4
9
84
Dee River
03040104
14
563
11.4
22
26.5
4
31
03040105
24
875
31
46
51.3
9
97
03040201
10
329
11.64
22
23.6
4
31
03040202
0
0
NA
NA
NA
0
0
Lumber
03040203
58
1346
5
12
15.2
8
61
03040204
23
362
5
7
15.0
2
16
River
03040206
25
503
7
20
31.1
3
27
03040208
0
0
NA
NA
NA
1
8
Catawba
03050101
63
2861
7
14
26.2
15
91
03050102
18
1230
8
22
27.4
9
72
River
03050103
14
966
38
67
67.2
5
40
Broad River
03050105
24
1011
9
17
21.2
8
63
Savannah
03060101
1
116
3
5
5.7
1
10
River
03060102
0
0
NA
NA
NA
0
0
New River
05050001
9
707
12
20
22.1
8
46
Jatauga Rive
06010103
6
322
12
20
21.8
2
15
French
06010105
30
1854
4
10
11.3
14
91
Broad
06010106
13
982
3
9
23.0
6
49
River
06010108
12
744
3
12
12.3
5
34
Little
06010202
12
567
4
8
8.2
3
24
Tennessee
06010203
7
310
4
7
8.9
1
8

River
Hiwassee
River
notes:
152
272
0
5
5
NA
9
10
NA
10.0
12.5
NA
1
3
0
8
17
0
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 databa!
3. This table was constructed using all available data in STORET for the State of North Carolina, 12/;
06010204 7
06020002 13
06020003 0
816

spended Sol'ds (TSS)
10th Percentile
Median
Mean
6.2
6.2
8.8
6.2
6.9
45.6
6.2
6.2
18.0
6.2
6.2
7.9
6.2
6.2
11.5
NA
NA
NA
6.2
6.2
6.6
6.2
6.2
6.4
6.2
6.2
8.9
6.2
6.2
7.2
6.2
6.2
9.3
6.2
6.2
6.2
6.2
6.2
9.8
6.2
6.2
15.9
NA
NA
NA
6.2
6.2
7.5
6.2
6.2
9.7
6.2
7.2
13.2
6.2
6.2
6.2
6.2
6.2
6.2
NA
NA
NA
6.2
6.2
6.2
6.2
7.8
14.8
6.2
6.2
38.8
6.2
6.2
10.0
6.2
7.2
12.3
6.2
6.2
6.5
6.2
6.2
6.6
6.2
8.8
25.6
6.2
13
29.1
6.2
11
19.3
6.2
6.2
10.2
6.2
6.2
26.6
6.2
6.2
10.5
NA
NA
NA
6.2
6.2
7.5
6.2
6.2
6.7
6.2
6.2
7.1
8.8
16
15.9
6.2
6.2
19.6
6.2
6.35
21.1
6.2
6.2
9.6
6.2
6.2
13.0
6.2
6.2
6.3
NA
NA
NA
6.2
6.2
33.8
6.2
6.2
6.5
6.2
6.2
18.6
6.2
6.2
8.1
6.2
6.2
16.2
6.2
6.2
11.5
6.2
6.2
8.2

6.2
6.2
NA
6.2
6.2
NA
9.0
8.5
NA
;e.
!0/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 = 0301010
Receiving
Stream
summer
7Q10 (CFS)
Receiving
Stream
summer 7Q10
(MGD)
Rec. Stream
1Q10
[MGD]
NPDES
Flow Limit
[MGD]
Total Suspended
Solids
-Fixed Value -chronic
(mg/L)
Combined
Hardness
(mg/L)
Combined
Hardness
Acute
(mg/L)
Instream
Wastewater
Concentration
(Chronic)
Instream
Wastewater
Concentration
(Acute)
8-digit HUC
Hardness Median
(mg/L)
Effluent
Hardness
Median
(mg/L)
60.0000
38.7097
31.7097
3.0000
10
25.000
25.000
7.1926
8.6431
I 25
I 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)
0.15
0.82
0.252
0.59
3.24
Cd -Trout streams
0.15
0.51
0.252
0.59
2.01
Chromium III (d)(h)
24
183
0.202
117.73
905.08
Chromium VI (d)
11
16
1.000
11.00
16.00
Chromium, Total (t)
N/A
N/A
Copper (d)(h)
2.7
3.6
0.348
7.88
10.47
Lead (d)(h)
0.54
14
0.184
2.94
75.49
Nickel (d)(h)
16
145
0.432
37.23
335.21
Ni - WS streams (t)
25 N/A
Silver (d)(h,acute)
Zinc (d)(h)
0.06
36
0.30
36
1.000
0.288
0.06 0.30
126.73 125.71
Beryllium
6.5
Arsenic (d)
150
65
1.000
6.5
65
340
1.000
150
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.