Page 1 of 8
1
2
3
... LastLast
  1. #1

    Discipline HPM Stat Weights and Optimisation Spreadsheet

    The latest versions of the Discipline and Holy Priest spreadsheets may downloaded from the links below. For 6.2, there are two versions: 'Basic', which uses the original overhealing factors, and 'Advanced', which uses the expanded set of overhealing factors. Either blank sheets may be downloaded (for the Basic versions only), or ones in which an example log has been analysed for illustration. Note that some features of the Advanced sheets will only work if opened in EXCEL, if iterative calculation is enabled (File -> Options -> Formulas -> Check "Enable iterative calculation").

    6.2 Discipline Spreadsheet: Basic (Blank, Example), Advanced (Example).
    6.2 Holy Spreadsheet: Basic (Blank, Example), Advanced (Example).

    Using the Sheets
    All of the input is done on the first sheet, 'Stats and Log Input', where you enter your Priest's in-game, non-raid-buffed stats (for secondary stats, enter the rating in each stat) into the tan coloured cells beneath "Character Stats", and enter the healing obtained from the log you wish to analyse into the tan coloured cells under "Log/Healing Input". When entering character stats, a number of effects such as racials, flasks, food, potions, trinket/enchantment procs, etc. can be added to improve the sheets' accuracy; how many you decide to include is up to you, but it is recommended that at least flasks and trinket/enchantment procs be included, since they often add a decent chunk of extra stats.

    With the stats entered, the next four sheets contain the results. The 'Weights and Healing' sheets display the resultant stat weights*, once your healing breakdown and current stats have been accounted for, in a black-bordered box at the bottom right. The coloured table above this includes individual spell data, such as spellpower coefficients, specialisation passives that affect each spell and stat weights by spell. The coloured table to the right, titled 'Healing by Spell', calculates some values for each spell from your stats, such as Healing per Target/Cast/Execute Time/Mana (HPT/C/ET/M)**, as well as the cast time and mana cost of each spell, which then gives the mana that spell consumes per second of casting it. The final column, 'OOM', is how many seconds a spell could be cast back-to-back before running from full mana to empty; while numbers are given for spells with cooldowns, this obviously cannot be applied to such spells, and these numbers do not consider rotations.
    (*Haste (HPET) is not an accurate weight, since it does not take mana considerations, cooldowns, or similar things into account. To better understand this, see this post by VigilantRose).
    (**Note that these values are calculated using 'aggregate' healing factors obtained from the analysed log, so they do not reflect what occurs on a spell-by-spell basis. Also, if a spell 'type' has not been used at all in a log, its overhealing factors default to one, which would then give higher healing numbers than would be likely if the spell were used).

    The 'HPM Optimisation' sheets use the theory set out in the Equations documents linked below to calculate the ratings in each of Mastery (m), Critical Strike (c), Multistrike (ms) and Versatility (v) that is 'best' for your current available allotment of secondaries (excluding Haste). Note that the first graph of allotment to each stats vs. total allotment goes up to total numbers of secondaries far beyond what will be available this expansion, so only the results prior to the second x-axis tick are relevant (approximately). In the Advanced sheets, dots are also shown on this graph to indicate where your current stats lie. The tables and graphs to the rights are more of theoretical interest than anything else, and display the ratio calculated by comparing the HPM calculated for an even spread of secondaries between any two, three or four of m, c, ms and v, to the optimal HPM. In the Advanced sheets, the graphs have additional lines to show where your current stats place your HPM relative to optimal.

    The final two sheets display the same again, but this time on the basis of raw healing; i.e. overhealing is ignored. This is done as 1) individual overhealing stats may vary strongly between different fights, raid compositions and gear levels and 2) many fights focus on providing healing within a short time period, rather than spread out over the entire fight duration, and improving your raw healing may be the better option.

    Caveat Emptor

    There are two main things to be wary of in using the above spreadsheets; that the Discipline spreadsheets require some additional analysis in separating Empowered and regular versions of Prayer of Healing and Flash Heal, and that the Advanced Holy spreadsheet uses approximate methods for calculating overhealing factors for Critical Strikes (due to necessity).
    Solving the Discipline issue: Under various tabs on the log page, there are + signs located to the right that will bring up a new graph showing when the selected spell/ability/buff/debuff was active. Creating these graphs for Flash Heal and/or Prayer of Healing (found under the Healing tab) and Empowered Archangel (found under the Buffs tab) will allow you to compare when Empowered Archangel was consumed to when Flash Heal and/or Prayer of Healing did effective healing. From this, and also clues in the rest of the log (e.g. was Flash Heal cast at all?), the number of Empowered spells, and which ones they were, may be deduced. With the number of Empowered spells determined, the raw and effective healing numbers for Flash Heal and/or Prayer of Healing as a whole may then be split between the Empowered and non-Empowered versions of the two spells in direct proportion to the number of Empowered and non-Empowered spell casts. Note that this split is an approximation; accurate numbers would require extracting the information from logs and then performing an analysis similar to this one.
    The (Advanced) Holy issue: While no additional analysis is required to arrive at the approximation used in the Advanced Holy spreadsheet, circumventing the approximation to get 'exact' numbers is far more difficult than for getting exact healing numbers in solving the Discipline Empowered/regular issue above. An example of an analysis to get such numbers may be found here.

    Links

    The following are links to the maths behind the optimisation process used in the 'HPM Optimisation' sheets of the spreadsheets. I've also added a document that briefly details basic stat weight calculations and how they may be calculated via Taylor series.

    Discipline HPM Equations: Basic ("Extended"), Advanced ("Full")

    Holy HPM Equations: Basic ("Extended"), Advanced ("Full")

    Stat Weights via Taylor Series

    Postscript

    One particular resource that I feel compelled to mention is the first one I encountered when I began theorycrafting - Adinne's HealNotes. Two particular pages on HealNotes are excellent for learning about spell healing quantities and stat weights (The Color of Heals) and for learning about the process used in the optimisation sheets (5.2 Discworld).

    Enjoy!

    PS: While the spreadsheets have evolved a bit from their original incarnations, they do seem to have stagnated in that they're really only doing the same thing now that they were near the beginning of the expansion. If you have suggestions of things you'd like to see added/done to the spreadsheets, feel free to PM me or leave a post in this thread.
    Last edited by Myllior; 2015-10-05 at 03:31 AM.

  2. #2
    This is a great resource Myllior, keep it up
    Disc Priests: Just 2 mana trinkets away from becoming Withered

  3. #3
    Deleted
    How would I go about changing the spreadsheet to the currently tested disc changes(-15% pws)?
    Also, thanks for the spreadsheet its a very good help.

  4. #4
    Alright, I'm sorry but I am looking at math that appears to be Chinese to me. I'm currently trying to help my friend out to calculate her Crit:Mastery ratio to determine which she needs more/less of to gain more throughput. I don't think the spreadsheet of calculating each effective heal's weights is what we are looking for.

    Am I overlooking the basic formula for creating the C:M ratio to play with? If so, can someone enlighten me? Ideally something that is just using character sheet numbers to input and BOOM results? Thanks so much and please forgive my early morning stupidity.

  5. #5
    Quote Originally Posted by Atonement View Post
    This is a great resource Myllior, keep it up
    Thanks! I'm thinking of ways of trying to automate as much of the above as possible...but then my lazy side kicks in lol (hence my super late reply :P).

    Quote Originally Posted by Pssh View Post
    How would I go about changing the spreadsheet to the currently tested disc changes(-15% pws)?
    Also, thanks for the spreadsheet its a very good help.
    You're welcome. I've just uploaded a new spreadsheet with the few changes announced thus far for 6.1. In order to implement the 15% PW:S nerf, cell B15 is multiplied by (1 - 0.15) = 0.85, as the spellpower coefficient is usually where they make the change if they're targeting individual spells.

    Quote Originally Posted by Sacul View Post
    Alright, I'm sorry but I am looking at math that appears to be Chinese to me. I'm currently trying to help my friend out to calculate her Crit:Mastery ratio to determine which she needs more/less of to gain more throughput. I don't think the spreadsheet of calculating each effective heal's weights is what we are looking for.

    Am I overlooking the basic formula for creating the C:M ratio to play with? If so, can someone enlighten me? Ideally something that is just using character sheet numbers to input and BOOM results? Thanks so much and please forgive my early morning stupidity.
    Have you looked at the second tab in the spreadsheet; 'Disc Opt Bound'? You still need to input your spell breakdown as well as your effectiveness factors, but then columns B to E on that sheet will show you how much rating you want in each of Mastery (m), Critical Strike (c), Multistrike (ms) and Versatility (v) in order to be 'optimised' (column A simply shows the sum of the other four columns). If your friend's Priest is not a Worgen nor a Blood Elf, then cell C5 should be changed to 0.10; if her Priest is a Human, then cell E5 should be changed to 0.0377.
    Oh yeah, look at it go! Roll out the barrel; feel it in your bones!
    6.2 Healing Priest Spreadsheets; Legion Holy Priest Rotation Calculator (WiP)

  6. #6
    Deleted
    Sticky this thread!

  7. #7
    Hi Myllior, it's a small error, but D3(which is int in raid) should be C3*1.05 to reflect the int raid buff, I think you accidentally deleted the equation in that box.

    Thanks for the comprehensive spreadsheets. :3

    Edit: Oh, I suppose it should probably count a 250 int flask in the equation as well, so it should be =(C3+250*1.05)*1.05
    Last edited by PosPosPos; 2015-01-14 at 09:51 AM. Reason: adjusted for 5% passive int buff for full cloth interacting with flask
    "My successes are my own, but my failures are due to extremist leftist liberals" - Party of Personal Responsibility

    Prediction for the future

  8. #8
    Oops, thanks for pointing that out! I often overwrite cells entirely when I want to test things; I must have forgotten to change it back D: Needless to say, a spreadsheet that says you have 3922 raid-buffed Intellect no matter what would be peculiar indeed!

    The equation you put down (Pos)3 is the correct one, so I've re-uploaded the sheets with it fixed. Thanks again!
    Oh yeah, look at it go! Roll out the barrel; feel it in your bones!
    6.2 Healing Priest Spreadsheets; Legion Holy Priest Rotation Calculator (WiP)

  9. #9
    Bloodsail Admiral nobodysbaby's Avatar
    Join Date
    Feb 2009
    Location
    Sweden
    Posts
    1,055
    Quote Originally Posted by Myllior View Post
    (Pos)3
    Brilliant... haha

  10. #10
    Quote Originally Posted by Myllior View Post
    Oops, thanks for pointing that out! I often overwrite cells entirely when I want to test things; I must have forgotten to change it back D: Needless to say, a spreadsheet that says you have 3922 raid-buffed Intellect no matter what would be peculiar indeed!

    The equation you put down (Pos)3 is the correct one, so I've re-uploaded the sheets with it fixed. Thanks again!
    :3

    I thought it had something to do with experimentation as well since it was scaling fine in the previous versions.
    "My successes are my own, but my failures are due to extremist leftist liberals" - Party of Personal Responsibility

    Prediction for the future

  11. #11
    Deleted
    I may have missed it, what formula are you using for calculating PoM? I see PoM at 83.26% sp coefficient. wowhead has a rather unintuitive tooltip but as far as I can read it it's 44.2787% sp
    i see you have grace and spiritual healing, are you including divine fury also?

    in your cell for raidbuffed int you have
    =(((C3+(250+50+94.8)*1.05))*1.05)

    what's the +50 and +94.8? I was assuming 50 was from augment rune but I couldn't find anything for 94.8. In any case, it's not matching what I see in game. Are you accounting for cloth spec 5% not increasing base int?
    Last edited by mmocc73a7e76d4; 2015-01-14 at 01:11 PM.

  12. #12
    Quote Originally Posted by Redsparowe View Post
    I may have missed it, what formula are you using for calculating PoM? I see PoM at 83.26% sp coefficient. wowhead has a rather unintuitive tooltip but as far as I can read it it's 44.2787% sp
    i see you have grace and spiritual healing, are you including divine fury also?

    in your cell for raidbuffed int you have
    =(((C3+(250+50+94.8)*1.05))*1.05)

    what's the +50 and +94.8? I was assuming 50 was from augment rune but I couldn't find anything for 94.8. In any case, it's not matching what I see in game. Are you accounting for cloth spec 5% not increasing base int?
    When you look at base stats in the character page, it's already counting the cloth 5%, so there's no need to calculate that in for the entire equation.

    As for PoM, it's a 6.1 spreadsheet, so it's counting 10 bounces rather than 5, hence it's easier to just double the coefficients for convenience.

    Read wrongly, PoM is indeed at 83.26% sp due to one of the last minute buffs holy and disc had before WoD arrived.

    Specifically:
    http://www.mmo-champion.com/content/?page=28 (do a ctrl-f for Prayer of Mending until you find the 69% sp coefficient)

    69% * 125% = 86.25% sp

    44% sp is for shadow spec only.
    Last edited by PosPosPos; 2015-01-14 at 02:05 PM.
    "My successes are my own, but my failures are due to extremist leftist liberals" - Party of Personal Responsibility

    Prediction for the future

  13. #13
    Deleted
    Quote Originally Posted by PosPosPos View Post
    When you look at base stats in the character page, it's already counting the cloth 5%, so there's no need to calculate that in for the entire equation.

    As for PoM, it's a 6.1 spreadsheet, so it's counting 10 bounces rather than 5, hence it's easier to just double the coefficients for convenience.

    Read wrongly, PoM is indeed at 83.26% sp due to one of the last minute buffs holy and disc had before WoD arrived.

    Specifically:
    http://www.mmo-champion.com/content/?page=28 (do a ctrl-f for Prayer of Mending until you find the 69% sp coefficient)

    69% * 125% = 86.25% sp

    44% sp is for shadow spec only.
    ta for the clarification.
    edit;
    actually in that datamining it looks like an error counting the glyph?
    will do some testing in game and get back to you
    Last edited by mmocc73a7e76d4; 2015-01-14 at 02:51 PM.

  14. #14
    Quote Originally Posted by Redsparowe View Post
    ta for the clarification.
    edit;
    actually in that datamining it looks like an error counting the glyph?
    will do some testing in game and get back to you
    It's probably a combination of bad datamining, patch notes lost in translation and hidden obscure passives adding up to one annoying clusterfuck. Makes it really difficult to actually calculate the accurate healing of spells this way tbh.

    Thank you Blizzard /sarcasm.
    "My successes are my own, but my failures are due to extremist leftist liberals" - Party of Personal Responsibility

    Prediction for the future

  15. #15
    Deleted
    Ok after some testing it appears to be;

    66.666...%SP * grace 30% * versatility% * mastery(/2) * spiritual healing 25% * divine fury 25%

    so it should be 83.333...% if the divine fury is baked in. This matches what I see from the actual heal in game although the tooltip seems way off

  16. #16
    Deleted
    Now I know, where all those Elitistjerks forum members came
    Also I'm sorry for offtopic

  17. #17
    Just downloaded the recent version(thanks again for the work!) I noticed PWS still has the 600% modifier. Shouldn't it be 510 after the nerf?
    Last edited by Aparthia; 2015-01-14 at 06:11 PM.

  18. #18
    Quote Originally Posted by Aparthia View Post
    Just downloaded the recent version(thanks again for the work!) I noticed PWS still has the 600% modifier. Shouldn't it be 510 after the nerf?
    If you downloaded the version at the top of the post, it's 510.
    "My successes are my own, but my failures are due to extremist leftist liberals" - Party of Personal Responsibility

    Prediction for the future

  19. #19
    upboat on the sticky

  20. #20
    Quote Originally Posted by Redsparowe View Post
    I may have missed it, what formula are you using for calculating PoM? I see PoM at 83.26% sp coefficient. wowhead has a rather unintuitive tooltip but as far as I can read it it's 44.2787% sp
    i see you have grace and spiritual healing, are you including divine fury also?
    I never noticed that Divine Fury has a component that increases Prayer of Mending's healing. An interesting find (and thanks for pointing it out); it would be nice if the tooltip itself at least hinted that there are extra effects. But yes, the spellpower coefficient for Prayer of Mending is back-calculated from its actual healing amount with all the passives I'm aware of. I'll leave the coefficient as it is for now, and put a note in for Divine Fury.
    (Oh, and there's the extra 10% on Flash Heal and Heal for Discipline hidden inside Grace!)

    Quote Originally Posted by Redsparowe View Post
    in your cell for raidbuffed int you have
    =(((C3+(250+50+94.8)*1.05))*1.05)

    what's the +50 and +94.8? I was assuming 50 was from augment rune but I couldn't find anything for 94.8. In any case, it's not matching what I see in game. Are you accounting for cloth spec 5% not increasing base int?
    You're looking at the example spreadsheet there, so the 94.8 Intellect was to account for 9.48% uptime on the +1000 Intellect potion in the log I analysed. As Pos said, the sheet works from the Armory/character pane value for Intellect, so things like the armour specialisation are automatically included properly (at least, they should be).

    Quote Originally Posted by Aparthia View Post
    Just downloaded the recent version(thanks again for the work!) I noticed PWS still has the 600% modifier. Shouldn't it be 510 after the nerf?
    Quote Originally Posted by PosPosPos View Post
    If you downloaded the version at the top of the post, it's 510.
    Ah thanks for finding that; I've kept separate versions of the spreadsheet for 6.0 and 6.1. I've updated the lower link so it should also lead to the 6.1 version.
    (EDIT: Have changed the structure of the first post; spreadsheet can now only be downloaded from the top of the first post).

    There's also one minor change that I should probably make, but can't test. Namely, I've currently got the spellpower coefficient for offensive Penance to be 120.96% (due to the 20% increase on the old 100.8% value), but the updated Penance tooltip is 120%. It would only be a minor change, but I've a suspicion that the Wowhead tooltip should be accurate for it. I'll think about it, just wanted to make people aware of it in the meantime.
    Last edited by Myllior; 2015-01-17 at 12:24 AM.
    Oh yeah, look at it go! Roll out the barrel; feel it in your bones!
    6.2 Healing Priest Spreadsheets; Legion Holy Priest Rotation Calculator (WiP)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •