Thanks! Might want to update the filename.

Thank you! That should cover all my spreadsheet needs.

If you find the time, I'd be glad if you could answer a few questions:

1. Where does Call of Flame enter the damage calculation for LvB? I couldn't find anything in the corresponding cells.

2. How does one arrive at the base damage values for LvB and LB (1230 and 807), respectively? 807 corresponds to my ingame-tooltip, but that already includes Concussion, doesn't it?

3. As far as I can tell, CC-uptime is always determined with respect to rows 23-135, regardless of fight length. I believe this should be adjusted dynamically, shouldn't it?

1) Fixed.
2) Fixed.
3) the CC page was some "math in progress". I've changed the CC reference back to the math page where it should be.

This is great, thanks a lot for your hard work.
I'm really happy it works in OpenOffice now.

Just thought I'd give you my thoughts on this;
Could you split up the "buffs" column into "buffs" and "talents"? (Mainly thinking about how it handles Call of Thunder and Misery/Imp FF. also should the user manually add 1% hit for Draenei Aura or can there be a setting?)
Can there be an option to enter the hit and haste values as ratings instead of %'ages? (Helps some if you only have access to the online armory)
Why is the Damage % modifier box green when it's feels like it's not something one should tinker with?

Also I'm not 100% certain how the DEP calculations work but it still listed hit as the #1 stat for me even when I had >17% already.

1) Buff/Talents - Can do, although there won't be much going into the talents column (CoT + Precision)
2) Draenei Aura - Done
3) Ratings not % - Done
4) Damage modifier - fixed.

I decided against automatically adjusting EP values based on hit %, because I could never figure out a decent way to handle it. The solution is that there are two Wowhead links, one including hit, and one that doesn't. It's up to the user to manage their own hit percentages.

Noticed a few small bugs.

Total Stam and Int, has static values.
mp5 from talents should come from Total int, not from int from buffs.
Critt from buffs sais "thunderingstrikes", what about CoT?

Perhaps the Critt% should be left at %.

Hey Bink, thanks for all the great work. My stats are showing spell damage weighting almost twice that of haste, might you consider adding the 46 dmg 40 sta food buff? It's obviously not hard to enter by hand, which I did for my own use.

Thank you for the spreadsheet Bink. I just had a quick question. With no raid buffs (except the ones I provide for myself), I'm showing my dps as 3235 for a 3 minute fight with BL. Adding the 4-piece T7 bonus, my dps is 3255, a mere 20 dps (.62%) increase. It gets worse when I factor in raid buffs. 4286 dps before the set bonus, 4310 after the bonus, which is only a 24 dps (.56%) increase. Is the set bonus really that insignificant? I wasn't expecting the benefit to be huge certainly, but 24 dps is seems incredibly low.

For all the talk about haste and especially crit being overshadowed by spellpower, that's not what the SEIC is telling me. The hinge seems to be cast delay. At .15s and even more at .2s, haste and crit overshadow spellpower.

I usually end up with 150-200 latency. Am I wrong to use this as the cast delay figure? In short, am I using the spreadsheet correctly and seeing that even a tiny additional casting delay swings DEP massively in favor of haste and crit?

No, it's because changing the delay figure only affected base dps, not the stat affected dps, so the EP values were off. Fixed in 3.0.8.2

I would like to thank you Bink, you always deliver on the goods for elemental shammies.

Only question I have is what is that chart you included? Can't figure it out for the life of me...

Also the pull down for warlock curse of elements doesn't work.

Is it just me, or does the SEIC spreadsheet say "Haste %" and "Crit %", but actually use rating instead of percentage?

I don't think the heroism/bloodlust value is being turned off for the stat-affected DPS tables when you change the heroism/bloodlust value from 1 to 0 on the "current" sheet.

The following is the content of the AG38 cell in the broken form:

And I believe the following is the correct formula for that cell:

The problem appears to affect columns AG, BA, BP, and BU from cells 38 to 65535+.

Clearcast uptimes vs Crit.
CoE has that problem because I think I removed the Yes/No/Improved option, or didn't add it back in.
Here will probably be fine.
Because I didn't change it? it'll be done in the next one.

Speaking of the next one.... I noticed I made a mistake in calculating Spellpower EP values. I was dividing Spellpower DPS by Base DPS rather than dividing the difference by 200. Suffice to say it has been fixed, and now spellpower is worth lots more.

Also added some copy/paste values for Pawn.

Thanks for your work, Bink, I appreciate it.

Regarding the spreadsheet: in the Math tab, is cell V6 supposed to be "=Current!$E$6+200/ratingcrit/100" or should it just be "=Current!$E$6"?

I figured in this area you were seeing how much of a DPS increase you gain from the increase in each stat. With the crit, it makes spellpower pretty powerful, but without it lowers it quite a bit.

Tab: Current
Cell: D3
Formula: =Settings!N2*(1+ancestralknowledge)


Tab: Settings
Cell: I5 (ancestralknowledge)
Formula: =1+D5*0,02


This gives a 110% bonus to the int from buffs.

Bink, thanks for the great updates.

You knew this would happen - I can't quite fathom the calculation you're using to derive the EP rating for the [Thunder Capacitor]. Possibly because I'm not sure what the percentage in your CC!O22 cell means. I assume that takes into account LO, EM and BL, but I don't think I see the 2.5sec internal cooldown anywhere either.

I have to ask because your calc seems to make it the second best trink in the game, with an EP 30-40 pts higher than what I modeled, and 80 pts higher than the number someone was throwing around elsewhere on these forums in the past couple of days.

Yeah, I think my figure is too high. On re-reading it, I stuffed up the crit damage, so it's down to 122 now.

What I did was took the chance that any given spell would be a crit, subtracted a quater of that chance squared (the chance that the fourth charge would be followed by another crit, in that 2.5 second cooldown window), and divided by the average cast time to get the number of charges generated per second.

Multiply this by the damage generated per charge (1181+1371)/2/4 * (1+(0.5*Crit) (I was doing 1.5*crit or something, which proves I shouldn't do math while I'm on holiday)

Formula for those wanting to update before I release .5 in however long it takes before I release it

SampleOutput - simulationcraft - Google Code

It looks like we are within 5 DPS of each other when I plug my numbers into your spreadsheet after I corrected a few of the bugs in the shaman code.

Good to have a confirmation of our numbers but sad that it seems we will fall short of 5K DPS on average.

That's an interesting point, given that I don't have Chain Lightning in my rotation. (Working on it at the moment)

Ok, so adding in a CL option, and having an "aggressive" and "after LvB" use setting, it's anywhere between 15 and 80 extra dps, and that's assuming that Overload is functioning correctly.