Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
NC0024406_Worksheets 003 Dewatering to UT_20190322
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 Belews Steam Station I NC0024406 003 - dewatering to UT 2.000 UT to Dan River WS-IV I:Apply WS Hardness WQC 7Q10s (cfs) 7Q10w (cfs) 30Q2 (cfs) QA (cfs) 1 Q10s (cfs) 0.00 0.00 0.00 0.00 0.00 Effluent Hardness Upstream Hardness Combined Hardness Chronic Combined Hardness Acute 25 mg/L (Avg) J 25 mg/L (Avg) 25 mg/L 25 mg/L Data Source(s) renewal application ❑CHECK TO APPLY MODEL 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. Table 2. Parameters of Concern Par01 Par02 Par03 Par04 Par05 ParOd Par07 Par08 Par09 Par10 Par11 Par12 Par13 Par14 Par15 Par16 Par17 Par18 Par19 Par20 Par21 Par22 Par23 Par24 Par25 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 Water Supply NC 250 WS mg/L / Chlorinated Phenolic Compounds Water Supply NC 1 A ug/L yTotal Phenolic Compounds Aquatic Life NC 300 A ug/L Chromium Ill 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 Water Supply NC 160 WS ug/L Nickel Aquatic Life NC 37.2313 FW 335.2087 pg/L Nickel Water Supply NC 25.0000 WS N/A pg/L Selenium Aquatic Life NC 5 FW 56 ug/L Silver Aquatic Life NC 0.06 FW 0.2964 ug/L Zinc Aquatic Life NC 126.7335 FW 125.7052 ug/L Antimony Water Supply NC 5.6 WS pg/L Barium Water Supply NC 1 WS mg/L Sulfates Water Supply NC 250 WS mg/L Thallum Human Health NC 2 HH pg/L NC0024406_Worksheets 003 Dewatering to UT_20190322, input 8/13/2021 For all dischargers to all waters of the state: Narrative aesthetic "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) For dischargers to Water Supply (WS) streams that chlorinate the effluent: "Chlorinated Phenolic Compounds" in Water Supply classified waters is an aesthetic standard 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) The following is a list of Chlorinated Phenolic Compounds detected using US EPA Method 625: 2-chlorophenol 2,4-dichlorophenol 4-chloro-3-methylphenol pentachlorophenol 2,4,6-trichlorophenol 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. 3-chlorophenol 2,5-dichlorophenol 2, 3 , 6-trichlorophenol 4-chloro-2-methylphenol 4-chlorophenol 2,6-dichlorophenol 2, 4, 5 -trichlorophenol 6-chloro-3-methylphenol 2,3-dichlorophenol 3,4-dichlorophenol 2,3,4,6-tetrachlorophenol *The following US EPA Method 625 reported non -chlorinated phenolic compounds SHOULD NOT be summed with the chlorinated data for comparison to the Water Supply standard for chlorinated phenolics: 2,4-Dimethylphenol 2,4-Dinitrophenol 2-Methyl-4,6-dinitrophenol 2-Nitrophenol 4-Nitrophenol Phenol p-cresol (4-methylphenol) o-cresol (2-methylphenol) NC0024406_Worksheets 003 Dewatering to UT_20190322, input 8/13/2021 REASONABLE POTENTIAL ANALYSIS H1 Use "PASTE SPECIAL, Values" then "COPY" . Maximum data points =58 H2 Use "PASTE SPECIAL, Values" then "COPY" . Maximum data points =58 Par01 & Par02 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points =58 Par03 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points =58 Par04 Use "PASTE SPECIAL - Values" then "COPY" . Maximum data points =58 Effluent Hardness Upstream Hardness Arsenic Beryllium Cadmium Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 25 25 Std Dev. 0.0000 1 25 25 Std Dev. 0.0000 1 90.6 90.6 Std Dev. 0.0000 1 Std Dev. NO DATA 1 < 1 0.5 Std Dev. 0.0000 2 Mean 25.0000 2 Mean 25.0000 2 Mean 90.6000 2 Mean NO DATA 2 Mean 0.5000 3 C.V. (default) 0.6000 3 C.V. (default) 0.6000 3 C.V. (default) 0.6000 3 C.V. NO DATA 3 C.V. (default) 0.6000 4 n 1 4 n 1 4 n 1 4 n 0 4 n 1 5 10th Per value 25.00 mg/L 5 10th Per value 25.00 mg/L 5 5 5 6 Average Value 25.00 mg/L 6 Average Value 25.00 mg/L 6 Mult Factor = 6.20 6 Mult Factor = N/A 6 Mult Factor = 6.20 7 Max. Value 25.00 mg/L 7 Max. Value 25.00 mg/L 7 Max. Value 90.6 ug/L 7 Max. Value N/A ug/L 7 Max. Value 0.500 ug/L 8 8 8 Max. Pred Cw 561.7 ug/L 8 Max. Pred Cw N/A ug/L 8 Max. Pred Cw 0 DETECTS ug/L 9 9 9 9 9 10 10 10 10 10 11 11 11 11 11 12 12 12 12 12 13 13 13 13 13 14 14 14 14 14 15 15 15 15 15 16 16 16 16 16 17 17 17 17 17 18 18 18 18 18 19 19 19 19 19 20 20 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 23 23 23 24 24 24 24 24 25 25 25 25 25 26 26 26 26 26 27 27 27 27 27 28 28 28 28 28 29 29 29 29 29 30 30 30 30 30 31 31 31 31 31 32 32 32 32 32 33 33 33 33 33 34 34 34 34 34 35 35 35 35 35 36 36 36 36 36 37 37 37 37 37 38 38 38 38 38 39 39 39 39 39 40 40 40 40 40 41 41 41 41 41 42 42 42 42 42 43 43 43 43 43 44 44 44 44 44 45 45 45 45 45 46 46 46 46 46 47 47 47 47 47 48 48 48 48 48 49 49 49 49 49 50 50 50 50 50 51 51 51 51 51 52 52 52 52 52 53 53 53 53 53 54 54 54 54 54 55 55 55 55 55 56 56 56 56 56 57 57 57 57 57 58 58 58 58 58 - 3 - NC0024406_Worksheets 003 Dewatering to UT_20190322, data 8/13/2021 REASONABLE POTENTIAL ANALYSIS Par05 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points = 58 Par06 Use "PASTE SPECIAL, Values" then "COPY" . Maximum data points = 58 Par07 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points = 58 Par08 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points = 58 Par09 Use "PASTE SPECIAL - Values" then "COPY" . Maximum data points = 58 Chlorides Chlorinated Phenolic Compounds Total Phenolic Compounds Chromium Ill Chromium VI Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 85 85.43 Std Dev. 0.0000 1 Std Dev. NO DATA 1 Std Dev. NO DATA 1 Std Dev. NO DATA 1 Std Dev. NO DATA 2 Mean 85.4 2 Mean NO DATA 2 Mean NO DATA 2 Mean NO DATA 2 Mean NO DATA 3 C.V. (default) 0.6000 3 C.V. NO DATA 3 C.V. NO DATA 3 C.V. NO DATA 3 C.V. NO DATA 4 n 1 4 n 0 4 n 0 4 n 0 4 n 0 5 5 5 5 5 6 Mult Factor = 6.2 6 Mult Factor = N/A 6 Mult Factor = N/A 6 Mult Factor = N/A 6 Mult Factor = N/A 7 Max. Value 85.4 mg/L 7 Max. Value N/A ug/L 7 Max. Value N/A ug/L 7 Max. Value N/A pg/L 7 Max. Value N/A pg/L 8 Max. Pred Cw 529.7 mg/L 8 Max. Pred Cw N/A ug/L 8 Max. Pred Cw N/A ug/L 8 Max. Pred Cw N/A pg/L 8 Max. Pred Cw N/A pg/L 9 9 9 9 9 10 10 10 10 10 11 11 11 11 11 12 12 12 12 12 13 13 13 13 13 14 14 14 14 14 15 15 15 15 15 16 16 16 16 16 17 17 17 17 17 18 18 18 18 18 19 19 19 19 19 20 20 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 23 23 23 24 24 24 24 24 25 25 25 25 25 26 26 26 26 26 27 27 27 27 27 28 28 28 28 28 29 29 29 29 29 30 30 30 30 30 31 31 31 31 31 32 32 32 32 32 33 33 33 33 33 34 34 34 34 34 35 35 35 35 35 36 36 36 36 36 37 37 37 37 37 38 38 38 38 38 39 39 39 39 39 40 40 40 40 40 41 41 41 41 41 42 42 42 42 42 43 43 43 43 43 44 44 44 44 44 45 45 45 45 45 46 46 46 46 46 47 47 47 47 47 48 48 48 48 48 49 49 49 49 49 50 50 50 50 50 51 51 51 51 51 52 52 52 52 52 53 53 53 53 53 54 54 54 54 54 55 55 55 55 55 56 56 56 56 56 57 57 57 57 57 58 58 58 58 58 - 4 - NC0024406_Worksheets 003 Dewatering to UT_20190322, data 8/13/2021 REASONABLE POTENTIAL ANALYSIS Par10 Use "PASTE SPECIAL, Values" then "COPY" . Maximum data points =58 Pall Use "PASTE SPECIAL, Values" then "COPY" . Maximum data points =58 Par12 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points =58 Par13 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points =58 Par14 Use "PASTE SPECIAL - Values" then "COPY" . Maximum data points =58 Chromium, Total Copper Cyanide Fluoride Lead Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date BDL=1/2DL Results 1 28.3 28.3 Std Dev. 0.0000 1 34.5 34.5 Std Dev. 0.0000 1 Std Dev. NO DATA 1 1051 1051 Std Dev. 0.0000 1 22.5 22.5 Std Dev. 0.0000 2 Mean 28.3000 2 Mean 34.5000 2 Mean NO DATA 2 Mean 1051.0000 2 Mean 22.5000 3 C.V. (default) 0.6000 3 C.V. (default) 0.6000 3 C.V. NO DATA 3 C.V. (default) 0.6000 3 C.V. (default) 0.6000 4 n 1 4 n 1 4 n 0 4 n 1 4 n 1 5 5 5 5 5 6 Mult Factor = 6.20 6 Mult Factor = 6.20 6 Mult Factor = N/A 6 Mult Factor = 6.20 6 Mult Factor = 6.20 7 Max. Value 28.3 pg/L 7 Max. Value 34.50 ug/L 7 Max. Value N/A ug/L 7 Max. Value 1051.0 ug/L 7 Max. Value 22.500 ug/L 8 Max. Pred Cw 175.5 pg/L 8 Max. Pred Cw 213.90 ug/L 8 Max. Pred Cw N/A ug/L 8 Max. Pred Cw 6516.2 ug/L 8 Max. Pred Cw 139.500 ug/L 9 9 9 9 9 10 10 10 10 10 11 11 11 11 11 12 12 12 12 12 13 13 13 13 13 14 14 14 14 14 15 15 15 15 15 16 16 16 16 16 17 17 17 17 17 18 18 18 18 18 19 19 19 19 19 20 20 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 23 23 23 24 24 24 24 24 25 25 25 25 25 26 26 26 26 26 27 27 27 27 27 28 28 28 28 28 29 29 29 29 29 30 30 30 30 30 31 31 31 31 31 32 32 32 32 32 33 33 33 33 33 34 34 34 34 34 35 35 35 35 35 36 36 36 36 36 37 37 37 37 37 38 38 38 38 38 39 39 39 39 39 40 40 40 40 40 41 41 41 41 41 42 42 42 42 42 43 43 43 43 43 44 44 44 44 44 45 45 45 45 45 46 46 46 46 46 47 47 47 47 47 48 48 48 48 48 49 49 49 49 49 50 50 50 50 50 51 51 51 51 51 52 52 52 52 52 53 53 53 53 53 54 54 54 54 54 55 55 55 55 55 56 56 56 56 56 57 57 57 57 57 58 58 58 58 58 - 5 - NC0024406_Worksheets 003 Dewatering to UT_20190322, data 8/13/2021 REASONABLE POTENTIAL ANALYSIS Par15 Use "PASTE SPECIAL, Values" then "COPY" . Maximum data points = 58 Par16 Use "PASTE SPECIAL, Values" then "COPY" . Maximum data points = 58 Par17 & Par18 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points = 58 Par19 Use "PASTE SPECIAL- Values" then "COPY" . Maximum data points = 58 Par20 Use "PASTE SPECIAL - Values" then "COPY" . Maximum data points = 58 Mercury Molybdenum Nickel Selenium Silver Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 1.7 1.7 Std Dev. 0.0000 1 2260 2260 Std Dev. 0.0000 1 21.3 21.3 Std Dev. 0.0000 1 60.7 60.7 Std Dev. 0.0000 1 Std Dev. NO DATA 2 Mean 1.7000 2 Mean 2260.0000 2 Mean 21.3000 2 Mean 60.7000 2 Mean NO DATA 3 C.V. (default) 0.6000 3 C.V. (default) 0.6000 3 C.V. (default) 0.6000 3 C.V. (default) 0.6000 3 C.V. NO DATA 4 n 1 4 n 1 4 n 1 4 n 1 4 n 0 5 5 5 5 5 6 Mult Factor = 6.20 6 Mult Factor = 6.20 6 Mult Factor = 6.20 6 Mult Factor = 6.20 6 Mult Factor = N/A 7 Max. Value 1.7 ng/L 7 Max. Value 2260.0 ug/L 7 Max. Value 21.3 pg/L 7 Max. Value 60.7 ug/L 7 Max. Value N/A ug/L 8 Max. Pred Cw 10.5 ng/L 8 Max. Pred Cw 14012.0 ug/L 8 Max. Pred Cw 132.1 pg/L 8 Max. Pred Cw 376.3 ug/L 8 Max. Pred Cw N/A ug/L 9 9 9 9 9 10 10 10 10 10 11 11 11 11 11 12 12 12 12 12 13 13 13 13 13 14 14 14 14 14 15 15 15 15 15 16 16 16 16 16 17 17 17 17 17 18 18 18 18 18 19 19 19 19 19 20 20 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 23 23 23 24 24 24 24 24 25 25 25 25 25 26 26 26 26 26 27 27 27 27 27 28 28 28 28 28 29 29 29 29 29 30 30 30 30 30 31 31 31 31 31 32 32 32 32 32 33 33 33 33 33 34 34 34 34 34 35 35 35 35 35 36 36 36 36 36 37 37 37 37 37 38 38 38 38 38 39 39 39 39 39 40 40 40 40 40 41 41 41 41 41 42 42 42 42 42 43 43 43 43 43 44 44 44 44 44 45 45 45 45 45 46 46 46 46 46 47 47 47 47 47 48 48 48 48 48 49 49 49 49 49 50 50 50 50 50 51 51 51 51 51 52 52 52 52 52 53 53 53 53 53 54 54 54 54 54 55 55 55 55 55 56 56 56 56 56 57 57 57 57 57 58 58 58 58 58 - 6 - NC0024406_Worksheets 003 Dewatering to UT_20190322, data 8/13/2021 REASONABLE POTENTIAL ANALYSIS Par21 Use "PASTE SPECIAL, Par22 Use "PASTE SPECIAL, Par23 Use "PASTE SPECIAL- Par24 Use "PASTE SPECIAL- Par25 Use "PASTE SPECIAL - Zinc Values" then "COPY" . Maximum data points Antimony Values" then "COPY" . Maximum data points Barium Values" then "COPY" . Maximum data points Sulfates Values" then "COPY" . Maximum data points Thallum Values" then "COPY" . Maximum data points Date Data BDL=1/2DL Results = 58 Date Data BDL=1/2DL Results = 58 Date Data BDL=1/2DL Results = 58 Date Data BDL=1/2DL Results = 58 Date Data BDL=1/2DL Results = 58 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 1 41 2 3 4 5 6 7 8 9 41 Std Dev. 0.0000 Mean 41.0000 C.V. (default) 0.6000 n 1 Mult Factor = 6.20 Max. Value 41.0 ug/L Max. Pred Cw 254.2 ug/L 1 2 3 4 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 11 11 Std Dev. 0.0000 Mean 11.0000 C.V. (default) 0.6000 n 1 Mult Factor = 6.20 Max. Value 11.000000 pg/L Max. Pred Cw 68.200000 pg/L 1 0.448 2 3 4 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 0.448 Std Dev. 0.0000 Mean 0.4480 C.V. (default) 0.6000 n 1 Mult Factor = 6.20 Max. Value 0.448000 mg/L Max. Pred Cw 2.777600 mg/L 1 2 3 4 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 164.4 164.4 Std Dev. 0.0000 Mean 164.4000 C.V. (default) 0.6000 n 1 Mult Factor = 6.20 Max. Value 164.400000 mg/L Max. Pred Cw ########## mg/L 1 1.98 2 3 4 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 1.98 Std Dev. 0.0000 Mean 1.9800 C.V. (default) 0.6000 n 1 Mult Factor = 6.20 Max. Value 1.980000 pg/L Max. Pred Cw 12.276000 pg/L - 7 - NC0024406_Worksheets 003 Dewatering to UT_20190322, data 8/13/2021 Belews Steam Station NC0024406 Outfall 003 - dewatering to UT Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 2 MGD MAXIMUM DATA POINTS = 58 Qw (MGD) = 2.00 1Q1OS (cfs) = 0.00 7Q 1 OS (cfs) = 0.00 7Q 1 OW (cfs) = 0.00 30Q2 (cfs) = 0.00 Avg. Stream Flow, QA (cfs) = 0.00 Receiving Stream: UT to Dan River HUC WS-IV WWTP/WTP Class: IWC% @ 1Q1OS = 100 IWC% @ 7Q 10S = 100 IWC% @ 7Q 1 OW = 100 IWC% @ 30Q2 = 100 IW%C @ QA = 100 Stream Class: COMBINED HARDNESS (mg/L) Acute = 25 mg/L Chronic = 25 mg/L YOU HAVE DESIGNATED THIS RECEIVING STREAM AS WATER SUPPLY Effluent Hard: 0 value > 100 mg/L Effluent Hard Avg = 25 mg/L PARAMETER TYPE (1)11 NC STANDARDS OR EPA CRITERIA _i az- N H REASONABLE POTENTIAL RESULTS RECOMMENDED ACTION Chronic Applied Acute Standard # Det. Max Pred Cw Allowable Cw Arsenic Arsenic C C 150 FW 340 10 HH/WS ug/L ug/L 1 1 Note: n < 9 Limited data set 561.7 Default C.V. Acute (FW): 340.0 _ _ ____ _______________________________ Chronic (FW)_150.0 Novalue > Allowable Cw______________________________ Chronic (HH): 10.0 1 value(s) > Allowable Cw add limit Cadmium NC 0.5899 FW 3.2396 ug/L 1 0 Note: n < 9 Limited data set NO DETECTS Acute: 3.240 _ _ _ _ _ _ _ _ _ _______________________________ Chronic: 0.590 Max MDL = 1 no limit Chlorides NC 250 WS mg/L 1 1 Note: n < 9 Limited data set 529.7 Default C.V. Acute: NO WQS ___ _ ____ _ _______________________________ Chronic: 250.0 No value > Allowable Cw add limit Chromium III NC 117.7325 FW 905.0818 µg/L 0 0 N/A Acute: 905.1 Chronic:-----117.7 ------------------------------ add limit Chromium VI NC 11 FW 16 µg/L 0 0 N/A Acute: 16.0 Chronic:-----11.0 ------------------------------ add limit Chromium, Total NC µg/L Tot Cr value(s) 1 1 Note: n < 9 Limited data set < 50 but > Cr VI 175.5 Default C.V. Allowable Cw Max reported value = 28.3 no limit Copper NC 7.8806 FW 10.4720 ug/L 1 1 Note: n < 9 Limited data set 213.90 Default C.V. Acute: 10.47 ___ _ ______ _______________________________ Chronic: 7.88 1 value(s) > Allowable Cw add limit Fluoride NC 1800 FW ug/L 1 1 Note: n < 9 Limited data set 6,516.2 Default C.V. Acute: NO WQS _ _ _ _ _ _ _ _ _ _______________________________ Chronic: 1,800.0 No value > Allowable Cw add limit Lead NC 2.9416 FW 75.4871 ug/L 1 1 Note: n < 9 Limited data set 139.500 Default C.V. Acute: 75.487 _ _ _ _ _ _ _ _ _ _______________________________ Chronic: 2.942 1 value(s) > Allowable Cw add limit Page 8 of 19 NC0024406_Worksheets 003 Dewatering to UT_20190322, rpa 8/13/2021 Belews Steam Station NC0024406 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Outfall 003 - dewatering to UT Qw = 2 MGD Mercury NC 12 FW 0.5 ng/L 1 1 Note: n < 9 Limited data set 10.5 Default C.V. Acute: NO WQS ___ _ ______ ______________________________ Chronic: 12.0 No value > Allowable Cw no limit Molybdenum NC 160 WS ug/L 1 1 Note: n < 9 Limited data set 14,012.0 Default C.V. Acute: NO WQS _ _ _ _ _ _ _ _ _ _ _ _ _ Chronic: 160.0 1 value(s) > Allowable Cw add limit _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Nickel Nickel NC NC 37.2313 FW 335.2087 25.0000 WS µg/L µg/L 1 1 Note: n < 9 Limited data set 132.1 Default C.V. Acute (FW): 335.2 _ _ ____ ______________________________ Chronic (FW)_37.2 N_ov_alue>_Allow_abl_e_Cw______________________________________ Chronic (WS): 25.0 No value > Allowable Cw add limit Selenium NC 5 FW 56 ug/L 1 1 Note: n < 9 Limited data set 376.3 Default C.V. Acute: 56.0 ___ _ ______ ______________________________ Chronic: 5.0 1 value(s) > Allowable Cw add limit Zinc NC 126.7335 FW 125.7052 ug/L 1 1 Note: n < 9 Limited data set 254.2 Default C.V. Acute: 125.7 ___ _ ______ ______________________________ Chronic: 126.7 No value > Allowable Cw add limit Antimony NC 5.6 WS µg/L 1 1 Note: n < 9 Limited data set 68.20000 Default C.V. Acute: NO WQS _ _ _ _ _ _ _ _ _ _ _ Chronic: 5.60000 1 value(s) > Allowable Cw add limit _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Barium NC 1 WS mg/L 1 1 Note: n < 9 Limited data set 2.77760 Default C.V. Acute: NO WQS _ _ _ _ _ _ _ _ _ _ _ _ Chronic: 1.00000 No value > Allowable Cw add limit _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Sulfates NC 250 WS mg/L 1 1 Note: n < 9 Limited data set 1,019.28000 Default C.V. Acute: NO WQS ___ _ ____ _ _ ____________________________ Chronic: 250.00000 No value > Allowable Cw add limit Thallum NC 2 HH µg/L 1 1 Note: n < 9 Limited data set 12.27600 Default C.V. Acute: NO WQS _ _ _ _ _ _ _ _ ______________________________ Chronic: 2.00000 No value > Allowable Cw add limit Page 9 of 19 NC0024406_Worksheets 003 Dewatering to UT_20190322, rpa 8/13/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 Water Quality Limited 2/Month 1/Week 2/Month 2/Month 1/Month 2/Month 1/Week 3/Week 1/Week 3/Week 1/Week 3/Week 1/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 Parametei 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* BOD5 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 M - monitor semi-annually - >= 1.0 MC - monitor quarterly For all other river basins: - >= 0.05 M - monitor quarterly - >= 1.0 MC - monitor monthly Per Memo Dated 7-15-2010 RPA Condition Permit Monitoring Frequency I.RPA Exists Monitor Monthly and add Permit Limit 2.RPA Exists but Action Levels (Cu, Zn, Ag ,Fe. CI) Monitor Quarterly in conjunction with Tox Test 3a.RPA Exists but Damsel Limited (n<g samples) 3b. RPA exists, dataset limit ed, but 2 values > allowable Cw Monitor Quarterly Monitor Monthly and add Permit Limit 4.No RPA (Predicted Max> 50%of Allowable) Monitor Quarterly (or deferto Pretreat LIMP) 5.NoRPA(Predicted Max <50%Allowable) No Monitoring 6a.NoData (New Pennit, New Waste Stream) 6b. New Command or Conventional WTP Monitor Monthly for Toxic Pollutants of Concern Monitor Quarterly for Toxic Pollutants of Concern password all sheets = rpa2016a 4/28/16: Note Action Level designation no longer allowed per EPA. Msg00 Msg01 Msg02 Msg03 Msg04 Msg05 Msg06 Msg07 Msg08 Msg09 Msg10 < No Data Entered > 111 NO DATA MaxPredCw <Acute MONITOR? MaxPredCw < Chronic MONITOR? MaxPredCw « Acute REMOVE? MaxPredCw « Chronic MaxPredCw > Acute MaxPredCw > Chronic REMOVE? DAILY MAX LIMIT? MO AVG LIMIT? MaxPredCw » Acute DAILY MAX LIMIT? MaxPredCw» Chronic MO AVG LIMIT? No acute standard or 1/2 FAV N/A No chronic standard or criterion N/A Sample recommendations: Daily max limit Monitor 1/month Monitor 1/week Monitor 2/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% Confidence Level Upper Boundary of the Effluent Distribution (Percentile Value Not To Exceed) 95.0% 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 1 1.00 1.39 1.92 2.63 3.55 4.73 6.20 7.98 #### 12.60 1.4i 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 16b.84 177.00 187.38 197.98 208.78 219.79 231.00 242.40 253.99 265.76 277.71 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 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 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 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 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 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 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 9 1.00 1.11 1.24 1.37 1.51 1.66 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Coefficient of Variation 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 289.83 302.12 314.57 327.19 339.96 352.88 365.95 37J.1i 3jz.53 406.03 419.66 433.43 447.33 461.35 475.50 489.76 504.15 518.65 533.27 1 63.09 65.03 66.98 68.93 70.89 72.85 74.81 76.78 78.75 80.72 82.69 84.67 86.64 88.62 90.60 92.58 94.56 96.54 98.52 2 30.38 31.15 31.92 32.68 33.44 34.20 34.96 35.72 36.47 37.22 37.97 38.71 39.46 40.20 40.93 41.67 42.40 43.13 43.86 3 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 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 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 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 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 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 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 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 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 4.14 4.18 4.22 4.26 4.30 4.35 4.38 4.42 4.46 4.50 4.54 4.57 4.61 4.65 4.68 4.72 4.75 4.78 4.82 13 3.81 3.85 3.89 3.92 3.96 3.99 4.03 4.06 4.10 4.13 4.16 4.19 4.22 4.26 4.29 4.32 4.35 4.37 4.40 14 3.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 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 3.10 3.13 3.15 3.18 3.20 3.23 3.25 3.27 3.30 3.32 3.34 3.36 3.38 3.40 3.42 3.44 3.46 3.48 3.50 17 2.92 2.95 2.97 2.99 3.01 3.03 3.06 3.08 3.10 3.12 3.14 3.16 3.17 3.19 3.21 3.23 3.25 3.26 3.28 18 2.77 2.79 2.81 2.83 2.85 2.87 2.89 2.90 2.92 2.94 2.96 2.97 2.99 3.01 3.02 3.04 3.06 3.07 3.09 19 2.63 2.65 2.66 2.68 2.70 2.72 2.73 2.75 2.77 2.78 2.80 2.81 2.83 2.84 2.86 2.87 2.89 2.90 2.91 20 2.50 2.52 2.54 2.55 2.57 2.58 2.60 2.61 2.63 2.64 2.66 2.67 2.68 2.70 2.71 2.72 2.74 2.75 2.76 21 2.39 2.41 2.42 2.44 2.45 2.46 2.48 2.49 2.50 2.52 2.53 2.54 2.56 2.57 2.58 2.59 2.60 2.61 2.63 22 2.29 2.30 2.32 2.33 2.34 2.36 2.37 2.38 2.39 2.40 2.42 2.43 2.44 2.45 2.46 2.47 2.48 2.49 2.50 23 2.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 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 2.03 2.04 2.06 2.07 2.08 2.09 2.09 2.10 2.11 2.12 2.13 2.14 2.15 2.16 2.16 2.17 2.18 2.19 2.20 26 1.96 1.97 1.98 1.99 2.00 2.01 2.02 2.03 2.04 2.04 2.05 2.06 2.07 2.07 2.08 2.09 2.10 2.10 2.11 27 1.90 1.91 1.91 1.92 1.93 1.94 1.95 1.96 1.96 1.97 1.98 1.99 1.99 2.00 2.01 2.01 2.02 2.03 2.03 28 1.84 1.84 1.85 1.86 1.87 1.88 1.88 1.89 1.90 1.90 1.91 1.92 1.92 1.93 1.94 1.94 1.95 1.95 1.96 29 1.78 1.79 1.79 1.80 1.81 1.82 1.82 1.83 1.84 1.84 1.85 1.85 1.86 1.87 1.87 1.88 1.88 1.89 1.89 30 1.73 1.73 1.74 1.75 1.75 1.76 1.77 1.77 1.78 1.78 1.79 1.80 1.80 1.81 1.81 1.82 1.82 1.83 1.83 31 1.68 1.68 1.69 1.70 1.70 1.71 1.71 1.72 1.72 1.73 1.74 1.74 1.75 1.75 1.76 1.76 1.76 1.77 1.77 32 1.63 1.64 1.64 1.65 1.65 1.66 1.66 1.67 1.67 1.68 1.68 1.69 1.69 1.70 1.70 1.71 1.71 1.72 1.72 33 1.59 1.59 1.60 1.60 1.61 1.61 1.62 1.62 1.63 1.63 1.64 1.64 1.65 1.65 1.65 1.66 1.66 1.67 1.67 34 1.55 1.55 1.56 1.56 1.57 1.57 1.58 1.58 1.58 1.59 1.59 1.60 1.60 1.60 1.61 1.61 1.61 1.62 1.62 35 1.51 1.51 1.52 1.52 1.53 1.53 1.53 1.54 1.54 1.55 1.55 1.55 1.56 1.56 1.56 1.57 1.57 1.57 1.58 36 1.47 1.48 1.48 1.49 1.49 1.49 1.50 1.50 1.50 1.51 1.51 1.51 1.52 1.52 1.52 1.53 1.53 1.53 1.54 37 1.44 1.44 1.45 1.45 1.45 1.46 1.46 1.46 1.47 1.47 1.47 1.48 1.48 1.48 1.48 1.49 1.49 1.49 1.50 38 1.41 1.41 1.41 1.42 1.42 1.42 1.43 1.43 1.43 1.43 1.44 1.44 1.44 1.45 1.45 1.45 1.45 1.46 1.46 39 1.38 1.38 1.38 1.38 1.39 1.39 1.39 1.40 1.40 1.40 1.40 1.41 1.41 1.41 1.41 1.42 1.42 1.42 1.42 40 1.35 1.35 1.35 1.35 1.36 1.36 1.36 1.37 1.37 1.37 1.37 1.37 1.38 1.38 1.38 1.38 1.39 1.39 1.39 41 1.32 1.32 1.32 1.33 1.33 1.33 1.33 1.34 1.34 1.34 1.34 1.34 1.35 1.35 1.35 1.35 1.35 1.36 1.36 42 1.29 1.29 1.30 1.30 1.30 1.30 1.31 1.31 1.31 1.31 1.31 1.32 1.32 1.32 1.32 1.32 1.32 1.33 1.33 43 1.27 1.27 1.27 1.27 1.28 1.28 1.28 1.28 1.28 1.28 1.29 1.29 1.29 1.29 1.29 1.29 1.30 1.30 1.30 44 1.24 1.24 1.25 1.25 1.25 1.25 1.25 1.26 1.26 1.26 1.26 1.26 1.26 1.26 1.27 1.27 1.27 1.27 1.27 45 1.22 1.22 1.22 1.22 1.23 1.23 1.23 1.23 1.23 1.23 1.24 1.24 1.24 1.24 1.24 1.24 1.24 1.24 1.25 46 1.20 1.20 1.20 1.20 1.20 1.21 1.21 1.21 1.21 1.21 1.21 1.21 1.21 1.22 1.22 1.22 1.22 1.22 1.22 47 1.18 1.18 1.18 1.18 1.18 1.18 1.18 1.19 1.19 1.19 1.19 1.19 1.19 1.19 1.19 1.19 1.20 1.20 1.20 48 1.16 1.16 1.16 1.16 1.16 1.16 1.16 1.16 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 49 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 50 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 51 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 52 1.08 1.08 1.08 1.08 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 53 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 54 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.06 1.06 1.06 1.06 55 1.03 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 56 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 57 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 58 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 I Multiplication Factor RPMFs as f(n,CV,Confidence,UpperBound) 400.00 350.00 300.00 250.00 200.00 150.00 100.00 50.00 0.00 y 1.1 0.1 1 4 7 10 13 16 19 22 25 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 9/11/2013 rdb New freshwater RPA based on 95% probability/95% confidence Statistically 58 points are the maximum number of points allowed under this RPA program. Data fields were estbalished to allow only 58 data point entries. Additional messages will appear to alert user if more than 58 data points were enter and no predicted values will be calculated All worksheets are "Protected" The "mf calculator" is password "Protected" OTHER CHANGES FROM PREVIOUS RPA PROGRAM: A. When Model is applied (Check box activated): 1) assumes only chroinc dilution known 2) assumes user will insert appropriate flow values for "7Q10s (cfs)", "7Q10w (cfs)", "30Q2 (cfs)", "QA (cfs)" to define chronic dilution in terms of "IWC %", "IWC %" is the same for all stream flows 3) automatically assigns the entered chronic IWC % to the "IWC @ 7Q10s", "IWC @ 7Q10w", "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page) 3) "1Q10s (cfs)" automatically defaults to no acute dilution, acute IWC = 100% ,"IWC @ 1Q1Os" = 100% which is used in acute WQS calculatons (See "RPA" page) B. When Model is not applied (Check box NOT activated): 1) assumes user will insert appropriate flow values for "7Q10s (cfs)", "7Q10w (cfs)", "30Q2 (cfs)", "QA (cfs)" , "Flow Qw (MGD)" for chronic IWC % calculations, IWC % will vary according to flows 3) automatically calculates chronic -based IWC % for the "IWC @ 7Q10s", "IWC @ 7Q10w", "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page) 3) "1Q10s (cfs)" is automatically calculated bases on entered "7Q10s (cfs)" flow 4) automatically calculates acute -based IWC% for the "IWC @ 1Q1Os" value used in acute WQS calculations (See "RPA" page) C. When paremeter's "Impaired?" check box is activated: 1) automtically activtes the "IMPAIRED" message alert on the "RPA" page for that parameter 2) does NOT make any automatic adjustements to WQS calculations NOTE: If new or expanding discharge and receiving stream impaired, will need to evaluate if additional waste load is allowed 10/30/2013 rdb 1) Amended "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 meatl translator Acute value f) "Cr_Total_CH" - Total Chromium calculated metal translator Chronic value g) "Orin MAE_AC" - Chromium III calculated metal translator Acute value. h) "CrIIIMAE_CH" - Chromium III calculated metal tramslator Chronic value i) "CrVIMAE_AC" - Chromium VI calculated metal translator Acute value j) "CrVINAE_CH" - Chromium VI calculatd metal translator Chronic value k) "PbMAE_AC" - Lead calculated metal translator Acute value m) "PbMAE_CH" - Lead calculated metal translator Chronic value n) "NiMAE_AC" - Nickel calculated metal translator Acute value o) "NiMAE_CH" - Nickel calculated metal translator Chroniv value p) "AuMAE_AC" - Silver calculated metal translator Acute value q) "AuMAE_CH" - Silver calculated metal translator Chronic value r) "ZnMAE-AC" - Zinc calculated metal translator Acute value s) "ZnMAE_CH" - Zinc calculated metal translator Chronic value t) "tss" - assigned TSS harness factor u) "CHA" - calculated combined acute hardness value v) "CHC" - calculated combined chronic hardness value - Added conditional methods to formulas for info display and to incorporate names, no rounding 6) Set up passwortd to protect all pages 'rpa2015' 1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION 1) Inserted "Aresenic, Aquatic Life, C, 50, FW, N/A, pg/L" in first row "INPUT" Table 2, Par01 2) Updated program names to reflect addition of new Arsenic Aquatic Life parameter 3) Inserted "Arsenic" Aquatic Life parameter and cell programming in Arsenic section "RPA" as Chronic and added drop down menu feature 4) Amended labels on "Data" to show H for hardnes and Par01-Par22 for paremeters 1/12/16 REVISED IWC CALCULATIONS TO SHOW FULL DISPLAY on "RPA" 1) Reformatted IWC calculation cells to show caculated value as general (number value will always be displayed) 2) Revised IWC calculation formula to x by 100 to mimic 3) Revised IWC calculation labels to include "%" 4) Revised all calculations using IWC values "Acute", "Chronic" to divide by 100 to correct for IWC % value 1/12/16 REVISED SPREADSHEET TO INDICATE NO DETECT AND MDL 1) Revised "Data" Par01-Par22 Max Value cell conditional statement to display "NO DETECTS" when data set has all no detects 2) Revised "RPA" all parameters Max Pred CW cell formatting to display "NO DETECTS" when required to display no detects 3) Revised "RPA" alert message (under Chronic labels) conditional statement to display "Max MDL = <2 x max adjusted data set value>" when data set has all no detects 4) Revised "RPA" drop menu to add "No detects" to list and display 1/12/16: Corrected formula error in mf formula Par01 to use corrected data set ("Data") Revised "RPA" Cadmium, Copper, Lead, Nickel, Silver, Zinc Acute and Chronic cell conditional statements to have cell display blank if WQS is blank or WQS displays "NO DATA" 1 /21-29/16: 1) Expanded parameter list and program features to add two additional parameters, (Par08) "Chromium III" & (Par09) "Chromium VI". This included adding two new data input sections on "Data" tab with new corresponding RPA evalutaion, non -detect evaluation, formulas for each new data input section; adding two new parameter summary sections to "RPA" tab; revising exsiting parameter designation to new assigned name (Par10 - Par24), data set (_Data08 - _Data24), non -detects (_ND08 - _ND24). 2) For consistency rearranged display, "Input" & "RPA" tabs, to be "Chromium III", "Chromium VI", "Chromium, Total". All features and programing unique to each display was revised accordingly. 3) Corrected Arsenic - Aquatic Life, Berylium Chronic and Acute values on "Input" tab to be exported from metal translator table. 4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (HUC Hard Med = NA mg/I)" when HUC hardness is NA. 5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formulas to assign 25 as hardness value when HUC hardness is NA. 6) Revised "RPA" tab Chromium, Total Reasonable Potential Results section to remove Acute and Chronic labels and allowable Cw calulation/display, area now blank except for MDL feature display. 7) Revised "RPA" tab Chromium III and Chromium VI Reasonable Potential Results sectons to remove display of values for n, #Det, Max Pred Cw, area blank except for display features from added condtional formulas that reference Chromium, Total display and data. NOTE: All RPA evaluation data is generated on each parameter "Data" section and imported to that parameter's "RPA" section, thus, RPA evaluation data can be displayed/used when programmed to do so. 8) Revised "RPA" tab Acute and Chronic conditional formulas for active parameters to display either "IWC?" or "IWC/DATA?" as default until appropraite data is provided. 9) Removed label from "Input" tab. 10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Method 625. See task notes 2/3/16: Revised "input"page model feature to a- Add new model 1Q1OS input cell that is visible on;y when model feature is activated b- Revise cell formula 1 Q10s (cfs) to display 1 Q10s flow when model feature activated or calculate from 7Q10s flow when model feature NOT activated and 7Q10s flow displayed c- Revised instructions narrartive that is visible only when model feature is activated 2/9/16: Revised "input" page Effluent Hardness (Median) cell formula to display "default 99 mg/L (Efflunet Hard Med = <actual value> mg/L)" when stream class is WS and Effluent Hard Med is greater than 99.999 mg/L Revised "data" page Effluent Hardness (Median) cell formula to display 99 whenstream class is WS and Effluent Hard Med is greater than 99.999 mg/L Added new display messages to "rpa" page that are visible only when the steam class is water supply 2/16/16: 1) Revised "Diss to Total Metal Calculator" page: added new cells to display actual calculated Effluent & HUC Median values and to display "Apply Water Supply Criterion" when applicable (stream class is Water Supply based and Efflunet Hard Med exceeds 99.999 mg/L) revised the existing calculation input/display cells for Effluent & HUC Hardness Median to show the applied hardness value based on new conditional formula as follows a- If HUC Hard Med = NA or less than 25 mg/L then default HUC Hard Med to 25 mg/L b- If Effluent Hard Med less than 25 then default Effluent Hard Med to 25 mg/L c- If stream class is WS and Effluent Hard Med is greater than 99.9999 mg/L then default Effluent Hard Med to 99 mg/L 2) Revised "input" page dipplay HUC Hardness (Median) to show NA when HUC table value is NA. 2/19/16: Added new WS WQC button to "input" page, activates effluent hardness to apply WS WQC standards, does NOT set parameter modifiers, still must do modifers individually Added Nickel WS parameter to "input" page Added Nichel WS to "rpa" page, revised both Nickel parametesr to share commom data, Nickel WS has no Acute standard so only list acute for FW Set up both Nickel Par17 & Par18 to use same data entries Changed Par22-25 modifier cells to be set automtically based on WQS entry. Changed display font color phenols, chlorinared phenols menus 2/22/16: Make text changes per Julie direction. 2/24/16: Added to " Diss to Total Metal Calculator" page: 1) Comment section for PERCS info or other to allow user to add commentary 2) Added Facility name to display based on input page 3) Added NPDES permit# to display based on input page 4) Set up new Name "PERCS_page" as print area for table and other PERCS info for GOTO use. NOTE: User can either highlight desire print area or use GOTO feature to set up desired print arae. When in print mode set up, will need to designate "Print Selection". 3/18/16: Removed HUC table and HUC hardness lookup features from calculations and program. Note: HUC number is an available option on the INPUT as an informational input only to use as a display label for other portion of the progam and has no Data Validation features. Added Upstream Hardness calculation feature using measured upstream data: 1) INPUT display shows "Upstream Hardess" status and how upstream data is applied 2) DATA has new Upstream Hardness input sheet to accept upstream hardness data used to calculate number of data enties, data set average, data set 10th percentile value 3) Diss to Total Metal Calculator determines which upstream hardness to apply, if the number of data entries exceed 30 then the average value is used, if the number of data enties are less than 30 then the 10th percentile value is used. Anytime the applied upstream hardness is less than 25 mg/L then a default value of 25 mg/L is applied. 4/26/16: Per Julia want to use average values for both the effluent and upstream hardness calculations. Defaults to be the same as was applied in the HUC base RPA. 1) Changed all upstream hardness median calculations to average calculations. 2) Removed any greater than 99.999 defaults from upstream hardness conditional statements. Upstream average will be actual execpt when less than 25, then 25 is the default. 3) Changed all effluent hardness median calculations to average calculations. Conditional statements for WS still apply, efflunet average value above 99.999 default to 99. 4) Any conditional statement referring to median hardness were revised. 5) Removed "(AL)" from parameter labels as no longer applicable. 6) Renamed RPA to describe features 4/27/16: Per Julia when WS is being applied, the combined acute and chroinc hardness needs to default to 100 if the combined hardness exceeds 100. Made changes: 1) Set up new cells to calculate combined acute and chronic hardness, defined cells as program names ACCH & ACAH. 2) Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH & ACAH exceed 100 when WS was applied. 3) Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate defaults 4) Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate defaults 4/28/16: Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI now function. Revised RPA page drop menu "Recommended Action" list to remove RP Action Level text and change "RP non action level..." text to state "RP shown...". Added statement to 2B .0500 RULES page "4/28/16: Note Action Level designation no long allowed per EPA." 4/29/16: Added ROUND function to conditional statements on INPUT page hardess displays to limit hardness value display to 2 decimal points. Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardness of 25 to be displayed as non -default value. 5/6/16: Removed less than 25 mg/L default from all effluent and upstream hardness conditional programming 5/11/16: Added new conditional display to Total Chromium Pred Cw box RPA page to compare Total Chromium data to Cr III and Cr VI Allowable Cw Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Total Chromium value entered 6/13/16: Revised title block text RPA tab to state "NC STANDARDS OR EPA CRITERIA", removed "NC WQS" from Chronic label, and removed 1/2 FAV from Acute label. Corrected INPUT tab to align Dats Source(s) text box at top. 6/14/16: Revised conditions for calculated combined hardness acute and chroinc to default to 400 mg/L if calculated value exceeded 400 mg/L Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when default 400 mg/L applied Corrected label on DISS ... page to indicate average for effluent and upstream hardness 7/13/16: Revised Model input feature when activated to calculate Model 7Q10s (cfs) flow based on entry of Qw, MGD and CHRONIC DILITION FACTOR (from Model) and display in Model narrative box. User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry box. 1 Q10s is calculated once the calculated 7Q10s (cfs) is entered in Tablel . Revised narrative in Model narrative box with new instructions, new messages to alert user on actions needed and/or completed to correctly enter Model 7Q10s (cfs) in Table 1. Remove conditions and features assocaited with entry of Model Acute IWC % . Date: 8/13/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. FACILITY: Belews Steam Station NPDES PERMIT: NC0024406 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] 2.0000 Total Suspended Solids -Fixed Value- (mg/L) Combined Hardness chronic (mg/L) Combined Hardness Acute (mg/L) Instream Wastewater Concentration (Chronic) Instream Wastewater Concentration (Acute) Upstream Hardness Average (mg/L) 25 Effluent Hardness Average (mg/L) 0.0000 0.0000 0.0000 10 25.000 25.000 100.0000 100.0000 i 25 PARAMETER Dissolved Metals Chronic Acute [ug/I] [ug/I] US EPA Translators- using Default Partition Coefficients (streams) Maximum Allowable Effluent Concentration (MAEC) as a Total Metal =Dissolved Metal + Translator Chronic Acute Upstream Hard Avg (mg/L) = 25 EFF Hard Avg (mg/L) = 25 [ug/I] [ug/I] Cadmium (d) Cd -Trout streams Chromium III (d)(h) Chromium VI (d) Chromium, Total (t) Copper (d)(h) Lead (d)(h) Nickel (d)(h) Ni - WS streams (t) Silver (d)(h,acute) Zinc (d)(h) 0.15 0.15 24 11 2.7 0.54 16 0.06 36 0.82 0.51 183 16 3.6 14 145 0.30 36 0.252 0.252 0.202 1.000 0.348 0.184 0.432 1.000 0.288 0.59 0.59 117.73 11.00 N/A 7.88 2.94 37.23 3.24 2.01 905.08 16.00 N/A 10.47 75.49 335.21 25 N/A 0.06 0.30 126.73 125.71 Beryllium Arsenic (d) 6.5 150 65 340 1.000 1.000 6.5 150 65 340 COMMENTS (identify parameters to PERCS Branch to maintain in facility's LTMP/STMP): (d) = dissolved metal standard. See 15A NCAC 02B .0211 for more information. (h) = hardness -dependent dissolved metal standard. See 15A NCAC 02B .0211 for more information. (t) = based upon measurement of total recoveable metal. See 15A NCAC 02B .0211 for more information. The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard. The Human Health standard for Arsenic is 10 µg/L which is Total Recoverable metal standard. ACAH ACCH 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 mq/L, expressed as CaCO, or Ca+Mq, as the default Hardness OR To determine a Hardness value for permit Hardness (mass balance) limit development, use the following equation: _ (Hardness instream(a), mq/L * 7Q10, MGD)+(Hardness effluent(b), ma/L* Plant flow, MGD) (7Q10, MGD + Plant flow, MGD) (a) Use the median instream Hardness value of the ambient 8-digit HUC data collected by the Division of Water Quality. To find the 8-digit HUC hardness 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 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 III, Acute 0.316 • e^{0.8190[In hardness]+3.7256} Chromium III, Chronic 0.860 • e^{0.8190[In hardness]+0.6848} Copper, Acute 0.960 • e^{0.9422[In hardness]-1.700} Copper, Chronic 0.960 • e^{0.8545[In hardness]-1.702} Lead, Acute {1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-1.460} Lead, Chronic {1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]4.705} Nickel, Acute 0.998 • e^{0.8460[In hardness]+2.255} Nickel, Chronic 0.997 • e^{0.8460[In hardness]+0.0584} Silver, Acute 0.85 • e^{1.72[In hardness]-6.59} Silver, Chronic Not applicable Zinc, Acute 0.978 • e^{0.8473[In hardness]+0.884} Zinc, Chronic 0.986 • e^{0.8473[In hardness]+0.884} Complete information on all the proposed Surface Water Quality Standards can be viewed at: http://h2o.enr.state.nc.us/csu/trirev SW.html. US EPA Translators using Default Partition Coefficients (DPC) Translator equation using Default Partition Coefficients = 1 v. 6/2/2010 [1 + (Kpo * TSS (1+a) * 10-6)1 Kpo and a are constants that express the equilibrium relationship between dissolved and adsorbed forms of metals. A default value of 10 mg/L Total Suspended Solids (TSS) will be used. Table A contains the Default Partition Coefficients for the equation. Table B contains the calculated translators using the default partition coefficients for streams. TABLE A. Default Partition Coefficients STREAMS Metal (1) Kpo a Cu 1.04E+06 -0.7436 Zn 1.25E+06 -0.7038 Pb 2.80E+06 -0.8 Cr (III) (2) 3.36E+06 -0.09304 Cd 4.00E+06 -1.1307 Ni 4.90E+05 -0.5719 (1) Delos, C.G., et al. Technical Guidance for Performing Waste Load Allocations. Book II: Streams and Rivers. Chapter 3: Toxic Substances, For the U.S. EPA. (EPA-140 4-84-022) (2) Linear partition coefficients shall not apply to the Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefore, TABLE B. US EPA Translators PARAMETER US EPA Translators Using stream Default Partition Coefficients TSS = 10 mg/L Cadmium 0.252 Chromium III 0.202 Chromium VI 1 Chromium, Total N/A Copper 0.348 Lead 0.184 Nickel 0.432 Silver 1 Zinc 0.288 Example for Cadmium (streams) Given: TSS = 10 mg/L Kpo = 4.00E + 06 a =-1.1307 Translator = 1 [1 + (Kpo * TSS a*a) * 10-)] 1 [1 + (4.00x106 * 10'-L1307) * 106)] 1 [1+2.960465] = 0.252