[top]6% bonus damage avg. overall.

3% to all over the same 3 hits will give you 9% bonus for each of the 3 hits and the extra 3% bonus added for the crit to the total.

Glaurong · 02/21/08, 6:29 PM

Originally Posted by tronar

Hi All,

Cheeky's spreadsheet is simply amazing and my dps has increased significantly since I began using it and raiding. I use it as a guide for all my upgrades.

I recently dl'ed the newest spreadsheet (43) to try to figure out what I could use from the new sunwell loots (I realize they might be changed but I like to see what's available to me) and while going over my upgrade chart I found out the the twinblades of the Phoenix from Kael are going to give me a 2DPS decrease versus my Vengeful Gladiator's Waraxe. What's odd about this is the older version I had (not that old mind you) put the twinblades as one of the best (if not the best) 2-hnd weapon I could get. I realize I loose some hit when getting the twinblades, but I tried resocketing and it still showed a small decrease.

Anyone else see this? Perhaps Cheeky changed the values of Armor penetration?

I made sure I have all the buffs on me (I am mostly concerned with raid dps and we have 4-5 palys in our raid most of the time. So I have all the paly buffs, mage buff, druid buff, warp burger and flask of relentless striking). I use a 1:1 rotation and a cat pet.

The thing is I would hate to pass on the twinblade only to find out something was a bit off with the Spreadsheet, just as much as if I "Need" the twinblade and find out they hurt my dps (and it could have gone to someone else)

Any help/insight is always appreciated.

Thanks
Tronar of Hakkar

Don't sign your posts and the hit was most likely the difference. An old version of the spreadsheet had everything on 1 roll. The newer versions have 2 rolls (hit/crit) for all our shots. Hit's value slightly increased.

tronar · 02/21/08, 6:37 PM

I only signed it to let people look at my armory. Didn't realize that was looked down on.

Thanks for the info tho.

Cheeky · 02/22/08, 11:12 AM

Originally Posted by Caell

First of all my compliments on the great job Cheeky! Keep it up!

My question: In the "Shot Rotation" tab, Macro choice you have 3 options: Hand-weaved, Castsequence & Spam. Handweaved and castsequence for the 1:1.X rotation are I guess pretty self explanatory. But, when you say spam, what exactly is the macro that you use? I am asking this because there are a couple of alternatives for this term:

1st Spam Macro 1:1.X (only arcane)
...
/cast !Auto Shot
/castrandom Steady Shot, Arcane Shot
...

2nd Spam Macro 1:1.X (only arcane)
...
/cast !Auto Shot
/cast Steady Shot
/castrandom Arcane Shot
...

3rd Spam Macro 1:1.X (only arcane)
...
/castsequence !Auto Shot, Steady Shot
/castrandom Arcane Shot
...

According to the spreadsheet this is the heaviest dps method for me by a large margin from the others (100-200dps). But I tried all three macros on Dr-Guinea-Pig-Boom and got no real differences. The one that came a bit higher than the rest and it's my best guess is the 1st one, but I would like to make sure I am correct.

Thanks in advance for the clarification.

PS: The Buffs Profile selection tab is protected in this version of the spreadsheet and you cannot change it (cell D4).

The spreadsheet models rotations, not macros. How you achieve the rotation is an exercise left to the reader. I've been a complete failure at generating the 3:2 rotation with a [Serpent Spine Longbow], so I've switched back to a 1:1 with my [Wolfslayer Sniper Rifle] and started setting personal DPS highs again. Other people have had incredible luck with the spam-macros. There is too much randomness involved in seeing how macros translate into rotations.

I added changes to the shot rotation to better model some of the timing we are seeing. I don't think any of us really has a great understanding of how to model the newer macros and the server-side changes.

Originally Posted by Snipehunter

A couple things: ZA bow is improperly named, and could you add the badge xbow reward to the next release as well?
On a related note, I discovered that the xbow doesn't do as well as the amani bow, even though the dps is higher. I think this is due to the armor pen and the 1% crit i get for being a troll. so it makes me feel better that blizz isn't completely giving out superior welfare epics...

I'll add as much gear as I can. Hope to release a new version tonight. For me (a troll) the [Crossbow of Relentless Strikes] is best in slot (non-orange text only) and actually had me join a Kara clear for the first time in 6 months....

◊ Estala · 02/22/08, 5:24 PM

I have a question Cheeky, why is the ability to not add other hunters' FI to your buffs still not an option? Am I just missing something here?. How about a flag for 3% crit from a ret paladin as well?

Cheeky · 02/22/08, 5:30 PM

Originally Posted by Estala

I have a question Cheeky, why is the ability to not add other hunters' FI to your buffs still not an option? Am I just missing something here?. How about a flag for 3% crit from a ret paladin as well?

I plan to add the Pally buff, but no other BM Hunter really provides 3% extra damage. It's something less than that, and it depends on that other Hunter and his pet. (Plus, for comparitive purposes 3% damage is just 3% damage, it doesn't help in evaluating gear/talent/rotation concerns of your own.)

Cheeky · 02/23/08, 1:31 AM

Change Log:
- Corrected some item names ([Starstalker Legguards], [Edge of Oppression], [Hauberk of the War Bringer],

22:11:06 called in wowhead_item::start:324 Item not found!

.)
- Corrected some item stats ([Thori'dal, the Stars' Fury].)
- Unprotected the Buff Profiles drop-down selection.
- Added new gear ([Crossbow of Relentless Strikes], [Shivering Felspine], [Clutch of Demise], [Ar'tor's Mainstay],

22:11:08 called in wowhead_item::start:324 Item not found!

,

22:11:08 called in wowhead_item::start:324 Item not found!

, [Carapace of Sun and Shadow], [Gloves of Immortal Dusk])

Last update for a few weeks. We'll let the gear changes on the PTR settle down before adjusting them.

vith · 02/23/08, 8:45 AM

Bug in v44: elixirs get cleared by the flask field being set to None during buff profile loading

Could we get an option to ignore meta gem requirements, to make comparing pieces quicker in cases that require swapping gems around in the rest of the gear?

There's also some buffs that could be added: Unleashed Rage (for pet), Inspiring Presence, Flame Cap (1m duration/3m cooldown), Haste Potion (eek, doubling the count of haste states--not worth the trouble?), and Improved Sanctity Aura, as well as FI's/Improved Seal of the Crusader as Estala said.

