NC0049867_Headworks Analysis_20190128

f ROY COOPER r
Governor
MICHAEL S. REGAN ..21` sr-1
Secretary
LINDA CULPEPPER " owd►'
Director
NORTH CAROLINA
Environmental Quality
January 28, 2019
Danny Gabriel, Mayor
Town of Cleveland
P.O. Box 429
Cleveland, NC 27013
Subject: Pretreatment Review of Headworks Analysis (HWA)
Program: Town of Cleveland (NPDES Permit No. NC0049867)
Rowan County
Dear Mr. Gabriel:
The Pretreatment, Emergency Response, and Collection Systems (PERCS) Unit of the Division of Water
Resources has reviewed the Headworks Analysis(HWA)for the Town of Cleveland. This HWA was initially
received by the Division on October 8, 2018, followed by additional information received on January 18,
2019.
The Division concurs with the most recent revisions of the HWA calculations for all pollutants of concern.
These approved Maximum Allowable Headworks Loadings (MAHLs), Maximum Allowable Industrial
Loadings (MAILs), and the basis for these values are found on the last page of the enclosed HWA
spreadsheet. The results of the HWA are also listed in the bottom section of the enclosed Allocation Table.
The following corrections and observations were made to the HWA:
1. 1.5 multiplier to BOD Design Value: It appears from our records that the Wastewater Treatment
Plant had an NPDES permit violation for BOD weekly average limit in April 2018. Therefore, PERCS
was not able to apply the requested multiplier of 1.5 to BOD influent design value of 181 mg/I, as
the WWTP must have full compliance for the parameters requested to be multiplied for the
previous 2 years, per PERCS design memo, dated February 19, 2007.
2. POTW Average Flow: POTW average flow was updated using DMR monthly average flow during
the HWA period, August 2017 through July 2018, not including STMP data, as these are included
within the monthly average flow data (see Removal Rate spreadsheet attached).
3. Sludge Data:
Sludge to Disposal Flow: Sludge to disposal flow was updated to 0.00022 MGD, using 5.97
dry tons from the submitted annual land application report.
Formula: (5.97 dry tons*2000 Ibs/ton)/(percent solids in decimal)(8.34 lbs/gallon)
ii. Percent solids to disposal was updated to 1.79, per submitted annual land application
report.
iii. Sludge Site Life and Age of Sludge Site: 5 years was deducted from sludge site life and
added to age of sludge site, from the approved HWA in 2012.
desPryrtrn M Iwwwwa10r1q '
North Carolina Department of Environmental Quality I Division of Water Resources
512 North Salisbury Street 11617 Mail Service Center I Raleigh,North Carolina 27699-1617
919.707.9000

4. Removal Rate Calculations: Removal Rates for several parameters were updated per Removal
Rate spreadsheet(see attached).
Removal rate for cyanide was chosen 69%, literature value,as the 67%of data is BDL, per
Removal Rate spreadsheet.
ii. Mercury removal rate was recalculated using low level mercury effluent data (1631E), as
it appears that couple of effluent data were sampled using method 245.1. Please note
that all mercury effluent samplings must be done using low level 1631 method.
iii. Removal rate for nickel was chosen 42% as literature value, even though site specific
removal rate came negative. It appears that STMP samplings were done using
inconsistent detection level (DLs). It is noticed that, DL from 12/2017 effluent lab report
was higher (0.01 mg/I) than the approved DL (0.005 mg/I) on the current STMP. POTW
needs to follow-up with the contact lab to ensure that the prescribed DLs on the approved
STMP consistently meet to produce accurate data for HWA calculations.
5. SIU Uncontrollable Mass Balance:
a. Average influent loading for several parameters were updated per Removal rate
spreadsheet.
b. Uncontrollable concentrations to be used in HWA were updated for several parameters
based on best judgement and most representative values(see attached),and carried over
to HWA spreadsheet.
6. STMP Detection Levels (DLs): From the lab reports, it appears that DLs/PQLs for several
parameters either did not meet consistently or reported higher than the listed DLs on the current
STMP. POTW needs to follow-up with contact analytical lab to ensure that all future samplings
meet the listed DLs on the current STMP. Please review current DLs on the STMP document and
revise, if necessary, and submit to PERCS for review and approval.
7. Copper and zinc over allocation: It appears from the Allocation Table (AT) that copper and zinc
are over allocated. POTW must take actions to resolve these over allocations, including reviewing
and lowering IUP limits, if necessary.
8. HWA Due Date: The HWA approved today is primarily based on DMR/STMP data for the period
of July 2017 through August 2018. Unless conditions at the POTW change significantly and thus
warrant an earlier submittal (see Comprehensive:6uide, Section B),the POTW must submit --
a. Updated HWA AT due by September 1st, 2023.
b. Please note that POTWs must submit an updated HWA within 180 days of the receipt of
NPDES permit renewal, per permit condition Part IV,Section D.
Thank you for your continued cooperation with the Pretreatment Program. If you have any questions or
comments, please contact Monti Hassan at(919)707-3626 [email: [e-mail]].
Sincerely,
Atk__
inda Culpepp
Director, Division of Water Resources
m h/Clevela nd.H W A.2018
Enclosures:HWA.AT,Removal Rate,Uncontrollable Mass Balance spreadsheets
cc: Barbara Sifford,Consultant(email)
Cathy Payne,Town of Cleveland(email)
Wes Bell,Mooresville Regional Office
PERCS Unit(e-copy)
Central Files

Workbook Name: HWA AT 2018.xlsx; Worksheet Name: HWA Page 1 of 5
Printed 1/28/2019,3:30 PM
A I B I C I D I_ E I F I G IHI I IJIK
1 Headworks Analysis Spreadsheet Spreadsheet Instructions:
2 POTW Name: own o C eve an. 1) Applicable Values should be entered in the Heavy Bordered Blue cells. The rest of worksheet is
3 Date: protected,password is"2".
4 POTW NPDES#=> NC0049867 2) Additional pollutants can be added in cells A34 to A42. Note all Pollutant names are linked from
5 POTW Sludge Permit#=> W•0011431 here to other pages in HWA worksheet and also to AT worksheet(i.e.,automatically entered into
-0- other pages in HWA worksheet and also AT worksheet from HWA worksheet).
7 POTW NPDES Permitted Flow(MGD)=111.11E EMO<=usedlin;A.Tady 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter.
8 POTW Average Flow(MGD)=ttiYll7f:� =used in HWA calculations 4) HWA,AT and HASL worksheets are linked. MAHLs,Basis,and Uncontrollable load are
9 Uncontrollable Flow(MGD)= 1 I automatically entered into AT from this worksheet.
10 7Q10 Stream Flow(MGD)= 5)If red tab notes are not visible,they can be turned on in the Tools"menu under"options",in
11 Stream Classification= - the"view"tab click the"comment indicator only"button.
13 Class of Sludge generated(A,or B) B
14 Sludge to Digestor Flow(MGD)= Through talc.for different POTW use Design
15 Sludge to Disposal Flow(MGD)= 0.00022 flows Criteria
16 %Solids to Disposal= 1.79 Desie Values Average Flow Permitted Flow Loading
17 Sludge Site Area(acres)= 4�.2 WWTF Influent BOD(mg/I) .181 622.4 278.0 x
18 Sludge Site Life(yrs)= 502 WWTF Influent TSS(mg/I)*1.5 249 2400.0 1071.8 x
19 Age of Sludge Site(yrs)= 10 WWTF Influent NH3(mg/I) 181.8 81.2
20 WWTF Influent Total N(tng/l)
21 Pass-Through Loading Calculations WWTF Influent Total P(mg/1)
Stream Standard Pass-Thru Minimum
NPDES LIMIT Plant Removal Removal rate NPDES Loading Standard Stream Loading Design Criteria Loading Pass-Thru
23 Pollutant (mg/i) Rate(%) Source (lbs/day) (mg/I) Standard Source (lbs/day) Loading(lbs/day) (lbs/day) Basis
24 BOD 15 97.59 DMR 626, 408 408 Design '
25 TSS 30 98.75 DMR 2,414 561 561 Design
26 Ammonia 6 96.70 DMR/STMP 183 183 NPDES
27 Arsenic 45 LIT>50%BDL 0.05 aquatic life 6.9454 6.9454 Stream Std
28 Cadmium 67 LIT>50%BDL 0.002 aquatic fife 0.4630 0.4630 Stream Std
29 Chromium 82 LIT>50%BDL 0.05 aquatic fife 21.2220 21.2220 Stream Std
30 Copper 71.60 STMP 0.007 aquatic life 1.8831 1.8831 Stream Std
31 Cyanide 69 LIT>50%BDL 0.005 aquatic fife 1.2322 1.2322•Stream Std
32 Lead 61 LIT--50%BDL 0.025 aquatic fife 4.8974 4.8974 Stream Std
33 Mercury • 97.67 STMP 0.000011 aquatic fife 0.03935 0.03935 Stream Std
34 Molybdenum 33 LIT-50%BDL
35 Nickel 42 LIT>50o/BDL 0.088 aquatic fife 11.5916 11.5916 Stream Std
36 Selenium 0 LIT>50o//B,,,DL �15.005 aquatic life 0.7640 0.7640 Stream Std
37 Silver 75 'l.rr->5)5 DL ' 0.00006 aquatic life 0.0183 0.0183 Stream Std
38 Zinc 53.7 'TMP 0.05 aquatic fife 8.2505 8.2505 Stream Std
39 Total Nitrogen
40 Total Phos.
41 c
42 a
43 e
44
45 g
46 i'
47 1
Modeled after.Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Workbook Name: HWA AT 2018.xlsx; Worksheet Name: HWA Page 2 of 5
Printed 1/28/2019,3:30 PM
A I B I C I D I E L F I G I H I I I J I K
49 Average Influent NH3(mg/I)
50 Average Anaerobic Digester NH3(mg/I)
51 Inhibition Loading Calculations only enter when have ANAEROBIC digester
A.SJNitJT.F. A.S✓Nit,/f.F. A.S✓Nit/f.F. Digestor Mmimu 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/0 Source (lbs/day) (mg/I) Conc.Source Loading(lbs/day) (lbs/day) Source
53 BOD
54 TSS
55 Ammonia 480 Lit AS 482.7059 482.71 AS/Nit/TF in
56 Arsenic 0.1 tit AS 0.1006 0.1006 AS/Nit/TF in
57 Cadmium 1 tit AS 1.0056 1.0056 AS/Nit/TF it
58 Chromium 0.394 Lit Nit 0.3962 0.3962 AS/Nit/IF in_
59 Copper 0.4nn Nit 0.4827 0.4827 AS/Nit/TF in
60 Cyanide 0.1 Lit AS 0.1006 0.1006 AS/Nit/TF in
61 Lead • 1.. 0.5 Lit Nit 0.5028 0.5028 AS/Nit/TF in
62 Mercury 0.1 Lit AS 0.1006 k 0.1006 AS/Nit/TF in
63 Molybdenum _
64 Nickel 0.25 Lit Nit 0.2514 0.2514 AS/NiVTF in
65 Selenium _
66 Silver 0.25 Lit AS 0.2514 0.2514 AS/NiVTF in
67 Zinc 1 Lit AS 1.0056 1.0056 AS/NiVTF in
68 Total Nitrogen
69 Total Phos. _
70 c
71 d +
72 e _
73 f
74 g .
75 h _
76 I
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Workbook Name: HWA AT 2018.xlsx; Worksheet Name: HWA Page3of5
Printed 1/28/2019,3:30 PM
A I B I C I D I E I F I G I H I I I J I K
77
76-Sludge Loading Calculations
Sludge Ceiling Class A Limits Class A Limits Class A Limits Minimum Minimum
Sludge Ceiling Sludge Ceiling Load Cumulative Sludge Cumulative Monthly Monthly Avg. Mon.Avg.Load. - Sludge Sludge
Concentration Limit load BPS!:Cale.- Rate Limit Sludge Loading Average Rate Loading HASL Cak.- Loading Loading
79 Pollutant (mg/kg) (lbs/day) (lbs/day) (Ibs/(acre life)) (lbs/day) Limit(mg/kg) (lbs/day) (lbs/day) (lbs/day) Sorce
80 BOD
81 TSS
82 Ammonia
83 Arsenic 75 0.0055 36 0.0140 41 0.0055 Sludge Ceilit
84 Cadmium 85 0.0042 34 0.0089 39 0.0042 Sludge Ceilit
85 Chromium
86 Copper 4300 0.1972 1338 0.3282 1500 0.1972 Sludge Celli'
87 Cyanide
88 Lead 840 0.0452 267 0.0769 300 0.0452 Sludge Ceilit
89 Mercury 57 0.0019 15 0.0027 17 0.0019 Sludge Ceilit
90 Molybdenum 75 0.0075 0.0075 Sludge Ceilit
91 Nickel 420 0.0328 374 0.1564 420 0.0328 Sludge Can
92 Selenium 100 0.0066 89 0.0313 100 0.0066 Sludge Can
93 Silver
94 Zinc 7500 0.4587 2498 0.8170 2800 0.4587 Sludge Ceilir
95 Total Nitrogen
96 Total Phos.
97 c
98 d
99 e
100 f
101 g
102 h
103 I
104
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Workbook Name: HWA AT 2018.xlsx; Worksheet Name: HWA Page4of5
Printed 1/28/2019,3:30 PM
A I B I C I D I E I F I G I H I I I J I K
105 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 407.6 Design 407.6 Design
108 TSS 560.7 Design 560.7 Design
109 Ammonia 182.8 NPDES 482.7059 AS/Nit/TF inhibiti _ 182.8 NPDES
110 Arsenic 6.9454 Stream Std 0.1006 AS/Nit/TF inhibiti 0.0055 Sludge Ceiling _ 0.0055 Sludge Ceiling
111 Cadmium 0.4630 Stream Std 1.0056 AS/Nit/TF inhibiti 0.0042 Sludge Ceiling _ 0.0042 Sludge Ceiling
112 Chromium 21.2220 Stream Std 0.3962 AS/Nit/TF inhibiti _ 0.3962 AS/Nit/TF inhibition
113 Copper 1.8831 Stream Std 0.4827 AS/Nit/TF inhibiti 0.1972 Sludge Ceiling 0.1972 Sludge Ceiling
114 Cyanide 1.2322 Stream Std 0.1006 AS/Nit/TF inhibiti 0.1006 AS/Nit/TF inhibition
115 Lead 4.8974 Stream Std 0.5028 AS/Nit/TF inhibiti 0.0452 Sludge Ceiling 0.0452 Sludge Ceiling
116 Mercury 0.03935 Stream Std . . .0.1006 AS/Nit/TF inhibiti 0.0019 Sludge Ceiling 0.00192 Sludge Ceiling
117 Molybdenum 0.0075 Sludge Ceiling 0.0075 Sludge Ceiling
118 Nickel 11.5916 Stream Std 0.2514 AS/Nit/TF inhibiti 0.0328 Sludge Ceiling 0.0328 Sludge Ceiling
119 Selenium 0.7640 Stream Std 0.0066 Sludge Ceiling 0.0066 Sludge Ceiling
120 Silver 0.0183 Stream Std 0.2514 AS/Nit/TF inhibiti 0.0183 Stream Std
121 Zinc 8.2505 Stream Std 1.0056 AS/Nit/TF inhibiti 0.4587 Sludge Ceiling 0.4587 Sludge Ceiling
122 Total Nitrogen
123 Total Phos.
124 c
125 d
126 e
127 f
128 g
129 h _
130 I
131
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Workbook Name: HWA AT 2O18.xlsx; Worksheet Name: HWA Page5of5
Printed 1/28/2019,3:30 PM
A I B I C I D I E 1 F I G I H I I IJIK
132
133 Maximum Allowable Industrial Loadings Calculations
mauimnm rvraulmum
Allowable Check to Use Uncontrollable Allowable
Headworks Loading HASL Cale Concentration Uncontrollable Uncontrollable Industrial Load Design vs.Pass-
134 Pollutant (Ibs/day) MARL Basis (x) (mg/i) Source Load(lbs/day) fibs/day) Thru Warning
135 BOD 407.5758 Design 23rAvg.Influent 91.8067 315.7691
136 TSS 560.6982 Design 4O Avg.Influent 144.1652 416.5330
137 Ammonia 182.8431 NPDES 27 Avg.Influent 9.6827 173.1604
138 Arsenic 0.0055 Sludge Ceiling 0.(rAvg.Influent 0.0008 0.0047
139 Cadmium 0.0042 Sludge Ceiling r 0.0tMass Balance 0.0011 0.0031
140 Chromium 0.3962 AS/NidPF inhibiti N/A 0.00331Mass Balance ' 0.0012 0.3950
141 Copper 0.1972 Sludge Ceiling 00284 Mass Balance 0.0102 0.1871
142 Cyanide 0.1006 AS/Nit(fF inhibiti N/A 0.0a'. Mass Balance 0.0011 0.0994
143 Lead 0.0452 Sludge Ceiling 0.061 Mass Balance 0.0007 0.0445
144 Mercury 0.00192 Sludge Ceiling 0.00M Mass Balance 0.00016 0.00I75
145 Molybdenum 0.0075 Sludge Ceiling r 0.01 Avg.Influent 0.0007 0.0067
146 Nickel 0.0328 Sludge Ceiling 0.0w Avg.Influent 0.0013 0.0316
147 Selenium 0.0066 Sludge Ceiling 0.0011 Avg.Influent 0.0009 0.0057
148 Silver 0.0183 Stream Std N/A 0.00111 Avg.Influent 0.0005 0.0178
149 Zinc 0.4587 Sludge Ceiling 0.04$Mass Balance 0.0172 0.4415
150 Total Nitrogen
151 Total Phos.
152 c
153 d l
154 e _
155 f
156 g
157 h
158 1
Modeled after:Chapter 5-HWA Guidance.Appendix 5-A
Revision Date: February 2008

Workbook Name : HWA AT 2018.xlsx, Worksheet Name: AT Printed: 1/28/2019,3:32 PM
— — Page 1 of 5
Allocation Table Spreadsheet Instructions:
Headworks last approved: 01/28/19 1,)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is protected,password is
Allocation Table updated: 09/20/18
2)Formulas are discussed in the Comprehensive Guidance,Chapter 6,Section C.
Permits last modified: 07/01/18 3)HWA and AT worksheets in this workbook are linked. Pollutant Names,MAHLs,Basis,and Uncontrollable load
in this AT worksheet are automatically entered from the HWA spreadsheet. This includes pollutant names in
columns AT through BK.
Pomw=>Town of Cleveland
NPDESiK> NC0049867
FLOW BOD TSS
Industry Type Renewal Modification Date Permit Limits Permit Limits Permit Limits
IUP INDUSTRY NAMES Permit Pipe of Effective Effective Permit Conc. Load Conc. Load
Count (please listalphabdidy) number number Industry Date Date Expires MGD $al/day mg/l lbs/day mg/I lbs/day
1 Daimler Trucks NA 0001 0002 433 07/01/18 06/30/20 0.1750 175,000 270.001 250.00
3
4
5
6
7
9
10
Column Totals=> 0.1750 175,0001 270 1 250
Basis=> NPDES Design Design
MAHL from HWA(lbs/day)=> NPDES Permitted Flow=> 0.2700 408 561
Uncontrollable Loading(lbs/day)=> . t 0.0430 92 144
Total Allowable for Industry(MAIL)(lbs/day)=> 0.2270 316 417
Total Permitted to Industry(lbs/day)=> 0.1750 270 250
MAIL left(lbs/day)=> 0.0520 46 167
Percent Allow.Ind.(MAIL)still available(%)=> 22.9% 14.5% 40.0%
Percent MAHL still available(%)=> 19.3% 11.2% 29.7%
5 Percent MAHL(lbs/day)=> 0.0135 20 28
HWA.AT
Revised:November 2005

Workbook Name : HWA AT Printed: 1/28/2019, 3:32 PM
_2018.x1sx, Worksheet Name: AT Page 2 of 5
Allocation Table
Headworks last approved: 01/28/19
Allocation Table updated: 09/20/18
Permits last modified: 07/01/18
POTW=>Town of Cleveland
NPDES4#> NC0049867
Ammonia Arsenic Cadmium Chromium Copper Cyanide
Industry Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits
IUP INDUSTRY NAMES Permit Pipe '' Conc. ` Load Conc. Load Conc. Load Conc. Load Conc. Load Conc. Load
Count (please listalphabetticly) number number mg/I lbs/day mg/1 lbs/day mg/I lbs/day mg/I lbs/day mg/I lbs/day mg/1 lbs/day
I Daimler Trucks NA 0001 0002 75.00 109.46 0.7800 1.1384
2
3
4
l
5
6 ,
7 I - - --
8
9 --4,
10
Column Totals=> 109 0.0000 0.0000 0.0000 1.1384 0.0000
Sludge Sludge AS/Nit/TF Sludge AS/Nit/TF
Basis=> NPDES Ceiling Ceiling inhibition Ceiling inhibition
MAHL from HWA(lbs/day)=> 182.84 0.0055 0.0042 0.3962 0.1972 0.1006
Uncontrollable Loading(lbs/day)=> 9.68 0.0008 0.0011 0.0012 0.0102 0.0011
Total Allowable for Industry(MAIL)(lbs/day)=> 173.16 0.0047 0.0031 0.3950 0.1871 0.0994
Total Permitted to Industry(lbs/day)=> 109.46 0.0000 0.0000 0.0000 1.1384 0.0000
MAIL left(lbs/day)=> 63.70 0.0047 0.0031 0.3950 -0.9514 0.0994
Percent Allow.Ind.(MAIL)still available(%)=> 36.8% 100.0% 100.0% 100.0% -508.6% 100.0%
Percent MAHL still available(%)=> 34.8% 85.6% 74.2% 99.7% 98.9%
5 Percent MAHL(lbs/day)=> 9.14 0.0003' 0.0002 0.0198 0.0099 0.0050
HWA.AT
Revised:November 2005

