I probably can put them on the same page, it would take a bit of work though.

The spreadsheet isn't designed for level 60 because of glancing blows. However, I'll try to work that in my next release.

I'm guessing you don't get the same number because I don't factor misses into the yellow hit mod at all. I assume with the type of people using this, you're going to have +6 to hit. This is probably a bad assumption though, seeing how much +hit is trade for +crit in Naxx. I'll add a miss calc to the yellow hit mod in the next release.

Next version is out. Added a bunch of little stuff in this one, biggest one being merging the 2H and DW pages into one. Make sure to read the notes to see how to use it, and read the version control to see what was added this release.

http://www.savefile.com/files/9056225


I'm pretty happy where the spreadsheet is right now. I'll continue adding more things based on feedback and when new items come out. But now, I'm going to shift my attention to writing a java-based combat simulator.

What's the cooldown on Kiss of the Spider?

I think people are blaming the warrior dps problem on the wrong source. Yes, better gear means more white damage which means more rage. For while in your gear progression, that then means more yellow damage. But after you're hitting BT and WW on cooldown, and full bar execute when the mob gets to 20%, what else is there to spend your rage on? I'm nearing that stage already, as the jump from blues to MC gear is much greater any other gear progression jump. Your options after that is hamstring, cleave, and HS. HS is an obvious no-no, except in the most extreme cases(C'Thun phase 2, from what I hear). Cleave is purported to have a smallish threat bonus too, so until it's proven one way or another, I shy away from that unless there's 2 mobs to hit. Hamstring is your best option, since it has better damage/rage than single target cleave anyway. But just look at the damage/rage numbers on hamstring compared to BT, WW, and Execute. Basically, after a certain point, the extra rage gained from more white damage is being converted into very inefficient yellow damage.

So, where's the DPS coming from? Execute. I'm sure I don't have to point the damage/rage efficiency on execute spamming. I'm thinking of adding a separate field that breaks up the 80/20 model into 80 and 20, just so people can see what a difference execute makes. A fury warrior is ~100 dps behind combat dagger rogue before 20%. Quick and dirty solution I guess to put a somewhat lengthy cooldown on execute, 6 to 10 seconds maybe. Higher rage executes really kill the efficiency. But that said, I'd rather not see anyone nerfed, rather rogues improved. It'd be a shame to put all this effort into my warrior just to see his dps punked.

Lastly, this is a sort of a disclaimer. I'm not going to say my calculations are accurate. I will say they are at least in the right area, so you can use it as comparison tool between classes, and gear within the class. That's all I intend for this spreadsheet, to compare dps. I welcome and encourage anyone to unhide the sheets and look at the calculations(most are on the DPS sheet though), but I understand if most don't. Sometimes I go back and wonder wtf I'm doing in this cell. Excel doesn't help much either, it really isn't design to handle stuff of this complexity. That's why I'm building a simulator.

Is HoJ fixed in this version?

Also, Unyielding Strength items aren't updated with patch (ring wasn't atleast).

And, is it possible to calculate a DPS excluding execute?

Yeah, HoJ should be purple. It also comes into account for when a warrior has a slow mainhand and fast offhand, the fast offhand will still proc a mainhand swing, which makes it amazing. Your spreadsheet now helps to see which trinket is better given a specific configuration.

You also forgot to add the new WSG legs, but I figured out how to do it myself, just saying for your next release =).

Also, I have no idea how this would work as PvP is burst DPS, but is there a way to see what your DPS would be like on a player? Would you just put the enemy level down to 60?

1 more thing - Untamed Blade's proc doesn't seem to be taken into account anywhere.

Thanks so much for this, it's amazing, and I can play with it at work and it looks inconspicuous.

Burst dps in pvp is pretty hard to calculate. Most of the calculations use a long time base to smooth out any inconsistencies(string of misses, no crits for 20s, that sort of thing). You can shorten the fight duration on my spreadsheet currently, but anything less than 30 seconds and I will not guaruntee any type of accuracy. Additionally, PvE can be modeled because the fights are at least somewhat predictable. In pvp, there's a lot thing the other player could do that would screw up any kind of predicted dps, and there's just no way to account for an enemy player's actions without running thousands of scenarios.

Level 60 enemies doesn't work in my spreadsheet. The whole purpose of enemy level was to deal with a pve only mechanic, glancing blows. Doing level 60 would require a lot reworking of the formulas. I will keep it in mind since Thorb mentioned it too.

I'd suggest, if you're trying to determine which gear is better for pvp, you evaluate them in the same way this spreadsheet does for pve. Most of the time, gear that's better dps in pve is also in pvp. You'd then have to take into account things like +skill being overvalued in pve, and how much sta the gear has.

EDIT: ah, I hadn't gotten around to weapon procs. Mainly because there's just so god damn many. Anyone know where I can get accurate PPM or %chance/hit info on weapon procs?

Right, and you can kind of see it too. For example, Edgemaster's Handguards are the best gloves in the game for PvE DPS (test it out), but they'd suck in PvP compared to Flameguard/Annihilation.

EDIT: What about sword spec?

If you don't have the rage to keep both going you are probably doing something wrong or have terrible gear. But use WW first with a 2her or BT if you DW.

Cleave is a miserable dmg/rage. Either heroic strike, or hamstring spam. I've actually given up imp OP with my latest talent spec, so I dont switch to battle stance at all.

There are ways to manage your threat, and use heroic strike effectively. SS aggrowipe anyone?

Hadn't thought of an SS aggrowipe =)

Should be almost as fun as eating wing buffets and dodging shadow flame =D

If you're alliance, I can do you one better.

SS a paladin. When the paladin is OOM or after they burn LOH, have them DI you and SS themself back up. DI is an aggro wipe. You reset your aggro, and Mr. Paladin gets 2800 mana.

I think I'm having some OpenOffice lookup issues, but one thing I did notice about the sheet is your addition of crit to the 'White Hit Mod' formula. Currently, crit is added as just 'B35/100' (straight crit%) but doesn't include the crit chance modification of weapon skill vs mob defense. Not a huge difference, admittedly, but if you're making that adjustment for dodge chance, might as well for your crit chance.

I hadn't progressed any further on wading through your calculations, but this might be an issue with the 2H White Hit Mod and Yellow Hit Mod as well.

Otherwise, looks like a really nice spreadsheet. Thanks for the work on this.