NC0001422_Worksheets_20220210 (KEEP ELECTRONIC COPY)

Worksheet - RPA

3
0

1

0

150
340
10

10
50

6.5
65

0.58987911307921359
3.239611736850295

211
230

8

500

117.73254526741752
905.0817858548595

11
16

0

0
7.8806391707256838
10.471993662870069

0
5
22
10

0
1800
160

0
2.94162407165387
75.487104032969768
2000

12
0.5

160

37.231337220463082
335.20869614001487

25

5
56

0.06
0.29639788810883572

126.73347513150829
125.70521164159749

71.400000000000006
96.7

15

3

1

0

2

,

0
0
0

3
4
5
6
7
8
9
10
11
12
13
14
15
16
19
20
21
22
23
24
25

1
25
25
0
1
25
25
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
10
5
4.7050770220634863
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0

2
25
2
25
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
10
10
7.1845454545454537
2
2
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

3
0.6
3
0.6
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
11
11
0.65488861499048912
3
3
3
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

4
1
4
1
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
0
4
7
7
22
4
0
4
0
4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

5
25
5
25
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
6
6
5
5
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

6
25
6
25
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
1.35
6
6
6
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

7
25
7
25
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
5
5
26.4
7
7
7
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
35.64
8
8
8
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
8
8
9
9
9
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
8
8
10
10
10
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
7
7
11
11
11
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
8
8
12
12
12
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
6
6
13
13
13
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
5
5
14
14
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
4.16
4.16
15
15
15
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
3.77
3.77
16
16
16
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
3.79
3.79
17
17
17
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
4.87
4.87
18
18
18
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
4.6399999999999997
4.6399999999999997
19
19
19
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
26.4
26.4
20
20
20
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
5.23
5.23
21
21
21
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
5.2
5.2
22
22
22
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
23
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
24
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
26
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
27
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
29
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
32
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
34
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
35
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
36
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
37
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
39
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
41
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
42
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
43
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
44
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
46
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
47
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
48
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
49
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
51
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
52
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
53
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
54
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
55
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
56
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
57
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
58
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0

0
0
0

1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
22
21
0
0
0
0
0
0

0.6
0.65488861499048912

0.6
0.6

1
22

7
7

6.1977451171828228
1.3236323171549016

7.9837491295123098
1.3761646025454706

6.1977451171828228
1.3524665610286359

6.2
1.35

Arial,Bold" 8REASONABLE POTENTIAL ANALYSIS - - ,

211

0
100

0
100

0
100

0
100

0
100

340

150
340

0
0
150

2
10
10

3
65

6.5
65
0
0

6.5

4
3.239611736850295

0.58987911307921359
3.239611736850295
0
0

0.58987911307921359

5

230
0
0

230

6

8
0
0

8

7

500
0
0

500

8
905.0817858548595

117.73254526741752
905.0817858548595
0
0

117.73254526741752

9
16

11
16
0
0

11

10

0
0

11
10.471993662870069

7.8806391707256838
10.471993662870069
0
0

7.8806391707256838

12
22

5
22
10
0
0

5

13

1800
0
0

1800

14
75.487104032969768

2.94162407165387
75.487104032969768
0
0

2.94162407165387

15

12
0.5
0
0

12

16

160
0
0

160

17
335.20869614001487

37.231337220463082
335.20869614001487

0
0
37.231337220463082

18

25
25

19
56

5
56
0
0

5

0.29639788810883572

20
0.06
0.29639788810883572
0
0

0.06

21
125.70521164159749

126.73347513150829
125.70521164159749
0
0

126.7334751315083

22
96.7

71.400000000000006
96.7
22
21
35.64

71.400000000000006

23

0
0

24

0
0

25

0
0

Page of ,

,

1

2
10
5

3
9
9
5

4
0

5

6
10
5

7
9
4.5
0

8

9

10

11

12

13

,

0.95

0.95

0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
1.1000000000000001
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2
2.1
2.2000000000000002
2.2999999999999998
2.4
2.5
2.6
2.7
2.8
2.9
3
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4
4.0999999999999996
4.2
4.3
4.4000000000000004
4.5
4.5999999999999996
4.7
4.8
4.9000000000000004
5
5.0999999999999996
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
6
6.1

1
1
1.388400997733763
1.9184179525863208
2.6266984330801288
3.5515003516286621
4.7303268635960807
6.1977451171828228
7.9837491295123098
10.112820236019875
12.603647258647346
15.469354589761483
18.718053656169833
22.353554076249154
26.376114063054608
30.783154031216604
35.569893028432325
40.729892275436313
46.255505208121519
52.138241536233295
58.369056386185548
64.93857643324597
71.837274310027496
79.055601291153991
86.584086754884339
94.413411455076499
102.53446031598482
110.93835932942842
119.61650019124889
128.560555545413
137.76248708610231
147.21454827594397
156.90928304923028
166.83952156251746
176.99837381459201
187.3792217696697
197.97571047075508
208.78173851547723
219.79144817744074
230.99921538665359
242.39963972861628
253.9875345797642
265.75791746452359
277.70600069417543
289.82718232844303
302.11703748590963
314.5713100181103
327.18590455358833
339.9568789118199
352.88043688216464
365.95292135955071
379.17080782618308
392.53069816685991
406.02931480445437
419.66349514146634
433.43018629329748
447.32644009890322
461.34940839463735
475.49633853745451
489.76456916404481
504.15152617299009
518.65471891754169
533.27173659722007
1

2
1
1.2711146905049311
1.6100674697271373
2.0258510292217733
2.5256637572735507
3.1144074156501782
3.7945305300724566
4.5661831387983813
5.4275808324597659
6.3754619643255932
7.405545184461368
8.5129308173867049
9.6924221007219415
10.93876429708264
12.246811412711242
13.611634632896882
15.028586698224398
16.493334568241472
18.001870223370229
19.55050704360713
21.135867161295796
22.754863581045029
24.404679657200106
26.082747646904544
27.786727439665974
29.51448613680023
31.264078863610234
33.033731003697838
34.821821919011661
36.626870139956637
38.447519962172386
40.282529359969779
42.13075911366812
43.991163044247187
45.862779250451958
47.744722248511181
49.636175921449379
51.536387192616921
53.444660345901163
55.360351922740598
57.282866133309227
59.211650725956424
61.146193265125042
63.08601777352191
65.03068169929422
66.979773173413847
68.932908526422523
70.889730037195676
72.849903889482391
74.8131183147174
76.779081902017595
78.747522058408592
80.71818360420869
82.690827490155385
84.665229624326514
86.641179798201151
88.618480702347554
90.596947023236893
92.5764046135764
94.556689729348506
96.537648327441872
98.519135418390789
2

3
1
1.2184765571307379
1.4803959236461235
1.788764713420792
2.145050565827721
2.549143761958347
2.9995330437419034
3.4936178658368013
4.0280669969906526
4.5991531330505673
5.2030245822118122
5.8359024884246926
6.4942093302864068
7.1746421887718865
7.8742057052975234
8.5902178639732796
9.3202988393116684
10.06235028219209
10.814530036014753
11.575225481561418
12.343027441289179
13.116705719160338
13.895186799015242
14.677533880870865
15.462929231185296
16.250658710886594
17.040098290163098
17.830702339252937
18.621993485196469
19.413553836468925
20.205017394843896
20.996063493281202
21.786411118073353
22.575813991826344
23.364056310559551
24.150949043090819
24.936326713924984
25.720044602193248
26.50197629895176
27.282011573516122
28.060054506657906
28.836021854584128
29.609841612809067
30.381451753443027
31.150799113178135
31.917838412448212
32.682531388961458
33.44484603112496
34.204755898860277
34.962239520999951
35.717279859903229
36.46986383516743
37.219981899377146
37.967627659746015
38.712797540293892
39.455490479880616
40.195707662003336
40.93345227277117
41.668729283910587
42.401545258035888
43.131908173749586
43.859827268427701
3

4
1
1.1863305480663198
1.403863746293363
1.6534139247853803
1.9346058223632958
2.2459872214933143
2.5852709561284608
2.9496311085685396
3.3359864830888708
3.7412304822882132
4.1623933362996555
4.5967410412120788
5.0418240825363876
5.4954907723133219
5.9558781356014521
6.4213901553659127
6.8906701324160631
7.3625714578813755
7.8361293170946134
8.3105346495471171
8.7851109350009864
9.2592939266742338
9.7326142038031946
10.204682293021309
10.675176060507983
11.14383007225368
11.610426637812642
12.074788281388392
12.536771415970859
12.996261027650799
13.453166206231426
13.907416384017473
14.35895816699956
14.807752661712728
15.253773217137878
15.69700351449764
16.137435949040793
16.575070257254925
17.009912350701146
17.441973324091933
17.871268610560453
18.297817261486056
18.72164133190465
19.142765355576397
19.561215896314074
19.977021164283926
20.390210687749299
20.800815032197544
21.208865560021223
21.614394224956612
22.017433396350278
22.418015709054171
22.816173935366439
23.211940875954781
23.605349267140518
23.996431702295293
24.385220565419459
24.771747975242143
25.156045738413251
25.538145310554572
25.918077764105465
26.295873762043499
4

5
1
1.1638376223078939
1.35151239692748
1.5628458293753913
1.7967403446344961
2.0513457258914021
2.3243027945588777
2.6129992079408582
2.9147886861021597
3.2271505468534918
3.547787878368545
3.8746748672174989
4.2060677593864186
4.540492931808588
4.8767225247154649
5.2137448190821285
5.5507338312079
5.8870206314716285
6.222067596244254
6.5554460074883654
6.8868169651124784
7.2159153482381138
7.5425364655996416
7.8665250148056991
8.1877659892658894
8.5061772088398637
8.8217031935454742
9.134310142474579
9.4439818192631328
9.7507161798042379
10.054522607167977
10.355419643207858
10.653433126622209
10.948594663897033
11.24094037316347
11.530509852080977
11.817345329859434
12.101490970843011
12.382992303012811
12.661895749585829
12.938248245806797
13.212096926219889
13.483488870307786
13.752470896509612
14.019089396366198
14.283390201964851
14.545418481024607
14.805218654924426
15.062834335769276
15.31830827924334
15.571682350540886
15.822997501113926
16.072293754348394
16.319610198590109
16.564984986199839
16.808455337532315
17.050057548913525
17.28982700384136
17.527798186760709
17.764004698869918
17.998479275504152
18.231253804716157
5

6
1
1.1468313902653384
1.3125866775205839
1.4965890703276736
1.6974437183544402
1.9132209679585921
2.1416836263431502
2.3805033741203872
2.6274309750079765
2.8804082302924567
3.137626545006027
3.397544944779209
3.6588815659361598
3.9205903162869267
4.1818310526502511
4.4419385581748632
4.7003932889655795
4.956795306786538
5.2108418647444346
5.4623085829737956
5.7110338897865622
5.9569063018232731
6.1998541031022629
6.4398370135525376
6.6768394870178094
6.9108653327606593
7.1419334060341999
7.3700741591620647
7.595326883792394
7.8177375076979798
8.0373568363227754
8.2542391510436417
8.468441093653345
8.6800207806342513
8.8890371020380403
9.0955491687665297
9.2996158792146577
9.5012955819566987
9.7006458157251299
9.8977231115845221
10.092582845127286
10.285279128863165
10.475864736857631
10.664391055189727
10.850908053020843
11.03546427005198
11.218106816944104
11.398881385922129
11.577832269306953
11.755002384145611
11.930433301456079
12.104165278885185
12.276237295808508
12.446687090088499
12.615551195860791
12.782864981844041
12.948662689770877
13.112977472621621
13.275841432410813
13.437285657332614
13.597340258116695
13.756034403483675
6

7
1
1.1333128961329395
1.2820468884599225
1.4452643355349699
1.6214605553119896
1.8087481862660326
2.0050635823609149
2.208349366424434
2.4166875589023444
2.6283783807432357
2.8419731451993822
3.0562747135539858
3.270318492857152
3.483343995355153
3.69476363386734
3.9041326573760933
4.1111221786875696
4.3154960173427774
4.517091383049272
4.715803074724243
4.911570729185164
5.1043686283651919
5.2941976067696039
5.4810786580510573
5.665047902743539
5.8461526392188592
6.0244482528929577
6.1999958034896911
6.37286014703938
6.5431084791270928
6.7108092097797432
6.8760310993412803
7.0388425996704562
7.1993113568046354
7.3575038405242612
7.5134850735582983
7.6673184389158404
7.8190655483494922
7.9687861585161448
8.1165381242079722
8.2623773802428708
8.406357945356012
8.5485319428217164
8.6889496336350938
8.8276594589563402
8.9647080892150122
9.1001404778239472
9.2339999178927137
9.3663281006810042
9.4971651748120536
9.6265498054891356
9.7545192331356656
9.8811093310214009
10.006354661549377
10.130288530968073
10.252943042344061
10.374349146686324
10.494536692157604
10.613534471342527
10.731370266569035
10.848070893300177
10.963662241629065
7

8
1
1.1221834441792538
1.2571720417397096
1.403892979170472
1.5608220057661784
1.7261619028123971
1.898028040064305
2.0746026982459882
2.2542398290086405
2.4355200969862376
2.6172665260901438
2.7985340779168415
2.9785849534231823
3.1568581766657124
3.332938818677369
3.5065297494293977
3.6774271606333064
3.8455001263169111
4.0106739553536928
4.17291686533932
4.3322294459789701
4.4886364028990524
4.6421801324677645
4.7929157489239937
4.9409072538292955
5.086224598852592
5.2289414443845788
5.3691334586253063
5.5068770356149965
5.6422483374771932
5.7753225871938945
5.9061735546757763
6.0348731916903677
6.1614913811547218
6.2860957740165082
6.4087516929357111
6.529522086627054
6.6484675223333154
6.7656462067059122
6.8811140275527434
6.9949246106140288
7.1071293868528951
7.2177776667819122
7.3269167191547826
7.4345918519830345
7.540846494330733
7.6457222777248157
7.7492591163192257
7.8514952851849342
7.9524674962801072
8.052210971795871
8.1507595146821785
8.2481455762423561
8.344400320748754
8.4395536870805685
8.5336344474210986
8.6266702630783296
8.7186877375119334
8.809712466663072
8.8997690866921673
8.988881319234924
9.077072014289632
8

9
1
1.1127804729937327
1.2363444869647875
1.3695550835358321
1.5109139927213577
1.6587311431880762
1.8112908902396543
1.9669829259354554
2.1243850125985966
2.2823005896391373
2.4397625362081592
2.5960159016104458
2.7504902316606268
2.9027688082168437
3.0525591183517298
3.1996666786364503
3.3439729515360921
3.4854173136166433
3.6239826609443413
3.75968410177637
3.8925601795410198
4.0226661222806461
4.1500686898264831
4.27484226709519
4.3970659218880561
4.5168212051356784
4.6341905203254434
4.7492559278733566
4.8620982809264754
4.9727966130225445
5.081427716560432
5.1880658653097118
5.2927826451562856
5.3956468656963468
5.4967245317430349
5.5960788587562353
5.6937703199984018
5.7898567161285319
5.8843932601790234
5.9774326725744302
6.069025282167738
6.1592191302810546
6.2480600755140685
6.335591897679584
6.4218563996819755
6.5068935065037792
6.5907413607319523
6.673436414257786
6.7550135159373728
6.83550599511429
6.914945740991449
6.993363277901512
7.070787836570454
7.1472474215001869
7.2227688746176328
7.2973779353509984
7.3710992973014733
7.4439566616816064
7.5159727876914175
7.5871695400004953
7.6575679334999123
7.7271881754822003
9

10
1
1.1046764909438496
1.2185327471081142
1.3404096329234578
1.4688580983627315
1.6022985498197178
1.7391696568600037
1.8780397885802698
2.0176724008714637
2.1570506074984741
2.2953726114373998
2.4320301265943076
2.5665793391412213
2.6987106771070764
2.8282208728702392
2.9549888628649548
3.0789558942231419
3.2001095881508435
3.3184714406564924
3.4340871709940619
3.5470193583500405
3.6573418798587696
3.7651357466424149
3.870486013988454
3.9734795107560781
4.0742031900895244
4.1727429491706003
4.2691828016005804
4.3636043137995824
4.4560862381747164
4.5467042921324134
4.6355310444380118
4.7226358798652166
4.8080850202384449
4.8919415853988433
4.9742656817378927
5.0551145090590595
5.1345424788892258
5.212601339150245
5.2893403014552254
5.3648061683187267
5.4390434583440266
5.512094528034206
5.5839996893124706
5.6547973221654741
5.7245239820678933
5.7932145020269639
5.8609020892177304
5.9276184162747496
5.9933937073731096
6.0582568192775845
6.122235317568725
6.185355548272927
6.2476427051326775
6.3091208927560016
6.3698131858822569
6.4297416849959497
6.4889275685127412
6.5473911417525796
6.605151882904722
6.6622284861787406
6.7186389023248019
10

