 |
| Welcome to Elitist Jerks |
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!
If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.
|
03/31/09, 2:28 PM
|
#1
|
|
Glass Joe
|
Power Word: Shield & Recount
Recount is one of the best addon written for Warcraft, however it does have some weaknesses. The most relevant one for my Priest is the inability to track damaged reduced from Power Word: Shield (PWS).
Unlike many other Priest healers that I know, I like using PWS as a main part of my rotation. I am both speced (discipline talent) and glyphed for it. Unbuffed PWS absorbs 2564 damage for 888 mana, as a reference Flash Heal (FH) heals for 1896-2203 costing 695 mana.
Some random thoughts:
* Casting PWS absorbs the first 2500 damage for each hit.
* PWS last for 30 seconds, so this can be a significant amount of damage absorption depending on the number of mobs and their attack speed.
* PWS is a great compliment to other buffs and all forms of healing.
* If there are two priests in a group, it is probably not efficient for both to use PWS in their rotation.
* As a negative, it doesn't crit.
We all know people who are Recount Junkies staring at the DPS or Healing meters. My view is best expressed by a fellow healer, "healers should not look at Recount, but it is a great tool for DPS". However, after being the lowest healer on the Recount meter, and having been told such, I felt compelled to do some analysis to help defend the Priests who rely on PWS.
Methodology:
I use Glyph of Power Word: Shield. It heals for 20% of all absorbed damage. Since we know the amount healed, we can determine the damage absorbed.
I took screenshots of both Healing and Overhealing from Recount after running two 5 man heroic instances (see below - top Instance) . As you can see, the Glyph healed for 30523 and overhealed for 16048, or a total of 46571. Since this is 20% of the damage absorbed, PWS absorbed 232855 of damage. The total of the healing was 980489, so healing + damage absorbed was 1213344, or 23.7% more then the healing meters indicate.
I ran a second instance and got an identical ratio (Bottom Instance)
For those of you who insist on comparing healers in a raid to one another, aside from shame on you, I provide the following analysis (see spreadsheet below). Lets assume there are 5 healers in a raid and Recount shows them to have healed 23%, 21%, 20%, 19%, and the Priest with 17%. If you top up the Priest by 24%, then readjust the numbers to total 100%, you get that the Priest should display as 2nd on the charts.
I have not found many posts on this topic, but the few I have found suggest that the healing from a Priest that uses PWS is understated from between 20-35% depending on the mob/bosses. This is supported by my analysis.
Reader Feedback.
I have posted this on Elitist Jerks, because I have found the analysis on this site to be superior to all other reference sits. Please comment on this post, I welcome and encourage your views.
* Do you agree with the analysis ?
* What are your thoughts about using PWS as a primary part of your rotation ?
Other Related Reading:
RezTheWeak: New Recount
MMO-Champion Article
Tales Of A Priest: DiscRecount
Wowhead: Discipline Priest Recount
|
|
|
|
|
|
03/31/09, 2:47 PM
|
#2
|
|
Piston Honda
|
I am not sure that this needed to be an additional thread, and could have been easily made a part of the Disc discussion or Holy discussion, depending on which spec you are targetting your information towards.
I am really unsure of the fact that you read the threads here or not because the Disc Compendium and the WotLK Healing Compendium threads both have a reasonable amount of applicable discussion. In fact methods for tracking "mitigation" have been discussed as well as the value of mitigation in relation to total/effective/over healing.
So far as your analysis of PW:S I don't see any major issues. Though it would be important to note that in actuality the Glyph of PW:S heals for less than 20% of the PW:S amount because the calculation isn't so straight forward. It also isn't indicitive of the amount absorbed so much as the amount applied because the glyph's heal/overheal amounts are calculated at the application of the shield not during its consumption. Also, if you are going to look at this from the aspect of Discipline healing then DA should be incorporated.
From the Disc perspective PW:S should be used often (see Disc thread). For Holy it is not quite as good, due to few talents to improve its performance.
|
|
|
|
|
|
03/31/09, 3:12 PM
|
#3
|
|
Von Kaiser
|
Like TheDoctor said, this has been discussed several times in the Discipline thread. Unless Blizzard changes the way the combat log works to also list the source of tha shield that is being used, it will be impossible to determine the exact amount of damage absorption a priest is doing. A while back Promethia did a pretty in depth analysis of a combat log and was able to reliably determine damage absorbed in most cases but there were still some events that were ambiguous.
Another, maybe simpler, way to measure the usage of absorb effects by a Discipline priest is by analyzing Rapture returns. I posted this analysis in the Discipline thread, but will link it here.

