Gadget

Is there a way to add the correct Steady/Arcane rotation to the spreadsheet?
--> Steady, Arcane, Auto, Steady, Auto, Steady, Arcane, Auto,...
I would like to weave in Arcane in the gap between Steady and Auto and not just use it instead of Steady.

Since, what it currently calculates is:
Steady, Auto, Arcane, Steady, Auto, Arcane,...

Comparing my current gear with Sunfury and Wolfsniper, I don't find anything to backup the current "rumours" that Wolfsniper is better for BM DPS. On a Steady rotation, Sunfury does 54,760.97 DMG while Wolfsniper does 51,411.22 (0.00 Latency). Result does not change when entering 1 as Latency. Where did those guys get their impression? Or, otherwise, what am I doing wrong?

 

• Glaurong

You are forgetting about the global cooldown. You cannot fire arcane in a tiny gap, you need 1.5 seconds.

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

 

tict

Cheeky, apparently (on worldofraids.com) the haste mechanic has been nerfed for melee (goes from 10.7 to 15.7 per%). It is all over the boards atm. Anyways, was wondering if you could make the adjustment on a"beta" version of your spreadsheet. Would like to see what the nerf does to haste in general and the dragonspine.

Possible? Thanks

 

Cheeky

You can change the shot rotation to anything you want, the timings will adjust automatically.

The Sunfury does more damage, but the Wolfslayer does it's damage in a shorter period of time. Short enough that unless you are clipping will out-DPS the Sunfury. Don't look at total damage, look at DPS. By the way, these are not rumors. They are the result of the basic Hunter shot mechanics.

And latency is in seconds. 1 second latency would be brutal. I tend to use 200 ms (0.2 in the spreadsheet) personally.

Cheeky of Havoc

 

Sartuk

So, with the upcoming haste rating hit, how viable is Crystalweave Cloak going to become? Right now, according to the spreadsheet, it's just about the best cloak upgrade I can find. With my dark cloak of the marsh equipped, I'm sitting at 1125.15 listed DPS (assuming 3000 mob armor, for the heck of it). With Crystalweave, it balloons up to 1142'ish. Any speculation on what sort of hit this cloak is going to take with the upcoming change?

 

• Keltan

You can enter -8.6 into the Haste cell of the Hand Adjust line to simulate the loss that the Crystalweave will get if the PTR change goes live.

10.5/15.7 = ~0.6688

x/26 = 0.6688

x = 0.6688 * 26 = 17.3888 (this is what the 26 haste rating will turn into using current server percentages)

26 - 17.388 = 8.6112

For me, this change will make the [Blood Knight War Cloak] slightly better than the [Crystalweave Cape].

My dps with current haste Crystalweave Cape: 1583.51
My dps using Blood Knight War Cloak: 1575.30
My dps with PTR haste Crystalweave Cape: 1573.26

 

Zene

This may have been brought up before but I could not find it using the search functionality...

First, kudos on the spreadsheet Cheeky. It's quite easy to use and very helpful!

Is there a way to model armor/physical damage reduction on a mob? For cases like Steady Shot doing more damage than Arcane Shot according to Cheeky's spreadsheet with my current gear. I can imagine this is true if the mob had no armor, but with damage reduced from the Steady Shot and the Arcane Shot being unaffected (assuming no arcane resistance) then Arcane usually ends up doing more damage.

 

Cheeky

There is a place to specify target armor on the gear page. Maybe I should move that stuff to Settings now that I have that tab added.

Cheeky of Havoc

 

Zene

Ah, my mistake. Sounds like a good idea, that whole little subsection with the mobs level and type would be easier to see under the Settings tab. I totally missed it when I was in the gear section. The orange and yellow tend to blend in a bit.

Thanks!

 

cmott2000

Is there a way to fill in Cheeky's spreadsheets with data from the Armory or other character snapshot sites? I'd like to use the spreadsheet to analyze hunters other than my own but I'm spending a lot of time trying to get the gear and talents into the spreadsheet.

 

Zene

I don't know of a way. But that does raise an interesting idea or feature request of somehow extracting the XML Armory data to be used within the spreadsheet.

 

Cheeky

If someone shows me how to do that I can look into adding it. I don't think it's going to be trivial though.

Cheeky of Havoc

 

ichiigo

Hey, ive downloaded the spreadsheet and opened it with openoffice however i cannot get the right names for the gems thus impossible for me to see my real stats. does anyone know what the problem could be? for example meta socket (24ap) swiftskyfire diamond is not in the list, infact only the gems that are in the default premade model are in the list:

http://i12.tinypic.com/6fh9cur.jpg

 

Trohck

Cheeky, can you please add [Messenger of Fate]? Thanks.

edit:
Also, [Balanced Shadowsong Amethyst] is listed incorrectly. It has the correct stats in the math portion (10 AP, 7 stam) but the item name says 3 stam, 4 crit.

 

Ailee

Cheeky, I have a simple question. I'm trying to determine ways to help other hunters and want to research it a bit before sending in a suggestion.

How much, if any, would DPS be impacted if Steady Shot had it's cast time reduced from anywhere from 0.5 to 1.0? I'd imagine that clipping wouldn't be as abundant and should bring the perfect timing issue down a notch. I tried to emulate it on your spreadsheet, but due to permissions I was unable to. Of course the GCD would prevent rampant abuse, but those that are excellent hunters that manage their timing to a 0.2 delay could see an improvement and those that are terrible could even see an improvement.

 

