Well given that this is the Hunter Spreadsheets thread, I'm moving all further discussion to this thread:

http://www.lurchington.com/misc/hunter_list.xls (updated pretty often)
http://www.lurchington.com/misc/hunter_list.htm (not updated as often)

Goal:
Provide a summary of what items I should be looking for in each slot, where they're from, and a quick snapshot of what they're worth. This was originally a personal project, so it was Horde, scryer only, with no profession BOPs, but I've completed enough that I'm trying to fill it out.

Currently:
Has a selection of items in each of the inventory slots, with what I've deemed as relevant stats for each. The front page has a set of constants up for a Pawn-style ratings estimate. You're encouraged to use your own constants for ranking. Includes gems at the front, and enchants per slot.

To add:
Fill out missing alliance, aldor and profession BOP items
Include leather
Include key items from pre-tbc
Add better logic for using gems in their correct slotted color, and handling gem bonuses better
Create some sort of summary page that shows what you have per slot, versus best available
Add in some sort of Item level / item level estimate similar to the calculator posted in public discussion

Suggestions that might be beyond the scope of this spreadsheet:

Combining it with other spreadsheets, especially Lactose's.
- I'll attempt to keep my lists updated, but I'm not intending this as an all-in-one solution.

I seem to remember test showing +damage scopes not affecting Steady Shot?

Yes, that's the consensus (haven't checked it myself). Sorry if I wasn't clear. The above calculation did indeed only consider a khorium scope increase in damage for autoshot; it's just that the dps is turned into faux rap since I'm used to comparing crit and rap for value.

Gloves are messed up, showing (red+blue) sockets for many items that have none. Also, beast lord are red+blue, not 2xred

Sorting would be easier if the headers were bold and there were no gaps (I know you can make some button-based sorting; I'm just talking about highlighting rows).

thanks for the tip on incorrect stats, those are kind of annoying to check. Not as clear on what you mean for the sorting. You mean the headers like Agility, RAP and etc? If so, not sure on the gaps you mean.

Well, added in some new SSC items from wowhead, and corrected the glove section. Available at the linked section.

Hi all. First, thanks Lurch for all the work. You have made my life much easier as a Hunter. I do have a question for all the Hunters out there. I realize that stamina has no affect on one's dps, and is therefore not accounted for in Pawn or the AEP figures from the other thread. But, I can't help but feel that stamina is somewhat important; how much, I don't know. My question is this. Are any of you changing the constants, whether it be Pawn or AEP, and assigning any weight to stamina, and if so, how much? For example, 2 items are within 3 Pawn rating points of one another, but the lower item has 30 stamina associated with it. I would assume everyone would go ahead and take the lower of the two items. If so, then a value has been placed on stamina.

Just curious if I am the only one out there thinking this way, or if others are reworking the numbers with a small value for stamina? Thanks in advance.

Thank you Bryne. Yes, I understand precisely what you are saying. An example if I may. If you had two items to choose from. Item (a) was 'worth' 200 and item (b) was worth 190, but item (b) had +30 stamina. Which item would you choose? If you say item (b), then you are placing a value on stamina, however small. But, I totally understand what you're saying. This is all new to me, so I am trying to get beyond the 'stamina is irrelevant' mind set, even though, as stated initially, it doesn't do jack for dps.

Honestly, I see it as very much identical to wearing resistance gear, when you need it, you put it on. I'd gladly use cloth with -stamina as long as I didn't die, if it gave the most DPS.

I always try to keep a little stock of items that, even thought they might not offer as much pure DPS as my current gear, serve their use otherwise. Examples might be +hit gear after you're hitcapped, just in case you need to swap out some of your regular gear for resistance / stamina, etc.

Lessons of Maraudon: Never sell / disenchant anything that might be of some use in a different situation, but don't use that gear as your normal gear either

I hate resurrecting older threads, but from the discussion, it sounds like there may be a newer version of Lactose's spreadsheet than the link in the OP? If so, could someone relink it for me?

(As a note, I like Cheeky's spreadsheet quite a bit, but it's not easy to compare items without going through individually and comparing the overall DPS numbers - not a big deal when you already have most of your end-game gear, but I put my hunter on the shelf for a while and have a lot of gear decisions to make as I level her up to 70.)

Thanks for the reply, Lactose, just didn't want to be missing out!

Cheeky: I've been playing around with your spreadsheet, but I've run across a strange phenomenon and I'm not sure whether it's "true," or simply an artifact and/or error (whether mine or the spreadsheet's). I selected a full set of tier 2 gear, full MM talents (including IAotH), and a GM bow. I used your prioritization for shot rotation (multi>steady), and came up with a hunter-only DPS of 841.28. I then started to play around with alternate bows (recalculating the shot rotation each time), but discovered that the GM bow gave me a higher DPS than every other ranged weapon on your list (again, hunter DPS only - it was even further ahead when you considered pet DPS, probably due to GftT).

I figured that faster bows would have a slight edge due to the increased IAotH proc, but there's something not quite right when a 55.8 DPS/1.8 speed bow calculates a higher DPS output then the 73.8 DPS/2.8 gladiator crossbow. I ran these numbers without IAotH and obtained similar results, which makes me think that there's something fishy about the calculations somewhere. Or are faster bows really that much better?

(Edit: If I only use autoshot and/or multishot, the values look more reasonable. I think the reason the GM/HW bow gives such a high DPS output is that you're basically able to fit in a steady shot between each autoshot without any "wasted" time. This means less longevity, I'm guessing, but higher DPS output during that time since the ratio of steady shot damage/autoshot damage is much higher.)