Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics

 
 
LinkBack Thread Tools
Old 04/12/07, 1:49 PM   #26
tedv
Observation: I am awesome
 
tedv's Avatar
 
Goblin Priest
 
Mal'Ganis
150 m/5 from Vampiric Touch is on the conservative side. With only 1000 +damage (obtainable without being a tailor and using only loot from 5 and 10 man instances) and curse of shadows, mind flay alone ticks for 600 DPS, which is 30 mana/sec, or 150 m/5. Once you factor in the damage from Shadow Word Pain and Vampiric Touch it's closer to 800 DPS, or 200 m/5. And going crazy with Mind Blast and Shadow Word Death brings it up to 1000 DPS, or 250 m/5.

United States Offline
Old 04/12/07, 2:31 PM   #27
Vontre
Mr. Sandman
 
Vontre's Avatar
 
Gnome Mage
 
Cenarion Circle
Combustion is its own topic altogether, and if I account for it I have to account for arcane power as well (averaged out). I'm currently running under the assumption that the total gain of these abilities over their 3 minute duration is, for the most part, negligible.

Aside from some fixes I've added what I think is a very much needed new feature: A talent spec comparison. I've included 3 raid-oriented talent builds with pretty much all the basic goodies: one for fire, arcane, and frost. The talent comparison will show total damage output from each build and tell you which is highest, for your given scenario.

Upload incoming, v2.3.5

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

United States Offline
Old 04/12/07, 2:35 PM   #28
Vontre
Mr. Sandman
 
Vontre's Avatar
 
Gnome Mage
 
Cenarion Circle
Trying to edit and it's lagging out. I did not lower VT estimation after reading the above post, I raised it to 175

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

United States Offline
Old 04/12/07, 2:47 PM   #29
flyinfungi
Piston Honda
 
flyinfungi's Avatar
 
Blood Elf Mage
 
Wyrmrest Accord
I would like to request if you could do a dps rotation with fireblast and scorch and an AB mixed in.

Something like this...
http://www.worldofwarcraft.com/info/...00000000000000

On the speradsheet it only shows an arcane blast spam for the AB cycle.

Offline
Old 04/12/07, 2:52 PM   #30
Vontre
Mr. Sandman
 
Vontre's Avatar
 
Gnome Mage
 
Cenarion Circle
Hey Kalman, could you tell me how to insert contextual menus into the spreadsheet? It looks like a lot of people would like a cycle selector instead of just auto-select.

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

United States Offline
Old 04/12/07, 3:42 PM   #31
Kalman
Super Macho Man
 
Kalman's Avatar
 
<>
Orc Shaman
 
No WoW Account
The most recent version I have from Vontre is uploaded.

Vontre:

Contextual menus are done via the Validation drop-down and the VLOOKUP function. The way the sheet is structured right now, it might be a little ugly; if you do a little rearranging though, it's easy enough to do contextual menuing via validation/vlookup. Check out the rogue spreadsheet if you want examples, or hold off until I get the gear page done; it'll use that method.

Melador> Incidentally, these last few pages are why people hate lawyers.
Viator> I really don't want to go all Kalman here.
Bury> Just imagine what the world would be like if you used your powers for good.

Clearly law school has done wonders for me.

United States Offline
Old 04/13/07, 2:23 AM   #32
Kalman
Super Macho Man
 
Kalman's Avatar
 
<>
Orc Shaman
 
No WoW Account
As promised, I have a first pass on a gear interface into Vontre's sheet.

I'm sure it has significant, major, horrifyingly wrong issues.

FIND THEM. Add pieces of gear. Tell me what's wrong/missing and Vontre and I will get it fixed. There's also a *lot* of modeling that isn't yet done, mostly for onhit type procs. I also model trinkets as averaged over their duration, which isn't really correct for a specified fight length, but we can fight with that later.

For now: have at it.

http://www.radiationnow.net/wow/beta/mage_dps_gear.ods (verified as working for OpenOffice)
http://www.radiationnow.net/wow/beta/mage_dps_gear.xls (might or might not work right in Excel)

United States Offline
Old 04/13/07, 5:50 AM   #33
kelben
Piston Honda
 
Draenei Death Knight
 
Ysera
My first thought was complicated... way too complicated ; / I've been using Irontygres's Theorycrafting for Mages program http://hosted.filefront.com/Irontygre - unforuantely it was never completed and theres mistakes through out the orginal item files... I've modded mine to reflect the correct values and added additional items...

However, i can't seem to get the menus to work in excel, but I'll play around in a bit with your update

