I also did som testing on Dr. Boom. I focused on number of shot fired, instead of DPS, because I find it more clear and not luck (crit) based. What I did was this: I was counting the number of Auto Shots and Steady Shots fired during the 2 minute period, while changing the haste rating for each test. I also did it with the new 3:2 macro and with AotV and only with Leggionkiller (base speed 2.9)

My discoveries:
1, The number of Steady Shots was always the same, no matter if my haste rating was 0 or 95 (or between these numbers).
2, The number of Auto Shots varied based on haste, but in very small chunks i.e. with 95 haste (1.98 attack speed, instead of 2.1) and period of 2 minutes, it fired like 2-3 more Auto Shots. (The number of Auto Shot might also be influenced by latency, which at the time of testing was ~150 ms)

So my personal conlusion is that with new 3:2 macro, haste rating is not as good as for example crit (which is often lacking the haste items), because it only affects 1/3 of your shots. I think it also affects SS, but you need more like 95 haste.

I'm going to do some more testing with improved AotH and report my findings.

What do you mean by "the new 3:2 macro" and a 3:2 rotation as a whole? I have seen it a lot lately, but I couldnt find a good example of this kind of rotation. There are also a lot of macros spread all over the forums.

I know that this is not the best place to ask this question so I want to apologize.

This post by synergi quotes and links a post by howitzer from the WoW-forums.
Howitzer explains the theorie and technique of this new rotation model.
http://elitistjerks.com/f31/t11420-h...ing/p106/#2632

In reality all the new macro results in is a Steady Shot spam. Most of it is just garbage, but what it tries to do is cast Steady Shot as often as possible, and let Auto Shots fire when they can in between chains. A lot of people see the pattern Auto, Steady, Steady, Auto, Steady (repeat), yielding 3 Steady Shots for every 2 Auto Shots.

In pouring over logs I think this only really works because latency isn't constant, and anytime it increases you have a greater chance of getting an Auto Shot through. The GCD on the client prevents lowering latency spikes from providing much of an effect.

I've used this spreadsheet to check out how to max out my dps, and for the shot rotation it seems the 1:1 priority rotation is the best one. I get like 40 extra dps then the Steady/Auto Shot.

Now the problem is, I don't know the 1:1 priority macro. Is this just the Auto/Steady Shot "spam" macro, spamming this macro while also clicking on both arcane & multi whenever their cd is off?

1:1 priority is having 1 special between each Auto Shot, but giving e.g. Arcane Shot priority over Steady Shot. So, if Arcane Shot is ready, you would use that instead of Steady Shot.

In most cases, this leads to higher DPS (due to Arcane Shot dealing more damage than Steady Shot on average). It does, however, also increase mana usage.

It all depends on your hasted weapon speed. For the macro to really shine your steady shot has to finish casting in the 0.5s auto shot window, or pretty well near it.

In my case it looks like I'm able to tune my weapon speed so I fire about 1.16 Steady Shots per Auto. I've been able to increase my rate of fire to 1.25 shots per second (up from 1.1).

Also a larger proportion of my shots are steady shots, which overall do much more damage (T6) and increase the value of my Ashtongue Talisman.

I was just looking through the calculations tab and it shows that the 'Proc Duration' on [Band of the Eternal Champion] is 15. Tooltip shows it as being 10 seconds. Was wondering if the 15 is referring to something else, or just a mistake?

I did some testing yesterday, but didn´t have the time to look closer at the logs yet.
What I did was buying 1000 cheap Arrows/Bullets. I wrote a very simple macro.
I then proceeded to spam this macro at Dr. Boom until either he died or I run oom. I repeated this until I´ve used up all my ammo so I should have a sample size of exactly 1000 shots. I did this with a 3.0 weapon as well as with a 2.6 weapon both with and without quiver haste. I´m planning on doing the same again with 5/5 SS. I used my G15 keyboard to spam the macro in 50ms intervals. My latency should have always been well below 100ms on an average 50ms too.

