Rogue DPS Spreadsheet - Page 88

x1tiger1x · 06/14/07, 4:20 PM

Is there a working link to DL the updated version? Link on the first page isn't working.

laforce · 06/14/07, 5:00 PM

Originally Posted by Hanos

The cooldown is somewhere between 30-40 seconds based on testing in another thread. I have been using it for a couple weeks now, and have the WWS logs for it showing more than 1 PPM. I would say that you get 1 proc every 45 seconds on average. I will update this with the specifics from all the rogues using them last night in our raid once WWS actually loads up.

Ok, 4 rogues with it, 7-8 min fight (Fathom Lord) we had 4, 7, 7 and 8 procs.

Looking at most of the other fights, 1 PPM is pretty reasonable, so atleast 24 Haste, 36 isn't unreasonable.

36 Haste means 1,5ppm, or 1 proc every 45 sec... Since in a 8min fight you had 4, 7, 7 and 8, that's an average of 6,5 procs in a 7,5min fight... 0,86ppm

Im gonna start testing when I get home.. damn I hate work.

mih · 06/14/07, 6:53 PM

http://www.savefile.com/files/809905

2.2.7a
added
Arena Season 2 Items (Set + Weapons)

changed
Ring of Devastation -> Band of Devastation
boss armor -> ~7000

Dread · 06/14/07, 7:44 PM

Originally Posted by mih

http://www.savefile.com/files/809905

2.2.7a
added
Arena Season 2 Items (Set + Weapons)

changed
Ring of Devastation -> Band of Devastation
boss armor -> ~7000

Sorry for repeating myself but Rod of the Sun King is still heavily overvalued..
Its 1.3 procs per minute not 12 procs per minute.

zkygge · 06/14/07, 8:49 PM

Originally Posted by Dread

Sorry for repeating myself but Rod of the Sun King is still heavily overvalued..
Its 1.3 procs per minute not 12 procs per minute.

This is my procwatch from hitting a Servant for 25 minutes, using Rod of the Sun King - a relatively small batch of data. But here it is nonetheless.

• Aldriana · 06/14/07, 8:57 PM

Are those parses autoattack or with specials? Did you have an OH weapon equipped or not?

benybenson · 06/14/07, 9:47 PM

anyone know, can Warp-Spring Coil still procc from sword-speccs after change them from yellow to white in 2.1.2 ?

Dread · 06/15/07, 7:56 AM

Originally Posted by Aldriana

Are those parses autoattack or with specials? Did you have an OH weapon equipped or not?

Mine is from a raid, so most of the time SnD up, plus Dragonspine/Mongoose hastes, meaning im giving it a fair extra chance for it to procc.
Shouldnt matter too much thou as im looking for procs per minute and not proc % chance.
(the other two from 2-3 pages back is from 10 minutes at servants Spamming SS and SnD but shows the same thing)
And that is not 12 ppm.. that would be an insane proc and the truth is that it is utterly useless :P

Jarush · 06/15/07, 8:35 AM

Talon of Azshara vs. Arena season 2 Gladiator's Slicer

2.7 speed vs. 2.6 speed
better dps stats vs. +4 dps
same average damage

Which one is better raid dps wise?

zkygge · 06/15/07, 8:37 AM

I had OH equipped (1.4 speed) and I used SS/SND and also Dragonspine Throphy. What kind of data would you need to model the PPM precisely in the spreadsheet?
I wouldn't say it is utterly useless, far from, but I somehow doubt that the proc would make it the best PvE weapon (It looks like it is in the spreadsheet(?))

Xizenta · 06/15/07, 10:30 AM

Originally Posted by Jarush

Talon of Azshara vs. Arena season 2 Gladiator's Slicer

2.7 speed vs. 2.6 speed
better dps stats vs. +4 dps
same average damage

Which one is better raid dps wise?

The Talon is still better,

Triton · 06/15/07, 10:59 AM

Originally Posted by Xizenta

The Talon is still better,

