Yes I know adding more hit while being capped is useless, but does it really mean that hit has no value? Having no trinkets with hit equipped while being hitcapped and then equiping Dying Curse means you have too much hit. This means you have to lose hit elsewhere getting crit in return. Doesn't this at least mean something for the value of hit?

This is rather uncalled for, but it gave me a good chuckle though. Amateur psycho-analysis is always a sight to behold.

Just resist the urges for those kind of comments next time Bink, you don't need that.

The value of hit is somewhat static in the since that if you aren't hit capped is it the most important stat. Period. However, once you are hit capped, one point beyond that is useless. Bink didn't spend a lot of extra time, nor does he need to, to code in devaluation of hit once the cap was reached. Also, the Wowhead and Lootrank links allow you to see armor ranked with or without hit. You can use this to look at your current hit items and see what future upgrades are available and possibly decide if you would rather drop a hit item for a non-hit item and pick the hit up somewhere else.

The trinkets can be sorted with and without hit valuation. This gives you a general idea of how much a non-hit trinket is worth versus a hit trinket. Some people, me included, do not use trinkets to pick up hit and choose to get it through other gear and gems. This may not be the best practice, but that is the point of the spreadsheet. It is a tool that allows you to make these decisions on your own.

Your analogy that gear either has hit or crit and not both is a bit vague and not entirely accurate. Therefore, your...recommendation, I guess...that there be some form of "you should dump hit for crit" part of this spreadsheet seems like a stretch. If that's your design strategy, great. This isn't the thread to discuss that in, however. It seems more like a derail and breaks the line of discussion. Try the "Optimal Gear" thread.

This can't be modelled: The +hit's value in a given slot depends on, that in another slots, what is the item's DEP gain you got compared to the item with the +hit item you are currently using.. Just make sure you pick the highest DEP value item set with the constraint of having hit capped, there is nothing hard in it.

Obviously this is beyond the scope of Bink's spreadsheet, but when I'm mixing and matching my gear to determine the most effective combination while maintaining the hit cap, I calculate the "DEP lost" (i.e. opportunity cost) for each point of hit rating on that gear:
(* Be sure you set the DEP value of hit rating to zero for this calculation)

I then rank my various choices of hit gear and equip them in order of least DEP lost per hit rating until I've reached the cap. It's not perfect (for example, if you're only 15 points away from the cap, you wouldn't want to take Dying Curse as your next item), but if you include hit gems rather than spellpower/haste in your list, it can also tell you at what point you should be gemming for hit versus just getting it on gear (typically, gear is the best source of hit rating barring a significant difference in item level).

Just wanted to say thanks to Blink and the other people who have helped make and maintain this sheet.

I was just wondering if there was a reason the value of haste became higher than th value of spellpower on the spreadsheet even though we had no majo changes in the patch.

I haven't seen anyone give a real solid answer. It doesn't make any sense to me that the value of haste would all the sudden change with no large change in class mechanics.

It makes sense if you read the change log and realise that I made some calculation changes, but I've already said that half a dozen times already.

I've begun reworking the calculations again, and it's turning out to be a long winded process. Hopefully the changes will make things a little more... transparent with how I've arranged things, and I'm working in the revised rotation calculations as well.

Timeframe? Umm.... maybe in a few weeks, depending on how bored I get, and how much free time is to be had (I've been playing lots of Evil Genius, Fallout 3, and Wolfenstein when I pick it up at the end of the week).

Alpha of the new calc stuff (on New EP tab). Only done the base rotation so far, but I think I have everything covered.

Comments?

Sweet.
Bink, have you considered an armoury import for this spreadsheet? ala Landsouls Warrior sheet.
Ty for efforts though

The amount of effort that went into the armory pull in v2 was ridiculous, and it is obsoleted anytime Blizz makes a change to the wowarmory. It was a fun experiment and I learned a lot putting it together, but it was very little return on the effort when the ONLY benefit would be in unique designing of trinket procs, and that can be handled with two drop down menus if it was something Bink wanted to do.

I feel you underestimate the value of intellect a bit when calculating the DEP-value in cell C6 in the EP-sheet or New EP-sheet for that matter.

It seems you calculate it by taking the DEP-value for crit-rating and multiple it with 45,91 and divide with 166.

[DEP-value for intellect] = [DEP-value for crit-rating] x 45,91 / 166

Intellect on gear will benefit from both Blessings of Kings and Ancestral Knowledge, which crit-rating doesn't. This is why I feel this formula is more correct.

[DEP-value for intellect] = [DEP-value for crit-rating] x 45,91 / 166,67 x [1 + 0,02 x Points in Ancestral Knowledge] x [1,1 if BoK]

Maybe i found a bug. I set the spellpower to 3800, set Electrifying Wind 1 and set ToW Glyph 0 and Lava Glyp on 1.
Then I see Glyph of Shocking on -3 DPS.

Well, given the fact that that's the old calcs as I had only created the base rotation stuff, I'm not going to worry about it :p
Might have a new copy of r18 up later today with those changes in it.

And here's 18b.

Glyph, set bonuses, relics and potions should be sorted. Still have to do mana stuff again though.

ToW would be a bug, OOM and Lava vs ToW not implemented yet.

I'm currently levelling my Shaman as my main alt, I do intend it to be elemental. At 80 I want to get the best possible gear for my spec, I read all your threads (the one wth all the maths and the ones on the spreedsheet). I've looked over your spreadsheet and the amount of information in it hurts my head at this point in time, it will likily make more sense once I get those last few dings and get in raids, what I can't seem to find now are the numbers to plug into places like wowhead, I thought I found them on the sheet put placing them in the wowhead list showed vastly differnt results to the best gear threads so I must have seen/used the wrong numbers. My plan was to use the numbers to generate a list of easy to get gear for pre-raid gearing (ie.mostly badge gear and BoE gear), if you could provide a list of the number you are currently using it would be appreciated.

The sheet comes out of the box with Bink's gear in it, clicking the buttons that say "WoWhead" or LootRank would do all this for you. You'll probably hear a lot more from your request, and deserve less. If you need anything else, I'd try using the sheet for a few minutes, its quite easy to use if you give it the effort.

Alternately, if that proves too difficult, use Rawr. You can import any shaman in the game into it and see what it says.

Wanting some feedback on the "New Rotation" side of things. I've only added heroism into the first section (the base/current dps calcs), but everything else should be the same. Wanting to double check rotation logic & calculations.

There's also the question of whether all heroism time should be without CL, as the damage gain is smaller (~120 with on CD selected) during that time. May end up putting a second CL use control in for stuff like that (I'm picking the best rotation will be CL After LvB with No CL on Heroism, for both damage output and mana efficiency)

I just checked out the new version you linked and it looks like something odd is going on with Cast Delay and the T9 Set bonus. With 0ms delay the T9 2 piece is in the 150 range. With a 200ms delay the value jumps up to the 570 range. That seems a tad high.

Fixed that one. Had to add in a if spellcast = none then 0 otherwise <insert normal calcs here> to the cast time column (which I'd actually added for the base heroism one anyway).