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.
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...
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.
So I just downloaded the latest version, and it's in Compatibility Mode. Halp?
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.
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.
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.
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.
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?
Heh, I also had this problem, which is why I switched to Excel and now even that doesn't work for me =(
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
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.
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.
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.
I think there is an issue in the way glyph DPS is calculated. I'm 53-0-18 aflic spec and Glyph of Conflagrate shows up as a 96 DPS improvement.
That's only true if conflagrate usage is set to 1 on the DPS sheet. (Pro tip: conflag is not available in a 53/0/18 spec). I tested my gear + the stock affic build in dev sheet 4, and your gear + spec on 3.20a.
While the spreadsheet does automatically set conflagrate usage appropriately when you load talents, it *is* possible to ask it to simulate impossible rotations and builds.
There is no "load glyphs from armory button" and when I set up the sheet v4 initially, Conflagrate was selected without me having done so. I understand that conflagrate isn't available in my build, but I still think it is an error for the sheet to allow impossible selections that result in higher DPS. If Someone that doesn't really understand their spec is trying to figure out the best glyphs for afflic, Conflagrate is listed. To me that's an error.
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.
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.
Could a mod please add this updated source for the only available lock spreadsheet. Leulier.com is just an empty site now. took me a while to find this link
I am having some trouble getting the newest version to work in Open Office. I have set the security changes to medium and even to low, and double checked to make sure it could run all the scripts through open office support, but my load talents from armory macro is not working. I am also seeing #macro? text on some of the other tabs. Please help?
@ ferbragga: Marklar had taken over, but I'm not sure if time is permitting him to continue work on the project. A quick fix is to copy and paste the cells marked custom (in the item tab) under each gear slot so you have a few extras. Then as you see gear that you are interested in you can in enter the stats. That way you can compare the gear and get a rough idea. It doesn't change any of the calculations under the hood though. So for that you will have to wait for Marklar or someone else to update for 3.3
I've been updating for 3.3 for my own use, mostly data entry for new gear.
Anyone know how you'd go about duplicating the calculations for T8 4 pc set bonus for the T10 2 pc bonus? It should be easy to copy, but I'm missing something.
1) Add the T10 items to the Items sheet. Add them to the middle of a section to have Excel automatically expand the ranges. Ensure they're identified as T10 in the Set column.
2) Add the lines for T10 in the Advanced Info sheet. The easiest way is to copy, insert, and modify the lines from T8. Change the Value column formulae to reference "T10" instead of "T8". Change the descriptions.
3) Change the names of the two value cells to T10_2 and T10_4. You can do this in Excel 2002 by clicking on the cell in question and editing its name in the Name Box.
4) The reason T8_4 is relevant is that its bonus is, "Increases the critical strike chance of your Shadow Bolt and Incinerate spells by 5%." So let's find all the places it's used. Using Ctrl-F across the worksheet, you'll find it's used in three places (Incinerate, Incinerate without Immolate, and Shadow Bolt) on the DPS sheet and all TNS-* sheets.
5) Do a global search and replace +5*T8_4 with +5*T8_4+5*T10_2. You'll have 27 replacements. That's Incinerate and Shadow Bolt covered.
6) On the DPS and each TNS-* sheet, add a +T10_2*5 element to the SB damage calculation, right after devas*5. You can't do this globally. That's Shadow Bolt covered.
7) On the DPS and each TNS-* sheet, change the Corruption damage calculation so that crit+malediction*3 is changed to crit+malediction*3+T10_2*5. You can't do this globally. And that's corruption covered.
i've added the new items from ICC to my spreadsheet, you can find all the items in comma separated value form on this post i made on the dev forum for the spreadsheet: DMZ-Gaming / CSV for new items in patch 3.3
you can load it in excel and pretty much just copy/paste into the current spreadsheet. you need to add the Tier10 stuff mentioned in Kushana's post above.
10/09/09, 4:45 PM
evelopmental variants - DMZWiki
Similar Threads
