Email: Password:
Codename Entertainment
 | Page 1 2 3
Talent Calculator Updated With New Talents

119 Posts
Link to post - Posted May 2nd 2016 at 6:02 PM
Last Edited August 5th 2016 at 12:38 PM
Smash10101
Hey all, I just finished updating my talent calculator for the new talents. You can find it at https://docs.google.com/spreadsheets/d/1I-EK0jLRbOR__h46oYfT-ewKA7DQ7hregp2k9RasoW4/edit?usp=sharing or tiny.cc/CotLI if you don't want to type it all out.

Let me know what you think/if you find any bugs!

EDIT: version 4.1 is live

6 Posts
Link to post - Posted May 3rd 2016 at 5:13 AM
IndomitableOne
Hey Smash. Thank you for doing this and all the work it took!

I did download the latest version (2.1.1) and I think I found a small bug. I have the stormrider talents set to disabled (B14). When I run the calculator though, it still puts points in "Storm's building."

Thanks again!

119 Posts
Link to post - Posted May 3rd 2016 at 5:33 AM
Smash10101
Good catch. It's fixed now.

1 Posts
Link to post - Posted May 5th 2016 at 6:44 PM
Last Edited May 5th 2016 at 6:45 PM
smokehalo
Storm's Building is not looking up the correct index for cumulative cost. It's off by a column (should be referencing K instead of J), resulting in incorrect calculation of unspent idols.

Edit: Using v2.1.3.

119 Posts
Link to post - Posted May 15th 2016 at 5:19 PM
Smash10101
Got that fixed. Sorry about not posting about it

5565 Posts
Link to post - Posted May 18th 2016 at 7:57 AM
Raymond
why does the new calculator have so limited abilities with the old talents?
do you have a copy of your old calculator anywhere?

119 Posts
Link to post - Posted May 25th 2016 at 9:29 AM
Smash10101
no copy of the old one, I don't think. I don't know what you mean by limited abilities with the old talents. If you explain that more clearly, I might be able to fix it or get you the features you want.

Also, I just released Version 2.2, with cool new stuff like scores for maxing FL and SB, and counting your idols spent on DPS talents. Also, you can now disable either storm rider talent, neither, or both

5565 Posts
Link to post - Posted May 25th 2016 at 10:46 AM
Raymond
i mean where the heck is time o rama and endurance training, how much will level x of those cost... you say so for a lot of talents, but not the old ones

119 Posts
Link to post - Posted May 25th 2016 at 8:48 PM
Smash10101
The calculator only calculates talents that increase your DPS. I've never had the ability to compare the value of DPS and nonDPS talents. If you put numbers into the sheet for whatever level of whatever talent you want, it'll tell you how much total idols it takes. If you want just a sheet full of cost data, it's there, just hidden. If you unhide it you can see what each level of each talent costs, as well as cumulative costs.

1 Posts
Link to post - Posted June 1st 2016 at 11:12 PM
Last Edited June 1st 2016 at 11:12 PM
Charsi
I found a small mistake in the Talent Calculator sheet.
In cell B4 it should be FLOOR not ROUND. I just checked with my new Siri which has 3 EP and she does not provide any EP for the King with Sharing is Caring level 0.

Great work btw.

119 Posts
Link to post - Posted June 3rd 2016 at 5:39 PM
Smash10101
New version is out, featuring new, better calculations for Overenchanted, Sharing is Caring, and Ride the Storm, as well as a box showing your total bonus from talents.

17 Posts
Link to post - Posted June 9th 2016 at 7:54 AM
Oort
Great work Smash!

I'm not familiar with google sheets so am figuring it out as I go. One thing that has tripped me up is after obtaining a copy I can only use it so long as I don't close that tab/window. If I do close it or it gets shutdown then the "calculate talents" menu option doesn't appear or is hidden by "Last update was x time ago". Is there a way to turn off that history update link right there or is there something I can do to make the talent calculator menu choice appear again?

119 Posts
Link to post - Posted June 9th 2016 at 2:20 PM
Smash10101
Sorry Oort, I've got no clue. I might be able to look into it for you sometime next week though.

17 Posts
Link to post - Posted June 9th 2016 at 4:09 PM
Oort
Ok,thanks Smash

17 Posts
Link to post - Posted June 12th 2016 at 10:17 AM
Oort
I think I found the reason Smash. When first loading the Talent Calculator from my google drive it opens on the Instruction page. After a few moments the tabs at the bottom appear to go to the Calculate page, Click damage Calc, Version History etc.

If I don't wait for the instruction page to be completely loaded and go to the Calculator page too soon then I don't get "Calculate Talents" selection. But if I just be patient and wait for the Instruction page to fully load, then I get the selection when I switch to the calculator.

119 Posts
Link to post - Posted June 13th 2016 at 4:21 PM
Smash10101
Huh. Well I'm glad to hear you figured it out.

319 Posts
Link to post - Posted June 18th 2016 at 4:51 PM
ihatethisfing
between the newest version and the one i was using (which is like a month old), the idols spent is far more wrong on the newest than the oldest by 15k or so. i triple checked everything and not finding a difference.

119 Posts
Link to post - Posted June 18th 2016 at 4:56 PM
Smash10101
The newest version, 2.3.1, didn't change anything on the idol counting from version 2.3.

If you want me to take a look, share your copy of the sheet with me, as well as a screenshot of your talents.

319 Posts
Link to post - Posted June 18th 2016 at 6:56 PM
ihatethisfing
turns out the new version wasnt calculating J13 for the "idols spent on passives", so i added that in and now its only off by 387.

119 Posts
Link to post - Posted June 18th 2016 at 9:08 PM
Smash10101
J13 is the total idols spent on the things in the "other talents" section, which is the utility tree and most of the active tree. Idols spent on passives in H15 is the number of idols spent on DPS increasing talents.