I, like many others, have come to rely on Aldriana's combat (and now mutilate) sheets to help evaluate gear and plan for upgrades.

I still miss some of the functionality which was built into earlier versions of the many spreadsheets which have appeared on this site. I had helped write some macros that copied all upgrade gear to a new "upgrades" sheet. It also included information on the boss who dropped each piece, and let you filter to only show pieces which meet certain criteria (a given slot, or a give boss' drops which are still upgrades, e.g.).

Anyway, I reworked some of that functionality into a standalone sheet that connects up to the combat sheet. The benefits of the standalone sheet is that I don't have to keep re-applying all my changes every time a new version of the combat sheet comes out.

When you click on the upgrade buttons, it will cycle through the various gear choices, and copy any that are an upgrade onto a filterable sheet.

The latest version of the Companion sheet can be found here: Download Ald Combat and Mutilate Companion_3.3.3.xls

Aldriana's combat and mutilate sheets can be found here: http://elitistjerks.com/f78/t39136-c...updated_3_3_a/

---

Usage notes (as of initial release):

* As this sheet uses VBA, it is only compatible with Excel, not with OpenOffice. It may also be incompatible with some Mac versions of excel.
* This version is compatible with version 1.1 of the original combat sheet.
* Put this companion sheet in the same directory as the combat sheet. If you rename it, you can adjust the name on the options tab.
* You can also set an option for how much of a DPS upgrade an item needs to be in order to get copied over.
* The third sheet is just a look-up table which contains all the source location, plus some additional notes.

Hopefully someone else finds this useful. If anyone has suggestions, feel free to propose them, though I don't make any promises.

Hmm, I wonder why I thought otherwise. I'll edit the initial post.

New version 1.1.2: Ald Combat Companion_1.1.2.xls Combat Companion_1.1.2.xls

Features added:

* Added a Pawn string generator
* Added a sort button to upgrades sheet

Yee, thanks, not that it is that hard to make the pawn string manually, but automated one is awesome, especially calculating sockets

Version 1.2.0 - compatible with new Combat_1.2.0 sheet: Ald Combat Companion_1.2.0.xls

* Some boss drop data is missing where I couldn't find it on wowhead or mmo-champion
* I haven't yet decided how I want to display heroics level sources. For now, they are listed as being "Hard" mode

Version 1.2.1: Ald Combat Companion_1.2.1.xls

* Corrected a few source errors, changed ToC Heroics to use their own sources, added some previously unknown and missing source and type data
* Added a separate axe type
* Updated Pawn to generate socket values automatically and intelligently
* Added this usage notes and changelog page

It's probably worth mentioning that there is no combination of current software that allows VBA execution on a Mac. The older versions Microsoft Office (v.X, 2004 - both PPC code so intel users will be running in Rosetta emulation, thus slow as hell) had VBA capability, but Microsoft removed it in the current Office:Mac 2008.

OpenOffice has never supported VBA, so that's a no-go there. Ald's sheet works fine in both Excel 2008 and the OpenOffice variants on Mac OS X.

Mostly posting this to try to head off the "omg doesn't work on my mac" responses you are likely to get.

Take a look at the link in my signature, I somewhat hacked together a working macro for both Excel and OpenOffice.
It's ugly as hell and it was (and is) my first approach in VBA or whatever, but maybe you can extract some useful information or routines out of it.

Hey, thanks. As you might have guessed, I used your sheet as a springboard for when I created mine in the first place (vis-a-vis putting it on a separate sheet rather than hacking it into the base release and including Pawn strings). I just seem to have forgotten that you built it to be OO capable as well.

I just took a quick look, and see how you have things broken into to sections. Since this basically means writing the OO version of my sheet from scratch, I guess I'll need to take a crash course in OO scripting. I don't suppose you had any particular resource you preferred online?

Hey I added the ability to swap between Horde and Alliance specific gear of the Adriana spreadsheet to your spreadsheet. Thought you might be interested in adding it to your release.

Ald Combat Companion_1.2.1_Replace.xls

When you look up the Name Manager, a ton of the formulas are referencing a "Combat_1.1.xls" workbook, rather than the workbook listed on the options sheet.