Iroared

You might have to enable macros, by default their functionality may be limited. Try tools->options->security or something of that sort. In office 2007 there was a warning on top of the page saying that macros were disabled and a link to enable them.

 

Thorinson

I've bumped into the hit rating in the Gear Planner issue a few times too. Now that it has a bit more attention, I gave it some thought.

Wouldn't the following solution be simple to implement, convenient to use and sufficient for most situations? Offer three possible ways to handle +hit on items:
- disregard all +hit - values all +hit on items in the Gear Planner as 0 (equal to Assume 100% hit: yes)
- use +hit until capped - values +hit on items taking into account current total +hit on gear/talents/etc and the hit cap (equal to Assume 100% hit: no)
- use all +hit - values all +hit on items fully (new option)

(Feel free to rename options. )

 

• VRoscioli

This was the original suggestion I had made. As Kathuka pointed out though, we would actually be replacing the excess hit through agility gems (or the gem of your choice), so it would be more appropriate to change the third option to "Use +hit value until hit and then replace with agility (or other stat of your choice"

EDIT: Now that I think about it, we could just have it pick the highest DPS value/itemization stat that isn't hit and use that automatically, since I don't see much of a reason to gem with a suboptimal gem.

 

tyrindor

I'm trying to figure out how [Belt of the Betrayed] is better than [Belt of Dragons].

For MM, sure it is... but for Surv, it seems to be worse.. yet the spreadsheet says otherwise. The only way I can see this being better is if I need to put a JC gem into another item, because one doesn't have the sockets.

 

Lilbitters

That's exactly the answer. They are -very- close to each other overall, but as a non-JC, Betrayed is usually better than Dragons depending on exactly how much ArP you currently have. As MM, that value is exaggerated even more.

As a JC, it's exact value depends on the rest of your gear. If you didn't have any other socket bonuses that could be achieved through using a Dragon's Eye over a blue or yellow gem, then that free Dragon's Eye will probably make Dragons better than Betrayed. However, if you do have other socket bonuses that could use the Dragon's Eye, you'd have to subtract the stats that you would lose by either not achieving that bonus or gemming sub-optimally in order to achieve it from the stats of Belt of Dragons (or comparatively you could "add" those stats to Belt of the Betrayed).

 

Shandara

I will most likely add the third option in some manner to the sheet. I'm kinda busy this week and I want to have a look at the PTR before I make any changes so expect something in the weekend.

WotLK Hunter DPS Spreadsheet

 

jenkins3030

problem solved.

 

Shandara

For ranged weapons, remember to use the 'Ranged Weapons' button on the Gear Planner often.

WotLK Hunter DPS Spreadsheet

 

Slager

It appears that activating the Mixology buff on the spreadsheet is not correctly effecting the Elixir of Armor Piercing. All other elixirs are correctly displayed at their higher value (usually ~60ish) but the ArPen elixir remains at it's base value of 45.

*edit* I just checked in-game and Elixir of Armor Piercing has a value of 61 ArPen with Mixology.

 

jenkins3030

Thank you so much, i never noticed that button before. Now it does show the emitter as being higher.

 

Kurianna

I would say that you are taking some great gloves and replacing them with the weakest of the tier pieces (and at ilvl 219 at that) and taking probably the best legs and doing the same ilvl downgrade. The 4pc bonus probably doesn't make up for the far weaker stats. You didn't say how much agility you lost. Those gloves and legs have insane amounts of agility, and the tier versions just don't.

Now, I may be wrong, and it could be something else, but this is what I saw with the same gloves and Darkcore Leggings (also lots of agi).

 

Kathucka

It occurred to me that I should provide an example to show just how useless the gear planner currently is in some circumstances.

The gear planner shows the [Surge Needle Ring] to be a 2 DPS downgrade from my [Ring of Invincibility]. However, if I swap it in on the Gear tab, and swap out all my hit rating gems for agility (still leaving me well over the cap, BTW), my total DPS goes up by 20.

So, it's off by 22, and shows an upgrade as a downgrade.

 

Kharthus

There does seem to be something weird going on between Giant's Bane and Magnetized Projective Emitter though. The gear planner always values Giant's Bane higher, but swapping in the Emitter results in higher dps even without swapping out gems for the extra hit rating.

 

Gadget

@Kathucka: If changing out your +hit gems for AGI, still leaves you "well over the cap", then why do you still gem for +hit? How much hit do you have when you put on the Surge Needle Ring, since it has 32 +hit?

If you are already above the hit cap by the rest of your gear including +hit gems, and then put on a ring with +hit, it is less good than a ring with all damage stats. After you changed your gems to AGI *and* put on the ring (has 32 +hit), you are still over the cap. With the other ring you wouldn't. That is probably why it can be both, a downgrade and an upgrade, depending on the rest of your gear settings.

 

