Ainyi

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

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

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

 

arlen

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

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

WotLK Hunter DPS Spreadsheet

 

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)

 

Shandara

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).

WotLK Hunter DPS Spreadsheet

 

killinggame

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

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

 

Heuristic

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

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.

WotLK Hunter DPS Spreadsheet

 

◊ arison

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

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.

WotLK Hunter DPS Spreadsheet

 

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!

 

Shandara

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

WotLK Hunter DPS Spreadsheet

 

ankah

I am getting an error as soon as I try to load from armory, or even change the profession to lets say, skinning(with everything staying as it's downloaded).

When trying to do anything, I get a run time error 13. The beta version.

 

Timbosabi

Thanks for finishing the spread sheets im kind of new to the community and this stuff has helped me alot. My dps has gone way up.

 

• Varance

I get the same thing, lots of #VALUE! after loading from armory or a saved profile with runtime 13s any time I try to calculate shot rotation or attributes (due to #VALUE!).

Edit: I tracked this error to the latency value on the shot rotation tab - it was saved as 0,2 (0 comma 2) in the preset profiles, so the spreadsheet appears to break upon first calculation. Just change this to an actual value and resave the profile to fix the problem.

V V V

 

Nyutu

Right now It's working for me, deliverance is working and It is showing as expected being ahead of avalanche. And everyhing else works while loading from armory to me.

Also magnetized (10 man hard mode deconstructor) is working as expected.

 

• Varance

The problem probably has to do with an older US-regional version of Excel not seeing a decimal comma as a decimal point, interpreting it as a text value instead of numerical.

 

Shandara

I'll solve this in a way I've meaning to do for a while, by setting latency in ms instead of seconds.

WotLK Hunter DPS Spreadsheet

 

hotmetal

On the spreadsheet, [Chestguard of the Lasher] is categorized under "Leather"
when its actually a mail item. Thought i was going mad when i disabled Leather and Hardmode
items from displaying.

 

baklava

There is a little issue with the spreadsheet;

1-) When one tries to put hit socket on one hand weapons, it does count as Crit. on the second spot.
2-) Bloodfury and Rapidfire creates problem when one tries to put them on the rotation at the last 3-4 positions. (7. 8. 9. 10.)

 

Chasim

I posted this awhile back:

There was only one response which, although appreciated, just explained about the pet hit cap (which is not what I was asking about).

With 88d, I still have 278 hit and the "Hunter Hit +1" is 1.597? It seems like that figure should be much lower because other stats are far more valuable once the hit cap is reached. (Also, hit "For Pet" still shows "0".)

 

GwolfGarona

I rephrased this question a few pages back, and the answer I received is when Assume 100%hit is set to NO then the spreadsheet still values Hit highly for gear planner to ensure you stay at 100% when you change a single item. To counter this set Assume 100% hit to Yes and then it will value Hit in relation to current hit cappedness and assume you will change gems if an upgrade drops your hit.