<< Back to Clans Forum   Search

Posts 1 - 25 of 25   
Clans sorted by highest-ranked member on 1v1: 4/27/2015 18:14:40


Nex
Level 60
Report
As of 4/27/2015, sorted by best player [ranked] on 1v1 ladder:


1) MASTERs (1st)
2) clanless (2nd)
3) LEA (3rd)
4) WG (4th)
5) M'Hunters (5th)
6) Illuminati (7th)
7) Yin-Yang (9th)
8) Warlighters, counting timon (11th)
9) AhoL (12th)
10) French (13th)
11) Blitz (15th)
12) Lynx (17th)
13) XS (18th)
14) Statisticians (24th)
15) GG (31st)
16) SNinja (34th)
17) Divided We Fall (41st)
18) [BR] (47th)
19) The Juggernauts (50th)
20) Yugoslavia (51st)
21) VIW (52nd)
22) The Ohms (54th)
23) REGL (62nd)
24) Darklords (66th)
25) Sol (68th)
26) The Royal Falcons (69th)
27) Freedom Fighters (83rd)
28) German Warlords (93rd)
29) Appalachian Warlight Federation (100th)
30) Lu Fredd (104th)
31) Incognito (108th)
32) Coalition of Roleplaying Friends (133rd)
33) Vitrix Mortalis (136th)
34) XCD (140th)
35) The G Spot (147th)
36) wolfpack (164th)
37) DeathMatch Club (165th)
38) Football Guys (169th)
39) BIA (170th)
40) Icelandic Turtles (176th)
41) Knights Templar (201st)
42) Lost Wolves (208th)
43) Monsterkill (216th)
44) Tranquility (226th)
45) {rp} (232nd)
46) MSF (243rd)
47) Poon Squad (258th)
48) Horse Guards (259th)
49) 101st (261st)
50) Clan Espanol (276th)




This list would obviously change daily, as the ladder is very dynamic, so I'm not gonna try to keep it updated regularly. It's cool to see so many clans competing!

Edited 4/27/2015 18:15:03
Clans sorted by highest-ranked member on 1v1: 4/27/2015 18:28:20


ChrisCMU 
Level 60
Report
Two clans have 2 players in top 10, Master and WG
Clans sorted by highest-ranked member on 1v1: 4/27/2015 19:12:01


Nex
Level 60
Report
Each clan was sorted by its single top player, Chris. :)

Edit: and also, a third clan (clanless), has 2 in the top 10. Lol

Edited 4/27/2015 19:12:50
Clans sorted by highest-ranked member on 1v1: 4/27/2015 19:23:57


ChrisCMU 
Level 60
Report
would be cool (but lots of work) to see points given for place (reverse of rank). So if you count top 100, #1 gets 100 points, #2 99 points, etc. Then add up total points by clan.

OR, another way would be to add the total ratings for all players by clan.
Clans sorted by highest-ranked member on 1v1: 4/27/2015 19:26:50


Nex
Level 60
Report
That would be awesome, but I'd love it if Warlight could do it automatically. I don't have time to keep updating something like this :)
Clans sorted by highest-ranked member on 1v1: 4/28/2015 06:40:48

