Less Rupture uptime does not mean less dps. With a normal level of Crit, Sinister Strike scales better with AP than Rupture does. Additionally, Armor Pen increases Sinister Strike value but does not affect Rupture. A looser cycle will give you more Sinister Strikes and less Rupture uptime. The spreadsheet is telling you to use a looser cycle because your gear has reached the point where the extra Sinister Strikes are worth more than the higher Rupture uptime.

This has previously been discussed by Aldriana and others, if you want to read further about Rupture/Sinister Strike scaling and looser cycles.

Edit: I post too slowly--Aldriana beat me to it--but the link above points to the general vicinity of where this has been discussed previously.

I would consider myself mid+ sunwell so this sounds like it is what's happening. I currently didn't have AToL equipped, but equipping it shows a gain over SoC.

So I assume I'd just stick with 5s/5r and not vary at all? (Especially with sticking with AToL)


Thanks for the link.

But that would also give a definite need for at least one rogue in the raid group, always. Which isn't all that bad.

It would require one expose rogue on every fight, which isn't always optimal. Imagine if this was implemented and look at a fight such as kalecgos and the pain of having to keep up expose or else loosing the raid significant damage. Instead of being a little boost to raid dps, it would become a taxing pain in the butt.

I have another quick question, Is the Hemo raid DPS shown calculated into your personal Hemo DPS? or is the correct estimate of DPS your Total DPS + Hemo DPS?

"Total DPS" never includes "Hemo DPS" because the latter is an estimate made using myriad assumptions, while the former is calculated using your actual gear, talents, and ability usage. You can estimate your total raid DPS contribution by adding the two together.

Thanks, just wanted to confirm.

Well, the purpose of having the spreadsheet available is to help make such choices. However, it's definitely true that certain factors are not incorporated at this time. For example, Rupture, Eviscerate, and Envenom all have increased AP coefficients, and these things aren't implemented in 0.1.0. Other things change as you level, including the base damage of those abilities, and also your ranks of poisons. Plus, as it is, the spreadsheet is not exactly accurate for short fights like those you'll have while leveling.

This spreadsheet will really come back into its own once we know all the level 80 ranks of abilities, all the fully implemented details of talents, and what level 80 dungeon/raid itemization looks like. Until then, it's largely there for us to make educated guesses about the future.

Obviously "WAT ITEM DO I USE???" threads are frowned upon, but I think there is some conflicting information here on EJ regarding the benefits of meta gems.

I use the S3 helm (gear can be seen to the left, obviously), hoping that some day my fellow raiders will manage to stay focused for 5 minutes so we can kill Archimonde and I can DKP dump on a T6 helm. However, until that day I'm weighing my options. The TTT states that "The [Relentless Earthstorm Diamond] is an extremely powerful gem which provides DPS value enough to boost helmets with meta gems well above same-tier helmets without meta gems". Looking at Aldriana's spreadsheet, this seems to be the case. However, it is vastly different in your spreadsheet, Vulajin.

With Aldriana's sheet:
Grimgrin Faceguard (1x Glinting Pyrestone, 2x Rigid Lionseye): 1817.87 DPS
Vengeful Gladiator (Relentless Earthstorm, 1x Glinting Pyrestone): 1833.24 DPS

With Vulajin's sheet:
Grimgrin: 1892.88 DPS
Vengeful: 1868.61 DPS

This is obviously with similar buffs/debuffs. I used the ones that I would most likely have in my raid, out of convenience. MotW (5/5), Faerie Fire (0/3), Mangle, Hunter's Mark (5/5), Blessing of Might (0/5), Kings, Misery (5/5), Grace of Air, Strength of Earth (2/2), Unleashed Rage, Recklessness, Battle Shout (5/5 CP, no Solarian trinket), Sunder Armor, Relentless Assault Flask, Spicy Hot Talbuk, Haste Potions, and Windfury being twisted. 2 Bloodlusts used, 3 drummers with Drums of Battle.

So which is correct? Should I keep holding out for my T6 helm or is it better to just gem up my Grimgrin?

And on a side note: How does your spreadsheet model the SSO necklace, Vulajin? Does it check your shoulder enchant and apply the correct proc accordingly?

And on another side note...
Nerf.

Make sure that you have the 2-Blue gem requirement for the Relentless Earthstorm Diamond. I don't know if Vulajin's sheet checks that (almost certainly does, knowing him) but this is probably the reason.

