NC0026573_Headworks Analysis_20210111

M01eG
1.1
December 28, 2020
RECEIVED
NCDWR
PERCS Unit JAN 1 1 2021
1617 Mail Service Center NCD EQ/pw
Raleigh,NC 27699-1617 R/NPDES
Subject: City of Morganton,NC 0026573
Dear, Michael Montebello
Enclosed is the City of Morganton's Wastewater Treatment Plant Headwork's Analysis
(HWA) as required by the above NPDES permit. If you have any questions about this
document please give Mr. Timothy Arney a call at 828-438-5376 or email him at
[e-mail].
Sincerely,
Brad Boris
Water Resources Director
Telephone [phone] 305 East Union St. Post Office Box 3448
www.ci.morganton.nc.us Morganton,NC 28655 Morganton, NC 28680-3448

2020 HWA Narrative:
HWA Data Time Period:
The City of Morganton monthly sampling for HWA started in September 2019 through August 2020 at
the WWTP influent and effluent sampling areas. All pollutants of concern (POC)where sampled during
the long term monitoring plan. Primary Clarifiers was sampled monthly for LTMP. Aeration Basin was
sampled quarterly on the LTMP. SIU's where sampled monthly and all POC's sampled twice doing this
period.
WWTP Design Criteria:
The design criteria were revised by Freese & Nichols Engineering Firm during the recent plant upgrade
from pure oxygen mechanically mixed basins to a diffused fine bubbler system using turbo blowers upon
completion of construction in August 2019. The design influent values for BOD and TSS were for a flow
rate of 10.5 MGD though currently permitted for 8.5 MGD.
Removal Rate Calculations:
All available DMR and LTMP were used during the sampling period. Site-specific removal rates were
used in the HWA. Except for the metals that was below 50% Literature/Default were used for removal
rate calculations.
Water Quality Standards:
Total Metal Allocated to the Permittee was used as the water quality standards in the HWA
Spreadsheet. The chronic criteria were used for the metals with chromium using the CR VI criteria;
water supply was used for arsenic, molybdenum and nickel.
Inhibition Calculations:
Literature criteria for nitrification and activated sludge were used .We do have a NH3 limit and data
shows the plant nitrifies.
Sludge Calculations:
There was only one parameter that sludge ceiling was a limiting factor for which was molybdenum and
has 99%of the MAHL remaining.
Uncontrollable Mass Balance:
We used the calculated literature concentrations on all but for copper, lead, molybdenum, selenium and
aluminum which we used mass balance concentrations.

r
Calculator: Estimate NPDES Permit Limitations based on the Dissolved Water
Quality Standards and Stream & Effluent Hardness
FACILITY: PERMIT#: DATE: CALC BY:
Catawba River NC0026573 12/16/2020 Tim Arney
Average Stream Flow Receiving Receiving Rec.Stream NPDES Total IWC-Instream IWC-Instream
9 Total Average
Stream Stream Hardness Wastewater Wastewater Average Effluent
(CFS) 1 Q1 0 Flow Limit Suspended Upstream
summer summer (CaCO3, Concentration Concentration Hardness
7 10 F 7Q10(MGD)_ [MGD) [MGD) Solids(mg/L) mg/L) (Chronic) (Acute) Hardness
1528.00 118.00 76.1290 62.26 8.50 10.00 25 0.10 0.12 18.08 35.91
Class C,C-NSW,C-Swamp,and B streams HQW streams
2 3 4 5 6 7 8 9 10
Dissolved Water Quality Translators- Total Metal (allocated Estimated NPDES Estimated NPDES
Criteria (function of total using EPA to permittee)Des.Metal+ Permit Limits [Total Permit Limits [Total
hardness) Default Translator Metal+IWC) Metal+IWC)
Partition
Chronic Acute Coefficients Chronic Acute Chronic Acute Chronic Acute
PARAMETER* (ug/(] [ug/l] (streams) [ugh)] [ug/I] [ug/I] [ug/I] jug/I] [ugh!)
Arsenic 150 340 1.000 150 340 1493.45 2830.39 746.73 1415.19
Arsenic(Hit/WS) 10 N/A 1.000 10 N/A 1169.77 N/A 49.78 N/A
Beryllium 6.5 65 1.000 6.5 65 64.72 541.10 32.36 270.55
Cadmium(a) 0.15 0.82 0.252 0.5899 3.2396 5.9 26.97 2.9 13.48
Chlorides(WS) 250000 N/A 1.000 250000 N/A 2489089 N/A 1244544.6 N/A
Chromium Ill(a) 24' 183 0.202 117.7325 905.082 1172.2 7534.51 586.1 3767.25
Chromium VI 11 16 1.000 11 16 109.5 133.19 54.8 66.60
Chromium,Total N/A N/A N/A N/A N/A N/A N/A N/A N/A
Copper(a) 2.7 3.6 0.348 7.8806 10.4720 78.5, 87.18 39.2 43.59
Cyanide 5.0 22.0 1.000 5.0000 22.0000 49.8 183.14 24.9 91.57
Flouride _ 1800.0 N/A 1.000 1800.0 N/A 17921.4 N/A 8960.7 N/A
Lead(a) 0.54 14 0.184 2.9416 75.4871 29.29 628.41 14.64 314.20
Mercury 0.012000 _ N/A 1.000 0.012000 N/A 0.119476 N/A 0.0597381 N/A
Molybdenum(WS) 160.00 N/A 1.000 160.0000 N/A 1593.02 N/A 796.51 N/A
Nickel(a)** 16 145 0.432 37.23131 335.2087 371 2790.50 185 1395.25
Nickel(WS) 25 N/A 1.000 25.0000 N/A 249 N/A 124 N/A
Selenium 5 56 1.000 5.0000 56.0000 50 466.18 25 233.09
Silver(a) 0.06 0.30 1.000 0.06 0.2964 0.60 2.47 0.30 1.23
Zinc(a) 36 36 0.288 126.7335 125.7052 1262 1046.45 631 523.23
Cadmium(trout streams) I 0.15 0 511 0.2521 0.59 2.021 5.9 16.81 I 2.94' 8.41
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

State of North Carolina
Department of Environmental Quality
Division of Water Resources
Rc' CUr-C C>
APPLICATION FOR AUTHORIZATION TO CONSTRUCT PERMIT(FORM ATC-12-
14)
B. WASTEWATER TREATMENT FACILITY DESIGN INFORMATION—COMPLETE FOR NEW OR EXPANDING FACILITIES AND
FOR TREATMENT PROCESS MODIFICATIONS
1. Have all of the requirements of 15 NCAC 02H.0100,15A NCAC 02T, North Carolina General Statute 133-3, North Carolina
General Statute 143-215.1,and Division of Water Resources Minimum Design Criteria for NPDES Wastewater Treatment
Facilities been met by the proposed design and specifications?®Yes or❑ No. If no,provide justification as to why the
requirements are not met,consistent with 15A NCAC 02T.0105(n):
2. Provide the design influent and effluent characteristics that are used as the basis for the project design,and the NPDES
permit limits for the following parameters:
Project Basis of Design
Design Influent Design Influent
Influent Concentration Load
Concentration- (Must be (Must be
Current Annual supported by supported by NPDES Permit Limits
Average(past Engineering Engineering Design Effluent (monthly average)
12 months)if Calculations Calculations Concentration and/or
Parameter Available [Section 3.H]) [Section 3.H]) Load For 10.5 MGD
6.6 mg/L Summer 6.6 mg/L Summer
Ammonia Nitrogen 21.5 mg/L 21.5 mg/L 1,883 lb/day
(NH3-N)
13.3 mg/L Winter 13.3 mg/L Winter
Biochemical 18.5 mg/L Summer 18.5 mg/L Summer
Oxygen Demand 413.9 mg/L 413.9 mg/L 36,245 lb/day
(BODs) 18.5 mg/L Winter 18.5 mg/L Winter
Fecal Coliform 200 per 100 mL 200 per 100 mL
Nitrate+Nitrite
Nitrogen(NO3-N + N/A N/A
NO2-N)
Total Kjeldahl N/A
Nitrogen
N/A N/A
Total Nitrogen
N/A N/A
N/A N/A
Total Phosphorus N/A N/A
N/A N/A
Total Suspended 315.3 mg/L 315.3 mg/L 27,611 lb/day 30.0 mg/L 30.0 mg/L
Solids(TSS)
3. Based on the"Project Basis of Design"parameters listed above,will the proposed design allow the treatment facility to
meet the NPDES Permit Limits listed above?®Yes or❑ No. If no,describe how and why the Permit Limits will not be
met:
Application for Authorization to Construct Permit(FORM ATC-12-14) Page 7

Workbook Name: HWA Spreadsheet 2019; Worksheet Name: HWA Page 1 of5
P Printed 12/28/2020,7:05 AM
J A I B I C I D I E I F I G I H I I I J I K
1 Headworks Analysis Spreadsheet Spreadsheet Instructions:
2 POTW Name: Catawba River 1) Applicable Values should be entered in the Heavy Bordered Blue cells. The rest of worksheet is
3 Date: 12/23/2020 protected,password is"2".
4 POTW NPDES#=> NC0026573 2) Additional pollutants can be added in cells A34 to A42. Note all Pollutant names are linked from
5 POTW Sludge Permit#=> WQ0002127 here to other pages in HWA worksheet and also to AT worksheet(i.e.,automatically entered into
v other pages in HWA worksheet and also AT worksheet from HWA worksheet).
7 POTW NPDES Permitted Flow(MGD)= 8.5 <=used in AT only 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter.
4) HWA,AT and HASL worksheets are linked. MAHLs,Basis,and Uncontrollable load are
8 POTW Average Flow(MGD)= 5.3525 <=uscd in HWA calculations automatically entered into AT from this worksheet.
9 Uncontrollable Flow(MGD)= 3.4263 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)= 76.23 "view"tab click the"comment indicator only"button.
11 Stream Classification= WS-IV
--rc ,
13 Class of Sludge generated(A,or B) A
nipui A
14 Sludge to Digestor Flow(MGD)= Through talc.for different POTW use Design
15 Sludge to Disposal Flow(MGD)= 0.04256 flows Criteria
16 %Solids to Disposal= 71.4 Design Values Average Flow Permitted Flow Loading
17 Sludge Site Area(acres)= WWTF Influent BOD(mg/I) 374 1500.0 944.6 X
18 Sludge Site Life(yrs)= WWTF Influent TSS(mg/1) 318 1500.0 944.6 X
19 Age of Sludge Site(yrs)= _ WWTF Influent NH,(mg/I) 22 800.0 503.8 X
20 WWTF Influent Total N(mg/1) 32 X
21 Pass-Through Loading Calculations WWTF Influent Total P(mg/1) 8 X
all eam A1111111111111
Stream Standard Pass-Thru Minimum
NPDES LIMIT Plant Removal Removal rate NPDES Loading Standard Stream Standard Loading Design Criteria Loading Pass-Thru
23 Pollutant (mg/1) Rate(%) Source (lbs/day) (mg/I) Source (lbs/day) Loading(lbs/day) (lbs/day) Basis
24 BOD 30 98 DMR/LTMP 66,960 26,513 26,513 Design
25 TSS 30 98 DMR/LTMP 66,960 22,543 22,543 Design
26 Ammonia 16 98 DMR/LTMP 35,712 1,560 1,560 Design
27 Arsenic 45 Literature 0.01 Water Supply 12.3709 12.3709 Stream Std
28 Cadmium 67 Literature 0.0006 Aquatic Life 1.2371 1.2371 Stream Std
29 Chromium 82 Literature - 0.011 Aquatic Life 41.5799 41.5799 Stream Std
30 Copper 86 Literature 0.0079 Aquatic Life 38.3939 38.3939 Stream Std
31 Cyanide 69 Literature 0.005 Aquatic Life 10.9742 10.9742 Stream Std
32 Lead 61 Literature 0.0029 Aquatic Life 5.0594 5.0594 Stream Std
33 Mercury 60 Literature 0.000012 Aquatic Life 0.02041 0.02041 Stream Std
34 Molybdenum 33 Literature 0.16 Water Supply 162.4831 162.4831 Stream Std
35 Nickel 42 Literature 0.025 Water Supply 29.3275 29.3275 Stream Std
36 Selenium 50 Literature 0.005 Aquatic Life 6.8040 6.8040 Stream Std
37 Silver 75 Literature 0.00006 Aquatic Life 0.1633 0.1633 Stream Std
38 Zinc 79 Literature ` 0.126 Aquatic Life 408.2388 408.2388 Stream Std
39 Total Nitrogen 2268.48 2268.480 Design
40 Total Phos. 567.12 567.120 Design
41 Oil&Grease 89 LTMP
42 COD 92 LTMP
43 Aluminum 88 LTMP
44 Total Phenols _ 90 Literature 0.3 Water Supply 2041.1942 2041.1942 Stream Std
45
46 h
47 I
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Page 2of5
Workbook Name: HWA Spreadsheet 2019; Worksheet Name: HWA Printed 12/28/2020,7:05AM
-..-1 A I B I c I D I E I F I G I H I I I -I I K
49 Average Influent NH3(mg/1) 22.48
50 Average Anaerobic Digester NH,(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. 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/I) Source (lbs/day) (mg/I) Conc.Source Loading(lbs/day) (lbs/day) Source
53 BOD
54 TSS
55 Ammonia 85 Literature 480 Act.Sludge 1 142847.5200 142847.52 AS/Nit/TF in
56 Arsenic 45 Literature 0.1 Act.Sludge 8.1 163, 8.1163 AS/Nit/TF in
57 Cadmium 67 Literature 1 Act.Sludge 135.2723 135.2723 AS/Nit/TF in
58 Chromium 82 Literature 0.394 Nitrification 97.7117 97.7117 AS/Nit/TF in
59 Copper A 86 Literature 0.48 Nitrification 153.0509 153.0509 AS/Nit/TF in
60 Cyanide 69 Literature 0.1 Act.Sludge 14.4000 14.4000 AS/Nit/TF in
61 Lead 61 Literature 0.5 Nitrification 57.2306 57.2306 AS/Nit/TF in
62 Mercury 60 Literature 0.1 Act.Sludge 11.1600 11.1600 AS/Nit/TF in
63 Molybdenum
64 Nickel 42 Literature 0.25 Nitrification 19.2413 19.2413 AS/Nit/TF in
65 Selenium 50 Literature
66 Silver 75 Literature 0.25 Act.Sludge 44.6399 44.6399 AS/Nit/TF in
67 Zinc 79 Literature 1 Act.Sludge 212.5707 212.5707 AS/Nit/TF in
•
68 Total Nitrogen
69 Total Phos.
70 Oil&Grease _
71 COD r ,
72 Aluminum
73 Total Phenols
74 g
75 h
76 I
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Page 3 of 5
Workbook Name: HWA Spreadsheet 2019; Worksheet Name: HWA Printed 12/28/2020,7:05AM
I A I B I C I D I E I F I G I H I I I J I K
77
78 Sludge Loading Calculations
Class A Limits Class A Limits Class A Limits Mon. Minimum Minimum
Sludge Ceiling Sludge Ceiling Sludge Ceiling Load Cumulative Sludge Cumulative Monthly Monthly Avg. Avg.Load. - Sludge Sludge
Concentration Limit Load -HASL Calc.- Rate Limit Sludge Loading Average Rate Loading HASL Calc.- 1.oading 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 42.2391 36 41 23.0907 23.0907 Class A,Mor
84 Cadmium 85 32.1521 34 39 14.7522 14.7522 Class A,Mor
85 Chromium
86 Copper 4300 1267.1729 1338 1500 442.0371 442.0371 Class A,Mor
87 Cyanide
88 Lead 840 348.9919 267 300 124.6400 124.6400 Class A,Mot
89 Mercury 57 24.0763 15 17 7.1806 7.1806 Class A,Mol
90 Molybdenum 75 57.5988 57.5988 Sludge Ceilic
91 Nickel 420 253.4346 374 420 253.4346 253.4346 Sludge Ceilic
92 Selenium 100 50.6869 89 100 50.6869 50.6869 Sludge Ceilic
93 Silver
94 Zinc 7500 2406.0245 2498 2800 898.2492 898.2492 Class A,Mot
95 Total Nitrogen
96 Total Phos.
97 Oil&Grease
98 COD
99 Aluminum
100 Total Phenols
101 g
102 h
103 1
104
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Workbook Name: HWA Spreadsheet 2019; Worksheet Name: HWA Page4of5
Printed 12/28/2020,7:05 AM
A I B I C I D I E 11 F I G I H I I I J I K
105 \lax innnn Allowable Headworks Loading Calculation,
n13X11111/111
Minimum Pass Minimum Minimum Minimum Allowable Maximum Allowable
Through Loading Pass Through Inhibition Loading Inhibition Loading Sludge Loading Minimum Sludge Headworks Loading Headworks Loading
106 (lbs/day) Source (lbs/day) Source (lbs/day) Loading Sorce (lbs/day) Source
107 BOD 26512.9 Design 26512.9 Design
108 TSS 22543.0 Design 22543.0 Design
109 Ammonia 1559.6 Design 142847.5200 AS/Nit/TF inhibiti 1559.6 Design
110 Arsenic 12.3709 Stream Std 8.1163 AS/Nit/TF inhibiti 23.0907 Class A,Mon.Avg. 8.1163 AS/Nit/TF inhibition
111 Cadmium 1.2371 Stream Std 135.2723 AS/Nit/TF inhibiti 14.7522 Class A,Mon.Avg. 1.2371 Stream Std
112 Chromium 41.5799 Stream Std 97.7117 AS/Nit/TF inhibiti I 41.5799 Stream Std
113 Copper 38.3939 Stream Std 153.0509 AS/Nit/TF inhibiti 442.0371 Class A,Mon.Avg. 38.3939 Stream Std
114 Cyanide 10.9742 Stream Std 14.4000 AS/Nit/TF inhibiti I 10.9742 Stream Std
115 Lead 5.0594 Stream Std 57.2306 AS/Nit/TF inhibiti 124.6400 Class A,Mon.Avg. 5.0594 Stream Std
116 Mercury 0.02041 Stream Std 11.1600 AS/Nit/TF inhibiti 7.1806 Class A,Mon.Avg. 0.02041 Stream Std
117 Molybdenum 162.4831 Stream Std 57.5988 Sludge Ceiling 57.5988 Sludge Ceiling
118 Nickel 29.3275 Stream Std 19.2413 AS/Nit/TF inhibiti 253.4346 Sludge Ceiling 19.2413 AS/Nit/TF inhibition
119 Selenium 6.8040 Stream Std 50.6869 Sludge Ceiling 6.8040 Stream Std
120 Silver 0.1633 Stream Std 44.6399 AS/Nit/TF inhibiti 0.1633 Stream Std
121 Zinc 408.2388 Stream Std 212.5707 AS/Nit/TF inhibiti 898.2492 Class A,Mon.Avg. 212.5707 AS/Nit/TF inhibition
122 Total Nitrogen 2268.5 Design 2268.4800 Design
123 Total Phos. 567.1 Design 567.1200 Design
124 Oil&Grease
125,COD
126 Aluminum
127 Total Phenols 2041.2 Stream Std 2041.1942 Stream Std
128 g
129 h
130 1
131
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

Page 5 of 5
Workbook Name: HWA Spreadsheet 2019; Worksheet Name: HWA Printed 12/28/2020,7:05AM
J A ( B I C I D I E I F I G I H I 1 I J I K
1321
133 Maximum Allowable Industrial Loadings Calculations
Maximum Maximum
Allowable Uncontrollable Allowable
Headworks Loading Check to Use HASL Concentration Uncontrollable Uncontrollable Industrial Load Design vs.Pass-
134 Pollutant (lbs/day) MAHL Basis Cates (x) (mg/I) Source Load(lbs/day) (lbs/day) Thru Warning
135 BOD 26512.8600 Design 250 literature 7143.8355 19369.0245
136 TSS 22543.0200 Design 250 Literature 7143.8355 15399.1845
137 Ammonia 1559.5800 Design 29.6 Mass Balance 845.8301 713.7499
138 Arsenic 8.1163 AS/Nit/TF inhibition 0.1126 Mass Balance 3.2176 4.8988
139 Cadmium 1.2371 Stream Std 0.003 Literature 0.0857 1.1514
140 Chromium 41.5799 Stream Std j N/A 0.05 Literature 1.4288 40.1511
141 Copper 38.3939 Stream Std 0.0695 Mass 1.9860 36.4079
142 Cyanide 10.9742 Stream Std N/A 0.041 Literature 1.1716 9.8026
143 Lead 5.0594 Stream Std 0.005 Mass Balance 0.1429 4.9165
144 Mercury 0.02041 Stream Std 0.0003 Literature 0.00857 0.01184
145 Molybdenum 57.5988 Sludge Ceiling 0.002 Mass Balance 0.0572 57.5416
146 Nickel 19.2413 AS/Nit/TF inhibition 0.021 Literature 0.6001 18.6412
147 Selenium 6.8040 Stream Std 0.0044 Mass Balance 0.1257 6.6782
148 Silver 0.1633 Stream Std N/A 0.005 Literature 0.1429 0.0204
149 Zinc 212.5707 AS/Nit/TF inhibition 0.0175 Literature 0.5001 212.0706
150 Total Nitrogen 2268.4800 Design
,151 Total Phos. 567.1200 Design
152 Oil&Grease 50 Literature 1428.7671
153 Aluminum 3.0106 Mass Balance 86.0289
154
155 Total Phenols 2041.1942 Stream Std 0 0.0000 2041.1942
156 g
157h
158 1
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008

r
Workbook Name : HWA Spreadsheet 2019, Worksheet Name: AT Printed: 12/28/2020, 7:07 AM
Page 1 of 6
Allocation Table Spreadsheet Instructions:
Headworks last approved: 06/1 1/14 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: 12/16/20 3)HWA and AT worksheets in this workbook are linked. Pollutant Names,MAHLs,Basis,and Uncontrollable load in
Permits last modified: 05/31/20 this AT worksheet are automatically entered from the HWA spreadsheet. This includes pollutant names in columns AT
through BK.
Pores=> Catawba River
NPDES#=> NC0026573
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 listalphabeticly) number number Industry Date Date Expires , MGD gal/day mg/I lbs/day mg/I lbs/day
1 Case Farms #1098 Chicken Chicken 05/31/20 05/31/25 2.0000 2,000,000 500.00 8340.00 400.00 6672.00
2 Seiren #4002 Textile Textile 03/31/17 03/31/22 1.5000 1,500,000 500.00 6255.00 300.00 3753.00
3
4
5
6 __
7
8
9
10 _ 7
Column Totals=> 3.5000 3,500,000 14595 10425
—
Basis=> NPDES Design Design
MAHL from HWA(lbs/day)_> NPDES Permitted Flow=> 8.5000 26513 22543
Uncontrollable Loading(lbs/day)=> 3.4263 7144 7144
Total Allowable for Industry(MAIL)(lbs/day)_> 5.0737 19369 15399
Total Permitted to Industry(lbs/day)_> 3.5000 14595 10425
MAIL left(lbs/day)_> 1.5737 4774 4974
Percent Allow.Ind.(MAIL)still available(%)_> 31.0% 24.6% 32.3%
Percent MAI-LL still available(%)=> 18.5% 18.0% 22.1%
5 Percent MAHL(lbs/day)_> 0.4250 1326 1127
H WA.AT
Revised:November 2005

Workbook Name : HWA Spreadsheet 2019, Worksheet Name: AT Printed: 12/28/2020, 7:07 AM
Page 2 of 6
Allocation Table
Headworks last approved: 06/11/14
Allocation Table updated: 12/16/20
Permits last modified: 05/31/20
PoTW=> Catawba River
NPDES#=> NC0026573
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 list alphabcticls) number number mg/I lbs/day mg/1 lbs/day mg/I lbs/day mg/I lbs/day mg/I lbs/day i mg/I lbs/day
1 Case Farms #1098 Chicken k....mmm.
2 Seiren #4002 Textile 0.3250 4.0658 0.3250 4.0658_
3
4
5
67 a.
8 _
9
p_-
10
Column Totals=> I 0 1 0.0000 0.0000 4.0658, 4.0658 I 0.0000
AS/Nit/TF Stream
Basis=> Design inhibition Std Stream Std Stream Std Stream Std
MARL from HWA(lbs/day)_> 1559.58 8.1163 1.2371 41.5799 38.3939 10.9742
Uncontrollable Loading(lbs/day)_> 845.83 3.2176 0.0857 1.4288 1.9860 1.1716
Total Allowable for Industry(MAIL)(lbs/day)_> 713.75 4.8988 1.1514 40.1511 36.4079 9.8026
Total Permitted to Industry(lbs/day)_> 0.00 0.0000 0.0000 4.0658 4.0658 0.0000
MAIL left(lbs/day)_> 713.75 4.8988 1.1514 36.0854 32.3422 9.8026
Percent Allow.Ind.(MAIL)still available(%)_> 100.0% 100.0% 100.0% 89.9% 88.8% 100.0%
Percent MAHL still available(%)=> 45.8% 60.4% 93.1% 86.8% 84.2% 89.3%
5 Percent MAHL(lbs/day)_> 77.981 0.4058 0.0619 2.0790 1.9197 0.5487
HWA.AT
Revised:November 2005

Workbook Name : HWA Spreadsheet 2019, Worksheet Name: AT Printed: 12/28/2020, 7:07 AM
Page 3 of 6
Allocation Table
Headworks last approved: 06/11/14
Allocation Table updated: 12/16/20
Permits last modified: 05/31/20
Pores” Catawba River
NPDESi > NC0026573
Lead Mercury Molybdenum Nickel Selenium Silver
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 listalphalactid)) number number mg/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/I lbs/day mg/I lbs/day mg/I lbs/day
1 Case Farms #1098 Chicken
2 Seiren #4002 Textile 0.2500 3.1275 monitor #VALUE!
3
4
5
6
7
8
9
10
Column Totals=> 0.0000 0.000000 0.0000 3.1275 #VALUE! 0.0000
Stream Stream Sludge AS/Nit/TF
Basis=> Std Std Ceiling inhibition Stream Std Stream Std
MAHL from HWA(lbs/day)_> 5.0594 0.020412 57.5988 19.2413 6.8040 0.1633
Uncontrollable Loading(lbs/day)=> 0.1429 0.008573 0.0572 0.6001 0.1257 0.1429
Total Allowable for Industry(MAIL)(lbs/day)_> 4.9165 0.011839 57.5416 18.6412 6.6782 0.0204
Total Permitted to Industry(lbs/day)=> 0.0000 0.000000 0.0000 3.1275 #VALUE! 0.0000
MAIL left(lbs/day)_> 4.9165 0.011839 57.5416 15.5137 #VALUE! 0.0204
Percent Allow.Ind.(MAIL)still available(%)=> 100.0% 100.0% 100.0% 83.2% #VALUE! 100.0%
Percent MAHL still available(%)_> 97.2% 58.0% 99.9% 80.6% #VALUE! 12.5
5 Percent MARL(lbs/day)_> 0.2530 0.001021 2.8799 0.9621 0.3402 0.0082
HWA.AT
Revised:November 2005

Workbook Name : HWA Spreadsheet 2019, Worksheet Name: AT Printed: 12/28/2020, 7:07 AM
Page 4 of 6
Allocation Table
Headworks last approved: 06/11/14
Allocation Table updated: 12/16/20
Permits last modified: 05/31/20
Polw=> Catawba River
NPDES > NC0026573
Zinc Total Nitrogen Total Phos. COD Oil& Grease
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 listalphabetidr) number J number mg/I lbs/day mg/I lbs/day mg/I lbs/day mg/I lbs/day mg/I lbs/day
1 Case Farms #1098 Chicken 2000.0000 33360.0000 100.0000 1668.0000
2 Seiren #4002 Textile 0.4500 5.6295 2000.0000 25020.0000
3
4
5
6
7
8
9 _
10
Column Totals=> I 5.6295i t 0.00 0.00 58380.0000 1668.0000
AS/Nit/TF
Basis=> inhibition Design Design
MAHL from HWA(lbs/day)_> 212.5707 2268.4800 567.12
Uncontrollable Loading(lbs/day)_> 0.5001, 1428.7671 86.0289
Total Allowable for Industry(MAIL)(lbs/day)=> 212.0706 #VALUE! #VALUE!
Total Permitted to Industry(lbs/day)_> 5.6295 0.00 0.00 58380.0000 1668.0000
MAIL left(lbs/day)=> 206.4411 #VALUE! #VALUE!
Percent Allow.Ind.(MAIL)still available(%)_> 97.3% #VALUE! #VALUE! #VALUE! #VALUE!
Percent MARL still available(%)=> 97.1 % #VALUE! #VALUE! #VALUE! #VALUE!
5 Percent MAHL(lbs/day)=> 10.6285 113.42 28.3560
HWA.AT
Revised:November 2005

Workbook Name : HWA Spreadsheet 2019, Worksheet Name: AT Printed: 12/28/2020, 7:07 AM
Page 5 of 6
Allocation Table
Headworks last approved: 06/11/14
Allocation Table updated: 12/16/20
Permits last modified: 05/31/20
PoTw=> Catawba River
NPDES#=> NC0026573
Aluminum I
Industry Permit
IUP INDUSTRY NAMES Permit Pipe Conc. Load
Count (plcasclistalphabetick) number number mg/I lbs/day
1 Case Farms #1098 Chicken
2 Seiren #4002 Textile
3
4
5
6
7
8
9
10
Column Totals=> 0.0000
Basis=>
MAHL from HWA(lbs/day)_>
Uncontrollable Loading(lbs/day)=>
Total Allowable for Industry(MAIL)(lbs/day)_>
Total Permitted to Industry(lbs/day)=> 0.0000
MAIL left(lbs/day)=>
Percent Allow.Ind.(MAIL)still available(%)_> #VALUE!
Percent MARL still available(%)_> #VALUE!
5 Percent MAHL(lbs/day)_>
HWA.AT
Revised:November 2005

Workbook Name : HWA Spreadsheet 2019, Worksheet Name: AT Printed: 12/28/2020, 7:07 AM
Page 6 of 6
Allocation Table
Headworks last approved: 06/11/14
Allocation Table updated: 12/16/20
Permits last modified: 05/31/20
Pores=> Catawba River
NPDES# > NC0026573
Total phenols g h I
Industry Limits Permit Limits Permit Limits Permit Limits
IUP INDUSTRY NAMES Permit Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (please listalphabctidc) number number mg/1 lbs/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day
1 Case Farms #1098 Chicken
2 Seiren #4002 Textile 5.0000 62.5500
3
4
6
7
8
9
10
(Column Totals=> 62.5500 0.0000 0.0000 0.0000
Basis=> Stream Std
MAHL from HWA(lbs/day)_> 2041.1942
Uncontrollable Loading(lbs/day)_> 0.0000
Total Allowable for Industry(MAIL)(lbs/day)_> 2041.1942
Total Permitted to Industry(lbs/day)_> 62.5500 0.0000 0.0000 0.0000
MAIL left(lbs/day)_> 1978.6442
Percent Allow.hid.(MAIL)still available(%)_> 96.9% #VALUE! #VALUE! #VALUE!
Percent MAHL still available(%)_> 96.9% #VALUE! #VALUE! #VALUE!
5 Percent MARL(lbs/day)_> 102.0597
HWA.AT
Revised:November 2005

Removal Rate Calculations
FLOW BOD TSS AMMONIA
INF/EFF Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date mgd < mg/L Calculation< mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation < m: L Calculation
9/2019 DMR AVG Spreadsheet 4.86 424 424 4.1 4.1 340 340 4.7 4.7 17.3 17.3 < 0.5 0.25
Instructions
10/2019 DMR AVG 1) Data 5.01 434 434 3.8 3.8 385 385 4.2 4.2 23.I 23.1 < 0.5 0.25
entered only 1
11/2019 DMR AVG in Heavy 5.49 456 456 8.8 8.8 411 411 10.0 10 22.8 22.8 < 0.5 0.25
12/2019 DMR AVG Bordered 5.91 311 311 5.0 5 430 430 6.0 6 23 23 < 0.5 0.25
cells. Rest
1/2020 DMR AVG of work heet 5.43 457 457 9.8 9.8 360 11.0 11 18.4 18.4 0.5 0.25
2/2020 DMR AVG is protected. --
password is 7.54 404 404 ' 28 28 410 410 25 25 17 17 1.45 1.45
3/2020 DMR AVG 2 5.07 541 541 10.2 10.2 508 508 11.8 11.8 23.I 23.1 < 0.5 0.25
4/2020 DMR AVG 2) For below 4.60 481 481 8.5 8.5 471 471 16 16 21
i detection
5/2020 DMR AVG data,enter 5.56 523 523 9 9 357 357 9.7 9.7 26 26 < I 0.25
6/2020 DMR AVG column,and 4.98 436 436 4.7 4.7 350 350 7.9 7.9 27
7/2020 DMR AVG enter 4.02 449 449 5.3 5.3 596 596 7.5 7.5 24 I 0.25
detection
8/2020 DMR AVG level in 5.76 492 492 4.8 4.8 515 515 72 7.2 27 27 < I 0.25
Influent or
Effluent mg/I
columns. ` I / 4 I -
Spreadsheet
will auto-
matically
calculate
averages I
and removal
rates using
1/2 value � r �mINMEN,
entered.
Ninnonr
3)Document
removal �.�►
Rate choice _
Column Averages=> 4)Formulas 5.3525 450.667 8.5 427.75 10.083333 22.475 0.35
in Compre-
hensive Unpaired Site Specific RR=> 98.11 % Unpaired Site Specific RR=> 97.64% Unpaired Site Specific RR=> 98.44%
Guide HWA
Chapter, Literature/Default RR=> 85.00% Literature/Default RR=> 85.00% Literature/Default RR=> 85.00%
Section E,
page 1. 0 % of data is BDL 0 % of data is BDL 46 % of data is BDL
RR for this HWA=> 98.00% RR for this HWA=> 98.00% RR for this HWA=> 98.00%
Removal Rate Spreadsheet 2019
Removal Rates eff(2)
Page 1 of 7 pages
12/28/2020, 7:14 AM
Revision:August 1999

