have been using the spreadsheet for awhile and it has helped my dps greatly on chosing my next item to use or when switching with gear sitting in my bank once I get something new. Whenever I download the newest 2007 version I always get an error saying there was unreadable content but Excel seems to fix that.
What I was wondering was if getting your ArP SEP to be as close to 1 as possible is the best method? If I remove some of my ArP gear and the grim Toll, my ArP SEP goes to around 1.1, and when I replace it back my ArP sits around 1.05. It seems to increase the DPS pretty well but how are we supposed to reach for the SEP needed to use Executioner instead of beserking ( I know it's not possible atm, maybe in Icecrown or 3.2 if they will let us )
have been using the spreadsheet for awhile and it has helped my dps greatly on chosing my next item to use or when switching with gear sitting in my bank once I get something new. Whenever I download the newest 2007 version I always get an error saying there was unreadable content but Excel seems to fix that.
What I was wondering was if getting your ArP SEP to be as close to 1 as possible is the best method? If I remove some of my ArP gear and the grim Toll, my ArP SEP goes to around 1.1, and when I replace it back my ArP sits around 1.05. It seems to increase the DPS pretty well but how are we supposed to reach for the SEP needed to use Executioner instead of beserking ( I know it's not possible atm, maybe in Icecrown or 3.2 if they will let us )
That will only happen if there are ever better trinkets other than Mjolnir/Grim Toll and we can get enough ArP from gear... though I'm not sure if that's even possible because I haven't done any research...
You should just put any thoughts of enchanting Executioner out of your mind for a long time. It will probably never be viable, ever again.
You seem to be implying that you want to reach higher ArP just to be able to use Executioner. That will just never happen as long as we have better ways of capping ArP (trinkets).
I'd bet on Dark Matter being the superior trinket since crit is generally more useful than haste, for both arms and fury I think. Haste is generally a weak stat for warriors comparatively.
The proc is actually higher than what's shown and haste is better for fury than it is for arms and while the proc isn't really amazing it should be slightly better than DMC:G.
Napkin math confirms, assuming it's on a 45sec ICD.
I dislike the concept behind Dark Matter. Critical Strike, Hit chance or Expertise are not the stats I want to have on a proc. These are stats that show their benefits on the long run. When Dark Matter procs there are chances that it will increase your damage by 0 since it's far from certain that it will give you an extra critical attack. Actually if the proc was something like a guaranteed crit on next attack it would be more reliable.
The stats that work on a proc basis are increased attack power and armor penetration that increase the damage of all your hits during the uptime timeframe and haste that increases your number of hits. And during Execute phase the value of Haste is higher.
I have to say Im slightly dissapointed there is not a single trinket with passive ArP and AP or Haste proc. It would be really useful for builds aiming to cap ArP passively.
Might consider Dark Matter as fury, but as arms when you got the high crit chance on overpower and ms (setbonus) it doesnt look to delicious. Spreadsheet showing me a dps-loss in the 0,3ish between darkmatter and DMC:G. (as fury)
The proc is actually higher than what's shown and haste is better for fury than it is for arms and while the proc isn't really amazing it should be slightly better than DMC:G.
Napkin math confirms, assuming it's on a 45sec ICD.
They're close enough that it will entirely depend on the exact SEP value for haste you use. I currently use .616 as fury.
DMC:G runs 90 + 300*.32 = 186 SEP.
Comet's trail is then 240*.37878.. + .616*726*.2(will have ~20% uptime, same GT/MR/and other 10s/15% chance on hit trinkets) = 180.35.
The break even point is .655 SEP for haste to equal DMC:G. Any higher and it wins, any lower and DMC:G wins. For Arms, there is no chance Comet's Trail will ever be comparable to DMC:G since haste is so much worse for it.
They're close enough that it will entirely depend on the exact SEP value for haste you use. I currently use .616 as fury.
DMC:G runs 90 + 300*.32 = 186 SEP.
Comet's trail is then 240*.37878.. + .616*726*.2(will have ~20% uptime, same GT/MR/and other 10s/15% chance on hit trinkets) = 180.35.
The break even point is .655 SEP for haste to equal DMC:G. Any higher and it wins, any lower and DMC:G wins. For Arms, there is no chance Comet's Trail will ever be comparable to DMC:G since haste is so much worse for it.
I take it this is always assuming's Thorim's 10-man Runestone as the 2nd trinket? Or were you just comparing these 2.
Last edited by Emeraude : 06/13/09 at 9:02 AM.
http://www.megaupload.com/?d=CX81UJZ8
For the lurking Phoenix Wright faithful.
What is the most important thing to you? Won't you grant me the pleasure of taking it away.
I just picked up new bracers and dropped some expertise by doing so. I'm sitting at 21 expertise and adding one Precise Scarlet Ruby (16 exp) only puts me at 23 expertise, but the spreadsheet is showing Expertise as .4231 SEP. I'm pretty certain that the cap is 26 (technically slightly lower), but I'm wondering why the sheet isn't showing a higher SEP value for expertise since I'm not capped. Did I miss something?
I just picked up new bracers and dropped some expertise by doing so. I'm sitting at 21 expertise and adding one Precise Scarlet Ruby (16 exp) only puts me at 23 expertise, but the spreadsheet is showing Expertise as .4231 SEP. I'm pretty certain that the cap is 26 (technically slightly lower), but I'm wondering why the sheet isn't showing a higher SEP value for expertise since I'm not capped. Did I miss something?
Probably because you have a Mace/Sword in one MH/OH slot and expertise is only benefiting the non-Mace/Sword slot because the racial weapon specialization only affects the hand wielding that weapon type.
Well, I'm fury, wielding Ironsoul/Stormedge and character sheet in game is showing 23/20 expertise. So I'm definitely below the expertise cap. Spreadsheet is showing 23 expertise with 3 from racial (changing race from human to gnome reduces expertise on spreadsheet to 20). So I'm still not sure what's going on.
Well, I'm fury, wielding Ironsoul/Stormedge and character sheet in game is showing 23/20 expertise. So I'm definitely below the expertise cap. Spreadsheet is showing 23 expertise with 3 from racial (changing race from human to gnome reduces expertise on spreadsheet to 20). So I'm still not sure what's going on.
Just to make sure it's not a dumb mistake, are you forgetting to click the big green button next to the SEP values after modifying everything (with macros enabled)?
To Sentia: Obviously I know that 26 expertise is preferable... That's why I'm asking the question in the first place.
To Vashar: Yes I reclicked the green button for a re-evaluation of the SEP values. If I change the 16 Exp gem in my bracers to a 16 Str gem, Expertise is showing 1.3998 SEP value. When I change it back to the 16 Exp, it drops down to .4247 SEP.
I probably have something messed up something in the spreadsheet, but wanted to check if anyone else was showing some oddities regarding Exp. I'll regem to make sure I'm capped but still seems odd since I've gone over all of my enchants, gems, gear, etc at least 3 times now in the sheet. And since the unbuffed stats match my character sheet almost exactly (missing 27 AP in game compared to spreadsheet), this whole thing seems odd.
To Sentia: Obviously I know that 26 expertise is preferable... That's why I'm asking the question in the first place.
To Vashar: Yes I reclicked the green button for a re-evaluation of the SEP values. If I change the 16 Exp gem in my bracers to a 16 Str gem, Expertise is showing 1.3998 SEP value. When I change it back to the 16 Exp, it drops down to .4247 SEP.
I probably have something messed up something in the spreadsheet, but wanted to check if anyone else was showing some oddities regarding Exp. I'll regem to make sure I'm capped but still seems odd since I've gone over all of my enchants, gems, gear, etc at least 3 times now in the sheet. And since the unbuffed stats match my character sheet almost exactly (missing 27 AP in game compared to spreadsheet), this whole thing seems odd.
I had the same thing happen when my expertise was sitting at 22/27, the spreadsheet told me expertise was around 0.4 or so compared to str, but I ended up getting it sitting at 26 after I got an upgrade
I have been playing around with modelling different rotations and am now less convinced on the accuracy of the new rotation the sheet uses.
1. Every distribution of the combos has at least 1 slam. The case of no slams is missing.
2. HS usage is static in relation to the GCD. I think the HS portion of determining the chance of a slam could be replaced with (1-Bloodsurge%*HS frequency)^((current time/time of last slam)/MH Speed) This would also save you a lot of space since you wouldn't have to assign cells for HS.
3. As I mentioned before there is the problem with cooldowns being pushed back and not being up for the next cycle. Since this hinges on if the 2nd GCD is a slam or WW, it seems this would create almost double the permutations needed.
4. This is only one of many variations of a dynamic rotation. To calculate others like this would be a lot of time and space. But there is no way for normal users to use other rotations without editing the sheet.
Landsoul,
Found another purely cosmetic issue to correct. The Stamina formula in cell J3 on both Fury and Arms is calculating total stamina incorrectly when either SoA or Vitality is taken. The formula is increasing stamina by 20% instead of 2% per talent point.
Thanks again for all the hard work you put into this spreadsheet.
This may or may not have been found already but setting the Windfury Totem to 0 Causes a Div/0 Error in the Office '07 version.
Scenario: I would update my gear on the Fury sheet remove most of the raid buffs and then run Sep and I would get the Div/0 error.
The Test: I redownloaded and started fresh. Using Landsouls gear I marked each buff to 0 one at a time would run Sep and if no error showed I'd click save. I did this until I got to windfury and got a Div/0 error so I reloaded skipped windfury and kept going. Then I saved and downloaded my gear. No Errors. Ran Sep. No Errors. Saved. Set Windfury to 0 and Div/0... so there's at least 1 cause of Div/0.
I still cant autoload my gear into the Arms Sheet... I get an Div/0 whenever I try I plan to manually enter my gear later and see how that goes. Also 'Enchanted Tear' +6 to all stats gem isn't found, not a big deal but I figured I'd mention it.
PS - I love the spreadsheet... and it's a wrong sort of love too almost like cheating
The Div/0 with the windfury totem seems to be fixed. I figured I'd mention it since it's not in the notes I'm guessing since its a minor detail.
I still cant download in the Arms sheet I'm wondering if this is related to my Armory being saved to my Fury build once the servers come back up I'll flip over to my Arms setup exit and see if it makes a difference. If thats the case I'm wondering how hard it would be to only download gear & skip talents and if needed skip that offhand weapon as well?
Probably dumb question, but I cant figure out how to import my toon into the sheet from armory. The modules are active, but i dont know how to input my name instead of landsoul to run a search. Any suggestions?