WHM Healing Spreadsheet

[Syncness]

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.

[Little_Lulu]

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

[Vech]

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.

[Syncness]

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.

[Syncness]

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

[Slixie]

What do you think of the crafted vanya healing items?

[Syncness]

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.

[Ekko]

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

[Syncness]

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.

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