Daidalos

I've been maintaining a resto spread sheet since the level 60 raiding days. I thought I would make a separate thread for those who wish to contribute and share their own spreadsheets.

A note about the my spreadsheet:
I periodically check the TC'd values in my spreadsheet as I get new gear and once thing I've noticed is that my healing wave calcs are slightly off.

To test I just buffed myself with ELW and went off the values shown in the paper doll for healing power.
I looked at the max projected values from healing wave.
I spammed healing wave for 10-15 mins and looked for the highest amount I got (8008)
(I do not have healing way but all the other talents that affect HW)

using the formula in my spreadsheet
using 3466 as the max amount hw heals for unbuffed
with 2106 healing power
(3466+(2106*(1.88+.2)*(3/3.5)))*1.1 = 7942

this was below the experimental result so I tried to change the formula but the only thing close I could get was
(3466+(2106*(1.88)*(3/3.5)*(1.2)))*1.1 = 8292
this seems too high to match my in game results.
Anyone have any ideas?

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

 

Pitbuller

If my memory serve me right then it should be:
(3466+(2106*(1.88*(3/3.5) + 0.2))))*1.1 = 8009

Slow, slower, shaman weapon.

 

Daidalos

Ah thanks that fixed it. <shakes fist at order of operations>

If anyone else has any comments/requests or their own sheets feel free to post.

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

 

chloebelle

Apparently I am a huge noob and posted this in the wrong spot

OK well... I spent some time making a spreadsheet. I looked at numbers from several WWS and utilized some of the formulas already out there. I had to make assumptions to simplify the math but, given time, I hope to incorporate all scenarios. The goal was to move stats around to see how it would impact average heals and overall heals. I tried to allow for the varying of casts since many shamans prefer to heal differently. I tried to incorporate as many talent buffs as I could, but some where left out. The top of the doc lists the assumptions I made.

I am hoping that people here can take what I have done and roll with it or help me out to adjust it for the best possible use. It is not completely ideal but you should still be able to adjust the numbers correctly to give you a good idea of what increasing SP, removing AA, taking EW, removing Imp Water Shield, increasing intel....etc, will give you.

It can be found at the following link:
http://spreadsheets.google.com/ccc?k...mbxXKS7JEHENOA

I expect there are errors but I have been staring at this so long, I wanted to bounce it off some others.

If there are any questions about my math or anything at all, I will be happy to answer. Just want to get whatever feedback I can.

Thanks!

PS. Not everything is updated automatically. For example - if you increase your intel - you must manually increase your SP and crit.

The tables should all update automatically but if you notice something that isn't - either they don't connect or I messed up. Let me know either way

 

Daidalos

Couple things I noticed you seem to have crittable hots for riptide... I'm not sure why you have that. It would be easier on my eyes if you consistently rounded to either the nearest whole number or hundredths or something like that. Having 8 decimal places doesn't really help anyone. Also whats the "% damange" column? Is that % of total heals?

Also some of your calculations are wrong. Feel free to look at my formulas in my sheet and pm me if you have any questions. I just did some spot checking but Healing wave for example are off.

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

 

chloebelle

The riptide was just a mistake. I created copied/pasted/edited formulas and then deleted crit where not needed - this was an oversight - thank you.

Sorry about the rounding, I had been staring at the document forever and inevitably forgot to make some final edits.

Damage was incorrectly typed - obviously supposed to be healing.

These have been updated, hopefully it helps.

http://spreadsheets.google.com/ccc?k...mbyIAJr863f_Uw

It obviously has a lot of work to be done. I just started working on it and I wanted to get feedback on the ideas. To be honest, I am a little embarrassed about even posting it as of yet. I kinda wish I could rewind and undo it.

 

Handyhoof

Chloebelle, I'm looking over the spreadsheet and have a few recommendations. I'd suggest asking for spellpower and crit rating and converting them to healing and crit chance. This way you can convert intellect automatically. Also, instead of making assumptions about buffs, you can add a field/checkbox/whatever to ask for buffs to make sure they are calculated correctly. I do like that you ask for rotation. That's a nice feature with some good potential. It could use some overall polish, but not a bad first iteration.

 

Daidalos

Nah its fine, I started out with a list of gear and then I tried to compre them so had to start doing more and more math. I was trying to prove to my guild that I should be allowed to roll on cloth and leather since all the mail in aq40 sucked. They didn't believe me so I had to show hard numbers. It went through many many iterations. Don't sweat it. This thread is to share, compare, refine, suggest, and so forth.

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

 

