Friday, July 13, 2018

2018 NFL Helmet Schedule Spreadsheet

2018 nfl helmet schedule spreadsheet download
Available to download now is the 2018 NFL helmet schedule spreadsheet. You’ll see a comprehensive breakdown of every NFL pro football team's 2018 season schedule with an image of each team’s helmet design.

There are two different sites you can get the sheet from.

1. Email required to download. I do this so you will be automatically updated you if changes or additions are made and will update you when the next year’s schedule is ready.


2. No email required (no notifications): I know some people don't like giving out their email so I've made this option available. However, you won't be notified if I update the sheet.

The NFL helmet schedule is printable too. You can save the spreadsheet as a PDF file or print it out and pin it up in your cubicle at work. If you do, please email or tweet me a picture of it hanging up - I'd love to see it!

As always, I welcome any comments or suggestions about how to fix or improve the sheet! How can I improve this spreadsheet into something you’ll use all the time during pro-football season? What future features would you like to see?

Thursday, June 28, 2018

2018 College Football Helmet Schedule Spreadsheet

The 2018 college football season will be here before we know it! I still can’t believe my Buckeyes got shut out of the college football playoff last year, but hey, I’ll take a win against USC any day.

I really have no idea what to expect this season. I always have fun looking at the 2018 college football helmet schedule to try to predict which games I think my favorite team will win or lose.

This spreadsheet of the college football schedules includes every team from all conferences plus independents. Every game is listed as either home, away, or neutral site (noted at the bottom of each sheet). A college football helmet schedule spreadsheet may be available on other websites but, to my knowledge, this is the only downloadable Excel version and, unlike some of the others, is 100% FREE!

college football games spreadsheet in excel


For the second year in a row I’ve used macro automation to automatically create this sheet - no more manual copying and pasting for hours with many mistakes. The schedules are imported directly from ESPN (so if there is a mistake blame them!).

The first time I uploaded this sheet, I messed up. The pictures were linked to all the helmets saved in a folder on my desktop. When you opened the spreadsheet on another PC, none of the helmets showed up. I made a mistake in my macro.

I originally used:

ws.Pictures.Insert(path)

I had to change the VBA to AddPicture in order to make embedded pictures instead of linked pictures.

myLeft = rng.Left + (rng.Width / 2) - 25

myTop = rng.Top + 45

If FileExists(path) Then

Dim p

Set p = ws.Shapes.AddPicture(path, False, True, myLeft, myTop, 60, 55)



AddPicture creates a picture from an existing file. Returns a Shape object that represents the new picture.

I’m happy to say this year’s sheet contains 245 different college football team helmets! It’s surprising how small the file size is when considering how many helmets there are.

DOWNLOAD THE 2018 COLLEGE FOOTBALL HELMET SCHEDULE SPREADSHEET

Below are two separate download options for you. Email required download link (to automatically update you if changes or additions are made and will update you when the next year’s schedule is ready)

https://gum.co/cfhelmetschedule

No email required (no notifications):

https://app.box.com/s/zkhiizjrx7ylaevd1q44npcc5o5qw7mm

As always, I welcome any comments or suggestions about how to fix or improve the sheet! Let me know if and how you’re using the sheet.

Monday, March 12, 2018

2018 March Madness Excel Brackets

Spoiler Alert: This post is going to mostly be a re-hash of my same March Madness Excel bracket posts from the past eight years.

It’s the most wonderful time of the year! March Madness 2018 is here and the first of the four “play-in” games will begin on Tuesday, March 13th . Once again, I’ll be using David Tyler’s NCAA Excel brackets, the same ones I’ve been using since at least 2010, as they're still the best as far as I’m concerned. I'd like to give a special thanks to David for continuing to update, tweak, and post his excellent brackets each and every March and giving us something to look forward to as we crawl out of the final few weeks of winter (snowing again here in Ohio, I hoped we were done with winter).

I’m a firm believer that a great way to increase your Excel knowledge is to reverse engineer Excel spreadsheet templates, like these office pool March Madness brackets. Previously, I’ve shared 11 things you can learn from the best Excel brackets and they all still apply for this year’s version. David doesn't lock or hide anything behind password protection so you can examine all the formulas to see how they work and make any modifications you desire.

There are two files: the bracket manager and the individual bracket file, that can be downloaded by following the link below. Download the files and start picking them apart!
http://www.whistleblows.com/p/bracket.html

