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
Voted Friendliest NordInvasion Player
Quote Board is on Discord (last updated 2025.07.24)
"When I feel bad, I read your quote board." - Corndog
Nka: You’re playing it smart, always [using] logic, and they get pissed.
Kaasovic: God, this guy is unbeatable. I feel defeated in every verbal argument we end up in. Good job, Sir.
Odi: Hasn’t [PCK beaten] the game at this point?
Quote Board is on Discord (last updated 2025.07.24)
"When I feel bad, I read your quote board." - Corndog
Nka: You’re playing it smart, always [using] logic, and they get pissed.
Kaasovic: God, this guy is unbeatable. I feel defeated in every verbal argument we end up in. Good job, Sir.
Odi: Hasn’t [PCK beaten] the game at this point?