WotLK DPS spreadsheet - Page 171

Ainyi · 05/22/09, 5:55 AM

what i was wondering personally is why people with arrowsong got left out in the cold by the buff(srry if this question is in the wrong thread just wondering)

another thing i lost about 400dps in the new version of the spreadsheet while using the exact same best in slot gear for me (note while still staying hitcapped without having to gem for it), i also noticed i have 12more hitrating in that particular gear profile and can't seem to find where the hit rating is coming from while using the exact same gear

Grummy · 05/22/09, 11:49 AM

Quick analysis form Lilbitters numbers. Average time between procs of Precision Shots was 52.8578 seconds. Average number of steady shots (roughly calculated using an assumed SS time of 1.7s) to trigger the effect after a 45 second ICD is 12.52. Granted there are only 26 data points, this seems to support the 45 second ICD with a 10% proc rate chance.

The problem is that with a 10% proc rate, the uptime isn't very good. Consider an average SS time of 1.5 seconds, the average wait time following the ICD until the next proc is 10*1.5 = 15 seconds. So, Precision Shots triggers once a minute, resulting in an uptime of 25%, yielding an average gain of 150 AP. But, this is under an ideal situation in which you are only firing steady shot. Looking at some real data from my guild from optimal tank and spank type fights, steady shots are fired about once every 7 seconds. Therefore, the average time in a raiding environment to proc precision shots jumps from 15 seconds to 70 seconds. This yields an up time of ~13% and an average statistical gain of only ~78 AP. (Note: this was for a survival hunter, a BM hunter is going to get more use out of the set bonus because she fires SS more).

Feel free to verify my napkin math, I haven't had coffee yet and am still a little hung over.

Edited for readability.

Scrith · 05/22/09, 1:33 PM

88d is not able to import the gems on my belt properly (Seether on U.S. server Draenor).

arlen · 05/22/09, 1:57 PM

Originally Posted by Scrith

88d is not able to import the gems on my belt properly (Seether on U.S. server Draenor).

Noticed the same thing last night, couldn't figure out why I wasn't hit capped in the spreadsheet but was in the game.

Shandara · 05/22/09, 3:06 PM

Originally Posted by Scrith

88d is not able to import the gems on my belt properly (Seether on U.S. server Draenor).

This will be fixed next release, thanks for catching it.

Ainyi · 05/22/09, 8:11 PM

Shandara why does when i export all my saved profiles in 88C and try to import them into 88D the gear doesn't get imported aswell sending me back to do the whole thing over again (i do the data for the other hunters in my guild aswell)

Shandara · 05/23/09, 4:27 AM

Originally Posted by Ainyi

Shandara why does when i export all my saved profiles in 88C and try to import them into 88D the gear doesn't get imported aswell sending me back to do the whole thing over again (i do the data for the other hunters in my guild aswell)

I removed the Quiver and this broke the gear import.

On the positive side, I am currently revamping the whole export/import and profile thing so that removing or adding items doesn't break it. I'm also expanding the gear string export on the overview page so you can (if desired) export a whole profile (that is gear, buffs, talents, pet, etc.. the whole shebang).

killinggame · 05/23/09, 4:35 AM

