2016 NFL Draft Spreadsheet

Fredd

Well-Known Member
Messages
4,995
Reaction score
2,238
Howdy all,
I have completed my 2016 NFL Draft Spreadsheet. It is very similar to last year's version. The things that I removed for this year were the combine stats, the Team Needs page

It's that time again. Some of you enjoyed this tool in past years, so here it is again (click the link below to view the file).

Here is what it gives you:
* Welcome page - there are boxes in there that you can click and navigate to the appropriate tab (just click one)
* Instructions - a brief run-down of what you can find on the file
* Value Chart - that is for all would-be GM's out there that like to wheel and deal (I think Jimmy Johnson created this initially)
* Offense and Defense tabs - these show all of the players on the file and their rankings, by position
* Ranking - that lists everything that you wanted to know about the 432 players listed, well, almost everything - I didn't have data on 100% of them - there are player profile links on most of them
- (note: I used 16 mocks to create the initial rankings
* College Tracker - this shows how many players are taken for each college team (Division 1), by round
* TRACKER - this is not yet populated as it takes the most time to build. I will complete this when I have my final rankings about two weeks prior to the draft

LINK (you may have to sign up to dropbox - it's free, and then download into Excel is you have that)


https://www.***NOT-ALLOWED***/s/a294evtamxufkoa/2016 nfl draft index (final).xlsm?dl=0

(EDIT: original link wasn't working, try this one)


I love feedback. so let me know your thought

Fredd
 
Last edited:

Fredd

Well-Known Member
Messages
4,995
Reaction score
2,238
If you can't get the link working and would prefer me to email the Excel file to you, please PM me (if interested)
 

Fredd

Well-Known Member
Messages
4,995
Reaction score
2,238
So, I have added another link in case you wanted to open in Excel, much like the drop box link, this link will give you access to an Excel version of the spreadsheet; you have to sign up for Zoho (it's free and took me about a minute); the drop box link will give you a view, but I think you have to save to an excel file (and you have to have Excel on your computer, of course)

File is in Excel 2010

https://docs.zoho.com/file/goqzz642e42bbd6624dd69e854f7a46e2c88d

If it is easier for me to send you the file via email, then PM me (not sure how these links look to you, they look fine to me, but I put them there). Also, I said that the tracker tab wasn't populated, but it is...

Fredd
 

ginstwin

Member
Messages
33
Reaction score
6
Fredd,

This is the best news of the month!!

The last 2 years your spreadsheet has been by my side for the 3 days of drafting. It is without doubt the best resource out there.
Those of you who havent used it , do your selves a favour and check it out. Its fantastic.

Thanks Fredd, really appreciate it.
 

Fredd

Well-Known Member
Messages
4,995
Reaction score
2,238
You're both welcome - enjoy it and let me know if there is anything I could add for the 2017 version
 

BermyStar

Well-Known Member
Messages
1,571
Reaction score
2,199
Only thing missing is beer, but we can handle that after all the hard work you put in. Wish I could buy you a round to show my appreciation.
 

RoboQB

Well-Known Member
Messages
8,488
Reaction score
10,766
Awesome share! My son is coming home from college just to watch the draft with me... these charts will be very useful and provide a bit of fun while we watch each day... Thank you, Fredd!
 

Fredd

Well-Known Member
Messages
4,995
Reaction score
2,238
Awesome share! My son is coming home from college just to watch the draft with me... these charts will be very useful and provide a bit of fun while we watch each day... Thank you, Fredd!

that is awesome...I take the thu and fri off from work every year, just to make sure that there is no honey-do list laying around...I am showered, with food, and Guinness when this starts
 

Fredd

Well-Known Member
Messages
4,995
Reaction score
2,238
Damn... I forgot about the lawn... lol... I'll try to squeeze it in.

honey-do, think honey-do....and have a plan...I already pulled the weeds too, I am Virtually ready to go!!!
 

Macnalty

Well-Known Member
Messages
3,639
Reaction score
2,162
Howdy all,
I have completed my 2016 NFL Draft Spreadsheet. It is very similar to last year's version. The things that I removed for this year were the combine stats, the Team Needs page

It's that time again. Some of you enjoyed this tool in past years, so here it is again (click the link below to view the file).

Here is what it gives you:
* Welcome page - there are boxes in there that you can click and navigate to the appropriate tab (just click one)
* Instructions - a brief run-down of what you can find on the file
* Value Chart - that is for all would-be GM's out there that like to wheel and deal (I think Jimmy Johnson created this initially)
* Offense and Defense tabs - these show all of the players on the file and their rankings, by position
* Ranking - that lists everything that you wanted to know about the 432 players listed, well, almost everything - I didn't have data on 100% of them - there are player profile links on most of them
- (note: I used 16 mocks to create the initial rankings
* College Tracker - this shows how many players are taken for each college team (Division 1), by round
* TRACKER - this is not yet populated as it takes the most time to build. I will complete this when I have my final rankings about two weeks prior to the draft

LINK (you may have to sign up to dropbox - it's free, and then download into Excel is you have that)


https://www.***NOT-ALLOWED***/s/a294evtamxufkoa/2016 nfl draft index (final).xlsm?dl=0

(EDIT: original link wasn't working, try this one)


I love feedback. so let me know your thought

Fredd

Thanks so much for taking the time to do this wonderful tool for the draft this weekend.
 
Top