[top](F47+G86+G91+G94+G88+G101+F$9+WENN('Main Sheet'!$B$47

ReignConfused · 10/01/07, 3:14 PM

Has he released an updated version? Or could anyone direct me to a viable way to remove the co-efficient to compare everything pre 2.3 and post 2.3?

frosty · 10/02/07, 6:34 AM

Originally Posted by ReignConfused

Has he released an updated version? Or could anyone direct me to a viable way to remove the co-efficient to compare everything pre 2.3 and post 2.3?

In order to remove the dmg-coefficients go to sheet 'Calculations' into field G47 (for fireball) and H47 (frostbolt).

The formula in G47 will look like:

[top](F47+G86+G91+G94+G88+G101+F$9+WENN('Main Sheet'!$B$47

"yes";'Game Stats'!$E$36;0))*(('Game Stats'!$B$78+Talents!$B67*0,03)*(1-Talents!$B58*0,02))

Now just remove the last part which is '*(1-Talents!$B58*0,02)'

Do the same in H47 (where it's actually '*(1-Talents!$B47*0,02)').

That should do the trick.

Roywyn · 10/02/07, 7:58 AM

Originally Posted by ReignConfused

Has he released an updated version? Or could anyone direct me to a viable way to remove the co-efficient to compare everything pre 2.3 and post 2.3?

As frosty said, you have to modify the entries in the sheet 'Calculations' in the way he descibed it.

G47, H47 for the gear in your current gear and spec.
X47, Y47 for the gear with your spec, and the changed gear stats (grey box in the 'Main Sheet').
G247, H247, G447, H447, G647, H647 to change it for the calculation with the calculations with a fire, frost and arcane spec.

Sorbe · 10/03/07, 8:47 AM

With items on the current spreadsheet...

[1] The socket combo boxes dont work on the "Talon of the Tempest" dagger
[2] The "Fang of the Leviathan" sword still has old data listed in the latest spreadsheet. (Full refresh time?)
[3] The "Wrath of Cenarius" ring is missing entirely.
[4] The "Elixir of Draenic Wisdom" is missing (often paired with Adept's Elixir).

I'm sure there are other issues -- just found those from digging around.

Rayga · 10/03/07, 11:01 PM

JoW on Arcane Missiles is incorrect as well. It's currently modeled to proc it only once.

Spellfire bonus is not in the spot on the gear it used to be in the newest version. I'm not sure if it was removed or if it was just moved.

Cardynal · 10/09/07, 11:32 AM

Just wanted to see if people were getting similar results.

With the best possible gear tailored for each spec...I get the following theory dps

Arcane Am spam - 1852 dps
This is assuming spamming 10 AM's and getting 1 CC.

Fire 6xFireball 1xScorch - 1857 dps

Frost Frostbolt spam as full frost- 1589 dps
Water elemental is 240dps...so it can burst to 1829dps. In a 5 minute fight...you can
summon your water elemental 3 times...which would average out
to 1697dps.

Frostbolt spam as 40/0/21 with another frost mage doing winter's chill - 1683dps

Vontre · 10/09/07, 1:55 PM

Originally Posted by Rayga

JoW on Arcane Missiles is incorrect as well. It's currently modeled to proc it only once.

Spellfire bonus is not in the spot on the gear it used to be in the newest version. I'm not sure if it was removed or if it was just moved.

There's my mana calculations... I'll have a fix in the next version along with the 2.3 changes.

aznxk3vi17 · 10/09/07, 5:36 PM

Is there any way I can do this through a 3rd party, possibly? I don't have Office installed on any computers here (I forgot to uh... buy it). I'm currently confused as to what my current optimal spec is, as I was trying out many different rotations last night, but none were very satisfying.

Aldric · 10/09/07, 5:52 PM

Originally Posted by aznxk3vi17

Is there any way I can do this through a 3rd party, possibly? I don't have Office installed on any computers here (I forgot to uh... buy it). I'm currently confused as to what my current optimal spec is, as I was trying out many different rotations last night, but none were very satisfying.

OpenOffice.org: Home

Once you get your install done Calc is the program you're looking for. The only thing that probably won't work is the Armory importer, although it might, I've never tried.

Rayga · 10/10/07, 12:34 AM

Originally Posted by Vontre

There's my mana calculations... I'll have a fix in the next version along with the 2.3 changes.

Yep, it was a simple change so I went ahead and modded it and added a few custom things myself (flame cap, destruction potion, scryer's bloodgem)

Cardynal · 10/12/07, 2:48 PM

how would I go about adding this new gem (12crit/3% crit dmg) to the spreadsheet?

(nvm, I just added 12 crit to the RED...and my version still works for spells. )

It's only a 10dps loss when using the new caster meta over the current version of the MSD

If the MSD is a 45 second cooldown...and if the proc rate went up to 33%...then you would cast 18 fireballs per 1 proc...assuming no passive haste. This gives it basically a passive haste rating of 15.26 when using fire. This actually scales negativly with passive haste.

I'm seeing a 23dps gain when using the new caster meta gem (12crit/3%crit dmg) over the New MSD for deep fire.

Aldric · 10/12/07, 4:50 PM

Originally Posted by Cardynal

incorrect MSD calculations

Followed Rowyn's example and moved my response on the issue over to the maga-thread to help keep things clean.

Roywyn · 10/12/07, 4:58 PM

Replied in the general mage thread, to keep this clear.

Basically, your numbers confuse me a lot, my results are different :o

http://elitistjerks.com/509210-post3101.html

Cardynal · 10/12/07, 5:05 PM

delete please

Cardynal · 10/12/07, 5:24 PM

Originally Posted by Aldric

I'm not sure how I feel about this way of determining the value of the new MSD (at least this guess on the new MSD) vs the new meta. First of all you're figuring the proc haste as 50% haste on next cast. It should be 100% haste for an increase of 50% cast time.

The new meta is pretty easy to calculate, average damage can be computed as

1.1ck + k = avg

for a fireball with ignite, where c is your crit percentage, and k your average fireball hit. The meta modifies this to

1.142ck + 1.01133k

using the same c and k as above (ie don't count the +12 crit rating in c)

umm...I was using the same math that the RED did...since I simply modified the RED and gave it 12 crit rating.

Ah...I see what I did for the New MSD now...

If it procs 33% of the time (this is an assumption to simply make it easier) then it will half the cast time of 1 fireball...meaning it would cast in 1.5 seconds. The following 15 fireballs would not have a chance to proc the gem...15x3 = 45. Then assume 1 of the next 3 will proc the gem...so that's roughly another 7.5 seconds....or 52.5. So that saved you 1.5 seconds...since 18 fireballs would have taken 54 seconds.

that's roughly 2.78% decrease in cast time...which would come out to a passive 43.61 haste. According to the spreadsheet...it is a 4dps increase over the method i used to calculate the CSD