 |
| Welcome to Elitist Jerks |
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!
If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.
|
12/04/08, 7:22 AM
|
#1
|
|
Public Enemy Nr.1
Undead Warlock
Ravencrest (EU)
|
Cherubael's Rogue Spreadsheet
This spreadsheet is simply put, pretty much exactly the same as Vulajin's. All credit goes to him for its creation and the link to his original sheet can be found here: The Roguecraft Spreadsheet
The current differences are:
- Gear sets can be created, saved and deleted
- A wishlist containing best possible rogue gear is saved within
Current Version: Rogue_DPS_Cherubael_0.4.7.xls
I appreciate that not everyone is an excel genius, so I will now tell you how to move your saved gear sets from one version of the sheet into another.
1. Download the new sheet.
2. Open the new and the old sheet.
3. In both sheets follow the menu options at the top: "Format" > "Sheet" > "Unhide..." > "Gear Sets"
4. Select the "Gear Sets" sheet in both workbooks.
5. Copy and paste the whole column from the old worksheet into the new one.
6. Select the "Gear Sets" sheet and follow the options "Format" > "Sheet" > "Hide"
Last edited by Rosethorn : 02/16/09 at 1:50 PM.
|
Sukoden - "I refuse to play druid. In the end you get too many and you end up with a frickin zoo."
|
|
|
|
12/04/08, 8:35 AM
|
#2
|
|
Von Kaiser
Orc Rogue
Magtheridon (EU)
|
Congratulations on the initiative.
There was a spreadsheet before which showed you possible upgrades and featured an import function, made by dontmindme i think.
Do you plan to implement any of those features?
|
|
|
|
|
|
12/04/08, 9:47 AM
|
#3
|
|
Public Enemy Nr.1
Undead Warlock
Ravencrest (EU)
|
The important things for me as a rogue when I look at this spreadsheet are to quickly and efficiently understand two things.
- How to maximise my dps with my current equipment.
- What my ideal equipment would be.
The only improvements I would personally want to make to the sheet would be to enhance those goals.
At the same time, I understand that Vulajin's spreadsheet and the version of it I modified above provide a service to the rogue community and that enhancing that service is a worthy ambition. So the answer to your question is that although I have not yet planned that functionality, nothing is impossible and if I see an opportunity to efficiently implement those improvements, there is no reason why I would not take it.
|
Sukoden - "I refuse to play druid. In the end you get too many and you end up with a frickin zoo."
|
|
|
|
12/04/08, 11:49 AM
|
#4
|
|
The Duke
Night Elf Rogue
Shattered Hand
|
I thank you for your effort, but from a development standpoint, wouldn't it make sense to combine versions instead of creating two divergent versions?
If you have updates to his spreadsheet, possibly just send them to him to check them over and implement them as a new version or release.
The only reason I can see for divergent versions is if you two disagree on features to implement, which may very well be the case.
|
Rogue at heart.
|
|
|
|
12/04/08, 12:03 PM
|
#5
|
|
Piston Honda
|
Vulajin can correct me if I'm mistaken, but he's always been pretty firm on maintaining OO compatibility, something that you can't really do when adding extensive macros like Armory Import, etc.
|
|
|
|
|
|
12/05/08, 1:32 PM
|
#6
|
|
Von Kaiser
|
Im curious, on your gear page, you have a section titled "equivalence non-sense":
You have some values here that dont seem to change as your gear changes..
MH speed +.1 = -540?
-540 what? Poison DPS?
Can you please explain what each of the 4th vertical column values represent? And more importantly, how you came to these conclusions?
|
|
|
|
|
|
12/06/08, 12:47 PM
|
#7
|
|
Public Enemy Nr.1
Undead Warlock
Ravencrest (EU)
|
If you follow the link at the top of those values "Equivalence Nonsense", You will go to a website which will show you what the "best" gear is you can get using those equivalence values.
They are the values I calculated by varying individual stats by 20 and then dividing the change in DPS by 20. The weapons were varied by 0.4 and then tweaked a bit and the dps change divided by 0.4 again to get a value of the dps difference of decreasing weapon speed. All these calculations were made with wishlist gear on.
The reason I call it "nonsense" is because some of the items listed are incorrectly placed first on the wishlist either due to set bonus issues, or reasons unknown. Either way using equivalence to decide on gear upgrades is not necessarily the best solution. I would aim to get the items indicated on the wishlist gear set and leave equivalence out of it.
About collaboration with Vulajin, I truly hope he decides to take my sheet and update it instead so I don't have to produce a new one every time he does, but we have not talked about it.
|
Sukoden - "I refuse to play druid. In the end you get too many and you end up with a frickin zoo."
|
|
|
|
12/06/08, 4:25 PM
|
#8
|
|
Now with 100%* less failure.
|
Originally Posted by Rosethorn
About collaboration with Vulajin, I truly hope he decides to take my sheet and update it instead so I don't have to produce a new one every time he does, but we have not talked about it.
|
This is not going to happen for three reasons:
- It breaks OO compatibility.
- I consider such features unnecessary fluff; I'd rather spend my time developing the actual calculations to be accurate. Other people are perfectly free to add such features, but I prefer they do so separately because I would rather their features did not become part of the updating process. As it is, I can churn out an update to the sheet very rapidly because I know every nook and cranny of it, and also because I don't have to go through someone else's work to make sure my changes don't break anything. I'm not interested in losing that.
- Saving talent builds is completely against the point of the sheet, which is to encourage people to figure things out for themselves. It's the same reason why the sheet doesn't just model specific cycle permutations such as 2s/5r, but rather entire classes of cycles for which you can specify any number of CP. If you have a bunch of saved talent builds, you're more likely to just choose one of them rather than do even the most rudimentary experimentation to figure out whether there might be a more optimal arrangement.
With that said, I'm extremely appreciative that people seem to like the sheet enough to develop modified versions or additions to extend its functionality to include these types of features. As long as the calculations are accurate and are being used in some fashion, be it through my original version or through anyone else's modified version, to help rogues gear and perform optimally, I'm happy.
(edit) I realize that my third point addresses something that isn't actually implemented in Cherubael's version of the sheet. Still, the argument can be generalized. :p
Last edited by Vulajin : 12/06/08 at 4:42 PM.
|
Originally Posted by Darkside
No expansion is complete without trolls. I expect now we'll discover that Arthas has been raising hordes of zombie-trolls in the secret troll hovel of Zul'Crown.
|
|
|
|
|
12/07/08, 12:49 AM
|
#9
|
|
Glass Joe
|
Additions
I would love to see a "Gear Upgrade" button, along with that the source of the items. This would add a great deal of functionality for people to see what they can improve on, and how they can get it.
It would be nice if there was an option so the user could input any weapon, ie right now I have the Merciless weapons which is not on your sheet, but there is not a way to manually enter it either.
Armory update would obviously be nice, but I think the gear upgrade with source would provide the most useful function for users.
Just some thoughts...
|
|
|
|
|
|
12/08/08, 6:17 AM
|
#10
|
|
Public Enemy Nr.1
Undead Warlock
Ravencrest (EU)
|
Originally Posted by Vulajin
Version 0.4.2 is now available via the download link in the first post. Changes:
- Mutilate now has two chances for all non-crit-based off hand procs.
- Increased armor to 13083 to reflect findings on same.
- Added Bandit's Insignia, Darkmoon Card: Death, Darkmoon Card: Greatness, and Mark of Norgannon.
- Implemented Heroic Presence, finally.
- Fixed an error preventing the Eternal Belt Buckle from granting its extra socket.
Note that most of the trinket valuations thus far are estimates. I simply guessed a 45 second ICD for any effect for which I didn't already know the exact ICD (in other words, everything but Mirror of Truth, which I believe is 50 seconds).
|
Updated Accordingly in first post: http://elitistjerks.com/f78/t38109-c...et/#post998421
|
Sukoden - "I refuse to play druid. In the end you get too many and you end up with a frickin zoo."
|
|
|
|
12/15/08, 6:49 AM
|
#11
|
|
Public Enemy Nr.1
Undead Warlock
Ravencrest (EU)
|
Originally Posted by Vulajin
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.
|
Updated Accordingly in first post: http://elitistjerks.com/f78/t38109-c...et/#post998421
|
Sukoden - "I refuse to play druid. In the end you get too many and you end up with a frickin zoo."
|
|
|
|
12/19/08, 2:50 AM
|
#12
|
|
Von Kaiser
Dwarf Paladin
Grim Batol (EU)
|
I get about 50 less dps with your sheet, in comparison to Vulajin's and I think I found the reason. The sheet doesn't seem to count the crit from CQC. At least my crit doesn't rise in the 'DPS' section when I "spec" CQC, while it does when I do it with Vulajin's original sheet.
|
|
|
|
|
|
12/19/08, 12:06 PM
|
#13
|
|
Glass Joe
|
Actually I made the upgrade function for Dontmindmes sheet, and I'm working on one that performs the same function for the Roguecraft. But it will be a separate workbook, able to read Vulajin's for data. I respect his desire to keep his o:o compatible, but I dont dont agree that convienence and ease of use is 'fluff'.
|
|
|
|
|
|
12/19/08, 10:34 PM
|
#14
|
|
Public Enemy Nr.1
Undead Warlock
Ravencrest (EU)
|
Originally Posted by OnTheHissay
I get about 50 less dps with your sheet, in comparison to Vulajin's and I think I found the reason. The sheet doesn't seem to count the crit from CQC. At least my crit doesn't rise in the 'DPS' section when I "spec" CQC, while it does when I do it with Vulajin's original sheet.
|
It's probably because I am a different class/race/spec to vulajin. The sheets are identical in every other way except the ability to save/load/delete gear sets. If you are getting different dps values check the buffs page, the length of the fight etc.
|
Sukoden - "I refuse to play druid. In the end you get too many and you end up with a frickin zoo."
|
|
|
|
12/22/08, 1:30 AM
|
#15
|
|
Glass Joe
|
The calculations for some of the item bonuses resulting from gems seems to be broken on the gear spreadsheet.
The item in question bonus (from the specific stats sheet, column 16) is compared against the names in row E. If they match then the bonus gets added if the gemming matches.
The problem is that some of the names have been abbreviated on the gear sheet.
For example stamina is listed as sta. Because "sta" doesn't match "stamina" an applicable bonus is never picked up.
I don't see these abbreviations in Vulajin's LK 0.4.3 workbook.
|
|
|
|
|
|
12/22/08, 5:13 PM
|
#16
|
|
Piston Honda
|
Originally Posted by Arioche
Actually I made the upgrade function for Dontmindmes sheet, and I'm working on one that performs the same function for the Roguecraft. But it will be a separate workbook, able to read Vulajin's for data. I respect his desire to keep his o:o compatible, but I dont dont agree that convienence and ease of use is 'fluff'.
|
Excellent. I share your views about the upgrade automation, and was the one who moditfied it with all of the autofiltering. In fact, I just PM'ed DMM earlier today to ask about his progress, because I was lamenting that missing functionality in all these new sheets. Best of all worlds!
|
|
|
|
|
|
01/05/09, 4:05 PM
|
#18
|
|
Banned
|
What is the difference between the saved dps and the total dps? I am sorry if this is a stupid question.
Last edited by tbee : 01/05/09 at 8:15 PM.
Reason: got a warning thus need to edit
|
|
|
|
|
|
01/05/09, 4:22 PM
|
#19
|
|
King Hippo
Gnome Rogue
Scarlet Crusade
|
Originally Posted by tbee
what is the difference between the saved dps and the total dps?
sorry if this is a stupid question.
|
I can answer this by use of example.
Put in your gear; view the 'total DPS'. Copy this total DPS into the 'saved DPS' section (be sure to copy this the right way). Now 'upgrade' a piece of gear by selecting something new. The sheet then compares the new total DPS to your previously saved DPS. Voila!
|
You're a lot of DPS, you know that? You wanna' earn 14 achievement points the hard way?
|
|
|
|
01/05/09, 9:27 PM
|
#20
|
|
Glass Joe
Blood Elf Rogue
Wildhammer
|
Any plan to add the saving of different specs?
|
|
|
|
|
|
01/16/09, 2:31 PM
|
#21
|
|
Glass Joe
Troll Rogue
Burning Legion (EU)
|
Can someone explain to me why white, mutilate, rupture, envenom and poison dps doesn't add up to the total dps?
The percentages doesn't add up to 100% either.
This is what it looks like (unbuffed dps):
White DPS 683,69 28,18%
Mutilate DPS 511,37 21,08%
Rupture DPS 243,06 10,02%
Envenom DPS 164,10 6,76%
Poison DPS 623,80 25,71%
Other DPS 0,00 0,00%
Total DPS 2426,35
I don't understand this at all, please help me.
|
|
|
|
|
|
01/17/09, 2:56 AM
|
#22
|
|
Von Kaiser
Undead Rogue
Dragonmaw (EU)
|
Originally Posted by yoyot
Can someone explain to me why white, mutilate, rupture, envenom and poison dps doesn't add up to the total dps?
The percentages doesn't add up to 100% either.
This is what it looks like (unbuffed dps):
White DPS 683,69 28,18%
Mutilate DPS 511,37 21,08%
Rupture DPS 243,06 10,02%
Envenom DPS 164,10 6,76%
Poison DPS 623,80 25,71%
Other DPS 0,00 0,00%
Total DPS 2426,35
I don't understand this at all, please help me.
|
For me it doesn't account for Killing Spree and Hunter's FI, you can check the DPS sheet to see the breakdown of the stats (cells B39 and below).
|
|
|
|
|
|
01/18/09, 7:50 AM
|
#23
|
|
Glass Joe
Troll Rogue
Burning Legion (EU)
|
The breakdown of the stats is not adding up to my total dps either. I've done some testing on dummies and the total dps seem to be right. Anyone else that know what's wrong here?
|
|
|
|
|
|
01/29/09, 6:13 PM
|
#24
|
|
Glass Joe
|
I am also seeing a % total damage of around 91, so I'm wondering where the rest has gone. And I don't see any EP weightings; where might those be? If not included, how can I modify the AEP Spreadsheet to read yours?
[edit] And since there's a save feature for gear, might one be added for buffs? I like to toggle back and forth between solo and raid to see the difference, and it's painful to have to turn everything off/on manually.
Last edited by ant1pathy : 01/30/09 at 2:26 AM.
|
|
|
|
|
|
02/05/09, 3:54 PM
|
#25
|
|
Glass Joe
Blood Elf Rogue
Wildhammer
|
Did this sheet die off?
|
|
|
|
|
|
|