Barmbul

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

Armory profile

 

Shoxx

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?

 

Gruntle

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.

 

Amorpheus

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."

 

Shoxx

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).

 

Isidur

* Expertise bug fixed
* TPS working
* Show correct cycle
* Racial OH Crit bug fixed

download

 

Ego

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.

 

Rhaeti

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.

 

Gruntle

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.

 

dr_AllCOM3

I'm playing 2.3 right now in my free time. It's a nice patch, ZA is good and I can finally have fun in AV.
So you have to wait a bit for this:

 

DocMartin

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.

 

Osborn

wohoooo, nice, you are the best

 

Machinator

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.

"Information is ammunition."

 

Zurgat

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.

 

Gruntle

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.

 

Zurgat

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.

 

Beefcakes

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.

 

DarkS

Isn't The Decapitator tagged as Main Hand? How can you equip it in off-hand?

 

• Darkmyst

One of the undocumented changes in 2.3 was that The Decapitator was changed to "One Hand" from "Main Hand"

 

Rhaeti

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.

 

Kylak

Is it possible to compare Armor Penetration with AP? (Like 1 AP = X armor ignore)

 

Graul

The sheet already does this. Look at the SEP section.

 

dr_AllCOM3

Have I forgotten something blatantly obvious? Items aren't complete, but you have figured that out unless you are Sherlock Holmes.