And one final pipe dream: I'd love to see a fight duration limit in order to work towards being able to value mana gains in terms of total damage done. This would then benefit from adding buff options for modeling various mana potions, Vampiric Touch, Spellsurge etc. I also noticed that Viper is being modeled as 25% of Int still, but better math in a continuous model eludes me. Then again maybe what I want is more a simulator than a spreadsheet. Either way, thanks for the invaluable tool.

Novacaine · 02/23/08, 8:47 AM

Cheeky I think I found a possible flaw in your spreadsheet regarding the 3:2 rotation, as I am obtaining an unreliable and incorrect simulation. Results from the spreadsheet showed up that the 3:2 rotation is the worst option I could adopt, compared to every other one (incase Armory is down I am using a [Wolfslayer Sniper Rifle]). These results confused me quite much since I have been using the 3:2 for a while and always noticed high dps on live realms.

So I decided to run a test on Dr Boom and tried the 1:1 Auto-Steady rotation and the 3:2 rotation. Unfortunately I am unable to provide a combat log since for some reason it does not save my results in wowcombatlog.txt ( /combatlog command works, it says it is starting to log, but infact it won't save anything on the txt file, even after giving the /combatlog input again).

So far the results from the spreadsheet were these (Both spreadsheet and live testing results are not including pet dps):

1:1 Auto-steady rotation -> 810 dps
3:2 Rotation -> 751 dps

But in fact the results from live testing on Dr. Boom were:

1:1 Auto-steady rotation -> 760 dps
3:2 rotation -> 830 dps

While I understand that the spreadsheet can't provide exact informations regarding dps, I am unable to figure out why the spreadsheet penalizes so much 3:2 rotations, when in fact 3:2 rotations seem to best any other rotation on "live" testing.

Note: All live testing were performed using Imp. AotH / Hourglass of the unraveller, Hunter Mark always up and Crit % was constant with the value I have, 30%. Live testing is a result of 3 sessions (Lenght of the session= time till I ran out of mana)on Dr Boom, under the same conditions.

P.S.: Forgive my english

.

edit: I am adding here the macro I have been using:

For 3:2 Rotation.

#showtooltip Steady Shot
/cast !Auto shot
/cast [target=pettarget, exists] Kill command
/cast Steady shot
/script UIErrorsFrame:Clear()

For 1:1 Steady/Auto Rotation.

#showtooltip Auto Shot
/castsequence reset=3 Steady Shot, Auto Shot
/castrandom [target=pettarget, exists] Kill Command
/script UIErrorsFrame:Clear()

Cheeky · 02/23/08, 10:05 AM

Originally Posted by Novacaine

edit: I am adding here the macro I have been using:

For 3:2 Rotation.

#showtooltip Steady Shot
/cast !Auto shot
/cast [target=pettarget, exists] Kill command
/cast Steady shot
/script UIErrorsFrame:Clear()

For 1:1 Steady/Auto Rotation.

#showtooltip Auto Shot
/castsequence reset=3 Steady Shot, Auto Shot
/castrandom [target=pettarget, exists] Kill Command
/script UIErrorsFrame:Clear()

My bet would be that your latency is worse than you have input in the spreadsheet, and the /castsequence macro is generating much more clipping than you think. Getting a timestamped combat log is the only was to ascertain if that is happening or not.

Novacaine · 02/23/08, 11:22 AM

It seems like I managed to fix the combat log, so here we go for the results. My apologizes, I've been able to run a test only for each of the macros I posted above, well anyways here we go:

3:2 Rotation (see previous post for macro)


DPS:837 CRIT: 26%

2/23 16:00:22.734  Your Auto Shot hits Dr. Boom for 438.
2/23 16:00:23.406  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:23.546  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:23.859  Your Steady Shot crits Dr. Boom for 1147. (49 blocked)
2/23 16:00:24.515  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:24.640  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:25.046  Your Steady Shot hits Dr. Boom for 532.
2/23 16:00:25.640  Your Auto Shot hits Dr. Boom for 487.
2/23 16:00:26.781  Your Steady Shot crits Dr. Boom for 1135.
2/23 16:00:27.000  You gain Quick Shots.
2/23 16:00:27.359  Your Auto Shot hits Dr. Boom for 501.
2/23 16:00:27.750  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:28.046  Your Steady Shot crits Dr. Boom for 1247.
2/23 16:00:29.078  Your Auto Shot hits Dr. Boom for 470.
2/23 16:00:29.843  Your Steady Shot hits Dr. Boom for 524.
2/23 16:00:30.640  Your Auto Shot hits Dr. Boom for 459.
2/23 16:00:31.187  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:31.312  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:31.437  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:31.562  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:31.703  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:31.718  Your Steady Shot hits Dr. Boom for 516.
2/23 16:00:32.031  Your Auto Shot hits Dr. Boom for 494.
2/23 16:00:32.687  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:32.812  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:33.000  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:33.000  Your Steady Shot crits Dr. Boom for 1302.
2/23 16:00:33.078  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:33.218  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:33.625  Your Auto Shot hits Dr. Boom for 452.
2/23 16:00:34.515  Your Steady Shot hits Dr. Boom for 562.
2/23 16:00:35.531  Your Auto Shot hits Dr. Boom for 463.
2/23 16:00:36.015  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:36.125  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:36.125  Your Steady Shot crits Dr. Boom for 1185.
2/23 16:00:36.265  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:36.390  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:36.562  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:36.687  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:36.843  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:36.859  You gain Rage of the Unraveller.
2/23 16:00:36.859  Your Auto Shot hits Dr. Boom for 506.
2/23 16:00:37.562  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:37.640  Your Steady Shot hits Dr. Boom for 529.
2/23 16:00:37.703  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:38.265  Your Auto Shot hits Dr. Boom for 529.
2/23 16:00:39.078  Quick Shots fades from you.
2/23 16:00:39.156  Your Steady Shot crits Dr. Boom for 1429.
2/23 16:00:39.828  You gain Quick Shots.
2/23 16:00:40.078  Your Auto Shot hits Dr. Boom for 496.
2/23 16:00:41.125  Your Steady Shot hits Dr. Boom for 554.
2/23 16:00:42.218  Your Steady Shot hits Dr. Boom for 620.
2/23 16:00:42.812  Your Auto Shot hits Dr. Boom for 514.
2/23 16:00:43.375  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:43.671  Your Steady Shot hits Dr. Boom for 611.
2/23 16:00:44.234  Your Auto Shot hits Dr. Boom for 531.
2/23 16:00:44.843  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:45.000  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:45.218  Your Steady Shot hits Dr. Boom for 571.
2/23 16:00:45.937  Your Auto Shot hits Dr. Boom for 523.
2/23 16:00:46.390  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:46.546  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:46.750  Rage of the Unraveller fades from you.
2/23 16:00:46.750  Your Steady Shot hits Dr. Boom for 513.
2/23 16:00:47.500  Your Auto Shot hits Dr. Boom for 530.
2/23 16:00:48.171  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:48.468  Your Steady Shot hits Dr. Boom for 586.
2/23 16:00:49.015  Your Auto Shot hits Dr. Boom for 494.
2/23 16:00:50.125  Your Steady Shot hits Dr. Boom for 515.
2/23 16:00:50.562  Your Auto Shot hits Dr. Boom for 523.
2/23 16:00:51.265  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:51.640  Your Steady Shot crits Dr. Boom for 1202. (49 blocked)
2/23 16:00:52.265  Your Auto Shot hits Dr. Boom for 525.
2/23 16:00:52.890  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:53.171  Your Steady Shot hits Dr. Boom for 557.
2/23 16:00:53.640  Your Auto Shot crits Dr. Boom for 1095.
2/23 16:00:54.359  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:54.562  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:54.718  Your Steady Shot crits Dr. Boom for 1339.
2/23 16:00:55.250  Your Auto Shot hits Dr. Boom for 506.
2/23 16:00:56.031  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:56.234  You fail to perform Steady Shot: Not yet recovered.
2/23 16:00:56.390  Quick Shots fades from you.
2/23 16:00:56.468  Your Steady Shot crits Dr. Boom for 1290.
2/23 16:00:56.781  Your Auto Shot hits Dr. Boom for 497.
2/23 16:00:58.187  Your Steady Shot hits Dr. Boom for 512.
2/23 16:00:58.968  Your Auto Shot crits Dr. Boom for 1137.
2/23 16:00:59.953  Your Steady Shot hits Dr. Boom for 580.
2/23 16:01:00.781  Your Auto Shot hits Dr. Boom for 510.
2/23 16:01:01.765  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:01.937  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:02.062  Your Steady Shot hits Dr. Boom for 547.
2/23 16:01:02.593  Your Auto Shot crits Dr. Boom for 1089.
2/23 16:01:03.296  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:03.406  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:03.578  Your Steady Shot hits Dr. Boom for 558.
2/23 16:01:04.531  Your Auto Shot hits Dr. Boom for 462.
2/23 16:01:05.203  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:05.500  Your Steady Shot crits Dr. Boom for 1366.
2/23 16:01:06.328  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:06.812  Your Steady Shot crits Dr. Boom for 1368.
2/23 16:01:07.218  Your Auto Shot crits Dr. Boom for 1016. (49 blocked)
2/23 16:01:08.031  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:08.359  Your Steady Shot hits Dr. Boom for 544.
2/23 16:01:09.093  Your Auto Shot hits Dr. Boom for 520.
2/23 16:01:09.703  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:10.062  Your Steady Shot hits Dr. Boom for 527.
2/23 16:01:10.984  Your Auto Shot crits Dr. Boom for 1252.
2/23 16:01:11.625  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:11.937  Your Steady Shot hits Dr. Boom for 519.
2/23 16:01:12.781  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:13.203  Your Steady Shot crits Dr. Boom for 1304.
2/23 16:01:13.671  You gain Quick Shots.
2/23 16:01:13.671  Your Auto Shot hits Dr. Boom for 507.
2/23 16:01:14.156  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:14.328  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:14.625  Your Steady Shot crits Dr. Boom for 1361.
2/23 16:01:15.531  Your Auto Shot crits Dr. Boom for 1231.
2/23 16:01:16.515  Your Steady Shot crits Dr. Boom for 1108. (49 blocked)
2/23 16:01:17.234  Your Auto Shot hits Dr. Boom for 521.
2/23 16:01:18.062  Your Steady Shot hits Dr. Boom for 514.
2/23 16:01:18.843  Your Auto Shot crits Dr. Boom for 1162.
2/23 16:01:19.625  Your Steady Shot crits Dr. Boom for 1338.
2/23 16:01:20.375  Your Auto Shot crits Dr. Boom for 1093.
2/23 16:01:21.234  Your Steady Shot hits Dr. Boom for 516.
2/23 16:01:22.203  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:22.437  Your Steady Shot hits Dr. Boom for 539.
2/23 16:01:22.968  Your Auto Shot crits Dr. Boom for 1130. (49 blocked)
2/23 16:01:23.593  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:23.796  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:24.078  Your Steady Shot crits Dr. Boom for 1234.
2/23 16:01:24.468  Your Auto Shot hits Dr. Boom for 479.
2/23 16:01:25.187  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:25.375  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:25.656  Your Steady Shot hits Dr. Boom for 524.
2/23 16:01:26.046  Your Auto Shot crits Dr. Boom for 1115.
2/23 16:01:26.703  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:26.812  You gain Rage of the Unraveller.
2/23 16:01:26.921  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:27.203  Your Steady Shot hits Dr. Boom for 565.
2/23 16:01:27.578  Your Auto Shot hits Dr. Boom for 556.
2/23 16:01:28.250  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:28.437  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:28.703  Your Steady Shot hits Dr. Boom for 613.
2/23 16:01:29.109  Your Auto Shot hits Dr. Boom for 524.
2/23 16:01:29.781  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:29.984  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:30.281  Your Steady Shot hits Dr. Boom for 620.
2/23 16:01:30.843  Your Auto Shot crits Dr. Boom for 1258.
2/23 16:01:31.500  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:31.828  Your Steady Shot hits Dr. Boom for 570.
2/23 16:01:32.171  Your Auto Shot hits Dr. Boom for 527.
2/23 16:01:32.375  You fail to perform Steady Shot: Another action is in progress.
2/23 16:01:32.984  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:33.312  Your Steady Shot hits Dr. Boom for 579.
2/23 16:01:33.890  Your Auto Shot hits Dr. Boom for 548.
2/23 16:01:34.375  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:34.671  Your Steady Shot hits Dr. Boom for 630.
2/23 16:01:35.421  Your Auto Shot hits Dr. Boom for 514.
2/23 16:01:35.890  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:36.218  Your Steady Shot crits Dr. Boom for 1451.
2/23 16:01:36.890  Rage of the Unraveller fades from you.
2/23 16:01:36.890  Your Auto Shot hits Dr. Boom for 470.
2/23 16:01:37.453  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:38.093  Your Steady Shot hits Dr. Boom for 545.
2/23 16:01:38.562  Your Auto Shot hits Dr. Boom for 481.
2/23 16:01:39.000  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:39.328  Your Steady Shot hits Dr. Boom for 520.
2/23 16:01:40.234  Your Auto Shot crits Dr. Boom for 1080.
2/23 16:01:40.937  Quick Shots fades from you.
2/23 16:01:41.078  Your Steady Shot hits Dr. Boom for 536.
2/23 16:01:41.875  Your Auto Shot hits Dr. Boom for 499.
2/23 16:01:42.500  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:43.031  Your Steady Shot hits Dr. Boom for 563.
2/23 16:01:44.046  Your Steady Shot hits Dr. Boom for 527.
2/23 16:01:44.625  Your Auto Shot crits Dr. Boom for 1234.
2/23 16:01:45.562  Your Steady Shot crits Dr. Boom for 1294.
2/23 16:01:46.531  Your Auto Shot hits Dr. Boom for 479. (49 blocked)
2/23 16:01:47.140  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:47.312  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:47.468  Your Steady Shot hits Dr. Boom for 521.
2/23 16:01:48.812  Your Steady Shot crits Dr. Boom for 1220.
2/23 16:01:49.203  Your Auto Shot hits Dr. Boom for 488.
2/23 16:01:49.812  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:50.125  Your Steady Shot hits Dr. Boom for 534.
2/23 16:01:50.921  Your Auto Shot hits Dr. Boom for 485.
2/23 16:01:51.781  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:52.078  Your Steady Shot hits Dr. Boom for 557.
2/23 16:01:52.875  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:53.421  Your Steady Shot crits Dr. Boom for 1368.
2/23 16:01:54.468  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:54.765  Your Steady Shot hits Dr. Boom for 530.
2/23 16:01:56.015  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:56.546  Your Steady Shot crits Dr. Boom for 1216.
2/23 16:01:56.921  Your Auto Shot crits Dr. Boom for 1266.
2/23 16:01:57.562  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:57.890  Your Steady Shot hits Dr. Boom for 533.
2/23 16:01:58.703  Your Auto Shot hits Dr. Boom for 458.
2/23 16:01:59.531  You fail to perform Steady Shot: Not yet recovered.
2/23 16:01:59.812  Your Steady Shot hits Dr. Boom for 559.
2/23 16:02:00.656  You fail to perform Steady Shot: Not yet recovered.
2/23 16:02:00.828  You fail to perform Steady Shot: Not yet recovered.
2/23 16:02:01.125  Your Steady Shot hits Dr. Boom for 548.
2/23 16:02:01.531  Your Auto Shot crits Dr. Boom for 1253.
2/23 16:02:02.375  You fail to perform Steady Shot: Not yet recovered.
2/23 16:02:02.906  Your Steady Shot hits Dr. Boom for 520.
2/23 16:02:03.468  Your Auto Shot hits Dr. Boom for 429. (49 blocked)
2/23 16:02:04.046  You fail to perform Steady Shot: Not yet recovered.
2/23 16:02:04.515  Your Steady Shot crits Dr. Boom for 1268.
2/23 16:02:05.359  Your Auto Shot hits Dr. Boom for 506.
2/23 16:02:06.015  You fail to perform Steady Shot: Not yet recovered.
2/23 16:02:06.187  You fail to perform Steady Shot: Not yet recovered.
2/23 16:02:06.390  Your Steady Shot hits Dr. Boom for 516.
2/23 16:02:07.437  Your Steady Shot crits Dr. Boom for 1330.
2/23 16:02:08.046  Your Auto Shot hits Dr. Boom for 453.
2/23 16:02:09.046  Your Steady Shot hits Dr. Boom for 576.
2/23 16:02:15.500  Hunter's Mark fades from Dr. Boom.

Here's the 1:1 castsequence macro


DPS:663 CRIT: 27,2%

2/23 16:09:08.125  Dr. Boom is afflicted by Hunter's Mark.
2/23 16:09:11.343  Your Steady Shot hits Dr. Boom for 469.
2/23 16:09:12.359  Your Auto Shot crits Dr. Boom for 1063.
2/23 16:09:13.890  Your Steady Shot hits Dr. Boom for 478.
2/23 16:09:14.687  Your Auto Shot hits Dr. Boom for 498.
2/23 16:09:16.546  Your Steady Shot hits Dr. Boom for 525.
2/23 16:09:17.171  Your Auto Shot hits Dr. Boom for 493.
2/23 16:09:18.859  Your Steady Shot crits Dr. Boom for 1175.
2/23 16:09:19.656  Your Auto Shot hits Dr. Boom for 461.
2/23 16:09:20.734  Your Steady Shot hits Dr. Boom for 500.
2/23 16:09:21.640  Your Auto Shot hits Dr. Boom for 468.
2/23 16:09:23.250  Your Steady Shot hits Dr. Boom for 522.
2/23 16:09:24.015  Your Auto Shot hits Dr. Boom for 432.
2/23 16:09:25.671  Your Steady Shot hits Dr. Boom for 534.
2/23 16:09:26.000  Your Auto Shot hits Dr. Boom for 437.
2/23 16:09:27.750  Your Steady Shot crits Dr. Boom for 1192.
2/23 16:09:28.578  Your Auto Shot crits Dr. Boom for 1208.
2/23 16:09:29.437  You gain Rage of the Unraveller.
2/23 16:09:30.218  Your Steady Shot hits Dr. Boom for 579.
2/23 16:09:30.890  Your Auto Shot hits Dr. Boom for 475.
2/23 16:09:32.484  Your Steady Shot hits Dr. Boom for 552.
2/23 16:09:33.750  Your Auto Shot hits Dr. Boom for 546.
2/23 16:09:34.531  Your Steady Shot hits Dr. Boom for 534.
2/23 16:09:35.203  Your Auto Shot crits Dr. Boom for 1227.
2/23 16:09:36.421  Your Steady Shot crits Dr. Boom for 1441.
2/23 16:09:37.265  Your Auto Shot hits Dr. Boom for 516.
2/23 16:09:38.531  Your Steady Shot hits Dr. Boom for 576.
2/23 16:09:39.062  Rage of the Unraveller fades from you.
2/23 16:09:39.250  Your Auto Shot crits Dr. Boom for 1301.
2/23 16:09:40.750  Your Steady Shot hits Dr. Boom for 545.
2/23 16:09:41.187  Your Auto Shot hits Dr. Boom for 529.
2/23 16:09:42.468  Your Steady Shot hits Dr. Boom for 508.
2/23 16:09:43.171  Your Auto Shot hits Dr. Boom for 519.
2/23 16:09:44.750  Your Steady Shot hits Dr. Boom for 548.
2/23 16:09:45.390  Your Auto Shot crits Dr. Boom for 1263.
2/23 16:09:46.625  Your Steady Shot hits Dr. Boom for 482. (49 blocked)
2/23 16:09:47.140  Your Auto Shot hits Dr. Boom for 465.
2/23 16:09:48.375  Your Steady Shot crits Dr. Boom for 1358.
2/23 16:09:49.203  Your Auto Shot hits Dr. Boom for 492.
2/23 16:09:50.640  Your Steady Shot hits Dr. Boom for 525.
2/23 16:09:50.921  Your Auto Shot hits Dr. Boom for 492.
2/23 16:09:52.515  Your Steady Shot hits Dr. Boom for 579.
2/23 16:09:53.328  Your Auto Shot crits Dr. Boom for 1229.
2/23 16:09:54.546  Your Steady Shot hits Dr. Boom for 583.
2/23 16:09:55.140  Your Auto Shot hits Dr. Boom for 503.
2/23 16:09:56.562  Your Steady Shot hits Dr. Boom for 549.
2/23 16:09:57.078  Your Auto Shot crits Dr. Boom for 1244.
2/23 16:09:58.484  Your Steady Shot hits Dr. Boom for 556.
2/23 16:09:59.000  Your Auto Shot hits Dr. Boom for 494.
2/23 16:10:01.000  Your Steady Shot hits Dr. Boom for 553.
2/23 16:10:01.468  Your Auto Shot hits Dr. Boom for 506.
2/23 16:10:02.687  Your Steady Shot hits Dr. Boom for 509.
2/23 16:10:03.093  Your Auto Shot hits Dr. Boom for 507.
2/23 16:10:04.687  Your Steady Shot crits Dr. Boom for 1303.
2/23 16:10:06.125  Your Auto Shot hits Dr. Boom for 531.
2/23 16:10:07.812  Your Steady Shot crits Dr. Boom for 1293.
2/23 16:10:08.765  Your Auto Shot hits Dr. Boom for 511.
2/23 16:10:10.156  Your Steady Shot hits Dr. Boom for 510.
2/23 16:10:10.640  Your Auto Shot crits Dr. Boom for 1191.
2/23 16:10:12.093  Your Steady Shot hits Dr. Boom for 567.
2/23 16:10:12.656  Your Auto Shot hits Dr. Boom for 505.
2/23 16:10:13.953  Your Steady Shot hits Dr. Boom for 589.
2/23 16:10:14.578  Your Auto Shot hits Dr. Boom for 473.
2/23 16:10:16.218  Your Steady Shot hits Dr. Boom for 526.
2/23 16:10:16.515  Your Auto Shot hits Dr. Boom for 463.
2/23 16:10:18.218  Your Steady Shot hits Dr. Boom for 519.
2/23 16:10:18.796  Your Auto Shot hits Dr. Boom for 526.
2/23 16:10:20.125  Your Steady Shot hits Dr. Boom for 538.
2/23 16:10:20.890  Your Auto Shot hits Dr. Boom for 488.
2/23 16:10:22.125  Your Steady Shot crits Dr. Boom for 1252.
2/23 16:10:22.609  Your Auto Shot crits Dr. Boom for 1216.
2/23 16:10:23.843  Your Steady Shot hits Dr. Boom for 563.
2/23 16:10:24.843  Your Auto Shot hits Dr. Boom for 463.
2/23 16:10:26.328  Your Steady Shot hits Dr. Boom for 573.
2/23 16:10:26.734  Your Auto Shot hits Dr. Boom for 519.
2/23 16:10:28.171  Your Steady Shot hits Dr. Boom for 532.
2/23 16:10:28.546  Your Auto Shot hits Dr. Boom for 488.
2/23 16:10:30.140  Your Steady Shot hits Dr. Boom for 532.
2/23 16:10:30.671  Your Auto Shot hits Dr. Boom for 472.
2/23 16:10:31.921  Your Steady Shot hits Dr. Boom for 573.
2/23 16:10:32.609  Your Auto Shot crits Dr. Boom for 1187.
2/23 16:10:33.937  Your Steady Shot hits Dr. Boom for 510.
2/23 16:10:34.734  Your Auto Shot crits Dr. Boom for 1098.
2/23 16:10:36.078  Your Steady Shot hits Dr. Boom for 511.
2/23 16:10:36.625  Your Auto Shot crits Dr. Boom for 1111.
2/23 16:10:37.031  You gain Rage of the Unraveller.
2/23 16:10:37.968  Your Steady Shot crits Dr. Boom for 1343.
2/23 16:10:38.546  Your Auto Shot crits Dr. Boom for 1356.
2/23 16:10:40.046  Your Steady Shot hits Dr. Boom for 588.
2/23 16:10:40.250  Your Auto Shot hits Dr. Boom for 511.
2/23 16:10:41.812  Your Steady Shot hits Dr. Boom for 578.
2/23 16:10:42.718  Your Auto Shot crits Dr. Boom for 1334.
2/23 16:10:43.812  Your Steady Shot crits Dr. Boom for 1351.
2/23 16:10:44.531  Your Auto Shot hits Dr. Boom for 559.
2/23 16:10:46.046  Your Steady Shot hits Dr. Boom for 587.
2/23 16:10:46.281  Your Auto Shot hits Dr. Boom for 537.
2/23 16:10:47.046  Rage of the Unraveller fades from you.
2/23 16:10:47.859  Your Steady Shot hits Dr. Boom for 539.
2/23 16:10:48.500  Your Auto Shot hits Dr. Boom for 462.
2/23 16:10:49.921  Your Steady Shot hits Dr. Boom for 517.
2/23 16:10:50.359  Your Auto Shot hits Dr. Boom for 509.
2/23 16:10:51.703  Your Steady Shot hits Dr. Boom for 577.
2/23 16:10:52.703  Your Auto Shot crits Dr. Boom for 1168.
2/23 16:10:53.875  Your Steady Shot hits Dr. Boom for 515.
2/23 16:10:54.609  Your Auto Shot hits Dr. Boom for 505.
2/23 16:10:56.046  Your Steady Shot crits Dr. Boom for 1397.
2/23 16:10:56.406  Your Auto Shot crits Dr. Boom for 1219.
2/23 16:10:58.015  Your Steady Shot hits Dr. Boom for 559.
2/23 16:10:58.656  You gain Quick Shots.
2/23 16:10:58.890  Your Auto Shot hits Dr. Boom for 506.
2/23 16:11:00.062  Your Steady Shot hits Dr. Boom for 569.
2/23 16:11:00.750  Your Auto Shot hits Dr. Boom for 532.
2/23 16:11:01.984  Your Steady Shot crits Dr. Boom for 1235.
2/23 16:11:02.843  Your Auto Shot crits Dr. Boom for 1116.
2/23 16:11:04.015  Your Steady Shot hits Dr. Boom for 552.
2/23 16:11:04.890  Your Auto Shot hits Dr. Boom for 475.
2/23 16:11:06.203  Your Steady Shot hits Dr. Boom for 580.
2/23 16:11:06.953  Your Auto Shot hits Dr. Boom for 481.
2/23 16:11:08.062  Hunter's Mark fades from Dr. Boom.
2/23 16:11:08.062  Your Steady Shot crits Dr. Boom for 1230.
2/23 16:11:08.796  Your Auto Shot hits Dr. Boom for 431.
2/23 16:11:10.734  Your Steady Shot crits Dr. Boom for 1263.
2/23 16:11:10.968  Your Auto Shot crits Dr. Boom for 1120.
2/23 16:11:12.906  Your Steady Shot crits Dr. Boom for 1195.
2/23 16:11:13.187  Your Auto Shot hits Dr. Boom for 473.
2/23 16:11:14.296  Quick Shots fades from you.
2/23 16:11:14.765  Your Steady Shot crits Dr. Boom for 1078.
2/23 16:11:16.015  Your Auto Shot crits Dr. Boom for 1008.
2/23 16:11:16.812  Your Steady Shot hits Dr. Boom for 512.
2/23 16:11:17.250  Your Auto Shot hits Dr. Boom for 419.
2/23 16:11:18.750  Your Steady Shot hits Dr. Boom for 526.
2/23 16:11:19.515  Your Auto Shot hits Dr. Boom for 431.
2/23 16:11:20.687  Your Steady Shot hits Dr. Boom for 458.
2/23 16:11:21.218  Your Auto Shot crits Dr. Boom for 1134.
2/23 16:11:22.750  Your Steady Shot hits Dr. Boom for 481.
2/23 16:11:23.703  Your Auto Shot hits Dr. Boom for 448.
2/23 16:11:25.218  Your Steady Shot crits Dr. Boom for 1124.
2/23 16:11:25.640  Your Auto Shot hits Dr. Boom for 400.
2/23 16:11:27.062  Your Steady Shot hits Dr. Boom for 495.
2/23 16:11:27.781  Your Auto Shot crits Dr. Boom for 967.
2/23 16:11:29.203  Your Steady Shot hits Dr. Boom for 509.
2/23 16:11:30.203  Your Auto Shot hits Dr. Boom for 435.
2/23 16:11:31.406  Your Steady Shot hits Dr. Boom for 466.
2/23 16:11:32.015  Your Auto Shot hits Dr. Boom for 440.

Cheeky · 02/23/08, 12:17 PM

Originally Posted by Novacaine

It seems like I managed to fix the combat log, so here we go for the results. My apologizes, I've been able to run a test only for each of the macros I posted above, well anyways here we go:

Here's the 1:1 castsequence macro - Modifed by Cheeky to show Auto Shot delays


DPS:663 CRIT: 27,2%

2/23 16:09:08.125  Dr. Boom is afflicted by Hunter's Mark.
2/23 16:09:12.359  Your Auto Shot crits Dr. Boom for 1063.
2/23 16:09:14.687  Your Auto Shot hits Dr. Boom for 498. (2.3s)
2/23 16:09:17.171  Your Auto Shot hits Dr. Boom for 493. (2.4s)
2/23 16:09:19.656  Your Auto Shot hits Dr. Boom for 461. (2.5s)
2/23 16:09:21.640  Your Auto Shot hits Dr. Boom for 468. (2.0s)
2/23 16:09:24.015  Your Auto Shot hits Dr. Boom for 432. (2.4s)
2/23 16:09:26.000  Your Auto Shot hits Dr. Boom for 437. (2.0s)
2/23 16:09:28.578  Your Auto Shot crits Dr. Boom for 1208. (2.5s)
2/23 16:09:30.890  Your Auto Shot hits Dr. Boom for 475. (2.3s)
2/23 16:09:33.750  Your Auto Shot hits Dr. Boom for 546. (2.9s)
2/23 16:09:35.203  Your Auto Shot crits Dr. Boom for 1227. (1.5s)
2/23 16:09:37.265  Your Auto Shot hits Dr. Boom for 516. (2.0s)
2/23 16:09:39.250  Your Auto Shot crits Dr. Boom for 1301. (2.0s)
2/23 16:09:41.187  Your Auto Shot hits Dr. Boom for 529. (1.9s)
2/23 16:09:43.171  Your Auto Shot hits Dr. Boom for 519. (2.0s)
2/23 16:09:45.390  Your Auto Shot crits Dr. Boom for 1263. (2.2)
2/23 16:09:47.140  Your Auto Shot hits Dr. Boom for 465. (1.8s)
2/23 16:09:49.203  Your Auto Shot hits Dr. Boom for 492. (2.1)
2/23 16:09:50.921  Your Auto Shot hits Dr. Boom for 492. (1.7s)
2/23 16:09:53.328  Your Auto Shot crits Dr. Boom for 1229. (2.4s)
2/23 16:09:55.140  Your Auto Shot hits Dr. Boom for 503. (1.8s)
2/23 16:09:57.078  Your Auto Shot crits Dr. Boom for 1244. (1.9s)
2/23 16:09:59.000  Your Auto Shot hits Dr. Boom for 494. (2.0s)
2/23 16:10:01.468  Your Auto Shot hits Dr. Boom for 506. (2.4s)
2/23 16:10:03.093  Your Auto Shot hits Dr. Boom for 507. (1.6s)
2/23 16:10:06.125  Your Auto Shot hits Dr. Boom for 531. (3.1s)
2/23 16:10:08.765  Your Auto Shot hits Dr. Boom for 511. (2.6s)
2/23 16:10:10.640  Your Auto Shot crits Dr. Boom for 1191. (1.9s)
2/23 16:10:12.656  Your Auto Shot hits Dr. Boom for 505. (2.0s)
2/23 16:10:14.578  Your Auto Shot hits Dr. Boom for 473. (1.9s)
2/23 16:10:16.515  Your Auto Shot hits Dr. Boom for 463. (2.0s)
2/23 16:10:18.796  Your Auto Shot hits Dr. Boom for 526. (2.2s)
2/23 16:10:20.890  Your Auto Shot hits Dr. Boom for 488. (2.1s)
2/23 16:10:22.609  Your Auto Shot crits Dr. Boom for 1216. (1.8s)
2/23 16:10:24.843  Your Auto Shot hits Dr. Boom for 463. 
2/23 16:10:26.734  Your Auto Shot hits Dr. Boom for 519.
2/23 16:10:28.546  Your Auto Shot hits Dr. Boom for 488.
2/23 16:10:30.671  Your Auto Shot hits Dr. Boom for 472.
2/23 16:10:32.609  Your Auto Shot crits Dr. Boom for 1187.
2/23 16:10:34.734  Your Auto Shot crits Dr. Boom for 1098.
2/23 16:10:36.625  Your Auto Shot crits Dr. Boom for 1111.
2/23 16:10:38.546  Your Auto Shot crits Dr. Boom for 1356.
2/23 16:10:40.250  Your Auto Shot hits Dr. Boom for 511.
2/23 16:10:42.718  Your Auto Shot crits Dr. Boom for 1334.
2/23 16:10:44.531  Your Auto Shot hits Dr. Boom for 559.
2/23 16:10:46.281  Your Auto Shot hits Dr. Boom for 537.
2/23 16:10:48.500  Your Auto Shot hits Dr. Boom for 462.
2/23 16:10:50.359  Your Auto Shot hits Dr. Boom for 509.
2/23 16:10:52.703  Your Auto Shot crits Dr. Boom for 1168.
2/23 16:10:54.609  Your Auto Shot hits Dr. Boom for 505.
2/23 16:10:56.406  Your Auto Shot crits Dr. Boom for 1219.
2/23 16:10:58.656  You gain Quick Shots.
2/23 16:10:58.890  Your Auto Shot hits Dr. Boom for 506.
2/23 16:11:00.750  Your Auto Shot hits Dr. Boom for 532.
2/23 16:11:02.843  Your Auto Shot crits Dr. Boom for 1116.
2/23 16:11:04.890  Your Auto Shot hits Dr. Boom for 475.
2/23 16:11:06.953  Your Auto Shot hits Dr. Boom for 481.
2/23 16:11:08.796  Your Auto Shot hits Dr. Boom for 431.
2/23 16:11:10.968  Your Auto Shot crits Dr. Boom for 1120.
2/23 16:11:13.187  Your Auto Shot hits Dr. Boom for 473.
2/23 16:11:14.296  Quick Shots fades from you.
2/23 16:11:16.015  Your Auto Shot crits Dr. Boom for 1008.
2/23 16:11:17.250  Your Auto Shot hits Dr. Boom for 419.
2/23 16:11:19.515  Your Auto Shot hits Dr. Boom for 431.
2/23 16:11:21.218  Your Auto Shot crits Dr. Boom for 1134.
2/23 16:11:23.703  Your Auto Shot hits Dr. Boom for 448.
2/23 16:11:25.640  Your Auto Shot hits Dr. Boom for 400.
2/23 16:11:27.781  Your Auto Shot crits Dr. Boom for 967.
2/23 16:11:30.203  Your Auto Shot hits Dr. Boom for 435.
2/23 16:11:32.015  Your Auto Shot hits Dr. Boom for 440.

Looks like a lot of your Auto shots are 2+ seconds apart. Not all, but I'd run this log through Glau's tool and see how bad your overall clipping is. It looks really bad.

And I need to stess again - the reason people see huge gains with the 3:2 macro isn't because it is super-better. It's because they didn't know had bad the /castsequence macro was clipping them.

Hrank · 02/23/08, 1:00 PM

Missing item:

[Shapeshifter's Signet]

The way I read what expertise rating does, taking it into account has about the same effect(s) as hit rating. The statistic doesn't exist (if I'm not mistaken) in the spreadsheet and would need to be added in the gear selection and on the custom gear tab.

Edit: thanks for clearing both things up. We're using the [ wowitem ] tag on our forum
Edit2: The ring actually adds 20 expertise rating. The dagger and feral rating are outdated.

◊ Lactose · 02/23/08, 1:03 PM

Expertise reduces the target's chance dodge and parry. Since ranged attacks are not subject to dodge or parry, Expertise has no effect on ranged attacks.

Edit: Also, the proper format for linking items is
[ item]Shapeshifter's Signet[/item] - without the space between "[" and "item]".

Ivaldi · 02/23/08, 1:04 PM

From Expertise - WoWWiki

One point of Expertise decreases the chance that melee attacks made by the player will be dodged or parried by 0.25%.

Only applies to melee, therefore is mostly a waste of itemization for a hunter.

Rokh · 02/24/08, 2:49 AM

Originally Posted by anjel

Cheeky, thanks for the quick reply.

1.) I think you are referring to the post where you mention trying to model the new macro? I guess by modeling that you would in effect handle the auto/steady/steady rotation for gear/specs where effective weapon speed was above certain threshold, e.g. MM or Surv builds.

