[Resto] spreadsheets and calculations
 

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?

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

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.

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

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.

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.

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.

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.

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!

Perhaps this will give you some ideas.

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.

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.

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

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.

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.