Removal Rate Calculations
I
ARSENIC CADMIUM CHROMIUM
INF/EFF II Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date m: L Calculation < m_ L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation < m L Calculation
9/2019 DMR AVG 0 0.010 0.005 Q 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
10/2019 DMR AVG 0.044 0.044 Q 0.010 III < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
11/2019 DMR AVG < 0.010 0.005 li 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
12/2019 DMR AVG < 0.010 0.005 Q 0.010 0.005 < 0.0002 0.0001,,< 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
1/2020 DMR AVG < 0.010 0.005 Q 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
2/2020 DMR AVG < 0.010 0.005 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
3/2020 DMR AVG < CI.010 0.005 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
4/2020 DMR AVG < CI.010 0.005 0.010 0.005 < 0.0002 0.0001 <f 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
5/2020 DMR AVG 1 1 I 0.005 IN 0.010 0.005 < 0.0002 0.0001 �< 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
6/2020 DMR AVG IN 0.010 0.005 Q 0.010 0.005 0.002 0.002 < 0.0002 0.0001 0.002 0.002 < 0.001 0.0005
7/2020 DMR AVG IN 0.010 0.005 Q 0.010 0.005 < 0.002 0.001 < 0.0002 0.0001 0.008 0.008 < 0.001 0.0005
8/2020 DMR AVG < 0.010 0.005 Q 0.01 0.005 0.0003 0.0003 < 0.0002 0.0001 0.006 0.006 0.001 0.001
111
Column Averages=> 0.0083 0.0050 0.0004 0.0001 0.0017 0.0005
Unpaired Site Specific RR=>I>50%BDL Unpaired Site Specific RR=>I>50%BDL Unpaired Site Specific RR=>'50%BDL
Literature/Default RR=> 45.00% Literature/Default RR=>L 67.00% Literature/Default RR=> 82.00%
96 " of data is BDL 92 'io of data is BDL 83 % of data is BDL
RR for thi, I I\V'_A 45.00% RR for this 11WA 67.00% ER Inr this I I\\-A = 82.00%
Removal Rate Spreadsheet 2019
Removal Rates eff(2)
Page 2 of 7 pages
12/28/2020, 7:14 AM
Revision:August 1999

Removal Rate Calculations
COPPER CYANIDE LED
INF/EFF 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
9/2019 DMR AVG 0.055 0.055 0.002 0.002 0.011 0.011 0.005 0.005 < 0.010 0.005 < 0.010 0.005
10/2019 DMR AVG 0.031 0.031 0.010 0.01 0.011 0.011 < 0.005 0.0025 < 0.010 0.005 < 0.010 0.005
11/2019 DMR AVG 0.064 0.064 0.010 0.01 0.007 0.007 < 0.005 0.0025 < 0.010 0.005 < 0.010 0.005
12/2019 DMR AVG 0.018 0.018 0.006 0.006 0.010 0.01 < 0.005 0.0025 < 0.010 0.005 < 0.010 0.005
1/2020 DMR AVG 0.099 0.099 0.033 0.033 i 0.015 0.015 < 0.005 0.0025 < 0.010 0.005 < 0.010 0.005
2/2020 DMR AVG 0.041 0.041 < 0.001 0.0005 0.008 0.008 0.0025 < 0.010 0.005 < 0.010 0.005
3/2020 DMR AVG 0.064 0.064 0.007 0.007 0.014 0.014 < 0.005 0.0025 < 0.010 0.005 < 0.010 0.005
4/2020 DMR AVG 0.27 0.27 0.014 0.014 0.012 0.012 0.005 0.005 < 0.010 0.005 < 0.010 0.005
5/2020 DMR AVG 0.019 0.019 0.009 0.009 0.011 0.011 < 0.005 0.0025 < 0.010 0.005 < 0.010 0.005
6/2020 DMR AVG 0.064 0.064 0.004 0.004 0.009 0.009 < 0.005 0.0025 < 0.010 0.005 < 0.010 0.005
7/2020 DMR AVG 0.078 0.078 0.007 0.007 1 0.016 0.016 < 0.005 0.0025 < 0.010 0.005 < 0.010 0.005
8/2020 DMR AVG 0.047 0.047 0.006 0.006 1 0.012 0.012 0.005 0.005 < 0.01 0.005 < 0.01 0.005
Column Averages=> 0.0708 0.0090 0.0113 0.0031 0.0050 0.0050
Unpaired Site Specific RR=> 87.24% Unpaired Site Specific RR=> 72.43% Unpaired Site Specific RR=>o 50%BDI
Literature/Default RR=> 86.00% Literature/Default RR=> 69.00% Literature/Default RR=> 61.00%
4 °„ of data is BDL 38 % of data is BDL 100 % of data is BDL
I:I: for this II11;A 86.00% RR l'01.thk I1\1,-\ 69.00% RR for this11\\,A 61.00%
Removal Rate Spreadsheet 2019
Removal Rates eff(2)
Page 3 of 7 pages
12/28/2020, 7:14 AM
Revision:August 1999

Removal Rate Calculations
MERCURY MOLYBDENUM
INF/EFF 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 < tut L Calculation < mg/L Calculation < mg/L Calculation
9/2019 DMR AVG 0.0002 0.0002�< 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005
10/2019 DMR AVG 0.0002 0.0002 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005 0.009 0.009
11/2019 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005
12/2019 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 0.041 0.041 < 0.001 0.0005
1/2020 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.033 0.0165 < 0.001 0.0005 < 0.001 0.0005
2/2020 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005
3/2020 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005
4/2020 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005
5/2020 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 < 0.001• 0.0005 < 0.001 0.0005
6/2020 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005 < 0.001 0.0005
7/2020 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 0.003 0.003 < 0.001 0.0005 0.002 0.002 < 0.001 0.0005
8/2020 DMR AVG < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005 0.002 0.002 < 0.001 0.0005
-
Column Averages=> 0.00008 0.00005 0.0007 0.0018 0.0041 0.0012
Unpaired Site Specific RR=>p 50%BDL Unpaired Site Specific RR=>p 50%BDL Unpaired Site Specific RR=>1>50%BDI
Literature/Default RR=> 60.00% Literature/Default RR=> 33.00% Literature/Default RR=> 42.00%
92 °i, of data is BDL 96 % of data is BDL 83 °,, of data is BDL
RI: for this I I\V'..A = 60.00% RR for this HWA= 33.00% RR for this I I\\ \ 42.00%
Removal Rate Spreadsheet 2019
Removal Rates eff(2)
Page 4 of 7 pages
12/28/2020, 7:14 AM
Revision:August 1999

