The Option "Include Hemo DPS Estimate" isn't working when I use Sinister Strike or under Raid Buffs the Option for Hemo debuff is missing. S at the moment the gain from Hemo Debuff for a combat rogue isn't fairly good to calculate.

Uh, that's because SS doesn't trigger the Hemo debuff. Unsurprisingly, to trigger the Hemo debuff, you need to use... Hemo!

Unless you mean you're using Hemo, then switching to SS till the charges are gone, then using Hemo again, etc. In that case, the charges are being used so slowly that the added Hemo DPS is negligible in context. The only reason to tick "Include Hemo DPS Estimate" is if you're in a raid with sufficient physical sources of damage that all Hemo charges get used as fast as you put them up. In which case you're spamming Hemo and not using SS.

At the moment it is set fix to 2,06 when thes gem is in the equip. Mo changed this because of the topic you linked.

Well I nether looked for this formular so far. Maybe I should read that topic sometime.

@the rest, I'll take a look

maybe there is another person in the raid who uses hemo?

Irrelevant. Only the one person using Hemo should tick the box. Otherwise you count the same damage multiple times.

I think people are misunderstanding what the 'Include Hemo DPS Estimate' box actually does.

It's not there to tell you how much having someone in the raid using hemo will add to your personal DPS. It's to show, in addition to your DPS (while using hemo), how much DPS you're theoretically contributing to the DPS of other physical damage dealers in the raid.

I must say Ellos, I am impressed. The Gem upgrade and All upgrade buttons are fun to just click and watch :P

My only two requests:
1. Is it possible to sort the results in the comments after clicking the upgrade buttons? Either by buffed or unbuffed dps? (Preferably buffed or an option for either )

2. Is there a way to remove all the comments at once aside from deleting them one-by-one?

Thanks

Hello, thanks for those great updates

Here are some things you could check for the next version (some may have already been posted):

* Macro: Wrong subroutine for the EnchantUpgrades macro, it should be "Call UpgradeCheck(36)" instead of "Call UpgradeCheck(35)" for the shoulder enchant upgrade.

* Buff: Thistle Tea is broken, the value should be "1" instead of "True" in the cell Q45 of the Buffed DPS Sheet.

* Buff: Flame Cap is broken, the value should be "1" instead of "True" in the cell Q47 of the Buffed DPS Sheet.

* Buff: Elixir of Major Agility is broken, it should be E112=B112*35 and G112=B112*20.

* Buffs: Useless Lists could be removed in the Gear _ Buffs sheet: Cells C85, C86, C87, C125, C126, C127, C128.

* Error: In the Unbuffed DPS Sheet, the name of cells J18 & J19 is inverted (finmiss <-> findodge), don't know about the impact of this mistake.

* Change: Exact formula for Dodge/rat is 12*82/52.

* Change: Exact formula for Haste/rat is (10-10/3)*82/52.
(In a patch Blizzard reduced the amount of Haste needed to get 1% by around 50% (@ lvl 70); it was done by reducing the amount of Haste needed for 1% @ lvl 60 (which was 10) by 33,33% (i.e.10 - 10/3)).

Don't know if its been mentioned yet but:

* Error: Weapon Sheet - AA231 "Twinblade" is on Vindicator's Brand line - Should be at AA232

The upgrade funktion was Arioche's work, I had only added this to the offical Version.

to 1: Well, it would be possible, but I think it's to much work for to less function. I won't do this.

to 2: I'll look, it won't be huge work I think, only another button.



We'll look at the errors, some are already done, others will be doen in the next days, thanks

Is it possible to turn off the set bonuses easily? Currently just messing with the equation in it to "turn it off" so to run the upgrades on purely the gear itself.

Short time reader, first time poster...

First off, great spreadsheet! Many kudos to all you guys who put the effort into making it as accurate as possible! Well done and keep up the great work.

A couple questions about Sword Spec:

I know SS, SnD and Rupture are all key components to max'ing DPS...but is there any room for Shiv in there? Especially on long Boss fights, aka Gruul?

I like to put Deadly Poison on OH and Instant Poison on MH...

Keeping SnD and Rupture ticking as much as possible...

For SS, should I just spam that till the cows come home...or does it makes sense to get some Shiv's in make sure Deadly Poison is ticking away too?

Furthermore, when I put IP/MH and DP/OH into the spreadsheet, it rates much higher than WF/MH and DP/OH.

