Current production release: Updated 2008.04.23
0.80c: Moonkin DPS - v0.80.xls - FileFront.com (notes)
Suggested version: Updated 2008.08.18
0.81alpha: Moonkin DPS - v0.81alpha.xls - FileFront.com

>>>FREE Spreadsheet Viewer (OpenOffice.org)<<<

Please also visit the "ThinkTank!" http://elitistjerks.com/f47/t21687-druid_balance/

FAQ
Q: My spreadsheet shows an estimated XXXX dps, but I can only pull off YYY dps despite my best efforts. What's going on?
A: DON'T PANIC. The spreadsheet tends to over-estimate. Make sure you've got the correct buffs selected, the latency is set correctly, and your fight duration is accurate. Now assume a 4-5% DPS loss if you're responsible for Faerie Fire. Each addt'l 10-15 seconds not casting (looking for the corpse of that damn rogue you have to B-rez, for instance) on a 6 minute fight can be another 5% DPS loss.

Q: Why do I sometimes see odd (and/or prime) spell rotations that don't factor out correctly, like Mfx2, Sfx11?
A: The spreadsheet is based on averages. A rotation like Mfx2, Sfx11 on the spreadsheet becomes Mfx1, Sfx5, Mfx1, Sfx6--depending on when you get the expected number of NG procs, etc. To best emulate these numbers in game, you simply want to keep your Moonfire on the mob without overwriting the last tick (sometimes called "clipping"), refreshing each time it's off without delaying your Starfire casts.

Q: Your spreadsheet shows I'm capable of X and my buddy's spreadsheet for his {mage, s-priest, ele/enh shammy, lock, hunter, rogue} suggests he should be doing less DPS, but he consistently beats me on the meters. Why?
A: Spreadsheets use different methodologies & make different assumptions, the numbers they provide are relative and aren't directly comparable. That being said, if you're getting spanked by your buddy in spite of posting WAY BETTER spreadsheet numbers, and out-gearing him in practice, try recording your fights (Fraps if possible, WWS if not) and look at how close you're coming to actual ideal consumable usage & cycle timing.

Q: How do you calculate for activated trinkets/potions and proc trinkets/set-bonuses/rings/idols?
A: I don't. Except for predictable mana restore effects, which can be easily averaged, the effects of proc-based (Mag's Eye, Quag's Eye, TLC, Sextant, etc.) and activated (Icon of the Silver Crescent, Scryer's Bloodgem, etc.) trinkets and the like are IGNORED. You'll pretty much be left to your own devices & the opinions of other experienced Druids to assign a numeric value to these effects, especially ones which are fight & spell-cycle dependent. Addt'l note: the "Moonfire" idol option is for the pre-BC "Idol of the Moon".

Q: The spreadsheet shows higher DPS with item X over item Y, but that doesn't make sense to me. Why does your spreadsheet lie?
A: The cake is a lie, the spreadsheet is an approximating & averaging algorithm. If you don't like the suggestions you're getting, no one is making you take them. And while the spreadsheet can easily be off by a few percent, be aware that it's cumulative 1-2% increases in DPS that got you where you are now from where you were when you were wearing AH & quest reward blues/greens.

Related Questions (moonkin specific, but not about spreadsheet)
Q: Is Improved Faerie Fire a good investment of points?
A: Depends on your raid make-up. It will definitely increase the threat generated by your main tank. How much that will help your raid, and the direct effect it will have on your other melee DPS depends on how many of them dual-wield, their gear level & how close/far they are from the hit cap.

Q: Is Force of Nature better than an additional point of threat reduction?
A: If you're getting Blessing of Salvation, if your raid is comfortable with allowing you to cast them, and if you remember to cast them, yes, it's better than an addt'l point in Subtlety.

Q: What's the ideal group make up for my Moonkin?
A: Are you trying to maximize the moonkin, or the raid as a whole? Your raid has a unique make-up so there's no general answer for this. We do, however, go great with Shadow Priests (at least, they help us alot), Elem/Resto Shaman, Dest Locks, Mages (regardless of spec) and to a lesser extent BM Hunters, Holy Pallys and Holy/Disc Priests.

Q: Should I use idol swapping macros?
A: Not in 2.4.3 or later.

Previous releases:
0.72c (notes)
0.71b (notes)
0.70e (notes)
0.69 (notes)
0.68 (notes)
0.67 (notes)
0.66 (notes)
0.65 (notes)
0.61 (notes)
0.60 (notes)
0.50

Other (simplified) spreadsheets by others:
Elitist Jerks - View Single Post - Moonkin DPS Numbers/Comparisons
Elitist Jerks - View Single Post - Moonkin DPS Numbers/Comparisons

Try the following:

Go with your "normal"--not boss--gear, but add ~150 hit rating (I added a "Target level" setting in the next version, but it's currently undergoing construction so I'm not really able to post it.)

Turn most buffs off. I'd say leave MotW (talented if appropriate), Superior Wizard Oil, and Blackened Basilisk--this is about what I normally use in a 5-man.

Set fight duration to 2 minutes, turn all the mana restore potions/consumables to "No" and Innervate to 1 @ 1.5 min.

