SWGoH Squad Builder Version: 1.02182019.0

Blackened
10 posts Member
edited January 9
snapshot.png

The SWGoH Squad Builder spreadsheet is a multi-use tool for the mobile game "Star Wars : Galaxy of Heroes".

What does it do?
In short, it recommends hero squads for various modes of the game.

Features
Download Player Data
Download yours, your opponent's or your entire guild's player data!

Compare your squad's stats side-by-side with an opponent or guildmate.

Player data is retrieved using both SWGoH.gg and SWGoH.help APIs thanks to PopGoesThaWza's Core Sheet!

Filter Heroes
There are several useful ways to filter your downloaded rosters which comes in handy during Territory Wars especially.

Filter by galactic Power - The standard, and TW minimum, is 6,000 GP. But what if your guild has higher standards and you don't want any units lower than 15k GP? Just set the filter, and all units below the threshold are removed from availability.

Automatically or manually exclude certain heroes - Remember when CG pulled that stunt and excluded some of our best characters from our available rosters? That's covered as well! Your sheet will automatically update with the next list of excluded heroes. But even if there isn't a mandatory exclusion, you can turn off the automatic update and manually exclude any heroes you just don't want to sift through.

Multiple PvP Modes
In any of the following modes, select from a vast array of predefined (and user added) squads and receive counter squad suggestions with strategy notes and, in some cases, video or discussion links.
  • Arena
  • Grand Arena
  • Territory Wars
  • PvE Modes

There are also several suggested squads for upcoming character events as well as raid squad compositions, again with strategy notes.
  • Events
  • Quests
  • Raids
  • Territory Battles

Schedule
  • Your guild reset - As well as the current guild activity and what to save for to maximize guild rewards.
  • Squad arena payout countdown
  • Fleet arena payout countdown
  • All three raids! - Separate countdown timers for each raid, just as a reminder that it may be closer than you realized.

Upcoming Events Calendar
  • Territory Battle
  • Territory War
  • Grand Arena
  • Character Events

Squad Management
Create and save your own squads (with multiple sub leaders as well as sub support units) and counter squads with your own notes.

On-screen navigation tips
My most recent addition is the On-Screen navigation tips that helps guide you through, not only how to use the sheet in each mode, but also how to setup the sheet to maximize it's performance.

Updates
Many updates, including new characters as well as the core squads and counter squads are updated remotely. So there's no need to create a new copy of the sheet.

When there is a major patch/update, multiple warnings will appear with links to make a fresh copy. In addition, there is also a communication window at the bottom where I'm able to drop notes to let users know the status of the sheet and when they might expect a revision.

That's about it!
Thanks for reading all of this! This has been a really fun project for me to tackle and I appreciate all of you that helped put it together as well as those who helped test it out and make it better. It's all just to make the game a little more fun.

@Blackened

If you enjoy the sheet, please let me know! That's what it's all about! I don't get paid to do this. Your gratification is my payment. Thanks!

SHEET LINK >>> Download the SWGoH Squad Builder Spreadsheet

DISCORD LINK >>> Chat with us on Discord!
Post edited by Blackened on

Replies

  • Thank you to all the new members and sheet users! I hope everyone is getting some good use out of this project!
  • UPDATE version 1.02202019.0
    • Fixed editing prompt while entering teams on 'Squad Builder Add-On' - you'll need to make a fresh copy of that sheet and re-associate the key in your settings, if you use the add-on
    • Fixed add-on not associating with Squad Builder Sheet
    • Fixed added counters not appearing
    • Updated instructional tips
    • Removed redundant "addSquads" and "addCounters" tabs (found on Squad Builder Add-On sheet now)
  • FEATURE UPDATE version 1.02242019.0
    • Added zeta abilities to player data display
    • Added squad notes to Squad Builder display
    • Updated settings help tips
  • Please change the version format into something that will sort alphabetically. Like 1.20190224.0. It's why it's an ISO standard
  • Blackened
    10 posts Member
    edited February 2019
    Ok. I can do that. I just switched it because it's easier for me to read. But please take into consideration that I'm just a carpenter doing this for fun. I'm not a programmer or excel pro or anything even somewhat related. So I don't know about any related standards. I make cabinets and furniture for a living. lol
  • New features need testing. If interested, go to Discord and request to be a tester.
Sign In or Register to comment.