• Latito

Surprised this hasn't been mentioned but..

When you download a file off the internet in windows to a folder where a file with the same name already exists, it creates a new file with the same name, adding (2) to the end. Subsequent files would be (3), (4), etc.

You likely just downloaded the spreadsheet once, configured it, etc. Then downloaded it again and put in different buffs. In fact, you likely did not apply many raid buffs at all to the first once, since Hit generally scales quite well, whereas AP does not. This would be why Bloodlust Brooch scores well on your essentially unbuffed sheet, while WSC/TT score better with more appropriate levels of buffs. Hit and Agi are close enough to swing back and forth for gem recomendations, I would suspect that you left the first sheet on Weighted.

 

drumbum

That's not actually true. If you try to download a file with the same name, it'll just ask you if you want to overwrite it or select your own new filename. It won't just pick a filename for you.

In any case, he said the download site listed it as (2) as well, so he's probably getting it from some unofficial source.

 

Alexsiss

Depends on browser and OS. Firefox 3 beta auto appends(2) onto redowloaded files. Certain versions of linux also do the same

 

• Latito

Hrm, I hadn't noticed that he said the downloading site listed it as (2) as well. That certainly puzzles me. And like Alexsiss said, Firefox just appends a (2) to it. I haven't used IE in a long time so I suppose it might prompt you.. but hey, who uses IE still? :P

 

PartNinja

I'm using FireFox, it must have added the 2.

I put in all the same raid buffs as before. What should I have the value type set to? Right now its on weighted, I never set the original one to anything ( didnt know it existed ).

EDIT: playing with it offensive tells me + hits and weighted tells me +agis. Both are still saying WSC and TT are better than the broach ( which I assume is correct ? )

 

• Aldriana

Whether to set it on Offensive or Weighted is really a matter of your personal preference. I'm of the opinion that weighted is a better choice, but there is certainly a valid school of thought that says Offensive is the way to go. It's really whether you think there's value in defensive stats or not.

The point is, if you have a different setting for that, you can get different answers pretty easily, and in particular hit and agi tend to pass each other.

Fundamentally: I suspect you just have two versions of the same sheet filled out differently, but if you don't, feel free to post both versions somewhere and I'll tell you what the difference is.

 

• Aldriana

As a caveat to those of you who, like me, use both OpenOffice and Excel at various times: it would appear that there's an issue in the current sheet wherein if you open the sheet in OO and save it, you can no longer open it successfully in Excel. I'm not entirely sure what's causing this - something to do with the new buff page, I imagine, but past that I couldn't say. When I figure out what's wrong and how to fix it, I will let you know.

 

nelalas

What do you mean by successfully? I had to use OpenOffice in order to change the cell names from the old buffs sheet to the new one (specifically the B<attribute> names where <attribute>: {Agility, Strength, Hit, etc.}). I'm of the opinion that this was because the sheet is currently protected and the password to unlock the sheet would be known by Darlal. Anyway, that was the only time that I used OpenOffice in wiring in the new buffs page; after using OO, I remember getting a message that I could only open the sheet as Read Only in Excel but this message eventually stopped showing up. I don't know why it occurred or how it was fixed.

 

• Aldriana

As a clarification on the issue in question:

