Algorithm of 400 Clan Ranking Algorithm

Abandoned challenges and other old information.

Moderators: Clan Directors, Global Moderators

Forum rules
Please read the Community Guidelines before posting.

Algorithm of 400 Clan Ranking Algorithm

Postby FarangDemon on Wed Mar 23, 2011 5:37 pm

Welcome! For the example clan ranking based on all clan wars and Clan League data prior to Mar 29, go to this post:

viewtopic.php?f=438&t=140929&start=15#p3088157

The remainder of this post is my original post, describing the method and my initial application of it to the results of Clan League 3 only (nothing else). You have to start small, right?


wikipedia wrote:Performance Rating is a hypothetical rating that would result from the games of a single event only. Some chess organizations use the "algorithm of 400" to calculate performance rating. According to this algorithm, performance rating for an event is calculated by taking (1) the rating of each player beaten and adding 400, (2) the rating of each player lost to and subtracting 400, (3) the rating of each player drawn, and (4) summing these figures and dividing by the number of games played. This can be expressed by the following formula:

Performance rating = [(Total of opponents' ratings + 400 * (Wins - Losses)) / Games].


I've taken this formula and modified it to get a clan ranking based on CL3 performance.

I treat each set of 18 games (19 games in finals) from CL3 as a single game between two clans where each clan either wins, loses or ties.
The points a clan gets for each set is a function of their opponents rating at that time.
The rating of a clan is the weighted average of all such accumulated points.
(weighting is by games in the set, so reg season sets are weighted at 18, finals weighted at 19)

I started each clan at 1000 points.

Image

I assumed that KORT beat TSM in the regular season 10-8 (the data in the thread are incomplete at 9-8 favoring KORT).
If TSM tied KORT please let me know and I'll update the ratings.
Last edited by FarangDemon on Mon Apr 25, 2011 2:26 pm, edited 6 times in total.
Click image to enlarge.
image

"He came dancin across the water.... FarangDemon, FarangDemon.... mmmhh....what a killer..."
User avatar
Brigadier FarangDemon
 
Posts: 700
Joined: Wed Apr 23, 2008 1:36 am
Medals: 33
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (1)
Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (3) Cross-Map Achievement (3) Ratings Achievement (1)
Tournament Achievement (6) General Achievement (2) Clan Achievement (4) Map Contribution (1) Tournament Contribution (1)

Re: Algorithm of 400 Clan Ranking for CL3

Postby jpcloet on Wed Mar 23, 2011 5:40 pm

FarangDemon wrote:I assumed that KORT beat TSM in the regular season 10-8 (the data in the thread are incomplete at 9-8 favoring KORT).
If TSM tied KORT please let me know and I'll update the ratings.


10-8 was the final. That game lagged for a while so the table has not been updated.
Image
User avatar
Captain jpcloet
 
Posts: 4426
Joined: Sat Mar 17, 2007 9:18 am
Medals: 69
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3) Battle Royale Achievement (1)
Ratings Achievement (3) Tournament Achievement (7) General Achievement (7) Clan Achievement (5) Tournament Contribution (8)
General Contribution (8)

Re: Algorithm of 400 Clan Ranking for CL3

Postby Dako on Thu Mar 24, 2011 3:25 am

Looking at the regular season it seems pretty accurate I must say. Good job.
Image
User avatar
Brigadier Dako
 
Posts: 3942
Joined: Sun Aug 26, 2007 9:07 am
Location: St. Petersburg, Russia
Medals: 115
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Battle Royale Achievement (1) Ratings Achievement (3) Tournament Achievement (13) General Achievement (24)
Clan Achievement (20) General Contribution (20)

Re: Algorithm of 400 Clan Ranking for CL3

Postby FarangDemon on Fri Mar 25, 2011 5:54 am

Dako wrote:Looking at the regular season it seems pretty accurate I must say. Good job.


Thanks!

I created a script that takes clan challenge data as input and provides a ranked list of all clans by performance rating.

http://killersapp.com/Algorithmof400.htm

I thought it may be interesting to add data from more clan wars, both before, during and after CL3, and see what performance looks like then. So now anybody can come up with a ranking for any event or set of events.

You can set the Rating Calculation Date to be any date, it will tell you what the clan's score was at the given time (not counting future challenge outcomes).

You can also set the Data Window, which is how many years back challenge outcomes will be used to calculate your performance rating. I have it set to 1 year as default. So clan challenges from 2 years ago won't be used to calculate your performance rating. They are still relevant because they established how many points your opponents gained/lost when they played against you over the previous year.

Format for Clan Challenge Input

http://killersapp.com/Data.xls

One war per line, tab separated columns: (ClanName1,ClanName2,WinCode,Games,Date)
  • ClanNames - use whatever you want but be consistent, matching is case-sensitive
  • WinCode = 1 means Clan1 beat Clan2, WinCode = 0 for ties
  • Games is number of games in challenge
  • Date must be dd/mm/yy, 0 in the tens place for any single digits
Click image to enlarge.
image

"He came dancin across the water.... FarangDemon, FarangDemon.... mmmhh....what a killer..."
User avatar
Brigadier FarangDemon
 
Posts: 700
Joined: Wed Apr 23, 2008 1:36 am
Medals: 33
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (1)
Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (3) Cross-Map Achievement (3) Ratings Achievement (1)
Tournament Achievement (6) General Achievement (2) Clan Achievement (4) Map Contribution (1) Tournament Contribution (1)

Re: Algorithm of 400 Clan Ranking for CL3

Postby skillfull on Fri Mar 25, 2011 7:00 am

Nice work Farang
Image
User avatar
Brigadier skillfull
 
Posts: 693
Joined: Tue Dec 11, 2007 8:39 am
Location: chalkis
Medals: 52
Standard Achievement (3) Doubles Achievement (4) Triples Achievement (3) Quadruples Achievement (3) Nuclear Spoils Achievement (1)
Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (2) Teammate Achievement (2) Random Map Achievement (1)
Cross-Map Achievement (3) Ratings Achievement (1) Tournament Achievement (11) General Achievement (2) Clan Achievement (12)

Re: Algorithm of 400 Clan Ranking for CL3

Postby White Moose on Fri Mar 25, 2011 8:01 am

Very nice work indeed.
Image
Highest Score: 3374
User avatar
Major White Moose
 
Posts: 2041
Joined: Mon Sep 24, 2007 6:33 am
Location: Sweden
Medals: 63
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (2) Freestyle Achievement (3) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Speed Achievement (3) Random Map Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (16)
General Achievement (3) Clan Achievement (6) Tournament Contribution (4)

Re: Algorithm of 400 Clan Ranking for CL3

Postby josko.ri on Fri Mar 25, 2011 8:05 am

very nice indeed. very accurate results shown ;)
Image
User avatar
General josko.ri
 
