Thanks for the response. To address your point, I think what happens is that people sometimes get confused and use my general purpose PVE chart instead of my Maximum DPS chart when comparing gear for raid DPS. Like the person in Post #1484 who thought Brooch of Deftness was ranked as one of the best raiding necks, but was in fact looking at the wrong chart. I think you'll find that the rankings in my Maximum DPS Chart fall pretty much in line with the results you'll get from the more precise Gear/DPS spreadsheets around here. There are always going to be minor inconsistencies, but I've been constantly tweaking my chart to correct those issues.

I'm well aware of this effect, and believe me, it goes both ways. I frequently get email from people asking why certain items on my charts are ranked differently than they are on the Gear/DPS spreadsheets. However, I don't have the luxury of responding with "I'm right and they're wrong" because that usually won't be the case. So, inevitably I have to take the extra time to figure out where my figures went astray so that I can correct the problem.

So many people seem to get confused by the distinction between "PVE Armor Chart" and "Max DPS Chart" that it might be worth simply changing your nomenclature a bit. I think "Raid DPS Chart" might clear up the confusion. Then again, maybe it is best to let people who refuse to read get a bunch of stam gear. =P

You make a fair point. And my respect for you increases with your obvious humility. I want to add, altho we are straying into the tangential, that your site for me got me interested enough in the theorycrafting to find places like EJ and learn even more.

There are people arguing (in the hemo thread) about the accuracy of the modeled value of Dirty Deeds in the spreadsheet. Some are arguing that:

1) due to talents of other classes that improve damage when a mob is below a certain health level, that the boss does not spend as much time below 35% as above it, so 35% * DD talent points * 10% overvalues the impact of dirty deeds

Others are arguing that:

2) due to deaths of other raid members that take place during any boss fight, mobs spend more than 35% of their time alive at under 35% health and therefore dirty deeds is undervalued by the spreadsheet

See posts on topic beginning here. My guild data is from SSC/the Eye. If anyone has data from BT/Hyjal they can analyze, that would be helpful.

The question is for each boss, on average, what percentage of the fight time does the boss spend above and below 35% health?

I expect that the current formula is a reasonable average estimate, but I see why it might be above or below (though arguments for both sides might actually result is an average of 35%).

Well, my first answer would be "Dirty Deeds isn't modeled by this spreadsheet at all yet".

Now, in terms of adding it: I was planning to add it assuming 35% uptime. It's probably not perfectly accurate, but it should be kept in mind that the damage output of the raid doesn't honestly increase by *that* much after 35%. I mean, 1/3 of your DPS classes do an extra, what, 10% damage? 20%? I mean, it goes faster, to be sure, but it's not like the last 35% only takes 20% of the time. Regardless of which effect you favor, I'm willing to bet that the time spent below 35% is probably between 30% and 40% of the total kill time; hence 35% is probably a pretty good estimate, so, barring significant evidence to the contrary, that's probably what I'll go with.

Ariashley, my point in the other thread is that while (1) is absolutely true (2) may well be true and regardless, math is not the most important thing here. For Aldriana's model, a mathematically plug in of 35% (or 30, or 40) is fine because it's a solid approximately. A rogue that rejects or choose that particular talent solely based on the few dps it shows he or she outputting one way or the other is very likely undervaluing said talent.

Only two pages back, you would have found the answer to your question.

yah, reading a thread that takes over 40 pages takes some time my friend

edit: i'm somewhere in the 20s at the moment, i'm reading between calls <.<;

Two pages back this question was answered, as it has been numerous times before. The author is working on updating the spreadsheet and undoubtedly will notify the rogue community when it is ready for public consumption. Your best bet is to check the first post of this thread for an edit update. There was a modification made by another user of this spreadsheet to include some, but not all, of the new to 2.3 items (this version was never certified by Aldriana, the author of the spreadsheet, so use at your own risk). You'll need to dig around a bit to locate the post, as I don't have it handy.

Edit: Slow poster. >_<

hrmm...perhaps i'll take a look into the point systems and try to help out with the update process...usefulness is bliss afterall

