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 11/05/09, 6:39 PM   #1976
NobleHelium
Von Kaiser
 
Night Elf Warrior
 
Uther
Originally Posted by landsoul View Post
Changes in 2.502:
-Increased the amount of armor penetration required for 1% from ~12.316 to ~13.996.
-5/5 Sword spec now grants a 10% on-hit chance for an extra attack, 10 second ICD.
-Changed stats of certain items reflecting the patch.
-Fixed some Horde/Alliance item name differences.
-Added all known Onyxia items.
-Fixed an issue with item comparisons when using a stat increment for SEP other than 1.
-Fixed an issue causing Siegebreaker Battlegear's (2pT8) haste proc not being added into DPS.
Well, it's in the first post.
 
User is offline.
Reply With Quote
Old 11/05/09, 10:29 PM   #1977
Hatchet81
Glass Joe
 
Orc Warrior
 
Auchindoun (EU)
Armory import error

I am probabbly doing this wrong, but seems like the spreadsheet cant find european armory. I have enabled macros, but still get errors. Anyone know what I should do? Thx

*edit*
Nvm, got it :o

Last edited by Hatchet81 : 11/05/09 at 10:35 PM.
 
User is offline.
Reply With Quote
Old 11/06/09, 6:04 AM   #1978
soujeh
Von Kaiser
 
Tauren Warrior
 
Tarren Mill (EU)
Originally Posted by landsoul View Post
I don't see where you are pulling the ICD as 10s from. Maybe you are misunderstanding.
Changes in 2.502:
(...) -5/5 Sword spec now grants a 10% on-hit chance for an extra attack, 10 second ICD

That's from the first post. Is it just a typo? I believe I've seen 10 seconds sword spec proc ICD being used in arguments around these forums too, but don't quote me on that.
 
User is offline.
Reply With Quote
Old 11/06/09, 6:19 PM   #1979
Stahlien
Glass Joe
 
Tauren Warrior
 
Draka
So I just downloaded the spreadsheet and was inputing all my gear. I got everything filled in and was looking over some stuff and realized that I hadn't changed the race. I switched it from Night Elf to Tauren and the calculated dps metric dropped almost 2000.

Is this because the gear that is listed is all alliance based, and I should just keep the race as alliance? Or is there a way to adjust the sheet to use horde items?
 
User is offline.
Reply With Quote
Old 11/06/09, 7:50 PM   #1980
Pirie
Glass Joe
 
Orc Warrior
 
Kil'Jaeden
The sheet automatically uses horde items when you change races, it just doesn't update the items you have selected to their horde equivalent. Just click on the item and select it's horde equivalent.
 
User is offline.
Reply With Quote
Old 11/06/09, 10:05 PM   #1981
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
^ this.

Sorry the front page update info is definately a typo, sorry about that.

Also, I am looking to do something new in terms of formatting maybe a new backdrop texture, intro page background, new functionality something. Let me know what you want or give me your suggestions.

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 11/07/09, 1:09 AM   #1982
BWarner
Von Kaiser
 
BWarner's Avatar
 
Human Warrior
 
Uldum
Originally Posted by landsoul View Post
Also, I am looking to do something new in terms of formatting maybe a new backdrop texture, intro page background, new functionality something. Let me know what you want or give me your suggestions.
Hello Kitty. Definitely.

To get you started:





...


In all seriousness, I'll try some stuff in the sheet to see what styles / types of textures work well with it. Question: when you say "...new functionality something.", what do you have in mind?

Last edited by BWarner : 11/08/09 at 1:05 AM.

The Warrior Formerly Known as Aerowyn.
 
User is offline.
Reply With Quote
Old 11/07/09, 5:41 PM   #1983
Anduryondon
Von Kaiser
 
Undead Warrior
 
Blackrock (EU)
Originally Posted by landsoul View Post
^ this.

Sorry the front page update info is definately a typo, sorry about that.

Also, I am looking to do something new in terms of formatting maybe a new backdrop texture, intro page background, new functionality something. Let me know what you want or give me your suggestions.
I think a macro where you can select difference pieces of gear and then gives you the best item choice for this setup dps wise would be nice (if this is possible). Would save a lot of work with comparing different items setup, especially when new items are obtained.
 
User is offline.
Reply With Quote
Old 11/08/09, 12:19 AM   #1984
alienangel
Bald Bull
 
alienangel's Avatar
 
Draenei Hunter
 
