| 
		
	
	
	
		
	Posts: 2,079Threads: 285
 Joined: Jan 2012
 
	
	
		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]
_Evildan_AbekrampeV2
 Adam242411_PL
 Alex
 Bananixx
 Belenos
 Benschie
 BlackKnight
 Blade
 Bradapple
 Brennanx
 Burnnt
 DatShield
 Delion
 DerekVinyard
 Gimli_I
 Gneiss_Preasts
 Greekdragonkdl
 Guard_Kip
 Harlaus
 Hawkens
 Human_being
 Israfel
 Juiced
 JustMicky
 K4mi
 Khmer
 KnightSimpleton
 Kosh
 Latina_Heat
 Leech
 Legend
 MP3jkl
 Mr_Awesome
 Nici_inf
 NickyJ
 Niezdara_Guard
 Nka19
 Pollypo
 Ragnash
 Rogue
 RWCostanzo
 RX-10
 Saladin
 Sargent_X
 Sativa
 Seaward
 Shieldling
 Sinister_Soldier
 Srellian
 Tararil
 Tea
 Tiberias
 Tjaviboy
 Trojkatny
 Tyr
 Vovgre
 Yabu
 Peeper
 [/spoiler]
_Evildan_AbekrampeV2
 Adam242411_PL
 Alex
 Bananixx
 Belenos
 Benschie
 BlackKnight
 Blade
 Bradapple
 Brennanx
 Burnnt
 DatShield
 Delion
 DerekVinyard
 Gimli_I
 Gneiss_Preasts
 Greekdragonkdl
 Guard_Kip
 Harlaus
 Hawkens
 Human_being
 Israfel
 Juiced
 JustMicky
 K4mi
 Khmer
 KnightSimpleton
 Kosh
 Latina_Heat
 Leech
 Legend
 MP3jkl
 Mr_Awesome
 Nici_inf
 NickyJ
 Niezdara_Guard
 Nka19
 Pollypo
 Ragnash
 Rogue
 RWCostanzo
 RX-10
 Saladin
 Sargent_X
 Sativa
 Seaward
 Shieldling
 Sinister_Soldier
 Srellian
 Tararil
 Tea
 Tiberias
 Tjaviboy
 Trojkatny
 Tyr
 Vovgre
 Yabu
 Peeper
Voted Friendliest NordInvasion Player
 Quote Board is on Discord (last updated 2025.09.06)
 "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?
 
	
	
	
		
	Posts: 383Threads: 79
 Joined: Apr 2013
 
	
	
		VLKA_Handef_Snizel - Royal Gaurd
	 
My Characters!
 VLKA_Handef_Snizel - Royal Gaurd
 VLKA_Handef - Master Peltast
 VLKA_HybridLeHandef - Sharpshooter
 VLKA_Snizel - Ranger
 
	
	
	
		
	Posts: 157Threads: 38
 Joined: Sep 2012
 
	
	
		 (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).
 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]
_Evildan_AbekrampeV2
 Adam242411_PL
 Alex
 Bananixx
 Belenos
 Benschie
 BlackKnight
 Blade
 Bradapple
 Brennanx
 Burnnt
 DatShield
 Delion
 DerekVinyard
 Gimli_I
 Gneiss_Preasts
 Greekdragonkdl
 Guard_Kip
 Harlaus
 Hawkens
 Human_being
 Israfel
 Juiced
 JustMicky
 K4mi
 Khmer
 KnightSimpleton
 Kosh
 Latina_Heat
 Leech
 Legend
 MP3jkl
 Mr_Awesome
 Nici_inf
 NickyJ
 Niezdara_Guard
 Nka19
 Pollypo
 Ragnash
 Rogue
 RWCostanzo
 RX-10
 Saladin
 Sargent_X
 Sativa
 Seaward
 Shieldling
 Sinister_Soldier
 Srellian
 Tararil
 Tea
 Tiberias
 Tjaviboy
 Trojkatny
 Tyr
 Vovgre
 Yabu
 Peeper
 [/spoiler]
_Evildan_AbekrampeV2
 Adam242411_PL
 Alex
 Bananixx
 Belenos
 Benschie
 BlackKnight
 Blade
 Bradapple
 Brennanx
 Burnnt
 DatShield
 Delion
 DerekVinyard
 Gimli_I
 Gneiss_Preasts
 Greekdragonkdl
 Guard_Kip
 Harlaus
 Hawkens
 Human_being
 Israfel
 Juiced
 JustMicky
 K4mi
 Khmer
 KnightSimpleton
 Kosh
 Latina_Heat
 Leech
 Legend
 MP3jkl
 Mr_Awesome
 Nici_inf
 NickyJ
 Niezdara_Guard
 Nka19
 Pollypo
 Ragnash
 Rogue
 RWCostanzo
 RX-10
 Saladin
 Sargent_X
 Sativa
 Seaward
 Shieldling
 Sinister_Soldier
 Srellian
 Tararil
 Tea
 Tiberias
 Tjaviboy
 Trojkatny
 Tyr
 Vovgre
 Yabu
 Peeper
 [/quote]
 
Kip was kind enough to do that for me, and ill fix my mistake, but thank you for the offer.
	 
	
	
	
		
	Posts: 157Threads: 38
 Joined: Sep 2012
 
	
	
		The list, and the stats should be fully up-dated as of now. if anyone see's any mistakes, let me know.
	 
	
	
	
		
	Posts: 2,079Threads: 285
 Joined: Jan 2012
 
	
	
		 (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.
	 
Voted Friendliest NordInvasion Player
 Quote Board is on Discord (last updated 2025.09.06)
 "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?
 
	
	
	
		
	Posts: 157Threads: 38
 Joined: Sep 2012
 
	
	
	
		
	Posts: 2Threads: 0
 Joined: Jan 2014
 
	
	
	
		
	Posts: 24Threads: 27
 Joined: Jun 2013
 
	
	
		VLKA_FrostRoyal Guard
 
-VLKA_Frost 52 Royal Guard-VLKA_Ice 41 Sniper
 -VLKA_BigBoy 44 Sharpshooter
 -Snow lvl 33 To be Pikeman
 Kills
 2x Thor
 1x Ragnar
 1x Prince
 Legandary Loot
 none
 
	
	
	
		
	Posts: 27Threads: 47
 Joined: Sep 2013
 
	
	
		ON_LegionZweihander
 
Characters:- Legion_I:       Zweihander   lvl 52
 - Legion_II:        Pikeman      lvl 50
 - Legion_III:         Sniper       lvl 43
 - Legion_IV:  Crossbow-man  lvl 26
 
	
	
	
		
	Posts: 2,079Threads: 285
 Joined: Jan 2012
 
	
	
		 (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.
	 
Voted Friendliest NordInvasion Player
 Quote Board is on Discord (last updated 2025.09.06)
 "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?
 |