 |
| 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.
|
07/05/07, 7:33 PM
|
#2526
|
|
Piston Honda
Night Elf Rogue
Zirkel des Cenarius (EU)
|
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.
|
|
|
|
|
|
07/05/07, 7:41 PM
|
#2527
|
|
Maniq is awesome.
Troll Rogue
Nazjatar (EU)
|
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
|
|
|
|
|
|
07/05/07, 8:11 PM
|
#2528
|
|
Gnome Connoisseur
|
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.
Last edited by Flailure : 07/05/07 at 8:13 PM.
Reason: more info
|
|
|
|
|
|
07/05/07, 8:23 PM
|
#2529
|
|
Piston Honda
Night Elf Rogue
Zirkel des Cenarius (EU)
|
mmh.. can't test it in OpenOffice, maybe could fix it when I know where the bug is
|
|
|
|
|
|
07/06/07, 4:06 AM
|
#2530
|
|
King Hippo
|
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?
Last edited by Zurgat : 07/06/07 at 4:38 AM.
|
-= Random Ravings - RSS Feed =- Rogue and Hunter stuff here. As well as guides to get you trough your spare time.
|
|
|
|
07/06/07, 5:15 AM
|
#2531
|
|
Piston Honda
Night Elf Rogue
Zirkel des Cenarius (EU)
|
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.
|
|
|
|
|
|
07/06/07, 6:21 AM
|
#2532
|
|
Piston Honda
Human Rogue
Teldrassil (EU)
|
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.
|
|
|
|
|
|
07/06/07, 6:26 AM
|
#2533
|
|
Von Kaiser
|
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?
|
|
|
|
|
|
07/06/07, 7:02 AM
|
#2535
|
|
Now with 100%* less failure.
|
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.
Last edited by Vulajin : 07/06/07 at 7:34 AM.
|
|
|
|
|
|
07/06/07, 9:51 AM
|
#2537
|
|
Glass Joe
Night Elf Rogue
Archimonde (EU)
|
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
|
|
|
|
|
|
07/06/07, 10:09 AM
|
#2538
|
|
Glass Joe
Gnome Rogue
Laughing Skull (EU)
|
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?
|
|
|
|
|
|
07/06/07, 10:54 AM
|
#2539
|
|
Von Kaiser
Tauren Warrior
Cenarion Circle
|
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.
|
|
|
|
|
|
07/06/07, 10:57 AM
|
#2540
|
|
Piston Honda
Blood Elf Paladin
Blackhand
|
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.
|
|
|
|
|
|
07/06/07, 10:58 AM
|
#2541
|
|
Piston Honda
Blood Elf Paladin
Blackhand
|
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.
|
|
|
|
|
|
07/06/07, 11:01 AM
|
#2542
|
|
Von Kaiser
Tauren Warrior
Cenarion Circle
|
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.
|
|
|
|
|
|
07/06/07, 11:03 AM
|
#2543
|
|
Piston Honda
Blood Elf Paladin
Blackhand
|
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.
|
|
|
|
|
|
07/06/07, 11:15 AM
|
#2544
|
|
Piston Honda
|
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).
|
|
|
|
|
|
07/06/07, 11:24 AM
|
#2545
|
|
Piston Honda
|
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.
|
|
|
|
|
|
07/06/07, 11:29 AM
|
#2546
|
|
Von Kaiser
Tauren Warrior
Cenarion Circle
|
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?
Last edited by Backgoode : 07/06/07 at 11:37 AM.
|
|
|
|
|
|
07/06/07, 11:33 AM
|
#2547
|
|
Piston Honda
|
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.
|
|
|
|
|
|
07/06/07, 11:35 AM
|
#2548
|
|
Piston Honda
Night Elf Rogue
Zirkel des Cenarius (EU)
|
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).
|
|
|
|
|
|
07/06/07, 11:43 AM
|
#2549
|
|
Von Kaiser
Tauren Warrior
Cenarion Circle
|
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.
|
|
|
|
|
|
07/06/07, 11:46 AM
|
#2550
|
|
Piston Honda
|
You're probably right. Sorry to confuse things needlessly 
|
|
|
|
|
|
|