Sstixx: I like the idea of the automatic multi-gear swaps. One problem is I think it would require macros to work in excel, and they cause security concerns for some people, and compatibility problems for people using open office. Also it would be A LOT of work for Efejel to setup, (but since I'm not doing the work it would be worth it )

The point to having the sheet select for you would be so that it can tell you with your current buffs and fight duration you do more damage by equipping +8int than +4hit +4damage gems, or gear with mp5 and spirit vs +damage and hit. If you already know that you want +hit more than +damage then you can just look at the gear and pick the ones with the higher numbers.

What I would like to set on an automatic gear swap is options for "requires insect swarm", "only arcane", and "only nature" so it won't select a spell rotation I won't use, (or possibly just a dropdown of what spell rotation to use along with the choice of "any".) Part of why I'm brought to raids is the extra miss chance for tanks, and some fights have high resistances or immunities.

Oh and I just looked at 0.72c. The healing items still aren't there but I understand they might take a while to add them all, back on page 19 I mentioned that the [Armwraps of the Kaldorei Protector] stamina is actually 19 in game not 18 like the spreadsheet says and I noticed that isn't fixed, (not like stamina really matters for a dps calculation.)

Thanks Mog. Hopefully I'll get relevant healing gear added soon, and find time to pick through the full thread for the slight errors like the one with the Armwraps.

I'll take a look at .80alpha this weekend and see if I can make something of it.

Thanks again for the great spreadsheet, I do have some suggestions:

Could you add an option for having more than one of totem of wrath? I am occasionally grouped with 2 elemental shamans and the totem stacks. Also could you display somewhere what the cast time of starfire/wrath/regrowth is with the current amount of haste rating? Also could it list somewhere, based on talents/how many totems you are getting, how much hit rating is needed to cap.

Also could you add the new mad alchemist potion to the mana restore effects section? I use them fairly often now.

Mad Alchemist's Potion - Items - World of Warcraft

one quick suggestion... is there anyway you could work Faerie Fire into your cast rotations (for Imp FF obviously on raids). I'd like to see how much of a DPS hit Im gonna be taking by casting it ;\

You can always add the extra hit and crit on the gear sheet.

Hey Efejel,

Does the current spreadsheet assume FF in the cast cycles? How can I alter the Mystical Skyfire Diamond proc rate and cooldown? Any luck on the new idol proc?

I looked through the spreadsheet, impressive work! Very handy indeed. Although I have a question that feels a bit "noobish" (I just respecced, never played moonkin before); The last cast-cycle in the list is "MFx2, SFx11" - can someone explain that? Two MF after eachother doesn't seem like a good idea because of the dot, or should you use different ranks? And SFx11 would certainly allow the MF dot to expire.. Why is this cast-cycle so effective? (almost always the top dps one).

Anyway, another idea came to mind also, even if it's a bit far fetched. Someone should really use this spreadsheet as a base for an AddOn. You can extract all information about spelldamage, crit, hit, buffs and so on from the AddOn interface, wich would allow to display the Cast Cycle diagram in-game and updated in realtime. Just an idea, any programmers feeling up to it?

MFx2 SFx11 is MF SFx5 MF SFx6

I'm not completely sure but I think for DPS calculations dots are considered to run to full duration as long as the cast cycle is long enough to support that...

IE: MF SFx3 will be less dps than MF SFx4... but MFx2 SFx8 will be the same dps...

It will depent on nature's grace proc If you crit reduced cast time on SF so more SF to throw in while MF is ticking, any setbonus like +3sec duration of MF on 2 set bonus T6 and so on. Rotation of 2xMF 11xSF means nothing else than 1xMF 5,5xSF rotation.

One question can anyone tell me how much ... spell hit rating, 12% hit rating is? Been looking for some clean numbers to see how much I can cut but still maintain capped, even if I'm not grouped with a shaman. (I keep comming up with 0,0795.......... (place more numbers on the dots) and I'm not that good at that kinda math thing ;-)

Great work btw love this Sheet, been and is very helpfull for me in MH and BT, keep up the great work.

