This is no longer being maintained

I haven't been updating ShamStats much lately, and going by the number of downloads it's still popular.

Over the last few months I've stopped working on it as a Elemental/Resto spreadsheet, and have just focused on the Elemental side of things. This means I could put aside the switching options, and do a bit more customisation.

Thusly, the Elemental Item Comparisons sheet evolved.

So now, I've got three "values". EP, DP, and SP.
These are Equivalence, Damage, and Sustainability points.

Damage points look at the direct damage done over the fight time frame (which you can specify). This is done by calculating the overall damage, then comparing it with the damage done without a particular stat.
Sustainability looks at the same thing, but via regen mechanics (elemental focus, mp5).
Equivalence points are the the two of them added together. Now before you get worried, you can sort by either EP or DS values.

One of the cool things that I've (finally) added in is the ability to specify individual gems for each item you have equipped (and it'll even make sure you have the right gems selected before adding on the socket bonus).

At the moment I am fairly certain I've ironed out the bugs, so if you find anything, post it here.
Also, I know I'm short of some items from 2.4 (the SSO necks in particular) so links to those from WoWHead would be useful as well (as much information on proc cooldowns would be useful)

Lasty, props to Moshne for helping out with formulae & fixing stuff

Link is dead
Posts containing stuff what needs to be updated/included:
http://elitistjerks.com/729737-post30.html - Dark & demonic runes


Added in:

• Armory import.
• Destruction Potion (and Mad Alchemists)
• Shadow Priest DPS -> MP5
• SSO Necks
• Heroic gems
• TTOOM calc
• Stormstrike (beta)
• More enchants
• Hit adjustment between 15-16%

In answer to the ICD of the neck from SSO (for Aldor Rep) it appears to be ~45s CD AFTER the proc ends. So a 55s ICD from time of proc.

still have problem with hit (see pic)


and DEP

given that draenei sham is treated with +1% hit here: can anyone precisely confirm this actually counts for himself aswell? given that the buff still shows up only for grp members, but not for the sham himself?

The tooltip reads as follows:

Increases chance to hit with spells by 1% for you and all party members within 30 yards.

Ah, I see where that went wrong. Fixed cell A73 on DEP to read =A72*IF($B$21>0.16,0.99-D21+(B21-0.16),0.99-B21)
Can you past that in to see if it fixes it?

thanks, I know what the tooltip reads, but, and apparently thats still in someway correct, the mechanic does not work as easily as you could suspect. I was told several times that the aura would work, but there wouldn't be an effect for the aura causing sham. but thats obviously wrong then. thanks for the info -_-

yes, its fix. But weigh 1 hitr still not equal (Hit=50=3,96% -> 1 hit=2,202; Hit=27=2,14% -> 1,698) - im not swap items, just add hitr in cell P15

Hey, nice tool!

I tried it and I found bug. I wrote fix for it. Spell Crit Rating is calculated wrong. You ignore values from elixirs, flasks, oils and food, though you forgot add [Skullfish Soup].

I wrote fix for it. Put this to K7

and fix for hit:

Put this to K8

You should this add for other stats like stamina, spirit etc.

Don't forget remove it this calculation from total crit.

Ops, try =A72*IF($B$21>0.16,0.99-D21+(B21-0.16),C21-D21)

You didn't check M7 & M8 did you? But you're right about the Skullfish Soup bit.
Hmm. Now that you mention it I'm just chaining a couple of cell references there, so I could tidy that up and make M3-9 refer to the row 15 stats rather than doing it via K3-9

also wanted to point out, if you look at the socket bonus calculator in ruizAw's picture, it doesn't appear to be working correctly either.

The rating column was just showing what you had from gear. I've since cleaned that part up to show the overall stat effects (and keeping the % values as I need them, but hiding them)

As for Destruction Potion, I'm not too sure on how I should handle it.

I guess I can add in a 120*15/120 for damage, and 44.2*15/120 for crit based on that (and then to a use check for valuing alchemy stones too)

I doubt that [Alchemist's Stone] affects this potion.

For when I add it in I mean. At the moment I'm just assuming that mana pots are the default, thus the static 40mp5 value

Trinkets look to be bugged.

Right I have Essence of the Martyr with a better DP then The Skull of Gul'dan.

Looks to me like the healing column (column U) is being used when the dmg column (column V) should be.

I suspect that one is my fault from when we updated the references away from the HEP/DEP values. Trinkets slipped through the cracks as they didn't need to be updated for the gem or enchant references.

EDIT: Or perhaps not, I am not able to replicate the problem, what do you have set as your sort value, EP or DP. The Skulls EP value is going to vary depending on if you are mana sustainable or not, do you have SPriest, JoW, and other such buffs turned off? Also, which list is it showing as an upgrade in, the main page, or the upgrade?

EDIT 2:

I found it, or I suspect I have, its referencing the heal column for hit, are you not hit capped in this instance of the sheet?
@Bink, in the trinketlist page, the DP calculation is referencing column U for hit instead of X, giving some wild values on non-hit capped setups for healing trinkets.

Fixed.
Noted. I think I know what to do to fix this bit now.

For reference, something someone emailed me (please don't, just post it here)

I am 1 pt short of being hit capped. So if the +heal column is being treated being referenced for hit rating that would explain the odd values I am seeing. I was looking directly at the trinket page and the DP column.

An item I would suggest adding from patch 2.4 Cloak of the Betrayed
[Cloak of the Betrayed]
When gemmed its about equal to the Ruby Drape of the Mysticant which is damn impressive for a non-heroic blue. The type of item shaman just starting out should know exists.

Thanks for all the hard work.

Crit in L7 is not looking at buffed Int, consequently, nothing is. Arcane Intellect and Blessing of Kings are not shown to be DPS increases.

L7 is =(2.2+(K7/critr)+(K3/80))/100.

It probably should be =(2.2+(K7/critr)+(=M3/80))/100

Can you post fresh version?

And tell me - before cap - hit > dmg (crit) or < dmg (crit)?

Bink, I posted my question under the elemental thread; basically my +dmg numbers are off on your spreadsheet to what they are in-game (1107 w/ totem), and also on the spreadsheet itself. When I add up all the +dmg from my items on the spreadsheet I come to a total of 1,153, not 1198. Why is this? The Skyshatter shoulders and gauntlets are off by a few +dmg. In-game my shoulders (w/ gems + enchant) add up to a total of 82, not 86, and the gauntlets add up to 78, not 80. Is there a reason they are adding up to those numbers and not the numbers I get in-game? I was also wondering why you added +38 damage to the Sextant. Thanks!

Added
Fixed
Maybe at the end of the week.

Prax: I can't tell anything from the screenshot you have up. I can go double check the item stats, but I think your problem revolves around the gems/enchants selected. Also, for proc or use effects, I've turned those into average values so we can compare them better.