### Appendix D 

# DR AFTNRGOswegoHar borPowerBi

-Weekly

Impingement at Maximum Plant Design Flow

PleaseNote: this is Unit

-5dataTableandIassumecolumns of interesttoEPA relative to Raw IM data= : “Date”,Collection Period”(may be?), “Common Name”, and “Total [i,e,,RAW] Number Collected”

### Appendix D

Date Collection

Period Time

StartTime

EndSpecies Code Common Name Total Number Collected Number

Collected per 100m3 flow AdjustedTotal by

Collection Period

4/8/2006 1 9:00 15:00 446 Stonecat 1 0.0002 1

8 4/8/2006 1 9:00 15:00 614 Tessellated Darter 1 0.0002 1 4/8/2006 1 9:00 15:00 617 Yellow Perch 1 0.0002 1 4/8/2006 1 9:00 15:00 600 Smallmouth Bass 1 0.0002 1 4/8/2006 1 9:00 15:00 381 Emerald Shiner 1 0.0002 1 4/8/2006 1 9:00 15:00 960 Goby 1 0.0002 1 4/8/2006 1 9:00 15:00 865 Mottled Sculpin 2 0.0004 2 4/8/2006 2 15:0021:00 960 Goby 1 0.0002 1 2 4/8/2006 2 15:0021:00 865 Mottled Sculpin 1 0.0002 1 4/8/2006 3 21:00 3:00 381 Emerald Shiner 3 0.0007 3

7 4/8/2006 3 21:00 3:00 335 Rainbow Smelt 2 0.0004 2 4/8/2006 3 21:00 3:00 865 Mottled Sculpin 1 0.0002 1 4/8/2006 3 21:00 3:00 617 Yellow Perch 1 0.0002 1 4/9/2006 4 3:00 9:00 381 Emerald Shiner 2 0.0004 2 3 4/9/2006 4 3:00 9:00 609 Fantail Darter 1 0.0002 1 4/22/2006 1 10:00 16:00 NA NA 0 0.0000 0 0 4/22/2006 2 16:0022:00 NA NA 0 0.0000 0 0 4/22/2006 3 22:00 4:00 NA NA 0 0.0000 0 0 4/23/2006 4 4:00 10:00 NA NA 0 0.0000 0 0 5/6/2006 1 10:00 16:00 NA NA 0 0.0000 0 0 5/6/2006 2 16:0022:00 NA NA 0 0.0000 0 0 5/6/2006 3 22:00 4:00 617 Yellow Perch 1 0.0002 1 1 5/7/2006 4 4:00 10:00 NA NA 0 0.0000 0 0 5/20/2006 1 10:00 16:00 960 Goby 1 0.0002 1 1 5/20/2006 2 16:0022:00 617 Yellow Perch 2 0.0004 2 4 5/20/2006 2 16:0022:00 562 Threespine Stickleback 1 0.0002 1 5/20/2006 2 16:0022:00 596 Pum pkinseed 1 0.0002 1 5/20/2006 3 22:00 4:00 562 Threespine Stickleback 1 0.0002 1 3 5/20/2006 3 22:00 4:00 960 Goby 2 0.0004 2 5/21/2006 4 4:00 10:00 390 Spottail Shiner 1 0.0002 1 1 6/3/2006 1 10:00 16:00 960 Goby 1 0.0002 1 1 6/3/2006 2 16:0022:25 562 Threespine Stickleback 1 0.0002 1 1 6/3/2006 3 22:25 4:05 NA NA 0 0.0000 0 0 6/4/2006 4 4:05 10:00 NA NA 0 0.0000 0 0 6/19/2006 1 10:00 16:00 289 Alewife 2 0.0004 2 2 6/19/2006 2 16:0022:00 562 Threespine Stickleback 1 0.0002 1 3 6/19/2006 2 16:0022:00 381 Emerald Shiner 1 0.0002 1 6/19/2006 2 16:0022:00 960 Goby 1 0.0002 1 6/19/2006 3 22:00 4:00 446 Stonecat 1 0.0002 1 6 6/19/2006 3 22:00 4:00 289 Alewife 5 0.0011 5 6/20/2006 4 4:00 10:00 600 Smallmouth Bass 1 0.0002 1 2 6/20/2006 4 4:00 10:00 289 Alewife 1 0.0002 1 7/1/2006 1 10:00 16:00 NA NA 0 0.0000 0 0 7/1/2006 2 16:0022:00 960 Goby 1 0.0002 1 1 7/1/2006 3 22:00 4:00 NA NA 0 0.0000 0 0 7/1/2006 4 4:00 10:00 NA NA 0 0.0000 0 0

