See previous comment about "if it's blank it's not back in yet".

Replace the buffs spellpower cell (D4) with =MAX(IF(I35="Yes",0.1*J35,0),IF(I42="Yes",280,0))+211*(1+0.1*M22)+glyphtow*84

[e]Fixed version + more notes: http://elitistjerks.com/blogs/binken...ion_stuff.html

Be sure to check the latency value on this push if you're using this sheet. A lot of the default values got changed including latency from 150 to 0. That greatly increases the given value for haste. People using this spreadsheet should probably make sure to fill out the fields to their stats to get the most out of it, unless there was a reason I'm not aware of to use a latency value of 0. The CL calculation fix did not magically make the haste weight almost eclipse spellpower gemming.

Ah, nice catch. When I enter 150 into the latency box, the numbers go back to roughly their previous values (~1.5 for sp, ~1.4 for haste). Turns out I was better off gemming for those socket bonuses anyway, though. The 4 haste and 5 sp socket bonuses make up for the slightly lower value from the gem (roughly a 2.6 DEP difference between a Reckless Ametrine and a Runed Cardinal Ruby before the socket bonuses are factored in).

I changed it to zero to compare the results with simcraft. Obviously people shouldn't use the default settings blindly.

Not earth shattering but Pandora's Plea is 751 SP:

=depint*108+depspell*(850*10/trinkintcd)

The original tooltip said 850 which didn't match the proc and was corrected.

Is there a place that explains why Haste is so good and why Crit is practically half as good as Haste? I understand that part of Crit being worth less is because of the LavaBurst, wasn't sure if there was more reasoning.

You answered the crit portion for yourself. Every caster class scales fairly poorly with crit due to the nature of the stat. (Yes, even shadowpriests, they just scale more poorly with haste.) The question is why we scale relatively better with haste.

First, we scale pretty poorly with spellpower, this is because of the cast times on our spells, we get a lower coefficient. All of our spells are this way. With the Shamanism buff, we are in a bit better shape, but still not as good as some of our caster counterparts.

Second, all of our spells have a cast time that can be reduced by haste. Flame Shock's DPS gain from haste is less than the others because the tick speed doesn't change, but FS is an insignificant portion of our DPS rotation. LB/LvB/CL all increase in value with haste until you get the 1.0 casting speed mark. This is very hard to obtain until you get the most top end of gear, and even at that point, LB will still continue to gain. Although, at that point haste devalues pretty quickly, for the same reason that Crit devalues from the beginning.

Hopefully that answers the concern, but the long story short is that "math" is the reason why. You have to get into the nitty-gritty coefficient and rotation dynamics to fully get it, and I'm not sure I can really show that to you without you getting your hands dirty yourself.

I have same problem as zuathar, but also I am curious if you will share, why you are discontinuing your spreadsheet.

By the look of things, it appears as if Bink has taken a leave of absence from the game. As for reasons, I doubt they will be shared here.

I was wondering if there was anything i could do to make the load times when i click the wowhead link go faster because for some reason when i click it for the gear list not incl or incl hit it takes forever to load or doesn't load at all :-/ like i can have my browser open and the tab will pop up minutes after I clicked and my computer is very good so I don't think its a hardware issue. Does anyone else have this issue and sorry thats all one sentence.

So any idea what we're doing now with BINK's spreadsheet not even visible? I recently switched to Elemental and was hoping to read up on the past few months of changes in his blog, but that's not even accessable either. What now?