# Troops, Souls, Traitstones & Kingdoms Tracking Spreadsheet (Silverglade Update) **URL:** \ **Category:** Community Guides\ **Created:** [October 7, 2016, 4:11pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412 "2016-10-07T16:11:21Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [October 7, 2016, 4:11pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/1 "2016-10-07T16:11:21Z")
UPDATED 20th Jan 2017 (Silverglade) Hi Everyone, I was wondering how many more souls and traitstones I still needed to farm to level up all of my troops. So I made myself a spreadsheet that calculates it for you. It turns out its a lot šŸ™‚. I would love this as an in game feature, but as its not, this spreadsheet will have to do! The spreadsheet calculates and shows how many traitstones and souls you still need, kingdom levels, tributes, skill bonuses, etc. pretty much all you will ever need to know about your GoW game. Below are screenshots of the Summary and Kingdom Summary pages: (showing my progress as of 20th Jan 2017) ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/9/1/91da2de85fc68175847a38afdeb0918489cb3ada.png) ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/5/9/59b572634723f443230eeaa58bce9fe1dfa82721.png) Below are more screenshots of souls, traitstones and kingdom info tabs from the spreadsheet: ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/b/b36ff81f40626566ae82f8f154b42fb8ad8ca4f8.png) ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/6/6974583faca3c83ffc4172cb1c5b482a638a7ee0.png) ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/6/66861364be9a5fb3c722bcdc2d1840b06ec5bc54.png) Iā€™m posting the spreadsheet here on the forum, in case anyone else would like to use it to see how many more resources they still need to farm. The spreadsheet also has lots of other info about all the troops, so it can be used as a reference guide if you wish. If you would like to use the spreadsheet feel free, there is a link to download it below (hopefully it works, if it doesnā€™t let me know). There are instructions in the spreadsheet on how to use it, but its pretty simple, just fill in 5 fields for each troop: 1. Own troop: Y/N 2. Level: number 3. Trait 1 acquired: Y or blank 4. Trait 2 acquired: Y or blank 5. Trait 3 acquired: Y or blank The spreadsheet does the rest. Link: [Dropbox - GoW Spreadsheet Blank\_20012017.xlsx - Simplify your life](https://www.dropbox.com/s/p1eem6cwpv1skmo/GoW%20Spreadsheet%20Blank_20012017.xlsx?dl=0) Have fun using it and hopefully when you see the huge amount of resources you probably still need it wont be too disheartening šŸ˜. Thanks for reading Tanis Also a big thank you to @Lyya , her great website was an invaluable source of Gems of War information to help me making this, you should check it out if you havenā€™t already. > **[Gems of War Database](https://gowdb.com/)** > > The definitive resource for all troops and content in Gems of War. ---
**Author:** ![Isis\_Kitty](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/isis_kitty/32/9189_2.png) [@Isis\_Kitty](https://community.gemsofwar.com/u/Isis_Kitty)\ **Post date:** [October 7, 2016, 4:14pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/2 "2016-10-07T16:14:58Z")
This is beautiful. Well done! ---
**Author:** ![ogunther](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ogunther/32/1464_2.png) [@ogunther](https://community.gemsofwar.com/u/ogunther)\ **Post date:** [October 7, 2016, 4:21pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/3 "2016-10-07T16:21:30Z")
Iā€™ll definitely be giving this a try and sharing it with my guildmates; thxs @tanis! šŸ™‚ ---
**Author:** ![Dustin1280](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/dustin1280/32/7970_2.png) [@Dustin1280](https://community.gemsofwar.com/u/Dustin1280)\ **Post date:** [October 7, 2016, 5:14pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/4 "2016-10-07T17:14:16Z")
This is fancy, I have been to lazy to put something like this together. So you rock!! Will definitely be using this, thanks for being awesome! EDIT: I kinda love you ---
**Author:** ![Kurokazna](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kurokazna/32/11246_2.png) [@Kurokazna](https://community.gemsofwar.com/u/Kurokazna)\ **Post date:** [October 7, 2016, 5:21pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/5 "2016-10-07T17:21:24Z")
Bookmarked for quick reference and to share with newbies ---
**Author:** ![ogunther](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ogunther/32/1464_2.png) [@ogunther](https://community.gemsofwar.com/u/ogunther)\ **Post date:** [October 7, 2016, 6:44pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/6 "2016-10-07T18:44:38Z")
![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/c/c73a2544ca6afe57b49a70a76fd0034860be835c.png) So, yeah; I still need over a million soulsā€¦but Iā€™m 1/3 of the way there. Thatā€™s good right; right? šŸ˜­ ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [October 7, 2016, 6:49pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/7 "2016-10-07T18:49:54Z")
Quickly go farm 801 souls and then it will be less than a millionā€¦ maybe youā€™ll feel re-energized then šŸ˜‰ ---
**Author:** ![ogunther](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ogunther/32/1464_2.png) [@ogunther](https://community.gemsofwar.com/u/ogunther)\ **Post date:** [October 7, 2016, 6:54pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/8 "2016-10-07T18:54:30Z")
Haha! I think I actually have over 1,000 sitting there so I donā€™t even need to farm them! Easy peasy! šŸ˜‰ ---
**Author:** ![efh313](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/efh313/32/34349_2.png) [@efh313](https://community.gemsofwar.com/u/efh313)\ **Post date:** [October 7, 2016, 8:01pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/9 "2016-10-07T20:01:03Z")
This looks amazing! Thank you for putting this together. I will definitely be checking it out. šŸ˜‰ ---
**Author:** ![Kharybdys](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kharybdys/32/2023_2.png) [@Kharybdys](https://community.gemsofwar.com/u/Kharybdys)\ **Post date:** [October 7, 2016, 8:07pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/10 "2016-10-07T20:07:34Z")
I moved it over to Community guides for easier finding ---
**Author:** ![kzintiwife](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kzintiwife/32/2350_2.png) [@kzintiwife](https://community.gemsofwar.com/u/kzintiwife)\ **Post date:** [October 7, 2016, 8:10pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/11 "2016-10-07T20:10:31Z")
this will be handy with my how many lvls, traits do you need for the next starā€¦ [https://docs.google.com/spreadsheets/d/1-SfyaSLvYCBctDLmSCeoXi0lUn13jfqvGVAcJqOjPjY/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1-SfyaSLvYCBctDLmSCeoXi0lUn13jfqvGVAcJqOjPjY/edit?usp=sharing) ---
**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 8, 2016, 5:14am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/12 "2016-10-08T05:14:50Z")
This is awesome, thank you! šŸ˜ƒ Now if version 2 could also calculate Kingdom Levels, thatā€™d be even better. ---
**Author:** ![Amitiel](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/amitiel/32/24973_2.png) [@Amitiel](https://community.gemsofwar.com/u/Amitiel)\ **Post date:** [October 8, 2016, 11:39am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/13 "2016-10-08T11:39:51Z")
thank you so much!! LE: so much work to doā€¦ ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/7/7bf03ae102bfa588abe747e3522fe9f8ff507509.png) ---
**Author:** ![Edu-M](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/edu-m/32/35070_2.png) [@Edu-M](https://community.gemsofwar.com/u/Edu-M)\ **Post date:** [October 8, 2016, 12:49pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/14 "2016-10-08T12:49:28Z")
Nice work @tanis šŸ‘ ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [October 10, 2016, 2:49pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/15 "2016-10-10T14:49:12Z")
@actreal Iā€™ll try to add that in a couple of weeks, Iā€™m going to be crazy busy for a bit, but hopefully I will have time in a fortnight ---
**Author:** ![TheLizzah](https://avatars.discourse-cdn.com/v4/letter/t/f4b2a3/32.png) [@TheLizzah](https://community.gemsofwar.com/u/TheLizzah)\ **Post date:** [October 10, 2016, 4:03pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/16 "2016-10-10T16:03:05Z")
Here are my totals only LVL 414 but still trucking along!!! Nice sheet, took a bit to get all the info in there. ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/d/d53e370b52c59d828d582674fbdc575024de5f03.png) ---
**Author:** ![TheLizzah](https://avatars.discourse-cdn.com/v4/letter/t/f4b2a3/32.png) [@TheLizzah](https://community.gemsofwar.com/u/TheLizzah)\ **Post date:** [October 10, 2016, 4:05pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/17 "2016-10-10T16:05:02Z")
Is there a password to unlock this so that I can add some of my own calculations? ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [October 10, 2016, 4:11pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/18 "2016-10-10T16:11:28Z")
@TheLizzah Yes its ā€˜Gemsā€™ . It does say it on the instructions tab, the furthest right tab. You might not see the tab if your are on a smallish screen, just click the right arrow next to the spreadsheet tabs. Iā€™m working on a large screen and it shows all the tabs by default, someone else asked me the same question, so I think it something to do with screen size not showing all the spreadsheet. ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [October 10, 2016, 4:14pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/19 "2016-10-10T16:14:30Z")
@TheLizzah. also I donā€™t know why your total souls in GoW on your screenshot is wrong. It should be 1.5 million ish. Have you changed Y to N on column C? you shouldnā€™t have. ---
**Author:** ![TheLizzah](https://avatars.discourse-cdn.com/v4/letter/t/f4b2a3/32.png) [@TheLizzah](https://community.gemsofwar.com/u/TheLizzah)\ **Post date:** [October 10, 2016, 4:29pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/20 "2016-10-10T16:29:24Z")
Yes I changes a few of the troops as Iā€™m using this for the PS4 version as there are troops that have not been released yet. There are about 55 ones that we still donā€™t have. As I add them then that total will update. I added my total trait stones to the main progress page sot that I can see exactly how many more stones I still need on each one and how many extra I have of others. I play both the PS$ version and PC/Mobile. ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/5/5929fca736a0d8ea6d2f183ed30ed16ba2b4334c.png) [Next page](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412.md?page=2)