WotLK DPS spreadsheet - Page 17

Nightgazer · 10/01/08, 3:40 PM

Build 9014: SV talent Surefooted no longer offers +hit. That has been moved to Focused Aim in MM tree.

I didn't see this change in your v73 notes. Sorry if this is redundant.

Shandara · 10/01/08, 6:20 PM

Originally Posted by Nightgazer

Build 9014: SV talent Surefooted no longer offers +hit. That has been moved to Focused Aim in MM tree.

I didn't see this change in your v73 notes. Sorry if this is redundant.

This change is in the change log.

Small update:

- Aimed Shot is now instant and no longer clips Auto Shot
- Readiness now doesn't require a selection, works on both abilities a the same time

Chul · 10/01/08, 7:45 PM

Originally Posted by Shandara

On the subject of Scorch and Winter's Chill, what of our shots are affected by this? Same goes for our pets.

Yeah, I was thinking more for pets specials. I see no reason why they shouldn't benefit from the +10% crit debuff.

EDIT:
Aimed Shot's damage has been nerfed to about 25% of its previous value. Check the added damage in Wowhead.

huntcaudata · 10/02/08, 12:57 PM

I have a picky but simple request. On the "Settings and Results" tab, I'd expect to see the results of all the inputs. It gives me the most basic one in DPS, but then it also provides, health, mana, resilience, armor, dodge (all things I really don't care much about, but some might), but it doesn't list things everyone cares about like AP, Armor Pen, Agility. Could you show some of those, so we can compare builds that we've saved in different profiles without cycling through, loading, and moving to the separate tabs?

Also, the one thing in the "Hunter Basic Statistics" box at the top, hit and crit are listed. It would be helpful if these were listed below with the saved profiles, also for comparison's sake.

Roywyn · 10/02/08, 1:39 PM

Originally Posted by Chul

Yeah, I was thinking more for pets specials. I see no reason why they shouldn't benefit from the +10% crit debuff.

Most pet specials are still attacks, so they shouldn't be affected. Neither should your shots.
It doesn't matter whether it's magic damage or not.
Death Knights have 2 melee attacks that deal magic damage but still work just like normal attacks, not like spells.

Things like Lightning Breath should be spells and be affected by the +10% spell crit and Moonkin Aura, but not Leader of the Pack.
Things like Bite should work like attacks.

It's a spell if it has a 17% resist rate, cannot be dodged/parried, (usually cannot be cast while silenced) and goes with spell hit / crit mechanics.

Thorinson · 10/02/08, 3:45 PM

I've got two feature requests:

The Talents tab already indicates you've got an invalid tree when you forget to include a prerequisite talent. I'd like it to check on the right amount of talent points in lower level tiers as well. (At least 5 points in tier 1, if you put points in tier 2, etc.)

On long fights a hunter will probably switch between AotH and AotV repeatedly. If that's so, talents like invigoration and efficiency will affect long term dps: longer in AotH and shorter in AotV. In order to compare the long term dps of different talent builds (with this in mind), I'd like it to show the average dps of one AotH/AotV cycle. Perhaps its best to make it optional or additional to the current way, for people who couldn't care less or who can stay in AotH for long fights.

Chul · 10/03/08, 5:06 AM

Given that Bestial Wrath, Rapid Fire and Readiness are on the GCD, should we add them to the shot rotation table since they will consume GCDs? There is a selection for the GCD near the ability but it is protected.

Also, Blood Fury is on the GCD by the looks of it, so that will probably need to go there too

Midnight · 10/03/08, 6:21 AM

The weapon enchant Greater Savagery only gives 85 AP not 90 AP.

edit:
Typo with Perfect Steady Dark Jade and Perfect Steady Dark Jade where it says Pefect instead of Perfect. Also the Perfect Wicked Huge Citrine seems to be missing completely.
Not necessarily a bug, but more of a suggestion: For metagem slots would it be possible to only show metagems that fit into the slot, not the "normal" gems?
edit2:
Nerubian Leg Armor only gives 55 AP and 15 crit not 60 AP and 15 crit

Shandara · 10/03/08, 7:21 AM

Update:

- Some corrections to gems and enchants
- Aimed Shot now has the new +damage values
- the Settings and Result tab now shows AP/Crit/Hit and ArPen values of the saved profile (you'll have to re-save any existing profile for these values to be filled in properly)
- You can now select Rapid Fire, Bestial Wrath and your Racial (if applicable) in the shot priority queue

Nandei · 10/03/08, 7:32 AM

Gear -tab is missing from 73b at the moment, I can only see Gear planner and custom gear there.

Shandara · 10/03/08, 7:36 AM

Originally Posted by Nandei

Gear -tab is missing from 73b at the moment, I can only see Gear planner and custom gear there.

It's just hidden, you can make it visible from the VB window or download it again (I've re-uploaded the same version but with the Gear Tab visible).

EDIT:
After the comments previously about pet specials going off faster than the GCD of 1,5 seconds, I've been running a series of tests on it.

Using /combatlog I've been gathering data on both talented (i.e. Serpent's Swiftness) and untalented times between claws.

I'm a bit hampered by the fact that Focus regeneration is insufficient even with 2/2 Bestial Discipline and I'm hampered by the fact that Go for the Throat is streaky. Maybe my crit rate is too low to really keep it up.

Also, the combat log is naturally inaccurate. I'm hoping that sufficiently large amounts of data will smooth it out.

That said, with AotV, I could sustain fairly long bouts of spamming Steady Shot to keep my pet's focus up.

I wrote a little macro to sift through the combatlog in Excel and determine the average time between casts. When importing wow combat logs in Excel, be sure to use spaces, semicolons and colons as delimiters, since Excel was being picky about me using it's timestamps directly, so I had to split them up.