Offline
Old 04/13/07, 9:11 AM   #34
Kalman
Super Macho Man
 
Kalman's Avatar
 
<>
Orc Shaman
 
No WoW Account
The menus may not work in Excel - OpenOffice doesn't seem to save validation information through to Excel formatted documents, which is annoying. I don't know how exactly I'd make it less complicated - it's got to handle gear and sockets and enchants, and dropdowns for each of those (if they were working) are the appropriate way.

Also, it throws a bunch of error: 502s on non-socketed items. These are just visual, they don't affect operation of the document.

Melador> Incidentally, these last few pages are why people hate lawyers.
Viator> I really don't want to go all Kalman here.
Bury> Just imagine what the world would be like if you used your powers for good.

Clearly law school has done wonders for me.

United States Offline
Old 04/13/07, 12:33 PM   #35
Vontre
Mr. Sandman
 
Vontre's Avatar
 
Gnome Mage
 
Cenarion Circle
Menus don't work in excel, this is a problem for me.

I have to get some actual work done today anyway, though =p

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

United States Offline
Old 04/14/07, 1:16 PM   #36
Wynna
Glass Joe
 
Human Rogue
 
Garona
Oh nice, I've been looking forward for the mage spreadsheet to start looking like the rogue one, that way I could make 2 or 3 changes of gear and see what would be the overall benefit instead of only knowing what is what isn't a single upgrade <3 Vontre

Edit: I also just got the latest version of the spreadsheet and it doesn't show any damage increase when I have Improved Scorch on the target btw.

Edit2: Another weird thing I noticed on this new version... I don't know, I'm getting the feeling +hit is not being as good and it used to show me it was, and I also lose like 100 dps from sheet 2.2 to this 2.3.5, what changes caused this exactly? (with obviously the same stats)

Last edited by Wynna : 04/14/07 at 2:21 PM.

Offline
Old 04/14/07, 3:33 PM   #37
Vontre
Mr. Sandman
 
Vontre's Avatar
 
Gnome Mage
 
Cenarion Circle
I fixed several bugs between those versions. Also, a non-confusing implementation of the scorch/wc values... I don't know. If you have the talent, it assumes it is up already. If not, it uses the settings to see if someone else is doing it for you.

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

United States Offline
Old 04/14/07, 5:14 PM   #38
Wynna
Glass Joe
 
Human Rogue
 
Garona
Oh ok! Thanks.

Another question, the haste rating thing added, I have a quag's eye so I should just go ahead and put 320 over there? Does it account for its hidden cooldown and all that though? Because I usually use an Icon of the Silver Crescent + Nelth tear, and I believe the the Icon is a lot better since you'll use it everytime you use combustion, which gives a bigger burst although I know there's not really a way to add that to the sheet. Thanks in advance =]

Offline
Old 04/14/07, 7:18 PM   #39
Vontre
Mr. Sandman
 
Vontre's Avatar
 
Gnome Mage
 
Cenarion Circle
No it's for modeling temporary effects. The spreadsheet has no idea about cooldowns or proc rates, it just shows dps while you have [x] haste rating.

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

United States Offline
Old 04/16/07, 11:12 AM   #40
fr0d0b0ls0n
Von Kaiser
 
fr0d0b0ls0n's Avatar
 
Night Elf Druid
 
Sanguino (EU)
I was thinking in trying this build:

http://www.worldofwarcraft.com/info/...10230010040000

The idea behind it is Ice Shard + Spell Power, for a 150% bonus crit damage, with Winter Chill, A. Instability and high crit items. But this sheet doesnt seem to stack Ice Shard with Spell Power... is a bug, or I'm wrong?

Is my first post here... i hope i havent done anything wrong

Offline
Old 04/16/07, 11:21 AM   #41
Kalman
Super Macho Man
 
Kalman's Avatar
 
<>
Orc Shaman
 
No WoW Account
Originally Posted by fr0d0b0ls0n View Post
I was thinking in trying this build:

http://www.worldofwarcraft.com/info/...10230010040000

The idea behind it is Ice Shard + Spell Power, for a 150% bonus crit damage, with Winter Chill, A. Instability and high crit items. But this sheet doesnt seem to stack Ice Shard with Spell Power... is a bug, or I'm wrong?

Is my first post here... i hope i havent done anything wrong
Shards + Spellpower isn't a 150% crit bonus for a 250% crit, it's 250% of base crit bonus (50%) for 125% crit bonus, or 225% crits.

