Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Rogues

Closed Thread
 
LinkBack Thread Tools
Old 01/14/09, 9:00 PM   #931
Solanthious
Von Kaiser
 
Solanthious's Avatar
 
Troll Druid
 
Mal'Ganis
Originally Posted by nlraley View Post
What I was referencing to was the dagger that drops off of kel, the Sinister Revenge with a Webbed Death oh as mutilate spec was, according to the spreadsheet, over 800 dps higher than combat with Calamity's Grasp and Webbed Death oh.

I know mutilate is higher dps than combat but by that much? It was just seeming really odd.

Oh and yes, I did change the talents accordingly as well as the cp builder.
Fleshripper / LBC is higher dps then Silent Crusader / Widow's Fury; about 5% higher dps output in my gear according to the spreadsheet when comparing Mutilate to Combat, so when comparing SR / WD against CG and WD it wouldn't surprise me it's that high.

"I'm the best there is at what i do, bub, and what i do ain't pretty"

Offline
Old 01/15/09, 3:54 AM   #932
Cicatriz
Glass Joe
 
Human Paladin
 
Kil'Jaeden
Originally Posted by Darkwyng View Post
I am epic fail. I'm looking at the Cycles tab on the spreadsheet and I see where it lists a bunch of numbers for the various rotations...but what/where should I be looking to see which rotation is better than the others? What stat? Rupture DPS?
By any chance could someone answer this? I was going through the thread to see if someone replied to that but I didn't find anything

Offline
Old 01/15/09, 4:51 AM   #933
Rilias
Von Kaiser
 
Night Elf Rogue
 
Arthas (EU)
Roguecycles use their own notation to give a short identification of the sequence of used finishers.


Keeping to the spreadsheet here:

s stands for Slice'n'Dice,
r stands for Rupture and
e stands for Eviscerate (or Envenom if the "Use Envenom instead of Eviscerate"-box is set to TRUE)

Numbers in front of the finishers represent minimum combopoints at wich you will execute the finisher.

4r would therefore mean: "Use rupture as soon as 4+ Combopoints are reached"

The cycle itself is then build as a repeating sequence of the finishers in the stated order.

3s/5r means "SnD with at least 3 CP then Rupture with 5. Repeat."

4e/4r (CttC) means "Evis (Envenom) with 4+ CP then Rupture with 4+ CP. Repeat. SnD is kept running through CttC."

Offline
Old 01/15/09, 9:33 AM   #934
Contalyst
Glass Joe
 
Night Elf Rogue
 
Malorne
Originally Posted by nlraley View Post
What I was referencing to was the dagger that drops off of kel, the Sinister Revenge with a Webbed Death oh as mutilate spec was, according to the spreadsheet, over 800 dps higher than combat with Calamity's Grasp and Webbed Death oh.

I know mutilate is higher dps than combat but by that much? It was just seeming really odd.

Oh and yes, I did change the talents accordingly as well as the cp builder.
I get the exact opposite in my gear atm... I run Calamaity's Grasp/Widow's Fury 7/51/13 and according to the SS, I drop in dps by about 300 after changing glyphs, rotation and CP builder. I'm not overly concerned as the other raid members are just starting to catch up in DPS with me and I'm starting to place where I'm 'supposed' to on the charts(according to what I read a rogue shoulndt be top 3 dps on every fight).

I have Sinister's Revenge but not Webbed Death as a Shaman snag it from me, who knew they want all of our weapons now?

Offline
Old 01/15/09, 1:15 PM   #935
dinesh
Piston Honda
 
Gnome Rogue
 
Dalaran
Originally Posted by Rerox View Post
Click on the category-names in the gear tab. Took me some time to find that too
Thanks for that. I guess I was thrown off because the macro still includes all the old code I wrote to copy the gear to an upgrade worksheet at the same time as it was populating the cell comment (even though the destination sheet no longer even exists, and it was referencing the wrong origin sheet and locations).

Well, I found that utility useful the first time around, so... I implemented it again.

Roguecraft_LK_0.4.4_dbm_m.xlsm - FileFront.com

Changelog:
* Added a Gear_Upgrades sheet
* Modified the macros to copy any upgrades to that sheet, when you run the macro for a given slot

