NC0025453_Headworks Analysis_20170623

Water Resources
ENVIRONMENTAL QUALITY
June 23, 2017
Mr. James Warren
Wastewater Operations Superintendent
Town of Clayton
P.O. BOX 879
Clayton, NC 27520
Subject: Pretreatment Review of Headworks Analysis - Approved
Program- Town of Clayton
NPDES Permit No. NCO025453
Johnston County
Dear Mr. Warren:
ROY COOPER
Governor
MICHAEL S. REGAN
Secretary
S JAY ZIMMERMAN
Director
The Pretreatment, Emergency Response, and Collection Systems (PERCS) Unit of the Division of Water
Resources has reviewed the Headworks Analysis (HWA) submitted by the Town of Clayton. The HWA was
initially received by the Division on April 3, 2017, followed additional Information received on June 23,
2017.
The Division concurs with the HWA calculations for all pollutants of concern, with the corrections outlined
below. 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
spreadsheets, which has the corrections marked. The results of the HWA are also listed in the bottom
section of the enclosed Allocation Table (AT)
1) Changes to the HWA Approved Today: Please feel free to contact PERCS If you have any questions
about the changes outlined below. All corrected spreadsheets were emailed to you for your files, and
other corrected documents were faxed. Please ensure the POTW's paper and electronic HWA, AT,
and other supporting documents contain these corrected documents, especially the Allocation Table.
As needed, please mark any original documents as "replaced" or "voided."
a) 7Q10 Flow: 7Q10 stream flow was corrected to 120 16 MGD per NPDES permit fact sheet.
b) Sludge Loading Calculations: Sludge site area was updated to 119 acres per attachment B of Land
application permit, WQ0023178. Also, sludge site life and age of sludge were corrected.
c) Mass Balance Calculations: Mass balance concentrations were chosen for molybdenum, selenium,
and zinc as uncontrollable concentrations to be used in the HWA.
2) Detection Levels: We noticed that Detection Levels (PQLs) for several parameters were inconsistent
and did not meet listed LTMP DLs throughout the samplings. In future HWA samplings, please make
sure labs follow approved LTMP DLs consistently.
Nothing Compares -,-,-
State of North Carolina I Environmental Quality I Water Resources
512 N Salisbury Street 11611 Mad Service Center I Raleigh, NC 27699-1611
9197079000

3) HWA Due Date The HWA approved today is primarily based on DMR/LTMP data for the period
January 2013 through December 2016 Your next updated HWA is due on April 1, 2022 unless
conditions at the POTW change significantly and thus warrant an earlier submittal (see Comprehensive
Guide, Section 8)0
Thank you for your continued cooperation with the Pretreatment Program. If you have any questions or
comments, please contact Monti Hassan at [phone] [email Monti Hassan@ncdenr gov] or
Deborah Gore, Unit Supervisor at [phone] [email Debora [e-mail]].
mh/Clayton HWA 2017
Enclosures HWA AT, mass balance spreadsheets
cc Central Files
Cheng Zhang, Raleigh Regional Office
Monti Hassan, PERCS Unit w/ enclosures
SiNon
ncerelyisn H
PERCS Unit
Nothing Compares_
State of North Carolina I Environmental Quality I Water Resources
512 N Salisbury Street 1 1611 Mail Service Center I Raleigh, NC 27699-1611
9197079000

