Vontre's Mage DPS Spreadsheet - Page 9

[DRF]Solmyr · 08/13/07, 1:43 PM

You can go in and manually update the numbers on the items, and add your own items. I'm sure there will eventually be an update from the author with the new info, but until then, copy/insert away!

◊ Vontre · 08/17/07, 1:35 PM

I'm working on a major update to the gear selector as well as the spreadsheet in general. Zexi do you still have that item table update? I'd rather not manually add them if I can help it.

Nomicon2 · 08/17/07, 2:39 PM

Will this update include [Veiled Noble Topaz] ? I swear I went blind checking and double-checking the gem drop down and couldn't find it.

◊ Vontre · 08/17/07, 2:59 PM

Kir · 08/17/07, 3:51 PM

Got a question that I didn't think warranted it's own thread. I've tried looking in the the major mage threads on the board, but couldn't find exactly what I'm looking for.

I was wondering if there is a website for mages, similar to ShadowPanther.net - World of Warcraft Rogue Info - Charts, Articles, Strategies & more! where there's equipment sets listed, such as best gear attainable without raiding, best played crafted gear set, best pure +dmg gear etc..

Hate Monkey · 08/17/07, 4:03 PM

Originally Posted by Kir

Got a question that I didn't think warranted it's own thread. I've tried looking in the the major mage threads on the board, but couldn't find exactly what I'm looking for.

I was wondering if there is a website for mages, similar to ShadowPanther.net - World of Warcraft Rogue Info - Charts, Articles, Strategies & more! where there's equipment sets listed, such as best gear attainable without raiding, best played crafted gear set, best pure +dmg gear etc..

Best gear for a mage without raiding....is Karazhan allowed? If so ANY item at ilvl 115-125(Prince level). If absolutely no raiding, anything ilvl 115 or lower.

And what is different about mages is the 3 different specs use different gear than rogues who use the same gear regardless of spec, so a site like that wouldn't exactly work to well.

lxsli · 08/17/07, 4:24 PM

Get the spreadsheet and figure out what you want: ie grind, boss or PvP
Choose talents suitable for the goal; roughly, full frost PvP otherwise fire.
Work out how much +dmg a point of crit or hit rating is worth, using the top-right section of the sheet.
Use lootzor.com to identify gear.
Grind until you die.
Get an IRL rez and grind more.

Kir · 08/17/07, 4:30 PM

edit: was responding to Haste Monkey.

You could have best +crit gear, best +dmg gear, best +hit gear lists, best +fire etc... It's not supposed to be definitive, just an organized list to save time surfing WoWhead compiling it yourself. It came in handy when I played a rogue.

But, appreciate the response at least. I was figuring there wasn't something exactly like it. I'm just returning to the game after an extended absence, want to get back into raiding and have hardly touched foot in Kara. Want to see how far I can get in gearing myself up without 25 man raiding, as none of the guilds I'd want to join would take me until I had better gear.

Qbert · 08/17/07, 5:10 PM

Minor feedback: version I downloaded @ ~4:00 pm 8/17

1) found a small bug resulting in superhigh arcane missle DPS (~4000)... found it in the calculations reference base stats. Rather than a 5 second cast it is reading arcane missles as a 1 second cast while still using the full 5-second damage total.

2) this might sound stupid, but we actually carry along a charity ret pally in our raids and I noticed that the sanctified crusader debuff wasn't an option for debuffs. that adds another 3% crit.

3) I couldn't find any mention of molten fury and wondered how you treat it. Simple theorycraft has always pegged it @ 4% increase, however there's the x-factor of having less time to DPS under 20% which decreases the effect... yet the x-factor of manipulating cooldowns/trinkets/consumables to coincide with the 20% marker which increases the effect (bloodlust, combustion, trinket, flame cap, destruction pot, etc. @ 20%). Seems like there's too many unknowns to make a distinction and wondered if you just left it @ 4%.

4) I noticed you're calculating debuffs multiplicatively, I always thought it was additive from talents and additive from debuffs, only multiplicative between the 2 totals (13% firepower+PWF * 30% scorch+misery+coe). I have no evidence to back it up, just the way I thought it was. Same with +dmg coefficients after the 10% tax. It seems like it could be multiplicative but I've done a few tests that resulted in higher max-hits than should be possible with a 1.035 coefficient on fireball, it seems like all empowered talents are additive which explains why the quick-heals & wrath only got 10%. In that case, mages got shafted even further as a flat coeficient increase to fireball is less DPS than an equal increase to shadowbolt & incinerate, despite that shadow/flame is 20% vs 15%.

