Ever heard of Super Bowl Squares?
It is a super cool betting game played during the Super Bowl, which is an annual sporting event of the National Football League (NFL). The enjoyment is truly unlimited and becomes more thrilling when shared with family, friends, and colleagues.
And, of course, the best part is winning prizes.
Imagine playing it on your own game board created using a spreadsheet program. With Google Sheets Super Bowl Squares Templates, you can double the enjoyment using built-in features, making the experience even more lively.
In this article, you will learn how to make a Super Bowl Squares template from scratch, and we’ll also look at some amazing templates you might like. So, make sure to read the article till the end.
What are Super Bowl Squares, and how does it work?
Super Bowl Squares is an exciting betting pool played by up to 100 people on a 10×10 square board.
The game is designed to add an element of chance and excitement to the participants.
Before we look into the templates of Super Bowl Squares, first let us see how it is played.
STEP #1 – Create the Grid
You need to start by creating a 10X10 square grid.
Each NFL tournament includes two teams. So, the first team’s score will be listed along the top (usually a column), and the second team’s score will be listed along the side (usually a row). Refer to the following image,
You can simply refer to the X and Y axes. Random numbers from 0 to 9 are assigned to both teams.
STEP #2 – Assign Squares
The participants can buy any squares of their choice from the grid that we created in the previous step at a set price.
The square that a particular player has bought will be assigned with their name or their initial.
STEP #3 – Randomize Score Assignment
Once all the squares are sold and the squares are assigned, then the numbers 0 to 9 are assigned randomly along the row and column for Team A and Team B.
By doing this, a unique combination of squares is achieved.
STEP #4 – Match with Game Scores
At the end of each quarter, the last digit of the scores of both teams is taken as a reference and matched against the row and column to land on a square. For example, consider the following scores by Team A and Team B.
Now, the last digit of the score by team A is 3. Similarly, in the case of team B, which has achieved a single-digit score, we will simply consider the number 8.
So, the final numbers are 3 and 8 to match and land on a winning square.
In short, the participant with the square where the intersecting row and column match the last digits of the team’s score will be the winner.
STEP #5 – Prize Distribution
Prizes are awarded at the end of each quarter, with a larger prize for the final round. Make sure to decide the prizes before the game begins.
Best Google Sheets Super Bowl Squares Template FREE
A handful of Super Bowl Templates for Google Sheets are available online. We have picked the best templates which are easy to use.
Let’s quickly discuss them.
1. Super Bowl Squares Template by SoftwareAccountant
Click Here To Use This Template!
It is the best Google sheet template for playing Super Bowl Squares with your family and friends.
You can download this fantastic template from SoftwareAccountant for FREE and customize it as you prefer.
The template is pretty straightforward and can be used by beginners at Google Sheets.
This template has a single spreadsheet. It is divided into two sections:
- The first section includes a huge 10×10 grid or a game board. The participants can buy each section or square for the prize defined in the second section.
- The second section lets you list down up to 8 participants. Make sure to mention the prize to buy each square. Also, you can add the winners along with their winning prizes after the end of each quarter. At the top, you will find a dropdown that allows you to randomize numbers.
The template includes formulas and a hidden table at the end of the template. They serve a critical purpose to randomize the numbers across the grid. Avoid editing the cell containing the formulas and also the hidden table.
2. Basic Super Bowl Square Template by Printyourbrackets
Click Here To Use This Template!
This is a basic printable Super Bowl Squares template. It allows you to enjoy this excellent betting game with your friends and family without relying on an active internet connection.
Before printing the template, you need to enter the team names across the top row and leftmost column of the template.
Once you print the template, filling the squares with the participant’s name is a breeze.
At the end of each quarter, fill in the numbers from 0 to 9 in the top row and left column randomly. Note that the users have the option to change or randomize the numbers after each quarter. The template uses a separate section for this purpose.
3. Super Bowl Squares Template by Spreadsheetpoint
Click Here To Use This Template!
It is a beginner-friendly and intuitive template on this list. It displays the points scored by both teams at the top to let users quickly match the winning square.
At the top of the template, users are allowed to mention the payout for the winner of each quarter.
The noteworthy feature of this template is that it randomizes the numbers each time the template gets refreshed.
You can customize this template and more features as per your preference without any limitations.
4. NFL Box Pool Template by Profound Cloud
Click Here To Use This Template!
It is an advanced Google Sheets Super Bowl Squares Template that uses Apps Script.
The template allows you to start the game only when you enter the number of squares you want to buy, your first and last name, and your email address.
It displays the live results of each quarter in the table placed on the right with their price and a separate column to decide the Winner as well. It also shows the number of blocks left and the block price.
It comes with a separate sheet to enter the details of the participants.
Overall, it is an easy-to-use spreadsheet template that can be customized as per your requirements. To make this template attractive, you can play around with the colors, font styles, and much more.
5. Football Square Template by PlayfootballSquares
Click Here To Use This Template!
This Super Bowl Square Template comes with an attractive design.
You need to start by entering the team names at the top row and left column of the main grid.
On the right-hand side, you will see a separate table to list the available players.
At the bottom of the sheet, you can see the price per square, which helps calculate the quarterly payouts of the participants. The Winners are decided and displayed at the bottom in the second table.
Additionally, there is a separate sheet to randomize the numbers. But you can only generate the random numbers if you have entered a “Yes” in the sheet, as shown below.
Do not edit the cells holding the formulas; otherwise, the template won’t work as expected.
How to Create a Super Bowl Squares Template in Google Sheets
If you are not satisfied with the templates discussed above, then here’s the step-by-step guide to making your own Super Bowl Square Template.
Note that it is going to be a basic printable template where you need to put the numbers randomly to announce the winner.
Let’s begin.
STEP #1 – Creating a Header
A header is a vital part of the Super Bowl Squares template. It helps you include the tournament name and other details to make it more personal.
To create a header for your template, follow the steps below.
- Open a new Google Sheet by clicking here
- Select the entire first row
- Adjust the height to your desired size for the header
- Select all the cells from A1 to L1
- Go to the toolbar section that sits right below the main menu
- Click on the Merge cells icon as shown in the following image
- Type “Super Bowl Squares“
- Make the font bold
- Adjust the font size to 20
- Align the text to the center
- Change the background color to green (Hex Code: #34a853)
- Change the text color to white
Here’s how our template header looks,
STEP #2 – Creating the Top Rows and Leftmost Columns for Entering the Team Names and Random Numbers
As shown in the following image, before creating the main grid, we will go for the top row and leftmost side column where the team names will be entered.
Here are the steps to create the top row,
- Select the third row
- Adjust the height of the third row
- Select the cells C3 to L3
- Click on the Merge cells icon from the toolbar
- Type “Team 2“
- Make the font bold
- Adjust the font size to 14
- Align the text to the center
- Change the background color to dark gray (Hex Code: #d9d9d9)
Here are the steps to create the leftmost column,
- Select the cells A5 to A14
- Click on the Merge cells icon from the toolbar section
- Now, type “Team 1“
- Make the font bold
- Adjust the font size to 14
- Align the text to the center
- Change the background color to dark gray (Hex Code: #d9d9d9)
- To rotate the text vertically, click on the Text rotation icon from the toolbar section and select the fifth option. Refer to the following image,
As you can see in the following image, the top row and leftmost column are done. Now, we can enter the team names in those sections.
To enter the random numbers for the grid, we need to create the following sections.
Let’s begin,
- Select the cells from C4 to L4
- Now, change the cell background color to light gray (Hex code – #f3f3f3)
- Go to the toolbar section and click on the Borders icon
- Select All borders from the popup
- Next, click on the Borders icon again
- Select the Border styles
- Change the border thickness as shown in the following image
Here’s how the 2nd top row for entering the random numbers looks.
You need to repeat the same steps to create the 2nd leftmost column for entering the random numbers.
#3 – Creating the Main Grid
In this step, let us create the 10×10 grid, which will act as the game board. We will enter the participants’ names in each square of this grid.
Here is the process,
- Select the cell range as shown in the following image,
- Go to the toolbar section and click on the Borders icon
- Choose All borders from the popup
Here’s how our 10×10 grid looks,
#4 – Creating Rule & Result Table
This is the final step, where we will create two tables,
- First – To mention the price of each square
- Second – To declare winners and the price they won
Creating both of these tables is pretty straightforward; you need to play around with the cell background colors, font styles, and borders in Google Sheets.
Here’s how they should look.
After creating these tables, our template looks like the one below. Make sure to adjust the column width and row height to make it more attractive.
The above template can also be printed and used at your home or office.
You can download the template we created using the following link. We have used our Google Sheets knowledge of functions and tools, along with formatting skills, to make the template aesthetically pleasing and feature-rich.
Benefits of using Google Sheets Super Bowl Squares Template?
Google Sheets is an online spreadsheet program. Super Bowl Squares Templates using Google Sheets are beginner-friendly and straightforward.
Let us quickly discuss a few benefits:
- Comprehensive Structure: Google Sheets boasts a highly organized structure for Super Bowl Squares. Users will have access to an excellent grid layout and various tables to know the participants and winners.
- Time Efficiency: Using templates can save a lot of time when compared to making it on your own. They offer dropdowns to select the participants’ names quickly. Also, they use built-in functions to randomize numbers within a few seconds.
- Customization Options: Many templates available on the internet can be easily adjusted to your preferences, including changes to font size, font color, and the addition of extra fields.
- Record Keeping: Google Sheets includes a Version history tool to keep track of the changes made to the template. It can be used for record-keeping for future reference. Users can restore any version of the file as per their preference.
- Sharing And Collaboration: These templates can be shared via email. You can print them and use them offline as well. Google Sheets offers real-time collaboration features as well.
Conclusion
Using Super Bowl Squares Templates in Google Sheets can significantly enhance the enjoyment of the game. These templates can be used for in-person or virtual gatherings as they offer a structured format to assign players, numbers, and track scores.
Next time you plan to host a Super Bowl Square game for an event, remember to give these templates a try.
To learn excellent tips and tricks for becoming a pro at using Google Sheets, check out our blog page.