Intellect -> Spirit Conversion on the PTR : Theorycrafting HQ - Page 9

Saraya · 02/16/08, 6:02 AM

The mana regen on my char sheet remains the same between caster and both moonkin/tree forms, so I imagine they should be the same.

Mithos · 02/16/08, 8:44 AM

Originally Posted by Skyhoof

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?

My formula is right, because only the MP5 Bonus of the Buffs has to be added.
44 int(IntBuff+Kings) -> 44*0.1= 4.4 Extra MP5

The MP5 Bonus from your Base Stats (500 Int -> 50MP5) is included in the Value of the Field "MP5 (Charscreen)". Because when you copy your ingame Value it is added already. If you are a Shaman who didn't skilled it but want to
test how it would be if you would, you have to add this 10% Base Value manually to the field "MP5 (Charscreen)".

Originally Posted by Skyhoof

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.

Perhaps Heavenwood has enough time this weekend to think about it, otherwise it would take some time. Perhaps this function does not have to be that exactly, because at a manapool of 10000 Mana the difference between the Races does not care so much.

Originally Posted by TheDeamon

Originally Posted by 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.

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.

Right.

Originally Posted by 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.

Fixed.

Download fixed Version

Skyhoof · 02/17/08, 2:07 AM

Originally Posted by Mithos

My formula is right, because only the MP5 Bonus of the Buffs has to be added.
44 int(IntBuff+Kings) -> 44*0.1= 4.4 Extra MP5

The MP5 Bonus from your Base Stats (500 Int -> 50MP5) is included in the Value of the Field "MP5 (Charscreen)". Because when you copy your ingame Value it is added already. If you are a Shaman who didn't skilled it but want to
test how it would be if you would, you have to add this 10% Base Value manually to the field "MP5 (Charscreen)".

/slaps forehead

I forgot that as a resto shaman the mp5 from that talent would not show up in my character screen. Your formula is indeed corect. Any plans to add some text with instructions/explanations. If so, it would be good to note that shamans without the talent will need to manually add that to their mp5 Charscreen field.

Flinkindolin · 02/18/08, 3:29 PM

Originally Posted by Mithos

Download fixed Version

