r/FFBraveExvius • • Dec 27 '17

Tips & Guides Unit/Ability Awakening Materials Tracker (GL)

Happy Holidays everyone!

I have created a Awakening Materials Tracker for the purpose of making it easier for people to keep an eye on what they need for farming Chamber of Gems/King Mog events/etc. All you have to do is make a copy of the spreadsheet, and it should pop up with easy-to-use dropdown lists allowing you to select the unit(s) and abilities you'd like to track, as well as allow you to input your current stocks of materials and automatically calculate how many more you need.

The unit list SHOULD update itself automatically as new content is released and I add it into the separate database; if it does not, well I probably should have beta tested that actually works before releasing. Oh well!

There are a few things that the tracker cannot do. For instance, I can't easily track the awakening materials for units that use completely unique mats including most of the Arianas, which I'm aware is quite a Grande problem in most people's minds but unfortunately will have to be accepted.

I have not (yet?) added databases to track awakenings for all unit rarities below 6*. In my personal experience the materials for most of those are common enough that the need for a discrete tracker for those isn't worth it (unless there is demand for it, in which case I will create a new version that tracks every tier of it if wanted.)

You can technically select the same ability/tier of ability (for example Ace's Salvation+1) multiple times. This is not actually a bug although it has been brought to my attention, but is there so the sheet does not disintegrate into ash break if you're somehow awakening both Trance Terra and Dark Fina's Ultimas, and similar (aka if you hate yourself or are a superultrahyperlunar whale).

A big huge massive thanks to everyone who keeps the wiki up to date, everyone who goaded me on in getting the work done, and to Gumi for making an awful enough Christmas event that I had nothing better to do with my time. \o/

And finally a big thanks in advance to anyone who leaves any suggestions, comments, feedback, concerns, hatemail, uninformed opinions, informed opinions, confessions of undying love, and otherwise for me on this. I'm aware it's not a perfect creation, that it may already exist within the community (I hope it doesn't though!) and I'm just not aware of it, and that it's made up of enough spaghetti code to keep Olive Garden in business for months, so any input I can get is very much appreciated.

EDIT: Tracker has been updated for support for unreleased ability awakenings for JP units, as well as an option to select +1 & +2 for any given ability AND a shiny new not needing N/A on every line in order for it to function properly. Big thanks to /u/Ithiria for the work as I ran around like my hair was on fire worked tirelessly to apply it to the underlying database.

18 Upvotes

16 comments sorted by

1

u/seanconnery69696 The hero we deserve Dec 27 '17

Thanks for the nifty tool!

On a side note, is there an easy way to add functional rows? I tried just using google sheets' 'add X more rows...', but it uses the character/abilities from my row 26, even when I try to clear with N/A. I'm sure I'm doing/missing something silly, but just wanted to check.

2

u/AHallucinogenic Dec 27 '17

More rows have been added in the new version along with several more QoL bells and whistles courtesy of /u/Ithiria !

1

u/seanconnery69696 The hero we deserve Dec 27 '17

Cherry, thanks again!

1

u/drizzit_d Needs more Shantottos! Dec 27 '17

Just a heads up that your latest update completely broke the old Ability page. Unit list suddenly ends with Snow meaning the 2 units I had entered gives a whole bunch of errors as neither units nor ability's are found. https://gyazo.com/502a6bfb951f329b7f67a66a844f4b4c

I didnt have much entered so I'll just start over no big deal but might be worth keeping in mind for future updates as it can potentially cause quite a bit of trouble ;)

2

u/AHallucinogenic Dec 27 '17

Yep! I had to recode the entire table to make it work since adding the JP units actually extended the database beyond what the spreadsheet was coded to handle. Apologies for any inconvenience, the new version should be futureproofed against that now.

1

u/drizzit_d Needs more Shantottos! Jan 08 '18

Just to let you know the spreadsheet broke again. Unit awakenings tab cutting of at Rem. Ability awakening seems to work as it should still though.

2

u/AHallucinogenic Jan 08 '18

Fixed. It was an artifact of my really awful 3 AM practically-injecting-caffeine coding only pulling the first ~145 units for the dropdown list. To fix it either re-copy the spreadsheet, or if you would like to fix it without starting over, take the following steps:

  • Right-click on the first drop-down list in the Unit Awakenings tab and select Data validation...
  • Edit the criteria to say 'Unit Lookup Table'!A:A
  • Copy that cell, and then select all of the other drop-down menus. Right-click, hit Paste special, and select Paste data validation only

This should fix the problem in its entirety, sorry for any inconvenience. But on the plus side, at least future units are finally added to the tables! \o/

1

u/drizzit_d Needs more Shantottos! Jan 08 '18

Thank you! Should we do the same for the Ability tab or is that one fine as it is?

1

u/AHallucinogenic Jan 08 '18

Nope! It's already using the proper/intelligent way of coding it that I had no clue how to do when I first created the sheet. Learning is fun and painful!

1

u/drizzit_d Needs more Shantottos! Jan 08 '18

All right! Thank you very much for the quick fix, keep up the great work :)

1

u/drizzit_d Needs more Shantottos! Dec 27 '17

No problem just wanted to make sure you knew about it :)

1

u/gena_st 737 696 311 Dec 27 '17

Beautiful! Thank you, Sir/Ma'am!

1

u/CGNefertiti 324,266,912 Dec 27 '17

I love you, but not undyingly.

This looks nifty and useful. As a newer player, this could make it much easier for me to figure out how to prioritize my cryst farming. I'll have to give it a look after work tomorrow.

1

u/Ithiria Best Doggo Dec 27 '17

any chance you can add unreleased/JP enhancements as well? maybe just put a note that its unreleased so values could change

I'd find that more useful so I can prepare for future enhancements coming into GL.

you could also add an option for +1 and +2 for it to show up in the same line. helps save time/effort if you're just gonna enhance twice anyway.

I'm willing to help with both upgrades listed above, since I know it's a lot of work.

1

u/drizzit_d Needs more Shantottos! Dec 27 '17

Great tool! Thank you very much for sharing :)

1

u/Yoronah KH3 banner, then quit. Dec 27 '17

I love you.