Just a quick question about something I saw recently on this forum. The item upgrade assumes all items have no gem slots? that seemed to be the gist of a comment earlier. Just need a clarification when time allows. Thanks much.

~Dreshla

Ariashley --- I fixed those non-calculation formulas last night as part of my Buffed/Unbuffed DPS sheet brush up. I'm guessing they are there so people can look at what their max damage could look like, maybe...since its against a 0 armor opponent. I figure it's there, so maybe people use it, might as well fix it (was a rather low priority but since I was looking over a couple other things on that page...).

Dreshla --- Actually it's a fair bit more complicated than that. The upgrade function uses the gems as they have been saved on the sheet. So, if a particular gem is in the first slot (even if it's grayed out because that item doesn't have sockets), that gem is used for calculation purposes for other items when socketed. It's really probably not the best solution (and hence the previous discussion). Much of the time it's going to work out as rogue sockets tend to be very similar in terms of order, especially if you are using Orange gems, you will often get the socket bonus active (since the spreadsheet does not discriminate on gemming order). It also works out for socketless items. Unfortunately, it doesn't work so well with items that have sockets in a strange order or different colors than what's currently socketed. Now, with Armory Import, that function actually blanks out non-used sockets (behind the gray) which further muddies it's value, as when you have equipped a non-socket item, socketed items won't be showing the benefit of gems being socketed at all. (Unless the Macro does more than I believe it does).

So, in some ways, you still benefit by selecting items individually at times, and personally selecting the appropriate gems to maximize DPS. The suggestion was to improve the Upgrade function to perform some of the selection process automatically.

Ok, the bug fix version 2.3.2.9 should be posted in the near future.

Scratch the Mac tests...I think I'm onto the issue and may have a Mac fix for the Combo boxes this weekend. Looks like I'll have to write a workaround as Excel for Mac does not support OCX control features but there are commands that are usable with Combo Boxes that can substitute. This won't help Armory import, but all the other Macros should still be able to be used on a Mac.

Am I right in thinking that the planned change to -armor AEP will result in a better rating of the Executioner enchant? When I apply Executioner instead of Mongose in the Rogue DPS Spreadsheet I get a -7 DPS difference, but when I do the same in the Rogue Gear Spreadsheet I get a +7 DPS difference.

Insightful, perhaps you'd like to explain?


This would make me think my original post is right, but I know I jumped to a conclusion as well and am willing to accept that it's possible I might be wrong as well. I mean, I'm not a spreadsheet expert by any means, so I don't want to start pissing off the guy who is trying to help the community.

We all know hit rating is ridiculously good for combat rogues, and after being reminded of that, I took a step back for a second. Anyway, time to check out this fixed version and see what I get.

There was originally a post that advertised gold selling or player rentals or something, never did click the link. It was apparently deleted.

That makes a bit more sense.

The download link is missing from the opening post.

Ok, so I have a test version for Mac users using Excel for Mac (at least those that did support VB). I have removed all the controls except the Combobox for talents. I need to know if Mac users can use this to change their talent builds from the pulldown. Should this work, I should be able to restore all the rest of the functionality for the use of those comboboxes throughout the sheet.

RogueDPS_2_3_2_9test.xls

and hmm...looks like I deleted more than I thought when I copied new version info on the front page...

As was pointed out to me when I raised this issue, it's basically because the sheet has to model specific cycles and it's simply that SnD cuts have not been modelled for Mutilate builds. As Improved Slice and Dice does not actually change the cycle the sheet simply assumes that the cycle takes longer (since SnD is up for longer). You'll notice the exact same thing happening when using the 2-piece Netherblade set bonus.

It will still give you the right gear/gemming info and you can simply cut SnD yourself and at worst you'll get no more dps than you would if you didn't take the talent.

Modelling Mutilate cycles is something that seems very difficult to do since the very nature of the build is that it is highly proc-dependant. You can have a 2-4s/4-5r cycle that could take take only 14 seconds to complete and yet generates up to 26 seconds of SnD time. The same cycle could either take 25 seconds to complete or only generate 18s of SnD (even with Improved SnD).

All things considered, the sheet does a damn fine job of modelling a very difficult-to-model talent build.

S3 sword and swordspec shows as higher DPS than the mace / mace spec for me. Are you sure you've entered it right?