mih

http://rogue.raidcal.com/
2.2.0.9 (mih)
fixed
AEP buffed AP calculation
Ringlist
Warglaive of Azzinoth OH (hit -> crit)
Unbuffed/Buffed Evi cycles

changed
Arcanite Steam-Pistol
Claw of the Phoenix
Fang of Vashj
Heartrazor
Rod of the Sun King
Serpent Spine Longbow
Serpentshrine Shuriken
Talon of Azshara
Talon of the Phoenix

 

Stabmaster

I get #VALUE! invalid calculations in the buffed DPS fields when Windfury is enabled on the mainhand enchant. Changing it to Instant Poison or anything else fixes the problem.

 

dhegin

When opening a fresh copy of 2.2.0.9, there is an error in "Other DPS" which leads to an error in "Total DPS." I've redownloaded it a few times and still have the same error upon opening. Is there anything I can do to fix this? Thanks in advance.

EDIT: wow, got beat to it, thanks for the quick fix though, Stabmaster.

 

Thousand

I get the same error. And it still doesnt provide me with the dps difference, and the AEP calculations are only working for unbuffed column right now. Also, if you have windfury selected and get lack of values, the upgrade macros do not function properly either.

 

Asherett

Bug: Blackout Truncheon is not correctly entered, the sockets (and corresponding bonus) is missing.

Suggestion: Possibility to choose "Any" in field Y44 and Y45 (Weapon equip options).

 

Mikhael

To Fix Windfury (which is bugged in 2.2.0.8 also), the Expose Weakness line needs to be fixed. In cell Wep_Enchants!R33, change the reference from Gear_Buffs!$B$107 to Gear_Buffs!$C$108. Also, in cell C108 on the Gear_Buffs sheet, enter either 0 or the agi of your survival hunter.

*edit*
Non zero agi values in this cell seem to increase dps by a ridiculous amount...100 agi is a 1357 dps increase, which doesn't seem reasonable.

 

Sekkyo

Same. Anyone know the fix?

 

Ariel

To fix the #value error for Windfury, it seems like the formula for imp weapon totems was broken. The formula in B107 should be 1+C107*0.15

Also, it seems like the sheet is still using instant attacks in the formula for Windfury Totem. I believe that can be fixed by updating Wep_Enchants!R32 to

('Buffed DPS'!$Q$14+'Buffed DPS'!$Q$19)*0.2*R28

And also update NextStat!O100 to:

IF(O$12>0,(O97+(O96+O97+O99)*'Buffed DPS'!R12+O95*'BuffedDPS'!R13)*0.2,0)*(I98+I99+I100)

This assumes that extra attacks from sword spec can still proc Windfury.

 

Doink

You forgot a space in the seconds 'Buffed DPS'!R13 in your forumula, and anyone who doesnt use excel regularly may be confused so this is the corrected formula :P

=IF(O$12>0,(O97+(O96+O97+O99)*'Buffed DPS'!R12+O95*'Buffed DPS'!R13)*0.2,0)*(I98+I99+I100)

 

Sekkyo

Yeah, I had to add the = sign in front of all of your corrections, Ariel, and then it worked perfectly.

Thanks all.

 

Doink

Mikhael the reason for the expose weakness problem is that you changed the reference in Wep_Enchants!R33.

Do NOT change the B107 to B108 in the cell, you have to change Gear_Buffs!$B$107 to =1+C107*0.15 as Ariel said earlier. In the latest release, this was changed to 1,3, which is where the WF error is coming from. Changing the reference in Wep_Enchants!R33 from B107 to B108 multiplies the WF attack power bonus by your hunter's agility!

 

Mikhael

Ah, thanks...I just left it at 0 and figured someone smarter would figure out what I did wrong

 

reknaw

I am not entirely sure this is where I should be posting this (my first ever post here), but I did some calculations regarding combat potency and hit% vs crit% to see how they compared. I couldn't find any posts covering this topic, apologies if there is one already.

There are two major factors not covered here: application rate of poisons, and “chance on hit” procs.

I am assuming that we have 5/5 Combat Potency, 5/5 Precision, hit rating higher than the one-hand miss rate but lower than the dual wield miss rate. Firstly I’ll focus solely on white damage, showing that increasing hit by 1% is exactly the same as increasing crit by 1%.

We know that hit% + crit% + miss% = 100%, and increasing hit rate decreases miss rate, while increasing crit rate has no effect on miss rate. Look it up. It’s true. So a HIT is in fact only a move that neither missed nor crit.

