Loading...
HomeMy WebLinkAboutNC0020940_Headworks Analysis_20180529 (3) Zobnu of Alurpbp Rick Ramsey,Mayor Commissioners P.O.Box 130 Commissioners Frank E.Dickey Murphy,North Carolina 28906 Noland Smith Barbara Hughes (828)837-2510 •Fax(828)837-9612 Gail Walker Stansell Barry R.McClure town_of murphy@frontiercom Karen Watson Deborah, Please find the Headworks Analysis attached for the Town of Murphy. If you have any questions or something is wrong, please feel free to contact me at opie01044@gmail.com or call me at 828-837- 5035.Thank you for all the help with this report. Sincerely, Tyler White Town of Murphy Pretreatment Coordinator RECEIVED/DENRIDWR MAY 29 2018 Water Resources Permitting Section Cowan &Cowan,Attorneys * • Workbook Name: HWA 2018; Worksheet Name: HWA Page 1 of 5 Printed 5/25/2018,10:13 AM A I B I C I D L_ E I F I G I H 1 I I J 1 K 1 Headworks Analysis Spreadsheet Spreadsheet Instructions: 1 2 POTW Name: Murphy WWTP 1) Applicable Values should be entered in the Heavy Bordered Blue cells. The rest of worksheet is 3 Date: 5/2/2018, protected,password is"2". 4 POTW NPDES#=> N00020940 2) Additional pollutants can be added in cells A34 to A42. Note all Pollutant names are linked from here to other pages in HWA worksheet and also to AT worksheet(i.e.,automatically entered into 5 POTW Sludge Permit#_> �— other pages in HWA worksheet and also AT worksheet from HWA worksheet). 7 POTW NPDES Permitted Flow(MGD)= 1.4 AT 3) Formulas are discussed in the Comprehensive Guidance HWA Chapter. 1 8 POTW Average Flow(MGD)= 0.5619 used in HWA calculations 4) HWA,AT and HASL worksheets are linked. MAHLs,Basis,and Uncontrollable load are 1 /` automatically entered into AT from this worksheet. 9 Uncontrollable Flow(MGD)= 0.5463 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)= 62.6 "view"tab click the"comment Indicator only"button. 11 Stream Classification= C 13 Class of Sludge generated(A,or B) 14 Sludge to Digestor Flow(MGD)= e s g 8Through talc.for different POTW use Design 15 Sludge to Disposal Flow(MGD)= flows Criteria 16 %Solids to Disposal= Design Values Average Flow Permitted Flow Loading 17 Sludge Site Area(acres)= WWTF Influent BOD(mg/I) 200 30.3 12.2 1 18 Sludge Site Life(yrs)= WWTF Influent TSS(mg/1) �� 218.2 87.6 19 Age of Sludge Site(yrs)= WWTF Influent NH3(mg/1)_ _ 20 WWTF Influent Total N(mg/1) 21 Pass-Through Loading Calculations WWTF Influent Total P(mg/I) . 41116 Stream Standard Pass-Thru Minimum NPDES LIMIT Plant Removal Removal rate NPDES Loading Standard Stream Loading Design Criteria Loading Pass-Thru 23 Pollutant (mg/I) Rate(%) Source (lbs/day) (mg/I) Standard Source (lbs/day) Loading(lbs/day) (lbs/day) Basis 24 BOD 30 93.08% DMR 142 2,335 142 NPDES 25 TSS 30 86.25 'DMR 1,022 2,919 1,022 NPDES 26 Ammonia 85 Lit 27 Arsenic 45 Lit 0.05 Aquatic Life 47.8882 47.8882 Stream Std 28 Cadmium 67 L it 0.002 Aquatic Life 3.1925 3.1925 Stream Std 29 Chromium 82 Lit 0.05 Aquatic Life 146.3251 146.3251 Stream Std 30 Copper 86 Lit 31 Cyanide69 Lit 32 Lead 61 Lit 0.025 Aquatic Life 33.7673 33.7673 Stream Std 33 Mercury 0.047 60 Lit 0.55063 0.55063 NPDES 34 Molybdenum 33 Lit 35 Nickel 42 Lit 0.088 Aquatic Life 79.9238 79.9238 Stream Std 36 Selenium 50 Lit 1 0.005,Aquatic Life 5.2677 5.2677 Stream Std 37 Silver 75 Lit 38 Zinc .. 79 Lit 39 Total Nitrogen 40 Total Phos. , 41 C 42 d 43 e 44 f 45 g 46 h r 47 I Modeled after:Chapter 5-HWA Guidance,Appendix 5-A Revision Date: February 2008 Workbook Name: HWA 2018; Worksheet Name: HWA Page 2 of 5 Printed 5/25/2018, 10:13 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(mg/I) 50 Average Anaerobic Digester NH3(mg/1) 51 Inhibition Loading Calculations only enter when have ANAEROBIC digester A.S./Nit,/T.F. A.S./Nit,/T.F. A.S./Nit,/T.F. 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 I 1 54 TSS r 55 Ammonia 480 Lit 22 9.3981 2249.40 AS/Nit/TF it 56 Arsenic O.I�Lit 0.4686 r 0.4686 AS/Nit/TF ir 57 Cadmium _ I Lit 4.6862 _ 4.6862 AS/Nit/TF ir 58 Chromium I�Lit t 4.6862 4.6862 AS/Nit/TF in 59 Copper I Lit 4.6862 4.6862 AS/Nit/TF in 60 Cyanide 0.1 Lit 0.4686 0.4686 AS/Nit/TF in 61 Lead 1 Lit 4.6862 4.6862 AS/Nit/TF in 62 Mercury ~ 0.1 Lit _ 0.4686 r 0.4686 AS/Nit/TF in 63 Molybdenum 64 Nickel I Lit 4.6862 4.6862 AS/Nit/TF in 65 Selenium A 66 Silver 0.25 Lit 1.1716r 1.1716 AS/Nit/TF in 67 Zinc I,Lit 4.6862 4.6862 AS/Nit/TF in 68 Total Nitrogen A 69 Total Phos. 70 c 71 d 72 e 73 f _ 74 g 75 h 76 I _ Modeled after:Chapter 5-HWA Guidance,Appendix 5-A Revision Date: February 2008 • Workbook Name: HWA 2018; Worksheet Name: HWAPage3of5 Printed 5/25/2018, 10:13 AM A F ] G I H 1 J 1 K 77 78 Sludge Loading Calculations Sludge Ceiling Class A Limits Class A Limits Class A Limits Minimum Minimum Sludge Ceiling Sludge Ceiling Load Cumulative Sludge Cumulative Monthly Monthly Avg. Mon.Avg.Load. - Sludge Sludge Concentration Load -HASL Calc.- Rate Limit Sludge Loading Average Rate Loading HASL Calc.- Loading Loading 79 Pollutant Limit(mg/kg) (lbs/day) (lbs/day) (lbs/(acre"life)) (lbs/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 g 102 h 103 1 104 Modeled after:Chapter 5-HWA Guidance,Appendix 5-A Revision Date: February 2008 Workbook Name: HWA 2018; Worksheet Name: HWA Page4of5 Printed 5/25/2018, 10:13 AM A I B I C I D I E I F I G .1 H 1 I 1 J 1 K 105 Maximum Allowable Headworks Loading Calculations IVIMAIMUM Minimum Pass Minimum Minimum Minimum Minimum Allowable Maximum Allowable Through Loading Pass Through Inhibition Loading Inhibition Loading Sludge Loading Sludge Loading Headworks Headworks Loading 106 (lbs/day) Source (lbs/day) Source (lbs/day) Sorce Loading(lbs/day) Source 107 BOD 141.9 NPDES 141.9 NPDES 108 TSS 1022.5 NPDES 1022.5 NPDES 109 Ammonia 2249.3981 AS/Nit/TF inhibiti 2249.4 AS/Nit/TF inhibition 110 Arsenic 47.8882 Stream Std 0.4686 AS/Nit/TF inhibiti 0.4686 AS/Nit/TF inhibition 111 Cadmium 3.1925 Stream Std 4.6862 AS/Nit/TF inhibiti 3.1925 Stream Std 112 Chromium 146.3251 Stream Std 4.6862 AS/Nit/TF inhibiti 4.6862 AS/Nit/TF inhibition 113 Copper 4.6862 AS/Nit/TF inhibiti 4.6862 AS/Nit/TF inhibition 114 Cyanide 0.4686 AS/Nit/TF inhibiti 0.4686 AS/Nit/TF inhibition 115 Lead 33.7673 Stream Std 4.6862 AS/Nit/TF inhibiti 4.6862 AS/Nit/TF inhibition 116 Mercury 0.55063 NPDES 0.4686 AS/Nit/TF inhibiti 0.468.62 AS/Nit/TF inhibition 117 Molybdenum 118 Nickel 79.9238 Stream Std 4.6862 AS/Nit/TF inhibiti 4.6862 AS/Nit/TF inhibition 119 Selenium 5.2677 Stream Std 5.2677 Stream Std 120 Silver 1.1716 AS/Nit/TF inhibiti 1.1716 AS/Nit/TF inhibition 121 Zinc 4.6862 AS/Nit/TF inhibiti 4.6862 AS/Nit/TF inhibition 122 Total Nitrogen 123 Total Phos. 124 c 125 d 126 e 127 f 128 g 129 h 130 1 131 Modeled after:Chapter 5-HWA Guidance,Appendix 5-A Revision Date: February 2008 Workbook Name: HWA 2018; Worksheet Name: HWA Page5of5 Printed 5/25/2018, 10:13 AM A I B I C I D E I F I G 1 H 1 I 1 J 1 K 132 133 Maximum Allowable Industrial Loadings Calculations Maximum Maximum Allowable Check to Use Uncontrollable Allowable Headworka Loading HASL Calcs Concentration Uncontrollable Uncontrollable Industrial Design vs.Pass- 134 Pollutant (lbs/day) MAHL Basis (x) (mg/I) Source Load(lbs/day) Load(lbs/day) Thru Warning 135 BOD 141.9083 NPDES 192.5 sampling 1 877.0573 -735.1491 136 TSS 1022.4537 NPDES r 1323ampling 602.7776 419.6761 137 Ammonia 2249.3981 AS/Nit/TF inhibition 25.7 sampling 117.0928 2132.3052 138 Arsenic 0.4686 AS/Nit/TF inhibition 0.005 sampling i 0.0228 0.4458 139 Cadmium 3.1925 Stream Std ! 0.0005 sampling 0.0023 3.1903 140 Chromium 4.6862 AS/Nit/TF inhibiti N/A 0.0025 sampling , 0.0114 4.6749 141 Copper 4.6862 AS/Nit/TF inhibition 0.0733 sampling s 0.3340 4.3523 142 Cyanide 0.4686 AS/Nit/TF inhibiti N/A 0.004 sampling 0.0182 0.4504 143 Lead 4.6862 AS/Nit/TF inhibition 0.0025 sampling 0.0114 4.6749, 144 Merct 0.46862 AS/Nit/TF inhibition 0.0001 sam,lin_ 0.00046 0.46817 145 Molybdenum 0.0025 sampling 0.0114 146 Nickel 4.6862 AS/Nit/TF inhibition 0.0076 sampling 0.0346 4.6516 147 Selenium 5.2677 Stream Std ! 0.005 sampling 0.0228 5.2449 148 Silver 1.1716 AS/Nit/TF inhibiti N/A 0.0071 sampling 0.0323 1.1392 149 Zinc 4.6862 AS/Nit/TF inhibition 0.6174 sampling 2.8130 1.8733 150 Total Nitrogen 151 Total Phos. 152 c 153 d 154 e 155 f 156 g 15711 158 I Modeled after:Chapter 5-HWA Guidance,Appendix 5-A Revision Date: February 2008 Workbook Name : HWA 2018, Worksheet Name: AT Printed: 5/25/2018, 10:09 AM Page 1 of 6 Allocation Table Spreadsheet Instructions: Headworks last approved: 10/29/12 1)Applicable Values should be entered in the Heavy Bordered cells. Rest of worksheet is protected,password is ..2,. Allocation Table updated: 03/05/13 2)Formulas are discussed in the Comprehensive Guidance,Chapter 6,Section C. Permits last modified: 09/05/17 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. Pores=, Murphy WWTP NPDESik> N00020940 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 list alphabeticly) number number Industry Date Date Expires MGD gal/day m I lbs/day lbs/day 1 MGM 0003 0001 433 09/05/17 03/05/22 0.0057 5,700 100.00 4.75 100.00 4.75 2 MOOG 0001 0001 433 09/05/17 10/01/17 03/05/22 3 SNAP ON 0005 0001 433 09/05/17 03/05/22 0.020020,000 100.00. 16.68 100.00 16.68 4 5 ._- 6 7 8 l + 9 i ►--. I 10 Column Totals=> , 0.0257 25,700 21 1 211 Basis=> NPDES NPDES NPDES MAHL from HWA(lbs/day)=> NPDES Permitted Flow=> 1.4000 142 1022 Uncontrollable Loading(lbs/day)=> 0.5463 877 603 Total Allowable for Industry(MAIL)(lbs/day)_> 0.8537 -735 420 Total Permitted to Industry(lbs/day)_> 0.0257 21 21 MAIL left(lbs/day)_> 0.8280 -757 398 Percent Allow.Ind.(MAIL)still available(%)=> 97.0% 102.9% 94.9% Percent MAHL still available(%)=> 59.1% -533.1 % 38.9% 5 Percent MAHL(lbs/day)_> 0.0700 7 51 HWA.AT Revised:November 2005 Workbook Name : HWA 2018, Worksheet Name: AT Printed: 5/25/2018, 10:09 AM Page 2 of 6 Allocation Table Headworks last approved: 10/29/12 Allocation Table updated: 03/05/13 Permits last modified: 09/05/17 Pores=, Murphy WWTP NPDESS=> NC0020940 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 (plea selistalphabeticly) number number mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day 1 MGM 0003 0001 monitor ####### monitor ####### 0.2500 0.0119 1.1000 0.0523 1.5000 0.0713 0.2000 0.0095 2 MOOG 0001 0001 3 SNAP ON 0005 0001 monitor ####### monitor ####### 0.0697 0.0116 1.0956 0.1827 1.4940 0.2492 0.1992 0.0332 4 , ii ,Imi ` i 11 ... ..1 5 ii 6 , 7 r 8 i i 10 Column Totals=> ####### ####### 0.0235 0.2350 0.3205 0.0427 AS/Nit/TF AS/Nit/TF Stream AS/Nit/TF AS/Nit/TF AS/Nit/TF Basis=> inhibition inhibition Std inhibition inhibition inhibition MAHL from HWA(lbs/day)=> 2249.40 0.4686 3.1925 4.6862 4.6862 0.4686 Uncontrollable Loading(lbs/day)=> 117.09 0.0228 0.0023 0.0114 0.3340 0.0182 Total Allowable for Industry(MAIL)(lbs/day)_> 2132.31 0.4458 3.1903 4.6749 4.3523 0.4504 Total Permitted to Industry(lbs/day)_> ####### ####### 0.0235 0.2350 0.3205 0.0427 MAIL left(lbs/day)_> ####### ####### 3.1668 4.4398 4.0318 0.4077 Percent Allow.Ind.(MAIL)still available(%)_> ####### ####### 99.3% 95.0% 92.6% 90.5% Percent MAHL still available(%)=> ####### ####### 99.2% 94.7% 86.0% 87.0% 5 Percent MAHL(lbs/day)_> 112.47 0.0234 0.1596 0.2343 0.2343 0.0234 HWA.AT Revised:November 2005 Workbook Name : HWA 2018, Worksheet Name: AT Printed: 5/25/2018, 10:09 AM Page 3 of 6 Allocation Table Headworks last approved: 10/29/12 Allocation Table updated: 03/05/13 Permits last modified: 09/05/17 Pores=> Murphy WWTP NPDES#�> NC0020940 Lead Mercury Molybdenum Nickel Selenium Sil Industry Permit Limits Permit Limits Permit Limits Permit Limits Permit Limits Permit IUP I INDUSTRY NAMES Permit Pipe Conc. Load Conc. Load Conc. Load Conc. Load Conc. Load Conc. Count (please list aIph beaoiy) number number mg/1 lbs/day mg/I lbs/day mg/1 lbs/day mg/I lbs/day mg/1 lbs/day mg/1 1 MGM 0003 0001 0.1000 0.0048 monitor #VALUE! monitor ####### 0.7500 0.0357 monitor ####### 0.2400 2 MOOG 00010` 001 3 SNAP ON 0005 0001 0.0996 0.0166-monitor #VALUE! only its ####### 0.7470 0.1246 monitor ####### 0.2390 4 ��` 1 5 6 `� 7 / 8 9 10 Column Totals=> l 0.0214 #VALUE! ,#######1 0.1603 ####### AS/Nit/TF AS/Nit/TF AS/Nit/TF Stream Basis=> inhibition inhibition inhibition Std MAHL from HWA(lbs/day)_> 4.6862 0.468625 4.6862 5.2677 Uncontrollable Loading(lbs/day)=> 0.0114 0.000456 0.0114 0.0346 0.0228 Total Allowable for Industry(MAIL)(lbs/day)=> 4.6749 0.468169 4.6516 5.2449 Total Permitted to Industry(lbs/day)=> 0.0214 #VALUE! ####### 0.1603 ####### MAIL left(lbs/day)=> 4.6535 #VALUE! 4.4914 ####### Percent Allow.Ind.(MAIL)still available(%)_> 99.5% #VALUE! ####### 96.6% ####### Percent MAHL still available(%)_> 99.3% #VALUE! ####### 95.8% ####### 5 Percent MAHL(lbs/day)=> 0.2343 0.023431 0.2343 0.2634 HWA.AT Revised:November 2005 Workbook Name : HWA 2018, Worksheet Name: AT Printed: 5/25/2018, 10:09 AM Page 4 of 6 Allocation Table Headworks last approved: 10/29/12 Allocation Table updated: 03/05/13 Permits last modified: 09/05/17 Pores=, Murphy WWTP NPDESik> NC0020940 ver Industry Limits IUP INDUSTRY NAMES Permit Pipe Load Count (please list aipi ananciy) number number lbs/day 1 MGM 0003 0001 0.0114 2 MOOG 0001 0001 3 SNAP ON 0005 0001 0.0399 4 _ 5 6 7 8 9 10 Column Totals=> 1 0.0513 AS/Nit/TF Basis=> inhibition MAHL from HWA(lbs/day)=> 1.1716 Uncontrollable Loading(lbs/day)_> 0.0323 Total Allowable for Industry(MAIL)(lbs/day)=> 1.1392 Total Permitted to Industry(lbs/day)_> 0.0513 MAIL left(lbs/day)_> 1.0879 Percent Allow.Ind.(MAIL)still available(%)=> 95.5% Percent MAHL still available(%)_> 92.9% 5 Percent MAHL(lbs/day)=> 0.0586 HWA.AT Revised:November 2005 Workbook Name : HWA 2018, Worksheet Name: AT Printed: 5/25/2018, 10:09 AM Page 5 of 6 Allocation Table Headworks last approved: 10/29/12 Allocation Table updated: 03/05/13 Permits last modified: 09/05/17 Pores— Murphy WWTP NPDES#=> NC0020940 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 l (please listalphabeticly) number number mg/I lbs/day mg/1 lbs/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day 1 MGM 0003 _ 0001 1.0000 0.0475 1 _ 2 MOOG 0001 0001 1. . 3 SNAP ON 0005 0001 0.9960 0.1661 4 ~~ , s-. �� �� 5 6 7 - , 8 . � .. .1sssssssssa• 1 9 _ 10 I 1 ._____4 Column Totals=> 0.2137 0.00 0.00 0.0000 0.0000 t 0.00001 AS/Nit/TF Basis=> inhibition MAHL from HWA(lbs/day)_> 4.6862 Uncontrollable Loading(lbs/day)_> 2.8130 Total Allowable for Industry(MAIL)(lbs/day)_> 1.8733 Total Permitted to Industry(lbs/day)=> 0.2137 0.00 0.0.0 0.0000 0.0000 0.0000 MAIL left(lbs/day)_> 1.6596 Percent Allow.Ind.(MAIL)still available(%)_> 88.6% ####### ####### ####### ####### ####### Percent MAHL still available(%)_> 35.4% ####### ####### ####### ####### ####### 5 Percent MAHLlbs/da => 0.2343 ( Y) HWA.AT Revised:November 2005 Workbook Name : HWA 2018, Worksheet Name: AT Printed: 5/25/2018, 10:09 AM Page 6 of 6 Allocation Table Headworks last approved: 10/29/12 Allocation Table updated: 03/05/13 Permits last modified: 09/05/17 Pores=. Murphy WWTP NPDES#K> NC0020940 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 (please listelphabeucIy) number number mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day 1 MGM 0003 0001 • 2 MOOG 0001 0001 3 SNAP ON 0005 0001 4 5 i r 6 7 8 9 10 Column Totals=> 0.0000 0.00001 I 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(%)_> ####### ####### ####### ####### Percent MAHL still available(%)=> ####### ####### ####### ####### 5 Percent MAHLlbs/da => ( Y) HWA.AT Revised:November 2005 +. 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/I lbs/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day 1 MGM 001/001 0.00192 1,920 7.06 0.11 30.075 0.48 0.675 0.0108 0.006575 0.0001 2 MOOG 003/001 0 0 0.00 0 0.00 0 0.0000 0 0.0000 3 SNAP ON 005/001 0.0136 13,600 2.93 0.33 35.6583 4.040.675 0.0766 0.0001 4 5 6 ......1 7 8 9 10F. ____ ______ _ 11 ,.......... ,.... . 1 _.... I 12 13 Sum of Industrial Loading(lbs/day)=> 0.0155 15520 I 0.4454 4.5261 r 0.0874 0.0002 MGD gal/day mg/I lbs/day mg/I lbs/day mg/1 lbs/day mg/1 lbs/day Avg Influent loading(lbs/day)=4 0.56186 561,860 166.86281 82.945361 388.671 1 1 0.00251 0.0117 Uncontrollable Load from Mass Bal(lbs/day)_> 0.5463 781.4590 384.1485 ######## 0.0115 Uncontrollable Concen. from Mass Bal(mg/L)=> 1 1721 I 841 1########1 I 0.00251 Uncont. from Uncont. Sampling(mg/L+lbs/day)_> 192.5 877.12 132.3 602.82 25.7 117.10 0.005 0.0228 Uncontrollable Concen.From Literature(mg/L)_> 1 2501 1 250J 1 251 I 0.003] Uncontrollable conc.to be used in HWA(mg/L)_> 192.5 132.3 25.7 0.005 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. Mass Balance 2018 SIU.Uncont.Mass.Bal Page 1 of 5 pages 5/25/2018, 10:16 AM Revision:August 1999 . SIU.Uncont.Mass.Bal FLOW CADMIUM CHROMIUM COPPER CYANIDE 1 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/I lbs/day mg/1 lbs/day mg/1 lbs/day 1 IMGM 001/001 0.00192 1,920 0.001 0.0000 0.005 0.0001 0.03543 0.0006 0.004 0.0001 2 MOOG 003/001 0 0 0.0000 0 0.0000 0 0.0000 0 0.0000 3 SNAP ON 005/001 0.0136 13,600 0.005 0.0006 0.05216 0.0059 0.0434 0.0049 0.004 0.0005 4 5 . 6 7 8 9 ....... I 10 11 12 13 Sum of Industrial Loading(lbs/day)_> 0.0155� 15520 I 0.0006- 0.0060 0.0055 0.0005 MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/1 lbs/day mg/I lbs/day Avg Influent loading(lbs/day)_>` 0.561861 561,8601 0.001 0.02341 0.021 0.11711 0.0251 0.11711 0.0041 0.0187 Uncontrollable Load from Mass Bal(lbs/day)=> 0.5463 0.0228 0.1112 0.1117 0.0182 Uncontrollable Concen. from Mass Bal(mg/L)_> 1 0.00501 I0.02441 0.0245J l 0.00401 Uncont. from Uncont. Sampling(mg/L+lbs/day)_> 0.0005 0.0023 0.0025 0.0114 0.0733 0.3340 0.004 0.0182 Uncontrollable Concen. From Literature(mg/L)_> 1 0.0031 1 0.051 1 0.0611 1 0.0411 Uncontrollable conc. to be used in HWA(mg/L)_> 0.0005 0.0025 0.0733 0.004 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. Mass Balance 2018 SIU.Uncont.Mass.Bal Page 2 of 5 pages 5/25/2018, 10:16 AM Revision:August 1999 SIU.Uncont.Mass.Bal FLOW LEAD MERCURY MOLYBDENUM NICKEL INDUSTRY Industry Average Discharge Average Discharge Average Discharge Average Discharge Average Discharge IUP NAMES Permit/Pipe Conc. Load Conc. Load Conc. Load Conc. Load Count (please list alphabetically) number MGD gal/day mg/1 lbs/day mg/1 lbs/day mg/I lbs/day mg/I lbs/day 1 MGM 001/001 0.00192 1,920 0.0025 0.0000 0.0001 0.00000 0.007113 0.0001 0.01464 0.0002 2 MOOG 003/001 0 0 0.0000 0 0.00000 0 0.0000 0 0.0000 3 SNAP ON 005/001 0.0136 13,600 0.0423 0.0048 0.0001 0.00001 0.0531 0.0060 0.02355 0.0027 4 5 6 7 8 9 10 11 INNN 12 _ 13 Sum of Industrial Loading(lbs/day)=> 0.01551 15520 0.0048 0.00001 0.0061 ( 0.0029 MGD gal/day mg/I lbs/day mg/1 lbs/day mg/I lbs/day mg/1 lbs/day Avg Influent loading(1bs/day)_>` 0.56186 561,860 0.00151 0.00701 0.000211 0.000981 0.00251 0.01171 0.0251 0.1171 Uncontrollable Load from Mass Bal(lbs/day)=> 0.5463 0.0022 0.00097 0.0056 0.1142 Uncontrollable Concen. from Mass Bal(mg/L)_> I 0.00051 0.000211 1 0.00121 1 0.02511 Uncont. from Uncont. Sampling(mg/L+lbs/day)_> 0.0025 0.0114 0.0001 0.0005 0.0025 0.0114 0.0076 0.0346 Uncontrollable Concen. From Literature(mg/L)_> I 0.0491 0.00031 1 1 1 0.0211 Uncontrollable conc. to be used in HWA(mg/L)_> 0.0025 0.0001 0.0025 0.0076 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. Mass Balance 2018 SIU.Uncont.Mass.Bal Page 3 of 5 pages 5/25/2018, 10:16 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/I lbs/day mg/1 lbs/day 1 MGM 001/001 0.00192 1,920 0.0001 0.0000 0.0025 0.0000 0.07916 0.0013 9.35 0.1497 2 MOOG 003/001 0 0 0.0000 0 0.0000 0 0.0000 0 0.0000 3 SNAP ON 005/001 0.0136 13,600 0.0001 0.0000 0.025 0.0028 0.01256 0.0014 22.8333 2.5898 4 5 6 7 1111111111•11111111.111111.1 ,1118 9 10 11 12 13 _ Sum of Industrial Loading(lbs/day)=> 0.01551 15520 I 0.0000 0.0029 I 0.0027 1 2.7396 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.561861 561,8601 0.005, 0.0234 0.025 0.1171 0.165 0.77321 I Uncontrollable Load from Mass Bal(lbs/day)=> 0.5463 0.0234 0.1143 0.7705 ######## Uncontrollable Concen. from Mass Bal(mg/L)=> 1 0.00511 1 0.02511 0.16911 1########J Uncont. from Uncont. Sampling(mg/L+lbs/day)_> 0.005 0.0228 0.0071 0.0324 0.6174 2.8132 58.114 264.7950 Uncontrollable Concen. From Literature(mg/L)_> r 0.0051 I 0.1711 r 501 Uncontrollable conc.to be used in HWA(mg/L)_> 0.005 0.0071 0.6174 58.14 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. Mass Balance 2018 SIU.Uncont.Mass.Bal Page 4 of 5 pages 5/25/2018, 10:16 AM Revision:August 1999 a 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 MGM 001/001 0.00192 1,920 2 MOOG 003/001 0 3 SNAP ON 005/001 0.0136 13,600 4 5 6 7 8 9 10 11 12 13 Sum of Industrial Loading(lbs/day)=> 0.0155 15520 ) 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)=>I1 0.56186 561,860 Uncontrollable Load from Mass Bal(lbs/day)_> 0.5463 Uncontrollable Concen. from Mass Bal(mg/L)=> Uncont. from Uncont. Sampling(mg/L+lbs/day)_> I Uncontrollable Concen. From Literature(mg/L)_> Uncontrollable conc. to be used in HWA(mg/L)_> 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. Mass Balance 2018 SIU.Uncont.Mass.Bal Page 5 of 5 pages 5/25/2018, 10:16 AM Revision:August 1999 Removal Rate Calculations FLOW BOD TSS AMMONIA Influent Used in Effluent Used in Intlucnt Used inII Used in Influent Used in Effluent Sample Date mgd < mg/L Calculation < m_ Calculation < mg/L Calculation < Calculation < mg/L Calculation < mg/L, 3/1/2015 Spreadsheet 0.514 127.8462 127.8462 12.15 12.15 69.6154 69.6154 26.55 26.55 2.4385 Instructions: �� isomms 9/1/2015 1) Data 0.533553 196.1786 196,1786 7.421429 7.421429 196.1786 196.1786_ 3.514286 3.514286 0.442857 12/1/2015 enHeavteryed only in 0.7 1 177.1333177.133_ 7.209524 7 209524 ` 123.7333 123.7333 i. 7.97333 7.97333 0.71333 I 3/1/2016 Bordered cells. 0.5�� 1�0 160.7333 8.81333 8.81333 88 9.96 9.96 0.77333 Rest of �� �� 6/1/2016 worksheet is 0.714 204.3571 204.3571 15.20714 15.20714 23.42857 23.42857 9.192857 9.192857 2.3 9/1/2016 propasswordcted,te is 0.472367 2 6� 262.6538- 12.65385 12.65385 137.9� 137.9231 - 10.06154 10.06154 0.653846 12/1/2016 ',2„. 0.505452 125.7917 125.7917 14.69167 14.69167 _ 29.1 29.1 _ 12.89167 12.89167 3.6 3/1/2017 2) For below 0.550516 183.8571183.8571 _ 13.27143 13.27143 128.7857 128.7857 8.042857 8.042857 _� 8.442857 6/1/2017 detectionedata, 0.575267 160.1538160.1538 _ 14.10769 14.10769 _ 104.6154 104.6154 7.115385 7.115385 ~- 7.423077 9/1/2017 column,and 0.535967142 _ 10.066 10.066 _ 37.5 37.5 ~ 20.966 20.966 -� 0.53333 enter detection 11/1/2017 level inu influent 0.4941 ~ 135.8571 135.8571 8.335714 8.335714 27.36429 27.36429 I" 7.721429 7.721429 0.592857 or Effluent - �r _ 12/1/2017 mo columns. 0.505452 125.7917 125.7917 14.69167 14.69167 29.1 29.1 12.89167 12.89167 3.6 Spreadsheet t� �� will auto- matically No I r calculate .11// __ IMMEM � averages and removal rates •--- 1 using 1/2 value entered. �,•••• ""tee 'r I 3)Document �s r. o - removal Rate imimmum no 1 .ns to choice 4)Formulas in Compre - min � hensive Guide , r HWA Chapter, Column Averages=> Section E, 0.56186 166.8628 11.55162 82.94536 11.40675 page 1. Unpaired Site Specific RR=> 93.08% Unpaired Site Specific RR=> 86.25% Unpaired Site Specific RR=> Literature/Default RR=> 85.00% Literature/Default RR=> 85.00% Literature/Default RR=> 0 °o of data is BDL 0 % of data is BDL 0 % of data is BDL RR for this HWA=> 93.00% RR for this I I WA=> 86.00% RR for this HWA=> Removal Rate Spreadsheet 2018 Removal Rates Page 1 of 8 pages 5/25/2018, 10:34 AM Revision:August 1999 Removal Rate Calculations Used in Sample Date Calculation 3/1/2015 2.4385 9/1/2015 0.442857 12/1/2015 0.71333 3/1/2016 0.77333 6/1/2016 2.3 9/1/2016 0.653846 12/1/2016 3.6 3/1/2017 8.442857 6/1/2017 7.423077 9/1/2017 0.53333 11/1/2017 0.592857 12/1/2017 3.6 Column Averages=> 2.626165 0 85.00% 85.00% Removal Rate Spreadsheet 2018 Removal Rates Page 2 of 8 pages 5/25/2018, 10:34 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 < m• L Calculation <, mg/L Calculation < mg/L Calculation 3/1/2015 I _ 9/1/2015 12/1/2015 ........ 3/1/2016 6/1/2016 M= _ 9/1/2016 12/1/2016 / - — ♦ — I - 3/1/2017 6/1/2017 < 0.005 0.0025 < 0.005 0.0025 < 0.01 0.005 < 0.01 0.005 < 0.05 0.025 < 0.05 (L025 IMIIIMMININIII 11=1111=11P MI `I MI 9/1/2017 �� ► �� 11/1/2017 ...�� a - f 12/1/2017 ..��. ., MMP ••••11MINIIIII M S 4/ Column Averages=> 0.0025 0.0025 0.0050 0.0050 0.0250 0.0250 Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=>F5.77.7, Unpaired Site Specific RR=>F7377-3D1 Literature/Default RR=> 45.00% Literature/Default RR=> 67.00% Literature/Default RR=> 82.00% 100 %of data is BDL 100 % of data is BDL 100 %of data is BDL RR for this HWA=> 45.00% RR for this HWA=> 67.00% RR for this HWA= 82.00% Removal Rate Spreadsheet 2018 Removal Rates Page 3 of 8 pages es 9 5/25/2018, 10.34 AM Revision:August 1999 Removal Rate Calculations COPPER CYANIDE LEAD Influent l,scd 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 < m L Calculation < mg/L Calculation < mg/L Calculation 3/1/2015 9/1/2015 12/1/2015 3/1/2016 '. .-------- 6/1/2016 9/1/2016 12/1/2016 3/1/2017 _ _ 6/1/2017 0.05 0.025 < 0.05 0.025 0.008 0.004 r_�� 0.004 0.0015 < 0.003 0.0015 1 .. — 1 ... 9/1/2017 '+•11MINNIMMIN ... ...m... 1 �............ �� 11/1/2017 �. I — — . �� ...... ...... 12/1/2017 Irk ► I �.� ., .. - - ft--.... IMINEIMIMIN MIW .. . - I .. "1 AMIN • / 11..-. --.... I '� �- i 1•1111 Ilnir IMIIMIMIP IMI MI e MN 1 M' \ MR i �� _�-- 14MI 11•111=1111111•MMI MI ,I r Column Averages=> 0.0250 0.0250 0.0040 0.0040 0.0015 0.0015 Unpaired Site Specific RR=>T5-6-= Unpaired Site Specific RR=>F67-1317 Unpaired Site Specific RR=> 50%BDI Literature/Default RR=> 86.00% Literature/Default RR=> 69.00% Literature/Default RR=> 61.00% 100 °i, of data is BDL 100 %of data is BDL 100 00 of data is BDL RR for this HWA=> 86.00% RR for this HWA='> 69.00% RR for this HWA= 61.00% Removal Rate Spreadsheet 2018 Removal Rates Page 4 of 8 pages 5/25/2018, 10:34 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 < mg/L Calculation < mg/L Calculation < m_ Calculation < m: L Calculation < mg/L Calculation < mg/L Calculation 3/1/2015 9/1/2015 12/1/2015 < 0.0002 0.0001 �� ... 3/1/2016 �< 0.0002 0.0001 6/1/2016' .1 < 0.0002 0.0001 p_______ . 9/1/2016 < 0.0002 0.0001 - ... 12/1/2016 < 0.0002 0.0001 3/1/2017 < 0.0002 0.0001 �- 6/1/2017 0.00021 0.00021 < 0.0002 0.0001 < 0.005 0.0025 < 0.005 0.0025 < 0.05 0.025 < 0.05 0.025 I� . - I r..��. 9/1/2017 < 0.0002 0.0001 ... �� - , 11/1/2017 < 0.002 0.001 12/1/2017 I _.-.. ►---�� - ' I IMMEIMMIMIIIMIINI IMI MN IN.- --- iilliinNIMMIP �� N -- IMMIIMINIMMINEMMIIr ----ter MI bIMI MMIIIIIMMMMMIMIMI , ...� - . .IMMI. I - M .. _ r.,.e • M - N ..� I .ter Me . - I MI AMP, / Mb - Column Averages=> 0.00021 0.00020 0.0025 0.0025 0.0250 0.0250 Unpaired Site Specific RR=>F717= Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=> 50%BDI Literature/Default RR=> 60.00% Literature/Default RR=> 33.00% Literature/Default RR=> 42.00% 90 % of data is BDL 100 °4, of data is BDL 100 % of data is BDL RR for this HWA=> 60.00% RR for this HWA=> 33.00% RR for this HWA 42.00% Removal Rate Spreadsheet 2018 Removal Rates Page 5 of 8 pages 5/25/2018, 10:34 AM Revision:August 1999 Removal Rate Calculations SELENIUM 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 3/1/2015 < 0.05 0.025 .1i.. �. 9/1/2015 12/1/2015 _� < 0.05 0.025 .i. 3/1/2016 < 0.05 0.025 6/1/2016 < 0.05 0.025 r_� . . — 9/1/2016 _ < 0.05 0.025 12/1/2016 0.05 0.025 �— . - �� �.. 3/1/2017 < 0.05 0.025 6/1/2017 < 0.01 0.005 < 0.01 0.005 < 0.05 0.025 < 0.05 0.025 0.165 0.165 < 0.1 0.05 9/1/2017 < 0.005 0.0025 11/1/2017 < 0.005 0.0025 12/1/2017 r , .M �..� MN n r r INIMMII MEMINIMMOINIMMIM OW NMI INE .1111111•11111111 �� E �� INE MINIMMIIM ..I MINOI a NM I �� A ter. Column Averages=> 0.0050 0.0050 0.0250 0.0205 0.1650 0.0500 Unpaired Site Specific RR—>F757717, Unpaired Site Specific RR=> 50%BDL Unpaired Site Specific RR=> 69.70 Literature/Default RR=> 50.00% Literature/Default RR=> 75.00% Literature/Default RR=> 79.00% 100 % of data is BDL 100 % of data is BDL 50 %of data is BDL RR for this HWA=> 50.00% RR for this HWA=> 75.00% RR for this HWA=> 79.00% Removal Rate Spreadsheet 2018 Removal Rates Page 6 of 8 pages 5/25/2018, 10:34 AM Revision:August 1999 Removal Rate Calculations Oil &Grease Influent Used in I illucnt t:,cd 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 < m• L Calculation < m./L Calculation 3/1/2015 .. , 1 - 9/1/2015 .. 1............• 12/1/2015 _ 3/1/2016 — p I 6/1/2016 9/1/2016 IMIMMINMINIMIVIMP '1 . .. 12/1/2016 ...,, . ,... ., I 3/1/2017 ..�� 6/1/2017 _ 9/1/2017 .. , -- _ INIMIIMMi 11/1/2017 1 - 12/1/2017 .. 1 _ .. I r.. VIM. .---, I.. .r 11.-- I - —L �onomilmonl .. ...IIMINNIonen Yr miii.mommomon Mlmr IMMIn �nik. a �1r Column Averages=> Unpaired Site Specific RR=>II Unpaired Site Specific RR=>0 Unpaired Site Specific RR=> Literature/Default RR=>— Literature/Default RR=>II Literature/Default RR=> of data is BDL of data is BDL of data is BDL RR for this HWA=>— RR for this HWA=>I RR for this HWA=> Removal Rate Spreadsheet 2018 Removal Rates Page 7 of 8 pages 5/25/2018, 10:34 AM Revision:August 1999 Removal Rate Calculations Influent Used in Effluent Used in Influent Used in Effluent Used in InfluentUsed in Effluent Used in Sample Date < m /L Calculation < m Calculation < m1/1, Calculation <, mg/L Calculation < mg/L �Calculation < mg/L Calculation 3/1/2015 ..-- 9/1/2015 I 12/1/2015 _ A.1 3/1/2016 6/1/2016 9/1/2016 ......._ .. 12/1/2016 4111 IMI ._ oin. .rte �- 3/1/2017 ..lam 6/1/2017 _ _ _ 9/1/2017 11/1/2017 PM 1 i 12/1/2017 ...�� I r....410, M I _ 1 �EMIIMINI NM . IIMMIONIMMINIminl i ► WINII1 r , MI MI ` I. 1- 1 I MI 1..11 �� `I iI Column Averages=> Unpaired Site Specific RR=> Unpaired Site Specific RR=>II Unpaired Site Specific RR=> Literature/Default RR=>II Literature/Default RR=>II Literature/Default RR=>I�.I of data is BDL of data is BDL of data is BDL RR for this HWA=>II RR for this HWA=>II RR for this HWA=1 Removal Rate Spreadsheet 2018 Removal Rates Page 8 of 8 pages 5/25/2018, 10:34 AM Revision:August 1999