Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Hunters

Closed Thread
 
LinkBack Thread Tools
Old 07/29/09, 2:35 PM   #3166
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
This is something that's hard to prevent. Basically VBA code is a big macro. It can simulate keypresses, mouse-movements, etc.. (in fact it started out as a way to record this).

So when the macro accesses data in the sheet itself, if you move the mouse or click or press any key it can sometimes throw the macro off.


Offline
Old 07/29/09, 2:56 PM   #3167
Esoth
Bald Bull
 
Esoth's Avatar
 
Pandaren Hunter
 
Whisperwind
Pyrite Infuser appears in the calculations twice - it looks like the one in P131 is just misnamed and should be Tears of Bitter Anguish. The result for it should read as average haste, not AP, as well. It looks like this is just a name mixup and the actual data processing is fine.

I would like to suggest having a standard color for fields that are meant to be edited by the end user, for the sake of usability. For someone who has not been using the sheet for awhile (not me!) it is not always easy to determine which fields are meant to be edited, especially when it is only one or two in some tabs. Right now it is light yellow in most fields but pale blue in a few others (mostly hand adjusted stats, not user selected settings) - but pale yellow is still used as the background for some cells that are not meant to be edited, such as on the gear tab. Perhaps I'm just being picky, but it seems to me that sticking with one color makes it more obvious what you're supposed to be adjusting.

Alts: http://www.esoth.com/wow/my-characters
Ion: Along with asking why we fight, and learning that our true enemy is war itself, a major theme of the Mists of Pandaria has been killing turtles
Hunter spreadsheet: http://www.esoth.com/files/mop/at_download/file

United States Offline
Old 07/30/09, 2:14 AM   #3168
FraGsta
Glass Joe
 
Tauren Hunter
 
Arthas
Originally Posted by Shandara View Post
If you could upload it, I'd be grateful.

The way I tested your gear was to:
a) Download the sheet
b) Set your name/server/US on the overview tab
c) Hit the Armory scrape button on the Gear tab, correct ring enchants
d) Load your talents/glyphs from Armory on the talent tab
e) put in the correct SV rotation on the shot rotation tab
f) Go to the settings tab and set 'use Dragon's Eyes' to yes.
g) Run the rotation test button on the shot rotation tab
h) Go the gear planner and press 'Recalculate DPS'

This gives me a fair list of possible upgrades over your gear for most slots.
So I followed this exactly and the results show that my T7.5 shoulders were BiS, and that Grotesque Handgrips were a better choice over my T7.5 gloves. So I went in and replaced them in the "Gear Tab" and hit recalculate DPS and now it's showing the T7.5 Gloves as an upgrade and my Iron Studded Mantle as an upgrade over my T7.5 shoulders. Am I missing an option somewhere?

Offline
Old 07/30/09, 2:46 AM   #3169
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by FraGsta View Post
So I followed this exactly and the results show that my T7.5 shoulders were BiS, and that Grotesque Handgrips were a better choice over my T7.5 gloves. So I went in and replaced them in the "Gear Tab" and hit recalculate DPS and now it's showing the T7.5 Gloves as an upgrade and my Iron Studded Mantle as an upgrade over my T7.5 shoulders. Am I missing an option somewhere?
It's the 2-set bonus. Remember the Gear Planner is only about 1 upgrade at a time.

Replacing your shoulders with the t7.5 ones will activate the 2-set bonus.. in isolation.
Replacing your gloves with the Grotesque ones (without replacing your shoulders) is an upgrade... in isolation.


Offline
Old 07/30/09, 6:30 AM   #3170
FraGsta
Glass Joe
 
Tauren Hunter
 
Arthas
Originally Posted by Shandara View Post
It's the 2-set bonus. Remember the Gear Planner is only about 1 upgrade at a time.

Replacing your shoulders with the t7.5 ones will activate the 2-set bonus.. in isolation.
Replacing your gloves with the Grotesque ones (without replacing your shoulders) is an upgrade... in isolation.
Ah ok, thank you for clarifying. I thought maybe the set bonus was throwing it off but I figured I'd post here to confirm. Thanks!

Offline
Old 07/30/09, 9:55 AM   #3171
Schanaha
Glass Joe
 
Night Elf Hunter
 
Die Silberne Hand (EU)
Originally Posted by Rivkah View Post
I'm not sure why the uptime would go down when haste is higher, but if you read the description of the improved aspect of the hawk talent you'll see that additional points in the talent only increase the haste it provides, they don't affect the uptime. The chance to proc is 10% at every rank (although naturally there's a slightly higher chance of a reproc if you're being hasted more when it's already up).
Simple. When there is a chance of iAotH to proc of 10%, then what happens, when iAotH is active? You get a bonus of 15% haste with 5 points and 3% with 1 point. So, during the uptime of iAotH you fire more shots, which each has the 10% chance to proc. So the haste effect of iAotH has to take effect on the uptime, the more points you put into this talent, the more chances to proc because of the bigger effect of haste. And what bothers me, is that the more haste you've got through gear, the less the uptime of iAotH is calculated. Maybe it is right, but it seems unnatural. The more shots you fire, which each a chance to proc, the less is the uptime? Sounds wrong to me.

