Anddacin

Anyone know why my buffed sheet shows 1 agi being worth 17 ap and my unbuffed sheet shows 1 agi worth 2 ap? Something seems wrong there...

 

• Aldriana

Not of this sheet... however, the rogue gear sheet I've been working on as a side project (Rogue Gear Spreadsheet if you haven't seen it) has it partially implemented. I changed it to not reset the swing timer, although I haven't made the glancing blow/hit rate changes yet since I haven't seen confirmation of that yet. If someone could find the time to parse some random raid boss on test and get us some data, that'd be great.

 

chocopaati

I'm not too sure if anyone else has noticed but the proc chance for Warp-Spring Coil has been increased significantly on the PTR (http://www.wowhead.com/?spell=37173)

I just went to blasted lands to make sure this wasn't a bug and it seems to be accurate(although there looks to be a hidden cooldown of something around 30 seconds)

 

koaschten

We will be raiding black temple on Saturday. i will see that i dont forget to /combatlog

 

fool

/combatlog activates. If you want to save that and start writing on another, you need to exit wow i think..

am i wrong ?

since it stacks everything on 1.

 

◊ Sarutobi

Is that 30 seconds from when the proc first goes off? Or 30 seconds of downtime after the buff fades?

 

Cel

It dumps the combat log to one file, yes. Logging out causes the cached log to be dumped to the file, as does /reloadui. You can't tell it to save to a different file, however. If you want the files split, you have to do it manually or write a parser.

"There is much pleasure to be gained from useless knowledge." - Bertrand Russell

Alpha is recruiting... go go.

 

mubbers

More testing needs to be done, but after some 5-10 minutes of SS spam in Blasted Lands, it would appear that the WSC is now a viable upgrade to Abacus. I had an average of 35.5 seconds per proc, which would result in an average uptime of 42.3%, or -423 armor over time. Updating the trinket with this value in the spreadsheet, I ended up with the following numbers:
It's good to see a drop off a normal mode boss in a blue instance gets outdated once you start farming The Eye, but I can't help thinking that the Dragonspine Trophy is a wee bit over the top considering where you get it (I tested it on PTR as well, it remains the same as on live servers).

 

Grunge

Well Drakefang Talisman was also over the top. As was Neltharion's Tear.
If anything I'd like prefer it to be moved to another boss (as it was originally intended to drop from Magtheridon) rather than nerfed.

Fans glory to the Gladiators,
Gods glory to the Heroes.

 

Yamira

I have got similar values on fighting at a Blasted Land mob for exactly ten minutes. The results are nearly the same like you got.

I (10minutes):
WSC Procs: 17
SS: 192
Evi: 25
Swordproc: 64

II (10minutes):
WSC Procs: 16
SS: 182
Evi: 26
Swordproc: 52

III (10minutes):
WSC Procs: 17
SS: 186
Evi: 26
Swordproc: 54

 

Tyranis

I'm sorry if that has been brough up but I was wondering if there is a current sheet with the new changes to the gear from the PTR and if so can someone point me to a link plz?

 

Fifty

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

This should take a total of one minute to browse the past 3-4 pages and notice the latest patch number and spreadsheet upgrade, by now in this thread this should really go without saying.

On topic, yeah it seems WSC has been put in its supposed place, just under Dragonspine and Tsunami, above both Brooch and Abacus aslong as Romulo's.

Howmuch wood would a woodchuck chuck if a woodchuck would chuck wood?

 

rj

Ok I ran a bunch of tests and it appears sword spec still procs main hand damage and from what I can tell it won't effect combat potency either but I am not 100% sure on that.

Over an 18 min time span autoattack only, no haste buffs, no weapon enchants with a spiteblade/Gladiator Quickblade combo on PTR I got an average of 8.2 potency procs per minute.

I then ran a 13 min test with Malch/Shiv, both enchanted with mongoose but no other haste buffs on the same blasted land mob, auto attack only. I got 9.9 procs per minute with the Malch/Shiv combo (remember they both have mongoose as well). This seems right considering mongoose + 1.4 speed of shiv compared to 1.5 of quickblade.

By the way, the lowest sword spec proc hit for 376 which is out of the range of the quickblade.

Here is about a 30 min Blasted Lands log file for sword test if anyone wants to take a look to see if you can tell if combat potency procs off of offhand sword spec procs. Autoattack only, UN-enchanted Spiteblade and Quickblade, 1653 AP, 276 hit rating, 16/45/0 spec, 20.31% crit.

http://www.savefile.info/file/851/Swords-txt.html

 

• Aldriana

From that log:

So, the first and third lines are OH attacks, the second line is a MH hit, and the 4th line is a sword spec proc... followed by two combat potency procs. Now, one of them is clearly caused by the OH hit at 25.468... but it's hard to see what could have caused the second one other than the SS proc. Or at least, I can't see any other explanation.

 

Kersey

I also found this in the log. It looks like the two combat potency procs with identical times comes from the OH crit and the SS proc.

 

• Andeh

