Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics

 
 
LinkBack Thread Tools
Old 03/01/08, 10:17 PM   #276
Incoherence
Don Flamenco
 
Undead Priest
 
Mal'Ganis
Originally Posted by chrull View Post
This change seems so weird without giving us a 11 heal 5 spi gem. I've been eagerly awaiting it every time the PTR was updated but aparantly that's more fun than we are allowed to have.
That, and a green int/spi gem. It's worth pointing out that the heroic versions of both ([Imperial Tanzanite] and [Seer's Chrysoprase]) are worse compared to the single-stat epic for each; I assume it's some rounding thing with the heroic gems due to their lower ilvl (since not all gems have this problem; [Royal Tanzanite] is exactly the same as [Royal Shadowsong Amethyst]).

Offline
Old 03/02/08, 5:45 AM   #277
Nemockulous
Glass Joe
 
Human Priest
 
Maelstrom
Originally Posted by constantius View Post
There's a conversion which seems 99% accurate, computed by Kevan:
Regen_mp5 = 5*0.00932715221261 * sqrt(Int) * Spirit
There is a formula that i saw on the priest forums that is about 100% accurate for the 2.4 PTR regen changes

( ( √( Intellect ) ) / (21.45) ) * Spirit = OOC MP5

This model is pretty much accurate to the t.

On a side note, when comparing spirit to intellect as a stat goes, i have run some numbers using this formula. I forget where i wrote them down, but it came out to be that you needed roughly twice as much intellect compared to spirit to get the same amount of regen out of this new formula.

Quick Calculation
Spirit = 500
Intellect = 460 (√460 ~ 21.45)

so, With 460 Intellect, 500 Spirit we get 500 OOC mp5
We will now increase the spirit by 100, which gives us 600 OOC mp5
When we solve the above equation for intellect we get

( (21.45 * regen(600) ) / (spirit(500) ) )^2 = Intellect

Running this math gives us a needed 662.5 Intellect, an increase of 202.5 to reach the given increase in regen.

For the basics of it, if you aren't getting at least 2x the intellect versus spirit on an item, the intellect will not give you more regen than the spirit.

Oh, one more thing, with this formula, the higher above 460 intellect you go, the less each additional intellect point increases your regen since it is the √(Intellect). And i am guessing that many people are above 500 at least.

Conclusion:
The intellect to spirit ratio is
1Spirit : 2+Intellect

Offline
Old 03/02/08, 12:56 PM   #278
 Adoriele
Save Greendale!
 
Adoriele's Avatar
 
Night Elf Druid
 
Dragonblight
Originally Posted by Nemockulous View Post
There is a formula that i saw on the priest forums that is about 100% accurate for the 2.4 PTR regen changes

( ( √( Intellect ) ) / (21.45) ) * Spirit = OOC MP5
Considering that 1/(21.45*5) is very close to 0.00932715221261, you're talking about the same formula.
As for the correct ratio, if you try to stack to stack spirit that much with your gear, you're going to find yourself using inferior gear. It's better to stack gear for 3:2, then gem to bring yourself closer to 2:1.

United States Offline
Old 03/02/08, 2:37 PM   #279
TheDeamon
Glass Joe
 
Human Priest
 
Mannoroth
Originally Posted by Adoriele View Post
Considering that 1/(21.45*5) is very close to 0.00932715221261, you're talking about the same formula.
As for the correct ratio, if you try to stack to stack spirit that much with your gear, you're going to find yourself using inferior gear. It's better to stack gear for 3:2, then gem to bring yourself closer to 2:1.
It's the same basic formula, except it has rounding errors present in it that can add up given the right set of comparisons.

Though comparing the numbers between Whitetooth's formula(with the +0.001 added in) which track with the reported regen numbers from the client(rather than the character sheet) out to the 6th decimal place with 520 int, 494 int being the numbers I used... (the error I came up with was +0.0000032256297, though I might have been doing something wrong)

That alternate formula was off by -0.1734488262888 mana per 5 versus the in game client... Which for the majority of players won't really concern them too much when they're just doing mp5 comparisons on a single five second interval. It gets problematic when people start using it to model regen over a much longer duration.

Basically, it's good enough for shorthand calculations, particularly when dealing with the character sheet stats, as they're already riddled with rounded values. But for more detailed work, the longer formula is the better one to use.

Offline
Old 03/02/08, 7:11 PM   #280
Nemockulous
Glass Joe
 
