SC2 World Ranking, Part 10: The Hottest Players

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.

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

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

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

Red Bull LAN
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)

+ Show Spoiler +

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.

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,932 Mvp
2. 26,043 MC
3. 23,236 DongRaeGu
4. 22,110 MMA
5. 17,063 NesTea
6. 14,554 MarineKing
7. 12,469 Polt
8. 10,882 Stephano
9. 10,581 PuMa
10. 9,803 Seed

I added Assembly which had a very significant impact on the rankings. First of all, MC gained a lot of points and he's so close to surpassing Mvp! Nooo!

Polt, Stephano, and PuMa gained lots of points and surpassed Seed, leaving Seed barely able to stay in the top 10. Stephano surpassed PuMa in this shuffle as well.

Unfortunately, TaeJa barely missed the cutoff... he's rank #11. His recent Assembly win gave him lots of points because it's so recent.