They come out very close on the spreadsheet for me with my current gear but the Talon is slightly ahead. Now it's just a question of whether I can earn 2,000 arena points before having a Talon drop off Morogrim. (Most likely yes given my prior luck with weapon drops.) It still feels weird to me to have alternative sources of good weapons beyond just killing a boss every week with my fingers crossed for a lucky drop.

mih · 06/15/07, 11:39 AM

http://www.savefile.com/files/812004

2.2.7b
added
New PVP Items
Flamecap

changed
Rod of the Sun King 12ppm -> 2,5ppm
Thundering Skyfire Diamond 1,5ppm -> 1ppm
Tsunami Talisman 1,3ppm -> 1ppm
Dragonspine Trophy 120 -> 90 haste

fixed
Syphon of the Nathrezim formula

• Shifft · 06/15/07, 12:08 PM

Fist/Sword spec was brought up in another thread around here (MH Fist/OH Sword). The only DPS talents you lose from picking up both are Vitality if you had it, and 1 point in assassination (at least for me since I would drop Imp Kick too). Anyone else think it's just an incredible idea? I'm going to test it out tonight on PTR and if it's as amazing as it seems it would be, gonna just go for that pair of gladiator weapons.

Might be no point even whining about the offhand fist being 1.8 speed if this is good =)

Statix · 06/15/07, 12:59 PM

I'm a little new to the spreadsheet so I apologize and please bare with me...

I'm trying to get the spreadsheet to work with Mutilate spec and it doesn't appear to be. No matter what I choose for Mutilate under Talents the value is False. Backstab is listed in my dps (which I figured might be a display issue) but nothing changes when I select Target Poisoned. Am I missing something?

Siq · 06/15/07, 1:28 PM

http://www.savefile.com/files/812247

2.2.7c
changed
AEP Section:
- added Button for easy macro usage
- added note, that it doesn't work with OpenOffice
- if mhtype=ohtype it now shows only one "Weapon Skill" entry instead of sepperat ones if mhtype!=ohtype
some changes to the macro itself
-> now ap+agi uses temp string, too

@mih:
Please be carefull with adding new rows to the Gear_Buffs Section, the macro uses the 77 and 129 lines -> simply adding a new line kills macro functionality unless you fix it in the macro, too

@pf:
I tried including all of your mentioned points, again I would appreciate if you could shortly look over the changes