11
1
1.0975810834536988
1.2030430877972527
1.3152302214618519
1.4327541126327428
1.5541427980045761
1.6779740098402502
1.8029703211906771
1.9280507004586387
2.0523451929463836
2.1751844530575997
2.2960755132013859
2.414672361030461
2.5307467074442114
2.6441617593397222
2.754850092504876
2.8627957241256752
2.9680199904650468
3.0705706469982408
3.1705135859028952
3.2679266218141492
3.3628948814807935
3.4555074207699725
3.5458547717607898
3.6340271894087288
3.7201134211726323
3.8041998654267157
3.8863700173145097
3.9667041258250304
4.0452790049503147
4.122167956199223
4.1974407705992487
4.2711637864769303
4.343399985430624
4.4142091135004211
4.4836478179799482
4.5517697928903083
4.6186259280631647
4.6842644582194843
4.7487311095040283
4.812069241734263
4.874319985214405
4.9355223714017926
4.9957134570327568
5.0549284415471849
5.1132007778174771
5.17056227630456
5.2270432028440306
5.2826723703183847
5.3374772245039681
5.3914839243991457
5.4447174173470465
5.4972015092656026
5.5489589302912039
5.600011396132305
5.6503796654169429
5.7000835933039706
5.7491421816131494
5.797573625714092
5.8453953583990588
5.892624090949842
5.9392758515949362
11

12
1
1.091288770356138
1.1893889132418258
1.2931637402203275
1.4012905506435089
1.5123994654518977
1.625192946631737
1.7385272252633108
1.851452706548224
1.9632210659315639
2.0732705926365456
2.1812004142818981
2.2867412978116755
2.3897276576359103
2.4900730393622204
2.5877498239651051
2.6827730512670596
2.7751878695146508
2.865059992496291
2.9524685588070412
3.0375008617875685
3.1202485107308702
3.2008046732057616
3.2792621260786206
3.3557119066865364
3.4302424062824461
3.5029387871694646
3.5738826349676267
3.6431517801702822
3.710820240213736
3.7769582460481197
3.8416323267145271
3.9049054325138397
3.9668370826118777
4.0274835268267335
4.0868979142340711
4.1451304633636257
4.2022286303378777
4.258237272465176
4.3131988056511927
4.3671533546139596
4.420138895337848
4.4721913895247782
4.5233449110296906
4.5736317644260929
4.6230825959549042
4.6717264971792964
4.7195911017101206
4.7667026753883475
4.8130862003184491
4.8587654531440698
4.9037630779476578
4.9481006541415864
4.9917987597009494
5.0348770300693912
5.0773542130495706
5.1192482199699514
5.1605761734000586
5.2013544516673003
5.2415987304103338
5.2813240213865882
5.3205447087354312
12

13
1
1.0856493005907124
1.177217127710428
1.2735956431833646
1.3735291794521369
1.4757433747098427
1.5790524868454368
1.6824291978840016
1.7850359512083005
1.8862261842261618
1.9855267128463285
2.082611168811713
2.177271402925796
2.2693908449167921
2.3589216409049887
2.4458660372474821
2.5302617600735862
2.612170830683477
2.691671181010852
2.7688504730265766
2.8438016121575087
2.9166195409034077
2.9873989877510856
3.0562329218110427
3.1232115243091405
3.1884215355030685
3.2519458719236964
3.3138634362942443
3.3742490630363422
3.433173557568058
3.4907037989311407
3.546902883654119
3.6018302949243459
3.655542085676228
3.708091067530241
3.7595269999536645
3.8098967757928635
3.8592446006213073
3.907612164284533
3.9550388036973549
4.0015616564291001
4.0472158049509774
4.0920344116536507
4.1360488449010102
4.179288796488402
4.2217823909358687
4.2635562870802941
4.3046357724433726
4.3450448508509734
4.3848063237683492
4.4239418657981737
4.4624720947666958

4.5004166367995584
4.5377941867637137
4.5746225644268614
4.6109187666610874
4.6466990159935131
4.6819788057839578
4.7167729422881477
4.7510955838447693
4.7849602774057765
4.8183799926119368
13

14
1
1.0805497780313689
1.1662642238693903
1.2560702869105569
1.3487786395417505
1.4432036714972012
1.5382599709554601
1.6330222209721874
1.7267491072604246
1.8188799968276852
1.9090152634192596
1.996889462026616
2.0823435682772584
2.165299725626594
2.245739951887129
2.3236890550665557
2.3992013963220709
2.4723508967408057
2.5432236476417174
2.611912543558085
2.6785134514633642
2.7431225276678175
2.8058343812314837
2.8667408551765985
2.9259302542280281
2.9834868921220679
3.039490865087167
3.0940179832104624
3.1471398100316801
3.1989237744424588
3.2494333290551394
3.2987281365864778
3.3468642711886982
3.3938944255815962
3.4398681176855725
3.4848318925143613
3.5288295165691013
3.5719021630373469
3.6140885868552082
3.6554252892213301
3.695946671519013
3.7356851788519609
3.7746714335628901
3.8129343592065648
3.8505012955071329
3.8873981048571236
3.9236492709212243
3.9592779898990464
3.9943062549823782
4.0287549345175497
4.0626438443550619
4.095991814838305
4.1288167528525586
4.1611356993249187
4.1929648825365158
4.2243197675802389
4.2552151022707152
4.2856649597884129
4.3156827783166642
4.3452813979089928
4.3744730948042907
4.4032696133893294
14

15
1
1.0759034127736975
1.1563288675517711
1.2402415710818671
1.3265166921790381
1.4140508063153079
1.5018487430398315
1.5890749915338107
1.6750714849606809
1.7593507357215452
1.8415747704865848
1.9215284086740909
1.999092478473862
2.0742199424086141
2.146916077155081
2.2172227834416804
2.2852065811221172
2.3509496595629096
2.4145433473344693
2.4760834393556275
2.5356669192713079
2.5933897128634649
2.6493451934658596
2.7036232296487546
2.7563096196403385
2.8074857982893247
2.8572287333748392
2.9056109510539367
2.952700647140686
2.9985618532704099
3.0432546360001544
3.0868353134228821
3.1293566785912756
3.1708682224466935
3.2114163513886571
3.2510445963627221
3.2897938115810148
3.3277023618596631
3.3648062981621809
3.4011395213514777
3.4367339344293928
3.4716195837203534
3.5058247895635546
3.5393762671364479
3.5722992380562979
3.6046175334069765
3.6363536888227501
3.6675290322352541
3.6981637648581023
3.7282770359484467
3.7578870118483541
3.787010939772308
3.8156652067715919
3.8438653942720902
3.8716263285497843
3.8989621274779291
3.9258862438516862
3.9524115055699229
3.9785501529298823
4.0043138732683285
4.0297138331625622
4.0547607083862669
15

16
1
1.0716421714593474
1.147254112634327
1.2258411335264769
1.3063404371065523
1.3877246015572053
1.4690798401104719
1.549650095574495
1.6288497542586204
1.7062540279622893
1.7815770013477763
1.8546452720723479
1.9253722226733743
1.993735489679566
2.0597585186412641
2.1234961419724674
2.1850236740640803
2.2444288796931522
2.3018061901041711
2.3572526260953368
2.4108649900918548
2.4627379862384431
2.5129630099901563
2.5616274147256015
2.6088141139461878
2.6546014161596596
2.6990630181865769
2.742268103684331
2.7842815090436317
2.8251639299528688
2.8649721499685858
2.9037592782133883
2.9415749874642056
2.9784657468469868
3.0144750454483518
3.0496436046301536
3.0840095778628571
3.1176087376037511
3.1504746492271507
3.1826388323314498
3.214130909949739
3.2449787463107058
3.2752085738594667
3.3048451102715704
3.333911666190299
3.3624302443968173
3.3904216310909527
3.4179054799222266
3.4449003893691956
3.471423974022517
3.4974929302848836
3.5231230969599969
3.5483295111638418
3.5731264599547741
3.5975275280447874
3.6215456419226868
3.6451931106907067
3.6684816638893794
3.6914224865609948
3.7140262517797185
3.7363031508560121
3.7582629214046599
16

17
1
1.0677118197943456
1.1389154817850857
1.2126571651784819
1.2879333432865017
1.363786868092288
1.4393775558882509
1.514019960497007
1.5871918744479685
1.658522582288227
1.7277704020175464
1.7947968677372659
1.8595420960273212
1.9220035492704237
1.9822188701567305
2.0402526134335188
2.0961863258111548
2.1501113252005268
2.2021235682449913
2.2523200878445047
2.3007965863895783
2.3476458657102519
2.3929568541781228
2.4368140541781136
2.4792972811654073
2.5204816014312512
2.5604374021691849
2.5992305467398764
2.6369225820087432
2.6735709746883081
2.709229360819446
2.7439477976595028
2.777773010886869
2.810748632600407
2.8429154273913717
2.8743115050142594
2.9049725190388864
2.9349318514423861
2.9642207834781251
2.9928686533972177
3.0209030017392742
3.0483497049822534
3.0752330983681251
3.1015760887169805
3.1274002580177487
3.1527259585467675
3.1775724002211705
3.2019577308463281
3.2258991098677203
3.2494127761895175
3.2725141105757465
3.2952176931058688
3.3175373561154808
3.3394862330144721
3.3610768033397393
3.3823209343671414
3.4032299195777584
3.4238145142465326
3.444084968396826
3.4640510573421794
3.4837221100162918
3.5031070352740423
17

18
1
1.0640684858258169
1.131212751947489
1.2005198909408614
1.2710427717344681
1.3418892590800811
1.4122859242385195
1.4816103330150456
1.5493960391283419
1.6153192073414819
1.6791759409838527
1.7408571331210132
1.8003249389865807
1.8575927766351585
1.9127093499012464
1.9657464315171551
2.0167898271095188
2.0659328733249249
2.1132718764957974
2.1589029964119479
2.2029201839155239
2.2454138740075194
2.2864702124092928
2.3261706530778619
2.3645918092710914
2.4018054742146275
2.4378787518927667
2.4728742562033568
2.5068503494484284
2.539861400225333
2.5719580472425378
2.6031874601485439
2.6335935916685767
2.6632174175800976
2.6920971626039361
2.7202685113432405
2.7477648041108984
2.7746172179500119
2.8008549334444797
2.8265052880899821
2.85159391708665
2.8761448824498492
2.90018079133332
2.9237229044327497
2.9467912352966326
2.9694046413216433
2.991580907155948
3.0133368211789251
3.0346882456716591
3.055650181240511
3.0762368260068418
3.0964616300299186
3.1163373453875338
3.1358760722995678
3.1550893016439718
3.173987954181928
3.1925824167792576
3.2108825758842374
3.2288978484975881
3.2466372108484292
3.2641092249699835
3.2813220633509959
18

19
1
1.0606762200810236
1.1240641538588212
1.1892913696537364
1.2554642606440107
1.3217508959395492
1.3874385576880444
1.4519612549384728
1.5149017933224531
1.5759771691839159
1.6350159078346347
1.69193366961006
1.7467108218739056
1.7993736168767631
1.849979317941332
1.8986049419721749
1.9453390193334446
1.9902757316111139
2.0335108530208363
2.0751390229409186
2.115251980400608
2.1539374816244101
2.1912786947348404
2.2273539221278402
2.2622365433786018
2.2959951027051133
2.3286934876504515
2.3603911619176734
2.3911434269015754
2.4210016946925594
2.4500137611284885
2.4782240715332429
2.5056739746061862
2.5324019618744167
2.5584438914467684
2.5838331956983067
2.608601073097101
2.6327766647540298
2.6563872164970235
2.679458227389965
2.7020135856664003
2.724075693052284
2.7456655784264572
2.7668030017238059
2.7875065489316837
2.8077937189708146
2.8276810031908131
2.847183958150302
2.8663172722936583
2.8850948270816814
2.9035297530824269
2.9216344814812047
2.9394207914254791
2.9568998535807789
2.974082270237806
2.990978112278329
3.0075969532779308
3.0239479009970696
3.0400396264879053
3.0558803910227144
3.0714780710301812
3.0868401812084114
19

20
1
1.0575052268555922
1.1174021879759231
1.1788581711243296
1.2410302931488335
1.3031424427820224
1.3645372616170057
1.4246994921144833
1.4832556111318562
1.5399583202317686
1.5946640681030018
1.6473094689546128
1.6978899556667684
1.7464420741521678
1.7930296336849791
1.8377333263470301
1.8806432052878026
1.9218533934706761
1.9614584692256469
1.9995510787422386
2.0362204274804623
2.0715513897904847
2.1056240457642805
2.138513507712974
2.1702899384020302
2.201018692216993
2.2307605313762253
2.2595718842635146
2.287505123551155
2.3146088492425392
2.3409281669778244
2.3665049555660254
2.3913781201982283
2.4155838294926841
2.4391557356602678
2.4621251778261843
2.4845213690198573
2.5063715676334808
2.5277012343100465
2.5485341752952246
2.5688926733035609
2.588797606928261
2.6082685595795025
2.6273239188785751
2.6459809673705661
2.6642559653514759
2.682164226539272
2.6997201872544063
2.716937469714813
2.7338289399939328
2.7504067611382186
2.7666824418927298
2.7826668814399564
2.7983704105174101
2.8138028292437971
2.8289734419513253
2.8438910892926055
2.8585641778644382
2.8730007075672805
2.8872082968980592
2.9011942063549618
2.9149653601158731
20

21
1
1.0545305581167939
1.1111705489561277
1.169126016858882
1.2276021109096542
1.2858745440217658
1.3433365631601777
1.3995186548751657
1.454086152262801
1.5068230866581398
1.5576100283189878
1.6064013533682897
1.6532049518922005
1.6980655791435819
1.7410519570289364
1.782247196527486
1.8217419260211485
1.8596295112684265
1.8960028346072291
1.9309522057117976
1.96456407603529
1.9969203132587729
2.0280978585569422
2.0581686399348871
2.0871996521694731
2.1152531409472615
2.1423868481782122
2.1686542892195169
2.1941050424249138
2.2187850381990928
2.2427368394283049
2.2659999083854077
2.288610857404739
2.3106036820982148
2.3320099768573335
2.3528591330104418
2.3731785203890476
2.3929936532773532
2.4123283418287325
2.431204830068797
2.4496439215929073
2.4676650940242721
2.4852866032394147
2.502525578299208
2.5193981079512469
2.5359193194969754
2.5521034507467011
2.5679639157191292
2.5835133646798636
2.5987637390559213
2.6137263217107547
2.6284117830163378
2.6428302231155794
2.6569912107290437
2.6709038188247236
2.6845766574378414
2.6980179038991472
2.7112353307046235
2.7242363312365629
2.7370279435254652
2.7496168722237035
2.7620095089455159
21

22
1
1.0517311330062327
1.1053218267164204
1.1600157903271688
1.2150636430694843
1.2697892804714184
1.3236323171549016
1.3761646025454706
1.4270861473834286
1.4762085542301229
1.5234332800274479
1.568729772111195
1.6121162001614338
1.6536438065923513
1.693384892045416
1.7314239743491253
1.767851506500981
1.8027595556173908
1.8362389320398489
1.868377362519694
1.8992583987743958
1.9289608336757207
1.9575584606311274
1.9851200593585563
2.0117095262155216
2.0373860924559328
2.0622045917403264
2.0862157508821104
2.109466486661745
2.1320001976796732
2.1538570444424074
2.1750742137542285
2.1956861654244051
2.2157248605828559
2.2352199717272945
2.2541990751434726
2.2726878266460777
2.2907101217502577
2.3082882414506103
2.3254429847890576
2.3421937893583538
2.3585588408296476
2.3745551725212257
2.3901987559484996
2.4055045832169575
2.4204867420434102
2.4351584841179625
2.4495322874510217
2.4636199132865904
2.4774324581053389
2.4909804011884438
2.5042736481655363
2.5173215709272427
2.5301330442441365
2.5427164793993082
2.5550798551106584
2.5672307459912327
2.5791763487709987
2.5909235064812042
2.6024787307825594
2.6138482226006126
2.6250378912158232
22

23
1
1.0490889908191379
1.0998157619234743
1.1514605209468105
1.2033169333546925
1.2547537554179675
1.3052531793264517
1.3544245524274554
1.4019989173242497
1.4478122002381655
1.4917839752429622
1.5338964782528013
1.5741763288287745
1.6126798246456819
1.6494817493046949
1.6846672080630225
1.7183258818516232
1.7505481193126757
1.7814223777188489
1.8110336276177561
1.8394624306846581
1.8667844779639451
1.8930704358660275
1.9183859922431403
1.9427920276439741
1.9663448603398457
1.9890965303427104
2.0110950992864978
2.0323849511365304
2.0530070842660195
2.0729993892424949
2.0923969092341075
2.1112320816532564
2.1295349607684195
2.1473334217202225
2.1646533468045188
2.1815187951238273
2.1979521568215903
2.2139742931447022
2.2296046635583062
2.2448614410834713
2.259761616956689
2.274321095629471
2.2885547810427846
2.3024766550284159
2.3160998486101607
2.329436706903226
2.3424988482412474
2.355297218096994
2.3678421383052601
2.3801433520442843
2.3922100649850293
2.4040509829754804
2.4156743465891983
2.4270879628335758
2.4382992342829035
2.4493151858743318
2.4601424895806754
2.4707874871524247
2.4812562111020973
2.4915544040868545
2.5016875368299822
23

