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!

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.

Basically this seems convenient but keep in mind that diminishing returns on armor do exist, they are simply not as high as one would assume on first sight. Hence there is also a bigger benefit from more ArP/low Armor bosses. For exact calculation concerning this please consult the above linked Warrior-Thread (though, the calculation found there naturally uses a tank-PoV).

However, there is also the case that AP or Crit scales to another proportion at given amounts of armor than ArP therefore making not only the relative- but also the absolute-value interesting. For this Cheekys Spreadsheet provides quite useful answers.

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?

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.

Huh, if they leave the damage as such and not change anything with the mechanics of Steady Shot, doesn't it make the Legendary Bow a little OP, such that it won't be replaced until way,way into lvl80 Raiding?

I.e Three benefits so far:

-Free Arrows,
-Free Bag slot,
and
- Rough increase of 200dps over Bristleback/Timeless? (And still not factoring in the other stats)

This would almost prompt me to believe the first balancing change for WotLK would be for changing Steady Shot Mechanics to factor in Ammo DPS. (a la many nerfs to Thunderfury)

Looking at your numbers, I'm assuming that "general shot delay" means average time per shot (regardless of type), and that this is what you're looking at to evaluate "average overall shot throughput"?

I do find it helpful to measure time per shot as you have done (or the inverse shots/time) rather than DPS results. I think a next logical step would be to compare your results with what you'd expect to achieve from legacy 1:1 and 1.5:1 rotations.

For example, taking the results of your quivered tests:

1:1 Expected shot delay*: 1.304 *(i.e. average time per shot)
Improvement: 20%
1.5:1 Expected shot delay: 1.043
Improvement: 0%

1:1 Expected shot delay: 1.087
Improvement: 5%

1:1 Expected shot delay: 1.130
Improvement: 8%

1:1 Expected shot delay: 0.942
Improvement: 2%

The blue numbers are the average shot times (or "delay" as you've called it) that I'm using to evaluate improvement over expected legacy rotation shot times.

So, if I understand your results correctly, of the four quivered tests, the best improvement you achieved in terms shots/time (or time/shot) was actually not with the slower bow, but in Test 6 (2.6 speed bow, no Serpent's Swiftness), for which you saw a reduced average time per shot of about 8%.

First of all - you´re right I confused the 3:2 rotation with a 2:1 rotation actually. 3:2 meaning Auto - Steady - Steady.

That beeing said there seems to be a general uncertainty about those terms, so I guess it´d be a good idea to clarify them. To my understanding they´re used as follows:

1:1 = Auto - Steady (steady may be replaced with either multi or arcane, there´s only one special per auto though)
1:1.5 = Auto - Steady - Auto - Steady - Special (special is either multi or arcane)
2:3 = Auto - Steady - Auto - Steady - Steady (actually the same as 1:1.5 but no specials but steady are beeing use)
1:2 = Auto - Steady - Steady (kind of uncommon rotation I´ve never seen theorycrafted in depth about anywhere on these boards, but the most common rotation on my macrotests)

To answer your questions Stinkerbelle: delay is the time between two shots. Steady shot delay is the delay between two steady shots whereas general shot delay is the delay between any two shots following on each other so the latter is the one determing the absolute shot throughput. Assuming all shots would do roughly the same damage the highest shot throughput would also yield the best dps result. I think I´m gonna do a few tests with a standard castsequence macro and see how it compares.

Since I forgot to mail myself my working copy of the spreadsheet form work to home last night I didn't get this released. If I'm not a complete idiot today too it'll get done.

I'll get those added/fixed.

That's pretty much exactly what I have done. My first pass on the code was to intelligently pick Auto or Steady based on what the relative cooldowns were and prioritize Steady if it was at all available. That lead to a lot of Auto, Steady, Steady, Auto, Steady, Steady rotations, which isn't what we want.

I'll just force the Auto, Steady, Steady, Auto, Steady pattern now. My initial work shows it as being even more of a mana drain than a 1:1, Priority rotation using max rank Arcane and Multi. But that fits with what people are seeing in game.

Do we need the 3:2 rotation only for unhasted rotations? Or do people envision using it for Quick Shots and DST-based rotations too?