Page 1 of 5
Workbook Name: Clayton. HWA.AT.2017.Approved.xlsx; Worksheet Name: HWA Printed 6/23/2017, 2 33 PM
Modeled after Chapter 5-HWA Guidance, Appendix 5-A
Revision Date February 2008
A B
C I
U I
r-
1
Headworks Analysts Spreadsheet
Spreadsheet Instructions
1) Applicable Values should be entered in the Heavy Bordered Blue cells The
rest of worksheet is
2
POTW Name
Little Creek WRF
"2"
3
Date
6/23/2017
protected, password is
2) Additional pollutants can be added in cells A34 to A42 Note all Pollutant names are linked from
4
POTW NPDES # =>
NC0025453
here to other pages in HWA worksheet and also to AT worksheet (i e , automatically entered into
5
POTW Sludge Permit # =>I
W 0023178
other pages in HWA worksheet and also AT worksheet from HWA worksheet)
3) Formulas are discussed in the Comprehensive Guidance HWA Chapter
7
POTW NPDES Permitted Flow(MGD)=
2 500 <
used in AT only
4) HWA, AT and HASL worksheets are linked MAHLs, Basis, and Uncontrollable
load are
8
POTW Average Flow(MGD)=
1 585 < used in HWA calculauom automatically entered into AT from this worksheet
Uncontrollable Flow(MGD)=
1 485
5) If red tab notes are not visible, they can be turned on in the "Tools" menu under "options", in the
g
10
7QI0 Stream Flow(MGD)=
12016
"view" tab click the "comment indicator only" button
11
Stream Classification=
WS -IV NSW CA
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)=
0004778
flows
Design Values Average Flow Permitted Flow
Criteria
Loading
16
%Solids to Disposal=
253
119
WWTF Influent BOD (mg/1) 300 5556 352 2
x
17
Sludge Site Area(acres)=
20
WWTF Influent TSS (mg/1) 300 19020
x
18
—WWTF
Sludge Site Life(yrs)=
--20000
Influent NH3 (mg/1) 25 909 576
x
1 g
Age of Sludge Site(yrs)=
20
WWTF Influent Total N(mg/1) 40 313 198
x
20
WWTF Influent Total P (mg/l) 8 127 80
x
21
Pass -Through
Loading Calculations
Stream Standard
Pass-Thru Minimum
NPDES LIMIT
Plant Removal Rate
Removal rate
NPDES Loading Standard Stream Loading Design Criteria
(mg/1) Standard Source (lbs/day) Loading (lbs/day)
Loading Pass-Thru
(lbs/day) Basis
23
Pollutant
(mg/1)
(%)
Source
(lbs/day)
6,255
6,255 Design
BOD
5
99 10
Site specific
7,344
6,255
6,255 Design
TSS
30
9900
Site s ecific
39,657
521
521 Design
Ammonia
1
9890
Sites ecific
1,202
0 O 1 Water Sti l 184610
184610 Streain Std
r27
Arsenic
4500
Literature
0.002 A uahc Life 6 1537
6 1537 StreStd
Cadmium
6700
Literature
0 05 Aquatic Life 282 0426
282 0426 Stream Std
Chromium
82 00
77 80
Literature
Sites ecific
0 007 Aquatic Life 320
32 0156 Stream Std
30
Copper
69 00
Lrtemhire
0 005 Aquatic Life 163767
16 3767 Stream Std
31
Cyanide
61 00
Literature
0 025 Aquatic Life 650868
650868 Stream Std
32
Lead
6000
Literature
0000012 Aquatic Life 0 03046
0 03046 Stream Std
33
Mercury
34
Molybdenum
3300
Literature
0 025 Water Supply 4376521
43 7652 Stream Std
35
Nickel
4200
Literature
0 005 Aquatic Life 10 1535
10 1535 Stream Std
36
Selenium
5000
Literature
0 00006 A uahc Life 02437
02437 Stream Std
37
Silver
7500
5330
Literature
Sites ecific
0 05 A uahc Life 1087102
1087102 Stream Std
38
Zinc
3
9040 Sites ecific
4130906 834
834 000 Design
39
Total Nitrogen
8420 Sites ecific
1673278 1668
166 800 Design
40
Total Phos
2
41
42
43
44
;Erg
45
461
47
1
Modeled after Chapter 5-HWA Guidance, Appendix 5-A
Revision Date February 2008