2.) Is it more difficult to model [Thundering Skyfire Diamond] than IAoH or DST?

In any case, what do you think about these approximations/calculations (assuming pure auto/steady rotation with a BM build):

With no metagem your spreadsheet reports (using some random gear and AS/SS rotation):
hunter dps: 806.55

If I equip [Relentless Earthstorm Diamond] your spreadsheet reports (with the same gear & rotation):
hunter dps: 818.25

If I equip [Thundering Skyfire Diamond]:
I do the following calculations (for simple auto/steady rotation):
240 haste rating --> 240/15.7 ~= 15.3% faster attacks for 6 seconds
Assuming 1ppm, or approx. 10% uptime, you could say it averages out to about 1.53% faster attacks
That in turn (again, assuming AS/SS rotation) is about 1.53% extra dps
That would mean, hunter dps should be: 1.0153 * 806.55 = 818.89

Do you think I signifficantly oversimplified anything?

Now that we're done with all the hubbub for the most part about the 3:2 rotation modeling, I remembered this post and took a look again. For me, if those numbers hold water, the meta would be about an 8 dps upgrade over Relentless Earthstorm. Of course speed doesn't translate directly into DPS like that, but still, 8 dps is a large enough margin that I think it warrants at least some preliminary testing in the spreadsheet. I'll see what I can do, should just be able to change the numbers on IotH.

