Thanks a TON! It was worth the wait. Everything works perfectly and the calculations are faster than EVER! Good job! I just have a small question, apparently we are getting more DPS from ArP gems than STR gems, which as a fury warrior is kind off weird due to the fact that we are getting that extra 10% from Imp. Zerk Stance. Not to mention raid buff's that increase the attribute of STR even more. By the time you get Mjolnir Runestone, you should really only need about 30% Arp Pen to hit a possible 100% armor reduction. I guess the buffer doesn't hurt, but, seems like a waste. Can you explain? Thanks!
Yeah, I thought the SEP points we're calculated wrong. Can you explain please. I had to edit this message, but I noticed you are fully loaded with ArpPen so im thinking there is a reason for it.
Last edited by Whitelion : 09/02/09 at 1:27 AM.
Reason: Wrong
It's easy. Get rid of your ArP trinket and grab some great gear. Gem ArP in every socket. This includes yellow sockets. Ignore socket bonuses. Granted you may not be able to do this right away. But as an example i loaded up some gear and came out with a quick BIS list that was 9,865 dps. All plate i might add. Using 250ms reaction time and 200ms latency. ArP was 1096 (96 short of the cap) and the SEP for arp was 1.5030 That's fairly insane for fury. Swapping from zerker to executioner on mainhand and swapping 1 20 arp gem to 1 20 str gem increased dps to 9,887 as well.
Last edited by catch22atplay : 09/02/09 at 1:48 AM.
I'm intrigued by the strong value of the clicky on [Incisor Fragment]. The rankings sheet lists it over both my current trinkets (Greatness and Banner), but equipping it over either is a DPS loss. I do see, though, that the value of the clicky is being averaged in rather than used all at once. I was wondering if the self-scaling of ArP, plus the fact that I'd always use it with Death Wish, could push its value higher than the sheet would suggest. To test, I took my point out of Death Wish in the sheet and modeled it manually. My Warrior is pretty typical: 374 ArP from cap, hit capped, almost Expertise capped. With one trinket slot empty and no Death Wish, the sheet says he does 5275 DPS, so I'll use that as the baseline.
* The additions in the last calculations for the Banner account for DPS from procs outside of Death Wish (117 AP 75% of the time and 201 AP 75% of the time, respectively).
I filled all my gear by hand. Because im at work and getting stuff from the armory isn't working because the firewall etc.
But I filled all by hand. Pressed the button for SEP calculation and got no error. But my DPS is gone.
See screenshot: http://img259.imageshack.us/img259/4151/landsoul.jpg (Office 2007 Dutch version)
Also on the screenshot you see the words "Fetch Armory" in the 3th socket of my belt. Kinda strange place I think.
I'm confused by the spreadsheet and I'm wondering if I've encountered a bug.
Currently I am not quite hit capped and the SEP on Hit Rating is higher than ArP. When I switch between ArP food and Hit Rating food, it correctly shows my DPS is higher using Hit Rating food. If I switch the gem in my T8.5 gloves from ArP to Hit Rating, my DPS goes down.
I especially don't get it because the socket bonus on the gloves is +4 Hit Rating.
So if 40 Hit Rating > 40 ArP Rating (according to the spreadsheet), why is 20 ArP Rating > 24 Hit Rating (also according to the spreadsheet).
The other bugs I found were that I can't manually change my talents, the macro to fetch talents from the armory does not work, and my Nitro Boosts (+24 Crit Rating) enchant is not recognized.
EDIT: I think I figured out why. Even though switching the gem gives me 24 Hit Rating, I am less than that from the cap. So when it says the SEP is higher, it means for how ever many points until I reach the cap.
I have some problems with new sheet.
If I change race from night elf (Landsoul) to orc many things gets red ("doll" column-J22; "DPS breakdown"; & all tables below "Orientation & buffs")
Dps calculation says "change lookup"
Also on lookup tab the "DPSdiff" coulmn says "#DIV/0!
Do we need to import charr from armory to make it work?
It wasn't the case with previous sheets...
I'm kinda lost here
Ok..but calculations doesn't work...macros are turned on btw.
And what is "change lookup"?? I also tried switching fury to arms & back on lookup tab but with no results
Nevermind, reinstalling office differently fixed the issue. Everything seems to work fine so far except the "DPS difference" for off hand weapons, the column is filled with NA after an armory import. The trace reports a circular reference error.
I get #WERT! (german office 2007, this should be #vlaue in english) in most of the calculated cells. Sheet loads just fine, armory import is working. Errors occur only after using the SEP macro. I tried following the error-paths but with hundreds of cells showing this error and references (including circle references) across the sheet I finally quit trying.
If there is any way I can find out specifics without following every single reference, please let me know.
I have a problem getting the sheet to work and I am not sure if it just a problem on my end. When I open the sheet, it tells me it found unreadable content in the sheet and if I would like to restore it, to which I press Yes. I realize I my network card is somewhat wonky so I sometimes get corrupted files when downloading (large) files so just making sure it's not that. Am I the only one who gets that? (I downloaded the sheet 5 times now and it always give me the same message)
If not:
The sheet breaks down after I let it run SEP calculations without changing anything in the sheet at all. It gives the error message you'd get when you would not have iterative calculations set as instructed in the first page of the sheet (which I have done).
You're not alone. Same problem here. Rest of the sheet really looks great, thanks for your hard work Landsoul!
And to all people having problems with setting talent points: Click in the cell of the talent and write the number of rank in there. It's faster then moving all the picture away
Seems as common problem people have:
I open the the file, enable macros, I set options->formulas->Maximum iterations:100, Maximum Change:0.000001
I do not change anything, i keep the Landsoul char data, i click "Click to" for SEP calculations => some values, as trinkets, wep enchants and so on get errors (#VALUE!). If i click ti again, all values get errors.
Seems as common problem people have:
I open the the file, enable macros, I set options->formulas->Maximum iterations:100, Maximum Change:0.000001
I do not change anything, i keep the Landsoul char data, i click "Click to" for SEP calculations => some values, as trinkets, wep enchants and so on get errors (#VALUE!). If i click ti again, all values get errors.
Exactly this is what I am experiencing as well. Hope it will help Landsoul to find and kill bug.
Under professions I noticed that you did not have engineering listed at all. Not a big worry since you have most of the engineering items in there. One thing you do not have however is the Nitro Boosts enchant which provide 24 Crit rating.
Also like a previous poster mentioned, it won't load my Off-hand Aesir's Edge.
Problems I've noticed... the gloves bonus isnt showing up on the Fury page. The comparisons for many items seem to be off a tad, some more than others. Trinkets... yah no ideas there... however slot changes that would break tier bonuses seem to be including the previous tier bonus that they would actually break(I could be wrong but that's what it looks like to me). The new etched kirin torn rings are missing.
As always I love the sheet it's still the best and it just keeps getting better.
To: Jarheaded
ArP has been discussed at length around here. Arp has a sort of soft bottom and then is greater than Str until it hits 100%. Using the sheet I swapped out all your +20 str gems and couldnt get even close to 100% so your best option to hit 100% would be to use one of the ArP trinkets Mjolnir Runestone or Grim Toll and then swap out a couple gems. Looking at your gear I'm guessing you could farm up these items in a short period of time or with any luck you have one of them sitting in your bank itching to be used. Replacing Banner of Victory will give the greatest gains.
I was Fury Before the Lich King Came... I was Fury before Titan's Grip... I was Fury Before it was cool...
ArP has been discussed at length around here. Arp has a sort of soft bottom and then is greater than Str until it hits 100%. Using the sheet I swapped out all your +20 str gems and couldnt get even close to 100% so your best option to hit 100% would be to use one of the ArP trinkets Mjolnir Runestone or Grim Toll and then swap out a couple gems. Looking at your gear I'm guessing you could farm up these items in a short period of time or with any luck you have one of them sitting in your bank itching to be used. Replacing Banner of Victory will give the greatest gains.
Appreciate the help Rexx, unfortunately the Loot Gods of Ulduar 10 and Naxx 25 do not want me to get a ArP trinket so I QQ everyday.
So ideally, I get a Mjolnir, sub out BoV and gem 4 +20 ArP gems?
-edit- I was mistaken; I had a few wrong gems making the Planestalker ArP not as effective. Leaving the previous post behind.
---- BAD INFO ----
For Fury BiS: Should see a small upgrade by going with [Band of Callous Aggression] over Planestalker, then putting 20 hit on gloves instead of 44 AP.
Last edited by Grayson Carlyle : 09/02/09 at 10:41 AM.
Reason: Messed up
Like some of the others I get #VALUE when trying to update SEP values or compare gear. One very strange thing I noticed while trying to figure out what Tier9 piece to get first was that if I switch to Tier9 gloves (and thereby loosing 4pT8 bonus, without getting 2pT9) I gained over 500 DPS. I couldn't understand this so I tried manually disabling 4pT8 without changing gear and I gained 450 DPS by doing this.
So there's definatly something wrong with 4pT8 bonus, you shouldn't gain 450 DPS by dropping 10% crit on Mortal Strike. All of this is in the arms section.
The new sheet looks really great though, and I'm looking forward to seeing it work. Thank you for you dedication Landsoul.
i didn't get european armory working and also when trying to calculata new sep values spreadsheet is bugging Berserking enchant on weapons and greatness trinket
Bug when pulling up the armory. Last night i got the heroic belt of the impaler. When i do a lookup on my guy it comes up as normal belt and i have to change it to heroic version.
Great work though. this is by far the best spreadsheet out there for any class. Thanks
i didn't get european armory working and also when trying to calculata new sep values spreadsheet is bugging Berserking enchant on weapons and greatness trinket
I get EU armory just fine, check later (as it gets down occasionaly) or you are behind firewall/proxy.
As for the second, most of the people get errors there (anyone manage to get them work?)
09/02/09, 1:09 AM
Similar Threads
