.xlsx file -->https://drive.google.com/open?id=0B_...EFSSWJ0dG82bnM
.xls file -->https://drive.google.com/file/d/0B_d...ew?usp=sharing
1. After you complete your draft take a video with your phone cycling through all the teams draft picks.
2. Using the video you took then open a new blank tab in the Excel file provided and start entering in each of the teams highest rated draft picks. It doesn't matter what round just keep the best players. Enter the Team, Player Name, Position and Overall rating. Just get between 45-55 players that you would like to see as rookies. Once done adding players create a filter on Overall rating and sort highest to lowest. Then, cut and Paste the players into their proper slots in the 2018 Draft class tab.
For example, the highest rated running back for 2018 will be Saquon Barkley, so whichever team drafted the highest rated running back will now get assigned Saquon.
3. Once finished entering all the information in Excel either print out a copy of your completed draft class or use your laptop to go into each teams rosters and make the necessary edits to the player names, colleges, height, weight, skin color, ratings, etc...
4. I will typically give only a few players (maybe 2-3) Superstar ratings but then leave all the other players random for development.
5. I most likely won't be making any new versions of this file so feel free to do so yourself. If you want to see a different player or change some of the overall ratings then go for it. It's a good starting point and I've spent a lot of time so far. Now it's time to enjoy the game!
Cheers,
klawler

Comment