The Roguecraft Spreadsheet - Page 101

Ticia · 03/17/09, 1:03 PM

Looking at all this data you have collected sp00n, the what I am seeing is that the percentage chance to proc Berzerking and Mongoose is calculated by the game using your *base* weapon speed, and not the hasted speed.

As an example, look at the observed PPM for Berzerking in This post. You had very little haste gear on, and you observed a "PPM with Hasted Speed" of 1.0128, which is outside of the confidence intervals calculated by your most recent data (assuming PPM is off of Hasted Speed).

However, all of the data you have collected falls cleanly into the "PPM with Base Speed" confidence intervals, so that would seem to indicate that the PPM calculations for Berzerking at least (and most likely Mongoose, as it appears to be the same) should be done using the Base Weapon speed, and not the Hasted Speed.

I'm still not sure how this relates to DMM's initial findings about different PPM values from different training dummies, although you don't seem to be seeing that effect, all of your data is consistent across both the 83 Heroic Dummy and the 60 Dummy.

I'm not sure if it is needed, but it might be useful to have a similar sized set of proc data on the same level 60 dummy but with very little haste gear on, just to really verify that the PPM is calculated off of base speed and not hasted speed.

Mavanas · 03/17/09, 2:02 PM

Despite the spread of the 95% confidence intervals, you seem to reject with 95% confidence a hypothesis that PPM of berserking is 1.0.

BTW I forgot to tell you in our private correspondence that I matched pretty closely your calculation of the confidence intervals using standard normal approximation of binomial distribution. I think I was within one proc of your interval.

Dontmindme · 03/17/09, 11:25 PM

I'm going to chalk the initial findings up to luck. What it appears to me looking at all the data is that the answer is 1 PPM and not haste adjusted. Same seems to apply to Mongoose as well.

Now, I know that Mongoose was tested pretty thoroughly back in BC and definitely used to be haste affected. If I were to guess, Blizzard changed the formula from 1.2 haste affected to 1 PPM non-haste affected and that the same formula is being used by Mongoose and Berserking (and probably Executioner now as well, although this has not been tested).

Amante · 03/18/09, 3:38 PM

Quick question:

I'm seeing DPS gains of about 50 DPS with IP/IP if I replace Ruthlessness with Turn The Tables. Is this accurate? Even if I remove it from a IP/DP build and replace it with NOTHING, it's only a loss of 15 DPS.

Is Ruthlessness that inconsequential these days? I remember when it was flat out required, but those were much different days.

My gear may or may not have something to do with it - mainly the two Webbed Death, as I haven't gotten a Sinister Revenge as of yet.

Thoughts?

Infuria · 03/18/09, 3:42 PM

Originally Posted by Amante

Quick question:

I'm seeing DPS gains of about 50 DPS with IP/IP if I replace Ruthlessness with Turn The Tables. Is this accurate? Even if I remove it from a IP/DP build and replace it with NOTHING, it's only a loss of 15 DPS.

Is Ruthlessness that inconsequential these days? I remember when it was flat out required, but those were much different days.

My gear may or may not have something to do with it - mainly the two Webbed Death, as I haven't gotten a Sinister Revenge as of yet.

Thoughts?

The spreadsheet has never given a real value to ruthlessness. In a perfect cycle, you don't need it. I'm not about to drop it, though. (Unless 3.1 builds absolutely require it.)

• Aldriana · 03/18/09, 3:54 PM

Um, wrong. Ruthlessness has a very significant and important DPS impact, and it is in no way optional; the fact that it shows up that way in some models is more due to flaws in the model than a reflection of the actual value of the talent.

In particular: Ruthlessness enables the ability to do 1-Mutilate 4pt finishers, which in many situations prove to be a DPS increase. There may exist situations where they don't make sense, and determining when this occurs is something the spreadsheets are bad at which is why unusual behavior is sometimes observed. But for traditional IDN cycles, Ruthlessness typically gives DPS gains on the order of 20-30 DPS per point. Less than, say, DW Spec? Certainly. But far from negligible.

Amante · 03/18/09, 4:12 PM

Good to know. I remember how vital it was back in the day so I had a hard time believing it would be on the magnitude of 10 DPS for all three points these days.

How is it with IP/IP Eviscerate? Still better than Annoying Noise Dance (AKA Turn The Tables), I assume?

wykedtron · 03/18/09, 4:20 PM

Originally Posted by Amante

