US Rogue DPS Stats Spreadsheet

Recluse

Recluse

Grandfathered
It has been too long that we rogues argue over what stats are better than others. Some rogues like haste, some rogues like crit, some rogues like glass cannon. The BiS dream was on a per rogue basis, each rogue could only infer what that meant...

I am now pleased to provide you an excel spreadsheet which compiles all stats (Attack Power, Haste, Crit, Versatility, Multistrike, & Weapon Damage) which can be manipulated by you to determine your true BiS.

Please download from the dropbox links below:

Combat Rogue DPS Stats Spreadsheet (v 1.03)

(Edit 1: Replaced Damage Reductions with Min / Max DPS - easier to read DPS calcs. Max DPS is calculated if ALL damage crits and multistrikes)

(Edit 3: Poisons can proc off multistrike)

Assassination Rogue DPS Stats Spreadsheet (v1.01)

(Edit 1: Per request, slice and dice is always active)


WARNING: When downloading these spreadsheets, you may have to turn Iterations on. Please go to File > Excel Options > Formulas > & Enable Iterative Calculations. Sinister Strike & 5pt Eviscerate / Mutilate & Envenom depend on this.

**All stats in yellow can be manipulated by you.** These values are applied to all attacks (Ambush, Revealing Strike, Sinister Strike, Mutilate, Envenom, 5pt Eviscerate, Melee Damage, Deadly Poison, & Elemental Force) over a certain time duration.

All Combat Rogues will follow the same standard rotation: Ambush, Revealing Strike on cooldown, Sinister Strike until 5 combo points, Eviscerate, repeat.

All Assassination Rogues will follow the same standard rotation: Ambush, Mutilate x2, Envenom, repeat. It is assumed Slice and Dice is always active, but you could remove the *1.4 from MH & OH Melee Hits and the 8 *1.4 from the # of Deadly Poison Ticks if you wish.

Combat duration and haste will determine how many times you can cast each move. It is assumed Nightstalker is your chosen talent for both spreadsheets.

Both spreadsheets are an average calculation of all moves. Critical Strike and Multistrike are applied to DPS as a complete average percentage. Deadly Poison and Elemental Force are calculated the same way. The time between Elemental Force procs is a 50% chance calculation. It is assumed Elemental Force is enchanted to both weapons.

Weapon Normalization is a stat that depends on your MH Weapon (Dagger / Sword). If you should want a dagger as your MH Weapon (for the Combat Rogue Spreadsheet), please change this value to 1.7 and times Ambush by an additional 40% (because a dagger is equiped). The Assassination Rogue Spreadsheet already assumes this.

Obviously the DPS shown in these calculations seem higher than what you may see from Skada or Recount. Please take into consideration that after your last melee damage or damage taken, it takes ~6 seconds to remove yourself from combat (which would hinder your DPS). Also consider physical damage reductions and your imperfections at real time pvp.

ERRORS IN DESIGN: There are, of course, a few errors when I created these spreadsheets. Some I could work around, others I could not, and some are just too damn complicated for me to try and think about. THE LARGEST ERROR with the Combat Rogue Spreadsheet is the extra combo point that could be applied from a sinister strike while revealing strike is active. I have no freaking clue how I could show this in an excel file, please understand. OTHER MARGINAL ERRORS with both spreadsheets would include wrongly shown Tooltip DMG. The maximum amount of error in these calculations should only be plus or minus 1 damage. I figure this is due to weird WoW rounding, but should still be close enough to its average damage for it not to matter too much. The only spell that differs is Envenom. If you should wish to calculate Envenom outside BG, please change +8 to +4. I really don't know why this is, but it holds true from my tests. Envenom calculations from Wowhead are quite insane. Deadly Poison will also be one that deviates, but the formula was taken straight from Wowhead. Envenom will increase poison proc by 30% for the 5 seconds after it's cast. Also, I do not believe Elemental Force scales with attack power, but it does have some sort of damage range and can increase with versatility and other damage increasing buffs. Elemental Force was also taken straight from Wowhead. If you should find any other errors, have any questions with this spreadsheet, or tips for improvement, please ask and I will try my best to respond or even update the spreadsheet.


Thanks & Enjoy
 
