WotLK DPS spreadsheet - Page 287

Failure · 05/21/10, 1:22 AM

Is it possible the current version of the spreadsheet has an old ArP cap? Based on the numbers I'm seeing messing with my gear, it seems to not realize that the cap is now 1400 instead of ~1230?

wilegenuis · 05/22/10, 3:34 AM

I’m using the latest spreadsheet (93j) and I still see the issue that was with the previous version (93i), whenever I filter out the 25-man gear in the “gear planner” tab (only the 10-man check box is selected), I’m still getting few gear options that are only relevant for 25-man raids. It’s also happening the other way around when 10-man gear is showing up when the 10-man check box is not selected. I assumed that the reason for that might be that these gears can be dropped from both 10-man and 25-man, but according to wowhead this is not the case.
Examples are Whispering Fanged Skull which according to wowhead drops only in ICC-10 (Deathwhisper), spreadsheet present it when the 25-man check box is selected and the 10-man check box is not. On the other direction Zod's Repeating Longbow is appearing is only dropped from ICC-25 (Deathwhisper) based on the wowhead and the spreadsheet, but also appears when only the 10-man check box is selected

UnstableFluxx · 05/24/10, 12:59 PM

So a couple questions arose when I was fooling around with the spreadsheet. 1.) For my current SV gear and spec, the spreadsheet has normal WFS as an upgrade to normal DC in the gear planner but shows it as 30ish dps loss when i switch from DC to WFS in the gear tab. Is the sheet broken or am I just not understanding something here? 2.) Also with my current gear and spec, the sheet shows me at 84.72% Ranged Critical Hit Chance vs. Level 83 with the normal 25m buffs minus boomkin, when in reality I have a little over 76% static crit when buffed. Is the Ranged Critical Hit Chance vs. Level 83 the averaged crit over the course of a boss fight with abilities procing or is it static(passive) crit?

alienangel · 05/24/10, 5:02 PM

Almost every proc we have is always averaged in the spreadsheet. So yes, the display value is your averaged crit over a fight with all procs, talents and buffs. There is a cell displayed somewhere for your character-sheet crit I think, but it's not used for anything.

Regarding the disparity between the gear planner and the gear tab, trust the gear tab. The planner is always going to be an estimate, not a prediction, so the two disagreeing doesn't mean anything is broken. Some of the disagreements are due to incorrect gem settings (e.g. your current item gemmed arp shows as an upgrade over a better item that that the planner puts agi gems into because you haven't changed your default red gem to arp), some of the disagreements are due to haste (shot rotation shuffles around with different haste), and some are just due to stat weights changing with different pieces of gear. In this case I'd guess it's the lattermost.

Feanoro · 05/28/10, 12:55 AM

Originally Posted by Dch48

You can't get the new version by clicking on the link, at least not in IE8. You get the warning that IE has blocked the site from downloading files and when you click to allow the download, you just come back to the main forum page. I had to right click and choose save target as to get the file.

Yes, that's the correct behavior for IE downloading from unknown/untrusted sites. It prompts you for permission, and if you give it, reloads the page. If it didn't refresh to that page but rather went back to the forum topic listing, you may need to check any ad-blockers or such you've installed.

Caribald · 05/31/10, 6:35 AM

Excuse me if my post is not supposed to be in this thread, I haven't been able to find an answer to my question elsewhere and it's been breaking my balls for months now.

In the spreadsheet, if a player has 100% armor penetration, the spreadsheet says:

Target Armor Reduction
Target Armor 10643
Effective Armor 315

For Hunter 2,03%
For Pet 34,68%

---

