Formula to calculate your Spirit:MP5 ratio

[Rayu]

Figured it would be nice to be able to calculate if you should get more spirit or more MP5 on your gear and since it's quite easy to construct a formula to do this I will. Note that we ignore spirit's health regen aspect here! (we assume 100% combat time)



The exact equations will be posted later because they are kind of messy atm and I will also upload a spreadsheet for you to download so you can put in your own stats. For now you'll have to do it all manually:



Int = Intellect

NFSR% = Percentage of time outside five-second-rule

SQRT(x) = Square root of x



1 point of MP5 = 1 / ( 0.06237 * SQRT(Int) * NFSR% ) Spirit



Hope it helped for some of you!

Thanks Kore.

 

[taniwha]

Figured it would be nice to be able to calculate if you should get more spirit or more MP5 on your gear and since it's quite easy to construct a formula to do this I will. Note that we ignore spirit's health regen aspect here! (we assume 100% combat time)



The exact equations will be posted later because they are kind of messy atm and I will also upload a spreadsheet for you to download so you can put in your own stats. For now you'll have to do it all manually:



Int = Intellect

NFSR% = Percentage of time outside five-second-rule

SQRT(x) = Square root of x



1 point of MP5 = 1/(0.0010395*NFSR%*SQRT(Int)) Spirit



Hope it helped for some of you!



PS does anyone know a website where I can safely upload spreadsheets?

Try saving the spreadsheet as a TAB separated file then open in notepad and paste into a twinkinfo post between [ CODE ]....[ /CODE ] tags :



http://www.twinkinfo.com/10-19-bracket/8417-spirit-regen-ratio.html#post110051

 

[Rayu]

Try saving the spreadsheet as a TAB separated file then open in notepad and paste into a twinkinfo post between [ CODE ]....[ /CODE ] tags :



http://www.twinkinfo.com/10-19-bracket/8417-spirit-regen-ratio.html#post110051

My formula is more useful than the table in the topic but thanks for the link. Thanks for the tip on the spreadsheet I will try it out now.

 

[Kore nametooshort]

where are you getting that coefficient from? Because when i plug into this formula i get 1mp5=289spirit, which is a scale factor of about 60 different from what i usually use.

 

[Rayu]

where are you getting that coefficient from? Because when i plug into this formula i get 1mp5=289spirit, which is a scale factor of about 60 different from what i usually use.

I did the calculations again and you are correct, I was indeed a factor 60 off. My apologies:



3 * ( 0.001 + SQRT(Int) * Spirit * 0.020790 ) * NFSR% + ( MP5 + 1 ) = 3 * ( 0.001 + SQRT(Int) * X * 0.020790 ) * NFSR% + MP5

( 1.003 + 0.06237 * SQRT(Int) * Spirit ) * NFSR% + MP5 = ( 0.003 + 0.06237 * SQRT(Int) * X ) * NFSR% + MP5

1 + 0.06237 * SQRT(Int) * NFSR% * Spirit = 0.06237 * SQRT(Int) * X

1 / (0.06237 * SQRT(Int) * NFSR% ) + Spirit = X

X - Spirit = 1 / ( 0.06237 * SQRT(Int) * NFSR% )



The reason for this is because I overlooked the 0.6 factor at the end of the given formula.