I've been poking around the spreadsheet to update it for the 2.1 Sword Spec changes. It looks like we only need to change 2 cells each on the unbuffed and buffed DPS sheets.

Cell H10 is currently:

[top]B2*(C21+C20*2+C19*Q9)/(C19+C20+C21)
this should be changed to:

B2*(C21+C20*2+C19*1)/(C19+C20+C21)
[Yellow sword spec hits now suffer no glancing penalty.]

Cell Q18 is currently:

[top](Q14*(M11/(M35+1)-lagfactor)/(M11/(M35+1))+(Q16+Q17)/2)*R11+(Q15/2)*R12
this should be changed to:

(Q14*(M11/(M35+1)-lagfactor)/(M11/(M35+1))+(Q16+Q17))*R11+(Q15)*R12
[The old method divided the number of extra attacks generated by CP generators, Evis/Rupture, and offhand hits by 2, to account for sword spec only zeroing the swing timer. Removing this divide by 2 treats them as true extra attacks.]

I'm pretty certain this is all that needs to be changed. Let me know if I missed anything.

 

Noctral

The lowest time I've seen so far is 30 seconds between buff gains:

5/18 15:26:31.553 You gain Perceived Weakness.
...
5/18 15:27:01.475 You gain Perceived Weakness.

 

pf

Yellow attacks cannot use the same hit tables as white attacks. If sword spec can be dodged, the critrate will be slightly off if you use the white hit table. The only problem I see is that an item like blinkstrike might not follow a yellow attack, and thus would have to be done differently, and Q14 needs to be set to =Q13 since you no longer "lose" possible mainhand procs when our offhand/specials proc sword spec. Also, lots of stuff in the nextstat sheet need to be changed.


Edit: Also, I got bored and decided to create a demo of how to provide better next-stat values. It only includes +1ap and +1crit, but can easily be expanded to include more if you edit the macro correctly (it uses the old spreadsheet as well, so just copy/pasting the macro into a newer version should work). The only downside of this is that I do not believe it will work with OO. However, the rest of the sheet should remain intact and work properly in OO while providing better next-stat values for Excel. One last thing, you have to run the macro after you complete your gear/talent choice as it does not update itself.

Link: http://rogue.bleedo.net/RogueDPS_2.2.4testmacro.xls

 

• Andeh

Good catch Pf. While I don't have log/photo evidence, I think it's safe to say that they can be dodged.

So instead...
Cell H10 is currently:

[top]B2*(C21+C20*2+C19*Q9)/(C19+C20+C21)
this should be changed to:

B2*(I21+I20*2)/(I20+I21)
[Yellow sword spec hits now suffer no glancing penalty.]

Edit: I'm not overly concerned with Blinkstrike for the moment, since it isn't something that people will be using forever.

Edit 2: Sweet merciful crap, NextStat really did get borked by all this. I will take a whack at it later.

 

pf

R11 and R12 need to be changed to follow column I as well. And if Sword procs cannot proc themselves anymore, that formula needs to be redone to just be =q11*hit%. Combat potency procs from sword procs would have to be modeled in L1 of the cycle sheet (shouldnt be too hard to figure out sproc%*cpot%*permahaste/speed*energy). Oh, and it should be (I20-if(instatk="bs",impbs,0))*2 for H10. This would idiot proof it better.

Fixing up the sword proc formula was the original reason I started editing the spreadsheet. Valor/chalon's versions lacked quite a bit of accuracy as they did not truly understand how it worked. That formula took me quite a while to get just right too, especially after having to add the lagfactor. It is almost a shame they are removing the mechanic since I spent a bit of time trying to model it in its whacky state. However, new sword spec is overpowered and will probably be nerfed just after you finally get the formula just right

That is why I suggested the macro in the above post. With more than 1 person editing the math, it really is a lot to ask that the nextstat sheet be kept up as rigorously as I did.

 

Anddacin

Here's a 5 minute autoattack on a servant with sword mh/dagger oh, in case anyone can find any use out of it (was checking some other useless stuff).

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

Weapons are Vindi's/GM Shiv, gear is some mix and match junk, trinkets are dragonspine and warpspring coil. No abilities, buffs, poisons.

 

• Aldriana

So, random crackpot theory:

It's looking like Sword Spec may proc combat potency when triggered by an OH attack.

Earlier testing indicated that OH SS Procs weren't applying poison from the MH.

So, crackpot theory: Maybe OH SS procs trigger an OH attack that does MH damage? Meaning that, the damage range is determined by the MH, but the procs and stuff are determined as though it were an OH hit? It would certainly explain both of the above.

Natural way to test this would be to do the standing-sideways-spam-Shiv trick where you have no white attacks, with Instant Poison on the OH. If this theory is correct, parsing for 1000 shivs or so should yield both a double-potency proc and a double-poison proc, which would seem to be pretty strong evidence, on the whole.

As I've been having trouble getting on test, I can't try it myself; but if someone can find time to test it I'd be interested to see the results.

 

Anddacin

If I have some time later, I shall. I assume you want a sword in the OH?

 

• Aldriana

Yes, swords in both hands.