With full BiS gear I've managed get 10074 DPS, however, with the new ArP nerf this is reduced to 9671 DPS.
After quickly swapping the ArP gems out for Str, this comes back as 9587 DPS with an ArP trinket equiped (MR). Not such a huge difference as previously mentioned. I'll have another play with the gear set-up later to see if I can tweak it a bit.
There is an error on names of bracers (horde side), where it says "Armbands of Nether Lord" must say "Armplates of Nether Lord", same with heroic version of those bracers. Solution is very simple if you subst the two lines for:
IF($C$7="Alliance";"Armguards of the Nether Lord (Heroic)";"Armplates of the Nether Lord (Heroic)")
IF($C$7="Alliance";"Armguards of the Nether Lord";"Armplates of the Nether Lord")
respectively (take care of number of cell when you subst, it depends on your gear, it's 7 for me but can change for you)
Takes the "125% of previous effectiveness" buff and turns it into 110%...any thoughts on how to tweak the spreadsheet to judge the impact?
The cap for ArP will go from 1231 to 1399, which isn't that big of an increase. I believe the absolute best will still be using Death's Verdict / Comet's Trail and gem for ArP in every socket after exp/hit cap.
Upon upgrading my chest and thusly loosing my t8 2pc bonus, the spreadsheet doesn't show a dps loss....how much dps loss is the t8 2pc bonus and can that be incorporated into the spreadsheet. Thanks.
From my own logs, the buff from this set bonus is up between 15 and 30 % of the time. That's 150 haste rating when it's up. If you average this haste rating it would give you between 22 to 45 haste rating overall throughout the fight... which, is really not that great for either dps specs.
I really wouldn't worry about breaking the T8 2pc bonus if you have any piece that's really better to balance out your stats.
The gem slot orde ron Legplates of Ruination is wrong. It is currently listed as R, Y, B. It's actually Y,R,B. This creates a discrepency when loading from armory because the gems end up in the wrong slot so it doesn't recognize your gem bonus.
Check the order on Legplates of Ruination to Y,R,B.