Operative Healing Analysis Spreadsheet

[Kaladris]

Request:
I was wondering if you were able to model how each point below one spend in "Medical engineering" alters your calculation.
I am interested in this because of two point:
1) The obvious: If the increases with surge-heavy gear declines heavily without too much output loss, it could be viable to just spend one point into the talent and put the other two in a defensive skill, thus gathering a doubled edge.
2) I am interested in how much of your heavily increased burst efficiency if rooted in the waste of TA-procs, to better estimate the whole outcome on myself without using a spreadsheet.
Furthermore, i think that this knowledge could help us to better estimate given efficiency and put it in context on a more sophisticated level.
(I.e. a question that comes to mind is how you do estimate the worth of a "wasted TA" proc, given the fact that we are talking about a heavily connected cast-frequency model that could contain the possiblity of argueing that "wasting" a proc is surely not a binary thing and has to be compared to the spell that you are casting instead of the other option.)

I hope you were able to get my point and see a possibility to implementing that model, at least for testing.

[Smokeskin]

(02-26-2012 11:44 PM)Kaladris Wrote:  2) I am interested in how much of your heavily increased burst efficiency if rooted in the waste of TA-procs, to better estimate the whole outcome on myself without using a spreadsheet.
Furthermore, i think that this knowledge could help us to better estimate given efficiency and put it in context on a more sophisticated level.
(I.e. a question that comes to mind is how you do estimate the worth of a "wasted TA" proc, given the fact that we are talking about a heavily connected cast-frequency model that could contain the possiblity of argueing that "wasting" a proc is surely not a binary thing and has to be compared to the spell that you are casting instead of the other option.)

I'll work a Medical Engineering variable into the spreadsheet soon. In the meantime I'd like to adress your other points.

Burst efficiency is negatively affected wasted TA procs too in the model. TA procs are only used if they happen while casting Infusion, but wasted if during KI.

In all my rotations, TA procs are wasted if and only if they happen during KI casts. The only way you could prevent the proc from being wasted was if you aborted the KI, and that costs you cast time at least and probably also causes energy to reach 100 which is extremely costly, so I believe the most effective rotation is actually to let them be wasted (during play, I only abort KI casts on TA procs if I'm low on energy). I've considered adding the player's reaction time to it also, as realisticly you can't cast SP if the proc happens 0.1 secs before you plan to cast KI, but so far I've decided against it. Honestly, I think it should be added, but I fear the model won't be accepted by the community.

Technically, it is simply done by eliminating (total time casting KI)/(total fight time) of the TA procs from KP, so they're not available for SP casts.

At my current stats, in the model I lose around 1.40% HPS for sustained healing due to wasted KP procs.

[denDAY04]

I don't see the reason for adding in player reaction time. Theorycrafting is not aiming to be realistic but is done to make us aim towards the unrealistic
So I think the hard facts are better kept alone and not interfered with variables that differ from person to person.

[Smokeskin]

(02-26-2012 11:44 PM)Kaladris Wrote:  Request:
I was wondering if you were able to model how each point below one spend in "Medical engineering" alters your calculation.
I am interested in this because of two point:
1) The obvious: If the increases with surge-heavy gear declines heavily without too much output loss, it could be viable to just spend one point into the talent and put the other two in a defensive skill, thus gathering a doubled edge.
2) I am interested in how much of your heavily increased burst efficiency if rooted in the waste of TA-procs, to better estimate the whole outcome on myself without using a spreadsheet.
Furthermore, i think that this knowledge could help us to better estimate given efficiency and put it in context on a more sophisticated level.
(I.e. a question that comes to mind is how you do estimate the worth of a "wasted TA" proc, given the fact that we are talking about a heavily connected cast-frequency model that could contain the possiblity of argueing that "wasting" a proc is surely not a binary thing and has to be compared to the spell that you are casting instead of the other option.)

I hope you were able to get my point and see a possibility to implementing that model, at least for testing.

v1.2 is up, it has Medical Engineering variable.

At the stats in the sheet, it shows the following sustained HPS loss compared to ME 3/3:

ME 2/3: 0.47%

ME 1/3: 1.18%

ME 0/3: 2.36%

[Smokeskin]

