Skyhoof

The mp5 values for a mana spring totem are not correct. The spreadsheet shows the totem restoring 20 mp5 or 25 mp5 through improved talents. However, this is actually the amount of mana restored every 2 seconds. The mp5 values are 50 mp5 for a regular mana spring totem and 62.5 mp5 for the improved totem.

Also, any chance you could add the shaman and paladin classes to the spreadsheet? I realize that the change does not affect our mana regen while casting but I would like to see how much more mana I will receive outside of the FSR. At the moment, I'm selecting priest and choosing 0/3 Meditation talent. Will my results be accurate as a shaman. Thanks.

 

Havenwood

Mana Spring Totem values fixed. Thanks for pointing that out!

Download here.

You will get more accurate Shaman results by selecting Druid with 0/3 Intensity and No Living Spirit. Shaman and Pally are closer to Druid caster form than to Mage or Priest. Druid feral form is actually identical to Shaman and Pally, but not included in the sheet. I'll try to get around to adding Shaman, Pally, Hunter, and Warlock tomorrow! In the meanwhile, selecting Druid should get you very close.

 

atilla

Looks like Dreanic Wisdom + Mastery elixirs will be better than both distiled wisdom and regen flasks in much cases

 

Havenwood

MP5 Spreadsheet now supports Priest, Druid, Mage, Hunter, Paladin, Shaman, and Warlock.

Download Here.

I added a bit more OO5 MP5 info for the additional classes. I put in Demonic Embrace for Warlocks, but I'm really not sure what other Talents are implicated for the other new classes. Let me know if you think of any!

 

Mithos

Fixes:

- I Corrected spirit/intellect/multiplier back as it was intended to be. (class/race specials only to buffed)

- Fixed all level bugs

- Mana Spring Totem values fixed

Added this function:

- Now you can insert the MP5 Charvalue (x mana regenerated while casting)
- Also you MUST select, which Version of WoW you were running when getting this value

Result:
- The correct Non Spirit MP5 Value is calculated and added to the Spirit-based mp5
- You don't have to calculate the so called "NonSpirit MP5" value like before, just insert the Charscreen Value

Click to download new Version

And now find some more mistakes!

 

Mithos

Oh post was not there when posting my new version.
Would be nice if you can add your additions to my spreadsheet and reupload it.
I have to go to sleep. See you tomorrow.

 

Havenwood

Your revision looks great! I'll work on merging them tomorrow.

 

atilla

Your spreadsheet increases MP5 with 20(25) if mana spring is "yes".
20(25) mana per 2 seconds = 50(62.5) per 5 seconds.
Edit - gnome and human racials and spirit of redemption must multiply only the spirit/intellect gained by the buffs.
Unbuffed value shown in-game is with already applied this bonuses.
Edit - Sorry if i posted somebody already posted, didn't refreshed the page from yesterday when clicked reply

 

Batguus

Yay more graphs! This time it is Draenic Wisdom vs Major Mageblood. This is again with 30% casting regen, and ONLY shows when Draenic gives more regen than Mageblood, it does not take into account the absolute mana gain from the int from Draenic.
Basically, unless your spirit is very low, Draenic wisdom is the way to go now, for most T6-geared healers the regen alone will be higher than Mageblood, and in combination with the larger manapool Draenic wisdom is now a no-brainer. Terocone will get even more expensive sigh.

 

Liths

Not exactly any groundbreaking news, but the stat increasing talents/spells/racials are multiplied with eachother, not added. So, a human priest with BoK and SoR will have her spirit modified by +27.05%, not +25%.

 

TheDeamon

Interesting catch. I guess I and a few others never noticed it before because of the relatively small amounts of spirit being involved, so the errors never added up enough to be noticeable. Particularly when you consider that the paperdoll rounds things which helps skew it a bit further.

I'm a Human priest with Spirit of redemption, so I have +10% to spi from the human racial, and another +5% through talents.

174 baseline spirit as reported by my paperdoll in WoW when striped of any gear with spirit on it. (no kings)
547 spirit on my paperdoll when in my normal gear loadout. (602 spirit with kings)
That normal gear loadout has 323 spirit on it.

323 spirit + 15% = 371.45 spi
371.45 + 174 = 545.45 spi (off by about 1.55 spirit, some of this can be attributed to rounding on the part of the paper doll, but not all of it.)

