Mage DPS Spreadsheet - Page 2

Maklar · 09/15/06, 12:24 PM

Yeah, I had a brain lapse and was thinking ~30 int = 1 crit instead of 59.5

Does this take into account race ( <3 Gnome)?

Also, I believe using a mana gem triggers GC. Does it factor that in? *

*Clarify: What I actually mean is that I usually use it when I'm on GC (so after NW proc, or Fireblast). That way the time associated with using the command does not impact DPS. So assuming .27sec lag it would need to calculate using a gem/pot as .27sec instead of 0. Does it do this?

snape · 09/15/06, 12:26 PM

Did you find out if you had that rounding error or if your code was wrong?

I'm not about to pore over Excel here at work...especially since half my time is using Excel anyways.

:(

snape · 09/15/06, 12:27 PM

Originally Posted by Maklar

Yeah, I had a brain lapse and was thinking ~30 int = 1 crit instead of 59.5

Does this take into account race ( <3 Gnome)?

Also, I believe using a mana gem triggers GC. Does it factor that in?

Using Mana Gems does NOT trigger the global CD. That's the real beauty of them - Mana Potions are the same way. You can hit gem and then fireball right away (I use hotkeys to do so).

Maklar · 09/15/06, 12:28 PM

Yeah, I edited my statement to clarify what I meant. I'm sure you could macro it much like a combustion/fireball macro to help nullify the lag but I do not do so.

Chimp · 09/15/06, 12:28 PM

Originally Posted by Arawethion

Not modelled:

Cooldowns.
Rolling Ignites...

I once had a pop at modelling rolling ignites, and failed miserably. I wouldn't recommend trying ;D

• Hamlet · 09/15/06, 12:32 PM

Originally Posted by Chimp

Originally Posted by Arawethion

Not modelled:

Cooldowns.
Rolling Ignites...

I once had a pop at modelling rolling ignites, and failed miserably. I wouldn't recommend trying ;D

Check the threads I linked in OP . . .

• Hamlet · 09/15/06, 12:34 PM

Originally Posted by Maklar

Yeah, I had a brain lapse and was thinking ~30 int = 1 crit instead of 59.5

Does this take into account race ( <3 Gnome)?

Also, I believe using a mana gem triggers GC. Does it factor that in? *

*Clarify: What I actually mean is that I usually use it when I'm on GC (so after NW proc, or Fireblast). That way the time associated with using the command does not impact DPS. So assuming .27sec lag it would need to calculate using a gem/pot as .27sec instead of 0. Does it do this?

Human only, for now, sorry.

Mana Gems don't take any time, although I have forgotten to take the 8sec off for Evocation, thanks for reminding me. Also need to do that to model Greater Dreamless Sleep.

snape · 09/15/06, 12:40 PM

Race? It is to laugh. Just look at your character screen, and put your Int in. No modifications have to be made based on race.

• Hamlet · 09/15/06, 12:44 PM

Originally Posted by snape

Race? It is to laugh. Just look at your character screen, and put your Int in. No modifications have to be made based on race.

Well, excapt that it takes in your total Int bonus from gear, rather than your actual Int from the character screen. Kind of annoying, but it was the easiest way to handle Kings.

• frmorrison · 09/15/06, 12:49 PM

He could have included the 5% more spirit for humans, since he plays one. That bonus adds up.

Gnomes have the 5% more int, but I don' t believe it stacks with BoK.

Anyway, since you have to enter stats, race doesn't matter (assuming the spirit bonus is counted as a buff)

snape · 09/15/06, 12:55 PM

Originally Posted by Arawethion

Originally Posted by snape

Race? It is to laugh. Just look at your character screen, and put your Int in. No modifications have to be made based on race.

Well, excapt that it takes in your total Int bonus from gear, rather than your actual Int from the character screen. Kind of annoying, but it was the easiest way to handle Kings.

Of course it takes your Int bonus from gear. Your raw int (with gear) +5%, is shown on your character screen. o.O

I don't get your statement.

I have, like, 180 spirit or something, and that is shown on the character screen, and includes the 5%.

Maklar · 09/15/06, 1:50 PM

Originally Posted by Arawethion

Mana Gems don't take any time

Sure, in a lag free world they do not. However, if you are going to calculate lag into spellcasting you should look into using it for pots/gems as well. Much like Presence of Mind/Arcane Power/Combustion/ToEP/etc do not take any casting time, they are still affected by your ping/reaction time. Does it make a huge effect? No, but to be realistic it is something that should be considered. You would want to make sure you add the lag time onto Evocation as well of course.

snape · 09/15/06, 2:43 PM

Originally Posted by Maklar

Originally Posted by Arawethion

Mana Gems don't take any time

Sure, in a lag free world they do not. However, if you are going to calculate lag into spellcasting you should look into using it for pots/gems as well. Much like Presence of Mind/Arcane Power/Combustion/ToEP/etc do not take any casting time, they are still affected by your ping/reaction time. Does it make a huge effect? No, but to be realistic it is something that should be considered. You would want to make sure you add the lag time onto Evocation as well of course.

mmkay, so if you Evocate once and Mana Gem twice in a 6 minute fight, for me that 0.1 seconds (normal ping) x 3 = 0.3 seconds, so just add that onto the end and divide. Your result will be so close to the one listed that it's practically negligible.

Maklar · 09/15/06, 3:27 PM

Yes, I mentioned that fact but a simulation should be as close to reality as possible. Also, not everyone has 100 ms ping times. Due to connection/hardware issues it is not unreasonable for someone to have 1000 ms ping times.

Based off his spreadsheet it calculates you using Evocation once, Mana Gems twice, and Potions twice.

Based off the given data average DPS = 642 for a 300 second fight so that figures out to 192,600 damage.

Sure if your ping is 100 ms that is a minor change 192,600 / 300.5 = 641 or so. A drop of 1 DPS which is minor. But if your ping is 1000 ms you change to 192,600 / 305 = 631.5 or so. A 10.5 drop in DPS is not negligible in my opinion.

*Edit: Fixed case inconsistency in DPS/dps

snape · 09/15/06, 4:06 PM

Originally Posted by Maklar

Yes, I mentioned that fact but a simulation should be as close to reality as possible. Also, not everyone has 100 ms ping times. Due to connection/hardware issues it is not unreasonable for someone to have 1000 ms ping times.

Based off his spreadsheet it calculates you using Evocation once, Mana Gems twice, and Potions twice.

Based off the given data average DPS = 642 for a 300 second fight so that figures out to 192,600 damage.

Sure if your ping is 100 ms that is a minor change 192,600 / 300.5 = 641 or so. A drop of 1 DPS which is minor. But if your ping is 1000 ms you change to 192,600 / 305 = 631.5 or so. A 10.5 drop in DPS is not negligible in my opinion.

*Edit: Fixed case inconsistency in DPS/dps

If you have 1k ping on even a semi-regular basis, something is wrong.

Not even our Australian guild members get over 500 ms on their worst days.