Since there seems to be quite a few people who want to run the spreadsheet on OpenOffice I just thought I'd upload my version of the spreadsheet, that does work in OO. It's a basic version without any scripts and in principle just a copy of dr_AllCOM3s test spreadsheet posted quite a few pages back (i.e. the version before the beta). The ITEM sheet needs to be in the same directory as the DPS sheet. Whenever you change something in the sheet you should press F9 (to update all cells) a couple of times, the circular refs makes this needed.
Warrior DPS, OO version
Changes from 9.1.6
- Expertise bug sorted, should work fine now
- Rage generation computed for the entire fight => more accurate number of heroic strikes/cleave
- Added Defiance talent (2.3.2 version)
- Changed all Weapon skill to Expertise in the item sheet and updated the dps sheet accordingly.
- Scripts that start when you open the sheet disabled, you should be able to open the sheet with macros enabled.
- No script buttons will work, pressing them should do nothing. You can't load/save item sets or talent setups, and SEP cannot be calculated using the macro (you can do it manually however, see *)
- Some circular ref issues solved, if you run without circular refs and have flurry, the number of instants/sec (that's needed for Flurry calculations) is set to 0.2 (guesstimate).
- Corrected UBW talent, set to 15 ppm (as suggested by Rezarel on the previous page), fast and slow weapons now gain exactly the same amount of rage from UBW.
The circular references will probably mess things up when you run the spreadsheet at first. To solve this do the following:
a) Disable Mongoose on all weapons
b) go to the page Buffed DPS, change Use Circular refs to "FALSE" (cell B12). (-> You should now get a value for the total dps out)
c) change B12 back to "TRUE" (-> DPS will probably rise a bit, it should work now however)
d) Enable Mongoose if you want and press F9 a couple of times to make sure the sheet is updated.
You should only have to do this once when you start use the sheet, but sometimes the circular refs bugs out so you might have to do it again.
* SEP: (1) copying the total dps to the row "DPS before", E107-L107, (2) adding 10 to each of the abilities in the SEP row (3) manually copy the resulting dps after each +10 modification to the correct DPS after, don't forget to change back the 10 before doing next stat. Always press F9 (update) a couple of times between each copy-paste.