# 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:** 2
**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:56pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/21 "2016-10-10T16:56:10Z")
Oh I forgot that PS4 doesn’t have all the troops yet. ---
**Author:** ![Phaethon](https://avatars.discourse-cdn.com/v4/letter/p/49beb7/32.png) [@Phaethon](https://community.gemsofwar.com/u/Phaethon)\ **Post date:** [October 13, 2016, 1:28pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/22 "2016-10-13T13:28:57Z")
![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/2/7/27152c3c6821c8a029e1f9a5bf1e7f0f79e34675.gif) ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [October 27, 2016, 1:46pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/24 "2016-10-27T13:46:40Z")
Version 2 is out. It adds Kingdom Levels & Info. ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [October 27, 2016, 1:50pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/25 "2016-10-27T13:50:01Z")
Also fixed a couple of small bugs from the first version. Also you should be able to just copy & paste your troop data from the first spreadsheet for the most part (just remember there are the new troops), it should save a lot of time not re-entering all that info again. ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [November 11, 2016, 11:34am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/26 "2016-11-11T11:34:02Z")
Spreadsheet has been updated to include Blackhawk kingdom. Also fixed another small bug. Please download and use the newest version. If you have used the spreadsheet before, then copy & paste your entered troop data across to the new spreadsheet. ---
**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:** [November 11, 2016, 1:00pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/27 "2016-11-11T13:00:30Z")
Thank you! You’re awesome! ---
**Author:** ![n8wachT](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/n8wacht/32/11171_2.png) [@n8wachT](https://community.gemsofwar.com/u/n8wachT)\ **Post date:** [November 26, 2016, 9:53am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/28 "2016-11-26T09:53:16Z")
Really impressive. Takes some time to get there but once you are there… well the whole game has been taken a lot of time right? Forget everything I just said after really impressive. You did an wonderfull job \<3 ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [November 26, 2016, 11:37am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/29 "2016-11-26T11:37:03Z")
Thanks a lot. I’m glad you like it and I hope you find it useful. ---
**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:** [December 7, 2016, 1:03pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/30 "2016-12-07T13:03:49Z")
As a thanks to @tanis’s job, i will try to keep it updated as much as i can. LE: I updated this with Night Hag and Giant Stool. Let them in the last 2 rows so it will be easier for you to copy/paste them in your already made spreadsheet. PS: i know some columns are too small, but this is up to @tanis to change them. I tried to do that myself but it don’t seem to work. > **[GoW Spreadsheet Blank\_11112016 (updatat-blank).xlsx](https://www.dropbox.com/s/6pmgarue7oydfps/GoW%20Spreadsheet%20Blank_11112016%20%28updatat-blank%29.xlsx?dl=0)** > > Shared with Dropbox ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [December 14, 2016, 1:28am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/31 "2016-12-14T01:28:36Z")
Amitiel, Thanks for taking an interest in helping with the spreadsheet, it’s appreciated. I’ve been on holiday and just got back, so sorry for the tardy response. I do plan to keep the spreadsheet up to date and will post semi-regular updates for it. The next one will be when the next new kingdom drops or if 2.2 brings any major changes to the game. If anyone has any requests on changes or additional features for the spreadsheet, post them here and i’ll see if its possible to add to them. Thanks ---
**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:** [December 14, 2016, 11:56am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/32 "2016-12-14T11:56:38Z")
Hello Tanis 🙂 As a request for changing something in it, i will give you the feedback i got when i uploaded this. I can’t change them, with or without the password, so i hope you can. “Hi. I tested Yout GoW-Spreadsheet. It’s amazing! But in Sheet “Kingdom Summary” column “O” is to small. If I have more than 9 troops there appear a “#” instead of the amount. Maybe you can correct this. Thanks.” It’s about columns O, Q, AP and AH LE: All being said, i can keep it to date with 2/3 troops coming per week and let you manage the major changes on troops and new kingdoms. Is that ok? ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [December 14, 2016, 12:04pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/33 "2016-12-14T12:04:21Z")
I’m not sure why you wouldn’t be able to just change the column width, most strange. I can look at it. It is fine on my spreadsheet, but i do use a large screen. Sometime excel resets zooms and fonts and things like that to default when opening on other computers, that might explain it. I know from screenshots others have posted that the text fonts I used don’t carry across well. ---
**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:** [December 14, 2016, 12:09pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/34 "2016-12-14T12:09:47Z")
I use it at 40%, but even at 100% it looks like this: ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/f/f01e6d0786cc475da07fc9f624c030644f26927c.jpg) PS: I’m using a 17" laptop ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [December 14, 2016, 12:13pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/35 "2016-12-14T12:13:39Z")
I’ll just make the column wider for the next version and then hopefully it will work for everyone. Your fonts are wrong as well, I spent ages choosing nice fonts 😭 Compare it to my screenshot in the 1st post. ---
**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:** [December 14, 2016, 12:32pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/36 "2016-12-14T12:32:36Z")
Meh, it’s not about fonts here, it’s about functionality. And plus, i may not have that fond you used so this might be a reason why it shows me like this. ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [January 20, 2017, 9:43am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/37 "2017-01-20T09:43:37Z")
I have updated the spreadsheet for the new kingdom, Silverglade. There is a link to the new spreadsheet in the 1st post of this topic. ---
**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:** [January 20, 2017, 10:23am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/38 "2017-01-20T10:23:07Z")
Umm, you put your own spreadsheet there. Not the blank one XD ---
**Author:** ![tanis](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tanis](https://community.gemsofwar.com/u/tanis)\ **Post date:** [January 20, 2017, 10:51am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/39 "2017-01-20T10:51:54Z")
Thanks for that. I’ve changed it it for the blank one. ---
**Author:** ![Rvdecw19](https://avatars.discourse-cdn.com/v4/letter/r/e19adc/32.png) [@Rvdecw19](https://community.gemsofwar.com/u/Rvdecw19)\ **Post date:** [April 19, 2017, 12:42pm UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/40 "2017-04-19T12:42:59Z")
@tanis can I make a suggestion? when you go to update the spreadsheet with the new kingdom and troops, can you add a spot where we can enter in the amount of souls and traitstones that we have but haven’t used on a troop yet? for example, that way when it says I still need 20 arcane forest, it factors in that I currently have 10 in my “collection”. thanks! ---
**Author:** ![Rvdecw19](https://avatars.discourse-cdn.com/v4/letter/r/e19adc/32.png) [@Rvdecw19](https://community.gemsofwar.com/u/Rvdecw19)\ **Post date:** [August 21, 2017, 12:37am UTC](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412/41 "2017-08-21T00:37:57Z")
@tanis are you still here? Tigerclaw misses you! If you are still here, do you still do the spreadsheet? [Previous page](https://community.gemsofwar.com/t/troops-souls-traitstones-kingdoms-tracking-spreadsheet-silverglade-update/13412.md?page=1)