Icefall_ShC

Make sure your security options are set to medium.

But that error generally seems to happen when wowarmory is down or slow.

 

PSK21

Yea I forgot to add that my security setting is set to medium.

 

Shibam

It's working now. Thankfully it was the armory issue rather then a spreadsheet issue

 

◊ Lactose

Nope.

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

 

Sorrugis

Lactose, do you know if there are any plans to make the buttons for setting the premade Shot Rotations work in Open Office, anytime in the near future?

 

Lotharn

The spreadsheet (version 38) thinks that screech does a fixed amount of damage, regardless of the ac of the target. Thus, at about 7500 ac (setting target to Attuman), screech does more dps than claw does. I tried out screech versus claw on some mobs (not mobs I had ac values for, however) and the numbers make it seem that screech is reduced by armor as well. I need to do some more careful tests, but I was wondering if any other hunters could confirm or deny screech being reduced by the armor value of the target.

 

Iod

Not having much luck with the search feature and I didn't see anything in the changelog, so here goes:

Improved Faerie fire should affect the pet's melee attacks as well, correct? Given that the Pet Calculation tab is showing a 5% miss rate, the extra 3% to hit should increase the pet's dps. However, when toying with it my pet's dps doesn't budge an inch. Am I missing something here?

Looking at the 'Hit Chance' calculation box there isn't even a line referring to the Imp. FF debuff, was adding this planned for future releases?

 

Sienna

One question about the spreadsheets is haste proc uptimes and overlapping hastes not increasing dps. I know many people tried to approximate the haste uptime over the past year and even though approximations do work, they don't help at all with overlaps. I'm trying to find a general way to calculate the uptime of n many hastes, with overlaps etc, but it's not coming that fast, I'm actually taking a course right now that might help with the calculations next term. So you can expect a definite answer on those in 2008 at least from me.

 

Fleabite

Just a small point, noticed I have the option to add a 20 agility scroll to myself under the buffs option, however there seems to be no similar option for Pet (who i occasionally drop a str stroll on).

 

Alerien

Okay, after all my other thousand and one edits I think I know where your deviations of agility are coming from Cheeky.

My hunter shows 708 agi on character sheet but 714 in your calc in the same gear.

708 - 170(Base Agility from character sheet) = 538 / 1.15 = 467.something - adding my gear up by hand you would get 468.

468+153(base agi shown for Draenei in spreadsheet) = 621 * 1.15 = 714.somthing - The number that shows up in the spreadsheet.

Pulling base agi of a non surv spec Draenei hunter from Armory their base agility is 148 which multiplied by 1.15 = 170.2

My apologies to any mods that saw my 8billion edits of this and so on, less math at 1am helps.




Hunters used for comparison: my hunter, Ephe of Cenarius(Survival) and Fallendevil of Cenarius(Non-Survival no LR)

 

Cheeky

I could very well have the base Agility for Draenei wrong. I'll see if I can find any other evidence of this. Thanks!

Cheeky of Havoc

 

Thalestris

I posted about it some time ago, I'll try to find the post again.

edit:
here Hunter Spreadsheets -- In development

 

dmacika

Mana Regen problem.

Just recently started using Cheeky's sheet and I was doing some fiddling around using different buff/food combinations. I noticed that the Mana Regen on the calculations tab only takes into account Gear and Viper. No place for buffs. So BoW, Sporefish and Mana Oil aren't affecting the Time to Mana Exhaustion on the Shot Rotation tab.

 

Lodi

4pc arena (9 sec multi-shot cooldown) - I'm trying to decide on dps talents for PVP, and it would be nice to have this included (the "10" is password-protected).

Also, Vengeful Gladiator's Waraxe wasn't a choice in the Weapon tab, although it fetched from armory.

 

Cheeky

You sure it wasn't in the pull down menu? I could have swore it was.

I'll get the 4-piece bonus done up next version.

Cheeky of Havoc

 

Tilethryn

