Hunter Spreadsheets -- In development - Page 72

Cheeky · 11/20/07, 2:44 PM

Originally Posted by 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.

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.)

Originally Posted by 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...

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.

Originally Posted by 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?

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 · 11/20/07, 3:35 PM

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.

Amiyuy · 11/20/07, 5:58 PM

Nevermind, I think I figured it out.

Thanks for the awesome spreadsheet and updates!

Juggernaught · 11/21/07, 4:07 AM

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 · 11/21/07, 6:38 AM

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 · 11/21/07, 7:22 AM

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 · 11/21/07, 8:55 AM

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 · 11/21/07, 11:47 AM

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- · 11/22/07, 7:42 AM

reading from armory errors:
[Item not found!] (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 · 11/22/07, 9:02 AM

Originally Posted by -rusty-

reading from armory errors:
[Item not found!] (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)

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.

Slingbow · 11/22/07, 1:18 PM

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- · 11/22/07, 1:57 PM

Originally Posted by 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.

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

-rusty- · 11/22/07, 3:49 PM

[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

Fury of the Crashing Waves 95
Band of the Eternal Champion 93
Rage of the Unraveller 92

Cachera - WWS

Fury of the Crashing Waves 127
Rage of the Unraveller 118
Band of the Eternal Champion 105

Cachera - WWS

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

_dodger_ · 11/23/07, 7:40 AM

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 · 11/23/07, 11:49 AM

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