Forum Discussion

StoffelZink's avatar
5 years ago

I made a great tool that helps you get Galactic Legends faster!

Hi guys,
maybe some of you already saw this on reddit (either from me or the original version of Jones, who has retired from the game).

I took on the development of his gear tracking sheet for Galactic Legends. This sheet should help you to keep track of how close you are to unlocking the requirements for any Galactic Legend character.

Here's the link to the sheet:
https://docs.google.com/spreadsheets/d/1oxKsHZLvpY5XHB2YhBxnO-qh2UD5j1TsykxACrd78TQ/edit?usp=sharing
Please keep in mind, that this sheet itself cannot be edited, but you can create a copy of it for yourself, which you can then fill with your own data.

I'll give you a quick overview of all the features:

Table "Summary":
Here you have to input your ally code first. Then you need to click on the "Update" button. The sheet will then retrieve all your character information from swgoh.gg. Then you'll have an overview of your character and ship progress regarding gear/relic levels and stars for the ships.

Table "Inventory":
Here you need to select for which Galactic Legend you want to farm gear. You can also activate the option to include the gear needed for the Galactic Legend character itself, so you can farm this already, too.
When the right GL is selected, you see the amount of scrap material, signal data and gear pieces that's needed in total. Please note, that on the bottom there are further checkboxes, where you can tell the sheet, that the gear pieces needed to build Aurodium Heatsinks (Holo Projectors) and Electrum Conductors (Visors, Armor Plating, Cybernetics and Wrist Bands) are also included in the total amount of required gear. This will give you an even better overview of what you actually need.
You can now continue to input your inventory, so you see how much you're actually missing. The button "Sort by Location" will help you a lot for this task. When all the gear pieces are sorted by location, you can easily go through your Dark Side, Light Side and Fleet Nodes to look up the amount of gear that you already have.
Now you can click the button "Sort by Missing" to see which gear pieces you need the most of. These are usually the ones you wanna farm first. The button "Hide Finished Gear" makes the sheet only show the gear pieces that you still need, so you only see the data you actually need.

Tables "CharacterFarm":
The purpose of this sheet is to manage your crystals costs and character shard farming. On the top you can play around with the number of energy refreshes you wanna do to see how this affects your crystals.
Beyond that you can input the characters and ships you are currently farming (please be aware that these are divided by ship and normal energy nodes). There you can input the node cost, the number of daily battles on that node, the star goal you wanna achieve and the number of shards you already have on the current star level. The current star level is updated with the "Update" button in the "Summary" table. Please be aware of the fact, that the data comes from swgoh.gg, which only updates once per day usually, so when you do an upgrade on anything, it may take one day until this appears in the sheet.
In the bottom left you can input your daily crystal income from the two arenas (based on your average rank).
In the bottom right you need to input your current amount of crystals. Now you see, when you're gonna run out of crystals with your current spending rate. When you input a desired data where you wanna be finished, you also see how many crystals you'll have left on that day. These can be used for further spendings.

Table "SignalData":
Here you see when the farm for the signal data will be finished based on how many cantina energy refreshes you're buying each day. The column belonging to the selected number of refreshes you input in the table "CharacterFarm" is highlighted in blue. So this helps you decide how many cantina refreshes you'll need to buy to reach a certain deadline date.

Table "GearProgress":
After updating your inventory, you can click the button "Add Row". The number of gear you're missing is now automatially added to the table (both for including GL gear and only the required characters). After you did this a few times you can see how fast you're farming the gear. The automatically calculated polynomical (because in the end the gear grind usually slows down) trendline helps you approximate the date when your gear will be finished.

Table "VersionHistory":
Here you see which changes I made to the sheet. When I make a new version, the sheet automatically gives you a notification the next times you do an update with the "Update" button in the first table.