So thanks to
@bvira I got this idea in my head that I should make this for myself. I am still gearing my PVP toon, and don't want to do it wrong. It costs too much to make the wrong stuff. This should be fairly accurate for the variables accounted for, but there are situations that cannot be simulated, such as flat mitigation. The optimizer section doesn't take into account lifesteal or recovery though, so you will likely need to tailor your input to account for the recovery and lifesteal you plan to build.
This tool should be able to accurately calculate damage output against a specific target, as well as calculate effective hit point total against a specific attacker. This is useful for min-maxing your critical strike, power, and armor pen for offense, and defense, deflect, and hp for defense. It comes with a brute force optimization method (big thanks to
@micky1p00 for pointing on the script editor for google sheets) to try and help you determine the maximum benefit you can get out of a limited stat pool. Note that this can take a very long time to process for large pools of stats, or even throw errors if it takes too long, so try and keep your values inside a reasonably realistic stat set. Note that the optimizer also gives stats in multiples of 1000.
Please let me know if you have any questions on how it works, or find any issues with it. I have very little motivation for adding new features though, so it would probably take an army or two to get me working on additional optimizers
https://docs.google.com/spreadsheets/d/1aPAuX6YOPWMPBdVga0Yr1BbJddYQqjuvzGJa6LaFrWkNote that if you don't understand exactly how weapon enchants work, you should avoid trying to add them in the damage calculator.
Signature [WIP] - tyvm John
Comments
I am curious: I've seen
RI = .01*((((70*0.9)^0.9)+41)*(ArP/9977.011)^0.85)
used in several places. Where did you get this from? Did the devs disclosed the exact formula? Or did someone fit a curve to {ArP, RI} data by minimising a loss function and that was the best fit equation?
Aelan Icebleed (CW)
Signature [WIP] - tyvm John
Aelan Icebleed (CW)
Which is 1 + (0.75 x 0.4)
Signature [WIP] - tyvm John
Aelan Icebleed (CW)
Signature [WIP] - tyvm John
Signature [WIP] - tyvm John