Cherubael's Rogue Spreadsheet - Page 2

dinesh · 12/22/08, 4:13 PM

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!

choumarin · 01/03/09, 5:37 PM

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 · 01/05/09, 3:05 PM

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

Tinwhisker · 01/05/09, 3:22 PM

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!

evolart · 01/05/09, 8:27 PM

Any plan to add the saving of different specs?

yoyot · 01/16/09, 1:31 PM

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 · 01/17/09, 1:56 AM

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

yoyot · 01/18/09, 6:50 AM

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 · 01/29/09, 5:13 PM

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 · 02/05/09, 2:54 PM

Did this sheet die off?

Rosethorn · 02/06/09, 9:18 AM

nope, I will update it as soon as Vul adds in his new one.

Edit: I felt no real need to release one based on his previous release as I am guessing rogues mainly use these sheets to check out the best gear and rotations they can use and none of that changed in the last release. Equipping my wishlist I believe is still the best gearing a rogue can use along with a 4+n/4+r 60 energy pool rotation.

ant1pathy · 02/07/09, 5:52 PM

Any word on some of the other modifications (AEP values/compatibility with the other sheet, buff set saving, total dps not adding up to 100%)?

Lys · 02/12/09, 8:08 AM

hi everyone, i'm serious trying to get rid of the 2-proc mechanic for mutilate since its been taken out of the game...
but i just cant find it, since im not a exel genius but already managed it to change the mut-poison multiplier and the hfb multiplier and now stuck at this is driving me kind of crazy :X anyone got a tip for me?^^

Turncoat · 02/13/09, 7:15 PM

Just tried this one out and liked it over others, i hope you keep it updated when ulduar come out.

Rosethorn · 02/16/09, 12:42 PM

Originally Posted by Vulajin

Finally got around to whipping up version 0.4.5 of the spreadsheet. As always, it's available via the download link in the first post. Changes:

- Mutilate now only receives a 20% bonus on poisoned targets, and always assumes targets are poisoned.
- Slice and Dice now provides a 40% haste bonus.
- Hunger for Blood now provides 15% increased damage.
- Changed cycle calcs to assume 100% Slice and Dice uptime initially to allow the model to reach equilibrium more quickly.
- Removed one each of the "DPS Calc" and "Cycles" sheets.

Basically this version brings the sheet up to speed with patch 3.0.9. In addition, the last couple changes in that list are basically step 1 in a major effort to streamline the calculation paths in the sheet. This is going to be necessary if I ever want to expand the cycle model, because as it was, adding any new calculation paths (for example, for a more dynamic CttC model, or for HAT) was going to be a gigantic pain in the ass. My goal is to have two DPS Calc sheets and one Cycles sheet, though that may or may not be a pipe dream. At worst I'd have two of each. We'll see what I can manage.

If I've inadvertently broken something while removing those two sheets, please let me know. A cursory examination showed no problems, so I'm reasonably confident, but we'll see.

Originally Posted by Vulajin

Version 0.4.6 is available via the download link in the first post. Changes in this version:

- Expertise is no longer truncated (i.e. each point of expertise rating provides equal effect).
- Bloodlust modeling streamlined slightly.
- Slightly changed the calculation path for Slice and Dice uptime, preventing the drop-off that previously occurred on DPS Calc 2.
- Hyperspeed Accelerators cooldown reduced to 60 seconds, duration increased to 10 seconds.
- Added some logic to automatically activate the Master Poisoner or Savage Combat debuffs if those talents are taken.
- Added an option to assume that the target is always being poisoned by someone (for Mutilate).
- Skinning now properly provides 32 crit rating.
- The damage breakdown header on data entry sheets no longer displays values adding up to less than 100% of your DPS.
- Cooldown-based haste effects now properly affect Instant Poison and Wound Poison DPS.
- Fixed a naming issue that was causing problems for OpenOffice users.

Sorry for the second update in two days. I just happened to have some extra free time today and thought it'd be a good opportunity to try to get all the small stuff I've been putting on the back burner into the sheet. This way, 0.5.0 will be focused primarily on my planned overhaul of the cycle models, rather than having a lot of extraneous other stuff to worry about.

If there are any further issues that I've overlooked, even if they're small, they're most likely going to wait until 0.5.0.

Originally Posted by Vulajin

You would be correct, as I just updated the download link in the first post to version 0.4.7. Changes:

- Really fixed the naming errors for OpenOffice users.

And hoo boy do I hope I'm right this time.

Updated Accordingly in first post: http://elitistjerks.com/f78/t38109-c...et/#post998421