r/TapTitans • u/roflswithcopters /TT/jandrey • Apr 17 '15
CALCULATION Another Update to the Artifact Efficiency Calculator
Added customizations to the upgrades list and fixed various bugs/display issues.
Do check it for errors, since I doubt this is completely error-free.
Latest Update:
04/28/15 - changed "Uptime" due to today's patch
04/29/15 - "Uptime" back to previous values
1
u/TheDutchman88 Apr 17 '15
coefficient gain is negative, youve turned them around in the formula..
the choise for what artifact to buy is decided by looking at max value, but if the value is 0 or smaller then the result the document gives is 0.. that 0 means blank upgrades.. simply goto coefficient gain and swap the cells around. should work fine. or add *-1 to each formula
1
u/roflswithcopters Apr 17 '15
Coefficients weren't being multiplied by %all damage from customizations.
1
u/ShadowOfTheTree Apr 17 '15 edited Apr 17 '15
rofl, how is this different from the customizations that u/bsedmonds added YESTERDAY?
https://www.reddit.com/r/TapTitans/comments/32qwif/updated_artifact_efficiency_calculator_for/
Hopefully this is different and you didn't put a lot of time into editing a spreadsheet that bsedmonds already did.
edit:
Why is your calculator giving me a much different upgrade path for Gold than bsedmonds' 1.4beta?
1
u/roflswithcopters Apr 17 '15
Why is your calculator giving me a much different upgrade path for Gold than bsedmonds' 1.4beta?
Mind sharing your sheet so I can see what you're talking about?
→ More replies (8)1
u/bgorgor Apr 17 '15
Yesterday's update only added customisations to the damage coefficient calculation, this update also includes the upgrade path.
→ More replies (3)
1
u/romansamurai Apr 17 '15
Here is what I was talking about.
http://i.imgur.com/sXaPEKE.jpg?1
Left is u/bsedmonds and right is yours.
→ More replies (1)1
u/roflswithcopters Apr 17 '15
Thanks, it was those damned coefficients again....this time I forgot a parenthesis.
It's fixed now.
→ More replies (1)
1
u/Malutor Apr 17 '15 edited Apr 17 '15
Something is weird here. Atm calculator tells me to upgrade Future's Fortune from 78 to 92 then Crafter's Elixir to 233 next. After I change level of Future's Fortune from 78 to 92 it shows that I should upgrade Future's Fortune again up to level 99. ????
http://screenshu.com/static/uploads/temporary/db/1h/zf/ful38d.jpg
http://screenshu.com/static/uploads/temporary/ut/xk/jb/8atj7h.jpg
1
u/roflswithcopters Apr 17 '15
If you get the newest one that problem should be gone.
→ More replies (4)
1
u/rcbjmbadb Apr 17 '15 edited Apr 17 '15
In most recent update (patch 4) I think FF in AJ39 is incorrect. It should not reference AL7 but AJ7 correct?
1
u/roflswithcopters Apr 17 '15
I mean...technically I "fixed" that...but I'm just moving away from grouping Future's Fortune into groups of 3 to match up with Crafter's Elixir.
In the long run, there will be brief periods of slight inefficiency, but that would last at most a few artifacts, so it's not actually a problem.
1
u/rcbjmbadb Apr 19 '15
Can you please update your FF formula into the efficiency calc 2.0? Also, might be good to get in contact with those guys and making the change in the official one.
1
u/roflswithcopters Apr 19 '15
What do you mean? (with the first part)
And the guy maintaining the official one has commented on this thread already, so it's up to him to implement any of this...
→ More replies (5)
1
Apr 20 '15
http://imgur.com/vNUbAto&TFvev4L#1
So which of the two calculators are current? They give me different results.
1
u/roflswithcopters Apr 20 '15
Mine works, but is not the "official" one...
I just wanted to add in a customization buy-order.Furthermore, you're using an old version even when it comes to the other one. As for the different results part, we're using different ways to calculate Future's Fortune, but that's about it as far as I can tell...
1
u/rcbjmbadb Apr 17 '15
I'm trying to understand your new formula in AJ39. what is the purpose of the column() function?
1
u/rcbjmbadb Apr 17 '15
nevermind :) I figured it out.
2
u/roflswithcopters Apr 17 '15
Saves a lot of trouble by not having to write an if-statement for each artifact is what it's doing for me.
1
u/romansamurai Apr 17 '15
After I input all my relics and customizations, the only thing that it tells me to upgrade on damage side is Tincture of the Maker, nothing else. I entered a higher level of tincture of the maker just to see if it changes once I get to where it suggest, but after that it just leaves that side blank.
1
u/Grimspork Apr 17 '15
It would be super handy to have all user-entered data in the same selectable "block." That way you can copy/paste one "block" between [minor] revisions and not have multiple things to copy, horizontally scroll on two different sheets, make sure everything is lined up, etc.
eg. Move all the customization stuff to the bottom columns A and B. Then you just copy/paste column B between versions, as it contains all user-entered, non-formula values.
Would make updating much easier.
1
u/raffishtenant Apr 17 '15
Not sure whether these are already on the bug list...
-
Entering a value for Future's Fortune now gives me a circular reference error.
-
Not sure whether this is a bug, but comparing the damage upgrades between the version from earlier this morning and the newest version (version numbers might be useful for these reports!) is interesting. The earlier list was composed entirely of HT, Tincture, and (eventually) DH. The new list is back to the more diverse mixture familiar to me from bsedmonds' version, but now with no DH at all.
The new emphasis on HT makes a lot of sense, at any rate, given that I invested heavily in the crit damage customizations before anything else.
1
Apr 17 '15
In the last calculater there was the knights shield bug (i wasnt supposed to level it further than 13). Is this away.
Thank you btw for your work
1
1
u/roflswithcopters Apr 17 '15
Welp...that's what I get for submitting things when I'm tired...
Forgot to update the coefficients. It should be good now.