I've been using the spreadsheet for awhile and for awhile it was my main point of reference for any gear choice, still is up there but now I mostly do all the calculations myself. Anyway, if you take a look at my armory you'll notice my hit is fairly low, but the spreadsheet keeps showing that optimally I should be gemming almost straight agi, which I know I get more dps per point from hit then straight agi.
The only reason I can think of is that it is impossible to formulate hit cap and the RNG from misses into dps calculations so the spreadsheet throws itself off. I don't really know, just thought id throw this up there for discussion purpose.
Also it calculates my dps to be somewhere around 1.3-1.4k with my current gear. While in actuality I am hitting between 900-1.1k depending on the fight. Any reason for this or is it more likely I have to re-examine the buffs I am getting, or I guess I could just suck at dpsing which is just as probable but from what I know about pveing I'm not doing anything wrong, other then having a crap computer...heh.