Sentinel Spreadsheet data validation (running tally)

[Underfyre]

Still perplexed by the Diamagnetic number. I mean, the math should be right. At max stacks it's only 40% -regen, reduced by 87%, bringing regen down to 96.94 from 102.26. Over, we'll call it a 350 second kill time, that will equate to another 33929 health to work down, versus having to work down 35791 health if it were 102.29. A whopping 1862 health difference. Assuming the Water/SR average of 230dps, that's another 8 seconds difference. But then you look at the averages from the runs with the different Interfaces and they're a total of 3 dps apart.

 

Let's just systematically take things apart, kind of easy if you don't mind ruining the sheet.

Removing the -res debuff from Reactive takes us from a base of 211.02 to 206.89 dps. The proc adds 4.13 dps (kind of, the proc does more damage on account of the debuff).

The proc on Degen takes it to 203.5 from having no proc at all, 188.98.

 

Diamag has no proc damage, it's just the base 188.98. It doesn't do anything else with regards to damage output, just lower the regen rate by a staggering 5.32/s. With the server ticks being, I think 15 is what Bopper said? that will shave off 79.8 per server tick. 1454.10 instead of 1533.90. It just isn't that much and you're doing 14 dps less than the other two. So why the eff is it keeping pace with them.

 

Grinding these numbers through the inverse time formula gives us...

 

Reactive: 30677.15 / (206.89 - 102.26) = 293.19s

Degen: 30677.15 / (203.50 - 102.26) = 303.01s

Diamag: 30677.15 / (188.98 - 102.26) = 353.75s

 

So just baseline Diamag is already taking 50 seconds longer. But that's not the whole picture, Reactive does more damage with the debuff, Degen also reduces total HP, and regen as a result, and Diamag is lowering regen. So let's pump those through again.

 

Reactive: 30677.15 / (211.02 - 102.26) = 282.06s

 

Degen: Couple steps

30677.15 - 1000 (kind of the average with 25% proc chance) = 29677.15

Regen = 29677.15 * 0.33% = 97.93

29677.15 / (203.5 - 97.93) = 281.11

 

Diamag: 30677.15 / (188.98 - 96.94) = 333.30

 

Diamag is 50 seconds behind still. Reactive and Degen have mostly merged as expected, but Diamag? Fuck your observed results. This is just baseline, we aren't even accounting for the part where there's lost time to keep buffs up, at 333/50 seconds Diamag should only be casting 1 more Aim than the other two, Hasten and Ageless would still be cast the same amount. I kind of feel like maybe I just had really lucky runs with Diamag, but who knows. The math thinks it's wrong.

[Underfyre]

So I took Electric/Bio for a roll on the Beta server to check out the numbers at work. Dropped the new pet numbers into the sheet, updated all the enhancement numbers, updated the Rotation to match what I'm using and set to work.

 

Since I have predicted kill times, I now kinda have a way to track how much Assault Hybrid will be up, but I'm pretty sure that will fall apart once you have a time longer than 240 (360 maybe?) seconds. I have run tests on Sentinels that do. I guess I'll cross that bridge when I get there.

 

Since it looks like that with Sparky at my side Degen Core is the highest output, that's what I went with.

 

Predicted kill time: 119.21

Observed kill time: 113, 116

 

I'll take it.

[Underfyre]

Pushed the old numbers through the newest iteration of my spreadsheet to see where we sit. The tests using Dark Blast are almost in lock-step with the sheet, but Psi and Water are varying by nearly 10%. Now, I planned on things to be off by a ways since tracking all the extraneous ability activations over a 300 second span starts to add up, and choosing not to track those times is going to have the sheet over estimating DPS, but I'm not sure I like 10% over.

 

I can't really use the old Electric numbers since the set changed so much with Shock and perma-Sparky.

 

Updated numbers on the original post.

Edited April 9, 2022 by underfyre