Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
NC0004961_RPA Outfall 002A-2020_20210215
Riverbend Steam Station NC0004961 Qw (MGD) = 0.0400 1 Q 10S (cfs) = 65.40 7Q 1 OS (cfs) = 80.00 7Q1OW (cfs) = 80.00 30Q2 (cfs) = 80.00 Avg. Stream Flow, QA (cfs) = 2700.00 Receiving Stream: Catawba River Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators MAXIMUM DATA POINTS = 58 WWTP/WTP Class: IWC% @ 1 Q 10S = 0.094711436 IWC% @ 7Q 10S = 0.077439984 IWC% @ 7Q1OW = 0.077439984 IWC% @ 30Q2 = 0.077439984 IW%C @ QA = 0.002296244 Stream Class: WS-IV B-CA Outfall 002A Qw = 0.04 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 _1REASONABLE a 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 19 16 9.6 Acute (FW): 358,985.2 Chr_ onic(F__193_ 698 4 ____________________________ W): , Novalue > Allowable _Cw_____________________________ Chronic (Tin):435,493 9 No value > Allowable Cw no limit Beryllium NC 6.5 FW(7Q10s) 65 ug/L 19 11 114.87 Acute: 68,629.52 -- _ _ _ ---_ _ _ ---------------------------- Chronic:—8,393.60 No value > Allowable Cw no limit Cadmium NC 0.5899 FW(7Q10s) 3.2396 ug/L 19 13 16.983 Acute: 3,420.507 _ _ _ Chronic: 761 724----------------------------- -- _ _ _ ----761.724 No value > Allowable Cw no limit Chlorides NC 230 FW(7Q10s) mg/L 19 19 28.6 Acute: NO WQS -- _ _ _ --- _ _ _ ---------------------------- Chronic: 297,004.2 No value > Allowable Cw no limit Chlorinated Phenolic Compounds NC 1 A(30Q2) ug/L 0 0 N/A Acute: NO WQS -- _Chr_ _ _ onic:-----1,291.3 ----------------------------- N/A Total Phenolic Compounds NC 300 A(30Q2) ug/L 0 0 N/A Acute: NO WQS -- _Chr_ onic:--- 38_7,396-8 ---------------------------- N/A Chromium III NC 117.7325 FW(7Q10s) 905.0818 µg/L 0 0 N/A Acute: 955,620.4 -- _Chr_ _ onic:----152,030.7_ ---------------------------- no limit Chromium VI NC 11 FW(7Q10s) 16 µg/L 19 3 1.1 Acute: 16,893.4 -- _ _ _ ---_ _ ----------------------------- Chronic:—14,204.5 No value > Allowable Cw no limit Chromium, Total NC µg/L Tot Cr value(s) 19 18 > 5 but < Cr VI 182.1 Allowable Cw Max reported value = 84.7 Page 1 of 3 4961-RPA Outfall 002A-2020, rpa 2/19/2021 Riverbend Steam Station NC0004961 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Outfall 002A Qw = 0.04 MGD Copper NC 7.8806 FW(7Q10s) 10.4720 ug/L 19 17 584.80 Acute: 11,056.74 -- _ _ _ ---_ _ _ ---------------------------- Chronic:—10,176.45 No value > Allowable Cw no limit Cyanide NC 5 FW(7Q10s) 22 10 ug/L 0 0 N/A Acute: 23,228.5 -- _ _ _ ---- _ _ ----------------------------- Chronic: 6,456.E N/A Fluoride NC 1800 FW(7Q10s) ug/L 13 8 8.6 Acute: NO WQS -- _ _ _ --- _ _ _ _ ---------------------------- Chronic: 2,324,380.6 No value > Allowable Cw no limit Lead NC 2.9416 FW(7Q10s) 75.4871 ug/L 19 10 8.745 Acute: 79,702.207 -- _ _ _ --- _ _ _ ---------------------------- Chronic: 3,798.58E No value > Allowable Cw no limit Mercury NC 12 FW(7Q10s) 0.5 ng/L 19 0 143.0 NO DETECTS Acute: NO WQS _ _ _ _ _ _ -- Chronic:----15,495.9 - Max MDL = 200 no limit —-—-—-—-—-—-—-—-—-—-—-—-—-— Molybdenum NC 2000 HH(7Q10s) ug/L 19 17 5.6 Acute: NO WQS -- _ _ _ --- _ _ _ _ ---------------------------- Chronic: 2,582,645.2 No value > Allowable Cw no limit Nickel Nickel NC NC 37.2313 FW(7Q10s) 335.2087 25.0000 WS(7Q10s) µg/L µ 19 19 1,253.9 Acute (FW): 353,926.3 Chr onic(F__,077.7 _ _____________________________ W): 48 No_ value>Allowable 2_Cw_ _ _ Chronic (WS): 3,283.1 No value > Allowable Cw no limit _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Selenium NC 5 FW(7Q10s) 56 ug/L 19 18 15.0 Acute: 59,127.0 -- _ _ _ ---- _ _ ----------------------------- Chronic: 6,456.E No value > Allowable Cw no limit Silver NC 0.06 FW(7Q10s) 0.2964 ug/L 6 0 Note: n < 9 Limited data set 1.070 C.V. (default) NO DETECTS Acute: 312.948 ___ _ _______ _ _____________________________ Chronic: 77.479 Max MDL = 1 no limit Zinc NC 126.7335 FW(7Q10s) 125.7052 ug/L 19 19 2,509.2 Acute: 132,724.4 -- _ _ _ ---_ _ -8 ---------------------------- Chronic:—163,653 No value > Allowable Cw no limit Thallium NC 2 FW(7Q10s) µg/L 19 11 1.53000 Acute: NO WQS -- _ _ _ --- _ _ _ _ ---------------------------- Chronic: 2582.64516 No value > Allowable Cw no limit Nitrate nitrite NC 10 WS(7Q10s) mg/L 19 15 1.30670 Acute: NO WQS -- _ _ _ --- _ _ _ _ ---------------------------- Chronic: 12913.22581 No value > Allowable Cw no limit. Acute: NO WQS ,,, ';_;+ Page 2of3 4961-RPA Outfall 002A-2020, rpa 2/19/2021 Riverbend Steam Station NC0004961 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Outfall 002A Qw = 0.04 MGD Aluminum NC 6500 WS(7Q10s) µg/L 19 17 104,052.00000 _ _ _ _ _ _ _ _ _ _ _ _ ########### ___________________________ Chronic: No value > Allowable Cw Acute: NO WQS no limit Antimony NC 5.6 WS(7Q10s) µg/L 19 7 4.10000 _ _ _ _ _ _ _ _ _ _ _ _____________________________ Chronic: 7231.40645 No value > Allowable Cw 4961-RPA Outfall 002A-2020, rpa Page 3 of 3 2/19/2021 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators MAXIMUM DATA POINTS = 58 REQUIRED DATA ENTRY Table 1. Project Information ['CHECK IF HQW OR ORW WQS Facility Name WWTP/WTP Class NPDES Permit Outfall Flow, Qw (MGD) Receiving Stream HUC Number Stream Class Riverbend Steam Station C I NC0004961 002A 0.040 Catawba River WS-IV B-CA OApply WS Hardness WQC 7Q10s (cfs) 7Q1Ow (cfs) 30Q2 (cfs) QA (cfs) 1Q1Os (cfs) 80.00 80.00 80.00 C 2700.00 65.40 Effluent Hardness Upstream Hardness Combined Hardness Chronic Combined Hardness Acute I 25 mg/L (Avg) I 25 mg/L (Avg) I 25 mg/L I 25 mg/L Data Source(s) ['CHECK TO APPLY MODEL CHECK WQS Table 2. Parameters of Concern Par01 Par02 Par03 Par04 Par05 Par06 Par07 Par08 Par09 Par10 Par11 Par12 Par13 Par14 Par15 Par16 Par17 Par18 Par19 Par20 Par21 Par22 Par23 Par24 Name WQS Type Chronic Modifier Acute PQL Units Arsenic Aquactic Life C 150 FW 340 ug/L Arsenic Human Health Water Supply C 10 HH/WS N/A ug/L Beryllium Aquatic Life NC 6.5 FW 65 ug/L Cadmium Aquatic Life NC 0.5899 FW 3.2396 ug/L Chlorides Aquatic Life NC 230 FW mn/I Chlorinated Phenolic Compounds Water Supply NC 1 A ug/L yTotal Phenolic Compounds Aquatic Life NC 300 A ug/L Chromium III Aquatic Life NC 117.7325 FW 905.0818 ug/L Chromium VI Aquatic Life NC 11 FW 16 pg/L Chromium, Total Aquatic Life NC N/A FW N/A pg/L Copper Aquatic Life NC 7.8806 FW 10.4720 ug/L Cyanide Aquatic Life NC 5 FW 22 10 ug/L Fluoride Aquatic Life NC 1,800 FW ug/L Lead Aquatic Life NC 2.9416 FW 75.4871 ug/L Mercury Aquatic Life NC 12 FW 0.5 ng/L Molybdenum Human Health NC 2000 HH ug/L Nickel Aquatic Life NC 37.2313 FW 335.2087 pg/L Nickel Water Supply NC 25.0000 WS N/A pg/L Selenium Aquatic Life NC 5 FW 56 ug/L Silver Aquatic Life NC 0.06 FW 0.2964 ug/L Zinc Aquatic Life NC 126.7335 FW 125.7052 ug/L Thallium Aquatic Life NC 2 FW pg/L Nitrate nitrite Water Supply NC 10 WS mg/L Aluminum Water Supply NC 6500 WS pg/L NC0004961_RPA Outfall 002A-2020_20210215, input 2/19/2021 NC0004961_RPA Outfall 002A-2020_20210215, input 2/19/2021 REASONABLE POTENTIAL ANALYSIS H1 Effluent Hardness Date Data BDL=1/2DL Results 1 25 25 Std Dev. 2 Mean 3 C.V. 4 n 5 10th Per value 6 Average Value 7 Max. Value 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 H2 Upstream Hardness N/A 25.0000 0.0000 1 25.00 mg/L 25.00 mg/L 25.00 mg/L Date Data BDL=1/2DL Results 1 25 25 Std Dev. 2 Mean 3 C.V. 4 n 5 10th Per value 6 Average Value 7 Max. Value 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 N/A 25.0000 0.0000 1 25.00 mg/L 25.00 mg/L 25.00 mg/L NC0004961 _RPA Outfall 002A-2020_20210215, data - 3 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS Par01 & Par02 Arsenic Date Data BDL=1/2DL Results 1 0.39 0.39 Std Dev. 2 1.534 1.534 Mean 3 1.16 1.16 C.V. 4 6.4 6.4 n 5 6.5 6.5 6 6.01 6.01 Mult Factor = 7 3.7 3.7 Max. Value 8 3.357 3.357 Max. Pred Cw 9 2.94 2.94 10 4.6 4.6 11 3.093 3.093 12 3.06 3.06 13 0.2 0.2 14 < 5 2.5 15 < 1 0.5 16 0.22 0.22 17 < 5 2.5 18 0.558 0.558 19 3.8 3.8 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 2.0615 2.7906 0.7387 19 1.48 6.5 ug/L 9.6 ug/L NC0004961 _RPA Outfall 002A-2020_20210215, data - 4 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS Par03 Beryllium Date Data BDL=1/2DL Results 1 < 1 0.5 Std Dev. 2 < 5 2.5 Mean 3 < 1 0.5 C.V. 4 66.4 66.4 n 5 51.8 51.8 6 57.3 57.3 Mult Factor = 7 18.6 18.6 Max. Value 8 20.3 20.3 Max. Pred Cw 9 22.1 22.1 10 22.8 22.8 11 22.9 22.9 12 25.5 25.5 13 < 0.1 0.05 14 < 5 2.5 15 < 1 0.5 16 0.4 0.4 17 < 5 2.5 18 < 1 0.5 19 20.9 20.9 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par04 Cadmium 20.7374 17.8184 1.1638 19 1.73 66.40 ug/L 114.87 ug/L Date Data BDL=1/2DL Results 1 < 0.8 0.4 Std Dev. 2 < 5 2.5 Mean 3 < 1 0.5 C.V. 4 11.1 11.1 n 5 9.12 9.12 6 8.3 8.3 Mult Factor = 7 4.3 4.3 Max. Value 8 6.34 6.34 Max. Pred Cw 9 5.21 5.21 10 4.6 4.6 11 4.97 4.97 12 5.21 5.21 13 0.48 0.48 14 < 5 2.5 15 0.601 0.601 16 0.19 0.19 17 < 5 2.5 18 < 1 0.5 19 4.8 4.8 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 3.2321 3.9011 0.8285 19 1.53 11.100 ug/L 16.983 ug/L NC0004961 _RPA Outfall 002A-2020_20210215, data - 5 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS Par05 Chlorides Date Data 22 22 21 9.9 9.9 13 11.4 11 11 11.5 11 12 7.4 6.4 9.73 6.6 6.2 8.1 22.2 BDL=1/2DL Results 22 Std Dev. 22 Mean 21 C.V. 9.9 n 9.9 13 Mult Factor = 11.4 Max. Value 11 Max. Pred Cw 11 11.5 11 12 7.4 6.4 9.73 6.6 6.2 8.1 22.2 Use "PASTE SPECIAL - Values" then "COPY" . Maximum data points = 58 Par06 Chlorinated Phenolic Compounds 5.4425 12.2 0.4451 19 1.3 22.2 mg/L 28.6 mg/L Date Data BDL=1/2DL Results 1 Std Dev. 2 Mean 3 C.V. 4 n 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SF Values" then "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 NC0004961 _RPA Outfall 002A-2020_20210215, data - 6 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Par07 Total Phenolic Compounds Date Data BDL=1/2DL Results 1 Std Dev. 2 Mean 3 C.V. 4 n 5 6 ug/L 7 ug/L 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 NO DATA NO DATA NO DATA 0 Mult Factor = N/A Max. Value N/A ug/L Max. Pred Cw N/A 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 NC0004961 _RPA Outfall 002A-2020_20210215, data - 7 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" iata ;8 Par09 Chromium VI Date Data BDL=1/2DL Results 1 < 0.1 0.05 Std Dev. 2 < 0.1 0.05 Mean 3 < 0.1 0.05 C.V. 4 < 0.1 0.05 n 5 0.1 0.1 6 0.1 0.1 Mult Factor = fag/L 7 < 0.1 0.05 Max. Value fag/L 8 < 0.1 0.05 Max. Pred Cw 9 < 0.1 0.05 10 0.22 0.22 11 < 0.1 0.05 12 < 0.1 0.05 13 < 0.1 0.05 14 < 0.1 0.05 15 < 0.1 0.05 16 < 0.1 0.05 17 < 0.1 0.05 18 < 0.1 0.05 19 < 1.2 0.6 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par10 Chromium, Total 0.1293 0.0932 1.3881 19 1.84 0.6 fag/L 1.1 fag/L Use "PASTE SF Values" then "I . Maximum c points = 5 Date Data BDL=1/2DL Results 1 13.9 13.9 Std Dev. 18.7209 2 0.746 0.746 Mean 8.9523 3 0.847 0.847 C.V. 2.0912 4 6.8 6.8 n 19 5 4.613 4.613 6 3.16 3.16 Mult Factor = 2.15 7 6.7 6.7 Max. Value 84.7 8 8.21 8.21 Max. Pred Cw 182.1 9 3.32 3.32 10 5.9 5.9 11 5.21 5.21 12 2.06 2.06 13 84.7 84.7 14 1.896 1.896 15 0.548 0.548 16 12.2 12.2 17 < 5 2.5 18 0.783 0.783 19 6 6 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 NC0004961 _RPA Outfall 002A-2020_20210215, data - 8 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Pal 1 Copper Date Data BDL=1/2DL Results 1 0.67 0.67 Std Dev. 2 < 5 2.5 Mean 3 < 1 0.5 C.V. 4 284 284 n 5 228 228 6 215 215 Mult Factor = fag/L 7 65.7 65.7 Max. Value fag/L 8 118 118 Max. Pred Cw 9 340 340 10 139 139 11 127 127 12 172 172 13 3.6 3.6 14 0.767 0.767 15 1.76 1.76 16 1.1 1.1 17 0.516 0.516 18 2.74 2.74 19 122 122 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 109.8960 96.0449 1.1442 19 1.72 340.00 ug/L 584.80 ug/L Par12 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 Cyanide NC0004961 _RPA Outfall 002A-2020_20210215, data - 9 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Par13 Fluoride Date Data BDL=1/2DL Results 1 0.1 0.1 Std Dev. 2 < 5 2.5 Mean 3 1.2 1.2 C.V. 4 < 10 5 n 5 2 2 6 3.575 3.575 Mult Factor = ug/L 7 1.7 1.7 Max. Value ug/L 8 3.35 3.35 Max. Pred Cw 9 < 0.1 0.05 10 < 10 5 11 0.1 0.1 12 < 5 2.5 13 2.4 2.4 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 1.6780 2.2673 0.7401 13 1.72 5.0 ug/L 8.6 ug/L Date < 1 < 5 < 1 2.4 2.987 2.09 0.64 0.939 0.483 1.5 1.124 0.656 < 0.1 < 5 < 1 < 0.1 < 5 < 1 5.5 Use "PASTE SF Values" then "I . Maximum c points = 5 BDL=1/2DL Results 0.5 Std Dev. 1.3642 2.5 Mean 1.4694 0.5 C.V. 0.9284 2.4 n 19 2.987 2.09 Mult Factor = 1.59 0.64 Max. Value 5.500 0.939 Max. Pred Cw 8.745 0.483 1.5 1.124 0.656 0.05 2.5 0.5 0.05 2.5 0.5 5.5 Lead NC0004961 _RPA Outfall 002A-2020_20210215, data - 10 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Par15 Mercury Date Data BDL=1/2DL Results 1 < 200 100 Std Dev. 2 < 50 25 Mean 3 < 200 100 C.V. 4 < 200 100 n 5 < 50 25 6 < 50 25 Mult Factor = ug/L 7 < 200 100 Max. Value ug/L 8 < 50 25 Max. Pred Cw 9 < 50 25 10 < 200 100 11 < 50 25 12 < 50 25 13 < 200 100 14 < 50 25 15 < 50 25 16 < 200 100 17 < 50 25 18 < 50 25 19 < 200 100 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 Par16 Molybdenum 38.0443 56.5789 0.6724 19 1.43 100.0 ng/L 143.0 ng/L Use "PASTE SF Values" then "I . Maximum c points = 5 Date Data BDL=1/2DL Results 1 3.1 3.1 Std Dev. 1.0238 2 2.549 2.549 Mean 0.7874 3 1.7 1.7 C.V. 1.3002 4 0.12 0.12 n 19 5 0.112 0.112 6 < 1 0.5 Mult Factor = 1.80 7 0.13 0.13 Max. Value 3.1 8 0.177 0.177 Max. Pred Cw 5.6 9 0.111 0.111 10 0.12 0.12 11 0.107 0.107 12 < 1 0.5 13 3.1 3.1 14 0.491 0.491 15 0.323 0.323 16 0.84 0.84 17 0.44 0.44 18 0.4 0.4 19 0.14 0.14 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 NC0004961_RPA Outfall 002A-2020_20210215, data 2/19/2021 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" iata ;8 Par17 & Par18 Nickel 1 2 3 4 5 6 ug/L 7 ug/L 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Date Data BDL=1/2DL 81.2 39.1 68 843 781 853 757 788 767 689 648 681 204 232 282 68.2 84.7 53.8 709 81.2 39.1 68 843 781 853 757 788 767 689 648 681 204 232 282 68.2 84.7 53.8 709 Results Std Dev. Mean C.V. n Mult Factor = Max. Value Max. Pred Cw Use "PASTE SPECIAL• Par19 Values" then "COPY" . Maximum data points = 58 Selenium 331.2493 454.1579 0.7294 19 1.47 853.0 fag/L 1253.9 fag/L Date Data BDL=1/2DL 4 2.5 0.566 10.3 3.101 2.52 6.4 2.642 4.354 7.4 3.301 3.878 1.1 1.291 1.18 3.8 3.413 1.12 1.7 4 5 0.566 10.3 3.101 2.52 6.4 2.642 4.354 7.4 3.301 3.878 1.1 1.291 1.18 3.8 3.413 1.12 1.7 Results Std Dev. Mean C.V. n Mult Factor = Max. Value Max. Pred Cw NC0004961 _RPA Outfall 002A-2020_20210215, data - 12 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par20 Silver 2.4417 3.3982 0.7185 19 1.46 10.3 ug/L 15.0 ug/L Date Data BDL=1/2DL Results 1 < 1 0.5 Std Dev. 2 < 1 0.5 Mean 3 < 1 0.5 C.V. (default) 4 < 1 0.5 n 5 < 1 0.5 6 < 1 0.5 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 0.0000 0.5000 0.6000 6 2.14 0.500 ug/L 1.070 ug/L Date Data BDL=1/2DL Results 1 7.4 7.4 Std Dev. 2 3.5 3.5 Mean 3 5 5 C.V. 4 1530 1530 n 5 1520 1520 6 1240 1240 Mult Factor = 7 904 904 Max. Value 8 1300 1300 Max. Pred Cw 9 1250 1250 10 666 666 11 1290 1290 12 1150 1150 13 14.9 14.9 14 11 11 15 15 15 16 10.6 10.6 17 9 9 18 7 7 19 1020 1020 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 NC0004961 _RPA Outfall 002A-2020_20210215, data - 13 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS Use "PASTE SPECIAL• Par22 Values" then "COPY" . Maximum data points = 58 Thallium Date Data 632.8891 629.1263 1.0060 19 1.64 1530.0 ug/L 2509.2 ug/L 1 1 0.2 0.36 0.564 0.565 0.093 0.264 0.143 0.092 0.155 2 0.1 1 0.127 0.1 1 0.09 0.2 BDL=1/2DL 0.5 0.5 0.1 0.36 0.564 0.565 0.093 0.264 0.143 0.092 0.155 1 0.05 0.5 0.127 0.05 0.5 0.09 0.2 Results Std Dev. Mean C.V. n Mult Factor = Max. Value Max. Pred Cw Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 0.2554 0.3081 0.8292 19 1.53 1.000000 fag/L 1.530000 fag/L Par23 Nitrate nitrite Date Data 0.096 0.03 0.029 0.09 0.34 0.383 0.02 0.257 0.187 0.02 0.135 0.169 0.02 0.005 0.01 0.72 0.73 0.118 0.02 BDL=1/2DL 0.096 0.03 0.029 0.09 0.34 0.383 0.01 0.257 0.187 0.02 0.135 0.169 0.01 0.005 0.005 0.72 0.73 0.118 0.01 NC0004961 _RPA Outfall 002A-2020_20210215, data - 14 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS Results Std Dev. Mean C.V. n Mult Factor = Max. Value Max. Pred Cw Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par24 Aluminum 0.2244 0.1760 1.2751 19 1.79 0.730000 mg/L 1.306700 mg/L Date Data 86.3 43 15 42400 59800 51500 17600 23600 24200 18600 24200 24900 < 100 7 5.904 < 100 16 7.366 17900 BDL=1/2DL 86.3 43 15 42400 59800 51500 17600 23600 24200 18600 24200 24900 50 7 5.904 50 16 7.366 17900 Results Std Dev. Mean C.V. n Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par25 Antimony 18937.0537 16051.6089 1.1798 19 Mult Factor = 1.74 Max. Value ########## fag/L Max. Pred Cw ########## fag/L Date Data 0.12 5 1 0.15 5 1 0.21 5 1 0.53 5 1 0.12 5 1 0.21 5 1 0.16 BDL=1/2DL 0.12 2.5 0.5 0.15 2.5 0.5 0.21 2.5 0.5 0.53 2.5 0.5 0.12 2.5 0.5 0.21 2.5 0.5 0.16 NC0004961 _RPA Outfall 002A-2020_20210215, data - 15 - 2/19/2021 REASONABLE POTENTIAL ANALYSIS Results Std Dev. Mean C.V. n Mult Factor = Max. Value Max. Pred Cw Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 1.0390 1.0263 1.0124 19 1.64 2.500000 fag/L 4.100000 fag/L NC0004961 _RPA Outfall 002A-2020_20210215, data - 16 - 2/19/2021 Monitoring Frequencies 2B .0500 Effluent Limited pH E 2/Month 1/Week 3/Week Daily Temp, C E 1/Week 1/Week 3/Week Daily BODS I, E 2/Month 1/Week 3/Week Daily TSS I, E 2/Month 1/Week 3/Week Daily NH3-N E 1/Month 2/Month 1/Week 3/Week Fecal Col. E 2/Month 1/Week 3/Week Daily TN E See notes below. TP E See notes below. Water Quality Limited Frequency Parameter Location Class I Class II Class III Class IV D.O. E 1/Week 1/Week 3/Week Daily D.O. U, D 1 /Week 1 /Week 3/Week* 3/Week* pH E 2/Month 1/Week 3/Week Daily Temp, C E Daily Daily Daily Daily Temp, C U, D 1/Week 1/Week 3/Week* 3/Week* BODS I, E 2/Month 1/Week 3/Week Daily TSS I, E 2/Month 1/Week 3/Week Daily NH3-N E 1/Month 2/Month 1/Week 3/Week TRC E 2/Week 2/Week 3/Week Daily Fecal Col. E 2/Month 1/Week 3/Week Daily Fecal Col. U, D 2/Month 1/Week 3/Week* 3/Week* Conductivi E 1/Week 1/Week 3/Week Daily Conductivi U, D 1/Week 1/Week 3/Week* 3/Week* TN E See notes below. TP E See notes below. Notes: * Upstream and downstream monitoring in WQ-limited waters is to be conducted 3/Week during Jun, Jul, Aug, and Sep; and 1/Week during the rest of the year. TN, TP Monitoring All facilities >= 0.05 MGD will monitor TN and TP Those < 0.05 MGD will monitor if discharging to NSW For the Neuse, Tar -Pamlico, and any other river basins classified as NSW, use limits and monitoring requirements according to the basin's permitting strategy. For French Broad, Broad, Savannah, New Watauga, Little Tennessee, and Hiwassee: - >= 0.05 MC- monitor semi-annually - >= 1.0 MG - monitor quarterly For all other river basins: - >= 0.05 MC- monitor quarterly - >= 1.0 MG - monitor monthly Sample recommendat Msg00 Msg01 Msg02 Msg03 Msg04 Msg05 Msg06 Msg07 Msg08 Msg09 Msg10 < No Data Entered > MaxPredCw < Acute MaxPredCw < Chronic MaxPredCw « Acute MaxPredCw « Chronic MaxPredCw > Acute MaxPredCw > Chronic MaxPredCw » Acute MaxPredCw » Chronic No acute standard or 1/2 FAV No chronic standard or criterion NO DATA MONITOR? MONITOR? REMOVE? REMOVE? DAILY MAX LIMIT? MO AVG LIMIT? DAILY MAX LIMIT? MO AVG LIMIT? N/A N/A Daily max limit Monitor 1/month Monitor 1/week Monitor 2/month Monitoring not necess, No limit No limit - assuming nc No limit (Action Level Continue to monitor at Mo. avg. limit (keep w Revise daily max. limi Per Memo Dated 7-15-2010 RPA Condition Exists Permit Monitoring Frequency Monitor Monthly and add Permit Limit _1_RPA 2.RPA Exists but Action Levels (Cu, Zn, Ag ,Fe, CO Monitor Quarterly in conjunction with 1 3a.RPA Exists but Dataset Limited (n< 8 samples) 3b. RPA exists, dataset limited, but 2 values > allowable Cw Monitor Quarterly Monitor Monthly and add Permit Limit 4.No RPA (Predicted Max > 50% of Allowable) Monitor Quarterly (or defer to Pretreat I 5.No RPA (Predicted Max < 50% Allowable) No Monitoring 6a.No Data (New Permit, New Waste Stream) 6b. New Greensand or Conventional WTP Monitor Monthly for Toxic Pollutants a Monitor Quarterly for Toxic Pollutants password all sheets = rpa2017 4/28/16: Note Action Level designation no longer allowed per EPA. 11/20/17 Chlorides still listed as have action levels but will be coorected at next EPA review ions: ary in permit tox (Action Level parameter) parameter) 2/month k. avg. if existing) t "ox Test '..TMP) f Concern of Concern Riverbend Steam Station NC0004961 Qw (MGD) = 0.0400 1 Q 10S (cfs) = 65.40 7Q 1 OS (cfs) = 80.00 7Q1OW (cfs) = 80.00 30Q2 (cfs) = 80.00 Avg. Stream Flow, QA (cfs) = 2700.00 Receiving Stream: Catawba River Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators MAXIMUM DATA POINTS = 58 WWTP/WTP Class: IWC% @ 1 Q 10S = 0.094711436 IWC% @ 7Q 10S = 0.077439984 IWC% @ 7Q1OW = 0.077439984 IWC% @ 30Q2 = 0.077439984 IW%C @ QA = 0.002296244 Stream Class: WS-IV B-CA Outfall 002A Qw = 0.04 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 _1REASONABLE a 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 19 16 9.6 Acute (FW): 358,985.2 Chr_ onic(F__193_ 698 4 ____________________________ W): , Novalue > Allowable _Cw_____________________________ Chronic (Tin):435,493 9 No value > Allowable Cw no limit Beryllium NC 6.5 FW(7Q10s) 65 ug/L 19 11 114.87 Acute: 68,629.52 -- _ _ _ ---_ _ _ ---------------------------- Chronic:—8,393.60 No value > Allowable Cw no limit Cadmium NC 0.5899 FW(7Q10s) 3.2396 ug/L 19 13 16.983 Acute: 3,420.507 _ _ _ Chronic: 761 724----------------------------- -- _ _ _ ----761.724 No value > Allowable Cw no limit Chlorides NC 230 FW(7Q10s) mg/L 19 19 28.6 Acute: NO WQS -- _ _ _ --- _ _ _ ---------------------------- Chronic: 297,004.2 No value > Allowable Cw no limit Chlorinated Phenolic Compounds NC 1 A(30Q2) ug/L 0 0 N/A Acute: NO WQS -- _Chr_ _ _ onic:-----1,291.3 ----------------------------- N/A Total Phenolic Compounds NC 300 A(30Q2) ug/L 0 0 N/A Acute: NO WQS -- _Chr_ onic:--- 38_7,396-8 ---------------------------- N/A Chromium III NC 117.7325 FW(7Q10s) 905.0818 µg/L 0 0 N/A Acute: 955,620.4 -- _Chr_ _ onic:----152,030.7_ ---------------------------- no limit Chromium VI NC 11 FW(7Q10s) 16 µg/L 19 3 1.1 Acute: 16,893.4 -- _ _ _ ---_ _ ----------------------------- Chronic:—14,204.5 No value > Allowable Cw no limit Chromium, Total NC µg/L Tot Cr value(s) 19 18 > 5 but < Cr VI 182.1 Allowable Cw Max reported value = 84.7 Page 17 of 64 NC0004961_RPA Outfall 002A-2020_20210215, rpa 2/19/2021 Riverbend Steam Station NC0004961 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Outfall 002A Qw = 0.04 MGD Copper NC 7.8806 FW(7Q10s) 10.4720 ug/L 19 17 584.80 Acute: 11,056.74 -- _ _ _ ---_ _ _ ---------------------------- Chronic:—10,176.45 No value > Allowable Cw no limit Cyanide NC 5 FW(7Q10s) 22 10 ug/L 0 0 N/A Acute: 23,228.5 -- _ _ _ ---- _ _ ----------------------------- Chronic: 6,456.E N/A Fluoride NC 1800 FW(7Q10s) ug/L 13 8 8.6 Acute: NO WQS -- _ _ _ --- _ _ _ _ ---------------------------- Chronic: 2,324,380.6 No value > Allowable Cw no limit Lead NC 2.9416 FW(7Q10s) 75.4871 ug/L 19 10 8.745 Acute: 79,702.207 -- _ _ _ --- _ _ _ ---------------------------- Chronic: 3,798.58E No value > Allowable Cw no limit Mercury NC 12 FW(7Q10s) 0.5 ng/L 19 0 143.0 NO DETECTS Acute: NO WQS _ _ _ _ _ _ -- Chronic:----15,495.9 - Max MDL = 200 no limit —-—-—-—-—-—-—-—-—-—-—-—-—-— Molybdenum NC 2000 HH(7Q10s) ug/L 19 17 5.6 Acute: NO WQS -- _ _ _ --- _ _ _ _ ---------------------------- Chronic: 2,582,645.2 No value > Allowable Cw no limit Nickel Nickel NC NC 37.2313 FW(7Q10s) 335.2087 25.0000 WS(7Q10s) µg/L µ 19 19 1,253.9 Acute (FW): 353,926.3 Chr onic(F__,077.7 _ _____________________________ W): 48 No_ value>Allowable 2_Cw_ _ _ Chronic (WS): 3,283.1 No value > Allowable Cw no limit _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Selenium NC 5 FW(7Q10s) 56 ug/L 19 18 15.0 Acute: 59,127.0 -- _ _ _ ---- _ _ ----------------------------- Chronic: 6,456.E No value > Allowable Cw no limit Silver NC 0.06 FW(7Q10s) 0.2964 ug/L 6 0 Note: n < 9 Limited data set 1.070 C.V. (default) NO DETECTS Acute: 312.948 ___ _ _______ _ _____________________________ Chronic: 77.479 Max MDL = 1 no limit Zinc NC 126.7335 FW(7Q10s) 125.7052 ug/L 19 19 2,509.2 Acute: 132,724.4 -- _ _ _ ---_ _ -8 ---------------------------- Chronic:—163,653 No value > Allowable Cw no limit Thallium NC 2 FW(7Q10s) µg/L 19 11 1.53000 Acute: NO WQS -- _ _ _ --- _ _ _ _ ---------------------------- Chronic: 2582.64516 No value > Allowable Cw no limit Nitrate nitrite NC 10 WS(7Q10s) mg/L 19 15 1.30670 Acute: NO WQS -- _ _ _ --- _ _ _ _ ---------------------------- Chronic: 12913.22581 No value > Allowable Cw no limit. Acute: NO WQS ,r,';_;+ Page 18 of 64 NC0004961_RPA Outfall 002A-2020_20210215, rpa 2/19/2021 Riverbend Steam Station NC0004961 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Outfall 002A Qw = 0.04 MGD Aluminum NC 6500 WS(7Q10s) µg/L 19 17 104,052.00000 _ _ _ _ _ _ _ _ _ _ _ _ ########### ___________________________ Chronic: No value > Allowable Cw Acute: NO WQS no limit Antimony NC 5.6 WS(7Q10s) µg/L 19 7 4.10000 _ _ _ _ _ _ _ _ _ _ _ _____________________________ Chronic: 7231.40645 No value > Allowable Cw NC0004961_RPA Outfall 002A-2020_20210215, rpa Page 19 of 64 2/19/2021 Reasonable Potential Multiplying Factors - Calculator 95.0% 95.0% Confidence Level Upper Boundary of the Effluent Distribution (Percentile Value Not To Exceed) Coefficient of Variation n 0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1 1.2 1.3 1.4 1 1.00 ..59 1.92 2.63 3.55 ../3 6.20 7.98 10.11 12.60 1S.47 18.72 22.35 26.38 30.78 2 1.00 1.27 1.61 2.03 2.53 3.11 3.79 4.57 5.43 6.38 7.41 8.51 9.69 10.94 12.25 3 1.00 1.22 1.48 1.79 2.15 2.55 3.00 3.49 4.03 4.60 5.20 5.84 6.49 7.17 7.87 4 1.00 1.19 1.40 1.65 1.93 2.25 2.59 2.95 3.34 3.74 4.16 4.60 5.04 5.50 5.96 5 1.00 1.16 1.35 1.56 1.80 2.05 2.32 2.61 2.91 3.23 3.55 3.87 4.21 4.54 4.88 6 1.00 1.15 1.31 1.50 1.70 1.91 2.14 2.38 2.63 2.88 3.14 3.40 3.66 3.92 4.18 7 1.00 1.13 1.28 1.45 1.62 1.81 2.01 2.21 2.42 2.63 2.84 3.06 3.27 3.48 3.69 8 1.00 1.12 1.26 1.40 1.56 1.73 1.90 2.07 2.25 2.44 2.62 2.80 2.98 3.16 3.33 9 1.00 1.11 1.24 1.37 1.51 1.6E 1.81 1.97 2.12 2.28 2.44 2.60 2.75 2.90 3.05 10 1.00 1.10 1.22 1.34 1.47 1.60 1.74 1.88 2.02 2.16 2.30 2.43 2.57 2.70 2.83 11 1.00 1.10 1.20 1.32 1.43 1.55 1.68 1.80 1.93 2.05 2.18 2.30 2.41 2.53 2.64 12 1.00 1.09 1.19 1.29 1.40 1.51 1.63 1.74 1.85 1.96 2.07 2.18 2.29 2.39 2.49 13 1.00 1.09 1.18 1.27 1.37 1.48 1.58 1.68 1.79 1.89 1.99 2.08 2.18 2.27 2.36 14 1.00 1.08 1.17 1.26 1.35 1.44 1.54 1.63 1.73 1.82 1.91 2.00 2.08 2.17 2.25 15 1.00 1.08 1.16 1.24 1.33 1.41 1.50 1.59 1.68 1.76 1.84 1.92 2.00 2.07 2.15 16 1.00 1.07 1.15 1.23 1.31 1.39 1.47 1.55 1.63 1.71 1.78 1.85 1.93 1.99 2.06 17 1.00 1.07 1.14 1.21 1.29 1.36 1.44 1.51 1.59 1.66 1.73 1.79 1.86 1.92 1.98 18 1.00 1.06 1.13 1.20 1.27 1.34 1.41 1.48 1.55 1.62 1.68 1.74 1.80 1.86 1.91 19 1.00 1.06 1.12 1.19 1.26 1.32 1.39 1.45 1.51 1.58 1.64 1.69 1.75 1.80 1.85 20 1.00 1.06 1.12 1.18 1.24 1.30 1.36 1.42 1.48 1.54 1.59 1.65 1.70 1.75 1.79 21 1.00 1.05 1.11 1.17 1.23 1.29 1.34 1.40 1.45 1.51 1.56 1.61 1.65 1.70 1.74 22 1.00 1.05 1.11 1.16 1.22 1.27 1.32 1.38 1.43 1.48 1.52 1.57 1.61 1.65 1.69 23 1.00 1.05 1.10 1.15 1.20 1.25 1.31 1.35 1.40 1.45 1.49 1.53 1.57 1.61 1.65 24 1.00 1.05 1.09 1.14 1.19 1.24 1.29 1.33 1.38 1.42 1.46 1.50 1.54 1.57 1.61 25 1.00 1.04 1.09 1.14 1.18 1.23 1.27 1.32 1.36 1.40 1.43 1.47 1.51 1.54 1.57 26 1.00 1.04 1.09 1.13 1.17 1.21 1.26 1.30 1.34 1.37 1.41 1.44 1.48 1.51 1.54 27 1.00 1.04 1.08 1.12 1.16 1.20 1.24 1.28 1.32 1.35 1.39 1.42 1.45 1.48 1.50 28 1.00 1.04 1.08 1.12 1.15 1.19 1.23 1.26 1.30 1.33 1.36 1.39 1.42 1.45 1.47 29 1.00 1.04 1.07 1.11 1.15 1.18 1.22 1.25 1.28 1.31 1.34 1.37 1.40 1.42 1.44 30 1.00 1.03 1.07 1.10 1.14 1.17 1.20 1.24 1.27 1.29 1.32 1.35 1.37 1.39 1.42 31 1.00 1.03 1.06 1.10 1.13 1.16 1.19 1.22 1.25 1.28 1.30 1.33 1.35 1.37 1.39 32 1.00 1.03 1.06 1.09 1.12 1.15 1.18 1.21 1.24 1.26 1.28 1.31 1.33 1.35 1.37 33 1.00 1.03 1.06 1.09 1.12 1.14 1.17 1.20 1.22 1.24 1.27 1.29 1.31 1.33 1.34 34 1.00 1.03 1.05 1.08 1.11 1.14 1.16 1.18 1.21 1.23 1.25 1.27 1.29 1.31 1.32 35 1.00 1.03 1.05 1.08 1.10 1.13 1.15 1.17 1.20 1.22 1.23 1.25 1.27 1.29 1.30 36 1.00 1.02 1.05 1.07 1.10 1.12 1.14 1.16 1.18 1.20 1.22 1.24 1.25 1.27 1.28 37 1.00 1.02 1.05 1.07 1.09 1.11 1.13 1.15 1.17 1.19 1.21 1.22 1.24 1.25 1.26 38 1.00 1.02 1.04 1.06 1.08 1.10 1.12 1.14 1.16 1.18 1.19 1.21 1.22 1.23 1.25 39 1.00 1.02 1.04 1.06 1.08 1.10 1.12 1.13 1.15 1.16 1.18 1.19 1.21 1.22 1.23 40 1.00 1.02 1.04 1.06 1.07 1.09 1.11 1.12 1.14 1.15 1.17 1.18 1.19 1.20 1.21 41 1.00 1.02 1.03 1.05 1.07 1.08 1.10 1.12 1.13 1.14 1.15 1.17 1.18 1.19 1.20 42 1.00 1.02 1.03 1.05 1.06 1.08 1.09 1.11 1.12 1.13 1.14 1.15 1.16 1.17 1.18 43 1.00 1.01 1.03 1.04 1.06 1.07 1.09 1.10 1.11 1.12 1.13 1.14 1.15 1.16 1.17 44 1.00 1.01 1.03 1.04 1.05 1.07 1.08 1.09 1.10 1.11 1.12 1.13 1.14 1.15 1.15 45 1.00 1.01 1.03 1.04 1.05 1.06 1.07 1.08 1.09 1.10 1.11 1.12 1.13 1.13 1.14 46 1.00 1.01 1.02 1.03 1.05 1.06 1.07 1.08 1.08 1.09 1.10 1.11 1.11 1.12 1.13 47 1.00 1.01 1.02 1.03 1.04 1.05 1.06 1.07 1.08 1.08 1.09 1.10 1.10 1.11 1.12 48 1.00 1.01 1.02 1.03 1.04 1.05 1.05 1.06 1.07 1.08 1.08 1.09 1.09 1.10 1.10 49 1.00 1.01 1.02 1.03 1.03 1.04 1.05 1.05 1.06 1.07 1.07 1.08 1.08 1.09 1.09 50 1.00 1.01 1.01 1.02 1.03 1.04 1.04 1.05 1.05 1.06 1.06 1.07 1.07 1.08 1.08 51 1.00 1.01 1.01 1.02 1.03 1.03 1.04 1.04 1.05 1.05 1.06 1.06 1.06 1.07 1.07 52 1.00 1.01 1.01 1.02 1.02 1.03 1.03 1.04 1.04 1.04 1.05 1.05 1.05 1.06 1.06 53 1.00 1.00 1.01 1.01 1.02 1.02 1.03 1.03 1.03 1.04 1.04 1.04 1.04 1.05 1.05 54 1.00 1.00 1.01 1.01 1.01 1.02 1.02 1.02 1.03 1.03 1.03 1.03 1.04 1.04 1.04 55 1.00 1.00 1.01 1.01 1.01 1.01 1.02 1.02 1.02 1.02 1.02 1.03 1.03 1.03 1.03 56 1.00 1.00 1.00 1.01 1.01 1.01 1.01 1.01 1.01 1.02 1.02 1.02 1.02 1.02 1.02 57 1.00 1.00 1.00 1.00 1.00 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 58 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1 1.2 1.3 1.4 Multiplication Factor RPMFs as f(n,CV,Confidence,U pperBound) 400.00 350.00 300.00 _' 250.00 7 J 200.00 y� 150.00 J 100.00 50.00 0.00 1 4 7 10 13 16 19 22 25 0 N 350.00-400.00 300.00-350.00 250.00-300.00 200.00-250.00 150.00-200.00 100.00-150.00 50.00-100.00 0.00-50.00 1.5 1.6 1.7 1.8 1.9 2.0 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 35.57 40.73 46.26 52.14 58.37 64.94 71.84 79.06 86.58 94.41 102.53 110.94 119.62 128.56 13.61 15.03 16.49 18.00 19.55 21.14 22.75 24.40 26.08 27.79 29.51 31.26 33.03 34.82 8.59 9.32 10.06 10.81 11.58 12.34 13.12 13.90 14.68 15.46 16.25 17.04 17.83 18.62 6.42 6.89 7.36 7.84 8.31 8.79 9.26 9.73 10.20 10.68 11.14 11.61 12.07 12.54 5.21 5.55 5.89 6.22 6.56 6.89 7.22 7.54 7.87 8.19 8.51 8.82 9.13 9.44 4.44 4.70 4.96 5.21 5.46 5.71 5.96 6.20 6.44 6.68 6.91 7.14 7.37 7.60 3.90 4.11 4.32 4.52 4.72 4.91 5.10 5.29 5.48 5.67 5.85 6.02 6.20 6.37 3.51 3.68 3.85 4.01 4.17 4.33 4.49 4.64 4.79 4.94 5.09 5.23 5.37 5.51 3.20 3.34 3.49 3.62 3.76 3.89 4.02 4.15 4.27 4.40 1-.52 4.63 4.75 4.86 2.95 3.08 3.20 3.32 3.43 3.55 3.66 3.77 3.87 3.97 4.07 4.17 4.27 4.36 2.75 2.86 2.97 3.07 3.17 3.27 3.36 3.46 3.55 3.63 3.72 3.80 3.89 3.97 2.59 2.68 2.78 2.87 2.95 3.04 3.12 3.20 3.28 3.36 3.43 3.50 3.57 3.64 2.45 2.53 2.61 2.69 2.77 2.84 2.92 2.99 3.06 3.12 3.19 3.25 3.31 3.37 2.32 2.40 2.47 2.54 2.61 2.68 2.74 2.81 2.87 2.93 2.98 3.04 3.09 3.15 2.22 2.29 2.35 2.41 2.48 2.54 2.59 2.65 2.70 2.76 2.81 2.86 2.91 2.95 2.12 2.19 2.24 2.30 2.36 2.41 2.46 2.51 2.56 2.61 2.65 2.70 2.74 2.78 2.04 2.10 2.15 2.20 2.25 2.30 2.35 2.39 2.44 2.48 2.52 2.56 2.60 2.64 1.97 2.02 2.07 2.11 2.16 2.20 2.25 2.29 2.33 2.36 2.40 2.44 2.47 2.51 1.90 1.95 1.99 2.03 2.08 2.12 2.15 2.19 2.23 2.26 2.30 2.33 2.36 2.39 1.84 1.88 1.92 1.96 2.00 2.04 2.07 2.11 2.14 2.17 2.20 2.23 2.26 2.29 1.78 1.82 1.86 1.90 1.93 1.96 2.00 2.03 2.06 2.09 2.12 2.14 2.17 2.19 1.73 1.77 1.80 1.84 1.87 1.90 1.93 1.96 1.99 2.01 2.04 2.06 2.09 2.11 1.68 1.72 1.75 1.78 1.81 1.84 1.87 1.89 1.92 1.94 1.97 1.99 2.01 2.03 1.64 1.67 1.70 1.73 1.76 1.78 1.81 1.83 1.86 1.88 1.90 1.92 1.94 1.96 1.60 1.63 1.66 1.68 1.71 1.73 1.76 1.78 1.80 1.82 1.84 1.86 1.88 1.90 1.56 1.59 1.62 1.64 1.66 1.69 1.71 1.73 1.75 1.77 1.79 1.80 1.82 1.84 1.53 1.55 1.58 1.60 1.62 1.64 1.66 1.68 1.70 1.72 1.73 1.75 1.77 1.78 1.50 1.52 1.54 1.56 1.58 1.60 1.62 1.64 1.66 1.67 1.69 1.70 1.72 1.73 1.47 1.49 1.51 1.53 1.55 1.56 1.58 1.60 1.61 1.63 1.64 1.66 1.67 1.68 1.44 1.46 1.48 1.49 1.51 1.53 1.54 1.56 1.57 1.59 1.60 1.61 1.63 1.64 1.41 1.43 1.45 1.46 1.48 1.50 1.51 1.52 1.54 1.55 1.56 1.57 1.59 1.60 1.39 1.40 1.42 1.43 1.45 1.46 1.48 1.49 1.50 1.51 1.53 1.54 1.55 1.56 1.36 1.38 1.39 1.41 1.42 1.43 1.45 1.46 1.47 1.48 1.49 1.50 1.51 1.52 1.34 1.35 1.37 1.38 1.39 1.41 1.42 1.43 1.44 1.45 1.46 1.47 1.48 1.49 1.32 1.33 1.34 1.36 1.37 1.38 1.39 1.40 1.41 1.42 1.43 1.44 1.45 1.45 1.30 1.31 1.32 1.33 1.34 1.35 1.36 1.37 1.38 1.39 1.40 1.41 1.42 1.42 1.28 1.29 1.30 1.31 1.32 1.33 1.34 1.35 1.36 1.36 1.37 1.38 1.39 1.39 1.26 1.27 1.28 1.29 1.30 1.31 1.32 1.32 1.33 1.34 1.35 1.35 1.36 1.37 1.24 1.25 1.26 1.27 1.28 1.29 1.29 1.30 1.31 1.31 1.32 1.33 1.33 1.34 1.22 1.23 1.24 1.25 1.26 1.26 1.27 1.28 1.29 1.29 1.30 1.30 1.31 1.31 1.21 1.21 1.22 1.23 1.24 1.24 1.25 1.26 1.26 1.27 1.27 1.28 1.29 1.29 1.19 1.20 1.21 1.21 1.22 1.23 1.23 1.24 1.24 1.25 1.25 1.26 1.26 1.27 1.18 1.18 1.19 1.20 1.20 1.21 1.21 1.22 1.22 1.23 1.23 1.24 1.24 1.25 1.16 1.17 1.17 1.18 1.18 1.19 1.20 1.20 1.20 1.21 1.21 1.22 1.22 1.22 1.15 1.15 1.16 1.16 1.17 1.17 1.18 1.18 1.19 1.19 1.19 1.20 1.20 1.20 1.13 1.14 1.14 1.15 1.15 1.16 1.16 1.17 1.17 1.17 1.18 1.18 1.18 1.19 1.12 1.13 1.13 1.13 1.14 1.14 1.15 1.15 1.15 1.16 1.16 1.16 1.16 1.17 1.11 1.11 1.12 1.12 1.12 1.13 1.13 1.13 1.14 1.14 1.14 1.14 1.15 1.15 1.10 1.10 1.10 1.11 1.11 1.11 1.12 1.12 1.12 1.12 1.13 1.13 1.13 1.13 1.08 1.09 1.09 1.09 1.10 1.10 1.10 1.10 1.11 1.11 1.11 1.11 1.11 1.12 1.07 1.08 1.08 1.08 1.08 1.09 1.09 1.09 1.09 1.09 1.10 1.10 1.10 1.10 1.06 1.06 1.07 1.07 1.07 1.07 1.07 1.08 1.08 1.08 1.08 1.08 1.08 1.09 1.05 1.05 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.07 1.07 1.07 1.07 1.07 1.04 1.04 1.04 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.06 1.06 1.03 1.03 1.03 1.03 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.02 1.02 1.02 1.02 1.02 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.01 1.01 1.01 1.01 1.01 1.01 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.5 1.6 1.7 1.8 1.9 2.0 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 Coefficient of Variation 2.9 3.0 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4.0 137.76 147.21 156.91 166.84 177.00 187.38 197.98 208.78 219.79 231.00 242.40 253.99 36.63 38.45 40.28 42.13 43.99 45.86 47.74 49.64 51.54 53.44 55.36 57.28 19.41 20.21 21.00 21.79 22.58 23.36 24.15 24.94 25.72 26.50 27.28 28.06 13.00 13.45 13.91 14.36 14.81 15.25 15.70 16.14 16.58 17.01 17.44 17.87 9.75 10.05 10.36 10.65 10.95 11.24 11.53 11.82 12.10 12.38 12.66 12.94 7.82 8.04 8.25 8.47 8.68 8.89 9.10 9.30 9.50 9.70 9.90 10.09 6.54 6.71 6.88 7.04 7.20 7.36 7.51 7.67 7.82 7.97 8.12 8.26 5.64 5.78 5.91 6.03 6.16 6.29 6.41 6.53 6.65 6.77 6.88 6.99 4.97 5.08 5.19 5.29 5.40 5.50 5.60 5.69 5.79 5.88 5.98 6.07 4.46 4.55 4.64 4.72 4.81 4.89 4.97 5.06 5.13 5.21 5.29 5.36 4.05 4.12 4.20 4.27 4.34 4.41 4.48 4.55 4.62 4.68 4.75 4.81 3.71 3.78 3.84 3.90 3.97 4.03 4.09 4.15 4.20 4.26 4.31 4.37 3.43 3.49 3.55 3.60 3.66 3.71 3.76 3.81 3.86 3.91 3.96 4.00 3.20 3.25 3.30 3.35 3.39 3.44 3.48 3.53 3.57 3.61 3.66 3.70 3.00 3.04 3.09 3.13 3.17 3.21 3.25 3.29 3.33 3.36 3.40 3.44 2.83 2.86 2.90 2.94 2.98 3.01 3.05 3.08 3.12 3.15 3.18 3.21 2.67 2.71 2.74 2.78 2.81 2.84 2.87 2.90 2.93 2.96 2.99 3.02 2.54 2.57 2.60 2.63 2.66 2.69 2.72 2.75 2.77 2.80 2.83 2.85 2.42 2.45 2.48 2.51 2.53 2.56 2.58 2.61 2.63 2.66 2.68 2.70 2.31 2.34 2.37 2.39 2.42 2.44 2.46 2.48 2.51 2.53 2.55 2.57 2.22 2.24 2.27 2.29 2.31 2.33 2.35 2.37 2.39 2.41 2.43 2.45 2.13 2.15 2.18 2.20 2.22 2.24 2.25 2.27 2.29 2.31 2.33 2.34 2.05 2.07 2.09 2.11 2.13 2.15 2.16 2.18 2.20 2.21 2.23 2.24 1.98 2.00 2.02 2.03 2.05 2.07 2.08 2.10 2.11 2.13 2.14 2.16 1.91 1.93 1.95 1.96 1.98 1.99 2.01 2.02 2.04 2.05 2.06 2.08 1.85 1.87 1.88 1.90 1.91 1.93 1.94 1.95 1.97 1.98 1.99 2.00 1.80 1.81 1.82 1.84 1.85 1.86 1.88 1.89 1.90 1.91 1.92 1.93 1.74 1.76 1.77 1.78 1.79 1.81 1.82 1.83 1.84 1.85 1.86 1.87 1.70 1.71 1.72 1.73 1.74 1.75 1.76 1.77 1.78 1.79 1.80 1.81 1.65 1.66 1.67 1.68 1.69 1.70 1.71 1.72 1.73 1.74 1.75 1.76 1.61 1.62 1.63 1.64 1.65 1.66 1.66 1.67 1.68 1.69 1.70 1.71 1.57 1.58 1.59 1.60 1.60 1.61 1.62 1.63 1.64 1.64 1.65 1.66 1.53 1.54 1.55 1.56 1.56 1.57 1.58 1.59 1.59 1.60 1.61 1.61 1.49 1.50 1.51 1.52 1.53 1.53 1.54 1.55 1.55 1.56 1.57 1.57 1.46 1.47 1.48 1.48 1.49 1.50 1.50 1.51 1.51 1.52 1.53 1.53 1.43 1.44 1.44 1.45 1.46 1.46 1.47 1.47 1.48 1.48 1.49 1.49 1.40 1.41 1.41 1.42 1.42 1.43 1.43 1.44 1.45 1.45 1.45 1.46 1.37 1.38 1.38 1.39 1.39 1.40 1.40 1.41 1.41 1.42 1.42 1.43 1.34 1.35 1.36 1.36 1.37 1.37 1.37 1.38 1.38 1.39 1.39 1.40 1.32 1.32 1.33 1.33 1.34 1.34 1.35 1.35 1.35 1.36 1.36 1.37 1.29 1.30 1.30 1.31 1.31 1.32 1.32 1.32 1.33 1.33 1.33 1.34 1.27 1.28 1.28 1.28 1.29 1.29 1.29 1.30 1.30 1.30 1.31 1.31 1.25 1.25 1.26 1.26 1.26 1.27 1.27 1.27 1.28 1.28 1.28 1.28 1.23 1.23 1.23 1.24 1.24 1.24 1.25 1.25 1.25 1.25 1.26 1.26 1.21 1.21 1.21 1.22 1.22 1.22 1.22 1.23 1.23 1.23 1.23 1.24 1.19 1.19 1.19 1.20 1.20 1.20 1.20 1.21 1.21 1.21 1.21 1.21 1.17 1.17 1.17 1.18 1.18 1.18 1.18 1.19 1.19 1.19 1.19 1.19 1.15 1.15 1.16 1.16 1.16 1.16 1.16 1.17 1.17 1.17 1.17 1.17 1.13 1.14 1.14 1.14 1.14 1.14 1.14 1.15 1.15 1.15 1.15 1.15 1.12 1.12 1.12 1.12 1.12 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.10 1.10 1.10 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.12 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.10 1.10 1.10 1.10 1.07 1.07 1.07 1.07 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.06 1.04 1.04 1.04 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.00 1.00 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 2.9 3.0 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4.0 Coefficient of Variation 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 5.0 5.1 5.2 265.76 277.71 289.83 302.12 314.57 327.19 339.96 352.88 365.95 379.17 392.53 406.03 59.21 61.15 63.09 65.03 66.98 68.93 70.89 72.85 74.81 76.78 78.75 80.72 28.84 29.61 30.38 31.15 31.92 32.68 33.44 34.20 34.96 35.72 36.47 37.22 18.30 18.72 19.14 19.56 19.98 20.39 20.80 21.21 21.61 22.02 22.42 22.82 13.21 13.48 13.75 14.02 14.28 14.55 14.81 15.06 15.32 15.57 15.82 16.07 10.29 10.48 10.66 10.85 11.04 11.22 11.40 11.58 11.76 11.93 12.10 12.28 8.41 8.55 8.69 8.83 8.96 9.10 9.23 9.37 9.50 9.63 9.75 9.88 7.11 7.22 7.33 7.43 7.54 7.65 7.75 7.85 7.95 8.05 8.15 8.25 6.16 6.25 6.34 6.42 6.51 6.59 6.67 6.76 6.84 6.91 6.99 7.07 5.44 5.51 5.58 5.65 5.72 5.79 5.86 5.93 5.99 6.06 6.12 6.19 4.87 4.94 5.00 5.05 5.11 5.17 5.23 5.28 5.34 5.39 5.44 5.50 4.42 4.47 4.52 4.57 4.62 4.67 4.72 4.77 4.81 4.86 4.90 4.95 4.05 4.09 4.14 4.18 4.22 4.26 4.30 4.35 4.38 4.42 4.46 4.50 3.74 3.77 3.81 3.85 3.89 3.92 3.96 3.99 4.03 4.06 4.10 4.13 3.47 3.51 3.54 3.57 3.60 3.64 3.67 3.70 3.73 3.76 3.79 3.82 3.24 3.28 3.30 3.33 3.36 3.39 3.42 3.44 3.47 3.50 3.52 3.55 3.05 3.08 3.10 3.13 3.15 3.18 3.20 3.23 3.25 3.27 3.30 3.32 2.88 2.90 2.92 2.95 2.97 2.99 3.01 3.03 3.06 3.08 3.10 3.12 2.72 2.75 2.77 2.79 2.81 2.83 2.85 2.87 2.89 2.90 2.92 2.94 2.59 2.61 2.63 2.65 2.66 2.68 2.70 2.72 2.73 2.75 2.77 2.78 2.47 2.49 2.50 2.52 2.54 2.55 2.57 2.58 2.60 2.61 2.63 2.64 2.36 2.37 2.39 2.41 2.42 2.44 2.45 2.46 2.48 2.49 2.50 2.52 2.26 2.27 2.29 2.30 2.32 2.33 2.34 2.36 2.37 2.38 2.39 2.40 2.17 2.18 2.20 2.21 2.22 2.23 2.25 2.26 2.27 2.28 2.29 2.30 2.09 2.10 2.11 2.12 2.13 2.15 2.16 2.17 2.18 2.19 2.20 2.21 2.01 2.02 2.03 2.04 2.06 2.07 2.08 2.09 2.09 2.10 2.11 2.12 1.94 1.95 1.96 1.97 1.98 1.99 2.00 2.01 2.02 2.03 2.04 2.04 1.88 1.89 1.90 1.91 1.91 1.92 1.93 1.94 1.95 1.96 1.96 1.97 1.82 1.83 1.84 1.84 1.85 1.86 1.87 1.88 1.88 1.89 1.90 1.90 1.76 1.77 1.78 1.79 1.79 1.80 1.81 1.82 1.82 1.83 1.84 1.84 1.71 1.72 1.73 1.73 1.74 1.75 1.75 1.76 1.77 1.77 1.78 1.78 1.66 1.67 1.68 1.68 1.69 1.70 1.70 1.71 1.71 1.72 1.72 1.73 1.62 1.63 1.63 1.64 1.64 1.65 1.65 1.66 1.66 1.67 1.67 1.68 1.58 1.58 1.59 1.59 1.60 1.60 1.61 1.61 1.62 1.62 1.63 1.63 1.54 1.54 1.55 1.55 1.56 1.56 1.57 1.57 1.58 1.58 1.58 1.59 1.50 1.50 1.51 1.51 1.52 1.52 1.53 1.53 1.53 1.54 1.54 1.55 1.46 1.47 1.47 1.48 1.48 1.49 1.49 1.49 1.50 1.50 1.50 1.51 1.43 1.43 1.44 1.44 1.45 1.45 1.45 1.46 1.46 1.46 1.47 1.47 1.40 1.40 1.41 1.41 1.41 1.42 1.42 1.42 1.43 1.43 1.43 1.43 1.37 1.37 1.38 1.38 1.38 1.38 1.39 1.39 1.39 1.40 1.40 1.40 1.34 1.34 1.35 1.35 1.35 1.35 1.36 1.36 1.36 1.37 1.37 1.37 1.31 1.32 1.32 1.32 1.32 1.33 1.33 1.33 1.33 1.34 1.34 1.34 1.29 1.29 1.29 1.29 1.30 1.30 1.30 1.30 1.31 1.31 1.31 1.31 1.26 1.26 1.27 1.27 1.27 1.27 1.28 1.28 1.28 1.28 1.28 1.28 1.24 1.24 1.24 1.24 1.25 1.25 1.25 1.25 1.25 1.26 1.26 1.26 1.22 1.22 1.22 1.22 1.22 1.22 1.23 1.23 1.23 1.23 1.23 1.23 1.19 1.20 1.20 1.20 1.20 1.20 1.20 1.21 1.21 1.21 1.21 1.21 1.17 1.18 1.18 1.18 1.18 1.18 1.18 1.18 1.18 1.19 1.19 1.19 1.15 1.15 1.16 1.16 1.16 1.16 1.16 1.16 1.16 1.16 1.17 1.17 1.13 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.15 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.13 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.11 1.11 1.11 1.08 1.08 1.08 1.08 1.08 1.08 1.09 1.09 1.09 1.09 1.09 1.09 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.03 1.03 1.03 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 5.0 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 6.0 6.1 n 419.66 433.43 447.33 461.35 475.50 489.76 504.15 518.65 533.27 1 82.69 84.67 86.64 88.62 90.60 92.58 94.56 96.54 98.52 2 37.97 38.71 39.46 40.20 40.93 41.67 42.40 43.13 43.86 3 23.21 23.61 24.00 24.39 24.77 25.16 25.54 25.92 26.30 4 16.32 16.56 16.81 17.05 17.29 17.53 17.76 18.00 18.23 5 12.45 12.62 12.78 12.95 13.11 13.28 13.44 13.60 13.76 6 10.01 10.13 10.25 10.37 10.49 10.61 10.73 10.85 10.96 7 8.34 8.44 8.53 8.63 8.72 8.81 8.90 8.99 9.08 8 7.15 7.22 7.30 7.37 7.44 7.52 7.59 7.66 7.73 9 6.25 6.31 6.37 6.43 6.49 6.55 6.61 6.66 6.72 10 5.55 5.60 5.65 5.70 5.75 5.80 5.85 5.89 5.94 11 4.99 5.03 5.08 5.12 5.16 5.20 5.24 5.28 5.32 12 4.54 4.57 4.61 4.65 4.68 4.72 4.75 4.78 4.82 13 4.16 4.19 4.22 4.26 4.29 4.32 4.35 4.37 4.40 14 3.84 3.87 3.90 3.93 3.95 3.98 4.00 4.03 4.05 15 3.57 3.60 3.62 3.65 3.67 3.69 3.71 3.74 3.76 16 3.34 3.36 3.38 3.40 3.42 3.44 3.46 3.48 3.50 17 3.14 3.16 3.17 3.19 3.21 3.23 3.25 3.26 3.28 18 2.96 2.97 2.99 3.01 3.02 3.04 3.06 3.07 3.09 19 2.80 2.81 2.83 2.84 2.86 2.87 2.89 2.90 2.91 20 2.66 2.67 2.68 2.70 2.71 2.72 2.74 2.75 2.76 21 2.53 2.54 2.56 2.57 2.58 2.59 2.60 2.61 2.63 22 2.42 2.43 2.44 2.45 2.46 2.47 2.48 2.49 2.50 23 2.31 2.32 2.33 2.34 2.35 2.36 2.37 2.38 2.39 24 2.22 2.23 2.24 2.25 2.25 2.26 2.27 2.28 2.29 25 2.13 2.14 2.15 2.16 2.16 2.17 2.18 2.19 2.20 26 2.05 2.06 2.07 2.07 2.08 2.09 2.10 2.10 2.11 27 1.98 1.99 1.99 2.00 2.01 2.01 2.02 2.03 2.03 28 1.91 1.92 1.92 1.93 1.94 1.94 1.95 1.95 1.96 29 1.85 1.85 1.86 1.87 1.87 1.88 1.88 1.89 1.89 30 1.79 1.80 1.80 1.81 1.81 1.82 1.82 1.83 1.83 31 1.74 1.74 1.75 1.75 1.76 1.76 1.76 1.77 1.77 32 1.68 1.69 1.69 1.70 1.70 1.71 1.71 1.72 1.72 33 1.64 1.64 1.65 1.65 1.65 1.66 1.66 1.67 1.67 34 1.59 1.60 1.60 1.60 1.61 1.61 1.61 1.62 1.62 35 1.55 1.55 1.56 1.56 1.56 1.57 1.57 1.57 1.58 36 1.51 1.51 1.52 1.52 1.52 1.53 1.53 1.53 1.54 37 1.47 1.48 1.48 1.48 1.48 1.49 1.49 1.49 1.50 38 1.44 1.44 1.44 1.45 1.45 1.45 1.45 1.46 1.46 39 1.40 1.41 1.41 1.41 1.41 1.42 1.42 1.42 1.42 40 1.37 1.37 1.38 1.38 1.38 1.38 1.39 1.39 1.39 41 1.34 1.34 1.35 1.35 1.35 1.35 1.35 1.36 1.36 42 1.31 1.32 1.32 1.32 1.32 1.32 1.32 1.33 1.33 43 1.29 1.29 1.29 1.29 1.29 1.29 1.30 1.30 1.30 44 1.26 1.26 1.26 1.26 1.27 1.27 1.27 1.27 1.27 45 1.24 1.24 1.24 1.24 1.24 1.24 1.24 1.24 1.25 46 1.21 1.21 1.21 1.22 1.22 1.22 1.22 1.22 1.22 47 1.19 1.19 1.19 1.19 1.19 1.19 1.20 1.20 1.20 48 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 49 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 50 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 51 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 52 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 53 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 54 1.05 1.05 1.05 1.05 1.05 1.06 1.06 1.06 1.06 55 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 56 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 57 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 58 5.3 5.4 5.5 5.6 5.7 5.8 5.9 6.0 6.1 9/11/2013 rdb New freshwater RPA based on 95% probability/95% confidence Statistically 58 points are the maximum number of points allowed under this RPA program. Data fields w Additional messages will appear to alert user if more than 58 data points were enter and no predicted va All worksheets are "Protected" The "mf calculator" is password "Protected" OTHER CHANGES FROM PREVIOUS RPA PROGRAM: A. When Model is applied (Check box activated): 1) assumes only chroinc dilution known 2) assumes user will insert appropriate flow values for "7Q10s (cfs)", "7Q10w (cfs)", "30Q 3) automatically assigns the entered chronic IWC % to the "IWC @ 7Q10s", "IWC @ 7Q10' 3) "1 Q10s (cfs)" automatically defaults to no acute dilution, acute IWC = 100% ,"IWC @ 1( B. When Model is not applied (Check box NOT activated): 1) assumes user will insert appropriate flow values for "7Q1 Os (cfs)", "7Q1 Ow (cfs)", "30Q 3) automatically calculates chronic -based IWC % for the "IWC @ 7Q10s", "IWC @ 7Q10w 3) "1 Q10s (cfs)" is automatically calculated bases on entered "7Q10s (cfs)" flow 4) automatically calculates acute -based IWC% for the "IWC @ 1 Q10s" value used in acute C. When paremeter's "Impaired?" check box is activated: 1) automtically activtes the "IMPAIRED" message alert on the "RPA" page for that paramet( 2) does NOT make any automatic adjustements to WQS calculations NOTE: If new or expanding discharge and receiving stream impaired, will need to evaluate i 10/30/2013 rdb 1) Amended "ERR' alert on data sets entreies to activate if "<" entered but no value entered, does not ( 2) Added new calculation feature to count nondetects when both "<" and a value are entered for each da 3) Amended "Comments" drop down menu - per Juile 4) Turned the Chronic toxicity concentration message off on the RPA page - per Julie 2/10/14: ON "data" page changed highlighted area from blue shades to gray 5/2/14 rdb 1) Increased rounding factor on all calculated IWC% to 7 decimals 2) Increased display for all calkculated to 6 decimals places. 5/5/14 rdb Increased rounding factor on all calculated IWC% to 9 decimals 5/21/14 rdb Removed ROUND function from all IWC% calculations 7/31/14 rdb Moved RPA page tile blocks down one row so header text was separated 9/9/15: COMPLETED REVISIONS FOR METAL TRANSLATOR FEATURE 1) Added tabs for "HUC Hardness" (lookup table for HUC hardness values), "Hardness Equations" (sums (calcution sheet for metal translator, impacted chronic and acute wqs) 2) Revised "Input" page Table 1: - New user input for "8 Digit HUC Number" uisng drop down menu for lookup HUC Hardness, required ei - New display only for calculated "Effluent Hardness (Median)" including conditional method for info displ - New display only for designed "HUC Hardness (Median)" incuding conditionla method for info display, I - New display only for calculated "Combined Hardness Chronic" for metal translator application, brown h - New display only for calculated "Combined Hardness Acute" for metal translator application, brown high - Assigned name for "HUC Number" 3) Revised "Input" pade Table 2: - Removed "Impaired ?" column, conditional display, references - Added new column for "WQS" designation incuding assigning applicable WQS where fixed - Added new error message "CHECK WQS", conditonal control based on "WQS" entry for Cadmium, Ch - Revised text in error message - Added new brown highlight "Metal Translator Data Entry" label box - Removed Par01 "Arsenic" line - Revised Par02 " Arsenic" line to reflect Human Health and Water Supply criterion, Chronic = 10 mg/L, J - Revised Par04 "Cadmium" line: a) "WQS" input with drop down menu to select applicable criterion b) "Chronic" and "Acute" inputs to display calculated metal translator values including condit c) "Modifier" input display only based on "WQS" selection including conditional method for ir d) Conditonal controls to activate error nessages, brown highlight - Revised Par05 "Chloride (AL)" line: a) "WQS" input with drop down menu to select applicable criterion b) "Chronic" display only for applicable value including conditional method for info display ba c) "Modifier" input display only based on "WQS" selection including conditional method for ir d) "Name" display only based on "WQS" selection including conditional metdod fro info disp e) Conditonal controls to activate error nessages - Revised "Chromium, Total" line: a) Removed Par08 label b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding c) brown highlight - Added new "Chromium III" line: a) Assigned applicable text in "WQS", "Type", Modifier", Units" b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding c) brown highlight - Added new Par08 "Chromium VI" line: a) Assigned Par08 label, applicable text in "WQS", "Type", Modifier", Units" b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding c) brown highlight - Revised Par09 "Copper (AL)" line: a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding b) brown highlight - Revisd Par12 "Lead" line: a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding b) brown highlight - Revised Par14 "Molybdenum" lime: a) "WQS" input with drop down menu to select applicable criterion b) "Chronic" display only for applicable value including conditional method for info display ba c) "Modifier" input display only based on "WQS" selection including conditional method for ir d) Conditonal controls to activate error nessages - Revised Par15 "Nickel" line: a) "WQS" input with drop down menu to select applicable criterion b) "Chronic" and "Acute" inputs to display calculated metal translator values including condit c) "Modifier" input display only based on "WQS" selection including conditional method for ir d) Conditonal controls to activate error nessages, brown highlight - Revised Par17 "Silver (AL)" line: a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding b) brown highlight - Revised Par18 "Zinc (AL)" line: a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding b) brown highlight 3) Revised "Data" page: - Revised Par01 "Arsenic" entry, text, and calculations ("1") - all effluent hardness data to be entered in t a) Reference to Par01 "Arsenic" removed b) New label "Effluent Hardness (monthly average)" added c) "Mult Factor =" and "Max. Pred Cw" removed, text and calcuation d) "10% value" and "Median value" added, text and calculation including conditional method e) Assigned name "Effluent_Median" and "effluent_10" to calculated values f) PQL condition removed from calculation method for data displayed 4) Revised "RPA" page: - Removed all features assocaited with "Impairment" - Added new display only for calculated "COMBINED HARDNESS (mg/L)", Chonic and Acute, conditions - Revised "Receiving Stream" display to include selected HUC Number in text - Removed unused display features for WET % (previouly hidden) - Revised "Arsenic" lines: a) Par01 "Arsenic" line removed b) Par02 "Arsenic" references used for display to calculate "Acute" and Chronic" allowable - Revised "Cadmium", "Chromium VI", "Copper (AL)", "Lead", "Nickel", "Silver (AL)", "Zinc (AL)" (lines: a) "NC WQS/Chronic" and 1/2 FAV/Acute" conditional method revised for info display, no ro b) "Allowable Cw" Acute" and "Chronic" conditional metfhod revised fro info display inculdinc 5) Revised "Dss to Total Metal Hardness Calculator" page - Assigned names for: a) "CdMAE_AC" - Cadmium calculated metal translator Acute value b) "CdMAE_CH" - Cadmium calculated metal translator Chronic value c) "CuMAE_AC" - Copper calculatd metal translator Acute value d) "CuMAE_CH" - Copper calculated metal translator Chronic value e) "Cr_Total_AC" - Total Chromium calculated meat) translator Acute value f) "Cr_Total_CH" - Total Chromium calculated metal translator Chronic value g) "CrIIIMAE_AC" - Chromium III calculated metal translator Acute value. h) "CrIIIMAE_CH" - Chromium III calculated metal tramslator Chronic value i) "CrVIMAE_AC" - Chromium VI calculated metal translator Acute value j) "CrVINAE_CH" - Chromium VI calculatd metal translator Chronic value k) "PbMAE_AC" - Lead calculated metal translator Acute value m) "PbMAE_CH" - Lead calculated metal translator Chronic value n) "NiMAE_AC" - Nickel calculated metal translator Acute value o) "NiMAE_CH" - Nickel calculated metal translator Chroniv value p) "AuMAE_AC" - Silver calculated metal translator Acute value q) "AuMAE_CH" - Silver calculated metal translator Chronic value r) "ZnMAE-AC" - Zinc calculated metal translator Acute value s) "ZnMAE_CH" - Zinc calculated metal translator Chronic value t) "tss" - assigned TSS harness factor u) "CHA" - calculated combined acute hardness value v) "CHC" - calculated combined chronic hardness value - Added conditional methods to formulas for info display and to incorporate names, no rounding 6) Set up passwortd to protect all pages 'rpa2015' 1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION 1) Inserted "Aresenic, Aquatic Life, C, 50, FW, N/A, pg/L" in first row "INPUT" Table 2, Par01 2) Updated program names to reflect addition of new Arsenic Aquatic Life parameter 3) Inserted "Arsenic" Aquatic Life parameter and cell programming in Arsenic section "RPA" as Chronic 4) Amended labels on "Data" to show H for hardnes and Par01-Par22 for paremeters 1/12/16 REVISED IWC CALCULATIONS TO SHOW FULL DISPLAY on "RPA" 1) Reformatted IWC calculation cells to show caculated value as general (number value will always be di 2) Revised IWC calculation formula to x by 100 to mimic % 3) Revised IWC calculation labels to include "%" 4) Revised all calculations using IWC values "Acute", "Chronic" to divide by 100 to correct for IWC % vale 1/12/16 REVISED SPREADSHEET TO INDICATE NO DETECT AND MDL 1) Revised "Data" Par01-Par22 Max Value cell conditional statement to display "NO DETECTS" when de 2) Revised "RPA" all parameters Max Pred CW cell formatting to display "NO DETECTS" when require 3) Revised "RPA" alert message (under Chronic labels) conditional statement to display "Max MDL = <2 4) Revised "RPA" drop menu to add "No detects" to list and display 1/12/16: Corrected formula error in mf formula Par01 to use corrected data set ("Data") Revised "RPA" Cadmium, Copper, Lead, Nickel, Silver, Zinc Acute and Chronic cell conditional statemer 1/21-29/16: 1) Expanded parameter list and program features to add two additional parameters, (Par08) "Chromium new corresponding RPA evalutaion, non -detect evaluation, formulas for each new data input section; a to new assigned name (Par10 - Par24), data set (_Data08 - _Data24), non -detects (_ND08 - _ND24). 2) For consistency rearranged display, "Input" & "RPA" tabs, to be "Chromium III", "Chromium VI", "Chroi 3) Corrected Arsenic - Aquatic Life, Berylium Chronic and Acute values on "Input" tab to be exported fror 4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (I- 5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formula; 6) Revised "RPA" tab Chromium, Total Reasonable Potential Results section to remove Acute and Chroi 7) Revised "RPA" tab Chromium III and Chromium VI Reasonable Potential Results sectons to remove c formulas that reference Chromium, Total display and data. NOTE: All RPA evaluation data is generated on each parameter "Data" section and imported to that pare 8) Revised "RPA" tab Acute and Chronic conditional formulas for active parameters to display either "/W 9) Removed label from "Input" tab. 10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Me See task notes 2/3/16: Revised "input"page model feature to a- Add new model 1 Q10S input cell that is visible on;y when model feature is activated b- Revise cell formula 1 Q10s (cfs) to display 1 Q10s flow when model feature activated or calculate from c- Revised instructions narrartive that is visible only when model feature is activated 2/9/16: Revised "input" page Effluent Hardness (Median) cell formula to display "default 99 mg/L (Efflunet Hard r Revised "data" page Effluent Hardness (Median) cell formula to display 99 whenstream class is WS and Added new display messages to "rpa" page that are visible only when the steam class is water supply 2/16/16: 1) Revised "Diss to Total Metal Calculator" page: added new cells to display actual calculated Effluent & HUC Median values and to display "Apply Water exceeds 99.999 mg/L) revised the existing calculation input/display cells for Effluent & HUC Hardness Median to show the applil a- If HUC Hard Med = NA or less than 25 mg/L then default HUC Hard Med to 25 mg/L b- If Effluent Hard Med less than 25 then default Effluent Hard Med to 25 mg/L c- If stream class is WS and Effluent Hard Med is greater than 99.9999 mg/L then default El 2) Revised "input" page dipplay HUC Hardness (Median) to show NA when HUC table value is NA. 2/19/16: Added new WS WQC button to "input" page, activates effluent hardness to apply WS WQC standards, d Added Nickel WS parameter to "input" page Added Nichel WS to "rpa" page, revised both Nickel parametesr to share commom data, Nickel WS has Set up both Nickel Par17 & Par18 to use same data entries Changed Par22-25 modifier cells to be set automtically based on WQS entry. Changed display font color phenols, chlorinared phenols menus 2/22/16: Make text changes per Julie direction. 2/24/16: Added to " Diss to Total Metal Calculator" page: 1) Comment section for PERCS info or other to allow user to add commentary 2) Added Facility name to display based on input page 3) Added NPDES permit# to display based on input page 4) Set up new Name "PERCS_page" as print area for table and other PERCS info for GOTO use. NOTE: User can either highlight desire print area or use GOTO feature to set up desired print arae. Whe 3/18/16: Removed HUC table and HUC hardness lookup features from calculations and program. Note: HUC number is an available option on the INPUT as an informational input only to use as a display Added Upstream Hardness calculation feature using measured upstream data: 1) INPUT display shows "Upstream Hardess" status and how upstream data is applied 2) DATA has new Upstream Hardness input sheet to accept upstream hardness data used to calculate r 3) Diss to Total Metal Calculator determines which upstream hardness to apply, if the number of data en 10th percentile value is used. Anytime the applied upstream hardness is less than 25 mg/L then a defa 4/26/16: Per Julia want to use average values for both the effluent and upstream hardness calculations. Defaults 1) Changed all upstream hardness median calculations to average calculations. 2) Removed any greater than 99.999 defaults from upstream hardness conditional statements. Upstrean 3) Changed all effluent hardness median calculations to average calculations. Conditional statements for 4) Any conditional statement referring to median hardness were revised. 5) Removed "(AL)" from parameter labels as no longer applicable. 6) Renamed RPA to describe features 4/27/16: Per Julia when WS is being applied, the combined acute and chroinc hardness needs to default to 100 if 1) Set up new cells to calculate combined acute and chronic hardness, defined cells as program names , 2) Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH & ACAH exceed 1001 3) Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate default! 4) Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate 4/28/16: Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI Revised RPA page drop menu "Recommended Action" list to remove RP Action Level text and change " Added statement to 2B .0500 RULES page "4/28/16: Note Action Level designation no long allowed per I 4/29/16: Added ROUND function to conditional statements on INPUT page hardess displays to limit hardness vale Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardneE 5/6/16: Removed less than 25 mg/L default from all effluent and upstream hardness conditional programming 5/11/16: Added new conditional display to Total Chromium Pred Cw box RPA page to compare Total Chromium c Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Tot 6/13/16: Revised title block text RPA tab to state "NC STANDARDS OR EPA CRITERIA", removed "NC WQS" fr( Corrected INPUT tab to align Dats Source(s) text box at top. 6/14/16: Revised conditions for calculated combined hardness acute and chroinc to default to 400 mg/L if calculai Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when defaL Corrected label on DISS ... page to indicate average for effluent and upstream hardness 7/13/16: Revised Model input feature when activated to calculate Model 7Q10s (cfs) flow based on entry of Qw, N User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry k Revised narrative in Model narrative box with new instructions, new messages to alert user on actions nE Remove conditions and features assocaited with entry of Model Acute IWC % . 8/30/16: Revised conditional note statement on RPA tab for Total Chromium to correct program error. 10/20/16: Revised label display for Fcailty discripition on "Diss to Total Metal Calculator".sheet to list Outfall #. 9/7/2017 Revised chromium drop down to reflect new < 5ug/L PQL. 11/21/17: (1) Revised RPA evaluation to assign C.V. (default) = 0.6 when only a sinlgle data entry inade for any pa (2) Revised RPA evaluation to always calculate and display "Max Pred Cw" value whenever there are 1 t (3) Revised rpa page to show each parameters automatic display message "NO DETECTS" independen (4) Revised Total Chromium < 50 data counter to start count when the entered data point < 4.9999. (hidc 11/29/17: (1) Revised RPA page ( C.V. (default? Message to (2) Corrected DATA page H2 message to show ... UPSTREAM... (3) Removed (1) from RPA page Type label 11/30/17: Revised Dissolved Metals and Total Metals Table label descriptions on "DSS to Total Metal Calculator" 1 12/12/17: Revised conditional statements DATA tab to allow appllication C.V. (default) for number of data values 1 1/20/18: 1) Revised "RPA" Receiving Stream display to only show the Stream name and if entered the HUC numk 2) Increased RPA page Qw display decimal places ere estbalished to allow only 58 data point entries. ues will be calculated 2 (cfs)", "QA (cfs)" to define chronic dilution in terms of "IWC %", "IWC %" is the same for all stream flows w", "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page) )10s" = 100% which is used in acute WQS calculatons (See "RPA" page) 2 (cfs)", "QA (cfs)" , "Flow Qw (MGD)" for chronic IWC % calculations, IWC % will vary according to flows "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page) WQS calculations (See "RPA" page) r? J f additional waste load is allowed ?ffect RPA calculation, ERR message only to set, used to calculate detected entries mary of translator formulas, metals impacted, general info), "Dss to Total Hardness Calculator" ntry, brown highlight ay, brown highlight Irown highlight ighlight flight lorides, Molybdeum, Nickel kcute = "N/A" Tonal method for info display based on "WQS" selection, no rounding go dispaly ised on "WQS" selection go dispaly ay ised on "WQS" selection go dispaly ional method for info display based on "WQS" selection, no rounding go dispaly :his section for used to calculate eflluent hardness factors for info display [I method for info display �w unding rounding value and added drop down menu feature splayed) ue Ita set has all no detects d to display no detects x max adjusted data set value>" when data set has all no detects its to have cell display blank if WQS is blank or WQS displays "NO DATA" III" & (Par09) "Chromium VI". This included adding two new data input sections on "Data" tab with dding two new parameter summary sections to "RPA" tab; revising exsiting parameter designation mium, Total". All features and programing unique to each display was revised accordingly. n metal translator table. IUC Hard Med = NA mg/I)" when HUC hardness is NA. to assign 25 as hardness value when HUC hardness is NA. nic labels and allowable Cw calulation/display, area now blank except for MDL feature display. lisplay of values for n, #Det, Max Pred Cw, area blank except for display features from added condtional Lmeter's "RPA" section, thus, RPA evaluation data can be displayed/used when programmed to do so. C?" or "IWC/DATA?" as default until appropraite data is provided. lhod 625. 7Q10s flow when model feature NOT activated and 7Q10s flow displayed Vied = <actual value> mg/L)" when stream class is WS and Effluent Hard Med is greater than 99.999 mg/L Effluent Hard Med is greater than 99.999 mg/L Supply Criterion" when applicable (stream class is Water Supply based and Efflunet Hard Med ed hardness value based on new conditional formula as follows (fluent Hard Med to 99 mg/L foes NOT set parameter modifiers, still must do modifers individually no Acute standard so only list acute for FW in in print mode set up, will need to designate "Print Selection". label for other portion of the progam and has no Data Validation features. lumber of data enties, data set average, data set 10th percentile value tries exceed 30 then the average value is used, if the number of data enties are less than 30 then the ult value of 25 mg/L is applied. to be the same as was applied in the HUC base RPA. average will be actual execpt when less than 25, then 25 is the default. WS still apply, efflunet average value above 99.999 default to 99. the combined hardness exceeds 100. Made changes: ACCH & ACAH. when WS was applied. defaults now function. RP non action level..." text to state "RP shown...". EPA." ue display to 2 decimal points. ;s of 25 to be displayed as non -default value. iata to Cr III and Cr VI Allowable Cw al Chromium value entered )m Chronic label, and removed 1/2 FAV from Acute label. Led value exceeded 400 mg/L ..ilt 400 mg/L applied 1GD and CHRONIC DILITION FACTOR (from Model) and display in Model narrative box. )ox. 1 Q10s is calculated once the calculated 7Q10s (cfs) is entered in Tablel . ?eded and/or completed to correctly enter Model 7Q10s (cfs) in Table 1. rameter (see data page). On data page the parameter will diplay Std..Dev. = "N/A" when only a single data entry m; o 58 data numerical entties made (see data and rpa pages). t from "Max Pred Cw" display len column of data page). Revised Total Chromium automatic diplay message on rpa page to reflect new 5 pg/I crib Lab so as not to conflict with exsiting descriptions in RPA to 9 even if no deviation in data set. )er ade. aria. Date: 2/19/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: Riverbend Steam Station Outfall 002A NPDES PERMIT: NC0004961 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) 80.0000 I 51.6129 42.1935 0.0400 10 25.000 25.000 0.0774 0.0947 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 15A NCAC 02B .0211 for more information. (t) = based upon measurement of total recoveable metal. See 15A NCAC 02B .0211 for more information. The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard. The Human Health standard for Arsenic is 10 ug/L which is Total Recoverable metal standard. ACAH ACCH Dissolved Metals & H I. How to Determine Hardness for use HARDNESS - Use 25 mg/L, expressed as C OR To determine a Hardness value for permit Hardness = (Hardness instream(a) n (mass balance) (a) Use the median instream Hardness vn (b) For the purpose of this estimation, use th II. To Develoa Dissolved Metal con Table A: Dissolved Freshwater Standards for H, Metal Cadmium, Acute Cadmium, Acute (Trout Waters) Cadmium, Chronic Chromium III, Acute Chromium III, Chronic Copper, Acute Copper, Chronic Lead, Acute Lead, Chronic Nickel, Acute Nickel, Chronic Silver, Acute Silver, Chronic Zinc, Acute Zinc, Chronic Complete information on all the proposed US EPA Translators using Default Partition 1 Translator equation using Default Partition Coel Kpo and a are constants that express the equ i A default value of 10 mg/L Total Suspended Table A contains the Default Partition Coel Table B contains the calculated translators TABLE A. Default Partition Coefficients Metal (1) Cu Zn Pb Cr (III) (2) Cd Ni (1) Delos, C.G., et al. Technical Guidance for Perforr (2) Linear partition coefficients shall not apply to the TABLE B. US EPA Translators PARAMETER Cadmium Chromium III Chromium VI Chromium, Total Copper Lead Nickel Silver Zinc ardness Determination v. 5/27/2010 with Dissolved Freshwater Standards for Permitting Purposes :aCo/ or Ca+Mg, as the default Hardness limit development, use the following equation: iq/L * 7Q10, MGD)+(Hardness effluent(b), and/L* Plant flow, MGD) (7Q10, MGD + Plant flow, MGD) clue of the ambient 8-digit HUC data collected by the Division of Water Quality. To find the 8-digit HUC le facility's median effluent Hardness value, if available. The Division will request the permittee to sample effluent Icentrations for permitting purposes use the Freshwater Standards for Hardness De irdness Dependent Metals pg/L {1.136672-[In hardness](0.041838)} • e^{0.9151 [In hardness]-3.1485} {1.136672-[In hardness](0.041838)} • e^{0.9151[In hardness]-3.6236} {1.101672-[In hardness](0.041838)} • e^{0.7998[In hardness]-4.4451} 0.316 • e^{0.8190[In hardness]+3.7256} 0.860 • e^{0.8190[In hardness]+0.6848} 0.960 • e^{0.9422[In hardness]-1.700} 0.960 • e^{0.8545[In hardness]-1.702} {1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-1.460} {1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-4.705} 0.998 • e^{0.8460[In hardness]+2.255} 0.997 • e^{0.8460[In hardness]+0.0584} 0.85 • e^{1.72[In hardness]-6.59} Not applicable 0.978 • e^{0.8473[In hardness]+0.884} 0.986 • e^{0.8473[In hardness]+0.884} Surface Water Quality Standards can be viewed at: http://h2o.enr.state.nc.us/csu/trirev SW.html. Coefficients (DPC) Fficients = 1 v. 6/2/2010 [1 + (Kpo * TSS (1+a) * 10-6)] librium relationship between dissolved and adsorbed forms of metals. Solids (TSS) will be used. Fficients for the equation. using the default partition coefficients for streams. STREAMS Kpo a 1.04E+06 -0.7436 1.25E+06 -0.7038 2.80E+06 -0.8 3.36E+06 -0.09304 4.00E+06 -1.1307 4.90E+05 -0.5719 ning Waste Load Allocations. Book II: Streams and Rivers. Chapter 3: Toxic Substances, For the U.S. EPA. (EPA-440/4-84-022) Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefore, p US EPA Translators Using stream Default Partition Coefficients TSS = 10 mg/L 0.252 0.202 1 N/A 0.348 0.184 0.432 1 0.288 hardness value for your facility, Click Here. hardness once/month and submit one to two years of data with the permit renewal application. If no effluent hardness datz pendent Metals listed in Table A below. Example for Cadmium (streams) Given: TSS = 10 mg/L Kpo = 4.00E + 06 a =-1.1307 Translator = 1 [1 + (Kpo * TSS (1+0 * 10-6)] = 1 [1 + (4.00x106 * 101-1.13°7) * 10-6)] = 1 [1+2.960465] = 0.252 1 is submitted, a default of 25 mg/L will be applied.