Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics

 
 
LinkBack Thread Tools
Old 11/16/07, 11:05 AM   #251
Barmbul
Von Kaiser
 
Barmbul's Avatar
 
Tauren Warrior
 
Dragonmaw
Originally Posted by Hozz View Post
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


Offline
Old 11/16/07, 9:18 PM   #252
Shoxx
Glass Joe
 
Human Warrior
 
Kargath (EU)
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?

Offline
Old 11/17/07, 6:03 AM   #253
Gruntle
King Hippo
 
Tauren Warrior
 
Earthen Ring (EU)
Originally Posted by Hozz View Post
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...

[Brooch of Deftness]
[Belt of One-Hundred Deaths]
[Shoulderpads of the Stranger]
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.

Offline
Old 11/17/07, 8:34 AM   #254
Amorpheus
Piston Honda
 
Amorpheus's Avatar
 
Human Warrior
 
Arthas (EU)
Originally Posted by Shoxx View Post
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."

Offline
Old 11/17/07, 11:26 AM   #255
Shoxx
Glass Joe
 
Human Warrior
 
Kargath (EU)
Originally Posted by Amorpheus View Post
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).

Offline
Old 11/17/07, 1:08 PM   #256
Isidur
Glass Joe
 
Isidur
Undead Mage
 
Non-US/EU Server
TestVersion 2.1

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

download

Offline
Old 11/17/07, 6:35 PM   #257
Ego
Glass Joe
 
Orc Warrior
 
Eldre'Thalas
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.

Offline
Old 11/17/07, 10:48 PM   #258
Rhaeti
Von Kaiser
 
Rhaeti's Avatar
 
Tauren Warrior
 
<SXM>
Area 52
Originally Posted by Shoxx View Post
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.


Offline
Old 11/18/07, 4:48 AM   #259
Gruntle
King Hippo
 
Tauren Warrior
 
Earthen Ring (EU)
Originally Posted by Ego View Post
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.

Offline
Old 11/18/07, 9:26 AM   #260
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
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:

Offline
Old 11/18/07, 12:21 PM   #261
DocMartin
Glass Joe
 
Draenei Warrior
 
Draenor
Originally Posted by DocMartin View Post
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.

Offline
Old 11/18/07, 8:54 PM   #262
Osborn
Banned
 
Blood Elf Paladin
 
Black Dragonflight
Originally Posted by dr_AllCOM3 View Post
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:
wohoooo, nice, you are the best

Offline
Old 11/19/07, 2:18 AM   #263
Machinator
Don Flamenco
 
Troll Warrior
 
Aggramar
Originally Posted by Rhaeti View Post
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.

Last edited by Machinator : 11/19/07 at 3:43 AM.

"Information is ammunition."

Offline
Old 11/19/07, 5:14 AM   #264
Zurgat
King Hippo
 
Zurgat's Avatar
 
Troll Rogue
 
Aszune (EU)
Originally Posted by dr_AllCOM3 View Post
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.

Originally Posted by Isidur View Post
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.

Offline
Old 11/19/07, 6:08 AM   #265
Gruntle
King Hippo
 
Tauren Warrior
 
Earthen Ring (EU)
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.

Offline
Old 11/19/07, 6:43 AM   #266
Zurgat
King Hippo
 
Zurgat's Avatar
 
Troll Rogue
 
Aszune (EU)
Originally Posted by Gruntle View Post
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.

Offline
Old 11/19/07, 9:39 AM   #267
Beefcakes
Glass Joe
 
Orc Warrior
 
Xavius (EU)
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.

Offline
Old 11/19/07, 10:22 AM   #268
DarkS
Von Kaiser
 
DarkS's Avatar
 
Undead Warrior
 
Daggerspine (EU)
Isn't The Decapitator tagged as Main Hand? How can you equip it in off-hand?

Offline
Old 11/19/07, 10:34 AM   #269
 Darkmyst
Terrible Terry Tate, Forum Linebacker.
 
Darkmyst's Avatar
 
Elyree
Troll Warrior
 
No WoW Account
Originally Posted by DarkS View Post
Isn't The Decapitator tagged as Main Hand? How can you equip it in off-hand?
One of the undocumented changes in 2.3 was that The Decapitator was changed to "One Hand" from "Main Hand"

Originally Posted by XI- View Post
Do you have a point or are you just crying now?

United States Offline
Old 11/19/07, 11:20 AM   #270
Rhaeti
Von Kaiser
 
Rhaeti's Avatar
 
Tauren Warrior
 
<SXM>
Area 52
Originally Posted by Machinator View Post
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.


Offline
Old 11/19/07, 11:32 AM   #271
Kylak
Glass Joe
 
Human Warrior
 
Quel'Thalas (EU)
Is it possible to compare Armor Penetration with AP? (Like 1 AP = X armor ignore)

Offline
Old 11/19/07, 11:49 AM   #272
Graul
King Hippo
 
Graul's Avatar
 
Orc Warrior
 
Fenris
Originally Posted by Kylak View Post
Is it possible to compare Armor Penetration with AP? (Like 1 AP = X armor ignore)
The sheet already does this. Look at the SEP section.

Offline
Old 11/19/07, 12:19 PM   #273
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)



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

Offline
Old 11/19/07, 1:01 PM   #274
Danath
Banned
 
Human Paladin
 
Les Sentinelles (EU)
Originally Posted by dr_AllCOM3 View Post



Have I forgotten something blatantly obvious? Items aren't complete, but you have figured that out unless you are Sherlock Holmes.
It would be great if you could put Exposed Weakness as well amongst other debuffs.

Offline
Old 11/19/07, 1:26 PM   #275
Graul
King Hippo
 
Graul's Avatar
 
Orc Warrior
 
Fenris
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.

Offline
 

Go Back   Elitist Jerks » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
DPS Warrior Spreadsheet Deathwing Class Mechanics 1901 11/06/07 4:32 PM
Possible to Fully Run Warrior Dps Spreadsheet Without Full Excel? DarthB Public Discussion 11 11/22/06 6:27 PM
Warrior Trinket Comparison (Earthstrike worth it for DW fury warrior?) Kasi Public Discussion 13 08/22/06 9:11 AM
Fury warrior / MS warrior vs. Rogues for raids? Petehmb Public Discussion 14 08/02/06 7:01 PM