Probably need a confirmation that they really exist first.

New items will come when I'm more positive they are real. That said...

New version up

2.4.0.1 dmm
Added
All enchants modeled (like Heavy Knothide Armor Kit) are now properly identified for all slots they can be used in, resolving Armory Import issues.
All modeled weapons that can be equipped in either hand are modeled for either hand, resolving Armory Import issues.
Mallet of the Tides; Terrok's Gavel; Andonisus, Reaper of Souls; Twinblade of Mastery; Crystal-Infused Shiv; and Talon of Anzu.
Adamantine Repeater and Crystalline Crossbow
Attack Power Equivalences along side the Agility Equivalences on the Talents page.

Changed
Shaman buffs now colored light blue for reability given the lack of Mage buffs that help Rogues.
Many Macro buttons enlarged.
Heroic gems no longer Unique-Equipped.
Poisons are now disabled based on the Option on the Talent sheet.
Altered % uptime estimates for suspected ~1 ppm weapon procs based on 1/3 uptime for 10 second MH procs and 1/2 uptime for 15 seconds.
Offhand procs estimated at 1/6 for 10 seconds and 1/4 for 15 seconds. Both done to provide consistency.
All ~1 ppm entered as 1.2 ppm based on the Mongoose/Executioner research.
Mongoose as an estimate so that it should compare better to Executioner at different build levels.
All this as a temporary measure prior to implementation of new improved ppm modeling.
Illdari-Bane Broadsword and Illdari-Bane Dagger now linked to mob type for Demon bonus.
Weapon list has been reviewed and adjusted to only include weapons with 69.67+ DPS.
Blackout Truncheon chosen as the bottom point due to the lack of fast Maces in early itemization.
Ranged weapon list has been reviewed. Those items not close enough to quest accessible items removed.
Importing Options also imports the options on the Gear Buffs sheet.

Fixed
Mob Armor can no longer be reduced below zero.
AEP Macro now working again if certain items equipped or bonuses active.
Doubled Copy buttons removed.
Upgrade Macro should now correctly search the 2nd Ring or Trinket on the list.
Fury was missing socket.
Demonblood Eviscerator was missing Expertise rating.
High Warlord's Left Ripper and Grand Marshal's Left Ripper had incorrect damage and speed.
The Unbreakable Will, Honor's Call and Warp-Storm Warblade were missing Defense rating.
Offhand Talon of Azshara and offhand King's Defender had old stats.

Removed
Thunderfury and Wastewalker Shiv as the dps output is worse than some unmodeled green items.
Gyro-Balanced Khorium Destroyer; Hemet's Elekk Gun; Huhuran's Stinger; Larvae of the Great Worm; Legion Blunderbuss; Legionkiller
Lohn'goron, Bow of the Torn-heart; Mark V's Throwing Star; Needle Shrike; Nerubian Slavemaker; Shuriken of Negation; Soulstring
Striker's Mark; The Sharp Cookie; Valanos' Longbow; and Wrathfire Hand-Cannon
All Grand Marshal's and High Warlord items given the availability of S1 for Honor.

I just downloaded the newest version of the spreadsheet but whenever I open it I get a Visual Basic Error that says "Error Loading DLL"

After closing the error window the sheet loads but none of the macros work ("Cannot run the macro ...... may not be available or macros are disabled) But I have macros enabled. I can still use the spreadsheet but just not the macros, which is quite annoying

Has anyone else had this problem or am I doomed to be macro-less?

I've noticed a bug, though i'm not sure exactly whats causing it.

I'm currently using the belt of deep shadows with two shifting nightseyes socketed (4agi/6sta). When i switch to the belt of one hundred deaths, i get a dps increase of 5.61, until i replace one of the two nightseyes with a Glinting noble topaz (4agi/4hit) which then drops my dps by -12.41

I'm not breaking the socket bonus, in essence all i'm doing is switching +6sta for +4hit - the sheet is obviously modeling something wrong, but i don't know how to fix it.

In testing this more, with my current gear setup, if i change the +4agi/+6stam gems in the belt of deep shadows to a +8agi gem (thus changing my stats by +1agi and -6stam) and this is giving me a net dps loss of 19.53

Any ideas how this can be fixed?

Sounds like you disable the Meta Gem Bonus, when switching out a purple (blue) gem.

Thank you, that appears to be the case :P

I've tried to do my homework and follow along but my math skills often lag. This is my gear The World of Warcraft Armory

Please ignore the poor gems in Girdle of Treachery. I'm getting Deep Shadow made tonight and didn't want to waste money on better for a temp belt. I have been planning on putting 2 +8hit gems in it.

My question is this. When I look at my specs in game I'm showing 302 hit. When I look at the spreadsheet unbuffed totals I'm showing 381. The difference is apparently coming from the talents number on row 75. I understand the hit cap is now 363 so I would be well over it.

Should I change my gem plans and stop worrying about hit? Is that 381 the number I should be concerned with or is it the one I see when I look at my stats in game.

I do see a dps increase (slight) on the sheet if I continue gemming for hit. Should that be happening if I'm over the cap?

Did you go to the buffs tab and correctly set the buffs you get and debuffs placed on the target, cause every time I use the sheet its dead on, also are you using the most up to date version?

I've sent you in PM the requested test results and button sizes on Mac OSX.


A few more things though, could you add lvl 71 and lvl 72 mobs in the talent spreadsheet selection?
Since most BT and Hyjal trash mobs are level 71-72, i don't really see a reason to leave those 2 levels out.
It'll help fine tune a perfect suit for average use, and expect to receive a +3% improved faery fire on bosses as cap.

Also, since the new popups for gear selection are causing so much trouble(still not working), is there any particular reason that you can't use the same popup-type that's being used everywhere else? e.g. for weapons, armor, rings, etc.

And, as another feature, could you perhaps add a box somewhere that matches the displayed hit rating as it would be in game?
" =uhit-H75 " It'd be nice to have for reference.

What is supposed to go into columns M, N, O.
They seem rather empty at the moment for the gear sheet.

---

Another request, instead of displaying "1 Red 1 Blue 1 Yellow" In the first column, then replacing that with "3 agi" when the sockets are filled, and thus making it impossible to see what sockets the item has...

Could you make it work something like this :
"0/1 Red 0/1 Blue 0/1 Yellow : 3 agi" : Colored gray, if the socket requirements are not met.
"2/1 Red 2/1 Blue 1/1 Yellow : 3 agi" When the socket requirements are filled.
This would make it a lot clearer to see what sockets you're using / filling / could replace. It's a bit of a haggle currently.

Giske: All data imported from armory this morning and checked. Substituting in Deep Shadow with the 2 Rigid Dawnstones I get 336 by subtracting that extra 79 points in H-75.

Saytar: Am using the latest version. Downloaded this morning. The figure I'm concerned with is from the unbuffed totals line.

The difference is attributable to cell H-75 which contains the formula Talents!I19*hitrate*100.

I would recommend you keep Thunderfury IN the sword list since it's 54 DPS is it's BASE dps and you're not including the approximated damage from the proc. I've read estimates over the years with the Thunderfury proc raising it's overall dps anywhere from 80 to 120.

After all, you keep [Andonisus, Reaper of Souls] which is even more unlikely than regular legendaries.