Monday, December 3, 2018

2018 College Football Bowl Prediction Pool Manager with CFB Playoff Bracket

The college football conference championships were played this past weekend which means the 2018 NCAA college football bowl season is here again! Therefore, it’s time to make your picks and predictions about who you think will win each bowl game. One of the best times of the holiday season (other than giving and receiving gifts) is gathering around the TV and rooting for your Alma mater or hometown football team. This year has the added bonus of not just single bowl games but the fifth year of a four team playoff to determine the national champion.

Features for this year's bowl prediction pool over the previous college football bowl pool manager spreadsheets include the following:
  • Easy method to make each bowl game worth a different point value, so the national championship game and semi-finals can be worth more points, or however you want to customize it.
  • Updated leaderboard tab with new stats
  • Separate entry sheet to pass out to participants or co-workers that can be imported by a macro
  • Complete NCAA college football bowl schedule with game times and TV stations
  • New stat sheet to track each conference's record during bowl season (Go Big Ten! Go MAC!)
  • The bowl prediction sheets include the football helmet designs for every team (taken from the 2017 college football helmet schedule spreadsheet), their win-loss record, and the logo for all bowl games. I added the helmets so those players who aren't big college football fans can pick a winner based on their favorite helmet design!
  • If you click on one of the helmets it should take you to that team's ESPN page so you can learn more about them and see which teams they won or lost to.
  • Download the CFP Pool Manager and Single Entry Form here.

There are now three ways to add participant’s data:
  • Manual entry using the drop down lists
  • Copy and paste from the selection sheet to the bowl manager
  • Use the import macro to automatically import a player’s data into the pool manager by way of a macro
Below is last year's video of how to use the bowl pool manager spreadsheet.

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.

I am working a version where you can add confidence picks by ranking the bowls in order of how confidence you are with your picks. I did one for 2017 but have not updated 2018's for this yet.

Here are some of my Bowl Game Observations that may interest only me...
  • Unlike two years ago when there were four teams with losing records, there are none this year, though there are a ton of 6-6 teams (yawn).
  • Last year, there were no undefeated teams in the four playoff spots (UCF was undefeated). This year there are three undefeated teams (and undefeated UCF got left out again).
  • Biggest gap of match-up between number of wins is 10-2 Cincinnati vs 6-6 Virginia Tech.
  • Can you name all 8 teams who have won 11 or more games this year without looking? Four are obviously in the playoff, but what about the other four? One is surprising.

Please let me know if you have any questions, comments, find any bugs, or have any suggestions for improvement. I love that people are using this Bowl Prediction Game to help raise money for charity, that's so awesome to hear! What team are you rooting for?

Tuesday, November 20, 2018

2018 Holiday Gift Guide for Microsoft Excel Users

The 2018 holiday season is officially upon us here in the United States which means it’s time for my annual gift giving guide. I used to panic every year whenever my spouse, parents, and siblings asked me what I wanted for Christmas. I needed to give them an idea otherwise I’d end up with an ugly sweater or some random gadget I would never use.

So to help alleviate some of my stress I started compiling my own holiday gift guide. It’s kind of like the big toy catalog you used to get as a kid, only this is for adults. I’ve made a list of items I think would be very useful or exciting for your fellow Excel users, sorted by different categories. Some of these items I already use on a daily basis and others are things that are on my own personal wish list. It's my biggest and best gift guide yet! Enjoy!


Excel 2016 Bible - The complete guide to Excel 2016, from Mr. Spreadsheet himself! Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.

Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features.

If you’ve ever thought to yourself “there has to be a better way to do this,” while using Microsoft Excel, then know you're probably right. There probably is a better way to complete your tasks you just don't know what it is and you don't have time to read a boring, expensive, thousand page manual on how to use Excel. 76 Excel Tips to Increase Your Productivity and Efficiency is for you. No fluff, just Excel tips and tricks you can put to use right away.


Will It Fly? How to Test Your Next Business Idea So You Don’t Waste Your Time and Money by Pat Flynn. I’ve been following Pat’s blog and podcast for a number of years, and you might have seen some of his tips at work on my site. If you’re new to the online business world, this book is fantastic. Lots of practical steps to take to prove whether your idea has validity or not. Over 700 reviews and a five star rating, that's impressive!

The Martian by Andy Weir. If you only read one (fiction) book this year, The Martian has to be the one. I absolutely love this book (and it’s even better than the movie). As soon as I finished it the first time, I immediately re-read it – something I’ve never done before. It’s about an astronaut (with a great sense of humor) who gets left behind on a mission to Mars and has to figure out how to survive. If you’re interested in space exploration, problem solving, engineering, chemistry, botany, or disco + 70s TV shows, I highly recommend you read The Martian. Maybe the best book I’ve read in the past five years.

Another quick, shameless self-plug. Where are the most terrifying roller coasters found? Who designs them? Which park builds the craziest rides? Find out by reading my book 50 Groundbreaking Roller Coasters. Another reason for including this book on this list is to show you a real life usage of Excel. How's that? Because this is one of the books I wrote using an Excel spreadsheet!