I'm more than happy to update the spreadsheet with requests (within the realm of the possible and practical of course), or explain the calculations or assumptions used if anyone wants to go over it in greater detail.

[Smokeskin]

(02-28-2012 12:17 AM)denDAY04 Wrote:  I don't see the reason for adding in player reaction time. Theorycrafting is not aiming to be realistic but is done to make us aim towards the unrealistic
So I think the hard facts are better kept alone and not interfered with variables that differ from person to person.

I'm not sure I agree. I prefer a model that can, as accuratedly as possible, predict my actual performance - so I can use the numbers to evaluate rotations, gear etc.

In Jagare's spreadsheet, he for example used a KP refresh at 1.5 secs duration left on the HoT, which is probably realistic. I've added this as a variable you can set accordingly, especially for the multiple rolling KPs I think you wouldn't be able to maintain only 1.5 secs on average. You should set it to 0 if you want to get a "perfect play" simulation.

[denDAY04]

But if you include something as unpredictable as reaction time, even if it's only your own, I doubt you will ever see a persistent result that is equal your sheet's numbers simply because you're unlikely to have the same reaction time two days in a row.

It's cool that you added it so that we can choose to use it or not, but I don't think it's of any use really.

[Smokeskin]

(02-28-2012 09:16 PM)denDAY04 Wrote:  But if you include something as unpredictable as reaction time, even if it's only your own, I doubt you will ever see a persistent result that is equal your sheet's numbers simply because you're unlikely to have the same reaction time two days in a row.

It's cool that you added it so that we can choose to use it or not, but I don't think it's of any use really.

I haven't added in reaction time - I've only kept Jagare's 1.5 sec early KP refresh as an assumption (though I've added the option so people can change it if they want).

I'm not sure I follow your line of reasoning regarding persistent results. What I want is a tool to estimate the effects on rotations, specs, and gear. In actual play, sure I have off days, I make mistakes, the encounter has mechanics that mess up my rotation, so I'm not going to see the spreadsheet numbers. But I'd still rather have a model that, as good as it can and with all the uncertainties that come from stuff like this, tells me how things will most likely work in real life. Deliberatedly introducing systematic errors by using unrealistic assumptions like "I'll always refresh KP the microsecond it ends" seems counterproductive to that intent.

But it is only the perfectionist in my that worry about the reaction time. It has very little effect on the actual numbers - it changes the relative weights of Alacrity and Surge by about 2%, so you'd prefer 100 to 101 instead of 101 to 100, which is totally inconsequential.

Ahem. And that was some theorizing about theorycrafting

[CaseyTheRetard]

The spreadsheet models total healing done by KP in O16 and O31 as [# of targets] * 2 * [1-stack tick size] * ([fight length] / 3 - 1/2). This suggests that 2-stack KP will tick [fight length] / 3 - 1/2 times per target. This isn't wow where refreshing a hot/dot just extends the duration, dots/hots clip. Practically speaking, since those KPs are being refreshed, each target should be losing 1/2 tick on average per refresh. That will total 1/2 * [fight length] / ([duration] - [early refresh]) lost ticks per target, so [# of targets] * 2 * [1-stack tick size] * ([fight length] * (1/3 - 1/2 / (18 - [early refresh])) - 1/2) should give a more accurate estimate of total healing from KP.

[Smokeskin]

(03-01-2012 03:32 PM)CaseyTheRetard Wrote:  The spreadsheet models total healing done by KP in O16 and O31 as [# of targets] * 2 * [1-stack tick size] * ([fight length] / 3 - 1/2). This suggests that 2-stack KP will tick [fight length] / 3 - 1/2 times per target. This isn't wow where refreshing a hot/dot just extends the duration, dots/hots clip. Practically speaking, since those KPs are being refreshed, each target should be losing 1/2 tick on average per refresh. That will total 1/2 * [fight length] / ([duration] - [early refresh]) lost ticks per target, so [# of targets] * 2 * [1-stack tick size] * ([fight length] * (1/3 - 1/2 / (18 - [early refresh])) - 1/2) should give a more accurate estimate of total healing from KP.

Thx Casey, didn't know that. I've updated the formulas accordingly.

That's a really good catch, good job