NC0004952_Worksheets_20210625 (4)

Worksheet - RPA

0
0

1

0

150
340
10

10
50

6.5
65

0.58987911307921359
3.2396117368502959

0.45
230

1

300

117.73254526741752
905.0817858548595

11
16

32

48
7.8806391707256838
10.471993662870075

48
5
22
10

201
1800
160

26.33
2.94162407165387
75.48710403296981
2000

12
0.5

2000

37.231337220463082
335.20869614001487

25

5
56

0.06
0.29639788810883599

126.73347513150829
125.70521164159754

21

60

0.95
16

0.03
2

1

0

3

8

,

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

1
25
25
1
25
25
1
1
0.5
1
1
0.5
1
1
0.5
1
1
1
0.34666666666666668
0.17333333333333334
10.043201791372223
1
1
1
0.3
0.15
2.3285814709102763
1
17
17
4.9328828623162471
1
1
5
0
1
430
430
1
0.64
0.32
1.5606408939919529
1
1
0.5
1
1
1.23
0.61499999999999999
3.9341079039599314
1
1
0.5
1
1
0.5
1
17
17
1
1
0.5
1
0.05
2.5000000000000001E-2
0.9267236193529691
1
1
2.29
1.145
1.3219642897345354
0
1
1
1
0
0
1
0
0
1
0
1
0
1
1
0
1
1
1
0
1
1
0
1
0

2
25
2
25
2
0.5
2
0.5
2
0.5
2
2
2
8
4
7.2506666666666657
2
2
2
5
2.5
3.1625000000000001
2
10
5
10.5
2
5
5
5
2
430
2
4
2
2.3499999999999996
2
0.5
2
2
10.4
10.4
3.819
2
0.5
2
0.5
2
17
2
0.5
2
4
2
1.3900000000000001
2
2
8
4
3.0562499999999999
0
0
0
0
0
0
1
0
0
1
1
1
0
1
0
0
0
0
0
0
0
1
0
1
0

3
0
3
0
3
0.6
3
0.6
3
0.6
3
3
3
6.4
3.2
0.6
3
3
3
10
5
0.6
3
20
10
0.6
3
10
5
0.6
3
0.6
3
6.4
3.2
0.6
3
0.6
3
3
6.4
3.2
0.6
3
0.6
3
0.6
3
0.6
3
0.6
3
3.2
1.6
0.6
3
3
6.4
3.2
0.6
0
0
0
0
0
0
1
0
0
1
1
1
0
1
0
0
1
0
0
0
0
1
0
1
1

4
1
4
1
4
1
4
1
4
1
4
0
4
0
4
7.7600000000000007
3.8800000000000003
5
4
0
4
0
4
10
5
4
4
20
10
4
4
10
5
4
4
1
4
7.76
3.88
4
4
1
4
0
4
7.76
3.88
5
4
1
4
1
4
1
4
1
4
3.87
1.9350000000000001
4
4
0
4
7.7600000000000007
3.8800000000000003
4
0
0
0
0
0
0
1
0
0
1
1
1
0
1
0
0
1
0
0
0
0
1
0
1
1

5
25
5
25
5
5
5
5
5
5
50
25
5
5
5
5
5
5
5
5
5
5
2
1
5
5
5
5
5
5
5
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0

6
25
6
25
6
6.2
6
6.2
6
6.2
6
6
6
2.3199999999999998
6
6
6
2.59
6
2.59
6
2.59
6
6.2
6
2.59
6
6.2
6
6
2.3199999999999998
6
6.2
6
6.2
6
6.2
6
6.2
6
2.59
6
6
2.59
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
0.5
7
0.5
7
0.5
7
7
7
25
7
7
7
5
7
17
7
5
7
430
7
3.88
7
0.5
7
7
10.4
7
0.5
7
0.5
7
17
7
0.5
7
2
7
7
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

8
8
8
3.1
8
3.1
8
3.1
8
8
8
57.999999999999993
8
8
8
12.95
8
44.03
8
12.95
8
2666
8
10.049199999999999
8
3.1
8
8
24.128
8
3.1
8
3.1
8
105.4
8
3.1
8
5.18
8
8
10.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

9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1
1
1
0
0
5
0
0
4
3
4
0
4
1
0
4
1
1
0
1
4
0
4
2

1
1
1
0
1
0
1
0
0
0
0
0
5
0
0
0
0
0
4
0
4
1
4
0
1
1
4
0
1
0
0
0
5
1
1
0
1
0
1
1
1
0
4
0
0
0
4
0

0
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6

0
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6
0.6

1
1
1
1
5
4
4
4
1
4
1
5
1
1
1
1
4
4

1
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7

1
6.1977451171828228
6.1977451171828228
6.1977451171828228
2.3243027945588777
2.5852709561284608
2.5852709561284608
2.5852709561284608
6.1977451171828228
2.5852709561284608
6.1977451171828228
2.3243027945588777
6.1977451171828228
6.1977451171828228
6.1977451171828228
6.1977451171828228
2.5852709561284608
2.5852709561284608

1.388400997733763
7.9837491295123098
7.9837491295123098
7.9837491295123098
2.6129992079408582
2.9496311085685396
2.9496311085685396
2.9496311085685396
7.9837491295123098
2.9496311085685396
7.9837491295123098
2.6129992079408582
7.9837491295123098
7.9837491295123098
7.9837491295123098
7.9837491295123098
2.9496311085685396
2.9496311085685396

1
6.1977451171828228
6.1977451171828228
6.1977451171828228
2.3243027945588777
2.5852709561284608
2.5852709561284608
2.5852709561284608
6.1977451171828228
2.5852709561284608
6.1977451171828228
2.3243027945588777
6.1977451171828228
6.1977451171828228
6.1977451171828228
6.1977451171828228
2.5852709561284608
2.5852709561284608

1
6.2
6.2
6.2
2.3199999999999998
2.59
2.59
2.59
6.2
2.59
6.2
2.3199999999999998
6.2
6.2
6.2
6.2
2.59
2.59

Arial,Bold" 8REASONABLE POTENTIAL ANALYSIS - - ,

0.45

26.33
2.580704837665341

32
2.1331906109029743

48
1.4323117203141844

48
1.4323117203141844

201
0.34581489606960919

13174.695340501792

150
340

1
0
3.1
7031.7204301075262

2
10
2891.7204301075267

3
2518.6917562724011

6.5
65
1
0
3.1

304.7078853046595

4
125.53205192504855

0.58987911307921359
3.2396117368502959
1
0
3.1

27.652433404885425

5

230
0
0

10781.971326164874

6

1
0
0

69.817204301075279

7

300
5
0
57.999999999999993

20945.161290322583

8
35071.108196691348

117.73254526741752
905.0817858548595
0
0

5519.0822923030601

9
619.98566308243721

11
16
0
0

515.65949820788524

10

4
0
12.95

11
405.78037092934903

7.8806391707256838
10.471993662870075
4
1
44.03

369.42967639398285

12
852.4802867383512

5
22
10
4
0
12.95

234.39068100358421

13

1800
1
1
2666

84380.645161290318

14
2925.0576405033571

2.94162407165387
75.48710403296981
4
0
10.049199999999999

137.89785388229734

15

12
0.5
1
0
3.1

562.53763440860212

16

2000
0
0

93756.272401433685

17
12989.036609210396

37.231337220463082
335.20869614001487

5
1
24.128
1745.3356971556868

18

25
1171.9534050179211

19
2169.9498207885304

5
56
1
0
3.1

234.39068100358421

20
11.48515257471192

0.06
0.29639788810883599
1
0
3.1

2.8126881720430106

21
4870.9643120333731

126.73347513150829
125.70521164159754
1
1
105.4

5941.0291084050068

22

21
1
0
3.1

984.4408602150537

23

60
4
0
5.18

2812.6881720430106

24

0.95
0
0

274.71344086021503

25

0.03
4
0
10.36

8.6751612903225812

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

9/7/2017

32
20.64516129032258
16.987096774193546
0.45
25
25.000000000000004
2.1331906109029743
2.580704837665341
25
25

25
25.000000000000004

25
25

0.14894186714057803
0.81798763542966524
0.25249557720918481
0.58987911307921359
3.2396117368502959

0.14894186714057803
0.50864341996156748
0.25249557720918481
0.58987911307921359
2.0144646713560932

23.813113368978001
183.06590693171381
0.20226449122363688
117.73254526741752
905.0817858548595

11
16
1
11
16

2.7393136541333787
3.6400696193855389
0.34760044138413848
7.8806391707256838
10.471993662870075

0.54096834392178628
13.88217279348274
0.18390125003894109
2.94162407165387
75.48710403296981

16.095897708649439
144.91783768523806
0.43232123555859853
37.231337220463082
335.20869614001487

25