Last edited:
Used it for my Glass, your set and also a pure crit set.

ECpyMCx.png
Balanced. (Shadowleather on legs, not primal from LW)

Njwgt7G.png
Glass

NDNC7aD.png
Crit

Gj Recluse!

Agility is taken from a Undead so 18 in base.
 
Last edited:
Try setting Combat Time = 135 / Energy Regen. This will give you the DPS of an Ambush, Revealing Strike, Sinister Strike x 2, and 5pt Eviscerate. If you plug in fat numbers like 10 or 11, Haste wouldn't be shown to be as effective as Crit or AP. Also try setting Combat Time = 420 / Energy Regen. This will let you cast two 5pt Eviscerates.

Combat Time needs to be a function of Energy Regen for a proper comparison of Haste to Crit to AP, but this is just my two cents...
 
insurgent said:
Not gunna question the math...just gunna trust it.
Click to expand...

The math should be mostly correct. You can check the Tooltip DMG to make sure I'm right, or check the Combat Time Stats and make sure Sinister Strike and Eviscerate is cast when you have the right amount of energy (which should also be correct). The only crazy calculations would be with Deadly Poison and Elemental Force. DPS is a large calculation, but it's just a sum of the Combat Time Stats multiplied by their damage. Crit and Multistrike are added to the final DPS, which makes it look like a long formula when it really is not.
 
Very handy spreadsheet thanks for letting us all see.

Something seems a bit odd with haste though. Am I right that if you put your stats in as having all Gift of Haste enchants, it says you will do significantly more DPS than all Gift of Verse?

I understand that ele force (and poison?) procs increase with haste so you gain something there. 10% haste would mean 11 RPPM of ele force instead of 10. Not an enormous dps boost over 10 second combat time. Idk I should have a closer look before posting but Im bging atm. x)

In your formula for 'AVG # of Elemental Force Procs:' where does the second "*2" come from? The first I assume is because ele force on *2 weapons. 8 ele procs in 10 seconds seems a lot? Idk hehe.
 
Pixel said:
In your formula for 'AVG # of Elemental Force Procs:' where does the second "*2" come from? The first I assume is because ele force on *2 weapons. 8 ele procs in 10 seconds seems a lot? Idk hehe.
Click to expand...

Nice! Thanks for looking deep into my calculations. This is exactly why I posted it on this forum... lol.

The extra *2 would be your 50% proc rate on Elemental Force. So with 10% Haste, Elemental Force could proc anywhere between 0 - 2.73 seconds. I figured dividing that maximum time by two would give you an average value of when it could proc. Over a 10 second fight you would have roughly 12 or 13 melee attacks (including special attacks), so it's entirely possible to have 8 Elemental Force procs in that time period. But this would also depend on how your attacks are spaced out time wise...

So instead of figuring up the time in between special attacks & melee attacks, I just divided the combat time by that 50% value and said "Meh it's close enough."

Maybe this value should be tweaked, but I haven't compared Haste to Versatility yet...

What do you think?

Also, Deadly Poison has a base 30% chance to proc, so it only depends on how many times you can melee & special attack
 
Last edited:
@Pixel

As of right now, Elemental Force is taken as an integer rather than a whole number. With 10% Haste and 50% proc rate, you would have 7.33 procs over 10 seconds. Though the last Elemental Force would only have a 16% chance to proc in that 10 second time frame, the 0.33 proc will be multiplied by the Elemental Force Tooltip DMG, which is semi-consistent with total average damage. Even though this isn't how it truly is in BGs, I don't see a better way to do this....

Elemental Force is a b*tch!

Also THIS BLUE POST will tell you how to calculate Elemental Force RPPM.
 
Last edited:
Recluse said:
Also THIS BLUE POST will tell you how to calculate Elemental Force RPPM.
Click to expand...

Yeah I've had a look through that. It confuses me because my interpretation of 10 RealProcsPerMinute is exactly that..... yet we are seeing 3.33 procs in 10 seconds or 20 procs per minute per enchant before haste.

