Yeah I assumed that the reason was something along that lines. Interesting nontheless to see in which slots it suggests putting the Tears though. Currently it seems to be that the bonus needs to be at least 6agi to tip the scale from arp/agi to the tear in a blue slot, which matches quite well with the ep. Nothing to wonder there.

Just updated to released 1.3-1 Sheet and I dropped from 8440ish to <8000, same gear, same settings/options. Either I am retarded or something has changed substantially.

I've been making a few modifications to my copy of the sheet for a few versions now to more easily keep track of the Dragon's Eyes and Nightmare Tears. I don't consider it a matter of being or not being smart enough to know when to use what gems, but being able to quickly glance at your tally of each can save a lot of frustration when you're trying to mix and match gear looking for optimal sets.

Download Combat_1.3 v2003.xls

This is a copy of the Combat 1.3 release with my changes made. While some of the changes are fairly complicated, I've also found they've been very portable from version to version. If you're not very handy with Excel (more specifically, if you don't understand SUMIFs and VLookups), I wouldn't fool with these, but if you know enough to understand the changes, they're amazingly handy.

Auto-toggle of Dragon's Eye Recommendation:
This will make the Equipment sheet recommend the optimal Dragon's Eye as long as you don't already have 3 (of any type) equipped.

1. Insert an option on the Settings sheet that denotes if you're a Jewelcrafter (Settings, A14:C14). This is probably a bit silly, because you wouldn't make these changes if you weren't one.
   
2. Add a count of Dragon's Eyes currently in use using a SUMIF on the EP column of equipped items in the Equipment sheet (Gems, T8:T11).
   
3. Replace the '0's in the Recommendable column with a check that you're not using more than 3 in total (Gems, U8:U11). I added an AND conditional to check the Jewelcrafter option on the Settings tab.

Auto-toggle of Nightmare Tear Recommendation:
This will make the Equipment sheet recommend a Nightmare Tear if you don't have one equipped. This is slightly complicated because the Nightmare Tear has the same EP value as Powerful Stats to Chest.

• Where the "Recommendable?" flag is for the Nightmare Tear (Gems, U24), use a a SUMIF on the EP column of equipped items in the Equipment Sheet using the EP value of the Nightmare Tear (Gems, C24). This will be equal to the Nightmare Tear EP value if you DON'T have one equipped (due to +10 Stats to chest) and twice the Nightmare Tear EP if you DO have one equipped.

Make Equipment Tab recommend the optimal blue socket in which to put a Nightmare Tear:
This is the most complicated change to make, but it will save you a lot of time looking up which piece has the best socket bonus when you're swapping gear around frequently.

1. All the way to the right on the Gear tab (Gear, BU2:BU215), add a format that mutliplies the Equipped column (Col. E) x Socket Bonus Value (Col. BC) x Whether or not the piece has a blue socket (Col. V). This will give the socket bonus of equipped gear with a blue socket. NOTE: As of right now, none of the gear in the sheet has more than 1 blue socket; if one is added in the future, it'll break this.
2. Add a formula in the next column (Gear, BV2:BV215) that ranks the values in the previous one.
3. Add a third column Labeled "Use This" (Gear BW2:BW215) that puts a 1 IF the Rank of that piece is 1 AND no piece above that was already labeled with a 1 (in the same column)
4. Modify the formula in the "Use Socket Bonus?" column (Col. BI) to also allow use IF there is a 1 in the "Use This" column (Col. BW).

Quick Reference Equipment Tab Additions:
If you made all the changes above, the "Nightmare Tear Used" and "Dragon's Eyes Used" cells should be populated correctly. NOTE: If you toggle on the "Use Agi Value for ArPen?" option, the Dragon's Eye field won't be able to tell the difference between Delicates and Fractureds, so you'll see exactly double what you have equipped.

• I don't feel like going through this part step by step, so just copy Rows 5:7 from my spreadsheet to yours and fix the formulas so they don't reference my workbook.

One final note is that I didn't include my spreadsheet here so that everyone can use that instead of Aldraina's version. I only posted it to give a visual aid to help understand the changes I made.

did you have the ArPen setting turned off so you had the pre-nerf values in your old sheet?

The only thing I can think of is the old version had HnS by default and the new version has CQC. Does your weapon spec
match the weapons you are using?

I'm trying to figure out why the 1.2 spreadsheet wants me to gem with Agi gems, but the 1.3 one wants me to use Attack Power.

Most likely because you are hitting the crit cap while procs are up, causing extra points in Agi to lose a bit of its value.

Must've been user error. *sigh* I re-downloaded it again and re-entered everything from scratch, and it's back to Agi now. Thanks for the reply though.

EDIT: Figured out what it was...I had been tinkering with the buffs...if I remove blessing of kings, it wants me to use AP instead of Agi.

For some reason unknown to me, SUMIF didn't work correctly. It always pretended that there was only one +10 stats active with my gear, despite having both +10 stats to chest and one Nightmare Tear.
So I went with another route and used
as the formula.
It checks if 'Nightmare Tear' (cell B24 in Gems sheet) occurs zero times in the gear list, and if it does, it sets recommended to 1.
(I hope my translation of the formula from German to English was correct - Excel does localize the formulae)


I'm not 100% positive the fault isn't on my side, but this doesn't seem to always work correctly. After adding this, it advised me to socket red/orange/blue for [Leggings of the Broken Beast], which in fact would have been a loss of 16 DPS compared to 3x 20 ArPen.

