The URL can be used to link to this page

Home My WebLink AboutNC0038377_Worksheets_20211215 Mayo Steam Station Outfall 002 NC0038377 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 10.25 MGD MAXIMUM DATA POINTS = 58 Qw(MGD)= 10.25 WWTP/WTP Class: I COMBINED HARDNESS(mg/L) 1Q1OS(cfs)= 0.00 IWC% @ 1Q1OS = 100 Acute=25 mg/L 7Q1OS(cfs)= 0.00 IWC% @ 7Q1OS= 100 Chronic=25 mg/L 7Q1OW(cfs)= 0.00 IWC%@ 7Q1OW= 100 YOU HAVE DESIGNATED THIS RECEIVING 30Q2(cfs)= 0.00 IWC%@ 30Q2= 100 STREAM AS WATER SUPPLY Avg. Stream Flow,QA(cfs)= 0.00 IW%C @ QA= 100 Effluent Hard:0 value> 100 mg/L Receiving Stream: NO HUC NUMBER Stream Class: WS-V Effluent Hard Avg=25 mg/L PARAMETER NC STANDARDS OR EPA CRITERIA N REASONABLE POTENTIAL RESULTS RECOMMENDED ACTION TYPE _1 H CJ (1) Chronic Applied Acute ° m 11 #Det. Max Pred Cw Allowable Cw Standard Acute(FW): 340.0 add limit Arsenic C 150 FW 340 ug/L _ _ _ _ ____ _______________________________ 58 58 38,270.4 Chronic(FW)_ 150.0 1 value(s)>Allowable—10-.0— Cw_______________________________ Arsenic C 10 HH/WS ug/L Chronic(HH) 10_0 1 value(s)>Allowable Cw Acute: 65.00 no limit Beryllium NC 6.5 FW 65 ug/L 58 1 1.42 _ _ _ _ --Chronic: -----6.50 ------------------------------ No value>Allowable Cw Acute: 3.240 no limit Cadmium NC 0.5899 FW 3.2396 ug/L 58 10 0.500 _ _ _ _ --Chronic: ---- ------------------------------ 0.590 No value>Allowable Cw Acute: NO WQS add limit Chlorides NC 230 FW mg/L 58 58 370.0 _ _ _ _ --Chronic: ---- ------------------------------ 230.0 4 value(s)>Allowable Cw Acute: NO WQS Chlorinated Phenolic Compounds NC 1 A ug/L 0 0 N/A --Ch_ _ronic: -—-—-_1.0-------—-—-—-—-—-—-—-—-—-—-—-—-— Acute: NO WQS no limit Total Phenolic Compounds NC 300 A ug/L 1 1 9.8 ___ _ ____ _ _______________________________ Note: n<9 Default C.V. Chronic: 300.0 Limited data set No value>Allowable Cw Acute: 905.1 Chromium III NC 117.7325 FW 905.0818 µg/L 0 0 N/A _ _ _ _ --Chronic: -----117.7 ------------------------------ Acute: 16.0 no limit Chromium VI NC 11 FW 16 µg/L 1 1 0.1 ___ _ _______ _______________________________ Note: n<9 Default C.V. Chronic: 11.0 Limited data set No value>Allowable Cw Tot Cr value(s)<50 and<Cr VI Allowable Cw Chromium,Total NC µg/L 58 58 1 2.7 Max reported value=2.7 no limit 38377-RPA-LRB-2021, rpa Page 1 of 3 12/20/2021 Mayo Steam Station Outfall 002 NC0038377 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 10.25 MGD Acute: 10.47 no limit Copper NC 7.8806 FW 10.4720 ug/L 58 57 2.60 - _ -Chronic:_ ----- ----------------------------- 7.88 No value>Allowable Cw Acute: 22.0 no limit Cyanide NC 5 FW 22 10 ug/L 1 0 NO DETECTS ___ _ ______ ______________________________ Note: n<9 Chronic: 5.0 Limited data set Max MDL= 10 Acute: NO WQS add limit Fluoride NC 1800 FW ug/L 58 58 2,300.0 - _ _ --- _ _ -Chronic: - ----------------------------- 1,800.0 1 value(s)>Allowable Cw Acute: 75.487 no limit Lead NC 2.9416 FW 75.4871 ug/L 58 5 0.500 - _ _ ---- _ _ -Chronic: ----------------------------- 2.942 No value>Allowable Cw Acute: NO WQS evaluated separately Mercury NC 12 FW 0.5 ng/L 1 0 NO DETECTS ___ _ _______ ______________________________ Note: n<9 Chronic: 12.0 Limited data set Max MDL=50 Acute: NO WQS no limit Molybdenum NC 2000 HH ug/L 58 58 1,898.8 - _ _ --- _ _ -Chronic: - ----------------------------- 2,000.0 No value>Allowable Cw Acute(FW): 335.2 no limit Nickel NC 37.2313 FW 335.2087 µg/L _ _ _ _ ---- -----------------------------58 58 15.7 Chronic(FW): 37.2 N_o value>Allowable Cw ___________________________ Nickel NC 25.0000 WS µg/L Chronic(WS): 25.0 No value>Allowable Cw Acute: 56.0 no limit Selenium NC 5 FW 56 ug/L 58 57 0.9 _ --Chronic:_ -----5 0------------------------------ No value>Allowable Cw Acute: 0.296 no limit Silver NC 0.06 FW 0.2964 ug/L 58 0 NO DETECTS _ _ _ _ --Chronic: ---- ----------------------------- 0.060 Max MDL=0.05 Acute: 125.7 no limit Zinc NC 126.7335 FW 125.7052 ug/L 58 41 17.5 _ _ _ _ --Chronic: -----126.7 ----------------------------- No value>Allowable Cw Acute: NO WQS add limit Antimony NC 5.6 WS µg/L 58 58 38.38000 - _ _ --- _ _ -Chronic: -----------------------------5.60000 1 value(s)>Allowable Cw Acute: NO WQS add limit Thallium NC 2 HH µg/L 58 58 2.47000 - _ _ --- _ _ -Chronic: ----------------------------2.00000 1 value(s)>Allowable Cw Acute: NO WQS n„iimi+ 38377-RPA-LRB-2021, rpa Page 2 of 3 12/20/2021 Mayo Steam Station Outfall 002 NC0038377 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 10.25 MGD Sulfate NC 250 WS mg/L 2 2 1 223.61000 Note: n<9 Default C.V. Chronic: 250.00000 Limited data set No value>Allowable Cw Acute: NO WQS Barium NC 1 WS mg/L 58 58 1.28000 add limit _ _ _ _ -- ---- —---------------------------Chronic: 1.00000 1 value(s)>Allowable Cw 38377-RPA-LRB-2021, rpa Page 3 of 3 12/20/2021 Monitoring Frequencies 2B .0500 Effluent Limited pH E 2/Month 1/Week 3/Week Daily Temp, C E 1/Week 1/Week 3/Week Daily BODS I, E 2/Month 1/Week 3/Week Daily TSS I, E 2/Month 1/Week 3/Week Daily NH3-N E 1/Month 2/Month 1/Week 3/Week Fecal Col. E 2/Month 1/Week 3/Week Daily TN E See notes below. TP E See notes below. Water Quality Limited Frequency Parameter Location Class I Class II Class III Class IV D.O. E 1/Week 1/Week 3/Week Daily D.O. U, D 1/Week 1/Week 3/Week* 3/Week* pH E 2/Month 1/Week 3/Week Daily Temp, C E Daily Daily Daily Daily Temp, C U, D 1/Week 1/Week 3/Week* 3/Week* BODS I, E 2/Month 1/Week 3/Week Daily TSS I, E 2/Month 1/Week 3/Week Daily NH3-N E 1/Month 2/Month 1/Week 3/Week TRC E 2/Week 2/Week 3/Week Daily Fecal Col. E 2/Month 1/Week 3/Week Daily Fecal Col. U, D 2/Month 1/Week 3/Week* 3/Week* Conductivi E 1/Week 1/Week 3/Week Daily Conductivi U, D 1/Week 1/Week 3/Week* 3/Week* TN E See notes below. TP E See notes below. Notes: * Upstream and downstream monitoring in WQ-limited waters is to be conducted 3/Week during Jun, Jul, Aug, and Sep; and 1/Week during the rest of the year. TN, TP Monitoring All facilities >= 0.05 MGD will monitor TN and TP Those < 0.05 MGD will monitor if discharging to NSW For the Neuse, Tar-Pamlico, and any other river basins classified as NSW, use limits and monitoring requirements according to the basin's permitting strategy. For French Broad, Broad, Savannah, New Watauga, Little Tennessee, and Hiwassee: - >= 0.05 MC- monitor semi-annually - >= 1.0 MG - monitor quarterly For all other river basins: - >= 0.05 MC- monitor quarterly - >= 1.0 MG - monitor monthly Sample recommendat Msg00 < No Data Entered > NO DATA Daily max limit Msg01 MaxPredCw < Acute MONITOR? Monitor 1/month Msg02 MaxPredCw < Chronic MONITOR? Monitor 1/week Msg03 MaxPredCw « Acute REMOVE? Monitor 2/month Msg04 MaxPredCw « Chronic REMOVE? Monitoring not necess Msg05 MaxPredCw > Acute DAILY MAX LIMIT? No limit Msg06 MaxPredCw > Chronic MO AVG LIMIT? No limit - assuming no Msg07 MaxPredCw » Acute DAILY MAX LIMIT? No limit (Action Level Msg08 MaxPredCw » Chronic MO AVG LIMIT? Continue to monitor at Msg09 No acute standard or 1/2 FAV N/A Mo. avg. limit (keep wl Msg10 No chronic standard or criterion N/A Revise daily max. limi Per Memo Dated 7-15-2010 RPA Condition Permit Monitoring Frequency _1_RPA Exists Monitor Monthly and add Permit Limit 2.RPA Exists but Action Levels (Cu,Zn,Ag,Fe,Cl) Monitor Quarterly in conjunction with 1 3a.RPA Exists but Dataset Limited (n<8 samples) Monitor Quarterly 3b. RPA exists, dataset limited,but 2 values > Monitor Monthly and add Permit Limit allowable Cw 4.No RPA(Predicted Max>50%of Allowable) Monitor Quarterly (or defer to Pretreat I 5.No RPA(Predicted Max<50%Allowable) No Monitoring 6a.No Data(New Permit, New Waste Stream) Monitor Monthly for Toxic Pollutants o 6b.New Greensand or Conventional\VTP Monitor Quarterly for Toxic Pollutants password all sheets = rpa2016a 4/28/16: Note Action Level designation no longer allowed per EPA. ions: ary in permit tox (Action Level parameter) parameter) 2/month k. avg. if existing) t "ox Test '..TMP) f Concern of Concern Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators MAXIMUM DATA POINTS = 58 REQUIRED DATA ENTRY CHECK WQS Table 1. Project Information Table 2. Parameters of Concern ['CHECK IF HQW OR ORW WQS Name WQS Type Chronic Modifier Acute PQL Units Facility Name Mayo Steam Station Par01 Arsenic Aquactic Life C 150 FW 340 ug/L WWTP/WTP Class I Par02 Arsenic Human Health C 10 HH/WS N/A ug/L Water Supply NPDES Permit NC0038377 Par03 Beryllium Aquatic Life NC 6.5 FW 65 ug/L Outfall 002 Par04 Cadmium Aquatic Life NC 0.5899 FW 3.2396 ug/L Flow, Qw(MGD) 10.250 Par05 Chlorides Aquatic Life NC 230 FW mg/L Receiving Stream Mayo Lake Par06y Chlorinated Phenolic Compounds Water Supply NC 1 A ug/L HUC Number Par07 y Total Phenolic Compounds Aquatic Life NC 300 A ug/L Stream Class Par08 Chromium III Aquatic Life NC 117.7325 FW 905.0818 ug/L WS-V ❑Apply WS Hardness WQC Par09 Chromium VI Aquatic Life NC 11 FW 16 pg/L 7Q10s (cfs) 0.00 Patio Chromium, Total Aquatic Life NC N/A FW N/A pg/L 7Q1Ow(cfs) 0.00 1 IParli Copper Aquatic Life NC 7.8806 FW 10.4720 ug/L 30Q2 (cfs) 0.00 Par12 Cyanide Aquatic Life NC 5 FW 22 10 ug/L QA(cfs) 0.00 Par13 Fluoride Aquatic Life NC 1,800 FW ug/L 1 Q10s (cfs) 0.00 Par14 Lead Aquatic Life NC 2.9416 FW 75.4871 ug/L Effluent Hardness 25 mg/L (Avg) Par15 Mercury Aquatic Life NC 12 FW 0.5 ng/L Upstream Hardness 25 mg/L (Avg) Par16 Molybdenum Human Health NC 2000 HH ug/L Combined Hardness Chronic 25 mg/L Par17 Nickel Aquatic Life NC 37.2313 FW 335.2087 pg/L Combined Hardness Acute 25 mg/L I Par18 Nickel Water Supply NC 25.0000 WS N/A pg/L Data Source(s) DMRs Par19 Selenium Aquatic Life NC 5 FW 56 ug/L ['CHECK TO APPLY MODEL Par20 Silver Aquatic Life NC 0.06 FW 0.2964 ug/L Par21 Zinc Aquatic Life NC 126.7335 FW 125.7052 ug/L Par22 Antimony Water Supply NC 5.6 WS pg/L Par23 Thallium Human Health NC 2 HH pg/L Par24 Sulfate Water Supply NC 250 WS mg/L NC0038377_Worksheets_20211215, input 12/20/2021 REASONABLE POTENTIAL ANALYSIS H1 H2 Use"PASTE SPECIAL. Use"PASTE SPECIAL. Values"then"COPY" Values"then"COPY" Effluent Hardness .Maximum data Upstream Hardness .Maximum data points=58 points=58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 25 25 Std Dev. N/A 1 25 25 Std Dev. N/A 2 Mean 25.0000 2 Mean 25.0000 3 C.V. 0.0000 3 C.V. 0.0000 4 n 1 4 n 1 5 10th Per value 25.00 mg/L 5 10th Per value 25.00 mg/L 6 Average Value 25.00 mg/L 6 Average Value 25.00 mg/L 7 Max.Value 25.00 mg/L 7 Max.Value 25.00 mg/L 8 8 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 22 23 23 24 24 25 25 26 26 27 27 28 28 29 29 30 30 31 31 32 32 33 33 34 34 35 35 36 36 37 37 38 38 39 39 40 40 41 41 42 42 43 43 44 44 45 45 46 46 47 47 48 48 49 49 50 50 51 51 52 52 53 53 54 54 55 55 56 56 57 57 58 58 NC0038377_Worksheets_20211215,data -2- 12/20/2021 REASONABLE POTENTIAL ANALYSIS Par01 &Par02 Use"PASTE SPECIAL. Arsenic Values"then"COPY" .Maximum data points=58 Date Data BDL=1/2DL Results 1 3.9 3.9 Std Dev. 133.5275 2 3.6 3.6 Mean 20.6569 3 3.7 3.7 C.V. 6.4641 4 3.4 3.4 n 58 5 3.1 3.1 6 3 3 Mult Factor= 37.52 7 2.9 2.9 Max.Value 1020.0 ug/L 8 2.4 2.4 Max. Pred Cw 38270.4 ug/L 9 2.8 2.8 10 2.3 2.3 11 2.9 2.9 12 2.2 2.2 13 2.3 2.3 14 2.3 2.3 15 2.5 2.5 16 2.8 2.8 17 2.8 2.8 18 2.7 2.7 19 2.4 2.4 20 2.5 2.5 21 2.4 2.4 22 3.1 3.1 23 5.7 5.7 24 3.1 3.1 25 3 3 26 3 3 27 2.9 2.9 28 3.3 3.3 29 3 3 30 2.7 2.7 31 2.6 2.6 32 2.7 2.7 33 2.5 2.5 34 2.3 2.3 35 3.6 3.6 36 2.6 2.6 37 2.4 2.4 38 0.7 0.7 39 1.7 1.7 40 1020 1020 41 1.7 1.7 42 4.8 4.8 43 1.8 1.8 44 2.3 2.3 45 2.7 2.7 46 2.6 2.6 47 2.6 2.6 48 2.9 2.9 49 3 3 50 5.1 5.1 51 3 3 52 3 3 53 3.2 3.2 54 7.2 7.2 55 6.4 6.4 56 6.1 6.1 57 4.9 4.9 58 5 5 NC0038377_Worksheets_20211215,data -3- 12/20/2021 REASONABLE POTENTIAL ANALYSIS Par03 Use"PASTE SPECIAL.Par04 Use"PASTE SPECIAL. Values"then"COPY" Values"then"COPY" Beryllium .Maximum data Cadmium .Maximum data points=58 points=58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 < 0.1 0.05 Std Dev. 0.1799 1 < 0.05 0.025 Std Dev. 0.0640 2 < 0.1 0.05 Mean 0.0736 2 < 0.05 0.025 Mean 0.0410 3 < 0.1 0.05 C.V. 2.4435 3 < 0.05 0.025 C.V. 1.5597 4 < 0.1 0.05 n 58 4 < 0.05 0.025 n 58 5 < 0.1 0.05 5 < 0.05 0.025 6 < 0.1 0.05 Mult Factor= 1.00 6 < 0.05 0.025 Mult Factor= 1.00 7 < 0.1 0.05 Max.Value 1.42 ug/L 7 < 0.05 0.025 Max.Value 0.500 ug/L 8 < 0.1 0.05 Max. Pred Cw 1.42 ug/L 8 < 0.05 0.025 Max. Pred Cw 0.500 ug/L 9 < 0.1 0.05 9 < 0.05 0.025 10 < 0.1 0.05 10 < 0.05 0.025 11 < 0.1 0.05 11 < 0.05 0.025 12 < 0.1 0.05 12 < 0.05 0.025 13 < 0.1 0.05 13 < 0.05 0.025 14 < 0.1 0.05 14 < 0.05 0.025 15 < 0.1 0.05 15 < 0.05 0.025 16 < 0.1 0.05 16 < 0.05 0.025 17 < 0.1 0.05 17 < 0.05 0.025 18 < 0.1 0.05 18 < 0.05 0.025 19 < 0.1 0.05 19 < 0.05 0.025 20 < 0.1 0.05 20 < 0.05 0.025 21 < 0.1 0.05 21 < 0.05 0.025 22 < 0.1 0.05 22 < 0.05 0.025 23 < 0.1 0.05 23 < 0.05 0.025 24 < 0.1 0.05 24 < 0.05 0.025 25 < 0.1 0.05 25 < 0.05 0.025 26 < 0.1 0.05 26 < 0.05 0.025 27 < 0.1 0.05 27 < 0.05 0.025 28 < 0.1 0.05 28 < 0.05 0.025 29 < 0.1 0.05 29 < 0.05 0.025 30 < 0.1 0.05 30 < 0.05 0.025 31 < 0.1 0.05 31 < 0.05 0.025 32 < 0.1 0.05 32 < 0.05 0.025 33 < 0.1 0.05 33 < 0.05 0.025 34 < 0.1 0.05 34 < 0.05 0.025 35 < 0.1 0.05 35 < 0.05 0.025 36 < 0.1 0.05 36 < 0.05 0.025 37 < 0.1 0.05 37 < 0.05 0.025 38 < 0.1 0.05 38 < 0.05 0.025 39 < 0.1 0.05 39 0.075 0.075 40 < 0.1 0.05 40 < 0.05 0.025 41 < 0.1 0.05 41 < 0.05 0.025 42 < 0.1 0.05 42 < 0.05 0.025 43 < 0.1 0.05 43 0.073 0.073 44 < 0.1 0.05 44 0.051 0.051 45 < 0.1 0.05 45 < 0.05 0.025 46 < 0.1 0.05 46 0.055 0.055 47 < 0.1 0.05 47 0.078 0.078 48 < 0.1 0.05 48 0.07 0.07 49 < 0.1 0.05 49 0.061 0.061 50 < 0.1 0.05 50 0.099 0.099 51 < 0.1 0.05 51 0.058 0.058 52 < 0.1 0.05 52 < 0.05 0.025 53 < 0.1 0.05 53 < 0.05 0.025 54 < 0.1 0.05 54 < 0.05 0.025 55 < 0.1 0.05 55 < 0.05 0.025 56 < 0.1 0.05 56 < 0.05 0.025 57 < 0.1 0.05 57 0.084 0.084 58 1.42 1.42 58 < 1 0.5 NC0038377_Worksheets_20211215,data -4- 12/20/2021 REASONABLE POTENTIAL ANALYSIS Par05 Par06 Use"PASTE SPECIAL- Use"PASTE SF Chlorides Values"then"COPY". Chlorinated Phenolic Compounds Values" then' Maximum data points= .Maximum c 58 points=5 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 263 263 Std Dev. 65.5499 1 Std Dev. NO DATA 2 236 236 Mean 107.3 2 Mean NO DATA 3 103 103 C.V. 0.6107 3 C.V. NO DATA 4 219 219 n 58 4 n 0 5 186 186 5 6 230 230 Mult Factor= 1.0 6 Mult Factor= N/A 7 226 226 Max.Value 370.0 mg/L 7 Max.Value N/A 8 370 370 Max. Pred Cw 370.0 mg/L 8 Max. Pred Cw N/A 9 187 187 9 10 240 240 10 11 187 187 11 12 89 89 12 13 91.1 91.1 13 14 89.7 89.7 14 15 73.2 73.2 15 16 38.4 38.4 16 17 80.6 80.6 17 18 216 216 18 19 95.3 95.3 19 20 79.6 79.6 20 21 77.8 77.8 21 22 89.9 89.9 22 23 60.6 60.6 23 24 83.6 83.6 24 25 81.9 81.9 25 26 80.6 80.6 26 27 77.6 77.6 27 28 78.1 78.1 28 29 71.4 71.4 29 30 84.7 84.7 30 31 80.2 80.2 31 32 80.4 80.4 32 33 87.7 87.7 33 34 84.1 84.1 34 35 85 85 35 36 87 87 36 37 79.1 79.1 37 38 77.6 77.6 38 39 69.3 69.3 39 40 67.5 67.5 40 41 71.1 71.1 41 42 79 79 42 43 78.3 78.3 43 44 73.4 73.4 44 45 74.4 74.4 45 46 74.9 74.9 46 47 71.7 71.7 47 48 76 76 48 49 84.5 84.5 49 50 58.3 58.3 50 51 80.5 80.5 51 52 78 78 52 53 76.5 76.5 53 54 75.5 75.5 54 55 75.1 75.1 55 56 76.1 76.1 56 57 67.9 67.9 57 58 70 70 58 NC0038377_Worksheets_20211215,data -5- 12/20/2021 REASONABLE POTENTIAL ANALYSIS ,ECIAL•Par07 Use"PASTE SPECIAL.Par08 Use"PASTE SF COPY" Values"then"COPY" Values"then"I lata Total Phenolic Compounds .Maximum data Chromium Ill .Maximum c ;8 points=58 points=5 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 9.8 9.8 Std Dev. N/A 1 Std Dev. NO DATA 2 Mean 9.8000 2 Mean NO DATA 3 C.V. 0.0000 3 C.V. NO DATA 4 n 1 4 n 0 5 5 6 Mult Factor= 1.00 6 Mult Factor= N/A ug/L 7 Max.Value 9.8 ug/L 7 Max.Value N/A ug/L 8 Max. Pred Cw 9.8 ug/L 8 Max. Pred Cw N/A 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 22 23 23 24 24 25 25 26 26 27 27 28 28 29 29 30 30 31 31 32 32 33 33 34 34 35 35 36 36 37 37 38 38 39 39 40 40 41 41 42 42 43 43 44 44 45 45 46 46 47 47 48 48 49 49 50 50 51 51 52 52 53 53 54 54 55 55 56 56 57 57 58 58 NC0038377_Worksheets_20211215,data -6- 12/20/2021 REASONABLE POTENTIAL ANALYSIS ,ECIAL•Par09 Use"PASTE SPECIAL.Par1 Use"PASTE SF COPY" Values"then"COPY" Values"then"I iata Chromium VI .Maximum data Chromium, Total .Maximum c ;8 points=58 points=5 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 0.1 0.1 Std Dev. N/A 1 0.33 0.33 Std Dev. 0.5162 2 Mean 0.1000 2 0.49 0.49 Mean 0.6628 3 C.V. 0.0000 3 0.4 0.4 C.V. 0.7789 4 n 1 4 0.36 0.36 n 58 5 5 0.34 0.34 6 Mult Factor= 1.00 6 0.42 0.42 Mult Factor= 1.00 pg/L 7 Max.Value 0.1 pg/L 7 0.4 0.4 Max.Value 2.7 pg/L 8 Max. Pred Cw 0.1 pg/L 8 0.33 0.33 Max. Pred Cw 2.7 9 9 0.3 0.3 10 10 0.25 0.25 11 11 0.38 0.38 12 12 0.2 0.2 13 13 0.49 0.49 14 14 0.28 0.28 15 15 0.29 0.29 16 16 0.34 0.34 17 17 2.7 2.7 18 18 2.2 2.2 19 19 1.5 1.5 20 20 1.3 1.3 21 21 1.1 1.1 22 22 1.3 1.3 23 23 1.4 1.4 24 24 1.2 1.2 25 25 1.2 1.2 26 26 1.4 1.4 27 27 1.1 1.1 28 28 1.2 1.2 29 29 0.83 0.83 30 30 0.12 0.12 31 31 0.69 0.69 32 32 0.64 0.64 33 33 0.51 0.51 34 34 0.59 0.59 35 35 0.27 0.27 36 36 0.85 0.85 37 37 0.24 0.24 38 38 0.52 0.52 39 39 0.1 0.1 40 40 0.37 0.37 41 41 0.22 0.22 42 42 0.38 0.38 43 43 0.4 0.4 44 44 0.13 0.13 45 45 0.32 0.32 46 46 0.23 0.23 47 47 1.1 1.1 48 48 0.28 0.28 49 49 0.6 0.6 50 50 0.38 0.38 51 51 0.38 0.38 52 52 0.94 0.94 53 53 0.46 0.46 54 54 0.67 0.67 55 55 0.5 0.5 56 56 0.46 0.46 57 57 0.77 0.77 58 58 1.29 1.29 NC0038377_Worksheets_20211215,data -7- 12/20/2021 REASONABLE POTENTIAL ANALYSIS ,ECIAL•Pal 1 Use"PASTE SPECIAL.Par12 Use"PASTE SF COPY" CO er Values"then"COPY" Cyanide Values"then"I iata pp .Maximum data y .Maximum c ;8 points=58 points=5 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 1.6 1.6 Std Dev. 0.3522 1 < 10 5 Std Dev. N/A 2 1.6 1.6 Mean 1.6152 2 Mean 5.00 3 1.6 1.6 C.V. 0.2180 3 C.V. 0.0000 4 1.7 1.7 n 58 4 n 1 5 2.6 2.6 5 6 1.7 1.7 Mult Factor= 1.00 6 Mult Factor= 1.00 pg/L 7 1.6 1.6 Max.Value 2.60 ug/L 7 Max.Value 5.0 pg/L 8 1.5 1.5 Max. Pred Cw 2.60 ug/L 8 Max. Pred Cw 0 DETECTS 9 1.6 1.6 9 10 2 2 10 11 1.8 1.8 11 12 1.8 1.8 12 13 1.7 1.7 13 14 1.6 1.6 14 15 1.8 1.8 15 16 1.7 1.7 16 17 1.6 1.6 17 18 1.6 1.6 18 19 1.7 1.7 19 20 1.3 1.3 20 21 1.5 1.5 21 22 1.3 1.3 22 23 0.78 0.78 23 24 1.3 1.3 24 25 1.3 1.3 25 26 1.4 1.4 26 27 1.3 1.3 27 28 1.4 1.4 28 29 1.3 1.3 29 30 1.3 1.3 30 31 1.2 1.2 31 32 1.6 1.6 32 33 1.3 1.3 33 34 1.2 1.2 34 35 1.3 1.3 35 36 1.3 1.3 36 37 1.6 1.6 37 38 1.7 1.7 38 39 2.1 2.1 39 40 1.5 1.5 40 41 1.5 1.5 41 42 1.4 1.4 42 43 1.5 1.5 43 44 1.8 1.8 44 45 2.1 2.1 45 46 2 2 46 47 2.2 2.2 47 48 1.8 1.8 48 49 1.8 1.8 49 50 1.8 1.8 50 51 1.7 1.7 51 52 2 2 52 53 < 1 0.5 53 54 1.8 1.8 54 55 1.7 1.7 55 56 1.7 1.7 56 57 2.1 2.1 57 58 2.5 2.5 58 NC0038377_Worksheets_20211215,data -8- 12/20/2021 REASONABLE POTENTIAL ANALYSIS ,ECIAL•Par13 Use"PASTE SPECIAL.Par14 Use"PASTE SF COPY" Values"then"COPY" Values"then"I iata Fluoride .Maximum data Lead .Maximum c ;8 points=58 points=5 Date Data BDL=1/2DL Results Date BDL=1/2DL Results 1 520 520 Std Dev. 292.1063 1 < 0.5 0.25 Std Dev. 0.0837 2 500 500 Mean 456.0345 2 < 0.5 0.25 Mean 0.2178 3 500 500 C.V. 0.6405 3 < 0.5 0.25 C.V. 0.3845 4 2300 2300 n 58 4 < 0.5 0.25 n 58 5 650 650 5 < 0.5 0.25 6 630 630 Mult Factor= 1.00 6 < 0.5 0.25 Mult Factor= 1.00 ug/L 7 560 560 Max.Value 2300.0 ug/L 7 < 0.5 0.25 Max.Value 0.500 ug/L 8 580 580 Max. Pred Cw 2300.0 ug/L 8 < 0.5 0.25 Max. Pred Cw 0.500 9 600 600 9 < 0.5 0.25 10 680 680 10 < 0.5 0.25 11 650 650 11 < 0.5 0.25 12 340 340 12 < 0.5 0.25 13 340 340 13 < 0.5 0.25 14 360 360 14 < 0.5 0.25 15 500 500 15 < 0.5 0.25 16 1300 1300 16 < 0.5 0.25 17 300 300 17 < 0.5 0.25 18 490 490 18 < 0.5 0.25 19 250 250 19 < 0.5 0.25 20 360 360 20 < 0.5 0.25 21 370 370 21 < 0.5 0.25 22 340 340 22 < 0.5 0.25 23 380 380 23 < 0.5 0.25 24 380 380 24 < 0.5 0.25 25 380 380 25 < 0.5 0.25 26 370 370 26 < 0.5 0.25 27 340 340 27 < 0.5 0.25 28 330 330 28 < 0.5 0.25 29 380 380 29 < 0.5 0.25 30 380 380 30 < 0.5 0.25 31 350 350 31 < 0.5 0.25 32 360 360 32 < 0.5 0.25 33 400 400 33 < 0.5 0.25 34 400 400 34 < 0.5 0.25 35 390 390 35 < 0.5 0.25 36 400 400 36 < 0.5 0.25 37 260 260 37 < 0.5 0.25 38 410 410 38 < 0.5 0.25 39 370 370 39 < 0.5 0.25 40 370 370 40 < 0.5 0.25 41 380 380 41 < 0.5 0.25 42 280 280 42 < 0.5 0.25 43 370 370 43 < 0.5 0.25 44 420 420 44 < 0.5 0.25 45 630 630 45 < 0.5 0.25 46 410 410 46 < 0.09 0.045 47 350 350 47 0.2 0.2 48 350 350 48 < 0.09 0.045 49 250 250 49 0.093 0.093 50 380 380 50 0.09 0.09 51 390 390 51 < 0.09 0.045 52 440 440 52 < 0.09 0.045 53 400 400 53 0.091 0.091 54 340 340 54 0.091 0.091 55 250 250 55 < 0.09 0.045 56 320 320 56 < 0.09 0.045 57 360 360 57 < 0.09 0.045 58 360 360 58 < 1 0.5 NC0038377_Worksheets_20211215,data -9- 12/20/2021 REASONABLE POTENTIAL ANALYSIS ,ECIAL•Par15 Use"PASTE SPECIAL.Par16 Use"PASTE SF COPY" Values"then"COPY" Values"then"I iata Mercury .Maximum data Molybdenum .Maximum c ;8 points=58 points=5 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 < 50 25 Std Dev. N/A 1 17.6 17.6 Std Dev. 244.8838 2 Mean 25.0000 2 22.8 22.8 Mean 47.3172 3 C.V. 0.0000 3 19.4 19.4 C.V. 5.1754 4 n 1 4 17.9 17.9 n 58 5 5 6.6 6.6 6 Mult Factor= 1.00 6 16.9 16.9 Mult Factor= 1.01 ug/L 7 Max.Value 25.0 ng/L 7 16.6 16.6 Max.Value 1880.0 ug/L 8 Max. Pred Cw 0 DETECTS ng/L 8 16 16 Max. Pred Cw 1898.8 9 9 15.4 15.4 10 10 16 16 11 11 18 18 12 12 16.8 16.8 13 13 16.3 16.3 14 14 15.7 15.7 15 15 14.4 14.4 16 16 12.8 12.8 17 17 18.2 18.2 18 18 12.8 12.8 19 19 11.6 11.6 20 20 12.8 12.8 21 21 19.1 19.1 22 22 18.2 18.2 23 23 17.2 17.2 24 24 15.8 15.8 25 25 16.6 16.6 26 26 16.8 16.8 27 27 17.2 17.2 28 28 17.5 17.5 29 29 17 17 30 30 18.7 18.7 31 31 18.1 18.1 32 32 17.5 17.5 33 33 15.1 15.1 34 34 1.8 1.8 35 35 14.6 14.6 36 36 14.5 14.5 37 37 15.3 15.3 38 38 15 15 39 39 13.9 13.9 40 40 13.5 13.5 41 41 14 14 42 42 13.8 13.8 43 43 15.1 15.1 44 44 14.6 14.6 45 45 13.7 13.7 46 46 15.1 15.1 47 47 13.6 13.6 48 48 13.5 13.5 49 49 12.9 12.9 50 50 12.3 12.3 51 51 11.2 11.2 52 52 12.8 12.8 53 53 13.4 13.4 54 54 14.4 14.4 55 55 15.8 15.8 56 56 14.4 14.4 57 57 15.8 15.8 58 58 1880 1880 NC0038377_Worksheets_20211215,data - 10- 12/20/2021 REASONABLE POTENTIAL ANALYSIS Par17&Par18 Par19 �ECIAL• Use"PASTE SPECIAL. COPY" Nickel Values"then"COPY" Selenium iata .Maximum data ;8 points=58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 0.98 0.98 Std Dev. 1.9564 1 0.67 0.66980024 Std Dev. 2 1 1 Mean 1.5138 2 0.682 0.68155112 Mean 3 0.9 0.9 C.V. 1.2924 3 0.705 0.70505288 C.V. 4 0.82 0.82 n 58 4 0.74 0.74030552 n 5 0.91 0.91 5 0.893 0.89306698 6 0.84 0.84 Mult Factor= 1.00 6 0.635 0.63454759 Mult Factor= ug/L 7 0.74 0.74 Max.Value 15.7 fag/L 7 0.588 0.58754407 Max.Value ug/L 8 0.67 0.67 Max. Pred Cw 15.7 fag/L 8 0.294 0.29377203 Max. Pred Cw 9 0.76 0.76 9 0.564 0.5640423 10 0.65 0.65 10 0.482 0.48178613 11 0.87 0.87 11 0.764 0.76380729 12 0.86 0.86 12 0.517 0.51703878 13 0.83 0.83 13 0.623 0.62279671 14 0.96 0.96 14 0.635 0.63454759 15 0.99 0.99 15 0.787 0.78730905 16 1.2 1.2 16 0.764 0.76380729 17 1.2 1.2 17 0.74 0.74030552 18 1.4 1.4 18 0.635 0.63454759 19 1.1 1.1 19 0.494 0.49353702 20 1.3 1.3 20 0.564 0.5640423 21 1.4 1.4 21 0.411 0.41128085 22 1.6 1.6 22 0.411 0.41128085 23 0.92 0.92 23 0.458 0.45828437 24 1.6 1.6 24 0.458 0.45828437 25 1.4 1.4 25 0.376 0.3760282 26 1.5 1.5 26 0.494 0.49353702 27 1.8 1.8 27 0.482 0.48178613 28 1.5 1.5 28 0.717 0.71680376 29 1.5 1.5 29 0.646 0.64629847 30 1.5 1.5 30 0.353 0.35252644 31 1.3 1.3 31 0.529 0.52878966 32 1.4 1.4 32 0.599 0.59929495 33 1.5 1.5 33 0.646 0.64629847 34 1.3 1.3 34 0.552 0.55229142 35 3.7 3.7 35 0.423 0.42303173 36 1.6 1.6 36 0.494 0.49353702 37 1.5 1.5 37 0.329 0.32902468 38 0.7 0.7 38 0.294 0.29377203 39 1.9 1.9 39 0.517 0.51703878 40 1.9 1.9 40 0.564 0.5640423 41 1.8 1.8 41 0.435 0.43478261 42 0.66 0.66 42 0.505 0.5052879 43 1.7 1.7 43 0.223 0.22326675 44 1.8 1.8 44 0.223 0.22326675 45 1.6 1.6 45 0.27 0.27027027 46 1.5 1.5 46 0.223 0.22326675 47 1.2 1.2 47 0.294 0.29377203 48 1.1 1.1 48 0.341 0.34077556 49 0.96 0.96 49 0.47 0.47003525 50 0.59 0.59 50 0.306 0.30552291 51 0.92 0.92 51 0.235 0.23501763 52 0.77 0.77 52 0.141 0.14101058 53 1.4 1.4 53 0.27 0.27027027 54 1.4 1.4 54 0.188 0.1880141 55 1.6 1.6 55 0.118 0.11750881 56 1.4 1.4 56 0.27 0.27027027 57 1.2 1.2 57 0.223 0.22326675 58 15.7 15.7 58 < 1 0.5 NC0038377_Worksheets_20211215,data - 11 - 12/20/2021 REASONABLE POTENTIAL ANALYSIS Use"PASTE SPECIAL.Par20 Use"PASTE SPECIAL.Par21 Values"then"COPY" Values"then"COPY" .Maximum data Silver .Maximum data Zinc points=58 points=58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 0.1853 1 < 0.05 0.025 Std Dev. 0.0000 1 10.4 10.4 Std Dev. 0.4787 2 < 0.05 0.025 Mean 0.0250 2 7.4 7.4 Mean 0.3872 3 < 0.05 0.025 C.V. 0.0000 3 5.5 5.5 C.V. 58 4 < 0.05 0.025 n 58 4 4.4 4.4 n 5 < 0.05 0.025 5 2.5 2.5 1.00 6 < 0.05 0.025 Mult Factor= 1.00 6 3.5 3.5 Mult Factor= 0.9 ug/L 7 < 0.05 0.025 Max.Value 0.025 ug/L 7 3 3 Max.Value 0.9 ug/L 8 < 0.05 0.025 Max. Pred Cw 0 DETECTS ug/L 8 14.2 14.2 Max. Pred Cw 9 < 0.05 0.025 9 < 2.5 1.25 10 < 0.05 0.025 10 < 2.5 1.25 11 < 0.05 0.025 11 3.3 3.3 12 < 0.05 0.025 12 < 2.5 1.25 13 < 0.05 0.025 13 < 2.5 1.25 14 < 0.05 0.025 14 < 2.5 1.25 15 < 0.05 0.025 15 < 2.5 1.25 16 < 0.05 0.025 16 < 2.5 1.25 17 < 0.05 0.025 17 < 2.5 1.25 18 < 0.05 0.025 18 < 2.5 1.25 19 < 0.05 0.025 19 < 2.5 1.25 20 < 0.05 0.025 20 < 2.5 1.25 21 < 0.05 0.025 21 < 2.5 1.25 22 < 0.05 0.025 22 < 2.5 1.25 23 < 0.05 0.025 23 < 2.5 1.25 24 < 0.05 0.025 24 < 2.5 1.25 25 < 0.05 0.025 25 < 2.5 1.25 26 < 0.05 0.025 26 2.7 2.7 27 < 0.05 0.025 27 3.5 3.5 28 < 0.05 0.025 28 12.3 12.3 29 < 0.05 0.025 29 6 6 30 < 0.05 0.025 30 5.7 5.7 31 < 0.05 0.025 31 4.5 4.5 32 < 0.05 0.025 32 3.2 3.2 33 < 0.05 0.025 33 4.1 4.1 34 < 0.05 0.025 34 6.9 6.9 35 < 0.05 0.025 35 4.9 4.9 36 < 0.05 0.025 36 3.9 3.9 37 < 0.05 0.025 37 4.6 4.6 38 < 0.05 0.025 38 4.3 4.3 39 < 0.05 0.025 39 8.3 8.3 40 < 0.05 0.025 40 15.1 15.1 41 < 0.05 0.025 41 17.5 17.5 42 < 0.05 0.025 42 10.5 10.5 43 < 0.05 0.025 43 12 12 44 < 0.05 0.025 44 9.8 9.8 45 < 0.05 0.025 45 10 10 46 < 0.05 0.025 46 10.8 10.8 47 < 0.05 0.025 47 12 12 48 < 0.05 0.025 48 12.1 12.1 49 < 0.05 0.025 49 14.8 14.8 50 < 0.05 0.025 50 12.1 12.1 51 < 0.05 0.025 51 9.8 9.8 52 < 0.05 0.025 52 7.6 7.6 53 < 0.05 0.025 53 6.7 6.7 54 < 0.05 0.025 54 14.1 14.1 55 < 0.05 0.025 55 4 4 56 < 0.05 0.025 56 6.7 6.7 57 < 0.05 0.025 57 4.8 4.8 58 < 0.05 0.025 58 < 5 2.5 NC0038377_Worksheets_20211215,data - 12- 12/20/2021 REASONABLE POTENTIAL ANALYSIS Use"PASTE SPECIAL.Par22 Use"PASTE SPECIAL.Par23 Values"then"COPY" Values"then"COPY" .Maximum data Antimony .Maximum data Thallium points=58 points=58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL 4.5647 1 0.56 0.56 Std Dev. 4.9249 1 0.094007 0.09400705 5.8966 2 0.34 0.34 Mean 1.1540 2 0.105758 0.10575793 0.7741 3 0.32 0.32 C.V. 4.2678 3 0.094007 0.09400705 58 4 0.51 0.51 n 58 4 0.094007 0.09400705 5 0.58 0.58 5 0.094007 0.09400705 1.00 6 0.49 0.49 Mult Factor= 1.01 6 0.094007 0.09400705 17.5 ug/L 7 0.75 0.75 Max.Value 38.000000 fag/L 7 0.117509 0.11750881 17.5 ug/L 8 0.39 0.39 Max. Pred Cw 38.380000 fag/L 8 0.094007 0.09400705 9 0.53 0.53 9 0.094007 0.09400705 10 0.39 0.39 10 0.082256 0.08225617 11 0.4 0.4 11 0.105758 0.10575793 12 0.76 0.76 12 0.082256 0.08225617 13 0.73 0.73 13 0.023502 0.02350176 14 0.75 0.75 14 0.023502 0.02350176 15 0.48 0.48 15 0.023502 0.02350176 16 0.58 0.58 16 0.047004 0.04700353 17 0.66 0.66 17 0.023502 0.02350176 18 0.77 0.77 18 0.094007 0.09400705 19 0.78 0.78 19 0.082256 0.08225617 20 0.68 0.68 20 0.070505 0.07050529 21 0.74 0.74 21 0.082256 0.08225617 22 0.68 0.68 22 0.094007 0.09400705 23 0.53 0.53 23 0.199765 0.19976498 24 0.54 0.54 24 0.035253 0.03525264 25 0.11 0.11 25 0.058754 0.05875441 26 0.59 0.59 26 0.035253 0.03525264 27 0.46 0.46 27 0.070505 0.07050529 28 0.47 0.47 28 0.105758 0.10575793 29 0.45 0.45 29 0.070505 0.07050529 30 0.45 0.45 30 0.082256 0.08225617 31 0.4 0.4 31 0.105758 0.10575793 32 0.46 0.46 32 0.070505 0.07050529 33 0.42 0.42 33 0.39953 0.39952996 34 0.55 0.55 34 0.094007 0.09400705 35 0.49 0.49 35 0.047004 0.04700353 36 0.45 0.45 36 0.094007 0.09400705 37 0.44 0.44 37 0.105758 0.10575793 38 0.55 0.55 38 0.105758 0.10575793 39 0.48 0.48 39 0.082256 0.08225617 40 0.46 0.46 40 0.082256 0.08225617 41 0.4 0.4 41 0.094007 0.09400705 42 0.77 0.77 42 0.188014 0.1880141 43 0.7 0.7 43 0.105758 0.10575793 44 0.54 0.54 44 0.105758 0.10575793 45 0.41 0.41 45 0.082256 0.08225617 46 0.41 0.41 46 0.094007 0.09400705 47 0.38 0.38 47 0.117509 0.11750881 48 0.42 0.42 48 0.082256 0.08225617 49 0.43 0.43 49 0.070505 0.07050529 50 0.43 0.43 50 0.12926 0.12925969 51 0.43 0.43 51 0.094007 0.09400705 52 0.44 0.44 52 0.047004 0.04700353 53 0.41 0.41 53 0.094007 0.09400705 54 0.44 0.44 54 0.188014 0.1880141 55 0.39 0.39 55 0.176263 0.17626322 56 0.4 0.4 56 0.176263 0.17626322 57 0.36 0.36 57 0.188014 0.1880141 58 38 38 58 2.47 2.47 NC0038377_Worksheets_20211215,data - 13- 12/20/2021 REASONABLE POTENTIAL ANALYSIS Use"PASTE SPECIAL.Par24 Use"PASTE SPECIAL.Par25 Values"then"COPY" Values"then"COPY" .Maximum data Sulfate .Maximum data Barium points=58 points=58 Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Std Dev. 0.3166 1 59 59 Std Dev. 1.4142 1 0.085 0.085 Mean 0.1390 2 57 57 Mean 58.0000 2 0.088 0.088 C.V. 2.2775 3 C.V. (default) 0.6000 3 0.08 0.08 n 58 4 n 2 4 0.084 0.084 5 5 0.082 0.082 Mult Factor= 1.00 6 Mult Factor= 3.79 6 0.078 0.078 Max.Value 2.470000 fag/L 7 Max.Value 59.000000 mg/L 7 0.077 0.077 Max. Pred Cw 2.470000 fag/L 8 Max. Pred Cw 223.610000 mg/L 8 0.07 0.07 9 9 0.076 0.076 10 10 0.071 0.071 11 11 0.073 0.073 12 12 0.067 0.067 13 13 0.068 0.068 14 14 0.069 0.069 15 15 0.075 0.075 16 16 0.072 0.072 17 17 0.077 0.077 18 18 0.076 0.076 19 19 0.066 0.066 20 20 0.07 0.07 21 21 0.066 0.066 22 22 0.073 0.073 23 23 0.074 0.074 24 24 0.074 0.074 25 25 0.071 0.071 26 26 0.068 0.068 27 27 0.068 0.068 28 28 0.069 0.069 29 29 0.068 0.068 30 30 0.069 0.069 31 31 0.065 0.065 32 32 0.067 0.067 33 33 0.068 0.068 34 34 0.064 0.064 35 35 0.09 0.09 36 36 0.07 0.07 37 37 0.064 0.064 38 38 0.039 0.039 39 39 0.058 0.058 40 40 0.058 0.058 41 41 0.059 0.059 42 42 0.076 0.076 43 43 0.058 0.058 44 44 0.064 0.064 45 45 0.064 0.064 46 46 0.062 0.062 47 47 0.064 0.064 48 48 0.067 0.067 49 49 0.063 0.063 50 50 0.067 0.067 51 51 0.064 0.064 52 52 0.066 0.066 53 53 0.062 0.062 54 54 0.077 0.077 55 55 0.076 0.076 56 56 0.073 0.073 57 57 0.068 0.068 58 58 1.28 1.28 NC0038377_Worksheets_20211215,data - 14- 12/20/2021 REASONABLE POTENTIAL ANALYSIS Use"PASTE SPECIAL. Values"then"COPY" .Maximum data points=58 Results Std Dev. 0.1591 Mean 0.0906 C.V. 1.7556 n 58 Mult Factor= 1.00 Max.Value 1.280000 mg/L Max. Pred Cw 1.280000 mg/L NC0038377_Worksheets_20211215,data - 15- 12/20/2021 Reasonable Potential Multiplying Factors - Calculator 95.0% Confidence Level 95.0% Upper Boundary of the Effluent Distribution(Percentile Value Not To Exceed) 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 1 1.00 1.92 2.63 3.55 +.,. 6.20 7.98 #### 12.60 15.47 18.72 22.35 26.38 30.78 35.57 40.73 46.26 52.14 58.37 64.94 71.84 79.06 86.58 94.41 102.53 ##### 119.62 128.56 137.76 147.21 156.91 166.84 177.00 187.38 197.98 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 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 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 5 1.00 1.16 1.35 1.56 1.80 2.0c 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 6 1.00 1.15 1.31 1.50 Liu 2.14 L.$8 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Coefficient of Variation 3.6 3.7 3.8 3.9 4.0 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 5.0 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 6.0 6.1 n 208.78 219.79 231.00 242.40 253.99 265.76 277.71 289.83 302.12 314.57 327.19 339.96 352.88 365.95 379.17 392.53 406.03 419.66 433.43 447.33 461.35 475.50 489.76 504.15 518.65 533.27 1 49.64 51.54 53.44 55.36 57.28 59.21 61.15 63.09 65.03 66.98 68.93 70.89 72.85 74.81 76.78 78.75 80.72 82.69 84.67 86.64 88.62 90.60 92.58 94.56 96.54 98.52 2 24.94 25.72 26.50 27.28 28.06 28.84 29.61 30.38 31.15 31.92 32.68 33.44 34.20 34.96 35.72 36.47 37.22 37.97 38.71 39.46 40.20 40.93 41.67 42.40 43.13 43.86 3 16.14 16.58 17.01 17.44 17.87 18.30 18.72 19.14 19.56 19.98 20.39 20.80 21.21 21.61 22.02 22.42 22.82 23.21 23.61 24.00 24.39 24.77 25.16 25.54 25.92 26.30 4 11.82 12.10 12.38 12.66 12.94 13.21 13.48 13.75 14.02 14.28 14.55 14.81 15.06 15.32 15.57 15.82 16.07 16.32 16.56 16.81 17.05 17.29 17.53 17.76 18.00 18.23 5 9.30 9.50 9.70 9.90 10.09 10.29 10.48 10.66 10.85 11.04 11.22 11.40 11.58 11.76 11.93 12.10 12.28 12.45 12.62 12.78 12.95 13.11 13.28 13.44 13.60 13.76 6 7.67 7.82 7.97 8.12 8.26 8.41 8.55 8.69 8.83 8.96 9.10 9.23 9.37 9.50 9.63 9.75 9.88 10.01 10.13 10.25 10.37 10.49 10.61 10.73 10.85 10.96 7 6.53 6.65 6.77 6.88 6.99 7.11 7.22 7.33 7.43 7.54 7.65 7.75 7.85 7.95 8.05 8.15 8.25 8.34 8.44 8.53 8.63 8.72 8.81 8.90 8.99 9.08 8 5.69 5.79 5.88 5.98 6.07 6.16 6.25 6.34 6.42 6.51 6.59 6.67 6.76 6.84 6.91 6.99 7.07 7.15 7.22 7.30 7.37 7.44 7.52 7.59 7.66 7.73 9 5.06 5.13 5.21 5.29 5.36 5.44 5.51 5.58 5.65 5.72 5.79 5.86 5.93 5.99 6.06 6.12 6.19 6.25 6.31 6.37 6.43 6.49 6.55 6.61 6.66 6.72 10 4.55 4.62 4.68 4.75 4.81 4.87 4.94 5.00 5.05 5.11 5.17 5.23 5.28 5.34 5.39 5.44 5.50 5.55 5.60 5.65 5.70 5.75 5.80 5.85 5.89 5.94 11 4.15 4.20 4.26 4.31 4.37 4.42 4.47 4.52 4.57 4.62 4.67 4.72 4.77 4.81 4.86 4.90 4.95 4.99 5.03 5.08 5.12 5.16 5.20 5.24 5.28 5.32 12 3.81 3.86 3.91 3.96 4.00 4.05 4.09 4.14 4.18 4.22 4.26 4.30 4.35 4.38 4.42 4.46 4.50 4.54 4.57 4.61 4.65 4.68 4.72 4.75 4.78 4.82 13 3.53 3.57 3.61 3.66 3.70 3.74 3.77 3.81 3.85 3.89 3.92 3.96 3.99 4.03 4.06 4.10 4.13 4.16 4.19 4.22 4.26 4.29 4.32 4.35 4.37 4.40 14 3.29 3.33 3.36 3.40 3.44 3.47 3.51 3.54 3.57 3.60 3.64 3.67 3.70 3.73 3.76 3.79 3.82 3.84 3.87 3.90 3.93 3.95 3.98 4.00 4.03 4.05 15 3.08 3.12 3.15 3.18 3.21 3.24 3.28 3.30 3.33 3.36 3.39 3.42 3.44 3.47 3.50 3.52 3.55 3.57 3.60 3.62 3.65 3.67 3.69 3.71 3.74 3.76 16 2.90 2.93 2.96 2.99 3.02 3.05 3.08 3.10 3.13 3.15 3.18 3.20 3.23 3.25 3.27 3.30 3.32 3.34 3.36 3.38 3.40 3.42 3.44 3.46 3.48 3.50 17 2.75 2.77 2.80 2.83 2.85 2.88 2.90 2.92 2.95 2.97 2.99 3.01 3.03 3.06 3.08 3.10 3.12 3.14 3.16 3.17 3.19 3.21 3.23 3.25 3.26 3.28 18 2.61 2.63 2.66 2.68 2.70 2.72 2.75 2.77 2.79 2.81 2.83 2.85 2.87 2.89 2.90 2.92 2.94 2.96 2.97 2.99 3.01 3.02 3.04 3.06 3.07 3.09 19 2.48 2.51 2.53 2.55 2.57 2.59 2.61 2.63 2.65 2.66 2.68 2.70 2.72 2.73 2.75 2.77 2.78 2.80 2.81 2.83 2.84 2.86 2.87 2.89 2.90 2.91 20 2.37 2.39 2.41 2.43 2.45 2.47 2.49 2.50 2.52 2.54 2.55 2.57 2.58 2.60 2.61 2.63 2.64 2.66 2.67 2.68 2.70 2.71 2.72 2.74 2.75 2.76 21 2.27 2.29 2.31 2.33 2.34 2.36 2.37 2.39 2.41 2.42 2.44 2.45 2.46 2.48 2.49 2.50 2.52 2.53 2.54 2.56 2.57 2.58 2.59 2.60 2.61 2.63 22 2.18 2.20 2.21 2.23 2.24 2.26 2.27 2.29 2.30 2.32 2.33 2.34 2.36 2.37 2.38 2.39 2.40 2.42 2.43 2.44 2.45 2.46 2.47 2.48 2.49 2.50 23 2.10 2.11 2.13 2.14 2.16 2.17 2.18 2.20 2.21 2.22 2.23 2.25 2.26 2.27 2.28 2.29 2.30 2.31 2.32 2.33 2.34 2.35 2.36 2.37 2.38 2.39 24 2.02 2.04 2.05 2.06 2.08 2.09 2.10 2.11 2.12 2.13 2.15 2.16 2.17 2.18 2.19 2.20 2.21 2.22 2.23 2.24 2.25 2.25 2.26 2.27 2.28 2.29 25 1.95 1.97 1.98 1.99 2.00 2.01 2.02 2.03 2.04 2.06 2.07 2.08 2.09 2.09 2.10 2.11 2.12 2.13 2.14 2.15 2.16 2.16 2.17 2.18 2.19 2.20 26 1.89 1.90 1.91 1.92 1.93 1.94 1.95 1.96 1.97 1.98 1.99 2.00 2.01 2.02 2.03 2.04 2.04 2.05 2.06 2.07 2.07 2.08 2.09 2.10 2.10 2.11 27 1.83 1.84 1.85 1.86 1.87 1.88 1.89 1.90 1.91 1.91 1.92 1.93 1.94 1.95 1.96 1.96 1.97 1.98 1.99 1.99 2.00 2.01 2.01 2.02 2.03 2.03 28 1.77 1.78 1.79 1.80 1.81 1.82 1.83 1.84 1.84 1.85 1.86 1.87 1.88 1.88 1.89 1.90 1.90 1.91 1.92 1.92 1.93 1.94 1.94 1.95 1.95 1.96 29 1.72 1.73 1.74 1.75 1.76 1.76 1.77 1.78 1.79 1.79 1.80 1.81 1.82 1.82 1.83 1.84 1.84 1.85 1.85 1.86 1.87 1.87 1.88 1.88 1.89 1.89 30 1.67 1.68 1.69 1.70 1.71 1.71 1.72 1.73 1.73 1.74 1.75 1.75 1.76 1.77 1.77 1.78 1.78 1.79 1.80 1.80 1.81 1.81 1.82 1.82 1.83 1.83 31 1.63 1.64 1.64 1.65 1.66 1.66 1.67 1.68 1.68 1.69 1.70 1.70 1.71 1.71 1.72 1.72 1.73 1.74 1.74 1.75 1.75 1.76 1.76 1.76 1.77 1.77 32 1.59 1.59 1.60 1.61 1.61 1.62 1.63 1.63 1.64 1.64 1.65 1.65 1.66 1.66 1.67 1.67 1.68 1.68 1.69 1.69 1.70 1.70 1.71 1.71 1.72 1.72 33 1.55 1.55 1.56 1.57 1.57 1.58 1.58 1.59 1.59 1.60 1.60 1.61 1.61 1.62 1.62 1.63 1.63 1.64 1.64 1.65 1.65 1.65 1.66 1.66 1.67 1.67 34 1.51 1.51 1.52 1.53 1.53 1.54 1.54 1.55 1.55 1.56 1.56 1.57 1.57 1.58 1.58 1.58 1.59 1.59 1.60 1.60 1.60 1.61 1.61 1.61 1.62 1.62 35 1.47 1.48 1.48 1.49 1.49 1.50 1.50 1.51 1.51 1.52 1.52 1.53 1.53 1.53 1.54 1.54 1.55 1.55 1.55 1.56 1.56 1.56 1.57 1.57 1.57 1.58 36 1.44 1.45 1.45 1.45 1.46 1.46 1.47 1.47 1.48 1.48 1.49 1.49 1.49 1.50 1.50 1.50 1.51 1.51 1.51 1.52 1.52 1.52 1.53 1.53 1.53 1.54 37 1.41 1.41 1.42 1.42 1.43 1.43 1.43 1.44 1.44 1.45 1.45 1.45 1.46 1.46 1.46 1.47 1.47 1.47 1.48 1.48 1.48 1.48 1.49 1.49 1.49 1.50 38 1.38 1.38 1.39 1.39 1.40 1.40 1.40 1.41 1.41 1.41 1.42 1.42 1.42 1.43 1.43 1.43 1.43 1.44 1.44 1.44 1.45 1.45 1.45 1.45 1.46 1.46 39 1.35 1.35 1.36 1.36 1.37 1.37 1.37 1.38 1.38 1.38 1.38 1.39 1.39 1.39 1.40 1.40 1.40 1.40 1.41 1.41 1.41 1.41 1.42 1.42 1.42 1.42 40 1.32 1.33 1.33 1.33 1.34 1.34 1.34 1.35 1.35 1.35 1.35 1.36 1.36 1.36 1.37 1.37 1.37 1.37 1.37 1.38 1.38 1.38 1.38 1.39 1.39 1.39 41 1.30 1.30 1.30 1.31 1.31 1.31 1.32 1.32 1.32 1.32 1.33 1.33 1.33 1.33 1.34 1.34 1.34 1.34 1.34 1.35 1.35 1.35 1.35 1.35 1.36 1.36 42 1.27 1.28 1.28 1.28 1.28 1.29 1.29 1.29 1.29 1.30 1.30 1.30 1.30 1.31 1.31 1.31 1.31 1.31 1.32 1.32 1.32 1.32 1.32 1.32 1.33 1.33 43 1.25 1.25 1.25 1.26 1.26 1.26 1.26 1.27 1.27 1.27 1.27 1.28 1.28 1.28 1.28 1.28 1.28 1.29 1.29 1.29 1.29 1.29 1.29 1.30 1.30 1.30 44 1.23 1.23 1.23 1.23 1.24 1.24 1.24 1.24 1.24 1.25 1.25 1.25 1.25 1.25 1.26 1.26 1.26 1.26 1.26 1.26 1.26 1.27 1.27 1.27 1.27 1.27 45 1.21 1.21 1.21 1.21 1.21 1.22 1.22 1.22 1.22 1.22 1.22 1.23 1.23 1.23 1.23 1.23 1.23 1.24 1.24 1.24 1.24 1.24 1.24 1.24 1.24 1.25 46 1.19 1.19 1.19 1.19 1.19 1.19 1.20 1.20 1.20 1.20 1.20 1.20 1.21 1.21 1.21 1.21 1.21 1.21 1.21 1.21 1.22 1.22 1.22 1.22 1.22 1.22 47 1.17 1.17 1.17 1.17 1.17 1.17 1.18 1.18 1.18 1.18 1.18 1.18 1.18 1.18 1.19 1.19 1.19 1.19 1.19 1.19 1.19 1.19 1.19 1.20 1.20 1.20 48 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.16 1.16 1.16 1.16 1.16 1.16 1.16 1.16 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.17 49 1.13 1.13 1.13 1.13 1.13 1.13 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 1.15 50 1.11 1.11 1.11 1.11 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.12 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 1.13 51 1.09 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 1.11 52 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 1.09 53 1.06 1.06 1.06 1.06 1.06 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 1.07 54 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.06 1.06 1.06 1.06 55 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 56 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 57 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 58 3.6 3.7 3.8 3.9 4.0 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 5.0 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 6.0 6.1 RPM Fs as f(n,CV,Confidence,UpperBound) 400.00 350.00 300.00 o C 350.00-400.00 LL 250.00 [ 300.00-350.00 ° ❑250.00-300.00 200.00 ❑200.00-250.00 150.00 0 150.00-200.00 100.00-150.00 100.00 ❑50.00-100.00 50.00 .. c ❑0.00 50.00 1.1 -1 0.00 c 0.1 > 1 4 7 10 13 16 19 22 25 Date: 12/20/2021 Dissolved to Total Metal Calculator FACILITY:Mayo Steam Station NPDES PERMIT:NC0038377 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 In accordance with Federal Regulations,permit limitations must be written as Total Metals per 40 CFR 122.45(c) "Effluent Hardness"under the Data Sheet. In accordance with 40 CFR 122.45(c),permits are,have and Receiving Receiving Rec.Stream NPDES Total Suspended Combined Combined Instream Instream Effluent Upstream must be written as total metals. Stream Stream Solids Hardness Hardness Wastewater Wastewater Hardness 1Q10 Flow Limit Hardness summer summer 7Q10 -Fixed Value- chronic Acute Concentration Concentration Average(mg/L) 7Q10(CFS) (MGD) [MGD] MGD (mg/L) (mg/L) (mg/L) (Chronic) (Acute) (mg/L) Average This calculator has been inserted into the RPA to calculate Total Metal allowable allocations once Table 1 has been completed o.0000 o.0000 0.0000 10.2500 25.000 II 25.000 II 100.0000 I 100.0000 25 25 (Input Sheet)and Effluent hardness has been entered(Data Upstream Hard Avg(mg/L)= 25 ACAH 25 EFF Hard Avg(mg/L)= 25 ACCH 25 Sheet). 1) Following the spreadsheet from left to right. First US EPA Maximum Allowable Effluent Concentration COMMENTS(identify parameters to PERCS Branch to maintain in facility's LTMP/STMP): the allowable allocations for the dissolved metals will Dissolved Metals Translators-using (MAEC)as a Total Metal PARAMETER Default Partition =Dissolved Metal-Translator appear for all the metals listed once Table 1 is complete and Chronic Acute Coefficients Chronic Acute effluent hardness entered.Use a default value of 25 mg/L if lug/11 fug/11 (streams) [uq/Il fug/Il Cadmium(d) 0.15 0.82 0.252 0.59 3.24 no hardness data is available. Second,the Cd-Trout streams 0.15 0.51 0.252 0.59 2.01 Dissolved Metal allocations are divided by the Translators to Chromium III(d)(h) 24 183 0.202 117.73 905.08 determine the Total Metals that can be allocated to the Chromium VI(d) 11 16 1.000 11.00 16.00 Permittee.These Total Metals values are automatically Chromium,Total(t) N/A N/A inserted into Table 2 and are the allowable Total Metal 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 allocations determined for the Permittee prior to allowing Nickel(d)(h) 16 145 0.432 37.23 335.21 for dilution.See Input sheet Table 2.The final acute and Ni-WS streams(t) 25 N/A chronic values shown under the RPA sheet are the Total Silver(d)(h,acute) 0.06 0.30 1.000 0.06 0.30 Metal values listed in Table 2 divided by the acute and Zinc(d)(h) 36 36 0.288 126.73 125.71 chronic IWC,respectively. Beryllium 6.5 65 1.000 6.5 65 2) The Translators used in the freshwater RPA are the Partition Arsenic(d) 150 340 1.000 150 340 Coefficients published by US EPA in 1984.They are TSS dependent equations and can be found listed with the WQS (d)=dissolved metal standard.See 15A NCAC 02B.0211 for more information. hardness dependent equations under the sheet labeled (h)=hardness-dependent dissolved metal standard.See 15A NCAC 02B.0211 for more information. Equations.A fixed TSS value of 10 mg/L is used to calculate (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 Translator values. The Human Health standard for Arsenic is 10 ug/L which is Total Recoverable metal standard. 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 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 mo/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 = (Hardness instream(a),mq/L*7010,MGD)+(Hardness effiuent(6),mq/L*Plant flow,MGD) (mass balance) (7010.MGD+Plant flow,MGD) (a) Use the median instream Hardness value of the ambient 8-digit HUC data collected by the Division of Water Quality.To find the 8-digit HUC hardness value for your facility,Click Here. (b) For the purpose of this estimation,use the facility's median effluent Hardness value,if available.The Division will request the permittee to sample effluent hardness once/month and submit one to two years of data with the permit renewal application.If no effluent hardness data 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.8190pn hardness]+D6848) 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) v.6/2/2010 Translator equation using Default Partition Coefficients= 1 [1+(Kpo*TSS(1+a)*106)] Kpo and w 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.09E+06 -0.7936 Zn 1.25E+06 -0.70. Pb 2.80E+06 -0.8 Cr(III)(2) 3.36E+06 -0.09309 Cd 9.00E+06 -1.1307 Ni 9.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.(EPA440/9-04022) Example for Cadmium(streams) (2) [near partltion coefficients shall not apply to the Chromium VI numerical crteron.The approved am^Tcal method for Chromum VI measures only the dssoived form.Therefore,perm fawn'. TABLE B.US EPA Translators TSS=10 mg/L US EPA Translators Kpo=14.00E+06 07 PARAMETER Using stream Default Partion Coefficients a Trantvt 00 slator = 1 TSS=10 mg/L [1+(Kpo*TSS[1b)*10T] Cadmium 0.252 - 1 Chromium III 0.202 [1+(4.00310s*10"von*106)] Chromium VI Chromium,Total N/A = 1 Copper 0.398 [1+2.960465] Lead 0.189 =0 252 Nkkel 0.932 Slyer nc 0.28B 9/11/2013 rdb New freshwater RPA based on 95%probability/95%confidence Statistically 58 points are the maximum number of points allowed under this RPA program.Data fields were estbalished to allow only 58 data point entries. Additional messages will appear to alert user if more than 58 data points were enter and no predicted values will be calculated All worksheets are"Protected" The"mf calculator"is password"Protected" OTHER CHANGES FROM PREVIOUS RPA PROGRAM: A.When Model is applied(Check box activated): 1)assumes only chroinc dilution known 2)assumes user will insert appropriate flow values for"7Q10s(cfs)","7Q10w(cfs)","30Q2(cfs)","QA(cfs)"to define chronic dilution in terms of"IWC%","IWC%"is the same for all stream flows 3)automatically assigns the entered chronic IWC%to the"IWC A 7Q10s","IWC A 7Q10w","IWC A 30Q2","IWC A QA"values used in chronic WQS calculations(See"RPA"page) 3)"1Q10s(cfs)"automatically defaults to no acute dilution,acute IWC=100%,"IWC A 1Q1Os"=100%which is used in acute WQS calculatons(See"RPA"page) B.When Model is not applied(Check box NOT activated): 1)assumes user will insert appropriate flow values for"7Q10s(cfs)","7Q10w(cfs)","30Q2(cfs)","QA(cfs)","Flow Qw(MGD)"for chronic IWC%calculations,IWC%will vary according to flows 3)automatically calculates chronic-based IWC%for the"IWC A 7Q10s","IWC A 7Q10w","IWC A 30Q2","IWC A QA"values used in chronic WQS calculations(See"RPA"page) 3)"1Q10s(cfs)"is automatically calculated bases on entered"7Q10s(cfs)"flow 4)automatically calculates acute-based IWC%for the"IWC A 1Q1Os"value used in acute WQS calculations(See"RPA"page) C.When paremeter's"Impaired?"check box is activated: 1)automtically activtes the"IMPAIRED"message alert on the"RPA"page for that parameter 2)does NOT make any automatic adjustements to WQS calculations NOTE:If new or expanding discharge and receiving stream impaired,will need to evaluate if additional waste load is allowed 10/30/2013 rdb 1)Amended"ERR"alert on data sets entreies to activate if"<"entered but no value entered,does not effect RPA calculation,ERR message only 2)Added new calculation feature to count nondetects when both"<"and a value are entered for each data set,used to calculate detected entries 3)Amended"Comments"drop down menu-per Juile 4)Turned the Chronic toxicity concentration message off on the RPA page-per Julie 2/10/14: ON"data"page changed highlighted area from blue shades to gray 5/2/14 rdb 1)Increased rounding factor on all calculated IWC%to 7 decimals 2)Increased display for all calkculated to 6 decimals places. 5/5/14 rdb Increased rounding factor on all calculated IWC%to 9 decimals 5/21/14 rdb Removed ROUND function from all IWC%calculations 7/31/14 rdb Moved RPA page tile blocks down one row so header text was separated 9/9/15: COMPLETED REVISIONS FOR METAL TRANSLATOR FEATURE 1)Added tabs for"HUC Hardness"(lookup table for HUC hardness values),"Hardness Equations"(summary of translator formulas,metals impacted,general info),"Dss to Total Hardness Calculator" (calcution sheet for metal translator,impacted chronic and acute wqs) 2)Revised"Input"page Table 1: -New user input for"8 Digit HUC Number"uisng drop down menu for lookup HUC Hardness,required entry,brown highlight -New display only for calculated"Effluent Hardness(Median)"including conditional method for info display,brown highlight -New display only for designed"HUC Hardness(Median)"incuding conditionla method for info display,brown highlight -New display only for calculated "Combined Hardness Chronic"for metal translator application,brown highlight -New display only for calculated"Combined Hardness Acute"for metal translator application,brown highlight -Assigned name for"HUC Number" 3)Revised"Input"pade Table 2: -Removed"Impaired?"column,conditional display,references -Added new column for"WQS"designation incuding assigning applicable WQS where fixed -Added new error message"CHECK WQS",conditonal control based on"WQS"entry for Cadmium,Chlorides,Molybdeum,Nickel -Revised text in error message -Added new brown highlight"Metal Translator Data Entry"label box -Removed Par01"Arsenic"line -Revised Par02"Arsenic"line to reflect Human Health and Water Supply criterion,Chronic=10 mg/L,Acute="N/A" -Revised Par04"Cadmium"line: a)"WQS"input with drop down menu to select applicable criterion b)"Chronic"and"Acute"inputs to display calculated metal translator values including conditional method for info display based on"WQS"selection,no rounding c)"Modifier"input display only based on"WQS"selection including conditional method for info dispaly d)Conditonal controls to activate error nessages,brown highlight -Revised Par05"Chloride(AL)"line: a)"WQS"input with drop down menu to select applicable criterion b)"Chronic"display only for applicable value including conditional method for info display based on"WQS"selection c)"Modifier"input display only based on"WQS"selection including conditional method for info dispaly d)"Name"display only based on"WQS"selection including conditional metdod fro info display e)Conditonal controls to activate error nessages -Revised"Chromium,Total"line: a)Removed Par08 label b)"Chronic"and"Acute"inputs to display calculated metal translator values,no rounding c)brown highlight -Added new"Chromium III"line: a)Assigned applicable text in"WQS","Type",Modifier",Units" b)"Chronic"and"Acute"inputs to display calculated metal translator values,no rounding c)brown highlight -Added new Par08"Chromium VI"line: a)Assigned Par08 label,applicable text in"WQS","Type",Modifier",Units" b)"Chronic"and"Acute"inputs to display calculated metal translator values,no rounding c)brown highlight -Revised Par09"Copper(AL)"line: a)"Chronic"and"Acute"inputs to display calculated metal translator values,no rounding b)brown highlight -Revisd Par12"Lead"line: a)"Chronic"and"Acute"inputs to display calculated metal translator values,no rounding b)brown highlight -Revised Par14"Molybdenum"lime: a)"WQS"input with drop down menu to select applicable criterion b)"Chronic"display only for applicable value including conditional method for info display based on"WQS"selection c)"Modifier"input display only based on"WQS"selection including conditional method for info dispaly d)Conditonal controls to activate error nessages -Revised Par15"Nickel"line: a)"WQS"input with drop down menu to select applicable criterion b)"Chronic"and"Acute"inputs to display calculated metal translator values including conditional method for info display based on"WQS"selection,no rounding c)"Modifier"input display only based on"WQS"selection including conditional method for info dispaly d)Conditonal controls to activate error nessages,brown highlight -Revised Par17"Silver(AL)"line: a)"Chronic"and"Acute"inputs to display calculated metal translator values,no rounding b)brown highlight -Revised Par18"Zinc(AL)"line: a)"Chronic"and"Acute"inputs to display calculated metal translator values,no rounding b)brown highlight 3)Revised"Data"page: -Revised Par01"Arsenic"entry,text, and calculations("1")-all effluent hardness data to be entered in this section for used to calculate eflluent hardness factors a)Reference to Par01"Arsenic"removed b)New label"Effluent Hardness(monthly average)"added c)"Mult Factor="and"Max.Pred Cw"removed,text and calcuation d)"10%value"and"Median value"added,text and calculation including conditional method for info display e)Assigned name"Effluent Median"and"effluent 10"to calculated values f)PQL condition removed from calculation method for data displayed 4)Revised"RPA"page: -Removed all features assocaited with"Impairment" -Added new display only for calculated"COMBINED HARDNESS(mg/L)",Chonic and Acute,conditional method for info display -Revised"Receiving Stream"display to include selected HUC Number in text -Removed unused display features for WET%(previouly hidden) -Revised"Arsenic" lines: a)Par01"Arsenic" line removed b)Par02"Arsenic"references used for display to calculate"Acute"and Chronic" allowable Cw -Revised"Cadmium","Chromium VI","Copper(AL)","Lead","Nickel","Silver(AL)","Zinc(AL)"(lines: a)"NC WQS/Chronic"and 1/2 FAV/Acute"conditional method revised for info display,no rounding b)"Allowable Cw"Acute"and"Chronic"conditional metfhod revised fro info display inculding rounding value 5)Revised"Dss to Total Metal Hardness Calculator"page -Assigned names for: a)"CdMAE AC"-Cadmium calculated metal translator Acute value b)"CdMAE CH"-Cadmium calculated metal translator Chronic value c)"CuMAE AC"-Copper calculatd metal translator Acute value d)"CuMAE CH"-Copper calculated metal translator Chronic value e)"Cr Total AC"-Total Chromium calculated meatl 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)"CHO"-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,ug/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%.