Human Priest
 
Maelstrom
Originally Posted by Adoriele View Post
Considering that 1/(21.45*5) is very close to 0.00932715221261, you're talking about the same formula.
As for the correct ratio, if you try to stack to stack spirit that much with your gear, you're going to find yourself using inferior gear. It's better to stack gear for 3:2, then gem to bring yourself closer to 2:1.
This isn't what i am talking about at all.

Stacking spirit can be good, but you must keep it to some kind of pattern. For me, I break down an item as its stats pertain to regen (ex. in 2.3, spirit/2.7=1mp5 for me) and then compare from there.

In this intence, I can convert any gained intellect to spirit, using the formula, and then convert spirit to MP5.

for example, comparing two peices of gear

Piece 1 Piece 2 Difference
Stam = 42 Stam = 37 -5
Int = 28 Int = 42 +14
Spi = 25 Spirit = 43 +18
+heal = 78 +heal = 78 0
+7MP5 +5MP5 -2

2.3 compare:
18/2.7 = 6.66MP5 18/4 = 4.5
Real difference = -5
+14
+18
+4.5
+4.66

2.4 compare:
14/2 = 7 (7+18)/1.44(spirit->MP5 ratio) = 17.43MP5 18/4 = 4.5+heal
Real Difference = -5
+14
+18
+4.5
+15.43




If you approach comparing gear this way, you can fool proof yourself against getting a downgrade. Since for the most part on items spirit and intellect are given the same weight, you aren't gonna find a 2:1 ratio, and lucky if you find a 3:2 ration. Also gems give spirit and intellect the exact same weight, so you cannot find a 2:1 ratio of gems(basically a 8spirit gem will always > a 8 intellect gem). I don't know how anyone else does gear comparisons, but when you can convert 5 stats down to 1 or 2 its much easier to compare.

Offline
Old 03/02/08, 10:40 PM   #281
Ackis
Glass Joe
 
Troll Priest
 
Scarlet Crusade
Flask of Distilled Wisdom = 65 int = 1072 Mana

Therefore the coeff for Distilled Wisdom is: 0.1128

At:

350 Spirit: 39.5 MP/5
400 Spirit: 45.1 MP/5
450 Spirit: 50.8 MP/5
500 Spirit: 56.4 MP/5
550 Spirit: 62.0 MP/5
600 Spirit: 67.7 MP/5


Are those calculations correct?

Canada Offline
Old 03/02/08, 10:59 PM   #282
Ackis
Glass Joe
 
Troll Priest
 
Scarlet Crusade
BTW I made some modifications to the spreadsheet (adding MP5/Healing and different consumables)

RapidShare: 1-Click Webhosting

I have spirit of redemption listed as a talent because I was doing this while PVP specced w/o it.

Canada Offline
Old 03/02/08, 11:04 PM   #283
Nemockulous
Glass Joe
 
Human Priest
 
Maelstrom
Retracted Post

Last edited by Nemockulous : 03/03/08 at 11:44 PM.

Offline
Old 03/03/08, 1:59 AM   #284
Whitetooth
Piston Honda
 
Whitetooth's Avatar
 
Orc Warlock
 
Ner'zhul
The BASE_REGEN[LEVEL] in my original post on the formula is actually rounded to 6th decimal places, because that seems to be a logical thing to do when I looked at the raw data.
So I thought I should also post the raw data for those that care to experiment with it, see if it gives less error and what not, the raw data has a full 16 decimal places but most is rounding error from decimal -> binary -> decimal.

