While the listed damage for shots doesn't indicate what the effect of armor mitigation is, the armor mitigation is definitely applied to the shots when considering total DPS.

I was checking the lightning breath calculations and my eye caught the lack of Misery - Spells - World of Warcraft in the calculations. Is this calculated without notification or have you just forgot to add it? Stormstrike - Spells - World of Warcraft uptime is probably hard to calculate as it depents on raid setup so much. Suppose I can just think that it gives a tiny boost of dps in fight. :-)

Change Log:
- Fixed lookups for Leg stats
- Actually allow the user to select a different target.
- Bestial Wrath is only counted if you actually have the talent.
- More spelling corrections to match Armory names. Keep the feedback on this coming.
- Added new gear ([Shadowmaster's Boots], [Adamantite Stinger], [Infused Shadow Draenite], [Balanced Shadow Draenite], [Wicked Flame Spessarite])
- Added Curse of Recklessness to Target Debuffs.
- Fixed some errors in Ammo drop-down values mapping properly.
- Correct some items ([Vengeful Gladiator's Waraxe], [Serpent Spine Longbow], [Foreman's Reinforced Helmet])
- Reapplied checks for Meta gems.
- Meta Gems for Gladiator Gear and Engineering Helms will now appear in the correct socket locations. You may need to correct this if you load an old saved file with them. (The check to do this honestly wasn't worth the effort.)
- Fixed Resilience socket bonuses for Wrist items.
- Fixed the mix-up in hit/Crit socket bonuses for Helms.
- Added in Resilience socket bonuses for Shoulder items.
- All gear is cleared out before loading from the Armory.
- Fixed gems in Moriquendi's Helm.
- On the 'Talents' tab is a button allowing you to read your talent spec in from the Armory. Character name and Realm are settable on the 'Settings and Results' tab.
- Added support for European Servers. Select server set from the 'Settings and Results' tab.
- Validate the character and realm combination exists for the server set, a warning message is issued if you provide an invalid character.


Bugs fixed from bug-tracking post:

• Sep 27: Calculations!D32 has a typo - Ranged WeaponWeapon DPS
• Sep 30: Dragonstalker armor (set) - not being counted correctly.
• Oct 09: [Serpent Spine Longbow] - listed with 16/7 stamina, not counted in stamina/HP totals.
• Oct 18: [Gronnstalker's Helmet] - currently listed with +4 Hit Rating, should be +4 Crit Rating
• Oct 18: Armor penetration on custom items not working correctly.
• Oct 18: [Merciless Gladiator's Chain Helm] - set bonus not listed correctly.
• Oct 18: [Foreman's Reinforced Helmet] - missing 30 Agility, 6 AP
• Oct 18: [Infused Shadow Draenite] - missing.
• Oct 18: [Balanced Shadow Draenite] - missing.
• Oct 18: [Wicked Flame Spessarite] - missing.
• Oct 19: [Beast Lord Helm] - incorrect socket bonus.
• Oct 21: [Forest Prowler's Helm] - incorrect socket bonus.
• Oct 22: [Merciless Gladiator's Chain Spaulders] - incorrect socket bonus.
• Oct 22: [Veteran's Chain Bracers] - incorrect socket bonus.
• Oct 23: Curse of Recklessness - missing.
• Oct 23: [Gronnstalker's Leggings] - not counting towards set bonus.
• Oct 23: [Shadowmaster's Boots] - missing.
• Oct 23: Armory import sometimes inverts imported gems.
• Oct 23: [Warden's Arrow] - display as #N/A in DPS field.
• Oct 23: [Vengeful Gladiator's Waraxe] - stats incorrect.
• Oct 23: [Sky-Hunter Swift Boots] - currently spelled incorrectly ("Sky Hunter Swift Boots").
• Oct 23: [Rift Stalker Leggings] - not counting towards set bonus.
• Oct 23: [Adamantite Stinger] - missing.
• Oct 25: [Beast-tamer's Shoulders] - currently spelled incorrectly ("Beast tamer's Shoulders").

Armory import makes things so much faster, gj.

Only thing worth mentioning is that the import doesnt copy ring enchants, otherwise no 'bugs' so far.

Hmm, I guess your own profile had all the same enchants I did then apart from ring the ones.

This version is really cool Cheeky

Just having a couple of problems

Its saying Band of Eternity 2 is not Supported use Custom Gear for it

Same with Timeless Arrows

Edit: It did not pick up race when loaded

None of the reputation rings are supported. They all have the same name, so I can't differentiate them without analyzing the specific stats, and I don't have the infrastructure in place for that yet.

[Timeless Arrow] is probably a spelling mistake. For both of those you can still use the drop down menu to select them.

OO Version updated. Mostly just gear corrections, since 95% of all the neat changes are Excel-only.

Cheeky, I like the spreadsheet. I have one of my own, very similar to yours. I'd like to make couple of suggestions though. Add a worksheet for quik comparisons of the differents saved sets, showing dps, crit rate, mana, hp, rotations, etc. This will make it a lot easier for people to view the differences between the created sets. Also in my spreadsheet I set up the talents with several preset, cookie cutter specs, which I can quickly loadup and tweek from there if need be. Also I have a reset for BM talents, MM talents and SV talents.

Just some ideas I thought you maybe intested in. Also the armory link downlaod is a great idea. Nice job on the sheet.

The armory import doesn't work for me because the Armory seems to return the item names in german. I'm using an english version of Excel 2007 but running on a german Windows XP.

The solution is to open the Internet Explorer and add english as the default language.

In german: Extras -> Internetoptionen -> Allgemein -> Sprachen -> Hinzufügen. Und dann "Englisch [en]" auswählen und in der Liste ganz nach oben schieben.

In english: Tools -> Internet Options -> General -> Languages... -> Add. And then add "English [en]" and move it to the top of the list.

Now the Armory should return the results in english. I don't know if there is a better workaround for this.


And thanks again for this new version - going to check if everything was imported fine now.

Today I was once again on worldofraids.com to check some of the PTR-news.

As Teza pointed out in the news (Worldofraids forums :: New PTR Build , Daily Blue, Heroic Badge Sets) there are a arena-gun and arena-bow found on the PTRs.

I don't know if you wanna add these to your spreadsheets at the moment, but for me as a Dwarf-Hunter the arena-gun may be quite an upgrade.

For your interest:
Vengeful Gladiator's Rifle and Vengeful Gladiator's Longbow