Leulier's Warlock DPS Spreadsheet - Page 29

duffry · 07/30/09, 1:29 PM

Originally Posted by Rayvven

It seems I am having the same problem Phearbot is having...

Thank you for the detailed report.

There have been some recent changes in this area due to the changes implemented in the Armory. These have not beed tested (by me) on OpenOffice as yet.

Further changes are likely to go into the next release around dual specs and I'll try and get some cross-app tests and debugging performed.

Issue raised in the development forum and will be tracked from there.
-> DMZ-Gaming / Armory lookup doesn't in OpenOffice

TiaMaster · 07/31/09, 2:41 AM

The Spreadsheet just shows a bunch of "#MACRO"s in most fields for me. Medium macro security in OpenOffice 3.1, latest Spreadsheet version.

Also, No import functionality works, import from armory buttons just don't do anything. Getting 'Scripting Framework' errors from "Save" or "Load" type buttons.

I manually put everything in and nothing changed or populated.

I can't load the website so can't post on those forums.

duffry · 07/31/09, 6:46 AM

As stated above I have not tested on OpenOffice as yet.

If you can't access the DMZ site then our hosts are probably failing on their 99.99% uptime promise once again.

I've not seen it down today though so it should be fine on refresh.

duffry · 08/01/09, 9:57 AM

Version 3.1.3f
Now available for download.

Sheet home

Changelog

Discussion & Development Forum

Primary changes:

Added dual talent spec support
Added Demonic Pact calculator

See changelog for details.

dualaud · 08/05/09, 9:27 AM

Thank you for your continuing effort.
Using the spreadsheet since its early beginnings, and the import from armory function never actually worked for me on Mac OS X using Office 2004, Office 2008 or Open Office.

If there is anything I can do to help the issue, please send a personal message.

elessar44 · 08/10/09, 10:42 AM

Any update for 3.2 coming? Thanks for the hard work thus far!

Also, I'm running into an error using 3.1.3f using Excel 2007. After saving options such as much armory info, gear, glyphs, etc. and then closing the spreadsheet, upon re-opening it I get an error on the damage calculation that stems from glyph of life tap. The trace error function on the gear buffs page points to the glyph of life tap field with a #VALUE error.

duffry · 08/11/09, 2:21 AM

Originally Posted by elessar44

Any update for 3.2 coming?

Yes, absolutely.
I'm currently working on the gear and am looking to get something out asap.

Cinnamons · 08/11/09, 10:10 AM

Originally Posted by duffry

Yes, absolutely.
I'm currently working on the gear and am looking to get something out asap.

You are my hero

duffry · 08/17/09, 10:56 AM

Version 3.2.0a
Now available for download.

Sheet home

Changelog

Discussion & Development Forum

Many changes, see changelog for details.

Known outstanding issues with:

Empowered Imp
ISB
Potion injectors
Toughness (mining)
Master of anatomy (skinning)
Items with the same name but different ilevel
- Distinguishing between them will screw up Armory import, not doing so will possibly screw up calculations

If you would like to contribute to the resolution of these outstanding issues please use the Discussion & Development Forum

Dalmasca · 08/17/09, 2:28 PM

Excellent job on the new version! It looks much more readable and I love the new calculations page! Everything is much easier to track down now, and the numbers seem much more accurate.

Keep up the good work and I'll let you know if I find any errors!

duffry · 08/17/09, 2:33 PM

Originally Posted by Dalmasca

Excellent job on the new version! It looks much more readable and I love the new calculations page! Everything is much easier to track down now, and the numbers seem much more accurate.

Keep up the good work and I'll let you know if I find any errors!

The calculations page is still work in progress and the sheet doesn't drive from that yet. I include it so the maths etc can be reviewed as I go along. Once I have it all laid out and the numbers match I'll swap over to the mechanics/calculations method.

fprefect · 08/17/09, 9:22 PM

I'm lost without this thing. Thanks for your continued efforts and interest in keeping this spreadsheet alive -- it's an essential tool.

Skellum · 08/18/09, 2:03 PM

Thank you so much for updating this. It keeps my pew pew going strong.

longtimelock · 08/18/09, 7:22 PM

Duffry thanks so much for keeping this going, it is my essential raiding tool.

ShiZero · 09/05/09, 9:34 PM

Duffry, your efforts are much appreciated. Thanks for inputting the time into fixing this thing.

However, here's something I found out tonight, trying to decide on which piece of 25m T9 I should go for first:

Both 25 normal and 25 heroic items share the same names, and Excel seems to either be randomly picking one of the two or always picking the Heroic version (what happened to me), which will obviously cause a discrepancy in your results and findings due to obviously higher stats from the normal pieces. I am fairly sure someone else has figured this out and reported it to you by this point, but a nice and quick fix to anyone having trouble with that is to hit the "Items" tab and modify the item names a bit. I added "H" for Heroic at the end of the heroic tier pieces I was researching, and the gear tab now picks up the items correctly.

Just thought I would share my appreciation and findings, in the hopes they are useful to someone experiencing the same problem.

Edit:

Something else that I just found out. [Lightbane Focus]/[Chalice of Benedictus] have sockets and, although the socket is listed in the Items tab for these items, it doesn't show up in the Gear_Buffs tab - probably because the list of OHs with slots is pretty slim and it's possible nobody has added the extra rows under the OH tab before these two popped up.