• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 07:47
CEST 13:47
KST 20:47
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
RSL Season 1 - Final Week6[ASL19] Finals Recap: Standing Tall12HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16Code S RO4 & Finals Preview: herO, Rogue, Classic, GuMiho0
Community News
Esports World Cup 2025 - Brackets Revealed12Weekly Cups (July 7-13): Classic continues to roll4Team TLMC #5 - Submission extension3Firefly given lifetime ban by ESIC following match-fixing investigation17$25,000 Streamerzone StarCraft Pro Series announced7
StarCraft 2
General
RSL Revival patreon money discussion thread Esports World Cup 2025 - Brackets Revealed Who will win EWC 2025? The GOAT ranking of GOAT rankings Weekly Cups (July 7-13): Classic continues to roll
Tourneys
FEL Cracov 2025 (July 27) - $8000 live event RSL: Revival, a new crowdfunded tournament series $5,100+ SEL Season 2 Championship (SC: Evo) WardiTV Mondays Sparkling Tuna Cup - Weekly Open Tournament
Strategy
How did i lose this ZvP, whats the proper response Simple Questions Simple Answers
Custom Maps
External Content
Mutation # 482 Wheel of Misfortune Mutation # 481 Fear and Lava Mutation # 480 Moths to the Flame Mutation # 479 Worn Out Welcome
Brood War
General
Flash Announces (and Retracts) Hiatus From ASL BGH Auto Balance -> http://bghmmr.eu/ BW General Discussion Starcraft in widescreen A cwal.gg Extension - Easily keep track of anyone
Tourneys
[Megathread] Daily Proleagues Cosmonarchy Pro Showmatches CSL Xiamen International Invitational [BSL20] Non-Korean Championship 4x BSL + 4x China
Strategy
Simple Questions, Simple Answers I am doing this better than progamers do.
Other Games
General Games
Stormgate/Frost Giant Megathread Nintendo Switch Thread Path of Exile CCLP - Command & Conquer League Project The PlayStation 5
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread Vanilla Mini Mafia
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Stop Killing Games - European Citizens Initiative Summer Games Done Quick 2025! Things Aren’t Peaceful in Palestine
Fan Clubs
SKT1 Classic Fan Club! Maru Fan Club
Media & Entertainment
[Manga] One Piece Movie Discussion! Anime Discussion Thread [\m/] Heavy Metal Thread
Sports
Formula 1 Discussion TeamLiquid Health and Fitness Initiative For 2023 2024 - 2025 Football Thread NBA General Discussion NHL Playoffs 2024
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
Men Take Risks, Women Win Ga…
TrAiDoS
momentary artworks from des…
tankgirl
from making sc maps to makin…
Husyelt
StarCraft improvement
iopq
Trip to the Zoo
micronesia
Customize Sidebar...

Website Feedback

Closed Threads



Active: 685 users

SC2 World Ranking, Part 6: Ratios

Blogs > Entirety
Post a Reply
Entirety
Profile Blog Joined April 2012
1423 Posts
Last Edited: 2012-08-13 18:00:12
August 12 2012 18:51 GMT
#1
Part 5: http://www.teamliquid.net/blogs/viewblog.php?id=359812

+ Show Spoiler [Introduction] +
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.


Now updated with "Ratios"! Please check the "How to Use" section for more info.

http://dl.dropbox.com/u/43612415/World Ranking.xlsm

+ Show Spoiler [How to Use] +
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.


+ Show Spoiler [Regression] +
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".


However, this is not completed yet! In fact, I need your help!

+ Show Spoiler [Checklist] +
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)


+ Show Spoiler [My Progress] +
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.


+ Show Spoiler [How You Can Help!] +
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!


Finally, here is my own ranking:

+ Show Spoiler +
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.


Honestly, I was going to write something about IEM. However, my mind is only on one person right now...

[image loading]

IPL TAC 3 was a pretty incredible story. Yes, other people have dominated hard, just like TaeJa is dominating right now. However, I don't think anyone else could have pulled off that 23-3 record, 4-kills and all-kills galore. Mvp at his prime still dropped games here and there. DongRaeGu at his prime dropped games here and there (games that he should not have dropped). Even MarineKing, when he all-killed StarTale in the KSL finals, dropped games here and there.

TaeJa does not merely drop games here and there.

Honestly, if the first Bo9 was played and there was a significant break until the next Bo9 (say, the next Bo9 is played next week or so), then Liquid might have won it all. They still almost won it all, even without any break.

I'm not hating on Liquid or anything, but Liquid had a pretty disappointing performance. (Meanwhile, TaeJa had a phenomenal performance.) Since each member of Liquid lost anyway (except for Zenio's win versus LosirA), it might have been better if they dragged out their games as long as possible, giving up chances of victory. Just turtle and use a strategy that you could never hope to succeed with, but have each game take 50+ minutes to finish you off. All for the sake of giving more rest to TaeJa.

That's how big the TaeJa advantage is. The whole team is there to support him, he's the one who's pulling off the kills.

When TaeJa finally got eliminated by Seed and he sat down on the TeamLiquid bench, I wasn't disappointed in him for failing to achieve that 9-kill of IM. There was no regret, no more expectations, nothing left to do but watch.

Job well done, TaeJa.

Question for you: What tournament shall I add next?

