Try unchecking the Talents box. Some major changes were made to that page which makes Importing them probably not work. The rest should probably work.

I saw that at some point and was wondering the same thing. I have a few questions regarding Sword Spec.
1) Can it miss, be dodged, glance etc.?
2) Do offhand procs reset the main hand swing timer?
3) Any other special considerations beyond the obvious?

I figure if I'm going to change it, let's try to get it right...
I did a search and didn't find that in these forums. Not saying it isn't there, just might not have the right combo of keywords.
I'll have to see what the latest combat log I have says...

Regarding Sword Spec Procs:

-- Can be found here.

This means that 1) Sword Spec procs can miss/be dodged/glance, and 2) Off-hand procs do not reset the MH Swing Timer. I'm not sure about your #3, but I don't think there's any special behavior except that as of 2.2.0 extra attacks from Sword Spec cannot proc more extra attacks.

Yeah, I just checked a combat log. I see what looks like misses, glances, dodges etc off Sword Spec attacks. No effect on the swing timer. So, I guess I should fix that. Think that's all the answers I need.

I try not to go by patch notes (instead look for actual testing) as they have been found wrong in the past. Looks like they got that one right though.

i have downloaded the program (had it working in the past), but it doesnt allow me to choose my daggers under gear nor does it use backstab as dmg source although i have changed talents.
is there a general switch or something like that?

I'm guessing that Y54 in the gear buffs tab isn't set to daggers.

If you can repeat this and hover the curser over oldpath and tell me what the value is, that would be helpful. And specifically what error are you getting trying to import from the armory?

I've created a list of ideas/wishes for the spreadsheet. Some are minor, some major changes, but I think each of these would help improve usability and benefit.