edit: to add to #2 and get really fussy, you could feasibly have imp sanctity aura for a 2% dmg increase, but i guess it's irrelevant as it's a flat 2% increase across the board

◊ Vontre · 08/17/07, 5:36 PM

Yeah I left it at 4%. I'll look at getting the Crusader Judgement option. Dunno how you ended up with 1 sec arcane missiles but I've significantly altered the cast time calculations for the next revision, so hopefully that clears up.

◊ Vontre · 08/21/07, 4:43 PM

Major revision posted!!

First off, my own host. Thank you to Kalman for hosting the speadsheet all these months, I won't be eating your bandwith anymore.

http://www.homegirlsguild.com/mage_dps.zip

New features:

NEW GEAR SELECTOR: The gear selector interface has been entirely redone and, thanks to Stirius' item database... thing... it has a whole new list of items as well as the new hit gems. Enjoy!

Armory Import: It's a bit cumbersome but the instructions are there to set it up to automatically download your stats from the armory. EDIT: This feature is problematic and is not working with several users in their version of Excel. I'll update with a fix, if possible, at a later date.

Updated 2.2 stats: New spell haste rating coefficient, updated arcane missiles functionality (particularly with Mystical Skyfire Diamond), and of course the usual miscellaneous tweaks/fixes.

Minor interface improvements: Changed around the position of some options on the main page, added a menu at the top for input source (Manual Stat Entry, Gear Selector, Armory Import). The manual stat boxes will disappear when a different input source is selected.

I'll ask Kalman to update his link with a redirect when he gets back from vacation.

As always post here with any questions/comments/concerns. Thanks!

Nocte · 08/21/07, 5:37 PM

The gear selector is currently missing the following items:

Crystalweave Bracers
Merciless Gladiator's Spellblade
Belt of Blasting
Boots of Blasting
Lightning Capacitor
Darkmoon Card: Crusade

Docjowles · 08/21/07, 5:47 PM

The Armory import doesn't seem to work for me. I'm using Excel 2003, what version did you test it in?

Basically, I follow the instructions, but the choices I have are different. First off, "Get External Data" is called "Import External Data" for me. Next, when I click that, it pops up a browser and tells me to select a table on the armory site to import from. I tried selecting none, as well as the one that contained the entire page. In both cases, once I click "Import", the values are not filled in

Any ideas what might be going wrong, on my end or yours?

Edit: For the record, here is my Armory URL:
The Armory

But I have tested with several other mages' URLs with no luck, so I feel like it's not character/guild/server specific.

◊ Vontre · 08/21/07, 6:02 PM

Originally Posted by Nocte

The gear selector is currently missing the following items:

Crystalweave Bracers
Merciless Gladiator's Spellblade
Belt of Blasting
Boots of Blasting
Lightning Capacitor
Darkmoon Card: Crusade

Darkmoon Card is in there. Lightning Capacitor appears as "The Lightning Capacitor". All of the other items are listed as well, I'm not sure why you're not finding them.

There is an issue with the weapons column which forced me to include it as two separate alphabetical lists (one for main hands, one for staves) in the same menu.

◊ Vontre · 08/21/07, 6:03 PM

Originally Posted by Docjowles

The Armory import doesn't seem to work for me. I'm using Excel 2003, what version did you test it in?

Basically, I follow the instructions, but the choices I have are different. First off, "Get External Data" is called "Import External Data" for me. Next, when I click that, it pops up a browser and tells me to select a table on the armory site to import from. I tried selecting none, as well as the one that contained the entire page. In both cases, once I click "Import", the values are not filled in

Any ideas what might be going wrong, on my end or yours?

Edit: For the record, here is my Armory URL:
The Armory

But I have tested with several other mages' URLs with no luck, so I feel like it's not character/guild/server specific.

This sounds like a version issue. Apparently I'm using Excel 2000 (issued by work, do'h). May have to write off this feature for now.

Edit: For you advanced users, if you can figure out how to get it to load an XML dump of the page (identical to the "view source" in Mozilla Firefox) in the correct place you may get the armory feature to work.

Aldric · 08/21/07, 6:06 PM

Originally Posted by Nocte

The gear selector is currently missing the following items:

Crystalweave Bracers
Merciless Gladiator's Spellblade
Belt of Blasting
Boots of Blasting
Lightning Capacitor
Darkmoon Card: Crusade

Hm, I found all those items except for the spellblade, which is odd seeing that the S2 warstaff is on the sheet. The largest problems I've seen with the gear selector thus far is that the socket colors are off on a lot of items. For instance all the spellfire gear is listed as RR instead of YB and they don't have bonuses (although they're stam bonuses so maybe they weren't added?)

Crystalweave Bracers, Cuffs of Devestation and Bracers of Havock (the ones I checked) don't even have their sockets. Oddly, the Veteran's bracer line has a bonus for the socket listed but no socket.

It would also be nice to see the stats on the items after selecting them as well, maybe I'm just old school liking how the gear selector used to be. But I must say this one looks pretty.

I'm liking the new version though, JoW uptime and shadow priest mp5 returns are particularly awesome.

Aldric · 08/21/07, 6:13 PM

Just saw Vontre's comment about the two lists for MH/Staff weapons so that's all good. I looked into the bracer socket issue a little more and it looks like they're listing correctly for the sockets, 0100, for devastation which is yellow if I remember the old version correctly, maybe some sort of cell mapping error?

◊ Vontre · 08/21/07, 6:28 PM

Originally Posted by Aldric

Just saw Vontre's comment about the two lists for MH/Staff weapons so that's all good. I looked into the bracer socket issue a little more and it looks like they're listing correctly for the sockets, 0100, for devastation which is yellow if I remember the old version correctly, maybe some sort of cell mapping error?

Thanks for this, I found the issue was an incorrect cell reference for a few item slots. I uploaded a hotfix (same version number).

Stein · 08/21/07, 8:46 PM

Is the 2/5 T5 bonus being added when using the Gear Selector?

◊ Vontre · 08/21/07, 9:20 PM

Originally Posted by Stein

Is the 2/5 T5 bonus being added when using the Gear Selector?

It should be included along with a few other common bonuses:

2/5 T5
4/5 T5
4/5 T6
3 Spellfire
2 Spellstrike

Cormack · 08/22/07, 3:45 AM

Hmm, would it be helpful to have a big listing of procs, bonuses, and other non stat characteristics that are included in the spreadsheet?

Just thinking that it might be easier than having a bunch of different people asking if, say, Robe of the Elder Scribe is getting dps correctly calculated.

Asahina · 08/22/07, 8:32 AM

Hi,

Just wanted to say great sheet, and nice to see it updated with all the new gear/gems!

I seem to be having a problem with some of the socket bonuses, for the pvp necklaces, they arent listed. I was able to add them in manually on the ItemDb sheet, but just thought you might want to know.

I also appear to be having problems with the spellstrike hat/legs, and the all of the spellfire set. Like I said, I can easily sort them out myself, but just a heads up incase you wanted to sort it out on your sheet.

*edit*
Wait, its because they are stamina socket bonuses. God what an embrassing mistake! My bad, sorry, and great work again, will teach me to open my mouth!

*edit again*!

I'm noticing on this version of the sheet, that potent noble topaz's win over the veiled noble topaz's every time, where as on your last version of the sheet, the veiled were much better. I'm wondering have the game mechanics changed since then, or is it an error in the calculations somewhere?

After having played about a bit, it looks like its not taking + hit from the new gems into account, maybe its just from the gems, or it might be a version issue, but it doesnt seem to be on my one at least

Seriously, final edit >.>

I should really learn to turn off totem of wrath, hadnt realised it was turned on by default, I feel this was a bit stupid of me. Works perfectly now!

Stein · 08/22/07, 9:59 AM

Originally Posted by Vontre

It should be included along with a few other common bonuses:

2/5 T5

Perhaps i was too passive in my wording.

2/5 T5 (at least head/shoulders) appears to not apply the bonus when using the gear selector. The yes/no box does work when doing manual stat entry.

◊ Vontre · 08/22/07, 2:48 PM

Damn that passive wording! Looks like I had a few setmasks in the wrong column. I uploaded the fix.

Zwink · 08/22/07, 4:35 PM

Tempest 4p also appears to not be working in the Manual Stat Entry for Fireball and Frostbolt. It works for AM. Also, Haste rating does not seem to be added in when using the Gear selector.

When you use the Gear Selector do you still need to update Trinket/Item Effects and Set Bonuses on the Main Sheet?

Like many others have said this spreadsheet is great. Thank you for it.