Part 7: http://www.teamliquid.net/blogs/viewblog.php?id=360230

***
IMMvp (정종현) | Fan Club: http://www.teamliquid.net/forum/viewmessage.php?topic_id=211431
Jaaaaasper
Profile Blog Joined April 2012
United States10225 Posts
August 12 2012 21:48 GMT
#2
This is pretty neat. I think you should add code a next, but figuring out how to rank the new version seems kind of hard. So i would say work on adding ranks with out prize pool, because those 9th and tenth places are still a lot of hard work and should be recognized.
I really like this!
Hey do you want to hear a joke? Chinese production value. | I thought he had a aegis- Ayesee | When did 7ing mad last have a good game, 2012?
Blitzkrieg0
Profile Blog Joined August 2010
United States13132 Posts
August 12 2012 22:24 GMT
#3
Is there any way to get this to upload in google documents (or just make it compatible)? Don't have office so I can't view it right now and when I tried to send it to google documents it didn't convert
I'll always be your shadow and veil your eyes from states of ain soph aur.
Entirety
Profile Blog Joined April 2012
1423 Posts
August 12 2012 22:53 GMT
#4
Yes there is a way, but it's not a good idea. When I tried it in Google Spreadsheets, it was far too slow to be useful. It literally took 5 minutes just to change one value or enter one date. That's why I moved the project to Excel.

I would love to make it compatible for more people, but Google Spreadsheets just doesn't work out that well... any ideas are always welcome.
IMMvp (정종현) | Fan Club: http://www.teamliquid.net/forum/viewmessage.php?topic_id=211431
opterown *
Profile Blog Joined August 2011
Australia54784 Posts
August 13 2012 00:55 GMT
#5
this needs more views o.O
ModeratorRetired LR Bonjwa
TL+ Member
Entirety
Profile Blog Joined April 2012
1423 Posts
Last Edited: 2012-08-13 01:09:16
August 13 2012 01:05 GMT
#6
I'll start promoting it when it's completed (which is a long way off )

Edit: Honestly, this deserves more views: http://www.teamliquid.net/blogs/viewblog.php?topic_id=358757
IMMvp (정종현) | Fan Club: http://www.teamliquid.net/forum/viewmessage.php?topic_id=211431
Please log in or register to reply.
Live Events Refresh
Next event in 4h 14m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Trikslyr34
Harstem 12
StarCraft: Brood War
Sea 27793
BeSt 4614
Mini 1795
Pusan 962
Stork 610
Zeus 369
PianO 289
EffOrt 286
Last 218
Barracks 129
[ Show more ]
ToSsGirL 116
zelot 65
JulyZerg 62
Aegong 39
Sharp 34
Rush 33
Sacsri 25
GoRush 19
sSak 17
Icarus 17
SilentControl 15
IntoTheRainbow 13
Noble 12
Bale 11
Hm[arnc] 9
scan(afreeca) 9
Britney 0
Dota 2
Gorgc7521
singsing2338
XcaliburYe261
Counter-Strike
shoxiejesuss717
x6flipin569
sgares329
Super Smash Bros
Mew2King146
Other Games
gofns11511
B2W.Neo581
DeMusliM384
Pyrionflax112
SortOf88
Hui .30
Organizations
Other Games
gamesdonequick3450
StarCraft: Brood War
lovetv 7
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 12 non-featured ]
StarCraft 2
• Berry_CruncH432
• Hinosc 22
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Upcoming Events
uThermal 2v2 Circuit
4h 14m
Replay Cast
12h 14m
The PondCast
22h 14m
OSC
1d 1h
WardiTV European League
1d 4h
Replay Cast
1d 12h
Epic.LAN
2 days
CranKy Ducklings
2 days
Epic.LAN
3 days
CSO Contender
3 days
[ Show More ]
BSL20 Non-Korean Champi…
3 days
Bonyth vs Sziky
Dewalt vs Hawk
Hawk vs QiaoGege
Sziky vs Dewalt
Mihu vs Bonyth
Zhanhun vs QiaoGege
QiaoGege vs Fengzi
Sparkling Tuna Cup
3 days
Online Event
4 days
BSL20 Non-Korean Champi…
4 days
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
Esports World Cup
5 days
ByuN vs Astrea
Lambo vs HeRoMaRinE
Clem vs TBD
Solar vs Zoun
SHIN vs Reynor
Maru vs TriGGeR
herO vs Lancer
Cure vs ShoWTimE
Esports World Cup
6 days
Liquipedia Results

Completed

CSL 17: 2025 SUMMER
RSL Revival: Season 1
Murky Cup #2

Ongoing

JPL Season 2
BSL 2v2 Season 3
Copa Latinoamericana 4
Jiahua Invitational
BSL20 Non-Korean Championship
Championship of Russia 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025
Asian Champions League '25
BLAST Rivals Spring 2025
MESA Nomadic Masters

Upcoming

CSL Xiamen Invitational
CSL Xiamen Invitational: ShowMatche
2025 ACS Season 2
CSLPRO Last Chance 2025
CSLPRO Chat StarLAN 3
BSL Season 21
K-Championship
RSL Revival: Season 2
SEL Season 2 Championship
uThermal 2v2 Main Event
FEL Cracov 2025
Esports World Cup 2025
Underdog Cup #2
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.