The URL can be used to link to this page

Home My WebLink AboutNC0039586_Worksheets_20210903 (2) Monitoring Frequencies Per Memo Dated 7-15-2010 2B.0500 Effluent Limited RPA Condition Permit Monitoring Frequency pH E 2/Month 1/Week 3/Week Daily Temp,C E 1/Week 1/Week 3/Week Daily I.RPA Exists Monitor Monthly and add Permit Limit BOD5 I,E 2/Month 1/Week 3/Week Daily 2.RPA BUSH.but ActionLevels(Cu,Zn,Ag,Fe.Cl) Monitor Quarterly in conjunction with lox Test TSS I,E 2/Month 1/Week 3/Week Daily NH3-N E 1/Month 2/Month 1/Week 3/Week 3a.RPA Exists but Damsel Limited(n<8samples) Monitor Quart erly Fecal Col. E 2/Month 1/Week 3/Week Daily 3b.RPA exists,dataset limited,but 2 values> Monitor Monthly and add Permit Limit TN E See notes below. allowable Cw TP E See notes below. 4.NoRYA(Predicted Max>50a/oof Allowable) Monitor Quanerly(or deferto Pretreat LIMP) Water Quality Limited 3.NoRPA(Predicted Max<50%Allowable) No Monitoring Frequency 6a.No Data(New Pennit,New Waste Stream) Monitor Monthly for Toxic Pollutants of Concern Parameter Location Class I Class II Class III Class IV 6b.NewGireensand or Conventional WTP Monitor Quarterly fo[Toxit Pollutants of Conc as 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* password all sheets=rpa2017 BOD5 I,E 2/Month 1/Week 3/Week Daily TSS I,E 2/Month 1/Week 3/Week Daily NH3-N E 1/Month 2/Month 1/Week 3/Week 4/28/16:Note Action Level designation no longer allowed per EPA. TRC E 2/Week 2/Week 3/Week Daily 11/20/17 Chlorides still listed as have action levels but will be coorected at next EPA review Fecal Col. E 2/Month 1/Week 3/Week Daily Fecal Col. U,D 2/Month 1/Week 3/Week` 3/Week* Conductivi E 1/Week 1/Week 3/Week Daily Conductivi U,D 1/Week 1/Week 3/Week* 3/Week* TN E See notes below. TP E See notes below. Notes: `Upstream and downstream monitoring in WQ-limited waters is to be conducted 3/Week during Jun,Jul,Aug,and Sep;and 1/Week during the rest of the year. TN,TP Monitoring All facilities>=0.05 MGD will monitor TN and TP Those<0.05 MGD will monitor if discharging to NSW For the Neuse,Tar-Pamlico,and any other river basins classified as NSW,use limits and monitoring requirements according to the basin's permitting strategy. For French Broad,Broad,Savannah,New Watauga,Little Tennessee,and Hiwassee: ->=0.05 M-monitor semi-annually ->=1.0 MC-monitor quarterly For all other river basins: ->=0.05 M-monitor quarterly ->=1.0 MC-monitor monthly 111 Sample recommendations: 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 necessary in permit Msg05 MaxPredCw>Acute DAILY MAX LIMIT? No limit Msg06 MaxPredCw>Chronic MO AVG LIMIT? No limit-assuming no tox(Action Level parameter) Msg07 MaxPredCw»Acute DAILY MAX LIMIT? No limit(Action Level parameter) Msg08 MaxPredCw»Chronic MO AVG LIMIT? Continue to monitor at 2/month Msg09 No acute standard or 1/2 FAV N/A Mo.avg.limit(keep wk.avg.if existing) Msg10 No chronic standard or criterion N/A Revise daily max.limit Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators MAXIMUM DATA POINTS = 58 REQUIRED DATA ENTRY Table 1. Project Information Table 2. Parameters of Concern 0 CHECK IF HQW OR ORW WQS Name WQS Type Chronic Modifier Acute PQL Units Facility Name Shearon Harris Nuclear Plant Par01 Arsenic Aquactic Life C 150 FW 340 ug/L WTP/WTP Class II Par02 Arsenic Human Health W C 10 HH/WS N/A ug/L Water Supply NPDES Permit NC0039586 Par03 Beryllium Aquatic Life NC 6.5 FW 65 ug/L Outfall 006 Par04 Cadmium Aquatic Life NC 0.9013 FW 5.2852 ug/L Flow,Qw(MGD) 7.900 Par05 Chlorides Aquatic Life NC 230 FW .ng/L Receiving Stream Harris Reservoir ParOt* Chlorinated Phenolic Compounds Water Supply NC 1 A ug/L HUC Number Par07 * Total Phenolic Compounds Aquatic Life NC 300 A ug/L Stream Class Par08 Chromium III Aquatic Life NC 186.3593 FW 1432.6571 ug/L WS-V El Apply WS Hardness WQC Par09 Chromium VI Aquatic Life NC 11 FW 16 pg/L 7Q10s(cfs) 0.00 I ParlO Chromium,Total Aquatic Life NC N/A FW N/A pg/L 7Q1Ow(cfs) 0.00 Par11 Copper Aquatic Life NC 12.7251 FW 17.7618 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 5.5121 FW 141.4489 ug/L Effluent Hardness 43.8 mg/L(Avg) Par15 Mercury Aquatic Life NC 12 FW 0.5 ng/L Upstream Hardness 25 mg/L(Avg) I Par16 Molybdenum Human Health NC 2000 HH ug/L Combined Hardness Chronic 43.8 mg/L I Par17 Nickel Aquatic Life NC 59.8327 FW 538.6977 pg/L Combined Hardness Acute 43.8 mg/L I Par18 Nickel Water Supply NC 25.0000 WS N/A pg/L Data Source(s) Par19 Selenium Aquatic Life NC 5 FW 56 ug/L ❑CHECK TO APPLY MODEL Par20 Silver Aquatic Life NC 0.06 FW 0.7776 ug/L Par21 Zinc Aquatic Life NC 203.8158 FW 202.1621 ug/L Par22 Par23 Par24 Follow directions for data entry. In some cases a Par25 comment menu list the available choices or a dropdown menu will provide a list you may select from.Error message occur if data entry does not • meet input criteria. NC0039586_Worksheets_20210903(2), input 9/14/2021 For all dischargers to all waters of the state: Narrative aesthetic "Total Phenolic Compounds" water quality standard(300 ug/L).Data should be supplied using US EPA Method 420.1(colorimetric)or US EPA Method 420.4(automated colorimetri, and will be labeled"Phenols"or"Total Recoverable Phenolics". (EPA Parameter Code:32730) For dischargers to Water Supply(WS)streams that chlorinate the effluent: "Chlorinated Phenolic Compounds"in Water Supply classified waters is an aesthetic standard at 1.0 ug/L.Concentrations of all chlorinated phenolic compounds,detected above the PQL,using US EPA Method 625 data,should be summed*and compared to the 1.0 ug/L water supply water quality standard for"chlorinated phenolic compounds".(EPA Parameter Code:34034) The following is a list of Chlorinated Phenolic Compounds detected using US EPA Method 625: 2-chlorophenol 2,4-dichlorophenol 2,4,6-trichlorophenol 4-chloro-3-methylphenol pentachlorophenol Additional chlorinated phenolic compounds MAY be reported. If reported above the PQL,the additional chlorinated compounds should be added to the five chlorinated compounds listed above to calculate the total chlorinated phenolics in the sample.NOTE:these additional compounds are NOT required to be reported by 40 CFR Part 136 regulations for US EPA Method 625. 3-chlorophenol 4-chlorophenol 2,3-dichlorophenol 2,5-dichlorophenol 2,6-dichlorophenol 3,4-dichlorophenol 2,3,6-trichlorophenol 2,4,5-trichlorophenol 2,3,4,6-tetrachlorophenol 4-chloro-2-methylphenol 6-chloro-3-methylphenol *The following US EPA Method 625 reported non-chlorinated phenolic compounds SHOULD NOT be summed with the chlorinated data for comparison to the Water Supply standard for chlorinated phenolics 2,4-Dimethylphenol 2,4-Dinitrophenol 2-Methyl-4,6-dinitrophenol 2-Nitrophenol 4-Nitrophenol Phenol p-cresol(4-methylphenol) o-cresol(2-methylphenol) NC0039586_Worksheets_20210903(2),input 9/14/2021 REASONABLE POTENTIAL ANALYSIS H1 Use"PASTE H2 use"PASTE Par01&Par02 use.PASTE Par03 Use"PASTE SPECIAL-Values" SPECIAL-Values.' SPECIAL-Values" SPECIAL-Values" Effluent Hardness then"COPY". Upstream Hardness then"COPY". Arsenic then"COPY". Beryllium then"COPY". Maximum data points Maximum data points Maximum data points Maximum data points =58 =58 =58 =58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 43.8 43.8 Std Dev. N/A 1 25 25 Std Dev. N/A 1 2.74 2.74 Std Dev. N/A 1 < 1 0.5 Std Dev. N/A 2 Mean 43.8000 2 Mean 25.0000 2 Mean 2.7400 2 Mean 0.5000 3 C.V. 0.0000 3 C.V. 0.0000 3 C.V.(default) 0.6000 3 C.V.(default) 0.6000 4 n 1 4 n 1 4 n 1 4 n 1 5 10th Per value 43.80 mg/L 5 10th Per value 25.00 mg/L 5 5 6 Average Value 43.80 mg/L 6 Average Value 25.00 mg/L 6 Mult Factor= 6.20 6 Mult Factor= 6.20 7 Max.Value 43.80 mg/L 7 Max.Value 25.00 mg/L 7 Max.Value 2.7 ug/L 7 Max.Value 0.50 ug/L 8 8 8 Max.Pred Cw 17.0 ug/L 8 Max.Pred Cw 3.10 ug/L 9 9 9 9 10 10 10 10 11 11 11 11 12 12 12 12 13 13 13 13 14 14 14 14 15 15 15 15 16 16 16 16 17 17 17 17 18 18 18 18 19 19 19 19 20 20 20 20 21 21 21 21 22 22 22 22 23 23 23 23 24 24 24 24 25 25 25 25 26 26 26 26 27 27 27 27 28 28 28 28 29 29 29 29 30 30 30 30 31 31 31 31 32 32 32 32 33 33 33 33 34 34 34 34 35 35 35 35 36 36 36 36 37 37 37 37 38 38 38 38 39 39 39 39 40 40 40 40 41 41 41 41 42 42 42 42 43 43 43 43 44 44 44 44 45 45 45 45 46 46 46 46 47 47 47 47 48 48 48 48 49 49 49 49 50 50 50 50 51 51 51 51 52 52 52 52 53 53 53 53 54 54 54 54 55 55 55 55 56 56 56 56 57 57 57 57 58 58 58 58 NC0039586_Worksheets_20210903(2),data -3- 9/14/2021 REASONABLE POTENTIAL ANALYSIS Par04 Use•'PASTE Par. Par06 Use"PASTE Par07 Use"PASTE SPECIAL-Values" Use"PASTE SPECIAL- SPECIAL-Values" SPECIAL-Values" Cadmium then'coPr'. Chlorides Values"then"COPY". Chlorinated Phenolic Compounds then"COPY". Total Phenolic Compounds then"COPY". Maximum data points= Maximum data points Maximum data points Maximum data points =58 58 =58 =58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 < 0.1 0.05 Std Dev. N/A 1 Std Dev. NO DATA 1 Std Dev. NO DATA 1 < 20 10 Std Dev. N/A 2 Mean 0.0500 2 Mean NO DATA 2 Mean NO DATA 2 Mean 10.0000 3 C.V.(default) 0.6000 3 C.V. NO DATA 3 C.V. NO DATA 3 C.V.(default) 0.6000 4 n 1 4 n 0 4 n 0 4 n 5 5 5 5 6 Mult Factor= 6.20 6 Mult Factor= N/A 6 Mult Factor= N/A 6 Mult Factor= 6.20 7 Max.Value 0.050 ug/L 7 Max.Value N/A mg/L 7 Max.Value N/A ug/L 7 Max.Value 10.0 ug/L 8 Max.Pred Cw 0.310 ug/L 8 Max.Pred Cw N/A mg/L 8 Max.Pred Cw N/A ug/L 8 Max.Pred Cw 62.0 ug/L 9 9 9 9 10 10 10 10 11 11 11 11 12 12 12 12 13 13 13 13 14 14 14 14 15 15 15 15 16 16 16 16 17 17 17 17 18 18 18 18 19 19 19 19 20 20 20 20 21 21 21 21 22 22 22 22 23 23 23 23 24 24 24 24 25 25 25 25 26 26 26 26 27 27 27 27 28 28 28 28 29 29 29 29 30 30 30 30 31 31 31 31 32 32 32 32 33 33 33 33 34 34 34 34 35 35 35 35 36 36 36 36 37 37 37 37 38 38 38 38 39 39 39 39 40 40 40 40 41 41 41 41 42 42 42 42 43 43 43 43 44 44 44 44 45 45 45 45 46 46 46 46 47 47 47 47 48 48 48 48 49 49 49 49 50 50 50 50 51 51 51 51 52 52 52 52 53 53 53 53 54 54 54 54 55 55 55 55 56 56 56 56 57 57 57 57 58 58 58 58 NC0039586_Worksheets_20210903(2),data -4- 9/14/2021 REASONABLE POTENTIAL ANALYSIS Par08 Use"PASTE Par09 use.PASTE Par10 use.PASTE Pal Use"PASTE SPECIAL-Values" SPECIAL-Values.' SPECIAL-Values" SPECIAL-Values" Chromium III then"COPY". Chromium VI then"COPY". Chromium,Total then"COPY". Copper then"COPY". Maximum data points Maximum data points Maximum data points Maximum data points =58 =58 =58 =58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 Std Dev. NO DATA 1 Std Dev. NO DATA 1 1.55 1.55 Std Dev. N/A 1 6.82 6.82 Std Dev. 10.1824 2 Mean NO DATA 2 Mean NO DATA 2 Mean 1.5500 2 8.45 8.45 Mean 18.7443 3 C.V. NO DATA 3 C.V. NO DATA 3 C.V.(default) 0.6000 3 7.23 7.23 C.V. 0.5432 4 n 0 4 n 0 4 n 1 4 6.82 6.82 n 58 5 5 5 5 7.21 7.21 6 Mult Factor= N/A 6 Mult Factor= N/A 6 Mult Factor= 6.20 6 6.33 6.33 Mult Factor= 1.00 7 Max.Value N/A pg/L 7 Max.Value N/A pg/L 7 Max.Value 1.6 pg/L 7 5.12 5.12 Max.Value 63.50 ug/L 8 Max.Pred Cw N/A pg/L 8 Max.Pred Cw N/A pg/L 8 Max.Pred Cw 9.6 pg/L 8 9.1 9.1 Max.Pred Cw 63.50 ug/L 9 9 9 9 8.63 8.63 10 10 10 10 11 11 11 11 11 11 12.9 12.9 12 12 12 12 22.4 22.4 13 13 13 13 19.1 19.1 14 14 14 14 32.6 32.6 15 15 15 15 22.2 22.2 16 16 16 16 2.61 2.61 17 17 17 17 63.5 63.5 18 18 18 18 21.9 21.9 19 19 19 19 12.6 12.6 20 20 20 20 12.1 12.1 21 21 21 21 10.65 10.65 22 22 22 22 9.69 9.69 23 23 23 23 9.44 9.44 24 24 24 24 10.7 10.7 25 25 25 25 12.9 12.9 26 26 26 26 11.9 11.9 27 27 27 27 20.5 20.5 28 28 28 28 17.8 17.8 29 29 29 29 21.1 21.1 30 30 30 30 21.65 21.65 31 31 31 31 18.3 18.3 32 32 32 32 24.1 24.1 33 33 33 33 30.85 30.85 34 34 34 34 26 26 35 35 35 35 40.57 40.57 36 36 36 36 24.9 24.9 37 37 37 37 32.7 32.7 38 38 38 38 18.15 18.15 39 39 39 39 14.1 14.1 40 40 40 40 36.4 36.4 41 41 41 41 28.65 28.65 42 42 42 42 23.6 23.6 43 43 43 43 22.1 22.1 44 44 44 44 20.45 20.45 45 45 45 45 23.3 23.3 46 46 46 46 12.3 12.3 47 47 47 47 16.5 16.5 48 48 48 48 21.8 21.8 49 49 49 49 22.9 22.9 50 50 50 50 26.95 26.95 51 51 51 51 21.5 21.5 52 52 52 52 18.4 18.4 53 53 53 53 17.6 17.6 54 54 54 54 24.4 24.4 55 55 55 55 22.8 22.8 56 56 56 56 17.4 17.4 57 57 57 57 14.2 14.2 58 58 58 58 21.3 21.3 NC0039586_Worksheets_20210903(2),data -5- 9/14/2021 REASONABLE POTENTIAL ANALYSIS Par12 Use"PASTE Par13 Use"PASTE Par14 Use"PASTE Par15 Use"PASTE SPECIAL-Values" SPECIAL-Values.' SPECIAL-Values" SPECIAL-Values" Cyanide then"COPY". Fluoride then"COPY". Lead then"COPY". Mercury then"COPY". Maximum data points Maximum data points Maximum data points Maximum data points =58 =58 =58 =58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date BDL=1/2DL Results Date Data BDL=1/2DL Results 1 < 8 5 Std Dev. N/A 1 320 320 Std Dev. N/A 1 < 1 0.5 Std Dev. N/A 1 < 50 25 Std Dev. N/A 2 Mean 5.00 2 Mean 320.0000 2 Mean 0.5000 2 Mean 25.0000 3 C.V.(default) 0.6000 3 C.V.(default) 0.6000 3 C.V.(default) 0.6000 3 C.V.(default) 0.6000 4 n 1 4 n 1 4 n 1 4 n 1 5 5 5 5 6 Mult Factor= 6.20 6 Mult Factor= 6.20 6 Mult Factor= 6.20 6 Mult Factor= 6.20 7 Max.Value 5.0 ug/L 7 Max.Value 320.0 ug/L 7 Max.Value 0.500 ug/L 7 Max.Value 25.0 ng/L 8 Max.Pred Cw 31.0 ug/L 8 Max.Pred Cw 1984.0 ug/L 8 Max.Pred Cw 3.100 ug/L 8 Max.Pred Cw 155.0 ng/L 9 9 9 9 10 10 10 10 11 11 11 11 12 12 12 12 13 13 13 13 14 14 14 14 15 15 15 15 16 16 16 16 17 17 17 17 18 18 18 18 19 19 19 19 20 20 20 20 21 21 21 21 22 22 22 22 23 23 23 23 24 24 24 24 25 25 25 25 26 26 26 26 27 27 27 27 28 28 28 28 29 29 29 29 30 30 30 30 31 31 31 31 32 32 32 32 33 33 33 33 34 34 34 34 35 35 35 35 36 36 36 36 37 37 37 37 38 38 38 38 39 39 39 39 40 40 40 40 41 41 41 41 42 42 42 42 43 43 43 43 44 44 44 44 45 45 45 45 46 46 46 46 47 47 47 47 48 48 48 48 49 49 49 49 50 50 50 50 51 51 51 51 52 52 52 52 53 53 53 53 54 54 54 54 55 55 55 55 56 56 56 56 57 57 57 57 58 58 58 58 NC0039586_Worksheets_20210903(2),data -6- 9/14/2021 REASONABLE POTENTIAL ANALYSIS Par16 use"PASTE Par17&Par18 use.PASTE Par19 use.PASTE Par20 Use"PASTE SPECIAL-Values" SPECIAL-Values" SPECIAL-Values.' SPECIAL-Values" Molybdenum then"COPY". Nickel then"COPY". Selenium then"COPY". Silver then"COPY". Maximum data points Maximum data points Maximum data points Maximum data points =58 =58 =58 =58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 Std Dev. NO DATA 1 < 10 5 Std Dev. 1.8173 1 < 1 0.5 Std Dev. N/A 1 < 1 0.5 Std Dev. N/A 2 Mean NO DATA 2 2.43 2.43 Mean 3.7150 2 Mean 0.5000 2 Mean 0.5000 3 C.V. NO DATA 3 C.V.(default) 0.6000 3 C.V.(default) 0.6000 3 C.V.(default) 0.6000 4 n 0 4 n 2 4 n 1 4 n 5 5 5 5 6 Mult Factor= N/A 6 Mult Factor= 3.79 6 Mult Factor= 6.20 6 Mult Factor= 6.20 7 Max.Value N/A ug/L 7 Max.Value 5.0 fag/L 7 Max.Value 0.5 ug/L 7 Max.Value 0.500 ug/L 8 Max.Pred Cw N/A ug/L 8 Max.Pred Cw 19.0 fag/L 8 Max.Pred Cw 3.1 ug/L 8 Max.Pred Cw 3.100 ug/L 9 9 9 9 10 10 10 10 11 11 11 11 12 12 12 12 13 13 13 13 14 14 14 14 15 15 15 15 16 16 16 16 17 17 17 17 18 18 18 18 19 19 19 19 20 20 20 20 21 21 21 21 22 22 22 22 23 23 23 23 24 24 24 24 25 25 25 25 26 26 26 26 27 27 27 27 28 28 28 28 29 29 29 29 30 30 30 30 31 31 31 31 32 32 32 32 33 33 33 33 34 34 34 34 35 35 35 35 36 36 36 36 37 37 37 37 38 38 38 38 39 39 39 39 40 40 40 40 41 41 41 41 42 42 42 42 43 43 43 43 44 44 44 44 45 45 45 45 46 46 46 46 47 47 47 47 48 48 48 48 49 49 49 49 50 50 50 50 51 51 51 51 52 52 52 52 53 53 53 53 54 54 54 54 55 55 55 55 56 56 56 56 57 57 57 57 58 58 58 58 NC0039586_Worksheets_20210903(2),data -7- 9/14/2021 REASONABLE POTENTIAL ANALYSIS Par21 use"PASTE Par22 use"PASTE Par23 use"PASTE Par24 use"PASTE Par25 Use"PASTE SPECIAL-Values" SPECIAL-Values'. SPECIAL-Values" SPECIAL-Values'. SPECIAL-Values" Zinc then"COPY". 0 then"COPY". 0 then"COPY". 0 then"COPY". 0 then"COPY". Maximum data points Maximum data points Maximum data points Maximum data points Maximum data points =58 =58 =58 =58 =58 Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results Date Data BDL=1/2DL Results 1 < 5 2.5 Std Dev. 4.3608 1 Std Dev. NO DATA 1 Std Dev. NO DATA 1 Std Dev. NO DATA 1 Std Dev. NO DATA 2 < 5 2.5 Mean 7.4878 2 Mean NO DATA 2 Mean NO DATA 2 Mean NO DATA 2 Mean NO DATA 3 5.62 5.62 C.V. 0.5824 3 C.V. NO DATA 3 C.V. NO DATA 3 C.V. NO DATA 3 C.V. NO DATA 4 5.32 5.32 n 58 4 n 0 4 n 0 4 n 0 4 n 0 5 < 5 2.5 5 5 5 5 6 5.82 5.82 Mult Factor= 1.00 6 Mult Factor= N/A 6 Mult Factor= N/A 6 Mult Factor= N/A 6 Mult Factor= N/A 7 < 5 2.5 Max.Value 26.6 ug/L 7 Max.Value N/A 7 Max.Value N/A 7 Max.Value N/A 7 Max.Value N/A 8 < 5 2.5 Max.Pred Cw 26.6 ug/L 8 Max.Pred Cw N/A 8 Max.Pred Cw N/A 8 Max.Pred Cw N/A 8 Max.Pred Cw N/A 9 10.1 10.1 9 9 9 9 10 5.63 5.63 10 10 10 10 11 5.24 5.24 11 11 11 11 12 5.24 5.24 12 12 12 12 13 6.83 6.83 13 13 13 13 14 11.5 11.5 14 14 14 14 15 8.6 8.6 15 15 15 15 16 9.64 9.64 16 16 16 16 17 26.6 26.6 17 17 17 17 18 5.05 5.05 18 18 18 18 19 7.17 7.17 19 19 19 19 20 7.74 7.74 20 20 20 20 21 5.45 5.45 21 21 21 21 22 8.7 8.7 22 22 22 22 23 11.8 11.8 23 23 23 23 24 8.42 8.42 24 24 24 24 25 13.7 13.7 25 25 25 25 26 13.5 13.5 26 26 26 26 27 17.35 17.35 27 27 27 27 28 9.59 9.59 28 28 28 28 29 9.66 9.66 29 29 29 29 30 10.3 10.3 30 30 30 30 31 5.47 5.47 31 31 31 31 32 6.66 6.66 32 32 32 32 33 8.11 8.11 33 33 33 33 34 5.36 5.36 34 34 34 34 35 12.6 12.6 35 35 35 35 36 5.31 5.31 36 36 36 36 37 7.78 7.78 37 37 37 37 38 5.98 5.98 38 38 38 38 39 < 5 2.5 39 39 39 39 40 6.82 6.82 40 40 40 40 41 6.81 6.81 41 41 41 41 42 5.82 5.82 42 42 42 42 43 5.04 5.04 43 43 43 43 44 < 5 2.5 44 44 44 44 45 19 19 45 45 45 45 46 < 5 2.5 46 46 46 46 47 5.24 5.24 47 47 47 47 48 5.24 5.24 48 48 48 48 49 5.36 5.36 49 49 49 49 50 10.48 10.48 50 50 50 50 51 5.84 5.84 51 51 51 51 52 8.1 8.1 52 52 52 52 53 < 5 2.5 53 53 53 53 54 8.07 8.07 54 54 54 54 55 7.48 7.48 55 55 55 55 56 5.89 5.89 56 56 56 56 57 5.64 5.64 57 57 57 57 58 9.12 9.12 58 58 58 58 NC0039586_Worksheets_20210903(2),data -8- 9/14/2021 REASONABLE POTENTIAL ANALYSIS NC0039586_Worksheets_20210903(2),data -9- 9/14/2021 Shearon Harris Nuclear Plant Outfall 006 NC0039586 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 7.9 MGD MAXIMUM DATA POINTS = 58 Qw(MGD)= 7.9000 WWTP/WTP Class: II COMBINED HARDNESS(mg/L) 1Q1OS(cfs)= 0.00 IWC% @ 1Q1OS = 100 Acute=43.8 mg/L 7Q1OS(cfs)= 0.00 IWC% @ 7Q1OS= 100 Chronic=43.8 mg/L 7Q1OW(cfs)= 0.00 IWC%@ 7Q1OW= 100 30Q2(cfs)= 0.00 IWC%@ 30Q2= 100 Avg. Stream Flow,QA(cfs)= 0.00 IW%C @ QA= 100 Receiving Stream: Harris Reservoir Stream Class: WS-V PARAMETER NC STANDARDS OR EPA CRITERIA _1H REASONABLE POTENTIAL RESULTS RECOMMENDED ACTION TYPE Chronic Applied Acute a m 11 #Det. Max Pred Cw Allowable Cw Standard Acute(FW): 340.0 No limit Arsenic C 150 FW 340 ug/L 1 1 17.0 Chronic_ (F_ ____150.0_______________________________ W): C.V.(default) No value>Allowable_Cw_______________________________ Arsenic C 10 HH/WS ug/L Note: n<9 Chronic(HH): 10.0 Limited data set No value>Allowable Cw Acute: 65.00 no limit Beryllium NC 6.5 FW 65 ug/L 1 0 3.10 ___ _ _______ _______________________________ Note: n<9 C.V.(default) Chronic: 6.50 Limited data set NO DETECTS Max MDL= 1 Acute: 5.285 no limit Cadmium NC 0.9013 FW 5.2852 ug/L 1 0 0.310 ___ _ _______ _______________________________ Note: n<9 C.V.(default) Chronic: 0.901 Limited data set NO DETECTS Max MDL=0.1 Acute: NO WQS N/A Chlorides NC 230 FW mg/L 0 0 N/A --_Chr_onic:-----_230_.0------------------------------ Acute: NO WQS N/A Chlorinated Phenolic Compounds NC 1 A ug/L 0 0 N/A _ _ -- Chronic:-----1-0------------------------------ Acute: NO WQS No limit Total Phenolic Compounds NC 300 A ug/L 1 0 62.0 ___ _ _______ _______________________________ Note: n<9 C.V.(default) Chronic: 300.0 Limited data set NO DETECTS Max MDL=20 Acute: 1,432.7 No limit Chromium III NC 186.3593 FW 1432.6571 µg/L 0 0 N/A --_Chr_onic:-----_186_.4------------------------------ Acute: 16.0 No limit Chromium VI NC 11 FW 16 µg/L 0 0 N/A --_Chr_onic:------1 i.-0 11._0 ------------------------------ Tot Cr value(s)<5 and<Cr VI Allowable Cw Chromium,Total NC µg/L 1 1 9.6 Max reported value= 1.55 Note: n<9 C.V.(default) Limited data set NC0039586_Worksheets_20210903(2), rpa Page 10 of 22 9/14/2021 Shearon Harris Nuclear Plant Outfall 006 NC0039586 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 7.9 MGD Acute: 17.76 no limit(please see the fact sheet) Copper NC 12.7251 FW 17.7618 ug/L 58 58 63.50 ___ _ _______ _____ _ _ _ ___________________ Chronic: 12.73 of the WER study 39 value(s)>Allowable Cw Acute: 22.0 No limit Cyanide NC 5 FW 22 10 ug/L 1 0 31.0 ___ _ _______ _____ _ _ _ _ _ _______________ Note: n<9 C.V.(default) Chronic: 5.0 all values below detect Limited data set NO DETECTS Max MDL= 10 Acute: NO WQS No limit Fluoride NC 1800 FW ug/L 1 1 1,984.0 ___ _ _______ _ _____________________________ Note: n<9 C.V. (default) Chronic: 1,800.0 Limited data set No value>Allowable Cw Acute: 141.449 No limit Lead NC 5.5121 FW 141.4489 ug/L 1 0 3.100 ___ _ _______ _______________________________ Note: n<9 C.V.(default) Chronic: 5.512 Limited data set NO DETECTS Max MDL= 1 Acute: NO WQS No limit Mercury NC 12 FW 0.5 ng/L 1 0 155.0 ___ _ _______ _____ _ _ _ _ _ _______________ Note: n<9 C.V.(default) Chronic: 12.0 all values below detect Limited data set NO DETECTS Max MDL=50 Acute: NO WQS N/A Molybdenum NC 2000 HH ug/L 0 0 N/A --_ _ _---- _ _ ----------------------------- Chronic: 2,000.0 Acute(FW): 538.7 No limit Nickel NC 59.8327 FW 538.6977 µg/L _ _ _ ____ _______________________________ 2 1 19.0 Chronic(FW): 59.8 Note: n<9 C.V.(default) No_value>Allowab_le_Cw__ ________ ________________________________ Nickel NC 25.0000 WS µg/L Limited data set Chronic(WS): 25.0 No value>Allowable Cw Acute: 56.0 No limit Selenium NC 5 FW 56 ug/L 1 0 3.1 ___ _ _______ _______________________________ Note: n<9 C.V.(default) Chronic: 5.0 Limited data set NO DETECTS Max MDL= 1 Acute: 0.778 No limit Silver NC 0.06 FW 0.7776 ug/L 1 0 3.100 ___ _ _______ _____ _ _ _ _ _ _______________ Note: n<9 C.V.(default) Chronic: 0.060 all values below detect Limited data set NO DETECTS Max MDL= 1 Acute: 202.2 No limit Zinc NC 203.8158 FW 202.1621 ug/L 58 49 26.6 --_ _ _ _ _ -----203. ------------------------------ Chronic: 8 No value>Allowable Cw. Acute: 0 0 N/A _ _ _ Chronic: Acute: 0 0 N/A _ _ _ Chronic: Acute: NC0039586_Worksheets_20210903(2), rpa Page 11 of 22 9/14/2021 Shearon Harris Nuclear Plant Outfall 006 NC0039586 Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators Qw = 7.9 MGD 0 0 N/A _ _ _ Chronic: Acute: 0 0 N/A _ _ _ Chronic: NC0039586_Worksheets_20210903(2), rpa Page 12 of 22 9/14/2021 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(/0" 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)"1 Q10s(cfs)"automatically defaults to no acute dilution,acute IWC= 100% ,"IWC @ 1 Q10s"= 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)"1 Q10s(cfs)" is automatically calculated bases on entered "7Q10s(cfs)"flow 4)automatically calculates acute-based IWC%for the"IWC @ 1 Q10s"value used in acute WQS calculations(See"RPA"page) C.When paremeter's"Impaired?"check box is activated: 1)automtically activtes the "IMPAIRED" message alert on the"RPA"page for that parameter 2)does NOT make any automatic adjustements to WQS calculations NOTE: If new or expanding discharge and receiving stream impaired,will need to evaluate if additional waste load is allowed 10/30/2013 rdb 1)Amended "ERR" alert on data sets entreies to activate if"<"entered but no value entered,does not effect RPA calculation, ERR message only 2)Added new calculation feature to count nondetects when both"<"and a value are entered for each data set, used to calculate detected entries 3)Amended"Comments"drop down menu-per Juile 4)Turned the Chronic toxicity concentration message off on the RPA page-per Julie 2/10/14: ON "data"page changed highlighted area from blue shades to gray 5/2/14 rdb 1)Increased rounding factor on all calculated IWC%to 7 decimals 2)Increased display for all calkculated to 6 decimals places. 5/5/14 rdb Increased rounding factor on all calculated IWC%to 9 decimals 5/21/14 rdb Removed ROUND function from all IWC%calculations 7/31/14 rdb Moved RPA page tile blocks down one row so header text was separated 9/9/15: COMPLETED REVISIONS FOR METAL TRANSLATOR FEATURE 1)Added tabs for"HUC Hardness"(lookup table for HUC hardness values), "Hardness Equations"(summary of translator formulas, metals impacted,general info), "Dss to Total Hardness Calculator" (calcution sheet for metal translator, impacted chronic and acute wqs) 2)Revised"Input"page Table 1: -New user input for"8 Digit HUC Number"uisng drop down menu for lookup HUC Hardness, required entry, brown highlight -New display only for calculated"Effluent Hardness(Median)" including conditional method for info display, brown highlight -New display only for designed"HUC Hardness(Median)" incuding conditionla method for info display, brown highlight -New display only for calculated "Combined Hardness Chronic"for metal translator application, brown highlight -New display only for calculated"Combined Hardness Acute"for metal translator application, brown highlight -Assigned name for"HUC Number" 3)Revised"Input"pade Table 2: -Removed"Impaired?"column, conditional display, references -Added new column for"WQS"designation incuding assigning applicable WQS where fixed -Added new error message"CHECK WQS", conditonal control based on"WQS"entry for Cadmium, Chlorides, Molybdeum, Nickel -Revised text in error message -Added new brown highlight"Metal Translator Data Entry"label box -Removed Par01 "Arsenic"line -Revised Par02"Arsenic"line to reflect Human Health and Water Supply criterion, Chronic= 10 mg/L,Acute="N/A" -Revised Par04"Cadmium"line: a)"WQS" input with drop down menu to select applicable criterion b)"Chronic"and"Acute" inputs to display calculated metal translator values including conditional method for info display based on"WQS"selection, no rounding c)"Modifier" input display only based on"WQS"selection including conditional method for info dispaly d)Conditonal controls to activate error nessages, brown highlight -Revised Par05"Chloride(AL)"line: a)"WQS" input with drop down menu to select applicable criterion b)"Chronic"display only for applicable value including conditional method for info display based on"WQS"selection c)"Modifier" input display only based on"WQS"selection including conditional method for info dispaly d)"Name"display only based on"WQS"selection including conditional metdod fro info display e)Conditonal controls to activate error nessages -Revised"Chromium,Total"line: a)Removed Par08 label b)"Chronic"and"Acute" inputs to display calculated metal translator values, no rounding c)brown highlight -Added new"Chromium III"line: a)Assigned applicable text in"WQS", "Type", Modifier", Units" b)"Chronic"and"Acute" inputs to display calculated metal translator values, no rounding c)brown highlight -Added new Par08"Chromium VI"line: a)Assigned Par08 label,applicable text in"WQS", "Type", Modifier", Units" b)"Chronic"and"Acute" inputs to display calculated metal translator values, no rounding c)brown highlight -Revised Par09"Copper(AL)"line: a)"Chronic"and"Acute" inputs to display calculated metal translator values, no rounding b)brown highlight -Revisd Par12"Lead"line: a)"Chronic"and"Acute" inputs to display calculated metal translator values, no rounding b)brown highlight -Revised Par14"Molybdenum"lime: a)"WQS" input with drop down menu to select applicable criterion b)"Chronic"display only for applicable value including conditional method for info display based on"WQS"selection c)"Modifier" input display only based on"WQS"selection including conditional method for info dispaly d)Conditonal controls to activate error nessages -Revised Par15"Nickel"line: a)"WQS" input with drop down menu to select applicable criterion b)"Chronic"and"Acute" inputs to display calculated metal translator values including conditional method for info display based on"WQS"selection, no rounding c)"Modifier" input display only based on"WQS"selection including conditional method for info dispaly d)Conditonal controls to activate error nessages, brown highlight -Revised Par17"Silver(AL)"line: a)"Chronic"and"Acute" inputs to display calculated metal translator values, no rounding b)brown highlight -Revised Par18"Zinc(AL)"line: a)"Chronic"and"Acute" inputs to display calculated metal translator values, no rounding b)brown highlight 3)Revised"Data"page: -Revised Par01 "Arsenic"entry,text, and calculations("1")-all effluent hardness data to be entered in this section for used to calculate eflluent hardness factors a)Reference to Par01 "Arsenic"removed b)New label"Effluent Hardness(monthly average)"added c)"Mult Factor="and"Max. Pred Cw"removed,text and calcuation d)"10%value"and"Median value"added,text and calculation including conditional method for info display e)Assigned name"Effluent_Median"and"effluent_10"to calculated values f)PQL condition removed from calculation method for data displayed 4)Revised"RPA"page: -Removed all features assocaited with"Impairment" -Added new display only for calculated"COMBINED HARDNESS(mg/L)", Chonic and Acute, conditional method for info display -Revised"Receiving Stream"display to include selected HUC Number in text -Removed unused display features for WET% (previouly hidden) -Revised"Arsenic" lines: a)Par01 "Arsenic" line removed b)Par02"Arsenic"references used for display to calculate"Acute"and Chronic" allowable Cw -Revised"Cadmium", "Chromium VI", "Copper(AL)", "Lead", "Nickel", "Silver(AL)", "Zinc(AL)"!lines: a)"NC WQS/Chronic"and 1/2 FAV/Acute"conditional method revised for info display, no rounding b)"Allowable Cw"Acute"and"Chronic"conditional metfhod revised fro info display inculding rounding value 5)Revised"Dss to Total Metal Hardness Calculator"page -Assigned names for: a)"CdMAE_AC"-Cadmium calculated metal translator Acute value b)"CdMAE_CH"-Cadmium calculated metal translator Chronic value c)"CuMAE_AC"-Copper calculatd metal translator Acute value d)"CuMAE_CH"-Copper calculated metal translator Chronic value e)"Cr_Total_AC"-Total Chromium calculated meat)translator Acute value f)"Cr_Total_CH"-Total Chromium calculated metal translator Chronic value g)"CrIIIMAE_AC"-Chromium III calculated metal translator Acute value. h)"CrIIIMAE_CH"-Chromium III calculated metal tramslator Chronic value i)"CrVIMAE_AC"-Chromium VI calculated metal translator Acute value j)"CrVINAE_CH"-Chromium VI calculatd metal translator Chronic value k)"PbMAE_AC"-Lead calculated metal translator Acute value m)"PbMAE_CH"-Lead calculated metal translator Chronic value n)"NiMAE_AC"-Nickel calculated metal translator Acute value o)"NiMAE_CH"-Nickel calculated metal translator Chroniv value p)"AuMAE_AC"-Silver calculated metal translator Acute value q)"AuMAE_CH"-Silver calculated metal translator Chronic value r)"ZnMAE-AC"-Zinc calculated metal translator Acute value s)"ZnMAE_CH"-Zinc calculated metal translator Chronic value t)"tss"-assigned TSS harness factor u)"CHA"-calculated combined acute hardness value v)"CHC"-calculated combined chronic hardness value -Added conditional methods to formulas for info display and to incorporate names, no rounding 6)Set up passwortd to protect all pages'rpa2015' 1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION 1)Inserted"Aresenic,Aquatic Life, C, 50, FW, N/A, ig/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 Niche!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 Table1. Revised narrative in Model narrative box with new instructions, new messages to alert user on actions needed and/or completed to correctly enter Model 7Q10s(cfs)in Table 1. Remove conditions and features assocaited with entry of Model Acute IWC% . 8/30/16: Revised conditional note statement on RPA tab for Total Chromium to correct program error. 10/20/16: Revised label display for Fcailty discripition on"Diss to Total Metal Calculator".sheet to list Outfall#. 9/7/2017 Revised chromium drop down to reflect new<5ug/L PQL. 11/21/17: (1)Revised RPA evaluation to assign C.V. (default)=0.6 when only a sinlgle data entry inade for any parameter(see data page). On data page the parameter will diplay Std..Dev. ="N/A" when only a single data entry made. (2)Revised RPA evaluation to always calculate and display"Max Pred Cw"value whenever there are 1 to 58 data numerical entties made(see data and rpa pages). (3)Revised rpa page to show each parameters automatic display message"NO DETECTS" independent from"Max Pred Cw"display (4)Revised Total Chromium <50 data counter to start count when the entered data point<4.9999. (hidden column of data page). Revised Total Chromium automatic diplay message on rpa page to reflect new 5 1.1g/I criteria. 11/29/17: (1)Revised RPA page C.V. (default? Message to (2)Corrected DATA page H2 message to show ... UPSTREAM... (3)Removed (1)from RPA page Type label 11/30/17: Revised Dissolved Metals and Total Metals Table label descriptions on"DSS to Total Metal Calculator"tab so as not to conflict with exsiting descriptions in RPA 12/12/17: Revised conditional statements DATA tab to allow appllication C.V. (default)for number of data values 1 to 9 even if no deviation in data set. 1/20/18: 1)Revised"RPA" Receiving Stream display to only show the Stream name and if entered the HUC number 2)Increased RPA page Qw display decimal places Date:9/14/2021 Dissolved to Total Metal Calculator FACILITY:Shearon Harris Nuclear Plant Outfall 006 NPDES PERMIT:NC0039586 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 1Q10 Flow Limit Solids Hardness Hardness Wastewater Wastewater Hardness Hardness summer summer 7Q10 -Fixed Value- chronic Acute Concentration Concentration Average 7Q10(CFS) (MGD) (mg/L) (mg/L) (mg/L) (Chronic) (Acute) Average(mg/L) (mg/L) This calculator has been inserted into the RPA to calculate [MGD] [MGD] Total Metal allowable allocations once Table 1 has been o.0000 0.0000 0.0000 7.9000 II:M I 43.800 II 43.800 II 100.0000 I 100.0000 25 43.8 completed(Input Sheet)and Effluent hardness has been Upstream Hard Avg(mg/L)= 25 ACAH 43.8 entered(Data Sheet). EFF Hard Avg(mg/L)= 43.8 ACCH 43.8 1) Following the spreadsheet from left to right. Dissolved Metals Criteria US EPA Total Metal Criteria Total Metal= COMMENTS(identify parameters to PERCS Branch to maintain in facility's LTMP/STMP): First the allowable allocations for the dissolved metals after applying hardness Translators-using Dissolved Metal Translator PARAMETER equation Default Partition will appear for all the metals listed once Table 1 is Chronic Acute Coefficients Chronic Acute complete and effluent hardness entered.Use a default fuq/11 fug/11 (streams) [ug/Il fug/Il Cadmium(d) 0.23 1.33 0.252 0.90 5.29 value of 25 mg/L if no hardness data is available. Cd-Trout streams 0.23 0.83 0.252 0.90 3.29 Second,the Dissolved Metal allocations are divided by Chromium III(d)(h) 38 290 0.202 186.36 1432.66 the Translators to determine the Total Metals that can be Chromium VI(d) 11 16 1.000 11.00 16.00 allocated to the Permittee.These Total Metals values are Chromium,Total(t) N/A N/A automatically inserted into Table 2 and are the allowable Copper(d)(h) 4.4 6.2 0.348 12.73 17.76 Total Metal allocations determined for the Permittee Lead(d)(h) 1.01 26 0.184 5.51 141.45 Nickel(d)(h) 26 233 0.432 59.83 538.70 prior to allowing for dilution.See Input sheet Table 2.The Ni-WS streams(t) 25 N/A final acute and chronic values shown under the RPA sheet Silver(d)(h,acute) 0.06 0.78 1.000 0.06 0.78 are the Total Metal values listed in Table 2 divided by the Zinc(d)(h) 59 58 0.288 203.82 202.16 acute and chronic IWC,respectively. 2) The Translators used in the freshwater RPA are the Beryllium 6.5 65 1.000 6.5 65 Arsenic(d) 150 340 1.000 150 340 Partition Coefficients published by US EPA in 1984.They are TSS dependent equations and can be found listed (d)=dissolved metal standard.See 15A NCAC 02B.0211 for more information. with the WQS hardness dependent equations under the (h)=hardness-dependent dissolved metal standard.See 15A NCAC 02B.0211 for more information. sheet labeled Equations.A fixed TSS value of 10 mg/L is (t)=based upon measurement of total recoveable metal.See 15A NCAC 02B.0211 for more information. used to calculate the Translator values. The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard. The Human Health standard for Arsenic is 10 µg/L which is Total Recoverable metal standard. 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. 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 ma/L,expressed as CaCO,or Ca+Ma,as the default Hardness OR To determine a Hardness value for permit limit development,use the following equation: Hardness = (Hardness instream(a)mg/L*7Q10,MGD)+(Hardness effluent(b)mg/L.Plant flow,MGD) (mass as6!r ) (7010,MGD+Plant flow,MGD) fa) Use the median instream Hardness value of the ambient 8-digit HUC data collected by the Division of Water Quality.To find the 8-digit HUC hardness value for your facility,Click Here. (b) For the purpose of this estimation,use the facility's median effluent Hardness value,if available.The Division will request the permittee to sample effluent hardness once/month and submit one to two years of data with the permit renewal application.If no effluent hardness data is submitted,a default of 25 mg/L will be applied. II.To Develop Dissolved Metal concentrations for permitting purposes use the Freshwater Standards for Hardness Dependent Metals listed in Table A below. Table A:Dissolved Freshwater Standards for Hardness Dependent Metals Metal pg/L Cadmium,Acute {1.136672-[In hardness](0.041838)}•e^{0.9151[In hardness]-3.1485} Cadmium,Acute(Trout Waters) {1.136672-[In hardness](0.041838)}•e^{0.9151[In hardness]-3.6236} Cadmium,Chronic {1.101672-[In hardness](0.041838)}•e^{0.7998[In hardness]-4.4451} Chromium 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-[ln hardness](0.145712)}•e^{1.273[In hardness]-1.460} Lead,Chronic {1.46203-[ln 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)* Kpo and a are constants that express the equilibrium relationship between dissolved and adsorbed forms of metals. A default value of 10 mg/L Total Suspended Solids(TSS)will be used. Table A contains the Default Partition Coefficients for the equation. Table B contains the calculated translators using the default partition coefficients for streams. TABLE A.Default Partition Coefficients STREAMS Metal(1) Kpo 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) Example for Cadniun(streams) (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 Given: TABLE B.US EPA Translators TSS=10 mg/L US EPA Translators Kpo=4.00E+06 a=-1.1307 PARAMETER Using stream Default Partition Coefficients Traislator = 1 TSS=10i g/L [1+(Kpo*TSS ir+N*10b)] Cadmium 0.252 1 Chromium III 0.202 [1+(4.00x10 *10b)] Chromium VI 1 Chromium,Total N/A = 1 Copper 0.348 [1+2.960465] Lead 0.184 =0.252 Nickel 0.432 Silver 1 Zinc 0.288