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 that is probably the easiest to use.
I also have the Full spreadsheet 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:
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.
I have a Single Sheet spreadsheet that is probably the easiest to use.
I also have the Full spreadsheet 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.