1 0.0349650010466576
2 0.0341910012066364
3 0.0334650017321110
4 0.0325269997119904
5 0.0316610001027584
6 0.0310769993811846
7 0.0305230002850294
8 0.0299949999898672
9 0.0293070003390312
10 0.0286619998514652
11 0.0275849997997284
12 0.0262150000780821
13 0.0253810007125139
14 0.0243009999394417
15 0.0233459994196892
16 0.0227489992976189
17 0.0219589993357658
18 0.0213869996368885
19 0.0207909997552633
20 0.0201210007071495
21 0.0197330005466938
22 0.0191559996455908
23 0.0188190005719662
24 0.0183169990777969
25 0.0179360006004572
26 0.0175769999623299
27 0.0172010008245707
28 0.0169190000742674
29 0.0165819991379976
30 0.0162339992821217
31 0.0159949995577335
32 0.0157079994678497
33 0.0154640004038811
34 0.0152040002867579
35 0.0149569995701313
36 0.0147449998185039
37 0.0144959995523095
38 0.0143020004034042
39 0.0140949999913573
40 0.0138959996402264
41 0.0137240001931787
42 0.0135220000520349
43 0.0133630000054836
44 0.0131759997457266
45 0.0129960002377629
46 0.0128539996221662
47 0.0126870004460216
48 0.0125399995595217
49 0.0123840002343059
50 0.0122330002486706
51 0.0121139995753765
52 0.0119730001315475
53 0.0118599999696016
54 0.0117149995639920
55 0.0115759996697307
56 0.0114730000495911
57 0.0113420002162457
58 0.0112450001761317
59 0.0111109996214509
60 0.0109999999403954
61 0.0107009997591376
62 0.0105229998007417
63 0.0102909998968244
64 0.0101199997588992
65 0.0099689997732639
66 0.0098080001771450
67 0.0096519999206066
68 0.0095530003309250
69 0.0094459997490048
70 0.0093270000070334

Last edited by Whitetooth : 03/03/08 at 2:07 AM.

Offline
Old 03/03/08, 12:48 PM   #285
Ackis
Glass Joe
 
Troll Priest
 
Scarlet Crusade
Updated spreadsheet to have elixir of mastery.

RapidShare: 1-Click Webhosting

Looks like elixir of mastery + elixir of draenic wisdom = win

Canada Offline
Old 03/03/08, 2:32 PM   #286
Kinien
Von Kaiser
 
Human Priest
 
Khaz Modan
Originally Posted by Ackis View Post
Updated spreadsheet to have elixir of mastery.

RapidShare: 1-Click Webhosting

Looks like elixir of mastery + elixir of draenic wisdom = win
All of that work you are doing has already been done Ackis. Your revisions have already been done
The "Looks like elixir of mastery + elixir of draenic wisdom = win" is old news.

MP5-modified.xls

Offline
Old 03/03/08, 3:35 PM   #287
Ackis
Glass Joe
 
Troll Priest
 
Scarlet Crusade
Originally Posted by Kinien View Post
All of that work you are doing has already been done Ackis. Your revisions have already been done
The "Looks like elixir of mastery + elixir of draenic wisdom = win" is old news.

MP5-modified.xls

Oh God, I saw that spreadsheet and I thought it was just a gear spreadsheet that I didn't understand :P GG for me seeing tabs. :P

And it wasn't a waste, I was able to understand it more myself.

Think they may buff mighty restoration at all?

Canada Offline
Old 03/03/08, 4:57 PM   #288
Muphrid
Don Flamenco
 
Gnome Mage
 
Llane
Nemockulous: you're right that the stated ratios that are "optimal" are also difficult to achieve. It's mostly of theoretical interest, I think.

Thus, your approach to stat equivalence is basically the way I would do things, just in a more formalized fashion. We can use algebra to generalize.

Given k \approx 9.327 \cdot 10^{-3}, we have...

R(i,s,f) = k s \sqrt i + f

We can compute various deltas...

\begin{align} \Delta{R}(i,s+\Delta{s},f) &= k \Delta s \sqrt i \\ \Delta R (i+\Delta i,s,f) &= k s \sqrt{i} \left (\sqrt{1+\frac{\Delta i}{i}} - 1 \right ) \\ \Delta R (i, s, f+\Delta f) &= \frac{\Delta f}{5} \end{align}

Which allows us to convert freely between int, spirit, and mp5. Converting int and spirit to equivalent mp5 is done by setting these expressions equal.

\begin{align} \Delta f_{equiv} &= 5 k \Delta s \sqrt{i} \\ &= 5 k s \sqrt{i} \left (\sqrt{1+\frac{\Delta i}{i}} - 1 \right ) \end{align}

These are, in essence, first-order approximations. You'll note that if one increases both int and spirit at the same time, one gets...

\begin{align} \Delta R(i+\Delta i, s + \Delta s, f) &= k (s + \Delta s) \sqrt{i+\Delta i} - k s \sqrt{i} \\ &= k s \sqrt{i} \left ( \left (1 + \frac{\Delta s}{s} \right) \sqrt{1+\frac{\Delta i}{i}} - 1 \right ) \end{align}

We can subtract out the one-variable gains of just int and spirit to figure out what the non-linear ("quadratic") gain is.

