As well, if you have the sheet set to consider the defensive value as well as the offensive value the agility will increase dodge as well.

Yes. I'm pretty sure it's not going to prove to be optimal, but it should be in the sheet anyway. I recently picked up a couple myself, but have been too busy with the Twin Eredars to do any testing.

Problem with nerves of steel is that it has no quantifiable benefit of any sort. I mean, it's good on some fights and whatever, but there's no direct way to convert it's effect into damage or survivability in the general sense, hence the reason it's excluded.

Why not? Depending on your gear/buff combination, Agi, particularly in weighted total, can be quite close to hit in overall quality; and 10% is plenty to nudge it from just below to just above the quality of hit, which would change the gem recommendations.

Question: is there anyway to just update the current spreadsheet instead of d/ling a whole new one? Or at least save the gear that you have set from one version to the next... i don't like re-entering my gear over and over after each update...

This new spreadsheet (0.10) is recommending for me to use Vanir's right fist in my main hand over my vengeful sword and to keep my vengeful sword in my off hand.

So vanir fist main hand, vengeful sword off hand...speced with 5 points in each sword and fist spec? Thats supposed to beat out both vengeful weapons?

Do remember to remove 4/5 Vile Poison if you're using a Fist/Sword spec!

It really depends on your gear, but for me Vengeful/Vengeful comes out at 2296.x vs 2293.x with Vanir's/Vengeful.
YMMV.

Would it be possible to add a selectable 200 AP buff to reflect the Warglaive Set Bonus against Demons? Currently I hack it in if needed, but that's just not very comfortable.

It's on the list. When I'll get to it is anyone's guess.

Would it be safe to assume that the new badge fist > talon of arashara for combat raid spec?

Given that you're posting in the thread for one of the spreadsheets I'd assume you know they exist, so my advice would be to plug it into the spreadsheet and see which is better.

With that said the fist appears to have better stats than the sword, both have very similar damage ranges, and the fist has a higher base dps. Given how close fist/sword and sword spec are I'd be willing to bet that the fist is an upgrade for you, but really check the spreadsheet that's what it's there for; to answer these kinds of questions.

Nope. not safe at all if you're a human. Check the spreadsheet to find out exactly how it shakes for your gear because results do vary.

I didnt realise the new one was ready.

Right (to both parts).

So did i miss something about the Hit Cap changing? Since i remember it being 363 but on the spreadsheet my hit is at 319 and is showing up as red? Just wondering if i missed something or if there is a reason for this.

You have improved faerie fire turned on which provides 3% to hit which isn't by default added to the main page. Dont remember off the top of my head what hit rating that equates to since im at school atm.

kk sweet that fixed it i dont even remember filling that in but its no big

Yeah, rather than converting Improved Faerie Fire and Heroic Presence into Hit Rating and adding it to your character, I have those two buffs decreasing the MH and OH miss chance. The reason for this was 1) that's the way those buffs were originally wired into the sheet, and 2) they provide flat percentage changes that do not change with changing character level, so it seemed safer and more accurate to keep them in that form by merely lowering one's % to miss. Thus, enabling either of these abilities will effectively lower your hit cap rather than adding more hit to your character.

I just want to contradict the last part of this statement - if you're using a viable alternative (namely you're gemming more for agility than hit), then you're better off assuming you'll have those buffs and gemming for that situation, than gemming assuming you won't, and overcapping when you do.

This of course, assumes that your gear is at the point where Agility is competitive with Hit point-for-point, and that you run the risk of overcapping with those buffs.

When does Agi becomes competitive with Hit? With high ArPen?

Where can I check the AEP values with my current set up in the spreadsheet? I can't find anything.

Currently, there's no particularly user-friendly place to find them - you need to unhide the DamageCalcs sheet, whereupon they can be read off row 11. However, to get an idea of agi vs hit, you can look at the gem recommendations; most people will have a mix of yellow and red sockets, which will thus give some recommendations of glinting and some of rigid or delicate, and based on the relative scores you can get a sense of the relative values.

Well, the EASIEST way is to just socket 1 8agi gem and another 8hit gem next to eachother and compare values, but if you want the 'real' way to do it, you need to unhide the DamageCalc sheet and look at row 11, which holds the EAP (note, these are not agility equivalent points, but effective attack power points).

As for when they become competitive, check with the spreadsheet for exacts, but I know for a fact once you're in late T5/early T6, the difference is getting somewhat minimal. That assumes Blessing of Kings, of course.


Edit: That point will also heavily depend on your build, as well.

Ahh, row 11, thank you. There were too many numbers I couldn't spot the info I wanted :p

I tested it on Twins today, and I am not impressed. Considering 300 ap over 10 sec once a minute, thats 50 ap in average on 3000-3500 raid ap, which is about 1.5% increased damage, vs. Deadly poison which is about 5% of your raid damage. So all in all, and not totally accurate, its a 3-3.5% loss in damage vs. Deadly Poison.