And I just checked the sheet, it seems to be calculating crit bonus correctly.

Melador> Incidentally, these last few pages are why people hate lawyers.
Viator> I really don't want to go all Kalman here.
Bury> Just imagine what the world would be like if you used your powers for good.

Clearly law school has done wonders for me.

United States Offline
Old 04/16/07, 2:24 PM   #42
fr0d0b0ls0n
Von Kaiser
 
fr0d0b0ls0n's Avatar
 
Night Elf Druid
 
Sanguino (EU)
Originally Posted by Kalman View Post
Shards + Spellpower isn't a 150% crit bonus for a 250% crit, it's 250% of base crit bonus (50%) for 125% crit bonus, or 225% crits.

And I just checked the sheet, it seems to be calculating crit bonus correctly.

I know that, it seems i was looking a wrong place in the Calculations tab, my fault. It works perfectly. But that build dont have the raw power of another, more common, builds.

Thanks for your help.

Offline
Old 04/17/07, 2:04 PM   #43
Kalman
Super Macho Man
 
Kalman's Avatar
 
<>
Orc Shaman
 
No WoW Account
Thanks to the efforts of Maklar there's an Excel version of the sheet with functioning gear dropdowns.

http://www.radiationnow.net/wow/beta/mage_dps_gear.xls

Melador> Incidentally, these last few pages are why people hate lawyers.
Viator> I really don't want to go all Kalman here.
Bury> Just imagine what the world would be like if you used your powers for good.

Clearly law school has done wonders for me.

United States Offline
Old 04/17/07, 2:50 PM   #44
Leto
King Hippo
 
Leito
Troll Rogue
 
No WoW Account
Good stuff... could you add Seal of the Exorcist in the next push?

Rogue at heart.

Offline
Old 04/17/07, 4:18 PM   #45
Vontre
Mr. Sandman
 
Vontre's Avatar
 
Gnome Mage
 
Cenarion Circle
Yeah, we're going to be working on a somewhat major upgrade that will include a new features, most notably the gear selector, we'll be refining it and working it into the main sheet more elegantly and such. It will also be updated for patch 2.1 with all the talent/consumable changes and such.

This might take about a week's time or so.

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

United States Offline
Old 04/20/07, 7:48 AM   #46
Praanz
Piston Honda
 
Praanz's Avatar
 
Human Mage
 
Auchindoun (EU)
Edit - I just DL'ed the latest version ...and this was already implemented

Raiding is full of challenge. Sometimes there is fire.

You have not to move out of the fire, it will be nerfed soon.

Offline
Old 04/20/07, 1:55 PM   #47
Reklaw
Glass Joe
 
Reklaw's Avatar
 
Gnome Mage
 
<ROC>
Shadowsong
In playing with the itemized sheet I noticed that spellpower ring enchant was coming up at 15, instead of 12. Otherwise it's looking great, thanks for the work guys.

Offline
Old 04/20/07, 5:54 PM   #48
Micah
Von Kaiser
 
Draenei Shaman
 
Tichondrius
I just downloaded your spreadsheet and is very interesting and enlightening when it comes to certain gear choices. I really appreciate the effort put forth to create this and share it with others.

I do have one question regarding the +hit cap that is not entirely specific to your spreadsheet but you seem to have a deeper understanding of the mage class than most so you would be a good person to ask. :P

I noticed today while on the armory website that when I hovered over my intellect tooltip it showed that affects +hit to a certain degree. In my case (armory link+motw) I have 544 int at the time which tells me I have an added +6.59% to hit. My hit rating is 106 (8.4%) and I have elemental precision.

6.59 + 8.4 + 3 = 17.99%

Can this be right? Am I really 2% passed the cap or is there something I dont know? For the spreadsheet, I can increase my +hit rating to +164 before the numbers cap but according to the numbers I observed above I should be able to lose some +hit without affecting much, if anything.

Offline
Old 04/20/07, 6:01 PM   #49
Tempestra
Don Flamenco
 
Draenei Mage
 
Lightbringer
Int doesn't affect spell hit.

You probably misread +6.59 to crit as +6.59 to hit.

That, or you just found an armory bug =)

Offline
Old 04/20/07, 6:02 PM   #50
Vontre
Mr. Sandman
 
Vontre's Avatar
 
Gnome Mage
 
Cenarion Circle
Probably an armory bug. It should be affecting crit, not hit.

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

United States Offline
 

Go Back   Elitist Jerks » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mage DPS Spreadsheet by Yes Yes Class Mechanics 11 07/12/07 10:35 AM
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