Legion Spreadsheet Math!

Everyone is super excited about spreadsheets, right? Right?! Well, if you aren’t, then maybe this post won’t be as interesting for you, but at least it will be exciting for the rest of you.

Holy Paladins were enabled on Alpha a few weeks ago, so there’s still a whole lot to discover and even more that could potentially change. I have a working spreadsheet that I’m fairly satisfied with, but I’m holding off on releasing it into the wild until we’ve had a chance to do some raid testing and I can see what realistic overhealing and casts-per-minute will look like for each ability.

These numbers are not necessarily indicative of which talents and abilities we’ll end up using in Legion, but they’re fun to look at in the meantime; just remember that this is all preliminary and more than likely will change before Legion.

Throughput versus Efficiency

One of the major changes in Legion is that there will no longer be spirit on items. We have a base regen that is four percent of our total mana every five seconds and we may be getting more mana regeneration through trinkets, but I think they’re still working on how trinkets are going to work for healers in Legion. This means that an ability’s healing-per-mana (HPM) is going to be more significant for longer than it has been in previous expansions.

In making the spreadsheet, I was surprised to see how incredibly efficient Judgment of Light is. At 28.14 HPM, it’s almost twice as efficient as the runner-up, Holy Prism, at 15.17.

Healing per mana

Nothing in this graph is too shocking. Holy Light is still our most efficient filler spell, but it is notable that Light of Dawn is more HPM than Holy Shock. This is also assuming we hit 5 people with Light of Dawn, something I haven’t been able to reliably test.

While our new ability, Light of the Martyr, is cheaper than even Holy Light (7.5% of base mana compared to Holy Light’s 10%), the effective healing of Light of the Martyr is very low due to the damage we inflict to ourselves in the process.

It’s interesting to note that when we take Stoicism as our Tier 75 talent, Light of the Martyr becomes more mana efficient than Holy Light, but we also lose our unbelievably economical Judgment of Light.

HPM Stoicism

In Legion, we may see an increased reliance on efficiency, but throughput will still determine which talents we choose and how often we use each ability for a majority of encounters. While Judgment of Light was an impressive front-runner in efficiency, it doesn’t even come close to the powerhouse that is Light’s Hammer. The potency of Light’s Hammer isn’t anything new. We’ve always had the option of showcasing this subtle sledgehammer, but Holy Prism has always been such a consistently strong ability on a relatively short cooldown that Light’s Hammer was never fully utilized. Now that Holy Prism and Light’s Hammer are in different rows, we can choose both. Por que no los dos?

This chart shows how much potential healing each ability has at any given moment (assuming its off cooldown). It doesn’t necessarily show how much each ability will contribute to our overall HPS, it’s more of a priority list of which spells we’ll want to use first when they come off cooldown.

Healing per cast time

You’ll notice that this chart has an added ability that wasn’t on either HPM chart: Lightburst. This is the jumping heal-over-time-ish spell that comes with our artifact weapon, Tyr’s Hand. It doesn’t actually cost any mana, so it’s efficiency is, literally, off the charts (that was a joke), but its HPCT isn’t too shabby either. It does, however, have a minute and a half cooldown, making it a pretty small part of our overall HPS.

You might also have noticed that Light of the Martyr is at the bottom. Stoicism does help make Light of the Martyr a slightly more attractive choice as a filler than Holy Light, but at the cost of Judgment of Light and total HPS, but we’ll cover that later.

HPCT Stoicism

Even with Stoicism, Light of the Martyr only barely edges out Holy Light in HPCT. I’m very hesitant to say that we’ll never use Light of the Martyr in its current state, but it’s hard to see the silver lining at the moment. I would love to be dead wrong about Light of the Martyr, though. We’ll just have to wait and see how it performs during raid testing.

More Talent Combinations!

In Legion, our talents are looking much more interesting. All three options in the 15, 75, and 90 tiers have a direct influence on HPS while each aura brings unique raid utility, and we finally have a real choice between Beacon of Faith and Beacon of the Lightbringer! All-in-all, I expect that we’ll have many more opportunities to swap talents based on each specific encounter. That being said, some talent combinations are looking much stronger than others.