Workbook Name: Clayton. roved.xlsx• Worksheet Name: HWA Page 2 of 5
Y pp � Printed 6/23/2017, 2 33 PM
A
B
C D
E F G
H I
J K
49
50
51 Inhibition Loading Calculations
Average Influent NH3 (mg/1) 29
Average Anaerobic Digester NH3 (mgA)
only enter when have ANAEROBIC digester
Primary
Removal Rate
52 Pollutant (%)
A S /Nd,/T F
Inhibition
Primary Removal Concentration
Rate Source (mg/1)
A S /Nit,/T F A S /Nit,/T F Digestor
Inhibition Inhibition Inhibition
Concentration Loading Concentration
Source (lbs/day) (mg/1)
Digestor
Inhibition Digestor Inhibition
Conc Source Loading (lbs/day)
Minimum Minimum
Inhibition Inhibition
Loading Loading
(lbs/day) Source
53 BOD
54 TSS
55 Ammonia
480
6345 0720
634507 AS/Nit/TF i
56 Arsenic
01
13219
13219 AS/Nit/TF i
57 Cadmium
1
132189
132189 AS/Nit/TF ir
58 Chromium
0 394
52082
52082 AS/Nit/TF ir
59 Copper
048
63451
63451 AS/Nn/TF ir
60 Cyanide
01
13219
13219 AS/Nit/TF ir
61 Lead
05
66095
66095 AS/Nit/TF i
62 Mercury
01
13219
13219 AS/Nit/TF ir
63 Molybdenum
b4 IQit,kel
025
3 3047
3 3047 AS/Nit/TF i
65 ISclenium
66 Silver
67 Zinc
025
1
33047
132189
3 3047 AS/Nit/TF ir
13 2189 AS/Nit/TF ir
68 Total Nitrogen
69 Total Phos
70
71
72
73
74
75
76
Modeled after Chapter 5-HWA Guidance, Appendix 5-A
Revision Date February 2008

Page 3 of 5
Workbook Name: Clayton. HWA.AT.2017.Approved.xlsx; Worksheet Name: HWA Printed 6/23/2017, 2 33 PM
Modeled after Chapter 5-HWA Guidance, Appendix 5-A
Revision Date February 2008

Workbook Name: Clayton. roved.xlsx; Worksheet Name: HWA Fage4of5
Y pp Panted 6/23/2017, 2 33 PM
A
I B I C
D E
F G H
I J K
105 Maximum Allowable Headworks Loading Calculations
Minimum Pass Minimum Minimum Minimum Mimmum
Through Loading Pass Through Inhibition Loading Inhibihon Loading Sludge Loading Sludge Loading
106 (lbs/day) Source (Ibs/day) Source (lbs/day) Sorce
Allowable Maximum Allowable
Headworks Headworks Loading
Loading (Ibs/day) Source
107 BOD 62550 Design
6255 0 Design
108 TSS 62550 Design
6255 0 Design
109 Ammonia 5213 Design 6345 0720 AS/NAITF mhibiti
5213 Design
110 Arsenic 184610 Stream Std 13219 AS/Nrt/TF mlubili 0 1680 Sludge Ceiling
0 1680 Sludge Ceiling
111 Cadmium 6 1537 Stream Std 132189 AS/Nit/TF mhibdi 0 1279 Sludge Ceiling
0 1279 Sludge Ceiling
112 Chroauum 2820426 Stream Std 52082 AS/Nit/TF mhibiu
52082 AS/Nit/TF mlubihon
113 Copper 320156 Stream Std 63451 AS/Nn/TF mhibih 5 5721 Sludge Ceiling
55721 Sludge Ceiling
114 Cyanide 163767 Stream Std 1 3219 AS/Nit/TF mhibiti
1 3219 AS/Nit/TF inhibition
115 Lead 65 0868 Stream Std 6 6095 AS/Nit/TF mlubitt 13883 Sludize Ceiling
1 3883 Sludge Ceiling
116 Mercury 003046 Stream Std 13219 AS/Nit/TF minbitr 00958 Sludge C iling
003046 Stream Std
117 Molybdenum 02291 Sludge Ceiling
02291 Sludge Ceiling
118 Nickel 437652 Stream Std 3 3047 AS/Nit/TF mhibilt 10082 Sludge Ceiling
10082 Sludge Ceiling
119 Selenium 10 1535 Stream Std 02016 Sludge Ceiling
02016 Sludge Ceiling
120 Silvor 02437 Stream Std 3 3047 AS/Ni/TF rnlubttt
121 Zinc 108 / lU2 Strewn Std 13 2189 AS/Ntt/TF rnhibih 14 1862 Sludge Ceiling
02437 Stream Std
132189 AS/Nit/TF inhibition
122 Total Nitrogen 8340 Design
8340000 Design
123 Total Phos 1668 Design
lbb 8000 Design
124
125
126
127
128
129
130
131
Modeled after Chapter 5-HWA Guidance, Appendix 5-A
Revision Date February 2008

