Cheeky

You know, I'm going to do that. Because I get asked it a hell of a lot more than you see in this thread.

Cheeky of Havoc

 

Zediono

Maybe put a FAQ page actually in your spreadsheet answering the 20-30 most commonly asked questions such as this one, that could help. Although it might be annoying to do and some people might still not read it

 

Midnight

Oops, how embarrassing.
I usually try and search the forums and threads for answers first, I guess I forgot to do it this time. Sorry Cheeky I bet you´ve got enough work to do as it is.

 

Slunter

Excellent work Cheeky - love your spreadsheet!

[Badge of Tenacity] doesn't appear to affect the dps calculation in any way.
Expected this to be weighted into the calculations as all the other 'use' trinkets.

 

train

sorry if this has been answered, but i'm wondering if you are planning to add the new 'ignore opponent's armor' to the spreadsheet.

 

Vegelus

It is there already, since BT at least. Look for Armor Penetration.

 

Chupacrbrae

Under chest enchants, there should be a major resilience adding 15 res

 

TheIceMan

Armor pen (84) missing @ season 3 head

http://armory.mmo-champion.com.nyud....83264tfnaZ.png

 

Berkut

OK, how do I get the buttons to work in the spreadsheet?

 

Flyx

Enable the macros.

 

Komatose

Couple things I noticed:

--Major Intellect Enchant to 1handers appears to add 9 stamina instead of 30 intellect
--No PvP trinkets (Intentional? Ignore this comment if so.)

--Third thing: it's possible I'm not looking in the right area, so bear with me. Background: I'm mainly focused on PvP. While trying to determine the Careful Aim vs. RWS decision (and likewise, the 2hander-agi enchant vs. 1handers-intellect enchant), I noticed there is no indication that total RAP is increased in the Gear table when CA is maxed out (3/3). I'm not sure if this is an oversight or not. I have manually added the potential RAP increase (hand adjust row). In doing so, it sways the talent-spec decision. I just don't want to be doubling up RAP if its already hidden somewhere I'm not looking.

Other than those few things, the spreadsheet is a godsend. Amazing work.

 

Juggernaught

Hey there,
Firstly, thanks for putting so much time into such an invaluable tool for all us hunters. I don't know what I'd do without it now.

I have but two questions though.
1. I was wondering if there were any plans to average out the AP gain from bloodfury like you can with trinkets?
2. Are there any plans to increment the AP gain from Hunters Mark? Currently it is treated as a flat 440AP. In reality though it starts at 110 and increases by 11 for each hit up to 440, therefore a faster weapon/shot rotation would reach the 440 AP cap quicker than a slower one, give a higher average AP over the 2 minute duration of Hunters Mark than a slower rotation would.

Once again, thanks for giving us such a great tool.

-----------EDIT----------
Actually, I do have two more questions...
3. Concussive barrage isn't currently taken into account. It's a 2%/4% chance to daze the target for 4 seconds. Steady shot does an extra 175 damage to dazed opponents. So providing your target isn't immune to daze effects, it's an extra 1-2 x 175 damage (depending on weapon speed and rotation) when it procs. Which is a minimal dps increase in reality, but an increase none the less.
4. Serpent sting is still only doing 660 damage in the spreadsheet. It now does (0.1*RAP)+660 damage, which although still means it's hugely mana inefficient for the damge it does, it may possibly be useable in a rotation now (??) as that damge is not mitegated by armor.

Although I guess they weren't really phrased as questions...

 

Juggernaught

There's always one other thing, which is more of a musing really...

I'm wondering how the Shots per 8 seconds is calculated for Master Tactician?

I have a 3.0 speed weapon (2.609 actual speed), 4/5 imp Arcane shot, and using a 1:1.x rotation (arcane only) with a 0.2 second latency, and I'm working on the assumption that you are using Uptime = 1 - (ChanceNotToProc^Attacks)

My shots per 8 seconds in the Master Tactician section of the calculations sheet shows 7.4. However, I think this value is too high, certainly in my situation.

I have gone through my full rotation and worked out how many complete shots can be landed within an 8 second window after each shot is fired. Any incomplete shots will not effect the proc chance of Master Tactician so should be disregarded.

My rotation consists of 5 shots, so it was a fairly easy pattern to work with.
Autoshot
7 shots can be landed after this shot within 8 seconds.
Steady Shot
7 shots ...
Arcane Shot
6 shots ...
Autoshot
6 shots ...
Steady Shot
8 shots ...
and the pattern repeats.

This gives me an average of 6.8 shots per 8 seconds. Then you have to factor in my miss rate of 0.73% giving 6.8*0.9927, giving me an average "Shots per 8 seconds" of 6.75.

Unless I'm missing something obvious?

 

Midnight

In an efford to make up for my unnesseccary question above I´ll try to answer a few questions whose answers seem obvious to me. Feel free to correct me if I´m wrong of course.
PvP trinkets won´t influence any calculations performed by the spreadsheet, so it propably doesn´t really make a lot of sense to include it. If you want to check your DPS with a pvp trinket on, just leave the row blank.
RAP is calculated even though it doesn´t show on the gear sheet. Check the RAP section of the calculations sheet. It does take into account Careful Aim too.
I assume this is intentional as the spreadsheet aims at calculating your dps agains bosses and bosses usually can´t be dazed.
It seems like all other shots still scale way better. That means that depending on your enemies armor at some point there´s a break even where the other shots will do more damage. From my personal observation I´d say this break even is somewhere around T4ish quality gear.
Nevertheless I agree serpent sting should be modelled correctly as soon as Cheeky finds some time to integrate it into his spreadsheet.

 

