Celandro

Deathwing: did you get the ftp site working? Filezilla should work fine, its what I use.

 

Deathwing

yep, got it working, thanks. I'm still working on slam some more, and deep wounds.

 

Deathwing

Ok, did some more error checking. Some of my calcs I forgot to switch up to level 70 for player level, so all builds will get a slight dps boost. Also, that lowers the significance of overpower(forgot to change the dodge percentage), such that at level 70, berserker stance/WW > battle stance/OP. 31 fury/30 protection still looks quite favorable, especially since you can stance dance with it. Notes:

Implemented an "excess rage" equation for slam similar to heroic strike, also fixed slam's RagePS field
Fixed hate generation for heroic strike
Fixed Windfury and SS dps, they weren't taking into account misses and dodges, and slams were being counted(which is wrong)
Modified WhiteMH and WhiteOH swings to account for slams replacing them
Fixed some more calcs regarding player level

http://www.rcsolid.com/deathwing/DPSWarriorv0.481.xls


Deep wounds is in there, as is a significant amount of slam changes. Let me know if they look wrong. Also, I assume if you use slam or heroic strike, you don't use the other.

 

polocabbit

I think you may have broken your spreadsheets with the alst few updates.

None of the buffs at the bottom. I noticed this when my white and overall dps didnt' change when I started adding in buffs.

edit: Nite_Moogle, I tried downloading and running your dps program, but it kept crashing on me.

"Doubt is the thief that often makes us fear to tread where we might have won.” —William Shakespeare

 

Deathwing

Can you check to make sure you have Iterations turned on and set to at least 20? Macros must be enabled too for the check boxes to work.

 

polocabbit

Weird, I opened and closed the sheet a couple of times before I posted. Did it again just now to double check and it's working now.

"Doubt is the thief that often makes us fear to tread where we might have won.” —William Shakespeare

 

Khalim

Deathwing love your work but....

- Shouldnt the starting stats reflect that fact that you have gained 10 levels?
- Also you havent put in the new ranks of hs, hamstring, battleshout and execute, which actually changes the different relative dps positions of the talent builds a fair bit

Don't worry about it too much anyway as this is an alpha and lots may change before BC comes out.

http://ctprofiles.net/2868856

 

Deathwing

What's equation for stats/level for races? I wanted to get out these changes before I left for home from work because I thought they were important.

 

• frmorrison

The starting stats can make about a 1-2 dps difference, Chalon's Rogue dps sheet deals with them.

http://wowvault.ign.com/View.php?vie...es.Detail&id=9 has a list of the starting stats.

DK - Ashbane Failure is the condiment that gives success its flavor.

 

Khalim

Couldnt find an exact link to how much you gained for each level. I took a bit of quick and dirty approach and took the level 60 stats minus level 1 stats, worked out average per level and applied it for lvl 60 + 10 levels to get to level base 70 stats

I used Dwarf:
Str:138
Stam: 127
Agi: 86

And yeah they make only a small difference. But the new ranks make a lot bigger difference i mean look at the increase:

HS dmg 247 compared to 157 (57%)
Hamstr dmg 63 compared to 43 (47%)
BS 305 compared to 235 (30%)
Exe 1070 compared to 600 (78%)

http://ctprofiles.net/2868856

 

Introvert

Forgive my ignorance - I don't have a spreadsheet program to check your file out.

Anyhoo, I'm a previous MT turned DPS-Arms speccing up for Fury. I know roughly the gear I need, but I also have some questions;

1) What is the 'best' (read: common) Fury spec?

2) What are the weapons I should aim for (My guild has everything up to Spider wing + Rezu down). To give you an idea - if I were to go Fury right this minute, I would be using Quel + Gutgore. Scary I know :P

 

Deathwing

Yeah, I'll put those in Khalim. Simple IF statement for level 70, it will change the spells.

As for introvert:

