Hi guys, I was playing arround with the spreadsheet, and I checked som gear and made a 100% Arp gear.

I wondered why the dps was still increasing after i cought 75% unbuffed pentration, while gemming Arp.... but doestn Sunder armor do 25%? so 75% base + 25% sunder pentration= 100%

At the end i had a build with 87% base pen + 25% sunder pentration= 112%

I thougt the arp cap was 100% ^^, its a bug or the sunder mechanic is working with the arp together like this

Unbuffed 10k Armor
-25% Sunder
---------------------------
Debuffed 7.5k Armor (is the new 100% value for the Arp)
-75% Arp
---------------------------
Total 1.875k Armor

Is that total s*** or does it work like this? xD

And Big thanks Landsoul for ur great work, the sheet is just amazing

ahh, ok! thx

crazy thougth but if u got 100% base pen + 25% sunder ->125%, then it would be better if the target has more armor?!?

Please forgive me if I've missed this earlier in the thread, but when I input my stats for arms DPS with either this new spreadsheet or the slightly older one, it doesn't value hit much at all, even when I'm nowhere near the cap. Is this a new dynamic that we have to work with where not capping can be valuable, or is it a flaw in the sheets?

Simple ArPen calculator

Maybe this link will help you understand how Arp, FF and Sunder work together.

Carnivorous Band
245 Version of the Carnivorous Band

Item #47993
Binds when picked up
Unique-Equipped
Finger
+70 Strength
+86 Stamina
Blue Socket
Yellow Socket
Socket Bonus: +6 Haste Rating
Requires Level 80
Equip: Improves haste rating by 34
Equip: Increases your armor penetration rating by 49


*Edit* The original post by Landsoul included the 232 version of this ring, this post was made to correct that, and his loot list was updated after this post was made.

Sunder Armor is 5 stacks of 4% = 20%.

Ehh. i just got that ring, and its 235 itemlvl and got only 1 blue socket... am i missing somthing? are there two of these rings you can get?

I think there's a mistake in the BiS list, Gauntlets of Ruthless Riprisal are a drop from Freya, the TotC drop is named Gauntlets of Bitter Reprisal

It was posted earlier in the thread, somewhere between pages 40 and 50 I believe.

Anyways, I THINK the fix is changing cell AH29 to read:
If that doesn't fix it then I'd suggest reading back through the thread. It's there, but I'm not certain where. I could find how to fix it for you if the old version were still being hosted, but it's not.


Edit:
If AH29 isn't the problem try changing Z29 to read:
Sorry I can't remember which cell exactly it is that's broken... but it's a cell somewhere in that area of the spread sheet.

I've made the changes to the spreadsheet as listed above, but when leave myself uncapped, I find Hit and Expertise consistently under valued compared to Strength and Armor Pen. I've also tested adding hit or expertise vice str/ArP/crit and the latter values always yield more dps in the spreadsheet. Is this accurate or is my sheet still bugged? (Currently only working with the Arms portion of the spreadsheet)

You might use the option on the lookup tab to change the value of hit manually. I had the same issue, but also couldn't fix it. I simply changed the "adjust hit to:" 1.2 so that it was valued a bit higher than ArP and Str. I know that's not the best way, but it got me closer than it was.