Just did some small testing on crit%'s as a Shadow Priest.

I made sure that I had 0/2 in Mind Melt.
I got naked so I had 0 crit rating and just my base 2.28% spell crit rate.
Attacked a heroic test dummy (noone else was attacking it).

I was still seeing crits on Mind Flay ticks.

If there's any sort of spell crit reduction %, it seems like it doesn't apply to Shadow Priests.

Edit: Given that resists are in 1/10th increments now instead of 1/8th as I believed.

4083 - ticks
2229 - full damage ticks
1267 - 9/10ths ticks
587 - 4/5th ticks

Giving a 5.9784% resist rate.

As to spell crit reduction, I have already established that the boss crit reduction is lower than 2.28%, so you should still see some crits. Nonetheless, the crits showing for the wound poison tests are still far below what one would expect if there was absolutely no crit reduction. The question is how many crits did you get in those 4000 ticks? And is that far below the expected 2.28% crit rate?

I'd say throw in an Evis. Out of curiosity, what is your dps loss from moving to a cycle that includes evis (such as 3/5/5 etc)? You might consider doing so for a more stable rotation.

I wasn't naked for the partial resist rate tests (mana wouldn't last too well if naked).
And I definitely saw more than just the 0%, 10% and a 20% partial resist bands. There was definitely a 9% and an 18.1% band in there too. Not sure why they were added though. But yeah, 6% partial resist rate seems right in general (not sure why SW:P is lower).

For the crit reduction test I was only trying to determine if I could a) see crits at just below 3% crit (was at 2.98%) and then if I could see them at 2.28% (the lowest I can test). Tested enough to determine I was seeing a few crits.

The 9% and 18.1% bands are interesting but I have to believe those are the result of some effect and they are actually still 10% and 20%. I'm definitely not seeing that with Wound poison where I have very tight single bands. It might be interesting to see what your crit rate looks like at a theoretical 2.28%. It has been long believed that this 6% resist cannot be reduced by talents or buffs of any kind, but one never knows if this has been changed (maybe when the last 1% was removed). So if your crit rate only looks to be around 0.2%-0.3% instead of the expected 2.3%, that would support the crit reduction theory.

---------

And latest results...finally got a crit (actually 2) at 99 crit rating

101 crit rating (2.2001%) - 1 crits in 1060 successful wound poison applications
99 crit rating (2.1566%) - 2 crits in 3667 successful wound poison applications

Now taking the crit rates from above and subtracting them from the known crit rates...
101 crit rating - Estimated reduction = 2.1058%
99 crit rating - Estimated reduction = 2.1020%

So, it's looking like 2.1% is the most probable spell crit reduction. This would mean that 97 crit rating (2.1130%) should still display a rare crit (1 in ~7684 successful applications) and 96 crit rating (2.0912%) should be unable to crit.

Over the last couple of weeks I've made changes to version 0.4.7 to update it for patch 3.1 and Ulduar. I think I've gotten it to the point where I can share it with the EJ community. It's not perfect but according to my testing it's fairly accurate. My intention for posting this is to learn through constructive criticism and possibly provide a tool for others while Vulajin prepares an "official" spreadsheet. I've typed up a full changelog to show my work so it's obvious where I made mistakes or bad assumptions. I've also included some questions that came up while I was working on these changes.

Download Links
The same spreadsheet is pre-setup for either Combat or Mutilate.

Works best with OpenOffice 3.0. Excel users see The Roguecraft Spreadsheet

Mutilate: http://rapidshare.com/files/21716486...duar_0.4.7.xls

Combat: http://rapidshare.com/files/21716485...duar_0.4.7.xls

ChangeLog

1) Instant Poison to PPM
I set the IP PPM constant as 8.5714*(1+0.5*0.2*tip+0.75*cycleenvbuff4) in DPS.T11 (where tip is talent Improved Poisons)
Calculated the MH proc rate using weapon speed in DPS.Q11: $Gear.N12*T11/60
and the OH proc rate again using weapon speed in DPS.S11: $Gear.N19*T11/60

2) Wound Poison to PPM
Set the WP PPM constant as 21.4285 in DPS.T15
Calculated the MH proc rate using weapon speed in DPS.Q15: $Gear.N12*T15/60
and the OH proc rate using weapon speed in DPS.S15: $Gear.N19*T15/60

3) Envenom to PPM
Envenom now works with PPM IP so see point #1. Changed DPS.T11 to 8.5714*(1+0.5*0.2*tip+0.75*cycleenvbuff4) where 0.75 is the increased rate to proc IP from the new Envenom buff.

