NC0025135_Worksheets_20220926

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
1.RPA Exists
Monitor Monthly and add Permit Limit
2.RPA Exists but Action Levels (Cu, Zn, Ag ,Fe, Cl)
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? 550% of Allowable) _Monitor
Quarterly (or defer to Pretreat I
5.No RPA (Predicted Max < 50% Allo viable)
No Monitoring
6a.No Data (New Permit, New Waste Stream)
6b. New Greensand or Conventional WTP
Monitor Monthly for Toxic Pollutants o,
Monitor Quarterly for Toxic Pollutants
password all sheets = rpa2017
4/28/16: Note Action Level designation no longer allowed per EPA.
11/20/17 Chlorides still listed as have action levels but will be coorected at next EPA review
ions:

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

'ox Test
:,TMP)
f Concern
of Concem

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
HUC Number
Stream Class
Huffman Finishing Company
C
II
NC0025135
001
0.250
Catawba River (Hickory Lake)
WS-IV, B, CA
0 Apply WS Hardness WQC
7Q10s (cfs)
7Q1Ow (cfs)
30Q2 (cfs)
QA (cfs)
1Q1Os (cfs)
40.00
40.00
40.00
C
40.00
32.86
Effluent Hardness
Upstream Hardness
Combined Hardness Chronic
Combined Hardness Acute
25 mg/L (Avg)
25 mg/L (Avg)
25 mg/L
25 mg/L
Data Source(s)
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
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
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
Aquatic Life
NC
0.06
FW
0.2964
ug/L
Zinc
Aquatic Life
NC
126.7335
FW
125.7052
ug/L
Antimony
Water Supply
C
5.6
WS
pg/L
Sulfide
Aquatic Life
NC
0.21
FW
pg/L
NC0025135_Worksheets_20220926, input
12/12/2022

NC0025135_Worksheets_20220926, input
12/12/2022

REASONABLE POTENTIAL ANALYSIS
H1
Effluent Hardness
Date Data BDL=1/2DL Results
1 25 25 Std Dev.
2 Mean
3 C.V.
4 n
5 10th Per value
6 Average 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
H2
Upstream Hardness
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 25 25 Std Dev.
2 Mean
3 C.V.
4 n
5 10th Per value
6 Average 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
N/A
25.0000
0.0000
1
25.00 mg/L
25.00 mg/L
25.00 mg/L
- 3 -
NC0025135_Worksheets_20220926, data
12/12/2022

REASONABLE POTENTIAL ANALYSIS
Par01 & Par02
Arsenic
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
NO DATA
NO DATA
NO DATA
0
N/A
N/A ug/L
N/A ug/L
- 4 -
NC0025135_Worksheets_20220926, data
12/12/2022

REASONABLE POTENTIAL ANALYSIS
Par03
Beryllium
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
Par04
Cadmium
NO DATA
NO DATA
NO DATA
0
N/A
N/A ug/L
N/A ug/L
Date Data BDL=1/2DL Results
1 < 2 1 Std Dev.
2 Mean
3 C.V. (default)
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
N/A
1.0000
0.6000
1
6.20
1.000 ug/L
6.200 ug/L
- 5 -
NC0025135_Worksheets_20220926, data
12/12/2022

REASONABLE POTENTIAL ANALYSIS
Par05
Chlorides
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
- 6 -
NC0025135_Worksheets_20220926, data
12/12/2022