0.06
0.29639788810883599
1
0.06
0.29639788810883599

36.497894063420418
36.201765105502218
0.28798937317506229
126.73347513150829
125.70521164159754

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
Applied Standard
PAR #
NO WQS
HH/WS
Total Phenolic Compounds
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
US EPA
Translators
- using Default Partition Coefficients (streams)
[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 wflow values for </t></r><r><rPr><b/><sz val="10"/><rFont val="Arial"/><family val="2"/></rPr><t>"7Q10s (cfs)
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:<
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
Chlorinated Phenolic Compounds
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 =
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 % .
8/30/16:
Revised conditional note statement on RPA tab for Total Chromium to correct program error.
10/20/16:
Revised label display for Fcailty discripition on "Diss to Total Metal Calculator".sheet to list Outfall #.
a: No monitoring required if all Total Chromium samples are < 5 µg/L or Pred. max for Total Cr is < allowable Cw for Cr VI.
b: Maintain Total Chromium monitoring or defer to LMTP if any Total Chromium sample is ≥ 50% of but < the Chromium VI Allowable Cw.
c: Monitor Total Chromium and Chromium VI, along with a limit for Chromium VI if any Total Chromium sample is  > the Chromium VI Allowable Cw but < the Chromium III Allowable Cw.
d: Limit both Chromium III and Chromium VI when any Total Chromium sample is ≥ the Chromium III Allowable Cw. Monitor for Total Chromium and Chromium VI, report the calculated Chromium
III.
Revised chromium drop down to reflect new < 5ug/L PQL.
11/21/17:
(2) Revised RPA evaluation to always calculate and display "Max Pred Cw" value whenever there are 1 to 58 data numerical entties made (see data and rpa pages).
(3) Revised rpa page to show each parameters automatic display message "NO DETECTS" independent from "Max Pred Cw" display
(4) Revised Total Chromium < 50 data counter to start count when the entered data point < 4.9999. (hidden column of data page). Revised Total Chromium automatic diplay message on rpa
page to reflect new 5 µg/l criteria.
(1) Revised RPA evaluation to assign C.V. (default) = 0.6 when only a sinlgle data entry inade for any parameter (see data page). On data page the parameter will diplay Std..Dev. = "N/A"
when only a single data entry made.
11/20/17 Chlorides still listed as have action levels but will be coorected at next EPA review
password all sheets = rpa2017
TYPE
11/29/17:
C.V. (default? Message to
(1) Revised RPA page C.V. (default) message function to link to DATA paget
(2) Corrected DATA page H2 message to show … UPSTREAM…
(3) Removed (1) from RPA page Type label
Total Metal Criteria
Total Metal
=
Dissolved Metal ÷ Translator
Dissolved Metals Criteria
after applying hardness equation
11/30/17:
Revised Dissolved Metals and Total Metals Table label descriptions on "DSS to Total Metal Calculator" tab so as not to conflict with exsiting descriptions in RPA
12/12/17:
Revised conditional statements DATA tab to allow appllication C.V. (default) for number of data values 1 to 9 even if no deviation in data set.
1/20/18:
1) Revised "RPA" Receiving Stream display to only show the Stream name and if entered the HUC number

2) Increased RPA page Qw display decimal places
Chlorodibromomethane
Chloroform
Dichlorobromomethane
Bis(2--ethylhexyl) phthalate
no limit
add limit
Ticona Facility
II
NC0004952
Buffalo Creek
001

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

DEFINE
DEFINE

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

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

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

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Pal 1
Copper
Date Data BDL=1/2DL Results
1 17 17 Std Dev.
2 < 10 5 Mean
3 < 20 10 C.V. (default)
4 < 20 10 n
5
6 Mult Factor =
fag/L 7 Max. Value
fag/L 8 Max. Pred Cw
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par12
Cyanide
4.9329
10.5000
0.6000
4
2.59
17.00 ug/L
44.03 ug/L
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
Date Data BDL=1/2DL Results
1 < 1 5 Std Dev. 0.0000
2 < 5 5 Mean 5.00
3 < 10 5 C.V. (default) 0.6000
4 < 10 5 n 4
5
6 Mult Factor = 2.59
7 Max. Value 5.0
8 Max. Pred Cw 13.0
NC0004952_Worksheets_20210625 (4), data
- 9 - 6/25/2021

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par13
Fluoride
Date Data BDL=1/2DL Results
1 430 430 Std Dev.
2 Mean
3 C.V. (default)
4 n
5
6 Mult Factor =
ug/L 7 Max. Value
ug/L 8 Max. Pred Cw
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par14
Lead
N/A
430.0000
0.6000
1
6.20
430.0 ug/L
2666.0 ug/L
Date
< 0.64
< 4
< 6.4
< 7.76
BDL=1/2DL Results
0.32 Std Dev.
2 Mean
3.2 C.V. (default)
3.88 n
Mult Factor =
Max. Value
Max. Pred Cw
Use "PASTE SF
Values" then "I
. Maximum c
points = 5
1.5606
2.3500
0.6000
4
2.59
3.880
10.049
NC0004952_Worksheets_20210625 (4), data
- 10 - 6/25/2021

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

REASONABLE POTENTIAL ANALYSIS
'ECIAL•
COPY"
lata
;8
Par17 & Par18
Nickel
Date Data BDL=1/2DL Results
1 < 1.23 0.615 Std Dev.
2 10.4 10.4 Mean
3 < 6.4 3.2 C.V. (default)
4 < 7.76 3.88 n
5 < 2 1
6 Mult Factor =
ug/L 7 Max. Value
ug/L 8 Max. Pred Cw
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
Use "PASTE SPECIAL• Par19
Values" then "COPY"
. Maximum data
points = 58
Selenium
3.9341
3.8190
0.6000
5
2.32
10.4 fag/L
24.1 fag/L
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev.
2 Mean
3 C.V. (default)
4 n
5
6 Mult Factor =
7 Max. Value
8 Max. Pred Cw
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
NC0004952_Worksheets_20210625 (4), data
- 12 - 6/25/2021

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

REASONABLE POTENTIAL ANALYSIS
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par22
Chlorodibromomethane
N/A
17.0000
0.6000
1
6.20
17.0 ug/L
105.4 ug/L
Date Data BDL=1/2DL Results
1 < 1 0.5 Std Dev.
2 Mean
3 C.V. (default)
4 n
5
6 Mult Factor =
7 Max. Value
8 Max. Pred Cw
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par23
Chloroform
N/A
0.5000
0.6000
1
6.20
0.500000 fag/L
3.100000 fag/L
Date Data BDL=1/2DL
1 < 0.05 0.025
2 < 4 2
3 < 3.2 1.6
4 < 3.87 1.935
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
NC0004952_Worksheets_20210625 (4), data
- 14 - 6/25/2021

REASONABLE POTENTIAL ANALYSIS
Results
Std Dev.
Mean
C.V. (default)
n
Mult Factor =
Max. Value
Max. Pred Cw
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
Par24
Dichlorobromomethane
0.9267
1.3900
0.6000
4
2.59
2.000000 fag/L
5.180000 fag/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
Par25
Bis(2--ethylhexyl) r
NO DATA
NO DATA
NO DATA
0
N/A
N/A fag/L
N/A fag/L
Date Data
< 2.29
< 8
< 6.4
< 7.76
BDL=1/2DL
1.145
4
3.2
3.88
NC0004952_Worksheets_20210625 (4), data
- 15 - 6/25/2021

REASONABLE POTENTIAL ANALYSIS
)hthalate
Results
Std Dev.
Mean
C.V. (default)
n
Use "PASTE SPECIAL•
Values" then "COPY"
. Maximum data
points = 58
1.3220
3.0563
0.6000
4
Mult Factor = 2.59
Max. Value 4.000000 fag/L
Max. Pred Cw 10.360000 fag/L
NC0004952_Worksheets_20210625 (4), data
- 16 - 6/25/2021

