I had this problemo with my Excel 2007,the Excel 2003 sheet however worked without a hitch

Hi, my first post on this great site for wow info

I imported my toon from Terenas EU server, spreadsheet looks great.
just a couple of things it didnt do, maybe it was me.
Spiked Titansteel Helm - never recognized my Persistant Earthsiege Diamond +42AP Stun Dur. red. by 10%
also never recognized my +16AP and +12Stam gem, as a result it gave no socket Bonus +8 Crit. Strike

Valorous Dreadnaught Legplates- it did not pull my Stormjewel +20Str.

Other than that this is cool..i will look to this to see if items will make a big enough difference dps wise.
Ty very much.

Yes they are.

First, the sheet does represent an unrealistic fight that does not exist in WoW. The DPS and SEP are guidelines more than anything that you can match in-game. Second, I think the sheet estimates slippage to be too low anyway, which is a whole separate topic.

@Machinator. Those posts encouraged me to toy with spreadsheet a bit, and I must say its somewhat fishy. With my far from good gear (I definitely ruined my fury set with wrong gems etc, I dont have 2 betrayers , and i barely got any upgrades i could use with fury (playing arms) ), on unsundered dummy, with just battleshout/rampage, the spreadsheet shows 73% heroic strike frequency. I must agree here , I just dont see how it is possible , and I have problems believing that in reality on a dummy I barely have rage to EVER heroic strike, let alone 3 out of 4 MH swings.

Where is this info from?

Just to check, you turned off all the raid buffs on the sheet right?

I suspect its mostly due to a requirement of the sheet to average rage over time, but in reality rage comes in such large chunks that excess rage often cannot cover the droughts. Of course if there was an easy way to calculate that we would have execute models already too.

I have to say I believe Catch22atplay is onto something. Like Shha I started to take a look at what my frequency and total HS damage 'should' be according to the spreadsheet and it does seem that its wayyy too high. I have ~95% HS frequency and reaching over 30% of my total spreadsheet damage. That's completely unattainable unless there is some technique that I've never figured out. The highest I've ever managed (I mean with some crazy lucky RNG) is like 22%. That's with crit% averaging like 10% or higher than my character sheet indicates.

Im no expert and I don't pretend to know how the spreadsheet works entirely but I do believe there is something amiss with the heroic strike portion.

Perhaps Landsoul can give us some explanation on the discrepancy between the sheet and numbers attained in game. I mean I can understand that its hard to fall into a 'perfect' scenario but when you've got everything going your way (splash damage, good RNG, etc) and you still only reach about 2/3rds of the proposed HS potential I think there might be something up with that.

I assume rage loss because of the 100 rage cap is not modelled at all? Or is it?
If not, a stocastical (read: empirical) approach might work to determine the heroic strike frequency more accurately.
The rage loss because of the 100 rage cap is more than significant. I am used to quite liberal use of Heroic Strikes, even as arms (e.g. on council hard my heroic strike : SD ratio is almost 1 : 1), and even there rage gets lost all the time. Hard hitting 2H weapons dont help here at all.

Just calculating all the rage gained by white damage (+ environmental damage?) and distributing this amount in all the instants and investing all the rest into heroic strikes would overestimate heroic strike usage by quite a bit. (Though this does not explain the deviance in HS usage of solo dummy testing ... rage loss can be kept minimal there)

Even implementing an empirical rage cap loss would not do real world conditions justice, as it neglects the granularity of rage income. But it would be a start.

Should be interesting to calculate a "rage balance" from an evenings worth of boss tries. Rage gained (white dmg done, #autoattack hits, incoming damage, talents and glyphs) und rage spent (abilities) should give a first indication on the magnitude of lost rage ratio.

the 100 rage cap is definately not modeled. I'm sure there are times with very hard hitting strikes that you can potentially go very well past 100 especially with 100% armor removal.

I also do agree that the way it's done in the sheet isn't how I really wanted o do it in the first place, but other methods I tried just produced chaotic divergence. I do agree it is too high, but there's not much I can do about it at the moment unless I cheat it or add some kind of constant like I do with the arms models which I don't really want to do. Some time I will do some dummy testing and compare white/heroic ratios and see if I can come up with anything I may have overlooked as far as a solution goes over the last year.

I appreciate the assistance with the brainstorming, but please keep it useful and intelligent.

Well, to keep that useful and intelligent. It feels to me , and im still trying to nail down the exact reason, that the spreadsheet gets "progressively" worse as your dps circumstances get worse. It almost feels like the normalized portion of rage gets too high. I added a "no buff, my poor gear" scenario another factor - ressurection sickness. The rage generation still was enough to heroic strike decently often (15%). From testing it myself, i was never in a position when i would use heroic strike while maintaining rotation in game under such circumstances. Considering the first page states you arent sure what rage normalization TG uses, could it be the culprit? That you picked up the more "optimistic" variant, which doesnt reflect reality?

42 AP stun reduction Meta is a terrible terrible idea,this sheet is meant to represent how the best gemming would affect your ideal 25man DPS,same with the 16ap gem,8str > 16ap...short simple fact,still you could add both gems to the sheet if you wanted,but the fact it doesnt recognize it seems to show that those gems are perhaps not the best choice

Admittedly the bold stormjewel is good,not common enough to be prevailent yet perhaps,but a definite addition to the sheet I think