First off, thanks again to Mavanas for putting so much effort into this.

For those that might be wondering, Mavanas has changed the formula to account for socket bonus's, so do not worry about deleting the extra "1's" from the various activate socket bonus's for the same piece of gear.

On a side note, I assume that what is supposed to happen when you unactivate an item and activate another, the activated item's row will then be highlighted in yellow and the unactivated item goes to white. This was happening for the wpn's, but this wasn't the case for other the other items. I also noted that for the weapons, the change of color was conditional on deleting the "1" before activating another item with a "1". I assume you have some sort of conditional formatting going on? I've never messed with that unfortunately so i'm not sure how to offer a suggestion to fix. I would be curious to know how you did that regardless.
Thanks,

Could you elaborate a bit more?
Yes, it's conditional formating, purely depending on a 1 in the 'Active' cell. It doesn't check for multiple selections nor does it deactivate an old item when selecting a new one.

Thank you for the new version !

I just have a little promblem: with a mutilate spec' i have 40 expertise more that i should have. i checked every part but i don't find where the problem can come from.

EDIT: sorry for my bad english

Expertise Food is on by default

Sp00n has basically explained the conditional formatting part. As long as you select an item, the entire row will be highlighted. I think it was his suggestion a couple pages ago.

As for socket bonuses, you do not need to deselect them in the "Activate Bonus" column when you change items. They will only contribute to your stats if the item is selected. Activating the bonus does change the dps value of the item, if you are using that score to select items. Note that these scores are based on ilvl264 BiS gear, and can only be used as a starting point to selecting items. Ultimately, you would still need to run the simulation to be sure which item is better.

So I've dug (sic?) a bit deeper regarding that matter, and it seems that this is a bug in Excel 2007 when using compatibility mode only. It works fine in Excel 2003.

More precisely, the bug manifests as conditonal formatting not immediately applying to the affected cells. When you scroll down and back up so that the specific cells are off screen, or you select the specific cells, the conditional formatting kicks in and updates/refreshes the screen correctly.