Eredar
Originally Posted by landsoul View Post
Also, I am looking to do something new in terms of formatting maybe a new backdrop texture, intro page background, new functionality something. Let me know what you want or give me your suggestions.

Wishlist-wise, I think the following would be nice for convenience:
- a button or option to swap your MH and OH weapons as fury. While upgrading my alt's gear I've been through several different pairs of weapons and even though it's usually pretty obvious, confirming which one to main hand is always a bit of pain for socketed weapons or weapons with different enchants.
- a cell that generates a Pawn import string for your current SEP values. This would only be useful to people who actually use Pawn, but for them it makes keeping up to date Pawn scales really convenient. The hunter spreadsheet at WotLK DPS spreadsheet for instance automatically generates such a string (on the overview tab, underneath the equivalent of the SEP table) and you can just copy to clipboard and paste it into Pawn's Import box ingame
- a bit of explanation, perhaps on the intro sheet, on how to interpret the information presented in the Execute table. Perhaps I'm alone in this, but I've never been able to figure out what the 3 intercept values there mean, and had trouble finding the DPR/DPGCD values to compare to for WW/BT/Slam at the rage points the table lists (I assume the values in the Execute table are all for Execute itself).

And this last isn't really a layout suggestion, but having the sheet disable your metagem when your current gems don't satisfy the requirements would be nice.

edit: and if you're really in the mood for a large change, support for saving different profiles would be handy - i.e. having named configurations of gear and talents you can switch between from a dropdown, without having to keep around multiple copies of the sheet.

Last edited by alienangel : 11/08/09 at 12:27 AM.
 
User is offline.
Reply With Quote
Old 11/08/09, 4:59 AM   #1985
Opalira
Von Kaiser
 
Night Elf Warrior
 
Lightbringer
Cleave and whirlwind make huge contributions in a fight like Anub. I think it would be interesting to see DPS if there are multiple targets, and how that impacts SEP.
 
User is offline.
Reply With Quote
Old 11/08/09, 9:35 AM   #1986
xavier2k3
Von Kaiser
 
Human Warrior
 
Kor'gall (EU)
Regarding BiS lists on the front page. When using 1 DV, I dunno if anyone else has found this by playing with the spreadsheet, I obtain higher dps from using the [Belt of Deathly Dominion] and [Greaves of the 7th Legion] rather than using [Bloodbath Belt] and [Icewalker Treads] as suggested in the 2nd option of gearing for fury.

Last edited by xavier2k3 : 11/08/09 at 11:08 AM.
 
User is offline.
Reply With Quote
Old 11/08/09, 1:25 PM   #1987
Ronninn
Glass Joe
 
Human Warrior
 
Kael'thas
I agree that having an automatically generated PAWN string in the spreadsheet would be pretty handy for anyone using the PAWN addon. If the spreadsheet had an "Optimize Gemming" button that calculated the optimal gemming for you character, and possibly even the best food to buff with, I’d be willing to bet a lot of people would be excited about this functionality. It could take into consideration if you where a Jewelcrafter, or had extra gem slots from being a Blacksmith. The same could be said for having a "Optimize Enchants", but I think most people should know which enchants they should be using at this point.
 
User is offline.
Reply With Quote
Old 11/08/09, 2:22 PM   #1988
BWarner
Von Kaiser
 
BWarner's Avatar
 
Human Warrior
 
Uldum
Expanding on what Anduryondon suggested: support the import / export of CSV files through macros.

