Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Hunters

Closed Thread
 
LinkBack Thread Tools
Old 04/30/09, 12:28 PM   #2281
jaofos
Glass Joe
 
Night Elf Warrior
 
Uther
I haven't seen mention of this anywhere else in the thread.. but in the Gear tab, if I select any Race other than Orc, I get #DIV/0! errors on most of the DPS calculations.

I've spent literally an hour resetting all default settings back to 0 with no successful results.

Any help would be appreciated. Running this on Excel 2007, if that makes a difference.

Offline
Old 04/30/09, 12:29 PM   #2282
Lerastes
Piston Honda
 
Tauren Hunter
 
Cenarion Circle
Remove Blood Fury from your Shot Rotation tab.

Offline
Old 04/30/09, 3:46 PM   #2283
bluetang
Glass Joe
 
Dwarf Hunter
 
Sen'jin
Latency

Playing around with the spread sheet can yield some rather large swings in dps with the same gear. I have been trying to pay closer attention to my in game latency and I have a question.

If the spreadsheet is given an average latency of 0.1 versus 0.15 the value of chimera, aimed and kill shot glyphs are very different. During a raid my latency will usually hover around 100-150 but 100 and 200 are common enough that I question how effective the spreadsheet is at determining my dps (obviously since the fights and our latency are not as smooth as the spreadsheet is able to predict). I guess I am wondering how many people glyph exactly how the spreadsheet recommends versus what you like or what makes your rotation easier?

Offline
Old 04/30/09, 3:47 PM   #2284
Allara
Extra Special
 
Allara's Avatar
 
Draenei Hunter
 
Draenor
[Drape of the Faceless General] - comments on Wowhead suggest that this drops from Ulduar-10 Hard, but the spreadsheet lists it as Ulduar 25. Not sure which is correct as I haven't seen the item drop myself, but it might be worth looking at. (87b)

United States Offline
Old 04/30/09, 6:04 PM   #2285
snail
Von Kaiser
 
Dwarf Hunter
 
Arygos
Originally Posted by Argg0 View Post
Nope, it was an upgrade... quite a big one actually.

6425.96 with Furious.
6387.77 with Siren.

I'm a troll and my gear/spec can be seen on my armory.

Maybe it's an upgrade because I'm MM?

I did a similar comparison and found the Furious weapons to be inferior regardless of my spec. I did the comparison from Giant's Bane vs the furious gun as well as comparing Siren's Call to the Furious bow/xbow. In both comparisons the Furious weapons were a downgrade of approx 20-30 dps.


Can anyone else see what they're getting? Maybe myself and the poster earlier on this page entered the data in incorrectly somehow?

Offline
Old 04/30/09, 7:22 PM   #2286
Sean
Piston Honda
 
Orc Hunter
 
Illidan
It's spec reliant.

Marks relies more on Weapon Damage with it being a main component of Chimera Shot so the Furious comes out ahead. The +Stat boosts from Giants/Sirens outweigh the higher weapon damage for Survival.

Offline
Old 05/01/09, 2:19 AM   #2287
Iru
Don Flamenco
 
Iru's Avatar
 
Draenei Hunter
 
Muradin
Bug report: 87c no longer correctly selects the pet family special attack when you change pet families, e.g. wolf to wasp. It certainly used to do so in 87a. Did something change in this area or do I have a corrupted spreadsheet?

Offline
Old 05/02/09, 5:45 PM   #2288
renork
Glass Joe
 
Dwarf Hunter
 
Hydraxis
I'm sorry if this has been asked and answered in this thread already (it's a little big and difficult to manuever at this point) but is there any way to remove gems from the listing? I'm getting really sick of searching through dark jade, citrine and such which I would never use. I'm wondering if maybe there could be an additional page or setting somewhere to remove/include a certain level of stone and/or JC only gems? Barring that how do I manually remove them? Thanks in advance.

Offline
Old 05/02/09, 6:00 PM   #2289
snail
Von Kaiser
 
Dwarf Hunter
 
Arygos
Originally Posted by Sean View Post
It's spec reliant.