Ticona Facility
N C0004952
Freshwater RPA -
Qw (MGD) = 0.4500
1 Q 10S (cfs) = 26.33
7Q 1 OS (cfs) = 32.00
7Q1OW (cfs) = 48.00
30Q2 (cfs) = 48.00
Avg. Stream Flow, QA (cfs) = 201.00
Receiving Stream: Buffalo Creek
95% Probability/95% Confidence Using Metal Translators
MAXIMUM DATA POINTS = 58
WWTP/WTP Class: II
IWC% @ 1 Q 10S = 2.580704838
IWC% @ 7Q 10S = 2.133190611
IWC% @ 7Q1OW = 1.43231172
IWC% @ 30Q2 = 1.43231172
IW%C @ QA = 0.345814896
Stream Class: C
Outfall 001
Qw = 0.45 MGD
COMBINED HARDNESS (mg/L)
Acute = 25 mg/L
Chronic = 25 mg/L
YOU HAVE DESIGNATED THIS RECEIVING
STREAM AS WATER SUPPLY
Effluent Hard: 0 value > 100 mg/L
Effluent Hard Avg = 25 mg/L
PARAMETER
TYPE
NC STANDARDS OR EPA CRITERIA
_1
a
REASONABLE POTENTIAL RESULTS
RECOMMENDED ACTION
Chronic Applied Acute
Standard
11 # Det. Max Pred Cw Allowable Cw
Arsenic
Arsenic
C
C
150 FW(7Q10s) 340
10 FIH/WS(Qavg)
ug/L
ug/L
1 0
Note: n < 9
Limited data set
3.1
C.V. (default)
NO DETECTS
Acute (FW): 13,174.7
_ _ _ __ _ _ _____________________________
Chronic (FW): 7,031.7
Max MDL =1 __ _ _ _____________________________
Chronic (HH): 2,891.7
Max MDL = 1
no limit
Beryllium
NC
6.5 FW(7Q10s) 65
ug/L
1 0
Note: n < 9
Limited data set
3.10
C.V. (default)
NO DETECTS
Acute: 2,518.69
Chronic: 304.71
Max MDL = 1
no limit
Cadmium
NC
0.5899 FW(7Q10s) 3.2396
ug/L
1 0
Note: n < 9
Limited data set
3.100
C.V. (default)
NO DETECTS
Acute: 125.532
___
Chronic: 27.652
Max MDL = 1
no limit
Chlorides
NC
230 FW(7Q10s)
mg/L
0 0
N/A
Acute: NO WQS
-- _Chr_ _ onic:----10,782.0_ ----------------------------
N/A
Chlorinated Phenolic Compounds
NC
1 A(30Q2)
ug/L
0 0
N/A
Acute: NO WQS
_ _
-- Chronic:----- 698------------------------------
N/A
Total Phenolic Compounds
NC
300 A(30Q2)
ug/L
5 0
Note: n < 9
Limited data set
58.0
C.V. (default)
NO DETECTS
Acute: NO WQS
Chronic: 20,945.2
Max MDL = 50
no limit
Chromium III
NC
117.7325 FW(7Q10s) 905.0818
µg/L
0 0
N/A
Acute: 35,071.1
-- _
Chr_onic:----5_,519.1-----------------------------
no limit
Chromium VI
NC
11 FW(7Q10s) 16
µg/L
0 0
N/A
Acute: 620.0
-- _Chr_ onic:----- _ 515_.7------------------------------
no limit
Chromium, Total
NC
µg/L
4 0
Note: n < 9
Limited data set
13.0
C.V. (default)
NO DETECTS
Max reported value = 5
Max MDL = 10
Page 17 of 26
NC0004952_Worksheets_20210625 (4), rpa
6/25/2021

Ticona Facility
N C0004952
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall 001
Qw = 0.45 MGD
Copper
NC
7.8806
FW(7Q10s)
10.4720
ug/L
4 1
Note: n < 9
Limited data set
44.03
C.V. (default)
Acute: 405.78
_ _ _ _ _ _ _ _ _ _ _ _ _ _
Chronic: 369.43
No value > Allowable Cw
no limit
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Cyanide
NC
5
FW(7Q10s)
22
10
ug/L
4 0
Note: n < 9
Limited data set
13.0
C.V. (default)
NO DETECTS
Acute: 852.5
___ _ ______ _______________________________
Chronic: 234.4
Max MDL = 10
no limit
Fluoride
NC
1800
FW(7Q10s)
ug/L
1 1
Note: n < 9
Limited data set
2,666.0
C.V. (default)
Acute: NO WQS
_ _ _ _ _ _ _ _ _ _ _ _ _
Chronic: 84,380.6
No value > Allowable Cw
no limit
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Lead
NC
2.9416
FW(7Q10s)
75.4871
ug/L
4 0
Note: n < 9
Limited data set
10.049
C.V. (default)
NO DETECTS
Acute: 2,925.058
_ _ _ _ _ _ _ _ _ _ _ _ _
Chronic: 137.898
Max MDL = 7.76
no limit
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Mercury
NC
12
FW(7Q10s)
0.5
ng/L
1 0
Note: n < 9
Limited data set
3.1
C.V. (default)
NO DETECTS
Acute: NO WQS
___ _ ______ _______________________________
Chronic: 562.5
Max MDL = 1
no limit
Molybdenum
NC
2000
HH(7Q10s)
ug/L
0 0
N/A
Acute: NO WQS
onic:----93,756.3-----------------------------
-- _Chr_
N/A
Nickel
Nickel
NC
NC
37.2313
25.0000
FW(7Q10s)
WS(7Q10s)
335.2087
µg/L
µg/L
5 1
Note: n < 9
Limited data set
24.1
C.V. (default)
Acute (FW): 12,989.0
_ ____ _ _____________________________
Chronic (FW): 1,745.3
No value > Allowable Cw _ _
Chronic (WS): 1,172.0
No value > Allowable Cw
no limit
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Selenium
NC
5
FW(7Q10s)
56
ug/L
1 0
Note: n < 9
Limited data set
3.1
C.V. (default)
NO DETECTS
Acute: 2,169.9
___Chr_ ______ _______________________________
onic: 234.4
Max MDL = 1
no limit
Silver
NC
0.06
FW(7Q10s)
0.2964
ug/L
1 0
Note: n < 9
Limited data set
3.100
C.V. (default)
NO DETECTS
Acute: 11.485
___ _ _______ _______________________________
Chronic: 2.813
Max MDL = 1
add limit
Zinc
NC
126.7335
FW(7Q10s)
125.7052
ug/L
1 1
Note: n < 9
Limited data set
105.4
C.V. (default)
Acute: 4,871.0
_ _ _ _ _ _ _ _ _ _ _ ___
Chronic: 5,941.0
No value > Allowable Cw
im
no_l_it________________________
Chlorodibromomethane
NC
21
FW(7Q10s)
µg/L
1 0
Note: n < 9
Limited data set
3.10000
C.V. (default)
NO DETECTS
Acute: NO WQS
___ _ _____ _ _ _____________________________�
Chronic: 984.44086
Max MDL = 1
no limit
Chloroform
NC
60
WS(7Q10s)
µg/L
4 0
Note: n < 9
Limited data set
5.18000
C.V. (default)
NO DETECTS
Acute: NO WQS
___ _ _____ _ _ _____________________________
Chronic: 2812.68817
Max MDL = 4
no limit
Acute: NO WQS
,„A
Page 18 of 26
NC0004952_Worksheets_20210625 (4), rpa
6/25/2021

Ticona Facility
N C0004952
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall 001
Qw = 0.45 MGD
Dichlorobromomethane
C
0.95 WS(Qavg)
g/L
µ
0 0
N/A
_ _ _ _ _ _
-- --- ---------------------------- Chronic: 274.71344
1 Y/rl
Bis(2--ethylhexyl) phthalate
C
0.03 WS(Qavg)
µg/L
4 0
Note: n < 9
Limited data set
10.36000
C.V. (default)
NO DETECTS
Acute: NO WQS
___ _ ____ _ _ _____________________________
Chronic: 8.67516
Max MDL = 8
add limit
Page 19 of 26
NC0004952_Worksheets_20210625 (4), rpa
6/25/2021

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