### Appendix D

Date Collection

Period Time

Start Time

EndSpecies Code Common Name Total Number Collected Number

Collected per 100m3 flow AdjustedTotal by

Collection Period
7/15/2006 1 10:00 16:00 NA NA 0 0.0000 0 0 7/15/2006 2 16:0022:00 NA NA 0 0.0000 0 0 7/15/2006 3 22:00 4:00 600 Smallmouth Bass 2 0.0004 2 2 7/16/2006 4 4:00 10:00 600 Smallmouth Bass 1 0.0002 1 2 7/16/2006 4 4:00 10:00 960 Goby 1 0.0002 1 7/29/2006 1 10:00 16:00 NA NA 0 0.0000 0 0 7/29/2006 2 16:0022:00 NA NA 0 0.0000 0 0 7/29/2006 3 22:00 4:00 600 Smallmouth Bass 1 0.0002 1 2 7/29/2006 3 22:00 4:00 335 Rainbow Smelt 1 0.0002 1 7/30/2006 4 4:00 10:00 562 Threespine Stickleback 1 0.0002 1 1 8/12/2006 1 10:00 16:00 NA NA 0 0.0000 0 0 8/12/2006 2 16:0022:00 617 Yellow Perch 1 0.0002 1 2 8/12/2006 2 16:0022:00 446 Stonecat 1 0.0002 1 8/12/2006 3 22:00 4:00 600 Smallmouth Bass 1 0.0002 1 1 8/13/2006 4 4:00 10:00 600 Smallmouth Bass 1 0.0002 1 1 8/26/2006 1 10:00 16:00 NA NA 0 0.0000 0 0 8/26/2006 2 16:0022:00 NA NA 0 0.0000 0 0 8/27/2006 3 22:00 4:00 NA NA 0 0.0000 0 0 8/27/2006 4 4:00 10:00 NA NA 0 0.0000 0 0 9/9/2006 1 10:00 16:00 600 Smallmouth Bass 1 0.0002 1 1 9/9/2006 2 16:0022:00 NA NA 0 0.0000 0 0 9/9/2006 3 22:00 4:00 NA NA 0 0.0000 0 0 9/10/2006 4 4:00 10:00 NA NA 0 0.0000 0 0 9/23/2006 1 10:00 16:00 446 Stonecat 1 0.0002 1 1 9/23/2006 2 16:0022:00 NA NA 0 0.0000 0 0 9/23/2006 3 22:00 4:00 NA NA 0 0.0000 0 0 9/24/2006 4 4:00 10:00 NA NA 0 0.0000 0 0 10/7/2006 1 10:00 16:00 600 Smallmouth Bass 1 0.0002 1 1 10/7/2006 2 16:0022:00 NA NA 0 0.0000 0 0 10/8/2006 3 22:00 4:00 289 Alewife 1 0.0002 1 1 10/8/2006 4 4:00 10:00 NA NA 0 0.0000 0 0 10/21/2006 1 10:00 16:00 600 Smallmouth Bass 1 0.0002 1 2 10/21/2006 1 10:00 16:00 446 Stonecat 1 0.0002 1 10/21/2006 2 16:00 11:00 NA NA 0 0.0000 0 0 11/4/2006 1 11:00 17:00 446 Stonecat 1 0.0002 1
6 11/4/2006 1 11:00 17:00 575 White Perch 2 0.0004 2 11/4/2006 1 11:00 17:00 598 Bluegill 2 0.0004 2 11/4/2006 1 11:00 17:00 294 Gizzard Shad 1 0.0002 1 11/4/2006 2 17:0023:00 562 Threespine Stickleback 1 0.0002 1 4 11/4/2006 2 17:0023:00 294 Gizzard Shad 2 0.0004 2 11/4/2006 2 17:0023:00 960 Goby 1 0.0002 1 11/5/2006 3 23:00 5:00 294 Gizzard Shad 1 0.0002 1 1 11/5/2006 4 5:00 11:00 NA NA 0 0.0000 0 0

