Cranch

As mentioned above, lootrank.com already allows putting in various weights for stats and will rank all items in wowhead; it also has a gems optimizer that maximizes the weight added by gems. lootrank doesn't work with item bonuses, nor items that are more complicated (i.e., dragonspine trophy.) Your spreadsheet works with bonuses and complicated items, but doesn't have a gems optimizer.

I'd actually use the gems optimizer more than an item comparison feature, especially when switching items around in the spreadsheet looking for an ideal upgrade path. Right now, I have to constantly correct the gems.

Regarding how to handle +hit, what I did in my separate item spreadsheet (done before lootrank) was list the dps gained both hit capped and not hit capped.

Thanks again for all your efforts on the spreadsheet!