Vontre's Mage DPS Spreadsheet - Page 13

Korrigan · 10/16/07, 7:15 PM

I would like to see the HS/BT epic gems and the new PTR spellhaste gear added.
Does 2.7.2.1 include the changed (PTR) mage talents?

Qbert · 10/18/07, 5:19 PM

May want to update the consumables tab to use 80 dmg for flasks rather than 70

◊ Vontre · 10/22/07, 5:43 PM

There's going to be a big update for 2.3, however I don't currently have time to add in all the ZA loot. If someone wants to do that and send it my way (matt.siege@gmail.com) that'd be great. I wrote the rest of the spreadsheet specifically for easy, quick updates, and I just don't have time anymore to input a huge list of gear.

Edit: currently available version is for live realms.

zurmagus · 10/22/07, 7:12 PM

Would anyone be intrested in a full DPS simulator as opposed to a spreadsheet?

[DRF]Solmyr · 10/23/07, 12:38 PM

Originally Posted by zurmagus

Would anyone be intrested in a full DPS simulator as opposed to a spreadsheet?

I believe there are full simulators around, but they require some extra knowledge to use over simple excel. I believe there is a demand for a dumbed down version.

I would also like to know, how long are most of the fights in BT/Hyjal? Meaning, how sustainable should I attempt to make my character?

◊ Vontre · 10/23/07, 1:05 PM

Seems like 5 minutes is a good mark.

zurmagus · 10/23/07, 1:12 PM

Originally Posted by [DRF]Solmyr

I believe there are full simulators around, but they require some extra knowledge to use over simple excel. I believe there is a demand for a dumbed down version.

This is intended to be a program that anyone could use. Just enter some stats and tell it to simulate a certain amount of damage. Simulator then casts spells until that total damage is reached. Each time a spell is cast, the simulator checks for procs, rolls damage, etc. In the end you get a DPS report that currently looks something like this:

Inputs
=======================
Spell Damage: 1000
Crit Rate: 35%
Hit Rate: 16%

DPS Report
=======================
Damage: 50001924 Time: 37284s
Ideal DPS: 1341.11
Fireball - 12680 casts

-----------------------------------------
Hits: 8170 64.4% Max: 3292
Crits: 4392 34.6% Max: 6914
Resists: 118 0.9%

[DRF]Solmyr · 10/23/07, 1:23 PM

Originally Posted by zurmagus

This is intended to be a program that anyone could use. Just enter some stats and tell it to simulate a certain amount of damage. Simulator then casts spells until that total damage is reached. Each time a spell is cast, the simulator checks for procs, rolls damage, etc. In the end you get a DPS report that currently looks something like this:

Inputs
=======================
Spell Damage: 1000
Crit Rate: 35%
Hit Rate: 16%

DPS Report
=======================
Damage: 50001924 Time: 37284s
Ideal DPS: 1341.11
Fireball - 12680 casts

-----------------------------------------
Hits: 8170 64.4% Max: 3292
Crits: 4392 34.6% Max: 6914
Resists: 118 0.9%

I'm sorry, did I miss a link somewhere? I would like to see this script. Is it anything like Lhivera's Theorycraft-o-matic?

◊ Vontre · 10/23/07, 1:27 PM

Originally Posted by zurmagus

This is intended to be a program that anyone could use. Just enter some stats and tell it to simulate a certain amount of damage. Simulator then casts spells until that total damage is reached. Each time a spell is cast, the simulator checks for procs, rolls damage, etc. In the end you get a DPS report that currently looks something like this:

Inputs
=======================
Spell Damage: 1000
Crit Rate: 35%
Hit Rate: 16%

DPS Report
=======================
Damage: 50001924 Time: 37284s
Ideal DPS: 1341.11
Fireball - 12680 casts

-----------------------------------------
Hits: 8170 64.4% Max: 3292
Crits: 4392 34.6% Max: 6914
Resists: 118 0.9%

