07-01-2016, 05:20 AM
IFNA - It looks like this is an issue for many people, so I will be updating the spreadsheet with IFERROR which should solve this problem.
The formulas came from someone who posted a very simple set of calculations in Discord. I don't remember who it was, but Hipoo suggests it was Blackie, and that is probably right. I state in the Information tab that I found these formulas and that I am not sure they are 100% accurate. I appreciate and help in correcting these formulas.
Aghannor said:
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.
So, it seems that the wording for Auto Damage is not clear. However, if you suggest that the Auto Damage should be a modifier to Base Damage % that shows on the Pet screen, that would substantially increase the Auto Damage value and make it better than any other upgrade. This is not what most people are experiencing. Absent clear evidence that the Auto Damage stat should affect the formula in some different way, I will leave it where it is.
Aghannor said:
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?
Tezexlo said:
And on the discussion about how we value the killing blow multiplier, I'm here more with IndigoFerret's 20% since the overkill only happens here. So the monster with ~4% hp left will be killed even without the killingblow dmg (depends on monster hp, for me its the 4% atm).
I felt that the 20% modifier made sense since it is not activated when monster HP is over 25%, but when it is activated, the monster is killed faster, thus the 25% of the time that is active ends up being less that 25% of the time. 20% seems reasonable and the difference between 20% and 25% wouldn't have a material affect on the value of this upgrade.
Tezexlo said:
First, it's not your idle autodmg, but your non idle autodmg, with this, the normal pet dmg fits with the shown value.
Killing Blow is actually halve the shown value (so misleading ingame).
Idle Auto Damage - It has been unclear to me which value to use coming from the Zilla IOU Complete MultiCalc. Where can I find the value you expect for autodmg?
Final Blow - What is the justification for halving this percentage?
Tezexlo said:
So the formulas would be:dmg (so it acually shows the standard dmg the pet does):
=B24*(1+B17)*(1+B18)*(1+B19)*(1+B11+B12-(B13*0,4))
dps:
=(B25*(1-B7)+B25*(B7*(B8+0,2)))*B9*(1+B10/2)*(1+B14/5/2)
Making the changes to these formulas gives me much higher calculated Pet DPS values than before. Maybe once I understand what you expect for autodmg, this might make more sense.
The formulas came from someone who posted a very simple set of calculations in Discord. I don't remember who it was, but Hipoo suggests it was Blackie, and that is probably right. I state in the Information tab that I found these formulas and that I am not sure they are 100% accurate. I appreciate and help in correcting these formulas.
Aghannor said:
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.
So, it seems that the wording for Auto Damage is not clear. However, if you suggest that the Auto Damage should be a modifier to Base Damage % that shows on the Pet screen, that would substantially increase the Auto Damage value and make it better than any other upgrade. This is not what most people are experiencing. Absent clear evidence that the Auto Damage stat should affect the formula in some different way, I will leave it where it is.
Aghannor said:
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?
Tezexlo said:
And on the discussion about how we value the killing blow multiplier, I'm here more with IndigoFerret's 20% since the overkill only happens here. So the monster with ~4% hp left will be killed even without the killingblow dmg (depends on monster hp, for me its the 4% atm).
I felt that the 20% modifier made sense since it is not activated when monster HP is over 25%, but when it is activated, the monster is killed faster, thus the 25% of the time that is active ends up being less that 25% of the time. 20% seems reasonable and the difference between 20% and 25% wouldn't have a material affect on the value of this upgrade.
Tezexlo said:
First, it's not your idle autodmg, but your non idle autodmg, with this, the normal pet dmg fits with the shown value.
Killing Blow is actually halve the shown value (so misleading ingame).
Idle Auto Damage - It has been unclear to me which value to use coming from the Zilla IOU Complete MultiCalc. Where can I find the value you expect for autodmg?
Final Blow - What is the justification for halving this percentage?
Tezexlo said:
So the formulas would be:dmg (so it acually shows the standard dmg the pet does):
=B24*(1+B17)*(1+B18)*(1+B19)*(1+B11+B12-(B13*0,4))
dps:
=(B25*(1-B7)+B25*(B7*(B8+0,2)))*B9*(1+B10/2)*(1+B14/5/2)
Making the changes to these formulas gives me much higher calculated Pet DPS values than before. Maybe once I understand what you expect for autodmg, this might make more sense.