WotLK DPS spreadsheet - Page 148

KraxisSingular · 04/24/09, 1:04 PM

Originally Posted by Nooska

Compared to which version? (All versions have changes, some bug changes, some mechanic changes)
Did you switch any gear or buffs, at all?

Remember the values change relatively according to your crit and haste (it may not be much, but just enough to make a 6 dps difference which is what you are reporting).
Haste favors [Fury of the Five Flights] as you get the stacks up faster, so they apply for more specials in the same duration fight.
Crit favors [Mirror of Truth] because it only procs on crits - have less crits and it will have lower uptime - more crits and you get more uptime.

Doubt that is the reason. I have lost crit since I changed to FFF (other than from MoT of course), back then it was an upgrade, now it is a downgrade (talking 1.5 DPS so it hardly matters). I don't know what to make of it.

In any case, since ES no longer stacks on FFF I think I will take MoT since I will get the full value on trash and fights where I might have to wait or un or something like that. It was an advantage I was willing to forego before, but now that ES seems bugged to a degree I don't think I can allow it any longer.

• VRoscioli · 04/24/09, 1:20 PM

Originally Posted by Mippy

I don't think it makes sense that the spreadsheet is acting as if the default enchant is applied to the current weapons (I'm hit capped, so 26 agi > Accuracy, but changing the default enchant from Accuracy to 26 agi lowers my current equips' DPS), but rather some other bug there.

This is what I was trying to describe. The following is what the spreadsheet is doing (if you have 1H weapons equipped):

1. Calculate the DPS value of each weapon
Included in this calculation is the assumption that you are using the "default" enchant on your weapons, not what you actually have. This means that changing the default enchants will change the value of your current weapons in the gear planner, but will cause potential upgrades to change by the same amount (that is, stay the same relative to your current weapons).

2. Add these values and treat this as the "DPS" to compare potential 2H weapon upgrades to
However, while this DPS value is determined by your "default" enchants, the DPS values of potential 2H weapon upgrades are affected by what you *actually have on your weapons*.

The opposite is true if using a 2H weapon:

1. Calculate the DPS value of the 2H weapon
Included in this calculation is the assumption that you are using the "default" enchant on your 2H weapon, not what you actually have. This means that changing the default enchant will change the value of your current weapon in the gear planner, but will cause potential upgrades to change by the same amount (that is, stay the same relative to your current weapon).

2. Divide this value by 2 and treat this as the "DPS" for each 1H weapon to compare potential upgrades to
However, the DPS values for MH/OH is calculated using what you currently have equipped, not the default enchant. As such, it will deduct a large value from potential MH upgrades (because you have a MH enchant) but nothing from your potential OH upgrades (because you have no OH weapon and thus no OH enchant).

The Consequences

What this means is that comparing 1H weapons to each other works as expected (compares using the same enchantment DPS increase) and that comparing 2H weapons to each other works as expected (compares using the same enchantment DPS increase), but comparing 1H weapons to 2H weapons does not work as well.

Solutions to this "problem"

Either compare all weapons as though they have the "default" enchantment value or compare potential upgrades as though they have the default enchants while using the current enchants for the current weapons (as it is presumably supposed to be now, but corrected).

Mippy · 04/24/09, 3:46 PM

Originally Posted by VRoscioli

This is what I was trying to describe. The following is what the spreadsheet is doing (if you have 1H weapons equipped):

1. Calculate the DPS value of each weapon
Included in this calculation is the assumption that you are using the "default" enchant on your weapons, not what you actually have. This means that changing the default enchants will change the value of your current weapons in the gear planner, but will cause potential upgrades to change by the same amount (that is, stay the same relative to your current weapons).

*snip*

I'm not convinced this is the case, because the relative positions of my weapons on the list DO change when I change (both) default enchants, and they shouldn't according to what you laid out. Though that could be related to the problem I mentioned where the value of my MH changes when I hit the sort button, and they could be two separate bugs.

• VRoscioli · 04/24/09, 4:32 PM

Originally Posted by Mippy

