WotLK DPS spreadsheet - Page 97

Chul · 01/27/09, 5:15 PM

Originally Posted by shermanc

I've decided to try using the spreadsheet again.

I've loaded my gear from the armory, my talents, my glyphs, and change my pet spec.
I've added my gathering prof mining buff.
I've removed all raid buffs, set it to none.
However, I saw a descrepancy of 2% crit and do not understand why. I'm basing this from what I'm seeing in the armoury.
I notice that my agi, stam, crit rating, haste rating on the spreadsheet matches the armoury.
However, there is an ap difference which i thought to be caused by aspect of the hawk. So i went to Settings and set the custom value to 0. (I'm unsure if there's a SAVE SETTING button that I can use). I don't see any change in my ap.

Anyway, I would like a few suggestions of what may have cause that crit % difference.

I'm not being anal about it, but i thought I can only make accurate judgments in using the spreadsheet when everything falls into place.

Thanks for any help.

A few things:

The spreadsheet is setup by default to assume all the trinket/talent averages that you would get during a fight. If you want to ignore them to get a 'tooltip' or 'character sheet' value, then under settings tab set 'Disable Averaging' to 'Yes'
If you want to turn off Aspects like Dragonhawk, do it under the Shot Rotation tab
Master Tactician and Crit Depression fields don't turn off/get disabled when disabling average, which is a spreadsheet bug which leads to an extra ~1% crit.

I imported your gear and spec, turned off Aspect of Hawk/Dragonhawk, disabled averages, then if you consider a fixed spreadsheet where Master Tacticition and Crit depression is zero, then you get pretty close to your armoury values.

Note: Not sure if Shandara has updated all the base stats for races yet, so you may want to compare what the spreadsheet thinks and your character pane thinks.

alienangel · 01/27/09, 11:55 PM

Apologies if I'm missing something obvious, but what is the "Yes" option for replenishment doing? I'm seeing some strange behaviour with it, viz. at 100% or 50% uptime setting it to "No" while having 2/3 EW and 1/5 in Hunting party raises my dps over a hundred DPS higher than if I have it set to "Yes" with 0 points in HP an 3/3 EW.

Setting it to "yes" and then changing the Uptime% also has counterintuitive results (0% uptime drops dps, but putting 1 point into HP has no effect on dps).

This is in Viper to OOM mode, for a 4 minute fight - I was trying to work out whether full EW is worth it in a raid without any replenishment other than my 1/5 HP.

This seems vaguely familiar, so did search the past 8 pages or so for "replenishment", but I can't seem to find anything :S

Chul · 01/28/09, 1:21 AM

If you select 'Yes' to Replenishment, then it takes that uptime value and ignores any points you have in Hunting Party.
I think Hunting Party and Replenishment buff should work in tandem with each other, not overwrite.

alienangel · 01/28/09, 3:18 AM

Ah, that would explain it, thanks!

Iru · 01/28/09, 4:42 AM

Originally Posted by Chul

If you select 'Yes' to Replenishment, then it takes that uptime value and ignores any points you have in Hunting Party.
I think Hunting Party and Replenishment buff should work in tandem with each other, not overwrite.

I don't think that the two buffs stack, so the spreadsheet is preferring Replenishment to Hunting Party as it's easier to keep up.

Naneless · 01/28/09, 6:56 AM

It says the sheet is protected, and I have to 'unprotect' it, but it needs a password. What is the password?

Zeel · 01/28/09, 7:01 AM

Originally Posted by Naneless

It says the sheet is protected, and I have to 'unprotect' it, but it needs a password. What is the password?

You can change all the fields that need to be changed in order to make the spreadsheet work.
Some fields are protected to ensure that spreadsheet if working as intended.

Naneless · 01/28/09, 2:25 PM

But I can't even "Load Gear from Armory", nor import or export my character, nothing is working

Garby · 01/28/09, 2:28 PM

Originally Posted by Naneless

But I can't even "Load Gear from Armory", nor import or export my character, nothing is working

Do you have macros enabled?

Harrumph · 01/28/09, 2:40 PM

Originally Posted by Iru

I don't think that the two buffs stack, so the spreadsheet is preferring Replenishment to Hunting Party as it's easier to keep up.

It's not two buffs, it's the same buff. Or more accurately perhaps: Hunting Party is not a buff, it is a talent that grants the Replenishment buff on crits. Replenishment can be given by 3 different classes and the talents are all called different things, so I don't blame people for being confused about this (I know I was at first).

Naneless · 01/28/09, 3:29 PM

Originally Posted by Garby

Do you have macros enabled?

No, nothing. Just downloaded the excel file and it is like this

Shandara · 01/28/09, 4:26 PM

Update:

- Fixed spelling on Vengance Shiv and Ritualistic Athame
- Added Anvil of Titans
- Fixed Tuskar's Vitality feet enchant
- corrected stats on arena gear and spelling on epic honor belt
- added Deadly Gladiator's Waraxe
- Hyperspeed Accelerators now have a 60s cooldown
- Shot Rotation priority queue now discounts invalid rotations (using Explosive/Arcane at the same time or Multi-Shot/Aimed Shot)
- Added Oracles/Frenzyheart trinkets
- Corrected ArP->Res on Savage Gladiator's Chain Spaulders
- Frog-Toe Band spelling fixed
- Fixed a bug with Glyph of Serpent Sting still providing +3s duration instead of +6s
- Added code for Mixology. So far only Flask of Endless rage numbers verified.
- Updated stats on Savage Cobalt Slicer
- Shot Rotation Test now uses IAotH properly
- Fixed some logic in the Shot Rotation test involving L&L
- Added Prismatic Sockets for gloves/bracers
- Added some more food options

I've tested the BS sockets with a few profiles I had, but please report if it gives any problems. You'll have to re-do your gear on import (because of the added sockets not being present in exported previous versions) but hopefully all your other settings should import properly.

The Mixology setting is present, but I could only find definite numbers for the flask of Endless Rage so far. If anyone has definite numbers on the improved version of other common elixirs/flasks I'll add them.

On the Shot Rotation Test tab I've made 2 changes. First when L&L procs Explosive Shot CD is reset immediatedly, in some cases before it wouldn't. Also it will now give a visual cue which Explosive Shots are because of L&L and which aren't.

EDIT:
One thing that might not be obvious right away is how to add BS sockets to an existing profile (rather than importing). Both gloves and wrist slots have an extra gem line now and you can change the socket type from 'no socket' to 'prismatic socket'. I'll have to work a bit on making this more user friendly for the next version but for now I'm already glad it works with the Armory.

jmlsteele · 01/28/09, 5:22 PM

[Corroded Saronite Woundbringer]
Change: 50 Hit Rating removed.

Kathris · 01/28/09, 5:51 PM

Socket Bonus on Chest not updating correctly. Socket Bonus always shows up as None regardless if you meet the color requirements.

Rezdan · 01/28/09, 9:15 PM

Originally Posted by Shandara

Update:
<snip>
On the Shot Rotation Test tab I've made 2 changes. First when L&L procs Explosive Shot CD is reset immediatedly, in some cases before it wouldn't. Also it will now give a visual cue which Explosive Shots are because of L&L and which aren't.
</snip>

Shandara, I don't believe that when L&L procs the Explosive Shot CD is reset. I've observed this on Live and currently Explosive Shot stays on cooldown if its used before an L&L proc. It is the *next* use of Explosive Shot that has no cooldown.

Example:
If you fire Explosive Shot at 0 seconds, it will only become available at 6 seconds regardless of whether or not LnL procced during the 6 second cooldown.