PDA

View Full Version : Draft Spreadsheet


keyser
04-14-2010, 03:31 PM
Some of you might remember that I put together a Draft Spreadsheet (in Excel) last year. I've done the same this year, although I have not had (and probably won't have) the time to go through it in detail to clean it up, as I have in the past.

I have a Single Sheet spreadsheet (http://faculty.cs.tamu.edu/keyser/Draft2010SingleSheet.xls) that is probably the easiest to use.

I also have the Full spreadsheet (http://faculty.cs.tamu.edu/keyser/Draft2010.xls) that has the raw data in it.

If I update these, I'll post the most recent versions there. (Actually, I converted both from .xlsx to .xls, so hopefully there were no problems...)

The way I use this on draft day is to add a new column near the front that is the position actually selected. I then fill in the pick number as people are chosen. You can always resort to find the "best" remaining players.

Some details:

I pulled information from five sites, from last Friday through today. All are publicly available sites: NFL.com, NFLDraftScout.com, Scout.com, SI.com, and NationalFootballPost.com.
If you look at the full spreadsheet, the first sheet is the one used to make the single sheet, and aggregates other data. Each of the websites then has one sheet with raw data, and another sheet with processed data. Sheet 12 contains some weights for how to combine the 5 rankings. You should, in theory, be able to update the raw data (though I had to make some hand modifications) and everything else update.
Two of the websites give overall rankings, while three give grades. For the graded websites, I assigned a ranking based on the grades (tied score gives tied ranking).
The overall ranking on the single sheet was an average of four of the websites' rankings. I did not include NationalFootballPost in the average, since it was very different from the others. If you get the full spreadsheet, you can change the weights on page 12 to weight the values relative to each other.
The list of players on the first sheet/single sheet is taken from NFLDraftScout.com, since they had, by far, the largest list. However, some of the sites have other names that might not appear. I haven't had the time to go through and add other players that are on other websites but not on NFLDraftScout - if someone makes a list, please let me know, so that I can add it.
Some websites have different spellings of names (e.g. "Joe" vs. "Joseph") that makes the spreadsheet miss the player in the search. I tried to correct by hand for the top 200 or so, but I am sure I missed some players, especially at higher numbers. Again, if you notice problems, please let me know.
Note that in the full spreadsheet, a couple of the raw data sheets include hyperlinks to the website information about players (not for SI.com, although it is on the SI website). I usually found this more annoying than helpful, though.


No promises that things are accurate or not messed up. Again, I'd like to eventually post a "clean" version of the spreadsheet, but I doubt I'll have the time to fix it up enough in the mean time. I hope others will find this useful.

76Texan
04-14-2010, 05:21 PM
Very nice!

You have some duplicates though.

The Pencil Neck
04-14-2010, 06:02 PM
Very nice!

You have some duplicates though.

Like he said, these aren't spotlessly cleaned up versions.

Dutchrudder
04-14-2010, 06:12 PM
Good sheet! Repped for effort! :D

drs23
04-15-2010, 01:04 AM
Thanks. Great effort.

Heath Shuler
04-15-2010, 07:29 PM
thanks

Hoss
04-15-2010, 08:17 PM
sweet...

keyser
04-22-2010, 06:19 PM
Just in case anyone wants it, I did manage to update just a bit. I grabbed the latest NFLDraftScout data, and I included Gosselin's top 100 list into the sheet. Gosselin's rankings are now part of the average in the single sheet (NFP is not), also.

I still didn't have time to do a thorough clean on the data, but it should be pretty good. Sorry if there are duplcates or errors (I think some were removed, though, since the NFLDraftScout website had a smaller list, today...).

Again, during the draft it helps to add one column for "actual spot taken". Then, if you sort on that column, you will get the "best" remaining list below.