[Rogue] DPS Spreadsheet - Page 8

Ellos · 07/22/07, 2:28 PM

Uploaded 2.2.0.6

only minor changes
http://rogue.raidcal.com/

2.2.0.6 (ellos)
added
Include racial button (Racials Change, Troll Berserk 20% cost 10 Energy every 3 min; Blood Elf gives all 2 Mins 30 Energy)
unique Gems can only taken 1 per Equip now
Choose for Upgrade search which data you want. Buffed DPS, unbuffed DPS or Both
5 ranks of misery
Hemorrhage Boss debuff
deleted Items (Band of Anguish, Blackhand Breath, Blackout Trunchen)
AP Factor for all cycles
Import-Choose (Want to import Equip, Gear and/or Buffs)
Ring of the Recalcitrant

changed
Saveplace for import/export Macro, should now work on all OS and the added sheet will be deleted after import

Next Version will take some time I think, will try to work on import function from armory, and maybe change something at the procs. Will see.

Nimro · 07/22/07, 2:58 PM

Thank you very much Vulajin for the answer.

Lets see which one drops first.

Kudos to all who works with this awesome sheet.

Radmsc · 07/22/07, 3:45 PM

I have some problem ex- and importing my gear from 2.2.0.5 to 2.2.0.6. Any1 else has a problem as well?

Ellos · 07/22/07, 4:45 PM

Got no problems with import export, just tested it.

Radmsc · 07/22/07, 5:00 PM

hmm, prolly a prob in my office programs, reïnstalling it now

BlackCadian · 07/22/07, 5:06 PM

Umm I just noticed that the spreadsheet values the Netherblade Facemask higher than the Deathmantle Helm (14 Hit vs 11 AGI & 25 Crit Rating).

Could someone please clarify this? To be honest, it doesn't make sense to me on 1st glance... :-/

Dulak · 07/22/07, 5:11 PM

Netherblade activates a set bonus for you and Deathmantle does not?

BlackCadian · 07/22/07, 5:15 PM

Originally Posted by Dulak

Netherblade activates a set bonus for you and Deathmantle does not?

duh, thank you!

I knew it had to be something obvious...

Ellos · 07/22/07, 5:16 PM

Last time I often hear OH extra hits should now be doen by the offhand.

Are there any test for this. Don't know which one is right now.

• Vulajin · 07/22/07, 5:17 PM

Sword spec procs result in white MH swings, regardless of the hand that caused the proc. This will not change.

Radmsc · 07/22/07, 6:18 PM

ok, I'm definately getting an error from the spreadsheet, it's not from my version of excel I'm using.

When I import in 2.2.0.6, the cells which are supposed to tell my (un)buffed dps say "#N/A".
When I open debugger it tells me the error is in this line: change = Workbooks(RogueDPS_Itemfile).Sheets("Gear _ Buffs").Cells(copyrange.row, copyrange.Column).Value

I guess I have to insert all my gear manually again :\

Ellos · 07/22/07, 6:22 PM

Ah.. I see, I've made an error in 2.2.0.5

To fix this, you have to open the export Macro code.

At the beginning there is this line:

' ActiveWorkbook.SaveAs Filename:="C:\RogueDPS_Itemfile.xls"

you have to delete the ' in front of this line. Then it should work.

Radmsc · 07/22/07, 6:42 PM

ok, that's solved now, but still the dps cell says #N/A to me.

I also noticed an other bug in 2.2.0.6.
When I push the upgrade gem button, there's something strange going on in the comment of the cells. It sometimes says there's an upgradable gem, tells me the amount of upgraded dps but tells me no name. Then an upgradable gem underneath that it says "(Yellow Gems)" and underneath that it tells me 5str/4hit is better than 4agi/4hit. Which is absolutely not true. I think there's something going wrong with assigning the cells with the correct names.

• Aldriana · 07/22/07, 6:58 PM

Originally Posted by Nimro

I expected little more constructive comment than that, well anyways..

I should have explained little better, ive been using this sheet since 1.x.

This sheet is showing WSC better, but Rogue Gearsheet is ranking TT higher.

Its littel confusing.