Ok so let’s say that your hit% from gear is H, crit% from gear is C, your base chance to miss is 19%, and your average weapon damage is D.From that it should be fairly obvious that increasing either H or C by the same amount has the exact same result. Therefore we can ignore white damage completely when determining the affect of hit vs crit on overall dps.

Now that that’s out of the way we can get on with yellow damage.

The affect of hit percent

The last thing I want is to turn this into an argument about Sinister Strike and Backstab, so I’m not even going to mention either when working out the affect of Combat Potency on yellows. Instead I’m going to say that your entire spell rotation has an average total damage caused, divided by the total energy cost (including Slice and Dice) to give you your yellow damage per energy or DPE. Over any given period of time, the yellow damage you deal is your DPE * (amount of energy generated). Increasing hit percent wont change your DPE since we are already past the hit cap for yellows, and as such the only factor we need to consider is how much more energy we generate over any given time.Let’s assume that we have a 1.3s dagger in the offhand, and Slice and Dice is always up, so we can say S = 0.91s. Solving this for every value of H gives..This is at most an increase in yellow damage of 0.28% for 1% increase in hit percent.

The affect of crit percent

Increasing crit by 1% does nothing more to yellows than increase the amount of crits by 1%. This is complicated by the fact that not every spell can crit (such as Rupture), and due to Lethality, not all crits increase damage by the same amount (e.g. Evicerate crit is 2 * D, Backstab crit is 2.3 * D).

Ok so as before we should talk in terms of damage per energy for yellows, and since our hit percent isn’t being changed here the amount of energy we generate won’t be changing either. Therefore what we need to calculate is how much more damage we do for each percent of crit added.

There are three different types of yellow we need to consider: Moves that are affected by Lethality; moves that are not affected by Lethality; and moves that can not crit at all.

Lethality
Crits do 230% normal damage. The hit cap for yellows has been passed already so we can assume there will be no misses.Changing our crit chance will have no affect on the average non crit, so we can say that our damage per energy will increase only as (1 + 1.2 * C) increases.

Choosing a range of crit chances to test this over of 20% to 50% (I’m assuming no one will have lower than 20% or higher than 50% crit) we get:Non Lethality
This will be the same as Lethality with the exception that crit damage is 200%.Which gives...Uncrittables
These won’t change at all no matter how much crit you have, and so the increase percentage is always 100%.

Combining the Crits
The best I can come up with to combine the crit increases so far is to have the person find out what percentage of their total yellow damage each type does at their current crit rate.Then increase the crittables by the Increase% of the next crit% in the tables we worked out earlier.Let’s say for example that our crit is 30%, and that our spell rotation breaks down to A = 0.5; B = 0.2; C = 0.3. We would have:Rather than work out a lot of different tables of data for every combination of A, B and C, I’ll just look at the worst case that could reasonably occur: No moves are affected by lethality, and more than half our yellow damage comes uncrittable moves. Since this is a worst case I’ll assume the person’s crit rate is already quite high, say 45%. The point we need to find here is where the increase% falls below 100.28 (i.e. the best case for hit)So given the worst possible spell rotation for crit, uncrittbale moves would have to account for at least 60% of your yellow damage in order for hit to give you more of an increase than crit.

This goes against 90% of what is said about rogue dps, so what I’m mainly after from posting this is to have people find any flaws in my assumptions or in my calculations.

EDIT: Yeah dunno why but I worked all this out with Lethality being an extra 20% dmg rather than 30%, fixed now.

 

elegy

I believe you are not doing the same rotation at different hit rating, therefore your 'DPE' is not the same. And, I believe when saying hit vs crit, we're taking in account hit rating and crit rating, not %.

 

reknaw

Oops yeah I'd used the word rating in many places where I should have used percent, editted to fix that.

I see your point about using a different rotation depending on what stat has been stacked, has given me something to think about.

 

WibbleNZ

The spreadsheet agrees with you: 1% crit is a larger dps increase than 1% hit.

But for the same budget (or bunch of gems, say) as 1% crit (22.1 crit rating) you can get 1.4% hit (22.1 hit rating).

 

Stock

So basically im in a dilema. imdebating on 2 pieces of gear and 2 kind of stats. (Not adding enchants, just gems), all stats include the agi to AP to Crit conversion with gems/bonuses. I didnt factor in what the stats are with the +weapon skill rating because i honestly don't know what to believe from everything i read.

-Choice 1
Bladed Shoulderpads of the Merciless (24Hit rating with 2x Glinting Noble Topaz, 25 Crit Rating, 66AP)
Netherblade Gloves 17Hit rating, 25 Crit rating, 72 AP

