Elitist Jerks
Register
Blogs
Urban Rivals
Forums
New Posts


Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Hunters
Elitist Jerks Login

gamerDNA Login

Welcome to Elitist Jerks
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!

If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.

Reply
LinkBack (1912) Thread Tools
Old 08/07/09, 7:00 AM   #3226
 promdates
King Beard!
 
promdates's Avatar
 
Orc Hunter
 
Mal'Ganis
Originally Posted by Zer0Cool View Post
Having problems with the latest version of spreadsheet. Since the new patch the only modefications I did to my gear are the new gems, Delicate Cardinal Ruby & Nightmare Tear. Once I had updated the "gear" tab using "load Gear from Armory" all my gear now is BiS... (I know its good lol but not that good).

I did a test where I changed my t7.5 shoulders, currently displayed as BiS to a "Shoulders of Misfortune" and recalculated DPS and now "Shoulders of Misfortune" became the new BiS.... this is not supposed to happen.

If this is a known problem my bad.
Go to the "Settings" tab and put the epic gem cuts in the list next to the rare gem cuts. It wasn't until I did this, that it started actually showing upgrades. It will use the epic gem cuts for all of the sockets instead of using the regular gems. If you have it set to use regular gems, but you have the epic gems equipped it things your gear is better (which it is at that point). Have it use epic cuts and it will fix itself.

"On a scale of one to mein kampf, how many racists does it take to make a guild look terrible?"

[03:28] L_J: it's "olololo hero class"

[01:09:39] <DeeNogger> Any of the resident grammer nazis on right now?
 
User is online.
Reply With Quote
Old 08/07/09, 7:32 AM   #3227
Kradish
Glass Joe
 
Orc Hunter
 
Quel'Thalas (EU)
I'm not sure whether it's due to my settings and i'm pulling from a limited supply of info but since the change to L'n'L the rotation test seems to be out. Like I said I know it's limited but on a 6 minute fight the rotation test is showing me as getting 3 L'n'L proc's while I got 3 on an Emalon kill that took just over 3 minutes, 5 procs on a 200 second Ignis fight and 4 procs on a 170 second Archavon.
 
User is offline.
Reply With Quote
Old 08/07/09, 11:37 AM   #3228
Angelis
Glass Joe
 
Murloc Paladin
 
Destromath
I've also noticed dispite the 22 sec CD of LnL, I've been getting at least 1 proc every minute. I wonder if they've increased the proc rate on BA to make it more consistent. However this is purely based on a days worth of heroic farming
 
User is offline.
Reply With Quote
Old 08/07/09, 11:47 AM   #3229
benisapha
Von Kaiser
 
Night Elf Hunter
 
Zangarmarsh
Looking at someone else's testing on the SV thread, it seems as if the proc rate is ~25%, and that is is very possible to get almost two a minute. This will need further testing, but difficult to do at work. I will test on Sat at a dummy, as at 1.5-2 procs a minute, I would like to see what this does to SV dps. I cant think that this is anythign but a Huge gain, and would be an immense help mana management fights.
 
User is offline.
Reply With Quote
Old 08/07/09, 11:55 AM   #3230
Bikiniwax
Piston Honda
 
Night Elf Hunter
 
Laughing Skull
Shandara,

Whenever you get around to it, the Frag Belt engineering enchant is not in the spreadsheet yet.
 
User is offline.
Reply With Quote
Old 08/07/09, 1:46 PM   #3231
Æpic
Glass Joe
 
Blood Elf Hunter
 
Rexxar
Wanna maximize my DPS

Originally Posted by Lilbitters View Post
Well with the addition of epic quality gems, there shouldn't really be much of a decision unless you need to gem for +Hit Rating.

Beast Mastery: [Bright Cardinal Ruby]
Survival: [Delicate Cardinal Ruby]
Marksman: [Fractured Cardinal Ruby] (until 567 ArP + [Mjolnir Runestone]) and then [Delicate Cardinal Ruby]

And then in whichever socket will give you the best set bonus, place a [Nightmare Tear].

The -only- exception to this rule should be if a single Orange ([Deadly Ametrine] or [Wicked Ametrine]) or Purple gem ([Shifting Dreadstone], [Balanced Dreadstone], or [Puissant Dreadstone]) in a socket will give that slot a socket bonus of +8 Agility or greater.
I am in a strange spot with choosing my spec, in that I do have item]Grim Toll[/item] but I only have 123 ArP if I still gem agi. I changed my secondary spec to one that would maximize my dps off of the spreadsheet, but it still states that I should have a lower dps. Unless my [Grim Toll] and my [Darkmoon Card: Greatness] proc a lot more during a fight, my dps on the dummies is generally about 100 higher using my MM spec, which is contrary to the spreadsheet. Additionally, if I gem ArP instead of Agi, my dps should go down even further.

