Sorcerer healing spreadsheet

[Asmo]

Hi, I've been using this spreadsheet myself for a while and figured I'd post it in case someone else might find it useful or would like to use it as a base for something more advanced. It is based on this posted by "_Neb" on the official forum. I made it Sorcerer specific and added all our heal spells with and without Force bending proced. It is nothing pretty or fancy at all but it does the job for me at least. You can use it to compare the heal/sec and heal/force values of our different heal spells, use it to calculate stat values or directly compare two different items or item sets.

Just input your numbers in the yellow fields just as they appear on the character sheet ingame. I'm assuming the standard 31/7/2 spec and all those talents are baked into the calculations. With the exception of the 11% will increase we get from talent + our buff but that is of course included in the will number you see on your character sheet already. The only time you have to consider it is if you're using comparative tooltips between two items and cant equip them both to see the actual equipped will values.

I've tried to verify everything with ingame testing and as far as I can tell everything checks out within reasonable allowances. Heal bonus is sometimes of by one decimal. Crit, crit magntude and activation speed match exactly. For the heal values Dark infusion and Dark heal check out exactly. The others are very close, something like within a tenth of a percent or so which I attribute to rounding somewhere.

I'm too lazy to add all the Sage mirror names but everything should be functionally identical as far as I know. With the exception of Revivification which I'm sure most have heard lacks the extra direct heal component for Sorcerers and who knows how the spells will end up with the 1.1.1 patch.

On sheet two I included the rating graphs for surge, crit and alacrity to give a visual presentation of how the diminishing returns look for those stats.

[Mallard]

Thanks for doing the work. Looks good so far

[shmashed]

This is fantastic. I am not educated enough on the formulae yet to know if this is all correct, but if it is, this is an invalueable tool. Thanks

[dulfy]

Oh cool just saw this, thanks for sharing

[Attur]

Thanks Asmo!

[mosmodre]

Thank you for sharing

[turlockmike]

Using this spreadsheet it seems like

FOR HPS it's
Willpower > Alacrity >= power/force power > crit > surge.

At very high levels of willpower, alacrity actually does better than willpower per point.

FOR HPF it's
Power/force power > willpower > crit > surge > alacrity.

Of course crit will be higher value considering that it will allow you to proc a free consumption more often.


Overall I think it's going to be like this

Willpower > forcepower/power > alacrity > crit > surge

Also when you proc forcebending dark infusion is the way to go during high damage phases and innervate otherwise. The HPF and HPS on dark heal is very lacking and not worth casting. I don't think it's worth expending the forcebending proc on the aoe heal either as it would be better to use it on innervate to get the cost efficiency and proc a free consumption.

As far as trinkets go force power/power trinkets are the best and alacricty 2nd best.

Kinda disappointed with how lackluster surge is, but it might scale better with more gear.

[Kaedis]

Quote:Using this spreadsheet it seems like

FOR HPS it's
Willpower > Alacrity >= power/force power > crit > surge.

At very high levels of willpower, alacrity actually does better than willpower per point.

FOR HPF it's
Power/force power > willpower > crit > surge > alacrity.

Of course crit will be higher value considering that it will allow you to proc a free consumption more often.


Overall I think it's going to be like this

Willpower > forcepower/power > alacrity > crit > surge

Also when you proc forcebending dark infusion is the way to go during high damage phases and innervate otherwise. The HPF and HPS on dark heal is very lacking and not worth casting. I don't think it's worth expending the forcebending proc on the aoe heal either as it would be better to use it on innervate to get the cost efficiency and proc a free consumption.

As far as trinkets go force power/power trinkets are the best and alacricty 2nd best.

Kinda disappointed with how lackluster surge is, but it might scale better with more gear.

Here's the problem: Resurgence and Static Barrier don't benefit from Alacrity at all, and nearly third of your effective healing (including Absorbs) comes from those two spells. Assuming you have the 2-set bonus for Innervate and you're casting it on CD, with Static Barrier on cooldown and Dark Infusion as a filler, you're looking at a rough cast ratio of 40% from Innervate, 22% from Resurgence, 28% from Dark Infusion, and 10% from Static Barrier. That means that while Alacrity has roughly a third higher benefit to HPS than Willpower on cast time spells, you lose about a third of that benefit due to Resurgence and Static Barrier.

