Probably from the fact that it actually does work that way for spell hits.

If I'm reading this right, weapon speed won't help you much since aimed shot and multi-shot were both normalized to assume 2.8 weapon speed when it comes to the RAP contribution.

That doesn't change the fact that slower weapons, by virtue of having higher damage ranges, still contribute considerably more DPS to multi shot over the long run. In the case that tict mentions though, it does seem kind of strange that you would get more actual DPS from a faster weapon with lower listed DPS. Both weapons are far too fast for a sane marks hunter to use anyway in my opinion.

I haven't gone in depth into Lactose's formula, but I was under the impression that MS wasn't a case of Heroic Strike where the top end damage particularly mattered. If that's not the case, then yeah, you got me.

I could somehow be looking at the wrong version of the spread sheet since no one has mentioned this, but the version I'm getting off the link in the first post appears to be calculating average damage wrong. For instance in cell B176, multishot average, it seems to be average the crit damage with the crit damage, weighted by your crit rate, when it should probably be your hit damage with crit damage, weighted by crit rate. Same for the arcane shot average in earlier cells, and possibly for some of the "current+1 agi" rows too.

It's an error I've fixed locally. I'm not going to upload a new version just yet though, have some other issues I'd like to fix first.
That and Fileplanet doesn't seem to allow me to keep 1 stable URL for the damn thing.

When comparing current/new item and changing the RAP contribution of the current item, the calculated dps for the new item changes. Don't know if that's the exact same thing someone mentioned above, so just in case.

I've been playing with Cheeky's spreadsheet, which I like since it has a shot rotation page allowing you to select your own rotation.

There does appear to be a bug on that page though -- if you select arcane, then it will shoot auto immediately, rather than with a 0.5 second delay. I did a combatlog to check what actually happens in the game, and indeed, the autoshot occurs ~0.484 seconds later.

The bug is in the P column equation. Currently, it is:

[top]O4+IF(L4

"Steady",BB4, IF(L4="Multi", 0.5, IF(L4="Aimed", BO4, IF(L4="Auto", 0.5,0))))

It needs to be

[top]O4+IF(L4

"Steady",BB4, IF(OR(L4="Multi", L4="Arcane"), 0.5, IF(L4="Aimed", BO4, IF(L4="Auto", 0.5,0))))

To fix the spreadsheet, enter the modified formula in the P4 cell, select the P4 cell, move the mouse to the lower right corner of the selection rectangle until the cursor changes to a +, and then drag the cursor all the way down the column stopping at row 53.

I added a small windserpent section to the spreadsheet to see the total damage done by hunter and the pet. Since the LB nerf, since LB is almost not scaling at all with AP, the value of hunter AP to pet dps is a lot les contributing than before while the crit chance of the hunter still plays a big role due to GFTT. Now after putting in the first numbers to see how much AP and how much crit rating gives the same overall damage boost, with no additional pet dps talents in BM tree, 1 crit rating is worth 1.48 AP for me.

Without contributing the pet part, it was 1 crit rating = 1.35 AP for me. I'll add some of the pet talents to the spreadsheet, stuff like Unleashed Fury and Ferocity. I'll stay away from the pet procs for this time being.

I've just tested this on version 7, and it seems to be working. I get the start of the arcane at 0, the end of the arcane at 0, the start of the Auto at 0, and the end of the auto at 0.5. I think you may be looking for the cast start time to be delayed 0.5 seconds with a 0 second cast time. What I have implemented it as is a 0.5 second cast time. The DPS will be calculated for both shots over 0.5 seconds of time, which is accurate with what you'd see in game.

Your changes would put a 0.5 second cast delay on Arcane shot. It wouldn't effect Auto shot at all.

No need to apologize. It's important to me to get this working as well as I can. I use it myself for deciding what gear to focus on getting or spend DKP on. Please continue to put it through it's paces. I'm sure there are tons of flaws and bugs in it still. Latest version (8) fixes (among other things) the upper damage of the Wrathfire Hand Cannon (168 vs. 186 - typo) which had been looking like the best ranged weapon in the game with the bug.

I am wondering if anyone knows the math behind proc over time items. I specifically ask because the Mark of Conquest trinket is working out to a ridiculous amount of mana regeneraton. I'm seeing a proc rate of between 8-9% on all shots. It would be nice to figure out if this scales based on weapon speed or not. I'm just not familiar with the TheoryCraft behind this mechanic.