OK, so i give up, i have to ask a perhaps stupid question... I've been using an older version of the spreadsheet for a while and it has done wonders my DPS, kudos Cheeky!

I recently upgraded to the latest version, with a 'gear planner' tab, which looks cool. However, this is what frequently happens:

I have the gear set up, press 'calcAttributes', go into the gear planner and press sort. If i then have an item which according to the gearplanner is #7 and go into the "gear" tab and switch to one of the supposedly better items on the list, my dps shrinks! I whould have expected it to rise since i switch to an item which is better according to the gear planner.

I'm mostly, of course, playing around with items that puts me above/under hit and haste caps, so i was thinking that it was something to do with that, the "treat hit" option is set to "based on current" but i have noticed it has little effect to change it.

Any input and/or pointers would be most appreciated.