Of the 54 possible combinations of talents from tier 15, 75, 90, and 100 (excluding Beacon of the Savior), here are the top 10 and, just for fun, the worst talent combinations and their projected HPS.

Talent Combo HPS


There’s a lot of really interesting data here. Holy Prism and Judgment of Light are looking very strong; both making up 80% of the top 10. Beacon of Faith and Beacon of the Lightbringer are equally represented with Lightbringer usually being higher, but Faith being in more combinations. Overall, each of the top 10 are fairly close to each other meaning we should, hopefully, be able to play with different talents without feeling like we’re sacrificing throughput.

Even though it may look like Stoicism is awful, the talent combination of Light’s Hammer, Holy Prism, Stoicism, and Beacon of the Lightbringer was still at 109,476 HPS, right behind number 10. It still performs less optimally than Judgment of Light and Daybreak, but it’s not too far behind if Light of the Martyr was ever discovered to have unique benefits that my spreadsheet isn’t accounting for.

Haste… uh, sucks?

All classes have had significant changes to shuffle around the weights of their secondary stats. We lost all raid buffs, our 5% crit affinity from Sanctified Light, the 10% passive haste from Infusion of Light, and the additional haste from Avenging Wrath. Losing so many sources of haste has given our naturally HoT-free toolkit even less synergy with haste. Other than our cast times, Light’s Hammer is the only ability that is affected by haste in any meaningful way. As such, haste is really far below all other secondary stats in relative power; usually less than half the weight of the second-to-last stat.

The actual weights of each secondary stat will differ with gear and talent choice, but the general priority is crit > intellect >= mastery = versatility >> haste. Surprisingly, versatility rivals mastery in many talent combinations and isn’t very far off from intellect and crit either. Its also very likely that I’m not calculating mastery’s effectiveness very well. In fact, I’m sure of it. Without proper raid testing (and likely some addons), it’s really hard to know how much benefit we’ll get from mastery, so take all of this with a pretty big helping of salt and skepticism.

Even though it’s still really early, I’m really liking the new aesthetic of the front-line healer that we’ve become and I’m excited to see how it ends up working in Legion. Hopefully, I’ll be able to do some raid testing soon and fine tune the spreadsheet so that you guys can poke and prod as well. In the meantime, be sure to check out the Paladin feedback thread on the official alpha forums for other opinions on Holy Paladin and give feedback if you actually have access.

Thanks for reading!


