@Mlho


First, check the armory to make certain you are logged out in the arms/fury gear you wish to check on. Next, enable macro's at the top of the sheet. Then, type in your own character name and server in the spaces provided at the top of the sheet. At this point you should find success when hitting the 'green button', as you put it.

ok it worked this time weird. Thanks for the help.
Although it's showing the wrong trinkets. It's showing landsoul's trinkets. After I get an error that says Trinket1 and Trinket2 is not a supported Trinket use customer gear.

Then simply click on the box displaying the item name. A drop down arrow will appear. Click on it, find your trinket from the menu, and profit.

It seems neither of my trinkets exist in the spreadsheet. Neither appears on the list.

Use Mirror of Truth for your first trinket, it's the exact same trinket. For the second one, leave the trinket slot blank and just pop 95 hit rating into the phony stats box. Should be a bit further down that page.

One thing that seems to be a minor problem with the armory import, is that when I load in my toon the points in incite are never brought over. Its been the same in the last few versions I believe.

Thanks Landsoul.

With low crit rates and high AP/haste its a possibility. Mongoose is 132 agi (kings) and 64 haste rating from proc. Berserking is around 400 AP gain but also 27 loss from AttT so its around 186x(2AP) vs 132 Agi+64 Haste. Given how agi and haste and 2AP values are always around same novadays its very close.

Berserking gains with:

- Ilvl , AP is most uniformely increasing stat when you upgrade gear.
- more STR and AP

Mongoose gains with

- Low Crit levels - increasing Agility worth from mongoose
- High Haste rating - increasing Haste contribution from mongoose (i said 64 haste for the rough comparison - but mongoose gives flat 2% haste, not dependant on the ratings, and multiplicable with other haste sources)
- High Hit rating - increasing haste contribution again from increased white/heroic usage.

Coliseum seemed to get mixed impact on mongoose but usually positive:

- Str items are most widely used (with 1 mail piece in BiS), some useful STR jewelry, and STR proccing trinket
- Haste is very low currently, which reduces a bit the mongoose effectiveness
- Crit is higher then in ulduar, but it didnt get as much as other stats


Right now Id say theoretically its worth to switch to mongoose. Depending on gear it might be a few dps drop or gain, but its a very significant rage and haste upgrade for "cleave fights" like anub, jaraxxus , and depending on strat other fights. When the only hard fight requires you to cleave, increasing your effectiveness on it seems to be best.

I havent done it myself mostly because of laziness, but there is one more thing to consider - crit cap. A lot of Coliseum setups will run very close to white crit cap - so mongoose can drop radically for those, as much of agility benefit (and almost all benefit to rage generation) will be lost.

Hello I am an Orc warrior and I have a question about the expertise bonus on axes we receive. My mainhand is an axe and my offhand is a sword. Right now my expertise is 31/26. I want to replace my crappy bracers with the crafted ilvl 245 bracers. Doing do drops my OH sword below the expertise cap by 4 which would make it 22 but my MH is still capped at 27. Will having my OH not capped greatly affect me? The spreadsheet states that I will receive about 130 DPS increase from replacing my bracers BUT dropping OH to 22 expertise in the meantime. Is this accurate?

The DPS upgrade from the bracers is greater than the loss from going under the expertise cap for the off-hand. It is a minor annoyance but 130 DPS upgrade is considerable. Just go with the under expertise cap off-hand until you find a suitable axe for it. I am at the same situation for my weapons and gearing for off hand expertise would be a DPS loss.

Im not sure if this type of question goes here or not.. but seeing as how it's directly related to the spreadsheet.

Are there any mirrors out there hosting the updated sheet? Filefront sucks so bad. "File not found" after days of refreshing.

After experimenting yet another time with the sheet I got some results that I hadn't noticed. It looks like regemming 20 str gems for +10 stats to blue sockets so as to match the socket bonus grants almost always a dps increase. From ~1 dps when bonus is 8 AP to ~8 when bonus is 6 str. Currently I am running a setup with mjolnir and agility meta while aiming for the 'soft' penetration cap with a SEP on agility at 0,7954. A simple change of the blue socket in TR chest for a +10 to all stats combined with a meta with crit instead of agility grants 14 dps increase. A setup without arp trinkets would not have this option since most of the gem slots would be filled with arp gems but the above setup can support it. Does this mean we should reconsider our gemming plan?

