NC0038377_Worksheets_20211215 (2)

Mayo Steam Station Outfall 002-dewatering
NC0038377 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 3 MGD
MAXIMUM DATA POINTS = 58
Qw(MGD)= 3.00 WWTP/WTP Class: I COMBINED HARDNESS(mg/L)
1Q1OS(cfs)= 0.00 IWC% @ 1Q1OS = 100 Acute=25 mg/L
7Q1OS(cfs)= 0.00 IWC% @ 7Q1OS= 100 Chronic=25 mg/L
7Q1OW(cfs)= 0.00 IWC%@ 7Q1OW= 100 YOU HAVE DESIGNATED THIS RECEIVING
30Q2(cfs)= 0.00 IWC%@ 30Q2= 100 STREAM AS WATER SUPPLY
Avg. Stream Flow,QA(cfs)= 0.00 IW%C @ QA= 100 Effluent Hard:0 value> 100 mg/L
Receiving Stream: NO HUC NUMBER Stream Class: WS-V Effluent Hard Avg=25 mg/L
PARAMETER NC STANDARDS OR EPA CRITERIA N REASONABLE POTENTIAL RESULTS RECOMMENDED ACTION
TYPE _1 H
CJ
(1) Chronic Applied Acute ° m 11 #Det. Max Pred Cw Allowable Cw
Standard
Acute(FW): 340.0
add limit
Arsenic C 150 FW 340 ug/L _ _ _ _ _____ _______________________________
1 1 454.0 Chronic(FW): 150.0
Default C.V. 1 value(s)>Allowable C_w
__ _______________________________
Arsenic C 10 HH/WS ug/L Note: n<9 Chronic(HH): 10.0
Limited data set 1 value(s)>Allowable Cw
Acute: 65.00 n/a
Beryllium NC 6.5 FW 65 ug/L 0 0 N/A _ _ _ _
--Chronic: -----6.50 ------------------------------
Acute: 3.240
add limit
Cadmium NC 0.5899 FW 3.2396 ug/L 1 1 1.520 ___ _ ____ _ _______________________________
Note: n<9 Default C.V. Chronic: 0.590
Limited data set 1 value(s)>Allowable Cw
Acute: NO WQS no limit
Chlorides NC 230 FW mg/L 1 1 1 8.8 ___ _ ____ _ _______________________________
Note: n<9 Default C.V. Chronic: 230.0
Limited data set No value>Allowable Cw
Acute: NO WQS
Chlorinated Phenolic Compounds NC 1 A ug/L 0 0 N/A _ _ _
--Chronic: ----- -------------------------------
1.0
Acute: NO WQS N/A
Total Phenolic Compounds NC 300 A ug/L 0 0 N/A _ _ _ _
--Chronic: ---- ------------------------------
300.0
Acute: 905.1 add Cr III limit
Chromium III NC 117.7325 FW 905.0818 µg/L 0 0 N/A _ _ _ _
--Chronic: -----117.7 ------------------------------
Acute: 16.0 add Cr VI limit
Chromium VI NC 11 FW 16 µg/L 0 0 N/A — _
-Chronic:_ -----i1-0------------------------------
Tot Cr value(s)>50 with 1 Tot Cr value(s)>Cr III Allowable Cw
Chromium,Total NC µg/L 1 1 1 301.0 Max reported value=301
Note: n<9 Default C.V.
Limited data set
38377-RPA-Outfall 002 dewatering-2021, rpa
Page 1 of 3 12/20/2021

Mayo Steam Station Outfall 002-dewatering
NC0038377 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 3 MGD
Acute: 10.47
add limit
Copper NC 7.8806 FW 10.4720 ug/L 1 1 1 446.00 ___ _ ______ ______________________________
Note: n<9 Default C.V. Chronic: 7.88
Limited data set 1 value(s)>Allowable Cw
Acute: 22.0 N/A
Cyanide NC 5 FW 22 10 ug/L 0 0 N/A _ _ _
--Chronic: ----- ------------------------------
5.0
Acute: NO WQS no limit
Fluoride NC 1800 FW ug/L 1 1 405.7 ___ _ ____ _ ______________________________
Note: n<9 Default C.V. Chronic: 1,800.0
Limited data set No value>Allowable Cw
Acute: 75.487
add limit
Lead NC 2.9416 FW 75.4871 ug/L 1 1 1 244.000 ___ _ ____ _ ______________________________
Note: n<9 Default C.V. Chronic: 2.942
Limited data set 1 value(s)>Allowable Cw
Acute: NO WQS no limit
Mercury NC 12 FW 0.5 ng/L 1 0 NO DETECTS ___ _ _______ ______________________________
Note: n<9 Chronic: 12.0
Limited data set Max MDL= 1
Acute: NO WQS no limit
Molybdenum NC 2000 HH ug/L 1 1 1 367.0 ___ _ ____ _ ______________________________
Note: n<9 Default C.V. Chronic: 2,000.0
Limited data set No value>Allowable Cw
Acute(FW): 335.2
add limit
Nickel NC 37.2313 FW 335.2087 µg/L _ _ _ _ _____ ______________________________
1 1 315.0 Chronic(FW) 37.2
Note: n<9 Default C.V. 1 value(s)>Allowab_le_C_w______________________________
Nickel NC 25.0000 WS µg/L Limited data set Chronic(WS) 25.0
1 value(s)>Allowable Cw
Acute: 56.0 no limit
Selenium NC 5 FW 56 ug/L 1 1 3.0 ___ _ ______ ______________________________
Note: n<9 Default C.V. Chronic: 5.0
Limited data set No value>Allowable Cw
Acute: 0.296 N/A
Silver NC 0.06 FW 0.2964 ug/L 0 0 N/A _ _ _ _
--Chronic: ---- -----------------------------
0.060
Acute: 125.7
add limit
Zinc NC 126.7335 FW 125.7052 ug/L 1 1 407.0 ___ _ ______ ______________________________
Note: n<9 Default C.V. Chronic: 126.7
Limited data set 1 value(s)>Allowable Cw
Acute: NO WQS no limit
Antimony NC 5.6 WS µg/L 1 1 1 1.99000 ___ _ ___ _ _ _____________________________
Note: n<9 Default C.V. Chronic: 5.60000
Limited data set No value>Allowable Cw
Acute: NO WQS
add limit
Thallium NC 2 HH µg/L 1 1 1 2.69000 ___ _ ___ _ _ ____________________________
Note: n<9 Default C.V. Chronic: 2.00000
Limited data set 1 value(s)>Allowable Cw
IAcute: NO WQS ,,,„,;mi+
38377-RPA-Outfall 002 dewatering-2021, rpa
Page 2 of 3 12/20/2021

