Sheet updates ranks automatically when points are updated, but doesn't sort automatically (not sure if that's even possible in Google Sheets).

The tournaments of cycle 3 were created.

Players have 7 days to join the tournaments except for Lombardy Swap for which there is only 1 day (due to it being a (free) coin tournament).

I already ran the draw for which clan can decide the templates for cycle 4:

EDIT - Results of the draw were invalid, a new draw was done - see below.

Edited 10/15/2019 07:48:19

do you mean 101st or dd?

autosort is possible. i've implemented one in my qm-sheet.

i have a seperate sheet to make that happen though.
on that seperate sheet i calculate the score and use RANK() to identify the ranking.
on the main sheet i use ADDRESS(MATCH(COLUMN())) to find the specific row and give the column that should be shown.

if you need further help on this, feel free to contact

Edited 9/29/2019 22:13:48

New draw:

> set.seed(4)
> sample(c({101st}","Apprentice","CORP","FCC","|GG|","Hawks",
"LuFredd","Masters","ONE!","Outlaws","SNinja","Statisticians","[V.I.W]"),6)
[1] "Masters" "{101st}" "FCC" "CORP" "[V.I.W]" "Outlaws"
> sample(c(rep("1v1",4),rep("2v2",2)))
[1] "2v2" "2v2" "1v1" "1v1" "1v1" "1v1"

Masters & {101st} can select a 2v2 template,
FCC, CORP, [V.I.W] & Outlaws can select a 1v1 template.

The previous draw was invalid because Avengers dropped out of cycle 3 and going forward - I should have waited with the draw until all tournaments had started.
Additionally, I made a copy-paste mistake in the results, so this is the only valid draw.

Deadline for submitting templates is Saturday October 26. If no template is submitted, previously used templates will be re-used in order of time since they were last used (least used first).

Edited 10/15/2019 08:00:10

Templates for Cycle 4 have been chosen:
1v1 Gotham City - https://www.warzone.com/MultiPlayer?TemplateID=1262168
1v1 Landria - https://www.warzone.com/MultiPlayer?TemplateID=1262169
1v1 Belarus - https://www.warzone.com/MultiPlayer?TemplateID=1262170
1v1 Georgia Army Cap - https://www.warzone.com/MultiPlayer?TemplateID=1262171
2v2 Asian Wastelords - https://www.warzone.com/MultiPlayer?TemplateID=1262172
2v2 GME II - https://www.warzone.com/MultiPlayer?TemplateID=1262173

The deadline for lineups (and tournament creation) is Saturday November 16, giving everyone almost 3 weeks to send their lineups. As with cycle 2 and 3, I will send a PM to all clan contacts with this information as well.

As always, clans are welcome to field incomplete teams.

*NEWS*

---

All tournaments for cycle 4 are created.
Stats take the #1 spot from masters!

---

RANKING

1	Statisticians	8502
2	Masters		8326
3	FCC		6090
4	Outlaws		5800
5	SNinja		5720
6	Apprentice	5526
7	|GG|		5244
8	ONE!		5020
9	[V.I.W]		4636
10	CORP		3836
11	LuFredd		3058
12	Polish Eagles	2560
13	Blitz		2142
14	{101st}		2110
15	Hawks		1870
16	M'Hunters	1200
17	USSR		400
18	Avengers	300

edit: news

Edited 11/17/2019 22:54:45

Can I register a team from TLA?

@LND: yes, just provide contacts and we will message you when you need to provide lineups or a template.

About templates, the draw for cycle 5 was done, with the following result.
Note that [REGL] was a lock due to never having chosen a template before, the others were chosen from the teams that have joined all 4 cycles and only once got the opportunity to determine a template.

> set.seed(5)
> c("REGL",sample(c("|GG|","Hawks","LuFredd","ONE!","SNinja","Statisticians"),5))
[1] "REGL"    "Hawks"   "ONE!"    "SNinja"  "|GG|"    "LuFredd"
> sample(c(rep("1v1",4),rep("2v2",2)))
[1] "2v2" "1v1" "1v1" "2v2" "1v1" "1v1"

Consequently:
* [REGL] and SNinja can choose a 2v2 template.
* Hawks, ONE!, |GG| and LuFredd can choose a 1v1 template.
Previously used templates up to cycle 3 can be chosen again.

 1	Statisticians	8112
 2	Masters		7726
 3	Outlaws		6614
 4	SNinja		5850
 5	|GG|		5532
 6	FCC		5170
 7	ONE!		5080
 8	CORP		4758
 9	Apprentice	4682
10	[V.I.W]		4478
11	Polish Eagles	3066
12	LuFredd		2994
13	{101st}		2530
14	Blitz		1732
15	Hawks		1636
16	M'Hunters	1080
17	USSR		 400
18	Avengers	 270
19	[REGL]		   0

We also have some new cup winners with Outlaws, CORP and Statisticians joining the club! FCC and Masters are still holding the most cups, with 3 each.

Sweet - contacts:
myself
https://www.warzone.com/Profile?p=9292269500