Speaking to the top hunter on my server, he says that I should stay Surv until I reach the ArP softcap of 619 with gems and then choose MM. If any hunter could Armory me at The World of Warcraft Armory and give me some educated suggestions as to what I should do, please let me know. It's jsut a little too expensive to regem twice right now.

Thanks,
Æpic
 
User is offline.
Reply With Quote
Old 08/07/09, 1:47 PM   #3232
SpartanKillian
Von Kaiser
 
Night Elf Hunter
 
Dalaran
Originally Posted by promdates View Post
Go to the "Settings" tab and put the epic gem cuts in the list next to the rare gem cuts. It wasn't until I did this, that it started actually showing upgrades. It will use the epic gem cuts for all of the sockets instead of using the regular gems. If you have it set to use regular gems, but you have the epic gems equipped it things your gear is better (which it is at that point). Have it use epic cuts and it will fix itself.
I'm having the same problem as the person you replied to. I changed all my default gems to +20 Agi and, while it's slightly different, the problem remains. Now items I -know- are significant upgrades are either showing up as not being an upgrade or being a much smaller upgrade than it should. For example, Windrunner's (H) shoulders show as a +14.27 upgrade over my current Shoulders of Misfortune on the Gear Planner. When I actually plug them in on my profile, the upgrade is closer to +90.
 
User is offline.
Reply With Quote
Old 08/07/09, 2:51 PM   #3233
Scrith
Glass Joe
 
Night Elf Hunter
 
Draenor
In addition to adding quite a few missing items (see the link, from another post in this thread, to new 3.2 loot from MMO Champion) and a few that aren't spelled/worded correctly (so they aren't importing from the Armory, such as the Etched Band of the Kirin'Tor and Collar of Ceaseless Torment), I definitely agree that the new epic gems need to be made the default gems in the spreadsheet, because most people aren't remembering to update these and are now wondering why the Gear Planner is giving them unexpected results with their gear that is gemmed with the new epic gems.
 
User is offline.
Reply With Quote
Old 08/07/09, 3:42 PM   #3234
Bees
Fixing Rawr.Hunter
 
Night Elf Hunter
 
Hyjal
Found a bug with Mana Regen from potions:

The named cell AAS should point to Assassin's Alchemist Stone in Trinkets!A18 but points to Darkmoon Card: Crusade in Trinkets!A27.

The named cell MAS should point to Mighty Alchemist's Stone in Trinkets!A44 but points to Mirror of Truth in in Trinkets!A10.
 
User is offline.
Reply With Quote
Old 08/07/09, 4:09 PM   #3235
Kathucka
Von Kaiser
 
Orc Hunter
 
Shu'halo
Re-gemmer problems make gear-planner problems

The re-gemmer consistently makes certain mistakes that lead to a sub-optimal gem setup. For instance, it insists on putting a [Deadly Ametrine] and [Delicate Cardinal Ruby] in my [Darkcore Leggings]. Given that there is a blue and a yellow slot here, it should either fill both slots with the matching color, or neither. Mis-matching one and not the other is almost always wrong.

This leads any new auto-gemmed gear setup to have lower DPS than my manually-gemmed current set up.

In turn, this leads the gear planner to show lower DPS for any non-equipped item, because the non-equipped item goes with a sub-optimal gem setup. So, everything looks like a downgrade.

The epic gems have only made this problem worse.

I expect that it is causing similar problems for the optimizer.

Change the gemming algorithm to match non-red gem slots only if the bonuses are sufficiently large. Matching two non-red slots would require a really big bonus. In this case, make sure it matches both of the slots.

As a work-around for this problem have the gear planner re-gem the current setup, load the new item, and re-gem the gear with the new item in place, then compare both re-gemmed setups. It's not ideal, but at least it will be comparing equally broken gem configs.
 
User is offline.
Reply With Quote
Old 08/07/09, 4:51 PM   #3236
SpartanKillian
Von Kaiser
 
Night Elf Hunter
 
Dalaran
I realized my mistake from my earlier post. I was looking at the +20 Agi value and not the gem's name and set everything to stormjewels. Switching to cardinal rubies solved the problem.
 
User is offline.
Reply With Quote
Old 08/08/09, 3:51 AM   #3237
Bees
Fixing Rawr.Hunter
 
