Warrior DPS Calculation Spreadsheet - Page 156

Xannadu · 01/01/10, 12:49 PM

First of all, awesome/easytouse spreadsheet, exactly what i have been looking for to calculate dps metrix.

After calculating everything, i have found that using Needle-Encrusted Scorpion would benefit me most. However i am reluctund to gem around it. Ie: 51.4% arp to match 100% proc. I've been hearing different opinions/idea's but i'm not sure what to do. Other trinkets include: Banner of victory, Darkmooncard Greatness but they all show a lower DPS in the spreadsheet.

Your thoughts?

Thokk · 01/01/10, 12:56 PM

Some bug reports:

Sheet Version: 2.600cExcel07.xlsm
Office Version: 2010 Public Beta (v14.0.4536.1000)

Page: ARMS, FURY, LOOKUP
Type: REFERENCE
- Glyph of Enduring Victory is not a supported minor glyph. Granted, it doesn't matter DPS-wise, but it does keep throwing errors when importing.

Page: ARMS, FURY, LOOKUP
Type: REFERENCE
- Glyph of Bloodthirst shows up in the dropdown boxes for minor glyphs in both Arms and Fury pages, as well as in the listing in the options area of the Lookup page. However, it is a major glyph.

Page: LOOKUP
Type: TYPO
- Garfrost's Two-Ton Hammer is listed as being an Axe, but ingame it is a Mace.

Page: ARMS, FURY
Type: CALCULATION
- For a good number of cells, Excel throws a warning that the formula is inconsistent with its neighbors (roughly translated, my Excel is German). An example would be cell AE14 in both Arms and Fury sheets, but there's at least 20-30 others. So maybe it's intended?

Also, a question:

- Is the standard Arms rotation assuming that you use Bladestorm? If so, should I learn from this that I should start using Bladestorm on single targets? I was never really impressed with its performance in that regard before, but maybe I missed something...?

markabey · 01/01/10, 3:20 PM

Thanks for some of the fixes landsoul

made me spot new ones

Page: ARMS, FURY
Type: REFERENCE

PVP set bonus AP is not applied for 2 and 4 set

Ran Newman · 01/03/10, 5:41 AM

On the arms sheet, when removing all raid buffs and having only unimproved battle shout (also removing heroism/shattering), my dps increase by little more then 10 when changing latency from 250 to 300 (as in, my dps is higer when my lag is bigger). I don't know what other info might be required, if there is anything else you need to know say so and I will post it.

Skoobah · 01/03/10, 8:31 PM

Originally Posted by Kidnick

I do not see Mourning Malice represented in any of the spreadsheet's weapon list. Thanks.

Already mentioned but yeah, [Mourning Malice] is missing.

landsoul · 01/03/10, 10:46 PM

Originally Posted by Ran Newman

On the arms sheet, when removing all raid buffs and having only unimproved battle shout (also removing heroism/shattering), my dps increase by little more then 10 when changing latency from 250 to 300 (as in, my dps is higer when my lag is bigger). I don't know what other info might be required, if there is anything else you need to know say so and I will post it.

This comes from some inconsistencies in the Arms rotation. I am looking to redo it so that those little things won't happen.

Ashlan · 01/03/10, 11:51 PM

arp-trinket SEP-calc error

Page: Lookup

when calculating the SEP-value of a arp-trinket proc you refer to cells that already include the arp-amount of that proc

example: Needle-Encrusted Scorpion
the amount of effective arp in your calculation is: MIN(Fury!AK112;678)
but cell Fury!AK112 contains the gap to arp-cap if(!) the proc is already active.

with one arp-trinket this should be easy to handle - with two arp-trinkets and overlapping procs ... have fun

great work, thanks for the spreadsheet

Brakthir · 01/04/10, 10:04 AM

Quick question landsoul. Is the 2pc Tier 10 undervalued in the spreadsheet or is it not that much of a dps gain? I break 4pc tier 9 when I replace shoulders, and it's a dps loss unless the shoulders are the ilvl 264 ones, thus gaining dps through sheer itemization.

What's the approximate dps gain for 2pc tier 10?

Kurg · 01/04/10, 1:36 PM

It might be that the T9 4-piece is a bit overvalued. Switching out my T9 legs/gloves for Legplates of Painful Death and Gatecrasher gauntlets (and adjusting for the big drop in expertise) is actually a DPS loss, which is strange considering how superior those two items are in comparison to their respective T9 pieces. However, I too have noticed that the T10 2-piece doesn't seem very exciting, at least according to the spreadsheet. I realize that with nearly 60% raid-buffed crit % there is significant chance of a greatly reduced DW tick frequency, but I would still expect the 2-piece bonus to be more valuable than the spreadsheet indicates.

Shha · 01/04/10, 2:21 PM