4) Master Poisoner talent buff
Changed DPS.Q19 to 0.3+0.02*tip+0.15*cycleenvbuff4+0.45*cycleenvbuff4*tmp*1/3
to represent tmp (talent Master Poisoner)'s increased 45% chance to apply DP.

5) Deadly Poison AP coefficient buffed from 8% to 12%
Changed the coefficient in DPS.P27: =(296+B3*0.12)/12

10) New glyph: Mutilate.
DPSCalc1.G19, DPSCalc2.G19, and DPS.G23 changed to
(60*(1-0.05*t74pc)*(1-0.8*(G13+G14+G15))-5*gmut)/(1-G13-G14-G15)
where gmut is the Glyph of Mutilate defined in Talents&Settings.M21

11) New glyph: HfB.
DPS.B51 changed to
SUM(B39:B40;B42:B50)*(1+0.15*thfb+0.03*ghfb)*(1+bdmg)*(1+0.02*tmurder*OR(btype="Human oid";btype="Beast";btype="Dragonkin";btype="Giant"))*(1+0.05*AND(crace="Troll";btype= "Beast"))
where ghfb is the Glyph of HfB defined in Talents&Settings.M22

12) New functionality for Killing Spree and KS glyph.
To represent 20% increased KS damage:
DPS.L21 changed to (L19+L20)*5*1.2, DPS.M21 changed to (M19+M20)*5*1.2
To represent an average 20% increased white, poison, and proc damage during the duration of KS:
I've added *(1+0.2*2.5/(120-45*gms)*tms) onto the end of several equations, where 0.2 is the bonus damage, gms is the Glyph of Killing Spree, tms is talent Killing Spree, 2.5 is the KS duration, and 120 (75 glyphed) is the cooldown.
The affected equations are: DPS.B39 (MH DPS), DPS.B40 (OH DPS), DPS.Q12 (MH IP), DPS.Q13 (OH IP), DPS.Q16 (MH WP), DPS.Q17 (OH WP), DPS.P28 (DP average DPS), DPS.R2 (Bandit's Insignia DPS), DPS.R3 (Darkmoon Card DPS), DPS.R4 (Vestige of Haldor DPS).
For DPS.P28 (DP average DPS), I added *(1+0.2*0.25*2.5/(120-45*gms)*tms) with another *0.25 multiplier accounting for a maximum of one DP tick being increased by KS before it is overwritten.
To represent decreased cooldown on KS glyph, DPS.B45 is changed to:
(L22*mharmor+M22*oharmor)/(120-45*gms)*tms

This big mess is just that, and there is probably a more elegant solution. I did it this way because yellow attacks cannot be used during KS and therefore can't get the damage bonus.
Comment regarding KS: I don't believe the 10 KS attacks have a chance to proc their poison at this time.

13) Changed AR glyph, adding 5 seconds duration instead of decreasing cooldown.
Changed the first part of DPS.B41 (Build. Adj. DPS) to =(((((150+50*gar)/180)*tar)...
where 150 is the energy awarded from AR, gar is the Glyph of AR, and 180 is the cooldown.

14) Changed Lightning Reflexes talent to add haste and brought down to 3 points.
In DPS.C7, added to the end:
(1+B7/(hsbase*conv)/100)*(1+(0.4+0.05*t62pc)*cycleslice4)*(1+$'DPS Calc 2'.Q13)*(1+$'DPS Calc 2'.Q14)*(1+bmhaste)*(1+bhaste)*(1+(0.1/3)*tlr)
where tlr is talent Lightning Reflexes as defined in Talents&Settings.C55

15) Added all known Ulduar weapons and armor pieces including Tier 8 with set bonuses.

