Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Public Discussion » Class Mechanics

 
 
LinkBack Thread Tools
Old 10/12/07, 9:03 AM   #1
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
[Warrior] DPS Spreadsheet 2.3 and beyond

Warrior DPS by Grim13

- With items to choose
- Up to date
- With Makros for SEP and stuff
Warrior DPS by Grim13


Warrior DPS Spreadsheet 2.08

Requires Excel 2003 / OpenOffice 2.3 or higher.
- OO compatible
- No makros


Warrior DPS Spreadsheet 2.08
Warrior DPS Tabelle 2.08

Last edited by dr_AllCOM3 : 02/22/08 at 4:54 PM.

Offline
Old 10/12/07, 12:14 PM   #2
Eliminate2
Von Kaiser
 
Gnome Warrior
 
Kil'Jaeden
So, after looking over the sheet a few times.

It seems the spreadsheet, under "Buffed DPS" I can't find where t6 4pc bonus is modeled.
It does appear under the "Buffed Threat", in cell B19

[top]H4*IF(Gear!V7,1.05,1)

Also under "Buffed DPS", the offhand factor is indeed.


50%+(5*Talents_Buffs!E20/100/2) Cell B9
Displaying the correct value of 62.5%

But under the "Buffed Threat", the offhand factor is
=0.5+Talents_Buffs!E20/100 Cell S5
Displaying an incorrect value of 55%

Are these meant to be like this? Or is the sheet missing things?

Also, what would the proc on Warglaives be modeled as? How much constant haste?

Last edited by Eliminate2 : 10/12/07 at 12:20 PM.

Offline
Old 10/12/07, 2:19 PM   #3
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
Originally Posted by Eliminate2 View Post
Are these meant to be like this? Or is the sheet missing things?

Also, what would the proc on Warglaives be modeled as? How much constant haste?
You are missing, that threat isn't modeled.
I didn't include the Warglaives. When you have both you don't need this sheet anymore. It's game over, maximum DPS achieved.


2.3 WW seems to be about more or less what we lose with Deathwish.

Last edited by dr_AllCOM3 : 10/12/07 at 2:25 PM.

Offline
Old 10/12/07, 2:41 PM   #4
Eliminate2
Von Kaiser
 
Gnome Warrior
 
Kil'Jaeden
Originally Posted by dr_AllCOM3 View Post
You are missing, that threat isn't modeled.
I didn't include the Warglaives. When you have both you don't need this sheet anymore. It's game over, maximum DPS achieved.


2.3 WW seems to be about more or less what we lose with Deathwish.
Ok, lol, well, I just wanted to make a benchmark with the modeling. But that's cool.

Ok, so I am missing it. Can you point out which cell its in? T6 bonus just seems very underwhelming.

Edit: I see it now with the new spreadsheet in cell H32

Last edited by Eliminate2 : 10/12/07 at 5:20 PM.

Offline
Old 10/12/07, 5:34 PM   #5
Eliminate2
Von Kaiser
 
Gnome Warrior
 
Kil'Jaeden
Hmm, was just testing out the new spreadsheet. Sticking the brutalizer into the offhand slot seem to yield more dps then a blade of infamy.

Are the calculations for Expertise accurate? seems like a very significant factor now.

Offline
Old 10/12/07, 5:41 PM   #6
rayijin
Piston Honda
 
rayijin's Avatar
 
Tauren Warrior
 
The Venture Co
Originally Posted by Eliminate2 View Post
Hmm, was just testing out the new spreadsheet. Sticking the brutalizer into the offhand slot seem to yield more dps then a blade of infamy.

Are the calculations for Expertise accurate? seems like a very significant factor now.
Assuming it changes dodge/parry to hit rather than miss, 1% less dodge from expertise= 1% increase in dps, up to the maximum dodge value.

1% hit only increases your dps by 1% if you are below the hit cap for specials, otherwise it's about a .5% increase. In other words, if you already have 8.6% hit (easy to achieve), rating equivalences to increase your overall dps by 1% would be:

~32 hit rating = ~16 expertise rating = ~22 crit rating

Offline
Old 10/12/07, 5:50 PM   #7
Eliminate2
Von Kaiser
 
Gnome Warrior
 
Kil'Jaeden
So the current values they have on live, such as the Brutalizer with 21 axe skill rating, will = 21 expertise rating? Or is the conversion different? I haven't been able to copy onto test

