Warrior DPS Calculation Spreadsheet - Page 2

IggyMac · 12/01/08, 6:04 PM

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.

• LodeRunner · 12/01/08, 6:37 PM

Originally Posted by landsoul

Can anyone get a hold of some of the answers to "questions needing answered" please?

As far as the different race stats, is this a simple matter of getting naked and writing down stats? If so, I can probably get Horde races for you tonight.

• landsoul · 12/01/08, 6:39 PM

No, I have no idea what you are talking about. What is not included that you only have access to? If you want a different item in any slot you go to Set1 and change what item you wear if its different than what I am wearing. It gives you a drop down menu and you find your item.

Anyways, important update/build is up. Changes on the front page you can read them.

Edit: Yes Lode that would be hot. Please also make sure to record base attack power.

IggyMac · 12/01/08, 6:59 PM

Originally Posted by landsoul

No, I have no idea what you are talking about. What is not included that you only have access to? If you want a different item in any slot you go to Set1 and change what item you wear if its different than what I am wearing. It gives you a drop down menu and you find your item.

No no. What I'm saying is that it's a pain to insert a NEW item that isn't in the list (there were plenty of missing ones when I DL'd it earlier today), just because of the layout of the item tab.

• landsoul · 12/01/08, 8:54 PM

What item are you missing? Its fairly easy to insert an item you just put it there in the list!

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

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

• Morsexy · 12/02/08, 3:36 AM

300 Whirlwinds with Berserking in offhand and zero procs.

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

Undead Race Base stats @ 80:

STR 173
AGI 111
STA 160
Base Health: 9541

Vhad · 12/02/08, 8: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, 9: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, 1: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, 1: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, 1: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, 2: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, 2: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, 4: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, 4: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, 6: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, 8: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, 7: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.

zinv · 12/03/08, 10:25 PM

Hi, would it by any means be possible to unlock the cell which defines the armor of the target in the spreadsheet ?
The wotlk boss armor seems as far as determination goes to be 13083, if i didn't overread anything.

• landsoul · 12/04/08, 12:16 AM

As far as what determination goes? Can you show me?

IggyMac · 12/04/08, 12:38 AM

Originally Posted by landsoul

What item are you missing? Its fairly easy to insert an item you just put it there in the list!

My bad, I figured it out (I'm used to the 10 year old version of excel, not the new one).
As for the missing item so you can slot it into future versions Heroes' Dreadnought Helmet is missing in the latest version.

Tauren base stats:
Str 179
Agi 108
Stam 161
Int 31
Spirit 61
Armor 216

zinv · 12/04/08, 5:00 AM

Sorry, I thought as it is in a thread located in this forum it would be unnecessary to post a link to the thread.
I don't know how that idea got into me.
well, here is the link to the Wotlk boss armor determination thread : Wrath boss armor testing

Rallik · 12/04/08, 5:11 PM

On the rage generation question, there's no difference in the formula between 2h and 1h. Formula is (7.5d/c + fs)/2 or 15d/4c + fs/2 if you want to factor out the normalized rage portion. d is damage, c is the constant based on level, f is the hit factor, s is the weapon's base speed. f is 3.5 for MH hits, 7 for MH crits, 1.75 for OH hits, and 3.5 for OH crits. The post below is the original source, but the hit factors were improved slightly from those values within a patch or 2, can't remember which. But basically, all it considers is hit/crit and wep speed, not 2h/1h.

World of Warcraft (en) Forums -> The new Rage formula (by Kalgan)

On a different note, does anyone know off the top of their head if armor gained from things like devo aura and stoneskin totem give you AP from att?