• Vulajin

T4 2pc is really not that big. You gain a lot more of a benefit just from having the improved stats on the T5 helm than you do from having that set bonus.

 

rj

That is counter to what previous versions of the spreadsheet have computed though. I would have upgraded my T4 helm a long time ago with a T5 helm if the older spreadsheets were showing that, but they were not.

For example version 5a of the spreadsheet said going from T4 helm to T5 was a 5DPS downgrade because I lose the T4 bonus. Same holds true for other older versions of the spreadsheet, except the latest one...

 

• Vulajin

Then get a second opinion. There's more than one spreadsheet out there, if you're ever in doubt about the results provided by one, use the other to keep it honest.

 

todemax

It is probably due to a lack of cut cycles, and are worked on to be fixed by dmm, left and myself.

 

Hrya

My RogueDPS_2_4_0_5 says :

with boots: Sunrage Treads (4agi/4hit) - total DPS = 841,86
with boots: Nyn'jah's Tabi Boots (4agi/6sta , 4agi/4hit) - total DPS = 830,43

it doesnt make sense to me :

------------------ Sunrage Treads ---------- Nyn'jah's Tabi Boots
AGI : ------------ 32 -------------------------- 37
AP (no agi): ---- 58 -------------------------- 60
HIT: ------------- 4 --------------------------- 29 !!!
------------------- ignore 126 armor

So that 126 armor is better than 24 hit + 5 agi + 2 ap ???

 

Cashin

I'm seeing some weird interactions with Warp Spring Coil and Ashtongue Talisman of Lethality.

Equipping both of those at the same time, or using upgrade on the other slot with one equipped, shows an impossible DPS gain, like around 275 to 300 dps.

Any ideas about what's going on? I'm going to look into it a bit more myself.

 

Left

No, that doesn't make much sense. Did you miss an enchant somewhere? If not, it's probably a bug.

EDIT: This response was in response to Hyra's question.

 

Cashin

It has something to do with armor penetration. If I leave the WSC on, but reduce it's armor penetration to zero, the values seem to be more rational.

It is extra attacks that is causing the increase, and if I follow it back, the Evi/Rupt per sec. field (Q16) that is inflated significantly. I am seeing a value of 7.127 right now which is kind of absurd.

When I unequip the WSC (or reduce it's armor) I get a more reasonable value of 0.042 (one eviscerate/rupture every 23.8 seconds.)

Edit: it has something to do with armor penetration going over 3885 and Ashtongue Talisman. Actually it has nothing to do with those specific values. I started punching in increasing armor pen with WSC and DST and eventually there was a jump. Error in field V18 on sheet Buffed Cycles.

 

drumbum

Are you sure you weren't above the hit cap?

 

• Feist-Mok

In that vein, check buffs for Imp. Faerie Fire, it tends to be what I miss when I run into hitcap issues.

 

Hrya

hmmm with equiped Nyn'jah's Tabi Boots my unbuffed hit rating = 341 in char log.
I belived we need near 363 - have it with food buff.
So anyway equiping Sunrage Treads boots in that situation should drop my hit rating
25 points below hit cap as i belive.

And so RogueDPS Sheet shows me 420 hit rating 341 + 79(precision).

 

Dontmindme

Hmm...I'm unable to replicate that error. I take it you are Combat (as your armory). On the Buffed Cycles sheet, is S15 or V15 or V16 overinflated when that occurs? Also, what cycle is it suggesting?

 

Sneakiest

It shouldn't be. Generally ArP is valued around 0.14+ (depending on your own values of course) per point in AEP terms, given it's 7 points equivalence for 1 rating that's ~18 rating. ArP is generally valued lower than hit (of course concerning your own AEP values) and even then it's 18 vs 30 total stat ratings, I doubt it's what it says.

Be sure to check metagem requirements. If they're on and you lost a gem needed for your metagem (I'm assuming you're using 12 agility, 3% bonus crit damage), they'll garble the DPS values. My bet is you needed that blue gem.

EDIT: I just skimmed through your gear and you currentely have two blue gems (on an aside, why not shifting nightseye though? Crit is poorly valued for rogues), one of them meaning they're your boots. So yeah, it's really likely to be metagem requirements garbling it up and telling you you need to place a blue gem elsewhere to get proper data - aka getting your meta gem to still work.

EDIT 2: Scratch that, you don't even have a metagem. Durr. Double check your gear then, I guess.

 

Dontmindme

Try 2.4.0.6...
I imported your gear from Armory...only boots upgrade I'm showing is Slayer's.

Also, 841.86 and 830.43 are awfully low. It's showing you around 1400 buffed DPS with default selections. Unless the 800's are "Unbuffed", then that might explain some of the hit devaluation. It's also possible you encountered a fixed bug.

 

Xanthi

the spreadsheet's recommended buffed cycle for me is 3s/5r. however, when i turn on the "blood frenzy" buff, it changes to a 4s/5r snd cut. i don't see how blood frenzy affects my cp generation, is this a bug?

 

Aura

Hey kinda new to the DPS spreadsheet, i was just wondering on the other possiblities i can do using the spreadsheet. So far what i only do is fix my talents, my equips, gems and enchants, add some buffs then check the dps with other items etc. Does the spreadsheet have other features that i can use to up my dps?

 

Jakani

It's probably because blood frenzy benefits your Sinister Strikes more than your rupture, since SS can crit and rupture cannot. What this means then, is that it's better for you to spend a greater share of your energy on SS instead of finishers.

 

Xanthi

would that be suggesting that i don't have 100% snd uptime with 3s/5r? i always thought cycles account for 100% snd uptime so it shouldn't affect my white damage if i went 3s or 4s.

 

kindath

Ergh, refresh before posting.

 

drumbum

Not necessarily. It calculates the damage you would do with 3s/5r and 4s/5r (and many many other cycles) independently, then selects the one that did the most damage. It doesn't automatically disqualify a cycle just because SND uptime is below 100%. Although I can't say this is happening specifically in your case, it may be possible for a cycle to have a 98% SND uptime (for example) and still be superior DPS.

 

Ikilu

Could you please add Haste, ArP, and Expertise to the Pawn Import String please. I'd do it myself but then I'd have to do it every single time an update came out. I'm extremely grateful to you for all you've done with this though, it's a work of art.

All my best comments during raids come from a book called, "How to be Witty at Parties"

 

Achillion

Adding my gear to the latest version of the spreadsheet shows more unbuffed crit than I really have. I tried adding my gear/talents manually and importing from armory. Any thoughts?

If you wanna try import: Achillion - Doomhammer EU.

Normal crit: 26.31%
Spreadsheet shows: 28.58%

 

todemax

Probably due to mongoose crit averaged out, or due to the same thing with trinkets.

 

Cashin

Yes, it switches to 4s/5e when the error happens.

To duplicate, from the default gear set, I did the following: Add 3/3 Imp Evisc, remove 3/5 Vile Poisons, set cell Q76 on Gear Buffs to 2088. DPS should be 2429.29. With Q76 set to 2087, DPS is 2083.27.

Under those conditions, V18 is evaluating to 1.0. TRUE in Excel. V15 is equal to 7.5288 (Evisc per second, kind of off.)

 

Dontmindme

Ok, I got it. In the formula in V18, delete the last ">0" in both the Buffed and Unbuffed Cycle sheets and it is corrected. Thanks for following this through. What was happening is by adding enough armor penetration and with imp. Evis, you finally created conditions where Eviscerate cycles were superior to Rupture and the Evis damage formula was bugged under these conditions.