Wikiupload is pretty good, from what I understand.

I noticed something when comparing cloaks.

On my buffed dps spreadsheet which is at 670dps, 1hit = 8.43~ agi (not able to view it from work), but when i swap Cloak on concentrated hatred (11str16agi1hit) for C'thun cloak(11str26agi) my dps goes up by a small amount.

Therefore 1hit must be better than 10agi, so something is wrong there, or am I missing something?

The 1 hit = X agi type comparisons are only valid at that specific point. Since they are effectively estimates of the tangent to the DPS curve at a given point, as you move to a new point, the tangent will change slightly, meaning that for balances right around equality (like in your example) you may not see expected results.

I think I understand what you mean, but it still confuses me.

The way I read it is that if I were to add 8.4agi worth of gear or 1hit worth of gear, it would have the same net effect on my overall dps, or very close to, since as you say its only valid at that specific point.

However in this example I am only taking away 10 agi and adding in 1hit, so how can it be so far out, mayb 0.1 either way, but 1.6 out, or am I still missing something?

The equivalency factor is a circular reference. Meaning, it's only true for any given (unique) set of gear. As soon as you change one item, technically the ratio will change. The point is, when you're comparing relatively equal items, you're going to get discrepencies like what you're seeing. In order to get a better feel for the trends per se, you should swap out say BF hood vs. BS hood or something.

Hope that clears it up a little. Regardless, I'd say don't get too hung up on the whole 1% hit = X agi equations.

Valar -

I noticed you added the 1% haste enchant (head/legs), but it doesn't seem to show up as a dps increase at all. How does it actually compare with the ZG enchant? As we get better gear does it scale more effectively?

Uh, Weapon Skill doesn't decrease the frequency of glancing blows, but rather decreases their severity. That is, at 300 skill glancing blows do 70% of white attack damage, and at 310 they do 100%.

Ahh, I was just misinformed then about how +skill affected glancing blows. I was under the impression that you glanced at a reduced rate. In that 310 glanced at 0% whereas 300 glanced at 40%. My mistake. Thanks for clearing that up. So it would appear that the 40% glance rate is inherent then. Gotcha.

It would be better if it reduced the glance rate, actually, because glancing blows can't crit.

Going through old threads I see what threw me off initially during the original glancing blows discussion. It was when the topic of glancing versus 61/62 mobs came up. Now I see that the glance rate is affected by the level of the mob, yet the glance amount is affected by weapon skill.

Well, Savefile is back up, so both 1.14 and RC3 are now hosted.

http://www.savefile.com/projects/299694

That would give a much-needed boost to the breastplate if true.

Those were old set bonuses that didn't pan out.

Damn, and here I was thinking I kept up on that stuff.

That's what EJ forums are for? I don't feel like post digging, but I know there is one about the T3 set bonuses being changed in here somewhere.

this is my first time checking up on something with a spreadsheet, so please correct me if im being stupid.

however i noticed that going from my current weapons harbinger(mh)/pugio, to a maexna's fang(mh)/harbinger is actually a 5% loss in buffed dps.

is the 1% crit on the pujio worth that much more over the higher dps/higher damage range of the maexnna's fang?

We havent gotten any death's stings (2 axes though) or belts from c'thun ever so i was considering taking a fang if it dropped, however now i'm really confused....

You must have had something that was not equal in the comparison...either buffs or set bonuses. Maexxana's Fang + Harbinger of Doom is unequivocally better than Harbinger + Pugio.

hrm
I am pretty sure i had current gear and wish list gear identical except for the weapons. I left that copy at the office so i will try to duplicate it here.

thanks for the quick response, i was seriously wondering what i was missing.


edit, i must have had something else wrong in my work copy as replicating it see's a dps increase with the fang. however it's really really small so i probably will let someone else take the fang if it drops tonight.

Yep, just make sure you get buffs too.

Changing M32 on the "Unbuffed DPS" and "Buffed DPS" page will fix that. Use:

[top]IF('Gear & Buffs'!A10

"Libram of Rapidity (+1% Haste)", 1.01, 1)*IF('Gear & Buffs'!A18 = "Libram of Rapidity (+1% Haste)", 1.01, 1)*IF('Gear & Buffs'!B57, 1.15, 1)*IF('Gear & Buffs'!A24 = "Minor Haste (+1% Haste)", 1.01, 1) * IF('Gear & Buffs'!B46, 1.01, 1)

The formula was looking at the wrong cells. The 1% haste effects work fine on the "Dream" sheets however. It looks like we'll have better enchants available by the time it catches up with the ZG enchant. The 1% to glove enchant caught up with 7 agi for example, but we also got the 15 agi enchant when it happened.

I'm using a hod/pugio too and abstaining from the fang. I hope it drops though. :ninja:

I just noticed that the 1.14 that's checked in has Windfury, SoE, and the Pally Buffs checked on the "Gear & Buffs" page, but not the Dream one. Oops. So that may be why you saw the discrepancy.