Its not really helpful at all to have all three weapon specs selected in the spreadsheet. Having them all active is going to give you erroneous data based on information that will never be accurate.

I agree however having all three selected doesn't actually change the calculated DPS as long as you dont screw up and start wearing a Mace/Sword, Sword/Dagger, etc. As long as you equip weapons of the same spec it will be accurate. That being said, if you aren't sure what you are doing this is a great point and please just only have 1 spec up at a time. I just have them all active so I can quickly evaluate if switching to sword spec or CQC is better based on item drops without having to click the button 100 times.

I've been trying to modify the sheets, but with little success. I think it may be more of an issue with Open Office then anything else. I can understand if you are busy right now Ald, but do you think you will be able to update with the new gear, and get Axes added? Thanks a bunch!

When you do, could you also leave the sheets in which you have item / gem data stored unlocked? It could be something to do with the fact that I use Openoffice, but if they were open like in Mpiemont's sheet I'd greatly appreciate it. It will allow me to add any new pieces of gear and test raw values like I can do with your Mutilate Spreadsheet.

It's probably harder to do now that you've already formatted your Combat sheet as it is, but if somehow the new one could be modeled just like your Mutilate spreadsheet is that would be perfect for me. Yes I realize the sheet isn't being formatted for me, but if you were thinking of changing it in that way, you have my thumbs up! Keeping it as is is also just as good, so long as there's an update.

On a sidenote: Regarding T9, has anyone extensively tested and seen results as to how high the proc chance of the 2 pc bonus is? How does it compare to dropping 4 pc t8.5? (Obviously depends on the pieces under discussion and which off pieces are being used) If the set bonus (with its procrate) were to be isolated, how does it fare?

The sheet breaks whenever I select a mainhand weapon with a gemsocket. Thanks for investing time into updating the sheet!

Re-adding gems to item that broke the sheet fixes it.

Thank everyone for their comments!

I have made an updated combat spreadsheet due to a significant number of new items that have been discovered! I also incorporated a lot of the comments and feedback, thanks

I still do not have T9 or trinkets in here as I don't have experience with modeling them. I hope to update the Mutilate spreadsheet soon as all I have to do is copy and paste the new gear/gem tables.

Additions:
1. Changed spec to 1 spec active instead of "all active" to avoid confusion with people incorrectly using it.
2. Added new epic gems
3. The sword with gems that "broke" the spreadsheet shouldn't do it anymore. To fix similar problems simply reselect the gem and it should fix itself.
4. Added all newly discovered loot and crafted wrist/chest
5. Updated Twirling Blades with correct stats
6. Added a section where you manually enter your old DPS and it calculates +/- % change
7. Added Coliseum filters


Many thanks to the creator's of the original spreadsheet and theory-crafters! I hope you can use my gear additions to make it easier to update the new "official" spreadsheet when it comes out instead of manually re-entering everything from scratch.


Combat_3.2_v5.zip

sarGz:

I just added the new gear and changed the gem properties (especially Prismatic from R/Y/B to R mostly) which may affect DPS output due to the properties change and socket bonuses. I didn't modify anything in the calc section (I'm too scared too).

I loaded up the original before I made the edits and I get the same results you are getting now (you confusing it with remorse or have the wrong spec equipped in the sheet?):
Void Sabre > Rune-Etched Nightblade
Serilas > Furious

The Serilas looks like it has a lot more bang for the buck in terms of stats when compared to Furious, but that's just me looking at it.



EDIT: I looked at your sheet and you did a lot of editing on your own, I have no idea what is right or wrong. Only way for you to check is to download the original one on page 1 and compare your results to see if you changed something accidentally. Also 20agi gems are unique equipped, only 1 bro

With my shizzle added: Combat.xls (I edited gems value, but not the names)

I don't understand the calculations when the suggested upgrades makes my calculated DPS go down. What am I missing?

(Oh and ignore the trinket, put on a normal one - I probably failed when I tried to add it myself)

Seralis is better, no question about it, for rogues at least the arena weapons are largely sub par for dps, maybe if you are at the expertise cap without Seralis the PvP weapon could be better.

Ah you are right! I didn't realize they removed that requirement too, ridiculously nice. I'll try to keep on it as I see more things, I'm sure given enough time the new official version will come out with T9 procs and new trinkets