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.

 

Megalith

It's possible to see total hit, which is important to se how much above the hit cap one hoovers. Wouldn't it be possible to show total expertise for the same reason? Now it is some testing back and fourth with gems and gear to nail the cap since one just can see that one is capped, but not how much the overcap is.

A row with buffed stats right above the unbuffed ones would give a better overview. Thanks for a great spreadsheet!

 

Gotrage

Hey,

I was looking through the replys and find that someone already sugested an upgrade column but it really never got into the spreadsheet. I was thinking about the same thing for some time and was trying to figure out how exactly the SEP sorting works to calculate the best upgrade for a slot.

It just takes the value calculated by the SEP macro and sorts? If so, is there a possibility to make the sorting take in consideration the amount of SEP you lost by removing the piece of gear you are wearing.

For example: I'm wearing some piece of gear that makes me exp capped. SEP macro values exp to 0. If i take off that piece of gear exp should be valued higher and in some cases contribute to ranking an item higher than others during SEP sorting.

Or is this the way the items are already sorted?

 

MildCorma

Just wondering if anyone else is having trouble getting the spreadsheet downloaded, and if so if there is an alternative location? I've tried changing browsers, but it seems to be an FF issue.

 

Mordenthal

Is exp bugged? I'm at 125 exp rating, yet exp is valued at 0 on SEP calculations. As far as I know the cap is still 148 with 2/2 WMastery.

 

Saizul

Any chance your race is set to something with a weapon specialization that would bump you above the cap?

 

Pogues

I am having the same problem with EXP being returned as a zero value while I am still below the cap. I am positive that I turned off the racials because at first it was reporting my EXP as 23. I will doub check when I get home tonight and see if I remove all my EXP gear if it updates the SEP. I am using the current version of the spreadsheet and Excel 2007. All other SEP scores change when the macro is run.

 

• 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?

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

Ynox

As for the SEP order from Items just enable the Boxes that Hit and Expertise are always worth 1 SEP. Why that? if you are not Exp/Hit capped you change your 16 Strength points into what you need.

16 Strengh is 16 SEP so if you get enough Expertise from gear you are forced to take 16 Strengh gems.
But if you are not capped on Expertise/Hit then you should change your Gems to what you need.

Expertise Cap for Furry Warriors is at:

107 Expertise Rating (5 Expertise Racial)
132 Expertise Rating (3 Expertise Racial)
148 Expertise Rating (No Expertise Racial)

 

Mightybeast

I do not think you should make this spreadsheet 'dummy proof'. I think if a dummy opens up your spreadsheet (I was a dummy when I did), then the dummy should have to figure it out. It should be part of the learning process, it will give users a better appreciation and understanding for what the spreadsheet actually does. Maybe you could make a readme file or something that gives just the basic explanations so people don't continually have this problem.

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?

 

Saizul

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

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

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

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

There's a bug in the code. Lines 106-107 appear like
should be instead:
Replace R[-81] at the end with R[-74] and all should work fine.

edit: spelling

 

• landsoul

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

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

NinJOu

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

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

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

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

 

Windchilla

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.

"It's better to live one day as a lion, than a thousand years as a lamb"

 

Illumina

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

Posted an update. Check the front page.

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

Windchilla

Much appreciated mate, keep up the fantastic work.

"It's better to live one day as a lion, than a thousand years as a lamb"

 

NobleHelium

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.