Sorcerer healing spreadsheet

[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.