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!

No comments:

Post a Comment

I'd love to hear from you!
-Nick