06-30-2016, 01:33 PM
(06-28-2016, 02:20 PM)IndigoFerret Wrote: I have created an Excel spreadsheet to analyze the new pet upgrades in various ways. Here is the file in Dropbox:
Version 0.1b 6/28/16
https://www.dropbox.com/s/n88ta6xtoupiea....xlsx?dl=0
If you are interested, please review and provide feedback. I hope this can be a useful tool for the community.
Indigo Ferret
Where did you get the formulas for determining how each of the various upgrades affects DPS? Specifically, whether they're additive or multiplicative with each other?
I ask because, if your formulas are correct, then the game descriptions for some of the upgrades are very, very misleading.
Specifically, the description of Auto Damage says it increases damage on pets gained from your auto damage. Which suggests the upgrade value should add some percentage of your non-pet damage to your bet damage. But in your sheet, it's treated as a basic multiplier of the pet base damage, which is additive with (and for all relevant purposes identical to) strengthening. I'm specifically referring to Pet Upgrade Sum cell 26, where B25 (base pet damage with orb/ascension modifiers) is multiplied by 1+B11+B12-0.4*B13. If that's correct, then the auto damage upgrade has nothing to do with your auto damage at all. In fact, you'd be better off ignoring it entirely and spending those PP on strengthening instead, which gives you 3 times the damage boost for far less PP.
Likewise, your sheet has final blow act as a 20% multiplier (multiplying by 1+B14/5). But why divide by 5, when it's supposed to activate at under 25% hp? If we're assuming that all enemy HPs are equally likely, shouldn't it be 1/4 rather than 1/5? And if we're not assuming that all enemy HPs are equally likely, how do we end up at 1/5 expected activation?