WotLK DPS spreadsheet - Page 209

Sjanny · 07/23/09, 3:48 PM

Did you consider removing silencng shot from "waited" in the rotation test? I dont think it makes sense to wait for a shot that is off gcd?

Also when I try to sort the gems it goes to debugging with an error message "Compile error: argument is not optional",
pointing at Call SortItemsA function.

Shandara · 07/23/09, 4:22 PM

Originally Posted by Sjanny

Also when I try to sort the gems it goes to debugging with an error message "Compile error: argument is not optional", pointing at Call SortItemsA function.

Thanks, I've fixed this. Re-download if you can't miss that functionality.

Sjanny · 07/23/09, 5:05 PM

Thank you and awesome work

Spamurai · 07/23/09, 6:39 PM

Using your latest incantation of v91 - I'm currently wearing Broach of the Wailing Night and the Gear Planner is telling me that Favor of the Dragon Queen is an upgrade, but when equipping it and putting any kind of gem in it, it still comes out lower than my current.

Here's a link to my spreadsheet so you can duplicate: Free File Hosting Made Simple - MediaFire

Shandara · 07/23/09, 6:43 PM

Originally Posted by Spamurai

Using your latest incantation of v91 - I'm currently wearing Broach of the Wailing Night and the Gear Planner is telling me that Favor of the Dragon Queen is an upgrade, but when equipping it and putting any kind of gem in it, it still comes out lower than my current.

Here's a link to my spreadsheet so you can duplicate: Free File Hosting Made Simple - MediaFire

The Gear Planner assumes you re-gem completely. Hit the re-gem button to see what the spreadsheet comes up (the gear planner also uses this during the calculations).

There is a problem when people start with a sub-optimal (from the spreadsheet view) gemming, because during the gear planning process it has to re-gem when it equips a new item..

Spamurai · 07/23/09, 6:58 PM

I see, I didn't realize it re-gemmed everything when running through the upgrade checks. That explains it then, thanks!

Tsook · 07/23/09, 7:16 PM

Originally Posted by Shandara

There is a problem when people start with a sub-optimal (from the spreadsheet view) gemming, because during the gear planning process it has to re-gem when it equips a new item..

I have the opposite problem. My gemming is more optimal than the gemmer can do, so I lose 10 or so DPS if I hit regem. I guess this would decrease the reported value of all the gear I don't have currently equipped on the Gear Planner.

Out of curiousity, why does it regem for socket bonuses when that leads to lower DPS?

woody-shuhalo · 07/23/09, 7:47 PM

Because JC only gems are no longer Prismatic in 3.2 and meta bonus is importaint to keep.

tonic316 · 07/24/09, 12:39 AM

Originally Posted by Rathenel

The link to 89g seems to be broken at the moment.

Any idea when the link will be fixed?

Shandara · 07/24/09, 4:59 AM

Originally Posted by Tsook

I have the opposite problem. My gemming is more optimal than the gemmer can do, so I lose 10 or so DPS if I hit regem. I guess this would decrease the reported value of all the gear I don't have currently equipped on the Gear Planner.

Out of curiousity, why does it regem for socket bonuses when that leads to lower DPS?

The gemmer is making a mistake with the socket bonus on your chest. It's putting a +hit gem in there, because it's a blue socket with a +hit bonus. That makes sense, but the amount needed for your to hit-cap is so small the bonus is enough to cover it. So it should put the enchanted tears into that socket, instead of a vivid forest emerald.

A few edge cases like these have popped up which I'll fix soon.

DerailedThread · 07/24/09, 7:15 AM

Originally Posted by Shandara

The gemmer is making a mistake with the socket bonus on your chest. It's putting a +hit gem in there, because it's a blue socket with a +hit bonus. That makes sense, but the amount needed for your to hit-cap is so small the bonus is enough to cover it. So it should put the enchanted tears into that socket, instead of a vivid forest emerald.

A few edge cases like these have popped up which I'll fix soon.

On the 89 version, I would gain 4 dps if I'd upgrade a 16 agi gem to 16arp. Now I am losing 4 dps by doing the same. Same talents/spec/gear, etc. I'm not sure what is causing this, I've looked at everything that be be doing so. Is arp itemized differently in this version 91?

ChasseyLain · 07/24/09, 8:14 AM

What I dont understand is why my Valorous Scourgestalker equipment has a higher DPS than the Conqueror's Version. The Conq is a bigger version of the same set.

Shandara · 07/24/09, 8:20 AM

Small re-upload, fixing some reported issues.
- The gemming issue mentioned above
- An issue with trinkets (Death's Choice/Verdict) breaking the gear planner

@The poster above:
I have never seen the conqueror set be lower than the valorous set myself. Could you upload your sheet somewhere?

ChasseyLain · 07/24/09, 10:23 AM

I have reput all my gear again and this time it looks to be setting correctly.

Ankhunter · 07/24/09, 2:52 PM

Do you mind fixing the hit rating adjustment (Calculations cell B55) so it is correct for non-raid bosses (lvl 81-82's).

To something like:
=IF((TargetLevel-Level_Selected)<3,(TargetLevel-Level_Selected)*-0.005,-3)

I've been changing this myself, finally getting around to posting. This would be great for those of us non-raiders...

Thanks.