I find it hard to believe clicking one cell and changing its value takes 90% of the time. If the issue is that much of a problem to you, why don't you go fix it yourself?

I looked over all items under Helm, Neck, Shoulder, Cape, Chest and Bracer.
No guarantee that I found everything!
I know that some mistakes already were posted here.
More to come! But that's enougth for today.

Helm

Item	Sheet	Ingame
[Guise of the Midgard Serpent]	Socketbonus 16 AP	Socketbonus 32 AP
[Warhelm of the Champion]	112 Str, 69 Hit and 192 Stam	122 Str, 61 Hit and 145 Stam
[Helm of the Grave]	86 Stam	78 Stam
[Crown of Anasterian]	60 Str	61 Str
[Cover of Silence]	35 Exp	No Exp
[Helm of Towering Rage]	61 Stam	69 Stam

Neck

Item	Sheet	Ingame
[Frigid Strength of Hodir]	64 Str, 40 Crit, 47 Hit, No ArP and 106 Stam	74 Str, No Crit, 40 Hit, 48 ArP and 81 Stam
[Collar of Dissolution]	28 Hit	24 Hit
[Spiked Collar of Servitude]	No ArP and 26 Exp	26 ArP and No Exp
[Choker of the Betrayer]	20 Stam	36 Satm
[Jade Dagger Pendant]	No Socket and Socketbonus	Yellow Socket and 4 Crit Socketbonus

Shoulder

Item	Sheet	Ingame
Shoulderpads of the Intruder	112 AP	122 AP
[Shoulderplates of the Eternal]	64 Crit	60 Crit
clerical mistake	Demonthooth Shoulderpads	should be: [Demontooth Shoulderpads]
clerical mistake	Onslaught Shoulderguards	should be: [Onslaught Shoulderblades]
[Spaulders of the Abomination]	No Socketbonus	Socketbonus 6 Stam
[Charred Leather Shoulderguards]	50 Agi, 41 Exp and 66 Stam	41 Agi, 42 Exp and 50 Stam
[Mantle of Volkhan]	45 Hit and 36 Stam	46 Hit and 45 Stam

Cape

Item	Sheet	Ingame
Drape of the Skyborn	154 Armor	162 Armor
clerical mistake	Frigid Winter's Embrace	should be: [Winter's Frigid Embrace]
Drape of the Skyherald	154 Armor	157 Armor
[Cloak of Darkening]	28 Agi	29 Agi

Chest

Item	Sheet	Ingame
[Tunic of the Limber Stalker]	63 ArP	No ArP
[Conqueror's Siegebreaker Battleplate]	2322 Armor	2348 Armor
[Chestplate of Titanic Fury]	61 Hit	62 Hit
clerical mistake	Custodian's Cestpiece	should be: [Custodian's Chestpiece]
clerical mistake	Hauberk of the Arcane Wrath	should be: [Hauberk of the Arcane Wraith]

Couldn't find Drakeheart Chestguard. Could be [Darkheart Chestguard], has same stats but is leather. If that's the case, then this item is two times in the table now!


Bracer

Item	Sheet	Ingame
Armbands of Bedlam	Socketbonus 4 Stam	Socketbonus 6 Crit
[Bitter Cold Armguards]	96 Stam	72 Stam
clerical mistake	Frostbound Chain Bracers	should be: [Frost-bound Chain Bracers]
clerical mistake	Bracers of the Smoldering Inferno	should be: [Bracers of the Smothering Inferno]
[Furious Gladiator's Bracers of Triumph]	64 Str	63 Str

Armbands of Bedlam (WoWwiki, Buffed-DB, found nothing about 4 Stammina!)

I will look through all remaining categories.
I updated the tables, so if you're interessted, landsoul, just tell me.

I found a typo

Breatplate of Frozen Pain -> Breastplate of Frozen Pain

What I do not understand is why Armor Penetration has increasing returns. Every 12 (or so) armor pen gives you 1% armor penetration. Going from 12 to 24, you get 2%, and so on. Every 12 points gets you 1%. So why does it make sense that as you get more armor pen, each addition point gives you more and more DPS. It made sense back when armor penetration was not a %, but a certain value of armor pen.

Even if it's a percentage, on each target you do still chip off a set value of armor every percent of Armor Penetration you gain. Say, against a level 80 mob with sunders and FF on it, you got 20% of ArPen on your character. You reduce the target's armor from 7394 to 5915 (-1478 from ArPen) -- 32,68% mitigation to 27,97%.

By increasing your ArPen another 20%, you further reduce the target's armor by 1478, and you gained a 7,52% damage increase doing so, reducing the target's armor to 4436 (22,56% mitigation). Increasing it yet another time to 60% ArPen you further reduce armor by the same amount of 1478, and you get a 8,13% damage increase doing so. Target's armor is now at 16,26% mitigation. Another 20% yields you a 8,85% increase, and the next 1478 armor reduces your target to 0 armor, giving you a 9,71% damage increase.

So, in a way, Armor Penetration still works the same. The difference is now from TBC that low-armor targets do not get hurt so much more from ArPen compared to high-armor classes. Going from 0% to 80% ArPen against a 15000 armor target yields a 36,36% damage increase. Against a 4000 armor target, the damage is increased by 19,96%.

Or in a shorter way:
Mitigation through armor has diminishing returns, so the opposite will have increasing returns.

Thanks for the update.

Noticed [Soul-Devouring Cinch] hasn't been added yet. Also, I believe this was mentioned before, but it wasn't changed in the update so figured I'd bring it up again - [Power Enhancing Loop] is 68 strength 35 hit instead of 60 strength 34 hit.

Hey landsoul,

thank you very much for your great work for our warrior community!
People all over the world use your spreadsheet (including me from germany )

Well, i have got a question for gemming:

How can I use Excel SOLVER for the gemming process? I think solver is exactly the thing you need for that.

The target cell should be the dps cell and the editable cells are what?? if i chose the gem fields it doesnt work (because of the dropdown?))