Originally Posted by Squeakster
Until 3.1 hits you can get a pretty good idea of effective healing + absorption from the Rapture returns. Take this WWS from my guild's recent naxx/sarth clear for example
It shows me as having done about 4.36 M effective healing over all the boss fights. My Rapture returns over those fights was 364446. Using the equation from the first post of this thread,
(ManaReturn)*11460/(0.025*MaxMana) = Effective Healing+Absorption
That means I did (364446*11460)/(0.025*25000) = 6.68 million effective healing+absoption from the Rapture spells. This is not exact however, because any portion of a heal that was effective past 11460 healing is not counted (so a Greater Heal crit that was mostly effective), so 6.68 million is an underestimation.
That doesn't include heals other than Penance, Gheal and Flash Heal, so those have to be added manually.
PoM did 1,009,974 healing and was 76% effective, so it did 0.75*1009974 = 757481
PoH did 603558 at 50% effectiveness, so 0.5*603558 = 301779
Renew did 284253 at 91% effectiveness, so 0.91*284253 = 258670
Glyph of PWS did 190170 at 38% effectiveness, so 0.38*190170 = 72265
Binding Heal did 51087 at 43% effectiveness, so 0.43*51087 = 21967
Glyph PoH did 49156 at 88% effectiveness, so 0.88*49156 = 43257
Divine Hymn did 28452 at 95% effectiveness, so 0.95*28452 = 27029
Add up those numbers and the number derived from the Rapture returns and you get 8.16 million effective healing+absorption, rather than the 4.36 million healing WWS shows. That means 46.6% of my healing was done through shields, which sounds a little high but I don't believe I've made any math errors. The 8.16 million is actually a low-end estimate too, because any Gheal crit that has more than 11460 effective healing isn't being counted fully.
|
|
|
|
|
|
|
03/31/09, 3:16 PM
|
#4
|
|
Piston Honda
|
First of all, no one's shields are absorbing 2500 or flash heals hitting for 2k. Those numbers are pre-spellpower, and the spells have different spellpower coefficients.
20-35% is a pretty wide range, but I suspect that it isn't wide enough. While the enemies you fight certainly significantly affect the amount of your healing that's power word shield absorbs, the way that power word: shield is used is much more important. Are you just casting it on the tank or spreading it around the raid? Are you casting it every time its 4 second cooldown ends, every time weakened soul comes off the tank, or are you using it more as an emergency heal or a buffer if you have nothing else to do?
What fights does your guild care about your recount position? Something like Noth can probably be solo-healed even on 25 man, so if no one drops below 90% health ever, you'd probably be better of smiting or focusing on cripple dispells than spamming unnecessary heals into your tank. I would ignore healing recount for fights like this.
Patchwerk is a fight where spamming overheals into your hateful tank is a good use of your time. A recount analysis of who's doing well on Patchwerk should probably include overhealing. If you only look at effective healing, and take credit for all your power word shields, than your kind of cheating, since it's impossible for the shield to overheal (unless you cast it on someone who doesn't get hit for the duration). A heal that lands 0.05 seconds after an effective heal is just as effective at saving the life of the tank it hit, even if recount gives it no credit.
On sapphiron, it's certainly reasonable to use effective healing to judge how much each healer is contributing, and also reasonable to use your method to determine how much damage your shields are absorbing.
On 3-drake sarth, where there are more unique healing assignments than the average fight, your healing assignment will have a lot more of an effect on the healing meters than how good of a healer you are.
As far as using power word: shield as a holy priest goes:
-Only if you're raiding without a discipline priest. Their shields are much more powerful and important.
-It's generally inefficient and low throughput compared to other heals
-There are certain places where it's useful like Sartharion breaths - attacks that you have a warning for that can be close to one-shotting your tank
|
|
|
|
|
|
03/31/09, 3:18 PM
|
#5
|
|
Piston Honda
|
Though I wouldn't recommend spending much time moving forward with the Rapture method as it goes away once 3.1 goes Live.
|
|
|
|
|
|
03/31/09, 3:36 PM
|
#6
|
|
King Hippo
Human Paladin
Scarlet Crusade
|
As a (non-Priest) raid leader who also runs Recount, I must fall in the camp of your friend - don't judge healers based on meters. Or, if you absolutely must use meters, you should dive into ridiculous depths for accurate information.
A quick and easy example - we had a healer top Naxx 25 charts this last week. Looked real good on the old effective heal meter. Great for them, right? Except that the top three healed targets were pets. Two hunter pets and an imp.
Go back to BT days (and I'm sure in Ulduar) and I bet the chart toppers will be raid healers while the MT healers are far lower with greater overheal - it's all that AOE damage and smart heals. That doesn't suddenly make the MT healers bad players. The fact the MT survives means they're at least doing their job properly - at the very least.
Healing remains a relatively thankless job and the best healers can often look the worst on charts. Anyone denigrating your location on healing meters as a Discipline Priest should understand the roles and abilities of various healers, raid assignments (MT vs raid healing), and damage sources from any given boss fight. If they cannot understand the whole picture they have no right issuing judgements.
|
Rock: "We're sub-standard DPS. Nerf Paper, Scissors are fine."
Paper: "OMG, WTF, Scissors!"
Scissors: "Rock is OP and Paper are QQers. We need PvP buffs."
|
|
|
|
03/31/09, 11:36 PM
|
#7
|
|
Piston Honda
|
Originally Posted by Squeakster
A while back Promethia did a pretty in depth analysis of a combat log and was able to reliably determine damage absorbed in most cases but there were still some events that were ambiguous.
|
Yes, although I believe in over 500,000 events, only 2 were ambiguous. And "ambiguous" only meant I could not guarantee an exact value: I could still make very informed estimates based on prior events (e.g. the previous crit heal size for DA and previous shield sizes from the same priest). So I feel confident the overall error was definitely < 1%.
More recently, I've come to think that while getting actual absorbed damage data would be nice, it probably isn't completely necessary because within a specific combat encounter:
- the significant majority of shields are absorbed anyway
- not all effective healing ends up absorbing damage either
So if you limit analysis to "in combat" events (which might be tricky), then it may not be unreasonable just to add in total shield size and ignore unabsorbed shields. That method of accounting is exploitable, so you have to believe no one is deliberately throwing shields on targets who won't take damage, but otherwise it is fair enough to do that.
Originally Posted by RootBreaker
20-35% is a pretty wide range, but I suspect that it isn't wide enough.
|
Yes, when I looked at that in detail, I saw the contribution of PW: shield varied very greatly depending on the encounter as well. So I've seen it range from about 10% all the way up to ~70%. 20-35% is a reasonable average across several boss encounters, BUT you cannot simply take a value and say that it is a reasonable estimate for a single encounter. It might not be. It could be wildly off even. That sucks, but that's the truth.
On the other hand, the contribution from DA shields seems more "stable" and was generally between 10-20% of effective healing done, depending on crit rate and overhealing. A reasonable estimate is:
Originally Posted by Exemplar
As a (non-Priest) raid leader who also runs Recount, I must fall in the camp of your friend - don't judge healers based on meters. Or, if you absolutely must use meters, you should dive into ridiculous depths for accurate information.
|
I think the problem is not so much about the accuracy of the information as much as it about the meaning of it all. The biggest predictor of healing done is damage taken, so the most direct meaning of healing done is that lots of healing was needed. That's kind of a "yeah, duh" except then it doesn't make much sense to judge healer by healing done at all. More healing done than usual is a better predictor that your raid is screwing up, standing in fire, etc.
If you have healing assignments doled out, then differences in healing done are also mostly a reflection of how much damage their respective targets were taking. This seems like a simple point, but it is somehow lost on the masses. If you have two hateful strike tanks on patchwerks and one tank takes 20% more damage than the other, then healer(s) on that tank will heal 20% more. Go check it out: this is reliably true. But what does it mean about healer performance?
Not much really, at least assuming no one dies. Your goal as a raid leader is to have enough healing capacity on each tank (and/or the raid, depending on the circumstance) but not too much. Unfortunately, healing done doesn't really tell you if your healers are performing near their maximum capacity. You only discover that by reducing healers and seeing if people start dying.
Fortunately, I think most players and especially most raid leaders know that if no one is dying, then healing isn't a big problem. It might not be maxed out, and you could possibly trim your number of healers, but it isn't "broken". If people die, then you have to investigate why. It might be people just taking more damage than they should, but it could also be weak healers. But healing meter data just does not help you sort that out very much.
Last edited by Promethia : 04/01/09 at 4:06 AM.
Reason: typographical error
|
|
|
|
|
|
04/01/09, 1:32 AM
|
#8
|
|
Bald Bull
Blood Elf Priest
Mal'Ganis
|
As stated every other post, the only way to measure a healer is if the raid doesn't die, especially when something goes wrong. Besides all recount would say is that I spend too much time spamming power word: sprint on CD.
|
|
|
|
|
|
04/01/09, 8:08 AM
|
#9
|
|
Von Kaiser
Troll Priest
Magtheridon (EU)
|
Originally Posted by GIJebus
As stated every other post, the only way to measure a healer is if the raid doesn't die.
|
Thats ofcourse not true.
By diving into the so called 'ridiculous depths' (even though an insane amount of possibilities can indeed take effect, it isn't always that complicated), you can often easily judge a healer by analyzing meters. Break it down, check how well a player reacts and if he's using his full arsenal of spells correctly for his personal priority-assignment, but also monitor how well he does in assisting outside his personal assigment whenever allowed.
Ofcourse its not as easy as judging dps, and in most cases not as accurate. But I think you can judge a healer way better with meters, rather than replacing and see if you feel theres much difference. Tbh that last thing is even less acurate and a stupid way for judging a healer.
[e] Also on top of that, with grid you can monitor the use of any important skill like Guardian Spirit, Hand of Sacrifice etc.
|
|
|
|
|
|
04/01/09, 12:56 PM
|
#10
|
|
Glass Joe
|
Originally Posted by Exemplar
Healing remains a relatively thankless job and the best healers can often look the worst on charts. Anyone denigrating your location on healing meters as a Discipline Priest should understand the roles and abilities of various healers, raid assignments (MT vs raid healing), and damage sources from any given boss fight. If they cannot understand the whole picture they have no right issuing judgements.
|
While part of me wants to cheer at this statement what comes to mind are the people who look bad on meters and are not doing their assigned healing. This can't be used as an excuse without good reason.
|
|
|
|
|
|
04/01/09, 2:09 PM
|
#11
|
|
Glass Joe
|
My thoughts on recount:
Don't worry about it.
Recount for DPSers is cool because competing with each other can increase performance of DPSers.
But healers competing on meters will likely DECREASE their performance.
Healers need to figure out how to best work as a team. The rest of the healers will affect your performance, and your peformance affects everyone elses. Performance in healing means timing, foresight, reaction, mana-management, teamwork, assignements, prioritizing targets, and so on. It can not be judged by numbers.
Nor by how many people are alive at the end. Example: A first kill with 90% of DPSers dead is better than a wipe at low boss health because the tank died and the boss raped the rest of the raid rather quickly.
|
|
|
|
|
|
04/09/09, 4:35 AM
|
#12
|
|
Glass Joe
Undead Warrior
Tarren Mill (EU)
|
I'm using RecountGuessedAbsorbs. It definitely making mistakes, but it looks like i'm getteng pretty close numbers and i'm happy with them.
|
Do you agree with the analysis ?
|
Yeah, it looks like right. But you rely on the glyph procs, which sometimes crit. It can make numbers of absorption a little wrong.
|
What are your thoughts about using PWS as a primary part of your rotation ?
|
It IS main part of my rotation now. The shield is always on MT and OT (for additional crit from Renewed Hope) and sometimes on some melee DPS.
Actually in 3.1 PW:S will become even more important for me because of new Rapture and T8(4) bonus.
My thoughts on recount:
Don't worry about it.
Recount for DPSers is cool because competing with each other can increase performance of DPSers.
But healers competing on meters will likely DECREASE their performance.
|
/agree, but it's really sad to be on the last place in parse. But with absorb plugin for Recount u can always defend your raid slot. Yesterdays Naxx25:
Healing Done (6th place)

But there were some absorbs  :

Last edited by brandyx : 04/09/09 at 4:47 AM.
|
|
|
|
|
|
04/10/09, 5:47 AM
|
#13
|
|
Piston Honda
|
Originally Posted by brandyx
I'm using RecountGuessedAbsorbs. It definitely making mistakes, but it looks like i'm getteng pretty close numbers and i'm happy with them.
...
/agree, but it's really sad to be on the last place in parse. But with absorb plugin for Recount u can always defend your raid slot.
|
Yes, I suppose you sometimes need something to combat the prevailing ignorance out there...
I like how it separates out absorbed damage for everyone. It should be a different statistic that is not the same as healing. Even though both healing and shielding attempt to prevent death, they work through different mechanisms to attain that end.
I would be curious about the actual methods used. From reading the threads on WoWHead and WoWAce, it sounds like Elsia is attempting to estimate damage actually absorbed. The downside of trying to do that is you'll have some error that is hard to estimate, although probably fairly small. However, as I've posted elsewhere actual absorbed damage is definitely superior to healing as a measure of usefulness since it was actually used to absorbed damage. All you really know about "effective" healing is that it made a health bar bigger (after which the target may have hearthed and logged).
|
|
|
|
|
|
04/10/09, 11:04 AM
|
#14
|
|
Piston Honda
Dwarf Priest
Eitrigg (EU)
|
Originally Posted by Promethia
However, as I've posted elsewhere actual absorbed damage is definitely superior to healing as a measure of usefulness since it was actually used to absorbed damage. All you really know about "effective" healing is that it made a health bar bigger (after which the target may have hearthed and logged).
|
I've never been really convinced with this idea. I acknowledge the theoretical difference, but in practice, our HP bars are small enough for most effective healing to be useful.
When there is not raid damage, at most 50k (one tank health) of your effective heal is not useful.
When there is RST, nearly all your healing on raid is useful, because it decreases the death probability, and you can't predict the next target.
When there is global aoe damage (Sapphiron), you could stop raid heal a few second before the kill, but that's not so important.
And keep in mind also that some targets are more "important" than other ones. I prefer direct healing on a target that is at 5k HP healer than shielding and preventing 5k damage on a melee dps at 25k HP, even if the healer takes no further damage.
|
|
|
|
|
|
04/13/09, 10:01 PM
|
#15
|
|
Piston Honda
|
Originally Posted by Elimbras
I've never been really convinced with this idea. I acknowledge the theoretical difference, but in practice, our HP bars are small enough for most effective healing to be useful.
When there is not raid damage, at most 50k (one tank health) of your effective heal is not useful.
When there is RST, nearly all your healing on raid is useful, because it decreases the death probability, and you can't predict the next target.
When there is global aoe damage (Sapphiron), you could stop raid heal a few second before the kill, but that's not so important.
And keep in mind also that some targets are more "important" than other ones. I prefer direct healing on a target that is at 5k HP healer than shielding and preventing 5k damage on a melee dps at 25k HP, even if the healer takes no further damage.
|
I pretty much agree there should hardly be any difference, especially when you're talking about tank healing where there is constant ongoing damage. The vast majority of healing will end up absorbing damage. What I'm really saying is that absorbed damage >= effective healing, not absorbed damage >> effective healing.
The odd inconsistency to me is that people will worry about unabsorbed shield and then simultaneously dismiss the idea that absorbed damage is a bit better than effective heals. I got thinking and (later) posting about this because of what I saw when I went through combat logs and tallied up how much of a shield actually absorbed damage. It turned out that the vast majority of shields were absorbed and usually right away (within a few seconds). The ones that were not absorbed were consistently at the end of combat or when mob aggro changed (e.g. a dps or healer gets hit and then subsequently a tank pulls the mob off).
That isn't really surprising. However, I also noticed that the same targets that were getting shielded and subsequently not taking any damage were also getting healed and not taking subsequent damage. That also shouldn't be shocking at all. If someone was worried enough to shield, then someone would be worried enough to heal as well.
But here's the killer question to me: Why then do we want to spend all this effort to find cases where shields do not absorb damage and discount that when we never do a similar thing for heals? If you spam shield the tank, at most the last shield wasn't useful. Same deal with heals. But with shields we want to subtract out that last shield that wasn't absorbed. With heals, we don't want to do that. No, it doesn't amount to a huge difference, but it is both a conceptual and procedural inconsistency IMO.
Of course, I completely agree healing (or shielding) a 5K HP healer >> than either action on 25 HP melee. This is perhaps the single biggest reason why statistics like healing done are so poor in evaluating healers: they count every point of healing as if they are all the same, when we know the bigger issue is judgement about who to heal and when. Both the who and the when elements are completely missing from healing done (although healing breakdowns can at least help one address the "who" part).
In fact about a year ago I wrote an application which weighted the value of heals based on how low the target's health bar was at the time the heal landed. That was an interesting venture that didn't really prove much. In a relative sense, raid healers didn't look quite as good by such an index since their targets tended to have higher relative health when healed, but the difference was slight. In the end all I showed was that in practice pretty much all healers do preferentially heal targets with lower health...
I feel dumb writing that now because I suppose I should have known that would be the outcome, and it took me a while to write that application. But oh well, now I know for sure. 
Last edited by Promethia : 04/14/09 at 1:12 AM.
Reason: Possibly confusing and unnecessary verbiage removed
|
|
|
|
|
|
04/28/09, 12:02 PM
|
#16
|
|
Von Kaiser
|
I wish that the developers behind WWS would calculate absorbs from PW:S and DA like recount has attempted to do.
Recount doesn't have a method for exporting and posting to our guild forums the way WWS stats does and so the only way for me to show what I am actually doing in the raid is take screenshots with recount guessed absorbed, healing done etc enlarged on my screen in-game and post the pictures in our forums. It doesn't really give the ability to do the in-depth analysis outside of the game that WWS does. What I have seen since 3.1 in particular and raiding in 10/25 Ulduar... disc priests become #1 or #2 when you compile absorbs with healing done on the meters. Even with the margin of error that recount guessedabsorbs most likely has, that still justifies a disc priest's presence in the raid imho.
|
|
|
|
|
|
04/28/09, 12:46 PM
|
#17
|
|
Glass Joe
Dwarf Priest
Balnazzar (EU)
|
The way PW:S is recorded in the combatlog (by the wow-client) makes it really hard to make an easy analyse.
Somewhere on these forums is a way to get the real absorbed message by loading the combatlog in a database. It's an accurate way but takes some time.
For WWS it's really hard, to filter it out. So I don't think they will be implement that feature. GuessAbsorb also uses asumed % to calculate absorbsion, so it's not sure if it's the real absorbed (on sarth3D when I was only PW:S the MT, it's used 100%, on fights where there is allot of raid damage I throw PW:S around and most just wear off.)
The best way would be that WoW records who's PW:S is on who. But that would mean allot of work for Blizzard. I don't think they would do it just for disc priests epeen. Everyone (also raidleaders) should know healing meters doesn't say anything, people staying alive says more about healing, and disc priests are great!!
|
|
|
|
|
|
04/28/09, 10:48 PM
|
#18
|
|
Piston Honda
|
Originally Posted by Healixor
The way PW:S is recorded in the combatlog (by the wow-client) makes it really hard to make an easy analyse.
Somewhere on these forums is a way to get the real absorbed message by loading the combatlog in a database. It's an accurate way but takes some time.
|
The process was posted here.
For convenience, here is the key portion:

Originally Posted by Promethia
Here's a basic synopsis of how I have done it:
1. Modify the log so it's easier to import into a database. Mostly the date header is different from the rest of an event line by being delimited by something other than a comma, so I delimit all fields with commas. Simple text seaches with replace can do this. Some database import tools might be able to do this as well.
2. Import the log into a database.
3. Select all SPELL_AURA_* events where the spell is "Power Word: Shield". Dump the query into a spreadsheet.
4. Select all SPELL_AURA_* events where the spell is "Divine Aegis". Dump the query into a spreadsheet.
5. Select all *_DAMAGE events where the absorb parameter is >0. Dump the query into a spreadsheet.
6. Select all *_MISS events where the absorb parameter is >0. Dump the query into a spreadsheet. [Some people fail to realize fully absorbed hits come out as MISS events, not DAMAGE events].
7. Add some columns to your SWING_ and _MISS spreadsheets so that the absorbed columns can line up with spell and ranged damage spreadsheets.
8. Paste all the source spreadsheets into a bigger spreadsheet
9. Create a new time stamp column which modifies the times for SPELL_AURA_ events. Because events can arrive out of order, you want to make it look like buffs are applied earlier and expire later. I modify them by 1.0 seconds.
10. Sort by the target first (!), then the modified timestamp.
11. With a little luck, the vast majority of absorb events will now be bracketed by buffs applied before and after the absorb events... but unfortunately, that might not always be true.
12. There are a lot of potential ways to proceed from here that might save you time. What I did was add columns for DA and PWS that tracked the state of that buff as well as who applied the buff. When no buff was up, the column is blank. I also added two columns to hold the amount absorbed by DA and PWS, respectively.
13. Now the fun begins since I know of no reliable way to go from here besides inspecting the spreadsheet and crediting the absorbed damage appropriately. Fortunately, most the time it's very obvious, but you'll see a variety of weird cases that require a little thinking.
14. I found that at least most of the time, general DA shields are absorbed before PW:Shield, even when the DA buff occurs after the PW:S buff. So when both buffs are up, the absorbed damage is usually assigned to the DA shield. But you can tell by seeing that the DA buff is consumed before the shield.
15. Sometimes both buffs may be up, and a hit will break through one shield and then be absorbed by the next. This will be apparent because the hit is fully absorbed (it's a miss event), but one buff fades (usually DA) while the other one does not fade. In these cases, I split credit in a 2:1 ratio with more credit going to the PWS. Don't stress over this since it's a rare event, but if you look over the data, that's a plausible ratio since DA shields are usually much smaller.
16. Once you get done going over every line in the spreadsheet, swear at Blizzard a while for failing to make this easier. It's a cathartic experience.
It's painful, but this produces pretty accurate results. Although there's some guesswork involved whenever two shields are up and a hit breaks through one into the other, there's enough context in most cases to get a reasonable estimate on those.
|
I'm not sure why I didn't mention this previously, but whenever you have hit break though a DA shield and into a PW:Shield, you can figure out how much each absorbed precisely because the DA shield size can be determined from previous crit heals. The reverse situation (where you break through a PW:Shield into DA shield) is not as simple but shield from the same player don't vary much at all in size. There are also other sources of absorbs, but again you can make a very good guess (and sometime know the precise absorb amount) based on historical data in the log.
That will produce slightly more accurate results than the simple but imprecise 2:1 ratio I used in step 15. So call step 15 "the lazy method" if you like, but it does save some time and produces reasonable results.
While I do hear many people say "it's not possible to get a precise total" or "you have to guess", if you actually do try and go through the log in detail, there is very little guesswork in practice. It's just a pain to do.
From what I have seen, the recount mod seems to produce a reasonable estimate of absorbed damage. I have heard WMO now tracks it too, but I know little of the methods and cannot comment on their accuracy. Maybe others can.
Last edited by Promethia : 04/28/09 at 11:13 PM.
Reason: quoted the actual method for reference and added comments
|
|
|
|
|
|
04/29/09, 12:04 AM
|
#19
|
|
Honorary Toastr
Night Elf Priest
Dragonblight
|
What do you do if the tank has Sacred Shield?
|
Originally Posted by XI-
No loot bro. Didn't you get the memo, when raiders care about loot they're all shallow asshats, when casuals care about loot they're part of the noble proletariat striving forth to advance themselves while maintaining the tight bonds of friendship and family unity, and juggling their difficult schedule of jetsetting the world and spending time with their supermodel wives and 2.5 picture book children.
|
|
|
|
|
04/29/09, 5:12 AM
|
#20
|
|
Piston Honda
|
Originally Posted by Starfire
What do you do if the tank has Sacred Shield?
|
Sacred Shield absorbs a fixed amount of damage, and if you look through the log you'll usually see how much it is quite readily. Often, it will go down in one hit and will be the only thing on the target and you'll see sequences like:
1. X gains Sacred Shield
2. X takes Y damage (Z absorbed)
3. Sacred shield fades from X
From that you know the shield absorbed Z. When you end up with a PW:S (or DA or whatever) and Sacred shield up at the same time, you may end up with something like:
1. X gains Sacred Shield
2. X gains PW: Shield
3. X absorbs Y' damage
4. Sacred shield fades from X
...
5. PW: Shield fades from X
In that case, you may want to know how much damage broke through the sacred shield and into the PW: Shield. Based on the historical information that sacred shield absorbs Z damage, you conclude that the remainder (Y'-Z) was PW: Shield.
While it is certainly possible to end up with cases where you can't figure out what shield absorbed what, this is so exceedingly rare in practice that it doesn't matter much. Most shields are on their target for only a few seconds before a hit takes them down, so even when a lot of shields are cast, there are many cases where the target only has one on at a time.
This relies on having a large log with lots of data, which is why most parsers will not be able to do it. [I went through logs with over 500,000 lines, which is why a database was needed -- spreadsheets cannot handle that much data]. Parsers want to operate on relatively short segments of log data and want to treat each segment independently. This throws away context but means the parser doesn't have to remember anything when it's running through its algorithm.
Last edited by Promethia : 04/29/09 at 5:23 AM.
|
|
|
|
|
|
04/29/09, 9:44 AM
|
#21
|
|
Von Kaiser
Human Priest
Shadowsong (EU)
|
Originally Posted by RootBreaker
As far as using power word: shield as a holy priest goes:
-Only if you're raiding without a discipline priest. Their shields are much more powerful and important.
-It's generally inefficient and low throughput compared to other heals
-There are certain places where it's useful like Sartharion breaths - attacks that you have a warning for that can be close to one-shotting your tank
|
For holy casting PW:S is more useful than it ever used to be for the speed boost application, not a main cast for us but definitely a regular use in 'xx is the bomb' senarios. The new 4 piece bonus will force holy to cast it much more, just have grid showing weakened soul and a bit of common sense on targets holy never shield and its fine.
|
|
|
|
|
|
04/29/09, 12:02 PM
|
#22
|
|
Piston Honda
|
Originally Posted by Ranc
For holy casting PW:S is more useful than it ever used to be for the speed boost application, not a main cast for us but definitely a regular use in 'xx is the bomb' senarios. The new 4 piece bonus will force holy to cast it much more, just have grid showing weakened soul and a bit of common sense on targets holy never shield and its fine.
|
Yes, I was talking about pre-3.1 in that post.
|
|
|
|
|
|
05/01/09, 9:40 PM
|
#23
|
|
R-R-RAGE QUIT!
|
Originally Posted by Ranc
For holy casting PW:S is more useful than it ever used to be for the speed boost application, not a main cast for us but definitely a regular use in 'xx is the bomb' senarios. The new 4 piece bonus will force holy to cast it much more, just have grid showing weakened soul and a bit of common sense on targets holy never shield and its fine.
|
That is if you plan on cycling a shield in just for that spell power. I personally think it is not that good for holy and won't be gearing 4 pieces of tier 8. Now disc on the other hand, that will be great.
|
|
|
|
|
|
|