WotLK DPS spreadsheet - Page 221

wurmfood · 08/13/09, 3:12 PM

Also, as has been mentioned, check the default gems and compare to what's in your gear right now. If you have mostly Delicate Scarlet Rubies and the default gem is Delicate Cardinal Ruby, lots of things will look like upgrades.

swiftfeet · 08/13/09, 3:17 PM

Still getting the visual basic problem when I hover mouse over 'Load gear from armory' or when I try to import from file.

Bikiniwax · 08/13/09, 3:26 PM

Originally Posted by wurmfood

Also, as has been mentioned, check the default gems and compare to what's in your gear right now. If you have mostly Delicate Scarlet Rubies and the default gem is Delicate Cardinal Ruby, lots of things will look like upgrades.

Bingo!

I swapped the default 20 ArP gem back to +16 AGI and re-ran the test and things look normal now. Thank you!

Riemu · 08/13/09, 4:57 PM

Originally Posted by Xoran

One thing to remember is that the gear planer is using the gems listed on the settings tab. This leads to wrong values when still using old gems in the current gear and new epic gems in the settings as it adds the difference in gems to the gear.

Thanks alot mate, it indeed fixed my problem!
So to all of you ARP users who have trouble with the Gear Planer Tab in the Spreadsheet: Go and check your Settings tab and make sure you input arp gems intead of agi gems!

Zer0Cool · 08/13/09, 6:11 PM

Originally Posted by Bikiniwax

Bingo!

I swapped the default 20 ArP gem back to +16 AGI and re-ran the test and things look normal now. Thank you!

Originally Posted by Riemu

Thanks alot mate, it indeed fixed my problem!
So to all of you ARP users who have trouble with the Gear Planer Tab in the Spreadsheet: Go and check your Settings tab and make sure you input arp gems intead of agi gems!

I had checked all my gems and I am still having problems with the correct display of “Gear Planner”. I am a JC with 34 Agil JC gems, 20 agil Cardinal ruby gems and one +10 to all Stats gem. All my gems are new (3.2 patch gems) and gear planner is still displaying most of all my gear as BiS and as I mentioned before whenever I change from BiS item to a #3 or #4 next in line and recalculate DPS that 3rd or 4th items becomes the new BiS.... any other suggestions on how to fix this guys?

Thanks

Ebonleaf · 08/13/09, 6:19 PM

Originally Posted by Xoran

One thing to remember is that the gear planer is using the gems listed on the settings tab. This leads to wrong values when still using old gems in the current gear and new epic gems in the settings as it adds the difference in gems to the gear.

I customized all my gems before hand, so it will use the gems i'd use and not the default.

Ebonleaf · 08/13/09, 6:23 PM

Originally Posted by davejustdave

I found that not importing from file and starting over from scratch by re entering all my information worked for me as I was getting weird gear anomalies as well.

I tried this as well, it still thinks my current gear is best.

Phouchg · 08/13/09, 6:32 PM

I'm seeing something really weird with the gear suggestions. Starting from a fresh file it's suggesting I would get a 15dps upgrade by switching Cloak of the Untamed Predator for Winter's Frigid Embrace. They have the exact same set of stats but Cloak of Untamed Predator has _more_ of each.

• promdates · 08/13/09, 6:42 PM

Don't change only one gem in the settings (using a Fractured Cardinal Ruby instead of a Delicate Cardinal Ruby), and leaving the others set to default will mess it up. If you're going to use the other gems as normal, but just adjust one you need to copy the other gem cuts into the "Custom Value" section of the gem settings before the gear planner will properly show you the right upgrades. Otherwise it will bug out and cause some of the issues people are talking about.

I'm seeing something really weird with the gear suggestions. Starting from a fresh file it's suggesting I would get a 15dps upgrade by switching Cloak of the Untamed Predator for Winter's Frigid Embrace. They have the exact same set of stats but Cloak of Untamed Predator has _more_ of each.

Using an item that has more stats than one item will give you a dps gain. Switching from WFE to CUP is 25AP (16 is agi), 7 Crit, 21 Haste, and 25 stam (not a dps increase unless you're survival). Depending on your gear, it might be a 15dps upgrade, or maybe it's only a 6dps upgrade and the sheet is bugged somehow.

Bees · 08/13/09, 6:43 PM

more rotation test fun. these lines are in the preamble:

        ' Set Auto Shot Speed to statically hasted value
        AutoShotSpeed = AutoShotSpeed * (1 / Worksheets("Calculations").Range("StaticHaste").value)

what you need to calculate is the autoshot speed, only taking into account static haste (since dynamic haste is calculated during the rotation). however, what you do is take the autoshot speed with dynamic and static haste and remove the static haste. this means you end up with the dynamically hasted autoshot speed, which is unstable since the dynamic haste value depends on the frequency of shots in the rotation (the thing we haven't yet calculated).

the correct code is probably:

        ' Set Auto Shot Speed to statically hasted value
        AutoShotSpeed = Worksheets("Calculations").Range("RangedWeaponSpeed").value / Worksheets("Calculations").Range("StaticHaste").value

Kathucka · 08/13/09, 6:47 PM

Originally Posted by promdates

Using an item that has more stats than one item will give you a dps gain. Switching from WFE to CUP is 25AP (16 is agi), 7 Crit, 21 Haste, and 25 stam (not a dps increase unless you're survival). Depending on your gear, it might be a 15dps upgrade, or maybe it's only a 6dps upgrade and the sheet is bugged somehow.

Read it again. He's pointing out that the spreadsheet tells that equipping the downgrade will boost his DPS.

That's either a straight-out bug, or else it's hitting a border condition with the haste.

Phouchg · 08/13/09, 6:52 PM

Originally Posted by Kathucka

Read it again. He's pointing out that the spreadsheet tells that equipping the downgrade will boost his DPS.

That's either a straight-out bug, or else it's hitting a border condition with the haste.

Yes, that's what I'm seeing. I also have a lot of gear that was BiS or close to it that I'm now seeing is getting eclipsed by gear that used to be a huge down grade. I've started fresh with the file a couple times and get the same results each time.

• promdates · 08/13/09, 6:59 PM

Originally Posted by Kathucka

Read it again. He's pointing out that the spreadsheet tells that equipping the downgrade will boost his DPS.

That's either a straight-out bug, or else it's hitting a border condition with the haste.

Touche sir, your reading is much better than might at this point. Since armory is terrible at not showing certain stats, what's your Haste and ArP at currently? It could be that you're over the haste cap with the CUP cloak with raid buffs?

Eijhune · 08/13/09, 7:15 PM

I made the changes in settings to the gems I use and took the dragon gems off.
It´s much better! Still not the same values as in 89g but much closer.
Thx.... I keep checking!

Phouchg · 08/13/09, 7:16 PM

Originally Posted by promdates

Touche sir, your reading is much better than might at this point. Since armory is terrible at not showing certain stats, what's your Haste and ArP at currently? It could be that you're over the haste cap with the CUP cloak with raid buffs?

I'm sitting at 242 haste unbuffed and 377 ArP. Not sure on haste when raid buffed but I have a 1.57s steady shot (raid buffed) so i doubt it's that.