WHM Healing Spreadsheet

Link: https://docs.google.com/spreadsheet/...rive_web#gid=0

Purpose
Shows healing returns such as average heal, crit adjusted heal, time to heal, effective heal per second, per mana, ehpm relative to Cure, etc.

Gear comparison and healing comparisons for both. Also has heal to threat skill ratios.

Instructions
Should be reasonably easy to understand. Info tab has basic info, credits, sources, changelog, todo, formulas.
Gear tab has purple boxes, these have dropdown menus for gears and races. Once done, go to Healing tab.

Other
It is designed for level 50 WHMs.
Please post feedback! Thanks!

Credits
Eein @ Chocobro.com, Reddit
Duraz0rz @ Reddit
Valk @ valk.dancing-mad.com, Valkky @ Reddit
and me.

This doesn't have enough views, I'm not even a WHM but I appreciate the effort you put into this!

Quote:

---

The download is on Dropbox, but I redirected it through my website

---

This is why it doesn't have enough views/comments. No one wants to expose their computer to a potential virus and re-directed dropbox excels are hotbeds for a potential threat. OP should have just used google docs. Safe, clean, and easy to view.

Quote:

---

Originally Posted by Vech

This is why it doesn't have enough views/comments. No one wants to expose their computer to a potential virus and re-directed dropbox excels are hotbeds for a potential threat. OP should have just used google docs. Safe, clean, and easy to view.

---

I moved support onto Google Docs after first release, I was far more familiar with Excel than Docs at the time. Now I've learnt to be familiar with Docs. Docs however has a little update lag and formulas don't update cells dynamically, might become a problem in the future. Had to redo entire vlookup setup.

Also, if people don't want to use the spreadsheet, frankly it's their loss.

On topic:
Major update, see spreadsheet for changelog.

Small update, fixed an error on party INT bonus, removed 30 default MND.

What do you think of the crafted vanya healing items?

Quote:

---

Originally Posted by Slixie

What do you think of the crafted vanya healing items?

---

HQ Vanya helm+chest is easily better than Darklight for a few reasons:

• First, Darklight is PIE/DET. PIE isn't that great of a stat at the moment due to the lack of real mana intensive healing, it also has poor scaling for WHM compared to SCH (due to how shroud works). Since the ilvl budget is split between PIE/DET, we have some of the budget wasted into PIE. As we can see with the Vanya set, although the helm has PIE, the rest of the budget is on CRT which is better than PIE because the essence of extra mana is that we have mana to cast an extra heal, thereby using an extra GCD where as with CRT/DET and SPSD (to some extent), we're saving a GCD/time. Essentially, Darklight Cowl has 7 PIE worth of budget that could be elsewhere.
• Second, at the cost of 1 MND, 11 DET, you gain 10 materia slots (I think of which 4 are safe). The 10 DET is easily made up from the 2 safe slots in the helm if desired and the remaining slots are up to the user. Obviously this means more stats at the realistic cost of 1 MND (IIRC was somewhere in the ballpark of 5.3 DET which is very close to CRT/SPSD).
• Third, the Vanya set allows for far greater freedom. Players aren't tied to waiting for AF2 Helm+Chest when they would be if they had Darklight. Swapping out DL for AF2+AK is also not an option since AF2Chest/Helm + AK counterpart is a downgrade for all scenarios due to the opportunity cost that comes with either the philos used on the Cowl or the Myths used on the Helm/Chest.

tl;dr - If you're loaded to afford Vanya HQ Head/Chest, get it. Poor man's option is DL. Myth AF2+AK rush isn't a good choice because the first myth should go to Wep>Ring >=Legs.

Using the darklight cowl if you set the helm to none the formulas give n/a

Quote:

---

Originally Posted by Ekko

Using the darklight cowl if you set the helm to none the formulas give n/a

---

Thanks, fixed. It has to be edited in the hidden gear spreadsheet due to how vlookup works.

Interesting spreadsheet. I got a kick out of the medica II 8/24 man heal threat ratios vs pld lol

One thing that surprised me was how low regen threat is listed. It seems like 1 tick of regen before the tank hits a boss and it is impossible to get the boss off of me. Maybe I'm just remembering encounters where warriors were tanking I dunno.

Quote:

---

Originally Posted by dragonflyseksparade

Interesting spreadsheet. I got a kick out of the medica II 8/24 man heal threat ratios vs pld lol

One thing that surprised me was how low regen threat is listed. It seems like 1 tick of regen before the tank hits a boss and it is impossible to get the boss off of me. Maybe I'm just remembering encounters where warriors were tanking I dunno.

---

SE made changes to how enmity is created with regen is why. I could explain but no need unless you want to know etc.