• VRoscioli

Clearly, in Kathucka's situation, he is not "well over the hit cap" prior to equipping the Surge Needle Ring. I presume he has just enough +hit gems to put him to the cap. The point is that equipping the ring (which has +32 hit) allows him to change these few hit gems to agility, remain hit capped, and get a DPS gain, rather than "wasting" the +32 hit rating (since he's already hit capped, albeit through gems).

He was showing an example of why the spreadsheet should at least give the option of counting excess hit as something of value (whether it be the DPS of hit or agility or whatever).

 

vashe9

Hi, here's my wow armory link : The World of Warcraft Armory

I have recently acquired the Magnetized Projectile Emitter ([Magnetized Projectile Emitter]) from XT 10 HM and there's something verry odd :

Siren's Cry would give me 16 more dps, Giant's bane 19more but the dps of the weapon is the same and the max-min damage are also lower than the MPE. I doubt it's because of the armor Pen. Please help me !

Thanks

(I'm alliance so I'm capped (7%) in a raid environnement even without the hit from MPE so its not that)

Edit : i forgot

 

TrevvyTrev

EDIT: mooted.

 

Shandara

This is something I'm working on, but it's not trivial to determine which gems can be replaced (I can't just count any points of hit rating over the cap as agility, because they only come in chunks of 8 or 16 on gems) and how they are replaced.

At least it's not trivial to do in plain Excel (VBscript it's doable, but I want to avoid using that since this is supposed to work on the gear planner).

WotLK Hunter DPS Spreadsheet

 

• VRoscioli

While that is true, just doing it point-for-point would be more accurate than what we have now, and would probably be sufficient imo.

EDIT: To elaborate, doing it point for point would at least give it a good metric for at-a-glance upgrades. Sure, the fact that it might be off by a few DPS due to being off by up to 7 agility might affect the relative position of side-grades, the real concern is being able to correctly identify a solid upgrade (e.g. the Surge Needle Ring example).

But I agree, if you want to model it very accurately, it is very nontrivial, as it becomes an optimization problem (since you need to take into account possible socket bonuses, the effect of removing an enchant like Icewalker, etc), and optimization problems aren't really what the spreadsheet is built for.

TL;DR: Point-for-point is easy and gives relatively good at-a-glance results. Modeling the exchange of individual gems is (potentially very) difficult but gives more accurate numbers.

 

Scrith

The Latency setting on the Shot Rotation tab seems a bit inconsistent. With my current setup I am seeing higher DPS at 80ms (7916) than 75ms (7891) when I hit the Test Rotation button after changing the Latency. I've been trying out some low numbers lately because my guild has set up a tunneling connection to our WoW server that reduces latency to the 25-75 range.

 

• VRoscioli

Because if you are not using the +hit on the MPE, the others are simply better.

Comparison:

SC vs MPE (16 Agi in socket)
-7 Agi
+25 Crit
+22 Haste
-20 AP

I think the crit and haste outweigh the AP and Agi

GB vs MPE (16 Agi in socket)
+21 ArP
+27 Haste
-7 Agi
-20 AP

The Arp and haste outweigh the Agi and AP by even more

Without using the hit on the MPE, the others are simply better.

 

• VRoscioli

My guess is that with these particular latency values and your haste rating, the shot rotation is lining up slightly differently. This has a similar effect to waiting for a higher-DPS shot, for some latency/haste combinations.

 

Whitefyst

On the other side though, if you are using the +hit, then the MPE is better. For instance, if the 27 hit was used to replace 24 hit rating in gems with 24 agility, then the differences are:

SC vs MPE (16 Agi in socket)
-31 Agi
+25 Crit
+22 Haste
-20 AP

GB vs MPE (16 Agi in socket)
+21 ArP
+27 Haste
-31 Agi
-20 AP

31 more agility is a big deal since that is really 35.5 agility with CE and BoK. This equates to about 39 AP and 0.42% crit. Thus:

SC vs. MPE
-59 AP
+0.13% crit
+22 haste

GB vs. MPE
+21 ArP
+27 haste
- 59 AP
- 0.42% crit

Hence, although I have both GB and MPE, I use the MPE since it allows me to replace hit in other places for more DPS.

 

• VRoscioli

Oh I agree absolutely, I was just explaining why it was worse for him (as he indicated has was not using any of the hit).

 

• Allara

89g: [Band of Lights] is classified as an Ulduar-25 drop. According to Wowhead comments, this item actually drops from Algalon-10, which would be Ulduar-10 Hard.