Last edited by Schanaha : 07/31/09 at 9:29 AM.

Offline
Old 07/30/09, 2:40 PM   #3172
Iru
Don Flamenco
 
Iru's Avatar
 
Draenei Hunter
 
Muradin
Small bug report with 91b: I like that generally badge gear is enabled in the gear planner by selecting the raid from which you get the badges, but if you're using that logic shouldn't Emblem of Triumph gear only appear if I have Colosseum selected? Currently that gear is on the list no matter what options I select in the gear planner

Offline
Old 07/30/09, 2:45 PM   #3173
 VRoscioli
Bald Bull
 
VRoscioli's Avatar
 
Troll Hunter
 
Ghostlands
Originally Posted by Iru View Post
Small bug report with 91b: I like that generally badge gear is enabled in the gear planner by selecting the raid from which you get the badges, but if you're using that logic shouldn't Emblem of Triumph gear only appear if I have Colosseum selected? Currently that gear is on the list no matter what options I select in the gear planner
Emblems of Triumph will, in 3.2, be available through the daily dungeon and daily heroic quests. Whether or not this is the reason this gear appears this way, I don't know.

Offline
Old 07/31/09, 6:34 AM   #3174
ryan92084
Glass Joe
 
Tauren Hunter
 
Stormreaver
While swapping around gear (and hitting the regemmer) i did run into one instance where it would swap out a red gem (in a red socket) for an enchanted tears. This is while the meta requirement was already achieved so it meant an 8 dps loss. It happened everytime with this specific gear setup and the slot was in the helm of tier 8.5.

to get this to happen all i did was use my armory and talent spec and swap the belt of the betrayed and drape of the faceless general in. With no other gear setup did i notice this happening.

Last edited by ryan92084 : 07/31/09 at 6:53 AM.

Offline
Old 07/31/09, 1:42 PM   #3175
Rivkah
Great Tiger
 
Dwarf Hunter
 
Stormrage
I've done some extensive testing on PTR to get data about how focused aim interacts with the new expertise for pets thing. It's clearly bugged, but the way it's bugged is pretty strange and I have a feeling it won't be fixed before live so it'll probably need to be reflected in the spreadsheet (I've been bugging it for awhile). I haven't quite figured out the pattern though. Here's my testing results:

1 focused aim:
7% hit - .6% dodge
6% hit - .9% - 1% dodge
5% hit - 1.9% dodge

2 focused aim:
7% hit - no dodge
6% hit - .8% dodge
5% hit - 2% dodge

3 focused aim:
7% hit - no dodge
6% hit - .4% dodge
5% hit - 1.2% dodge

Under normal circumstances 1% hit seems to be about .8% dodge (which is logical since 6.5% dodge is the total with no expertise) so these results are pretty weird. Focused aim has some effect but not the expected effect.

I also tested the draenei hit buff and it seems to have no effect on pet expertise.

Offline
Old 08/01/09, 4:10 AM   #3176
bronnum
Von Kaiser
 
bronnum's Avatar
 
Dwarf Hunter
 
Ravencrest (EU)
@Rivkah
How big a sample does your test rely on, Rivkah? As the percentages are quite small, it might require a fairly big sample to derive reliable results regarding expertise.

Last edited by bronnum : 08/02/09 at 3:55 AM.

Offline
Old 08/01/09, 5:13 PM   #3177
Rivkah
Great Tiger
 
Dwarf Hunter
 
Stormrage
I've been running about 3-4k pet attacks per test. For tests that have been giving me numbers that didn't follow a logical pattern I ran the tests a few times to see if the numbers were consistent. I'm currently working on running tests all the way to 0% so I can get a better picture of the situation.

Offline
Old 08/03/09, 8:23 AM   #3178
turbo_012
Von Kaiser
 
Orc Hunter
 
Mal'Ganis
stamina converting to AP

Hi,

I've been playing around with the accuracy of the character's health.

During the test I found a possible bug related to health.

If you look at the calculations tab, the talent "hunter vs. wild" is supposed to increase attack power by a certain percentage based on the total stamina. But the spreadsheet only calculates the stamina accounted from gear.

Is this how it works in-game? Just something to look into.

Offline
Old 08/03/09, 9:33 AM   #3179
kaye
Glass Joe
 
Night Elf Hunter
 
Terenas (EU)
I maybe a thiko here, but how do you enable dragons eyes in the settings tab.

Cheers in advance

Offline
Old 08/03/09, 5:33 PM   #3180
atheana
Glass Joe
 
Night Elf Hunter
 
Kargath
none of the buttons are working when i click on them. and i already adjusted all the settings as it says. how can i fix this?

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Hunters

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Moonkin DPS Spreadsheet Efejel Druids 1925 11/04/08 2:34 PM
Hunter lvl 70 DPS spreadsheet Solaris Public Discussion 12 12/03/06 6:09 AM