WotLK DPS spreadsheet - Page 22

veyn · 10/13/08, 9:57 AM

The Cobra Reflexes calculation (Pet Calculations!F9) references wrong cell for tenacity pets (Pet!K3 instead of Pet!M3).
Also, in IAotH calculation, shouldn't formula for shots in initial proc (Calculations!N87) be (IAotHDuration-IAotHBaseSpeed)/IAotHShotSpeed + 1 instead of (IAotHDuration-IAotHBaseSpeed)/IAotHBaseSpeed + 1?

Miya Mirage · 10/13/08, 10:12 AM

Did you change something about Pet calculations in general? Comparing last version and this version my pet lost 50 dps on autoattack, 20 dps on claw and 20 dps on rake.

messcaline · 10/13/08, 10:13 AM

Unlucky me... Unfortunatelly Office 2008 for Mac has VBA removed :-(
Numbers from iWork of course doesn't have VBA ;-) so as far as I found it's possible to use Automator or ActionScripts instead VBA for Numbers...
Do you have some IM? Maybe I'll be able to simulate something like this xls spreadsheet...

Shandara · 10/13/08, 10:13 AM

Originally Posted by veyn

The Cobra Reflexes calculation (Pet Calculations!F9) references wrong cell for tenacity pets (Pet!K3 instead of Pet!M3).
Also, in IAotH calculation, shouldn't formula for shots in initial proc (Calculations!N87) be (IAotHDuration-IAotHBaseSpeed)/IAotHShotSpeed + 1 instead of (IAotHDuration-IAotHBaseSpeed)/IAotHBaseSpeed + 1?

Yes, it shouldn't count the initial shot that procc'ed it but that's fired at the pre-hasted speed and the amount of further shots in the initial proc is determined by the hasted speed.

I won't pretend to understand the calculations that follow though.

@Miya:
I did toy with the buff profiles a bit because I worked on saving profiles so it might have a different buff set than the last version. So if that's not it might be something unintended.
EDIT: After checking V73f and V74 and equalizing the buff profiles my pets did nearly the same dps in both (I made some fixes to some trinkets I had equipped in my gear set which made up for the differences).

Miya Mirage · 10/13/08, 10:29 AM

Ah yes, I thought when exporting, it does include the Buff Profiles I made for our raid setup. Should've thought of it myself.

A second thing that did have a small influence on hunter dps actually was the fight length and the viper settings. All things I thought to be included in the export file. Now that I know, I shouldn't bring up things like that again.

Shandara · 10/13/08, 10:38 AM

Originally Posted by Miya Mirage

Ah yes, I thought when exporting, it does include the Buff Profiles I made for our raid setup. Should've thought of it myself.

A second thing that did have a small influence on hunter dps actually was the fight length and the viper settings. All things I thought to be included in the export file. Now that I know, I shouldn't bring up things like that again.

It should export the buff profiles properly, but it usually breaks when I add/remove a buff from the available ones since I don't provide conversion from version to version if I do change them.

As for the AotV settings, I hadn't added them to the exporting yet. The sheet is quite beta in the user-friendly department, sorry. Once things settle down in WotLK I'll probably find some time (if I'm not busy leveling) to organise these things.

EDIT:
Things I'm currently not saving in profiles:

AotV settings (Shot Rotation tab)
Default Gem Choices (Settings and Results)
Gathering Skill (Settings and Results)
Control Settings (Settings and Results) - exception Custom Target level/armor
Filename to Export to (obviously)
Player name/realm/server set
Target selected
Gear Planner selections
Custom Gear
Sniper Training range selector (Talents tab)
Boss fight length settings (Shot Rotation)
Boss HP % selector
Latency
Misc settings on the calculations page (Lock&Load modifiers, etc..)
Pet GCD (Pet tab)
Pet Level/Happiness

I think that's all of it. Most of these things are pretty much static in between comparisons.

Miya Mirage · 10/13/08, 10:45 AM

That's fine, I'm just fighting a flu so I'm not 100% concentrated and things like these slip by.

The thing with the AotV Setting was that switching from Viper-Regen to Viper-oom led to 1 AP more being transferred to the pet in the pet calculations tab somehow and it changed the numbers slightly (less than 1 dps but I noticed it when comparing after equalizing the buffs).

I for one am happy with the functionality in the spreadsheet already, so don't worry about small things like that. 99% transferabilty from version to version is superb enough for me! I'll happily check the Buffs and Shot Rotation Tab from now on (if I get rid of that stupid flu at least).

Chul · 10/13/08, 6:18 PM

If you have 2 or more points in Longevity, Rake will only tick twice, not three times.

Shandara · 10/14/08, 6:22 AM

Originally Posted by Chul

If you have 2 or more points in Longevity, Rake will only tick twice, not three times.

Cheers. I had the day off so I spent some time reorganising the UI and moving stuff around. I've moved all the 'options' for various things (spells, range checks, etc..) to a separate tab and only left the really specific toggles where they were (e.g. Latency on the Shot Rotation tab).

I've also cleaned up the Settings and Results tab and moved most of the informational windows there. No doubt this will break stuff (although I didn't get many errors myself and I fixed those), so let me know.

It should also save ALL the custom settings with each profile now. There's an option to override them on the 'Settings' tab in which case it will use predetermined defaults for all of them. The defaults are also used if you don't specify a custom setting for an option.

- Cobra Reflexes now references the correct cell for Tenacity Pets
- Small fix to IAotH
- Redesigned UI, moved all custom settings to a separate tab. Cleaned up the Settings and Results tab
- All custom settings will now save with the profile (and export); existing exports won't load correctly (hopefully the last time I have to make changes)
- Rake will only tick 2 times if you have 2 or more talent points in Longevity
- Fixed a bug with the Gear planner involving +hit and trinkets

Stealth update:

- Rapid Killing 1/2 leads to a Rapid Fire downtime of 127,5 seconds with Readiness; 0/2 leads to a 157,5 cooldown
- You can now name talent specs and these names are exported/imported properly

veyn · 10/14/08, 8:01 AM

Small correction regarding Readiness and Rapid Killing. When you put 1 point into Rapid Killing, you consider Rapid Fire cd to be equal to 180 sec - which (I assume) means you reset Rapid Fire cd immediately when Readiness becomes available. If you would wait for RF cd to end naturally instead, and you'd have 2 RF's every (240+15) sec, which leads to greater uptime (effective cd of 127.5 sec).

edit: In fact, even if you spend 0 points in Rapid Killing, waiting for natural cd of RF leads to effective cd of 157.5 sec, as opposed to resetting RF cd with Readiness immediately (180 sec cd).

Devastor · 10/14/08, 12:46 PM

No doubt this will break stuff (although I didn't get many errors myself and I fixed those), so let me know.

i'm confused again, using 74b.

Longevity:

1/3: Me +1DPS | Pet +15dps
2/3: Me +4DPS | Pet -13DPS !!!
3/3: Me +2DPS | Pet +50DPS

this seems strange to me.
I understand, that with different CDs, Buffs "collide" in a better/worse way (Like +AP trinket and BW/TBW...)
But the "jumps" are really strange.

From 1/3 to 2/3 points actually decreases Pet-DPS by 13DPS, or in other words: 2/3 is +2 Pet-dps vs 0/3
And then the abnormal jump from 2/3 to 3/3...

Shandara · 10/14/08, 12:52 PM

Originally Posted by Devastor

i'm confused again, using 74b.

Longevity:

1/3: Me +1DPS | Pet +15dps
2/3: Me +4DPS | Pet -13DPS !!!
3/3: Me +2DPS | Pet +50DPS

this seems strange to me.
I understand, that with different CDs, Buffs "collide" in a better/worse way (Like +AP trinket and BW/TBW...)
But the "jumps" are really strange.

From 1/3 to 2/3 points actually decreases Pet-DPS by 13DPS, or in other words: 2/3 is +2 Pet-dps vs 0/3
And then the abnormal jump from 2/3 to 3/3...

It has to do with Rake. With Longevity at 2/3 or 3/3 you miss the last tick because it's refreshed before it ticks for the 3rd time.

I could offer a big explanation, but after looking at the code it's not quite what I want it do. I'll re-do it for the next release.

Devastor · 10/14/08, 1:09 PM

Thanks a lot

Shandara · 10/14/08, 1:47 PM

Originally Posted by Devastor

Thanks a lot

The calculation in the sheet as it is now is correct, it's just a bit kludgy. The results won't change.

It comes from the fact that Rake ticks 3 times. Every 3 seconds for 9 seconds. Now if you have 2/3 or 3/3 Longevity (i.e. 8 or 7 sec cooldown) you'll cut off the last part of the Rake DoT.

In case of the 2/3 and coupled with pet GCD you waste nearly a whole tick (at a 1.25 sec pet GCD Rake will fire in ideal situations every 8.75 seconds). You'd have gotten the 3rd tick at 9 seconds so you waste 2.75 seconds of time. This is what leads to the dps LOSS.

In case of 3/3 Longevity it's the same, but with a 7 sec cooldown you waste less time. But, at the same time you get an added benefit from the reduced CD on Bestial Wrath/Rapid Fire, because of how the cooldowns line up. This leads to the substantial DPS boost.

This is all in theory and in the sheet of course. Testing will have to determine whether or not it's close enough to the truth.

Littlehelper · 10/14/08, 3:24 PM

I was looking through some of the Formula, because Hit did increase my dps as Surv despite being above the hitcap.

So I found some questionable calculations.. the Explosion Shot's average dmg is decreased as if it would have a 17% extra Misschance.(Calculations.K103) Does ES really have a 17% base-miss-chance?
Also there is a 5,14% reduction due to partial resists and I always assumed partials resist only happen due to magic resistance, which should be decreased by curse of elements. So shouldn't that be 0%?

And I found similiar weird behavior in the pet calculations.C69, where the partial resist is decreased by Animal Handler and Pet/Hunter Hitrating.

And as long as I am not misinterunderstanding shouldn't Wolverine Bite's Total Damage(Pet Calculations.C140) be C132*C138*(1-C139)?