Select the Wrath idol.

Set Curse of Shadows & Misery to 0. (Or just turn Curse of Shadows off).

Make sure Mystical Skyfire Diamond is "No".

Hopefully it nets you something like this:



EDIT: P.S.-I implemented the Wrath idol as an additional 25 +dmg for Wrath only. So, it's only adding ~ 25 * .78 = 19.5 dmg to Wrath. This is the conservative estimate--I haven't tested it yet (it's on the "To do" list) but it could be as much as 27.5 dmg, which will skew things a bit more.

Uploaded version "0.6".

Notes:
Added target level pulldown
Partially-implemented gear selection
Implemented most of the previously greyed out World buffs.

Spreadsheet was set to demonstrate a fight vs. level 72 mob but "6% resist" was inadvertently set to "Yes". Set that to "No" for more accurate results.

Found & fixed a couple of errors where it was still assuming 17% boss miss and not taking into account level. Also found & fixed some order of operations errors with partial resist, while I was at it.

it seems like the "Approx time till OOM" is too low. I was extremely overestimating the amount of mana I would have/regen, and most cycles still say I would go OOM before the end of a 5min fight (including pots, regen flask, food, innervate, shadowpriest, mana tide, etc).

I tried playing with the time using the 5s spirit regen, and adding a full minute of spirit regen netted me less than an extra second of fight before running oom. I'm guessing either it's not all worked out in that department, or something is off.

also, is nature's grace included?
edit: nvm just saw the talents section

Can you post a screenshot of the Character Sheet & Buffs page, and let me know if you changed Dreamstate/Moonglow/Intensity at all?

This is what my spreadsheet (v0.61, as posted) looks like when I set things up for about how Gruul goes:
Now, take away the Shadow Priest and things turn ugly pretty fast.

I'm not sure what coeff. is given based on down-ranking, but I doubt Starfire follows the (level + 4) convention, as many of the gaps between ranks (5@50 vs. 6@58, 7@60 vs. 8@67) are much greater than 4 levels. Similarly, many of the Wrath gaps are > 4 levels by a fair amount. I'm inclined to lean towards the (level + 6) convention, but I'm not even sure that's accurate.

I know personally, I down-rank to Starfire 6 quite frequently and note that my pre-debuffs damage changes by ~100 (1550 vs. 1650 average non-crit) for 50 mana saved per cast. 6% less DPS for 15% less mana.

If I get the time to determine the actual coeff. for downranked Starfire & Wrath, I'll look at adding those options to the sheet.

According to http://forums.worldofwarcraft.com/th...sid=1&pageNo=1

its (spell level+6)/character level.
this changes the values above to -

Wrath % SD % Mana Effectiveness
7 74.29% 61.00% 103.26%
8 85.71% 71.00% 110.57%
9 95.71% 82.00% 112.94%
10 100.00% 100.00% 100.00%
Starfire
5 80.00% 74.00% 100.80%
6 91.43% 85.00% 105.14%
7 94.29% 92.00% 101.83%
8 100.00% 100.00% 100.00%

%SD = % of spell damage applied due to "downranking"
% Mana = % of mana that this rank costs compared to the highest currently available rank.

Effectiveness calculated as (%SD+(1-%Mana)x%SD) or more simply , how much damage you get from the same amount of mana as a top ranked cast.

Looking at it this way it looks like rank 8 & 9 of wrath will give you most over a static mana pool.

Digression --- with mana being so important, what relative value would you assign to something like an alchemist's stone(using super mana pots its an additonal 40 mp5, with fel mana it becomes closer to 53 mp5)?


I really like what you have done so far though. nice job.

Has anyone found anything wrong with the mechanics in the latest version?

I've been working on cosmetic enhancements & fully implementing the gear selection window, but I'm more interested in the accuracy of the calculations I'm doing.

I just hopped on the PTR & did some quick testing. It seems that the Wrath idol will actually update the in-game tooltip, and is affected by Moonfury. The Starfire idol will NOT update the tooltip, but is similarly affected by Moonfury. Neither appears to be affected by Wrath of Cenarius.

I looked at the Moonfire idol in my bags and.... decided I didn't care that much.

I'm uploading a new version, 0.65 with the following features:

Wrath & Starfire idols should now be factored more accurately.

Conditions are set to mimic those present in this thread: http://forums.worldofwarcraft.com/th...01801597&sid=1
I'm pleased to find that the spreadsheet predicts an IS:SFx4 rotation as doing 280,065 dmg and Horao's screenshots show 280,223 total damage. Clearly the fight went 4.25 minutes + 1 IS tick, in reality.

Cosmetic improvements, included automatic highlighting of the highest DPS cycle.

Gear selection page has seen continued additions, but is still not complete.



Additionally, I don't expect to be able to do much more work on this in the near future, but I should be able to handle simple bug fixes. And if anyone else is interested on doing further work on the Gear Select page, you can get in contact with me via PM to ask questions or to give me newer versions to upload & link.

I assume you're not including Moonfire crit in the calculations for Natures Grace procs.
Damage_Calcs W2: =(((3.5-(0.1*Starlight_W))+Latency))*(Sf_p)*(Sf_p)