Vontre's Mage DPS Spreadsheet - Page 2

Kavan · 04/12/07, 5:10 AM

Some things that came to my mind looking through the spreadsheet:

-base mana is wrong: 70 gnome mage has 1961 base mana, you have 933 (I believe this was at level 60)
-add field to modify spirit for evocation (spi weapon swap)
-crit does not match character sheet (should be rating/14*(1-10/246)+int/80+0.9075)
-add option for damage from divine spirit
-for pure arcane builds the following combos are interesting in arcane blast cycles: AMx2, AM8x2, AM8 (with overlap, extra spirit tick)

And one question: what are you basing mana regen from Vampiric Touch on?

Jayde · 04/12/07, 8:35 AM

I agree that I'd also like to see a spirit weapon swap option. I think most hardcore raiding Mages are doing this now, simply due to the massive difference in mana gain from it. You're basically looking at a 100 Spirit increase in most cases if you have a green level 70 MH/OH/Wand/Enchant setup.

Based on swapping the spirit totals and looking at the Calculations in your sheet, it seems that an optimized spirit swap more or less adds around 1600 mana to an Evocation channel... which is a rather substantial amount.

Kalman · 04/12/07, 10:12 AM

2.3.1 uploaded.

Vontre, I'm (slowly) working on a gear interface to the sheet, similar to the one the rogue DPS spreadsheet uses. I'll forward you a copy once I have it up and running.

Vontre · 04/12/07, 11:27 AM

Oh cool!

I'll take a look at the weapon swap and a few of those fixes, thanks for the numbers.

kelben · 04/12/07, 12:17 PM

Nice update

Its a little suggestion but for the armor field would adding a clickable menu make sense? I have no clue how hard it is but i've seen it before in spreadsheets. Terrible description I know

Anyhow last night was the first time I've ever had a shaman in my group and this one was specced full resto meaning he was dropping a mana tide totem (twice on the gruul fight) the mana return was crazy

For the haste effects how are you accounting for them? Most are short in duration and have a hefty cooldown which is still being debated (closest i've been able to determine is 2.1 procs a minute roughly for the sword and trinket which works with the 45 second cooldown people are reporting - my currently theory is 6x duration on these items vs the 3x duration for melee haste effects)

And did you figure combustion as a flat crit % bonus? Oh and maybe add the human racial in too, its not as important as the gnome racial but it helps... same for the %hit aura racial

And one more question - what do you consider a dps consumable? what do you consider a mana regen consumable?

One other thing occured to me, could you add the option to change the lvl of mob? I realize boss dps on lvl 73 mobs is the most important thing but still I'm kind curious regarding my dps vs a 70, 71 and 72 mob

Vontre · 04/12/07, 12:33 PM

By the way Kalman if your stuff involves changing the calculations table (I doubt it would) you'll want to hold off a bit, I'm in the middle of changing the cell references for a new feature.

Vontre · 04/12/07, 12:36 PM

Originally Posted by kelben

Nice update

Its a little suggestion but for the armor field would adding a clickable menu make sense? I have no clue how hard it is but i've seen it before in spreadsheets. Terrible description I know

Anyhow last night was the first time I've ever had a shaman in my group and this one was specced full resto meaning he was dropping a mana tide totem (twice on the gruul fight) the mana return was crazy

For the haste effects how are you accounting for them? Most are short in duration and have a hefty cooldown which is still being debated (closest i've been able to determine is 2.1 procs a minute roughly for the sword and trinket which works with the 45 second cooldown people are reporting - my currently theory is 6x duration on these items vs the 3x duration for melee haste effects)

I'm just not accounting for haste effects or any other proccable/activated trinkets or other gears.

Kalman is making a clickable menu for gear.

Oh and VT is estimated as 150 mp5

Kalman · 04/12/07, 1:08 PM

Originally Posted by Vontre

By the way Kalman if your stuff involves changing the calculations table (I doubt it would) you'll want to hold off a bit, I'm in the middle of changing the cell references for a new feature.

Not planning to touch any of the calculations, I'll just provide a total of stats/damage/crit/hit/etc from gear as references the calculations can work from.

Sockets are gonna be pretty quick and dirty in the first revision, though.

Leto · 04/12/07, 1:18 PM

Originally Posted by Kalman

2.3.1 uploaded.

Vontre, I'm (slowly) working on a gear interface to the sheet, similar to the one the rogue DPS spreadsheet uses. I'll forward you a copy once I have it up and running.

Good news! Thats the main thing I've missed from the rogue spreadsheet.

Thanks again guys for all the work you've put into spreadsheets and such, they really help drive the theorycrafting progress for the class.

kelben · 04/12/07, 1:47 PM

I guess it would be easier to sum it up in point form rather than the scatter thought process I did above, I'm even finding it disorganized to read. My little wish list for the spread would be the following

1) Add all racial bonuses that apply to magic (spirit, %hit)
2) Add mana tide totem
3) Account for haste ratings with cooldowns (sword / eye)
4) Allow for the mob lvl to be adjusted
5) Add in spirit for evocation (coming in future version)
6) Account for combustion (or do you already do this?)

And thank you once again, the spreadsheet is a huge and rather unforgiving job but both of you have done an amazing job on it

tedv · 04/12/07, 1:49 PM

150 m/5 from Vampiric Touch is on the conservative side. With only 1000 +damage (obtainable without being a tailor and using only loot from 5 and 10 man instances) and curse of shadows, mind flay alone ticks for 600 DPS, which is 30 mana/sec, or 150 m/5. Once you factor in the damage from Shadow Word Pain and Vampiric Touch it's closer to 800 DPS, or 200 m/5. And going crazy with Mind Blast and Shadow Word Death brings it up to 1000 DPS, or 250 m/5.

Vontre · 04/12/07, 2:31 PM

Combustion is its own topic altogether, and if I account for it I have to account for arcane power as well (averaged out). I'm currently running under the assumption that the total gain of these abilities over their 3 minute duration is, for the most part, negligible.

Aside from some fixes I've added what I think is a very much needed new feature: A talent spec comparison. I've included 3 raid-oriented talent builds with pretty much all the basic goodies: one for fire, arcane, and frost. The talent comparison will show total damage output from each build and tell you which is highest, for your given scenario.

Upload incoming, v2.3.5

Vontre · 04/12/07, 2:35 PM

Trying to edit and it's lagging out. I did not lower VT estimation after reading the above post, I raised it to 175

flyinfungi · 04/12/07, 2:47 PM

I would like to request if you could do a dps rotation with fireblast and scorch and an AB mixed in.

Something like this...
http://www.worldofwarcraft.com/info/...00000000000000

On the speradsheet it only shows an arcane blast spam for the AB cycle.

Vontre · 04/12/07, 2:52 PM

Hey Kalman, could you tell me how to insert contextual menus into the spreadsheet? It looks like a lot of people would like a cycle selector instead of just auto-select.