Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Public Discussion » Class Mechanics

 
 
LinkBack Thread Tools
Old 04/26/07, 2:31 PM   #1
Yes
Bald Bull
 
Yes's Avatar
 
Tauren Druid
 
Dragonmaw
Mage DPS Spreadsheet by Yes

Hio. I figured I'd finally make a post with this.
Updated it for 2.1
Fixed a bug where crit rating was not doing anything (!!).

It looks something like this:


Input data in green area!
I am eager to hear feedback and suggestions

Enjoy.
Attached Files
File Type: xls mage v1.21.0-3.xls (59.5 KB, 1855 views)

Last edited by Yes : 06/11/07 at 3:43 AM.

Offline
Old 04/26/07, 3:05 PM   #2
Leto
King Hippo
 
Leito
Troll Rogue
 
No WoW Account
Hmm, I think you posted this before in the TBC Mage Theorycrafting thread. Can't this information be found already in Vontre's spreadsheet? Is there anything different that yours has to add?

Rogue at heart.

Offline
Old 04/26/07, 5:03 PM   #3
Tempestra
Don Flamenco
 
Draenei Mage
 
Lightbringer
Could you throw in some rotations into the mix?

Vontre's spreadsheet focuses on ending fights with no mana and over-emphasizes the ability to dump mana via arcane blasts.

If this can be a straight "what DPS can you attain" spreadsheet that you can sustain for X seconds, and it's very easy to use (I like the drop-down menus a lot), then it oculd be helpful.

Offline
Old 04/26/07, 6:01 PM   #4
Yes
Bald Bull
 
Yes's Avatar
 
Tauren Druid
 
Dragonmaw
Leto: I took a look at the spreadsheet of Vontre's, and while you must note that I build my tool without knowledge of existence and without intention to compete, complete, or anything of that sort, I personally think that my simpler and easier to use tool will give accurate results on expected real world dps.

All someone has to do is put in their overall stats into the corresponding boxes, put in the talent tree they wish to see and adjust a few modifiers for what their raid group has or does not have, and they are given what I believe a very accurate gauge of various statistics of dps, dpm, etc for a number of chaincast spells, and soon every realistic rotation. Not to mock Vontre, but I don't think that apple was shunned for releasing an ipod, even though people could already carry a boombox and a headset with them. I don't think it is wrong for me to release my own interpretation on theorycrafting mages even if that work has been done differently and perhaps more extensively already. Perhaps someone would enjoy using my interface more so.

Tempestra: I am going to implement these:
Chain fireball with keeping scorch up
Chain fireball with fireblast
Chain fireball with keeping scorch up and fireblast

Some sort of AB for threat sensitive fights (ab -threat is superior)

If I get to it I might play around with AM, but realistically speaking the above four rotations cover anything else, other things will do less dps and dpm (Like say, frostbolt/fireblast) and are not really worth putting in over implementing other things.

Offline
Old 04/27/07, 8:22 AM   #5
Leto
King Hippo
 
Leito
Troll Rogue
 
No WoW Account
Yes, I'm sorry my comments came across as shunning, I meant nothing of the sort. I was just curious what the goal was, as it is generally more productive to build upon the work of others rather than start from scratch.

Improved usability is good. I'll try to mess around with it and see if I have any suggestions, looks good so far though.

Edit:
Messed around with it a bit, entered my stats and buffs from Gruul last night and it came out with a 3300 avg fireball, which was about right. Seems pretty accurate to me.

Last edited by Leto : 04/27/07 at 8:45 AM.

Rogue at heart.

Offline
Old 06/02/07, 2:13 AM   #6
Yes
Bald Bull
 
Yes's Avatar
 
Tauren Druid
 
Dragonmaw
I thought I'd give this a bump as I fixed a major bug and updated for the new patch.


Offline
Old 06/03/07, 8:24 AM   #7
Carnivean
Piston Honda
 
Carnivean's Avatar
 
Carni
Undead Mage
 
No WoW Account (EU)
Very nice work, but I have one major bug...

On my of the dropdown Fields the Selection Possibilities are messed up...

For example for the 2/5 tier 5 Bonus you can either select 1 or 01. Februar....
Would be cool if you could fix it, or just say which values we have to insert, so that we could fix it ourselves.

BTW I have Excel 2003, maybe its based on different office version....

Germany Offline
Old 06/11/07, 3:41 AM   #8
Yes
Bald Bull
 
Yes's Avatar
 
Tauren Druid
 
Dragonmaw
I use excel 2003 as well and I do not see that bug. However, can you try sending me the file that is bugged so I could take a look?

Fow now I will enter accepted values in the comments: new file
Attached Files
File Type: xls mage v1.21.0-3.xls (59.5 KB, 1542 views)

Last edited by Yes : 05/11/09 at 8:31 PM.


Offline
Old 06/11/07, 5:05 AM   #9
nubb3y
Von Kaiser
 
Undead Warrior
 
Hakkar
so whats the most dps you've managed to get from this, with the best possible gear? i have no clue what the best gear is, since i don't play a mage ;/

Offline
Old 06/11/07, 8:21 AM   #10
Yes
Bald Bull
 
Yes's Avatar
 
Tauren Druid
 
Dragonmaw
With around 1100 spelldamage unbuffed, and a raid setup giving you most possible buffs/debuffs you could want and .25 latency and all consumables but no worldbuffs you could do around 1600 dps sustained.


Offline
Old 07/10/07, 2:54 PM   #11
[DRF]Solmyr
Von Kaiser
 
Undead Mage
 
Spirestone
Wow, great work... this is very nice and tidy indeed!

Offline
Old 07/12/07, 10:35 AM   #12
Logun
Banned
 
Human Mage
 
Dunemaul
I tought you might find this calculator interesting.

Lhivera's Theorycraft Script

Offline
 

Go Back   Elitist Jerks » Public Discussion » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vontre's Mage DPS Spreadsheet Vontre Class Mechanics 550 05/25/08 8:33 PM
Mage spreadsheet updated for 2.0 Hamlet Public Discussion 14 12/20/06 9:59 AM
Mage DPS Spreadsheet Hamlet Public Discussion 32 09/15/06 6:20 PM
Mage Spreadsheet, updated Hamlet Public Discussion 52 09/06/06 9:49 PM
Frost Mage Spreadsheet Hamlet Public Discussion 37 08/06/06 7:43 PM