 |
| Welcome to Elitist Jerks |
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!
If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.
|
10/23/07, 2:02 AM
|
#101
|
|
King Hippo
|
The Bludgeon seems to be competetive at low level - med BT gear levels, even after the 2.3 change. It seems to lose ground at higher levels.
Last edited by Graul : 10/27/07 at 9:15 PM.
|
|
|
|
|
|
10/23/07, 2:57 AM
|
#102
|
|
Von Kaiser
Night Elf Warrior
Lightbringer
|
I've been doing a lot of work with the spreadsheet lately and I've found that the bludgeon remains very solid as an OH. The haste rating still scales very well with other gear, and since its not a dagger its fast speed isn't as big of an issue.
With my current gear set I show 1335 DPS, no other OH gives more. The slow S3 items are similar, but still a little less. To experiment I made an item with the Bludgeon's stats, but with the Blade of Infamy's damage range (2.6), and I get 1345 DPS.
Last edited by Opalira : 10/23/07 at 3:07 AM.
|
|
|
|
|
|
10/23/07, 3:05 AM
|
#103
|
|
Glass Joe
|
I've been going over the spreadsheet but am relatively new to its amazingness.
Is there anywhere to calculate enchant ring - striking into the spreadsheet?
|
|
|
|
|
|
10/23/07, 4:06 AM
|
#104
|
|
King Hippo
|
Originally Posted by Opalira
I've been doing a lot of work with the spreadsheet lately and I've found that the bludgeon remains very solid as an OH. The haste rating still scales very well with other gear, and since its not a dagger its fast speed isn't as big of an issue.
With my current gear set I show 1335 DPS, no other OH gives more. The slow S3 items are similar, but still a little less. To experiment I made an item with the Bludgeon's stats, but with the Blade of Infamy's damage range (2.6), and I get 1345 DPS.
|
In my current gear, with just a Bludgeon off hand, it shows 1308, which does in fact seem to beat every other off hand at my gear level, even the season 3 axe (by 1 DPS). But at a higher gear level (new neck, rings, boots, gloves, legs, chest, helm, ZA bow) it's 1458 with the Bludgeon and 1476 with a season 3 axe. I'm not actually sure this really even translates into a "real world" difference considering the majority of numbers you see from the spreadsheet are for "optimal, in a vacuum" theoreticals. The season 3 axe does however beat out my current main hand.
|
|
|
|
|
|
10/23/07, 7:11 AM
|
#105
|
|
King Hippo
Tauren Warrior
Earthen Ring (EU)
|
Originally Posted by Elistion
I've been going over the spreadsheet but am relatively new to its amazingness.
Is there anywhere to calculate enchant ring - striking into the spreadsheet?
|
I answered that question for one of the previous versions of the spreadsheet:
http://elitistjerks.com/500521-post1837.html
(cell P12 should be cell I2/K2 (MH/OH) on the Buffed dps page in the current version of the spreadsheet)
|
|
|
|
|
|
10/23/07, 7:30 AM
|
#106
|
|
Don Flamenco
Orc Death Knight
Stormrage (EU)
|
Originally Posted by Machinator
10/15 04:37:03.031 You hit Servant of Razelikh for 154.
10/15 04:37:05.562 You crit Servant of Razelikh for 317.
I would say so. I believe it was actually a bug that it didnt affect white damage and it was fixed.
|
Yup. I was going to quote the patch notes but I can't find it now. It was fixed though.
|
|
|
|
|
|
10/24/07, 12:54 AM
|
#107
|
|
The Spider Scenario
|
Originally Posted by Opalira
I've been doing a lot of work with the spreadsheet lately and I've found that the bludgeon remains very solid as an OH. The haste rating still scales very well with other gear, and since its not a dagger its fast speed isn't as big of an issue.
|
This got me thinking: is 2.3 going to be the effective end of warriors using daggers due to whirlwind changes and dagger normalization?
|
|
|
|
|
|
10/24/07, 2:56 AM
|
#108
|
|
Bald Bull
Night Elf Warrior
Sargeras
|
Originally Posted by hawkk
This got me thinking: is 2.3 going to be the effective end of warriors using daggers due to whirlwind changes and dagger normalization?
|
Yes, completely.
|
|
|
|
|
|
10/24/07, 4:11 AM
|
#109
|
|
King Hippo
Tauren Warrior
Earthen Ring (EU)
|
For similar dps weapons daggers will be severely disfavored both as MH and OH. Did some back-of-the-envelope maths and it seems that the difference between a 1.6 dagger and a 2.6 sword/mace/axe is about 10 dps for kara level gear and optimal usage of WW. So if you have a crappy offhand the dagger might be preferable (less so the faster the dagger is).
|
|
|
|
|
|
10/24/07, 12:07 PM
|
#110
|
|
Great Tiger
Orc Death Knight
Blutkessel (EU)
|
Originally Posted by Gruntle
For similar dps weapons daggers will be severely disfavored both as MH and OH. Did some back-of-the-envelope maths and it seems that the difference between a 1.6 dagger and a 2.6 sword/mace/axe is about 10 dps for kara level gear and optimal usage of WW. So if you have a crappy offhand the dagger might be preferable (less so the faster the dagger is).
|
I don't have Office installed right now, but I don't think I have taken normalized speed for offhands into account.
So don't be too fast about 2.3  .
|
|
|
|
|
|
10/24/07, 12:37 PM
|
#111
|
|
Glass Joe
|
ok i recently downloaded and experimented with the spreadsheet so as new to this conversation i have a few questions:
a) is there any way to sort armor and weapons? if yes how?
b) i noticed +crit rating contributes much to the spreadsheet dps outcome. However my background so far and my private talks with other warriors suggested going heavy for +hit. is the value of +crit thorougly proved to be better? is it a balance of stats? is there a minimum value required for different stats like hit?
c) has anyone ever considered making a list similar the one rogues have at shadowpanther.net but for warriors. if anyone would be interested i would be happy to contribute in whatever way i can.
anyway keep it up
|
|
|
|
|
|
10/24/07, 12:39 PM
|
#112
|
|
Piston Honda
Human Warrior
Arthas (EU)
|
Well, some napkin math about offhand whirlwind with 2000/3500 attack power:
Slow offhand: 300 avg hit + 343/600 from AP = 400/563 after OH penalty
Fast offhand: 180 avg hit + 343/600 from AP = 326/488 after OH penalty (20/15% worse than slow)
Dagger offhand: 190 avg hit + 242/425 from AP = 270/384 after OH penalty (~33% worse than slow in both cases)
IMHO Dagger users don't need to panic, but obviously priorities have changed so look for that offhand upgrade. 
|
"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."
|
|
|
|
10/24/07, 1:50 PM
|
#113
|
|
Debleated
@ChickenArise
Night Elf Warlock
No WoW Account
|
Originally Posted by Solva
b) i noticed +crit rating contributes much to the spreadsheet dps outcome. However my background so far and my private talks with other warriors suggested going heavy for +hit. is the value of +crit thorougly proved to be better? is it a balance of stats? is there a minimum value required for different stats like hit?
|
Past 9%, hit takes a steep drop for DW warriors in the relative value compared to other stats. Hit is still nice, and it smooths rage generation, but in the big picture, past 9% hit, crit is a superior stat.
|
See you, auntie.
|
|
|
|
10/24/07, 4:13 PM
|
#114
|
|
Von Kaiser
|
Not seen it posted in here, but weapon mastery 2/2 is now only -2% on the PTR.
|
|
|
|
|
|
10/25/07, 4:25 AM
|
#115
|
|
Glass Joe
Orc Warrior
Kul Tiras (EU)
|
Hello,
I'm quite new her eso I'd just like to start off with saying thx to dr_Alcomm for the brilliant spreadsheet, as well as thx to all other giving brilliant input and answers.
On to my question: I am currently in choosing a weapon for my new warrior, I'm selecting between Dragonmaw and Black Planar Edge. From moddeling my aproximate gear in the spreadsheet the axe commes in on top of the hammer for DPS. I should say my warrior is an Orc an hence get's the bonus for axes. But from what I've read before (not on this forum tho) the hammer was favoured for dps for it's haste proc.
My question is, is it 2.3 that have made the axe more favourable for orcs with the 1%crit or is the info I've read before with the hammer beeing better just drivel?
Cheers,
Mean
|
|
|
|
|
|
10/25/07, 10:49 AM
|
#116
|
|
Don Flamenco
Orc Death Knight
Stormrage (EU)
|
The 3% hit you get currently from axe skill is far better than the 1% crit you'll get in 2.3. Nevertheless the axe is better then the mace since the haste nerf.
|
|
|
|
|
|
10/25/07, 12:02 PM
|
#117
|
|
Not enough rage
Gnome Warrior
Argent Dawn (EU)
|
Originally Posted by Darkrenown
The 3% hit you get currently from axe skill is far better than the 1% crit you'll get in 2.3. Nevertheless the axe is better then the mace since the haste nerf.
|
That is assuming the modeling of the value of the haste proc present in the spreadsheet is correct. The spreadsheet assumes about 20% uptime on the haste effect while myself I seem to recall numbers closer to 35% (at least when using hamstring to incur more proccs)
|
|
|
|
|
|
10/25/07, 4:24 PM
|
#118
|
|
Glass Joe
Human Death Knight
Sylvanas (EU)
|
is the first time im using the spreddsheet and prolly im doing something wrong but when i change the race from tauren to human i get ### and #NUM all over the tabs.
can anyone help me, please.
|
|
|
|
|
|
10/25/07, 5:26 PM
|
#119
|
|
Glass Joe
|
Originally Posted by Aten
is the first time im using the spreddsheet and prolly im doing something wrong but when i change the race from tauren to human i get ### and #NUM all over the tabs.
can anyone help me, please.
|
I have the same issue when I select human as my race. Also does the spreadsheet take into account what the human racial will be in 2.3?
BTW I just discovered the DPS spreadsheet a week ago and I want to say thank you to DR Allcom and whoever else helped make this possible.
|
|
|
|
|
|
10/25/07, 6:00 PM
|
#120
|
|
Glass Joe
|
Originally Posted by Aten
is the first time im using the spreddsheet and prolly im doing something wrong but when i change the race from tauren to human i get ### and #NUM all over the tabs.
can anyone help me, please.
|
I only get that error if I have Dragonstrike in my main hand when I switch the race to human. I haven't had that error with any other mace or sword but it seems there is an error with the human racial in the new spreadsheet.
|
|
|
|
|
|
10/26/07, 6:36 AM
|
#121
|
|
Glass Joe
Human Death Knight
Sylvanas (EU)
|
Originally Posted by Chadw
I only get that error if I have Dragonstrike in my main hand when I switch the race to human. I haven't had that error with any other mace or sword but it seems there is an error with the human racial in the new spreadsheet.
|
Yep thats exactly my MH, and i had S2 fist weapon to my OH, had to had it as dagger, tho cause it seems that fist isnt working properlly too.
BTW how do i had Doomplate set i still have 2 pieces and i want to put the + 35 hit.
Yes i know they suck but fighting againt tanks a and priest with prio sucks.
EDIT: The caracteres show on the AGI collumn, and all over the place in Buffed tab, also on the enhants tab just on mongoose, and executioner in MH and OH, still dunno why Executioner get changed cause i dont select it wahtsoever.
Last edited by Aten : 10/26/07 at 6:44 AM.
|
|
|
|
|
|
10/26/07, 2:45 PM
|
#122
|
|
Glass Joe
Human Warrior
Feathermoon
|
Human Racial borked?
I think I have found the problem in regards to the Dragonmaw+Human being borked.
In Buffed_DPS Sheet, there is an identical error in the MH Crit Racial and OH Crit Racial fields:
[top]IF(Gear!B11
"Human",IF(Gear!D13="2h Mace",1%,IF(Gear!D13="2h Sword",1%,IF(Gear!D13="Sword",1%, IF(Gear!D13="Mace",22,0)))),0)+IF(Gear!B11="Orc",IF(Gear!D13="2h Axe",1%,IF(Gear!D13="Axe",1%,0)),0)
As you can see in the bolded part, mace is currently giving 2200% bonus crit. So, changing the "22" (I assume this was for crit rating) in the formulae back to 1% fixes the problem.
EDIT:
P.S.: I see that the current version of the spreadsheet is giving expertise for Weapon Mastery. Since it is -2% dodge now, is it equivalent to edit the expertise given to 8 (assuming 2 points) instead?
Last edited by Milfeulle : 10/26/07 at 2:54 PM.
|
|
|
|
|
|
10/27/07, 2:56 PM
|
#123
|
|
King Hippo
Tauren Warrior
Earthen Ring (EU)
|
To model Weapon mastery you could also unclick the talent points and just change Base dodge on the Buffed dps page to 3.6% instead of 5.6%.
The problems with "###" in the cells is probably caused by too narrow columns in the display (that's what it shows for me anyway), just widen the column by clicking on the border and dragging it to make it broader, the numbers should appear then.
|
|
|
|
|
|
10/27/07, 5:51 PM
|
#124
|
|
Great Tiger
Orc Death Knight
Blutkessel (EU)
|
I made an update.
Some fixes of things you mentioned.
Also now threat. Have a look into it and report wrong stuff.
[Prism of Inner Calm] is kinda underwhelming  .
|
|
|
|
|
|
10/27/07, 8:19 PM
|
#125
|
|
Glass Joe
Undead Rogue
Forscherliga (EU)
|
Thanks for the great work dr_AllCOM3, but i wonder if it is possible to add the ring enchants to the sheet, as well as the SV Hunter skill Expose Weakness (w/ dropdown menu to set the agility of the SV Hunter). That would be a great improvement for me and some others i guess.
Talida
|
|
|
|
|
|
|