2021 Super Bowl Squares Spreadsheet – the only template you’ll ever need

I’ve been creating Super Bowl Squares spreadsheets for ten years now. Every January I’d update the template and add more sheets with more ways to play. It’s gotten to the point where it’s a bit of a mess when opening the workbook and seeing all these different colored tabs with similar yet different names. It was getting annoying dealing with multiple game boards, multiple score managers, etc. and probably very confusing to new users. 

The old version of the Super Bowl Squares template

I’ve had an idea for streamlining and improving the grid game spreadsheet for over two years but just finally had enough time and energy to work on it before the actual Super Bowl. It’s taken many hours of work setting up the macros and testing all of the conditions but it’s finally ready: the new and improved Super Bowl Squares template is here!

When you first open the template you’ll notice the big changes right off the bat. You’re met with a simple setup screen where the user will decide how to play the game. The sheet automatically updates the Super Bowl boxes and the leaderboard to reflect only the version of the game you want to play. 

I used to have to update the sheet every year by inputting the teams and their helmets. This time, all the teams and helmets are in one of the sheets. Simply use the drop down lists in the Squares sheet to select the team from the list (broken up by AFC and NFC) and their helmets will update automatically! 

Watch me demo the new Super Bowl board in the video below:

As you can see, the new sheet allows more ways to play but is simple and easy to setup and is automated as much as possible. 

Get the Super Bowl pool template here.

Even if you’re not into football, you can still use the template to learn how to do these Excel tricks:

• Lookup pictures based on cell values
• Generate random numbers
• Use NameManager
• Create drop down lists
• Use index and match formulas

If you dissect the macros in the spreadsheet you’ll learn how to:

• Hide rows and columns
• Hide or unhide sheets
• Generate random numbers between 0 and 9 with no duplicates
• How to hide command buttons by VBA
• How to change cell fill color

Update 1-19-2021

I've updated the spreadsheet again. There are now 54 ways to play within one slick spreadsheet. I added options to play by quarters, every minute, or every time the score changes. Watch me preview the update below. Also be sure to subscribe to my email list and YouTube channel as I'll be showing off all the tricks and tips I used to make this spreadsheet work.

*Intended for PC/Microsoft Office/Excel. I don't think it will work in Mac Numbers*

Get it here (enter a 0 into the price box then input an email address):

https://gumroad.com/l/superbowlsquares

Let me know what you think. I’d love to hear from you. Is this version as much of an upgrade and easy to use as I think it is? I welcome any and all questions, comments, suggestions, cuss words, and compliments. Let me know using the comments below or via email. Enjoy playing Super Bowl Squares!