TreeCalcs: WrathCalcs, respecced
 

Ok, so since I'm playing Resto most of the time these days, and I already had this great Moonkin spreadsheet sitting around, I retooled it for Resto purposes. For those of you who've never used WrathCalcs, the focus is on providing accurate marginal values of stats/talents. The basic idea is to have accurate numbers on what all our spells do. Obviously we're not always playing to maximize some numerical output like DPS are, but good spellcasting decisions rely on knowing how much each of our spells do, and perhaps more importantly, good gearing decisions require knowing what each stat does for all of our spells. For now, it's focused on raw HPET of all healing spells, but I can refine that if it becomes important for anything.

Input stats/setup on the front page. Next to each stat/talent/set bonus, etc., there will be marginal HPS/MP5 benefits. For stats, it shows the benefit of having 1 more of that stat. For talents and other bonuses, it shows a) if you have no points in the talent, the value you would gain from one point, b) if you have points, the value you currently gain from those points (i.e. the amount you would lose by dropping them).
All of these computations are derived from a spellcasting cycle you pick in the bottom-right corner. For now I lazily just put in a Rejuv5-WG one to get going, but I'll add more as I think about useful spellcasting scenarios to model.

Since healing, unlike DPS, isn't quite as focused on the singular output from one rotation of spells, the second page becomes a bit more important. It lists all spells, the HPS/MP5 of each, and the amount which that HPS/HPM of each would increase from added points of spellpower/haste/crit. The top box on this page will also contain a bit more info on spellcasting cycles once I come up with them.

Any suggestions are welcome. Basically, the framework is there to model any combination of spells--tell me which ones you think would be useful to add. Also, ignore all the residual Moonkin stuff; it will just get worked out as I replace it.

Updated version lives here now:
http://elitistjerks.com/f73/t88239-r...ion/#TreeCalcs

Excellent idea, will be useful to get more into the guts of resto rotations.

Perhaps add options to analyse the effect the 3.3 changes will have on our rotations (new glyph for hasted Rejuvenation, one less Rejuvenation tick per cast, tier set bonuses)?

Also, shouldn't Healing Received & All Haste have an HPS value attributed in Raid De/Buffs? Focus Magic is showing as a negative HPS value if you don't have the buff, I think that should be a zero value with extra HPS being attributed if you do have it? Just a quick look during my lunch break, will have a closer look tonight.

Looks pretty good. I didn't realize Tranq benefited from EmpRej, but logs confirm you are right.

With 4t9, Insightful should provide some HPS (21 Int, and int is showing .32 HPS with 4t9).

There is now an 8% BoK (Drums). Probably an issue on Wrathcalcs, too.

If tabs like Regrowth would show min/max non-crit, min/max crit, and min/max Living Seed, it would be easier for people to compare the spreadsheet with logs, and find bugs (either in the spreadsheet, or in their input to the spreadsheet).

Glyph of Healing Touch is additive (subtractive) with GoN. So HT formula should be
... (1+.02*GoN-if(GHTActive,.5)) ...
Reference is here.

For tank healing rotations, I like to assume that on average, Rj and Rg is refreshed a bit late (so perhaps the Rg is cast, on average every 28s, and Rj is cast, on average, every 19s, currently). The only way to not be late is to sometimes not be casting (or to clip a HoT).

If using a Lb3Slow, I assume that the initial cast (after the bloom) is a bit late, and that one of the two "refresh" casts is an entire tick too early.

If someone has Glyph of Regrowth, the tank cycle should be 8 ticks and roughly 25s.

In your first post in this thread, you misspelled "haste" as "hit."

The 3.3 Rejuv-haste idea wouldn't do anything in this model, since it doesn't change the HPET of Rejuv casts. The 2T10 I can put in once we know the numbers. 4T10 will basically just a be a multiplicative buff to Rejuv--doesn't change too much materially.

Right now the All Healing Recieved raidbuff doesn't do anything since it assumed you have it from your own Tree form. I'm going to take that out; then you'll be able to see the individual effects of ToL mana reduction, iToL, ToL aura, and MSS more easily.

Erdluf:
The meta/Spark lines only show the proc/bonus on the item, not the passive stats gain. Basically, things are always set up so the stat values in the top-left match those you should see on your Armory--makes it much easier to use. So the "Insightful" line right now only shows the gain from the proc (also, I think I have to fix the way the "Ember" one works).

Right now I'm approximating slightly on HoT reapplication times being instantaneous. It's the same assumption that's always been made in WC--it would probably complicate things a lot to try to estimate the gap. I'll consider adding half a GCD to each. LB stacking already accounts for clipped tick--I should add it somehow to Regrowth.

Updated--fixed BoK, Ember meta, LB rolling, Tree form, Glyph of HT.

Added a version reflecting known 3.3 PTR changes.

Updated--put Rejuv tick back in, added a simple model for T10 set bonuses and T10 idol.

Updated 3.3 sheet for newest GOTEM functionality.

Apparently the 2T10 is datamined to be "reduces WG decay by 30%." I put in my best guess as to how that will work numerically. I'm pretty sure it's a pathetic set bonus regardless of how precisely it works.

When I plug in Ember to the meta, it gives me like a 11.94 HPS increase. I understand that the 25 SP from this is figured in the above SP part, but how does the 2% int figure in as HPS? Or what part is altering it. Chances are I am missing something big, but I didn't dig through the spreadsheet TOO much, as it is a little easier to ask how you set it up.

EDIT: I do not have Lunar Guidance on the spreadsheet.

Do you have 4T9? Then the int gives a bit of crit. Can't think of anything else offhand.

entia non sunt multiplicanda praeter necessitatem

Aye, that is exactly what it is. But isn't that intellect already figured into the base stats at the top of the page?

Yes. But for all talents/bonuses that add to your "armory stats" (Ember, iMotW, Lunar Guidance, Living Spirit), the sheet jumps through some hoops to still accurately figure out how much you're getting from the talent.

Hello

I am trying to figure out what and where to put into the MP5 cell (C9) as inside it has a formula saying

(3.3 sheet has)
so I would assume that "195" or "241" are you counted MP5 gear numbers and I would have to put mine at that place replacing only these numbers and leaving the rest of the forumula intact?

You might think about moving that forumula to another cell and leave C9 just for the raw number for confused users like me in the future :-)

No, I was just estimating my own MP5 return from Sif's/Show of Faith. Just put into that box whatever is your static MP5 value from gear bonuses.