Slingbow

Looking at the multishot calculations it looks like the damage bonus for PvP arena gloves is 4% instead of the new 5% Multishot Damage bonus that all seasons hunter gloves have.

 

-rusty-

ill check few WWS logs and PM you the proc rate after i find it out, or ill just leave it here

 

-rusty-

[Band of the Eternal Champion] is most likely the same ppm and %rate as Tsunami and Hourglass, check here
altho its %proc cant be compared to Tsunami and Hourglass since those are chance on crit and the ring is chance on hit, still the ppm is around the same

Cachera - WWS

Cachera - WWS


//Edit: http://elitistjerks.com/542918-post1386.html, id stick to the wws stats tho

 

_dodger_

I reported this before but it seems to have gotten lost (at least it is not in Lactoses list on the first page).

http://elitistjerks.com/543612-post1016.html

[Bladed Shoulderpads of the Merciless] have a socket bonus of 3 Agility in the spreadsheet (version 36 and 38). Correct are 3 Hit Rating.

 

Ticktock

I've been leveling up my hunter alt and these forums and awesome spreadsheet have been invaluable, thank you.

But, I'm having some confusion with the spreadsheet, my dps numbers are nowhere close to what is suggested =( so in an effort to figure out why I found that the spreadsheet suggests that my "Total base Damage" for autoshot should be: 814.94 but in game my autoshots are not coming anywhere close to that, they are averaging 490 ish? What am I missing? I have double checked that I have input my gear and spec correctly, I have not altered the default numbers for "Target Level" or "Target Armor" but my average damage isn't from raid bosses, rather world trash and Dr. Boom. I have been looking through this post for someone with a similar issue but haven't found one yet (it is 44 pages after all). Any help would be greatly appreciated, thank you.

My Hunter alt: Jorallan of Vox Virtus on Eonar (US)
The World of Warcraft Armory

 

Houze

The spreadsheet displaying the avarage of hits+crits, so if you hit for 500 and have 25% crits for 1150 (500*2.3) damage, it will display the auto shot damage as 662,5 (if i did the math correct).
I think the spreadsheet asumes Sunder Armor and Curse of Recklessness as default, disable those and other target debuffs and you will see numbers close to your Dr. Boom testing case. I don't know how high armor Dr. Boom has, but i think Lactose has posted the numbers on this forum sometime in the past, you maybe should adjust this in the spreadsheet. The spreadsheet also count hunters mark as fully stacked (440 AP) so you have to hit the target 30 times before getting the right numbers.

There are still a few target debuffs missing, like Misery and Blood Frenzy, guess they will come into the sheet soon Cheeky?

 

Cheeky

Yeah, they are on the list of things to do. I haven't had as much time lately as I'd like for development, but hopefully things slow down soon for me.

Cheeky of Havoc

 

Iriesaadi

Would it be possible to add an option in the buffs list for "Target's Resilience"?

It would be really nice to clearly see how crit and AP compare against a target with 400 resilience when looking to gem for arena gear.

I couldn't find another thread on these forums that had some math on AP vs. Agi for high resilience targets, if there is some discussion on this already, could someone please direct me to that thread?

 

Kirrina

Cheeky rocks, as per usual, grovel, bow, scrape.

Minor typos in Gems:
Eicked Flame Spessarite - remove, already there as Wicked Flame Spessarite
Fallen Star - should be Falling Star

 

Sorrugis

I am curious how people have set up shot rotations for their spreadsheets.

How often do you insert a KC? Do the BM hunters include multi-shot (due to not being able to use it during fights with CC or due to mana efficiency)?

I guess my best bet would be to run a 3 minute test on boom (seems it would be an accurate depiction since Rapid Fire is on a 3 minute cooldown), then go back through my log and insert all the data that way.

I would appreciate to find out how exactly others have set their shot rotation up for their spreadsheet though.

 

Thorongil

@Sorrugis: Firstly, I do everthing manually (KC is bound to a mouse-button - MX518 just rocks ). I use a 1:1 Auto-Steady-Rot with Arcane when it fits. I have been using Multishot everytime although being BM, but after doing a bit of research in here and in our Logs (other BM-Hunter in our Raid basically did the same DPS without using Multi at all) I dropped the Multi - a good choice, since it didn´t affect my DPS at all and made the rotation a bit more mana-efficient. I just use Multi on Trashmobs now, where real multi-hits are guaranteed.

Besides that I also use Scorpid-Sting normally when mana allows it to help the healers a bit.

I use KC anytime it´s availabe (normally every 5 - 7 seconds).

 

Jerem

The shot rotation you set up in the spreadsheet (and the one you will be using) depends on the fight, what mana regen you will get, if the fight relies on a constant, steady DPS, or on 'DPS phases' during which you need to burn, etc.

This is what will determine what rotation you need to use.
I make systematic use of KC.
I Scorpid-sting a boss on my tank's request.
Both my Arcane- and Multi-shots inflict more damage than an auto- or steady-shot, while consuming more mana.

A priority rotation, with Arcane and Multi whenever they're up, and KC all the time (KC is almost always up, the cooldown is the the limit here), is the one that nets me the best DPS.
A standard Auto-steady rotation is good, sustained DPS "that can last forever".

