• Aldriana

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

 

roq

oops.

 

Tipi

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.

 

Zaev

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

 

evl

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).

 

Dread

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

 

OnTheHissay

How good is armor ignore according to your sheet, worth dropping other stats for?

 

• Aldriana

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.

 

• Wodin

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

 

OnTheHissay

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?

 

• Aldriana

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

 

Darlal

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.

 

• Aldriana

Version 0.7.5, 8/29/07:
Excel Version: Free file hosting by Savefile.com
OO Version: Free file hosting by Savefile.com

Changes in this version:
*Updated weapon stats in accordance with 2.2 changes.
*Froze the damage calculation sheets, as requested.
*Adjusted gear lists for some slots.
*Added Solarian's Sapphire and Improved Faerie Fire to available buffs.
*Fixed bug that was causing gem sockets to incorrectly be displayed in OpenOffice.
*Improved hit cap detection for "Current Hit" and "Optimal Hit" cells.
*Added defensive contribution of Mongoose.
*Added Madness of the Betrayer
*Added Approximate Cycle display to front page.
*Replaced zone selection boxes with checkboxes.
*Fixed bug with Glove Enchant recommendation by removing +haste option, as said enchant is no longer useful due to the haste nerf anyway.
*Fixed gem names
*Rearranged Gem List to make it easier to use.

 

Gallinor

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

 

• Aldriana

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

 

Darlal

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.

 

Zaev

Thanks man!

 

antonmb

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

 

• astearns

Trivial bug: While the Talents_Equipment sheet allows you to modify the number of points you've put in Dual Wield Specialization, it doesn't actually affect the calculations. The cells in the "White OH Raw" rows in the cycle sheets use a hardcoded 0.75 instead of the value from L47.

 

Cybelirrae

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?

 

• koaschten

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.

 

Karmon

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

 

• Aldriana

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.

 

OnTheHissay

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?

 

• koaschten

unhide the trinket sheet and look at the ranking/scores

&