WrathCalcs updated:
--Fixed bug with shoulder slot reforging.
--Changed stats on a few items. Notably, changed JC trinket to the spellpower one, and reduced ICD on Volcano to 45.
--ICD trinkets are still a bit overvalued since I'm just using ICD as the cooldown (i.e. 0 proc time).
--Lightweave changed to Int and 50s ICD. (Forgot to do this one in TreeCalcs, I think).
--Added Dark Intent (haste only for now until I have some way to model the DoT bonus).
--Changed meta requirement to match live, since we still have no idea when it will be fixed.
--Put in better numbers for Force of Nature, based on some nice research from thedopefishlives over at SimC.

Still looking into gems not working in OpenOffice. Apparently the "gems" list isn't populating correctly (column N in the charsheetdata page). One of the functions used there must not work in OO.

For me the newest sheet isn't working at all using OO.

In the Nukes table, the formulae D23 and G23 are using the entry 'PartialResists' which doesn't exist any more. It looks like you removed all partial resists but forgot removing it from the 4t10 calculations there.

Adjusting those formulae fixes the sheet, besides the gem bug that is.

And just by the way, it seems like you still haven't mentioned the Jeweled Serpent JC trinket in the guide. I'd really suggest adding a small line about it mentioning that if you're a jewelcrafter, you can easily get it as one of the best trinkets currently in game (even though proc trinkets are overvalued it's still above Witching Hourglass and most epic trinkets in your sheet).

Uploaded a quick fix for that. I guess Excel computes in some way that avoids the error if it's in an unused conditional.

In the spreadsheet the hit chance gained from Balance of Power does not seem to affect the hit chance of Force of Nature. From some brief testing on live servers my Force of Nature are not missing at all without any "real" hit rating.

Ritssyn's Ruminous Drape has the name "Cataclysm World Drop Epic Caster DPS Cloak"

I'm wondering about some of the numbers for FoN, my guesses in green.
Base: 580*1.65 weapon DPS*attack speed from pet tab
AP: 932+.57*SP regression from pet tab
Coef: .635/14*1.7 Armor reduction? / AP conversion * attack speed, but this cell is never used
Damage: base+AP/14*1.65 Melee formula for a zero armor target

Farther down there is a fixed crit chance with double-damage, and computations for dodge and miss, and a single roll table for 3 treants, 30s, and a 1.65s swing.

I think the final number is ignoring armor and any raid buffs to melee damage. It is also ignoring (possibly correctly) the Druid's haste and crit.

I'd expect that ignoring armor is a fairly large error (I think a Sundered ?? takes about 71% melee damage, before other raid buffs), and Haste could also be big, if they inherit our haste.

Getting the number exactly right doesn't matter too much. A full duration FoN is always extremely high on our DPET list (probably in second place behind a two target Starfall). However, knowing if FoN is affected by changes to the Druid's Haste could influence casting decisions.

There's not a simple way with the spreadsheet to figure out what your DPS would be sitting in Solar Eclipse and either Lunar Shower Sunfire spam with IS up, or apply SF/IS dots + WM Spam is there? I'd still use Starfall on cooldown, but basically no Wrath/Starfire/Starsurge - Just sit in Solar Eclipse. This is what I do when I'm farming / AoEing, and honestly most of the time whenever I'm in a 5 man dungeon for trash. Anything that dies fast it seems more efficient to stay in Solar Eclipse and multi dot etc and then run around with Lunar Shower and pew pew until dead. I was looking at the rotation section but it doesn't seem to be very simple to change the spreadsheet so drastically :x If there's not an easy way to do this, oh well.

Just curious though to see what is / isn't possible, and how many targets would be needed to make this more viable than a standard rotation. It's definitely more viable for me for multiple adds when farming. Can run around killing 70k+ HP mobs pretty much infinitely without having to stop moving. I don't use Wild Mushrooms, but for instances where you can be stationary, I was curious if even when two mobs are alive, if sitting in Solar + WM spam would be better than a standard rotation. I'm aware the radius on mushrooms is extremely terrible at the moment, but I'm still curious.

I know on the Training Dummies I was able to get to 32k DPS with my gear by literally running around the top section of the Horde dummies and Sunfiring every dummy, Starfalling when on cooldown, and applying IS if I ever had a GCD where I didn't need to Sunfire a new dummy. Obviously in multitarget scenarios there is some validity to this, I'm just curious to see the true break points on target #'s + how good mastery would be in such a scenario.

That's been updated in the version I just put in the druid forum thread with a few other updates. When I took the items from MMO-C's database it didn't have a real name yet.

Hamlet, in your opening guide post you clearly state that the chaotic metagem is what we should be aiming for even after its silly gem requirements. My question to you sir is does the 54 crit plus 3 percent increased crit damage make up for the 40-60 intellect loss from gems and the 54 intellect loss on the ember shadowspirit meta? Looks to be a total loss of 94 intellect for most of us.

With Intellect being our primary stat is this a wise shift before the chaotic metagem is fixed?

I think Tecton's looking at this now. Some function being used must not be handled correctly by OpenOffice.

Like Dopefish said below, he did some testing on this. For now I at least got the AP/hit/crit right. Not sure what to do about target armor or haste/AP raid buff since they're currently not in the sheet at all. I should add in glancing blows and LotP. The scaling factors for spellpower and hit do change slightly when FoN is modeled correctly, so I at least want to have pretty good numbers for it, although the exact total damage isn't too important.

I was thinking about adding this to the sheet. How many targets it takes for it to outpace normal DPS is definitely something to know. With the patch coming up there will probably be more changes and maybe new features, I should get a full thread going on the forum.

Chaotic is still best, you can always play with different setups in the sheet to see.

I'm attaching a version of the sheet with an "AoE" tab (between "Other Spells" and "Rotations"). You specify:

1) Eclipse-state
2) Duration (clips a DoT or a rotation)
3) The number of targets an AoE can hit
4) Number of Lunar Shower stacks

It tells you the DPET of each spell (other than Roots) if it is your next cast.

It also tells you the DPS of two "simple" rotations (including ramp-up time and loss of ticks at the end of the fight)

Rotation 1: Tab-MF-Spam
Rotation 2: MF/IS Priority list
2a) MF DoT on as many targets as possible.
2b) IS on as many as possible.
2c) MF for DD

Any thoughts on bell of enraging resonance change to proc on normal spell dmg and not just crits? And the big change seems to be the Mandala Of stirring patterns going from a proc of mastery to int. That would seem to be a contender for bis, I've been searching for it's icd on healing threads to no avail.