Introduction

There’s no doubt that TreeCalcs is the most popular Restoration Druid spreadsheet available for us, but it has a few issues that bothered me a lot, and I’ve found it unsatisfactory for helping me to select the best healing gear for myself and to determine relative stat values. So I wrote my own Spreadsheet that will answer the questions that I look for, and it’s publicly available for anyone that finds it useful.

  1. TreeCalcs uses separate “HPS” and “Time to OOM” measures. Unfortunately there is no hint given on how to use these two measures together. I’ve found that many simply ignored “Time to OOM” and look only at HPS, resulting in certain stats (mainly Haste) being overvalued. My Spreadsheet instead combines the two together into one measure called “Sustainable HPS”, which is the maximum HPS you can sustain without running out of mana until the end of the fight (of a configurable duration).
  2. The rotation assumed by TreeCalcs is rather arbitrary, and tries to be a mix of everything. I prefer a different approach, modeling two common healing playstyles (tank and raid healing) and mana situations (infinite mana, infinite duration, fixed duration), and being able to show how stat values change in reaction to different situations.

Usage Instructions:

  1. Visit the Restoration Druid Spreadsheet at http://goo.gl/dsVCU
  2. The values in the yellow box section show the Relative Stat Value normalized against Intellect (aka Intellect Equivalent Points) for my current healing gear.
  3. Download the spreadsheet, or go to File -> Make a Copy, to make a copy of the spreadsheet into your own Google Docs account.
  4. Make sure you have no buffs activated.
  5. Enter your stats into the spreadsheet.

Limitations of the Spreadsheet

  1. Does not take into account procs and cooldowns

Description of Model

  • OOM – Models an infinite length fight, assuming you start at 0 mana and using only mana that is regenerated
  • Duration – Models a finite length fight based on the duration set in the green section
  • Burst – Assumes unlimited mana
  • Raid Healing – Keep Lifebloom and Rejuvenation on Main Tank, refreshing Lifebloom using Nourish. Healing Touch used on Clearcasting. Swiftmend on cooldown. Wild Growth on cooldown. Spend excess mana on Rejuvenation.
  • Main Tank Healing – Keep Lifebloom and Rejuvenation on Main Tank. Healing Touch used on Clearcasting. Swiftmend on cooldown. Spam Nourish. Spend excess mana upgrading Nourishes to Healing Touch.

13 Comments

  • Continuous says:

    Thanks so much for posting this, it has been extremely helpful for me in both choosing a spec and in my management of mana. All your hard work has made for an awesome replacement of treecalcs. :)

  • Kalette says:

    So I was looking through the spreadsheet and it looked like you still have mastery set as 11.6% and 1.25%. I could be wrong, but those should be 18% and 1.45%

    • Tangedyn says:

      It’s actually 11.6% and 1.45%. The 11.6% is part of the first 8 points of Mastery, so you it is totally ignored when you multiply total mastery with 1.45%. I’m actually using 1.45% – if you look at the formula I’m using the old 1.25% and multiplying 1.16 to it because of the 16% buff in 4.0.6 to get 1.45. The 1.16 has nothing to do with the 11.6% except they look similar, so that probably confused you.

  • Serath says:

    Would it be possible to add a checkbox for DI?

  • Aani says:

    I’m never a huge fan of crit, but Ember meta has always been very lack-luster. Plus, getting rid of the yellow gem requirement is a nice side benefit, since it seems most of DS gear for some healers is missing some yellow sockets.

  • Katarnas says:

    Just a quick question regarding the values you gain from the spreadsheet: is it possible to then use those values to work out stats equivalent to intellect? e.g. intellect is 1 IEP, mastery is 0.6 IEP, so 155 mastery is equivalent to 93 intellect (155 x 0.6 = 93), or have I understood this wrongly?

    Sorry for noob question, first time using spreadsheets etc :)

    Kat

    • Tangedyn says:

      Yes, that’s the way it’s supposed to be used. Although I prefer to call it ‘approximately equivalent’, because EP values can and will change when the balance of stats change, but it’s usually very small unless you hit some special breakpoint or cap. In most cases it should be a very good approximation.

  • Zakaluka says:

    I understand the reason for showing scalefactors normalized against int. However, I was wondering if this could be modified to show ABSOLUTE scalefactors. In the current presentation I can see that each point of MST is worth slightly less than each point of INT, but I can’t tell how much HPS I gain from a point of INT without just editing the stats sheet.

    Pretty minor point.

    Thanks for this spreadsheet, it helped me get on my feet and rolling with my resto druid very quickly.

  • Josiah says:

    I see that on clearcasting procs your using HT over regrowth. I may be a complete failure of a healer but is it really better thru throw out a HT over Regrowth seems like when I’m healing that Free Regrowth usually tops of a dps or gets then about 90% letting the short hot do the rest.

    • Tangedyn says:

      The spreadsheet assumes a rotation that tries to maximize sustainable dps, and since Healing Touch heals more per cast than Regrowth, using Healing Touch on OOC procs is theoretically more effective assuming we are not capped for cast time. In practice, of course, I do see the point of Regrowth being better situationally especially for its low cast time, and may add an option to use Regrowth instead of HT on OOC procs.

  • Lolofora says:

    Do you make a version for 5.0 or MOP?

Leave a Reply

Your email address will not be published. Required fields are marked *