binky

My buffed crit rate is 36.96. The talents chosen were cookie cutter BM raid 41/20/0 with the exception of 5/5 Imp Arcane shot and 2/5 Mortal shots. Talent Calculator - World of Warcraft. The shot rotation is Auto-Steady-Auto-Steady-Arcane (1:1.5). All of the shot damages reflected the lowered critical strike damage bonus.

The shot frequency changed however. Auto shot frequency with 2/5 Imp Arcane shot is 2.71. With 5/5 Imp Arcane shot, it went down to 2.44. I assume this is due to the reduced CD of Arcane shot. Also, with 5/5 Imp Arcane shot, it takes me 48.71 seconds to achieve 50 shots. With 2/5 it takes 54.11 seconds.

God!!!! I hope I am not blathering! The DPS gain is around 20: not "huge" but a gain none the less.

 

Cheeky

It sounds like the increased frequency is overcoming the damage decrease.

Do you regenerate the entire rotation with 2/5 vs. 5/5 IAS? (I assume you are using the 1:1.X rotation button.)

Cheeky of Havoc

 

binky

I am on a Mac....I have never been able to get the "buttons" to work. I entered the rotations manually. I am looking at 2 different spreadsheets (one for 5/5 IAS and the other 2/5). The rotations are identical. The mana used is identical. The number of shots is identical. It is only the duration that is different. I think that means I regenerate the entire rotation. Is that what you mean?

 

Daenerys

I'm getting an error when I try to download today's Cheeky update. I can get the OO version fine, but I'd prefer to use the Excel version. I have an older version that works just fine. Anyone else having issues with the newest version (v.43)?

 

Flouyd

(Sry for my English I'm from Germany)

Ok I think I found a few flaws in the new shot rotation calculation

If I understand correctly with the castsquence option my lag is added to each SS because I have to wait for the server to confirm I’m done with my auto shot. That makes sense. But in the sheet I always wait 0,2 sec even when I shouldn't. For example:

-Steady starts 0,0 (GCD ready @ 1,5)
-Auto ends 1,3
-next Steady starts 1,7 (<-- this should be 1,5 because my client already knew I’m ready for my next SS and I shouldn't wait another 0,2 sec)



Another thing I notice is that the "castsequence-lag" is also added to arcane and multishot in the 1:1.x rotation. But I think those rotation doesn’t use /castsequence for arcane and multi. They are using /castrandom to wave in their shots so it would be more accurate to only add the "castsequence-lag" to the SS in those rotations

 

Rawman

I'm not sure if it's just me but I can't click the buttons in the spreadsheet. Save profile, import, etc.

Is it supposed to be like that?

 

Ikuzo

yes i have this issue as well. it reads my gear from armory just fine but it doesn't calculate any of the attributes.

Edit: it seems it had something to do with my shoulder enchant (Greater Inscription of Vengeance). i selected another one and then reselected the correct enchant (Vengeance) and it worked fine.

 

Jander

Base Mana Spring Gives 50 MP/5 since 2.2; still showing as 30 in the spreadsheet.

Mana Spring Totem - Spells - World of Warcraft

Can be talented for more.

 

Cheeky

What version are you using (OO or normal)?

What application are you using to view it?

If it is Excel, have you changed security settings to allow macros?

Did you think of using the search feature on these forums or look through some of the recent thread pages to find the multiple other times this question has been asked?

Cheeky of Havoc

 

Groznar

FYI - As Phaedryn pointed out, I think there's a problem with the buff profiles. You can rename them on the settings tab, but on the buffs tab if you try to use the drop down to change the buff profile to load or create a new one, the drop down is still protected.

 

Velvetjones

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.

 

cmott2000

For #1, please see multiple posts throughout this thread, Hunterlin's (post #1194) is here.

 

Opostrophe

And for some reasoning behind this :

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

 

Saryanne

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.

 

Cheeky

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!

Cheeky of Havoc

 

Uncas

Cheeky,

I could be wrong, but wasn't this spreadsheet set up so that the last "rotation" you chose...be it in the shot rotation, quickshots or DST tab would be come the displayed Hunter DPS in the Gear tab?...Well, I am no longer displaying this behaivor when trying to use the quickshots tab to test 1:1 priority vs 3:2 with all my different bows.

 

Saryanne

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.

 

Cheeky

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.

Cheeky of Havoc

 

MikeMo

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.

 

Uncas

so, the hunter DPS displayed on the Gear Tab is from the "shot rotation tab" only?

Oks

 

Cranch

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!

 

Uncas

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.

 

• Glaurong

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.

Log Parser for BM Hunters (Right click, save as) - Updated 10/11/2007

 

Elimbras