Night Elf Hunter
 
Hyjal
Found some more bugs, this time in 'Pet Skills', PetSkillMatrix, 'Talented?' column. Several of the abilities point to the wrong talent cells:

Bullheaded is pointing to G20, should be G19
Dash is pointing to G4, J4 and M4 - it should not include M4
Dive has the same issue as Dash
Road of Sacrifice points to M19, should also point to G22

[edit] Also, cooldown on Dive & Dash are wrong. they check for the Dive/Dash talent in G8 but it's also in J8. Bug exists in 'Pet Skills' cells F33 & F34

[edit2] Also, there are some non-damaging pet abilities that are marked as damaging in 'Pet Skills' column 'I':
* Furious Howl
* Dust Cloud
* Bad Attitude
* Snatch
* Tendon Rip
Aside from Furious Howl, they are also marked as critting, which means that they are proc'ing Kill Command when (i think) they shouldn't be

[edit3] Also, Nether Shock is not counted as a damaging ability. Seems it should be calculated the same way as spell attacks like Froststorm Breath, but with shadow debuffs

[edit4] Scorpid Poison is using 0.04 as its AP scaling factor, instead of PetSpellScaling which the other skills use. 0.15/3.5 = 0.042857..., so is a little off - pet DPS changes by 0.89 in my test setup. Spirit Strike uses 4% too.

[edit5] Scorpid Poison dps is being calculated as its max dps, using cooldown instead of frequency. mistake appears to be in Pet Calculations C218

[edit6] Poison Spit has its final DPS wrong, ignoring how many ticks can be applied given its frequency. I195 should be =IF(I193=0,0,I186*I188*I193)

[edit7] Venom Web Spray damage is not calculated. seems it should be calculated the same way as spell attacks and then multiplied by 4. it can never be fast enough for the frequency to be shorter than the cooldown, so there's no need to calculate applied dots

[edit8] For Spirit Strike, you apply hit/crit adjust for the initial hit, and not for the dot. This seems half right, because the dot can't crit, but if the initial hit doesn't hit, then the dot wont apply. Maybe I163 should be multiplied by PetHit?

[edit9] For the Spore Cloud uptime in I145 you use the (unadjusted for longevity) cooldown - it should use the final frequency (Sting has exactly the same issue)

[edit10] If you have 100% hit, the target has 0% dodge and you use Acid Spit, the armor reduction effect causes a divide by zero. The problem is in 'Pet Calculations'!S56 - need to check that AcidSpitChanceToStop isn't zero. Monstrous Bite already has this check.

[edit11] For both Acid Spit and Monstrous Bite stacking/uptime calculations, you use the (adjusted for longevity) cooldown - seems like you should be using the real frequency.

[edit12] Uptime calculations for Acid Spit and Monstrous Bite are always 100% - set the cooldown to 100 seconds and you'll still see it at 100% uptime. The needed tweak is to not count the '% time' for 0 stacks into the uptime calculation. Change T19 from =SUM(T15:T18) to =SUM(T16:T18) and T57 from =SUM(T54:T56) to =SUM(T55:T56). I suspect that Rabid might have a similar issue, but haven't looked into it yet.