If you’re worried you might not be able to use the March Madness Excel brackets have no fear. They are easy to use and you can watch this short video I made to show you just how easy it is to use David's brackets. Simply click on each team to advance them (don't forget to enable macros).





  • A No. 16 seed has never beaten a No. 1. Like ever.
  • A No. 12 seed usually beats a No. 5 seed.
  • Odds of picking a perfect bracket: 1 in 9.2 quintrillion.
  • Odds of picking a perfect bracket using historical data and basketball knowledge: 1 in 128 billion.

I know some readers of this blog skip over the templates I post, especially if they're sports related. but there really are many lessons that can be learned by examining them that you can apply to your own spreadsheets to improve them. What new lessons about Excel have you learned by breaking down a template?

Thursday, February 22, 2018

Weighted Olympic Medal Count 2018

In honor of the 2018 Winter Olympic Games currently being held in PyeongChang, South Korea I decided to create a Microsoft Excel spreadsheet template for the medal count as I did for the 2016 Summer Olympic Games2014 Winter Olympics and 2012 Summer Olympics. There are two primary methods most websites appear to be ranking the 2018 medal count. Most sites rank countries by the total number of Olympic medals won. Other sites, like the International Olympic Committee (or IOC) rank countries by their gold medal count. And others rank by other factors like per capita or GDP.

Pictured below is a bar chart showing all medals won for the top 22 countries (as of the time of this posting on 2-22-18). The bar chart is created in Excel by highlighting the data then going to Insert>Bar>Stacked Bar chart. Change the colors of the bars by right clicking on them then use the drop down menu to select the data you want to change. Norway is currently in first place followed by Germany and Canada. You can update the chart yourself by download the Excel file here.

winter olympics medal count excel

Weighted Olympic Medal Count 2018


I’ve devised my own ranking system to give each Olympic medal a weight where the silver is worth half a gold medal and a bronze is worth only a quarter of the gold. Based on this new scoring system, previous Olympic results suddenly became quite interesting. However, for the 2018 Winter Games not too much actually changes.

Looking at the new Olympic medal ranking systems yields some interesting results. The top seven countries actually remain in the same order. Biggest change is OAR dropping six places, followed by Finland dropping five places. Sweden benefits the most, gaining four spots.



Download the spreadsheet and see for yourself. I’ve shared my Olympic Medal Count spreadsheet and listed out the Olympic medals by country. How would you weight each medal against the others? Comment below and share any of your Olympic medal rating systems!

Monday, February 12, 2018

2018 NASCAR Fantasy League Manager Spreadsheet

2018 is now the fith(!) year in a row that I’ve made the NASCAR Fantasy League spreadsheet available for download (and I'm not even a NASCAR fan). This NASCAR fantasy game is based on Total Driver Points according to NASCAR’S scoring system. In order for your drivers to score they must be running for Monster Cup Points. Drivers may run in more than one NASCAR division but can only score points in one division.



How to Play NASCAR Fantasy in Excel


At the beginning of the year (first race is Daytona on February 18th) participants choose ten race car drivers as follows: three from Group 1 & 2 and two from Group 3 & 4. In Group 3, you may write in any driver that is not listed in one of the groups AND drove for points in the 2017 season. In Group 4, you may write in any driver that is rookie for the 2018 season. These will be their 10 drivers for the entire year - no changing after the entry deadline. All players also submit the three drivers that they think will place 1st, 2nd, and 3rd in the NASCAR standings at the end of the year. They don’t need to have these drivers in their picks, just who they think is going to finish on top. This is used as a tie-breaker. Drivers are listed in the order of their Monster Cup point total for 2017 season. Monster Cup points (including Chase points) will be from Nascar.com and driver point totals will be accumulated for each of the 36 races.



The fantasy league manager manually enters each player’s picks into the spreadsheet at the beginning of the year (or uses the new entry form to copy and paste entries). Players keep the same drivers all year long. After each race, the manager then goes to ESPN.com and enters the amount of points that each driver earned during the race into that driver’s column. The spreadsheet then automatically adds and ranks each player according to their driver’s scores.


I used many of the same formulas found in the leaderboard of my NCAA Bowl Prediction Pool sheet. This NASCAR fantasy manager template can currently handle up to one hundred drivers and one hundred participants without needing to modify a single formula!

2018 NASCAR Fantasy League Manager Download


The beauty of this fantasy racing league 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 or drivers. If you enjoy using this NASCAR sheet I would really appreciate it if you would share it with friends, family, and coworkers.

2018 NASCAR Fantasy League manager spreadsheet download

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). You will be given the download link instantly and one will be sent to your email if you want to download it later.

Download now by entering your email (which will only be used to send you an update if we add a new feature or alert you when next year's sheet is available). Enter a zero for free download or make a donation to my children's future college education fund ;)

I welcome any questions, comments, or suggestions! Have fun.

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.xls

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!