If one saves the sheet in OpenOffice (specifically OpenOffice 2.x has this problem, I can't swear as to whether it happens with older versions), and then attempts to open it in Excel 07, one gets an error message that there is "unreadable content in Rogue_gear_0_10.xls". It does give the option to recover, but recovering wipes out all formulas and formatting and thus makes the sheet utterly useless.

This problem doesn't occur with at least some earlier versions of Excel; nelalas and I did some experimentation last night and he doesn't have the same problem. It also appears that once it has been opened and saved with the older version of Excel, it can again be opened in Excel 07.

 

• Aldriana

Might of the Scourge, Shard of Contempt, SSO Exalted Neck, and Hyjal Fists (though not the set bonus) are in. Blackened Naaru Sliver is not.

Note that the proc effect of the neck is to some extent estimated as I didn't see any conclusive findings on a) the proc rate or b) the damage/crit rate/crit multiplier/etc. of the Scryer version. Speaking of the neck, I've added a new box to Advanced Settings to select whether you're Aldor or Scryer. At the moment this only matters for the neck, but eventually I might do something else with it.

There's also an assortment of bugfixes since the last beta, and a whole mess of features that have been added since the last official release - I've listed them out in detail in the various beta releases, so I'm not going to duplicate that information here.


Note: If you download this sheet, and something isn't working the way you expect, please read the FAQ section in the first post before posting a question about it. Many of the questions that get asked in this thread are already answered therein.

Version 0.10, 4/11/08: Download

 

◊ Shaker

Just out of curiousity, what assumptions did you model the neck procs off of?

Consistency. It's only a virtue if you're not a screwup.

 

• Aldriana

45 sec internal cooldown, 15% proc rate.

Aldor Proc: 200 AP for 10 sec
Scryer Proc: 350 Arcane Damage, crits using MH Crit Rate/Multipliers.

 

◊ Shaker

From the comments on the item [Shattered Sun Pendant of Might] (click to the page and check the comments section), it seems like it takes normal melee crit as crit rate, and the multiplier as well. The rogue's data seems somewhat questionable as the proc isn't supposed to do more than 367 damage (and he reports an -average- of 377), but the feral druid's data looks clean and has a WWS along with it.

Consistency. It's only a virtue if you're not a screwup.

 

• Aldriana

Well lets see, he has 76 procs in 3833 attacks; assuming he's actually attacking once per second, that means roughly 76 * 45 = 3420 attacks are disqualified by the cooldown, meaning he had 76 procs in 413 eligible attacks, which works out to a 18.4% proc rate... which is a bit over my estimate, but since Koaschten's test on PTR had it down around 13-14%, I'm still reasonably confident with 15% as a ballpark figure until we have more precise testing... particularly since that estimate based on the druid's data is pretty rough.

 

Kellaris

Thanks for the update Aldriana! Your hard work is very much appreciated.

I love the new Buff Menu. Much Improved.

 

• koaschten

Any need for [Righteous Weapon Coating] testing?

 

letha

Indeed it is, thanks for the new version!

 

hordminion

I wanted to suggest the addition of an item into the spreadsheet. [Marksman's Bow]

I have been using this weapon for a long time now and would like to be able to enter it into the spreadsheet. Pre 2.4 it was the second best rogue weapon ingame that i knew of(next to the steampistol of course).

Thank you.

Also the addition of the talent "Nerves of Steel" would be nice.

 

◊ Vulajin

I can't check the sheet right now to confirm, but I'm willing to bet the item you linked is represented in the form of [Veteran's Musket], which is identical for all intents and purposes.

The Nerves of Steel talent has no [quantifiable] DPS value, therefore there's not really any purpose to having it in the sheet.

 

drumbum

Yes, [Veteran's Musket] is in the spreadsheet.

 

hordminion

Thanks Vul. i didnt know that the musket was the same.

As for Nerves of Steel, the only reason i think it should be put in is for the same reason Lightning reflexes are in there(survivability factor). Unless LR has some other purpose i have yet to notice

Again thanks for clearing that up!

 

Grunge

Lightning Reflexes affect weighted total statvalues afaik.

Fans glory to the Gladiators,
Gods glory to the Heroes.

 

Tholofonos

I suspect that something wonky is going on with Blessing of Kings. When I have it enabled, suddenly my page turns from recommendations of Glinting and Rigid to Delicate and Glinting. An extra 10% agi is good, but there's no way it's *that* good.

 

Vodrin

edit; Acyrith pointed out the problem.

 

Feist-Mok

Why not? at a number of gear levels and sets, hit is basically = to agility. At that point, Kings is indeed enough to make it better to gem for agi.