I am trying to work out some SEP values for my Warrior spreadsheet at the moment. The problem I have encountered is that having a not hit-capped set of gear leads to a value for Hit that is way too high (bumping suboptimal items with 24+ hit rating on top of the Lootrank list).
Having a hit-capped set of gear leads to really diminished values for best in slot items that have hit on them. What have some of you done to work around this? I've tried setting hit to half its value or a third, but I don't really like that.
The SoC is not in the actual version of the spreadsheet. Is that rigth? Or is there a newer version of the spreadsheet that is not in the starting thread...
The SoC is not in the actual version of the spreadsheet. Is that rigth? Or is there a newer version of the spreadsheet that is not in the starting thread...
It isn't in the released version. I'm touching things up right now and will likely get a new release out the door this afternoon.
I know it's been a while, but this update should get things more or less up to date for 2.4. I did a little extra testing, and it looks like all 6 pages are operating correctly. For me anyways... If anyone spots anything, please point it out so i can fix it.
Changelog: v330 5/15/2008
Added Akil'zon's Talonblade
Added list of armor values to Buffs sheet from [RAID] Boss armor values
Corrected an issue causing sExe5 to #/N/A the fuck out; ended up having to correct via brute force
Corrected a bug where matched speed weapons were not taking haste into account when determining execute cool down
Added slight value to Sta and Resil in SEP calculations ONLY when PVP mode is set in Gear1
The actual effect on SEP values is not large, and is actualy fairly under-valued compared to the actual effect these stats have in pvp
The idea is to simply give the stuff with resil and Sta a slight SEP edge in PvP mode, for comparison purposes
Added Shard of Contempt (finally) and modeled it's proc based upon 1ppm, 45s internal CD
Have you modeled the Aldor/Scryer versions of the SSO rep necklace? From my experience, the aldor version of the necklace has the same proc rate as the SoC. Going by WWS data, on average both the necklace and the trinket procced about once every 50 seconds, so they seem to have an effective uptime of about 20%.
I'm currently trying to decide if the SSO necklace is better or worse than the Choker of Serrated Blades.
Did you change something for execute weapons?
When I put together my equip, the old version says don`t execute, go on with slam rotation, the new version says execute. Doesn`t matter if I choose execute weapons or not? And I`m pretty sure that execute is crap for me (2h Slam Warrior with Cats Edge and BT equip)... And when I choose execute weapons, the dps for executing doesn`t change. I Get same dps for 2 88dps weapons as for 2 100 dps weapons...
I figured out why though, it must've been because i had combat mode on different settings, also dedicated execute weapons on different settings as well, all good now. http://i48.photobucket.com/albums/f2...arriorDPS2.jpg.
I don't know why but I've never been able to get this spreadsheet to work. Whenever I update SEP values it all gets set to 0 and I have to to bounce back and forth between pages spamming "f9" in order to get any calculations to even be near correct.
Added gem sockets for neck and back slots (no more adding gem stats into the item manually in Warrior_Items!)
Updated SEP macro, seems to be running well now; remember - Gear1 SEP is used to calculate item total SEP value (used for comparison purposes only, it makes a handy value to use for sorting in Warrior_Items.xls if nothing else))
Corrected an error in 2-hand execute DPS which was causing inflated values (This one has been around since separate execute weapons were introduced it looks like)
Corrected haste for Vanir's Right Fist of Brutality
Thanks for the bug reports and such. Keep 'em coming. Feature requests/suggestions are good too. Everything posted so far should be fixed up and good to go. Btw, I currently sort items by their approximate SEP value, best to worst. Another option is alphabetical. What do people prefer?
Jokal, what program are you using to view the spreadsheet? Macros like the SEP calculator are pretty picky about what they run on. I do everything in Microsoft Excel 2003, and the macros are done with some sort of Visual Basic extension or something. I don't really know a lot about the software, I just write the sheets figuring shit out as I go along. Basically, if you aren't using Excel, I've not a clue what to tell you to try. If you are using Excel and it don't work still, I suggest physical abuse. A good solid punch followed by a side kick helps to "re-seat the cards" inside the computer.
my guild is about to clear BT, Council should go down this or next week. After improving my gear with quite some drops I'm beginning to think about the path I'm heading with my equipment.
So far, I've been focusing mostly on my AP with keeping my hit and crit at a decent level, although never really focused on stats like armor penetration or haste. As haste shouldn't be much of a concern (just no quality items with that stat), I begin to wonder how important armor penetration is for me.
Especially with Items like the plate pants of Bloodboil I'll have to decide if I should go down that path, as there are other great items on that slot like the plate pants of Archimonde and the mail ones from Azgalor.
Here are my stat, unbuffed in zerk stance, fury gear and spec:
- How can I compare armor penetration to pure AP or crit?
- At wich point should I start to focus on armor penetration?
- Does it really make a difference in pure PVE-DPS if you go massively on AP or armor penetration?
I hope you guys can help me to decide how to handle that stat in the future - if you have any other questions regarding my gear or other important raidwise stuff, just ask!
my guild is about to clear BT, Council should go down this or next week. After improving my gear with quite some drops I'm beginning to think about the path I'm heading with my equipment.
So far, I've been focusing mostly on my AP with keeping my hit and crit at a decent level, although never really focused on stats like armor penetration or haste. As haste shouldn't be much of a concern (just no quality items with that stat), I begin to wonder how important armor penetration is for me.
Especially with Items like the plate pants of Bloodboil I'll have to decide if I should go down that path, as there are other great items on that slot like the plate pants of Archimonde and the mail ones from Azgalor.
Here are my stat, unbuffed in zerk stance, fury gear and spec:
- How can I compare armor penetration to pure AP or crit?
- At wich point should I start to focus on armor penetration?
- Does it really make a difference in pure PVE-DPS if you go massively on AP or armor penetration?
I hope you guys can help me to decide how to handle that stat in the future - if you have any other questions regarding my gear or other important raidwise stuff, just ask!
PS: Hope that is the right place to post this :P
How about downloading the spreadsheet and actually inputting the gear and finding out for yourself? The entire point of these spreadsheets (not the thread) is to answer questions like this.
As for Arp go for it. So far as I`m concerned best stat fpr a Warrior out there (As long as you have more than only 200 or so).
I found a problem in the spreadsheet.
If you chose shivering Felspine, you don`t get the crit Bonus from Axe/Polearms Spec. You must change the type of weapon for shivering felspine to 2h axe to make it work. Would be nice if you could get that error out of way^^
How about downloading the spreadsheet and actually inputting the gear and finding out for yourself? The entire point of these spreadsheets (not the thread) is to answer questions like this.
Well I mostly wanted an explenation WHY Arp is so good as all say and from wich point on and compared to how much AP for example. But I'll get it, although I don't believe it'll give me all the answers :P
Problem with Arp is that you cannot say so much ArP equals so much Ap. That`s because Arp gets better the more you have...
So till a certain point Ap is better than Arp, because 100 Arp doen`t do much dmg. But when you reach the point where Arp is better than Ap, I cannot tell you. So best way is download the spreadsheet and just try it out.
Also you are missing vanir's left fist of brutality which is a must for 45 badges.
Vanir's Left Fist of Brutality
Binds when picked up
Off Hand Fist Weapon
180 - 335 Damage Speed 2.50
(103.0 damage per second)
Durability 75 / 75
Requires Level 70
Equip: Improves hit rating by 21.
Equip: Improves haste rating by 23.
Equip: Increases attack power by 44.
Not that, but I see that badge offhand as equal or even worse then my current weapons, due to its crappy speed.
The fact that it's speed is not the same as your mainhand is MUCH more important that what it's speed actually is. The misconception is that slow weapons mean a poor execute phase, but this is not the cause. The real cause is matched speed weapons resulting in long intervals between executes. In fact, for overall DPS, the majority of the models and sims I've done indicate that a slow offhand that isn't the same speed as your mainhand is the best average DPS. The difference isn't much, but it helps debunks the misconception that your offhand has to be fast for good execute DPS.
example:
Slow Vanir's
Cycle DPS - 1395.4
Execute DPS - 1406.0
Avg. DPS - 1397.5
Fast Vanir's (Kept weapon DPS the same, reduced speed to 1.5)
Cycle DPS - 1382.8
Execute DPS - 1428.4
Avg. DPS - 1391.9
The argument can be made that it is advantageous to have your DPS stacked into the execute phase, in order to provide a "strong finish" to the encounter, and that is probably valid. But, I don't think you should sacrifice too much to do it. If there were two Vanir's Left Fist versions and you wanted the fast one, fine. But there aren't. My advice is to simply take the best weapon available, so long as it's speed does not match your mainhand.
Also, I have corrected all issues that have been mentioned up to this point, other than modeling that faction trinket. What's that thing called again? However, I am not doing a new release until I finish testing on a new feature set that I have added. The main change for the next update will include detailed DPS breakdowns, to include DPS contribution for MH, OH, MS/BT/Dev, WW, Slam, HS, Total cycle, Total white, and overall total. All DPS will be expressed as a raw value as well as a % of overall DPS.
If anyone has any more bugs, missing items, or ideas/suggestions, please get them on here so I can get them into this release. I am trying to get to a "final" version so that I can put more time into other projects. (Web-based version of this sheet, sheets for more classes, etc...)
I piggyback a weapon swap onto the GCD of my first Execute. Wouldn't this get the best of both worlds? You'll have the rage for the first Execute regardless and piggybacking means you don't waste any time messing around with your weapons. The only downside is having to pick up a separate Execute weapon and use an extra weight/sharpening stone on the one in your bag.
Still collecting badges but I'm shooting for Slow/Slow Vanir's during regular cycle and moving the fast one in for Executes. It also has the advantage of matched weapon speeds during the cycle which people say gives an extra Flurry charge. I'm not entirely convinced that lag won't throw the swing timers off enough eventually although I have yet to test it out.
I piggyback a weapon swap onto the GCD of my first Execute. Wouldn't this get the best of both worlds? You'll have the rage for the first Execute regardless and piggybacking means you don't waste any time messing around with your weapons. The only downside is having to pick up a separate Execute weapon and use an extra weight/sharpening stone on the one in your bag.
Still collecting badges but I'm shooting for Slow/Slow Vanir's during regular cycle and moving the fast one in for Executes. It also has the advantage of matched weapon speeds during the cycle which people say gives an extra Flurry charge. I'm not entirely convinced that lag won't throw the swing timers off enough eventually although I have yet to test it out.
Yeah, a slow for cycle swapping to fast for execute is the ideal, assuming you have something to swap to. As to the 4th flurry charge, it is unproven, and the actual mechanics behind flurry are VERY fuzzy. All we can hope for is to have the model represent an approximation that is accurate enough to not introduce a notable amount of error, which is about where the current model puts us.
Hey guys i was wondering if you could help me out on this. I'm currently using the slow MH Hyjal trash drop fist, and am going to pick up the badge OH fist and was wondering whether i should go with the fast or slow one, the spreadsheets aren't giving me much help on this one.
05/15/08, 12:44 AM
Similar Threads