Surge, on the other hand, has a massive benefit to Innervate (about 50% higher than Willpower on a Force Bending Innervate). Due to the high percentage of your healing that comes from Innervate, this vastly increases the value of Surge.

In fact, if I plug in the stats in that sheet (1834 Willpower buffed, 320 Power, 1210 Force Power, 375 Crit, 235 Surge, 275 Alacrity) into my stat weights sheet (which simply calculates the HPS difference from +10 of each stat, and normalizes this value to +10 Willpower), I get the following normalized stat weights (weighted average across spell usage):

Willpower: 1.0000
Power: 0.9319
Crit: 0.6876
Surge: 1.2623
Alacrity: 0.9103

Now to optimize this, the equivalency point (where all 4 secondary stats have the same stat weight) is the maximum output stat point. This point is given by the following constraint equations (all 3 must be true to be at the equivalency point):

Crit = 155 + 13.0% Power
Surge = 260 + 6.5% Power
Alacrity = 155 + 21.0% Power

Power, in this case, is [(Force Power + Power) - 1200]

These equations are accurate at 1834 Willpower (± ~60 for accurate results), summed Power + Force Power range of 1200 - 2200 (0-1000 Power at 1200 Force Power). Note, these equations only consider HPS, not HPF.

Incidentally, along this range, Willpower is fairly consistently 9-11% better than the other stats.


As for the sheet itself, a couple errors:

• Your sheet either doesn't include the 5% crit from or doesn't include the 5% crit from Seeping Darkness and Life Surge, as your crit equation has a base of 10% rather than 15%. This devalues Surge considerably.
• Your sheet is providing a 6% boost to Healing Bonus from Penetrating Darkness, but not the 5% boost from Unnatural Might
  Unnatural Might
  Sith Warrior
  
  Range: 30m
  Activation time: Instant
  Cooldown: 6 secs
  Mirror: Force Might
  
  Increases the target's melee, ranged, Force and tech bonus damage and healing by 5% for 60 minutes. If the target is a party member, all other party members are also affected.
  
  . This devalues Power and Willpower a bit.

[Asmo]

Very interesting and informative post Kor. A couple questions and comments:

(02-01-2012 06:43 AM)Kor Wrote:  Assuming you have the 2-set bonus for Innervate and you're casting it on CD, with Static Barrier on cooldown and Dark Infusion as a filler, you're looking at a rough cast ratio of 40% from Innervate, 22% from Resurgence, 28% from Dark Infusion, and 10% from Static Barrier.

This assumes healing a single target though, right? If you include Revivification plus throwing around shields a lot more often than once every 20s that should change things a bit. Not sure how much it would affect the final stat values though.

Quote:In fact, if I plug in the stats in that sheet (1834 Willpower buffed, 320 Power, 1210 Force Power, 375 Crit, 235 Surge, 275 Alacrity) into my stat weights sheet (which simply calculates the HPS difference from +10 of each stat, and normalizes this value to +10 Willpower)

You wouldn't like to share this sheet would you?

Quote:Now to optimize this, the equivalency point (where all 4 secondary stats have the same stat weight) is the maximum output stat point. This point is given by the following constraint equations (all 3 must be true to be at the equivalency point):

Crit = 155 + 13.0% Power
Surge = 260 + 6.5% Power
Alacrity = 155 + 21.0% Power

Power, in this case, is [(Force Power + Power) - 1200]

Not sure I understand exactly how you arrived at these numbers but they do take into account the diminishing returns properties of the rating stats right?

Some general comments about Surge. If you look at the second sheet which shows the curve for the ratings you see the one for Surge is for some reason quite different from the other two and extremely non linear where the benefit tapers of extremely sharply around 400 rating or so. That means that it's basically impossible to give out a general rule of thumb stat weight for Surge. You have to take in to account how much you currently have. If you're sitting at say 100 or 400 Surge it will massively alter the value of adding more of it. My personal feeling is that for some very general advice aim for somewhere between 200-350.

Quote:As for the sheet itself, a couple errors:

