DPS Spreadsheet - Page 29

Cheshyr · 03/30/08, 12:32 PM

Originally Posted by drumbum

Yes, that's exactly what it means. I'm assuming you're using a PVP Shadowstep build.

It's impossible to sustain two finishers without Improved Slice and Dice, so that's why you are only seeing one. With a low hit rating and no Dual Wield Specialization, your white damage is much lower, and because you have Serrated Blades, your rupture damage is increased by 30%. The result is that Rupture is actually a better finisher than Slice and Dice.

20/0/41 isn't a very good PVE build at all.

Originally Posted by Jakani

Yes, that's what it means.

As a sidenote, it also means your spec is terrible for doing good DPS.

Ok, just making sure I understood. Thanks. And while I'm not using 20/0/41, I know that any ShadowStep build is a terrible raid dps build. My guild favors PvP over raiding, so I have to keep some Arena viability.

Thanks again!

Eliago · 03/30/08, 6:25 PM

I usually don't use Excel. Is there a way to get fist weapons to appear in the Gear_Buffs sheet? All I see is swords and I think a couple maces. I wanted to compare the Vanir's Fists to some sword combos.

Zurgat · 03/30/08, 6:51 PM

Originally Posted by Eliago

I usually don't use Excel. Is there a way to get fist weapons to appear in the Gear_Buffs sheet? All I see is swords and I think a couple maces. I wanted to compare the Vanir's Fists to some sword combos.

It's a pretty common question. But could you please, read the first and second post in this thread?
That should give you the answers you need.

Eliago · 03/30/08, 8:28 PM

Originally Posted by Zurgat

It's a pretty common question. But could you please, read the first and second post in this thread?
That should give you the answers you need.

Sorry. I actually read over the FAQ but apparently skipped the very first article.

Thanks, though.

Cyn · 03/30/08, 10:52 PM

I've found a bug in the spreadsheet.

In investigating damage options for brutullus, i turned off "rupturable?" in the talents tab, and my dps went up 200dps, this cant be possible, as it should be picking that rotation anyway even if it was conceivable that evis was better.

Dontmindme · 03/31/08, 12:47 AM

Originally Posted by Cyn

I've found a bug in the spreadsheet.

In investigating damage options for brutullus, i turned off "rupturable?" in the talents tab, and my dps went up 200dps, this cant be possible, as it should be picking that rotation anyway even if it was conceivable that evis was better.

That's the same bug caught last page triggered by high armor penetration. Post #700 has the fix, the final ">0" doesn't belong in the formulas for cell V18 in both the Unbuffed and Buffed cycle sheets (until next version comes out). And you are correct. It's choosing the correct cycles, just reporting the damage numbers wrong for non-mutilate cycles involving eviscerate. There was a typo when I improved the handling of Adrenaline Rush that got missed because Eviscerate cycles are rarely recommended.

Drow · 03/31/08, 5:34 AM

Quick question. Can you acc setup for dps calc into the sheet? I asked this accidentally in aldrianas thread...

Zurgat · 03/31/08, 5:55 AM

Originally Posted by Drow

Quick question. Can you acc setup for dps calc into the sheet? I asked this accidentally in aldrianas thread...

Not sure what you are talking about.
Could you perhaps requote your question in this thread, or link to the other thread for clarification?

Also, another feature request for the sheet.
Could you add a checkbox at the AEP calculation panel for "Ignore Hit / Expertise cap".
If you are at the hit or expertise cap, it'll return 0 AEP currently. If you were to tick the checkbox it should ignore the cap and return a more comprehensive value.
After all, you might or might not always have the same buffs in effect. I think this would be a useful addition.

Could Deathfrost be added to the weapon enchants?

Drow · 03/31/08, 5:58 AM

Originally Posted by Zurgat

Not sure what you are talking about.
Could you perhaps requote your question in this thread, or link to the other thread for clarification?

Also, another feature request for the sheet.
Could you add a checkbox at the AEP calculation panel for "Ignore Hit / Expertise cap".
If you are at the hit or expertise cap, it'll return 0 AEP currently. If you were to tick the checkbox it should ignore the cap and return a more comprehensive value.
After all, you might or might not always have the same buffs in effect. I think this would be a useful addition.

