The Roguecraft Spreadsheet - Page 47

MasterDinadan · 12/12/08, 3:32 AM

Originally Posted by Paxs

I'm on the spreadsheet and having a little trouble deciphering some of the "abbreviations" i.e. I'm trying all the different cycles and trying to figure out what i like the most but they say stuff like XeYr (CTTC). from what i read i think i can understand that X = CPs and e= envenom. r=rupture. What does CTTC stand for?
I assume SnD are never mentioned in these abbrev... b/c maybe its obvious?

Also what is AToL?

Any other useful information that someone wouldn't mind giving to help me understand this a little more. (especially the Cycle and DPS tabs on the spreadhseet ) will be appreciated

Thanks

or maybe i missed something, i've looked around but couldn't find anything. if someone would be me in the right direction if theres something up.

To elaborate on the cycles -- s means Slice and Dice, e means eviscerate or envenom, r means rupture, and a means expose armor. CttC cycles don't have an s, they assume that SnD has already been put up and will remain up indefinitely.

Understanding the DPS and Cycle tabs (especially the cycle tab!) are not essential in order to use the spreadsheet effectively. They mainly do all the intermediate calculations and provide a few pieces of specific information you might be curious about. The main number you care about is the Total DPS which you can see on all sheets - this number already takes into account everything on those DPS and Cycle sheets. There may be some interesting numbers on these sheets but if you don't understand them then don't worry about them and let the spreadsheet take care of it all.

Wytryszek · 12/12/08, 10:31 AM

First 2 small remarks about buff names in the sheet - Blood Poisoning is now Savage Combat, and Icy Touch should be replaced by Icy Talons (the second one confused me a little because I am not a DK expert). I think somebody even mentioned these mistakes before?

The main thing is I propose to put "somewhere" a statement that would address quite a few recurring questions about why real raid DPS numbers some people see are so different from the spreadsheet estimation. That is what I observed myself, and the answer is quite simple - it's the buffs. Or, more specifically, the missing buffs. If I disable all buffs, my DPS drops from 3750 to 1750. So the buffs increase the base DPS by more than 100%.
I know it may be obvious to most, but I bet this will be a real revelation to some. I think it is worth mentioning.

Edit: Icy TALONS... not Veins. Talking about mistakes, eh

Arindelest · 12/12/08, 11:21 AM

Originally Posted by Wytryszek

The main thing is I propose to put "somewhere" a statement that would address quite a few recurring questions about why real raid DPS numbers some people see are so different from the spreadsheet estimation. That is what I observed myself, and the answer is quite simple - it's the buffs. Or, more specifically, the missing buffs. If I disable all buffs, my DPS drops from 3750 to 1750. So the buffs increase the base DPS by more than 100%.
I know it may be obvious to most, but I bet this will be a real revelation to some. I think it is worth mentioning.

Or you could just disable the buffs you don't have, and get an accurate estimate for your scenario.

Vayyde · 12/12/08, 11:24 AM

This is particularly pertinent when using the training dummies. Don't plug in your gear to the spreadsheet, see 3500dps, then go test out rotations in Stormwind and be devastated when your recount shows a measly 1750 (unless of course you've managed to convince 24 of your friends to hangout in the SI:7 courtyard).

Like Wytryszek said, it's sort of common sense but I've already been asked in game a few times by rogues as to why their dps is so much lower then expected.

Yuntiff · 12/12/08, 3:03 PM

Can somebody explain why according to my spreadsheet (with the Glyph of Adrenaline Rush bug taken into account), Glyph of Blade Flurry comes out 5 dps higher than Glyph of Adrenaline Rush? How does getting an energy-free Blade Flurry every 2 minutes compete with losing half of the 2 minute Blade Flurry cooldown? (not to mention a minute off AR too...)

Demi9OD · 12/12/08, 3:51 PM

Originally Posted by Yuntiff

Can somebody explain why according to my spreadsheet (with the Glyph of Adrenaline Rush bug taken into account), Glyph of Blade Flurry comes out 5 dps higher than Glyph of Adrenaline Rush? How does getting an energy-free Blade Flurry every 2 minutes compete with losing half of the 2 minute Blade Flurry cooldown? (not to mention a minute off AR too...)

It's KSpree cooldown that is bugged to 1min, not Blade Flurry, and the spreadsheet does not incorporate this.

