Warrior DPS Calculation Spreadsheet - Page 20

Saizul · 01/30/09, 4:44 PM

Originally Posted by Mightybeast

I do have a question though, assuming I have enough expertise to get rid of weapon mastery, where should those 2 talent points be going? Enrage? That seems to be the only place that would really add damage to my spec. Even then is it worth it? Shouldn't I just get rid of the expertise and swap out for strength and keep the talent points?

Probably more appropriate for directing to the simple questions or Fury discussion threads. Or just reading through them, where it has been addressed. Pretty sure this is specifically for discussing changes / improvements / usage of Landsoul's spreadsheet tool.

Mordenthal · 01/31/09, 10:26 AM

Originally Posted by landsoul

A lot of people don't recognize that the default race/settings change sometimes from my own testing and they don't set them back.

About expertise: Basically, if dodge rate says 0%, your SEP for expertise will most obviously be zero... If your unbuffed EXP stat is 18 or greater, then your SEP will be zero...

I try to make it as simple as possible but since its not dummy proof. Maybe I should make a video tutorial?

Race is UD. Racial exp on MH/OH is 0, no buffs except BS and Rampage and it comes out at a 0 SEP value. I tried replacing all my exp gear and recalculating, still 0 value.

JohnoMel · 01/31/09, 11:07 AM

I believe the expertise issue is due to the SEP macro pointing to the wrong cell when it looks for the expertise adder. If I hard code 8.197 into the macro it works OK. I get errors if I point to the correct cell in the macro, possibly because I am using Excel2003 and it is a merged cell. Or maybe I can't count.

My first post, so I'd like to say thanks Landsoul for a great spreadsheet which is really helping me.

Pogues · 01/31/09, 11:24 AM

Originally Posted by Mordenthal

Race is UD. Racial exp on MH/OH is 0, no buffs except BS and Rampage and it comes out at a 0 SEP value. I tried replacing all my exp gear and recalculating, still 0 value.

I just checked this as well. I removed all Exp gear I have, checked all racial settings and buffs, removed points from WM in the talent portion and with a null EXP rating the SEP remains zero. Of course, I am a dummy so who knows. :P Will try the fix mentioned above, thanks for the post.

edited: clarity.

nponoBegHuk · 02/01/09, 8:58 PM

Originally Posted by Pogues

I just checked this as well. I removed all Exp gear I have, checked all racial settings and buffs, removed points from WM in the talent portion and with a null EXP rating the SEP remains zero. Of course, I am a dummy so who knows. :P Will try the fix mentioned above, thanks for the post.

There's a bug in the code. Lines 106-107 appear like

    ActiveCell.FormulaR1C1 = _
        "=R[-53]C[-9]+R[-48]C[-9]+R[-41]C[-9]+R[-35]C[-9]+R[-26]C[-9]+R[-18]C[-9]+R[-11]C[-9]+R[-53]C+R[-45]C+R[-37]C+R[-30]C+R[-24]C+R[-18]C+R[-10]C+R[-2]C+R[-9]C[-9]+R[-7]C[-9]+R[-81]C[20]"

should be instead:

    ActiveCell.FormulaR1C1 = _
        "=R[-53]C[-9]+R[-48]C[-9]+R[-41]C[-9]+R[-35]C[-9]+R[-26]C[-9]+R[-18]C[-9]+R[-11]C[-9]+R[-53]C+R[-45]C+R[-37]C+R[-30]C+R[-24]C+R[-18]C+R[-10]C+R[-2]C+R[-9]C[-9]+R[-7]C[-9]+R[-74]C[20]"

Replace R[-81] at the end with R[-74] and all should work fine.

edit: spelling

landsoul · 02/01/09, 10:33 PM

Yeah, that's the culprit. thanks for finding that.

NinJOu · 02/02/09, 5:50 AM

Originally Posted by NinJOu

Hey Land,

I got something for you :

I'm an orc, got 2 Death's Bite and 2 points in Weapon Mastery.

I should have 13 EXP from stuff to get dodge capped. But in your xls, while i'm 13 EXP, i got still some % dodge from both hands on bosses.
However, when i recalc SEP values, EXP gives me 0.

Is it intended ?

Ok, in fact, the EXP number unbuffed (at the top of the sheet) adds the racial bonus from main hand to EXP from stuff.
I found this a little confusing but hey i gotta live with it :p

Xabrophazon · 02/03/09, 12:40 AM

Originally Posted by iwt2001

Is it possible to request a checkbox for unlimited rage or unlimited heroic strikes for certain fights like sapphiron or thaddius where pretty much every single MH swing will be a heroic strike? It'll be helpful for determining the amount of TPS tanks will have to keep up with as well as seeing how well damage scales with more rage.

Kind of a nitpick, but Sapphrion's Frost Aura does not generate rage.

I figured this out because of trying to fit Enrage in my spec, thinking that a small percentage damage increase might be beneficial in fights such as Sapphiron since his aura ticks every few seconds. Alas, his aura (and many other forms of large, non-directed AoE damage from bosses) does not generate rage, and thus cannot proc Enrage. An AoE ability will only generate rage in a PvE situation if it is physical, like a cleave, or normally if it's a frontal-cone AoE, like Sartharion's fire breath.

Zagtul · 02/03/09, 7:25 AM

Ok so i got the spreadsheet and what i get at lookup table is only helmets stats. Cant switch to watch other item types... Anyone can help?

Mace · 02/03/09, 8:06 AM

Originally Posted by Zagtul

Ok so i got the spreadsheet and what i get at lookup table is only helmets stats. Cant switch to watch other item types... Anyone can help?

There is a scrollbar.. tried scrolling to the right? ^^

Windchilla · 02/03/09, 7:13 PM

I'm using a trial version of Excel 2007 and it wont let me edit the sheet to make the outlined EXP:SEP fix above; if someone has an updated version they could link I'd be grateful.

Illumina · 02/03/09, 11:06 PM

Swordguard Embroidery doesn't seem to be adding any DPS at all. I switch between None and Swordguard Embroidery and nothing happens. Granted, tailoring isn't usually considered a good profession for plate dps, but I've actually found it to be pretty nice.

I've been testing SG Embroidery with procodile lately and it seems to have a 50s cd with an uptime of 15s. If I'm not mistaken, this gives an average of 30% uptime, although I've been seeing more of a 33% uptime. 30% uptime would be a static 100AP, which is far superior to the other cloak enchants available.

landsoul · 02/04/09, 2:09 AM

Posted an update. Check the front page.

Windchilla · 02/04/09, 2:31 AM

Originally Posted by landsoul

Posted an update. Check the front page.

Much appreciated mate, keep up the fantastic work.

NobleHelium · 02/04/09, 3:35 AM

Based on data in the Fury DPS thread, it seems that Deep Wounds has been nerfed to no longer double dip from damage multipliers. I assume the spreadsheet currently uses the double dipping and needs updating.

Edit: conclusion may have been premature, sorry. It's still being discussed over there.