9 thoughts on “Legion Spreadsheet Math!

  1. Lifespark February 29, 2016 / 6:52 am

    1) I’m glad to see people doing this spreadsheet work – kudos and for other readers, don’t be afraid to join in as well! More sheets are never bad especially because (to some degree) they are subjective.

    2) When you compare Intellect to Crit, is it 1:1? It would be odd if Crit is higher than Int, because that (among other things) means that secondary stats will outweigh item level. Unless that’s what is intended.

    Maybe they want to bring back theorycrafting, but I actually it found positive that you didn’t need to run sims or semi-accurate tools after getting your gear to see if it was “truly” an upgrade, you could just take the higher item level. (Read: Intermediate steps to getting loot really isn’t fun!)

    3) Likewise, was Mastery compared at full value or an assumed “average” value? Because if it’s full value, then Versatility is just plain better. If it’s an “average” value, Versatility (with DR and damage) is still better.

    4) It’s sad to see Haste suck so bad. Haste for non-HoT classes such as Paladin always gave an interesting choice – did you want more throughput, or more HPM? Now it’s just a “dead”/”shit” stat overall, which I find unfortunate.


  2. Dreamguard February 29, 2016 / 7:22 am

    1) Whole-heartedly agree.

    2) A lot of these numbers are based on me being level 106 and scaling to 110 and 810 item level while in a dungeon, so I’m not 100% sure that the stats scale like I think they do. Regardless, it looks like gear has about 5x as much mainstat as a secondary stat whereas it’s much closer to 1 to 1 in Warlords of Draenor. So, my weights are normalized in the sense that 1 crit is worth roughly 5 int, so not necessarily 1 to 1, but more in the ratio that it appears on gear.

    I think being able to figure out what’s best without simulations is still partly true. For the most part, you can still just choose whichever item has the highest item level and be fine. Optimizing the rotation/playstyle and talents are typically worth a lot more throughput than the stats themselves. I think people who like to min/max (myself included) typically play up the value of min/maxing more than it might be worth.

    3) Yes, all secondary stats (crit, mastery, haste, vers) are weighted as 1 to 1, only intellect is normalized. Yes, I think that makes versatility incredibly strong. Especially since it might mean that Light of the Martyr increases in performance as well since it double dips in healing effectiveness and damage reduction. Unfortunately, all my gear is from leveling and it doesn’t have any versatility on it. If I had equal amounts of versatility, I would have 9% damage reduction, which is huge.

    4) It’s true. It’s even sadder because Holy Paladins are the only healer that can reduce cooldowns with haste and that’s not even really worth anything at the moment either.


  3. Jordan (@pelinal1415) March 8, 2016 / 11:43 pm

    Some interesting tidbits here, no surprises though.

    One thing your post alludes to and is somewhat misleading, is that although Light’s Hammer is a very efficient Health per Mana spell, and I hope it turns out to be a good talent choice (It was constantly one of my favorite spells that i rarely got to use). Holy Bolt gives us more mana efficiency overall and appears to be very competitive in terms of raw HPS (in your charts comparing talent combinations). Light’s hammer seems very attractive in perfect situations (used on cd with 6 targets and no overheal for the duration) Holy Bolt is always useful, and doesn’t make us spend any extra mana.. According to your HPS per talent combination comparison isn’t far behind Light’s Hammer in raw HPS either.

    In addition (too early to tell ofc) our old Artifact Passive synergized with Holy Shocks and as a result Holy BOlt, if we get the same one back or a new one that is something to consider as well.


    • Dreamguard March 9, 2016 / 8:47 pm

      You’re correct about Light’s Hammer and Holy Bolt. It looks like we’ll be using Light’s Hammer on shorter fights with more burst and Holy Bolt for longevity.

      We’re still getting a new Alpha build each week, so it’s likely that this might change, but for now that seems right.


  4. Ben March 9, 2016 / 8:36 am

    Is Holy Bolt + Sanctified Wrath(and Judgement of Light I guess) really so little hps that it didn’t make into top10? Can you tell me any numbers on that?


    • Dreamguard March 9, 2016 / 8:51 pm

      The numbers have actually changed quite a bit from when I posted this. Avenging Wrath’s bonus healing has been reduced to 35% from 50% and Sanctified Wrath no longer gives any additional crit to Holy Shock. Also, there have been a number of other changes that would make the HPS numbers different.

      I might do an update a little later down the road, but for now things are changing a little too fast for me to keep up with and post about every week. I’ll probably wait a while until I do another recap like this.


  5. sanctifiedwrath July 13, 2016 / 11:45 am

    Hello, Thanks a lot for this article.

    I have a question not fully related to it, even if it’s a question about healing efficiency 🙂

    I’m wondering about the tier 60 talent and Devotion aura vs Aura of mercy when used with Aura of mastery, which is our big raid CD after all and it will influence our HPS.

    I’m sure it’s really a stupid question but I’m not sure about which talent will be the more efficient regarding hps vs damage absorbtion.

    For me, when we need to cast our raid CD, if 20% of damage taken per member during 6sec is > to 30% of spell power x 6 (the number of ticks of Aura of mercy under Aura of mastery effect) then we should go to devotion aura, if not we should go to Aura of mercy to be more efficient.

    Am I correct regarding this logic? Am I also correct when I say that the number of people inside the area of effect of the Aura of mastery doesn’t enter into consideration?

    Sorry again if it’s not posted in the correct article 🙂



    • Dreamguard July 13, 2016 / 7:54 pm

      You’re correct, though it would be 30% SP * 6 * 20 that would have to be greater than the amount mitigated by Devo.

      If you’re asking if the amount of people changes the amount that Mercy heals during Aura Mastery, no that doesn’t matter. During Aura Mastery, it heals all players within 40 yards for the same 30% spellpower.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s