Warrior DPS Calculation Spreadsheet - Page 40

Borona · 04/19/09, 8:24 AM

Originally Posted by Axira

For some reason the entire spreadsheet, of the latest version, is broken for me. It gives #div0! values for the SEP values, probably because it doesn't decently seem to calculate the effect of +1 stat on the DPS (as in that column all the DPS values stay the same.)

I when pressing the "calculate SEP" button I can see it adding +1 to each stat temporarily, but it doesn't seem to write down how this affects the DPS in the end. Or maybe it doesn't calculate it decently. I've no clue why it's suddenly broken compared to the previous versions.

This happened to me too after i tried to use the armory-import. Redownload the sheet, fill in your gear manually and it should work fine, at least it did for me.

Axira · 04/19/09, 8:31 AM

Originally Posted by Borona

This happened to me too after i tried to use the armory-import. Redownload the sheet, fill in your gear manually and it should work fine, at least it did for me.

Doesn't work I'm afraid. Even when not importing from armory, and when I just change gear manually, the overall DPS number stays the same and the 'calculate SEP'-button still doesn't work. Thanks for the help though. It also gave a me circular reference warning now.

callion · 04/19/09, 10:09 AM

Sorry, delete please

• Rezarel · 04/19/09, 11:19 AM

Originally Posted by Axira

Doesn't work I'm afraid. Even when not importing from armory, and when I just change gear manually, the overall DPS number stays the same and the 'calculate SEP'-button still doesn't work. Thanks for the help though. It also gave a me circular reference warning now.

Once the sheet gets broken, it's impossible to unbreak it. Did you redownload the sheet before trying to manually select your gear?

Also, the circular references are necessary because of how warrior mechanics work.

Symphonia · 04/19/09, 4:25 PM

Originally Posted by callion

I think I found a bug, the weapon specs are not updating when changing weapon to anything but an axe/polearm (arms sheet).

Unless I misunderstood what you're saying; you have to manually change your weapon spec under the arms talents. Switching weapons doesn't do it automatically for you, even when switching to an axe.

Harpo · 04/19/09, 7:50 PM

Originally Posted by Stuntspike

I am not sure if this an error only I myself am getting but for whatever reason it is showing my Darkmoon card: Greatness as AGI being my highest stat even though i am well over my AGI total with STR.

Is anyone else seeing this?

Also how would i go about adding in Lotrafen, Spear of the Damned into the weapon slot?

The "STR" portion of the Darkmoon Card is simply missing. Off the top of my head, I believe there is an empty cell (It should just have "STR" writtein in it), next to that there is a number (this is your strength), then it says agi, then your total number of agility.
I believe it is there simply to let the player know if they have more Str than agi.

Also, I am not sure about your last question. You add it into you weapon slot as you would any item.

Originally Posted by Axira

Doesn't work I'm afraid. Even when not importing from armory, and when I just change gear manually, the overall DPS number stays the same and the 'calculate SEP'-button still doesn't work. Thanks for the help though. It also gave a me circular reference warning now.

Socketing drape of the faceless was causing this error for me.

My primary concerns with this spreadsheet is how amazing it is rating Apen, as Rpzip claimed, even when I am cap/near cap with or without procs, apen is still out-weighing strength. I understand armor pen does not scale linearly, and as you get a higher number, it will increse in value, but it seems a bit off right now.

Also, my horribly itemized/gemmed arms gear is giving me about 100 dps than my newly optimized wishlist set. I made sure all the buffs are the same, I confirmed weapon specs, lag, race, draenei racial, etc. etc. I simply do not understand how I am only gaining 100 DPS with all of these upgrades. I put a bit of time into this spreadsheet and I finally set it up so I was at 18 expertise, slightly over hit cap I also would have the 2/4 piece set bonuses for tier 8, since the 4 piece seems to be around a 100 dps upgrade by itself according to the sheet. Suprisingly, the 2 piece tier 8 bonus was only around 30ish DPS if I recall correctly. Could anyone possibly update a wishlist of what they intend on using/speccing so I may compare it to m own?

