05-24-2017, 05:18 PM
Hey everyone. Long-time lurker, new poster here. Wanted to share something I developed recently. I am often interested in what fish species have been stocked in certain Utah lakes and in what quantities. The Utah DWR publishes stocking data here:
https://dwrapps.utah.gov/fishstocking/Fish
If you scroll all the way to the bottom, you will see a set of links for prior year stocking data going back several years.
This is great, but suppose I want to figure out how many kokanee have been stocked at Strawberry in recent years? I have to go through each year and locate and add up all the numbers to get a set of totals. This is because they don't give a total per year, rather they list each stocking event over the year, along with the date and the number of fish.
Since I am kind of a geek, I decided to create a spreadsheet tool that consolidates all this information. I first developed it in Excel but moved it to Google Sheets. The resulting tool is simple to use and gives an immediate response. What I did was create a connection to the stocking data for each year from 2011-2016. The sheet pulls the data from the DWR website. Then I have a selector where you pick a lake from a list and then pick a species and you get a nice summary of the stocking history for the lake/species combo. Here is an example:
![[Image: stock-data_zpsmzkqytd5.png]](http://i65.photobucket.com/albums/h205/rcc122/stock-data_zpsmzkqytd5.png)
Note that it should be a banner year for kokes in 2017!
Sometimes I am curious to see where certain species have been stocked so I created a tool for that also. You select a species and you get a list of all the lakes where that species has been stocked (since 2011). For example:
![[Image: species-finder_zpsqmrulfsv.png]](http://i65.photobucket.com/albums/h205/rcc122/species-finder_zpsqmrulfsv.png)
Very fun to play with. For example, did you know that chubs are deliberately stocked in several lakes? Including Lake Powell in 2016? That was news to me.
If you want to play with the sheet, you will first need to log into your google account. Then here is a link that gives you access to view (but not change) the sheet:
https://docs.google.com/spreadsheets/d/1...edit#gid=0
Be warned that others might be accessing the document at the same time. If you would like to simply make a copy of the sheet on Google Drive and then have complete private access, use this link:
https://docs.google.com/spreadsheets/d/1...uV85Q/copy
Feedback welcomed. Happy fishing.
[signature]
https://dwrapps.utah.gov/fishstocking/Fish
If you scroll all the way to the bottom, you will see a set of links for prior year stocking data going back several years.
This is great, but suppose I want to figure out how many kokanee have been stocked at Strawberry in recent years? I have to go through each year and locate and add up all the numbers to get a set of totals. This is because they don't give a total per year, rather they list each stocking event over the year, along with the date and the number of fish.
Since I am kind of a geek, I decided to create a spreadsheet tool that consolidates all this information. I first developed it in Excel but moved it to Google Sheets. The resulting tool is simple to use and gives an immediate response. What I did was create a connection to the stocking data for each year from 2011-2016. The sheet pulls the data from the DWR website. Then I have a selector where you pick a lake from a list and then pick a species and you get a nice summary of the stocking history for the lake/species combo. Here is an example:
Note that it should be a banner year for kokes in 2017!
Sometimes I am curious to see where certain species have been stocked so I created a tool for that also. You select a species and you get a list of all the lakes where that species has been stocked (since 2011). For example:
Very fun to play with. For example, did you know that chubs are deliberately stocked in several lakes? Including Lake Powell in 2016? That was news to me.
If you want to play with the sheet, you will first need to log into your google account. Then here is a link that gives you access to view (but not change) the sheet:
https://docs.google.com/spreadsheets/d/1...edit#gid=0
Be warned that others might be accessing the document at the same time. If you would like to simply make a copy of the sheet on Google Drive and then have complete private access, use this link:
https://docs.google.com/spreadsheets/d/1...uV85Q/copy
Feedback welcomed. Happy fishing.
[signature]