16) Implemented 2 piece bonus (energy return on deadly poison ticks):
Changed the first part of DPS.B43 to =(((((150+50*gar)/180)*tar)+(1/3)*(1-P20)*t82pc+...
where 1/3 is the energy gained every second, DPS.P20 is the chance to have 0 DP stacks, and t82pc represents tier 8 2 piece as defined in Gear.U19: COUNTIF($L$12:$L$94;"=Terrorblade")>=2

17) Implemented 4 piece bonus (rupture crits):
I assumed Rupture crits were affected by Relentless Earthsiege Diamond and Prey on the Weak and copied the crit modifier equation from DPS.K12 (Envenom) into DPS.I12:
2*(1+0.03*red)*(1+0.02*tmurder*OR(btype="Humanoid";btype="Beast";btype="Dragonkin";bt ype="Giant"))*(1+0.05*AND(crace="Troll";btype="Beast"))*(1+0.04*tprey)

Next I set DPS.I17 (Rupture crit) to:
C5*(1-I13-I14-I15-I16)*t84pc
Note #5: I'm not sure whether CQC would affect rupture crits. I assumed it didn't.

Set the DPS.I24 (Rupture damage multiplier) to I12*I17+I18.
Then added *I24 to the end of I25:I29, e.g. (580+0.06*B$3)*(1+2/4*grup)*I24 for DPS.I25.
Repeated the above in DPSCalc1 and DPSCalc2.
Note #6: I don't think Rupture without 4 piece crits is getting taxed twice by not being expertise capped (hit not 100) and then having a DPS.I24 multiplier under 100% using this approach; after comparing with an older version Rupture DPS is roughly the same. It's a possibility.

18) Savage Combat up to 4% increased physical damage.
Changed Buffs.D24 to =0.02*IF(AND(tbp>0;... from =0.01*IF...

PTR Testing

To make sure my spreadsheet was accurate I recorded some DPS parses on the PTR, then simulated the fight with the spreadsheet. I found that the current version is highly accurate. These parses were not intended to compare specs, and are not reflective of raid buffed conditions.

-Parses are 10-15 minutes long, 2-4 of them were averaged.
-Only self buffed, no debuffs from other players on dummy (Heroic boss level).
-Combat weapons: CG/WD
-Combat glyphs: SS, SnD, Rup
-Mut weapons: SR/WD
-Mut Glyphs: HfB, Mut, Rup
-Other gear unchanged

Spec...........Poisons..........Modeled DPS..........Observed DPS...........Deviation
15/51/5.......WP/DP...........3239.....................3211 (3)..................-0.8%
15/51/5.......WP/WP..........3162.....................3054 (2)..................-3.5%
18/51/2.......WP/DP...........3282.....................3303 (4).................+0.6%
18/51/2.......WP/WP..........3189.....................3252 (2)..................+1.9%
7/51/13.......WP/DP...........3245.....................3207 (2)..................-1.2%
7/51/13.......WP/WP..........3166.....................3086 (2)..................-2.6%
51/13/7.......IP/DP............3144......................3142 (3)..................-0.0%
51/13/7.......WP/DP...........3005.....................3033 (2)..................+1.3%
51/18/2.......IP/DP............3074......................3073 (2).................-0.0%
51/18/2.......WP/DP...........2950.....................2903 (2).................-1.6%

At this point I think the spreadsheet is "done" for 3.1, aside from adding some unknown loot tables. I would highly appreciate any feedback. Please PM me about minor issues. Credit to Vulajin for creating a great spreadsheet that's intuitive and easy to work with. Credit to Rallik for the armor penetration formula. Thanks to Armanewb for helping me with Excel basics. Thanks in advance for any comments and criticisms.

Awesome work - thank you.
I see that changing the offhand poison type in the Combat version to IP nets +5% increased total DPS (about +320dps). That is still in the current gear, so not counting the new DP set bonus. But it sounds quite significant.

The Lovecuddles sheet has an error in cell M28, seems like only half the cycle codes are implemented. Cells AQ45-71 don't recognise the codes for the mutilate cycles, I think.

I'm getting the same #VALUE! error as Rerox, and I'm also finding what's errors on the DPS tab's Envenom/Eviscerate cells (cells B47 and B48).

Eviscerate:
Envenom:
Unfortunately finding those errors is about the extent of my Excel abilities.

EDIT: Just took a closer look after Oscarvil's comment and it looks like only cycles with envenom/evis are getting errors.

EDIT2: Under the cycles tab lines 41 and 52 aren't occurring, at a glance it looks like something is causing envenoms and evis's to just not happen.

EDIT3: After much more trial and error and comparing it to Vulajin's it looks like the formulas in line 52 under the cycles tab is answering a calculation as a cell rather than a value when it's supposed to choose one of the values from K25-29 under the DPS tab (or J25-29). Of course, I really do have practically no clue how to work excel so I could be completely wrong, I've just been tracing tabs and cells to find out what I have so far.

EDIT4: Last one, I promise. I fixed the sheet, or at least it seems like I did. I just copy+pasted the corresponding cells from vulajin's version to the new one. As far as I could tell the equations are supposed to be the same so it shouldn't matter. You'll have to copy+paste for whichever cycle you're using but after that it should work fine. Thanks for the new sheet.

@ Rerox, Oscarvil, Darkshine

I didn't touch any of the cycles or anything regarding envenom and eviscerate. I think the main reason you're getting errors is because I'm using OpenOffice Calc 3.0 and you're presumably using Excel. One solution that might work is just to copy over the affected cells from Vulajin's original spreadsheet like Darkshine did. I know I had to do something similar when I first got Vulajin's sheet (he works with Excel). I'm not familiar with what's actually happening but the bottom line is the two programs aren't fully compatible. If you're using OpenOffice 3.0 (OpenOffice 2.x is no longer compatible since 0.4.7!) and you still get errors, please send me a PM and I'll try to track it down. Everyone else, I'd suggest re-entering or copying over the cells that have errors. Unfortunately I don't have access to Excel for testing.


Those are good points. I added the gems, changed the inscription and used profession-agnostic gear choices.

I fixed an error in DPS.P13 where Instant Poison on the OH was still using the mainhand PPM value. Changed DPS.P13 to
J33*S11*(1-P7)+IF(cpbuilder="Shiv";D33;0)*(1-S11)*(1-P7)
Replaced Q11 with S11. My mistake I never tested IP in the offhand. I went ahead and tested 18/51/2 WP/IP on the PTR is the result I got is consistent with the new simulated DPS.

I've uploaded a new version (v0.4) primarily to fix the IP error.

Mutilate: http://rapidshare.com/files/21625360...duar_0.4.7.xls

Combat: http://rapidshare.com/files/21716485...duar_0.4.7.xls

Finally completed version 0.5.0 of the spreadsheet! Download link can be found here:

Roguecraft Spreadsheet 0.5.0 LK

Changes in this version:

- Greatly reduced the complexity of the available options.
- Provided handy EP value readouts, finally!
- All items now link to their Wowhead info pages.
- All items now include additional information (handedness, rarity, etc.) to serve as a quick reference.
- Added a large number of additional items.
- Unfortunately, had to cut support for some options, like user-specified cycles and cooldown usage.

I think you'll all agree this version of the sheet constitutes a massive improvement over previous versions. As always, please report bugs and I'll release 0.5.1 to fix them ASAP.

Err.. the link leads to shadowpanther.net/armor-pve and not to the download whatsoever
1st April is over and you can only make jokes before 12.00 in the morning I heard
Also, you've suggested copying the affected cells from Vuljan's spreadsheet, but err.. they are exactly the same so after copying it doesn't help either, I'm still getting the #Value! error in both Mutilate and Combat spreadsheet
Also, when you posted your reports were you referring to 18/51/2 SHIV build and have you applied the shiv changes to it (the fact that it cannot crit etc.)? Is there any chance you could add a wowhead link to the exact talent build and say which weapons you were using? Could you add the 51/13/7 Eviscerate build with Webbed Death/Webbed Death IP/IP?

Thanks for releasing 0.5.0 Vulajin!

The new features are great. Wowhead links really make finding gear that much easier. And with EP values provided I can always tell what pieces are superior and by how much!

I'm thrilled you added additional items like Strength jewelry. I've often wondered how my dps would fare if I repaid all those jerks who steal my leather in full.

I think I've found a bug though: there's now no way to switch between Combat and Mutilate. What gives?! Please fix this in 0.5.1.

Is it just me seeing the link leading to shadowpanther.net? :P

I'm calling april fools.

Source: April Fools' Day - Wikipedia, the free encyclopedia

What's interesting is that using panther is not that far from using the actual spreadsheet in terms of finding best gear.

I could get it to work when I pasted the cells from the original sheet over the cells that showed the #value error in the cycles tab.
Clicking into each "error" cell in the cycles tab abd confirming the formula by pressing enter works too, but copy&paste from the original sheet is faster.

Really seems like a OO/Excel problem, since there is nothing wrong with the formula in these cells, you just have to "reconfirm" every single Envenom/Evis-dps formula.

just wondering if anyone else is having trouble matching the spreadsheet for combat builds...

on patchwerk
mut build, weapons, buffs, spreadsheet shows 4900 dps, and i get 4700, close enough
combat build, weapons, buffs, spreadsheet shows 4900 dps, and i get 4200, big discrepancy

i have looked over the wws. rng isnt a factor, neither is time to kill. my cycles are tighter on combat than on mut.

something seems amiss....

A few questions that come to mind...
1. Were your raid buffs and target debuffs the same between for both combat and mutilate?
2. Are you specifying the time for your use of cooldowns as combat?
3. Are you sure the fight duration on the spreadsheet approximates the actual fight length? I'm guessing that is what "neither is time to kill" means, but it is worth mentioning.

One more thing to ask, are you slime dipping? (even once in the beginning to get hp low?)

One minor thing I just noticed, the Shoulderpads of the Monolith is missing the yellow socket in it.