Monday, February 14, 2022

Weighted Olympic Medal Count 2022

In honor of the 2022 Winter Olympic Games currently being held  Beijing, China, I decided to create a Microsoft Excel spreadsheet template for the medal count as I did for the 2020 (2021) Summer Olympic Games, 2018 Winter Olympics, 2016 Summer Olympic Games, 2014 Winter Olympics and 2012 Summer Olympics

There are two primary methods most websites appear to be ranking the 2022 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 countries (as of the time of this posting on 2-14-22). 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.


You can update the chart yourself by download the Excel file here.


As of 2/14/22

 

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 2020 Summer Games not too much actually changes (so far, will revisit after more events are completed).




If you’ve been reading my blog for awhile, you’ll probably know I’m a roller coaster enthusiast, so you probably won’t be surprised that the Olympic event that intrigues me the most is the bobsled and luge. As they said on the broadcast of the monobob following the Super Bowl, “this track more than any other is similar to a roller coaster” as it has 4 uphill sections and a helix. It’s over 4,000 feet long, has a total elevation difference of 117 meters (383 feet), and bobsleders were hitting 75 miles per hour while sustaining 4gs up to 7 seconds at a time. That’s intense! A ride on a bobsled would scare me more than any roller coaster that’s secured to the rails, as you could legit crash! What Winter Olympic sport do you like to follow?




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!

2 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Gyansetu's Excel section is a data wizard's haven! Their tutorials and tips are a treasure trove for mastering Excel. Thanks for simplifying complex tasks and helping us become Excel experts!
    For more info:- https://www.gyansetu.in/blogs/best-10-uses-of-ms-excel-in-daily-life/

    ReplyDelete

I'd love to hear from you!
-Nick