Sunday, January 21, 2018

Super Bowl Squares Template 2018 - SuperBowl LII Grid Game

The match-up for the Super Bowl is set which means it's time to download your Super Bowl Squares Template 2018 edition. Tom Brady and the New England Patriots will play Carson Nick Foles and the Philadelphia Eagles in Super Bowl 52 on Sunday, February 4th 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) that will never make it to the championship (or winning more than one game), 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.


superbowl game with grids printable

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 new 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 2017 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 2017.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.

Sunday, January 7, 2018

Year in Pixels 2018 Mood Tracking Template

Year in Pixels is a cool idea I recently saw on Pinterest and decided I would make an Excel template for it to help save you the time of having to make your own using pencil and grid paper. Each day of an entire year is given one square or “pixel” and after every day you color in what your mood was for that day. It’s a great way to track your well-being to get a visual representation for how your year is going.

At the end of the year you’ll be able to answer the questions: How many days a year am I really happy or how many bad days do I experience in a year? Too many bad days in a row means it’s time to make a change.

During a day you may experience a wide variety of feelings. This chart doesn’t go that deep, it’s more what the culmination of everything is: was it a good day, an OK day, or a bad day?

The template is modifiable. You can change the colors if you want: I’ve decided to go with warm for happy feelings and cold for sad feelings. You can also change the number of colors/moods you want to track. I’ve gone with just five for now.

There are multiple sheets included within my template: a printable version, an Excel (electronic) version, and an example.

The printable version is for you old fashioned folks who want to print it out and color in the squares by hand with markers, crayons, or colored pencils. Feel free to hang it on the fridge or somewhere visible where you won’t forget to fill it out every day.



Personally, I prefer the Excel version because then I can do other things with it, like automatically sum up the total number of good versus bad days to know exactly what my percentages are.


See how easy it is to use the Year in Pixels template by watching the video below:



This template uses drop down lists, conditional formatting, and nested IF formulas. If you’re not sure what any of those are, I highly recommend downloading the sheet and taking a look at how it works.

Download Year in Pixels Excel Mood Tracker.xlsm

--Year in Pixels 2023 Update--

Happy New Year! I've made a few updates to the Pixel Year spreadsheet. First, I switched the format from xlsx to xlsm so I could add a macro. This way you can change the colors from the default to whatever you want at the click of a button. I also added a Yearly sheet so you can track your average and number of days for each category for each year and compare your years. See how I made the updates in the video below. Download link is the same.

 
Now you can track your mood in Excel with the Year in Pixels spreadsheet. Let me know in the comments below if you’re going to use it this year!