Reasonable Potential Multiplying Factors - Calculator
95.0%
95.0%
Confidence Level
Upper Boundary of the Effluent Distribution (Percentile Value Not To Exceed)
Coefficient of Variation
Coefficient of Variation
Coefficient of Variation
n
0.0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1.0
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2.0
2.1
2.2
2.3
2.4
2.5 2.6
2.7
2.8
2.9
3.0 3.1
3.2
3.3
3.4
3.5 3.6
3.7
3.8
3.9
4.0 4.1
4.2
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
1
1.00
1.39
1.92
2.63
3.55
4.73
6.20
7.98
####
12.60
15.47
18.72
22.35
26.38
30.78
35.57
40.73
46.26
52.14
58.37
64.94
71.84
79.06
86.58
94.41
102.53
#####
119.62
128.56
137.76
147.21
156.91
166.84
177.00
187.38
197.98
208.78
219.79
231.00
242.40
253.99
265.76
277.71
289.83
302.12
314.57
327.19
339.96
352.88
365.95
379.1
,92.53
406.03
419.66
433.43
447.33
461.35
475.50
489.76
504.15
518.65
533.27
1
2
1.00
1.27
1.61
2.03
2.53
3.11
3.79
4.57
5.43
6.38
7.41
8.51
9.69
10.94
12.25
13.61
15.03
16.49
18.00
19.55
21.14
22.75
24.40
26.08
27.79
29.51
31.26
33.03
34.82
36.63
38.45
40.28
42.13
43.99
45.86
47.74
49.64
51.54
53.44
55.36
57.28
59.21
61.15
63.09
65.03
66.98
68.93
70.89
72.85
74.81
76.71
78.75
80.72
82.69
84.67
86.64
88.62
90.60
92.58
94.56
96.54
98.52
2
3
1.00
1.22
1.48
1.79
2.15
2.55
3.00
3.49
4.03
4.60
5.20
5.84
6.49
7.17
7.87
8.59
9.32
10.06
10.81
11.58
12.34
13.12
13.90
14.68
15.46
16.25
17.04
17.83
18.62
19.41
20.21
21.00
21.79
22.58
23.36
24.15
24.94
25.72
26.50
27.28
28.06
28.84
29.61
30.38
31.15
31.92
32.68
33.44
34.20
34.96
35.7:
36.47
37.22
37.97
38.71
39.46
40.20
40.93
41.67
42.40
43.13
43.86
3
4
1.00
1.19
1.40
1.65
1.93
2.25
2.59
2.95
3.34
3.74
4.16
4.60
5.04
5.50
5.96
6.42
6.89
7.36
7.84
8.31
8.79
9.26
9.73
10.20
10.68
11.14
11.61
12.07
12.54
13.00
13.45
13.91
14.36
14.81
15.25
15.70
16.14
16.58
17.01
17.44
17.87
18.30
18.72
19.14
19.56
19.98
20.39
20.80
21.21
21.61
22.02
22.42
22.82
23.21
23.61
24.00
24.39
24.77
25.16
25.54
25.92
26.30
4
5
1.00
1.16
1.35
1.56
1.80
2.05
2.32
2.61
2.91
3.23
3.55
3.87
4.21
4.54
4.88
5.21
5.55
5.89
6.22
6.56
6.89
7.22
7.54
7.87
8.19
8.51
8.82
9.13
9.44
9.75
10.05
10.36
10.65
10.95
11.24
11.53
11.82
12.10
12.38
12.66
12.94
13.21
13.48
13.75
14.02
14.28
14.55
14.81
15.06
15.32
15.57
15.82
16.07
16.32
16.56
16.81
17.05
17.29
17.53
17.76
18.00
18.23
5
6
1.00
1.15
1.31
1.50
1.70
1.91
2.14
2.38
2.63
2.88
3.14
3.40
3.66
3.92
4.18
4.44
4.70
4.96
5.21
5.46
5.71
5.96
6.20
6.44
6.68
6.91
7.14
7.37
7.60
7.82
8.04
8.25
8.47
8.68
8.89
9.10
9.30
9.50
9.70
9.90
10.09
10.29
10.48
10.66
10.85
11.04
11.22
11.40
11.58
11.76
11.93
12.10
12.28
12.45
12.62
12.78
12.95
13.11
13.28
13.44
13.60
13.76
6
7
1.00
1.13
1.28
1.45
1.62
1.81
2.01
2.21
2.42
2.63
2.84
3.06
3.27
3.48
3.69
3.90
4.11
4.32
4.52
4.72
4.91
5.10
5.29
5.48
5.67
5.85
6.02
6.20
6.37
6.54
6.71
6.88
7.04
7.20
7.36
7.51
7.67
7.82
7.97
8.12
8.26
8.41
8.55
8.69
8.83
8.96
9.10
9.23
9.37
9.50
9.63
9.75
9.88
10.01
10.13
10.25
10.37
10.49
10.61
10.73
10.85
10.96
7
8
1.00
1.12
1.26
1.40
1.56
1.73
1.90
2.07
2.25
2.44
2.62
2.80
2.98
3.16
3.33
3.51
3.68
3.85
4.01
4.17
4.33
4.49
4.64
4.79
4.94
5.09
5.23
5.37
5.51
5.64
5.78
5.91
6.03
6.16
6.29
6.41
6.53
6.65
6.77
6.88
6.99
7.11
7.22
7.33
7.43
7.54
7.65
7.75
7.85
7.95
8.05
8.15
8.25
8.34
8.44
8.53
8.63
8.72
8.81
8.90
8.99
9.08
8
9
1.00
1.11
1.24
1.37
1.51
1.6`
1.81
1.97
2.12
2.28
2.44
2.60
2.75
2.90
3.05
3.20
3.34
3.49
3.62
3.76
3.89
4.02
4.15
4.27
4.40
4.52
4.63
4.75
4.86
4.97
5.08
5.19
5.29
5.40
5.50
5.60
5.69
5.79
5.88
5.98
6.07
6.16
6.25
6.34
6.42
6.51
6.59
6.67
6.76
6.84
6.91
6.99
7.07
7.15
7.22
7.30
7.37
7.44
7.52
7.59
7.66
7.73
9
10
1.00
1.10
1.22
1.34
1.47
1.60
1.74
1.88
2.02
2.16
2.30
2.43
2.57
2.70
2.83
2.95
3.08
3.20
3.32
3.43
3.55
3.66
3.77
3.87
3.97
4.07
4.17
4.27
4.36
4.46
4.55
4.64
4.72
4.81
4.89
4.97
5.06
5.13
5.21
5.29
5.36
5.44
5.51
5.58
5.65
5.72
5.79
5.86
5.93
5.99
6.06
6.12
6.19
6.25
6.31
6.37
6.43
6.49
6.55
6.61
6.66
6.72
10
11
1.00
1.10
1.20
1.32
1.43
1.55
1.68
1.80
1.93
2.05
2.18
2.30
2.41
2.53
2.64
2.75
2.86
2.97
3.07
3.17
3.27
3.36
3.46
3.55
3.63
3.72
3.80
3.89
3.97
4.05
4.12
4.20
4.27
4.34
4.41
4.48
4.55
4.62
4.68
4.75
4.81
4.87
4.94
5.00
5.05
5.11
5.17
5.23
5.28
5.34
5.39
5.44
5.50
5.55
5.60
5.65
5.70
5.75
5.80
5.85
5.89
5.94
11
12
1.00
1.09
1.19
1.29
1.40
1.51
1.63
1.74
1.85
1.96
2.07
2.18
2.29
2.39
2.49
2.59
2.68
2.78
2.87
2.95
3.04
3.12
3.20
3.28
3.36
3.43
3.50
3.57
3.64
3.71
3.78
3.84
3.90
3.97
4.03
4.09
4.15
4.20
4.26
4.31
4.37
4.42
4.47
4.52
4.57
4.62
4.67
4.72
4.77
4.81
4.86
4.90
4.95
4.99
5.03
5.08
5.12
5.16
5.20
5.24
5.28
5.32
12
13
1.00
1.09
1.18
1.27
1.37
1.48
1.58
1.68
1.79
1.89
1.99
2.08
2.18
2.27
2.36
2.45
2.53
2.61
2.69
2.77
2.84
2.92
2.99
3.06
3.12
3.19
3.25
3.31
3.37
3.43
3.49
3.55
3.60
3.66
3.71
3.76
3.81
3.86
3.91
3.96
4.00
4.05
4.09
4.14
4.18
4.22
4.26
4.30
4.35
4.38
4.42
4.46
4.50
4.54
4.57
4.61
4.65
4.68
4.72
4.75
4.78
4.82
13
14
1.00
1.08
1.17
1.26
1.35
1.44
1.54
1.63
1.73
1.82
1.91
2.00
2.08
2.17
2.25
2.32
2.40
2.47
2.54
2.61
2.68
2.74
2.81
2.87
2.93
2.98
3.04
3.09
3.15
3.20
3.25
3.30
3.35
3.39
3.44
3.48
3.53
3.57
3.61
3.66
3.70
3.74
3.77
3.81
3.85
3.89
3.92
3.96
3.99
4.03
4.06
4.10
4.13
4.16
4.19
4.22
4.26
4.29
4.32
4.35
4.37
4.40
14
15
1.00
1.08
1.16
1.24
1.33
1.41
1.50
1.59
1.68
1.76
1.84
1.92
2.00
2.07
2.15
2.22
2.29
2.35
2.41
2.48
2.54
2.59
2.65
2.70
2.76
2.81
2.86
2.91
2.95
3.00
3.04
3.09
3.13
3.17
3.21
3.25
3.29
3.33
3.36
3.40
3.44
3.47
3.51
3.54
3.57
3.60
3.64
3.67
3.70
3.73
3.76
3.79
3.82
3.84
3.87
3.90
3.93
3.95
3.98
4.00
4.03
4.05
15
16
1.00
1.07
1.15
1.23
1.31
1.39
1.47
1.55
1.63
1.71
1.78
1.85
1.93
1.99
2.06
2.12
2.19
2.24
2.30
2.36
2.41
2.46
2.51
2.56
2.61
2.65
2.70
2.74
2.78
2.83
2.86
2.90
2.94
2.98
3.01
3.05
3.08
3.12
3.15
3.18
3.21
3.24
3.28
3.30
3.33
3.36
3.39
3.42
3.44
3.47
3.50
3.52
3.55
3.57
3.60
3.62
3.65
3.67
3.69
3.71
3.74
3.76
16
17
1.00
1.07
1.14
1.21
1.29
1.36
1.44
1.51
1.59
1.66
1.73
1.79
1.86
1.92
1.98
2.04
2.10
2.15
2.20
2.25
2.30
2.35
2.39
2.44
2.48
2.52
2.56
2.60
2.64
2.67
2.71
2.74
2.78
2.81
2.84
2.87
2.90
2.93
2.96
2.99
3.02
3.05
3.08
3.10
3.13
3.15
3.18
3.20
3.23
3.25
3.27
3.30
3.32
3.34
3.36
3.38
3.40
3.42
3.44
3.46
3.48
3.50
17
18
1.00
1.06
1.13
1.20
1.27
1.34
1.41
1.48
1.55
1.62
1.68
1.74
1.80
1.86
1.91
1.97
2.02
2.07
2.11
2.16
2.20
2.25
2.29
2.33
2.36
2.40
2.44
2.47
2.51
2.54
2.57
2.60
2.63
2.66
2.69
2.72
2.75
2.77
2.80
2.83
2.85
2.88
2.90
2.92
2.95
2.97
2.99
3.01
3.03
3.06
3.08
3.10
3.12
3.14
3.16
3.17
3.19
3.21
3.23
3.25
3.26
3.28
18
19
1.00
1.06
1.12
1.19
1.26
1.32
1.39
1.45
1.51
1.58
1.64
1.69
1.75
1.80
1.85
1.90
1.95
1.99
2.03
2.08
2.12
2.15
2.19
2.23
2.26
2.30
2.33
2.36
2.39
2.42
2.45
2.48
2.51
2.53
2.56
2.58
2.61
2.63
2.66
2.68
2.70
2.72
2.75
2.77
2.79
2.81
2.83
2.85
2.87
2.89
2.90
2.92
2.94
2.96
2.97
2.99
3.01
3.02
3.04
3.06
3.07
3.09
19
20
1.00
1.06
1.12
1.18
1.24
1.30
1.36
1.42
1.48
1.54
1.59
1.65
1.70
1.75
1.79
1.84
1.88
1.92
1.96
2.00
2.04
2.07
2.11
2.14
2.17
2.20
2.23
2.26
2.29
2.31
2.34
2.37
2.39
2.42
2.44
2.46
2.48
2.51
2.53
2.55
2.57
2.59
2.61
2.63
2.65
2.66
2.68
2.70
2.72
2.73
2.75
2.77
2.78
2.80
2.81
2.83
2.84
2.86
2.87
2.89
2.90
2.91
20
21
1.00
1.05
1.11
1.17
1.23
1.29
1.34
1.40
1.45
1.51
1.56
1.61
1.65
1.70
1.74
1.78
1.82
1.86
1.90
1.93
1.96
2.00
2.03
2.06
2.09
2.12
2.14
2.17
2.19
2.22
2.24
2.27
2.29
2.31
2.33
2.35
2.37
2.39
2.41
2.43
2.45
2.47
2.49
2.50
2.52
2.54
2.55
2.57
2.58
2.60
2.61
2.63
2.64
2.66
2.67
2.68
2.70
2.71
2.72
2.74
2.75
2.76
21
22
1.00
1.05
1.11
1.16
1.22
1.27
1.32
1.38
1.43
1.48
1.52
1.57
1.61
1.65
1.69
1.73
1.77
1.80
1.84
1.87
1.90
1.93
1.96
1.99
2.01
2.04
2.06
2.09
2.11
2.13
2.15
2.18
2.20
2.22
2.24
2.25
2.27
2.29
2.31
2.33
2.34
2.36
2.37
2.39
2.41
2.42
2.44
2.45
2.46
2.48
2.49
2.50
2.52
2.53
2.54
2.56
2.57
2.58
2.59
2.60
2.61
2.63
22
23
1.00
1.05
1.10
1.15
1.20
1.25
1.31
1.35
1.40
1.45
1.49
1.53
1.57
1.61
1.65
1.68
1.72
1.75
1.78
1.81
1.84
1.87
1.89
1.92
1.94
1.97
1.99
2.01
2.03
2.05
2.07
2.09
2.11
2.13
2.15
2.16
2.18
2.20
2.21
2.23
2.24
2.26
2.27
2.29
2.30
2.32
2.33
2.34
2.36
2.37
2.38
2.39
2.40
2.42
2.43
2.44
2.45
2.46
2.47
2.48
2.49
2.50
23
24
1.00
1.05
1.09
1.14
1.19
1.24
1.29
1.33
1.38
1.42
1.46
1.50
1.54
1.57
1.61
1.64
1.67
1.70
1.73
1.76
1.78
1.81
1.83
1.86
1.88
1.90
1.92
1.94
1.96
1.98
2.00
2.02
2.03
2.05
2.07
2.08
2.10
2.11
2.13
2.14
2.16
2.17
2.18
2.20
2.21
2.22
2.23
2.25
2.26
2.27
2.28
2.29
2.30
2.31
2.32
2.33
2.34
2.35
2.36
2.37
2.38
2.39
24
25
1.00
1.04
1.09
1.14
1.18
1.23
1.27
1.32
1.36
1.40
1.43
1.47
1.51
1.54
1.57
1.60
1.63
1.66
1.68
1.71
1.73
1.76
1.78
1.80
1.82
1.84
1.86
1.88
1.90
1.91
1.93
1.95
1.96
1.98
1.99
2.01
2.02
2.04
2.05
2.06
2.08
2.09
2.10
2.11
2.12
2.13
2.15
2.16
2.17
2.18
2.19
2.20
2.21
2.22
2.23
2.24
2.25
2.25
2.26
2.27
2.28
2.29
25
26
1.00
1.04
1.09
1.13
1.17
1.21
1.26
1.30
1.34
1.37
1.41
1.44
1.48
1.51
1.54
1.56
1.59
1.62
1.64
1.66
1.69
1.71
1.73
1.75
1.77
1.79
1.80
1.82
1.84
1.85
1.87
1.88
1.90
1.91
1.93
1.94
1.95
1.97
1.98
1.99
2.00
2.01
2.02
2.03
2.04
2.06
2.07
2.08
2.09
2.09
2.10
2.11
2.12
2.13
2.14
2.15
2.16
2.16
2.17
2.18
2.19
2.20
26
27
1.00
1.04
1.08
1.12
1.16
1.20
1.24
1.28
1.32
1.35
1.39
1.42
1.45
1.48
1.50
1.53
1.55
1.58
1.60
1.62
1.64
1.66
1.68
1.70
1.72
1.73
1.75
1.77
1.78
1.80
1.81
1.82
1.84
1.85
1.86
1.88
1.89
1.90
1.91
1.92
1.93
1.94
1.95
1.96
1.97
1.98
1.99
2.00
2.01
2.02
2.03
2.04
2.04
2.05
2.06
2.07
2.07
2.08
2.09
2.10
2.10
2.11
27
28
1.00
1.04
1.08
1.12
1.15
1.19
1.23
1.26
1.30
1.33
1.36
1.39
1.42
1.45
1.47
1.50
1.52
1.54
1.56
1.58
1.60
1.62
1.64
1.66
1.67
1.69
1.70
1.72
1.73
1.74
1.76
1.77
1.78
1.79
1.81
1.82
1.83
1.84
1.85
1.86
1.87
1.88
1.89
1.90
1.91
1.91
1.92
1.93
1.94
1.95
1.96
1.96
1.97
1.98
1.99
1.99
2.00
2.01
2.01
2.02
2.03
2.03
28
29
1.00
1.04
1.07
1.11
1.15
1.18
1.22
1.25
1.28
1.31
1.34
1.37
1.40
1.42
1.44
1.47
1.49
1.51
1.53
1.55
1.56
1.58
1.60
1.61
1.63
1.64
1.66
1.67
1.68
1.70
1.71
1.72
1.73
1.74
1.75
1.76
1.77
1.78
1.79
1.80
1.81
1.82
1.83
1.84
1.84
1.85
1.86
1.87
1.88
1.88
1.89
1.90
1.90
1.91
1.92
1.92
1.93
1.94
1.94
1.95
1.95
1.96
29
30
1.00
1.03
1.07
1.10
1.14
1.17
1.20
1.24
1.27
1.29
1.32
1.35
1.37
1.39
1.42
1.44
1.46
1.48
1.49
1.51
1.53
1.54
1.56
1.57
1.59
1.60
1.61
1.63
1.64
1.65
1.66
1.67
1.68
1.69
1.70
1.71
1.72
1.73
1.74
1.75
1.76
1.76
1.77
1.78
1.79
1.79
1.80
1.81
1.82
1.82
1.83
1.84
1.84
1.85
1.85
1.86
1.87
1.87
1.88
1.88
1.89
1.89
30
31
1.00
1.03
1.06
1.10
1.13
1.16
1.19
1.22
1.25
1.28
1.30
1.33
1.35
1.37
1.39
1.41
1.43
1.45
1.46
1.48
1.50
1.51
1.52
1.54
1.55
1.56
1.57
1.59
1.60
1.61
1.62
1.63
1.64
1.65
1.66
1.66
1.67
1.68
1.69
1.70
1.71
1.71
1.72
1.73
1.73
1.74
1.75
1.75
1.76
1.77
1.77
1.78
1.78
1.79
1.80
1.80
1.81
1.81
1.82
1.82
1.83
1.83
31
32
1.00
1.03
1.06
1.09
1.12
1.15
1.18
1.21
1.24
1.26
1.28
1.31
1.33
1.35
1.37
1.39
1.40
1.42
1.43
1.45
1.46
1.48
1.49
1.50
1.51
1.53
1.54
1.55
1.56
1.57
1.58
1.59
1.60
1.60
1.61
1.62
1.63
1.64
1.64
1.65
1.66
1.66
1.67
1.68
1.68
1.69
1.70
1.70
1.71
1.71
1.72
1.72
1.73
1.74
1.74
1.75
1.75
1.76
1.76
1.76
1.77
1.77
32
33
1.00
1.03
1.06
1.09
1.12
1.14
1.17
1.20
1.22
1.24
1.27
1.29
1.31
1.33
1.34
1.36
1.38
1.39
1.41
1.42
1.43
1.45
1.46
1.47
1.48
1.49
1.50
1.51
1.52
1.53
1.54
1.55
1.56
1.56
1.57
1.58
1.59
1.59
1.60
1.61
1.61
1.62
1.63
1.63
1.64
1.64
1.65
1.65
1.66
1.66
1.67
1.67
1.68
1.68
1.69
1.69
1.70
1.70
1.71
1.71
1.72
1.72
33
34
1.00
1.03
1.05
1.08
1.11
1.14
1.16
1.18
1.21
1.23
1.25
1.27
1.29
1.31
1.32
1.34
1.35
1.37
1.38
1.39
1.41
1.42
1.43
1.44
1.45
1.46
1.47
1.48
1.49
1.49
1.50
1.51
1.52
1.53
1.53
1.54
1.55
1.55
1.56
1.57
1.57
1.58
1.58
1.59
1.59
1.60
1.60
1.61
1.61
1.62
1.62
1.63
1.63
1.64
1.64
1.65
1.65
1.65
1.66
1.66
1.67
1.67
34
35
1.00
1.03
1.05
1.08
1.10
1.13
1.15
1.17
1.20
1.22
1.23
1.25
1.27
1.29
1.30
1.32
1.33
1.34
1.36
1.37
1.38
1.39
1.40
1.41
1.42
1.43
1.44
1.45
1.45
1.46
1.47
1.48
1.48
1.49
1.50
1.50
1.51
1.51
1.52
1.53
1.53
1.54
1.54
1.55
1.55
1.56
1.56
1.57
1.57
1.58
1.58
1.58
1.59
1.59
1.60
1.60
1.60
1.61
1.61
1.61
1.62
1.62
35
36
1.00
1.02
1.05
1.07
1.10
1.12
1.14
1.16
1.18
1.20
1.22
1.24
1.25
1.27
1.28
1.30
1.31
1.32
1.33
1.34
1.35
1.36
1.37
1.38
1.39
1.40
1.41
1.42
1.42
1.43
1.44
1.44
1.45
1.46
1.46
1.47
1.47
1.48
1.48
1.49
1.49
1.50
1.50
1.51
1.51
1.52
1.52
1.53
1.53
1.53
1.54
1.54
1.55
1.55
1.55
1.56
1.56
1.56
1.57
1.57
1.57
1.58
36
37
1.00
1.02
1.05
1.07
1.09
1.11
1.13
1.15
1.17
1.19
1.21
1.22
1.24
1.25
1.26
1.28
1.29
1.30
1.31
1.32
1.33
1.34
1.35
1.36
1.36
1.37
1.38
1.39
1.39
1.40
1.41
1.41
1.42
1.42
1.43
1.43
1.44
1.45
1.45
1.45
1.46
1.46
1.47
1.47
1.48
1.48
1.49
1.49
1.49
1.50
1.50
1.50
1.51
1.51
1.51
1.52
1.52
1.52
1.53
1.53
1.53
1.54
37
38
1.00
1.02
1.04
1.06
1.08
1.10
1.12
1.14
1.16
1.18
1.19
1.21
1.22
1.23
1.25
1.26
1.27
1.28
1.29
1.30
1.31
1.32
1.32
1.33
1.34
1.35
1.35
1.36
1.37
1.37
1.38
1.38
1.39
1.39
1.40
1.40
1.41
1.41
1.42
1.42
1.43
1.43
1.43
1.44
1.44
1.45
1.45
1.45
1.46
1.46
1.46
1.47
1.47
1.47
1.48
1.48
1.48
1.48
1.49
1.49
1.49
1.50
38
39
1.00
1.02
1.04
1.06
1.08
1.10
1.12
1.13
1.15
1.16
1.18
1.19
1.21
1.22
1.23
1.24
1.25
1.26
1.27
1.28
1.29
1.29
1.30
1.31
1.31
1.32
1.33
1.33
1.34
1.34
1.35
1.36
1.36
1.37
1.37
1.37
1.38
1.38
1.39
1.39
1.40
1.40
1.40
1.41
1.41
1.41
1.42
1.42
1.42
1.43
1.43
1.43
1.43
1.44
1.44
1.44
1.45
1.45
1.45
1.45
1.46
1.46
39
40
1.00
1.02
1.04
1.06
1.07
1.09
1.11
1.12
1.14
1.15
1.17
1.18
1.19
1.20
1.21
1.22
1.23
1.24
1.25
1.26
1.26
1.27
1.28
1.29
1.29
1.30
1.30
1.31
1.31
1.32
1.32
1.33
1.33
1.34
1.34
1.35
1.35
1.35
1.36
1.36
1.37
1.37
1.37
1.38
1.38
1.38
1.38
1.39
1.39
1.39
1.40
1.40
1.40
1.40
1.41
1.41
1.41
1.41
1.42
1.42
1.42
1.42
40
41
1.00
1.02
1.03
1.05
1.07
1.08
1.10
1.12
1.13
1.14
1.15
1.17
1.18
1.19
1.20
1.21
1.21
1.22
1.23
1.24
1.24
1.25
1.26
1.26
1.27
1.27
1.28
1.29
1.29
1.29
1.30
1.30
1.31
1.31
1.32
1.32
1.32
1.33
1.33
1.33
1.34
1.34
1.34
1.35
1.35
1.35
1.35
1.36
1.36
1.36
1.37
1.37
1.37
1.37
1.37
1.38
1.38
1.38
1.38
1.39
1.39
1.39
41
42
1.00
1.02
1.03
1.05
1.06
1.08
1.09
1.11
1.12
1.13
1.14
1.15
1.16
1.17
1.18
1.19
1.20
1.21
1.21
1.22
1.23
1.23
1.24
1.24
1.25
1.25
1.26
1.26
1.27
1.27
1.28
1.28
1.28
1.29
1.29
1.29
1.30
1.30
1.30
1.31
1.31
1.31
1.32
1.32
1.32
1.32
1.33
1.33
1.33
1.33
1.34
1.34
1.34
1.34
1.34
1.35
1.35
1.35
1.35
1.35
1.36
1.36
42
43
1.00
1.01
1.03
1.04
1.06
1.07
1.09
1.10
1.11
1.12
1.13
1.14
1.15
1.16
1.17
1.18
1.18
1.19
1.20
1.20
1.21
1.21
1.22
1.22
1.23
1.23
1.24
1.24
1.25
1.25
1.25
1.26
1.26
1.26
1.27
1.27
1.27
1.28
1.28
1.28
1.28
1.29
1.29
1.29
1.29
1.30
1.30
1.30
1.30
1.31
1.31
1.31
1.31
1.31
1.32
1.32
1.32
1.32
1.32
1.32
1.33
1.33
43
44
1.00
1.01
1.03
1.04
1.05
1.07
1.08
1.09
1.10
1.11
1.12
1.13
1.14
1.15
1.15
1.16
1.17
1.17
1.18
1.18
1.19
1.20
1.20
1.20
1.21
1.21
1.22
1.22
1.22
1.23
1.23
1.23
1.24
1.24
1.24
1.25
1.25
1.25
1.25
1.26
1.26
1.26
1.26
1.27
1.27
1.27
1.27
1.28
1.28
1.28
1.28
1.28
1.28
1.29
1.29
1.29
1.29
1.29
1.29
1.30
1.30
1.30
44
45
1.00
1.01
1.03
1.04
1.05
1.06
1.07
1.08
1.09
1.10
1.11
1.12
1.13
1.13
1.14
1.15
1.15
1.16
1.16
1.17
1.17
1.18
1.18
1.19
1.19
1.19
1.20
1.20
1.20
1.21
1.21
1.21
1.22
1.22
1.22
1.22
1.23
1.23
1.23
1.23
1.24
1.24
1.24
1.24
1.24
1.25
1.25
1.25
1.25
1.25
1.26
1.26
1.26
1.26
1.26
1.26
1.26
1.27
1.27
1.27
1.27
1.27
45
46
1.00
1.01
1.02
1.03
1.05
1.06
1.07
1.08
1.08
1.09
1.10
1.11
1.11
1.12
1.13
1.13
1.14
1.14
1.15
1.15
1.16
1.16
1.17
1.17
1.17
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.20
1.20
1.20
1.20
1.21
1.21
1.21
1.21
1.21
1.22
1.22
1.22
1.22
1.22
1.22
1.23
1.23
1.23
1.23
1.23
1.23
1.24
1.24
1.24
1.24
1.24
1.24
1.24
1.24
1.25
46
47
1.00
1.01
1.02
1.03
1.04
1.05
1.06
1.07
1.08
1.08
1.09
1.10
1.10
1.11
1.12
1.12
1.13
1.13
1.13
1.14
1.14
1.15
1.15
1.15
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.18
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.19
1.19
1.20
1.20
1.20
1.20
1.20
1.20
1.21
1.21
1.21
1.21
1.21
1.21
1.21
1.21
1.22
1.22
1.22
1.22
1.22
1.22
47
48
1.00
1.01
1.02
1.03
1.04
1.05
1.05
1.06
1.07
1.08
1.08
1.09
1.09
1.10
1.10
1.11
1.11
1.12
1.12
1.12
1.13
1.13
1.13
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.16
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.17
1.17
1.18
1.18
1.18
1.18
1.18
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.20
1.20
1.20
48
49
1.00
1.01
1.02
1.03
1.03
1.04
1.05
1.05
1.06
1.07
1.07
1.08
1.08
1.09
1.09
1.10
1.10
1.10
1.11
1.11
1.11
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.14
1.14
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.16
1.16
1.16
1.16
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
49
50
1.00
1.01
1.01
1.02
1.03
1.04
1.04
1.05
1.05
1.06
1.06
1.07
1.07
1.08
1.08
1.08
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.12
1.12
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
50
51
1.00
1.01
1.01
1.02
1.03
1.03
1.04
1.04
1.05
1.05
1.06
1.06
1.06
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
51
52
1.00
1.01
1.01
1.02
1.02
1.03
1.03
1.04
1.04
1.04
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.07
1.07
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
52
53
1.00
1.00
1.01
1.01
1.02
1.02
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
53
54
1.00
1.00
1.01
1.01
1.01
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
54
55
1.00
1.00
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
55
56
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
56
57
1.00
1.00
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
57
58
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
58
0.0
0.1 0.2 0.3 0.4 0.5 0.6
0.7
0.8
0.9
1.2
1.3
1.4
1.5 1.6
1.7
1.8
1.9
2.0 2.1
2.2
2.3
2.4
2.5
2.6
2.7
2.8
2.9
3.0
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4.0
4.1
4.2
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
RPMFs as
f(n,CV,Confidence,UpperBound)
400.00
350.00
300.00
`o
250.00
LL
m 200.00
150.00
100.00
50.00
0.00
1
4 7 10 13 16 19 22 25
❑ 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

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

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

