Aer

Marklar - in the latest developmental version (warlock_dps_v320a.marklar3.xls) I noticed some of the socket bonus lookup formulas on the Gear_Buffs worksheet were missing, so here's what they should be.

OH cell D45:
Hands cell D54:
2nd Finger cell D78:
1st Trinket cell D82:

 

Marklar

Hmm. Seems I screwed that up a while back. Thanks for pointing that out, I appreciate it. Fixed in current version. Download updated yet again.

 

Dithrica

So I just downloaded the latest version, and it's in Compatibility Mode. Halp?

 

Marklar

The spreadsheet is written in Excel 2003, so if you open it in Excel 2007, you should go into compatibility mode automatically. If this presents a problem for you, I believe you can just resave it as the new Excel 2007(.xlsx) format.

 

Dithrica

I tried resaving it in every avaliable format, it didn't say it was in Compatibility Mode anymore but I still couldn't change anything.

 

Xizl

I'm using Openoffice and can't get the spreadsheet to load my profile at all from the armory. I have changed the settings to allow executable code and activated macros of course.

Anyone have an idea of what could be wrong?

 

Dithrica

Heh, I also had this problem, which is why I switched to Excel and now even that doesn't work for me =(

 

chiyeuk

The latest developmental spreadsheet tells me spirit = 1.31 when using the Life Tap glyph.. this greatly increases the ranks of items that have spirit on it. When I switch out the Life Tap glyph, spirit = 0.99

 

Marklar

Well, it seems a couple of fixes I thought were implemented in my sheet weren't. Since some of them affect the relative value of ISL, they may be of some interest. There's a bunch of other bug fixes as well.

New version posted.

If something doesn't work, feel free to post either here or on the spreadsheet forums. If I can replicate an issue, I'll do what I can to fix it. If I can't, someone else may be able to help. Just please remember to give as much relevant information as possible.

 

Johnneke

Marklar, could you please add the Grimoire's from Onyxia10/25 to the spreadsheet? Would be very welcome.

http://sig.gamerdna.com/quizzes/INFL...ks/missaar.png

 

bazal

I found a couple Items that I had to edit in the Item list:

Wail of the Valkyr and Cry of the Valkyr

Edited them too:

Wail of the Val'kyr and Cry of the Val'kyr..


Thanks for all the great work..

 

Pihaya

I got a question about the lock spreadsheet whichone was updated on 15. October '09.

There are many items, which the sheet doesn't know.
Is there a new lock-sheet ( or new thread ) or when it will be updated?

Thanks for the nice work.

I'm from Eu btw, english is not my favorit : )

 

Kushana

BUG: The procs from Reign of the Unliving/Dead are not included in DPS. Using the maklar4 development sheet.

The procs are calculated in the Trinket Procs sheet, but are not included in the total DPS. DPS procs are supposed to be incorporated at DPS!I42, but currently that's a direct link to the DPS of Timbal's Focusing Crystal (woo!).

The immediate fix is to unhide all TNS-* worksheets (press the Toggle Visible Sheets button on the Notes worksheet), then replace all workbook instances of ='Advanced infos'!$D$38 with =Gear_Buffs!R87. You should have 8 replacements.

UPDATE 11/17: I just realized that while the fix above corrects the DPS, it does not adjust the +1 crit rating correctly. I'll post again when I have a better fix. In the meantime as a rough approximation: using a single ilvl245 Reign adds about .05 to the +1 crit value.

UPDATE 11/18: You can get correct numbers (along with a difficult-to-maintain hacky spreadsheet) by copying the proc formula(e) of the Reign(s) (add the formulae if using two) from the Trinket Procs sheet to TNS-crit!G36. You can make it slightly more maintainable by wrapping that formula in a =IF(Gear_Buffs!R87=0,0,<formula>). This allows you to swap trinkets to a non-Reign without modifying TNS-crit.