Looking at the formula from here, I believe the above is incorrect (or, perhaps more likely, I'm missing something).

If (level<60)
C=400+85*targetlevel
Else
C=400+85*targetlevel+4.5*85*(targetlevel-59);

For a level 80 target, C=15232.5. For a level 83, C=16635.

The cap for Armor Penetration then is: (armor + C)/3.

---

Target Armor is 10643. Applying Sunder Armor and Faerie Fire will reduce this to 0.80 * 0.95 * 10643 = 0.76 * 10643 = 8088.68. Using the formula for the Armor Penetration cap:

(8088.68 + 16635)/3 = 8241.226666∞

"The game chooses the minimum of x and y" - in this case 8088.68 armor vs. 8241.226666∞. Armor is the lowest number, and therefore all the armor should be removed by Armor Penetration.

My question is: How do you come up with 315 effective armor?

Arreia · 06/02/10, 3:24 PM

If it hasn't already been mentioned, the item Vengeful Noose's socket bonus is incorrectly marked as +4 agi on the spreadsheet. The correct socket bonus is +6 agi.

Seoman · 06/09/10, 9:22 PM

For me, the Spreadsheet seems to give 4x T10.5 (i264) (no pants) an under 100 DPS edge over 2x T10.5 (i264) + 2x T9.5 (i245), but the spreadsheet can't possibly model reapplying SrS at advantageous times to take advantage of added crit.

Do we still trust the Spreadsheet, or stick with critting SrS?

Shandara · 06/10/10, 3:50 AM

Originally Posted by Seoman

For me, the Spreadsheet seems to give 4x T10.5 (i264) (no pants) an under 100 DPS edge over 2x T10.5 (i264) + 2x T9.5 (i245), but the spreadsheet can't possibly model reapplying SrS at advantageous times to take advantage of added crit.

Do we still trust the Spreadsheet, or stick with critting SrS?

The sheet only models carrying over %-damage modifiers at the moment and that imperfectly. These things aren't really easily and accurately possible in the model used in the sheet. Simcraft would be a better candidate.

Seoman · 06/10/10, 2:40 PM

Originally Posted by Shandara

The sheet only models carrying over %-damage modifiers at the moment and that imperfectly. These things aren't really easily and accurately possible in the model used in the sheet. Simcraft would be a better candidate.

Apologies - my question wasn't as clear as it should have been:

Given that the spreadsheet is not really great at modeling such a situational thing as reapplying SrS when advantageous from crit% procs, for a player who is conscientious about doing the reapplication, is it more worthwhile to stick with 2x T9.5 (i245) and 2x T10.5 (i264), or are the more passive benefits of 4x T10.5 (i264) better enough in-game to warrant the upgrade?

I do have DV (i245) and DBW (i264), which have helped me keep the T9.5 gear this far, but I have almost no chance at the T9.75 (i258) versions, since I don't think too many other classes have any incentive to go after them now, other than for ToGC-25 achievements.

AnthonyB · 06/13/10, 10:16 AM

I think the stats on the Seal of Many Mouths are wrong.

Is missing the Yellow socket and the equip bonuses are wrong.

wilegenuis · 06/19/10, 8:52 AM

Originally Posted by Seoman

I do have DV (i245) and DBW (i264), which have helped me keep the T9.5 gear this far, but I have almost no chance at the T9.75 (i258) versions, since I don't think too many other classes have any incentive to go after them now, other than for ToGC-25 achievements.

Spreadsheet is showing that T9.245X2 + T10.264X2 is better than T10.264X4. My reality shows that T10.264X4 is showing much better DPS then T9.245X2 + T10.264X2 on ICC bosses.
Don’t know why, but the delta is real clear

astraldub · 06/23/10, 7:27 AM

Hello. Any plans for releasing next version of spreadsheet with Ruby Sanctum gear included ?

Bunnybare · 06/24/10, 12:32 PM

Originally Posted by wilegenuis

Spreadsheet is showing that T9.245X2 + T10.264X2 is better than T10.264X4. My reality shows that T10.264X4 is showing much better DPS then T9.245X2 + T10.264X2 on ICC bosses.
Don’t know why, but the delta is real clear

T9.245X2 + T10.264X2 is showing a DPS loss for me compared to T10.264X4. What pieces did you change? I just changed a couple of 264s to:

T10.264X2 = head and chest
T9.245X2 = gloves and shoulders

wilegenuis · 06/26/10, 11:30 AM

The exact point where T10.264X4 is showing better results in the spreadsheet over T9.245X2 + T10.264X2 is individual point. I would guess to say that the biggest factor of it is your ArP. As ArP doesn't scale linearly, going from 50% to 51% ArP helps you much more than going from 10% to 11%. Therefore if you reached this point, then the effect of adding T10.264X2 is adding big DPS effect as a result of the ArP increase.
My numbers are showing a different story, currently my ArP is 535 with T10.264X4 and the spreadsheet still suggest that T9.245X2 + T10.264X2 will give a better DPS. However my next change in gear will replace my Windrunner's Legguards of Triumph (71 ArP) with Draconic Bonesplinter Legguards (77 ArP), as a result my ArP will increase into 541 (delta of only 6 ArP) but the spreadsheet recommendation will be to stay with T10.264X4 in this case.