# Spreadsheet With all Troops (updated 2015.10.16) **URL:** \ **Category:** Community Guides\ **Created:** [August 24, 2015, 11:01pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245 "2015-08-24T23:01:43Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![DJ\_MAD](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/dj_mad/32/92_2.png) [@DJ\_MAD](https://community.gemsofwar.com/u/DJ_MAD)\ **Post date:** [August 24, 2015, 11:01pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/1 "2015-08-24T23:01:43Z")
As a tool to select your best team I created a spreadsheet with all troops. Link [to Full Troop Spreadsheet](https://goo.gl/3BTO2x) Currently you can filter on the following fields: Class / From: Create a custom filter to select e.g. a kingdom or all legendary troops Name: Name of The Troop Level: Skill level of troop Life: # of life for each level Attack: # of Attack for each level Armor: # of Armor for each level Magic: # of Magic for each level HP: # of Hitpoints for each level (Life+Armor=Hitpoints) Cost: # How much it cost to release the Troop Skill (if you like fast teams filter only 6 - 9) HP/COST: Will give you a ratio of how much it cost vs #HP (The higher the better) Colors: Color filters to select e.g. only the troops who need red There are some filters already added like Class, Kingdom and Skills (extra turn). Not all filters might work properly as I have not checked all of them but you can simply create your own custom filter by clicking on the filter icon on the top left corner. The best way to start is to select only Level 15 and filter out the rest of the values. Have fun and feel free to ask questions in case you are stuck. Spreadsheet updated 2015.10.16 ---
**Author:** ![Gems-of-War](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/gems-of-war/32/2281_2.png) [@Gems-of-War](https://community.gemsofwar.com/u/Gems-of-War)\ **Post date:** [August 25, 2015, 4:40am UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/2 "2015-08-25T04:40:50Z")
Awesome to see this one come across, thanks @DJ_MAD! 15 Gems coming to you now! ---
**Author:** ![madpharaoh](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/madpharaoh/32/151_2.png) [@madpharaoh](https://community.gemsofwar.com/u/madpharaoh)\ **Post date:** [August 25, 2015, 1:52pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/3 "2015-08-25T13:52:36Z")
Thanks for this great resource! I put a filter for Level 15, then sorted descending by: Attack, Magic, Armor, Life. Now I know where I want to spend my souls. 😃 ---
**Author:** ![DJ\_MAD](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/dj_mad/32/92_2.png) [@DJ\_MAD](https://community.gemsofwar.com/u/DJ_MAD)\ **Post date:** [October 16, 2015, 10:33am UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/4 "2015-10-16T10:33:50Z")
The spreadsheet has been updated and it now contains also all troops from the new kingdom Wild Plains ---
**Author:** ![actreal](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/actreal/32/1945_2.png) [@actreal](https://community.gemsofwar.com/u/actreal)\ **Post date:** [October 28, 2015, 12:49am UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/5 "2015-10-28T00:49:18Z")
This is a great resource, but it would be even better if the Class and Location fields were separated so that you could apply filters more easily. ---
**Author:** ![killerman3333](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/killerman3333/32/4068_2.png) [@killerman3333](https://community.gemsofwar.com/u/killerman3333)\ **Post date:** [November 12, 2015, 11:55pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/6 "2015-11-12T23:55:51Z")
Can you update the list to include notes of units that can be earned from completing areas. I am building a team but my map isn’t fully open yet so finding out where i can get some troops outside of keys will save me time and in-game money. Although i have to admit that your guide is very informational and for that i thank you. ---
**Author:** ![Zelfore](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/zelfore/32/22295_2.png) [@Zelfore](https://community.gemsofwar.com/u/Zelfore)\ **Post date:** [November 13, 2015, 1:38am UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/7 "2015-11-13T01:38:02Z")
[Kingdom Domination](http://community.gemsofwar.com/t/kingdom-domination/406) compiled by [Archnessa](http://community.gemsofwar.com/users/archenassa) Some of the info in the original post is outdated (\*\* cough\* \* Sparkgrinder’s/Sunweaver’s spells \*\* cough\* \*) or has changed now (Mana Bonus = Banner, Stat Bonus = Lv10 Kingdom, etc.), granted, but it will still tell you what Epic Troops you’ll get from which kingdoms. ---
**Author:** ![Archenassa](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/archenassa/32/153_2.png) [@Archenassa](https://community.gemsofwar.com/u/Archenassa)\ **Post date:** [November 13, 2015, 6:19am UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/8 "2015-11-13T06:19:30Z")
The problem is that the thread is too old to be edited. I made some addendums after the 1.0.7 update, but haven’t noted the more minimal changes like the card rebalances. I will probably need to redo all of the guides to have them updated on one page rather than just add new posts. But I’ll wait for the next update since it’s pretty certain the devs have a lot of new surprises in store. 😄 ---
**Author:** ![Jainus](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/jainus/32/34949_2.png) [@Jainus](https://community.gemsofwar.com/u/Jainus)\ **Post date:** [November 13, 2015, 1:15pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/9 "2015-11-13T13:15:54Z")
Random question - hey @Zelfore how come you have ‘Knight of Krystara’ showing after your name? is that an option or field in the profile somewhere? @CrowdedWorlds how do I set that? ---
**Author:** ![Zelfore](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/zelfore/32/22295_2.png) [@Zelfore](https://community.gemsofwar.com/u/Zelfore)\ **Post date:** [November 13, 2015, 1:32pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/10 "2015-11-13T13:32:27Z")
Little off topic, but I’ll answer quickly. It’s a random perk Nimhain (and possibly some other staff) decided to allow the Regular members to make up our own titles. Check out Mel, Marcel and Serale for other unique titles. Archenassa hasn’t appeared to place an order yet. ---
**Author:** ![MarvelKit](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/marvelkit/32/7072_2.png) [@MarvelKit](https://community.gemsofwar.com/u/MarvelKit)\ **Post date:** [November 13, 2015, 1:41pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/11 "2015-11-13T13:41:48Z")
Just some random characters to show off my title. 😜 ---
**Author:** ![Machiknight](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/machiknight/32/6108_2.png) [@Machiknight](https://community.gemsofwar.com/u/Machiknight)\ **Post date:** [November 13, 2015, 2:12pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/12 "2015-11-13T14:12:07Z")
Iiiiiiinteresting…what are the exact requirements for such a thing? ---
**Author:** ![Zelfore](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/zelfore/32/22295_2.png) [@Zelfore](https://community.gemsofwar.com/u/Zelfore)\ **Post date:** [November 13, 2015, 2:36pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/13 "2015-11-13T14:36:04Z")
Go to the [Badges](http://community.gemsofwar.com/badges) page, click the ‘[Granted](https://meta.discourse.org/t/what-do-user-trust-levels-do/4924/6)’ link under the Trust Level section. Regular members receive numerous perks, most notably the ability to rename and relocate topics. If anyone has any further questions, feel free to message me directly. ---
**Author:** ![Archenassa](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/archenassa/32/153_2.png) [@Archenassa](https://community.gemsofwar.com/u/Archenassa)\ **Post date:** [November 13, 2015, 4:12pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/14 "2015-11-13T16:12:06Z")
I hadn’t even noticed but I’ve placed an order now. 😛 But don’t tell them about being regulars or they might prepare for the next Fight Club competition. Shh! Edit: got mine too now! ^^ ---
**Author:** ![Machiknight](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/machiknight/32/6108_2.png) [@Machiknight](https://community.gemsofwar.com/u/Machiknight)\ **Post date:** [November 14, 2015, 3:09pm UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/15 "2015-11-14T15:09:54Z")
> [@Zelfore](#): > > Go to the [Badges](http://community.gemsofwar.com/badges) page, click the ‘[Granted](https://meta.discourse.org/t/what-do-user-trust-levels-do/4924/6)’ link under the Trust Level section. > > Regular members receive numerous perks, most notably the ability to rename and relocate topics. > > If anyone has any further questions, feel free to message me directly. Im a big fan of how these new forums work! ---
**Author:** ![cihuacotl](https://avatars.discourse-cdn.com/v4/letter/c/ed655f/32.png) [@cihuacotl](https://community.gemsofwar.com/u/cihuacotl)\ **Post date:** [November 16, 2015, 5:05am UTC](https://community.gemsofwar.com/t/spreadsheet-with-all-troops-updated-2015-10-16/245/16 "2015-11-16T05:05:45Z")
> [@DJ\_MAD](#): > > HP/COST: Will give you a ratio of how much it cost vs #HP (The higher the better) must say first, thank you for this! really appreciate the time youve spent on this probably being completely thick here, how does this work? might be sleep deprivation from looking after a poorly baby but i cant get my head around this? if someone could explain i would be most grateful 😄