24
1
1.0465887142307888
1.0946179041157817
1.1434030724517161
1.1922786469773985
1.2406552106734359
1.2880541325087616
1.3341188335451346
1.378608191604161
1.421379635449922
1.4623684717663532
1.5015677774127001
1.5390110755754458
1.5747585220200808
1.6088864785898398
1.6414799718215274
1.6726274352612833
1.7024171741235108
1.7309350847035707
1.7582632635858084
1.7844792333815935
1.8096555861486245
1.8338599028000839
1.8571548492096011
1.8795983804370546
1.9012440063898208
1.9221410876372687
1.9423351408249878
1.9618681405397886
1.9807788095398562
1.9991028926910142
2.0168734122393794
2.0341209035543146
2.050873631439575
2.0671577877065666
2.0829976710506903
2.0984158504525063
2.113433313396667
2.1280696002024202
2.1423429257165068
2.1562702895506738
2.1698675759637283
2.1831496444002028
2.196130411609325
2.2088229261823509
2.2212394362653827
2.2333914511294091
2.2452897972101429
2.2569446691671331
2.2683656764545397
2.2795618858445703
2.2905418602983385
2.3013136945376345
2.3118850476340986
2.3222631728993415
2.33245494533013
2.3424668868365677
2.3523051894578009
2.3619757367490068
2.3714841235048438
2.3808356739679692
2.3900354586565364
24

25
1
1.0442169785584385
1.0896985667559909
1.1357943488344626
1.1818773682468968
1.227397259398944
1.2719115069797784
1.3150945598393848
1.3567303153732231
1.396695242152854
1.4349383158939453
1.4714617839042907
1.5063047595189569
1.5395302507611333
1.5712154475283098
1.6014447544147319
1.6303049786852404
1.6578821317326364
1.6842593977109028
1.709515923838608
1.7337261754599553
1.7569596701030912
1.7792809589977507
1.8007497644719606
1.8214212104288803
1.8413461034986545
1.8605712367302372
1.8791396975692669
1.8970911686441598
1.9144622144827466
1.9312865503685128
1.9475952915863366
1.9634171826300004
1.9787788067760179
1.9937047769287273
2.0082179089196441
2.0223393785751149
2.0360888639020125
2.0494846737168033
2.0625438639826643
2.0752823430384271
2.0877149668125714
2.0998556250221423
2.1117173192647423
2.1233122338241657
2.1346517999283625
2.1457467541229494
2.1566071913545044
2.1672426132955263
2.1776619723865998
2.1878737120209037
2.1978858032509612
2.2077057783572926
2.2173407615826064
2.2267974973032256
2.2360823758809532
2.2452014574132209
2.2541604935768484
2.2629649477406812
2.2716200135045335
2.2801306318059278
2.2885015067220196
25

26
1
1.0419621956206768
1.0850320043433819
1.1285918860306652
1.172051485585013
1.2148969460570551
1.2567191042966042
1.29722071732007
1.3362082115564828
1.3735749357659199
1.4092817404601634
1.4433386037850848
1.4757891082909096
1.5066982655318528
1.5361434691707241
1.5642080579340591
1.5909769110398575
1.6165335546248256
1.6409583537766768
1.6643274633676572
1.6867122962738805
1.7081793354895336
1.7287901680306761
1.7486016561574389
1.7676661883992273
1.7860319718646431
1.8037433405380112
1.820841063365616
1.8373626421363425
1.8533425933409486
1.8688127109742803
1.8838023090628218
1.8983384438611326
1.9124461163765669
1.9261484562984186
1.9394668886257831
1.9524212843768372
1.9650300967678522
1.9773104842048395
1.989278421355575
2.0009487994791417
2.0123355170932076
2.0234515619619571
2.0343090852936569
2.0449194689482284
2.0552933863731115
2.0654408579105707
2.0753713010513923
2.0850935761484335
2.0946160280483053
2.1039465240501296
2.1130924885562874
2.122060934740901
2.1308584935269246
2.1394914401317529
2.1479657184137553
2.1562869632277137
2.1644605209754291
2.1724914685184986
2.1803846306031147
2.1881445959314991
2.1957757320010227
26

27
1
1.0398142294946318
1.0805957577255063
1.1217587348363316
1.1627475186746552
1.2030824271594902
1.2423851471586191
1.2803843070413692
1.3169066506601534
1.3518605052434747
1.3852170293199031
1.416992685865891
1.4472345660321135
1.4760089660393991
1.5033929622810109
1.5294684644186967
1.5543181839333302
1.5780230171453253
1.6006604377833564
1.6223035902547704
1.6430208568882878
1.6628757371677898
1.6819269256249563
1.7002285104805361
1.717830240359415
1.7347778240964822
1.7511132408963896
1.766875046492864
1.7820986666288967
1.7968166729760104
1.8110590391137593
1.8248533758087979
1.8382251458503149
1.8511978593116101
1.8637932504510339
1.8760314376317324
1.8879310676915522
1.8995094461746926
1.9107826547738556
1.9217656572448416
1.9324723949573048
1.9429158731437646
1.9531082388090104
1.9630608511668515
1.9727843453822607
1.9822886903152828
1.9915832408887091
2.0006767856344179
2.0095775899129631
2.0182934352471102
2.0268316551619687
2.0351991678815802
2.0434025061938752
2.0514478447621989
2.0593410251316886
2.0670875786523126
2.0746927475168508
2.0821615040912564
2.0894985686963246
2.096708425983203
2.1037953400306284
2.1107633682788682
27

28
1
1.0377641675502474
1.0763701283084555
1.1152625663250424
1.1539187824179218
1.1918911236474794
1.2288298552457053
1.2644872863315484
1.2987085071086497
1.3314151421919385
1.3625872845450155
1.3922467992797096
1.4204434598337148
1.4472442362303455
1.4727254517532478
1.4969672898167055
1.5200501047016974
1.5420520557884592
1.563047680347639
1.58310711327037
1.6022957409271916
1.6206741379797103
1.6382981819813298
1.6552192739200093
1.6714846164693471
1.6871375181851118
1.7022177032257186
1.7167616138946229
1.7308026984960456
1.7443716804437659
1.7574968068148613
1.7702040759788473
1.782517444821929
1.7944590166081471
1.8060492107984158
1.8173069162697295
1.828249629397539
1.8388935784232652
1.8492538354517492
1.8593444173273921
1.869178376533716
1.8787678831561638
1.8881242988464144
1.8972582436308749
1.9061796563174502
1.9148978491738973
1.9234215574778546
1.9317589844728631
1.9399178422058099
1.94790538866878
1.9557284616216237
1.9633935094301247
1.9709066192179847
1.9782735425982843
1.9854997192213066
1.9925902983501196
1.9995501586527427
2.006383926379717
2.0130959920781861
2.0196905259778815
2.026171492170437
2.0325426616910995
28

29
1
1.0358041344347604
1.0723377521141098
1.1090749491146328
1.1455243103171022
1.1812682356073956
1.2159835008177917
1.2494441204693501
1.2815117684660629
1.312119875456804
1.3412562602392921
1.3689472458889547
1.3952445749556555
1.4202153707250034
1.4439348382131281
1.4664811916704272
1.4879322795487149
1.5083634471753005
1.527846271657924
1.5464478939173305
1.5642307482334668
1.5812525482805257
1.5975664321010212
1.613221199782009
1.6282615996797019
1.642728634366474
1.6566598679743152
1.670089723715656
1.6830497651132801
1.6955689576013633
1.7076739091846618
1.7193890901198043
1.730737032357591
1.7417385099267948
1.7524127016630235
1.7627773377686289
1.7728488316838613
1.7826423986906497
1.7921721625817035
1.801451251624308
1.8104918849399994
1.8193054503142851
1.8279025743483612
1.8362931857694225
1.8444865726285016
1.852491434035225
1.8603159270071181
1.8679677089468973
1.8754539762038944
1.8827814991248146
1.8899566539539183
1.8969854519026479
1.9038735656733812
1.9106263536906591
1.917248882265582
1.9237459458946169
1.93012208587239
1.9363816073789228
1.9425285951848239
1.948566928102913
1.9545002923014509
1.9603321935823532
29

30
1
1.0339271397565082
1.0684832519502161
1.1031707607030559
1.1375279797163922
1.1711655382351454
1.2037848358635603
1.2351798061221948
1.265227125364585
1.2938707028521437
1.3211050162046361
1.3469600203893284
1.3714888096990689
1.3947582160730878
1.4168420200393226
1.437816268587665
1.4577561890448265
1.476734259702718
1.4948190906449244
1.512074855497235
1.5285610870028552
1.5443327049419666
1.559440185949923
1.5739298141941489
1.5878439725086895
1.6012214478419027
1.6140977345897676
1.6265053259275024
1.6384739875960836
1.6500310114402781
1.6612014478136783
1.6720083170977376
1.6824728012546661
1.6926144167045183
1.702451169990798
1.7119996977478296
1.7212753924549575
1.7302925153891398
1.7390642980895914
1.7476030335393835
1.7559201581578783
1.7640263255897699
1.7719314731744165
1.7796448818846193
1.7871752304377011
1.7945306442037461
1.8017187394658505
1.8087466635247706
1.8156211310847803
1.8223484573082742
1.8289345878830729
1.8353851264077987
1.8417053593666859
1.84790027893509
1.8539746038304463
1.8599327983999923
1.86577909011586
1.8715174856298513
1.8771517855240312
1.8826855978789609
1.8881223507686697
1.8934653037802713
30

31
1
1.0321269524494818
1.0647929512527048
1.0975277043755143
1.1298977956000875
1.1615403981988757
1.1921798097788034
1.2216282629328681
1.2497760137568885
1.2765762649764432
1.3020292080999052
1.3261677050821614
1.3490456661081525
1.370729251298697
1.3912905598428638
1.4108033105481541
1.4293400216273164
1.4469702707985486
1.4637597075132849
1.4797695732047431
1.4950565543310397
1.5096728457132134
1.5236663403573714
1.5370808895404451
1.5499565962138626
1.5623301180314149
1.5742349652948688
1.5857017851264203
1.5967586271466105
1.6074311885109478
1.617743037790351
1.627715818181001
1.6373694311109701
1.6467222016186587
1.6557910270092002
1.6645915103152591
1.6731380800415512
1.68144409758701
1.6895219536334178
1.6973831546766989
1.7050384007643511
1.7124976553942171
1.7197702084284487
1.7268647327833597
1.7337893355712553
1.7405516042941858
1.7471586486214969
1.7536171382224681
1.7599333370715822
1.7661131345964387
1.7721620739963184
1.7780853780223398
1.7838879724775023
1.7895745076660365
1.7951493779961472
1.8006167399177688
1.8059805283572341
1.8112444717932497
1.8164121061031941
1.8214867872950871
1.8264717032284963
1.8313698844169839
31

32
1
1.0303979964395695
1.0612546370358549
1.0921259099624938
1.1226053000255218
1.1523549642483841
1.1811205162608247
1.2087310150021613
1.2350890127151821
1.260155944433428
1.2839368763340528
1.3064669395024315
1.3278003938356036
1.348002401575999
1.3671431652526114
1.3852939455190758
1.4025244859221302
1.4189014457573408
1.4344875306422911
1.4493410912320677
1.4635160261204174
1.4770618748834468
1.4900240236575792
1.5024439715049727
1.5143596238054176
1.5258055912227502
1.536813481100533
1.5474121736709667
1.5576280790857508
1.5674853736094152
1.5770062147776795
1.586210936205851
1.5951182232327628
1.603745270837988
1.6121079253639843
1.6202208115705026
1.628097446485878
1.6357503414247838
1.643191093431599
1.6504304672933079
1.657478469152539
1.6643444126435694
1.6710369783741605
1.6775642674846736
1.6839338499333067
1.6901528080822932
1.696227776093846
1.7021649755861306
1.7079702479476528
1.7136490836627472
1.7192066489604634
1.7246478100636062
1.7299771552834073
1.735199015177705
1.7403174809662649
1.7453364213754858
1.7502594980658834
1.7550901797790912
1.7598317553265017
1.7644873455286203
1.7690599142027934
1.7735522782867743
32

33
1
1.0287352634510762
1.0578573622563809
1.0869476017336834
1.1156250819169902
1.1435754967211473
1.1705643225541176
1.1964361025719263
1.221104524082339
1.2445383017539651
1.266746629126694
1.2877663437664393
1.3076516488943664
1.3264664291637471
1.3442788101901439
1.3611574903565307
1.3771693914712539
1.3923782492241592
1.4068438503362619
1.4206217007507449
1.4337629716102469
1.4463146169461749
1.4583195912750182
1.4698171195115191
1.4808429883754961
1.4914298398923449
1.501607455258644
1.5114030224223423
1.520841384033925
1.5299452645345051
1.5387354764544479
1.5472311067723457
1.5554496846121149
1.5634073317594392
1.57111889754043
1.5785980795802335
1.5858575318837091
1.5929089615778074
1.5997632155409847
1.6064303580284487
1.6129197402888558
1.6192400630615889
1.6253994327455306
1.6314054119410006
1.6372650649861824
1.642984999037612
1.6485714011805193
1.6540300719983632
1.6593664559810322
1.6645856691072582
1.6696925238981177
1.6746915522044428
1.6795870259610992
1.6843829761147118
1.6890832099083182
1.6936913266860412
1.698210732362939
1.7026446526893511
1.7069961454251676
1.711268111527064
1.7154633054409145
1.719584344581929
33

34
1
1.0271342397057972
1.0545912800455721
1.0819768204486468
1.108934367641202
1.1351718086187832
1.1604731448930512
1.1846971779416853
1.2077676773263597
1.2296597799410289
1.2503861396013263
1.2699848029324106
1.2885095616032094
1.3060227825961153
1.3225903640746464
1.338278359695799
1.353150837705779
1.3672686152256872
1.3806885913437292
1.3934634767026635
1.4056417764946332
1.4172679283036915
1.4283825284252385
1.4390226029374871
1.4492218954137968
1.4590111537552219
1.4684184057004548
1.4774692172294877
1.4861869310910534
1.4945928845898535
1.5027066069369734
1.510545997147372
1.518127483831708
1.5254661683903754
1.5325759531513625
1.5394696559509853
1.5461591125704708
1.55265526833324
1.5589682600510426
1.565107489390146
1.5710816886166252
1.5768989795750543
1.5825669266589211
1.5880925844442644
1.593482540580188
1.5987429544605694
1.6038795921398485
1.6088978579015063
1.6138028228399934
1.6185992507748088
1.6232916217784348
1.6278841535673236
1.6323808209766344
1.6367853737143012
1.641101352568018
1.6453321042193363
1.6494807948020427
1.6535504223269559
1.65754382808206
1.6614637071052323
1.6653126178164717
1.6690929908874665
34

35
1
1.0255908439592207
1.0514475038868287
1.0771991894011332
1.10251267706697
1.1271167969485418
1.1508128420076105
1.1734727499130053
1.1950294156676817
1.2154636249244655
1.2347908949496376
1.2530500407847616
1.27029413220733
1.2865838124475946
1.3019826269367949
1.3165539203451615
1.3303588881315613
1.343455442118999
1.3558976298995267
1.3677354185424415
1.3790147091821208
1.3897774910168357
1.4000620734403344
1.4099033561783791
1.4193331118243553
1.4283802649751796
1.4370711586915845
1.445429803276743
1.453478105110324
1.4612360749944098
1.4687220165076407
1.4759526954582516
1.4829434918326427
1.4897085357591531
1.4962608290165991
1.5026123535600246
1.5087741684417857
1.5147564963940119
1.520568801220495
1.5262198570296865
1.5317178102299438
1.5370702351056733
1.5422841836996197
1.5473662306424172
1.5523225134953165
1.5571587691052711
1.561880366412508
1.5664923360987013
1.5709993974180565
1.5754059825134585
1.5797162584844844
1.5839341474431774
1.5880633447662891
1.5921073357288484
1.5960694106830231
1.5999526789278307
1.6037600813990975
1.6074944022948567
1.6111582797388213
1.6147542155735595
1.6182845843651961
1.6217516416929112
35

36
1
1.0241013748476995
1.0484179890538281
1.0726017164363231
1.0963415330622979
1.1193860475850157
1.1415527046215679
1.1627255487991597
1.1828457291303953
1.2018989807697742
1.2199031493559254
1.2368974272941673
1.2529338907671594
1.2680712824362563
1.2823706912518276
1.2958927039519541
1.3086956343989606
1.3208345090029499
1.3323605637005829
1.3433210752179419
1.3537594023844326
1.3637151527248281
1.3732244178270496
1.3823200407076448
1.3910318918846398
1.3993871399370528
1.4074105083338908
1.4151245142234379
1.4225496873668146
1.4297047689480926
1.4366068909173419
1.4432717370397845
1.4497136870792438
1.4559459456343364
1.4619806571354497
1.4678290084414805
1.4735013203747667
1.4790071294179428
1.4843552606783363
1.4895538931104315
1.4946106178786183
1.4995324906425955
1.5043260784573018
1.5089975018979913
1.513552472948692
1.5179963291282359
1.5223340642714542
1.5265703563334192
1.5307095925409075
1.5347558921769262
1.5387131272505974
1.5425849412752004
1.5463747663514291
1.5500858387302812
1.5537212130101521
1.557283775105327
1.5607762541077381
1.5642012331504165
1.5675611593692245
1.5708583530490383
1.5740950160313116
1.5772732394518552
36

37
1
1.0226624659284984
1.0454954315766365
1.0681726255642667
1.0904042148708941
1.1119575003922229
1.1326650234970363
1.1524219899332495
1.1711770074520087
1.1889201272578052
1.2056710427179851
1.2214689759983968
1.2363647716044068
1.2504151200741602
1.2636785685304279
1.2762129097484223
1.2880735757964046
1.2993127328473502
1.3099788477856871
1.3201165610874044
1.3297667504849757
1.3389667069706757
1.3477503711176111
1.3561485960618331
1.3641894159963748
1.3718983074029121
1.3792984357640687
1.3864108840706431
1.3932548617002778
1.3998478936355785
1.4062059908085554