Workbook Name: Clayton. roved.xlsx; Worksheet Name: HWA Page 5 of 5
Y pp Panted 6/23/2017, 2 33 PM
A
B C
D
E F
G
H I J K
132
133 Maximum Allowable Industrial Loadings Calculations
Design vs Pass -
Thru Warning
Maximum
Allowable Check to Use Uncontrollable
Headworks Loading HASL Cales Concentration Uncontrollable Uncontrollable
134 Pollutant (lbs/day) MAHL Basis (x) (mg/1) Source Load (lbs/day)
Maximum
Allowable
Industrial
Load (Ibs/day)
135 BOD 6255 0000 Design 309 Sampling 3826 0000
24290000
136 TSS 6255 0000 Design 301 Sam lm 3727 0000
2528 0000
137 Ammonia 5212500 Design 31 ISairmling 3840000
1372500
138 Arsenic 0 1680 Sludge Ceiling 0 003 Literature 00371
0 1309
139 Cadmium 0 1279 Sludge Ceiling 0 003 Literature 00371
00908
140 Chromium 52082 AS/Nit/TF inhibit N/A 005 Literature 06190
45892
141 Copper 55721 Sludge Ceiling 0 061 Literature 07555
4 8166
1421 Cyanide 13219 AS/Nit/TF inhibit N/A 0 015 Literature 0 1857
1 1362
143 Lead 13883 Sludge Ceiling 0 049 Literature 06069
07814
144 Mercury 003046 Stream Std 00003 Literature 000370
002676
145 Molybdenum 02291 Sludge Ceiling 00051 Mass Balance 00632
0 T6-60-
146 Nickel 10082 Sludge Ceiling 0 021 Literature 02601
07481
147 Selenium 0 2016 Sludge Ceiling 0 005 Mass Balance 00619
0 1397
148 Silver 02437 Stream Std N/A 0 005 Literature 00619
0 1818
1491Z nc 132189 AS/Nit/TF mlubition 0 22 Mass Balance 27247
104942
150 Total Nitrogen 8340000 Design 43 Sampling 5325507
3014493
151 Total Phos 166 8000 Design 7 1 Sampling 87 9328
788672
152
153
154
155
156
157
158
Modeled after Chapter 5-HWA Guidance, Appendix 5-A
Revision Date February 2008

34
Workbook Name: Clayton. HWA.AT.2017.Approved.xlsx, Worksheet Name: AT Printed 6/23/2017, 21 PPage 5
Allocation Table
Headworks last approved 06/23/17
Allocation Table updated 1 06/23/17
Permits last modified r 06/01/15
Po,w-- Little Creek WRF
�DesrJ'--> NC0025453
Spreadsheet Instructions
1) Applicable Values should be entered in the Heavy Bordered cells Rest of worksheet is protected, password is
"2"
2) Formulas are discussed in the Comprehensive Guidance, Chapter 6, Section C
3) 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
IDP
Count
1
Industry
INDUSTRY NAMES Permit
(please listalphabehely) number
Novo Nordisk 0003-02
Pipe
number
0002
Type
of
Industry
Pharm
Renewal
Effective
Date
07/01/12
Modification
Effective
Date
06/01/15
Date
Permit
Expires
06/30/17
Permit Limits
MGD al/d
0 1750 175;
2
Grifols(Tributary to Johnston Co) 0001-02
0001
Pharm
07/01/12
08/17/15
06/30/17
Uncontrollable Loading (lbs/day) _>
3
10150
2429
2528
Total Allowable for Industry (MAIL) (lbs/day) _>
4
365
365
Total Permitted to Industry (lbs/day) _>
0 8400
2064
5
MAIL left (lbs/day) _>
828%
85 0%
1 85 6%
Percent Allow Ind (MAIL) still available (%) _>
6
33 6%
33 0%
346%
Percent MARL still available (%) _>
7
5 Percent MARL. (lbs/day) _>
0 1250
313
8
9
10
Column Totals =>
0 1750 175
BOD
Permit Limits
Conic Load
MR/1 lbs/da;
250001 3641
TSS
Permit Limits
-
Conic Load
3
Basis=>
NPDES
Design
Design
25000
6255
6255
MARL, from HWA (lbs/day) _> NPDES Permitted Flow-->
14850
3826
3727
Uncontrollable Loading (lbs/day) _>
10150
2429
2528
Total Allowable for Industry (MAIL) (lbs/day) _>
0 1750
365
365
Total Permitted to Industry (lbs/day) _>
0 8400
2064
2163
MAIL left (lbs/day) _>
828%
85 0%
1 85 6%
Percent Allow Ind (MAIL) still available (%) _>
33 6%
33 0%
346%
Percent MARL still available (%) _>
5 Percent MARL. (lbs/day) _>
0 1250
313
313
HWA AT
Revised November 2005

