Warrior DPS Calculation Spreadsheet - Page 3

Freddie · 12/02/08, 1:57 AM

[Spaulders of the Giant Lords] is the only item I've noticed missing in my limited testing.

Morsexy · 12/02/08, 2:36 AM

300 Whirlwinds with Berserking in offhand and zero procs.

DarkS · 12/02/08, 4:55 AM

Undead Race Base stats @ 80:

STR 173
AGI 111
STA 160
Base Health: 9541

Vhad · 12/02/08, 7:25 AM

Originally Posted by Morsexy

300 Whirlwinds with Berserking in offhand and zero procs.

How are we to interpret this and how did you conduct that test? Not that it can't be true, but would be nice if you could elaborate.

Senjion · 12/02/08, 8:03 AM

Originally Posted by IggyMac

Landsoul, is there anyway you could rearrange the items chart in the next version?

Given that they're tiled out horizontally rather then vertically, if you want an different item in any particular slot you get a blank line in the across the rest of the slots (inserting a row). Hopefully you get what I mean. Given that this is very much a beta to test it I'd like to put in the items I currently have access to (most of which aren't present yet).

Edit:
Possibly a different tab for each item slot might be in order. I know it's a pain, but it could be the way to go.

Instead of inserting a new row, highlight the cells at the bottom of that category and Insert, it will ask if you want to move the cells down or otherwise, choose down.

ebs2002 · 12/02/08, 12:17 PM

When inserting and selecting my gear, I **frequently** get the #N/A bug (using both 2003 and 2007 excel sheets).

Is there something else I need to do besides selecting the cells and choosing "insert"?

My steps: Go through each item, and when one isn't listed (I'm still in some quest greens, for example), I highlight the bottom cells for plate in that section, choose "insert", and go back to the set and select the item. Almost without fail, I do not get to my full gear before this breaks somewhere.

I can upload a version of my broken spreadsheet if that would help diagnose the issue.

Senjion · 12/02/08, 12:36 PM

Originally Posted by ebs2002

When inserting and selecting my gear, I **frequently** get the #N/A bug (using both 2003 and 2007 excel sheets).

Is there something else I need to do besides selecting the cells and choosing "insert"?

My steps: Go through each item, and when one isn't listed (I'm still in some quest greens, for example), I highlight the bottom cells for plate in that section, choose "insert", and go back to the set and select the item. Almost without fail, I do not get to my full gear before this breaks somewhere.

I can upload a version of my broken spreadsheet if that would help diagnose the issue.

When you are entering your gear are you copying the Raw SEP Formula from another cell and pasting it into that column? I have added quite a few items to the sheet thus far with no issues. It may help if you upload what you are doing (along with some flags to point to the changes) so that it can be looked at.

ebs2002 · 12/02/08, 12:39 PM

When you are entering your gear are you copying the Raw SEP Formula from another cell and pasting it into that column? I have added quite a few items to the sheet thus far with no issues. It may help if you upload what you are doing (along with some flags to point to the changes) so that it can be looked at.

No, I'm filling-down the raw SEP lookup.

As to at least one possible cause, I just found a few bugs. The VLookup in the Gearsets Array for the following enchants are off:

Head (no "None") -- this is probably what was causing my issue before, although there may be other places as well
Shoulders (range is way off)
Hands (range is off-by-one, doesn't read "none")

There are probably also range-checking issues in the gearstats array for items as well (which may be related to my problem)...I'll try to be more observant as I'm populating it this time.

ebs2002 · 12/02/08, 1:07 PM

I was able to successfully populate everything now (after fixing the enchantment lookups locally). Maybe those are the only errors (as I haven't enchanted a lot of my stuff yet). Will post if I find anything else.

Morsexy · 12/02/08, 1:49 PM

Originally Posted by Vhad

How are we to interpret this and how did you conduct that test? Not that it can't be true, but would be nice if you could elaborate.

Sure. Over a period of about 90 minutes I killed the fire elementals southeast in Winters Grasp with my main hand as [Titansteel Destroyer] enchanted with mongoose. My offhand my [Armageddon] enchanted with Berserking.

I would build up to 100 rage with a different off hand ( so zero chance to proc Berserking ) and then I would find a mob and only WW him down. No other specials, no other white hand hits\crits. If I did something wrong please tell me, and I would doubt this is the final word as Mongoose procd much less than I was accustomed to seeing, but that could have been the general time between attacks that I stood there getting beat on.

noxium · 12/02/08, 3:28 PM

Does anyone have any more information on the Nobles deck? I am interested in picking it up and the DPS difference in cold numbers might help others in decision of how much they really want it. Additionally, it is not in the spreadsheet at this time. It is my assumption that it would beat out mirror of truth/five flights.

Wowhead seems to have accurate numbers based on the agility version.

RyvenZ · 12/02/08, 3:40 PM

@ 80

STR 177
AGI 110
STA 161
INT 33
SPI 62
ARMOR 220

AP 631 (AttT gives another 3 even naked, so it displayed 634)

AttT giving AP without armor would suggest it IS affected by debuffs, such a berserking

landsoul · 12/02/08, 5:38 PM

Damn I should ask what armor is also and if you had AttT on. Updating in questions. Also be sure to not be in zerk stance.

I also would love to know your HP naked.

RyvenZ · 12/02/08, 7:30 PM

Orc Warrior - Level 80
Health: 10051
Rage: 0

Base Stats:
Strength 177
Agility 110
Stamina 161
Intellect 33
Spirit 62
Armor 220

Melee:
Damage 83-84
Speed 2.00
Power 577(574+3)
Hit rating 0
Crit Chance 3.63%
Expertise 0

Ranged:
Damage N/A
Speed N/A
Power 183(180+3)
Hit Rating 0
Crit Chance 3.63%

Spell:
Bonus Damage 0
Bonus Healing 0
Hit Rating 0
Crit Chance 0
Haste rating 0
Mana Regen N/A

Defenses:
Armor 220
Defense 400
Dodge 4.96%
Parry 10.00%
Block 5.00%
Resilience 0

Fwip · 12/03/08, 6:45 PM

Naked Gnome Warrior at 80:

Stats:
STR   179
AGI   116
STA   167
INT   40
SPI   59

Melee:
Damage        84-85
Attack Power  581 (578 + 3) 
Crit          4.29%

Defenses:
Defense   400
Dodge     10.04%
Parry     10.00%
Block     10.00%

Misc:
Armor   232
Health  10111

This includes: Deflection, AtT, Cruelty, Shield Spec, Anticipation, and Vitality.