Removal Rate Calculations
SILVER
INF/EFF Influent Used in Effluent Used in II
Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date < mg/L Calculation < mg/L Calculation mg/L Calculation < m_ L Calculation < mg/L Calculation < mg/L Calculation
9/2019 DMR AVG < 0.010 0.005 < 0.010 0.005 0.018 0.018 I
0.006 0.006 0.155 0.155 0.042 0.042
10/2019 DMR AVG < 0.010 0.005 < 0.010 0.005 0.001 0.0005 0.001 0.0005 0.128 0.128 0.020 0.02
11/2019 DMR AVG `� 0.005 < 0.010 0.005 0.001 0.0005 8 11 0.0005 � 0.264 0.054 0.054
12/2019 DMR AVG < 0.010 0.005 < 0.010 0.005 0.001 0.0005 1 11 0.0005 0.172 0.172 0.010 0.01
1/2020 DMR AVG < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 8 1 11 0.0005 0.373 0.373 0.157 0.157
2/2020 DMR AVG < 0.010 0.005 < 0.010 0.005 0.001 0.0005 0.001 0.0005 0.178 0.178 0.077 0.077
3/2020 DMR AVG < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 0 0.001 0.0005 0.224 0.224 0.089 0.089
4/2020 DMR AVG < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 E 0.001 0.0005 0.105 0.105 0.038 0.038
5/2020 DMR AVG < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 8 0.001 0.0005 0.089 0.089 0.021 0.021
6/2020 DMR AVG < 0.010 0.005 < 0.010 0.005 0.001 0.0005 0.001 0.0005 0.214 0.214 0.024 0.024
7/2020 DMR AVG < 0.010 0.005 < 0.010' 0.005 0.002 0.002 Q 0.001 0.0005 0.245 0.245 0.054 0.054
8/2020 DMR AVG < 0.010 0.005 < 0.010 0.005 0.003 0.003 Q 0.001 0.0005 0.281 0.281 0.016 0.016
II-- ,
.
I-_-
t
I
Column Averages=> 0.0050 0.0050 0.0023 0.0010 0.2023 0.0502
Unpaired Site Specific RR=4 50%BDL Unpaired Site Specific RR=>L50%BDL Unpaired Site Specific RR=> 75.21
Literature/Default RR=> 50.00% Literature/Default RR=> 75.00% Literature/Default RR=> 79.00%
100 of data is BDL S3 % of data is BDL n "�, of data is BDL
RR for this I 1\\ 1 50.00% RR for this 1-IWA ° 75.00% RR Ior this I 1\1,1 - 79.00%
Removal Rate Spreadsheet 2019
Removal Rates eff(2)
Page 5 of 7 pages
12/28/2020, 7:14 AM
Revision:August 1999

Removal Rate Calculations
Oil&Grease COD
INF/EFF 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
9/2019 DMR AVG 1.42 1.42 0.181 0.181
10/2019 DMR AVG 6.2 6.2 _ 1.4 1.4 704 704 32 32
•
11/2019 DMR AVG
12/2019 DMR AVG
1/2020 DMR AVG 4.2 4.2 < 1 0.5 5.39 5.39 0.604 0.604 633 633 59 59
2/2020 DMR AVG
3/2020 DMR AVG
4/2020 DMR AVG
•
5/2020 DMR AVG
•
6/2020 DMR AVG
7/2020 DMR AVG 25 25 2.1 2.1 1.85 1.85 0.221 0.221 574 574 52.75 52.75
8/2020 DMR AVG
Column Averages=> 11.8000 1.3333 2.8867 0.3353 637.0000 47.9167
Unpaired Site Specific RR=> 88.70% Unpaired Site Specific RR=> 88.38% Unpaired Site Specific RR=> 92.48%
Literature/Default RR=>II Literature/Default RR=>II Literature/Default RR=>II
17 % of data is BDL 0 % of data is BDL 0 % of data is BDL
RR for this HWA=> 89.00% RR for this HWA=> 88.00% RR for this HWA=> 92.00%
Removal Rate Spreadsheet 2019
Removal Rates eff(2)
Page 6 of 7 pages
12/28/2020, 7:14 AM
Revision:August 1999

Removal Rate Calculations
INF/EFF 111
Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
_Sample Date m: L Calculation mg/L Calculation < mg/L. Calculation < mg/L Calculation < mg/L Calculation
9/2019 DMR AVG III �� �_
10/2019 DMR AVG
11/2019 DMR AVG
12/2019 DMR AVG —~
1/2020 DMR AVG —I
2/2020 DMR AVG _I—3/2020 DMR AVG ——
4/2020 DMR AVG —I——
I
5/2020 DMR AVG —— / _
6/2020 DMR AVG —111—7/2020 DMR AVG —I—8/2020 DMR AVG II——
' -111
111--
I
I�� .
I
II_— --
Column Averages=>
Unpaired Site Specific RR=> Unpaired Site Specific RR=> Unpaired Site Specific RR=>
Literature/Default RR=>I Literature/Default RR=>II Literature/Default RR=>
of data is BDL of data is BDL of data is BDL
RR for this HWA=>L..— RR for this HWA=>L I RR for this HWA=>�
Removal Rate Spreadsheet 2019
Removal Rates eff(2)
Page 7 of 7 pages
12/28/2020, 7:14 AM
Revision:August 1999

I
Removal Rate Calculations
FLOW BOD AMMO IA
INF/Primary Eff Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date mgd mg/L Calculation< mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation
9/2019 DMR AVG/LTMP Spreadsheet 4.86 340 340 112 112 17.3 17.3 27.2 27.2
Instructions:
10/2019 DMR AVG/LTMP 1) Data 5.01 385 385 150 150 23.1 23.1 23.8 23.8
entered only
11/2019 DMR AVG/LTMP in Heavy 411 411 100 100 22.8i 22.8 24 24
12/2019 DMR AVG/LTMP Bordered 5.91 430 430 128 128 23 23 24 24 '
cells. Rest of
1/2020 DMR AVG/LTMP worksheet is 5.43 360 360 140 140 18.4 18.4 23 23
protected, 1 f� "r
2/2020 DMR AVG/LTMP password is 7.54 410 410 130 130 17 17 17 17
3/2020 DMR AVG/LTMP 2 508 508 ~296 296 23.) 23.1 18.5 18.5
4/2020 DMR AVG/LTMP 2) For below 4.60 471 471 86 86 21 21 27 27
5/2020 DMR AVG/LTMP data,enter 5.56 357 357 136 136 26 26 28 28
6/2020 DMR AVG/LTMP column,and 4.98 350 350 193 193 27 27 34 34
7/2020 DMR AVG/LTMP de entertection 4.02 596 596 212 212 24 24 28 28
8/2020 DMR AVG/LTMP level in 5.76 515 515 94 94 27 27 26 26
Influent or
Effluent mg/I
columns.
Spreadsheet
will auto-
matically , N.. ,
calculate
averages and
removal rates
using 1/2 I".
value , r
entered.
3)Document
removal Rate �'" " '��
choice
Column Averages=> 4)Formulas 5.3525 427.75 148.083 22.475 25.041667
in Compre-
hensive Unpaired Site Specific RR=>0 Unpaired Site Specific RR=> 65.38% Unpaired Site Specific RR=> -11.42%
Guide HWA
Chapter, Literature/Default RR=> 85.00% Literature/Default RR=> 85.00% Literature/Default RR=> 85.00%
Section E,
page 1. of data is BDL 0 % of data is BDL 0 % of data is BDL
RR for this HWA=> 98.00% RR for this HWA=> 98.00% RR for this HWA=> 98.00%
Removal Rate Spreadsheet 2019
Removal Rates primary eff
Page 1 of 7 pages
12/28/2020, 7:16 AM
Revision:August 1999

Removal Rate Calculations
CADMIUM CHROMIUM
INF/Primary Eff 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
9/2019 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 0.009 0.009
10/2019 DMR AVG/LTMP 0.044 0.044 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
11/2019 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 0.036 0.036
12/2019 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
1/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
2/2020 DMR AVG/LTMP < 0.0101 0.005 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
3/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 < 0.001 0.0005
4/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 0.003 0.003
5/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.0002 0.0001 < 0.0002 0.0001 < 0.001 0.0005 0.005 0.005
6/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 0.002 0.002 < 0.0002 0.0001 0.002 0.002 0.005 0.005
7/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.002 0.001 < 0.0002 0.0001 0.008 0.008 0.005 0.005
8/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 0.0003 0.0003 < 0.0002 0.0001 0.006 0.006 0.001 0.001
Column Averages=> 0.0083 0.0050 0.0004 0.0001 0.0017 0.0055
Unpaired Site Specific RR=>p 50%BDL Unpaired Site Specific RR=>[50%BDL Unpaired Site Specific RR=>p 50%BD[
Literature/Default RR=> 45.00% Literature/Default RR=> 67.00% Literature/Default RR=> 82.00%
96 of data is BDL 92 of data is BDL 58 % of data is BDL
RR for this I-I WA 45.00% RR for this 11\\ \ 67.00% RR for?hi, 1 I\\A 82.00%
Removal Rate Spreadsheet 2019
Removal Rates primary eff
Page 2 of 7 pages
12/28/2020, 7:16 AM
Revision:August 1999

Removal Rate Calculations
COPPER CYANIDE LEAD
INF/Primary Eff 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 < m_ L Calculation
9/2019 DMR AVG/LTMP 0.055 0.055 0.043 0.043 0.011 0.01 I 0.008 0.008 < 0.010 0.005 < 0.010 0.005
10/2019 DMR AVG/LTMP 0.031 0.031 0.023 0.023 0.011 0.011 0.009 0.009 < 0.010 0.005 < 0.010 0.005
11/2019 DMR AVG/LTMP 0.064 0.064 0.046 0.046 0.007 0.007 0.013 0.013 < 0.010 0.005 < 0.010 0.005
12/2019 DMR AVG/LTMP 0.018 0.018 0.023 0.023 0.010 0.01 0.008 0.008 < 0.010 0.005 < 0.010 0.005
1/2020 DMR AVG/LTMP 0.099 0.099 0.056 0.056 0.015 0.015 0.01 0.01 < 0.010 0.005 < 0.010 0.005
2/2020 DMR AVG/LTMP 0.041 0.041 0.046 0.046 0.008 0.008 0.009 0.009 < 0.010 0.005 < 0.010 0.005
3/2020 DMR AVG/LTMP 0.064 0.064 0.038 0.038 0.014 0.014 0.008 0.008 < 0.010 0.005 < 0.010 0.005
4/2020 DMR AVG/LTMP 0.27 0.27 0.048 0.048 0.012 0.012 0.007 0.007 < 0.010 0.005 < 0.010 0.005
5/2020 DMR AVG/LTMP 0.019 0.019 0.057 0.057 0.011 0.011 0.007 0.007 < 0.010 0.005 < 0.010 0.005
6/2020 DMR AVG/LIMP 0.064 0.064 0.067, 0.067 0.009 0.009 0.007 0.007 < 0.010 0.005 < 0.010 0.005
7/2020 DMR AVG/LIMP 0.078 0.078 0.064 0.064 0.016 0.016 0.008 0.008 < 0.010 0.005 < 0.010 0.005
8/2020 DMR AVG/LTMP 0.047 0.047 0.033 0.033 0.012 0.012 0.007 0.007 < 0.01 0.005 < 0.010 0.005
11
Column Averages=> 0.0708 0.0453 0.0113 0.0084 0.0050 0.0050
Unpaired Site Specific RR=> 36.00% Unpaired Site Specific RR=> 25.74% Unpaired Site Specific RR=>p 50%BDI
Literature/Default RR=> 86.00% Literature/Default RR=> 69.00% Literature/Default RR=> 61.00%
0 °I, of data is BDL 0 "o of data is BDL 100 % of data is BDL
RR for this HWA 86.00% RR for this I I\\_1 69.00% RR for this1111'A 61.00%
Removal Rate Spreadsheet 2019
Removal Rates primary eff
Page 3 of 7 pages
12/28/2020, 7:16 AM
Revision:August 1999

Removal Rate Calculations
MERCURY MOLYBDENUM
INF/Primary Eff 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
9/2019 DMR AVG/LTMP 0.0002 0.0002 , 0.0004 0.0004 < 0.001 0.0005 < 0.0011 0.0005
10/2019 DMR AVG/LTMP 0.0002 0.0002 0.0004 0.0004 < 0.001 0.0005 0.004 0.004
11/2019 DMR AVG/LTMP < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 <r 0.001 0.0005
12/2019 DMR AVG/LTMP < 0.0001 0.00005 < 0.0001 0.00005 0.041 0.041 0.047 0.047
1/2020 DMR AVG/LTMP < 0.0001 0.00005 0.00005 < 0.001' 0.0005 < 0.001 0.0005
2/2020 DMR AVG/LTMP 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005
3/2020 DMR AVG/LTMP < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005
4/2020 DMR AVG/LTMP < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005
5/2020 DMR AVG/LTMP < 0.0001 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005
6/2020 DMR AVG/LTMP < 0.0001' 0.00005 < 0.0001 0.00005 < 0.001 0.0005 < 0.001 0.0005
7/2020 DMR AVG/LTMP < 0.0001 0.00005 < 0.0001 0.00005 0.002 0.002 < 0.001 0.0005
8/2020 DMR AVG/LTMP < 0.0001 0.00005 < 0.0001 0.00005 0.002 0.002 < 0.00I 0.0005
Column Averages=> 0.00008 0.00011 0.0041 0.0047
Unpaired Site Specific RR=>p 50%BDL Unpaired Site Specific RR=> Unpaired Site Specific RR=> 50%BDL
Literature/Default RR=> 60.00% Literature/Default RR=> 33.00% Literature/Default RR=> 42.00%
83 °0 of data is BDL of data is BDL 79 `%, of data is BDL
RR for thisHWA-- 60.00% ER forthi: II\V'.A 33.00% RR for thisI!WA - 42.00%
Removal Rate Spreadsheet 2019
Removal Rates primary eff
Page 4 of 7 pages
12/28/2020, 7:16 AM
Revision:August 1999

Removal Rate Calculations
SELENIUM
INF/Primary Eff 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
9/2019 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 i 0.022 0.022 0.006 0.006 0.155 0.155 0.051 0.051
10/2019 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.128 0.128 0.020 0.02
11/2019 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.264 0.264 0.135 0.135
12/2019 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.172 0.172 0.171 0.171
1/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.373 0.373 1.100 1.1
2/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.178 0.178 0.164 0.164
3/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.224 0.224 0.127r 0.127
4/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.105 0.105 0.112 0.112
5/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.089 0.089 0.124 0.124
6/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.214 0.214 0.315 0.315
7/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 < 0.001 0.0005 < 0.001 0.0005 0.245 0.245 0.112 0.112
8/2020 DMR AVG/LTMP < 0.010 0.005 < 0.010 0.005 0.001 0.001 < 0.001 0.0005 0.281 0.281 0.189 0.189
Column Averages=> 0.0050 0.0050 0.0023 0.0010 0.2023 0.2183
Unpaired Site Specific RR=>I>50%BDL Unpaired Site Specific RR=>p 50%BDL Unpaired Site Specific RR=> -7.91 %
Literature/Default RR=> 50.00% Literature/Default RR=> 75.00% Literature/Default RR=> 79.00%
100 °i, of data is BDL S8 of data is BDL 0 '%, of data is BDL
RR for this II WA 50.00% RR for this II\\A 75.00% RR for till, II\\ \ 79.00%
Removal Rate Spreadsheet 2019
Removal Rates primary eff
Page 5 of 7 pages
12/28/2020, 7:16 AM
Revision:August 1999

Removal Rate Calculations
Oil&Grease COD
INF/Primary Eff 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
9/2019 DMR AVG/LTMP
10/2019 DMR AVG/LTMP
11/2019 DMR AVG/LTMP
12/2019 DMR AVG/LTMP
1/2020 DMR AVG/LTMP < ,
2/2020 DMR AVG/LTMP _
3/2020 DMR AVG/LTMP
4/2020 DMR AVG/LTMP
5/2020 DMR AVG/LTMP _
6/2020 DMR AVG/LTMP
7/2020 DMR AVG/LTMP _
8/2020 DMR AVG/LTMP
Column Averages=>
Unpaired Site Specific RR=>I Unpaired Site Specific RR=>II Unpaired Site Specific RR=>I
Literature/Default RR=>I Literature/Default RR=>II Literature/Default RR=>
of data is BDL of data is BDL of data is BDL
RR for this HWA=> 89.00% RR for this HWA=> 88.00% RR for this HWA=> 92.00%
Removal Rate Spreadsheet 2019
Removal Rates primary eff
Page 6 of 7 pages
12/28/2020, 7:16 AM
Revision:August 1999

