@Dr. Stupid: You have like no formulas at all.. Share the spreadsheet with ChrisCMU or I and we can make it so you only have to update the standings.

Sent you a mail, lolowut. I hope that's what you need.

2 DrStupid, take a look to Wakanarai's spreadsheet, there you can clearly see formulas. Copy them and you will be only need to update some number, not the whole spreadsheet :)

@Dr. Stupid Why is it that in Guiroma, only 3 matches were played for each player, yet you have given a score of 5 wins to LEA with 2 wins, 4 to Stahlgewittern with 2 wins. 3 to T4R, for the equal amount of 2 wins?

Edited 4/1/2015 14:28:30

because he gave 5 points to the winner 4 points who became 2nd etc. He didnt gave any points for each win

So there's no rule for shared places?

He must have messed things up. He needs to use the sheet Lolo is using and put the correct clans in. It has all the formulas built in.

@ Facetroll
Tiebreakers in Warlight are determined by who won against whom.

For instance:

If
Person A completes a tournament with 2 wins, 1 loss
and
Person B completes a tournament with 2 wins, 1 loss
but,
Person A beat Person B in their game, Person A wins the tiebreaker and is placed higher than Person B.

Unless someone tells me otherwise, I would assume that Clan League also functions this way.

@ ChrisCMU

I shared the edit link with Lolowut and he is looking into the template for me. Thanks!

There are no tiebreakers in clan league.

Points are assigned for each game win, tournament wins have nothing to do with it (in your scenario player A would have won that RR, but they both got the same points from it). Those are just nice to know, but most points from games wins the league. Take a look at Lolowut's sheet from last season.

Edited 4/1/2015 21:48:59

@Dr. Stupid: Actually it goes in a circle. LEA lost vs T4R, T4R lost to Stahl, Stahl lost to LEA

Ok, got the scores updated in D, so this now includes all completed games so far in all tournaments.

The scoring changes change the landscape a little though....

Now our clear front runner is Stahlgewittern with a total score of 64

After them, we have the LEA, T4R, and Spanish clan clustered together at scores of 47, 42, and 37.

More distantly, the Lost Wolves trail with only 22 total points.

and bringing up the rear, Vaders Fist with a grand total of 6

(Thanks everyone for helping out with the scoring methodology!)

2nd place ain't too bad, I suppose. But that means we'll likely be fighting Illuminati next season :/

Incognito dropped out huh? I though they had a pretty good chance.

Score only for C: XS 111, Brazil 83, REGL 62, Turtles 62, SNinja 58, FBG 24
The ladder update makes it much easier to keep score BTW!

Edited 4/4/2015 04:34:22

Yes thanks almostricky.....I haven't had computer access in days...

Group A standings sorted by Win%

Group A is 40.69% completed.

Clan    Points      Win%    Max Points   Games Left     
GG        82       77.42%      217          35                
Apex      60       72.00%      219          41
WM        41       52.00%      202          41                
WG        41       46.43%      192          38              
French    32       44.83%      185          37                             
WL'ers    18       27.27%      183          44               
AHoL      24       25.00%      173          38

Okay guys, so from now on we will have games left. I wait until roughly 35-40% completion because that's when this knowledge becomes useful in seeing who's really in what place. Once we hit 50% completion I shall be sorting the table by max points. Now, why is this information so useful now, Lolowut? Well glad you asked. You see if we look by win% between GG and Apex, and look at max points, you may think: Wow, Apex is very close to GG atm. While I hate to admit this, Apex is not 'very close' atm. GG has completed 7 more games than apex and only lost 2 maximum points. This means that for every 7 games, GG loses 2/3rds of a 1v1 game. That's pretty impressive. Apex historically does not dominate 2v2 and 3v3. Last year we lost 14 total games, we're 36% of the way through and lost 7 games, which means we're projected to lose much more games this season. GG is projected to lose 13-15 games, but has already cleared some important matchups, they're in a really good lead atm. I wish I could say otherwise, but basically Apex needs to win every single one of their GG matchups from now on in order to take some serious points away from them. If Apex can win both 3v3s vs GG then it will start looking better because of the net difference of 10 points each game.

1st and 2nd aside, this is a very competitive season in general. French WM and WG are very close to each other, and each has a shot at bringing Apex or GG down a rank or 2 if they win matchups.

Things are looking better for AHoL as I imagine that the Warlighters have found AHoL's hidden stash of alcohol, resulting in drunk Warlighters and very very angry AHoLs. Maybe this anger will get AHoL out of relegation spot. Who knows?

tl;dr: GG's lead is bigger than first glance, WM WG and French are really close, Warlighters stole AHoL's liquor and now AHoL is mad.

edit: a game finished right after I posted so I updated standings a bit.

Edited 4/7/2015 01:15:10

lol.. nice post

!!! nice one. :-)

lolowut I should just give you the Group C information and let you write us up a fancy post.

since the other tournaments just had updates i will do a update as well

Group B: 66.67% finished (so exactly 2/3)

clan   score   win%  max points games left
Blitz  105     83%     178         19
Lynx    98     78%     174         19
Master  81     57%     142         15
101st   39     32%     111         18
BIA     32     27%     106         19
VIW     26     20%     108         20

Lynx has closed the gap to Blitz and is now just 7 points behind so everything can still happen for the 1st place in the group. Masters is slowly falling behind though and they can't afford to lose many more games or Blitz and Lynx will get out of their reach which will probably mean they will be staying in Group B next season.

On the bottom of the list we still have VIW but they are climbing back up like they don't want to relegate so it will be interesting to see how the battle for 4th will develop in the coming weeks with 101st currently in the lead but just by a small margin.

Besides that there is a 3rd tournament where the winner has been decided even though there are still 4 games ongoing in that tournament. The winner here is #QB# from Blitz which means Blitz is now 3 out of 3 wins (1 3-way tie with Lynx and Master)

At the moment there are in total still 5 players who are undefeated which are Cruass and Roooob from the 3v3 SR for Lynx, Bigchps147 from the 2v2 China for Lynx, JSA from Lynx who is in both of the previous called teams and KKND from Blitz who is in the S1v1 and 2v2 szeurope tournaments (only finished 1 game each tournament).
After those 5 the next on the list is MotD who is 10-1 total and clearly best performing of Masters till this point.