WHM Healing Spreadsheet

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