WotLK DPS spreadsheet - Page 6

Shandara · 08/28/08, 7:53 AM

Update:

- Sniper Training now increases damage of Aimed/Steady/Explosive by 2%/4%/6%
- Chimera Shot now deals nature damage (ignores armor and is improved by +nature damage debuffs), Improved SS now also affects the sting part of the damage
- Re-implemented Wild Quiver according to Ravenfire's calculations
- added some wotLK mined trinkets
- Glyph of Steady Shot only affects steady shot if there's Serpent Sting in your rotation now
- Pet Frenzy now differentiates between different critrates for specials and melee hits
- Dwarf level 80 has the correct wotLK beta stats, so use that to get a correct impression of mana costs/longevity

Chimera Shot ignoring armor and being boosted by +nature damage debuffs on the boss makes it gain the lead yet again. Or would have, depending on what sort of buffs you have. BM gets a huge boost out of having a MM hunter in the party and a SV hunter in the raid, but with Blizzard assuring us every class will have 2.5 raid slots, that's a bit problematic.

SV hunter raid damage seems a bit low to me, but we're not counting any raid benefits and that'd most likely make up the difference by a big margin.

I still don't have level 80 stats for most races (or level 71-79 for that matter) except dwarves.

Making myself into a dwarf the mana costs for abilities finally take real shape and we can make a more accurate judgement of longevity and sustainability.

From the Hunter WotLK thread I've set the JoW proc amount to about 250 per proc (since that was what a sunwell equipped paladin would get according to the poster). Real level 80 raid values will probably be higher, but only MM spec'ed hunters really have to worry about mana it seems, both BM and SV will probably have enough, even without using a potion.

Ebonleaf · 08/29/08, 10:59 AM

I've noticed that Animal Handler doesn't raise your overall dps when you put the 2nd point into it, but when you manually adjust your hit it does go up. And did our hit cap actually raise that much?

Shandara · 08/29/08, 11:37 AM

Originally Posted by Ebonleaf

I've noticed that Animal Handler doesn't raise your overall dps when you put the 2nd point into it, but when you manually adjust your hit it does go up. And did our hit cap actually raise that much?

We need roughly double the hit rating to get the same % (EDIT: at level 80 of course)

I'm assuming that hunter +hit is transferred to the pet at the moment, so the pet should be nearly hitcapped with or without animal handler. This is I was told was going to happen, I have no idea whether pet scaling is actually like that in beta at the moment.

Ebonleaf · 08/29/08, 12:19 PM

Yea, i'm in the beta and I can't tell for sure if thats the case. I guess i could log it when my pet is attacking and do a wws to see.

Shandara · 08/30/08, 1:15 PM

Update

- Lock and Load back to 5/10/15% proc chance off stings
- Hunter's Mark now only increases hunter RAP (and doesn't stack ) and Expose Weakness as well (i.e. no pet AP)
- Improved Hunter's Mark increases HM by 10/20/30%
- Trueshot Aura increases RAP by 10%, Glyph works now as well
- Trueshot Aura, Unleashed Rage and Abomination's Might are now mutually exclusive
- Combat Experience now increases agility by 3/6% instead of 1/2%
- Improved Arcane Shot now only 3 talent points and increases damage by 5/10/15%
- Added Rhino's Stampede ability (although it doesn't do anything DPS-wise, it's just selectable)
- Added new Glyphs
- Chimera Shot's sting proc effect now is affected separatedly by damage adjustments (crit + modifiers)
- Ferocious inspiration and Swift Retribution are now mutually exclusive
- Blood Pact and Commanding Shout are now mutually exclusive (no data on Blood Pact Health bonus though)
- Added Rank 7 Strength of Earth totem (assumed to be same as DK Horn of Winter with talents, i.e. 135 base, 155 talented)
- Changed Greater Blessing of Might +AP values to match battleshout
- Added new LW bracer enchants (stamina/AP)
- Improved Faerie Fire no longer increases +hit to target
- Curse of Elements and Earth and Moon no longer stack and both increase spell damage against targets by 13%. Earth and Moon no longer has stacks
- Cobra Strikes now only works if you have the talent
- Added Spiced Mammoth treats to pet snacks
- Winter's Chill and Improved Scorch buffs removed as they will increase spell crit against target instead of damage

Cranch · 08/30/08, 10:37 PM

Link's still giving v61 of the spreadsheet.

By the way, thanks for the fast update!!

*edit* ya, it was my browser cache as well (firefox.)

Shandara · 08/31/08, 2:40 AM

Originally Posted by Cranch

Link's still giving v61 of the spreadsheet.

By the way, thanks for the fast update!!

It should have the V62 now.

Edit: Or at least I re-uploaded the correct version but it's still giving me v61.. maybe some caching issue.
Edit2: Cleared my browser cache and it's updated now.

Stinkerbelle · 09/01/08, 1:39 AM

Thanks for taking on this task, Shandara. I'm not on beta, but am using the spreadsheet to try to find optimal raid talent choices at level 70 for when 3.0x goes live. (BM was way ahead on version 60, but on version 62 MM has pulled ahead by ~500 DPS.)

I realize the spreadsheet is now targeted at WOTLK, but during the weeks/months after 3.0, there is going to be keen interest among non-beta hunters about how to adjust to the new talents and mechanics. At the moment there are some parts of the spreadsheet that do not permit adjustment to level-70 spells or buffs. If you'd be willing to adjust those, I think people will find it very helpful once 3.0x goes live.