Revdarian · 02/24/08, 10:36 AM

There seems to be a bug on the latest Cheeky´s spreadsheet on the hit calculation, seems that due to a small slip it is considering the chance to miss lvl 73 mobs (bosses) as +4% instead of +3.6%, i noticed it as my programmed gear which hitted 137HR mark still shows a 0.4% or so chance to miss with shots, which we know shouldnt be.

EDIT:

Thanks for the answer then, hmm, guess i will have to throw in an 8hit rating gem in there then.

Cheeky · 02/24/08, 10:45 AM

Originally Posted by Revdarian

There seems to be a bug on the latest Cheeky´s spreadsheet on the hit calculation, seems that due to a small slip it is considering the chance to miss lvl 73 mobs (bosses) as +4% instead of +3.6%, i noticed it as my programmed gear which hitted 137HR mark still shows a 0.4% or so chance to miss with shots, which we know shouldnt be.

Latest results confirm base 9% miss chance against a target 3 levels higher.

Kharthus · 02/24/08, 3:15 PM

Originally Posted by rothomp3

Older versions of Mac Office don't work with any of the VB stuff, either. The only way to use the spreadsheet to its fullest is with a copy of Parallels and the Windows version of Office

That is very true. I'm running Office 2004 and lots of the buttons and pulldowns don't work correctly. And I'll still running a PowerPC machine so no Parallels for me until I upgrade.

