WotLK DPS spreadsheet - Page 69

Shandara · 12/22/08, 6:11 PM

Originally Posted by Fishhead88

I'm looking at the math for how Aspect of the Viper uptime is calculated. It looks like the mana gain from a potion is averaged along the length of the boss fight (C46, Shot Rotation tab. It's possibly a holdover from when potions could be chain-chugged?)

I noticed this because Viper Uptime has such a huge affect on DPS output. I also wondered if this entire calculation is stable for different bossfight lengths. Ie, are multiples of "Time to OOM" particularly advantageous because they happen to use exactly the minimum amount of Viper? I wonder if there is a better way of calculating Viper Uptime; maybe eliminating this "Regen from Mana Potion" and drinking once when you drop below a certain mana threshold.

The longer a fight, the less effect a potion will have. (precisely because you can't chain-chug anymore). Thus I average the effect over the duration of the whole fight.

Any ability or item that restores mana is in effect a specific amount of Mana per Second you gain, measured over the length over the fight. Mana potions are special in that they can only be used once, hence the value diminishes on longer fights.

Thayer · 12/22/08, 7:08 PM

I am trying to use the spreadsheet (v81a) and I noticed something when I changed specs from MM to SV to BM.

when I was changing specs, I was also looking at the rotation tab, and even after hitting test rotation, it was not changing my rotation based on the shot available to me.

So if I was BM, it was showing chimera shot in my rotation, etc.

This seem rather peculiar to me, as I think it might be effecting the numeric returns I get. Am I supposed to change something somewhere else in order to get the rotation to change to the appropriate shots for the spec?

Iru · 12/22/08, 8:04 PM

Yes, change the shot rotation tab appropiately. Put your fill shot (SS usually) last

Thayer · 12/22/08, 11:32 PM

Took me a while to get it in the right order so I didn't get errors. I am sure this is something a lot of people who use the spreadsheet don't know about that aspect of the spreadsheet.

There needs to be an option to save rotation orders, just like spec, so it is easy to switch specs as well as rotations.

You could possibly have an auto fill option that put the shots available to the each spec as talents are selected to simplify this aspect of the spreadsheet.

TrevvyTrev · 12/23/08, 8:20 AM

Originally Posted by Shandara

As for Wolverine Bite, others have reported it but I haven't looked into it yet. Is it on the pet GCD? If so then that's probably the reason it reduces DPS. Coupled with the fact that the calculations might be not correct.

I can't confirm that it's on the pet GCD, but that wouldn't lower the dps if the calculations are correct. In my testing (with a chimera), Wolverine Bite does more damage than Bite/Claw/Smack and the cunning family specials. At worst it's replacing a lower damage attack with a higher damage one, which should still be a dps increase. Maybe the sheet isn't scaling it with PAP?

Iru · 12/23/08, 2:02 PM

Originally Posted by Thayer

Took me a while to get it in the right order so I didn't get errors. I am sure this is something a lot of people who use the spreadsheet don't know about that aspect of the spreadsheet.

There needs to be an option to save rotation orders, just like spec, so it is easy to switch specs as well as rotations.

You could possibly have an auto fill option that put the shots available to the each spec as talents are selected to simplify this aspect of the spreadsheet.

The spreadhseet already saves your shot rotation when you click on 'save profile' on the gear page. I use the profiles mechanism to consider different build options. Load my default gear & talent tree from the amory, save that as one profile, select a new profile from the drop-down on the gear tab, make any talent changes etc and save again. Then when I want to compare between the two just load the relevant profile and fiddle appropriately.

I will let shandara comment on the idea of a default shot rotation associated with the use of a 51pt talent.

Rammbo · 12/23/08, 2:07 PM

This may have been answered once (or more) before, but over the most recent few pages it has not:

How do I get the naxx-25 ranged weapons to appear in the gear planner for ranged weapons? It's quite obvious which weapons are the best, but out of complete curiosity I was wondering how much more dps [Arrowsong] (my current equip) is than the lesser weapons, as well as the increase that KT's gun (my future weapon *cross fingers*) would give.

Thanks in advance for the help, and CONGRATS on this amazing spreadsheet, it has helped me gear up so much faster and effectively than constantly researching wowhead etc etc etc.

Samba · 12/23/08, 3:13 PM

Also may have missed this but assuming i have 100% hit from gear (no focused aim) and then I select the option to assume 100% hit wouldnt the gear planner change? removing gear with +hit on it for better itemised equipment?

This is not happening for me. Basically when I change assume 100% hit to yes and resort i get no changes with the current version (81a)

I am Samba on Gnomeregan if you'd like to verify stats/gear

*edit* Ok I just read a post 1 page back having the same issue but that particular person had 3/3 focused aim, so more hit on gear would in fact be a DPS increase due to pet hit scaling. I however am hit capped from gear and have 0/3 focused aim, yet the results do not change.

Cynddl · 12/23/08, 7:28 PM

Hello everyone. This is my first time posting, though I am an avid reader. There's something that's somewhat bothering me, however, and I can't quite dig up an answer for it. Shandara's spreadsheet is showing me that dual-wielding 2x Major Intellect (or Exceptional Intellect) is pretty much the best enchant I can get for 1-handers. It boggles me that the +26agi and Accuracy enchants are providing less DPS than +45 intellect. Has anyone else noticed this, or am I missing something? Below is a link to my armory.

The World of Warcraft Armory

noglen · 12/23/08, 7:44 PM

You most likely don't have any buffs selected, which means your mana regen will be non-existant, hence your viper time will be quite large and so the larger mana pool from the Int makes a big difference.

Fully raid buffed, Mana won't be a problem anymore, so the value of the int buffs will be alot lower.

Cynddl · 12/23/08, 7:57 PM

I have Shandara's pre-built Level 80 Raid buffs all loaded, so that's not the issue. Have you not noticed this?

Cranch · 12/23/08, 8:08 PM

Originally Posted by Cynddl

Hello everyone. This is my first time posting, though I am an avid reader. There's something that's somewhat bothering me, however, and I can't quite dig up an answer for it. Shandara's spreadsheet is showing me that dual-wielding 2x Major Intellect (or Exceptional Intellect) is pretty much the best enchant I can get for 1-handers. It boggles me that the +26agi and Accuracy enchants are providing less DPS than +45 intellect. Has anyone else noticed this, or am I missing something? Below is a link to my armory.

The World of Warcraft Armory

Int gives you AP through the talent, and also can increase your effective dps over a full fight cycle by giving more mana (so fewer aspects of the viper are needed.) As far as I know, there is no 1H 45 int enchant (yet.)

ankah · 12/24/08, 6:05 AM

Hi.

First off, I would like to thank every one that is involved with the spreadsheet, in particular Shandara.

I am a MM hunter, trying to deal with viper uptime, or better yet, trying to find ways to reduce it as much as possible. With this principle in mind, I am really looking into the cunning family of pets, and I will be doing some tests in the next few days in regards to feeding frenzy and roar of recovery.

Before i get started, I would like to confirm that with the latest version of the spreadsheet, no longer do we have the option to change the health % of bosses, and that there is no way to factor in applications of roar of recovery, since there is no change to viper uptime on the Aspect Usage box under shot rotation.

It would not be a simple "take 30% of the viper uptime, add to hawk" since that extra time spent in AofH will trigger additional ImpAofH, further influenced by possible gylphs.

If this has been talked about before, some one please point me to the right direction, I could not find it.

Shandara · 12/24/08, 6:38 AM

You can find most settings on the "Settings" tab, including boss health percentage.

EDIT:
The next release will have Roar of Recovery and Wolverine Bite scaling with pet AP (anyone has any numbers on this, it has proven difficult to test accurately).

snail · 12/24/08, 8:33 AM

Originally Posted by Samba

Also may have missed this but assuming i have 100% hit from gear (no focused aim) and then I select the option to assume 100% hit wouldnt the gear planner change? removing gear with +hit on it for better itemised equipment?

This is not happening for me. Basically when I change assume 100% hit to yes and resort i get no changes with the current version (81a)

I am Samba on Gnomeregan if you'd like to verify stats/gear

*edit* Ok I just read a post 1 page back having the same issue but that particular person had 3/3 focused aim, so more hit on gear would in fact be a DPS increase due to pet hit scaling. I however am hit capped from gear and have 0/3 focused aim, yet the results do not change.

Someone can correct me if I'm wrong but the 100% assumes 8% hit on the hunter while pets require 9% hit to be capped.