WotLK DPS spreadsheet - Page 194

Kathucka · 06/22/09, 9:03 PM

Originally Posted by GhostRoc

Hi all,

I can't open the 87g version after I download it.

The error message I'm getting is "Hunter_DPS.xl cannot be accessed. The file may be corrupted, located on a server that's not responding, or read-only.

Any advice? I was opening the previous version fine.

Thanks!

Sounds like your download failed. Check the file size. Download it again.

Iru · 06/23/09, 12:32 AM

Originally Posted by Kathucka

For now, though, the only way to accurately determine if an item is an upgrade is to save your current profile with your current gear and spec, create a new (experimental) profile, load in the new item, fiddle with the gems and enchants on the new profile, and then save the new profile. You can then compare two profiles on the overview page to see which has the bigger numbers. And no, you do not want to do that right after an item drops.

You can always just equip the relevant item and hand-adjust both your hit, and which ever other stat you're dropping - there's generally only one other that you'd be gemming/enchanting for - and then look at your DPS, but I can see that having the spreadsheet do that for you would be more convenient.

• VRoscioli · 06/23/09, 11:05 AM

Originally Posted by Kathucka

If you have time to put in the work, an even more accurate technique would be to add two more options: "Translate Hit Rating and Agility" and "Translate Hit Rating and Attack Power". This would simulate the re-gemming that players always do.

These options calculate the hit rating difference between the equipped item and the new item, and subtract it from the current hit rating to get the un-adjusted total hit rating with the new item equipped. If this is over the cap, any excess hit rating on the item is removed and translated to agility (or attack power) on the item. If it's under the cap, the missing hit rating is added in and made up by subtracting agility (or attack power) from the item. The adjusted stats on the new item are used to perform its DPS calculation.

This is actually similar to what I was thinking. I was thinking to actually make it a drop down that would allow us to replace excess hit with any stat that we get a calculated DPS value on the overview page. That way, it can be used for say ArP for the new high-DPS MM ArP spec and for future specs we haven't conceived yet.

But I agree, this is probably the most accurate way to handle this. Since all of these DPS values are pre-calculated, I don't imagine it would be an incredibly difficult change to implement.

• VRoscioli · 06/23/09, 11:07 AM

Originally Posted by Iru

You can always just equip the relevant item and hand-adjust both your hit, and which ever other stat you're dropping - there's generally only one other that you'd be gemming/enchanting for - and then look at your DPS, but I can see that having the spreadsheet do that for you would be more convenient.

As previously stated, this is not something that is feasible to do immediately following an item drop. As such, you would have to do this for every possible drop (that involves hit rating) before hand. This obviates a large convenience of the spreadsheet for determining gear upgrades.

Namuka · 06/23/09, 12:32 PM

I downloaded the spreadsheet but don't have a full copy of office 2007 so I couldn't edit anything. I used office 2003 and everything works but I cannot click on any of the buttons to calculate things or test rotations. Is this a problem with 2003 excel and do I need to get 2007? Also under pet how do I add rake and claw to a cat to get special DPS .. it seems to not be in the drag-down menus.

Iroared · 06/23/09, 2:31 PM

Originally Posted by Namuka

I downloaded the spreadsheet but don't have a full copy of office 2007 so I couldn't edit anything. I used office 2003 and everything works but I cannot click on any of the buttons to calculate things or test rotations. Is this a problem with 2003 excel and do I need to get 2007? Also under pet how do I add rake and claw to a cat to get special DPS .. it seems to not be in the drag-down menus.

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 · 06/23/09, 5:17 PM

Originally Posted by VRoscioli

This is actually similar to what I was thinking. I was thinking to actually make it a drop down that would allow us to replace excess hit with any stat that we get a calculated DPS value on the overview page. That way, it can be used for say ArP for the new high-DPS MM ArP spec and for future specs we haven't conceived yet.

But I agree, this is probably the most accurate way to handle this. Since all of these DPS values are pre-calculated, I don't imagine it would be an incredibly difficult change to implement.

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 · 06/23/09, 8:10 PM

Originally Posted by 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.

)

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 · 06/24/09, 1:37 AM

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 · 06/24/09, 3:41 AM

Originally Posted by 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.

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 · 06/24/09, 8:34 AM

Originally Posted by 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.

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.

jenkins3030 · 06/24/09, 11:22 AM

problem solved.

Shandara · 06/24/09, 11:38 AM

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

Slager · 06/24/09, 11:40 AM

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 · 06/24/09, 12:06 PM

Originally Posted by Shandara

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

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