Today is a sad day as Karthis, of my original home server, Garona, will be hanging up his claws. It seems the game has lost it's pull for him. I will miss perusing his blog for some great feral information.

Good luck, Karthis, and as always, may Nature guide your Path!
/salute

In other news, Graylo has pumped out a very nice excel spreadsheet for modeling purposes. I'm gonna link his post, and not the spreadsheet so that you can understand what it is and what its purpose is.

Moonkin Stats and Graylo's New Model

There will be a series of blogs coming shortly that deal with the theoretical damage of both eclipse cycles, some interesting thoughts (hopefully) on DoT uptime, and other such rotation based musings. See you soon!

DOUBLE EDIT: I updated the spreadsheet, took out all of the separate gear lists, cleaned up the interface a little bit, double-checked some of my pointers and feel a lot better about it as a whole.

Download it here!

If you're interested in helping make the spreadsheet better, leave me a message with gear you think I'm missing. I'm no good at crawlers or automation so I'm doing most of this by hand and I'm sure I've missed bits and pieces.

A big thanks goes to Murmurs for the Lunar cycle numbers as well as a plethora of formulas so that we could have a comparative Solar cycle. I have incorporated these values into a page of the spreadsheet based on your current gear and your BiS list.

Lunar Rotation Scaling

Percent of Damage: Insect Swarm: 12% Moonfire: 10% Starfire: 50% Wrath: 25% Starfall, Force of Nature, proc effects: 3% (ignored due to complications)

Spell Power - (0.14957948 * .12) + (.10524679 * .10) + (1.1023188 * .50) + (1.1865983 * .25) = 0.876283192

Haste - (0.0113592254 * .12) + (0.00841851174 * .10) + (1.05240836 * .50) + (0.411537562 * .25) = 0.631293529

Crit - (0 * .12) + (0 * .10) + (0.878345459 * .50) + (1.05686234 * .25) = 0.703388314

Spirit - 0.876283192 * (15/100) = 0.131442479

Intellect - (0.275459945 * 0.703388314) + (0.876283192 * (12/100) = 0.298909289

Okay, so, I know what people are thinking "What!? Crit is so not better than Haste for a Lunar Eclipse rotation! You've done something wrong!" Well, I may have done something wrong, but I don't really think I have, and, if anything, I favored Haste more than Crit in my calculations. The out come isn't all that odd though, and does make some sense. Haste is far better than Crit is when casting Starfire, there is no doubting that, however Haste is essentially worthless for Wrath at this point. However, and here's the fun part, the more Crit you get, the lower a percentage Wrath is going to take up in your rotation, thus increasing the portion of Starfire and netting more gain from Haste. I looked at a wide variety of DPS reports in order to construct these percentages, and I'm quite confident that they are accurate. As I recall, the highest Starfire percentage I saw was from a Druid on Hodir where he had 60% Starfire, and 27% Wrath - although he didn't use Starfall nor Force of Nature (which I thought was odd.)

Do not read this as me saying, or even the data suggesting, that Druids using a Lunar Rotation go out and stack crit and toss out all of their Haste. That isn't the case. Druid should always stack to 400 Haste before anything no matter what rotation they are going to use (and these numbers assume that you already have Wrath Haste capped) - at that point you probably want to focus on getting Crit. Trinkets that have an on-use Haste effect (Haste procs too, although be warry of those as a proc during Wrath spam is sadness and you'd get more out of Crit or Spell Power procs then) and Potions of Speed are still your friend. As is Power Infusion.

Solar Rotation Scaling

Percent of Damage:
Insect Swarm: 11%
Moonfire: 7%
Starfire: 32%
Wrath: 46%
Starfall, Force of Nature, proc effects: 3% (ignored due to complications)

Over 400 Haste

Spell Power: 0.877493361
Haste: 0.433181487
Crit: 0.506081945
Spirit: 0.263248008
Int: 0.244704508

Under 400 Haste

Spell Power: 0.87437463
Haste: 0.737575344
Crit: 0.552895115
Spirit: 0.262312392
Int: 0.257225415

Ok, so my synopsis right now is that this wont hold much weight. First, I used Mumurs' theoretical druid to calculate this so that the stats would be relative to his stats. 30% crit, 15% haste, 2700 spellpower. Reading this, we see that under the haste cap, we still benefit most from haste. Once we hit the soft haste cap, crit takes over. Spell power continues to reign supreme (and did so through some very large numbers of haste/crit/SP).

When I ran the calculations for my BiS geared druid, I got some different weights but the rankings stayed mostly constant. I put together one of the highest SP sets I could as well and found that in these instances, crit and haste began to overtake spell power. That said, the high spell power set performed poorly within my DPS model and I would highly recommend against seeking such a thing. Spell power is built in to all of our items with the possible exception of trinkets. You shouldn't actively seek the highest spell power piece, but instead search for the best "secondary" stats on the item. In many cases, the highest spell power piece was NOT the best performing piece given either my weights, Graylo's weights, or Murmurs weights. I'd like to give a nod to Kiliani too, for putting together some very nice dps gear sets. Unfortunately, I could not run his weights because I did not have them.

TL:DR

1. Hit till capped.
2. Spellpower is greater than all =]
3. Haste till ~400 then Crit
4. Int~Spi
5. Going too high on haste with a solar rotation causes clipping during the wrath portion of your rotation. This is akin to lost dps.

EDIT: This workbook is constantly being updated and I will (hopefully) soon have a user friendly version to bring you full of dropdown selection menus, automated importing of the selected item's stats, and creamy goodness. If you think I missed an item (and I know i did) send me a message or leave me a comment. I'll add it in!

I have been working on modeling this DPS spreadsheet for a little bit now. The long and short of this is that this is an alpha release of this. I'm stuck seeing this as I want to see it. So what I need from any interested reader is a review of it. What buffs/debuffs are missing in my dps calculations? The percentages for the rotation came from my own WWS reports on uptime of DoTs and spellcasts all normalized to 100%. Treants and starfall were ignored. Along with this are some other proposed BiS and some musings on NG uptime. If you don't have a pretty good knowledge of excel, you may not want to tinker with this. PS, this is a total clutter. It needs to have all the names cleaned up and much much more. I'm looking for content at the moment, not succinctness nor aesthetics. Thanks!

Moonkin Spreadsheet

I do realize there is a spreadsheet out there called WrathCalcs. I built this to try to get a better understanding of how to model moonkin damage (and thereby choose stats). It is not intended to correct or compete with WrathCalcs in any way.