Hello commissioners, I know that creating an available player list for progressive drafts can be a pain and time consuming. I created a tool that hopefully can help. Type in the year you want, copy and paste keeper lists and then you get an list of available players for your given year.

Here is the link for the tool in Google sheets. https://docs.google.com/spreadsheets/d/1h9gmpY87jqtGRwqQYalzACitUTWHHgqhO8z5DSXCIo4/edit?usp=sharing

For anyone that has not used Google sheets, you will need to be logged into your Google account and make a copy of the sheet to use.

Right now this is for pitchers. I am planning on releasing one for hitters soon. This is also my first attempt at using SQL/Query, also at using any language at all. I would appreciate any feedback from any experienced SQL users.

This is great - I’ll look and see if I can get it to work and give any feedback. You should post this in the SLB forum as well - most owners only check the classifieds if they’re looking for new teams but could get a lot of good feedback

Here is the link for the hitters version of the tool:

https://docs.google.com/spreadsheets/d/1OQOQl97kZ1fn1ThqbDrrsJGpHGVJ4v8jjfxgw6ogQyo/edit?usp=sharing

These will only work in Google sheets and not work in Excel since it uses a query function that Excel does not support.

Thanks for the suggestion chargingryno, I will post it in the SLB forum as well.

This may be the greatest advancement since the wheel............

b

This is flipping brilliant....what a time saver. Thanks for sharing it!!

Thanks! I thought it might be a bit more popular but I am glad some people are able to save some time.

B

I have updated the data for the 2022 season. I removed a lot of unused columns in the historical data to process faster. I also added the option of pasting horizontal lists. Please let me know if anything isn't working. Once again remember to use Google sheets. To use it you need to make a copy by going to "File" -> "Make a copy".

Hitters: https://docs.google.com/spreadsheets/d/1-mWCQzE-KBG-6yrh6RMlUKqLnR75ILe97kleamZLWRE/edit?usp=sharing

Pitchers: https://docs.google.com/spreadsheets/d/1dUPu52Zdker1hihDHLL0GBSEsZ5wBcxvXG3j0MHkUIc/edit?usp=sharing
(WiS has not released the spreadsheet data with pitcher Shohei Ohtani yet)

Great work. I’ve made a few additions on my copy of your original as well and can post when I’m back to my computer. Added a way to sort out rookies and highlight them, as well as pulling stats for each player (hitters I have PA, BA, OBP, SLG, OPS, and Salary - pitchers I have IP, ERA, ERC, OAV, WHIP, HR9, Salary)

fwiw...I did this for 2010 recently and a few hitters didn't show up as available (griffey jr, ausmus, k.matsui among others).

regardless, this is still a ridiculously helpful tool.

Posted by odalisgagne on 8/17/2023 12:30:00 PM (view original):
fwiw...I did this for 2010 recently and a few hitters didn't show up as available (griffey jr, ausmus, k.matsui among others).

regardless, this is still a ridiculously helpful tool.

I checked 2010 on a clean version, I did not see the same missing players. Could you share out a link of the spreadsheet with missing players and I can take a look at it.