Yeah, 5.2 Solace looks really good for Disc. Assuming you use Holy Fire at all, at the very least you can replace Holy Fire (costing 1.26% with Evangelism) with Solace (costing -1%). Do that about 3 times a minute for a net gain of 7% mana, which is roughly the gap between Shadowfiend and Mindbender, and the rest is gravy. Not to mention making HF instant instead of 2s cast.

I'm less convinced for Holy since Holy doesn't cast Holy Fire to begin with. So at best you get 6% a minute out of it.

Got Disc info into the sheet. The individual spell data should be in pretty good shape. As far as rotations, it's about as far along as the Holy one was. There's a decent model for Archangel/Evangelism. There isn't really one for Borrowed Time or Grace yet, but those are much more minor effects.

Remember, this has the 5.2 versions of PoH, PWS, Penance, and PW:Solace. Penance and PW:S are both extremely good now.

Just some notes as I go through the recent version:
I think Divine Insight uses the Holy version for Discipline currently. Checking it increases HPS and PoM ratio significantly.

Is Inner Focus currently supported? It shouldn't be a problem to determine its average cooldown considering you already know GH frequency. Then you could just have it prioritize PoH>GH>FH depending on which of those are included in your fillers.

If you're already including 5.2 data, you may want to quickly implement the new Binding Heal glyph. It allows Binding Heal to hit a third target at an additional 35% mana cost. It also looks like Binding Heal isn't supported as a filler right now even though it has pretty good HPS and HPM - and those would increase when glyphed.

PW: Solace only seems to work for Discipline. Holy doesn't seem to gain any MP5 from it even with a high amount of idle time.

Ah, that's right. Although, the Disc version doesn't affect anything that's modelable on paper. The extra PWS you get is a normal PWS for all intents and purposes; you just get to cast it on a target you otherwise wouldn't. So it will be a blank talent in the sheet. I could make it add a PWS for each proc, but you could do the same thing by increasing PWS casts in the rotation, probably not worth bothering.

I am currently working on a spreadsheet (for a month or two). It will be no where as "massive" as Hamlets sheets I guess, but that wasn't my focus when I started it. My main focus was to provide me with accurate data in terms of hps, hpm, hpet and I think that part is pretty much done.
At the moment the layout and some other stuff is still pretty beta and you have to input stats manually (int, spirit, crit/mast/haste ratings) because I just started working on an armoryimport function with the community api.
But I guess I could provide it if people are interested in it. Just let me know

First off, I edited in some more things I noticed while you were typing, you may want to take a quick look.

