Rogue Gear Spreadsheet - Page 111

Garren · 12/17/07, 8:52 PM

Aldrana, I PM'ed you an alternate method to the LOOKUP command.

• Aldriana · 12/17/07, 9:08 PM

Yes, I got that. I'm busy with work right now, but will try to post an update with it later this evening.

Stickx · 12/17/07, 9:30 PM

Thanks heaps Ald

• Aldriana · 12/18/07, 1:23 AM

Originally Posted by Shaker

Quick bug - the note at the top of the main page implies that 308 is still the hit cap, when this is no longer the case. I'm getting 'odd' behavior when trying to gear out so that the current hit and optimal hit categories are marked RED - in gear that has 0 expertise on it, I am getting 343 as a hit cap (i.e. 342 hit the box is white, at 343 it is red).

For the record: this is just a display bug, that I will be fixing shortly; the hit cap was being computed correctly, the Current/Optimal hit cells just weren't factoring in the hit one gets from Spicy Hot Talbuk.

Originally Posted by Aldriana

Re: Edit: what he was referring to (I think) is a cooldown shorter than the length of the buff; for instance, Mongoose has a duration of 15 sec; if the cooldown on it was 5 seconds, you could still see back to back - and even overlapping - procs. This is certainly possible, although I recall seeing data that made me doubt this; when I get home this evening I'll scrub that data set a bit more and see if I can confirm/deny that.

I checked some various mongoose parses, and have found Mongoose procs for basically every interval of time between 15 and 20 seconds; if there were any internal cooldown at all, one would expect to see a bunch of procs around 15 seconds in duration, and then the rest greater than 15+cooldown settings - i.e., a 5 second cooldown should mean no procs between 15 and 20 seconds. Since we don't see these, I think we can safely say that there is no internal cooldown at all. Or if there is, it's so short you can't tell the difference between a min-length refreshed proc and a nonrefreshed proc, which is more or less the same thing in the end.

Anthony · 12/18/07, 2:10 AM

I was wondering if perhaps you could add a section to the "current" gear list called "none" or something. I have a rogue alt that doesn't get played much, and I'm trying to find the best gear I can get from where I do get to go sometimes. Some of the gear I have just isn't listed. (I'm sure it's because it blows, LoL) But at least that way I could get an accurate optimal and suggested or something. Right now I just have to go and try to find the lamest one listed and tell the spreadsheet I have that.

• Aldriana · 12/18/07, 2:18 AM

You wouldn't want to put "None" in for an item - it's more accurate to have a piece of gear with somewhat incorrect stats than no piece of gear at all. Now, the right solution to your problem would be to just add more pieces of gear to the list, which I don't really want to do to the main sheet but you could do yourself - it's been discussed a couple times in the thread how to do this. However, as a general rule, the gear for each slot includes at least one item that should be reasonably easy to get - quest rewards, BoEs, some of the easier reputation items, non-heroic 5 man drops, and so on. So if I were you, I'd start by trying to get items that are at least on the list to start with - they tend to be better than (and, in some cases, easier to get) than any item not on the list.

Anthony · 12/18/07, 2:31 AM

Originally Posted by Aldriana

You wouldn't want to put "None" in for an item - it's more accurate to have a piece of gear with somewhat incorrect stats than no piece of gear at all. Now, the right solution to your problem would be to just add more pieces of gear to the list, which I don't really want to do to the main sheet but you could do yourself - it's been discussed a couple times in the thread how to do this. However, as a general rule, the gear for each slot includes at least one item that should be reasonably easy to get - quest rewards, BoEs, some of the easier reputation items, non-heroic 5 man drops, and so on. So if I were you, I'd start by trying to get items that are at least on the list to start with - they tend to be better than (and, in some cases, easier to get) than any item not on the list.