mmmmm I dont know how accurate this chart is...

I have an option now of weather replace 3 darklight pieces for 3 Hero items, or get my Thyrus +1

Based on this the Thyrus will give me a better heal by ~30 HPS...
Crit seems like is not being considered at all...

Quote:

---

Originally Posted by DivineAyumi

mmmmm I dont know how accurate this chart is...

I have an option now of weather replace 3 darklight pieces for 3 Hero items, or get my Thyrus +1

Based on this the Thyrus will give me a better heal by ~30 HPS...
Crit seems like is not being considered at all...

---

You're going to have to be more specific...

3 MD greatly outweighs crit though.

Dark light neck and ring stats are wrong. Not sure if others are. I just noticed when I picked my gear and stats weren't matching up to in game.

Quote:

---

Originally Posted by Airikay

Dark light neck and ring stats are wrong. Not sure if others are. I just noticed when I picked my gear and stats weren't matching up to in game.

---

Fixed thanks. Ring PIE was 9 instead of 8, Neck SPSD was 8 instead of 9.

Also, in your thread stated it each Pie to be 7.8 mana, I've done a ton of tests and go it to be 7.9 for certain. Perhaps different races have different gain? I'm Dusk Elf. I know it doesn't pertain to your sheet yet but it'd be cool to add in health and mana pool on stats top left corner.

As a WHM I just bought my myth chest this morning and made an HQ Vanya hat of healing (will get +1 in 3weeks). Looking at your earlier comment about myth body + AK, would you say my combination is an upgrade? What should I meld onto the hat to make it considered so?

Quote:

---

Originally Posted by Airikay

Also, in your thread stated it each Pie to be 7.8 mana, I've done a ton of tests and go it to be 7.9 for certain. Perhaps different races have different gain? I'm Dusk Elf. I know it doesn't pertain to your sheet yet but it'd be cool to add in health and mana pool on stats top left corner.

---

I don't have sufficient data (testing) to put in formulas as fact.

Quote:

---

Originally Posted by NintenPyjak64

As a WHM I just bought my myth chest this morning and made an HQ Vanya hat of healing (will get +1 in 3weeks). Looking at your earlier comment about myth body + AK, would you say my combination is an upgrade? What should I meld onto the hat to make it considered so?

---

Up to you depending on your preference of gameplay. The gains between SPSD/CRT/DET are pretty negligible at the moment, so you can choose based on practicality.

Quote:

---

Originally Posted by DivineAyumi

mmmmm I dont know how accurate this chart is...

I have an option now of weather replace 3 darklight pieces for 3 Hero items, or get my Thyrus +1

Based on this the Thyrus will give me a better heal by ~30 HPS...
Crit seems like is not being considered at all...

---

For whm,
Crit = overheal. You can't wait for tank hp to go low and hope for crit cure I to top off your tank instead of casting cure II.
Crit heal on 1st cast right after pull = dead whm.

Quote:

---

Originally Posted by Aedra

For whm,
Crit = overheal. You can't wait for tank hp to go low and hope for crit cure I to top off your tank instead of casting cure II.
Crit heal on 1st cast right after pull = dead whm.

---

Maybe if your tank is really bad and only pulls with a shield lob and then just stands there, but if they have any sort of rotation there really isn't an issue.

I personally weigh det > speed > crit .

Quote:

---

Originally Posted by Aedra

For whm,
Crit = overheal. You can't wait for tank hp to go low and hope for crit cure I to top off your tank instead of casting cure II.
Crit heal on 1st cast right after pull = dead whm.

---

You should be using Swiftcast > Stoneskin > Regen/Cure > Cure/Regen on the pull. This is more than enough GCDs for tank to get aggro.

Quote:

---

Originally Posted by Syncness

You should be using Swiftcast > Stoneskin > Regen/Cure > Cure/Regen on the pull. This is more than enough GCDs for tank to get aggro.

---

You realize that every tick of that regen on the Stoneskin tank is just generating overhealing threat right?

And are we talking about AK/WP or Coil or HM Primals? Wasting a Swiftcast on a Stonekin seems rather silly since in AK/WP you can easily time your Stoneskin cast to land as the tank finishes up a pull or heads to the next one. On Primals, the only one you really need to worry about is possibly Titan, and after Landslide you have more than enough time to cast Stoneskin on him before MB anyhow.

End game you should be weighting PIE>DET>SS>Crit

PIE is our only source of scaling mana regen and the larger the piety pool, the longer we'll sustain healing in a fight, the less we need to call for a ballad, the more our group can focus on dps, the faster the content goes down.