This would accomplish a few things:
  1. Allow users to save character setups for archival purposes (through exporting a CSV file of the character)
  2. Allow users to load character setups (through importing a CSV file)
  3. Allow users to import non-spreadsheet generated character setups (eg. Rawr's)
  4. Facilitate quicker and easier comparisons between various gear setups

Another option I'd love to see is allowing the user's choice of potion from the popular suspects (Speed, Wild Magic, Indesructible), with the additional option of pre-potting an Indestructible. Creating options in the existing dropdowns for the best Elixirs, as well as the +Armor Guardian Elixir, would be great for comparison purposes, as well.

The Warrior Formerly Known as Aerowyn.
 
User is offline.
Reply With Quote
Old 11/09/09, 9:48 AM   #1989
DarkS
Von Kaiser
 
DarkS's Avatar
 
Undead Warrior
 
Daggerspine (EU)
An "auto-gem" feature when you equip an item with sockets would be helpful. Even if you need to change the gem after for socket/meta bonus. After all you end always selecting the higher SEP gem for your sockets and this could be easily done by the sheet when you select the item. It would save time while playing with lots of gear.
 
User is offline.
Reply With Quote
Old 11/10/09, 2:26 AM   #1990
jgarver
Glass Joe
 
Tauren Warrior
 
Smolderthorn
Lookup error

I'm kind of an excel noob, so I was wondering if anyone could help me. Every time I enter my info to look up my gear, it looks up everything through my chest piece, and then gives me an error message;

Run-time error '1004':

Unable to get the VLookup property of the WorksheetFunction class.

Would this be a problem with my excel program? Or is it a macro error or something?
 
User is offline.
Reply With Quote
Old 11/11/09, 9:50 AM   #1991
Malindo
Glass Joe
 
Draenei Warrior
 
Ysera (EU)
Originally Posted by DarkS View Post
An "auto-gem" feature when you equip an item with sockets would be helpful. Even if you need to change the gem after for socket/meta bonus. After all you end always selecting the higher SEP gem for your sockets and this could be easily done by the sheet when you select the item. It would save time while playing with lots of gear.
^this is the only thing the spreadsheet is really missing. Would be great if you could implement that landsoul.

Another thing would be some kind of more filtering in the lookup, e.g. 10man and 25man --> for those "dedicated to insanity 10man" or "herold of the titans 10man" set builders. right now theres no difference in 10man or 25man colours. could be easily solved with light tones for 10man and darker tones for 25.

keep it up! love you landsoul!
 
User is offline.
Reply With Quote
Old 11/11/09, 9:50 PM   #1992
Reeno
Glass Joe
 
Human Warrior
 
Defias Brotherhood (EU)
They've just released some incomplete loot lists for the 5-man ICC instances on mmo-champion and theirs a pretty interesting trinket dropping in there - Needle-Encrusted Scorpion - Items - Sigrie

What confuses me however is how Mjolnir is 6 ilv lower than it yet the only difference is 12 crit rating at a huge cost of 213 ArP on the proc. Assuming we model it in an ideal world with it proccing every 45 seconds thats an average loss of 47 ArP rounded down. I can only assume this is either a placeholder with an incorrect value or blizzard have messed about with ArP itemization believing that mjolnir was too great of an asset to ArP friendly classes.
 
User is offline.
Reply With Quote
Old 11/12/09, 12:25 AM   #1993
Shha
King Hippo
 
Night Elf Warrior
 
Scilla
Probably the latter, this trinket might be a good "transitional" trinket for icecrown tbh. Something for when your gear carries you past mjolnir soft cap, but not yet to the point of going for 100% passive ARP.
 
User is offline.
Reply With Quote
Old 11/12/09, 3:09 AM   #1994
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
I put it into the sheet already.
I ran a little test to see which was better using runestone or scorpion and here's how it worked.

I equipped 2 DV's and used a mix of ICC and TOC gear and then got my armor pen 667 from the cap mixing gems.
I then equipped Runestone in place of 245 DV and got 2 rating from the cap.
I then re-equipped the 245 DV and got my armor pen 459 from the cap mixing gems.
I then equipped Scorpion in place of 245 DV and got 7 rating from the cap.

Runestone was significantly better. To visualize how it is better without doing math, think of it this way:

With runestone proc up, you have 200+ more STR than with Scorpion proc up.
With procs down, you have 200+ less ArP and 200+ more STR with Runestone than with Scorpion.

The increased passive armor pen at the cost of strength at that armor pen level to make the trinkets work, is not worth the strength loss when the proc is up.

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 11/12/09, 11:28 AM   #1995
Shrakz
Glass Joe
 
Shrakz's Avatar
 
Human Warrior
 
Undermine
I was more thinking there maybe was an itemization error on this new trinket since the proc really seems too low ... or maybe the uptime is higher than it is for Mjollnir/Grim Toll. What do you guys think ?
 
User is offline.
Reply With Quote
Old 11/12/09, 12:34 PM   #1996
Grayson Carlyle
Take what ye can
 
Grayson Carlyle's Avatar
 
Orc Warrior
 
Turalyon
A 33% loss in the linearly extracted ArP rating on the trinket from what you'd expect could be made up for with a 50% increase in uptime. I'd much rather see that anyway, so we don't have to try so hard to keep below the ArP soft cap with a proc as high as Mjolnir.
 
User is offline.
Reply With Quote
Old 11/12/09, 1:25 PM   #1997
Shha
King Hippo
 
Night Elf Warrior
 
Scilla
Originally Posted by landsoul View Post
I put it into the sheet already.
I ran a little test to see which was better using runestone or scorpion and here's how it worked.

I equipped 2 DV's and used a mix of ICC and TOC gear and then got my armor pen 667 from the cap mixing gems.
I then equipped Runestone in place of 245 DV and got 2 rating from the cap.
I then re-equipped the 245 DV and got my armor pen 459 from the cap mixing gems.
I then equipped Scorpion in place of 245 DV and got 7 rating from the cap.

Runestone was significantly better. To visualize how it is better without doing math, think of it this way:

With runestone proc up, you have 200+ more STR than with Scorpion proc up.
With procs down, you have 200+ less ArP and 200+ more STR with Runestone than with Scorpion.

The increased passive armor pen at the cost of strength at that armor pen level to make the trinkets work, is not worth the strength loss when the proc is up.
I think Runestone vs Scorpion is really no direct contest. If you are below arp soft cap from GEAR, then Runestone clearly wins. All i said is that, MAYBE ICC gear will leave us with 900+ PASSIVE arp before gemming (not hard to do with TOC gear, although not practical because of expertise lacking etc). Which means Mjolnir wont be an option anymore (as it will lose to 245 DV).

Only test to really matter i think is : Assuming increase in ICC gear to easily geyt us to higher ARP then toc, will it be better to have

400 STR + Scorpion

or

400 ArP + Deaths Verdict (245)

Again - if you are low enough on GEAR ArP so that mjolnir is fully utilized, then its clearly better. But it might not be the case in ICC.
 
User is offline.
Reply With Quote
Old 11/12/09, 1:45 PM   #1998
Reeno
Glass Joe
 
Human Warrior
 
Defias Brotherhood (EU)
Originally Posted by Shrakz View Post
I was more thinking there maybe was an itemization error on this new trinket since the proc really seems too low ... or maybe the uptime is higher than it is for Mjollnir/Grim Toll. What do you guys think ?
I haven't looked into item budget for proc based items, however it could just be the scorpions ilv 219 and will drop on normal when it goes live (Anyone who can derive the procs budget please feel free to correct this) assuming the datamined values on mmo-champion are incorrect.

However I'm still adamant that its a placeholder, I find it extremely unlikely that Blizzard would mess about with proc budgets since all the other ArP gear in ICC has scaled properly with its ilv besides this trinket.

Also correct me if i'm wrong but does there even exist a proc trinket which breaks the 45 internal CD rule? as if their isnt I doupt they'd start here with this.
 
User is offline.
Reply With Quote
Old 11/12/09, 2:27 PM   #1999
Shha
King Hippo
 
Night Elf Warrior
 
Scilla
On other hand the 2h from 1st boss is strange. The complete lack of stats (almost) coupled with faster speed made me very reluctant about it. Im still reluctant to say it will replace TOGC weapons (well at least heroic JB), but the proc indeed is very powerful as it seems. It added 360 dps or so to our DK, a bit over 400 for me. Considering its a normal weapon, heroic one might be interesting.

The proc didnt seem to have any ICD, and do more healing then BT self heals too. I guess if nothing else double axe might be fun to solo some weird shit as fury (dual axe provides quite a lot of healing).
 
User is offline.
Reply With Quote
Old 11/12/09, 3:33 PM   #2000
Reeno
Glass Joe
 
Human Warrior
 
Defias Brotherhood (EU)
Originally Posted by Shha View Post
On other hand the 2h from 1st boss is strange. The complete lack of stats (almost) coupled with faster speed made me very reluctant about it. Im still reluctant to say it will replace TOGC weapons (well at least heroic JB), but the proc indeed is very powerful as it seems. It added 360 dps or so to our DK, a bit over 400 for me. Considering its a normal weapon, heroic one might be interesting.

The proc didnt seem to have any ICD, and do more healing then BT self heals too. I guess if nothing else double axe might be fun to solo some weird shit as fury (dual axe provides quite a lot of healing).
Yea I first assumed it was a 45 second internal CD making the DPS of it very sub-par compaired to Decimation & Heroic JB, however hearing that there is no CD sounds pretty interesting as to simulating it and working out the proc rate. The speed on the otherhand is still dissapointing however, you would of thought 3.6 would of been staple in the last raid of Wrath.
 
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