Megalith · 04/19/09, 10:45 PM

I also noticed that the Darkmoon Card: Greatness became worse with the latest spreadsheet both for fury and arms. Now Mirror of Truth surpasses it. But if it's only a possible agility procc that is counted instead of str we know the reason for this odd behaviour?

I also noticed that for arms Lotrafen surpasses Voldrethar with 100 dps at least. I guess this is plausible thou considering poleaxe specc is stronger than sword?

IggyMac · 04/20/09, 12:00 AM

Is the code for importing a character working?
I can't seem to make the function work, and it tells me that

"Could not find http://www.wowarmory.com/character-talents.xml?r=Eldre'Thalas&n=IggyMcMuffen&lang=en_us"

I suspected maybe it was because the apostrophe in Eldre'Thalas wasn't URL encoded, but that doesn't seem to be the issue.

Ferboten · 04/20/09, 12:06 AM

For the fury sheet at least, Darkmoon Card is still the top.

I've put together a list of what I think is the best in slot using plate, at least with the items provided in the 2.401 spreadsheet, as an UD warrior with BS/JC

Helm: T8.5, 21crit3%crit/16arp
Neck: Pendulum of Infinity, 16arp
Shoulders: T8.5, 16arp
Cloak: Drape of the Faceless General, 16arp/8str8crit, 23 haste chant (i put the gem bonuses and socket bonus in phoney stats since the cloak gems seem to be bugged)
Chest: T8.5, 16arp/27arp
Bracer: Bitter Cold Armguards 8str8crit/16arp
Weaps: 2x Voldrethar 16arp/16arp, berserking chant
Gloves: T8.5 8exp8hit/16exp
Belt: Belt of Colossal Rage 27exp/8str8crit
Legs: Plated Legguards of Ruination 16arp/8str8crit/27exp
Boots: Melancholy Sabatons
Ring 1: Godbane Signet
Ring 2: Sif's Promise
Trinket 1: Darkmoon Card: Greatness
Trinket 2: Mjolnir Runestone
Ranged: Twirling Blades, 16arp

NoTaeves · 04/20/09, 1:25 AM

Originally Posted by Ferboten

For the fury sheet at least, Darkmoon Card is still the top.

I've put together a list of what I think is the best in slot using plate, at least with the items provided in the 2.401 spreadsheet, as an UD warrior with BS/JC

Helm: T8.5, 21crit3%crit/16arp
Neck: Pendulum of Infinity, 16arp
Shoulders: T8.5, 16arp
Cloak: Drape of the Faceless General, 16arp/8str8crit, 23 haste chant (i put the gem bonuses and socket bonus in phoney stats since the cloak gems seem to be bugged)
Chest: T8.5, 16arp/27arp
Bracer: Bitter Cold Armguards 8str8crit/16arp
Weaps: 2x Voldrethar 16arp/16arp, berserking chant
Gloves: T8.5 8exp8hit/16exp
Belt: Belt of Colossal Rage 27exp/8str8crit
Legs: Plated Legguards of Ruination 16arp/8str8crit/27exp
Boots: Melancholy Sabatons
Ring 1: Godbane Signet
Ring 2: Sif's Promise
Trinket 1: Darkmoon Card: Greatness
Trinket 2: Mjolnir Runestone
Ranged: Twirling Blades, 16arp

This is also what I got, minus a few exp gems due to the human racial. For what its worth, you say its the best using plate but I have been unable to find any set up plate or otherwise that outweighed the value of the 4 set bonus.

IggyMac · 04/20/09, 2:04 AM

Found a couple of other small bugs. Apparent the spreadsheet has a reference to another arms1.000 spreadsheet and so Excel 2007 complains.

Also in the Excel 2007 version, putting a gem in Drape of the Faceless General causes a N/A error and all the calculations break.

landsoul · 04/20/09, 2:38 AM

Yeah, expect another update in a day or so top fix those. I haven't found the external file reference yet to take it out. But yeah that's definately the BiS setup that I found too (minus any hardmode stuff that is yet to be unfound)