Fist time post - not sure if this has already been pointed out but it looks like Veranus' bane's damage has not been updated unlike the other 226+ ilvl ranged weps in the May 19th version. (I use it as it seems better than my 219 - its base dps did recieve the upgrade and it is currently at 187.1 dps (401 to 684 dam @ 2.9)

I think this is the case because in an older version it shows the gun as around a 15dps downgrade under my setup and this is pretty much the same on the most recent may 19th version despite the significant buff to its base damage.

P.S. To the authors and contributors to this sheet - this is a very powerful and helpful tool. Your hard work is appreciated. Thanks very much.

Nyutu · 05/23/09, 8:49 PM

X-Bow from Yoggy 10 man normal mode isn´t in the spreadsheet
[Deliverance]

Heuristic · 05/24/09, 1:46 AM

It seems Magnetized Projectile Emitter, from Deconstructor 10-man hard mode, has not yet been updated in the latest upload. Its current in-game (ilvl232) stats are:

415-708 damage, 3.00 speed (187.1dps),
+29agi,
+30stam,
red socket (+8AtkP socket bonus),
+27hit,
+66AtkP.

There may have been some confusion, since this gun was upgraded from ilvl226 to ilvl232 and furthermore received the ilvl226+ ranged weapon white dps buff. Its in-spreadsheet stats are 339-631 damage, 3.0 speed (161.67dps). The rest of the stats are accurate.

Also, is it possible to use the Gear Planner with Custom Gear? At least for ranged weapons, the custom item's calculated DPS contribution is 0 and cannot be used to calculate meaningful dps deltas. Looks like a case of NYI, so could this be added to your list of things to implement?

Thanks, and thank you for your dedication in maintaining this invaluable tool.

Shandara · 05/24/09, 3:20 AM

The new stats for the Projector and the Yogg xbow will be in the next release.

The Gear Planner is currently not showing the custom ranged weapon (I had disabled this in a previous version to fix some errors). I will remedy this.

♦ arison · 05/24/09, 2:31 PM

This spreadsheet is very handy -- thanks for maintaining it!

One thing that I find myself doing is copying lists of gear improvements from the Gear Planner tab and constructing my own personal priority list -- basically what gear provides the biggest bang for the buck, so I can prioritize spending epgp, buying mats, etc. It would be very convenient to me (and I imagine others) if any item that was a dps upgrade were inserted into a separate list of items, sorted by dps, but disregarding slot (or perhaps listing slot as a column). Basically turning the per-slot planning section also into a wishlist creator of (item name, slot, dps increase) entries.

Shandara · 05/24/09, 3:14 PM

I've finished revamping the export/import and profile saving (plus some misc fixes to things that popped up in this thread).

I've decided to release it as a 'beta' version for now, so hopefully people can comment on it. Basically, the profile/buffs/talent/export all store the data in the same way now (instead of each their own routine) which makes making changes afterwards easier to coordinate. Also on import/load any values that are not defined are ignored and just let be, so when I remove/add a new gear slot or gem socket it doesn't break upon importing an older version. Every value that's stored is stored by name as well, so moving talents around or change a buff it doesn't break everything.

The main idea is that it should put an end to people's woes of older versions not being imported properly. You can also now export/import a complete profile on the Overview page and/or import/export parts of it by choice.

The rotation test has gained some features. The most notable is that it doesn't work for a number of shots, but a length of time now. The usage of kill shot is now also tied to this time (so the last 20% of the simulated rotation Kill Shot is used, rather than either on or off). Improved Steady Shot now also works the same as Lock & Load in the test.

You can get it here

EDIT:
For now you can import the old gear strings, but not import any complete export of old profiles. Just to clarify. I'm not sure whether I can provide a meaningful conversion of the old exported profiles to the new ones, since the format is completely different.

The10 · 05/24/09, 5:48 PM

Originally Posted by Shandara

The usage of kill shot is now also tied to this time (so the last 20% of the simulated rotation Kill Shot is used, rather than either on or off).

I think 20% of the time is improper and will overvalue KS-Glyph, because most (if not all) raid-targets go down faster once they hit the 20% mark (Kill Shot, Execute, Drain Soul, etc.). I have no suggestions though..

OT: Thanks for your work Shandara!

Shandara · 05/24/09, 6:09 PM

Originally Posted by The10

I think 20% of the time is improper and will overvalue KS-Glyph, because most (if not all) raid-targets go down faster once they hit the 20% mark (Kill Shot, Execute, Drain Soul, etc.). I have no suggestions though..

OT: Thanks for your work Shandara!

I'll add a setting so you can adjust it to whatever you want.