Pants
Well-Known Member
- Messages
- 5,250
- Reaction score
- 6,384
Good afternoon all.....I took the time to make the 2019 version of my yearly Excel spreadsheet for the draft. So, if you can open an excel file (2010 version), I have it here. Sadly, I have no way of attaching it on here or cutting and pasting snapshots of it. So here is what is on there (tabs):
* Ranking - I used 20 or so mocks/draft prediction sites and gave each pick points for wherever they fell in everyone's list. Then I tallied up the numbers and made an order (top 10 I copied below but it looks nicer in Excel). In columns M and N (on the file), you can select the team that drafts the player and enter the # of the pick (respectively)
Rank PLAYER Off/ Def O/D Rank POS Pos Rank Func Func Rank TEAM Height Wght
1 Bosa, Nick DEF 1 DL 1 DLine 1 Ohio St. 6' 4" 266
2 Murray, Kyler OFF 1 QB 1 QB 1 Oklahoma 5' 10" 207
3 Allen, Josh DEF 2 DL 2 DLine 2 Kentucky 6' 5" 262
4 Williams, Quinnen DEF 3 DL 3 DLine 3 Alabama 6' 3" 303
5 White, Devin DEF 4 LB 1 LB 1 LSU 6' 0" 237
6 Taylor, Jawaan OFF 2 OL 1 OLine 1 Florida 6' 5" 312
7 Gary, Rashan DEF 5 DL 4 DLine 4 Michigan 6' 4" 277
8 Oliver, Ed DEF 6 DL 5 DLine 5 Houston 6' 2" 287
9 Sweat, Montez DEF 7 DL 6 DLine 6 Miss. State 6' 6" 260
10 Haskins, Dwayne OFF 3 QB 2 QB 2 Ohio St. 6' 3" 231
* Tracker - this tab shows the breakdown of each round and where the players fell in my rankings. If you do enter the # of the pick for each player in the ranking tab, this tab will automatically "check them off" so you won't see them on there as available; the totals at the top also account for the picks being taken and how many are left per round.
* Offense and Defense - these show rankings per position per side of the ball (for reference)
Anyway, if you want me to email you this file, send me a PM with your email. I can send this to you. Those that have used this in the past seemed to have enjoyed it
Note: if anyone (mods?) knows of a way to attach the spreadsheet in here, I am all ears....thanx....
* Ranking - I used 20 or so mocks/draft prediction sites and gave each pick points for wherever they fell in everyone's list. Then I tallied up the numbers and made an order (top 10 I copied below but it looks nicer in Excel). In columns M and N (on the file), you can select the team that drafts the player and enter the # of the pick (respectively)
Rank PLAYER Off/ Def O/D Rank POS Pos Rank Func Func Rank TEAM Height Wght
1 Bosa, Nick DEF 1 DL 1 DLine 1 Ohio St. 6' 4" 266
2 Murray, Kyler OFF 1 QB 1 QB 1 Oklahoma 5' 10" 207
3 Allen, Josh DEF 2 DL 2 DLine 2 Kentucky 6' 5" 262
4 Williams, Quinnen DEF 3 DL 3 DLine 3 Alabama 6' 3" 303
5 White, Devin DEF 4 LB 1 LB 1 LSU 6' 0" 237
6 Taylor, Jawaan OFF 2 OL 1 OLine 1 Florida 6' 5" 312
7 Gary, Rashan DEF 5 DL 4 DLine 4 Michigan 6' 4" 277
8 Oliver, Ed DEF 6 DL 5 DLine 5 Houston 6' 2" 287
9 Sweat, Montez DEF 7 DL 6 DLine 6 Miss. State 6' 6" 260
10 Haskins, Dwayne OFF 3 QB 2 QB 2 Ohio St. 6' 3" 231
* Tracker - this tab shows the breakdown of each round and where the players fell in my rankings. If you do enter the # of the pick for each player in the ranking tab, this tab will automatically "check them off" so you won't see them on there as available; the totals at the top also account for the picks being taken and how many are left per round.
* Offense and Defense - these show rankings per position per side of the ball (for reference)
Anyway, if you want me to email you this file, send me a PM with your email. I can send this to you. Those that have used this in the past seemed to have enjoyed it
Note: if anyone (mods?) knows of a way to attach the spreadsheet in here, I am all ears....thanx....