WotLK DPS spreadsheet - Page 129

pabelanger · 08/05/09, 10:23 PM

Seems to be an issue loading the Etched Band of the Krin Tor from Armory.

'Run-time error '13': Type mismatch

Sub clearGems(gemset As String, offset As Integer)
    Dim previous
    
    'Turn on the Auto-check throttle
    previous = autoDpsThrottle
        
    'Loop through all possible gems
    For Each cell In Worksheets("Gear").Range(gemset)
        row = cell.row
        col = cell.Column + offset
                
        If Worksheets("Gear").Cells(row, col).value <> "No" And Cells(row, col).value <> "Prismatic" Then <-- Break
            cell.value = Worksheets("Settings").Range("Default" & Worksheets("Gear").Cells(row, col).value).value
        ElseIf Worksheets("Gear").Cells(row, col).value = "Prismatic" Then
            cell.value = Worksheets("Settings").Range("DefaultRed").value
        Else
            cell.value = "None"
        End If
    Next cell
    
    'Turn off the Auto-check throttle
    unthrottleDPS (previous)
End Sub

Kom · 08/05/09, 11:44 PM

Originally Posted by Lilbitters

Well with the addition of epic quality gems, there shouldn't really be much of a decision unless you need to gem for +Hit Rating.

Beast Mastery: [Bright Cardinal Ruby]
Survival: [Delicate Cardinal Ruby]
Marksman: [Fractured Cardinal Ruby] (until 567 ArP + [Mjolnir Runestone]) and then [Delicate Cardinal Ruby]

And then in whichever socket will give you the best set bonus, place a [Nightmare Tear].

The -only- exception to this rule should be if a single Orange ([Deadly Ametrine] or [Wicked Ametrine]) or Purple gem ([Shifting Dreadstone], [Balanced Dreadstone], or [Puissant Dreadstone]) in a socket will give that slot a socket bonus of +8 Agility or greater.

What are you using to support these claims? Both shandara's speadsheet and my own one show that gemming for ArP is not viable over agility, and yes I am comparing setups with [Mjolnir Runestone] + 500 ish ArP vs just agility gems. I'd be open to the idea that maybe sometime in the future once gear reaches a certain point that this ArP setup will become marginally better or alternatively maybe really bad gear benefits from it more, but it leads to my point that there is a pretty big decision involved if your going to attempt to gem for ArP as marks, because personally I can't construct a situation where it is better.

As for your second comment, I find this odd also. Your saying that an orange gem will have the same effect as a purple one? It's quite different in reality, an orange gem will be far more viable with a socket bonus of just +6 Agility (i.e. a two socket item such as [Drape of the Faceless General]). Your right purple gems are only viable in an item with a 3 socket +8 agility bonus, however I don't believe there are any items with sockets RED, RED, BLUE but your point is still true in strict dps terms. However for survival a player may prefer the 15 stamina over 4-5 dps on something like [Saronite Mesh Legguards].

britomartis · 08/05/09, 11:58 PM

Originally Posted by britomartis

Sheet 91a seems to think Naxx gear is better than Ulduar gear for me.

For instance... I have gloves of the steady hand, gear planner says gloves of the stonereaper is 71.54 dps increase... I actually equip it in the gear tab, and it's the reverse. (58 dps lower)

Namarus · 08/06/09, 1:10 AM

Originally Posted by britomartis

For instance... I have gloves of the steady hand, gear planner says gloves of the stonereaper is 71.54 dps increase... I actually equip it in the gear tab, and it's the reverse. (58 dps lower)

I have the same problem. I've tried different fixes, but unfortunately nothing.

Scrith · 08/06/09, 4:31 AM

I'm also having a problem importing Etched Band of the Kirin'Tor from the Armory (Seether on US-Draenor). It looks like the problem could be that in the spreadsheet it is being called "Etched Ring of the Kirin'Tor" (i.e. Ring instead of Band).

Also, Collar of Ceaseless Torment (which dropped for me tonight) has the wrong name (in the spreadsheet it is called Choker of Ceaseless Torment).

Lilbitters · 08/06/09, 6:23 AM

Sorry if my post seemed confusing, I'll try and clarify it a bit more.

[quote=Kom;1339201]What are you using to support these claims? Both shandara's speadsheet and my own one show that gemming for ArP is not viable over agility, and yes I am comparing setups with [Mjolnir Runestone] + 500 ish ArP vs just agility gems. I'd be open to the idea that maybe sometime in the future once gear reaches a certain point that this ArP setup will become marginally better or alternatively maybe really bad gear benefits from it more, but it leads to my point that there is a pretty big decision involved if your going to attempt to gem for ArP as marks, because personally I can't construct a situation where it is better.[quote]