152 spell hit rating is the cap, assuming 2/2 Balance of Power and no totems/draenei.

I was going through the Armory to see how many people were using the new Chaotic Skyfire Diamond, but something else caught my eye. Vandiego socketed a Royal Nightseye - Items - World of Warcraft instead of the typical Spell Damage/Stamina gem. Very cute. I'm not in a rush to replace the epic gems I AHed, but I think this is definitely worth keeping in mind.

Maybe I'm not getting this correctly, but on the spreadsheet I'm getting unrealistic ETA on going OOMS. Like having 10 minutes of combat and using no consumables and no innervate and being able to MS/IS/SFx3 over and over without ever going oom. What am I not getting?

did you turned of blessing of wisdom and kings, Judgement of wisdom, mana spring totem, mana tide totem, mana gained from sp, and arcane interlect?

Hmm seems I fixed it... Good Spreadsheet

Wait til you drop a 25k SF on Essence of Anger. (:

Edit: I'd like to use all 11 healing 2 mp5's on my gear once the Chaotic meta requirement is changed. I think the 4 damage 2mp5 will only help considering I'm already over 10k hp raid buffed. But who knows, I really want to go with all Potent Pyrestones, but I need to get my chest, helm, and legs still. And the fact that the GB never ever has pyrestones, I may end up with gleaming lionseyes.

Great thread, and great spreadsheet! Thank you for taking the time to make this resource available to us. As someone who played Feral 1-70 and tanked everything up through and including Void Reaver I had a lot to learn when I recently respecced to Balance. I've been reading everything I could find, but unfortunately there really isn't a great deal of information for Balance, or what is available conflicts.

One question that lingers in my mind is what level of spell dmg, crit, mp/5, and mana should we be shooting for in general at the kara level, gruul/mag, tk/ssc and beyond?

I think I understand from a few sources that about mid-high 700 spell dmg for starting kara. But that is literally all I can find about raiding power levels. Would be very helpful to new balance druids, like me, to have some kind of a gauge to go by when comparing our equipment. Am I ready for Gruul/Mag? Am I ready for TK/SSC?, etc. Anyway, again, thank you for all your hard work.

BTW, right now I have high 700's spell dmg, but only 20% crit (without moonkin or any buffs) in my crappy healing gear I assembled along the way. I plan on running kara again and heroics like mad to get badges so I can put together a 1k+ spell dmg, hit capped, 25% crit suit before returning to TK/SSC. But when I compared my stats with a friend who really has inferrior gear, she has more than 2k more mana that I would in that suit. Anyway, if you could include info about relative levels for each raid I would personally much appreciate it.

I think it's kinda hard to hit 30% crit + if you wanna be hitcapped. Depends on your gems maybe. I've been going hit > +dmg > crit because crit can get you aggro pretty easily especially on trash and its no fun to stop nuking.

Awesome! Thank you so much both of you. Exactly what I was looking for. In regards to MP/5, I guess I'll experiment with it some and see how I can balance it in and stay in around the parameters you've jotted down here.

Thanks again!

To go back a few posts... Any news on that Vandiego? Whatd you find in terms of haste?

Well I realized that was a pretty silly idea as I attempted to build for it. I'm only up to a hundred and change atm. I was thinking about it though, a 4p T5 w/ 216.5 haste rating for a MF/SFx4 is possible though. Not sure where you'll be hit cap wise but its doable. My concern right now is breaking the 50% paper crit line in a raid setting. I'm at 40 and have a ways to go but its gonna be fun. I just need some bosses to start being a bit nicer.

The other balance druid in my guild has 2p T6 and the 165 haste for the MF/SFx5 cycle, he's off for the week though.

Any chance at some WWSs? A lot of theory goes back and forth here and as one of the few balance druids to have Illidan down I think you could give some nice insight.

I've started to do some gear swapping with the spreadsheet, and changing gems each time is somewhat of a pain when trying to compare many items.
Would it be possible to have a default gem setting for blue/red/yellow slot type, and to be able to override it when entering specifig gems for the items, as it's done now ?