Workbook Name: Clayton.HWA.AT.2017.Approved.xlsx, Worksheet Name: AT Printed 6/23/2017, 2 34 PM
Page 2 of 5
Allocation Table
Headworks last approved 06/23/17
Allocation Table updated 06/23/17
Permits last modified 06/01/15
Porw=> Little Creek WRF
NPDES#-- NC0025453
HWA AT
Revised November 2005
Industry
Permit Limits
Permit Limits
Permit Limits
Permit Limits
Permit Limits
Percmt Limits
IUP
INDUSTRY NAMES Permit
Pipe Cone
Load
Cone Load
Cone Load
Cone Load
Cone Load
Cone Load
Count
(pleaseInt alphabebcly) number
number mg/1
lbs/da
mg/1 lbs/da
mg/l lbs/da
mg/1 lbs/da
mg/l lbs/da
mg/I lbs/da
1
Novo Nordisk 0003-02
0002 2000
29 19
2
Grifols (Tributary to Johnston Co) 0001-02
0001
3
4
5
6
7
8
9
10
Column Totals =>
29
00000
1 000001
00000
00000
00000
Sludge
Sludge
AS/Nit/TF
Sludge
AS/Nit/TF
Basis—
Design
Ceding
Ceiling
inhibition
Ceiling
inhibition
MARL, from HWA (lbs/day) =>
52125
0 1680
0 1279
52082
55721
13219
Uncontrollable Loading (lbs/day) =>
38400
00371
0 0371
06190
07555
0,1857
Total Allowable for Industry (MAIL) (lbs/day) =>
13725
0 1309
0 0908
45892
48166
1 1362
Total Permitted to Industry (lbs/day) =>
29 19
00000
0 0000
00000
00000
00000
MAIL left (lbs/day) =>
10806
0 1309
0 0908
45892
48166
1 1362
Percent Allow Ind (MAIL) still available (%) =>
78 7 %
100 0 %
1000%
100 00/0
100 0 %
1000OX
Percent MARL still available (%) =>
20 7 %
779%
71 0 %
5 Percent MAHL (lbs/dav) =>
26 06
00084
0 0064
0 2604
0 2786
0 0661
HWA AT
Revised November 2005