my apologies. i wanted to ask if it is possible to add the subtley talent Setup into the dps sheet.

Jakani · 03/31/08, 6:11 AM

Originally Posted by Drow

my apologies. i wanted to ask if it is possible to add the subtley talent Setup into the dps sheet.

That's not really possible to model because it would require a knowledge of the number of incoming attacks that are dodgeable/resistable per unit time.

Drow · 03/31/08, 6:34 AM

that is not quite correct. if you can add it to the sheet just like armor value this should be possible. this value rate changes if you have resist armor or even if you have skilled into talents like heightened senses, enveloping shadows or sleight of hand.

Ratak - US KT · 03/31/08, 7:14 AM

Probable Bug with Current Mutilate modeling:

For non-eviscerate Mutilate cycles 'uevidmg' has a value assigned despite the cycle damage of eviscerate in p283 of the cycle sheets being 0 (zero). The error appears to come in the nested IF statement, but this is so complicated I cannot determine the fix with any certainty.

The net result is that Mutilate Rupture (and other non-eviscerate cycles) have the value of an eviscerate added to the DPS of the cycle - overstating the DPS by 50-100 (depending on gear, buffs etc.) which accounts for the very high DPS readings of Mutilate in 2_4_0_6 sheets. Blast! (As I was considering switching back to Mutilate after 2.4, but now the DPS is too low.)

This could probably be fixed pretty easily and improve the estimate prior to the complete modeling revamp.

todemax · 03/31/08, 9:19 AM

Originally Posted by Ratak - US KT

Probable Bug with Current Mutilate modeling:

For non-eviscerate Mutilate cycles 'uevidmg' has a value assigned despite the cycle damage of eviscerate in p283 of the cycle sheets being 0 (zero). The error appears to come in the nested IF statement, but this is so complicated I cannot determine the fix with any certainty.

The net result is that Mutilate Rupture (and other non-eviscerate cycles) have the value of an eviscerate added to the DPS of the cycle - overstating the DPS by 50-100 (depending on gear, buffs etc.) which accounts for the very high DPS readings of Mutilate in 2_4_0_6 sheets. Blast! (As I was considering switching back to Mutilate after 2.4, but now the DPS is too low.)

This could probably be fixed pretty easily and improve the estimate prior to the complete modeling revamp.

Myself and Left are currently revamping the mutilate modelling, and I won't think that there will be any specific mutilate rupture modelling when it is done.

Left · 03/31/08, 2:27 PM

Speaking of Mutilate modeling, yeah, I'm making some progress. I'm in the process, at the moment, of getting some basic tools in place which will allow consistent cycle calculations for all cycle types (mutilate and non-mutilate) using the same cycle set. I have another round of cycle diagrams (state/path diagrams) for both Mutilate and non-Mutilate Seal Fate builds which I plan to upload later today for review, if I have time. I'm adapting a spreadsheet to use them right now.

Today my lunchtime project was reviewing the way that finisher damage is calculated and making a new table that unifies all the relevant information (combo points, damage, time, energy cost) rather than have two tables: one for the regular cycles and one for Mutilate cycles. In the process, I found a bug in the current Envenom damage calculations: 'Unbuffed Cycles' and 'Buffed Cycles' cells N154:N158. These cells include a multiplier from cell T5, which is an aggregate multiplier for Eviscerate damage. (It takes into account Improved Eviscerate and Aggression.) These talents do NOT apply to Envenom, and this multiplier should be removed from the Envenom calculation. (I made this fix in my revamped finisher table.)

Progress is slow, but I hope to post an in-progress version of the sheet soon.

jsternbe · 03/31/08, 3:41 PM

Perhaps this was already mentioned, but as of 2.4.0.6 if you say that the boss is not rupturable, the DPS displayed goes up very significantly. This was not true in the previous version and seems to be a bug.

• Vulajin · 03/31/08, 3:46 PM

Originally Posted by jsternbe

Perhaps this was already mentioned, but as of 2.4.0.6 if you say that the boss is not rupturable, the DPS displayed goes up very significantly. This was not true in the previous version and seems to be a bug.