• Your sheet either doesn't include the 5% crit from or doesn't include the 5% crit from Seeping Darkness and Life Surge, as your crit equation has a base of 10% rather than 15%. This devalues Surge considerably.
• Your sheet is providing a 6% boost to Healing Bonus from Penetrating Darkness, but not the 5% boost from Unnatural Might
  Unnatural Might
  Sith Warrior
  
  Range: 30m
  Activation time: Instant
  Cooldown: 6 secs
  Mirror: Force Might
  
  Increases the target's melee, ranged, Force and tech bonus damage and healing by 5% for 60 minutes. If the target is a party member, all other party members are also affected.
  
  . This devalues Power and Willpower a bit.

Correct, I didn't include other classes buffs. But you're right it probably is the most logical thing to do since you normally should have all buffs, at least in most raids (though our 8man raid doesn't have a single Imperial agent ) Unnatural might stacks additively giving a 11% increase to bonus healing right?

Another thing I guess I should change is to not just divide the total amount healed by Revivification and Resurgence by the cast time and call it HPS which more accurately would be called heal per cast time? If I add the actual HPS by those spells do you think I should divide by the cast time + the duration of the HOT or by just the HOT duration?

[Kaedis]

Quote:This assumes healing a single target though, right? If you include Revivification plus throwing around shields a lot more often than once every 20s that should change things a bit. Not sure how much it would affect the final stat values though.

My gut says that including Reviv and more Static Barriers will decrease the values of Alacrity, Crit, and Surge (as they don't affect Static Barrier), while increasing the value of Power.

Quote:You wouldn't like to share this sheet would you?

It's a mess at the moment, I'm intending soon to go back through and rebuild it to be a bit more robust. I'll officially release it then.

Quote:Not sure I understand exactly how you arrived at these numbers but they do take into account the diminishing returns properties of the rating stats right?

Yes. Basically, my sheet calculates the HPCT done by each ability, then the percentage change in the HPCT from +10 of each of the stats (including Willpower). It then normalizes these individual weights to Willpower = 1.0000, then performs a weighted average of the scaling values for each spell based on the percentage of total healing from each spell. This is only a first-order derivation, so changes in casting frequency from the changes in stats (which admittedly are rather small) are not taken into account, all of the weights are done assuming the healing distribution given at the baseline stats. 10 stat intervals should be small enough to negate inaccuracies from this only being a first-order calculation.

As for how I came up with the equations, it was actually iterative and manual. I set a certain Power level, then altered the crit, alacrity, and surge values until the weights for each of them fell within 0.5% of the average of the 4 weights. I copied these values, then set a new power level (usually +100). I usually did this at 3 Power levels, then computed and averaged the scaling of crit, alacrity, and surge as a function of Power (usually near-linear). I then set up the equations in the cells for each of the stats and test them over a range of power values to ensure their comformity, adjusting them as needed. I'm not skilled enough with macros, nor knowledgeable enough of advanced differential equations, to write a more analytical setup.

Quote:Some general comments about Surge. If you look at the second sheet which shows the curve for the ratings you see the one for Surge is for some reason quite different from the other two and extremely non linear where the benefit tapers of extremely sharply around 400 rating or so. That means that it's basically impossible to give out a general rule of thumb stat weight for Surge. You have to take in to account how much you currently have. If you're sitting at say 100 or 400 Surge it will massively alter the value of adding more of it. My personal feeling is that for some very general advice aim for somewhere between 200-350.

My sheet does. In fact, all of the stats require you to know how much you already have of them in order to evaluate them. Surge, though it has a somewhat sharper DR curve, is not different in this regard. There's no threshold where it suddenly becomes less useful.

Quote:Unnatural might stacks additively giving a 11% increase to bonus healing right?

Honestly don't know. I've modeled it as multiplicative for now, but I wouldn't be surprised if it were additive.

Quote:Another thing I guess I should change is to not just divide the total amount healed by Revivification and Resurgence by the cast time and call it HPS which more accurately would be called heal per cast time? If I add the actual HPS by those spells do you think I should divide by the cast time + the duration of the HOT or by just the HOT duration?

Just label it HPCT. That's what I do. HPS and DPS are poor measures of skills, to be honest. DPCT and HPCT are far better measures, unless you're talking about a short fights or burst healing.