overall:
-138 AP
-41Hit rating (2.59% Hit)
-50 Crit rating (2.37% Crit)


vs


-Choice 2
Shoulderpads of the Stranger (36 Crit rating, +10 weapon skill rating, +4 hit 1xGlinting Noble Topaz, 99AP)
Grips of Deftness 15Crit rating, +15 weapon skill rating, 89AP

overall
-188AP
-4+Hit (0.25% Hit)
-51+Crit rating (2.4% crit)
-25 Weapon skill (+6 weapon level)




This idea is mainly for boss fights.
Since i have combat potency(+10), i would be at +16 Weapon skill Level with Choice 2. making me pretty much a lvl 73 mob. my theories around DPS always derived from, "what if i was a higher level mob myself?", and still i clinch to the pre-BC morals of pve stats for rogues. thus bringing into the equation, is weapon skill JUST looking at a measly .1% increase per level? ive read so many forums and numbers, but im still not sure what is the dominant factor on Boss fights, i need some help in my decision, please. Which choice should i stick to.

 

sp00n

Why not Shoulderpads of the Stranger + Netherblade Gloves?
That is what I would do.

And then some notes:
1) We simply don't know what weapon skill does right now, besides the effects on hit, which have been almost found out now (see the appropiate thread for more information). The spreadsheet currently doesn't use the right formulae for weapon skill (which is mainly due we still haven't figured them out).
If you are already at +10 weapon skill through Weapon Expertise (and not Combat Potency where I think you simply mistyped), 1 weapon skill (not rating) should give you 0.1% to hit. Fractial weapon skill isn't taken into account, so the Shoulderpads of the Stranger give only 2 weapon skill (but shoulders + gloves would indeed give 6 skill).
For dodge it is maybe as well 0.1%, maybe not.
For crit, it is totally unknown except the statement we have from Blizzard that it increases the 'crit rating by 1% against higher mobs'. Whatever that means.

2) Lethality increases the crit damage by 30% and not 20%.

3) Crits on special attacks are currently believed to be under a two roll mechanic, meaning that the crit rate will not match your real crit rate. You will have to account for the 5% (or more, unknown so far...) dodges and possible parries/misses (if applicable) to calculate your crit rate for specials.

4) The spreadsheet is quite accurate, despite the lack of the real formula for weapon skill and some other minor issues. I'd simply stick with the recommendation it gives you.

 

Steve75

hi,

maybe i´m stupid or blind, but

where in the sheet i can switch from swords to daggers?

I only have the choice of Swords in the sheet, talent build i made is dagger-specced

Greetings Steve

Edit: found it XD

 

Devil Warrior

One of the big things I notice about Weapon Skill is that my % of hits Dodged by enemies is usually lower around 4.5% on average when the spreadsheet says vs boss mobs my % dodge should be somewhere around 4.95%. Noticable enough in the long run.

 

Stock

how much weapon skill exactly did you notice this with? including weapon expertise.

 

Zurgat

Is 2.2.0.10 planned to be released by Ellos / Mih soonish?
As was pointed out a week ago there's a nasty bug which causes the buffed dps to return "#VALUE!", effectively making the current version of the sheet unuseable. Though i'd still like to experiment with the haste rating changes.

-= Random Ravings - RSS Feed =- Rogue and Hunter stuff here. As well as guides to get you trough your spare time.

 

lijana

I had the WF bug aswell when exporting/importing the settings from my older (2.2.0.8) spreadsheet. However, opening 2.2.0.9 and starting fresh didn't give me any errors.

 

LiteSabre

I finally got 4pc T6 + vashj belt the other day, so I decided to try combat mutilate this week now that we don't need every single ounce of DPS the raid can squeeze out, and I got over 355 weapon skill without WEx.

So here's the question: what trinkets to wear?

I know the DPS spreadsheet theoretically has the answers, but IMO it models most of the trinkets incorrectly particularly the ashtongue trinket) and I can't really trust it.

In the current incarnation of the DST, is it still better for combat mutilate than the WSC? My gut tells me that the ashtongue talisman is on par or superior to DST with a mutliate build (4+ point finishers up the wazoo) but I'm not so sure on the WSC. The Coil has two seperate chances to proc on each mutilate, which to me makes it seem pretty good.

 

Wodahs

If I download and open the 2.2.0.9 sheet, and go to the gear and buffs tab, my buffed 'other dps' 'total dps' and 'difference' fields are ####### errors, so I dont know how you have anything different.