Vontre's Mage DPS Spreadsheet

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

The spreadsheet has been deprecated as of WoW patch 3.0. Please visit www.magegraf.com for my new theorycrafting tool, Vontre's Magegraf!

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.