i just downloaded 2.0.5 and tried to plug in my gear, but when i got to the boot section, my [Boots of Utter Darkness] weren't in the dropdown selection menu. So i unhid the Boots page and was about to add my boots (thinking it a mere oversight)... and then i saw that my boots were indeed on that page.

So i figured i'd done something wrong, and of course i'd forgotten to tick the Craftable LW BoP stuff. But then when i went back to plug in my boots, they still weren't there. What's going on?

i tested out a theory. i tried to add my boots on a second line anyway, then on a third. Every time i added the boots and their stats, they didn't show up on the dropdown. In fact, they displayed as an empty, white space in the dropdown. So i tweaked one of them (not a direct Copy/Paste) to lie and say the boots were a drop from SSC. Still nothing. Is the dropdown not recognizing the LWing patterns somehow? Or does it just hate my boots? It's just odd.

Just keep up the great work guys. Thanks.

Just tested it, and in 2.2.0.5 it seems to work ok here.
If i enable the LW tick, the boots show up.
If i disable the LW tick, the boots are hidden.

The ticks for SSC / TK seem to have no effect on it.

The Boots should show up when Letherworking is seleceted (It works for me) when it not works, well you can write the name of the Boots into the cell and it will work.

When you want to Add new Boots, it's now a little bit more complicated than before. For cutting the dropdown list I need to sort the items.

Add the Boots normaly as you ever do this, add the Source where to get. Copy the cells in column U then you boots also have this formular. In Column V you hace to vount the maximum Boots (If you add one, you should at the next count and should deleted a empty cell when there is one) and of course you should add again the Formula to the new Cell in Column W. When its then not shown, then you must enlarge the matrix (Bootslist will it be in this case).

This was the only way to make it without a macro.

The Gems are even more complicated in the next Version

And maybe I should add again a loong loong Weapon list where all Weapons are listed it, then would'nt ask the half of the users why there are only Daggers in there.

I don't see anymore the "Deathblow X11 Goggles" helm :s

On the right side, enable the "Engineering" tick.

Just changed the notes on the Download page, when this won't be seeing, then.. I've no Idea anymore

As I said, my grammar is not the best

In the Spreadsheet it's only a DPS increase, no hasteeffect is added to the Hit/s.

