If you've been following me for any amount of time you know I love a good football spreadsheet game, like Super Bowl Squares or College Football Bowl Pick'em. Recently a reader made me aware of a new game I had never heard of before and I just had to turn it into an Excel template to play this fall.
Introducing the NFL 33 Pool spreadsheet!
Here's how to play: players are assigned an NFL each week of the 18 game season and if your team scores 33 points, you win!
But that's not all. If that was the only way to play the spreadsheet would have been far too simple to make. My Excel template allows the pool manager to select different options so you can play how you want to.
First, select the number of players, which can be between 1 and 32.
Second, choose if you want the target score to be the same every week, or change every week.
Next, choose if the winner requires hitting the exact target score, whoever gets closest on a weekly basis, or add up the scores for the whole season.
Finally, choose if you want players to keep the same NFL teams all season or to be assigned a different team every week.
How to Play NFL 33 Game
Watch the video below to learn how to play football 33 and see how the spreadsheet works:
How the NFL 33 Pool Spreadsheet Works
In the Pool sheet from column C to T a random number is generated. Each number corresponds to team on the Lists sheet. Change the numbers manually if you want to manually change the teams. Uses conditional formatting to turn cell green if scores exactly match. This sheet uses macros. Macros must be enabled. Document must be saved in trusted location. Go to Trust Center settings to modify if needed.
No comments:
Post a Comment
I'd love to hear from you!
-Nick