Good to know. I remember how vital it was back in the day so I had a hard time believing it would be on the magnitude of 10 DPS for all three points these days.

How is it with IP/IP Eviscerate? Still better than Annoying Noise Dance (AKA Turn The Tables), I assume?

If im not mistaken you drop ruthlessness and add improved evis for IP/IP build while keeping TtT. No way around the noise currently unless you went with MP. I think the reasoning behind dropping ruthlessness was to avoid situations of having 4CP after 1 mut and thus potentially wasting 2CP for 5PT evis finishers. Make sense?

• Aldriana · 03/18/09, 5:05 PM

IIV with Ruthlessness could still do 4 point finishers, same as IDN; it's simply that the extra finishers you gain from 4pt finishers are proportionately less valuable, as Eviscerate is a lower damage finisher than Envenom; hence, adapting your cycle in this way tends to make less sense. As to whether it's better to drop TtT or Ruthlessness, I don't currently have a model of that I'm fully happy with; as such, I don't have a solid answer for that.

Gungne · 03/19/09, 6:21 AM

I have read most of this thread, but I cannot see anyone having asked this:

Is there a way to import my char from the armory into the spreadsheet without typing in the values manually?

koaschten · 03/19/09, 7:55 AM

Read the first post perhaps, significant part quoted here for you.

Originally Posted by Vulajin

How do I use it? Basically, the Roguecraft Spreadsheet was never really designed with any users other than me in mind. So, basically the UI is generally accessible but not especially user-friendly. Frankly, I don't think I will change that too much, because I'm far more concerned with the actual accuracy and quality of calculations than I am with the UI. I have no intention to ever include features like Armory Import, or saving talent builds, or things of that ilk. There are also currently no readouts for EP values or anything of that sort. It's very minimal: there is a talent selection sheet with some general settings, a gear selection sheet that should appear familiar to most users of other spreadsheets, a buff selection sheet, and a cooldown settings sheet. All of the calculation sheets are hidden by default; you can find the iterative calculations on "DPS Calc 1," "DPS Calc 2," and "DPS Calc 3," and the corresponding numbered sheets for "Cycles" and "Cooldowns" as well. The final calculations are on "DPS" and "Cycles." All of the gear data is contained in the respectively-named sheets.

Be careful with the sheet, as there is not really any error-checking and it is fragile. Set up your build on the "Talents" sheet, then select a combo point builder (even if you take the Mutilate or Hemorrhage talent, you must specify Mutilate or Hemorrhage as your CP builder; conversely, you can specify one of those as your CP builder even if you don't have the talent for it), a cycle type, and the number of CP to use on each of your finishers. If you wish to pool energy prior to a particular finisher, you can specify that in the column to the right of the cell indicating the number of CP for that finisher. Sorry, but the sheet is not equipped to recommend cycles or gear for you. If you're unsure what cycle to use, you should read Rogue: PvE DPS for some ideas, or just play around until you find something that achieves high DPS. If you wish to take advantage of the more accurate cooldown-stacking modeling without having to specify every single use of your various cooldowns, then set a fight duration longer than 0, and simply change all the yellow-highlighted settings on the "Cooldowns" sheet to FALSE.

kujararanch · 03/19/09, 9:07 PM

Is the expertise somewhat deviated on the spreadsheet or am I using an older version.
My Exp is at 6.5 but however when I use the sheet I get a constant 6.71. I've gone over everything several times but cannot find where that .21 comes from.

falconindy · 03/19/09, 9:36 PM

Originally Posted by kujararanch

Is the expertise somewhat deviated on the spreadsheet or am I using an older version.
My Exp is at 6.5 but however when I use the sheet I get a constant 6.71. I've gone over everything several times but cannot find where that .21 comes from.

Expertise in game has always been rounded down to the nearest .25%. 6.01% expertise is the same effective expertise as 6.24%.

• Vulajin · 03/19/09, 9:43 PM

Originally Posted by falconindy

Expertise in game has always been rounded down to the nearest .25%. 6.01% expertise is the same effective expertise as 6.24%.

No, it is not. It was discovered around January, I think, that expertise does not actually round down. That's just the character sheet having a mind of its own.

Onodrim · 03/20/09, 4:15 AM

Originally Posted by falconindy

Expertise in game has always been rounded down to the nearest .25%. 6.01% expertise is the same effective expertise as 6.24%.

Should you be interested, some calculations and conclusions regarding whether expertise truncates or not can be found here and in the posts that follow.