1.4123438028054311
1.4182747543757541
1.4240111672515663
1.4295643687548572
1.4349447885929107
1.4401620451360666
1.4452250223564396
1.4501419384887673
1.4549204073615141
1.459567493240687
1.4640897599320559
1.4684933148000705
1.472783848283604
1.4769666694192094
1.4810467378212819
1.4850286925144569
1.4889168779661845
1.4927153676257952
1.4964279852399724
1.5000583241826275
1.5036097650092721
1.5070854914215359
1.5104885048060734
1.513821637493334
1.5170875648652269
1.5202888164262653
1.5234277859400616
1.5265067407219119
1.5295278301683473
1.5324930935958645
1.5354044674534018
37

38
1
1.0212710471117934
1.0426731817413204
1.0639012130646845
1.0846855477316877
1.1048111640315701
1.1241247221364004
1.1425317181350874
1.1599874913706418
1.1764858341685553
1.1920478551122169
1.2067124967072811
1.220529163041518
1.2335523628424458
1.2458380318214919
1.2574411436655089
1.2684142555661249
1.2788067028399359
1.288664227924847
1.2980288894985217
1.30693914455446
1.3154300309703566
1.3235334027564352
1.3312781872373038
1.3386906449987721
1.3457946211510454
1.352611781521506
1.359161830648125
1.365462710493321
1.371530780045837
1.3773809767014864
1.3830269606983792
1.3884812440522827
1.3937553054750627
1.3988596927173704
1.4038041136906831
1.4085975176157364
1.4132481673282475
1.4177637037570445
1.4221512034792727
1.4264172301548268
1.4305678805487028
1.434608825765928
1.4385453482487938
1.4423823750197138
1.4461245075945428
1.4497760489397291
1.4533410278015921
1.456823220696529
1.4602261718164151
1.4635532110732556
1.4668074704807281
1.4699918990471825
1.4731092763344076
1.476162224818802
1.4791532211760603
1.4820846065968858
1.4849585962292542
1.4877772878322981
1.4905426697175839
1.4932566280454223
1.4959209535366647
38

39
1
1.0199243114319698
1.0399451697052873
1.0597777239697164
1.0791717225997519
1.0979288719663332
1.1159090430098029
1.1330272191006336
1.1492448051236839
1.1645588117851102
1.1789913730481123
1.1925808759854253
1.2053751012044076
1.2174262649095393
1.2287876353469065
1.2395113512069429
1.2496471075915545
1.2592414416544337
1.2683374173816346
1.2769745660670087
1.2851889832455921
1.2930135152773681
1.3004779917229981
1.307609475479601
1.3144325133405501
1.3209693767455575
1.3272402871221356
1.3332636231854464
1.3390561094150122
1.3446329860427138
1.3500081615231248
1.3551943487860536
1.3602031867062245
1.3650453482412992
1.3697306366360025
1.3742680709985333
1.3786659624457374
1.3829319818982597
1.3870732204934109
1.3910962434761729
1.3950071383297431
1.3988115578171727
1.402514758525149
1.4061216354293813
1.4096367529377902
1.4130643728120709
1.4164084793193337
1.4196728019228244
1.4228608357833181
1.4259758603101336
1.4290209559721936
1.4319990195546313
1.4349127780246667
1.4377648011514363
1.4405575130077937
1.4432932024675147
1.4459740327985415
1.4486020504416646
1.4511791930541906
1.4537072968894558
1.4561881035753994
1.4586232663486716
39

40
1
1.018619686301403
1.0373058412643661
1.0557932455897652
1.0738501409986065
1.0912940728045135
1.1079972783297194
1.1238834864097207
1.1389195563519903
1.1531052411640803
1.1664633482929476
1.1790314633357937
1.1908555828842544
1.2019855364106227
1.212471880274911
1.2223639100582395
1.2317084763899047
1.2405493535321501
1.2489269739072906
1.256878395493116
1.2644374104030902
1.2716347331985483
1.2784982287912414
1.2850531544373789
1.2913224001828709
1.2973267186389648
1.3030849392017885
1.3086141645233442
1.3139299487104688
1.319046457723513
1.3239766130045121
1.3287322196435507
1.3333240804964197
1.3377620976651425
1.3420553626902121
1.3462122367079172
1.3502404217161097
1.3541470239782112
1.3579386104847704
1.3616212592881312
1.3652006044305975
1.3686818761004564
1.3720699365733946
1.3753693124287301
1.3785842234697936
1.3817186087250719
1.384776149860508
1.387760292292967
1.3906742642596102
1.3935210940671259
1.3963036257179193
1.3990245330868938
1.4016863328020222
1.4042913959639818
1.4068419588245096
1.4093401325294534
1.4117879120204808
1.4141871841788949
1.4165397352857829
1.4188472578645868
1.4211113569650222
1.4233335559409988
40

41
1
1.0173548085452884
1.0347501021670247
1.0519396153629452
1.0687092809581951
1.0848916494067009
1.1003705380874058
1.1150777349928269
1.128984992238222
1.1420943708749407
1.1544290337515664
1.1660255452806865
1.1769279773136285
1.187183692764882
1.1968405017051638
1.2059448550864627
1.2145407806433759
1.2226693269901645
1.2303683423670559
1.2376724649163668
1.2446132400051308
1.2512193082119787
1.2575166273321201
1.263528705266058
1.2692768297210049
1.2747802866231523
1.2800565629975487
1.2851215325129368
1.2899896233892154
1.2946739692497891
1.2991865439880002
1.3035382819513099
1.3077391848246172
1.311798416577733
1.3157243877720388
1.3195248304236449
1.3232068645110238
1.326777057104122
1.3302414749849685
1.3336057315300702
1.336875028533784
1.340054193569878
1.3431477134154843
1.3461597639970657
1.3490942372611701
1.3519547653229775
1.3547447422020336
1.3574673434165714
1.3601255436746091
1.3627221328711212
1.365259730575348
1.3677407991703243
1.3701676557875313
1.372542483162819
1.3748673395251134
1.3771441676166303
1.3793748029321022
1.3815609812546943
1.3837043455576599
1.385806452333231
1.3878687774035161
1.3898927212623611
41

42
1
1.0161275026402425
1.032273269657652
1.0482093407983273
1.0637385807269961
1.0787077622042724
1.0930115494065114
1.1065891535933259
1.1194167027877528
1.1314981693991448
1.1428567838033279
1.1535278928986812
1.1635535205316667
1.1729784957932852
1.1818478566984869
1.1902052136245924
1.1980917962213034
1.2055459661700865
1.2126030350820503
1.2192952739724336
1.2256520366948322
1.2316999457565665
1.2374631071578166
1.2429633333278907
1.2482203615396752
1.2532520606327346
1.2580746223814339
1.2627027360488681
1.2671497460117453
1.2714277931246982
1.2755479409152162
1.2795202878953851
1.2833540673313308
1.2870577357826609
1.2906390516489195
1.2941051448614138
1.2974625787511898
1.3007174050161838
1.303875212607658
1.3069411712606056
1.3099200703060987
1.3128163533257526
1.3156341491393846
1.3183772995559782
1.3210493842645261
1.3236537431944551
1.3261934966344111
1.3286715633625179
1.331090677010111
1.3334534008538712
1.3357621412077314
1.3380191595653201
1.3402265836258576
1.3423864173207425
1.3445005499444274
1.3465707644812777
1.3485987452096282
1.3505860846551221
1.3525342899573969
1.3544447887071149
1.3563189343041353
1.3581580108821771
42

43
1
1.0149357616791341
1.0298710301605811
1.0445955296750973
1.0589283375333269
1.0727297129859057
1.0859044823368582
1.0983986901103799
1.1101923638127551
1.1212910243542928
1.1317177088103498
1.141506371037982
1.1506968790341516
1.1593314717870777
1.167452396942946
1.1751004330674946
1.1823140391549392
1.1891289297275982
1.1955779272327782
1.2016909873542421
1.2074953261721881
1.213015602146015
1.2182741226579383
1.2232910562525792
1.2280846392969911
1.2326713707438497
1.237066191855255
1.2412826497288738
1.24533304466829
1.2492285621302337
1.252979390346092
1.2565948248752545
1.2600833613828719
1.2634527778961671
1.2667102077145942
1.2698622040508225
1.2729147973745436
1.2758735463272397
1.278743582977619
1.2815296530966371
1.2842361520488843
1.2868671568236547
1.289426454663914
1.2919175686941102
1.2943437808974978
1.2967081527497846
1.2990135437775985
1.3012626282769533
1.3034579103978465
1.3056017377758935
1.3076963138699229
1.3097437091453108
1.3117458712261973
1.3137046341251564
1.3156217266462491
1.3174987800462739
1.319337335029374
1.3211388481416315
1.3229046976248737
1.3246361887823654
1.3263345589033022
1.328000981787989
43

44
1
1.0137777306652149
1.0275394022018569
1.0410918289752957
1.0542696191423886
1.0669458260625166
1.079034798066977
1.0904888647869135
1.1012915135004764
1.1114494812847784
1.1209853753548431
1.1299315995472101
1.138325771808955
1.1462074943710474
1.1536162126346294
1.1605898860883361
1.16716423260477
1.1733723600377468
1.1792446488411474
1.1848087901451472
1.1900899144759887
1.1951107684104882
1.1998919118177753
1.2044519187490481
1.2088075719423235
1.2129740454030844
1.2169650723854604
1.2207930978775379
1.2244694157613867
1.2280042914245548
1.2314070709124316
1.2346862778403684
1.2378496993028185
1.240904461970703
1.2438570994873652
1.246713612176606
1.2494795199747295
1.2521599093991214
1.2547594752723148
1.2572825578346274
1.2597331758010835
1.2621150558492726
1.2644316589638538
1.2666862040097655
1.2688816888593324
1.2710209093575064
1.2731064763738436
1.2751408311587893
1.2771262591948962
1.2790649027101302
1.2809587720000697
1.282809755688028
1.2846196300367347
1.2863900674117155
1.2881226439848088
1.2898188467560014
1.2914800799628008
1.2931076709385276
1.2947028754740515
1.2962668827314301
1.2978008197526427
1.2993057556019234
44

45
1
1.0126516918040853
1.0252747038160075
1.0376923712832498
1.0497541863366466
1.0613453442469623
1.0723891162233952
1.0828436070756668
1.0926953575080467
1.1019520160257572
1.1106355452420476
1.1187766585637839
1.1264106417823034
1.1335744221603774
1.140304636538733
1.1466364414055947
1.1526028447162748
1.1582343885817843
1.1635590581729536
1.168602329750303
1.1733872989753817
1.1779348508894958
1.182263846957144
1.1863913140335491
1.1903326263719782
1.1941016758413356
1.1977110280960808
1.2011720640281196
1.2044951067742615
1.2076895350818597
1.2107638841011088
1.2137259347752174
1.2165827930042006
1.2193409597063056
1.2220063928197389
1.224584562192897
1.2270804982139187
1.2294988349358926
1.2318438483657026
1.2341194905037993
1.2363294196496846
1.238477027423416
1.2405654628966098
1.2425976541765362
1.2445763277433399
1.2465040258024731
1.2483831218813572
1.2502158348706411
1.2520042416854373
1.253750288700302
1.2554558020928879
1.2571224972148387
1.2587519870942798
1.2603457901618509
1.2619053372814102
1.2634319781571595
1.2649269871806395
1.2663915687738772
1.2678268622786393
1.2692339464362024
1.2706138434971757
1.2719675229966523
45

46
1
1.0115560515155193
1.023073523807591
1.0343917275926662
1.0453744247567265
1.0559183375117682
1.0659550984832078
1.0754481127190245
1.0843865983838303
1.0927788356688029
1.1006459474977415
1.1080168312690393
1.1149243692509425
1.1214027829431403
1.1274858991153258
1.1332060901362182
1.1385936865526007
1.143676705860843
1.1484807840686664
1.1530292311037038
1.1573431569263144
1.1614416336179374
1.1653418714279447
1.1690593953183108
1.1726082141831626
1.176000978559689
1.179249124943907
1.1823630062340158
1.185352008654436
1.1882246559723646
1.1909887020427445
1.1936512127970775
1.1962186387847429
1.1986968793199726
1.2010913392069775
1.2034069789246782
1.2056483590598595
1.207819679688489
1.2099248153221052
1.2119673459608498
1.2139505847272438
1.2158776024949767
1.2177512498743042
1.219574176869566
1.221348850484087
1.2230775705127459
1.224762483732045
1.2264055966711376
1.2280087871243222
1.2295738145456301
1.2311023294488823
1.232595881921539
1.2340559293476838
1.2354838434240627
1.2368809165432662
1.2382483676094693
1.2395873473446337
1.240898943136473
1.2421841834737137
1.2434440420091184
1.2446794412862934
1.245891256162398
46

47
1
1.0104893289310211
1.0209326963376026
1.0311848656323368
1.0411232847927649
1.0506556225361905
1.0597213461812063
1.0682887181498164
1.0763492858120149
1.0839117039864958
1.0909960785559794
1.0976293786279643
1.1038420211292961
1.1096654975219924
1.1151308271445861
1.1202676194706169
1.1251035611426372
1.1296641861814996
1.1339728268592799
1.1380506741255896
1.1419168998925697
1.1455888101377185
1.1490820092436855
1.1524105636832751
1.1555871582066877
1.1586232409344466
1.1615291557984648
1.1643142620166758
1.1669870410123144
1.1695551915837041
1.1720257143173023
1.1744049862963544
1.1766988271418093
1.1789125573644801
1.1810510499287219
1.1831187758410417
1.1851198444897943
1.1870580393788179
1.1889368498208208
1.1907594990865402
1.1925289694433738
1.1942480244620184
1.1959192289212435
1.1975449665985887
1.1991274561978731
1.2006687656323773
1.2021708248547025
1.2036354374001887
1.2050642907898454
1.2064589659205851
1.2078209455548243
1.2091516220078184
1.2104523041192385
1.211724223585154
1.2129685407175803
1.2141863496909198
1.2153786833277633
1.2165465174705299
1.2176907749801884
1.2188123293987034
1.2199120083078123
1.2209905964131929
47

48
1
1.0094501456791718
1.0188492783874019
1.0280671129610759
1.0369942284235545
1.0455486916390986
1.0536773099649424
1.0613527897872896
1.0685686847458584
1.0753337878491487
1.0816670266202633
1.0875933415339685
1.0931406308606424
1.0983376374876455
1.1032125795454981
1.107792326785032
1.1121019561836241
1.116164559279416
1.1200012092650959
1.12363102426529
1.1270712843098045
1.1303375744633086
1.1334439368262781
1.1364030209803684
1.1392262269393583
1.1419238375411638
1.1445051390130199
1.146978529529959
1.1493516162158846
1.1516313013732966
1.1538238588816694
1.1559350017472088
1.1579699417642271
1.1599334421900982
1.1618298642600207
1.1636632082859475
1.1654371500026253
1.1671550727465441
1.1688200959825812
1.1704351006290228
1.1720027515745515
1.1735255177304011
1.1750056899167034
1.1764453968434845
1.1778466194132331
1.1792112035428348
1.180540871677406
1.1818372331466775
1.1831017934956207
1.1843359629045658
1.1855410637998258
1.1867183377434714
1.1878689516801666
1.1889940036096436
1.1900945277452677
1.1911714992120723
1.1922258383314495
1.1932584145342982
1.1942700499397065
1.1952615226320882
1.1962335696660782
1.1971868898252884
48

49
1
1.0084372167907507
1.0168205297210784
1.0250341241977734
1.0329811820717185
1.0405896498288534
1.0478132098569597
1.0546286261859075
1.0610311589614447
1.0670295217206904
1.0726413168260294
1.0778893665172269
1.082799004674851
1.0873962121268788
1.0917064151095781
1.095753768432181
1.0995607741605358
1.1031481220678749
1.1065346700929679
1.1097375084785439
1.1127720700804988
1.1156522626337775
1.1183906078532444
1.1209983783102173
1.1234857269790079
1.1258618068700084
1.1281348797345969
1.1303124137708811
1.1324011707996424
1.1344072836640959
1.1363363247320304
1.1381933664075246
1.13998303453216
1.1417095554981536
1.1433767978240743
1.1449883088675756
1.1465473472744954
1.148056911692992
1.1495197662166081
1.1509384629618653
1.1523153621342166
1.153652649890599
1.1549523542669016
1.1562163594039043
1.1574464182749951
1.1586441640928002
1.1598111205491151
1.1609487110228982
1.162058266874052
1.1631410349259848
1.1641981842271729
1.1652308121708699
1.1662399500425054
1.1672265680559439
1.1681915799325324
1.1691358470705193
1.1700601823469092
1.1709653535889994
1.1718520867486204
1.1727210688084104
1.173572950446204
1.1744083484807755
49

50
1
1.0074493425805233
1.0148438950238221
1.0220818518480079
1.0290784946846316
1.0357711588953735
1.042119964335946
1.0481053713108306
1.0537240679480324
1.0589844877765064
1.063902774362413
1.0684995517816027
1.0727975505594907
1.0768199804309229
1.0805894877136457
1.0841275383731066
1.0874540946460625
1.0905874848788484
1.0935443947071384
1.096339930226192
1.0989877204031411
1.1015000376759767
1.1038879236565469
1.1061613121543481
1.1083291451823982
1.1103994797952497
1.1123795849637772
1.1142760285008138
1.1160947545103788
1.1178411520701372
1.1195201159563097
1.1211361002374267
1.1226931655330346
1.1241950206780542
1.1256450594665979
1.1270463930790509
1.1284018787279173
1.1297141449939856
1.130985614265984
1.1322185226445614
1.1334149376250371
1.1345767738325829
1.1357058070478652
1.1368036867301961
1.1378719472182852
1.1389120177654211
1.1399252315456876
1.1409128337503955
1.1418759888787928
1.1428157873140499
1.1437332512642091
1.1446293401379652
1.1455049554166492
1.1463609450763921
1.1471981076080118
1.1480171956765897
1.1488189194578056
1.1496039496838495
1.1503729204280013
1.1511264316537089
1.1518650515511275
1.1525893186815737
50