Workbook Name: Clayton. HWA.AT.2017.Approved.xlsx, Worksheet Name: AT Panted 6/23/2017, 2 34 PM
Page 3 of 5
Allocation Table
06/23/17
Headworks last approved
Molybdenum
Allocation Table updated
06/23/17
Permits last modified
1 06/01/15
PDEs#=> NCO025453
Lead
Mercury
Molybdenum
Nickel
Selenium
i ver
Permit Limits
Permit Lmuts
Pemut Limits
Permit Limits
Permit Lumts
Load
Permit Lm
Conc Load
Industry
INDUSTRY NAMES Permit Pipe
Conc Load
Conc Load
Conc Load
/1 lbs/da
Cone Load
m,/1 lbs/da
Cone
m /1 lbs/da mg/1 lbs/da
Np
number number
m 1 IbsJda
m 1 lbs/da
m
Count
(pleasehstalphabencly)
0003-02 0002
1
ovo Nordisk
2
Gnfols (Tributaryto Johnston Co 0001-02 0001
3
4
5
6
7
8
9
10
0000
000000
000001
0 0000
000
0 0000
Column Totals =>
Sludge
Sludge
g
Sludge
Stream
Std
Sludge
Ceding
Stream Std
Ceding
Ceiling
Ceiling
0 2437
Basrs=>
from HWA (lbs/day) =>
38830030461
FIO
10082MARL
0 2601
69Uncontrollable
Loading (lbs/day) =>
6069
0 003700
0 026761
0 7481
MO2
0 1818
lbs/da
Total Allowable for Industry (MAIL) ( y) =>
0 7814
0 0000
0 000000
07249%,
0 0000
0 0000
0 1818
Total Permitted to Industry (lbs/day) =>
0 026761
07481
MAIL le$ (lbs/day) =>
0 7814
0
100 0 %
1000%
1000%
Percent Allow Ind (MAIL) still available (%) =>
100 0 /0
879%
74 2 %
69 3 %
74 6 %
Percent MARL still available (%) =>
56.3
0 0101
0 0122
0 0694
0 001523
0 0115
0 0504
5 Percent MARL (lbs/da =>
HWA AT
Revised November 2005

Workbook Name: Clayton.HWA.AT.2017.Approved.xlsx, Worksheet Name: AT Printed 6/23/2017, 2 34 PM
Page 4 of 5
Allocation Table
00000
0 00
14 60
0 000�j
Headworks last approved
06/23/17
AS/Nit/TF
Allocation Table updated
06/23/17
Basis=>
Permits last modified
06/01/15
Design
Porw=> Little Creek WRY
MARL from HWA (lbs/day) =>
132189
8340000
166 80
NPDEs#=> NCO025453
Uncontrollable Loading (lbs/day) =>
27247
5325507
87 93
Zinc
Total Nitrogen
Total Phos. 0 0 0
Total Allowable for Industry (MAIL) (lbs/day) =>
Industry
Permit Limits
Permit Limits
Permit Limits Permit Limits Permit Lmmts Permit Limits
IUP INDUSTRY NAMES
Permit
Pipe Cone Load
Cone Load
Cone Load Cone Load Cone Load Cone Load
Count (pl—cI.stnlplub.ady)
number
number mg/1 lbs/da
mg/1 lbs/da
mg/l lbs/da mg/l lbs/da mg/1 lbs/da mg/1— lbs/da
1 Novo Nordisk
0003-02
0002
1000 1460
2 Grifols (Tributary to Johnston Co
0001-02
0001
1000%
815 %
3
#######
#######
Percent MAHL still available (%) =>
794%
4
5
06609
4170
8 3400
6
7
8
9
10
Column Totals =>
00000
0 00
14 60
0 000�j
L 00000
0 000
AS/Nit/TF
Basis=>
inhibition
Design
Design
MARL from HWA (lbs/day) =>
132189
8340000
166 80
Uncontrollable Loading (lbs/day) =>
27247
5325507
87 93
Total Allowable for Industry (MAIL) (lbs/day) =>
104942
30145
78 87
Total Permitted to Industry (lbs/day) =>
00000
000
1460
00000
00000
00000
MAIL left (lbs/day) =>
104942
30145
6427
Percent Allow Ind (MAIL) still available (%) =>
100 0 %
1000%
815 %
#######
#######
#######
Percent MAHL still available (%) =>
794%
361 %
5 Percent MARL (lbs/day) =>
06609
4170
8 3400
HWA AT
Revised November 2005

SIU.Uncont.Mass. Bal
1UP
Count
1
2
3
4
5
6
7
8
9
10
11
12
13
Sum of Industrial Loading (lbs/day) _->
Avg Influent loading (lbs/day)
Uncontrollable Load from Mass Bal (lbs/day) => 1 4850
Uncontrollable Concen. from Mass Bal (mg/L) =>
Uncont. from Uncont Sampling (mg/L + lbs/day) =>
Uncontrollable Concen. From Literature (mg/L) =>
I YnconiTo-1161[e cone. i o be, wed in WATA (mom) =>
Spreadsheet Instructions
1) Applicable Values should be entered in the Heavy Bordered cells Rest of worksheet is
protected, password is "2"
2) Formulas are discussed in the Comprehensive Guidance, Chapter 5, Section E, page 5
Unc Mass Balance Spreadsheet 2017_PERCS As
SIU Uncont Mass Bal
Page 1 of 5 pages
.' 6/23/2017, 2 51 PM
Revision August 1999
F 7 07 0322
2711 274 30 5 0002
U-3091 382693[-301 3727 85F-311 383 93 0 0026 0.0322
250 2501 25 1 0 003
3091 301 31 0 003
Choose "Uncontrollable Concentration to be used in HWA" (row 31) from Uncontrollable
Concentration From "Mass Balance" (row 25),
"Sampling" (row 27), or "Literature" (row 29) Document reasons

1
b
IUP
Count
1
2
3
4
5
6
7
8
9
10
11
12
13
SI U. Uncont. Mass. Bal
INDUSTRY
Industry
AverageAverage Discharge
Average Discharge
Average Discharge
Average Dischar
NAMES
Permit/Pipe
Cone Load
Cone Load
Cone Load
Cone Load
(please list alphabetically)
number
"Discharge
MGDm /l lbs/da
m 1 lbs/da
m /l lbs/da
m 1 lbs/da:
ovo Nordisk
0 000051 000041
1 00 '000
0.00321 0.00271
0041 003341
000251F 0 K.
Sum of Industrial Loading (lbs/day) => 0 10001 100000
MGD al/da
Avg Influent loading (lbs/day) —> 1.585 1,585,000
Uncontrollable Load from Mass Bal (lbs/day) =>1 14850
Uncontrollable Concen from Mass Bal (mg/L) =>
Uncont. from Uncont. Sampling (mg/L + lbs/day) =>
Uncontrollable Conceit From Literature (mg/L) =>
Uncontrollable conc, to be used in HIAIA (mom) =>
)readsheet Instructions
Applicable Values should be entered in the Heavy Bordered cells Rest of worksheet is
Dtected, password is "2"
Formulas are discussed in the Comprehensive Guidance, Chapter 5, Section E, page 5
Line Mass Balance Spreadsheet 2017_PERCS As
SIU Uncont Mass Bal
Page 2 of 5 pages
6/23/2017,2 51 PM
Revision August 1999
000041 1 000271 1 003341 1 00021
000051 0.00661 0.0025
0 03301 00351
046271 0.00251 00330
0.0062 0 0304
0 4293 0 0310
000251
003471
000251
000081 0.0099 00-031
003721 0.05541
0.68611 0.0043 0.0533
0 0031 0051
0 061
0 015
0.0031
0153
0 061
0 015
Choose "Uncontrollable Concentration to be used in HWA" (row 31) from Uncontrollable
Concentration From "Mass Balance" (row 25),
"Sampling" (row 27), or "Literature" (row 29) Document reasons

SIU Uncont Mass Bal
IUP
Count
1
2
3
4
5
6
7
8
9
10
11
12
13
Sum of Industrial Loading (10s/clay)
Avg Influent loading (lbs/day)
Uncontrollable Load from Mass Bal (lbs/day)
Uncontrollable Concen from Mass Bal (mg/L) _>
Uncont from Uncont Sampling (mg/L + lbs/day) =>
Uncontrollable Concen From Literature (mg/L) =>
fTnrroll-rolIshl,e CODA to be used iLC1-IW(mg/L) =>
Spreadsheet Instructions
1) Applicable Values should be entered in the Heavy Bordered cells Rest of worksheet is
protected, password is "2"
2) Formulas are discussed in the Comprehensive Guidance, Chapter 5, Section E, page 5
Unc Mass Balance Spreadsheet 2017_PERCS AS
SIU Uncont Mass Bal
Page 3 of 5 pages
6/23/2017, 2 51 PM
Revision August 1999
00310 0 00171 0 0627 0 0608
0 00251 1 000 0 0-0 5-11 0004
0 0041 0 0495U 0 0003 0 0037 0 00351 0 04331 0 00529 0 0655
0 049 0 0003 0 021
0 049 0 0003 000511
0 021
Choose "Uncontrollable Concentration to be used in HWA" (row 31) from Uncontrollable
Concentration From "Mass Balance" (row 25),
"Sampling" (row 27), or "Literature" (row 29) Document reasons

