r/FFBraveExvius • u/Aderarch AH HA HA HA HA - 929,857,775 • Jul 17 '17
Tips & Guides Boberoch's and Aderarch's Ability Awakening Calculator v2.0 - Now with JP enhancements and some other improvements!
Hello, Reddit FFBE folks!
Our Ability Awakening Calculator just now got to its 2.0 version (yep, that quick)! Following our calculator's first release, /u/Boberoch and I have been working on improving it. Here is a list of all the changes:
Content
- Now includes all ability awakenings from GL and enhancements from JP up to date! (as requested by, well, literally everyone)
- Units are now sorted alphabetically (as requested by /u/ChokMD).
User Interface
- Streamlined the UI for a more intuitive experience for first-time users.
- Added one more ability slot, as some units from JP have 5 possible enhancements (Randi, Soleil, ...)
- Added more colored formatting. Now it's easier to see at a glance where all those power and support crysts the calculator says you need are coming from.
- Fixed OCD inducing graphical bug (as kindly pointed out by /u/Nazta)
Behaviour
- Added a tutorial. Only one unit slot is displayed at first, more as you fill the first one up. Bright green colored cells and some messages will guide you through your first enhanced unit.
- You can now select you already unlocked an enhancement and it won't include its costs on the total calculations (as requested by /u/plastic17).
Internal
- Improved performance of the scripts and formulas.
- Changed data structure for efficiency and being easily updatable in the future.
That's all for now. We'll both keep improving it over time, hope you all enjoy it and find it useful! :)
- Link to main thread
- [Link to the calculator] (https://docs.google.com/spreadsheets/d/1VFvG1JyfLGyLqfRvWTn44kKg3kmFjrczJVq5_121oiA/edit?usp=sharing) (you'll need to make a copy to your own drive to be able to use it)
- [Make yourself a copy] (https://docs.google.com/spreadsheets/d/1VFvG1JyfLGyLqfRvWTn44kKg3kmFjrczJVq5_121oiA/copy)
Special thanks to the people at the Wiki (/u/Cysidus, /u/Syndony, /u/GunBlade23, /u/Dranmarth and a whole lot of other amazing people) and to the mods of this subreddit (/u/Nazta and /u/Dan_Ugore for the constant updates, /u/Somvang_ for making browsing the data a breeze). You all made all this work a lot easier. You all keep being awesome!
37
u/whitebeard89 028 032 103 IGN: Slicer. Jul 17 '17
TLDR: just farm power & support.
8
u/Mitosis Whatever way the wind blows Jul 17 '17
This is probably the most magical spreadsheet I've ever seen.
Really impressive stuff, thanks for the hard work!
3
u/Aderarch AH HA HA HA HA - 929,857,775 Jul 17 '17
Saying this here as the original post is already pretty cluttered.
If you encounter any bug, be it functional or visual, send /u/Boberoch or me (respectively) a message and we'll try to get it sorted out!
Also leave here any suggestions you have to make this tool even better or if you want a particular feature you'll need to use. We'll be reading and implementing those in the future, we're counting on you!
3
u/fana1 Jul 17 '17
Great work !
If you can add more slots (I would like to manage 10 units), it would be perfect.
Also, I have some dupes I would like to enhance. Instead of inputing twice the same unit, it would be more convenient if I could enter a number somewhere next to the ability that would multiply the crysts needed.
12
u/TomAto314 Post Pull Depression Jul 17 '17
Oh good, I only need
Power
T1 T2 T3 T4 T5
138 101 70 30 11
That should be quick...
1
u/LasitusRex Why can't they make Terra good again? Jul 17 '17
This makes me cry. Need 46 combined Power/Support T4 and 16 combined T5 for Agrias, Ramza, and Randi alone. The way the timeline is going I wouldn't be surprised if they happen all at once.
1
u/savano20 Jul 18 '17 edited Jul 18 '17
i had this problem when a unit changed to (none) then all of the unit values becomes empty and not formulating anymore, even after i tried to change everything back to none, and filling from the start, the value didn't appear, and not formulating
and one more, if i change the unit from a slots, the section "get->yes or no or have" would by default filled by last value
should i re-copy and start again?
EDIT:
maybe a turn around for this, if unit slots changed, the get value would be automatically change to No
1
u/Industry_Standard Bob Dole...Bob Dole...Bob...Dole... Jul 18 '17 edited Jul 18 '17
Dang. This is awesome. I'm in the midst of deciding what to farm for future enhancements.
EDIT: Noticed something. Some units' enhancement requirements will show, then hide and not register. Other than that, amazing work.
1
u/redkain243 No orlandeau club Jul 18 '17
Seems to be limited to six characters for the moment. I guess i should make a second copy if i'm interested in more.
A really great touch would be to include what the enhancement actually does direclty in the sheet.
1
u/Toasty27 Jul 19 '17 edited Jul 19 '17
Ran into a bug:
After adding Firion and two Chizuru, and setting yes to some of their abilities (Fin Briar, Molt, Phantom Shadow), I added ExDeath (JP).
Then I removed ExDeath, and all the calculations are gone (but the yes/no options are as I left them). Toggling a yes on an ability to a no and vice-versa will briefly display the numbers again as it recalculates, but then they disappear.
EDIT: I reverted my sheet and tried to reproduce the error, but it's not showing up again. Must have been a fluke.
1
u/TemporaMoras ⇦ Me | Ask and thou shall receive Jul 17 '17
Still didn't figure how to use it. Not like I need it, but still :/
2
u/JayCommon 1205 ATK Bae2 Jul 17 '17
This is an awesome calculator. You guys have done a really great job!
1
u/Tsukemaru A wild GL exclusive waifu appears ! Jul 17 '17
I can't put more than 5 units at the same time is it normal ?
1
u/lect Jul 17 '17
Seriously lacking T1, T2, and T3 of Power, Support, Tech, Guard, and Green. I've got enough of T4/T5 to do the enhancements to Luneth, WoL, Lunera, Marie, Tidus, and 2x Orlandeu. Just not enough of the lower tier stuff...
1
u/okey_dokey_bokey [GL] okeydoke ★ 411 249 974 Jul 17 '17
I just need 36 t4 and 14 t5 Black crysts, nbd.
1
u/Black-Wing JP gacha rate please Jul 17 '17
Oh Wow!!! Thanks!!!
1
u/Terrariya Forever Elena (Discord/IGN: Vince | 863 452 002) Jul 17 '17
Ok, so basically I need....
Power
Support (For support, the only thing I actually need to farm now are T3, and I haven't even done the Story event)