The spreadsheet has a "Gear Optimizer" tab. Guess what it does?
Feature request (I think):
My 9 month absence has left me with severely outdated gear - but I have a lot of it having picked up off set pieces in naxx for progressions and preperation for having to break my hit (or whatever else) and compensating.
That got me started thinking about how to best mix and match what I have and using the spreadsheet to do so.
When I use the spreadsheet one item at a time I sometimes end up with having to switch back in the end because another piece of gear I have - and I got to thinking that it would be beneficial for top end raiders as well.
With my (admittedly very limited) knowledge of Excel programming, it doesn't strike me as a big programming job (of course it stil has to be done, regardless of how big or small it is) but my feature request is something like this;
A checksheet where you can check off what gear you have and an option on the gear planner to only use that gear for calculations - like the overrides in the settings tab.
As it is, you can indeed do this manually by mentally filtering out gear you don't have, but seeing as the calculations change everytime you change a piece of gear it would be very timesaving if the spreadsheet could do the calculations off a limited set of gear.
I don't know if the calculations in the gearplanner are useable, but it seems to me that they do the calculations needed already although maybe a seperate tab for showing these calculations (call it my gear or whatever seems appropriate) would be better?