### Appendix D

Date Collection

Period Time

Start Time

EndSpecies Code Common Name Total Number Collected Number

Collected per 100m3 flow AdjustedTotal by

Collection Period
11/18/2006 1 10:00 16:00 600 Smallmouth Bass 1 0.0002 1 2 11/18/2006 1 10:00 16:00 289 Alewife 1 0.0002 1 11/18/2006 2 16:0022:00 NA NA 0 0.0000 0 0 11/19/2006 3 22:00 4:00 NA NA 0 0.0000 0 0 11/19/2006 4 4:00 10:00 NA NA 0 0.0000 0 0 12/2/2006 1 10:00 16:00 617 Yellow Perch 7 0.0031 7

12 12/2/2006 1 10:00 16:00 960 Goby 1 0.0004 1 12/2/2006 1 10:00 16:00 390 Spottail Shiner 2 0.0009 2 12/2/2006 1 10:00 16:00 446 Stonecat 1 0.0002 1 12/2/2006 1 10:00 16:00 600 Smallmouth Bass 1 0.0002 1 12/2/2006 2 16:0022:00 617 Yellow Perch 3 0.0007 3 9 12/2/2006 2 16:0022:00 390 Spottail Shiner 4 0.0009 4 12/2/2006 2 16:0022:00 960 Goby 2 0.0004 2 12/2/2006 3 22:00 4:00 960 Goby 4 0.0009 4 14 12/2/2006 3 22:00 4:00 575 White Perch 3 0.0007 3 12/2/2006 3 22:00 4:00 617 Yellow Perch 7 0.0016 7 12/3/2006 4 4:00 10:00 335 Rainbow Smelt 1 0.0002 1

17 12/3/2006 4 4:00 10:00 390 Spottail Shiner 1 0.0002 1 12/3/2006 4 4:00 10:00 575 White Perch 3 0.0007 3 12/3/2006 4 4:00 10:00 446 Stonecat 1 0.0002 1 12/3/2006 4 4:00 10:00 960 Goby 6 0.0013 6 12/3/2006 4 4:00 10:00 617 Yellow Perch 5 0.0011 5 12/16/2006 1 10:00 16:00 600 Smallmouth Bass 5 0.0022 5

