WotLK DPS spreadsheet - Page 229

Shandara · 08/24/09, 5:06 PM

Originally Posted by zybron

Hmm...I seem to still be having protected cell issues.

I've just downloaded the sheet myself from the first page, entered your details and imported from Armory (rather than use my local copy). It worked on all your unknown items.

Which cells are protected and giving you problems? Which Excel version do you use? Could you perhaps upload it somewhere for me? Also, if you can, check whether you really have the latest version (clear browser cache etc.. before downloading).

Lactose · 08/24/09, 5:08 PM

Incorrect stats on [Boundless Gaze].
Currently has 112 AP in the spreadsheet, should have 224.

Moshi · 08/25/09, 4:57 AM

I'm trying to observe the effects of Chimera shot and Aimed shot glyphs on the rotation test tab for an ArP heavy build that drops Arcane shot. Whenever I change the glyphs on the talent sheet and run the rotation test I see gains/losses in DPS, however when observing the rotation nothing changes. I'm using this priority:

Chimera > Aimed > Steady.
It will always go Chimera, Aimed, SS x 4, repeat on both tests.

In my dummy tests with Chimera glyph a gap begins to form between Chimera and Aimed. The only way to remedy this gap is to delay Chimera by making sure 4 Steadies are cast in between the last Aimed and next Chimera; however this effectively renders that Chimera glyph useless because Chimera shot is delayed by a second unless you start using Steady shot in between Chimera and Aimed but the test doesn't model this. With Aimed glyph the shot comes off cool down at the same time as Chimera and because Aimed shot is prioritized after Chimera shot it also makes that glyph useless. I tried using Glyph of Kill Shot/Glyph of the Hawk to see if I gain DPS from the rotation test as Chimera/Aimed glyphs weren't doing anything to it, it turned out to be a DPS loss in comparison to having Chimera (even when it doesn't do anything to the rotation).

The shot frequencies are the same in both tests, shots in total are the same, everything. I can't figure out how the average DPS is changing when the tests are exactly the same with each glyph. Is there something I have missed?

Shandara · 08/25/09, 5:14 AM

You might want to fiddle with the setting on how long the sheet can wait for a shot to get off CD (it's on the rotation test tab).

Most likely it's waiting too long for a shot (which creates a big gap) or not long enough at all (which makes the glyph useless).

Moshi · 08/25/09, 5:44 AM

Originally Posted by Shandara

You might want to fiddle with the setting on how long the sheet can wait for a shot to get off CD (it's on the rotation test tab).

Most likely it's waiting too long for a shot (which creates a big gap) or not long enough at all (which makes the glyph useless).

That seems to be it, thanks. Was still odd though because it was set to 0.8 seconds when Aimed would have still had a 1 second cool down without factoring the time from latency after the global cool down from the Chimera. I guess I'll keep fiddling around with it.

Alduin · 08/25/09, 11:31 AM

Have there been any changes to Improved Hawk? I just get half of the proccs (values are the same but 36,7% uptime in v91e to 70% uptime in 91c is pretty strange).

Ktharsis · 08/25/09, 1:55 PM

When downloading a new version of the spreadsheet, is there a way to import old profiles, settings, etc., or does everything have to be restarted from scratch?

• promdates · 08/25/09, 2:31 PM

You can either do the mass-export option (which I noticed didn't work a build or two ago, or maybe I had messed up), or the individual export option. Go to the overview tab and you should see a giant blank white box towards the bottom, with a bunch of check tabs and options next to it. Click "Everything" and press export. Copy/paste the string that appears. To import, do the same but put that string in the box, click everything and then press import.

The mass-export/import is at the top of the overview page near the Character box, should say something like "Export to Bin"/"Import from Bin" or something similar.

Axejess · 08/25/09, 3:47 PM

I think the calculate dps thingie is a bit broken in 91e. Every time I push it it tells me that I should regem my trinkets
How can I regem a wrathstone and a Greatness trinket?

Fixed when I setted the option not to take dragon's eye's the suggestion went gone.

Maybe you should put in the first page to not forget this option set to no when you don't have JC.

hotmetal · 08/26/09, 2:21 AM

Originally Posted by Shandara

I've already taken along the very recently tested t9 2-set bonus crit damage bonus for the next version. The current version still has our previous understanding of how it works (trust me I do read all the other threads).

Update:

- T9 2-set bonus only crits for spell-crit bonus damage (i.e. 50% instead of 100%), not affected by Mortal Shots

For 3.2.2:

World of Warcraft - English (NA) Forums -> PTR Patch 3.2.2 Notes

* Hunter Tier-9 2-Piece Bonus: Critical damage from Serpent Sting will now work properly with the Mortal Shots and Expose Weakness talents.

Edit:
3.3.2 -> 3.2.2

Difool · 08/26/09, 10:43 AM

Originally Posted by Axejess

Fixed when I setted the option not to take dragon's eye's the suggestion went gone.

Maybe you should put in the first page to not forget this option set to no when you don't have JC.

If I could make a enhancement suggestion to either set primary skills on the overview tab, or to load them from armory on the gear tab and then switch that gemming option off these values.

Bluesfear · 08/26/09, 10:48 AM

Is there a easy way to convert the gear from horde to alliance or vice-versa or do you have to go through the drop down list one by one and figure it out on your own?

I see the horde and alliance option under gear planner, but that didn't seem to help.

Ossian666 · 08/26/09, 10:58 AM

Is the t8 4pc bonus working properly? I input a 245 that I received last night to test if losing that set bonus was worth swapping the gear out and it seemed like there was a significant increase in DPS. I figured it may be close, so I wanted to double check before I gemmed this bad boy for raiding tonite.

Drakbak · 08/26/09, 11:37 AM

I finally thought of a good way how to model procs from the ArP trinkets. In prior posts I had commented that taking the Average ArP values was a poor way to model the procs because of the way ArP works with increasing returns. Anyway, at the time I had concluded that the only way someone could really calculate the trinket effects was to calculate the full DPS with & without the proc, create ratios based on trinket Uptime, and apply that ratio to the DPS (sorry if that's confusing). That method would have been very hard to implement, and I noted as much.

However, I have come up with a very similar means to achieve the same thing. Basically, instead of calculating total DPS with and without proc, you're calculating the damage mitigation from armor with and without proc. You then create a ratio utilizing those values and apply it as a %increase in DPS to affected shots. It's still a little mathy, but fairly easy to implement, i think. I even worked out for events such as when both Grim Toll & Mjolnir's Runestone proc.

http://spreadsheets.google.com/ccc?k...jM1JoWWc&hl=en

That's a spreadsheet with the calculations I made to work this out. This solution should be fairly easy to implement and ought to give a much better approximation as to how much DPS these things are kicking out. The only problem it might incur is that it would be difficult to use them with the Gear Planner since they use a ratio instead of static stats or DPS values.

• VRoscioli · 08/26/09, 11:49 AM

Originally Posted by Drakbak

I finally thought of a good way how to model procs from the ArP trinkets.

I had been thinking about a method like this for a while. However, you would also have to factor in things like what ratio of our damage is affected by armor penetration. I feel like I had thought of something that became a showstopper problem to modeling this in this manner, but it isn't coming to mind right now.

[e] Now that I think about it, the problem may have been the problem in calculating values for the gear planner that you mentioned. However, my understanding is that the gear planner now actually tries each piece, rather than just giving a value based on stat weightings. If so, this would no longer be a problem.