Sorcerer healing spreadsheet

[turlockmike]

(02-01-2012 01:21 PM)Kor Wrote:  Just label it HPCT. That's what I do. HPS and DPS are poor measures of skills, to be honest. DPCT and HPCT are far better measures, unless you're talking about a short fights or burst healing.

It's generally understood that HPS really means HPCT.


In a raid setting, I noticed that I pretty much used my aoe heal on cooldown.


My question is, is it possible for the GCD to go under 1.5 seconds? And if so, then does that include static barrier and resurgence. If so, then they would benefit slightly from alacrity.

[frmorrison]

(02-04-2012 04:55 AM)turlockmike Wrote:  My question is, is it possible for the GCD to go under 1.5 seconds? And if so, then does that include static barrier and resurgence. If so, then they would benefit slightly from alacrity.

No, when the spell is instant it is hard locked at 1.5 seconds currently. However, if you had a 1.5 second cast time spell (like Lightning Strike) but it becomes instant (such as with Wrath) with alacrity the GCD is less than 1.5 seconds.

Alacrity is the weakest stat.

[Kaedis]

Quote:No, when the spell is instant it is hard locked at 1.5 seconds currently. However, if you had a 1.5 second cast time spell (like Lightning Strike) but it becomes instant (such as with Wrath) with alacrity the GCD is less than 1.5 seconds.

Alacrity is the weakest stat.

Actually, spells with a cast time that become instant revert back to a 1.5 second GCD. The only time the GCD falls under 1.5 is if you have a ability with a cast time who's modified (post-Alacrity post-skills post-buffs) cast time falls below 1.5 without becoming instant. For example, Lightning Strike without Wrath but with 10% Alacrity would cast in 1.35 seconds, or 1.05 with Polarity Shift. In both of these cases, the GCD would then equal the cast time. This is very easily observed with the talent Haunted Dreams (since cast time reductions from skills are treated the same). With 1/2 in Haunted Dreams, Whirlwind will have a 1.0 second (before Alacrity) cast time and a 1.0 second GCD. With 2/2 Haunted Dreams, Whirlwind will have an instant cast time and a 1.5 second GCD.

[Arulan]

I don't usually post a lot on forums but I created my own Seer spreadsheet I thought I would share.

I'll give a brief introduction to myself. I played a Discipline Priest in WoW; Holy Priest before WotLK. During ICC I was ranked (according to WorldofLogs and other similar sites) among the top 3 of my class. In TOR I've currently completed all of Nightmare mode 8m and soon to work on 16m Nightmare, which should hopefully provide a challenge. In both WoW and TOR I've been heavily involved in the theory crafting of my class. I do not mean to boast but I thought some credibility before I submitted my spreadsheet was necessary.

Most of the formulas were taken from the Formula thread on this site as well as some ideas about what type of information to display. Currently it is only v1.0 and I intend to update it frequently with new features, customization, and improved accuracy.

For instance, currently over healing or "unused" healing (in Salvation's case) is not calculated into the stat weights. This is one of the things I intend to do next. Although, without accurate log reports this type of information would not be completely accurate but it should provide with more accurate estimates and leave placeholders for when that information is known to us. An example, Rejuvenate's weight in the stat weights would diminish because of the amount of over healing it is likely to do.

Another thing to note, currently Salvation can be customized to have an average number of targets. Until I finish the over healing and "unused" healing portion of the spreadsheet I would recommend keeping this number at 1 or possibly 2 for 16m Ops.

Currently this spreadsheet allows you to input your own spell usage percentage, which modifies the stat weights to your play style. ***Keep in mind, the stat weights are using the data from Build A.

If anyone has any further recommendations, spots any errors, or has any comments please feel free to ask.

EDIT: Updated to include Sorcerer spell names.
The light green area of the spreadsheet is meant to be edited by the player.

[MagicSN]

Arulan, I got some question to you about your spreadsheet. I am currently trying to model the Heal Sage/Sorcerer for my theorycrafting tool "Project Shield". In your spreadsheet I saw these percentage values (Note: I do not play a sage myselves, so this is all new territory for me). Does for example the 0.32 with Healing Trance mean that "usually" from 300 (the 300 just as an example!) spells you would cast 300*0.32 = 96 times Healing Trance? (yes, I am aware that healers play very reactively, just trying to figure something out to get a metric I can use). Do I understand your spreadsheet right here? Thanks in advance, and this is really nice work !!!

[Arulan]

(02-24-2012 12:25 AM)MagicSN Wrote:  Arulan, I got some question to you about your spreadsheet. I am currently trying to model the Heal Sage/Sorcerer for my theorycrafting tool "Project Shield". In your spreadsheet I saw these percentage values (Note: I do not play a sage myselves, so this is all new territory for me). Does for example the 0.32 with Healing Trance mean that "usually" from 300 (the 300 just as an example!) spells you would cast 300*0.32 = 96 times Healing Trance? (yes, I am aware that healers play very reactively, just trying to figure something out to get a metric I can use). Do I understand your spreadsheet right here? Thanks in advance, and this is really nice work !!!

I assume you're using my up-to-date spreadsheet I have up in my thread. To answer your question: Perhaps I should have worded it differently but those "Spell Healing Percentage of Total" is not a spell use count but instead Effective Healing. Keep in mind that variable is meant to be edited by the player.

When originally creating my spreadsheet I had considered Spell Use Count as a variable but I realized that information without an accurate way of determining over healing does not actually hold much meaning and would skew the results. I may, once I implement a over healing system in my spreadsheet change to Spell Use Count however.

With using Effective Healing, without accurate log, you still have to have an idea of what your spell count / total looks like in a raid but also an understanding the effectiveness of their use, which deals with over healing. Rejuvenate/Resurgence for example is a spell you are going to use a lot for the Conveyance/Force-bending buff, but it is going to over heal a lot. One of the reasons, which depends on your playing style is who use it on. The armor bonus (talented) to the spell would mean it's probably best to use it on the Tanks. This spell, despite a high number of uses in raid will have a fairly low effective healing % to the total. Keep in mind, knowing some of this information is based on experience looking at your own logs in past MMOs. (WoW, etc.)

If you have any further questions, please let me know. Also, this discussion should probably continue in my thread.

[Ayaria]

Hello,
Bw changend the hard cap from surge. So the calculator is now wrong in the calculation. Can you fix it? Thanks

[Adam]

Attached is the updated heal stat value;

Updated with Crit Multiplier changes. Confirmed with all the datapoints I could text it with.