Couple things I noticed while using the spreadsheet.
1) When I put in Bladed Chaos Tunic it broke the DPS calculator, as in the number from their on out displayed as N/A. When I undid the change or anything short of exiting the spreadsheet and opening up a backup sheet the N/A would continue to display. This was for the 97' -03' spreadsheet.
2) I have a very hard time believing that ArP should be anywhere nearly as valuable as it is. Just from my own calculations I found going from the old Arp system to the new system its about 46% as effective on low armor bosses and 75% as effective on high armor bosses. Meaning that if the SEP value for the old Arp was around 1.25(which was a common number for the gear I ran) then the SEP value for the new Arp should be .58/.94. This dosen't seem to jive with the dps increases I'm seeing on the spreadsheet and with rejdakon numbers. I'll post the math below for people wanting to fact check, but I'd really like to hear the counter arguement to this not being a terrible stat at L70.
Taking Leggings of Divine retribution as a base for comparison (350 armor pen [old] vs 50 arp rating [new]) and this formula...[debuffed boss armor value] * .06767 = new static armor reduction.
low
202.03(w/o) 145.27(w/)
high
303.378(w/o) 246.62(w/)
now to calculate the effective% I divided the new static armor pen by the old static armor pen... i.e. X/350
low
57.7%(w/o) 41.5%(w/)
high
86.7%(w/o) 70.5%(w/)
Taking a weighted average using the assumed executioner uptime I arrived at the percentages I used earlier...
low = 46%
high = 75%
You need to be more specific so I can reproduce this. Sounds like you have Weapon mastery 2/2 and something else activated. What is the mob level and recheck your talents and expertise levels?
Could it be that you check for Precision instead of Wp. Mastery in DodgeM/DodgeO (->V14)?
Great work, landsoul. One question: what happened to the SEP values? I was looking to figure out which gems I should be upgrading to (10crit vs 5str/5crit for yellow, 10str vs 5str/5crit for red), and used to look at the SEP calcs.
Okay, I found an interesting bug, and am having a difficult time rectifying it. I was trying to play with the differences between using TG and not, and somewhere along the line I removed TG with a pair of 2-handers equipped, and excel filled everything out with #DIV/0 errors.
Tracing the error wasn't helpful because of how many circular references are being used, and I can't find the offending area easily.
Do you know of any way in Excel to force the calculations again?
After playing around with it a bit, I think I found where the problem lies: Haste Averages.
I don't know if you can refactor this in such a way as to remove the circular references in the haste averages, but something to look into. I'm running out of time here at work so I can't continue right now
Would it be possible to add dragonstrike to the spread sheet? I know they are better weapon out there i think there are still lots of people using it. It would be good to use it has a baseline so we know what to upgrade to.
It's the beta. It's not complete yet. Working SEP requires hours of brute force linking and verifying, and I haven't been able to figure out how to set it up in a macro yet. It's been very complicated. Again its the beta and I am keeping choices limited as this will be the flagship going into Wrath, which is what the sheet was intended for. I'm just getting its feet wet making sure it can work at 70.
I can't reproduce your error ebs2002. I need more information. when I remove TG with 2handers equipped nothing happens to the calculations because TG only adds 5% to miss yellow attacks. The way to protect against that kind of thing tho is to definately backup a master copy and save frequently in the book you are working in so that if there is error, you can close the program and re-enter where you last saved without error.
Again if you have error, please describe what version of excel you are using and make sure you are using the right version with the right excel program, and that you have the latest version.
I found the expertise error. Apparently on accident I linked the weapon mastery with precision. You can clearly see the incorrect link in the DodgeM/DodgeO boxes.
1) Before the yellow cap, + hit increases hits and crits for yellows due to the 2-roll system on yellow.
At 50% crit chance and 1% miss, 1% more hit adds 0.5% crit and 0.5% hit to yellows.
Thanks, hadn't considered that.
Originally Posted by Roywyn
2) ArPen doesn't affect Deep Wounds, which are a significant amount of Damage that a TG spec doesn't have.
Hence ArP being worse for Deep Wounds specs.
Yes, but the sheet calculates Deep Wounds post-nerf, showing it to be 15% of my total damage. This makes a 30%-difference seem a bit high, but I could be wrong and still fail to take into acount something important.
Originally Posted by landsoul
That's cosmetic only. What are you trying to add? I put all the popular epic trinkets that you ever could use.
My bad. Thought that SoC-proc was not implemented yet due to it yielding a much smaller dps-increase than expected but that was due to the expertise-bug.
Originally Posted by landsoul
Oh and what is 5/56 TG? You should go 2/51/8 with incite that's the best.
I actually meant 8/53, having simply shaved off 10 points from the lvl 80 spec I used before in the sheet. Doesn't make it less of a mistake on my side, though.
One more thing: The sheet allows taking up to five points in Weapon Mastery in the drop-down box.
Armors for chest are still broken past the 1st marker for "leather"
You can probably remove scrolls or at least make them not stack. Scrolls dont stack with each other now, and they dont stack with Strength of Earth totem (which also removes them , pretty annoying if you ask me that once you get in range of shaman totems scrolls get "purged").
I added my equipment, but I have some trouble getting the spreadsheet (Excel 2007) to accept Trollbane as offhand. I use the 2/51/8 Titan Grip levelling spec. I got all the other changes to come through to the lists on that tab, so am I doing something wrong or is there something wrong there?
By the way Landsoul - great job, much appreciated!
Add it yourself, he posted instructions on the intro page of the spreadsheet. I added Furious Gizmatic just fine.
I searched both the latest version and the previous one I downloaded for these instructions and found nothing. Further, I tried fiddling with the "Gear Lookup" tab and modifying one of the items already entered but it didn't seem to do the trick.
My apologies if I'm not as versed in spreadsheet mechanics as some, to modify it as easily as you seem able to do.
Edit to add: I've been using the OpenOffice version. Perhaps the Excel version has the instructions you're aluding to?
If you have excel 2007 I highly recommend switching to that version. Sorry, the version i was using was 2007 and its very easy to use and much cleaner/less dopic then open office version
Wow I have no idea what is wrong with chest pieces other than plate. This is really weird. I have traced so many different paths and I think it has something to do with a VLOOKUP error. Not sure what it is yet.
Dont you think 2/51/8 spec is wrong i mean like you can take a point out of imp heroic strike and put it in intensify rage or even try Heroic Fury get a Mod Like Quartz and put Intercept in your rotation i mean it dose 12% of your AP jump out after white swing then Intercept? Might be a good rotation any1 test this out yet? If so 53/8 Might be better then 2/51/8.
Dont you think 2/51/8 spec is wrong i mean like you can take a point out of imp heroic strike and put it in intensify rage or even try Heroic Fury get a Mod Like Quartz and put Intercept in your rotation i mean it dose 12% of your AP jump out after white swing then Intercept? Might be a good rotation any1 test this out yet? If so 53/8 Might be better then 2/51/8.
2/51/8 Requires 3/3 Intesify rage or 2/3 Intesify rage and 1/1 heroic fury in your scenarios.
Are you suggesting that we stop attacking the mob and run away in order to intercept back in? With a 5 second cooldown on bloodthirst and our attack speed I don't see how running away and intercepting would be beneficial. Even if it were beneficial it would be very situational as many boss fights require us not to stand close to other persons. The extra point in heroic strike is a non-situational talent usable in all fights :-/
2/51/8 Requires 3/3 Intesify rage or 2/3 Intesify rage and 1/1 heroic fury in your scenarios.
Are you suggesting that we stop attacking the mob and run away in order to intercept back in? With a 5 second cooldown on bloodthirst and our attack speed I don't see how running away and intercepting would be beneficial. Even if it were beneficial it would be very situational as many boss fights require us not to stand close to other persons. The extra point in heroic strike is a non-situational talent usable in all fights :-/
2 Less rage for Heroic Strike kinda blows especially With glyph of Heroic strike and raid buff sunwell warriors have 50% plus crit And when u jump out u jump out when BT,WW Are on CD And if u watch your Swing timer just standing there kind pointsless jump with E or Q and in range of intercept especially when bosses like brut have large hit boxes i think your just underestimating this 12% of AP is 1/4 BT but still better then standing there waiting for CD's or Swing timer ima try this out any other options?
I cant imagine where you would have time to move away and intercept where no swing would land. Its not that the damage is bad its just you will probably lose something moving.
That said Im not sure why 2 points in Imp HS is best, wouldnt using one to max out Intensify rage or precision be better?
I cant imagine where you would have time to move away and intercept where no swing would land. Its not that the damage is bad its just you will probably lose something moving.
That said Im not sure why 2 points in Imp HS is best, wouldnt using one to max out Intensify rage or precision be better?
Yea even if im wrong about the Intercept Put one into Intensify rage or precision would be better.
I found the error regarding Armor and Leather. The armor lookup for chest stopped at 25 instead of 225. Has nothing to do with leather, but is really a serious typo.
There's that fix plus lowered the max selection of weapon mastery down to up to 2.
When playing around a bit with imp heroic, intensify rage and precision, order went by: intensify rage, imp heroic, precision. So best you would go with 3 intensify rage, 2 precision (by need to advance), and 1 imp heroic. This is true for both raiding and not raiding stats.
Yea even if im wrong about the Intercept Put one into Intensify rage or precision would be better.
The spreadsheet works well for this. I already do 3/3 intensify rage and I do 2/3 precision since i'm yellow hit capped without wasting that point. If you do 3/3 intensify rage and have an on use trinket like berserkers call, the death wish/trinket cool downs even out. Deathwish = 2.01 minutes and trinket is 2minutes.
/cast Deathwish
/use Berserker's call
But again the spreadsheet is good to see which talents will gain more dps and I believe this conversation would be better had in the future of a dps warrior thread
I found the error regarding Armor and Leather. The armor lookup for chest stopped at 25 instead of 225. Has nothing to do with leather, but is really a serious typo.
There's that fix plus lowered the max selection of weapon mastery down to up to 2.
When playing around a bit with imp heroic, intensify rage and precision, order went by: intensify rage, imp heroic, precision. So best you would go with 3 intensify rage, 2 precision (by need to advance), and 1 imp heroic. This is true for both raiding and not raiding stats.
Wouldn't this be 3 IR, 2 precision, and 2 imp heroic? Not sure if I'm missing something but i'm pretty sure w/ 2/3 precision, 3/3 IR, and 2/3 Heroic strike you still get all the talents needed and it works for level 70.
11/03/08, 4:06 PM
Similar Threads
