Moonkin DPS Spreadsheet - Page 11

Neshalin · 07/23/07, 3:48 AM

There is a work around until Idol of the Raven Goddess is added. You can select 'None' as idol and simply add the 9 spell crit rating on the gear selection page.

Efejel · 07/24/07, 12:51 AM

Originally Posted by Neshalin

There is a work around until Idol of the Raven Goddess is added. You can select 'None' as idol and simply add the 9 spell crit rating on the gear selection page.

That's a good solution! Especially since updating this is falling ever lower on my life-priorities list. :-/

As far as estimating the DPS that 9 crit rating will have for everyone else in the party... not currently do-able in this sheet. The existing spreadsheets for Moonkin, Elem Shaman, SPriest, Warlocks, and Mages are each amazing & powerful tools, but the also take such unique approaches to calculating DPS that it becomes nearly impossible to integrate them for calculations such as that.

Benita · 07/24/07, 5:01 AM

Well you can estimate it. Something in between 20-35 crit rating on your sheet in terms of raid dps if you were doing comparable dmg to those in your group would be my guess.
It really depends on the amount of affl/destr warlocks, spriests, resto/elem shaman, mages in your group.

In the end the starfire idol is providing more or at least the same raid dps as the Idol of the Raven Goddess, without a headache of estimating the dps it does in your specific groupsetup. A slight threat switch from you to the other casters could be another use for it, but its effect is hardly noticable.

Efejel · 07/25/07, 12:22 AM

0.70e<--clicky

Added Season 2 Arena/PvP gear
Added various other missing gear (not necessarily complete, let me know what I missed)
-Naturewarden's, Elunite, Belt of the Crescent Moon
Fixed slight error in calculating crit rate on Moonfire (was reading from cell with Wrath/Sf rate!)
Added support for Idol of the Raven Goddess (Raven)
Added support for Relentless Earthstorm Diamond
Added support for Tier 5 4-pc. bonus
Added 80 nat/arc flask
Added some missing epic gems (+4 mp5, +10 spi)

NOTE ON NAMING CONVENTION: Gear updates & minor fixes will be noted by letter increments (0.70b, 0.70c, etc.) and only mechanics changes will merit new version numbers. New filefront links will be listed only for new version numbers, "letter" updates will be posted to the same link. Use the "Read Me" page to verify your version number against the first post.

Neshalin · 07/25/07, 3:33 AM

Your new sheet gives me a good 200 dps increase with same gear and buffs. Playing with the numbers a little, it seems mana is ignored. Dps output is always the same, whether the fight lasts 1 minute, 10 minutes or an hour.

Efejel · 07/25/07, 3:36 AM

D'oh! OK, I'll check that out. :-/

Haha... I see what it is. It's the fancy formatting on time till OOM. Will be fixed in ~45 sec.

EDIT: And, fixed!

Neshalin · 07/25/07, 4:44 AM

Almost forgot to say, great spreadsheet Efejel. I find it very useful to plan my gear upgrades in a world of angry mages (raid leader literally said "MINE" when I mentioned Al'ar's Mindstorm Wristbands as a possible upgrade). It looks very tidy and it's easy to enter missing gear myself.

That said, a few more things could make it even better

- The new flask seems way off. It's only 10 more spell damage compared to Flask of Supreme Power, yet supposedly improves my dps by 17. Compare with the first 70 spell damage only giving 36 more dps. If I enter the 10 spell damage manually on the gear select page it gives a more realistic increase of 5.
- On the Weapon Swaps page, if the "high int weapon" has less intellect than the primary weapon, it gives a #NUM! error on additional mana, JoW restore and all calculated dps fields. I know, silly me for not updating the high int weapon when I upgrade my primary weapon or offhand.
- Trial-Fire Trousers, not Tribal.
- Please consider adding Anetheron's Noose, Chronicle of Dark Secrets and Cuffs of Devastation.

Benita · 07/25/07, 6:15 AM

The new flask is called "Flask of Blinding Light".

