(another) DPS Spreadsheet - Page 35

Bakka · 11/05/08, 4:40 PM

Originally Posted by MooMan65

With regards to the things I reported earlier:

1) I'm getting the same thing happening again on the latest version. A quickest way to reproduce it is using a fresh copy of v303c, change the EA talent to 0/5. The TNS values jump off the scale immediately. I noticed that with EA Corruption's duration is 200, without it's 21. But on the TNS sheets even with 0/5 EA Corruption's still at a 200 duration. The DPS sheet references Models!B11 in the IF statement, while the TNS stat ones reference Models!B6, which is SL's MC contribution rather than the EA figure. So if your rotation included Siphon Life, it actually screws up the Corruption TNS duration figure. If this isn't happening on your machine even with the same public file download, any ideas how the formula could be different on someone elses machine? I've not heard of this before.

3 & 4) It seems to be fixed in the latest version with the used/option in the TNS sheets now linking to the DPS!$B$36 value, but in the previous version it was hardcoded to 0 all the time. That same thing fixed the Dark Pact issue too. Before in v303b the used/option values were hardcoded to 'max' instead of linking to DPS!$B!38.

1. Fixed for the next version. So much easier to track down issues when I know exactly what you're doing. Thanks.

Rozzenwyn · 11/10/08, 12:48 PM

Is Glyph of Corruption implemented in the worksheet? I get absolutely no change in DPS when I select it so I'm wondering if it is working correctly. I am using the very latest version of the sheet as of this weekend. (I forget the number but it was the latest available as of Saturday Nov. 8th). I would expect at least a small change from just the fact that some shadowbolts will not cost mana thus allowing less lifetaps etc. However it doesn't appear to make a difference at all. I would expect as a 0/55/6 spec who keeps up corruption constantly that it would make some difference for me even if it does not effect other specs.

Any feedback would be great. Thanks. I'm currently using glyph of corruption and glyph of shadow bolt. I plan to use glyph of felguard once its available obviously but am trying to determine which of the others will give me the best outcome.

Bakka · 11/10/08, 1:23 PM

Originally Posted by Rozzenwyn

Is Glyph of Corruption implemented in the worksheet? I get absolutely no change in DPS when I select it so I'm wondering if it is working correctly. I am using the very latest version of the sheet as of this weekend. (I forget the number but it was the latest available as of Saturday Nov. 8th). I would expect at least a small change from just the fact that some shadowbolts will not cost mana thus allowing less lifetaps etc. However it doesn't appear to make a difference at all. I would expect as a 0/55/6 spec who keeps up corruption constantly that it would make some difference for me even if it does not effect other specs.

Any feedback would be great. Thanks. I'm currently using glyph of corruption and glyph of shadow bolt. I plan to use glyph of felguard once its available obviously but am trying to determine which of the others will give me the best outcome.

Yes GoC is working properly in the spreadsheet. Make sure you have the NF/GoC Proc enabled under dps.

And in other news I've released a very preliminary wrath version of the spreadsheet: WoW Warlock DPS Spreadsheet