Rosethorn

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"

Sukoden - "I refuse to play druid. In the end you get too many and you end up with a frickin zoo."

 

turbare

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?

 

Rosethorn

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."

 

Leto

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.

 

PessimiStick

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.

 

sephfiroth

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?

 

Rosethorn

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."

 

• Vulajin

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

 

juhaha

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...

 

Rosethorn

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."

 

Rosethorn

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."

 

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.

 

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'.

 

Rosethorn

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."

 

Cragzop

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.

 

dinesh

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!

 

choumarin

I did some minor additions to your sheet to add EP calculation.
Here is the file: Rogue_DPS_Cherubael_0.4.3s.zip - FileFront.com

 

tbee

What is the difference between the saved dps and the total dps? I am sorry if this is a stupid question.

 

Tinwhisker

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?

 

evolart

Any plan to add the saving of different specs?

 

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.

 

Gogge

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).

 

yoyot

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?

 

ant1pathy

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.

 

evolart

Did this sheet die off?