I think Solver is maybe a great way to find always the maximized GEM-Solution for your complete set or??

Best regards from europe!

Keep up the good work! It awesome, i love you =)

I've been using your spreadsheet for quite a while, and it's always been a really good measure for me - at least until recently. As you well know, the gear in non-hard mode Ulduar has the general theme of hit rating and armor penetration, and while equipping the pieces shows a nice increase on your spreadsheet, I'm finding my DPS is falling off drastically.

It's true that my attack power has gone up a couple hundred, and I am approaching the point in armor pen where I'll soon switch all my gems over, as well as gaining about 150 hit rating... but I've lost about 6% crit in the process. I'm finding that flurry and deep wounds are going down quite often, I'm having even more rage starvation issues than before, and I'm definitely not able to heroic strike as often.

I guess I don't really have any suggestions to make, but I am wondering if this discrepancy I'm finding has any reason behind it that could be overlooked in your spreadsheet?

The World of Warcraft Armory

This is where I'm at now, and I'm finding results are just not as good as the crit gear these new pieces replaced.

Edit: I was curious, and decided to swap my Valorous Siegebreaker shoulders and legs for my Valorous Dreadnaught in the spreadsheet, and found something interesting... My DPS went up a bit, but more than that, the four piece bonus for tier 7 doesn't seem to be worth anything anymore. That has never been the case for me. Does this mean that with just changing those two pieces out that I'll have so much rage that the proc will have no effect on my DPS? I hardly think that to be the case with how things were tonight.

Just tried using all plate and came up with 6707dps. Using T8.5 in every slot but the shoulder. Used T7.5 there instead. ArP total is 926. Belt of the Titans was easier to work with vs Belt of Colossal Rage. This freed up some restrictions and allowed more ArP gem usage. Also updated and used Frigid Strength of Hodir. Forced to use that due to belt swappage. But with updated stats it works out quite well. What i found interesting was i couldn't get better results with Plated Leggings of Ruination. I figured i may never see them so specifically optimized without them. I'm now glad that i did this. You can get about 6733dps with 792 ArP using the leather Legguards of Cunning Deception. I'll stick with the plate setup myself. I always prefer plate and i prefer the higher ArP.

I've actually noticed that lately as well and it's been puzzling me. I swapped some gear out for last night's raid, that according to the spreadsheet should've changed my theoretical dps from 5235 to 5337, yet my dps on bosses dropped from the 4600 range to around 4000. It was really confusing, all raid buffs should've been the same (unless someone stealth-respecced), and other dps classes didn't seem to have problems. Unfortunately I was the only dps warrior (we have a feral druid & combat rogue), so I didn't have anyone else in for comparison. Tonight I'll pull my old gear out of the bank and try to compare more thoroughly. My latency seemed consistent, it's always in the 60-90 ms range. I had no rage problems with either gearset, I was able to keep up HS nearly 100%. It's possible I was hitting Berserker Rage more often than before to maintain rage, but I'm not sure.

Basically gear-wise I dropped about 90 AP, 52 hit (unbuffed) to gain 45 ArP, about 0.9% crit, and 121 haste, which the spreadsheet was showing should be a 102 dps increase. I'll see what testing I can do tonight.