Midnight · 02/25/08, 6:24 AM

There´s currently a bug on PTR that allows "duping" stats (details). I don´t see any harm beeing done using it solely on PTR but it´s propably a great way to (re)check theories about the two-roll system or internal cast speed of auto shot etc.

edit:
Timestamps in the Combatlog of me with 0.15s auto shot speed (1308.88% haste iirc) shooting at Dr. Boom

47.890
48.328 +0.438s
48.484 +0.156s
48.703 +0.219s
48.812 +0.109s
49.281 +0.469s
49.296 +0.015s
49.593 +0.297s
49.593 +0.000s
49.906 +0.313s
49.984 +0.078s
50.171 +0.187s
50.515 +0.344s
50.703 +0.188s
51.000 +0.297s
51.015 +0.015s
51.171 +0.156s
51.609 +0.438s

average time between 2 Shots: 0.219s

Unfortunatly I didn´t have the time to do a longer test series but it certainly seems like the supposedly 0.5s "cast time" of auto shot can be lowered with haste.

Blonda · 02/25/08, 9:21 AM

Hi, 1st time poster here.

I'd like to find out the best outcome for 3 talent point spots. Here is some rough math unless there are unseen variables I'm missing. {Givin a humanoid target}, 3 points into MS or HS.

18% bonus damage to your crits
or
3% damage to all hits+ 3% additional damage to crits. (includes the allready +3% regular hits)