\begin{align} \Delta R(i+\Delta i, s+\Delta s, f) - \Delta R(i + \Delta i, s,f) - \Delta R(i, s+\Delta s, f) &= k \Delta s \left(\sqrt{i+\Delta i} - \sqrt{i}\right) \\ &= k s \sqrt{i} \left(\frac{\Delta s}{s} \right) \sqrt{1+\frac{\Delta i}{i}} \\ &= R(i,s,f) \left(\frac{\Delta s}{s} \right) \sqrt{1+\frac{\Delta i}{i}} \end{align}

This is, of course, of even less practical use, merely theoretical interest. Indeed, for a change of +10 spirit and +10 int at 300 spirit and 400 int, we get a paltry .116 mp5 from the non-linear term (compared to 12.8 mp5 from the linear terms, a less than 1% difference).

Offline
Old 03/04/08, 12:04 AM   #289
Nemockulous
Glass Joe
 
Human Priest
 
Maelstrom
Originally Posted by Muphrid View Post
Nemockulous: you're right that the stated ratios that are "optimal" are also difficult to achieve. It's mostly of theoretical interest, I think.

Thus, your approach to stat equivalence is basically the way I would do things, just in a more formalized fashion. We can use algebra to generalize.

Given k \approx 9.327 \cdot 10^{-3}, we have...

R(i,s,f) = k s \sqrt i + f

We can compute various deltas...

\begin{align} \Delta{R}(i,s+\Delta{s},f) &= k \Delta s \sqrt i \\ \Delta R (i+\Delta i,s,f) &= k s \sqrt{i} \left (\sqrt{1+\frac{\Delta i}{i}} - 1 \right ) \\ \Delta R (i, s, f+\Delta f) &= \frac{\Delta f}{5} \end{align}

Which allows us to convert freely between int, spirit, and mp5. Converting int and spirit to equivalent mp5 is done by setting these expressions equal.

\begin{align} \Delta f_{equiv} &= 5 k \Delta s \sqrt{i} \\ &= 5 k s \sqrt{i} \left (\sqrt{1+\frac{\Delta i}{i}} - 1 \right ) \end{align}

These are, in essence, first-order approximations. You'll note that if one increases both int and spirit at the same time, one gets...

\begin{align} \Delta R(i+\Delta i, s + \Delta s, f) &= k (s + \Delta s) \sqrt{i+\Delta i} - k s \sqrt{i} \\ &= k s \sqrt{i} \left ( \left (1 + \frac{\Delta s}{s} \right) \sqrt{1+\frac{\Delta i}{i}} - 1 \right ) \end{align}

We can subtract out the one-variable gains of just int and spirit to figure out what the non-linear ("quadratic") gain is.

\begin{align} \Delta R(i+\Delta i, s+\Delta s, f) - \Delta R(i + \Delta i, s,f) - \Delta R(i, s+\Delta s, f) &= k \Delta s \left(\sqrt{i+\Delta i} - \sqrt{i}\right) \\ &= k s \sqrt{i} \left(\frac{\Delta s}{s} \right) \sqrt{1+\frac{\Delta i}{i}} \\ &= R(i,s,f) \left(\frac{\Delta s}{s} \right) \sqrt{1+\frac{\Delta i}{i}} \end{align}

This is, of course, of even less practical use, merely theoretical interest. Indeed, for a change of +10 spirit and +10 int at 300 spirit and 400 int, we get a paltry .116 mp5 from the non-linear term (compared to 12.8 mp5 from the linear terms, a less than 1% difference).
Well, I don't think that this type of calculation is all that theoretical. In the computations that are being performed, there are really no assumptions being made, which basically removes the theory factor to the calculations. When analyzing Intellect V Spirit from a purely regeneration standpoint, you carry no assumptions. When you compare that to say a regeneration model based on %inside the five second rule, that is more of a theoretical model.

I however do like your approach of removing all the numbers to create a generic equation, because the way i performed the calculation was a tad crude (I have since made a excel spreadsheet that i will post if i get a chance).

On a side note, what did you use to get all of your equations in such a nice looking format?

Offline
Old 03/04/08, 2:50 AM   #290
Muphrid
Don Flamenco
 
Gnome Mage
 
Llane
Well, I say it's of theoretical interest because a spreadsheet or tool would probably just want a master formula and calculate numerical equivalences rather than using the derived equivalences.

