Sunder

@Kevlar

One of the gems in my helm isn't liked by your program. I'm not good with programs, so maybe you can figure it out if I give you my armory.

The World of Warcraft Armory

Hope that helps.

 

Kevlar

Thanks for your input everyone. HealCrafter is now updated with all your input.

You may have to hit refresh on your browser to see the new version on the download page.

The new EU support is pretty awesome because if you save your character and then later, one of the armorys is down, you can choose to use the other armory when searching for gear. Clear as mud?

Since people don't seem to have much to say about HealCrafters patch 2.4 capabilities, I probably won't post much more on this thread. I'll still check this thread, but if you have other problems, feel free to email me. There is a link from the websites "Contact" page.

_____________________________________________________________________________________ ___________
Version 1.1.0.2
--------------------------------------------------------
Added EU Realm Support
Added Gem: Lustrous Empyrean Sapphire
Added Gems: Luminous Fire Opal and Imperial Tanzanite
Added Enchant: Boar's Speed

 

Batguus

I thought this was quite an interesting statement allthough I had my doubts. Ofcourse this heavily depends on the fight length and you spirit and intellect. So I threw it all in a matlab plot, here ya go:



Note1: This assumes 30% casting regen.
Note2: I assumed BoK affects the wisdom flask, it does right?

 

Pôpô

Hi Kevlar,
I tried your little log, and i think it's awsome, and really a great gain of time.
But i had to add some enchant and gems :

Gems :

<gem id="32201">
<Name>Sparkling Empyrean Sapphire</Name>
<Color1>blue</Color1>
<Color2>none</Color2>
<Spirit>10</Spirit>
</gem>

Enchant :

Chest :
<enchant id="1144">
<Name>Greater Spirit</Name>
<ItemType>20</ItemType>
<Spirit>15</Spirit>
</enchant>
Weapon :
<enchant id="2674">
<Name>Spellsurge</Name>
<ItemType>14</ItemType>
</enchant>

For the spirit enchant, i tried to add this line :
<!ELEMENT Spirit ANY>

But i think you have to add something in the .exe to considere the spirit add on enchants !
If it can help you for next versions =)

After this, a little error is still there : i've -12 stamina between the Armory and the real character (and -15Spirit, because of the Spirit enchant !)

