Warrior DPS Calculation Spreadsheet - Page 47

speeddemon · 04/29/09, 8:42 PM

Is the update macro for the SEP working? When I click on it (click for SEP Calc), it says cannot run the macro .... macro not in workbook or all macro may be disabled. Anyone know the problem?

Grimlii · 04/30/09, 3:38 AM

You need to save the workbook not just run it.

speeddemon · 04/30/09, 6:16 AM

thank you, got it working now

samot · 04/30/09, 8:57 AM

Originally Posted by MikHaven

Strength Equivilant Points - IN as much as if you had one point of armor pen how much strength would that equal. Since the warrior is based off of strength for everything we do.

Therefore if people are saying that their Armor Pen SEP is 1.5 that means for 2 points of armor pen, it would be equal to as if you got 3 points of strength, thereby the whole discussion of is armor pen better than strength.

With other words: until the (recalculated) SEP value of a stat (AP, ARP, crit ...) reaches or exceeds 1,0 it is better to sockel STR instead this stat.

windav · 04/30/09, 10:10 AM

EDIT: Filefront works!

Mordenthal · 04/30/09, 11:22 AM

Got 24.11% ArP from gear and gems and with the Grim Toll proc puts me on 73,80% ArP. Currently the SEP value of ArP is 0,9717.

I have 3 27str gems and if I switch them to 27 ArP it gets a SEP value of 0,9837.

As I understand my gear isn't good enough yet for maximizing what I get from ArP, ie I'm too low on AP? Or do I have too little ArP from gear? If I artifically put in a couple of more ArP gems the value starts going over 1.

Edited

cozie · 04/30/09, 11:46 AM

Is there another link to get this anywhere else? I am with Pokiou and am unable to get this to download. What is up with Filefont ?

Lamprey · 04/30/09, 6:26 PM

Hmmm, so on latest download of the spreadsheet it comes up with about 8 circular references and I cannot figure out why it thinks that. Anyone else have this problem?

Stink · 05/01/09, 9:45 AM

Whenever I get messages about circular references, it's because my Maximum Change value got reset to the default .001 rather than .00001. I change it back and then reopen the spreadsheet and everything is fine.

Paradosi · 05/01/09, 10:29 AM

Landsoul, before you update the spreadsheet as I'm sure it's a lot of work with the new info out there and all the new items that need to be added, do you think with negative armor and how it scales, that Grim Toll + Mjolnir Runestone will end up being the best combo of trinkets to use?

nomopofomo · 05/01/09, 3:45 PM

Originally Posted by Paradosi

Landsoul, before you update the spreadsheet as I'm sure it's a lot of work with the new info out there and all the new items that need to be added, do you think with negative armor and how it scales, that Grim Toll + Mjolnir Runestone will end up being the best combo of trinkets to use?

Probably only if this whole negative armor thing pans out positively.

RPZip · 05/01/09, 4:36 PM

Originally Posted by Paradosi

Landsoul, before you update the spreadsheet as I'm sure it's a lot of work with the new info out there and all the new items that need to be added, do you think with negative armor and how it scales, that Grim Toll + Mjolnir Runestone will end up being the best combo of trinkets to use?

I've heard they tend to synch up, which I haven't tested myself as I don't have the Mjolnir Runestone.

Assuming that they do (and honestly, probably even if they don't) it almost certainly will beat out the DMC: Greatness unless you're just wasting the hit from the Grim Toll.

Linklinus · 05/01/09, 5:05 PM

Is Expertise really that weak? I'm at 21 Expertise but the SEP value is only 1,0147 for me. (ArP is at 1,1162)
I can't belive the other Stats really compensate the dps-loss of a dodge. So should i go on gearing for Str/ArP and ignoring the expertise cap?

Paradosi · 05/01/09, 5:10 PM

If armor pen doesn't get changed anytime soon, if I get the Earthshaper, go Mace spec, and pick up a few more BiS Arp items, I might start ignoring expertise to really just focus on stacking Arp since it's value will start going through the roof making both GT and the MR trinket procs insanely powerful.

Shha · 05/01/09, 5:17 PM

Well mace spec isnt worth it still until around 1700 ArP from gear. Axe spec is THAT good :P.