Cortic · 04/20/09, 4:35 AM

Originally Posted by Ferboten

For the fury sheet at least, Darkmoon Card is still the top.

I've put together a list of what I think is the best in slot using plate, at least with the items provided in the 2.401 spreadsheet, as an UD warrior with BS/JC

Helm: T8.5, 21crit3%crit/16arp
Neck: Pendulum of Infinity, 16arp
Shoulders: T8.5, 16arp
Cloak: Drape of the Faceless General, 16arp/8str8crit, 23 haste chant (i put the gem bonuses and socket bonus in phoney stats since the cloak gems seem to be bugged)
Chest: T8.5, 16arp/27arp
Bracer: Bitter Cold Armguards 8str8crit/16arp
Weaps: 2x Voldrethar 16arp/16arp, berserking chant
Gloves: T8.5 8exp8hit/16exp
Belt: Belt of Colossal Rage 27exp/8str8crit
Legs: Plated Legguards of Ruination 16arp/8str8crit/27exp
Boots: Melancholy Sabatons
Ring 1: Godbane Signet
Ring 2: Sif's Promise
Trinket 1: Darkmoon Card: Greatness
Trinket 2: Mjolnir Runestone
Ranged: Twirling Blades, 16arp

How can your gems reflect BiS when Str is still a greater stat than ArP?

Ferboten · 04/20/09, 5:05 AM

Actually with that gear, ArP is slightly more valuable than Str. I guess the high amount of ArP already present on the gear plus the high amount of AP (I get 4409 unbuffed) without gemming for it makes ArP more valuable. In my first pass of the gear I gemmed for Str but then after calculating SEP values again ArP came out on top.

Harpo · 04/20/09, 5:11 AM

Those are similar to what I have or my arms setup, but obviously arms needs a lesser amount of exp/greater amount of hit. What off piece are you all think about using for arms? I am at 18 exp/just over 8% hit, and I cannot find a better setup to use 4 pieces of tier 8 without simply running 5/5 tier 8. However, this just seems wrong. This is what I am currently considering, although it could very/probably be incorrect.

5/5 Conqueror Siegebreaker (Head, Chest, Gloves, Leg, Shoulders) gemmed with ArP in red/+8str +8 crit in yellow, along with a +6 to all stats/+8 ArP + 12 stam in the legs/chest for my meta gem since I am not a JC. I am fairly sure the two blue gem placement could be better, but it is not something I will lose sleep over for the moment.

Frigid Strength of Hodir gemmed with +16 ArP

Drape of the Faceless General (gemming it was causing errors, probably 2 +16 ArP gems)

Bitter Cold Armguards with 8 str/crit and a +16 ArP BS gem

Lotrafen, Spear of the Damned with Berserker, although I really hope an axe is released so we do not have to compete with hunters, as I imagine this is probably one/their BiS weapon

Belt of Colossal Rage with 3 16 ArP gems

Melancholy Sabatons - I am also using runspeed over icewalker. I am not sure if I will keep icewalker, as juggernaut/intercept may be enough PvE mobility, but I really like the runspeed for mimiron/boss encounters where the tank is moving the boss and eventually desyncs.

Loop of the Agile with 16 ArP

Strength of the Automaton

DMC/Mjlonir Runestone for trinkets

Twirling Blades with 16 ArP for my ranged

This gear puts me at 18 Exp (cap with weapon mastery), 265 hit (8.08%), 37.63% crit (poleaxe spec), 59.12% base apen, .98% haste, 3538 AP, and 27238 HP not even coutning my mining bonus.

However, in comparison to my bad, bad current arms gear, it is only a 150 DPS gain. I just fail to see how that big of a stat leap is only 150 DPS. I basically am losing 2% crit and slightly over 3% haste in favor of 15 AP and *30%* armor pentration, on top of having a superior weapon. I am hoping that an item on the spreadsheet is simply not adding into the total DPS calculations, and it is more of gain than 150 DPS.