Copying the whole content of the gear sheet to a new sheet within the same document removes the bug (of course this doesn't update the references in the formulae of the sheet, so this is no quick fix). Creating a new sheet in the same document and applying conditional formatting to some new arbitrary data also doesn't show the buggy behaviour.
Saving the spreadsheet when opened in Excel 2007 and reopening doesn't work, neither does saving it in the new .xlsm format.


There might be a chance that copying the gear sheet to a new tab, adapting ALL formulae and saving it with Office 2007 as an .xls may solve the problem, but that would be a lot of work (I guess).
I have not found any solution so far, only a few posts regarding that matter.

Conditional formatting - cell format not immediately updated - Excel Help Forum
Microsoft Excel Conditional formatting in 2007
Excel 2007 Conditional formatting not refreshing as it did in 2003 - microsoft.public.excel.misc | Google Groups

And possibly related to
Odd refresh behavior after you specify a conditional format in Excel

Would it be safe to use the EP value on DPS output to compare two separate pieces of gear?
ex. Find a baseline dps. Then run 1000 iterations with new piece A. Then run 1000 iterations with new piece B. And the one with the higher EP would be the better piece assuming 1.96xSE < .35?

An example I can think of is if both are very close in terms of dps output.
Tell me if I'm completely wrong here.

If you need to compare two pieces of gear, you do not need EP values. Run the simsheet with piece A and save the dps as baseline. Then run the simsheet with piece B. The piece that gave you higher dps is the better piece. To know if that result is statistically significant, look at the p-value below the DPS values. If that value is less that 10%, you can be 90% sure that the result was not obtained just through RNG. If it's less than 5%, then you are 95% sure and so forth.

Hm. I think reworking / adding information on how the p-value works would be quite helpful. I still have problems to work out what it exactly means everytime I haven't used the sheet for quite some time.
Maybe add exactly that what you have explained above.

Mavanas,

I noticed your edit regarding heartpierce and now how you've claimed that it is the best ilvl 264 dagger. I've read the data posts about how the proc works and how it can proc off your poisons now. I'd just like to know if you have done simulations on the matter and would it outperform the rib spreader?

I noticed in your 3.3c sheet that it is not currently supporting the new findings to how heartpierce works.

I added an explanation about statistical significance to the front page. I also added a Q&A section for adding new gear and selecting gear using the simsheet, and I encourage you to read that section to use the simsheet to its fullest.

Also I am releasing an updated version of 3.3c, which has support for custom DPS Value of Gear: that's when you run your own EP values and then use them to calculate the DPS value of each gear piece in the simsheet's Gear Tab (more about that in the Q&A section on the front page of this thread). Also I have updated Heartpierce proc mechanics based on the recent findings. It is in fact the BiS dagger if our understanding of its proc mechanics is accurate. It is better than Rib Spreader by some 120 dps, and it is better than Blood Sipper Heroic by about 90 dps. Using Heartpierce can change your EP stats. It benefits from some amounts of white hit and haste up to a point, but if you get too much haste, the uptime of Invigoration should start dropping due buff resets. It does not mean haste becomes worthless, it's just a warning that you need to run the simsheet to find out how haste scores relative to other stats when using the Heartpierce.

As always your suggestions regarding the interface of the spreadsheet, its ease-of-use, its flexibility and usefullness are encouraged. Also if you find some strange behavior or bugs, let me know as well. Just a warning: strange behavior does not include your comparisons of the DPS value that comes out from the simsheet to what you observe in a raid. There are a ton of posts by now that explain the limitations of inferences based on your raid dps, so I am not going to go over them again.

The new sheet is located here.

P.S. Those that were having a problem with randbetween function translation, see if my new implementation continues to cause #NAME problems in the Combat tab.

Mavanas,

Thanks for all your hard work as I have been a fan of your spreadsheet and simulations. I've done some simulations/tests regarding vigor + heartpierce and it appears that I am experiencing a 95-99% confidence rate that it is increasing my DPS by about ~50 or so (I'm using your default settings that came with the sheet download and have only manipulated my gear, professions, vigor talent, and removed heroism / potion of speed (since they don't have a constant uptime)). The interesting point is that when I try the same test with Twin spike Heroic 258, I am seeing only a small ~10 DPS increase with only about 50% confidence.

It'sa bug. I forgot to delete the old implementation. You are probably looking at the energy regen column. The implementation that takes into account tick timer reset is in column DR and it adds to your energy. However, that also means that in the last implementation, energy from HP was double counted. When I fix the error, HP scores below same ilvl daggers by about 140-150 dps. I have updated the uploaded file, so you will need to redownload it from the front page.

Yeah, I'm getting it as about a 130 DPS loss from the heroic 258 dagger (0.0% Pvalue) as well. That sort of jives with my gut instinct that the 258 heroic weapons would be nearly as good as the 264 weapons with stats, and that even with pretty high uptime HP won't hold up.

Indeed Twin Spike Heroic appears to be far superior to HP normal.

As for Vigor, first make sure you are doing it right. Whenever you change total energy, you need to change "Do not use if energy is above (HaT only)" setting in the DPS rules. It's there to prevent energy capping in GCD-starved situations, but in this case, you need to change it from 100 to your total energy (110 if you have vigor, 120 if you have it glyphed too). I am seeing the following regarding Vigor:
- dps with Heartpierce increases by 70 when you have glyphed Vigor
- dps with Twin Spike increases by 30 when you have glyphed Vigor
The effect if Vigor on dps is higher for Heartpierce because you have higher energy regen and therefore higher chance to get energy capped. Vigor+glyph reduces the chance to get energy capped. This may also indicate that reducing or eliminating energy pooling may be beneficial to your dps. Check "Do not use if energy is below (energy pooling)" setting for envenom. By default it is set to 60.

P.S. I was right about energy pooling. Consider this table:
As you can see, the effect of vigor is seriously diminished when you do not have energy pooling. Also energy pooling is definitely limiting the effectiveness of Heartpierce. Also energy pooling is still effective for Heartpierce, but only when you have more energy. It's probably worth also trying an intermediate energy pooling case, say 50 energy.

I noticed on the table that the dps with h twin spike is the same for energy pooling with vigor+glyph as it is for no energy pooling but vigor+glyph. Is this because pooling energy is less significant because your not getting the extra energy regen from heartpierce?

I downloaded the current 3.3c but when trying to use it is giving me an error that it cant access /corrupted or is located on a server that is not responding or ect. I've never ran into this before is it on my end or yours?
-Thanks again for the #1 sheet i.m.o Mavanas!

Could be neither end. Most likely it is a corrupted download case, try downloading again please. If the outcome is the same, I will create a filefront mirror.

Tryed downloading agin (5 times) to be total and still the same outcome--May be corrupted, located on a server that is not responding, or readonly.

Try this mirror.

That one works perfect thanks alot!

I find the following sets to be best in slot:

Mutilate DPS: 13682

Profession: JC/Engineering (bombs and hyperspeed on cooldown)

DPS Strat: classic 4+, ToTT used on cooldown, no energy pooling, 51/18/2 spec

Gear:
Lungbreaker Heroic (DP)
Heartpierce Heroic (IP)
Gluth's Fetching Knife Heroic
Sanctified Shadowblade Helmet Heroic
Sindragosa's Cruel Claw Heroic
Sanctified Shadowblade Pauldrons Heroic
Shadowvault Slayer's Cloak Heroic
Ikfirus's Sack of Wonder Heroic
Toskk's Maximized Wristguards Heroic
Sanctified Shadowblade Gauntlets Heroic
Astrylian's Sutured Cinch Heroic
Sanctified Shadowblade Legplates Heroic
Frostbitten Fur Boots Heroic
Ashen Band of Endless Vengeance
Band of the Bone Colossus Heroic
Tiny Abomination in a Jar Heroic
Deathbringer's Will Heroic


Gems and enchants:
Double berserking, 1 prismatic in the chest, 34 haste x 3, 20 haste x 11, 20 ap/10 haste x 6 - basically gemming ap/haste in red slots and haste elsewhere. Haste food.


Combat DPS: 13480

Profession: JC/Engineering (bombs and hyperspeed on cooldown)

DPS Strat: 5pt eviscerate, ToTT used on cooldown, 60 energy pooling

Gear:
Bloodvenom Blade Heroic
Scourgeborne Waraxe Heroic
Steakthrower Heroic
Sanctified Shadowblade Helmet Heroic
Sindragosa's Cruel Claw Heroic
Sanctified Shadowblade Pauldrons Heroic
Vereesa's Dexterity
Sanctified Shadowblade Breastplate Heroic
Toskk's Maximized Wristguards Heroic
Aldriana's Gloves of Secrecy Heroic
Astrylian's Sutured Cinch Heroic
Sanctified Shadowblade Legplates Heroic
Frostbitten Fur Boots Heroic
Ashen Band of Endless Vengeance
Frostbrood Sapphire Ring Heroic
Tiny Abomination in a Jar Heroic
Deathbringer's Will Heroic


Gems and enchants:
Double berserking, 1 prismatic in the belt, 34 Arpen x 3, 10hit/10exp x 2, 20ap/10hit x 3, 20 Arpen x 12 - gemming hit and accuracy gems almost up to hard crit cap and expertise cap. The rest are armor pen gems, which end up being just below hard cap. Arpen food.

Thus by the time armor pen gains it's full value near the hard cap, combat almost catches up mutilate in single target dps.