Wow, you answered quick! Yeah, you are right... something close would be better than none. I'll have to look and see about how to add an item. My biggest problem is that I played her for a while and have gotten quest items and tossed them because I thought they were not as good as what I had. This spreadsheet and many other sources have told me I was just plain wrong on some of my choices. I was big on AP and that was about it. I've slowly found that sometimes the highest AP on an item doesn't always make it better.

I'm slowly trying to repair all my previous mistakes. BTW, I want to thank you for all the work you've done on this spreadshit. It's been helping me immensely lately.

• Aldriana · 12/18/07, 3:15 AM

Well, I've been reading through the last two pages to make sure I've fixed all the bugs you all have found, so I happened to see your post pretty quickly. Not that I don't spend entirely too much time checking these forums the rest of the time, but that's a separate issue.

Anyway, speaking of bug fixes: I've made a bunch of changes (listed below), but Savefile doesn't seem to want to let me upload stuff right now, so I guess I'll have to wait to post it. I'll try again tomorrow morning before I leave for work, and, if that doesn't work, I'll try posting it from work. If you come up with any more bugs beyond the ones listed before then, let me know.

*Fixed the hit rating display bug
*Changed hit rating to crit rating on Vindicator's Pendant of Triumph
*Added Garren's fix to weapon enchants.
*Fixed a glitch (or at least, I think it's a glitch; I can't tell what the heck I was thinking when I wrote that section) with ring enchants.
*Updated backstab damage numbers for DontMindMe's discovery regarding Sinister Calling (see Roguecraft 101 if you didn't see it go by).

dinesh · 12/18/07, 11:09 AM

Originally Posted by Aldriana

Yeah, I think Excel's LOOKUP works oddly and somehow requires that the data be in a certain order to work (which makes absolutely no sense whatsoever, but there you have it).

From your later comments I think you have this sorted out, but in case it helps you or someone else... yes, LOOKUP requires the lookup_vector or array to be in ascending order.

HLOOKUP and VLOOKUP are alternatives which do not have this restriction.

• Aldriana · 12/18/07, 1:16 PM

Okay, Savefile started cooperating again:

Version 0.9.1, 12/18/07:

Excel Version: Free file hosting by Savefile.com
OO Version: Free file hosting by Savefile.com

roq · 12/18/07, 2:02 PM

Damn I should have come back to the site yesterday, but since it is small, i doubt anyone will notice it. The pvp neck is listed as quest item.

Sekkyo · 12/18/07, 2:54 PM

How is this version recommending Executioner as a superior enchant over Mongoose?

Koosai · 12/18/07, 3:00 PM

Well, since armory was being silly for me I couldn't see all of your gear, but I did see atleast one piece with armor pen. The more armor pen you have the better it becomes, so if you already have a decent amount then Executioner will be better than if you didn't. Also mongoose becomes less valuable as your AP increases, due to a smaller proportional increase in your AP granted by the 120 agi.

• Aldriana · 12/18/07, 4:02 PM

A couple of quick comments on Executioner/Mongoose:

1) Both are currently modeled as 1 PPM, which, based on recent data, is probably not true. However, they seem to have roughly the same proc rate, so their relative value is probably about right; they're both just worth somewhat more than listed.

2) Which is better depends heavily on the total armor pen up on the mob; hence, make sure you have the armor pen debuffs (Sunders, FF, and CoRecklessness) configured as you want them when comparing them.

Offhand, it seems that for 7700 armor bosses with typical debuffs, Mongoose vs Executioner is pretty much a wash; however, for 6200 armor boss, Executioner is a fair amount better. Thus, I personally am of the opinion that Executioner MH/Mong OH is probably the best overall option.

hannigaholic · 12/18/07, 6:12 PM

It also depends on your own passive armor penetration gear and trinket procs (Warp Spring Coil for example), as well as what armor reduction debuffs are active on the boss. I believe it was listed somewhere on this site that you could end up wasting part of the Executioner proc if you already have too much armor penetration (IE you could hit the armor cap)

I'm not sure how common such a waste would be, but the mere threat of it seems to suggest that Mongoose might be the safer bet