Notes:
* Will only copy item, slot, and dps upgrade amount. Source (and boss) info isn't included in the existing data, so I just chopped it out.
* There is still some code in there which doesn't do what it was originally intended to do (i.e. it refers to a min. DPS upgrade cell which no longer exists). I just left it all in there because it still works (for the moment at least), and maybe someday one of us will fix it.
* Running the macros will likely be slower now that it is copying items as well.
* I didn't re-implement the "upgrade all slots" functionality or the automatic deletion of old data on the upgrade sheet.

P.S. that sound you hear is me banging my head against my desk, because I accidentally saved over my working copy that I had spent a few hours filling in with all the source and boss info for all my upgrades.

Offline
Old 01/16/09, 4:45 AM   #936
Valustria
Banned
 
Blood Elf Rogue
 
Mal'Ganis
Is there a way to add [Enchanted Tear] to the list of gems?

Offline
Old 01/16/09, 8:55 AM   #937
denidd
Glass Joe
 
Human Rogue
 
Dalaran
Figurine - Emerald boar

This is a JC only trinket that is not appearing in the spreadsheet.

It adds 84 AP when equipped and is used to summon a fighting boar for 30 sec

I don't give a dam for the summoned boar...it's quite boring!

But the trinket comes with two slots for gems (yellow and blue) and has a 12 AP socket bonus, making it quite powerfull.

Earns some consideration in the spreadsheet, but i dont know how to add items to it.

Offline
Old 01/16/09, 10:01 AM   #938
Kmannkoopa
Von Kaiser
 
Night Elf Rogue
 
Alterac Mountains
Question that may have been answered, but I didn't find it by searching the thread:

I began my search by looking at my sub-categories of DPS, and wondering why the percentages don't add up to 100%. I had what I felt was a pretty good raid last night and on a lark decided to compare my WWS to the spreadsheet (for what little it is worth, I was only about 500 DPS behind theoretical maximum).

The white, rupture, and envenom damage matches my spreadsheet percentage, but Mutilate and Poison do not by about 6% each. The spreadsheet ends up adding up to 89%, so accounting for rounding and playing error, it would account for the missing percentages and be right in line with WWS.

I took a quick (not detailed) glance at some of the formulas on the DPS worksheet, it appears that the dps values copied in the DPS list are later modified for the totaldps formula, but are copied unmodified to the top of the other sheets in the spreadsheet. Is there a way to resolve this issue?

Offline
Old 01/16/09, 12:35 PM   #939
zenmoney
Glass Joe
 
Troll Rogue
 
Alleria
Originally Posted by Cicatriz View Post
By any chance could someone answer this? I was going through the thread to see if someone replied to that but I didn't find anything
I would like to know this as well. What should we be looking at in order to determine that one cycle is better than another (e.g. 4e/5r vs 4e/4r on the Xe/Yr (CttC) cycles)?

Offline
Old 01/16/09, 12:51 PM   #940
Cyllan
Von Kaiser
 
Cyllan's Avatar
 
Undead Rogue
 
Rexxar
Originally Posted by zenmoney View Post
I would like to know this as well. What should we be looking at in order to determine that one cycle is better than another (e.g. 4e/5r vs 4e/4r on the Xe/Yr (CttC) cycles)?
There isn't really an option on Mutilate CttC cycles. I mean, you could manually change it, but the recommendation is (after SnD is up, leaving out keeping HfB up):

Mutilate to 4+ combo points.
If SnD is about to drop, Envenom to refresh SnD.
If Rupture is not up, Rupture.

If you get 4 combo points, do not Shiv to get 5. If you really need to (for some obscure reason), Mutilate to 5 and waste combo points instead, but you really shouldn't ever need to do that.

The combat specs offer variability in cycles, and in that case, you want to look at whether changing X/Y/Z increases your calculated dps. If it does, then cycle A is better than cycle B.

EDIT: typo

Last edited by Cyllan : 01/16/09 at 2:02 PM.

Offline
Old 01/16/09, 1:20 PM   #941
Kmannkoopa
Von Kaiser
 
Night Elf Rogue
 
Alterac Mountains
On my copy of the spreadsheet, I theoretically do max dps with a 5e/4r cycle than a 4e/4r cycle. However, because of Seal Fate and Ruthlessness, I find that if I go with a 4e/4r cycle, depending on where my HfB I can sneak a second 4-5 point Envenom in before my Rupture ends, and I am confident that improves my DPS more. If I mutilate once more to get a 5th point (wasting one-two points in the process), I lose the time to sneak that extra mutilate. Now I make no attempt to keep a "perfect" rotation, instead I attempt refresh SnD and HfB as soon as there is less than 6s remaining.