chloebelle

Thanks for the advice guys. I am going to keep polishing this. Initially I was arguing about AA, EW, Imp WS, and some others with people. I added in spell rotation because it tends to have a large impact on what you should stack and how you should spec. If you cast LHW 5% of the time, how much would it actually help for me to use the LHW glyph and likewise, if CH is 75% of my damage, would EW actually help more compared to maxing IWS.... etc

I wanted to look at these numbers myself and determine, for my healing style, what stats were best.

Daidalos's spreadsheet is great and I am going to use some of the ideas there to help me incorporate talents and buffs into my numbers. Despite the initial feelings of "OMG there is soooo much I should have done before showing anyone" ... I am going to keep working on this.

Thanks again and keep the suggestions coming!

 

Durnitol

Perhaps this will give you some ideas.

 

Daidalos

Yes previously our heals didn't have any synergy so I never bothered with spell rotations, but adding in rotations of rt/lhw/lhw, rt/hw/hw, rt/hw/hw/ch etc are next on my to do list. HPS HEP and regen HEP will be implemented after that most likely.

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

 

Yekkom

Daidalos,

Looking at your spreadsheet I noticed you are using [Totem of Healing Rains] for your plus to chain heal totem. I have been using [Totem of the Bay] which is a slight upgrade in fights where mana is not an issue.

 

Daidalos

I was debating if I should include every relic or just allow you to enter the additional amount then I forgot about it. Its changed now so you just enter the additional amount given to that spell

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

 

chloebelle

Hey, I realized that mine was leaving out the purification factor. Other then that I think my calculations are correct. You mentioned healing wave was wrong... but I have:

=(Base+ (3 / 3.5) * 1.88 * (Spell Power))*1.1 (for purification)

The thing I noticed in yours is that your default value is including the 20% tidal wave bonus, which I was excluding from my average. Did you want your average healing wave to assume that you always had the tidal waves buff?

I noticed some things that I did wrong (like not reading the tool tip and doing 20% of bonus healing effects as opposed to a 20% increase).

Anyway, I am working on updating it and I will post again when I have made more progress. Thanks again for the help.

 

Daidalos

I think you are getting confused. Tidal waves has 2 effects.
1. Decreases cast time on the next 2 lhw/hw after a rt or ch.

2. Static increase gaining an additional 10%/20% of your spell power to your lhw/hw.

So yes tidal waves will always be applied to your healing amount calculations if you have the talent. its only situational for if the cast time is reduced.

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

 

aureon

I just made a spreadsheet that is incredibly easy to use, and giving you the information you need to excel in a raid environment. My spreadsheet is currently a work in progress, there is currently no implementation of Nature's Blessing, so if you add int to check for upgrades, be aware that you will need to manually adjust the spellpower; this seemed the lesser of 2 evils, since for the easiest use the end user would rather just copy their stats out of the character pane.

Here's the link to the google code page: Google Code
Here's the link to the Gameriot download page: Gameriot; this one is going to be updated more often.

Feature's I'm currently looking at:
1. Engineer a solution for theoretical +int to translate into extra spellpower; along with that an entire raid buff menu that's simple to use.
2. Simple healing rotations such as Chain heal -> LHW -> LHW, and showing the HPS and MPS from that.

 

Handyhoof

I have created a healing Shaman spreadsheet. It is currently very powerful, taking into account all talents, buffs, glyphs, and meta gems. It is however still in Beta and needs feedback and testing.

Resto.ods - FileFront.com

There are macros that have functionality only in OpenOffice, but they only control the buttons in the talent calculator and the HEP calculator. The talents can be entered by hand, and I haven't figured out an elegant way to do the HEP calcs without a macro yet.

 

Jerem

I am currently having a look at your sheet Handy (thanks for the time you invested, by the way).
If it is not too much trouble for you, I suggest you upload a .xls version of it as well.

As it is now, I had to download the file, open it in Google Docs, and save it as .xls, to finally open it in Excel.
From what I've seen in the Hunter Spreadsheet thread(s) over the past year, you can expect multiple questions about that, I'm afraid

 

Handyhoof

