Sorry, I figured it out, since the trinket is an upgrade in both trinket slots it lists it twice and the different dps is because its a different dps upgrade for each slot. the same issue comes up with rings as well.

Version 3.3.0: Download Ald Combat and Mutilate Companion_3.3.0.xls

* Compatible with Combat 1.4.1 sheet
* Added compatibility with Mutilate 1.2 sheet, and ability to copy items from both sheets to single upgrade list, including new spec column. Use the combobox on the Gear Upgrades sheet to select which sheet to use.
* Added WoW 3.3 known items (nothing yet from Arthas) - may be some missing
* Changed version numbering to follow WoW version, since Combat and Mutilate sheets are not kept at same version numbers.
* Updated Pawn string to generate for both Combat and Mutilate weights.

Note that you will have to make the following corrections in the combat 1.4.1 and mutilate 1.2 sheets in order to avoid lookup errors in this companion sheet.

Lookup errors typically manifest as items which get copied over to this companion sheet without a source or other additional information. Also, the following item gets listed with an identical DPS as the item which failed the lookup. (I imagine these errors will be corrected in future versions of those sheets, but for now you have to manually correct them.)

To make the corrections, you will have to unhide the Gear sheet in each file, and fix the spelling in the appropriate row for each item.

Combat:
* The heroic Ivory-Inlaid Leggings is missing the " (Heroic)" designation in its name.

Mutilate:
* "Aldriana's Gloves of Secrecy" (non-heroic) are misspelled (missing an 's').
* The Herkuml War Token has an extra "'s".

Is it possible, that the Alliance/Horde name replace isn't working vor the Mutilate Sheet? I tryed it in my sheet and it wasn't working. It also results in some wrong dps results.

Sorry, yes it is entirely possible. I didn't even think to update that part of the code, which was built just for the combat sheet. I'lll try to work on it this weekend.

If you can be more specific about "wrong DPS results" that would be helpful. Particularly if it's of the sort I described above for lookup failures.

