Here is a link to a Google Docs spreadsheet I created of draft prospects and their rankings on assorted draft boards. The prospects had to make the top 100 on one of the selected boards to make the spreadsheet. I had a similar sheet for last year's draft and it had some filters added that identified Toney as a hand full of value picks when the Giants came up at 20.
You can sort by average, high, low or a preferred boards average. I find the spreadsheet useful when running mock drafts to identify players worth checking out or if a player is a reach based on board rankings.
Just thought I would share it if some may find it useful.
Google Docs spreadsheet - (
New Window )
I will look into that. Its a little tricky to move those columns as they have formulas. I need to look up the help on that :-(
I usually freeze the columns at Pos and then you can scroll the Avg over to Pos column.
Rather take a RB in 4th or 5th
Jerion Early. Brian Robinson. Jerome Ford
That is also where the preferred column comes in. You can modify that to have a column based only on the analysts that you like. Currently I believe I dropped drafttek and Walter football in my preferred column. If you modify also update the divisor based on the number of column that you use and the preferred blank column formula.
As far as being all over the place on the rankings, I think that makes this a useful tool. If you rely on "my guy says" view then he may be wrong. Averaging a pool of analysts will tend to weed out the lone poor analysis.