Workbook Name : HWA AT 2018.xlsx, Worksheet Name: AT Printed: 1/28/2019,3:32 PM
- - Page3of5
Allocation Table
Headworks last approved: 01/28/19
Allocation Table updated: 09/20/18
Permits last modified: 07/01/18 I
POTW=>Town of Cleveland
NPDES#>NC0049867
,. ,Lead Mercury Molybdenum Nickel Selenium I Silver
Industry Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits Permit Limi
IUP INDUSTRY NAMES Permit Pipe Conc. Load Conc. Load Conc. Load Conc. Load Conc. Load ' Conc.
Count (please ligalphabGidy) number number mg/I lbs/day mg/I lbs/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/I
1 Daimler Trucks NA 0001 0002 _
2
3 I _~-
4
5 _ ,
6
7 -♦
8 1 6
9
10
Column Totals=> I 0.0000 10.000000 0.0000 0.0000 I 0.0000,
Sludge Sludge Sludge Sludge Sludge
Basis=> Ceiling Ceiling Ceiling Ceiling Ceiling
MAHL from HWA(lbs/day)=> 0.0452 0.001917 0.0075 0.0328 0.0066
Uncontrollable Loading(lbs/day)=> 0.0007 0.000165 0.0007 0.0013 0.0009
Total Allowable for Industry(MAIL)(lbs/day)=> 0.0445 0.001752 0.0067 0.0316 0.0057
Total Permitted to Industry(lbs/day)_> 0.0000 0.000000 0.0000 0.0000 0.0000
MAIL left(lbs/day)=> 0.0445 0.001752 0.0067 0.0316 0.0057
Percent Allow.Ind.(MAIL)still available(%)=> 100.0% 100.0% 100.0% 100.0% 100.0%
(%) 0 % o 0 0
Percent MAHL still available => 98.4 /0 91.4 /0 90.4 /0 96.2 /0 86.4 /o
5 Percent MAHL(lbs/day)=> t • 0.0023 0.000096 0.0004 0.0016 0.0003
HWA.AT
Revised:November 2005

