Rogue DPS Spreadsheet - Page 102

Ellos · 07/05/07, 7:33 PM

Originally Posted by micha

hi,

since 2.3.0g all gems have a grey background in the box and not the name of the gems ;<

Uh?
I've got no Problems with the gems.

koaschten · 07/05/07, 7:41 PM

Originally Posted by micha

hi,

since 2.3.0g all gems have a grey background in the box and not the name of the gems ;<

working as expected with Excel 2k3

Flailure · 07/05/07, 8:11 PM

Its a bug with Open Office.

It also appears to just be a display bug. should still be able to use the pulldown menus in it.

Ellos · 07/05/07, 8:23 PM

mmh.. can't test it in OpenOffice, maybe could fix it when I know where the bug is

Zurgat · 07/06/07, 4:06 AM

Originally Posted by tucciim

are you combat dagger or swords? as combat dagger instant on my MH gave me significantly more dps then WF. this was on the 2.2.6a sheet. Just want to make sure i am not doing something wrong, i am new to the spreadsheet greatness.

Yes, i'm swords. I probably should have mentioned that.

Originally Posted by Ellos

mmh.. can't test it in OpenOffice, maybe could fix it when I know where the bug is

If you wish to try OpenOffice : http://www.openoffice.org/
It's free software, and it's for Windows, MacOSX, and others.

2.3g looks to be working good so far. No display errors.
Just 1 more small request. Could you add a "save dps" button on the talents page as well?

Ellos · 07/06/07, 5:15 AM

No, don't wanna install OpenOffice here. I have Microsoft Office and I'm pleased with it.

And only for testing it's to huge.

Karmon · 07/06/07, 6:21 AM

Originally Posted by Ellos

mmh.. can't test it in OpenOffice, maybe could fix it when I know where the bug is

The conditional formatting for gems reference cells $Cx. The "Oo fix" for the dropdownbox shifted that to $Dx, but Oo apparently did not move the reference in the conditional formatting.

ron9 · 07/06/07, 6:26 AM

For a Combat Sword rogue who is regularly in a Windfury group, which of the three is the best Trinket?

Romulo's Poison Vial, Warp Spring Coil, or Tsunami Talisman?

Ellos · 07/06/07, 6:41 AM

http://rogue.raidcal.com/RogueDPS_2_3_0h.xls

This is only for testing

Gems working again in Open Office? Someone test this please.

• Vulajin · 07/06/07, 7:02 AM

It seems to still not be working.

(edit) Tested the version linked in the post below (in OpenOffice). The gems seem to work fine now. Not sure what the "other error" you mentioned should be, but I didn't have any problems.

Ellos · 07/06/07, 7:13 AM

http://rogue.raidcal.com/RogueDPS_2_3_0h.xls
(only for testing)
deleted the once made fix. When this doesn't help is there another error.

Sneez · 07/06/07, 9:51 AM

Excuse me for my bad English.

