Jezele

I'm not sure how hard it would be to incorporate, but since you're providing HEP for various items, it might be nice to toss in a chart at the end, something along the lines of:

Tier 7 2-piece bonus HEP value: W
Tier 7 4-piece bonus HEP value: X
Tier 8 2-piece bonus HEP value: Y
Tier 8 4-piece bonus HEP value: Z

That'd answer those questions directly when trying to put together a gear set that is "best in set" for your particular casting style.

 

Jessamy

Measuring the healing benefit of the T8 2-piece bonus is complicated. During a fight with lots of movement, it's great. When using RT-HW-HW, it can increase output. But how much of an increase does the bonus give over what we would have been able to do otherwise? It's not an easy mathematical bonus like the T7 bonuses, but rather it frees us up to have a more flexible healing style. How do you measure that? Providing hep values for the other bonuses will undervalue T8 gear, since the T8 2-piece bonus has value, even if it can't be quantified.

 

Gbits

I agree - the 2 pc is almost entirely based on playstyle. I'm pretty sure calculating the 4 pc bonus would be worthwhile/possible, though. I'm just too math-challenged to do it myself - hoping someone might be able to help.

 

Daidalos

Its not that hard to do the 4pc. I'll see if I can throw it in to my sheet.

Edit: added it to my sheet. Assuming CH spam is a reasonable amount of your healing it pretty much guarantee that 4pc t8 will trump any other gear.

Restoration Shaman calculations:http://spreadsheets.google.com/ccc?k...IWv3sPmcYnEJUg

 

Daidalos

Updating my sheet for the proposed 3.2 changes. I'll update further as I learn more. The change to the CH bounce looks like it will make a nice difference. Also ff you get the full mana back from WS on any ch bounce CH is going to be extremely cheap.

Edit: I am leaving my stats2 calculations as current live calcs if you want to use live calcs or want to compare 3.2 vs live.

Edit2: Updated stats1 calculations with latest info.

Restoration Shaman calculations:http://spreadsheets.google.com/ccc?k...IWv3sPmcYnEJUg

 

Daidalos

Sheet is updated with 3.2 mechanics and added t9 bonus HEP calcs. After last night I've noticed ch is now a greater % of my overall healing making 4pc t8 now out weighing both t9 bonuses. I also changed my wowhead loot rank to use epic gems. Seems likely I'll keep 4pc t8 around for a ch set unless I can get 325 haste from 4 pcs of t9 without losing any other stats.

Restoration Shaman calculations:http://spreadsheets.google.com/ccc?k...IWv3sPmcYnEJUg

 

Corunix

I wonder if Spell Power (Stats C7) should include Nature's Blessing effect (Stats F24)?
Without it, intellect does not seem to have effect on healing calculations.
Also, it might be worthwhile to integrate crit bonus from Intellect buffs (MotW/GotW, AI, BoK), since now raidbuffed intellect is proper, while crit is not.

 

Daidalos

Since nature's blessing is already included when you look at your stats in game I opted not to factor int into base spell power. However for my int HEP calculations the spell power is taken into account. If you wanted an option to enter spell power before nature's blessing (if you were building a BIS or something) I could add an option to add in the extra spell power.

In other news I'd added overhealing calculations so that haste's HEP will go up to some extent and crit HEP will go down to some extent due to crit over heals.

Restoration Shaman calculations:http://spreadsheets.google.com/ccc?k...IWv3sPmcYnEJUg

 

Corunix

Actually, I was trying to model my idea about partial intellect gemming (since Rawr.RestoSham module is broken beyond repair, your spreadsheet remains the only source of reliable math I know of), and I was looking at how much LHW/CH would heal for -- when I found out that changing intellect does not affect those values, I thought that there's some kind of an error in there =) So, yes, an option to include intellect in in +healing would be a good thing.

 

Daidalos

I created an option to add in the spell power from nature's blessing. I will set it to 0 by default since I assume most people just put in what they see in the characters stat screen, but simply change it to 1 and it will add in the spell power from int.

Restoration Shaman calculations:http://spreadsheets.google.com/ccc?k...IWv3sPmcYnEJUg

 

Daidalos

In the stats 1 and stats 2 sheets I have added some haste cap calculations. I added haste rating needed to hit the 1s gcd cap with and without lust for 1.5s casts, HW with tidal waves up, and 2.5 s casts.

Restoration Shaman calculations:http://spreadsheets.google.com/ccc?k...IWv3sPmcYnEJUg

 

tenaveran

I've been using Shaman_hep for quite some time now and I decided to pop numbers into Diadalos' spreadsheet for the first time. Thus, I have a somewhat newb question to ask about how to use the spreadsheet.

On the Overview tab where it asks the weightings of the various healing spells, it it looking for the percentage that you *cast* those heals? Or are we putting in what percentage of our healing numbers that spell provides? In other words, can I take the "% of player's overall" stat from a Shaman_hep report and plug it into the weightings on the spreadsheet? Or do I need to calculate the percentage of casts that particular spell uses?

Thanks in advance for the assistance.

 

Daidalos

You don't need to figure out percentage of casts, its simply the healing breakdown in recount/World of Logs or % of player's overall.

You will get a little different results from Stass's mod simply because I decided to adjust overhealing into HEP values a little differently. I use my sheet for a "what if..." and then play with stats and see the result. Stass's mod is "What is.."

I also just added haste cap amount for various cast with and without bloodlust and berserking.

Restoration Shaman calculations:http://spreadsheets.google.com/ccc?k...IWv3sPmcYnEJUg

 

tenaveran

Exactly what I was hoping for. "If I change gemming/gear like X, how does that affect Y?"

Thanks again for your help and for the great tools.