Something is wrong with the change to Mace spec as I seriously doubt I'll gain 6577.54dps for each point in it. Changes to expertise seem correct though, although was not expecting Belt of One-Hundred Deaths to still be that good. Thanks for sharing and keep up the good work!

I'm sorry to ask, but it seems I can't find the button to export my gear/talents etc anywhere. I also looked into the list of all the macro's to create a button myself and bind that macro to it, but I can't find it. Can someone tell me where the macro is right now?

You don't export anymore...just hit the import button and select the last version of the sheet.


Mace spec is broken for me also. I think the flaw is in the ucfact and cfact fields. Thats Q23 on buffed dps and unbuffed dps sheets.
If I understand the mechanic correctly, the bonus should be multiplied by the bonus for the RED.
RED = 1.03
Mace= 1.05
RED and Mace = 1.03 * 1.05 = 1.0815
Then multiplied by 2 for crit = 2.163

Meaning he formula for both should be:

That actually gives you possibly too low value. If going by how spreadsheet handles RED right one would be:

Working with different language excel, might have wrong symbology there. Well all depends on how they stack. Didn't check with RED and mace at same time yet tbh. Lot to consider there too.

Yes, Macespec had an error at this formula, I've already fixed this, but hadn't uploaded it. Those things are the reason, why this is a beta

I saw this post above and I'm getting a similar result. I have a theoretical Sword Spec build (19/42) with gear similar to the above that I like to tinker with. In it I'm finding GoA+IP better than WF totem by about 4 dps (assuming both are improved).

Conventional wisdom has ALWAYS pointed to WF being far better than GoA, so the result startled me. Is this accurate?

Hi,
I can open this Spreadsheet, but I can´t change anything in the fields, like Talents, Gear and Equip etc...

Cells you want to mess around with are Q23 on both Unbuffed and Buffed DPS sheets.

i'm not going to say either one of you guys are wrong, because i definitely don't know much about excell, but whenever i enter either one of those calculations into the spread sheet i get a huge dps drop( around 600) if i Don't have a mace equiped. what i did, which is pretty much the same thing, but only a little different is:

[top]IF(AND('Gear _ Buffs'!B28

"Relentless Earthstorm Diamond (12agi/3%crit dam)",MID('Gear _ Buffs'!R26,7,1)="1",Socket!S77),2.06,2)*IF(mhtype="mace",Talents!I19+1,1)

and it came out to the calculated 2.163 you get when you multiply 1.03*1.05*2

also, another thing i noticed, was that at the end of both of your forumulas, you have something similar to this:
.......*IF(mhtype="mace",Talents!I19;0)*2 or
.......*IF(mhtype="mace",Talents!I19 + 1,0)

neither one of those work, because if you don't have mace spec, then your IF formula will spit out 0, and since you're multiplying the RED crit bonus times the mace spec, anything times 0 = 0, so RED with a sword/dagger/fist spec will give you no bonus crit damage on the spread sheet.

i guess after making those changes, the only thing to find out is how mace spec and RED stack (is it (1.03+1.05)*2 or 1.03*1.05*2 or is it (1.03*2)+.05 or whatever)

another thing i've noticed is that haste aep is less than crit is for 41/20 combat build. i know the haste rating was nerfed, but it wasn't that bad on version 2.2.0.13. is it possible that formulas involving haste have been changed? nearly every haste item i use (except dragonspine trophy) is easily beaten by other items. i don't know, seems an aep of .73 (compared to .75 for crit) is too low.

Well most BT haste items are horrible now, so there's nothing to be surprised about.

I'm getting the same result, both with my gear/spec and the default gear/spec entered by Ellos. What gives?

one of the last version got a huge change on windfury and it dropped some DPS, I'll look if there is an issue, maybe it's new DPS is not high enough.

Expertise is truncated, just like weapon skill. Partial expertise doesn't count towards dodge, so [Shoulderpads of the Stranger] give only 2 expertise (0.5% dodge) instead of 2.54 (0.63% dodge). Please insert the ROUNDDOWN (ABRUNDEN) command as I mentioned earlier.

Do we have a list of all 2.3 rogue related items that need to be added into the sheet,
or should we start making one to help elios in inserting it there?

http://www.mmo-champion.com/index.php?topic=1629.0
http://www.mmo-champion.com/images/n...quickblade.jpg
http://www.wowhead.com/?item=33872
http://www.wowhead.com/?item=33540
http://www.wowhead.com/?item=33538
http://www.wowhead.com/?item=33222
http://www.wowhead.com/?item=33539
http://www.wowhead.com/?item=33484

What's the evidence for this?

No you can't. All other ratings work with fractional points - this is a new stat and new rating, so it makes sense that it will indeed give fractional points.

As mentioned above, weaponskill was in the game as an integer value long before weaponskill rating was kludged on top of it. This in itself is enough of an explanation for why weaponskill would be truncated, unlike every single other rating stat in the game.

All that can be said at this point is that we should make no assumptions either way until it is tested.

Well, at least the character sheet on PTR says so. With 2 WeX and [Shoulderpads of the Stranger], it says my expertise is 12 and my chance to be dodged is reduced by 3%. Of course it could be wrong, but as long as not proved otherwise, I'd go with the character sheet.

I'm going to see if I can gather enough expertise rating to do such a test.
Against level 70 and a presumed 5% dodge rate, with 2 WeX, you'd need a rating to match 2.5% dodge.
If partial counts towards it, 40 additional rating would be enough (40/(2.5*82/52)*0.25= 2.537%), and if not, you'd need 48 additional rating (48/(2.5*82/52)*0.25= 3.044%).
It depends on a 5% dodge rate of course.

Easier would be testing against a blasted land mob, but unfortunately they're level 57, so if weapon skill still does give 0.1% anti dodge against lower level enemies, you won't see any dodges against mobs under level 61.

// Edit
Bah, blatant bullshit.
It's not 48 expertise rating, as the steps are 0.25%.
I have to think about another way to test this.

#925

Hm, I see no way of testing it besides statistical analysis.

The problem is that between two points of expertise rating, the difference is never larger than 0.2488% in dodge, when comparing not truncated to truncated (this value being 67 expertise rating).
Therefore there is never the case when a non truncated formula would see no dodges against a mob, whereas a truncated formula would produce dodges.

The only option then would be to gather thousands of thousands of swings, and to look for a statistical mismatch. Something I certainly do not plan to do anymore right now.

Therefore, without such testing, I'll just stick to the character sheet.

I'd like some answers here as well. I have a rogue in my raid group that has run some numbers with his combat dagger build and says that GoA + IP will actually do more damage than WF. I'm trying to crunch some numbers myself, but if anyone here already has I'd love to see them.

GoA + IP/DP has always done (slightly) more damage with dagger based builds when taken in a vacuum, and with the nerf it's not that surprising that it happens for swords too.

The issue is that warriors benefit a lot more from windfury than GoA due to rage mechanics (plus agi isn't a great stat for them), and the tiny dps gained from going from wf to goa/ip is nothing compared to what you gain from battle shout.