Removal Rate Calculations
INF/Primary Eff Influent Used in Effluent Used in InIIuent Used in Effluent I Used in Influent Used in Effluent Used in
Sample Date < mg/L Calculation < mg/L Calculation < m g/1_ Calculation < mg/L Calculation < mg/L Calculation_< mg/L Calculation
9/2019 DMR AVG/LTMP
10/2019 DMR AVG/LTMP
11/2019 DMR AVG/LTMP
12/2019 DMR AVG/LTMP
1/2020 DMR AVG/LTMP 1
2/2020 DMR AVG/LTMP
3/2020 DMR AVG/LTMP _
4/2020 DMR AVG/LTMP
5/2020 DMR AVG/LTMP
6/2020 DMR AVG/LTMP
7/2020 DMR AVG/LTMP
8/2020 DMR AVG/LTMP
,
Column Averages=>
Unpaired Site Specific RR=> Unpaired Site Specific RR=> Unpaired Site Specific RR=>
Literature/Default RR=>II Literature/Default RR=>� Literature/Default RR=>I
of data is BDL of data is BDL of data is BDL
RR for this HWA=>` I RR for this HWA=>II RR for this HWA=>�..1
Removal Rate Spreadsheet 2019
Removal Rates primary eff
Page 7 of 7 pages
12/28/2020, 7:16 AM 1
Revision:August 1999

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/I lbs/day
1 Case Farms 1098 1.5295 1,529,500 568.67 7253.97 117.75 1502.02 12.2 155.6236
2 Seiren 4002 0.39667 396,670 172.58 570.93 20.08 66.43 0.39 1.2902
4
5 1
6
8
ram.9
10
11
r
12
13
Sum of Industrial Loading(lbs/day)=> 1.9262 1926170 I 7,824.9055 1,568.4517 156.9138
MGD gal/day mg/1 lbs/day mg/I lbs/day mg/I lbs/day
Avg Influent loading(lbs/day)=> 5.35251 5,352,500 450.67 20117.84 427.83 19098.27 22.48 1003.5038
Uncontrollable Load from Mass Bal(lbs/day)=> 3.4263 12,292.9357 17,529.8153 846.5901
Uncontrollable Concen. from Mass Bal(mg/L)=> I 4301 I 6131 I- 29.61
Uncont. from Uncont. Sampling(mg/L+lbs/day)_>
Uncontrollable Concen. From Literature(mg/L)=> I 250I I25 J I 251
Uncontrollable conc. to be used in HWA (ma:'l.)_> 250 250 25
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 C
protected,password is"2". "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.
Uncontrollable(Primary)Mass Balance Spreadsheet 2019
SIU.Uncont.Mass.Bal
Page 1 of 6 pages
12/28/2020,7:17 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/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 Case Farms 1098 1.5295 1,529,500 0.005 0.0638 0.0011 0.0140 0.0073 0.0931 0.0188 0.2398
2 Seiren 4002 0.39667 396,670 0.005 0.0165 0.0018 0.0060 0.0006 0.0020 0.01 0.0331
3
4
5
6
7
8
10
11
12
13
Sum of Industrial Loading(lbs/day)=> 1.9262 1926170 0.0803 0.0200 0.0951 ( 0.2729
MGD gal/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)_> 5.35251 5,352,500 0.08031 3.5846 0.00011 0.0045 0.0021 0.0893 0.05061 2.2588
Uncontrollable Load from Mass Bal(lbs/day)=> 3.4263 3.5043 -0.0155 -0.0058 1.9859
Uncontrollable Concen. from Mass Bal(mg/L)=> I 0.12261 I -0.0005I I -0.00021 I 0.06951
Uncont. from Uncont. Sampling(mg/L+lbs/day)_>
Uncontrollable Concen. From Literature(mg/L)_> 1 0.0031 1 0.0031 I 0.051 I 0.0611
Uncontrollable conc.to be used in IIN A => 0.003 0.003 0.05 0.0695
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is ;oncentration From Choose"Uncontrollable Concentration to be used in HWA"(row 31)from
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.
Uncontrollable(Primary)Mass Balance Spreadsheet 2019
SIU.Uncont.Mass.Bal
e Pa92of6 pages
12/28/2020,7:17 AM
Revision:August 1999

SIU.Uncont.Mass.BaI
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/I lbs/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day
1 Case Farms 1098 1.5295 1,529,500 0.0115 0.1467 0.005 0.0638 0.00013 0.00166 0.0048 0.0612
2 Seiren 4002 0.39667 396,670 0.0105 0.0347 0.005 0.0165 0.00005 0.00017 0.0075 0.0248
3
4
•
6
7
•
8
9 _
10 _
11
12
13
Sum of Industrial Loading(lbs/day)=> 1.9262 1926170 0.1814 0.0803 0.00182 0.0860
MGD gal/day mg/1 lbs/day , mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)_> 5.3525 5,352,500 0.01131 0.50441 0.0051 0.2232 0.000081 0.00357 0.00071 0.0312
Uncontrollable Load from Mass Bal(lbs/day)=> 3.4263 0.3230 0.1429 0.00175 -0.0548
Uncontrollable Concen. from Mass Bal(mg/L)=> I 0.0113I I 0.00501 I 0.000061 I -0.00191
Uncont. from Uncont. Sampling(mg/L+lbs/day)=>
Uncontrollable Concen. From Literature(mg/L)_> I 0.0411 I 0.0491 I 0.00031
Uncontrollable cone. to he used in IIVVA (me/I.)_> 0.041 0.005 0.0003 0.002
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Uncontrollable Choose"Uncontrollable Concentration to be used in HWA"(row 31)fron
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.
Uncontrollable(Primary)Mass Balance Spreadsheet 2019
SIU.Uncont.Mass.Bal
Page 3 of 6 pages
12/28/2020,7:17 AM
Revision:August 1999

SIU.Uncant.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 Case Farms 1098 1.5295 1,529,500 0.0018 0.0230 0.00, 0.0638 0.0005 0.0064 5.84451 74.5526
2 Seiren 4002 0.39667 396,670 0.0136 0.0106 0.0351 0.0005 0.0017` 0.2512 0.8310
3
4
5 6 _
7
8 _
9
10 _
11
12
13 _
Sum of Industrial Loading(lbs/day)=> 1.9262 1926170 0.0365 0.0988 L 0.0080 75.3836
MGD gal/day mg/I lbs/day mg/1 lbs/day mg/I lbs/day mg/I lbs/day
Avg Influent loading(lbs/day)=> 5.35251 5,352,500 0.00411 0.1830 0.0051 0.2232 0.00231 0.1027 0.20231 9.0306
Uncontrollable Load from Mass Bal(lbs/day)=> 3.4263 0.1465 0.1244 0.0946 -66.3530
Uncontrollable Concen. from Mass Bal(mg/L)=> ( 0.00511 I 0.00441 I 0.00331 1- -2.3220I
Uncont. from Uncont. Sampling(mg/L+lbs/day)=>
Uncontrollable Concen.From Literature(mg/L)=> I 0.021 I I 0.0051 I 0.1751
Uncontrollable cone. to be used in IIWA (mgL)=> 0.021 0.0044 0.005 0.175
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is t Uncontrollable Choose"Uncontrollable Concentration to be used in HWA"(row 31)from
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.
Uncontrollable(Primary)Mass Balance Spreadsheet 2019
SIU.Uncont.Mass.Bal
Page 4 of 6 pages
12/28/2020,7:17 AM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW Oil &Grease Aluminum Phenols
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average'.
IUP NAMES Permit/Pipe Conc. Load Conc. Load Cone. Load Conc.
Count (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1
1 Case Farms 1098 1.5295 1,529,500 9.6667 123.3087 3.292 41.9929
2 Seiren 4002 0.39667 396,670 9 29.7741 0.265 0.8767 0.0174 0.0576
3
4 _
5
6
7
8
9
10
11
12 _
13
Sum of Industrial Loading(lbs/day)_> 1.9262i 1926170 153.0828 42.8695 0.0576
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1
Avg Influent loading(lbs/day)=>f 5.3525 5,352,500 11.81 526.7502 2.8867 128.8619
Uncontrollable Load from Mass Bal(lbs/day)=> 3.4263 373.6675 85.9923 #VALUE!
Uncontrollable Concen. from Mass Bal(mg/L)=> 13.0765 3.0093 #VALUE! 1 '
Uncont. from Uncont. Sampling(mg/L+lbs/day)_>
Uncontrollable Concen.From Literature(mg/L)=> I 501 II I 1 I
Uncontrollable cone. to be used in 11WA (mgl.)=> 50 3.0106
Spreadsheet Instructions:1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Uncontrollable Choose"Uncontrollable Concentration to be used in HWA"(row 31)1
protected,password is"2". 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.
Uncontrollable(Primary)Mass Balance Spreadsheet 2019
SIU.Uncont.Mass.Bal
Page 5 of 6 pages
12/28/2020,7:17 AM
Revision:August 1999

SIU.Uncont.Mass.Bal
FLOW
INDUSTRY Industry Average Discharge Discharge Average Discharge
IUP NAMES Permit/Pipe Load Conc. Load
Count (please list alphabetically) number MGD gal/day lbs/day mg/I lbs/day
1 Case Farms 1098 1.5295 1,529,500
2 Seiren 4002 0.39667 396,670
3
4
5
6
7
8
9
10
11
12
13
Sum of Industrial Loading(lbs/day)_> 1.92621 1926170
MGD gal/day lbs/day mg/I lbs/day
Avg Influent loading(lbs/day)=> 5.35251 5,352,500 '
Uncontrollable Load from Mass Bal(lbs/day)=> 3.4263
Uncontrollable Concen. from Mass Bal(mg/L)=> I 1
Uncont. from Uncont. Sampling(mg/L+Ibs/day)_> I I
Uncontrollable Concen.From Literature(mg/L)=>
Uncontrollable conc. to be used in HWA(mgiL)_>
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is rom Uncontrollable Concentration
protected,password is"2".
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5.
Uncontrollable(Primary)Mass Balance Spreadsheet 2019
SIU.Uncont.Mass.Bal
Page 6 of 6 pages
12/28/2020,7:17 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW BOD TSS AMMONIA
Influent Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day <glL Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR AVG Spreadsheet 4.86 424 424 17185.74 340 340 13781.02
Instructions: M+MMMMMMM=MMI
9/23/2019 LTMP 1) Data 17.3 17.3 0.00
110/2019 DMR AVG Heavyd only in 5.01 434 434 18134.00 .....- 385 385 16086.61
10/15/2019 LTMP ResBordere
of d cells. 23.1 23.1 0.00
1 1/2019 DMR AVG worksheetis 5.49 456 456 20878.69 411 411 18818.29
11/13/2019 LTMP protected,password is 22.8 22.8 0.00
12/2019 DMR AVG 2. 5.91 311 311 15329.00 430 430 21 194.44
12/10/19 LTMP 2) For below 23 23 0.00
detection data, . -
1/20 DMR AVG enter"<"in"<^ 5.43 457 457 20695.79 361 361 16348.32
column,and
1/9/2020 LTMP enter detection 18.4 18.4 0.00
level in Influent ~r
2/2020 DMR AVG or Effluent mgn 7.54 404 404 25404.97 111•I 410 410 25782.28
2/21/2020 LTMP columns. 17 17 0.00
3/2020 DMR AVG wiilllrautosheet 5.07 541 541 22875.54 508 508 21480.17
ally
3/17/2020 LTMP c atalc ulateulate 23.1 23.1 0.00
c
4/2020 DMR AVG averages and 4.60 481 481 18453.08 471 471 18069.44
removal rates ��
4/21/2020 LTMP using 1/2 value 21 21 0.00
entered. ��
5/2020 DMR AVG 5.56 523 523 24251.72 357 357 16554.23
5/19/2020 LTMP 26 26 0.00
6/20 DMR AVG 4.98 436 436 18108.48 350 350 14536.62
6/15/20 LTMP 27 27 0.00
7/2020 DMR AVG 4.02 449 449 15053.53 1 596 596 19981.97
7/7/20 LTMP 24 24 0.00
8/2020 DMR AVG 5.76 492 492 23634.89 515 515 24739.78
8/12/2020 LTMP 27 27 0.00
,Column Averages=> 5.35250 450.67 20000.45 427.83 18947.76 _ 22.48 0.00
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Influent
Page 1 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW CADMIUM C ROMIUM
Influent Used in Calculated Used in Calculated Used in Calculated
Sample Date [ MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR AVG Spreadsheet 4.86
Instructions:
9/23/2019 LTMP 1) Data < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
I10/2019 DMR AVG Heavyd only in 5.01
'
10/15/2019 LTMP Bost Bordered
dcells. 0.044 0.044 0.0000 <_ 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
11/2019 DMR AVG worksheet is 5.49
11/13/2019 LTMP protected, < 0.010 0.005 0.0000 <•
password is 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
12/2019 DMR AVG "2". 5.91
12/10/19 LTMP 2) For below < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
detection data, +=..
1/20 DMR AVG enter"<"in"<" 5.43
column,and < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
1/9/2020 LTMP enter detection
2/2020 DMR AVG +level in Influent 7.54
or Effluent mg/I
2/21/2020 LTMP columns. < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
Spreadsheet - - -
3/2020 DMR AVG will auto- 5.07
ny
3/17/2020 LTMP calculate
< 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
calculate _
4/2020 DMR AVG averages and 4.60
removal rates
4/21/2020 LTMP using 1/2 value < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
entered.
5/2020 DMR AVG 5.56
5/19/2020 LTMP < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 0.004 0.004 0.0000
6/20 DMR AVG 4.98
6/15/20 LTMP < 0.010 0.005 0.0000 < 0.0002 0.0002 0.0000 0.002 0.002 0.0000
7/2020 DMR AVG 4.02
7/7/20 LTMP < 0.010 0.005 0.0000 0.0001 0.0000 0.008 0.008 0.0000
8/2020 DMR AVG 5.76
8/12/2020 LTMP < 0.010 0.005 0.0000 0.0003 0.0003 0.0000 0.006 0.006 0.0000
Column Averages=> 5.35250 0.0083 0.0000 0.0001 0.0000 0.0020 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Influent
Page 2 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW • ' • CYANIDE LEAD
Influent Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR AVG Spreadsheet 4.86
Instructions:
-
9/23/2019 LTMP 1) Data 0.055 0.055 0.0000 0.011 0.011 0.0000 < 0.010 0.005 0.0000
110/2019 DMR AVG Hetad only in 5.01
10/15/2019 LTMP Bordered cells. 0.031 0.031 0.0000 0.011 0.011 0.0000 < 0.010 0.005 0.0000
Rest of
1 1/2019 DMR AVG worksheet is 5.49
1 1/13/2019 LTMP protected,
password is 0.064 0.064 0.0000 0.007 0.007 0.0000 < 0.010 0.005 0.0000
12/2019 DMR AVG "2". 5.91
12/10/19 LTMP 2) For below 0.018 0.018 0.0000 0.010 0.01 0.0000 < 0.010 0.005 0.0000
detection data,
1/20 DMR AVG enter"<"in"<" 5.43
1/9/2020 LTMP column,and
enter detection 0.099 0.099 0.0000 0.015 0.015 0.0000 < 0.010 0.005 0.0000
2/2020 DMR AVG level in Influent 7.54
or Effluent mg/I
2/21/2020 LTMP columns. 0.041 0.041 0.0000 0.008 0.008 0.0000 < 1 0.010 0.005 0.0000
Spreadsheet ,
3/2020 DMR AVG will auto- 5.07
3/17/2020 LTMP c atalculate u 0.064 0.064 0.0000 0.014 0.014 0.0000 < 0.010 0.005 0.0000
clate
4/2020 DMR AVG averages and 4.60
removal rates
4/21/2020 LTMP using 1/2 value 0.027 0.027 0.0000 0.012 0.012 0.0000 < 0.010 0.005 0.0000
entered.
5/2020 DMR AVG 5.56
5/19/2020 LTMP 0.019 0.019 0.0000 0.011 0.011, 0.0000 < 0.010 0.005 0.0000
6/20 DMR AVG 4.98
6/15/20 LTMP 0.064 0.064 0.0000 0.009 0.009 0.0000 < 0.010 0.005 0.0000
7/2020 DMR AVG 4.02
7/7/20 LTMP 0.078 0.078 0.0000 0.016 0.016 0.0000 < 0.010 0.005 0.0000
8/2020 DMR AVG 5.76
8/12/2020 LTMP 0.047 0.047 0.0000 0.0113 0.0113 0.0000 < 0.01 0.005 0.0000
Column Averages=> 5.35250 0.0506 0.0000 0.0113 0.0000 0.0050 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Influent
Page 3 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW MOLYBDENUM
Influent Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR AVG Spreadsheet
Instructions: 1mir
9/23/2019 LTMP 1) Data 0.0002 0.0002 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
110/2019 DMR AVG I entareyd only in 5.01
10/15/2019 LTMP ResBordere
of d cells. 0.0002 0.0002 0.00000 < 0.0005 0.0000 < 0.001 0.0005 0.0000
11/2019 DMR AVG worksheetis 5.49
11/13/2019 LIMP protected,password is < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
12/2019 DMR AVG "2". 5.91 .....,.-
Inpmmir
12/10/19 LTMP 2) For below �< 0.0001 0.00005 0.00000 0.0005 0.0000 0.041 0.041 0.0000
detection data, I k
1/20 DMR AVG enter"<"in"<" 5.43
1/9/2020 LTMP column,and enter detection < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
level DMR AVG in Influen
or Effluent mg/I 7.54
2/21/2020 LTMP columns. < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
Spreadsheet - ��
3/2020 DMR AVG will auto- 5.07
3/17/2020 LTMP manually calculate < 0.0001 0.00005 0.00000 0.0005 0.0000 < 0.001 0.0005 0.0000
4/2020 DMR AVG averages and 4.60
removal rates
-
4/21/2020 LTMP using 1/2 value < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
entered.
5/2020 DMR AVG 5.56
5/19/2020 LTMP < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
6/20 DMR AVG 4.98
6/15/20 LIMP < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
7/2020 DMR AVG 4.02
7/7/20 LTMP < 0.0001 0.00005 0.00000 0.003 0.003 0.0000 0.002 0.002 0.0000
8/2020 DMR AVG 5.76
8/12/2020 LTMP < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 0.002 0.002 0.0000
Column Averages=> 5.35250 0.00008 0.00000 0.0007 0.0000 0.0041 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Influent
Page 4 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
[Sample Location: FLOW SILVER
Influent Used in Calculated Used in Calculated Used in Calculated
i
Sample Date ! MGD < mg/L Calculation lbs/day < mg/L Calculation Ibs/day < mg/L Calculation lbs/day
9/2019 DMR AVG Spreadsheet 4.86
Instructions:
9/23/2019 LTMP 1) Data < 0.010 0.005 0.0000 0.018 0.018 0.0000 0.155 0.155 0.0000
110/2019 DMR AVG ente p
Heavyred only in 5.01
10/15/2019 LTMP BRestorderedof cells. < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.128 0.128 0.0000
11/2019 DMR AVG worksheetis 5.49
protected, momm7mm �
1/13/2019 LTMP password is < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.264 0.264 0.0000
12/2019 DMR AVG "2". 5.91
12/10/19 LTMP 2) For below < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.172 0.172 0.0000
detection data,
1/20 DMR AVG enter"<"in"<" 5.43
column,and
1/9/2020 LTMP enter detection < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.373 0.373 0.0000
.
level in Influent -
2/2020 DMR AVG or Effluent mg/I 7.54
2/21/2020 LTMP columns. < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.178 0.178 0.0000
Spreadsheet ip -
3/2020 DMR AVG will auto- 5.07
3/17/2020 LTMP matically r< 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.224 0.224 0.0000
calculate
4/2020 DMR AVG averages and 4.60
removal rates ...��►
4/21/2020 LTMP using 1/2 value < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.105 0.105 0.0000
entered. -
5/2020 DMR AVG 5.56
5/19/2020 LTMP < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.089 0.089 0.0000
6/20 DMR AVG 4.98
6/15/20 LTMP < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.214 0.214 0.0000
7/2020 DMR AVG 4.02
7/7/20 LTMP < 0.010 0.005 0.0000 0.002 0.002 0.0000 0.245 0.245 0.0000
8/2020 DMR AVG 5.76
8/12/2020 LTMP < 0.010 0.005 0.0000 0.003 0.003 0.0000 0.281 0.281 0.0000
Column Averages=> 5.35250 0.0050 0.0000 0.0023 0.0000 0.2023 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Influent
Page 5 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet readsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW 01 &GREASE Total Phosphorus
Influent Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg L Calculation lbs/day < n1JL Calculation lbs/day < Calculation lbs/day
9/2019 DMR AVG Spreadsheet 4.86
Instructions:
9/23/2019 LTMP 1) Data 1.42 1.42 0.0000
I10/2019 DMR AVG
Headentered only in 5.01 6.2 6.2 259.0571
10/15/2019 LTMP BRestorderedof cells.
l 1/2019 DMR AVG worksheet is 5.49
protected,
1 1/13/2019 LTMP password is
12/2019 DMR AVG 2. 5.91
I2/10/19 LTMP 2) For below
detection data,
1/20 DMR AVG enter"<"in•.<" 5.43
column,and
1/9/2020 LTMP enter detection 4.2 4.2 0.0000 5.39 5.39 0.0000
2/2020 DMR AVG level in Influent 7.54
or Effluent mg/I
2/21/2020 LTMP columns.
Spreadsheet
3/2020 DMR AVG will auto- 5.07
3/17/2020 LTMP manually
calculate
4/2020 DMR AVG averages and 4.60
removal rates
4/21/2020 LTMP using 1/2 value
entered.
5/2020 DMR AVG 5.56
5/19/2020 LTMP
6/20 DMR AVG 4.98
6/15/20 LTMP
7/2020 DMR AVG 4.02
7/7/20 LTMP 25 25 0.0000 1.85 1.85 0.0000
8/2020 DMR AVG 5.76
8/12/2020 LTMP
Column Averages=> 5.35250 I 1.8000 86.3524 2.8867 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Influent
Page 6 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: 1 FLOW Conductivity COD
Influent Used in Calculated Used in Calculated Used in Calculated
Sample Date J MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR AVG Spreadsheet 4.86
Instructions:
9/23/2019 LTMP 1) Data 704 0.0000
110/2019 DMR AVG Hetaevyred only in 5.01 704
10/15/2019 LTMP Bordered cells.
Rest of
11/2019 DMR AVG worksheet is 5.49
protected,
11/13/2019 LTMP password is
12/2019 DMR AVG 2 5.91
12/10/19 LTMP 2) For below
detection data,
1/20 DMR AVG enter"<"in"<" 5.43
column,and
1/9/2020 LTMP enter detection 633 633 0.0000
level in Influent
2/2020 DMR AVG or Effluent mg/I 7.54
2/21/2020 LTMP columns.
Spreadsheet
3/2020 DMR AVG wilt auto- 5.07
ally
3/17/2020 LTMP c atalculateu
clate
4/2020 DMR AVG averages and 4.60
removal rates
4/21/2020 LTMP using 1/2 value
entered.
5/2020 DMR AVG 5.56
5/19/2020 LTMP
6/20 DMR AVG 4.98
6/15/20 LTMP
7/2020 DMR AVG 4.02
7/7/20 LTMP 574 574 0.0000
8/2020 DMR AVG 5.76
8/12/2020 LTMP
Column Averages=> 5.35250 637.0000 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Influent
Page 7 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
1 Sample Location: FLOW BOD TSS AMMONIA
Effluent Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR Avg Spreadsheet 4.86 4.1 4.1 166.18 4.7 4.7 190.50 < 0.5 0.25 10.13
Instructions:
9/23//2019 LTMP 1) Data
10/2019 DMR Avg enteredHeavy only in 5.01 3.8 3.8 158.78 4.2 4.2 175.49 < 0.5 0.25 10.45
10/15/2019 LTMP Bordered cells.
Rest of
11/2019 DMR Avg worksheet is 5.49 8.8 8.8 402.92 10.0 10 457.87 < 0.5 0.25 11.45
protected,
11/13/2019 LTMP password is
12/2019 DMR Avg 2 5.91 5 5 246.45 6.0 6 295.74 < 0.5 0.25 12.32
12/10/2019 LTMP 2) For below
detection data,
-
1/2020 DMR AVG enter"<°in"<" 5.43 9.8 9.8 443.80 11.0 11 498.15 < 0.5 0.25 11.32
,and
1/9/2020 LTMP enter d
enter detection
level in Influent
2/2020 DMR AVG or Effluent mg/ 7.54 28 28 1760.74 25 25 1572.09 1.45 1.45 91.18
2/21/20 LTMP columns.
Spreadsheet T .
3/2020 DMR AVG will auto- 5.07 10.2 10.2 431.29 11.8 11.8 498.95 < 0.5 0.25 10.57
matically + r
3/17/2020 LTMP calculate
4/2020 DMR AVG averages and 4.60 8.5 8.5 326.09 16 16 613.82 < 0.5 0.25 9.59
removal rates 111
4/21/20 LTMP using 1/2 value
entered.
5/2020 DMR AVG 5.56 9 9 417.33 9.7 9.7 449.79 < 0.5 0.25 11.59
5/19/2020 LTMP
6/20 DMR AVG 4.98 4.7 4.7 195.21 7.9 7.9 328.11 < 0.5 0.25 10.38
6/15/20 LTMP
7/2020 DMR AVG 4.02 5.3 5.3 177.69 7.5 7.5 251.45 < 0.5 0.25 8.38
7/7/20 LTMP
8/2020 DMR AVG 5.76 4.8 4.8 230.58 7.2 7.2 345.88 < 0.5 0.25 12.01
8/12/20 LTMP
Column Averages=> 5.35250 8.50 413.09 10.08 473.15 0.35 17.45
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Effluent
Page 1 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