2/24/16:
Added to " Diss to Total Metal Calculator" page:
1) Comment section for PERCS info or other to allow user to add commentary
2) Added Facility name to display based on input page
3) Added NPDES permit# to display based on input page
4) Set up new Name "PERCS_page" as print area for table and other PERCS info for GOTO use.
NOTE: User can either highlight desire print area or use GOTO feature to set up desired print arae. When in print mode set up, will need to designate "Print Selection".
3/18/16:
Removed HUC table and HUC hardness lookup features from calculations and program.
Note: HUC number is an available option on the INPUT as an informational input only to use as a display label for other portion of the progam and has no Data Validation features.
Added Upstream Hardness calculation feature using measured upstream data:
1) INPUT display shows "Upstream Hardess" status and how upstream data is applied
2) DATA has new Upstream Hardness input sheet to accept upstream hardness data used to calculate number of data enties, data set average, data set 10th percentile value
3) Diss to Total Metal Calculator determines which upstream hardness to apply, if the number of data entries exceed 30 then the average value is used, if the number of data enties are less than 30 then the
10th percentile value is used. Anytime the applied upstream hardness is less than 25 mg/L then a default value of 25 mg/L is applied.
4/26/16:
Per Julia want to use average values for both the effluent and upstream hardness calculations. Defaults to be the same as was applied in the HUC base RPA.
1) Changed all upstream hardness median calculations to average calculations.
2) Removed any greater than 99.999 defaults from upstream hardness conditional statements. Upstream average will be actual execpt when less than 25, then 25 is the default.
3) Changed all effluent hardness median calculations to average calculations. Conditional statements for WS still apply, efflunet average value above 99.999 default to 99.
4) Any conditional statement referring to median hardness were revised.
5) Removed "(AL)" from parameter labels as no longer applicable.
6) Renamed RPA to describe features
4/27/16:
Per Julia when WS is being applied, the combined acute and chroinc hardness needs to default to 100 if the combined hardness exceeds 100. Made changes:
1) Set up new cells to calculate combined acute and chronic hardness, defined cells as program names ACCH & ACAH.
2) Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH & ACAH exceed 100 when WS was applied.
3) Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate defaults
4) Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate defaults
4/28/16:
Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI now function.
Revised RPA page drop menu "Recommended Action" list to remove RP Action Level text and change "RP non action level..." text to state "RP shown...".
Added statement to 2B .0500 RULES page "4/28/16: Note Action Level designation no long allowed per EPA."
4/29/16:
Added ROUND function to conditional statements on INPUT page hardess displays to limit hardness value display to 2 decimal points.
Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardness of 25 to be displayed as non -default value.
5/6/16:
Removed less than 25 mg/L default from all effluent and upstream hardness conditional programming
5/11/16:
Added new conditional display to Total Chromium Pred Cw box RPA page to compare Total Chromium data to Cr III and Cr VI Allowable Cw
Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Total Chromium value entered
6/13/16:
Revised title block text RPA tab to state "NC STANDARDS OR EPA CRITERIA", removed "NC WQS" from Chronic label, and removed 1/2 FAV from Acute label.
Corrected INPUT tab to align Dats Source(s) text box at top.
6/14/16:
Revised conditions for calculated combined hardness acute and chroinc to default to 400 mg/L if calculated value exceeded 400 mg/L
Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when default 400 mg/L applied
Corrected label on DISS ... page to indicate average for effluent and upstream hardness
7/13/16:
Revised Model input feature when activated to calculate Model 7Q10s (cfs) flow based on entry of Qw, MGD and CHRONIC DILITION FACTOR (from Model) and display in Model narrative box.
User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry box. 1Q10s is calculated once the calculated 7Q10s (cfs) is entered in Tablel .
Revised narrative in Model narrative box with new instructions, new messages to alert user on actions needed and/or completed to correctly enter Model 7Q10s (cfs) in Table 1.
Remove conditions and features assocaited with entry of Model Acute IWC % .
8/30/16:
Revised conditional note statement on RPA tab for Total Chromium to correct program error.
10/20/16:
Revised label display for Fcailty discripition on "Diss to Total Metal Calculator".sheet to list Outfall #.
9/7/2017
Revised chromium drop down to reflect new < 5ug/L PQL.
11/21/17:
(1) Revised RPA evaluation to assign C.V. (default) = 0.6 when only a sinlgle data entry inade for any parameter (see data page). On data page the parameter will diplay Std..Dev. = "N/A" when only a single data entry made.
(2) Revised RPA evaluation to always calculate and display "Max Pred Cw" value whenever there are 1 to 58 data numerical entties made (see data and rpa pages).
(3) Revised rpa page to show each parameters automatic display message "NO DETECTS" independent from "Max Pred Cw" display
(4) Revised Total Chromium < 50 data counter to start count when the entered data point < 4.9999. (hidden column of data page). Revised Total Chromium automatic diplay message on rpa page to reflect new 5 pg/I criteria.
11/29/17:
(1) Revised RPA page C.V. (default? Message to
(2) Corrected DATA page H2 message to show ... UPSTREAM...
(3)
Removed (1) from RPA page Type label
11/30/17:
Revised Dissolved Metals and Total Metals Table label descriptions on "DSS to Total Metal Calculator" tab so as not to conflict with exsiting descriptions in RPA
12/12/17:
Revised conditional statements DATA tab to allow appllication C.V. (default) for number of data values 1 to 9 even if no deviation in data set.
1/20/18:
1) Revised "RPA" Receiving Stream display to only show the Stream name and if entered the HUC number
2) Increased RPA page Qw display decimal places