sp00n · 12/13/08, 6:33 AM

I updated the AEP addon to 1.2.

- Reverted AP value in EP calculation back to one (down from two). Makes more sense in my opinion and also fixes bug in the EP Pawn string, where AP was worth double the amount.
- Adapted the WoWHead-Link to the updated weigthing system on their site. Should work again correctly now.

As for the expertise problem, I fear there is not much one can do due to its "jumpy" behaviour.
However, you can now change the nextstat value in the sheet without breaking the calculation (was a fixed "divide by 20" formula before), so this might be a workaround. Just remember that decreasing the value might result in rounding/flooring errors in the sheet itself, and increasing might have effects on hit rating and expertise itself, if you then reach the cap.

Roguecraft.AEP.v1.2

vya · 12/13/08, 11:59 AM

Apologies if I've missed mention of this earlier in the thread, but I may have found a small glitch with glyphs in the LK 0.4.2 sheet.

With a 7/51/13 combat build and a 2s/5r cycle, switching from glyph of sinister strike to glyph of eviscerate (other glyphs are SnD and rupture) brings me from 4045.56 dps to 4049.08 dps.

Combo point builder is set to sinister strike, and envenom instead of eviscerate is set to false. No changes other than the glyphs. If I've left out anything pertinent please yell, and I'll edit to include whatever I left out, or apologize for my idiocy, depending.

henslaved · 12/13/08, 5:39 PM

How does the spreadsheet handle Turn the Tables?

I'm consistently ~100 dps below my spreadsheet, even when I have a flawless session (<1s on HfB for refresh etc.) and I'm wondering if this might be an explanation for that discrepancy.

New to the site, appreciate all the work you guys do. Keep it up.

• Vulajin · 12/13/08, 7:23 PM

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

- Increased crit reduction against mobs above player level by 0.6% per level plus 3% against bosses (total 4.8%), per recent findings.
- Reduced special attack base miss rate to 8% and Dual Wield base miss rate to 27%.
- Added Engineering to the list of professions.
- Glyph of Adrenaline Rush reduces your Killing Spree cooldown by 1 minute, to reflect an existing bug in the game.
- Nerubian Conquerer spelling corrected.
- Second ring slot socket bonus now properly activates.

Almehym · 12/13/08, 7:34 PM

Does the updated sheet reflect the mutilate 'bug' that gives 2x chances to proc the offhand poison?

And regarding that, does anyone have information about this actually being a bug/intended, or any confirmation on its functionality at all from Blizzard? I haven't seen any blue posts, but I may have missed them, since there have been a bunch lately.

• Vulajin · 12/13/08, 7:35 PM

If you had checked the version history, you'd see that that bug has been in since 0.4.2.

henslaved · 12/13/08, 8:02 PM

Vulajin I have all raid buffs set to FALSE. Does Turn the Tables apply?

If so, should I set talent points there to 0?

Trying to determine the discrepancy between my actual dps and spreadsheet dps on boss dummies.

Neto- · 12/13/08, 8:08 PM

Originally Posted by henslaved

Vulajin I have all raid buffs set to FALSE. Does Turn the Tables apply?

If so, should I set talent points there to 0?

Trying to determine the discrepancy between my actual dps and spreadsheet dps on boss dummies.

You can just set it to 0, you know. I believe it's counted as 100% uptime, so it would probably apply with all raid buffs off.

GreenMarine · 12/14/08, 6:05 AM

Originally Posted by Vayyde

This is particularly pertinent when using the training dummies. Don't plug in your gear to the spreadsheet, see 3500dps, then go test out rotations in Stormwind and be devastated when your recount shows a measly 1750 (unless of course you've managed to convince 24 of your friends to hangout in the SI:7 courtyard).

Like Wytryszek said, it's sort of common sense but I've already been asked in game a few times by rogues as to why their dps is so much lower then expected.

What is the armor value of the "boss" training dummy? I am 15/51/5 fist/sword. I've turned all buffs off in the spreadsheet. I have "Boss" selected in the sheet. It says I should see ~1803 sustained DPS, but this is about what I see on the non-boss level 80 training dummy. On the boss I see ~1550.

With a properly configured spreadsheet should you be able to hit your theoretical maximum "all buffs off" DPS on the level 80 boss training dummy?