T
Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
'Sample Location: FLOW CADMIUM C ROMIUM
Effluent Used in Calculated Used in Calculated Used in Calculated
1 Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR Avg Spreadsheet 4.86
Ions:
9/23//2019 LTMP 1) < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
Data Data
10/2019 DMR Avg Heavyd only in 5.01
10/15/2019 LTMP Bordered cells. < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
Rest of
11/2019 DMR Avg worksheet is 5.49
11/13/2019 LTMP protected,password is < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
12/2019 DMR Avg 2 5.91
12/10/2019 LTMP 2) For below ��0.010,
.010, 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
detection data,
1/2020 DMR AVG enter"<"in"<" 5.43
column,and 1/9/2020 LTMP enter detection < 0.010 0.0000 < 0.00002 0.00001 0.0000 < 0.001 0.0005 0.0000
2/2020 DMR AVG level in Influent 7.54
or Effluent mg/I
2/21/20 LTMP columns. < 0.010 0.005 0.0000 < 0.00002 0.00001 0.0000 < 0.001 0.0005 0.0000
Spreadsheet ��1
3/2020 DMR AVG will auto- 5.07
3/17/2020 LTMP matica < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
calculatt ee 1�
4/2020 DMR AVG averages and 4.60
remousingal rates
ng
4/21/20 LTMP s 1/2 value 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
entered.
5/2020 DMR AVG 5.56
5/19/2020 LTMP < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
6/20 DMR AVG 4.98
6/15/20 LTMP < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
7/2020 DMR AVG 4.02
7/7/20 LTMP < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 < 0.001 0.0005 0.0000
8/2020 DMR AVG 5.76
8/12/20 LTMP < 0.010 0.005 0.0000 < 0.0002 0.0001 0.0000 0.001 0.001 0.0000
Column Averages=> 5.35250 0.0050 0.0000 0.0001 0.0000 0.0005 0.00000-1
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Effluent
Page 2 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
'Sample Location: FLOW COPPER CYANIDE LEAD
Effluent Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR Avg Spreadsheet 4.86
Instructions:
9/23//2019 LTMP 1) Data 0.002 0.002 0.0000 0.005 0.005 0.0000 < 0.010 0.005 0.0000
10/2019 DMR Avg Heavyd only in 5.01
10/15/2019 LTMP Bordered cells. 0.010 0.01 0.0000 < 0.005 0.0025 0.0000 < 0.010 0.005 0.0000
Rest of
11/2019 DMR Avg worksheet is 5.49
protected,
11/13/2019 LTMP password is 0.010 0.01 0.0000 < 0.005 0.0025 0.0000 < 0.010 0.005 0.0000
12/2019 DMR Avg 2 5.91
12/10/2019 LTMP 2) For below 0.006 0.006 0.0000 < 0.005 0.0025 0.0000 < 0.010 0.005 0.0000
detection data, --- -
1/2020 DMR AVG enter"<"in"<" 5.43
1/9/2020 LTMP column,and
enter detection 0.033 0.033 0.0000 < 0.005 0.0025 0.0000 < 0.010 0.005 0.0000
2/2020 DMR AVG level in Influent 7.54
or Effluent mg/I
2/21/20 LTMP columns. < 0.001 0.0005 0.0000 < 0.005 0.0025 0.0000 < 0.010 0.005 0.0000
Spreadsheet
3/2020 DMR AVG will auto- 5.07
3/17/2020 LTMP manually calculate 0.007 0.007 0.0000 < 0.005 0.0025 0.0000 < 0.010 0.005 0.0000
4/2020 DMR AVG averages and 4.60
removal rates 4.60
4/21/20 LTMP using 1/2 value 0.014 0.014 0.0000 0.005 0.005 0.0000 < 0.010 0.005 0.0000
entered. -
5/2020 DMR AVG 5.56
5/19/2020 LTMP 0.009 0.009 0.0000 < 0.005 0.0025 0.0000 < 0.010 0.005 0.0000
6/20 DMR AVG 4.98
6/15/20 LTMP 0.004 0.004 0.0000 < 0.005 0.0025 0.0000 < 0.010 0.005 0.0000
7/2020 DMR AVG 4.02
7/7/20 LTMP 0.007 0.007 0.0000 < 0.005, 0.0025 0.0000 < 0.010 0.005 0.0000
8/2020 DMR AVG 5.76
8/12/20 LTMP 0.006 0.006 0.0000 0.005 0.005 0.0000 < 0.010 0.005 0.0000
Column Averages=> 5.35250 0.0090 0.0000 0.0031 0.0000 0.0050 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Effluent
Page 3 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW MOLYBDENUM NICKEL
Effluent Used in Calculated Used in Calculated Used in Calculated
Sample Date I MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR Avg Spreadsheet 4.86
Instructions:
9/23//2019 LTMP 1) Data < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
10/2019 DMR Avg Heavyd only in 5.01
10/15/2019 LTMP BRestorderedof cells. < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 0.009 0.009 0.0000
11/2019 DMR Avg worksheet is 5.49
11/13/2019 LTMP p1 0.0005 0.0000 < 0.001 0.0005 0.0000
password is < 0.0001 0.00005 0.00000 < 0.00d,
12/2019 DMR Avg 2 5.91
12/10/2019 LTMP 2) For below < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
detection data, -- -
1/2020 DMR AVG enter"<"in"<" 5.43
column,and < 0.0001 0.00005 0.00000 < 0.033 0.0165 0.0000 < 0.001 0.0005 0.0000
1/9/2020 LTMP enteer detection
2/2020 DMR AVG level in Influent 7.54
or Effluent mg/I
2/21/20 LTMP columns. < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
Spreadsheet
3/2020 DMR AVG will auto- 5.07
3/17/2020 LTMP manually calculate < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001, 0.0005 0.0000
4/2020 DMR AVG averages and 4.60
removal rates
4/21/20 LTMP using 1/2 value < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
' entered.
5/2020 DMR AVG 5.56
5/19/2020 LTMP < 0.000I 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
6/20 DMR AVG 4.98
6/15/20 LTMP < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
7/2020 DMR AVG 4.02
7/7/20 LTMP < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
8/2020 DMR AVG 5.76
8/12/20 LTMP < 0.0001 0.00005 0.00000 < 0.001 0.0005 0.0000 < 0.001 0.0005 0.0000
Column Averages=> 5.35250 L0.00005 0.00000 0.0018 0.0000 0.0012 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Effluent
Page 4 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
'Sample Location: FLOW SELENIUM SILVER
Effluent Used in Calculated Used in Calculated Used in Calculated
( Sample Date I. MGD < Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/2019 DMR Avg Spreadsheet 4.86
Instructions:
9/23//2019 LTMP 1) Data < 0.010 0.005 0.0000 0.006 0.006 0.0000 0.042 0.042 0.0000
10/2019 DMR Avg Hetarryed only in 5.01 .
10/15/2019 LTMP Bordered cells. < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.020 0.02 0.0000
Rest of 1
11/2019 DMR Avg worksheet is 5.49
11/13/2019 LTMP p < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.054 0.054 0.0000
parotected,ssword is
12/2019 DMR Avg 2 5.91
12/10/2019 LTMP 2) For below < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.010 0.01 0.0000
detection data,
1/2020 DMR AVG enter"<"in"<" 5.43
column,and
1/9/2020 LTMP enter detection < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.157 0.157 0.0000
2/2020 DMR AVG level in Influent 7.54
, or Effluent mg/I
2/21/20 LTMP columns. < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.077 0.077 0.0000
Spreadsheet
3/2020 DMR AVG will auto- 5.07
3/17/2020 LTMP manually calculate < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.089 0.089 0.0000
4/2020 DMR AVG averages and 4.60
removal rates
4/21/20 LTMP using 1/2 value < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.038 0.038 0.0000
entered.
5/2020 DMR AVG 5.56
5/19/2020 LTMP < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.021 0.021 0.0000
6/20 DMR AVG 4.98
6/15/20 LTMP < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.024 0.024 0.0000
7/2020 DMR AVG 4.02
lommillommIr
7/7/20 LTMP < 0.010 0.005 0.0000 < 0.001 0.0005 0.0000 0.054 0.054 0.0000
8/2020 DMR AVG 5.76
8/12/20 LTMP < 0.010 0.005 0.0000 0.0005 0.0000 0.016 0.016 0.0000
Column Averages=> 5.35250 0.0050 0.0000 0.0010 0.0000 0.0502 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Effluent
Page 5 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
'Sample Location: FLOW OIL : GREASE To al Phosphorus
Effluent Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/1. Calculation lbs/day
9/2019 DMR Avg Spreadsheet 4.86
Instructions: ommmm..m . r
9/23//2019 LTMP 1) Data 0.181 0.181 0.0000 0.554 0.554 0.0000
enteredHeavy only in a............10/2019 DMR AVE 5.01
10/15/2019 LTMP Bordered cells. 1 4 1.4 0.0000 9.97 9.97 0.0000
Rest of
11/2019 DMR Avg worksheet is 5.49
1 I/13/2019 LTMP protected,
password is L91 1.91 0.0000
~�12/2019 DMR Avg 2 5.91
12/10/2019 LTMP 2) For below 4.38 4.38 0.0000
detection data,
1/2020 DMR AVG enter"<"in"<" 5.43
1/9/2020 LTMP column,and
enter d etection <' I ` 0.5 0.0000 0.604 0.604 0.0000 4.24 4.24 0.0000
d
2/2020 DMR AVG level in Influent 7.54
or Effluent mg/I
2/21/20 LTMP columns. 1.23 1.23 0.0000
.__ Spreadsheet -
3/2020 DMR AVG wilt auto- 5.07
3/17/2020 LTMP alculate calculate 2.19 2.19 0.0000
4/2020 DMR AVG averages and 4.60
removal rates
4/21/20 LTMP using 1/2 value 10.40 10.4 0.0000
entered. -- - ,
5/2020 DMR AVG 5.56
5/19/2020 LTMP 3.75 3.75 0.0000
6/20 DMR AVG 4.98
6/15/20 LTMP 3.45 3.45 0.0000
ip
7/2020 DMR AVG 4.02
7/7/20 LTMP 2.1 2.1 0.0000 0.221 0.221 0.0000 2.97 2.97 0.0000
8/2020 DMR AVG 5.76
8/12/20 LTMP
Column Averages=> 5.35250 1.3333 0.0000 0.3353 0.0000 4.0949 0.0000
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Effluent
Page 6 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
ISample Location: FLOW Conductivity COD Total Nitrogen
Effluent Used in Calculated Used in Calculated Used in Calculated
< m L CalculationCalculation lbs/day
Sample Date MGD < mg/L Calculation lbs/day g/ lbs/daym L< g/9/2019 DMR Avg ,Spreadsheet 4.86 485.6 485.6 19682.5334
Instructions:
9/23//2019 LTMP 1) Data 32 0.0000 12.70 12.7 0.0000
10/2019 DMR Avg Heavyd only in 5.01 458.8 458.8 19170.2239 32
10/15/2019 LTMP Bordered cells.
Rest of 11.32 11.32 0.0000
11/2019 DMR Avg worksheet is 5.49 457 457 20924.4762
protected, 12.07 12.07 0.0000
11/13/2019LTMP password is
12/2019 DMR Avg 5.91 391.5 391.5 19296.8001
12/10/2019 LTMP 2) For below detection data, 12.37 12.37 0.0000
1/2020 DMR AVG enter"<°in"<" 5.43 427.9 427.9 19377.9650
column,and
1/9/2020 LTMP enter detection 58.7 58.7 0.0000 11.94- 11.94 0.0000
2/2020 DMR AVG level in Influent 7.54 361.4 361.4 22726.1330
or Effluent mg/ ,_
2/21/20 LTMP columns. 9.38 9.38 0.0000
Spreadsheet
3/2020 DMR AVG will auto- 5.07 430 430 18182.0340
3/17/2020 LTMP manually calculate 13.21 13.21 0.0000
4/2020 DMR AVG averages and 4.60 425 425 16304.7000
removal rates
4/21/20 LTMP using 1/2 value 11.92 11.92 0.0000
entered. � ,
5/2020 DMR AVG 5.56 373 373 17296.1592
5/19/2020 LTMP 13.24 13.24 0.0000
6/20 DMR AVG 4.98 408 408 16945.5456
6/15/20 LTMP 12.51 12.51 0.0000
7/2020 DMR AVG 4.02 457 457 15321.7476
7/7/20 LTMP 52.75 52.75 0.0000
8/2020 DMR AVG 5.76 13.27 13.27 637.4696
8/12/20 LTMP
Column Averages=> 5.35250 425.0182 18657.1198 47.8167 0.0000 12.1755 57.9518
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Effluent
Page 7 of 7 pages
12/28/2020, 6:59 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
'Sample Location: FLOW BOD AMMONIA
Primary Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < me i. Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 112 112 4875.90 27.2 27.2 1184.15
Instructions:
10/15/2019 1) Data 4.00 150 150 5004.00 23.8 23.8 793.97
1 1/13/2019 Heta rryed only in 6.00 100 100 5004.00 24.0 24 1200.96
12/10/2019 Bordered cells. 6.22 128 128 6639.97 24 24 1245.00
Rest of ,
1/9/2020 worksheet is 5.43 140 140 6340.07 23 23 1041.58
protected,
2/21/2020 password is 4.65 130 130 5041.53 17 17 659.28
3/17/2020 2 5.07 296 296 12516.00 18.5 18.5 782.25
4/21/2020 2) For below 5 34 86 86 3830.06 2 7 27 1202.46
- , detection data, •
5/19/2020 enter"<"in''<" 5.19 136 136 5886.71 28 28 1211.97
6/15/2020 enl enter detectdetection 5.00 193 193 8048.10 34 34 1417.80
7/7/2020 or
ll in Influenmg/tI
5.00 212 212 8840.40 28 28 1167.60
eveEffl nu
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
Column Averages=> 5.19273 153.00 6547.89 24.95 1082.46
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Primary
Page 1 of 7 pages
12/28/2020, 7:02 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: I FLOW C'DMIUM C ROMIUM
Primary Used in Calculated Used in Calculated Used in Calculated
i Sample Date I I MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 < 0.010 < 0.0002 0.0001 0.0044 0.009 0.009 0.3918
Instructions:
10/15/2019 1) Data 4.00 < 0.010 0.005 0.1668 < 0.0002 0.0001 0.0033 < 0.001 0.0005 0.0167
11/13/2019 enteredHeavy only in 6.00 < 0.010 0.005 0.2502 < 0.0002 0.0001 0.0050 0.036 0.036 1.8014
12/10/2019 Bordered cells. 6.22 < 0.010 0.005 0.2594 < 0.0002 0.0001 0.0052 < 0.001 0.0005 0.0259
Rest of
1/9/2020 worksheetis 5.43 < 0.010 0.005 0.2264 < 0.0002 0.0001 0.0045 < 0.001 0.0005 0.0226
protected,
2/21/2020 password is 4.65 < 0.010 0.005 0.1939 < 0.0002 0.0001 0.0039 < 0.001 0.0005 0.0194
3/17/2020 "2". 5.07 < 0.010 0.005 0.2114 < 0.0002 0.0001 0.0042 < 0.001 0.0005 0.0211
4/21/2020 2) For below 5.34 < 0.010 0.005 0.2227 < 0.0002 0.0001 0.0045 0.003 0.003 0.1336
detection data,
5/19/2020 enter"<'•in"<" 5.19 < 0.010 0.005 0.2164 < 0.0002 0.0001 0.0043 0.005 0.005 0.2164
6/15/2020 column,and
enter detection 5.00 < 0.010 0.005 0.2085 < 0.0002 0.0001 0.0042 0.005 0.005 0.2085
7/7/2020 or levelEffl inuent Influent
mg/
5.00 < 0.010 0.005 0.2085 < 0.0002 0.0001 0.0042 0.005 0.005 0.2085
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered. •
I If
v
Column Averages=> 5.19273 0.0050 0.2164 0.0001 0.0043 0.0060 0_'7 S 7
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Primary
Page 2 of 7 pages
12/28/2020, 7:02 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW • - • - CYANIDE LEAD
Primary Used in Calculated Used in Calculated Used in Calculated
Sample Date l ` MGD < mg/L Calculation lbs/day < mg/L Calculation Ibs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 0.043 0.043 1.8720 0.008 0.008 0.3483 < 0.010 0.005 0.2177
Instructions:
10/15/2019 1) Data 4.00 0.023 0.023 0.7673 0.009 0.009 0.3002 < 0.010 0.005 0.1668
11/13/2019 enteredHeavy only in 6.00 0.046 0.046 2.3018 0.013 0.013 0.6505 < 0.010 0.005 0.2502
,
12/10/2019 Bordered cells. 6.22 0.023 0.023 1.1931 0.008 0.008 0.4150 < 0.010 0.005 0.2594
Rest of
1/9/2020 worksheet is 5.43 0.056 0.056 2.5360 0.010 0.01 0.4529 < 0.010 0.005 0.2264
protected,
2/21/2020
password is 4.65 0.046 0.046 1.7839 0.009 0.009 0.3490 < 0.010 0.005 0.1939
3/17/2020 "2"' 5.07 0.038 0.038 1.6068 0.008 0.008 0.3383 < 0.010 0.005 0.2114
4/21/2020 2) For below 5.34 0.048 0.048 2.1377 0.007 0.007 0.3117 < 0.010 0.005 0.2227
detection data,
5/19/2020 enter"<"in"<" 5.19 0.057 0.057 2.4672 0.007 0.007 0.3030 < 0.010 0.005 0.2164
column,and
6/15/2020 enter detection 5.00 0.067 0.067 2.7939 0.007 0.007 0.2919 < 0.010 0.005 0.2085
or
7/7/2020 ll inuent Influenmg/It 5.00 0.064 0.064 2.6688 0.008 0.008 0.3336 < 0.010 0.005 0.2085
eveEffl
columns.
Spreadsheet
-
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
Column Averages=> 5.19273 0.0465 2.0117 0.0085 0.3722 0.0050 0.2165
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Primary
Page 3 of 7 pages
12/28/2020, 7:02 AM
Revision:August 1999

I
Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
'Sample Location: FLOW MERCURY MOLYBDENUM NICKEL
Primary Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 ( MGD < mg/L Calculation lbs/day < mg/L Calculation Ibs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 0.0004 0.0004 0.0174I < 0.001 0.0005 0.0218
Instructions:
10/15/2019 1) Data 4.00 0.0004 0.0004 0.01334 0.004 0.004 0.1334
11/13/2019 Heavydonlyin 6.00 < 0.0001 0.00005 0.00250 < 0.001 0.0005 0.0250
12/10/2019 Bordered cells 6.22 < 0.0001 0.00005 0.00259 0.047 0.047 2.4381
Rest of
1/9/2020 worksheet is 5.43 < 0.0001 0.00005 0.00226 < 0.001 0.0005 0.0226
protected,
2/21/2020
password is 4.65 < 0.0001 0.00005 0.00194 < 0.001 0.0005 0.0194
3/17/2020 "2"' 5.07 < 0.0001 0.00005 0.00211 < 0.001 0.0005 0.0211
4/21/2020 2) For below 5.34 < 0.0001 0.00005 0.00223 < 0.001 0.0005 0.0223
detection data, .�
5/19/2020 enter"<"in"<" 5.19 < 0.0001 0.00005 0.00216 < 0.001 0.0005 0.0216
column,and < 0.001 0.0005 0.0209
6/l 5/2020 enter detection 5.00 < 0.0001 0.00005 0.00209
7/7/2020 level in Influent 5.00 < 0.0001 0.00005 0.00209 < 0.001 0.0005 0.0209
or Effluent mg/I I
columns.
Spreadsheet
will auto- _ _
matically r
calculate ,
averages and
removal rates , -
using 1/2 value
entered. , ,
Column Averages=> 5.19273 0.00011 0.00461 0.0050 0.2516
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Primary
Page 4 of 7 pages
12/28/2020, 7:02 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
(Sample Location: FLOW
Primary Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 < 0.010 0.005 0.2177 0.022 0.022 0.9578 0.051 0.051 2.2203
Instructions:
10/15/2019 1) Data 4.00 < 0.010 0.005 0.1668 < 0.001 0.0005 0.0167 0.020 0.02 0.6672
1 1/13/2019 Hetaevyed only in 6.00 < 0.010 0.005 0.2502 < 0.001 0.0005 0.0250 0.135 0.135 6.7554
12/10/2019 Bordered
e d o d cells. 6.22 < 0.010 0.005 0.2594 < 0.001 0.0005 0.0259 0.171 0.171 8.8706
1/9/2020 worksheet is 5.43 < 0.010 0.005 0.2264 < 0.001 0.0005 0.0226 1.10 1.1 49.8148
protected,
2/21/2020 password is 4.65 < 0.010 0.005 0.1939 < 0.001 0.0005 0.0194 0.164 0.164 6.3601
3/17/2020 "2"' 5.07 < 0.010 0.005 0.2114 < 0.001 0.0005 0.0211 0.127 0.127 5.3700
4/21/2020 2) For below 5.34 < 0.010 0.005 0.2227 < 0.001 0.0005 0.0223 0.112 0.112 4.9880
detection data,
5/19/2020 enter"<"in"<" 5.19 < 0.010 0.005 0.2164 < 0.001 0.0005 0.0216 0.124 0.124 5.3673
column,and
6/15/2020 enter detection 5.00 < 0.010 0.005 0.2085 < 0.001 0.0005 0.0209 0.315 0.315 13.1355
7/7/2020 or levelEffluent in Influentmg/1 5.00 < 0.010 0.005 0.2085 < 0.001 0.0005 0.0209 0.112 0.112 4.6704
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered
r
Column Averages=> 5.19273 0.0050 0.2165 0.0025 0.1067 0.2210 9.8381
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Primary
Page 5 of 7 pages
12/28/2020, 7:02 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW OIL$GREASE Chlorides Total Phosphorus
Primary Used in Calculated Used in Calculated Used in Calculated
Sample Date J MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22
Instructions:
10/15/2019 1) Data 4.00
I I/13/2019 entered only in 6.00
12/10/2019 Bordered cells. 6.22
Rest of
1/9/2020 worksheet is 5.43
protected,
2/21/2020 password is 4.65
3/17/2020 "2". 5.07
4/21/2020 2) For below 5.34
detection data,
5/19/2020 enter"<"in"<" 5.19
6/15/2020 column,and
enter detection 5.00
level in
7/7/2020 or Effluent Influent mg/I 5.00
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
Column Averages=> 5.19273
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Primary
Page 6 of 7 pages
12/28/2020, 7:02 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
[Sample Location: FLOW Conductivity Sodium
Primary Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < tng/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22
Instructions:
10/15/2019 1) Data 4.00
1 1/13/2019 Heavy only in 6.00
12/10/2019 Be t Bordered cells. 6.22
o1/9/2020 worksheet is 5.43
protected,
2/21/2020 password is 4.65
3/17/2020 "2". 5.07
4/21/2020 2) For below 5.34
detection data,
5/19/2020 enter"<"in"<" 5.19
column,and
6/15/2020 enter detection 5.00
level in Influent
7/7/2020 or Effluent mg/I 5.00
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
n �
1
Column Averages=> 5.19273
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Primary
Page 7 of 7 pages
12/28/2020, 7:02 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
(Sample Location: FLOW BOD TSS AMMONIA
Aeration Used in Calculated Used in Calculated Used in Calculated
Sample Date J MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 17.3 17.3 753.15
Instructions:
10/15/2019 1) Data 4.00 < 0.5 0.25 8.34
entered only in
1/9/2020 Heavy 5.43 L l 1.1 49.81
4/21/2(P0 Bordered
r d cells. 5.34 < 0.5 0.25 11.13
Bo
7/7/2020 worksheet is 5.00 1.1 1.1 45.87
protected,
password is
2) For below
detection data,
enter"<"in"<"
column,and
enter detection
level in Influent
or Effluent mg/I
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using1/2 value
entered.
Column Averages=> 4.99800 4.00 173.66
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Aeration
Page 1 of 7 pages
12/28/2020, 7:00 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
'Sample Location: FLOW CADMIUM CHROMIUM
Aeration Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 0.784 0.784 34.1313 0.0090 0.009 0.3918 0.022 0.0221 0.9578
Instructions:
_ 10/15/2019 1) Data 4.00 0.218 0218 7.2725 < 0.0002 0.0001 0.0033 < 0.001 0.0005 0.0167
1/9/2020 Heavyd only in 5.43 < 0.010 0.005 0.2264 < 0.0002 0.0001 0.0045 0.035 0.035 1.5850
4/21/2020 Bordered cells_ 5.34 0.012 0.012 0.5344 < 0.0002 0.0001 0.0045 < 0.001 0.0005 0.0223
, Rest of
7/7/2020 worksheet is 5.00 0.014 0.014 0.5838 < 0.0002 0.0001 0.0042 0.008 0.008 0.3336
protected,
password is
.2„
2) For below
detection data,
enter"<^in"<"
column,and
enter detection
level in Influent
or Effluent mg/I
columns.
Spreadsheet
will auto-
matically
calculate _
averages and
removal rates
using 1/2 value
entered.
Column Averages=> 4.99800 0.2066 8.5497 0.0019 0.0817 0.0132 0.5831
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Aeration
Page 2 of 7 pages
12/28/2020, 7:00 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW • ' ' - CYANIDE LEAD
Aeration Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 0.937 0.937 40.7921 0.018 0.018 0.7836 0.049 0.049 2.1332
Instructions: -
10/15/2019 1) Data 4.00 0.350 0.35 11.6760 < 0.021 0.0105 0.3503 < 0.010 0.005 0.1668
I/9/2020 eHeavyntered only in 5.43 1.45 1.45 65.6650 0.036 0.036 1.6303 < 0.010 0.005 0.2264
4/21/2020 Bordered cells. 5.34 0.243 0.243 10.8222 0.021 0.021 0.9352 < 0.010 0.005 0.2227
Rest of
7/7/2020 worksheet is 5.00 0.289 0.289 12.0513 0.035 0.035 1.4595 < 0.010 0.005 0.2085
' protected, ,
password is
2) For below
detection data,
enter"<^in"<"
" column,and ,
enter detection
` level in Influent
, or Effluent mg/I
columns.
Spreadsheet , i •
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
iminiiiii
Column Averages=> 4.99800 0.6538 28.2013 0.0241 1.0318 0.0138 0.5915
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Aeration
Page 3 of 7 pages
12/28/2020, 7:00 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
(Sample Location: FLOW MOLYBDENUM NICKEL
Aeration Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5 22 0.0010 0.001 0.04353 0.026 0.026 1.1319
Instructions. ■
10/15/2019 1) Data 4.00 0.0005 0.0005 0.01668 0.013 0.013 0.4337
entered only in
1/9/2020 Heavy 5.43 0.0006 0.0006 0.02717 0.001 0.0005 0.0226
4/21/2020 Bost r d cells. 5.34 0.0006 0.0006 0.02672 0.002 0.002 0.0891
7/7/2020 worksheet is 5.00 0.0008 0.0008 0.03336 0.004 0.004 0.1668
protected,
password is
2) For below
detection data,
enter"<"in"<"
' column,and
enter detection
level in Influent
or Effluent mg/I
columns.
Spreadsheet - -will auto-
matically
calculate _
averages and T�
removal rates
using 1/2 value
entered.
� r
Column Averages=> 4.99800 0.00070 0.02949 0.0091 0.3688
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Aeration
Page 4 of 7 pages
12/28/2020, 7:00 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW SELENIUM SILVER ZINC
Aeration Used in Calculated Used in Calculated Used in Calculated
1 Sample Date 1 MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22 0.297 0.297 12.9298 0.047 0.047 2.0461 1.24 1.24 53.9832
Instructions:
10/15/2019 1) Data 4.00 0.110 0.11 3.6696 0.009 0.009 0.3002 0.916 0.916 30.5578
1/9/2020 enteredHeavy only in 5.43 < 0.010 0.005 0.2264 < 0.001 0.0005 0.0226 3.62 3.62 163.9360
4/21/2020 Bordered cells. 5.34 < 0.010 0.005 0.2227 < 0.001 0.0005 0.0223 0.745 0.745 33.1790
Rest of
7/7/2020 worksheetis 5.00 < 0.010 0.005 0.2085 0.004 0.004 0.1668 0.614 0.614 25.6038
protected,
password is
2" ��
2) For below
detection data, �Mml,
enter"<^in"<"
column,and
enter detection
level in Influent
or Effluent mg/I ��
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
Column Averages=> 4.99800 0.0844 3.4514 0.0122 0.5116 1.4270 61.4520
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Aeration
Page 5 of 7 pages
12/28/2020, 7:00 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW OIL&GREASE Chlorides TO al Phosphorus
Aeration Used in Calculated Used in Calculated Used in Calculated
Sample Date I MGD < mo L Calculation lbs/day < mg/1. Calculation lbs/day < mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22
Instructions:
10/15/2019 1) Data 4.00
1/9/2020entere Heavy
only in 5.43
4/21/2020 Bordered cells. 5.34
Rest of
7/7/2020 worksheet is 5.00
protected,
password is
2) For below
detection data,
enter"<"in"<"
column,and —-
enter detection
level in Influent
or Effluent mg/I
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered. —-
Column Averages=> 4.99800
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Aeration
Page 6 of 7 pages
12/28/2020, 7:00 AM
Revision:August 1999

