It might be interesting to implement cooldowns for lava burst and flame shock, a fixed rotation with 1 lightning bolt gives skyhigh dps, yummie.

Also, it might be worthwhile to round the amount of lightning bolts cast in the "priority" styles up or down (depending on whether you want to wait for Lava Burst to become available, or rather finish the cast and lose a bit of Lava Burst / Flame Shock efficiency). After all, you can't cast a partial lightning bolt.

Regarding 1, well, maybe if I were to insert 4 or 5 lightning bolts, I might go under the CD by a second or so. Will you call everyone with tons of haste who tries to insert a rotation with 4 lightning bolts, an idiot? For the record, I used the "1 lightning bolt per cycle" example just to make the point clear that a few extra checks might be useful. Not everyone realizes they are looking at bad results when they play around with the spreadsheet. You can't expect that from everyone.

Regarding 2, I would say it is fairly obvious that the average LB:FS ratio won't be X, but will be ceil(X) or floor(X), simply because good players tend to stick with a decision, instead of make a different one every other cycle. If you always cast the extra lightning bolt, it will be ceil(X). If you always wait for the Lava Burst cooldown to pop up when it is nearly done, it will be floor(X).
Some playing around with my own calculations suggests that finishing casts (ceil(X)) gives more dps. But feel free to ignore me. I'm just a minor person who doesn't even have a lvl80 shammy. And I don't really mind what you do with your own spreadsheet. I probably suck at constructive criticism as well.

Sarcasm aside, the idea of using a floor() and ceiling() for the expected DPS values would actually be useful in knowing whether you should cast one more LB or not (I wouldn't bother using it in any of the other calculations, since you'd effectively need to calculate everything twice). I'm assuming that for some value of time left, it's better to wait, although most have shown that continuous casting produces better results, at least in real-world scenarios.

I have no intention of replicating haste work within SEIC, nor automating it so that it's fool-proof. That said, I do have some graphs & work to be added to the TTT entry soon re: haste

Great spreadsheet Binkenstein, been using it for while. Just noticed one little thing about newest one, while you can choose Glyph of Totem of Wrath, it doesn't give bonus spell damage to buffs part. It's ofc easy for everyone to fix but just wanted to mention.

I am not sure if this is worth its own thread or not, but it would seem like focus magic would be an interesting buff to do some research on. Bink, have you done any number crunching on how much DPS we would gain compared to the other classes out there? I looked in the mage forums and saw nothing about FM. I know our mages buff each other with it, as a "If you boost my DPS, I'll boost yours".

Probably a question for the mages to be honest. It's in the sheet, so that should give you the elemental figure, but given the crit scaling for Elemental, it's probably better to use on other classes.

Pretty sure the only class a mage can put it on and guarentee themselves 100% uptime for themselves is elementals.

So it's 3% for us and them with 100% uptime if the mage picks an elemental for it.

It's possible, but unlikely that a caster will go 10 seconds without a crit. If there's more than one mage, they'll usually put them on each other anyway.

I've been wondering this myself, so I've ran a few numbers. General rule of a thumb is: if you have frostfire mage in raid, he should get it, as his gain from the buff is pretty impressive and they tend to have high crit gear themselves. If you don't, put it on boomkin or elemental shaman, former for his tiny bit greater bonus or later for a tiny bit more assured uptime, but the end result is too small to matter.

Your math is very flawed. the uptime will be more like 98.5%. At any point in time you can look at the chance that the other caster failed to crit any of his 6 last spells, which is 0.5^6 ~1.5% assuming 1.66 sec casting time. 2 sec casting time gives 97% uptime, 2.5 sec casting time gives 94% uptime. In all of these cases, a much bigger deciding factor will be the other persons benefit from crit .