32 12/16/2006 1 10:00 16:00 617 Yellow Perch 3 0.0013 3 12/16/2006 1 10:00 16:00 335 Rainbow Smelt 1 0.0004 1 12/16/2006 1 10:00 16:00 960 Goby 1 0.0004 1 12/16/2006 1 10:00 16:00 390 Spottail Shiner 7 0.0031 7 12/16/2006 1 10:00 16:00 381 Emerald Shiner 15 0.0067 15 12/16/2006 2 16:0022:00 381 Emerald Shiner 2 0.0004 2 3 12/16/2006 2 16:0022:00 289 Alewife 1 0.0002 1 12/17/2006 4 4:00 10:00 294 Gizzard Shad 2 0.0004 2 5 12/17/2006 4 4:00 10:00 390 Spottail Shiner 2 0.0004 2 12/17/2006 4 4:00 10:00 381 Emerald Shiner 1 0.0002 1 12/30/2006 1 10:00 16:00 NA NA 0 0.0000 0 0 12/30/2006 2 16:0022:00 NA NA 0 0.0000 0 0 12/31/2006 3 22:00 4:00 NA NA 0 0.0000 0 0 12/31/2006 4 4:00 10:00 390 Spottail Shiner 1 0.0002 1 1 1/13/2007 1 10:00 16:00 381 Emerald Shiner 1 0.0002 1 1 1/13/2007 2 16:0022:00 865 Mottled Sculpin 1 0.0002 1 1 1/14/2007 3 22:00 4:00 390 Spottail Shiner 1 0.0002 1 1 1/14/2007 4 4:00 10:00 390 Spottail Shiner 1 0.0002 1 1 1/27/2007 1 10:00 16:00 381 Emerald Shiner 1 0.0002 1 1 1/27/2007 2 16:0022:00 600 Smallmouth Bass 1 0.0002 1 2 1/27/2007 2 16:0022:00 960 Goby 1 0.0002 1 1/27/2007 3 22:00 4:00 335 Rainbow Smelt 1 0.0002 1 2 1/27/2007 3 22:00 4:00 600 Smallmouth Bass 1 0.0002 1 1/28/2007 4 4:00 10:00 617 Yellow Perch 1 0.0002 1 1 Date CollectionTimeTimeSpecies Common Name Total Number AdjustedTotal by

### Appendix D Period Start End Code Number CollectedCollected

per 100m3 flow Collection Period

2/9/2007 1 10:00 16:00 600 Smallmouth Bass 5 0.0011 5
13 2/9/2007 1 10:00 16:00 591 Rock Bass 2 0.0004 2 2/9/2007 1 10:00 16:00 390 Spottail Shiner 1 0.0002 1 2/9/2007 1 10:00 16:00 960 Goby 5 0.0011 5 2/9/2007 2 16:0022:00 381 Emerald Shiner 4 0.0009 4 6 2/9/2007 2 16:0022:00 960 Goby 2 0.0004 2 2/10/2007 3 22:00 4:00 591 Rock Bass 2 0.0004 2
18 2/10/2007 3 22:00 4:00 960 Goby 2 0.0004 2 2/10/2007 3 22:00 4:00 335 Rainbow Smelt 9 0.0020 9 2/10/2007 3 22:00 4:00 381 Emerald Shiner 5 0.0011 5 2/10/2007 4 4:00 10:00 335 Rainbow Smelt 4 0.0009 4

10 2/10/2007 4 4:00 10:00 617 Yellow Perch 1 0.0002 1 2/10/2007 4 4:00 10:00 562 Threespine Stickleback 1 0.0002 1 2/10/2007 4 4:00 10:00 960 Goby 1 0.0002 1 2/10/2007 4 4:00 10:00 575 White Perch 1 0.0002 1 2/10/2007 4 4:00 10:00 381 Emerald Shiner 2 0.0004 2 2/24/2007 1 10:00 16:00 600 Smallmouth Bass 2 0.0004 2 5 2/24/2007 1 10:00 16:00 960 Goby 3 0.0007 3 2/24/2007 2 16:0022:00 600 Smallmouth Bass 1 0.0002 1

5 2/24/2007 2 16:0022:00 390 Spottail Shiner 1 0.0002 1 2/24/2007 2 16:0022:00 381 Emerald Shiner 1 0.0002 1 2/24/2007 2 16:0022:00 960 Goby 2 0.0004 2 2/25/2007 3 22:00 4:00 NA NA 0 0.0000 0 0 2/25/2007 4 4:00 10:00 NA NA 0 0.0000 0 0 3/6/2007 1 10:00 16:00 960 Goby 23 0.0052 23

