|
Hmm, checking it atm, I'm kinda trying to do the same thing atm but it seem I'm complicating my life alot. Anyway.
I'm not sure I get the yellow hit mod/white hit mod thing.
You seem to be using 2.4 weapon speed normalization for stuff like ww/op, etc, even though your main hand is a dagger.
Also I think the whole point of stuff like this is to compare specs versus one another, 2-h is easier to do then dw in theory too.
The thing with crusader and flurry is that weapon speed change the up time obviously. The slower your weapon speed, the higher the uptime you will have on flurry and crusader due to instants being a constant. Stuff like windfury will increase the uptime on crusader/flurry alot. This is very hard to model exactly but it's possible to have some kind of estimate. What I did for crusader is assume 1ppm on autoattack. That give you a % per swing then you calculate the number of swing you have per second and get an uptime from that. Obviously it's an estimate and the higher the uptime the more likely you are to overlap, same with flurry.
Lastly I think using some kind of "hard coded" 55/45 formula to spread the value of specials versus white dmg is very flawed. The whole point of doing a spreadsheet like this is to not do that. You know how much rage per second you generate, you know how much rage per second stuff like bloodthirst and ww cost, you should be able to calculate how much special you can do in that time. You could use a 80%/20% rule for "other" specials and executes for the last 20% of the fight though and assume you spam execute as soon as it's up (got enough rage for it and your weapon delay is reset, possibly giving 1 bonus for using bloodrage). Also not sure about heroic strike but do you calculate that it lower your white dmg, thus your rage generation and that it's using the special hit table?
But overall good work, nice presentation too.
|