Sorry, i haven't described it clearly. It has only wrong DPS results, because of the Alliance/Horde replace. I think the Companian Sheet doesn't find the correct Name. (Because the replace doesn't work).

Just discovered this, and it is something I've wanted for a long time. Thanks. However, I cannot seem to convert the names to their Horde equivalents. Both spreadsheets (Mutilate_1.2.xls and yours) are in the same directory, finding gear upgrades and sorting them every which way works fantastically. However, when I click the 'Horde' button, I get the error

with the "Continue" options greyed out. Is this a problem with some part of Office I neglected to install? I am currently running the Office 2010 Beta (offical from MS, no shady torrent copy), so that's my first guess but I wanted to get that out there, and thank you for all the work you've put into this sheet.

Point three in Usage Notes:

3. Change the Options tab to identify the exact name of the Combat and/or Mutilate sheets (if you've changed it) and any minimum DPS upgrade cutoff you'd like.

Changing the name on mine seemed to work. Hope that fixes it :P

I don't have office 2010 so I can't say for sure whether this is the issue, but I would tend to doubt it. When the error happens, what line of the code is highlighted if you select debug? Do any of the items gets changed before getting the error?

Through some messing around, I've gotten it to work. Mousing over a few things in the Debugger, it seems that the line it highlighted for some reason was looking for the Combat spreadsheet, which I did not have a copy of in the same folder. Once downloaded, I clicked the Horde button and it worked for a few seconds and changed most of the gear in the hidden 'Gear Data' sheet to their Horde equivalents, as well as doing the same in the Combat spreadsheet (but not the Mutilate one-- was this left out purposely?) One thing I noticed is that the conversion process does not change the name for some items (Death's Choice/Verdict, Victor's Call/Vengenace of the Forsaken, Twin Spike/Gouge of the Frigid Heart).

In short, I fixed the problem myself after seeing that the Combat sheet is required since it also changes the names there as well, since it's programmed to, and I guess it's an obscure condition that wasn't anticipated.

Are you using the newest Version of the Companien Sheet? I had the same problem in version 3.3.0. But in version 3.3.1 it works fine for me, also without a copy of the combat sheet.

Ok, I found the link to the 3.3.1 version heh. I admit I did not read through the whole thread before posting my initial issue. Thanks.

At a quick glance, here are the items I see not being changed to their Horde equivalent, even in 3.3.1: Death's Verdict, Victor's Call, Baelgun's Heavy Crossbow (the Heroic one got name changed, the normal didn't), Twin Spike, Icefall Blade

Thanks. I'll fix and push out a new release when I have a chance. (Note that Baelgun is actually in there already.)

Thanks also for pointing out that I forgot to update the link in the first post to point to the latest. That's fixed now too.

Version 3.3.2: Download Ald Combat and Mutilate Companion_3.3.2.xls

* Updated list of Horde-specific names for conversion

This version is only needed if you play Horde and need to change the names of the T9 pieces in your Combat, Mutilate, and this companion sheet.

Note that you will need to make the changes described in the 3.2.1 post above, until the next versions of the Combat and Mutilate sheets are released.

Version 3.3.3: Download Ald Combat and Mutilate Companion_3.3.3.xls

* Updated to be compatible with the Mutilate 1.2.1 sheet
* Sorting now unhides all rows first

Not directly related to this sheet, but there are two issues with item names in the 1.2.1 mutilate sheet which you should correct to have this sheet be as useful as possible. They are the "Ashen Band of Endless Vengeance", and the "Taldaram's Soft Slippers (Heroic)". More info can be found in the thread for those sheets, linked in the first post of this thread.

I know you don't have Office 2010, but it can easily be downloaded on microsoft.com.
I just here to say that you sheet does not work very well with office 2010. Personnaly the name conversion thing seams to work when I convert the xls file into a xlsm otherwise that does not work at all (it returns the thing that jsz say).
But the upgrade thing does not work very well because the only Item it returns is :
Blood of the Old God Trinket 0,2 M Ulduar 25 13. Yogg-Saron
It takes time before it display two of the same line. It let me thinking it does all items comparison before trinket one when I click on all.

Can you take a look? I really appreciate the help given by your sheet.

Version 3.3.4: Download Ald Combat and Mutilate Companion_3.3.4.xls

* Updated to be compatible with Mutilate 1.3 sheet

Once again, if there are equipment naming issues in the combat or mutilate sheets, you'll want to fix them manually.

A side note on usage of this sheet: now that 3.3 has dropped and many of us are upgrading gear to the new ICC items, you are likely discovering that any given set of gear can be very precisely gemmed to hover on the knife's edge of expertise cap and crit cap. Unlike previous tiers of upgrades, any given item (particularly one which changes your expertise or hit or crit) might now require a substantial amount of regemming in order to take full advantage of it.

More to the point, there may be times when this regemming is required in order to even see the new item as an upgrade, even if the upgrade is theoretically substantial. Which is, of course, the problem with this sheet - it just swaps items in and out quickly, without changing any gemming.

Long story short: because gemming can have a much more substantial impact on overall DPS of any given gear set than it used to, you are more likely to find now that this companion sheet does not always identify all the available upgrades, if such an upgrade also requires regemming in order to maximize it's potential. Caveat emptor.

Unfortunatley the sheet doesn't work anymore for me with combat 1.4.4
In the options tab i changed the name to name of the combat 1.4.4-sheet
If i want to copy the DPS to saved dps there is filled in a 0.
The gear upgrade tab doesn't return any results anymore (doesn't matter using saved dps or not)

Any ideas what i can do?
Thanks everybody

I need to update it to work with the latest versions, and things have been busy with me at work. I'll update it shortly, if I get a chance.

I am having similar issues with the mutilate sheet. The only thing that shows up as an upgrade is Tiny Abom.
I have tried to re-configure my stats around for the expertise to be arouns 2-3% and still not pulling in the upgrades.

Same answer. Both of Aldriana's sheets have had new versions released since my last update. For each of his new releases, odds are usually good that I need to release a corresponding new update.

Version 3.3.5: Download Ald Combat and Mutilate Companion_3.3.5.xls

* Updated to be compatible with Mutilate 1.3.2 and Combat 1.4.4 sheets

Note that this was a quick hit, and I've done limited testing. I also switched to Excel 2007 in the interim (and had to deal with a nasty sharing violation bug that prevented saving new versions of the spreadsheets), so there's a slim chance that may have had some unintended effects.

Some follow-on advice about the expertise capping issues I mentioned above in post #45. In order to resolve the issues around expertise capping causing some gear which should be listed as upgrades not getting picked up, I have taken to always making sure I am ~80 Exp rating below cap before running the upgrade macro - i.e. I temporarily convert 4 of my Exp gems to AP or Agi gems in Aldriana's sheet prior to running the upgrade macros.

This will cause the overall DPS to decrease marginally (by ~30 dps in my experience), but unless you are using saved DPS, it should have limited effect on the DPS deltas being returned for most gear, and it will allow this sheet to once again return gear upgrades with lots of expertise on them. Just remember to switch your gems back again on Aldriana's sheets when you are done.

Theoretically, you could do something similar if you have crit capping issues, and you can over-gem yourself with hit gems temporarily, to allow Agi and crit items to show their full worth using the macro. I have not tested this though.