It's been a couple of weeks without sports now and man has it been hard. I've especially missed March Madness and filling out brackets.
I've been trying to think of ways to make up for the loss of sports. The 2020 NFL Draft is one of the few sports-related things still scheduled to go on (for now). My friend Isaic gave me the idea to make a NFL Draft Game in Excel.
Inside this template I've listed the top 100 draft prospects according to ESPN. Each player (and the template is setup to handle ten players) are randomly assigned ten future NFL players by using a randomize macro. The earlier your players get drafter the better as the draft position counts for points and the lowest number of points wins!
Update 4/17/20 - new options added!
Based on some good user feedback I added the option where each player can now try to predict which team will select their players.
See how the Draft Game spreadsheet works in the video below:
Download the NFL Draft Game Excel Template here.
Even if you have no interest in the NFL, football, or drafts, you can still learn a bit about Excel by examining the random number generator macro, or the vlookup and sumif formulas used.
For now, the spreadsheet is setup to handle ten players. To add more, the formulas and macro will need to be modified. If enough people are interested in using this sheet, I will work on making it scalable so it can automatically adjust to the exact number of players.
Let me know if you like this game or if you have any suggestions or questions.
I've been trying to think of ways to make up for the loss of sports. The 2020 NFL Draft is one of the few sports-related things still scheduled to go on (for now). My friend Isaic gave me the idea to make a NFL Draft Game in Excel.
Inside this template I've listed the top 100 draft prospects according to ESPN. Each player (and the template is setup to handle ten players) are randomly assigned ten future NFL players by using a randomize macro. The earlier your players get drafter the better as the draft position counts for points and the lowest number of points wins!
Update 4/17/20 - new options added!
Based on some good user feedback I added the option where each player can now try to predict which team will select their players.
See how the Draft Game spreadsheet works in the video below:
Download the NFL Draft Game Excel Template here.
Even if you have no interest in the NFL, football, or drafts, you can still learn a bit about Excel by examining the random number generator macro, or the vlookup and sumif formulas used.
For now, the spreadsheet is setup to handle ten players. To add more, the formulas and macro will need to be modified. If enough people are interested in using this sheet, I will work on making it scalable so it can automatically adjust to the exact number of players.
Let me know if you like this game or if you have any suggestions or questions.
No comments:
Post a Comment
I'd love to hear from you!
-Nick