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

You will still need 100% ArP regardless of Sunder armour and faerie fire. Those are stacked on top.

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.

AeroWow | The Renaissance of Armor Penetration

It's slightly out of date, as I wrote it prior to the final changes that were made to ArP, but the concepts are still relevant. FF+Sunders stack multiplicatively with ArP (from gear, stance, or weapon spec).

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?

You have the ilvl 232 version, dropped from 10-man normal-mode. The version posted earlier is the ilvl 245 version dropped in 10-man heroic mode.

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.

Probably still bugged. Like I said, I thought those were the cells that needed fixing, but I could be wrong. Hit should be worth the most SEP until capped, but expertise's value diminishes below that of strength when within 2 or 3 points of expertise cap.

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.

^This


There are several items that have the same name and different iLevels.

Just want to point out for those using galindon's modified spreadsheet in the interim that cell Z29 in the arms sheet should be
instead of
otherwise it uses the wrong value for armor pen to determine white dps.

When Landsoul has an updated version of his spreadsheet, he can PM a mod and we'll reopen this thread. Until then, you fucking retards can't be trusted to post here.

Check the front page for the link. If you don't have 2007, well you are just gonna have to wait a little bit more beacause I have to go back and cut stuff out for 97 because it can't handle some of the cells.

The new look is great. Well worth the wait. Thanks for this.

Looks and works amazing, just one thing though. On the talents when you try to change say the sword or mace spec, the picture is becoming selected before the drop down menu. I just moved them to the side and could use the menu again. I'm not sure if this is only on my side as I'm using a newer version, either way just a heads up.

For some reason the 4pT8 Bonus reduces my dps in the Arms-Sheet by about 400dps.
And I also have the button Fetch Armory on my 3rd Belt socket.
The rest looks great!

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).

Also, Aesier's Edge seems to be missing from the Offhand selection.

PS: Thanks alot for your hard work, landsoul!

Firstly, thanks a lot for the sheet (and updates) its greatly appreciated.

All of the items from "Trial of the Champion - Heroic" that are in the sheet have thier previous ilvl213 stats, rather than the current ilvl219 stats. Obviously quite easy to change, but worth noting. Im just having my first play around and will edit this post if i find anymore errors.

I do appolagise if this isn't the place for error reports. but the first page didn't seem very clear.