DanWL 
Level 62
Report
This sounds like a good idea...
It might be better if the clans were sorted by clan averages.
27 April 2015, 19:40-22:15 UTC. Finished sorting on 28 April 2015, 07:24 UTC clan averages, means:
#    Clan                                                  Score                  Workings
#1 Yin-Yang                                           9                          ((9)/1)
#2 (AHoL)                                             18.5                    ((12+25)/2)
#3 WG                                                     20.4                   ((4+8+26+31+33)/5)
#4 Master                                               22                      ((1+10+20+57)/4)
#5 [Blitz]                                                35.5                  ((15+56)/2)
#6 [Lynx]                                                35.7142857    ((17+27+29+37+39+46+55)/7)
#7 GG                                                       39                     ((31+33+53)/3)
#8 |[XS]|                                                  48                     ((18+38+57+60+67)/5)
#9 SNinja                                                 49.5                 ((34+65)/2)
#10 M'Hunters                                       52                    ((5+74+77)/3)
#11 Yugoslavia                                       52                    ((52)/1)
#12 The Ohms                                        54                   ((54)/1)
#13 Soldiers of Light                             68                   ((68)/1)
#14 French Community                        92.8333333 ((13+45+85+110+148+156)/6)
#15 Divided We Fall                              95.4               ((41+89+102+117+128)/5)
#16 Illuminati                                         104                ((7+151+154)/3)
#17 [BR] FUDEW                                    121.2            ((47+48+106+182+223)/5)
#18 Incognito                                           105               ((105)/1)
#19 The Clan of Warlighters                 109.666...     ((32+104+193)/3)
#20 Freedom Fighters                            131.5            ((83+180)/2)
#21 [V.I.W] Very Important Weirdos  134.4            ((51+72+137+160+252)/5)
#22 Vitrix Mortalis                                 136                ((136)/1)
#23 The Juggernauts Clan                      139                ((50+228)/2)
#24 [REGL] The Red Eagles                   141               ((62+101+191+210)/4)
#25 The "G " Spot                                     152.5           ((147+158)/2)
#26 Appalachian Warlight Federation 162.625       ((100+111+118+119+126+214+254+259)/8)
#27 ✧ XCD ✧                                            164                ((141+162+189)/3)
#27 wolfpack                                           164                ((164)/1)
#28 DMC - DeathMatch Club                 165               ((165)/1)
#29 Lu Fredd                                            170               ((104+236)/2)
#30 Brothers in Arms                             170               ((170)/1)
#31 The Royal Falcons                           179.6           ((69+109+153+283+284)/5)
#32 Coalition of Roleplaying Friends  182              ((133+231)/2)
#33 Icelandic Turtles                              185              ((176+194)/2)
#34 LEA                                                     186.5            ((3+116+171+178+192+270+274+288)/8)
#35 DARKLORDS                                     199               ((64+114+265+272+280)/5)
#36 Statisticians                                      200.25          ((24+248+251+278)/4)
#37 **[KK]**                                            201               ((201)/1)
#38 German Warlords                            202.666...     ((94+250+264)/3)
#39 Knights Templar                              203                ((203/1)
#40 Footballguys                                     208.75          ((169+205+206+255)/4)
#41 [M4K] M-M-M-MONSTERKILL     216                ((216)/1)
#42 The Lost Wolves                              224.75           ((207+220+233+239)/4)
#43 Tranquility                                        226                ((226 )/1)
#44 {rp} The Roleplayers Guild            232                ((232)/1)
#45 The Poon Squad                                258                ((258)/1)
#46 Horse Guards                                    259                 ((259)/1)
#47 {101st}                                               268                 ((261+275)/2)
#48 [MSF] Militaires Sans Frontières 265.333...      ((243+272+281)/3)
#49 Clan Español                                     276                 ((276)/1)


Edited 4/28/2015 06:41:45
Clans sorted by highest-ranked member on 1v1: 4/28/2015 07:52:23


Thomas 633
Level 56
Report
since when is one of our members 69th on the ladder?
Clans sorted by highest-ranked member on 1v1: 4/28/2015 08:14:28


Don [ Ω ]
Level 62
Report
lol... Mihai Cuceritorul... ;-)... but i guess you checked already

Edited 4/28/2015 08:14:41
Clans sorted by highest-ranked member on 1v1: 4/28/2015 11:55:21


Wenyun 
Level 59
Report
It might be better if the clans were sorted by clan averages.
But this causes problems, as it prefers people with lower amounts of people, most preferably just a sole #1.

Also it makes this funny situation where a clan with just #2 wins against a clan that dominates with #1, #3, #4, and #5 (13/4 = 3.25)
Clans sorted by highest-ranked member on 1v1: 4/28/2015 13:04:47


ChrisCMU 
Level 60
Report
Right, average can favor small sample size.

Look at SNinja. If their person ranked 65th left the ladder (leaving only the person ranked 35th), they jump from 9th on your list to 5th, just because someone left the ladder.
Clans sorted by highest-ranked member on 1v1: 4/28/2015 14:13:40

DanWL 
Level 62
Report

since when is one of our members 69th on the ladder?

The data was correct at the mentioned time, 27 April 2015, 19:40-22:15 UTC. You viewed it several hours later, when the rank and rating changed.

prefers people with lower amounts of people

average can favor small sample size


This is the only disadvantage, however it's the only way I know of that sorts clans, as a whole in terms of how good participating members are.
Clans sorted by highest-ranked member on 1v1: 4/28/2015 14:40:07


ChrisCMU 
Level 60
Report
I think total rating is better than average rank.
Clans sorted by highest-ranked member on 1v1: 4/28/2015 14:46:42

