Well, the correction that is needed & the cells where that correction needs to be posted are in the thread... somewhere. And there's an existing tool for haste analysis, as well as static equations with clear breakpoints. Finally, the discrepancy in the posted spreadsheet isn't too bad, and only approaches misinformation with larger amounts of haste, making it even less of an issue with reasonably obtainable haste values.

I do apologize the public spreadhsheet has an error.

As I am still unable to locate my copy of Windows Office, I'm hoping maybe there is someone with both OO.o and a relatively recent copy of MS Office who might be willing to convert this local .ods to an .xls? If you meet this description, PM me and I'll upload the .ods & send you a link. You can then upload or e-mail me the .xls & I'll post it on Filefront. Hopefully this will be a one-time occurrence, as I know I do have that disc.... somewhere.

Errr... actually, I'll just try and upload what OO.o outputs when I tell it to convert to .xls. If folks are getting errors, we'll have to go from there.

Wrong!

Every time you swap idols the server tells your client to reset the GCD. This extends your GCD by double your ping.

In theory with 0 haste casting moonfire has a cooldown of 1.5 seconds. With an idol swap macro setup to equip an idol on a moonfire cast the GCD is triggered for the spell then immediately re-triggered for the idol swap. If you have any haste, an idol swap will make the moonfire cast ignore it. So no matter what you have a 1.5 second cooldown. If this was true people with 0 haste would benefit from an idol swap, once you hit a certain amount of haste idol swaps would decrease your dps.

Notice I said in THEORY. In practice the client sends "cast moonfire" to the server at time 0. The server gets this request at time 0.2, (presuming a 200 ping.) The server then sends back a "reset the GCD" message to the client, this is received by the client at time 0.4. The GCD should be done at time 1.5, but it is not due to the idol swap GCD reset. at time 1.9 the client has cleared its GCD and you can cast the next spell. Your idol swap just reduced your damage. You now do 1.5/1.9 = 78.9% of the damage you would have done without an idol swap.

Currently even with 0 haste idol swaping on anything other than a starfire will decrease your dps. If your in game results don't show this you're not spaming your keys fast enough.

Come next patch idol swapping will be completly dead.

The idol to use if you have 3 crit happy casters, (including yourself) in your group: idol of the raven goddess
The idol to use if you have less crit happy casters, and no T6 2 set bonus: idol of the unseen moon
The idol to use if you have an insane amount of haste: ivory idol of the moongoddess

I'm not sure on the numbers where the moongoddess becomes better than unseen moon or raven goddess, but it's based off how many starfires you gett off per moonfire.

Before Moonfury, crit, and CoS, unseen moon will typically help three SF's (1% haste with a NG, or 6% haste with no NG) when it procs, giving 1.2*3*140*50% = 252 damage to a rotation. Any lag/movement at all, and it only helps 2*SF, or just 168 damage to the rotation.

Again before Moonfury, crit and CoS, Moongoddess adds 55 per SF. So SF*5 (sure thing with t6, unless you have lag/movement issues) is always better than Unseen Moon. If you don't have t6 and also have no haste, SF*4 would favor Moongoddess, since you'd need two NG's to complete 3 SF's during the Unseen proc.

For MF IS SF*4, Unseen and Moongoddess are almost exactly the same, but slightly favors Moongoddess. Same is true if you use Wrath instead of IS.

Raven adds about 80 to 150 to an SF*5 rotation (depending on your gear level). That is after crit, but before moonfury and CoS. Since the after-crit number for Moongoddess on an SF*5 rotation is close to 320, you can see where Raven is a raid-boost when it affects 3 or more casters who are "like you." At lower gear levels you'd probably want 4 or more.

Summary for MF+SF* rotations:

Raven with four crit-happy casters in your party (counting yourself) and within 30 yards (3 at high gear levels).
Unseen Moon if you can complete SF*3 before the bonus expires, but you use no more than SF*4 in your rotation.
Moongoddess otherwise.

For MF+Wr trash, Unseen Moon.

Avenger for arcane-immune (or other situations were you use Wrath but not MF/SF).

Seems to work fine for me using Excel 2007. Thanks for the update!

Moonfury and CoS are just flat multipliers after the other damage is calculated, so they affect all SF/MF idols the same.

The Unseen Moon idol adds 140 +spell, but only procs 50% of the time and only lasts 10s. Since it is +spell, it gets the WoC boost (20% for SF). 140*50%*1.2 = 84 damage. I thought that Moongoddess was a flat 55 damage. However the Moongoddess description says "by up to", which usually means that the spell coefficient comes into play. 55*1.2 = 66.

If that is correct, MF SF*4 would prefer moongoddess, even if three of the SF could get the Unseen bonus:

Unseen Moon 84*3 = 252
Moongoddess 66*4 = 264

I thought that Rawr and Efejel's spreadsheet both treated Moongoddess as something that ignored WoC. However, I may be misremembering.

You (and other casters in your group) having a high crit level slightly lowers the relative value of the Raven idol (at 0% crit, 1% crit is a 1% dps boost. at 99% crit, 1% crit is a 0.5% dps boost).

Crit and haste affect both the number of SF in your rotation, and the number of SF that would get the Unseen bonus. It still looks to me as if Moongoddess will win if you get more than 3 SF into your rotation (which should usually be the case).

Using my dps simulator (DrBoom) I haven't seen any cases where Unseen Moon beats Moongoddess on average.

In 1.0b, DrBoom still has a 30s cooldown on Unseen Moon. That cooldown was removed in patch 2.4 (at least according to the patch notes). That change is a pretty big boost to Unseen Moon. (Procs every 2 rotations, rather than every 3.5 rotations (12s MF)).

It looks like DrBoom's Moongoddess is getting the Moonfury multiplier, but not the WoC multiplier. Do you know if anyone has tested to see if that is correct?

Hi. I'm a long-time troller, new-time poster here for some DPS input.

Armory: The World of Warcraft Armory

I have access to BT/MH gear. I currently have 4/5 Tier 5 and 2/8 Tier 6. So far I have only been able to push 1,100 DPS (even on most tank'n'spank encounters). My question is, would it be more ideal to use 4/5 Tier 5 (+10% SF damage w/ MF up) w/ Moongodess or 2 pieces of Tier 5 and Tier 6 with some other rotation/idol.

Side note: I am considering dropping 375 LW (Drums) for 375 Alchemy (Sorcerer's Alch. Stone). Which offers the most DPS?

Any advice/constructive criticism is greatly appreciated.

-Euqremba

4T5 is better than anything pre-4T6. In fact, if you're limiting yourself to leather, 4T5+4T6 competes for best-in-slot. So yes, keep your 4T5 on, especially since you're not in Sunwell yet.

As to Drums/Stone, Drums affect 5 people, Stone affects 1. Your call.

I have wondered some about the numbers for spamming starfire compared to spamming wrath. I looked up on the dps calc tab and noticed that for me starfire was set to average casttime of 2.9 sec and wrath to 1.594. How come wrath average a higher than 1.5 casttime? Do it account for some kind of lag or where is that coming from?

There appears to be a slight bug in the buffed mana regen calculation - when the formula subtracts out the stat-based mana regen to get the gear regen, it uses the pre-2.4 formula, but all the other calculations are done with the 2.4 formula. The following formula works correctly for me:

Also, I am seeing 18 points of stats from Improved MotW instead of the spreadsheet's 19, which is consistent with Blizz' rounding down.. I'm guessing Mark should give 14/14/15/16/17/18 stat points.

Thanks for the spreadsheet! I'm definitely hooked