MMO News and theorycrafting for advanced MMO gamers. News and articles that relate to your gameplay. World of Warcraft, SWTOR, Guild Wars 2, Rift, TERA, Eve Online, Star Wars the Old Republic, Diablo3, The Secret World and all Western AAA MMOs
Sorcerer healing spreadsheet
02-01-2012, 06:43 AM
RE: Sorcerer healing spreadsheet
Quote:Using this spreadsheet it seems like
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):
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:
Even Angels must kill from time to time...
|Messages In This Thread|
RE: Sorcerer healing spreadsheet - Kaedis - 02-01-2012 06:43 AM