I would like to understand something in the sheet.
Without dagger, sword and fist spec, why do I have a slighty better DPS with Gladiator's Left Ripper than with Gladiator's Shiv ?
It's the same DPS, same stats on them, so I would have thought than Gladiator's Shiv is better because of Combat Potency (Gladiator's Shiv is quicker).

Thank you in advance

Marx · 07/06/07, 10:09 AM

Hey can anyone put out some final thoughts on the TSD vs RED fued?

it seemed for a while the TSD won easily..then RED came out on top of the spreadsheet..

are their any final conclusions for a combat swords/daggers build?

Backgoode · 07/06/07, 10:54 AM

Where is the hitrate value being defined? I'd like to change it from 15.8 to 15.769, but I can't find it for the life of me.

Melnor · 07/06/07, 10:57 AM

Originally Posted by Marx

Hey can anyone put out some final thoughts on the TSD vs RED fued?

it seemed for a while the TSD won easily..then RED came out on top of the spreadsheet..

are their any final conclusions for a combat swords/daggers build?

It's most likely one of those situations where it comes down to get whichever one is cheaper to acquire. Personally I would use RED because I'm not a fan of internal cooldowns combined with short proc durations.

Melnor · 07/06/07, 10:58 AM

Originally Posted by Backgoode

Where is the hitrate value being defined? I'd like to change it from 15.8 to 15.769, but I can't find it for the life of me.

Cell AL2 on the Gear_Buffs worksheet.

Backgoode · 07/06/07, 11:01 AM

Originally Posted by Melnor

Cell AL2 on the Gear_Buffs worksheet.

Well now I feel like an ass, it was right in front of me. Thanks.

Melnor · 07/06/07, 11:03 AM

Originally Posted by Sneez

Excuse me for my bad English.

I would like to understand something in the sheet.
Without dagger, sword and fist spec, why do I have a slighty better DPS with Gladiator's Left Ripper than with Gladiator's Shiv ?
It's the same DPS, same stats on them, so I would have thought than Gladiator's Shiv is better because of Combat Potency (Gladiator's Shiv is quicker).

Thank you in advance

Since they are the same dps you can then look at the average damage each weapon produces.

Gladiator's Shiv -- 127.5 Average Damage
Gladiator's Left Ripper -- 136.5 Average Damage

I'm guessing the .1 difference in speed between the two won't generate enough CP procs to make up the average damage difference.

Balkoth · 07/06/07, 11:15 AM

Originally Posted by Melnor

Since they are the same dps you can then look at the average damage each weapon produces.

Gladiator's Shiv -- 127.5 Average Damage
Gladiator's Left Ripper -- 136.5 Average Damage

I'm guessing the .1 difference in speed between the two won't generate enough CP procs to make up the average damage difference.

If the Shiv deals 127.5 damage every 1.4 seconds and the Left Ripper deals 136.5 damage every 1.5 seconds, then the overall DPS is the same, no? Actually, the dagger ends up 0.05-0.1 DPS ahead.

So the Left Ripper has the same (or 0.05-0.1 lower) DPS and is slightly slower. If the combo point generation doesn't make enough of a difference, then they should be equal if there are no weapon specs selected. The Left Ripper shouldn't be *higher* (unless I'm drastically missing something here).

Zaniel · 07/06/07, 11:24 AM

Originally Posted by lordbalkoth

If the Shiv deals 127.5 damage every 1.4 seconds and the Left Ripper deals 136.5 damage every 1.5 seconds, then the overall DPS is the same, no? Actually, the dagger ends up 0.05-0.1 DPS ahead.

So the Left Ripper has the same (or 0.05-0.1 lower) DPS and is slightly slower. If the combo point generation doesn't make enough of a difference, then they should be equal if there are no weapon specs selected. The Left Ripper shouldn't be *higher* (unless I'm drastically missing something here).

Just a shot in the dark, but i'd imagine armor might do some of that mitigation. Especially given the increased values of the recently tweaked sheets.

Backgoode · 07/06/07, 11:29 AM

Originally Posted by Zaniel

Just a shot in the dark, but i'd imagine armor might do some of that mitigation. Especially given the increased values of the recently tweaked sheets.

The mitigation from armor would be evenly distributed across all damage done by the weapon though. Either way you look at it, they both do the same DPS.

*edit* If I "remove" my spec, I get a 12 dps increase with shiv while main handing the right ripper, and 14 dps with Malch MH. What is your gear setup?

Zaniel · 07/06/07, 11:33 AM

Not necessarily. Weren't you talking about a very small DPS disparity? Armor applies a flat number reduction, yes? The weapon that hits more frequently runs up against a tiny bit more resistance from armor, just based on the way it's applied. (As in, eventually you'll reach a point where the extra speed leads to an extra attack, giving you back a full gain, but until that point you'd be "losing" part of your DPS.)

In the end, it wouldn't be a lot of difference, but it might account for the small amount you're seeing.

Ellos · 07/06/07, 11:35 AM

Allright.

http://rogue.raidcal.com/
Version 2.3.1
Mainly it has a fix for Open Office. Had testet it and it worked for me (in Open Office).

Backgoode · 07/06/07, 11:43 AM

Originally Posted by Zaniel

Not necessarily. Weren't you talking about a very small DPS disparity? Armor applies a flat number reduction, yes? The weapon that hits more frequently runs up against a tiny bit more resistance from armor, just based on the way it's applied. (As in, eventually you'll reach a point where the extra speed leads to an extra attack, giving you back a full gain, but until that point you'd be "losing" part of your DPS.)

In the end, it wouldn't be a lot of difference, but it might account for the small amount you're seeing.

I think I understand what you're saying, but I don't think the spreadsheet calculates DPS in this fashion. It assumes perpetual combat, so the average DPS of the offhand is really what comes into play.

The buffed DPS sheet lists my OH damage as 195.13(shiv) and 195.07(ripper). I assume the difference is due to rounding.

Zaniel · 07/06/07, 11:46 AM

You're probably right. Sorry to confuse things needlessly