Well, it's not quite fair to say that they model *everything*, per se, but they certainly model such basic things as the increased energy regen from hit due to combat potency. The shortcomings of the sheet tend to be more subtle - for instance, proc synergies and the like.

Does the sim sheet account for more factors than the other sheets, seeing as its an actual simulation, or does is have the same (limited) shortcomings?

Honestly, I've never really looked at it. But unless I quite miss my guess, it probably has a body of shortcomings all of it's own. Coming up with a perfect approximation of what happens is impossible, so all spreadsheets tend to miss things; how one approaches the problem and what assumptions one makes dictate what you can and can't model. For instance, Vulajin's sheet models a number of things that mine doesn't, and mine models a number of things that his doesn't. I imagine it's the same with Mavanas's - it probably has simplifying assumptions and mistakes and whatever like every other tool available. The nature and magnitude of these approximations can be debated, of course, but fundamentally I'd say the fairest way to characterize it is that it, like all tools, has its own unique collection of flaws.

I was thinking of the discussion about AOE a page earlier. Would 18/52/1 be ideal for max damage and utility in a heavy aoe environment?

For something like yogg 0-lights yes it would be since RS is useless for phase 3 but for those certain bosses with heavy aoe environment (freya +3 , mimiron hard and thorim) 15/51/5 or 18/51/2(1 point out of endurance and precision) would be the best for max damage and interrupts since you would still need good single target DPS for the boss itself.

There's a mistake in the stats of the Godbane Signet.
It is 42 Critical Strike rating not Hit rating as said in the spreadsheet.

Twirling Blades & Perilous Bite didn't get updated after they got buffed.

For my own purposes/spreadsheet, I was able to chart the lowest dps loss for accommodating Throwing Spec by shifting two points from Aggression (Combat Swords) rather than any combination of points from Lethality and/or Precision.

Doesn't seem to be the case in the Combat spreadsheet. I just checked it and it clearly has the 42 crit under the correct column.

It's incorrect on the Mutilate spreadsheet. Making the correction makes it either second or third in slot, depending on other gear choices for me.

Rune-Etched Nightblade has alot of "base score" in your sheet Aldriana. It ranks better then Bladetwister which strikes me as odd. It is 25 dps less, less Aep (279 for Bladetwister and 252 for Rune-Etched Balde I think), has no socket and is the same speed. What is it that puts the Rune-Etched Nightblade ahead?

Couple of points.

One, offhand swords will always have a high score if you have sword spec - much as MH swords will always have a low score. Basically, more of the benefit of sword spec comes from offhand attacks than mainhand attacks, hence your OH sword contributes relatively more damage - hence, a higher score. This is why hybrid specs were good for a while - because you could use the increased OH damage of a sword with the increased MH damage of a mace or fist. The problem being that doing this at the moment requires dropping too many dps talents to get both specs. This is a big reason why Rune-Edged Nightblade stacks up well to Bladetwister, assuming you have both specs - it's because you don't have both specs, so the comparison isn't really meaningful. For the same reason, if you have both specs, the best MH swords will still be far behind MH fists of equal ilvl.

The second point is that "base score" is not a meaningful number unto itself. Notably, it doesn't include any gems - hence, an unsocketed weapon (like Rune Edged Nightblade) will score higher in "Base Score" than a socketed one (such as Void Sabre or Blade Twister), even if the items are of otherwise equal quality. The more relevant number for assessing items is column BK, Item Value.

Been theorycrafting all morning. Well for almost 2 hours. At the bottoms of the mutilate spreadsheet on the first sheet (Gear) I was trying to compare the stats it showed on the total with the stats on my guy. I don't know if anyone noticed, but a lot of the gears data is wrong. Especially on the tier 8 gear. My total agility on my guy is 1585(187 +1398), but on the spreadsheet its +1374. I rechecked all the gear that I am wearing, and they all have the same stats. Checked sockets too. I don't know, but are the stats of the total on the spreadsheet suppose match the exact stats on your character unbuffed?

Edit:
I figured it out. Man, I feel like a noob. I see now that some of the socket bonuses are added directly with the gear. Sigh, Gotta go change everything now again.
ASKLHA:FY:OAN :KNASD"P AK - E Rage

Was looking at aldriana's armory and was just messing around wondering how much crit I could stack by swapping pieces out without regemming. I noticed on my rating buster that my Furious Gladiator's Shoulders gives me +7 agility, +13 AP, +0.19% Crit over my T7.5 Shoulders. I tried plugging these numbers into the spreadsheet, and it actually lowered my dps from 7012.2 down to 6992.8. Does the 43 haste rating from T7.5 really make a that much of a difference in dps? My weapon speed is only lowered by .2 seconds. I didn't think haste was such a factoring number for mutilate, being our weapons speed are already low compared to combat. That or am I plugging the numbers in wrong?

More haste means more poison applications, and that's a big part of Mutilate's damage if I'm not mistaken.

Interesting build, taking advantage of the rogues ability to use poisons is smart; like Auturgist said haste is important for this build. I'll have to try this build, it seems like it will produce a lot of DPS in raids... anyone else agree?

