# My Collection on Gems of War Database - Auto Updates! **URL:** \ **Category:** Community Content\ **Created:** [January 23, 2017, 7:23am UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799 "2017-01-23T07:23:31Z")\ **Posts on this page:** 20\ **Page:** 9
**Author:** ![Whiskeyjack](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/whiskeyjack/32/65850_2.png) [@Whiskeyjack](https://community.gemsofwar.com/u/Whiskeyjack)\ **Post date:** [January 27, 2017, 12:35pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/162 "2017-01-27T12:35:36Z")
@Lyya, just wanted to add my thanks for this amazing resource. I hadn’t bothered using a resource manager before as I couldn’t face having to type all my data in. The fact that yours does is automatically is brilliant! ---
**Author:** ![Lun](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@Lun](https://community.gemsofwar.com/u/Lun)\ **Post date:** [January 27, 2017, 1:26pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/163 "2017-01-27T13:26:18Z")
I just noticed that My Collection shows that Maugrim Woods has 1825/2100, while the game itself shows only 1715/2100 in Kingdom Power Level. ---
**Author:** ![MakoSipper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/makosipper/32/1933_2.png) [@MakoSipper](https://community.gemsofwar.com/u/MakoSipper)\ **Post date:** [January 27, 2017, 1:35pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/164 "2017-01-27T13:35:37Z")
Curious, at least 10 of mine are correct. I didn’t check them all, though. ---
**Author:** ![Lun](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@Lun](https://community.gemsofwar.com/u/Lun)\ **Post date:** [January 27, 2017, 2:36pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/165 "2017-01-27T14:36:01Z")
All I’ve checked before have been right. I checked randomly a few others right now, and they are right too. Maugrim Woods is the only one I can see that is off (but havn’t checked all). ---
**Author:** ![MakoSipper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/makosipper/32/1933_2.png) [@MakoSipper](https://community.gemsofwar.com/u/MakoSipper)\ **Post date:** [January 27, 2017, 2:38pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/166 "2017-01-27T14:38:56Z")
Maugrim Woods is correct for me as well. Have you tried “hard-refreshing” (usually ctrl+F5) your collection page? Also, I assume you have your in-game account linked, right? ---
**Author:** ![Lun](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@Lun](https://community.gemsofwar.com/u/Lun)\ **Post date:** [January 27, 2017, 2:45pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/167 "2017-01-27T14:45:12Z")
Tried ctrl-F5 right now, same result. Also tried on two different computers. My Collection shows the same cards in Maugrim Woods as I have in game, so that is correct: 10 different troops (500) 5 of them with one trait (125) All of them on level 10, except one on level 19 (1090) Total: 1090+500+125 = 1715. But “Checklist” still lists it as 1825. Edit: And yes, I have linked it to my account. ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 27, 2017, 2:56pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/168 "2017-01-27T14:56:38Z")
I’ll take a look. Thanks for the report. ---
**Author:** ![HKdirewolf](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/hkdirewolf/32/21614_2.png) [@HKdirewolf](https://community.gemsofwar.com/u/HKdirewolf)\ **Post date:** [January 27, 2017, 2:59pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/169 "2017-01-27T14:59:42Z")
Spoken like a true Developer! Next you’ll be saying SOON to everyone. 😂 ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 27, 2017, 3:18pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/170 "2017-01-27T15:18:28Z")
Okay, should be fixed. Please refresh to verify. (Eventually I’ll stop regressing the level/count bug, I promise.) ---
**Author:** ![Lun](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@Lun](https://community.gemsofwar.com/u/Lun)\ **Post date:** [January 27, 2017, 3:21pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/171 "2017-01-27T15:21:31Z")
Thanks a lot! It works like the dream it always did, now also with correct Maugrim Woods number 🙂 ---
**Author:** ![EnsignGarak](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ensigngarak/32/17147_2.png) [@EnsignGarak](https://community.gemsofwar.com/u/EnsignGarak)\ **Post date:** [January 27, 2017, 3:32pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/172 "2017-01-27T15:32:48Z")
So jealous. Wish this was available for console… ---
**Author:** ![polyester](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/polyester/32/59766_2.png) [@polyester](https://community.gemsofwar.com/u/polyester)\ **Post date:** [January 27, 2017, 5:30pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/173 "2017-01-27T17:30:37Z")
Holy crap, this is awesome. You rule. I’ve been tracking stuff in Excel to keep organized, but this is so much better. 🙂 The one suggestion I have is something to calculate which troops are the cheapest to trait up - so if you’re looking to five-star a kingdom, you can quickly see Troop X will take 60% of my supply of his stones, while Troop Y only takes 10%. I do this in my file and it’s probably the one thing I use the most. Actually I set it to tell me what’s the max percentage among all the needed stones, so like if troop X’s next trait will use 2% of my purple minors, 8% of my blue majors and 60% of my blue Runics it’ll take the highest number. Just a thought. If you ever decide to do anything like that, or other analysis-type stuff, let me know. I’d be more than willing to help out. 🙂 ---
**Author:** ![HKdirewolf](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/hkdirewolf/32/21614_2.png) [@HKdirewolf](https://community.gemsofwar.com/u/HKdirewolf)\ **Post date:** [January 27, 2017, 5:37pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/174 "2017-01-27T17:37:48Z")
Got my collection down to only needing 700k souls. This time next year i’ll almost be done!🎉 ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/7/b/7b6893ec9a7d83ee816d47a14fd6b6404beb5154.gif) ---
**Author:** ![Verdugo](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/verdugo/32/9407_2.png) [@Verdugo](https://community.gemsofwar.com/u/Verdugo)\ **Post date:** [January 27, 2017, 5:45pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/175 "2017-01-27T17:45:02Z")
![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/a/1/a10c025373eaf468d6e40b95da9dea444fff18c2.JPG) ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [January 27, 2017, 5:53pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/176 "2017-01-27T17:53:31Z")
It might be helpful if you show me a screenshot of the desired data you are looking for. I’m having a hard time visualizing your request. ---
**Author:** ![XLS78](https://avatars.discourse-cdn.com/v4/letter/x/b2d939/32.png) [@XLS78](https://community.gemsofwar.com/u/XLS78)\ **Post date:** [January 27, 2017, 8:01pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/177 "2017-01-27T20:01:23Z")
I think the idea would be to have a calculator for how to get a kingdom most efficiently to the next star level. This might be a little complex, but here’s the idea: Assume troops are constant. Option 1: Ask for number of traits that the player is willing to add as the independent variable. Dependent variable outputs are the total number of souls needed, and how many levels should go to which troops in order to get to the next kingdom level as efficiently (in soul costs) as possible. Option 2 (more complex?): Ask for number of levels or souls the player will add as independent variable. Dependent variable outputs are whether or not the player can get to the next kingdom level with the traitstones owned, and which ones are needed for which troops to do so. Prioritization given to more common traitstones usage, minors \> majors \> runics \> arcanes. Hope this makes sense - it’s asking a lot, I know, but it would be another amazingly helpful addition. Many thanks for the great tools! ---
**Author:** ![AeroCloud](https://avatars.discourse-cdn.com/v4/letter/a/d26b3c/32.png) [@AeroCloud](https://community.gemsofwar.com/u/AeroCloud)\ **Post date:** [January 27, 2017, 8:04pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/178 "2017-01-27T20:04:40Z")
I still need 850k souls… and too many traitstones… I do like this tool, it is very useful ---
**Author:** ![Annaerith](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/annaerith/32/13840_2.png) [@Annaerith](https://community.gemsofwar.com/u/Annaerith)\ **Post date:** [January 27, 2017, 8:07pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/179 "2017-01-27T20:07:52Z")
in 5 days i went from 800k to 730k souls left thanks to this tool i can see the progress, its amazing 😃 ---
**Author:** ![MakoSipper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/makosipper/32/1933_2.png) [@MakoSipper](https://community.gemsofwar.com/u/MakoSipper)\ **Post date:** [January 27, 2017, 8:12pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/180 "2017-01-27T20:12:52Z")
There are too many variables involved, and they all have different weighs for different players, so I find it really hard to calculate. While it’s easy to compare 3 Runic Yellow with 5 Runic Yellow, how do you compare 3 Runic Yellow with 40 Red Minor, and these with 1 Arcane Forest? How do you compare all that with souls? That said, the closest tool that I’ve seen to what I think you want is ToDo Monitor > [@GoW: ToDo Monitor](http://community.gemsofwar.com/t/gow-todo-monitor/5087): > > Hi all, I create an application to have an overview of my progress. Most of us should have a spreasheet to do that but this solution is quite limited and can be slow if you put some crazy formula. This application is for PC only, I cannot do any version for iOS or Android. It is based on your progress so you will need to enter all your data the first time only (you can save wink ). So what you can do with it (for one kingdom or all kingdoms): know the souls required to level up all your … You might wanna give it a try. ---
**Author:** ![XLS78](https://avatars.discourse-cdn.com/v4/letter/x/b2d939/32.png) [@XLS78](https://community.gemsofwar.com/u/XLS78)\ **Post date:** [January 27, 2017, 8:57pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/181 "2017-01-27T20:57:03Z")
I wasn’t suggesting it was trivial, but it’s not impossible either. The souls vs stones question is why there need to be two options - either you say how many traits you will complete and it calculates souls needed, or vice versa. The optimization piece needs to make some simplifying assumptions, most likely. For instance, out of the possible ways to complete traits given stones owned, it could prioritize traits that used only minors and majors, then those that use the fewest runics, then those that use the fewest arcanes. Logic like that could get you useful output, though I don’t want to trivialize the programming required to get there. [Previous page](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799.md?page=8) [Next page](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799.md?page=10)