28-02-2014, 12:11 AM
It looks like the RG and Legionnaire lists are the same. And I see players in my house missing from certain lists (e.g. Evildan and Malong from Wardens, Eve from Rangers, etc), and others being counted as in multiple houses (numbers don't add up).
If you want help making this a Google doc leveraging the API to aggregate, let me know. For example, to list classes by popularity, it's:
If you want help making this a Google doc leveraging the API to aggregate, let me know. For example, to list classes by popularity, it's:
Code:
=ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(" ",Heroes!C2:C)," ")&{"";""}),"select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 12 label Col1 'Class', count(Col2) 'Number'",0))(27-02-2014, 09:42 PM)Buttercup link Wrote: [glow=black,1,150]Royal Guards[/glow]
[glow=black,1,150]Legionnaire[/glow]
[/spoiler]
![[+]](/images/collapse_collapsed.png "[+]")
Spoiler
Quote Board is on Discord (last updated 2023.09.07)
"When I feel bad, I read your quote board." - Corndog
Tofu: People call Tricksters racist, yet we have the most Muslim members of any house.
PCK: If Islam is a religion of peace, and Tricksters have the most Muslims, then is House of Tricksters the house of peace?
Falankos: I always knew that we were the good guys.
"When I feel bad, I read your quote board." - Corndog
Tofu: People call Tricksters racist, yet we have the most Muslim members of any house.
PCK: If Islam is a religion of peace, and Tricksters have the most Muslims, then is House of Tricksters the house of peace?
Falankos: I always knew that we were the good guys.