Date: 6/25/2021
Dissolved to Total Metal Calculator
Do NOT enter any data directly into this spreadsheet.
Enter data onto "Table 1" under the Input Sheet and enter
"Effluent Hardness" under the Data Sheet.
In accordance with 40 CFR 122.45 (c ), permits are, have and
must be written as total metals.
This calculator has been inserted into the RPA to calculate Total
Metal allowable allocations once Table 1 has been completed
(Input Sheet) and Effluent hardness has been entered (Data
Sheet).
1) Following the spreadsheet from left to right. First
the allowable allocations for the dissolved metals will
appear for all the metals listed once Table 1 is complete and
effluent hardness entered. Use a default value of 25 mg/L if
no hardness data is available. Second, the
Dissolved Metal allocations are divided by the Translators to
determine the Total Metals that can be allocated to the
Permittee. These Total Metals values are automatically
inserted into Table 2 and are the allowable Total Metal
allocations determined for the Permittee prior to allowing
for dilution. See Input sheet Table 2. The final acute and
chronic values shown under the RPA sheet are the Total
Metal values listed in Table 2 divided by the acute and
chronic IWC, respectively.
2) The Translators used in the freshwater RPA are the Partition
Coefficients published by US EPA in 1984. They are TSS
dependent equations and can be found listed with the WQS
hardness dependent equations under the sheet labeled
Equations. A fixed TSS value of 10 mg/L is used to calculate
the Translator values.
3) Pretreatment Facilities - PERCS will need a copy of the
Dissolved to Total Metal Calculator spreadsheet and the
RPA sheet along with the Final Permit. Pretreatment
Facilities are required to renew their Headwords Analysis
after renewal of their permits. Since all their metal
allocations are likely to change PERCS needs to see any new
metal permit limits and the allowable allocations for the
dissolved metals to assess Maximum Allowable Headworks
Loading (MAHL) numbers for each metal based on the
Combined Hardness values used in the permit writers RPA
calculations.
4) For Cadmium, Lead, Nickel, Chromium and Beryllium, if all
the effluent sampling data for the last three to five years
shows the pollutant at concentrations less than the Practical
Quantitative Level (PQL), it is not likely a limit or monitoring
will be put in the permit. However, if the estimated NPDES
permit limit is less than the Practical Quantitative Limit
(particularly, Cadmium and Lead) and the pollutant is
believed to be present, to assess compliance with the new
standards and for future permit limit development,
monitoring for the pollutant will be required. If the facility is
monitoring for the pollutant in its Pretreatment LTMP, no
monitoring is needed in the permit.
5) For monitoring and compliance purposes if Total Chromium
FACILITY: Ticona Facility Outfall 001
NPDES PERMIT: NC0004952
Dissolved to Total Metal Calculator
In accordance with Federal Regulations, permit limitations must be written as Total Metals per 40 CFR 122.45(c)
Receiving
Stream
summer
7Q10 (CFS)
Receiving
Stream
summer 7Q10
(MGD)
Rec. Stream
1Q10
[MGD]
NPDES
Flow Limit
MGD
Total Suspended
Solids
-Fixed Value-
(mg/L)
Combined
Hardness
chronic
(mg/L)
Combined
Hardness
Mute
(mg/L)
Instream
Wastewater
Concentration
(Chronic)
Instream
Wastewater
Concentration
(Acute)
Upstream
Hardness
Average (mg/L)
Effluent
Hardness
Average
(mg/L)
32.11
20.6452
16.9871
0.4500
10
25.000
25.000
2.1332
2.5807
I 25
I 25
Upstream Hard Avg (mg/L) =
25
EFF Hard Avg (mg/L) = 25
PARAMETER
Dissolved Metals Criteria US EPA
after applying hardness Translators- using Total Metal Criteria Total Metal =
equation Default Partition Dissolved Metal - Translator
Coefficients
(streams)
Chronic
Iuq/I1
Acute
f uq/Il
Chronic
f uq/Il
Acute
f uq/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
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 1SA NCAC 02B .0211 for more information.
(t) = based upon measurement of total recoveable metal. See 15A NCAC 02B .0211 for more information.
The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard.
The Human Health standard for Arsenic is 10 ug/L which is Total Recoverable metal standard.
ACAH
ACCH