Now, to go more along the lines of what you're saying, it would be more "theoretical" to introduce another constant multiplier to account for the five-second rule and the percent of regeneration allowed while in it. If you wanted to be really technical, you could introduce a function as a multiplier (perhaps a function of time, even?). No idea how useful that would be, though.

And the boards have LaTeX built in, which is quite convenient for me to learn the language while avoiding a lot of the compromises usually associated with posting algebra.

Offline
Old 03/04/08, 8:36 AM   #291
Nahiag
Glass Joe
 
Night Elf Hunter
 
Burning Legion (EU)
I wonder if they realy intended it to be this major of a buff, or well, yes they want to make spirit better, aswell as making intellect worthwhile. that's good. But giving a druid/priest ~50 while casting mp5 for free? just out of nowhere? hmm seems to be little too much imho, neither paladins or shamans gain from this buff.

I like the buff though, realy makes spirit better and could even make arcane visiable ^_^

Offline
Old 03/04/08, 12:30 PM   #292
Nemockulous
Glass Joe
 
Human Priest
 
Maelstrom
Originally Posted by Nahiag View Post
I wonder if they realy intended it to be this major of a buff, or well, yes they want to make spirit better, aswell as making intellect worthwhile. that's good. But giving a druid/priest ~50 while casting mp5 for free? just out of nowhere? hmm seems to be little too much imho, neither paladins or shamans gain from this buff.

I like the buff though, realy makes spirit better and could even make arcane visiable ^_^
Well they have done it before. Remember I believe it was 2.2 or 2.3 when the increased meditation and the druid talent to give 30% regen while casting. I think in large part this change could have to do with the shift away from regen on items, and towards spell haste. By increasing the regen model, you can allow for less regen stats on an item and increase its other stats, i.e. spell haste.

Offline
Old 03/04/08, 1:04 PM   #293
Jacinthia
Glass Joe
 
Jacinthia's Avatar
 
Night Elf Druid
 
Bronzebeard
It does seem a bit of a huge buff. Like I mentioned, I gained about 40-50mp5 for doing nothing but keeping the gear/gem set I have. There is a bit of shift towards spell haste, which I imagine is to offset the mana gains (no mp5 on a lot of spell haste pieces) but this seems to be quickly contradicted by the set pieces (boots, bracers, belt) as they have both spell haste, healing, and mp5.

I keep telling myself it's not a joke, I was excited when flexing like 500 OOFSR and nearly 320 within, now with 2.4 it's up to nearly 800-1000 ooFSR and close to 450-500 within. (all theorycrafting of course)

From most of my time on the PTR I've gathered at least this for druids.

Red = Teardrop Crimson Spinel
Blue = Sparkling Empyrean Sapphire
Yellow = Luminous Pyrestone

However a though that comes across my mind, with spirit such an assest, innervating that shadow priest becomes infinitely more viable.

I don't know if it's me, but does 2.4 seem like it spells the end of the hybrid gems for healers? (Goodbye shadowsong?)

Offline
Old 03/04/08, 1:07 PM   #294
Jacinthia
Glass Joe
 
Jacinthia's Avatar
 
Night Elf Druid
 
Bronzebeard
Originally Posted by Nemockulous View Post
Well, I don't think that this type of calculation is all that theoretical. In the computations that are being performed, there are really no assumptions being made, which basically removes the theory factor to the calculations. When analyzing Intellect V Spirit from a purely regeneration standpoint, you carry no assumptions. When you compare that to say a regeneration model based on %inside the five second rule, that is more of a theoretical model.

I however do like your approach of removing all the numbers to create a generic equation, because the way i performed the calculation was a tad crude (I have since made a excel spreadsheet that i will post if i get a chance).

On a side note, what did you use to get all of your equations in such a nice looking format?
Maple or MathLAB

Offline
Old 03/04/08, 2:30 PM   #295
Richelieu
Von Kaiser
 
Undead Priest
 
Area 52
Regarding the "ideal" ratio of Spirit:Intellect in 2.4, after reading a thorough article on the subject posted yesterday at the Resto4Life blog (link below), it occurred to me that the ratio analyses in this thread have been assuming a fight of infinite duration. As Resto4Life points out, the raw chunk of additional mana provided by Intellect has an MP5 value that varies with the fight length; ergo, the ideal ratio actually varies with the fight length. And as the chart in the article demonstrates, the variation in the ratio is very substantial moving from a 4 minute to an 8 minute fight.

Article link: http://www.resto4life.com/2008/03/03...-1-the-basics/

