Hunter Spreadsheets -- In development - Page 98

peterk0 · 02/12/08, 12:04 PM

Originally Posted by Cheeky

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?

As far as I experienced, the new macro under haste effects produces 1:1 rotation, but I use it anyway, it's more consistent this way, at least for me (I can focus on other things), so if it isn't much extra work, I would very much appreciate it for hasted rotations too.

Fendryl · 02/12/08, 12:06 PM

Shivering Felspine (Shivering Felspine - Items - WOWDB) and Clutch of Demise (Clutch of Demise - Items - WOWDB) from last nights kills, if there's still time.

Lactose · 02/12/08, 12:17 PM

Originally Posted by peterk0

As far as I experienced, the new macro under haste effects produces 1:1 rotation, but I use it anyway, it's more consistent this way, at least for me (I can focus on other things), so if it isn't much extra work, I would very much appreciate it for hasted rotations too.

To me that sounds like you want a forced 1:1 rotation if there are some hastes up (Quick Shots, Dragonspine Trophy), and a forced 2:3 rotation otherwise.

Cheeky · 02/12/08, 1:57 PM

Originally Posted by Lactose

To me that sounds like you want a forced 1:1 rotation if there are some hastes up (Quick Shots, Dragonspine Trophy), and a forced 2:3 rotation otherwise.

I added the 3:2 for Quick Shots, but using my gear (no +haste) and a [Serpent Spine Longbow] I get the following unbuffed:
Quick Shots 1:1 - 865.03 DPS, 52.37 MPS
Quick Shots 3:2 - 836.66 DPS, 61.07 MPS

As extra information here is what the spreadsheet gives me unhasted:
1:1, Auto:Steady - 752.34 DPS, 45.54 MPS
1:1, Priority - 794.88 DPS, 74.35 MPS
1:1.X, Arcane - 870.17 DPS, 73.14 MPS
3:2 - 837.39 DPS, 61.12 MPS

Interesting...

Lodi · 02/12/08, 3:53 PM

Originally Posted by Midnight

Test #2 - 3,0s Weapon, 15% quiverhaste, no SS talent - 2,61s actual attack speed.
Number of Auto Shots fired: 322
Number of Steay Shots fired: 677
Total number of shots fired: 999

Auto Shot delay (min/max/avrg): (2,625s/4,610s/3,187s)
Steady Shot delay (min/max/avrg): (1,203s/2,000s/1,541s)
General Shot delay (min/max/avrg): (0.312s/1.766s/1.043s)

Test #8 - 2,6s Weapon, 15% quiverhaste, 5/5 SS talent - 1,88s actual attack speed.
Number of Auto Shots fired: 405
Number of Steay Shots fired: 594
Total number of shots fired: 999

Auto Shot delay (min/max/avrg): (0,078s/4,625s/2,275s)
Steady Shot delay (min/max/avrg): (1,031s/2,219s/1,541s)
General Shot delay (min/max/avrg): (0.031s/2.188s/0.919s)

A few conclusions that jump to my mind:

- Five of the eight test series produced an almost perfect 3:2 rotation and a near perfect 1,5s average steady delay too. Depending on haste Auto shot is clipped between about 0,4s and 1,0s on those rotations though.
- Haste doesn´t seem to have much of an impact on those 3:2 rotations. The average overall shot throughput is almost the same for all of them with faster attack speeds just clipping auto shot more than slow weapons. This favors slow weapons over fast ones for absolute damage.

The ratio of steady to auto was 2:1 for all your tests that had some haste, except for the extreme case where you went BM with a 2.6 speed gun. There, you actually got 3:2. Not surprisingly, you did get more shots (10%).

It's cute that this works and automatically adjusts for haste procs (going from 2:1 to 3:2 to 1:1 as the hastes stack). But I'd be shocked if steady-multi-auto and steady-arcane-auto didn't outperform steady-steady-auto at most weapon speeds (although, of course, you can't start your next steady as soon, so the earlier autoshot following an arcane isn't as great as you'd think).

Rokh · 02/12/08, 6:33 PM

Under Quickshots / DST you'll want to drop to 1:1, I'm almost sure. You'll be clipping to much to squeeze in a second steady shot anywhere.

Also Cheeky, yeah, 1:1.x with I'd think Arcane and Multi would be better than a pure 2:3 rotation, shouldn't be that much more mana, just ALOT harder to do and time right.

Cheeky · 02/12/08, 11:09 PM

