Maybe I'm behind the power curve - I just noticed on the latest AEP calculation that:

Agility 1.00 AEP 1.00 AEP 1.00 AEP
Strength 0.59 AEP 0.49 AEP 0.54 AEP
AP 0.59 AEP 0.49 AEP 0.54 AEP
Hit 0.97 AEP 0.15 AEP 0.56 AEP



Buffed, hit is worth 0.15 AEP???? And agi is worth more than hit? I was under the impression that hit rating was the #1 stat for rogues. At the moment I raid with 277 hit unbuffed. I ask because another rogue in the guild has about 40 less hit but about 200 more AP and pulls ahead on the DPS by about 1% thru long fights, am I nerfing my own DPS by socketing mostly hit?

Really?!

I'll to the math with my gear to see what it would come out to...

Garrote 8
810 damage + 18% AP (+20% talented)
50 energy (30 energy talented)
1 CP (1.75 CP talented)
Can't crit
ignores armor

Sinister Strike 10
instant attack + 98 damage (+16% talented)
45 energy (40 energy talented)
1 CP
Can crit (+30% crit damage talented)
mitigated by armor (3950 armor assumed)

My stats buffed according to spreadsheet:
AP = 2781
MH = 254 avg damage
Crit = 26.21%

Untalented Garrote:
810 + ( 2781 * 0.18 ) = 1310.58 damage
1310.58 / 50 = 26.21 damage per energy

Talented SS average:
( ( ( 2781 / 14 ) * 2.4 + 254 + 98 ) * 1.16 ) + ( ( ( ( 2781 / 14 ) * 2.4 + 254 + 98 ) * 1.16 ) * ( 2.3 * 0.2621 ) ) * ( 1 - ( 3950 / ( 3950 + 400 + 85 * ( 73 + 4.5 * ( 73 - 59 ) ) ) ) ) = 1158.27 damage
1158.27 / 40 = 28.96 damage per energy

For clarification on my formula for SS it's SS damage + SS crit damage considering crit chance then mitigated by armor. The individual values are as follows for this formula:
24.83% armor mitigation ( 75.17% damage post mitigation )
961.34 SS avg damage
579.53 SS avg crit damage per swing

Hum, yup for me SS is better maxed out then garrote. Let's see how things fair when garrote is all talented out (minus lolstep)

Garrote talented average:
( 810 + ( 2781 * 0.18 ) ) * 1.2 = 1572.70
1572.70 / 30 = 52.42 damage per energy
30 / 1.75 = 17.14 energy per combo point

So, if I take 5/5 Opportunity, Initiative 3/3, and 2/2 DD Garrote becomes significantly better... otherwise SS is a better choice for an opener. Actually just taking 5/5 Opportunity makes Garrote come out better then SS, not by much ends up being 31.50 damage per energy.

Comparing my dps from the two most recent versions (same combat spec and gear) I notice a loss of about 70dps buffed. I couldn't figure out why until I noticed the 'AC amount' value was changed in cell Q-41 of the DPS sheets. Just curious if there was a reason for this change.

2.3.2.2 (mih)
fixed
Human racial 5 expertise instead of 5 rating
Tsunami Talisman

changed
hemo debuff (42 instead of 36)

MIH, is there some reason you feel it unnecessary to fix the clearly wrong formula for backstab? I just posted a sheet with that correction and more. All very reasonable corrections, and yet you decide to post your own, ignoring fixes that have been mentioned for nearly a month. I altered Armor to make the best established knowledge of the EJ community. I fixed a number of incorrect item stats. I fixed Backstab with the clearly screwed up formulas and fixed the issue with some of the additive talents. Fixed Hemo where it properly does not gain its own benefit. (Test this yourself, its simple, equip a low-range weapon, open up with Hemo, attack again with Hemo and you will see that the Hemo attack does not benefit from the Hemo debuff). I fixed the item bonus sheet so that the Item Compare sheet will work with many items its not currently working with...yet you seem to think it prudent to ignore all this and post a less accurate sheet. What gives?

The reason I made this change in my version of the sheet was because it was more accurate. If you refer to research on these forums, you will see that almost all bosses have armor of either 6200 or 7700. The sheet was just declaring Armor to be a base 40% reduction or about 7038 or so Armor. So, for many bosses 7700 will be much more accurate, although for some you'd want the base value to be 6200.
[RAID] Boss armor values

Now, I've been thinking about adding a box so the user can set the Armor to the boss you are interested in based on research in that thread. I think it would be nice to have the sheet calculate values for the specific boss you are interested in (i.e. Rupturable? Poisonable? How much Armor?) so one could compare their build to the boss they are stuck on in progression and even so one could optimize their talents to down that one troublesome boss.

Now, I know that no one has officially decided to take charge of maintaining the sheet, but given that I've been modifying my own sheet, I'd be willing to maintain it for a little while, while at the same time making the calculations more accurate and possibly adding a new feature here or there.

Yeah, good point. If the mob is mangles your garrote just gained 30% damage pushing it 34.08 damage per energy. That's a big jump in damage. I won't bother with a talented garrote, as it's already better then SS w/o mangle.

So, good rule of thumb... if the boss is mangled garrote away! If not open with a ss.

Well, Im not sure on the aep calculations, but, Id trade 40 hit for 200 ap pretty easily. In fact, I think Id trade 50-60 hit for 200 ap. It definitely is not a gem socketing issue here, 200 ap is worth mare than 40 hit.

200 AP > 40 Hit, of that there can be no doubt.

As for the weird number on your buffed Hit AEP, the only reason I can think of is that your buffed Hit Rating is just below the Hit cap, so that last point of Hit barely makes any difference. But the numbers you give don't add up. Even with all the Hit buffs, and 277 unbuffed Hit, you'd effectively have 344 Hit rating.

i only read "New update with Hemo 110% and 10 charges of 42 damage..." and don't check any changelog. big sorry
ur version is available @ http://rogue.raidcal.com/

so which spread sheet is the most accurate, 2.3.2.3 or is it the one dontmindme posted?