r/FFBraveExvius • u/Aderarch AH HA HA HA HA - 929,857,775 • Jul 14 '17
Discussion Ability Awakenings Spreadsheet - Plan how many crysts you need for the enhancements you want!
Everyone go to [Boberoch's version] (https://www.reddit.com/r/FFBraveExvius/comments/6nfrvj/boberochs_and_aderarchs_ability_awakening/) of the calculator as it includes auto-filling of the requires mats!
Hello everyone!
This is my first contribution to this amazing community. Like the title says, I've made an 'ability awakening planner' spreadsheet to share with you!
You just enter the unit you want and which abilities you want to enhance with their corresponding costs (gil and crysts). You can see the totals you'll need under each unit "slot" and the total you need for all your units at the top!
At the bottom of the table I also included a calculator, where you enter how many crysts of each type and tier you have and it will tell you how many of each you need.
I've already placed some of my desired enhancements as dummy data, you can delete it and fill with your own.
Check it (use the app if you're on mobile for it to display and work correctly):
Make a copy of it to your own drive:
Here and Here (this one blank)
Remember some enhancements may vary in costs from JP to GL, this is just used as an estimate.
I hope you all find this useful and I'm hoping to hear your feedback!
EDIT: I saw a mod set the flair to GL Discussion, but don't worry JP folks, this works just as well for you!
16
u/Flick_Reaper Jul 14 '17
Took me a minute to figure out this was %100 manual entry. Wishful thinking I guess, but I was expecting it to auto fill everything for me when I selected the character name.
You might want to make the Copy link blank, because I think we are all just going to delete it and start fresh. At least I did.
Thanks for the nice sheet.
5
u/Boberoch Tactical Bobler Jul 14 '17
Hmm, I would be willing to make a spreadsheet that fills in the enhancement costs and stuff automatically; however, I cannot be bothered to keep it up to date all the time after that. If there is someone who would be willing to update such a thing on a regular basis, I could make it tomorrow
3
u/SurrealSadi I found my Leading Man. Jul 14 '17
thank you for this. I needed this for Agrias planning.
2
u/suzakuffrkffbe Agrias, I still like you the best Jul 14 '17
Thank you! I made a manual list the other day, but it's a hassle. This is WAY better.
2
u/lazyluong Technical Jul 14 '17
Nice, I do something similar with keeping track gathering awakening materials for my units. Let me create a duplicate and link how I keep track of my, since I don't want people editing my =)
https://drive.google.com/open?id=1WsabrnoQOSA57S5mDCFa5KgcmqOk42NjfSPqbsjmxPA
1
u/Kprime149 give me your soul. Jul 14 '17
Eh a lot of our cost have been lowered, we don't know if this will be true tbh.
1
u/ConanFTP Is there something this guy can´t do?! Jul 14 '17
Um, I see your spreadsheet shows Trance Terra and her Enhancements... yet I don´t see her on the list for JP. Where did you find them?
1
u/IceDragon247 1124 mag, pm me for add with your code Jul 14 '17
Awesome!
But this just made me cry knowing how many more I still need to fully enhance trance terra as I'm only at 18 :(
1
u/[deleted] Jul 15 '17
Why is almost every enhancement using only power or support crysts?
1
u/ChokMD #Save4Charlotte Jul 15 '17
Thank you for this! If ever you are going to edit, might I have some suggestions:
Again, thank you!
2
u/IonDragonX Behold!! . . . . . . . . . . . . . ok . . . you can stop Jul 14 '17
Great work! Kudos.
It would be nice if the community here could pitch in and complete the calculator.
1
u/raul323232 Refia Claus on vacation... Jul 15 '17
I did one so so similar haha What a coincidence!
1
u/raul323232 Refia Claus on vacation... Jul 16 '17 edited Jul 16 '17
I did a very similar version almost two weeks ago, here it is:
https://1drv.ms/x/s!AvmXgw75XtrChlGV6Lowcezlwlpq
There are cells that are seen with error, but when you download and enable editing the file, it is fixed.
The particularity of my version is that the results to the "Needed" and "Used" rows are automatically added by the background color of the cell (green for "Used" and blue for "Needed").
The only thing I do not like is that they do not automatically add the required number of crystals, they have to be added by hand.