+- NordInvasion Forum (https://forum.nordinvasion.com)
+-- Forum: Discussions (https://forum.nordinvasion.com/forumdisplay.php?fid=7)
+--- Forum: Community Discussion & Engagement (https://forum.nordinvasion.com/forumdisplay.php?fid=14)
+--- Thread: The Great List of Swadian Heroes (/showthread.php?tid=19971)
Re: The great list of swadian heroes - Malong - 28-02-2014
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:
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 "[+]")
SpoilerRe: The great list of swadian heroes - Handef_Snizel - 28-02-2014
VLKA_Handef_Snizel - Royal Gaurd
Re: The great list of swadian heroes - Buttercup - 28-02-2014
(28-02-2014, 12:11 AM)Malong link Wrote: 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).[/quote]
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))
[quote author=Buttercup link=topic=23654.msg167956#msg167956 date=1393537356]
[glow=black,1,150]Royal Guards[/glow]
[glow=black,1,150]Legionnaire[/glow]
[/spoiler]
Kip was kind enough to do that for me, and ill fix my mistake, but thank you for the offer.
Re: The great list of swadian heroes - Buttercup - 28-02-2014
The list, and the stats should be fully up-dated as of now. if anyone see's any mistakes, let me know.
Re: The great list of swadian heroes - Malong - 28-02-2014
(28-02-2014, 12:22 AM)Buttercup link Wrote: The list, and the stats should be fully up-dated as of now. if anyone see's any mistakes, let me know.Just from a quick look at Commando heroes:
The Royal Guard and Legionnaire lists are still copies of each other.
Names aren't in their alphabetical place: under RG, Diamond_drop, Handef_Snizel, Peeper. This is not a comprehensive list.
Names are listed twice in the same category: under Zweihander, _Gismo_, Cherry, Victoria. This is not a comprehensive list.
Some characters are listed as the wrong hero: e.g. JustMicky listed as Zweihander instead of RG. This is not a comprehensive list.
I think the Google doc idea would address most of these.
Re: The great list of swadian heroes - Buttercup - 28-02-2014
fixed.
Re: The great list of swadian heroes - BOE - 28-02-2014
VLKA_BOE
Royal Gaurd
Re: The great list of swadian heroes - BigBoy - 28-02-2014
VLKA_Frost
Royal Guard
Re: The great list of swadian heroes - _Legion_ - 28-02-2014
ON_Legion
Zweihander
Re: The great list of swadian heroes - Malong - 28-02-2014
(28-02-2014, 12:22 AM)Buttercup link Wrote: if anyone see's any mistakes, let me know.New names were put at the end instead of in place alphabetically.
Names aren't in their alphabetical place: e.g. Zweihander list.
Names are listed twice in the same category.
Some characters are listed as the wrong hero.
Some character names appear in multiple categories.