Mayo Steam Station Outfall 002-dewatering
NC0038377 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 3 MGD
Sulfate NC 250 WS mg/L 1 1 1 32.78000 ___ _ ____ _ _ ____________________________
Note: n<9 Default C.V. Chronic: 250.00000
Limited data set No value>Allowable Cw
Acute: NO WQS
add limit
Barium NC 1 WS mg/L 1 1 1.75000 ___ _ ____ _ _ ____________________________
Note: n<9 Default C.V. Chronic: 1.00000
Limited data set 1 value(s)>Allowable Cw
38377-RPA-Outfall 002 dewatering-2021, rpa
Page 3 of 3 12/20/2021

Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
MAXIMUM DATA POINTS = 58
iii REQUIRED DATA ENTRY CHECK WQS
Table 1. Project Information Table 2. Parameters of Concern
['CHECK IF HQW OR ORW WQS Name WQS Type Chronic Modifier Acute PQL Units
Facility Name Mayo Steam Station Par01 Arsenic Aquactic Life C 150 FW 340 ug/L
WWTP/WTP Class I Par02 Arsenic Human Health C 10 HH/WS N/A ug/L
Water Supply
NPDES Permit NC0038377 Par03 Beryllium Aquatic Life NC 6.5 FW 65 ug/L
Outfall 002-dewatering Par04 Cadmium Aquatic Life NC 0.5899 FW 3.2396 ug/L
Flow, Qw(MGD) 3.000 Par05 Chlorides Aquatic Life NC 230 FW ,ig/L
Receiving Stream Mayo Lake Par06$ Chlorinated Phenolic Compounds Water Supply NC 1 A ug/L
HUC Number Par07 y Total Phenolic Compounds Aquatic Life NC 300 A ug/L
Stream Class Par08 Chromium III Aquatic Life NC 117.7325 FW 905.0818 ug/L
WS-V
['Apply WS Hardness WQC Par09 Chromium VI Aquatic Life NC 11 FW 16 pg/L
7Q10s(cfs) 0.00 Par10 Chromium, Total Aquatic Life NC N/A FW N/A pg/L
7Q1Ow(cfs) 0.00 Par11 Copper Aquatic Life NC 7.8806 FW 10.4720 ug/L
30Q2 (cfs) 0.00 Par12 Cyanide Aquatic Life NC 5 FW 22 10 ug/L
QA(cfs) 0.00 Par13 Fluoride Aquatic Life NC 1,800 FW ug/L
1 Q10s(cfs) 0.00 Par14 Lead Aquatic Life NC 2.9416 FW 75.4871 ug/L
Effluent Hardness 25 mg/L(Avg) Par15 Mercury Aquatic Life NC 12 FW 0.5 ng/L
Upstream Hardness 25 mg/L(Avg) I Par16 Molybdenum Human Health NC 2000 HH ug/L
Combined Hardness Chronic 25 mg/L I Par17 Nickel Aquatic Life NC 37.2313 FW 335.2087 pg/L
Combined Hardness Acute 25 mg/L I Par18 Nickel Water Supply NC 25.0000 WS N/A pg/L
Data Source(s) DMRs Par19 Selenium Aquatic Life NC 5 FW 56 ug/L
['CHECK TO APPLY MODEL Par20 Silver Aquatic Life NC 0.06 FW 0.2964 ug/L
Par21 Zinc Aquatic Life NC 126.7335 FW 125.7052 ug/L
Par22 Antimony Water Supply NC 5.6 WS pg/L
Par23 Thallium Human Health NC 2 HH pg/L
Par24 Sulfate Water Supply NC 250 WS mg/L
Follow directions for data entry. In some cases a Par25 Barium Water Supply NC 1 WS mg/L
comment menu list the available choices or a
dropdown menu will provide a list you may select
from. Error message occur if data entry does not •
meet input criteria.
NC0038377_Worksheets_20211215 (2), input
12/20/2021

REASONABLE POTENTIAL ANALYSIS
H1 H2
Use"PASTE SPECIAL. Use"PASTE SPECIAL.
Values"then"COPY" Values"then"COPY"
Effluent Hardness .Maximum data Upstream Hardness .Maximum data
points=58 points=58
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
1 25 25 Std Dev. N/A 1 25 25 Std Dev. N/A
2 Mean 25.0000 2 Mean 25.0000
3 C.V. 0.0000 3 C.V. 0.0000
4 n 1 4 n 1
5 10th Per value 25.00 mg/L 5 10th Per value 25.00 mg/L
6 Average Value 25.00 mg/L 6 Average Value 25.00 mg/L
7 Max.Value 25.00 mg/L 7 Max.Value 25.00 mg/L
8 8
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
-2- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
Par01 &Par02
Use"PASTE SPECIAL.
Arsenic Values"then"COPY"
.Maximum data
points=58
Date Data BDL=1/2DL Results
1 454 454 Std Dev. N/A
2 Mean 454.0000
3 C.V. 0.0000
4 n 1
5
6 Mult Factor= 1.00
7 Max.Value 454.0 ug/L
8 Max. Pred Cw 454.0 ug/L
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
NC0038377_Worksheets_20211215(2),data
-3- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
Par03 Use"PASTE SPECIAL.Par04 Use"PASTE SPECIAL.
Values"then"COPY" Values"then"COPY"
Beryllium .Maximum data Cadmium .Maximum data
points=58 points=58
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
1 Std Dev. NO DATA 1 1.52 1.52 Std Dev. N/A
2 Mean NO DATA 2 Mean 1.5200
3 C.V. NO DATA 3 C.V. 0.0000
4 n 0 4 n 1
5 5
6 Mult Factor= N/A 6 Mult Factor= 1.00
7 Max.Value N/A ug/L 7 Max.Value 1.520 ug/L
8 Max. Pred Cw N/A ug/L 8 Max. Pred Cw 1.520 ug/L
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
-4- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
Par05 Par06
Use"PASTE SPECIAL- Use"PASTE SF
Chlorides Values"then"COPY". Chlorinated Phenolic Compounds Values"then"1
Maximum data points= .Maximum c
58 points=5
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
1 8.75 8.75 Std Dev. N/A 1 Std Dev. NO DATA
2 Mean 8.8 2 Mean NO DATA
3 C.V. 0.0000 3 C.V. NO DATA
4 n 1 4 n 0
5 5
6 Mult Factor= 1.0 6 Mult Factor= N/A
7 Max.Value 8.8 mg/L 7 Max.Value N/A
8 Max. Pred Cw 8.8 mg/L 8 Max. Pred Cw N/A
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
-5- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
,ECIAL•Par07 Use"PASTE SPECIAL.Par08 Use"PASTE SF
COPY" Values"then"COPY" Values"then"I
lata Total Phenolic Compounds .Maximum data Chromium Ill .Maximum c
;8 points=58 points=5
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
1 Std Dev. NO DATA 1 Std Dev. NO DATA
2 Mean NO DATA 2 Mean NO DATA
3 C.V. NO DATA 3 C.V. NO DATA
4 n 0 4 n 0
5 5
6 Mult Factor= N/A 6 Mult Factor= N/A
ug/L 7 Max.Value N/A ug/L 7 Max.Value N/A
ug/L 8 Max. Pred Cw N/A ug/L 8 Max. Pred Cw N/A
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
-6- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
,ECIAL•Par09 Use"PASTE SPECIAL.Par1 Use"PASTE SF
COPY" Values"then"COPY" Values"then"I
lata Chromium VI .Maximum data Chromium, Total .Maximum c
;8 points=58 points=5
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
1 Std Dev. NO DATA 1 301 301 Std Dev. N/A
2 Mean NO DATA 2 Mean 301.0000
3 C.V. NO DATA 3 C.V. 0.0000
4 n 0 4 n 1
5 5
6 Mult Factor= N/A 6 Mult Factor= 1.00
pg/L 7 Max.Value N/A pg/L 7 Max.Value 301.0
pg/L 8 Max. Pred Cw N/A pg/L 8 Max. Pred Cw 301.0
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
-7- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
,ECIAL•Pal 1
Use"PASTE SPECIAL.Par12 Use"PASTE SF
COPY" CO er Values"then"COPY" Cyanide Values"then"I
lata pp .Maximum data y .Maximum c
;8 points=58 points=5
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
1 446 446 Std Dev. N/A 1 Std Dev. NO DATA
2 Mean 446.0000 2 Mean NO DATA
3 C.V. 0.0000 3 C.V. NO DATA
4 n 1 4 n 0
5 5
6 Mult Factor= 1.00 6 Mult Factor= N/A
pg/L 7 Max.Value 446.00 ug/L 7 Max.Value N/A
pg/L 8 Max. Pred Cw 446.00 ug/L 8 Max. Pred Cw N/A
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
-8- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
,ECIAL•Par13 Use"PASTE SPECIAL.Par14 Use"PASTE SF
COPY" Values"then"COPY" Values"then"I
lata Fluoride .Maximum data Lead .Maximum c
;8 points=58 points=5
Date Data BDL=1/2DL Results Date BDL=1/2DL Results
1 405.7 405.7 Std Dev. N/A 1 244 244 Std Dev. N/A
2 Mean 405.7000 2 Mean 244.0000
3 C.V. 0.0000 3 C.V. 0.0000
4 n 1 4 n 1
5 5
6 Mult Factor= 1.00 6 Mult Factor= 1.00
ug/L 7 Max.Value 405.7 ug/L 7 Max.Value 244.000
ug/L 8 Max. Pred Cw 405.7 ug/L 8 Max. Pred Cw 244.000
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
-9- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
,ECIAL•Par15 Use"PASTE SPECIAL.Par16 Use"PASTE SF
COPY" Values"then"COPY" Values"then"I
lata Mercury .Maximum data Molybdenum .Maximum c
;8 points=58 points=5
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev. N/A 1 367 367 Std Dev. N/A
2 Mean 0.5000 2 Mean 367.0000
3 C.V. 0.0000 3 C.V. 0.0000
4 n 1 4 n 1
5 5
6 Mult Factor= 1.00 6 Mult Factor= 1.00
ug/L 7 Max.Value 0.5 ng/L 7 Max.Value 367.0
ug/L 8 Max. Pred Cw 0 DETECTS ng/L 8 Max. Pred Cw 367.0
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
- 10- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
Par17&Par18 Par19
�ECIAL• Use"PASTE SPECIAL.
COPY" Nickel Values"then"COPY" Selenium
iata .Maximum data
;8 points=58
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
1 315 315 Std Dev. N/A 1 3 3 Std Dev.
2 Mean 315.0000 2 Mean
3 C.V. 0.0000 3 C.V.
4 n 1 4 n
5 5
6 Mult Factor= 1.00 6 Mult Factor=
ug/L 7 Max.Value 315.0 pg/L 7 Max.Value
ug/L 8 Max. Pred Cw 315.0 pg/L 8 Max. Pred Cw
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
- 11 - 12/20/2021

REASONABLE POTENTIAL ANALYSIS
Use"PASTE SPECIAL.Par20 Use"PASTE SPECIAL.Par21
Values"then"COPY" Values"then"COPY"
.Maximum data Silver .Maximum data Zinc
points=58 points=58
Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results
N/A 1 Std Dev. NO DATA 1 407 407 Std Dev.
3.0000 2 Mean NO DATA 2 Mean
0.0000 3 C.V. NO DATA 3 C.V.
1 4 n 0 4 n
5 5
1.00 6 Mult Factor= N/A 6 Mult Factor=
3.0 ug/L 7 Max.Value N/A ug/L 7 Max.Value
3.0 ug/L 8 Max. Pred Cw N/A ug/L 8 Max. Pred Cw
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
- 12- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
Use"PASTE SPECIAL.Par22 Use"PASTE SPECIAL.Par23
Values"then"COPY" Values"then"COPY"
.Maximum data Antimony .Maximum data Thallium
points=58 points=58
Date Data BDL=1/2DL Results Date Data BDL=1/2DL
N/A 1 1.99 1.99 Std Dev. N/A 1 2.69 2.69
407.0000 2 Mean 1.9900 2
0.0000 3 C.V. 0.0000 3
1 4 n 1 4
5 5
1.00 6 Mult Factor= 1.00 6
407.0 ug/L 7 Max.Value 1.990000 pg/L 7
407.0 ug/L 8 Max. Pred Cw 1.990000 pg/L 8
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
- 13- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
Use"PASTE SPECIAL.Par24 Use"PASTE SPECIAL.Par25
Values"then"COPY" Values"then"COPY"
.Maximum data Sulfate .Maximum data Barium
points=58 points=58
Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL
Std Dev. N/A 1 32.78 32.78 Std Dev. N/A 1 1.75 1.75
Mean 2.6900 2 Mean 32.7800 2
C.V. 0.0000 3 C.V. 0.0000 3
n 1 4 n 1 4
5 5
Mult Factor= 1.00 6 Mult Factor= 1.00 6
Max.Value 2.690000 pg/L 7 Max.Value 32.780000 mg/L 7
Max. Pred Cw 2.690000 pg/L 8 Max. Pred Cw 32.780000 mg/L 8
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
NC0038377_Worksheets_20211215(2),data
- 14- 12/20/2021

REASONABLE POTENTIAL ANALYSIS
Use"PASTE SPECIAL.
Values"then"COPY"
.Maximum data
points=58
Results
Std Dev. N/A
Mean 1.7500
C.V. 0.0000
n 1
Mult Factor= 1.00
Max.Value 1.750000 mg/L
Max. Pred Cw 1.750000 mg/L
NC0038377_Worksheets_20211215(2),data
- 15- 12/20/2021

Monitoring Frequencies Per Memo Dated 7-15-2010
2B.0500 Effluent Limited RPA Condition Permit Monitoring Frequency
PH E 2/Month 1/Week 3/Week Daily
Temp,C E 1/Week 1/Week 3/Week Daily I.RPA Exists Monitor Monthly and add Permit Limit
BOOS I,E 2/Month 1/Week 3/Week Daily 2.RPA Exists but Action Levels(Cu,Ze.Ag,Fe,Cl) Monitor Quarterly in conjunction with Tox Test
TSS I,E 2/Month 1/Week 3/Week Daily
NH3-N E 1/Month 2/Month 1/Week 3/Week 3a RPA Exists but Dataset Limited(n<S samples) Monitor Quarterly
Fecal Col. E 2/Month 1/Week 3/Week Daily 3b.RPA exists,dataset limited,but 2 values> Monitor Monthly and add Permit Limit
TN E See notes below. allowable Cw
TP E See notes below. 4.No RPA(Predicted Max>50%of Allowable) Monitor Quanaly(or defer to Pretreat LTMP)
Water Quality Limited 5.No RPA(Predicted Max<50%Allowable) No Monitoring
Frequency 6a.Na Data(New Permit,New Waste Stream) Monitor Monthly far Toxic Pollutants of Concern
Parameter Location Class I Class II Class III Class IV 6b.New Greensand or Conventional WTP Monitor Quarterly for Toxic Pollutants of Concern
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' password all sheets=rpa2016a
GODS 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 4/28/16:Note Action Level designation no longer allowed per EPA.
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 Mi-monitor semi-annually
->=1.0 MG-monitor quarterly
For all other river basins:
->=0.05 Mi-monitor quarterly
->=1.0 MG-monitor monthly

Sample recommendations:
Msg00 <No Data Entered> NO DATA Daily max limit
Msg01 MaxPredCw<Acute MONITOR? Monitor 1/month
Msg02 MaxPredCw<Chronic MONITOR? Monitor 1/week
Msg03 MaxPredCw«Acute REMOVE? Monitor 2/month
Msg04 MaxPredCw«Chronic REMOVE? Monitoring not necessary in permit
Msg05 MaxPredCw>Acute DAILY MAX LIMIT? No limit
Msg06 MaxPredCw>Chronic MO AVG LIMIT? No limit-assuming no tox(Action Level parameter)
Msg07 MaxPredCw»Acute DAILY MAX LIMIT? No limit(Action Level parameter)
Msg08 MaxPredCw»Chronic MO AVG LIMIT? Continue to monitor at 2/month
Msg09 No acute standard or 1/2 FAV N/A Mo.avg.limit(keep wk.avg.if existing)
Msg10 No chronic standard or criterion N/A Revise daily max.limit

Reasonable Potential Multiplying Factors - Calculator
95.0% Confidence Level
95.0% Upper Boundary of the Effluent Distribution(Percentile Value Not To Exceed)
Coefficient of Variation Coefficient of Var
n 0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2.0 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 3.0 3.1
1 1.00 __ 1.92 2.63 3.55 4.73 6.20 12.60 15.47 18.72 22.35 26.38 30.78 35.57 40.73 46.26 52.14 58.37 64.94 71.84 79.06 86.58 94.41 102.53 ##### 119.62 128.56 137.76 147.21 156.91
2 1.00 1.27 1.61 2.03 2.53 3.11 3.79 4.57 5.43 6.38 7.41 8.51 9.69 10.94 12.25 13.61 15.03 16.49 18.00 19.55 21.14 22.75 24.40 26.08 27.79 29.51 31.26 33.03 34.82 36.63 38.45 40.28
3 1.00 1.22 1.48 1.79 2.15 2.55 3.00 3.49 4.03 4.60 5.20 5.84 6.49 7.17 7.87 8.59 9.32 10.06 10.81 11.58 12.34 13.12 13.90 14.68 15.46 16.25 17.04 17.83 18.62 19.41 20.21 21.00
4 1.00 1.19 1.40 1.65 1.93 2.25 2.59 2.95 3.34 3.74 4.16 4.60 5.04 5.50 5.96 6.42 6.89 7.36 7.84 8.31 8.79 9.26 9.73 10.20 10.68 11.14 11.61 12.07 12.54 13.00 13.45 13.91
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 5.21 5.55 5.89 6.22 6.56 6.89 7.22 7.54 7.87 8.19 8.51 8.82 9.13 9.44 9.75 10.05 10.36
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 4.44 4.70 4.96 5.21 5.46 5.71 5.96 6.20 6.44 6.68 6.91 7.14 7.37 7.60 7.82 8.04 8.25
7 1.00 1.13 1.28 1.45 1.62 1.81 2.01 2.21 2.42 2.63 2.84 3.06 3.27 3.48 3.69 3.90 4.11 4.32 4.52 4.72 4.91 5.10 5.29 5.48 5.67 5.85 6.02 6.20 6.37 6.54 6.71 6.88
8 1.00 1.12 1.26 1.40 1.56 1.73 1.90 2.07 2.25 2.44 2.62 2.80 2.98 3.16 3.33 3.51 3.68 3.85 4.01 4.17 4.33 4.49 4.64 4.79 4.94 5.09 5.23 5.37 5.51 5.64 5.78 5.91
9 1.00 1.11 1.24 1.37 1.51 1.6' 1.81 1.97 2.12 2.28 2.44 2.60 2.75 2.90 3.05 3.20 3.34 3.49 3.62 3.76 3.89 4.02 4.15 4.27 4.40 4.52 4.63 4.75 4.86 4.97 5.08 5.19
10 1.00 1.10 1.22 1.34 1.47 1.60 1.74 1.88 2.02 2.16 2.30 2.43 2.57 2.70 2.83 2.95 3.08 3.20 3.32 3.43 3.55 3.66 3.77 3.87 3.97 4.07 4.17 4.27 4.36 4.46 4.55 4.64
11 1.00 1.10 1.20 1.32 1.43 1.55 1.68 1.80 1.93 2.05 2.18 2.30 2.41 2.53 2.64 2.75 2.86 2.97 3.07 3.17 3.27 3.36 3.46 3.55 3.63 3.72 3.80 3.89 3.97 4.05 4.12 4.20
12 1.00 1.09 1.19 1.29 1.40 1.51 1.63 1.74 1.85 1.96 2.07 2.18 2.29 2.39 2.49 2.59 2.68 2.78 2.87 2.95 3.04 3.12 3.20 3.28 3.36 3.43 3.50 3.57 3.64 3.71 3.78 3.84
13 1.00 1.09 1.18 1.27 1.37 1.48 1.58 1.68 1.79 1.89 1.99 2.08 2.18 2.27 2.36 2.45 2.53 2.61 2.69 2.77 2.84 2.92 2.99 3.06 3.12 3.19 3.25 3.31 3.37 3.43 3.49 3.55
14 1.00 1.08 1.17 1.26 1.35 1.44 1.54 1.63 1.73 1.82 1.91 2.00 2.08 2.17 2.25 2.32 2.40 2.47 2.54 2.61 2.68 2.74 2.81 2.87 2.93 2.98 3.04 3.09 3.15 3.20 3.25 3.30
15 1.00 1.08 1.16 1.24 1.33 1.41 1.50 1.59 1.68 1.76 1.84 1.92 2.00 2.07 2.15 2.22 2.29 2.35 2.41 2.48 2.54 2.59 2.65 2.70 2.76 2.81 2.86 2.91 2.95 3.00 3.04 3.09
16 1.00 1.07 1.15 1.23 1.31 1.39 1.47 1.55 1.63 1.71 1.78 1.85 1.93 1.99 2.06 2.12 2.19 2.24 2.30 2.36 2.41 2.46 2.51 2.56 2.61 2.65 2.70 2.74 2.78 2.83 2.86 2.90
17 1.00 1.07 1.14 1.21 1.29 1.36 1.44 1.51 1.59 1.66 1.73 1.79 1.86 1.92 1.98 2.04 2.10 2.15 2.20 2.25 2.30 2.35 2.39 2.44 2.48 2.52 2.56 2.60 2.64 2.67 2.71 2.74
18 1.00 1.06 1.13 1.20 1.27 1.34 1.41 1.48 1.55 1.62 1.68 1.74 1.80 1.86 1.91 1.97 2.02 2.07 2.11 2.16 2.20 2.25 2.29 2.33 2.36 2.40 2.44 2.47 2.51 2.54 2.57 2.60
19 1.00 1.06 1.12 1.19 1.26 1.32 1.39 1.45 1.51 1.58 1.64 1.69 1.75 1.80 1.85 1.90 1.95 1.99 2.03 2.08 2.12 2.15 2.19 2.23 2.26 2.30 2.33 2.36 2.39 2.42 2.45 2.48
20 1.00 1.06 1.12 1.18 1.24 1.30 1.36 1.42 1.48 1.54 1.59 1.65 1.70 1.75 1.79 1.84 1.88 1.92 1.96 2.00 2.04 2.07 2.11 2.14 2.17 2.20 2.23 2.26 2.29 2.31 2.34 2.37
21 1.00 1.05 1.11 1.17 1.23 1.29 1.34 1.40 1.45 1.51 1.56 1.61 1.65 1.70 1.74 1.78 1.82 1.86 1.90 1.93 1.96 2.00 2.03 2.06 2.09 2.12 2.14 2.17 2.19 2.22 2.24 2.27
22 1.00 1.05 1.11 1.16 1.22 1.27 1.32 1.38 1.43 1.48 1.52 1.57 1.61 1.65 1.69 1.73 1.77 1.80 1.84 1.87 1.90 1.93 1.96 1.99 2.01 2.04 2.06 2.09 2.11 2.13 2.15 2.18
23 1.00 1.05 1.10 1.15 1.20 1.25 1.31 1.35 1.40 1.45 1.49 1.53 1.57 1.61 1.65 1.68 1.72 1.75 1.78 1.81 1.84 1.87 1.89 1.92 1.94 1.97 1.99 2.01 2.03 2.05 2.07 2.09
24 1.00 1.05 1.09 1.14 1.19 1.24 1.29 1.33 1.38 1.42 1.46 1.50 1.54 1.57 1.61 1.64 1.67 1.70 1.73 1.76 1.78 1.81 1.83 1.86 1.88 1.90 1.92 1.94 1.96 1.98 2.00 2.02
25 1.00 1.04 1.09 1.14 1.18 1.23 1.27 1.32 1.36 1.40 1.43 1.47 1.51 1.54 1.57 1.60 1.63 1.66 1.68 1.71 1.73 1.76 1.78 1.80 1.82 1.84 1.86 1.88 1.90 1.91 1.93 1.95
26 1.00 1.04 1.09 1.13 1.17 1.21 1.26 1.30 1.34 1.37 1.41 1.44 1.48 1.51 1.54 1.56 1.59 1.62 1.64 1.66 1.69 1.71 1.73 1.75 1.77 1.79 1.80 1.82 1.84 1.85 1.87 1.88
27 1.00 1.04 1.08 1.12 1.16 1.20 1.24 1.28 1.32 1.35 1.39 1.42 1.45 1.48 1.50 1.53 1.55 1.58 1.60 1.62 1.64 1.66 1.68 1.70 1.72 1.73 1.75 1.77 1.78 1.80 1.81 1.82
28 1.00 1.04 1.08 1.12 1.15 1.19 1.23 1.26 1.30 1.33 1.36 1.39 1.42 1.45 1.47 1.50 1.52 1.54 1.56 1.58 1.60 1.62 1.64 1.66 1.67 1.69 1.70 1.72 1.73 1.74 1.76 1.77
29 1.00 1.04 1.07 1.11 1.15 1.18 1.22 1.25 1.28 1.31 1.34 1.37 1.40 1.42 1.44 1.47 1.49 1.51 1.53 1.55 1.56 1.58 1.60 1.61 1.63 1.64 1.66 1.67 1.68 1.70 1.71 1.72
30 1.00 1.03 1.07 1.10 1.14 1.17 1.20 1.24 1.27 1.29 1.32 1.35 1.37 1.39 1.42 1.44 1.46 1.48 1.49 1.51 1.53 1.54 1.56 1.57 1.59 1.60 1.61 1.63 1.64 1.65 1.66 1.67
31 1.00 1.03 1.06 1.10 1.13 1.16 1.19 1.22 1.25 1.28 1.30 1.33 1.35 1.37 1.39 1.41 1.43 1.45 1.46 1.48 1.50 1.51 1.52 1.54 1.55 1.56 1.57 1.59 1.60 1.61 1.62 1.63
32 1.00 1.03 1.06 1.09 1.12 1.15 1.18 1.21 1.24 1.26 1.28 1.31 1.33 1.35 1.37 1.39 1.40 1.42 1.43 1.45 1.46 1.48 1.49 1.50 1.51 1.53 1.54 1.55 1.56 1.57 1.58 1.59
33 1.00 1.03 1.06 1.09 1.12 1.14 1.17 1.20 1.22 1.24 1.27 1.29 1.31 1.33 1.34 1.36 1.38 1.39 1.41 1.42 1.43 1.45 1.46 1.47 1.48 1.49 1.50 1.51 1.52 1.53 1.54 1.55
34 1.00 1.03 1.05 1.08 1.11 1.14 1.16 1.18 1.21 1.23 1.25 1.27 1.29 1.31 1.32 1.34 1.35 1.37 1.38 1.39 1.41 1.42 1.43 1.44 1.45 1.46 1.47 1.48 1.49 1.49 1.50 1.51
35 1.00 1.03 1.05 1.08 1.10 1.13 1.15 1.17 1.20 1.22 1.23 1.25 1.27 1.29 1.30 1.32 1.33 1.34 1.36 1.37 1.38 1.39 1.40 1.41 1.42 1.43 1.44 1.45 1.45 1.46 1.47 1.48
36 1.00 1.02 1.05 1.07 1.10 1.12 1.14 1.16 1.18 1.20 1.22 1.24 1.25 1.27 1.28 1.30 1.31 1.32 1.33 1.34 1.35 1.36 1.37 1.38 1.39 1.40 1.41 1.42 1.42 1.43 1.44 1.44
37 1.00 1.02 1.05 1.07 1.09 1.11 1.13 1.15 1.17 1.19 1.21 1.22 1.24 1.25 1.26 1.28 1.29 1.30 1.31 1.32 1.33 1.34 1.35 1.36 1.36 1.37 1.38 1.39 1.39 1.40 1.41 1.41
38 1.00 1.02 1.04 1.06 1.08 1.10 1.12 1.14 1.16 1.18 1.19 1.21 1.22 1.23 1.25 1.26 1.27 1.28 1.29 1.30 1.31 1.32 1.32 1.33 1.34 1.35 1.35 1.36 1.37 1.37 1.38 1.38
39 1.00 1.02 1.04 1.06 1.08 1.10 1.12 1.13 1.15 1.16 1.18 1.19 1.21 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.29 1.30 1.31 1.31 1.32 1.33 1.33 1.34 1.34 1.35 1.36
40 1.00 1.02 1.04 1.06 1.07 1.09 1.11 1.12 1.14 1.15 1.17 1.18 1.19 1.20 1.21 1.22 1.23 1.24 1.25 1.26 1.26 1.27 1.28 1.29 1.29 1.30 1.30 1.31 1.31 1.32 1.32 1.33
41 1.00 1.02 1.03 1.05 1.07 1.08 1.10 1.12 1.13 1.14 1.15 1.17 1.18 1.19 1.20 1.21 1.21 1.22 1.23 1.24 1.24 1.25 1.26 1.26 1.27 1.27 1.28 1.29 1.29 1.29 1.30 1.30
42 1.00 1.02 1.03 1.05 1.06 1.08 1.09 1.11 1.12 1.13 1.14 1.15 1.16 1.17 1.18 1.19 1.20 1.21 1.21 1.22 1.23 1.23 1.24 1.24 1.25 1.25 1.26 1.26 1.27 1.27 1.28 1.28
43 1.00 1.01 1.03 1.04 1.06 1.07 1.09 1.10 1.11 1.12 1.13 1.14 1.15 1.16 1.17 1.18 1.18 1.19 1.20 1.20 1.21 1.21 1.22 1.22 1.23 1.23 1.24 1.24 1.25 1.25 1.25 1.26
44 1.00 1.01 1.03 1.04 1.05 1.07 1.08 1.09 1.10 1.11 1.12 1.13 1.14 1.15 1.15 1.16 1.17 1.17 1.18 1.18 1.19 1.20 1.20 1.20 1.21 1.21 1.22 1.22 1.22 1.23 1.23 1.23
45 1.00 1.01 1.03 1.04 1.05 1.06 1.07 1.08 1.09 1.10 1.11 1.12 1.13 1.13 1.14 1.15 1.15 1.16 1.16 1.17 1.17 1.18 1.18 1.19 1.19 1.19 1.20 1.20 1.20 1.21 1.21 1.21
46 1.00 1.01 1.02 1.03 1.05 1.06 1.07 1.08 1.08 1.09 1.10 1.11 1.11 1.12 1.13 1.13 1.14 1.14 1.15 1.15 1.16 1.16 1.17 1.17 1.17 1.18 1.18 1.18 1.19 1.19 1.19 1.19
47 1.00 1.01 1.02 1.03 1.04 1.05 1.06 1.07 1.08 1.08 1.09 1.10 1.10 1.11 1.12 1.12 1.13 1.13 1.13 1.14 1.14 1.15 1.15 1.15 1.16 1.16 1.16 1.16 1.17 1.17 1.17 1.17
48 1.00 1.01 1.02 1.03 1.04 1.05 1.05 1.06 1.07 1.08 1.08 1.09 1.09 1.10 1.10 1.11 1.11 1.12 1.12 1.12 1.13 1.13 1.13 1.14 1.14 1.14 1.14 1.15 1.15 1.15 1.15 1.16
49 1.00 1.01 1.02 1.03 1.03 1.04 1.05 1.05 1.06 1.07 1.07 1.08 1.08 1.09 1.09 1.10 1.10 1.10 1.11 1.11 1.11 1.12 1.12 1.12 1.12 1.13 1.13 1.13 1.13 1.13 1.14 1.14
50 1.00 1.01 1.01 1.02 1.03 1.04 1.04 1.05 1.05 1.06 1.06 1.07 1.07 1.08 1.08 1.08 1.09 1.09 1.09 1.10 1.10 1.10 1.10 1.11 1.11 1.11 1.11 1.11 1.12 1.12 1.12 1.12
51 1.00 1.01 1.01 1.02 1.03 1.03 1.04 1.04 1.05 1.05 1.06 1.06 1.06 1.07 1.07 1.07 1.08 1.08 1.08 1.08 1.09 1.09 1.09 1.09 1.09 1.10 1.10 1.10 1.10 1.10 1.10 1.10
52 1.00 1.01 1.01 1.02 1.02 1.03 1.03 1.04 1.04 1.04 1.05 1.05 1.05 1.06 1.06 1.06 1.06 1.07 1.07 1.07 1.07 1.07 1.08 1.08 1.08 1.08 1.08 1.08 1.09 1.09 1.09 1.09
53 1.00 1.00 1.01 1.01 1.02 1.02 1.03 1.03 1.03 1.04 1.04 1.04 1.04 1.05 1.05 1.05 1.05 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07
54 1.00 1.00 1.01 1.01 1.01 1.02 1.02 1.02 1.03 1.03 1.03 1.03 1.04 1.04 1.04 1.04 1.04 1.04 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.06 1.06 1.06 1.06 1.06
55 1.00 1.00 1.01 1.01 1.01 1.01 1.02 1.02 1.02 1.02 1.02 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04
56 1.00 1.00 1.00 1.01 1.01 1.01 1.01 1.01 1.01 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03
57 1.00 1.00 1.00 1.00 1.00 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02
58 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.01
0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2.0 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 3.0 3.1

iation Coefficient of Variation
3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4.0 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
166.84 177.00 187.38 197.98 208.78 219.79 231.00 242.40 253.99 265.76 277.71 289.83 302.12 314.57 327.19 339.96 352.88 365.95 379.1 192.53 406.03 419.66 433.43 447.33 461.35 475.50 489.76 504.15 518.65 533.27 1
42.13 43.99 45.86 47.74 49.64 51.54 53.44 55.36 57.28 59.21 61.15 63.09 65.03 66.98 68.93 70.89 72.85 74.81 76.71 78.75 80.72 82.69 84.67 86.64 88.62 90.60 92.58 94.56 96.54 98.52 2
21.79 22.58 23.36 24.15 24.94 25.72 26.50 27.28 28.06 28.84 29.61 30.38 31.15 31.92 32.68 33.44 34.20 34.96 35.7: 36.47 37.22 37.97 38.71 39.46 40.20 40.93 41.67 42.40 43.13 43.86 3
14.36 14.81 15.25 15.70 16.14 16.58 17.01 17.44 17.87 18.30 18.72 19.14 19.56 19.98 20.39 20.80 21.21 21.61 22.0: 22.42 22.82 23.21 23.61 24.00 24.39 24.77 25.16 25.54 25.92 26.30 4
10.65 10.95 11.24 11.53 11.82 12.10 12.38 12.66 12.94 13.21 13.48 13.75 14.02 14.28 14.55 14.81 15.06 15.32 15.5; 15.82 16.07 16.32 16.56 16.81 17.05 17.29 17.53 17.76 18.00 18.23 5
8.47 8.68 8.89 9.10 9.30 9.50 9.70 9.90 10.09 10.29 10.48 10.66 10.85 11.04 11.22 11.40 11.58 11.76 11.9: 12.10 12.28 12.45 12.62 12.78 12.95 13.11 13.28 13.44 13.60 13.76 6
7.04 7.20 7.36 7.51 7.67 7.82 7.97 8.12 8.26 8.41 8.55 8.69 8.83 8.96 9.10 9.23 9.37 9.50 9.63 9.75 9.88 10.01 10.13 10.25 10.37 10.49 10.61 10.73 10.85 10.96 7
6.03 6.16 6.29 6.41 6.53 6.65 6.77 6.88 6.99 7.11 7.22 7.33 7.43 7.54 7.65 7.75 7.85 7.95 8.05 8.15 8.25 8.34 8.44 8.53 8.63 8.72 8.81 8.90 8.99 9.08 8
5.29 5.40 5.50 5.60 5.69 5.79 5.88 5.98 6.07 6.16 6.25 6.34 6.42 6.51 6.59 6.67 6.76 6.84 6.91 6.99 7.07 7.15 7.22 7.30 7.37 7.44 7.52 7.59 7.66 7.73 9
4.72 4.81 4.89 4.97 5.06 5.13 5.21 5.29 5.36 5.44 5.51 5.58 5.65 5.72 5.79 5.86 5.93 5.99 6.06 6.12 6.19 6.25 6.31 6.37 6.43 6.49 6.55 6.61 6.66 6.72 10
4.27 4.34 4.41 4.48 4.55 4.62 4.68 4.75 4.81 4.87 4.94 5.00 5.05 5.11 5.17 5.23 5.28 5.34 5.39 5.44 5.50 5.55 5.60 5.65 5.70 5.75 5.80 5.85 5.89 5.94 11
3.90 3.97 4.03 4.09 4.15 4.20 4.26 4.31 4.37 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.99 5.03 5.08 5.12 5.16 5.20 5.24 5.28 5.32 12
3.60 3.66 3.71 3.76 3.81 3.86 3.91 3.96 4.00 4.05 4.09 4.14 4.18 4.22 4.26 4.30 4.35 4.38 4.42 4.46 4.50 4.54 4.57 4.61 4.65 4.68 4.72 4.75 4.78 4.82 13
3.35 3.39 3.44 3.48 3.53 3.57 3.61 3.66 3.70 3.74 3.77 3.81 3.85 3.89 3.92 3.96 3.99 4.03 4.06 4.10 4.13 4.16 4.19 4.22 4.26 4.29 4.32 4.35 4.37 4.40 14
3.13 3.17 3.21 3.25 3.29 3.33 3.36 3.40 3.44 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.84 3.87 3.90 3.93 3.95 3.98 4.00 4.03 4.05 15
2.94 2.98 3.01 3.05 3.08 3.12 3.15 3.18 3.21 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.57 3.60 3.62 3.65 3.67 3.69 3.71 3.74 3.76 16
2.78 2.81 2.84 2.87 2.90 2.93 2.96 2.99 3.02 3.05 3.08 3.10 3.13 3.15 3.18 3.20 3.23 3.25 3.27 3.30 3.32 3.34 3.36 3.38 3.40 3.42 3.44 3.46 3.48 3.50 17
2.63 2.66 2.69 2.72 2.75 2.77 2.80 2.83 2.85 2.88 2.90 2.92 2.95 2.97 2.99 3.01 3.03 3.06 3.08 3.10 3.12 3.14 3.16 3.17 3.19 3.21 3.23 3.25 3.26 3.28 18
2.51 2.53 2.56 2.58 2.61 2.63 2.66 2.68 2.70 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.96 2.97 2.99 3.01 3.02 3.04 3.06 3.07 3.09 19
2.39 2.42 2.44 2.46 2.48 2.51 2.53 2.55 2.57 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.80 2.81 2.83 2.84 2.86 2.87 2.89 2.90 2.91 20
2.29 2.31 2.33 2.35 2.37 2.39 2.41 2.43 2.45 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.66 2.67 2.68 2.70 2.71 2.72 2.74 2.75 2.76 21
2.20 2.22 2.24 2.25 2.27 2.29 2.31 2.33 2.34 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.53 2.54 2.56 2.57 2.58 2.59 2.60 2.61 2.63 22
2.11 2.13 2.15 2.16 2.18 2.20 2.21 2.23 2.24 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.42 2.43 2.44 2.45 2.46 2.47 2.48 2.49 2.50 23
2.03 2.05 2.07 2.08 2.10 2.11 2.13 2.14 2.16 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.31 2.32 2.33 2.34 2.35 2.36 2.37 2.38 2.39 24
1.96 1.98 1.99 2.01 2.02 2.04 2.05 2.06 2.08 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.22 2.23 2.24 2.25 2.25 2.26 2.27 2.28 2.29 25
1.90 1.91 1.93 1.94 1.95 1.97 1.98 1.99 2.00 2.01 2.02 2.03 2.04 2.06 2.07 2.08 2.09 2.09 2.10 2.11 2.12 2.13 2.14 2.15 2.16 2.16 2.17 2.18 2.19 2.20 26
1.84 1.85 1.86 1.88 1.89 1.90 1.91 1.92 1.93 1.94 1.95 1.96 1.97 1.98 1.99 2.00 2.01 2.02 2.03 2.04 2.04 2.05 2.06 2.07 2.07 2.08 2.09 2.10 2.10 2.11 27
1.78 1.79 1.81 1.82 1.83 1.84 1.85 1.86 1.87 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.98 1.99 1.99 2.00 2.01 2.01 2.02 2.03 2.03 28
1.73 1.74 1.75 1.76 1.77 1.78 1.79 1.80 1.81 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.91 1.92 1.92 1.93 1.94 1.94 1.95 1.95 1.96 29
1.68 1.69 1.70 1.71 1.72 1.73 1.74 1.75 1.76 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.85 1.85 1.86 1.87 1.87 1.88 1.88 1.89 1.89 30
1.64 1.65 1.66 1.66 1.67 1.68 1.69 1.70 1.71 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.79 1.80 1.80 1.81 1.81 1.82 1.82 1.83 1.83 31
1.60 1.60 1.61 1.62 1.63 1.64 1.64 1.65 1.66 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.74 1.74 1.75 1.75 1.76 1.76 1.76 1.77 1.77 32
1.56 1.56 1.57 1.58 1.59 1.59 1.60 1.61 1.61 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.68 1.69 1.69 1.70 1.70 1.71 1.71 1.72 1.72 33
1.52 1.53 1.53 1.54 1.55 1.55 1.56 1.57 1.57 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.64 1.64 1.65 1.65 1.65 1.66 1.66 1.67 1.67 34
1.48 1.49 1.50 1.50 1.51 1.51 1.52 1.53 1.53 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.59 1.60 1.60 1.60 1.61 1.61 1.61 1.62 1.62 35
1.45 1.46 1.46 1.47 1.47 1.48 1.48 1.49 1.49 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.55 1.55 1.56 1.56 1.56 1.57 1.57 1.57 1.58 36
1.42 1.42 1.43 1.43 1.44 1.45 1.45 1.45 1.46 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.51 1.51 1.52 1.52 1.52 1.53 1.53 1.53 1.54 37
1.39 1.39 1.40 1.40 1.41 1.41 1.42 1.42 1.43 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.47 1.48 1.48 1.48 1.48 1.49 1.49 1.49 1.50 38
1.36 1.37 1.37 1.37 1.38 1.38 1.39 1.39 1.40 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.44 1.44 1.44 1.45 1.45 1.45 1.45 1.46 1.46 39
1.33 1.34 1.34 1.35 1.35 1.35 1.36 1.36 1.37 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.40 1.41 1.41 1.41 1.41 1.42 1.42 1.42 1.42 40
1.31 1.31 1.32 1.32 1.32 1.33 1.33 1.33 1.34 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.37 1.37 1.38 1.38 1.38 1.38 1.39 1.39 1.39 41
1.28 1.29 1.29 1.29 1.30 1.30 1.30 1.31 1.31 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.34 1.34 1.35 1.35 1.35 1.35 1.35 1.36 1.36 42
1.26 1.26 1.27 1.27 1.27 1.28 1.28 1.28 1.28 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.31 1.32 1.32 1.32 1.32 1.32 1.32 1.33 1.33 43
1.24 1.24 1.24 1.25 1.25 1.25 1.25 1.26 1.26 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.29 1.29 1.29 1.29 1.29 1.29 1.30 1.30 1.30 44
1.22 1.22 1.22 1.22 1.23 1.23 1.23 1.23 1.24 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.26 1.26 1.26 1.26 1.27 1.27 1.27 1.27 1.27 45
1.20 1.20 1.20 1.20 1.21 1.21 1.21 1.21 1.21 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.24 1.24 1.24 1.24 1.24 1.24 1.24 1.24 1.25 46
1.18 1.18 1.18 1.18 1.19 1.19 1.19 1.19 1.19 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.21 1.21 1.21 1.22 1.22 1.22 1.22 1.22 1.22 47
1.16 1.16 1.16 1.16 1.17 1.17 1.17 1.17 1.17 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.19 1.19 1.19 1.19 1.19 1.19 1.20 1.20 1.20 48
1.14 1.14 1.14 1.14 1.15 1.15 1.15 1.15 1.15 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.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 49
1.12 1.12 1.13 1.13 1.13 1.13 1.13 1.13 1.13 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.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 50
1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.12 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.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 51
1.09 1.09 1.09 1.09 1.09 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 52
1.07 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 53
1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 54
1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.06 1.06 1.06 1.06 55
1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 56
1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 57
1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 58
3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4.0 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

RPMFs as
f(n,CV,Confidence,UpperBound)
400.00
350.00
300.00
❑350.00-400.00
LL 250.00
r'300.00-350.00
° ❑250.00-300.00
200.00
Q - ❑200.00-250.00
150.00 0 150.00-200.00
2
❑100.00-150.00
100.00
❑50.00-100.00
50.00 ____ o ❑0.00 50.00
1.1 r!
- - 0.1 >
1 4 7 10 13 16 19 22 25 v

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

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

Added Nichel WS to"rpa"page,revised both Nickel parametesr to share commom data,Nickel WS has no Acute standard so only list acute for FW
Set up both Nickel Par17&Par18 to use same data entries
Changed Par22-25 modifier cells to be set automtically based on WQS entry.
Changed display font color phenols,chlorinared phenols menus
2/22/16:
Make text changes per Julie direction.
2/24/16:
Added to"Diss to Total Metal Calculator"page:
1)Comment section for PERCS info or other to allow user to add commentary
2)Added Facility name to display based on input page
3)Added NPDES permit#to display based on input page
4)Set up new Name"PERCS_page"as print area for table and other PERCS info for GOTO use.
NOTE:User can either highlight desire print area or use GOTO feature to set up desired print arae.When in print mode set up,will need to designate"Print Selection".
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 label for other portion of the progam and has no Data Validation features.
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 number of data enties,data set average,data set 10th percentile value
3)Diss to Total Metal Calculator determines which upstream hardness to apply,if the number of data entries exceed 30 then the average value is used,if the number of data enties are less than 30 then the
10th percentile value is used.Anytime the applied upstream hardness is less than 25 mg/L then a default value of 25 mg/L is applied.
4/26/16:
Per Julia want to use average values for both the effluent and upstream hardness calculations.Defaults to be the same as was applied in the HUC base RPA.
1)Changed all upstream hardness median calculations to average calculations.
2)Removed any greater than 99.999 defaults from upstream hardness conditional statements.Upstream average will be actual execpt when less than 25,then 25 is the default.
3)Changed all effluent hardness median calculations to average calculations.Conditional statements for WS still apply,efflunet average value above 99.999 default to 99.
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 the combined hardness exceeds 100.Made changes:
1)Set up new cells to calculate combined acute and chronic hardness,defined cells as program names ACCH&ACAH.
2)Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH&ACAH exceed 100 when WS was applied.
3)Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate defaults
4)Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate defaults
4/28/16:
Fixed programming errors so"NO DETECTS"display feature on RPA page for Nickel and Chromium VI now function.
Revised RPA page drop menu"Recommended Action"list to remove RP Action Level text and change"RP non action level..."text to state"RP shown...".
Added statement to 2B.0500 RULES page"4/28/16:Note Action Level designation no long allowed per EPA."
4/29/16:
Added ROUND function to conditional statements on INPUT page hardess displays to limit hardness value display to 2 decimal points.
Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardness of 25 to be displayed as non-default value.
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 data to Cr III and Cr VI Allowable Cw
Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Total Chromium value entered
6/13/16:
Revised title block text RPA tab to state"NC STANDARDS OR EPA CRITERIA",removed"NC WQS"from Chronic label,and removed 1/2 FAV from Acute label.
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 calculated value exceeded 400 mg/L
Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when default 400 mg/L applied
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,MGD and CHRONIC DILITION FACTOR(from Model)and display in Model narrative box.
User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s,(cfs)entry box.1 Q10s is calculated once the calculated 7Q10s(cfs)is entered in Tablel.
Revised narrative in Model narrative box with new instructions,new messages to alert user on actions needed and/or completed to correctly enter Model 7Q10s(cfs)in Table 1.
Remove conditions and features assocaited with entry of Model Acute IWC%.

