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.
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.
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.
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.
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.