I posted back in this post my findings about being able to achieve higher DPS than what was traditionally considered optimal because of the spreadsheet's miscalculation of [Mjolnir Runestone].

With the addition of [Fractured Dragon's Eye] and [item]Fractured Cardinal Ruby[item], it is actually pretty easy to reach the Armor Penetration soft cap without having to resort to suboptimal gear choices. Higher item level gear (245 and 258 especially) will also increase the ease of obtaining this number with relatively few items. For example [Hellion Glaive], [Windrunner's Headpiece of Triumph], [Windrunner's Legguards of Triumph], [Bracers of the Untold Massacre], and [Sabatons of Ruthless Judgment].

Originally Posted by Kom

As for your second comment, I find this odd also. Your saying that an orange gem will have the same effect as a purple one? It's quite different in reality, an orange gem will be far more viable with a socket bonus of just +6 Agility (i.e. a two socket item such as [Drape of the Faceless General]). Your right purple gems are only viable in an item with a 3 socket +8 agility bonus, however I don't believe there are any items with sockets RED, RED, BLUE but your point is still true in strict dps terms. However for survival a player may prefer the 15 stamina over 4-5 dps on something like [Saronite Mesh Legguards].

In this case I didn't mean either an Orange or a Purple gem, but whichever would fulfill the socket bonus. In the following scenario lets just assume we're talking about Survival. If it were Beast Mastery obviously the gems would be for AP rather than Agi, but this conveys my concept behind color selection.

In the case of [Drape of the Faceless General] my suggested gemming would be:
Red - [Delicate Cardinal Ruby]
Yellow - [Deadly Ametrine]

This gemming would grant +36 Agility and +10 Crit Rating
vs.
Two Delicate reds granting +40 Agility
My spreadsheet values show +10 Crit Rating > +4 Agility
Actual values were in fact close enough to make it worth socketing for this +6 Agility bonus.
However, It wouldn't have been worth have been worth socketing for a +12 AP bonus.

In the case of [Saronite Mesh Legguards] my suggested gemming would be:
Red - [Delicate Cardinal Ruby]
Blue - [Shifting Dreadstone]

This gemming would grant +36 Agility and +15 Stamina (which translates into +5 AP with 3/3 Hunter vs. Wild)
vs.
Two Delicate reds granting +40 Agility
My spreadsheet values show +5AP < +4 Agility
However, if the socket bonus for this piece was +8 Agi rather than 6 Agi, it would be because +5 AP < +2 Agi only worth 40% of 1 AP in item budget but you also gain the survivability of 180 health (after raid buffs).
Exaggerating this to say you did this in 10 slots, you would only lose 4 AP but gain 1,800 health.

All in all I'll rescind my previous statement and say that it's only worth breaking all reds and a [Nightmare Tear] if you can reach the item's socket bonus of +6 Agility or better with an Orange gem, or +8 Agility or better with a purple gem.

Hagen · 08/06/09, 6:26 AM

Originally Posted by Kom

What are you using to support these claims? Both shandara's speadsheet and my own one show that gemming for ArP is not viable over agility, and yes I am comparing setups with [Mjolnir Runestone] + 500 ish ArP vs just agility gems.

When testing with Zeherah's Hunter DPS Analyzer, which shuold be close to the spreadsheet, I recognized that ArP was noticably below Agi. But the reaon is just that you can easily get close enough to the softcap wih the new gear. And if you are close to the cap Agi is more worthwhile then ArP. Just change some gear to gt you below the cap and test by switching one +20Agi gem with one +20ArP gem. You should see an DPS increase.

swiftfeet · 08/06/09, 8:06 AM

Error with spreadsheet

I am encountering an error using the latest version of your DPS spreadsheet Version 91a.

I am using Excel 2003. If this is the root of the issue, please let me know. As far as I know, spreadsheets are relatively backwards compatible.

The error occurs when I try to mouse over the "Load Gear from Armory" button on the "Gear" tab. The MS Visual Basic debugger comes up and two error messages are displayed. They are the same and say: "Compile Error: Automation Error".

The debugger highlights the Private Sub Worksheet_Change(ByVal Target As Excel.Range) function when this occurs.

Thank you. I appreciate your work on this spreadsheet.

I am also getting this, any help on the matter?

KergeKacsa · 08/06/09, 8:08 AM

I have found some mistyped items:
Greaves of Ruthless Judgement -> Greaves of Ruthless Judgment
Band of Callous Aggresion -> Band of Callous Aggression

And Ring of Callous Aggression is missing from the spreadsheet.

hagelslagfabrikant · 08/06/09, 8:58 AM

hi, first time poster, long time user here

first of all, thanks for all the effort on maintaining this awesome project which has helped me out a lot, keep up the good work!

now, why i am posting:

i seem to have a problem with the newest version of the spreadsheet, with the gear planner to be more specific.

whenever i press the recalculate dps button my system goes all bonkers... cursor animation gets stuck in the wrong modes and when i mouse over to my other screen (the one excel is not open in at that moment) it just disappears at all (i can still see things highlighting as i mouse over them, but the cursor animation remains in the other screen).

next to that the system gets all slugish and i have to reset completely cause everything starts to crash...

never had this happen before, so im a bit clueless what is happening...

some system info: (might be usefull)

Processor: Intel Core i7 920
Physical Memory: 6144MB (3x 2048MB DDR3-SDRAM)
Video Card: NVIDIA GeForce GTX 295
Operating System: Windows Vista Ultimate SP2 64-bit
Excel Version: Excel 2007 SP2

hagelslagfabrikant · 08/06/09, 9:16 AM

it seems to happen whenever a progress bar is used... i just had it happen when pressing the run tests button in the rotation test tab as well...

Redamok · 08/06/09, 11:11 AM

Little update needed: I believe 2h weapon Rune Edge was renamed in 3.2 to Stormrune Edge (same stats) and is therefore not loading on 'load gear from Armory' for me. Obvious workaround at moment is to load 'rune edge' from drop downs but thought I best report it - couldn't see it mentioned in last few pages.

Cheers

Esoth · 08/06/09, 11:54 AM

The spreadsheet attributes a 655 armor pen proc to [Mjolnir Runestone]. I believe it should be 665.

skorziks · 08/06/09, 12:05 PM

Originally Posted by britomartis

For instance... I have gloves of the steady hand, gear planner says gloves of the stonereaper is 71.54 dps increase... I actually equip it in the gear tab, and it's the reverse. (58 dps lower)

Has this switching of gear caused you to loose your meta requirement?

Vercgetorix · 08/06/09, 2:14 PM

I'm comparing the DPS results, with all available buffs turned on other than temporaries you never see, with Rawr's hunter module. I also compare this against WWS parses by Event Horizon and other tools for boss fights where there are no special buffs.

Rawr reports (or did, before today's release that has a bug showing 19.5k...) mid 4k dps. The spread sheet had the same setup listed at just under 7k. My actual run, minus a few upgrades, on patchwerk was ~5.5k.

How close are you coming to your spreadsheet dps on a flat out, single target tank and spank fight (without special buffs like those from hodir/loatheb/thaddius)?

Repaxan · 08/06/09, 3:06 PM

Would it be possible to model single-target Volley?

me2evil13 · 08/06/09, 3:51 PM

so here a ? it shows that in 25mans i should be doing about 7056.12 dps. and in all of my 25man i can only push out about between 5.2k - 6k, latancy's about 150ms, frame rate about 20. i'm not trap dancing. and yes i know i'm very close with my gear to going to marks. any help would be great. thanks

Saltyone · 08/06/09, 4:28 PM

so here a ? it shows that in 25mans i should be doing about 7056.12 dps. and in all of my 25man i can only push out about between 5.2k - 6k, latancy's about 150ms, frame rate about 20. i'm not trap dancing. and yes i know i'm very close with my gear to going to marks. any help would be great. thanks

The spreadsheet models theoretical performance under optimal scenarios: long, fixed fight length (6 minutes), several kill shots, multiple rapid fire/cow, no movement, no target switching, no setup/threat issues, 100% uptime on all non-exclusive raid buffs/debuffs and perfect shot priority placement. Also, by default procs are averaged, taking RNG out of the equation and causing all attacks to benefit from them, not just shots during the randomized proc windows.

Of course, this is not a criticism of the spreadsheet - all of these parameters are configurable if you know how to in order to get a more realistic number. But you can always use the number given by the spreadsheet as an indicator of relative performance. It’s helpful for determining whether a change is an upgrade and for weighing which changes offer the greatest performance increase.

If I had to pick a single integer to represent most Ulduar fights, I see maybe 75% of my spreadsheet number, which varies wildly from fight to fight and my assignments. However, if you use a ‘near-realtime’ tool like Worldoflogs, and narrow your window to period of time where you know the scenario is close to optimal (as described above), you may find the spreadsheet value more closely reflected. An Ignis speed kill is presently the most straightforward benchmark in Ulduar for Hunters, merely losing Steady Shots to Flame Jets.

vith · 08/06/09, 11:49 PM

Custom cloak isn't showing up in the Gear Planner; also not sorted correctly in Gear.

Rezdan · 08/07/09, 12:48 AM

Choker of Ceaseless Torment is misnamed and should be "Collar of Ceaseless Torment". It's not currently on WoWHead but you can view it on the Armory. While the stats are correct in the spreadsheet, the Gear Planner seems to be miscalculating this item's expected DPS and incorrectly stating that it is a significant DPS loss compared to [Broach of the Wailing Night]. When swapping the item in, the spreadsheet does confirm that the Collar is more DPS. The stat allocations are quite similar for these two items so there shouldn't be any stat-cap issues.

Interestingly, when I reran the Gear Planner's Recalculate DPS with the Collar equiped, swapping to the Broach shows a DPS loss of over 100 while actually doing the swap only reduces DPS by around 20.

Since Wowhead is missing quite a bit, here's the MMO List of the Trial of the Champion loot.

Bees · 08/07/09, 1:06 AM

possibly a bug in the calculation of Swordguard Embroidery:

Calculations!Q86 uses TotalShotsPerSecond and FinalCrit

seems it should either be using TotalShotsPerSecond and FinalHit (if it procs from hits) or CrittingShotsPerSecond and FinalCrit (if it procs from crits)

[edit] and thinking about it, i wonder if all of the crit-triggered trinket proc rates might be off. CrittingShotsPerSecond assumes all shots hit (the rotations factors hit into the damage, not the frequency), so it seems that crit trinkets should be:
AverageTimePerCrit = 1 / (CrittingShotsPerSecond * FinalHit * FinalCrit)

something that i don't think is a bug, but i've been wondering about is the partial resists formula. if we resist 10% of the damage 30% of the time and 20% of the damage 15% of the time, the average resist should be 6%, not 4.5% (10%*30% + 20%*15%, rather than 10%*30% + 10%*15%). i'm probably missing something obvious here, but a search found nothing but a couple of people asking the same question.

Zer0Cool · 08/07/09, 3:17 AM

Having problems with the latest version of spreadsheet. Since the new patch the only modefications I did to my gear are the new gems, Delicate Cardinal Ruby & Nightmare Tear. Once I had updated the "gear" tab using "load Gear from Armory" all my gear now is BiS... (I know its good lol but not that good).

I did a test where I changed my t7.5 shoulders, currently displayed as BiS to a "Shoulders of Misfortune" and recalculated DPS and now "Shoulders of Misfortune" became the new BiS.... this is not supposed to happen.

If this is a known problem my bad.

Argg0 · 08/07/09, 3:54 AM

I'm getting an error when trying to import specs with glyph included... even if it's from Wowhead or Armory.

Without the glyphs it works normally.

The error happens on a line where it sets glyph to none.

atuin · 08/07/09, 4:56 AM

Originally Posted by Vercgetorix

How close are you coming to your spreadsheet dps on a flat out, single target tank and spank fight (without special buffs like those from hodir/loatheb/thaddius)?

As BM was geting within +-5% diference on patchwerk fight, in other fights generaly i get also quite close as long im not doing any additional jobs during fight (like webed people on maxxena, harpoons on razorscale etc.) Thats mainly because BM is relatively easy to maintain near perfect rotation while surv suffer badly when rotation is not timed correctly or thers some element missing

And colliseum-5 weapons and gear got upgraded in yesterdays fix - they are iLvl 219 and have slightly better stats than those in v91a spreadsheet

DreamScaper · 08/07/09, 5:35 AM

A few "problems" with spreadsheet.

1. TBC boss 1 and 2 should be level 83 not 73.
2. Is the hit raiting per lower level accurate? Woring on VH with level 77 mobs, and it wants me to be at 4% hit. It is my understanding (which might be wrong) that 5% 80, 4% 79, 3% 78, 2%77, etc.
3. The 42 ap gem/health regen gem looks like it requires a yellow and blue in your spreadsheet. The gem (invergeratting earthseige) requires 1 red, 2 blue.