Post 387 (which is referenced in Post 534, also on this page) has a more thorough description.

oops.

Could you add a Solarian's Sapphire box by the two Battle Shout options in the buffs sheet? It adds 70 ap to Battle Shout and is affected by the imp bshout talent, so a warrior buffing the group with both adds 468 AP.

An option for improved Faerie Fire would be nice too, since +3% hit from a debuff on the mob is 3% I don't need on my gear, but I don't know how prevalent Balance druids are in BT/Hyjal guilds. It would be nice to be able to tell him how much dps he's adding in exchange for losing his points in the resto threat reduction talent.

As a rogue who regularly runs with a balance druid and gears himself accordingly, I have to second this request.
Please?

Yesterday I picked up [Belt of One-Hundred Deaths] which according to the spreadsheet is a 10 point gain from my last belt, [Belt of Deep Shadow] however when I put it on I get a 1 point loss. But if I shuffle my two [Shifting Nightseye] and put one of them in my legs and replace one on the belt with a [Rigid Dawnstone] I get a 2 point increase (the type and number of gems are unchanged).

New changes to alot of weapons in SSC/TK.. possible MH/BT coming soon :P

MMO-Champion - World of Warcraft Guides and Raid Strategies

http://www.mmo-champion.com/images/n.../tkchanges.jpg
http://www.mmo-champion.com/images/n...sscchanges.jpg

I've noticed that Belt of One-Hundred Deaths tends to change in value more than some other pieces do; I'm not entirely sure why. I will review the calcs for it and verify that nothing is obviously broken.

It should be noted, however, that item comparisons are made between the "optimal" socketing of each item, such that if you socket one or both items differently than the "optimal" column, the value of the upgrade is going to be different than expected.

Yeah, I saw those this morning. Expect a new version in the next day or two with the new items + a couple of bug fixes + possibly the first couple UI tweaks (depending on how much time I have).

If you feel the need to ask this question, you've totally missed the point of the sheet.

Bug report: Shifting Shadowsong Amethyst is listed as 10AP/5crit when it's 5agi/7sta.

Yeah I know the sheet will tell me if it's worth it or not, which is it's purpose, I was on the move and asked it all wrong.

What I really was wondering, was what kind of calculations the sheet uses for armor reduction values. And can I view the math they're based on somewhere?

Already noted in post 457.

And I'd just like to note that I'm officially jealous of those of you that have reason to pay attention to such things.

Well, the sheet computes damage assuming some baseline armor value, as specified in Advanced Settings. The default value is 5k. So it mitigates damage of Sinister Strike, white attacks, etc. by an amount appropriate to an opponent with that amount of armor; in particular, it multiplies damage from those sources by a factor of 10557.5*(10557.5+Armor Value).

So, when you equip a piece of armor penetration gear, it instead mitigates the armor by the new, reduced value. So if you have, say, 200 armor penetration, it will mitigate by 4800 armor instead of 5k

I'd like to post a quick apology for disappearing and dropping the development of this spreadsheet back on Aldriana. Suffice it to say I got over run by real life issues, some expected, some not. Long story short, I'm married now, with a new job, a new apartment, and starting grad school (what a month!) and wanted to say thank you to Aldriana for continuing to provide this excellent spreadsheet for the rogue community.

according to your sheet ... i should be wearing my wastewalker tunic and wastewalker gloves over my netherblade gloves and chestguard of the conniver.

Probably. I wore WW Shoulders + Gloves myself until I had T5 for both slots. WW is a good set with a powerful set bonus.

What's your hit rating? In general wastewalker is overpowered. If your armory profile is up to date, I think the spreadsheet is correct. Dropping 1 peice netherblade does not cost you the 2-piece bonus and getting the 2-piece ww set is really worth it.

Edit: beaten by Aldriana.

Thanks man!

the dps cell isn't frozen for me. using excel 2007.

Hey Ald. Thank you so much for continuing to update/upgrade this gearsheet. I find it invaluable as you know I am too lazy to ever do these types of calculations myself. You can figure it has saved you tons of time and distraction from me whispering you about gear.

In any event, quick question. Did you change the values underlying WSC's proc or the value of Ashtongue Talisman of Lethality. I remember reading in this thread or another that theory-crafters thought that AT and WSC were pretty competitive dps-wise, with AT having a slight edge. For my gear level it is only showing a 19.80 AP increase going from WSC to Madness of the Betrayer whereas it shows a 30.28 AP increase for AT, implying of course that WSC is roughly 10 AP equivalents more powerful for me than AT. Or is it instead implying that my gear has scaled enough that the Armor Pen from the proc scales more than the extra crit rating proc?

Ok, something is borked with the sheet, the +hit box showing wrong stats or me just being stupid... i cant figure it out...

Grab this sheet: Free file hosting by Savefile.com

Now switch the 10 hit gem in the boots to 5agi/5hit and explain me why the dps goes down instead of up though i am above the hit-cap before and after the switch.

Somthing is broken with the Gemsheet for 0.7.5 (OOffice version)
e.g. Cell R51 sums hit instead crit for yellow gems. But only for yellow and green variaty and not orange.

It seems to me that all the cells in range M51:S55 needs a thoroug investigation

Good catch. Will be fixed in a future revision.

I didn't *intentionally* change anything with WSC or Ashtongue. Which is not to say I might not have changed something by accident, but, as far as I know, everything should be more or less the same.

The only thing that I can think of is that I switched Mangle on by default in the buffs page, which does give WSC a slight boost relative to Ashtongue. So if you've been using the 'default' buff set, that may account for it.

So, the fact that it's doing crit instead of hit is defenitely a bug, and will be fixed in next revision. The fact that it's not doing orange gems is correct, because orange (and purple) are already counted under red gems, so if it were also under yellow it would be double counted.

I'm actually not sure why it's split out into gem color there in the first place; I don't see any intrinsic reason not to total over all gems. However, it was set up that way initially, and I didn't feel like thinking through all the consequences of changing it, so I didn't. If you want to know the overall motivation, ask Darlal. In the mean time, I'll clean it up in the next patch or two .

Hmm, that does sound unusual. I'll look into it and get back to you when I have time.

Edit: Oh, I see what's happening. This is actually the bug that Karmon caught; what's happening is that the 10 hit gem is actually being scored as 10 hit and 10 crit, while the 5agi/5hit gem has correct stats. I'll post a bug fix release this evening with this and the DW Spec changes, plus anything else you guys find in the next couple hours.

How can I get the sheet to show me more alternatives regarding trinkets? The sheet shows me that I should upgrade my Tsunami to DST, but I already have that. So how can I see the other alternatives?

unhide the trinket sheet and look at the ranking/scores