Quick question Cheeky (or anyone, really): I was playing around with different gear sets on your spreadsheet, mostly comparing high-end bows with the Wolfslayer. As a 41/20 BM hunter following a 1:1 rotation, I was wondering if using a strict priority rotation (arcane/multi > steady shot) with, say, the Ancient Sin'Dorei Longbow would be better than an auto/steady rotation with the Wolfslayer. Long story short, when playing around with this, I noticed that even with the Wolfslayer a strict auto/steady is actually coming out as 25 dps better than the priority rotation on your sheet Cheeky. Why would that be? I double checked to make sure that sunder x 5 and FF were up on a target, and made sure that your default value (7700) is input on your sheet to be certain that it wasn't a 0 armor mob.

Am I misunderstanding the way your sheet compares dps compared to dmg until oom, perhaps? I was under the impression that dps is dps is dps, and time until oom is something the hunter needed to weigh into consideration and offset with consumables. Does your sheet actually calculate dmg until oom then divide by time until oom or am I missing something more obvious?

 

Cheeky

Multi-Shot and Arcane shot don't hit for that much more than Steady for a BM build. The advantages of a 2.7s weapons still win out, even using the bigger, more mana-inefficient shots and a slower bow.

Remember, weapon speed is the driving force behind good DPS.

Cheeky of Havoc

 

Scrummy

Question re-guarding the DST.

I have the Legionkiller atm and finally decided to run all my tests through your spreadsheet. Everything came out exactly like I expected... a friggin Kara Opera Event weapon does more damage than the Bristleblitz Striker I was looking at getting soon. I noticed however that by switching my current BT Rep trinket out with a DST the BS bow actually produced more damage, which made me happy until I realized that you have the current CD of DST set to 20 seconds (assuming I'm reading everything right.)

I was under the impression it was changed to a 45 second hidden CD with this latest patch? If not then looks like I will be rounding up alts for Gruul. I've looked everywhere to see if someone has an update on its current hidden CD (or hopefully lack of), just wondering if you knew anything before I waste gold paying repair bills from alt wipes .

 

Tilethryn

I understand the weapon speed bit, perhaps I was unclear though. Even when using the Wolfslayer an auto/steady rotation beat a priority rotation. Shouldn't arcane/multi in place of a steady when the respective shot is off CD beat a straight auto/steady rotation when wanting to eke out every last ounce of dps?

 

Cheeky

The DST cool down in the spreadsheet is user configurable. Change it to whatever you think you'd like to test and the equations should produce the expected up time. I have little faith in my ppm/cd numbers for the DST, which is why I allow them to be changed.

Check to make sure the spreadsheet is timing the specials correctly. There was a bug in earlier versions where the automatic rotations were ignoring the potential to clip the shot+2 Auto Shot by waiting too long to get a Special in before the current Auto Shot. This pushed back the start time for the next Steady Shot and led to clipping. It was fixed at some point when I redid the shot rotation buttons to how they are now. (The bug still exists for DST rotations.)

Other than that, check shot damages, total damage, and total time for the 2 rotations. There has to be some reason the numbers are coming out like they are. Do you have 4 piece T5 or T6, both of which greatly favor pure Auto:Steady rotations?

Cheeky of Havoc

 

Sienna

DST cooldown is not 45 seconds. I saw it proc twice in 30 seconds many times. 20 seconds sound more reasonable, although I'm not sure it's exactly 20.

 

Sorrugis

Do you have a WWS report for that?

All of mine are stating that the hidden cooldown is in fact 45 seconds.

 

Zediono

Here you go: Wow Web Stats

In case the link gets outdated:

21:13'01.828 Zediono gains Haste
21:13'21.859 Zediono gains Haste

20 sec cooldown at most it looks like

 

Romario

Will the new Battlemaster's trinkets (Battlemaster's Cruelty and Battlemaster's Determination) be added to the spreadsheet?

Not sure if I should get one of the Battlemaster's trinket. I got [Bloodlust Brooch] and [Tsunami Talisman] at the moment.

 

Cheeky

There are already supported as Cruelty and Determination as trinkets.

Cheeky of Havoc