Elitist Jerks
Register
Blogs
Urban Rivals
Forums
New Posts


Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Warriors
Elitist Jerks Login

gamerDNA Login

Welcome to Elitist Jerks
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!

If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.

Reply
LinkBack (747) Thread Tools
Old 01/29/09, 3:37 PM   #276
iwt2001
Glass Joe
 
Human Warrior
 
Anetheron
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.
 
User is offline.
Reply With Quote
Old 01/30/09, 9:49 AM   #277
Megalith
Glass Joe
 
Tauren Warrior
 
Jaedenar (EU)
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!
 
User is offline.
Reply With Quote
Old 01/30/09, 10:15 AM   #278
Gotrage
Glass Joe
 
Orc Hunter
 
Llane
Upgrade and SEP sorting

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?
 
User is offline.
Reply With Quote
Old 01/30/09, 11:46 AM   #279
MildCorma
Glass Joe
 
MildCorma's Avatar
 
Tauren Warrior
 
Grim Batol (EU)
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.
 
User is offline.
Reply With Quote
Old 01/30/09, 11:59 AM   #280
Mordenthal
Glass Joe
 
Undead Warrior
 
Bloodfeather (EU)
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.
 
User is offline.
Reply With Quote
Old 01/30/09, 12:04 PM   #281
Saizul
Von Kaiser
 
Troll Warrior
 
Shadow Council
Originally Posted by Mordenthal View Post
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.
Any chance your race is set to something with a weapon specialization that would bump you above the cap?
 
User is offline.
Reply With Quote
Old 01/30/09, 1:31 PM   #282
Pogues
Von Kaiser
 
Undead Warrior
 
Frostmane
Originally Posted by Saizul View Post
Any chance your race is set to something with a weapon specialization that would bump you above the cap?
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.
 
User is offline.
Reply With Quote
Old 01/30/09, 1:37 PM   #283
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
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
 
User is offline.
Reply With Quote
Old 01/30/09, 2:10 PM   #284
Ynox
Glass Joe
 
Tauren Druid
 
Dethecus (EU)
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)
 
User is offline.
Reply With Quote
Old 01/30/09, 5:03 PM   #285
Mightybeast
Glass Joe
 
Tauren Warrior
 
Aggramar
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?

Last edited by constantius : 02/06/09 at 11:02 AM. Reason: Back-to-back posts.
 
User is offline.
Reply With Quote
Old 01/30/09, 5:44 PM   #286
Saizul
Von Kaiser
 
Troll Warrior
 
Shadow Council
Originally Posted by Mightybeast View Post
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.
 
User is offline.
Reply With Quote
Old 01/31/09, 11:26 AM   #287
Mordenthal
Glass Joe
 
Undead Warrior
 
Bloodfeather (EU)
Originally Posted by landsoul View Post
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.
 
User is offline.
Reply With Quote
Old 01/31/09, 12:07 PM   #288
JohnoMel
Glass Joe
 
Human Warrior
 
Nagrand (EU)
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.
 
User is offline.
Reply With Quote
Old 01/31/09, 12:24 PM   #289
Pogues
Von Kaiser
 
Undead Warrior
 
Frostmane
Originally Posted by Mordenthal View Post
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.
 
User is offline.
Reply With Quote
Old 02/01/09, 9:58 PM   #290
nponoBegHuk
Glass Joe
 
nponoBegHuk's Avatar
 
Gnome Warrior
 
Tyrande (EU)
Originally Posted by Pogues View Post
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

Last edited by nponoBegHuk : 02/02/09 at 12:05 AM.
 
User is offline.
Reply With Quote
Old 02/01/09, 11:33 PM   #291
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
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
 
User is offline.
Reply With Quote
Old 02/02/09, 6:50 AM   #292
NinJOu
Von Kaiser
 
Orc Warrior
 
Illidan (EU)
Originally Posted by NinJOu View Post
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
 
User is offline.
Reply With Quote
Old 02/03/09, 1:40 AM   #293
Xabrophazon
Von Kaiser
 
Xabrophazon's Avatar
 
Dwarf Warrior
 
Garona
Originally Posted by iwt2001 View Post
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.
 
User is offline.
Reply With Quote
Old 02/03/09, 8:25 AM   #294
Zagtul
Glass Joe
 
Troll Warrior
 
Daggerspine (EU)
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?
 
User is offline.
Reply With Quote
Old 02/03/09, 9:06 AM   #295
Mace
Glass Joe
 
Night Elf Warrior
 
Dunemaul (EU)
Originally Posted by Zagtul View Post
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? ^^
 
User is offline.
Reply With Quote
Old 02/03/09, 8:13 PM   #296
Windchilla
Call it, friendo.
 
Windchilla's Avatar
 
Tauren Shaman
 
Cho'gall
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"
 
User is offline.
Reply With Quote
Old 02/04/09, 12:06 AM   #297
Illumina
Glass Joe
 
Orc Warrior
 
Tortheldrin
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.
 
User is offline.
Reply With Quote
Old 02/04/09, 3:09 AM   #298
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
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
 
User is offline.
Reply With Quote
Old 02/04/09, 3:31 AM   #299
Windchilla
Call it, friendo.
 
Windchilla's Avatar
 
Tauren Shaman
 
Cho'gall
Originally Posted by landsoul View Post
Posted an update. Check the front page.
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"
 
User is offline.
Reply With Quote
Old 02/04/09, 4:35 AM   #300
NobleHelium
Von Kaiser
 
Night Elf Warrior
 
Uther
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.

Last edited by NobleHelium : 02/04/09 at 2:30 PM.
 
User is offline.
Reply With Quote
Reply

Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Warriors

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mongoose calculation or simulation? sag_ich_nicht Public Discussion 1 08/05/08 10:59 AM
[Rogue] Backstab damage calculation Karmon Class Mechanics 5 11/04/07 6:22 PM
Range Calculation Nite_Moogle Theorycrafting Think Tank 0 09/21/07 1:02 PM
Ilvl calculation Drauk Public Discussion 9 03/24/06 5:30 PM