Workbook Name : HWA AT_2018.xlsx, Worksheet Name: AT Printed: 1/28/2019,3:32 PM
Page 4 of 5
Allocation Table
Headworks last approved: 01/28/19
Allocation Table updated: 09/20/18
Permits last modified: 07/01/18
Po-w.,Town of Cleveland
NPDESi >NC0049867 __
Zinc Total Nitrogen Total Phos. c d e
Industry Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits
IUP INDUSTRY NAMES Permit Pipe Conc. Load Conc. Load Conc. Load Conc. Load Conc. Load Conc. Load
Count (please hst alphabeticly) number number mg/I lbs/day mg/I lbs/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/I lbs/day
1 Daimler Trucks NA 0001 0002 i 0.5570 0.81291
2
3
4
--�5 --+
7
10
Column Totals=> 0.8129 0.00 0.00 0.0000 1 0.0000 0.0000
Sludge
Basis=> Ceiling
MAHL from HWA(lbs/day)=> 0.4587
Uncontrollable Loading(lbs/day)=> 0.0172
Total Allowable for Industry(MAIL)(lbs/day)=> 0.4415
Total Permitted to Industry(lbs/day)=> 0.8129 0.00 0.00 0.0000 0.0000 0.0000
MAIL left(lbs/day)=> -0.3715
Percent Allow.Ind.(MAIL)still available(%)=> -84.1 % ####### #t###### ####### #Itt/Ntltltlt #Itlilit#Ett#
Percent MAHL still available(%)=> -$0% I/INlltltll# ####### ###4t### ####### IININIIIINt
5 Percent MAHL(lbs/day)=> 0.0229
HWA.AT
Revised:November 2005

