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.