Elitist Jerks
Register
Blogs
Urban Rivals
Forums
New Posts


Go Back   Elitist Jerks > Public Discussion > Class Mechanics
Elitist Jerks Login

gamerDNA Login

Welcome to Elitist Jerks
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!

If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.

Reply
 
LinkBack (38) Thread Tools
Old 04/26/07, 3:31 PM   38 links from elsewhere to this Post. Click to view. #1
Yes
Brutal Gladiator
 
Yes's Avatar
 
Human Druid
 
Shattered Hand
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, 1168 views)

Last edited by Yes : 06/11/07 at 4:43 AM.
 
User is offline.
Reply With Quote
Old 04/26/07, 4:05 PM   #2
Leto
The Duke
 
Night Elf Rogue
 
Shattered Hand
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.
 
User is offline.
Reply With Quote
Old 04/26/07, 6:03 PM   #3
Tempestra
Professional Cat Herder
 
Night Elf Druid
 
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.
 
User is offline.
Reply With Quote
Old 04/26/07, 7:01 PM   #4
Yes
Brutal Gladiator
 
Yes's Avatar
 
Human Druid
 
Shattered Hand
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.
 
User is offline.
Reply With Quote
Old 04/27/07, 9:22 AM   #5
Leto
The Duke
 
Night Elf Rogue
 
Shattered Hand
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 9:45 AM.

Rogue at heart.
 
User is offline.
Reply With Quote
Old 06/02/07, 3:13 AM   #6
Yes
Brutal Gladiator
 
Yes's Avatar
 
Human Druid
 
Shattered Hand
I thought I'd give this a bump as I fixed a major bug and updated for the new patch.

 
User is offline.
Reply With Quote
Old 06/03/07, 9:24 AM   #7
Carnivean
Space for rent, call 11833 for more information
 
Carnivean's Avatar
 
Undead Mage
 
Gul'dan (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....
 
User is offline.
Reply With Quote
Old 06/11/07, 4:41 AM   #8
Yes
Brutal Gladiator
 
Yes's Avatar
 
Human Druid
 
Shattered Hand
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, 1041 views)

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

 
User is offline.
Reply With Quote
Old 06/11/07, 6: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 ;/
 
User is offline.
Reply With Quote
Old 06/11/07, 9:21 AM   #10
Yes
Brutal Gladiator
 
Yes's Avatar
 
Human Druid
 
Shattered Hand
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.

 
User is offline.
Reply With Quote
Old 07/10/07, 3:54 PM   #11
[DRF]Solmyr
Von Kaiser
 
Undead Mage
 
Spirestone
Wow, great work... this is very nice and tidy indeed!
 
User is offline.
Reply With Quote
Old 07/12/07, 11:35 AM   #12
Logun
Banned
 
Human Mage
 
Dunemaul
I tought you might find this calculator interesting.

Lhivera's Theorycraft Script
 
User is offline.
Reply With Quote
Reply

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 9:33 PM
Mage spreadsheet updated for 2.0 Arawethion Public Discussion 14 12/20/06 10:59 AM
Mage DPS Spreadsheet Arawethion Public Discussion 32 09/15/06 7:20 PM
Mage Spreadsheet, updated Arawethion Public Discussion 52 09/06/06 10:49 PM
Frost Mage Spreadsheet Arawethion Public Discussion 37 08/06/06 8:43 PM