I plugged in my gear as it is ingame for both sheets. There were 2 purple gems in each sheet, and I didn't change them out for yellows/reds when using Grimgrin (which would indicate that Grimgrin is even better by Vulajin's math).

There's a really silly logic bug where, if you select a meta gem other than "None", it will provide its full effects even if the helm you're using has no meta socket. It'll be fixed in 0.3.1.

I just plugged in all of my gear into your spreadsheet to test it out in comparison to the other sheets, largely because I wanted to see how my DPS came out in your sheet using AToL. Anyways as I was messing around with fields I changed the boss type from Demon to Humanoid and back again. This resulted in a change of about 9 DPS. Now that really confuses me, I have both glaives and somehow I think that 200 AP would result in a slightly larger DPS change than that.

Is there a set bonus field in the sheet that I'm missing or something else?

Against demons you lose the benefit of Murder, which is 2% critical strike damage and 2% total damage. Apparently, for you, that adds up to be nearly as much as the Warglaive AP bonus.

(edit - typoed what Murder did)

Interesting, I didn't think Murder would be worth nearly as much as the proc. Thanks though.

Version 0.3.1 is available via the link in the first post. Changes:

- Fixed a bug where a meta gem other than "None" would provide its full effects even if there was no meta socket in the equipped helm.
- Improved the accuracy of the agility-to-crit conversion.

The exact changes were:

Cell R30 on "Gear" sheet now reads (new portion bolded): =AND(S29>=S30,T29>=T30,U29>=U30,A30="Meta")
Cell I32 on "Talents & Settings" sheet now reads: 40
Cell I33 on "Talents & Settings" sheet now reads: -0.295

That's all, feel free to just patch these changes into your 0.3.0 spreadsheet if you don't want to have to download the new one and re-enter all your settings.

Hey!
Thanks for this spreadsheet Vulajin, it's pretty damn good. Unfortunately I seem to have run into some sort of bugg with mace spec and while browsing through this thread I cant find anyone else with the same problem. Maybe I accidentaly altered or changed something I shouldn't have?

I have a mace equipped in mainhand and a sword in offhand. When altering talent points in mace specialization from 0 to 5 points it doesnt affect the dps at all. 5% increased critical strike dmg with the mace should alter the dps. Maybe not as much as fist spec but still.

That's a fascinating, and hilarious, omission. I'll fix it in 0.3.2.

I have the Merciless swords equipped and the expertise rating doesn't seem to change when I switch from Human to any other race. It should be 26, since I have the shard and 2 pt. talents, but it shows as 21.

Perhaps I'm misunderstanding, but as far as I can tell the sheet works fine in this regard (I've been using the BC sheet, but the LK one doesn't look different with regard to expertise, nor should it). Switching from Human to any other race should result in a 5 expertise loss on MH/OH equipped with a sword/mace; this appears to be implemented correctly. If I set it to Human with two swords, 10 exp from talents, and no expertise on gear but Shard (worth 11 expertise), I get 26 expertise on both hands, and changing only the race will drop that to 21. Looks fine to me.

The expertise bonus for humans does not apply to the display at the top of the 'DPS Calc' sheets, nor the main DPS/stat headers, it is calculated separately for each type of attack, since some use the MH and others the OH, and you could have two different weapon types equipped.

I'm getting the extra 180 health from the Mark of The Wild buff wether its on, off, improved or not, or at least, I have 180 health more than i actually do which I can't seem to fix no matter how many times i re-check what I've entered into the sheet. Turning Mark of The Wild on and off has no effect on my health so I thought it would be this.

I didn't notice this until I'd filled out my gear (in a copy)... but then I made a fresh copy and checked straight away and it's there from the start.

The 'White DPS' (Gear:C2 and D2) is coming out as 'Err:529', which I'm guessing in turn causes a load of other errors (Gear D:3-7 are '#DIV/0!'), and makes the total DPS (Gear C:8) come out as 0.00. Not very helpful.

The actual contents of Gear:C2 are "=mhdps+ohdps+wfadjdps", which looks correct. If that's referring to DPS B39:41, then know that both B39 and B40 there are also 'Err:529'.

That error seems to be what's described here. Given it appears to be an OoO bug I don't know if you can work around it.