DET for obvious reasons. SS for reduced casting time, reduced gcd, and smoother overall healing. Crit is always last because no WHM should ever be relying on RNG to heal (as we do not benefit from any overhealing at all as SCH do). In addition, our overhealing just adds onto the threat issues we already have as WHM.

I definitely appreciate the work you've done with the spreadsheet though and wish more people would visit/contribute to r/ffxivtc

Quote:

---

Originally Posted by Lionsden

You realize that every tick of that regen on the Stoneskin tank is just generating overhealing threat right?

And are we talking about AK/WP or Coil or HM Primals? Wasting a Swiftcast on a Stonekin seems rather silly since in AK/WP you can easily time your Stoneskin cast to land as the tank finishes up a pull or heads to the next one. On Primals, the only one you really need to worry about is possibly Titan, and after Landslide you have more than enough time to cast Stoneskin on him before MB anyhow.

snip

---

I'm talking about Twintania of course...

Updated to reflect 2.1 changes.

Missing ilvl 80 item stats as well as adjusted ilvl 95 Allagan weapon stats.

See spreadsheet changelog for more information.

I see updating, so wanted to point something out. Not that it makes much difference, but the 1.028 is a decimal short of being correct I think. When I have 381 mind the buff sets me up to 395, whreas spread sheet only lists 394. I think perhaps 1.0283 maybe more accurate or so. I'm not sure when they start the rounding up on stats though, at .5 or higher. But thought I'd bring it to your attention anyways. Anyways, keep up the good work! Always use your sheet to help me when deciding what to upgrade next.

Probably a rounding error, I remember the variation to be from 2.77% to 2.83% or something similar, averaged it out.

Looking at the 2.1 EX Primal accessories, how do the vortex ring of healing and inferno bangle of healing compare to the current best in slot gear?

Vortex Ring of Healing: 13 MND, 11 SS, 11 DET
Hero's Ring of Healing: 13 MND, 8 PIE, 16 CRIT

Inferno Bangle of Healing: 13 MND, 8 PIE, 11 DET
Hero's Bracelet of Healing: 13 MND, 12 PIE, 11 CRIT

Correct me if I'm wrong, but I believe the priority stats for White mages are DET >> CRIT >> SS
Would these two primal accessories be the new best in slot and if not, could anyone kindly explain why they aren't?

Quote:

---

Originally Posted by Ace_S

Looking at the 2.1 EX Primal accessories, how do the vortex ring of healing and inferno bangle of healing compare to the current best in slot gear?

Vortex Ring of Healing: 13 MND, 11 SS, 11 DET
Hero's Ring of Healing: 13 MND, 8 PIE, 16 CRIT

Inferno Bangle of Healing: 13 MND, 8 PIE, 11 DET
Hero's Bracelet of Healing: 13 MND, 12 PIE, 11 CRIT

Correct me if I'm wrong, but I believe the priority stats for White mages are DET >> CRIT >> SS
Would these two primal accessories be the new best in slot and if not, could anyone kindly explain why they aren't?

---

It depends. I rank Det > Pie > SS = Crit. Sometimes prefer crit though if everything else is equal just cause it is useful for if I want to play as SCH too. But the ring is BiS for some and not for others. Some might not be willing to give up all their piety on that equip. I would say that and Allagan Ring are BiS. For Bangle I'd also put that at BiS as a no brainer for WHM.

Updated with all 2.1 stuff.

My opinion is that CRT is most practically useful since SPSD and DET give negligible gains when it really matters. However, I haven't done Titan/Ifrit EX so this may change.

On Twin, if you're healing the DS tank, CRT helps. If you're SSing the tank (since SCH should Lustrate) then SS might be slightly more useful, but keep in mind faster casting means more mana drained.

Thankfully, the difference in gains between the three stats (det/spsd/crt) is very small, so ultimately it comes down to what's most practical.

Did your sheet take into consideration Cure II free procs and Cure III overpowers? Granted, those are on some unpredictable and unreliable mechanics, but they still improve HPM for both spells over a long fight.

Also, your HPM seems to only look at single target effect. A spell that gives multiple players healing benefit would not only increase HPM, but also reduces healing stress.

I guess the question is, what do we do with spreadsheet data for healing? Healing is completely situational and conditional. It's hard to utilize static figures for developing a healing strategy when any given fight will give you a different set of stresses and variable. Some fights, for example, may require more AOE healing.

Kudos on taking the time to figure this all out. I do not mean to discredit your efforts or trivialize their values at all.

Uh. Spreadsheets are just to lay stuff out in numbers. Stuff you suggest is so situational numbers can't even be tied to them. If you read the links on spreadsheet all the efficiency and stuff is laid out on the reddit link. A spreadsheet isn't meant to be a walkthrough, which seems to be what you want. Perhaps you should try YouTube. Its so people can figure out how they want to gear and plan.