And as an update from the developer:

I'm getting pretty close, although there are still a few things to add - of 26 updates originally on my to-do list, 6 have been classified as "UI tweaks that I'm not going to mess with", 14 have been implemented (including the largest couple of things), and 6 remain. However, due to external factors (buying a new car, Christmas shopping, helping my parents remodel their place, etc.) I haven't had any time to work on it today, and don't expect to have a lot of time for it tomorrow either. So we're looking at either middle of next week or next weekend.

Thanks for the update, take your time and if there is anything we can do to help let us know.

This is pretty old news but it dawned on me I'd never heard confirmation on whether or not the relentless earthstorm diamond got fixed. Has it? I just sorta assumed it did.

As a side note, I'd hate to be you aldriana. I just tried hacking in the proc set bonus for warglaives, after copying and adjusting formulas for 30 mins or some such I was still pulling up 0 values then realized that I guess the sheet doesn't associate the set bonus with the equipped weapons so it doesn't know the proc is active. I could sorta see how you were doing it with other sets (though the formulas were a complete mystery other than the column numbers/letters) but figuring out how to apply that to warglaive...screw it. I'll wait till you release new version and thank jesus you exist :-) I think I remember you saying the nerfed proc was worth about 200 ap. I just added 200 passive AP to the MH and it showed about 75 dps increase, no idea if thats remotely accurate or not :-p

Long story short, thanks again for what you do.

Yes, it has.

The quick hack approximation I'd use for Warglaives would be to estimate that it procs about once a minute and gives 450 haste rating for 10 seconds; hence, it should be roughly equivalent to 1/6 * 450 = 75 haste rating. So I'd use that for your ballpark estimate until the next version.

And thanks for the kind words of appreciation. And yes, you just ran into one of the major issues with this sheet: it's a pain to maintain. And I've thought some days that I really should fix that. Unfortunately, fixing it is *even* *more* work, so for now it will have to do.

Greetings:

I am wearing three or four pieces of gear that do not have entries in the sheet and would like to add them. How can I go about doing this? I am not an excel wizard although I did get as far as finding out that VLOOKUP is referencing a table array hidden somewhere in one of these workbooks but I'm not finding it? Any input would be greatly appreciated.

In the future, you might want to try the search tool for the thread - enjoy.

Interesting, I did search on a couple phrases including add gear but I did not see that post. I must have missed it. Thanks for the help, I'm off to figure out how to unhide it.

Explained here: http://elitistjerks.com/460045-post540.html

Although in Office 2007, it works a bit differently; just go down the sheet tabs at bottom, right-click, and select "unhide".

To unhide the other workbook pages in the spreadsheet, go to Format -> Sheet -> Unhide... -> and select which page to display. These un-hid workbooks will display on the tabs at the bottom of the spreadsheet. If you want/need to add weapons and trinkets, for example, you will need to unhide and modify those workbooks separately from the Armor workbook.

Groutagg was correct, the search didn't return any results - so I'm adding a post that hopefully will.

To add gear to the sheet, you need to UNHIDE the Armor or Weapon sheet (ranged weapons are on the armor sheet). If you're new to this sort of thing, honestly, don't bother with adding trinkets.

After unhiding the sheet, right click on the ROW and copy the entire row of an item that is in the same category, then INSERT the copied cells into the MIDDLE of the section for that type of item (bracers, leggings, etc). Then change the name/stats of the item to match whatever you're trying to insert, and change the drop location.

Hope that helps everyone out.


Adding Ald's link as well: http://elitistjerks.com/460045-post540.html

Oh, one extra caveat about adding weapons: pretty much any weapon that has a proc (Hearstriker, BS maces, Rod of the Sun King, etc.) will have a different formula than the other items in it's block; hence, to get correct answers, you generally want to copy a weapon that doesn't have a proc, or things could start going south for you in a hurry.

This is more or less why trinkets are a pain to add as well; they almost all have procs. However, if you wanted to add something really simple like, say, Berserker's Call, it can be done the same way... just make sure to copy another trinket with no procs (I recommend Bloodlust Brooch).