Vontre's Mage DPS Spreadsheet

◊ Vontre · 04/10/07, 6:03 PM

People keep requesting the url on my spreadsheet so I thought I'd make a new thread for easy access.

www.magegraf.com/mage_dps.zip

Any questions, complaints, or feature requests can be posted (and preferably reposted) here.

Armory Import
This feature only works in Excel 2000. I'm very sorry about this, but there's nothing I can do to fix it right now, excel refuses to input the source correctly in future versions. I'm leaving it in for users who may have that version of excel and have been using the feature.

WORKAROUND: If you use a view source on your armory page and copy the XML into the blue box, you can "hack" it to work. If you do this, it won't automatically update your information, but it is a quick way to get stats into the spreadsheet.

Yaltus · 04/11/07, 4:00 PM

This is partially related to the horrible way blizzard implements character sheet information, but I had some issues with figuring out the correct numbers to enter if you have taken the Mind Mastery talent.

I think that the character sheet displays the +damage from Mind Mastery not as spell damage, but individually adds it to your fire, frost, and arcane damage totals. I have been entering these numbers into the spreadsheet, despite the fact that I'm supposed to enter values pre-talents, because when I tested a 35/20/5 build versus my 41/20/0 build (5 points in improved frostbolt, since that wouldn't impact my arc/fire damage numbers), there didn't seem to be the change in dps I'd be expecting if Mind Mastery was being accounted for.

◊ Vontre · 04/11/07, 4:17 PM

Mind Mastery will definitely be added to your individual frost, fire, and arcane totals on the character sheet. I hadn't considered this and I'm at something of a loss for a simple and straightforward implementation to get around that.

Yaltus · 04/11/07, 4:46 PM

Originally Posted by Vontre

Mind Mastery will definitely be added to your individual frost, fire, and arcane totals on the character sheet. I hadn't considered this and I'm at something of a loss for a simple and straightforward implementation to get around that.

Perhaps just have people enter the total fire, frost, and arcane +damage totals from their character sheet into the three fields, rather than entering total spell damage, and then the additional bonus damage you have to the individual schools? Then note that those numbers account for Mind Mastery if you have the talent.

kelben · 04/11/07, 5:59 PM

Frost builds are broken in this version too... a 40/0/21 build tries to add in water elemental dps and seems to come up with very different numbers that your older spreadsheet

◊ Vontre · 04/11/07, 6:12 PM

Yeah, I noticed that in my working today.

Yaltus: The problem with that is if people want to adjust their talent specs for comparisons the information will be skewed. It has to be information from gear, not from the character sheet unforunately.

Yaltus · 04/11/07, 6:17 PM

Originally Posted by Vontre

Yaltus: The problem with that is if people want to adjust their talent specs for comparisons the information will be skewed. It has to be information from gear, not from the character sheet unforunately.

Totally overlooked that. I guess that's why you do the spreadsheet, and not me

Since you account for Arcane Mind if the talent build has that in it, couldn't you do the same thing on the spreadsheet? I don't mind doing a bit of math or adding all my gear totals without using the character sheet to make sure my stats are correctly inputted, but the way it stands right now I have to manually adjust my spell damage number in the spreadsheet to accurately compare 40/x builds.

pojo · 04/11/07, 6:21 PM

Very nice spreadsheet.

I was curious though if improved scorch was being taken into consideration because there is a box for winters chill but none for improved scorch. I was also unsure if this was taking into account raid buffs or not.

It would also be really cool if you could possibly add in something with lightening capcitator as I am very curious how it stacks up with different specs and what not.

Anyway thanks a lot very cool.

kelben · 04/11/07, 6:31 PM

Same I'm curious regarding the improved scorch debuff... are you assuming its always up there?

Oh and would it be possible to add in a box for the Spellfire set bonus? (Increases spelldmg by 7% of your total intell)

◊ Vontre · 04/11/07, 6:42 PM

New version 2.3 incoming - wait for the upload.

Major feature request added: damage totals based on encounter duration. This formula also uses an "oom casting" method to fill in remaining time left on the fight in case you run oom early. It then shows the result as total damage dealt for the encounter. It includes wanding regeneration from judgement of wisdom if that option is selected, as well as wand dps.

Problems with water elemental damage were fixed.

Consumable options were altered under game settings to account for the new consumable stacking rules.

Some settings for temporary effects like arcane power were added.

◊ Vontre · 04/11/07, 6:45 PM

Originally Posted by Yaltus

Totally overlooked that. I guess that's why you do the spreadsheet, and not me

Since you account for Arcane Mind if the talent build has that in it, couldn't you do the same thing on the spreadsheet? I don't mind doing a bit of math or adding all my gear totals without using the character sheet to make sure my stats are correctly inputted, but the way it stands right now I have to manually adjust my spell damage number in the spreadsheet to accurately compare 40/x builds.

I'm not sure what you mean. I definitely account for Mind Mastery. What I don't account for is someone counting the mind mastery buff on their character sheet as "school-specific" damage and adding it in themselves, as that will just duplicate the effect.

Don't use the character sheet to find extra your school-specific damage, in other words. I made a note of that in the new version. =)

◊ Vontre · 04/11/07, 6:47 PM

Originally Posted by kelben

Same I'm curious regarding the improved scorch debuff... are you assuming its always up there?

Oh and would it be possible to add in a box for the Spellfire set bonus? (Increases spelldmg by 7% of your total intell)

Just added this for 2.3.1

Scorch Debuff has always been assumed. I'll add an option for it to alleviate confusion.

Yaltus · 04/11/07, 7:04 PM

Originally Posted by Vontre

I'm not sure what you mean. I definitely account for Mind Mastery. What I don't account for is someone counting the mind mastery buff on their character sheet as "school-specific" damage and adding it in themselves, as that will just duplicate the effect.

Don't use the character sheet to find extra your school-specific damage, in other words. I made a note of that in the new version. =)

I just checked, I was apparently just wrong in thinking it didn't account for it. Not sure how I screwed it up, but sorry for any confusion.

nathanbp · 04/11/07, 9:20 PM

Maybe this is a stupid question, but I was wondering if you could explain the effect of the "Encounter Duration (sec.):" field in the spreadsheet? As far as I can tell, changing it has major effects on the time for all spell cycles, but not in any intuitive way to me. Thanks.

Genaro · 04/12/07, 2:52 AM

Thank you for this spreadsheet Vontre!

I Wanted to point out one thing i noticed, however: If I leave my Spelldamage field blank and use only School based bonuses the item comparison table is not able to compare properly. It will basically not compare anything in the spelldamage fields.

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