51
1
1.006485401383366
1.012916987941104
1.0192065202681797
1.0252809003683812
1.0310863876306195
1.0365891272579222
1.0417729374758338
1.0466356753690083
1.0511853095628148
1.0554364031490329
1.0594073108355735
1.0631181268753678
1.0665892847988423
1.069840665269389
1.0728910725719705
1.0757579643688029
1.0784573474527699
1.0810037772016783
1.0834104180978006
1.0856891371188149
1.087850611945977
1.0899044428285121
1.091859261511267
1.0937228335919131
1.0955021525469353
1.097203524819059
1.0988326460431919
1.100394668871669
1.1018942630539148
1.1033356685032558
1.104722742091683
1.1060589988818081
1.1073476484530764
1.1085916269180831
1.1097936251616547
1.1109561137741684
1.1120813650936321
1.1131714727192379
1.1142283688127661
1.1152538394633067
1.1162495383547819
1.1172169989444443
1.1181576453332691
1.119072801985534
1.1199637024344467
1.1208314970930047
1.1216772602739917
1.1225019965097975
1.1233066462513366
1.1240920910154568
1.1248591580416458
1.1256086245114463
1.1263412213775248
1.1270576368437377
1.1277585195326805
1.1284444813729253
1.1291161002344732
1.1297739223376762
1.1304184644580699
1.1310502159470461
1.1316696405861246
51

52
1
1.0055443430398148
1.0110375767829889
1.0164046023745938
1.0215834850002026
1.0265289673979763
1.031212831612901
1.0356219366972044
1.0397550675915608
1.043619557429831
1.0472282780265967
1.0505972513972841
1.0537439080147668
1.0566859035508378
1.0594403692411851
1.0620234757026992
1.0644502113177923
1.0667343006667684
1.0688882099888326
1.0709232035023599
1.0728494267487161
1.0746760017573926
1.0764111246824473
1.0780621604269114
1.0796357312683738
1.0811377980728816
1.082573733648641
1.0839483883592176
1.0852661484309849
1.0865309875457394
1.0877465123682404
1.0889160026596159
1.0900424465962784
1.0911285718661343
1.0921768730590722
1.0931896358128259
1.0941689581216154
1.0951167691651849
1.0960348459707747
1.096924828180343
1.0977882311598866
1.0986264576566342
1.0994408081828109
1.1002324902811953
1.1010026268073241
1.1017522633456287
1.1024823748615649
1.1031938716786927
1.1038876048583017
1.1045643710493835
1.1052249168682802
1.1058699428599763
1.1065001070866776
1.1071160283837527
1.1077182893183595
1.1083074388818808
1.108883994943668
1.1094484464904151
1.1100012556727128
1.110542859677915
1.1110736724463048
1.1115940862457003
52

53
1
1.0046251830407855
1.0092035716910994
1.0136727987606535
1.0179816563270112
1.0220929523832929
1.0259837392580908
1.0296436193989615
1.0330720810034504
1.0362756642315565
1.0392654487223663
1.0420550675988145
1.0446592648890609
1.0470929197986636
1.0493704320399164
1.0515053672367569
1.0535102797158218
1.0553966505991923
1.0571748971690651
1.058854423562698
1.0604436931331889
1.0619503099843566
1.06338110203625
1.064742201171675
1.0660391180695088
1.0672768106212474
1.0684597456139913
1.0695919538233531
1.0706770789119691
1.071718420651552
1.072718973029352
1.073681457796291
1.0746083539843989
1.0755019238786494
1.0763642358805652
1.0771971846528572
1.0780025088884146
1.0787818070045971
1.0795365510254928
1.0802680988807909
1.0809777053199334
1.0816665316140088
1.0823356541950631
1.0829860723627323
1.0836187151710077
1.0842344475931802
1.0848340760502539
1.0854183533771158
1.085987983291258
1.0865436244206161
1.0870858939400334
1.0876153708596779
1.0881325990034634
1.0886380897108772
1.0891323242916346
1.0896157562590951
1.0900888133653239
1.0905518994580565
1.0910053961775026
1.0914496645088945
1.091885046204929
1.0923118650906836
53

54
1
1.0037269972535665
1.0074130130937273
1.0110080189322512
1.0144711171267633
1.0177727839546595
1.0208949958909073
1.0238298195570978
1.0265772370196526
1.029142850002934
1.0315358541041386
1.0337674438028477
1.0358496583565018
1.0377946045808384
1.0396139699975733
1.0413187444148724
1.0429190831639477
1.044424262034348
1.045842688590549
1.0471819459277161
1.0484488531954628
1.0496495329742723
1.050789479468933
1.0518736240316944
1.0529063961624539
1.0538917791556701
1.0548333601837299
1.0557343749665382
1.0565977473720103
1.0574261243843235
1.0582219069065999
1.0589872768581274
1.0597242209996662
1.0604345518839999
1.0611199262889268
1.0617818614499148
1.0624217493717614
1.0630408694637667
1.0636403997116
1.0642214265712211
1.0647849537457792
1.0653319099850806
1.065863156028682
1.0663794907976141
1.0668816569258637
1.0673703457107862
1.0678462015512724
1.0683098259336017
1.0687617810172172
1.0692025928660327
1.0696327543651436
1.0700527278578509
1.0704629475336331
1.0708638215939588
1.0712557342196016
1.0716390473603381
1.0720141023654257
1.072381221471147
1.0727407091598444
1.073092853403228
1.0734379268013245
1.0737761876271712
54

55
1
1.0028489171616732
1.0056640612982635
1.0084073644110836
1.0110478410676849
1.0135632586374628
1.0159401906279153
1.0181729054986535
1.0202616838365817
1.022211054508098
1.0240282454482932
1.0257219685864314
1.0273015439725195
1.0287763124721472
1.0301552699595773
1.031446859968026
1.0326588736522724
1.0337984189340998
1.0348719319583624
1.0358852126985612
1.0368434728644329
1.0377513886453344
1.0386131537682757
1.0394325302783538
1.0402128956825443
1.0409572858660963
1.041668433654289
1.0423488031594164
1.0430006201956521
1.0436258991101994
1.0442264663983354
1.0448039814622598
1.0453599548513279
1.0458957642918927
1.046412668783292
1.0469118210050972
1.0473942782511116
1.0478610120785099
1.0483129168361724
1.0487508172147237
1.0491754749419013
1.049587594730403
1.0499878295710681
1.0503767854519031
1.0507550255727649
1.0511230741163353
1.0514814196280711
1.0518305180509799
1.0521707954551793
1.052502650497102
1.0528264566388241
1.0531425641541883
1.0534513019451179
1.0537529791886528
1.0540478868327787
1.0543362989569729
1.0546184740115092
1.0548946559479435
1.0551650752517792
1.0554299498870563
1.0556894861615345
1.0559438795201632
55

56
1
1.0019901255600501
1.0039549870901983
1.0058681134892054
1.00770805094976
1.0094594992784669
1.0111133196426851
1.0126657356795539
1.0141171441222048
1.0154708767075298
1.016732117625802
1.0179070576496152
1.0190022866730795
1.0200243881304125
1.0209796878106296
1.021874112757208
1.0227131244614951
1.0235016997573969
1.0242443407328259
1.0249451010685222
1.0256076206187195
1.0262351630956954
1.0268306537632883
1.0273967153787182
1.0279357014723527
1.0284497265826738
1.028940693380338
1.029410316796292
1.029860145364411
1.0302915800318448
1.0307058907012443
1.0311042307618408
1.0314876498493539
1.0318571050531826
1.0322134707664103
1.0325575473516075
1.0328900687743026
1.0332117093366959
1.0335230896269745
1.0338247817843111
1.0341173141663282
1.0344011754941593
1.0346768185401967
1.0349446634149171
1.0352051005016614
1.0354584930817941
1.0357051796870946
1.0359454762114375
1.0361796778096801
1.0364080606081194
1.0366308832478013
1.0368483882793005
1.037060803425303
1.0372683427253158
1.0374712075751094
1.0376695876719955
1.0378636618757355
1.0380535989937343
1.0382395584981832
1.0384216911819473
1.0386001397592268
1.0387750394163628
56

57
1
1.0011498526546943
1.0022841632250479
1.0033877074467199
1.0044481990548044
1.0054569290296769
1.006408753389201
1.0073016188566823
1.0081358679408905
1.0089135203222304
1.0096376472607649
1.0103118845782308
1.0109400841941689
1.011526082457278
1.012073557484868
1.0125859497576122
1.0130664252569663
1.0135178658069579
1.013942875875343
1.0143437986158819
1.0147227364739229
1.015081573430761
1.0154219971344733
1.015745519928321
1.0160534982727594
1.0163471503567758
1.0166275718731916
1.0168957500340532
1.0171525759550319
1.017398855560611
1.0176353191668392
1.0178626298932227
1.0180813910447406
1.018292152591959
1.0184954168635179
1.018691643551938
1.0188812541212111
1.0190646356933455
1.0192421444809068
1.0194141088236985
1.0195808318799384
1.0197425940155056
1.0198996549289865
1.0200522555451783
1.020200619705353
1.0203449556788331
1.0204854575171909
1.0206223062696129
1.020755671075561
1.0208857101488078
1.0210125716651406
1.0211363945644818
1.0212573092768555
1.0213754383804661
1.0214908971991596
1.0216037943456739
1.0217142322163257
1.0218223074421233
1.0219281113007241
1.0220317300931483
1.02213324548873
1.0222327348413933
57

58
1
1.0003273725222672
1.000650056714163
1.0009637380688436
1.0012649493671311
1.0015512478312423
1.0018212070000163
1.0020742781473846
1.0023105903055365
1.002530744783438
1.0027356370436311
1.0029263185351849
1.0031038981933476
1.0032694772304129
1.0034241092096507
1.0035687780292928
1.0037043879110363
1.0038317610339587
1.0039516397690642
1.0040646914750659
1.0041715145380798
1.0042726448349313
1.0043685621311875
1.0044596961402852
1.0045464321063864
1.0046291158574989
1.0047080583251966
1.0047835395553046
1.0048558122482738
1.0049251048739902
1.0049916244067845
1.0050555587246652
1.0051170787135462
1.0051763401133991
1.0052334851392117
1.0052886439057778
1.0053419356816933
1.0053934699946914
1.0054433476075089
1.0054916613809231
1.0055384970383541
1.0055839338444927
1.0056280452087079
1.0056708992225776
1.0057125591395981
1.0057530838040796
1.0057925280353044
1.0058309429722232
1.0058683763832896
1.0059048729454363
1.0059404744956943
1.0059752202585124
1.0060091470514592
1.0060422894716574
1.0060746800650184
1.0061063494800948
1.0061373266081635
1.0061676387109457
1.0061973115372267
1.0062263694294868
1.0062548354215215
1.0062827313279452
58

0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
1.1000000000000001
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2
2.1
2.2000000000000002
2.2999999999999998
2.4
2.5
2.6
2.7
2.8
2.9
3
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4
4.0999999999999996
4.2
4.3
4.4000000000000004
4.5
4.5999999999999996
4.7
4.8
4.9000000000000004
5
5.0999999999999996
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
6
6.1

9/11/2013

10/30/2013

0
0
0
211
25
25
100
100
25
25

25
25

25
25

0.14894186714057803
0.81798763542966491
0.25249557720918481
0.58987911307921359
3.239611736850295

0.14894186714057803
0.50864341996156726
0.25249557720918481
0.58987911307921359
2.0144646713560923

23.813113368978001
183.06590693171381
0.20226449122363688
117.73254526741752
905.0817858548595

11
16
1
11
16

2.7393136541333787
3.6400696193855371
0.34760044138413848
7.8806391707256838
10.471993662870069

0.54096834392178628
13.882172793482731
0.18390125003894109
2.94162407165387
75.487104032969768

16.095897708649439
144.91783768523806
0.43232123555859853
37.231337220463082
335.20869614001487

25

0.06
0.29639788810883572
1
0.06
0.29639788810883572

36.497894063420418
36.201765105502204
0.28798937317506229
126.73347513150829
125.70521164159749

6.5
65
1
6.5
65

150
340
1
150
340

4Date:
1040000
-0.74360000000000004

1250000
-0.70379999999999998

2800000
-0.8

3360000
-9.3039999999999998E-2

4000000
-1.1307

490000
-0.57189999999999996

0.252

0.20200000000000001

1

0.34799999999999998

0.184

0.432

1

0.28799999999999998

n
BDL=1/2DL
Std Dev.
Mean
Stream Class
C.V.
Mult Factor =
Max. Pred Cw
Max. Value
Data
Cyanide
PQL
RECOMMENDED ACTION
PARAMETER
30Q2 (cfs)
Max Pred Cw
n =
Interpolate to find Mult. Factor
cv =
value 1 address =
value 1 =
value 2 address =
value 2 =
Interpolated MF value =
PRELIM. RESULTS
which truncates to
Pick upper & lower Mult. Factors and interpolate:
Round to 2 dec. places to get MF:
Date
Results
REASONABLE POTENTIAL RESULTS
Allowable Cw
No limit (Action Level parameter)
No limit
MaxPredCw << Acute
MaxPredCw < Acute
MaxPredCw > Chronic
MaxPredCw < Chronic
Monitoring not necessary in permit
MaxPredCw << Chronic
Hit(s)
# Det.
Monitor 1/month
Revise daily max. limit
C
Monitor 1/week
Continue to monitor at 2/month
Monitor 2/month
No limit - assuming no tox (Action Level parameter)
Units
ug/L
Facility Name
Acute:
Chronic:
MaxPredCw >> Chronic
MaxPredCw > Acute
MaxPredCw >> Acute
N/A
REMOVE?
MONITOR?
DAILY MAX LIMIT?

MO AVG LIMIT?
NO DATA
Daily max limit
Mo. avg. limit (keep wk. avg. if existing)
Sample recommendations:
LTMP
Y
N
Monitoring Frequencies
2B .0500
Parameter
Location
Class I
Class II
Class III
Class IV
Frequency
Effluent Limited
pH
E
2/Month
Daily
3/Week
Temp, C
BOD5
TSS
NH3-N
Fecal Col.
TN
TP
Water Quality Limited
D.O.
TRC
Conductivity
I, E
U, D
1/Week
1/Month
See notes below.
2/Week
3/Week*
Notes:
TN, TP Monitoring
All facilities >= 0.05 MGD will monitor TN and TP
Those < 0.05 MGD will monitor if discharging to NSW
For French Broad, Broad, Savannah, New Watauga, Little Tennessee, and Hiwassee:
-
>= 0.05 MGD
- monitor semi-annually
>= 1.0 MGD
- monitor quarterly
For all other river basins:
- monitor monthly
* 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.</t
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.</t><
7Q10s (cfs)
7Q10w (cfs)
QA (cfs)
Receiving Stream
Type
Chronic
Modifier
Acute
NPDES Permit
Outfall
Flow, Qw (MGD)
Name
Msg02
Msg03
Msg07
Msg04
Msg08
Msg05
Msg09
Msg06
Msg01
Msg10
Msg00
Fac_Name
IWC_30Q2
=rpa!$L$8
IWC_7Q10s
=rpa!$L$6
IWC_7Q10w
=rpa!$L$7
IWC_QA
=rpa!$L$9
NPDES
Stream_Class
WWTP_Grade
No chronic standard or criterion
No acute standard or 1/2 FAV
< No Data Entered >
Workbook Names:
Table 1. Project Information
Table 2. Parameters of Concern
=input!$B$10
=input!$B$11
=input!$B$12
=input!$B$13
=input!$B$14
=input!$B$5
=input!$B$6
=input!$B$7
=input!$B$8
=input!$B$9
=input!$E$5:$K$5
=input!$E$6:$K$6
=input!$E$7:$K$7
=input!$E$8:$K$8
=input!$E$9:$K$9
=input!$E$10:$K$10
=input!$E$11:$K$11
=input!$E$12:$K$12
=input!$E$13:$K$13
=input!$E$14:$K$14
=input!$E$15:$K$15
=input!$E$16:$K$16
=input!$E$17:$K$17
Find row in M.F. Table -
Find column in M.F. Table -
Data Source(s)
Par02
Par03
Par04
Par05
Par06
Par07
Par08
Par09
Par10
Par11
Par12
Par13
Par14
Par15
Par16
Par17
Par18
Par19
=input!$E$18:$K$18
=input!$E$19:$K$19
=input!$E$20:$K$20
=input!$E$21:$K$21
=input!$E$22:$K$22
1Q10s (cfs)
Jan. 09
<
Feb. 09
PQL = 10
No PQL or a lower PQL of 9
Per Memo Dated 7-15-2010

