 |
| 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.
|
07/16/09, 9:42 PM
|
#1276
|
|
Banned
|
Odd behavior using the spreadsheet
I've been playing with the spreadsheet and have notice some odd things. My character's name is Drakthuel on the server Vashj, and am Poleaxe spec Arms so you guys can see what I mean.
I run with Betrayer and was curious what other weapons would do. So I loaded my toon, recaculated SEP and then jumped over to the gear and sorted by DPS. It put Ironsoul 5 or 6 slots above my BoH, so I went back to the character page and changed my weapon to Ironsoul, set my spec to Mace and my dps went down by about 500.
Now, I thought that with the gear sorted by DPS higher items would increase my total DPS. Instead it decreased it. Is the sheet working like it is supposed to and I'm misunderstanding or misusing it?
|
|
|
|
|
|
07/17/09, 2:50 AM
|
#1277
|
|
Glass Joe
Tauren Warrior
Lightbringer
|
Originally Posted by Troutinator
I've been playing with the spreadsheet and have notice some odd things. My character's name is Drakthuel on the server Vashj, and am Poleaxe spec Arms so you guys can see what I mean.
I run with Betrayer and was curious what other weapons would do. So I loaded my toon, recaculated SEP and then jumped over to the gear and sorted by DPS. It put Ironsoul 5 or 6 slots above my BoH, so I went back to the character page and changed my weapon to Ironsoul, set my spec to Mace and my dps went down by about 500.
Now, I thought that with the gear sorted by DPS higher items would increase my total DPS. Instead it decreased it. Is the sheet working like it is supposed to and I'm misunderstanding or misusing it?
|
The sorting sheet is either not considering weapon spec or you did not choose arms as the check sheet.
|
|
|
|
|
|
07/17/09, 12:33 PM
|
#1278
|
|
Von Kaiser
|
How do I make the spread sheet not value hit as worthless when capped? All items with hit show way down the list. For example, I had Wraith Spear, but recently got Black Ice. I was able to shift gear to drop the hit so that i'm at 263 with Black Ice. Still the planner shows Black Ice as one of the absolute worst options, even below many blue weapons. This happens using both the SEP and DPS settings. When equiped, this new setup with BI is quite a bit higher than the one with Wraith Spear.
Also happens with items like my T7.5 chest. It's rated very poorly, mainly due to having so much hit.
|
|
|
|
|
|
07/17/09, 12:59 PM
|
#1279
|
|
Glass Joe
|
Landsoul,
Thanks for putting the time and effort in to making this spreadsheet.
Everyone,
Call me old-fashioned but I have never been one to just plug my gear/talents into a spreadsheet and blindly follow its advice. I usually use them as more of a guide than a mandate. With that said, I have just begun raiding as an Arms warrior in Ulduar (formerly prot for Naxx and Ulduar). I have some experience using DPS sims and spreadsheets from my BC rogue-raiding days so I am not completely new. However, something odd I have found with this spreadsheet is that when/if I gear and gem to be way below hit cap (fully raid buffed gets me to 2% MISS chance), it still doesn't assign a very high SEP value to HR (only around 0.600). If I ran this with really low hit, shouldn't it give hit a really high rating? I have played with the 'Use Hit Adjustment' on the Lookup tab and I guess this is supposed to help me offset the value of hit.
Ultimately, I'm just confused as to whether I should just suck it up for now... do everything I can to get hit-capped, and then use a spreadsheet to work on upgrades. For now, kind of disregard it and just tunnel vision in on capping hit. Back in my rogue days I wouldn't even consider asking this question because advice flew all over the place and it all said CAP HIT. However, I have had a tougher time finding definitive answers to these questions concerning Arms warriors even after searching all these threads.
|
|
|
|
|
|
07/17/09, 1:36 PM
|
#1280
|
|
Piston Honda
Orc Warrior
Burning Legion (EU)
|
Originally Posted by Faithireon
Landsoul,
However, something odd I have found with this spreadsheet is that when/if I gear and gem to be way below hit cap (fully raid buffed gets me to 2% MISS chance), it still doesn't assign a very high SEP value to HR (only around 0.600). If I ran this with really low hit, shouldn't it give hit a really high rating? I have played with the 'Use Hit Adjustment' on the Lookup tab and I guess this is supposed to help me offset the value of hit.
|
Draenei hit buff. Btw its rather strange since in my gear I have 250 hit rating and Hit SEP is over 1 (so thats OK).
|
peace MK
|
|
|
|
07/17/09, 1:52 PM
|
#1281
|
|
Von Kaiser
Night Elf Warrior
Icecrown
|