Since the 3:2 ratio (when accounting for item budgeting) and 2:1 ratio (when not accounting for it) assume an infinite fight length, they cannot be the "ideal" ratios for any encounter the game has or ever will have. The ideal ratios will necessarily favor Intellect more. Resto4Life tentatively concludes that a ratio around 7:5 is ideal, but her conclusion is limited to Resto Druids under a specific trinket itemization. She also does not account for item budget costs (so her Resto ideal ratio may actually end up close to 1:1 when choosing gear sans gems). However, her general reasoning makes obvious that this thread has yet to arrive at the true, actual-gameplay ideal ratio for a typical-length boss fight (say 8 minutes). My calculus has been long forgotten, so I'll just throw the computation of that down as a challenge to the posters here....

Offline
Old 03/04/08, 2:46 PM   #296
 Adoriele
Save Greendale!
 
Adoriele's Avatar
 
Night Elf Druid
 
Dragonblight
Originally Posted by Richelieu View Post
Regarding the "ideal" ratio of Spirit:Intellect in 2.4, after reading a thorough article on the subject posted yesterday at the Resto4Life blog (link below), it occurred to me that the ratio analyses in this thread have been assuming a fight of infinite duration. As Resto4Life points out, the raw chunk of additional mana provided by Intellect has an MP5 value that varies with the fight length; ergo, the ideal ratio actually varies with the fight length. And as the chart in the article demonstrates, the variation in the ratio is very substantial moving from a 4 minute to an 8 minute fight.

Article link: http://www.resto4life.com/2008/03/03...-1-the-basics/

Since the 3:2 ratio (when accounting for item budgeting) and 2:1 ratio (when not accounting for it) assume an infinite fight length, they cannot be the "ideal" ratios for any encounter the game has or ever will have. The ideal ratios will necessarily favor Intellect more. Resto4Life tentatively concludes that a ratio around 7:5 is ideal, but her conclusion is limited to Resto Druids under a specific trinket itemization. She also does not account for item budget costs (so her Resto ideal ratio may actually end up close to 1:1 when choosing gear sans gems). However, her general reasoning makes obvious that this thread has yet to arrive at the true, actual-gameplay ideal ratio for a typical-length boss fight (say 8 minutes). My calculus has been long forgotten, so I'll just throw the computation of that down as a challenge to the posters here....
You're correct, and the model here also doesn't factor in the bonus spell crit for all caster, spell damage and Mp5 for Moonkins, etc, all of which provide a benefit from int, or the extra healing for tree druids, spell damage under the effects of Imp. DS, or healing for priests. All of these are much more case-by-case problems without an easy closed-form solution. However, if your intent is simply to maximize your regen, then barring Dreamstate these calculations work pretty well.

United States Offline
Old 03/04/08, 5:26 PM   #297
Richelieu
Von Kaiser
 
Undead Priest
 
Area 52
Originally Posted by Adoriele View Post
You're correct, and the model here also doesn't factor in the bonus spell crit for all caster, spell damage and Mp5 for Moonkins, etc, all of which provide a benefit from int, or the extra healing for tree druids, spell damage under the effects of Imp. DS, or healing for priests. All of these are much more case-by-case problems without an easy closed-form solution. However, if your intent is simply to maximize your regen, then barring Dreamstate these calculations work pretty well.
The examples you mention are clear "case-by-case problems," and they are nontrivial to the extent they involve damage/healing --> mana conversions peculiar to a class. In contrast, 1 Int = 15 more mana at the fight's commencement for all casters.** The effective regen rate of that 15 mana over an x-minute fight is the same for all casters. It would thus seem to make some sense to include that in a base general formula that is the starting point for all the subsequent case-by-case analyses.

In any event, the point is moot because the formula already has been published. I overlooked that Resto4Life included it and its derivation in an appendix to her post. She says it is:

S = 2I - 30√I / (t * 0.046635) where t = number of ticks in the fight.

This adjusted formula does indeed present a character-by-character element because the ratio now varies not only with the fight length, but also with the character's actual amount of Int. The effect of differing Int levels is less than the effect of the t variable; here are some example ratios calculated with this formula:

Character with 400 Int, 300 tick (10-minute) fight: 1.892:1

600 Int, 10 min fight: 1.912:1

400 Int, 5 min fight: 1.786:1

600 Int, 5 min fight: 1.824:1

Now if only someone could adjust her formula to account for item value budgeting...




