Is it possible to account for the latent regain on Moonshade earring in the spreadsheet? I imagine it's difficult to get a perfect picture since as opposed to Atma it's not a constant regain and instead only works when engaged. But what about at least just assuming a constant 1/tic regain from Moonshade to at least provide a useful comparison between other earrings for a given lenghty fight? Somewhat related would also be SCH's Adloquium or COR's Tactician's Roll (another tricky one since depending on number and AF3+1/+2 gear, amount of regain can vary).
Even if it is possible, could someone with more Excel knowledge than me describe how to edit the spreadsheet to show the effect? I know how to add gear to the gear list, but Regain isn't a normal stat and I don't quite understand how to modify the main "Regain" formula on the main Calcs page to reflect the extra Regain from Moonshade (I imagine you'd have to reference the equipped earring, and if that = Moonshade, add some Regain - I don't know the proper syntax to write the formula though).
The reason I ask is that I'm having a hard time comparing the benefit of Moonshade latent Regain (mine is Acc+4/Regain, and yes I know I'm likely capping Acc already in many situations) versus Aesir for my non-Brutal TP earring. As a practical matter, I tend to just manually switch my TP gear macros to choose between Aesir/Moonshade before an event depending on whether I feel the overall benefit of the Regain would be helpful. Particularly in Abyssea runs where we're focusing on hitting a lot of procs, I use Moonshade (I'm actually often using VV atma and idling on Staff in such cases, for 3/tic regain if I'm engaged - I'll switch to H2H on longer fights once we hit the procs or eliminate Staff as a possibility). Otherwise I use the currently widely accepted Brutal/Aesir combo. But I'm starting to wonder if it's not just worth keeping Moonshade as my fulltime TP piece regardless of situation, and I'm having a hard time weighing the two.
Any suggestions appreciated.
Edited, Aug 3rd 2011 6:10pm by Anza