REASONABLE POTENTIAL ANALYSIS
,ECIAL•
:OPY"
lata
Par07
Total Phenolic Compounds
Date Data BDL=1/2DL Results
1 3.597 3.5971223 Std Dev.
2 3.597 3.5971223 Mean
3 4.796 4.79616307 C.V.
4 3.597 3.5971223 n
5 4.796 4.79616307
6 3.597 3.5971223 Mult Factor =
ug/L 7 4.796 4.79616307 Max. Value
ug/L 8 3.597 3.5971223 Max. Pred Cw
9 3.597 3.5971223
10 3.597 3.5971223
11 4.796 4.79616307
12 4.796 4.79616307
13 3.597 3.5971223
14 3.597 3.5971223
15 15.59 15.58753
16 23.98 23.9808153
17 14.39 14.3884892
18 3.597 3.5971223
19 4.796 4.79616307
20 3.597 3.5971223
21 5.995 5.99520384
22 3.597 3.5971223
23 9.592 9.59232614
24 4.796 4.79616307
25 10.79 10.7913669
26 13.19 13.1894484
27 4.796 4.79616307
28 11.99 11.9904077
29 10.79 10.7913669
30 5.995 5.99520384
31 5.995 5.99520384
32 3.597 3.5971223
33 4.796 4.79616307
34 5.995 5.99520384
35 4.796 4.79616307
36 5.995 5.99520384
37 5.995 5.99520384
38 4.796 4.79616307
39 4.796 4.79616307
40 3.597 3.5971223
41 5.995 5.99520384
42 9.592 9.59232614
43 5.995 5.99520384
44 5.995 5.99520384
45 11.99 11.9904077
46 3.597 3.5971223
47 4.796 4.79616307
48 5.995 5.99520384
49 4.796 4.79616307
50 5.995 5.99520384
51 5.995 5.99520384
52 4.796 4.79616307
53 4.796 4.79616307
54 9.592 9.59232614
55 3.597 3.5971223
56 5.995 5.99520384
57 4.796 4.79616307
58 4.796 4.79616307
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
3.7653
6.2640
0.6011
58
1.00
24.0 ug/L
24.0 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
- 7 -
NC0025135_Worksheets_20220926, data
12/12/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
iata
;8
Par09
Chromium VI
1
2
3
4
5
6
fag/L 7
fag/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
Mult Factor =
Max. Value
Max. Pred Cw
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par10
Total
Chromium, Tot
NO DATA
NO DATA
NO DATA
0
N/A
N/A fag/L
N/A fag/L
Date Data BDL=1/2DL
1 29.9760192
2 45.5635492
3 51.558753
4 239.808153
5 3.5971223
6 68.3453237
7 83.9328537
8 46.7625899
9 83.9328537
10 71.942446
11 26.3788969
12 47.9616307
13 33.5731415
14 39.5683453
15 9.59232614
16 33.5731415
17 58.7529976
18 45.5635492
19 28.7769784
20 39.5683453
21 20.383693
22 31.17506
23 20.383693
24 9.59232614
25 47.9616307
26 20.383693
27 29.9760192
28 68.3453237
29 71.942446
30 20.383693
31 29.9760192
32 43.1654676
33 25.1798561
34 19.1846523
35 5.99520384
36 5.99520384
37 51.558753
38 40.7673861
39 23.9808153
40 25.1798561
41 25.1798561
42 14.3884892
43 23.9808153
44 16.7865707
45 50.3597122
46 27.5779376
47 39.5683453
48 33.5731415
49 13.1894484
50 40.7673861
51 21.5827338
52 27.5779376
53 19.1846523
54 20.383693
55 26.3788969
56 28.7769784
57 37.1702638
58 34.7721823
29.98
45.56
51.56
239.8
3.597
68.35
83.93
46.76
83.93
71.94
26.38
47.96
33.57
39.57
9.592
33.57
58.75
45.56
28.78
39.57
20.38
31.18
20.38
9.592
47.96
20.38
29.98
68.35
71.94
20.38
29.98
43.17
25.18
19.18
5.995
5.995
51.56
40.77
23.98
25.18
25.18
14.39
23.98
16.79
50.36
27.58
39.57
33.57
13.19
40.77
21.58
27.58
19.18
20.38
26.38
28.78
37.17
34.77
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Results
Std Dev. 32.8029
Mean 37.9558
C.V. 0.8642
n 58
Mult Factor = 1.00
Max. Value 239.8
Max. Pred Cw 239.8
- 8 -
NC0025135_Worksheets_20220926, data
12/12/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Pal 1
Copper
Date Data BDL=1/2DL Results
1 28 28 Std Dev.
2 Mean
3 C.V. (default)
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
28.0000
0.6000
1
6.20
28.00 ug/L
173.60 ug/L
Par12
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Date Data BDL=1/2DL Results
1 < 5 5 Std Dev. N/A
2 Mean 5.00
3 C.V. (default) 0.6000
4 n 1
5
6 Mult Factor = 6.20
7 Max. Value 5.0
8 Max. Pred Cw 31.0
9
Cyanide
- 9 -
NC0025135_Worksheets_20220926, data
12/12/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
Date
< 5
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
BDL=1/2DL Results
2.5 Std Dev. N/A
Mean 2.5000
C.V. (default) 0.6000
n 1
Mult Factor = 6.20
Max. Value 2.500
Max. Pred Cw 15.500
NC0025135_Worksheets_20220926, data
- 10 - 12/12/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par15
Mercury
Date Data BDL=1/2DL Results
1 5.74 5.74 Std Dev.
2 Mean
3 C.V. (default)
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
N/A
5.7400
0.6000
1
6.20
5.7 ng/L
35.6 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
NC0025135_Worksheets_20220926, data
12/12/2022

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
iata
;8
Par17 & Par18
Nickel
Date Data BDL=1/2DL Results
1 6 6 Std Dev.
2 Mean
3 C.V. (default)
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.0000
0.6000
1
6.20
6.0 fag/L
37.2 fag/L
Date Data BDL=1/2DL Results
1 < 5 2.5 Std Dev.
2 Mean
3 C.V. (default)
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
NC0025135_Worksheets_20220926, data
- 12 - 12/12/2022

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par20
Silver
N/A
2.5000
0.6000
1
6.20
2.5 ug/L
15.5 ug/L
Date Data BDL=1/2DL Results
1 < 5 2.5 Std Dev.
2 < 5 2.5 Mean
3 < 5 2.5 C.V.
4 < 5 2.5 n
5 < 5 2.5
6 < 5 2.5 Mult Factor =
7 < 5 2.5 Max. Value
8 < 5 2.5 Max. Pred Cw
9 < 5 2.5
10 < 5 2.5
11 < 5 2.5
12 < 5 2.5
13 < 5 2.5
14 < 5 2.5
15 < 5 2.5
16 < 5 2.5
17 < 5 2.5
18 < 10 5
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
0.5893
2.6389
0.2233
18
1.15
5.000 ug/L
5.750 ug/L
Date Data BDL=1/2DL Results
1 < 10 5 Std Dev.
2 Mean
3 C.V. (default)
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
NC0025135_Worksheets_20220926, data
- 13 - 12/12/2022

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par22
Antimony
N/A
5.0000
0.6000
1
6.20
5.0 ug/L
31.0 ug/L
Date Data BDL=1/2DL Results
1 < 5 2.5 Std Dev.
2 Mean
3 C.V. (default)
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
Sulfide
N/A
2.5000
0.6000
1
Mult Factor = 6.20
Max. Value 2.500000 fag/L
Max. Pred Cw 15.500000 fag/L
Date Data BDL=1/2DL
1 < 50 25
2 < 50 25
3 < 50 25
4 < 50 25
5 < 50 25
6 < 50 25
7 < 50 25
8 < 50 25
9 < 50 25
10 < 50 25
11 < 50 25
12 < 50 25
13 < 50 25
14 < 50 25
15 < 50 25
16 < 50 25
17 < 50 25
18 < 50 25
19 < 50 25
20 < 50 25
21 < 50 25
22 < 50 25
23 < 50 25
24 < 50 25
25 < 50 25
26 < 50 25
27 < 50 25
28 < 50 25
29 < 50 25
30 < 50 25
31 < 50 25
32 < 50 25
33 < 50 25
34 < 50 25
35 < 50 25
36 < 50 25
37 < 50 25
38 < 50 25
39 < 50 25
40 < 50 25
41 < 50 25
42 < 50 25
43 < 50 25
44 < 50 25
45 < 50 25
46 < 50 25
47 < 50 25
48 < 50 25
49 < 50 25
50 < 50 25
51 < 50 25
52 < 50 25
53 < 50 25
54 < 50 25
55 < 50 25
56 < 50 25
57 < 50 25
58 < 50 25
NC0025135_Worksheets_20220926, data
- 14 - 12/12/2022