These are the cells I've noticed could not be adjusted to level 70 values:

Buffs/Debuffs
-Greater BoM: Rank 2 not available in drop-down menu
-Sunder Armor: Locked at level 80 values

Pet
-Spell ranks locked at level 80

You might even consider auto-limiting ranks based on character level, depending on how much work you want to give yourself(!)

************

Also, I'd love to be able to see how some of the weapon buffs should impact dps: weightstones, sharpening stones, and righteous weapon coating. I'm still not sure whether I'm better off with Shivering Felspine or a combination of one-handers.

Sympa · 09/01/08, 2:18 AM

Originally Posted by Stinkerbelle

Thanks for taking on this task, Shandara. I'm not on beta, but am using the spreadsheet to try to find optimal raid talent choices at level 70 for when 3.0x goes live. (BM was way ahead on version 60, but on version 62 MM has pulled ahead by ~500 DPS.)

I realize the spreadsheet is now targeted at WOTLK, but during the weeks/months after 3.0, there is going to be keen interest among non-beta hunters about how to adjust to the new talents and mechanics. At the moment there are some parts of the spreadsheet that do not permit adjustment to level-70 spells or buffs. If you'd be willing to adjust those, I think people will find it very helpful once 3.0x goes live.

These are the cells I've noticed could not be adjusted to level 70 values:

Buffs/Debuffs
-Greater BoM: Rank 2 not available in drop-down menu
-Sunder Armor: Locked at level 80 values

Pet
-Spell ranks locked at level 80

You might even consider auto-limiting ranks based on character level, depending on how much work you want to give yourself(!)

************

Also, I'd love to be able to see how some of the weapon buffs should impact dps: weightstones, sharpening stones, and righteous weapon coating. I'm still not sure whether I'm better off with Shivering Felspine or a combination of one-handers.

None of additions you've mentioned will matter in WoTLK. The entire point of the spreadsheet is to model a WoTLK raiding environment. IE it would be pointless to include the changes you have mentioned.

Stinkerbelle · 09/01/08, 3:28 AM

Originally Posted by Sympa

None of additions you've mentioned will matter in WoTLK.

I said this already, Sympa. However, there will be a significant time gap between 3.0 and WoTLK. During this time, not everyone will cease raiding. Hence your "pointless" comment is indeed.

Shandara · 09/01/08, 9:24 AM

I love lists.

Pet spell ranks should scale automatically on the level you select.
Greater Blessing of Might rank 3 is my fault, I'd been pruning the lower ranks (i.e. sub-70) out of the sheet and must've deleted it accidentally
Sunder Armor was just a quick hack to get the new value in, I'll redo that stuff when I find a moment

Small update:

- JoW now restores 2% of your total mana per hit
- Hunting Party now restores 0.5% total mana per second (it's assumed you get the buff every time at the moment)
- Explosive Shot now hits the initial target 3 times with the 'big' scaling (345 + 20% RAP)
- Death Knight's Anguish trinket now adds its stacking crit bonus to your actual crit rate
- Windfury Totem now has modifiers for the talent Improved Windfury Totem (improved works for ranged haste too, no?)
- Fixed Buff loading/saving
- Explosive Shot and Arcane Shot share CD
- Added level 70 ranks of Sunder Armor and Greater Blessing of Might

ragex · 09/01/08, 12:00 PM

does anyone have an older verion of the open office soread sheet

Shandara · 09/01/08, 12:51 PM

Originally Posted by ragex

does anyone have an older verion of the open office soread sheet

Open Office is not supported at the moment (fancy way of saying I don't have the time or inclination to adapt it). Once WotLK hits and the sheet is in a stable state I'm sure someone will step forward and adapt it.

You should be able to get the Open Office version of Cheeky's v49 from the old Spreadsheet thread.

EDIT:
After pondering the above discussion about level 70 raiding pre-WotLK, I should have the missing level 70 stuff in the next version again.

One really important bit of info I need though is pet base attack damage at level 80. I'm using the level 70 values at the moment (min 50 and max 70 damage) since I have no information on it.

That is the pet BASE melee attack damage (without modifiers or anything). Any comparison is a bit skewed since with the right talent spec the pet will do nearly the same amount of melee dps at level 70 as it will at 80 without the correct values.

Other pet stats are nice to have, but don't have such a big impact. I'd still like to know them though.

EDIT2:
I'm also missing level 80 armor calculations. I have not found any definite numbers on the scaling at level 80 yet.

EDIT3:
Small update:

- Trinkets can now have sockets and added the Emerald Boar trinket
- Profiles now save spell ranks used
- Profiles now save player level and target level and armor level
- Added new cooking items to buffs

ragex · 09/01/08, 7:25 PM

oh , i tottaly understand, im just after the OLDER version, someone must have an old copy for open office.

KraxisSingular · 09/02/08, 8:09 AM

Shandara, whenever I set my own talents and I pick Bestial Wrath the total DPS doesn't go up, The Beast Within does give a litmited value (as does the Bestial Wrath glyph). That makes BM DPS slow to a relative halt.

Also with that glyph what is the cooldown for Bestial Wrath set to? 64 or 70 seconds?