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.
* 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.
* As this sheet uses VBA, it is only compatible with Excel, not with OpenOffice. Given that the combat sheet also has this restriction, I doubt this will be an issue.
This is untrue, Aldriana's sheet works just fine in Open Office.
Edit: That said, this tool is not only incompatible with Open Office, it is also, as are other sheets dependent on VBA macros, incompatible with recent versions of Microsoft Office for Mac OS X as well. Just a heads up for those that might not be aware.
Well, the sockets actually aren't automatically calculated at the moment, I have them in the "manual adjust" section.
I suppose I could automate the color sockets, based on knowing that 32 AP gems are best for most people. I had trouble finding a way to calculate the EP of the 3% damage to crits in Ald's spreadsheet, though, so I ended up just back calculating the EP amount that caused my gemmed pawn calc to equal out. It's a pretty big hack, to be honest.
* 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?
So, apparently I failed pretty hard. There was a bug in the macro and a typo in the Replace section. This caused there to be 2 T9 helms equipped while only 1 was equipped. This naturally really inflated dps by providing twice the stats(more, actually since it was the heroic version) as well as an automatic T9 2pc for just the helm. Really sorry guys. Here's the corrected version.