Your method of 50% proc chance time seems ok to me (although that's where the 20 ppm is coming from?). Your working there is a bit hard for me to follow so I redid it in my own intuitive way and got the same result. I also tested in game on target dummies and with 10% haste could get 8 ele procs in a ~10 second period so you can't be far away. As long as it's close enough then the effect of haste on ele dps will be roughly in the right ratio of total dps.

I tested the Combat Time Stats with a basic model of my own and can replicate your results exactly. There can be a situation where it needs to refresh RS and so takes away the SS in the previous second but that's all sweet, it gets back to where it needs to be.

Also I think multistrike has a chance to multistrike off 1st multistrike and multistrike again off 2nd multistrike, so three potential chances. Not sure if that's still the case. Most of us don't have any MS anyway.

I'm surprised how good a bit of haste can be. Gotta be careful how you interpret the results though. I'm not ready to start swapping all my gear but I'll look at picking up as much cheap haste as I can. Foreman's Gloves are a must have imo.

I really like how the model moves through time, it's fundamentally simple but pretty complex to make it work for a rogue. Top job and thanks for sharing.
 
Pixel said:
Yeah I've had a look through that. It confuses me because my interpretation of 10 RealProcsPerMinute is exactly that..... yet we are seeing 3.33 procs in 10 seconds or 20 procs per minute per enchant before haste.

Your method of 50% proc chance time seems ok to me (although that's where the 20 ppm is coming from?). Your working there is a bit hard for me to follow so I redid it in my own intuitive way and got the same result. I also tested in game on target dummies and with 10% haste could get 8 ele procs in a ~10 second period so you can't be far away. As long as it's close enough then the effect of haste on ele dps will be roughly in the right ratio of total dps.

I tested the Combat Time Stats with a basic model of my own and can replicate your results exactly. There can be a situation where it needs to refresh RS and so takes away the SS in the previous second but that's all sweet, it gets back to where it needs to be.

Also I think multistrike has a chance to multistrike off 1st multistrike and multistrike again off 2nd multistrike, so three potential chances. Not sure if that's still the case. Most of us don't have any MS anyway.

I'm surprised how good a bit of haste can be. Gotta be careful how you interpret the results though. I'm not ready to start swapping all my gear but I'll look at picking up as much cheap haste as I can. Foreman's Gloves are a must have imo.

I really like how the model moves through time, it's fundamentally simple but pretty complex to make it work for a rogue. Top job and thanks for sharing.
Click to expand...

RPPM gives you a greater likelihood of procs in the beginning of a fight, which leads to more procs occurring in the start of the fight and then levelling off toward the base 20 rppm (10 rppm per elemental force enchant, modified by haste).

Multistrike is only one chance in PvP unless something has changed in the past year or so since I haven't paid too much attention to WoD changes. source: https://twitter.com/WarcraftDevs/status/535248820423380992
 
@Pixel

MH & OH Melee Damage was not being multiplied by Versatility. I had kept them separate in the Tooltip DMG for people to check and make sure I was right, but then forgot to add it to the final DPS calculations!

Haste should no longer be better than Versatility.

:)
 
AlbinoCow said:
Lets get a assn spread going since u got most of the same formula's. even a sub one if u got the time
Click to expand...

An Assassination Rogue DPS Stats Spreadsheet is posted as you requested! However, I probably won't be making a Subtlety Rogue Spreadsheet....

:)
 
Interestingly enough, 1 AP = 0.50% Crit = 0.25% Haste. This depends on how much AP you have though, as you get more AP it takes less crit and less haste to match the damage.

4 AP : 2% Crit : 1% Haste is a pretty close, general ratio.

Someone just needs to tell me how much Crit / Haste rating = 1% ... =P
 
So 2 AP = 6 Crit = 3 Haste ?
 
AntiStealth said:
Okay this might be completly wrong, but if you visit wowhead.com and you check http://www.wowhead.com/item=52671/bahrums-bad-mood-ring for example, if you press the crit strike you can change the scaling in rating > %.

Acording to wowhead then, 1 crit rating would be 0.18% in level 29.
¯\_(ツ)_/¯
Click to expand...
Just gonna point out that wowhead is inaccurate for a lot of levels. And why would you even use wowhead when you can go in-game and look how much crit you have?

crit rating / crit % (minus passive boost) = what you want to know. Same for haste.
 
You must log in or register to reply here.

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
Top