I want to use the spreadsheet to see if I should switch any pieces out, but I'm having trouble figuring out how hit is taken into account.
I have 13% hit on my gear and 1% hit from talents (then I use misery to get to 17%). I think misery is taken into account on the spreadsheet. Considering this should put me at the hit cap, I'm confused why my DPS goes up slightly when I use the 40 hit food. Since I'm capped at 17% shouldn't the extra 40 hit rating do absolutely nothing?
Also, the spreadsheet says that for my gear set each point of crit is worth more than haste. Is this because I have so much haste already? I was under the impression that haste was more valuable for affliction warlocks.