Some errors:
I selected the Thunderheart Headguard, then the Swift Starfire Diamond as metagem. It shows "Err: 502" in the whole row for that and even with selecting a different headpiece without a metagem it wont go away. Im using Staroffice, did you write it in Excel? Might just be my program fucking up. 0.69 worked fine tho.

One more minor thing, Glyph-Lined Sash and 2 orange gems still keep the socket bonus inactive on the sheet.

And im unable to select a cloak enchant, but i guess that doesnt matter anyway or does the sheet account for spell penetration on nature spells?

2+4 T6 set boni are not in the list on the last page.

Keep up the good work!

Efejel · 07/25/07, 10:56 AM

Thanks, will see how many of these I can fix today.

Efejel · 07/25/07, 4:18 PM

First of all, let me say: I'm really glad people are finding this helpful & take the time to say so. At this point, I only spend any time at all on this because of you folks. Now, on to the other comments.

Originally Posted by Neshalin

- The new flask seems way off. It's only 10 more spell damage compared to Flask of Supreme Power, yet supposedly improves my dps by 17. Compare with the first 70 spell damage only giving 36 more dps. If I enter the 10 spell damage manually on the gear select page it gives a more realistic increase of 5.

There was a slight error here, don't know if it was causing what you're seeing though. The error I found has, of course, been corrected. Let me know if it resolves this issue.

- On the Weapon Swaps page, if the "high int weapon" has less intellect than the primary weapon, it gives a #NUM! error on additional mana, JoW restore and all calculated dps fields. I know, silly me for not updating the high int weapon when I upgrade my primary weapon or offhand.
- Trial-Fire Trousers, not Tribal.
- Please consider adding Anetheron's Noose, Chronicle of Dark Secrets and Cuffs of Devastation.

Fixed (hopefully, lemme know), corrected, addedx3.

Originally Posted by Benita

The new flask is called "Flask of Blinding Light".

Danke.

Some errors:
I selected the Thunderheart Headguard, then the Swift Starfire Diamond as metagem. It shows "Err: 502" in the whole row for that and even with selecting a different headpiece without a metagem it wont go away. Im using Staroffice, did you write it in Excel? Might just be my program fucking up. 0.69 worked fine tho.

Yes, I'm developing in Excel. Can you screenshot your gear select page with the error, assuming it's still present in 0.70c? This was probably related to my failure to assign gem colors to the few gems I added, which has been fixed!

One more minor thing, Glyph-Lined Sash and 2 orange gems still keep the socket bonus inactive on the sheet.

Socket bonus activity (on/off) calculation is compounded when allowing order independent gem selection. (Read: It's hard, I'm lazy. Anyone willing to fix it--decipher the logic in column O on the gear select page, and figure out what the correct logic is--will get mad props on the read me page. Until then, just toss it in the misc. gear selection, or add a custom "Glyph-Lined (SBonus incl.)" item.)

And im unable to select a cloak enchant, but i guess that doesnt matter anyway or does the sheet account for spell penetration on nature spells?

2+4 T6 set boni are not in the list on the last page.

AFAIK, no bosses with partial, non-level-based, nature/arcane resist have been encountered in BC? I'm currently doing NO calculations for: spell haste, spell penetration, threat. Therefore, there are currently no cloak enchants implemented.

4 pc. T6 added. 2 pc. probably not worth the hassle--if there are any 2+ T6 Moonkin out there who are using Moonfire as part of their boss rotation, please post here to prove me wrong.

Benita · 07/25/07, 6:54 PM

I think bosses have a base amount of resist dont they? It gets removed by the curses usually so thats why noone bothers, but since theres no curse for nature dmg (a shame really), penetration could be useful. But i wouldnt bet on me being right on this point.

Spell haste would be interesting. I got 2 BT rings now (Ring of Ancient Knowledge) and my Starfire is down to 2.91 making it somewhat noticeable already.

I got 3/5 T6 and im using Moonfires mostly in multiple mob situations to get the natures grace to proc. I was kinda hoping for info from the spreadsheet if it can compare on a normal tanknspank boss rotation

About the error, its easy to reproduce as i noticed. I just select the Robes of Rhonin and it creates an error on the metagem row and then the totals row. It goes away if you select another chestitem, i just assumed it was linked to the headitem/metagem and thats all i changed then. Im using OpenOffice Calc 2.0.3.