Anyways on topic you're missing Inferno Bracer and Allagan weapon is i95.

Edit: Actually found Bracers, you have them under ears.

Quote:

---

Originally Posted by Airikay

Uh. Spreadsheets are just to lay stuff out in numbers. Stuff you suggest is so situational numbers can't even be tied to them. If you read the links on spreadsheet all the efficiency and stuff is laid out on the reddit link. A spreadsheet isn't meant to be a walkthrough, which seems to be what you want. Perhaps you should try YouTube. Its so people can figure out how they want to gear and plan.

---

I don't want a walk through. And I didn't realize there was any planning to gearing. I guess it was always grab the item with the strongest stat you can first because it's worth it over the long haul.

Quote:

---

Originally Posted by Airikay

Anyways on topic you're missing Inferno Bracer and Allagan weapon is i95.

Edit: Actually found Bracers, you have them under ears.

---

Thanks, fixed both.

Quote:

---

Originally Posted by Jyoeru

Also, your HPM seems to only look at single target effect. A spell that gives multiple players healing benefit would not only increase HPM, but also reduces healing stress.

I guess the question is, what do we do with spreadsheet data for healing? Healing is completely situational and conditional. It's hard to utilize static figures for developing a healing strategy when any given fight will give you a different set of stresses and variable. Some fights, for example, may require more AOE healing.

---

You can take what you want from the spreadsheet. For example: you have a situation where you can top 3 people up with either Cure or Medica, but you don't know which is more efficient, one uses more GCDs, heals more, but only uses slightly more mana whilst the other uses one GCD, less mana, but heals for less. However, their health is not the same, you might overheal with Cure but you won't with Medica, so how do you figure out which is more efficient? You use the spreadsheet.

You're also right in that it doesn't calculate HPM for AoE heals "accurately", for this, you can simply alter the overheal amount to a negative value. So for Cure3, right now default is set at 40% so what this means is that normally with no overheal, the target gets 100% effectiveness of the heal (overheal = 0%), now the target gets 60% (so overheal is 40%). You can change this to -100%, meaning Cure3 now can heal for full effectiveness on two targets (2x100%). You can set this to -300% (this is 4 targets, which is commonly used to 4 stack Twintania Fireballs) against no overheal Cure2s (but keep in mind you need to cast 4x). Of course you'll easily see that Cure3 is far more efficient than 4 Cure2s as it should be.

I didn't include Cure2/3 free procs because the average mana saved is determined by fight length, and as such, it doesn't compare well to impromptu comparisons such as the one listed above. In the above example, you're testing whether to use Cure2 or 3. The mana reduction is irrelevant because I can't rely on it to activate and then use that activation to compare which is more efficient.

Quote:

---

Originally Posted by Syncness

I didn't include Cure2/3 free procs because the average mana saved is determined by fight length, and as such, it doesn't compare well to impromptu comparisons such as the one listed above. In the above example, you're testing whether to use Cure2 or 3. The mana reduction is irrelevant because I can't rely on it to activate and then use that activation to compare which is more efficient.

---

Which is quite unfortunate. Their efforts to implement more efficiency through these mechanics are highly trivialized by their unreliability and short use timers.

Thanks for the discussion points.

I would like to say that without looking at the math, my experience for efficiency and realistic healing models indicates the following:

Regen*** > cure 1 > Med II > cure II > Cure III/Medica 1 with Stoneskin being a good heal when and if you can pull it off and know where to place it, such as with pre 2.1 Mountain Buster.

The problem with Med I is that it does such trivial healing, but it hits just about anyone on the map. The problem with cure III is that it does amazing healing, but is too prone to having wasted overcures or missing several (read: all but 1) targets. So, cure III ends up being a stack heal (which those mechanics don't seem to come out too often), and doesn't seem to get to be used as I think it was designed--as a tank/melee heal. The mechanics of the game, in other words, don't seem to work fluidly with the abilities given to answer to them.

I say cure I > cure II because it does more reliably proc a useful free cure than cure II procs a useful overcure (which I use over a cure II when it's about to run out because it's cheaper and *might* just hit more people who need it at the time it's cast). Besides, most of the time, that's what we're casting is cure I to keep tank topped off.

***Regen as a tank buff (a) and as a preemptive heal to offset known incoming or sustained damage (b). Not to be used instead of a direct heal unless you know odds are low more immediate damage is incoming, unless you want to use it as a buffer.

Stats on Allagan Staff. 35 Vitality.

@Jyoeru:

You're not taking into account GCD savings.

Revived link in first post.

I haven't added any new items. Feel free to edit the stats yourself.

well, thats currently not possible cuz its view only