NC0020559_Headworks Analysis_20190806

4
A* CITY OF HENDERSON
�., k l iv: Water Reclamation Facility
k .,r.
p �� Post Office Box 1434�'if p\'' Henderson,North Carolina 27536-1434
C Ate-" Phone: [phone] FAX: [phone]
Shipping Address-1646 West Andrews Avenue,Henderson NC 27537
August 6th, 2019
CERTIFIED MAIL-RECEIPT REQUESTED RECE1VED/NCDE®/D1NR
MONTI HASSAN AUG 12 2019
PERCS UNIT
ater QUal
NCDENR---DWQ Permitting Sec on
1617 MAIL SERVICE CENTER
RALEIGH,NC 27699-1617
Re: Submission of City of Henderson Water Reclamation Facility Headworks Analysis Revision
for Dissolved Metal
NC0020559
Dear Mr. Hassan:
I am sending though email attachments our Headworks Analysis Revision for dissolved metals
for the City of Henderson.Hard copies of all revised forms are also being mailed. Revisions on
all worksheets are highlighted in green.
If you have questions or need additional information please contact me at 252-431-6085 or
Lamont Allen at 252-431-6081.
Sincerely,
Cn -
Darrel Jo on
City of Henderson Pre-treatment Coordinator
v
C: Lamont Allen,Henderson WRF Director

HWA Narrative Dissolved Metal Revision
Stream Standard Assignment
1) Arsenic-Used 0.01 mg/L Human Health Limit for stream standard
2) Cadmium-Used 0.0017 mg/L calculator for stream standard
3) Chromium-Used 0.011 mg/L Chrome VI stream standard
4) Copper- Used permit limit of 0.0267 mg/L
5) Lead-Used 0.0137 mg/L from calculator for stream standard.
6) Molybdenum-Used 0.16 mg/L from calculator.
7) Nickel—Used 0.121 mg/L from calculator
8) Silver—Used 0.00006 mg/L from calculator
9) Zinc—Used 0.408 mg/L from calculator
Resulting Over Allocations
1) Lead-This metal had a negative MAIL after inserting the new stream standard
from the calculator spreadsheet. Upon review of the Uncontrollable Mass
Balance spreadsheet, it is reasonable to apply the sampling value of 0.017 mg/L
rather than the literature value giving a MAIL value of 0.3784 lbs/day with 54.6%
remaining MAHL.
2) Silver- The calculator gives a stream standard of 0.00006 mg/L with a permit
limit of 0.000062 mg/L. Only 2 samples of influent have been analyzed at the new
lower PQL of 0.0005 mg/L(State lab PQL is 0.001 mg/L)with one non-detect
and one at 0.0008 mg/L. This limited data does not justify a zero uncontrollable
value. Three effluent samples have been analyzed at the PQL of 0.0005 mg/L
with all three non-detect. Within the limitations of the method it can be assumed
that the effluent is meeting the probable permit level and so the Allocation Table
remains with a negative MAIL with no possible allocation to industry.

