• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 10:02
CEST 16:02
KST 23:02
  • 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
[ASL19] Finals Recap: Standing Tall9HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16Code S RO4 & Finals Preview: herO, Rogue, Classic, GuMiho0TL Team Map Contest #5: Presented by Monster Energy6
Community News
Flash Announces Hiatus From ASL54Weekly Cups (June 23-29): Reynor in world title form?13FEL Cracov 2025 (July 27) - $8000 live event16Esports World Cup 2025 - Final Player Roster16Weekly Cups (June 16-22): Clem strikes back1
StarCraft 2
General
Weekly Cups (June 23-29): Reynor in world title form? The SCII GOAT: A statistical Evaluation PiG Sty Festival #5: Playoffs Preview + Groups Recap The GOAT ranking of GOAT rankings Statistics for vetoed/disliked maps
Tourneys
RSL: Revival, a new crowdfunded tournament series Korean Starcraft League Week 77 Master Swan Open (Global Bronze-Master 2) [GSL 2025] Code S: Season 2 - Semi Finals & Finals $5,100+ SEL Season 2 Championship (SC: Evo)
Strategy
How did i lose this ZvP, whats the proper response Simple Questions Simple Answers
Custom Maps
[UMS] Zillion Zerglings
External Content
Mutation # 480 Moths to the Flame Mutation # 479 Worn Out Welcome Mutation # 478 Instant Karma Mutation # 477 Slow and Steady
Brood War
General
Replays question Player “Jedi” cheat on CSL BW General Discussion Flash Announces Hiatus From ASL BGH Auto Balance -> http://bghmmr.eu/
Tourneys
[Megathread] Daily Proleagues [BSL20] Grand Finals - Sunday 20:00 CET Small VOD Thread 2.0 [BSL20] GosuLeague RO16 - Tue & Wed 20:00+CET
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 What do you want from future RTS games? Beyond All Reason
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 Trading/Investing Thread Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread The Games Industry And ATVI
Fan Clubs
SKT1 Classic Fan Club! Maru Fan Club
Media & Entertainment
Anime Discussion Thread [Manga] One Piece [\m/] Heavy Metal Thread
Sports
Formula 1 Discussion 2024 - 2025 Football Thread NBA General Discussion TeamLiquid Health and Fitness Initiative For 2023 NHL Playoffs 2024
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
Blogs
Culture Clash in Video Games…
TrAiDoS
from making sc maps to makin…
Husyelt
Blog #2
tankgirl
StarCraft improvement
iopq
Trip to the Zoo
micronesia
Customize Sidebar...

Website Feedback

Closed Threads



Active: 628 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
WardiTV European League
12:00
Swiss Groups Day 2
WardiTV1254
TKL 406
Liquipedia
CranKy Ducklings
10:00
Master Swan Open #93
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
TKL 406
Hui .248
BRAT_OK 121
MindelVK 46
StarCraft: Brood War
Calm 11367
Horang2 2412
Jaedong 2022
Bisu 1838
Flash 1360
Larva 923
Mini 881
BeSt 855
actioN 436
hero 311
[ Show more ]
Last 203
TY 197
Hyun 190
Mind 165
Stork 148
sSak 64
Sea.KH 60
Yoon 40
Mong 24
Terrorterran 19
GoRush 16
HiyA 10
NaDa 10
Dota 2
XcaliburYe486
canceldota166
Counter-Strike
zeus489
Heroes of the Storm
Khaldor370
Other Games
Gorgc3548
singsing2828
B2W.Neo1434
DeMusliM565
Fuzer 277
Lowko260
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 15 non-featured ]
StarCraft 2
• Adnapsc2 20
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• Michael_bg 1
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• C_a_k_e 3090
• WagamamaTV660
League of Legends
• Nemesis5409
Upcoming Events
FEL
1h 58m
RSL Revival
19h 58m
Clem vs Classic
SHIN vs Cure
FEL
21h 58m
WardiTV European League
21h 58m
BSL: ProLeague
1d 3h
Dewalt vs Bonyth
Replay Cast
2 days
Sparkling Tuna Cup
2 days
WardiTV European League
3 days
The PondCast
3 days
Replay Cast
4 days
[ Show More ]
RSL Revival
4 days
Replay Cast
5 days
RSL Revival
5 days
RSL Revival
6 days
Liquipedia Results

Completed

BSL 2v2 Season 3
HSC XXVII
Heroes 10 EU

Ongoing

JPL Season 2
BSL Season 20
Acropolis #3
KCM Race Survival 2025 Season 2
CSL 17: 2025 SUMMER
Copa Latinoamericana 4
Championship of Russia 2025
RSL Revival: Season 1
Murky Cup #2
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
CCT Season 2 Global Finals
IEM Melbourne 2025

Upcoming

2025 ACS Season 2: Qualifier
CSLPRO Last Chance 2025
2025 ACS Season 2
CSLPRO Chat StarLAN 3
K-Championship
uThermal 2v2 Main Event
SEL Season 2 Championship
FEL Cracov 2025
Esports World Cup 2025
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
FISSURE Playground #1
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.