Well it would give an error I think. So it should be added as 2% not as 21 Haste (then there weren't any problems).

You mean the mongoose haste effect isn't calculated currently?

Mongoose gives 120 agi (damage), and 2% haste while it's active.
If it's a flat %, it'd be multiplied by existing haste effects such a SnD, BF and the like.
If it's a rating(which i doubt), then it's added to the other ratings before being multiplied.
Working Theories of Theorycrafting as of 2.1
The difference would be "very" small since it's only 2% but should be worth looking into.

On that same subject, I see that (troll) berserking is listed as 7.5 haste, is it calculated in the end haste as a multiplicative % though, or as the haste rating that is displayed ?


As for the hit% accuracy.
I ran recap last night, and ended up with 1.9% miss.
The spreadsheet tells me i should have 1.93% miss, so you can probably count the deviation of 0.03% as luck. So it seems fairly accurate.


One more thing i noticed, the column "Proc DPS" lists the dps that each enchant gives.
Except for the Windfury buff, though this is considered a proc. Would it be possible to list the dps that Windfury gives in this column as well?

And another one: Misery, is currently listed as 1 rank, but it should be 5 ranks. 1,2,3,4,5% spell damage increase. (Does that work on poison?)

Oh yes, the Haste is calculatet, but not as Hit/sec to the cycles. Its calculated all in nextstat und gives a DPS Value. Well It's maybe not 100% accurate, but it should nearly enough on reality.
And I think there will be problems to add the haste directly into the sheet because:

You need the Hit/s to calculate the procchance of Mongoose, then you get 2% haste and the chance you get Mongoose is higher, but excel can't do such calculations.

I've changed the Racials in the next Version. There will ne an Option where you can take them into the calculation (only Troll, Orc, Blood Elf). The Troll Racial I've changed to: 20*hasterate*10/180

Means, 20% Speed increase * hasterating * time / Cooldown

also I've added the Energy loose. Well, don't know which speedincrease is normal so I set 20% because its in the middle of 10 and 30%

Sounds good

I think I'll let it this way. The problem is, windfury is a buff, when I'll add this to the column, than it will be calculated for unbuffed as well and I'll have to make extra calculations which aren't as accurate as it's now is.

Yes works on Poison, will add the 5 ranks next release.

The next release will take a little bit time, for now I had changed and Add the racials, unique Gems only can be selected once per Equip and you can choose which DPS you want to compare in the Upgrade Search.

I'll see if I can make some other Macros work a little bit better.

Nice, i'll keep you busy though

Putting in the gear and talents of one of my guildies.
[Band of Anguish], seems to be missing from the rings list. It's a quest reward.
[Blackhand's Breadth], could still be nice to have available as trinket.


Encountered an oddity with "Ruthlessness" : http://www.mediafire.com/?9i1j3t6cy1j
At 0/3 the damage is as shown in the XLS file above.
At 1/3, nothing changes. Which is ok.
At 2/3, nothing changes.
At 3/3, unbuffed dps goes "up", this is good. However, buffed dps goes "down", this should be impossible.

Looks like at 3/3 it switches the buffed dps cycle to 3s/5s/5r, even though this is less efficient than "5s cut".

Finally having taken the time to give this awesome spreadsheet a closer look, I noticed that the gear recommendations differ from the ones listed in the Max DPS List at Shadowpanther, which I have been using so far.
Now, being no star among the theorycrafters, I so far couldn't figure out which one uses the "better" formulas, and in consequence, which one I should use when picking my gear.

Am I mistaken when I view the goals of both the spreadsheet and the gear list at shadowpanther as the same, maximising raid dps?

I think I got the reason:

The cycle DPS IS higher, well it's only around 0.5DPS but it is higher.

The problem is, Procs are calculated after the cycle is choosen.

With 5s you got a higher SnD Uptime as with the 3s/5s/5r. With the second cycle there are around 10 seconds without SnD up and this time you got less procs. So these less procs are DPS loose enough to make the cycle worse than the other cycle.

So, basically it would just need to calculate all damage including procs, before returning the final rotation ?

just is good, when you want to add this you have to change the complet DPS calculation.

Sounds like a good project for a rainy sunday afternon.
With a huge lot of beer.

I wouldn't make a priority out of it, but it'd still be nice to see fixed sometime.
Maybe its possible to make a workaround for it?

am i blind or i cant see [Ring of the Recalcitrant] in spreadsheet?

Since most bosses have adds, you can still use Mana Tap on bosses that don't have mana bars. I use a focus Macro myself, so that I can Mana Tap anyone needed without actually switching targets. It works out to 15 energy every minute, nothing huge, but better than my old racials.

First off I'd like to thank everyone involved with the spreadsheet for keeping up the good work.

As for the actual question, I'm wondering whether to use Thundering Skyfire Diamond or Relentless Earthstorm Diamond in the meta gem slot. When 2.1 came out people were chanting TSD as the ultimate meta gem but testing really seemed to prove that it wasn't _that_ good after all. Aldriana's gear spreadsheet still has TSD coming clearly ahead but the DPS spreadsheet is vice versa, RED being an upgrade, albeit quite minor. Another thing to factor in is that RED provides a passive boost to your DPS while TSD procs might get wasted due to various reasons.

Same question has been tossed around in the old thread a couple of times but couldn't find any decisive answers to this problem. I played around a bit with both spreadsheets and even with BT gear RED seemed to scale better (my current gear is about 4/5 T4 and season 2 weapons.) I'd appreciate any anecdotal evidence regarding this problem.

Found another minor bug :
The green highlights for "Slayer's armor" 2 and 4 piece set bonus, only highlights the first and last cell, the 2 cells in between are left yellow.

It might occur with other sets as well.


On the subject of "Hemo", perhaps the hemo debuff could be moved to the boss debuffs? Since there might be another rogue in the raid applying it, even if you're combat spec yourself.


The RED (Relentness Earthstorm Diamond) seems to scale better than the TSD (Thundering Skyfire Diamond), if you insert the Tier-6 gear you'll see the gap between them grow bigger.
It's very gear and cycle dependant. For example, if you're using a "cut" cycle the TSD loses some of its value.
While at the same time if you're using Rupture, the RED loses some of it's value, though less than the TSD since it doesn't affect Rupture while the RED does.
Also, the RED has no real limit to it's scaling with crit, while the TSD scales with hit but is capped due to the internal cooldown.

I also wonder if envenom scales better at later levels. (it's pretty worthless to spec for it currently)
So many things to test, it's good we got this spreadsheet available.

Quick question.

Anyone know the dps difference 1.4, 1.5 and 1.6? when considering procs and haste etc.

I'm currently thinking Latro's VS. King's Defender, it's a 17 dps difference, can 1.4 - 1.6 mean that much? relatively it is 19% (dps) and 13% (speed) so +17 hit rating ftw?

Would like to see a quick-table for this info :p

People say ~10dps per 0.1s weapon speed is gained from CP. However the spreadsheet shows a 14dps unbuffed gain of Latro's over King's Defender with my gear. This obviously takes into account the dps oriented stats on Latro's that KD doesn't possess.

The thing about making a table is that the table should vary depending on your total stats. Surely just getting the spreadsheet and plugging in your gear and offhands is the best way to determine which would give you the most DPS.

P.s. post was written assuming you were talking about these swords in your offhand not your mainhand...

EDIT: I did make up a simple spreadsheet showing the effects of weapon speed on CP energy regen and found that as the weapon gets faster it actually gets better, it's not a linear relationship as the ~10dps per 0.1s speed estimate suggests, slow weapons (1.6-2.0 speed) are actually really bad for energy regen (as one would expect). The model was simple but it illustrated to me that comparing weapons of different dps values requires knowledge of crit rate and AP as well as the weapon speeds and average damage values.

You also have to remember, Latro's adds sword skill, perhaps more beneficial than the hit rating or basic DPS increase, especially if you're also wielding a sword in your MH.