I've been a huge fan of Rawr to use for my Mage and Prot Paladin but it seems to be not totally accurate for Arms Warriors at the moment (I could be wrong), so I decided to check out your spreadsheet.

I've been so spoiled on how easy it was to "optimize" my gear, gems, enchants through Rawr which basically does everything for me after pressing a button. So I'm having a hard time to adjust to spreadsheet.

I have a few questions if you don't mind.

Is there a way to figure out what my best setup is given the gems/enchants/gears I have available? Or do I have to manually plug in different gears,gems, and enchants to see what the change in total DPS is? This isn't much of a concern when I'm only comparing between 1 or 2 items, but if say I have 10 different gear pieces for 5 different slots (so 10 gears, 5 slots to put them to) and want to maximize my DPS, it seems hard to compare the results by changing the setup 1 by 1.

Like for example, let's say I have Ring A, Ring B, Neck 1, Neck 2, Trinket a, Trinket b...Ring A might be higher DPS if I have Neck 1, trinket a equipped..or ring B might be better if I have neck 2, trinket b equippeed..and so on and so forth.

Is there a way to better optimize my setup manually choosing each items?

That's just unbuffed stats. It has nothing to do with the actual calculations

Somewhat. Put in your gear, calculate the SEP, sort the Lookup sheet and go down the gear lists to see if the other items you have are below/above the ones you're wearing, then fiddle around. It won't be able to cover capped stats so well (Hit and Exp), but it gives you a start.

@landsoul

Aye, but it's just very disturbing not seeing your unbuffed stats match the spreadsheet ones.

Landsoul, can you elaborate a bit on the ArP issue?

It sounds like ArP hasn't been buffed as much as it was supposed to, but your spreadsheet accounts for it (in other words, your spreadsheet reflects live right now). Is this correct? Or does the spreadsheet not reflect live?

All testing against the heroic dummy indicates that ArP is suffering from a 19% suppression.
In other words, against a boss, you can expect to only get 81% of your ArP.

We told Blizzard this a whole lot of times in a whole lot of threads and got no substantive response. We all kinda hoped it would change, and it didn't. They haven't said yet if this is intended or not. The bottom line is that yes, ArP gives you less than your tooltip. If your tooltip reads 100%, you're actually only getting 81%.

Are you for sure on this information? I am no number cruncher but I went ahead and regemmed all of my gear with ArP, does that mean I should turn around and regem everything with strength again? I cannot view the spreadsheet on my current computer, but would strength scale better then ArP until fixed?

Also on a sidenote, have people tested arms dps to fury yet in a raid situation with full buffs? I haven't had the opportunity in a 25 man to test it due to server crashes.

Edit: Forgot to state that I am currently arms, regarding regemming if that makes a difference at all.

Once you start nearing 6K DPS as Fury ArP starts passing up strength. And that's also just factoring in whatever ArP you would get normally from Fury gear, not gemming for it. Not really going to worry about it much until they fix the ArP issues though, which hopefully won't be too long.

Hi,

Your fix for the arms armor calculation isn't quite correct - the final (incorrect) term was indeed adding armor from Endless Rage, where it should in fact have come from toughness - the original formula is closer, but the AR8 term should read AR15 (as it does on the Fury sheet). Small point, since I doubt many will be running with toughness, but what the hey.

I also found the B3 calculation to be double-dipping AttT, and prefer your version, though just for completeness you probably want a ROUNDDOWN on the J4/180*AL7 term - mine was out by 1 without this.

Not sure your E4 calculation is entirely what was intended, since the *1 term looks extraneous - should that read AO16*AI24?

I actually had J3 nearly spot on; only thing missing was a lookup on my necklace causing the value to be slightly low - adding "+VLOOKUP(C8,Lookup!U2:AH40,11,FALSE)" to the large lookup sum got me spot on.

Finally my unbuffed crit (B4) was out by about +0.24% (and, unlike B3, it takes Zerk stance into account). I couldn't find any error with the formula except perhaps the base 3.192 value; I have thus far been unable to verify this constant.

I understand these unbuffed figures are purely cosmetic - the rest of the sheet looks mighty impressive. It's just nice for newcomers to the sheet (myself, for example ;-) ) to see that the easily comparable figures here match their paper doll, giving confidence that they have imported their character correctly.

Edit: D'oh - I just realised you are probably looking at the Arms sheet, given your first edit; I am looking at Fury, so not sure if the J3 calculation is different.

The item might of the leviathan is showing to have 43 hit rating and 34 ArP on the spreedsheet when it in actually has 34 hit rating and 43 ArP. I changed this on my local copy, just thought I should let you know.

Well doesn't that just show me up as a complete noob who doesn't enchant his gear (and a self-quoting one at that)? The HP calculation also doesn't take the +stats enchant into account. Not an entirely straightforward fix for this (that I can see), so no worries if you don't feel like fiddling with such a minor cosmetic thang; just thought I'd mention it.

Edit: Now understand how enchants are modelled, so added "+VLOOKUP(C15,Lookup!GB261:GN264,12,FALSE)" and my HP are again correct.

Anyone care to submit a known item BIS? Regardless of faction or race.

I've had a poke around with Landsouls sheet and feel there's still some grey areas with my selection.

Could you add "Extract of Necromatic Power" for the Trinket slots? Thanks

Seems there are still quite a few items to be listed that haven't dropped off bosses yet. I have seen two new 2handers this week, so your BIS request may be a bit premature. Hopefully we will have a full listing in the next couple of weeks.

In case you never got a Grim Toll, and your guild isn't doing Naxx 25 for a while, or you simply want crit over it's hit:

http://static.mmo-champion.com/mmoc/..._17_9767_6.jpg

10 man Hard mode Thorim.

MMO-Champion BlueTracker - 116% Armor Pen only giving 66%!?!?!?!

Update on ArP status.

Allright, I'll get working on that and have it out soon.

Depending on your gear, str is about the same as hit or expertise. If you dodge you can also use a relatively small space consuming instant crit, so it makes sense that expertise would be lower than 1.

Might of Leviathon has its hit and arp in the wrong place on the spreadsheet.

updated.

X110, the Mjolnir Runestone uptime cell still references Grim Toll:
ArP Values for Grim Toll and Mjolnir are hard-coded. C59 isn't anything like the Grim Toll cell.

Ah, AD78 still references AD108 instead of AD110.

Cloak gem and socket bonus cells are busted, as well as only doing a lookup on the first socket for the bonus.

Gear totals don't have a 2nd socket for cloak yet.

Mjolnir runestone is actually 655 ArP even though its tooltip says 612, Mjolnir Runestone - Spell - World of Warcraft

Ok so looking at this spreadsheet, for arms is it 100% safe to say that ArP > Strength? as i resocket the gems from Strength to ArP my dps goes up on the spreadsheet. So before i resocket i just want some input and any kind of confirmation anyone can give me because its a lot of Gold id rather not waste. So if anyone could give me some input thatd be great. Thanks