Active Clan ELO ranking 2011-[update 31 dec 2011]

by **FarangDemon** on Thu May 05, 2011 7:21 am

qwert wrote:well im not good in these coding, if you can notice all work im doing totaly manualy.

If you are willing to compile the clan war results to an excel file I can do the coding for you. Then the only thing you have to do manually is maintain the excel file containing clan war results. I could write a script to calculate all your rankings using your formula - so then you would only have to press a button.

by **Qwert** on Thu May 05, 2011 10:11 am

excel file.
I have all results in page 1 second post, why you dont take and write these excel file, its not take you to much time,because i have less then 100 chalenges finished

by **Qwert** on Thu May 05, 2011 4:19 pm

well number of chalenges grows.
68 finished
39 active
these mean that every two days ,one chalenge finished. If these going these dynamic we will end year with ove 200 chalenges.

by **Dako** on Sun May 08, 2011 12:22 pm

I think we need a database of results for all the wars and some simple form to output data in whichever format you desire.

by **FarangDemon** on Thu May 12, 2011 4:32 pm

qwert, sorry to pollute your thread with this topic that is unrelated to your specific ranking system...
But the topic is relevant because having a database of clan war results could help you process your updates easier (especially if you were using a script instead of performing manual calculations).

qwert wrote:excel file.
I have all results in page 1 second post, why you dont take and write these excel file, its not take you to much time,because i have less then 100 chalenges finished

We need dates, which you don´t have. Also want results from old wars and clan league to be in it. I already have results for Clan League but its hard to put a date to when clan league challenges finished. I just guestimated for those end dates in the data I used.

I could put it together but my goal is not to create a ranking for today only. My goal is to create a ranking for any day I want in the future. This requires someone to maintain clan war results in a file or database that anybody can access at any time in the future, as Dako recommends. I don´t have the time now to step forward to commit to do this so I'll have to wait until someone is willing to do this.

Dako wrote:I think we need a database of results for all the wars and some simple form to output data in whichever format you desire.

I'm glad you see the value of this. I think jpcloet will respond with his opinion on this in my algorithm of 400 thread soon.

by **Qwert** on Thu May 12, 2011 5:22 pm

i think that jpcloet have these database with date

by **jpcloet** on Thu May 12, 2011 6:42 pm

Yes, the CD's have a file which I need to review.

by **Qwert** on Thu May 19, 2011 2:10 pm

new update of board,now its FOED leader with 1173 points.

by **John Deere** on Sat May 28, 2011 8:00 pm

nc:PACK 27 vs SOH 16

PACK 39 BSS 21

by **Qwert** on Sun May 29, 2011 7:38 am

add to board
KOA vs SOH 21-27 [49]

BSS vs PACK 21-39 [58]

cc2:EMP vs DBC 32-9 [24]

nc:PACK vs SOH 27-16 [39]

by **Qwert** on Sat Jun 04, 2011 5:07 am

two chalenge add
nc:OSA vs WLDG 22-21 [45]

nc:GRIM vs PIG 25-18 [38]

by **FarangDemon** on Tue Jun 14, 2011 8:30 am

I can do only 2011 data later, so we can compare, but I'm a bit busy now in RL.

by **Qwert** on Sat Jun 18, 2011 5:52 am

finished chalenges
DEVB vs NEM 23-27 [48]
cc2:ID vs TFFS 17-24 [46]
cc2:DEVB vs BPB 18-23 [38]
TNC vs 1RFG 23-19 [37]
cc2:AOC vs TFFS 26-15 [33]
cc2:EMP vs NEM 30-11 [31]
cc2:TSM vs AFOS 24-17 [37]
cc2:THOTA vs BPB 24-17 [31]
------------------------------------
new start
MM vs WLDG
LEG vs AOD
DEVB vs PIG
cc2:KORT vs FOED
cc2:THOTA vs AOC
cc2:TSM vs LOW
TNC vs LOTZ
------------------------
update board

by **Qwert** on Fri Jun 24, 2011 1:14 pm

added to board-
DYN vs OSA 35-25 [54]
GRIM vs RISK 28-13 [41]
AKA vs TNC 22-18 [37]
OSA vs BSS 27-33 [57]
cc2:KORT vs G1 24-17 [28]
RISK vs LOTZ 26-15 [31]
VDLL vs AKA 22-19 [40]

new activated chalenges
KOA vs OHIO
cc2:TOFU vs EMP
GRIM vs MYT
ID vs G1

by **Eyestone** on Sat Jun 25, 2011 7:39 pm

Hehe, The Pack is still on top... Very nice.

Btw: You have forgotten about the CL3 semi finals.

by **Qwert** on Sun Jun 26, 2011 6:11 am

no i dont forget, kort lost and still dont see official end of second semi.

by **therev1957** on Mon Jun 27, 2011 1:30 pm

The pack just locked in the win in the Newcomers Cup! =D>

We are new, but you WILL be hearing from us!

by **Qwert** on Sat Jul 02, 2011 9:36 am

add to table
cl3: IA vs TSM 10-9 [18]
GRIM vs KOA 21-27 [50]
cc2:TOFU vs BOFM 22-19 [32]
TNC vs MYT 27-33 [56]
---------------------------
new active
TNC vs PIG

by **Qwert** on Mon Jul 11, 2011 4:54 am

add to table
cc2:IA vs FOED 12-29 [48]

1RFG vs RISK 24-16 [53]

nc:GRIM vs PACK 17-26 [42]---(6th consecutive win for pack in 2011 year)

---------------------------
new active
AKA vs LOTZ
OSA vs VDLL
KOA vs IGF
TNC vs DBC
----------------------
106 chalenges finished in 2011

by **Leehar** on Mon Jul 11, 2011 8:27 am

What I'd like to know about this ranking, is how much of an effect the end score has on it? It seems to me it's just a simple win/loss calculation over amount of games? Rather than the actual score between the 2. So for example, I wouldn't expect bofm to lose as many points when they're already playing 13v2 in score. Sometimes you can mostly tell which team will win a contest, does that mean it's not worth playing in, when it's still up in the air how close you can get to victory?

by **Qwert** on Sun Jul 17, 2011 4:49 am

""by Leehar on Mon Jul 11, 2011 3:27 pm

What I'd like to know about this ranking, is how much of an effect the end score has on it? It seems to me it's just a simple win/loss calculation over amount of games? Rather than the actual score between the 2. So for example, I wouldn't expect bofm to lose as many points when they're already playing 13v2 in score. Sometimes you can mostly tell which team will win a contest, does that mean it's not worth playing in, when it's still up in the air how close you can get to victory?""
i hope that im ehplane to you in PM.

new board update

by **John Deere** on Sun Jul 17, 2011 8:57 pm

1-PACK---6---1258

Finally a clan ranking system that got it right...... :lol:

by **Lubawski** on Sun Jul 17, 2011 9:39 pm

I like how this system encourages farming, especially of new clans.

:roll:

That's one of the reasons we moved away from a ELO ranking long ago.

by **John Deere** on Sun Jul 17, 2011 10:14 pm

Lubawski wrote:I like how this system encourages farming, especially of new clans.

That's one of the reasons we moved away from a ELO ranking long ago.

Are you suggesting we have been farming? Well there was KOA..... :lol:

by **grifftron** on Mon Jul 18, 2011 3:26 am

Lubawski wrote:I like how this system encourages farming, especially of new clans.

That's one of the reasons we moved away from a ELO ranking long ago.

Then stop looking at it, you clearly have not moved away from it if you keep following it... And we are a new clan, are we suppose to farm old clans to be worthy?