Bug:

For the last few versions of the spreadsheet the Balanced Nightseye has been listed as an epic instead of a rare quality gem.

I manually entered the items. I didn't import anything.

EDIT: I tried everything now, but still can't find the bug, sorry.

My build: The Armory

Sample Void Reaver Damage Summary (No Shiv spam possible as he is immune to poisons.)
Raid Damage Summary
Dogbert

Sample Magtheridon Fight (Using Shiv spam in the method I described above. Note the fact that I got twice as many Combat Potency procs as I did without Shiv. This is it's major draw.)
Raid Damage Summary
Dogbert

Note the dps is fairly identical between both methods. It's a substantial increase in some encounters though. At very least, an equal alternative.

Sidenote: For Shiv spam dps methods, GoA with Deadly Poison on MH > WF.

PS: When it comes to dps, I just don't do "horribly wrong." I show up as best I can and execute to the fullest with the tools I'm given. I'm not the best, but I Know what I'm doing.

I'm currently working on swordspec.
Could anyone please test something for me?

I need:
Maindhand speed, Offhand Speed, Average time between Swordspec, used instants and used cycle.

I need this data, so that I can check if the value for the swordspec extra hits is correct.

Okay no need anymore, got some values for testing.

The likelyhood of this still being interesting when you get a better MH is quite low.

I'm also not sure how you can maintain 5 stacks of Deadly poison on your mob unless you are somehow using it on your OH too. Seems you must have under 25% to ever getting to 5.

Point taken Elegy. Once I get Talon of Azshara, I'll most likely revert to SS spam. At present though, this is working very nicely for me.

And you're right, I often don't have 5 stacks of Deadly when it's time. In that circumstance, I typically use Eviscerate or I refresh Rupture depending on how long is left on the current Rupture. The benefit of a ticking Deadly almost always up though is greater than WF proc rate vs having GoA up. This only applies to Shiv spam though.

Every time I toggle Mutilate to Yes, I get a #Div/0! error and nothing works. Edit: for some reason it's working now, not sure what I did or what the problem was.

A little surprised that Whispering Blades of Slaying and Insignia of the Mag'hari hero were left off.

Don't see any bonescythe either.

Also, how do I look at your calculations for cell H4 (avginst) or instatk? Not that savvy with excel.

Oh, and how can I add items to the lists?

I cant select the "Merciless Gladiator's Left Ripper", anyone else got that problem?

Will be fixt in next Version

From the FAQ:
Q: How do I add new items to the gear drop-down lists?
A: If you happen to be using an item that doesn't show up on the dropdown list, you have to unhide the sheet for that particular slot. To unhide a sheet, go to Format>Sheet>Unhide… (in Excel), and select the item slot you wish to add the item to. Then add in the name and stats to one of the blank rows, and it will now show up on the dropdown list.

Avginst is in (un)buffed cycles

But look clearly how to add in Item, it's maybe not that easy

The blade is in there, but there is a little.. well bug I should say which causes a problem, will be fixt in next version.
The Insgnia I'll add I think.

In the actual version (.12) I cannot select anything else than daggers.. is this intended or a bug or am I just too blind to see how I can select e.g. swords or maces?

I "specced" maces and swords as well, but I still only can select daggers as main- and offhand weapons... confusing.

Oh god, i'm using the spreadsheet long time ago, i've never hat to select the weapon type. My last version didn't has included this feature, so I didn't expected something like this. And I scrolled a few pages back and didn't recognize something about this. Looking on the first page is a pretty damn good idea, why the hell I do not get this idea by myself?

[lfg] Arcane Brilliance IRL...

sorry.

Hi it's really a good job.

I just hav a little question , is it possible to add the Hand of Justice
I wanna try it on the Spreadsheet.

Thank's

How accurate is the Shiv model in this version? I haven't looked in the spreadsheet for months but I know the one I was using back then didn't model Shiv so well.

The reason I ask is because I can actually see a DPS increase if I move some talents around and check Force Shiv... Is it accurate? If it's not accurate, do you think it's too high or too low?

The only point at which shiv is good is when you have CRAPPY gear. As in.. "I just hit 70 and use Ced's Carver and greens" crappy. Spamming shiv with instant poison, a fast offhand and both poison talents can then be competent. Pretty much any point in gearing after that and shiv-spam just isn't viable anymore.

Think about it this way:
Most of you dps is white dmg - doesn't matter what instants you use as long as SnD is up.
Shiv is your offhand and thus incurs the offhand penalty - this takes off more and more damage as your gear scales up.
Shiv gets an instant poison proc - this gives you a static dmg boost, regardless of gear level.

It has been tested, modeled, etc. and proven inferior. Just like Envenom on a mob with 12 or more seconds left to live.

*shrug* it's situational. Sure, Shiv spam is bad DPS. So don't do that. But on interrupted fights, it's nice to have the reassurance that you can refresh the DP stack as soon as you move back in rather than risk it dropping. I'll take the fractional loss of damage in return for the knowledge that I won't be getting bent over backwards by the random number generator. Similarly, it's a nice low-aggro move to use for the first couple of hits of a fight, to build up the DP stack while letting the tank get a head start on threat.

Very much like Envenom. Both are situationally useful, well worth an action bar slot, and get a lot of unjustified flak from the peanut gallery who seem to think that an rogue's entire raiding life consists of long tank'n'spank fights with 100% time on target.

In the case of Envenom, it's worth pointing out that on trash fights, pretty much every mob you're using a finisher on has less than 12 seconds to live.

(And yes, I know that the whole point of these spreadsheets is to measure steady state DPS, but it does bear repeating that it's thus considerably divorced from actual raiding)

There are checkmarks on the right, below the apparently impossible to find MH/OH weapon dropdown, to indicate where your guild is raiding at the moment.

I don't have crappy gear, but I can still pull off better numbers on the spreadsheet by switching to Shiv. I'm not saying it will actually be this way in a practical situation, but the spreadsheet says Shiv is better. I'm asking how accurate the spreadsheet is, and if it's Shiv calculations are flawed, than in what way and how significant?

It's already there.

When I change from DP to Windfury on MH and OH to DP from IP, I get ##### on Buffed DPS and a decline in Unbuffed DPS.

Is this a bug, or?

Update: Same with Ashtongue Talisman when replacing Bloodlust Brooch

You will get a drop in unbuffed, because windfury on mainhand is considered "buffed" and is not considered at all for unbuffed.

It it says #### it usually implies the column just isn't wide enough, try making the column wider?

What are the thoughts of the PPM proc chances changing with haste procs?

I believe the spreadsheet currently implements PPM procs as a constant proc rate, regardless of haste rating, rather than scaling ppm to keep the PPM constant as has been shown the case in other threads on these forums. I can see this change having rather large effects on the balance of stats/items etc.