Yep, I just downloaded 2.3.2.6 again to check. After downloading, I don't change a single thing. I just click the copy button next to the Veteran's Musket ranged item and it's adding the Netherblade Facemask to the Gear Upgrades tab. Ironically, I did not have a problem with cloaks or trinkets in the previous version. I am using Excel 97 though I don't think that should cause a problem.

Deselecting Hemorrhage in the Boss Debuff section (Cell B89) effects unbuffed DPS - bug or feature?

There are 2 fields in both the Talents (G6 and P6) and Gear_Buffs (I6 and R6) sheets showing your miss chance when unbuffed and buffed.

Is that what you're talking about?

--edit--

This is in the 5a sheet - the fields may have moved for version 6 for all I know, but they've always been there

Ah, right. I was too preoccupied with looking at the hit rating numbers to actually think about that. Sorry.

Oh, ok, sorry I had a brain fart. I was thinking Upgrade button, not Copy buttons. Yeah, a bunch of those are screwed up when I checked, fixed now for the next version.

New version to be posted soon...

2.3.2.7 dmm

added
Wow Armory Import
Special thanks to Rerox for looking up innumerable Item IDs and finding a working Armory Import model.
Special thanks to Faelivrin @ EU_Proudmoore for the Armory Import code which was adapted to this sheet.

improved
Better Seal fate modeling thanks to Todemax (work in progress)

fixed
Humanoid mobtype works for Murder
Void Reaver is now attributed to TK.
Midnight Chestguard spelled correctly.
typo Relentless Strikes
Various Copy buttons not copying the correct stats
Copying weapons now correctly gives the Source

if armory import doesn't work, download MSXML 6.0

Dmm I found a small bug in the buffed cycles. I will change it myself and send it to you the next time I make some other changes. But if you have nothing else to do : The cells T51:T54 should be changed to =E13*(1+OXX), with XX being the rows (51-54). And the same goes for the unbuffed cycles.

Should be noted also that Armory Import does not and will not work on MS Excel for Mac.

Well, if any Mac users have any ideas. The Armory Import uses an XML parser, since the webpage is coded in XML and the information is pulled out with the tags. Specifically, what error are people getting when using a Mac?

You can also try going to Tools - > Macro -> Visual Basic Editor
then
Tools -> References
and try to enable any checkbox for Microsoft XML, Version 6 (other versions probably work too)
(at least this is the path for Excel 2000)

Yeah, it looks like when I added the other Unique gems, the revised coding to detect Unique gems was not originally populated to all the gems on the list, so when I cut and pasted the code from the top I had selected a row with the old code (pre-Unique). Fixed in the next version again.

Are there any older versions of the XML Library available to be checked? Like Version 4. The functions I used were pretty standard and should also work with older versions. Anything with the MSXML2 Library should work.

While we are at it. Who had to download anything to make this work? Would be nice to be able to track this down.
The beta Spreadsheet that I pulled the code from opened up and work fine I didn't have to do a thing. Although when I copied the code to the spreadsheet, i needed to enable that reference to make it work for this sheet.

So my question is..
Who did this version work without a hitch? Please post Operating System and Excel version.
If you had to do something, what did you do, and did it work?

So, I'm using Windows XP and Office 2000. I can check this on a few computers at work to see where some of the compatibility issues are. It would be nice to cut down the hoops people need to jump through.

Worked fine with Windows Vista & Excel 2007

None. Googling for "MSXML mac os x" isn't encouraging.

Yeah, I'm noticing that, started Googling it myself. I guess I'm a little mystified about how Office can be marketed on a Mac but with a large number of features, including XML formatting, unusable. What I did notice, is that supposedly Open Office might support XML. I'm thinking my next major task will be looking for ways to make some of the macros work in Open Office.

Perfectly fine with Excel 2007 on Xp and Vista

No Blade of savagery? Alot of epic gems, etc missing also. Am i not doing something right? with an import maybe?

By default, BT/HYjal gear and gems are disabled. Tick their boxes in the gear selection box in the gear page

It's possible, I'll have to check that and try to track that down. Unfortunately, many of the formulas in the sheet check for things by different means, some check by variable name, some reference cells directly, some are sensitive to things moving on the sheets. Although, you'd think with the boxes highlighting, it would be working as that box never moved.

I found the problem, fixed in next version. Interestingly enough, the older sheets gave you the Demon bonus AP with just the main hand equipped.

I was attempting to verify as much as I could understand of the spreadsheet (learning a lot about Excel in the process!) and noticed that the average damage of a Sword Spec proc was different than the average main hand hit. Looking at the formulas, it appears that the Sword Spec procs are assumed to be unable to miss or be dodged. Is this an error in the formula, or do extra attacks from Sword spec actually work that way? I remember reading that hit rating is extremely valuable for anything that procs extra attacks, as the number of those attacks are affected by hit rating twice: once when they proc, once when they swing.

Specifically, on the unbuffed DPS sheet, adjusted damage for a main hand hit is calculated as (Average noncrit * Glancing chance * glancing reduction factor + Average crit * crit chance * crit multiplier + Average noncrit * hit chance) while the same value for "extra attacks" is (Average noncrit *(glancing chance * glancing reduction factor + crit chance * 2 + hit chance)/(sum of glancing, hit, and crit chances). The pre-armor DPS for extra attacks is then calculated as Adjusted damage * extra attacks per second * Murder bonus factor, so the miss and dodge chances are not being considered there either.

The way the formula is laid out, it seems as though the author did make the assumption that they canot crit or miss, but this goes against what I remember reading. If this was covered previously in the thread and I missed it, I apologize.

Addtionally, extra attacks are assumed to have a crit multiplier of 2, disregarding RED and Mace Spec.

I downloaded the new version of the sheet to see if the problems mentioned in my previous post were fixed. When I attempt to run the import from another sheet, I get the error as above and the debugger pops up in Module 5, in a block of code labeled Sub Import(). In the line "If (".xls" = Right(oldpath, 4)) Then", "Right" is highlighted. I also get the error when attempting to import from armory. I attempted to follow the path mentioned above, but References was ghosted out.

I'm running XP and Excel 2000.

edit: seeing if downloading the file from the website helps.... and it didn't.