However, I guess that is just due to the interaction of the different stats and the predicted AEP values, so there's not much one can do about it.
Just remember to not blindly follow the gem recommendations.


What I still really really miss in the sheet is a box for comparing an old DPS value against the current one. This was added by somebody I cannot remember anymore quite some time ago (so kudos to him/her), and I've added it to each new release so far.
It's just too useful to not have in my opinion.

The formulae are:
Where E1 is the DPS number to be compared against the current. I've just added these on the right side of the 'Estimated DPS' box.


I've uploaded the sheet as well so that you don't have to solely rely on my poor explanations:
http://sp00n.pytalhost.com/misc/Combat_1.3.sp00n.rar

When you met the requirements on the legs did you switch the Nightmare tear in your necklace to a Fractured Ruby? When I swapped your gems on the sheet you supplied I see a DPS loss of 1.
It's probably recommending meeting the legs and not the neck simply because the socket bonus itself is better than the socket bonus on the necklace (not factoring in the dps loss you would also incur going from the fractured to an orange.)

Thanks to both of you for the extra little addons, I had added similar lines to my own sheets but both of these examples work much nicer.

If you aren't familer with Excel an easy way to make sure you are copying the exact formula and not making a reference to the 'old' sheet is highlight the cell you want to copy, and at the top highlight and copy all the text in the formula bar, instead of highlighting the cell and copying it. The downside to this is you will only be able to copy one cell at a time instead of multiple cells, but will save you the time of editing the formula on each cell on the new sheet.

I forgot about this part. There is a =ROUND(...) around the EP values for enchants on the Equipment sheet. This makes the value for +10 Stats to Chest NOT be the same as the value for Nightmare Tear (since 31.61 is NOT equal to 31.60941638). I've been deleting the ROUND, but if you just leave it there, it actually takes a lot of the funky work-around out of the picture.

I'll take a look at the other stuff you mentioned and edit this. I like the use of COUNTIF, though. I hadn't used that formula before, so SUMIF / (value) just came naturally.

What is/are the extra step(s) to adding a new Zone Filter?

If I simply Right Click -> Insert -> shift cells down, either at the top or the bottom or the middle, I get N/A in all the upgrade columns. I've looked at the formula in the BS column of the Gear sheet, but i'm not entirely spreadsheet savvy so I don't know any immediate problem. I'm guessing it has something to do with the 3 in the formula (which represents the col_index_num) but changing that number doesn't seem to fix anything. That is, if the BS column has anything to do with the problem.

When adding zone filters, make sure to insert a row in column L as well as columns J and K of the Gear sheet, and fill the formula down accordingly. Then it should work.

EDIT: I got it to work. For some reason it only liked it when I inserted the new cells beneath Other, any other position whether it was farther down the middle of the list, at the top or the bottom, it didn't like it.

Another quick curiosity question...doesn't expertise lose a ton of value after the soft cap? I'm currently at 267 expertise rating, and the Mutilate 1.1 beta 2 sheet is still giving it a value of 1.9348, higher than everything but agi. Is there something I'm missing?

Yes, after you pass 26 expertise (214 rating), the value of expertise is generally zero since all you're trying to do is eliminate dodges. If you look at your sheet at start to gem expertise with your current expertise, you'll see your estimated dps drop. I believe the reason it says the value of expertise is 1.9348 is that it's indicating value of the expertise rating in your gear for your current set up as oppose to what another point of expertise rating would give you.

I'm extremely interested in the proposed ruptureless Mutilate cycle. I've found the 51/18/2 spec where you drop Opportunity, Blood Spatter, and 3 points in Relentless Attacks for 2/2 Fleet Footed and 3/3 Lightning Reflexes (but I might be missing something else). It seems your replaced glyph is replaced with something more utility-based like Tricks of the Trade (to increase someone else's dps while target switching on fights like Jaraxxus, etc.). The only other thing I'm missing is when to use the swapping macros and where. I'd assume you'd give deadly poison up on your OH and swap another comparable dagger with another poison, probably Instant. I also realize you're doing this to increase raid success instead of personal dps, though the loss isn't exceptionally high. Since I'm taking my first real dip into TOGC this week, I'd like to try out this spec and give it a shot. Any clarification/pointers would be great

As for weapon swapping, yes, you swap to a dagger (preferably a 2nd version of the one you're already using for DP) that has Instant Poison on it. You'll want to hit your weapon swap macro immediately after you Envenom, so that you don't hit the 1 sec GCD when swapping weapons. Then when DP has 3-4 seconds left, you'll want to swap back to your original setup. Ideally this swap will also occur after an Envenom, and then when Deadly is refreshed to 11 seconds, you swap again, after an Envenom.

Sorry, just a quick question and its probably stupid but where on your spread sheet can I find the n and m values?
I'm kinda new to spreed sheets so

Go to Format->Sheet->Unhide and select the Cycles sheet.

I've been under the impression that you would almost always make sure to swap to IP before the envenom, so that you aren't resetting the swing timer during the envenom buff. I was also under the impression that you would make sure to refresh DP before envenom, so you're able to have your IP off hand during the envenom buff.

Both ways work fine, the envenom during IP phase is probably better use of envenom buff in terms of dps, however having envenom up before the DP refresh is making DP less likely to fall off, thus reducing the variance of your dps. Some people dislike DP falling off despite the fact that overall dps might be higher.