Tottaly correct, I completely forgot the 'unique'. Only difference left would be to occasionally go with the crit meta while using a second blue with arp to match arp cap numbers but this is nothing new. Apologies.

Hi All,

I'm having a few issues getting the spreadsheet to actually give me an accurate SEP for ArP and this is all down to me being me. Unfortunately I've been having to rely on using a free version of Excel 2007 as I can't afford it at the moment and haven't found a "work-around" as my time is limited with work / social life etc. Therefore as I've reached the end of my trial time some of the formulaes don’t appear to be working - namely the SEP values - even though the spreadsheet is still loading up.

Despite doing everything but bribe Blizzard with a copious ammount of hard cash, I've been unable to aquire either the Runestone or Grim Toll. This may sound defeatest but as my current 10-man group doesn't have much time together we're concentrating on heroic-10 rather than push for 10-man Ulduar hardmode so I've resigned myself to giving up the ghost of getting an ArP trinket.

Still - despite my questionable use of the spreadsheet I decided to play around with gemming for pure Strength and pure ArP. I did a little bit of unbuffed testing with only battle shout up (i'm not by any stretch of the immagination a number cruncher) on a heroic dummy and found that the ArP set-up is giving me slightly more dps over a 7 minute period (went through 2 recklessness and DW) than the strength setup.

What I was after, given my lack of facilities to make best use of Landsouls spreadsheet, is whether or not to continue pushing from the hardcap of ArP which given the nerf means scraping together an extra 350 ArP from gear and sacrifice a few stats like strength and crit (keeping exp & hit capped) or to just go for strength again. I have enough scarlets to make the switch back to strength but I obviously don't want to have to do it again.

Apologies if this is somewhat of a menial, daft question but my gut feeling is telling me to just stick with the consesus that I should keep priortising strength until I get my hands on an ArP trinket, but I would just like some 3rd party reassurance from the community as to whether my gut feeling is correct.

Cheers,

Meneltama

P.s - as my post covers several areas (spreadsheet / simple answers & questions / fury dps discussion) I've put it in here.

From my own experience with the spreadsheet after the ArP Nerf, gemming ArP is beneficial in 2 cases:
- You gem ArP to reach the softcap of either Grim Toll or Mjollnir and after that, gem str in red sockets/str crit in yellows (or expertise and hit if need be for stat balance)
- You gem full Armor pen if you can manage to reach passive 90%+ Armor penetration from gear + gem.

You can only reach a very high passive Armor pen with high end ToGC gear (and it will be at the cost of expertise).

the link to your armory is not working atm, but chances are you should gem straight Str or Str/Crit in yellow sockets without an ArP trinket.

First of all I would like to thank you making an excellent tool, not many classes have as confusing and hidden mechanics as warriors do, this tool helps me alot. But I have a problem that might be big or irrelevant depending on the following question. Is the DPS metric affected in anyway by how you calculate SEP?

Because for some odd reason whenever I click to calculate SEP I get valueerrors all over the place.

http://i35.tinypic.com/1e410w.jpg
http://i35.tinypic.com/2dafuyx.jpg (with trace error showing it comes from multiple places, following these traces again leads me all over the place)

Why does the spreadsheet have completely different damge calculations for my BT/WW/ect. than what im actually hitting. currently it says my BT noncrits should be 4k but they are significantly lower than that. the case is the same for my bt crits and every other calculation of skills it is giving me.

The sheet has a giant section for configuring your raid setup, and you need to configure your sheet to match your raid setup. Usually when I download the sheet, Landsoul has it configured to have every raid buff and every boss debuff. So the damage the sheet displays will take all of these buffs/debuffs into consideration for the amount it shows you.

If you still use the 1997 version of Excel and are itching to use the spreadsheet, go download Office 2007 here:

[chocedit - no dont]

Works fine.

Why is the sword spec 10 seconds ICD on the spread sheet? Just from hitting a dummy a few minutes it's been proccing in less than 10 seconds more than once.

I believe the ICD for sword spec is 6 seconds.

sword spec proc:

1/(6+1/(2*AO15/100*Y174))

That is, once every 6 seconds plus the average time in seconds it takes for a proc to occur based on your attack rate. For example, if you had 5/5 sword spec and 1.0 attacks per second, your avg proc time would be 1/(.1*1) = 10 seconds. Your sword spec frequency would then be 1/(6+10) = .0625 which is equivalent to once every 16 seconds on average.

I don't see where you are pulling the ICD as 10s from. Maybe you are misunderstanding.

Well, it's in the first post.