to simplify, hits will be 3 shots and 1 bieng counted as a crit. or 33.33% crit

So far here is what i get.

The 18% bonus will get divided by (3) for the 1/3rd of the time you get the bonus used.

[top]6% bonus damage avg. overall.

3% to all over the same 3 hits will give you 9% bonus for each of the 3 hits and the extra 3% bonus added for the crit to the total.

12% bonus overall.

This topic was brought up before but was not accounting for the bonus to crit on HS.

Is this wrong? If so please help. Thanks

Caell · 02/26/08, 4:02 AM

Originally Posted by Novacaine

Note: All live testing were performed using Imp. AotH / Hourglass of the unraveller, Hunter Mark always up and Crit % was constant with the value I have, 30%. Live testing is a result of 3 sessions (Lenght of the session= time till I ran out of mana)on Dr Boom, under the same conditions.

For 1:1 Steady/Auto Rotation.

#showtooltip Auto Shot
/castsequence reset=3 Steady Shot, Auto Shot
/castrandom [target=pettarget, exists] Kill Command
/script UIErrorsFrame:Clear()

Reasons for different results:

Mistake in your 1:1 macro, needs "!Auto Shot"
Great dependancy of the 3:2 rotation on lag! (even small changes affect it greatly)
IAotH random procs
Hourglass of the Unraveller random procs
Different lengths of sessions probably (3:2 shorter than 1:1, uses more mana)

