#### Modeling Stat Weight Changes

by

, 11-02-2014 at 09:19 PM (31646 Views)
Hi guys, I'm back.

Yes, I re-subbed recently, have found a new raiding guild to call home, and of course have a little mathy side project going. However, I don't have as much time as I'd like, which means getting the initial draft out for public viewing is taking some time. Rather than wait I figure I'll share what I'm working on here and see what others think.

One of the things I’ve always thought about was working out stat “inflection points”, ie: where one stat becomes more valuable than another. Generally this is when a red gem becomes worth less than a yellow gem, which usually happens in the middle of every expansion.

Part of the problem for finding this is that at the moment we only get static stat weights for a particular gear set, and it takes a lot of trial and error to get some of the information that I’ve previously posted about. In an effort to get some more useful information on this I’ve gone back to my modeling spreadsheet roots, and have started looking at each spell individually, working out stat weights & changes from there, and then merging everything together later.

There are the usual flaws with models, in that you have to assume every percentage based event will happen exactly that often, which leads to some slightly complicated formulae, and I’m not going to be using things like trinket procs and cooldowns either. This doesn’t mean we can’t use it for general information purposes though.

So far I’ve got the base stuff done, and have worked out some of the stat interactions for Lightning Bolt. Examples:

Spellpower has a gain of 2.2140 dps per point, but also increases the value of Haste by 0.00004, Crit by 0.000047 and Mastery by 0.00038. Similarly, Haste increases by 1.4760 per point, the value of Spellpower by 0.00040, and Crit by 0.00156 (I’ve yet to do the mastery calculations),

As you can see, Spellpower has a minor increase from secondary stats, and has the same minor influence back. Secondary stats, on the other hand, affect each other about three times as much as Spellpower does.

This matches with what we observe, where Intellect is most important to start with, and then there’s a switch mid expansion to secondary stats as the total amount of secondary stats increase.

Once I’ve got all of this data modeled for the individual spells I’ll estimate the total damage and then use this damage proportion to add the individual weights together. The resulting information should show us a better picture of stat interactions and give a better answer to those “how much X should I stack before going for Y?”.