Thanks for your feedback, it is appreciated.
Yes you can go back and pick other options on each tab just as long as you don't filter another rootsum. Yes the Root Sum in the yellow box on the "RootSum" tab will change each time you run the filter on the H/C tab (it was meant to be a convenience) so just remember to change the RootSum in the yellow box on the RootSum tab to the proper value for you to start another round of filtering. Otherwise you could edit the code for the H/C Filter Button. Just right click on the button, choose assign macro, and then click Edit. In the code put an apostrophe in front of the line of code that reads:
Range("RootSum!K3").Value = Range("RootSum!K3").Value + 1
should look like this when done:
'Range("RootSum!K3").Value = Range("RootSum!K3").Value + 1
(when you scroll or arrow off that code it will turn green which means it is now disabled.) Now when you click the H/C Filter button, it will do everything the same EXCEPT update the RootSum value in the yellow box on the RootSum tab to the next value. You'll have to update that yourself.
For the AHP weights please see the AHP_Example.xlsx I posted and read the AHP papers listed in the reference section of the paper I posted. It is the values in the YELLOW cells on the AHP tab that determine the weights.
I have not been tracking the winning AHP values as they are really determined by the current statistics for each of the filters. So I believe it is more important to track the filters and try to determine patterns and relavance there. But if you do decide to track them for a while and find so important correlation, please do inform us.
Again, thanks for your feedback, it helps make this a better tool.