The most important reason ofcourse is the first one. Your macro actually doesn't fire autoshots, just turns them on & off.

Lawkenah · 02/26/08, 7:32 AM

Perhaps I have missed a couple threads here on the forums, but I swear I can't find anything on Haste gear or Armor Penetration gear. I've heard mixed things about haste gear being bad due to GC issues, but at the same time I have been told that's not true. Same issue with Armor Pen gear. People say as a Hunter you'd never be able to stack enough on your gear for it to be effective. Can someone please post a spreadsheet or formula that shows how haste/armor pen actually works for hunters. I would greatly appreciate it.

ghungadihn · 02/26/08, 6:07 PM

Anyone else thinking that Stanchion of Primal Instinct ought to be modeled in there? I know strength has no play for us but as a survival hunter the ability to pick up 105 agi on a single piece of gear is absurd. 350 armor penetration on top of that? The kittys are going to get pissed when we want to roll on their gear.

Glaurong · 02/26/08, 6:48 PM

I really can't see a guild giving you that unless it would rot otherwise.

Shivering Felspine - Items - World of Warcraft is only 13 Agi less.

Blade of Infamy - Items - World of Warcraft x 2 + enchants is only 9 Agi less.

Rifeus · 02/26/08, 7:52 PM

Am I saying something that's to obvious, but isn't the stats on the three new groonstalker items wrong in the spreadsheet?

I think it's supposed to be http://static.mmo-champion.com/mmoc/...6v3_hunter.jpg

[top]6% bonus damage avg. overall. 3% to all over the same 3 hits will give you 9% bonus for each of the 3 hits and the extra 3% bonus added for the crit to the total.

[top]6% bonus damage avg. overall.

3% to all over the same 3 hits will give you 9% bonus for each of the 3 hits and the extra 3% bonus added for the crit to the total.