Possibly on the exact same page on which you just posted.

jsternbe · 03/31/08, 3:48 PM

Originally Posted by Vulajin

Possibly on the exact same page on which you just posted.

D'oh! I looked for it and didn't see it right under my nose. I'm lucky I don't have a career as a proofreader or editor.

Left · 03/31/08, 6:54 PM

As an update, I tried to change around my probability diagrams to make them (a) more generic, and (b) easier to implement with a spreadsheet. Here are the updated versions:

Seal Fate Probability Model (savefile.com)
Mutilate Probability Model (savefile.com)

I'm trying to get these implemented in the spreadsheet now so that I can write new cycles based on them. As always, any error checking is appreciated.

EDIT: Ignore the sixth page of the Mutilate PDF. I'm not using that table anymore, as it was very complicated and made for some really ugly formulas. I just forgot to take it out.

Dontmindme · 03/31/08, 11:18 PM

Originally Posted by Ratak - US KT

Probable Bug with Current Mutilate modeling:

For non-eviscerate Mutilate cycles 'uevidmg' has a value assigned despite the cycle damage of eviscerate in p283 of the cycle sheets being 0 (zero). The error appears to come in the nested IF statement, but this is so complicated I cannot determine the fix with any certainty.

The net result is that Mutilate Rupture (and other non-eviscerate cycles) have the value of an eviscerate added to the DPS of the cycle - overstating the DPS by 50-100 (depending on gear, buffs etc.) which accounts for the very high DPS readings of Mutilate in 2_4_0_6 sheets. Blast! (As I was considering switching back to Mutilate after 2.4, but now the DPS is too low.)

This could probably be fixed pretty easily and improve the estimate prior to the complete modeling revamp.

Here's a temporary fix:
Formula in Cell I10 in the Unbuffed and Buffed DPS sheets should substitute...
Unbuffed:
substitute =IF(AND(instatk="mut",'Unbuffed Cycles'!P283=0),0, for the leading = and add ) at the end
Buffed:
substitute =IF(AND(instatk="mut",'Buffed Cycles'!P283=0),0, for the leading = and add ) at the end

Apithicles · 04/01/08, 10:24 AM

I think the ring section is missing:

[Angelista's Revenge]

Zurgat · 04/01/08, 11:24 AM

Originally Posted by Apithicles

I think the ring section is missing:

[Angelista's Revenge]

It is in there actually, it's just named something like : "Sunwell badge loot - Melee ring"
This will be changed in the next version I'm sure.

Belakor · 04/01/08, 11:49 AM

Can you add Sunwell Plateau boss armor values next time you do a fix to the sheet? <.<

Zurgat · 04/01/08, 12:04 PM

Originally Posted by Belakor

Can you add Sunwell Plateau boss armor values next time you do a fix to the sheet? <.<

The author will need to know how much armor those bosses have first, and since these are not yet listed in this thread yet : [RAID] Boss armor values
You may need to wait a bit longer.

Apithicles · 04/01/08, 1:26 PM

Originally Posted by Zurgat

It is in there actually, it's just named something like : "Sunwell badge loot - Melee ring"
This will be changed in the next version I'm sure.

Thanks

Blankstar · 04/01/08, 2:20 PM

So I'm a Mac user, and since Microsoft delivers us lousy versions of Officer I got used to a less functional version of this spreadsheat. But I also have a pc, that I don't use for anything much but since it's worth nothing anymore selling it is not a real viable option.
Nevertheless, I wondered how cool the armory import and macro's and shit are, so I booted my pc, installed me Office 2007 and downloaded the spreadsheet. Some stuff didn't work so I read the first posts completely and saw I needed to install some extra stuff. Got me .net framework 3 or something like that, and that should fix it all.

But now I open the spreadsheet and the first thing I get is this;

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

I'm not keen on reading all the posts here to figur out if someone posted it already or not, and I'm no full fledged Windows/MS Office user so I'm not going to try and figur it out myself. So I'm asking you guys for a solution. (In return you can always PM me when you have some Mac OS X problems whenever you decide to switch

)