Beerfish Posted March 11, 2020 Share Posted March 11, 2020 With the improvement of mock draft sites the last few years my spreadsheet is no longer the best for actually making mocks but it still can be useful for playing around with the draft and researching some things. I especially still find it useful when participating in the Jet Nation mock draft. Features of the spreadsheet: List of 450 players ranked from various web site resources. Full draft order with draft trade values Ability to make easy mock drafts Some team statistical rankings from last year. (Allowing you to get a feel for a teams strengths and weaknesses from the previous year.) Combine results The sheet has some simple macros that allow you to more easily move around the sheet but if you are adverse to macros you do not have to enable them you can just navigate by tabs if you wish. The link is below, just 'download' the sheet from the linked page. https://drive.google.com/file/d/1q3-UQK52Jxnh-mwQ3FgT-CH8v57UgUGe/view?usp=sharing 3 1 Quote Link to comment Share on other sites More sharing options...
Lith Posted March 11, 2020 Share Posted March 11, 2020 3 minutes ago, Beerfish said: With the improvement of mock draft sites the last few years my spreadsheet is no longer the best for actually making mocks but it still can be useful for playing around with the draft and researching some things. I especially still find it useful when participating in the Jet Nation mock draft. Features of the spreadsheet: List of 450 players ranked from various web site resources. Full draft order with draft trade values Ability to make easy mock drafts Some team statistical rankings from last year. (Allowing you to get a feel for a teams strengths and weaknesses from the previous year.) Combine results The sheet has some simple macros that allow you to more easily move around the sheet but if you are adverse to macros you do not have to enable them you can just navigate by tabs if you wish. The link is below, just 'download' the sheet from the linked page. https://drive.google.com/file/d/1q3-UQK52Jxnh-mwQ3FgT-CH8v57UgUGe/view?usp=sharing Perfect timing. I was just beginning to work on my sheet for the JN mock draft, but it wil be easier to use yours as a starting point rather than creating mine from scratch. 1 Quote Link to comment Share on other sites More sharing options...
Beerfish Posted March 11, 2020 Author Share Posted March 11, 2020 Use anything you wish but probably use whatever resource you are happy with for official draft order and trade value numbers. I used the nfl draft wiki for some of the stuff, but a few of the trades they had listed still seemed up in air. Quote Link to comment Share on other sites More sharing options...
Lith Posted March 11, 2020 Share Posted March 11, 2020 2 minutes ago, Beerfish said: Use anything you wish but probably use whatever resource you are happy with for official draft order and trade value numbers. I used the nfl draft wiki for some of the stuff, but a few of the trades they had listed still seemed up in air. Yup. I was going to give it a couple of days to confirm draft order. Even though NFL has announced the final draft order, I am seeing some conflicting info among various sties around the "official" draft order. I will probably just steal your player list and build it into my sheet; that is the piece that usually takes me the most time. 1 Quote Link to comment Share on other sites More sharing options...
32EBoozer Posted March 14, 2020 Share Posted March 14, 2020 Thanks, BF. It’s going to be an interesting year with so many , QB, WR, OL in the mix. I can see the board being fluid come draft day. The Dolphins will be the team to watch. With so many picks (14), they may actually try to gain picks in future years by moving down this year. Similar to Pats strategy. 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.