Version 43 released - Buff Profiles! 3:2 rotations! Sunwell Loot!!!!

- 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, Greater Inscription of Vengeance)
- 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, Surestrike Goggles v3.0, Gylph of the Gladiator, Shadowed Gauntlets of Paroxysm, Sunrage Shoulderpads, Carapace of Sun and Shadow, Hard Khorium Band, Mounting Vengeance, Stalker's Legguards, Tunic of the Ranger Lord).
- 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.
- Users can select from 3 types of shot rotations - Hand-Weaving, Castsequence, and Spam. These refer to the common methods of timing by hand, or using some of the various macros available.
- Using Castsequence macros results in latency being added to the start of every shot cast to account for server<->client communication.
- Using either Hand-Weaving or Spam macros results in latency being a factor when computing GCD based on whether or not the previous shot was an Auto Shot. This means the Shot Rotation matrix will now try and mimic the behavior seen of the GCD being client-only.
- Added a button to build the Auto, Steady, Steady, Auto, Steady (usually referred to as "3:2") shot rotation automatically.

No OO version yet.

Osse · 02/13/08, 12:46 AM

http://static.mmo-champion.com/mmoc/...duskshadow.jpg

Those gloves are almost 30 dps upgrade over Gronnstalker's... Not sure if someone has mentioned the item yet but oh well. :p

Midnight · 02/13/08, 7:36 AM

Bugreport for next version: You forgot the Star in [Starstalker Legguards] also you put an 's behind stalker in that name.

Lactose · 02/13/08, 7:49 AM

Added to bug list.
Also spotted a couple of other mistakes, which were added as well.

Zediono · 02/13/08, 8:35 AM

Bug on 43: Thor'idal adds 17str instead of 17agi.

Opostrophe · 02/13/08, 8:52 AM

Am I right in assuming that v 42 and back use v 43's 'Castsequence' logic for building shot rotations?

Making my shot rotations in v 43, and I notice that a hand-weaved or Spam 1:1.X (Multi & Arcane) rotation results in a ~80 DPS gain over Castsequence, and thereby a ~20 dps gain over 1:1 (Prio) for my cookie-cutter BM + Wolfslayer setup.

Does this seem wrong to anyone else?

Also possibly related, I notice that theres not a single Multishot in my Hand-weaved/Spam 1:1.X rotation, even though I have selected Multi (Yes) for the rotation. Multi-shot does however appear in the rotation if I use the Castsequence setting.

Bikiniwax · 02/13/08, 10:00 AM

Getting a pop-up that Battlemaster's Cruelty is not a supported Trinket. This was happening in ver 42 and now ver 43 (not sure about earlier versions).

Maybe check the space between "Battlemaster's" and "Cruelty". Looks like there might be an extra space?

Seven · 02/13/08, 10:55 AM

Thanks again cheeky for your hard work!
I achieved the best theoretical results with the 1.1.x rotation (x=arcane), + 1.1.x rotation (x=arcane) under quickshots, but only when "spammed" oder "handweaved". Since I got my SP garanteed, mana is not the limiting factor here.

Is there any macro out there that can actualy !spam! an auto, steady, arcane rotation like its mentioned in the spreadsheet?

My first suggestion:

/cast !Auto Shot
/cast Steady Shot
/cast Arcane Shot
/cast [target=pettarget, exists] Kill Command
/cast [target=pettarget, exists] Lightning Breath

Can't test that right now, but looks reasonable to me atm. If I get this right it will do the 3:2 rotation until the next arcane shot is up. The arcane here fills the gap where the double steady would appear in the standard spammed 3:2 rotation. The spreadsheed tells me it will be:
[auto, steady, auto, steady, auto, steady+arcane,] [auto, steady, auto, steady, auto, steady+arcane,]

The weird thing is that the next steady after the arcane is started 1s after the last arcane. I thought arcane triggers a 1,5s GCD....
... now I'm kind of confused.....

(can be seen in the shot rotation matrix in the wall of numbers everyone ignores.)

I didn't ignore your beautifull wall cheeky

Phaedryn · 02/13/08, 11:04 AM

Cheeky

Thank you for creating, and maintaining, this incredible tool for the Hunter community.

I downloaded the newest version, and love the Buff Profiles. However, when attempting to switch profiles via the drop down I get a cell protection error.

Although, seeing this addition to the spreadsheet made me wonder...would it be possible to make selectable Talent profiles also?