I saved my current file in Excel format. I'm fairly certain it broke at least the HEP calculator macro. All the base fuctionality should still be there, though. I'm not going to go out of my way to support an Excel version, but when I update the file I'll make sure to convert it and post it.

Edit:
I would also recommend against loading it into Google Spreadsheets. I tested that as a hosting service, but it does not have a level of fidelity with which I'm comfortable.

 

Brohuld

I have worked some time on another Excel model for Restoration Shamans out there. Hope somebody can find it useful. Appreciate any comments of course- have tried to debug as much as I could but you nerver know.

Restoration Shaman Simulation

 

Daidalos

I've updated my sheet a bit. I've added in HPS HEP calculations for lhw, hw, and ch. I left out riptide due to the hot nature of it and it being a small part of our healing but if people really want to see it I can include HEP for it as well.

I am debating adding in HEP for regen but it really boils down to crit and replenishment and mp5 as our only regen so its going to vary on your raid make up and rotations a lot. Do people want this or is this more of a based on my experience kinda thing?

Also I added in the glyph for earth shield assuming it a 1.2 multiplier after all other calculations are applied.

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

 

Skyhoof

Daidalos:

This is a great addition to an already extremely useful spreadsheet! And it confirms mathematically what many of us have suspected: Haste is more valuable than crit. Keep in mind the HEP doesn't take into account the hard-to-quantify benefits of criting such as Improved Water Shield and Ancestral Fortitude. This makes crit more valuable than it looks on paper but probably never as good as haste.

Some observations

• HPS is about the same for HW and LHW using this model (and we know that HW overheals more often in reality)
• Chain Heal has the highest HPS (as long as you hit multiple targets)
• Regardless of how much spellpower you have, Haste is worth about 2.95 times as much as Crit using Chain Heal
• Regardless of how much spellpower you have, Haste is worth about 1.7 times as much as Crit using HW and LHW
• At 2500 spellpower with 400 haste and 24% crit (38% on heals), you would get the following HEP values
  • CH: 10 spellpower = 9 haste = 3 crit
  • HW/LHW: 10 spellpower = 12 Haste = 7 Crit

Does Haste really benefit LHW as much as the spreadsheet shows? Tidal Waves lowers the cast time of LHW by 30%, which results in a cast time of 1.05 before we take into account haste from your gear. So in reality, the benefit that haste provides to LHW is capped at about 100 haste from gear if you take Tidal Waves into account. This might be quite difficult to show on the spreadsheet but it's worth keeping in mind when trying to establish some HEP values. Also, it would seem that Haste is actually MORE valuable for Chain Heal since there is no other way to decrease CH cast time while you can use Tidal Waves to cast HW and LHW more quickly.

We should try to establish some HEP values using this spreadsheet as a baseline and adjusting the values as necessary for other game mechanics.

The chart below is based on having 400 haste and 24% crit (38% on heals) with only the amount of spellpower changing

 

Daidalos

This is why I might add crit regen. I could make MP5 Equiv Points / MEPs (makes me of Beaker from the muppets for some reason) or some such. In my sheet I do not calculate LHW using TW cast time at all. So basically I count LHW as gcd time. Haste lowers the gcd so LHW scales nicely with haste. The fact that the actual time to heal is lower than the gcd doesn't really affect any math here (although its a great benefit for landing a heal before someone dies.)

As for the numbers you listed HEP means healingpower equiv points. So if haste has an HEP of 1.2 then 1 haste equals 1.2 healing. To convert this 1.2 healing to crit you div by the crit HEP then mul by the amount of haste you are converting from. I added a little conversion between crit and haste so you won't have to actually do this.

When I look at the numbers for the stats you list I get
CH: haste HEP = 0.91, crit HEP = .31
so we can see healing is the best followed closely by haste then distantly crit
10 haste rating= 9.08 healing = 29.70 crit rating

here we see haste is the most valuable followed by healing and not too far back crit,
HW/LHW: haste HEP = 1.20, crit HEP = .68
10 haste = 11.96 healing = 17.28 crit rating

I think this makes crit a good stat for hw/lhw considering the increased mana back as its decent hps gains but this is really only good for single target healing.

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

 

Daidalos

I added INT HEP and haste crit and int MEP calcs. Feel free to dissect, find errors, or give feedback

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

 

Slurpeedelic

Can anyone please give me the formula for Chain heal HPS? I've been looking through the forum, but cant find it.
would really appriciate it. thanks