I've been playing with the spreadsheet a bit and given that I play an orc, I seem to be getting better results with [Greaves of Ruthless Judgment] than [Greaves of the 7th Legion] with the 3.2.2 Arp nerf since we get a total overkill on expertise with the boots. This also means that Orc warriors seem to be the only ones that can cap expertise and arp currently as Arms.

Page: FURY, ARMS, LOOKUP
Error Type: CALCULATION, FORMULA
Gauntlets of Rising Anger (heroic) is listed in the lookup with the red and yellow socket. On the fury/arms page however it only lists the red socket.

Hm, in newest version I am getting very high SEP values for crit , with 33% unbuffed it has 1,01 SEP.

Does anybody else get similar results?

Edit: for around 35% unbuffed crit is again below str.

dont know if this has been mentioned but ive noticed 2 things:

the new hit trinkets mark of supremacy is not listed

and when i use the armory look-up function it does not load the heroic version of the items i have equipped but the normal one (neck and belt from toc 10 hc on my character)

sorry if its not posted on the correct format

Error:

LOOKUP
Typo
The heroic version of Talonstrike does not include the Blue Socket, nor the socket bonus. Also, the stats on the spreadsheet for it are incorrect. They should read, 49AP, 40agi, 32haste, and 32ArP.
Also, the regular version of Talonstrike has incorrect stats. They should read, 57AP, 43agi, 28haste, and 28ArP.


Edit-- Added data for regular version of Talonstrike.

I read in Landsoul's comments, not to use the sheet to prove if ARMs\Fury is better than the other. Can someone give me the quick answer as to why ? Or of I'm comparing the 2, and Arms is showing 800 dps more, why that may not be accurate or a fair metric ?

I'd like to go back to Fury full time, but so far, even though I've gotten my gearing up to T8.5 levels, I still do around 500 or so more DPS has ARMS than Fury. In my case, the Spreadsheet seems to be pretty accurate on the DPS difference between the two and so I was just wondering if I'm just a special case.

I think if I can ever get some 232dps weapons (over the 212 ones I have now) then Fury will win out. But RNG hasn't been kind to me on drops.

Just another side questions of Flasks and foods, I noticed there isn't an options for Stregnth or Armor Piercing Pots. Is it possible to get that added in manually ? I'd just like a way to see what difference they make.

Anyways thanks for your time

Fury, I take it? I am also getting >1 SEP values for crit fury specced. This isn't the first time this has happened to me. Prior to Ulduar, I saw it happen as well.

I am guessing that it has to do with Flurry uptime. Play around with a couple +crit gems in your gear and I think you will see it drop under 1.0.

A strength potion that gives you roughly 315 AP for 15 seconds.
An indestructable potion gives 102 AP for 120 seconds.
Stick with the armor pots.

