WotLK DPS spreadsheet - Page 73

Shandara · 01/01/09, 5:05 PM

Originally Posted by King-Slide

I'm experiencing a strange problem with the spreadsheet. My "Haste to Cap" isn't calculated right. At the moment I selected some gear to sit at 286 Haste and the SS keeps telling me that Haste to Cap is 0. Is there a button to turn off serpent swiftness or anything similar? With Haste to Cap = 0 it weights haste much less than the other stats and keeps suggesting gear without haste. Could this be a msexcel 2k7 specific problem?

The haste to cap figure is how much haste you need to get SS down to below 1.5s. With 286 haste and buffs/talents you will be way below 1.5 seconds. Hence you don't need any more haste.

King-Slide · 01/01/09, 6:47 PM

I changed my gear to 0 Haste and this is what the Spreadsheet came up with:

(No Serpent Swiftness, only Quiver)

My belief was, that Haste Cap was somewhere over 500 Rating.

The second try without Raidbuffs resulted in the same 187 Rating for Cap and the last try with 0/5 IAotH and no Raidbuffs didn't change the Haste Cap either.

Esoth · 01/01/09, 11:05 PM

Originally Posted by Shandara

The haste to cap figure is how much haste you need to get SS down to below 1.5s. With 286 haste and buffs/talents you will be way below 1.5 seconds. Hence you don't need any more haste.

Your steady shot calculations use the haste for autoshot, which has averages for rapid fire and heroism/bloodlust. Is this used for the "haste to cap" calculation? I'm not sure that would be appropriate, since either rapid fire and/or heroism will cap you when active but have no effect when not.

Tzentch · 01/02/09, 12:55 AM

Hiya,

I've been looking for the Elixir of Accuracy (45 +hit) and couldn't see it in the list of available elixir buffs.

I'm hovering on the brink of being hitcapped and like to use the spreadsheet to work out gear/elixir/food combinations that yield the best dps while still maintaining the necessary hit cap.

I did a quick search in this thread and couldn't see a post about it so thought i would give a heads up.

Thanks
Tzentch

Cranch · 01/02/09, 3:11 AM

Use the Hand Adjust line near the bottom of the Gear page for now.

Sienna · 01/02/09, 3:36 AM

Can someone check how much crit you get from taking 5/5 master tactician as survival build? Using regular steady/explosive/auto rotation? I don't have excel installed right now so can't check this spreadsheet. But my spreadsheet is saying it gives 7% average crit, which is a lot better than what I expected. If this spreadsheet is not giving around the same, might be an error in modeling that. I remember checking old versions back in TBC and finding MT totally useless. They buffed it ofc but I remember seeing some threads about the new version being totally worthless as well, citing the spreadsheet.

SkyMonkey · 01/02/09, 4:41 AM

Does the alchemist's stone account for the 40% increased mana potion effect when using the "use a potion" setting? I was looking around for where the value of a mana pot is shown but couldn't find it. This certainly reduces viper uptime.

shermanc · 01/03/09, 12:27 AM

Okay. I've asked this in the Simple Question thread and did not receive any answer. On hindsight, I don't think my problem is as simple as what I had initially thought it would be.

My dilemma lies with deciding between 2 ranged weapons - the Drake mounted Crossbow and the Accursed Bow of the Elite.

Drake Crossbow
126.9 dps
29 agi
enchant heartseeker scope
improves crit rating by 26
increases ap by 56

Accursed Bow
129.6 dps
28 agi
enchant heartseeker scope
improves haste by 21
hit by 16
ap by 40

Given that my hit is capped, and my skills on both types of weapons is a max 400, it is obvious which is better. The problem lies in the fact that I'm a troll and is supposed to have +1% to crit chance for bows. Theoretically, that should made the bow better for me.

Using the Gear Planner in the Spreadsheet (it's the only thing in there which I think i know how to use), they tell me that my drake is better, but then i realise that it doesn't seem to include my racial trait.

I did test on heroic dummies. 10 min autoshots only to get this
On drake, 318 shots 22.6% crit 435.5dps
On accursed, 320 shots (i presume it's because of the haste difference), 20.6% crit 431.5 dps

Therefore, I hope that one can you can help me. Sorry if this is a very noobish question.

Garby · 01/03/09, 12:50 AM

Originally Posted by shermanc

Using the Gear Planner in the Spreadsheet (it's the only thing in there which I think i know how to use)

There's your problem. The Gear Planner is used only for basic comparisons. To properly answer your question, import your gear (assuming you did already; if you didn't change character names and server in the Overview tab), then, use the Gear tab, and switch out your bows there. That will provide you with the correct information.

Your question isn't terribly noobish; the spreadsheet can be very confusing to people who aren't used to it.

dragoonvengance · 01/03/09, 1:12 AM

Originally Posted by Sthellesta

Aspect of the Beast is currently bugged on live to give 21%(25.44% glyphed) pet AP instead of 10%(12% glyphed). The latest spreadsheet version calculates AotB in its bugged state. From what I've read, AotB will be fixed in the next patch.

That is my main question. Where did you see that at? I have been looking for information and have yet to see blizzard say it is bugged. Of course it defiantly seems to be.

Shandara · 01/03/09, 5:29 AM

Originally Posted by dragoonvengance

That is my main question. Where did you see that at? I have been looking for information and have yet to see blizzard say it is bugged. Of course it defiantly seems to be.

It has been silently 'fixed' on the PTR to not double-dip anymore which is the biggest sign it truly was a bug.

Varelse · 01/03/09, 8:49 PM

I searched the thread and couldn't find anything relating to this, but I do apologize if this is a question someone has already posed.

Using Excel on Mac OSX, I'm unable to run any of the macros, or importing or profile saving functions (this was also true for Cheeky's spreadsheet). I doubt there's a quick fix option in the actual writing of the spreadsheet, so the question is more to other Mac users who may have found better successes with these functions then I, could any tips please be shared?

Chul · 01/04/09, 3:48 AM

I wonder if this spreadsheet could use a Talent Planner page. There are numerous questions posed and it may be a good idea if one page listed a summary of that information rather than having to constantly chance talents and note DPS or uptime of various things.

For example, people used to put 5/5 in Frenzy for a while until we realised that 4/5 is sufficient. How many points is "sufficient" for Hunting Party? And so forth.

A simple page that "calculates" how good (or bad) some talents are would provide many of the answers to questions posed in many of the hunter threads.

Xoran · 01/04/09, 4:07 AM

What comes to my mind here is something I have been doing manually in the past: Drop/Take one point for all talents in question and note the dps difference. Maybe this could be automated. Calculate all differences and show a sorted list. This would certainly be nice as a quick reference.

Edit: Thinking about it a little further, maybe there could be two lists: a "+1 talent point" list listing and sorted by the dps gain, if you put one more point in this talent where applicable and a "-1 talent point" list for talents, where you actually have points spend, beginning with the least dps lost.

Recursion · 01/04/09, 6:35 AM

I'm really sorry if this has been asked before, but how do you change the rotation bit in the spreadsheet to cater for readiness refreshing the cd of BW and rapid fire?

So it'd be:
1 - Rapid fire
2 - BW
3 - Readiness
4 - Serpent sting
5 - Steady shot
.
.
.
n - BW and Rapid fire when it wears off