Keep Texans Talk Google Ad Free!
Venmo Tip Jar | Paypal Tip Jar
Thanks for your support! 🍺😎👍

Draft Spreadsheet

keyser

Veteran
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. 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. 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.
 
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. 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. 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.
 
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?
 
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.
 
Back
Top