Having finally got to play with this, I have some questions about haste related buffs:
- Does the spreadsheet just assume the reapplication of heroism/bloodlust as they're available, i.e. every 5 mins for if the fight is at least 5mins long? If not, could the sheet be changed to a percentage up-time figure as the data is in the WWS for that?
- Is it possible to change the %3 haste aura (I assume this is Swift Retribution from the ret pally tree) to a percentage rather than a flat application? If the Ret pally in my raid is a noob & dies, currently the spreadsheet will overstate my max shots.
Separately, it would also be nice for the results fields to protect against 0 in the divisor rather than the numerator as they currently do. I put values in for my aimed shot usage and got a #DIV/0 error because I forgot to indicate I had aimed shot available. That's obviously my own fault but it would be nice for the results to be a little more user friendly.
One last feature request: could you build in a way to track a collection of fights in a single spreadsheet, similar to the idea of profiles in shandara's spreadsheet. Being able to compare different fights in the same raid, or the same fight over multiple weeks would significantly enhance the spreadsheets diagnostic capabilities, e.g. I can see if my rotations on patchwerk are improving, or I can see how different fight mechanics affect my ability to maintain an optimal shot rotation. And for the super lazy, could the spreadsheet figure out when I have entered my % of cit shots (the default WWS display) and do the math for me, e.g when the crit_value is < 1 dividing the hit_shots by (1-crit_value)?
PS: did I mention what a great tool this is? Great work!
EDIT:
Replying to a post in the SV thread, reminded me of another feature request.
This post in that same thread laid out the math for determining how long you can afford to delay an ES in your rotation to complete an SS before it becomes a net DPS loss. Is there any way to work that into calculations your doing to more accurately measure the affect of the ES/SS ratio in a fight. Presumably the same effect and mechanics exist for MM with the CS/SS ratio. If I get bored or need further ways to avoid work I may take a shot at this myself but it doesn't hurt to ask.