Gnuffone's alt Belzebu will not affect WG, etc.
Interesting. His alternate personality sure does not like himself.
Lol. I stand corrected. I just had to assume Belz was Gnuff, because, you know, high-ranked Italian and Gnuff is too proud of his 2400 rating to play the RT ladder regularly. He knows he'd lose that rating if he did. :)
What's your formula again? I can trivially do this for all clans if you want me to, although not continuously like a Sheet.
Here's roughly the logic behind its setup:
Using the formula you gave me to track an individual player's performance on a ladder, I then listed each player and his performance on all four of the ladders. So, row A would be names; B 1v1 ladder rating; C 1v1 ladder rating tracking formula; D & E repeat of B & C for 2v2 ladder, D & E repeat for 3v3 ladder; E & F repeat for realtime ladder.
So, to calculate the total value of a clan, in row G goes the formula, written out in English, =sum(sum of clan's 1v1 ratings [of ranked players] + sum of clan's 2v2 ratings [of ranked players] + sum of clan's 3v3 ratings [of ranked players] + sum of clan's realtime ratings [of ranked players]).
After the initial setup, the only thing I have to do to keep it flowing is keep track of the clan's membership. The spreadsheet automatically counts any unranked player as worth $0. I'm sure it's not the most elegant way to do it, but so far I'm pleased with the results. :)