Date: 12/20/2021
Dissolved to Total Metal Calculator FACILITY:Mayo Steam Station
NPDES PERMIT:NC0038377 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 In accordance with Federal Regulations,permit limitations must be written as Total Metals per 40 CFR 122.45(c)
"Effluent Hardness"under the Data Sheet.
In accordance with 40 CFR 122.45(c),permits are,have and Receiving Receiving Rec.Stream NPDES Total Suspended Combined Combined Instream Instream Effluent
Upstream
must be written as total metals. Stream Stream Solids Hardness Hardness Wastewater Wastewater Hardness
1Q10 Flow Limit Hardness
summer summer 7Q10 -Fixed Value- chronic Acute Concentration Concentration Average(mg/L)
7Q10(CFS) (MGD) [MGD] MGD (mg/L) (mg/L) (mg/L) (Chronic) (Acute) (mg/L)
Average
This calculator has been inserted into the RPA to calculate Total
Metal allowable allocations once Table 1 has been completed o.0000 o.0000 0.0000 3.0000 25.000 II 25.000 II 100.0000 I 100.0000 25 25
(Input Sheet)and Effluent hardness has been entered(Data Upstream Hard Avg(mg/L)= 25 ACAH 25
EFF Hard Avg(mg/L)= 25 ACCH 25
Sheet).
1) Following the spreadsheet from left to right. First US EPA Maximum Allowable Effluent Concentration COMMENTS(identify parameters to PERCS Branch to maintain in facility's LTMP/STMP):
the allowable allocations for the dissolved metals will Dissolved Metals Translators-using (MAEC)as a Total Metal
PARAMETER Default Partition =Dissolved Metal-Translator
appear for all the metals listed once Table 1 is complete and Chronic Acute Coefficients Chronic Acute
effluent hardness entered.Use a default value of 25 mg/L if lug/Il fug/11 (streams) [uq/Il fug/Il
Cadmium(d) 0.15 0.82 0.252 0.59 3.24
no hardness data is available. Second,the Cd-Trout streams 0.15 0.51 0.252 0.59 2.01
Dissolved Metal allocations are divided by the Translators to Chromium III(d)(h) 24 183 0.202 117.73 905.08
determine the Total Metals that can be allocated to the Chromium VI(d) 11 16 1.000 11.00 16.00
Permittee.These Total Metals values are automatically Chromium,Total(t) N/A N/A
inserted into Table 2 and are the allowable Total Metal 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
allocations determined for the Permittee prior to allowing Nickel(d)(h) 16 145 0.432 37.23 335.21
for dilution.See Input sheet Table 2.The final acute and Ni-WS streams(t) 25 N/A
chronic values shown under the RPA sheet are the Total Silver(d)(h,acute) 0.06 0.30 1.000 0.06 0.30
Metal values listed in Table 2 divided by the acute and Zinc(d)(h) 36 36 0.288 126.73 125.71
chronic IWC,respectively. Beryllium 6.5 65 1.000 6.5 65
2) The Translators used in the freshwater RPA are the Partition Arsenic(d) 150 340 1.000 150 340
Coefficients published by US EPA in 1984.They are TSS
dependent equations and can be found listed with the WQS (d)=dissolved metal standard.See 15A NCAC 02B.0211 for more information.
hardness dependent equations under the sheet labeled (h)=hardness-dependent dissolved metal standard.See 15A NCAC 02B.0211 for more information.
Equations.A fixed TSS value of 10 mg/L is used to calculate (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 Translator values. The Human Health standard for Arsenic is 10 ug/L which is Total Recoverable metal standard.
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

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

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

lue for your facility, Click Here.
(month and submit one to two years of data with the permit renewal application. If no effluent hardness data is si
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+a)* 10-6)]
= 1
[1 + (4.00x106* 101-1.13°7)* 10-6)]
= 1
[1+2.960465]
=0.252