NP
Count
1
2
3
4
5
6
7
8
9
10
11
12
13
SIU.Uncont Mass.Bal
INDUSTRY Industry
NAMES Permit/Pipe
(please list alphabetically) number
FLOW
Average Discharge
MGD gal/day
SELENIUM
Average Discharge
Conc Load
mg/1 lbs/da
SILVER
Average Discharge
Conc Load
mg/1 lbs/day
ZINC
Average Discharge
Cone Load
mg/l lbs/da
Oil & Grease
Average Discharge
Cone Load
m /l lbs/da
Novo Nordisk
01
100,000
0 005
00042
00023
00019
0 092
00767
Sum of Industrial Loading (lbs/day) =>
0 100Lgjada
MGD
000
m /l
00
lbs/day
m /l
0 002
lbs/da
mg/1
008
lbs/da
mg/1 lbs/da
Avg Influent loading (lbs/day) =>I 1 S8511,b8b,0001 U UOSj 006611 U UU2S1 U 0331 02121 2801
Uncontrollable Load from Mass Bal (lbs/day) => 1 006191 U 031 0 L
Uncontrollable Concen from Mass Bal (mg/L) => 1 000501 000251 0221
Uncont from Uncont Sampling (mg/L + lbs/day) => 0.00351 004331 0 00331 004091 020921 259091—
Uncontrollable
5909Uncontrollable Concen From Literature (mg/L) => 1 00051 1 0 1751 1 50
Uncontrollable cope to be used in HWA (zr EJUL > 1 0 005 0 22 11
Spreadsheet Instructions
1) Applicable Values should be entered in the Heavy Bordered cells Rest of worksheet is
protected, password is "2"
2) Formulas are discussed in the Comprehensive Guidance, Chapter 5, Section E, page 5
Unc Mass Balance Spreadsheet 2017_PERCS As
SIU Uncont Mass Bal
Page 4 of 5 pages
6/23/2017, 2 51 PM
Revision August 1999
Choose "Uncontrollable Concentration to be used in HWA" (row 31) from Uncontrollable
Concentration From "Mass Balance" (row 25),
"Sampling" (row 27), or "Literature" (row 29) Document reasons