Generic Data Summary Spreadsheet 2019 - Inf,Eff,PC,AB
Sample Location: FLOW Conductivity Sodium
Aeration Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < mg/L Calculation lbs/day < mJL Calculation lbs/day K mg/L Calculation lbs/day
9/23/2019 Spreadsheet 5.22
Instructions:10/15/2019 1) Data 4.00
entered only in
1/9/2020 Heavy 5.43
4/21/2070 Bordered cells. 5.34
Rest of -
7/7/2020 worksheet is 5.00
protected,
password is
2) For below
detection data,
enter"<"in"<"
column,and
enter detection
level in Influent
or Effluent mg/
columns.
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
Column Averages=> 4.99800
Generic Data Summary Spreadsheet 2019-Inf,Eff,PC,AB
Aeration
Page 7 of 7 pages
12/28/2020, 7:00 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Case Farms - Copy
Sample Location: FLOW BOD TSS • MONIA
Case Farms Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/11/2019 Spreadsheet 1.511 521 521 6565.51 80 80 1008.14
Instructions:
10/8/2019 1) Data 1.546 538 538 6936.78 266 266 3429.71
11/6/2019 Heavyd only in 1.321 393 393 4329.74 126 126 1388.16 13 13 143.__
Bordered cells. r
12/4/2019 Rest of 1.475 598 598 7356.30 104 104 1279.36
1/3/2020 worksheet is 1.363 669 669 7604.80 102 102 1159.48
2/4/2020 protected,
password is 1.447 594 594 7168.38 83 83 1001.64
3/11/2020 "2". 1.467 489 489 5982.81 71 71 868.67
,4/7/2020 2) For below 1.558 544 544 7068.58 74 74 961.54
detection data,
5/6/2020 enter^<"in"<" 1.59 556 556 7372.89 135 135 1790.18
6/3/2020 column,and
enter detection 1.749 792 792 11552.63 250 250 3646.67
7/14/2020 or levelEfFl inuent Influen
mg/tI 1.621 512 512 6921.80 58 58 784.1 I 11.4 11.4 154.12
8/19/2020 columns. 1.706 618 618 8792.93 64 64 910.59
Spreadsheet
will auto-
matically 1=======.m.
calculate _
averages and
removal rates ,
using 1/2 value
entered.
1
Column Averages=> 1.52950 568.67 7304.43 117.75 1519.02 12.20 148.67
Industry Generic Data Summary Spreadsheet 2019-Case Farms-Copy
data summary I
Page 1 of 7 pages 1
12/28/2020, 7:10 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Case Farms - Copy
Sample Location: FLOW CADMIUM C■ROMIUM
Case Farms Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/1 1/2019 Spreadsheet 1.511
Instructions:
10/8/2019 1) Data 1.546
1 1/6/2019 eHeaved only in 1.321 < 0.010 0.005 0.0551 0.0020 0.002 0.0220 < 0.001 0.0005 0.0055
Bordered cells.
12/4/2019 1.475
Rest of
1/3/2020 worksheet is 1.363
protected, ■ ,
2/4/2020 password is 1.447
3/11/2020 „2., 1.467
IMIP
4/7/2020 2) For below I.558
detection data, ■
5/6/2020 enter" in"<' 1.59
column,and
6/3/2020 enter detection 1.749
oreveEfflu
7/14/2020 ent ll in Influenmg/tl
1.621 < 0.010 0.005 0.0676 < 0.0002 0.0001 0.0014 0.014 0.014 0.1893
8/19/2020 columns. 1.706
Spreadsheet ■
will auto-
matically
calculate _
averages and
removal rates ,
using 1/2 value
entered.
,
�r i
Column Averages=> 1.52950 0.0050 0.0613 0.0011 0.0117 0.0073 0.0974
Industry Generic Data Summary Spreadsheet 2019-Case Farms-Copy
data summary
Page 2 of 7 pages
12/28/2020, 7:10 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Case Farms - Copy
'Sample Location: FLOW OPPER CYANIDE LEAD
Case Farms Used in Calculated Used in Calculated Used in Calculated
L _ Sample Date ( MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/1 1/2019 Spreadsheet 1.511
Instructions: ,
10/8/2019 1) Data 1.546
1 1/6/2019 entere Heavyd only in 1.321 < 0.001 0.0005 0.0055 0.011 0.011 0.1212 < 0.010 0.005 0.0551
12/4/2019 Bordered cells. 1 475
Rest of
1/3/2020 worksheet is 1.363
protected, i •
2/4/2020 password is 1.447
3/1 1/2020 ..2,. 1.467
4/7/2020 2) For below 1.558
detection data,
5/6/2020 enter"<'•in"<" 1.59
column,and ` o.iiii......
6/3/2020 enter detection 1.749
7/14/2020 level in Influent 1.621 0.037 0.037 0.5002 0.012 0.012 0.1622 < 0.010 0.005 0.0676
or Effluent mg/I
8/19/2020 columns. 1.706
Spreadsheet
will auto-
matically
calculate
averages and
removal rates ,
using 1/2 value
entered. i
r r
Column Averages=> 1.52950 0.0188 0.2529 0.0115 0.1417 0.0050 0.0613
Industry Generic Data Summary Spreadsheet 2019-Case Farms-Copy
data summary
Page 3 of 7 pages
12/28/2020, 7:10 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Case Farms - Copy
'Sample Location: FLOW MOLYBDENUM NICKEL
Case Farms Used in Calculated Used in Calculated Used in Calculated
Sample Date J MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/11/2019 Spreadsheet 1.511
Instructions:
10/8/2019 1) Data 1.546
1 1/6/2019 Hetaryd only in 1.321 < 0.0001 0.00005 0.00055 < 0.001 0.0005 0.0055 < 0.001 0.0005 0.0055
12/4/2019 Bordered cells. 1 475
Rest of
1/3/2020 worksheet is 1.363
2/4/2020 protected,
password is 1.447
3/11/2020 "2". 1.467
4/7/2020 2) For below 1.558
detection data,
5/6/2020 enter"<•'in"<" 1.59
6/3/2020 column,and
enter detection 1.749
7/14/2020 level m Influent 1.621 0.0002 0.0002 0.00270 0.009 0.009 0.1217 0.003 0.003 0.0406
or Effluent mg/I
8/19/2020 columns. 1.706
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
r 1
.4111.11.11111111
Column Averages=> 1.52950 0.00013 0.00163 0.0048 0.0636 0.0018 0.0230
Industry Generic Data Summary Spreadsheet 2019-Case Farms-Copy
data summary
Page 4 of 7 pages
12/28/2020, 7:10 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Case Farms - Copy
Sample Location: FLOW
Case Farms Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/11/2019 Spreadsheet 1.511
Instructions:
10/8/2019 1) Data 1.546
1 1/6/2019 H ea�yd only in 1.321 < 0.010 0.005 0.0551 < 0.001 0.0005 0.0055 11.5 11.5 126.6971
Bordered cells.
12/4/2019 1.475
Rest of
1/3/2020 worksheetis 1.363
2/4/2020 protected,
password is 1.447
3/11/2020 ,.2„ 1.467
•
4/7/2020 2) For below I.558
detection data,
5/6/2020 enter"<"in"<" 1.59
column,and '-
6/3/2020 enter detection 1.749
•
7/14/2020 or level in InEffluentFluen
mg/
t 1.621 < 0.010 0.005 0.0676 < 0.001 0.0005 0.0068 0.189 0.189 2.5551
8/19/2020 columns. 1.706
1 Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
1
Column Averages=> 1.52950 0.0050 0.0613 0.0005 0.0061 5.8445 64.6261
Industry Generic Data Summary Spreadsheet 2019-Case Farms-Copy
data summary
Page 5 of 7 pages
12/28/2020, 7:10 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Case Farms - Copy
Sample Location: FLOW OIL&GREASE Chlorides T. al Phosphorus
Case Farms Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/11/2019 Spreadsheet 1.511 8 8 100.8139
Instructions:
10/8/2019 1) Data 1.546 10 10 128.9364
1 1/6/2019 eHnetaevyred only in 1.321 16 16 176.2742
12/4/2019 Bordered cells. 1.475 9 9 110.7135
Rest of ,
1/3/2020 worksheet is 1.363 ` 9 9 102.3068
protected,
2/4/2020 password is 1.447 8 8 96.5438
3/11/2020 .,2.. 1.467 8 8 97.8782
4/7/2070 2) For below 1.558 8 8 103.9498
detection data,
—
5/6/2020 enter"<"in 1.59 12 12 159.1272
column,and
6/3/2020 enter detection 1.749 9 9 131.2799
7/14/2020 level in Influent 1.621 10 10 135.1914
or Effluent mg/I
8/19/2020 columns. 1.706 9 9 128.0524
Spreadsheet
will auto-
matically
calculate
averages and
removal rates r
using 1/2 value
entered. • + •
Column Averages=> 1.52950 9.6667 122.5890
Industry Generic Data Summary Spreadsheet 2019-Case Farms-Copy
data summary
Page 6 of 7 pages
12/28/2020, 7:10 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Case Farms - Copy
(Sample Location: FLOW Conductivity Sodium COD
Case Farms Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < mg/1.. Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/1 1/2019 Spreadsheet 1.511 806 806 10157.0024
Instructions: ,,
10/8/2019 1) Data 1.546 1 183 1183 15253.1761
~ entered only in
11/6/2019 Heavy 1.321 794 794 8747.6092
12/4/2019 Bordered cells. 1.475 923 923 11354.2845
Rest of
1/3/2020 worksheetis 1.363 896 896 10185.2083
protected,
2/4/2020 password is 1.447 802 802 9678.5200
3/11/2020 "2"' 1.467 927 927 11341.6411
4/7/2020 2) For below 1.558 799 799 10381.9823
u detection data,
5/6/2020 enter" in"<" 1.59 970 970 12862.7820
6/3/2020 column,and enter detection 1.749 1113 1 113 16234.9526
7/14/2020 or level inEffluent Influemg/Int 1.621 696 696 9409.3214
8/19/2020 columns. 1.706 822 822 11695.4489
Spreadsheet
will auto-
matically
calculate
averages and
removal rates ' ,
using 1/2 value
entered. .
1111
Column Averages=> 1.52950 894.2500 11441.8274
Industry Generic Data Summary Spreadsheet 2019-Case Farms-Copy
data summary
Page 7 of 7 pages
12/28/2020, 7:10 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Seiren
(Sample Location: FLOW BOD N IMONIA
Seiren Used in Calculated Used in Calculated Used in Calculated
Sample Date I MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/16/2019 Spreadsheet 0.551 173 173 794.99 20 20 91.91
Instructions:
10/7/2019 1) Data 0.422 165 165 580.71 27 27 95.03
11/4/2019 Heavyd only in 0.458 136 136 519.48 31 31 118.41 < 0.5 0.25 0.95
12/2/2019 Rest Bordered
d cells. 0.356 r 170 170 504.74 16 16 47.50
o1/6/2020 worksheet is 0.464 191 191 739.12 19 19 73.53
protected,
2/3/2020
password is 0.363 217 217 656.95 15 15 45.41
3/9/2020 "2". 0.638 140 140 744.93 22 22 117.06
4/7/2020 2) For below 0.419 193 193 674.43 20 20 69.89
detection data,
5/20/2020 enter'<"in"<" 0.005 111 111 4.63 17 17 0.71
column,and 0.470 182 182 713.40 12 12 47.04
6/9/2020 enter detection
7/20/2020 lorevelEfFlinuent Influent
mg/I 0.315 183 183 480.76 21 21 55.17 0.52 0.52 1.37
8/10/2020 columns. 0.299 210 210 523.67 21 21 52.37
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered. r
r
i
Column Averages=> 0.39667 172.58 578.15 20.08 67.83 (1.39 1.1/,
Industry Generic Data Summary Spreadsheet 2019-Seiren
data summary
Page 1 of 7 pages
12/28/2020, 7:12 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Seiren
Sample Location: FLOW CADMIUM C ROMIUM
Seiren Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < n1g'1_ Calculation lbs/day < mel, Calculation lbs/day < mg/L Calculation lbs/day
9/16/2019 Spreadsheet 0.551 < 0.001 0.0005 0.0023
Instrucons: < 0.001 0.0005 0.0018
10/7/2019 1) Dataa 0.42�2
1 1/4/2019 Head only in 0.458 < 0.010 0.005 0.0191 0.0033 0.0033 0.0126 < 0.001 0.0005 0.0019
12/2/2019 Bordered cells. 0.356 < 0.001 0.0005 0.0015
Rest of .
1/6/2020 worksheet is 0.464 < 0.001 0.0005 0.0019
protected, < 0.001 0.0005 0.0015
2/3/2020 password is 0.363
3/9/2020 "2"' 0.638 < 0.001 0.0005 0.0027
4/7/2020 2) For below 0.419 < 0.001 0.0005 0.0017
detection data, -5/20/2020 enter"<..in"<' 0.005 < 0.001 0.0005 0.0000
column,and 0.002 0.002 0.0078
6/9/2020 enter detection 0.470
7/20/2020 or levelEffluent in Influenmg/t 0.315 < 0.010 0.005 0.0131 0.0003 0.0003 0.0008 < 0.001 0.0005 0.0013
8/10/2020 columns. 0.299 < 0.001 0.0005 0.0012
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
Column Averages=> 0.39667 0.0050 0.0161 0.0018 0.0067 0.0006 0.0021
Industry Generic Data Summary Spreadsheet 2019-Seiren
data summary
Page 2 of 7 pages
12/28/2020, 7:12 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Seiren
'Sample Location: FLOW • ' ' CYANIDE LEAD
Seiren Used in Calculated Used in Calculated Used in Calculated
Sample Date I MGD mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation Ibs day
9/16/2019 Spreadsheet 0.551 -- 0.001 0.0005 0.0023
Instructions: •
10/7/2019 1) Data 0.422 0.003 0.003 0.0106
1 1/4/2019 H tend only in 0.458 < 0.001 0.0005 (1.0019 0.009 0.009 0.0344 < 0.010 0.005 0.0191
12/2/2019 Bordered cells 0.356 0.002 0.002 0.0059
Rest of
1/6/2020 worksheet is 0.464 0.016 0.016 0.0619
protected, < 0.001 0.0005 0.0015
2/3/2020 password is 0.363
3/9/2020 "2". 0.638 < 0.001 0.0005 0.0027
4/7/2020 2) For below 0.419 < 0.001 0.0005 0.0017
detection data,
5/20/2020 enter" in"<" 0.005 0.028 0.028 0.0012
column,and
6/9/2020 enter detection 0.470 0.021 0.021 0.0823
7/20/2020 or leveEl i ffl n Influen
mg/tI
0.315 0.014 0.014 0.0368 0.012 0.012 0.0315 < 0.010 0.005 0.t)131
nu
- -
8/10/2020 columns. 0.299 0.033 0.033 0.0823
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered. '
Column Averages=> 0.39667 0.0100 0.0243 0.9105 0.0330 0.0050 0.0161
Industry Generic Data Summary Spreadsheet 2019-Seiren
data summary
Page 3 of 7 pages
12/28/2020, 7:12 AM
Revision:August 1999
l-

Industry Generic Data Summary Spreadsheet 2019 - Seiren
jSample Location: FLOW • MOLYBDENUM
Seiren Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < mg%L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/16/2019 Spreadsheet 0.551 < 0.001 0.0005 0.0023
Instructions: < 0.001 0.0005 0.0018
10/7/2019 1) Dataa0.422
1 1/4/2019 enteredHeavy only in 0.458 < 0.0001 0.00005 0.00019 0.013 0.013 0.0497 0.05 I 0.051 0.1948
12/2/2019 Rost r d cells. 0.356 0.019 0.019 0.0564
1/6/2020 worksheet is 0.464 < 0.001 0.0005 0.0019
2/3/2020 protected,
password is 0.363 < 0.001 0.0005 0.0015
3/9/2020 "2". 0.638 _ < 0.001 0.0005 0.0027
4/7/2020 2) For below 0.419 < 0.001 0.0005 0.0017
detection data. -
5/20/2020 enter in"<" 0.005 < 0.001 0.0005 0.0000
e and < 0.001 0.0005 0.0020
6/9/2020 enternter detection 0.470
7/20/2020 or leveEl in Influemg/I K nt 0.315 0.0001 0.00005 0.00013 0.002 0.002 0.0053 < 0.001 0.0005 0.0013
ff luent
8/10/2020 columns. 0.299 1 < 0.001 0.0005 0.0012
Spreadsheet
will auto-
matically
calculate
averages and
removal rates ,--- -
using 1/2 value
entered.
1
Column Averages=> 0.39667 0.00005 0.00016 0.0075 0.0275 0.0063 0.0223
Industry Generic Data Summary Spreadsheet 2019-Seiren
data summary
Page 4 of 7 pages
12/28/2020, 7:12 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Seiren
Sample Location: FLOW SILVER
Seiren Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/16/2019 Spreadsheet 0.551 0.015 0.015 0.0689 0.184 0.184 0.8455
Instructions:
10/7/2019 1) Data 0.422 < 0.010 0.005 0.0176 0.079 0.079 0.2780
11/4/2019 entered only in 0.458 < 0.010 0.005 0.0191 < 0.001 0.0005 0.0019 0.196 0.196 0.7487
12/2/2019 Bordt r d cells. 0.356 0.062 0.062 0.1841 0.056 0.056 0.1663
R1/6/2020 worksheetis 0.464 < 0.010 0.005 0.0193 0.669 0.669 2.5889
rotect2/3/2020 pa sword is 0.363 < 0.010 0.005 0.0151 0.104 0.104 0.3149
3/9/2020 "2". 0.638 < 0.010 0.005 0.0266 0.106 0.106 0.5640
4/7/2020 2) For below 0.419 < 0.010 0.005 0.0175 0.117 0.117 0.4089
detection data,
5/20/2020 enter"<"in"<" 0.005 < 0.010 0.005 0.0002 0.418 0.418 0.0174
6/9/2020 column,and enter detection 0.470 < 0.010 0.005 0.0196 0.5240.524 2.0540
7/20/2020 level in Influent 0.315 < 0.010 0.005 0.0131 < 0.001 0.0005 0.0013 0.184 0.184 0.4834
or Effluent mg/I
8/10/2020 columns. 0.299 < 0.010 0.005 0.0125 0.377 0.377 0.9401
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered.
Column Averages=> 0.39667 0.0106 0.0345 0.0005 0.0016 0.2512 0.7842
Industry Generic Data Summary Spreadsheet 2019-Seiren
data summary
Page 5 of 7 pages
12/28/2020, 7:12 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Seiren
Sample Location: FLOW OIL&GREASE Phenols Total Phosphorus
Seiren Used in Calculated Used in Calculated Used in Calculated
Sample Date MGD mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/l. Calculation lbs/day
9/16/2019�Spreadsheet 0.551 0.015 0.015 0.0689
Instructions:
10/7/2019 1) Data 0.422 0.020 0.02 0.0704
entered only in '' �
11/4/2019 Heavy 0.458 10 10 38.1972 0.016 0.016 0.0611
12/2/2019 Bordered cells. 0.356 0.019 0.019 0.0564
Rest of
T-
1/6/2020 worksheet is 0.464 0.018 0.018 0.0697
2/3/2020 protected,
password is 0.363 0.019 0.019 0.0575
3/9/2070 "2". 0.638 0.017 0.017 0.0905
4/7/2020 2) For below 0.4 19 0.01 1 0.01 1 0.0384
detection data, 1 .
5/20/2020 enter"<"in"<" 0.005 0.022 0.022 0.0009
r --- column,and
6/9/2020 enter detection 0.470 0.020 0.02 0.0784
7/20/2020 or levelEffl in Influentmg/I 0.315 8 8 21.0168 0.017 0.017 0.0447
uent
8/10/2020 columns. 0.299 0.015 0.015 0.0374
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered. - - -. '
r
IMEMIr
Column Averages=> 0.39667 9.0000 29.6070 0.0174 0.0562
Industry Generic Data Summary Spreadsheet 2019-Seiren
data summary
Page 6 of 7 pages
1 12/28/2020, 7:12 AM
Revision:August 1999

Industry Generic Data Summary Spreadsheet 2019 - Seiren
Sample Location: FLOW Conductivity Sodium COD
Seiren Used in Calculated Used in Calculated Used in Calculated
Sample Date 1 MGD < mg/L Calculation lbs/day < mg/L Calculation lbs/day < mg/L Calculation lbs/day
9/16/2019 Spreadsheet 0.551 785 785 3607.3419
Instructions: I
10/7/2019 1) Data 0.422 --.11 812 812 2857.8178
11/4/2019 Heavyd only in 0.458 764 764 2918.2661
12/2/2019 Rest Bordered cells_ 0.356 669 669 1986.2878
1/6/2020 worksheet is 0.464 754 754 2917.7990
protected,
2/3/2020 password is 0.363 774 774 2343.2231
3/9/2020 "2". 0.638 625 625 3325.5750
4/7/2020 2) For below 0.419 987 987 3449.0320
detection data,
5/20/2020 enter"<"in"<" 0.005 299 299 12.4683
6/9/2020 column,and
enter detection 0.470 723 723 2834.0154
7/20/2020 level in Influent 0315, 766 766 2012.3586
or Effluent mg/I 1 =====m1
8/10/2020 columns. 0.299 946 946 2359.0024
Spreadsheet
will auto-
matically
calculate
averages and
removal rates
using 1/2 value
entered. ,
Column Averages=> 0.39667 742.0000 2551.9323
Industry Generic Data Summary Spreadsheet 2019-Seiren
data summary
Page 7 of 7 pages
12/28/2020, 7:12 AM
Revision:August 1999

Significant Industrial User Monthly Monitor
2019 Case Farms
Paremeter & Permit Limits pH BOD COD
Date Time 6.0 - 11.0 8340 lbs 33360 lbs
1/9/2019 0800/0800 7.28 6033 8946
2/6/2019 0800/0800 6.53 5501 7627
3/13/2019 0800/0800 8.34 5738 8270
4/3/2019 0800/0800 8.04 5368 8339
5/13/2019 0800/0800 6.77 5958 8932
6/5/2019 0800/0800 6.42 5788 8542
7/10/2019 0800/0800 7.65 7131 8847
8/7/2019 0800/0800 7.50 7743 11225
9/11/2019 0800/0800 7.25 6566 10157
10/8/2019 0800/0800 7.88 6645 15253
11/6/2019 0800/0800 6.55 4330 8748
12/4/2019 0800/0800 7356 11354