I´ll post the results as well as the logs here as soon as I´m done with my testing.

Would it be possible to add one more list to the spreadsheet which would show table similar to Shadowpanthers rogue armor chart (http://shadowpanther.net/armor.htm)?
It should be pretty easy considering you got all items in the sheet already...it would be even better then then the Shadowpanthers one, because you can sort the armor chart (based on the "weigth" of each attribute) each time you change gear.

Hello,

When I'm trying to use the 1:1.X Option in the spreadsheet for my Survival 1:1.5 (both arcane & multi) rotation the behavior is strange. It starts out as a 1:1.5 but then in places it will use 2 sequences of Auto/Steady in a row without weaving in a multi/arcane. The result is the rotation comes out to be a 1:1.4 or something like that and I have to manually correct the mistakes.

Is this behavior intended or is there something I am overlooking? I am using version 42.

Yes you are exactly right, keeping up 1:1.5 is impossible without clipping. Cycle Time increases when I manually put it in but DPS jumps by a considerable amount.

Thanks for the clarification.

No problem. I didn't build in enough intelligence to the rotation-generation code to weigh clip time vs. DPS increase. Always feel free to hand build rotations when you think you have a better pattern.

FYI, raptors have been able to use Dash for awhile now, but the spreadsheet lists it as wrong family.

As it doesn't affect DPS I hardly see this as a needed fix.

Once again to Cheeky (and whoever else helps him), this spreadsheet is amazing.

I was using the spreadsheet this morning at work for a while, and thought of a couple things that might be handy in future versions. I dont know how hard/easy this stuff is, just throwing the ideas out in the open incase they didnt cross your mind!

1) On the gear selection tab, have a cell next to each item that shows that particular items 'worth' in dps. Just something simple like:

worth = (total dps with the item equipped) minus (total dps without item equipped).

Sure its uses are a little limited, but I think it would be interesting seeing how different slots worth varies. And also for comparing rings/trinkets on the fly.

2) When I make gear changes and compare the hunter/total dps, it would be great to be able to undo and redo (ctrl-z ctrl-shift-z). Maybe it's just my version of excel (2007), but I have trouble undoing changes to gear tabs.

3) Now this is just pure laziness on my part: how hard is it to have auto-complete for typing in gear slots? The style where the dropdown list pops down and selects the closest thing to what you're typing. Scrolling up and down from Band of Eternal Champion to Stormrage Ring/Signet Ring of Primal to compare dps with different hit values ftl! This situation would also be nice with the undo/redo feature. Again, this might just be an Excel version issue (or a user issue).

4) The spreadsheet needs to make me a coffee in the morning and bring me drinks to my PC while raiding.

If I had to guess I'd say the two-roll change (since you're below hit cap, at least on armory) is the main reason. Also, pet FI uptime decreased across the board in these versions because of that bug fix.

I think the uptime has been increased from the previous version, not decreased. I believe extra specials from GftT was somehow causing less FI's (a bug obviously), which is now fixed, resulting in the correct uptime.

It worked as a reduction. I was using the frequency of specials at 1/X, where X was the time between them. I needed to be using X itself as the value. (So instead of you getting a special every 1.5 seconds in a focus-flooded situation, it was every 0.67 seconds, resulting in more chances to proc per period.)

In the works is a feature to allow you to sort/view gear by DPS (based off current ratios.)

I have no clue how to do this. Not sure if it's something Excel even supports.

See #2.

Only my Beta version does that. There will be a small charge for releasing that feature to the general public.

Heh, reminds me of that bloke on Letterman that made a portable robotic fridge that would sense where you are (via a remote I guess), navigate to you, then throw your favourite canned beverage to you, upwards of 5 metres away.

Anyway, I just thought of another feature to keep you busy!

On the gear tab, at the top it has crit and hit chance (for level 73 default, which I love). Any chance of making the hit chance go above 100% when you are over the cap? Just to know at a glance how much over you are.

Any info on this?