HomeMy WebLinkAboutNC0028916_Headworks Analysis_20190208 MAYOR
SHERRI HARRIS ALLGOOD TOWN
REGnZE HGR ER
MAYOR PRO-TEM LT R Y
BRUCE HAMILTON TOWN CLERK
COMMISSIONERS NORTH CATHY MANESS
KAYREN BRANTLEY CAROLINA ATTORNEY
ANGELA ELKINS RUSSELL J. HOLLERS. III
WALLACE JONES
DAMON PRINCE
February 8. 2019
Monti Hassan
PERCS Unit
NC DEQ
1617 Mail Service Center
Raleigh, NC 27699-1617
Mr. Hassan,
Please find enclosed the Town of Troy NC HWA with supporting documentation. Troy currently has 2 SIU's. Uwharrie
Environmental, and Wright Foods. I hope you find the HWA analysis sufficient. If you have any concerns or questions
please contact me using my contact info provided.
Thank You,
Bryan Bowles
Town of Troy WW ORC
Email: troywwtp650(a�yahoo.com
Cell:704-796-6045 RECEIVED/DENR/pWR
FEB 12 2019
Water Resources
Permitting Section
TROY.NC.US 315 N MAIN STREET TROY, NC 27371 910-572-3661
THE TOWN OF TROY IS AN EQUAL OPPORTUNITY PROVIDER AND EMPLOYER.
2019 HWA Narrative: Town of Troy
HWA Data Time Period:
All samples were taken from Jan2018-Dec2018. SIU samples for BOD TSS and
Ammonia were taken weekly. All other parameters were sampled quarterly. Influent data
was pulled from DMR based on NPDES sampling requirements.
WWTP Design Criteria:
BOD and TSS were the only parameters using Design criteria in the HWA.
Removal Rate Calculations:
STMP data for low level mercury were used in RR calculations. Influent data was pulled
from DMR. All other POC's used influent and effluent STMP data.
Inhibition Calculations: Silver has a negative MAIL. This may be due to the fact that all
Influent and Effluent samples were BDL for the time frame chosen.
I used the more restrictive summer NPDES limit of 1.1mg/L for Ammonia in the pass -
thru calculations.
Workbook Name: Troy.HWA.AT.2018; Worksheet Name: HWA Page 1 of Ay�
y Printed 2/8/2019,9:35 AM
A I B I C I D L_ E I F _I G I H I I I J i K
1 HcadworksAnalysisSpreadsheet Spreadsheet Instructions: lVED�DEN2019
RIDWR
2 POTW Name: . q 1) Applicable Values should be entered in the Heavy Bordered Blue cells. The rest of workhttet
3 Date: protected,password is"2". �� I
4 POTW NPDES#_> N00002891• 2) Additional pollutants can be added in cells A34 to A42. Note all Pollutant names are linked from
5 POTW Sludge Permit#=> W000012 here to other pages in HWA worksheet and also to AT worksheet(i.e.,automatically entered into
other pages in HWA worksheet and also AT worksheet from HWA worksheet).
7 POTW NPDES Permitted Flow(MGD)= 1.2 <=usadInAT only 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter. N ater Resources
8 POTW AverageFlow(MGD)= 0.56 <=ussdin HWA calwlatlons 4) HWA,AT and HASL worksheets are linked. MAHL5,Basis,and Uncontrollable load are permitting Section
automatically entered into AT from this worksheet.
9 Uncontrollable Flow(MGD)= 0.395 5)If red tab notes are not visible,they can be turned on in the"Tools"menu under"options",in the
10 7Q10 Stream Flow(MGD)= 0.23 "view"tab click the"comment Indicator only"button.
11 Stream Classification= C
13 Class of Sludge generated(A,or B) 1
14 SludgetoDigestorFlow(MGD)= Through calc.for differentPOTW use Des n
15 SI to Di Flow MGD= flows g
� � ( ) Criteria
16 %Solids to Disposal= Design Values Average Flow Permitted Flow Loading
17 Sludge SiteAree(acres)= WWTF Influent BOD(mg/1) 300 437.5 204.2 x
18 Sludge Ste Life(yrs)= WWTF Influent TSS(mg/1) 300 2500.0 1166.7 x
19 Age of Sludge Site(yrs)= WWTF Influent NH3(mg/I) 40 183.3 85.6
20 WWTF Influent Total N(mg/I)
21 Pass-Through Loading Calculations WWTF Influent Total P(mg/1)
Stream Standard Pass•Thru Minimum
NPDESLIMIT Plant Removal Removal rate NPDESLoading Standard Stream Loading DeagnCriteria Loading Pa.Thru
23 Pollutant (mgrl) Rate(%) Source (Ibs/day) (mg/1) Standard Source (Ibaday) Loading(Ibs'day) (Ibs'day) Basis
24 BOD 7 98.4 site'specific 2,043 3,002 3,002 Design
25 TSS 30 98.8 site'specific 11,676 3,002 3,002 Design
26 Ammonia 1.1 r 99.4 site'specific 856 400 856 NPDES
II
27 Arsenic 45 lit/default 0.05 NC-WQS 0.5990 0.5990 Stream Std
28 Cadmium ` 67 lit/default 0.002 NC-WQS 0.0399 0.0399 Stream Std
29 Chromium 68.2 site,specific 0.05 NC-WQS I 1.0359 1.0.-TP Stream Std
30 Copper 81.6 site/specific r 0.04AL POC 0.2507 0.2507 Stream Std
31 Cyanide 69 lit/default 0.005 NC-WQS 0.1063 0.1063 Stream Std
32 Leed 61 lit/default 0.025 NC-WQS 0.4223 0.4223 Stream Std
33 Mercury - 97.8 Ste'specific 0.000012`NC-WQS 0.0036 0.00359 Streem Std
34 Molybdenum 33 lit/default
35 Nickel 52.1 site/specific 0.08,NNC-WQS 1.2104 1.2104 Stream Std
36 Selenium .5, 50 lit/default 0.005 NC-WQS 0.0659 0.0659 Stream Std
37 Silver 75 lit/default 0.00006 NC-WQS 0.0016 0.0016 Stream Std
38 Zinc 83.1 �site'specific L POC
39 Total Nitrogen
40 Total Phos.
41 c
42 d
I 1 I
43 e
44f
45 - A
46 h
47 1
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008
Workbook Name: Tro HWA.AT.2018; Worksheet Name: HWA Page 2 of 12
Y• Printed 2/8/2019,9:35 AM
A I B I C I D I E I F I G I H I I I J I K
49 Average Influent NH3(VI)
50 Average Anaerobic Digester NH3(mg/I)
51 Inhibition Loading Calculations only enter when ha✓e A NA EROBI C digester
A.S./Nit,/T.F. A.SJNItJT.F. A.S/NItJT.F. Dlgeeor Minimum Minimum
Primary Primary Inhibition Inhibition Inhibition Inhibition Digester Inhibition Inhibition
Renal Rate Renaval Rate Concentration Conoettration Loading Concentration Inhibition Digester Inhibition Loading Loading
52 Pollutant (%) Source (myl) Source (Ibe'day) (m04) Conc.Source Loading(Ibs/day) (IbWday) Source
53 BOD
54 TSS
55 Ammonia 480JLIT-AS 2241.7920 2241.79 ASINit/TF it
56 Arsenic 0.1 LIT-AS 0.4670 0.4670 AS/Nit/TFir
57 Cadmium 1 LIT-AS 4.6704 4.6704 AS/Nit/TF ir
58 Chromium 1 LIT-AS 4.6704 4.6704 AS/Nit/TF ir
59 Copper 1 LIT-AS 4.6704 * 4.6704 AS'Nit/TFir
60 Cyanide 0.1 LIT-AS 0.4670 0.4670 ASlNit/TF ir
61 Lead 1 LIT-AS 4.6704 _♦ 4.6704 AS/Nit/TF it
62 Mercury 0.1 LIT-AS 0.4670 0.4670 ASINit/TF ir
63 Molybdenum
64 Nickel 1�LIT-AS 4.6704 4.6704 AS/NitITF ir
,65 Selenium
66 Silver 0.25 LIT-AS 1.1676 1.1676 AS/Nit/TF ir
67 Zinc 1 LIT-AS 4.6704 4.6704 AS/Nit/IF ir
68 Total Nitrogen
69 Total Phos
70 C
S
71 d _
72 e
_73 f _
74 g
75 h
76 I
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008
Workbook Name: Troy.HWA.AT.2018; Worksheet Name: HWA Page 3 of 12
Y• � Printed 2/8/2019,9:35 AM
A I B I C I D I E I F I G I H 1 I I J I K
77
78 Sludge Loading Calculations
SludgeCeiling ClassA Limits ClassA Limits ClassA Limits Minimum Minimum
SudgeCeling SludgeCaling Load Cumulative Sludge Cumulative Monthly Monthly Avg. Mon.Avg.Load. - Sludge Sludge
Concentration Load -HASLCatc.- Rate Limit Sludge Loading Average Rate Loading HAS_Calc- Loading Loading
79 Pdlutant Limit(mg/kg) (Ibs/day) (Ibs'day) (Ibs'(acr et'Iife)) (Ibs'day) Limit(mg/kg) (lbs/day) (lbs/day) (lbs/day) Sorce
80 BOD
81 TSS
82 Ammonia
83 Arsenic 75 36 41 No Criteria
84 Cadmium 85 34 39 No Criteria
85 Chromium
86 Copper 4300 1338 1500 No Criteria
87 Cyanide
88 Lead 840 267 300 No Criteria
89 Mercury 57 15 17 No Criteria
90 Molybdenum 75 No Criteria
91 Nickel 420 374 420 No Criteria
92 Selenium 100 89 100 No Criteria
93 Silver _
94 Zinc 7500 2498 2800 No Criteria
95 Total Nitrogen
96 Total Phos.
97 c
98 d
99 e
100 f
101 q
102 h
1031
104
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008
Workbook Name: Tro HWA.AT.2018; Worksheet Name: HWA Page 4 of 12
Y• Printed 2/8/2019.9:35 AM
A B I C I D E F 1 G 1 H I I J 1 K
105 Maximum Allowable Headworks Loading Calculations
Minimum Pass Minimum Minimum Minimum Minimum Allowable Maximum Allowable
Through Loading PassThrough Inhibition Loading Inhibition Loading SludgeLoading Sudgeloading Heedworks HeadworksLoading
106 (Ibs/day) Source (lbsday) Source (Ibs/day) Sorce Loading(Ibs/day) Source
107 BOD 3002.4 Design 3002.4 Design
108 TSS 3002.4 Design 3002.4 Design
109 Ammonia 856.0 NPDES 2241.7920 AS/Nit/TF inhibiti 2241.8 AS/Nit/TF inhibition
110 Arsenic 0.5990 Stream Std 0.4670 AS/Nit/IF inhibiti 0.4670 AS/Nit/TF inhibition
111 Cadmium 0.0399 Stream Std 4.6704 AS/Nit/TF inhibiti 0.0399 Stream Std
112 Chromium 1.0359 Stream Std 4.6704 AS/Nit/TF inhibiti 1.0359 Stream Std
113 Copper 0.2507 Stream Std 4.6704 AS/Nit/TF inhibiti 0.2507 Stream Std
114,Cyanide 0.1063 Stream Std 0.4670 AS/Nit/TF inhibiti 0.1063 Stream Std
115 Lead 0.4223 Stream Std 4.6704 AS/Nit/TF inhibiti 0.4223 Stream Std
116 Mercury 0.00359 Stream Std 0.4670 AS/Nit/TF inhibiti 0.00359 Stream Std
117 Molybdenum
118 Nickel 1.2104 Stream Std 4.6704 AS/Nit/TF inhibiti 1.2104 Stream Std
119 Selenium 0.0659 Stream Std 0.0659 Stream Std
120 Silver 0.0016 Stream Std 1.1676 AS/Nit/TF inhibiti 0.0016 Stream Std
121 Zinc 4.6704 AS/Nit/TF inhibiti 4.6704 AS/Nit/TF inhibition
122 Total Nitrogen
123 Total Phos.
124 c
125 d
126 e
127 f
128 q
129 h
130 I
131
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008
Page 5 of 12
Workbook Name: Troy.HWA.AT.2018; Worksheet Name: HWA Printed 2/8/2019,9:35 AM
A I B I C I D I E I F I G I H I I I J I K
132
133 Maximum Allowable industrial LoedingsCalculations
M axlmUm M Ma MUM
Allowable Chedt to Use Uncontrollable Allowable
Heedworks Loading HA&Calcs Concentration Uncontrollable Uncontrollable Indugrid psalm vs.Pass-
134 Pollutant (ibdday) MAHL Bads (x) (VD Source Loed(ibdday) Load(Iba'day) Thru Warning
135 BOD 3002.4000 Design 266'MASS BALAN.-
876.2838 2126.1162
136 TSS 3002.4000 Design ' 190rMASSBALAN 625.9170 2376.4830
137 Ammonia 2241.7900 ASfNit/TF inhibition 32.9 MASSBALAF1 108.3825 2133.4075
138 Arsenic 0.4670 AS/Nit/TF inhibition 0.003\MASSBALAt\ 0.0109 0.4562 1
139 Cadmium 0.0399 Stream Std -r-_ 0.001 MASS BALM:: 0.0033 0.0366
140 Chromium 1.0359 Stream Std N/A 0. LITERATURE 0.1647 0.8712
141 Copper 0.2507 Stream Std ` i 0.050 MASS BALAN 0.1654 0.0853
it
142 Cyanide 0.1063 Stream Std N/A 0.001 MASS BALAN 0.0059 0.1003
143 Lead 0.4223 Stream Std ... 0.049 LITERATURE 0.1614 0.2609
144 Mercury 0.00359 StreamStd _ 0.00033MASSBALAN 0.00099 0.00261
145 Molybdenum 0.0027't ITERATURE 0.0089
146 Nickel 1.2104 StreamStd 0.0214 MASSBALAN 0.0705 1.1399
147 Selenium 0.0659 Stream Std
148 Silva 0.0016 Stream Std N/A 0.0026 MASS BALAN 0.0086 -0.0070
149 Zinc 4.6704 AS/Nit/IF inhibition 0.0103 MASS BALAN 0.0339 4.62 5
150 Total Nitrogen
151 Total Phos.
152 c _
153 d
154 e
155f
156 g _
A
157 h
158 1
Modeled after:Chapter 5-HWA Guidance,Appendix 5-A
Revision Date: February 2008
Workbook Name : Troy.HWA.AT.2014.Approved (1)2018DRAFT, Worksheet Name: Arrinted: 2/7/2019, 10:36 AM
Page 1 of 6
Allocation Table Spreadsheet Instructions:
Headworks last approved: 04/11/14 t)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is protected,password is
Allocation Table updated: 02/07/19 2)Formulas are discussed in the Comprehensive Guidance,Chapter 6,Section C.
Permits last modified: 12/01/16 3)HWA and AT worksheets in this workbook are linked. Pollutant Names,MAHLs,Basis,and Uncontrollable load
in this AT worksheet are automatically entered from the HWA spreadsheet. This includes pollutant names in
columns AT through BK.
POTw=> Town of Troy
NPDES > NC00028916
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 liet,lyh.buiey) number number Industry Date Date Expires MGD al/da m /I Ibs/da m /I lbs/da
1 right Foods 0003 0001 Food 08/01/18 03/01/15 08/01/23 0.1250 125,000 600.00 625.50 300.00 312.75
2 Uwharrie Environmental 0004 0001 Leachate 12/01/16 12/20/2017 11/30/21 0.0200 20,000 2400.00 400.32 300.00 50.04
3
4
5
6
7
1 , _.-.,
8
9 T
10 --�
Column Totals=> 0.1450 145,000 1 1026 I 363
Basis=> NPDES Design Design
MAHL from HWA(lbs/day)_> NPDES Permitted Flow=> 1.2000 3002 3002
Uncontrollable Loading(lbs/day)_> 0.3950 876 626
Total Allowable for Industry(MAIL)(lbs/day)=> 0.8050 2126 2376
Total Permitted to Industry(lbs/day)_> 0.1450 1026 363
MAIL left(lbs/day)=> 0.6600 1100 2014
Percent Allow.Ind.(MAIL)still available(%)=> 82.0% 51.8% 84.7%
Percent MAHL still available(%)=> 55.0% 36.6% 67.1%
5 Percent MAHL(lbs/day)_> 0.0600 150 150
HWA.AT
Revised:November 2005
Workbook Name : Troy.HWA.AT.2014.Approved (1)2018DRAFT, Worksheet Name: ATPrinted: 2/7/2019, 10:36AM
Page 2 of 6
Allocation Table
Headworks last approved: 04/11/14
Allocation Table updated: 02/07/19
Permits last modified: 12/01/16
Pores=> Town of Troy
NPDESA > NC00028916
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 J (please liaalphabeticly) number number mg/1 lbs/day mg/I lbs/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 Wright Foods 0003 0001 _
2 Uwharrie Environmental 0004 0001 750.00 125.10
~��
4 �.......
8
9
10 i ,--~ V--... ---i
Column Totals=> 125 0.0000 1 0.0000 0.0000 0.0000 0.0000
AS/Nit/TF AS/Nit/TF Stream Stream Stream Stream
Basis=> inhibition inhibition Std Std Std Std
MAHL from HWA(lbs/day)=> 2241.79 0,4670 0.0399 1.0359 0.2507 0.1063
Uncontrollable Loading(lbs/day)=> 108.38 0,0109 0.0033 0.1647 0.1654 0.0059
Total Allowable for Industry(MAIL)(lbs/day)=> 2133.41 0,4562 0.0366 0.8712 0.0853 0.1003
Total Permitted to Industry(lbs/day)=> 125.10 0,0000 0.0000 0.0000 0.0000 0.0000
MAIL left(lbs/day)=> 2008.31 0,4562 0.0366 0.8712 0.0853 0.1003
Percent Allow.Ind.(MAIL)still available(%)=> 94.1 % 100.0% 100.0% 100.0°% 100.0% 100.0%
Percent MAHL still available(%)=> 89.6% 97.7% 91.8% 84.1% 34.0% 94.4
5 Percent MAHL(lbs/day)=> 112.09 0.0234 0.0020 0.0518 0.0125 0 0053
HWA.AT
Revised:November 2005
Workbook Name : Troy.HWA.AT.2014.Approved (1)2018DRAFT, Worksheet Name: ATPrinted: 2/7/2019, 10:36AM
Page 3 of 6
Allocation Table
Headworks last approved: 04/11/14
Allocation Table updated: 02/07/19
Permits last modified: 12/01/16
POTW=> Town of Troy
NPDES#=> NC00028916
Lead Mercury Molybdenum Nickel Selenium Sit
Industry Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits Permit
IUP INDUSTRY NAMES Permit Pipe Conc. Load Conc. Load Conc. Load Conc. Load Conc. Load Conc.
Count (please listalphabeticty) number I number mg/I 1bs/day mg/I lbs/day mg/I lbs/day mg/1 lbs/day mg/I lbs/day mg/1
1 Wright Foods 0003 0001 ' ..
2 Uwharrie Environmental 0004 0001
3 I �a�.
4 Imo- .ram !�-
5 .�...+ i.�.�. INIIIMMINIMMIN
6 .�. ���
7 4 po�.m r� raaaaaome
8 a..�,
I 1 ,... .......wk--. ......+______. n....
10
Column Totals=> 0.0000 1 0.000000 0.0000 0.0000 0.0000
Stream Stream Stream
Basis=> Std Stream Std Std Std
MAHL from HWA(lbs/day)=> 0.4223 0.003594 1.2104 0.0659
Uncontrollable Loading(lbs/day)_> 0.1614 0.000988 0.0089 0.0705
Total Allowable for Industry(MAIL)(lbs/day)=> 0.2609 0.002605 1.1399 #######
Total Permitted to Industry(lbs/day)=> 0.0000 0.000000 0.0000 0.0000 0.0000
MAIL left(lbs/day)_> 0.2609 0.002605 1.1399 #######
Percent Allow.Ind.(MAIL)still available(%)_> 100.0% 100.0% ####### 100.0% #######
Percent MAHL still available(%)_> 61.8% 72.5% ####### 94.2% #######
5 Percent MAHL(lbs/day)_> 0.0211 0.000180 0.0605 0.0033
HWA.AT
Revised:November 2005
Workbook Name : Troy.HWA.AT.2014.Approved (1)2018DRAFT, Worksheet kAarlae; ATPrintecf 2/7/2019, 10:36AM
Page 4 of 6
Allocation Table
Headworks last approved: 04/11/14
Allocation Table updated: 02/07/19
Permits last modified: 12/01/16
POTW=> Town of Troy
NPDES0=> N C00028916
ver
Industry Limits
IUP INDUSTRY NAMES Permit Pipe Load
Count (please liatelphabeticly) number number lbs/day
1 Wright Foods 0003 0001
2 Uwharrie Environmental 0004 4 0001
3
4 4
5
6
7
8
9
10
Column Totals=> 0.0000
Stream
Basis=> Std
MAHL from HWA(lbs/day)=> 0.0016
Uncontrollable Loading(lbs/day)_> 0.0086
Total Allowable for Industry(MAIL)(lbs/day)_> -0.0070
Total Permitted to Industry(lbs/day)_> 0.0000
MAIL left(lbs/day)_> -0.0070
Percent Allow.Ind.(MAIL)still available(%)=> 100.0%
Percent MAHL still available(%)_> -441.7%
5 Percent MAHL(lbs/day)_> 0.0001
HWA.AT
Revised:November 2005
Workbook Name : Troy.HWA.AT.2014.Approved (1)2018DRAFT, Worksheet Name: ATPrinted: 2/7/2019, 10:36AM
Page 5 of 6
Allocation Table
Headworks last approved: 04/11/14
Allocation Table updated: 02/07/19
Permits last modified: 12/01/16
Pores., Town of Troy
NPDES#=> N C00028916
Zinc Total Nitrogen Total Phos. c d e
Industry Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits
IUP INDUSTRY NAMES Permit Pipe Conc. Load Conc. Load Conc. Load Conc. Load Conc. Load Conc. Load
Count (please listalphabeticly) number number mg/1 lbs/day mg/1 lbs/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 Wright Foods 0003 0001
2 Uwharrie Environmental 0004 0001 �....
3
4
5
6
•
7
1
I
I
Column Totals=> 0.0000 I 0.00 0.00 0.0000 0.0000 0.0000
AS/Nit/TF
Basis=> inhibition
MAHL from HWA(lbs/day)=> 4.6704
Uncontrollable Loading(lbs/day)_> 0.0339
Total Allowable for Industry(MAIL)(lbs/day)_> 4.6365
Total Permitted to Industry(lbs/day)_> 0.0000 0.00 0.00 0.0000 0.0000 0.0000
MAIL left(lbs/day)_> 4.6365
Percent Allow.Ind.(MAIL)still available(%)_> 100.0% ####### ####### ####### ####### #######
Percent MAHL still available(%)=> 99.3% ####### ####### ####### ####### #######
5 Percent MAHL(lbs/day)_> 0.2335
HWA.AT
Revised:November 2005
Workbook Name : Troy.HWA.AT.2014.Approved (1)2018DRAFT, Worksheet Name: ATPrinted: 2/7/2019, 10:36AM
Page 6 of 6
Allocation Table
Headworks last approved: 04/11/14
Allocation Table updated: 02/07/19
Permits last modified: 12/01/16
POTw=> Town of Troy
NPDESM=> NC00028916
f g h I
Industry Permit Limits Permit Limits Permit Limits Permit Limits
IUP INDUSTRY NAMES Permit Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (plena lietalphabeticly) number number mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 1Wright Foods 0003 0001 1 _
2 Uwharrie Environmental 0004 0001 �.
3
4
t
5
6 II la ...
7 ��r
S a.�. r•a��a
10 �� 1r.......__-
Column Totals=> 0.0000 0.00001 0.0000 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 0,0000 0.0000 0.0000
MAIL left(lbs/day)=>
Percent Allow.Ind.(MAIL)still available(%)=> ####### ####### ####### #######
1 Percent MAHL still available(%)_> ####### ####### ####### #######
5 Percent MAHL(lbs/day)_>
HWA.AT
Revised:November 2005
Removal Rate Calculations
FLOW BOD AMMO IA
Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent
Sample Date mg/L Calculation < m:/L Calculation < mg/L Calculation < mg/L Calculation < mg/L Calculation < mg/L
1/2018 DMR Avg Spreadsheet 0.532 244.5 244.5 I 6.81 6.81 620.07 620.07 14.86 14.86 42.13 42.13 2.29
Instructions: Immosimm.
2/2018 DMRAvg 1) Data 0.552 233.83 233.83 111 3.63 3.63 523.17 523.17 5.67 5.67 49.33 49.33 < 0.1
entered only in '�'"*�'
3/2018DMRAvg Hwy 0.624 218.85 218.85111 4.53 4.53 634.46 634.46 , 8 8 60.48 60.48 0.331
4/2018 DMRAvg Bordered cells. i.574 209.75 209.75 3 3 508.67 508.67 4.73 4.73 57.96 57.96 < 0.1
Rest of �.�r� �r��
5/2018 DMRAvg worksheet is 0.556 194.2 194.2 2.25 2.25 397.2 397.2 3.7 3.7 65.81 65.81 < 0.1
6/2018 DMR Avgprotected,
password is 0.424 234.5 234.5 2.97 2.97 415.33 415.33 � 3,99 57.16 57.16 0.675
7/2018DMRAvg "2". 0.411 160.7 160.7 3.14 3.14 305.85 305.85 3.15 3.15 1 46.33 46.33 0.05
8/2018 DMR Avg 2) For below 0.499 U 143.77 143.77 1.279 1.279 332.38 332.38 4.15 4.15 52.86 52.86 0.021
detection data, _
9/2018 DMR Avg enter"<"in"<" 0.7 285.83 285.83 2.67 2.67 649.25 649.25 4.5 4.5 �^ 54.74 0.075
10/2018 DMR Av clumn,and 79.88 0,043
0.516 196.14 196.14 4.11 4.11 351.21 351.21 4.29 4.29 79.88 B enter detection ��
11/2018 DMR Avg oe Etfluen luent 0.606 163,19 163.19 2.23 2.23 316.54 316.54 2.54 2.54 29.74 29.74 < 0.1
12/2018 DMR Avg mg/I columns. 0.729 131.55 131.55 2 1 213.36� 213.36 5.27 5.27 23.71 23.71 < 0.1
Spreadsheet
will auto-
matically mum
-.MN
calculate ..........„
averages and +�
removal rates �....... ,
using 1/2
value entered. l'Immmill"""
3)Document
removal Rate ....�r
mt
choice
4)Formulas in
Compre-
hensive ���► I
Guide
es=> HWA Chapter,
Column Averages section E, 0.56025 201.4008 3.134917 438.9575 5.404167 51.6775
page 1. Unpaired Site Specific RR=> 98.44% Unpaired Site Specific RR=> 98.77% Unpaired Site Specific RR=>
Literature/Default RR=> 85.00% Literature/Default RR=> 85.00% Literature/Default RR=>
4 ".i, of data is BDL 0 ?-%, of data is BDL 21 % of data is BDL
RR lbr this HWA 98.44% RR for this iIWA .->• 98.77% RR for this I-i:WA
Removal Rate Spreadsheet Working Draft
Removal Rates
Page 1 of 8 pages
2/7/2019, 10:40 AM
Revision:August 1999
Removal Rate Calculations
Used in
Sample Date Calculation
1/2018 DMR Avg 2.29
2/2018 DMR Avg 0.05
3/2018 DMR Avg 0.331
4/2018 DMR Avg 0.05
5/2018 DMR Avg 0.05
6/2018 DMR Avg 0.675
7/2018 DMR Avg 0.05
8/2018 DMR Avg 0.021
9/2018 DMR Avg 0.075
10/2018 DMR Avj 0.043
11/2018 DMR Avg 0.05
12/2018 DMR Avg 0.05
Column Averages=> 0.31125
99.40%
85.00%
99.40%
Removal Rate Spreadsheet Working Draft
Removal Rates
Page 2 of 8 pages
2/7/2019, 10:40 AM
Revision:August 1999
Removal Rate Calculations
ARSENIC CADMIUM CHROMIUM
Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date < mg/L Calculation < mg/L Calculation `mg/L Calculation < mg/L Calculation < mg/L Calculation < mt/L Calculation
1/2018 DMR Avg < 0.01 0.005 < 0.01 0.005 < 0.002 0.001 <I 0.002 0.001 0.021 0.021 0.009 0.009
�r w
2/2018 DMR Avg
3/2018 DMR Avg
4/2018 DMR Avg 0.039 0.039 < 0.01 0.005 < 0.002 0.001 < 0.002 0.001 �� 0.021 0.006 0.006
5/2018 DMR Avg ,
6/2018 DMR Avg
7/2018 DMR Avg ��1� 0.005 < 0.01 0.005 <, 0.002� 0.001 < 0.002 0.001' 0.017 0.017 , 0.006 0.006
8/2018 DMR Avg
9/2018 DMR Avg
10/2018 DMR Avg < 0.01 0.005 < 0.01 0.005 < 0.002 0.001 < 0.002 0.001 0.029 0.029 0.007 0.007
11/2018 DMR Avg _ _
12/2018 DMR Avg
i
Column Averages=> 0.0135 0.0050 0.0010 0.0010 0.0220 _ 0.0070
Unpaired Site Specific RR=>'50%BDL Unpaired Site Specific RR=4 50%BDL Unpaired Site Specific RR=> 68.18%
Literature/Default RR=> 45.00% Literature/Default RR=> 67.00 % Literature/Default RR=> 82.00°'o
88 % of data is BDL ItiO of data is BDL it °,+ of data is BDL
1/k td,rr this l lvv'.\ 45.00% R43" 1,i tii,,, i i°vki,A 67.00% RR fir this 1:.WA 68.18%
Removal Rate Spreadsheet Working Draft
Removal Rates
Page 3 of 8 pages
2/7/2019, 10:40 AM
Revision:August 1999
•
Removal Rate Calculations
COPPER CYANIDE LEAD
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 < m:/L Calculation < m_/L Calculation < mg/L Calculation < mg/L Calculation
1/2018 DMR Avg �5 0.105 0.035 0.035 < 0.005 0.0025 0.011 0.011 0.014 0.014 0.01 0.005
3/2018 DMR Avg =$E
3/2018 DMR Avg
4/2018 DMR Avg 0.192 0.192' 0.012 0.012 0.006 0.006 < 0.005 0.0025 0.058 0.058 $ 0.01 0.005
5/2018 DMR Avg -I IIIIII
-
6/2018 DMR Avg $MIN $N 7/2018 DMR Avg 0.138 0.138 0.028 0.028 I< 0.005' 0.0025 <4 0.005 0.0025 1:1 0.01 0.005 $ 0.01 0.005
8/2018 DMR Avg IM-II Mil
� -
9/2018 DMR Avg IIIIIIIIIII
10/2018 DMR Avg 0.071r 0.071 0.018 0.018 < 0.005 0.0025 0.01 0.01 < 0.01 0.005 $ 0.01" 0.005
11/2018 DMR Avg ��e ■a
12/2018 DMR Avg -IN
f 4.
•Mil'�INOM
I MOO I 1111111'
MIN
.___ ■ �I
•MCI MOM
._....___MINI ..
111111111111110.111111111111111111111111111, I all
II 1111111111111
11 NM
I MIN
---_._ =
Column Averages=> 0.1265 0.0233 0.0034 0.0065 0.0205 0.0050
Unpaired Site Specific RR=> 81.62% Unpaired Site Specific RR-4 50%BDL Unpaired Site Specific RR=>p 50%BDI
Literature/Default RR=> 86.00% Literature/Default RR=> 69.00% Literature/Default RR=> 61.00%
v of data is BDL 63 of data is BDL 75 to of data is BDL
RR for this il\NA 81.60% KR fol this II\VA 69.00% RR.for this il+N A 61.00%
Removal Rate Spreadsheet Working Draft
Removal Rates
Page 4 of 8 pages
2/7/2019, 10:40 AM
Revision:August 1999
Removal Rate Calculations
MOLYBDENUM NICKEL
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 < m_•/L Calculation < m•/L Calculation < mg/L ,Calculation < m /L Calculation
1/2018 DMR Avg 0.0003 0.0003 0.01 0.01 < 0.005 0.0025 0.021 0.021 0.012 0.012
2/2018 DMR Avg ��� 1
3/2018 DMR Avg ~�- 3.63E-06 3.63E-06 �-
4/2018 DMR Avg 0.0001 0.0001 < 0.005 0.0025 < 0.005 0.0025 0.026 0.026 0.012 0.012
5/2018 DMR Avg ~��
6/2018 DMR Avg `
7/2018 DMR Avg 0.0003 0.0003 <' 0.005 0.0025 < 0.005 0.0025 0.017' 0.017 <,
�mr 0.01 0.005
8/2018 DMR Avg 1 3.79E-06 3.79E-06
9/2018 DMR Avo
10/2018 DMR Avg 0.0005o 0.0005 <<00.00005 0.0025 < 0.005 0.0025 0.03 I 0.03 0.016 0.016
11/2018 DMR Avg
I
12/2018 DMR Avg 1.24E-05 1.24E-05
- .ram
IMIIIIIIIIIIIMIIIIIIIIIIIMINW
Column Averages=> 0.00030 0.00001 0.0044 0.0025 0.0235 0.0113
Unpaired Site Specific RR-> 97.80%o Unpaired Site Specific RR=>I>50%BDL Unpaired Site Specific RR=> 52.13
Literature/Default RR=> 60.00% Literature/Default RR=> 33.00% Literature/Default RR=> 42.00%
(I "ia of data is BDL 38 °,, of data is BDL 13 of data is BDL
RE flit this IIWA ' 97.80% RR for Ow,I(WA 33.00% P.k ,F . :ifl , +2.%,, 52.10%
Removal Rate Spreadsheet Working Draft
Removal Rates
Page 5 of 8 pages
2/7/2019, 10:40 AM
Revision:August 1999
Removal Rate Calculations
SELENIUM SILVER ZINC
Influent Used in I�Tlluent Used in Influent used in Effluent Used in II Influent Used in il Used in
Sample Date < mg/L Calculation < m /L Calculation <�rnrwnrr mg/L Calculation ,..<�rrmrg/L Calculation rn /L Calculation < Calculation
pnrr
1/2018 DMR Avg < 0.01 0.005 <1 0.01 0.005 < 0.005 0.0025 < 0.005 0.0025 IN 0.378 0.378 0.165 0.165
2/2018 DMR Avg 1 :a-
3/2018 DMR Avg
4/2018 DMR Avg < 0.01 0.005 < 0.01 0.005 < 0.005 0.0025 < 0.005, 0.0025 0.85.a 0.05 ME
5/2018 DMR Avg •
6/2018 DMR Avg .N
7/2018 DMR Avg < 0.01 0.005 < 0.01 0.005 < 0.005♦ 0.0025 < 0.005 0.0025 • 0.315 15 MI
DMR Avg a ~ . .M
9/2018 DMR Avg ■Ell a
10/2018 DMR Avg < 0.01 0.005 < 0.01 0.005 < 0.005 0.0025 < 0.005 0.0025 II0.217 1 0.04 0.04
11/2018 DMR Avg INN II MUM
12/2018DMR Avg
MP AO
� II MOO-I MN
rr..iri�sr .. 111 NM I MN IIM
.. .a s
I NMI
1111111111
IIMOMIIIIIMININNIMINOW
Column Averages-> 0.0050 0.0050 0.0025 0.0025 0.4400 0.0743
Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR-> 50%BDL Unpaired Site Specific RR=> 83.13%
Literature/Default RR=> 50.00% Literature/Default RR=> 75.00% Literature/Default RR=> 79.00%
100 °U of data is BDL 100 "0 of data is BDL of data is BDL
RR tin this 1lW'A 50,00% RR lot this I1G4s1 75.00% RR for this IIWA 83.10%
Removal Rate Spreadsheet Working Draft
Removal Rates
Page 6 of 8 pages
2/7/2019, 10:40 AM
Revision:August 1999
Removal Rate Calculations
Oil& Grease
Influent Used in Effluent Used in Influent Used in Effluent Used in Influent Used in Effluent Used in
Sample Date < m•-/L Calculation < m /L Calculation < m /L Calculation < mg/L Calculation < m_/L Calculation
1/2018 DMR Avg -111--
2/2018 DMR Avg 111-
3/2018 DMR Avg UMW
4/2018 DMR Avg -■M
5/2018DMR Avg -III-
6/2018 DMR Avg - I -I MIN
7/2018 DMR Avg Mil
8/2018 DMR Avg -U
9/2018 DMR Avg -.M
10/2018 DMR Avg -III MEI
11/2018 DMR Avg -r_-
12/2018 DMR Avg -,
I
ISM.... __SINIIMINIMILMIIIIIKOMMINIP
II NM 11111111111111
li -II�-
Column Averages=>
Unpaired Site Specific RR=>II Unpaired Site Specific RR=>II Unpaired Site Specific RR=>
Literature/Default RR=> Literature/Default RR=>_ Literature/Default RR=>
of data is BDL of data is BDL of data is BDL
RR tot this t tWA KR lot this IIWA .,1I R.R Sot this IDA A �.
Removal Rate Spreadsheet Working Draft
Removal Rates
Page 7 of 8 pages
2/7/2019, 10:40 AM
Revision:August 1999
Removal Rate Calculations
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 m•/L Calculation < m•/L Calculation < mg/L Calculation < mg/L Calculation
1/2018 DMR Avg ■--■EOM- I _
2/2018 DMR Avg ■--■__
3/2018DMRAvg - ■�—■_'—
4/2018 DMR Avg r— ■——■ r���
5/2018 DMR Avg r��.. r..���MN IL _
6/2018 DMR Avg ��.�.....� ■ -Imil
-
7/2018 DMR Avg ■—_■ _
8/2018DMRAvg ■--■_'-
9/2018 DMR Avg ■_—■�—
10/2018DMRAvg ■
......... ...............��
11/2018DMRAvg �� ■��■��
12/2018 DMR Avg ■ I
■��I �.
■ ■ _._�
■
I
■ 1111■IIIII- .�
MINIIINIMMINEINNOIMIIINL
Column Averages
Unpaired Site Specific RR=> Unpaired Site Specific RR=>II Unpaired Site Specific RR=>
Literature/Default RR=>— Literature/Default RR—>_ Literature/Default RR=>rn'.."."1
of data is BDL of data is BDL of data is BDL
RR for this IIWA II RR for this 1 WA RR for this 1:IWA
Removal Rate Spreadsheet Working Draft
Removal Rates
Page 8 of 8 pages
2/7/2019, 10:40 AM
Revision:August 1999
SIU.Uncont.Mass.Bal
FLOW BOD TSS AMMONIA ARSENIC
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 Uwharrie Environmental 4 0.008572 8,572 285 20.37 354 25.31 807 57.6928 0.084 0.0060
2 Wright Foods 3 0.015 15,000 221 27.65 85 10.63
3
4
5
6
7
8
9
10
11
12
13
Sum of Industrial Loading(lbs/day)=>' 0.02361 23572 I 48.0219 35.9411 57.6928 f 0.0060
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)=> 0.6811 681011.16.6...71 237.83071 0.005 0.0284
Uncontrollable Load from Mass Bal(lbs/day)_> 0.6574 1,467.14 1,044.591 180.1379 0.0224
Uncontrollable Concen.from Mass Bal(mg/L)=> 2681 I 1911 I- 32.9J I 0.00411
Uncont.from Uncont. Sampling(mg/L+lbs/day)_>
Uncontrollable Concen. From Literature(mg/L)_> 250 250 25 0.003
Uncontrollable cone. to he used in HWA(mg/L)_> 250 250 25 0.003
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
Uncontrollable Mass Balance Spreadsheet(3)
SIU.Uncont.Mass.Bal
Page 1 of 5 pages
2/7/2019, 10:42 AM
Revision:August 1999
•
SIU.Uncont.Mass.Bal
FLOW CADMIUM CHROMIUM COPPER CYANIDE
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 ‘Uwharrie Environmental 4 0.008572 8,572 0.0015 0.0001 0.232 0.0166 0.012 0.0009 0.064 0.0046
2 Wright Foods 3 0.015 15,000 0.059 0.0074
3
4
5
6
7
9
10
11
12
13
Sum of Industrial Loading(lbs/day)=> 0.0236 23572 0.0001 0.0166 0.0082 0.0046
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)_> 0.6811 681,000 0.0011 0.00571 0.00291 0.01651 0.04961 0.2817E 0.0031 0.0176
Uncontrollable Load from Mass Bal(lbs/day)_> 0.6574 0.0056 -0.0001 0.2735 0.0130
Uncontrollable Concen. from Mass Bal(mg/L)_> I 0.00101 1 0.00001 I 0.0499J I 0.00241
Uncont.from Uncont. Sampling(mg/L+lbs/day)_>
Uncontrollable Concen. From Literature(mg/L)=> 0.003 0.05 0.061 0.041
01111t7 1,;[Pir ;,P 13t" I i`a`;': trilp 0.003 0.05 0.061 0.041
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
Uncontrollable Mass Balance Spreadsheet(3)
SIU.Uncont.Mass.Bal
Page 2 of 5 pages
2/7/2019, 10:42 AM
Revision:August 1999
SIU.Uncont.Mass.Bai
FLOW LEAD MERCURY MOLYBDENUM NICKEL
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 Uwharrie Environmental 4 0.008572 8,572 0.0056 0.000017 0.00000 0.226 0.0162
2 Wright Foods 3 0.015 15,000 1111111111111111111 IMIll M MIN
3 111111111
4 - NININ Milli
-
5 _ .
6Mill-_ Mil MIN
-
7 --M
8 _
9 Mil MIN
10 MINN MN
11 MOE
12 MIN
13 --_--�
Sum of Industrial Loading(lbs/day)=> 0.0236 23572 0.00000 0.0162
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)=> 0.681 681,000 0.0092 0.0523 0.00015 0.00085 0.0025 0.0142 0.0235 0.1335
Uncontrollable Load from Mass Bal(lbs/day)_> 0.6574 0.00085 0.1173
Uncontrollable Concen. from Mass Bal(mg/L)_> I I 1 0.000161 I I 1 0.0214,
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> I
Uncontrollable Concen. From Literature(mg/L)_> 0.049 0.0003 I-- 0.021
I in ofif,(, aliit;.,,, ,:. lay f), ti :..i s . ri'',t A f ow f 0.049 0.0003 0.0027 0.021
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
Uncontrollable Mass Balance Spreadsheet(3)
SIU.Uncont.Mass.Bal
Page 3 of 5 pages
2/7/2019, 10:42 AM
Revision:August 1999
SIU.Uncont.Mass.Bal
$' FLOW SELENIUM SILVER ZINC Oil & Grease
INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average Discharge
IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load
Count (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
1 Uwharrie Environmental 4 0.008572 8,572 0.00045 0.0000 0.264 0.0189
2 Wri• t Foods 111111111111111111 0.015 15,000 _- 0.44 0.0550
3 MIN MEN
4 11111111111111 --
5 111111.111111111_-_-_
6 NEM
7 1111111111111111_---_
8 11111111111111111111111111111111111.1111111111111--_-�
9 1111111111111111111111111111111111111111111111111111.1111
10
11 -�-�_�
12 11111111111-11.111111
13 _�- -�-�_
Sum of Industrial Loading(lbs/day)_> 0.0236 23572 0.0000 0.0739
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)_> 0.681 681,000 0.005 0.0284 0.0025 0.0142 0.114 0.6475
Uncontrollable Load from Mass Bal(lbs/day)_> 0.6574 0.0142 0.5736
Uncontrollable Concen. from Mass Bal(mg/L)_> ( I I 0.00261 I 0.10461
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> r
Uncontrollable Concen. From Literature(mg/L)_> I�"'''0..0051 I 0.1751 50
1 1 I�..r... 1
k k �,�.,, t_.1 .1 �n,, E.i
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
Uncontrollable Mass Balance Spreadsheet(3)
SIU.Uncont.Mass.Bal
Page 4 of 5 pages
2/7/2019, 10:42 AM
Revision:August 1999
SIU.Uncont.Mass.Bal
FLOW
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 Uwharrie Environmental 4 0.008572 8,572
2 Wright Foods 3 0.015 15,000
3 _�-_--
4
5
6
7
89
-�--
10
11
12
MII
13
Sum of Industrial Loading(lbs/day)=> 0.0236 23572 r
MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day
Avg Influent loading(lbs/day)_>' 0.681) 681,000
Uncontrollable Load from Mass Bal(lbs/day)_> 0.6574
Uncontrollable Concen. from Mass Bal(mg/L)_> I I I I I I I
Uncont.from Uncont. Sampling(mg/L+lbs/day)_> ' L1 Lememosi I1
Uncontrollable Concen. From Literature(mg/L)_> I J I I I I ( I
Spreadsheet Instructions:
1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is Choose"Uncontrollable Concentration to be used in HWA"(row 31)from Uncontrollable
protected,password is"2". Concentration From "Mass Balance"(row 25),
2)Formulas are discussed in the Comprehensive Guidance,Chapter 5,Section E,page 5. "Sampling"(row 27),or"Literature"(row 29). Document reasons.
Uncontrollable Mass Balance Spreadsheet(3)
SIU.Uncont.Mass.Bal
Page 5 of 5 pages
2/7/2019, 10:42 AM
Revision:August 1999