0'U
•
o rt
N N CO W U1 A A W .P A O —� CU
CD iv cr, O Oo I O N J NJ Cn E N
-)
00
0
=
O D
LC) p Co W lD CO lD lD 3 C)
CT) Oo fD
v
CD
N
N N N N N N N N N O T_
Lk) (.n U'i 6l A A W N iv iv W O
N A h-' O O 01 Cn Ql O 1
Co U'i 1-) Ol V O 00 O Cl

r
nifi ant Industrial User Monthly c Monitor
2020 Case Farms
Paremeter & Permit Limits
pH BOD COD
Date Time 6.0- 11.0 8340 lbs 33360 lbs
1/13/2020 0800/0800 7.23 7605 10185
2/4/2020 0800/0800 8.42 7168 9679
3/11/2020 0800/0800 8.99 5983 11342
4/7/2020 0800/0800 7.87 7205 10382
5/6/2020 0800/0800 7.04 7373 12863
6/3/2020 0800/0800 6.27 11553 16235
7/14/2020 0800/0800 7.34 6292 9409
8/19/2020 0800/0800 7.50 8793 11695

ing Data
TSS Oil & Grease Flow
400 mg/I 100 mg/I 2.0 MGD
102 9 1.363
83 8 1.447
71 8 1.467
74 8 1.558
135 12 1.590
250 9 1.749
58 10 1.621
64 9 1.706

Significant Industrial User Monthly Monitor
2019 Seiren
Paremeter & Permit Limits
pH BOD COD
Date Time 6.0- 11.0 500 mg/I 2000 mg/I
1/7/2019 0800/0800 5.88 208 769
2/13/2019 0800/0800 6.53 176 804
3/5/2019 0800/0800 8.75 199 767 1
4/1/2019 0800/0800 6.28 179 800
5/6/2019 0800/0800 6.76 213 814
6/3/2019 0800/0800 6.24 167 756
7/16/2019 0800/0800 6.83 204 699
8/1/2019 0800/0800 10.58 157 669
9/16/2019 0800/0800 6.17 173 785
10/7/2019 0800/0800 7.23 165 812
11/4/2019 0800/0800 6.82 136 764
12/2/2019 0800/0800 6.52 170 669

ing Data
TSS Chromium Copper Nickel Phenols
300 mg/I 0.325 mg/I 0.325 mg/I 0.250 5.0 mg/I
24 <0.001 0.021 <0.001 0.019
23 <0.001 0.012 <0.001 0.017
15 <0.001 <0.001 <0.001 0.019
22 <0.001 0.020 <0.001 0.017
21 <0.001 <0.001 <0.001 0.018
16 0.008 0.032 <0.001 0.022
18 <0.001 0.047 <0.001 0.019
15 <0.001 <0.001 <0.001 0.023
20 <0.001 <0.001 <0.001 0.015
27 <0.001 0.003 <0.001 0.020
31 <0.001 <0.001 0.051 0.016
16 <0.001 0.002 <0.001 0.019

f
Selenium Zinc Temperature Flow
Monitor Only 0.450 mg/I 55 C 1.5 MGD
<0.010 0.089 29.3 0.494
<0.010 0.015 30.2 0.455
<0.010 <0.001 32.7 0.525
<0.010 <0.001 32.6 0.479
<0.010 0.028 36.2 0.566
0.015 0.046 40.5 0.472
<0.010 0.213 32.5 0.520
<0.010 0.006 40.5 0.497
<0.010 0.184 37.2 0.551
<0.010 0.079 37.2 0.422
<0.010 0.196 27.3 0.458
0.062 0.056 26.5 0.356

1
Significant Industrial User Monthly Monitor
2020 Seiren
Paremeter & Permit Limits
pH BOD COD
Date Time 6.0- 11.0 500 mg/I 2000 mg/I
1/6/2020 0800/0800 9.12 191 754
2/3/2020 0800/0800 6.01 217 774
3/9/2020 0800/0800 10.61 140 625
4/7/2020 0800/0800 6.32 193 987
5/20/2020 0800/0800 6.79 111 299
6/9/2020 0800/0800 6.09 182 723
1 7/20/2020 0800/0800 6.01 183 766
8/10/2020 0800/0800 6.00 210 946

STO'0 T00'0> ££0'0 T00'0> TZ
LTO'0 T00'0> V10'0 T00'0> TZ
OZO'0 T00•0> TZ0'0 Z00.0 ZT
ZZO'0 T00'0> 8Z0'0 T00'0> LT
TT0'0 T00'0> T00'0> T00'0> 0Z
LTO'0 T00'0> T00'0> T00'0> ZZ
6T0'0 T00'0> T00'0> T00'0> ST
8T0'0 T00'0> 9T0'0 T00'0> 61
I/sw 0'S OSZ'0 I/sw SZ£'0 I/sw SZ£'0 I/sw 00£
siouayd Ia)ID!N aaddoD LumwoRD SSl
I elea 2u!

Selenium Zinc Temperature Flow
Monitor Only 0.450 mg/I 55 C 1.5 MGD
<0.010 0.669 30.6 0.464
<0.010 0.104 29.3 0.363
<0.010 0.106 30.1 0.638
<0.010 0.117 30.3 0.419
<0.010 0.418 25.4 0.005
<0.010 0.524 38.3 0.470
<0.010 0.184 37 0.315
<0.010 0.377 36.1 0.299

