SC2 World Ranking, Part 6: Ratios

Lately, I've heard lots of discussion about a StarCraft 2 World Ranking based on tournament results. Essentially, the concept is that you assign points for tournament rankings. Unfortunately, no matter how it is done, the ranking will always be subjective. One person may say that the GSL is worth as much as every other tournament combined, whereas another person may say that the GSL is worth about as much as a MLG.

How do I get around this "subjective" problem? Here's my answer: I'll let you choose the values!

That's right, I'm starting a project to create a World Ranking. The cool thing is that you get to choose how many points each victory is worth and more.

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

I have now changed the spreadsheet to work on ratios. 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 another person thinks that 1st place is worth 3 times as much as 2nd place, he/she can put 1st place as 300 points and 2nd place at 100 points. Simple, right?

The section underneath that (highlighted with a darker shade), the one 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:

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

The "Sort" button will automatically sort the lists in order of points.

The sheet known as "Rankings" has the ultimate ranking which you are looking for.

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. I completely agree with this idea, so I've included this.

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

NASL
Iron Squid
TSL
Red Bull LAN
Assembly
WCG
WCS
HomeStory
OSL
ESWC
BlizzCon
GSL Code A
Other major tournaments/one-off tournaments (such as IPL Hot Import Nights, GSL All-Stars Invitational, MLG Global Invitational, etc.)
Tournament rankings without prize pool (such as MLG 9th place)

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.

I need lists of tournament rankings. First, I need the name of the tournament, and the date it ended. Then, I need a list of players starting from 1st place until last place. Here's an example:

GSL Open Season 1
10/2/2010

FruitDealer
RainBOw
Ensnare
LiveForever
HongUn
InCa
Maka
TricKsteR
anypro
Check
Clide
Hyperdub
LegalMind
Nettie
San
TOP
IdrA
JookTo
justfake
Keeping
Maru
Polt
TaeJa
Tankboy
TheWinD
TLO
ZanDarke
Zenio
Aory
Artosis
Astraea
BrEEzE
Cella
Cezanne
Chipmunk
Dos
FoCuS
Genius
Gerrard
GuineaPig
Hansin
JiTaeHoon
jjonga
JSL
Junwi
LosirA
MC
miso
Myth
NesTea
New
RenieHouR
SengKun
Sopia
Spunky
SSoja
TorcH
Wind
Xian
Yong

My next goal is foreign tournaments. Do not worry about Code A yet!

1. 26,964 Mvp
2. 23,330 DongRaeGu
3. 21,263 MC
4. 19,133 MMA
5. 16,114 NesTea
6. 14,291 MarineKing
7. 9,894 Seed
8. 9,878 Polt
9. 8,024 Leenock
10. 6,939 aLive

MC gained the most points from IEM (he did win that World Championship over PuMa). The addition of the ratio system seems to have shifted the point values slightly.