EDIT : A last error : A littre round error for the add heal (i've 1908, but the program display 1907 !)

(Sorry for my bad English, but i'm French, so it's a little bit hard for me !)

 

Sarjin

It's a straight stat buff (and not an increase in mana pool); to my knowledge, all those buffs get affected by Blessing of King's 10% bonus modifier, so that should also be applicable here.

 

Pôpô

The BoK is the last applicated buff into the calcul. Add all the buff and then multiply with the BoK coef !

 

Kadaan

I don't understand this graph. 65int with static values for time spent inside/outside the 5SR is a static mp5 value at each spi/int point. Why should fight length matter?

 

Jayde

Unless I'm mistaken, 65 Int would technically provide (65 * 15 / Seconds * 5) Mp5 over the duration of the fight in terms of its manapool contribution, in addition to the Mp5 granted from Spirit multiplication. This is often a point about Int that was typically ignored, mostly due to it not being a massive factor on a per-point basis alone.

However, it seems as if it would make Distilled Wisdom considerably better with my stats, especially considering that with ~30% OO5SR 65 Int seems as if it would provide just over 21 Mp5 for me. One could also argue that the higher manapool better optimizes spirit-based regen phases which could end up over-regenning with the silly amounts of OO5SR floating around now. Over a 6 minute fight, it would seem to be around 39 Mp5.

 

Batguus

It factors in the absolute mana gain from the 65 int (65*1.1*15=1072.5 mana) which is ofcourse part of the reason why you would choose the Wisdom flask over the Resto flask. Of course the relative effect of this buff is lower on longer fights.

In other words, when choosing between two flasks you want to know how much mana it adds to your effective mana pool for a particular fight. For the Resto flask this is regen*fight length, for the Wisdom flask this is extra spirit regen*fight length + absolute mana from int.

 

Jayde

Unless my napkin math is leading me dramatically of course, I think one would have to have a fight with somewhere over 20 minutes duration to have Distilled Wisdom not be better given the base contribution of regen from the Spirit * Int multiplier vs a static 25 Mp5.

On the other hand, most 20 minute fights have much higher than 30% OO5SR periods, meaning that the OO5SR regen granted by the Int would most probably scale better than the Mp5 anyhow.

So, all in all, I think Distilled Wisdom would end up being better in almost every case, especially as I think one could possibly pass or match 25 Mp5 with 30% OO5SR from Distilled Wisdom when considering BoK and high levels of Spirit.

(That said, all of this is a bit moot as Draenic Wisdom + Elixir of Mastery for 45 Int/45 Spirit would probably be better anyhow. That combo is pretty much insane for Priests after the patch.)

 

Shadewalk

The distilled wisdom vs mighty restoration arguement also raises interesting points maybe for Elixier of mastery + Draenic wisdom. Here you could have a total of 45 int/spirit (+15 to the rest), which I expect beats 65 int on any build.

Using 450 spirit and 500 int, no buffs or anything else interesting, regen gained from the 45 spirit/int combo was 69 oo5sr, and 21 during. This is ignoring the 45*15 mana pool and other benefits from BoK and talents on spirit/int.

 

Alvira

Thanks! I love your spreadsheet, Havenwood.

Yeah, the buff to mage mana regen especially for arcane mages is amazing. Is it possible for you to add the effects of using flask of distilled wisdom (+65 int) ? Thanks.

Based on your spreadsheet, raid buffed, I gained 185 MP5 and 308 oo5MP5!!! wow!

 

Batguus

If you take for example a player with 500 int and 400 spi, the Mp5 you get with 30% OO5SR is:
(0.001+400*0.009327*500^0.5)*5*0.3=125,1 mp5

With 65 extra int:
(0.001+400*0.009327*(500+65*1.1)^0.5)*5*0.3=133,8 mp5

So you gain 8,7 mp5, plus the 65*1,1*15=1072.5 mana.

So when is 25-8,7 mp5 more than 1072,5 mana:
1072,5/(16,3*12)=5,5 minutes.

But indeed, Draenic wisdom is now an easy win over all other elixirs, Im pretty sure Ill be going Draenic wisdom + healing power after the patch.
WTS 140 mageblood elixirs .

 

Pyros

Does the Distilled vs Restoration comparison assume any amount of casting out the FSR or chaincast? You say 3°% casting regen, that's the talent right, not 30% time out of FSR?

 

• Playered

Its the talent (Meditation/Itensity), regardless there still isn't a FoDW from marks so they wont get that much use, especially considering the vastly superior yield of elixirs instead (or the moderately small gain from FoMR to be fair).

 

PiousFlea

Draenic wisdom + healing power certainly seems like the way to go. Draenic + Mastery is viable as well.

For a character with high INT and SPI and reasonable FSR time, the Draenic Elixir by itself will provide more MP5 than the Flask of Mighty Resto. So much for the superiority of flasks over elixirs.

Although with the massive overall buff to mana regen, it is entirely likely that fights that previously required mana consumables will no longer require them.

 

Havenwood

Updated MP5 Spreadsheet to include Flask of Distilled Wisdom and Elixir of Mastery.

Download Here.

Interestingly, it looks like in many cases that Elixir of Draenic Wisdom plus an Elixir of Mastery will be more overall MP5 than a Flask of Restoration in the PTR.

 

Jayde

I was doing the numbers with a bit higher Int/Spirit than you, as my stats more approach 600-650 Spirit in raids, and probably about 550-600 Int. That gives me a base regen of ~742, whereas with 65 more Int I would end up with ~786 regen, a gain of around 44 regen. With 30% regen while casting and ~30% OO5SR time, this equates to (44 * .3) + (44 * .3 * .7) ~= 22.4 Mp5, and a bit more if you use the PMC bonus.

As Int adds to base regen, not Mp5, one has to calculate a roughly resonable OO5SR% to factor. The interesting thing about Int is that on short fights where you are less likely to get high OO5SR numbers, the base mana pool contribution will be much higher--whereas on longer fights were the base mana contribution is not as important, one tends to have a much higher OO5SR% overall. (Think Kael'thas vs. Gorefiend, for instance.)

 

Mithos

There were still many mistakes in that spreadsheet. I fixed all i found and added a new function.


List of Mistakes:

• Racial Buffs:
  - Human Buff (10% more spirit) was not multiplyed with the total Spirit Value (only with the
  Buffbonus)
  - Gnome Buff (5% more int) was not multiplyed with the total Intellect Value (only with the Buffbonus)
  
  ---> Corrected so that the Buffs affect the complete amount of Int / Spirit
  
  
• Class Buffs:
  - All: Again only multiplyed with the Buffbonus instead of the Total Int/Spiritvalue
  -Druid-LivingSpirit and Mage-ArcaneMind are one "On/Off Switch" but correspond to different stats (Int/Spirit)
  (if you switched Mage-ArcaneMind "on" the bonus was added to Spirit)
  
  --> Created a new "Class Buff Switch"

New Function: Additional Buffs

• Insert a specific value of Additional Int and Spirit
  and see what amount of Manareg you will gain.
  
  
  Figure 1:Example of Elixir of Draenic Wisdom: How much Manareg do i get?
  
  Its not the same as setting the Character-Values of Int/Spirit to 30 / 30,
  because the higher your Base-Spirit(Int) Value is, the better you profit from it.

Downloadlink:
Click me!

 

Kinien

The racials etc were setup correctly. People will be gathering their spirit and int totals from their character sheet...where the bonuses have already been applied. If you apply the bonus to the complete total, it totally messes up your numbers, because you effectively give the bonus on your base 2 times. Havenwood had it wrong initially, I corrected him, now you broke it again. But obviously he messed up the Mage - Arcane Mind.

 

• Richelieu

@ Kevlar:

I played around with Healcrafter for a few minutes today before work, it is a great concept and a very promising application.

In some future version you may consider adding a feature similar to the "Additional Buffs" feature that Mithos just added to the MP5 spreadsheet (see a couple posts above). And also perhaps a series of checkboxes or a dropdown menu for the various buffs/consumables so you can rapidly try out different combos. These would facilitate the ability to choose a gear setup by (1) estimating from experience how much effective *raid-buffed* MP5 you'll need for the scenario you're considering, then (2) using Healcrafter to assemble a gear/consumable combination that gives you that target MP5 while maximizing +heal and maintaining adequate Stam.

Or maybe such a feature is there but I just can't find it?

Anyway, nice job! I'm gonna play with it some more after work.

 

Havenwood

It is funny how people call out my glaring error when I have it either way. I guess I should be more explicit about my assumptions up front!

Bendyr had it multiplying buffs only, I changed it to total amount, Kinien changed it to buffs only, Mithos changed it to total amounts. Basically one way isn't right and the other wrong, but I think multiplier effecting buffs only is preferable. It depends on the assumptions made as to where the total spirit and intellect numbers come from. If the number is inserted from the character info tab, then Bendyr and Kinien made the correct assumption. If the number is added up from spirit and intellect on gear, then the other way is right. Since most people will presumably be pulling the number from their character info tab, I think we should leave the spirit and intellect multiplier effecting buffs only.

So all of the errors you found are actually functioning properly, except one glaring error--Arcane Mind. As to the Mage Arcane Mind buff effecting spirit not intellect, OOOPS! Shows how much I know about mages! Good catch. I'd like to see how you incorporated that change, but your download link isn't working for me.

 

Havenwood

The download is working for me now. I like how you added a choice for character level. However, it doesn't seem that everything is properly plugged in yet, since the level choice doesn't effect all applicable fields.

Your additional buff section is interesting. I think it might be worth adding a more comprehensive buff analysis section.

I like the way you compacted the Priest, Druid, Mage talents into a single field--that was beyond my Excel ability. =P

I really think we should go back to assuming Spirit and Intellect have been entered directly from the Character Information Tab. (Reverting your "error" fixes.) Additionally, I think we should query for "Mana Regen" or something else directly accessible from the Character Information Tab, instead of "Non-Spirit MP5," which requires that the User do math. The only thing that has stopped me from switching it to a more directly accessible stat is that it is nice to be able to set "Non-Spirit MP5" to zero, so that you can see only Spirit and Intellect totals. There has got to be a more elegant way to do this!

 

glowacks

It's been true for quite a while that for many classes and specs that a cocktail of elixirs has been very, very close to, if not better than, comparable flasks. However, their purpose is to be used when you expect to die quite often. Using two elixirs each and every attempt at a new boss is now certainly a reasonable thing to do if you're rich, but part of the whole alchemy redesign was to reduce costs. I don't expect to see much of a change in flask usage by spirit based healers given that in general mana regen for them has been vastly increased and they likely have no chance to run out of mana unless they chain cast Prayer of Healing for 5 minutes.

Now, I admit that Draenic Wisdom elixirs were by far the easiest to make among elixirs for me (Super Mana pots I farmed out to pot spec'd folks) such that they were basically the only item I sold off (instead of donating to the guild) even though I used them myself quite a bit. And while Healing Power was the only thing I had to make with Golden Sansam, I only got any when I was trolling Zangarmarsh for Flame Caps. (And really, I hated doing it because of the existence of Blindweed and Glowcaps on herb radar; I suppose there might be a mod out there that hid them, but I was never a huge fan of mods)(And the existence of Blindweed in Zangarmarsh, along with Ghost Mushrooms in caves therein, suggested to me that they didn't plan to nerf Limited Invulnerability pots, which made those two herbs pointless to be in Outland)(insert tertiary digression here).

 

Havenwood

Well, since I haven't switched to Mithos' sheet yet, due to the spirit/intellect/multiplier debate, and character level bugs--here is an updated version of my simpler sheet with the Arcane Mind bug fixed!

Download.