relientKitten

This is something that I have been working on for a while now as I get bored at work. It stayed in a fairly simple state of only calculating the effects of healing gear and talents. Then I saw the amazing Paladin spreadsheet and determined that I could do that, too.

http://www.cat.pdx.edu/~murasaki/druid_spell_sheet.xls


I am currently working on implementing combat rules and will eventually give room for buffs and trinkets and such, but at the moment, you can simply add the buff information to your base stats.

Numbers so far have been fairly accurate. I am noticing some minor differences on spells such as Regrowth, which I believe to be due to rounding issues.

The "Time 'til OOM" information is something I've been tweaking for a while and I think I've found a sweet spot. You'll need to make sure that iterations are turned on, if it doesn't default when you open the spreadsheet. 100 and 0.001 seem to work nicely.

I am in the process of adding Balance spells to the sheet as well. Need to verify numbers and calculations, so I'm waiting for the servers to come up.

 

Reachie

Awesome!

I've been looking for something like this..

I'm at work right now, but will try to DL it and check it out while the boss isn't looking! :P

 

Apate

Thank you very much for this.

See you, auntie.

 

Daelrine

Great job! I found it very useful in calculating mana efficiency and adjusting ranks for my current stats.

I think though that one of the formulas need a fix. In the sheet Lifebloom cost is based on "Mana base" instead of "Mod Mana". That would mean that Tree of Life aura does not affect this spell, while ToL tooltip says "(...) and you can only cast Swiftmend, Innervate, Barkskin, and healing over time spells, but the mana cost of these spells is reduced by 20%. "

 

Elo

Very Nice Job!

I had a small correction to make (well what I believe to be a correction) on the lifebloom tab.

The Heal/Mana and Heal/Sec calculations are using Direct Crit Heal (H3) in their calculations instead of Average Heal (I3).

I believe the formulas should be

Heal/Mana =(E3+I3)/A3
Heal/Sec =(E3+I3)/7

Let me know though if I am misunderstanding something.