Removal Rate Calculations
FLOW BOD TSS AMMONIA
Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in
Sample Date mgd < mg/L Calculation < mg/L Calculation < m L Calculation < m L Calculation i
m• L Calculation <MI
8/1/2017 Spreadsheet 0.1372 178.4 178.4 4.136 4.136 203.4 203.4 5.421 5.421 111--
Instructions: Lsw. 15.23 15.23 la 0.5
August 2017 stmp 1) Data
9/1/2017 entered only 0.12345 270.5 270.5 4.75 4.75 238.5 238.5 238.5 3.896 3.896 •--iO 0.5
in Heavy
10/1/2017 Bordered 0.11497 232.8 232.8 2.75 2.75 258.75 258.75 4.575 4.575 •--IS 0.5
cells. Rest of
October stmp worksheet is y j • 26.43 26.43 121 0.5
11/1/2017 protected, 0.09411 381.4 3.2 3.2 289.6 289.6 2.122 2.122 -- 0.355
password is .--.
12/1/2017 2 0.09228 364.3 364.3 5.65 5.65 162.75 162.75 3.93 3.93 0.405
A
Dec PPA 2) For below III--iO 0.04
1/1/2018 detection 0.10062 234.2 234.2 6.202 6.202 660.4 660.4 9.514 9.514 --II 1.027
data,enter"<"
2/1/2018 in"<"column, 0.11796 297.5 297.5 5.838 5.838 569.5 569.5 3.15 3.15 II--I 2.82
3/1/2018 de ection level 0.12287 184.2 184.2 7.64 7.64 501 501 2.4 2.4 I--II 4.9
4/1/2018 inffluen inflenttmgo/Ir 0.11543 288.75 288.75 13.54 13.54 581.25 581.25 9.03 9.03 --II 3.048
I E
5/1/2018 columns. 0.14243 213.8 213.8 6.62 6.62 591.6 591.6 5.37 5.37 -- 0.0936
Spreadsheet
May STMP will auto- II 30.8 30.8 Q 0.1
6/1/2018 matcalcicallyulate0.1304 201.5 201.5 6.77 6.77 221 221 4.925 4.925 -- 0.052
June STMP averages and . 35.6 35.6 iO 0.1
removal rates �ommimmo
7/1/2018 using 1/2 0.1553 225 225 7.0125 7.0125 545 545 5.8 5.8 -- 0.459
value entered. .--.
3)Document ,•- III
choiceremov Rate .--.
choice _
4)Formulas in I- -
-II
-
Column Averages=> Compre-hensive Guide 0.120585 256.03 1 6.18 401.90 5.01 27.02
g
HWA Chapter, Unpaired Site Specific RR=> 97.59% Unpaired Site Specific RR=> 98.75% Unpaired Site Specific RR=>
Section E. P P P P P P
page 1. Literature/Default RR=> 85.00 /o° Literature/Default RR=> 85.00% Literature/Default RR=>
(I % of data is BDL 0 % of data is BDL 35 % of data is BDL
RR for this HWA > 97.59% RR for this HWA=> 98.75% RR for this HWA=>
„ i i I6
RR Cleveland 2018_PERCS.xlsx
Removal Rates
Page 1 of 7 pages
1/28/2019, 3:35 PM
Revision:August 1999

Removal Rate Calculations
ARSENIC CADMIUM CHROMIUM
Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date < m_ L Calculation < in: L Calculation < m•/L Calculation < m! L Calculation < m• L Calculation < m: L Calculation
8/1/2017
August 2017 stmp < 0.005 0.0025 < 0.005 0.0025 0.0018 0.0018 0.0015 0.0015 0.003 < - 0.001
9/1/2017 ;
10/1/2017
October stmp < 0.0025 0.00125 < 0.0025 0.00125 0.0017 0.0017 0.0016 0.0016 I 0.003 0.003 < 0.002 0.001
11/1/2017
12/1/2017
Dec PPA < 0.005 0.0025 < 0.001 0.0005 < 0.005 0.0025
1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
May STMP < 0.005 0.0025 < 0.005 0.0025 <' 0.001 < 0.002 0.001 < 0.005 0.0025 < 0.005 0.0025
6/1/2018
June STMP < 0.005 0.0025 < 0.005 0.0025 < 0.002 0.001 < 0.002 0.001 < 0.005 0.0025 0.009 0.009
7/1/2018
iinflMMMMEINM
Column Averages=> 0.0022 0.0023 0.0014 0.0011 0.0028 0.0032
Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=> 50%BDI
Literature/Default RR=> 45.00% Literature/Default RR=> 67.00% Literature/Default RR=> 82.00%
100 % of data is BDL 56 % of data is BDL 67 % of data is BDL
RR for i11Hs I IWA > 45.00% RR for this HWA=> 67.00% . RR for this HWA=> 82.00%
RR Cleveland 2018_PERCS.xlsx
Removal Rates
Page 2 of 7 pages
1/28/2019, 3:35 PM
Revision:August 1999

Removal Rate Calculations
COPPER CYANIDE LEAD
Influent Used in 111ffl
Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date < m_• L Calculation < Calculation < mg/L Calculation-< mg/L Calculation < mg/L Calculation < m L Calculation
8/1/2017
I I
August 2017 stmp 0.062 0.062 0.021 0.021 0.007 0.007 0.007 0.007 0.003 0.003 < 0.0025 0.00125
9/1/2017 0 NIninel 11,
10/1/2017
October stmp 0.057 0.057 0.023 0.023 < 0.005 0.0025 0.005 0.005 0.0034 0.0034 < 0.0025 0.00125
11/1/2017
12/1/2017
Dec PPA +..1r 0.011 0.011 < 0.005 < 0.005 0.0025
I1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
May STMP 0.053 0.015 0.015 < 0.005 0.0025 < 0.005 0.0025 < 0.005 0.0025 < 0.005 0.0025
6/1/2018 �.. .
June STMP 0.05 0.05 0.01 0.01 < 0.005 0.0025 < 0.005 0.0025 I< 0.002 0.001 < 0.002 0.001
7/1/2018
1
_-Column Averages=> 0.0563 0.0160 0.0036 0.0039 0.0025 0.0017
Unpaired Site Specific RR=> 71.60% Unpaired Site Specific RR=>'50%BDL Unpaired Site Specific RR=> 50%BDI
Literature/Default RR=> 86.00% Literature/Default RR=> 69.00% Literature/Default RR=> 61.00%
0 % of data is BDL 67 % of data is BDL 78 % of data is BDL
RR tiff:iii, HWA-> 71.60% RR for this HWA=> 69.00% RR for this HWA 61.00%
f i
RR Cleveland 2018_PERCS.xlsx
Removal Rates
Page 3 of 7 pages
1/28/2019, 3:35 PM
Revision:August 1999

Removal Rate Calculations
MERCURY MOLYBDENUM
Influent Used in - Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date < m: L Calculation < Calculation < in: L Calculation < m• L Calculation < m L Calculation < m L Calculation
8/1/2017
August 2017 stmp <0.0� 0.0001 3.94E-06 3.94E-06 < 0.0025 0.00125 0.00266 0.00266 0.0048 0.0048 0.0038 0.0038
9/1/2017
..ice I
10/1/2017
October stmp � 0.0004 0.0004 5.47E-06 5.47E-06 I< 0.0025 0.00125 0.00279 0.00279 0.0036 0.0036 0.0059 0.0059
11/1/2017
12/1/2017
Dec PPA
`�� 111 .........., < 0.01 0.005
1/1/2018 ~r mmi -
�.....: .•� l.M.MMW _
2/1/2018
3/1/2018 I
I t
4/1/2018
IIMMI IMIIMMINIMIII• I -
5/1/2018
May STMP 0.0002 0.0002 < 0.005 0.0025 < 0.005 0.0025 0.0025 < 0.005 0.0025
m .- I
6/1/2018
June STMP 0.0002 0.0002 6.35E-06 6.35E-06 < 0.005 0.0025 < 0.005 0.0025 0.003 0.003 0.002 0.002
7/1/2018
Column Averages=> L 0.00023 0.00001 0.0019 0.0026 0.0035 0.0038
, Unpaired Site Specific RR=> 97.67% Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=> -10.50%
Literature/Default RR=> 60.00% Literature/Default RR=> 33.00% Literature/Default RR=> 42.00%
14 of data is BDL 75 % of data is BDL 33 % of data is BDL
RR for Nu, HWA=> 97.67% RR for this HWA=> 33.00% RR for this HWA= = 42.00%
RR Cleveland 2018_PERCS.xlsx
Removal Rates
Page 4 of 7 pages
1/28/2019, 3:35 PM
Revision:August 1999

Removal Rate Calculations
SELEN M SILVER ZINC
Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date < mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation
8/1/2017
August 2017 stmp < 0.005 0.0025 < 0.005 0.0025 < 0.0025 0.00125 <• 0.0025 0.00125 0.1 0.1 0.043 0.043
9/1/2017
10/1/2017
October stmp < 0.005 0.0025 < 0.005 0.0025 < 0.0025 0.00125 <, 0.0025 0.00125 0.116 0.116 0.051 0.051
MEr
11/1/2017
12/1/2017
Dec PPA < 0.01 0.005 < 0.005 0.0025 0.054 0.054
1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
May STMP < 0.005 0.0025 < 0.005 0.0025 0.0025 < 0.005 0.0025 0.17 0.17 0.092 0.092
6/1/2018
June STMP < 0.005 0.0025 < 0.0,05 0.0025 < 0.002 0.001 < 0.002 0.001 0.12 0.12 0.053 0.053
7/1/2018
Column Averages=> 0.0025 0.0030 0.0015 0.0017 0.1265 0.0586
Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=> 53.68%
Literature/Default RR=> 50.00% Literature/Default RR=> 75.00% Literature/Default RR=> 79.00%
100 % of data is BDL 100 % of data is BDL 0 % of data is BDL
RR for HWA > 50.00% RR forthisHWA=> 75.00% RR for this HWA=> 53.68%
RR Cleveland 2018_PERCS.xlsx
Removal Rates
Page 5 of 7 pages
1/28/2019, 3:35 PM
Revision:August 1999

Removal Rate Calculations
.
Oil &Grease
Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date < mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation
8/1/2017 < 5.3 2.65 22.7 22.7 4.5 4.5
August 2017 stmp _
9/1/2017 < 5.2 2.6 34.24 34.24 4.8 4.8
10/1/2017 < 5.5 2.75 32.35 32.35 5.1 5.1
October stmp
11/1/2017 < 5.27 2.635 32.4 32.4 4.5 4.5
12/1/2017 < 5.4 2.7 27.79 27.79 4.4 4.4
Dec PPA < 5 2.5
1/1/2018 < 5 2.5 37.2 37.2 4.9 4.9
•
2/1/2018 < 5 2.5 15.8 15.8 4.25 4.25
3/1/2018 < 5 2.5 31.4 31.4 3.36 3.36
4/1/2018 15.15 15.15 +� 39.3 39.3 3.84 3.84
5/1/2018 ...1 < 5 2.5 39.1 39.1 �� 3.5 3.5
-May STMP 16.3 16.3 <<-, 5 ; ,;2.5
6/1/2018 < 5 2.5 37 37 9.38 9.38
II IMII,
June STMP 13.7 13.7 < 5 2.5
7/1/2018 < 5 2.5 35.5 35.5 2.22 2.22
Column Averages=> 15.0000 3.3990 32.0650 4.5625
Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=>II Unpaired Site Specific RR=>
Literature/Default RR=>II Literature/Default RR=>II Literature/Default RR=>II
82 % of data is BDL 0 % of data is BDL 0 % of data is BDL
RR for illis HWA=>� RR for this HWA=>II RR for this HWA=>II
RR Cleveland 2018_PERCS.xlsx
Removal Rates
Page 6 of 7 pages
1/28/2019, 3:35 PM a '
•
Revision:August 1999

SIU.Uncont.Mass.Bal
N FLOW BOD TSS AMMONIA ARSENIC
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 DAIMLER 0.07747 77,470 167.66 108.33 177.91 114.95 19.44 12.5602 0.005 0.0032
2
3 ,• . . -
4
5 _
6
7
9
10
11
12 -
13 i l +�
Sum of Industrial Loading(lbs/day)_>� 0.07751 77470 108.3251 114.9476 12.5602 0.0032
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)_>I 0.120581 120,5801 2561 257.441 4021 404.271 271 27.15221 0.0022 0.0022
Uncontrollable Load from Mass Bal(lbs/day)=> 0.0431 149.1180 289.3185 14.5920 -0.0010
Uncontrollable Concen. from Mass Bal(mg/L)=> 4151 I 8051 I 40.61 I -0.00281
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> 229 82.33 500 179.77 32.5 11.68 0.001961 0.0007
Uncontrollable Concen. From Literature(mg/L)_> ( 2501 I 2501 251 I 0.003I
Uncontrollable conc.to be used in HWA(mg/I,)_> 256 402 27 0.0022
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
SIU MASS BAL 1718_PERCS.xls
SIU.Uncont.Mass.Bal
Page 1 of 5 pages
1/28/2019,3:37 PM
Revision:August 1999

SIU.Uncont.Mass.Bal
N FLOW CADMIUM CHROMIUM COPPER CYANIDE
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count I (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 DAIMLER 0.07747 77,470 0.0005 0.0003 0.0025 0.0016 0.0718 0.0464 0.0038 0.0025
2
3 ...
4 i
5
6
-__., 1
7
8 -
9
10
�-.
11 _
12 _
13
Sum of Industrial Loading(lbs/day)=> 0.07751 77470 0.0003 1 0.0016 1 0.0464 0.0025
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day _ mg/1 lbs/day
Avg Influent loading(lbs/day)=> 0.120581 120,580 0.0014� 0.0014 0.0028� 0.0028 0.0563� 0.0566 0.0036� 0.0036
Uncontrollable Load from Mass Bal(lbs/day)=> 0.0431 0.0011 0.0012 0.0102 0.0012
Uncontrollable Concen. from Mass Bal(mg/L)=> ( 0.00301 I 0.00331 1 0.0284I I 0.00321
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> 0.000655 0.0002 0.00295 0.0011 0.0459 0.0165 0.00262J 0.0009
Uncontrollable Concen.From Literature(mg/L)_> ( 0.0031 1 0.05J I 0.0611 I 0.0411
Uncontrollable conc.to be used in HWA(mg/I.)_> 0.003 0.0033 0.0284 0.0032
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
SIU MASS BAL 1718_PERCS.xls
SIU.Uncont.Mass.Bal
Page 2 of 5 pages
1/28/2019,3:37 PM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW LEAD MERCURY MOLYBDENUM NICKEL
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (please list alphabetically) number MGD gal/day I mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 DAIMLER 0.07747 77,470 0.0028 0.0018 0.0001 0.00006 0.0028 0.0018 0.005 0.0032
2
3
4
5
6
7
8
9
10
11
12 ( -�
13
Sum of Industrial Loading(lbs/day)=> 0.0775 774701 1 0.0018 0.00006 I 0.0018 0.0032
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/I lbs/day
Avg Influent loading(lbs/day)=> 0.120581 120,580 0.0025� 0.0025 0.00023� 0.00023 0.0019� 0.0419 0.0035� 0.0035
Uncontrollable Load from Mass Bal(lbs/day)=> 0.0431 0.0007 0.00017 0.0001 0.0003
Uncontrollable Concen. from Mass Bal(mg/L)=> 0.00201 1 0.000461 I 0.00031 r 0.00081
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> 0.0013 0.0005 0.000655 0.0002 0.2723 0.0979 0.0043 0.0015
Uncontrollable Concen. From Literature(mg/L)_> I 0.0491 I 0.00031 I I r 0.0211
Uncontrollable conc.to be used in HWA(mg'►.)_> 0.002 0.00046 0.002 0.0035
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
SIU MASS BAL 1718_PERCS.xls
SIU.Uncont.Mass.Bal
Page 3 of 5 pages
1/28/2019,3:37 PM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW SELENIUM SILVER ZINC Oil &Grease
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge _ Average Discharge
IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 DAIMLER 0.07747 77,470 0.0049 0.0032 0.0028 0.0018 0.1702 0.1101 20.17 13.0318
2
3
4 I
5
6
7
8
9
10
11
12
13
Sum of Industrial Loading(lbs/day)_> 0.0775 77470 0.0032 ' 0.0018 0.1100 I 13.0318
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)=> 0.12058 120,580 0.0025 0.0025 0.0015 0.0015 0.1265 0.1272 15 15.0846
Uncontrollable Load from Mass Bal(lbs/day)=> 0.0431 -0.0007 -0.0003 0.0172, 2.0527
Uncontrollable Concen. from Mass Bal(mg/L)=> I -0.00181 I -0.00081 I 0.04801 r 5.70941
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> 0.00262 0.0009 0.0013 0.0005 0.0013 0.0005
Uncontrollable Concen.From Literature(mg/L)=> I I I 0.0051 I 0.1751 I 501
Uncontrollable conc.to be used in HWA(mg i i > 0.0025 0.0015 0.048
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
SIU MASS BAL 1718_PERCS.xls
SIU.Uncont.Mass.Bal
Page 4 of 5 pages
1/28/2019,3:37 PM • •
Revision:August 1999