Arsenic
FW
HH
Beryllium
NC
Cadmium
Fluoride
Lead
Mercury
ng/L
Molybdenum
Nickel
A
Selenium
Par20
Par21
Par22
Qw (MGD) =
1Q10S (cfs) =
7Q10S (cfs) =
7Q10W (cfs) =
30Q2 (cfs) =
Avg. Stream Flow, QA (cfs) =
Receiving Stream:
Stream Class:
TR
WS
WWTP/WTP Class:
=input!$B$16
_1Q10__cfs
_7Q10s__cfs
_7Q10w__cfs
_30Q2__cfs
Qw__MGD
QA__cfs
=input!$B$15
HQWF
Par_01
Par_02
Par_03
Par_04
Par_05
Par_06
Par_07
Par_08
Par_09
Par_10
Par_11
Par_12
Par_13
Par_14
Par_15
Par_16
Par_17
Par_18
Par_19
Par_20
Par_21
Par_22
=input!$E$23:$K$23
=input!$E$24:$K$24
=input!$E$25:$K$25
=input!$E$26:$K$26
=input!$E$5:$E$26
=input!$G$5:$G$26
=input!$F$5:$F$26
=input!$H$5:$H$26
=input!$I$5:$I$26
=input!$J$5:$J$26
=input!$K$5:$K$26
=input!$N$6
=rpa!$L$5
IWC_1Q10S
Print_Area
Print_Titles
=rpa!$C1:$P$99
=rpa!$1:$2
RPA Tab only:
INPUT Tab only:
=input!$A$1:$K$26
DATA Tab only:
=data!$A$2:$GP$204
Receiving_Stream
No Data (new Permit, New Waste Stream) - apply Monthly Monitoring, Pollutant of concern

Follow directions for data entry. In some cases a 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.
RPALIST
_Data01
_Data02
_Data03
_Data04
_Data05
_Data06
_Data07
_Data08
_Data09
_Data10
_Data11
_Data12
_Data13
_Data14
_Data15
_Data16
_Data17
_Data18
_Data19
_Data20
_Data21
_Data22
=data1$D5:$D$204
=data1$M5:$M$204
=data1$V5:$V$204
=data1$AE5:$AE$204
=data1$AN5:$AN$204
=data1$AW5:$AW$204
=data1$BF5:$BF$204
=data1$BO5:$BO$204
=data1$BX5:$BX$204
=data1$CG5:$CG$204
=data1$CP5:$CP$204
=data1$CY5:$CY$204
=data1$DH5:$DH$204
=data1$DQ5:$DQ$204
=data1$DZ5:$DZ$204
=data1$EI5:$EI$204
=data1$ER5:$ER$204
=data1$FA5:$FA$204
=data1$FJ5:$FJ$204
=data1$FS5:$FS$204
=data1$GB5:$GB$204
=data1$GK5:$GK$204
Û
REQUIRED DATA ENTRY
USE MENU BUTTON TO SELECT POSSIBLE "RECOMMENDED ACTION"
=rpa1$y$64:$y$77
UNITS
TYPE (1)
Applied Standard
PAR #
NO WQS
HH/WS
For
all dischargers
to all waters of the state:
For dischargers to Water Supply (WS) streams that
chlorinate
the effluent:
The following is a list of
Chlorinated
Phenolic Compounds
detected using US EPA Method 625:
at
1.0 ug/L.
Concentrations of all
chlorinated
phenolic compounds, detected above the PQL,
using
US EPA Method 625 data
, should be summed
*
and compared to the
1.0 ug/L
water supply water
quality standard for “
chlorinated
phenolic compounds”.
(EPA Parameter Code: 34034)
Additional
chlorinated
phenolic compounds

MAY

be reported.
<
If reported above the PQL, the
additional
chlorinated
compounds
should
be added to the five chlorinated compounds listed above
to calculate the total chlorinated phenolics in the sample. NOTE: these additional compounds are NOT
required to be reported by 40 CFR Part 136 regulations for US EPA Method 625.
summed
with the chlorinated data for comparison to the Water Supply standard for chlorinated phenolics:
Narrative a
esthetic
“
Total
Phenolic Compounds”

water quality standard
(300 ug/L). Data should be
supplied using
US EPA Method 420.1 (colorimetric) or US EPA Method 420.4 (automated colorimetric),
and will be labeled “Phenols” or “Total Recoverable Phenolics”.
(EPA Parameter Code: 32730)
“
Chlorinated
Phenolic Compounds”
in
Water Supply
classified waters is an a
esthetic
standard
*
The following US EPA Method 625 reported
non-chlorinated
phenolic compounds
SHOULD NOT be
4-chloro-2-methylphenol 6-chloro-3-methylphenol</t></si>
3-chlorophenol 4-chlorophenol 2,3-dichlorophenol </t></si>
2,3,6-trichlorophenol 2,4,5-trichlorophenol 2,3,4,6-tetrachlorophenol</t></si>
2,5-dichlorophenol 2,6-dichlorophenol 3,4-dichlorophenol </t></si>
p-cresol (4-methylphenol)     o-cresol (2-methylphenol)           </t></si>
2-Nitrophenol 4-Nitrophenol Phenol </t></si
2,4-Dimethylphenol 2,4-Dinitrophenol 2-Methyl-4,6-dinitrophenol </t></si
4-chloro-3-methylphenol pentachlorophenol</t></si><
mg/L
No RP , Predicted Max ≥ 50% of Allowable Cw - apply Quarterly Monitoring
No RP , Predicted Max ≥ 50% of Allowable Cw - defer to LTMP
No RP, Predicted Max < 50% of Allowable Cw - No Monitoring required
RP for Limited Dataset (n<8 samples) - apply Quarterly Monitoring
RP for Limited Dataset (n<8) but 2 values > Allowable Cw - apply Monthly Monitoring with Limit
WWTP/WTP Class
ppt
µg/L
lb/d
rdb
Use "PASTE SPECIAL-Values" then "COPY" . Maximum data points = 58
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.
All worksheets are "Protected"
Reasonable Potential Multiplying Factors - Calculator
Confidence Level
Upper Boundary of the Effluent Distribution (Percentile Value Not To Exceed)
Coefficient of Variation
The "mf calculator" is password "Protected"
MAXIMUM DATA POINTS = 58

New freshwater RPA based on 95% probability/95% confidence
1) assumes only chroinc dilution known
A. When Model is applied (Check box activated):
B. When Model is not applied (Check box NOT activated):
OTHER CHANGES FROM PREVIOUS RPA PROGRAM:
Additional messages will appear to alert user if more than 58 data points were enter and no predicted values will be calculated
C. When paremeter's "Impaired?" check box is activated:
2) does NOT make any automatic adjustements to WQS calculations
1) automtically activtes the
"IMPAIRED"
message alert on the "RPA" page for that parameter
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
NOTE: If new or expanding discharge and receiving stream impaired, will need to evaluate if additional waste load is allowed
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 @ 1Q10s"
= 100% which is used in acute WQS calculatons (See "RPA" page)
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)
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)
"1Q10s (cfs)"
is automatically calculated bases on entered
"7Q10s (cfs)"
flow

4) automatically calculates acute-based IWC% for the
"IWC @ 1Q10s"
value used in acute WQS calculations (See "RPA" page)
2) Added new calculation feature to count nondetects when both "<" and a value are entered for each data set, used to calculate detected entries
1) Amended
"ERR"
alert on data sets entreies to activate if "<" entered but no value entered, does not effect RPA calculation, ERR message only
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
Combined Hardness Chronic
Combined Hardness Acute
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
Total Suspended Solids -Fixed Value-(mg/L)
Combined Hardness chronic (mg/L)
Combined Hardness Acute (mg/L)
Instream Wastewater Concentration (Chronic)
Instream Wastewater Concentration (Acute)
1Q10
Flow Limit
[MGD]
10
Dissolved Metals
US EPA
Translators
- using Default Partition Coefficients (streams)
Maximum Allowable Effluent Concentration (MAEC) as a
Total Metal =
Dissolved Metal
÷
Translator
[ug/l]
Cd -Trout streams</t>
Chromium VI
Chromium, Total
Beryllium
Arsenic (d)
Dissolved Metals & Hardness Determination
v. 5/27/2010</t></si><si><t>I. How to Determine Hardness for use with Dissolved Freshwater Standards for Permitting Purposes</t></si><si><r><t>HARDNESS - Use 25 mg/L, express
I. How to Determine Hardness for use with Dissolved Freshwater Standards for Permitting Purposes
HARDNESS - Use 25 mg/L, expressed as CaCO
3
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)</t></r></si><si><t>(a)    Use the median instream Hardnes

(a)    Use the median instream Hardness value of the ambient 8-digit HUC data collected by the Division of Water Quality.  To find the 8-digit HUC hardness value for your facility, Click
Here.
(b)    For the purpose of this estimation, use the facility's median effluent Hardness value, if available.  The Division will request the permittee to sample effluent hardness once/month
and submit one to two years of data with the permit renewal application. If no effluent hardness data is submitted, a default of 25 mg/L will be applied.
II. To Develop Dissolved Metal concentrations for permitting purposes use the Freshwater Standards for Hardness Dependent Metals listed in Table A below.
Table A: Dissolved Freshwater Standards for Hardness Dependent Metals
Metal
Cadmium, Acute
{1.136672-[ln hardness](0.041838)} · e^{0.9151 [ln hardness]-3.1485} 
Cadmium, Acute (Trout Waters)
{1.136672-[ln hardness](0.041838)} · e^{0.9151[ln hardness]-3.6236}
Cadmium, Chronic
{1.101672-[ln hardness](0.041838)} · e^{0.7998[ln hardness]-4.4451}
Chromium III, Acute
0.316 · e^{0.8190[ln hardness]+3.7256}
Chromium III, Chronic
0.860 · e^{0.8190[ln hardness]+0.6848}
Copper, Acute
0.960 · e^{0.9422[ln hardness]-1.700}
Copper, Chronic
0.960 · e^{0.8545[ln hardness]-1.702}
Lead, Acute
{1.46203-[ln hardness](0.145712)} · e^{1.273[ln hardness]-1.460}
Lead, Chronic
{1.46203-[ln hardness](0.145712)} · e^{1.273[ln hardness]-4.705}
Nickel, Acute
0.998 · e^{0.8460[ln hardness]+2.255}
Nickel, Chronic
0.997 · e^{0.8460[ln hardness]+0.0584}
Silver, Acute
0.85 · e^{1.72[ln hardness]-6.59}
Silver, Chronic
Not applicable
Zinc, Acute
0.978 · e^{0.8473[ln hardness]+0.884}
Zinc, Chronic
0.986 · e^{0.8473[ln 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</t></si><si><r><t xml:space="preserve">Translator equation using Default Partition Coefficients = </t></r><r><rPr><sz val="12"/><rFont val="Tahoma"/><fa
Translator equation using Default Partition Coefficients =
</
1                        </t></r></si><si><r><
[1 + (Kpo * TSS </t></r><r><rPr><vertAlign val="superscript"/><sz val="12"/><rFont val="Ta
(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
Zn
Pb
Cr (III)
(2)
Cd
Ni
(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)</t
(2)
Linear partition coefficients shall not apply to the Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefore, permit
limits for Chromium VI shall be expressed in the dissolved form.  See 40 CFR § 122.45(c)(3).</t
TABLE B. US EPA Translators
Using stream Default Partition Coefficients
TSS = 10 mg/L
Chromium III
Copper
Silver
Zinc
Trout
Water Supply
Human Health Water Supply
Aquatic Life
WQS
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Human Health
COMBINED HARDNESS (mg/L)
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:
3) Revised "Input" pade Table 2:
- 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
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
- Revised Par05 "Chloride (AL)" line:
b) "Chronic" display only for applicable value including conditional method for info display based on "WQS" selection
d) "Name" display only based on "WQS" selection including conditional metdod fro info display
- 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
d) Conditonal controls to activate error nessages, brown highlight
- 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
- Revised "Chromium, Total" line:
a) Removed Par08 label
- Added new "Chromium III" line:
c) brown highlight
b) brown highlight
a) Assigned Par08 label, applicable text in "WQS", "Type", Modifier", Units"
a) Assigned applicable text in "WQS", "Type", Modifier", Units"
- Revised Par09 "Copper (AL)" line:
- Added new Par08 "Chromium VI" line:
- Revisd Par12 "Lead" line:
- Revised Par15 "Nickel" line:
- Revised Par14 "Molybdenum" lime:
e) Conditonal controls to activate error nessages
d) Conditonal controls to activate error nessages
- Revised Par17 "Silver (AL)" line:
- Revised Par18 "Zinc (AL)" line:
- Added new brown highlight "Metal Translator Data Entry" label box
3) Revised "Data" page:
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
- 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
- Removed "Impaired ?" column, conditional display, references
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
- Assigned name for "HUC Number"
- 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) "Allowable Cw" Acute" and "Chronic" conditional metfhod revised fro info display inculding rounding value
- Revised "Cadmium", "Chromium VI", "Copper (AL)", "Lead", "Nickel", "Silver (AL)", "Zinc (AL)" llines:
b) Par02 "Arsenic" references used for display to calculate "Acute" and Chronic" allowable Cw
a) "NC WQS/Chronic" and 1/2 FAV/Acute" conditional method revised for info display, no rounding
5) Revised "Dss to Total Metal Hardness Calculator" page
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
h) "CrIIIMAE_CH" - Chromium III calculated metal tramslator Chronic value
g) "CrIIIMAE_AC" - Chromium III calculated metal translator Acute value.
i) "CrVIMAE_AC" - Chromium VI calculated metal translator Acute value

j) "CrVINAE_CH" - Chromium VI calculatd metal translator Chronic value
m) "PbMAE_CH" - Lead calculated metal translator Chronic value
k) "PbMAE_AC" - Lead calculated metal translator Acute value
n) "NiMAE_AC" - Nickel calculated metal translator Acute value
o) "NiMAE_CH" - Nickel calculated metal translator Chroniv value
q) "AuMAE_CH" - Silver calculated metal translator Chronic value
p) "AuMAE_AC" - Silver calculated metal translator Acute 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
- Assigned names for:
b) "Chronic" and "Acute" inputs to display calculated metal translator values including conditional method for info display based on "WQS" selection, no rounding
b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
- Added conditional methods to formulas for info display and to incorporate names, no rounding
6) Set up passwortd to protect all pages 'rpa2015'
f) PQL condition removed from calculation method for data displayed
Par01
Aquactic Life
Chronic (HH):
Chronic (FW):
1&2
IWC% @ 7Q10S = <
IWC% @ 1Q10S =
IWC% @ 7Q10W =
IWC% @ 30Q2 =
IW%C @ QA =
H
No detects
.
1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION
1) Inserted "Aresenic, Aquatic Life, C, 50, FW, N/A, µg/L" in first row "INPUT" Table 2, Par01
2) Updated program names to reflect addition of new Arsenic Aquatic Life parameter
4) Amended labels on "Data" to show H for hardnes and Par01-Par22 for paremeters
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 %
4) Revised all calculations using IWC values "Acute", "Chronic" to divide by 100 to correct for IWC % value
1/12/16 REVISED IWC CALCULATIONS TO SHOW FULL DISPLAY on "RPA"
3) Revised IWC calculation labels to include "%"
1/12/16 REVISED SPREADSHEET TO INDICATE NO DETECT AND MDL
2) Revised "RPA" all parameters Max Pred CW cell formatting to display
"
NO DETECTS"
when required to display no detects
1) Revised "Data" Par01-Par22 Max Value cell conditional statement to display "NO DETECTS" when data set has all 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
1/12/16:
Corrected formula error in mf formula Par01 to use corrected data set ("Data")
4) Revised "RPA" drop menu to add "No detects" to list and display
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"
3) Inserted "Arsenic" Aquatic Life parameter and cell programming in Arsenic section "RPA" as Chronic and added drop down menu feature
Acute (FW):
!
Par23
Par24
Pa11
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
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.
5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formulas to assign 25 as hardness value when HUC hardness is NA.
4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (HUC Hard Med = NA mg/l)" 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.

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.
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.</
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).</
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.
2-chlorophenol 2,4-dichlorophenol 2,4,6-trichlorophenol</t></si><
10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Method 625.
Par01 & Par02
Here’s the Chromium breakdown:<
a.
</t></
No Monitoring required if all Total Chromium samples are < the Chromium VI Allowable C
w
b.
</t><
Maintain Total Chromium monitoring or defer to LTMP if all Total Chromium samples are < 50 µg/L but
 >
the Allowable C
w
for Chromium VI.<
c.
</t></
Monitor Total Chromium and Chromium VI, along with a limit for Chromium VI if any Total Chromium sample is
 ≥  5
0 µg/L

and

 ≥
to the Allowable C
w
for Chromium VI but &< the Allowable Cw for Chromium III.
d.
</t><
Limit both Chromium III and Chromium VI when any Total Chromium sample is ≥ 50 µg/L and ≥
to the Allowable Cw for Chromium III. Monitor for Total Chromium and Chromium Vi, report the calculated Chromium III.
2/16/16:
1) Revised "Diss to Total Metal Calculator" page:
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
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
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)
2) Revised "input" page dipplay HUC Hardness (Median) to show NA when HUC table value is NA.
See task notes
Revised "input"page model feature to
b- Revise cell formula 1Q10s (cfs) to display 1Q10s 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
a- Add new model 1Q10S input cell that is visible on;y when model feature is activated
2/3/16:
2/9/16:
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
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
Added new display messages to "rpa" page that are visible only when the steam class is water supply
Chromium, Total (t)
Ni - WS streams (t)
Par25
Chronic (WS):
Par17 & Par18
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
Set up both Nickel Par17 & Par18 to use same data entries
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

Changed Par22-25 modifier cells to be set automtically based on WQS entry.
17&18
Changed display font color phenols, chlorinared phenols menus
Cadmium (d)