(especially I'm not sure wether the agi part of the macro now works correctly)

Lucke · 06/15/07, 1:35 PM

Long-time dagger rogue thinking about sword spec - I am unable to snag the specsheet, so having to ponder on the board (my appologies). Since humans recieve the 5 swd skill perk, I have been considering picking up swords with my banked arena points next week. Would this necessarily be much of a deal-breaker to choose swords > fists? I am primarily PVE, with PVP ambitions.

• Aldriana · 06/15/07, 2:05 PM

Originally Posted by Dread

Mine is from a raid, so most of the time SnD up, plus Dragonspine/Mongoose hastes, meaning im giving it a fair extra chance for it to procc.
Shouldnt matter too much thou as im looking for procs per minute and not proc % chance.
(the other two from 2-3 pages back is from 10 minutes at servants Spamming SS and SnD but shows the same thing)
And that is not 12 ppm.. that would be an insane proc and the truth is that it is utterly useless :P

Yeah, I mean, obviously it's not 12; however, when you're getting 1.3 and the other test is getting over 2, it seems to me a little more investigation is needed to get the "true" proc rate.

The reason why I ask is because if you have an OH, that's going to skew the PPM numbers because, last I checked, procwatch can't tell the difference between MH and OH swings.

Originally Posted by zkygge

I had OH equipped (1.4 speed) and I used SS/SND and also Dragonspine Throphy. What kind of data would you need to model the PPM precisely in the spreadsheet?
I wouldn't say it is utterly useless, far from, but I somehow doubt that the proc would make it the best PvE weapon (It looks like it is in the spreadsheet(?))

To get a good test you'd want to unequip your OH and go beat on a Servant for a while, so as not to have OH hits cluttering up the proc rate info. Sinister strikes and SnD are fine; just need to get rid of the 2nd weapon.

pf · 06/15/07, 4:43 PM

Originally Posted by Siq

@pf:
I tried including all of your mentioned points, again I would appreciate if you could shortly look over the changes

(especially I'm not sure wether the agi part of the macro now works correctly)

Looks good, except +skill is not correct yet. (and you removed buffed haste/armor, doh) I would also suggest that you run all +1's through unbuffed only and let the buffed part pick it up from that line (like you did with agi), the only exception would be AP since it does not use row77 to calculate buffed AP like the rest do. Doing so should make the macro run a little bit faster.

    Sheets("Unbuffed DPS").Select
    Temp = Range("Q7").Formula
    Temp2 = Range("Q8").Formula
    Range("Q7").Formula = Temp & "+1/skillrate"
    Sheets("Gear _ Buffs").Select
    If Range("x10").Value = Range("x16").Value Then
        Sheets("Unbuffed DPS").Select
        Range("Q8").Formula = Temp2 & "+1/skillrate"
    End If
    Sheets("nextstat2").Select
    Range("B9").Formula = Range("b1").Value
    Sheets("Unbuffed DPS").Select
    Range("Q7").Formula = Temp
    Range("Q8").Formula = Temp2

That code should work for unbuffed MHskill so OHskill gets +1 rating iff mhtype=ohtype. Copy that code to work for buffed MHskill and leave OHskill alone.

One last suggestion would be to change the button to say "Calculate AEP" instead of "Run AEP Macro" as it makes it more excel noob friendly.

Stabmaster · 06/15/07, 4:54 PM

FYI for Mutilate Rogues:

I'm normally Combat Daggers and I have observed a ~1 PPM rate for the Thundering Skyfire Diamond over the course of a night's raiding.

I respecced Combat Mutilate again last night, and observed ~1.4 PPM. An increase is expected in procs from the meta-gem, DST, etc. as every Mutilate counts as two hits for the purposes of procs (MH + OH).

Just a heads-up that any of these effects are undervalued for Mutilate Rogues, and to keep that in mind when evaluating specs and gear.

Pork · 06/15/07, 7:39 PM

Originally Posted by Stabmaster

FYI for Mutilate Rogues:

I'm normally Combat Daggers and I have observed a ~1 PPM rate for the Thundering Skyfire Diamond over the course of a night's raiding.

I respecced Combat Mutilate again last night, and observed ~1.4 PPM. An increase is expected in procs from the meta-gem, DST, etc. as every Mutilate counts as two hits for the purposes of procs (MH + OH).

Just a heads-up that any of these effects are undervalued for Mutilate Rogues, and to keep that in mind when evaluating specs and gear.

This is purely anecdotal, but most of my raiding pre-SSC was with 41/20 and it made a huge difference in terms of Mongoose, and DST uptime. Combat daggers on the other hand is without a doubt the worst raiding spec for taking advantage of proc gear/enchants. On a side note, I'm really excited about the prospect of being able to use the Ashtongue trinket with a 41/20 build at some point in the future, considering that it's basically a 134 crit rating passive trinket in the hands of a mutilate Rogue.

benybenson · 06/15/07, 7:50 PM

Originally Posted by benybenson

anyone know, can Warp-Spring Coil still procc from sword-speccs after change them from yellow to white in 2.1.2 ?

tested about 1000 hits just autoattacks , about 55 swordspeccs without a coil procc
maybe its overratet on the spreadsheet

paper · 06/16/07, 12:28 AM

Siq: your lastest version seems to have problems calculating haste. Try manually adding some haste on any item and You'll notice it does not affect the dps results.

mih · 06/16/07, 5:57 AM

http://www.savefile.com/files/813990
2.2.7d
fixed buffed dps (haste, -armor, ap)

Siq · 06/16/07, 11:06 AM

http://www.savefile.com/files/814449

2.2.7e
some macro changes/fixes
added a part for snd cut cycles in the FAQ section

sorry for deleting those 2 fields, happened while testing the macro :/