Yeah, only just got working excel.

Oh well, Latro's does look cool but I don't feel special /cry.

The only reason to use King's Defender over Latro's is to have a purple offhand instead of a blue.

I make my changes and then excel will not let me save it how do I fix this?

This spreadsheet turned even more awesome after I tried it in Excel

Just noticed this Export/Import function. It shouldn't be that hard to read the armory data from a spesific character with a web based tool and import into the spreadsheet? Would be fucking awesome if someone had the time to implement this. Always interesting to compare your own toon to other rogues, but adding every bit of data takes time.

The problem is, when the armory isn't in english, then it is needed a translation table and this would be to big.

And another problem is, I don't know if you can read the gems.

The tools at MMO-Champion.com Armory Guild Tools can read the sheet datas for each character atleast. Should be possible to read talents and the slots for the items atleast?

Does the Upgrade macro not work with Excel 97? The macro halts at:

Listname = Replace(ItemCell.Validation.Formula1, "=", "")

It has done this since version 2.3.6

Hi, while the new dropdown lists breaking weapons up by type are really good, there are a few issues...
Mainly that certain combinations (especially turning PVP off, cause I never PVP) leave you with no weapons available at all.
Mainly I don't think you have enough 5-man weapons listed.
For example, I am Combat Maces. We are most of the way through Kara and have killed Maulgar in Gruuls. Since I don't pvp the _only_ Mace offhand I have access to is the Blackout Truncheon, but this isn't in the list.
I've put it back in myself, but I don't know the proc information. I was going to download an older spreadsheet to look at that, but you don't have any versions to download that are before the change...
So... Yeah, please consider putting slightly more of the "5 man" items back in please...
Thanks.

For the European Armory, you can just select English display, not matter what server you're playing on.

See my profile, German server, English profile.

Is the hit cap on the spreadsheet modeled correctly? I have 306 hit rating and Latro's along with Precision and Weapon Expertise, so my hit cap should be 303. Switching 2 of my Rigid Dawnstones (+8 hit) to Bright Living Rubies (+16 AP) raises my buffed and unbuffed DPS on the spreadsheet, even though my miss chance goes up (hit rating lowered to 290 and no damage socket bonus was affected). I was under the impression that until you are at the hit cap, hit rating would provide the most DPS increase, but the spreadsheet does not seem to support this. Tested this also with removing 3 Rigid Dawnstones which left me at 282 hit rating. Now adding Bright Living Rubies seemed to increase DPS by about 3 per gem, whereas Rigid Dawnstone would increase DPS by only about 2.45 per gem (again, no damage socket bonus). So, are AP gems a bigger DPS increase than hit gems, even if you are not at the hit cap?

I'm using the 2.2.0.5 version of the spreadsheet.

I believe that it depends where you are at with your AP. Hit is excellent, but balance is important and your AP may be low enough that a +16 bump makes more of a difference then a few extra hit rating points. I suppose if your hit is high enough that you only miss a handful of times on a raid, the static boost from AP over that time may be more than enough.

Spreadsheet aside, it's a good idea to try and keep some balance...at least in my opinion.

Suppose you had 290 hit and 100 AP. Yes, 100.. not 1k, not 1500. Would that last 18 hit really help you much? No.. those extra few hits would still be wimpy. Adding more dmg to the ~94% of your attacks you already are landing would be much better.

Now suppose you had 0 hit and 2k AP. Adding hit would SUBSTANTIALY improve your dps as each extra attack that now landed would be huge. Adding AP would be a relatively small percentage dmg increase.

Think of the extremes and you'll realize there is no "X is ALWAYS better than Y". In general, hit is king, but you can overdo it, just like anything else.

Ok, thanks for the comments, I think I have overestimated the importance of hit, at least if the spreadsheet DPS calculations are to be trusted. Just tried changing all my 12 gems on the spreadsheet to 16AP ones, most being 8hit gems currently, here are the results:

Before:
306 hit
1507 AP
671.05 unbuffed DPS

After:
238 hit
1657 AP
678.02 unbuffed DPS (+6.97)

So seems to be a big boost gained from scrapping the hit gems. These results make me wonder, has anyone experienced with their gear setup in the spreadsheet that 8hit would provide more DPS gained than 16AP? Because it would seem from the above that the rule of thumb would be AP > hit, at least when gemming and going for maximum DPS. Doesn't this conradict the (common?) consensus that hit>AP for combat rogues? Or is there some hidden DPS gained by the +hit through combat potency and poison procs that the spreadsheet is not taking into account?

Then again, if you put your gear into Aldriana's spreadsheet (rogue gear spreadsheet) you'll more than likely find that on the 'offensive' setting it will rate +hit and +agi gems over flat +ap gems, in contradiction to what this spreadsheet says.

I'm not really sure what to conclude from this result and it has been worrying me as of late.

EDIT: actually, after reviewing both spreadsheets, making sure buffs and gear for both were identical I found that they both predict +hit gems are better than +AP gems. However the DPS sheet predicts +hit is better than +agi, which is contrary to the Gear sheet, this worries me.

Who cares about unbuffed dps?

and roughly 2 attack power = 1 hit rating = 1 agility = 1 crit rating, with slight changes dependant on total stats, spec, weapons etc. The misconception that hit is a "better" stat is wrong.

With my gear (Mostly Kara/Heroics), +AP gems are the best for increasing unbuffed DPS but the worst for buffed DPS. The contradiction you are noticing from Aldriana's spreadsheet is probably because his has no unbuffed measure (unless you manually turn off all the buffs yourself.)

Edit: premature reply to Ariose, apologies for thread spam.

I think the major difference between the two spreadsheets on the issue of hit is that mine has a much more robust model of procs. While Dragonspine Trophy in this sheet is modeled as a flat +haste effect, my sheet models it as an actual proc - and as effects can't proc unless they hit, these tend to increase the value of hit. Hence, the more procs you have (mongoose, dragonspine, etc.) the larger the disparity you will find between the two sheets.

Hello fellow rogues.

Im long time lurker here in forums and this is my first post.

Ive read through every page of topics related Warp Spring Coil vs. Tsunami Talisman.

There were not clear answer to question which one is better especially to combat sword rogue.

So, in short.

Which one is it?

Considering you're posting in the DPS Spreadsheet Thread one might suggest using it.

I expected little more constructive comment than that, well anyways..

I should have explained little better, ive been using this sheet since 1.x.

This sheet is showing WSC better, but Rogue Gearsheet is ranking TT higher.

Its littel confusing.

Whisch one is correct?

There is no 100% accurate mathematical model at this time, therefore there is no way to tell you which one is correct. My gut feeling tells me that Warp-Spring Coil is better, and my gut feeling also tells me that this spreadsheet is usually reasonably accurate. But really the only way to find out is to just try them. If you can't get your hands on both, I would recommend just taking the one that comes first.