1. Remove Resilience, Dodge, Defense and Parry from the Gear_Buffs sheet. These stats are utterly useless for a DPS spreadsheet and use up space which could be used to display the options (update search, equip, etc) properly.
2. Derived from this, relocate the options menu *somehow*.
3. Add (or replace the current Dodge) a 'Chance to be Dodged' column to the top overview (since the introduction of expertise).
4. Highlight the several equipment slots to be better seen on first sight. Currently I simply set the background color to red on the A column, there may be better ways.
5. Add a 'fast swap' function to easily switch between two (or more) talent builds. Similar to the Save DPS button (you define one talent build, save it to slot 1, create another one, save it to slot 2, etc).
6. Add a sheet which contains gear upgrades. Not the current one, as you have to select the gear manually there, but a sheet which basically only contains the already present comments when you click on 'Upgrade'. Now, instead in the comments, they show up in a sorted list on another sheet. (Big help for me, as currently I do this by hand to see how much DKP I should/could spent on the certain items).
7. You can remove the AEP gear comparison links to my page I fear. I don't have the time to update the list anymore.
   However, you could do such a list by yourself, since you a) have all the item data and b) can calculate the personalized AEP already. Just create *another* sheet () with a sorted list of all equipment (similar to #6 and the search upgrade function).

That's it, I'd love to see some of these ideas implemented, as at least for me they would be a great addition to the sheet.
I'll take a look if I can do some of the work for myself, but I have zero knowledge of Excel macros so I doubt I can do much of the really interesting work.

With MS Excel 2003 on Windows XP (my work computer environment) it did not work at first. I had to download and install MSXML 6.0. This machine is relatively clean, since I got it less than 6 months ago. It is likely that people using older versions of Excel who haven't somehow installed MSXML will need to do so now to get the armory import script to work.

As an aside, for some reason WoWArmory doesn't currently have my profile up, which threw me for a loop for a second. If anyone else is getting the error "No itemdata available!" during the import script, that is NOT an XML error. It's a WoWArmory error. If you go directly to the armory site and search for your character, you'll probably see something like:

"Character Data Awaiting Refresh: It seems like the character you are trying to view hasn't been active for a while. Since the Armory only tracks active characters, this character needs to have been active recently for detailed character data to show up."

When I tried it with another rogue in my guild whose armory was showing up properly, it worked fine. (Also, apparently 3 days is long enough to get your character dropped on the inactive list...?)

So in 2.3.2.4 and earlier, Shoulderpads of the stranger were listed as a big (around 9 dps) upgrade.

In this latest sheet with no gear/talent changes they are only shown as a 1dps upgrade.

What gives?

As far as I can see, changes have only been made to Sinister calling, Deadliness, Hemo, seal fate and haste (As well as some statpoint changes on a few items). If either of these are involved, it's probably caused by a change in the stat weightings.

Longtime Lurker so first the standard thank you to maintaining such a fabulous tool.

The Umbral Shiv (dagger from Za) does not appear in the drop down lists for daggers. This was true in the 2.3.2.6 version as well as the current 2.3.2.7.

Thanks!

No changes in buffs or boss armor values? Are you equipping the said item with the same gems, or are you just running the item upgrade macro? If not, are the gems in B37:B38 greyed out and different in the two sheets?

Dmm probably stealthchanged something, because I'm out of ideas

I'll disagree here--I use the spreadsheet to evaluate PVP gear as well. Obviously the Patchwerk-style DPS model hardly applies to a PVP setting but its good for me to see some of the trade-offs between AP, STA, and resilience. In my opinion, balancing those stats can sometimes be a trickier problem to solve than the one-dimensional problem of "which piece is more DPS?"

Appears it was a gem issue, thanks for suggesting it.

I've been having the same problem all extended weekend. Pretty weird for playing almost every day. It seemed like almost half the Rogues I tried to check had similar problems. Not sure what's up with that. I've been chalking it up to holiday hiccups. But this is something people should check if they are having problems.

I agree that Resilience as a stat has its right to exist, however Dodge, Parry and Defense definitely do not. These stats are so extremely rare on rogue gear now anyway that it is just a waste of space to have them listed at all (we are not on T2 anymore).
As for Resilience, you could have that functionality in an sorted AEP-list instead of the Gear_Upgrades sheet.


Pawn itself has nothing to do with my site, I just proposed to include the string into the sheet for easy copy&paste into the game.
It's the both links to Compare Equipment - Rogue that you can remove, I haven't even updated it to expertise instead of weapon skill yet.


Back in the days I've found the conversion to be Base Agility (naked) - 11.5 / 40, so for a night elf (163-11.5)/40.
This thread doesn't exist anymore in this forum*, but you can find it here: Google Cache



* Where have all these threads gone anyway? I cannot access the Class Mechanics Archives section anymore, it says I have no permission to do so. Google Cache says it's a version from 30th Nov. 2007, so it can't be that long ago since the forum was pruned. I find it really a pity that all these valuable information are lost now for the broad public.
Just opened another thread for the archives issue, answers should go there I suppose: Where have the Archives gone?

Downloaded the latest version and I noticed that compared to previous versions, haste suddenly seems to be better stat than hit on average (at least with my gear) or pretty much on par with hit. Is that because of the haste formula fix or something else was changed in the spreadsheet?


PS: Is it me or the results of stat comparision should be more accurate if people turn Heroism and Blade Flurry off? Calculating "average haste" based on those 2 is pretty pointless as they don't have much to do with your average haste during a long fight, being on command abilities with a fix uptime and all. By having BF for instance up, ain't it possible that it misscalculates the uptime of poison based on BF, even if BF has really not much to do with your poison uptime 5/6 of the time?

The constant terms in crit formulas for various classes can differ by race. I remember figuring this all out when I did my early combat mechanics guide back at level 60.

Also, I just tried out sheet 2.3.2.7 (been using 2.3.2.5 without problems). The macros don't seem to work in Excel 2004 for Mac.

There definitely are issues that arise when most of the haste and energy formulas average the effects as though they are activated every cooldown.

1) Adrenaline Rush. For the purpose of calculating the optimal cycle, it currently is just a half energy per second (150 energy every 300 seconds). Given that AD produces more than 100 extra energy, won't some of that energy go to waste if you start your optimal cycle with it up? You can't just bank it all in extra SnD time. In reality, you'd want to figure out what the best cycle is without AD, then figure out how to modify that cycle with an additional 150 energy. Of course, it's not really 150 energy, but normally 160 given you're activating it withing 1 second of an energy tick, right? This is something that modeling is possible for, and given somewhat minimal effort. The following issues are not.