Sub CheckClaws()
    Dim LastClaw, AvgTime, TotalTime, CountClaw As Integer
     
    Application.Calculation = xlCalculationManual
    
    CountClaw = 0
    TotalTime = 0
    AvgTime = 0
    LastClaw = 0
    
    'run through all the rows
    For i = 1 To 65000
        If Cells(i, 5) = "SPELL_DAMAGE" And Cells(i, 13) = "Claw" Then
            Dim NewTime As Double
                        
            NewTime = Cells(i, 3) * 60 + Cells(i, 4) / 1000
                      
            CountClaw = CountClaw + 1
            
            If CountClaw = 1 Then
                AvgTime = 0
            Else
                AvgTime = NewTime - LastClaw
            End If
            
            TotalTime = TotalTime + AvgTime
                        
            LastClaw = NewTime
            
        End If
    Next
    
    MsgBox "Average Time: " & (TotalTime / CountClaw)
    
    Application.Calculation = xlCalculationAutomatic
    
End Sub

I ran both untalented and talented a number of times.

Talented (with 5/5/ SS) the average time between Claws fluctuates between 1.1 and 1.2 seconds.
Untalented it was between 1.35s and 1.45s.

It would point to a possibility that Serpent's Swiftness affects pet GCD, but we probably need more tests.

Cranch · 10/03/08, 4:36 PM

I don't know VB, but there appear to be a couple of bugs in your function.

Assuming Cells(i,3) is integral seconds and Cells(i,4) integral milliseconds, the seconds value will wrap back to 0 every minute. So you want to add an additional test: if (AvgTime < 0) AvgTime = AvgTime + 60 . That's a bit of an hack as it does assume the time between claws is no longer than 30 seconds.

The other possible bug is that AvgTime and TotalTime are declared as Integer and not Double.

Shandara · 10/03/08, 4:54 PM

Originally Posted by Cranch

I don't know VB, but there appear to be a couple of bugs in your function.

Assuming Cells(i,3) is integral seconds and Cells(i,4) integral milliseconds, the seconds value will wrap back to 0 every minute. So you want to add an additional test: if (AvgTime < 0) AvgTime = AvgTime + 60 . That's a bit of an hack as it does assume the time between claws is no longer than 30 seconds.

The other possible bug is that AvgTime and TotalTime are declared as Integer and not Double.

I know about the wrapping, but Cells(i,3) is integral _minutes_ and Cells(i,4) is milliseconds (hence I divide it by 1000 to get the seconds).

It may seem as if I declare all variables as Integers, but in fact Excel requires you to put 'As Integer' behind every variable name. So TotalTime is in fact a Variant variable (undeclared). I only declared CountClaw as Integer to make it easier to read.

Chul · 10/03/08, 6:16 PM

Removing Rapid Fire and Bestial Wrath (or Beast Within) from the Shot Rotation table doesn't stop their modifiers from being used in calculations.

Originally Posted by Shandara

I know about the wrapping, but Cells(i,3) is integral _minutes_ and Cells(i,4) is milliseconds (hence I divide it by 1000 to get the seconds).

Maybe the combatlog for EU is different, but for me using the US client, it is minutes and seconds, not miliseconds, so I had to remove the /1000.

I then used your macro when some modifications (I printed the max claw time for reference, and the number of claws to see if it matched the spreadsheet. I also hardcoded my pet name in as part of the check since the number of claws was higher then expected). The macro printed 1.21s average and 1.6s highest when I had no haste talents like Serp Swiftness and Cobra Reflexes.

Since a new build is being pushed onto the PTR, I'll redo the testing.

EDIT:

There is also a bug in your calculations since if there are two claws, you only want to divide the total time by 1 since you've only got one duration.

Here is the macro code I used which accurately matched the numbers from my spreadsheet when doing it by hand (which is now 1.25s, or what I reported earlier):

NOTE: I've hardcoded my pet name in there to stop other Claws from being counted.

Sub CheckClaws()
    Dim LastClaw, AvgTime, TotalTime, CountClaw, MaxTime, Row As Integer
     
    Application.Calculation = xlCalculationManual
    
    CountClaw = 0
    TotalTime = 0
    AvgTime = 0
    LastClaw = 0
    MaxTime = 0
    MaxTimeRow = 0
    
    'run through all the rows
    For i = 1 To 65000
        If Cells(i, 5) = "SPELL_DAMAGE" And Cells(i, 7) = "Fang" And Cells(i, 13) = "Claw" Then
            Dim NewTime As Double
                        
            NewTime = Cells(i, 3) * 60 + Cells(i, 4)
                      
            CountClaw = CountClaw + 1
            
            If CountClaw = 1 Then
                AvgTime = 0
            Else
                AvgTime = NewTime - LastClaw
            End If
            
            If AvgTime > MaxTime Then
                MaxTime = AvgTime
                MaxTimeRow = i
            End If
            
            TotalTime = TotalTime + AvgTime
                        
            LastClaw = NewTime
            
        End If
    Next
    
    MsgBox "Average Time: " & (TotalTime / (CountClaw - 1)) & Chr(13) & "Max Time: " & MaxTime & " (" & MaxTimeRow & ")" & Chr(13) & "Number of Claws: " & CountClaw
    
    
    Application.Calculation = xlCalculationAutomatic
    
End Sub

EDIT 2:
Just tested on the PTR and got 1.25s again using this temp build and about the same when using full talents.

samfisher · 10/04/08, 12:52 AM

Hmm, I'm getting an error when I try to click the CalcAttributes button on the Gear tab. Scanning from the Armory gives some slots #N/A. Here are the screenshots, might help. Something about run-time error 13.

Error Message

Debug Text