PDA

View Full Version : Draft Spreadsheet


keyser
04-28-2011, 10:35 AM
As I've done the past few years, I put together a draft spreadsheet. I use this to follow the draft, and keep track of the "best" players remaining. I include rankings of players from 7 different sites, and you can adjust the relative weight of those (right now, I weight 4 of them equally, give one just 75% weight (since they only ranked the first 50 in order), and gave two just 25% weight, since I know less about them.

The "single sheet" version, which most people will probably prefer, is HERE (http://faculty.cse.tamu.edu/keyser/Draft2011SingleSheet.xls). This is an older Excel format, and has a column you can enter in players as they are chosen. It does not have the raw data. Sheet 2 has the relative weighting for the 7 sites, and Sheet 3 has copied explanation of grades from two of the sites. It is currently sorted based on my weighting.

The "full" version, which has the raw data, including lots of hyperlinks and individual data (like height/weight/40/etc.) on the subsequent sheets, is available HERE (http://faculty.cse.tamu.edu/keyser/Draft2011.xlsx). Use that if you want lots of details and to see how I put together the main sheet (note: it is not sorted).

All of the data is freely available data - I did not include anything like ESPN insider. The data was from the last couple of days (it says when I got it in the header line), but may not be the "final" version from each site.

I haven't had as much time to fix the sheet as usual, so there are probably some errors in places, but hopefully stuff near the top is accurate, at least. Let me know if you find errors, but I probably won't have time to fix much today unless it's something big.

kiwitexansfan
04-28-2011, 10:41 AM
Only 1971 players on your list? Weak Sauce.


No really, awesome job on this. Always appreciate your effort! :clap:

rmartin65
04-28-2011, 10:45 AM
This is fantastic man. Thanks!

Dutchrudder
04-28-2011, 10:49 AM
Wow, great work! Rep sandwich for you!

chicagotexan2
04-28-2011, 01:52 PM
As I've done the past few years, I put together a draft spreadsheet. I use this to follow the draft, and keep track of the "best" players remaining. I include rankings of players from 7 different sites, and you can adjust the relative weight of those (right now, I weight 4 of them equally, give one just 75% weight (since they only ranked the first 50 in order), and gave two just 25% weight, since I know less about them.

The "single sheet" version, which most people will probably prefer, is HERE (http://faculty.cse.tamu.edu/keyser/Draft2011SingleSheet.xls). This is an older Excel format, and has a column you can enter in players as they are chosen. It does not have the raw data. Sheet 2 has the relative weighting for the 7 sites, and Sheet 3 has copied explanation of grades from two of the sites. It is currently sorted based on my weighting.

The "full" version, which has the raw data, including lots of hyperlinks and individual data (like height/weight/40/etc.) on the subsequent sheets, is available HERE (http://faculty.cse.tamu.edu/keyser/Draft2011.xlsx). Use that if you want lots of details and to see how I put together the main sheet (note: it is not sorted).

All of the data is freely available data - I did not include anything like ESPN insider. The data was from the last couple of days (it says when I got it in the header line), but may not be the "final" version from each site.

I haven't had as much time to fix the sheet as usual, so there are probably some errors in places, but hopefully stuff near the top is accurate, at least. Let me know if you find errors, but I probably won't have time to fix much today unless it's something big.

Man I'd rep you 100 times if I could. THis is what I've been whishing for. Thanks man.

Brandon420tx
04-28-2011, 02:07 PM
Since the decertification and lockout process started, I haven't gone to NFL.com, ESPN.com, or watched NFL Network or ESPN (and affiliates), so I forgot, what is the precise time the draft starts so I can follow it on the MB?

rmartin65
04-28-2011, 02:12 PM
Since the decertification and lockout process started, I haven't gone to NFL.com, ESPN.com, or watched NFL Network or ESPN (and affiliates), so I forgot, what is the precise time the draft starts so I can follow it on the MB?

Starts around 8.

Playoffs
04-28-2011, 03:26 PM
+ Rep.

I'm gonna strip out all but Goose's Top 100 --- simple minded. ;)

keyser
04-28-2011, 04:21 PM
Starts around 8.

Actually, I'm pretty sure it is stated as starting at 7 Central Time (8 is for the Eastern time zone). Tomorrow, round 2 starts at 5 Central time, and Saturday round 4 starts at 11 a.m. Central time.

rmartin65
04-28-2011, 05:21 PM
Actually, I'm pretty sure it is stated as starting at 7 Central Time (8 is for the Eastern time zone). Tomorrow, round 2 starts at 5 Central time, and Saturday round 4 starts at 11 a.m. Central time.

True that. I am on east coast time though, which is why I said 8. My bad dude.

keyser
04-28-2011, 05:49 PM
True that. I am on east coast time though, which is why I said 8. My bad dude.

Actually it looks like Brandon420tx is also on Eastern time, so I probably should have just not said anything!

Heath Shuler
04-28-2011, 07:53 PM
great stuff
you rock:clap: