Great test Midnight, but I miss one thing:
Your lag (and your lag variance).

I suppose your lag is lower than 230, am I right? (Speculation based on Test #4.)

Here are my meager results:

Macros used:

1:1
3:2
(pet was not summoned during testing)

Latency: 70ms - 110ms

No haste procs, aspect of the viper, each test was only 150 shots since I run oom on the 3:2 tests with larger samples (i had a stack of 150 jagged arrows equipped for each test).

Un-hasted Tests
3.0 speed bow, 5/5 SS, 15% quiver, 0 haste rating, 2.17 weapon speed
Wow Web Stats
Wow Web Stats


Hasted Tests
3.0 speed bow, 5/5 SS, 15% quiver, 58 haste rating, 2.1 weapon speed
Wow Web Stats
Wow Web Stats

DPS Calculation
The Average Steadyshot and Autoshot are my average values from the Calculation's page of Cheeky's spreadysheet, with my normal hasted/unhasted gear, with full raid buffs and target debuffs. I use them to calculate to total damage based on the number of shots in each test, get the dps time figure from the WWS summary page (which seems to be the time between first and last attack), and hence get DPS.

For the average values I had [Hourglass of the Unraveller] equipped instead of [Ashtongue Talisman of Swiftness], since I'm not sure how that would affect the average damages on the spreadsheet, while hourglass would affect both auto and steady equally. In-game the Ashtongue would probably benefit more from the 3:2 rotations?

Conclusions
Not a lot to conclude. I was surprised that hasted 3:2 came out on top for me, since it has a worse ratio (1.6) than unhasted (2.0). Apparently it fires those shots in much less time (140s instead of 150+ for all the other rotations) which gives it a big dps gain. I'm actually fairly pleased that hasted works out better both for 1:1 and 3:2 though, since it means i can switch from one to the other mid-fight.

I need to test 3:2 hasted again I think, i'm surprised at how much less time it took (if you can see anything wrong with the 4th combat log above, please tell me).

My latency should´ve been around about 50ms at all times.

Judging by the numbers, your 3:2 rotation is actually more like a 1:2 Steady Shot rotation. It gets closer to a 3:2 with more haste. Basically, you're pressing the macro to fast. Every other auto should end up firing 2 steadies. The auto between those should include 1 steady.

I thought pressing the macro as often as possible was necessary . But you're right, only the hasted 3:2 has the "auto steady auto steady x2" pattern (filtered log at Wow Web Stats ). The unhasted 3:2 (Wow Web Stats) from the same macro is "auto steady x2 auto" over and over, with occasional "auto steady x3 auto".

I'll try both again with lower spam rates (macro bound to mousewheel instead of keyboard).

At least for my tests this has been the truth though. The G15 macro produced a 0,05s interval spam which resulted in an almost perfect 3:2 rotation.

I've heard many conflicting statements about the value of armor penetration. Does the DPS increase from armor penetration scale linearly or not? I know that the amount of mitigation is not linear, as 5000 armor is around 32.1% mitigation, where 10000 is only around 48.6%. But according to tank theory, every point of armor is as valuable as the preceding one. 10k health, and are taking 1000 base physical DPS, then you would live

0 armor: 10.0 seconds
5000 armor 14.7 seconds (+4.7 seconds)
10000 armor 19.4 seconds (+4.7 seconds)
15000 armor 24.2 second (+4.8 seconds)

Shouldn't this work the same way for bosses too? But almost everything I had seen people say about armor pen suggests that it gets more valuable, either as you get more pen, or when fighting bosses with less armor. I think I even saw Cheeky suggest that 600 armor pen every 20 seconds was better than 100 armor pen constantly. Is everyone just misinformed, or does boss armor work differently than player's armor?

Here is a question about the new bow.

Will having ammo equipped, but not used, stack our auto shot damage?

No. This is why the actual bow DPS is ~50 higher than anything currently available.

All the G15 macro does is simulating a Keypress on my ´ key every 0,05s I then only had to keybind my testmacro to that key et voilá.

The value for tanks results of the relation to how much damage they get before and how much afterwards. A detailed explanation can be found here http://elitistjerks.com/f31/t18771-protection_warrior/ but basically it comes down to this:

You take a pre-armor hit of 10.000
10 % Armor will reduce it to 9.000 (mitigating 1.000 points of damage) providing 10 % mitigation.
If you reduce your damage bye another 1.000 you need more armor than before but you also get more than 10 % further mitigation (11,11 % to be exact).

So while needing more armor to get further mitigation you also get a greater relative benefit. That´s the reason why the dimishing returns on armor for tanks - while still existing - are not that high as one might think on first sight.

However, for damage dealers you can´t apply the same rationality. In fact, the system turns upside-down if you are the one who has armor penetration since every further point of ArP provides roughly the same relative damage-gain the absolute damage-gain will be higher.

So basically it´s a matter of whether relative or absolute values are the ones that are of interest for you.

Damage-increase in percent = ArP / (Boss_AC - ArP - Debuffs + 10557,5)

Example:
100 ArP
7700 Boss_AC
Debuffs: Sunder Armor (2600) + Feenfire (610)

100 / (7700 - 2600 - 610 - 100 + 10557,5) = 0,67%

No. Only the last test produced a 3:2 rotation. For 1000 shots at a 3:2 rotation, the target is 600 steadies to 400 autos. You have 2 series that are obviously broken, 5 that have ~333 autos and ~667 steadies, and 1 that has ~400 autos and ~600 steadies. The 5 that you refer to are actually a 2:1 steady:auto rotation.

I'm sorry to disturb your legendary discussion.

Bug Report:
Spreadsheed v.42 seems to switch 2 gems in my bow stitched leggins when it collects the data automaticaly from the armory.
Because of this the socket bonus appears as "not achieved" which actually is not true. It switches the gems in the blue and yellow socket.
(10AP 4Hit vs. (AP 2MP5).

Thanks for your great work!

Actually, one can imagine different 2 rolls systems.
The one you use is most likely the one Blizzard use, but here is a "Crits dont miss" 2-roll system, with different results :
- roll for crit or normal.
- Crits always hit. If normal, roll for hit or miss.

If crit and hit are your crits and hits "paperdoll corrected" values (meaning that they are the character sheet ones, corrected by defense/ level /etc, except the roll system), then this systems leads to Crit chance of critical strikes, Hit*(1-Crit) chances of hit, and (1-Hit)*(1-Crit) chances of miss.

The 2-roll system you use leads to Hit*Crit chances of critical, Hit*(1-Crit) chances of hit and (1-Hit) chances of miss.

The old 1-roll system just gave the Crit, Hit-Crit and (1-Hit) probability.

It is cleary weird, but it is possible to have a different 2-roll system, and I've not always been able to understand blizzard logic (why is the amno dps replaced by a fixed bonus in steady-shot ???).

The good point is that with a little more datas like the one Lactose provided to move to 2-roll system, it will be quite easy to find which system is accurate, since Hit and Crit "paperdoll" probability are far away from 0 and 1.

It seems like relative gains should be the only ones of interest. Obviously against bosses with lower armor, the raw DPS gain for any amount of armor pen higher than they are on bosses with high armor. But I don't think that matters at all, because the percentage increase would be the same with 1000 armor pen whether you are facing a boss with a net 1000 armor, or one with 9999 armor. If you have enough armor pen to increase your damage by 10% it doesn't really matter whether you are doing 1000 DPS to a higher armor boss, or 2000 DPS to a low armor boss, it's still just 10%. Against the low armor bosses any increase in stats would produce a higher DPS increase than they would against high armor targets.

So to me it seems like every point of armor pen should have the same value, no matter how much or how little you have it, unless of course you get targets down to zero armor.

With all the new gear in 2.4 I'm thinking of releasing a new version tonight.

Only problem is I'm still not 100% satisfied with my model of the 3:2 (Steady Spam) rotation yet, so I'm going to leave that out.

Here is what is done:
- Change Band of the Eternal Champion proc duration to 10 seconds.
- Corrected some bugs in the profiles matrix. Everything should display accurately now.
- Corrected Draenei base Intelligence to 78 (from 82.)
- Corrected some item stats (Embrace of the Twisting Nether, Bow-Stitched Leggings)
- Fixed a bug in Shoulder socket bonuses that was sometimes showing bonuses for gear that did not have sockets.
- Corrected some item name spellings (Ancient Draenei War Talisman, Wicked Flame Spessarite)
- Remodeled Mark of Conquest with a 17 second internal cooldown and 13% chance to proc. This is based on data collected by Xeno of Suramar.
- If you select Thor'idal, the Stars' Fury as a ranged weapon the ammo is defaulted to None. (This is not applicable for OO versions.)
- Added new gear (Thor'idal, the Stars' Fury, Blackened Naruu Sliver, Apolyon, the Soul-render, Fang of Kalecgos, Muramasa, Crus of the Apocalypse, Shiv of Exsanguination, Hard Khorium Choker, Shoulderpads of the Silvermoon Retainer, Breeching Comet, Edge of Opression, Sunrage Shoulderpads, Hauberk of the Warbringer, Bladed Chaos Tunic, Leggings of the Immortal Night, Shoulderpads of Vehemence, Duplicitous Guise, Truestrike Crossbow, Bombardier's Blade, The Sunbreaker, Shattered Sun Pendant of Might, Gronnstalker's Belt, Gronnstalker's Bracers, Gronnstalker's Boots, Fletcher's Gloves of the Phoenix, Embrace of the Phoenix).
- Provide for three Buff Profiles. These are Loaded/Saved on the 'Buffs' tab, the names are controlled on 'Settings and Results' and they are Imported/Exported properly.

Does anyone else have any quick suggestions?

I don't think this is a quick suggestion, but I have been wondering if you could add the Rift Stalker 4 piece bonus to the modeled items that proc off of a crit (Tsunami Talisman and Hourglass of the Unraveller)?

We can add that to the bug list. It'll take a bit more work than what I plan to spend before packaging this up tonight. I'll have to track different crit rates per shot. (In reality I'd be surprised if it made more than a 2 AP difference.)

Cheeky, could we get some remedial "3:2 support" included? All you'd have to do is remove latency from affecting Steady Shot, and the reduced GCD's you talked about before in this post. We can build our own rotations from that.

The only time latency affects steady shot anymore is when using the cast sequence macro, pretty much, and so many people have switched over that I think it's worth taking out now.

Here are a few more items to include in the 2.4 gear list: Shadowed Gauntlets of Paroxysm, Sunrage Shoulderpads, Glyph of the Gladiator, Carapace of Sun and Shadow, Hard Khorium Band, Mounting Vengeance, Starstalker Legguards, Surestrike Goggles 3.0, Tunic of the Ranger Lord

The shoulder enchants have a typo - Inscription of Vengence/Greater Inscription of Vengence should be spelled Vengeance.

I must be misunderstanding something about what we mean by a 3:2 rotation. I thought it meant an alternating pattern approximating

Steady, Auto
Steady, Steady, Auto

Hence 3 steadies per 2 autos.

Looking at Midnight's test summaries, it looks like all but 1 of the quivered tests resulted in a 2:1 rotation (2 steadies per auto), with the exception of test 8, which comes pretty close to a 3:2 ratio.

I realize that maintaining 3 steadies per 2 autos is not necessarily the goal of these tests, but rather to puzzle out optimal rotation/speed/haste combinations given the new Auto Shot mechanics. Just confirming what you mean by 3:2.