Trying it with kings (602 being the reported total by paper doll):
323 spirit + 25% = 403.75
174 spirit + 10% = 191.4 (didn't grab the paperdoll numbers for my naked spirit while I had a kings buff)
403.75 + 191.4 = 595.15 spirit, now the difference between the theory number and the paperdoll number by about 6.85 spirit, which is well outside the realm of 4 rounding errors(+0.5 on one end, -0.5 on the other respectively).

Now doing it in the multiplicative manner, one step at a time:
323 spirit + 5% = 339.15
339.15 + 10% = 373.07
373.07 + 10% = 410.37
410.37 + 191.4 = 601.77 spirit .... which would round to 602 on the paperdoll.

 

Kinien

Error found.. Additional buff area, you have the Int being affected by being human. Remove that line and it looks much better.

 

Skyhoof

Thanks for much for adding the other classes. The buff you would want to add for shaman is Water Shield, which is 50 mp5. It could go in the line where you have Warlock's Demonic Embrace and other class talents. Water Shield is not a shaman talent but we have no talents for mana regeneration so it might as well go there.

I wonder if it would be possible in a future version to add Mana Tide. Each point of Intellect would restore an additional 3.6 mana with Mana Tide (15 mana * 24%). That would equal 0.06 mp5 (3.6 mana/60).

 

Daidalos

Well actually we do have a regen talent it just isn't in the resto tree. Unrelenting storm restores up to 10% (5 points) of your int every 5 secs even while casting. I can't imagine any resto build having this but an ele shaman might be curious about spi and regen OO5SR

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

 

Skyhoof

Yes, I forgot about that talent being a resto shaman. Also, can you add Elixir of Major Mageblood (+16 mp5) to the buffs available?

 

Moginheden

I just looked at the spreadsheet and it's missing the moonkin talent Dreamstate. Any chance this can be added?

 

Moginheden

Also it's been mentioned that druids in caster form are on a different regen formula than druids in feral forms, what do tree and moonkin count as?

 

Mithos

Here: Spirit - WoWWiki - Your guide to the World of Warcraft you see the numbers.

I'm currently on adding Shaman Talent "Unrelenting Storm", the different Reg for Druidforms, and merging it all with the last changes of Havenwood.

It will take some time

 

Mithos

Now after a big session of brooding about the sheet and reworking, it's done.

- Redesigned the Class Selection with associated buffs.


- Added Shaman Skill "Unrelenting Storm"
- Fixed a Bug with Brilliant Mana Oil
- Insertet all other Classes by refering to Havenwood's Implemention
- Elixir of Major Mageblood added
- Inserted Havenwood's Function showing OO5 MP5 from +1 Spirit/Intellect


Download


And now again, try, find some errors or new ideas

 

Skyhoof

Thanks to both of you for updating your spreadsheets so quickly.

Can you check your formulas for Unrelenting Storm. It's currently ($E$6-$D$6)*0.1. Should it be $E$6*0.1? If I enter 500 Intellect (609 Intellect with raid buffs), the talent adds only 10 mp5. Should it be adding 60.9 mp5? Or does the talent not work with other buffs such as Arcane Intellect and Mark of the Wild? Even then, wouldn't it add 50 mp5 while casting?

The only new idea I have is to add Water Shield for shamans which provides 50 mp5 -- both casting and outside the FSR. Or if you are feeling really ambitious you could add Mana Tide, which would restore 24% of your Mana pool. It has a 5 min cooldown. So if you had 10,000 mana, mana tide would equal 40 mp5. However, I believe you would have to add all the races, since each has a slightly different amount of base Intellect. And it would change the calculations about how much MP5 and OO5 MP5 you get from Intellect.

 

Kinien

You still have error at the bottom with the buffed INT - you are using spirit of redemption to boost int 15% in the item upgrade spot. You also have the same issue in your Buffed INT section at the top next to character sheet INT.

 

Kevlar

I fixed everything you guys asked for in HealCrafter. I can't believe I originally forgot to add spirit enchants to my code. Oops.. You may have to hit "Refresh" on your browser to see the V1.1.0.3 on the download page.

This weekend I'm going to try to add support for buffs/totems/consumables, etc. I'm just not sure how I should deal with it from a UI standpoint.
________________________________________________________
Version 1.1.0.3
--------------------------------------------------------
Added Spirit to the enchant parser and enchant XML header. Oops..
Added Gem: Sparkling Empyrean Sapphire
Added Enchant: Spellsurge (it wont error if it sees it, but it doesn't add anything to stats)
Added Enchant: Enchant Chest - Greater Spirit

 

TheDeamon

Missing these gems as well:

<gem id="30589">
<Name>Dazzling Chrysoprase</Name>
<Color1>yellow</Color1>
<Color2>blue</Color2>
<Intellect>5</Intellect>
<MP5>2</MP5>
</gem>
<gem id="30593">
<Name>Iridescent Fire Opal</Name>
<Color1>red</Color1>
<Color2>yellow</Color2>
<Heal>11</Heal>
<--<SpellCrit>4</SpellCrit> no format for spell crit rating -->
</gem>

 

• Cluey

While it is great you are putting all this time into making a spreadsheet you need to read the thread you are replying to.
A couple of times it has been pointed out that the old spirit formula's, as listed in your link to wowwiki, are not being used anymore.

From post number 55:

 

TheDeamon

He was trying to answer a question regarding what the current regen model is for tree/moonkin druids are for the purpose of including their current regen model into a spreadsheet so they too can compare their 2.3 regen against 2.4 regen.