No matter how I try to simplify the heroic strike calculations, they always diverge as I suspected. Ebs2002, If you can find some way to make it converge by your means, please tell me how.

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

Could you add mixology with a flask to the AP Flask choices? It's 244 AP.

When I open the spreadsheet using Excel 97, I immediately get a warning that it contains circular references. Any idea how to address that?

Removed

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?

Thanks for all the information.

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.

stats for undead lvl 80

AP, 566 (+3 from att giving 569)
STR, 173
Hit Points, 9541
Stamina, 160
Agility, 111
Armor 222

Found a bug in the spreadsheet. When I changed the glove enchant to none, the sheet bugs out and returns nul values for everything.

Would it possible to include a switch to toggle between 5% penalty TG and 0% penalty TG?