I'm not convinced this is the case, because the relative positions of my weapons on the list DO change when I change (both) default enchants, and they shouldn't according to what you laid out. Though that could be related to the problem I mentioned where the value of my MH changes when I hit the sort button, and they could be two separate bugs.

Upon further inspection, you appear to be correct. I looked at the MH and OH formulas and thought the only change was the enchant calculation, but its also doing something with hit.

The MH DPS calculation has the term:

+ (DpsHitCompare * IF(MeleeHit+HitRatingToCap>0,IF(MeleeHit+HitRatingToCap>AL5+$J$145,AL5+$J$145,MeleeHit+HitRatingToCap),0)) +

While the OH DPS calculation has the term:

+ (DpsHitCompare * IF(OffHandHit+HitRatingToCap>0,IF(OffHandHit+HitRatingToCap>AL5+$J$146,AL5+$J$146,OffHandHit+HitRatingToCap),0)) +

$J$145 and $J$146 are the hit values from the (adjusted) enchants from MH and OH weapon, respectively. That is, $J$145 is the DefaultHit-CurrentHit where DefaultHit is the hit granted by the default enchant and CurrentHit is the hit granted by the current enchant (on the MH weapon). So adjusting either the current or default enchant could lead to weird behavior, I suppose.

Haggypants · 04/24/09, 10:14 PM

So, i've been playing with the excel sheet trying to figure out what is the bis now and what we need for hit and what we need that doesnt have hit on it. I plugged in a 4 set of scourge for set bonus. I'm wondering if anyone has figured out the bis yet. Ill still be trucking away at it if not.

GwolfGarona · 04/24/09, 10:50 PM

Originally Posted by Haggypants

So, i've been playing with the excel sheet trying to figure out what is the bis now and what we need for hit and what we need that doesnt have hit on it. I plugged in a 4 set of scourge for set bonus. I'm wondering if anyone has figured out the bis yet. Ill still be trucking away at it if not.

Best Possible DPS in Shandaras WotLK Spreadsheet is the forum for using the spreadsheet to discover BiS. This forum is for checking the accuracy of the sheet in determining BiS. No need to combine the two threads

Riceman · 04/25/09, 1:51 AM

So, i must be stupid or something. For some reason when i try to click on "load from armory" button it doesn't work, I followed the directions too. Can someone help me out please?

Mr Tazza · 04/25/09, 2:05 AM

Wrong thread, sorry

Lactose · 04/25/09, 7:57 AM

Missing: [Chestguard of Insidious Intent] -- Ulduar 25

Zoen · 04/25/09, 10:14 AM

Hi, could you have a look at the mechanics of silencing shot in the shot rotation test tab? it seems to be waiting a GCD before casting the next shot.

The10 · 04/25/09, 10:19 AM

Originally Posted by Riceman

So, i must be stupid or something. For some reason when i try to click on "load from armory" button it doesn't work, I followed the directions too. Can someone help me out please?

Maybe you need to activate Macros and ActiveX Elements. Look for a horizontal yellow bar in the upper fifth of your screen in Excel titled "security blabla" (Office 2007).

Riceman · 04/25/09, 1:01 PM

Originally Posted by The10

Maybe you need to activate Macros and ActiveX Elements. Look for a horizontal yellow bar in the upper fifth of your screen in Excel titled "security blabla" (Office 2007).

I don't have Office 2007, I have 2003. Does that matter?

Nooska · 04/25/09, 1:47 PM

Originally Posted by Riceman

I don't have Office 2007, I have 2003. Does that matter?

Then its probably a setting option.

I use 2003 as well (My mom bought it and it had 3 licenses, so me and my SO each have it as well) and the spreadsheet works fine - I did have to go and change t he security for the sheets to lower than the standard which blocks macros.
I believe that tehre is a good description of how to do it in the beginning of the thread, as I followed a guide from here.

Allara · 04/25/09, 2:31 PM

[Tunic of the Limber Stalker] has had it's stats adjusted. It no longer has the 63 armor penetration.

Argg0 · 04/26/09, 3:19 AM

I Still get no change on pet DPS by specing into feeding frenzy (Cunning)...

and [Relentless Gladiator's War Edge] has not been included yet.