Marks relies more on Weapon Damage with it being a main component of Chimera Shot so the Furious comes out ahead. The +Stat boosts from Giants/Sirens outweigh the higher weapon damage for Survival.
I continue to see it as a dps loss versus Giants/Sirens regardless of whether I spec MM or SV. I suppose it may just be my gear's stat distribution. Oh well.

Offline
Old 05/02/09, 9:05 PM   #2290
Iru
Don Flamenco
 
Iru's Avatar
 
Draenei Hunter
 
Muradin
Originally Posted by renork View Post
I'm sorry if this has been asked and answered in this thread already (it's a little big and difficult to manuever at this point) but is there any way to remove gems from the listing? I'm getting really sick of searching through dark jade, citrine and such which I would never use. I'm wondering if maybe there could be an additional page or setting somewhere to remove/include a certain level of stone and/or JC only gems? Barring that how do I manually remove them? Thanks in advance.
There's no easy way to remove them but you could sort them on DPS value so at least you're only seeing gems that are likely to be useful at the top of the list.

Just remember to run the calculate attribute routine (the button on the summary page) first so that you're seeing the gems' DPS value based on your current gear.

Offline
Old 05/02/09, 11:57 PM   #2291
Bainik
Glass Joe
 
Orc Hunter
 
Boulderfist
I noticed some strange behavior in how stats are calculated when messing with gems for a 54/12/5 spec in that AP seemed to be scaling with itself. Unless I'm missing something shouldn't the DPS value of AP be constant unless another stat (crit/arp/hit/haste/agi/int) changes? Nothing was changed other than agi gems to attack power gems which should have (again, unless I'm completely missing something) lowered the DPS value of attack power not increased it since the crit chance decreased.

Last edited by Bainik : 05/03/09 at 12:32 AM.

Offline
Old 05/03/09, 4:26 AM   #2292
Aieda
Von Kaiser
 
Dwarf Hunter
 
Dragonmaw (EU)
I'm having some problems using the spreadsheet, trying to determine what gear will be best for me (that is also accessible). When I look in the gearplanner and see an item listed as dps upgrade and I go back in the gear tab and put it on, it sometimes show as a downgrade instead on my dps. So there's not always consistency between the gear planner and then the gear tab when equipping the item. Hence I'm very confused and can't really figure out what items are upgrades and what not.
Shall i trust the gearplanner or the result from gear tab when equipping an item?

I dunno if it's just me doing something wrong or if the rest of you have similar problems.

(copy/pasted from the other thread since i was told this is the correct place to ask)

Offline
Old 05/03/09, 5:12 AM   #2293
Argg0
Von Kaiser
 
Troll Hunter
 
Warsong
Just want to be sure... has the 4pt T8 been implemented?

edit: Also... Gloves of the Steady Hand are shown with two red socks, while on armory they have a red and a blue one.

Last edited by Argg0 : 05/03/09 at 5:20 AM.

Offline
Old 05/03/09, 7:29 AM   #2294
Ufthak
Von Kaiser
 
Orc Hunter
 
Dragonblight (EU)
Originally Posted by renork View Post
I'm sorry if this has been asked and answered in this thread already (it's a little big and difficult to manuever at this point) but is there any way to remove gems from the listing? I'm getting really sick of searching through dark jade, citrine and such which I would never use. I'm wondering if maybe there could be an additional page or setting somewhere to remove/include a certain level of stone and/or JC only gems? Barring that how do I manually remove them? Thanks in advance.
It depends on how comfortable you are with Excel. If you know what you are doing you can unhide the gems sheet and delete the gems you aren't interested in seeing. Make sure you delete the whole row though, just removing the entries will leavea whole bunch of blanks in the drop down and cause further issues.

Offline
Old 05/03/09, 4:10 PM   #2295
Chasim
Glass Joe
 
Dwarf Hunter
 
Eonar
I'm sorry if this has been asked before (tried searching...) but why does the Hunter Hit +1 value always stay so high? For example, I'm currently 278 Hit (15 over the cap) and the Hunter Hit +1 value is still 1.583 - shouldn't it now be 0?

One other thing - with 87c, "For Pet" hit (on the Overview tab) does not seem to correctly calculate. At 278 hit, it shows 0. Shouldn't that be -14?

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