Interesting. Based on Aldriana's spreadsheet, I fiddled with a few talent points and also messed around on the talent calculator. I have the masticator but I've been using it with golem shard sticker as OH due to the lack of a faster dagger in my possession. Armoury: The World of Warcraft Armory

I do however have rune-etched nightblade and thought I'd see if I could put it to use given its 1.4 speed. This build: Talent Calculator - World of Warcraft
seemed to give slightly better dps on the spreadsheet than my cookie-cutter original. I'd be a little wary of trying it as it is unusual but nevertheless interesting. Copying your build as it happens resulted in a dps loss with my gear.

It doesn't really surprise me that you can pull out better dps with a mixed weapon spec, given a superior sword offhand and superior fist main hand.

It is quite clear that given sword and dagger off hands of similar quality (void sabre/bootblade for example) or fist weapon/sword mainhands of similar quality(Insanities Grip/Seralis) , the benefit from being able to take lethality with a single weapon spec, is supirior to the advantage of being able to use a sword offhand and fist main hand.


However, because CQC has an advantage in your main hand and swords have an advantage in the offhand, in the case of a weaker offhand dagger or weaker main hand sword (Shard Sticker, Malice) It may be possible to get a dps gain from using a mixed weapon spec.

The deciding factor will come down to if the advantage from using a good fist main hand good sword offhand outweighs the loss of lethality or other minor dps increase talent. I would assume that the spreadsheet is as good a way to check this as any, and if the spreadsheet gives you better dps with a hybrid spec and the Masticator/Rune Etched Nightblade, it is probably accurate.

I was attempting to add in some of the Emblem of Triumph gear myself and I've got them working for the most part, it seems the only thing I can't get to work for any of them is the Rank column always displays #N/A and it seems the cause of that is because it doesn't like any of the Zone Filtering. The Base Scores and everything else work fine and that's what concerns the status of an upgrade, does the Rank just concern the item showing up on the Equipment sheet because that seems to be another issue, the item not showing up. I suppose as long as the Base Score is calculated right that's enough, I just want to make sure that number isn't being skewed because of the Rank value not showing up.

The usual foolproof way is to insert a line in between to other lines for that itemslot, copy the data from one line to another, then replace the actual stats.

If your ranges are not accurate (which inserting in the middle avoids), you'll have to fix them manually. If you're using Excel 2007, Formulas -> Name Manager allows you to fix the ranges. Boots, BootScores, Helm, HelmScores, etc are what you're looking for.

Unless you want to expand the Zone Filtering functionality, simply copy all of the information from the line above (make sure the formula cell references update correctly), and type "Other" in the zone column. If you have "Other" checked on the Equipment tab, this should let your new items show up. I figured out you had to do this when I tried dragging the cell contents down and Excel iterated "Ulduar 25" to "Ulduar 26" and the zone filter blew up.

As Maestro suggested, the easiest way is to create a new line somewhere between two existing items, drag or copy all of the formulas and contents, then update the item stats (make sure to delete the Item Set flags) and zone information (set to Other).

Its not too hard to update to add a new zone filter.

1. Create a new line(s) for "coliseum" or whatever you want to use on the Equipment Tab.
2. There is a hidden formula in the grey area just to the right of the zone filter box, copy and paste it down next to all the new zone filters you created.
3. Highlight the entire new area including the hidden formula in grey and call it something like "ZoneFilter1" (you do this in the Name Box) unless you have a newer excel where you can edit the ranges of the existing ZoneFilter then do that and skip step 4.
4. In the Gear tab in Column BS find and replace "ZoneFilter" with "ZoneFilter1" and it should work as long as your new gear zone in column BR matches your new filters.


Edit: Make sure you "sort ascending" all items in your new ZoneFilter1 area otherwise the vlookup tables wont work

Yeah I just don't understand what is going on. I copied existing items and just replaced stats for the new ones I added, made sure to change any socket colors and weapon speed and what not, all the cell numbers match up, but it just does not like anything I put for Zone Filtering. If i change it to Other and go and say No for Other on the Equipment sheet, it works fine (although the item itself still doesn't show up in the Equipment sheet) but if I change Other to Yes, it doesn't want to calculate the Rank cell. But, as long as the DPS value of the item is calculated fine without the Rank column, I don't really mind it, I'll fiddle with it some more later but at least I can see the DPS value of the item correctly.

EDIT: Bah, i'll just leave it to the professionals. I can change values and copy paste things all day I don't know what the actual problem is and not well versed in Excel at all, I don't think tinkering can solve this. Hell i even tried to add the craftable bracers to mpie's sheet and I copied Fluxing Energy Coils, renamed it, changed the AGI and it broke all calculations. THIS GEAR IS TOO UBER FOR SPREADSHEETS >.<

I'll share my edited version of the spreadsheet with new gem info, gear, and some other goodies for all who want to save some time.

I am not 100% versed with trinkets and T9 EAP calculation so all new tinkets and T9 gear are omitted.


Combat_3.2_v3.zip


Note:
I have 5/5 talents selected for CQC/Sword/Mace spec just to evaluate weapons in all categories. Obviously you need to select MH and OH from one category in practice however it's helpful in theory to compare all items at the same time. If you don't like this, you can change it!


EDIT: Added crafted chest & wrists!

Combat_3.2_v4.zip