SC2 World Ranking, Part 12: Graphs

The first sheet is known as "Values" and it is the only spreadsheet you should edit. Only edit the highlighted areas!

Do not worry about the exact point values, only the ratios truly matter! Basically, having GSL = 10 points and MLG = 4 points is the same as having GSL = 5 points and MLG = 2 points.

First, start with the point ratios. Simply enter the points that you think a 1st place is worth compared to a 2nd place, a 3rd place, a 4th place, etc.

For example, if I enter 1,000 points for 1st place and 500 points for 2nd place, that means 1st place is worth double the amount of points as 2nd place. If you think that 1st place is worth 3 times as much as 2nd place, you can put 1st place as 300 points and 2nd place at 100 points.

The section underneath that (highlighted with a darker shade, containing 3rd/4th, 5th/6th, etc.) are optional. You can choose the values yourself if you want. If you do not, they work using averages (3rd/4th averages the points you gave for 3rd place and 4th place).

Next, enter the tournament ratios. For example, if I enter 10 points for GSL and 4 points for MLG, that means GSL will give out 2.5x as many points as MLG. Use these ratios to gauge relative importance of the tournaments. If you think MLG is worth half as much as GSL, make MLG 5 points and GSL 10 points, and so on.

The points are calculated by multiplying the tournament ratios with the point ratios. If I put 100 points for 1st place and 10 points for GSL, it will multiply the two values and give you 1,000 points for GSL 1st place. Here's another example:

Let's say I choose these values: 1st place = 1,000 points, 2nd place = 500 points. GSL = 10 points, MLG = 4 points.

GSL 1st = 1,000*10 = 10,000 points
GSL 2nd = 500*10 = 5,000 points
MLG 1st = 1,000*4 = 4,000 points
MLG 2nd = 500*4 = 2,000 points

One thing that is very popular in point rankings such as this is the concept of regression. Basically, your points degrade over time, meaning that a GSL today is worth more than a GSL one year ago.

The sheet "Values" has a "Regression Factor" which you can edit. Right now, the spreadsheet only supports simple regression - exponential decay. Here's how the regression model works:

New Point Value = Original Point Value * (Regression Factor)^(# of Days since the Tournament)

The value I prefer is "0.99769217652702". If you use this value, the number of points will be halved after 300 days (so 10,000 points becomes 5,000 points), the number of points will be 25% after 600 days (so 10,000 points becomes 2,500 points), and so on.

You may choose your own value! If you do not wish to use regression (you think a GSL from one year ago is worth exactly the same as a GSL today), then simply use the value "1".

Some regression values:
50% after 120 days: 0.99424042381754732964045049128729
50% after 180 days: 0.99615658722058
50% after 300 days: 0.99769217652702

The concept of this is that you can go back in time and see what the rankings would look like in August 2011 or August 2010 or whatever date you choose. The way to use this is very simple:

In the "Values" spreadsheet, there is a section called "Date". Simply change this date to whatever date you want to go back to!

Finally, when you are ready to produce your ranking, simply press the "Sort" button in the "Values" sheet. It will automatically sort every list in the spreadsheet. The sheet named "Ranking" will have your final ranking sorted from the greatest amount of points to the least amount of points.

Just go to the sheet named "Graphs" and there is a highlighted cell near the top. Enter the player whose points you wish to track and it should automatically create a graph for you detailing his/her points over time.

Part 1: I started this project on Google Spreadsheets and added the three GSL Open Seasons. NesTea topped the rankings with his GSL Open Season win.

Part 2: I added all of the GSL Code S seasons including the World Championship, Super Tournament, and Blizzard Cup. I also moved the project to Microsoft Excel, which is much much faster than Google Spreadsheets. With the addition of more GSL seasons, the GSL king (also known as Mvp) topped the rankings.

Part 3: I added IPL. I changed the spreadsheet into a macro-enabled spreadsheet and protected each sheet except "Values". The addition of IPL allowed Squirtle to break the top ten!

Part 4: I added MLG. MLG gave a lot of points to DongRaeGu and MarineKing, and they rose many places. MC, MMA, and Leenock also rose some places, while NesTea didn't gain any points.

Part 5: I added DreamHack. A high placement in DreamHack allowed Genius to overtake aLive and break into the top 10.

Part 6: I added IEM. Also, I changed the "Values" system to work with ratios rather than point values for each "cluster" of tournaments. Ratios are more flexible in general.

Part 7: I added Top 16 for each DreamHack tournament (before, only the placements with prize money were included in the ranking). Also, I added the NASL, causing PuMa and Stephano to enter the rankings.

Part 8: I added Top 16 for each MLG Arena this year. I added the Iron Squid, giving lots of points to MMA.

Part 9: I added TSL, not much accomplished today.

Part 10: I added Assembly and Seed falls in the rankings as Stephano, PuMa, and Polt gain significant amounts of points.