That said, assuming a 5 minute fight, the following is approximate (this math won't take into account special buffs, like using the pot during bloodlust or shattering throw, or when your grim toll procced):

(using my warriors #'s)
SEP DPS * Strength pot
1.8 * 120 = 216 dps while the pot is active

300 seconds in the fight, pot is up for 15 seconds or 5% of total fight.

216 * 0.05 = ~11 dps increase over the entire fight

same math using an indestructible pot.
SEP DPS * AP Pot / 2
.7576 * 102 AP / 2 = 38.6 dps while the pot is active

300 seconds in the fight, pot is up for 120 seconds or 40% of total fight

38.6 * 0.4 = ~15.4 increase over the entire fight, or ~30 dps increase considering you can pop two of these during one fight.


I'm sure there is a better (more accurate) way to do this math, but this might get you close.

Opps my fault, I meant to say Strength Elxir and not Potions, which I guess implies the insane stregnth pot.

No, I meant more like drinking a Strength or Armor Pen Elixir. I know that for Warriors it's less than the Flask, I'm just wanting to play with the numbers.

On the Hunter Side of the House, the spreadsheet shows drinking the Agil and Mighty Thoughts Elixirs beats out the flask, though we're only talking about 5dps and that requires kings.

Again, just looking to play around and see the differences. The only battle elixir listed for some reason is demonskin.

Right under the spot where you select the flasks, there is a spot to select battle and guardian elixirs. This should do exactly what you want.

However, the only Battle Elixir currently available on the sheet is Demonslaying.

Additionally, there are no Guardian Elixirs available (not even the Armor one).

BUG REPORT:
Run-time error '91':
Object variable or With block variable not set

HOW I GOT THE ERROR:
Hit "fetch" from armory after inserting Iggymcmuffin and Kilrogg into Name and Server fields.

REPRODUCEABLE: 100%.

ADDITIONAL INFORMATION:
The debugger is pointing at Function getItemName(id as String) in module 10.

More specifically it's pointing at the line which reads:
sName = Node.Attributes.getNamedItem("name").Text

It's saying sName is empty. I'm trying to step through it now to see if it's something obvious, but I'm not up on programming in excel and haven't used VB in ages.

Looks like it was a temporary thing. Armory might have been down intermittently because it just suddenly started working. My feeling is it's probably not catching a null somewhere when Armory lookup fails.

Hey yeah, first time contributing to this, I usually hide in the background reading these threads.

I have been messing around with the spreadsheet the last couple of hours just tossing around my gear and doing different combinations, and I tried something that I have been thinking about for months since seeing the high ilevel from ToC. Sorry if this has been covered, I recently resumed reading the thread.

I stacked ArP in every way possible to get the highest value possible unbuffed (70% in my current gear, a bit higher in i258), and replaced MR/Death's Verdict.Heroic with Death's Verdict/Death's Verdict.Heroic, and what have you, my DPS went up by 100! Personally I enjoy having a static ArP bonus and having STR procs over MR. This was just an interesting observation, but I definitely intend to go that path on live once the items drop already..., I'm excited to see how having a very high base ArP changes things as opposed to being stuck with MR for all eternity.

Also, Dark Matter went up a bit in value over Greatness when I did this, so DV/Dark Matter? Food for thought


Edit:
On a side note, any plans to implement Engineering into the spreadsheet? It has gotten nothing but buffs lately and even ignoring the dramatic bonus of the speed boots on many fights, the passive bonuses and the use of saronite bombs, pyro gloves, and the frag belt off cooldown are a dramatic increase in DPS relative to any other profession. The pyro gloves alone scale off of the debuffs on the boss and I have had them crit for 7k with Deathwish up (45 sec cooldown, that's quite the DPS for a single enchant). It would be nice to see an implementation of the profession, but amazing work you've done Landsoul

Are you sure that pyrorockets are better than hyperspeed accelerators? I always thought of pyro rockets as a pvp enchant. You say that those rockets did up to 7k, but the average damage is around 3.5k in a raid situation, right?

So, pyro rockets: damage/CD = 3500/45=78 dps increase.

Haste SEP is around 0.65, and one SEP equals to 1.9 dps increase (I think these are the values I have).

Hyperspeed accelerators: haste given*(duration time/CD)*haste SEP*dps increase for 1 SEP = 340*(12/60)*1.9*0.65=84 dps increase.

And this is in a single target fight. In AoE, haste becomes far more usefull (more rage and more cleaves).

So, I think that hyperspeed accelerators > pyro rockets. Anything wrong with my reasoning?

some more (and some old) typos in version 2.501:

[Gauntlets of The Culling] - Gauntlets of the Culling (has to be upper cased)


[Cinch of Bonded Servitude] and [Links of Unquenched Savagery] - you've just one "item": Bonded Servitude/Unquenched

[Infectious Skitterer Leggings] -> Infectious Skitterrer Leggings

[Treads of Nimble Evasion] / [Treads of the Earnest Squire] - you've just one "item": Nimble Evasion/Earnest Squire

in formula: [Ring of the Violent Temperament] -> Ring of the Violent Temperment / [Band of the Violent Temperment] - Band of the Violent Temperament

[The Blade of Harbingers] -> The Blade of Harbringers


formula: Horde only
[Spaulders of the Snow Bandit] - Placeholders of the Ice Scout
[Pauldrons of the Shadow Hunter] - Pauldrons of the Placeholder


missing: [Gormok's Band] (non heroic version; you'v just the heroic but I wear the non-heroic :-))

Page: Lookup
Type: Typo
Cell E236: Master's Inscription of the Axe shoulder enchant is listed as "+104 AP + 15 Crit" while it was buffed in 3.2 to "+120 AP + 15 Crit" and has the correct stats already.

Just add 50 STR or any stats of other Elixirs manually in the "Stat Modification"

I finally installed Office 2007 last night (been using 2000 for ages) and the new spreadsheet is awesome Landsoul.

Huge thanks for all the hard work you've put in.

Due to lack of expertise on my current gear, 51 of my exp rating is from gems.

I am therefore interested in items that have expertise on them, as I could then switch the exp gems for ArP gems, however the spreadsheet is (obviously) rating expertise as useless for me, as I am capped, thereby devaluing items with expertise on.

For anyone else in the same situation, I found that manually entering a negative exp value of say -51 (the amount I am looking to replace from gems) in the manual adjustments section of the spreadsheet, allows the lookup tables to sort items with expertise in a way that correctly indicates their usefulness to me.

About the Run-time error '91'

It popped up last night for me. I tested on my laptop and then on my desktop and got the same result.

Then today tried again today and it was resolved. Surely an Armory update issue.

At the moment my dwarf wears 2x Ironsoul (2-Hand Mace), so I get 5 Expertise extra. I have 26 Expertise in total - so I'm at the cap while wearing maces.

On the Lookup-Page there are many weapons that are better then mine... of course not only Maces. The Edge of Ruin (Axe PDC Hero) is listed as a little better then my Ironsoul after clicking on "Click to run item comparison", so I choose it on the Fury-Page as a Main-Hand-Weapon (Offhand is still Ironsoul).

I expected that SEP tells me that I have too less Expertise (21)... but it didn't.

In the Pre-3.2-Spreadsheet the expertise-value for main- and off-hand were separated... in 3.2 there is only one value.

But to my knowledge expertise out of racial traits does only count for the main or offhand (or both when both are the same kind). Isn't that right any more? Or is the spreadsheet wrong?!

If offhand expertise is different than mainhand expertise due to racials it does take it into account. Notice there are seperate fields for mainhand/offhand dodge and crit. You only get one bonus per hand, not double bonus for both when wearing two maces.

I'm trying to figure out if I'm doing something wrong or if something changed and Expertise is less valued. Under Arms, I can let myself go all the way down to 2.75% (or 11 expertise) and it shows a SEP .3720 value for expertise. If I add in any expertise it lowers my DPS.

Maybe I have it all wrong, I thought the dodge cap was 6.5% whether Arms or Fury and that as NELF I would need to get to 6.50% expertise. In Arms, I get 2% from Talents, so would need 4.5% or a expertise of 18 (give or take a smidge). So far the Spreadsheet seems to hate any expertise.

Am I doing something wrong or did something change ?