Emails are disabled - for account issues, post in #help on the NI Discord.
NordInvasion Forum › Discussions › Community Discussion & Engagement v
The Great List of Swadian Heroes

Threaded Mode
The Great List of Swadian Heroes
Malong Offline
Posting Freak
Donator
Contributor
Posts: 1,907
Threads: 263
Joined: Jan 2012
#11
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:

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]
[+]Spoiler
[glow=black,1,150]Legionnaire[/glow]
[+]Spoiler
[/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.
Find
Reply
Handef_Snizel Offline
Senior Member
Donator
Posts: 383
Threads: 79
Joined: Apr 2013
#12
28-02-2014, 12:12 AM
VLKA_Handef_Snizel - Royal Gaurd
My Characters!

VLKA_Handef_Snizel - Royal Gaurd
VLKA_Handef - Master Peltast
VLKA_HybridLeHandef - Sharpshooter
VLKA_Snizel - Ranger
Find
Reply
Buttercup Offline
Member
Donator
Posts: 157
Threads: 38
Joined: Sep 2012
#13
28-02-2014, 12:15 AM
(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]
[+]Spoiler
[glow=black,1,150]Legionnaire[/glow]
[+]Spoiler
[/spoiler]
[/quote]

Kip was kind enough to do that for me, and ill fix my mistake, but thank you for the offer.
https://i.imgur.com/x0FDoO4.png?1
Find
Reply
Buttercup Offline
Member
Donator
Posts: 157
Threads: 38
Joined: Sep 2012
#14
28-02-2014, 12:22 AM
The list, and the stats should be fully up-dated as of now. if anyone see's any mistakes, let me know.
https://i.imgur.com/x0FDoO4.png?1
Find
Reply
Malong Offline
Posting Freak
Donator
Contributor
Posts: 1,907
Threads: 263
Joined: Jan 2012
#15
28-02-2014, 12:45 AM
(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.
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.
Find
Reply
Buttercup Offline
Member
Donator
Posts: 157
Threads: 38
Joined: Sep 2012
#16
28-02-2014, 01:20 AM
fixed.
https://i.imgur.com/x0FDoO4.png?1
Find
Reply
BOE Offline
Junior Member
**
Posts: 2
Threads: 0
Joined: Jan 2014
#17
28-02-2014, 01:12 PM
VLKA_BOE
Royal Gaurd
Find
Reply
BigBoy Offline
Junior Member
Donator
Posts: 24
Threads: 27
Joined: Jun 2013
#18
28-02-2014, 01:13 PM
VLKA_Frost
Royal 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
Find
Reply
_Legion_ Offline
Junior Member
Donator
Posts: 27
Threads: 47
Joined: Sep 2013
#19
28-02-2014, 01:17 PM
ON_Legion
Zweihander
Characters:
- Legion_I:       Zweihander   lvl 52
- Legion_II:        Pikeman      lvl 50
- Legion_III:         Sniper       lvl 43
- Legion_IV:  Crossbow-man  lvl 26
Find
Reply
Malong Offline
Posting Freak
Donator
Contributor
Posts: 1,907
Threads: 263
Joined: Jan 2012
#20
28-02-2014, 03:07 PM
(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.
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.
Find
Reply




Users browsing this thread: 1 Guest(s)