Also, on the Talents_Buff sheet. You included the Damage taken. On the note you mentioned, that 50.000 is good fro fights like teron. Just wondering what values are you using as a basis? Is it damage taken per sec?

Last edited by Eliminate2 : 10/12/07 at 6:03 PM.

Offline
Old 10/12/07, 6:07 PM   #8
Machinator
Don Flamenco
 
Troll Warrior
 
Aggramar
A couple questions for modeling the new stuff because I havent been able to get on the PTR either.

1. I am assuming WW shows up in 2 hits like mutilate. Do they each have their own hit chance, and is the OH affected by the OH damage penalty (50/62.5%)?

2. Does Sweeping Strikes count as special attacks or does it depend on abilities used. Does WW count as 2? Pretty much will there be any difference at all if you use it on a single target?


"So the current values they have on live, such as the Brutalizer with 21 axe skill rating, will = 21 expertise rating? Or is the conversion different?"
The notes say the conversion is the same at least. so 21 skill rating is 5 expertise, or 1.25% less dodge/parry. However before skill rating had to come out to a whole number, I wonder if that still is true.

"Information is ammunition."

Offline
Old 10/12/07, 6:35 PM   #9
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
Small update. Those S3 weapons are damn good -_-.

Offline
Old 10/12/07, 6:35 PM   #10
Apfelkäse
Glass Joe
 
Orc Death Knight
 
Kazzak (EU)
After getting 9% Hit, woulnd't it be smart getting 23 Weapon Expertise? It eliminates dodges on special as well as white hits

Offline
Old 10/12/07, 11:57 PM   #11
PSGarak
Bald Bull
 
PSGarak's Avatar
 
Undead Warlock
 
Hyjal
Originally Posted by Eliminate2 View Post
So the current values they have on live, such as the Brutalizer with 21 axe skill rating, will = 21 expertise rating? Or is the conversion different? I haven't been able to copy onto test
Rating is rating, the point of rating is that they all have the same itemization cost. I think what you're asking though is if it gets converted to expertise at the same rate weapon skill does (and if you weren't you should be =P). The general consensus is that the rating:point conversion is the same, and the point:effect conversion is 4:1 (ie 1 expertise is .25% off dodge and parry) but the wording of any official sources seem a bit hazy on the subject. Someone should run parses to make sure it works how we think it works, and that it does in fact work, as opposed to being bugged.

I wanted to check the spreadsheet but it wanted me to sign up for a webhosting service or something, so I'll just ask: is whirlwind now a better staple attack than bloodthirst when duel-wielding?

Offline
Old 10/13/07, 3:53 AM   #12
Bronwyn
Piston Honda
 
Human Warrior
 
Alleria (EU)
Thanks for the quick work - may I ask how exactly Whirlwind is calculated?

2 Attacks? Both full Damage or OH Attack reduced to 50/62.5%?

Offline
Old 10/13/07, 6:24 AM   #13
mogun
Glass Joe
 
Undead Warrior
 
<Yoh>
Magtheridon (EU)
The way the bonus from Imp. zerker stance is calculated, is not correct. The 10% is applied for all AP you have, not only the AP from items. (Don't know exactly for unleashed rage as we dont have an ench shammy, but I guess its the same).

So cell H156 instead of

[top]H147*H150*H151+H153 should be


(H147+H153)*H150*H151


Cheers.

Last edited by mogun : 10/13/07 at 6:27 AM. Reason: typo

Offline
Old 10/13/07, 9:23 AM   #14
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
Originally Posted by Bronwyn View Post
Thanks for the quick work - may I ask how exactly Whirlwind is calculated?

2 Attacks? Both full Damage or OH Attack reduced to 50/62.5%?
Second.

Originally Posted by mogun View Post
The way the bonus from Imp. zerker stance is calculated, is not correct. The 10% is applied for all AP you have, not only the AP from items. (Don't know exactly for unleashed rage as we dont have an ench shammy, but I guess its the same).
So cell H156 instead of

[top]H147*H150*H151+H153 should be


(H147+H153)*H150*H151
Cheers.
Are you sure, that it's item ap only?

Offline
Old 10/13/07, 9:43 AM   #15
mogun
Glass Joe
 
Undead Warrior
 
<Yoh>
Magtheridon (EU)
Originally Posted by dr_AllCOM3 View Post
Second.


Are you sure, that it's item ap only?
No, I said the opposite. It applies on ALL ap you have. But the spreadsheet calculates only for the AP from items.

Offline
 

Go Back   Elitist Jerks » Public Discussion » 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