[Rogue] DPS Spreadsheet - Page 107

Latito · 01/11/08, 5:41 PM

[Raid] Executioner vs. Mongoose, preliminary numbers
They are no longer "preliminary" numbers.

Dontmindme · 01/11/08, 6:01 PM

Originally Posted by Doink

I found a problem with the 200ap to demons Twinblades set bonus.

Gear_Buffs Z36
=IF(OR(mobtype="Any",mobtype="Demon"),1,0)

Weapons Z68
=44+IF('Gear _ Buffs'!Z36=TRUE,200,0)

Right off I notice that there is no equation to confirm that you have both Warglaives. This should add 200ap to the MH when you're fighting a demon, but for whatever reason my sheet isn't registering 1 = TRUE (at least for this cell), resulting in the 200ap bonus not being calculated into my dps, even with only one of the main hand.

Changing Gear_Buffs Z36 to the following fixes both problem for me, but you're welcome to sleek it up a bit Dmm.

=IF(AND(X36=TRUE,OR(mobtype="Any",mobtype="Demon")),TRUE,FALSE)

Actually already fixed for next version, there was a post about it a few pages back. I noticed the inconsistent set coding when it was brought up that the Warglaives weren't giving a bonus to Demons. I'm actually phasing out "TRUE" and "FALSE" where possible (primarily because using such conflicts with non-english language versions of Excel at times). I'm hoping to post a new version by the end of the weekend. Thanks especially to Pulynerain, there will be some very nice added features. You will be able to designate Gear and Talent sets that you can load on demand. I'll probably include some default sets.

sp00n · 01/12/08, 9:56 AM

Originally Posted by Dontmindme

I'm actually phasing out "TRUE" and "FALSE" where possible (primarily because using such conflicts with non-english language versions of Excel at times).

Actually I haven't noticed any problems with occurrences of TRUE or FALSE yet, and I'm using the German version. Afaik Excel is 'intelligent' enough to replace those expressions with the correct localized ones, just like IF, etc.

Dontmindme · 01/12/08, 12:12 PM

The one time I seemed to notice a problem was an equation where one set an item to "TRUE" or "FALSE" in the coding. I guess what I'm saying is that I'm trying to clean up the code where the code creates it's own Booleans and just use IF(A2) or IF(NOT(A2)) as opposed to IF(A2="TRUE") and IF(NOT(A2="TRUE"). At the very least, it's more compact the first way.

Dontmindme · 01/12/08, 3:23 PM

Originally Posted by Miltrath

I've noticed that when adding or removing serrated blades from the talents page, DPS is affected accordingly, however, the -Armor tallies don't change at all, and there's no entry placed in the -Armor field for talents on the Gear_Buffs page. Is this being accounted for somewhere else, and is it possible to make it more "standardized", and add it to the other totals if so?

Corrected in the upcoming version. I actually forgot I even added that to the page. I was playing around with what I might add to the boxes up there, plugged in some quick formulas to see how it looked. I've now linked the -Armor boxes to the totals on the (Un)Buffed DPS pages which should account for all additions.

Dontmindme · 01/12/08, 5:32 PM

I have started a new thread as this one has become rather long and a new thread will let me update the first few posts to keep the project up to date. If a moderator could, pretty please, close this thread it would be appreciated. For all others, please post in the new thread.