Originally Posted by Faithireon
Landsoul,
Thanks for putting the time and effort in to making this spreadsheet.
Everyone,
Call me old-fashioned but I have never been one to just plug my gear/talents into a spreadsheet and blindly follow its advice. I usually use them as more of a guide than a mandate. With that said, I have just begun raiding as an Arms warrior in Ulduar (formerly prot for Naxx and Ulduar). I have some experience using DPS sims and spreadsheets from my BC rogue-raiding days so I am not completely new. However, something odd I have found with this spreadsheet is that when/if I gear and gem to be way below hit cap (fully raid buffed gets me to 2% MISS chance), it still doesn't assign a very high SEP value to HR (only around 0.600). If I ran this with really low hit, shouldn't it give hit a really high rating? I have played with the 'Use Hit Adjustment' on the Lookup tab and I guess this is supposed to help me offset the value of hit.
Ultimately, I'm just confused as to whether I should just suck it up for now... do everything I can to get hit-capped, and then use a spreadsheet to work on upgrades. For now, kind of disregard it and just tunnel vision in on capping hit. Back in my rogue days I wouldn't even consider asking this question because advice flew all over the place and it all said CAP HIT. However, I have had a tougher time finding definitive answers to these questions concerning Arms warriors even after searching all these threads.
|
Make sure you have pressed the "Calc For SEP values" button on the Arms tab. Doing so will calculate the SEP values for all your stats. If you are under the hit cap, then Hit will have a SEP value greater than 1. After you have done this, then sort the Lookup tab (with Arms selected) and you will see Hit gear valued much higher than gear lacking hit.
You will need to do this everytime you make a gear change.
|
|
|
|
|
|
07/17/09, 3:15 PM
|
#1282
|
|
Glass Joe
|
I think I may just download a fresh copy of the spreadsheet then. I know to hit the 'Click for SEP Calc' button when I change my gear and gemming but the effect this has on SEP value of Hit Rating is still absurdly miniscule. I just put in bunk gear selections that place my MISS chance at 5.41% and clicked the recalc SEP values button. The new SEP value for hit rating is 0.6453. Like I said, I am just going to try redownloading and starting from scratch. Unless somebody else has encountered this issue.
Last edited by Faithireon : 07/17/09 at 4:13 PM.
|
|
|
|
|
|
07/17/09, 6:25 PM
|
#1283
|
|
Glass Joe
Night Elf Warrior
Windrunner
|
Well, I just quickly tested Faithireon's claim and something does look odd.
If you grab a fresh template and go to the Arms tab, just switch Conq Gloves to Bladebreaker's. This drops Hit down to 224 from 266 (NOTE: Heroic Presence default is set to OFF; I left this alone). Press the SEP recalc and you'll notice that the value for Hit lands at 0.77. Of course, there's a large DPS drop-off due to breaking 4-pc bonus and Expertise climbing through the roof (1.0457), but conceptually it does seem strange that white hits are valued less than dodges when you consider the rage implications of foregoing that hit and the ability to recover some of the Expertise gap via Overpowers.
Just playing with it a bit more, I seem to be able to push Hit SEP value down even lower (eg. 0.55 range) despite not being anywhere close to Hit cap with some of these setups.
|
|
|
|
|
|
07/17/09, 11:28 PM
|
#1284
|
|
Glass Joe
|
2 x aesir Edge
Is there any reason not to duel wield 2 weapons of the same speed?
Why then does the sheet suggest that duel wielding [Aesir's Edge] is inferior to 1 x Aesir's and 1 x [Stormrune Edge] when the Aesir's has near 40 more SEP? Is this due to decreased rage generation using same speed weopons?
|
|
|
|
|
|
07/18/09, 1:09 AM
|
#1285
|
|
Didn't reroll DK
Night Elf Warrior
Alterac Mountains
|
Hit rating problem:
That's odd, I'll take a look at it. It should not be doing this..
Edit: Found the problem, for yellow crit reduction through miss rate, it was referring to the wrong cell. Fixing it properly puts hit rating above 1.000 SEP.
To fix, make sure cell AH36 reads the following.
=X111*((1-AH39-AH31)*(IF(AL23=80,3.192,0)+(3)*C35+IF(C23="Player",0,IF(C23="Boss",-4.8,0.2*(AL23-C23)))+AL6+MAX(5*P27,5*P25)+MAX(U37*V37/100,U39*V39/100,3*V41)+AG24*AO15+D139/AL57+(N136+C48+Z111+IF(A30="Food: Crit",C30,0)+C36*32)/AL58)/100-A41)+(1-X111)*((1-AH39-AH31)*(IF(AL23=80,3.192,0)+3*C35+IF(C23="Player",0,IF(C23="Boss",-4.8,0.2*(AL23-C23)))+AL6+MAX(5*P27,5*P25)+MAX(U37*V37/100,U39*V39/100,3*V41)+AG24*AO15+D139/AL57+(N136+C48+IF(A30="Food: Crit",C30,0)+C36*32)/AL58)/100-A41)
I bolded the correction. Should say AH31, not AH32. Please not this is only in the arms sheet. Do not touch the fury sheet.
Last edited by landsoul : 07/18/09 at 1:41 AM.
|
|
|
|
|
07/18/09, 8:50 AM
|
#1286
|
|
King Hippo
|
Originally Posted by Jevade
Is there any reason not to duel wield 2 weapons of the same speed?
Why then does the sheet suggest that duel wielding [Aesir's Edge] is inferior to 1 x Aesir's and 1 x [Stormrune Edge] when the Aesir's has near 40 more SEP? Is this due to decreased rage generation using same speed weopons?
|
Weapon SEP arent really very well calculated - look at it as pointers (as the whole sheet). Aesir's edge is superior in MH (again- ACCORDING to spreadsheet), but its inferior in OH - it has worse stats then rune edge (cough, agility weapons were always better despite blizzard efforts), but slower speed pushes it ahead on MH. On OH speed matters a lot less, so rune edge is better. It has nothing to do with synced weapon speed (whcih afaik is totally ignored by spreadsheet)
|
|
|
|
|
|
07/18/09, 9:40 AM
|
#1287
|
|
Von Kaiser
Orc Rogue
Magtheridon (EU)
|
Hello, is there any way to fix the Armory Import feature before a new version is made?
|
|
|
|
|
|
07/18/09, 3:32 PM
|
#1288
|
|
Glass Joe
|
Shaa,
Thanks for the reply. Yes having 4 stats instead of 3 makes a significant difference even if one is agility. So are you hinting at the idea that alike weopon speeds would be worthy of more or less DPS that the sheet does not suggest? Would you duel wield 2 X aesir's instead of 1 x Rune Edge?
|
|
|
|
|
|
07/18/09, 3:57 PM
|
#1289
|
|
Didn't reroll DK
Night Elf Warrior
Alterac Mountains
|
The thing about all this aesir's vs rune edge stuff, is the lookup page 'best guesses' each item based on the stats of a full set of gear. Meaning, Wielding 3 weapons' stats. This is clearly farse. They are similar enough to where once might overshoot another on the lookup page just based on the stat difference. For example, when wielding agility type gear, strength type gear increases slightly, and vise versa due to SEP interdependancy.
|
|
|
|
|
07/20/09, 12:47 AM
|
#1290
|
|
Glass Joe
|
Does the Arms sheet operate under the assumption that the metagem is always active?
When I put in enough blue gems to activate my metagem, the DPS doesn't go up compared to when the metagem is not activated. That is, when I go from no gem to a purple gem, the dps only increases by the amount it would increase from the purple gem.
Also, what is the general breakpoint where 1 ArP > 1 Str for Arms spec? Does it involve getting static ArP on gear above a certain level, or is it a certain level of AP? Or something unrelated? (Assuming hit is capped and expertise is capped for dodges of course)
|
|
|
|
|
|
07/20/09, 1:15 PM
|
#1291
|
|
Piston Honda
|
Small bug: Brann rings are shown to have an 8AP socket bonus - it should be 4AGI
Keep up the fantastic work
|
|
|
|
|
|
07/20/09, 6:29 PM
|
#1292
|
|
Glass Joe
Gnome Warrior
Terrordar (EU)
|
another small bug: fluxing energy coils is shown as having 8 agility socket bonus, insted of 4.
|
|
|
|
|
|
07/20/09, 9:17 PM
|
#1293
|
|
Glass Joe
|
Is it possible to include executioner as a weapon enchant next build? I know it's probably inferior but I'm curious to see how it stacks up.
|
|
|
|
|
|
07/20/09, 11:18 PM
|
#1294
|
|
Glass Joe
Orc Warrior
Agamaggan (EU)
|
Originally Posted by Hemotolic
Also, what is the general breakpoint where 1 ArP > 1 Str for Arms spec? Does it involve getting static ArP on gear above a certain level, or is it a certain level of AP? Or something unrelated? (Assuming hit is capped and expertise is capped for dodges of course)
|
I'm very interested in knowing this aswell.
|
|
|
|
|
|
07/21/09, 1:04 AM
|
#1295
|
|
Glass Joe
|
Originally Posted by turbare
Hello, is there any way to fix the Armory Import feature before a new version is made?
|
Yes, when i enter my warrior's name and server. It comes up with an error that my toon does not exist. Is there a way around this? Also it does not recoginze the rigid stormjewel, can this be fixed.
|
|
|
|
|
|
07/21/09, 2:00 AM
|
#1296
|
|
Glass Joe
|
The latest revision seems to have fixed my old DIV/0! problem with Windfury in my current gear, but tonight I got my t8.5 gloves, ran the SEP calculation and encountered the same WF problem again.
|
|
|
|
|
|
07/21/09, 2:36 AM
|
#1297
|
|
Glass Joe
|
I have downloaded the spreadsheet and it states that my theoretical dps is supposed to be arnd 4156. But I struggle to maintain 2300. Could I get some pointers on rotations. From what I gathered from the spreadsheet, it suggests waiting slightly and not nailing BT and WW on the cd, and it looks like I should avoid HS too often. Im just under 14% hit and could really use some good ideas if u could it be greatly appreciated. Thx. Fury spec btw, 
Last edited by Zoban : 07/21/09 at 2:41 AM.
|
|
|
|
|
|
07/21/09, 3:21 AM
|
#1298
|
|
Glass Joe
Orc Warrior
Madmortem (EU)
|
Originally Posted by Zoban
I have downloaded the spreadsheet and it states that my theoretical dps is supposed to be arnd 4156. But I struggle to maintain 2300. Could I get some pointers on rotations. From what I gathered from the spreadsheet, it suggests waiting slightly and not nailing BT and WW on the cd, and it looks like I should avoid HS too often. Im just under 14% hit and could really use some good ideas if u could it be greatly appreciated. Thx. Fury spec btw, 
|
You should skill imp. HS. Furthermore the spreadsheet asumes that you have every buff possible. Check if you have got every buff and you should use BT and WW on EVERY CD and use your BS proccs!
|
|
|
|
|
|
07/21/09, 3:21 AM
|
#1299
|
|
Glass Joe
|
Rotation used in Spreadsheet
Just wondering which rotation - or "prioriy order" you are using for Arms to calculate said DPS in the spreadsheet? And how often are you expecting HS usage? Reading through the Arms DPS discussion thread it seems the agreed priority order is:
Rend > MS > OP > SD procs > Execute > Slam (and HS everytime rage spikes to 80). This is what i have currently implemented.
However using abilities at different priorities can drastically alter DPS. Im not asking for you to hold my hand etc etc just curious to confirm is that what you use to theorycraft the DPS on the Arms Spreadhseet?
|
|
|
|
|
|
07/21/09, 6:26 AM
|
#1300
|
|
Von Kaiser
Human Warrior
Kor'gall (EU)
|
Possible Bug?:
From what i can see, the spreadsheet isn't showing the socket bonuses for Leggings of Cunning Deception & Algalon rings when you're using the gear sheets. It just says Bonus: None; however it's listed in the lookup. For other gear the socket bonuses show up fine so I can't imagine that this is intended.
I can't see that this has been mentioned in this thread for the new build, only that the rings have the wrong socket bonuses in the lookup.
|
|
|
|
|
|
|