Vermis

is it just me who's having problems with getting builds to the right spot, for some unknown reason it doesnt recognise 10/48/3 at all. Which is a bit annoying and weird.

Tested it a bit more and it doesnt show the point allocation to any build at all. Nor it adds the talents into dps calculations.

 

◊ Vontre

Are you using links from the official worldofwarcraft.com talent calculator and not wowhead?

www.magegraf.com

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

"We agree with Communism." - Greg Street 2009

 

Stirius

Did you set "Manual Talent Entry" to "no" on page 4 ("Talents")?

 

Vermis

manual entry was causing it, thanks for the tip . Seems like it was on "yes" by default

 

Asherett

I discovered a few more missing items:

Gem missing: Potent Flame Spessarite (+4 dmg / +3 crit, red/yellow)
Ring missing: Band of the Guardian (http://wow.allakhazam.com/db/item.html?witem=29320)

Excellent resource, by the way!

 

Drully

Thx, great spread sheet!!!

If you like, you could update the frobos, you have wrong/old stats there, the new are:

Frostbolt(13): 661
Frostbolt(10): 485,5
Frostbolt(9): 401,5

EDIT:

I wanted to look up my frobo damage on your calc sheet and found the "hit damage" line.
The shown number is around 10% higher then my frobo realy hits.
Testing brings up around 1300 damage, calculation with the known formulas 1333,3, but your hit damage line comes up with 1448,5...
I triple checked my input into the sheet..., any idea where the diffrence may come from?

I guess this signature will remind me of...

 

◊ Vontre

My bad there, I must've forgotten to default everything before we uploaded again ><

www.magegraf.com

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

"We agree with Communism." - Greg Street 2009

 

◊ Vontre

Curse of Elements

www.magegraf.com

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

"We agree with Communism." - Greg Street 2009

 

Drully

Oh, ok, I thought that would be "hit damage after debuffs"

Forgot talent is in tool tip included...:

So the real new stats are:

Frostbolt(13): 655
Frostbolt(10): 446
Frostbolt(9): 368

I guess this signature will remind me of...

 

Øystein

Great sheet.

A couple of items I'm missing:

trinket:
Oculus of the Hidden Eye (http://www.wowhead.com/?item=26055)

Hat:
Evoker's Helmet of Second Sight (http://www.wowhead.com/?item=31104)

Boots (don't laugh!):
Ringo's Blizzard Boots (http://www.wowhead.com/?item=19438)

Offhand:
The Saga of Terokk (http://www.wowhead.com/?item=29330)

Wand:
Nethekurse's Rod of Torment (http://www.wowhead.com/?item=25806)

Cheers
Oystein

 

Insurgence

I want to compliment you on the massive amount of work put into this spreadsheet and how much it helps us out.

I know that serveral ppl have asked if improved scorch is taken into account in the calculations however I got some unexpected results and would like some guidance.

I entered the spell sequences

Scorch, Scorch, Scorch, Scorch, Scorch, Fireball, Fireball, Fireball, Fireball, Fireball

and

Fireball, Fireball, Fireball, Fireball, Fireball, Scorch, Scorch, Scorch, Scorch, Scorch

In both cases the dps was 1153.510488, time: 2:38 and dmg 218,906

My understanding is that with impoved scorch that it improves fire damage by 3% each scorch and stacks 5 times which should result in the fireballs in the first sequence benifiting by 15% each and resulting in a higher dps. In the second sequence, the fireballs are cast first and thus would not benifit by the scorches that follow (although each subsequent scorch would benifit by previous scorches).

Any Help?

 

◊ Vontre

Ramp-up is not calculated, it's treated as a static debuff. The effects of a ramp-up over a long duration are usually negligible.

www.magegraf.com

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

"We agree with Communism." - Greg Street 2009

 

Jayde

Although it's probably not useful to have it in the spreadsheet as a general rule, what are your findings in regard to the effect of ramp-up on Scorch vs. Fireball DPS on shorter fights?

e.g. What is the most optimal casting order for an average trash fight?

I've been doing some in-game testing in regard to pure Fireball on trash, pure scorch, 5x Scorch+Fireball, 3x Scorch+Fireball, and some other things...but given the short duration, it's really hard to get any conclusive testing. Perhaps you can shed some better light on it with some magical formulas?

 

Kazanir

I've read through the thread (and don't see any other mage threads around) and was wondering if this has been updated to account for the new nature of consumables -- i.e. two elixirs or a flask, plus food and oil, and that's it.

'War' is too small a word for what I'm fighting. Like a candle in front of the whole burning Sun. I told you. This is bigger than a war. Now, I am not going to die today. I have other projects, and other options.

You can come with me. I can protect you.

 

Jugalub

As the gear isn't updated to the latest patch yet I am guessing that the consumables aren't either. Hope for an update soon

 

◊ Vontre

I updated the consumables a while ago, but Kalman handles the gear. I might update it if I have time.

www.magegraf.com

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

"We agree with Communism." - Greg Street 2009

 

Copernicus

So using the spreadsheet generator from Item database project (for all these spreadsheets) and this spreadsheet, I made a quick item comparison spreadsheet for a 10/48/3 spec. It's updated for post 2.10 values but doesn't have a lot of the new post 2.10 items, like the majority of Tier 6 stuff. I included set bonuses for Spellstrike and Spellfire, but not Tier 4 and Tier 5.

The stat values I used were...

1 dmg = 1 DEP
3.5 int = 1 dmg
7 spirit = 1 dmg
2 stam = 1 dmg
1.5 crit rating = 1 dmg
0.9 hit rating = 1 dmg
1 socket = 9 dmg
1 meta-socket = 12 dmg
Spellfire Set = 11.66 dmg/slot
Spellstrike Set = 7 dmg/slot

http://www.ainur-guild.org/stuff/magegeardps.htm

This is the first spreadsheet I've ever really made for public use, so advice and error-correction would be helpful.
I also have no idea what to value stamina at, with 2 stamina/dmg being a complete guess. Stamina is valuable on a lot of TBC fights with random damage, but it's very easy to overvalue it.

 

Xei

You cannot really 'value' stamina as its needed in some fights but totally irrelevant in others. As such I normally collect some gear that has slightly less dmg or crit but a good stack more stamina for such fights as Tidewalker where I am likely to take a decent amount of damage - then switch out for pure dmg gear for something like Fathom-Lord.

"Being a leader is not a position of power. It is a position of service." ~ Barestomper

WTB Oceanic Horde PvE Players

 

Jayde

I'd personally make a seperate "stamina gear" section that ranked Stamina higher. Would be better as people usually have different sets for different fights.

I'd say Stamina is nearly trivial or a non-issue for the majority of fights, so I would rank it rather low (or even 0 it out completely) for general-purpose DPS gear. For instance, on your sheet the Bloodmaw Magus-Blade gets lower DEP than the Nathrezim Mindblade, however for the majority of fights the Bloodmaw Magus-Blade is a superior item--albeit only very, very slightly. Likewise, the new stats on Ring of Recurrence are downplayed a bit due to the low stam on the item.

 

Copernicus

Stamina valued at zero version - http://www.ainur-guild.org/stuff/magegeardpszero.htm

Stamina valued at 2 stamina/dmg version - http://www.ainur-guild.org/stuff/magegeardps.htm

I made a mistake with my initial values of int and spirit, counting spellfire as being always on for the purposes of intellect and overvaluing spirit on my initial valuing.


My values were-

Crit = 1.5/dmg
Hit = 0.9/dmg
Stamina = 2/dmg or zero
Intellect = 5/dmg
Spirit = 9/dmg
Socket = 9 dmg
Meta socket = 12 dmg

If anyone wants to mess around with their own values, here's a zip file of the two spreadsheets - http://www.ainur-guild.org/stuff/magedps.zip
Just change the numbers in the constants, this is still a very simple spreadsheet.

I also added in the recent items from wowhead, but I have no idea how to value spellhaste on a few of the new items and I didn't include them because of that.

 

Jugalub

Just another query about the consumables on your spreadsheet Vontre. Under Options I am guessing that DPS consumables is Superior Wizard Oil, and a Blackened Basilisk type food? and Flask is pretty self explanatory. Unstable Mana Pots again is self explanatory but is there a way to use Super Mana instead or even Fel Mana? Under Miscellaneous i can toggle Mana Regen Consumables. Is this mana gems or a Mageblood potion and mana regen food? If not are Mana Gems built into the spreadsheet anyway?

 

◊ Vontre

Mana gems are in the spreadsheet anyway.

All the consumable values are stored under the Game Information tab, if you want to mess with it. I'm pretty sure the mana gem consumables were mageblood potion and food though i may have removed them from the calculation due to being outdated.

www.magegraf.com

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

"We agree with Communism." - Greg Street 2009

 

Jugalub

Thanks for the clarification.

 

alvinrod

Any idea of when he might have that finished?

 

Zyrexana

Anyone that can help a warlock trying to figure out how a mage is played?

Alright, so I've broken out this spreadsheet, have the values entered for talents, and basic stats in the Main Sheet, including evocate weapons and such, and it gave me a bunch of delightful numbers that I don't quite understand. I would love any help and clarification.

Under the Spells tab in the Main Sheet, when it lists a spell, such as Fireball, is that just saying "If you chain this spell in the circumstances you provided, you would do this dps for this long before you're mana is dry"? Or is it considering it as part of a rotation, or what?

My issue here is a bizarre one. In my guild, we have a few mages who, it appears from preliminary research, aren't coming up to par; so naturally, now I have to theorycraft a way for them to pwn before they believe me that they can do better than like 620 dps on Mag. =P I am normally a warlock, so mages are a relatively new field for. So, any help is appreciated.

So clarification on that would help (for the numbers I'm seeing in the sheet), and does anyone have a recommended spell rotation to try in this sheet, for a couple of the better specs? Like 10/48/3? And how would this rotation reflect in the spreadsheet? Similar to the front tab (you can do this maxed out for this long before oom, or?)

Sorry for being a pain, and thanks for the help in advance!