Rogue DPS Spreadsheet - Page 181

Cyn · 07/11/07, 11:50 PM

I love the new upgrade functionality, however i've found 2 issues.

The ranged Upgrade button appears to trigger the neck piece upgrade macro.

And using the leg upgrade macro, i watched it find at least 1 leg upgrade (Square flashed green), however the macro returned "no dps upgrades", and in trying to put in Slayer's legs, they were indeed an upgrade.

Rinced · 07/12/07, 3:03 AM

Clicking on the "All" Button in the Gear_Buffs Sheet made Excel Freeze.

Spreadsheet Version 2.3.6
Excel 11.3 (060914)
Mac OSX 10.4.9

The bottom of the Window showed "Calculating Cells 100%"

evl · 07/12/07, 5:03 AM

The socket cell for cloak (B40) doesn't display the name of the selected gem but it's calculating it.

Ellos · 07/12/07, 5:53 AM

Originally Posted by Cyn

I love the new upgrade functionality, however i've found 2 issues.

The ranged Upgrade button appears to trigger the neck piece upgrade macro.

And using the leg upgrade macro, i watched it find at least 1 leg upgrade (Square flashed green), however the macro returned "no dps upgrades", and in trying to put in Slayer's legs, they were indeed an upgrade.

This bugs should be fixed in the next version. I think I'll release them in a few days.

Originally Posted by Rinced

Clicking on the "All" Button in the Gear_Buffs Sheet made Excel Freeze.

Spreadsheet Version 2.3.6
Excel 11.3 (060914)
Mac OSX 10.4.9

The bottom of the Window showed "Calculating Cells 100%"

All upgrades I think? Well maybe it's fixed in the next version, there will be another subroutine

Originally Posted by evl

The socket cell for cloak (B40) doesn't display the name of the selected gem but it's calculating it.

In which Version? Got no Problems witch Excel 2007 and Open Office.

Think will be fixed in the next version, had controled all displayconditions.

Nextzor · 07/12/07, 1:48 PM

Quick question, has the bug with the Netherblade tier 2 been fixed so that it does not interprit it as a waste of combo points resulting in showing a 4s/5r combo instead of the 3s/5s/5r one?

Tenge · 07/12/07, 2:33 PM

The cloak socket issue is just a cell format/color problem. You can click in the cell and change the background color and text color via either the menus at the top, or the toolbar. (Excel)

Edit: I also agree that it might be prudent to start a new thread for Ellos' supported versions. Perhaps consolidate all of the currently-accepted theorycraft into a first post, with a link to the current sheet. I realize this may be a bit of an undertaking though, given the time-investment to wade through 109 pages to sift out the gems (and a lot of this may be covered in the theorycraft sticky at the top of the forum).

Rinced · 07/12/07, 4:52 PM

Originally Posted by Ellos

All upgrades I think? Well maybe it's fixed in the next version, there will be another subroutine

Well i dont know - actually it just displays "All" - might be a Scaling problem - same thing for other buttons - on 75 % the upgrade buttons show "Up" and on 200% they show "Upgra".

And somehow AEP goes down for hit & haste for buffed DPS … dunno - shouldn't it go up ?

Arioche · 07/12/07, 4:56 PM

Originally Posted by Rinced

Well i dont know - actually it just displays "All" - might be a Scaling problem - same thing for other buttons - on 75 % the upgrade buttons show "Up" and on 200% they show "Upgra".

And somehow AEP goes down for hit & haste for buffed DPS … dunno - shouldn't it go up ?

The button text is most likely a font issue. I cant speak for Ellos, but i use 1600x1200 resolution, so I imagine its just clipping the text on yours. If you right click on the buttons youll get the small handles to strech the buttons larger.

LiteSabre · 07/12/07, 9:59 PM

Sword Specialization: This talent’s free extra attacks can no longer trigger additional extra attacks.

Well, we knew it was coming, but will this nerf really make that much of a difference? It seems to me that the gap between daggers and swords won't really be bridged by this, at least not completely.

Siq · 07/13/07, 1:39 AM

Originally Posted by LiteSabre

Well, we knew it was coming, but will this nerf really make that much of a difference? It seems to me that the gap between daggers and swords won't really be bridged by this, at least not completely.

Just change R12+R13 in buffed and unbuffed dps sheets to
R12 -> =(1-C18-C19)*Q12
R13 -> =(1-F18-F19)*Q13

Somehow this results in 0,5-1 less dps. We can't even call this a nerv oO

Grym · 07/13/07, 2:07 AM

Originally Posted by LiteSabre

Well, we knew it was coming, but will this nerf really make that much of a difference? It seems to me that the gap between daggers and swords won't really be bridged by this, at least not completely.

What are the implications? Sword spec doesn't proc: poison, sword spec, windfury, and other effects? I'm not even sure which of those worked before, windfury could be pretty significant though.

Tryss · 07/13/07, 2:58 AM

Originally Posted by Grym

What are the implications? Sword spec doesn't proc: poison, sword spec, windfury, and other effects? I'm not even sure which of those worked before, windfury could be pretty significant though.

I was under the impression that it simply meant it cannot proc off itself.

Apsalar · 07/13/07, 3:04 AM

That is the impression i get as well although i thought they had removed that ages ago.

Zurgat · 07/13/07, 3:25 AM

Originally Posted by Apsalar

That is the impression i get as well although i thought they had removed that ages ago.

I was under the impression that they removed all procs proccing from other procs ages ago.
But seems in 2.2 they are making some change to it : http://forums.worldofwarcraft.com/th...74505927&sid=1

E.g. :
Instant poison can't proc Swordspec,
Instant poison can't proc Hand of Justice,
Swordspec can't trigger another Swordspec,
Swordspec can't trigger Windfury,
Swordspec can't trigger Romulo's poison vial / Maelstrom,
Lifestealing can't trigger Swordspec,
Windfury can't trigger Swordspec.

(These all used to work iirc)

evl · 07/13/07, 4:12 AM

I've got somewhat of a newcomers question: Will the spreadsheet take into account balance between hit/crit/ap meaning will the value of hit decline as I close in on 300?

Also the Gear Spreadsheet; another thread gives me completely different results, I reckon these two are separate but which one paints the more correct image? (e.g Crystalweave Cape with crap stats and +26 haste rating is rated as a lot better than say Vengeance Wrap with +8 hit in the socket)