Nowhere in the world is there a more bizarre theme park than Happy Fun Land. Nike Farmington’s twelve years of thrill-seeking and roller coaster riding has brought him to exotic locales like Perth, Australia, Kaatsheuvel, Netherlands, and Santa Claus, Indiana. He's marathoned a roller coaster for ten consecutive hours and conquered the world’s tallest and fastest. Yet nothing has prepared him for the insanity of Happy Fun Land and it’s mind blowing attractions: a drop ride with no brakes and a death simulator, just to name a few. Will Nike survive his hilarious adventure through the world's craziest theme park? I thought this book was hilarious and I think you will too!

Tools for the Job

Excel Quick Reference Sheets - Laminated quick reference showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2016 (Windows Version). Written with Beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.

TechSmith Snagit takes the hassle out of creating images and videos. Capture your screen, edit images, and deliver results. Snagit is also the only screen capture tool with built-in advanced image editing and screen recording. So you can easily create high-quality images and videos all in one program. Quickly explain a process, build visual-based documentation and be more engaging by adding images and videos to your communications. It's the tool I use to create all the images for Excel Spreadsheets Help and well worth the price.

Microsoft Surface Tablet. Need to use Excel on the go put don't want to lug around a larger laptop? A Surface tablet is great way to go.

Dimmable Eye-care LED Desk Lamp. A great lamp and exactly what I was looking for in a new clip on lamp for my drafting desk. It has six different light settings so I can find the right lighting for all of my needs. It is well built, works great besides being stylish.Besides using at work can use at home as a reading lamp too.

Keyboard Case for Tablets. How do I get so much done, especially when I’m traveling on the road a lot? I use a combination of a Samsung Galaxy Tablet and my new Keyboard case. They’re small so I can take it almost anywhere and the keyboard allows me to do things like type out this blog post, reply to your email questions, and write Excel macro code.

USB Heated Mouse / Hand Warmer. I'm not sure about you but the office at my day job can get really cold during the winter, especially after weekends or holidays. One solution I've found that helps is a heated mouse to keep you hand warm while not impacting my ability to get things done.

Laptop Privacy Screen Protector. Whenever I visit a customer I always take my privacy screen protector for my laptop. It keeps your personal or confidential information safe from prying eyes as you’ll see the information on your display while people on either side only see a darkened screen. If you’re ever on an airplane or in a coffee shop and feel like your neighbor is constantly looking over your shoulder at your screen then you need to get one of these today!

A good quality laser point. This laser pointer always comes in handy when it’s time for a meeting or presentation. Plus, it doubles as a toy to keep your cats entertained.

Rocketbook Smart Erasable, Reusable Wirebound Notebook with Penstation – the last notebook you’ll ever need!

Krieger Plug Adapters (Most of Europe (type C)) - If you're going to do some international travel I highly recommend taking this adapters with you. They come in a pack of four so you can share when your travel buddy forgets his.

Toys, Tech, Gadgets, and Others

Handheld Gimbal Stabilizer for Smartphone – Outside of this website, in my spare time I like to make and edit videos and montages (mostly of my family). It’s easiest just to use a cellphone but the video is often shaky due to my unsteady hands. So I decided to get a gimbal and I’ve had fun playing around with it.

Anker PowerCore Fusion - This is a portable power charger that plugs directly into the wall so it works as your regular charger, but is also a battery so you always have power on the go.

In my little free time from working and being a dad, I like to play around with my Samsung Gear VR headset. Virtual Reality is really taking off and the technology is getting much better. Though be warned it may cause motion sickness if the app you’re looking at doesn’t perfectly track your head movement.

Solar Powered Christmas Lights. I love putting up Christmas lights and trying to out-do my neighbors, but I have to admit I feel a little guilty about using the additional electricity. Luckily I found these solar powered Christmas lights and they actually work very well! They’re environmentally friendly and they automatically turn on and off each night. They also don’t have to be attached to a power source so I can put them in areas I normally couldn’t string lights.

Dash and Dot – programmable robots. If you’re into programming things like Excel macros and you want to teach your kids the joys of programming then I’ve found the perfect gift for you. These cute robots are designed to help introduce children to the wonderful world of programming. Oh, and they’re fun for adults too! Can’t wait to use this with my son in a few years. For now he just likes watching me drive it around with my phone.

Fitbit Alta. Let’s face it – us engineers nowadays sit in front of a computer a lot. I didn’t realize how much I wasn’t moving until I started wearing a Fitbit. It now helps me to stay motivated by tracking all-day activity like steps, distance, calories burned and active minutes so I can stay healthy for my family. When I’m sick I can’t answer your Excel questions and help you out, so I use Alta to help stay in shape and on top of my game!

Amazon Prime Membership. If you haven’t joined Amazon Prime yet, why not? I do almost all my shopping online and I get free two-day shipping on nearly everything. You can also borrow books, watch movies, and stream music. Get your Prime Discounted Monthly Offering here.


Are you putting any of these items on your holiday wish list? If so, let me know which ones in the comments below. Do have anything you’d like to recommend to me?

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?

Looking for the college football helmet schedule?

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:


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.


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)

No email required (no notifications):

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.

Looking for the NFL Helmet schedule?

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!

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