39 3/6/2007 1 10:00 16:00 381 Emerald Shiner 9 0.0020 9 3/6/2007 1 10:00 16:00 591 Rock Bass 1 0.0002 1 3/6/2007 1 10:00 16:00 390 Spottail Shiner 1 0.0002 1 3/6/2007 1 10:00 16:00 461 Trout Perch 1 0.0002 1 3/6/2007 1 10:00 16:00 335 Rainbow Smelt 1 0.0002 1 3/6/2007 1 10:00 16:00 865 Mottled Sculpin 3 0.0007 3 3/6/2007 2 16:0022:00 381 Emerald Shiner 5 0.0011 5 12 3/6/2007 2 16:0022:00 960 Goby 7 0.0016 7 3/7/2007 3 22:00 4:00 562 Threespine Stickleback 1 0.0002 1 6 3/7/2007 3 22:00 4:00 960 Goby 4 0.0009 4 4 3/7/2007 3 22:00 4:00 381 Emerald Shiner 1 0.0002 1 1 3/7/2007 4 4:00 10:00 960 Goby 4 0.0009 4 7 3/7/2007 4 4:00 10:00 335 Rainbow Smelt 1 0.0002 1 3/7/2007 4 4:00 10:00 381 Emerald Shiner 2 0.0004 2 3/24/2007 1 10:00 16:00 600 Smallmouth Bass 2 0.0004 2 4 3/24/2007 1 10:00 16:00 960 Goby 2 0.0004 2 3/24/2007 2 16:0022:00 617 Yellow Perch 1 0.0002 1 1 3/25/2007 3 22:00 4:00 960 Goby 1 0.0002 1 1 3/25/2007 4 4:00 10:00 NA NA 0 0.0000 0 0

### Appendix D

Date Collection

Period Time

Start Time

EndSpecies Code Common Name Total Number Collected Number

Collected per 100m3 flow AdjustedTotal by

Collection Period
4/7/2007 1 10:00 16:00 960 Goby 5 0.0011 5
14 4/7/2007 1 10:00 16:00 562 Threespine Stickleback 7 0.0016 7 4/7/2007 1 10:00 16:00 335 Rainbow Smelt 1 0.0002 1 4/7/2007 1 10:00 16:00 865 Mottled Sculpin 1 0.0002 1 4/7/2007 2 16:0022:00 617 Yellow Perch 1 0.0002 1

25 4/7/2007 2 16:0022:00 960 Goby 5 0.0011 5 4/7/2007 2 16:0022:00 335 Rainbow Smelt 2 0.0004 2 4/7/2007 2 16:0022:00 381 Emerald Shiner 7 0.0016 7 4/7/2007 2 16:0022:00 394 Spotfin Shiner 1 0.0002 1 4/7/2007 2 16:0022:00 531 Banded Killifish 1 0.0002 1 4/7/2007 2 16:0022:00 562 Threespine Stickleback 8 0.0018 8 4/8/2007 3 22:00 4:00 340 Central Mudminnow 1 0.0002 1

19 4/8/2007 3 22:00 4:00 960 Goby 6 0.0013 6 4/8/2007 3 22:00 4:00 381 Emerald Shiner 7 0.0016 7 4/8/2007 3 22:00 4:00 335 Rainbow Smelt 2 0.0004 2 4/8/2007 3 22:00 4:00 562 Threespine Stickleback 3 0.0007 3 4/8/2007 4 4:00 10:00 562 Threespine Stickleback 7 0.0016 7

23 4/8/2007 4 4:00 10:00 617 Yellow Perch 4 0.0009 4 4/8/2007 4 4:00 10:00 289 Alewife 1 0.0002 1 4/8/2007 4 4:00 10:00 335 Rainbow Smelt 1 0.0002 1 4/8/2007 4 4:00 10:00 960 Goby 1 0.0002 1 4/8/2007 4 4:00 10:00 381 Emerald Shiner 9 0.0020 9

### Appendix D