Tired of choosing your unions based on everybody's tier lists? Well, here ye go. A surprisingly simple to use (but a pain to make, my god) spreadsheet for setting up your crew (and creating your own tier list).
Made a spreadsheet in LibreOffice Calc to help with union matters because I don't want to chose based on everybody's tier lists. It currently includes the 35 UL's that I are available to me (Welcome to the Second Disk). Not gonna bother adding the rest until I get to them.
It's designed for the units’ designated sheets to be edited instead of the Unions one.
Constructive criticism is welcome.
Extract the 7zip file wherever you'd like and open the .ods.
The only editing you should ever do on the Unions sheet is changing the filters (to switch between Default and Custom Stats, reorganize the Unions themselves, etc.) or something cosmetic. All changes specific to the Units themselves should be made on their respective sheet.
To open hyperlinks, ctrl-click the "[link]".
To reveal spoilers within the Background boxes: left-click > Background Color > No Fill.
The "(do not delete)" sheet can be ignored. Otherwise, be sure to read the notes throughout before touching anything since it'll affect every sheet.
how to use the Unions sheet (gif)
quick Units sheets cycle through (mp4)
The three Custom columns on the far right (Primary Secondary Tertiary) are already filled in for my own purposes. You should edit them as you see fit, especially since I realized post-release that a few[?] of the units were mislabeled (e.g.: Both instead of Combat).
If you're curious to know how a non-expert decides his Unions, here's how they work (IIRC lul):
For each unit, subtract their STR and INT from eachother in whichever order creates a positive result.
In Allan's case,
In Caedmon's case,
In Darien's case,
In Gabriel's case,
In Irina Sykes' case,
Wiki pages.
Regarding compatibility with other programs, I didn't realize until the release of v0.58 that the spreadsheet would lose so much of what made it useful or easy to use when opened in Excel, even when saved as Excel 2007-365. Should've used that one online program (Collabora) I heard about on Reddit that's free as hell and sounds like a legit copycat of Excel. Meh.
Give LibreOffice a shot if you want the AutoFilters to work. Without them, the Unions sheet is significantly less convenient to use.
Discord Download
GDrive Download
Added Gaou, Irina, Jager, Kate, Paris, Sheryl, and Zolean.
Added Data Bars to numerical cells in Unions sheet.
Corrected Emblem selection for Royotia, Royotia Guild, and Athlum.
Corrected The Four Generals of Athlum's emblem image to the red one for Pagus and Torgal.
Taking a break from the game to play others and do other projects, so this won't get finished any time soon. That being said, the template's laid out and 73%'s already done, so feel free to release your own version for everyone.
If anybody knows a way to automate the copying and pasting of most of the info from wiki to spreadsheet, do tell. I'll be more likely to jump ahead and complete it.
Original 11/04/2020 Steam Post
Highly Recommended Steam Guide: TLR - Mods, Maps, Tools, and Whatnot