I have a couple of questions and observations.

First of all, can anyone tell me how to get access to the underlying database? I'd like to change the items that have changed in game.

Secondly, it would appear that the night blade has turned into, assuming the approximation used in the spreadsheet is correct, the very best dagger in the game this moment (MH for combat daggers, MH or OH for mutilate). For people that have it, would you estimate the proc buff to be significant enough for this to be the case?

Edit: I'm using open office.

I have been using night blade for a long time Zandig. The proc rate seems to be about every 3-5 hits, (assuming the mob is being hit constanly i.e. a boss.) So the proc rate is signifcant, it is a self-buff it stays on you. I have yet to find a replacement for it, I have not tried this with mutilate, I will try mutilate later on today and get more information about it.

OHHH. Hmm, where on the spreadsheet can I modify that value? In my 5-man parties I think the Hemo debuff is very rarely consumed entirely. Can anyone enlighten me as to the assumptions made about the "400" damage for Hemo?

This isn't used for five-mans, the situation he was talking about was a raid where every charge is used between your hemorrhages. So, that is lost by using a ghostly strike.

Yes, with current itemization I'd say so. I'm not sure with 95dps 1h coming in a few months (arena/t6 instances) but even then the debuff will be massive. Especialy with high armor mobs that we've seen so far in tbc.

In a 5 man, DPS from the hemo debuff is basically negligible; just disable it entirely for a more accurate picture.

PF!

Before you really go, can you add socket support to ranged? I know Doomwalker drops a gun with two red sockets, so it's safe to assume more ranged will be seen in the near future with sockets too... maybe just add support for 3 sockets on ranged or something.

I guess I can update gear and such if anybody has corrections or additions.

Not sure if this is the proper thread or if i might have missed the answer if it was already posted, but i wanted to get some thoughts for combat builds etc and would appreciate any positive input from raiding guild rogues. I'm only looking for PVE info.

My guild has 2 groups that clear kara every week and just killed gruul for the second time yesterday. This week we are venturing into SSC, just to kind of give you an idea of what loot i have access to. My question is, as i know hit and AP to be king for combat maces, but at 70 what % hit should i aim for and how much ap? I have the second lvl mace crafted 1 hander, as well as 2 tier 4 bonus, 2 piece Assassination, dragonspine trophy. I'm looking to get all the haste possible atm as well as hit and crit. I have a pretty large assortment of gear to choose from, around 150 badges ( lol i know thats just meh, but just to give you an idea of amount of heroic gear i have).

Currently all my gems are +8 crit, because i was combat daggers with Malc. I'm looking to replace them and wondering what other end game raiding rogues were shooting for.

As a side note stacking all that haste has greatly boosted my raid dps ( at least in kara so far ) and im looking forward to see how it goes in 25 mans this week. With our normal raid setup on most fights im normally top melee dps with locks, mages, shadow priests, and hunters ( the "on the ball" ones ) all ahead of me. lol so that means in a 25 man im anywhere from 7-13th

Anyways, if you make it through this wall of text I appreciate you reading, and thanks in advance for your input.

Ðisable / 70 Rogue / Overdose / Thrall

Pardon me asking, but am I the only one that have been missing out on the Wastwalker Leggings in the spreadsheet?

If you flask etc and have a battleshout in your raids, your high buffed AP makes hit or crit much more desirable... So much so that I would say you should aim for 25% hit before picking up more ap. Crit is also slightly less appreciated since it is increased by consumabless and LOTP, braided eternium chain, etc.

Don't forget to factor in weapon skill for your hit%. For me it only took about 240 hit rating. Now I am going to try to start picking up crit while maintaining my hit.

Also, be more concious of what gems you are choosing, you broke two important socket bonuses (+3 hit and +3 agi.) Hey, may not seem like much, but when you come on forums and go through the trouble of doing the math this is one of this bigger gains you can get from relatively little work. Good gems come in every color, so try to fill the sockets as asked when they help your damage.