Posts: 1726
Joined: Sun Nov 15, 2009 5:18 pm
Medals: 98
Conqueror Achievement (1) Monthly Leader Silver (1) Monthly Leader Bronze (2) Standard Achievement (3) Doubles Achievement (2)
Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1) Assassin Achievement (1) Manual Troops Achievement (1)
Freestyle Achievement (1) Polymorphic Achievement (2) Nuclear Spoils Achievement (2) Fog of War Achievement (3) Trench Warfare Achievement (1)
Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2) Cross-Map Achievement (3) Beta Map Achievement (1)
Ratings Achievement (3) Tournament Achievement (26) General Achievement (16) Clan Achievement (17) Tournament Contribution (1)

Re: Algorithm of 400 Clan Ranking for CL3

Postby jpcloet on Fri Mar 25, 2011 8:15 am

Here is what I get when I put all the wars into that system....

Rank Name Rating
1 z-Dark Defenders 1800
2 The Horsemen of the Apocalypse 1583
3 The Spanking Monkeys 1474
4 z-The Rogue State 1400
4 z-Dragon Lazorz Pew Pew 1400
4 The Pack 1400
7 The Odd Fellows Union 1382
8 The Immortal Assassins 1345
9 Nemesis 1320
10 Knights of The Round Table 1278
11 The Fantastic Four-Skins 1275
12 Legends of War 1271
13 EMPIRE 1267
14 Knights of the Round Table 1229
15 The Devil's Brigade 1199
16 A Fistful of Sixes 1195
17 De Veroveraars der Lage Landen 1188
18 ++The Legion++ 1167
18 The Brethren of the Fat Mermaid 1167
20 Angels of Death 1159
21 Agents of Chaos 1149
22 z-The Untouchables 1132
23 The Fraternal Order of Exceptional Drinkers 1129
24 Memento Mori 1112
25 The Imperial Dragoons 1095
26 Generation One: The Clan 1079
27 One Step Ahead 1036
28 z-Knights of the Empire 1000
28 z-Snipers 1000
28 z-Disciples for Christ 1000
31 z-Exictium 976
32 The Dark Knights of Chaos 974
33 z-Warlords of the Wort 970
33 z-Order of Odin 970
35 The Last Warriors 955
35 z-Left4Dead 955
37 Risk Attackers 954
38 Black Sheep Squadron 943
39 The Bullet-Proof Bandits 931
40 z-Eternal Empire 927
41 z-Knights of the Future 924
42 z-Sky Force 910
43 z-The Regulators 903
44 z-Outlaws & Highwaymen 875
45 Mythology 868
46 z-Imperial Britain 857
47 Legends of the Zone 829
48 z-Project Enigma 815
49 Grim Reapers 810
50 Soldiers of War 798
51 z-Divine Domination 785
52 z-Bounty Hunters 763
53 Death By Comity 760
54 z-Freemium Forces 690
55 z-Flame Whores 659
56 z-Grey Company 636
57 z-Churchill War Cabinet 600
57 z-Jesus Freaks 600
57 z-Bushwhakers 600
57 z-The Army of Darkness 600
57 z-Hell's Messengers 600
57 z-Project Firestorm 600
57 Always Kicking Ass 600
57 Kill On Arrival 600
65 z-Water's Fury 587
66 Dynasty 568
67 z-TIME 555
68 The 4th Crusade 496
69 z-Lunatics 458
70 z-Faith Becomes Reality 444
71 z-Marvel/DC Heroes 372
72 z-Gorgonzola Pirates 317
73 Legends of The Zone 207
74 Karma Clan 173
Total Records: 180
Image
User avatar
Captain jpcloet
 
