|
First, I think that the quoted equations above get the coefficients wrong in the final formula. It is not enough to count *only* coefficients that affect Mind Flay because they are additive among coefficients that also affect Mind Blast. This would prevent you from being able to "cancel" them out when you do the final algebra.
|
There are errors in both your formula and spreadsheet. The real question that should be asked now is the behaviour of the Glyph of Mind Flay. The ONLY difference between the old equation and the one you propose is if the 10% damage from the glyph of MF is additive to TF or multiplicative to ALL MF damage modifiers. Below is boring work:
1. DMB = (1.15)(1.10)(1.10)(1.10)(1.15*0.4285*X+1025)
Mind Blast = 992 to 1048 base damage
This is an average base hit of 1020, not 1025. MB is overrated.
2. DMF = (1.15)(1.15)(1.10)(1.20)(1.15*0.7710*X+533)
Mind Flay = 588 base damage
588, not 533, Mind Flay was underrated.
3. The spreadsheet has errors.
Cell A4 is "=((((1.15*1.1)*1.1)*1.1)*(((1.15*A2)*0.4285)+1025))" for MB, with A2 = 4000, it results in 4585.98
Cell A4 (condensed) should read "=(1.15*1.1*1.1*1.1)*((1.15*0.4285*A2)+1020)" which results in 4578.32 @ 4000 spell power
Cell A8 changed to "=(1.15*1.15*1.1*1.2)*((1.15*0.771*A2)+588)"
Cell E2 has a different formula than A4 for MB's DPE. E2 changed to "=((1.15*1.1*1.1*1.1*1.1)*((1.15*0.4285*A2)+1020))/D5"
Cell F2 has a different formula than A8 for MF's DPE. F2 changed to "=((1.15*1.15*1.10*1.2)*((1.15*0.771*A2)+588))/D8"
Result? False becomes true at 860haste + minor + major raid buffs (37%) and 4,000 spell power.
Let's correct this bad boy:
(1.53065)(0.492775x + 1025)/(y+(1.5/(1+z))) = (1.7457)(0.88665x + 533)/(y+(2.49/(1+z))
Should read: (1.53065)(0.492775x + 1020)/(y+(1.5/(1+z))) = (1.7457)(0.88665x + 588)/(y+(2.49/(1+z))
Condensing:
(0.75426605375x + 1561.263)/(y+(1.5/(1+z))) = (1.547824905x + 1026.4716)/(y+(2.49/(1+z))
to
(0.75426605375x + 1561.263)*(y+(2.49/(1+z)) = (1.547824905x + 1026.4716)*(y+(1.5/(1+z)))
to
(0.75426605375x + 1561.263)*MFcastD = (1.547824905x + 1026.4716)*MBCastD
to
spell power needed =
((1026.4716*MBCastD) - (1561.263*MFCastD)) / ((0.754266*MFCastD) - (1.547825*MBCastD))
A new formula!!! But is it really different?
So let's put 0.17 delay to three different equations and see if they differ.
The elder formula: ((1020*(MFcast+delay))-(679.14*(MBcast+delay)))/((1.0240807*(MBcast+delay))-(0.492775*(MFcast+delay)))
assumes that the Glyph of Mind Flay is multiplicitave, not additive. If it is additive, we need to break down the like coeffecients differently.
DMF = (1.15)(1.15)(1.10)(1.20)(1.15*0.7710*X+533)
DMB = (1.15)(1.10)(1.10)(1.10)(1.15*0.4285*X+1025)
becomes
DMF = (1.15)(1.15)(1.10)(1.20)*y
DMB = (1.15)(1.10)(1.10)(1.10)*z
DMF ?=? DMB
(1.15)(1.15)(1.10)(1.20)y=(1.15)(1.10)(1.10)(1.10)z
(1.15)(1.15)(1.10)(1.20)y/(1.15)(1.10)(1.10)(1.10) = z
(1.140496)y=z
Which gives us a "additive changed old formula" of:
MF: 1.140496(588 + 0.88665x) which is (670.611648 + 1.0112207784x)
MB: 1020 + 0. 492775x
Additive old: ((1020*MFCastD)-(670.611648*MBCastD))/((1.0112207784*MBCastD)-(0.492775*MFCastD))
We wind up with an exact match (table below) between changing the old formula to having Glyph of MF being additive to the new formula posted above, which both differ from the old formula that used the Glyph of MF as being multiplicative. What the question now, is, not if algebra is suddenly not working with numbers in World of Warcraft, but rather:
Does the Glyph of Mind Flay stack multiplicatively or additively with other damage modifers of Mind Flay???
Haste - MFCastD - MBCastD - Old EQ - New EQ - Old w/ Glyph Change
1200 - 1.86 - 1.19 - 3605 - 3833 - 3833
1190 - 1.86 - 1.19 - 3605 - 3833 - 3833
1180 - 1.86 - 1.19 - 3605 - 3833 - 3833
1170 - 1.87 - 1.19 - 3700 - 3936 - 3936
1160 - 1.87 - 1.19 - 3700 - 3936 - 3936
1150 - 1.87 - 1.2 - 3554 - 3777 - 3777
1140 - 1.88 - 1.2 - 3646 - 3877 - 3877
1130 - 1.88 - 1.2 - 3646 - 3877 - 3877
1120 - 1.89 - 1.2 - 3740 - 3981 - 3981
1110 - 1.89 - 1.21 - 3594 - 3821 - 3821
1100 - 1.89 - 1.21 - 3594 - 3821 - 3821
1090 - 1.9 - 1.21 - 3686 - 3922 - 3922
1080 - 1.9 - 1.21 - 3686 - 3922 - 3922
1070 - 1.91 - 1.22 - 3634 - 3864 - 3864
1060 - 1.91 - 1.22 - 3634 - 3864 - 3864
1050 - 1.91 - 1.22 - 3634 - 3864 - 3864
1040 - 1.92 - 1.22 - 3726 - 3966 - 3966
1030 - 1.92 - 1.23 - 3583 - 3809 - 3809
1020 - 1.93 - 1.23 - 3673 - 3907 - 3907
1010 - 1.93 - 1.23 - 3673 - 3907 - 3907
1000 - 1.93 - 1.23 - 3673 - 3907 - 3907
990 - 1.94 - 1.24 - 3622 - 3851 - 3851
980 - 1.94 - 1.24 - 3622 - 3851 - 3851
970 - 1.95 - 1.24 - 3713 - 3951 - 3951
960 - 1.95 - 1.24 - 3713 - 3951 - 3951
950 - 1.96 - 1.25 - 3661 - 3894 - 3894
940 - 1.96 - 1.25 - 3661 - 3894 - 3894
930 - 1.96 - 1.25 - 3661 - 3894 - 3894
920 - 1.97 - 1.25 - 3752 - 3994 - 3994
910 - 1.97 - 1.26 - 3611 - 3839 - 3839
900 - 1.98 - 1.26 - 3700 - 3936 - 3936
890 - 1.98 - 1.26 - 3700 - 3936 - 3936
880 - 1.99 - 1.26 - 3791 - 4037 - 4037
870 - 1.99 - 1.27 - 3649 - 3881 - 3881
860 - 1.99 - 1.27 - 3649 - 3881 - 3881