Was this always the case? Seems Sword Spec benefits very greatly from WF procing as often as it does.

Sorry if these answers already posted...

You are looking at unbuffed DPS. The unbuffed DPS does not count Windfury, but does count your poisons. Take a look at buffed DPS (scroll to the right a little bit, if you're looking at the Gear & Buffs sheet). Windfury is a massive DPS upgrade over IP.

Regarding Shiv: no. Just don't do it.

* Change: Exact formula for Dodge/rat is 12*82/52.

* Change: Exact formula for Haste/rat is (10-10/3)*82/52.
(In a patch Blizzard reduced the amount of Haste needed to get 1% by around 50% (@ lvl 70); it was done by reducing the amount of Haste needed for 1% @ lvl 60 (which was 10) by 33,33% (i.e.10 - 10/3)).[/quote]


Good, confirmation:
And fyi 10-10/3 = 30/3 - 10/3 = 20/3, thus making this equivalent to 20/3*82/52 as originally posted.

New item: Band of Eternity 3d (Revered) Band of Eternity - Items - World of Warcraft

Band of Eternity
Binds when picked up
Unique
Finger
+29 Agility
+43 Stamina
Equip: Increases attack power by 60.

Already in.

Tomorrow I'll post the new Version I think. I have to do one or two thinks then it is ready.

One important think: The import will not work with the next version, there are some changes that it won't make downgrade compatibel. (Changes for Gemnames & Changes at the import/export Macro).

And I have to think if I'll partition the Gems, but no Idea how at the moment.

I just downloaded these spreadsheets and am not really sure how to use them. I went into the talents tab but couldnt find a place to plug-in my talents. Is there a guide on how to use this somewhere? Thanks.

First, I love this spreadsheet, and I'm using it. Pre-BC I found the rogue DPS spreadsheets quite helpful with DKP decisions. With so many more choices (on what to socket) I'm finding the spreadsheets even more invaluable post BC for making better decisions on just what to put in my sockets in addition to what gear upgrades make the most sense.

Now.. I have a question related to sword spec:

Zelios, earlier in this thread, posted that offhand on sword spec can proc mainhand attacks-- now, I took a long break right when BC came out, but I thought I heard that sword spec was getting a nerf & that the offhand would only proc offhand attacks.. so if so, the sword spec DPS probably wont scale quite as well...

Can someone please confirm/ deny this:
Sword spec is/ is not getting patched so that the offhand will only proc offhand attacks (instead of mainhand attacks)

I haven't heard anything that offhand swings will proc offhand attacks.
Sword spec is being changed, but only in such a way, that it won't proc any other instant attacks anymore.
Whether these are only other sword specs, or also windfury and poisons, is currently not known though.

Well basically it comes down to 5% crit for special attacks - including windfury - versus the 212 haste rating proc of the mace.
Additionally, you would either have to chose between mace spec and weapon expertise, or take all of them, mace spec, weapon expertise and sword spec, which is a rather heavy investment (takes that last two points in e.g. vile poisons also away).

Since I don't know how the proc rate for the mace is, I have no idea, but I suppose that the fist would be better.
What does the spreadsheet say?

Is anyone able to confirm if OH swordspecc still can procc MH extra attacks on PTR 2.2?

I hope I hadn't forget anything


Note:
- On the right site are now Options. Only the Item from the location that are marked will be seen.
- Weapons only the choosen Type (and location of course)
- Import Equip/Talents/Buffs of an older Version may break the Spreadsheet

New Version (2.2.0.3):
http://rogue.raidcal.com/

Changelog

2.2.0.3 (ellos)
added
Gear Options (Itemchoose based on droplocation)
Feint every 10 seconds (only the Energy cost)
Metasocketcontrol for AEP

Changed
Dodge/rat and Haste/rat now use exact formulas
Export/Import subroutine. Hopefully the last change for a long time
Subroutine for Gearupgrade, now MinimumDPS and fxied buffedDPS

fixed
Socket 2 for Neck


2.2.0.2 (mih)
added
Band of Eternity 3rd
droplocation of all items
gem stats in gem names

fixed
Elixir of Major Agility
Thistle Tea
Flame Cap

removed
many low level items
some useless cells

Could you re-add [Drake Fang Talisman]? Maybe under a "pre-tbc-60" tab along with some naxxramas trinkets / enchants. ([Might of the Scourge], and [Slayer's Crest] for instance)
It is actually better than the hourglass of the unraveler, and i know a lot of rogues still use it.