Chromium III (d)(h)
Chromium VI (d)
Copper (d)(h)
Lead (d)(h)
Nickel (d)(h)
Silver (d)(h,acute)
Zinc (d)(h)
The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard.</t></si>
The Human Health standard for Arsenic is 10 µg/L which is Total Recoverable metal standard.</t></si>
(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.
2/19/16:
2/22/16:
Make text changes per Julie direction.
Dissolved to Total Metal Calculator
COMMENTS (identify parameters to PERCS Branch to maintain in facility's LTMP/STMP):
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
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".
4) Set up new Name "PERCS_page" as print area for table and other PERCS info for GOTO use.
`
HUC Number
Upstream Hardness
H1
H2
Average Value =
password all sheets = rpa2016a
10th Per value
3/18/16:
Added Upstream Hardness calculation feature using measured upstream data:
Removed HUC table and HUC hardness lookup features from calculations and program.
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.</
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.
Effluent Hardness
4/26/16:
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.
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.
6) Renamed RPA to describe features
ACCH
ACAH
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.
4) Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate defaults
3) Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate defaults
4/28/16: Note Action Level designation no longer allowed per EPA.
RP shown - apply Monthly Monitoring with Limit
4/28/16:
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…".

Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI now function.
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
TotCh>50
≥
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
NC STANDARDS OR EPA CRITERIA
6/13/16:
Corrected INPUT tab to align Dats Source(s) text box at top.
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.
Effluent Hardness Average (mg/L)
Upstream Hardness Average (mg/L)
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
Corrected label on DISS … page to indicate average for effluent and upstream hardness
Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when default 400 mg/L applied
To appy a Model IWC %: Once the "Flow, Qw (MGD)" and and the "CHRONIC DILUTION FACTOR = " values are entered, the 7Q10s (cfs) flow is calculated and displayed. Enter the calculated "7Q10s
(cfs)" flow value in Table 1.
7/13/16:
User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry box. 1Q10s is calculated once the calculated 7Q10s (cfs) is entered in Table1.

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.
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 % .
Aluminum
Total Dissolved Solids
Sutton
I
NC0001422
C, Sw
renewal application, historic data
008
Sutton Lake
Copper WER

Must Designate One:

C = Carcinogen
NC = Non-carcinogen
WQS Standards Designate Applicable Standard:

A = Aesthetic Standard

FW = Freshwater Aquatic Life Standard

HH = Human Health Standard
for human consumption organism and water

TR = Trout Aquatic Life Standard

WS = Water Supply Standard
for human consumption water

This “npdes rpa” workbook was developed by and for the use of the North Carolina Division of Water Quality for the purpose of conducting Reasonable Potential Analyses under the NPDES
permit program. It is a working tool for DWQ staff and may be distributed to others at no charge so long as it contains this acknowledgement. Portions of the workbook are lightly protected
to prevent accidental alteration, and DWQ cannot guarantee that any copy so distributed is unaltered. Please contact the Point Source Branch to request an original copy.
</a:t></a:r><a:r><a:rPr lang="en-US" sz="1600" b="0" i
NCDWQ, 2009
Please see the 'user_guide' worksheet
for instructions on the use of this workbook.

CHECK IF HQW OR ORW WQS
CHECK TO APPLY MODEL
Apply WS Hardness WQC

Additional guidance on RPA 2010 revision v.Freshwater07282010:
I.
<
TABLE 1,
the Input page
:
a. The 1Q10 flow will automatically be determined when the 7Q10 is entered.
II. In
TABLE
2
, under the
Input page
, enter the parameter
Type
and
Modifier
as follows:

</a:t><
TYPE: MODIFIERS:
___
___________________________
<
C = Carcinogen
NC = Non-carcinogen
</a:t></a:r><
FW = Freshwater Aquatic Life Standards
<
</a:t></a:r><
A = Aesthetic
<
</a:t></a:r><
WS = Water Supply, human health associated with water & organism consumption
HH = Human Health associated with organism consumption</a:t></a:r><a:
</
III. When
entering sample results on the "data" sheet as shown to the right:
a. Data numbers (sample results) and &<'s can be copied and pasted but should be entered by clicking
Paste </a:
Special and Values.
b. If a PQL is listed, a sample result less than the PQL will be<
recognized at the PQL limit. Example
,
</a:
the PQL
for <
Cyanide
is
10 ug/L. Entering a
sample such as < 9
ug/L will result
in
a BDL=1/2

DL of

5 ug/L
because it recognizes the sample result is less than the PQL.
If you want the
sample to be recognized at that lower PQL level, d
ecrease or remove the PQL. In the example on the right, if you want the BDL=1/2

DL
to equal 4.5 the PQL on the Input Table for Cyanide would have to be removed or lowered.
IV. RPA sheet
and limit calculations:
Freshwater (FW)

To delete a parameter from the chart, simply click on the parameter number on the left , right click, hit delete and entire row.
Calculated limits are determined as follows:
a. Chronic and acute, Aquatic Life standards
for all parameters,
carcinogenic(C) or non-carcinogenic(NC),
will be divided by the 7Q10 and 1Q10, respectively.
b. Non-carcinogenic

(NC) parameters with
Human Health standards (HH and WS)
will be divided by the 7Q10
to give a chronic standard.

c
. Carcinogenic parameters with Human Health standards (HH and WS) will be divided by the mean annual average flow (QA) to give a chronic standard.
d. Parameters with
Aesthetic standards
such as Phenolic Compounds are divided by the 30Q2 flow.
Saltwater (S)
Go to the Saltwater RPA. All the rules
listed above are the same for saltwater aquatic life standards.
Instead of using FW (Freshwater) as the MODIFIER, use S (Saltwater).
If you would like No Dilution to be allowed, simply enter
the word
"<
Tidal"
under Stream Info.
on
Table 1
.

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).
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.

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.

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.<
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.
For monitoring and compliance purposes
if Total Chromium < the Chromium VI chronic Total Metal limitation – no limit or monitoring is required.
</a:t></a:r></a:p></xdr:txBody></xdr:s

Example for Cadmium (streams)
Given
:
TSS
= 10 mg/L
Kpo
= 4.00E + 06
a
= -1.1307
Translator   = </a
1                             </a:t></a:r></a:p><a:p><a:pP
[1 + (Kpo * TSS </a:t></a:r><a:r><a:rPr lang="en
(1+
a
)
* 10
-6
)]
 </a:t></a:r><a:endPa
 = </a:t></a:r><a:r><a:
1                              </a:t></a:r></a:p><a:p><a:pP
 [1 + (4.00x10</a:t></a:r><a:r><a:rPr lang
6
* 10
1-1.1307)
* 10
-6
)]
 </a:t></a:r
 = </a:t></a:r><a:r><a:
1                              </a:t></a:r></a:p><a:p><a:pP
 [1+2.960465]</a:t></a:r></a:p><a:p><a:pPr algn="l" rtl
 </a:t></a:r><a:endPa
 = 0.252</a:t></a:r><a:endPa

Using the Tool
The general sequence of steps for completing the RPA is as follows:
Setup (‘in’ sheet)-Begin with a blank copy of the ‘npdes rpa 200403.xls’ file. (Permit writers: To generate a blank copy, double-click on the RPA template (‘npdes rpa 200403.xlt’)
or on the shortcut to the template, located on the NPDES server.)
-Enter the facility, receiving stream, and other project-specific information in Table 1 of the ‘in’ sheet. The information will automatically populate the ‘rpa’ sheet.
-Enter the parameter names, applicable standards, and other information for the Pollutants of Concern (POCs, up to 15) in Table 2 of the ‘in’ sheet. The POC names will automatically
populate both the ‘rpa’ and the ‘data’ sheets.
-Table 2 already includes relevant information on the most common parameters. Users can change the table’s contents to include different parameters or to adjust for a saltwater discharge.

DO NOT cut-and-paste or click-and-drag the existing POC cells in order to re-arrange them. Instead, copy-and-paste the cells, then go back and delete the originals. (Just trust me on
this.) -Hide any rows in the ‘rpa’ and ‘data’ sheets that are not needed for the RPA. The file includes a toolbar with custom to simplify this.
-Enter new POC information into the appropriate cells. Be sure to update all of the information for each parameter to be changed.
-Once the information is entered, you can sort it by Parameter (or whatever column you choose) to get it in the preferred order.
Data Entry -Prepare the raw effluent data for each POC and enter it in the appropriate columns in the ‘data’ sheet.
-There are three data columns for each parameter: the Date, the “<” indicator (if needed; any character will work), and the data value. Enter the data accordingly. It is sometimes easier
to use the ‘blank’ sheet or other sheet to arrange the raw data, and then copy it into the ‘data’ sheet.
-Values entered as “less than detection” using the “<” character (actually, any character in that column) will automatically be halved for the calculations that follow. The sheet also
counts any values less than the PQL (see Table 2 on the ‘in’ sheet) as “less than detection”.
User’s Guide
RPA Tool
March 21, 2009
The RPA Tool is an Excel workbook, ‘npdes rpa 200403.xls, developed and maintained by the NCDWQ’s NPDES Permitting Units. The Unit’ permit writers use the Tool to evaluate effluent data
from individual wastewater treatment plants and determine whether limits for certain pollutants of concern (typically, heavy metals, cyanide, and toxic organics) are warranted. It evaluates
the magnitude and variability of the data and determines whether there is a reasonable potential that the discharge will cause a contravention of applicable water quality standards
and criteria. If such reasonable potential is found, the permit writer uses the results of the analysis to determine appropriate permit limits for the parameter(s).
The Tool employs statistical methods described in the U.S. EPA’s Technical Support Document for Water Quality-based Toxics Control, March 1991, EPA/505/2-90-001, available for download
at http://yosemite.epa.gov/water/owrccatalog.nsf/e673c95b11602f2385256ae1007279fe/025cb4267d4d9fd585256b060072539a?OpenDocument&CartID=8774-040144.
Overview
The RPA workbook consists of six spreadsheets:
ack is the introductory screen and explains to terms of use of the RPA tool.
in is the initial data entry sheet for project-specific information and the pollutants of concern.
rpa is the main worksheet of the tool. It serves as a summary report of the RPA’s results and includes the permit writer’s recommendations for each parameter.
data contains the raw effluent data for each pollutant of concern. Most of the statistical calculations are carried out on this sheet.
mf table is the standard Multiplication Factor table used in the tool. The MF is a function of the number of samples (n) and the Coefficient of Variation (CV, the standard deviation
of a data set divided by its mean).
blank is a blank sheet which can be used to organize effluent data prior to entering the data in the ‘data’ sheet. Of course, you can add others if the need arises.
The first five sheets are “protected” to prevent unintentional (and undetected) changes in the spreadsheet’s programming or content. However, certain portions of the ‘in,’ ‘rpa,’ and
‘data’ sheets - highlighted in light blue - are unlocked for data entry.
Unfortunately, the “protect” feature in Excel prevents certain changes (some formatting, for instance) that would be useful and would not corrupt the workbook. To get around this, the
sheets include macros that allow the user to unlock (and re-lock) the sheets when changes are needed (more on that below).
Review Results-The ‘data’ sheet calculates the maximum predicted concentration for each POC and returns it to the ‘rpa’ sheet (Col. K). The ‘rpa’ sheet compares this result with the
maximum concentrations allowed by the acute standard (no instream dilution) and the chronic standard (dilution included) and reports whether the maximum predicted value is more than
or less than the maximum allowed (Col. L). It also presents an automated response, suggesting a permitting action based on these results.
Enter Recommendations - At this point, the permit writer must evaluate the results in the ‘rpa’ sheet, along with any other relevant factors, and recommend what limits and/or monitoring
to include in the new permit. Enter these notes in Column M.<
Misc. notes:
‘mf table’</w:t></w:r><w:r - n = 1-200, CV = 0.1-6.1- values based on 99% probability to not exceed, with 99% confidence
REASONABLE POTENTIAL ANALYSIS
Par05
Chlorides
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
Par06
Aluminum
Use "PASTE SF
Values" then "1
. Maximum c
points = 5
Date Data BDL=1/2DL Results
NO DATA 1 Std Dev. NO DATA
NO DATA 2 Mean NO DATA
NO DATA 3 C.V. NO DATA
0 4 n 0
5
N/A 6 Mult Factor = N/A
N/A mg/L 7 Max. Value N/A
N/A mg/L 8 Max. Pred Cw N/A
9
- 6 -
NC0001422_Worksheets_20220210.xlsm, data
6/8/2022

REASONABLE POTENTIAL ANALYSIS
,ECIAL
COPY"
lata
;8
mg/L
mg/L
Par07
Total Dissolved Solids
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 mg/L
N/A mg/L
Par08
Use "PASTE SF
Values" then "1
. 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 -
NC0001422_Worksheets_20220210.xlsm, data
6/8/2022

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

REASONABLE POTENTIAL ANALYSIS
,ECIAL
COPY"
lata
;8
fag/L
fag/L
Pal 1
Copper
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
Par12
Use "PASTE SF
Values" then "1
. 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
Cyanide
- 9 -
NC0001422_Worksheets_20220210.xlsm, data
6/8/2022

REASONABLE POTENTIAL ANALYSIS
,ECIAL
COPY"
lata
;8
ug/L
ug/L
Par13
Fluoride
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
Par14
NO DATA
NO DATA
NO DATA
0
N/A
N/A ug/L
N/A ug/L
Date
Use "PASTE SF
Values" then "1
. Maximum c
points = 5
BDL=1/2DL Results
Std Dev. NO DATA
Mean NO DATA
C.V. NO DATA
n 0
Lead
Mult Factor = N/A
Max. Value N/A
Max. Pred Cw N/A
NC0001422_Worksheets_20220210.xlsm, data
- 10 - 6/8/2022

REASONABLE POTENTIAL ANALYSIS
,ECIAL
COPY"
lata
;8
ug/L
ug/L
Par15
Mercury
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 ng/L
N/A ng/L
Par16
Use "PASTE SF
Values" then "1
. 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
NC0001422_Worksheets_20220210.xlsm, data
6/8/2022

REASONABLE POTENTIAL ANALYSIS
,ECIAL
COPY"
lata
;8
ug/L
ug/L
Par17 & Par18
Nickel
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
Par19
Selenium
NO DATA
NO DATA
NO DATA
0
N/A
N/A fag/L
N/A fag/L
Date Data BDL=1/2DL Results
1 Std Dev.
2 Mean
3 C.V.
4 n
5
6 Mult Factor =
7 Max. Value
8 Max. Pred Cw
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
NC0001422_Worksheets_20220210.xlsm, data
- 12 - 6/8/2022

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par20
Silver
NO DATA
NO DATA
NO DATA
0
N/A
N/A ug/L
N/A ug/L
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
Par21
Zinc
NO DATA
NO DATA
NO DATA
0
N/A
N/A ug/L
N/A ug/L
Date Data BDL=1/2DL Results
Std Dev.
Mean
C.V.
n
Mult Factor =
Max. Value
Max. Pred Cw
NC0001422_Worksheets_20220210.xlsm, data
- 13 - 6/8/2022

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par22
Copper WER
NO DATA
NO DATA
NO DATA
0
N/A
N/A ug/L
N/A ug/L
Date Data
< 10
10
11
7
6
6
5
8
8
8
7
8
6
5
4.16
3.77
3.79
4.87
4.64
26.4
5.23
5.2
BDL=1/2DL
5
10
11
7
6
6
5
8
8
8
7
8
6
5
4.16
3.77
3.79
4.87
4.64
26.4
5.23
5.2
Results
Std Dev.
Mean
C.V.
n
Mult Factor =
Max. Value
Max. Pred Cw
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par23
0
4.7051
7.1845
0.6549
22
1.35
26.400000 fag/L
35.640000 fag/L
Date Data
BDL=1/2DL
NC0001422_Worksheets_20220210.xlsm, data
- 14 - 6/8/2022

REASONABLE POTENTIAL ANALYSIS
Results
Std Dev.
Mean
C.V.
n
Mult Factor =
Max. Value
Max. Pred Cw
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
NO DATA
NO DATA
NO DATA
0
N/A
N/A
N/A
Par24
0
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
NC0001422_Worksheets_20220210.xlsm, data
- 15 - 6/8/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
NC0001422_Worksheets_20220210.xlsm, data
- 16 - 6/8/2022

Sutton
N C0001422
Qw (MGD) = 211.00
1Q1OS (cfs) = 0.00
7Q 1 OS (cfs) = 0.00
7Q 1 OW (cfs) = 0.00
30Q2 (cfs) = 0.00
Avg. Stream Flow, QA (cfs) = 0.00
Receiving Stream: NO H U C NUMBER
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
MAXIMUM DATA POINTS = 58
WWTP/WTP Class:
IWC% @ 1Q1OS = 100
IWC% @ 7Q 10S = 100
IWC% @ 7Q 1 OW = 100
IWC% @ 30Q2 = 100
IW%C @ QA = 100
Stream Class: C, Sw
Outfall 008
Qw = 211 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
(1)
NC STANDARDS OR EPA CRITERIA
_1
a
°
N
H
z-
m
REASONABLE POTENTIAL RESULTS
RECOMMENDED ACTION
Chronic
Applied
Standard
Acute
11
# Det. Max Pred Cw Allowable Cw
Acute (FW):
340.0
Arsenic
C
150
FW
340
ug/L
_ _ _ _ _____
_______________________________
0
0
N/A
Chronic (FW):
150.0
Arsenic
C
10
HH/WS
ug/L
Chronic (HH):
10.0
Acute:
65.00
Beryllium
NC
6.5
FW
65
ug/L
0
0
N/A
Chronic:-----6.50
------------------------------
Acute:
3.240
Cadmium
NC
0.5899
FW
3.2396
ug/L
0
0
N/A
Chronic: ----
0.590 ------------------------------
Acute:
NO WQS
Chlorides
NC
230
FW
mg/L
0
0
N/A
Chronic: ----
230.0 ------------------------------
Acute:
NO WQS
Aluminum
NC
8
HH
mg/L
0
0
N/A
Chronic: -----
8 0-------------------------------
Acute:
NO WQS
Total Dissolved Solids
NC
500
WS
mg/L
0
0
N/A
Chronic: ----
500.0 ------------------------------
Acute:
905.1
Chromium III
NC
117.7325
FW
905.0818
µg/L
0
0
N/A
Chronic:-----117.7
------------------------------
Acute:
16.0
Chromium VI
NC
11
FW
16
µg/L
0
0
N/A
Chronic:-----11.0
------------------------------
Chromium, Total
NC
µg/L
0
0
N/A
Page 17 of 58
NC0001422_Worksheets_20220210.xlsm, rpa
6/8/2022

Sutton
N C0001422
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall 008
Qw = 211 MGD
Copper
NC
7.8806
FW
10.4720
ug/L
0
0
N/A
Acute: 10.47
Chronic:-----7.88 -----------------------------
Fluoride
NC
1800
FW
ug/L
0
0
N/A
Acute: NO WQS
Chronic: 1,800.0
Lead
NC
2.9416
FW
75.4871
ug/L
0
0
N/A
Acute: 75.487
Chronic: ---- 2.942 -----------------------------
Mercury
NC
12
FW
0.5
ng/L
0
0
N/A
Acute: NO WQS
Chronic:-----12.0 -----------------------------
Molybdenum
NC
160
WS
ug/L
0
0
N/A
Acute: NO WQS
Chronic:-----160.0 -----------------------------
Nickel
Nickel
NC
NC
37.2313
25.0000
FW
WS
335.2087
µg/L
µg/L
0
0
N/A
Acute (FW): 335.2
_ _ _ _ ----_ _ -----------------------------
Chronic (FW): 37.2
Chronic (WS): 25.0
Selenium
NC
5
FW
56
ug/L
0
0
N/A
Acute: 56.0
Chronic: ----- 5.0
Silver
NC
0.06
FW
0.29639789
ug/L
0
0
N/A
Acute: 0.3
Chronic: ----- 0.1
Zinc
NC
126.7335
FW
125.7052
ug/L
0
0
N/A
Acute: 125.7
Chronic:-----126.7 -----------------------------
Copper WER
NC
71.4
FW
96.7
µg/L
22
21
35.64000
Acute: 96.70000
Chronic: --- 71.40000
No value > Allowable Cw
No limit
NC
FW(???)
0
0
N/A
Acute:
Chronic: -------------------------------------
NC
WS(???)
0
0
N/A
Acute:
Chronic: -------------------------------------
Acute:
Page 18 of 58
NC0001422_Worksheets_20220210.xlsm, rpa
6/8/2022

Sutton Outfall 008
NC0001422 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 211 MGD
NC 1 WS(???) 0 0 N/A
Chronic:------------------------------------
NC0001422_Worksheets_20220210.xlsm, rpa
Page 19 of 58 6/8/2022

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*
Conductiv E 1/Week 1/Week 3/Week Daily
Conductiv 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 M - monitor semi-annually
- >= 1.0 MG - monitor quarterly
For all other river basins:
- >= 0.05 M - monitor quarterly
- >= 1.0 MG - monitor monthly
Sample recommends

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
NO DATA
MONITOR?
MONITOR?
REMOVE?
REMOVE?
DAILY MAX LIMIT?
MO AVG LIMIT?
DAILY MAX LIMIT?
MaxPredCw » Chronic MO AVG LIMIT?
No acute standard or 1/2 FAV N/A
No chronic standard or criterion N/A
Daily max limit
Monitor 1/month
Monitor 1/week
Monitor 2/month
Monitoring not neces:
No limit
No limit - assuming n
No limit (Action Leve
Continue to monitor
Mo. avg. limit (keep v
Revise daily max. lirr

Per Memo Dated 7-15-2010
A Condition tp
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'
3a.RPA Exists but Dataset Limited (n< 8 samples)
3b. RPA exists, dataset limited. but 2 values >
allowable Cw
Monitor Quarterly
Monitor Monthly and add Permit Limit
4.No RPA (Predicted Max> 50% of Allowable)
Monitor Quarterly (or defer to Pretreat I
5.No RPA (Predicted Max < 50% Allowable)
No Monitoring
6a.No Data (New Permit, New Waste Stream)
6b. New Greensand or Conventional W FP
Monitor Monthly for Toxic Pollutants of
Monitor Quarterly for Toxic Pollutants
password all sheets = rpa2016a
4/28/16: Note Action Level designation no longer allowed per EPA.
tions:

;ary in permit
o tox (Action Level parameter)
parameter)
it 2/month
vk. avg. if existing)
lit

'ox Test
:TMP)
f Concem
Df Concern

Dissolved Metals & H
[. How to Determine Hardness for use
HARDNESS - Use 25 mg/L, expressed as (
OR
To determine a Hardness value for permit
Hardness = (Hardness instream(a) n
(mass balance)
(a) Use the median instream Hardness v;
(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
Translator equation using Default Partition Coe
Kpo and a are constants that express the equi
A default value of 10 mg/L Total Suspended
Table A contains the Default Partition Coen
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:
1g/L * 7Q10, MGD)+(Hardness effluent(b), mg/L* Plant flow, MGD)
(7Q10, MGD + Plant flow, MGD)
alue of the ambient 8-digit HUC data collected by the Division of Water Quality. To find the 8-digit HUC hardness
le facility's median effluent Hardness value, if available. The Division will request the permittee to sample effluent hardness c
icentrations for permitting purposes use the Freshwater Standards for Hardness Dependent
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,
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

value for your facility, Click Here.
mce/month and submit one to two years of data with the permit renewal application. If no effluent hardness data is sul
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 * 1011.13°) * 10-6)]
= 1
[1+2.960465]
= 0.252

Omitted, 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
__,9
1.92
2.63
3.55
6.20
7.98
10.11
12.60
15.47
18.72
22.35
26.38
30.78
2
1.00
1.27
1.61
2.03
2.53
E.,. _L1
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
Multiplication Factor
RPMFs as
f(n,CV,Confidence,U pperBound)
400.00 T-----
350.00
300.00
250.00
200.00
150.00
100.00
50.00
0.00
1 4 7 10 13 16 19 22 25
0
1.1 '1
0
0.1
V
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
S.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 were est
Additional messages will appear to alert user if more than 58 data points were enter and no predicted values wi
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 "7Q1 Os (cfs)", "7Q1 Ow (cfs)", "30Q2 (cfs)
3) automatically assigns the entered chronic IWC % to the "IWC @ 7Q10s", "IWC @ 7Q10w", "IV
3) "1 Q10s (cfs)" automatically defaults to no acute dilution, acute IWC = 100% ,"IWC @ 1 Q10s"
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)", "30Q2 (cfs)
3) automatically calculates chronic -based IWC % for the "IWC @ 7Q10s", "IWC @ 7Q10w", "IW
3) "1 Q10s (cfs)" is automatically calculated bases on entered "7Q10s (cfs)" flow
4) automatically calculates acute -based IWC% for the "IWC @ 1 Q10s" value used in acute WQS
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 additi
10/30/2013 rdb
1) Amended "ERR" alert on data sets entreies to activate if "<" entered but no value entered, does not effect F
2) Added new calculation feature to count nondetects when both "<" and a value are entered for each data set,
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 o
(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, br
- New display only for calculated "Effluent Hardness (Median)" including conditional method for info display, bro
- New display only for designed "HUC Hardness (Median)" incuding conditionla method for info display, brown I-
- New display only for calculated "Combined Hardness Chronic" for metal translator application, brown highligh
- 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
- 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 =
- 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 n
c) "Modifier" input display only based on "WQS" selection including conditional method for info disK
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 or
c) "Modifier" input display only based on "WQS" selection including conditional method for info disK
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 or
c) "Modifier" input display only based on "WQS" selection including conditional method for info disK
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 n
c) "Modifier" input display only based on "WQS" selection including conditional method for info disK
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 sec
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 infc
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 meth)
- 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 rounc
5) Revised "Dss to Total Metal Hardness Calculator" page
- Assigned names for:
a) "CdMAE_AC" - Cadmium calculated metal translator Acute value
b) "CdMAE_CH" - Cadmium calculated metal translator Chronic value
c) "CuMAE_AC" - Copper calculatd metal translator Acute value
d) "CuMAE_CH" - Copper calculated metal translator Chronic value
e) "Cr_Total_AC" - Total Chromium calculated meat) translator Acute value
f) "Cr_Total_CH" - Total Chromium calculated metal translator Chronic value
g) "CrIIIMAE_AC" - Chromium III calculated metal translator Acute value.
h) "CrIIIMAE_CH" - Chromium III calculated metal tramslator Chronic value
i) "CrVIMAE_AC" - Chromium VI calculated metal translator Acute value
j) "CrVINAE_CH" - Chromium VI calculatd metal translator Chronic value
k) "PbMAE_AC" - Lead calculated metal translator Acute value
m) "PbMAE_CH" - Lead calculated metal translator Chronic value
n) "NiMAE_AC" - Nickel calculated metal translator Acute value
o) "NiMAE_CH" - Nickel calculated metal translator Chroniv value
p) "AuMAE_AC" - Silver calculated metal translator Acute value
q) "AuMAE_CH" - Silver calculated metal translator Chronic value
r) "ZnMAE-AC" - Zinc calculated metal translator Acute value
s) "ZnMAE_CH" - Zinc calculated metal translator Chronic value
t) "tss" - assigned TSS harness factor
u) "CHA" - calculated combined acute hardness value
v) "CHC" - calculated combined chronic hardness value
- Added conditional methods to formulas for info display and to incorporate names, no rounding
6) Set up passwortd to protect all pages 'rpa2015'
1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION
1) Inserted "Aresenic, Aquatic Life, C, 50, FW, N/A, pg/L" in first row "INPUT" Table 2, Par01
2) Updated program names to reflect addition of new Arsenic Aquatic Life parameter
3) Inserted "Arsenic" Aquatic Life parameter and cell programming in Arsenic section "RPA" as Chronic and adl
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 displaye
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
2) Revised "RPA" all parameters Max Pred CW cell formatting to display "NO DETECTS" when required to di
3) Revised "RPA" alert message (under Chronic labels) conditional statement to display "Max MDL <2 x max
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 h
1/21-29/16:
1) Expanded parameter list and program features to add two additional parameters, (Par08) "Chromium III" & (I
new corresponding RPA evalutaion, non -detect evaluation, formulas for each new data input section; adding 1
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,
3) Corrected Arsenic - Aquatic Life, Berylium Chronic and Acute values on "Input" tab to be exported from meta
4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (HUC Hz
5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formulas to as:
6) Revised "RPA" tab Chromium, Total Reasonable Potential Results section to remove Acute and Chronic lab(
7) Revised "RPA" tab Chromium III and Chromium VI Reasonable Potential Results sectons to remove display
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'
8) Revised "RPA" tab Acute and Chronic conditional formulas for active parameters to display either "IWC?" of
9) Removed label from "Input" tab.
10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Method 6
See task notes
2/3/16:
Revised "input"page model feature to
a- Add new model 1 Q10S input cell that is visible on;y when model feature is activated
b- Revise cell formula 1 Q10s (cfs) to display 1 Q10s flow when model feature activated or calculate from 7Q10s
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 =
Revised "data" page Effluent Hardness (Median) cell formula to display 99 whenstream class is WS and Effluer
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
exceeds 99.999 mg/L)
revised the existing calculation input/display cells for Effluent & HUC Hardness Median to show the applied hall
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
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 N(
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 Act
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 pr
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 1
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
3) Diss to Total Metal Calculator determines which upstream hardness to apply, if the number of data entries e)
10th percentile value is used. Anytime the applied upstream hardness is less than 25 mg/L then a default vak
4/26/16:
Per Julia want to use average values for both the effluent and upstream hardness calculations. Defaults to be tr
1) Changed all upstream hardness median calculations to average calculations.
2) Removed any greater than 99.999 defaults from upstream hardness conditional statements. Upstream averE
3) Changed all effluent hardness median calculations to average calculations. Conditional statements for WS s.
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 co
1) Set up new cells to calculate combined acute and chronic hardness, defined cells as program names ACCH
2) Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH & ACAH exceed 100 when
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 defaull
4/28/16:
Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI now fu
Revised RPA page drop menu "Recommended Action" list to remove RP Action Level text and change "RP nor
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 dish
Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardness of 2;
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
Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Total Chrc
6/13/16:
Revised title block text RPA tab to state "NC STANDARDS OR EPA CRITERIA", removed "NC WQS" from Chi
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 vale
Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when default 400

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 ar
User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry box. 1 C
Revised narrative in Model narrative box with new instructions, new messages to alert user on actions needed
Remove conditions and features assocaited with entry of Model Acute IWC % .

:balished to allow only 58 data point entries.
II be calculated
", "QA (cfs)" to define chronic dilution in terms of "IWC %", "IWC %" is the same for all stream flows
VC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page)
= 100% which is used in acute WQS calculatons (See "RPA" page)
", "QA (cfs)" , "Flow Qw (MGD)" for chronic IWC % calculations, IWC % will vary according to flows
C @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page)
calculations (See "RPA" page)
onal waste load is allowed
ZPA calculation, ERR message only
used to calculate detected entries
f translator formulas, metals impacted, general info), "Dss to Total Hardness Calculator"
own highlight
wn highlight
iighlight
t
, Molybdeum, Nickel

"N/A"
iethod for info display based on "WQS" selection, no rounding
)aly
1 "WQS" selection
)aly
1 "WQS" selection
)aly
iethod for info display based on "WQS" selection, no rounding
)aly
ton for used to calculate eflluent hardness factors
display

od for info display
I
ling value
ded drop down menu feature
d
)
has all no detects
;play no detects
adjusted data set value>" when data set has all no detects

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

int mode set up, will need to designate "Print Selection".
For other portion of the progam and has no Data Validation features.
of data enties, data set average, data set 10th percentile value
(ceed 30 then the average value is used, if the number of data enties are less than 30 then the
ae of 25 mg/L is applied.
le same as was applied in the HUC base RPA.
ige will be actual execpt when less than 25, then 25 is the default.
till apply, efflunet average value above 99.999 default to 99.
mbined hardness exceeds 100. Made changes:
& ACAH.
VS was applied.
is
nction.
1 action level..." text to state "RP shown...".
)lay to 2 decimal points.
5 to be displayed as non -default value.
Cr III and Cr VI Allowable Cw
)mium value entered
'onic label, and removed 1/2 FAV from Acute label.
ue exceeded 400 mg/L
mg/L applied

id CHRONIC DILITION FACTOR (from Model) and display in Model narrative box.
10s is calculated once the calculated 7Q10s (cfs) is entered in Tablel .
and/or completed to correctly enter Model 7Q10s (cfs) in Table 1.

Date: 6/8/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.
FACILITY: Sutton
NPDES PERMIT: NC0001422
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
1 Q10
[MGD]
NPDES
Flow Limit
[MGD]
Total Suspended
Solids
-Fixed Value-
(mg/L)
Combined
Hardness
chronic
(mg/L)
Combined
Hardness
Acute
(mg/L)
Instream
Wastewater
Concentration
(Chronic)
Instream
Wastewater
Concentration
(Acute)
Upstream
Hardness
Average (mg/L)
Effluent
Hardness
Average
(mg/L)
0.C11
0.0000
0.0000
211.0000
10
25.000
25.000
100.0000
100.0000
I 25
I 25
Upstream Hard Avg (mg/L) =
25
EFF Hard Avg (mg/L) = 25
PARAMETER
Dissolved Metals
Chronic
Acute
lug/11
lug/11
US EPA Maximum Allowable Effluent Concentration
Translators- using (MAEC) as a Total Metal
Default Partition =Dissolved Metal - Translator
Coefficients
(streams)
Chronic
fug/Il
Acute
fug/Il
Cadmium (d)
Cd -Trout streams
Chromium III (d)(h)
Chromium VI (d)
Chromium, Total (t)
Copper (d)(h)
Lead (d)(h)
Nickel (d)(h)
Ni - WS streams (t)
Silver (d)(h,acute)
Zinc (d)(h)
0.15
0.15
24
11
2.7
0.54
16
0.06
36
0.82
0.51
183
16
3.6
14
145
0.30
36
0.252
0.252
0.202
1.000
0.348
0.184
0.432
1.000
0.288
0.59
0.59
117.73
11.00
N/A
7.88
2.94
37.23
3.24
2.01
905.08
16.00
N/A
10.47
75.49
335.21
25 N/A
0.06 0.30
126.73 125.71
Beryllium
Arsenic (d)
6.5
150
65
340
1.000
1.000
6.5
150
65
340
COMMENTS (identify parameters to PERCS Branch to maintain in facility's LTMP/STMP):
(d) = dissolved metal standard. See 15A NCAC 02B .0211 for more information.
(h) = hardness -dependent dissolved metal standard. See 15A NCAC 02B .0211 for more information.
(t) = based upon measurement of total recoveable metal. See 15A NCAC 02B .0211 for more information.
The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard.
The Human Health standard for Arsenic is 10 µg/L which is Total Recoverable metal standard.
ACAH
ACCH