Ok, seems like I've cleared up the major bugs. Anyone who was waiting to download until I was done with this flurry of revisions should now feel free to do so. :-p

This is really pretty easy to do. I'll include it in 0.71, but if you'd like to see it on your current version, do the following:

First, add an option for "Both" to the Idols pull-down menu.
Start by unhiding the Pulldown sheet.


Insert a single cell somewhere between the first & the last existing pull-down options.


(Shift cells DOWN!)


Type in "Both" or whatever you want to call your option.


Now for the slightly trickier part: making sure the addt'l damage is calculated. We need to go to the "Damage Calcs" (clever name, I know) sheet for this.


This is one of the four cells we'll be changing.


Simply change "(Idol_Select="Starfire")" to "OR((Idol_Select="Starfire),(Idol_Select="Both"))"

Do the same thing in cell K4.



The changes for Wrath happen elsewhere. Since the tooltip/spell pane actually updates with the Wrath idol, I figure the addt'l Wrath damage in the spell pane columns.


And the change you make is fairly obvious. Make the same change in C5.





You may want to hide (Alt+O+H+H in Excel, Alt+O+S+H in OO.o scalc) those two sheets once you're done with the changes, so you don't accidentally muck them up later.

I was trying to enter in my current gear via gear select.
And a few things I noticed.


Band of eternity stats are wrong. And there multiple versions of the ring like the violent signet. (though none are choices.)

Neltherions tear is not an option as well.
marshals silk bracers has 12 crit rating in the spreadsheet. its 11 in game.

And there should be a choice to enter -none- for each item, so entering in items manually via the "other" entry form can be done.



Additionally, is it easy to simple edit the stats on items oneself? I know very little about spreadsheets.



And, some more.

On the gear select page, Its showing the correct int, spirit, hit values.
Crit is shown as 17.88%, when I switch to the char sheet/buffs page. the unbuffed slot shows 18.29% crit.

my damage is showing as 1 higher on the spreadsheet, and mp/5 while casting is 1mp/5 lower on the spreadsheet. This could be a gear stat being incorrect as well, but havent found it yet.

There's instructions on adding/changing items a few pages earlier in this thread. It's not particularly complex. I'll update these locally for future versions. Except for Nelth's tear. Pre-BC gear can suck it. The few Moonkin who actually have these items will have to continue to enter them manually because I'm spiteful.

Indeed. I'll get on that.

You probably have Idol set to "Raven", which doesn't update the gear select page. I'll make that change for 0.71 as well.

Most likely it's an in-game rounding error. The correct/exact formulas don't mimic the unpredictable results generated by Blizzard, so I've had to try and apply rounding and addition in manners that are correct as frequently as possible.

Remember that spell damage is determined by (dmg from gear + dmg from buffs + dmg from talents) and that (dmg from buffs = direct dmg + IF(impDS, (spirit * IF(BoK,1.1,1))*IF(impDS = 2/2,.1,.05))) and (dmg from talents = IF(BoK, ((int*1.1)/4),(int/4))). Thus the question becomes does (449 * 1.1) /4 + ((360 * 1.1) * .1) round to FLOOR(123.475) + FLOOR(39.6) or FLOOR(123.475 + 39.6)? What I found while testing was that the answer varied. *shrug*

Positive. Thats odd.
They are 11 resil and 11 spell crit in game.

Well I was refering to unbuffed spell damage and mp/5. That would have been just purely from gear, int, and spirit.
Possiblity of rounding error is there still though.


And yeah, the raven idol was likely the cuase for the shift in crit. I shifted that later.



T5 4pc doesnt seem to work with the custom cycle. Understandable though.


If you could add, mf, sfx4 to the cycles, it is the highest dps cycle late game. Might help people see that though, as many newer players might not.

*shrug* More Blizz weirdness/laziness.

I was playing around comparing set bonuses, and the prediction that 4/4 T5 > 4/4 T6... turns out it's right*, assuming you don't have the T6 chest. The T6 chest + 3 other T6 > T5.

Also, it looks like* the T6 SHOULDERS give the same DPS upgrade as the T6 gloves for us, so you might be in better shape trying to get those, assuming you don't need that extra socket to activate your meta gem.

*- 6 minute fight, fully buffed, highest DPS rotation, semi-mana limited, hit-capped (Totem of Wrath) with pretty much any combination of T5/6, Relentless Earthstorm Diamond meta

Right. Rounding from the talents alone still doesn't follow any reasonable rules.

If you don't want to edit your gear locally, just add a -1 crit custom item.

To be fair, that is the way for Warlocks as well compared to the Tier sets (mostly due to number of sockets and the Warlock item budget being used on stamina, while nice isn't doing dps).

The only exception are the Tier 6 Gloves/Chest.

2.43 it said in the spellbook tooltip.

So, in addition to causing you to OOM faster, spell haste reduces the value of NG... sweet!

A few things.

Whats easier for you efejel? Should I make a list of wowhead items that should be added.
Or should I enter them myself, then upload my .xls for you to just copy?
Theres quite a few bt/hyal items missing.


Secondly is another potential feature.
A spell average effects page.

List:
Starfire: unbuffed Buffed Buff/debuff
Crit %
Average hit
Average crit
Average damage
Average damage/mana.

Insect swarm: Unbuffed Buffed buff/debuff
Average damage
Average damage/mana

Wrath : Unbuffed Buffed Buff/debuff
Crit%
Average hit
Average crit
Average damage
Average damage/mana.

Unbuffed being unbuffed values
Buffed being buffed values but not misery/cos
Buff/debuff being full damage to debuffed target.