Wait, are you talking about distributing a full C program? Or a web utility? I don't think the former would be advisable, no offense but we don't know you and that could very easily be a keylogger.

You need to be less eager here. Of course people are interested in a simulator, but you haven't shown us anything yet. Do you have a beta ready to distribute, or source code you'd like reviewed? Go ahead and post that in one of the mage threads when you're ready.

zurmagus · 10/23/07, 2:29 PM

Just posted my thread:

[Mage] DPS Simulator

Originally Posted by Vontre

Wait, are you talking about distributing a full C program? Or a web utility? I don't think the former would be advisable, no offense but we don't know you and that could very easily be a keylogger.

It's a full C++ program.

I posted both the source and the executable so if people don't trust it they can read the code build it themselves.

You need to be less eager here. Of course people are interested in a simulator, but you haven't shown us anything yet. Do you have a beta ready to distribute, or source code you'd like reviewed? Go ahead and post that in one of the mage threads when you're ready.

I'm not trying to be over eager here, don't know where that came from.

I made this tool about 3 months ago, before quitting WoW for a while. Now that I'm playing again, I'm interested in developing it further but I don't have as much free time as I did before. So as I said above, the source code is being made available and I'm hoping there are some other programmers out there interested in the idea. I am planning to post some documentation on the code as well. It is a decently large object-oritented project so I'm sure some of my design decisions will need explanation.

Anyway feel free to check it out and tell me what you think.

zurmagus · 10/23/07, 2:36 PM

Originally Posted by [DRF]Solmyr

I'm sorry, did I miss a link somewhere? I would like to see this script. Is it anything like Lhivera's Theorycraft-o-matic?

See my pervious post for a link to the thread. The source code is included.

AFAIK, it is not like Lhivera's Theorycraft-o-matic.

What makes my simulator different is that it runs through a spell casting loop, making crit/hit checks, rolling damage, and triggering procs for each spell cast. It keeps a running total of the time needed, damage done, and number of spells cast (among other things) to produce some valuable DPS statistics.

Vand1 · 10/26/07, 2:36 PM

I have searched this thread but have been unable to find an answer to my question.

The spreadsheet is quite detailed, including things as detailed as the gnome racial and whether you've got malediction. I am surprised, therefore, that there is no check-box asking whether you have a draenei in your group. So that brings up two questions.