Cheeky

Since the Gem locations are unprotected, you can modify the Validity for the cells yourself. Select all the gem cells simultaneously and change the Validation to be =Gems (default will be =INDIRECT(xxx) - different for each cell). You should be fine doing that,

Open Office doesn't support as many nice features as Excel does. I will try and include some simple directions for handling some of the Open Office deficiencies.

Steady Shot cast time is part of the core mechanics. I never envisioned anyone wanting to change it. From a theorectical point of view you should be able to peform the analysis you want yourself. The damage doesn't change, so you can use the spreadsheet for that and do your own timings for shots.

Personally I don't think you'll see much DPS change (or any) unless you have a very high latency value specified. Decreasing the cast time just makes using a /castsequence macro much easier and less prone to clipping. It won't buy you more shots because of the global cool down, as you identified.

Cheeky of Havoc

 

Ailee

That is what I expected, but what I'm looking in to is making a suggestion to send to Blizzard to hopefully make the class a lesser hassle to deal with when attempting to DPS in a raid setting while having little to no impact on PVE DPS and especially PVP. Thanks for the input.

I don't really want to change the mechanic of the cycles or cast time of Steady Shot, but just try to do what I said above. To maintain a perfect rotation in comparison to a mage is night and day.. I guess it's hard to describe without someone exactly coming out and saying "it is difficult to keep the rotation with no clipping for hours.."

 

Ralith

I just downloaded this sheet and choose what gear I have but it shows me doing over 900 damage on autoshot when my Armory profile has me at just under 700 max auto shot damage?

The Armory

Also shows me doing nearly 1,500 dps which is completely ridicules (I know it is set for 0 armor but even at 10,000 (Almost 50% reduction) armor I still have nearly 750 dps which is high for my gear).

Am I missing something here?

 

cmott2000

Bad news: Extracting the items from the armory looks like it would be a painful ordeal! It uses a database lookup table somewhere and then populate the xml with an ID and an icon. When you mouse-over the item, the database is queried for the entry with the corresponding ID and then the item's details are returned. It would not be easy to extract the name (Cheeky's identifier) of each item from the XML.
The good news (you knew this was coming): the talent build would be easy to extract! Clicking on the Talents tab loads XML that contains a tag called talentTree, which is a simple number with an entry for each talent. At 57, here's my talentTree entry (41/0/7):
talentTree value="2320300051521215210510000000000000000000011302000000000000000000"

Also this value is the same as the one that is used on the Talent Calculator page (Export Build produces the same number appended to the url). Seems that it would be straight forward to have a cell that accepted a number like the one above and filled in the talent section of the spreadsheet. I know, I'm too lazy to do this manually (like any good programmer).

Disclaimer: I don't know if Bliz frowns on/forbids us to extract this information automatically.

 

Cheeky

Your paper doll does not factor in on-proc +AP/+% benefits to damage, nor the effects of critical hits. I do.

And the numbers are correct if you can actually stand still and just DPS, timing your shots to the latency you specify. That's pretty much impossible for most raid bosses, so think of it as a potential, not a baseline.

If you don't believe the numbers you don't have to use the spreadsheet.

Cheeky of Havoc

 

Ralith

Hmm... I have the averging out of ap trinkets/BM off...

I'm not saying what you wrote is wrong, just that I am probably missing something here.

Because even with crits... thats only +~20% damage or so (With a 20% crit)... and 555-692 damage is 623.5 average... *1.2=748.2. I can't see where the spread sheet is getting 921 auto shot damage from that... thats an extra 175 damage almost (All buffs should be off... Hunters mark gives some if it is counting that there but not 175 damage). Add in the talent for crit but thats an extar 30% damage on crits which would be... 623*.2=124*.3=37...damage... (738+37=785) So thats still over 130 more damage to account for that I can't find...

I'm just trying to figure out how to work it because I can't be doing it right and getting that I can do nearly 1k dps when I've never come near that before.

OK I just tested it with NO ARMOR except my weapon and I STILL at 632 DPS!!!! At 5000 armor I'm doing 430 dps with NO armor except my bow! What am I missing?

BTW whats a fair armor value? Most bosses have somewhere between like 15-30% reduction don't they?

 

Cheeky

Since the point of the spreadsheet is sustained DPS, I work out Hunter's mark as a maxed value of +440 AP. That's a fair bit of damage for most weapons, +88 for a 2.8s weapon.

Please look through the calculations tab, I really try to spell out each part of the calculation in mind-numbing detail. You may find a bug in it. I'll use my own values real quickly to illustrate Auto Shot:

[Don Santos' Famous Hunting Rifle] - 199 average damage.
[Felbane Slugs] for a 2.7s weapon - 99.9 damage
2454.62 "Effective RAP" (Gear, Aspect of Hawk, Hunter's Mark, Santos' proc, averaged trinkets) for a 2.7s weapon - 472.39 damage

Shot damage before modifiers - 772.29
Critical Hit chance - 24.92% for 236.9% damage
Hit chance - 98.7%
Effective, average gain from Hit/Crit - 132.82%
Focused Fire - 102%
Average Ferocious Inspiration effect - 102.95%
Total Adjustment (multiplicative) - 139.48%

Total Average Auto shot damage - 1077.19 (paper doll average of 682)

Cheeky of Havoc

 

LokE