Originally Posted by Shandara
As for the Gear Planner, I've been considering how to 'fix' it so comparisons between 1h and 2h are accurate, but Excel formulas are such a kludgy way of doing it.
|
My suggestion on how to do this would be to always compare the gear planner items as though they have the "default" enchant.
So, for example (using version 87a for this example), Melee!C145 currently reads:
=VLOOKUP(GPMHEnchant,MeleeEnchantStats,3,FALSE)-VLOOKUP(MainEnchant,MeleeEnchantStats,3,FALSE)
I suggest a change to something like:
=IF("Gear Planner"!I102<>"2-Hander",0,(VLOOKUP(GPMHEnchant,MeleeEnchantStats,3,FALSE)-VLOOKUP(GP2HEnchant,MeleeEnchantStats,3,FALSE))/2)
(and the same for the OH enchant adjustment, but using GPOHEnchant instead of GPMHEnchant). Similarly, change Melee!C147 to something like:
=IF("Gear Planner"!I102<>"2-Hander",VLOOKUP(GP2HEnchant,MeleeEnchantStats,3,FALSE)-VLOOKUP(GPMHEnchant,MeleeEnchantStats,3,FALSE)-VLOOKUP(GPOHEnchant,MeleeEnchantStats,3,FALSE),0)
(Disclaimer: I haven't actually tried these, there's probably at least a few typos somewhere, but you get the idea)