In my "boss debuffs" column for Hit, Faerie Fire is listed with 47. Any idea why that is? With it, my total buffed hit is over 400 and it is inflicting the buffed results of my gear. Something must be wrong?

That'd be Imp Faerie Fire. Change the 3 in the Imp calling to 0. Fixed.

I am unable to see daggers on the gear list. This includes the use of the "update" button, as no daggers show up on the list of upgrades. I know 2.3.2.4 notes said "Possible issue with daggers not showing up on the list" was fixed, but I've always had this problem. I'm using MS Excel 2007 if this helps.

Also, Seal Fate calculations seems to be horribly wrong. My DPS goes UP when I remove 5 points out of Seal Fate, and that doesn't seem to be quite right to me.

Anyway, thank you for continuing work on a great spreadhseet!

are you sure that Y45 and Y46 in the Gear_Buffs sheet is set to daggers?

As of seal fate bugs. More details of this (what cycles are used? backstab/hemo/ss/mut instants?) would be helpful.

Does it actually increase lower the hit rating needed in boss fights by 47? I had no idea. But if that is the case, why do we talk about hit cap of 363 when fully buffed? Shouldn't it be 315 then? On large boss fights there are usually several tanks, and one of them is likely to be a druid. I mean, since all kinds of other buffs/debuffs are included in the spreadsheets and math that is used here, wouldn't it make sense to talk about 315 hit cap then? I'm just asking, not critisizing, since this was news to me.

In my experience raiding Boomkins are rare and thus having Imp. FF is not something that the majority of the community has access to.

I guess the person maintaining the sheet has a boomkin in his usual setup.

Bug: When you copy a Ranged item to the Gear Upgrade worksheet it copies the Helm slot instead.

Most raiding druids are not boomkins. Most raiding boomkins do not have the imp FF talent. I wouldn't really build around it.

Hmm, I guess that means none of my equipment planning changes made it in, since I fixed that bug too.

We have a boomkin who makes a pretty good argument for not spec-ing improved faerie fire though I do keep pressing her and pressing her.

And that argument is?

Well, looking at this last set of issues...

Murder vs. Humanoid...corrected in the next version

Typos, Midnight Chestguard and Void Reaver corrected in the next version...

Boomkin...hmm...ours just respecced Resto, I'll have to change that anyway...

Daggers seem to be working. I downloaded a copy at work, seems to work fine if you change the cells to the correct weapon types as mentioned below.

Ranged copy issue...Are you sure you are using 2.3.2.6? This was corrected in Dinesh's 2.3.2.5a which was used to create 2.3.2.6. This currently seems to be copying Ranged correctly on my version anyway. I also had corrected an issue with Backs/Cloaks and Trinket 2 not copying to the gear upgrade sheet at all.

Nope, just downloaded it, and my changes are in there. Maybe there was another error I just didn't notice.

edit: crap, should learn to refresh before posting.

What could be really useful is some warning or some way to show when the hit cap is reached, and at what value. Because the way it is now, I am really confused as to when I have reached the hit cap when I try out different gear.

363 Hit rating, +5% from talents = 28%. That is the hit cap for melee combat. The only number you have to worry about is the 363 (unless you have some oddball spec that doesnt include Precision). If your character sheet show you at or above 363, thats when you know you've reached the cap.

EDIT: Wrote without thinking.

Look at the talents line of the gear page. It adds hit rating according to Precision. That's why.

Ok, I see. But that makes it even more confusing. Why not just add a box or field that just said [+/- hit cap]. That way I could keep track of it much easier.

Because the talents add other things as well. Grouping them in a single row only makes sense. If you wanted to know without talents, racials, and socket bonuses added into the mix just look at the total above the one you are mistaking.

I'm not saying to group things differently or change anything. But I really think that the sheet could use a field or some simple way of telling someone how close they are to the hit cap.

Look at your hit % in the top boxes. Don't exceed 28%.

Or look at the hit totals and remember 442 will be the cap in that box. (363 + 79 from precision)