Posts: 4426
Joined: Sat Mar 17, 2007 9:18 am
Medals: 69
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3) Battle Royale Achievement (1)
Ratings Achievement (3) Tournament Achievement (7) General Achievement (7) Clan Achievement (5) Tournament Contribution (8)
General Contribution (8)

Re: Algorithm of 400 Clan Ranking for CL3

Postby Dako on Fri Mar 25, 2011 8:19 am

Interesting results. New clans with 1-2 wars get an overpowered rating.
Image
User avatar
Brigadier Dako
 
Posts: 3942
Joined: Sun Aug 26, 2007 9:07 am
Location: St. Petersburg, Russia
Medals: 115
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Battle Royale Achievement (1) Ratings Achievement (3) Tournament Achievement (13) General Achievement (24)
Clan Achievement (20) General Contribution (20)

Re: Algorithm of 400 Clan Ranking for CL3

Postby jpcloet on Fri Mar 25, 2011 8:21 am

Notes for those that are not aware.

1 z-Dark Defenders 1800 (1-0)
4 z-The Rogue State 1400 (1-0)
4 z-Dragon Lazorz Pew Pew 1400 (2-0 and farmed both)

Essentially this is ELO which requires lots of good data and I see a number of clans that have not faced any decent clans yet. This is one of the usual faults in ELO and RPI systems.
Image
User avatar
Captain jpcloet
 
Posts: 4426
Joined: Sat Mar 17, 2007 9:18 am
Medals: 69
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3) Battle Royale Achievement (1)
Ratings Achievement (3) Tournament Achievement (7) General Achievement (7) Clan Achievement (5) Tournament Contribution (8)
General Contribution (8)

Re: Algorithm of 400 Clan Ranking for CL3

Postby jpcloet on Fri Mar 25, 2011 8:21 am

Dako wrote:Interesting results. New clans with 1-2 wars get an overpowered rating.


If you are a new clan and go 3-0 against new clans (then 1000 v 1000 etc.) will give you a higher than perceived ranking.
Image
User avatar
Captain jpcloet
 
Posts: 4426
Joined: Sat Mar 17, 2007 9:18 am
Medals: 69
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3) Battle Royale Achievement (1)
Ratings Achievement (3) Tournament Achievement (7) General Achievement (7) Clan Achievement (5) Tournament Contribution (8)
General Contribution (8)