Im also interested in how to balance stats... Currently ive followed shadowpanthers armor dps chart and mings aep .xls blindly. Yesterday i picked up the belt from Chess-event(Girdle of Treachery) and it gave a nice AP boost from ol Bonescythe.

Problem is, all these Kara non-set epix seem to lower critrate...

So my question becomes: Is there a point where items like Girdle of Treachery, in fact become inferior to items like Bonescythe(due to bad balancing, diminishing returns on stats etc), while being superior before this point is reached?

Or can one just say that Girdle of Treachery is allways better than Bonescythe?

And if such a point exists, is there any way of identifying it? (Besides maxing stats like hit, or picking random pretty numbers like 25% crit...)

In response to Disable, I've played around with gems in the spreadsheet, and generally found that for red sockets, you're best using 8 Agil, and for yellow using 8 Hit Rating. You can check my armory profile (should be linked to my name here); I'm running 21.8% hit, 22.9% crit, and 1540 AP. I generally find items with a combination of Agil, Stam, Hit and AP to be the best bang for your buck.

In response to Exog, following someone else's AEP sheet is generally a bad idea. As you'll see if you play around with this spreadsheet, the equivalences will vary as you increase or decrease in a particular stat. Besides some items being better for you at certain levels of gear, they are also better for some builds than others. Also keep in mind that in the case of Bonescythe, you may pick up a couple items that are individually slightly better than the corresponding Bonescythe piece, when you factor in the 4 piece bonus, they can mean a significant downgrade. In my own experience, it took the Edgewalker Longboots to finally crack the 4 piece bonus.

1. you dont need more then 24.6% hit, which is 19.6% hit from gear which is the equivalent to 308.98 hit rating for the cap as you get 1%hit for 15.76 hit rating

2. its bad to have an unbalanced stat layout.

Thanks for the responses ill check it out.

Is there something temporary or "rigged" about your fix, or can we just upload that one to the site and use it full time?

I assumed everyone knew what I meant by 25%, also, that stat layout becomes balanced with buffs... this was the point.

Don't forget to calculate the hit from your weaponskill bonuses.

He actually just copy/pasted it from another 3-socket entry which is exactly what I would have done. It seems to work just fine except that he did not extend the sums on the sockfit sheet to add the socket bonus from the ranged slot. So, the socket bonus does not actually give you stats in his version. Also, the name should be something slightly different as to not confuse it with the version I put out last (2.2.3a would work).

One other thing I noticed that I forgot to add was a 2nd AEP Pawn input string for buffed stats. (the current is unbuffed). That is an easy fix that could go in with it as well. If you want to put this version up Bleedo, I'll send you a cell value that you can copy/paste into it that would work.

Sure

Just on a side note : the stats for the cobrascale hood are incorrect
Spreasheet values : 35Agi, 52Sta, 70AP
Correct values : 37Agi, 42Sta, 18Hit, 74AP
Thottbot link : Cobrascale Hood

Edit : i can't find a way to modify it, does somebody knows how to access the database underlying the spreadsheet ?

http://www.savefile.com/files/574057

Fixed the sockfit sheet to correctly add up socket bonus from ranged to add into main sheet. Stupid mistake, I assumed inserting rows would automatically increment the sum range - but I was adding them after the end of the sum range so it didn't happen.

There's nothing temporary about it - no reason not to replace the 2.2.3 with the now renamed 2.2.3a. It's a minor change that adds a capability that might be required more often in future.

Exactly as Pf said - all I did was copy/paste the socket cells from elsewhere and then back track to correct all the cell references and create new lines where neccessary.

Shouldn't be any reason not to add Pf's cell change for the Pawn string and have an up to date version with Ranged sockets.

Many items have not been updated to their current "live" stats and I believe pf mentioned earlier in the thread that he wouldn't be going through the spreadsheet to fix them. It's easy enough to do on your own by unhiding the appropriate sheet and changing them, but it'd be nice if someone did a complete pass through the spreadsheet to update the items that are incorrect. I've been hesitant to do it myself because changes keep being made to the spreadsheet logic but if we got a 'feature freeze' for a few days for an item update that'd be cool.

Ok i'll try to do that, thanks for the tip.