What and when you use it is situational.
If you take, lets's say, Tidewalker : it's a long fight, you might want to go with a standard auto-steady-KC rotation.
If Morogrim is JoW-ed, and/or if you have a SP, or mana-tide totems, you might want to go for a higher damage rotation (we tank murlocs on top of Morogrim, so Multishot is a winner when murlocs are here).

Basically, as a BM hunter, auto-steady is your base "DPS sequence" and once you start knowing the fight, you squeeze in as much DPS as you can (for me, that means replacing steady shots by arcane or multishots), depending on your mana bar, your tank's aggro, your positionning, and so on.

 

Sorrugis

Personally, I am lucky enough to be able to run with a SP in my group for 90% of my runs. Last WWS I have recorded ( Wow Web Stats ) was unfortunately one of the days when our SP was out on vacation, but I have never been one to be afraid of chain chugging mana pots for optimal DPS.

I guess my main question is not that of which Shot Rotation everyone uses, but whether or not there is an "easy" way to sync up my spread sheet's shot rotation tab as close as possible to my true in game shot rotations.

Maybe there a mod other than Recount (for some reason it flashes like a disco ball for me, I imagine another mod is messing with it's ability to read me as in or out of combat), that will allow me to go back and look at a complete shot rotation log for the night?

Mainly, I just want to make the tab as precise as possible. I hate to keep my spread sheet at Auto-->Steady-->Auto-->Steady when this isn't what is actually going on.

Any advice would be greatly appreciated. If anyone can save me from an all night spread sheet shot rotation project, I would be in your debt.

 

Shibam

I get the same error from v38, and it asks to end or debug. Debug taking you to an editing page which i know nothing of and end...ends

 

Cheeky

Armory has been really sluggish the past few days. I'm seeing the same problems. If anyone knows how to increase the time out delay on the embedded XTML stuff in Excel I'm all ears.

Cheeky of Havoc

 

Slunter

This small "issue" still haven't made it's way onto the bug report.

 

◊ Lactose

Sorry, was sure I'd added it already. Should be sorted now.

US armory seems to have issues in general lately, when I've tried to do normal searches there I've just got error messages in return.

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

 

infamy

It seems to be pretty speedy this morning, the numbers fly in. However, I'm still getting the timeout message immediately after the speadsheet hits a custom piece of gear. (Ring of Ghoulish Delight). A soon as I hit OK on the custom gear warning (I'm not letting it sit for any time at all) I get a timeout.

Don't know if that's helpful for bug squashing or not, but I wanted to let you know.

Love the spreadsheet, thank you. I've been working with it all week and the results were very apparent on our last raid.

 

Lukian

Missing a few new items in 2.3:
Pouches:
Quiver of a Thousand Feathers - Items - World of Warcraft
Netherscale Ammo Pouch - Items - World of Warcraft
Knothide Ammo Pouch - Items - World of Warcraft
Knothide Quiver - Items - World of Warcraft

 

Zomghuntar

I keep getting "Band of the Eternal Champion is not a supported Ring2" every time I try and load [Band of the Eternal Champion] from the Armory.

Also I noticed that loading from the armory kept swapping my second and third gems on my [Bow-stitched Leggings] not really sure if that's just a bug or a fluke.

 

Meleshooter

i know that spicy talbuk is new, but the calc is wrong. i have the 38 version

on the buff page totals are correct but when figures are xferd over to the gear page, the +20 hit is listed as +20 Mp5

thank u for haveing the hand adjust. i temp fixed it through that.

i wish i had this when i hit 70 and started getting pre-kara gear.

Thanks, Meleshooter of Eitrigg aliance

edit...
dont know if this will fix the time out but might point u in right direction. google search FTW

Socket connection timeout - MSDN Forums

 

Bullshot

On the Pet page, with a Wind Serpent as the pet and Lightning Breath as the primary attack and Bite as the secondary attack, Bite's DPS doesn't seem to affect the pet's final DPS. Bite's rank has been correctly set and shifting the ranks around doesn't seem to make any difference either.

 

Trohck

If Bite is set to secondary attack, the only time it will be used is when your pet has focus in between 35 and 49 (inclusive). So I wouldn't expect it to have much impact, and I'm not sure the spreadsheet is (currently) sophisticated enough to handle complex pet focus scenarios.

 

Sympa

This is a question reffering to Darkmoon Card : Crusade. In the spreadsheet how does it qualify the damage gained from the trinket? A flat 120 AP? The reason I am asking is that when on a simple tank and spank like Teron there are many instances of my kill command triggering the spell damage portion of the trinket even up to the trinkets full 10 stack.

http://wowwebstats.com/whlew4kbsr6zy?s=14690-14979&a=3

I suppose the real question is, does the spell damage from the trinket affect kill command damage at all?

My blog, about wow and the like.

 

PSK21

I've searched this thread a couple of times, but without any luck so I decided to post in hopes someone can help me out with this problem.

At work I run Excel 2000 and this spreadsheet works perfectly, however when I get home and run it on Excel 2003 I get this error:

Run-time error '91':
Object Variable or With Block variable not set

When I enter debugging mode it takes me to the "Scrapitems" modules and points to this line in particular:

If Node.Attributes.Length = 0 Then

I've been looking around on the internet to some how disable the VB debugging becuase it also detects a run-time error with the WoW Launcher but I've had no such luck either. I think both errors are directly related this VB Debugging program.