Warrior DPS Calculation Spreadsheet - Page 97

Crillick · 08/17/09, 2:28 PM

I have reached 9556 on the spreadsheet and I still have yet to write a formula for the Tier 9 4 piece.

Helm: Wyrnn's Helmet of Triumph (25H) [Relentless][10 Stats]
Neck: Collar of Ceasless Torment (10H) [+20 ArP]
Shoulders: Wrynn's Shoulderplates of Triumph (25H) [+27 ArP]
Back: Vereesa's Dexterity (25HT) [+20 ArP]
Chest: Wrynn's Battleplate of Triumph (25H) [+20 ArP][+20 ArP]
Bracers: Bracers of Untold Massacre (25H) [+20 ArP][+20 ArP]
Gloves: Gloves of Bitter Reprisal (25H) [+20 ArP][+20 ArP][+20 ArP]
Waist: Bloodbath Girdle (25H) [+20 ArP][+20 ArP][+20 ArP]
Legs: Wrynn's Legplates of Triumph (25H) [+27 ArP][+10 Str +10 Hit]
Feet: Greaves of the 7th Legion (25H) [+27 ArP][+10 Str +10 Hit]
Ring1:Gormok's Band (10H) [+20 ArP][+20 ArP]
Ring2:Planestalker Signet (10H) [20 ArP]
Trinket1: Death's Verdict (25H)
Trinket2: Comet's Trail (U25)
Weapon1: Justicebringer (25H)[+20 ArP][+20 ArP]
Weapon2: Justicebringer (25H)[+20 ArP][+20 ArP]
Ranged: Talonstrike (25H) [+20 ArP]

And now to the plus stat colloumn to accomidate the changes till the new spreadsheet,

+10 Agi (10 stat gem)
+91 Crit (2p Tier 9 Bonus)
+41 ArP (Since you can't add 2nd Ring Slot and +21 for Dragon's Eye)

This leaves you with
170 Hit
27 Exp
92.40 ArP
41.14 Crit
5499 AP

Originally Posted by Rushed

So how does gemming for strength work out, along with an ArP trinket?

I tried that as well, keeping the Runestone, as it is the better of the two. It is significantly lower, unless I was missing something.

BWarner · 08/17/09, 3:00 PM

Originally Posted by Shrakz

Hey guys, New poster here.

As I was reading the thread this week-end, I figured I'd try to help determining the glance chance and maybe save Landsoul some 25-50k attacks in afk mode.

There is no way we could get a big enough sample of attacks from 1 person to determine with a small margin of error the glance chance. So I thought of posting a "standard" protocol for some autoattacking tests to try and get autoattack samples from a lot of lvl 80 warriors.

If any of you wants to contribute, you can PM me your recount SS and I'll compile all the results. We could even get far more than 25-50k attacks this way but the results would only be relevant if we all follow the same protocol for the test. We could also use this to confirm with solid numbers the expertise cap/hit cap etc.

I'll be running my own tests using this setup:
. Orc warrior, Level 80
. Attacking training dummy from behind, without any armor or equipment with any stat.
. I'll be using a weapon that's not an axe (to not get any expertise from racial)
. No talents whatsoever for the test (completely empty talent trees, mainly to not get precision, weapon mastery, Str of arms)

So, to reproduce the test with almost any other warrior you should:
. Have empty talent trees
. Have no hit / expertise at all from your gear (I'd recommend naked to avoid repair costs)
. Not be a Draenei ...
. Not use a Sword/Mace if you're a human
. Not use a Mace if you're a dwarf
. Not send a sample that's too small for it to still be relevant and useful (I'm thinking about 2.5-5k attacks per sample should be fine and it would be great if I could get 10-20 samples). Of course, If you have time to provide a bigger sample, it's better.

If I missed anything relevant for the tests, please tell me !

Which dummy? Same-level? Or boss-level?

Shrakz · 08/17/09, 3:01 PM

Boss level sorry, didn't mention it ...

Dual wielding doesnt seem to affect the glance chance like it was pointed out in a previous post. In the SS I'm posting is a 13k hit sample, more to come during the week, i'll try to post a summary when I have about 100k hits overall or so.

http://i916.photobucket.com/albums/a...h13382hits.jpg

Killigan · 08/17/09, 4:13 PM

Originally Posted by Crillick

I have reached 9556 on the spreadsheet and I still have yet to write a formula for the Tier 9 4 piece.

And now to the plus stat colloumn to accomidate the changes till the new spreadsheet,

+10 Agi (10 stat gem)
+91 Crit (2p Tier 9 Bonus)
+41 ArP (Since you can't add 2nd Ring Slot and +21 for Dragon's Eye)

Forgot to change Dragon's Eye value on my sheet. So i was able to switch a 20 arp for a 20 str.
Then adding +91 Crit to my setup made the dps go as high as 9570. (Edited my previous post)