• frmorrison · 07/25/07, 7:27 PM

I looked at your spreadsheet, you are missing 2/5 Tier 6 (adds 3 seconds to Moonfire's DoT).

As to spell cycles, is there a way to change them?
IS, MF, SF, Wx3 would be nice to see.

Also, where is the Force of Nature dps? Anything would be nice to see, even a gray box to show it is coming.

Originally Posted by Efejel

AFAIK, no bosses with partial, non-level-based, nature/arcane resist have been encountered in BC? I'm currently doing NO calculations for: spell haste, spell penetration, threat.

if there are any 2+ T6 Moonkin out there who are using Moonfire as part of their boss rotation, please post here to prove me wrong.

Half of Hydross is nature immune, so spell pen will not help there, no other bosses mess with Nature/Arcane spells.

On the PTR I have 3/6 Tier 6

and use Moonfire

, but I might not know what I am doing.

Efejel · 07/25/07, 10:35 PM

Just occurred to me it's going to have to be a MFx8, ISx10, SFx31 to properly & evenly account for the 3 addt'l secs on Moonfire duration. At which point the "give or take lag, crits, and cast interruption" makes things MUCH more vague.

And, in case I do decide to implement spell haste: if you are hasted to 2.91 sec SF & proc NG, do you get a 2.41 sec SF, or a (2.91/3)*2.5 = 2.425 sec SF?

About the error, its easy to reproduce as i noticed. I just select the Robes of Rhonin and it creates an error on the metagem row and then the totals row. It goes away if you select another chestitem, i just assumed it was linked to the headitem/metagem and thats all i changed then. Im using OpenOffice Calc 2.0.3.

Ah, turns out the Robes are the culprit. Need to have "0 0 0" put in for the sockets on the "Chests" sheet.

Caliane · 07/26/07, 12:05 AM

I could have sworn it was haste effect then .5s taken off that. but I might be tired and remembering it wrong..

2p t6. Honestly, at that point, I would drop IS likely and just do mf/sfx5.
The extra tick wont really increase dps. Though you could say the longer duration increases damage per global cooldown.
But it will increase moonfires efficiency a good amount.

4pc t6, ill be pushing 40% crit on starfire raid buffed and 45% on moonfire. Should be getting 2-3 nat grace procs per rotation.

Insect swarm will be a dps hole at that point. It doesnt scale as well as starfire, or moonfire after CoS. I am not positive, but I do not think the 2% IS miss actaully stacks with standard warrior defence/parry/dodge, miss cap.

(The real issue is 4pc t5 being way way too strong, and its much stronger then any amount of t6 up until 4pc t6. And even after, very possibly STILL better.)

Seems to be something wrong with velvent boots of the gaurdian, btw. Gives me a n/a for char stats when I try entering them.

Efejel · 07/26/07, 12:23 AM

Originally Posted by Caliane

2p t6. Honestly, at that point, I would drop IS likely and just do mf/sfx5.
The extra tick wont really increase dps. Though you could say the longer duration increases damage per global cooldown.
But it will increase moonfires efficiency a good amount.

You'll like the new version. Added a section for custom cast cycles.

4pc t6, ill be pushing 40% crit on starfire raid buffed and 45% on moonfire. Should be getting 2-3 nat grace procs per rotation.

Only 1% more crit on MF than SF after you have 4pc T6.

Insect swarm will be a dps hole at that point. It doesnt scale as well as starfire, or moonfire after CoS. I am not positive, but I do not think the 2% IS miss actaully stacks with standard warrior defence/parry/dodge, miss cap.

I just was seeing the DPS loss of IS & was a bit surprised. I know, maybe Blizzard will see that we have one less thing to add to raids & add a 21-25 pt. talent to double IS's damage & triple it's avoidance value to tanks--of course, they'll put the talent in Resto!

Seems to be something wrong with velvent boots of the gaurdian, btw. Gives me a n/a for char stats when I try entering them.

Yeah, forgot to add them on Boot Sockets sheet. Caught that before you pointed it out, though!