Loading...
HomeMy WebLinkAboutNC0003417_Other_20220728H.F. Lee N C0003417 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators MAXIMUM DATA POINTS = 58 Qw (MGD) = 0.34 1Q10S (cfs) = 213.23 7Q1OS (cfs) = 263.00 7Q1OW (cfs) = 260.00 30Q2 (cfs) = NO 30Q2 DATA Avg. Stream Flow, QA (cfs) = 1100.00 Receiving Stream: Neuse River HUC 03020201 WWTP/WTP Class: NA IWC% @ 1 Q 10S = 0.246541634 IWC% @ 7Q1OS = 0.199979509 IWC% @ 7Q1OW = 0.202282297 IWC% @ 30Q2 = N/A IW%C @ QA = 0.047886149 Stream Class: WS-IV; NSW Outfall seeps Qw = 0.34 MGD COMBINED HARDNESS (mg/L) Acute = 25 mg/L Chronic = 25 mg/L YOU HAVE DESIGNATED THIS RECEIVING STREAM AS WATER SUPPLY Effluent Hard: 0 value > 100 mg/L Effluent Hard Avg = 25 mg/L PARAMETER TYPE (1) NC STANDARDS OR EPA CRITERIA CJ N REASONABLE POTENTIAL RESULTS RECOMMENDED ACTION Chronic Applied Acute Standard 11 # Det. Max Pred Cw Allowable Cw Arsenic Arsenic C C 150 FW(7Q10s) 340 10 FIH/WS(Qavg) ug/L ug/L 6 5 Note: n < 9 Limited data set 28.5 Default C.V. Acute (FW): 137,907.7 _ _ __ _ _ _ Chronic (FW)_75,007.7 No value > Allowable Cw _____________________________ Chronic (HH): 20,882.9 No value > Allowable Cw no limit ____________________________ Beryllium NC 6.5 FW(7Q10s) 65 ug/L 0 0 N/A Acute: 26,364.72 Chronic: --- 3,250.33 — ---------------------------- Cadmium NC 0.5899 FW(7Q10s) 3.2396 ug/L 6 0 Note: n < 9 Limited data set NO DETECTS Acute: 1,314.022 Chronic: 294.97 Max MDL = 0.1 no limit Chlorides NC 250 WS(7Q10s) mg/L 6 6 Note: n < 9 Limited data set 66.3 Default C.V. Acute: NO WQS ___ _ ___ _ _ _ Chronic: 125,012.8 No value > Allowable Cw no limit ____________________________ Chlorinated Phenolic Compounds NC 1 A(30Q2) ug/L 0 0 N/A Acute: NO WQS Chronic: ----IWC? -- ---------------------------- Total Phenolic Compounds NC 300 A(30Q2) ug/L 0 0 N/A Acute: NO WQS Chronic: ----IWC? -- ---------------------------- Chromium III NC 117.7325 FW(7Q10s) 905.0818 µg/L 0 0 N/A Acute: 367,111.1 Chronic: --- 58,872.3 — ---------------------------- Chromium VI NC 11 FW(7Q10s) 16 µg/L 0 0 N/A Acute: 6,489.8 Chronic: ----5,500.E-- ---------------------------- Chromium, Total NC µg/L Tot Cr value(s) 6 1 Note: n < 9 Limited data set < 50 and < Cr VI 4.1 Default C.V. Allowable Cw Max reported value = 1.9 no limit Page 1 of 3 NC0003417_0ther_20220728, rpa 11/28/2022 H.F. Lee N C0003417 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Outfall seeps Qw = 0.34 MGD Copper NC 7.8806 FW(7Q10s) 10.4720 ug/L 6 0 Note: n < 9 Limited data set NODETECTS Acute: 4,247.56 Chronic: 3,940.72 Max MDL = 2 no limit Cyanide NC 5 FW(7Q10s) 22 10 ug/L 0 0 N/A Acute: 8,923.4 Chronic:----2,500.3-- ---------------------------- Fluoride NC 1800 FW(7Q10s) ug/L 6 6 Note: n < 9 Limited data set 1.3 Default C.V. Acute: NO WQS ___ _ ____ _ _ Chronic: 900,092.2 No value > Allowable Cw no limit ____________________________ Lead NC 2.9416 FW(7Q10s) 75.4871 ug/L 6 1 Note: n < 9 Limited data set 2.183 Default C.V. Acute: 30,618.400 ___ _ ____ _ _ _ Chronic: 1,470.963 No value > Allowable Cw no limit ____________________________ Mercury NC 12 FW(7Q10s) 0.5 ng/L 6 4 Note: n < 9 Limited data set 21.4 Default C.V. Acute: NO WQS ___ _ ____ _ ___ Chronic: 6,000.E No value > Allowable Cw no limit ____________________________ Nickel Nickel NC NC 37.2313 FW(7Q10s) 335.2087 25.0000 WS(7Q10s) µg/L µg/L 6 0 Note: n < 9 Limited data set NO DETECTS Acute (FW): 135,964.3 Ti_ _ __ _ _ Cronic (FW)_18,617.E Max _MDL = 1 _ _ _____________________________ Chronic (WS): 12,501.3 Max MDL = 1 no limit ____________________________ Selenium NC 5 FW(7Q10s) 56 ug/L 6 0 Note: n < 9 Limited data set NODETECTS Acute: 22,714.2 Chronic: 2,500.3 Max MDL = 1 no limit Zinc NC 126.7335 FW(7Q10s) 125.7052 ug/L 6 0 Note: n < 9 Limited data set NODETECTS Acute: 50,987.4 Chronic: 63,373.2 Max MDL = 5 no limit Barium NC 1000 WS(7Q10s) µg/L 6 6 Note: n < 9 Limited data set 111.3 Default C.V. Acute: NO WQS ___ _ ____ _ ___ Chronic: 500051 No value > Allowable Cw no limit ____________________________ Boron NC 34000 FW(7Q10s) 7300 µg/L 6 6 Note: n < 9 Limited data set 137.0 Default C.V. ########### no limit ____________________________ Acute: ___ _ ____ _ Chronic: 17001741 9 No value > Allowable Cw Nitrate NC 10000 WS(7Q10s) µg/L 6 6 Note: n < 9 Limited data set 300 Default C.V. Acute: NO WQS ___ _ ____ _ _ _ Chronic: 5000512 No value > Allowable Cw no limit ____________________________ Sulfate NC 250 WS(7Q10s) mg/L 6 2 Note: n < 9 Limited data set 21.4 Default C.V. Acute: NO WQS ___ _ ____ _ _ _ Chronic: 125012.8 No value > Allowable Cw no limit ____________________________ Page 2 of 3 NC0003417_0ther_20220728, rpa 11/28/2022 H.F. Lee NC0003417 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Outfall seeps Qw = 0.34 MGD N00003417_0ther_20220728, rpa Page 3 of 3 11/28/2022 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 H.F. Lee NA NC0003417 seeps 0.340 Neuse River 03020201 WS-IV; NSW 0 Apply WS Hardness WQC 7Q10s (cfs) 7Q1Ow (cfs) 30Q2 (cfs) QA (cfs) 1 Q10s (cfs) 263.00 260.00 1100.00 213.23 Effluent Hardness Upstream Hardness Combined Hardness Chronic Combined Hardness Acute 25 mg/L (Avg) 25 mg/L (Avg)— 25 mg/L 25 mg/L Data Source(s) CHECK TO APPLY MODEL 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 Water Supply NC 250 WS 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 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 Barium Water Supply NC 1000 WS pg/L Boron Aquatic Life NC 34000 FW 7300 pg/L Nitrate Water Supply NC 10000 WS pg/L NC0003417_Other 20220728, input 11/28/2022 Monitoring Frequencies 2B .0500 Effluent Limited pH Temp, C BOD5 TSS NH3-N Fecal Col. TN TP E E I, E I, E E E E E 2/Month 1/Week 2/Month 2/Month 1/Month 2/Month Water Quality Limited Parameter Location Class I D.O. D.O. pH Temp, C Temp, C BOD5 TSS NH3-N TRC Fecal Col. Fecal Col. Conductivi Conductivi TN TP U. E E U, D I, E I, E E E U, D E U, D E E 1/Week 1/Week 1/Week 1/Week 3/Week 3/Week 3/Week 3/Week 2/Month 1/Week 1/Week 3/Week See notes below. See notes below. Frequency Daily Daily Daily Daily 3/Week Daily 1/Week 1/Week 2/Month Daily 1/Week 2/Month 2/Month 1/Month 2/Week 2/Month 2/Month 1/Week 1/Week Class II Class III 1/Week 3/Week 1/Week 3/Week' 1/Week 3/Week Daily Daily 1/Week 3/Week` 1/Week 3/Week 1/Week 3/Week 2/Month 1/Week 2/Week 3/Week 1/Week 3/Week 1/Week 3/Week' 1/Week 3/Week 1/Week 3/Week' See notes below. See notes below. Class IV Daily 3/Week' Daily Daily 3/Week' Daily Daily 3/Week Daily Daily 3/Week' Daily 3/Week' Notes: Upstream and downstream monitoring in WQ-limited waters is to be conducted 3/Week during Jun, Jul, Aug, and Sep; and 1/Week during the rest of the year. TN, TP Monitoring All facilities >= 0.05 MGD will monitor TN and TP Those < 0.05 MGD will monitor if discharging to NSW For the Neuse, Tar -Pamlico, and any other river basins classifed as NSW, use limits and monitoring requirements according to the basin's permitting strategy. For French Broad, Broad, Savannah, New Watauga, Little Tennessee, and Hiwassee: - >= 0.05 M: - monitor semiannually - >= 1.0 MG - monitor quarterly For all other river basins: - >= 0.05 M: - monitor quarterly - >= 1.0 MG - monitor monthly Per Memo Dated 7-15-2010 RPA Condition Permit Monitoring Frequency I.RPA Exists Monitor Moodily and add Permit Limit 2RPA Exists but Action Levels (Cu, Zn, Ag Fe, CI) Monitor Quarterly in conjunction with Tox Test 3a.RPA Exists but Dataset Limited (n<8 samples) 3b. RPA exists, dataset limited, but 2 values > allowable Ctv Monitor Quarterly Monitor Monthly and add Permit Limit 4.No RPA (Predicted Max> 50% of Allowable) Monitor Quarterly (or defer to Pretreat LTMP) 5.No RPA (Predicted Max <50% Allowable) No Monitoring 6a No Data (New Permit., New Waste Stream) 6b. New Greensand or Conventional RTP Monitor Monthly for Toxic Pollutants of Coecem 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 > MaxPredCw < Acute MaxPredCw < Chronic MaxPredCw « Acute MaxPredCw « Chronic MaxPredCw > Acute MaxPredCw > Chronic MaxPredCw » Acute MaxPredCw» Chronic No acute standard or 1/2 FAV No chronic standard or criterion NO DATA MONITOR? MONITOR? REMOVE? REMOVE? DAILY MAX LIMIT? MO AVG LIMIT? DAILY MAX LIMIT? MO AVG LIMIT? N/A N/A Sample recommendations: Daily max limit Monitor 1/month Monitor 1/week Monitor2/month Monitoring not necessary in permit No limit No limit - assuming no tox (Action Level parameter) No limit (Action Level parameter) Continue to monitor at 2/month Mo. avg. limit (keep wk. avg. if existing) Revise daily max. limit REASONABLE POTENTIAL ANALYSIS H1 Effluent Hardness Date Data BDL=1/2DL Results 1 25 25 Std Dev. 2 Mean 3 C.V. (default) 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 0.0000 25.0000 0.6000 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. (default) 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 0.0000 25.0000 0.6000 1 25.00 mg/L 25.00 mg/L 25.00 mg/L -3- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS Par01 & Par02 Arsenic Date Data BDL=1/2DL Results 1 13.3 13.3 Std Dev. 2 11.6 11.6 Mean 3 4.8 4.8 C.V. (default) 4 1.7 1.7 n 5 2.23 2.23 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 5.4490 5.6883 0.6000 6 2.14 13.3 ug/L 28.5 ug/L -4- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS Par03 Beryllium Date Data BDL=1/2DL Results 1 Std Dev. 2 Mean 3 C.V. 4 n 5 6 Mult Factor = 7 Max. Value 8 Max. Pred Cw 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par04 Cadmium NO DATA NO DATA NO DATA 0 N/A N/A ug/L N/A ug/L 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. (default) 4 < 0.1 0.05 n 5 < 0.1 0.05 6 < 0.1 0.05 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 0.0000 0.0500 0.6000 6 Mult Factor = 2.14 Max. Value 0.050 ug/L Max. Pred Cw 0 DETECTS ug/L -5- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS Par05 Chlorides Date Data 28 27 28 26 27 31 BDL=1/2DL Results 28 Std Dev. 27 Mean 28 C.V. (default) 26 n 27 31 Mult Factor = Max. Value Max. Pred Cw Use "PASTE SPECIAL - Values" then "COPY" . Maximum data points = 58 Par06 Chlorinated Phenolic Compounds 1.7224 27.8 0.6000 6 2.1 31.0 mg/L 66.3 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 N00003417_0ther_20220728, data - 6 - 11/28/2022 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 -7- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Par09 Chromium VI Date Data BDL=1/2DL Results 1 Std Dev. 2 Mean 3 C.V. 4 n 5 6 Mult Factor = fag/L 7 Max. Value fag/L 8 Max. Pred Cw 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par10 Chromium, Total NO DATA NO DATA NO DATA 0 N/A N/A fag/L N/A fag/L Use "PASTE SF Values" then "I . Maximum c points = 5 Date Data BDL=1/2DL Results 1 < 0.1 0.05 Std Dev. 0.7553 2 < 0.1 0.05 Mean 0.3583 3 < 0.1 0.05 C.V. (default) 0.6000 4 < 0.1 0.05 n 6 5 1.9 1.9 6 < 0.1 0.05 Mult Factor = 2.14 7 Max. Value 1.9 8 Max. Pred Cw 4.1 -8- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Pal 1 Copper Date Data BDL=1/2DL Results 1 < 2 1 Std Dev. 2 < 2 1 Mean 3 < 2 1 C.V. (default) 4 < 2 1 n 5 < 2 6 < 2 fag/L 7 fag/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 0.0000 1.0000 0.6000 6 1 1 Mult Factor = 2.14 Max. Value 1.00 ug/L Max. Pred Cw 0 DETECTS 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 N00003417_0ther_20220728, data - 9 - 11/28/2022 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Par13 Fluoride Date Data BDL=1/2DL Results 1 0.37 0.37 Std Dev. 2 0.36 0.36 Mean 3 0.49 0.49 C.V. (default) 4 0.31 0.31 n 5 0.35 0.35 6 0.59 0.59 Mult Factor = ug/L 7 Max. Value ug/L 8 Max. Pred Cw 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par14 0.1063 0.4117 0.6000 6 2.14 0.6 ug/L 1.3 ug/L Date < 0.2 < 0.2 < 0.2 < 0.2 1.02 < 0.2 Use "PASTE SF Values" then "I . Maximum c points = 5 BDL=1/2DL Results 0.1 Std Dev. 0.3756 0.1 Mean 0.2533 0.1 C.V. (default) 0.6000 0.1 n 6 1.02 0.1 Mult Factor = 2.14 Max. Value 1.020 Max. Pred Cw 2.183 Lead -10- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Par15 Mercury Date Data BDL=1/2DL Results 1 1.17 1.17 Std Dev. 2 1.34 1.34 Mean 3 3.02 3.02 C.V. (default) 4 < 0.5 0.25 n 5 10 10 6 < 0.5 0.25 Mult Factor = ug/L 7 Max. Value ug/L 8 Max. Pred Cw 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 3.7305 2.6717 0.6000 6 2.14 10.0 ng/L 21.4 ng/L Par16 Use "PASTE SF Values" then "I . Maximum c points = 5 Date Data BDL=1/2DL Results 1 Std Dev. NO DATA 2 Mean NO DATA 3 C.V. NO DATA 4 n 0 5 6 Mult Factor = N/A 7 Max. Value N/A 8 Max. Pred Cw N/A 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Molybdenum -11- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS 'ECIAL• COPY" lata ;8 Par17 & Par18 Nickel 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 = ug/L 7 Max. Value ug/L 8 Max. Pred Cw 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Par19 Values" then "COPY" . Maximum data points = 58 Selenium 0.0000 0.5000 0.6000 6 2.14 0.5 fag/L 0 DETECTS fag/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 -12- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par20 Silver 0.0000 0.5000 0.6000 6 2.14 0.5 ug/L 0 DETECTS ug/L Date Data BDL=1/2DL Results Std Dev. Mean C.V. n Mult Factor = Max. Value Max. Pred Cw Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par21 Zinc NO DATA NO DATA NO DATA 0 N/A N/A ug/L N/A ug/L Date Data BDL=1/2DL 2.5 2.5 2.5 2.5 2.5 2.5 5 5 5 5 5 5 Results Std Dev. Mean C.V. (default) n Mult Factor = Max. Value Max. Pred Cw -13- NC0003417_Other_20220728, data 11/28/2022 REASONABLE POTENTIAL ANALYSIS Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par22 Barium 0.0000 2.5000 0.6000 6 2.14 2.5 ug/L 0 DETECTS ug/L Date Data BDL=1/2DL Results 1 42 Std Dev. 2 41 41 Mean 3 52 52 C.V. (default) 4 35 35 n 5 43 43 6 23 23 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 Par23 Boron 10.7331 38.8000 0.6000 5 Mult Factor = 2.14 Max. Value 52.000000 fag/L Max. Pred Cw 111.280000 fag/L Date Data BDL=1/2DL 1 64 64 2 63 63 3 60 60 4 57 57 5 51 51 6 54 54 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 N00003417_0ther_20220728, data - 14 - 11/28/2022 REASONABLE POTENTIAL ANALYSIS Results Std Dev. Mean C.V. (default) n Use "PASTE SPECIAL - Values" then "COPY" . Maximum data points = 58 Par24 Nitrate 5.1153 58.1667 0.6000 6 Mult Factor = 2.14 Max. Value 64.000000 fag/L Max. Pred Cw 136.960000 fag/L Date Data BDL=1/2DL Results 1 60 60 Std Dev. 2 60 60 Mean 3 80 80 C.V. (default) 4 140 140 n 5 90 90 6 90 90 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- Par25 Values" then "COPY" . Maximum data points = 58 29.4392 86.6667 0.6000 6 2.14 140.000000 fag/L 299.600000 fag/L Date Data 0.1 0.1 0.1 10 4.4 0.1 N00003417_0ther_20220728, data - 15 - 11/28/2022 REASONABLE POTENTIAL ANALYSIS Sulfate BDL=1/2DL Results 0.05 Std Dev. 0.05 Mean 0.05 C.V. (default) 10 n 4.4 0.05 Mult Factor = Max. Value Max. Pred Cw Use "PASTE SPECIAL• Values" then "COPY" . Maximum data points = 58 4.0950 2.4333 0.6000 6 2.14 10.000000 mg/L 21.400000 mg/L -16- NC0003417_Other_20220728, data 11/28/2022 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 RPMFs as f(n,CV,Confidence,U pperBound) 400.00 350.00 300.00 ifl roU 250.00 u_ c 0 fa 200.00 u t. 150.00 100.00 7 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 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 "ERP" alert on data sets entreies to activate if "<" entered but no value entered, does not effect RPA calculation, ERR message only 2) Added new calculation feature to count nondetects when both "<" and a value are entered for each data set, used to calculate detected entries 3) Amended "Comments" drop down menu - per Juile 4) Turned the Chronic toxicity concentration message off on the RPA page - per Julie 2/10/14: ON "data" page changed highlighted area from blue shades to gray 5/2/14 rdb 1) Increased rounding factor on all calculated IWC% to 7 decimals 2) Increased display for all calkculated to 6 decimals places. 5/5/14 rdb Increased rounding factor on all calculated IWC% to 9 decimals 5/21/14 rdb Removed ROUND function from all IWC% calculations 7/31/14 rdb Moved RPA page tile blocks down one row so header text was separated 9/9/15: COMPLETED REVISIONS FOR METAL TRANSLATOR FEATURE 1) Added tabs for "HUC Hardness" (lookup table for HUC hardness values), "Hardness Equations" (summary of translator formulas, metals impacted, general info), "Dss to Total Hardness Calculator" (calcution sheet for metal translator, impacted chronic and acute wqs) 2) Revised "Input" page Table 1: - New user input for "8 Digit HUC Number" uisng drop down menu for lookup HUC Hardness, required entry, brown highlight - New display only for calculated "Effluent Hardness (Median)" including conditional method for info display, brown highlight - New display only for designed "HUC Hardness (Median)" incuding conditionla method for info display, brown highlight - New display only for calculated "Combined Hardness Chronic" for metal translator application, brown highlight - New display only for calculated "Combined Hardness Acute" for metal translator application, brown highlight - Assigned name for "HUC Number" 3) Revised "Input" pade Table 2: - Removed "Impaired ?" column, conditional display, references - Added new column for "WQS" designation incuding assigning applicable WQS where fixed - Added new error message "CHECK WQS", conditonal control based on "WQS" entry for Cadmium, Chlorides, Molybdeum, Nickel - Revised text in error message - Added new brown highlight "Metal Translator Data Entry" label box - Removed Par01 "Arsenic" line - Revised Par02 " Arsenic" line to reflect Human Health and Water Supply criterion, Chronic = 10 mg/L, Acute = "N/A" - Revised Par04 "Cadmium" line: a) "WQS" input with drop down menu to select applicable criterion b) "Chronic" and "Acute" inputs to display calculated metal translator values including conditional method for info display based on "WQS" selection, no rounding c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly d) Conditonal controls to activate error nessages, brown highlight - Revised Par05 "Chloride (AL)" line: a) "WQS" input with drop down menu to select applicable criterion b) "Chronic" display only for applicable value including conditional method for info display based on "WQS" selection c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly d) "Name" display only based on "WQS" selection including conditional metdod fro info display e) Conditonal controls to activate error nessages - Revised "Chromium, Total" line: a) Removed Par08 label b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding c) brown highlight - Added new "Chromium III" line: a) Assigned applicable text in "WQS", "Type", Modifier", Units" b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding c) brown highlight - Added new Par08 "Chromium VI" line: a) Assigned Par08 label, applicable text in "WQS", "Type", Modifier", Units" b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding c) brown highlight - Revised Par09 "Copper (AL)" line: a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding b) brown highlight - Revisd Par12 "Lead" line: a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding b) brown highlight - Revised Par14 "Molybdenum" lime: a) "WQS" input with drop down menu to select applicable criterion b) "Chronic" display only for applicable value including conditional method for info display based on "WQS" selection c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly d) Conditonal controls to activate error nessages - Revised Par15 "Nickel" line: a) "WQS" input with drop down menu to select applicable criterion b) "Chronic" and "Acute" inputs to display calculated metal translator values including conditional method for info display based on "WQS" selection, no rounding c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly d) Conditonal controls to activate error nessages, brown highlight - Revised Par17 "Silver (AL)" line: a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding b) brown highlight - Revised Par18 "Zinc (AL)" line: a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding b) brown highlight 3) Revised "Data" page: - Revised Par01 "Arsenic" entry, text, and calculations ("1") - all effluent hardness data to be entered in this section for used to calculate eflluent hardness factors a) Reference to Par01 "Arsenic" removed b) New label "Effluent Hardness (monthly average)" added c) "Mult Factor =" and "Max. Pred Cw" removed, text and calcuation d) "10% value" and "Median value" added, text and calculation including conditional method for info display e) Assigned name "Effluent_Median" and "effluent_10" to calculated values f) PQL condition removed from calculation method for data displayed 4) Revised "RPA" page: - Removed all features assocaited with "Impairment" - Added new display only for calculated "COMBINED HARDNESS (mg/L)", Chonic and Acute, conditional method for info display - Revised "Receiving Stream" display to include selected HUC Number in text - Removed unused display features for WET % (previouly hidden) - Revised "Arsenic" lines: a) Par01 "Arsenic" line removed b) Par02 "Arsenic" references used for display to calculate "Acute" and Chronic" allowable Cw - Revised "Cadmium", "Chromium VI", "Copper (AL)", "Lead", "Nickel", "Silver (AL)", "Zinc (AL)" (lines: a) "NC WQS/Chronic" and 1/2 FAV/Acute" conditional method revised for info display, no rounding b) "Allowable Cw" Acute" and "Chronic" conditional metfhod revised fro info display inculding rounding value 5) Revised "Dss to Total Metal Hardness Calculator" page - Assigned names for: a) "CdMAE_AC" - Cadmium calculated metal translator Acute value b) "CdMAE_CH" - Cadmium calculated metal translator Chronic value c) "CuMAE_AC" - Copper calculatd metal translator Acute value d) "CuMAE_CH" - Copper calculated metal translator Chronic value e) "Cr_Total_AC" - Total Chromium calculated meat) translator Acute value f) "Cr_Total_CH" - Total Chromium calculated metal translator Chronic value g) "CrIIIMAE_AC" - Chromium III calculated metal translator Acute value. h) "CrIIIMAE_CH" - Chromium III calculated metal tramslator Chronic value i) "CrVIMAE_AC" - Chromium VI calculated metal translator Acute value j) "CrVINAE_CH" - Chromium VI calculatd metal translator Chronic value k) "PbMAE_AC" - Lead calculated metal translator Acute value m) "PbMAE_CH" - Lead calculated metal translator Chronic value n) "NiMAE_AC" - Nickel calculated metal translator Acute value o) "NiMAE_CH" - Nickel calculated metal translator Chroniv value p) "AuMAE_AC" - Silver calculated metal translator Acute value q) "AuMAE_CH" - Silver calculated metal translator Chronic value r) "ZnMAE-AC" - Zinc calculated metal translator Acute value s) "ZnMAE_CH" - Zinc calculated metal translator Chronic value t) "tss" - assigned TSS harness factor u) "CHA" - calculated combined acute hardness value v) "CHC" - calculated combined chronic hardness value - Added conditional methods to formulas for info display and to incorporate names, no rounding 6) Set up passwortd to protect all pages 'rpa2015' 1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION 1) Inserted "Aresenic, Aquatic Life, C, 50, FW, N/A, pg/L" in first row "INPUT" Table 2, Par01 2) Updated program names to reflect addition of new Arsenic Aquatic Life parameter 3) Inserted "Arsenic" Aquatic Life parameter and cell programming in Arsenic section "RPA" as Chronic and added drop down menu feature 4) Amended labels on "Data" to show H for hardnes and Par01-Par22 for paremeters 1/12/16 REVISED IWC CALCULATIONS TO SHOW FULL DISPLAY on "RPA" 1) Reformatted IWC calculation cells to show caculated value as general (number value will always be displayed) 2) Revised IWC calculation formula to x by 100 to mimic 3) Revised IWC calculation labels to include "%" 4) Revised all calculations using IWC values "Acute", "Chronic" to divide by 100 to correct for IWC % value 1/12/16 REVISED SPREADSHEET TO INDICATE NO DETECT AND MDL 1) Revised "Data" Par01-Par22 Max Value cell conditional statement to display "NO DETECTS" when data set has all no detects 2) Revised "RPA" all parameters Max Pred CW cell formatting to display "NO DETECTS" when required to display no detects 3) Revised "RPA" alert message (under Chronic labels) conditional statement to display "Max MDL = <2 x max adjusted data set value>" when data set has all no detects 4) Revised "RPA" drop menu to add "No detects" to list and display 1/12/16: Corrected formula error in mf formula Par01 to use corrected data set ("Data") Revised "RPA" Cadmium, Copper, Lead, Nickel, Silver, Zinc Acute and Chronic cell conditional statements to have cell display blank if WQS is blank or WQS displays "NO DATA" 1/21-29/16: 1) Expanded parameter list and program features to add two additional parameters, (Par08) "Chromium III" & (Par09) "Chromium VI". This included adding two new data input sections on "Data" tab with new corresponding RPA evalutaion, non -detect evaluation, formulas for each new data input section; adding two new parameter summary sections to "RPA" tab; revising exsiting parameter designation to new assigned name (Par10 - Par24), data set (_Data08 - _Data24), non -detects (_ND08 - _ND24). 2) For consistency rearranged display, "Input" & "RPA" tabs, to be "Chromium III", "Chromium VI", "Chromium, Total". All features and programing unique to each display was revised accordingly. 3) Corrected Arsenic - Aquatic Life, Berylium Chronic and Acute values on "Input" tab to be exported from metal translator table. 4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (HUC Hard Med = NA mg/I)" when HUC hardness is NA. 5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formulas to assign 25 as hardness value when HUC hardness is NA. 6) Revised "RPA" tab Chromium, Total Reasonable Potential Results section to remove Acute and Chronic labels and allowable Cw calulation/display, area now blank except for MDL feature display. 7) Revised "RPA" tab Chromium III and Chromium VI Reasonable Potential Results sectons to remove display of values for n, #Det, Max Pred Cw, area blank except for display features from added condtional formulas that reference Chromium, Total display and data. NOTE: All RPA evaluation data is generated on each parameter "Data" section and imported to that parameter's "RPA" section, thus, RPA evaluation data can be displayed/used when programmed to do so. 8) Revised "RPA" tab Acute and Chronic conditional formulas for active parameters to display either "IWC?" or "IWC/DATA?" as default until appropraite data is provided. 9) Removed label from "Input" tab. 10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Method 625. See task notes 2/3/16: Revised "input"page model feature to a- Add new model 1Q1OS input cell that is visible on;y when model feature is activated b- Revise cell formula 1Q10s (cfs) to display 1Q10s flow when model feature activated or calculate from 7Q10s flow when model feature NOT activated and 7Q10s flow displayed c- Revised instructions narrartive that is visible only when model feature is activated 2/9/16: Revised "input" page Effluent Hardness (Median) cell formula to display "default 99 mg/L (Efflunet Hard Med = <actual value> mg/L)" when stream class is WS and Effluent Hard Med is greater than 99.999 mg/L Revised "data" page Effluent Hardness (Median) cell formula to display 99 whenstream class is WS and Effluent Hard Med is greater than 99.999 mg/L Added new display messages to "rpa" page that are visible only when the steam class is water supply 2/16/16: 1) Revised "Diss to Total Metal Calculator" page: added new cells to display actual calculated Effluent & HUC Median values and to display "Apply Water Supply Criterion" when applicable (stream class is Water Supply based and Efflunet Hard Med exceeds 99.999 mg/L) revised the existing calculation input/display cells for Effluent & HUC Hardness Median to show the applied hardness value based on new conditional formula as follows a- If HUC Hard Med = NA or less than 25 mg/L then default HUC Hard Med to 25 mg/L b- If Effluent Hard Med less than 25 then default Effluent Hard Med to 25 mg/L c- If stream class is WS and Effluent Hard Med is greater than 99.9999 mg/L then default Effluent Hard Med to 99 mg/L 2) Revised "input" page dipplay HUC Hardness (Median) to show NA when HUC table value is NA. 2/19/16: Added new WS WQC button to "input" page, activates effluent hardness to apply WS WQC standards, does NOT set parameter modifiers, still must do modifers individually Added Nickel WS parameter to "input" page Added Nichel WS to "rpa" page, revised both Nickel parametesr to share commom data, Nickel WS has no Acute standard so only list acute for FW Set up both Nickel Par17 & Par18 to use same data entries Changed Par22-25 modifier cells to be set automtically based on WQS entry. Changed display font color phenols, chlorinared phenols menus 2/22/16: Make text changes per Julie direction. 2/24/16: Added to " Diss to Total Metal Calculator" page: 1) Comment section for PERCS info or other to allow user to add commentary 2) Added Facility name to display based on input page 3) Added NPDES permit# to display based on input page 4) Set up new Name "PERCS_page" as print area for table and other PERCS info for GOTO use. NOTE: User can either highlight desire print area or use GOTO feature to set up desired print arae. When in print mode set up, will need to designate "Print Selection". 3/18/16: Removed HUC table and HUC hardness lookup features from calculations and program. Note: HUC number is an available option on the INPUT as an informational input only to use as a display label for other portion of the progam and has no Data Validation features. Added Upstream Hardness calculation feature using measured upstream data: 1) INPUT display shows "Upstream Hardess" status and how upstream data is applied 2) DATA has new Upstream Hardness input sheet to accept upstream hardness data used to calculate number of data enties, data set average, data set 10th percentile value 3) Diss to Total Metal Calculator determines which upstream hardness to apply, if the number of data entries exceed 30 then the average value is used, if the number of data enties are less than 30 then the 10th percentile value is used. Anytime the applied upstream hardness is less than 25 mg/L then a default value of 25 mg/L is applied. 4/26/16: Per Julia want to use average values for both the effluent and upstream hardness calculations. Defaults to be the same as was applied in the HUC base RPA. 1) Changed all upstream hardness median calculations to average calculations. 2) Removed any greater than 99.999 defaults from upstream hardness conditional statements. Upstream average will be actual execpt when less than 25, then 25 is the default. 3) Changed all effluent hardness median calculations to average calculations. Conditional statements for WS still apply, efflunet average value above 99.999 default to 99. 4) Any conditional statement referring to median hardness were revised. 5) Removed "(AL)" from parameter labels as no longer applicable. 6) Renamed RPA to describe features 4/27/16: Per Julia when WS is being applied, the combined acute and chroinc hardness needs to default to 100 if the combined hardness exceeds 100. Made changes: 1) Set up new cells to calculate combined acute and chronic hardness, defined cells as program names ACCH & ACAH. 2) Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH & ACAH exceed 100 when WS was applied. 3) Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate defaults 4) Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate defaults 4/28/16: Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI now function. Revised RPA page drop menu "Recommended Action" list to remove RP Action Level text and change "RP non action level..." text to state "RP shown...". Added statement to 2B .0500 RULES page "4/28/16: Note Action Level designation no long allowed per EPA." 4/29/16: Added ROUND function to conditional statements on INPUT page hardess displays to limit hardness value display to 2 decimal points. Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardness of 25 to be displayed as non -default value. 5/6/16: Removed less than 25 mg/L default from all effluent and upstream hardness conditional programming 5/11/16: Added new conditional display to Total Chromium Pred Cw box RPA page to compare Total Chromium data to Cr III and Cr VI Allowable Cw Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Total Chromium value entered 6/13/16: Revised title block text RPA tab to state "NC STANDARDS OR EPA CRITERIA", removed "NC WQS" from Chronic label, and removed 1/2 FAV from Acute label. Corrected INPUT tab to align Dats Source(s) text box at top. 6/14/16: Revised conditions for calculated combined hardness acute and chroinc to default to 400 mg/L if calculated value exceeded 400 mg/L Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when default 400 mg/L applied Corrected label on DISS ... page to indicate average for effluent and upstream hardness 7/13/16: Revised Model input feature when activated to calculate Model 7Q10s (cfs) flow based on entry of Qw, MGD and CHRONIC DILITION FACTOR (from Model) and display in Model narrative box. User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry box. 1Q10s is calculated once the calculated 7Q10s (cfs) is entered in Tablel . Revised narrative in Model narrative box with new instructions, new messages to alert user on actions needed and/or completed to correctly enter Model 7Q10s (cfs) in Table 1. Remove conditions and features assocaited with entry of Model Acute IWC % . Date: 11/28/2022 Dissolved to Total Metal Calculator Do NOT enter any data directly into this spreadsheet. Enter data onto "Table 1" under the Input Sheet and enter "Effluent Hardness" under the Data Sheet. In accordance with 40 CFR 122.45 (c ), permits are, have and must be written as total metals. This calculator has been inserted into the RPA to calculate Total Metal allowable allocations once Table 1 has been completed (Input Sheet) and Effluent hardness has been entered (Data Sheet). 1) Following the spreadsheet from left to right. First the allowable allocations for the dissolved metals will appear for all the metals listed once Table 1 is complete and effluent hardness entered. Use a default value of 25 mg/L if no hardness data is available. Second, the Dissolved Metal allocations are divided by the Translators to determine the Total Metals that can be allocated to the Permittee. These Total Metals values are automatically inserted into Table 2 and are the allowable Total Metal allocations determined for the Permittee prior to allowing for dilution. See Input sheet Table 2. The final acute and chronic values shown under the RPA sheet are the Total Metal values listed in Table 2 divided by the acute and chronic IWC, respectively. 2) The Translators used in the freshwater RPA are the Partition Coefficients published by US EPA in 1984. They are TSS dependent equations and can be found listed with the WQS hardness dependent equations under the sheet labeled Equations. A fixed TSS value of 10 mg/L is used to calculate the Translator values. 3) Pretreatment Facilities - PERCS will need a copy of the Dissolved to Total Metal Calculator spreadsheet and the RPA sheet along with the Final Permit. Pretreatment Facilities are required to renew their Headwords Analysis after renewal of their permits. Since all their metal allocations are likely to change PERCS needs to see any new metal permit limits and the allowable allocations for the dissolved metals to assess Maximum Allowable Headworks Loading (MAHL) numbers for each metal based on the Combined Hardness values used in the permit writers RPA calculations. 4) For Cadmium, Lead, Nickel, Chromium and Beryllium, if all the effluent sampling data for the last three to five years shows the pollutant at concentrations less than the Practical Quantitative Level (PQL), it is not likely a limit or monitoring will be put in the permit. However, if the estimated NPDES permit limit is less than the Practical Quantitative Limit (particularly, Cadmium and Lead) and the pollutant is believed to be present, to assess compliance with the new standards and for future permit limit development, monitoring for the pollutant will be required. If the facility is monitoring for the pollutant in its Pretreatment LTMP, no monitoring is needed in the permit. 5) For monitoring and compliance purposes if Total Chromium FACILITY: H.F. Lee NPDES PERMIT: NC0003417 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) 263.0000 I 169.6774 137.5677 0.3400 10 25.000 25.000 0.2000 0.2465 I 25 I 25 Upstream Hard Avg (mg/L) = 25 EFF Hard Avg (mg/L) = 25 PARAMETER Dissolved Metals Chronic Acute Iuq/I1 f uq/I1 US EPA Maximum Allowable Effluent Concentration Translators- using (MAEC) as a Total Metal Default Partition =Dissolved Metal - Translator Coefficients (streams) Chronic fuq/Il Acute f uq/Il Cadmium (d) 0.15 0.82 0.252 0.59 3.24 Cd -Trout streams 0.15 0.51 0.252 0.59 2.01 Chromium III (d)(h) 24 183 0.202 117.73 905.08 Chromium VI (d) 16 1.000 11.00 16.00 Chromium, Total (t) N/A N/A Copper (d)(h) 2.7 3.6 0.348 7.88 10.47 Lead (d)(h) 0.54 14 0.184 2.94 75.49 Nickel (d)(h) 16 145 0.432 37.23 335.21 Ni - WS streams (t) 25 N/A Silver (d)(h,acute) Zinc (d)(h) 0.06 36 0.30 36 1.000 0.288 0.06 0.30 126.73 125.71 Beryllium 6.5 65 1.000 6.5 65 Arsenic (d) 150 340 1.000 150 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 & 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+Mg, as the default Hardness OR To determine a Hardness value for permit limit development, use the following equation: Hardness (mass balance) (Hardness instream(a), ma/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 ha (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 harc II. To Develop Dissolved Metal concentrations for permitting purposes use the Freshwater Standards for Hardness De 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 = v. 6/2/2010 1 [1 + (Kpo * TSS (1+a) * 10-6)] Kpo and a are constants that express the equilibrium relationship between dissolved and adsorbed forms of metals. A default value of 10 mg/L Total Suspended Solids (TSS) will be used. Table A contains the Default Partition Coefficients for the equation. Table B contains the calculated translators usino the default partition coefficients for streams. TABLE A. Default Partition Coefficients STREAMS Metal (1) Kpo a Cu 1.04E+06 -0.7436 Zn 1.25E+06 -0.7038 Pb 2.80E+06 -0.8 Cr (III) (2) 3.36E+06 -0.09304 Cd 4.00E+06 -1.1307 Ni 4.90E+05 -0.5719 (1) Delos, C.G., et al. Technical Guidance for Performing Waste Load Allocations. Book II: Streams and Rivers. Chapter 3: Toxic Substances, For the U.S. EPA. (EPA-440/4-84-022) (2) Linear partition coefficients shall not apply to the Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefor TABLE B. US EPA Translators 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 'iciness value for your facility Click Here. iness once/month and submit one to two years of data with the permit renewal application. If no effluent hardness data is submitted, a default of 25 mg/L will be applied. :pendent Metals listed in Table A below. Example for Cadmium (streams) Given: TSS = 10 mg/L Kpo = 4.00E + 06 CC =-1.1307 Translator = 1 [1 + (Kpo * TSS U*a> * 10-6)] 1 [1 + (4.00x106 * 101-1.'un * 10-6)] [1+2.960465] = 0.252