Rhaeti

Nevermind

 

Cheeky

The question on Careful Aim was answered correctly above. Thanks for spotting the melee enchant fuck up. I'll get that fixed. The PvP trinket will be added, just so resilience can be tracked (and Armory scrapes.)

1. Good idea. Will add it in the next version (due out later today, actually.)
2. I model an instantaneous point in an infinite length encounter. I'm not really interested in looking into build-up times and all the work that would take. I can provide a rough "time to maxed out mark" though, I'll look into it.
3. See here for the math on how useless that ability is. If I'm really bored one day I'll add it in.
4. Corrected in the next version.

I use a weighted Shots per Second over all haste states. This won't be perfectly accurate, since in general you don't have partial shots in the real world. Like most models in the spreadsheet this is an approximation. You can trace the "Shots per Second" calculation back to the different Shot Rotations. If you find a bug, I'd love to hear about it, I'm not 100% positive it's all completely correct.

Cheeky of Havoc

 

Cheeky

Change Log:
- Changed more item names to match Armory values.
- Added RAP scaling to Serpent Sting.
- Fixed Dory's Embrace socket.
- Added support for Signet Ring of the Bronze Dragonflight, Violet Signet, and Band of Eternity reputation rings. They can now be scraped from the Armory.
- Corrected a bug where Spicy Hot Talbuk wasn't being added in properly.
- Corrected some item stats (Retainer's Blade, Vindicator's Chain Helm, Choker of Serrated Blades, Vengeful Gladiator's Chain Armor).
- Fixed mistake in Stamina and Intellect on Melee Weapon enchants.
- Added in Orc racial Blood Fury, you can control averaging it out on the'Settings and Results' tab.
- Added new gear (Medallion of the Horde, Medallion of the Alliance).
- Factor Hit % into calculations for Master Tactician (my interpretation of "successful ranged attacks")
- Fixed mixup on Helm socket bonuses being switched for +RAP/+Crit
- Adjusted Aimed Shot to 3.0s base cast time.
- Added new enchants (Major Resilience to Chest).

Still working on the Enchants from Armory. It's a real pain in the ass.

Cheeky of Havoc

 

Amiyuy

Nevermind, I think I figured it out.

Thanks for the awesome spreadsheet and updates!

 

Juggernaught

Just trying v 38. I now get the following error when I "Load Gear from Armory":

"Object variable or With block variable not set"

in the following place:

-------------------------------------------------------------------------------------------------
Function getItemName(id As String)
Dim url
Dim name

url = "http://www.wowarmory.com/item-info.xml?i=" & id

Set Node = getsingledata(url, "//itemInfo/item")

name = Node.Attributes.getNamedItem("name").Text <----------------- At this line.

getItemName = name

End Function
-------------------------------------------------------------------------------------------------

I've tried with the default settings for yourself, as well as for a few of the hunters in my guild and get the same error each time.

----------EDIT-----------
This is all working now. I've re-downlaoded the spreadsheet to make sure it wasn't something I had changed, and that works correctly as well now. Perhaps it was a connectivity problem my end causing it...

 

Juggernaught

I noticed another thing.
I was grouped with a BM hunter last night, and noticed that you can't add Ferocious Inspiration on the Buffs page (TSA and EW are there tho)

 

Toetje

Hey there, my first post and i want to say AWESOME work . Very nice guidance.

But 1 thing, at the custom page, i can't find a tab for "ammo" the rest is there ;-).

(i was trying to fill in the new ammo in an older version (36, with working armory button) thats why i came by it)

 

minoshei

Hey sorry to ask but i wanted to know if the badge of tenacity when equipped take into account the added dps to expose weakness :S I was switching it with my abacus of the violent odds and every time i would go see in the calculation: exposer weakness, nothing would have changed :S

also, i dont know if this is stupid from my part or not, but would it be possible to add stormstrike in the debuff's considering it could add dps if my pet is a windserpent >.> dunno if it was there and im just stupid and i cant see welll

 

Fleabite

Sorry if this has been raised (altho i have scanned through the thread and not seen it)

I'm currently using a Dark Moon Card: Wrath.... However this adds No dps at all on the spreadsheet...I don't know whether this is an oversight..or merely due to the difficulty of mathcrunching said trinket (math crunching it would certainly be beyond me :P)

Is there any plans to get this working in a future version? At the moment because I don't know if, or by how much i benefit rom the card, i don't know what would be a suitable upgrade.

Cheers, and keep up the great work.

 

-rusty-

reading from armory errors:
(in spreadsheet) is actually [Insidious Bands] @ armory
band of eternal champion gives error too because of the (+ap proc) in spreadsheet (plus the ap proc isnt counted in dps but i guess that wasnt done yet so dont stress yourself :P)

 

Cheeky

Thanks, I'll have them corrected in the next version.

Since I don't have the [Band of the Eternal Champion] does anyone know the proc rate? It's easy enough to model once I know the ppm or %rate.

Cheeky of Havoc