2.3.2.3 is the one dontmindme posted, that's why it says DMM next to it. don't worry took me a bit to get that also =)

~Dreshla

Thank you, MIH. I'm glad you are still updating things when need be. This weekend I plan on adding a couple things. I'm going to add an option for the user to enter their own Armor values and Dirty Deeds percentage. The first so that people can get a more accurate reflection of damage to a particular boss; the 2nd since so many people have their own opinions on how valuable Dirty Deeds is. If you want to call it a 5% contribution, you'll have that option as an override without having to edit the code yourself.

I've isolated the +4 stats issue on my version and in the process have noticed a few other array ranges that might need to be adjusted, lest in some circumstances additional items may "fall off the list". I'll try to get the above changes implemented by tomorrow especially so the JCs get their ring enchants working again.

Eventually, I want to "clean" up some of the code so that skill changes can be more easily implemented. I plan to eventually create a formula page which would be the master reference for all the skill and talent percentages. If all the formulas point to this page, when Blizzard adds a new rank of Backstab or changes any other percent or static damage modifier, one could go to the page, fix the value there, and in one edit correct the entire sheet rather than hunting for every reference. This would be especially useful when the expansion hits.

I'm noticing some unexpected behavior with the DPS spreadsheet. My apologies if this has already been addressed, I didn't find it in the existing rogue threads.

I'm playing with an 11/21/29 hemo spec (note no weapon specialization). All other things being equal (including weapon enchants) I do less damage in this build with an MG Shiv in my offhand than with a regular Gladiator's Quickblade in my offhand. The Shiv has a higher weapon DPS and a slightly faster attack speed. I don't understand why the Shiv would do less damage, particularly because the offhand isn't making any special attacks (which would be normalized with the dagger's 1.7s speed).

What am I missing?

Offhand procs cause mainhand action.. so the sword spec will proc on the offhand but will affect the main hand.

If this is a response to my question, note the part where it says "note no weapon specialization". I don't have Sword Specialization so the extra swings from that don't apply.

Yeah, 200 AP is definitely better than 40 hit, I'm still confused though because I assumed that, raid buffed with 2700+ AP, my hit would become that much more valuable while his AP would become that much less valuable, but it seems that according to the spreadsheet my hit is actually less useful. Spreadsheet issue?

It seems ok on my version, anywhere you can post your copy, maybe I can troubleshoot it.

I wonder if you have a poison on that offhand weapon? If you do, and poisons being a straight % proc, a slower weapon will have less poison procs and less damage, in this care the mutliate offhand S3 dagger, if I understand your situation correctly. Specialization has nothing to do with it, most likely just poisons. take off poisons and the dmg should be nearly identical.

~Dreshla

Hello, first time poster. Long time reader.
Just wanted to alert everyone to the fact that the latest version is not the one that is linked. The link on http://rogue.raidcal.com/ points to RogueDPS_2_3_2_2.xls which is the one without the hemo changes.
If you manually paste the url (or use this one): http://rogue.raidcal.com/RogueDPS_2_3_2_3.xls you will get the latest version and any wild comparisons between old hemo and the new may be done.

EDIT: I see that it is fixed now. Disregard this little post.

Maybe I missed a conversation about this earlier, but what about setting up a talent import macro? My talent build is WorldofWarcraft.com -> Info -> Classes -> Rogue -> Talent Calculator
Id imagine it wouldnt be hard to figure input the correct talents, from extracting the talents in this url?

As I have written before, I have a spreadsheet from another class here, that can even do a complete Armory-import.
If MIH or Dontmindme want to have a look at the sheet, drop me a PM and I'll send you a URL and a short description.
Since the sheet is not publicly available right now i don't want to link it directly in the forum.

I'm looking into this. I think this is the next area I'm focusing my attention.

I think the armory import can happen, but it will take a bit of prep work. I'm going to have to add item ID's to the spreadsheet for every item, gem, and enchant as this is how Blizzard represents items in the armory. I've begun this process, once I have that in place, I'll see about the next phase.

Maybe your hit rating almost reached the cap? Because it also happened to me a few times, then I looked at my % miss and saw it was at 0,04%.

Could you please look at the MacOSX support as well?
The current sheet doesn't agree with my Mac so much when i try to do any form of import / export.

Yeah, I'm not sure if the current implementation of import/export is as stable as it should be. It's prone to errors when the sheet changes. I haven't really looked at that aspect very closely yet, but I'm hoping the Armory import would alleviate any such issues.

As a further note...
2.3.2.4 is now available
The Ring enchant issue is corrected as well as user adjustable armor values. Enter the armor you want in the box. I've included a little chart with a summary of the results of the boss armor value thread. I've also added an Override box to Dirty Deeds. So if you want to value the last 35% of a bosses life as more or less than 35% of your damage output, click the override box and enter the % you value it.

I'm guessing most people aren't really looking for a 0 AEP value for hit rating when they're at the cap. Perhaps the AEP for hit rating should be estimated by subtracting one point instead of adding. In fact, if the sheet added .063% miss instead of using rating points, it would give the "right" value even when above the hit cap. And the same formula would work for expertise.

I've noticed that when i tick the 'hemo debuff' option in raids buffs, my unbuffed Hemo specific dps jumps by about 0.8dps and my unbuffed melee dps jumps by 24. Not sure where this is coming from, is it applying the raid buff to unbuffed dps, is that intentional?

For the buffed dps, how is the debuff modeled, does it just add the +42dmg to each melee attack (and how realistic is this as a debuff, as its unlikely that you will have many of your melee attacks actually buffed by the debuff in a raid (due to the charges being eaten up by others) (currently showing a +32 melee dps buff with the hemo debuff ticked)

I believe so. The "Unbuffed" is intended as an estimate of your likely solo DPS. It therefore includes self-buffs, so the effect of Hemo will factor into it if you are Hemo spec.

Not sure why you see the 0.8 dps change in the "buffed" Hemo-specific DPS when you tick this option - is it recommending a different cycle that spends more energy on Hemo and less on finishers? In any case, you should not tick this option when modelling your raid DPS. As you (quite rightly) point out, you are very unlikely to eat many of your charges in a raid situation. Rather, you should tick the Hemo debuff option on the Talents sheet. This assumes that all Hemo charges are always used by someone or other, and is the best model for raid scenarios. Ticking Hemo on the raid buff sheet as well as on the talents sheet double-counts the debuff and will overestimate your DPS quite widely.

Um, I'm having an issue with the new spreadsheets... Can't find dropdowns to put my items in. I'm probably just overlooking something incredibly simple but... help?

Try scrolling up and to the left. I noticed the last version is saved while on a cell that is quite abit to the right, far enough over that the drop down boxes are no longer on the screen.

I do not know if this is a current issue, but in 2.3.0.2 there is no hit cap.

In other words, you can stack hit into the 400s and still have the sheet tell you its worth more than agility.