Just for general recordkeeping and such, can keep info about my (or anyone else's) DPS spreadsheets here.
There was a bit of weirdness with Google Docs today, and a bunch of the spreadsheets dropped out of my shared folder for some reason. I think it's all back in place, now.
All spreadsheets have been converted to using a single weaponskill page. Vastly reduces file size, and simplifies maintenance.
Also added new spreadsheet for Bst. Does not cover pets at all, and you'll have to do some manual juggling for balancing out the effects of Pet gear, but hopefully will be useful for general gearing issues.
As usual, let me know if you find any bugs.
Link to Google Drive folder
NOTES
Format
The spreadsheets at the top level are saved using Excel 2007, in .xlsx format. They are usable in Excel 2007 or later, and using the online Google Sheets program.
There is a subfolder called "XLS files for Calc". These versions of the spreadsheets are saved out in Excel 2003 .xls format, and can be read by Excel 2000-2003, LibreOffice Calc, and OpenOffice Calc.
Setup
Items in red text or green background on the Setup page are user-editable, and should be set to configure the conditions you want to use when comparing gear. Red values are usually toggles (eg: Berserk on vs. Berserk off), while green-background cells are parameters for those toggles (eg: how much Enhancing Magic skill the whm casting Boost-Str has).
The user is free to set any of those to an appropriate value. To make it easier to compare Set 1 to Set 2, for most fields the Set 2 version gets an alternate background color if it's different from the Set 1 version.
The "Combined Results" section is just to allow you to get a time-weighted average of two sets, such as one with Berserk up and another with Berserk down. The numbers used are arbitrary, but by default represent seconds (eg: 180 seconds up, 120 seconds down). Anything more complicated than a 2-point comparison needs to be handled manually.
Gear
The Gear page(s) are mostly locked down to prevent stray overwriting of the lookup formulas. There are dropdown lists for all the gear you can choose for a given slot. There's an extra line that holds set bonuses for various combinations of gear (eg: the Thaumas set) that is automatically determined, so you don't need to do anything special for that.
In addition, there's a Custom line for each set group that allows you to put in arbitrary values for each stat, and can be used as you see fit.
All gear is entered on the Gear Lists page. If you wish to add another piece of gear, you may do so by inserting a new line between two existing lines in the gear group you wish to add to. For example, if you wanted to add a Rank 10 Manibozho Brais entry, you could insert a new line between the Rank 2 and the Rank 15 entries, and fill in the appropriate augmented values.
Do not add a new gear item at the very beginning (ie: between the header line and the first real entry) or very end of the list. If you do so, some of the named ranges won't expand properly to include it. If you need to re-sort the list, you can do so after inserting the item within the normal group.
Analysis
Almost all calculations are contained in the Data page. If you need to figure out why a given gear change has the effect it does, such as differences in hit rates, or crit rates due to dex, etc, you can examine this page to figure out how everything's being calculated and put together into the final DPS value.