Are you saying the spreadsheet wants skill entered and not rating, for Expertise?
Hes saying there is a bug in the way the sheet is calculating expertise If you change from tauren to human using a sword you also see a large increase in dps about 100 dps, or equip the talon of ashara
I have a short question about Band of Eternal Champion from Hyjal.
Is this item modelled correctly in the spreadsheet? The spreadsheet says, that it's got 87 attack power. In the cell: "60+27". Is this the correct amount of ap for the proc or just a number written in there without sense?
Regarding Expertise...does the spreadsheet model it correctly? If so, according to what I got, the following items are the best available for DPS in their respective slots for 17/44 now...
If you had bothered to read the replies two above yours you would have seen that Expertise from gear is currently not modeled correctly in the test version of the sheet. Expertise rating is correctly converted to Expertise, it's the conversion to -dodge/parry that is wrong.
I have a short question about Band of Eternal Champion from Hyjal.
Is this item modelled correctly in the spreadsheet? The spreadsheet says, that it's got 87 attack power. In the cell: "60+27". Is this the correct amount of ap for the proc or just a number written in there without sense?
That seems to overrate the proc slightly, which of course will never be more than a guess - educated or otherwise.
(I'm fairly sure it's a 60sec internal cooldown, I guess the spreadsheet value assumes 45sec like most procs seem to have.)
"You are better than I am," Inigo admitted. "So it seems. But if that is true, then why are you smiling?"
"Because," Inigo answered, "I know something you don't know." "And what is that?" asked the man in black. "I'm not left-handed."
That seems to overrate the proc slightly, which of course will never be more than a guess - educated or otherwise.
(I'm fairly sure it's a 60sec internal cooldown, I guess the spreadsheet value assumes 45sec like most procs seem to have.)
But there's neither a formula in the cell nor are there any hints, that the spreadsheet does even know a formula to calculate the proc-ap... That's somehow confusing to me. The ring highly out-performs the band of devastation (bt trashmob loot).
On the spreadsheet, expertise is calculated individually for the main hand and off hand weapons. In game, there is only one 'expertise' stat.
I'm fairly certain that an orc using an axe in the offhand and another weapon type in the main hand will grant the racial bonus for both hands. On the same note a human with a mace in one hand and a sword in the other should be granted the 5 expertise from each, on both hands. The spreadsheet currently does not support this.
I had a human warrior friend check his expertise stat while using a sword/mace for verification, and it does indeed show that he has 10 expertise.
But there's neither a formula in the cell nor are there any hints, that the spreadsheet does even know a formula to calculate the proc-ap... That's somehow confusing to me. The ring highly out-performs the band of devastation (bt trashmob loot).
There's no need for a calculation. The proc effect is averaged out to a static AP number. The proc is 160AP for 10 seconds. The spreadsheet assumes there's a 60 second cooldown. To average the effect out for modeling purposes you multiply 160AP by 10/60, thus the 27AP.
On the spreadsheet, expertise is calculated individually for the main hand and off hand weapons. In game, there is only one 'expertise' stat.
I'm fairly certain that an orc using an axe in the offhand and another weapon type in the main hand will grant the racial bonus for both hands. On the same note a human with a mace in one hand and a sword in the other should be granted the 5 expertise from each, on both hands. The spreadsheet currently does not support this.
I had a human warrior friend check his expertise stat while using a sword/mace for verification, and it does indeed show that he has 10 expertise.
Well, the +10 expertise racial is almost certainly a bug which will be removed soon. Not that I have any blue source for this but -2.5 dodge/parry for a racial is just way too much.
Slam calculation:
Since it's not normalized, I see that it takes (AP/14)*(speed). Does that take the hasted/flurried speed of the weapon, or the base?
I think I just answered my own questing parsing my combat logs. I have a 2H build with imp slam and 5/5 flurry. For hasted slams, I edited the combat log to show slams only when flurry was up, then ran it through WWS. Without flurry, I clicked it off every time and edited the file to show only un-flurried slams. For both tests, I made sure to click off enrage right away, though it wasn't happening very often at all.
With flurry up, over 66 hits, the average slam damage was 808. Without flurry, over 60 hits, the average was 807. A quick calculation says that if hasted speed were in the calculation, there should be about a 100 damage difference between the two.
Therefore, Slam always uses the base weapon speed, making flurry and haste that much more valuable in increasing white damage without hurting slam.
There's no need for a calculation. The proc effect is averaged out to a static AP number. The proc is 160AP for 10 seconds. The spreadsheet assumes there's a 60 second cooldown. To average the effect out for modeling purposes you multiply 160AP by 10/60, thus the 27AP.
How accurate is that though? Shouldn't the uptime vary depending on your gear? Anything that changes how often you hit, (+hit%, flurry, haste, +crit%) would change the uptime of the proc. The Dragonspine Trophy's haste is put at 325*20%, Hourglass of the Unraveller is put at 45 AP. More attacks/sec or a higher crit% would alter the uptime of those two respectively.
Also from the tanking sheet threat there is values showing WW and execute as 100% threat, Unaffected by Stance Multiplier. Anyone have any data on this or if its just out of date? I thought I read execute was extra threat anyway.
I can't seem to get this one working, it complains about missing links when launched.
Clicking the weapon slot doesn't produce a popup to allow switching.
Trying to compare: [Heartless] - vs - [Netherbane] for offhand.
I'd say Netherbane wins due to more dps and more stats, but not everyone seems to agree as agility isn't a very amazing stat for warriors.
This one doesn't work either.
Could these sheets please be combined into 1 xls file (like the rogue version is) so that these can be opened on Macintosh?
-= Random Ravings - RSS Feed =- Rogue and Hunter stuff here. As well as guides to get you trough your spare time.
I don't know, 9.1.6 is working just fine for me on a mac (even using OpenOffice). Have you tried opening the *ITEM.xls sheet before opening the *DPS.xls sheet? These sheets need to be in the same directory for the sheet to work. If that doesn't work I suggest you check the links in the DPS sheet (Edit-Links menu, and make sure the link is pointing at the correct file). Always answer yes to the questions you're asked when opening the DPS sheet (unless you're running on OpenOffice).
If it's still not working maybe something is wrong with your excel installation.
I don't know, 9.1.6 is working just fine for me on a mac (even using OpenOffice). Have you tried opening the *ITEM.xls sheet before opening the *DPS.xls sheet? These sheets need to be in the same directory for the sheet to work. If that doesn't work I suggest you check the links in the DPS sheet (Edit-Links menu, and make sure the link is pointing at the correct file). Always answer yes to the questions you're asked when opening the DPS sheet (unless you're running on OpenOffice).
If it's still not working maybe something is wrong with your excel installation.
I have them both opend currently.
Path looks ok, and both files are in the same dir, yet when i open the dps file it'll say it can't find the items.xls and give a debug warning.
Edit: Got it working, but still shows the error. And [Netherbane] comes on top with about 4 more effective dps.
-= Random Ravings - RSS Feed =- Rogue and Hunter stuff here. As well as guides to get you trough your spare time.
About the racial +expertise thingie. I'm not gonna ask or go about how you calculate it. That is not the point in my post. It seems that the bonus can be applied when the weapon in equipped in the offhand.
ie. I was using pre patch [The Decapitator] in MainHand, [Talon of Azshara] as offhand and that was the best place for those to be in. With 2.3, in my case the +5 expertise is applied when [The Decapitator] is put as off-hand. Thus it is better to have them swap places. I believe the spreadsheet doesn't pick that up.
How accurate is that though? Shouldn't the uptime vary depending on your gear? Anything that changes how often you hit, (+hit%, flurry, haste, +crit%) would change the uptime of the proc. The Dragonspine Trophy's haste is put at 325*20%, Hourglass of the Unraveller is put at 45 AP. More attacks/sec or a higher crit% would alter the uptime of those two respectively.
Also from the tanking sheet threat there is values showing WW and execute as 100% threat, Unaffected by Stance Multiplier. Anyone have any data on this or if its just out of date? I thought I read execute was extra threat anyway.
I don't know what the source is, but I believe whoever made the gear spreadsheet assumes an internal CD. Items that have a proc w/out an internal CD are difficult to model. That is why the gear spreadsheet just goes with an averaged out effect.
Does the current spreadsheet assume that your off hand can proc Mongoose on a WW? In most of the previous spreadsheets it was always Mongoose/Potency and then Executioner/Potency, but suddenly it's Executioner/Mongoose. While that combo is an extremely minor upgrade in DPS (and quite a bit more expensive) it's my belief that this is only true on static fights where you are able to hit the same target for 100% of the time. There is nothing more annoying than proccing something and only getting a second or two use out of it because you have to move or are simply not in range yet, whereas a static buff is always there and always being used on every hit. For that reason, I am still going to put Potency in my off hand, because it's still going to be more reliable on trash and every fight that requires a lot of movement.
11/16/07, 11:05 AM
Similar Threads