Can someone else who has already dl'ed this please share it? speedshare.org is telling me the file has reached it's dl limit. (I think. Babelfish didn't translate the German into comprehensible English.)

Kinien · 02/18/08, 4:48 PM

Originally Posted by Mithos

My formula is right, because only the MP5 Bonus of the Buffs has to be added.
44 int(IntBuff+Kings) -> 44*0.1= 4.4 Extra MP5

The MP5 Bonus from your Base Stats (500 Int -> 50MP5) is included in the Value of the Field "MP5 (Charscreen)". Because when you copy your ingame Value it is added already. If you are a Shaman who didn't skilled it but want to
test how it would be if you would, you have to add this 10% Base Value manually to the field "MP5 (Charscreen)".

Perhaps Heavenwood has enough time this weekend to think about it, otherwise it would take some time. Perhaps this function does not have to be that exactly, because at a manapool of 10000 Mana the difference between the Races does not care so much.

Right.

Fixed.

Download fixed Version

Mithos...I hate this filehost, but my comcast isnt accepting my upload at this time.

MP5-modified.xls

I added a sheet to the file with priest gear and their stats to play with. Some of the formula's might need tweaking, but for the most part it looks like a pretty good rough outline to work with. The priest mp5 calculations are based off the stats you first enter under the character sheet.

Bianca · 02/19/08, 5:35 AM

Originally Posted by Kinien

MP5.xls

I added a sheet to the file with priest gear and their stats to play with. Some of the formula's might need tweaking, but for the most part it looks like a pretty good rough outline to work with. The priest mp5 calculations are based off the stats you first enter under the character sheet.

brilliant work Kinien

but could you add priest variables like "percent casting" and "% from Spiritual Guidance". Yes, i'm using your previous gear.xls

Kinien · 02/19/08, 10:31 AM

Originally Posted by Bianca

brilliant work Kinien

but could you add priest variables like "percent casting" and "% from Spiritual Guidance". Yes, i'm using your previous gear.xls

It bases the percents from the first sheet where you input your stats, I never thought to enter spiritual guidance into the equation. Isn't that a druid talent? Haha, never knew anyone downloaded my gear.xls...Knew a few guildmates did, but that was about it. I am happy the merge into the 2.4 theorycrafting sheet is going well. I can add another 2 collumns into it for percent casting however and look at spiritual guidance.

I will make some changes to the formulas and repost it.

Kinien · 02/19/08, 11:35 AM

MP5-modified.xls

Here are the changes you requested Bianca. Added some modifiers to the item section.

TheDeamon · 02/19/08, 12:09 PM

Originally Posted by Kinien

MP5-modified.xls

Here are the changes you requested Bianca. Added some modifiers to the item section.

Uhhhh, their download script on that page seems to be defective for me.

I had to view the page source code and pull the download link from there and copy/paste it in order to grab your file.

Problem exists in IE7 and Firefox 2.0.0.12

Kinien · 02/19/08, 12:16 PM

Originally Posted by TheDeamon

Uhhhh, their download script on that page seems to be defective for me.

I had to view the page source code and pull the download link from there and copy/paste it in order to grab your file.

Problem exists in IE7 and Firefox 2.0.0.12

I copied the source code and put it into the link...but I still see some errors with the "percent casting" formula.

I reuploaded it with the corrections to the percent casting formula....best redownload it again.
MP5-modified.xls

TheDeamon · 02/19/08, 12:49 PM

You're missing enlightenment (Discipline) which gives a 1/2/3/4/5 % increase to your total stamina/intellect/spirit.

Kinien · 02/19/08, 12:58 PM

Originally Posted by TheDeamon

You're missing enlightenment (Discipline) which gives a 1/2/3/4/5 % increase to your total stamina/intellect/spirit.

Oki, I can add it, gimme a few, having lunch.

Kinien · 02/19/08, 1:26 PM

Originally Posted by TheDeamon

You're missing enlightenment (Discipline) which gives a 1/2/3/4/5 % increase to your total stamina/intellect/spirit.

MP5-modified.xls

All set.

Skyhoof · 02/19/08, 1:36 PM

Any chance of adding Water Shield option for shamans? It restores 50 mp5, both while casting and outside the FSR. Thanks.

Kinien · 02/19/08, 1:44 PM

Originally Posted by Skyhoof

Any chance of adding Water Shield option for shamans? It restores 50 mp5, both while casting and outside the FSR. Thanks.

Sure.

Lambi · 02/19/08, 1:55 PM

So for the math retards 2int is worth 1spi?

Kinien · 02/19/08, 2:01 PM

Originally Posted by Skyhoof

Any chance of adding Water Shield option for shamans? It restores 50 mp5, both while casting and outside the FSR. Thanks.

MP5-modified.xls

Added watershield under Shaman options.

Kinien · 02/19/08, 2:02 PM

Originally Posted by Lambi

So for the math retards 2int is worth 1spi?

It really depends on the ratio of your stats on your gear, but in most cases...yes.

Skyhoof · 02/19/08, 2:43 PM

Originally Posted by Kinien

MP5-modified.xls

Added watershield under Shaman options.

Wow! That was fast. Thank you very much.

drunknpriest · 02/19/08, 3:14 PM

Healcrafter is not recognizing Teardrop Crimson Spinels

Can the author of Healcrafter plz fix?

Thx
DP

Kinien · 02/20/08, 2:32 PM

Originally Posted by Bianca

brilliant work Kinien

but could you add priest variables like "percent casting" and "% from Spiritual Guidance". Yes, i'm using your previous gear.xls

MP5-modified.xls

Updated again, thanks for the input.

Bianca · 02/21/08, 3:32 AM

Originally Posted by Kinien

MP5-modified.xls

Updated again, thanks for the input.

thank you once again

Holyphenom · 02/21/08, 11:13 AM

I may have missed it, but after reading so much my eyes hurt. I was told the equation for spirit regen is much different than what it was. Do we know the exact spi + int = mp/5 equation? No buffs, racials, or talents. Just the equation. Thanks in advance for the help.

Kinien · 02/21/08, 11:20 AM

Originally Posted by Holyphenom

I may have missed it, but after reading so much my eyes hurt. I was told the equation for spirit regen is much different than what it was. Do we know the exact spi + int = mp/5 equation? No buffs, racials, or talents. Just the equation. Thanks in advance for the help.

Whitetooth from Ratingbuster cracked it.

ManaRegen(SPI, INT, LEVEL) = (0.001+SPI*BASE_REGEN[LEVEL]*(INT^0.5))*5

BASE_REGEN[LEVEL] = { -- parsed from game files
[1] = 0.034965
[2] = 0.034191
[3] = 0.033465
[4] = 0.032526
[5] = 0.031661
[6] = 0.031076
[7] = 0.030523
[8] = 0.029994
[9] = 0.029307
[10] = 0.028661
[11] = 0.027584
[12] = 0.026215
[13] = 0.025381
[14] = 0.0243
[15] = 0.023345
[16] = 0.022748
[17] = 0.021958
[18] = 0.021386
[19] = 0.02079
[20] = 0.020121
[21] = 0.019733
[22] = 0.019155
[23] = 0.018819
[24] = 0.018316
[25] = 0.017936
[26] = 0.017576
[27] = 0.017201
[28] = 0.016919
[29] = 0.016581
[30] = 0.016233
[31] = 0.015994
[32] = 0.015707
[33] = 0.015464
[34] = 0.015204
[35] = 0.014956
[36] = 0.014744
[37] = 0.014495
[38] = 0.014302
[39] = 0.014094
[40] = 0.013895
[41] = 0.013724
[42] = 0.013522
[43] = 0.013363
[44] = 0.013175
[45] = 0.012996
[46] = 0.012853
[47] = 0.012687
[48] = 0.012539
[49] = 0.012384
[50] = 0.012233
[51] = 0.012113
[52] = 0.011973
[53] = 0.011859
[54] = 0.011714
[55] = 0.011575
[56] = 0.011473
[57] = 0.011342
[58] = 0.011245
[59] = 0.01111
[60] = 0.010999
[61] = 0.0107
[62] = 0.010522
[63] = 0.01029
[64] = 0.010119
[65] = 0.009968
[66] = 0.009808
[67] = 0.009651
[68] = 0.009553
[69] = 0.009445
[70] = 0.009327
}

Bluephantom · 02/21/08, 11:31 AM

And in case your eyes hurt too much for that one, here is the formula for a lvl 70:

(0.001+SPI*0.009327*INT^0.5)*5 = MP5 OO5SR