ROY COOPER
ir,
Governor
MICHAEL S.REGAN
Secretary
Water Resources S. JAY ZIMMERMAN
ENVIRONMENTAL QUALITY
Director
August 23,2017
BRAD BORIS—WATER RESOURCES DIRECTOR
CITY OF MORGANTON
POST OFFICE BOX 3448
MORGANTON,NORTH CAROLINA 28680-3448
Subject: Permit No. WQ0002127
City of Morganton DCAR
Distribution of Class A
Compost Residuals
Burke County
Dear Mr. Boris:
In accordance with your permit renewal request received June 1,2017, and subsequent additional
information received August 4, 2017, we are forwarding herewith Permit No. WQ0002127 dated August
23, 2017, to the City of Morganton for the continued operation of the subject residuals management
program. Please note that this renewed permit shall become effective on March 1,2018 (i.e.,the day after
the expiration date of the existing permit).
Modifications to the subject permit are as follows: Removal of the Catawba River WTP as a
residuals source for the residuals composting facility.
This permit shall be effective from March 1, 2018 until February 28, 2023, shall void Permit No.
WQ0002127 issued March 13, 2009, and shall be subject to the conditions and limitations as specified
therein. Please pay particular attention to the monitoring requirements listed in Attachment A for they may
differ from the previous permit issuance. Failure to establish an adequate system for collecting and
maintaining the required operational information shall result in future compliance problems.
Please note the following permit conditions have been removed since the last permit issuance
dated March 13,2009:
➢ Old Condition II.9.—Compliance Boundary does not apply to Class A distribution permits.
➢ Old Condition II.10.—Review Boundary does not apply to Class A distribution permits.
➢ Old Condition III.5.—Replaced by Condition III.9.
➢ Old Condition IV.8.—Duration of record keeping now part of individual condition.
-"-`Nothing Compares
State of North Carolina I Environmental Quality(Water Resources I Water Quality Permitting I Non-Discharge Permitting
1617 Mail Service Center I Raleigh,North Carolina 27699-1617
919-807-6332

Mr.Brad Boris
August 23,2017
Page 2 of 2
Please note the following permit conditions are new since the last permit issuance dated
March 13,2009:
➢ Condition I.2.—Permittee to submit Operation&Maintenance(O&M)Plan within 90 days of
effective date of this permit.
➢ Condition 111.2.—O&M Plan requirements stipulated.
➢ Condition 1I1.4. —Similar to Old Condition III.8., but now copy of permit and O&M Plan to
be on site during application of residuals. Note that copy may include electronic copy.
➢ Condition 1I1.7.—With bulk application of residuals, a vegetative cover to be maintained.
➢ Condition 1II.8.g. and k.—Bulk application of residuals not to occur if the slope is too great or
at a rate exceeding the agronomic rate.
➢ Condition III.9.—Permittee shall inform residuals user of conditions under which residuals to
be applied.
➢ Condition VI.6. — Similar to Old Condition VI.6., but now revocation or modification occurs
60 days after notice.
➢ Condition VI.7.—Expansion of facility not permitted without waiver if Permittee has exhibited
behavior detrimental to environment.
If any parts, requirements or limitations contained in this permit are unacceptable, the Permittee
has the right to request an adjudicatory hearing upon written request within 30 days following receipt of
this permit. This request shall be in the form of a written petition,conforming to Chapter 150B of the North
Carolina General Statutes, and filed with the Office of Administrative Hearings at 6714 Mail Service
Center,Raleigh,NC 27699-6714. Unless such demands are made,this permit shall be final and binding.
If you need additional information concerning this permit,please contact Troy Doby at(919)807-
6336 or [e-mail].
Sincerely,
' � J
p.S. Jay Zimmerman,P.G.,Director
Division of Water Resources
cc: Burke County Health Department(Electronic Copy)
Asheville Regional Office,Water Quality Regional Operations Section(Electronic Copy)
Digital Permit Archive(Electronic Copy)
Central Files

NORTH CAROLINA
ENVIRONMENTAL MANAGEMENT COMMISSION
DEPARTMENT OF ENVIRONMENTAL QUALITY
RALEIGH
DISTRIBUTION OF CLASS A COMPOST RESIDUALS PERMIT
In accordance with the provisions of Article 21 of Chapter 143,General Statutes of North Carolina as
amended, and other applicable Laws,Rules,and Regulations
PERMISSION IS HEREBY GRANTED TO
City of Morganton
Burke County
FOR THE
continued operation of a residuals management program for the City of Morganton and consisting of the
distribution of Class A compost residuals generated by the approved facilities listed in Attachment A with
no discharge of wastes to surface waters,pursuant to the application received June 1,2017,and subsequent
additional information received by the Division of Water Resources, and in conformity with other
supporting data subsequently filed and approved by the Department of Environmental Quality and
considered a part of this permit. The use and disposal of residuals are regulated under Title 40 Code of
Federal Regulations Part 503. This permit does not exempt the Permittee from complying with the federal
regulations.
This permit shall be effective from March 1, 2018 until February 28, 2023, shall void Permit No.
WQ0002127 issued March 13, 2009, and shall be subject to the following specified conditions and
limitations:
SCHEDULES
1. No later than six months prior to the expiration of this permit, the Permittee shall request renewal of
this permit on official Division forms. Upon receipt of the request, the Division will review the
adequacy of the facilities described therein,and if warranted,will renew the permit for such period of
time and under such conditions and limitations as it may deem appropriate. Please note Rule 15A
NCAC 02T.0105(d)requires an updated site map to be submitted with the permit renewal application.
[15A NCAC 02T.0108(b)(2), 02T .0105(d), 02T.0109]
IL PERFORMANCE STANDARDS
1. The subject residuals management program shall be effectively maintained and operated at all times so
there is no discharge to surface waters, nor any contravention of groundwater or surface water
standards. In the event the facilities fail to perform satisfactorily, including the creation of prolonged
nuisance conditions due to improper operation and maintenance,the Permittee shall immediately cease
distribution of residuals, contact the Asheville Regional Office supervisor, and take any immediate
corrective actions. [G.S. 143-215.1]
WQ0002127 Version 4.0 Shell Version 170401 Page 1 of 10

2. This permit shall not relieve the Permittee of responsibility for damages to groundwater or surface
water resulting from the operation of this residuals management program. [15A NCAC 02B .0200,
02L .0100]
3. Only residuals generated by the facilities listed in Attachment A are approved for distribution in
accordance with this permit. [G.S. 143-215.1]
4. Pollutant concentrations in residuals distributed or applied to any land application site shall not exceed
the following Ceiling Concentrations or Monthly Average Concentrations(i.e.,dry weight basis):
Ceiling Concentration Monthly Average
Parameter (milligrams per kilogram) Concentration
(milligrams per kilogram)
Arsenic 75 41
Cadmium 85 39
Copper 4,300 1,500
Lead 840 300
Mercury 57 17
Molybdenum 75 n/a
Nickel 420 420
Selenium 100 100
Zinc 7,500 2,800
[15A NCAC 02T.1105]
5. Residuals that are distributed shall meet Class A pathogen reduction requirements in 15A NCAC 02T
.1106(a)and(b). Exceptions to this requirement shall be specified in Attachment A. [15A NCAC 02T
.1106]
6. Biological residuals (i.e. residuals generated during the treatment of domestic or animal processing
wastewater, or the biological treatment of industrial wastewater, and as identified in Attachment A)
that are distributed shall meet one of the vector attraction reduction alternatives in 15A NCAC 02T
.1107(a). Exceptions to this requirement shall be specified in Attachment A. [15A NCAC 02T .1107]
7. Setbacks for treatment and storage facilities shall be as follows:
Setback Description Setback
(feet)
Habitable residence or place of public assembly under separate ownership or not to 100
be maintained as part of the project site
Property lines 50
Private or public water supply 100
Surface waters(streams—intermittent and perennial,perennial waterbodies, and 50
wetlands)
Wells with exception to monitoring wells 100
[15A NCAC 02T .1108]
WQ0002127 Version 4.0 Shell Version 170401 Page 2 of 10

8. Setbacks for Class A land applied bulk residuals shall be as follows:
Setback by residual type
Setback Description (feet)
Liquid Cake
Private or public water supply 100 100
Surface waters(streams—intermittent and perennial, 100 25
perennial waterbodies, and wetlands)
Surface water diversions(ephemeral streams,
waterways,ditches) 25 0
Groundwater lowering ditches (where the bottom of 25 0
the ditch intersects the SHWT)
Wells with exception to monitoring wells 100 100
Bedrock outcrops 25 0
Unless otherwise noted in Attachment A, "cake" residuals are those that have greater than 15%
solids by weight and can be stacked without flowing, as well as can be handled, transported and
spread as a solid (e.g., using a backhoe, front end loader, slinger spreader, broadcast spreader or
other equipment designed for handling solid materials) without leaving any significant liquid
fraction behind.
[15A NCAC 02T .1108]
9. Bulk residuals and other sources of Plant Available Nitrogen(PAN)shall not be applied in exceedance
of agronomic rates. Appropriate agronomic rates shall be calculated using expected nitrogen
requirements based on the determined Realistic Yield Expectations (RYE) using any of the following
methods:
a. Division's pre-approved site specific historical data for specific crop or soil types by calculating
the mean of the best three yields of the last five consecutive crop harvests for each field.
b. North Carolina Historical Data for specific crop and soil types as provided by North Carolina State
University Department of Soil Science (http://nutrients.soil.ncsu.edu/yields/index.php). A copy
shall be kept on file and reprinted every five years in accordance with Condition IV.6.
c. If the RYE cannot be determined using methods(a) or(b)above,the Permittee may use the RYE
and appropriate nutrient application rates reported in any of the following documents:
i. Crop management plan as outlined by the local Cooperative Extension Office, the North
Carolina Department of Agriculture and Consumer Services, the Natural Resource
Conservation Service, or other agronomist.
ii. Waste Utilization Plan as outlined by the Senate Bill 1217 Interagency Group - Guidance
Document: Chapter 1
(http://www.ncagr.gov/SWC/tech/documents/9th Guidance Doc 100109.pdf).
iii. Certified Nutrient Management Plan as outlined by the Natural Resources Conservation
Services (NRCS). These plans must meet the USDA-NRCS 590 Nutrient Management
Standards(ftp://ftp-fc.sc.egov.usda.gov/NHQ/practice-standards/standards/590.pdf).
d. If the RYE and appropriate nutrient application rates cannot be determined, the Permittee shall
contact the Division to determine necessary action.
[15A NCAC 02T .1109(b)(1)(k)]
WQ0002127 Version 4.0 Shell Version 170401 Page 3 of 10

10. The Permittee shall not distribute Class A compost residuals that have a sodium adsorption ratio(SAR)
of 10 or higher without prior written Division approval. The Permittee may seek approval by
demonstrating that the entity accepting the residuals is: aware of the effects of a high SAR content;has
agreed on proper residual application rates; and has agreed to operational considerations to ensure that
the high SAR content will not adversely impact the receiving sites. Recommendations regarding
sodium application rate, soil amendments (e.g., gypsum, etc.) or a mechanism for maintaining site
integrity and conditions conducive to crop growth, can be obtained from the local Cooperative
Extension Office, the Department of Agriculture and Consumer Services, the Natural Resource
Conservation Service, a North Carolina Licensed Soil Scientist, or an agronomist. [15A NCAC 02T
.0108(b)(1)]
III. OPERATION AND MAINTENANCE REQUIREMENTS
1. The residuals management program shall be properly maintained and operated at all times. The
program shall be effectively maintained and operated as a non-discharge system to prevent any
contravention of surface water or groundwater standards. [15A NCAC 02T.1110]
2. The Permittee shall maintain an approved Operation and Maintenance Plan(O&M Plan)Modifications
to the O&M Plan shall be approved by the Division prior to utilization of the new plan.The O&M Plan,
at the minimum, shall include:
a. Operational functions;
b. Maintenance schedules;
c. Safety measures;
d. Spill response plan;
e. Inspection plan including the following information:
i. Names and/or titles of personnel responsible for conducting the inspections;
ii. Frequency and location of inspections, including those to be conducted by the ORC, and
procedures to assure that the selected location(s) and inspection frequency are representative
of the residuals management program;
iii. Detailed description of inspection procedures including record keeping and actions to be taken
by the inspector in the event that noncompliance is observed pursuant to the noncompliance
notification requirements under the monitoring and reporting section of the permit;
f. Sampling and monitoring plan including the following information:
i. Names and/or titles of personnel responsible for conducting the sampling and monitoring;
ii. Detailed description of monitoring procedures including parameters to be monitored;
iii. Sampling frequency and procedures to assure that representative samples are being collected.
Fluctuation in temperature, flow, and other operating conditions can affect the quality of the
residuals gathered during a particular sampling event. The sampling plan shall account for any
foreseen fluctuations in residuals quality and indicate the most limiting times for residuals to
meet pathogen and vector attraction reduction requirements (e.g. facilities that distribute
multiple times per year but have an annual sampling frequency, may need to sample during
winter months when pathogen reduction is most likely to be negatively affected by cold
temperatures).
[15A NCAC 02T .1100]
WQ0002127 Version 4.0 Shell Version 170401 Page 4 of 10

3. Upon the Water Pollution Control System Operators Certification Commission's (WPCSOCC)
classification of the facility,the Permittee shall designate and employ a certified operator in responsible
charge (ORC) and one or more certified operators as back-up ORCs in accordance with 15A NCAC
08G.0201.The ORC or his back-up shall visit the facilities in accordance with 15A NCAC 08G.0204,
or as specified in the most recently approved O&M plan (i.e., see Condition III.2.), and shall comply
with all other conditions of 15A NCAC 08G.0204. For more information regarding classification and
designation requirements,please contact the Division of Water Resources'Protection and Enforcement
Branch at(919)707-9105. At the time of this permit issuance, a certified ORC is not required for the
subject Distribution of Class A Residuals program. [15A NCAC 02T.0117]
4. When the Permittee land applies bulk residuals,a copy of this permit and a copy of O&M Plan shall be
maintained at the land application sites during land application activities. [15A NCAC 02T
.0108(b)(1)]
5. When the Permittee transports or land applies bulk residuals, the spill control provisions shall be
maintained in all residuals transport and application vehicles. [15A NCAC 02T .1110]
6. When the Permittee land applies bulk residuals, adequate measures shall be taken to prevent wind
erosion and surface runoff from conveying residuals from the land application sites onto adjacent
or into surface waters. G.S. 143-215.1
properties L ]
7. When the Permittee land applies bulk residuals,a suitable vegetative cover shall be maintained on land
application sites onto which residuals are applied, or application shall be in accordance with the crop
management plan outlined by the local Cooperative Extension Office,the Department of Agriculture
and Consumer Services,the Natural Resource Conservation Service,or an agronomist and as approved
by the Division. [15A NCAC 02T .1109(b)(1)]
8. Bulk residuals shall not be land applied under the following conditions:
a. If the residuals are likely to adversely affect a threatened or endangered species listed under section
4 of the Endangered Species Act or its designated critical habitat;
b. If the application causes prolonged nuisance conditions;
c. If the land fails to assimilate the bulk residuals or the application causes the contravention of surface
water or groundwater standards;
d. If the land is flooded,frozen or snow-covered,or is otherwise in a condition such that runoff of the
residuals would occur;
e. Within the 100-year flood elevation,unless the bulk residuals are injected or incorporated within a
24-hour period following a residuals land application event;
f. During a measurable precipitation event(i.e., greater than 0.01 inch per hour), or within 24 hours
following a rainfall event of 0.5 inches or greater in a 24-hour period;
g. If the slope is greater than 10% for surface applied liquid residuals, or if the slope is greater than
18% for injected or incorporated bulk liquid residuals;
h. If the land does not have an established vegetative cover unless the residuals are incorporated or
injected within a 24-hour period following a residuals land application event.Any field that is in a
USDA, state or county no-till program shall be exempted from meeting this vegetative cover
requirement;
i. If the vertical separation between the seasonal high water table and the depth of residuals
application is less than one foot;
j. If the vertical separation of bedrock and the depth of residuals application is less than one foot;
k. Application exceeds agronomic rates.
[15A NCAC 02T .1109]
WQ0002127 Version 4.0 Shell Version 170401 Page 5 of 10

9. The Permittee shall notify all third-party entities receiving bulk distributed Class A compost residuals
that land application activities occurring on the third-party's property shall meet the requirements in
15A NCAC 02T .1108(b)(1) and 02T .1109(b) (i.e., Conditions 11.8. and I11.8., respectively). [15A
NCAC 02T .1103(4), 15A NCAC 02T.1103(5)]
10. All residuals shall be adequately stored to prevent untreated leachate runoff.The finished product may
be placed on a concrete pad,placed under shelter or physically covered until it is distributed to a third-
party entity. If bulk residuals are to be applied, the residuals may be staged at the application site for
up to 30 days for biological residuals,and 60 days for non-biological residuals. If an alternate storage
site is used,approval must be obtained from the Division. [15A NCAC 02T.0108(b)(1)]
11. A label shall be affixed to the bag or other container in which residuals are sold or given away for land
application,or an information sheet shall be provided to the person who receives Class A residuals. At
a minimum,the label or information sheet shall contain the following:
a. The name and address of the person who prepared the residuals;
b. A statement that residual land application is prohibited except in accordance with the instructions
on the label or information sheet;
c. A statement identifying that this material shall be prevented from entering any public or private
water supply source(including wells)and any surface water(e.g.,stream,lake,river,wetland,etc.);
d. A statement that the residuals shall be applied at agronomic rates and recommended rates for its
intended use.
[15A NCAC 02T.1109(a)]
12. The Permittee shall not distribute bulk residuals to any person or entity known to be applying residuals
contrary to the conditions of this permit. The Permittee shall report to the Asheville Regional Office
as per reporting conditions under Condition IV.8.any person or entity known to be applying residuals
contrary to the condition of this permit. [15A NCAC 02T .1103(a)]
WQ0002127 Version 4.0 Shell Version 170401 Page 6 of 10

IV. MONITORING AND REPORTING REQUIREMENTS
1. Any Division-required monitoring (including groundwater, plant tissue, soil and surface water
analyses) necessary to ensure groundwater and surface water protection shall be established, and an
acceptable sample reporting schedule shall be followed. [15A NCAC 02T .0108(c)]
2. Residuals shall be analyzed to demonstrate they are non-hazardous under the Resource Conservation
and Recovery Act(RCRA). Residuals that tests or is classified as a hazardous or toxic waste under 40
CFR Part 261 shall not be used or disposed under this permit. The analyses [corrosivity,ignitability,
reactivity, and toxicity characteristic leaching procedure (TCLP)] shall be performed at the
frequency specified in Attachment A, and the Permittee shall maintain these results for a minimum of
five years. Any exceptions from the requirements in this condition shall be specified in Attachment A.
The TCLP analysis shall include the following parameters(the regulatory level in milligrams per liter
is in parentheses):
Arsenic(5.0) 1,4-Dichlorobenzene(7.5) Nitrobenzene(2.0)
Barium(100.0) 1,2-Dichloroethane (0.5) Pentachlorophenol(100.0)
Benzene(0.5) 1,1-Dichloroethylene(0.7) Pyridine(5.0)
Cadmium(1.0) 2,4-Dinitrotoluene(0.13) Selenium(1.0)
Carbon tetrachloride(0.5) Endrin(0.02) Silver(5.0)
Chlordane(0.03) Hexachlorobenzene(0.13) Tetrachloroethylene (0.7)
Chlorobenzene(100.0) Heptachlor(and its hydroxide) Toxaphene(0.5)
(0.008)
Chloroform(6.0) Hexachloro-1,3-butadiene(0.5) Trichloroethylene(0.5)
Chromium(5.0) Hexachloroethane(3.0) 2,4,5-Trichlorophenol(400.0)
m-Cresol(200.0) Lead(5.0) 2,4,6-Trichlorophenol(2.0)
o-Cresol(200.0) Lindane(0.4) 2,4,5-TP(Silvex)(1.0)
p-Cresol(200.0) Mercury(0.2) Vinyl chloride (0.2)
Cresol(200.0) Methoxychlor(10.0)
2,4-D(10.0) Methyl ethyl ketone(200.0)
[15A NCAC 13A .0102(b),02T.1101,02T.1105]
WQ0002127 Version 4.0 Shell Version 170401 Page 7 of 10

3. An analysis shall be conducted on the residuals from each source generating facility at the frequency
specified in Attachment A, and the Permittee shall maintain the results for a minimum of five years.
The analysis shall include the following parameters:
Aluminum Mercury Potassium
Ammonia-Nitrogen Molybdenum Selenium
Arsenic Nickel Sodium
Cadmium Nitrate-Nitrite Nitrogen Sodium Adsorption Ratio
(SAR)
Calcium Percent Total Solids TKN
Copper pH Zinc
Lead Phosphorus
Plant Available Nitrogen
Magnesium (by calculation)
[15A NCAC 02T.1101]
4. Residuals shall be monitored for compliance with pathogen and vector attraction reduction
requirements at the frequency specified in Attachment A, and at the time indicated in the sampling and
monitoring sections of the approved O&M plan.The required data shall be specific to the stabilization
process utilized, and sufficient to demonstrate compliance with the Class A pathogen reduction
requirements in 15A NCAC 02T.1106(a)and(b), and one vector attraction reduction requirement in
15A NCAC 02T .1107 (a)shall be met. Any exceptions from the requirements in this condition shall
be specified in Attachment A. [15A NCAC 02T.1106, 02T.1107,02T.1111(c)]
5. Laboratory parameter analyses shall be performed on the residuals as they are distributed,and shall be
in accordance with the monitoring requirements in 15A NCAC 02B .0505. [15A NCAC 02B .0505]
6. The Permittee shall maintain records tracking all bulk residual distribution or land application events
performed by the Permittee. At a minimum,these records shall include the following:
a. Source of residuals;
b. Date of distribution/land application;
c. Name and address of recipient of residuals;
d. Volume of residuals distributed to each recipient;
e. Intended use of residuals;
f. If land application events performed by the Permittee-Nitrogen Application Rate based on RYEs
(if using data obtained from the North Carolina State University Department of Soil Science
Website,the printout page shall be kept on file and reprinted every five years).
[15A NCAC 02T.0108(a)]
WQ0002127 Version 4.0 Shell Version 170401 Page 8 of 10

7. Three copies of an annual report shall be submitted on or before March 1 s'. The annual report shall
meet the requirements described in the Instructions for Residuals Application Annual Reporting Forms.
Instructions for reporting and annual report forms are available at
http://deq.nc.gov/about/divis ions/water-resources/water-resources-perm its/wastewater-branch/non-
discharge-permitting-unit/reporting-forms, or can be obtained by contacting the Non-Discharge
Permitting Unit directly. The annual report shall be submitted to the following address:
Division of Water Resources
Information Processing Unit
1617 Mail Service Center
Raleigh,North Carolina 27699-1617
[15A NCAC 02T.1111(a)]
8. Noncompliance Notification
The Permittee shall report by telephone to the Asheville Regional Office,telephone number(828)296-
4500,as soon as possible,but in no case more than 24 hours or on the next working day following the
occurrence or first knowledge of the occurrence of any of the following:
a. Distribution of residuals abnormal in quantity or characteristic.
b. Any failure of the distribution program resulting in a release of material to surface waters.
c. Any time self-monitoring indicates the facility has gone out of compliance with its permit
limitations.
d. Any process unit failure, due to known or unknown reasons, rendering the facility incapable of
adequate residual treatment.
e. Any spill or discharge from a vehicle or piping system during residuals transportation.
Any emergency requiring immediate reporting(e.g., discharges to surface waters, imminent failure of
a storage structure, etc.)outside normal business hours shall be reported to the Division's Emergency
Response personnel at telephone number(800)662-7956,[phone], or(919)733-3300.Persons
reporting such occurrences by telephone shall also file a written report in letter form within five days
following first knowledge of the occurrence. This report shall outline the actions taken or proposed to
be taken to ensure that the problem does not recur. [15A NCAC 02T.0105(1), 02T .0108(b)(l)]
V. INSPECTIONS
1. The Permittee shall provide adequate inspection and maintenance to ensure proper operation of the
subject facilities and shall be in accordance with the approved O&M Plan. [15A NCAC 02T.0108(b)]
2. Prior to each bulk residuals distribution event,the Permittee or his designee shall inspect the residuals
processing, storage, transport and distribution facilities to identify malfunctions, facility deterioration
and operator errors that could result in discharges to the environment, a threat to human health or a
public nuisance. The Permittee shall maintain an inspection log that includes, at a minimum, the date
and time of inspection, observations made, and any maintenance, repairs, or corrective actions taken.
The Permittee shall maintain this inspection log for a period of five years from the date of inspection,
and this log shall be made available to the Division upon request. [15A NCAC 02T .0108(b)]
3. Any duly authorized Division representative may, upon presentation of credentials, enter and inspect
any property, premises or place on or related to the distribution sites or facilities permitted herein at
any reasonable time for the purpose of determining compliance with this permit; may inspect or copy
any records required to be maintained under the terms and conditions of this permit; and may collect
groundwater,surface water or leachate samples. [G.S. 143-215.3(a)(2)]
WQ0002127 Version 4.0 Shell Version 170401 Page 9 of 10

VI. GENERAL CONDITIONS
1. Failure to comply with the conditions and limitations contained herein may subject the Permittee to an
enforcement action by the Division in accordance with North Carolina General Statutes 143-215.6A to
143-215.6C. [G.S. 143-215.6A to 143-215.6C]
2. This permit shall become voidable if the residuals distribution events are not carried out in accordance
with the conditions of this permit. [15A NCAC 02T.0110]
3. This permit is effective only with respect to the nature and volume of residuals described in the permit
application and other supporting documentation. [G.S. 143-215.1]
4. The issuance of this permit does not exempt the Permittee from complying with any and all statutes,
rules, regulations, or ordinances, which may be imposed by other jurisdictional government agencies
(e.g.,local,state, and federal). Of particular concern to the Division are applicable river buffer rules in
15A NCAC 02B .0200; erosion and sedimentation control requirements in 15A NCAC Chapter 4 and
under the Division's General Permit NCG010000;any requirements pertaining to wetlands under 15A
NCAC 02B .0200 and 02H.0500;and documentation of compliance with Article 21 Part 6 of Chapter
143 of the General Statutes. [15A NCAC 02T.0105(c)(6)]
5. In the event the residuals program changes ownership or the Permittee changes his name, a formal
permit modification request shall be submitted to the Division. This request shall be made on official
Division forms, and shall include appropriate documentation from the parties involved and other
supporting documentation as necessary. The Permittee of record shall remain fully responsible for
maintaining and operating the residuals program permitted herein until a permit is issued to the new
owner. [15A NCAC 02T .0104]
6. This permit is subject to revocation or unilateral modification upon 60-day notice from the Division
Director,in whole or part for the requirements listed in 15A NCAC 02T.0110. [15A NCAC 02T.0110]
7. Unless the Division Director grants a variance,expansion of the permitted residuals program contained
herein shall not be granted if the Permittee exemplifies any of the criteria in 15A NCAC 02T.0120(b).
[15A NCAC 02T .0120]
8. The Permittee shall pay the annual fee within 30 days after being billed by the Division. Failure to pay
the annual fee accordingly shall be cause for the Division to revoke this permit. [15A NCAC 02T
.0105(e)(3)]
Permit issued this the 23`d day of August 2017
NORTH CAROLINA ENVIRONMENTAL MANAGEMENT COMMISSION
FS.Jay Zimmerman, P.G.,Director
Division of Water Resources
By Authority of the Environmental Management Commission
Permit Number WQ0002127
WQ0002127 Version 4.0 Shell Version 170401 Page 10 of 10

ATTACHIVMENT A-Approved Residual Sources Certification Date: August 23,2017
City of Morganton Permit Number: WQ0002127 Version: 4.0
Residuals Source-Generating Facility
Maximum
Owner Facility County Permit Biological Dry Torts Monitoring Frequency for Non- Monitoring Frequency for Metals
Number Residuals per Year 1 hazardous Determination 2 and Nutrients 2
City of Morganton Catawba River Pollution Burke NC0026573 Yes 1,400 Once per permit cycle Once per permit cycle
Control Facility
Total 1,400
Class A Residuals
Product Generated for Distribution
Monitoring Monitoring Monitoring
Permit Biological Maximum Frequency for Frequency for Frequency for Approved
Owner Facility Name County Number Residuals Dry Tons Non-hazardous Metals and Pathogen& Mineralization
Per Year I Determination 2 Nutrients 3 Vector Attraction Rate
Reductions'
City of Morganton Residuals Composting Burke WQ0002127 Yes 3,250 Once per permit See Table Below See Table Below 0.1
Facility _ cycle
1. Maximum Dry Tons per Year for residuals source is the amount of residuals approved for composting. Maximum Dry Tons per Year for Class A residuals is the amount of residuals product
approved for distribution from the permitted facility.
2. Analyses to demonstrate that residuals are non-hazardous(i.e.,TCLP,ignitability,reactivity,and corrosivity)as stipulated under permit Condition 1V.2.
3. Testing of metals and nutrients as stipulated under permit Condition IV.3.
4. Analyses of pathogen and vector attraction reductions as stipulated under permit Condition 1V.4.
5. Monitoring frequencies are based on the actual dry tons applied per year using the table below,unless specified above.
Dry Tons Distributed Monitoring Frequency
(short tons per year) (Established in 40 CFR 503 and 15A NCAC 02T.1111)
<319 1/Year
=>319-<1,650 1/Quarter(4 times per year)
>1,650-<16,500 1/60 Days(6 times per year)
=>16,500 1/month(12 times per year)
WQ000887 Version 4.0 Attachment A Page 1 of 1

CLASS A ANNUAL DISTRIBUTION AND MARKETING/ SURFACE DISPOSAL CERTIFICATION AND SUMMARY FORM
WQ PERMIT#: WQ0002127 FACILITY NAME: Catawba River Pollution Control Facility
PHONE: [phone] COUNTY: Burke OPERATOR: Eli Self
FACILITY TYPE(please check one): ❑ Surface Disposal(complete Part A(Source(s)and "Residual In" Volume only)and Part C)
0 Distribution and Marketing(complete Parts A,B,and C)
Was the facility in operation during the past calendar year? Yes 0 No ❑ —P. If No skip parts A, B,C and certify form below
Part A*: Part B*:
Volume(dry tons) Recipient Information
Sources(s)(include NPDES# if
Month applicable) Amendment/ Residual In Product Out Name(s) Volume(dry tons) Intended use(s)
Bulking Agent
January NC0026573 204 70 24 See Attached Sheet 151 Attched Sheets
February NC0026573 192 68 33 See Attached Sheet 71 Attched Sheets
March NC0026573 267 89 44 See Attached Sheet 99 Attched Sheets
April NC0026573 231 77 91 See Attached Sheet 57 Attched Sheets
May NC0026573 406 135 115 See Attached Sheet 121 Attched Sheets
June NC0026573 163 54 55 See Attached Sheet 41 Attched Sheets
July NC0026573 223 74 48 See Attached Sheet 0 Attched Sheets
August NC0026573 373 122 86 See Attached Sheet 9 Attched Sheets
September NC0026573 193 61 50 See Attached Sheet 197 Attched Sheets
October NC0026573 349 116 76 See Attached Sheet 0 Attched Sheets
November NC0026573 276 88 63 See Attached Sheet 143 Attched Sheets
December NC0026573 319 107 71 See Attached Sheet 5 Attched Sheets
Total from FORM DMSDF(sup) ....
Totals: Annual(dry tons): 3196 1061 756 894
Amendment(s)used: Bulking Agent(s)used: Wood Chips
* If more space is required, attach additional information sheets(FORM DMSDF(supp)): Total Number of Form DMSDF(Supp)
Part C:
Facility was compliant during the past calendar year with all conditions of the land application permit 0 Yes
(including but not limited to items 1-3 below) issued by the Division of Water Resources: ❑ No - - If No, Explain in Narritive
1. All monitoring was done in accordance with the permit and reported for the year as required and three(3)copies of certified laboratory results are attached.
2. All operation and maintenance requirements were compiled with or, in the case of a deviation,prior authorization was received from the Division of Water Resources.
3. No contravention of Ground Water Quality Standards occurred at a monitoring well.
"I certify, under penalty of law,that the above information is,to the best of my knowledge and belief,true,accurate and complete. I am aware that there are significant
penalties for submitting false information,including the possibility of fines and imprisonment for knowing violations."
Signature of Permittee Date Signature of Preparer** Date
(if different from Permittee)
**Preparer is defined in 40 CFR Part 503.9(r)and 15A NCAC 2T .1102 (26)
DENR FORM DMSDF (12/2006)

ANNUAL RESIDUAL SAMPLING SUMMARY FORM
Please note that your permit may contain additional parameters to be analyzed. The parameters can be reported in FORM RSSF- B
WQ Permit Number: WQ0002127 Laboratory: 1) Statesville Analytical
Facility Name: Catawba River Pollution Control Facility 2) Water Tech Labs
Residual Source WQ#or NC0026573 3)
NPDES#: 4)
WWTP Name: Catawba River Pollution Control Facility 5)
Residual Analysis Data
Conc. Sample or Composite Date
Parameter Limit
(mg/kg) (mgg)a 1/31/19 3/18/19 4/18/19 7/09/19 10/07/19 12/09/19
Percent Solids (%) NA 55 62 66 70 74 67
Arsenic 75 0.391 0.31 0.066 <1.42 <0.673
Cadmium 85 0.858 2.19 0.615 5.85 0.405 0.42
Copper 4,300 56.27 31.6 48.16 337 92.6 226
Chromium NA
Lead 840 4.46 11.33 153.5 16.2 11.5 10.72
Mercury 57 0.023 0.11 0.062 0.498 0.002 0.157
Molybdenum 75 6.57 4.47 1.46 8.73 11.9 6.03
Nickel 420 7.987 2.01 8.92 30.4 18.2 10.9
Selenium 100 0.503 <0.01 <0.016 <1.42 <0.666 <0.673
Zinc 7,500 636.96 796 386 663 747 837
Total Phosphorus NA 5280 2476 5380 2540 397 777.8
TKN NA 38608 35652 38810 37600 40320 350
Ammonia-Nitrogen NA 10202 14405 12405 17700 80 4448
Nitrate and Nitrite NA 35 157.56 107.96 23.4 35.9 48.6
a For surface disposal facilities the ceiling concentration limits listed in this form are not applicable. Reference the individual permit for metals limits.
"I certify, under penalty of law, that this document was prepared under my direction or supervision in accordance with a system designed
to assure that qualified personnel properly gathered and evaluated the information submitted. I am aware that there are significant
penalties for submitting false information, including the possibility of fines and imprisonment for knowing violations."
Signature of Preparer * Date
*Preparer is defined in 40 CFR Part 503.9(r)and 15A NCAC 2T.1102(26)
DENR FORM RSSF (12/2006)

ANNUAL RESIDUAL SAMPLING SUMMARY FORM - B
Report all sampling analysis results for parameters not listed in FORM RSSF that are part of the WQ permit or were analyzed for over the past
calendar year. Use additional forms as needed.
WQ Permit Number: WQ0002127 Laboratory: 1) Statesville Analytical
Facility Name: Catawba River Pollution Control Facility 2) Water Tech Labs
Residual Source NC0026573 3)
NPDES#or WQ#: 4)
WWTP Name: Catawba River Pollution Control Facility 5)
Residual Analysis Data
Sample or Composite Date
Parameter
(mg/kg) 1/09/19 1/31/19 2/04/19 2/21/19 3/18/19 4/18/19 5/09/19 7/09/19 7/22/19 10/07/19 10/21/19 12/09/19
Aluminum 43714 24400 2630 23320 3229.5 23000
Calcium 8348 11300 5790 8720 2280 1030
pH 6.37 7.4 7.14 6.86 7.44 6.99
Patassium 2340 2460 1950 261 2100 2190
Sodium 100 707 552 628 452 997.2
Fecal Coliform (MPN/g) <40 380 <47.6 <39 3598 <33 <30 <27 <30
Fecal Coliform (MPN/g) <32 417 <47.6 <41 15101 <32 <27 <27 <32
Fecal Coliform (MPN/g) <38 426 <38 <37 33 <33 <30 <27 >23529
Fecal Coliform (MPN/g) <38 <52 <34 <33 <29 <27
Fecal Coliform (MPN/g) <38 <46.9 <32 <52 <29
Fecal Coliform (MPN/g) <43 <47.6 <31 <58 <33
Fecal Coliform (MPN/g) <44 <43.3 <33 <43 <30
"I certify, under penalty of law, that this document was prepared under my direction or supervision in accordance with a system
designed to assure that qualified personnel properly gathered and evaluated the information submitted. I am aware that there are
significant penalties for submitting false information, including the possibility of fines and imprisonment for knowing violations."
Signature of Preparer* Date
*Preparer is defined in 40 CFR Part 503.9(r)and 15A NCAC 2T .1102 (26)
DENR FORM RSSF - B (12/2006)

ANNUAL RESIDUAL SAMPLING SUMMARY FORM - B
Report all sampling analysis results for parameters not listed in FORM RSSF that are part of the WQ permit or were analyzed for over the past
calendar year. Use additional forms as needed.
WQ Permit Number: WQ0002127 Laboratory: 1) Statesville Analytical
Facility Name: Catawba River Pollution Control Facility 2) Water Tech Labs
Residual Source NC0026573 3)
NPDES# or WQ#: 4)
WWTP Name: Catawba River Pollution Control Facility 5)
Residual Analysis Data
Sample or Composite Date
Parameter
(mg/kg) 12/13/19
Aluminum
Calcium
PH
Patassium
Sodium
Fecal Coliform (MPN/g)
•
Fecal Coliform (MPN/g)
•
•
Fecal Coliform (MPN/g)
Fecal Coliform (MPN/g) <20 _
Fecal Coliform (MPN/g) <20
Fecal Coliform (MPN/g) <20
Fecal Coliform (MPN/g)
•
"I certify, under penalty of law, that this document was prepared under my direction or supervision in accordance with a system
designed to assure that qualified personnel properly gathered and evaluated the information submitted. I am aware that there are
significant penalties for submitting false information, including the possibility of fines and imprisonment for knowing violations."
Signature of Preparer* Date
*Preparer is defined in 40 CFR Part 503.9(r)and 15A NCAC 2T .1102 (26)
DENR FORM RSSF - B (12/2006)

ANNUAL PATHOGEN AND VECTOR ATTRACTION REDUCTION FORM (02T Rules)
Facility Name: Catawba River Pollution Control Facility WQ Permit Number: W00002127
WWTP Name: Catawba River Pollution Control Facility NPDES Number: NC0026573
Monitoring Period: From 1/1/2019 To 12/31/2019
Pathogen Reduction (15A NCAC 02T .1106) - Please indicate level achieved and alternative performed:
Class A: Alt. A (time/temp) ❑ Alt B (Alk Treatment)❑ Alt. C (Prior Testing)❑
AIt.D (No Prior Test) ❑ Process to Further Reduce Pathogengs El
If applicable to alternative performed (Class A only) indicate"Process to Further Reduce Pathogens":
Compost In Heat Drying ❑ Heat Treatment ❑ Therinophilic ❑�::::
Beta Ray ❑ Gamma Ray ❑ Pasteurization ❑
Class B: Alt. (1)Fecal Density ❑ Alt. (2) Process to Significantly Reduce Pathogens ❑
If applicable to alternative performed (Class B only) indicate"Process to Significantly Reduce Pathogens":
Lime Stabilization ❑ Air Drying ❑ Composting ❑ Aerobic Digestion ❑
Anaerobic Digestion ❑
If applicable to alternative performed (Class A or Class B) complete the following monitoring data:
Allowable Level Pathogen DensityNumber o Analytical
Parameter gExcee- Frequency Sample Tech-
in Sludge Minimum Geo. Mean Maximum Units dences of Analysis Type niaue
2 x 10 to the MPN
6th power
per gram of CFU
Fecal Coliform total solids
1000 mpn per gram
of total solid (dry <2O >23529 MPN/g 3 Quarterly Grab sm221ce
weight)
Salmonella bacteria 3 MPN per 4 grams
(in lieu of fecal total solid(dry
coliform) weight)
Vector Attraction Reduction (15A NCAC 02T .1107) - Please indicate alternative performed:
Alt.1 (VS reduction) ❑ Alt. 2(40-day bench) ❑ Alt. 3 (30-day bench) ❑ Alt. 4(Spec. 02 uptake) C7
Alt. 5 (14-Day Aerobic) n Alt. 6 (Alk. Stabilization ❑ Alt 7(Drying- Stable) ❑ Alt. 8 (Drying-Unstable) ❑
Alt. 9(Injection) ❑ Alt. 10(Incorporation) ❑_No vector attraction reduction alternatives were performed ❑
CERTIFICATION STATEMENT (please check the appropriate statement)
El "I certify, under penalty of law, that the pathogen requirements in 15A NCAC 02T .1106 and the
vector attraction reduction requirement in 15A NCAC 02T .1107 have been met."
❑ "I certify, under penalty of law,that the pathogen requirements in 15A NCAC 02T .1106 and the
vector attraction reduction requirement in 15A NCAC 02T .1107 have not been met." (Please note
if you check this statement attach an explanation why you have not met one or both of the
requirements.)
"This determination has been made under my direction and supervision in accordance with the system
designed to ensure that qualified personnel properly gather and evaluate the information used to determine
that the pathogen and vector attraction reduction requirements have been met. I am aware that there are
significant penalties for false certification including fine and imprisonment."
Eli Self- ORC
Preparer Name and Title (type or print) Land Applier Name and Title (if applicable)(type or print)
Signature of Preparer* Date Signature of Land Applier(if applicable) Date
*Preparer is defined in 40 CFR Part 503.9(r)and 15A NCAC 2T.1102(26)
DENR FORM PVRF 02T (12/2006)