Calculator: Estimate NPDES Permit Limitations based on the Dissolved Water
Quality Standards and Stream & Effluent Hardness
FACILITY: PERMIT#: DATE: CALC BY:
Henderson WRF I NC0020559 7/22/2019 - DJ
Average Stream Flow Receiving Receiving Rec Stream NPDES Total IWC-Instream IWC-Instream
g Total Average
Stream Stream Hardness Wastewater Wastewater Average Effluent
(CFS) summer summer 1Q10 Flow Limit Suspended (CaCO3, Concentration Concentration Upstream Hardness
7010(CFS) 7Q10(MGD)_ [MGD] [MGD] Solids(mg/L) mq/L) (Chronic) (Acute) Hardness
3.50 I 0.20 0.1290 0.111 4.14 10.00 100 0.97 I 73.201 101.25�
Class C,C-NSW,C-Swamp,and B streams HQW streams
2 3 4 5 6 7 8 9 10
Dissolved Water Quality Translators- Estimated H•DES F tip IaFt ES
using EPA Total Metal (allocated to
(P v@&L;r.lt [Total Namara 0 3 or, [Total
Criteria (function of total Default permittee)Diss Metal+Translator
hardness) Metal+IWC) Metal 4,IWC1
Partition
Chronic Acute Coefficients Chronic Acute Chewed Acute Meanie Ad,,
PARAMETER* rug/I] [ugll] (streams) rug/I] [ugh]] I(•1 lugn" lugI
Arsenic 150 340 1.000 150 340 154.66 349a06 77„34 174,53
Arsenic(HH/WS) 10 N/A 1.000 10 N/A 15.45 N/A 5.15 NIA
Beryllium 6.5 65 1.000 6.5 65 6.70 .66.73 3.35 33,37
Cadmium(a) 0.43 2 75 0 252 1.6856 10.8908 1.738 11.L8 9.9 5,59
Chlorides(WS) 250000 N/A 1.000 250000 N/A 257792 N/A 128895.9 WA
Chromium III(a) 74 572 0.202 367.6303 2826.198 379.1 2901.53 189.5 1450976
Chromium VI 11 16 1.000 11 16 11.3 16.43 5,7 8.21
Chromium,Total N/A N/A N/A N/A N/A N/A N/A ,J A N/A
Copper(a) 9.0 13.5 0.348 25.8530 38.8090 26,7 39.84 13.3 19.92
Cyanide 5.0 22.0 1.000 5.0000 22.0000 5.2 22,59 2.5 11.29
Flouride 1800.0 N/A 1.000 1800.0 N/A 1856.1 N/A 928.1 N/A
Lead(a) 2.53 65 0.184 13.7447 352.7122 14.17 362.11 7.09 131,96
Mercury 0.012000 N/A 1.000 0.012000 N/A 0.012374 N/A 0,0061879 NIA
Molybdenum(WS) 160.00 N/A 1.000 160.0000 N/A 164.99 N/A 82.49 WA
Nickel(a)** 52 470 0.432 120.7052 1086.7577 124 1115,72 _ 62 557,86
Nickel(WS) 25 N/A 1.000 25.0000 N/A 26 N/A 13 NIA
Selenium 5 56 1 000 5.0000 56.0000 5.2 57.49 3 28,75
Silver(a) 0.06 ,3.24 1.000 0.06 3.2390 0,062 3,33 '9.93 1.86
Zinc(a) 119 118 0.288 411.6174 408.2777 424 419.16 212 209.58
Cadmium(trout streams) I 0 43 0.511 0.2521 1.69 2.021 1,71 2,07 I 0.87 1.04
Ia. Denotes metals for which Aquatic Life Criteria are expressed as a function of total hardness.
*Arsenic has a Human Health standard of 10 ug/L is more stingent than the freshwater standards. The Permit limit
for arsenic would be determined by taking the Human Health Standard and dividing it by an IWC based on the mean
annual flow of the receiving stream and the permitted plant flow.
IIWC=Permitted Flow-(Permitted Flow+mean annual average)
**Nickel has a Water Supply standard of 25 ug/L and in most cases is more stringent than the freshwater standard.
The Permit limit for nickel using the 25 ug/L WS standard would be determined by dividing 25 by an IWC based on

Workbook Name: Copyof Henderson HWA AT Dissolved Metal Criteria; Worksheet Name: H�`/A��,p Page 1 of
PrlhfeU 8/6/2019,8 25 AM
I A I B I C I D I E I F I G I H I 1 I J I K
1 Headworks Analysis Spreadsheet Spreadsheet Instructions:
2 POTW Name. Henderson WRF 1) Applicable Values should be entered in the Heavy Bordered Blue cells The rest of worksheet is
3 Date• 8/2/2019 protected,password is"2".
4, POTW NPDES#_> NC0020559 2) Additional pollutants can be added in cells A34 to A42 Note all Pollutant names are linked from here
5 POTW Sludge Permit#_>WQ0000838(Granville Farms) to other pages in HWA worksheet and also to AT worksheet(i.e.,automatically entered into other pages
-IT in HWA worksheet and also AT worksheet from HWA worksheet).
7 POTW NPDES Permitted Flow(MGD)= 4.14 .<=usedmAT only 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter.
8 POTW Average Flow(MGD) 2 2348 <=used in HWA calculations 4) HWA,AT and HASL worksheets are linked. MAHL5,Basis,and Uncontrollable load are automatically
entered into AT from this worksheet
9 Uncontrollable Flow(MGD)=® 5)If red tab notes are not visible,they can be turned on in the"Tools"menu under"options",in the
10 7Q10 Stream Flow(MGD)= 0 13 "view"tab click the"comment indicator only"button
11 Stream Classification= 0
13 Class of Sludge generated(A,or 13) B
14 Sludge to Digestor Flow(MGD)= Through calc for different POTW use Design
15 Sludge to Disposal Flow(MGD)= 0.0084 flows Criteria
16 %Solids to Disposal= 5 49 Average Flow Permitted Flow Loading
17 Sludge Site Area(acres)= 203 17 WWTF Influent BOD(mg/1) 270 392 2 211.7
18 Sludge Site Life(yrs)= 50 WWTF Influent TSS(mg/I) 300 1676.0 • 904.7 x
19 Age of Sludge Site(yrs)= 30 WWTF Influent NH3(mg/1) 30 161 3 87.1 x
20 WWTF Influent TKN(mg/I) 35 x
21 Pass-Through Loading Calculations WWTF Influent Total P(mg/1) 7 23 5 12.7 x
...LOU. 011.11.1.1111111
Stream Standard Pass-Thru Minimum
NPDES LIMIT Plant Removal Rate Removal rate NPDES Loading Standard Stream Standard Loading Design Criteria Loading Pass-Thru
23 Pollutant (mg/I) (%) Source (lbs/day) (mg/1) Source (lbs/day) Loading(lbs/day) (Ibs/day) Basis
24 BOD 6 98.47 DMR 7,309 9,322 7,309 NPDES
25 TSS 30 98 21 DMR 31,237 10,358 10,358 Design
26 Ammonia 3 98.14 DMR&LTMP 3,006 1,036 1,036 Design
27 Arsenic 45 literature 01.01l HIAIRISME,g4n 0.3586 0 3586 Stream Std
28 Cadmium 67 literature AtifiiiMOTOOlg Galculator 0.1016 0.1016 Stream Std
29 Chromium 82 literature O101+11 Glirome iMISMBIE 1 2053 1 2053 Stream Std
30 Copper 51 0T0267 93 19 LTMP Data 7.3075 7 3075 NPDES
31 Cyanide
32 Lead 61 literature 0r0,l1317,GgIF.051611111111111111 0.6928 0.6928 Stream Std
33 Mercury 98.08 LTMP Data 0.000012 Aquatic Life 0.01233 0 01233 Stream Std
34 Molybdenum 33 literature 01lr6•
:alEulator 4.7098 4.7098 Stream Std
....
35 Nickel 42 literature 1460010,2111 Galculator 4 1145 4.1145 Stream Std
36 Selenium 50 literature 0 005 Aquatic Life 0.1972 0 1972 Stream Std
37 Silver 75 literature INE10100006 Galculator 0.0047 0.0047 Stream Std
38 Zinc 70.66 LTMP Data EiENDT,408'eilF11515U-111111111111 27 4259 27.4259 Stream Std
39 TKN 98.78 LTMP Data 1208 47 1208 466 Design
40 Total Phos. 1 95.75 DMR&LTMP 438 55 241.69 241.693 Design
41
42
43
44
45
46
47
Modeled after Chapter 5-HWA Guidance,Appendix 5-A
Revision Date' February 2008

Workbook Name: Copyof Henderson HWA AT Dissolved Metal Criteria; Worksheet Name: HWA Page 2ot5
Prl►iTeTI 8/6/2019,8:25 AM
I A I B I C I D I E I F I G I H I I I J 1 K
49 Average Influent NH3(mg/I)
50 Average Anaerobic Digester NH3(mg/1)
51 Inhibition Loading Calculations only enter when have ANAEROBIC digester
A.S./Nit,/T.F. A.S./Nit,/T.F. A.S./Nit,/T.F. Minimum Minimum
Primary Inhibition Inhibition Inhibition Digestor Inhibition Inhibition
Removal Rate Primary Removal Concentration Concentration Loading Digestor Inhibition Inhibition Digestor Inhibition Loading Loading
52 Pollutant (%) Rate Source (mg/I) Source (lbs/day) Concentration(mg/I) Conc.Source Loading(Ibs/day) Obs/day) Source
53 BOD
54 TSS
55 Ammonia 480 Act Sludge 8946 3514 8946.35 AS/Nit1TF ir
56 Arsenic 0.1 Act Sludge - 1 8638 1.8638 AS/Nit/TF
57 Cadmium 1 Act Sludge 18 6382 18.6382 AS/NiVFF it
58 Chromium 0.394 Nitrification 7.3435 7.3435 AS/Nit/TF ir
59 Copper 1.393 Data 25.9631 25.9631 AS/Nit/IT ir
60 Cyanide
61 Lead 0.5 Nitrification 9.3191 9.3191 AS/Nit/TF it
62 Mercury 0.1 Act Sludge 1.8638 1.8638 AS/Nit/TF it
63 Molybdenum
64 Nickel 0.25 Nitrification 4.6596 4.6596 AS/Nit/TF u
65 Selenium
66 Silver 0.25 Act Sludge 4.6596 4.6596 AS/Nst/TF tr
67 Zinc 2.554 Data 47.6020 47.6020 AS/NIVPF ir
68 TKN
69 Total Phos
70
71
72
73
74
75
76
Modeled after.Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Workbook Name: Copyof Henderson HWA AT Dissolved Metal Criteria; Worksheet Name: HW Page 3 of 5
PrlhCe?J 8/6/2019,8:25 AM
I A I B I C I D I E I F I G I H I I IJIK
77
78 Sludge Loading Calculations
Sludge Ceiling Class A Limits Class A Limits Minimum Minimum
Sludge Ceiling Load Cumulative Sludge Cumulative Class A Limits Monthly Avg. Mon.Avg.Load. - Sludge Sludge
Concentration Sludge Ceiling Load -HASL Calc.- Rate Limit Sludge Loading Monthly Average Loading HASL Calc.- Loading Loading
7g Pollutant Limit(mg/kg) (lbs/day) (lbs/day) (lbs/(acre"life)) (lbs/day) Rate Limit(mg/kg) (lbs/day) (lbs/day) (lbs/day) Sorce
80 BOD
81 TSS
82 Ammonia
83 Arsenic 75 0.6410 36 0.8900 41 0.6410 Sludge Ceilis
84 Cadmium 85 0.4879 34 0 5646 39 0 4879 Sludge Ceilir
85 Chromium
86 Copper 4300 17 7467 1338 15 9739 1500 15.9739 Cumul Slud
87 Cyanide
88 Lead 840 5.2962 267 4 8697 300 4.8697 Cumul.Slud
89 Mercury 57 0.2235 15 01702 17 0 1702 Cumul Slud
_90 Molybdenum 75 0.8741 0.8741 Sludge Ceilu
91 Nickel 420 3.8461 374 9.9071 420 3.8461 Sludge Ceilii
92 Selenium 100 0.7692 89 1.9804 100 0.7692 Sludge Celli' _
93 Silver
94 Zinc 7500 40.8230 2498 39 3316 2800 39.3316 Cumul.Slud
95 TKN
96 Total Phos
97
98
99
100
101
102
103
104
•
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date February 2008

Workbook Name: Copyof Henderson HWA AT Dissolved Metal Criteria; Worksheet Name: H�,/A��I/A� Page 4of5
Pr�i eetl 8/6/2019,8.25 AM
I 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
iraatAnamma
I'1 Minimum Pass Minimum Minimum Minimum Allowable Maximum Allowable
Through Loading Inhibition Loading Inhibition Loading Sludge Loading Minimum Sludge Headworks Headworks Loading
106 (Ibs/day) Pass Through Source (lbs/day) Source (lbs/day) Loading Sorce Loading(lbs/day) Source
107 BOD 7309.1 NPDES 7309.1 NPDES
108 TSS 10358 3 Design 10358 3 Design
109 Ammonia 1035.8 Design 8946 3514 AS/Nit/TF inhibit 1035.8 Design
110 Arsenic 0 3586 Stream Std 1.8638 AS/Nit/IT rnhibiti 0.6410 Sludge Ceding 0 3586 Stream Std
111 Cadmium 0 1016 Stream Std 18 6382 AS/NitiTF inhibits 0 4879 Sludge Ceiling 0 1016 Stream Std
112 Chromium 1.2053 Stream Std 7 3435 AS/Nit/TF inhibits 1 2053 Stream Std
113 Copper 7 3075 NPDES 25.9631 AS/Nit/TF inhibit 15 9739 Cumul Sludge Loading 7 3075 NPDES
114 Cyanide I
115 Lead 0 6928 Stream Std 9.3191 AS/Nit/TF inhibit 4 8697 Cumul Sludge Loading 0 6928 Stream Std
116 Mercury 0 01233 Stream Std 1 8638 AS/Nit/TF inhibits 0 1702 Cumul.Sludge Loading 0 01233 Stream Std
117 Molybdenum 4 7098 Stream Std 0 8741 Sludge Ceiling 0 8741 Sludge Ceiling
118 Nickel 4.1145 Stream Std 4 6596 AS/Nit/TF inhibiti 3 8461 Sludge Ceiling 3 8461 Sludge Ceiling
119 Selenium 0.1972 Stream Std 0 7692 Sludge Ceiling 0.1972 Stream Std
120 Silver 0 0047 Stream Std 4 6596 AS/Nit/TF inhibiti 0 0047 Stream Std
121 Zinc 27.4259 Stream Std 47.6020 AS/Nit/TF inhibit 39.3316 Cumul Sludge Loading 27 4259 Stream Std
122 T1IN 1208 5 Design 1208 4660 Design
123 Total Phos 241 7 Design 241 6932 Design
124
125
126
127
128
129
130
131
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Workbook Name: Copyof Henderson HWA AT Dissolved Metal Criteria; Worksheet Name: H /� Page 5of5
��� 8/6/2019,8:25 AM
I A I B I C I D I E I F I G I H I I I J I K
132
133 Maximum Allowable Industrial Loadings Calculations
Maximum Maximum
Allowable Check to Use Uncontrollable Allowable
Headworks Loading HASL Cates Concentration Uncontrollable Uncontrollable Load Industrial Design vs.Pass-
134 Pollutant (lbs/day) MAHL Basis (x) (mg/1) Source (lbs/day) Load(lbs/day) Thru Warning
135 BOD 7309 1106 NPDES 198 Mass Balance 3661.4718 3647 6388
136 TSS 10358 2800 Design 237 Mass Balance 4382.6708 5975.6092
137 Ammonia 1035 8280 Design 20.9 Mass Balance 386 4887 649.3393
138 Arsenic 0 3586 Stream Std 0.005 Mass Balance 0 0925 0.2661
139 Cadmium 0 1016 Stream Std 0.003 Literature 0 0555 0 0461
140 Chromium 1 2053 Stream Std N/A 0 013 Mass Balance 0 2404 0 9649
141 Copper 7.3075 NPDES 0.052 Mass Balance 0 9616 6 3459
142 Cyanide N/A
143 Lead 0.6928 Stream Std - "•0.01:1SSn lin.r1 0.3144 0 3784
144 Mercury 0 01233 Stream Std 0.0003 Literature 0 00555 0 00678
145 Molybdenum 0 8741 Sludge Ceiling 0.003 Mass Balance 0.0555 0.8186
146 Nickel 3 8461 Sludge Ceilmg 0 011 Mass Balance 0 2034 3.6427
147 Selenium 0.1972 Stream Std 0.005 Sampling 0 0925 0.1048
148 Silver 0 0047 Stream Std N/A 0.003 Mass Balance 0 0555 -0 0507
149 Zmc 27.4259 Stream Std 0.128 Mass Balance 2 3670 25.0589
150 TKN 1208 4660 Design 33.7 Mass Balance 623 1899 585 2761
151 Total Phos 241 6932 Design 4 8 Mass Balance 88 7630 152 9302
152
153
154
155
156
157
158
Modeled after.Chapter 5-HWA Guidance,Appendix 5-A
Revision Date• February 2008

Copy of Henderson HWA AT Dissolved Metal Criteria,Worksheet Name: AT Printed: 8/6/2019, 8:25 AM
Page 1 of 5
Allocation Table Spreadsheet Instructions:
Headworks last approved:. 06/15/17 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.
Allocation Table updated: 08/02/19 3)HWA and AT worksheets in this workbook are linked. Pollutant Names,MAHLs,Basis,and Uncontrollable load in
Permits last modified: 09/11/17 this AT worksheet are automatically entered from the HWA spreadsheet. This includes pollutant names in columns AT
through BK.
PoTw=> Henderson WRF
NPDES#=> NC0020559
FLOW BOD
Industry Type Renewal Modification Date Permit Limits Permit Limits
IUP INDUSTRY NAMES Permit Pipe of Effective Effective Permit Conc. Load
Count (please hst alphabeticly) number number Industry Date Date Expires MGD gal/day mg/1 lbs/da
1 MARS PETCARE 0011 0001 Pet Food 04/03/17 06/01/17 04/03/22 0.0750 75,000 345.00 215.80
2
3
4
5
6
7
8
9
10
Column Totals=> I 0.0750 75,000 I 216
Basis=> NPDES NPDES
MAHL from HWA(lbs/day)=> NPDES Permitted Flow=> 4.1400 7309
Uncontrollable Loading(lbs/day)=> 2.2173 3661
Total Allowable for Industry(MAIL)(lbs/day)=> 1.9227 3648
Total Permitted to Industry(lbs/day)=> 0.0750 216
MAIL left(lbs/day)=> 1.8477 3432
Percent Allow.Ind. (MAIL)still available(%)=> 96.1 % 94.1 %
Percent MARL still available(%)=> 44.6% 47.0%
5 Percent MARL(lbs/day)=> 0.2070 365
HWA.AT
Revised:November 2005

Copy of Henderson HWA AT Dissolved Metal Criteria,Worksheet Name: AT Printed: 8/6/2019, 8:25 AM
Page 2 of 5
Allocation Table
Headworks last approved: 06/15/17.
Allocation Table updated: 08/02/19
Permits last modified: 09/11/17
po-rw=> Henderson WRF
NPDES#=> NC0020559
TSS Ammonia Arsenic Cadmium Chromium
Industry 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
Count i (please list alphabclic1y) number number mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 MARS PETCARE 0011 0001 340.00 212.6741=a
11
I
4 C
5
6
7
._ ® i
8
9
1 r-
0 Column Totals=> 1 213 01 I 0.00001 I 0.0000 1 0.0000
Stream Stream
Basis=> Design Design Stream Std Std Std
MARL,from HWA(lbs/day)=> 10358 1035.83 0.3586 0.1016 1.2053
Uncontrollable Loading(lbs/day)=> 4383 386.49 0.0925 0.0555 0.2404
Total Allowable for Industry(MAIL)(lbs/day)=> 5976 649.34 _ 0.2661 0.0461 0.9649
Total Permitted to Industry(lbs/day)=> 213 0.00 0.0000 0.0000 0.0000
MAIL left(lbs/day)=> 5763 649.34 _ 0.2661 0.0461 0.9649
Percent Allow.Ind. (MAIL)still available(%)=> 96.4% 100.0% 100.0% 100.0% 100.0%
Percent MARL still available(%)=> 55.6% 62.7% 74.2% 45.4% 80.1 %
5 Percent MAHL(lbs/day)=> 518 51.79 0.0179 0.0051 0.0603
HWA.AT
Revised:November 2005

Copy of Henderson HWA AT Dissolved Metal Criteria,Worksheet Name: AT Printed: 8/6/2019, 8:25 AM
Page 3 of 5
Allocation Table
Headworks last approved: 06/15/17
Allocation Table updated: 08/02/19
Permits last modified: 09/11/17
porw=> Henderson WRF
NPDES#=> NC0020559
Copper Cyanide Lead Mercury Molybdenum
Industry 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
Count (please hatalphabeticly) number number mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 MARS PETCARE 0011 0001 0.0750 0.0469
2
3 _
4
5
6
7
8
9
10
Column Totals=> 0.04691 0.0000 0.0000 I 0.000000J I 0.0000
Stream Sludge
Basis=> NPDES Std Stream Std Ceiling
MAIL from HWA(lbs/day)=> 7.3075 0.6928' 0.012327 0.8741
Uncontrollable Loading(lbs/day)=> 0.9616 0.3144 0.005548 0.0555
Total Allowable for Industry(MAIL)(lbs/day)=> 6.3459 0.3784 0.006779 0.8186
Total Permitted to Industry(lbs/day)=> 0.0469 0.0000 0.000000 0.0000
MAIL left(lbs/day)=> 6.2990 0.3784 0.006779 0.8186
Percent Allow.Ind. (MAIL)still available(%)=> 99.3% 100.0% 100.0% 100.0%
Percent MARL still available(%)=> 86.2% 54.6% 55.0% 93.7%
5 Percent MARL(lbs/day)=> 0.3654 0.0346 0.000616 0.0437
HWA.AT
Revised:November 2005

Copy of Henderson HWA AT Dissolved Metal Criteria,Worksheet Name: AT Printed: 8/6/2019, 8:25 AM
Page 4of5
Allocation Table
Headworks last approved: 06/15/17
Allocation Table updated: - 08/02/19e
Permits last modified: 09/11/17
Porw=> Henderson WRF
NPDES#=> NC0020559
Nickel Selenium Silver Zinc TKN
Industry 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
Count (please list alphabeticly) number number mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 MARS PETCARE 0011 0001 0.2100 0.1314 40.00 25.02
2
3
4
5
6
7
8
I
9 _
10 I
Column Totals=> 0.00001 0.00001 I 0.0000 1 0.13141 I 25.02
Sludge Stream Stream
Basis=> Ceiling Std Stream Std Std Design
MARL from HWA(lbs/day)=> 3.8461 0.1972 0.0047 27.4259 1208.4660
Uncontrollable Loading(lbs/day)=> 0.2034 0.0925 0.0555 2.3670 623.1899
Total Allowable for Industry(MAIL)(lbs/day)=> 3.6427 0.1048 -0.0507 25.0589 585.28
Total Permitted to Industry(lbs/day)=> 0.0000 0.0000 0.0000 0.1314 25.02
MAIL left(lbs/day)=> 3.6427 0.1048 -0.0507 24.9275 560.26
Percent Allow.hid. (MAIL)still available(%)=> 100.0% 100.0% 100.0% 99.5% 95.7%
Percent MARL still available(%)=> 94.7% 53.1 % -1072.0% 90.9% 46.4%
5 Percent MARL(lbs/day)=> 0.1923 0.0099 0.0002 1.3713 60.42
HWA.AT
Revised:November 2005

Copy of Henderson HWA AT Dissolved Metal Criteria,Worksheet Name:AT Printed: 8/6/2019, 8:25 AM
Page 5 of 5
Allocation Table
Headworks last approved: 06/15/17
Allocation Table updated: 08/02/19
Permits last modified: 09/11/17
POTw=> Henderson WRF
NPDES#=> NC0020559 _
Total Phos. COD Oil and Grease
Industry Permit Limits _Permit Limits Permit Limits
IUP INDUSTRY NAMES Permit Pipe Conc. Load Conc. Load Conc. Load
Count (please list aipiia icly) number number mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 MARS PETCARE 0011 0001 45.00 28.15 690.0000 431.60 75.0000 46.91
2
3
4
5
6
7
8
9
10
Column Totals=> 28.151 431.59501 46.9125
Basis=> Design
MARL from HWA(lbs/day)_> 241.69
Uncontrollable Loading(lbs/day)=> 88.76
Total Allowable for Industry(MAIL)(lbs/day)=> 152.93
Total Permitted to Industry(lbs/day)=> 28.15
MAIL left(lbs/day)=> 124.78
Percent Allow.Ind.(MAIL)still available(%)=> 81.6%
Percent MARL still available(%)=> 51.6%
5 Percent MARL(lbs/day)=> 12.0847
HWA.AT
Revised:November 2005

SIU.Uncont.Mass.Bal
FLOW BOD TSS AMMONIA
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe 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
1 IAMS 011/001 0.00761 7,610 174.5 11.08 131.5 8.35 5.4 0.3427
2 WALMART 016/001 0.0073 7,300 134 8.16 80 4.87 67.2 4.0913
3 SEMPRIUS 017/001 0.0026 2,600 1.8 0.04 8.4 0.18 0.2 0.0043
4
5
6
7
8
9
10 _
11
12
13
Sum of Industrial Loading(lbs/day)=> 0.01751 17510 1 19.2723 1 13.3987 4.4383
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)=> 2.234812,234,800f 197.00000� 3671.73 236 4398.62 21 391.4029
Uncontrollable Load from Mass Bal(lbs/day)=> 2.2173 3,652.4594 4,385.2241 386.9645
Uncontrollable Concen.from Mass Bal(mg/L)=> I 1981 r 2371 I20.91
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> 4801 _ 8876.26 825 15256.06
Uncontrollable Concen.From Literature(mg/L)_> I 2501 I 2501 I 251
Uncontrollable conc.to be used in IWA(mg/L)®> 198 237 20.9
Spreadsheet Instructions: M M M
1)Applicable Values should be entered in the Heavy Bordered cells Rest of worksheet is
protected,password is^2^ Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrol
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. From "Mass Balance"(row 25),
Uncontrollable Mass Balance Spreadsheet(1)Dissolved Metals
SIU.Uncont.Mass.Bal
Page 1 of 6 pages
8/6/2019,8:26 AM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW ARSENIC CADMIUM CHROMIUM COPPER
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 IAMS 011/001 0.00761 7,610 0.005 0.0003 0.001 0.0001 0.003 0.0002 0.044 0.0028
2 WALMART 016/001 0.0073 7,300 0.005 0.0003 0.001 0.0001 0.003 0.0002 0.046 0.0028
3 SEMPRIUS 017/001 0.0026 2,600 0.005 0.0001 0.001 0.0000 0.003 0.0001 0.014 0.0003
4
5
6
7
8 -
9
10
11
12
13
i
Sum of Industrial Loading(lbs/day)=> 0.01751 17510 I 0.0007 0.0001 I 0.0004 0.0059
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)=> 2.2348 2,234,800 0.0051 0.0932 0.001� 0.0186 0.013f 0.2423' 0.052 0.9692
Uncontrollable Load from Mass Bal(lbs/day)=> 2.2173 0.0925 0.0185 0.2419 0.9633
Uncontrollable Concen.from Mass Bal(mg/L)=> I 0.00501 0.00101 I 0.0131 I 0.0521
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> 0.005 0.0925 0.002 0.0370 0.010 0.1849 0.180 3.3286
Uncontrollable Concen.From Literature(mg/L)_> I 0.003I I 0.0031 1 0.05I f 0.0611
Uncontrollable conc.to be used in HWA(tn `1)=> 0.005 0.003 0.013 0.052
Spreadsheet Instructions• M L M M
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is
protected,password is"2". lable Concentration Choose"Uncontrollable Concentration " fron
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. ncon to be used in HWA" 31)
Concentration From "Mass Balance"(row 25),
"Sampling"(row 27),or"Literature"(row 29). Document reasons.
Uncontrollable Mass Balance Spreadsheet(1)Dissolved Metals
SIU.Uncont.Mass.Bal
Page 2 of 6 pages
8/6/2019,8:26 AM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW CYANIDE LEAD MERCURY MOLYBDENUM
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 LAMS I 011/001 0.00761 7,610 0.005 0.0003 0.0001 0.00001 0.056 0.0036
2 WALMART 016/001 0.0073 7,300 0.005 0.0003 0.0001 0.00001 0.068 0.0041
3 SEMPRIUS 017/001 0.0026 2,600 0.005 0.0001 0.0001 0.00000 0.003 0.0001
4
5
6
7
8
9
10
11 _
12 �l
13
Sum of Industrial Loading(lbs/day)=> 0.01751 17510 0.0007 1 0.00001 0.0078
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)=> 2.2348-2,234,800 I I 0.0051 0.09321 0.0001r 0.00186 0.003 0.0559
Uncontrollable Load from Mass Bal(lbs/day)=> 2.2173 0.0925 0.00185 0.0482
Uncontrollable Concen.from Mass Bal(mg/L)=> I 0.0051 0.00010I I 0.0031
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> -- 0.017 0.3144 0.0002 0.0028 0.003 0.0555
Uncontrollable Concen.From Literature(mg/L)_> I 0.0411 r 0.0491 r 0.0003J r I
Uncontrollable cone.to be used in HWA(mg/L)=> t ` `0 0J7 0.0003 0.003
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is
protected,password is e" Uncontrollable Choose"Uncontrollable Concentration to be used in HWA"(row 31)frc
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. Concentration From "Mass Balance"(row 25),
Uncontrollable Mass Balance Spreadsheet(1)Dissolved Metals
SIU.Uncont.Mass.Bal
Page 3 of 6 pages
8/6/2019,8:26 AM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW NICKEL SELENIUM SILVER ZINC
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 IAMS 011/001 0.00761 7,610 0.012 0.0008 0.005 0.0003 0.003 0.0002 0.067 0.0043
2 WALMART 016/001 0.0073 7,300 0.005 0.0003 0.005 0.0003 0.003 0.0002 0.739 0.0450
3 SEMPRIUS 017/001 0.0026 2,600 0.005 0.0001 0.005 0.0001 0.003 0.0001 0.009 0.0002
4
5
I I
6
7
• 8
9
10
i
11
12
13 _
Sum of Industrial Loading(lbs/day)=> 0.0175 17510 1 0.0012 0.0007 1 0.0004 r 0.0494
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)=> 2.2348 2,234,800 0.011� 0.2050 0.0050� 0.0050 0.0030� 0.0559 0.13� 2.4230
Uncontrollable Load from Mass Bal(lbs/day)=> 2.2173 0.2038 0.0043 0.0555 2.3735
_ Uncontrollable Concen.-from Mass Bal(mg/L)=> I 0.0111 1 0.00021 I 0.0031 1 0.1281
Uncont.from Uncont. Sampling(mg/L+Ibs/day)_> 0.015 0.2774 0.005 0.0925 0.003 0.0555 0.5610 10.3741
Uncontrollable Concen.From Literature(mg/L)_> I 0.0211 I I L 0.0051 I 0.1751
Uncontrollable cone,to be used in HIWA(mg/L.)P> 0.011 0.005 0.003 0.128
Spreadsheet Instructions: M S M M
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is
protected,password is"2". )m Uncontrollable
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. Choose"Uncontrollable Concentration to be used in HWA"(row 31)fron
Concentration From "Mass Balance"(row 25),
Uncontrollable Mass Balance Spreadsheet(1)Dissolved Metals
SIU.Uncont.Mass.Bal
Page 4 of 6 pages
8/6/2019,8:26 AM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW Oil & Grease CHLORIDE TOTAL PHOS
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe 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
1 IAMS 011/001 0.00761\ 7,610 4.3 0.2729 100 6.3467 10.2 0.6474
2 WALMART 016/001 0.0073 7,300 8.4 0.5114 116 7.0623 7.5 0.4566
3 SEMPRIUS 017/001 0.0026 2,600 20 0.4337 0.4 0.0087
4
5
11
7
8 _
9
10
11 -
12
13
Sum of Industrial Loading(lbs/day)=> 0.0175 17510-� 0.7843 I 13.8427 ) 1.1127
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)=>I 2.234812,234,800 1 1 51.7' 963.5966 4.8000 89.4635
Uncontrollable Load from Mass Bal(lbs/day)=> 2.2173 949.7539 88.3509
Uncontrollable Concen.from Mass Bal(mg/L)=> ( I 51.41 ' 4.81
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> 1=71 510.3847 40.5 748.9340 13.3 245.9462
Uncontrollable Concen.From Literature(mg/L)_> 501 I I F I
Uncontrollable conc.to be us in I-iWA(mg/L) I 4.8
Spreadsheet Instructions: M
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 5,Section E,page 5 i Uncontrollable I Choose"Uncontrollable Concentration to be
Uncontrollable Mass Balance Spreadsheet(1)Dissolved Metals
SIU.Uncont.Mass.Bal
Page 5 of 6 pages
8/6/2019,8:26 AM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW COD TKN MBAS
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe 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
1 IAMS 011/001 0.00761 7,610 219.5 13.9311 26.2 1.6628 4.29 0.2723
2 WALMART 016/001 0.0073 7,300 276 16.8034 76.2 4.6392 2.62 0.1595
3 SEMPRIUS 017/001 0.0026 2,600 26.6 0.5768 1.16 0.0252 0.13 0.0028
4
5
6
7
8
9
10
11
12
13
Sum of Industrial Loading(lbs/day)_> 0.01751 17510 I 31.3113 6.3272 I 0.4346
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)_>11 2.234812,234,8001 415.0001 7,734.86631 33.80001 629.97221 4.9400 92.0729
Uncontrollable Load from Mass Bal(lbs/day)=> 2.2173 7,703.6 623.6450 91.6383
Uncontrollable Concen.from Mass Bal(mg/L)=> 4171 I 33.71 I 4.961
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> I 1486 27479.4 88.9 1643.9565 8.83 163.2861
Uncontrollable Concen.From Literature(mg/L)=> I I I I \ I I
Uncontrollable cone.to be used in HWA(mgllL)¢> 33.7
Spreadsheet Instructions: M
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 5,Section E,page 5 used in HWA"(row 31)
Uncontrollable Mass Balance Spreadsheet(1)Dissolved Metals
SIU.Uncont.Mass.Bal
Page 6 of 6 pages
8/6/2019,8:26 AM
Revision August 1999