Faerdael, thanks for the great work. I have a couple questions.
The screenshot (first post) shows 0 for Explosive Shot under Player Settings. Armory stalking you shows you are 5/15/51, so you have ES, shouldn't there be a 1 in the ES column in Player Settings?
Latency something you guess at? Manually track via WoW client while in game? And what's the units? I typically run 55ms latency, put 55 into Combat Settings->Latency?
Yes, I probably should turn on that talent for myself, eh? Really thats there to be able to flag a shot as something to be tracked; suprising it didnt blow up (infite). Latency is something you would need to get in game. Currently it is in seconds (to be consistent with Gear SS) but I'll probably change that to milliseconds to match in game and provide better granularity.
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!
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.
Given that triggering BW could consume a little less that 2.5% of the GCDs available in a fight at best, it's probably not that important but I guess it would be good to know.
The spreadsheet already allows for Readiness & Rapid Killing, and assumes the use of Rapid Fire when it's available. Kill Command doesn't consume a GCD, neither do any 'on use' trinkets so they don't matter.
I only brought up the the ES/SS or CS/SS ratios above as the optimum DPS cycle may not match the optimum shot count cycle for MM & SV until under the haste soft-cap. As BM is already below that cap, optimum shot count should always equal optimum DPS.
I don't feel this is worth a new thread and I'm still searching for whether this info is up elsewhere here. My WWS reports since 3.1 dropped are not displaying the boss fights. All of the numbers are there, but they are only reported as overall numbers, with no bosses to select from the drop-down menu.
I use NoScript on my Firefox, but using a different browser to post the reports results in the same thing. I haven't seen any announcements on the WWS main page and they seem to have eliminated their forums(?) so I can't report the bug.
It's not a bug with the client, the people running WWS simply haven't set up the bosses on their end so it doesn't know how to split the logs in order to seperate the bosses from each other. I'm assuming it will get done soonish.