Operative Healing Analysis Spreadsheet

[Smokeskin]

I've developed this spreadsheet based on Jagare's work.

Googledocs Spreadsheet

Upgrades include

- Analysis of burst and AoE healing
- Correct surge formula
- Factored in that TA procs from KP are wasted during KI casts
- Use fractional casts rather than whole amount of casts to better reflect stats over fights of varying length
- Always balances sustained rotations to neutral energy usage, as in reality we don't know when fights end and so can't aim for ending at 60 energy
- Added change fields for easy comparison of shifting stats etc.
- Added case fields to easily compare several setups
- v1.1: Added option for rolling KP on multiple targets
- v1.2: Added Medical Engineering as variable.
- v1.3: Patch 1.2 changes implemented

The most surprising finding is that Surge Rating quickly becomes worth very little. At Surge Rating 350, Alacrity becomes better for sustained healing. At 300, Surge is only marginally better.

What this analysis also shows that for burst healing, Alacrity is much, much better than Surge, at 300% to 600% more output per rating point. For this reason, I'd prefer Alacrity over Surge already after Surge Rating 250.

Any comments or questions are very welcome

EDIT: v1.1 added
- Added PvP set bonus
- Added KP HoT rolling on multiple targets. Simulation includes higher TA proc frequency.
- Added option for setting time for early KP refresh. When rolling HoTs on multiple targets, it is unrealistic to assume that all KPs can be refreshed with only 1.5 sec duration left on average.

[denDAY04]

I get a lot of #NAME? in the cells. Know why?

I have a feeling that it might be due to the formula used in B15 16 and 17 because I've never seen the code [] used before. (FYI I'm not using an English Excel but a Danish.)

Edit:
Apparently it is those three cells, because when I enter in my values manually the spreadsheet works as intended.

I will also remind you that as of yesterday's patch (1.1.4) KP and Nanotech should benefit from Medical Therapy ( don't know if it's been verified)

[Smokeskin]

(02-24-2012 03:36 AM)denDAY04 Wrote:  I get a lot of #NAME? in the cells. Know why?

I have a feeling that it might be due to the formula used in B15 16 and 17 because I've never seen the code [] used before. (FYI I'm not using an English Excel but a Danish.)

Edit:
Apparently it is those three cells, because when I enter in my values manually the spreadsheet works as intended.

I will also remind you that as of yesterday's patch (1.1.4) KP and Nanotech should benefit from Medical Therapy ( don't know if it's been verified)

I don't get these errors, even when I access the document not logged in. Anyone else get his? What browser?

The formulas should be:

B15 = (5 + 30 * ( 1 - ( 1 - ( 0.01 / 0.3 ) )^( (D32 / 50 ) / 2.5 ) ) + 30 * ( 1 - ( 1 - ( 0.01 / 0.3 ) )^( (D33 / 50 ) / 0.45 ) )) / 100 + D25 +D26
B16 = (50 + 30* ( 1 - ( 1 - ( 0.01 / 0.3 ) ) ^ ( (D30 / 50 ) / 0.11 ) )) / 100
B17 = D27 + 0.3 * ( 1 - ( 1 - ( 0.01 / 0.3 ) )^( (D31 / 50 ) / 0.55 ) )

I've fixed the Medical Therapy, hadn't seen the patch notes. Thx

[denDAY04]

Aight that fixed it.
For some reason the formula is just very much different when I download it, but replacing them with those you've just written fixes it.

[Servi]

If you remove those spaces in the formula the problem should be fixed.

Requests:
- 2-piece PvP set bonus
- KP on multiple targets in AoE-Analysis

[sipylus]

Hey just having a quick look - I may be stupid but it seems like you're casting Infusions faster than the GCD in your calculations to me.

Not sure if that's an issue yet, but it makes me deeply suspicious from the start, so maybe some explanation of that in the Burst section at least would be good.


Cheers

[Smokeskin]

(02-26-2012 07:40 AM)sipylus Wrote:  Hey just having a quick look - I may be stupid but it seems like you're casting Infusions faster than the GCD in your calculations to me.

Not sure if that's an issue yet, but it makes me deeply suspicious from the start, so maybe some explanation of that in the Burst section at least would be good.


Cheers

The 1.5 sec GCD is only for instants. Cast time spells can go below 1.5 sec cast.

[sipylus]

(02-26-2012 08:26 AM)Smokeskin Wrote:  

(02-26-2012 07:40 AM)sipylus Wrote:  Hey just having a quick look - I may be stupid but it seems like you're casting Infusions faster than the GCD in your calculations to me.

Not sure if that's an issue yet, but it makes me deeply suspicious from the start, so maybe some explanation of that in the Burst section at least would be good.


Cheers

The 1.5 sec GCD is only for instants. Cast time spells can go below 1.5 sec cast.

Ok that's true - but you still have the GCD to deal with. Like, you can clutch your heal by .2 seconds or whatever, but you can't actually cast the next one until the GCD finishes - unless there's an undocumented change that allows alacrity to reduce the GCD ?

---

(02-26-2012 08:31 AM)sipylus Wrote:  

(02-26-2012 08:26 AM)Smokeskin Wrote:  

(02-26-2012 07:40 AM)sipylus Wrote:  Hey just having a quick look - I may be stupid but it seems like you're casting Infusions faster than the GCD in your calculations to me.

Not sure if that's an issue yet, but it makes me deeply suspicious from the start, so maybe some explanation of that in the Burst section at least would be good.


Cheers

The 1.5 sec GCD is only for instants. Cast time spells can go below 1.5 sec cast.

Ok that's true - but you still have the GCD to deal with. Like, you can clutch your heal by .2 seconds or whatever, but you can't actually cast the next one until the GCD finishes - unless there's an undocumented change that allows alacrity to reduce the GCD ?

OK nm - did some reading on the theorycraft forums, there's some evidence that the GCD is reduced for casttimes, sometimes. Has there been any clear support of that from BW?

[Smokeskin]

AFAIK all testing shows that alacrity will reduce cast times below 1.5secs. Either way, it won't really change the conclusions - the different results from previous spreadsheets comes mainly from them using the old surge formula, wrongly assuming no TA procs are wasted, and setting an arbitrary fight length. Those are real, obvious errors.

[Smokeskin]

(02-25-2012 12:32 AM)Servi Wrote:  Requests:
- 2-piece PvP set bonus
- KP on multiple targets in AoE-Analysis

v1.1 added
- Added PvP set bonus
- Added KP HoT rolling on multiple targets. Simulation includes higher TA proc frequency.
- Added option for setting time for early KP refresh. When rolling HoTs on multiple targets, it is unrealistic to assume that all KPs can be refreshed with only 1.5 sec duration left on average.