WotLK DPS spreadsheet - Page 81

Selmarix · 01/12/09, 5:16 AM

Originally Posted by Chul

Roar of Recovery isn't being used in Viper uptime calculations. Adding in the spell into the pet rotation adds its mana/s to the Mana Regen section, but the ManaRegenWithoutViper cell (not sure where that is, but it is referenced in Shot Rotation!C45) doesn't consider it so you don't get any DPS boost from less Viper time.

It is in Calculations!E32 and yes, Roar of Recovery in E26 is missing from that sum.

Shandara · 01/12/09, 5:45 AM

Originally Posted by Selmarix

It is in Calculations!E32 and yes, Roar of Recovery in E26 is missing from that sum.

Fixed next version. Had to make some changes or it would lead to (yet) another circular reference mess.

As for JoW, I couldn't find any data on possibly changed proc chances or internal cooldowns so I'll just stick with a 2% base mana change for now.

EDIT:

Update:

- Added Stamina to PAWN string
- JoW now restores 2% base mana
- Roar of Recovery now bases mana regen on the amount of times it can be used in a boss fight and is also used for Viper Uptime calculations
- Rabid and Roar of Recovery no longer use a pet GCD
- All Pet 'magic' abilities now scale with pet AP at 4,2875% (apart from those mentioned by Ghostcrawler as having a different coefficient). Pet physical damage abilities still scale with 7% of AP (excepting again those mentioned by GC)
- Alchemy Trinket +40% potion effect now implemented

Ravenfire · 01/12/09, 12:01 PM

Bug: While Roar of Recovery is being calculated correctly for actual mana returned, it is not turning off for cases with Ferocity/Tenacity pets and is thus screwing with proper mana regen rates and AotV up time. At the moment Roar of Recovery is calculated via a simple CIELING function (cell E120) and does not check to see if a cunning pet/appropriate talent point is selected.

There is also a pair of #REF! errors in the Thunderstomp calculation section.

Shandara · 01/12/09, 12:24 PM

Originally Posted by Ravenfire

Bug: While Roar of Recovery is being calculated correctly for actual mana returned, it is not turning off for cases with Ferocity/Tenacity pets and is thus screwing with proper mana regen rates and AotV up time. At the moment Roar of Recovery is calculated via a simple CIELING function (cell E120) and does not check to see if a cunning pet/appropriate talent point is selected.

There is also a pair of #REF! errors in the Thunderstomp calculation section.

Good catch. Made a quick fix and reuploaded.

Update:

- Fixed Thunderstomp #REF! errors
- Roar of Recovery only works for Cunning pets now

Seoman · 01/12/09, 12:55 PM

Minor item error:

Concealment Shoulderpads are Leather, but appear even when Leather is unchecked.

KergeKacsa · 01/12/09, 1:08 PM

Shandara, when will be LnL's new 30 sec inner CD implemented?

ankah · 01/12/09, 1:41 PM

I noticed how Mana Regen per Second, under the calculations tab has Hunting party, although it is not listed under hunter buffs. You also have a separate line for target debuffs. Is that Hunting Party mana regen a placeholder for another skill, or should it be listed under hunter buffs as well (the number does carry over to shot rotation)?

Shutruk · 01/12/09, 2:04 PM

I don't know if this has been reported yet, but when I read my gear from the armory, it doesn't pick up the "Darkmoon Card: Greatness", It just displays my "Bandit's Insignia" twice.

Guessing it has something to do with the same ID numbers on the Darkmoon Cards between Int, Agi, STR and Spirit?

Onouris · 01/12/09, 3:06 PM

Originally Posted by Rezdan

@Onouris
Is your Survival spec employing 3/3 Focused Aim? Also, what Pet are you testing with? Its quite tough to figure out what the problem is without having your actual spreadsheet setup to play around with.

Nah it isn't, and it's a Wind Serpent (it's close enough in DPS, seemingly without taking Roar of Recovery into account. So with the new changes which I'll download soon hopefully that'll push it over the edge).

Axejess · 01/12/09, 4:38 PM

Why is Journey's End the best 2hnd weapon? It's a druid weapon according to wowhead and thotbot.

dlanod · 01/12/09, 5:39 PM

Originally Posted by Axejess

Why is Journey's End the best 2hnd weapon? It's a druid weapon according to wowhead and thotbot.

All druid weapons are having their feral AP removed, DPS upped to normal stats, and most are having their strength converted into AP in 3.0.8. That makes a lot of them somewhere in between "good" and "excellent" for hunters.

Whitemane · 01/12/09, 9:41 PM

Originally Posted by Shutruk

I don't know if this has been reported yet, but when I read my gear from the armory, it doesn't pick up the "Darkmoon Card: Greatness", It just displays my "Bandit's Insignia" twice.

Guessing it has something to do with the same ID numbers on the Darkmoon Cards between Int, Agi, STR and Spirit?

I have the same thing - it reports that my Ring of Invincibility is an invalid trinket and then doesn't import Darkmoon Card: Greatness.

I didn't see in the latest version and I didn't see it mentioned in notes, but the spreadsheet counts aimed shot in the shot rotation if you select it in the shot rotation tab - even though you have not put a talent point into it and in effect, do not have it.

Chul · 01/12/09, 9:50 PM

- Roar of Recovery: This spell is taken into consideration regardless of whether it is in the pet rotation so long as the talent is selected so remove it from the selection list. And lastly, the calculated frequency of usage assumes a static 6 minute spell cooldown - a) shouldn't this be referenced like other pet spell data, and b) wouldn't longevity reduce this?

- Rabid: Not sure why Rapid is still in the list since it is off the GCD, but assuming it is selected and then you change pets to say cunning, it still gets the affect of Rabid.

I think all pet talent point checks must also check pet family for completeness.

akbinhil · 01/13/09, 12:30 AM

I know everyone hates them, but do we have an ETA for sporebat special damage for the spreadsheet? I'm leveling one right now, and was curious how they'd stack up against, say, raptors at high AP.

ankah · 01/13/09, 3:05 AM

Originally Posted by akbinhil

I know everyone hates them, but do we have an ETA for sporebat special damage for the spreadsheet? I'm leveling one right now, and was curious how they'd stack up against, say, raptors at high AP.

I ran some numbers by hand, and they didn't stack up all that well against ferocity pets, even with Roar of Recovery factored in. The difference was not huge, but significant. they did look more attractive if there is no armor debuffer around (well, a minor debuff, in this case), but at that point, you may be better off with a wasp. If RoR gets buffed, then they may became viable for MM hunters, otherwise, hug your kitty.

**edited**

the numbers for the spore cloud's dps is in the spread sheet, just not transferring over. Just check out the Pet calculation tab, and it will show the max dps and the actual dps, as long as you have the spore bat selected as pet, and have the skill on the rotation.

Few things to point out:

1. It did make it the number 1 pet for me (15/51/05, with 4 points into UF), in my case by 8dps.
2. The spore cloud's armor debuff is being calculated regardless of minor debuffs (calculations tab, armor penetration shows By Pet Debuffs of -630 armor), so it increases the pet's overall dps (in my case 18dps).
3. In short, it still did less than a cat/raptor (again, for me it was 10 dps less).