Its master shake

Don't you steal my name for him Spudz! Don't you do it!

@turtle: yea you were second with total points on that point but if you look carefully you can see it's ordered on win% and with that you were tied with BR on the moment for 4th and i could even have put you below BR but your max points and total points were higher

https://docs.google.com/spreadsheet/pub?key=0Arn0ahIN9qcsdDM2VU9mUnFONmltYjN1ZlBWTDlXV3c&gid=2

I think "Points Assigned" (Total) does not include last 3vs3 tournament.

Ineffable has been pretty busy the last few days.

Any word from TWM?

https://docs.google.com/spreadsheets/d/1Viz3GlgloChi50YIkMjUsU30xuOTfmd1icPsNrgc8FI/edit#gid=0

updates group B: 62,34% compeleted

clan   score   win%  1v1 win%  max points finished games
20     120     76%   68%       206        45
WarL.   60     56%   50%       197        32
French  70     55%   66%       177        40
VIW     57     43%   40%       165        40
BIA     61     41%   44%       148        46
XCD     54     40%   45%       157        42
REGL    55     40%   39%       153        43

20 is clear in front of all other clans like expected. Behind them WarLighters managed to take the second place for now in win% but since they still are a few games behind in total their score is lower then some others below them


Group C: 73,16% completed

clan   score   win%  1v1 win%  max points finished games
Blitz  146     79%   71%       206        52
Lynx    96     69%   62%       201        42
BR      95     58%   66%       165        50
SNinja  82     57%   63%       170        46
Turtle  94     56%   56%       166        50
Swirve  31     17%   14%        92        53
Ohms    22     16%   18%       114        45

waiting for the desi-mod judgement to say anything about changes in this group but it's looking pretty solid for Blitz and Lynx considering their win%

Since Ineffable seems to be out I have made a replica spreadsheet which took me quite some time and still isn't formatted perfectly, however it should work for now. I'll work on replicating "Player Statistics" later and play on adding functions for recurring players over multiple seasons.. anyways

https://docs.google.com/spreadsheets/d/1_HlNhRewdI3LBc81QSrsOOOSXmHxEkf5KTMNQPg4r28/edit#gid=168045224

Group A: 59.09% completed

Clan  Points    Win%  Max Points
Apex    101    83.78%    221
WG      100    73.17%    205
WM      74     65.71%    202
GG      62     45.24%    164
AHoL    40     30.77%    152
101st   24     22.22%    144
MASTER  41     30.23%    141

You now... we are lagging after you, so why update :)

@lolo: think you are missing 1 game for a player since i get in my sheet on 59,09% if i get rid of 3 players with a game which is 1,5 game but you can't play a game on your own

edit: your problem is that Julkorn of GG has 1 win and 4 losses while he only has 3 losses

this might be some sums to help you automate the sheet so you only have to concentrate on wins and losses.
for points assigned you might be able to use "=sum((D4+E4)*3)"
for max points you might use "=sum((6-E4)*3)"

Edited 7/17/2014 18:48:18

this post is for the tournament that are already decided for who wins and some of them still have games running in them.

Group A
1v1 MME     AHoL   NoobSchool  4-2 surprise win since some said Apex was better of without him playing for them
1v1 ME 0%   WG     Summer      5-1 Apex had 5 wins as well but Summer won their duel
1v1 Islands Apex   Widzisz     6-0 clear victory showing apex dominance since 2 above have also Apex (sharing) 2nd


Group B
Strat 1v1   French 125ch209    6-0
1v1 MME     French Niko        6-0 French showing very strong performance in 2 tournaments
1v1 ME 0%   20     szeweningen 5-1 WL had 5 wins as well but szeweningen won their duel
1v1 Guiroma 20     Heyheuhei   6-0 HHH showing his strengh on the guiroma template


Group C
1v1 MME     Blitz  potato      6-0 potato showing his strengh and reason why he got invited to WM
1v1 ME 0%   SNinja McTwist     5-1 surprising win by SNinja but Blitz had 5 wins as well
1v1 Guiroma Blitz  Jefferspin  5-1 another tie between SNinja and Blitz but this time Blitz won their game
1v1 Islands Turtle Wohoo       6-0 surprising victory by the turtles but Wohoo might be alt but claims to be brother of
1v1 Turkey  Lynx   Taishõ      4-2 both of the losses are due to boots since he was on vacation but forgot to expend his time after 10 days

Updating the spreadsheet with those functions. I'm not good at spreadsheets but I missed how well Ineffable's looked. :( I hope he's back soon.

Chat with me tomorrow on skype and i can help you

It's completely automatic now thanks to Wakanarai's suggestions. I'll need help when creating the player statistics. :)

Group A
1v1 MME AHoL NoobSchool 4-2 surprise win since some said Apex was better of without him playing for them

Whoever said this clearly doesn't understand the power of alcohol. Who was this?

Thank you Noob! I finally have a title for my unreleased record. The Power of Alcohol

Edited 7/18/2014 04:35:58

Szeweningen... we'll get you next time!

...Arun, you have to get to groupA first, otherwise there will be no "next time"..

^burn