Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Hunters

Closed Thread
 
LinkBack Thread Tools
Old 11/21/08, 12:04 PM   #601
Fimbo
King Hippo
 
Fimbo's Avatar
 
Tauren Hunter
 
Argent Dawn (EU)
Interesting effect going on with the Spreadsheet.

I wanted to test the difference in gain between Longevity and Animal Handler.

So I loaded up the "default 50/21" spec and got a Total DPS figure of 1638, with two points in Longevity.
Changing the setting to 1 point the DPS number immeadiately increased to 1656.
Going down to 0 point reduced it to 6118.

Looks likely there's a maths bug somewhere.

As a note however: Shandara - If I were you I really wouldn't even be thinking of maintaing this while levelling! The community appreciates your efforts and I look forward to seeing the spreadsheet evolve AFTER you've got to 80 and killed Sarth.

Offline
Old 11/21/08, 1:48 PM   #602
rabidfire
Glass Joe
 
Draenei Hunter
 
Garithos
Longevity 3/3 is better than 1/3 which is better than 2/3 if you're using a cat, so your numbers are in-line. This was covered before.

What I haven't seen any information about is the spreadsheet weighting 2AP much, much higher than 1Agi. It kinda makes sense if you think about it, but I still want some confirmation before going AP for everything. Can anyone confirm this?

Offline
Old 11/21/08, 2:09 PM   #603
Rokh
Piston Honda
 
Orc Hunter
 
Emerald Dream
I'm really interested in the +1 int being the best stat for my gear, according to the sheet. Gemming and enchanting Int is showing more a DPS increase than anything else. I get the mana return, AP from talents, ect. Just seems really really odd that that's how it'd work out.

Also worth noting it's all depending on what fight, what buffs, ect you have. So yeah, mostly ignoring that for now in the sheet.

Offline
Old 11/21/08, 2:31 PM   #604
rabidfire
Glass Joe
 
Draenei Hunter
 
Garithos
The higher 'Viper Damage Penalty' is in Shot Rotation tab, the more value will be given to Int. In the Settings tab you can change 'Aspect Behavior' to 'Always On', that will de-value Int by quite a bit.

edit: Missing [Ring of Invincibility] from the spreadsheet

Last edited by rabidfire : 11/21/08 at 4:13 PM.

Offline
Old 11/21/08, 6:40 PM   #605
Tsook
chiefly comprised of water
 
Tsook's Avatar
 
Tsook
Troll Hunter
 
No WoW Account
Originally Posted by rabidfire View Post
What I haven't seen any information about is the spreadsheet weighting 2AP much, much higher than 1Agi. It kinda makes sense if you think about it, but I still want some confirmation before going AP for everything. Can anyone confirm this?
It doesn't for me. Do you have absurdly high crit and low AP? Is Blessing of Kings on?

EDIT: Actually, you're right. The spreadsheet is showing 2 AP as about 10% better than 1 agi with early level 80 levels of gear, for BM spec. Of course, that lead should decrease as your gear improves and you start getting more AP, which will increase the relative value of crit and thus agi.

EDIT2: Caught up with the continuing discussion in the simple questions thread. Does assuming 10% AP bonus at all times to match Blessing of Kings mean that AP and agi will keep their current relative strength as gear improves? Perhaps. It's an interesting question, and one that maybe is best resolved by experimentation in the sheet.

Last edited by Tsook : 11/21/08 at 8:05 PM.

United States Offline
Old 11/21/08, 10:30 PM   #606
Khallas
Glass Joe
 
Tauren Hunter
 
Cenarius
I have noticed that there are a lot of decent blue items that are not listed in the pre-existing gear list. There are a lot of quest rewards and and rep rewards that are very decent weapons and gear that aren't listed. A few that I have been using that aren't listed are:

