[Rogue] DPS Spreadsheet - Page 42

Gillrowson · 09/10/07, 12:31 PM

I am having a problem with version 2.2.0.12. I downloaded it from http://rogue.raidcal.com/. I don't know if it is a bug or if I neglected to check a box. In the gear pane when choosing weapons, the only options for weapons are daggers. I would like to know how to get lists for both swords and maces. If someone could let me know what mistake I have made I would greatly apreciate it.

Druss · 09/10/07, 12:36 PM

Originally Posted by Ellos

It's possible.
You need a maybe blue Gem to complete the Bonus on your Item or you need the item to complete the Requirment for the Metagem.

/facepalm - you are so right ;P That's what it was. Now "fixed".

Need arcane brilliance buff badly ;P

Druss · 09/10/07, 12:37 PM

Originally Posted by Gillrowson

I am having a problem with version 2.2.0.12. I downloaded it from http://rogue.raidcal.com/. I don't know if it is a bug or if I neglected to check a box. In the gear pane when choosing weapons, the only options for weapons are daggers. I would like to know how to get lists for both swords and maces. If someone could let me know what mistake I have made I would greatly apreciate it.

On the screen with gear selection scroll right and down a bit and you will see you need to select the weaps you use - once you ahve you get what you select only.

Radmsc · 09/10/07, 3:53 PM

Really good works guys. You have implemented the meta gem check. This really helped me a lot to find the best green/purple gem.

The sheet is (in my opinion) almost perfect. Allthough there's 1 little thing I would recommend.

You have been able to remove an unique gem once it has been used. Can you also do this for the rings and trinkets? Because one ring (which u use) will always be in the upgrade-list of your other ring. The same thing goes for the trinkets.

Darmoed · 09/10/07, 7:37 PM

Originally Posted by Dreshla

So I have been looking over the dagger spec vs sword spec issue. From what I can tell the newest version 2.2.0.12 takes into account the changes to windfury and sword spec listed from PTR. IS the pure dps really as different as listed even for non-humans? I have adjusted my current gear just changes to season 2 swords and spec to swords for comparison...and its depressingly showing daggers far inferior.

The Armory

Again, thanks for all your hard work on the spreadsheet.

~Dreshla

I see the same issue. I do significantly more dps with [Talon of Azshara] then with [Fang of Vashj]. I change only my weapons and spec. I leave the rest of my gear the same. It looks funny... Aren't daggers supposed to be beter on dps then swords? Swords are less positioning- dependent so why should they be better than daggers? I do not understand this part. Is this a real issue? Should Blizzard fix it?

Dreshla · 09/10/07, 8:39 PM

Originally Posted by Darmoed

I see the same issue. I do significantly more dps with [Talon of Azshara] then with [Fang of Vashj]. I change only my weapons and spec. I leave the rest of my gear the same. It looks funny... Aren't daggers supposed to be beter on dps then swords? Swords are less positioning- dependent so why should they be better than daggers? I do not understand this part. Is this a real issue? Should Blizzard fix it?

hehe indeed. I have ranted often about this issue... a class defining skill (backstab) which requires positioning, does less overall dmg than spamming SS and throwing out ruptures. granted you do much the same but if BS is gonna be sooo inferior..unless they change energy on BS to match SS since it requires position and is unuseable solo... it should do more dmg. If the patch changes still leave swords a clear leader (currently like a good 3% or more better dmg... even with similar/inferior weapons dps wise) I'll just have to give up the ghost on daggers I guess.....sniffle

~Dreshla

nilme · 09/11/07, 2:38 AM

I was a bit shocked about the difference between the gear sheet and the dps sheet when it came to maces. I did some numbers on my gear on both sheets and isolated the problem: dragonmaw/dragonstrike [and I guess drakefist] are heavily undervaluated on this sheet.

Using S2 MH Mace gives me lower dps on live than using dragonmaw. On the sheet the S2MH mace is suggested as a big upgrade, slightly above dragonstrike. On the gear sheet the S2MH mace is a downgrade from dragonmaw, which was not consistent with my experience on live.

Now I checked some of my WWS logs and found that dragonmaw(and, I guess, dragonstrike) proc should be considered as a 2PPM one. I checked several fights and on all of them I had between 2.1 and 2.3 ppm("Haste" procs / fight duration) and I guess that the logs are ignoring the refreshing ones. If my "uptime concept" isn't skewed, that should give the mace 80 permanent haste(212/10secs * 60secs/2ppm), twice as much as what it's given on the sheet.

"Upgrading" the mace makes the sheet result the same as I apreciate on live(dragonmaw > s2 mace) and consistent with the gear sheet(dragonstrike slightly superior to rod of the sun king).

Any other dragon* mace users that can confirm this?

*Edit:If it is of any use, my import/export function works flawlessly. I'm using the spanish version of MSExcel that shares the "." and "," formatting with the german one(ellos'?). I get no errors using it and everything is imported into the proper cell, with no negative dps// #### errors.

Zurgat · 09/11/07, 3:37 AM

Originally Posted by Ellos

Export Equip takes a long time and it makes often problems.

I'm thinking if I should drop Buffs from the export, because if there are changes, it imports wrong (well, when the buff added at the end of the category it should work, but we have seen what happend if the buffs is added in the middle, it makes many problems)

