In view of the posting I did on this thread (Reset & Re-Classing Projects (share your experience) - #2 by Guvnor) I wanted something which would give me a better idea of the cost of resetting various projects as well as allowing me to plan out how far & how much emblems I could use on different heroes.
So I made the below calculator!
What it does:
This calculator does a couple things. Primarily it is designed to help with emblem planning/ working out costs of moving or assigning emblems & whether you REALLY want to do that…
Calculates the final node you can get to with current emblems
Calculates the Food & Iron cost to go from current node to last possible node.
Tells you the excess emblems you have & how many you need for the next node.
Calculates the total food, iron & emblems committed at the current node.
Calculates the food, iron & emblem costs to an input “target” node
Calculates the food, iron & emblem costs of “maxing” the talent grid
Some pre-set “max” points of Nodes 7, 15, 18, 19 & 20.
Instructions for use:
There is a tab with this on it. Just read it.
Link to the spreadsheet!
Feel free to make a copy or just work off my one.
Update Log
30 July:
Added “target node” calculations.
Input the node you wish to progress to
Outputs will include excess/ required emblems, food & iron costs
Added Emblems required to “Max” the Talent Grid
Booyaah!! It’s hard to manually calculate repeatedly embleming projects as well as stripping heroes of their emblems. I have plans to strip Kage and Albe of their emblems in favor of GM and Vela but I am hesitant cause i have invested a ton of food and iron on them and i am still leveling HA and Adv Farm, the former is iton-extensive. Will check on it later. Thanks, Guv
This is really cool! Thanks a heap for making it, I can’t edit things like this to save my life so on behalf of the not-mathematical players, YOU ROCK!
I’ve been working recently on emblems calculator, which shows the stats depending od the chosen path (eg. below). But google docs doesn’t support macros
It does, just have to re-write the macro… It also uses a completely different syntax & code set-up compared to Excel VBA. Its close but not quite the same…
But there is no ability to “import” your VBA code into Google Sheets.
I know it’s only been a few days since the changes so obviously haven’t had the time to gather all the info and work on this, and also this might not be as valuable as it once was with those changes…but are you planning to update this to account for the new costs?
Hey Guv, wonderful stuff you’re doing for the community! I requested edit access on this spread sheet, so when you got time approve it please. Thanks a lot