Korikin

Well, if we assume that the proc has a 45sec internal cooldown. (which seems popular these days) The average passive AP bonus would be (10/45)*(160AP) = 35.55AP I believe. And in reality it'll be a bit less overall.

 

Avellyr

When I made my own spreadsheets before, I always put them in a gear-ranking format so that I could see at a glance which item would be better for each specific slot without shuffling around a bunch of menus. Now that Cheeky's excel skills have basically made all of my efforts futile, I think it would be awesome if something of this nature could be implemented in this spreadsheet. I don't think it would be that difficult excepting ranged weapons, I would even do it myself if it wasn't locked.

 

Cheeky

This is actually in the works, by someone other than me. If I get a move on and finish up what I'm trying to do he can add the sorting feature. I just haven't near as much free time as I planned recently.

Cheeky of Havoc

 

Blueluck

Thank you for the Most Excellent spreadsheet!

I have a suggestion. Could you include Void Sphere on the list of gems? I think it would be useful while switching gemmed gear around to keep meta gems stable for comparison purposes.

 

• Relwin

Being largely bored at work today lead me to start playing around with spreadsheets again for a bit to see how much of an upgrade my last few coveted items actually are, and I have to say that the spreadsheet has certainly come quite a ways since I last used it. Thanks for keeping up with the mechanics and such.


Despite know that this would be a huge headache to implement and has already been tossed out the window, activated haste effect use would basically top off the sheet for me. But then again, only in theorycraft.

 

KergeKacsa

Could you place in Hellfire shoot too in the spreadsheet?

 

ron9

My Latency in game is always 150-250, so for the spreadsheet would my Latency in seconds be 0 or that is still atleast 0.2seconds of Latency?

With 0seconds of Latency using Steady Shot, Arcane Shot, Auto Shot rotation is 30DPS increase over Steady Shot, Auto Shot, Arcane Shot, Auto Shot.

With 0.2seconds of Latency which is default on Spreadsheet both those rotations are about same DPS.

Kill Command is used in both rotations also, any suggestions on what would be better to use out of those two rotations based on my Latency?

 

Xenoborg

Latency (aka ping) is measured in milliseconds, 0.001 s = 1.
so 250 ping is the same as a 0.250s delay.

 

Hunterlin

Just about new flawor rotation in 2.3.2 .
Can 1:2 rotation(plain steady-steady-auto) be added to some button?
May be some rotation sets be chosen from dropdown in case there will be more of them invented?
I myself do not use 1:2, but would want to model claimed dps increases with this rotation.

In tests 1:1.5 worked better for me on dr.Boom, but 1:2 was better than 1:1 with slow weapon, because 1:2 can be forced now to ignore latency.

 

ahhzz

Hey guys. Just wondered if anyone else had seen this. Was trying out diff points in specs, to see where I could tweak up some more dps (more spots than I care to mention ), and my IAotH started wigging. It's acting in reverse (it appears) for my profile only. The other profiles, it operates fine, but for mine, when I take away the 5 points, it jacks my dps, and when I add them back, it yanks it down... Thoughts? Or just rebuild the stupid profile, and hope it doesn't occur again?
thanks

 

Talrunya

Well it depends, are you trying a Survival based spec? If so then haste effects will actually screw your dps based on a 1:1.5 shot roation. Haste effects are better for BM and MM hunters, which is why you almost never see a Surv spec with IAotH. For Surv hunters the slower your attack speed better, which is why 2.90-3.10 weapon speeds are preferred over 2.70 or less.

http://sigs.guildlaunch.net/wsig.php/1938497mSwpZ.png

 

Cheeky

This probably means that the Shot Rotation for Quick Shots is less DPS than your unhasted Shot Rotation. Fiddle around with both to see what effects you get.

Cheeky of Havoc

 

ahhzz

