Sunday, January 19, 2020

Super Bowl Squares Template 2020 - SuperBowl Grid Game

The match-up for the Super Bowl is set which means it's time to download your Super Bowl Squares Template 2020 edition. Finally! We don't have to watch the Patriots. The Chiefs and the 49ers square off in Super Bowl 53 on Sunday, February 2nd at 6:30pm. To make the big game more interesting you can start a football office pool using our printable Super Bowl spreadsheet

Fill in the squares, watch the game, laugh at the commercials, and see who wins and maybe make a little money at the same time (or help raise money for charity). If you’re a fan of a team like mine (the Factory of Sadness Hope) that will never make it to the championship (or even get a taste of the playoffs), then playing Super Bowl Squares will make watching the game more exciting and gives you something to actually root for. Others may be torn between cheering for their favorite team and cheering for their squares.

2020 super bowl squares spreadsheet


This year’s Super Bowl Squares spreadsheet includes three different versions so you can choose the way you want to play:
  1. Printable version - This print ready version contains a blank grid, simply print it off and write all the player’s names down on the piece of paper. It’s quick and easy.
  2. Pick your own squares - Manage the office Super Bowl pool directly in Excel. In this version, each player gets to pick what squares they want. Once all are taken, press the randomize button to generate the random score numbers. No modifications are necessary, though you can if you so desire.
  3. Assign squares randomly - In this latest version, type each player's name in the manager sheet and use the drop down menu to assign how many squares to give each player. Then click the Assign Names Randomly button and it will automatically populate the grid with all of the names.

Super Bowl Squares Rules & How to Play


Listed below are the basic instructions on how to play Super Bowl Squares (which are also included within the spreadsheet for the three different versions, along with an example):

  1. Participants “purchase” individuals squares by writing their name in their desired squares, until all one hundred are filled.
  2. After all squares are taken, the numbers 0 through 9 are written in the empty horizontal and vertical rows in random order (draw the numbers out of a hat).
  3. After the end of each quarter of the game, match the last digit of each team's score to the corresponding square to find the winner.

Tip: 0, 3, and 7 are the best numbers to get. 8, not so much.

Added again this year is the option whether to keep the same random numbers chosen for all four quarters or to have four different sets of random numbers for each quarter. Using the rotating quarters method, someone could theoretically still get the number 3 for all four quarters, though that’s not very likely, or four different players could each get a 3 for different quarters.

Below is a short video tutorial I put together of how to use my Super Bowl Squares template in Excel.



Super Bowl Squares Template 2020 Download


The beauty of this football bowl manager is you will not have to change or modify any formulas yourself (unless you want to of course). Instructions are included within the Excel file and shows you exactly how to add more players (either manually or by using the button that is linked to a macro). If you enjoy using this sheet football pool manager I would really appreciate it if you would share it with friends, family, and coworkers. 

To be notified when any updates are made to the file or to get a notification when next year's template is available, download using this link(requires an email address):

Download the Super Bowl Squares Template 2020.xlsm file here

Please let me know in the comments or by email which version you'll use to play - printable, pick your squares, or randomly assign names. Or if you have any requests for modifications shout me out!


NEW AND IMPROVED VERSION FOR 2021! 


5 comments:

  1. Great spreadsheet and this is my second Super Bowl Party using it to keep track of the bets. On your 2020 Superbowl Squares, is there away to assign names in the "Quarters Rotate Manager"? The reason is that there isn't a dynamic drop down menu for the names. For instance, if "Bob" buys 4 squares the drop down name doesn't stop him from selecting more than 4. Bob drinks too much and will probably select 5 or 6 which would screw up the count. This scenario isn't a problem on "assign names to squares" because you have a dynamic "# of squares" that keeps track of total squares available. Then you have the "assign names randomly" button to make it simple. I want to use the assign names randomly but on the rotating quarters spreadsheet. The workaround is to input everything on Assign names and then cut and paste into quarters rotate but that is more work and I plan on having a lot of beers like Bob. Can you add an assign names random button to the Rotating Quarters spreadsheet? That would make it perfect. Thanks
    Grant Williams

    ReplyDelete
  2. Did you realize there is a 12 word phrase you can say to your crush... that will trigger deep emotions of love and instinctual attraction to you deep inside his heart?

    That's because hidden in these 12 words is a "secret signal" that fuels a man's instinct to love, adore and protect you with all his heart...

    12 Words That Trigger A Man's Love Response

    This instinct is so hardwired into a man's mind that it will drive him to try better than ever before to build your relationship stronger.

    In fact, fueling this dominant instinct is absolutely mandatory to having the best possible relationship with your man that the moment you send your man a "Secret Signal"...

    ...You'll instantly notice him expose his heart and mind to you in a way he's never experienced before and he'll identify you as the only woman in the universe who has ever truly tempted him.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Thanks for giving us knowledge regarding super bowl squares template. Keep sharing such blogs.

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete

I'd love to hear from you!
-Nick