Loading...
HomeMy WebLinkAboutNC0046728_Pretreatment Annual Report_20161209Pretreatment Annual Report FEB 112017 water Quality PAR � 2016 Permitting Section Town of Mooresville Pretreatment Program Info Database for Program Name Mooresville WWTP Name Rocky River Program Approval Date 09/30/1983 Pretreatment Status Full Region MRO County Iredell NPDES Number RECEIVEDINCDEQIMUR FEB '21 2017 WaterQuality � fitting Section printed on: 12/9/ZO� IWC % at 7Q10 95.87 7Q 0 ow cfs / mgd 0.5 / 0.32 1Q10 Flow cfs / mgd 0.42 / 0.27 Stream Classification C Basin Number YAD11 Receiving Stream Name DYE CREEK 114C0046728 NPDES Effective Date 04/01/2014 Last PAR Rec 02/29/2016 PAR Due Date 03/01/2017 mercury 1631 NPDES Expire Date 11/30/2016 Current Fiscal 03/01/2016 Year PCI Done required es POTW is Primary WWTP TRUE Last Audit on 04/19/2012 Audit Year Next 13/14 Mr. Erskine Smith Design Flow mgd 7.5000 % Design mgd is SiU permitted F 1660 1 Permitted 311.1 flow (mgd) [Pt_SIU) 1.2 WWTP SI U's ®program StUs HWA LTMP- C 8110 IW3 ERP )1 WWTP CIU's Program CIUs IMBox 878 pal15 date Inactive Date Next Due 11/01/2018 03/30/2017 Date Received by DWR 11/05/2013 06/30/2016 03/16/2012 01/02/2013 ' 02/11/2011 Date Approved 01/14/2014 09/20/2016 04/23/2012 01/10/2013 —_ j 03/2912011 Adopt Date Required Date Adopted Info in this Box from PI Contacts Date Data Date pT Pro Attended Attended Attended Formal Name a.Prime Phonal ext Fax HWA WksD IUP Wksn PAR Wkan Mr. Eric Brackett 04-662-3051; 1 04-663-4293 11 3/24/2013 1 6!16!2011 1/31/2013 ebrackett@cl.mooresville.ne.us Environmental Compliance. Officer JRO.Box878 8115 Mr. Erskine Smith 704) 662-3186 704),662-5449 Town Manager IMBox 878 pal15 Mr. Jamie Levis 10rim ,04-662$341 I 1 11 111012412013116116/2011 1113112013 Jlevis@cl.mooresville.nc.us Environmental Compliance' 1PO Box 878 8115 Ms, Whitney Monroe 1 lk04.663-2460 04-662-8473 W3709 wmunroe@ci.mooresviile.nc:us Laboratory Technician PO Box 878 28115. DWR Central Office Contact JMontl Hassan DWR Regional Contact es Bell NCP Number histMdRE'PORT Mooresville • 20D9 2010 2011 2012 2013 2014 2016 list half I 2nd half 1st half I 2nd half 1st half I 2nd half 1st half l 2nd half 1st half 2nd half 1st half 2nd half 1st half l 2nd half Carolina Beverage Group, LLC PreviousNames: Carolina Beer & Beverage, LLC IUP # 0017 Pipe # 01 SIU Word Demiptiore IUP—Status: Active food, Brewing and Bottling Cyanide I I I I I XI I Zinc XIX I I An W in a semi-annual period Indicates snc for the period for the respective parameter. PRINTED ON: 1216/2016 This information is compiled from many sources, and has not been verified. PAGE 51 Contact the local pretreatment coordinator or state pretreatment staff if errors are noted. ANNUAL PRETREATMENT PROGRAM REPORT POTW NAME: Town of Mooresville REPORT DATE: March 1St, 2017 Period covered by this report: January 1, 2016 to December 31, 2016 Period covered by previous report: January 1, 2015 to December 31, 2015 Name of wastewater treatment plant (s) Rocky River WWTP NPDES Permit # NCO046728 --------------------------------------------------- -------------------------------- Person to contact concerning information contained in this report: Name: Jamie Levis Title: Environmental Compliance Supervisor Mailing Address : PO Box 878 Mooresville, NC 28115 (Att. WWTP) Telephone # (704) 662-8341 I have personally examined and am familiar with the information submitted in this document and attachments. Based upon my inquiry of those individuals immediately responsible for obtaining the information reported herein, I believe that the submitted information is true, accurate and complete. I am aware that there are significant penalties for submitting false information. l o2--16--2-0-17 - ---------7 Z� ------------------ --- Date Signature of Official Environmental Compliance Supervisor Title Town of Mooresville Rocky River WWTP (NPDES # NC0046728) PAR Narrative for 2016 GENERAL INFORMATION: GENERAL PROGRAM INFORMATION: • AT, LTMP, ERP, and HWA are up to date. • HWA and AT were received 11/5/2013 and approved 1/14/2014 by DWQ. • SUO Draft approved by PERCS 1/10/2013 • IWS was submitted March 2012 and approved April 2012 by DWQ, next due date 3/30/2017. We are close to finishing this as well. • A copy of our Pretreatment Program Info Database sheet is enclosed. • Note: Pretreatment staff as of 12/31/16. Environmental Compliance Supervisor (Jamie Levis) Environmental Compliance Officer (Eric Brackett) FOG Compliance Officer (Jeff Campbell) FOG Compliance Officer (Keaton Long) Environmental Analyst (Whitney Munroe) Environmental Analyst (Justin Vanderford) SIU INFORMATION: 1) BestCo, Inc. (IUP # 0006, Cough Drop Manufacturer) SNC INFORMATION: • SIU was not in SNC this 2016 PAR Year. ORDERS AND SCHEDULE INFORMATION: None A to C and CONSTRUCTION INFORMATION: None OTHER MISC. INFORMATION: Pretreatment Staff modified BestCo permit raising daily max. TSS to 900 lbs/day from 505 lbs/day and 6/mo. average to 500 lbs/day from 300 lbs/day. This modification was for a product change. This was approved by PERCS on December 19, 2016 N.O.V.s issued during 2016 year: 11 1/6/2016 — Cyanide ($500) 1/13/2016 — TSS ($500) 1/20/2016 — TSS ($750) 1/27/2016 — TSS ($1,000) 3/1/2016 — BOD ($750) 5/4/2016 — TSS ($1,250) 7/6/2016 — Copper ($0) 9/8/2016 — TSS ($1,500) 10/5/2016 —TSS ($1,750) 10/12/2016 — TSS ($2,000) 10/21/2016 — BOD ($1,000) TOTAL: ($11,000) ALL N.O.V.'s RESOLVED SIU INFORMATION: 2) Carolina Beverage Group, LLC (IUP # 0017, Energy Drink Blender and Bottler) SNC INFORMATION: • SIU was not in SNC for 2016 PAR Year. ORDERS AND SCHEDULE INFORMATION: NONE A to C and CONSTRUCTION INFORMATION: NONE OTHER MISC. INFORMATION: • 2012 CBG increased production and expanded their facility. Nothing new in Mooresville facility for 2016. CBG opened new facility in Ft. Worth, TX and has 1 production line running now. • Pretreatment staff modified CBG permit to alleviate NOV's for Flow approved August 7, 2015 by PERCS. N.O.V.s issued during 2015 year: 7 1/7/2016 — BOD ($500) 2/10/2016 — pH ($500) 5/26/2016 — BOD ($750) 6/12/2016 — Flow ($500) 6/13/2016 — Flow Daily Max. ($1,000) 6/14/2016 — Flow Daily Max. ($1,500) 11/3/2016 — BOD (1,500) TOTAL: $6,250.00 ALL N.O.V.'s RESOLVED SIU INFORMATION: 3) Niagara Bottling, LLC. (IUP # 0018, Bottle Water Manufacturer) SNC INFORMATION: NONE Production started in May, 2012 Carbonated Flavor Water in 2014 Permit Renewal January 1, 2017 thru December 31, 2021 N.O.V.s issued during 2016 year: 10 1/2/2016 — pH Excursion Self Monitor ($0) 1/5/2016 —pH <5.0 Self Monitor ($500) 1/28/2016 —PH <5.0 Self Monitor ($750) 2/23/2016 — pH <5.0 Self Monitor ($1,250) 5/23/2016 — pH <5.0 Self Monitor (1,500) 9/9/2016 — pH <5.0 Self Monitor (1,750) 11/17/2016 pH <5.0 Self Monitor ($2,000) Failure to Monitor Yd Quarter — 2016 ($300) 11/29/2016 — pH <5.0 Self Monitor ($2,250) 12/20/2016 — pH <5.0 Self Monitor ($2,500) TOTAL: $12,800 ALL N.O.V.'s RESOLVED pH Violations are caused by no alkalinity in their water due to R/O. Process effluent from the water lines doesn't go thru pretreatment system. Therefore, if anything is spilled goes straight thru the flume. These pH violations usually only last around 10 to 20 minutes. They have a long run from their line until it mixes with our line. We have not seen any effects from these occurrences also believe when it mixes with other flows it takes on that characteristic. Niagara also added a way to get the flow from steaming the carbon towers to a sump and pumping it thru the pretreatment system. Therefore, this should help resolve some of these pH violations. BestCo Surcharge 2016 Month Customer # Invoice # Munis # Invoice Date Paid Date Amount Sent Date Paid Date Amount Paid Comments January 100192 BS 01-16 32827 2/24/2016 $ 61,591.77 2/24/2016 9/6/2016 $ 61,591.77 ck# 68070 February 100192 BS 02-16 32971 3/22/2016 $ 18,614.18 3/22/2016 3/23/2016 $ 18,614.18 ck# 38963 March 100192 BS 03-16 33137 4/25/2016 $ 17,428.49 4/25/2016 5/9/2016 $ 17,428.49 ck# 39603 April 100192 BS O4-16 33289 5/20/2016 $ 18,061.50 5/20/2016 5/26/2016 $ 18,061.50 ck# 40137 (Surcharge & NOV) May 100192 BS 05-16 33466 6/21/2016 $ 13,479.64 6/21/2016 6/28/2016 $ 13,479.64 ck# 40699 June 100192 BS 06-16 33676 7/28/2016 $ 7,490.97 7/28/2016 8/17/2016 $ 7,490.97 ck# 41531 July 100192 BS 07-16 33826 8/25/2016 $ 12,353.09 8/25/2016 9/6/2016 $ 12,353.09 ck# 42085 August 100192 BS 08-16 33996 9/21/2016 $ 19,483.27 9/21/2016 9/26/2016 $ 19,483.27 ck# 42486 September 100192 BS 09-16 34138 10/19/2016 $ 19,480.47 10/19/2016 10/27/2016 $ 19,480.47 ck# 42996 October 100192 BS 10-16 34272 11/16/2016 $ 16,552.48 11/16/2016 11/21/2016 $ 16,552.48 ck# 43495 November 100192 BS 11-16 34414 12/21/2016 $ 11,039.03 12/21/2016 1/13/2017 1 $ 11,039.03 ck# 44335 December 1 100192 1 BS 12-16 1 34494 1/13/2017 $ 20,076.15 1/13/2017 1/25/2017 1 $ 20,076.15 jck# 44564 $ 235,651.04 $ 235,651.04 BC Fees Customer # Invoice # Munis # Invoice Date Amount Sent Date Paid Date Amount Paid Comments Lab Fees 100192 JPOTW Sampling Event () Lab Fees 100192 1 POTW Sampling Event () BC Fines Customer # Invoice # Munis # Invoice Date Amount CK # Paid Date Amount Paid Comments Total 100192 32828 2/24/2016 $500.00 38367 3/4/2016 $ 500.00 BOD 1/6/16 1 100192 32829 2/24/2016 $500.00 38367 3/4/2016 $ 500.00 TSS1/13/16 1 100192 32829 2/24/2016 $750.00 38367 3/4/2016 $ 750.00 TSS 1/20/16 1 100192 32829 2/24/2016 $1,000.00 38367 3/4/2016 $ 1,000.00 TSS 1/27/16 1 100192 33138 4/25/2016 $750.00 39603 5/9/2016 $ 750.00 BOD 3/1/16 1 100192 33290 5/20/2016 $1,250.00 40137 5/26/2016 $ 1,250.00 TSS 5/4/16 1 100192 $0.00 $ - Copper 7/6/16 1 100192 34142 10/19/2019 $1,500.00 42996 10/27/2016 $ 1,500.00 TSS 9/8/16 1 100192 34273 11/2/2016 $3,750.00 43495 11/16/2016 $ 3,750.00 TSS 10/5,10/12 2 100192 34495 1/13/2017 $1,000.00 44564 1/25/2017 $ 1,000.00 BOD 12/21/16 1 $ 11,000.00 $ 11,000.00 CBG Surcharge 2016 Month Customer # Invoice # Munis # Invoice Date Amount Sent Date Paid Date Amount Paid Comments January 100173 CBG 01-16 32825 2/24/2016 $ 93,226.80 2/24/2016 2/29/2016 $ 93,226.80 ck# 64628 February 100173 CBG 02-16 32967 3/22/2016 $ 48,424.72 3/22/2016 3/29/2016 $ 48,424.72 ck# 65503 March 100173 CBG 03-16 33136 4/25/2016 $ 55,612.72 4/25/2016 5/2/2016 $ 55,612.72 ck# 66037 April 100173 CBG 04-16 33288 5/20/2016 $ 30,873.90 5/20/2016 5/31/2016 $ 30,873.90 ck# 66513 May 100173 CBG 05-16 33464 6/21/2016 $ ° 77,666.06 6/21/2016 6/27/2016 1 $ 77,666.06 ck# 66987 June 100173 CBG 06-16 33677 7/28/2016 $ 50,370.10 7/28/2016 8/5/2016 $ 50,370.10 ck# 67600 July 100173 CBG 07-16 33827 8/25/2016 $ 58,799.11 8/25/2016 9/6/2016 $ 58,799.11 ck# 68070 August 100173 CBG 08-16 33997 9/21/2016 $' ° 31,933.54 9/21/2016 10/3/2016 $ 31,933.54 ck# 68503 September 100173 CBG 09-16 34139 10/19/2016 $ 59,618.85 9/21/2016 10/31/2016 $ 59,618.85 ck# 68873 October 100173 CBG 10-16 34274 11/16/2016 $ 48,354.58 11/16/2016 11/28/2016 $ 48,354.58 ck# 69336 November 100173 CBG 11-16 34415 12/21/2016 $ 67,617.84, 12/21/2016 1/5/2017 $ 67,617.84 ck# 69837 December 100173 CBG 12-16 34496 1/13/2017 $ 22,739.07 1/13/2017 1/23/2017 1 $ 22,739.07 ck# 70184 I $ 645,237.29 I $ 645,237.29 CBG Fees Customer # Invoice # Munis # Invoice Date Amount Sent Date Paid Date I Amount Paid I Comments Lab Fees 100173 JPOTW Sampling () Lab Fees 1 100173 JPOTW Sampling () CBG Fines Customer # NOV Date Munis # Invoice Date Amount Paid Date CK # Amount Paid Comments Total NOV 100173 1/7/2016 32826 2/24/2016 $ 500.00 2/29/2016 65055 $ 500.00 CBG BOD NOV (1/7/16) 1 NOV 100173 2/10/2016 32969 3/22/2016 $ 500.00 3/29/2016 65503 $ 500.00 CBG pH NOV (2/10/16) 1 NOV 100173 5/26/2016 33470 6/21/2016 $ 750.00 7/5/2016 67032 $ 750.00 CBG BOD NOV (5/26/16) 1 NOV 100173 6/12/2016 33465 6/21/2016 $ 500.00 7/5/2016 67032 $ 500.00 CBG Flow NOV (6/12/16) 1 NOV 100173 6/13/2016 33465 6/21/2016 $ 1,000.00 7/5/2016 67032 $ 1,000.00 ICBG Flow NOV (6/13/16) 1 NOV 100173 6/14/2016 33465 6/21/2016 $ 1,500.00 7/5/2016 67032 $ 1,500.00 1 CBG Flow NOV (6/14/16) 1 NOV 100173 11/3/2016 34456 1/3/2017 $ 1,500.00 1/9/2017 69940 1 $ 1,500.00 JCBG BOD NOV (11/3/16) 1 NOV 100173 5,250.00 $ 6,250.00 Niagara 2016 Month Customer # Invoice # Munis # Invoice Date Amount Sent Date Paid Date Amount Paid Comments January 108642 NB - February 108642 March 108642 April 108642 May 108642 June 108642 July 108642 August 108642 September 108642 October 108642 November 108642 December 1 108642 Fees ce # Munis # I Invoice Date 788 33188 5/4/20116- 805 34182 10/25/2016 17591 34299 11/21/2016 mount Sent Date 467.43 5/4/2016 297.43 10/27/2016 500.00 11/21/2016 1,264.86 Paid Date Amount Paid I Comments 11/17/2016 $ 467.43 IPOTW Sampling Event (4/6/16) 12/14/2016 $ 297.43 1 POTW Sampling Event (10/5/16 1/13/2017 $ 500.00 jPermit 1/1/2017 thru 12/31/2021 $ 1,264.86 Niagara Fines Customer # Check # Munis # Invoice Date Amount Sent Date Paid Date Amount Paid Comments Total 108642 NOV pH Excursion 1/2/16 ($0) 1 108642 180751 32970 3/22/2016 $500.00 3/22/2016 4/11/2016 $ 500.00 NOV pH <5.0 1/5/16 ($500) 1 108642 180751 32970 3/22/2016 $750.00 3/22/2016 4/11/2016 $ 750.00 NOV pH <5.0 1/28/16 ($750) 1 108642 180751 32980 3/22/2016 $1,250.00 3/22/2016 4/11/2016 $ 1,250.00 NOV pH <5.0 2/23/16 ($1,250) 1 108642 181670 33471 6/21/2016 $1,500.00 6/21/2016 7/13/2016 $ 1,500.00 NOV pH <5.0 5/23/16 ($1,500) 1 108642 182667 34000 9/21/2016 $1,750.00 9/21/2016 9/9/2016 $ 1,750.00 NOV pH <5.0 9/9/16 ($1,750) 1 108642 183882 34297 11/21/2016 $2,000.00 11/21/2016 2/9/2017 $ 2,000.00 NOV pH <5.0 11/7/16 ($2,000) 1 108642 183882 34298 11/21/2016 $300.00 11/21/2016 2/9/2017 $ 300.00 Failure to Monitor 3rd Quarter -2016 1 108642 183882 34360 12/8/2016 $2,250.00 12/8/2016 2/9/2017 $ 2,250.00 NOV pH <5.0 11/29/16 ($2,250) 1 108642 183882 34418 12/21/2016 $2,500.00 12/21/2016 1 2/9/2017 $ 2,500.00 NOV pH <5.0 12/20/16 ($2,500) 1 $ 12,800.00 $ 12,800.00 BestCo 2016 2016 Max Average January 0.16871 0.11524 February 0.14935 0.12625 March 0.15984 0.11537 April 0.24459 0.11816 May 0.11717 0.09159 June 0.14130 0.11195 1st 6 mo. 0.24459 0.11309 July 0.14233 0.12001 August 0.14742 0.13043 September 0.15083 0.11492 October 0.13037 0.08842 November 0.12372 0.07028 December 1 0.17704 0.07664 2nd 6 mo. 10.17704 0.1001, 2 Carolina Beverage 2016 Max Avera e January 0.54780 0.39259 February 0.71510 0.46913 March 0.66290 0.47576 April 0.69350 0.47980 May 0.74240 0.51644 June 0.92760 0.78071 1st 6 mo. 0.92760 0.51907 July 0.99100 0.83443 August 0.96628 0.67296 September 0.73300 0.52717 October 0.48400 0.41577 November 0.67050 1 0.46534 December 0.62520 0.34779 2nd 6 mo. 0.99100 0.54391 mgd mgd mgd mgd Nia ara Bottling 2016 Max Average January 0.184 0.11128 February 0.187 0.14610 March 0.217 0.16100 April 0.235 0.18357 May 0.250 0.20023 June 0.281 0.21363 1st 6 mo. 0.281 x0.16930 July 0.312 0.24653 August 0.301 0.23533 September 0.302 0.22093 October 0.314 0.19322 November 0.249 0.16543 December 0.272 0.17040 2nd 6 mo. 0.314 0.204,31 mgd mgd Chapter 9, PAR Guidance Pretreatment Performance Summary (PPS) 1. Pretreatment Town Name: Town of Mooresville 2. 'Primary" NPDES Number or Non Discharge Permit # if applicable => NCO046728 3. Notes: PAR begin Date, please enter 01/01/yy or 07/01/yy 3. =>_ 4. PAR end Date, please enter 06/30/yy or 12/31/yy 4. =>_ 5. Total number of SIUs, includes CAJs 5. => 6. Number of CIUs 6. =>- 7. Enter the Higher Number, either (7a) or (7b) here => 7a. Number of SIUs not sampled by POTW 7a. => 7b. Number of SIUs not inspected by POTW 7b. _> 8. Number of SIUs with no IUP, or with an expired IUP 8. => 9. Total Number of SIUs in SNC due to either IU Reporting violations or IUP Limit violations. To avoid double counting some SIUs Enter ( 9a + 9b) - 9c here => Enter the Number of SIUs in SNC for: 9a. IU Reporting violations 9a. => 9b. IUP Limit violations 9b. => 9c. Both IU Reporting & Limit violations 9c. => 10. Number of SIUs in SNC due to IU Reporting violations that were not sampled or inspected by POTW 10.- 0._>11. 11. Number of SIUs in SNC due to violation of 11. => Compliance Schedule due dates 12. Number NOVs, NNCs, AOs, or similar assesed to SIUs 12.- 2._>13. 13. Number Civil or Criminal Penalties assessed to SIUs 13. => 14. Number of SIUs included in public notice 14. => 15. Number of SIUs from which penalties collected 15. => 16. Total Amount of Civil Penalties Collected 16. => $ 30,050.00 17. Total Number of SIUs on a compliance schedule 17.-- 7._> Notes: AO Administrative Order CN Categorical Industrial User CO Consent Order IUP Industrial User Pretreatment Permit NNC Notice of Non -Compliance 1/1/2016 12/31/2016 3 0 0 0 0 0 0 0 0 0 0 0 28 26 0 3 0 NOV Notice of Violation PAR Pretreatment Annual Report POTW Public Operated Treatment Works SN Significant Industrial User SNC Sianificant Nan -Compliance, fora RNC This Column for office use only EPA WENDB codes PSSD PSED SNS CNS NOIN NOCM PSNC MSNC SNPS SNIN SSNC PENF JUDI SVPU NPN SOCS Pretreatment Annual Report (PAR) Significant Non -Compliance Report (SNCR) WWTP = Wastewater Treatment Plant, use separate form for each WWTP. SIU = Significant Industrial User SNC = Significant Non -Compliance PAR covers this calendar year => 1/1/16 TO 12/31/16 Control Authority=Program=Town Name => Town of Mooresville WWTP Name => Rocky River WWTP NPDES # _> NCO046728 A SNCR Form must be submitted with every PAR, please write "None " if you had No SIUs in SNC during calendar year IUP # Pipe # Industry Name Parameter or "Reporting" SNC ? ( Yes / No) for each 6 -month period. Jan. - June July - Dec. 0006 001 BestCo NONE NONE NONE 0017 001 Carolina Beverage Group NONE NONE NONE 0018 001 Niagara Bottling NONE NONE NONE Attach a copy of the Division's "SIUs in SNC Historical Report" for your POTW's SIUs behind this page. Is the database correct ? Notify the Division of any errors ! Database indicates SNC history for previous years. EVERY SNC MUST be explained in the Narrative, How was, is, or will it be resolved? REPEAT SNCs are serious matters that MUST be explained in the Narrative. Form name: PAR,SNCR,2001 Date Revised: 1/4/2001 Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each industry/pipe Enter BDL values as < (value) Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations,(chronic SNC is >= 66%) => TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Control Authority, Town Name => Town of Mooresville WWTP Name => RRWWTP NPDES # => NCO046728 1st 6 months, dates => 1/1/2016 to 6/30/2016 2nd 6 months, dates => 7/1/2016 to 12/31/2016 Industry Name BestCo, Inc. IUP 9 # 0006 Pipe # # 001 Flow, mgd BOD TSS Ammonia s mon s 2ncl 6 month I st 6 months 2ncl 6 months s mon s 2ncl 6 months s mon s 2nd 6 months 181 184 39 27 39 27 3 3 0.24459 0.17704 0.25 0.25 6277 4076 948 754 0.11309 0.10012 0.18 0.2 1648 1460 229 206 0% 0% 5.1% 3.7% 10.3% 11.1% 0% 0% 0% 0% 3% 0% 7.7% 3.7% 0% 0% Arsenic Cadmium Chromium COD st 6 months 2nd 6 months I T707mmmoMs 2nd 6 mont smA mont s 2nd 6 mont sst mont s 2nd 6 mont s 1 1 0 3 3 3 N/A N/A 0.0005 0.0025 0.0005 0.0043 0.019 0.017 0.0005 0.0025 0.005 0.002 0.009 0.01 NA NA 0% 0% 0% 0% NA NA 0% 0% 0% 0% Copper Cyanide Lead L.L. Mercury ng/l st 6 months 2nd 6 monthsIst mont s 2nd 6 months 1 779 mont s 2nd 6 mont smA mont s 2nd 6 months 3 4 3 3 3 3 1 1 0.065 0.600 0.01 0.003 0.0046 0.004 0.5 1.25 0.05 0.18 0.01 0.003 0.002 0.003 0.5 1.25 0% 25% . 16.7% 0% 0% 0% NA NA 0% 0%1 16.7% 0% 0% 0%1 NA NA BDL => Below Detection Limit mg/I => milligrams per liter * POTW must enter at least one of these IUP => Industrial User Permit Ib/d => pounds per day four rows, Please indicate how averages were calculated SNC - Significant Non -Compliance mgd => million gallons per day Avg period could be month, Qtr, or 6 -month & if BDL , 1/2BDL, or zero values used. TRC - Technical Review Criteria W WTP => wastewater treatment plant Page 1 BS-IDSF-BS-201.6.xls Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each Industry/pipe Enter BDL values as < (value) Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Industry Name BestCo Inc. IUP # #0006 Pipe # # 001 Nickel Selenium Silver Zinc st months n months st mont s n months st mont s n months st mont s2nd 6 months 3 3 1 1 1 1 3 3 0.0187 0.011 0.0005 0.0025 0.0005 0.0005 0.16 0.175 0.007 0.01 0.0005 0.0025 0.0005 0.0005 0.1 0.15 0% 0% NA NA NA NA 0% 0% 0% 0-0/.-F—NA NAI NA NA 0% 00N T. Phos. pH Oil & Grease Mercury (245.1) st _ mont s n mont s st mont s n months st mont s 2nd 6 months st mont s 2nd 6 months 3 3 39 27 7 7 1.70 8.5 10.9 10.7 46 34 1.23 3.7 NA NA 23 13 NA NA 00% 0% 13% 0% NA NA NA NA 0% 0% 0% 0% NA NA Aluminum Molybdenum st 6 months 2nd 6 mont sst mont s 2nd 6 months I st 6 months 2nd 6 months stmont s 2nd 6 months 2 2 1 1 0.30 0.5 0.0005 0.0025 0.18 0.5 0.0005 0.0025 NA NA NA NA NA NA NA NA BDL => Below Detection Limit mg/I => milligrams per liter * POTW must enter at least one of these **TRC Violations below 5.0 pH IUP => Industrial User Permit lb/d => pounds per day four rows; Please indicate how averages were calculated SNC — Significant Non -Compliance mgd => million gallons per day Avg period could be month, Qtr, or 6 -month & if BDL, 1/2BDL, or zero values used. TRC => Technical Review Criteria W WTP => wastewater treatment plant Page 2 13S-IDSF-BS-20l6.xls Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each industry/pipe Enter BDL values as < (value) Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations,(chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (Ib/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Control Authority, Town Name => Town of Mooresville WWTP Name => RRWWTP NPDES # => NCO046728 1st 6 months, dates => 2nd 6 months, dates => 1/1/2016 to 6/30/2016 7/1/2016 to 12/31/2016 Industry Name Carolina Beverage Group IUP # #0017 Pipe # # 001 1 st 6 months 2nd 6 months Flow, mgd BOD I TSS Ammonia 1 st 6 months 2nd 6 months 1 st 6 months 2nd 6 months 1 st 6 months 2nd 6 months 1 st 6 months 2nd 6 months 181 184 30 32 30 32 3 3 0.92760 0.99100 0.25 0.44 22002 25505.4 813.9 425 0.51907 0.54391 0.24 0.31 5479 4989 250 232.2 0% 0% 0% 3.1% 0% 0% 0% 0% 0% 0% 0% 3.1% 0% 0% 0% 0% Arsenic Cadmium Chromium T. Phosphorus st 6 months 2nd 6 months I Tsmt9mmmomnmtrsm 2nd 6 months I st mont s 2nd 6 months stmont s 2nd 6 months 1 1 3 3 3 3 3 3 0.0005 0.001 0.0014 0.0023 0.0057 0.003 3.5 5.2 0.0005 0.001 0.001 0.001 0.004 0.002 2.5 3.6 NA NA 0% 0% 0% 0% NA NA NA NA 0% 0% 0% 0%1 NA NA Copper Cyanide Lead LL Mercury ng/l st 6 months 2nd 6 mont sst mont s 2nd 6 mont sst mont s 2nd 6 mont sst mont s '2nd 6 months 3 3 4 3 3 3 1 0 0.18 0.21 0.0025 0.0140 0.012 0.0037 0.05 0 0.13 0.11 0.0025 0.006 0.006 0.003 0.05 0 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% BDL => Below Detection Limit mg/l => milligrams per liter * POTW must enter at least one of these IUP => Industrial User Permit lb/d => pounds per day four rows, Please indicate how averages were calculated SNC => Significant Non -Compliance mgd => million gallons per day Avg period could be month, Qtr, or 6 -month & if BDL , 1/2BDL, or zero values used. TRC => Technical Review Criteria WWTP => wastewater treatment plant Page 1 IDSFCB&B08 Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each industry/pipe Enter BDL values as < (value) Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Industry Name Carolina Beverage Group 1UP # # 0017 Pipe # # 001 Nickel Selenium Silver Zinc st months n months st months n months st mont s n months st mont s n mont s 3 3 1 1 1 1 4 3 0.004 0.0048 0.0005 OA01 0.0005 0.0039 0.10 0.07 0.003 0.003 0.0005 0.001 0.0005 0.0039 0.073 0.08 0% 0% NA NA NA NA 0% 00/0 0% 0% NA NA NA NA 00/0 0% T. Phos. pH Oil & Grease Mercury (245.1) st 6 months 2nd 6 mont sst mon s 2nd 6 mont sst mon s 2nd 6 months st mon s 2nd 6 months 3 3 30 32 9 7 3.5 5.2 10.53 10.3 66 50 2.5 3.6 NA NA 35 28 NA NA 0% 0% 10% 0% NA NA NA NA _0% 0% 10% 0% NA NA Aluminum Molybdenum Cl Fl st 6 months 2nd 6 mont sst mont s 2nd 6 months I st mont s 2nd. 6 months I st 6 months 2nd 6 months 3 2 1 1 3 3 3 3 0.50 0.5 0.0005 0.001 43 73 1.9 1.37 0.28 0.34 0.0005 0.001 36.1 57 1.3 2.6 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA BDL => Below Detection Limit mg/I => milligrams per liter * POTW must enter at least one of these **TRC Violations below 5.0 pH NP => Industrial User Permit lb/d=> pounds per day four rows, Please indicate how averages were calculated SNC => Significant Non -Compliance mgd => million gallons per day Avg period could be month, Qtr, or 6 -month & if BDL, 1/2BDL, or zero values used. TRC — Technical Review Criteria W WTP => wastewater treatment plant Page 2 IDSFCB&B08 Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each industry/pipe Enter BDL values as < (value) Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations,(chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples. => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Control Authority, Town Name => Town of Mooresville WWTP Name => RRWWTP NPDES # => NCO046728 1st 6 months, dates => 1/1/2016 to 6/30/2016 2nd 6 months, dates => 7/1/2016 to 12/31/2016 Industry Name Niagara Bottling LLC IUP # # 0018 Pipe # # 001 Flow, mgd BOD TSS Ammonia st 6 months 2nci 6 months s mon s 2ncl 6 mon ss mon s 2nd 6 months s mon s 27CI 6 months 181 186 4 3 3 3 3 3 0.281 0.314 0.10 0.22 24 56 11 9 0.169 0.205 0.7 0.10 16 25 8.3 10.6 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Arsenic Cadmium Chromium COD st mont s n mont s st mont s 2nd. 6 months TsTT mont s 2nd 6 months 1 1 4 3 4 3 N/A N/A 0.005 0.0011 0.0005 0.0005 0.0058 0.0025 N/A N/A 0.005 0.0011 0.0005 0.001 0.003 0.001 N/A N/A NA NA 0% 0% 0% 0% N/A N/A NA NA 0% 00/. 0% 0% N/A N/A Copper Cyanide Lead L.L. Mercury ng/1 st mont s n mons s st mon s n months st mon s n mont s st mont s n mont s 4 3 3 3 4 3 2 0 0.053 0.007 0.004 0.004 0.0025 0.0025 0.638 0 0.03 0.01 0.004 0.004 0.0025 0.002 0.569 0 0% 0% 0% 0% 0% 0% NA NA 0% 0% 0% 0% 0% 0% NA NA BDL => Below Detection Limit mg/1 => milligrams per liter * POTW must enter at least one of these IUP => Industrial User Permit lb/d => pounds per day four rows, Please indicate how averages were calculated SNC => Significant Non -Compliance mgd => million gallons per day Avg period could be month, Qtr, or 6 -month & if BDL , 1/2BDL, or zero values used. TRC => Technical Review Criteria W WTP => wastewater treatment plant Page 1 Niagara-IDSF-Niagara-2016.xls Pretreatment Annual Report (PAR) Industrial Data Summary Form (IDSF) Use separate forms for each industry/pipe Enter BDL values as < (value) Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Total # of samples => * Maximum (mg/1) => * or Maximum (lb/d) => * or Average (mg/1) => * or Average Loading (lb/d) => % violations, (chronic SNC is >= 66%) => % TRC violations, (SNC is >= 33 %) => Industry Name Niagara Bottling LLC IUP # #0018 Pipe # # 001 Nickel Selenium Silver Zinc st 6 months 2nd 6 mont sst mont s 2nd 6 mont sst mont s 2nd 6 months stmont s 2nd 6 months 4 3 1 1 1 1 4 3 0.0025 0.0025 0.005 0.0005 0.0005 0.0005 0.05 0.005 0.0025 0.002 0.005 0.0005 0.0005 0.0005 0.02 0.01 0% 0% NA NA NA NA 0% 0% 0%u 0% NA NA NA NA 0% 0% T. Phos. pH Oil & Grease st 6 months 2nd 6 months 1 st 6 months 2nd 6 months I st 6 months 2nd 6 mons sst mont s 2nd 6 months 4 3 4 3 3 3 2.0 1.8 7.7 8.1 2.5 3 1.4 1.4 NA NA - 2.5 3 NA NA 0% 0% 0% 0% 0% 0% NA NA 0% 0% 0% 0% 0% 0% Aluminum Molybdenum Cloride Flouride st 6 months 2nd 6 mont sst mont s 2nd 6 mont sst mont s 2nd 6 months I st mont s 2nd 6 months 3 2 1 1 3 3 3 3 0.103 0.086 0.51 0.11 342 94 3.1 3.4 0.569 0.05 0.0087 0.11 154 81 2.8 3.0 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA BDL — Below Detection Limit mg/I => milligrams per liter * POTW must enter at least one of these **TRC Violations below 5.0 pH IUP => Industrial User Permit lb/d => pounds per day four rows, Please indicate how averages were calculated SNC => Significant Non -Compliance mgd — million gallons per day Avg period could be month, Qtr, or 6 -month & if BDL, 1/2BDL, or zero values used. TRC => Technical Review Criteria W WTP => wastewater treatment plant Page 2 Niagara-IDSF-Niagara-2016.xls Workbook Name: 2013AIlocationTablerevision4.xis, Worksheet Name: AT Printed: 12/1512016, 9:52 AM Page 1 of 4 Allocation Table Headworks last approved:01/14114 Allocation Table updated: 01/01/17 Permits fast modified: 10/15/15 nraor s#=>I NC0046728 IUP INDUSTRY NAMES Count (plass latalptubnrdr) I BestSweet, Inc. 2 Carolina Beer & Beverage, i 3 Niagra Bottling LLC 4 5 6 7 8 9 10 Spreadsheet Instructions: 1) Applicable Values should be entered In the Heavy Bordered cells. Rest of worksheet Is protected, password is ..2,. 2) Formulas are discussed in the Comprehensive Guidance, Chapter 6, Section C. 3) H WA and AT worksheets in this workbook are linked. Pollutant Names, MAHLs, Basis, and Uncontrollable load in this AT worksheet are automatically entered from the HWAspreadsheeL This includes pollutant names in columns AT through BK Industry Type Renewal Modification Date Permit Pipe of Effective Effective Permit number number Industry Date Date Expires Column Totals => Basis--> MARL from HWA (lbs/day) _> Uncontrollable Loading (lbs/day) Total Allowable for Industry (MAIL) (lbs/day) => Total Permitted to Industry (lbs/day) => MAIL left (lbs/day) _> Percent Allow. Ind. (MAIL) still available (%) _> Percent MARL still available (%) => 5 Percent MAHL (lbs/davl HWA.AT Revised: November 2005 10/1 Permit Limits Permit Limits Permit Limits Cone. Load Cone. Load MGD gal/day To lbs/da m lbs/da 0.2000 200,000 1500.001-2502.00 500.00 0.70D0 700,000 1071.00 6252.50 107.10 625.25 0.30D0 1 300,000 250.001 625.50 1.2000 NPDES NPDES Permitted Flow--> 7.5000 2.9811 4.5189 1.2000 3.3189 73.4% 44.3% 0.3750 3 20.2 21455 9348 12106 1125 10981 90.7% 51.2% 1073 Pow NPOES#-: IUP Count 2 3 4 5 6 7 8 9 10 Workbook Name: 2013AIlocationTabierevision4.xis, Worksheet Name: AT Allocation Table Headworks last approved: 01/14/14 Allocation Table updated: 01/01/1 Permits last modified: 10/15/15 Printed: 12/15/2016, 9:52 AM Page 2 of 4 Rocky River WWTP ` Sludge Basis--> NCO046728 INDUSTRY NAMES (p)-tlist alph*ejrJ5) BestSweet, Inc. Industry Permit number 00061,01 Pipe number 0001 Ammonia Permit Limits Conc. Load mg/1 lbs/da 7.50 12.51 Arsenic Permit Limits Cadmium Permit Limits Chromium Permit Limits Copper Cyanide Permit Limits Permit Limits Cone. Load Cone. Load Cone. Load m lbs/day mW1 lbs/day m lbs/day 0.0030 0.0050 0.0500 0.0834 Cone. Load Conc, Load m lbs/da mglbs/da 0.20001 0.3336 0.030 0.0500 Carolina Beer & Beverage, LLC 0017101 0001 7.50 43.79 0.0671 0.0030 0.0175 0.0500 0.2919 0.2000 1.1676 0.010 0.0584 Niagra Bottlinp LLC 0018101 0001 0.0394 0.1050 8.1441 2.3054 0.3698 Total Permitted to Industry (lbs/day) > 56.30 0.0000 0.0225 0.3753 1.5012 0.1084 MAIL lett (lbs/day) = 708.58 0.0394 0.0825 7.7688 0.8042 0.2614 Percent Allow. Ind. (MAIL) stili available (o/a) y 92.6% 100.0 % 78.6% 95.4 % 34.9% Percent MAHL still available (%) _> 49.3% 37.0 % 45.9% 94.4 % 25.0 % EO.2 5 Percent MAHL (lbs/day) _> 71.93 0.0053 0.0090 0.4116 0.3606 0.0217 1 Column Totals =} 56 0.0000 0,0225 0.3753 1.5012 0.1084 Sludge Sludge Basis--> Design Ceiling Stream Std Stream Std Ceiling NPDES MAHL from HWA (lbs/day) 1438.65 0.1066 0.1796 8.2311 3.2128 0.4345 Uncontrollable Loading (lbs/day) _> 673.77 0.0671 0.0746 0.0870 0.9075 0.0646 Total Allowable for Industry. (MAIL) (lbs/day) => 764.88 0.0394 0.1050 8.1441 2.3054 0.3698 Total Permitted to Industry (lbs/day) > 56.30 0.0000 0.0225 0.3753 1.5012 0.1084 MAIL lett (lbs/day) = 708.58 0.0394 0.0825 7.7688 0.8042 0.2614 Percent Allow. Ind. (MAIL) stili available (o/a) y 92.6% 100.0 % 78.6% 95.4 % 34.9% Percent MAHL still available (%) _> 49.3% 37.0 % 45.9% 94.4 % 25.0 % EO.2 5 Percent MAHL (lbs/day) _> 71.93 0.0053 0.0090 0.4116 0.3606 0.0217 HWA.AT Revised:November 2005 POTW- NPOESIK IUP Count 1 2 3 4 5 6 7 8 9 10 Workbook Name: 2013AIlocationTablerevision4.xis, Worksheet Name: AT Allocation Table Headvrorks last approved: 01/14/14 Allocation Table updated: 01/01/17 Permits last modified: 10/15/15 Printed: 12/15/2016, 9.52 AM Page 3 of 4 Rocky River WWTP 0.2402 1 0.000000 1 0.0000 0.3753 0.0000 0.0000 NCO046728 INDUSTRY NAMES (PI.. n.iPhabeada) Industry Permit number Pipe number Lead Permit Limits Cone. Load mgA lbs/day Mercury Permit Limits Conc. Load MgA lbs/da Molybdenum Permit Limits Conc. Load m lbs/day Nickel Permit Limits Cone. Load m9A lbs/day Selenium Permit Limits Cone. Load m lbs/da Silver Permit Limits Conc. Load m lbs/da BestSweet, Inc. 0006101 0001 0.0320 0.0534 NPDES HASL 0.0500 0.0834 Stream Std inhibition Carolina Beer & Beverage, LLC 0017101 0001 0.0320 0.1868 0.6394 0.2963 0.0500 0.2919 Uncontrollable Loading (lbs/day) -> 0.0646 Niagra Bottling LLC 0018101 0001 0.1343 0.0671 Total Allowable for Industry (MAIL) (Ibs/day) _> 0.8159 0.013283 0.7862 0.5474 0.1621 6.6674 Total Permitted to Industry (lbs/day) _> 0.2402 0.000000 0.0000 0.3753 0.0000 0.0000 MAIL left (lbs/day) = 0.5757 0.013283 0.7862 0.1721 0.1621 6.6674 Percent Allow. Ind. (MAIL) still available (%) => 70.6% 100.0 % 100.0%. 31.4%. 100.0% 100.0%. Percent MAHL still available (%) = 65.4% 75.9% 83.4% 1 26.9%1 99.0 5 Percent MAHL (lbs/day)=> 0.0440 0.000875 1 0.0471 0.0320 0.0]48 0.3367 Column Totals => 0.2402 1 0.000000 1 0.0000 0.3753 0.0000 0.0000 Sludge Sludge Ceiling Sludge AS/NitlTF Basil Ceiling NPDES HASL Ceiling Stream Std inhibition MARL from HWA (Ibs/day) > 0.8805 0.017510 0.9428 0.6394 0.2963 6.7346 Uncontrollable Loading (lbs/day) -> 0.0646 0.004227 0.1566 0.0920 0.1343 0.0671 Total Allowable for Industry (MAIL) (Ibs/day) _> 0.8159 0.013283 0.7862 0.5474 0.1621 6.6674 Total Permitted to Industry (lbs/day) _> 0.2402 0.000000 0.0000 0.3753 0.0000 0.0000 MAIL left (lbs/day) = 0.5757 0.013283 0.7862 0.1721 0.1621 6.6674 Percent Allow. Ind. (MAIL) still available (%) => 70.6% 100.0 % 100.0%. 31.4%. 100.0% 100.0%. Percent MAHL still available (%) = 65.4% 75.9% 83.4% 1 26.9%1 99.0 5 Percent MAHL (lbs/day)=> 0.0440 0.000875 1 0.0471 0.0320 0.0]48 0.3367 HWA.AT Revised: November 2005 POTw= NPDESN= IUP Count 2 3 4 5 6 7 8 9 10 Workbook Name: 2013AIlocationTablerevision4.xis, Worksheet Name: AT Allocation Table Headworks last approved: 01/14/14 Allocation Table updated: 01/0111 Permits last modified: 10/15115 Rocky River WWTP 2.7105 0.00 0.00 Sludge NCO046728 INDUSTRY NAMES ia�limaou4,Kiyr BestSweet, Inc. Industry Permit number 0006101 Pipe number 0001 Zinc Permit Limits Cone. Load rag4 lbs/da 0.4000 0.667 Total Nitrogen Permit Limits Cone. Load m lbs/day Total Phos. Permit Limits Cone. Load mgA Ibslda Carolina Beer & Bevera e, LLC 0017/01 0001 1 0:3500 2.0433 3.5479 Niagra Bottling LLC 0018101 0001 301.60 Total Permitted to Industry Obs/day) > 2.7105 0.00 0.00 MAIL left Obs/day) > 2.0373 301.60 Percent Allow. Ind. (MAIL) still available (%) ####### 100.0% Percent MAHL still available (%o) => W2. ##am 86.95 Percent MART. (lhs/dav) > , -7 z c7K Column Totals > 2.7105 0.00 0.00 Sludge Basis--> Ceiling Design. MAHL from HWA Obs/day) => 8.2956 347.15 Uncontrollable Loading (Lbs/day) => 3.5479 45.56 Total Allowable for Industry (MAIL) Obs/dap) => 4.7478 301.60 Total Permitted to Industry Obs/day) > 2.7105 0.00 0.00 MAIL left Obs/day) > 2.0373 301.60 Percent Allow. Ind. (MAIL) still available (%) ####### 100.0% Percent MAHL still available (%o) => W2. ##am 86.95 Percent MART. (lhs/dav) > , -7 z c7K HWA.AT Revised:November 2005 Printed: 1.2/15/2016, 9:52 AM Page 4 of 4 Workbook Name: 2013AIlocationTablerevision4.xis; Worksheet Name: HWA Page, of5 Printed 1/30/2017, 2:11 PM Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 A B C D E F G H I J K 1 Headworks Analysis Spreadsheet Spreadsheet Instructions: 2 POTW Name: ocky river wWTP 1) Applicable Values should be entered in the Heavy Bordered Blue cells. The rest of worksheet is 3 Date: 3 31 2011 protected, password is "2". 4 POTW NPDES # => NCO046728 2) Additional pollutants can be added in cells A34 to A42. Note all Pollutant names are linked from 5 POTW Sludge Permit # => WQ014136 here to other pages in HWA worksheet and also to AT worksheet (i.e., automatically entered into other pages in HWA worksheet and also AT worksheet from HWA worksheet). 7 POTW NPDES Permitted Flow(MGD)= 7.5 <tised in AT only 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter. 8 POTW Average Flow(MGD)-- 3.23 <tisedinHWAcalculations 4) HWA, AT and HASL worksheets are linked. MAHLs, Basis, and Uncontrollable load are 9 Uncontrollable Flow(MGD)= 2.9811 automatically entered into AT from this worksheet. 10 7Q10 Stream Flow(MGD)= 0.323 5) If red tab notes are not visible, they can be turned on in the "Tools" menu under "options", in the 11 Stream Classification = C "view" tab click the "comment indicator only" button. 13 Class of Sludge generated (A, or B) B 14 Sludge to'Digcstor Flow(MGD)= Through calc. for different POTW use Design 15 Sludge to Disposal Flow(MGD)= 0.0041 flows Criteria 16 %Solids to Disposal= 1.87 Design Values Average Flow I Permitted Flow Loading 17 Sludge Site Area(acres)-- 839.2 WWTF Influent BOD (mg/1) 323 684.9 295.0 x 18 Sludge Site Life(yrs� 20 WWTF Influent TSS (mg/1) 343 3571.4 1538.1 x 19 Age of Sludge Site(yrs� 8 WWTF Influent NH3 (mg/1) 23 400.0 172.3 x 20 WWTF Influent Total N(mg/1) 21 Pass -Through Loading Calculations WWTF Influent Total P (mg/1) 5.55 x Stream Standard Pass-Thru Minimum NPDES LIMIT Plant Removal Removal rate NPDES Loading Standard Stream Loading Design Criteria Loading Pass-Thru 23 Pollutant (mg/1) Rate (%) Source (lbs/day) (m9/1) Standard Source (lbs/day) Loading (lbs/day) (lbs/day) Basis 24 BOD 5 99.27 Site Specific 18,451 20,204 20,204 Design 25 TSS 30 99.16 Site S ecific 96,208 21,455 21,455 Design 26 Ammonia 1 99.75 Site S ecific 10,775 1,439 1,439 Design 27 Arsenic 45 Literature 0.05 NC WQS 2.6938 2.6938 Stream Std 28 Cadmium 67 Literature 0.002 NC WQS 0.1796 0.1796 Stream Std 29 Chromium 82 Literature 0.05 NC WQS 8.2311 8.2311 Stream Std 30 Copper 85.58 Site S eci c Achon Level 31 Cyanide 0.005 69 Literature 0.4345 0.4345 NPDES 32 Lead 61 Literature 0:025 NC WQS 1.8995 1.8995 Stream Std 33 Mercury 0.000013 98 Site 'Specific 0.01751 0.01751 NPDES 34 Molybdenum 33 Literature 35 Nickel 42 Literature 0.088 C WQS 4.4959 4.4959 Stream Std 36 Selenium 50 Literature 0.005 NC WQS 0.2963 0.2963 Stream Std 37 Silver 75 Literature Action Leve 38 Zinc 57.81 Site Specific Action Level 39 Total Nitrogen 65 Site S eci c 40 Total Phos. 67 Site Specific 347.1525 347.153 Design 41 c 42 43 e 44 f 75- Z6_ 47 I Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 Workbook Name: 2013AIlocationTablerevision4.xis; Worksheet Name: HWA Page 2 of 5 Printed 1/30/2017, 2:11 PM A B C D E I F G H I J K 49 50 FT Inhibition Loading Calculations Average Influent NH3 (Mg/1) Average Anaerobic Digester NH3 (mg/1) ® only enter when have ANAEROBIC digester 52 jPollutant Primary Removal Rate (%) Primary Removal Rate Source .. it Inhibition Concentration (mg/1) rt Inhibition Concentration Source . A. t Inhibition Loading (lbs/day) Digestor Inhibition Concentration (mg/1) Digestor Inhibition Digestor Inhibition Conc. Source Loading (lbs/day) m�mum r 'mum Inhibition in Loading Loading (Ibs/day) Source 53 BOD 54 TSS 55 Ammonia 480 A. S. Literature 12930.3360 12930.34 AS/Nit/TF i 56 Arsenic 0.1 A. S. Literature 2.6938 2.6938 AS/Nit/TF i 57 Cadmium 1 A. S. Literature 26.9382 26.9382 AS/WTF ' 58 Chromium 0.394 it. Literature - 20 10.6137 10,6137 AS/Nit/TF it 59 Copper 0.48 it. Literature - 20 12.9303 12.9303 AS/Nit/TF ' 60 Cyanide 0.1 A. S. Literature 2.6938 2.6938 AS/Nit/TF it 61 Lead 0.5 Nit. Literature 13.4691 13.4691 AS/Nit/TF i 62 Mercury 0.1 A- S. Literature 2.6938 2.6938 AS/Nit/TF i 63 Molybdenum 64 Nickel 0.25 Nit. Literature 6.7346 6.7346 AS/Nit/TF it 65 Selenium 66 Silver 0.25 A.S. Literature 6.7346 6.7346 AS/Nit/TF i 67 Zinc 1.574 Sde Specific 42.4007 42.4007 AS/Nit/TF i 68 Total Nitrogen 69 Total Phos. 70 c 71 d 72 e 73 f 74 Ig 75 lh 7611 Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 Workbook Name: 2013AIlocationTablerevision4.xls; Worksheet Name: HWA Page 3 of 5 � Printed 1/30/2017, 2:11 PM A B C D E F G H I J K 77 78 Sludge Loading Calculations Sludge Ceiling Concentration Limit 79 Pollutant (mg/kg) Sludge Ceiling Load (lbs/day) Sludge Ceiling Load - HASL Calc. - (lbs/day) Cumulative Sludge Rate Limit (lbs/(acre life)) Cumulative Sludge Loading (lbs/day) Class A Limits Monthly Average Rate Limit (mg/kg) Class A omits ass ants Monthly Avg. Mon. Avg. Load. - Loading HASL Calc. - (lbs/day) (lbs/day) It '"'mum Sludge Sludge Loading Loading (lbs/day) Sorce 80 BOD 81 TSS 82 Ammonia 83 Arsenic 75 0.1066 36 9.1909 41 1 0.1066 Sludge Ceili 84 Cadmium 85 0.0811 13.0843 34 5.8301 39 13.0843 Sludge Ceili 85 Chromium 86 Copper 4300 3.2128 1338 179.6192 1500 3.2128 Sludge Ceili 87 lCyanide 88 Lead 840 0.8805 267 50.2864 300 0.8805 Sludge Ceili 89 Mercury57 0.0372 15 1.7585 17 0.0372 Sludge Ceili 90 Molybdenum 75 0.1453 0.9428 0.9428 Sludge Ceili 91 Nickel 420 0.6394 374 102.3037 420 0.6394 Sludge Ceil' 92 Selenium 100 0.1279 2.1380 89 20.4498 100 2.1380 Sludge Ceili 93 Silver 94 Zinc 7500 8.2956 2498 496.4304 2800 8.2956 Sludge Ceili 95 Total Nitrogen 96 Total Phos. 97 c 98 d 99 e 100 f 101 102 h 103 I 104 Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 Workbook Name: 2013AIlocationTablerevision4.xis; Worksheet Name: HWA Page 4 of 5 Printed 1/30/2017, 2:11 PM A I B I C I D E F G H I J K 105 Maximum Allowable Headworks Loading Calculations Minimum Pass Minimum Minimum Minimum Minimum Through Loading Pass Through Inhibition Loading Inhibition Loading Sludge Loading Sludge Loading 106 (lbs/day) Source (lbs/day) Source (lbs/day) Sorce Allowable Maximum Allowable Headworks Headworks Loading Loading (lbs/day) Source 107 BOD 20203.7 Design 20203.7 Design 108 TSS 21454.7 Design 21454.7 Design 109 Ammonia 1438.7 Design 12930.3360 AS/Nit/TF inhibiti 1438.7 Design 110 Arsenic 2.6938 Stream Std 2.6938 AS/Nit/TF inhibitil 0.1066 Sludge Ceiling 0.1066 Sludge Ceiling 111 Cadmium 0.1796 Stream Std 26.9382 AS/Nit/TF inhibiti 13.0843 Sludge CeilingHASL 0.1796 Stream Std 112 Chromium 8.2311 Stream Std 10.6137 AS/Nit/TF inhibiti 8.2311 Stream Std 113 Copper 12.9303 AS/Nit/TF inhibiti 3.2128 Sludge Ceiling 3.2128 Sludge Ceiling 114 Cyanide 0.4345 NPDES 2.6938 AS/NiVTF inhibiti 0.4345 NPDES 115 Lead 1.8995 Stream Std 13.4691 AS/NiVTF inhibiti 0.8805 Sludge Ceiling 0.8805 Sludge Ceiling 116 Mercury 0.01751 NPDES 2.6938 AS/Nitinhibiti 0.0372 Sludge Ceiling 0.01751 NPDES 117 Molybdenum 1 0.9428 Sludge Ceiling HASL 0.9428 Sludge Ceiling HASL 118 Nickel 4.4959 Stream Std 6.7346 AS/NiVTF inhibiti 0.6394 Sludge Ceiling 0.6394 Sludge Ceiling 119 Selenium 0.2963 Stream Std 2.1380 Sludge CeilingHASL 0.2963 Stream Std 120 Silver 6.7346 AS/Nit/TF inhibiti 6.7346 AS/NiVTF inhibition 121 Zinc 42.4007 AS/Nit/TF inhibin 8.2956 Sludge Ceiling 8.2956 Sludge Ceiling 122 Total Nitrogen 123 Total Phos. 347.2 Design 347.1525 Design 124 c 125 d 126 e 127 f 128 129h 1301 131 Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 Workbook Name: 2013AIlocationTablerevision4.xis; Worksheet Name: HWA Printed 1/30/20 Page 2:11 PM -Y A B C D E F G H I J K 132 33 Maximum Allowable Industrial Loadin s Calculations Design vs. Pass - - Allowable Check to Use Uncontrollable Allowable Headworks Loading HASL Calcs Concentration Uncontrollable Uncontrollable Industrial Load 134 Pollutant (lbs/day) MAHL Basis (x) (m9/1) Source Load Obs/day) Ohs/day) �ThruWarning 135 BOD 20203.6500 Design 271 Mass Ba ance 6737.7034 13465.9466 136 TSS 21454.6500 Design 376 Mass Balance 9348.2526 12106.3974 137 Ammonia 1438.6500 Design 27.1 Mass Balance 673.7703 764.8797 ling 0.0027 Mass Balance 0.0671 0.0394 138 Arsenic 0.1066MNPDES 139 Cadmium 0.1796 X 0.003 Lderature 0.0746 0.1050 140 Chromium 8.2311 N/A 0.0035 Mass Balance 0.0870 8.1441 tire 141 Copper 3.2128ling 0.0365 Mass Balance 0.9075 2.3054 142 Cyanide 0.4345 N/A 0.0026 Mass Balance 0.0646 0.3698 143 Lead 0.8805iling 0.002 Mass Balance 0.0646 0.8159 144 Mercury 0.01751 0.00017 Mass B ance 0.00423 0.01328 145 Molybdenum 0.9428 Sludge Ceiling W X 0.0063 Mass Balance 0.1566 0.7862 146 Nickel 0.6394 Sludge Ceiling 0.0037 Mass Balance 0.0920 0.5474 147 Selenium 0.2963 Stream Std X 0.0054 Mass B ance 0.1343 0.1621 148 Silver 6.7346 AS/Nit/TF inhibin N 0.0027 Mass Bance 0.0671 6.6674 149 Zinc 8.2956 Sludge Ceiling 0.1427 Mass Balance 3.5479 4.7478 150 Total Nitrogen 151 Total Phos. 347.1525 Design 1.8323 Mass Balance 45.5553 301.5972 152 c 153 d 154 e 155 f 156 g 157 h 1581 Modeled after: Chapter 5-HWA Guidance, Appendix 5-A Revision Date: February 2008 BS Comp. Judg. 1 st 2016-PAR.xis Industry Name: BestCo IUP #/Pipe # 0061001 """"I struc ons - Reporting 1) Data entry in blue bordered cells only. All other cells protected. Password is 3. Strongly Recommend only Period: 1St/2 016 unprotect to make specific changes, and the reinstate protection again. 2) Choose either to enter detection level or 112 detection level and mark choice in cell B5. (Nate use second option only when detection level at or below limit) Detection Level 0.1568 (DL) entered 0.124 Level (DQ I 0 entered X 1 27/2016 0 0.1 53 s Sample Date Sample Daily Flow Violation Type Type MGD 2/18/2016 Permit Limit ®2 TRC Limit 0.330 0.1291 Rea TRC 1/6/2016]F--[--] 0.1568 1 13/2016 0 0.124 1/20/2016 0 0. 361 1 27/2016 0 0.1 53 2/ 2016 0 0.143 2 10 2016 0 0.1042 2/18/2016 0 0. 164 2/23/2016 0 0.1291 2124120 6 0 0. 453 2/25/2016 � 0.1494 31 20 6 OD 0.1520 3 2/2016 0 0.146 3 3/2016 0 0.1 58 3 8/20 6 OD 0.152 3 9/2016 OD 0.1 98 3 10 20 6 0 0.1 08 31520160D 219 0.1178 31620160 0.1183 3 7 2016 0 0.1289 3/22/2016 0 0.0762 3 23 20 6 0 0.0746 3 2 /2016 0 0.0729 3 29/2016 0 0. 071 3 30 2016 0 0.120 3/31/20160D 152 69 133 0. 259 46201601 0. 130 (7/2016 PTW ❑ 4 312016 0 0. 325 421/20160D 0. 2 2 !27 2016 0 0. 307 4 20 6 � 0.0860 511 /2016 0 0.1079 5 8/2016 0 0.1110 F -9 0-/2-0-q6 6 OD 0.0910 6/1 2016 OD 0.0942 6820 60D 0. 1 4 6/ 5/2016 0 0.10 2 6/22 2016 0 0. 085 6/29 2016 0 0.0797 Average of Column 1 0.121 I Total Samples 39 0 %Violations 0.0% %TRC Violations 0.0% SNC? NO BS Comp. Judg. 1st 2016-PAR.xis, SIU # 1/30/2017,1:51 PM e•■ al y � Concentr Violation =bstd- 'ally Concentr Violation ation Type a • aly Concentr Violation ation Type mof- ❑ 6 .8 �® ❑0 Q 300 5108 Rpn TRC 583.8 Rea TRC � Rea TRC 420 Rea TRC ation TypeEl ElElEl 8 62 7 1 1 ❑ 21 5 3627 ❑ 1 95 ❑ 120 ❑ 78 ❑ 330 ❑ 1662 ❑ 20 ❑ 2283 ❑®2 1 ❑ 2206 ❑ 3636 ❑ 2297 ❑ 980 91 ❑ 965 ❑ 88 932 607 ❑ 10761 I I 104/.1 226 ❑ 876 1 1 ❑ 678 1 1 ❑ 948 1 1 ❑ 80 ❑ 176 ❑ 125 ❑ 13 ❑ 210 ❑ 212 ❑ 207 ❑ 35 ❑ 179 ❑ 255 ❑ 197 1 3 ❑ 187 188 ❑ 86 ❑ 185 ❑ 17 ❑ 88 ❑ 194 ❑ 219 ❑ 16 224 217 ❑ 159 8 ❑ 137 ❑ ❑ ❑ 94 100 ❑ 86 ❑ ❑ 005 152 69 133 ❑ 261 ❑ 33El ❑ 2624 ❑ 33 ❑ 1678 ❑ 076 ❑ 280 1291 ❑ 1 20 ❑ 621 ❑ 282 ❑ 723 ❑ 96 ❑ 222 I I 104/.1 226 ❑ 876 1 1 ❑ 678 1 1 ❑ 948 1 1 ❑ 80 ❑ 176 ❑ 125 ❑ 13 ❑ 210 ❑ 212 ❑ 207 ❑ 35 ❑ 179 ❑ 255 ❑ 197 1 3 ❑ 187 188 ❑ 86 ❑ 185 ❑ 17 ❑ 88 ❑ 194 ❑ 219 ❑ 16 224 217 ❑ 159 8 ❑ 137 ❑ 31 1 ❑ 193 ❑ 100 ❑ 230 ❑ 236 ❑ ❑ ❑ 152 69 133 ❑ 137 I I I LLy.LI 0 0 39 2 1 0 39 4 %Violations 5.1% %Violations 10.3% %TRC Violations 2.6% %TRC Violations 7.7% SNC ? NO SNC ? NO 3 Violations 0.0% %TRC Violations 0.0% SNC? Page 1 NO I I zL•yl 0 7 0 % Violations 0% %TRC Violations 0% SNC ? NO •1011 Daily Violation 7 0 %Violations 0.0% %TRC Violations 0.0% SNC? NO < Concentration Type mg/L %Violations 0.0% %TRC Violations 0.0% SNC? NO Industry Name: BestCo IUP#/Pipe #006/001 Reporting Period: 1st/2016 Detection Level (DL) entered Level entered X Permit Limit TRC Limit Aven Total Samples BS Comp. Judg. 1st 2016-PAR.xis Sample Date Sample Type < 111, w; •' Daily Violation Concentration mg/L Type < Daily Violation Concentration Type mg/L yp 0 monitor �� 0� #VALUEI 0.006 0.09 Reg TRC 0 ##### %% %Violations 0.0% % TRC % % TRC Violations #VALUEI SNC ? #VALUEI BS Comp. Judg. 1st 2016-PAR.xis, SIU # 1130/2017,1:55 PM 0,00047- 0 .0004 0 3 0 0 % Violations 0.0% %TRC Violations 0.0% SNC? NO Daily Volation < Concentration Type mg/L 0 0 % Violations 0.0% %TRC Violations 0.0% SNC ? NO Page 2 Iy 7Daily n Volation < ConcOenlly tration Volation Type mg/L Type 0� 0� 0.6 0.09 Rea TRC Rea TRC I I u.ua I 0 3 0 0 %Violations 0.0% % TRC Violations 0.0% SNC ? NO 0 0 % Violations 0.0% %TRC Violations 0.0% SNC ? NO BS Comp. Judg. 1 st 2016-PAR.xIs Industry Name: BestCo 3/20 6 IUP #/Pipe #0061001 00 1/20120160D Reporting /27 2016 0 QO Period: 1st / 2016 20 6 F—T-� QO Detection Level (DL) entered 020 60D QO Level enteredX 8 0 6 0 Sample Date Sample p Type < Daily Violation Concentration mg/L Type Daily Violation < Concentration mg/L TYPe Daily Violation < Concentration mg/L Type Permit Limit 2/2 /20 6 TRC Limit 0.0576 Reg TRC 0.96 Reg TRC 0.036 Reg TRC Average of Column 1 0.0021 Total Samples 0 3 0 0 % % oda Violations 0.0% % TRC %% TRC Violations 0.0% SNC? NO BS Comp. Judg. 1st 2016-PAR.xls, SIU # 1/30/2017,1:51 PM 0 0 % Violations 0.0% % TRC Violations 0.0% SNC ? NO I u.0 lul 0 3 0 0 - % Violations 0.0% %TRC Violations 0.0% SNC ? NO Page 3 3/20 6 0 00 1/20120160D QO /27 2016 0 QO 20 6 F—T-� QO 020 60D QO 8 0 6 0 QO 23 20 6 0 �0 2/2 /20 6 0 QO 2 25/20 6 � QO 31 20160D QO 3220 60D 00 3/3/20 6 0 QO 3 8/2016 0 QO 3 9 2016 QO 31020160D QO 3 15 20 6 0 00 3 6 2016 0 00 3/1 2016 � 00 3 22 2016 00 3/23/2016 0 00 3 24 0 6 0 00 3/29 20 6 QO 3/30 2 16 0 QO 33 0 6� QD 4620160 Q 0.0012 4!7/20 6 POTW 0 0.0012 4 3/20 6 0 00 2 /20 6 0 00 4 2 20 6 � 00 5 2016 0 00 20 6 0 00 18 0 6 0 00 512 2016 � QO 61 6� 00 6820 6�D �0 �67f5�6�0 QO 612 2 6 � 00 6129 2 6 � 00 Average of Column 1 0.0021 Total Samples 0 3 0 0 % % oda Violations 0.0% % TRC %% TRC Violations 0.0% SNC? NO BS Comp. Judg. 1st 2016-PAR.xls, SIU # 1/30/2017,1:51 PM 0 0 % Violations 0.0% % TRC Violations 0.0% SNC ? NO I u.0 lul 0 3 0 0 - % Violations 0.0% %TRC Violations 0.0% SNC ? NO Page 3 Industry Name: BestCo IUP #/Pipe #006 / 001 Reporting Period: 1st / 2016 Detection Level (DL) entered Level (DL) entered X Sample Date Sample Type Permit Limit TRC Limit BS Comp. Judg. 1st 2016-PAR.xis < Daily Violation Concentration Type Daily Violation < Concentration TYPe Daily Violation < ConcenVation Type ng/L mg/L mg/L 0 monitor 0 monitor 0 monitor #VALUE! #VALUE! #VALUE! Req TRC Req TRC Req TRC /6/2016 0 00 13 20 6D 00 20 20 6 D �0 X17271201rj DD �0 2 4/20 6 � QO 2/ 0/2016 � 00 2/18120 6 � 00 2 23!20 6 � 00 2 2 /2016 � 00 25/20 6 ® QO 3/1/2016 ® 00 3/2/20160D 00 3 3/20 6 0 00 3/8/2016 0 00 3 9/2016 0 00 3/ 0/2016 0 �0 3/15/2016 0 QO 3/16 2016 � QO 3/ 2016 � 00 3222 160 00 3/23/20 6 �D� 00 3124 20 6 0 �0 3129 20 6 0 00 3/30 20 6 0 00 331 20 60 00 16/20 6 0 00 13 2016 � QO /21/2016 0 �0 4127 20 6 0 00 514/2016 � 00 11 2016 � �0 5/ 6 2016 � 00 512 20 6 � 00 6 20 6 0 �0 618 2016 �D� 00 6 52 6� 00 6 22/2016 � 00 6/29/20 6 � 00 Average of Column 1 0.05001 Total Samples 0 1 0 ##### %% %Violations 0.0% % TRC %%TRC Violations ##### SNC ? ##### BS Comp. Judg. 1st 2016-PAR.xls, SIU # 1/30/2017,1:51 PM 0 2 0 ##### % Violations 0.0% %TRC Violations fit# SNC ? ##### 0 1 0 0 % Violations 0.0% % TRC Violations 0.0% SNC ? NO Page 4 BS Comp. Judg.2nd 2016 - PAR.As Industry Name:HE�;] 0I 0.099 7 3 2016 D 0. 203 7!20 2016 IUP #/Pipe # 0. 410 Instructions - 0 0.136 8 3/20 6 0 Reporting1) Period: 8 10 20 6 Data entry in blue bordered cells only. A l other cells protected. Password is 3. Strongly Recommend only unprotect to make specific changes, and the reinstate protection again. 2) Choose to detection level 12 detection level in as. 0. 432 8 17 2016 0.1125 either enter option only when detection level or and mark choice at or below limit) cell (Note use second 83 206 D Detection Level 6 F-0-8-/2016 0 0. 289 9/ 2016 0 0. 545 (DL) entered 9/22 2016 D 0. 231 9 29 20 6 0 0.1085 12 Detection Level (DL) entered �( 0.0866 10620 6 P W 0. 104 0 2 20 6 Sample Date Sample • Daily Violation ow : • D Concentr V olation ` Concentr Violation ` Concentr r Violation ` • - Concentr Violation ` • Daily Violation Concentration 0 26/20,6 MGD Type anon Type anon Type ation Type ation Type Type Permit Limit 0 �� Q® ❑� 0® ❑© TRC Limit 0.330 5108 707 0.0498 360 12 � Rea TRC Rea TRC Rea TRC Rea TRC Rea TRC Rea TRC 6 20 6 0I 0.099 7 3 2016 D 0. 203 7!20 2016 0 0. 410 7/26/20 6 0 0.136 8 3/20 6 0 0.1269 8 10 20 6 0 0. 432 8 17 2016 0.1125 8 25 20 6 D 0. 5 3 83 206 D 0.127 6 F-0-8-/2016 0 0. 289 9/ 2016 0 0. 545 9/22 2016 D 0. 231 9 29 20 6 0 0.1085 10 5 20 6 = 0.0866 10620 6 P W 0. 104 0 2 20 6 0 0.0775 0 9 20 6 0 0. 077 0 26/20,6 F-15-1 0.1044 FTV272-016 F -U--] 0.1090 9 2016 0 0.0994 17!2016 D 0.0933 11 22 2016 D 0.0498 1 30 016 � 0.1237 12 /20 6 0 0.0961 .0T-6 0 0.1 91 21 2016 � 0. 263 2/28/2016 � 0.0409 Average of Column 0.112 Total Samples 27 0 % Violations 0.0% % TRC Violations 0.0% SNC? NO BS Comp. Judg.2nd 2016 - PAR.xIs, SIU # 1/30/2017.1:49 PM 0 M % Violations 3.7% % TRC Violations 0.0% SNC? NO I I zus.il 0 0 27 3 % Violations 11.1% % TRC Violations 3.7% SNC? NO Limit Change No Violation 1 n % Violations 0.0% % TRC Violations 0.0% SNC? NO Page 1 I I isl 0 0 7 0 % Violations 0.0% % TRC Violations 0.0% SNC? NO 0 n n % Violations 0.0% % TRC Violations 0.0% SNC? NO BS Comp. Judg.2nd 2016 - PAR.xIs Industry Name: BestCo IUP #/Pipe # 006 / 001 Reporting Period: 2nd / 2016 Detection Level (DL) entered 112 DetectionLevel (DL) ententered = Total Samples 3.7 n a n fififift %N %Violations 0.0% % TRC \ % TRC Violations #VALUE! SNC? #VALUE! BS Comp. Judg.2nd 2016 - PAR.xIs, SIU # 1/30/2017,1:49 PM n n % Violations 0.0% % TRC Violations 0.0% SNC ? NO n 0 %Violations 0.0% % TRC Violations 0.0% SNC ? NO Page 2 1 n % Violations 25.0% % TRC Violations 0.0% SNC ? NO n n % Violations 0.0% %TRC Violations 0.0% SNC ? NO Sample late]SampleViolation 7�C.ncen,tlralon Violation 7C.nrentla'ton Daily V olation < Concentration Daily Violation < ConcenVation Daily Viola te < ConcentrationType mgL Type Type mg/L TYPe mg/L TYPe mg/L TYPe Permit Limit TRC Limit #VALUE! 0.006 0.09 0.6 0.09 Total Samples 3.7 n a n fififift %N %Violations 0.0% % TRC \ % TRC Violations #VALUE! SNC? #VALUE! BS Comp. Judg.2nd 2016 - PAR.xIs, SIU # 1/30/2017,1:49 PM n n % Violations 0.0% % TRC Violations 0.0% SNC ? NO n 0 %Violations 0.0% % TRC Violations 0.0% SNC ? NO Page 2 1 n % Violations 25.0% % TRC Violations 0.0% SNC ? NO n n % Violations 0.0% %TRC Violations 0.0% SNC ? NO Industry Name: BestCo 0 0.0030 IUP #/Pipe # 006 / 001 DD �0 Reporting Period: 20 2016 � �0 2nd / 2016 28 2016 Detection Level 00 (DL) entered � �0 1/2 Detection Level (DLI entered 8 10 2016 � �0 X 8 20 6 �D 00 Daily � [SampleSample Violation < Concentration Type 31 20 6 � Type mg/L Permit Limit 9 8 2016 TRC Limit 0.0576 oo.. ror 7 6 2016 0 0 0.0030 3/20 6 DD �0 20 2016 � �0 28 2016 � 00 832016 � �0 8 10 2016 � �0 8 20 6 �D 00 8 25 2016 � �0 31 20 6 � QO 9 8 2016 0 QO 9 2016 0 QO 9/22 2016 000 9/29 2016 � 00� 0 5 2016 0 0 0.00 0 062016 ®0 0. 0 0 2 06��0 9/20 6 0 00 FTU/2— 2016 0 00 1 /2 2 16 0 00 11 2016 D 00 �1Tf 2 6 � 00 22 20 6 0 00 30 20 6 0 00 2 7 2016 ®00 3 20 � 00 12 21 201 � 00 12 28 20 6 0 00 Average of Column 1 0.003 Total Samples 0 3 0 0 % \ %Violations 0.0% e/ TRC \ % TRC Violations 0.0% SNC ? NO BS Comp. Judg.2nd 2016 - PAR.xIs Daily Daily =Conce,'t1ration Violation Violat onViolation < Conm9 Lotion Type < Con Concentration TYPe Type YP 0.96 0.036 #VALUE! % Violations 0.0% % TRC Violations 0.0% SNC ? NO IKU n n % Violations 0.0% %TRC Violations 0.0% SNC ? NO BS Comp. Judg.2nd 2016 - PAR.xIs, SIU # 1/30/2017,1:49 PM Page 3 n % Violations 0.0% %TRC Violations ##### SNC ? ##### I r�u BS Comp. Judg.2nd 2016 - PAR.xIs Industry Name: BestCo 0 900 IUP #/Pipe # 0061001 Q 1050 Reporting 0 Q14401 Period: 2nd / 2016 Q 404 DetectionLevel 0 Q 759 (DL) entered Q 335 1/2 Detection Level � Q 3510 1 1 82206 (DL) entered 86 i F—DT-1 10881 9 8/2016 Daily 0 Daily FSa-pleate Sample < Concentration V olation TYPe Violation < Concentration Type 0 0 type 1 1 mg/L. 0 mg/L Permit Limit 10 5/2016 0 TRC Limit 2450 308 10620 6 Ran TRr Ron TR(: 7 6/2016 I 0 900 13/20 6 Q 1050 7/20 2016 0 Q14401 7 28/2016 Q 404 8 3/2016 0 Q 759 8/10/2016 Q 335 8/17 2016 � Q 3510 1 1 82206 � Q 86 8 3 /20 6 F—DT-1 10881 9 8/2016 F—D— 0 614 9/ 5 2016 0 0 8 9 22/2016 0 0 3150 1 1 9 29!2016 0 1173 10 5/2016 0 Q 200 1 10620 6 © � 00 1012/2016 0 0 2325 1 0 9/2016 0 0 97 0 26120 6 0 1 3 1 2 2016 FDS =1 1770 1 19/2016 0 1188 1 1 2016 D j 0 22711 1 11 22/20 6 0 380 11 30 2016 � Q 1398 12/7/20 6 � 0 022 12 13/2016 0 Q 236 2/2 /2016 0 0 3870 1 1 2/28/2016 0 1926 1 Average of Column 1 1599 Total Samples 0 27 8 % \ % Violations 29.6% % TRC \ % TRC Violations 11.1% SNC ? NO I I L34.01 3 0 27 7 5 % Violations 25.9% % TRC Violations 18.5% SNC ? NO I I •� Daily Daily Daily Violation Violation Violation < Concentration 7Concentration < Concentration ng/L Type mg/L TYPe mg/L Type 0 onitor 0 orator 0 onitor #VALUE! #VALUE! #VALUE! % Violations 0.0% % TRC Violations ##### SNC ? ##### BS Comp. Judg.2nd 2016 - PAR.xIs, SIU # 1/30/2017,1:49 PM Page 4 % Violations 0.0% % TRC Violations SNC ? ##### % Violations 0.0% % TRC Violations #a>1l# SNC ? ###}t# Industry Name: BestCo IUP #/Pipe # 006 / 001 Reporting Period: 2nd / 2016 Detection Level (DL) entered 1/3 Detection Level (DL) entered )( Permit Limit TRC Limit Aver Total Samples [Sampleate Sample Type Daily Violation < Concentration mg/L Type 0 onitor #VALUE! % \ %Violations 0.0% % TRC \ % TRC Violations ##### SNC ? ##### BS Camp. Judg.2nd 2016 - PAR.As, SIU # 1/30/2017,1:49 PM BS Comp. Judg.2nd 2016 - PAR.As Daily Volation < Concentration mg/L TYpe 0 oni or #VALUE! n % Violations 0.0°% % TRC Violations ##### SNC ? ##### IMU Page 6 CBG Comp.Judge 1st 2016.xis Average of Column Total Samples % Violations 16.7% %TRC Violations 13.3% SNC? NO CBG Comp.Judge 1st 2016.xis, SIU # 1/3012017.1:43 PM 0 22002 1 1 2638 Q 4622 0 4261 Industry Name: Carolina Beverage 0 3021 0 3116 Q 4654 IUP #/Pipe # 0017/001 In.tn,cuons - 5192 Q 2718 0 Reporting Period: 1st / 2016 6108 1)Data entry in blue bordered cells only. All other cells protected. Password is 3. strongly Recommend 'hang.., and the reinatate prmoobon again. 2) Chaos. either to enter d,teedon level or 12 detection level and mark choice in ..[1 135. (Note use below limn) only unprotect to make specific second option only when detection level at o 0 4107 0 Detection Level 0 3632 0 664 0 5083 (DL) entered 4613 0 4269 0 4776 7.62 Level 16523 1 2404 0 4804 entered X 6293 9962 6.65 7887 1[1 00 Sample Date Sample Type Daily Flow Violation MGD Type Daily Violation 7-.can,retion Ibs/day Type Daily Violation <ration lbs/day TYPe Daily < Concentration mg/L Violation TYPe Daily < Concentration mg/L Violation TYPe Daily < Concentration mg/L Violation TYPO Permit Limit 0� 10 00 TRC Limit 0.720 21016.8 1401.12 140 12 Rea TRC Ren TRC Rea Ti Ren TRC Rea TRC Ren TRC Average of Column Total Samples % Violations 16.7% %TRC Violations 13.3% SNC? NO CBG Comp.Judge 1st 2016.xis, SIU # 1/3012017.1:43 PM 0 22002 1 1 2638 Q 4622 0 4261 0 5294 0 3021 0 3116 Q 4654 3769 5021 5192 Q 2718 0 1654 Q 6108 6.72 8057 0 4107 0 3617 0 3632 0 664 0 5083 0 4613 0 4269 0 4776 7.62 31961 11 16523 1 2404 0 4804 0 6293 9962 6.65 7887 0 124.8 97.3 0 123.5 Q 138.8 160.7 0 257.4 0 261.6 Q 259.0 120.6 434.7 167.5 0 167.9 Q 203.2 Q 320.7 6.72 813.9 0 328.3 199.71 1 6.21 203.3 Q 151.7 246.5 0 401.3 0 289.7 178.6 7.62 211.5 233.8 249.7 0 356.5 0 224.6 299.7 6.65 270.2 I 1 y4I 1 1 LDU•UI 0 30 2 1 0 30 0 % Violations 6.7% % Violations 0.0% %TRC Violations 3.3% %TRCViolations 0.0% SNC? NO SNC? NO Page 1 I I �'•� I 0 0 9 0 % Violations 0.0% % TRC Violations 0.0% SNC? NO I I V.cgl 0 0 3 0 % Violations 0.0% % TRC Violations 0.0% SNC? NO I I I 0 0 26 0 0 %Violations %.TRC Violations SNC ? 0 7.40-1 0 6.26 0 6.66 0 0 .02 6 0 6.72 0 9.35 Q 6.21 Q 9.50 Q 10.53 9.13 7.62 9.92 0 7.62 0 ,0.18 6.65 00 0 10.03 .95 or B D� 0 6.26 I I I 0 0 26 0 0 %Violations %.TRC Violations SNC ? Industry Name: Carolina Beverage IUP#/Pipe# 0017/001 Reporting Period: 1st ! 2016 Detection Level (DL) entered Level entered X E.,-,IeSample Type Permit Limit TRC Limit Avei Total Samples %T CBG Comp.Judge 1st 2016.xis, SIU # 1/30/2017,1:43 PM CBG Comp.Judge 1 st 2016.xis I V.UVl1 0 3 0 % Violations 0.0% %TRCViolations 0.0% SNC? NO 1 V.VU41 0 0 3 0 %Violations 0.0% % TRC Violations 0.0% SNC? NO I I V. 10 0 0 3 0 %Violations 0.0% %TRCViolations 0.0% SNC? NO Page 2 Daily Violation < Concentration TYPO Daily= aily < Concentration Violation TYPe Daily Violation < concentration Type Daily violation < Concentration Type Daily Violation < concentration Type Daily Violation < Concentration TYPe mg/L mg/L rnw mg/L mg/L mg/L o D.DD o o� o D.D46 0� 0.006 Aon TDr` 0.09 Ren TA(` 0.3 Ren TRr". 0.018 Rcn TRr` 0.0576 Ann TDr"` 0.09 Don TA(` I V.UVl1 0 3 0 % Violations 0.0% %TRCViolations 0.0% SNC? NO 1 V.VU41 0 0 3 0 %Violations 0.0% % TRC Violations 0.0% SNC? NO I I V. 10 0 0 3 0 %Violations 0.0% %TRCViolations 0.0% SNC? NO Page 2 - 11 - 1 111 I V.UVl1 0 3 0 % Violations 0.0% %TRCViolations 0.0% SNC? NO 1 V.VU41 0 0 3 0 %Violations 0.0% % TRC Violations 0.0% SNC? NO I I V. 10 0 0 3 0 %Violations 0.0% %TRCViolations 0.0% SNC? NO Page 2 I V.UUA.I 0 0 3 0 % Violations 0.0% % TRC Violations 0.0% SNC? NO I U.UUp 0 0 3 0 % Violations 0.0% %TRCViolations 0.0% SNC? NO 1 I Y.YVJI 0 0 3 0 0 % Violations 0.0% % TRC Violations 0.0% SNC? NO - 11 I V.UUA.I 0 0 3 0 % Violations 0.0% % TRC Violations 0.0% SNC? NO I U.UUp 0 0 3 0 % Violations 0.0% %TRCViolations 0.0% SNC? NO 1 I Y.YVJI 0 0 3 0 0 % Violations 0.0% % TRC Violations 0.0% SNC? NO Industry Name:Carolina Beverage IUP#/Pipe# 0017/001 Reporting Period: 1st / 2016 Detection Level (DL) entered Level entered X [Sample Date Sample Type Permit Limit TRC Limit Avei Total Samples CBG Comp.Judge 1st 2016.x1s I I rel 0 3 0 Violations 0.0% %T % TRC Violations 0.0% SNC? NO I I I I I 7•s I u.Lo1 740 0 0 3 0 ##### 0 Daily Violation Concentration TYPe Daily Violation < Concentration TYPe Daily Violation < concentration TYPe Daily Violation < concentration TYPe Daily < concentration Violation TYPe < Daily Violation Concentration TYPe mgL mgt m9/L mg/L mg/L SNC? ##### 0 mgt �� 0 monitor 0 mondar 0 mondor 0 monitor � 00 0.42 Ron TRC: #VALUE! Ran TR(: #VALUE! Ran TRr. #VALUE! Ron TRC: #VALUE! Ron TRC: 4200.D Ron TRf: I I rel 0 3 0 Violations 0.0% %T % TRC Violations 0.0% SNC? NO I I Sb.l I I I I I I 7•s I u.Lo1 740 0 0 3 0 ##### 0 62 0 3 0 ##### 0 30 2 2 1003 % Violations 0 1230 % Violations 6.7 TRC Violations ##### 939 % TRC Violations ##### % TRC Violations ##### 1036 SNC? ##### 0 1 62 SNC? iF#iggt 01 133811 0 1386 0 1209 0 696 0 366 0 1422 0 267, 0 1109 0 960 0 97 3 8 0 15 954 257 0I 99 9751 0 446 759 906 1491 0 1041 I I Sb.l I I I I I I 7•s I u.Lo1 1 14uu.a1 0 0 3 0 ##### 0 0 0 0 0 3 0 ##/#!# 0 3 0 ##### 0 30 2 2 Violations 0.0% % Violations % Violations 0.0% % Violations 0.0% % Violations 6.7 TRC Violations ##### % TRC Violations % TRC Violations ##### % TRC Violations ##### % TRC Violations 6.7% SNC? ##### SNC? SNC? ##### SNC? iF#iggt SNC? NO CBG Comp.Judge 1st2016.xls, SIU At 1/3012017,1:43 PM Page 3 !2016 =1271 Industry Name: Carolina Beverage 2,/2016 IUP #/Pipe #0017/001 22 Reporting o� 33� Period: 1st / 2016 0�37� Detection Level 28/2016 0 (DL) entered 80 vzs/zo s Level O� ee l enteredd t j(� 1 7,,mp,ete Sample < Daily Violation Concentration Type 2/181 0 6 mg/L Type Permit Limit �® TRC Limit 280 Reg TRC r i—r� n1n11 !2016 =1271 2,/2016 ®0 22 1 26/2016 o� 33� /2016 0�37� 28/2016 0 0 80 vzs/zo s O� ee l !zo s ® O � 2/181 0 6 ®� 120 39 3/312 6 ® 0��31 290j 1 1 4 /2 16 ® 01551 x12,12 s� o[ —701 777M 1 12/2 1 0 0 3 o© 6 , I20 61�D o 32 6 012 6 0 0 36 IL II I I b4.Ll Average of Column 0 30 1 Total Samples Violations 3.3% T % TRC Violations 3.3% SNC ? NO CBG Comp.Judge 1st 2016.x1s, SIU # 1/30/2017. 1:43 PM Daily Violation < Concentration Type ype monitor #VALUE! Ran TRf CBG Comp.Judge 1st 2016.x1s Daily Violation < Concentration Type ng/L � monitor #VALUE! Ran TRr. I I °Yl I I �•�I 0 3 0 '## 0 1 0 ##### Violations 0.0% %Violations 0.0% TRC Violations #tq##/ % TRC Violations ##### SNC? tqt### SNC? ##### Page 4 CBG Comp.Judge 2nd 2016.xis 0 3572 11266 0 6421 --M-fT2Uf61� �7/2�016 5010 Industry Name: Carolina Beverage Q 3988 4 0 3127 0.9662 ©� IUP #/Pipe # NOW 18 0 mewmeB 0.6146 �672372af61C�� 0 6449 ® Reporting Period: �9T8720f8j� 1) Data entry in blue bordered cello only. All changes. and the reinstate p.Wdi n again. ober cats protected. Pas M h 3. StnoNy Reco W only unprotect to make.""Mc �r6/26T611-D� 6403.1 0.691 �9722720Ig 2nd / 2016 0.5927 2) Choose ether to enter deteulen level or 12 datadion loveI and nark choice In MU B5. (Note use second opdon only vdan 10,cUan level at o 6961.0 0 0 0.3922 1016420T61 101642076/ 1692.8 bek Undt) D 6991.3 Q 1664.6 Q Detection Level 0 I.39 IIM220j® 3809.4 0.50971 rT1Tf072o�6j® 0 ��68�j (DL) entered 2919.7 Q �TiT1Y720�6j® �0.6323j 20 6 0.67K Level 0�d22� �fT28 2 1 ® 0.361-91 X1729 01 ®�o.42�aj entered X 2 8 ®_ X034831 2 6 Daily Flow Violation /®® Daily violation ® Daily Violation Daily Violation Daily Violation Daily Violation 7Concnt-1 Sample Date Sample MGD Type on Type < Concentration Type < Concentration TYPe < Concentration TYPe < ConcentrationTYDe Type s/day Ibs/day mglL mglL mgt Permit Limit I TRC Limit Ren Tar Ren TRC. aen Tar Ren TRC F12 R.D TRC Ren TRC 0 3572 11266 0 6421 --M-fT2Uf61� �7/2�016 5010 Q �r/2�726i�1� Q 3988 4 0 3127 0.9662 ©� 0 0. 86 18 0 � 0.6146 �672372af61C�� 0 6449 ® D �9T8720f8j� 0.40311 �r6/26T611-D� 6403.1 0.691 �9722720Ig 0.5927 Q 25505.4 1 1 0 6961.0 0 0 0.3922 1016420T61 101642076/ 1692.8 10/13/20 6j D 6991.3 Q 1664.6 Q 1 20-i-6jF-U-1 0 I.39 IIM220j® 3809.4 0.50971 rT1Tf072o�6j® 0 ��68�j r 11116/207"61 2919.7 Q �TiT1Y720�6j® �0.6323j 20 6 0.67K FT172 / 0 161D 0�d22� �fT28 2 1 ® 0.361-91 X1729 01 ®�o.42�aj 2 8 ®_ X034831 2 6 /®® �T28 20 6 ® �Gdb91 0 3572 11266 0 6421 0 5010 Q 10274 Q 3988 0 3127 1259 0 9666 4891.5 0 3303.4 0 1942.6 0 5263.4 5560.6 2134.4 6403.1 4336.0 2217.3 Q 25505.4 1 1 0 6961.0 0 1668.1 1692.8 3002.9 0 6991.3 Q 1664.6 Q 3596.4 0 2672.9 0 3809.4 0 4970.7 0 2863.9 0 2919.7 Q 657.0 Average of Column 1 0.53161 1 1 4989.41 Total Samples 32 0 0 0 32 1 Violations 0.0% % Violations 3.1 TRC Violations 0.0% % TRC Violations 3.1 SNC? NO SNC? NO I I z3z.zl 1 0 32 0 Violations 0.0% %TRC Violations 0.0% SNC? NO CBG Comp.Judge 2nd 2016.xis, SIU # 1/30/2017, 1:37 PM Page 1 I I Lel 0 0 7 0 Violations 0.0% TRC Violations 0.0 SNC ? NO I I u.ai I 0 0 3 0 Violations 0.0 TRC Violations 0.0 SNC? NO I I I 0 0 32 0 0 Violations TRC Violations SNC ? Industry Name: Carolina Beverage IUP#/Pipe# 0017/001 Repomng� Period: 2nd/2016 (DL) eDetectrste Level (DL) entered Level entered X [S,m7pI,,,j1eSample Type Permit Limit TRC Limit Avei Total Samples %T CBG Comp.Judge 2nd 2016.xis I .. t ■ Daily Violation < Concentration Daily < Concentration Violation Daily Violation < Concentration Daily Violation < Concentration Daily Violation < Concentration Daily Violation < Concentration mgt TYPe mg/L TYPe mg/L TYPe mg/L TYPe mgt TYPe 7717 TYPe 0.006 Rwn TRr: 0.09 Ran TR(: 0.3 Ran TR(: 0.016 Ren TRf` 0.0576 Ron TRr 0.09 Aon TRr` I I o.00i I 0 3 0 %Violations 0.0% %TRC Violations 0.0% SNC? NO I u.uuc I 0 0 3 0 %Violations 0.0% %TRC Violations 0.0% SNC? NO I I �•��I 0 0 3 0 %Violations 0.0% %TRC Violations 0.0% SNC? NO CBG Comp.Judge 2nd 2016.x1s, SIU # 1/30/2017,1:37 PM Page 2 I I e•Iluo I 0 0 3 0 %Violations 0.0% %TRC Violations 0.0% SNC ? NO I I �•ee�l 0 0 3 0 %Violations 0.0% %TRC Violations 0.0% SNC? NO I I u.uus1 0 0 3 0 0 %Violations 0.0% %TRC Violations 0.0% SNC ? NO Industry Name: Carolina Beverage IUP#/Pipe# 0017!001 Reporting Period: 2nd/2016 Detection Level (DL) entered Level entered X [Sa-7,lealeSample Type Permit Limit TRC Limit Total Samples %T CBG Comp.Judge 2nd 2016.xis, SIU # 1/30/2017,1:37 PM CBG Comp.Judge 2nd 2016.xis o® ■ ■ I I ■ ■ • c■■ Daily I- Violation < Concentration TYPe 7aily Violation c Conation TYPe Daily Violation < Concentration TYPe Daily Volation < Concentration TYpa Daily < Concentration Violation Type Daily Violation < Concentration TYPe mgt mg/L mg/L mg/L 0 mg/L 0 0.3 Q monitor 0 monitor monitor monitor 0® 0.42 Rea TRC #VALUE! RP.n TRC. #VALUE! Ran TRr: #VALUE! Ran TRf: #VALUE! Ron TRr 4200.0 Ann TRl`. o® I I aY.01 I I 0 • �o 0 1071 0 0 3 0 ##### 0 0 0 0 0 3 0 ##### 0 2 0 00 1 1 % Violations 0.0% 0 813 %Violations 0.0% 0 610 3.1 % Q 23a % TRC Violations % TRC Violations ##### % TRC Violations 0.0% % TRC Violations 3.1% SNC? NO SNC? ##### SNC? s SNC? NO 0 393 Or -220 00 89 0 2043 14371 6 =E--- 6000 1 1 0 226 0 294 3211 0�5371 Q 893 057 �r-760 003 Q 666 Q 906 926 o® I I aY.01 I I 0 470 1 1 1217.81 0 1071 0 0 3 0 ##### 0 0 0 0 0 3 0 ##### 0 2 0 00 1 1 % Violations 0.0% 0 813 %Violations 0.0% 0 610 3.1 % Q 23a % TRC Violations % TRC Violations ##### % TRC Violations 0.0% % TRC Violations 3.1% SNC? NO SNC? ##### SNC? s SNC? NO 0 393 Or -220 00 89 0 2043 14371 6 =E--- 6000 1 1 0 226 0 294 3211 0�5371 Q 893 057 �r-760 003 Q 666 Q 906 926 I I u.Uol I I aY.01 I I 1 1 2.61 I I 0.341 1 1 1217.81 0 3 0 0 0 3 0 ##### 0 0 0 0 0 3 0 ##### 0 2 0 0 0 32 1 1 % Violations 0.0% %Violations 0.0% % Violations %Violations 0.0% % Violations 0.0% %Violations 3.1 % % TRC Violations 0.0% % TRC Violations ##### % TRC Violations % TRC Violations ##### % TRC Violations 0.0% % TRC Violations 3.1% SNC? NO SNC? ##### SNC? SNC? ##### SNC? NO SNC? NO Page 3 CBG Comp.Judge 2nd 2016.x1s M Average of Column I 1 54.21 I I 1 Total Samples 0 32 0 0 0 0 0 0 Violations 0.0% % Violations T % TRC Violations 0.0% % TRC Violations SNC ? NO SNC ? CBG Comp.Judge 2nd 2016.xis, SIU # 1/30/2017.1:37 PM Violations 0.0% TRC Violations SNC? ####It Page 4 D 009 Industry Name: Carolina Beverage 0® IUP #/Pipe 0017/001 017 / 001 00 28 DT61� Reporting � 1 Period: 2nd / 2016 8 0 0 0� Detection Level (DL) entered 8 0 ®00 Level (DL),..r..,.�.,--.....,....... entered X Sample Date Sample Daily < Concentrati0n Violation Daily Yolation < Concentration Daily < Concentretion 110lation Type mg/L TYPe mgt TYPe mg/L TYPe Permit Limit �® monitor monitor TRC Limit 280 #VALUE! #VALUEI 0341 Reg TRC Rea TRC Rea TRC M Average of Column I 1 54.21 I I 1 Total Samples 0 32 0 0 0 0 0 0 Violations 0.0% % Violations T % TRC Violations 0.0% % TRC Violations SNC ? NO SNC ? CBG Comp.Judge 2nd 2016.xis, SIU # 1/30/2017.1:37 PM Violations 0.0% TRC Violations SNC? ####It Page 4 D 009 �7TTd/2D0 0® IDS 00 28 DT61� 0 1 0� 8 0 0 0� 8 0 ®00 �®o 1 �10T6T200�6 0 0341 �f67f3 20 0 1 102 0 0 0© �fo7277Eb�61� 0 00 /3 Deo as 07 1®0 1 I2 0 6 0 28 rTi728 0 6 0 3 912016 o© X173 20,6 0� 62D 60 0� 2 2D 6 0 0® /20 01 68 6,2D o a® _4 M Average of Column I 1 54.21 I I 1 Total Samples 0 32 0 0 0 0 0 0 Violations 0.0% % Violations T % TRC Violations 0.0% % TRC Violations SNC ? NO SNC ? CBG Comp.Judge 2nd 2016.xis, SIU # 1/30/2017.1:37 PM Violations 0.0% TRC Violations SNC? ####It Page 4 Average of Column I 1 54.21 I I 1 Total Samples 0 32 0 0 0 0 0 0 Violations 0.0% % Violations T % TRC Violations 0.0% % TRC Violations SNC ? NO SNC ? CBG Comp.Judge 2nd 2016.xis, SIU # 1/30/2017.1:37 PM Violations 0.0% TRC Violations SNC? ####It Page 4 Niagara Comp. Judg. 1st 2016.xis Industry Name: Niagara • Violation Type % Violations 0.0% IUP #/Pipe # 0018/001 monitor TRC Limit nsvuctlons - Reporting 0.166 % TRC Violations 0.0% 6/22/2016 1) Data entry in blue bordered cells only. A l other cells protected. Passvmrd is 3. Strongly Recommend only Period: 1st / 2016 NO SNC? NO unprotect to make specific changes, and the reinstate protection again. 2) Choose either to enter detection level or 12 detection level and mark choice in cell B5. (Note use second SNC? 00 0 option only when detection level at or below limit) Detection Level (DL) entered D Level (DL) D entered R D Sample Date Sample Type Flow MGD • Violation Type % Violations 0.0% Permit Limit 0. 0 monitor TRC Limit 0.480 Ran TRr 0 1/27 201601 % Violations 0.172 % Violations 0.0% 4/6/2016 POTW 0.156 % TRC Violations 0.0% 4/19/20 6 0 0.166 % TRC Violations 0.0% 6/22/2016 0 0.225 SNC ? NO SNC? NO SNC? NO SNC? 00 0 OD D OD D DD D Average of Column Total Samples I u., ttu 4 0 0 :•o at y Concentr Violation ation Type lbs/day Dal y Concentr Violation ation Type lbstdav monitor Reg TRC I—I 11 e • Dai y al y 7c7 Concent/ Violation Concentr Violation Moll —A `ation Type ` ation Type �0 monitor ❑ monitor #VALUE! B n % Violations 0.0% % Violations 0.0% % Violations 0.0% % Violations 0.0% % Violations 0% % TRC Violations 0.0% % TRC Violations 0.0% % TRC Violations 0.0% % TRC Violations 0.0% % TRC Violations D% SNC ? NO SNC ? NO SNC? NO SNC? NO SNC? NO Niagara Comp. Judg. 1 st 2016.xis, SIU # 1/30/2017.12:36 PM Page 1 %Violations 0.0% TRC Violations 0.0% SNC ? NO Industry Name: Niagara IUP #/Pipe # 0018 / 001 Reporting Period: 1st / 2016 Detection Level (DL) entered Level (DL) entered X FS,mpleate Sample Type Permit Limit TRC Limit /2 /201601 6 2016 POTW F—Vl-9T2016 6 220160 DD DD DD DD DD 00 Average of Column Total Samples % \ % Violations 0.0% % TRC \ % TRC Violations 0.0% SNC ? NO � morntor #VALUE! IKU 0 0 Niagara Comp. Judg. 1st 2016.x1s, SIU # 1130/2017,12:36 PM Niagara Comp. Judg. 1st 2016.x1s < Daily Violation Concentraton Type Daily Violation monitor Concentration mgt Type � morntor #VALUE! IKU 0 0 Niagara Comp. Judg. 1st 2016.x1s, SIU # 1130/2017,12:36 PM Niagara Comp. Judg. 1st 2016.x1s < Daily Violation Concentraton Type mg/L monitor � monl or #VALUE! #VAL—UE ! n n % Violations 0.0% % TRC Violations 0.0% SNC ? NO •• Daily Violation < Concentration mgn_ TYpe n n % Violations 0.0% %TRCViolations 0.0% SNC? NO Page 2 •-• Daily Volation Daily Violation < Conm9� tion Type < Concentration Type 9 0 monitor 0 monitor #VALUE! #VALUE! 0 0 % Violations 0.0% % TRC V!olations 0.0% SNC ? NO n n % Violations 0.0% % TRC Violations 0.0% SNC ? NO Niagara Comp. Judg. 1st 2016.x1s Industry Name: Niagara IUP #/Pipe # 0018/001 Reporting Period: 1st / 2016 Detection Level (DL) entered Level (DL) entered X Daily latioDaily Violation lation < ConcmDeagittlti< CmDgiltrlL tiViolation nnao< ConntrationmpleDaSample Con VTe Type Type Type mg/L mg/L Permit Limit 0 monitor 0 monitor 0 monitor 0 mons or TRC Limit #VALUE! #VALUE! #VALUE! #VALUE! Reg TRC Req TRC Req TRC Rea TRC Aver Total Samples 1 27/2016 Average 0 0 0.002 4 6/20 6 POTW 0 0.000 4 1912016 0 0 0.002 6 22/2016 0 Q 0.002 00 �0 00 00 00 00 0� 00 00 00 0= 00 of Column 0.002 u a u u % \ % Violations 0.0% % TRC \ % TRC Violations 0.0% SNC ? NO Niagara Comp. Judg. 1st 2016.xls, SIU # 1/30/2017,12:36 PM % Violations 0.0% %TRC Violations 0.0% SNC ? NO % Violations 0.0% % TRC Violations 0.0% SNC ? NO Page 3 n % Violations 0.0% % TRC Violations ##### SNC ? ##### Niagara Comp. Judg. 1st 2016.x1s Industry Name: 1 /27 2016 Niagara F-11 16.81 Daily 6 2016 P TW IUP #/Pipe # 0018 / 001 /19/2016 0 009 Reporting Period: 1st / 2016 QO 0� Detection Level (DL) entered =0 00 00 Level(DL)-'.`""`�.`..._"."""'"`___�_....'"�( entered 00 00 Sam le Date Sam le P Type Daily < Concentration mg/LTYPe Violation on 7tiType Daily Violafion < Concentration ng lL Type DailyViolation Violation < ConcentrationP mg/L Type Permit Limit 0 mons or 0 monitor Q monitor Q monitor TRC Limit #VALUEI Rea TRC #VALUEI Rea TRC #VALUE! Rea TRC #VALUE! Req TRC Average of Column 11.9 Total Samples 0 3 0 0 % \ % Violations 0.0% % TRC \ % TRC Violations 0.0% SNC ? NO Niagara Comp. Judg. 1st 2016.xis, SIU # 1/3012017.12:36 PM 0 0 F-11 16.81 Daily 6 2016 P TW 0 10 /19/2016 0 009 6/2 20 6 QO 0� =0 00 00 00 00 00 00 00 00 00 E0 Average of Column 11.9 Total Samples 0 3 0 0 % \ % Violations 0.0% % TRC \ % TRC Violations 0.0% SNC ? NO Niagara Comp. Judg. 1st 2016.xis, SIU # 1/3012017.12:36 PM 0 0 FQmonitor #VALUE! % Violations 0.0% % Violations 0.0% % TRC Violations 0.0% % TRC Violations SNC ? NO SNC ? ##### Page 4 % Violations 0.0% % TRC Violations 0.0% SNC ? NO n 0 0 0 0 0 0 % Violations 0.0% % TRC Violations 0.0% % l SNC ? NO Daily Volation < Concentration Type mg/L FQmonitor #VALUE! % Violations 0.0% % Violations 0.0% % TRC Violations 0.0% % TRC Violations SNC ? NO SNC ? ##### Page 4 % Violations 0.0% % TRC Violations 0.0% SNC ? NO n 0 0 0 0 0 0 % Violations 0.0% % TRC Violations 0.0% % l SNC ? NO Industry Name: Niagara IUP #/Pipe #0018 / 001 Reporting Period: 1st / 2016 Detection Level (DL) entered Level entered X Permit Limit TRC Limit Aver, FSa-pleate Sample Type Daily ConcentrationVTYolation mg/L pe monitor #VALUE! Reg TRC 2 20 6 � 2.7 20 6 POTW 3.1 9 20 6 = 2.7 6222 60 0 0� 0 00 0 00 0 0� 0 age of Column 2.8 Total Samples % \ % Violations 0.0% % TRC MC Violations 0.0% SNC ? NO Niagara Comp. Judg. 1st 2016.x1s, SIU # 1/30/2017.12:36 PM Niagara Comp. Judg. 1st 2016.xis Page 5 Niagara Comp. Judg.2nd 2016.x!s Industry Name: Niagara ®mQ 1 2/2016 0 0.2 Daily Violation � Concentration 12 7 2016 0 IUP #/Pipe # 0018/ 001 00 Instru tions - Ron -rRr. E:= 0 Reporting Period: 0 0 3 0 #### % Violations 0.0% 1) Data entry in due bordered unprotect to make specific changes, cells only. All other cells protected. Password is 3. Strongly Recommend only and the reinstate protection again. % Violations 0.0% % TRC Violations 0.0% 2nd / 2016 % TRC Violations #### % TRC Violations 0.0% 2) Choose either to enter detection level or 12 detection level and mark choice in cell B5. (Note use second SNC ? #### SNC? NO SNC ? #### coon only when detection level at or below limit) Detection Level (DL) entered 112 Detection Level (DL) entered (D X Sample Date STY Daily Fl,ow • Violation :•• Concent/ Violation Concentr Violation Concentr Violation ele MGD Type ation Type ation Type ation Type Permit Limit0® 0 .8 onitor ❑0 TRC Limit 0.480 1401 Reg TRC Reg TRC Reg TRC Reg TRC 0 5 2016 POTW 1 0.222 ®mQ 1 2/2016 0 0.2 Daily Violation � Concentration 12 7 2016 0 0. 68 Type 00 0 Ron -rRr. E:= 0 0 0 3 0 #### 0 3 0 ��_� M®__ ■�=� E�== N�!i ®=Q 0.202 ®mQ Concentr Violation Daily Violation � Concentration anon Type Type 0 onitor � onitor Ron -rRr. #VALUE! Re TRC ®=Q 0.202 ®mQ M�=M WEEMIMM 10.9 WiMMMMM Average of Column 0.202 25 10.9 3 Total Samples 3 0 0 0 3 0 0 0 3 0 #### 0 3 0 0 0 3 0 #### % Violations 0.0% % Violations 0.0% % Violations 0.0% % Violations 0.0% % Violations 0.0% % TRC Violations 0.0% % TRC Violations 0.0% % TRC Violations #### % TRC Violations 0.0% % TRC Violations #### SNC? NO SNC ? NO SNC ? #### SNC? NO SNC ? #### Niagara Comp. Judg.2nd 2016.xls, Niagara 0018 113012017,12:48 PM Page 1 9 ❑ ❑ E 0.05 ##### E0 D0 0.1 0 3 0 ##### % Violations 0.0% % TRC Violations ##### SNC ? ##### Industry Name: Niagara IUP #/Pipe # 0018 / 001 Reporting Period: 2nd / 2016 Detection Level (DL) entered 112 Detection Level (D (DL) entered �( 7S,mpl,ate Sample Type Permit Limit TRC Limit 0/ 2016 POTWI /2 2016 0 12/7 20 6 0 0� 00 Average of Column Total Samples Daily Violation < Concentration Type mg/L 0 ondor #VALUE! Reg TRC 0® � 00 00 1.4 0 3 0 ##### % \ % Violations 0.0% % TRC \ % TRC Violations #VALUE! SNC ? #VALUE! Niagara Comp. Judg.2nd 2016.xis, Niagara 0018 1/30/2017,12:48 PM Niagara Comp. Judg.2nd 2016.xls Daily Violation Daily Violation < Concentration < Concentration mg/L Type mgt Type 0 orntor #VALUE! Reg TRC 0 0.0005 ##### 00 00 0.001 0 3 0 ##### % Violations 0.0% % TRC Violations ##### SNC ? ##### Q Mondor #VALUE! Reg TRC Q 0.0005 ##### =F-- 0.0025 ##### �0 00 0.001 0 3 0 ##### % Violations 0.0% % TRC Violations ##### Page 2 SNC ? ##### • Daily Violation < Concentration Type mg/L 0 onitor #VALUE! Reg TRC L 11 0.007 ##### 0 0.00 ##### 00 00 0.01 0 3 0 ##### % Violations 0.0% % TRC Violations ##### SNC ? ##### DailyViolation < Concentration Type mg/L 0 onitor #VALUE! Reg TRC �0 �0 0.002 0 3 0 ##### % Violations 0.0% %TRC Violations ##### SNC ? ##### Industry Name: Niagara IUP #/Pipe # o018/001 Reporting Period: 2nd / 2016 Detection Level (DL) entered 112 Detection Levei (D (DL) entered �( Sample Date Sample Type Permit Limit TRC Limit Niagara Comp. Judg.2nd 2016.x1s Daily Daily Daily Daily Violation Violation Violation Violation < Concentration < ConcenVation < Concentration < ConcenVaticn mg/L TYPe mgt Type mg/L TYPe mglL Type � onitor #VALUE! RPn TR(' 0/5/2016 ©0 0.001 12/7 2016 0 Q 0.00251 ##### OF 00 00 00 0.002 Average of Column Total Samples V a V iiiHF/Flf e/ \ %Violations 0.0% e/ TRC \ % TRC Violations ##### SNC ? ##### Niagara Camp. Judg.2nd 2016.xls, Niagara 0018 1/30/2017,12:48 PM amtor #VALUE! Reg TRC Q 0.00 ##### Q �0 00 0.01 0 3 0 ##### % Violations 0.0% % TRC Violations ##### SNC ? #Jflgl# 0 onitar #VALUE! Reg TRC Q 0.004 ##### Q 0.00 ##tel# �0 �0 0.004 0 3 0 ##### %Violations 0.0% % TRC Violations ##### Page 3 SNC ? 0 Monitor #VALUE! Reg TRC 00 00 00 0.05 0 2 0 ##### % Violations 0.0% %TRC Violations ##### SNC ? ##### Industry Name: Niagara IUP #/Pipe # 0018/001 Reporting Period: 2nd / 2016 Detection Level (DL) entered 112 Detection Level (D (DL) entered F7 Daily Violation Sample Date Sample < Concentration Type mg/L Type Permit Limit TRC Limit 560 Reg TRC 10 2016 FO -TW 0 30 1 2 2016 � 0 10. 7 2016 0 00 00 =F -- E==== 00= �0 Average of Column 14 Total Samples 0 3 0 0 % N % Violations 0.0% TRC \ % TRC Violations 0.0% SNC ? NO Niagara Comp. Judg.2nd 2016.xis Daily Violation < Concentration Type mg/L � onitor #VALUEI Reg TRC Q 0 3.7 1t#### QD ##### 00 �0 7.0 0 3 0 ##### %Violations 0.0% % TRC Violations ##### SNC ? ##### Daily Daily Daily Violation Violation V olat on < Concne19Lation TYPe < Concentration Type ` Conne9Lation TYPe 0 onitor 0 onitor � onitor #VALUE! #VALUE!#VALUE! Q Reg TRC Reg TRC Reg TRC 2.7 ##### 0 00 �0 3.4 ##### 0 - 00 < 3.0 0 0 0 0 0 0 0 0 0 3 0 ##### 0 % Violations % TRC Violations SNC ? Niagara Comp. Judg.2nd 2016.xls, Niagara 0018 1/3012017,12:48 PM Page 4 % Violations %Violations 0.0% % TRC Violations % TRC Violations ##### % l SNC ? SNC ? ##### Industry Name: Niagara IUP #/Pipe # 0018 / 001 Reporting Period: 2nd / 2016 Detection Level (DL) entered 112 Detection Level (DIFI'�jj (OL) entered X Permit Limit TRC Limit Aver., FS,mpl,ate Sample Type Daily 7Violation Concentration mgJL Type ondor #VALUE! Req TRC 0/5/2016 © 84 ##### 00 0 0E 0 age of Column 81.4 rotal Samples 3 0 ##### % \ % Violations 0.0% % TRC CRC Violations ##### SNC? Niagara Comp. Judg.2nd 2016.xls, Niagara 0018 1/30/2017,12:48 PM Niagara Comp. Judg.2nd 2016.x1s Page 5