DanWL 
Level 62
Report
It took me 3 hours 30 mins. to do the averages and I'm probably not going to spend more time doing this, unless there's a short-cut / automatic way of doing it.
Clans sorted by highest-ranked member on 1v1: 4/28/2015 15:51:57


ChrisCMU 
Level 60
Report
Yikes, I agree.

I've copied ladder rankings in the past, and it is pretty quick to format if you use the right combinations of programs (excel, text editor, etc). It takes about 5-10 minutes to get the entire list formatted how you want (rank, player, rating)...if it is taking you a long time there, I can give you tips on doing that fast. I think I pasted into text editor first, eliminated "new!" in mass, standardized spaces/tabs, inserted comma separator...then opened comma separated in excel. All of this is very fast in a text editor (I use Ultra Edit but there are many).

The issue after that is then grouping the player. That has to be done manually since clans are icons, not an item in the list you can group on. If you past into text editor first, it does not carry over the icons (or arrows up/down). That makes formatting easy, but also loses the clan icon entirely. Pasting from site to excel creates big format issues though. Pasting into Word first looks nice (table elements line up), but since clan tag is in same column as Player name, that is still hard to separate.

If I could find a way to return the picture name in excel, you could do it.
Clans sorted by highest-ranked member on 1v1: 4/28/2015 16:00:48


ChrisCMU 
Level 60
Report
Hmm, I found a workaround. Takes a few steps but not horrible.

1) paste into excel
2) use a Macro to extract URLs from images:

Sub ExtractURL()
Dim shp As Shape
Dim sTemp As String

For Each shp In ActiveSheet.Shapes
sTemp = ""
On Error Resume Next 'go to next shape if no hyperlink
sTemp = shp.Hyperlink.Address
On Error GoTo 0
If sTemp <> "" Then
shp.TopLeftCell.Value = sTemp
shp.Delete
End If
Next
End Sub

3) Use Lookup to grab name based on URL (need to make lookup table)

Edited 4/28/2015 16:46:30
Clans sorted by highest-ranked member on 1v1: 4/28/2015 17:19:17


ChrisCMU 
Level 60
Report
So I made a google sheet from this that displays the clan name for each person (I only did lookup for top 10, but all clans would need to be added):

https://docs.google.com/spreadsheets/d/12xRryjzawY7hb4kNyoWyvC2K4dL7GblN4VTMIHKIXko/edit?usp=sharing

It is then easy to do any kind of math you want on it. There could also be a tab for each ladder.

The only real work is copying the ladder as it currently is, running the macro in excel to extract the URL (I am going to look into a Google Apps Script to replace that macro: https://support.google.com/docs/answer/2942256?hl=en), then pasting into the google sheet. It would be nice if I could auto retrieve it somehow.

At any rate, we can do our own clan rankings this way (based on the ladders). Maybe Fizzer would adopt it some day.
Clans sorted by highest-ranked member on 1v1: 4/28/2015 17:26:47


ChrisCMU 
Level 60
Report
I think I will split this off into a separate discussion on clan ranking system and grab all the ladder data and bring it in.

If you are interested in discussing this rating system (how to calculate it), let me know (I may do chat game to discuss).
Clans sorted by highest-ranked member on 1v1: 4/28/2015 17:38:49

DanWL 
Level 62
Report
You can right-click clan icons and select "Save Image As..."
Clans sorted by highest-ranked member on 1v1: 4/28/2015 17:46:21


ChrisCMU 
Level 60
Report
Yeah, but why? All I need is the ID anyway. I will probably just copy the whole clan list, use my macro to extract the URL, DONE.
Clans sorted by highest-ranked member on 1v1: 4/29/2015 01:45:11


Bane 
Level 60
Report
MSF hangin out after a clan battle:
Clans sorted by highest-ranked member on 1v1: 4/29/2015 01:47:24


Nex
Level 60
Report
You should join clan league
Clans sorted by highest-ranked member on 1v1: 4/29/2015 12:28:33


Poseidó̱nas
Level 57
Report
You should join the clan league fan club?
Clans sorted by highest-ranked member on 1v1: 4/29/2015 12:48:14


Thomas 633
Level 56
Report
you are trolling worse than me with that comment
Clans sorted by highest-ranked member on 1v1: 5/1/2015 17:26:15


BONE
Level 52
Report
yeah but at least he's funny
Clans sorted by highest-ranked member on 1v1: 5/1/2015 18:31:09


Nex
Level 60
Report
Funny you mention that; I might actually be willing to be part of the league's management team, if they'll have me.
Posts 1 - 25 of 25