Re: Algorithm of 400 Clan Ranking for CL3

Postby Qwert on Fri Mar 25, 2011 8:41 am

farang these not going to work- because THOTA its not no1. Its better to give up. Like blitz say- hes and Chuuck ranking its only acurate ranking, and all other its pointless mathematic who are not acurate.
Image
NEW REVOLUTION-NEW RANKS PRESS THESE LINK viewtopic.php?f=471&t=47578&start=0
User avatar
Major Qwert
SoC Training Adviser
 
Posts: 9175
Joined: Tue Nov 07, 2006 5:07 pm
Location: VOJVODINA
Medals: 77
Standard Achievement (3) Doubles Achievement (1) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (1) Freestyle Achievement (1) Polymorphic Achievement (1) Nuclear Spoils Achievement (1)
Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (2) Teammate Achievement (1) Random Map Achievement (1)
Cross-Map Achievement (3) Ratings Achievement (1) Tournament Achievement (5) General Achievement (3) Clan Achievement (6)
Training Achievement (2) Map Contribution (8) Tournament Contribution (22) General Contribution (4)

Re: Algorithm of 400 Clan Ranking for CL3

Postby danryan on Fri Mar 25, 2011 9:08 am

A lot of very odd looking results in that output...
User avatar
Lieutenant danryan
 
Posts: 3428
Joined: Tue Jan 09, 2007 8:30 pm
Medals: 152
Standard Achievement (4) Doubles Achievement (4) Triples Achievement (4) Quadruples Achievement (4) Terminator Achievement (3)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (4) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (2) Speed Achievement (4) Teammate Achievement (3) Random Map Achievement (3)
Cross-Map Achievement (4) Beta Map Achievement (1) Ratings Achievement (4) Tournament Achievement (31) General Achievement (7)
Clan Achievement (12) Tournament Contribution (30) General Contribution (14)

Re: Algorithm of 400 Clan Ranking for CL3

Postby FarangDemon on Fri Mar 25, 2011 9:20 am

Wow, I hadn't hoped for such a quick response!

Thanks, jpcloet.
Please provide your data file so I can take a look at improving this metric.

I should add some sort of filter to only include clans that have played a minimum number of wars in the ranking.
It is only meaningful after a certain amount of data, as I believe most metrics would be.

Regarding the non-existent clans, there must be some bug, though, any clan that hasn't played a game within the past year, if you use default setting, should have a score of 1000. I'll take a look and report back.
Last edited by FarangDemon on Fri Mar 25, 2011 9:25 am, edited 2 times in total.
Click image to enlarge.
image

"He came dancin across the water.... FarangDemon, FarangDemon.... mmmhh....what a killer..."
User avatar
Brigadier FarangDemon
 
Posts: 700
Joined: Wed Apr 23, 2008 1:36 am
Medals: 33
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (1)
Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (3) Cross-Map Achievement (3) Ratings Achievement (1)
Tournament Achievement (6) General Achievement (2) Clan Achievement (4) Map Contribution (1) Tournament Contribution (1)

Re: Algorithm of 400 Clan Ranking for CL3

Postby danryan on Fri Mar 25, 2011 9:22 am

FarangDemon wrote:I should add some sort of filter to only include clans that have played a minimum number of wars in the ranking.
It is only meaningful after a certain amount of data.


I'd say 3 wars or a total of 100 games played as a minimum amount of data, then it would make sense. The trouble is, some decay needs to be in there as well as clans' strength change over time. This is a hard nut to crack.
User avatar
Lieutenant danryan
 
Posts: 3428
Joined: Tue Jan 09, 2007 8:30 pm
Medals: 152
Standard Achievement (4) Doubles Achievement (4) Triples Achievement (4) Quadruples Achievement (4) Terminator Achievement (3)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (4) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (2) Speed Achievement (4) Teammate Achievement (3) Random Map Achievement (3)
Cross-Map Achievement (4) Beta Map Achievement (1) Ratings Achievement (4) Tournament Achievement (31) General Achievement (7)
Clan Achievement (12) Tournament Contribution (30) General Contribution (14)

Next

Return to Clan Archives

Who is online

Users browsing this forum: No registered users and 1 guest

Login