Moral of the Story, for Mutilate, use rule one: (Mutilate to 4+ combo points)

Offline
Old 01/16/09, 3:04 PM   #942
• Aldriana
Mike Tyson
 
Night Elf Rogue
 
Doomhammer
Originally Posted by denidd View Post
This is a JC only trinket that is not appearing in the spreadsheet.

It adds 84 AP when equipped and is used to summon a fighting boar for 30 sec

I don't give a dam for the summoned boar...it's quite boring!

But the trinket comes with two slots for gems (yellow and blue) and has a 12 AP socket bonus, making it quite powerfull.

Earns some consideration in the spreadsheet, but i dont know how to add items to it.
It's not listed because it's honestly not very good. 84 AP + 2 sockets at 32 EP each works out to a total value of about 148 EP, which is barely half of what the better trinkets give. Almost anything you can pick up in a 5man or raid will be better.

Offline
Old 01/16/09, 4:42 PM   #943
zenmoney
Glass Joe
 
Troll Rogue
 
Alleria
Originally Posted by Cyllan View Post
There isn't really an option on Mutilate CttC cycles. I mean, you could manually change it, but the recommendation is (after SnD is up, leaving out keeping HfB up):

Mutilate to 4+ combo points.
If SnD is about to drop, Envenom to refresh SnD.
If Rupture is not up, Rupture.

If you get 4 combo points, do not Shiv to get 5. If you really need to (for some obscure reason), Mutilate to 5 and waste combo points instead, but you really shouldn't ever need to do that.

The combat specs offer variability in cycles, and in that case, you want to look at whether changing X/Y/Z increases your calculated dps. If it does, then cycle A is better than cycle B.

EDIT: typo
So for combat cycles, which field (or combination of fields) do you look at on the cycles page to determine which is best?

Last edited by zenmoney : 01/16/09 at 4:46 PM. Reason: reworded question

Offline
Old 01/16/09, 5:06 PM   #944
Cyllan
Von Kaiser
 
Cyllan's Avatar
 
Undead Rogue
 
Rexxar
Originally Posted by zenmoney View Post
So for combat cycles, which field (or combination of fields) do you look at on the cycles page to determine which is best?
Compare Total DPS to Previous DPS. If, after changing something, Total DPS is higher, you have just improved your dps. If Total DPS is lower, you have just made a change that decreases your dps. These are fields C8 and C9 on all tabs.

If you want to alter your combat cycle to try to improve your dps, alter I27-I30 on the Talents & Settings tab.

If the above isn't clear, please try to find some way to rephrase your question, as you appear to be asking:

"How do I get the spreadsheet to work?"

Offline
Old 01/17/09, 2:56 PM   #945
sp00n
Bald Bull
 
Night Elf Rogue
 
Wrathbringer (EU)
Added version 1.3 of the AEP calc sheet to the download page.


The only change is added support for OpenOffice 3.0.

The AEP calculation should now work with OO3. I didn't test it in OO2.x, and I doubt it'll work there, but let me know to be sure.


Note:
Until I find a way to include both the Excel (VBA) style macro and the OO (Basic) macro within one file, you will have to enable VBA support within OpenOffice.


To do so:
Choose Tools > Options > Load/Save > VBA Properties and enable the Executable code checkbox.
(Source)


The macro code itself is (seems?) to be OO Basic compatible, but I simply couldn't get it to work with both macro "languages", at least not with one button etc, and so my only option was to save the file using Excel.

Also, please check if it still works in Excel versions other than German 2002 (XP). I had to do really really wonky "Excel detection", which I'm not sure will work with other versions/localizations.
If anybody knows how to differentiate between Excel and OO3 with VBA support enable, please let me know (think of some sort of 'browser sniffer').
After a few hours I just gave up searching and simply hacked that piece of crap into the macro.

Stopped Playing

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Rogues

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Roguecraft 101 Vulajin Class Mechanics 3126 05/26/08 8:46 AM
[Rogue] DPS Spreadsheet Ellos Class Mechanics 1595 01/12/08 5:32 PM
Spreadsheet Design Boevis Public Discussion 11 07/14/07 2:46 AM
World of Roguecraft Episode 1 frmorrison Public Discussion 49 08/27/06 1:52 AM