# StarSheets: Kingdom Stars Decision-Maker **URL:** \ **Category:** Gameplay Chat (PC/Mobile)\ **Created:** [May 8, 2016, 10:27am UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495 "2016-05-08T10:27:49Z")\ **Posts on this page:** 14\ **Page:** 1
**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:** [May 8, 2016, 10:27am UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/1 "2016-05-08T10:27:49Z")
Roll the drums. Due to popular demand and lots of hair-pulling sessions late at night. Here’s the Beta of StarSheets. No need to drill down to what you want. No need to decipher hieroglyphs. Information is presented in an attractive, familiar, user-friendly way. What is under the bonnet is trustworthy and can be checked by the user It is not a Mazarati with a Trabant engine under the bonnet. There is flexibility - everyone can use it, change it, improve it. It’s yours. The Alpha version will: AutoUpdate from GoW JSONs using Python. AutoUpdate user data from older StarSheets. If you are under level 600 this is the resource for you! GoWStarSheets can be downloaded from: > **[GitHub - Aristarchos/GemsOfWar: StarSheets](https://github.com/Aristarchos/GemsOfWar)** > > StarSheets. Contribute to Aristarchos/GemsOfWar development by creating an account on GitHub. Just click on the Download Zip button Unfortunately, I do not use MS Office. Fortunately LibreOffice is free to download and free to use. You can download LibreOffice 5.1 from here: > **[Download LibreOffice | LibreOffice - Free Office Suite - Based on OpenOffice...](https://www.libreoffice.org/download/download-libreoffice/)** > > Download free office suite for Windows, macOS and Linux. Microsoft compatible, based on OpenOffice, and updated regularly. When you open StarSheets click on the Help Tab and follow the instructions. Enjoy. IMHO, I think it is better if the screenshots have a home in another thread and we can keep discussion here: > [@StarSheets: Screen Shots](http://community.gemsofwar.com/t/starsheets-screen-shots/6496): > > Probably better for me to put the screenshots here and keep the chat in the other (Main) thread. The main thread is here: Click on the Star button and you get this: Ctrl-Click on the Kingdom Name and you get this: The rest of the screenshots show some of the extras I have included. I do use these for other things. More about that at a later date if this run is successful. There is much more in StarSheets! 🙂 ---
**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\ **Post date:** [May 8, 2016, 12:38pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/2 "2016-05-08T12:38:18Z")
Thanks for sharing this resource. 🙂 It’s pretty easy to setup and use as well. I really needed something like this because I hate tearing my hair out of kingdom decisions. ---
**Author:** ![MrSnake](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/mrsnake/32/4196_2.png) [@MrSnake](https://community.gemsofwar.com/u/MrSnake)\ **Post date:** [May 8, 2016, 12:56pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/3 "2016-05-08T12:56:43Z")
> Unfortunately, or fortunately 'cos it’s free, you need to also download LibreOffice 5.1 from here: > [Download LibreOffice | LibreOffice - Free Office Suite - Based on OpenOffice - Compatible with Microsoft](https://www.libreoffice.org/download/libreoffice-fresh/2) > It’s Free to download and free to use. @Bludax so - with normal microsoft office it doesnt work? ---
**Author:** ![Ozball](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ozball/32/36110_2.png) [@Ozball](https://community.gemsofwar.com/u/Ozball)\ **Post date:** [May 8, 2016, 12:59pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/4 "2016-05-08T12:59:02Z")
If you’re using Excel 2010 you can get it to repair the sheet and it will seem to work. But I can’t confirm that everything works properly. I didn’t have time to fill it in. ---
**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:** [May 8, 2016, 2:22pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/5 "2016-05-08T14:22:59Z")
I’m sure some of it will work with MS Excel, but for sure not all of it will work. There are some formulas that are not in Excel and while some formulas will look the same their behavior may be slightly different. I cannot afford to pay for MS Excel nor am I willing to use a pirate copy here in the Philippines and end up having my OS nerfed by MS. Feel free to transfer what you can to MS Excel. There is no need due to the easy availability of LibreOffice. It runs on other operating systems so that is a plus. Oh, if you want to play around with StarSheets you need to be aware that there are some hidden columns and one hidden sheet. The code is yours. The formulas are yours. Enjoy 🙂 ---
**Author:** ![orbin111](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/orbin111/32/509_2.png) [@orbin111](https://community.gemsofwar.com/u/orbin111)\ **Post date:** [May 8, 2016, 6:40pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/6 "2016-05-08T18:40:27Z")
Hi @Bludax, I won’t probably use it because I am using ToDo Monitor but I wanted to check your work. I pleased to say, nicely done. Can you please check the calculation of kingdom power for Pridelands? I have found that it doesn’t calculate Chimera’s traits correctly. I have correcly dilled 1.st trait for chimera in main tab but summary shows 0. ---
**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:** [May 8, 2016, 11:43pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/7 "2016-05-08T23:43:01Z")
Hi @orbin111 and @Ashasekayi, Thanks for the thumbs-up and feedback 😳 Tested the Chimera problem and it showed that a hidden column had a missing formula that was reproduced across the Kingdoms. Now fixed. StartSheets03b is now in the repository available for download. Just copy your old input and paste it into the new spreadsheet. ---
**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:** [May 10, 2016, 1:19am UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/8 "2016-05-10T01:19:23Z")
GowStarSheets04b has been uploaded with details of the new troop: Sacrificial Priest. 🙂 Also added column linking troop names to the Wiki Troop Detail Also Added other resources, for example those below; ToDo Standalone program by turintuor > [@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 … Troop Listing and Filtering Resource – Can be used for Team-Building by Lyya > [@Gems of War Database - updated troops list and much more!](http://community.gemsofwar.com/t/updated-troops-list/6037): > > Hi everyone, I’ve created a webpage that can be used to browse and search for all the troops, classes, weapons, kingdoms in Gems of War, along with many other features. It is called the “Gems of War Database” and can be found here: ~~[http://ashtender.com/gems~~](http://ashtender.com/gems~~) Troop List The troop list can be found here:~~[http://ashtender.com/gems/troops~~](http://ashtender.com/gems/troops~~) In addition to what the official Troop List supports, the replacement list has: Up-to-date stats information for all stats to level 20 Ascension … GoW Team-Builder Beta by Mr Snake > [@GoW-Tool by MrSnake](http://community.gemsofwar.com/t/mrsnakes-teambuilder-beta-phase/6560): > > I am proud to present you my GoW-Tool v2.0 The Application is coded in JavaFX, so all you need is Java installed - its no \*.exe File, its an executable \*.jar File. Features: Complete List of all available Troops (inclusive Glacial Peaks and Apocalypse) Create and Add Heros to the Team Filter Option for Kingdom, Type, Mana-Color and Rarity Mana Preview for selected Team Banner Selection Save and Load created Team Setups Preview of all Bonuses your Team can get (Kingdoms, Types, Mana) Progre… Thanks 🙂 ---
**Author:** ![MrSnake](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/mrsnake/32/4196_2.png) [@MrSnake](https://community.gemsofwar.com/u/MrSnake)\ **Post date:** [May 10, 2016, 6:55am UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/9 "2016-05-10T06:55:48Z")
> [@Bludax](#): > > Also Added other resources, for example those below; THX man - i appreciate it 😉 ---
**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:** [May 10, 2016, 9:33am UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/10 "2016-05-10T09:33:57Z")
You are welcome @MrSnake It can get lonely in the engine room. I hope you succeed. I will have some ideas for you later. But first, I am forced to make a defense of Spreadsheets! Saw this quote by accident while linking the resource to my thread. ‘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.’ In defence of all spreadsheet soldiers, I feel I just have to respond - in a nice way. Let’s look at some advantages of spreadsheets: Rapid development - I can confirm that. Excellent visual representation of data. No need to drill down to get to the data you need. No need to master new software. Spreadsheets are familiar. Most school-children can operate a spreadsheet. Many Managers make decisions based on data in Spreadsheets. Spreadsheets are great for modelling 'what if’s and simulations. Now, I will admit there is a limitation here. I am a hobbyist not a professional programmer. There are limits to the amount of time I can spend on development. Also, I am pretty low on the learning curve. Nevertheless, StarSheets works and gives an excellent visual representation of the data we need to analyse, no matter what is under the bonnet. I am aware that code for the buttons can be improved using Select…Case Statements. I am also aware, and mention in the spreadsheet, that a particularly long nested formula will be shortened using a VLookup table. There is no ‘apparent’ loss of speed. So, I am really curious as to why @turintuor felt the need to state ‘Spreadsheets… this solution is quite limited’. What solution? What limitation? Seriously curious 🙂 ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [May 10, 2016, 2:02pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/11 "2016-05-10T14:02:24Z")
In fact, I thought that the calculation could be longer using a spreadsheet when I said that 😛 . I created a C++/Qt application because I’m used to it and it’s the same for you: you propose a spreadsheet because you have some knowledge about that. Players now have two very different solutions to optimize their kingdom power level. They will use the one that fit the most their preference ;-). I think you fill this spreasheet manually and it should have take a lot of time. So, thank you for this work 🙂 . EDIT: apparently, I was too rude 😉 . ---
**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:** [May 16, 2016, 3:25pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/12 "2016-05-16T15:25:00Z")
Updated StarSheets is now available in the GitHub Repository: 🙂 > **[GitHub - Aristarchos/GemsOfWar: StarSheets](https://github.com/Aristarchos/GemsOfWar)** > > StarSheets. Contribute to Aristarchos/GemsOfWar development by creating an account on GitHub. Added New Troops: Marilith and Naga Queen Tested and confirmed the changes all work Made improvements to Links Sheet (More organised and visual) Added new links especially Lyya’s excellent Troop / Classes / Weapons Resource Added User Notes area for each Kingdom Added \<\<\< Return to Table to each kingdom to make it clear that there is no need to scroll back to the table, Just Ctrl-Click Gold Stars. ---
**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:** [May 16, 2016, 5:57pm UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/13 "2016-05-16T17:57:57Z")
No need to drill down to what you want. No need to decipher hieroglyphs. Information is presented in an attractive, familiar, user-friendly way. What is under the bonnet is trustworthy and can be checked by the user It is not a Mazarati with a Trabant engine under the bonnet. There is flexibility - everyone can use it, change it, improve it. It’s yours. The Alpha version will: AutoUpdate from GoW JSONs using Python. AutoUpdate user data from older StarSheets. If you are under level 600 this is the resource for you! ---
**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:** [May 24, 2016, 12:30am UTC](https://community.gemsofwar.com/t/starsheets-kingdom-stars-decision-maker/6495/14 "2016-05-24T00:30:58Z")
StarSheets 6b is out with the latest updated troop - Nobend Brothers - get it from here. > **[GitHub - Aristarchos/GemsOfWar: StarSheets](https://github.com/Aristarchos/GemsOfWar)** > > StarSheets. Contribute to Aristarchos/GemsOfWar development by creating an account on GitHub. Enjoy 🙂