I was attempting to verify as much as I could understand of the spreadsheet (learning a lot about Excel in the process!) and noticed that the average damage of a Sword Spec proc was different than the average main hand hit. Looking at the formulas, it appears that the Sword Spec procs are assumed to be unable to miss or be dodged. Is this an error in the formula, or do extra attacks from Sword spec actually work that way? I remember reading that hit rating is extremely valuable for anything that procs extra attacks, as the number of those attacks are affected by hit rating twice: once when they proc, once when they swing.
Specifically, on the unbuffed DPS sheet, adjusted damage for a main hand hit is calculated as (Average noncrit * Glancing chance * glancing reduction factor + Average crit * crit chance * crit multiplier + Average noncrit * hit chance) while the same value for "extra attacks" is (Average noncrit *(glancing chance * glancing reduction factor + crit chance * 2 + hit chance)/(sum of glancing, hit, and crit chances). The pre-armor DPS for extra attacks is then calculated as Adjusted damage * extra attacks per second * Murder bonus factor, so the miss and dodge chances are not being considered there either.
The way the formula is laid out, it seems as though the author did make the assumption that they canot crit or miss, but this goes against what I remember reading. If this was covered previously in the thread and I missed it, I apologize.
Addtionally, extra attacks are assumed to have a crit multiplier of 2, disregarding RED and Mace Spec.
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...
Originally Posted by WoW 2.1.3 Patch Notes (Latest Regarding Sword Spec)
Sword Specialization: The change to Sword Specialization making its extra attacks appear in yellow has been reverted. Extra attacks will appear in white and act like any auto-attack. They will no longer reset the swing time of your weapon.
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 downloaded the new version of the sheet to see if the problems mentioned in my previous post were fixed. When I attempt to run the import from another sheet, I get the error as above and the debugger pops up in Module 5, in a block of code labeled Sub Import(). In the line "If (".xls" = Right(oldpath, 4)) Then", "Right" is highlighted. I also get the error when attempting to import from armory. I attempted to follow the path mentioned above, but References was ghosted out.
I'm running XP and Excel 2000.
edit: seeing if downloading the file from the website helps.... and it didn't.
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.
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.
Derived from this, relocate the options menu *somehow*.
Add (or replace the current Dodge) a 'Chance to be Dodged' column to the top overview (since the introduction of expertise).
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.
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).
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).
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.
Are there any older versions of the XML Library available to be checked? Like Version 4. The functions I used were pretty standard and should also work with older versions. Anything with the MSXML2 Library should work.
While we are at it. Who had to download anything to make this work? Would be nice to be able to track this down.
The beta Spreadsheet that I pulled the code from opened up and work fine I didn't have to do a thing. Although when I copied the code to the spreadsheet, i needed to enable that reference to make it work for this sheet.
So my question is..
Who did this version work without a hitch? Please post Operating System and Excel version.
If you had to do something, what did you do, and did it work?
So, I'm using Windows XP and Office 2000. I can check this on a few computers at work to see where some of the compatibility issues are. It would be nice to cut down the hoops people need to jump through.
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 188.8.131.52 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.
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.
I use a standard 20/41/0 sword spec with no gear haste, so none of those were changed.
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