REASONABLE POTENTIAL ANALYSIS
Results
Std Dev.
Mean
C.V.
n
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par24
0
0.0000
25.0000
0.0000
58
Mult Factor = 1.00
Max. Value 25.000000 fag/L
Max. Pred Cw 25.000000 fag/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 SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par25
0
NO DATA
NO DATA
NO DATA
0
Mult Factor = N/A
Max. Value N/A
Max. Pred Cw N/A
Date Data BDL=1/2DL
NC0025135_Worksheets_20220926, data
- 15 - 12/12/2022

REASONABLE POTENTIAL ANALYSIS
Results
Std Dev.
Mean
C.V.
n
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
NO DATA
NO DATA
NO DATA
0
Mult Factor = N/A
Max. Value N/A
Max. Pred Cw N/A
NC0025135_Worksheets_20220926, data
- 16 - 12/12/2022

Huffman Finishing Company
N C0025135
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
MAXIMUM DATA POINTS = 58
Qw (MGD) = 0.2500
1 Q 10S (cfs) = 32.86
7Q1OS (cfs) = 40.00
7Q 1 OW (cfs) = 40.00
30Q2 (cfs) = 40.00
Avg. Stream Flow, QA (cfs) = 40.00
Receiving Stream: Catawba River (Hickory Lake)
WWTP/WTP Class: II
IWC% @ 1 Q 1 OS = 1.165501166
IWC% @ 7Q1OS = 0.959455277
IWC% @ 7Q 10W = 0.959455277
IWC% @ 30Q2 = 0.959455277
IW%C @ QA = 0.959455277
Stream Class: WS-IV, B, CA
Outfall 001
Qw = 0.25 MGD
COMBINED HARDNESS (mg/L)
Acute = 25 mg/L
Chronic = 25 mg/L
YOU HAVE DESIGNATED THIS RECEIVING
STREAM AS WATER SUPPLY
Effluent Hard: 0 value > 100 mg/L
Effluent Hard Avg = 25 mg/L
PARAMETER
TYPE
NC STANDARDS OR EPA CRITERIA
_1
a
REASONABLE POTENTIAL RESULTS
RECOMMENDED ACTION
Chronic Applied Acute
Standard
11 # Det. Max Pred Cw Allowable Cw
Arsenic
Arsenic
C
C
150 FW(7Q10s) 340
10 FIH/WS(Qavg)
ug/L
ug/L
0 0
N/A
Acute (FW): 29,172.0
Chronic (FW): 15
Chronic (HH): 1,042.3
N/A
Beryllium
NC
6.5 FW(7Q10s) 65
ug/L
0 0
N/A
Acute: 5,577.00
-- _Chr_
onic:-----677-._47 -----------------------------
N/A
Cadmium
NC
0.5899 FW(7Q10s) 3.2396
ug/L
1 0
Note: n < 9
Limited data set
6.200
C.V. (default)
NO DETECTS
Acute: 277.959
___
Chronic: 61.481
Max MDL = 2
no limit
Chlorides
NC
230 FW(7Q10s)
mg/L
0 0
N/A
Acute: NO WQS
-- _Chr_ onic:----23,971.9_ ----------------------------
N/A
Chlorinated Phenolic Compounds
NC
1 A(30Q2)
ug/L
0 0
N/A
Acute: NO WQS
-- _Chr_ _ _
onic:----- 104.2------------------------------
N/A
Total Phenolic Compounds
NC
300 A(30Q2)
ug/L
58 58
24.0
Acute: NO WQS
-- _Chr_ _ onic:----31,267.7__ ----------------------------
No value > Allowable Cw
no limit
Chromium III
NC
117.7325 FW(7Q10s) 905.0818
µg/L
0 0
N/A
Acute: 77,656.0
-- _Chr_ _
onic:----12,27 ).8-----------------------------
no limit
Chromium VI
NC
11 FW(7Q10s) 16
µg/L
0 0
N/A
Acute: 1,372.8
-- _ _
Chr_onic:-----1,146.5 -----------------------------
no limit
Chromium, Total
NC
µg/L
Tot Cr value(s)
58 58
> 5 but < Cr VI
239.8
Allowable Cw
reported value = 239.80815347
Page 17 of 64
NC0025135_Worksheets_20220926, rpa
12/12/2022