Many thanks for the reply Cheeky! (and Tal ). I'm using the Wolfsniper, and I'm BM specced. Don't believe I screwed anything up with the different stats or gear, but maybe I'd better clear one of the other specs, and try to rebuild it. I'm sure it's just something oddball I did in messing with the different tabs. Thanks again guys.

 

Endugu

Found this sheet this morning and I already love it However, I found 2 things that I don't understand:

1: setting your trinkets to "none" will lower your pet focus regen, even to a negative number, lowering your pet dps. Not sure how or why.

2: I'm using steelhawk crossbow (2,8 speed) as a BM with Shoulders of lightning reflexes (37 haste rating). However, for some odd reason I put on Beastmaw pauldrons on in the sheet and noticed my dps went up. Kinda odd, since the raw stats on beastmaw are lower then on shoulders of lightning reflexes. Only thing I can think of is the extra haste, but that should not lower my dps. That would be like using rapid shots and watching your dps lower...

 

Thorongil

I can think of 2 reasons:

- maybe you have to recalc your shot-rotation after selecting the new item

- it may be, that the relatively low amount of haste that 1 single item grants you is too low, to result in a better rotation. On the other hand the higher petcrit on the beastmaw-pauldrons might result in a higher frenzy-uptime and therefore grant a not unsignificant higher pet-dps. These 2 things combined might lower your dps with the haste-item though it normally shouldn´t.

 

Cheeky

Hmmm. I'm not seeing this. If I change both of my trinkets ([Bloodlust Brooch] and [Tsunami Talisman]) to None, I see pet focus regerenation drop from 28.71 to 27.76, and that's purely from the crit change of not having the Tsunami Talisman. Any chance you can look at the focus regeneration section on the 'Pet Calculations' tab and see if anything looks screwy?

Cheeky of Havoc

 

Bikiniwax

Cheeky,

I thought this was fixed but I looks like there is still an import bug.

Using the S3 Helm, the Gear tab shows,

Cell A22 shows Red Socket 1, however my Meta gem (Relentless Earthstorm Diamond) loads next to it in B22
Cell A23 shows Meta Socket 2, however my Delicate Living Ruby (+8 AGI) loads next to it in B23

 

Bratac

i found it my bad

 

Joheltro

I'd love to see the new steady rotation as an option in your most excellent spreadsheet if posible.

I used it in the last SSC raid I was in with good results as an SV hunter. I have prior always used the 1:1,5 rotation, but wanted to see how good/bad the new rotation was in a raid enviroment. I was surprised to see just how good it was...

WWS report : WWS Loading...

Im the #3 on that list, with a DPS on 975. I linked the report anonymously to not disclose my fellow raiders.
The other two hunters are BM specced.

 

Thorongil

You say you are using a 1:1-rotation? I can´t seem to find a reason for not using 1:1.5 as SV. You should normally be lacking 25 - 30 % of total shots compared to 1:1.5

I also feel the autoshot-mechanic has somewhat changed but has it even become viable for SV-hunters to go 1:1?

 

Endugu

The thing is, there is no higher pet crit on the [Beastmaw Pauldrons]... The [Shoulders of Lightning Reflexes] have 4 more agi and 28 more ap. Beastmaw have 8 mp5 while shoulders of lightning reflexes have 37 haste rating, but even if my shot rotation was perfect, that should not lower my dps. Yet it does on the excell sheet :s

Uhm, me and excell.... I have something better for you: a screen shot



I hope this helps? this is with both my trinkets ([Bloodlust Brooch] and [Hourglass of the Unraveller]) unequiped. If you want I can give you a list of all my other equips.

 

JoeBravo

@Thorongil:

The WWS-parse shows 1274 SS and 620 AS, so it's not a 1:1 but a 1:2 rotation.

I've seen it discussed before on EJ, but can't seem to find the posts. :S

 

Cheeky

My spreadsheet doesn't model macros, it models shot rotations. If you can figure out what the shot rotation of that macro looks like for you, you can hand select the shots in the same order.

Cheeky of Havoc

 

Cheeky