So changing the belt to Bloodbath one to get more expertise and switching the gemming to +10 Str +10 Hit doesn't seem to make much of a difference.

I don't see how you have comet's trail higher than Banner of Victory when you have ARP at near 1.45-1.48 SEP.
What is nice too : Banner can be easily farmed.

Originally Posted by Rushed

So how does gemming for strength work out, along with an ArP trinket?

I tried it as well. Couldn't reach "OVER 9000!!" dps if I remember right

Can't wait to play with new sheet!
Mucho love landsoul, keep up the good work.

Crillick · 08/17/09, 4:27 PM

Originally Posted by Killigan

I don't see how you have comet's trail higher than Banner of Victory when you have ARP at near 1.45-1.48 SEP.
What is nice too : Banner can be easily farmed.

Because 84 *1.45 is still only 121 that isn't modified by anything, where as the Comet's Trail static stat (262 AP Raid buffed) is roughly 132 Str equivalent.

The proc on the Banner is also only 1000 AP so roughly 1100 (raid buffed) / 2 = 550 str. Even at .77 SEP for haste, 726 haste is roughly 559 Str.

It's not a whole lot better, but it's better. About 30 DPS. I agree though on the easy to farm thing, lol.

[edit] Those values might change based on the difference in belt. I did those calculations with the SEP values from my setup. I'll check 'em against the mail belt when I get a minute later.

So changing the belt to Bloodbath one to get more expertise and switching the gemming to +10 Str +10 Hit doesn't seem to make much of a difference.

Yeah, this is basically a whichever drops first case to me, similar to the margin of difference between Comet's Trail and the Banner. Will have to see how it turns out with the new spreadsheet.

I tried it as well. Couldn't reach "OVER 9000!!" dps if I remember right

Yup, same result. Wound up roughly 400 DPS behind.

Tibor · 08/17/09, 4:27 PM

Dangerously close to a cross-post, I know, but how well is Mongoose modelled in the spreadsheet? In my current-gear Fury setup, Mongoose is almost neck-and-neck with Berserking, and would like to know if this is anomalous due to bad/out-of-date/incorrect modelling.

landsoul · 08/17/09, 10:32 PM

Mongoose is up to date. It's in line with zerking if your crit is low enough and you have more AP compared to it. I'm gonna try working on some more tonite and hopefully get a working release out by tomorrow. I've been very busy lately and I was not able to finish when I said, so sorry.

Edit: Also, how do you get wowhead item links to work with heroic items?

Grayson Carlyle · 08/17/09, 10:53 PM

Originally Posted by landsoul

Edit: Also, how do you get wowhead item links to work with heroic items?

[item]item#[ /item]:

[Hellscream's Helmet of Triumph]

Ancallagon · 08/17/09, 11:54 PM

Originally Posted by landsoul

Edit: Also, how do you get wowhead item links to work with heroic items?

To more elaborately explain the above, the items are two separate ID's in the database, not just an elevated version of the same ID.

[Dual-blade Butcher] -ID 47446

[Dual-blade Butcher] -ID 47285

Same name, one heroic, one not, different ID.

At least, I believe that's the question you were asking.

phantomlink · 08/17/09, 11:55 PM

whats the estimated range of Crit/AP for mongoose to work? roomate is leveling his old BC warrior so it might be a useful enchant for him

ZeTodu · 08/18/09, 2:59 AM

What about this two:
The World of Warcraft Armory
The World of Warcraft Armory

Flukeworld · 08/18/09, 3:03 AM

I manage my own item loot xls table for fast reference of loots i need, and i was thinking for a fast way to create wowhead links without searching for IDs, so i came up with this:

--In a separate column next to the item name colum:
=IF((ISNUMBER(SEARCH("",D37))),HYPERLINK(CONCATENATE("http://www.wowhead.com/?search=",D37),">>>"),"")

This way i deal with the problem is it heroic item, as it just will show both items in search result and you can mouseover check them.

Hope it helps (would be great to have something like that integrated in Lookup worksheet)

aggressions · 08/18/09, 4:30 AM

Is there any guide how to use this? I have Excel 2007 but getting errors from when trying to catch my armory...errors from some items aswell (it downloads my armory but not complete, but giving errors). And I have no clue how to add items on my own. :/ Which I guess I need to do?

Bickins · 08/18/09, 5:18 AM

Originally Posted by aggressions

Is there any guide how to use this? I have Excel 2007 but getting errors from when trying to catch my armory...errors from some items aswell (it downloads my armory but not complete, but giving errors). And I have no clue how to add items on my own. :/ Which I guess I need to do?

The error is due to the Module that pulls data from your armory's XML file, as they changed the xPath location.

change:

talentGroups/talentGroup[@active=""1""]

to

//talents/talentGroup[@active=""1""]

I checked with landsoul, he's aware and on top of all this for the next version.

landsoul · 08/18/09, 12:13 PM

Another thing, when pulling items from armory, how to differentiate between a normal and heroic item form armory?