Thank you for the suggestion, but checking for weapons with +skill other than the +dagger or +sword is going to be gone in the next sheet. Anyone wanting to use this fix for the current sheet is more than welcome to, but the fix that is applied already in an upcoming version is a much better fix.

Noted. I suppose I can make a new topic upon the next release of the sheet which is still a ways off. I have started the process of merging the two sheets and have made a decent amount of progress on it. I would say that the merging of the two sheets is about 50% done. When all this is done (I'm guessing still a few weeks away), I will post a new topic with new versions. So dont worry about checking in here for new versions anymore.

(posted on the wow rogue forums)

You're a good man Pf, thanks for taking over the project! It was too good to let it retire with Chalon.

Oh, just looked it over(combat swords), Anubisath Warhammer still doesn't have +4 mace skill, not a big problem I edited the weapons sheet.

2nd edit, If I take out 5 mace skill from talents, it still shows +14 skill still, but the DPS total does lower. It also shows a .1 base AP change when I toggle 5/5 maces or 0/5 maces.

3rd edit, Weapon Expertise is adding superficial points in the skill column. Might add in a circumstance for no extra skill if maces. It works out, because a mace rogue wouldn't have WE, it's just a round about way for it to work. Assume someone would want to see what a human with a sword MH with anubisath OH with WE would be like.. Maybe add in some sort of seperate individual weapon skill check that shows +9 mace skill, and +10 sword skill. AQR/Anubisath on a human for example. Not too viable to raid with, but nonetheless.

Using the gear in my sig for the sheet, if you wanted to re-create the issue. (weapon skill adding AP problem)

1 more edit, assuming my gear, it's showing 929 AP on the spreadsheet(sword) in game I'm 932 AP(same as ctprofiles http://ctprofiles.net/2606223)

I assume the overhaul to the +weapon skill in the next update will fix all of this anyway..

Thanks again Pf, I'll keep you updated on the human/mace side of things.

All of this should be fixed in the next release. I did not want to put a bunch of +skill checks across the sheet etc. Try the fix located a few posts above this and see how that works. But rest assured, everything related to +skill problems should be fixed with the next release. I am guessing the AP change you get from removing mace spec is based around crusader and increased uptime with +skill (ie some +hit).

I put in your gear from your ctprofiles link into the sheet and came up with the correct numbers (crit is slightly off since ctprofiles includes +5 mace skill whereas the sheet shows 0 skill on the base crit rate). My assumption is that you forgot to change the cloak enchant. Again, if anyone sees any problems with the sheet, dont hesitate to ask. You might come across something that is not a known issue and needs to be fixed.

Cloak enchant indeed, sorry >.<

Yeah, it was crusader, didnt even know you added support for the increased uptime with +weap skill. Nice.. I kinda of don't like the "false" AP reading (even though in real time, thats what it averages during fights with crusader). I usually turn off weapon enchant on the MH to get my tooltip AP.

So yeah, just waiting for the new +weapon skill, and dont forget to add +mace skill on Anubisath =D

when pickin maces on the sword combat spreadsheet, which talent build is assumed?

Could you add an option for Faerie Fire and Curse of Recklessness?
Both reduce the target's armor, FF by 505 and CoR by 640, together by 1145.
The standard AC amount is 1375 as seen in the Unbuffed DPS & Buffed DPS sheet. Applying both would reduce this to 230.

I have only limited knowledge of excel therefore I fear I won't be able to help.

All the AQ bosses I grabbed data for seemed to be right around 4k armor, for what that's worth.

Also, the armor calculation has some problems, in that it assumes a 60 hitting a 60 - need to change it to use the appropriate formula for 60 vs. 63.

Well, I can't see a differnce in an assumed standard armor value of 1375 or an assumed debuffed armor value with FF and CoR.
I know it can't be 100% accurate since the armor values differ, but that's the same without those two debuffs.

Anybody have a mirror for the most recent combat spreadsheets? For some reason, the download isn't working for me. :(

I have a question regarding the SnD cycle.
Seeing many 800+ DPS screenshots in the sustained DPS thread and even that astonishing 900+ DPS screen from Ifrit (Hallo übrigens ;)), and considering that I cannot seem to bypass 750 DPS on two successive tries on Patchwerk, I wonder if I'm doing something wrong, or rather, suboptimal.
I start with backstab, backstab, tea, SnD, AR and BF (or vice versa, depending on relentless strike proc). Then I work the normal 5cp SnD cycle.
Now my question, with the following scenario:
Due to a ruthlessness proc I have one additional combo point. I have reached 5cp already.
SnD is running a good 10 seconds.
My energy is around 30.
Now, what would be the option yielding the best DPS on the long term.
a) Do nothing. Wait until energy has filled up to around 90 (~6 seconds) and then start over with SnD and proceed.
b) Ignore combo points. Just keep on backstabbing until SnD runs out and then start over.
c) Ignore runtime. Immediatly renew SnD.

At the moment I'm going with option a), but I wonder if I'm "losing" backstabs this way since I don't do anything but white attacks during ~6 seconds. On the other hand, I'm saving that energy for later usage, and I don't know if I'm really wasting some possible backstabs.

Spoon i asked the same question in some thread and I think the general consenus is that A is the correct way to do it. You arn't losing any backstabs because your energy never hits 100 and its not as if you have so much energy that you have problems with the global cooldown.

Love the spreadsheet. Thank you. I have a question about Shadowcraft set bonuses. I have the 4 piece set bonus of +40 AP. It does not appear to pick that up. Do i go in and manually set the flag FM/HW 6 piece set bonus to true.

Not all set bonus's are modelled. This being one of them. If you wish to manually click the +40ap bonus from the rank13 set, you can, however keep in mind once you do this, if you switch away from that you will have to manually change it. When I did the set bonus stuff, I did not model sets that had a +energy proc. So I left out stormshroud/SC/DM cause I have no idea of the procrate on those. I will try to add the +40ap bonus from them in the next release.

Anyway, I am hoping to get the next release out sometime soon (probably another week away). It should be the largest change to the sheets since they were released. And keep in mind, when the sheet is released, I will make a new thread so dont worry about relentless checking this post to see when it is released.

guys i have a small problem, when i unhide the ranged weapons sheet and try to add a line, for example i add at the end "bloodseeker" when i tab or click next cell to add values excell (2003 SP1) crashes... tried it 10 different ways, always crashes, saved it in a slightly different format and opened it again, no luck

it also crashed when i tried to change any buff, or when i try to click the 1.12 evisc. option in combat swords sheet

First of all thank you for this amazing spreadsheet.

On another note I'd like to ask whether it would be possible to add Darkmoon Card: Maelstrom ( http://wow.allakhazam.com/db/item.html?witem=19289 ) to the possible trinkets.

It's so bad that you shouldn't even consider wearing it for raids. ;)

Fill out your profile.

Also, to whomever was asking about shadowcraft... you really shouldn't be wearing any of that stuff if you're raiding.

I don't believe this spreadsheet was ever meant to be a catch all "plug my lolgreens in to see what my sustained DPS on patchwork can be", so that is the grain of salt you have to swallow with this.

Also, FWIW, if you're still wearing SC stuff, try to get into some PUG ZG runs and pick up the rep pieces, or even the "off set" stuff from there, in general they're all going to be great upgrades from the UBRS/DM/Strat/Scholo alternatives, and there are many many guilds running PUG ZG alt groups on the few servers I'm on.

Which rank of Backstab does this Spreadsheet assume? Is there any way of selecting between Ranks 9 (AQ20 book) and 8?

I think the offhand may be adding dagger spec a second time. With my current gear (MC/ZG) switching my offhand from Warblade of the Hakkari to Fang of the Faceless adds a fairly ridiculous 10 DPS to my unbuffed total. Does the +5% crit to offhand melee really make THAT much of a difference?

Edit: Oh shit weapon skill. Disregard this, I guess the weapon type really does make that much of a difference.

It assumes rank 9. The next version will have an option for rank 8 for those lazy people who have not gotten it yet.

Weapon skill on the dagger sheet isn't working correctly right now. You should have +5 skill from weapon expertise for swords, but you do not recieve the bonus making warblade offhand worse than it really is. This as well is fixed in the next version.

wrong button :(

On topic, this is a great tool for many people and I thank you all for your efforts working on it :)