Whisch one is correct?

Rogue Gear Spreadsheet has a bug in it right now that it causing it to misvalue WSC. WSC is very comperable to TT, but until I update the sheet I couldn't say for sure which is better.

Devil Warrior · 07/22/07, 7:29 PM

Seems like ring enchants are also broken. If I select Enchanting, the options that pop up are "none", " ". "0" and "RING ENCHANTS".

Ellos · 07/22/07, 7:51 PM

http://rogue.raidcal.com/

2.2.0.7 (ellos)
fixed
a Problem with the Gem search
a Problem with some Enchants

Hope it works now

Greywyn · 07/22/07, 11:21 PM

Is there an add-on that will automatically show and update depending on gear change/gem socketing for rogues? I know there's one for Hunter AEP that I use (very useful).

Duskmourn · 07/23/07, 12:22 AM

http://i40.photobucket.com/albums/e2...kmourn/WSC.jpg

I posted this in an edit on the WSC thread. If my calcs are correct it would mean a 375 sustained armor pen. That is on live with max hit, using all of my abilities and a 1s(cut)/5evis cycle mostly. I would assume it to be slightly higher had I used a 1s(cut)/5r cycle throughout. I haven't been able to get on PTR yet due to transfer waiting list, but I assume there isn't a change anyways.

1.5ppmx15sec=22.5sec/60sec=.375x1000armor=375armor.

ruizAw · 07/23/07, 5:40 AM

2.2.0.7

if i simple change "Netherblade 4p bonus" to "false" in table "set bonuses" i have +buffed DPS?!!..

and "find upgrade items" not count set bonuses - i have upgrade for all my Netherblade items

(malefic mask of the shadows, grips of the deftness etc.)

Ellos · 07/23/07, 7:03 AM

Which cycle do you have with and without the bonus.

You'll find the same Problem with the Upgrade with the gems.

There would be too much possible combinations. Well, building this in would easy, but will you realy wait 5 mins or longer until the upgrade is ready to look at?

Zurgat · 07/23/07, 8:15 AM

Originally Posted by Ellos

Uploaded 2.2.0.6

only minor changes
http://rogue.raidcal.com/

2.2.0.6 (ellos)
added
deleted Items (Band of Anguish, Blackhand Breath, Blackout Trunchen)

You mean you re-added those three items?
I can see them in 2.2.0.7 (which is nice)

Upgrade search is not working yet on OSX.

Ellos · 07/23/07, 8:24 AM

Originally Posted by Zurgat

You mean you re-added those three items?
I can see them in 2.2.0.7 (which is nice)

Upgrade search is not working yet on OSX.

yes readded them.

I haven't found the error for OSX, don't know where there could the error, looks all correct.

Zurgat · 07/23/07, 8:34 AM

In regards to the AEP.
After you "calculate" it, it'll show the expected values.
But, as soon as you change anything it'll reset back to the default values.

Could this be changed in such a manner that any changes don't constantly change the AEP values?
You'd still have the manual update button / feature to make sure the values are accurate if you wished.

It might also be interesting to display an item's AEP value as a column in the "gear_buffs" list.

Also, since you changed the import/export functions, are these now compatible with 2.2.0.7 only?

Item error : If you select the [Band of Anguish], the DPS will switch to N/A, and the 3 columns where the BoA stats would be, will display ###

Ellos · 07/23/07, 8:52 AM

Also, since you changed the import/export functions, are these now compatible with 2.2.0.7 only?

No should be compatible until 2.2.0.3

only added the choice what you want to import, becauce the buffs often chance last time and then it can be possible that you import wrong value's.

At the over things I'll look later.

• Maestroquark · 07/23/07, 8:55 AM

I had a problem with import/export yesterday (2.2.0.6) where everything was showing as #N/A after an import. The root seemed to be that import was choosing no class instead of Night Elf.

Another issue with import/export seems to be a permissions issue. Where I'm typically delving into the sheet, I don't have permissions to right new files to the root of C:\. 2.2.0.6 was the first time I got a workaround for it, I manually saved the created workbook to my thumbdrive then just manually opened it before I hit import.