[edit14] The macro function Worksheet_Change() in the Pet sheet recalculates the list of skills to show in the pet rotation dropdowns. However, it only updates when you change pet family. If you change your pet spec to allow a new skill (e.g. Cunning pet spec'ing into Wolverine Bite) then it wont be available to put into the rotation unless you change the pet family again.

[edit15] Charge/Swoop is available to the wrong pets - every tenacity and ferocity pet can charge/swoop if spec'd into it - it's not a replacement for dive/dash since some pets (cats) can do both while some (bear) can only do one. The talent in the pet tree should be labelled "Charge/Swoop" in the ferocity tree only (not tenacity!) since 3 ferocity pets (carrion bird, moth, wasp) swoop in place of charging.

[edit16] Bug with populating the talented skills for pet families. Even if spec'd into it, Cunning can't use Roar of Sacrifice and Tenacity can't use Grace of the Mantis. The 'Talented Skills' box isn't currently large enough to hold all 6 talented skills in the tenacity tree (cunning has 5 and ferocity only 2).

[edit17] It's not clear to me why Rabid, Bullheaded and Call of the Wild aren't included in the pick list for pet rotations - other zero-focus-cost abilities are and there seems to be nothing special about these three.

[edit18] Grace of the Mantis appears in the rotation pick-list for cunning pets who spec'd into it, but it's a passive talent, not an ability. It's also is mis-spelled in the Cunning talent tree.

[edit19] Beatial Wrath still causes a damage bonus when you have your pet type set to None

[edit20] Mana gained from Beatial Wrath (calc'd in BeastManaBenefit - Calculations!N45) is not factored into mana expenditure at all

Last edited by Bees : 08/11/09 at 12:09 AM.
 
User is offline.
Reply With Quote
Old 08/08/09, 10:03 AM   #3238
Doomglazer
Glass Joe
 
Night Elf Hunter
 
Turalyon (EU)
The stats of Gloves of the dark exile are incorect
also Armbands of the Norythern Stalker isent in the database yet
 
User is offline.
Reply With Quote
Old 08/08/09, 1:48 PM   #3239
Difool
Von Kaiser
 
Night Elf Hunter
 
Llane
A few more bugs with imports from Armory:

I got the error "+24 Crit is not a legitimate foot enchant" (not exact wording). I selected Nitro Boots as an enchant and it correctly put the +24 crit back on the boots.

On Talent import from WOW Armory I immediately got a Runtime Error (13) - type missmatch. FWIW I have my main spec selected, but my alt spec is currently 0/0/0.

When I hit the debugger on the latter it starts me at this line (I have no idea if that is the start location or the location where the error occurs):
Worksheets("Talents").Range("E2").value = CInt(Mid$(Talents, 1, 1))

Last edited by Difool : 08/08/09 at 1:56 PM. Reason: Sorry. Stormrune Edge imort error already reported
 
User is offline.
Reply With Quote
Old 08/08/09, 4:46 PM   #3240
Kharthus
Piston Honda
 
Dwarf Hunter
 
Deathwing
Originally Posted by Difool View Post
A few more bugs with imports from Armory:

On Talent import from WOW Armory I immediately got a Runtime Error (13) - type missmatch. FWIW I have my main spec selected, but my alt spec is currently 0/0/0.

When I hit the debugger on the latter it starts me at this line (I have no idea if that is the start location or the location where the error occurs):
Worksheets("Talents").Range("E2").value = CInt(Mid$(Talents, 1, 1))
Same issue here for people without dual specs.
 
User is offline.
Reply With Quote
Old 08/08/09, 6:54 PM   #3241
Zer0Cool
Glass Joe
 
Troll Hunter
 
Sargeras
Originally Posted by promdates View Post
Go to the "Settings" tab and put the epic gem cuts in the list next to the rare gem cuts. It wasn't until I did this, that it started actually showing upgrades. It will use the epic gem cuts for all of the sockets instead of using the regular gems. If you have it set to use regular gems, but you have the epic gems equipped it things your gear is better (which it is at that point). Have it use epic cuts and it will fix itself.
I gat a popup saying that this cell is protected, and when i try to make the Sheet unprotected it is asking me for password... Is there a different way of changing a Delicate Scarlet Rudy to a Delicate Cardinal? Or maybe someone knows the pass?

Thanks
 
User is offline.
Reply With Quote
Old 08/08/09, 7:34 PM   #3242
arlen
Piston Honda
 
Night Elf Hunter
 
Aggramar
Originally Posted by Zer0Cool View Post
I gat a popup saying that this cell is protected, and when i try to make the Sheet unprotected it is asking me for password... Is there a different way of changing a Delicate Scarlet Rudy to a Delicate Cardinal? Or maybe someone knows the pass?

Thanks
Change the values in the custom collumn. The default collumn isn't meant to be changed by users.
 
User is offline.
Reply With Quote
Old 08/08/09, 7:50 PM   #3243
 arison
Von Kaiser
 
arison's Avatar
 
Night Elf Hunter
 
Windrunner
I see Shandara has been away and hasn't posted anything since 7/29. It would be interesting to see what DPS increase a 20% proc rate of LnL gets. Hopefully he will return I wonder if the DPS analyzer has a new proc rate yet.
 
User is offline.
Reply With Quote
Old 08/08/09, 8:05 PM   #3244
 promdates
King Beard!
 
promdates's Avatar
 
Orc Hunter
 
Mal'Ganis
Originally Posted by arlen View Post
Change the values in the custom collumn. The default collumn isn't meant to be changed by users.
While this is true, changing the custom column for the epic gems, at some point the default one should be set to the epic gems. With the epics being so easy to get now (run some heroics, do some pvp, use 150 stone keeper's shards), there's no reason that it can't be set to the default.

"On a scale of one to mein kampf, how many racists does it take to make a guild look terrible?"

[03:28] L_J: it's "olololo hero class"

[01:09:39] <DeeNogger> Any of the resident grammer nazis on right now?
 
User is online.
Reply With Quote
Old 08/08/09, 11:04 PM   #3245
arlen
Piston Honda
 
Night Elf Hunter
 
Aggramar
Originally Posted by promdates View Post
While this is true, changing the custom column for the epic gems, at some point the default one should be set to the epic gems. With the epics being so easy to get now (run some heroics, do some pvp, use 150 stone keeper's shards), there's no reason that it can't be set to the default.
I agree, but as my post stated, the default column isn't meant to be changed by the user which is why the person I was replying to was getting an error. Shandara will have to change the default column since its password protected.
 
User is offline.
Reply With Quote
Old 08/09/09, 9:23 AM   #3246
swiftfeet
Glass Joe
 
Troll Hunter
 
Eonar (EU)
Error with spreadsheet

I am encountering an error using the latest version of your DPS spreadsheet Version 91a.

I am using Excel 2003. If this is the root of the issue, please let me know. As far as I know, spreadsheets are relatively backwards compatible.

The error occurs when I try to mouse over the "Load Gear from Armory" button on the "Gear" tab. The MS Visual Basic debugger comes up and two error messages are displayed. They are the same and say: "Compile Error: Automation Error".

The debugger highlights the Private Sub Worksheet_Change(ByVal Target As Excel.Range) function when this occurs.

Thank you. I appreciate your work on this spreadsheet.


I am also getting this, any help on the matter?
 
User is offline.
Reply With Quote
Old 08/09/09, 12:03 PM   #3247
Stara
Glass Joe
 
Night Elf Hunter
 
Hellscream
I am also getting what I believe to be weird results in the gear planner, even after adjusting the settings to the epic quality ones.

For example: I currently have Favor of the Dragon Queen with a +8 AGI/+12 STA gem in it. Running the calculations and looking at the gear planner, it tells me Broach of the Wailing Night is an 86.81 DPS upgrade for me. So I swap that into my gear profile, and its actually a ~9 DPS upgrade. Now if I go back into the gear planner, suddenly Favor of the Dragon Queen now is the better trinket by 79.55 DPS. So thinking it has to do with it using an epic gem now, I'll swap it back in with an epic gem which nets me a ~2 DPS upgrade. And then again checking back into the gear planner the Broach is back up as a 76.44 DPS upgrade.

Now maybe the Broach is just bugged in the spread sheet or I suddenly don't know what I am doing, it just seems off.

I haven't tested any other gear yet, this was the first since I have more then enough badges for the Broach, but the way the gear planner is sorting things is making me take a second look.
 
User is offline.
Reply With Quote
Old 08/09/09, 2:46 PM   #3248
Thorinson
Glass Joe
 
Dwarf Hunter
 
Alonsus (EU)
Originally Posted by Stara View Post
Now maybe the Broach is just bugged in the spread sheet or I suddenly don't know what I am doing, it just seems off.
The gear planner assumes you always regem when you switch any piece of gear. I bet that if you made the first swap you mentioned and hit the regem button, the DPS increase is exactly what the gear planner indicated.
 
User is offline.
Reply With Quote
Old 08/09/09, 3:26 PM   #3249
 promdates
King Beard!
 
promdates's Avatar
 
Orc Hunter
 
Mal'Ganis
Originally Posted by arlen View Post
I agree, but as my post stated, the default column isn't meant to be changed by the user which is why the person I was replying to was getting an error. Shandara will have to change the default column since its password protected.
Yes, thanks for pointing out the obvious for me. I never realized that it was password protected at all The message I posted about moving the epics to the default was meant for Shandara. He has to make changes to it anyway (fixing item names, stats, procs, etc.), so he might as well adjust the default gems to the epic ones.

"On a scale of one to mein kampf, how many racists does it take to make a guild look terrible?"

[03:28] L_J: it's "olololo hero class"

[01:09:39] <DeeNogger> Any of the resident grammer nazis on right now?
 
User is online.
Reply With Quote
Old 08/09/09, 3:52 PM   #3250
Thorinson
Glass Joe
 
Dwarf Hunter
 
Alonsus (EU)
Adding gear yourself

Now that Shandara seems to be occupied, I'd like to add some new gear that's still missing to the spreadsheet myself. I'd really like them to show up in the gear planner.

Does anybody know if this is possible and more importantly how to do this?
 
User is offline.
Reply With Quote
Reply

Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Hunters

Thread Tools


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