Huffman Finishing Company
N C0025135
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall 001
Qw = 0.25 MGD
Copper
NC
7.8806 FW(7Q10s) 10.4720
ug/L
1 1
Note: n < 9
Limited data set
173.60
C.V. (default)
Acute: 898.50
___Chr_ ______ _____________________________
onic: 821.37
No value > Allowable Cw
no limit
Cyanide
NC
5 FW(7Q10s) 22
10
ug/L
1 0
Note: n < 9
Limited data set
31.0
C.V. (default)
NO DETECTS
Acute: 1,887.6
___Chr_ ______ _______________________________
onic: 521.1
Max MDL = 10
no limit
Fluoride
NC
1800 FW(7Q10s)
ug/L
0 0
N/A
Acute: NO WQS
-- _Chr_
onic:----187_,606-5 ----------------------------
N/A
Lead
NC
2.9416 FW(7Q10s) 75.4871
ug/L
1 0
Note: n < 9
Limited data set
15.500
C.V. (default)
NO DETECTS
Acute: 6,476.794
___Chr_ ____ _ _____________________________
onic: 306.593
Max MDL = 5
no limit
Mercury
NC
12 FW(7Q10s)
0.5
ng/L
1 1
Note: n < 9
Limited data set
35.6
C.V. (default)
Acute: NO WQS
___Chr_ ______ _ _____________________________
onic: 1,250.7
No value > Allowable Cw
no limit
Molybdenum
NC
2000 HH(7Q10s)
ug/L
0 0
N/A
Acute: NO WQS
-- _Chr_ _
onic:--- 2-_ ,451-6 ----------------------------
N/A
Nickel
Nickel
NC
NC
37.2313 FW(7Q10s) 335.2087
25.0000 WS(7Q10s)
µg/L
µg/L
1 1
Note: n < 9
Limited data set
37.2
C.V. (default)
Acute (FW): 28,760.9
Chronic (FW): 3,880.5
Novalue > Allowable _Cw_ _ _
Chronic (WS): 2,605.E
No value > Allowable Cw
no limit
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Selenium
NC
5 FW(7Q10s) 56
ug/L
1 0
Note: n < 9
Limited data set
15.5
C.V. (default)
NO DETECTS
Acute: 4,804.8
___Chr_ ______ _______________________________
onic: 521.1
Max MDL = 5
no limit
Silver
NC
0.06 FW(7Q10s) 0.2964
ug/L
18 0
5.750
NO DETECTS
Acute: 25.431
-- _Chr_ _
onic:----- 6.254------------------------------
Max MDL = 10
no limit
Zinc
NC
126.7335 FW(7Q10s) 125.7052
ug/L
1 0
Note: n < 9
Limited data set
31.0
C.V. (default)
NO DETECTS
Acute: 10,785.5
___Chr_ ____ ,208 _____________________________
onic: 13.9
Max MDL = 10
no limit
Antimony
C
5.6 WS(Qavg)
µg/L
1 0
Note: n < 9
Limited data set
15.50000
C.V. (default)
NO DETECTS
Acute: NO WQS
___Chr_ ____ _ _ ____________________________
onic: 583.66452
Max MDL = 5
no limit
Sulfide
NC
0.21 FW(7Q10s)
µg/L
58 0
25.00000
NO DETECTS
Acute: NO WQS
-- _ _ _ ---_ _ _
Chronic:-21.88742 ----------------------------
Max MDL = 50
no limit
all values below detection level
Acute:
Page 18 of 64
NC0025135_Worksheets_20220926, rpa
12/12/2022