1. Common spec is 34 fury/17 arms. Get Flurry, Bloodthirst, DW spec, imp execute, imp overpower, impale.

2. At that point, I would get Harbinger of Doom for offhand, Crul'Shorukh, Misplaced Servo Arm, Noth Axe, CTS, or AQR for main hand. Or, you can go the dagger route since it has superiour +skill itemization. ACLG + Death's Sting + Harbinger is awesome.

 

gman

Any chance you could add Thick Obsidian Breastplate? Nice BP for guilds with bad annihilation drop rates that don't have cthun.

 

Joho

This being my first post on these forums, first off I want to commend you Deathwing for an excellent job on this spreadsheet, it far exceeds any other tool I have seen out there for warriors.

In regards to the stone buffs, it would be a lot better if you could pick which hand to buff. I am not sure if you know this or not, however if you use a stone buff in your main hand and there is a windfury totem down you will not be able to get windury. Therefore in all common sense all Horde warriors in a raid will only put stone buffs in their offhand and leave their main hand buff free in order to be able to receive windufury.

 

Antilles

Just posting to tack my name onto the list of supporters for stones assigned by weapon. I'm cheap so I just use a dense stone MH and elemental OH because I have no gold and really despise farming elemental earth.

But yeah, overall this spreadsheet is great and I attribute a lot of my improvement to it.

 

domer

Deathwing -

Inbox is full, send me a PM if you see this.

 

Deathwing

Ok, next version is up:

Added conditional statements for assumed updates for certain abilities. Spreadsheet still functions fine at level 60
Added Thunderclap
Added Rend
Modified Cooldown equation for slam. It was calculating the white rage cost incorrectly, as well as the maximum cooldown time
Added separate check boxes for MH and OH stones
Added misc. requested items
Added common set bonuses
Modified started stats to a per level basis up to level 70

http://www.rcsolid.com/deathwing/DPSWarriorv0.482.xls


A little bit more about the slam. I have it modeled currently such that I assume the user is slamming immediately after a white hit lands and is not chaining them. From what I understand, that's the best way to do it because you don't lose any extra white dps from the melee swing reset, only the white dps during the slam cast time. Grayson, you mentioned earlier that using an instant after slam causes the player to swing earlier...can you explain that a bit more?

Embarrasingly, the features I've said I would have in for a little while aren't in, namely the execution range weapon switch and the raw stats input. Because release TBC info, I put those to the side for a bit. I think I've covered them pretty well now, so I can get back to work on those.

Lastly, the DPS tab on my spreadsheet is getting quite large. I'll take suggestions from anyone on ways to consolidate the information. My goal is to keep so you can change any piece of gear/enchant/buff and see the affect on your dps immediately instead of having to scroll up and down constantly. The top parts of my spreadsheet are already out range :(

 

Rezarel

You can create two separate scrollable panes in Excel. Just above the scrollbar, there's a small horizontal bar - the top of the bar is flush with the top of the A B C... column headers. Drag that down to create a pane one row tall. Then you can make a cell in the first row "=TotalDPS" (or I guess you could just scroll that pane down to row 65), and it should always be visible as you scroll the larger second pane wherever you want.

Also, Cell A68 says "Gemerated" :) Thanks for the great spreadsheet.

 

• frmorrison

Well, you really need all those cells to do the calcs. What I have do is simple, I just go to a blank cell and type =C56 (assuming that was the Cell with DPS calc I was interested in). Not very elegant, but it saves you from having to scroll down.

DK - Ashbane Failure is the condiment that gives success its flavor.

 

Khalim

Hehe yeah thats what I do morrison :), I've set up some benchmark calcs on nearly every version too because I want to see the dps difference in number and % terms for when I compare different gear and specs.