Additionally I'm not sure how you'd want to implement it without it becoming too cumbersome but you may want to include the shield caps (40% of Priest's HP for DA and 60% for SpS). I'm not talking about including multiple spells' capping the absorption here as that's similar to overheal but with current gear you're already running into single spells overcapping and having their DA shields reduced by the cap. Thus mastery value for those spells is actually zero unlike the (low yet existant) value listed in the spreadsheet.

This is mostly true for GH right now but it may easily extend to other spells in the future considering health scales linearly (with stamina) while DA shields show cubic scaling behaviour as they scale with SP and mastery.

The main problem I see with an implementation is that you'd probably need to divide heals into different phases (e.g. with/without Archangel) to get proper results on how much of the time you're overcapping.

Edit: Just a sidenote. The spreadsheet shows pretty well how bad Holy actually is when you cannot spam PoH exclusively in 5.2. Tinkering around with TreeCalcs, HolyCalcs and the T14H gear in each of those you can quickly see how bad Holy's mana situation is. E.g. aiming for 150k HPS while still having 10% of idle time filled with FH/RG, adjusting reforges from Holy to Mastery and then adjusting Reju/PoH to get roughly 150k HPS, I ended up at roughly 200 seconds to OOM for Holy and 300 seconds to OOM for Resto. Now if you include Restoration Druid's flexibility (Reju not bound to groups and moveable while casting unlike PoH, Druid able to switch to efficient tank-heal and back on the fly without waiting for Chakra cooldown), Holy seems just like a gimmick spec you bring in 25 man fights where you're able to effectively chain-cast PoH all day long.

Thanks!

HPET/HPM info of each spell is in the "individual spell data" box on the bottom right of the first page.

I want to keep it up at least somewhat. In truth I really only made it because I wanted to work out all the HPET/HPM comparisons for all the spells and building it into TreeCalcs was the easiest way. That's why I haven't really overhauled the rotation tab/inputs. I think it's more likely that if ever redo the ones for TreeCalcs I'd copy them over here. Also, Tecton is the one who manages the gear selector and I'm probably not going to conscript him to keep up more sheets.

Let me see how far I get with it before 5.2. In general I'll probably keep revisiting when there are obvious spell changes, but if you guys like it and really want to get it really robust we should probably see if someone from here will eventually take it over.


Will think about caps. The gear tracker does include Stamina, so maybe would only be a little work. You're right about the quadratic scaling. Maybe for now we can hope that if people shed mastery in 5.2 it will delay the problem for a while.

No, Don't have IF yet, will have to put something in.

Glyph of Binding Heal is in and works in the spell table, it's just not in the rotation. Probably should be as another filler spell.

I didn't add PW:Solace for Holy. I should for completeness, but I think the 5.2 version with a cooldown is going to be weak for Holy; it no extra healing, eats a lot of GCDs which is impractical, and still is a little less mana than Mindbender.

I'm wary of doing straight cross-class comparisons based on total raw HPS output in the sheet. That number is just a bit too far removed from actual context I think. One of the things I'm hoping to use the sheets for is to get into better analysis of class balance armed with the comparison info for the individual spells. I do agree Holy has issues though, and one of the obvious points looking at the table is that it no spell with anything like the sheer strength of Penance.

Removed Divine Insight proc for Disc.
Added PW:Solace for Holy. The modeling is a little weird since currently adding an on-cooldown spell removes some cast time from fillers, so it looks it like gives you back extra mana and loses some HPS. The conclusion is the same though when you look at the combined HPS/MP5 score--slightly worse than Mindbender.
Added Binding Heal filler.

Just an additional small thing that's linked to my note about Holy above:
You may want to give the option to disable rotational spell usage for some Holy spells. For most cases, PoH has higher HPS than CoH and higher HPM than CoH and some level 90 talents. Using those on cooldown drains lots of mana, especially with 4T14, you'd often spend on PoH in 25 man raids instead.

It would probably make more sense to allow the user to set an interval for those abilities even though it may clump the UI a bit.

I'm updating this now, apologies for the delays (in a new position at work and free time isn't exactly plentiful!). As far as gear updates/etc for future patches it'd probably be best to have someone from the Priest community taking that over. I can give you an update on how to import gear/etc (it's very easy, just takes a bit of time).

Added:

• Armory import (gear and enhancements) and upgrades have been added.
• Layout tweaked to match Wrathcalcs, which will make maintenance easier going forward.

Doesn't sound like much, but took a while!

In the works:

• Talents/Spec detection. Having some difficulty with how to handle this as so many of you guys use Holy & Disc as active specs (for obvious reasons). Probably best to just let you toggle this manually? I've ignored glyphs under the same thinking for now. We do need to standardise wording on these too (i.e. use the official talent names/glyph names in the dropdowns, but that's not a huge deal).
• Profiles. I'll update this once things are a bit more bedded in.
• Race detection, purely because I don't have the base values. Can someone provide a list of the base values for each race of priest?
• Gear list. There are probably one or two things missing as I'm not as familiar with cloth drops. If you spot anything, just post up and I'll add it.
• Speaking of which, I need to update to the new Wowhead XML layout for this sheet, it looks like it has changed slightly recently.

Please note: this is a first attempt for Priests, so there will likely be some teething issues. Please let me know if you spot anything, as I don't have a priest so won't be making as much use as I do of the Druid spreadsheets personally.

I have some nice idea for spreadsheet.
In past I modify healing spreadsheet to enter manually Overheal level to each spell, because stat scaling wont be accurate w/o these numbers.

It was something like this:
PoH 20%
DA 10%
Attonement 50%
and so on

By default all these OH numbers were set up at 0%
In all formulas about HPS or HPET I add one multiplier *(1-Spell_OH/100), where Spell_OH is number for appropriate spell.

And then stat scaling were may more close to reality.

I saw these numbers in WoL records and manually enter them in 10sec.