Remember the spreadsheet assumes single target fights. Therefore you can do quick rough math here. 3% per tick, even with 1 tick per second only will give you expcted 1.8 procs per minute, and even then it will possibly overlap reducing it by around 1/7th. Thats a rough estimate but good enough for evaluating if the spreadsheet isnt vastly wrong. thats more or less 25% uptime of 16% ap buff or 4% ap. assuming buffed ap of 10k thats 400 ap, equal to roughly 150 str, and using the spreadsheet STR value around 330 dps. Thats for my gear.

So 330 dps is the upper limit, assuming no DW overlaps. Now looking at lets say Saurfang fight (where i can and will have some extra DW on beasts) I had 210 ticks over 390 seconds. You can see that will end being 177 dps increase. Remember that when worms go underground your ticks go off, same when icehowl runs around etc - overall beasts are one of best choices i had for a model fight , but hardly the best (Marrowgar has same problems with no dps times, saurfang i cleave/ww beasts for the extra DW). Spreadsheet shows it at 110 dps for me, so it actually feels a bit on the low side , even counting extra ticks. Still its nothing really breaking gear choices in a big way, and I accept that spreadsheet might be more correct then me on that one.

foopeemoa · 01/04/10, 3:37 PM

Sheet 2.600c
Excel 97 Version (also 2007 version)
Page: LOOKUP
Error Type: REFERENCE

Problem: Formulae for Arpen Proc trinkets (GT, MR, NES, IF) are using a logical on cell $C$9 to determine if the sheet is set to Fury or Arms, however they should be using $C$12. This makes the Proc SEP always use the Arms values, since cell C9 is blank.

Solution: Change the $C$9 to $C$12 in the Proc SEP field for both Trinket1 and Trinket2 sections for the following items: Grim Toll, Mjolnir Runestone, Needle-Encrusted Scorpion, and Incisor Fragment (Deathbringer's Will is correct). This makes the SEP of the proc more reasonable, although they still are undervalued (if you have one equipped currently) due to post #2333.

Ran Newman · 01/05/10, 7:02 AM

On the arms sheet, using [Death's Choice] and [Banner of Victory], [Death's Choice] have 32.15% uptime. Switching [Banner of Victory] to [Herkuml War Token], the uptime on [Death's Choice] changes to 32.16%. Switching to [Whispering Fanged Skull] I get 32.13% uptime on [Death's Choice]. 32.14% with [Deathbringer's Will].
While all this doesn't realy change anything in terms of gear choices, I would like to know the reason (if it's intended).

Note: [Comet's Trail] doesn't change the uptime, so I guss the extra uptime on [Herkuml War Token] can't be from haste.

Matsujinn · 01/05/10, 10:39 AM

Originally Posted by Shha

Now looking at lets say Saurfang fight (where i can and will have some extra DW on beasts) I had 210 ticks over 390 seconds. You can see that will end being 177 dps increase.

Why are you hitting beasts at all on the Saurfang fight? If you get close to them they hit you, which means Saurfang is getting more blood power. Ranged are supposed to deal with beasts to minimize blood power stacks. Makes me wonder if the top Arms DPS for this fight popped Bladestorm/SS when beasts came out... Though I guess if Saurfang died that makes it ok.

At any rate, let me get back on topic.

I'm Arms and the only warrior in my raid currently which means I'm stacking sunders and keeping them refreshed. I'm strongly concidering EXP capping just to be able to reliably keep my sunder stack up and wait until the last second to refresh, but I was curious if Landsoul could add some option to the spreadsheet to account for the DPS loss from stacking sunders and keeping them refreshed or when in the rotation the best time would be to refresh the stack. Currently I'm just refreshing sunder following my rend refresh at 24 sec which buys me time to refresh rend and sunder if I get really unlucky with dodges.

I haven't done much research on this topic, but would it be better for a rogue to be exposing or a hunter to be using a pet that can spit acid?

Durabolin · 01/05/10, 10:46 AM

Originally Posted by Brakthir

Quick question landsoul. Is the 2pc Tier 10 undervalued in the spreadsheet or is it not that much of a dps gain? I break 4pc tier 9 when I replace shoulders, and it's a dps loss unless the shoulders are the ilvl 264 ones, thus gaining dps through sheer itemization.

What's the approximate dps gain for 2pc tier 10?

I noticed the same thing and it made me hesitant on rushing out and getting my shoulders this week and running helm/shoulder t10, chest/leg t9, and the bitter reprisal gloves. I was thinking the 2pc t10 would be a great combination to run but in the SS only when I get the iLvL 264 shoulders does that become the case. I'm wondering also if 2pc t10 is undervalued or if its really not that great.

Matsujinn · 01/05/10, 10:50 AM

please remove