First, is my understanding correct that having a draenei caster in your group (I've always got a draenei shadow priest in mine) is like adding ~12 spell hit rating, thereby making the hit cap ~152 for firespec, rather than 164?

Second, assuming my understanding in the first question is correct, is there an easy workaround to account for this? I simply added +12 hit to my wand on the itemdb sheet, since I am not likely to be switching it out any time soon. But if there is a simpler/better/more accurate way to do it, I'd love to hear it.

◊ Vontre · 10/26/07, 8:20 PM

Originally Posted by Vand1

I have searched this thread but have been unable to find an answer to my question.

The spreadsheet is quite detailed, including things as detailed as the gnome racial and whether you've got malediction. I am surprised, therefore, that there is no check-box asking whether you have a draenei in your group. So that brings up two questions.

First, is my understanding correct that having a draenei caster in your group (I've always got a draenei shadow priest in mine) is like adding ~12 spell hit rating, thereby making the hit cap ~152 for firespec, rather than 164?

Second, assuming my understanding in the first question is correct, is there an easy workaround to account for this? I simply added +12 hit to my wand on the itemdb sheet, since I am not likely to be switching it out any time soon. But if there is a simpler/better/more accurate way to do it, I'd love to hear it.

This would be correct. I can add a box for it, just hadn't occured to me.

◊ Vontre · 10/30/07, 7:36 PM

Edit: ok had a little version scare, thought I lost all my work. It's up. I'm tired. Here are changes:

TLC nerf
MSD nerf
fireball/frostbolt buff
New ZA gear, trinket is modeled
casting latency defaulted to zero

I'm sure I forgot something.

[DRF]Solmyr · 11/02/07, 3:15 AM

Vontre,

In "Vontre's Mage DPS v2.7.3", when I toggle "Improved Scorch on Target," the Build Comparison Fire DPS doesn't change, but the Arcane DPS goes up/down 125 DPS. Is there something I'm missing?

◊ Vontre · 11/02/07, 3:17 AM

Originally Posted by [DRF]Solmyr

Vontre,

In "Vontre's Mage DPS v2.7.3", when I toggle "Improved Scorch on Target," the Build Comparison Fire DPS doesn't change, but the Arcane DPS goes up/down 125 DPS. Is there something I'm missing?

I'll take a look at this tomorrow.

Roywyn · 11/02/07, 8:36 AM

Originally Posted by [DRF]Solmyr

Vontre,

In "Vontre's Mage DPS v2.7.3", when I toggle "Improved Scorch on Target," the Build Comparison Fire DPS doesn't change, but the Arcane DPS goes up/down 125 DPS. Is there something I'm missing?

Check the the Calculation tab, cells A642 to C652.

With an Arcane spec and Imp. Scorch in the raid, fireball spam is better than arcane missile spam. Without Imp. Scorch, fireball damage goes down, and may or not be lower than arcane missile spam.

That's just dumb for a spec, really ...

Edit:
A huge

for you, Vontre, keeping all the work and this awesome sheet up.

Searix · 11/03/07, 7:59 AM

Woot, new 2.3 chaotic data too plz

Gnag · 11/04/07, 4:50 AM

I cannot find the darkmoon card: wrath in the Trinket option in the gear. Is it normal and intended or I'm a looking at the wrong place?

Roywyn · 11/04/07, 7:03 AM

Originally Posted by Gnag

I cannot find the darkmoon card: wrath in the Trinket option in the gear. Is it normal and intended or I'm a looking at the wrong place?

Just use [Eye of the Beast] instead, they are pretty similar in power ...

Myrdinn · 11/04/07, 8:47 AM

Thanks for your follow up Vontre !
This new version is nice

Just a little point, you are still using Spirit to improve Evocation.
Evocation 2.3 is not in and Int during evoc should replace spirit.

◊ Vontre · 11/05/07, 5:55 PM

Originally Posted by Myrdinn

Thanks for your follow up Vontre !
This new version is nice

Just a little point, you are still using Spirit to improve Evocation.
Evocation 2.3 is not in and Int during evoc should replace spirit.

Yeah I realized that after I posted but didn't care quite enough to post a hotfix.

I'll get it worked out in the next push

as well as the "better" CSD calculations.

Chentoka · 11/06/07, 11:02 AM

Hi Vontre,

Would you be able to add Moonkin Aura to the buff options please? We seem to switch between being supported by a moonkin druid and an elemental shaman; sometimes with both if we've got mainly affliction warlocks (or if me and the Destro 'lock get left in charge of group assignments and feel like some comedy crit rates).

Also the Band of Eternity names need fixing in the same way that you sorted Violet Signet out; I emailed you my modded version of v2.7.2.1 where I'd done those names so feel free to cannibalise it.

Just to echo what others have said, this sheet is awesome and I can't thank you enough for all of the work you've put in to it. If you're ever in the UK I'll buy you a pint!

Copernicus · 11/07/07, 1:07 PM

Originally Posted by Vontre

Yeah I realized that after I posted but didn't care quite enough to post a hotfix.

I'll get it worked out in the next push

as well as the "better" CSD calculations.

Assuming 1100 damage and capped hit, at what crit percentage does CSD overtake MSD (for deep fire and deep frost)? And at the equilibrium point, which one scales better with more damage?

◊ Vontre · 11/07/07, 5:09 PM

I just uploaded a fix for the Chaotic Skyfire Diamond.

v2.7.3.1