**However, according to Wowwiki, the first 20 points of Intellect only contribute 1 mana each. See Attributes - WoWWiki - Your guide to the World of Warcraft The formula discussed in this post does not account for that.

Offline
Old 03/04/08, 5:35 PM   #298
constantius
Soda Popinski
 
constantius's Avatar
 
Dwarf Priest
 
Shadowsong
Speaking from an end-game perspective, there will be functionally *zero* cases where I will care to compare the amount of intellect on an item. Zero. Zip. Zilch. I just functionally do not care.

I will (and do, currently) have over 700 intellect raid-buffed on my gear. I will not stack it. I will not care about it. It's there, it's free, it's meaningless. Given that regen is going to scale with the square root of intellect, stacking it makes absolutely no sense as a priest, given that I get nothing from it but that scaling and spell crit. Stacking spirit on the other hand ... gives linearly increasing regen results and gives 35% as +heal.

The constant arguments over what ratio to aim for are, to be frank, silly, when taken in the context of priests and druids. We really should *not* be caring about 'stacking intellect'. It's a dumb idea. Don't even care about your ratio, either. It's not like we have multiple sets of gear sitting around with identical stats except for the amount of intellect/spirit on them. There are a maximum of 2 items per slot in 2.4 that are 'best-in-game'. They basically differ in the amount of spirit they have on them (spirit and haste, to be precise). That's it. You pick the one you want more of, and you get intellect for free.

Anyone who cannot cope with mathematics is not fully human. At best he is a tolerable subhuman who has learned to wear shoes, bathe, and not make messes in the house. - R.A. Heinlein

Offline
Old 03/04/08, 5:39 PM   #299
Muphrid
Don Flamenco
 
Gnome Mage
 
Llane
Yeah, look, the math doesn't say more than what it says. Optimizing the spirit regen function on the item point allocator, well, just doesn't tell you very much when there are other factors at play. Yes, we can make more complicated models to find better optimizations, but the majority of such work is best done by spreadsheets and tools, not by symbolic math.

Offline
Old 03/04/08, 5:54 PM   #300
Eldergrubel
Glass Joe
 
Dwarf Hunter
 
Norgannon
A few points about the MP5-modified.xls:

Gem Values

It does not seem accurate to value all gem colors the same (@18 points for example). Instead, the stat point values should be based on what is entered for each gem choice and your stat point values. Red > Blue > Yellow.

Blue: Cell X6, Formula: =H3*W$3+I3*X$3+J3*Z$3+K3*Y$3

Red: Cell Y6, Formula: =H5*W$3+I5*X$3+J5*Z$3+K5*Y$3

Yellow: Cell Z6, Formula: =H4*W$3+I4*X$3+J4*Z$3+K4*Y$3

Meta: Cell Z9, Formula: =H6*W$3+I6*X$3+J6*Z$3+K6*Y$3

Missing Items

I found a number of items missing from the spreadsheet that may be helpful for the community. I added these items to my own version, but I thought it might be helpful if they were added to the "master" version being distributed.

Light-Collar of the Incarnate
Light-Mantle of the Incarnate
Masquerade Gown
Trousers of the Incarnate
Gloves of Saintly Blessings
Vindicator's Mooncloth Cuffs (competative if socketed with red +healing gem)
Anveena's Touch (version 2.4 60 Badges Ring)
Earring of Soulful Meditation (estimate stats: 75 spirit, 66 healing)
Essence of the Martyr (estimate stats: 134 healing)
Fel-Reaver's Piston (estimate stats: 75 healing, 16 Mp5)
Lower City Prayerbook (estimate stats: 70 healing, 12 Mp5)
Ribbon of Sacrifice (estimate stats: 98 healing)
Gavel of Pure Light (Sha'tar Exalted)
Vengeful Gladiator's Baton of Light
Carved Witch Doctor's Stick
Blue Diamond Witchwand

Thanks in advance.

Offline
 

Go Back   Elitist Jerks » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Stat Conversion Nite_Moogle Theorycrafting Think Tank 1 08/31/09 3:06 PM
[Casters] Intellect -> Spell Crit? vokzhen Class Mechanics 5 09/16/07 7:43 PM
Final Word on Spirit Regen? Burrbon Class Mechanics 3 04/27/07 2:43 PM
Rating to % Conversion? Necrotoid User Interface and AddOns 2 04/19/07 5:03 PM
Spirit and Crit Rates MongoJerry Public Discussion 20 06/16/06 8:43 PM