Dissolved Metals & Hardness Determination
v. 5/27/2010
I. How to Determine Hardness for use with Dissolved Freshwater Standards for Permitting Purposes
HARDNESS - Use 25 mg/L expressed as CaCO, or Cal -Mg. as the default Hardness
OR
To determine a Hardness value for permit limit development, use the following equation:
Hardness = (Hardness instreamla), mq/L * 7010, MGD)+(Hardness effluents"), mq/L* Plant flow, MGD)
Cm.aa1 re )
(7010, MGD + Plant Flow, MGD)
(a) Use the median instream Hardness value of the ambient 8-digit HUC data collected by the Division of Water Quality. To find the 8-digit HUC hardness value for your facility Click Here.
(b) For the purpose of this estimation, use the facility's median effluent Hardness value, if available. The Division will request the permittee to sample effluent hardness once/month and submit one to two years of data with the permit renewal application. If no effluent hardness data is submitted, a default of 25 mg/L will be applied.
II. To Develop Dissolved Metal concentrations for permitting purposes use the Freshwater Standards for Hardness Dependent Metals listed in Table A below.
Table A: Dissolved Freshwater Standards for Hardness Dependent Metals
Metal
pg/L
Cadmium, Acute
{1.136672-[In hardness](0.041838)} • e^{0.9151 [In hardness]-3.1485}
Cadmium, Acute (Trout Waters)
{1.136672-[In hardness](0.041838)} • e^{0.9151[In hardness]-3.6236}
Cadmium, Chronic
{1.101672-[In hardness](0.041838)} • e^{0.7998[In hardness]-4.4451}
Chromium 111, Acute
0.316' a^{0.8190[In hardness]+3.7256}
Chromium 111, Chronic
0.860' a^{0.8190[In hardness]+0.6848}
Copper, Acute
0.960 ' e^{0.9422[In hardness]-1.700}
Copper, Chronic
0.960 ' e^{0.8545[In hardness]-1.702}
Lead, Acute
{1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-1.460}
Lead, Chronic
{1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-4.705}
Nickel, Acute
0.998 ' e^{0.8460[In hardness]+2.255}
Nickel, Chronic
0.997 ' e^{0.8460[In hardness]+0.0584}
Silver, Acute
0.85 ' e^{1.72[In hardness]-6.59}
Silver, Chronic
Not applicable
Zinc, Acute
0.978' a^{0.8473[In hardness]+0.884}
Zinc, Chronic
0.986' a^{0.8473[In hardness]+0.884}
Complete information on all the proposed Surface Water Quality Standards can be viewed at: http://h2o.enr.state.nc.us/csu/trirev SW.html.
US EPA Translators
using Default Partition Coefficients (DPC)
v. 6/2/2010
Translator equation using Default Partition Coefficients =
1
[1 + (Kpo * TSS (1-"`)* 10-0)]
Kpo and cc 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
Cu
1.04E+06
- 0.7436
Zn
1.25E+06
- 0.7038
Pb
2.80E+06
- 0.8
Cr (III) (2)
3.36E+06
- 0.09304
Cd
4.00E+06
- 1.1307
4.90E+05
- 0.5719
(1) Delos, C.G., et al. Technical Guidance for Perfo ming Waste Load Allocations. Book II: Streams and Rivers. Chapter 3: Toxic Substances, For the U.S. EPA. (EPA-440/4-84-022)
(2) Linear partition cceffcienfs shall not apply to the Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefo
TABLE B. US EPA Translators
PARAMETER
US EPA Translators
Using stream Default Partition Cceffcients
T55= 10 mg/L
Cadmium
0.252
Chromium III
0.202
Chromium VI
1
Chromium, Total
N/A
Copper
0.348
Lead
0.184
Nickel
0.432
Silver
1
Zinc
0.288
Example for Cadmium (streams)
Glum.
TSS = 10 mg/L
Kpo =4.00E+06
=-1.1307
a Translator =
[1 + (Kpo * TSS (rW * 106)]
1
[1 + (4.Nx10° * 10 - 00T * 10a)]
1
[1+2960465]
= 0.252