Thanks for your work in updating this Deathwing, know its appriciated by all. Its interesting that i've basically given up stacedancing due to this sheet and now spamstring and overpower in battlestance. I also use hoj over my hard earned/farmed earthstike. Although I still think (gut feel) that earthstrike is better than what you have modelled it, if you ever get around to being able to specify use of deathwish and recklessness as well as any trinkets like earthstrike or diamond flask while executing I wonder I would be proven right. Also on long fights like chromagus and emps where I get to use it like 3-4 times.

Looking forward to next revision of warrior BC talents so we can test them on Deathwings spreadsheet :)

Again thanks for the good work!!

http://ctprofiles.net/2868856

 

• Ren

I have a question for you all. Should I main-hand Maladath or the Hakkari Warblade? According to the spreadsheet, the set is still better by a good margin. Here's what I've been considering:

Warblade main (set):
+28 AP
+1% crit
+1 sword skill
More efficient Heroic Strikes, more executes during spam mode, and 4 flurried swings instead of 3.

Maladath main (warblade offhand):
+6.7 white dps
Minimal gain to WW/OP numbers

What do you think? BTW, the spreadsheet rates the Warblades better than anything short of Death's Sting dagger combos and maces/swords out of Naxx.

 

Khalim

For a human that sounds about right, I would go with warblades until you get a better MH sword then use maladath.


Deathwing was thinking a bit more about trinkets with cooldowns. Wanted to show how earthstrike was superior to hoj in long fights because of multiple use. Changed the earthstike AP equation in the trinkets page to this:

(20*280/Trinket1CD)*(FLOOR(FightDuration/Trinket1CD,1)

That seems to work right and adjust dps properly for these trinkets. Equation should work for any trinket with a cooldown e.g. KOS. Also I'm not sure if you have adjust Deathwish for multiple use either, should be possible useing the same logic.

Also any luck on modeling recklessness use on execute phases?

http://ctprofiles.net/2868856

 

Emth

CTS/AQR + Maladath are better surely?

But all this is assuming you won't be using Edgemaster's, which isn't true for me at least :)

EDIT: Ah Human, well just shows the power of +skill

http://ctprofiles.net/404078

 

Deathwing

Not sure how this FLOOR function works, but it looks like you're doubling the trinket's power. Why? I would think the situation where these trinkets shine is short fights and trinket stacking.

 

Grayson Carlyle

FLOOR rounds down to the nearest integer. The second half of the equation figures out how many times during the fight the trinket will be used, the first half calculates the average AP bonus over time, then he incorrectly multiplies those two values, which would give an infinite AP value on an infinite fight.

To get an exact value to AP contribution over a fight, it should be AP by Duration by Full Cooldowns and Partial Cooldowns over Fight Duration, or TrinketDuration*AP*(FLOOR(FightDuration/CooldownLength)+MIN(MOD(FightDuration, CooldownLength), TrinketDuration)/TrinketDuration)/FightDuration

-edited: was originally done with ES on a 180s cooldown, fixed for 120-

Earthstrike in a 20s fight would then be:
20*280*(FLOOR(20/120)+MIN(MOD(20, 120), 20)/20)/20
20*280*(0+MIN(20, 20)/20)/20
20*280*(0+20/20)/20
20*280*(0+1)/20 = 280

Exactly what you'd expect the AP contribution to be.

Earthstrike in a 120s fight would be:
20*280*(FLOOR(120/120)+MIN(MOD(120, 120), 20)/20)/120
20*280*(1+MIN(0, 20)/20)/120
20*280*(1+0/20)/120
20*280*(1)/120 = 46.66

Earthstrike in a 130s fight would be:
20*280*(FLOOR(130/120)+MIN(MOD(130, 120), 20)/20)/130
20*280*(1+MIN(10, 20)/20)/130
20*280*(1+10/20)/130
20*280*(1.5)/130 = 64.66

Earthstrike in a 140s fight would be:
20*280*(FLOOR(200/180)+MIN(MOD(140, 120), 20)/20)/140
20*280*(1+MIN(20, 20)/20)/140
20*280*(1+20/20)/140
20*280*(2)/140 = 80