Zombie Sweeper Shotgun (Argent Crusade - Revered)
Traditional Fleshing Knife (Kalu'ak - Revered)
Dragonstompers (Crafted: Leatherworking) (Most of the other LW crafted gear as well, haven't started wearing it yet due to not breaking my T6 4pc)
Ring of Foul Mojo (Quest Reward)
Spiked Collar of Servitude (Quest Reward)

Offline
Old 11/22/08, 1:24 AM   #607
Burakan
Banned
 
Tauren Hunter
 
Argent Dawn
I'm having an issue with custom gear and profiles.

When I load custom gear into a profile, no issues occur.

However, when I make a second profile, also with custom gear, and save, it will display that new custom gear in the first profile when loaded, but the stats of the first profile are unchanged from the original save. If I were to save the profile again, it would then change the custom gear on the first profile, which should not happen.

Summary of problem:

When you have two profiles with custom gear, the stats on the gear from the second-made profile are being displayed in the first profile gear (custom gear). No change occurs to the DPS stats of the first profile, even though the gear is displaying inaccurately.

As an ancient hunter theorycrafter, I have to say that the spreadsheet is well done. I would suggest future development should be focused on user-friendliness, as the one criticism I could make about the current one is the lack of such user-friendliness.

In particular, I would like to see gear profiles handled better than they are. If you look back at Rooke's spreadsheet from OG WoW, you will see that she separated each gear set into a different tab. This allowed the user to intuitively create a set of gear, and view the results, side by side with the other sets. The profile system of the current sheet is a bit awkward, and as you can see from the above, can lead to problems (unless my problem is unique).

Well done, overall.

Edit: Also, Thunderstomp is not displaying damage and frequency values.

Last edited by Burakan : 11/22/08 at 1:35 AM.

Offline
Old 11/22/08, 7:47 AM   #608
Kargos
Von Kaiser
 
Kargos's Avatar
 
Troll Hunter
 
Uldum
Quick item that isn't listed.

Eternal Belt Buckle (Crafted, Blacksmithing)

Adds a socket for belts.


Keep up the good work and have fun leveling!

Offline
Old 11/22/08, 3:07 PM   #609
Khallas
Glass Joe
 
Tauren Hunter
 
Cenarius
An additional note, the fur lining wrist enchants and icewalker boot enchant are not importing in from armory. The spreadsheet is saying they could not be found as a supported enchant even though they are in the list already.

Offline
Old 11/22/08, 4:03 PM   #610
Vail
Glass Joe
 
Draenei Hunter
 
Sen'jin
First off, thank you so much for continuing Cheeky's work, secondly is there a way to use this without Microsoft Excel? I don't feel like purchasing it at the moment and was hoping for another means of using it.

Offline
Old 11/23/08, 1:12 AM   #611
Ocelotmgs3
Glass Joe
 
Gulleygrim
Blood Elf Hunter
 
Non-US/EU Server
wtb some info on a macro that contains steady shot with serpent sting in it for the 10% increased steady shot from the glyph

Offline
Old 11/23/08, 8:18 AM   #612
Maa
Glass Joe
 
Orc Hunter
 
Magtheridon (EU)
Poached Northern Sculpin is missing from the food buffs section.

Offline
Old 11/23/08, 1:44 PM   #613
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Update:
- Various spelling errors and stats on items fixed. Added a few missing ones.
- Rotation Test tab will now properly do nothing if no shots are selected
- Added Aspect of the Dragonhawk
Added a lot of items, probably missed some stuff. Also adjusted quite a few calculations to live patch numbers (damages on abilities etc..). Too much to list.


Offline
Old 11/23/08, 1:47 PM   #614
Dch48
Von Kaiser
 
Night Elf Hunter
 
Draka
Doesn't work

Cheeky's always worked for me. I downloaded this one and no matter what I do, it shows N/A for all the calculations. What do I have to do to make this thing work?

Offline
Old 11/23/08, 2:36 PM   #615
flimflam
Von Kaiser
 
Orc Hunter
 
Mug'thol
Getting an error with the latest version 78 when trying to load gear from the armory.

Run-time error '91':
Object variable or With block variable not set
Then highlights this line:

sName = Node.Attributes.getNamedItem("name").Text
sUrl variable is: http://www.wowarmory.com/item-info.xml?i=44081&lang=en_us

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