Huffman Finishing Company
N C0025135
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall 001
Qw = 0.25 MGD
0 0
N/A
Chronic:
0 0
N/A
Acute:
Chronic:--------------------------------------
NC0025135_Worksheets_20220926, rpa
Page 19 of 64 12/12/2022

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.

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
ifl
roU 250.00
u_
c
0
fa 200.00
u
t.
150.00
100.00 7
50.00
0.00
1 4 7 10 13 16 19 22 25
0
N
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
3/18/16:
Removed HUC table and HUC hardness lookup features from calculations and program.
Note: HUC number is an available option on the INPUT as an informational input only to use as a display
Added Upstream Hardness calculation feature using measured upstream data:
1) INPUT display shows "Upstream Hardess" status and how upstream data is applied
2) DATA has new Upstream Hardness input sheet to accept upstream hardness data used to calculate r
3) Diss to Total Metal Calculator determines which upstream hardness to apply, if the number of data en
10th percentile value is used. Anytime the applied upstream hardness is less than 25 mg/L then a defa
4/26/16:
Per Julia want to use average values for both the effluent and upstream hardness calculations. Defaults
1) Changed all upstream hardness median calculations to average calculations.
2) Removed any greater than 99.999 defaults from upstream hardness conditional statements. Upstrean
3) Changed all effluent hardness median calculations to average calculations. Conditional statements for
4) Any conditional statement referring to median hardness were revised.
5) Removed "(AL)" from parameter labels as no longer applicable.
6) Renamed RPA to describe features
4/27/16:
Per Julia when WS is being applied, the combined acute and chroinc hardness needs to default to 100 if
1) Set up new cells to calculate combined acute and chronic hardness, defined cells as program names ,
2) Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH & ACAH exceed 1001
3) Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate default!
4) Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate
4/28/16:
Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI
Revised RPA page drop menu "Recommended Action" list to remove RP Action Level text and change "
Added statement to 2B .0500 RULES page "4/28/16: Note Action Level designation no long allowed per I
4/29/16:
Added ROUND function to conditional statements on INPUT page hardess displays to limit hardness vale
Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardneE
5/6/16:
Removed less than 25 mg/L default from all effluent and upstream hardness conditional programming
5/11/16:
Added new conditional display to Total Chromium Pred Cw box RPA page to compare Total Chromium c
Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Tot
6/13/16:
Revised title block text RPA tab to state "NC STANDARDS OR EPA CRITERIA", removed "NC WQS" fr(
Corrected INPUT tab to align Dats Source(s) text box at top.
6/14/16:
Revised conditions for calculated combined hardness acute and chroinc to default to 400 mg/L if calculai
Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when defaL
Corrected label on DISS ... page to indicate average for effluent and upstream hardness

7/13/16:
Revised Model input feature when activated to calculate Model 7Q10s (cfs) flow based on entry of Qw, N
User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry k
Revised narrative in Model narrative box with new instructions, new messages to alert user on actions nE
Remove conditions and features assocaited with entry of Model Acute IWC % .
8/30/16:
Revised conditional note statement on RPA tab for Total Chromium to correct program error.
10/20/16:
Revised label display for Fcailty discripition on "Diss to Total Metal Calculator".sheet to list Outfall #.
9/7/2017
Revised chromium drop down to reflect new < 5ug/L PQL.
11/21/17:
(1) Revised RPA evaluation to assign C.V. (default) = 0.6 when only a sinlgle data entry inade for any pa
(2) Revised RPA evaluation to always calculate and display "Max Pred Cw" value whenever there are 1 t
(3) Revised rpa page to show each parameters automatic display message "NO DETECTS" independen
(4) Revised Total Chromium < 50 data counter to start count when the entered data point < 4.9999. (hidc
11/29/17:
(1) Revised RPA page ( C.V. (default? Message to
(2) Corrected DATA page H2 message to show ... UPSTREAM...
(3) Removed (1) from RPA page Type label
11/30/17:
Revised Dissolved Metals and Total Metals Table label descriptions on "DSS to Total Metal Calculator" 1
12/12/17:
Revised conditional statements DATA tab to allow appllication C.V. (default) for number of data values 1
1/20/18:
1) Revised "RPA" Receiving Stream display to only show the Stream name and if entered the HUC numk
2) Increased RPA page Qw display decimal places

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".
label for other portion of the progam and has no Data Validation features.
lumber of data enties, data set average, data set 10th percentile value
tries exceed 30 then the average value is used, if the number of data enties are less than 30 then the
ult value of 25 mg/L is applied.
to be the same as was applied in the HUC base RPA.
average will be actual execpt when less than 25, then 25 is the default.
WS still apply, efflunet average value above 99.999 default to 99.
the combined hardness exceeds 100. Made changes:
ACCH & ACAH.
when WS was applied.
defaults
now function.
RP non action level..." text to state "RP shown...".
EPA."
ue display to 2 decimal points.
;s of 25 to be displayed as non -default value.
iata to Cr III and Cr VI Allowable Cw
al Chromium value entered
)m Chronic label, and removed 1/2 FAV from Acute label.
Led value exceeded 400 mg/L
..ilt 400 mg/L applied

1GD and CHRONIC DILITION FACTOR (from Model) and display in Model narrative box.
)ox. 1 Q10s is calculated once the calculated 7Q10s (cfs) is entered in Tablel .
?eded and/or completed to correctly enter Model 7Q10s (cfs) in Table 1.
rameter (see data page). On data page the parameter will diplay Std..Dev. = "N/A" when only a single data entry m;
o 58 data numerical entties made (see data and rpa pages).
t from "Max Pred Cw" display
len column of data page). Revised Total Chromium automatic diplay message on rpa page to reflect new 5 pg/I crib
Lab so as not to conflict with exsiting descriptions in RPA
to 9 even if no deviation in data set.
)er

ade.
aria.

Date: 12/12/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: Huffman Finishing Company Outfall 001
NPDES PERMIT: NC0025135
Dissolved to Total Metal Calculator
In accordance with Federal Regulations, permit limitations must be written as Total Metals per 40 CFR 122.45(c)
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
Mute
(mg/L)
Instream
Wastewater
Concentration
(Chronic)
Instream
Wastewater
Concentration
(Acute)
Upstream
Hardness
Average (mg/L)
Effluent
Hardness
Average
(mg/L)
40.0000
I 25.8065
21.2000
0.2500
10
25.000
25.000
0.9595
1.1655
I 25
I 25
Upstream Hard Avg (mg/L) =
25
EFF Hard Avg (mg/L) = 25
PARAMETER
Dissolved Metals Criteria US EPA
after applying hardness Translators- using Total Metal Criteria Total Metal =
equation Default Partition Dissolved Metal - Translator
Coefficients
(streams)
Chronic
Iuq/I1
Acute
f uq/Il
Chronic
Iuq/Il
Acute
Iuq/Il
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)
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
65
1.000
6.5
65
Arsenic (d)
150
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 ug/L which is Total Recoverable metal standard.
ACAH
ACCH