EDIT: Okay I read more posts, but still can't see where the problem is. I did a DPS warrior spreadsheet some time ago for myself, would be glad to contribute to your awesome work but you'd had to PM me with precise description of the problem(s) because my forum reading skills aren't great
Last edited by nponoBegHuk : 12/20/08 at 10:21 PM.
Reason: Misread a post
The thing is that's how its done now. People were wondering if it was possible to not do it this way once the heroic strike frequency is determined, and have the total rage gained from white DPS modified off that percentage, and recalculate the rage available for heroics and also remove the RageGeneratedByAverageMainHandSwing cost of the strike. I say it is not possible, because I have tried it different ways this way all diverging. Someone said it was possible, but haven't shown how yet.
Okay, so you're right; once I set all the variables at once it started to diverge.
The solution I came upon, then, is to have a WhiteDPS temp value that the rage value looks at, and keeping the RageGenMH field's functionality. The actual white DPS should be the current formula with the MH portion multiplied by %noHS, but the rage generation formula should be based off how much white DPS you'd do if you did no HSes.
Doing it this way reports the same %HS freq that the current sheet shows, but will report a more accurate whiteDPS portion (~800 instead of 2000). This somehow is causing the SEP calcs to cause an Excel crash, and I don't know enough about debugging macros or excel macros in general to find out how/why it's happening.
One other thing you may want to include in the rage calcs is the cost of slam and deathwish, as these would take precedence over Heroic Strikes
Slam cost is included. Deathwish is not. The deathwish cost would not make any real difference at all really. This is an interesting solution, but I don't think it would add any accuracy to the calculations. I think you don't understand how I set it up.
I take the full white damage without heroic strikes, and then add the amount of DPS doing heroic strikes on the calculated frequency of main hand attacks does. What's wrong with doing that?
And yes sure I can add mixology. I got an update coming with item changes anyway.
I just had some quick questions regarding the Look Up tab. I would like to confirm that the gem SEP is included into the total SEP for any given item? How is the GEM SEP calculated? Does it assume socket bonus and appropriate gem colors? Also when considering an item such as [Signet of Edward the Odd] that does not have a proc value assigned, could i assume that there has not been an accurate model for it yet and thus there is no proc value added to its SEP value or maybe the proc value just hasn’t been added to the lookup tab yet? Furthermore does this reflect the DPS estimation by putting this in your current gear setup, in other words are we getting the full DPS added to the estimation when we include items that have no proc value assigned on the look up tab?
For any given item, it is sorted based on its total SEP, which includes a choice between max gem setup or matching the blue gems for socket bonus. For Signet, there is an accurate model for it, however the proc is not included in the SEP calculation. Once you load it into your gear on the Set1 page, the proc calculation automatically adds itself in.