HomeMy WebLinkAboutNC0020591_Pretreatment_Annual_Report_Update_20230426 CITY OF STATESVILLE
NCO020591
General Program Information:
All information is correct on the Pretreatment Program Info Database Sheet.
All Program Elements are up to date. The City of Statesville's Industrial Waste
Survey was updated and approved on October 14th, 2021. The ERP was updated and
approved on November 16th, 2021. The Long-Term Monitoring Plan was updated and
approved on April 2nd, 2019. 4th Creek HWA was updated and approved on October
27th, 2017. 3rd Creek HWA was updated and approved on June 1st, 2018. 3rd Creek
HWA was modified and sent to the state on June loth, 2021. 4' Creek HWA was
submitted to the state on June 28th, 2022, and acknowledged on June 29th, 2022.
Hi-Tec Plating #3008 does a batch discharge. On the months that they do not
discharge, the industry sends me a "No Discharge" letter. When they do discharge,
we do a split sample with the industry and average the results according to parameters
that are required. Flows are based on sampling events by the industry and the POTW.
SDFC, LLC permit #3002, was dropped due to closer of the facility. The
approval for the permit drop was on 10/17/2022.
The City of Statesville's Pretreatment Program continues to offer incentives for
active participants in EPA's Strategic Goals Program and the City of Statesville's
Common Sense Initiative.
Waste Reduction Table is attached.
Dental Amalgam Rule: In 2019 22 dental facilities submitted the one-time
compliance report. We received 1 in 2020.
CITY OF STATESVILLE
NCO020591
NCO031836
SIU Information:
PRATT Industries.-PERMIT NO. 4007
Second 6 months•
One notice of violation was sent out: one for BOD. Fines for these violations
totaled $50.00
JPS Composite Material-Permit No. 3005
Second 6 months•
One violation was sent out for TSS. Fines for this violation totaled $50.00.
They completed additional TSS sampling.
Workbook Name:Copy of S--ille_4thHWAAT.2022,Worksheet Name:AT
a.„a,on mm�.� v.i...uwauw� ,mom m.xwn.p..e.i.w.�.n�.aww��areo�•
o�ie35 COD
uvnpmeM== uvo¢RamomR
1)>
of 7
Workbook Name: Copy of Statesville_4th_HWA_AT.2022; WorksheetNpir ;o AAM
A I B C D E I F G H I J K
1 Headworks Analysis Spreadsheet Spreadsheet Instructions:
2 POTW Name: Statesville4th Cr 1) Applicable Values should be entered in the Heavy Bordered Blue cells. The rest of worksheet is
3 Date: 6/16/2022 protected, password is "2".
4 POTW NPDES#=> NCO031836 2) Additional pollutants can be added in cells A34 to A42. Note all Pollutant names are linked from
5 POTW Sludge Permit#=> WQ0016247 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)= 6.0 <=used in AT only 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter.
8 POTW Average Flow(MGD)= 3.385 -used in HWA calculations 4) HWA,AT and HASL worksheets are linked. MAHLs, Basis, and Uncontrollable load are
9 Uncontrollable Flow(MGD)= 3.351 automatically entered into AT from this worksheet.
10 7Q10 Stream Flow(MGD)= 7.5 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 Cl ass of SI udge generated(A,or B) B
14 Sludge to Digestor Flow(MGD)= Through calc.for different POTW use Desi n
9
15 Sludgeto Disposal Flow(MGD)= 0.033 flows Criteria
16 %Sol ids to Disposal= 12.68 Design Values Average Flow Permitted Flow Loading
17 SludgeSlteArea(acres)= 305.2 WWTF Influent BOD (mg/1) 350 503.0 283.8
18 9 udge Si te L i f e(yrs)= WWTF I nf I uent TSS(mg/1) 300 2419.4 1364.9 x
19 Age of Sludge Site(yrs)= WWTF Influent NH3(mg/1) 21 25.1 14.2
20 WWTF Influent Total N(mg/1) 28
21 Pass-Through Loading Calculations WWTF Influent Total P(mg/1)
Standard Pass-Thru Minimum
NPDESLIMIT Plant Removal Removal rate NPDES Loading Stream Standard Stream Standard Loading Design Criteria Loading Pass-Thru
23 Pollutant (mg/1) Rate(%) Source (lbs/day) (mg/1) Source (lbs(day) Loading(lbs/day) (lbs(day) Basis
24 1 BOD 17 96.62 DMR 14,199 17,514 14,199 NPDES
25 TSS 30 98.76 DMR 68,301 15,012 15,012 Design
26 Ammonia 2 92.04 DMR/LTMP 709 1,051 709 NPDES
27 Arsenic 45 LIT.VALUE 0.01 C HH RPA 1.6506 1.6506 Stream Std
28 Cadmium 67 LIT.VALUE 0.0009 NCAL RPA 0.2476 0.2476 Stream Std
29 Chromium 82 LIT.VALUE 0.011 NCAL RPA 5.5477 5.5477 Stream Std
30 Copper 0.0239 90.43 DMR/LTMP 7.0504 0.013 INC ALRPA 12.3318 7.0504NPDES
31 Cyanide 69 LIT.VALUE 0.005 NCAL RPA 1.4642 1.4642 Stream Std
32 Lead 61 LIT.VALUE 0.0058 NCAL RPA 1.3501 1.3501 Stream Std
33 Mercury 97.78 DMR/LTMP 0.000012 NCAL RPA 0.04907 0.04907 Stream Std
34 Molybdenum 33 LIT.VALUE 2 INC HH RPA 270.9878 270.9878 Stream Std
35 Nickel 45.42 LTMP 0.062 NCAL RPA 10.3122 10.3122 Stream Std
36 Selenium 50 LIT.VALUE 0.005 NCAL RPA 0.9078 0.9078 Stream Std
37 Silver 75 LIT.VALUE 0.00006 NCAL RPA 0.0218 0.0218 Stream Std
38 Zinc 68.2 LTMP 0.212 NCAL RPA 60.5206 60.5206 Stream Std
39 Total Nitrogen 1 83.55 jDMR/LTMP 1401.12
Modeled after: Chapter 5-HWA Guidance, Appendix 5-A
Revision Date: February 2008
Workbook Name: Copy of Statesville 4th HWA AT.2022• Workshee of 7
A B C D E F G H I J K
40 Total Phos. 88.62 DM R/LTM P
41 COD 89.03 DM R/LTM P
42 Oi I & Grease 76.22 LTM P
43 e
44 f
45 g
46 h
47 1
49 Averagelnfluent NH3(mg/I) 16.41
50 Average Anaerobic Digester NH3(mg/I)
51 Inhibition Loading Calculations only enterwhen haveANAEROBIC digester
i , i , . Digestor inimum minimum
Primary Primary Inhibition A.S./Nit,/T.F. Inhibition Inhibition Digestor Inhibition Inhibition
Removal Rate Removal Rate Concentration Inhibition Loading Concentration Inhibition Digestor Inhibition Loading Loading
52 Pollutant (%) Source (mg/1) Concentration Sour (lbs�day) (mg/1) Conc.Source Loading(Ibs(day) (lbs/day) Source
53 BOD
54 ITSS
55 Ammonia 480 ACT. SLUDGE 13550.8320 13550.83 AS/Nit/TF i
56 Arsenic 0.1 ACT. SLUDGE 2.8231 2.8231 AS/Nit/TF i
57 Cadmium 1 LIT.-AS. 28.2309 28.2309 AS/Nit/TF i
58 Chromium 0.394 NC 2006 NIT LIT 11.1230 11.1230 AS/Nit/TF i
59 Copper 0.48 NC 2006 NIT LIT 13.5508 13.5508 AS/Nit/TF i
60 Cyanide 0.1 LIT.-AS. 2.8231 2.8231 AS/Nit/TF i
61 Lead 0.5 LIT.-NIT. 14.1155 14.1155 AS/Nit/TF i
62 Mercury 0.1 LIT.VALUE 2.8231 2.8231 AS/Nit/TF i
63 Molybdenum
64 Nickel 0.25 LIT.-NIT 7.0577 7.0577 AS/Nit/TF i
65 Sel eni um
66 Silver 0.25 LIT.VALUE 7.0577 7.0577 AS/Nit/TF i
67 Zinc 1 NC 2006 NIT LIT 28.2309 28.2309 AS/Nit/TF i
68 Total Nitrogen
69 Total Phos.
70 COD
71 Oil & Grease
72 e
73 f
74 g
75 h
76 1
77
Modeled a er: Uhapter 5-HVVA Uwaance, Appendix -
Revision Date: February 2008
Workbook Name: Copy of Statesville 4th HWA AT.2022• Works hee °f'
A I B C D F G H I J K
78 Sludge Loading Calculations
ClassA Limits ClassA Limits ClassA Limits Minimum Minimum
Sludge Ceiling Sludge Ceiling Sludge Ceiling Load Cumulative Sludge Cumulative Monthly Monthly Avg. Mon.Avg.Load. - Sludge Sludge
Concentration Limit Load -HASL Calc.- RateLimit Sludge Loading Average Rate Loading HASL Calc.- Loading Loading
79 Pollutant (mg/kg) (lbs/day) (lbs/day) (lbs((acre*life)) (lbs/day) Limit(mg/kg) (lbs(day) (lbs(day) (lbs(day) Sorce
80 1 BOD
81 TSS
82 Ammonia
83 Arsenic 75 5.8163 36 41 5.8163 SI udge Cei I i
84 Cadmi um 85 4.4273 34 39 4.4273 SI udge Cei I i
85 Chromium
86 1 Copper 4300 165.9416 1338 1500 165.9416 SI udge Cei I i
87 Cyanide
88 Lead 840 48.0561 267 300 48.0561 SI udge Cei I i
89 Mercury 57 2.0343 15 17 2.0343 SI udge Cei I i
90 Molybdenum 75 7.9313 7.9313 SI udge Cei I i
91 N i ckel 420 32.2702 374 420 32.2702 SI udge Cei I i
92 lSelenium 100 6.9796 89 100 6.9796 SI udge Cei I i
93 Silver
94 Zinc 7500 383.7745 2498 2800 383.7745 SI udge Cei I i
95 Total Nitrogen
96 Total Phos.
97 COD
98 jOil & Grease
99 e
100 f
101 g
102 h
103 1
104
105 Maximum Allowable Headworks Loading Calculations
Minimum Pass Minimum Minimum Sludge Minimum Allowable Maximum Allowable
Through Loading Pass Through Inhibition Loading Minimum Inhibition Loading Sludge Loading Headworks Loading Headworks Loading
106 (lbs(day) Source (lbs/day) Loading Source (lbs/day) Sorce (lbs(day) Source
107 BOD 14199.0 NPDES 14199.0 NPDES
108 TSS 15012.0 Design 15012.0 Design
109 Ammonia 709.3 NPDES 13550.8320 AS/Nit/TF inhibition 709.3 NPDES
110 Arsenic 1.6506 Stream Std 2.8231 AS/Nit/TF inhibition 5.8163 SI udge Cei I i ng 1.6506 Stream Std
111 Cadmium 0.2476 Stream Std 28.2309 AS/Nit/TF inhibition 4.4273 SI udge Cei I i ng 0.2476 Stream Std
112 Chromium 5.5477 Stream Std 11.1230 AS/Nit/TF inhibition 5.5477 Stream Std
113 Copper 7.0504 NPDES 13.5508 AS/Nit/TF inhibition 165.9416 Sl udge Cei I i ng 7.0504 NPDES
114 Cyanide 1.46421 Stream Std I 2.8231 AS/Nit/TF inhibitionj 1 1 1.4642 Stream Std
115 Lead 1.35011 Stream Std I 14.1155 AS/Nit/TF inhibitionj 48.05611 SI udge Cei I i ng 1.3501 Stream Std
116 M ercur 0.04907 Stream Std 2.8231 AS/Nit/TF i nhi bition 2.0343 SI ud e Cei I i n 0.04907 Stream Std
Revision Date: February 2008
of 7
Workbook Name: Copy of Statesville_4th_HWA_AT.2022; WorksheetNpIr ;o AAM
A B C D E F G H I J I K
117 Molybdenum 270.9878 Stream Std 7.9313 SI udge Cei I i ng 7.9313 SI udge Cei I i ng
118 Nickel 10.3122 Stream Std 7.0577 AS/Nit/TF inhibition 32.2702 Sl udge Cei I i ng 7.0577 AS/Nit/TF inhibition
119 Selenium 0.9078 Stream Std 6.9796 SI udge Cei I i ng 0.9078 Stream Std
120 Silver 0.0218 Stream Std 7.0577 AS/Nit/TF inhibition 0.0218 Stream Std
121 lZinc 60.5206 Stream Std 28.2309 AS/Nit/TF inhibition 383.7745 Sl udge Cei I i ng 28.2309 AS/Nit/TF inhibition
122 Total Nitrogen
123 Total Phos.
124 COD
125 Oil & Grease
126 e
127 f
128 g
129 h
130 1
131
132
133 Maximum Allowable Industrial Loa din sCalculations
Allowable Allowable
Headworks Loading Check to Use HASL Uncontrollable Uncontrollable Uncontrollable Industrial Load Design vs. Pass-
134 Pollutant (lbs�day) MAHL Bass Calcs (x) Concentration(mg/1) Source Load(Ibs(day) (lbs(day) Thru Warning
135 BOD 14198.9734 NPDES 131 MASSBALANCE 3661.1015 10537.8718
136 TSS 15012.0000 Design 249 MASS BALANCE 6958.8877 8053.1123
137 Ammonia 709.3191 NPDES 16.41 AVG.INFLUENT 458.6158 250.7032
138 Arsenic 1.6506 Stream Std 0.0012 MASS BALANCE 0.0335 1.6170
139 Cadmium 0.2476 Stream Std 0.0003 MASS BALANCE 0.0084 0.2392
140 Chromium 5.5477 Stream Std N/A 0.0044 MASS BALANCE 0.1230 5.4248
141 Copper 7.0504 NPDES 0.042 AVG.INFLUENT 1.1738 5.8766
142 Cyanide 1.4642 Stream Std N/A 0.003 MASS BALANCE 0.0838 1.3804
143 Lead 1.3501 Stream Std 0.0023 MASS BALANCE 0.0643 1.2858
144 Mercury 0.04907 Stream Std 0.0002 AVG. INFLUENT 0.00559 0.04348
145 Molybdenum 7.9313 SI udge Cei I i ng 0.0037 AVG. INFLUENT 0.1034 7.8279
146 Nickel 7.0577 AS/Nit/TF inhibition 0.0069 MASS BALANCE 0.1928 6.8649
147 Selenium 0.9078 Stream Std 0.0014 MASS BALANCE 0.0391 0.8687
148 Silver 0.0218 Stream Std f N/A 0.0006 MASS BALANCE 0.0168 0.0050
149 Zinc 28.2309 AS/Nit/TF inhibition 0.1254 MASS BALANCE 3.5046 24.7263
150 Total Nitrogen
151 Total Phos.
152 COD 380 AVG.INFLUENT 10619.9892
153 Oil & Grease 13.59 MASS BALANCE 379.8044
154 e
155 f
Modeled after: Chapter 5-HWA Guidance, Appendix 5-A
Revision Date: February 2008
Workbook Name: Copy of Statesville_4th_HWA AT.2022; WorksheetNAMI ;o A of 7
AM
A B C D E F G H I J K
156 g
157 h
1581
Modeled after: Chapter 5-HWA Guidance, Appendix 5-A
Revision Date: February 2008
Name: Copy of Statesville_4th_HWA_AT.2022; Worksheet Name: HASL Page 7of7
Printed 4/26/2023,10:14 AM
Headworks Addendum for Sludge Loadings(HASL)worksheet
POTW Name=> Statesville-4th Creek Spreadsheet Instructions:
POTW NPDES#_> NCO031836 MAHL_sv= (Q_potw*C_inf*8.34)/(%_adj)Ibs/day
POTW Sludge Permit#_> WQ0016247 1) Data entered only in Heavy Bordered cells. Rest of workshect is protected,
Date=> 8/23/2017 password is"2". Q_potw=Average POTW flow(mgd)
POTW Average Flow=> 3.39 mgd C_inf=Average influent concentration(mgd)
Avg.sludge flow to Disposal=> 0.033 mgd 2)This spreadsheet changes based on the class of sludge generated inputted in %_adj= Per percentage of Sludge Limit as decimal
Average%Solids to Disposal=> 12.68 % cell C13 of the HWA spreadsheet. The title and the limits in column G of this (example:enter 117%as 1.17)
Sludge Site Area permitted=> 305.2 acres spreadsheet are updated automatically. 8.34= Conversion Factor
3)Formulas in Comprehensive Guidance HWA Chapter,Section K.
Enter actual Calculate MAHL_sv
CUMULATIVE Flag if> based on%of
LOADING data Enter actual 80%of Monthly Average
from most recent Flag if MAXIMUM SLUDGE %of Applicable Concentration Limits
CUMULATIVE Sludge Report for %of Greater Sludge Ceiling CONC.from most Applicable Ceiling Flag if> Enter Average to Protect Sludge
SLUDGE the most heavily Cumulative than Concentrations recent Sludge Report Ceiling Conc. Conc. 100%of POTW Influent Quality(insert these
POLLUTANT LOADING LIMITS loaded field' Limit 80% Limits or LTMP Data Limit Limit the Limit Conc. values into HWA)
Ibs/acre Ibs/acre mg/dry kg mg/dry k % Flag Flag mg/I Ibs/day
Arsenic 36 0.31 0.86 % 75 11.000 14.7 % 0.0012 0.2310
Cadmium 341 0.551 1.62 %1 85 3.600 4.2 % 0.00031 0.2000
Chromium
Copper 13381 21.221 1.59 % 4300 280.000 6.5 % 0.0433 18.7725
Lead 2671 2.781 1.04 % 840 32.000 3.8 % 0.0023 1.7044
Mercury 151 0.061 0.40 % 57 0.960 1.7 % 0.0002 0.3855
Molybdenum 75 12.000 16.0 % 0.0037 0.6528
Nickel 374 2.731 0.73 % 420 35.000 8.3 % 0.0069 2.3375
Selenium 89 0.35 0.39 % 100 5.600 5.6 % 0.0014 0.7058
Zinc 2498 47.02 1.88 % 7500 670.000 8.9 % 0.1250 39.5022
If over ceiling conc.
IF Greater than 80%Flag POTW MUST SUBMIT If Greater than 80%of the concentration limit POTW POTW must reduce
LAND APP&METALS MANAGEMENT PLAN n/a MUST SUBMIT METALS MANAGEMENT PLAN Na MAHL n/a
'The most heavily loaded field is determined for each polluntant indivisually,and is the field that contains the highest amount(Ibs/acre)of that polluntant.
Pretreatment Annual Report(PAR) PAR covers this calendar year=> 2022
Significant Non-Compliance Report(SNCR) Control Authority=Program=Town Name => City of Statesville
WWTP =Wastewater Treatment Plant,use separate form for each WWTP. WWTP Name => Third Creek
SIU= Significant Industrial User NPDES # => NCO020591
SNC = Significant Non-Compliance
A SNCR Form must be submitted with every PAR,please write "None"if you had No SIUs in SNC during calendar year
SNC? (Yes/No)
IUP Pipe Industry Name Parameter for each 6-month period.
# # or"Reporting" Jan. -June July-Dec.
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
Workbook Name: Co of Statesville.3rd Creek.HWA.AT.2021 U .Page 1of7
A I B C D E1111111L.Z. 1 nhjA G H I J K
1 Headworks Analysis Spreadsheet Spreadsheet Instructions:
2 POTW Name: 3RD CREEK WWTP 1) Applicable Values should be entered in the Heavy Bordered Blue cells. The rest of worksheet is
3 Date: 6/10/2021 protected, password is "2".
4 POTW NPDES#=> NCO020591 2) Additional pollutants can be added in cells A34 to A42. Note all Pollutant names are linked from
5 POTW Sludge Permit#=> WQ0016247 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)= 6 -used in AT only 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter.
8 POTW Average Flow(MGD)= 1.013 <=used in HWA calculations 4) HWA, AT and HASL worksheets are linked. MAHLs, Basis, and Uncontrollable load are
9 Uncontrollable Flow(MGD)= 0.565 automatically entered into AT from this worksheet.
10 7Q10 Stream Flow(MGD)= 13.2 5) If red tab notes are not visible, they can be turned on in the "Tools" menu under'options", in
11 Stream Classification- C the "view"tab click the "comment indicator only" button.
13 Class of Sludge generated(A,or B) B
14 Sludgeto Digestor Flow(MGD)= Through calc.for different POTW use Deli n
9
15 Sludgeto Disposal Flow(MGD)= 0.0152 flows Criteria
16 %Sol ids to Disposal= 17.53 Design Values Average Flow Permitted Flow Loading
17 9udge Ste Area(acres)= 382 WWTF Influent BOD (mg/1) 240 409.6 69.1 X
18 Sludge Site Life(yrs)= 50 WWTF Influent TSS(mg/1) 240 890.2 150.3 X
19 Ageof SludgeSite(yrs)= WWTF Influent NH3(mg/1) 20 103.4 17.5 X
20 WWTF Influent Total N(mg/1) 30
21 Pass-Through Loading Calculations WWTF I nf I uent Total P(mg/1) 6.5
Stream Standard Pass-Thru Minimum
NPDESLIMIT Plant Removal Removal rate NPDESLoading Standard Stream Loading Design Criteria Loading Pass-Thru
23 Pollutant (mg/1) Rate(%) Source (lbs(day) (mg/1) Standard Source (Ibs(day) Loading(lbs(day) (lbs(day) Basis
24 IBOD 12 97.07 DMR 3,460 12,010 12,010 Design
25 TSS 30 96.63 DMR 7,521 12,010 12,010 Design
26 Ammonia 2.1 97.97 DMR/LTM 874 1,001 1,001 Design
27 Arsenic 45 LIT.VALUE 0.005 Aquatic Life 1.0776 1.0776 Stream Std
28 Cadmium 62.89 LTM 0.0008364 Aquatic Life 0.2672 0.2672 Stream Std
29 Chromium 79 LTM 0.011 Aquatic Life 6.2091 6.2091 Stream Std
30 Copper 0.0283 81.82 DMR/LTM 1.3151 0.011693 Aquatic Life 7.6240 1.3151 NPDES
31 Cyanide 69 LIT.VALUE 0.005 Aquatic Life 1.9119 1.9119 Stream Std
32 Lead 61 LIT.VALUE 0.005751 Aquatic Life 1.7480 1.7480 Stream Std
33 Mercury 98.14 DMR/LTM 0.00012 Aquatic Life 0.76475 0.76475 Stream Std
34 Molybdenum 50.4 LTMP 2 Human Health 477.9694 477.9694 Stream Std
35 Nickel 35.79 LTM 0.0550293 Aquatic Life 10.1588 10.1588 Stream Std
36 Selenium 50 LIT.VALUE 0.005 Aquatic Life 1.1854 1.1854 Stream Std
37 Silver 75 LIT.VALUE 0.00006 Aquatic Life 0.0284 0.0284 Stream Std
38 jZinc 63.01 LTM 0.1874291 Aquatic Life 60.0627 60.0627 Stream Std
39 ITotal Nitrogen 75.2 DMR/LTMP 1501.2
Revision Date: February 2008
Workbook Name: Copy of Statesville.3rd Creek.HWA.AT.2021 Up.PATPage 2 of 7
n E 10:13 AM
A B C DWarkshdat me. G H I J K
40 Total Phos. 51.55 DM R/LTM P 325.26
41 COD 89.12 DMR
42 Bis(2-ethy1hexy1)Phth 0.0026 0.0037 Human Health
43 Hardness
44 f
45 g
46 1h
4711
49 Average Influent NH3(Mg/l)l 12.23
50 Average Anaerobic Digester NH3(mg/I)
51 1 nhibition Loading Calculations only enter when have ANAEROBIC digester
it, itj I F. A.S./Nitj I F. Digestor minimum minimum
Primary Primary Inhibition Inhibition Inhibition Inhibition Digestor Inhibition Inhibition
Removal Rate Removal Rate Concentration Concentration Loading Concentration Inhibition Digestor Inhibition Loading Loading
52 Pollutant (%) Source (mg/1) Source (Ibs(day) (mg/1) Conc.Source Loading(lbs(day) (lbstday) Source
53 IBOD
54 TSS
55 Ammonia 480 LIT.-AS. 4055.2416 4055.24 AS/Nit/TF in
56 Arsenic 0.1 LIT.-AS. 0.8448 0.8448 AS/Nit/TF in
57 Cadmium 1 LIT.-AS. 8.4484 8.4484 AS/Nit/TF in
58 Chromium 0.394 LIT.-NIT 3.3287 3.3287 AS/Nit/TF in
59 Copper 0.9 SAMPLING 7.6036 7.6036 AS/Nit/TF in
60 Cyanide 0.1 LIT.-AS. 0.8448 0.8448 AS/Nit/TF in
61 Lead 0.5 LIT.-NIT 4.2242 4.2242 AS/Nit/TF in
62 Mercury 0.1 LIT-AS. 0.8448 0.8448 AS/Nit/TF in
63 Molybdenum
64 Nickel 0.25 LIT. NIT 2.1121 2.1121 AS/Nit/TF in
65 Selenium
66 Silver 0.25 LIT.-AS. 2.1121 2.1121 AS/Nit/TF in
67 Zinc 3.197 SAMPLING 27.0096 27.0096 AS/Nit/TF in
68 Total Nitrogen
69 ITotal Phos.
70 COD
71 Bis(2-ethyl hexyl)Phthal ate
72 Hardness
73 f
74 g
75 h
7611
Modeled after: Chapter 5-HWA Guidance, Appendix 5-A
Revision Date: February 2008
Workbook Name: Copy of Statesville.3rd Creek.HWA.AT.2021 U . Page 3 of 7
It ln-l'I AM
A B C D G H I J K
77
78 Sludge Loading Calculations
u ge ei ing ClassA Limits ClassA Limits ClassA Limits Minimum Minimum
Sludge Ceiling Sludge Ceiling Load Cumulative Sludge Cumulative Monthly Monthly Avg. Mon.Avg.Load. - Sludge Sludge
Concentration Limit Load -HA& Calc.- Rate Limit Sludge Loading Average Rate Loading HA& Calc.- Loading Loading
79 jPollutant (mg/kg) (lbs/day) (lbs/day) (Ibs((acre*life)) (lbs(day) Limit(mg/kg) (Ibs(day) (lbsfday) (lbs(day) Sorce
80 IBOD
81 TSS
82 Ammonia
83 Arsenic 75 3.7037 36 1.6735 41 1.6735 Cumul. Sludgy
84 Cadmium 85 3.0035 34 1.1309 39 1.1309 Cumul. Sludgy
85 Chromium
86 1 Copper 4300 116.7886 1338 34.2077 1500 34.2077 Cumul. Sludgy
87 Cyanide
88 Lead 840 30.6014 267 9.1561 300 9.1561 Cumul. Sludgy
89 Mercury 57 1.2907 15 0.3197 17 0.3197 Cumul. Slud,
90 Molybdenum 75 3.3069 3.3069 SI udge Cei I i r
91 Nickel 420 26.0783 374 21.8593 420 21.8593 Cumul. Slud,
92 ISelenium 100 4.4445 89 3.7235 100 3.7235 Cumul. Sludgy
93 Si I ver
94 Zinc 7500 264.5108 2498 82.9296 2800 82.9296 Cumul. Slud,
95 Total Nitrogen
96 Total Phos.
97 COD
98 1 Bis(2-ethyl hexyl)Phthal ate
99 Hardness
100 f
101 g
102 h
103 1
104
1051
05 Maximum Allowable Headworks Loading Calculations
Minimum Pass Minimum Minimum Minimum Minimum Allowable Maximum Allowable
Through Loading Pass Through Inhibition Loading Inhibition Loading Sludge Loading Sludge Loading Headworks Headworks Loading
106 (lbs(day) Source (lbs(day) Source (lbs(day) Sorce Loading(lbs(day) Source
107 BOD 12009.6 Design 12009.6 Design
108 TSS 12009.6 Design 12009.6 Design
109 Ammonia 1000.8 Design 4055.2416 AS/Nit/TF inhibiti 1000.8 Design
110 Arsenic 1.0776 Stream Std 0.8448 AS/Nit/TF inhibiti 1.6735 Cumul. Sludge Loading 0.8448 AS/Nit/TF inhibition
111 Cadmium 0.2672 Stream Std 8.4484 AS/Nit/TF inhibiti 1.1309 Cumul. Sludge Loading 0.2672 Stream Std
112 Chromium 6.2091 Stream Std 3.3287 AS/Nit/TF inhibiti 3.3287 AS/Nit/TF inhibition
113 1 Copper 1.3151 NPDES 7.6036 AS/Nit/TF inhibiti 34.2077 Cumul. Sludge Loading 1.3151 NPDES
114 Cyanide 1 1.91191 Stream Std 0.8448 AS/Nit/TF inhibitil I F 0.8448 AS/Nit/TF inhibition
Modeled alter'. Chapter b-HVVA Guidance, AppendiX -
Revision Date: February 2008
Workbook Name: Co of Statesville.3rd Creek.HWA.AT.2021 U . Page 4 of 7
It 10-VIAM
A B C DIN G H I J K
115 Lead 1.7480 Stream Std i i i El M9. 5IMMul. Sludge Loading 1.7480 Stream Std
116 Mercury 0.76475 Stream Std 0.8448 AS/Nit/TFinhibiti 0.3197 Cumul. Sl udge Loading 0.31972 Cumul. Sludge Loading
117 Molybdenum 477.9694 Stream Std 3.3069 SI udge Cei I i ng 1 3.3069 SI udge Cei I i ng
118 Nickel 10.1588 Stream Std 2.1121 AS/Nit/TF inhibiti 21.8593 Cumul. Sludge Loading 2.1121 AS/Nit/TF inhibition
119 Selenium 1.1854 Stream Std 3.7235 Cumul. Sludge Loading 1.1854 Stream Std
120 Silver 0.0284 Stream Std 2.1121 AS/Nit/TF inhibiti 0.0284 Stream Std
121 Zinc 60.0627 Stream Std 27.0096 AS/Nit/TF inhibiti 82.9296 Cumul. Sludge Loading 27.0096 AS/Nit/TF inhibition
122 Total Nitrogen
123 Total Phos.
124 COD
125 Bis(2-ethylhexyl)
126 Hardness
127 f
128 g
129 h
130 1
131
132
133 Maximum Allowable Industrial Loadings Calculations
Allowable Uncontrollable Allowable
H eadwor ks Load i ng Check to Use HASL Concentration Uncontrollable Uncontrollable Industrial Load Design vs. Pass-
134 Pollutant (lbs(day) MAHL Basis Calcs (x) (mg/1) Source Load(Ibs(day) (lbs(day) Thru Warning
135 BOD 12009.6000 Design 158.16 Sampling 745.2657 11264.3343
136 TSS 12009.6000 Design 221 MASS BALANCE 1041.3741 10968.2259
137 Ammonia 1000.8000 Design 16.9 SAMPLING 79.6345 921.1655
138 Arsenic 0.8448 AS/Nit/TFinhibition 0.0011 MASS BALANCE 0.0052 0.8397
139 Cadmium 0.2672 Stream Std 0.002 MASS BALANCE 0.0094 0.2577
140 Chromium 3.3287 AS/Nit/TFinhibiti N/A 0.008 MASS BALANCE 0.0377 3.2910
141 Copper 1.3151 NPDES 0.0489 MASS BALANCE 0.2304 1.0847
142 Cyanide 0.8448 AS/Nit/TF inhibiti N/A 0.0025 SAMPLING 0.0118 0.8331
143 Lead 1.7480 Stream Std 0.006 MASS BALANCE 0.0283 1.7197
144 Mercury 0.31972 Cumul. Sludge Loading 0.00339 MASS BALANCE 0.01597 0.30375
145 Molybdenum 3.3069 SI udge Cei I i ng 0.006 MASS BALANCE 0.0283 3.2786
146 Nickel 2.1121 AS/Nit/TF inhibition 0.043 SAMPLING 0.2026 1.9095
147 Selenium 1.1854 Stream Std I
0.0013 MASSBALANCE 0.0061 1.1792
148 Silver 0.0284 Stream Std I N/A 0.0005 MASS BALANCE 0.0024 0.0261
149 Zinc 27.0096 AS/Nit/TFinhibition 0.148 MASS BALANCE 0.6974 26.3122
150 Total Nitrogen
151 Total Phos.
152 COD 589.26 SAMPLING 2776.6520
153 Bis(2-ethylhexyl)I
o e e a er: Uhapter - uI ance, ppen Ix -
Revision Date: February 2008
Workbook Name: Copy of Statesville.3rd Creek.HWA.AT.2021 UP.PATgP"I 5of7
n E 10:13 AM
Worksheet Name: HWA
A B C D E F G H I J K
154 Hardness
155 f
156 g
157 h
15811
Modeled after: Chapter 5-HWA Guidance, Appendix 5-A
Revision Date: February 2008
M,kb..k N...:C.py f —k.—AT.2021 UP—ED,W.--N...
--7L
- - - - - - - - - - - - - -- - - -
EW H4 EM 1W R� Ril
Name: Copy of Statesville.3rd Creek.HWA.AT.2021 UPDATED; Worksheet Name: HASL Page 7of7
Printed 4/26/2023,10:13 AM
Headworks Addendum for SludgeLoadings(HASL)worksheet
POTW Name=> 3RD CREEK WWTP Spreadsheet Instructions:
POTW NPDES#_> NCO020591 MAHL_sv= (Q_potw*C_inf*8.34)/(%_adj)Ibs/day
POTW Sludge Permit#_> WQ0016247 1) Data entered only in Heavy Bordered cells. Rest of workshect is protected,
Date=> 6/10/2021 password is"2". Q_potw=Average POTW flow(mgd)
POTW Average Flow=> 1.01 mgd C_inf=Average influent concentration(mgd)
Avg.sludge flow to Disposal=> 0.0152 mgd 2)This spreadsheet changes based on the class of sludge generated inputted in %_adj= Per percentage of Sludge Limit as decimal
Average%Solids to Disposal=> 17.53 % cell C13 of the HWA spreadsheet. The title and the limits in column G of this (example:enter 117%as 1.17)
Sludge Site Area permitted=> 382 acres spreadsheet are updated automatically. 8.34= Conversion Factor
3)Formulas in Comprehensive Guidance HWA Chapter,Section K.
Enter actual Calculate MAHL_sv
CUMULATIVE Flag if> based on%of
LOADING data Enter actual 80%of Monthly Average
from most recent Flag if MAXIMUM SLUDGE %of Applicable Concentration Limits
CUMULATIVE Sludge Report for %of Greater Sludge Ceiling CONC.from most Applicable Ceiling Flag if> Enter Average to Protect Sludge
SLUDGE the most heavily Cumulative than Concentrations recent Sludge Report Ceiling Conc. Conc. 100%of POTW Influent Quality(insert these
POLLUTANT LOADING LIMITS loaded field' Limit 80% Limits or LTMP Data Limit Limit the Limit Conc. values into HWA)
Ibs/acre Ibs/acre mg/dry kg mg/dry k % Flag Flag m /I Ibs/day
Arsenic 36 0.25 0.69 % 75 6.500 8.7 % 0.0011 0.1072
Cadmium 341 0.551 1.62 %1 85 33.2001 39.1 % 0.0011 0.0130
Chromium
Copper 1338 19.23 1.44 % 4300 459.000 10.7 % 0.045 3.5616
Lead 267 2.59 0.97 % 840 108.000 12.9 % 0.005 0.3154
Mercury 15 0.061 0.40 % 57 0.754 1.3 % 0.0002 0.1213
Molybdenum 75 23.000 30.7 % 0.011 0.2W
Nickel 374 2.181 0.58 % 420 58.800 14.0 % 0.007 0.4405
Selenium 89 0.321 0.36 %1 100 5.300 5.3 % 0.002 0.25W
Zinc 2498 36.981 1.48 %1 7500 1200.0001 16.0 % 0.114 6.0195
If over ceiling conc.
IF Greater than 80%Flag POTW MUST SUBMIT If Greater than 80%of the concentration limit POTW POTW must reduce
LAND APP&METALS MANAGEMENT PLAN n/a MUST SUBMIT METALS MANAGEMENT PLAN Na MAHL n/a
'The most heavily loaded field is determined for each polluntant indivisually,and is the field that contains the highest amount(Ibs/acre)of that polluntant.