IUP
Count
1
2
3
4
5
6
7
8
9
10
11
12
13
SIU.Uncont.Mass Bal
INDUSTRY
NAMES
(please list al habeticall)
Industry
Permit/Pipe
number
FLOW
Average Discharge
MGD al/da
T -Phosphorus
Average Discharge
Cone Load
m /l lbs/da
T -Nitrogen
Average Discharge
Cone Load
m /l lbs/da
Average Discharge
Cone Load
mg/l lbs/da
Average Discharge
Cone Load
mg/l lbs/da
Novo Nordisk
01
100,000
728
60715
1007
8 3984
Sum of Industrial Loading (lbs/day) =>
0 1000
MGD
100000
al/da
m /l
1 6 0715
lbs/da
mg/l
8 3984
lbs/da
mg/l lbs/da
mg/l lbs/da
Avg lnlluent loaamg (lbs/aay) —1 1 -)6D j1,DzSJ,VUU li /y -11.5 41 4.J1 Jb25 412/1 1
Uncontrollable Load from Mass Bal (lbs/day) =>F 148501 73 2419 560 0143
Uncontrollable Concen from Mass Bal (mg/L) => 1 601 41
Uncont from Uncont Sampling (mg/L + lbs/day) => 711 87 9328 51 3 635 34541 1
Uncontrollable Concen From Literature (mg/L) => 8 40
Uncontrollable cork toy be used in HWA (nam'.) => 7 1 43
Spreadsheet Instructions
1) Applicable Values should be entered in the Heavy Bordered cells Rest of worksheet is
protected, password is "2"
2) Formulas are discussed in the Comprehensive Guidance, Chapter 5, Section E, page 5
Unc Mass Balance Spreadsheet 2017_PERCS As
' SIU Uncont Mass Bal
Page 5 of 5 pages
6/23/2017, 2 51 PM
Revision August 1999
Choose "Uncontrollable Concentration to be used in HWA" (row 31) from Uncontrollable
Concentration From "Mass Balance" (row 25),
"Sampling" (row 27), or "Literature" (row 29) Document reasons