Two observations (on the latest spreadsheet version - 43) that I noticed but didn't see addressed in the thread-

1) It appears that the best DPS ranged weapon in the game is the Wolfslayer Sniper Rifle. I ran all the weapon combo's against my gear just to check. This surely has to be a stat bug for this weapon. As much as I like Kara and the Opera event I don't think this weapon is better than Bristleblitz or BoBB.

2) The spreadsheet doesn't appear to adjust DPS if haste pushes Attack speed below 2.00 secs and thus shot clipping occurs. As a BM hunter it doesnt take very much haste to push the ranged attack speed below 2.00. For simplicity sake: assume you use a 1:1 auto/steady shot rotation- A sub 2.00 second attack speed will cause you to clip shots and really impact your DPS.

And for some reasoning behind this :

WoW-Europe.com Forums -> Analysis of Hunter DPS mechanics

Hey Cheeky,
You know I love your spreadsheet, reccomend it all the time. However, since I have a Rogue as well and have been helping our guilds Rogues, I have been messing around with their spreadsheet. In many many ways, the Hunter one is clearly superior, being far faster for one. However, there are a couple of features they have that I was wondering if it would be possible to incorporate into the Hunter version.

1. On the Rogue version, once you get it all set up and sorted, it actually has a list of items that are a DPS upgrade for you. You can actually mouse over your gear page and it will show upgrades for that spot. There is an option to turn this on, called "show only DPS upgrades." This is pretty sweet. I understand that it may involve far more computations and such, but is it possible?

2. It has options to remove gear selections for certain instances. For example, if I am not in BT or MH, I can filter out those items. Also listed next to the names of items from the drop down menus, it says what instances they come from.

Don't get me wrong, your spreadsheet is awesome, this isn't criticism, just some input. Hell man, do you have a paypal account? I think you should be rewarded for your work.

I like both of those ideas. It just comes down to the amount of time I can spend on improving this. The #1 unsupported-yet-asked-for feature is some sort of gear planner. I have a few ideas about that, and I've gotten several suggestions on how to implement a ranking system.

I'll take a look at the Rogue sheet and see if I can plagurize some of their better stuff!

Cool, if you look at the Rogue sheet, don't look at their newest version, they jacked up part of it, specifically the parts I reccmended. I would go back to the version before the current. I'm at work and can't give you an exact version, I have firewall issues at work.

It'll show up as 1:1.5, since the logic just compares Auto Shots to Specials. And I'm probably not going to put in logic there just to make it display 3:2. It's not wortht he effort, and the name "1:1.5" is technically more accurate.

Hello Cheeky,

I was glad to see the suggestion I made was implemented with your spreadsheet (buff profiles). However, I am having issues with it. Every time I try to change it I get an error stating that the cell is protected and read only and tells me I will need to turn off protection. However, when I try to do this it asks for a password. I am using Excel 2003. I also ran into this problem trying to make a Custom MH for the Shivering Felspine. I have my security set to the lowest possible for macros but most likely there is something else i need to change. If you or anybody else could help I would be greatly appreciative.

You can already do this via www.lootrank.com/wow; just plug in the attribute values you get from the spreadsheet.

The correct DPS upgrade algorithm is tricky because there are 2 variables: the dps upgrade including +hit and the dps upgrade not including +hit.

For example, I can get a higher dps by apparently lowering my dps swapping an item with +hit for one without +hit, and then swapping a second item without +hit with an item with +hit. Searching for such upgrade paths is really too much to ask of the spreadsheet, IMO. There are more important things for Cheeky to spend his time on!

Cheeky, I have a concern via the 3:2.

I was doing a lot of theory crafting of my currect gear options using your spreadsheet.

Spreadsheet: QS tab, 62 haste, 117 HR, Aspect of the hawk (I have 5/5 IAOTH) latency .2sec, no other buffs, i couldn't find a way to indicate for sure that the target was marked, I assume that is the case.

1:1 steady 1:1 Arcane/steady 3:2
Wolfsniper 836 849* 724

SS longbow 840 865* 782


Dr. Boom in game 62 haste, 117hr, Aspect and mark on Boom, latency was .2sec as well

SS longbow -- 803 ± 33* 880 ± 64

*order was auto, arcane, auto, steady, auto, steady, auto , steady, repeat


Now, I am not concerend about the drop from 865 to 803, what does bother me is the complete flip flop from the 3:2 in the spreadsheet vs 3:2 in live testing. I only bring this up as I was performing the Boom tess with a variety of weapons and also went through a lot of different gear combinations / rotations on the spreadsheet.

The general conclusion from the spreadsheet, through out a variety of set ups was that a 1:1 priority with Arcane/steady should outperform a the spreadsheet 3:2. But repeatidly, on tests on Boom with wolfsniper, steelhawk, sunfury or SSL, the 3:2 produced better DPS.


So, my thoughts:

1. The spread sheet is set for a lvl 73 mob...I couldnt change the custom option (probably a office 2007 problem) (maybe there could be a Dr. Boom option?)...hmm, how much would this effect?

2. Maybe my testing method was off, but I was trying to replicate the spreadsheet. I did 4 tests at 60 sec intervals (so I wouldn't worry about mana consumption). I think there needs to be a discussion started to decide what is the right way to test, and the wrong way. I know I added a lot of variables with my tsunami trinket and leaving Hawk on, but thats what the spreadsheet has on. Usually i test with hawk off and a different trinket in that does not proc (skyguard is a fixed crit, and I wont trigger the proc).

3. Maybe its a problem with my gear, I know, I need more hit rating, but I am pretty sure the alck of hit would translate evenly to both a 1:1 and a 3:2. (without the haste, I have 136 HR)

4. Your model of the 3:2 isnt exactly on target with what is actually happening. Note: I am not complaining, I am fully aware of the whole cluster fuck that is "what is the 3:2 macro actually doing?" problem. Just trying to point out a concern I currently have with your model


** I could do more tests, but it probably wont be until tomorrow. Name the way you want me to test and I'll do it.

Anyways, good work, keep it up, and thanks again.

The spreadsheet models a point in time in an infinite duration fight against a specific level target with a certain armor. HM always stacked up to full, any randomness averaged out.

Any test you do will have a large degree of uncertainty unless you collect thousands of shots in the exact same environment the spreadsheet models.

I don't model a 3:2 macro, I model a 3:2 rotation. I'm pretty sure that under Quick Shots your macro actually produces a 1:1 rotation. Plug that in and see if it matches up better.

No.