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!

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.

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.

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.

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).

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

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.

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!

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.

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.