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'sin-game, non-raid-buffedstats (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.