I'll see what I'll do.

Tried export, and see a potential bug.

Spreadsheet located in: "files/docs/roguedps22012.xls"
Press export.
It then created a file in the folder "files" with the name "docs\RogueDPS_Itemfile.xls", instead of in the folder "files/docs".
So it probably was unable to find that file proper.

Radmsc · 09/11/07, 4:18 AM

I was just fooling around a bit with the spreadsheet and found the following bug:

When entering both Warglaives of Azzinoth and Windfury as a temporary buff, the dps goes +5500. I think this is not ment to be, is it?

Wandatin · 09/11/07, 6:51 AM

Is a certain version of Excel required to run the Upgrade macros? Using Excel 97, I get the following error when attempting to run the Upgrade macro.

Listname = Replace(ItemCell.Validation.Formula1, "=", "")

All versions have behaved like this for me since the old 2.3.6 version which I reported back on July 20th in the old thread.

http://elitistjerks.com/427156-post158.html

Melnor · 09/11/07, 8:52 AM

I would assume that a lot of macro functionality is missing in a 10 year old version of Excel

Azaziel · 09/11/07, 9:38 AM

Originally Posted by nilme

I was a bit shocked about the difference between the gear sheet and the dps sheet when it came to maces. I did some numbers on my gear on both sheets and isolated the problem: dragonmaw/dragonstrike [and I guess drakefist] are heavily undervaluated on this sheet.

Using S2 MH Mace gives me lower dps on live than using dragonmaw. On the sheet the S2MH mace is suggested as a big upgrade, slightly above dragonstrike. On the gear sheet the S2MH mace is a downgrade from dragonmaw, which was not consistent with my experience on live.

Now I checked some of my WWS logs and found that dragonmaw(and, I guess, dragonstrike) proc should be considered as a 2PPM one. I checked several fights and on all of them I had between 2.1 and 2.3 ppm("Haste" procs / fight duration) and I guess that the logs are ignoring the refreshing ones. If my "uptime concept" isn't skewed, that should give the mace 80 permanent haste(212/10secs * 60secs/2ppm), twice as much as what it's given on the sheet.

"Upgrading" the mace makes the sheet result the same as I apreciate on live(dragonmaw > s2 mace) and consistent with the gear sheet(dragonstrike slightly superior to rod of the sun king).

Any other dragon* mace users that can confirm this?

*Edit:If it is of any use, my import/export function works flawlessly. I'm using the spanish version of MSExcel that shares the "." and "," formatting with the german one(ellos'?). I get no errors using it and everything is imported into the proper cell, with no negative dps// #### errors.

Dragonstrike is quite a bit better than S2Mace, yes. I think it will still be a bit better after patch, but with haste nerf it should be closer between them. Not sure if the new sheet already running on the testserver numbers.

nilme · 09/11/07, 11:00 AM

Originally Posted by Azaziel

Dragonstrike is quite a bit better than S2Mace, yes. I think it will still be a bit better after patch, but with haste nerf it should be closer between them. Not sure if the new sheet already running on the testserver numbers.

All sheets included the haste nerf since the day it was discovered. Changing the haste value to the old one(the live servers value that is) increases the gap even more.
The point of my post was that according to my own tests(unbuffed!) and acording to a different sheet, dragonMAW(not strike!) is better than S2 Mace and I think the sheet does not reflect the power of blacksmithing maces' proc. Just consider it a lesser version of the unnerfed dragonspine: high ppm, no internal cd.

Chaplin · 09/11/07, 2:30 PM

I was wondering if there were any plans to incorporate Shiv spam builds as alternative methods of dps into the spreadsheet. Recently me and another rogue in guild have switched up our normal dps method when fighting mobs that can be poisoned. We use Anesthetic Poison in the off-hand and Deadly Poison in the main hand. Both using Merciless Gladiator's Quickblade in off-hand and Spiteblade in main hand. Both with dual Mongoose. We have found that our dps is substantially increased using the following method.

Cheapshot/Garrote/Other Opener
Slice and Dice
-----------------------------------------
Shiv till 5 pts
Slice and Dice
Shiv till 5 pts
Rupture
Shiv till 5 pts
Envenom
-----------------------------------------
repeat

It's an extraordinarily efficient method and I'd love to see it in the spreadsheet. I've been using the spreadsheet for as long as it's existed. Longer than I can remember. Thanks for all the work that's done on it.

• Vulajin · 09/11/07, 4:05 PM

Originally Posted by Chaplin

We have found that our dps is substantially increased using the following method.

Cheapshot/Garrote/Other Opener
Slice and Dice
-----------------------------------------
Shiv till 5 pts
Slice and Dice
Shiv till 5 pts
Rupture
Shiv till 5 pts
Envenom
-----------------------------------------
repeat

Substantially increased compared to what? In no sense is Shiv going to be better DPE than Sinister Strike, even counting Anesthetic Poison or Instant Poison. Additionally, you don't want to be using a poison on your main hand if there's any chance of having Windfury Totem. And then of course, if you are using Deadly Poison, unless you're Mutilate and using it on both weapons, you don't want to waste it by using Envenom.

In every sense you will be better off running 1s/5r with Sinister Strike.