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

Annual Draft Spreadsheet

keyser

Veteran
Some of you might remember that I put together a spreadsheet each year so that I can keep track of the draft and what players are available. In the past, some others have liked to use them, also, so I'll post this again.

I pulled the rankings from 6 different public sites and show that data, along with a weighted average. I used my own relative weightings of the six sources based on last year's accuracy in the top 100 picks. I know some people don't like these rankings - if so, you can edit yourself to remove them or whatever.

THIS SPREADSHEET has the main data on a single page. It just has values (no formulas) so it's easier to work with.
THIS SPREADSHEET is the same thing, but with a column to use to record actual picks (and then press sort to sort them). I use this during the draft itself to help me keep up with what's going on.
THIS SPREADSHEET gives the raw data. If you want to change weights or fix errors or whatever, that's the place to do it (then you might want to create a new single sheet again).

I had very little time this year to do error checking and stuff, so no promises on accuracy. Hope someone finds it useful.
 
Some of you might remember that I put together a spreadsheet each year so that I can keep track of the draft and what players are available. In the past, some others have liked to use them, also, so I'll post this again.

I pulled the rankings from 6 different public sites and show that data, along with a weighted average. I used my own relative weightings of the six sources based on last year's accuracy in the top 100 picks. I know some people don't like these rankings - if so, you can edit yourself to remove them or whatever.

THIS SPREADSHEET has the main data on a single page. It just has values (no formulas) so it's easier to work with.
THIS SPREADSHEET is the same thing, but with a column to use to record actual picks (and then press sort to sort them). I use this during the draft itself to help me keep up with what's going on.
THIS SPREADSHEET gives the raw data. If you want to change weights or fix errors or whatever, that's the place to do it (then you might want to create a new single sheet again).

I had very little time this year to do error checking and stuff, so no promises on accuracy. Hope someone finds it useful.
I find it hard to believe a #1 overall is worth 2000 times as much as a late 7th rounder.
 
I find it hard to believe a #1 overall is worth 2000 times as much as a late 7th rounder.
I find it hard to believe that it's not worth more than 2000X. I wouldn't take 2000 late 7th round picks for the #1 overall.
 
Back
Top