2) Deadly poison. Right now, it's modeled by figuring out how much time each size DP stack going to be up on average, and using this to determine the number of doses that are present on average. The problem with this is that DP doesn't tick continuously; it ticks every 3 seconds. What you need to do is determine the likelihood of each stack transitioning to a different size stack within the 3 second time period, and thus determine how many stacks will be there when it ticks. Even simplifying a potential model to allow non-integer numbers of attacks every 3 seconds, I think this would require some knowledge of stochastic processes that I don't quite have yet given my attempts to come with something so far haven't gotten anywhere.

3) Cooldown stacking. The Mage trinket from SSC is slightly better than just another trinket with an activate effect (disregarding mana returns) because it allows a controlled way to activate a +dmg effect that does not cause a cooldown in other trinkets. By combining this with another trinket activation, a Destro Potion, Berserking, and Combustion, you can stack large amounts of both multiplicative and additive effects together to get the greatest use out of them. This is even more worthwhile when Heroism/Bloodlust is active. Right now, all trinkets, other partial duration buffs, and hastes are averaged, but in reality people are going to stack them on each other. This provides potentially a much larger increase in damage from a activated haste/AP gain and a static or proc'd one. Is this modelable? Possibly, but I don't have good knowledge of what is normally thought of as "optimal" use them. Shaman at my level like to pop Bloodlust without telling anyone beforehand, but I assume that this normally not the case. There lots of 2 minute cooldown effects, but there are also 3 min and 5 min cooldowns that are hard to stack precisely. Perhaps the model can assume that all effects will be used together exactly once, but then average their effects over the rest of the time?

4) Combat Potency and Combo point Cycles. This is saved for last as the absolute worst thing to 100% accurately model in attempting to determine an optimal cycle, but in practice can be fairly safely averaged without large problems. An optimal model would determine the best cycle given any number of CP, Relenetless, and Ruthlessness procs, modifying the next (or current) as the number of them changes. Doing this would be extremely difficult, having to consider a large number of potential situations in which to modify the cycle, even disregarding temporary hastes or energy gains.

On that note, the sheet does a decent job of figuring out a good cycle based on average energy gained and average combo point cost, but in practice I've found I've dropped SnD a lot more than the sheet says I will in its SnD uptime stat. While going one combo point higher is generally overkill, I've been able to vary the number of points used in SnD to better match the energy generation I have, both in general and in the short term. It is my supposition that the truly optimal cycle (on average) would be one that has no energy surplus or deficit: No SnD downtime, no extra instants, and no cutting of SnD time unless you can keep rupture up 100%. This seems incredibly likely given that the optimal cycle the spreadsheet returns is that one closest to that, and that it makes sense from what rogues try to accomplish anyway. To do so you would need to vary SnD points used between two values in a prescribed manner. Of course, in practice you would probably end up changing that schedule based on actual CP gains and AD, but an even more advanced sheet would tell you how to make such changes.

All in all, the sheet as it stands does a great job, and the above things are all incredibly minor compared to the overall picture. Everything is modeled in a way that at least comes extremely close to how it works in practice.

I have a really quick questions I know that AP is calculated into your rupture dmg, can someone tell me the formula that goes into that please for my overall rupture dmg? If it's already on here I apologize, but if you could just copy and paste it that'd be great. Thanks in advance